[repository1]
dbserver01:5432
begin:
2015-03-10 00:00
end:
2015-03-11 00:00



repository1

dbserver01:5432

repository2

dbserver02:5432


Report Overview

Database system identifier6124488995257552289
Host namedbserver01
Port ID5432
PostgreSQL version9.4.1
Begins at2015-03-10 16:13:00
Ends at2015-03-10 17:13:00
Period01:00:00
Database size1055 MiB
Number of commits16532
Number of rollbacks64

Alerts

TimeMessage
2015-03-10 16:44:00load average 1min exceeds threshold in snapshot '2015-03-10 16:44:00' --- 7.19 (threshold = 7)
2015-03-10 17:08:00load average 1min exceeds threshold in snapshot '2015-03-10 17:08:00' --- 8.09 (threshold = 7)

Statistics

Databases Statistics

DatabaseMiB+MiBCommit/sRollback/sHit%Gets/sReads/sRows/s
dbt21054334.5920.01895.1828.51940.425772.807

Transactions

Database Size

Recovery Conflicts

DatabaseOn tablespacesOn locksOn snapshotsOn bufferpinsOn deadlocks
dbt200000

Instance Statistics

Write Ahead Logs

Total size (MiB)1353.734
Average output rate (MiB/s)0.376
Number of archived files84
Number of archiving errors0
Latest WAL file0000000100000000000000CF
Last archived file0000000100000000000000CD

Backend States Overview

idle (%)idle in xact (%)waiting (%)running (%)
65.20.12.332.5

Backend States

OS Resources

CPU and Memory

CPU Usage

Load Average

Memory Usage

Disks

Disk Usage per Tablespace

TablespaceLocationDeviceUsed (MiB)Avail (MiB)Remain (%)
<pg_xlog_archive>/home/statsinfo/var/archivelog8:211726729438.3
pg_default/home/statsinfo/var/pgdata8:211726729438.3
pg_global/home/statsinfo/var/pgdata8:211726729438.3

Disk Usage per Table

DatabaseSchemaTableSize (MiB)Table readsIndex readsToast reads
dbt2publiccustomer18354125151600
dbt2publicstock34747888101530
dbt2publicorders1971959430
dbt2publicorder_line282308926840
dbt2publicitem1045242290
dbt2publicnew_order4515580
dbt2publichistory257000
dbt2publicwarehouse0670
dbt2publicdistrict0200

I/O Usage

Device nameContaining table spacesReadWriteAverage I/O queueTotal I/O time (ms)
Total bytes (MiB)Peak rate (KiB/s)Total time (ms)Total bytes (MiB)Peak rate (KiB/s)Total time (ms)
sda2{<pg_xlog_archive>,pg_default,pg_global}32142766.401010285271927156.0016725652055.500177375832

Toggle I/O Rate Graph

Toggle I/O Peak Rate Graph

Toggle I/O Time Graph

Activities

Notable Tables

Heavily Updated Tables

DatabaseSchemaTableINSERTUPDATEDELETETotalHOT (%)
dbt2publicorder_line7159661831013342775.2
dbt2publicstock0715960715960.0
dbt2publicdistrict01348201348299.8
dbt2publicorders6801650001330180.5
dbt2publicnew_order680206410132120.0
dbt2publiccustomer01317801317822.0
dbt2publichistory66780066780.0
dbt2publicwarehouse0667806678100.0
dbt2publicitem00000.0

Heavily Accessed Tables

DatabaseSchemaTableSeq scanSeq tup readTup per seqHit ratio (%)
dbt2publicwarehouse206992016209.741100.0

Low Density Tables

DatabaseSchemaTableTuplesLogical pagesPhysical pagesL/P ratio (%)
dbt2publicstock999995416674449293.7
dbt2publichistory3067923163329596.0
dbt2publicitem1000001235128196.4
dbt2publiccustomer300000230772342498.5
dbt2publicorder_line2920012360503612199.8
dbt2publicorders30683325572481103.1

Table Fragmentations

DatabaseSchemaTableColumnCorrelation
dbt2publicwarehousew_id-0.086
dbt2publicorderso_c_id-0.007
dbt2publiccustomerc_first0.000
dbt2publiccustomerc_last0.002
dbt2publicorder_lineol_o_id0.009
dbt2publicstocks_quantity0.011
dbt2publiccustomerc_id0.012
dbt2publiccustomerc_id0.012
dbt2publicorderso_id0.019
dbt2publicorder_lineol_number0.093
dbt2publicstocks_i_id0.096
dbt2publicdistrictd_id0.125
dbt2publicnew_orderno_o_id0.156
dbt2publicnew_orderno_d_id0.188
dbt2publicorderso_d_id0.195
dbt2publicorderso_d_id0.195
dbt2publiccustomerc_d_id0.199
dbt2publiccustomerc_d_id0.199
dbt2publicorder_lineol_d_id0.212
dbt2publicdistrictd_w_id0.368
dbt2publicnew_orderno_w_id0.914

Query Activity

Functions

DatabaseSchemaFunctionCallsTotal time (ms)Self time (ms)Time/call (ms)
dbt2publicnew_order67954373175.3674373175.367643.587
dbt2publicpayment66772409754.6912409754.691360.904
dbt2publicdelivery650540961.861540961.861832.249
dbt2publicstock_level613284760.145284760.145464.535
dbt2publicorder_status597282199.495282199.495472.696
dbt2publicmake_new_order_info1019254285.8064285.8060.042

Statements

UserDatabaseQueryCallsTotal time (sec)Time/call (sec)
statsinfodbt2FETCH ALL IN mycursor68374403.6860.644
statsinfodbt2SELECT payment(?, ?, ?, ?, ?, ?, ?)66952418.2820.361
statsinfodbt2SELECT delivery(9, 10)653542.3430.831
statsinfodbt2SELECT stock_level(?, ?, ?)614284.8520.464
statsinfodbt2SELECT * FROM order_status(?, ?, ?, ?)599282.5900.472
statsinfodbt2SELECT c.oid AS relid, c.relnamespace, c.reltablespace, c.relname, c.reltoastrelid, x.indexrelid AS reltoastidxid, c.relkind, c.relpages, c.reltuples, c.reloptions, pg_relation_size(c.oid), pg_stat_get_numscans(c.oid) AS seq_scan, pg_stat_get_
display full query string
6030.7280.512
statsinfodbt2
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), datname, numbackends,
       xact_commit, xact_rollback, blks_read, blks_hit, tup_returned,
       tup_fetched, tup_inserted, tup_updated, tup_deleted
FROM pg_stat_database
display full query string
6024.8860.415
statsinfodbt2
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), a.schemaname, a.relname,
       seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd,
       n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read,
       heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read,
display full query string
6024.5270.409
statsinfodbt2
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), a.schemaname, a.relname,
       a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read,
       idx_blks_hit
FROM pg_stat_all_indexes a, pg_statio_all_indexes b
display full query string
6024.4340.407
statsinfodbt2CLOSE mycursor68371.7810.000
statsinfodbt2
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), relname, pid, mode, granted
FROM pg_locks, pg_class
WHERE relfilenode = relation
ORDER BY relname;
display full query string
600.7750.013
statsinfodbt2
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), datname, pid, usesysid,
       usename, application_name, client_addr, client_port, backend_start,
       xact_start, query_start, waiting, query
FROM pg_stat_activity
display full query string
600.7470.012
statsinfodbt2BEGIN154580.4310.000
statsinfodbt2COMMIT153940.3380.000
statsinfodbt2SELECT a.attrelid, a.attnum, a.attname, format_type(atttypid, atttypmod) AS type, a.attstattarget, a.attstorage, a.attnotnull, a.attisdropped, s.stawidth as avg_width, s.stadistinct as n_distinct, CASE WHEN s.stakind1 = ? THEN s.stanumbers1[?]
display full query string
600.1780.003
statsinfodbt2SELECT i.oid AS indexrelid, c.oid AS relid, i.reltablespace, i.relname AS indexrelname, i.relam, i.relpages, i.reltuples, i.reloptions, x.indisunique, x.indisprimary, x.indisclustered, x.indisvalid, x.indkey,
display full query string
600.1410.002
statsinfodbt2SELECT s.funcid, n.oid AS nspid, s.funcname, pg_get_function_arguments(funcid) AS argtypes, s.calls, s.total_time, s.self_time FROM pg_stat_user_functions s JOIN pg_namespace n ON s.schemaname = n.nspname WHERE n.nspname <> ALL ((? || $1 || ?)::t
display full query string
600.0640.001
statsinfodbt2DECLARE mycursor CURSOR FOR SELECT new_order(8, 10, 2479, 1, 10, make_new_order_info(7934, 8, 10), make_new_order_info(69590, 8, 8), make_new_order_info(40368, 8, 6), make_new_order_info(1920, 8, 10), make_new_order_info(81844, 8, 7), make_new_order_info(4
display full query string
10.0010.001

Plans

Query ID User Database Plan count Calls Total time (sec) Time/call (sec) Block read time (ms) Block write time (ms)
Query (child row)
Plan details (child row)
9142721statsinfodbt21600.7470.0120.0000.000
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), datname, pid, usesysid,
       usename, application_name, client_addr, client_port, backend_start,
       xact_start, query_start, waiting, query
FROM pg_stat_activity
display full query string
Plan IDCallsTotal time (sec)Time/call (sec)Block read time (ms)Block write time (ms)First callLast call
Plan (child row)
2400835002600.7470.0120.0000.0002015-03-10 16:13:262015-03-10 17:12:41
Nested Loop  (cost=1.15..2.69 rows=1 width=261)
  ->  Hash Join  (cost=1.02..2.41 rows=1 width=201)
        Hash Cond: (s.usesysid = u.oid)
        ->  Function Scan on pg_stat_get_activity s  (cost=0.00..1.00 rows=100 width=137)
        ->  Hash  (cost=1.01..1.01 rows=1 width=68)
              Buckets: 1024  Batches: 1  Memory Usage: 1kB
              ->  Seq Scan on pg_authid u  (cost=0.00..1.01 rows=1 width=68)
  ->  Index Scan using pg_database_oid_index on pg_database d  (cost=0.13..0.27 rows=1 width=68)
        Index Cond: (oid = s.datid)
259851661statsinfodbt216024.8860.4150.0000.000
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), datname, numbackends,
       xact_commit, xact_rollback, blks_read, blks_hit, tup_returned,
       tup_fetched, tup_inserted, tup_updated, tup_deleted
FROM pg_stat_database
display full query string
Plan IDCallsTotal time (sec)Time/call (sec)Block read time (ms)Block write time (ms)First callLast call
Plan (child row)
26773764446024.8860.4150.0000.0002015-03-10 16:13:262015-03-10 17:12:47
Seq Scan on pg_database d  (cost=0.00..1.09 rows=2 width=68)
1150882013statsinfodbt216024.4340.4070.0000.000
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), a.schemaname, a.relname,
       a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read,
       idx_blks_hit
FROM pg_stat_all_indexes a, pg_statio_all_indexes b
display full query string
Plan IDCallsTotal time (sec)Time/call (sec)Block read time (ms)Block write time (ms)First callLast call
Plan (child row)
20182864606024.4340.4070.0000.0002015-03-10 16:13:262015-03-10 17:12:47
Nested Loop Left  (cost=29.18..50.96 rows=6 width=200)
  Join Filter: (n.oid = c.relnamespace)
  ->  Nested Loop  (cost=29.18..49.21 rows=6 width=140)
        Join Filter: (x.indexrelid = i.oid)
        ->  Nested Loop  (cost=29.03..45.38 rows=12 width=80)
              ->  Hash Join  (cost=28.89..42.66 rows=12 width=76)
                    Hash Cond: (c_1.oid = x_1.indrelid)
                    ->  Seq Scan on pg_class c_1  (cost=0.00..13.34 rows=84 width=8)
                          Filter: (relkind = ANY ('{r,t,m}'::"char"[]))
                    ->  Hash  (cost=28.34..28.34 rows=44 width=80)
                          Buckets: 1024  Batches: 1  Memory Usage: 14kB
                          ->  Hash Join  (cost=21.64..28.34 rows=44 width=80)
                                Hash Cond: (x_1.indexrelid = x.indexrelid)
                                ->  Seq Scan on pg_index x_1  (cost=0.00..5.64 rows=164 width=8)
                                ->  Hash  (cost=21.09..21.09 rows=44 width=72)
                                      Buckets: 1024  Batches: 1  Memory Usage: 13kB
                                      ->  Hash Join  (cost=14.39..21.09 rows=44 width=72)
                                            Hash Cond: (x.indrelid = c.oid)
                                            ->  Seq Scan on pg_index x  (cost=0.00..5.64 rows=164 width=8)
                                            ->  Hash  (cost=13.34..13.34 rows=84 width=72)
                                                  Buckets: 1024  Batches: 1  Memory Usage: 9kB
                                                  ->  Seq Scan on pg_class c  (cost=0.00..13.34 rows=84 width=72)
                                                        Filter: (relkind = ANY ('{r,t,m}'::"char"[]))
              ->  Index Only Scan using pg_class_oid_index on pg_class i_1  (cost=0.15..0.22 rows=1 width=4)
                    Index Cond: (oid = x.indexrelid)
        ->  Index Scan using pg_class_oid_index on pg_class i  (cost=0.15..0.31 rows=1 width=68)
              Index Cond: (oid = i_1.oid)
  ->  Materialize  (cost=0.00..1.09 rows=6 width=68)
        ->  Seq Scan on pg_namespace n  (cost=0.00..1.06 rows=6 width=68)
1366601918statsinfodbt21599282.5900.472279756.6810.000
SELECT * FROM order_status(?, ?, ?, ?)
Plan IDCallsTotal time (sec)Time/call (sec)Block read time (ms)Block write time (ms)First callLast call
Plan (child row)
46092690599282.5900.472279756.6810.0002015-03-10 16:12:292015-03-10 17:12:54
Function Scan on order_status  (cost=0.00..10.00 rows=1000 width=24)
1380877759statsinfodbt21600.7750.0130.0000.000
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), relname, pid, mode, granted
FROM pg_locks, pg_class
WHERE relfilenode = relation
ORDER BY relname;
display full query string
Plan IDCallsTotal time (sec)Time/call (sec)Block read time (ms)Block write time (ms)First callLast call
Plan (child row)
2236869949600.7750.0130.0000.0002015-03-10 16:13:262015-03-10 17:12:41
Sort  (cost=150.59..153.46 rows=1149 width=101)
  Sort Key: pg_class.relname
  ->  Hash Join  (cost=22.50..92.19 rows=1149 width=101)
        Hash Cond: (pg_class.relfilenode = l.relation)
        ->  Seq Scan on pg_class  (cost=0.00..12.16 rows=316 width=68)
        ->  Hash  (cost=10.00..10.00 rows=1000 width=41)
              Buckets: 1024  Batches: 1  Memory Usage: 6kB
              ->  Function Scan on pg_lock_status l  (cost=0.00..10.00 rows=1000 width=41)
