Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.02.2021 22: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 17114120 kB
MemAvailable 31169776 kB
Buffers 0 kB
Cached 14568968 kB
SwapCached 4772 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.8
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 2021-02-11 22:27:17
DTS_END                         2021-02-11 22:27:17.7890
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/33582
TRN_ID                          242823
ATT_ID                          696
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: 9151.03 20630 1098123
customer order: creation 177.34 362 21281
customer order: refuse 15.03 376 1803
order to supplier: creation 46.33 1267 5559
order to supplier: removal 3.17 108556 380
invoice (draft): creation 47.62 3523 5714
invoice (draft): removal 51.77 788 6212
invoice accept: apply 42.82 18275 5138
invoice accept: cancel 46.42 837 5570
customer reserve: creation 3881.08 184 465730
customer reserve: removal 4542.72 60 545126
realization accept: apply 84.54 165 10145
realization accept: cancel 78.44 115 9413
payment from customer: creation 61.19 122 7343
payment from customer: removal 6.32 86 758
payment to supplier: creation 50.77 132 6092
payment to supplier: removal 3.38 89 406
service: total inventory turnovers 4.72 1315 567
service: total monetary turnovers 6.35 33 762
service: aggregate perf. data 1.00 14293 120
service: refresh index statistics 0.03 262014 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 11-02-2021 22:28:01 to 11-02-2021 22:28:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3943
TEST_TIME 2 4619
TEST_TIME 3 4404
TEST_TIME 4 4627
TEST_TIME 5 5059
TEST_TIME 6 5101
TEST_TIME 7 5118
TEST_TIME 8 5375
TEST_TIME 9 5354
TEST_TIME 10 5520
TEST_TIME 11 5810
TEST_TIME 12 6167
TEST_TIME 13 6296
TEST_TIME 14 6499
TEST_TIME 15 6719
TEST_TIME 16 6969
TEST_TIME 17 7016
TEST_TIME 18 7294
TEST_TIME 19 7326
TEST_TIME 20 8057
TEST_TIME 21 8493
TEST_TIME 22 8689
TEST_TIME 23 8806
TEST_TIME 24 8903
TEST_TIME 25 8849
TEST_TIME 26 9066
TEST_TIME 27 9075
TEST_TIME 28 9426
TEST_TIME 29 9937
TEST_TIME 30 10657
TEST_TIME 31 10829
TEST_TIME 32 10673
TEST_TIME 33 10411
TEST_TIME 34 10373
TEST_TIME 35 10210
TEST_TIME 36 10151
TEST_TIME 37 9952
TEST_TIME 38 9986
TEST_TIME 39 9900
TEST_TIME 40 9790
TEST_TIME 41 9768
TEST_TIME 42 9740
TEST_TIME 43 9671
TEST_TIME 44 9636
TEST_TIME 45 9447
TEST_TIME 46 9358
TEST_TIME 47 9381
TEST_TIME 48 9220
TEST_TIME 49 9181
TEST_TIME 50 9253
TEST_TIME 51 9233
TEST_TIME 52 9155
TEST_TIME 53 9080
TEST_TIME 54 9020
TEST_TIME 55 9050
TEST_TIME 56 9006
TEST_TIME 57 8912
TEST_TIME 58 9014
TEST_TIME 59 9042
TEST_TIME 60 9020
TEST_TIME 61 9011
TEST_TIME 62 9061
TEST_TIME 63 9054
TEST_TIME 64 9006
TEST_TIME 65 9106
TEST_TIME 66 9163
TEST_TIME 67 9199
TEST_TIME 68 9247
TEST_TIME 69 9173
TEST_TIME 70 9309
TEST_TIME 71 9332
TEST_TIME 72 9324
TEST_TIME 73 9451
TEST_TIME 74 9345
TEST_TIME 75 9312
TEST_TIME 76 9233
TEST_TIME 77 9189
TEST_TIME 78 9240
TEST_TIME 79 9202
TEST_TIME 80 9161
TEST_TIME 81 9136
TEST_TIME 82 9090
TEST_TIME 83 9079
TEST_TIME 84 9084
TEST_TIME 85 9069
TEST_TIME 86 9072
TEST_TIME 87 9096
TEST_TIME 88 9088
TEST_TIME 89 9110
TEST_TIME 90 9172
TEST_TIME 91 9135
TEST_TIME 92 9181
TEST_TIME 93 9225
TEST_TIME 94 9260
TEST_TIME 95 9225
TEST_TIME 96 9176
TEST_TIME 97 9251
TEST_TIME 98 9267
TEST_TIME 99 9232
TEST_TIME 100 9167
TEST_TIME 101 9172
TEST_TIME 102 9140
TEST_TIME 103 9123
TEST_TIME 104 9070
TEST_TIME 105 9061
TEST_TIME 106 9010
TEST_TIME 107 9039
TEST_TIME 108 8996
TEST_TIME 109 8982
TEST_TIME 110 8992
TEST_TIME 111 9040
TEST_TIME 112 9065
TEST_TIME 113 9147
TEST_TIME 114 9137
TEST_TIME 115 9114
TEST_TIME 116 9142
TEST_TIME 117 9144
TEST_TIME 118 9149
TEST_TIME 119 9150
TEST_TIME 120 9152

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-02-2021 22:28:05 to 11-02-2021 22:28:08.

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 1529804 1529804 0 0.00 0 18862 6 0 0
doc_list_biud 1529804 1529804 0 0.00 0 76679 27 0 0
sp_add_invoice_to_stock 5220 5138 82 1.57 36 220793 18276 0 82
sp_cancel_adding_invoice 5570 5570 0 0.00 5 79469 838 0 0
sp_cancel_client_order 1803 1803 0 0.00 4 12240 377 0 0
sp_cancel_customer_reserve 545126 545126 0 0.00 1 76681 61 0 0
sp_cancel_pay_from_customer 758 758 0 0.00 3 13936 87 0 0
sp_cancel_pay_to_supplier 406 406 0 0.00 3 4493 89 0 0
sp_cancel_supplier_invoice 6219 6212 7 0.11 1 33534 789 0 7
sp_cancel_supplier_order 380 380 0 0.00 9 1004298 108556 0 0
sp_cancel_write_off 9413 9413 0 0.00 1 13727 115 0 0
sp_client_order 21281 21281 0 0.00 3 37953 362 0 0
sp_customer_reserve 465730 465730 0 0.00 0 124176 185 0 0
sp_fill_shopping_cart 32548 32548 0 0.00 1 30245 41 0 0
sp_fill_shopping_cart_clo_res 465728 465728 0 0.00 0 14803 14 0 0
sp_get_clo_for_invoice 5136 5136 0 0.00 0 21738 292 0 0
sp_kill_cost_storno 16147 16147 0 0.00 0 6291 55 0 0
sp_kill_qstorno_ret_qs2qd 1106257 1106257 0 0.00 0 76672 33 0 0
sp_kill_qty_storno 583785 583785 0 0.00 0 76678 71 0 0
sp_lock_selected_doc 21258 21258 0 0.00 0 8055 5 0 0
sp_make_cost_storno 28716 28716 0 0.00 0 18325 51 0 0
sp_multiply_rows_for_pdistr 28716 28716 0 0.00 0 10557 28 0 0
sp_multiply_rows_for_qdistr 21281 21281 0 0.00 0 18132 167 0 0
sp_pay_from_customer 7343 7343 0 0.00 4 14124 122 0 0
sp_pay_to_supplier 6092 6092 0 0.00 4 18336 132 0 0
sp_payment_common 13435 13435 0 0.00 1 16283 34 0 0
sp_qd_handle_on_cancel_clo 1803 1803 0 0.00 0 12195 341 0 0
sp_qd_handle_on_invoice_upd_sts 10706 10706 0 0.00 0 35563 335 0 0
sp_qd_handle_on_reserve_upd_sts 10145 10145 0 0.00 0 19791 58 0 0
sp_reserve_write_off 10145 10145 0 0.00 6 19840 165 0 0
sp_supplier_invoice 5714 5714 0 0.00 7 91863 3524 0 0
sp_supplier_order 5559 5559 0 0.00 6 72324 1268 0 0
srv_aggregate_perf_data 120 120 0 0.00 2690 125642 14293 0 0
srv_fill_mon_cache_memory 172 172 0 0.00 1133 177885 30985 0 0
srv_find_qd_qs_mism 1049498 1049498 0 0.00 0 11486 6 0 0
srv_make_invnt_saldo 567 567 0 0.00 44 117211 1316 0 0
srv_make_money_saldo 762 762 0 0.00 1 6505 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 192189 342309 262015 0 0
t$perf-abend:sp_add_invoice_to_stock 82 82 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5138 5138 0 0.00 0 10769 156 0 0
t$perf-norm:sp_cancel_adding_invoice 433 433 0 0.00 0 3388 90 0 0
t$perf-norm:sp_cancel_client_order 1803 1803 0 0.00 0 8130 22 0 0
t$perf-norm:sp_cancel_customer_reserve 703 703 0 0.00 0 982 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 758 758 0 0.00 0 5082 21 0 0
t$perf-norm:sp_cancel_pay_to_supplier 406 406 0 0.00 0 5324 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 422 422 0 0.00 0 442 10 0 0
t$perf-norm:sp_cancel_supplier_order 380 380 0 0.00 0 20228 1667 0 0
t$perf-norm:sp_cancel_write_off 1072 1072 0 0.00 0 2141 5 0 0
t$perf-norm:sp_client_order 21281 21281 0 0.00 0 14106 19 0 0
t$perf-norm:sp_customer_reserve 1014 1014 0 0.00 0 2886 10 0 0
t$perf-norm:sp_pay_from_customer 7343 7343 0 0.00 0 7384 9 0 0
t$perf-norm:sp_pay_to_supplier 6092 6092 0 0.00 0 3022 8 0 0
t$perf-norm:sp_reserve_write_off 10145 10145 0 0.00 0 12731 12 0 0
t$perf-norm:sp_supplier_invoice 5714 5714 0 0.00 0 2307 15 0 0
t$perf-norm:sp_supplier_order 5559 5559 0 0.00 0 6486 18 0 0
t$perf-norm:srv_aggregate_perf_data 120 120 0 0.00 0 64 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 625 8 0 0
t$perf-norm:srv_make_invnt_saldo 567 567 0 0.00 0 1085 25 0 0
t$perf-norm:srv_make_money_saldo 762 762 0 0.00 0 1516 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 451 116 0 0
v_add_invoice_to_stock 10436 10272 164 1.57 0 11571 20 0 164
v_all_customers 38578 38578 0 0.00 0 21 1 0 0
v_all_suppliers 31166 31166 0 0.00 0 25 1 0 0
v_all_wares 42562 42562 0 0.00 0 53 1 0 0
v_cancel_adding_invoice 866 866 0 0.00 0 1203 7 0 0
v_cancel_client_order 3606 3606 0 0.00 0 3559 6 0 0
v_cancel_customer_prepayment 1516 1516 0 0.00 0 13895 18 0 0
v_cancel_customer_reserve 1406 1406 0 0.00 0 1468 5 0 0
v_cancel_payment_to_supplier 812 812 0 0.00 0 3832 11 0 0
v_cancel_supplier_invoice 858 844 14 1.63 0 869 15 0 14
v_cancel_supplier_order 760 760 0 0.00 0 470 5 0 0
v_cancel_write_off 2144 2144 0 0.00 0 3113 16 0 0
v_max_id_clo_ord 5559 5559 0 0.00 0 165 1 0 0
v_max_id_clo_res 1014 1014 0 0.00 0 3446 9 0 0
v_max_id_ord_sup 5708 5708 0 0.00 0 8774 5 0 0
v_max_non_paid_invoice 1776 1776 0 0.00 0 1429 4 0 0
v_max_non_paid_realizn 3920 3920 0 0.00 0 5404 4 0 0
v_min_id_clo_ord 5559 5559 0 0.00 0 3845 10 0 0
v_min_id_clo_res 1014 1014 0 0.00 0 6541 10 0 0
v_min_id_ord_sup 5708 5708 0 0.00 0 7003 10 0 0
v_min_non_paid_invoice 6092 6092 0 0.00 0 16277 21 0 0
v_min_non_paid_realizn 7343 7343 0 0.00 0 9199 21 0 0
v_our_firm 10830 10830 0 0.00 0 22 1 0 0
v_reserve_write_off 20290 20290 0 0.00 0 7554 6 0 0
x_lock_depdocs_on_canc_invoice 11360 11360 0 0.00 0 24715 117 0 0
x_lock_depdocs_on_canc_sup_ord 380 380 0 0.00 0 5965 322 0 0
x_make_qstorno_1000_1200 5559 5559 0 0.00 2 72319 1183 0 0
x_make_qstorno_1200_2000 5714 5714 0 0.00 3 91854 3374 0 0
x_make_qstorno_2100_3300 465730 465730 0 0.00 0 124175 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-02-2021 22:28:09 to 11-02-2021 22:28:13.

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
19:57:21 4 8192000000 8803570752 8815480832 8233760 0.100 2 1 2 0 8353168 56848 62560
19:57:28 14847 8192000000 10221035440 10524520448 853024608 9.430 68 57 114 0 873969504 2344144 18600752
19:57:53 31509 8192000000 10327114880 10643574784 1373561008 14.359 100 82 164 0 1405750144 4835760 27353376
19:58:35 33985 8192000000 10385300960 10708410368 1420466656 14.777 100 87 174 0 1455548016 6348800 28732560
19:59:20 20436 8192000000 10409008336 10734018560 1465282064 15.172 100 93 186 0 1503335424 7865488 30187872
19:59:51 25741 8192000000 10433147840 10761031680 1489883776 15.388 100 94 188 1 1528878784 8389952 30605056
20:00:38 21200 8192000000 10454163424 10789003264 1505267312 15.522 100 86 172 0 1542157696 9067680 27822704
20:01:06 15156 8192000000 10468670368 10805116928 1518883232 15.641 100 87 174 0 1555929872 9296496 27750144
20:01:31 15077 8192000000 10481804208 10825588736 1543122832 15.851 100 80 160 0 1577778048 9600624 25054592
20:01:57 20051 8192000000 10522240032 10871222272 1568495120 16.069 100 80 160 1 1603042784 9824544 24723120
20:02:26 9212 8192000000 10538803024 10891862016 1599608752 16.336 100 84 168 0 1636420848 10805152 26006944
20:02:44 13003 8192000000 10553230320 10906607616 1607696400 16.405 100 77 154 2 1642255664 10909280 23649984
20:03:04 10320 8192000000 10580344160 10939023360 1641554464 16.693 100 79 159 0 1676907840 11587952 23765424
20:03:24 11445 8192000000 10601706784 10964185088 1654476240 16.802 100 81 161 0 1690661728 12193536 23991952
20:03:44 11148 8192000000 10623729392 10990092288 1678216688 17.002 100 74 148 1 1711498896 11224656 22057552
20:04:02 10938 8192000000 10634123808 11001020416 1696207168 17.153 100 74 146 2 1730224512 12725696 21291648
20:04:20 8165 8192000000 10646403360 11019329536 1708737296 17.258 100 77 154 2 1744236096 13001744 22497056
20:04:36 6722 8192000000 10658881584 11035365376 1726042320 17.403 100 79 156 1 1760582656 12513536 22026800
20:04:50 7621 8192000000 10674548112 11051610112 1731329984 17.447 100 73 146 0 1765022928 12916736 20776208
20:05:05 5044 8192000000 10684305808 11065868288 1748144160 17.586 100 72 144 0 1781210512 12249456 20816896
20:05:18 4463 8192000000 10708636032 11085127680 1765962432 17.734 100 79 158 1 1800877616 13022544 21892640
20:05:29 4195 8192000000 10717161600 11094896640 1775417632 17.812 100 82 164 0 1811993968 13874752 22701584
20:05:40 2532 8192000000 10720635024 11099123712 1782464144 17.870 100 84 170 0 1820222352 13800432 23957776
20:05:49 6491 8192000000 10724440624 11106697216 1788067632 17.916 100 77 154 0 1821680624 12151984 21461008
20:06:03 7403 8192000000 10733577888 11114250240 1794427152 17.968 100 77 156 1 1828269184 13045888 20796144
20:06:16 2864 8192000000 10745701936 11128000512 1814456896 18.132 100 90 178 1 1852870976 13287728 25126352
20:06:26 2685 8192000000 10760708672 11141996544 1817355968 18.156 100 86 172 0 1855516432 13347680 24812784
20:06:35 3194 8192000000 10763702544 11147689984 1824615792 18.215 100 90 179 0 1863441264 14176528 24648944
20:06:45 3443 8192000000 10771915824 11154661376 1828999440 18.251 100 85 170 1 1865646688 12840688 23806560
20:06:56 1946 8192000000 10777178144 11158020096 1831141344 18.269 100 87 174 0 1868988688 12776256 25071088
20:07:05 1675 8192000000 10779410208 11163631616 1839115808 18.334 100 90 181 1 1876841216 12939584 24785824
20:07:13 2613 8192000000 10788801856 11173085184 1843450640 18.369 100 89 175 2 1880177472 13156224 23570608
20:07:22 2286 8192000000 10787649104 11171446784 1844223392 18.375 100 95 191 0 1884343312 13244032 26875888
20:07:31 1887 8192000000 10791865552 11177381888 1851515760 18.434 100 95 191 1 1892894112 14610464 26767888
20:07:39 2313 8192000000 10796982480 11185733632 1857201456 18.481 100 92 183 1 1900430912 17309696 25919760
20:07:48 2399 8192000000 10804087552 11189989376 1856156272 18.472 100 90 178 2 1894236048 13081856 24997920
20:07:57 1738 8192000000 10808213904 11195949056 1861767744 18.518 100 85 171 0 1899011744 13121920 24122080
20:08:05 12556 8192000000 10777651328 11186577408 1857853376 18.486 100 58 116 2 1884575536 10855408 15866752
20:08:24 2811 8192000000 10786202608 11189809152 1858671248 18.493 100 44 88 1 1879562944 8103056 12788640
20:08:33 2519 8192000000 10795134368 11193651200 1865597424 18.549 100 61 124 0 1891877648 8778304 17501920
20:08:43 3369 8192000000 10794339040 11197915136 1869359776 18.579 100 60 120 2 1897590416 11670144 16560496
20:08:52 3591 8192000000 10787443744 11196788736 1867270160 18.562 100 58 117 0 1893974208 10111616 16592432
20:09:03 3538 8192000000 10783055488 11199070208 1869835568 18.583 100 46 92 1 1892261568 9455808 12970192
20:09:14 3744 8192000000 10782719808 11195793408 1868495440 18.572 100 35 70 0 1886592528 8135360 9961728
20:09:26 4561 8192000000 10779630752 11198496768 1871260096 18.594 100 49 98 1 1893935968 8570480 14105392
20:09:40 5489 8192000000 10782049200 11203817472 1870813904 18.591 100 37 76 0 1888650560 7146208 10690448
20:09:52 5574 8192000000 10782025776 11200454656 1868989520 18.576 100 27 54 1 1882796560 5701424 8105616
20:10:04 7077 8192000000 10780257248 11204571136 1871833856 18.599 100 23 47 0 1885665840 6955104 6876880
20:10:19 11206 8192000000 10772190416 11203207168 1871287632 18.595 100 19 38 1 1883269152 5977008 6004512
20:10:39 7223 8192000000 10780747232 11207057408 1874480368 18.621 100 31 60 1 1888463536 5959984 8023184
20:10:52 38155 8192000000 10789303584 11216920576 1878082240 18.650 100 27 53 3 1891220688 5199088 7939360
20:12:06 4857 8192000000 10802097088 11225153536 1888735488 18.736 100 67 136 1 1916917392 8396464 19785440
20:12:18 3131 8192000000 10803410736 11223449600 1881679216 18.679 100 29 58 3 1897593552 7699648 8214688
20:12:28 8242 8192000000 10799446704 11225034752 1882877360 18.688 100 26 51 5 1900616096 11353600 6385136
20:12:43 5059 8192000000 10800781280 11230007296 1881086080 18.674 100 26 52 0 1899114768 10858544 7170144
20:12:56 8960 8192000000 10797555632 11228995584 1884162224 18.699 100 21 41 0 1899826704 10169264 5495216
20:13:12 5185 8192000000 10810233232 11230650368 1886354512 18.716 100 31 63 0 1902194976 7163504 8676960
20:13:23 7855 8192000000 10798811600 11228495872 1885918624 18.713 100 21 40 2 1897997728 6473216 5605888
20:13:42 10977 8192000000 10789514784 11226849280 1883815296 18.696 100 11 22 0 1891717552 5226320 2675936
20:14:01 7688 8192000000 10808489760 11235700736 1892222464 18.764 100 24 48 1 1905542688 6098448 7221776
20:14:15 8892 8192000000 10807229616 11235983360 1891860384 18.761 100 16 32 0 1902125824 6015424 4250016
20:14:33 17901 8192000000 10804912016 11242622976 1898667120 18.816 100 22 44 2 1911337248 5868688 6801440
20:14:58 9755 8192000000 10811071648 11244630016 1901761136 18.840 100 20 40 2 1913581680 5991392 5829152
20:15:18 10983 8192000000 10804159008 11241967616 1883698528 18.695 99 19 38 3 1899227008 10543360 4985120
20:15:37 63217 8192000000 10819293648 11252064256 1900472864 18.830 100 23 45 0 1912132992 5320640 6339488
20:16:47 20191 8192000000 10815680064 11246469120 1883856016 18.696 99 15 30 1 1893095424 5344624 3894784
20:17:17 5970 8192000000 10800015424 11237654528 1892043584 18.762 100 25 50 3 1905711472 6431792 7236096
20:17:30 5477 8192000000 10796604688 11217256448 1844387168 18.377 98 28 56 1 1858804640 6385920 8031552
20:17:44 4541 8192000000 10737813248 11154345984 1804804048 18.053 98 28 55 1 1820319936 7383824 8132064
20:17:59 9351 8192000000 10747221424 11176972288 1821863072 18.193 98 26 52 0 1835173024 5943712 7366240
20:18:16 5454 8192000000 10779934448 11200872448 1838746304 18.331 99 29 58 0 1853328016 6612608 7969104
20:18:29 11390 8192000000 10734007936 11154956288 1733217872 17.462 93 16 32 1 1742871056 5126768 4526416
20:18:50 6711 8192000000 10747857584 11174576128 1830132160 18.260 100 18 36 0 1841085424 5933824 5019440
20:19:03 7234 8192000000 10734728640 11152777216 1780663280 17.855 97 23 46 1 1793461104 5700720 7097104
20:19:17 6271 8192000000 10719409728 11131121664 1735032592 17.477 96 26 51 1 1748228048 5723760 7471696
20:19:31 8021 8192000000 10706492416 11124400128 1710527216 17.273 95 24 48 2 1723357376 5883184 6946976
20:19:54 8247 8192000000 10711191664 11118407680 1740427696 17.522 96 34 69 0 1756184576 5849360 9907520
20:20:09 9682 8192000000 10710042368 11125096448 1778568368 17.838 99 18 36 1 1789078752 5441216 5069168
20:20:25 61767 8192000000 10717044000 11109572608 1711666912 17.283 95 45 90 2 1729587360 5174368 12746080
20:21:33 8064 8192000000 10706096384 11124592640 1785796912 17.897 100 31 59 3 1802205104 8442496 7965696
20:21:52 6147 8192000000 10699775728 11109994496 1715021392 17.311 96 29 58 1 1732690720 10043728 7625600
20:22:04 7602 8192000000 10687927392 11099049984 1735593584 17.482 98 31 62 1 1759992304 15844096 8554624
20:22:20 3112 8192000000 10721850192 11134042112 1797821296 17.996 100 40 79 3 1820644736 11846336 10977104
20:22:30 7469 8192000000 10717496976 11136241664 1787510752 17.911 99 27 54 0 1801342416 6232960 7598704
20:22:44 6030 8192000000 10723400976 11144314880 1777439440 17.828 98 28 56 0 1792243440 6946272 7857728
20:23:00 6561 8192000000 10744901536 11161378816 1818908528 18.169 100 32 60 1 1837851824 9797520 9145776
20:23:13 9631 8192000000 10746522272 11171528704 1828889456 18.250 100 24 44 3 1841576768 5732512 6954800
20:23:31 6115 8192000000 10745983888 11169251328 1834543072 18.296 100 25 50 1 1847963168 5425536 7994560
20:23:48 6239 8192000000 10759886192 11180068864 1840912816 18.348 100 23 46 0 1858301728 10943152 6445760
20:24:03 11211 8192000000 10759679264 11185008640 1846421888 18.393 100 23 47 2 1858351520 5116176 6813456
20:24:22 73935 8192000000 10768041872 11201056768 1851245744 18.432 100 25 49 2 1868065440 9333552 7486144
20:25:42 13010 8192000000 10783451184 11204050944 1860633968 18.508 100 21 42 0 1871871328 5380064 5857296
20:26:02 7513 8192000000 10783436368 11207393280 1865150144 18.545 100 36 71 1 1882044208 7103120 9790944
20:26:16 5427 8192000000 10772090656 11204583424 1864248448 18.538 100 30 60 1 1880054880 7454480 8351952
20:26:30 10838 8192000000 10788150400 11211145216 1865355632 18.547 100 35 70 1 1882580384 6538016 10686736
20:26:47 7348 8192000000 10782211744 11209203712 1865714608 18.550 100 22 44 2 1877596784 5070448 6811728
20:27:01 7148 8192000000 10783766256 11215339520 1874488432 18.621 100 29 58 3 1888982960 6507728 7986800
20:27:14 10428 8192000000 10816648240 11232567296 1885165888 18.707 100 21 42 0 1895864688 4573856 6124944
20:27:38 36991 8192000000 10830919232 11250884608 1901180656 18.836 100 46 92 2 1919684832 5754832 12749344
20:28:26 9535 8192000000 10849993216 11262365696 1911523824 18.919 100 44 88 0 1934512864 10239840 12749200
20:28:47 12541 8192000000 10854302272 11269808128 1915341776 18.950 100 40 79 0 1936360064 9848736 11169552
20:29:10 7367 8192000000 10859718160 11277942784 1921193008 18.996 100 48 96 0 1945875968 11054320 13628640
20:29:24 33517 8192000000 10867399312 11290767360 1929985632 19.067 100 41 81 1 1958141776 16517024 11639120
20:30:04 68898 8192000000 10853855280 11292299264 1931635136 19.080 100 27 52 2 1951295568 11901776 7758656
20:31:32 34588 8192000000 10866277264 11302682624 1938424560 19.134 100 38 74 2 1963846240 13523136 11898544
20:32:20 8777 8192000000 10885098208 11313045504 1946200608 19.196 100 45 90 0 1973489408 14088016 13200784
20:32:38 6637 8192000000 10895023168 11317362688 1952835936 19.249 100 44 87 1 1978296880 12936672 12524272
20:32:52 9486 8192000000 10895076704 11323432960 1959299360 19.300 100 59 118 0 1994915936 18496224 17120352
20:33:18 14183 8192000000 10893247280 11331383296 1960544800 19.310 100 39 76 2 1988061552 16504672 11012080
20:33:53 9374 8192000000 10910870496 11342041088 1970724560 19.391 100 53 104 1 2002176192 15758192 15693440
20:34:11 9997 8192000000 10911248464 11344384000 1973715392 19.415 100 46 92 2 2005736048 17807920 14212736
20:34:29 9615 8192000000 10923288720 11350372352 1975974336 19.433 100 52 102 4 2011836416 20639136 15222944
20:34:47 15569 8192000000 10931344624 11360329728 1982154144 19.482 100 59 119 1 2018720704 19717504 16849056
20:35:14 11661 8192000000 10923652832 11363287040 1984534960 19.501 100 41 82 0 2015902720 19328288 12039472
20:35:33 3488 8192000000 10937981600 11370246144 1991004560 19.552 100 51 102 0 2026930496 20399104 15526832
20:35:46 17154 8192000000 10949888128 11380740096 2000694544 19.628 100 59 116 3 2039060432 19847136 18518752
20:36:20 23063 8192000000 10944615472 11379458048 1996082816 19.592 100 51 102 0 2033962240 22098416 15781008
20:37:01 13720 8192000000 10945105680 11381460992 1992097120 19.560 100 53 106 1 2035309024 26591712 16620192
20:37:27 7129 8192000000 10947015664 11381403648 1978537472 19.453 99 55 110 1 2022700832 27705120 16458240
20:37:42 4411 8192000000 10953178288 11385131008 1997535008 19.603 100 60 120 0 2043508128 27488288 18484832
20:38:01 6502 8192000000 10966549776 11394019328 2002048352 19.639 100 65 130 1 2051677472 28759616 20869504
20:38:18 9648 8192000000 10953747456 11384340480 1987587856 19.525 99 71 140 0 2038301872 28770832 21943184
20:38:40 11456 8192000000 10939569072 11377287168 1976835344 19.440 99 52 102 2 2016704976 24171504 15698128
20:39:06 1481 8192000000 10961862432 11391254528 2005035824 19.662 100 69 135 3 2051115680 25317936 20761920
20:39:16 5121 8192000000 10958148912 11389677568 1999530112 19.619 100 63 124 0 2047243440 28655424 19057904
20:39:31 5454 8192000000 10972148448 11394273280 2003914096 19.654 100 67 133 1 2054189872 30220608 20055168
20:39:43 3916 8192000000 10945409280 11369943040 1981529456 19.477 99 72 142 3 2029393424 25921024 21942944
20:39:58 2947 8192000000 10966654880 11390361600 2001223008 19.632 100 67 133 1 2047665904 26676240 19766656
20:40:08 11708 8192000000 10956645632 11387195392 1997207056 19.601 100 57 113 2 2040952320 26687824 17057440
20:40:27 4861 8192000000 10963904368 11392061440 2003893616 19.653 100 64 127 2 2050738816 26976880 19868320
20:40:40 3146 8192000000 10953865952 11375857664 1987615840 19.525 99 76 152 1 2038310912 28006288 22688784
20:40:51 1789 8192000000 10979878064 11392184320 2005339424 19.665 100 84 165 2 2059732720 29182256 25211040
20:41:02 9845 8192000000 10971787456 11399356416 2011155184 19.711 100 70 140 1 2062858080 30144208 21558688
20:41:22 4878 8192000000 10965468528 11393118208 2003917504 19.654 100 74 148 1 2054215904 27937376 22361024
20:41:34 1323 8192000000 10971505952 11382067200 1995769392 19.589 100 87 173 2 2051233552 29366304 26097856
20:41:43 4868 8192000000 10974322016 11396063232 2001122608 19.632 100 68 134 0 2052420240 30945552 20352080
20:41:56 3631 8192000000 10974452288 11396411392 2004041968 19.655 100 80 159 1 2057486032 29845648 23598416
20:42:09 2581 8192000000 10985889328 11404144640 2008737776 19.692 100 88 177 2 2067229072 32920672 25570624
20:42:19 2196 8192000000 10974110048 11394551808 1999882864 19.622 100 78 156 0 2057457232 33622144 23952224
20:42:30 2157 8192000000 10983702928 11404427264 2007997024 19.686 100 81 161 0 2066147360 33808432 24341904
20:42:40 2889 8192000000 10979570112 11399147520 1993646496 19.573 99 90 179 1 2056032368 35030192 27355680
20:42:50 6186 8192000000 10976494512 11404824576 2005804752 19.668 100 71 142 1 2061973536 34266800 21901984
20:43:04 5694 8192000000 10948183488 11373973504 1973956112 19.417 99 67 132 0 2029463440 34440320 21067008
20:43:19 4567 8192000000 10949559056 11382398976 1985582864 19.509 100 62 122 3 2040051328 35255104 19213360
20:43:32 2787 8192000000 10954600848 11376439296 1975474240 19.429 100 73 146 0 2035311328 36537136 23299952
20:43:43 3915 8192000000 10939440800 11347890176 1952389424 19.246 98 78 156 1 2013065344 35918976 24756944
20:43:54 9009 8192000000 10945569536 11365969920 1972266384 19.403 100 63 126 0 2027344976 35722752 19355840
20:44:12 6316 8192000000 10967856384 11394236416 1989502336 19.540 100 64 128 3 2050880912 41490608 19887968
20:44:25 8853 8192000000 10980045888 11404451840 1996327520 19.594 100 66 132 0 2060232688 43237472 20667696
20:44:42 1927 8192000000 10987775376 11407753216 2003101904 19.647 100 86 171 2 2072789792 43747328 25940560
20:44:51 2330 8192000000 10993966704 11410214912 2005109840 19.663 100 87 172 2 2073026864 42630224 25286800
20:45:00 2893 8192000000 10956252320 11363389440 1964365856 19.341 99 82 164 2 2031956304 42908816 24681632
20:45:10 3110 8192000000 10962822240 11371180032 1969991008 19.385 99 86 172 1 2043834304 47069440 26773856
20:45:20 1389 8192000000 10972378128 11378855936 1975305040 19.428 100 87 170 2 2047564240 45899888 26359312
20:45:28 3088 8192000000 10959312304 11376291840 1971954944 19.401 100 79 156 1 2043752544 47298800 24498800
20:45:38 2925 8192000000 10961467024 11372859392 1974645600 19.422 100 94 188 0 2049502528 45672960 29183968
20:45:49 1416 8192000000 10965669552 11371098112 1967807008 19.368 100 89 176 0 2041420688 46032096 27581584
20:45:57 1534 8192000000 10967774064 11376594944 1962583264 19.327 99 87 175 0 2036793248 47483008 26726976
20:46:06 2283 8192000000 10972451552 11383771136 1962499408 19.326 99 90 181 1 2039971584 49443648 28028528
20:46:16 5260 8192000000 10948294224 11360489472 1956956144 19.282 99 82 161 1 2033449168 51088720 25404304
20:46:29 3695 8192000000 10966292000 11378601984 1964700240 19.343 100 79 158 0 2044114864 54016320 25398304
20:46:41 1133 8192000000 10979442704 11384504320 1972669760 19.407 100 88 172 2 2055112496 54776176 27666560
20:46:50 2642 8192000000 10962984400 11372990464 1938802624 19.137 98 91 182 4 2022714864 54893056 29019184
20:47:00 3307 8192000000 10964359056 11373572096 1950237184 19.228 99 80 160 0 2032066256 56073760 25755312
20:47:10 2081 8192000000 10965849472 11377176576 1960989632 19.314 100 87 174 0 2046765552 57707424 28068496
20:47:20 5726 8192000000 10948768080 11371704320 1950451760 19.230 100 64 128 0 2028634240 56317600 21864880
20:47:32 2044 8192000000 10967797232 11374874624 1962285232 19.324 100 83 166 0 2048680592 59383312 27012048
20:47:41 9435 8192000000 10956864304 11394588672 1964614240 19.343 100 49 98 1 2041141536 59131056 17396240
20:47:58 18627 8192000000 10937948944 11373924352 1933137792 19.092 98 45 91 0 2000872592 52495904 15238896
20:48:25 9036 8192000000 10936929376 11370504192 1960202272 19.308 100 48 96 0 2021107056 45056320 15848464
20:48:42 4757 8192000000 10926065152 11366457344 1951639632 19.240 100 35 70 1 2006623008 42666256 12317120
20:48:54 8639 8192000000 10906115088 11342450688 1910828592 18.913 98 50 99 0 1969275648 42752528 15694528
20:49:13 6318 8192000000 10900337920 11322441728 1924167056 19.020 99 56 111 1 1977018384 35550528 17300800
20:49:26 2753 8192000000 10925892160 11347488768 1948368464 19.213 100 68 133 0 2005869744 37196032 20305248
20:49:35 9088 8192000000 10928792896 11358146560 1951252752 19.236 100 55 108 2 2010193408 41880720 17059936
20:49:59 4272 8192000000 10932335168 11343765504 1944957008 19.186 100 72 144 4 2007455696 40160688 22338000
20:50:11 3742 8192000000 10890091888 11313401856 1895623920 18.791 98 51 101 1 1954916352 43040768 16251664
20:50:28 13321 8192000000 10896301776 11338526720 1930415232 19.070 100 44 87 0 1990740032 44721728 15603072
20:50:48 21134 8192000000 10898373456 11334664192 1914555536 18.943 99 31 62 1 1967596784 42250576 10790672
20:51:18 18851 8192000000 10905312736 11343552512 1931216400 19.077 100 31 62 1 1986289888 43924432 11149056
20:51:55 14582 8192000000 10909572880 11340828672 1924497776 19.023 99 36 71 1 1978392048 42728320 11165952
20:52:16 19081 8192000000 10914041280 11353518080 1942762000 19.169 100 23 46 2 1993295120 42617616 7915504
20:52:45 9742 8192000000 10912180544 11350441984 1928289472 19.053 99 29 58 0 1985552240 47350576 9912192
20:53:03 9179 8192000000 10922593792 11366981632 1945417840 19.190 100 29 58 2 2004918896 50036128 9464928
20:53:47 14047 8192000000 10899417968 11357536256 1929105568 19.060 100 19 38 1 1985163904 49371984 6686352
20:54:30 32719 8192000000 10914259136 11370975232 1938955360 19.138 100 26 53 1 2004596368 56809808 8831200
20:55:11 35368 8192000000 10900570832 11365687296 1932279168 19.085 100 20 40 2 1994712400 55078816 7354416
20:55:54 15831 8192000000 10906922544 11368804352 1931907200 19.082 100 14 28 0 1989807216 52245536 5654480
20:56:17 40721 8192000000 10890428176 11346178048 1895791936 18.792 98 29 56 1 1955714736 50397856 9524944
20:57:05 37753 8192000000 10855783952 11315654656 1876518960 18.637 97 11 22 2 1895481920 15897136 3065824
20:57:50 52436 8192000000 10883810496 11332435968 1913746048 18.937 99 16 32 1 1937456976 18770224 4940704
20:58:49 81209 8192000000 10874768096 11327717376 1906428560 18.878 98 14 27 2 1922978064 12787760 3761744
21:01:04 15513 8192000000 10897271360 11340009472 1955354432 19.269 100 42 79 1 1971986416 4321744 12310240
21:01:36 45397 8192000000 10887778736 11333537792 1923740224 19.017 98 37 74 1 1941659264 7855760 10063280
21:02:48 110138 8192000000 10877807040 11335405568 1898106944 18.811 97 22 46 0 1912843536 8217152 6519440
21:04:48 177885 8192000000 10875228688 11345620992 1910536672 18.911 97 26 53 0 1928863808 10328528 7998608
21:07:53 55749 8192000000 10885992144 11353219072 1935997472 19.115 99 19 38 1 1951188016 9403760 5786784
21:08:58 55261 8192000000 10886151888 11354845184 1959683504 19.304 100 7 14 0 1972354480 10619808 2051168
21:10:01 47998 8192000000 10897260832 11366522880 1975409216 19.428 100 10 18 2 1990711168 12588096 2713856
21:11:16 52840 8192000000 10885290528 11351531520 1957374416 19.285 99 12 24 1 1974618032 14238672 3004944
21:12:20 106865 8192000000 10887383328 11359305728 1953983088 19.258 99 26 52 1 1976641472 14440992 8217392
21:15:39 13977 8192000000 10902453104 11369005056 1975614048 19.430 100 18 36 0 1990114304 9374336 5125920
21:16:01 2938 8192000000 10910403088 11371528192 1985024048 19.504 100 40 78 2 2006828000 10740000 11063952
21:16:10 30409 8192000000 10909533504 11377389568 1990539072 19.548 100 33 62 2 2012216368 12958272 8719024
21:16:53 43210 8192000000 10901776464 11383115776 1988974624 19.536 100 38 76 3 2015132672 14149584 12008464
21:17:58 66230 8192000000 10892651776 11378368512 1960658400 19.311 99 7 14 1 1975724992 13190576 1876016
21:19:15 61287 8192000000 10897028240 11370938368 1965439664 19.349 99 16 32 1 1982060752 12039696 4581392
21:20:22 77769 8192000000 10877422640 11356569600 1963399280 19.333 100 8 16 1 1974256528 8608720 2248528
21:22:07 46840 8192000000 10905429280 11361030144 1977013280 19.441 100 36 72 0 1994881888 8164864 9703744
21:23:01 54217 8192000000 10893755120 11369361408 1961757984 19.320 99 17 33 0 1973757344 7545456 4453904
21:24:05 73153 8192000000 10887747952 11369082880 1958849360 19.297 99 11 22 2 1972707504 10641392 3216752
21:25:25 51169 8192000000 10884158144 11370692608 1955095136 19.267 99 5 10 0 1969267584 12066544 2105904
21:26:23 62780 8192000000 10891200352 11375394816 1957561584 19.287 99 11 22 2 1973345760 12621840 3162336
21:27:41 46350 8192000000 10898933520 11371032576 1965671552 19.351 99 23 46 2 1982834864 11213232 5950080
21:28:33 14650 8192000000 10896691152 11361046528 1945665184 19.192 98 30 60 1 1961659440 7588352 8405904
21:28:55 51297 8192000000 10869714400 11342864384 1923204544 19.013 97 28 55 3 1946151808 15494944 7452320
21:29:56 46329 8192000000 10864635392 11326783488 1880473728 18.669 96 17 34 1 1893349440 7957056 4918656
21:30:56 52949 8192000000 10894210912 11338043392 1878796800 18.655 96 35 70 2 1903081616 14735184 9549632
21:31:56 73960 8192000000 10858505344 11329667072 1866731296 18.558 96 15 30 1 1888454240 17624880 4098064
21:33:22 46482 8192000000 10870150512 11335405568 1882218176 18.683 97 23 45 1 1898505392 10172416 6114800
21:34:22 45670 8192000000 10867597536 11336708096 1904620208 18.863 98 22 44 1 1924193328 13543296 6029824
21:35:14 57811 8192000000 10861589968 11312480256 1886652912 18.719 97 24 48 1 1901879872 9115904 6111056
21:36:20 54892 8192000000 10867944992 11325992960 1857681968 18.484 95 36 72 0 1883093760 14890048 10521744
21:37:23 80951 8192000000 10852421968 11330928640 1853018320 18.447 96 13 26 0 1875360864 18454864 3887680
21:38:50 62327 8192000000 10879166224 11353796608 1919941344 18.986 99 24 48 1 1946771168 20330720 6499104
21:40:01 138239 8192000000 10860981536 11329388544 1922068816 19.003 99 12 23 1 1948488064 22716432 3702816
21:42:37 69125 8192000000 10884505696 11345416192 1932053040 19.083 99 25 50 0 1945490432 6190912 7246480
21:43:52 36311 8192000000 10876116080 11339784192 1920617632 18.992 98 35 70 0 1941300048 10798448 9883968
21:44:35 16861 8192000000 10874210016 11321208832 1915998544 18.955 98 48 95 0 1939212960 9865600 13348816
21:44:59 49027 8192000000 10818413584 11285512192 1841088736 18.350 95 21 42 1 1857432928 10562400 5781792
21:46:00 46696 8192000000 10823203344 11293216768 1855134048 18.464 97 10 18 0 1866349072 8683952 2531072
21:46:53 68783 8192000000 10837511984 11307450368 1870246544 18.586 97 13 24 0 1884319808 10884832 3188432
21:48:08 45855 8192000000 10836809024 11291631616 1891837088 18.761 99 8 16 0 1907207440 13041840 2328512
21:49:04 33688 8192000000 10843347728 11316604928 1923249312 19.013 100 13 26 0 1939458704 11882800 4326592
21:49:49 55057 8192000000 10845174176 11315859456 1914046400 18.939 100 10 20 0 1930296000 13291504 2958096
21:51:07 34864 8192000000 10854478064 11316981760 1914688480 18.944 99 37 74 2 1938100752 12639120 10773152
21:52:08 60792 8192000000 10860657024 11321434112 1908319888 18.893 99 17 32 0 1923031312 10164752 4546672
21:53:20 57105 8192000000 10864351776 11333861376 1918850592 18.978 99 14 28 0 1933537424 10787312 3899520
21:54:23 76287 8192000000 10857047968 11324403712 1840659360 18.346 95 11 22 0 1853342736 9643952 3039424
21:55:46 51330 8192000000 10866113728 11333255168 1918283792 18.973 99 29 58 0 1939128384 12333120 8511472
21:56:53 41327 8192000000 10875501200 11338801152 1897224224 18.804 98 18 36 1 1912462592 10653024 4585344
21:57:44 60692 8192000000 10884588016 11342663680 1906352432 18.877 98 13 26 0 1924855520 14930640 3572448
21:58:51 60079 8192000000 10895053520 11362271232 1957102352 19.283 100 17 34 0 1973893248 11459616 5331280
22:00:04 134111 8192000000 10918707824 11377463296 1942300912 19.165 98 12 24 0 1962154816 16772704 3081200
22:02:27 34545 8192000000 10905286032 11365806080 1957781936 19.288 99 25 50 1 1973438192 8686880 6969376
22:03:08 10527 8192000000 10936569280 11379310592 1980635760 19.470 100 36 70 0 1998880080 7761040 10483280
22:03:27 23109 8192000000 10953216864 11389452288 1993824928 19.574 100 58 116 1 2021416880 11343024 16248928
22:03:59 15343 8192000000 10946010816 11392602112 1993682688 19.573 100 65 130 0 2024114992 12349712 18082592
22:04:24 72401 8192000000 10907553104 11384328192 1924144576 19.020 97 20 38 2 1939932656 10622608 5165472
22:05:46 157502 8192000000 10890957616 11371954176 1892080704 18.763 95 14 28 0 1906466336 10358736 4026896
22:09:02 12996 8192000000 10913427584 11382083584 1973289440 19.412 100 23 46 3 1994965104 15437440 6238224
22:09:22 30255 8192000000 10892365568 11366162432 1958822416 19.297 99 23 46 0 1977276112 12113664 6340032
22:10:02 62751 8192000000 10898434832 11383988224 1977337808 19.444 100 11 22 0 1988047856 7512512 3197536
22:11:17 33265 8192000000 10905298304 11391332352 1981809184 19.479 100 6 12 0 1992528880 9035936 1683760
22:11:57 55716 8192000000 10891382912 11375923200 1925592624 19.032 97 7 13 0 1938163584 10531104 2039856
22:12:59 43683 8192000000 10887563680 11374018560 1961110656 19.315 99 16 32 1 1976011088 10382240 4518192
22:13:56 75766 8192000000 10872218736 11363094528 1892222400 18.764 96 8 16 0 1910710672 15737264 2751008
22:15:18 79915 8192000000 10906690336 11383771136 1937782672 19.129 97 36 72 1 1959583232 11292560 10508000
22:16:44 43408 8192000000 10919084128 11393515520 1969732224 19.383 99 17 34 0 1988781280 13752688 5296368
22:17:42 59237 8192000000 10885486416 11370549248 1893843072 18.777 95 20 40 0 1919741968 19425888 6473008
22:18:48 47062 8192000000 10892649968 11362783232 1926230016 19.037 98 21 42 0 1948118912 16059648 5829248
22:19:48 59619 8192000000 10863161024 11348041728 1892782512 18.768 97 7 14 0 1908746048 14069792 1893744
22:21:00 64883 8192000000 10881849280 11342897152 1889311200 18.740 97 15 30 0 1906745824 13387024 4047600
22:22:15 24558 8192000000 10868996864 11329404928 1895184912 18.788 97 40 80 0 1914924192 8584880 11154400
22:22:46 22323 8192000000 10869531152 11323990016 1906626144 18.880 98 44 88 0 1931859936 13211728 12022064
22:23:16 53115 8192000000 10887615424 11355488256 1908484784 18.894 98 38 76 3 1933539792 15038256 10016752
22:24:25 63137 8192000000 10871014016 11341156352 1908405248 18.894 98 33 66 1 1930884208 13424736 9054224
22:25:44 25735 8192000000 10880054880 11336802304 1926754976 19.041 99 23 46 2 1941646224 8852032 6039216
22:26:19 67461 8192000000 9273550880 9547653120 408967072 4.754 22 8 16 0 414814256 3714416 2132768

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 11-02-2021 22:28:15 to 11-02-2021 22:28:48.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 82 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 11-02-2021 22:28:49 to 11-02-2021 22:28:50.

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          243171
MON$OLDEST_ACTIVE               243172
MON$OLDEST_SNAPSHOT             243172
MON$NEXT_TRANSACTION            243172
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                       2025696
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:228: 
:229: mscs-test-161.budzdorov.ru    Thu Feb 11 22:27:30 2021
:230:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:231: 
--- end of diff output ---

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

11.02.21 22:28:51. 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
2021-02-11 22:28:54 No severe PSQL-related problems occured
11.02.21 22:28:55. End of report.