[Wed May 01 11:32:11 papicella@:~/sqlfire/vFabric_SQLFire_11_b40332/pasdemos/sqlfire ] $ sqlf sqlf version 10.4 sqlf> connect peer 'bind-address=localhost;mcast-port=12333;host-data=false' as peerClient; sqlf> explain select * from emp where deptno = 20; MEMBER_PLAN -------------------------------------------------------------------------------------------------------------------------------- ORIGINATOR 192.168.14.167(73118)<v6>:61492 BEGIN TIME 2013-05-01 11:32:39.735 END TIME 2013-05-01 11:32:39.777 DISTRIBUTION to & Slowest Member Plan: member 192.168.14.167(72048)<v1>:42223 begin_execution 2013-05-01 11:32:39.74 end_execution 2013-05-01 11:& Fastest Member Plan: member 192.168.14.167(72048)<v1>:42223 begin_execution 2013-05-01 11:32:39.74 end_execution 2013-05-01 11:& 3 rows selected sqlf> select STMT_ID, STMT_TEXT from SYS.STATEMENTPLANS; STMT_ID |STMT_TEXT --------------------------------------------------------------------------------------------------------------------------------------------------------------------- 00000001-ffff-ffff-ffff-000400000016| select * from emp where deptno = <?> 1 row selected sqlf> explain '00000001-ffff-ffff-ffff-000400000016'; stmt_id 00000001-ffff-ffff-ffff-000400000016 SQL_stmt select * from emp where deptno = <?> begin_execution 2013-05-01 11:32:39.735 end_execution 2013-05-01 11:32:39.777 QUERY-SCATTER execute_time 0.0 ms QUERY-SEND RESULT-RECEIVE SEQUENTIAL-ITERATION (0.38%) execute_time 0.136 ms returned_rows 5 no_opens 1 RESULT-HOLDER returned_rows 5 no_opens 1 DISTRIBUTION-END (99.61%) execute_time 35.073 ms returned_rows 5 member 192.168.14.167(72048)<v1>:42223 begin_execution 2013-05-01 11:32:39.74 end_execution 2013-05-01 11:32:39.774 QUERY-RECEIVE RESULT-SEND RESULT-HOLDER returned_rows 5 no_opens 1 ROWIDSCAN (1.71%) execute_time 0.148 ms returned_rows 5 no_opens 1 node_details EMP : CONSTRAINTSCAN (98.28%) execute_time 8.482 ms returned_rows 5 no_opens 1 scan_qualifiers None scanned_object APP.6__EMP__DEPTNO:base-table:APP.EMP scan_type node_details WHERE : ((DEPTNO = CONSTANT:20) and true)
Search This Blog
Wednesday, 1 May 2013
Explain Plan in vFabric SQLFire improved
With the recently released vFabric SQLFire 11 version the query execution plan is much easier to read then previously. An example below.
Subscribe to:
Post Comments (Atom)
2 comments:
You can even do this from a client connection rather then a peer connection as shown below.
sqlf> connect client 'localhost:1527';
sqlf> maximumdisplaywidth 2000;
sqlf> explain select * from emp where deptno = 20;
This is cool!
Post a Comment