1909903165statsinfodbt2166952418.2820.3611734804.4570.000
SELECT payment(?, ?, ?, ?, ?, ?, ?)
Plan IDCallsTotal time (sec)Time/call (sec)Block read time (ms)Block write time (ms)First callLast call
Plan (child row)
273449499866952418.2820.3611734804.4570.0002015-03-10 16:12:292015-03-10 17:12:58
Result  (cost=0.00..0.01 rows=1 width=0)
2023618306statsinfodbt21600.0640.0010.0000.000
SELECT s.funcid, n.oid AS nspid, s.funcname, pg_get_function_arguments(funcid) AS argtypes, s.calls, s.total_time, s.self_time FROM pg_stat_user_functions s JOIN pg_namespace n ON s.schemaname = n.nspname WHERE n.nspname <> ALL ((? || $1 || ?)::t
display full query string
Plan IDCallsTotal time (sec)Time/call (sec)Block read time (ms)Block write time (ms)First callLast call
Plan (child row)
2834312224600.0640.0010.0000.0002015-03-10 16:13:002015-03-10 17:12:00
Hash Join  (cost=2.33..112.39 rows=54 width=72)
  Hash Cond: (p.pronamespace = n_1.oid)
  ->  Seq Scan on pg_proc p  (cost=0.00..108.37 rows=162 width=72)
        Filter: ((prolang <> 12::oid) AND (pg_stat_get_function_calls(oid) IS NOT NULL))
  ->  Hash  (cost=2.31..2.31 rows=2 width=8)
        Buckets: 1024  Batches: 1  Memory Usage: 1kB
        ->  Hash Join  (cost=1.20..2.31 rows=2 width=8)
              Hash Cond: (n_1.nspname = n.nspname)
              ->  Seq Scan on pg_namespace n_1  (cost=0.00..1.06 rows=6 width=68)
              ->  Hash  (cost=1.18..1.18 rows=2 width=68)
                    Buckets: 1024  Batches: 1  Memory Usage: 1kB
                    ->  Seq Scan on pg_namespace n  (cost=0.00..1.18 rows=2 width=68)
                          Filter: ((nspname)::text <> ALL (('{pg_catalog, pg_toast, information_schema, statsinfo}'::cstring)::text[]))
2584918680statsinfodbt216030.7280.5120.0000.000
SELECT c.oid AS relid, c.relnamespace, c.reltablespace, c.relname, c.reltoastrelid, x.indexrelid AS reltoastidxid, c.relkind, c.relpages, c.reltuples, c.reloptions, pg_relation_size(c.oid), pg_stat_get_numscans(c.oid) AS seq_scan, pg_stat_get_
display full query string
Plan IDCallsTotal time (sec)Time/call (sec)Block read time (ms)Block write time (ms)First callLast call
Plan (child row)
19539199736030.7280.5120.0000.0002015-03-10 16:13:002015-03-10 17:12:00
HashAggregate  (cost=40.88..43.68 rows=28 width=133)
  ->  Hash Left Join  (cost=25.11..39.41 rows=28 width=133)
        Hash Cond: (c.reltoastrelid = x.indrelid)
        ->  Nested Loop Left  (cost=17.42..31.24 rows=28 width=129)
              ->  Hash Right Join  (cost=17.27..23.68 rows=28 width=125)
                    Hash Cond: (i.indrelid = c.oid)
                    ->  Seq Scan on pg_index i  (cost=0.00..5.64 rows=164 width=8)
                    ->  Hash  (cost=16.92..16.92 rows=28 width=121)
                          Buckets: 1024  Batches: 1  Memory Usage: 2kB
                          ->  Hash Left Join  (cost=1.14..16.92 rows=28 width=121)
                                Hash Cond: (c.relnamespace = n.oid)
                                Filter: ((n.nspname)::text <> ALL (('{pg_catalog, pg_toast, information_schema, statsinfo}'::cstring)::text[]))
                                ->  Seq Scan on pg_class c  (cost=0.00..12.95 rows=84 width=121)
                                      Filter: (relkind = ANY ('{r,t}'::"char"[]))
                                ->  Hash  (cost=1.06..1.06 rows=6 width=68)
                                      Buckets: 1024  Batches: 1  Memory Usage: 1kB
                                      ->  Seq Scan on pg_namespace n  (cost=0.00..1.06 rows=6 width=68)
              ->  Index Only Scan using pg_class_oid_index on pg_class t  (cost=0.15..0.26 rows=1 width=4)
                    Index Cond: (oid = c.reltoastrelid)
        ->  Hash  (cost=5.64..5.64 rows=164 width=8)
              Buckets: 1024  Batches: 1  Memory Usage: 5kB
              ->  Seq Scan on pg_index x  (cost=0.00..5.64 rows=164 width=8)
2617894629statsinfodbt21614284.8520.464274705.6680.000
SELECT stock_level(?, ?, ?)
Plan IDCallsTotal time (sec)Time/call (sec)Block read time (ms)Block write time (ms)First callLast call
Plan (child row)
2734494998614284.8520.464274705.6680.0002015-03-10 16:12:342015-03-10 17:12:55
Result  (cost=0.00..0.01 rows=1 width=0)
2694427204statsinfodbt21653542.3430.831497424.4340.000
SELECT delivery(9, 10)
Plan IDCallsTotal time (sec)Time/call (sec)Block read time (ms)Block write time (ms)First callLast call
Plan (child row)
2734494998653542.3430.831497424.4340.0002015-03-10 16:12:372015-03-10 17:12:54
Result  (cost=0.00..0.01 rows=1 width=0)
2924031990statsinfodbt216024.5270.4090.0000.000
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), a.schemaname, a.relname,
       seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd,
       n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read,
       heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read,
display full query string
Plan IDCallsTotal time (sec)Time/call (sec)Block read time (ms)Block write time (ms)First callLast call
Plan (child row)
3313488516024.5270.4090.0000.0002015-03-10 16:13:262015-03-10 17:12:47
Hash Join  (cost=82.90..90.99 rows=84 width=272)
  Hash Cond: (c.oid = a.relid)
  ->  HashAggregate  (cost=24.85..30.52 rows=84 width=136)
        ->  Hash Left Join  (cost=15.53..23.38 rows=84 width=136)
              Hash Cond: (c.relnamespace = n.oid)
              ->  Hash Right Join  (cost=14.39..21.09 rows=84 width=76)
                    Hash Cond: (i.indrelid = c.oid)
                    ->  Seq Scan on pg_index i  (cost=0.00..5.64 rows=164 width=8)
                    ->  Hash  (cost=13.34..13.34 rows=84 width=72)
                          Buckets: 1024  Batches: 1  Memory Usage: 9kB
                          ->  Seq Scan on pg_class c  (cost=0.00..13.34 rows=84 width=72)
                                Filter: (relkind = ANY ('{r,t,m}'::"char"[]))
              ->  Hash  (cost=1.06..1.06 rows=6 width=68)
                    Buckets: 1024  Batches: 1  Memory Usage: 1kB
                    ->  Seq Scan on pg_namespace n  (cost=0.00..1.06 rows=6 width=68)
  ->  Hash  (cost=57.00..57.00 rows=84 width=196)
        Buckets: 1024  Batches: 1  Memory Usage: 18kB
        ->  Subquery Scan on a  (cost=51.96..57.00 rows=84 width=196)
              ->  HashAggregate  (cost=51.96..56.16 rows=84 width=148)
                    ->  Hash Left Join  (cost=40.54..48.39 rows=84 width=148)
                          Hash Cond: (c_1.relnamespace = n_1.oid)
                          ->  Hash Right Join  (cost=39.41..46.10 rows=84 width=88)
                                Hash Cond: (i_1.indrelid = c_1.oid)
                                ->  Seq Scan on pg_index i_1  (cost=0.00..5.64 rows=164 width=8)
                                ->  Hash  (cost=38.36..38.36 rows=84 width=84)
                                      Buckets: 1024  Batches: 1  Memory Usage: 9kB
                                      ->  Hash Right Join  (cost=31.66..38.36 rows=84 width=84)
                                            Hash Cond: (x.indrelid = t.oid)
                                            ->  Seq Scan on pg_index x  (cost=0.00..5.64 rows=164 width=8)
                                            ->  Hash  (cost=30.61..30.61 rows=84 width=76)
                                                  Buckets: 1024  Batches: 1  Memory Usage: 9kB
                                                  ->  Hash Left Join  (cost=16.11..30.61 rows=84 width=76)
                                                        Hash Cond: (c_1.reltoastrelid = t.oid)
                                                        ->  Seq Scan on pg_class c_1  (cost=0.00..13.34 rows=84 width=76)
                                                              Filter: (relkind = ANY ('{r,t,m}'::"char"[]))
                                                        ->  Hash  (cost=12.16..12.16 rows=316 width=4)
                                                              Buckets: 1024  Batches: 1  Memory Usage: 12kB
                                                              ->  Seq Scan on pg_class t  (cost=0.00..12.16 rows=316 width=4)
                          ->  Hash  (cost=1.06..1.06 rows=6 width=68)
                                Buckets: 1024  Batches: 1  Memory Usage: 1kB
                                ->  Seq Scan on pg_namespace n_1  (cost=0.00..1.06 rows=6 width=68)
3116242283statsinfodbt21600.1410.0020.0000.000
SELECT i.oid AS indexrelid, c.oid AS relid, i.reltablespace, i.relname AS indexrelname, i.relam, i.relpages, i.reltuples, i.reloptions, x.indisunique, x.indisprimary, x.indisclustered, x.indisvalid, x.indkey,
display full query string
Plan IDCallsTotal time (sec)Time/call (sec)Block read time (ms)Block write time (ms)First callLast call
Plan (child row)
2504135445600.1410.0020.0000.0002015-03-10 16:13:002015-03-10 17:12:00
Nested Loop  (cost=15.25..28.53 rows=15 width=151)
  ->  Hash Join  (cost=15.10..21.51 rows=15 width=39)
        Hash Cond: (x.indrelid = c.oid)
        ->  Seq Scan on pg_index x  (cost=0.00..5.64 rows=164 width=39)
        ->  Hash  (cost=14.75..14.75 rows=28 width=4)
              Buckets: 1024  Batches: 1  Memory Usage: 1kB
              ->  Hash Join  (cost=1.20..14.75 rows=28 width=4)
                    Hash Cond: (c.relnamespace = n.oid)
                    ->  Seq Scan on pg_class c  (cost=0.00..12.95 rows=84 width=8)
                          Filter: (relkind = ANY ('{r,t}'::"char"[]))
                    ->  Hash  (cost=1.18..1.18 rows=2 width=4)
                          Buckets: 1024  Batches: 1  Memory Usage: 1kB
                          ->  Seq Scan on pg_namespace n  (cost=0.00..1.18 rows=2 width=4)
                                Filter: ((nspname)::text <> ALL (('{pg_catalog, pg_toast, information_schema, statsinfo}'::cstring)::text[]))
  ->  Index Scan using pg_class_oid_index on pg_class i  (cost=0.15..0.44 rows=1 width=116)
        Index Cond: (oid = x.indexrelid)

Long Transactions

