[repository1]
dbserver01:5432
begin:
2020-12-02 00:00
end:
2020-12-03 00:00
[repository1]
dbserver01:5432
begin:
2020-12-02 00:00
end:
2020-12-03 00:00
1
| Database system identifier | 6124488995257552289 |
|---|---|
| Host name | dbserver01 |
| Port ID | 5432 |
| PostgreSQL version | 13.1 |
| Begins at | 2020-12-02 16:13:00 |
| Ends at | 2020-12-02 17:13:00 |
| Period | 01:00:00 |
| Database size | 1055 MiB |
| Number of commits | 16532 |
| Number of rollbacks | 64 |
Time | Message |
|---|---|
| 2020-12-02 16:44:00 | load average 1min exceeds threshold in snapshot '2020-12-02 16:44:00' --- 7.19 (threshold = 7) |
| 2020-12-02 17:08:00 | load average 1min exceeds threshold in snapshot '2020-12-02 17:08:00' --- 8.09 (threshold = 7) |
Database | MiB | +MiB | Commit/s | Rollback/s | Hit% | Gets/s | Reads/s | Rows/s |
|---|---|---|---|---|---|---|---|---|
| dbt2 | 1054 | 33 | 4.592 | 0.018 | 95.1 | 828.519 | 40.425 | 772.807 |
|
Transactions Time Transactions per second 0 1 2 3 4 5 6 16:30 17:00 |
dbt2 commit_tps
dbt2 rollback_tps |
|
Database Size Time Database Size (Bytes) 1G 1.01G 1.02G 1.02G 1.03G 16:30 17:00 |
dbt2 size
|
Database | On tablespaces | On locks | On snapshots | On bufferpins | On deadlocks |
|---|---|---|---|---|---|
| dbt2 | 0 | 0 | 0 | 0 | 0 |
| Total size (MiB) | 1353.734 |
|---|---|
| Average output rate (MiB/s) | 0.376 |
| Number of archived files | 84 |
| Number of archiving errors | 0 |
| Latest WAL file | 0000000100000000000000CF |
| Last archived file | 0000000100000000000000CD |
|
WAL Write Rate Time Bytes per snapshot Write rate (Bytes/s) 16M 20M 24M 28M 272.84k 341.1k 409.37k 477.63k 16:30 17:00 |
Bytes/snapshot (Bytes)
Write rate (Bytes/s) |
idle (%) | idle in xact (%) | waiting (%) | running (%) |
|---|---|---|---|
| 65.2 | 0.1 | 2.3 | 32.5 |
|
Backend States Time Percent 0 20 40 60 80 100 16:30 17:00 |
idle
idle in xact waiting running |
| Written buffers by bgwriter | 20.571 |
|---|---|
| Written buffers by backends | 5.520 |
| bgwriter scans quitted earlier | 0.000 |
| fsyncs executed on backends | 0.000 |
| Allocated buffers | 24.841 |
|
Background Writer Statistics Time Buffer rate (buffers/s) Frequency (s-1) 0 20 40 60 80 100 120 0 0.18 0.37 0.55 0.73 0.92 1.1 16:30 17:00 |
Written buffers by bgwriter(L)
Written buffers by backends(L) Allocated buffers(L) bgwriter scans quitted earlier(R) fsyncs executed on backends(R) |
|
CPU Usage Time Percent 0 20 40 60 80 100 16:30 17:00 |
idle
iowait system user |
|
Load Average Time Load Average 0 2 4 6 8 16:30 17:00 |
1min
5min 15min |
|
Memory Usage (Linear Scale) Time Bytes 0 128M 256M 384M 512M 640M 768M 16:30 17:00 |
memfree
buffers cached swap dirty |
Tablespace | Location | Device | Used (MiB) | Avail (MiB) | Remain (%) |
|---|---|---|---|---|---|
| <pg_xlog_archive> | /home/statsinfo/var/archivelog | 8:2 | 11726 | 7294 | 38.3 |
| pg_default | /home/statsinfo/var/pgdata | 8:2 | 11726 | 7294 | 38.3 |
| pg_global | /home/statsinfo/var/pgdata | 8:2 | 11726 | 7294 | 38.3 |
Database | Schema | Table | Size (MiB) | Table reads | Index reads | Toast reads |
|---|---|---|---|---|---|---|
| dbt2 | public | stock | 347 | 47888 | 10153 | 0 |
| dbt2 | public | order_line | 282 | 3089 | 2684 | 0 |
| dbt2 | public | customer | 183 | 54125 | 15160 | 0 |
| dbt2 | public | history | 25 | 70 | 0 | 0 |
| dbt2 | public | orders | 19 | 719 | 5943 | 0 |
| dbt2 | public | item | 10 | 4524 | 229 | 0 |
| dbt2 | public | new_order | 4 | 515 | 58 | 0 |
| dbt2 | public | warehouse | 0 | 6 | 7 | 0 |
| dbt2 | public | district | 0 | 2 | 0 | 0 |
Device name | Containing table spaces | Read | Write | Average I/O queue | Total 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} | 3214 | 2766.40 | 10102852 | 7192 | 7156.00 | 167256520 | 55.500 | 177375832 |
| Toggle I/O Rate Graph | |
|
I/O Rate Time I/O Rate (Bytes/s) 512k 1M 1.5M 2M 2.5M 16:30 17:00 |
sda2 read
sda2 write |
| Toggle I/O Peak Rate Graph | |
|
I/O Peak Rate per Snapshot Interval Time I/O Peak Rate (Bytes/s) 1M 2M 3M 4M 5M 6M 7M 16:30 17:00 |
sda2 read
sda2 write |
| Toggle I/O Time Graph | |
|
I/O Time Time I/O Time (%) 0 2000 4000 6000 8000 10000 12000 16:30 17:00 |
sda2 avg read time
sda2 avg write time |
Database | Schema | Table | INSERT | UPDATE | DELETE | Total | HOT (%) |
|---|---|---|---|---|---|---|---|
| dbt2 | public | order_line | 71596 | 61831 | 0 | 133427 | 75.2 |
| dbt2 | public | stock | 0 | 71596 | 0 | 71596 | 0.0 |
| dbt2 | public | district | 0 | 13482 | 0 | 13482 | 99.8 |
| dbt2 | public | orders | 6801 | 6500 | 0 | 13301 | 80.5 |
| dbt2 | public | new_order | 6802 | 0 | 6410 | 13212 | 0.0 |
| dbt2 | public | customer | 0 | 13178 | 0 | 13178 | 22.0 |
| dbt2 | public | history | 6678 | 0 | 0 | 6678 | 0.0 |
| dbt2 | public | warehouse | 0 | 6678 | 0 | 6678 | 100.0 |
| dbt2 | public | item | 0 | 0 | 0 | 0 | 0.0 |
Database | Schema | Table | Seq scan | Seq tup read | Tup per seq | Hit ratio (%) |
|---|---|---|---|---|---|---|
| dbt2 | public | warehouse | 20699 | 201620 | 9.741 | 100.0 |
Database | Schema | Table | Tuples | Logical pages | Physical pages | L/P ratio (%) |
|---|---|---|---|---|---|---|
| dbt2 | public | order_line | 2920012 | 36050 | 36121 | 99.8 |
| dbt2 | public | stock | 999995 | 41667 | 44492 | 93.7 |
| dbt2 | public | orders | 306833 | 2557 | 2481 | 103.1 |
| dbt2 | public | history | 306792 | 3163 | 3295 | 96.0 |
| dbt2 | public | customer | 300000 | 23077 | 23424 | 98.5 |
| dbt2 | public | item | 100000 | 1235 | 1281 | 96.4 |
Database | Schema | Table | Column | Correlation |
|---|---|---|---|---|
| dbt2 | public | new_order | no_w_id | 0.914 |
| dbt2 | public | district | d_w_id | 0.368 |
| dbt2 | public | order_line | ol_d_id | 0.212 |
| dbt2 | public | customer | c_d_id | 0.199 |
| dbt2 | public | customer | c_d_id | 0.199 |
| dbt2 | public | orders | o_d_id | 0.195 |
| dbt2 | public | orders | o_d_id | 0.195 |
| dbt2 | public | new_order | no_d_id | 0.188 |
| dbt2 | public | new_order | no_o_id | 0.156 |
| dbt2 | public | district | d_id | 0.125 |
| dbt2 | public | stock | s_i_id | 0.096 |
| dbt2 | public | order_line | ol_number | 0.093 |
| dbt2 | public | orders | o_id | 0.019 |
| dbt2 | public | customer | c_id | 0.012 |
| dbt2 | public | customer | c_id | 0.012 |
| dbt2 | public | stock | s_quantity | 0.011 |
| dbt2 | public | order_line | ol_o_id | 0.009 |
| dbt2 | public | customer | c_last | 0.002 |
| dbt2 | public | customer | c_first | 0.000 |
| dbt2 | public | orders | o_c_id | -0.007 |
| dbt2 | public | warehouse | w_id | -0.086 |
Database | Schema | Function | Calls | Total time (ms) | Self time (ms) | Time/call (ms) |
|---|---|---|---|---|---|---|
| dbt2 | public | delivery | 650 | 540961.861 | 540961.861 | 832.249 |
| dbt2 | public | new_order | 6795 | 4373175.367 | 4373175.367 | 643.587 |
| dbt2 | public | order_status | 597 | 282199.495 | 282199.495 | 472.696 |
| dbt2 | public | stock_level | 613 | 284760.145 | 284760.145 | 464.535 |
| dbt2 | public | payment | 6677 | 2409754.691 | 2409754.691 | 360.904 |
| dbt2 | public | make_new_order_info | 101925 | 4285.806 | 4285.806 | 0.042 |
User | Database | Query | Calls | Total execution time (sec) | Average execution time (sec) | Plans | Total planning time (sec) | Average planning time (sec) |
|---|---|---|---|---|---|---|---|---|
| statsinfo | dbt2 | FETCH ALL IN mycursor | 6837 | 4403.686 | 0.644 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | SELECT payment(?, ?, ?, ?, ?, ?, ?) | 6695 | 2418.282 | 0.361 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | SELECT delivery(9, 10) | 653 | 542.343 | 0.831 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | SELECT stock_level(?, ?, ?) | 614 | 284.852 | 0.464 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | SELECT * FROM order_status(?, ?, ?, ?) | 599 | 282.590 | 0.472 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | 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 | 60 | 30.728 | 0.512 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | 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 | 60 | 24.886 | 0.415 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | 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 | 60 | 24.527 | 0.409 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | 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 | 60 | 24.434 | 0.407 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | CLOSE mycursor | 6837 | 1.781 | 0.000 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), relname, pid, mode, granted FROM pg_locks, pg_class WHERE relfilenode = relation ORDER BY relname;display full query string | 60 | 0.775 | 0.013 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | 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 | 60 | 0.747 | 0.012 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | BEGIN | 15458 | 0.431 | 0.000 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | COMMIT | 15394 | 0.338 | 0.000 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | 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[?] display full query string | 60 | 0.178 | 0.003 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | 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 | 60 | 0.141 | 0.002 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | 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 | 60 | 0.064 | 0.001 | 0 | 0.000 | 0 |
| statsinfo | dbt2 | 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(4 display full query string | 1 | 0.001 | 0.001 | 0 | 0.000 | 0 |
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) |
|||||||||||||||||||||||||||||||||||||
| 19099031651909903165 | statsinfo | dbt2 | 1 | 6695 | 2418.282 | 0.361 | 1734804.457 | 0.000 | |||||||||||||||||||||||||||||
| SELECT payment(?, ?, ?, ?, ?, ?, ?) | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
| 26944272042694427204 | statsinfo | dbt2 | 1 | 653 | 542.343 | 0.831 | 497424.434 | 0.000 | |||||||||||||||||||||||||||||
| SELECT delivery(9, 10) | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
| 26178946292617894629 | statsinfo | dbt2 | 1 | 614 | 284.852 | 0.464 | 274705.668 | 0.000 | |||||||||||||||||||||||||||||
| SELECT stock_level(?, ?, ?) | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
| 13666019181366601918 | statsinfo | dbt2 | 1 | 599 | 282.590 | 0.472 | 279756.681 | 0.000 | |||||||||||||||||||||||||||||
| SELECT * FROM order_status(?, ?, ?, ?) | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
| 25849186802584918680 | statsinfo | dbt2 | 1 | 60 | 30.728 | 0.512 | 0.000 | 0.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 | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
| 259851661259851661 | statsinfo | dbt2 | 1 | 60 | 24.886 | 0.415 | 0.000 | 0.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 | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
| 29240319902924031990 | statsinfo | dbt2 | 1 | 60 | 24.527 | 0.409 | 0.000 | 0.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 | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
| 11508820131150882013 | statsinfo | dbt2 | 1 | 60 | 24.434 | 0.407 | 0.000 | 0.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 | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
| 13808777591380877759 | statsinfo | dbt2 | 1 | 60 | 0.775 | 0.013 | 0.000 | 0.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 | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
| 91427219142721 | statsinfo | dbt2 | 1 | 60 | 0.747 | 0.012 | 0.000 | 0.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 | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
| 33922167763392216776 | statsinfo | dbt2 | 1 | 60 | 0.178 | 0.003 | 0.729 | 0.000 | |||||||||||||||||||||||||||||
| 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[?] display full query string | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
| 31162422833116242283 | statsinfo | dbt2 | 1 | 60 | 0.141 | 0.002 | 0.000 | 0.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 | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
| 20236183062023618306 | statsinfo | dbt2 | 1 | 60 | 0.064 | 0.001 | 0.000 | 0.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 | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
PID | Client address | Xact Start | Duration (sec) | Last query |
|---|---|---|---|---|
| 9214 | ::1 | 2020-12-02 16:58:50 | 19.766 | COMMIT |
| 9214 | ::1 | 2020-12-02 17:05:06 | 18.768 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:56:42 | 18.096 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:27:02 | 17.214 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:58:50 | 16.753 | FETCH ALL IN mycursor |
| 9202 | ::1 | 2020-12-02 16:58:50 | 16.679 | COMMIT |
| 9202 | ::1 | 2020-12-02 17:10:09 | 16.429 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:58:50 | 16.330 | FETCH ALL IN mycursor |
| 9210 | ::1 | 2020-12-02 16:45:34 | 15.877 | 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(97 display full query string |
| 9210 | ::1 | 2020-12-02 16:43:29 | 15.581 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:39:25 | 15.289 | COMMIT |
| 9204 | ::1 | 2020-12-02 17:05:10 | 15.197 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 16:45:35 | 14.808 | 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(35 display full query string |
| 9202 | ::1 | 2020-12-02 17:07:25 | 14.786 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:21:05 | 14.761 | COMMIT |
| 9221 | ::1 | 2020-12-02 17:07:25 | 14.559 | SELECT payment(10, 3, 0, 10, 3, 'EINGATIONPRI', 3625.400000) |
| 9221 | ::1 | 2020-12-02 16:45:36 | 14.420 | 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(73 display full query string |
| 9214 | ::1 | 2020-12-02 16:21:06 | 14.324 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:21:06 | 14.310 | FETCH ALL IN mycursor |
| 9219 | ::1 | 2020-12-02 16:58:52 | 14.280 | FETCH ALL IN mycursor |
| 9212 | ::1 | 2020-12-02 16:45:36 | 14.253 | 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(4 display full query string |
| 9202 | ::1 | 2020-12-02 16:45:36 | 14.169 | 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(323 display full query string |
| 9210 | ::1 | 2020-12-02 17:05:11 | 14.162 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:45:36 | 14.085 | 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_i display full query string |
| 9212 | ::1 | 2020-12-02 17:07:26 | 14.055 | COMMIT |
| 9219 | ::1 | 2020-12-02 17:01:06 | 14.049 | COMMIT |
| 9212 | ::1 | 2020-12-02 17:01:06 | 14.049 | COMMIT |
| 9206 | ::1 | 2020-12-02 17:07:26 | 14.035 | COMMIT |
| 9214 | ::1 | 2020-12-02 17:07:26 | 14.029 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 16:45:36 | 14.009 | 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(4056 display full query string |
| 9206 | ::1 | 2020-12-02 16:58:53 | 13.978 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 16:21:06 | 13.920 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 17:07:26 | 13.891 | COMMIT |
| 9202 | ::1 | 2020-12-02 17:05:11 | 13.875 | COMMIT |
| 9217 | ::1 | 2020-12-02 17:05:11 | 13.770 | COMMIT |
| 9221 | ::1 | 2020-12-02 17:05:11 | 13.770 | COMMIT |
| 9219 | ::1 | 2020-12-02 17:05:11 | 13.769 | COMMIT |
| 9208 | ::1 | 2020-12-02 17:05:11 | 13.769 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:43:31 | 13.761 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:43:31 | 13.761 | COMMIT |
| 9219 | ::1 | 2020-12-02 17:07:26 | 13.681 | SELECT payment(6, 4, 0, 6, 4, 'BAROUGHTPRES', 3143.310000) |
| 9208 | ::1 | 2020-12-02 17:07:26 | 13.675 | FETCH ALL IN mycursor |
| 9219 | ::1 | 2020-12-02 16:39:27 | 13.585 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:39:27 | 13.583 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:39:27 | 13.582 | COMMIT |
| 9204 | ::1 | 2020-12-02 17:07:26 | 13.519 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 17:01:02 | 13.252 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:56:42 | 12.992 | FETCH ALL IN mycursor |
| 9212 | ::1 | 2020-12-02 17:05:12 | 12.922 | COMMIT |
| 9210 | ::1 | 2020-12-02 17:09:37 | 12.865 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:56:42 | 12.859 | FETCH ALL IN mycursor |
| 9204 | ::1 | 2020-12-02 17:12:22 | 12.685 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:56:42 | 12.652 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:43:38 | 12.520 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 16:43:38 | 12.516 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:43:38 | 12.515 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:43:38 | 12.510 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:43:38 | 12.505 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:56:43 | 12.496 | SELECT delivery(7, 8) |
| 9202 | ::1 | 2020-12-02 17:09:38 | 12.493 | COMMIT |
| 9212 | ::1 | 2020-12-02 17:00:53 | 11.875 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:39:08 | 11.600 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:50:03 | 11.599 | FETCH ALL IN mycursor |
| 9214 | ::1 | 2020-12-02 16:50:03 | 11.599 | FETCH ALL IN mycursor |
| 10180 | 2020-12-02 16:45:38 | 11.533 | ||
| 9210 | ::1 | 2020-12-02 16:39:09 | 11.527 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:54:29 | 11.512 | SELECT delivery(4, 5) |
| 9204 | ::1 | 2020-12-02 16:29:04 | 11.380 | COMMIT |
| 9204 | ::1 | 2020-12-02 17:09:39 | 11.380 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:39:09 | 11.371 | COMMIT |
| 9210 | ::1 | 2020-12-02 17:01:04 | 11.257 | COMMIT |
| 9206 | ::1 | 2020-12-02 17:05:14 | 11.245 | COMMIT |
| 9208 | ::1 | 2020-12-02 17:09:39 | 10.962 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:52:19 | 10.932 | FETCH ALL IN mycursor |
| 9204 | ::1 | 2020-12-02 16:58:49 | 10.903 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:56:39 | 10.886 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:43:49 | 10.804 | 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(52 display full query string |
| 9204 | ::1 | 2020-12-02 16:43:49 | 10.803 | 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_inf display full query string |
| 9221 | ::1 | 2020-12-02 17:10:05 | 10.544 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:29:05 | 10.501 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:39:10 | 10.355 | COMMIT |
| 9221 | ::1 | 2020-12-02 17:12:35 | 10.342 | COMMIT |
| 9202 | ::1 | 2020-12-02 17:12:35 | 10.342 | COMMIT |
| 9217 | ::1 | 2020-12-02 17:12:35 | 10.341 | COMMIT |
| 9208 | ::1 | 2020-12-02 17:12:35 | 10.335 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:39:10 | 10.309 | COMMIT |
| 9219 | ::1 | 2020-12-02 17:12:25 | 10.144 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:26:50 | 10.129 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:59:00 | 10.104 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:39:10 | 10.031 | SELECT payment(6, 10, 0, 6, 10, 'ABLEOUGHTCALLY', 881.320000) |
| 9210 | ::1 | 2020-12-02 17:07:25 | 9.808 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:52:20 | 9.777 | SELECT payment(8, 1, 0, 8, 1, 'EINGEINGCALLY', 3754.150000) |
| 9214 | ::1 | 2020-12-02 17:01:05 | 9.719 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:26:50 | 9.713 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 17:00:50 | 9.712 | COMMIT |
| 9210 | ::1 | 2020-12-02 17:12:26 | 9.640 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:56:51 | 9.624 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:41:26 | 9.467 | COMMIT |
| 9210 | ::1 | 2020-12-02 17:12:36 | 9.466 | COMMIT |
| 9219 | ::1 | 2020-12-02 17:12:36 | 9.466 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:21:06 | 9.446 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:41:36 | 9.433 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:41:31 | 9.432 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:41:26 | 9.418 | COMMIT |
| 9221 | ::1 | 2020-12-02 17:10:16 | 9.405 | SELECT stock_level(10, 10, 14) |
| 9214 | ::1 | 2020-12-02 17:10:06 | 9.401 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 16:41:36 | 9.320 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:26:51 | 9.312 | FETCH ALL IN mycursor |
| 9202 | ::1 | 2020-12-02 16:41:36 | 9.306 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:21:06 | 9.294 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:41:36 | 9.219 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:49:46 | 9.193 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:26:51 | 9.168 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:26:51 | 9.149 | FETCH ALL IN mycursor |
| 9210 | ::1 | 2020-12-02 16:23:01 | 9.041 | COMMIT |
| 10666 | 2020-12-02 17:12:36 | 8.996 | autovacuum: VACUUM ANALYZE public.warehouse | |
| 9221 | ::1 | 2020-12-02 16:41:26 | 8.993 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:23:01 | 8.982 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:41:26 | 8.970 | COMMIT |
| 9221 | ::1 | 2020-12-02 17:09:41 | 8.965 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:41:26 | 8.949 | COMMIT |
| 9210 | ::1 | 2020-12-02 17:01:16 | 8.897 | SELECT payment(8, 4, 0, 6, 7, 'BARPRESCALLY', 2334.020000) |
| 9202 | ::1 | 2020-12-02 17:01:11 | 8.840 | COMMIT |
| 9217 | ::1 | 2020-12-02 17:01:11 | 8.840 | COMMIT |
| 9204 | ::1 | 2020-12-02 17:01:11 | 8.835 | COMMIT |
| 9210 | ::1 | 2020-12-02 17:00:51 | 8.772 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:52:31 | 8.734 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:58:51 | 8.690 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:52:31 | 8.671 | SELECT stock_level(7, 9, 20) |
| 9208 | ::1 | 2020-12-02 16:52:31 | 8.670 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:52:31 | 8.667 | FETCH ALL IN mycursor |
| 9210 | ::1 | 2020-12-02 16:50:01 | 8.666 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:50:01 | 8.666 | SELECT delivery(1, 5) |
| 9219 | ::1 | 2020-12-02 16:52:31 | 8.666 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:52:31 | 8.665 | SELECT delivery(4, 4) |
| 9204 | ::1 | 2020-12-02 16:52:31 | 8.655 | FETCH ALL IN mycursor |
| 9221 | ::1 | 2020-12-02 16:50:06 | 8.644 | FETCH ALL IN mycursor |
| 9221 | ::1 | 2020-12-02 16:23:02 | 8.643 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:26:51 | 8.636 | FETCH ALL IN mycursor |
| 9202 | ::1 | 2020-12-02 16:52:17 | 8.568 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:26:52 | 8.500 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:27:12 | 8.472 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:23:02 | 8.464 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:23:02 | 8.442 | COMMIT |
| 9219 | ::1 | 2020-12-02 17:09:42 | 8.412 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:21:07 | 8.383 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:36:52 | 8.359 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 16:49:42 | 8.326 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:26:52 | 8.263 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 16:23:02 | 8.195 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:37:12 | 8.119 | FETCH ALL IN mycursor |
| 9202 | ::1 | 2020-12-02 16:36:52 | 8.118 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 16:56:42 | 8.052 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:36:52 | 8.031 | FETCH ALL IN mycursor |
| 9204 | ::1 | 2020-12-02 16:46:02 | 8.020 | COMMIT |
| 9212 | ::1 | 2020-12-02 17:03:12 | 7.953 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 17:10:17 | 7.940 | SELECT stock_level(2, 4, 14) |
| 9214 | ::1 | 2020-12-02 16:23:07 | 7.918 | COMMIT |
| 9206 | ::1 | 2020-12-02 17:10:17 | 7.904 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:29:02 | 7.859 | COMMIT |
| 9219 | ::1 | 2020-12-02 17:10:17 | 7.848 | FETCH ALL IN mycursor |
| 9202 | ::1 | 2020-12-02 16:56:42 | 7.838 | COMMIT |
| 9214 | ::1 | 2020-12-02 17:00:52 | 7.664 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:58:52 | 7.651 | COMMIT |
| 9212 | ::1 | 2020-12-02 17:10:18 | 7.635 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 17:00:52 | 7.605 | COMMIT |
| 9214 | ::1 | 2020-12-02 17:10:18 | 7.593 | COMMIT |
| 9219 | ::1 | 2020-12-02 17:03:13 | 7.567 | FETCH ALL IN mycursor |
| 9221 | ::1 | 2020-12-02 17:00:52 | 7.557 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:56:43 | 7.524 | COMMIT |
| 9217 | ::1 | 2020-12-02 17:09:43 | 7.507 | COMMIT |
| 9214 | ::1 | 2020-12-02 17:09:43 | 7.486 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:32:53 | 7.349 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:29:03 | 7.327 | COMMIT |
| 9221 | ::1 | 2020-12-02 17:03:13 | 7.316 | FETCH ALL IN mycursor |
| 9202 | ::1 | 2020-12-02 17:03:13 | 7.253 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 16:54:28 | 7.251 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:54:28 | 7.244 | FETCH ALL IN mycursor |
| 9219 | ::1 | 2020-12-02 16:29:03 | 7.242 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:29:03 | 7.163 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:45:43 | 7.094 | 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(387 display full query string |
| 9217 | ::1 | 2020-12-02 16:45:43 | 7.082 | 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(2 display full query string |
| 9214 | ::1 | 2020-12-02 16:33:13 | 7.078 | COMMIT |
| 9214 | ::1 | 2020-12-02 17:03:13 | 7.066 | SELECT payment(1, 4, 2046, 1, 4, '', 1266.560000) |
| 9206 | ::1 | 2020-12-02 16:33:13 | 7.065 | <IDLE> in transaction |
| 9217 | ::1 | 2020-12-02 16:33:13 | 7.063 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:33:13 | 7.063 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:33:13 | 7.061 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:54:28 | 7.060 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:46:03 | 7.048 | COMMIT |
| 9210 | ::1 | 2020-12-02 17:03:13 | 7.022 | SELECT * FROM order_status(1501, 9, 7, '') |
| 9221 | ::1 | 2020-12-02 16:33:13 | 7.010 | COMMIT |
| 9204 | ::1 | 2020-12-02 17:03:13 | 6.967 | SELECT payment(8, 4, 0, 5, 4, 'EINGATIONEING', 2348.990000) |
| 9206 | ::1 | 2020-12-02 17:03:13 | 6.908 | FETCH ALL IN mycursor |
| 9219 | ::1 | 2020-12-02 16:36:53 | 6.851 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 16:32:53 | 6.826 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 16:32:53 | 6.815 | SELECT payment(10, 7, 0, 3, 8, 'ESEOUGHTOUGHT', 995.570000) |
| 9208 | ::1 | 2020-12-02 17:00:53 | 6.768 | COMMIT |
| 9212 | ::1 | 2020-12-02 17:09:43 | 6.714 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:32:53 | 6.695 | SELECT payment(7, 4, 0, 6, 1, 'ESEOUGHTOUGHT', 3180.460000) |
| 9212 | ::1 | 2020-12-02 17:10:08 | 6.694 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:36:53 | 6.680 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 16:36:53 | 6.675 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:29:03 | 6.648 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:30:44 | 6.592 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:50:03 | 6.573 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:50:03 | 6.573 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:50:03 | 6.573 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:50:03 | 6.573 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:50:03 | 6.572 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:32:54 | 6.547 | FETCH ALL IN mycursor |
| 9204 | ::1 | 2020-12-02 16:36:54 | 6.526 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 17:03:14 | 6.514 | SELECT payment(10, 1, 0, 10, 1, 'ABLEABLEPRI', 4858.950000) |
| 9204 | ::1 | 2020-12-02 16:54:29 | 6.490 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 16:54:29 | 6.490 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:54:29 | 6.490 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:49:44 | 6.454 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:30:49 | 6.433 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:32:54 | 6.422 | SELECT payment(7, 5, 1008, 7, 5, '', 1451.580000) |
| 9208 | ::1 | 2020-12-02 17:03:14 | 6.347 | SELECT payment(6, 4, 255, 6, 4, '', 4154.910000) |
| 9214 | ::1 | 2020-12-02 16:36:54 | 6.321 | SELECT * FROM order_status(2616, 1, 7, '') |
| 9221 | ::1 | 2020-12-02 16:36:54 | 6.256 | SELECT delivery(6, 3) |
| 9221 | ::1 | 2020-12-02 16:32:54 | 6.252 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 16:32:54 | 6.197 | FETCH ALL IN mycursor |
| 9204 | ::1 | 2020-12-02 16:49:44 | 6.151 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:49:44 | 6.150 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:24:49 | 6.134 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:54:29 | 6.090 | FETCH ALL IN mycursor |
| 9212 | ::1 | 2020-12-02 16:54:29 | 6.089 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:54:29 | 6.089 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:24:49 | 5.837 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 16:30:44 | 5.731 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:48:09 | 5.718 | FETCH ALL IN mycursor |
| 9214 | ::1 | 2020-12-02 16:48:09 | 5.588 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:58:50 | 5.588 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:29:05 | 5.551 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:30:50 | 5.460 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:30:50 | 5.460 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:30:50 | 5.458 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:21:05 | 5.447 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:47:55 | 5.353 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:49:40 | 5.282 | COMMIT |
| 9221 | ::1 | 2020-12-02 17:06:55 | 5.247 | SELECT delivery(4, 3) |
| 9214 | ::1 | 2020-12-02 16:32:55 | 5.215 | SELECT payment(8, 6, 72, 1, 1, '', 3622.380000) |
| 9219 | ::1 | 2020-12-02 16:23:00 | 5.198 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:59:05 | 5.153 | SELECT delivery(9, 10) |
| 9210 | ::1 | 2020-12-02 16:36:55 | 5.141 | SELECT payment(6, 3, 748, 6, 3, '', 3484.640000) |
| 9210 | ::1 | 2020-12-02 16:30:50 | 5.129 | COMMIT |
| 9212 | ::1 | 2020-12-02 17:08:00 | 5.075 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:32:55 | 5.071 | SELECT payment(6, 8, 0, 6, 8, 'PRESESEOUGHT', 2771.520000) |
| 9219 | ::1 | 2020-12-02 16:30:50 | 5.058 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:19:05 | 5.048 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:29:10 | 5.039 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:29:10 | 5.012 | SELECT payment(3, 2, 0, 3, 2, 'CALLYESEEING', 870.610000) |
| 9212 | ::1 | 2020-12-02 16:30:50 | 4.978 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:30:50 | 4.974 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:46:00 | 4.974 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:46:00 | 4.881 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:46:00 | 4.879 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:46:00 | 4.877 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:46:00 | 4.875 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:46:00 | 4.874 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:46:00 | 4.872 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:46:00 | 4.871 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:21:15 | 4.865 | SELECT payment(10, 9, 0, 10, 9, 'PRIANTICALLY', 345.170000) |
| 9210 | ::1 | 2020-12-02 16:34:55 | 4.858 | FETCH ALL IN mycursor |
| 9221 | ::1 | 2020-12-02 16:47:55 | 4.803 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 16:34:55 | 4.766 | FETCH ALL IN mycursor |
| 9202 | ::1 | 2020-12-02 16:49:40 | 4.669 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:34:55 | 4.629 | SELECT payment(1, 10, 1982, 1, 10, '', 1534.610000) |
| 9219 | ::1 | 2020-12-02 17:06:55 | 4.622 | COMMIT |
| 9217 | ::1 | 2020-12-02 17:08:01 | 4.615 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:35:06 | 4.572 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:35:06 | 4.572 | FETCH ALL IN mycursor |
| 9221 | ::1 | 2020-12-02 16:35:06 | 4.572 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:34:56 | 4.565 | SELECT payment(1, 5, 0, 1, 5, 'ABLEESEOUGHT', 2693.210000) |
| 9214 | ::1 | 2020-12-02 16:33:05 | 4.549 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:33:05 | 4.544 | COMMIT |
| 9214 | ::1 | 2020-12-02 17:08:01 | 4.509 | FETCH ALL IN mycursor |
| 9214 | ::1 | 2020-12-02 16:49:41 | 4.506 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:37:12 | 4.502 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:37:12 | 4.501 | FETCH ALL IN mycursor |
| 9210 | ::1 | 2020-12-02 16:37:12 | 4.499 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 16:34:56 | 4.460 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 17:08:01 | 4.452 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 17:08:01 | 4.452 | COMMIT |
| 9219 | ::1 | 2020-12-02 17:08:01 | 4.451 | COMMIT |
| 9204 | ::1 | 2020-12-02 17:08:01 | 4.449 | FETCH ALL IN mycursor |
| 9221 | ::1 | 2020-12-02 16:31:11 | 4.448 | FETCH ALL IN mycursor |
| 9221 | ::1 | 2020-12-02 17:08:01 | 4.447 | COMMIT |
| 9210 | ::1 | 2020-12-02 17:08:01 | 4.447 | FETCH ALL IN mycursor |
| 9204 | ::1 | 2020-12-02 16:23:01 | 4.398 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:31:11 | 4.379 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 16:31:11 | 4.373 | FETCH ALL IN mycursor |
| 9204 | ::1 | 2020-12-02 17:00:56 | 4.308 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:34:56 | 4.305 | FETCH ALL IN mycursor |
| 9219 | ::1 | 2020-12-02 17:00:51 | 4.305 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:22:36 | 4.293 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:34:56 | 4.249 | SELECT payment(10, 4, 0, 7, 7, 'CALLYANTICALLY', 1240.730000) |
| 9219 | ::1 | 2020-12-02 16:49:41 | 4.226 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:21:06 | 4.214 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:47:56 | 4.200 | SELECT payment(1, 10, 68, 1, 10, '', 1773.420000) |
| 9217 | ::1 | 2020-12-02 16:47:56 | 4.193 | SELECT * FROM order_status(0, 6, 4, 'OUGHTPRIEING') |
| 9210 | ::1 | 2020-12-02 16:49:46 | 4.191 | FETCH ALL IN mycursor |
| 9204 | ::1 | 2020-12-02 17:06:56 | 4.156 | FETCH ALL IN mycursor |
| 9204 | ::1 | 2020-12-02 16:34:56 | 4.131 | FETCH ALL IN mycursor |
| 9202 | ::1 | 2020-12-02 17:06:56 | 4.075 | SELECT payment(3, 9, 724, 6, 1, '', 2953.930000) |
| 9204 | ::1 | 2020-12-02 16:26:51 | 4.074 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:48:11 | 4.070 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:35:16 | 3.957 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:35:16 | 3.946 | COMMIT |
| 9208 | ::1 | 2020-12-02 17:06:56 | 3.941 | FETCH ALL IN mycursor |
| 9204 | ::1 | 2020-12-02 16:23:06 | 3.932 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:26:36 | 3.897 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:24:36 | 3.896 | COMMIT |
| 9204 | ::1 | 2020-12-02 17:00:51 | 3.817 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:35:16 | 3.802 | FETCH ALL IN mycursor |
| 9219 | ::1 | 2020-12-02 16:33:01 | 3.760 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:47:56 | 3.737 | SELECT * FROM order_status(0, 2, 5, 'ANTIBARPRES') |
| 9202 | ::1 | 2020-12-02 16:37:16 | 3.719 | SELECT delivery(6, 7) |
| 9214 | ::1 | 2020-12-02 16:33:01 | 3.712 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:20:36 | 3.682 | FETCH ALL IN mycursor |
| 9212 | ::1 | 2020-12-02 16:18:56 | 3.668 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:20:36 | 3.638 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 16:15:01 | 3.633 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:18:56 | 3.617 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:35:17 | 3.609 | FETCH ALL IN mycursor |
| 9212 | ::1 | 2020-12-02 17:06:56 | 3.594 | SELECT stock_level(6, 9, 19) |
| 9219 | ::1 | 2020-12-02 16:18:56 | 3.566 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 16:24:36 | 3.557 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:40:57 | 3.554 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 17:06:56 | 3.537 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 16:35:17 | 3.488 | FETCH ALL IN mycursor |
| 9214 | ::1 | 2020-12-02 16:47:57 | 3.455 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 16:34:27 | 3.441 | COMMIT |
| 9210 | ::1 | 2020-12-02 17:06:57 | 3.366 | SELECT payment(6, 8, 0, 6, 8, 'ABLEESEOUGHT', 107.060000) |
| 9202 | ::1 | 2020-12-02 16:47:57 | 3.276 | SELECT * FROM order_status(2158, 9, 10, '') |
| 9202 | ::1 | 2020-12-02 16:34:57 | 3.188 | COMMIT |
| 9214 | ::1 | 2020-12-02 17:06:57 | 3.187 | SELECT payment(5, 7, 0, 5, 7, 'BARABLEPRI', 2391.720000) |
| 9206 | ::1 | 2020-12-02 17:06:57 | 3.161 | SELECT payment(5, 3, 0, 5, 3, 'ATIONATIONEING', 3891.960000) |
| 9206 | ::1 | 2020-12-02 16:37:17 | 3.090 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:37:17 | 3.090 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:47:57 | 3.088 | FETCH ALL IN mycursor |
| 9202 | ::1 | 2020-12-02 16:40:57 | 3.083 | FETCH ALL IN mycursor |
| 9733 | 2020-12-02 16:20:37 | 3.071 | autovacuum: VACUUM ANALYZE public.district | |
| 9217 | ::1 | 2020-12-02 16:18:57 | 3.058 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:22:37 | 3.051 | FETCH ALL IN mycursor |
| 9219 | ::1 | 2020-12-02 16:27:42 | 3.006 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:22:37 | 2.991 | FETCH ALL IN mycursor |
| 9221 | ::1 | 2020-12-02 16:22:37 | 2.964 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:40:57 | 2.903 | FETCH ALL IN mycursor |
| 9210 | ::1 | 2020-12-02 16:37:17 | 2.849 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 16:37:17 | 2.848 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:37:17 | 2.847 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:57:07 | 2.847 | SELECT payment(9, 9, 0, 9, 9, 'BARABLEOUGHT', 1201.480000) |
| 9221 | ::1 | 2020-12-02 16:16:57 | 2.841 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:16:47 | 2.822 | COMMIT |
| 9206 | ::1 | 2020-12-02 17:09:42 | 2.809 | COMMIT |
| 9202 | ::1 | 2020-12-02 17:08:02 | 2.798 | SELECT payment(5, 6, 0, 5, 6, 'ATIONPRIOUGHT', 745.720000) |
| 9202 | ::1 | 2020-12-02 16:51:27 | 2.791 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:16:47 | 2.773 | FETCH ALL IN mycursor |
| 9210 | ::1 | 2020-12-02 16:51:27 | 2.751 | SELECT payment(5, 3, 0, 5, 3, 'BAROUGHTPRI', 3662.540000) |
| 9212 | ::1 | 2020-12-02 16:57:07 | 2.739 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:57:07 | 2.738 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:57:07 | 2.732 | FETCH ALL IN mycursor |
| 9214 | ::1 | 2020-12-02 16:57:07 | 2.727 | SELECT * FROM order_status(0, 7, 9, 'ESEOUGHTOUGHT') |
| 9204 | ::1 | 2020-12-02 16:57:07 | 2.721 | SELECT stock_level(5, 4, 17) |
| 9219 | ::1 | 2020-12-02 16:57:07 | 2.721 | SELECT stock_level(4, 3, 10) |
| 9206 | ::1 | 2020-12-02 16:18:57 | 2.700 | FETCH ALL IN mycursor |
| 9212 | ::1 | 2020-12-02 16:35:18 | 2.662 | FETCH ALL IN mycursor |
| 9210 | ::1 | 2020-12-02 16:38:57 | 2.635 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:19:02 | 2.593 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 16:19:02 | 2.593 | FETCH ALL IN mycursor |
| 9210 | ::1 | 2020-12-02 16:18:57 | 2.586 | FETCH ALL IN mycursor |
| 9202 | ::1 | 2020-12-02 16:22:38 | 2.584 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:38:57 | 2.580 | SELECT payment(9, 3, 0, 9, 3, 'CALLYANTIANTI', 4143.050000) |
| 9208 | ::1 | 2020-12-02 16:24:37 | 2.578 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:47:57 | 2.571 | FETCH ALL IN mycursor |
| 9212 | ::1 | 2020-12-02 16:15:02 | 2.571 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:20:37 | 2.566 | SELECT stock_level(9, 8, 19) |
| 9206 | ::1 | 2020-12-02 16:24:58 | 2.549 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:24:58 | 2.549 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:24:58 | 2.547 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:24:58 | 2.546 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:24:58 | 2.545 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:51:28 | 2.491 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 16:51:28 | 2.491 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:47:58 | 2.478 | SELECT payment(8, 9, 1008, 8, 9, '', 3835.470000) |
| 9202 | ::1 | 2020-12-02 16:35:18 | 2.466 | SELECT payment(2, 7, 1939, 2, 7, '', 1425.940000) |
| 9210 | ::1 | 2020-12-02 16:22:38 | 2.465 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 16:16:48 | 2.451 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:16:43 | 2.451 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 16:38:58 | 2.440 | SELECT delivery(7, 2) |
| 9206 | ::1 | 2020-12-02 16:40:58 | 2.439 | FETCH ALL IN mycursor |
| 9214 | ::1 | 2020-12-02 16:40:58 | 2.393 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 17:02:48 | 2.326 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:38:58 | 2.313 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:14:48 | 2.309 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:15:08 | 2.305 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:15:08 | 2.305 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:40:58 | 2.302 | SELECT payment(7, 5, 0, 7, 5, 'EINGABLEBAR', 2012.920000) |
| 9221 | ::1 | 2020-12-02 16:20:38 | 2.301 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:16:48 | 2.301 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:22:38 | 2.296 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:18:58 | 2.286 | SELECT payment(7, 10, 0, 7, 10, 'PRESANTIPRI', 1871.170000) |
| 9206 | ::1 | 2020-12-02 16:51:28 | 2.252 | FETCH ALL IN mycursor |
| 9210 | ::1 | 2020-12-02 16:20:58 | 2.247 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 16:27:43 | 2.243 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:48:18 | 2.225 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:16:53 | 2.208 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:27:43 | 2.200 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:18:58 | 2.196 | FETCH ALL IN mycursor |
| 9219 | ::1 | 2020-12-02 16:38:58 | 2.190 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:48:18 | 2.175 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:51:28 | 2.153 | FETCH ALL IN mycursor |
| 9221 | ::1 | 2020-12-02 16:18:58 | 2.152 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:16:48 | 2.146 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:40:58 | 2.142 | FETCH ALL IN mycursor |
| 9219 | ::1 | 2020-12-02 16:20:58 | 2.142 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:17:43 | 2.124 | FETCH ALL IN mycursor |
| 9202 | ::1 | 2020-12-02 17:02:48 | 2.118 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:16:48 | 2.097 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:55:13 | 2.085 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:51:43 | 2.046 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:16:58 | 2.000 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:25:09 | 1.994 | 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(818 display full query string |
| 9212 | ::1 | 2020-12-02 16:25:09 | 1.993 | 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(81 display full query string |
| 9219 | ::1 | 2020-12-02 16:25:09 | 1.993 | 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( display full query string |
| 9210 | ::1 | 2020-12-02 16:55:13 | 1.961 | SELECT payment(2, 4, 0, 1, 1, 'ABLEESEESE', 3487.660000) |
| 9206 | ::1 | 2020-12-02 16:22:38 | 1.961 | SELECT payment(7, 8, 0, 7, 8, 'ABLEABLEPRI', 3671.660000) |
| 9214 | ::1 | 2020-12-02 16:19:08 | 1.955 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:19:08 | 1.954 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:19:08 | 1.954 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:20:58 | 1.951 | SELECT payment(2, 10, 2419, 2, 10, '', 2645.220000) |
| 9219 | ::1 | 2020-12-02 16:17:43 | 1.950 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 16:19:08 | 1.949 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:19:03 | 1.926 | FETCH ALL IN mycursor |
| 9221 | ::1 | 2020-12-02 16:19:03 | 1.926 | FETCH ALL IN mycursor |
| 9214 | ::1 | 2020-12-02 16:19:03 | 1.926 | FETCH ALL IN mycursor |
| 9221 | ::1 | 2020-12-02 16:40:18 | 1.925 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:48:13 | 1.925 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:48:13 | 1.924 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:48:13 | 1.922 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:20:58 | 1.920 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:42:43 | 1.912 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:57:38 | 1.907 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:20:38 | 1.902 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:40:48 | 1.889 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:18:58 | 1.878 | COMMIT |
| 9217 | ::1 | 2020-12-02 17:02:58 | 1.855 | SELECT payment(9, 1, 0, 9, 1, 'ATIONEINGESE', 2061.270000) |
| 9204 | ::1 | 2020-12-02 16:40:18 | 1.844 | SELECT stock_level(8, 7, 19) |
| 9214 | ::1 | 2020-12-02 16:53:38 | 1.836 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:22:38 | 1.821 | FETCH ALL IN mycursor |
| 9221 | ::1 | 2020-12-02 16:55:13 | 1.773 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:57:38 | 1.756 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 16:55:13 | 1.742 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:15:03 | 1.739 | SELECT delivery(5, 4) |
| 9217 | ::1 | 2020-12-02 16:15:03 | 1.706 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:48:13 | 1.702 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:51:28 | 1.695 | FETCH ALL IN mycursor |
| 9214 | ::1 | 2020-12-02 16:48:18 | 1.685 | COMMIT |
| 9221 | ::1 | 2020-12-02 17:02:48 | 1.683 | SELECT payment(4, 6, 0, 4, 6, 'BARABLEPRI', 3501.730000) |
| 9219 | ::1 | 2020-12-02 16:44:04 | 1.666 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:17:43 | 1.651 | FETCH ALL IN mycursor |
| 9204 | ::1 | 2020-12-02 16:31:59 | 1.643 | FETCH ALL IN mycursor |
| 9214 | ::1 | 2020-12-02 17:02:48 | 1.639 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:15:08 | 1.631 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:57:08 | 1.628 | COMMIT |
| 9212 | ::1 | 2020-12-02 17:02:48 | 1.627 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:44:04 | 1.609 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:44:04 | 1.591 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:44:04 | 1.591 | COMMIT |
| 9219 | ::1 | 2020-12-02 16:31:14 | 1.590 | FETCH ALL IN mycursor |
| 9210 | ::1 | 2020-12-02 16:59:05 | 1.544 | SELECT * FROM order_status(60, 10, 1, '') |
| 9204 | ::1 | 2020-12-02 16:59:05 | 1.543 | SELECT payment(5, 5, 2942, 5, 5, '', 2542.650000) |
| 9221 | ::1 | 2020-12-02 16:53:49 | 1.532 | FETCH ALL IN mycursor |
| 9219 | ::1 | 2020-12-02 16:53:39 | 1.495 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:53:39 | 1.485 | FETCH ALL IN mycursor |
| 9204 | ::1 | 2020-12-02 16:44:04 | 1.484 | COMMIT |
| 9221 | ::1 | 2020-12-02 16:15:09 | 1.479 | SELECT * FROM order_status(0, 6, 4, 'BAROUGHTEING') |
| 9206 | ::1 | 2020-12-02 16:38:34 | 1.450 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:38:34 | 1.441 | SELECT stock_level(2, 6, 10) |
| 9202 | ::1 | 2020-12-02 16:44:04 | 1.436 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:17:44 | 1.409 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 16:44:09 | 1.405 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:38:34 | 1.405 | SELECT delivery(8, 1) |
| 9202 | ::1 | 2020-12-02 16:44:09 | 1.405 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:38:34 | 1.392 | COMMIT |
| 9208 | ::1 | 2020-12-02 17:02:49 | 1.387 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:53:39 | 1.365 | FETCH ALL IN mycursor |
| 9217 | ::1 | 2020-12-02 16:38:34 | 1.356 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 17:04:59 | 1.352 | SELECT payment(5, 6, 686, 5, 6, '', 3196.450000) |
| 9204 | ::1 | 2020-12-02 17:02:49 | 1.351 | COMMIT |
| 9204 | ::1 | 2020-12-02 16:42:44 | 1.348 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:53:49 | 1.333 | FETCH ALL IN mycursor |
| 9208 | ::1 | 2020-12-02 16:31:59 | 1.320 | FETCH ALL IN mycursor |
| 9214 | ::1 | 2020-12-02 16:51:29 | 1.320 | SELECT payment(7, 3, 0, 1, 3, 'ESEOUGHTOUGHT', 4029.610000) |
| 9221 | ::1 | 2020-12-02 16:44:04 | 1.313 | FETCH ALL IN mycursor |
| 9206 | ::1 | 2020-12-02 16:15:04 | 1.311 | COMMIT |
| 9210 | ::1 | 2020-12-02 16:17:44 | 1.310 | FETCH ALL IN mycursor |
| 9210 | ::1 | 2020-12-02 16:15:04 | 1.307 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:53:54 | 1.292 | COMMIT |
| 9206 | ::1 | 2020-12-02 16:53:39 | 1.286 | COMMIT |
| 9212 | ::1 | 2020-12-02 16:55:14 | 1.267 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:27:19 | 1.250 | COMMIT |
| 9214 | ::1 | 2020-12-02 17:02:59 | 1.250 | FETCH ALL IN mycursor |
| 9212 | ::1 | 2020-12-02 16:27:19 | 1.249 | COMMIT |
| 9214 | ::1 | 2020-12-02 16:27:19 | 1.248 | FETCH ALL IN mycursor |
| 9212 | ::1 | 2020-12-02 16:53:54 | 1.234 | SELECT payment(4, 9, 0, 4, 9, 'BARABLEABLE', 1923.040000) |
| 9206 | ::1 | 2020-12-02 16:17:44 | 1.232 | SELECT payment(10, 7, 0, 10, 7, 'BARABLEPRI', 1138.910000) |
| 9202 | ::1 | 2020-12-02 16:53:49 | 1.210 | SELECT payment(5, 10, 0, 6, 6, 'PRIOUGHTBAR', 103.780000) |
| 9217 | ::1 | 2020-12-02 17:04:59 | 1.184 | SELECT payment(6, 2, 0, 6, 2, 'BAROUGHTOUGHT', 2532.660000) |
| 9212 | ::1 | 2020-12-02 17:02:14 | 1.179 | SELECT delivery(4, 6) |
| 9204 | ::1 | 2020-12-02 16:27:19 | 1.177 | FETCH ALL IN mycursor |
| 9202 | ::1 | 2020-12-02 16:27:19 | 1.174 | COMMIT |
| 9208 | ::1 | 2020-12-02 16:42:44 | 1.173 | SELECT delivery(6, 1) |
| 9206 | ::1 | 2020-12-02 16:55:14 | 1.170 | COMMIT |
| 9217 | ::1 | 2020-12-02 16:31:14 | 1.153 | SELECT delivery(7, 7) |
| 9219 | ::1 | 2020-12-02 16:55:14 | 1.152 | COMMIT |
| 9202 | ::1 | 2020-12-02 16:31:14 | 1.136 | FETCH ALL IN mycursor |
| 9221 | ::1 | 2020-12-02 16:17:44 | 1.135 | SELECT payment(9, 8, 0, 9, 8, 'ATIONEINGPRES', 3972.380000) |
| 9214 | ::1 | 2020-12-02 17:04:59 | 1.117 | SELECT payment(3, 6, 1920, 3, 6, '', 4819.390000) |
| 9204 | ::1 | 2020-12-02 16:17:44 | 1.114 | FETCH ALL IN mycursor |
| 9204 | ::1 | 2020-12-02 16:51:29 | 1.108 | SELECT delivery(6, 1) |
| 9204 | ::1 | 2020-12-02 16:22:34 | 1.050 | SELECT stock_level(9, 1, 12) |
| 9204 | ::1 | 2020-12-02 16:25:49 | 1.019 | FETCH ALL IN mycursor |
| 9219 | ::1 | 2020-12-02 16:25:34 | 1.008 | COMMIT |
Database | Schema | Relation | Duration | Blockee PID | Blocker PID | Blocker GID | Blockee query | Blocker query |
|---|---|---|---|---|---|---|---|---|
| 00:00:14 | 9214 | 9208 | FETCH 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 = $1display full query string | ||||
| 00:00:12 | 9204 | 9219 | SELECT 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_zipdisplay full query string | ||||
| 00:00:08 | 9210 | 9212 | SELECT 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_zipdisplay full query string | ||||
| 00:00:05 | 9204 | 9214 | FETCH 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 = $1display full query string | ||||
| 00:00:05 | 9219 | 9221 | SELECT 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_zipdisplay full query string | ||||
| 00:00:04 | 9214 | 9219 | FETCH 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 = $1display full query string | ||||
| 00:00:04 | 9219 | 9221 | FETCH 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 = $1display full query string | ||||
| 00:00:03 | 9208 | 9206 | SELECT 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_zipdisplay full query string | ||||
| 00:00:03 | 9210 | 9221 | SELECT 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_zipdisplay full query string | ||||
| 00:00:02 | 9206 | 9202 | SELECT 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 = $1display full query string | ||||
| 00:00:02 | 9219 | 9217 | SELECT 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_zipdisplay full query string | ||||
| 00:00:01 | 9214 | 9204 | SELECT 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 = $1display full query string | ||||
| 00:00:01 | 9212 | 9206 | SELECT 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 = $1display full query string | ||||
| 00:00:01 | 9217 | 9210 | SELECT 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_zipdisplay full query string | ||||
| 00:00:00 | 9214 | 9208 | SELECT 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_zipdisplay full query string | ||||
| 00:00:00 | 9212 | 9204 | SELECT 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_zipdisplay full query string | ||||
| 00:00:00 | 9210 | 9206 | FETCH 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 = $1display full query string | ||||
| 00:00:00 | 9221 | 9212 | SELECT 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_zipdisplay full query string |
| Number of checkpoints | 28 |
|---|---|
| Caused by timeout | 0 |
| Caused by WALs | 0 |
| Average written buffers | 6105.679 |
| Maximum written buffers | 6465.000 |
| Average checkpoint duration | 74.531 |
| Maximum checkpoint duration | 88.732 |
Database | Schema | Table | Count | Avg index scans | Avg removed rows | Avg remain rows | Avg remain dead | Avg duration (sec) | Max duration (sec) | Cancels |
|---|---|---|---|---|---|---|---|---|---|---|
| dbt2 | pg_catalog | pg_statistic | 1 | 1.000 | 61.000 | 491.000 | 0.000 | 0.060 | 0.060 | 0 |
| dbt2 | pg_toast | pg_toast_2619 | 5 | 1.000 | 56.400 | 81.000 | 4.400 | 1.030 | 4.790 | 0 |
| dbt2 | public | district | 59 | 0.119 | 99.356 | 121.797 | 20.373 | 0.027 | 0.740 | 2 |
| dbt2 | public | warehouse | 36 | 0.028 | 56.167 | 21.389 | 10.528 | 0.005 | 0.130 | 0 |
Database | Schema | Table | Avg page hit | Avg page miss | Avg page dirtied | Avg read rate | Avg write rate |
|---|---|---|---|---|---|---|---|
| dbt2 | pg_toast | pg_toast_2619 | 64.000 | 12.600 | 13.400 | 1.233 | 1.487 |
| dbt2 | pg_catalog | pg_statistic | 119.000 | 2.000 | 21.000 | 0.234 | 2.456 |
| dbt2 | public | warehouse | 45.722 | 0.250 | 3.528 | 1.953 | 32.019 |
| dbt2 | public | district | 40.966 | 0.034 | 2.763 | 0.145 | 17.791 |
Database | Schema | Table | Count | Total duration (sec) | Avg duration (sec) | Max duration (sec) | Last analyzed | Cancels | Max modified rows |
|---|---|---|---|---|---|---|---|---|---|
| dbt2 | public | warehouse | 60 | 2.170 | 0.036 | 0.050 | 2020-12-02 17:12:40 | 0 | 69 |
| dbt2 | public | district | 60 | 1.180 | 0.020 | 0.130 | 2020-12-02 17:12:49 | 2 | 246 |
| dbt2 | public | new_order | 1 | 0.660 | 0.660 | 0.660 | 2020-12-02 16:51:36 | 0 | 8963 |
|
Modified Rows Time Modified rows (%) 0 100 200 300 400 500 600 700 16:30 17:00 |
dbt2.public.customer ratio
dbt2.public.district ratio dbt2.public.history ratio dbt2.public.item ratio dbt2.public.new_order ratio dbt2.public.order_line ratio dbt2.public.orders ratio dbt2.public.stock ratio dbt2.public.warehouse ratio |
Time | Database | Schema | Table | Activity | Causal query |
|---|---|---|---|---|---|
| 2020-12-02 17:07:18 | dbt2 | public | district | VACUUM | 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 |
| 2020-12-02 17:01:57 | dbt2 | public | district | ANALYZE | 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 |
| 2020-12-02 16:51:36 | dbt2 | public | district | ANALYZE | 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 |
| 2020-12-02 16:22:36 | dbt2 | public | district | VACUUM | 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 |
| snapshot time | 2020-12-02 17:13:00 |
|---|---|
| Session user | statsinfo |
| Application name | sby |
| Client address | 127.0.0.1 |
| Client host | |
| Client port | 40783 |
| Started at | 2020-12-02 16:11:08 |
| State | streaming |
| Current location | 0/CF2184B0 (0000000100000000000000CF) |
| Sent location | 0/CF2184B0 (0000000100000000000000CF) |
| Write location | 0/CF2184B0 (0000000100000000000000CF) |
| Flush location | 0/CF2184B0 (0000000100000000000000CF) |
| Replay location | 0/CF2037E0 (0000000100000000000000CF) |
| Write lag time | 00:00:00.000000 |
| Flush lag time | 00:00:00.000000 |
| Replay lag time | 00:00:01.000000 |
| Average replay delay | 193 kB |
| Peak replay delay | 1057 kB |
| Sync priority | 1 |
| Sync state | sync |
|
Replication Delays Time Delay (Bytes) 0 256k 512k 768k 1M 16:30 17:00 |
[sync]127.0.0.1:sby flush
[sync]127.0.0.1:sby replay |
Database | Schema | Table | Columns | Rows | MiB | +MiB | Table scans | Index scans |
|---|---|---|---|---|---|---|---|---|
| dbt2 | public | customer | 21 | 300000 | 183 | 6 | 0 | 31507 |
| dbt2 | public | district | 11 | 100 | 0 | 0 | 0 | 30408 |
| dbt2 | public | history | 8 | 306792 | 25 | 0 | 0 | 0 |
| dbt2 | public | item | 5 | 100000 | 10 | 0 | 0 | 71660 |
| dbt2 | public | new_order | 3 | 90300 | 4 | 0 | 0 | 13000 |
| dbt2 | public | order_line | 10 | 2920012 | 282 | 7 | 0 | 14210 |
| dbt2 | public | orders | 8 | 306833 | 19 | 0 | 0 | 13598 |
| dbt2 | public | stock | 17 | 999995 | 347 | 7 | 0 | 252179 |
| dbt2 | public | warehouse | 9 | 10 | 0 | 0 | 20699 | 0 |
Database | Schema | Index | Table | MiB | +MiB | Scans | Rows/scan | Reads | Hits | Keys |
|---|---|---|---|---|---|---|---|---|---|---|
| dbt2 | public | i_customer | customer | 17 | 0 | 4251 | 11.684 | 9072 | 34909 | c_w_id, c_d_id, c_last, c_first, c_id |
| dbt2 | public | i_orders | orders | 9 | 0 | 598 | 1.048 | 5634 | 20366 | o_w_id, o_d_id, o_c_id |
| dbt2 | public | pk_customer | customer | 9 | 0 | 27256 | 1.000 | 6088 | 106770 | c_w_id, c_d_id, c_id |
| dbt2 | public | pk_district | district | 0 | 0 | 30408 | 0.999 | 0 | 30572 | d_w_id, d_id |
| dbt2 | public | pk_item | item | 2 | 0 | 71660 | 0.999 | 229 | 143417 | i_id |
| dbt2 | public | pk_new_order | new_order | 2 | 0 | 13000 | 0.994 | 58 | 60367 | no_w_id, no_d_id, no_o_id |
| dbt2 | public | pk_order_line | order_line | 92 | 6 | 14210 | 16.781 | 2684 | 304612 | ol_w_id, ol_d_id, ol_o_id, ol_number |
| dbt2 | public | pk_orders | orders | 9 | 0 | 13000 | 1.000 | 309 | 63275 | o_w_id, o_d_id, o_id |
| dbt2 | public | pk_stock | stock | 33 | 3 | 252179 | 0.587 | 10153 | 963784 | s_w_id, s_i_id, s_quantity |
| dbt2 | public | pk_warehouse | warehouse | 0 | 0 | 0 | 0.000 | 7 | 66 | w_id |
Name | Setting | Unit | Source |
|---|---|---|---|
| TimeZone | Japan | configuration file | |
| archive_command | cp %p /home/statsinfo/var/archivelog/%f | configuration file | |
| archive_mode | on | configuration file | |
| default_text_search_config | pg_catalog.english | configuration file | |
| lc_messages | C | configuration file | |
| listen_addresses | * | configuration file | |
| log_autovacuum_min_duration | 0 | ms | configuration file |
| log_checkpoints | on | configuration file | |
| log_destination | csvlog | override | |
| log_timezone | Japan | configuration file | |
| logging_collector | on | override | |
| max_prepared_transactions | 10 | configuration file | |
| max_stack_depth | 2048 | kB | environment variable |
| max_wal_senders | 30 | configuration file | |
| pg_statsinfo.excluded_dbnames | template0, template1, postgres | configuration file | |
| pg_statsinfo.excluded_schemas | pg_catalog, pg_toast, information_schema, statsinfo | configuration file | |
| pg_statsinfo.long_lock_threashold | 0 | configuration file | |
| pg_statsinfo.repository_server | port=5432 | configuration file | |
| pg_statsinfo.snapshot_interval | 60 | s | configuration file |
| port | 5433 | configuration file | |
| shared_buffers | 16384 | 8kB | configuration file |
| shared_preload_libraries | pg_statsinfo, pg_stat_statements, pg_store_plans | configuration file | |
| synchronous_standby_names | sby | configuration file | |
| track_functions | all | configuration file | |
| track_io_timing | on | configuration file | |
| transaction_isolation | read committed | override | |
| wal_buffers | 512 | 8kB | override |
| wal_keep_segments | 32 | configuration file | |
| wal_level | hot_standby | configuration file |
End of report
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
;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)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
;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)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
; 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)SELECT EXTRACT(? FROM TRANSACTION_TIMESTAMP()), relname, pid, mode, granted FROM pg_locks, pg_class WHERE relfilenode = relation ORDER BY relname; ;
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[]))HashAggregate (cost=40.88..43.68 rows=28 width=133)
Group Key: c.oid, c.relnamespace, c.reltablespace, c.relname, c.reltoastrelid, c.relkind, c.relpages, c.reltuples, c.reloptions, t.oid, x.indexrelid
-> 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)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)
Group Key: c.oid, n.nspname, c.relname
-> 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)
Group Key: c_1.oid, n_1.nspname, c_1.relname, t.oid, x.indrelid
-> 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)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
; 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)Hash Right Join (cost=106.06..155.68 rows=173 width=229)
Hash Cond: ((s.staattnum = a.attnum) AND (s.starelid = a.attrelid))
-> Seq Scan on pg_statistic s (cost=0.00..41.91 rows=246 width=150)
Filter: (NOT stainherit)
-> Hash (cost=103.47..103.47 rows=173 width=85)
Buckets: 1024 Batches: 1 Memory Usage: 11kB
-> Hash Join (cost=17.27..103.47 rows=173 width=85)
Hash Cond: (a.attrelid = c.oid)
-> Seq Scan on pg_attribute a (cost=0.00..77.14 rows=1954 width=85)
Filter: (attnum > 0)
-> Hash (cost=16.92..16.92 rows=28 width=4)
Buckets: 1024 Batches: 1 Memory Usage: 1kB
-> Hash Left Join (cost=1.14..16.92 rows=28 width=4)
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=8)
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)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...;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...;
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(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...;
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...;
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;
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(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...;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, 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;
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(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...;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;\
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 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 average percentage for every snapshot interval.
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).
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 section determines how to restrict log lines fetched from repository. The fetched lines are shown in the Log Table below.
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.