2014-07-03T19:03:48.5980 (6599:0x7f10c15a9228) EXECUTE_STATEMENT_FINISH
        oltp30 (ATT_166, SYSDBA:NONE, NONE, TCPv4:192.168.43.62)
        C:\1INSTALL\FB25SNAP\bin\isql.exe:1696
                (TRA_293036, CONCURRENCY | NOWAIT | READ_WRITE)

Statement 774851:
-------------------------------------------------------------------------------
execute block returns( invoice_id bigint, total_lines int, total_invoice_qty int, total_invoice_purchase numeric(12,2) )
as begin
    if ( exists( select * from v_qdistr_ord_sup ) ) then
    begin
      select
         min(p.doc_list_id) stock_order_id,
         count(*) total_lines,
         sum(p.qty) total_invoice_qty,
         sum(p.purchase) total_invoice_purchase
      from sp_supplier_invoice p 
      into invoice_id, total_lines, total_invoice_qty, total_invoice_purchase;
      suspend;
   end
end
1 records fetched
  67529 ms, 264 write(s), 67487 fetch(es), 6653 mark(s)

Table                             Natural     Index    Update    Insert    Delete   Backout     Purge   Expunge
***************************************************************************************************************
RDB$DATABASE                            2
RDB$INDICES                                       1
TMP$SHOPPING_CART                      12         1         1        11
TMP$RESULT_SET                        765                           255
Z_USED_VIEWS                                     13
OPTYPES                                          27
RULES_FOR_QDISTR                       91        11
DOC_LIST                                         23        11         1
DOC_DATA                                       2904                  11
QDISTR                                         1592       535       255       255                           122
QSTORNED                                        255       255       255
DOC_STATES                                        1
INVNT_TURNOVER_LOG                               13                  11
PERF_LOG                                          3         3         3

2014-08-04T13:47:40.1200 (18377:0x7f3ca4739300) EXECUTE_ SINGLE _STATEMENT_FINISH
        oltp30 (ATT_1834, SYSDBA:NONE, NONE, TCPv4:192.168.43.96)
        C:\MIX\firebird\fb25\bin\isql.exe:2332
                (TRA_161283, CONCURRENCY | WAIT | READ_WRITE)

 Unit: MY_POOR_PROCEDURE, row: 150, col: 10 
-------------------------------------------------------------------------------
select count(*) from tsour into n
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Select Expression
    -> Table "TSOUR" Full Scan
0 records fetched
 12518 ms, 109217 read(s), 15802049 fetch(es)

Table                             Natural     Index    Update    Insert    Delete   Backout     Purge   Expunge
***************************************************************************************************************
TSOUR                             4999850


. . . . . . . .

2014-08-04T13:47:52.1360 (18377:0x7f3ca4739300) EXECUTE_ SINGLE _STATEMENT_FINISH
        oltp30 (ATT_1834, SYSDBA:NONE, NONE, TCPv4:192.168.43.96)
        C:\MIX\firebird\fb25\bin\isql.exe:2332
                (TRA_161283, CONCURRENCY | WAIT | READ_WRITE)

 Unit: MY_POOR_PROCEDURE, row: 156, col: 10 
-------------------------------------------------------------------------------
insert into ttarg(id, s01) select id, s01 from tsour
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Select Expression
    -> Table "TSOUR" Full Scan
0 records fetched
 15418 ms, 1217 read(s), 217255 write(s), 158022049 fetch(es), 35807862 mark(s)

Table                             Natural     Index    Update    Insert    Delete   Backout     Purge   Expunge
***************************************************************************************************************
TSOUR                             4999850
TTARG                                                           4999849             4999849