PIDClient addressBegin atDuration (sec)Last query
9214::12015-03-10 16:58:5019.766COMMIT
9214::12015-03-10 17:05:0618.768COMMIT
9210::12015-03-10 16:56:4218.096COMMIT
9210::12015-03-10 16:27:0217.214COMMIT
9208::12015-03-10 16:58:5016.753FETCH ALL IN mycursor
9202::12015-03-10 16:58:5016.679COMMIT
9202::12015-03-10 17:10:0916.429COMMIT
9221::12015-03-10 16:58:5016.330FETCH ALL IN mycursor
9210::12015-03-10 16:45:3415.877DECLARE mycursor CURSOR FOR SELECT new_order(9, 5, 1592, 1, 8, make_new_order_info(38400, 9, 1), make_new_order_info(57086, 9, 5), make_new_order_info(24416, 9, 10), make_new_order_info(47294, 9, 7), make_new_order_info(90868, 9, 9), make_new_order_info(97
display full query string
9210::12015-03-10 16:43:2915.581COMMIT
9212::12015-03-10 16:39:2515.289COMMIT
9204::12015-03-10 17:05:1015.197FETCH ALL IN mycursor
9206::12015-03-10 16:45:3514.808DECLARE mycursor CURSOR FOR SELECT new_order(7, 1, 1846, 0, 14, make_new_order_info(95164, 7, 4), make_new_order_info(61118, 7, 9), make_new_order_info(28605, 7, 4), make_new_order_info(6895, 7, 2), make_new_order_info(45783, 7, 10), make_new_order_info(35
display full query string
9202::12015-03-10 17:07:2514.786COMMIT
9202::12015-03-10 16:21:0514.761COMMIT
9221::12015-03-10 17:07:2514.559SELECT payment(10, 3, 0, 10, 3, 'EINGATIONPRI', 3625.400000)
9221::12015-03-10 16:45:3614.420DECLARE mycursor CURSOR FOR SELECT new_order(2, 3, 990, 0, 12, make_new_order_info(12128, 4, 8), make_new_order_info(85992, 2, 3), make_new_order_info(38656, 2, 8), make_new_order_info(79870, 2, 7), make_new_order_info(98304, 2, 10), make_new_order_info(73
display full query string
9214::12015-03-10 16:21:0614.324COMMIT
9221::12015-03-10 16:21:0614.310FETCH ALL IN mycursor
9219::12015-03-10 16:58:5214.280FETCH ALL IN mycursor
9212::12015-03-10 16:45:3614.253DECLARE mycursor CURSOR FOR SELECT new_order(3, 4, 2006, 1, 14, make_new_order_info(24524, 3, 9), make_new_order_info(87525, 3, 9), make_new_order_info(81903, 3, 10), make_new_order_info(73016, 3, 2), make_new_order_info(7792, 3, 10), make_new_order_info(4
display full query string
9202::12015-03-10 16:45:3614.169DECLARE mycursor CURSOR FOR SELECT new_order(7, 1, 352, 1, 6, make_new_order_info(57280, 7, 9), make_new_order_info(39936, 7, 3), make_new_order_info(24576, 7, 8), make_new_order_info(80892, 7, 10), make_new_order_info(83189, 7, 4), make_new_order_info(323
display full query string
9210::12015-03-10 17:05:1114.162COMMIT
9204::12015-03-10 16:45:3614.085DECLARE mycursor CURSOR FOR SELECT new_order(10, 7, 1023, 0, 10, make_new_order_info(15836, 10, 7), make_new_order_info(81399, 10, 4), make_new_order_info(64983, 10, 10), make_new_order_info(24550, 10, 6), make_new_order_info(20976, 4, 8), make_new_order_i
display full query string
9212::12015-03-10 17:07:2614.055COMMIT
9212::12015-03-10 17:01:0614.049COMMIT
9219::12015-03-10 17:01:0614.049COMMIT
9206::12015-03-10 17:07:2614.035COMMIT
9214::12015-03-10 17:07:2614.029FETCH ALL IN mycursor
9208::12015-03-10 16:45:3614.009DECLARE mycursor CURSOR FOR SELECT new_order(5, 7, 40, 1, 8, make_new_order_info(81919, 5, 8), make_new_order_info(65400, 5, 4), make_new_order_info(13822, 5, 7), make_new_order_info(24576, 5, 10), make_new_order_info(71551, 5, 1), make_new_order_info(4056
display full query string
9206::12015-03-10 16:58:5313.978FETCH ALL IN mycursor
9206::12015-03-10 16:21:0613.920FETCH ALL IN mycursor
9217::12015-03-10 17:07:2613.891COMMIT
9202::12015-03-10 17:05:1113.875COMMIT
9217::12015-03-10 17:05:1113.770COMMIT
9221::12015-03-10 17:05:1113.770COMMIT
9208::12015-03-10 17:05:1113.769COMMIT
9219::12015-03-10 17:05:1113.769COMMIT
9204::12015-03-10 16:43:3113.761COMMIT
9208::12015-03-10 16:43:3113.761COMMIT
9219::12015-03-10 17:07:2613.681SELECT payment(6, 4, 0, 6, 4, 'BAROUGHTPRES', 3143.310000)
9208::12015-03-10 17:07:2613.675FETCH ALL IN mycursor
9219::12015-03-10 16:39:2713.585COMMIT
9202::12015-03-10 16:39:2713.583COMMIT
9210::12015-03-10 16:39:2713.582COMMIT
9204::12015-03-10 17:07:2613.519FETCH ALL IN mycursor
9206::12015-03-10 17:01:0213.252COMMIT
9204::12015-03-10 16:56:4212.992FETCH ALL IN mycursor
9212::12015-03-10 17:05:1212.922COMMIT
9210::12015-03-10 17:09:3712.865COMMIT
9208::12015-03-10 16:56:4212.859FETCH ALL IN mycursor
9204::12015-03-10 17:12:2212.685COMMIT
9221::12015-03-10 16:56:4212.652COMMIT
9202::12015-03-10 16:43:3812.520FETCH ALL IN mycursor
9217::12015-03-10 16:43:3812.516COMMIT
9212::12015-03-10 16:43:3812.515COMMIT
9214::12015-03-10 16:43:3812.510COMMIT
9219::12015-03-10 16:43:3812.505COMMIT
9212::12015-03-10 16:56:4312.496SELECT delivery(7, 8)
9202::12015-03-10 17:09:3812.493COMMIT
9212::12015-03-10 17:00:5311.875COMMIT
9212::12015-03-10 16:39:0811.600COMMIT
9204::12015-03-10 16:50:0311.599FETCH ALL IN mycursor
9214::12015-03-10 16:50:0311.599FETCH ALL IN mycursor
101802015-03-10 16:45:3811.533
9210::12015-03-10 16:39:0911.527COMMIT
9214::12015-03-10 16:54:2911.512SELECT delivery(4, 5)
9204::12015-03-10 16:29:0411.380COMMIT
9204::12015-03-10 17:09:3911.380COMMIT
9204::12015-03-10 16:39:0911.371COMMIT
9210::12015-03-10 17:01:0411.257COMMIT
9206::12015-03-10 17:05:1411.245COMMIT
9208::12015-03-10 17:09:3910.962COMMIT
9214::12015-03-10 16:52:1910.932FETCH ALL IN mycursor
9204::12015-03-10 16:58:4910.903COMMIT
9219::12015-03-10 16:56:3910.886COMMIT
9210::12015-03-10 16:43:4910.804DECLARE mycursor CURSOR FOR SELECT new_order(9, 3, 2560, 1, 13, make_new_order_info(68840, 9, 4), make_new_order_info(89790, 9, 8), make_new_order_info(73728, 9, 3), make_new_order_info(40896, 9, 8), make_new_order_info(12000, 9, 5), make_new_order_info(52
display full query string
9204::12015-03-10 16:43:4910.803DECLARE mycursor CURSOR FOR SELECT new_order(10, 3, 1776, 0, 9, make_new_order_info(90032, 10, 6), make_new_order_info(8192, 10, 9), make_new_order_info(47104, 10, 4), make_new_order_info(97792, 10, 6), make_new_order_info(48380, 10, 9), make_new_order_inf
display full query string
9221::12015-03-10 17:10:0510.544COMMIT
9208::12015-03-10 16:29:0510.501COMMIT
9219::12015-03-10 16:39:1010.355COMMIT
9221::12015-03-10 17:12:3510.342COMMIT
9202::12015-03-10 17:12:3510.342COMMIT
9217::12015-03-10 17:12:3510.341COMMIT
9208::12015-03-10 17:12:3510.335COMMIT
9221::12015-03-10 16:39:1010.309COMMIT
9219::12015-03-10 17:12:2510.144COMMIT
9217::12015-03-10 16:26:5010.129COMMIT
9212::12015-03-10 16:59:0010.104COMMIT
9208::12015-03-10 16:39:1010.031SELECT payment(6, 10, 0, 6, 10, 'ABLEOUGHTCALLY', 881.320000)
9210::12015-03-10 17:07:259.808COMMIT
9210::12015-03-10 16:52:209.777SELECT payment(8, 1, 0, 8, 1, 'EINGEINGCALLY', 3754.150000)
9214::12015-03-10 17:01:059.719COMMIT
9221::12015-03-10 16:26:509.713FETCH ALL IN mycursor
9217::12015-03-10 17:00:509.712COMMIT
9210::12015-03-10 17:12:269.640COMMIT
9219::12015-03-10 16:56:519.624COMMIT
9214::12015-03-10 16:41:269.467COMMIT
9219::12015-03-10 17:12:369.466COMMIT
9210::12015-03-10 17:12:369.466COMMIT
9204::12015-03-10 16:21:069.446COMMIT
9210::12015-03-10 16:41:369.433COMMIT
9204::12015-03-10 16:41:319.432COMMIT
9212::12015-03-10 16:41:269.418COMMIT
9221::12015-03-10 17:10:169.405SELECT stock_level(10, 10, 14)
9214::12015-03-10 17:10:069.401FETCH ALL IN mycursor
9206::12015-03-10 16:41:369.320COMMIT
9212::12015-03-10 16:26:519.312FETCH ALL IN mycursor
9202::12015-03-10 16:41:369.306COMMIT
9219::12015-03-10 16:21:069.294COMMIT
9214::12015-03-10 16:41:369.219COMMIT
9202::12015-03-10 16:49:469.193COMMIT
9210::12015-03-10 16:26:519.168COMMIT
9208::12015-03-10 16:26:519.149FETCH ALL IN mycursor
9210::12015-03-10 16:23:019.041COMMIT
106662015-03-10 17:12:368.996autovacuum: VACUUM ANALYZE public.warehouse
9221::12015-03-10 16:41:268.993COMMIT
9217::12015-03-10 16:23:018.982COMMIT
9219::12015-03-10 16:41:268.970COMMIT
9221::12015-03-10 17:09:418.965COMMIT
9210::12015-03-10 16:41:268.949COMMIT
9210::12015-03-10 17:01:168.897SELECT payment(8, 4, 0, 6, 7, 'BARPRESCALLY', 2334.020000)
9217::12015-03-10 17:01:118.840COMMIT
9202::12015-03-10 17:01:118.840COMMIT
9204::12015-03-10 17:01:118.835COMMIT
9210::12015-03-10 17:00:518.772COMMIT
9221::12015-03-10 16:52:318.734COMMIT
9210::12015-03-10 16:58:518.690COMMIT
9217::12015-03-10 16:52:318.671SELECT stock_level(7, 9, 20)
9208::12015-03-10 16:52:318.670COMMIT
9214::12015-03-10 16:52:318.667FETCH ALL IN mycursor
9219::12015-03-10 16:52:318.666COMMIT
9208::12015-03-10 16:50:018.666SELECT delivery(1, 5)
9210::12015-03-10 16:50:018.666COMMIT
9206::12015-03-10 16:52:318.665SELECT delivery(4, 4)
9204::12015-03-10 16:52:318.655FETCH ALL IN mycursor
9221::12015-03-10 16:50:068.644FETCH ALL IN mycursor
9221::12015-03-10 16:23:028.643COMMIT
9219::12015-03-10 16:26:518.636FETCH ALL IN mycursor
9202::12015-03-10 16:52:178.568COMMIT
9214::12015-03-10 16:26:528.500COMMIT
9219::12015-03-10 16:27:128.472COMMIT
9202::12015-03-10 16:23:028.464COMMIT
9206::12015-03-10 16:23:028.442COMMIT
9219::12015-03-10 17:09:428.412COMMIT
9208::12015-03-10 16:21:078.383COMMIT
9217::12015-03-10 16:36:528.359FETCH ALL IN mycursor
9206::12015-03-10 16:49:428.326COMMIT
9202::12015-03-10 16:26:528.263FETCH ALL IN mycursor
9208::12015-03-10 16:23:028.195COMMIT
9214::12015-03-10 16:37:128.119FETCH ALL IN mycursor
9202::12015-03-10 16:36:528.118FETCH ALL IN mycursor
9206::12015-03-10 16:56:428.052COMMIT
9212::12015-03-10 16:36:528.031FETCH ALL IN mycursor
9204::12015-03-10 16:46:028.020COMMIT
9212::12015-03-10 17:03:127.953FETCH ALL IN mycursor
9217::12015-03-10 17:10:177.940SELECT stock_level(2, 4, 14)
9214::12015-03-10 16:23:077.918COMMIT
9206::12015-03-10 17:10:177.904COMMIT
9202::12015-03-10 16:29:027.859COMMIT
9219::12015-03-10 17:10:177.848FETCH ALL IN mycursor
9202::12015-03-10 16:56:427.838COMMIT
9214::12015-03-10 17:00:527.664COMMIT
9217::12015-03-10 16:58:527.651COMMIT
9212::12015-03-10 17:10:187.635FETCH ALL IN mycursor
9206::12015-03-10 17:00:527.605COMMIT
9214::12015-03-10 17:10:187.593COMMIT
9219::12015-03-10 17:03:137.567FETCH ALL IN mycursor
9221::12015-03-10 17:00:527.557COMMIT
9217::12015-03-10 16:56:437.524COMMIT
9217::12015-03-10 17:09:437.507COMMIT
9214::12015-03-10 17:09:437.486COMMIT
9204::12015-03-10 16:32:537.349COMMIT
9206::12015-03-10 16:29:037.327COMMIT
9221::12015-03-10 17:03:137.316FETCH ALL IN mycursor
9202::12015-03-10 17:03:137.253FETCH ALL IN mycursor
9208::12015-03-10 16:54:287.251COMMIT
9219::12015-03-10 16:54:287.244FETCH ALL IN mycursor
9219::12015-03-10 16:29:037.242COMMIT
9212::12015-03-10 16:29:037.163COMMIT
9219::12015-03-10 16:45:437.094DECLARE mycursor CURSOR FOR SELECT new_order(7, 3, 2551, 0, 9, make_new_order_info(96238, 7, 8), make_new_order_info(45823, 7, 9), make_new_order_info(56198, 7, 4), make_new_order_info(94155, 5, 1), make_new_order_info(56224, 7, 2), make_new_order_info(387
display full query string
9217::12015-03-10 16:45:437.082DECLARE mycursor CURSOR FOR SELECT new_order(9, 4, 415, 0, 11, make_new_order_info(56926, 9, 7), make_new_order_info(6092, 10, 10), make_new_order_info(32620, 9, 4), make_new_order_info(28647, 9, 10), make_new_order_info(65184, 9, 5), make_new_order_info(2
display full query string
9214::12015-03-10 16:33:137.078COMMIT
9214::12015-03-10 17:03:137.066SELECT payment(1, 4, 2046, 1, 4, '', 1266.560000)
9206::12015-03-10 16:33:137.065 in transaction
9217::12015-03-10 16:33:137.063COMMIT
9210::12015-03-10 16:33:137.063COMMIT
9208::12015-03-10 16:33:137.061COMMIT
9202::12015-03-10 16:54:287.060COMMIT
9221::12015-03-10 16:46:037.048COMMIT
9210::12015-03-10 17:03:137.022SELECT * FROM order_status(1501, 9, 7, '')
9221::12015-03-10 16:33:137.010COMMIT
9204::12015-03-10 17:03:136.967SELECT payment(8, 4, 0, 5, 4, 'EINGATIONEING', 2348.990000)
9206::12015-03-10 17:03:136.908FETCH ALL IN mycursor
9219::12015-03-10 16:36:536.851FETCH ALL IN mycursor
9217::12015-03-10 16:32:536.826FETCH ALL IN mycursor
9208::12015-03-10 16:32:536.815SELECT payment(10, 7, 0, 3, 8, 'ESEOUGHTOUGHT', 995.570000)
9208::12015-03-10 17:00:536.768COMMIT
9212::12015-03-10 17:09:436.714COMMIT
9212::12015-03-10 16:32:536.695SELECT payment(7, 4, 0, 6, 1, 'ESEOUGHTOUGHT', 3180.460000)
9212::12015-03-10 17:10:086.694COMMIT
9206::12015-03-10 16:36:536.680FETCH ALL IN mycursor
9208::12015-03-10 16:36:536.675COMMIT
9221::12015-03-10 16:29:036.648COMMIT
9212::12015-03-10 16:30:446.592COMMIT
9217::12015-03-10 16:50:036.573COMMIT
9219::12015-03-10 16:50:036.573COMMIT
9206::12015-03-10 16:50:036.573COMMIT
9202::12015-03-10 16:50:036.573COMMIT
9212::12015-03-10 16:50:036.572COMMIT
9202::12015-03-10 16:32:546.547FETCH ALL IN mycursor
9204::12015-03-10 16:36:546.526FETCH ALL IN mycursor
9217::12015-03-10 17:03:146.514SELECT payment(10, 1, 0, 10, 1, 'ABLEABLEPRI', 4858.950000)
9204::12015-03-10 16:54:296.490FETCH ALL IN mycursor
9221::12015-03-10 16:54:296.490COMMIT
9206::12015-03-10 16:54:296.490COMMIT
9221::12015-03-10 16:49:446.454COMMIT
9202::12015-03-10 16:30:496.433COMMIT
9210::12015-03-10 16:32:546.422SELECT payment(7, 5, 1008, 7, 5, '', 1451.580000)
9208::12015-03-10 17:03:146.347SELECT payment(6, 4, 255, 6, 4, '', 4154.910000)
9214::12015-03-10 16:36:546.321SELECT * FROM order_status(2616, 1, 7, '')
9221::12015-03-10 16:36:546.256SELECT delivery(6, 3)
9221::12015-03-10 16:32:546.252FETCH ALL IN mycursor
9206::12015-03-10 16:32:546.197FETCH ALL IN mycursor
9204::12015-03-10 16:49:446.151COMMIT
9212::12015-03-10 16:49:446.150COMMIT
9219::12015-03-10 16:24:496.134COMMIT
9210::12015-03-10 16:54:296.090FETCH ALL IN mycursor
9212::12015-03-10 16:54:296.089COMMIT
9217::12015-03-10 16:54:296.089COMMIT
9217::12015-03-10 16:24:495.837FETCH ALL IN mycursor
9208::12015-03-10 16:30:445.731COMMIT
9206::12015-03-10 16:48:095.718FETCH ALL IN mycursor
9214::12015-03-10 16:48:095.588COMMIT
9212::12015-03-10 16:58:505.588COMMIT
9217::12015-03-10 16:29:055.551COMMIT
9214::12015-03-10 16:30:505.460COMMIT
9217::12015-03-10 16:30:505.460COMMIT
9204::12015-03-10 16:30:505.458COMMIT
9212::12015-03-10 16:21:055.447COMMIT
9212::12015-03-10 16:47:555.353COMMIT
9208::12015-03-10 16:49:405.282COMMIT
9221::12015-03-10 17:06:555.247SELECT delivery(4, 3)
9214::12015-03-10 16:32:555.215SELECT payment(8, 6, 72, 1, 1, '', 3622.380000)
9219::12015-03-10 16:23:005.198COMMIT
9217::12015-03-10 16:59:055.153SELECT delivery(9, 10)
9210::12015-03-10 16:36:555.141SELECT payment(6, 3, 748, 6, 3, '', 3484.640000)
9210::12015-03-10 16:30:505.129COMMIT
9212::12015-03-10 17:08:005.075COMMIT
9219::12015-03-10 16:32:555.071SELECT payment(6, 8, 0, 6, 8, 'PRESESEOUGHT', 2771.520000)
9219::12015-03-10 16:30:505.058COMMIT
9219::12015-03-10 16:19:055.048COMMIT
9214::12015-03-10 16:29:105.039COMMIT
9219::12015-03-10 16:29:105.012SELECT payment(3, 2, 0, 3, 2, 'CALLYESEEING', 870.610000)
9212::12015-03-10 16:30:504.978COMMIT
9208::12015-03-10 16:30:504.974COMMIT
9212::12015-03-10 16:46:004.974COMMIT
9217::12015-03-10 16:46:004.881COMMIT
9210::12015-03-10 16:46:004.879COMMIT
9214::12015-03-10 16:46:004.877COMMIT
9202::12015-03-10 16:46:004.875COMMIT
9208::12015-03-10 16:46:004.874COMMIT
9206::12015-03-10 16:46:004.872COMMIT
9219::12015-03-10 16:46:004.871COMMIT
9208::12015-03-10 16:21:154.865SELECT payment(10, 9, 0, 10, 9, 'PRIANTICALLY', 345.170000)
9210::12015-03-10 16:34:554.858FETCH ALL IN mycursor
9221::12015-03-10 16:47:554.803FETCH ALL IN mycursor
9206::12015-03-10 16:34:554.766FETCH ALL IN mycursor
9202::12015-03-10 16:49:404.669COMMIT
9221::12015-03-10 16:34:554.629SELECT payment(1, 10, 1982, 1, 10, '', 1534.610000)
9219::12015-03-10 17:06:554.622COMMIT
9217::12015-03-10 17:08:014.615COMMIT
9208::12015-03-10 16:35:064.572FETCH ALL IN mycursor
9221::12015-03-10 16:35:064.572COMMIT
9212::12015-03-10 16:35:064.572COMMIT
9219::12015-03-10 16:34:564.565SELECT payment(1, 5, 0, 1, 5, 'ABLEESEOUGHT', 2693.210000)
9214::12015-03-10 16:33:054.549COMMIT
9221::12015-03-10 16:33:054.544COMMIT
9214::12015-03-10 17:08:014.509FETCH ALL IN mycursor
9214::12015-03-10 16:49:414.506COMMIT
9206::12015-03-10 16:37:124.502COMMIT
9208::12015-03-10 16:37:124.501FETCH ALL IN mycursor
9210::12015-03-10 16:37:124.499FETCH ALL IN mycursor
9208::12015-03-10 16:34:564.460FETCH ALL IN mycursor
9206::12015-03-10 17:08:014.452COMMIT
9208::12015-03-10 17:08:014.452FETCH ALL IN mycursor
9219::12015-03-10 17:08:014.451COMMIT
9204::12015-03-10 17:08:014.449FETCH ALL IN mycursor
9221::12015-03-10 16:31:114.448FETCH ALL IN mycursor
9221::12015-03-10 17:08:014.447COMMIT
9210::12015-03-10 17:08:014.447FETCH ALL IN mycursor
9204::12015-03-10 16:23:014.398COMMIT
9214::12015-03-10 16:31:114.379FETCH ALL IN mycursor
9208::12015-03-10 16:31:114.373FETCH ALL IN mycursor
9204::12015-03-10 17:00:564.308COMMIT
9217::12015-03-10 16:34:564.305FETCH ALL IN mycursor
9219::12015-03-10 17:00:514.305COMMIT
9219::12015-03-10 16:22:364.293COMMIT
9212::12015-03-10 16:34:564.249SELECT payment(10, 4, 0, 7, 7, 'CALLYANTICALLY', 1240.730000)
9219::12015-03-10 16:49:414.226COMMIT
9217::12015-03-10 16:21:064.214COMMIT
9206::12015-03-10 16:47:564.200SELECT payment(1, 10, 68, 1, 10, '', 1773.420000)
9217::12015-03-10 16:47:564.193SELECT * FROM order_status(0, 6, 4, 'OUGHTPRIEING')
9210::12015-03-10 16:49:464.191FETCH ALL IN mycursor
9204::12015-03-10 17:06:564.156FETCH ALL IN mycursor
9204::12015-03-10 16:34:564.131FETCH ALL IN mycursor
9202::12015-03-10 17:06:564.075SELECT payment(3, 9, 724, 6, 1, '', 2953.930000)
9204::12015-03-10 16:26:514.074COMMIT
9219::12015-03-10 16:48:114.070COMMIT
9214::12015-03-10 16:35:163.957COMMIT
9208::12015-03-10 16:35:163.946COMMIT
9208::12015-03-10 17:06:563.941FETCH ALL IN mycursor
9204::12015-03-10 16:23:063.932COMMIT
9208::12015-03-10 16:26:363.897COMMIT
9214::12015-03-10 16:24:363.896COMMIT
9204::12015-03-10 17:00:513.817COMMIT
9221::12015-03-10 16:35:163.802FETCH ALL IN mycursor
9219::12015-03-10 16:33:013.760COMMIT
9210::12015-03-10 16:47:563.737SELECT * FROM order_status(0, 2, 5, 'ANTIBARPRES')
9202::12015-03-10 16:37:163.719SELECT delivery(6, 7)
9214::12015-03-10 16:33:013.712COMMIT
9206::12015-03-10 16:20:363.682FETCH ALL IN mycursor
9212::12015-03-10 16:18:563.668COMMIT
9217::12015-03-10 16:20:363.638FETCH ALL IN mycursor
9208::12015-03-10 16:15:013.633COMMIT
9214::12015-03-10 16:18:563.617COMMIT
9210::12015-03-10 16:35:173.609FETCH ALL IN mycursor
9212::12015-03-10 17:06:563.594SELECT stock_level(6, 9, 19)
9219::12015-03-10 16:18:563.566FETCH ALL IN mycursor
9206::12015-03-10 16:24:363.557COMMIT
9219::12015-03-10 16:40:573.554FETCH ALL IN mycursor
9217::12015-03-10 17:06:563.537FETCH ALL IN mycursor
9206::12015-03-10 16:35:173.488FETCH ALL IN mycursor
9214::12015-03-10 16:47:573.455FETCH ALL IN mycursor
9208::12015-03-10 16:34:273.441COMMIT
9210::12015-03-10 17:06:573.366SELECT payment(6, 8, 0, 6, 8, 'ABLEESEOUGHT', 107.060000)
9202::12015-03-10 16:47:573.276SELECT * FROM order_status(2158, 9, 10, '')
9202::12015-03-10 16:34:573.188COMMIT
9214::12015-03-10 17:06:573.187SELECT payment(5, 7, 0, 5, 7, 'BARABLEPRI', 2391.720000)
9206::12015-03-10 17:06:573.161SELECT payment(5, 3, 0, 5, 3, 'ATIONATIONEING', 3891.960000)
9204::12015-03-10 16:37:173.090COMMIT
9206::12015-03-10 16:37:173.090COMMIT
9204::12015-03-10 16:47:573.088FETCH ALL IN mycursor
9202::12015-03-10 16:40:573.083FETCH ALL IN mycursor
97332015-03-10 16:20:373.071autovacuum: VACUUM ANALYZE public.district
9217::12015-03-10 16:18:573.058COMMIT
9204::12015-03-10 16:22:373.051FETCH ALL IN mycursor
9219::12015-03-10 16:27:423.006COMMIT
9212::12015-03-10 16:22:372.991FETCH ALL IN mycursor
9221::12015-03-10 16:22:372.964COMMIT
9204::12015-03-10 16:40:572.903FETCH ALL IN mycursor
9210::12015-03-10 16:37:172.849FETCH ALL IN mycursor
9217::12015-03-10 16:37:172.848COMMIT
9210::12015-03-10 16:57:072.847SELECT payment(9, 9, 0, 9, 9, 'BARABLEOUGHT', 1201.480000)
9219::12015-03-10 16:37:172.847COMMIT
9221::12015-03-10 16:16:572.841COMMIT
9212::12015-03-10 16:16:472.822COMMIT
9206::12015-03-10 17:09:422.809COMMIT
9202::12015-03-10 17:08:022.798SELECT payment(5, 6, 0, 5, 6, 'ATIONPRIOUGHT', 745.720000)
9202::12015-03-10 16:51:272.791COMMIT
9219::12015-03-10 16:16:472.773FETCH ALL IN mycursor
9210::12015-03-10 16:51:272.751SELECT payment(5, 3, 0, 5, 3, 'BAROUGHTPRI', 3662.540000)
9212::12015-03-10 16:57:072.739COMMIT
9221::12015-03-10 16:57:072.738COMMIT
9217::12015-03-10 16:57:072.732FETCH ALL IN mycursor
9214::12015-03-10 16:57:072.727SELECT * FROM order_status(0, 7, 9, 'ESEOUGHTOUGHT')
9204::12015-03-10 16:57:072.721SELECT stock_level(5, 4, 17)
9219::12015-03-10 16:57:072.721SELECT stock_level(4, 3, 10)
9206::12015-03-10 16:18:572.700FETCH ALL IN mycursor
9212::12015-03-10 16:35:182.662FETCH ALL IN mycursor
9210::12015-03-10 16:38:572.635COMMIT
9217::12015-03-10 16:19:022.593FETCH ALL IN mycursor
9208::12015-03-10 16:19:022.593FETCH ALL IN mycursor
9210::12015-03-10 16:18:572.586FETCH ALL IN mycursor
9202::12015-03-10 16:22:382.584COMMIT
9204::12015-03-10 16:38:572.580SELECT payment(9, 3, 0, 9, 3, 'CALLYANTIANTI', 4143.050000)
9208::12015-03-10 16:24:372.578COMMIT
9212::12015-03-10 16:15:022.571COMMIT
9219::12015-03-10 16:47:572.571FETCH ALL IN mycursor
9214::12015-03-10 16:20:372.566SELECT stock_level(9, 8, 19)
9206::12015-03-10 16:24:582.549COMMIT
9202::12015-03-10 16:24:582.549COMMIT
9217::12015-03-10 16:24:582.547COMMIT
9212::12015-03-10 16:24:582.546COMMIT
9214::12015-03-10 16:24:582.545COMMIT
9221::12015-03-10 16:51:282.491FETCH ALL IN mycursor
9208::12015-03-10 16:51:282.491COMMIT
9208::12015-03-10 16:47:582.478SELECT payment(8, 9, 1008, 8, 9, '', 3835.470000)
9202::12015-03-10 16:35:182.466SELECT payment(2, 7, 1939, 2, 7, '', 1425.940000)
9210::12015-03-10 16:22:382.465FETCH ALL IN mycursor
9217::12015-03-10 16:16:482.451COMMIT
9217::12015-03-10 16:16:432.451FETCH ALL IN mycursor
9206::12015-03-10 16:38:582.440SELECT delivery(7, 2)
9206::12015-03-10 16:40:582.439FETCH ALL IN mycursor
9214::12015-03-10 16:40:582.393FETCH ALL IN mycursor
9217::12015-03-10 17:02:482.326COMMIT
9221::12015-03-10 16:38:582.313COMMIT
9208::12015-03-10 16:14:482.309COMMIT
9206::12015-03-10 16:15:082.305COMMIT
9210::12015-03-10 16:15:082.305COMMIT
9221::12015-03-10 16:40:582.302SELECT payment(7, 5, 0, 7, 5, 'EINGABLEBAR', 2012.920000)
9221::12015-03-10 16:20:382.301COMMIT
9221::12015-03-10 16:16:482.301COMMIT
9208::12015-03-10 16:22:382.296COMMIT
9204::12015-03-10 16:18:582.286SELECT payment(7, 10, 0, 7, 10, 'PRESANTIPRI', 1871.170000)
9206::12015-03-10 16:51:282.252FETCH ALL IN mycursor
9210::12015-03-10 16:20:582.247FETCH ALL IN mycursor
9217::12015-03-10 16:27:432.243COMMIT
9206::12015-03-10 16:48:182.225COMMIT
9210::12015-03-10 16:16:532.208COMMIT
9221::12015-03-10 16:27:432.200COMMIT
9202::12015-03-10 16:18:582.196FETCH ALL IN mycursor
9219::12015-03-10 16:38:582.190COMMIT
9212::12015-03-10 16:48:182.175COMMIT
9212::12015-03-10 16:51:282.153FETCH ALL IN mycursor
9221::12015-03-10 16:18:582.152COMMIT
9202::12015-03-10 16:16:482.146COMMIT
9219::12015-03-10 16:20:582.142COMMIT
9217::12015-03-10 16:40:582.142FETCH ALL IN mycursor
9212::12015-03-10 16:17:432.124FETCH ALL IN mycursor
9202::12015-03-10 17:02:482.118COMMIT
9208::12015-03-10 16:16:482.097COMMIT
9208::12015-03-10 16:55:132.085COMMIT
9210::12015-03-10 16:51:432.046COMMIT
9217::12015-03-10 16:16:582.000COMMIT
9204::12015-03-10 16:25:091.994DECLARE mycursor CURSOR FOR SELECT new_order(2, 3, 956, 1, 8, make_new_order_info(24576, 2, 6), make_new_order_info(15224, 2, 3), make_new_order_info(79784, 2, 1), make_new_order_info(32112, 2, 10), make_new_order_info(49980, 2, 9), make_new_order_info(818
display full query string
9219::12015-03-10 16:25:091.993DECLARE mycursor CURSOR FOR SELECT new_order(8, 2, 1536, 1, 12, make_new_order_info(49146, 8, 10), make_new_order_info(65248, 8, 5), make_new_order_info(72348, 8, 1), make_new_order_info(59231, 8, 10), make_new_order_info(72679, 8, 9), make_new_order_info(
display full query string
9212::12015-03-10 16:25:091.993DECLARE mycursor CURSOR FOR SELECT new_order(5, 3, 2944, 1, 9, make_new_order_info(92960, 5, 6), make_new_order_info(71166, 5, 1), make_new_order_info(39888, 5, 4), make_new_order_info(63484, 5, 5), make_new_order_info(15074, 5, 10), make_new_order_info(81
display full query string
9210::12015-03-10 16:55:131.961SELECT payment(2, 4, 0, 1, 1, 'ABLEESEESE', 3487.660000)
9206::12015-03-10 16:22:381.961SELECT payment(7, 8, 0, 7, 8, 'ABLEABLEPRI', 3671.660000)
9214::12015-03-10 16:19:081.955COMMIT
9212::12015-03-10 16:19:081.954COMMIT
9210::12015-03-10 16:19:081.954COMMIT
9204::12015-03-10 16:20:581.951SELECT payment(2, 10, 2419, 2, 10, '', 2645.220000)
9219::12015-03-10 16:17:431.950FETCH ALL IN mycursor
9217::12015-03-10 16:19:081.949COMMIT
9206::12015-03-10 16:19:031.926FETCH ALL IN mycursor
9221::12015-03-10 16:19:031.926FETCH ALL IN mycursor
9214::12015-03-10 16:19:031.926FETCH ALL IN mycursor
9221::12015-03-10 16:40:181.925COMMIT
9212::12015-03-10 16:48:131.925COMMIT
9221::12015-03-10 16:48:131.924COMMIT
9210::12015-03-10 16:48:131.922COMMIT
9202::12015-03-10 16:20:581.920COMMIT
9217::12015-03-10 16:42:431.912COMMIT
9210::12015-03-10 16:57:381.907COMMIT
9219::12015-03-10 16:20:381.902COMMIT
9212::12015-03-10 16:40:481.889COMMIT
9208::12015-03-10 16:18:581.878COMMIT
9217::12015-03-10 17:02:581.855SELECT payment(9, 1, 0, 9, 1, 'ATIONEINGESE', 2061.270000)
9204::12015-03-10 16:40:181.844SELECT stock_level(8, 7, 19)
9214::12015-03-10 16:53:381.836COMMIT
9214::12015-03-10 16:22:381.821FETCH ALL IN mycursor
9221::12015-03-10 16:55:131.773COMMIT
9214::12015-03-10 16:57:381.756FETCH ALL IN mycursor
9217::12015-03-10 16:55:131.742COMMIT
9221::12015-03-10 16:15:031.739SELECT delivery(5, 4)
9217::12015-03-10 16:15:031.706COMMIT
9208::12015-03-10 16:48:131.702COMMIT
9219::12015-03-10 16:51:281.695FETCH ALL IN mycursor
9214::12015-03-10 16:48:181.685COMMIT
9221::12015-03-10 17:02:481.683SELECT payment(4, 6, 0, 4, 6, 'BARABLEPRI', 3501.730000)
9219::12015-03-10 16:44:041.666COMMIT
9208::12015-03-10 16:17:431.651FETCH ALL IN mycursor
9204::12015-03-10 16:31:591.643FETCH ALL IN mycursor
9214::12015-03-10 17:02:481.639COMMIT
9214::12015-03-10 16:15:081.631COMMIT
9202::12015-03-10 16:57:081.628COMMIT
9212::12015-03-10 17:02:481.627COMMIT
9212::12015-03-10 16:44:041.609COMMIT
9206::12015-03-10 16:44:041.591COMMIT
9210::12015-03-10 16:44:041.591COMMIT
9219::12015-03-10 16:31:141.590FETCH ALL IN mycursor
9210::12015-03-10 16:59:051.544SELECT * FROM order_status(60, 10, 1, '')
9204::12015-03-10 16:59:051.543SELECT payment(5, 5, 2942, 5, 5, '', 2542.650000)
9221::12015-03-10 16:53:491.532FETCH ALL IN mycursor
9219::12015-03-10 16:53:391.495COMMIT
9204::12015-03-10 16:53:391.485FETCH ALL IN mycursor
9204::12015-03-10 16:44:041.484COMMIT
9221::12015-03-10 16:15:091.479SELECT * FROM order_status(0, 6, 4, 'BAROUGHTEING')
9206::12015-03-10 16:38:341.450COMMIT
9214::12015-03-10 16:38:341.441SELECT stock_level(2, 6, 10)
9202::12015-03-10 16:44:041.436COMMIT
9214::12015-03-10 16:17:441.409FETCH ALL IN mycursor
9202::12015-03-10 16:44:091.405COMMIT
9210::12015-03-10 16:38:341.405SELECT delivery(8, 1)
9206::12015-03-10 16:44:091.405COMMIT
9204::12015-03-10 16:38:341.392COMMIT
9208::12015-03-10 17:02:491.387COMMIT
9212::12015-03-10 16:53:391.365FETCH ALL IN mycursor
9217::12015-03-10 16:38:341.356FETCH ALL IN mycursor
9206::12015-03-10 17:04:591.352SELECT payment(5, 6, 686, 5, 6, '', 3196.450000)
9204::12015-03-10 17:02:491.351COMMIT
9204::12015-03-10 16:42:441.348COMMIT
9208::12015-03-10 16:53:491.333FETCH ALL IN mycursor
9208::12015-03-10 16:31:591.320FETCH ALL IN mycursor
9214::12015-03-10 16:51:291.320SELECT payment(7, 3, 0, 1, 3, 'ESEOUGHTOUGHT', 4029.610000)
9221::12015-03-10 16:44:041.313FETCH ALL IN mycursor
9206::12015-03-10 16:15:041.311COMMIT
9210::12015-03-10 16:17:441.310FETCH ALL IN mycursor
9210::12015-03-10 16:15:041.307COMMIT
9217::12015-03-10 16:53:541.292COMMIT
9206::12015-03-10 16:53:391.286COMMIT
9212::12015-03-10 16:55:141.267COMMIT
9214::12015-03-10 17:02:591.250FETCH ALL IN mycursor
9217::12015-03-10 16:27:191.250COMMIT
9212::12015-03-10 16:27:191.249COMMIT
9214::12015-03-10 16:27:191.248FETCH ALL IN mycursor
9212::12015-03-10 16:53:541.234SELECT payment(4, 9, 0, 4, 9, 'BARABLEABLE', 1923.040000)
9206::12015-03-10 16:17:441.232SELECT payment(10, 7, 0, 10, 7, 'BARABLEPRI', 1138.910000)
9202::12015-03-10 16:53:491.210SELECT payment(5, 10, 0, 6, 6, 'PRIOUGHTBAR', 103.780000)
9217::12015-03-10 17:04:591.184SELECT payment(6, 2, 0, 6, 2, 'BAROUGHTOUGHT', 2532.660000)
9212::12015-03-10 17:02:141.179SELECT delivery(4, 6)
9204::12015-03-10 16:27:191.177FETCH ALL IN mycursor
9202::12015-03-10 16:27:191.174COMMIT
9208::12015-03-10 16:42:441.173SELECT delivery(6, 1)
9206::12015-03-10 16:55:141.170COMMIT
9217::12015-03-10 16:31:141.153SELECT delivery(7, 7)
9219::12015-03-10 16:55:141.152COMMIT
9202::12015-03-10 16:31:141.136FETCH ALL IN mycursor
9221::12015-03-10 16:17:441.135SELECT payment(9, 8, 0, 9, 8, 'ATIONEINGPRES', 3972.380000)
9214::12015-03-10 17:04:591.117SELECT payment(3, 6, 1920, 3, 6, '', 4819.390000)
9204::12015-03-10 16:17:441.114FETCH ALL IN mycursor
9204::12015-03-10 16:51:291.108SELECT delivery(6, 1)
9204::12015-03-10 16:22:341.050SELECT stock_level(9, 1, 12)
9204::12015-03-10 16:25:491.019FETCH ALL IN mycursor
9219::12015-03-10 16:25:341.008COMMIT

Lock Conflicts

DatabaseSchemaRelationDurationBlockee PIDBlocker PIDBlocker GIDBlockee queryBlocker query
dbt200:00:1492149208FETCH ALL IN mycursor
DECLARE mycursor CURSOR FOR SELECT new_order(7, 10, 1017, 1, 12, make_new_order_info(83968, 7, 2...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
display full query string
dbt200:00:1292049219SELECT payment(8, 9, 1144, 8, 9, '', 4861.960000)
SELECT payment(8, 3, 0, 8, 3, 'CALLYBARABLE', 2287.110000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
display full query string
dbt200:00:0892109212SELECT payment(7, 5, 1008, 7, 5, '', 1451.580000)
SELECT payment(7, 4, 0, 6, 1, 'ESEOUGHTOUGHT', 3180.460000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
display full query string
dbt200:00:0592199221SELECT payment(1, 5, 0, 1, 5, 'ABLEESEOUGHT', 2693.210000)
SELECT payment(1, 10, 1982, 1, 10, '', 1534.610000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
display full query string
dbt200:00:0592049214FETCH ALL IN mycursor
DECLARE mycursor CURSOR FOR SELECT new_order(2, 3, 71, 1, 10, make_new_order_info(89856, 2, 4), ...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
display full query string
dbt200:00:0492199221FETCH ALL IN mycursor
DECLARE mycursor CURSOR FOR SELECT new_order(10, 8, 2223, 1, 15, make_new_order_info(14302, 10, ...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
display full query string
dbt200:00:0492149219FETCH ALL IN mycursor
DECLARE mycursor CURSOR FOR SELECT new_order(9, 6, 1776, 1, 15, make_new_order_info(30711, 9, 8)...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
display full query string
dbt200:00:0392089206SELECT payment(5, 4, 0, 5, 4, 'ANTICALLYBAR', 529.620000)
SELECT payment(5, 6, 686, 5, 6, '', 3196.450000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
display full query string
dbt200:00:0392109221SELECT payment(7, 2, 0, 7, 2, 'ESEOUGHTOUGHT', 4951.450000)
SELECT payment(7, 5, 0, 7, 5, 'EINGABLEBAR', 2012.920000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
display full query string
dbt200:00:0292069202SELECT delivery(2, 2)
SELECT delivery(2, 3);SELECT no_o_id
FROM new_order
WHERE no_w_id = $1
  AND no_d_id = $2ORDER BY no_o_id LIMIT 1;DELETE FROM new_order
WHERE no_o_id = $1
display full query string
dbt200:00:0292199217SELECT payment(6, 2, 0, 6, 2, 'PRIATIONABLE', 4413.290000)
SELECT payment(6, 2, 0, 6, 2, 'BAROUGHTOUGHT', 2532.660000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
display full query string
dbt200:00:0192179210SELECT payment(1, 1, 48, 1, 1, '', 2464.750000)
SELECT payment(1, 9, 924, 1, 9, '', 690.670000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
display full query string
dbt200:00:0192149204SELECT payment(3, 2, 1980, 3, 2, '', 3160.320000)
DECLARE mycursor CURSOR FOR SELECT new_order(3, 2, 736, 1, 11, make_new_order_info(49102, 3, 2),...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
display full query string
dbt200:00:0192129206SELECT payment(3, 6, 0, 3, 6, 'ABLEPRIEING', 2583.740000)
DECLARE mycursor CURSOR FOR SELECT new_order(3, 6, 2034, 1, 14, make_new_order_info(88702, 3, 9)...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
display full query string
dbt200:00:0092219212SELECT payment(8, 2, 2328, 8, 2, '', 3202.920000)
SELECT payment(8, 10, 902, 8, 10, '', 4936.950000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
display full query string
dbt200:00:0092109206FETCH ALL IN mycursor
DECLARE mycursor CURSOR FOR SELECT new_order(8, 6, 8, 1, 9, make_new_order_info(8020, 8, 5), mak...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
display full query string
dbt200:00:0092129204SELECT payment(7, 3, 2606, 7, 3, '', 4915.340000)
SELECT payment(7, 1, 0, 7, 1, 'ABLEOUGHTESE', 4318.190000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
display full query string
dbt200:00:0092149208SELECT payment(3, 1, 0, 3, 1, 'ESEOUGHTESE', 815.170000)
SELECT payment(3, 5, 0, 3, 5, 'BARANTIPRI', 1983.660000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
display full query string

Maintenances

Checkpoints

Number of checkpoints28
Caused by timeout0
Caused by xlogs28
Average written buffers6105.679
Maximum written buffers6465.000
Average checkpoint duration74.531
Maximum checkpoint duration88.732

Autovacuums

Overview

DatabaseSchemaTableCountAvg index scansAvg removed rowsAvg remain rowsAvg remain deadAvg duration (sec)Max duration (sec)Cancels
dbt2publicdistrict590.11999.356121.79720.3730.0270.7402
dbt2pg_catalogpg_statistic11.00061.000491.0000.0000.0600.0600
dbt2pg_toastpg_toast_261951.00056.40081.0004.4001.0304.7900
dbt2publicwarehouse360.02856.16721.38910.5280.0050.1300

I/O Summary

DatabaseSchemaTableAvg page hitAvg page missAvg page dirtiedAvg read rateAvg write rate
dbt2pg_catalogpg_statistic119.0002.00021.0000.2342.456
dbt2pg_toastpg_toast_261964.00012.60013.4001.2331.487
dbt2publicwarehouse45.7220.2503.5281.95332.019
dbt2publicdistrict40.9660.0342.7630.14517.791

Analyze Overview

DatabaseSchemaTableCountTotal duration (sec)Avg duration (sec)Max duration (sec)Last analyzedCancelsMax modified rows
dbt2publicwarehouse602.1700.0360.0502015-03-10 17:12:40069
dbt2publicdistrict601.1800.0200.1302015-03-10 17:12:492246
dbt2publicnew_order10.6600.6600.6602015-03-10 16:51:3608963

Modified Rows

Cancellations

TimeDatabaseSchemaTableActivityCausal query
2015-03-10 16:22:36dbt2publicdistrictVACUUM
SELECT payment(7, 4, 0, 6, 1, 'ESEOUGHTOUGHT', 3180.460000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip\
FROM warehouse\
WHERE w_id = $1;UPDATE warehouse\
SET w_ytd = w_ytd + $1\
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip\
display full query string
2015-03-10 16:51:36dbt2publicdistrictANALYZE
SELECT payment(7, 4, 0, 6, 1, 'ESEOUGHTOUGHT', 3180.460000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip\
FROM warehouse\
WHERE w_id = $1;UPDATE warehouse\
SET w_ytd = w_ytd + $1\
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip\
display full query string
2015-03-10 17:01:57dbt2publicdistrictANALYZE
SELECT payment(8, 3, 0, 8, 3, 'CALLYBARABLE', 2287.110000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip\
FROM warehouse\
WHERE w_id = $1;UPDATE warehouse\
SET w_ytd = w_ytd + $1\
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip\
display full query string
2015-03-10 17:07:18dbt2publicdistrictVACUUM
SELECT payment(8, 3, 0, 8, 3, 'CALLYBARABLE', 2287.110000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip\
FROM warehouse\
WHERE w_id = $1;UPDATE warehouse\
SET w_ytd = w_ytd + $1\
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip\
display full query string

Replication

Overview

Session userstatsinfo
Application namesby
Client address127.0.0.1
Client host
Client port40783
Started at2015-03-10 16:11:08
Statestreaming
Current location0/CF2184B0 (0000000100000000000000CF)
Sent location0/CF2184B0 (0000000100000000000000CF)
Write location0/CF2184B0 (0000000100000000000000CF)
Flush location0/CF2184B0 (0000000100000000000000CF)
Replay location0/CF2037E0 (0000000100000000000000CF)
Sync priority1
Sync statesync

Delays

Miscellaneous

Tables and Indexes

Tables

DatabaseSchemaTableColumnsRowsMiB+MiBTable scansIndex scans
dbt2publiccustomer213000001836031507
dbt2publicdistrict1110000030408
dbt2publichistory830679225000
dbt2publicitem5100000100071660
dbt2publicnew_order39030040013000
dbt2publicorder_line1029200122827014210
dbt2publicorders8306833190013598
dbt2publicstock1799999534770252179
dbt2publicwarehouse91000206990

Indexes

DatabaseSchemaIndexTableMiB+MiBScansRows/scanReadsHitsKeys
dbt2publici_customercustomer170425111.684907234909c_w_id, c_d_id, c_last, c_first, c_id
dbt2publici_ordersorders905981.048563420366o_w_id, o_d_id, o_c_id
dbt2publicpk_customercustomer90272561.0006088106770c_w_id, c_d_id, c_id
dbt2publicpk_districtdistrict00304080.999030572d_w_id, d_id
dbt2publicpk_itemitem20716600.999229143417i_id
dbt2publicpk_new_ordernew_order20130000.9945860367no_w_id, no_d_id, no_o_id
dbt2publicpk_order_lineorder_line9261421016.7812684304612ol_w_id, ol_d_id, ol_o_id, ol_number
dbt2publicpk_ordersorders90130001.00030963275o_w_id, o_d_id, o_id
dbt2publicpk_stockstock3332521790.58710153963784s_w_id, s_i_id, s_quantity
dbt2publicpk_warehousewarehouse0000.000766w_id

Settings

Run-time parameters

NameSettingUnitSource
TimeZoneJapanconfiguration file
archive_commandcp %p /home/statsinfo/var/archivelog/%fconfiguration file
archive_modeonconfiguration file
default_text_search_configpg_catalog.englishconfiguration file
lc_messagesCconfiguration file
listen_addresses*configuration file
log_autovacuum_min_duration0msconfiguration file
log_checkpointsonconfiguration file
log_destinationcsvlogoverride
log_timezoneJapanconfiguration file
logging_collectoronoverride
max_prepared_transactions10configuration file
max_stack_depth2048kBenvironment variable
max_wal_senders30configuration file
pg_statsinfo.excluded_dbnamestemplate0, template1, postgresconfiguration file
pg_statsinfo.excluded_schemaspg_catalog, pg_toast, information_schema, statsinfoconfiguration file
pg_statsinfo.long_lock_threashold0configuration file
pg_statsinfo.repository_serverport=5432configuration file
pg_statsinfo.snapshot_interval60sconfiguration file
port5433configuration file
shared_buffers163848kBconfiguration file
shared_preload_librariespg_statsinfo, pg_stat_statements, pg_store_plansconfiguration file
synchronous_standby_namessbyconfiguration file
track_functionsallconfiguration file
track_io_timingonconfiguration file
transaction_isolationread committedoverride
wal_buffers5128kBoverride
wal_keep_segments32configuration file
wal_levelhot_standbyconfiguration file
SELECT c.oid AS relid, c.relnamespace, c.reltablespace, c.relname, c.reltoastrelid, x.indexrelid AS reltoastidxid, c.relkind, c.relpages, c.reltuples, c.reloptions, pg_relation_size(c.oid), pg_stat_get_numscans(c.oid) AS seq_scan, pg_stat_get_tuples_returned(c.oid) AS seq_tup_read, sum(pg_stat_get_numscans(i.indexrelid))::bigint AS idx_scan, sum(pg_stat_get_tuples_fetched(i.indexrelid))::bigint + pg_stat_get_tuples_fetched(c.oid) AS idx_tup_fetch, pg_stat_get_tuples_inserted(c.oid) AS n_tup_ins, pg_stat_get_tuples_updated(c.oid) AS n_tup_upd, pg_stat_get_tuples_deleted(c.oid) AS n_tup_del, pg_stat_get_tuples_hot_updated(c.oid) AS n_tup_hot_upd, pg_stat_get_live_tuples(c.oid) AS n_live_tup, pg_stat_get_dead_tuples(c.oid) AS n_dead_tup, pg_stat_get_mod_since_analyze(c.oid) AS n_mod_since_analyze, pg_stat_get_blocks_fetched(c.oid) - pg_stat_get_blocks_hit(c.oid) AS heap_blks_read, pg_stat_get_blocks_hit(c.oid) AS heap_blks_hit, sum(pg_stat_get_blocks_fetched(i.indexrelid) - pg_stat_get_blocks_hit(i.indexrelid))::bigint AS idx_blks_read, sum(pg_stat_get_blocks_hit(i.indexrelid))::bigint AS idx_blks_hit, pg_stat_get_blocks_fetched(t.oid) - pg_stat_get_blocks_hit(t.oid) AS toast_blks_read, pg_stat_get_blocks_hit(t.oid) AS toast_blks_hit, pg_stat_get_blocks_fetched(x.indexrelid) - pg_stat_get_blocks_hit(x.indexrelid) AS tidx_blks_read, pg_stat_get_blocks_hit(x.indexrelid) AS tidx_blks_hit, pg_stat_get_last_vacuum_time(c.oid) as last_vacuum, pg_stat_get_last_autovacuum_time(c.oid) as last_autovacuum, pg_stat_get_last_analyze_time(c.oid) as last_analyze, pg_stat_get_last_autoanalyze_time(c.oid) as last_autoanalyze FROM pg_class c LEFT JOIN pg_index i ON c.oid = i.indrelid LEFT JOIN pg_class t ON c.reltoastrelid = t.oid LEFT JOIN pg_index x ON c.reltoastrelid = x.indrelid LEFT JOIN pg_namespace n ON c.relnamespace = n.oid WHERE c.relkind IN (?, ?) AND n.nspname <> ALL ((? || $1 || ?)::text[]) GROUP BY c.oid, c.relnamespace, c.reltablespace, c.relname, c.reltoastrelid, c.relkind, c.relpages, c.reltuples, c.reloptions, t.oid, x.indexrelid
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), datname, numbackends,
       xact_commit, xact_rollback, blks_read, blks_hit, tup_returned,
       tup_fetched, tup_inserted, tup_updated, tup_deleted
FROM pg_stat_database
;
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), a.schemaname, a.relname,
       seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd,
       n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read,
       heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read,
       toast_blks_hit, tidx_blks_read, tidx_blks_hit
FROM pg_statio_all_tables a, pg_stat_all_tables b
WHERE a.relid = b.relid
; 
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), a.schemaname, a.relname,
       a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read,
       idx_blks_hit
FROM pg_stat_all_indexes a, pg_statio_all_indexes b
WHERE a.indexrelid = b.indexrelid
; 
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), relname, pid, mode, granted
FROM pg_locks, pg_class
WHERE relfilenode = relation
ORDER BY relname;
;
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), datname, pid, usesysid,
       usename, application_name, client_addr, client_port, backend_start,
       xact_start, query_start, waiting, query
FROM pg_stat_activity
;
SELECT a.attrelid, a.attnum, a.attname, format_type(atttypid, atttypmod) AS type, a.attstattarget, a.attstorage, a.attnotnull, a.attisdropped, s.stawidth as avg_width, s.stadistinct as n_distinct, CASE WHEN s.stakind1 = ? THEN s.stanumbers1[?] WHEN s.stakind2 = ? THEN s.stanumbers2[?] WHEN s.stakind3 = ? THEN s.stanumbers3[?] WHEN s.stakind4 = ? THEN s.stanumbers4[?] ELSE ? END AS correlation FROM pg_attribute a LEFT JOIN pg_class c ON a.attrelid = c.oid LEFT JOIN pg_statistic s ON a.attnum = s.staattnum AND a.attrelid = s.starelid AND NOT s.stainherit LEFT JOIN pg_namespace n ON c.relnamespace = n.oid WHERE a.attnum > ? AND c.relkind IN (?, ?) AND n.nspname <> ALL ((? || $1 || ?)::text[])
SELECT i.oid AS indexrelid, c.oid AS relid, i.reltablespace, i.relname AS indexrelname, i.relam, i.relpages, i.reltuples, i.reloptions, x.indisunique, x.indisprimary, x.indisclustered, x.indisvalid, x.indkey, pg_get_indexdef(i.oid), pg_relation_size(i.oid), pg_stat_get_numscans(i.oid) AS idx_scan, pg_stat_get_tuples_returned(i.oid) AS idx_tup_read, pg_stat_get_tuples_fetched(i.oid) AS idx_tup_fetch, pg_stat_get_blocks_fetched(i.oid) - pg_stat_get_blocks_hit(i.oid) AS idx_blks_read, pg_stat_get_blocks_hit(i.oid) AS idx_blks_hit FROM pg_class c JOIN pg_index x ON c.oid = x.indrelid JOIN pg_class i ON i.oid = x.indexrelid JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN (?, ?) AND n.nspname <> ALL ((? || $1 || ?)::text[])
SELECT s.funcid, n.oid AS nspid, s.funcname, pg_get_function_arguments(funcid) AS argtypes, s.calls, s.total_time, s.self_time FROM pg_stat_user_functions s JOIN pg_namespace n ON s.schemaname = n.nspname WHERE n.nspname <> ALL ((? || $1 || ?)::text[])
DECLARE mycursor CURSOR FOR SELECT new_order(8, 10, 2479, 1, 10, make_new_order_info(7934, 8, 10), make_new_order_info(69590, 8, 8), make_new_order_info(40368, 8, 6), make_new_order_info(1920, 8, 10), make_new_order_info(81844, 8, 7), make_new_order_info(49076, 8, 1), make_new_order_info(48636, 8, 8), make_new_order_info(32344, 8, 1), make_new_order_info(48557, 8, 6), make_new_order_info(15104, 8, 5), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0) )
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), datname, pid, usesysid,
       usename, application_name, client_addr, client_port, backend_start,
       xact_start, query_start, waiting, query
FROM pg_stat_activity
;
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), datname, numbackends,
       xact_commit, xact_rollback, blks_read, blks_hit, tup_returned,
       tup_fetched, tup_inserted, tup_updated, tup_deleted
FROM pg_stat_database
;
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), a.schemaname, a.relname,
       a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read,
       idx_blks_hit
FROM pg_stat_all_indexes a, pg_statio_all_indexes b
WHERE a.indexrelid = b.indexrelid
; 
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), relname, pid, mode, granted
FROM pg_locks, pg_class
WHERE relfilenode = relation
ORDER BY relname;
;
SELECT s.funcid, n.oid AS nspid, s.funcname, pg_get_function_arguments(funcid) AS argtypes, s.calls, s.total_time, s.self_time FROM pg_stat_user_functions s JOIN pg_namespace n ON s.schemaname = n.nspname WHERE n.nspname <> ALL ((? || $1 || ?)::text[])
SELECT c.oid AS relid, c.relnamespace, c.reltablespace, c.relname, c.reltoastrelid, x.indexrelid AS reltoastidxid, c.relkind, c.relpages, c.reltuples, c.reloptions, pg_relation_size(c.oid), pg_stat_get_numscans(c.oid) AS seq_scan, pg_stat_get_tuples_returned(c.oid) AS seq_tup_read, sum(pg_stat_get_numscans(i.indexrelid))::bigint AS idx_scan, sum(pg_stat_get_tuples_fetched(i.indexrelid))::bigint + pg_stat_get_tuples_fetched(c.oid) AS idx_tup_fetch, pg_stat_get_tuples_inserted(c.oid) AS n_tup_ins, pg_stat_get_tuples_updated(c.oid) AS n_tup_upd, pg_stat_get_tuples_deleted(c.oid) AS n_tup_del, pg_stat_get_tuples_hot_updated(c.oid) AS n_tup_hot_upd, pg_stat_get_live_tuples(c.oid) AS n_live_tup, pg_stat_get_dead_tuples(c.oid) AS n_dead_tup, pg_stat_get_mod_since_analyze(c.oid) AS n_mod_since_analyze, pg_stat_get_blocks_fetched(c.oid) - pg_stat_get_blocks_hit(c.oid) AS heap_blks_read, pg_stat_get_blocks_hit(c.oid) AS heap_blks_hit, sum(pg_stat_get_blocks_fetched(i.indexrelid) - pg_stat_get_blocks_hit(i.indexrelid))::bigint AS idx_blks_read, sum(pg_stat_get_blocks_hit(i.indexrelid))::bigint AS idx_blks_hit, pg_stat_get_blocks_fetched(t.oid) - pg_stat_get_blocks_hit(t.oid) AS toast_blks_read, pg_stat_get_blocks_hit(t.oid) AS toast_blks_hit, pg_stat_get_blocks_fetched(x.indexrelid) - pg_stat_get_blocks_hit(x.indexrelid) AS tidx_blks_read, pg_stat_get_blocks_hit(x.indexrelid) AS tidx_blks_hit, pg_stat_get_last_vacuum_time(c.oid) as last_vacuum, pg_stat_get_last_autovacuum_time(c.oid) as last_autovacuum, pg_stat_get_last_analyze_time(c.oid) as last_analyze, pg_stat_get_last_autoanalyze_time(c.oid) as last_autoanalyze FROM pg_class c LEFT JOIN pg_index i ON c.oid = i.indrelid LEFT JOIN pg_class t ON c.reltoastrelid = t.oid LEFT JOIN pg_index x ON c.reltoastrelid = x.indrelid LEFT JOIN pg_namespace n ON c.relnamespace = n.oid WHERE c.relkind IN (?, ?) AND n.nspname <> ALL ((? || $1 || ?)::text[]) GROUP BY c.oid, c.relnamespace, c.reltablespace, c.relname, c.reltoastrelid, c.relkind, c.relpages, c.reltuples, c.reloptions, t.oid, x.indexrelid
SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), a.schemaname, a.relname,
       seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd,
       n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read,
       heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read,
       toast_blks_hit, tidx_blks_read, tidx_blks_hit
FROM pg_statio_all_tables a, pg_stat_all_tables b
WHERE a.relid = b.relid
; 
SELECT i.oid AS indexrelid, c.oid AS relid, i.reltablespace, i.relname AS indexrelname, i.relam, i.relpages, i.reltuples, i.reloptions, x.indisunique, x.indisprimary, x.indisclustered, x.indisvalid, x.indkey, pg_get_indexdef(i.oid), pg_relation_size(i.oid), pg_stat_get_numscans(i.oid) AS idx_scan, pg_stat_get_tuples_returned(i.oid) AS idx_tup_read, pg_stat_get_tuples_fetched(i.oid) AS idx_tup_fetch, pg_stat_get_blocks_fetched(i.oid) - pg_stat_get_blocks_hit(i.oid) AS idx_blks_read, pg_stat_get_blocks_hit(i.oid) AS idx_blks_hit FROM pg_class c JOIN pg_index x ON c.oid = x.indrelid JOIN pg_class i ON i.oid = x.indexrelid JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN (?, ?) AND n.nspname <> ALL ((? || $1 || ?)::text[])
DECLARE mycursor CURSOR FOR SELECT new_order(9, 5, 1592, 1, 8, make_new_order_info(38400, 9, 1), make_new_order_info(57086, 9, 5), make_new_order_info(24416, 9, 10), make_new_order_info(47294, 9, 7), make_new_order_info(90868, 9, 9), make_new_order_info(97909, 9, 4), make_new_order_info(7662, 9, 8), make_new_order_info(65533, 9, 10), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(7, 1, 1846, 0, 14, make_new_order_info(95164, 7, 4), make_new_order_info(61118, 7, 9), make_new_order_info(28605, 7, 4), make_new_order_info(6895, 7, 2), make_new_order_info(45783, 7, 10), make_new_order_info(35560, 7, 10), make_new_order_info(81653, 7, 1), make_new_order_info(40944, 7, 6), make_new_order_info(22128, 7, 3), make_new_order_info(73124, 7, 4), make_new_order_info(55287, 7, 7), make_new_order_info(24056, 7, 10), make_new_order_info(57312, 6, 8), make_new_order_info(48060, 7, 8), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(2, 3, 990, 0, 12, make_new_order_info(12128, 4, 8), make_new_order_info(85992, 2, 3), make_new_order_info(38656, 2, 8), make_new_order_info(79870, 2, 7), make_new_order_info(98304, 2, 10), make_new_order_info(73072, 2, 4), make_new_order_info(52978, 2, 9), make_new_order_info(32512, 2, 5), make_new_order_info(71163, 2, 4), make_new_order_info(12276, 2, 3), make_new_order_info(46974, 2, 6), make_new_order_info(81790, 2, 5), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(3, 4, 2006, 1, 14, make_new_order_info(24524, 3, 9), make_new_order_info(87525, 3, 9), make_new_order_info(81903, 3, 10), make_new_order_info(73016, 3, 2), make_new_order_info(7792, 3, 10), make_new_order_info(48000, 3, 8), make_new_order_info(89695, 3, 10), make_new_order_info(78710, 3, 5), make_new_order_info(97134, 3, 7), make_new_order_info(49072, 3, 6), make_new_order_info(89719, 3, 2), make_new_order_info(98144, 3, 1), make_new_order_info(65150, 3, 6), make_new_order_info(73711, 3, 5), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(7, 1, 352, 1, 6, make_new_order_info(57280, 7, 9), make_new_order_info(39936, 7, 3), make_new_order_info(24576, 7, 8), make_new_order_info(80892, 7, 10), make_new_order_info(83189, 7, 4), make_new_order_info(32368, 7, 9), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(10, 7, 1023, 0, 10, make_new_order_info(15836, 10, 7), make_new_order_info(81399, 10, 4), make_new_order_info(64983, 10, 10), make_new_order_info(24550, 10, 6), make_new_order_info(20976, 4, 8), make_new_order_info(63863, 10, 2), make_new_order_info(80314, 10, 6), make_new_order_info(4080, 10, 10), make_new_order_info(40936, 10, 8), make_new_order_info(8118, 10, 2), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(5, 7, 40, 1, 8, make_new_order_info(81919, 5, 8), make_new_order_info(65400, 5, 4), make_new_order_info(13822, 5, 7), make_new_order_info(24576, 5, 10), make_new_order_info(71551, 5, 1), make_new_order_info(40560, 5, 3), make_new_order_info(65272, 5, 4), make_new_order_info(48188, 5, 10), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(9, 3, 2560, 1, 13, make_new_order_info(68840, 9, 4), make_new_order_info(89790, 9, 8), make_new_order_info(73728, 9, 3), make_new_order_info(40896, 9, 8), make_new_order_info(12000, 9, 5), make_new_order_info(52524, 9, 10), make_new_order_info(20413, 9, 4), make_new_order_info(57344, 9, 7), make_new_order_info(89598, 9, 2), make_new_order_info(24550, 9, 6), make_new_order_info(12800, 9, 9), make_new_order_info(73162, 9, 10), make_new_order_info(6756, 9, 4), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(10, 3, 1776, 0, 9, make_new_order_info(90032, 10, 6), make_new_order_info(8192, 10, 9), make_new_order_info(47104, 10, 4), make_new_order_info(97792, 10, 6), make_new_order_info(48380, 10, 9), make_new_order_info(50772, 10, 2), make_new_order_info(23022, 10, 8), make_new_order_info(79808, 7, 8), make_new_order_info(31456, 10, 8), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(7, 3, 2551, 0, 9, make_new_order_info(96238, 7, 8), make_new_order_info(45823, 7, 9), make_new_order_info(56198, 7, 4), make_new_order_info(94155, 5, 1), make_new_order_info(56224, 7, 2), make_new_order_info(3872, 7, 3), make_new_order_info(65370, 7, 10), make_new_order_info(11792, 7, 5), make_new_order_info(46825, 7, 9), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(9, 4, 415, 0, 11, make_new_order_info(56926, 9, 7), make_new_order_info(6092, 10, 10), make_new_order_info(32620, 9, 4), make_new_order_info(28647, 9, 10), make_new_order_info(65184, 9, 5), make_new_order_info(23232, 9, 7), make_new_order_info(89594, 9, 1), make_new_order_info(20222, 9, 3), make_new_order_info(49022, 9, 10), make_new_order_info(32352, 9, 5), make_new_order_info(79728, 9, 2), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(2, 3, 956, 1, 8, make_new_order_info(24576, 2, 6), make_new_order_info(15224, 2, 3), make_new_order_info(79784, 2, 1), make_new_order_info(32112, 2, 10), make_new_order_info(49980, 2, 9), make_new_order_info(81888, 2, 4), make_new_order_info(37526, 2, 3), make_new_order_info(57151, 2, 4), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(8, 2, 1536, 1, 12, make_new_order_info(49146, 8, 10), make_new_order_info(65248, 8, 5), make_new_order_info(72348, 8, 1), make_new_order_info(59231, 8, 10), make_new_order_info(72679, 8, 9), make_new_order_info(89824, 8, 9), make_new_order_info(18928, 8, 3), make_new_order_info(7680, 8, 4), make_new_order_info(6101, 8, 2), make_new_order_info(89764, 8, 4), make_new_order_info(97208, 8, 10), make_new_order_info(3420, 8, 8), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(5, 3, 2944, 1, 9, make_new_order_info(92960, 5, 6), make_new_order_info(71166, 5, 1), make_new_order_info(39888, 5, 4), make_new_order_info(63484, 5, 5), make_new_order_info(15074, 5, 10), make_new_order_info(81918, 5, 8), make_new_order_info(73696, 5, 9), make_new_order_info(11775, 5, 8), make_new_order_info(89968, 5, 9), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0), make_new_order_info(0, 0, 0) )
DECLARE mycursor CURSOR FOR SELECT new_order(7, 10, 1017, 1, 12, make_new_order_info(83968, 7, 2...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
  AND d_id = $2
FOR UPDATE;UPDATE district
SET d_next_o_id = d_next_o_id + 1
WHERE d_w_id = $1
  AND d_id = $2;SELECT c_discount, c_last, c_credit
FROM customer
WHERE c_w_id = $1
  AND c_d_id = $2
  AND c_id...;INSERT INTO new_order (no_o_id, no_w_id, no_d_id)
VALUES ($1, $2, $3);INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d,
		    o_carrier_id, o_ol_cnt, o_all...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM stock
WHERE s_i_id = $2
  AND s_w_id = $3;UPDATE stock
SET s_quantity = s_quantity - $1
WHERE s_i_id = $2
  AND s_w_id = $3;INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number,
			ol_i_id, ol_supply_w_id, ol_del...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM sto...;
SELECT payment(8, 3, 0, 8, 3, 'CALLYBARABLE', 2287.110000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
FROM district
WHERE d_id = $1
  AN...;UPDATE district
SET d_ytd = d_ytd + $1
WHERE d_id = $2
  AND d_w_id = $3;SELECT c_id
FROM customer
WHERE c_w_id = $1
  AND c_d_id = $2
  AND c_last = $3
ORDER BY c_first ASC;
SELECT payment(7, 4, 0, 6, 1, 'ESEOUGHTOUGHT', 3180.460000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
FROM district
WHERE d_id = $1
  AN...;UPDATE district
SET d_ytd = d_ytd + $1
WHERE d_id = $2
  AND d_w_id = $3;SELECT c_id
FROM customer
WHERE c_w_id = $1
  AND c_d_id = $2
  AND c_last = $3
ORDER BY c_first ASC;SELECT c_first, c_middle, c_last, c_street_1, c_street_2, c_city,
       c_state, c_zip, c_phone...;UPDATE customer
SET c_balance = c_balance - $1,
    c_ytd_payment = c_ytd_payment + 1
WHERE c_id...;
SELECT payment(1, 10, 1982, 1, 10, '', 1534.610000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
FROM district
WHERE d_id = $1
  AN...;UPDATE district
SET d_ytd = d_ytd + $1
WHERE d_id = $2
  AND d_w_id = $3;SELECT c_first, c_middle, c_last, c_street_1, c_street_2, c_city,
       c_state, c_zip, c_phone...;
DECLARE mycursor CURSOR FOR SELECT new_order(2, 3, 71, 1, 10, make_new_order_info(89856, 2, 4), ...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
  AND d_id = $2
FOR UPDATE;UPDATE district
SET d_next_o_id = d_next_o_id + 1
WHERE d_w_id = $1
  AND d_id = $2;SELECT c_discount, c_last, c_credit
FROM customer
WHERE c_w_id = $1
  AND c_d_id = $2
  AND c_id...;INSERT INTO new_order (no_o_id, no_w_id, no_d_id)
VALUES ($1, $2, $3);INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d,
		    o_carrier_id, o_ol_cnt, o_all...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM stock
WHERE s_i_id = $2
  AND s_w_id = $3;UPDATE stock
SET s_quantity = s_quantity - $1
WHERE s_i_id = $2
  AND s_w_id = $3;INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number,
			ol_i_id, ol_supply_w_id, ol_del...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM sto...;
DECLARE mycursor CURSOR FOR SELECT new_order(10, 8, 2223, 1, 15, make_new_order_info(14302, 10, ...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
  AND d_id = $2
FOR UPDATE;UPDATE district
SET d_next_o_id = d_next_o_id + 1
WHERE d_w_id = $1
  AND d_id = $2;SELECT c_discount, c_last, c_credit
FROM customer
WHERE c_w_id = $1
  AND c_d_id = $2
  AND c_id...;INSERT INTO new_order (no_o_id, no_w_id, no_d_id)
VALUES ($1, $2, $3);INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d,
		    o_carrier_id, o_ol_cnt, o_all...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM stock
WHERE s_i_id = $2
  AND s_w_id = $3;UPDATE stock
SET s_quantity = s_quantity - $1
WHERE s_i_id = $2
  AND s_w_id = $3;INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number,
			ol_i_id, ol_supply_w_id, ol_del...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM sto...;
DECLARE mycursor CURSOR FOR SELECT new_order(9, 6, 1776, 1, 15, make_new_order_info(30711, 9, 8)...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
  AND d_id = $2
FOR UPDATE;UPDATE district
SET d_next_o_id = d_next_o_id + 1
WHERE d_w_id = $1
  AND d_id = $2;SELECT c_discount, c_last, c_credit
FROM customer
WHERE c_w_id = $1
  AND c_d_id = $2
  AND c_id...;INSERT INTO new_order (no_o_id, no_w_id, no_d_id)
VALUES ($1, $2, $3);INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d,
		    o_carrier_id, o_ol_cnt, o_all...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM stock
WHERE s_i_id = $2
  AND s_w_id = $3;UPDATE stock
SET s_quantity = s_quantity - $1
WHERE s_i_id = $2
  AND s_w_id = $3;INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number,
			ol_i_id, ol_supply_w_id, ol_del...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM sto...;
SELECT payment(5, 6, 686, 5, 6, '', 3196.450000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
FROM district
WHERE d_id = $1
  AN...;UPDATE district
SET d_ytd = d_ytd + $1
WHERE d_id = $2
  AND d_w_id = $3;SELECT c_first, c_middle, c_last, c_street_1, c_street_2, c_city,
       c_state, c_zip, c_phone...;UPDATE customer
SET c_balance = c_balance - $1,
    c_ytd_payment = c_ytd_payment + 1
WHERE c_id...;INSERT INTO history (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id,
		     h_date, h_amount, h_data...;
SELECT payment(7, 5, 0, 7, 5, 'EINGABLEBAR', 2012.920000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
FROM district
WHERE d_id = $1
  AN...;UPDATE district
SET d_ytd = d_ytd + $1
WHERE d_id = $2
  AND d_w_id = $3;SELECT c_id
FROM customer
WHERE c_w_id = $1
  AND c_d_id = $2
  AND c_last = $3
ORDER BY c_first ASC;SELECT c_first, c_middle, c_last, c_street_1, c_street_2, c_city,
       c_state, c_zip, c_phone...;UPDATE customer
SET c_balance = c_balance - $1,
    c_ytd_payment = c_ytd_payment + 1
WHERE c_id...;INSERT INTO history (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id,
		     h_date, h_amount, h_data...;
SELECT delivery(2, 3);SELECT no_o_id
FROM new_order
WHERE no_w_id = $1
  AND no_d_id = $2ORDER BY no_o_id LIMIT 1;DELETE FROM new_order
WHERE no_o_id = $1
  AND no_w_id = $2
  AND no_d_id = $3;SELECT o_c_id
FROM orders
WHERE o_id = $1
  AND o_w_id = $2
  AND o_d_id = $3;UPDATE orders
SET o_carrier_id = $1
WHERE o_id = $2
  AND o_w_id = $3
  AND o_d_id = $4;UPDATE order_line
SET ol_delivery_d = current_timestamp
WHERE ol_o_id = $1
  AND ol_w_id = $2
  ...;SELECT SUM(ol_amount * ol_quantity)
FROM order_line
WHERE ol_o_id = $1
  AND ol_w_id = $2
  AND ...;UPDATE customer
SET c_delivery_cnt = c_delivery_cnt + 1,
    c_balance = c_balance + $1
WHERE c_...;SELECT no_o_id
FROM new_order
WHERE no_w_id = $1
  AND no_d_id = $2ORDER BY no_o_id LIMIT 1;DELETE FROM new_order
WHERE no_o_id = $1
  AND no_w_id = $2
  AND no_d_id = $3;SELECT o_c_id
FROM orders
WHERE o_id = $1
  AND o_w_id = $2
  AND o_d_id = $3;UPDATE orders
SET o_carrier_id = $1
WHERE o_id = $2
  AND o_w_id = $3
  AND o_d_id = $4;
SELECT payment(6, 2, 0, 6, 2, 'BAROUGHTOUGHT', 2532.660000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
FROM district
WHERE d_id = $1
  AN...;UPDATE district
SET d_ytd = d_ytd + $1
WHERE d_id = $2
  AND d_w_id = $3;SELECT c_id
FROM customer
WHERE c_w_id = $1
  AND c_d_id = $2
  AND c_last = $3
ORDER BY c_first ASC;
SELECT payment(1, 9, 924, 1, 9, '', 690.670000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
FROM district
WHERE d_id = $1
  AN...;UPDATE district
SET d_ytd = d_ytd + $1
WHERE d_id = $2
  AND d_w_id = $3;SELECT c_first, c_middle, c_last, c_street_1, c_street_2, c_city,
       c_state, c_zip, c_phone...;UPDATE customer
SET c_balance = c_balance - $1,
    c_ytd_payment = c_ytd_payment + 1,
    c_dat...;INSERT INTO history (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id,
		     h_date, h_amount, h_data...;
DECLARE mycursor CURSOR FOR SELECT new_order(3, 2, 736, 1, 11, make_new_order_info(49102, 3, 2),...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
  AND d_id = $2
FOR UPDATE;UPDATE district
SET d_next_o_id = d_next_o_id + 1
WHERE d_w_id = $1
  AND d_id = $2;SELECT c_discount, c_last, c_credit
FROM customer
WHERE c_w_id = $1
  AND c_d_id = $2
  AND c_id...;INSERT INTO new_order (no_o_id, no_w_id, no_d_id)
VALUES ($1, $2, $3);INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d,
		    o_carrier_id, o_ol_cnt, o_all...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM stock
WHERE s_i_id = $2
  AND s_w_id = $3;UPDATE stock
SET s_quantity = s_quantity - $1
WHERE s_i_id = $2
  AND s_w_id = $3;INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number,
			ol_i_id, ol_supply_w_id, ol_del...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM sto...;
DECLARE mycursor CURSOR FOR SELECT new_order(3, 6, 2034, 1, 14, make_new_order_info(88702, 3, 9)...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
  AND d_id = $2
FOR UPDATE;UPDATE district
SET d_next_o_id = d_next_o_id + 1
WHERE d_w_id = $1
  AND d_id = $2;SELECT c_discount, c_last, c_credit
FROM customer
WHERE c_w_id = $1
  AND c_d_id = $2
  AND c_id...;INSERT INTO new_order (no_o_id, no_w_id, no_d_id)
VALUES ($1, $2, $3);INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d,
		    o_carrier_id, o_ol_cnt, o_all...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM stock
WHERE s_i_id = $2
  AND s_w_id = $3;UPDATE stock
SET s_quantity = s_quantity - $1
WHERE s_i_id = $2
  AND s_w_id = $3;INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number,
			ol_i_id, ol_supply_w_id, ol_del...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM sto...;
SELECT payment(8, 10, 902, 8, 10, '', 4936.950000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
FROM district
WHERE d_id = $1
  AN...;UPDATE district
SET d_ytd = d_ytd + $1
WHERE d_id = $2
  AND d_w_id = $3;SELECT c_first, c_middle, c_last, c_street_1, c_street_2, c_city,
       c_state, c_zip, c_phone...;UPDATE customer
SET c_balance = c_balance - $1,
    c_ytd_payment = c_ytd_payment + 1
WHERE c_id...;INSERT INTO history (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id,
		     h_date, h_amount, h_data...;
DECLARE mycursor CURSOR FOR SELECT new_order(8, 6, 8, 1, 9, make_new_order_info(8020, 8, 5), mak...;SELECT w_tax
FROM warehouse
WHERE w_id = $1;SELECT d_tax, d_next_o_id
FROM district 
WHERE d_w_id = $1
  AND d_id = $2
FOR UPDATE;UPDATE district
SET d_next_o_id = d_next_o_id + 1
WHERE d_w_id = $1
  AND d_id = $2;SELECT c_discount, c_last, c_credit
FROM customer
WHERE c_w_id = $1
  AND c_d_id = $2
  AND c_id...;INSERT INTO new_order (no_o_id, no_w_id, no_d_id)
VALUES ($1, $2, $3);INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d,
		    o_carrier_id, o_ol_cnt, o_all...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM stock
WHERE s_i_id = $2
  AND s_w_id = $3;UPDATE stock
SET s_quantity = s_quantity - $1
WHERE s_i_id = $2
  AND s_w_id = $3;INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number,
			ol_i_id, ol_supply_w_id, ol_del...;SELECT i_price, i_name, i_data
FROM item
WHERE i_id = $1;SELECT s_quantity, $1, s_data
FROM sto...;
SELECT payment(7, 1, 0, 7, 1, 'ABLEOUGHTESE', 4318.190000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
FROM district
WHERE d_id = $1
  AN...;UPDATE district
SET d_ytd = d_ytd + $1
WHERE d_id = $2
  AND d_w_id = $3;SELECT c_id
FROM customer
WHERE c_w_id = $1
  AND c_d_id = $2
  AND c_last = $3
ORDER BY c_first ASC;
SELECT payment(3, 5, 0, 3, 5, 'BARANTIPRI', 1983.660000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip
FROM warehouse
WHERE w_id = $1;UPDATE warehouse
SET w_ytd = w_ytd + $1
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip
FROM district
WHERE d_id = $1
  AN...;UPDATE district
SET d_ytd = d_ytd + $1
WHERE d_id = $2
  AND d_w_id = $3;SELECT c_id
FROM customer
WHERE c_w_id = $1
  AND c_d_id = $2
  AND c_last = $3
ORDER BY c_first ASC;
SELECT payment(7, 4, 0, 6, 1, 'ESEOUGHTOUGHT', 3180.460000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip\
FROM warehouse\
WHERE w_id = $1;UPDATE warehouse\
SET w_ytd = w_ytd + $1\
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip\
FROM district\
WHERE d_id = $1\
  AN...;UPDATE district\
SET d_ytd = d_ytd + $1\
WHERE d_id = $2\
  AND d_w_id = $3;SELECT c_id\
FROM customer\
WHERE c_w_id = $1\
  AND c_d_id = $2\
  AND c_last = $3\
ORDER BY c_first ASC;\
SELECT payment(7, 4, 0, 6, 1, 'ESEOUGHTOUGHT', 3180.460000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip\
FROM warehouse\
WHERE w_id = $1;UPDATE warehouse\
SET w_ytd = w_ytd + $1\
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip\
FROM district\
WHERE d_id = $1\
  AN...;UPDATE district\
SET d_ytd = d_ytd + $1\
WHERE d_id = $2\
  AND d_w_id = $3;SELECT c_id\
FROM customer\
WHERE c_w_id = $1\
  AND c_d_id = $2\
  AND c_last = $3\
ORDER BY c_first ASC;SELECT c_first, c_middle, c_last, c_street_1, c_street_2, c_city,\
       c_state, c_zip, c_phone...;UPDATE customer\
SET c_balance = c_balance - $1,\
    c_ytd_payment = c_ytd_payment + 1\
WHERE c_id...;
SELECT payment(8, 3, 0, 8, 3, 'CALLYBARABLE', 2287.110000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip\
FROM warehouse\
WHERE w_id = $1;UPDATE warehouse\
SET w_ytd = w_ytd + $1\
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip\
FROM district\
WHERE d_id = $1\
  AN...;UPDATE district\
SET d_ytd = d_ytd + $1\
WHERE d_id = $2\
  AND d_w_id = $3;SELECT c_id\
FROM customer\
WHERE c_w_id = $1\
  AND c_d_id = $2\
  AND c_last = $3\
ORDER BY c_first ASC;
SELECT payment(8, 3, 0, 8, 3, 'CALLYBARABLE', 2287.110000);SELECT w_name, w_street_1, w_street_2, w_city, w_state, w_zip\
FROM warehouse\
WHERE w_id = $1;UPDATE warehouse\
SET w_ytd = w_ytd + $1\
WHERE w_id = $2;SELECT d_name, d_street_1, d_street_2, d_city, d_state, d_zip\
FROM district\
WHERE d_id = $1\
  AN...;UPDATE district\
SET d_ytd = d_ytd + $1\
WHERE d_id = $2\
  AND d_w_id = $3;SELECT c_id\
FROM customer\
WHERE c_w_id = $1\
  AND c_d_id = $2\
  AND c_last = $3\
ORDER BY c_first ASC;\

This table shows the overview of entire this report.

Each line in this table shows statistic overview of a database.

* Small values may be shown as zero by round off.

This graph shows the trend of number of transactions per seconds.

Axes

Legend

This graph shows the database size over time.

Axes

Legend

This table shows the number of canceled queries for every database due to conflict with some activities on master during this report period. This table have values only when the instance is a standby server.

This table shows the overview of Write Ahead Logs.

This graph shows the trend of the rate of WAL output. One of the lines shows amount of WAL written during every snapshot interval and the another shows the amount divided by the snapshot interval.

Axes

Legend

This table shows the average percentage of time the backends spend in different state throughout this report period.

The data in this table is collected by the interval specified with the configuration parameter pg_statsinfo.sampling_interval (5 seconds by default).

This graph shows the percentage of time the backends spend in different states over time.

Axes

Legend

This graph shows average for every snapshot interval of the percentage of states collected by the interval specified with the configuration parameter pg_statsinfo.sampling_interval (5 seconds by default).

This graph shows the trend of percentage of time the CPU spends in different states.

Legend

Legend

This graph shows average percentage for every snapshot interval.

This graph shows system load averages over time.

Axes

Legend

This graph shows itemized memory usage over time. The values are read from /proc/meminfo.

Axes

Legend

Each row in this table shows the overview of a table space.

* Small values may be shown as zero by round off.

This section consists of one overview table and two graphs.

Each row in the Disk Usage per Table shows the disk usage overview of one table.

* Small values may be shown as zero by round off.

The Table Size Chart shows the table size ratios in different tables.

The Disk Read Chart shows the ratios of the number of blocks read from a table and its belongings in different tables.

This section consists of one overview table and three trend graphs. The graphs are hidden at first and comes out by clicking the corresponding links.

The I/O Usage Table shows the overview of I/O usage throughout the report period. Each row represents one device.

* Small values may be shown as zero by round off.

The I/O Rate Graph shows the read/write rate over snapshots. The values are the average in a snapshot.

Axes

Legend

The I/O Peak Rate Graph shows the read/write peak rate over snapshots. The values are the maximum within a snapshot. Available on pg_statsinfo 3.1 or later.

Axes

Legend

The I/O Time Graph shows the time spent by reading from or writing to the device over snapshots. The values are percentage of I/O time against real time and are the sums over all processes simultaneously running so they may go above 100 % for certain load.

Axes

Legend

Each row in this table shows the update activity overview of a table. The rows are shown in descending order of the "Total" field at first.

Each row in this table shows the scan activity overview of a table. The rows are shown in descending order of the "Seq scan" field at first.

Each rows in this table shows some figures related to filling factor of one table at the time of the latest snapshot in reportin period. The rows are shown in descending order of the "Tuples" field at first.

Each row in this table shows the fragmentation (correlation between physical and logical ordering) of one column. The correlation factor closer to zero means the stronger fragmentation of column. The rows are shown in descending order of the "Correlation" field at first.

Each row in this table shows usage statistics of one function. The rows are shown in descending order of the "Time/call" field at first.

Each row in this table shows execution statistics of a query. Multiple execitions by diffent users or on different databases of a statement have their own rows. This feature requires pg_stat_statsments to be installed.

Each row in this table shows execution statistics itemized by execution plan. Clicking Query ID opens the itemized execution plan statistics. This feature requires pg_stat_statements and pg_store_plans to be installed.

This table shows the list of long lasting transactions. Every snapshot holds certain number of longest transactions at the time of creation and the entries of the same transaction over snapshots are merged on generating report then the merged transactions are shown in this table, in descending order of their duration at first. Transactions are identified by the set of "PID", "Client address" and "Began at". pg_statsinfo.long_transaction_max specifies how many long transactions every snapshot records.

This table shows lock conflicts observed druing this report period.

This table shows the summary of checkpoint activity.

This table shows the overview of autovacuum activities. Each row corresponds to one table on which logged that autovacuums are done. This shows only tables that autovacuum has been done at least once in this report period.

This feature reuiqres autovacuum logs so set log_autovacuum_min_duration to 0 to make this feature fully available. Less logging reduces the completeness this table.

This table shows the I/O statistics for autovacuums. Each row corresponds to one table reported in autovacuum logs. This feature is available on PostgreSQL 9.2 or later.

This table shows the overview of autoanalyze activities. Each row corresponds to one table reported in autoanalyze logs.

This feature requires autovanalyze logs so set log_autovacuum_min_duration to 0 to make this feature fully available. Less logging reduces the completeness this table.

This graph shows how many rows are inserted, updated or deleted since last analyze for each table in percentage to all tuples including dead tuples, which is related to the threshold of autoanalyze.

Axes

Legend

To avoid losing readability of the graph, only ten largest tables in number of tuples are shown in this graph. The values are calculated as pg_stat_get_mod_since_analyze(table) / (reltuples of the table).

This table lists the cancellation events of autovacuums and autoanalyzes occurred during this report period.

This table shows the overview of replication activities at the end of reporting period. One column is shown for one replication session.

This graph shows how far the standby servers are behind this server.

Axes

Legend

Each rows in this table shows the overview of a database table.

* Small values may be shown as zero by round off.

Each rows in this table shows the overview of a index.

* Small values may be shown as zero by round off.

This table lists all run-time parameters.

This table lists the alerts issued during this report period.

Changing alert settings.

Update the alert setting table of the repository database to change alert settings.
Please see the pg_statsinfo manual for details.

e.g. Change the threshold of Rollback per seconds to "3000" for instance 1.

UPDATE statsrepo.alert SET rollback_tps = 3000 WHERE instid = 1;

This table shows the summary for profiling using system tap.

The log viewer shows the server log lines sotred in repository. This allows you to narrow down or search logs for specific events easily on GUI.

Search Options

This section determines how to restrict log lines fetched from repository. The fetched lines are shown in the Log Table below.

The Log Table

Each row in this table shows one log line. The first row in this table is quick filter fields, which will cleared by the Filter Reset button. You can select columns to show by the "Column" button. The following is the list of all available columns.


End of report