Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 09.11.2020 01:27
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17127368 kB
MemAvailable 31426636 kB
Buffers 0 kB
Cached 14523444 kB
SwapCached 2812 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.7
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-09 01:27:01
DTS_END                         2020-11-09 01:27:01.7470
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45600
TRN_ID                          250755
ATT_ID                          679
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9644.48 21421 1157337
customer order: creation 184.34 340 22121
customer order: refuse 15.58 304 1870
order to supplier: creation 48.36 1241 5803
order to supplier: removal 3.51 88089 421
invoice (draft): creation 47.83 3233 5740
invoice (draft): removal 55.61 710 6673
invoice accept: apply 43.93 16017 5271
invoice accept: cancel 50.25 755 6030
customer reserve: creation 3963.94 162 475673
customer reserve: removal 4914.79 49 589775
realization accept: apply 89.85 161 10782
realization accept: cancel 89.82 95 10778
payment from customer: creation 62.01 102 7441
payment from customer: removal 6.23 78 747
payment to supplier: creation 51.90 109 6228
payment to supplier: removal 3.62 58 434
service: total inventory turnovers 4.83 1244 579
service: total monetary turnovers 7.07 28 848
service: aggregate perf. data 0.99 17955 119
service: refresh index statistics 0.03 297699 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-11-2020 01:27:52 to 09-11-2020 01:27:54.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2779
TEST_TIME 2 3253
TEST_TIME 3 3825
TEST_TIME 4 4860
TEST_TIME 5 5258
TEST_TIME 6 5174
TEST_TIME 7 5456
TEST_TIME 8 5427
TEST_TIME 9 5540
TEST_TIME 10 5966
TEST_TIME 11 6094
TEST_TIME 12 6446
TEST_TIME 13 6799
TEST_TIME 14 6995
TEST_TIME 15 7334
TEST_TIME 16 7827
TEST_TIME 17 8192
TEST_TIME 18 8855
TEST_TIME 19 8981
TEST_TIME 20 9190
TEST_TIME 21 9247
TEST_TIME 22 9827
TEST_TIME 23 10038
TEST_TIME 24 10096
TEST_TIME 25 10465
TEST_TIME 26 10407
TEST_TIME 27 10531
TEST_TIME 28 10740
TEST_TIME 29 11133
TEST_TIME 30 10892
TEST_TIME 31 10767
TEST_TIME 32 10601
TEST_TIME 33 10504
TEST_TIME 34 10598
TEST_TIME 35 10464
TEST_TIME 36 10590
TEST_TIME 37 10454
TEST_TIME 38 10475
TEST_TIME 39 10348
TEST_TIME 40 10450
TEST_TIME 41 10348
TEST_TIME 42 10393
TEST_TIME 43 10418
TEST_TIME 44 10293
TEST_TIME 45 10152
TEST_TIME 46 10071
TEST_TIME 47 10027
TEST_TIME 48 9911
TEST_TIME 49 9884
TEST_TIME 50 9921
TEST_TIME 51 9842
TEST_TIME 52 9839
TEST_TIME 53 9813
TEST_TIME 54 9817
TEST_TIME 55 9751
TEST_TIME 56 9803
TEST_TIME 57 9796
TEST_TIME 58 9884
TEST_TIME 59 9870
TEST_TIME 60 9865
TEST_TIME 61 9860
TEST_TIME 62 9918
TEST_TIME 63 9888
TEST_TIME 64 9972
TEST_TIME 65 9967
TEST_TIME 66 10025
TEST_TIME 67 9941
TEST_TIME 68 9977
TEST_TIME 69 10089
TEST_TIME 70 10104
TEST_TIME 71 10159
TEST_TIME 72 10142
TEST_TIME 73 10059
TEST_TIME 74 9952
TEST_TIME 75 9978
TEST_TIME 76 9962
TEST_TIME 77 9892
TEST_TIME 78 9859
TEST_TIME 79 9920
TEST_TIME 80 9866
TEST_TIME 81 9829
TEST_TIME 82 9806
TEST_TIME 83 9739
TEST_TIME 84 9760
TEST_TIME 85 9681
TEST_TIME 86 9649
TEST_TIME 87 9636
TEST_TIME 88 9646
TEST_TIME 89 9600
TEST_TIME 90 9679
TEST_TIME 91 9695
TEST_TIME 92 9729
TEST_TIME 93 9722
TEST_TIME 94 9773
TEST_TIME 95 9864
TEST_TIME 96 9831
TEST_TIME 97 9813
TEST_TIME 98 9846
TEST_TIME 99 9857
TEST_TIME 100 9815
TEST_TIME 101 9881
TEST_TIME 102 9828
TEST_TIME 103 9780
TEST_TIME 104 9813
TEST_TIME 105 9778
TEST_TIME 106 9766
TEST_TIME 107 9738
TEST_TIME 108 9739
TEST_TIME 109 9734
TEST_TIME 110 9658
TEST_TIME 111 9668
TEST_TIME 112 9643
TEST_TIME 113 9609
TEST_TIME 114 9585
TEST_TIME 115 9667
TEST_TIME 116 9703
TEST_TIME 117 9717
TEST_TIME 118 9722
TEST_TIME 119 9726
TEST_TIME 120 9648

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-11-2020 01:27:56 to 09-11-2020 01:27:59.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1598019 1598019 0 0.00 0 11622 5 0 0
doc_list_biud 1598019 1598019 0 0.00 0 50443 23 0 0
sp_add_invoice_to_stock 5460 5271 189 3.46 43 151485 16017 0 189
sp_cancel_adding_invoice 6030 6030 0 0.00 4 63283 756 0 0
sp_cancel_client_order 1870 1870 0 0.00 4 12360 305 0 0
sp_cancel_customer_reserve 589775 589775 0 0.00 1 50443 49 0 0
sp_cancel_pay_from_customer 747 747 0 0.00 3 5559 78 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 3 1519 58 0 0
sp_cancel_supplier_invoice 6688 6673 15 0.22 1 40772 711 0 15
sp_cancel_supplier_order 421 421 0 0.00 12 938398 88089 0 0
sp_cancel_write_off 10778 10778 0 0.00 1 14966 96 0 0
sp_client_order 22121 22121 0 0.00 3 41608 340 0 0
sp_customer_reserve 475673 475673 0 0.00 0 90529 163 0 0
sp_fill_shopping_cart 33649 33649 0 0.00 1 10958 36 0 0
sp_fill_shopping_cart_clo_res 475672 475672 0 0.00 0 9919 12 0 0
sp_get_clo_for_invoice 5269 5269 0 0.00 0 23337 267 0 0
sp_kill_cost_storno 17989 17989 0 0.00 0 5961 46 0 0
sp_kill_qstorno_ret_qs2qd 1197422 1197422 0 0.00 0 50441 27 0 0
sp_kill_qty_storno 631598 631598 0 0.00 0 50442 59 0 0
sp_lock_selected_doc 22256 22256 0 0.00 0 8337 6 0 0
sp_make_cost_storno 29720 29720 0 0.00 0 11618 48 0 0
sp_multiply_rows_for_pdistr 29720 29720 0 0.00 0 7416 24 0 0
sp_multiply_rows_for_qdistr 22121 22121 0 0.00 0 9512 136 0 0
sp_pay_from_customer 7441 7441 0 0.00 4 10517 102 0 0
sp_pay_to_supplier 6228 6228 0 0.00 5 12167 109 0 0
sp_payment_common 13669 13669 0 0.00 1 9379 24 0 0
sp_qd_handle_on_cancel_clo 1870 1870 0 0.00 0 12353 285 0 0
sp_qd_handle_on_invoice_upd_sts 11299 11299 0 0.00 0 18431 311 0 0
sp_qd_handle_on_reserve_upd_sts 10782 10782 0 0.00 0 13103 54 0 0
sp_reserve_write_off 10782 10782 0 0.00 6 13162 161 0 0
sp_supplier_invoice 5740 5740 0 0.00 7 89282 3234 0 0
sp_supplier_order 5803 5803 0 0.00 6 42371 1241 0 0
srv_aggregate_perf_data 119 119 0 0.00 1981 162022 17956 0 0
srv_fill_mon_cache_memory 154 154 0 0.00 1752 140996 35503 0 0
srv_find_qd_qs_mism 1107391 1107391 0 0.00 0 10195 5 0 0
srv_make_invnt_saldo 579 579 0 0.00 20 118229 1245 0 0
srv_make_money_saldo 848 848 0 0.00 1 3624 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 161889 358955 297700 0 0
t$perf-abend:sp_add_invoice_to_stock 189 189 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5272 5272 0 0.00 0 25982 148 0 0
t$perf-norm:sp_cancel_adding_invoice 465 465 0 0.00 0 4587 94 0 0
t$perf-norm:sp_cancel_client_order 1870 1870 0 0.00 0 2241 13 0 0
t$perf-norm:sp_cancel_customer_reserve 757 757 0 0.00 0 17619 30 0 0
t$perf-norm:sp_cancel_pay_from_customer 747 747 0 0.00 0 3766 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 602 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 431 431 0 0.00 0 1169 12 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 16376 1510 0 0
t$perf-norm:sp_cancel_write_off 1080 1080 0 0.00 0 1347 5 0 0
t$perf-norm:sp_client_order 22121 22121 0 0.00 0 12273 17 0 0
t$perf-norm:sp_customer_reserve 1107 1107 0 0.00 0 6096 14 0 0
t$perf-norm:sp_pay_from_customer 7441 7441 0 0.00 0 6686 11 0 0
t$perf-norm:sp_pay_to_supplier 6228 6228 0 0.00 0 3985 9 0 0
t$perf-norm:sp_reserve_write_off 10782 10782 0 0.00 0 8580 11 0 0
t$perf-norm:sp_supplier_invoice 5740 5740 0 0.00 0 3980 15 0 0
t$perf-norm:sp_supplier_order 5803 5803 0 0.00 0 7546 18 0 0
t$perf-norm:srv_aggregate_perf_data 119 119 0 0.00 0 73 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 424 6 0 0
t$perf-norm:srv_make_invnt_saldo 579 579 0 0.00 0 1997 19 0 0
t$perf-norm:srv_make_money_saldo 848 848 0 0.00 0 954 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 41 13 0 0
v_add_invoice_to_stock 10916 10538 378 3.46 0 6189 21 0 378
v_all_customers 39842 39842 0 0.00 0 19 1 0 0
v_all_suppliers 31780 31780 0 0.00 0 15 1 0 0
v_all_wares 44240 44240 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 930 930 0 0.00 0 782 6 0 0
v_cancel_client_order 3740 3740 0 0.00 0 1441 4 0 0
v_cancel_customer_prepayment 1494 1494 0 0.00 0 2526 6 0 0
v_cancel_customer_reserve 1514 1514 0 0.00 0 799 4 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 1508 6 0 0
v_cancel_supplier_invoice 892 862 30 3.36 0 1625 20 0 30
v_cancel_supplier_order 842 842 0 0.00 0 548 3 0 0
v_cancel_write_off 2160 2160 0 0.00 0 4950 13 0 0
v_max_id_clo_ord 5803 5803 0 0.00 0 1210 1 0 0
v_max_id_clo_res 1107 1107 0 0.00 0 5875 24 0 0
v_max_id_ord_sup 5726 5726 0 0.00 0 8776 6 0 0
v_max_non_paid_invoice 1867 1867 0 0.00 0 1095 3 0 0
v_max_non_paid_realizn 4171 4171 0 0.00 0 1322 3 0 0
v_min_id_clo_ord 5803 5803 0 0.00 0 873 4 0 0
v_min_id_clo_res 1107 1107 0 0.00 0 6009 19 0 0
v_min_id_ord_sup 5726 5726 0 0.00 0 5028 4 0 0
v_min_non_paid_invoice 6228 6228 0 0.00 0 7337 14 0 0
v_min_non_paid_realizn 7441 7441 0 0.00 0 2970 12 0 0
v_our_firm 10938 10938 0 0.00 0 17 1 0 0
v_reserve_write_off 21564 21564 0 0.00 0 6042 6 0 0
x_lock_depdocs_on_canc_invoice 12272 12272 0 0.00 0 11336 110 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 8715 310 0 0
x_make_qstorno_1000_1200 5803 5803 0 0.00 2 42263 1165 0 0
x_make_qstorno_1200_2000 5740 5740 0 0.00 3 89259 3098 0 0
x_make_qstorno_2100_3300 475673 475673 0 0.00 0 90526 148 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-11-2020 01:28:00 to 09-11-2020 01:28:04.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:05 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:11 18341 8192000000 10259433008 10569576448 856000752 9.460 67 52 104 0 876345360 2497392 17847216
22:57:37 34896 8192000000 10356106752 10668240896 1400234896 14.597 100 90 180 0 1434248848 5070032 28943920
22:58:25 33206 8192000000 10382583344 10706006016 1426395536 14.829 100 83 167 1 1460711088 6772576 27542976
22:59:12 17876 8192000000 10419312544 10745757696 1469610496 15.210 100 91 182 0 1506913008 7659264 29643248
22:59:42 24190 8192000000 10442456160 10774171648 1489658992 15.386 100 86 171 1 1525622624 8495104 27468528
23:00:14 14139 8192000000 10457073024 10793472000 1511321568 15.575 100 86 172 0 1548295248 9365424 27608256
23:00:42 10441 8192000000 10473326176 10815209472 1528154896 15.721 100 82 164 0 1567932336 13967856 25809584
23:01:02 11408 8192000000 10486998640 10833354752 1548397072 15.896 100 79 159 0 1582428352 9430256 24601024
23:01:27 5632 8192000000 10510475552 10860548096 1574443024 16.120 100 78 156 0 1608665216 9964336 24257856
23:01:41 15347 8192000000 10539521824 10890276864 1590886416 16.261 100 86 172 0 1627350288 9802784 26661088
23:02:05 14350 8192000000 10559472880 10916102144 1611611008 16.438 100 80 161 1 1646483376 10335792 24536576
23:02:31 6733 8192000000 10567104160 10927788032 1632921504 16.620 100 73 146 1 1665239024 10362080 21955440
23:02:45 14242 8192000000 10598065840 10959233024 1656059488 16.816 100 77 154 0 1689600272 10874160 22666624
23:03:07 10579 8192000000 10618253712 10980556800 1673182384 16.960 100 79 158 3 1708223248 11676128 23364736
23:03:25 11335 8192000000 10630269120 11003342848 1692810384 17.125 100 74 148 0 1725584096 11817568 20956144
23:03:45 9196 8192000000 10659454144 11027828736 1712646992 17.291 100 83 166 1 1749964656 13187376 24130288
23:04:01 7343 8192000000 10670280048 11041124352 1727533744 17.415 100 86 171 0 1766003184 14009840 24459600
23:04:16 6120 8192000000 10675873872 11050295296 1735084944 17.478 100 76 152 1 1770503984 13770736 21648304
23:04:29 5365 8192000000 10687024928 11062542336 1749153760 17.595 100 89 175 2 1787610656 13513744 24943152
23:04:41 3199 8192000000 10698243312 11071111168 1761600160 17.698 100 88 174 1 1799259088 13063936 24594992
23:04:54 5075 8192000000 10704924608 11085176832 1762975136 17.709 100 82 163 0 1799385088 13785776 22624176
23:05:06 5870 8192000000 10718658208 11098193920 1776397872 17.820 100 82 164 1 1812823696 13068848 23356976
23:05:19 5329 8192000000 10720450688 11102957568 1785166912 17.892 100 85 172 1 1822166016 13651312 23347792
23:05:32 3331 8192000000 10733210304 11114635264 1793043472 17.957 100 81 163 0 1828957280 13390528 22523280
23:05:42 2116 8192000000 10735903376 11119419392 1798442256 18.001 100 87 176 0 1836606704 13507872 24656576
23:05:50 2837 8192000000 10742479904 11124318208 1805854144 18.062 100 82 165 0 1840869168 12474752 22540272
23:06:00 3036 8192000000 10753895488 11135856640 1811198000 18.106 100 88 176 0 1846633744 11324112 24111632
23:06:09 8789 8192000000 10752533824 11136106496 1811883008 18.111 100 75 151 3 1844530352 11896800 20750544
23:06:26 4956 8192000000 10764139312 11151171584 1817554048 18.158 100 82 162 2 1853279968 13677312 22048608
23:06:37 2142 8192000000 10774206176 11160395776 1830945424 18.267 100 86 171 1 1869441232 14574240 23921568
23:06:46 2936 8192000000 10778617824 11163299840 1835859648 18.307 100 90 179 2 1875890304 14510688 25519968
23:06:55 2648 8192000000 10782092176 11166453760 1839833472 18.339 100 90 180 1 1880631664 15376976 25421216
23:07:04 1841 8192000000 10782646864 11172143104 1842056944 18.358 100 90 181 0 1882121840 14274192 25790704
23:07:12 2329 8192000000 10788169280 11178196992 1847948880 18.405 100 94 188 1 1887641504 13269552 26423072
23:07:21 2112 8192000000 10795327760 11178508288 1849838896 18.421 100 93 185 0 1889596128 14020048 25737184
23:07:30 1936 8192000000 10796674816 11182583808 1851831200 18.437 100 95 189 0 1890804256 13392096 25580960
23:07:38 1893 8192000000 10795221472 11178090496 1852834016 18.445 100 91 183 0 1892807008 13353776 26619216
23:07:46 1512 8192000000 10805959536 11190317056 1854868848 18.462 100 91 183 0 1894761408 14482128 25410432
23:07:54 1240 8192000000 10799114192 11188162560 1856578176 18.476 100 94 187 1 1896714704 13404192 26732336
23:08:01 2535 8192000000 10801118848 11192221696 1859341504 18.498 100 88 174 0 1897080640 13743008 23996128
23:08:10 1781 8192000000 10804269200 11192385536 1863454144 18.531 100 92 184 1 1901938096 12365360 26118592
23:08:19 15533 8192000000 10807305616 11200872448 1867504704 18.564 100 74 147 3 1900768688 13104848 20159136
23:08:40 2076 8192000000 10806763024 11205500928 1870741344 18.590 100 81 162 0 1907367136 12884560 23741232
23:08:49 20681 8192000000 10798161024 11206299648 1870664272 18.590 100 48 96 0 1892501424 7769056 14068096
23:09:17 3085 8192000000 10782433248 11204698112 1871372784 18.595 100 40 79 1 1890306912 7073440 11860688
23:09:29 6397 8192000000 10789165344 11210883072 1875492784 18.629 100 38 77 1 1893966544 7354528 11119232
23:09:43 3491 8192000000 10797325408 11218173952 1883215808 18.691 100 37 74 0 1901583168 8339008 10028352
23:09:54 4799 8192000000 10794541904 11219869696 1883804288 18.696 100 40 80 0 1902918784 7709984 11404512
23:10:05 2957 8192000000 10786477792 11218108416 1882100400 18.682 100 22 43 2 1895609920 6757696 6751824
23:10:24 3047 8192000000 10821177168 11231277056 1895332208 18.789 100 51 100 0 1916419328 5936032 15151088
23:10:35 3913 8192000000 10808306688 11234414592 1898174352 18.812 100 44 88 3 1919037264 8918656 11944256
23:10:46 7159 8192000000 10798483504 11236241408 1893029584 18.770 100 21 42 2 1905550064 7008352 5512128
23:10:59 7814 8192000000 10804565984 11236716544 1893612096 18.775 100 15 30 0 1904044272 6086880 4345296
23:11:13 3601 8192000000 10814837248 11236974592 1901480880 18.838 100 34 66 2 1918168032 6189056 10498096
23:11:27 4849 8192000000 10819515616 11245924352 1902900112 18.850 100 33 66 3 1919731872 6967792 9863968
23:11:39 6214 8192000000 10813519648 11245445120 1901851872 18.841 100 21 42 1 1914828048 7447568 5528608
23:11:53 9529 8192000000 10824317984 11252551680 1907489184 18.886 100 30 60 3 1926993696 11392976 8111536
23:12:17 77310 8192000000 10833639664 11265519616 1912324592 18.925 100 31 62 0 1927414336 5677520 9412224
23:13:50 5434 8192000000 10834976048 11273494528 1925018176 19.027 100 40 80 2 1943643088 7106448 11518464
23:14:02 5605 8192000000 10853898544 11274432512 1921960736 19.003 100 40 81 2 1938870528 6139408 10770384
23:14:14 4454 8192000000 10856036688 11279261696 1922211184 19.005 100 40 78 0 1940960384 7934080 10815120
23:14:25 5888 8192000000 10836537008 11273048064 1921560752 18.999 100 36 72 2 1938610384 7022416 10027216
23:14:38 2038 8192000000 10843365200 11270426624 1916030784 18.955 100 38 76 1 1934771024 7632880 11107360
23:14:48 5410 8192000000 10838364880 11269804032 1919035024 18.979 100 34 65 3 1935417216 6443760 9938432
23:15:00 5274 8192000000 10839032272 11274919936 1919859968 18.986 100 26 52 1 1934991584 8003488 7128128
23:15:14 7750 8192000000 10835914240 11260846080 1904867952 18.865 99 34 69 1 1921469792 6434496 10167344
23:15:28 6567 8192000000 10842691392 11274772480 1923809536 19.017 100 23 47 0 1936099792 6089200 6201056
23:15:42 13314 8192000000 10826114752 11264835584 1901647344 18.840 99 24 48 2 1914643408 5728912 7267152
23:16:04 7649 8192000000 10828777232 11264278528 1893882256 18.777 99 13 26 2 1907078576 9883072 3313248
23:16:23 10587 8192000000 10801849264 11234783232 1821465584 18.190 95 24 47 3 1834353056 5781248 7106224
23:16:39 7715 8192000000 10798333424 11229429760 1857393216 18.482 98 19 38 0 1868854928 5883648 5578064
23:16:56 6474 8192000000 10807676384 11236093952 1873275536 18.611 99 27 55 3 1886769440 5815376 7678528
23:17:08 12913 8192000000 10791994016 11219709952 1857196016 18.481 98 18 36 3 1867585616 5297936 5091664
23:17:42 37068 8192000000 10764730672 11205017600 1800791760 18.020 95 60 117 2 1824785328 6054160 17939408
23:18:26 10174 8192000000 10753596224 11179044864 1811464624 18.108 98 17 34 1 1821700368 5167456 5068288
23:18:44 9083 8192000000 10737160272 11147268096 1766304288 17.736 95 34 68 0 1781306656 4460352 10542016
23:19:01 6573 8192000000 10729577824 11145637888 1744295168 17.554 95 26 50 1 1756859584 5200496 7363920
23:19:18 10233 8192000000 10742905248 11161853952 1796003552 17.981 98 23 46 3 1809272336 6430720 6838064
23:19:37 4850 8192000000 10722991600 11135279104 1768876800 17.758 97 36 72 0 1787062896 7811040 10375056
23:19:48 3934 8192000000 10696169856 11112398848 1773810736 17.798 98 30 60 0 1788993984 6093568 9089680
23:19:58 5673 8192000000 10707862928 11118465024 1756445552 17.655 98 32 63 1 1770800912 5487056 8868304
23:20:10 6181 8192000000 10722616384 11140616192 1794140048 17.966 99 32 64 0 1809699536 5817488 9742000
23:20:25 9276 8192000000 10706859744 11127762944 1765880208 17.733 98 29 58 2 1780611808 5873408 8858192
23:20:41 8892 8192000000 10707383760 11117821952 1755520832 17.647 98 19 38 1 1766142256 4863120 5758304
23:20:56 12995 8192000000 10702872144 11109158912 1688658848 17.090 94 23 46 4 1700514592 5222432 6633312
23:21:19 10290 8192000000 10700111680 11119284224 1769340208 17.762 99 18 36 1 1780040944 5593744 5106992
23:21:35 8832 8192000000 10713002976 11135954944 1799973792 18.014 100 20 40 3 1811358848 5659120 5725936
23:21:50 60644 8192000000 10749101504 11158003712 1797118336 17.990 99 36 72 0 1812631952 4907264 10606352
23:23:12 12560 8192000000 10758680240 11180326912 1831728224 18.273 99 37 74 1 1851192192 9743808 9720160
23:23:32 7055 8192000000 10768315936 11192111104 1850730032 18.428 100 39 78 3 1869419968 7095456 11594480
23:23:47 9672 8192000000 10762162448 11181498368 1814558528 18.133 98 32 63 3 1829853856 6085152 9210176
23:24:03 5902 8192000000 10762059232 11190636544 1849249856 18.416 100 36 70 1 1866283408 7434288 9599264
23:24:15 6956 8192000000 10771231472 11193458688 1854148704 18.456 100 28 56 1 1868095616 5686592 8260320
23:24:29 7805 8192000000 10781534352 11200876544 1858455456 18.491 100 25 47 3 1870831920 5319120 7057344
23:24:44 6578 8192000000 10777627392 11204878336 1862163536 18.521 100 25 50 1 1875941392 6855776 6922080
23:24:59 5869 8192000000 10776529296 11207360512 1864081024 18.536 100 23 45 1 1875601600 5468288 6052288
23:25:12 7809 8192000000 10800695072 11222122496 1870625744 18.589 100 27 53 3 1888661808 10665344 7370720
23:25:27 6664 8192000000 10784482000 11217010688 1872994480 18.608 100 24 47 0 1885978096 6416624 6566992
23:25:44 6928 8192000000 10784329984 11214548992 1872061600 18.601 100 19 38 0 1884930544 6135584 6733360
23:25:58 9021 8192000000 10791286224 11219140608 1872457936 18.604 100 20 40 0 1883173456 4798336 5917184
23:26:14 9055 8192000000 10781428800 11216687104 1871642384 18.598 100 12 24 1 1880548048 5544672 3360992
23:26:32 17763 8192000000 10800563104 11229040640 1880936336 18.673 100 20 40 3 1891548560 4948720 5663504
23:26:57 119292 8192000000 10840595520 11267743744 1905357376 18.869 100 36 68 1 1921171408 5779024 10035008
23:29:12 22523 8192000000 10869164752 11291185152 1933492656 19.095 100 48 95 1 1955543440 9367584 12683200
23:29:47 9351 8192000000 10868073616 11292975104 1942550880 19.167 100 51 102 0 1967645680 10558896 14535904
23:30:06 7299 8192000000 10880172208 11306496000 1948562720 19.215 100 58 113 3 1975142272 11033104 15546448
23:30:20 16678 8192000000 10876325104 11302023168 1931204128 19.077 99 56 112 2 1958750304 11976960 15569216
23:30:52 29500 8192000000 10870975904 11304960000 1948067344 19.211 100 50 100 1 1974979536 12698880 14213312
23:31:49 27011 8192000000 10900019248 11321823232 1953005792 19.250 100 34 68 0 1975511040 12288672 10216576
23:32:26 16806 8192000000 10890076768 11329695744 1958971728 19.298 100 39 78 1 1982806912 11303568 12531616
23:33:01 20058 8192000000 10896034336 11329150976 1951181616 19.236 99 45 88 1 1978261888 14113200 12967072
23:33:31 18161 8192000000 10911741264 11348307968 1972840480 19.408 100 48 96 0 2006366928 19483408 14043040
23:33:59 18872 8192000000 10913945616 11347808256 1973715056 19.415 100 42 84 0 2010291312 23839632 12736624
23:34:26 17697 8192000000 10920945248 11354419200 1979849248 19.464 100 58 114 1 2017291264 20363280 17078736
23:34:57 5444 8192000000 10926397472 11360280576 1983477856 19.492 100 49 98 0 2017188016 19697008 14013152
23:35:10 7924 8192000000 10934914480 11369381888 1991044688 19.552 100 49 97 0 2024391440 19514640 13832112
23:35:27 5368 8192000000 10937029168 11366883328 1993082608 19.568 100 57 113 2 2030162816 20256720 16823488
23:35:40 4807 8192000000 10949299344 11375357952 1999452096 19.618 100 64 128 2 2040128432 21718064 18958272
23:35:52 6515 8192000000 10958632752 11384123392 2003019296 19.647 100 69 139 0 2048368688 23383248 21966144
23:36:11 6716 8192000000 10959595040 11389415424 2006885744 19.677 100 66 128 1 2049831248 23820672 19124832
23:36:30 9421 8192000000 10958776752 11391762432 2009369216 19.697 100 61 122 0 2051650240 23276320 19004704
23:36:48 4740 8192000000 10979154784 11402747904 2014567312 19.737 100 72 140 0 2060571504 25421744 20582448
23:37:01 6658 8192000000 10980594080 11409055744 2016539040 19.753 100 72 143 3 2064357248 26634688 21183520
23:37:16 5597 8192000000 10973568304 11406077952 2019363744 19.775 100 68 136 1 2064059232 24647600 20047888
23:37:31 6281 8192000000 10964822336 11397791744 2014651776 19.738 100 61 123 1 2056811104 24027520 18131808
23:37:44 3618 8192000000 10969111568 11400712192 2015049792 19.741 100 66 132 3 2059401856 23115824 21236240
23:38:05 10237 8192000000 10932504560 11369238528 1972230752 19.403 99 48 96 1 2012582512 25579200 14772560
23:38:23 11126 8192000000 10935589616 11366285312 1967328144 19.364 99 59 118 0 2013526016 28165072 18032800
23:38:44 18842 8192000000 10922202032 11367108608 1962173568 19.323 99 52 104 2 2007738592 28806832 16758192
23:39:22 2677 8192000000 10936800992 11355930624 1946910368 19.202 98 75 147 2 1996721728 27339856 22471504
23:39:32 1751 8192000000 10959317696 11371008000 1980228336 19.467 100 80 157 3 2034399648 29823424 24347888
23:39:40 1799 8192000000 10964785872 11389091840 2000184528 19.624 100 90 176 1 2055990832 30522352 25283952
23:39:49 2691 8192000000 10963776224 11374678016 1985654336 19.509 100 87 172 1 2044172400 32868848 25649216
23:40:02 7701 8192000000 10941959600 11370266624 1978839696 19.456 100 74 148 1 2029273376 28503760 21929920
23:40:17 2071 8192000000 10966075696 11392344064 1984522544 19.500 100 74 148 0 2042830448 36660256 21647648
23:40:26 1755 8192000000 10979551232 11399561216 2007307600 19.680 100 85 168 0 2063601440 30601152 25692688
23:40:35 2638 8192000000 10984200544 11408056320 2011091504 19.710 100 79 159 0 2070042960 34754096 24197360
23:40:44 6032 8192000000 10956855072 11369115648 1971245744 19.395 98 87 174 0 2028476272 31135696 26094832
23:40:57 4032 8192000000 10980361024 11396808704 2004332848 19.657 100 83 164 4 2061723744 32486656 24904240
23:41:09 2355 8192000000 10960212528 11371773952 1955196592 19.268 98 84 168 2 2014584864 34034752 25353520
23:41:18 3050 8192000000 10955097360 11373879296 1979382448 19.460 100 76 151 0 2035986096 33771232 22832416
23:41:30 2550 8192000000 10975447008 11390038016 1993498208 19.571 100 82 162 1 2053972128 34207120 26266800
23:41:42 2426 8192000000 10952972064 11369746432 1963897360 19.337 99 87 174 0 2026667920 35678752 27091808
23:41:51 3131 8192000000 10927229648 11341479936 1932286000 19.085 98 80 159 1 1992208288 35722080 24200208
23:42:03 1862 8192000000 10939387744 11349123072 1943088928 19.171 99 87 175 1 2007829504 37030256 27710320
23:42:12 4084 8192000000 10911507296 11330596864 1932910512 19.090 99 67 134 1 1992385040 38439600 21034928
23:42:25 8053 8192000000 10921000416 11342794752 1945778064 19.193 100 64 128 0 2006021920 39388400 20855456
23:42:47 5238 8192000000 10924908192 11341312000 1932869040 19.090 99 76 153 0 1996204224 39908496 23426688
23:43:00 2123 8192000000 10954777168 11361603584 1963406048 19.333 100 87 172 1 2028677616 40166256 25105312
23:43:09 2878 8192000000 10947084928 11362562048 1968177056 19.371 100 75 148 1 2028839424 37065456 23596912
23:43:19 6827 8192000000 10939419616 11368214528 1968875744 19.377 100 62 124 0 2025568432 37501328 19191360
23:43:34 3522 8192000000 10921205840 11340451840 1933937280 19.098 99 70 139 1 1991636368 36963968 20735120
23:43:45 1937 8192000000 10943953408 11358101504 1960000768 19.306 100 78 155 1 2022082624 37444160 24637696
23:43:54 3896 8192000000 10954644768 11366260736 1966603888 19.358 100 77 150 3 2027137008 38594112 21939008
23:44:05 3590 8192000000 10954334528 11365064704 1968874896 19.377 100 86 170 1 2034606448 39608160 26123392
23:44:16 2342 8192000000 10949940800 11366629376 1969605344 19.382 100 81 161 0 2029108096 34672720 24830032
23:44:24 4018 8192000000 10946990752 11371208704 1973729024 19.415 100 65 130 2 2029876400 35561488 20585888
23:44:36 2257 8192000000 10946233584 11369013248 1970428832 19.389 100 65 130 1 2026848944 35675264 20744848
23:44:47 2760 8192000000 10942051296 11358273536 1959727760 19.304 100 72 143 2 2018146240 36892896 21525584
23:44:59 9322 8192000000 10918648000 11357921280 1958440720 19.294 100 46 92 0 2010829632 37565088 14823824
23:45:17 12251 8192000000 10914700720 11352612864 1934733392 19.105 99 29 58 1 1979244272 35322000 9188880
23:45:47 14747 8192000000 10868710576 11311280128 1890624736 18.751 97 32 64 1 1930721392 29626176 10470480
23:46:08 8554 8192000000 10874493488 11312877568 1916964976 18.963 100 30 60 0 1954604224 28027184 9612064
23:46:25 4398 8192000000 10883618064 11314286592 1911319520 18.917 99 47 93 0 1955086480 29829616 13937344
23:46:39 9697 8192000000 10884458976 11326906368 1923014720 19.011 100 47 93 1 1969698048 31899696 14783632
23:46:56 10894 8192000000 10873947088 11314155520 1902541456 18.847 99 35 70 2 1948777856 34574688 11661712
23:47:16 12492 8192000000 10901661296 11339976704 1927970080 19.051 100 38 75 0 1975185472 35417424 11797968
23:47:37 2041 8192000000 10913385376 11328507904 1919327488 18.981 99 75 148 1 1974587168 31717408 23542272
23:47:46 5330 8192000000 10906304064 11334533120 1935736048 19.113 100 50 97 1 1985747600 34426352 15585200
23:47:59 14888 8192000000 10902125344 11344863232 1938351776 19.134 100 31 62 0 1982940592 34587376 10001440
23:48:21 14548 8192000000 10911899120 11356446720 1934767760 19.105 99 39 78 0 1983840576 36239664 12833152
23:48:47 15734 8192000000 10913732864 11359137792 1950018896 19.227 100 30 60 1 1997328480 37348464 9961120
23:49:10 20172 8192000000 10891764848 11348013056 1928303456 19.053 99 18 36 2 1963539568 29569104 5667008
23:49:40 11556 8192000000 10887011584 11329687552 1926456720 19.039 99 39 78 3 1968765184 29759728 12548736
23:50:00 19493 8192000000 10911097088 11359588352 1947381728 19.206 100 41 82 3 1996477360 36661792 12433840
23:50:31 17297 8192000000 10896089392 11349159936 1933769168 19.097 99 31 62 1 1971553104 28012272 9771664
23:50:55 16189 8192000000 10907933728 11361820672 1951441120 19.238 100 26 52 5 1995618928 35839600 8338208
23:51:19 25863 8192000000 10918496384 11369381888 1958425136 19.294 100 28 56 3 2006082848 38558400 9099312
23:51:52 22767 8192000000 10908515872 11354873856 1914846528 18.946 98 31 62 2 1962548448 37671840 10030080
23:52:21 9331 8192000000 10919806160 11370967040 1955209568 19.268 100 39 76 2 2003728208 35945152 12573488
23:52:37 24194 8192000000 10914190912 11362385920 1965764272 19.352 100 38 74 1 2002278608 24250688 12263648
23:53:24 20779 8192000000 10923621216 11368640512 1961543360 19.318 100 31 62 0 1999011520 27421184 10046976
23:53:51 45803 8192000000 10889878320 11341631488 1911100512 18.915 98 23 46 1 1949385216 30241584 8043120
23:55:09 31260 8192000000 10883723840 11352260608 1927873872 19.050 99 22 44 2 1963631312 28647504 7109936
23:55:47 57854 8192000000 10864962064 11358552064 1937602752 19.128 100 14 28 0 1969654608 26906736 5145120
23:56:51 45816 8192000000 10892434000 11339685888 1927938272 19.050 99 17 33 1 1942031136 9562464 4530400
23:57:47 60301 8192000000 10895703232 11355078656 1942658304 19.168 99 14 28 0 1957040192 10383328 3998560
23:59:05 86039 8192000000 10936218032 11386552320 1983805472 19.495 100 30 58 2 2006200848 14115936 8279440
00:00:44 49460 8192000000 10912758144 11383250944 1983224784 19.490 100 14 28 2 2002093888 15112816 3756288
00:01:49 57533 8192000000 10914558880 11379499008 1971360352 19.396 99 11 22 4 1986695072 12527952 2806768
00:02:56 101981 8192000000 10923474544 11380588544 1950690688 19.232 98 26 52 1 1974690640 15028720 8971232
00:04:48 49375 8192000000 10920381376 11377029120 1970001424 19.385 99 32 66 1 1987892128 8854944 9035760
00:05:47 77590 8192000000 10935708000 11380867072 1984293584 19.499 100 14 28 0 1999511904 11163728 4054592
00:07:14 55276 8192000000 10913977664 11382304768 1968061824 19.370 99 7 14 0 1981878672 11848320 1968528
00:08:16 114892 8192000000 10927904944 11400142848 1949947312 19.226 98 4 8 0 1962555472 11535792 1072368
00:10:18 93870 8192000000 10909291040 11378487296 1908630736 18.896 96 10 20 0 1928520112 16876304 3013072
00:11:58 113308 8192000000 10915245248 11381547008 1962764144 19.328 99 30 60 1 1981939504 9870864 9304496
00:14:01 47631 8192000000 10924863088 11376037888 1954252192 19.260 98 43 85 5 1976843632 10825920 11765520
00:14:55 95121 8192000000 10897683744 11360169984 1928098336 19.052 97 26 52 1 1947064944 11342448 7624160
00:16:52 28364 8192000000 10908311280 11360997376 1946968800 19.202 99 26 50 1 1970620112 15895360 7755952
00:17:27 16807 8192000000 10911748256 11369562112 1974061088 19.418 100 41 82 0 2004227856 17181280 12985488
00:17:53 17554 8192000000 10900373296 11338620928 1909969680 18.906 97 44 85 1 1932967552 10485504 12512368
00:18:17 21113 8192000000 10901414496 11356569600 1959841936 19.305 100 32 64 2 1980346416 11220208 9284272
00:18:51 29135 8192000000 10934024720 11376881664 1978534432 19.453 100 54 106 1 2008002880 13667648 15800800
00:19:36 52986 8192000000 10901111664 11377008640 1945352672 19.189 98 24 48 0 1966487584 14395200 6739712
00:20:35 78495 8192000000 10876170544 11350302720 1931378112 19.078 98 18 36 1 1958547408 21105776 6063520
00:22:00 92768 8192000000 10913243136 11390017536 1956679968 19.280 99 14 28 0 1980110976 18916576 4514432
00:23:58 69894 8192000000 10852858544 11323301888 1878298224 18.651 95 16 33 0 1900608208 17301056 5008928
00:25:18 94262 8192000000 10885533104 11339190272 1893148816 18.771 97 3 6 0 1907901824 13853232 899776
00:27:04 94881 8192000000 10885087408 11351830528 1872529792 18.605 95 27 53 3 1890431024 10028384 7872848
00:29:01 140996 8192000000 10846593536 11319943168 1722548816 17.373 88 12 24 0 1739781216 13809360 3423040
00:31:31 104239 8192000000 10839055296 11293118464 1751390672 17.613 91 11 22 1 1762454944 8350688 2713584
00:34:14 59762 8192000000 10873960704 11336081408 1898444944 18.814 98 16 32 1 1916045152 13203488 4396720
00:35:20 65947 8192000000 10865822992 11329519616 1890583664 18.750 98 12 24 1 1910668496 16291376 3793456
00:36:32 91558 8192000000 10855580944 11318501376 1812152832 18.114 94 13 26 2 1843348000 26766112 4429056
00:38:11 116358 8192000000 10865133344 11332227072 1834084576 18.293 95 17 34 2 1855767232 16692832 4989824
00:40:14 48952 8192000000 10872926080 11320610816 1903791744 18.857 98 30 60 0 1922152848 9184448 9176656
00:41:09 104927 8192000000 10867097648 11329290240 1917733264 18.969 99 30 60 3 1938066176 11514208 8818704
00:43:01 31964 8192000000 10885104080 11345985536 1953398016 19.254 100 19 38 0 1967174768 8629280 5147472
00:43:41 39219 8192000000 10907405840 11353706496 1943093968 19.171 99 44 86 1 1964683008 9486320 12102720
00:44:31 40774 8192000000 10899686512 11362091008 1965524368 19.350 100 36 71 1 1988332448 12768944 10039136
00:45:22 20961 8192000000 10892352256 11360825344 1964916880 19.345 100 20 40 1 1980965008 10273792 5774336
00:46:08 60418 8192000000 10886089136 11370168320 1944017200 19.179 99 13 25 0 1963003696 15298112 3688384
00:47:15 48651 8192000000 10903954384 11369840640 1966052992 19.354 100 10 19 2 1977192576 8080016 3059568
00:48:11 60595 8192000000 10888653136 11364802560 1937148512 19.124 98 19 38 1 1956651152 14413648 5088992
00:49:21 31951 8192000000 10877390928 11359649792 1944953200 19.186 99 13 25 1 1959719264 10983728 3782336
00:50:04 49330 8192000000 10879955984 11354488832 1947237616 19.204 99 12 24 1 1961587904 11019792 3330496
00:51:07 57911 8192000000 10868413712 11351371776 1922459232 19.007 98 10 20 0 1936840128 11237072 3143824
00:52:50 60586 8192000000 10884103264 11359789056 1965032416 19.346 100 24 48 2 1978846704 6692256 7122032
00:53:58 56324 8192000000 10877428736 11363205120 1918162240 18.972 97 12 24 0 1931579856 10154496 3263120
00:55:01 66745 8192000000 10898774768 11385741312 1927357472 19.046 98 14 28 1 1942760992 11538480 3865040
00:56:27 56502 8192000000 10892386704 11359059968 1923505200 19.015 98 16 32 3 1941422544 13498208 4419136
00:57:29 66993 8192000000 10901112672 11367960576 1931973920 19.083 98 13 26 0 1945325312 10308512 3042880
00:58:47 50559 8192000000 10908560048 11387883520 1959220944 19.300 99 14 28 0 1976743584 14132032 3390608
00:59:57 62276 8192000000 10914858880 11383468032 1949182528 19.220 98 20 40 1 1972328672 17969616 5176528
01:01:15 89479 8192000000 10888141200 11358752768 1882267856 18.683 95 12 24 0 1901784608 16877840 2638912
01:02:50 60013 8192000000 10909532768 11372548096 1919619840 18.984 97 28 56 0 1938740624 11242640 7878144
01:03:58 27996 8192000000 10939037184 11378651136 1977669376 19.446 100 51 102 2 2005448848 13145904 14633568
01:04:32 16311 8192000000 10915462528 11370160128 1962060720 19.322 99 56 112 1 1995005792 17097712 15847360
01:04:55 36251 8192000000 10932442960 11388674048 1947049104 19.203 98 48 96 1 1979677440 19178944 13449392
01:05:41 37483 8192000000 10907589744 11392393216 1976653344 19.438 100 18 36 0 1999086848 17642480 4791024
01:06:24 58939 8192000000 10912685264 11375222784 1868380848 18.571 94 16 30 1 1881074096 8147504 4545744
01:07:34 35905 8192000000 10918516432 11388911616 1961470096 19.318 99 28 56 1 1982624720 13529504 7625120
01:08:16 122819 8192000000 10901961424 11374104576 1958170832 19.291 99 18 36 0 1976159184 13079360 4908992
01:10:55 99156 8192000000 10894662560 11388760064 1908126656 18.892 96 10 20 2 1932457696 21460032 2871008
01:13:38 87933 8192000000 10852365552 11342176256 1840069456 18.341 94 11 22 0 1860888592 17180560 3638576
01:15:13 60793 8192000000 10852382368 11328966656 1878188496 18.650 97 15 30 0 1894710976 12140784 4381696
01:16:32 70107 8192000000 10830347744 11308687360 1836344736 18.311 95 7 14 0 1852411040 14083216 1983088
01:19:07 88592 8192000000 10873975248 11341824000 1880649616 18.670 97 14 28 2 1899199184 14453408 4096160
01:20:42 68934 8192000000 10881211776 11352903680 1913823568 18.937 98 14 28 0 1935965216 17905792 4235856
01:21:57 44120 8192000000 10866485872 11346264064 1885547264 18.710 97 22 44 0 1914565040 21692384 7325392
01:22:50 67321 8192000000 10828872096 11296960512 1772067712 17.784 92 16 30 0 1795568144 18914144 4586288
01:24:05 33662 8192000000 10844215776 11296894976 1855393328 18.466 97 38 74 1 1883686368 17900048 10392992
01:24:48 30216 8192000000 10857538544 11301130240 1868595552 18.573 98 32 63 2 1887143824 9213264 9335008
01:25:29 39682 8192000000 10856078832 11319816192 1914722000 18.945 100 36 72 1 1937006032 12533152 9750880
01:26:15 56522 8192000000 9612844064 9938513920 748765552 8.374 39 11 22 1 757885808 6016800 3103456

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 09-11-2020 01:28:06 to 09-11-2020 01:28:37.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 189 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-11-2020 01:28:38 to 09-11-2020 01:28:40.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          251426
MON$OLDEST_ACTIVE               251427
MON$OLDEST_SNAPSHOT             251427
MON$NEXT_TRANSACTION            251427
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2057056
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

09.11.20 01:28:41. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2020-11-09 01:28:44 No severe PSQL-related problems occured
09.11.20 01:28:45. End of report.