Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 13.01.2021 16:28
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 17226136 kB
MemAvailable 31375968 kB
Buffers 0 kB
Cached 14488204 kB
SwapCached 4864 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-01-13 16:27:10
DTS_END                         2021-01-13 16:27:10.2820
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/38488
TRN_ID                          240044
ATT_ID                          622
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: 9585.39 17513 1150247
customer order: creation 172.24 358 20669
customer order: refuse 14.87 349 1784
order to supplier: creation 46.75 1190 5610
order to supplier: removal 3.43 113673 412
invoice (draft): creation 45.93 3579 5511
invoice (draft): removal 55.97 826 6716
invoice accept: apply 42.00 17944 5040
invoice accept: cancel 50.49 809 6059
customer reserve: creation 3891.44 176 466973
customer reserve: removal 4961.58 61 595390
realization accept: apply 83.36 170 10003
realization accept: cancel 87.62 107 10514
payment from customer: creation 59.98 105 7197
payment from customer: removal 5.88 67 706
payment to supplier: creation 48.39 122 5807
payment to supplier: removal 3.29 77 395
service: total inventory turnovers 5.03 1149 603
service: total monetary turnovers 6.24 55 749
service: aggregate perf. data 0.88 18280 105
service: refresh index statistics 0.03 191155 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-01-2021 16:29:09 to 13-01-2021 16:29:11.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3481
TEST_TIME 2 4194
TEST_TIME 3 5307
TEST_TIME 4 4944
TEST_TIME 5 5833
TEST_TIME 6 5690
TEST_TIME 7 5374
TEST_TIME 8 5528
TEST_TIME 9 5522
TEST_TIME 10 5673
TEST_TIME 11 5911
TEST_TIME 12 6140
TEST_TIME 13 6195
TEST_TIME 14 6258
TEST_TIME 15 6297
TEST_TIME 16 6736
TEST_TIME 17 6640
TEST_TIME 18 6675
TEST_TIME 19 7101
TEST_TIME 20 7714
TEST_TIME 21 7933
TEST_TIME 22 8864
TEST_TIME 23 8914
TEST_TIME 24 9480
TEST_TIME 25 9947
TEST_TIME 26 11325
TEST_TIME 27 11423
TEST_TIME 28 11221
TEST_TIME 29 11056
TEST_TIME 30 10978
TEST_TIME 31 10929
TEST_TIME 32 10715
TEST_TIME 33 10596
TEST_TIME 34 10451
TEST_TIME 35 10397
TEST_TIME 36 10390
TEST_TIME 37 10334
TEST_TIME 38 10251
TEST_TIME 39 10117
TEST_TIME 40 10246
TEST_TIME 41 10313
TEST_TIME 42 10224
TEST_TIME 43 10103
TEST_TIME 44 10129
TEST_TIME 45 9992
TEST_TIME 46 9997
TEST_TIME 47 9947
TEST_TIME 48 9902
TEST_TIME 49 9793
TEST_TIME 50 9822
TEST_TIME 51 9677
TEST_TIME 52 9712
TEST_TIME 53 9615
TEST_TIME 54 9518
TEST_TIME 55 9503
TEST_TIME 56 9430
TEST_TIME 57 9429
TEST_TIME 58 9341
TEST_TIME 59 9568
TEST_TIME 60 9517
TEST_TIME 61 9611
TEST_TIME 62 9626
TEST_TIME 63 9659
TEST_TIME 64 9741
TEST_TIME 65 9859
TEST_TIME 66 9904
TEST_TIME 67 9890
TEST_TIME 68 9888
TEST_TIME 69 9975
TEST_TIME 70 9944
TEST_TIME 71 9853
TEST_TIME 72 9826
TEST_TIME 73 9807
TEST_TIME 74 9734
TEST_TIME 75 9710
TEST_TIME 76 9717
TEST_TIME 77 9700
TEST_TIME 78 9630
TEST_TIME 79 9635
TEST_TIME 80 9579
TEST_TIME 81 9598
TEST_TIME 82 9553
TEST_TIME 83 9592
TEST_TIME 84 9576
TEST_TIME 85 9593
TEST_TIME 86 9687
TEST_TIME 87 9636
TEST_TIME 88 9628
TEST_TIME 89 9720
TEST_TIME 90 9714
TEST_TIME 91 9704
TEST_TIME 92 9786
TEST_TIME 93 9745
TEST_TIME 94 9817
TEST_TIME 95 9777
TEST_TIME 96 9705
TEST_TIME 97 9702
TEST_TIME 98 9662
TEST_TIME 99 9655
TEST_TIME 100 9611
TEST_TIME 101 9578
TEST_TIME 102 9549
TEST_TIME 103 9472
TEST_TIME 104 9443
TEST_TIME 105 9444
TEST_TIME 106 9496
TEST_TIME 107 9477
TEST_TIME 108 9532
TEST_TIME 109 9525
TEST_TIME 110 9568
TEST_TIME 111 9563
TEST_TIME 112 9519
TEST_TIME 113 9535
TEST_TIME 114 9652
TEST_TIME 115 9643
TEST_TIME 116 9685
TEST_TIME 117 9697
TEST_TIME 118 9732
TEST_TIME 119 9663
TEST_TIME 120 9585

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-01-2021 16:29:13 to 13-01-2021 16:29:16.

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 1582355 1582355 0 0.00 0 24331 6 0 0
doc_list_biud 1582354 1582354 0 0.00 0 69721 29 0 0
sp_add_invoice_to_stock 5127 5040 87 1.69 36 153652 17945 0 87
sp_cancel_adding_invoice 6059 6059 0 0.00 5 82818 810 0 0
sp_cancel_client_order 1784 1784 0 0.00 4 9043 350 0 0
sp_cancel_customer_reserve 595390 595390 0 0.00 1 69725 61 0 0
sp_cancel_pay_from_customer 706 706 0 0.00 2 2071 68 0 0
sp_cancel_pay_to_supplier 395 395 0 0.00 3 3591 77 0 0
sp_cancel_supplier_invoice 6727 6716 11 0.16 1 24415 826 0 11
sp_cancel_supplier_order 412 412 0 0.00 8 1238726 113673 0 0
sp_cancel_write_off 10514 10514 0 0.00 1 12156 107 0 0
sp_client_order 20669 20669 0 0.00 3 20345 359 0 0
sp_customer_reserve 466973 466973 0 0.00 0 41130 177 0 0
sp_fill_shopping_cart 31779 31779 0 0.00 1 11750 36 0 0
sp_fill_shopping_cart_clo_res 466971 466971 0 0.00 0 14751 13 0 0
sp_get_clo_for_invoice 5038 5038 0 0.00 0 18513 290 0 0
sp_kill_cost_storno 17674 17674 0 0.00 0 6372 53 0 0
sp_kill_qstorno_ret_qs2qd 1208422 1208422 0 0.00 0 69710 33 0 0
sp_kill_qty_storno 635915 635915 0 0.00 0 69720 72 0 0
sp_lock_selected_doc 20879 20879 0 0.00 0 8439 5 0 0
sp_make_cost_storno 28045 28045 0 0.00 0 24027 47 0 0
sp_multiply_rows_for_pdistr 28044 28044 0 0.00 0 7779 30 0 0
sp_multiply_rows_for_qdistr 20669 20669 0 0.00 0 12688 156 0 0
sp_pay_from_customer 7197 7197 0 0.00 4 10126 106 0 0
sp_pay_to_supplier 5807 5807 0 0.00 5 16149 123 0 0
sp_payment_common 13004 13004 0 0.00 1 9836 28 0 0
sp_qd_handle_on_cancel_clo 1784 1784 0 0.00 0 8992 326 0 0
sp_qd_handle_on_invoice_upd_sts 11096 11096 0 0.00 0 34541 357 0 0
sp_qd_handle_on_reserve_upd_sts 10003 10003 0 0.00 0 23638 62 0 0
sp_reserve_write_off 10003 10003 0 0.00 5 23663 170 0 0
sp_supplier_invoice 5511 5511 0 0.00 6 101868 3579 0 0
sp_supplier_order 5610 5610 0 0.00 6 52508 1190 0 0
srv_aggregate_perf_data 105 105 0 0.00 2168 160811 18280 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1430 129948 31043 0 0
srv_find_qd_qs_mism 1102087 1102087 0 0.00 0 24329 5 0 0
srv_make_invnt_saldo 603 603 0 0.00 44 55583 1149 0 0
srv_make_money_saldo 749 749 0 0.00 0 9936 55 0 0
srv_recalc_idx_stat 4 4 0 0.00 91798 250807 191156 0 0
t$perf-abend:sp_add_invoice_to_stock 87 87 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5040 5040 0 0.00 0 8582 167 0 0
t$perf-norm:sp_cancel_adding_invoice 403 403 0 0.00 0 3828 80 0 0
t$perf-norm:sp_cancel_client_order 1784 1784 0 0.00 0 20794 28 0 0
t$perf-norm:sp_cancel_customer_reserve 660 660 0 0.00 0 11913 48 0 0
t$perf-norm:sp_cancel_pay_from_customer 706 706 0 0.00 0 3177 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 395 395 0 0.00 0 2920 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 392 392 0 0.00 0 795 12 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 22675 1651 0 0
t$perf-norm:sp_cancel_write_off 1088 1088 0 0.00 0 831 4 0 0
t$perf-norm:sp_client_order 20669 20669 0 0.00 0 14766 20 0 0
t$perf-norm:sp_customer_reserve 1070 1070 0 0.00 0 4450 9 0 0
t$perf-norm:sp_pay_from_customer 7197 7197 0 0.00 0 6477 10 0 0
t$perf-norm:sp_pay_to_supplier 5807 5807 0 0.00 0 7956 11 0 0
t$perf-norm:sp_reserve_write_off 10003 10003 0 0.00 0 22408 11 0 0
t$perf-norm:sp_supplier_invoice 5511 5511 0 0.00 0 6800 20 0 0
t$perf-norm:sp_supplier_order 5610 5610 0 0.00 0 6958 20 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 358 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 483 5 0 0
t$perf-norm:srv_make_invnt_saldo 603 603 0 0.00 0 1461 27 0 0
t$perf-norm:srv_make_money_saldo 749 749 0 0.00 0 1192 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 10 4 0 0
v_add_invoice_to_stock 10248 10074 174 1.69 0 9675 18 0 174
v_all_customers 37748 37748 0 0.00 0 64 1 0 0
v_all_suppliers 31098 31098 0 0.00 0 65 1 0 0
v_all_wares 41338 41338 0 0.00 0 42 1 0 0
v_cancel_adding_invoice 806 806 0 0.00 0 1036 7 0 0
v_cancel_client_order 3568 3568 0 0.00 0 2798 4 0 0
v_cancel_customer_prepayment 1412 1412 0 0.00 0 2049 7 0 0
v_cancel_customer_reserve 1320 1320 0 0.00 0 6349 11 0 0
v_cancel_payment_to_supplier 790 790 0 0.00 0 3180 12 0 0
v_cancel_supplier_invoice 806 784 22 2.72 0 1429 13 0 22
v_cancel_supplier_order 824 824 0 0.00 0 616 5 0 0
v_cancel_write_off 2176 2176 0 0.00 0 8977 20 0 0
v_max_id_clo_ord 5610 5610 0 0.00 0 11618 3 0 0
v_max_id_clo_res 1070 1070 0 0.00 0 3551 21 0 0
v_max_id_ord_sup 5500 5500 0 0.00 0 5127 4 0 0
v_max_non_paid_invoice 1368 1368 0 0.00 0 3025 7 0 0
v_max_non_paid_realizn 3752 3752 0 0.00 0 3541 4 0 0
v_min_id_clo_ord 5610 5610 0 0.00 0 3607 9 0 0
v_min_id_clo_res 1070 1070 0 0.00 0 7125 32 0 0
v_min_id_ord_sup 5500 5500 0 0.00 0 6917 6 0 0
v_min_non_paid_invoice 5807 5807 0 0.00 0 8293 24 0 0
v_min_non_paid_realizn 7197 7197 0 0.00 0 9833 15 0 0
v_our_firm 10480 10480 0 0.00 0 21 1 0 0
v_reserve_write_off 20004 20004 0 0.00 0 5752 5 0 0
x_lock_depdocs_on_canc_invoice 12383 12383 0 0.00 0 17797 121 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 27465 467 0 0
x_make_qstorno_1000_1200 5610 5610 0 0.00 2 52498 1105 0 0
x_make_qstorno_1200_2000 5511 5511 0 0.00 3 101856 3452 0 0
x_make_qstorno_2100_3300 466973 466973 0 0.00 0 31917 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-01-2021 16:29:17 to 13-01-2021 16:29:21.

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
13:57:14 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:20 27890 8192000000 10270887568 10586083328 1021073328 11.082 78 59 120 0 1043246144 2780624 19392192
13:58:01 29511 8192000000 10377811280 10700562432 1415460912 14.732 100 82 164 0 1446253392 4785680 26006800
13:58:42 14378 8192000000 10404140624 10734927872 1454224032 15.075 100 85 170 0 1488407248 6610992 27572224
13:59:14 17213 8192000000 10438299856 10767912960 1484878272 15.344 100 88 176 0 1521319920 7674672 28766976
13:59:41 27082 8192000000 10463258416 10796408832 1509342672 15.558 100 92 184 0 1547614032 8756416 29514944
14:00:19 24964 8192000000 10477936032 10818404352 1530927200 15.745 100 85 170 1 1567150272 9367712 26855360
14:00:53 12000 8192000000 10481791920 10824638464 1543385648 15.853 100 82 164 0 1577956144 9564976 25005520
14:01:16 18880 8192000000 10517052816 10864443392 1564820288 16.038 100 82 164 1 1600061792 10200736 25040768
14:01:43 14965 8192000000 10527941088 10880516096 1593205024 16.281 100 80 159 1 1627572464 10467568 23899872
14:02:06 15250 8192000000 10565886064 10919288832 1613611936 16.456 100 81 162 0 1648453408 10856208 23985264
14:02:32 16912 8192000000 10579891888 10939236352 1635186400 16.639 100 84 168 3 1672214304 11842944 25184960
14:03:02 12679 8192000000 10583724560 10943766528 1647311408 16.742 100 80 160 1 1683364752 12332208 23721136
14:03:22 13586 8192000000 10601915712 10968133632 1661922432 16.865 100 81 160 0 1698058048 13185056 22950560
14:03:45 9410 8192000000 10633358640 11001671680 1692290096 17.121 100 88 177 1 1731070464 13079120 25701248
14:04:03 10551 8192000000 10647750080 11019976704 1712033392 17.286 100 81 162 0 1748072768 12878304 23161072
14:04:21 8902 8192000000 10668478688 11040370688 1727009504 17.411 100 88 176 0 1765645408 13326064 25309840
14:04:38 8074 8192000000 10670324640 11053211648 1739290992 17.513 100 77 154 5 1775291120 13946608 22053520
14:04:56 5308 8192000000 10686632640 11064397824 1750058400 17.602 100 85 170 0 1787617664 13341728 24217536
14:05:09 6003 8192000000 10700880240 11076026368 1759975872 17.684 100 88 176 0 1799419024 14450336 24992816
14:05:22 5084 8192000000 10704552672 11080470528 1763538256 17.714 100 85 170 1 1801933680 14267312 24128112
14:05:33 4689 8192000000 10706380288 11088433152 1773221280 17.794 100 78 155 0 1807732912 12554944 21956688
14:05:45 3570 8192000000 10716589936 11099013120 1786031696 17.899 100 84 168 0 1822159136 12962384 23165056
14:05:55 3007 8192000000 10727547184 11106738176 1790246624 17.934 100 81 162 0 1825244944 12639376 22358944
14:06:08 2932 8192000000 10729103552 11114246144 1799725152 18.012 100 89 178 2 1838963696 13573440 25665104
14:06:17 2889 8192000000 10745427072 11126251520 1803739088 18.045 100 89 179 2 1842496112 13730912 25026112
14:06:27 2806 8192000000 10749318048 11130736640 1808108512 18.080 100 87 174 2 1846349712 14053920 24187280
14:06:36 1938 8192000000 10754274496 11135926272 1815955888 18.145 100 91 183 2 1855312928 13728784 25628256
14:06:44 8975 8192000000 10760072512 11143979008 1815037216 18.137 100 76 151 1 1848988800 13080560 20871024
14:07:01 2207 8192000000 10772995968 11158446080 1834645344 18.297 100 90 180 1 1874496592 14145600 25705648
14:07:10 2520 8192000000 10786636144 11175088128 1841967872 18.357 100 90 178 0 1880918672 13699248 25251552
14:07:18 2036 8192000000 10795814960 11181240320 1856563104 18.475 100 89 178 0 1895325056 14005312 24756640
14:07:27 2173 8192000000 10795460720 11184783360 1854384032 18.458 100 96 188 1 1894393872 13154032 26855808
14:07:35 1658 8192000000 10802418368 11189010432 1861044064 18.512 100 93 186 2 1900323584 13779152 25500368
14:07:44 1776 8192000000 10806664464 11195617280 1862867344 18.527 100 94 189 2 1904395728 15030848 26497536
14:07:52 1522 8192000000 10806129824 11193688064 1863124832 18.529 100 93 186 2 1903734944 12331968 28278144
14:08:00 1779 8192000000 10812262080 11199168512 1866822752 18.559 100 92 185 1 1905861024 12895744 26142528
14:08:08 3118 8192000000 10811996448 11204427776 1873749808 18.615 100 95 189 1 1914041008 13258544 27032656
14:08:19 2181 8192000000 10814547760 11208519680 1871284784 18.595 100 90 180 2 1911393296 14820752 25287760
14:08:28 2413 8192000000 10800472976 11203223552 1874376896 18.620 100 73 146 2 1907004032 12780848 19846288
14:08:36 24384 8192000000 10806737344 11210272768 1872193248 18.602 100 66 132 1 1905515728 14941024 18381456
14:09:08 9878 8192000000 10762554960 11194843136 1865874720 18.551 100 19 38 1 1876950704 5741744 5334240
14:09:27 7254 8192000000 10779309152 11204214784 1864998560 18.544 100 21 42 1 1876998400 6546320 5453520
14:09:43 5314 8192000000 10775547248 11203350528 1868241808 18.570 100 22 44 0 1880585760 6036016 6307936
14:09:56 9334 8192000000 10781572128 11206746112 1872131616 18.602 100 18 36 1 1882458528 5633504 4693408
14:10:11 8180 8192000000 10791946336 11211755520 1874863440 18.624 100 32 65 0 1892128928 7962176 9303312
14:10:29 9069 8192000000 10774511856 11208904704 1876949920 18.640 100 19 37 2 1889180816 6646480 5584416
14:10:48 8706 8192000000 10794060736 11218313216 1879019472 18.657 100 20 40 1 1890681824 6399840 5262512
14:11:03 9337 8192000000 10788835504 11223183360 1883515104 18.693 100 21 42 2 1895936944 6289712 6132128
14:11:19 14246 8192000000 10796323968 11226300416 1886027424 18.714 100 18 36 1 1901007216 10063104 4916688
14:11:43 10365 8192000000 10803412480 11235352576 1892350288 18.765 100 22 44 1 1909155648 9436672 7368688
14:12:01 10609 8192000000 10800070896 11233464320 1899110832 18.819 100 35 67 0 1914169296 5776112 9282352
14:12:23 63187 8192000000 10835610384 11250528256 1900215168 18.828 100 36 72 3 1917729104 5373888 12140048
14:13:33 6131 8192000000 10827156656 11255934976 1904510896 18.863 100 34 66 1 1922372256 9236128 8625232
14:13:46 8523 8192000000 10813977520 11251621888 1901869376 18.841 100 21 42 2 1914025008 5851776 6303856
14:14:02 4926 8192000000 10822795808 11254636544 1908394320 18.894 100 36 73 2 1925623760 7262240 9967200
14:14:16 4586 8192000000 10820755648 11252568064 1907554176 18.887 100 23 46 1 1920144240 5702464 6887600
14:14:29 4614 8192000000 10827976048 11257249792 1907451648 18.886 100 27 54 2 1921510800 6420464 7638688
14:14:40 3236 8192000000 10828817088 11258109952 1907682496 18.888 100 27 54 1 1921121632 6284752 7154384
14:14:51 8121 8192000000 10816778576 11253194752 1907056288 18.883 100 23 46 3 1919166016 5464048 6645680
14:15:07 6426 8192000000 10833264064 11262369792 1909652304 18.904 100 28 56 2 1924369392 6317056 8400032
14:15:19 9433 8192000000 10833838416 11264720896 1912862144 18.930 100 23 46 1 1925968960 6214016 6892800
14:15:37 8448 8192000000 10828249472 11262652416 1908153424 18.892 100 17 35 1 1923427200 10864272 4409504
14:15:54 12480 8192000000 10815156864 11246026752 1852070560 18.439 97 14 28 1 1861125184 5086720 3967904
14:16:13 8274 8192000000 10804518064 11237154816 1874905152 18.624 99 22 44 2 1887339808 5995536 6439120
14:16:32 8632 8192000000 10813863184 11240091648 1876747136 18.639 99 14 28 1 1885023600 4710208 3566256
14:16:50 57781 8192000000 10783812048 11214123008 1832889232 18.283 97 32 65 1 1847255296 4958272 9407792
14:17:54 11051 8192000000 10773106288 11200782336 1816684960 18.151 97 28 56 3 1830442608 5925392 7832256
14:18:11 13654 8192000000 10783705936 11207172096 1798755120 18.004 96 22 44 1 1810516128 5790304 5970704
14:18:34 6079 8192000000 10759850864 11177259008 1822445344 18.198 98 39 76 2 1840288272 7088096 10754832
14:18:46 5242 8192000000 10752598816 11175682048 1804437232 18.050 98 21 41 4 1815864640 5038448 6388960
14:19:00 4408 8192000000 10734395616 11159240704 1821935040 18.193 99 26 52 2 1834901184 4705552 8260592
14:19:12 6198 8192000000 10717757456 11130191872 1751787584 17.616 95 33 68 2 1768692848 7115872 9789392
14:19:26 8381 8192000000 10723244512 11143409664 1786157840 17.900 98 29 56 2 1799216704 5777472 7281392
14:19:41 6314 8192000000 10742152864 11160698880 1805995536 18.063 99 16 32 1 1816124464 5477072 4651856
14:19:54 8896 8192000000 10713604768 11128307712 1713933360 17.302 94 13 26 0 1722390576 4788624 3668592
14:20:10 5536 8192000000 10710978656 11121455104 1776710912 17.822 99 15 30 2 1786362272 5128864 4522496
14:20:27 8443 8192000000 10703978640 11116785664 1767281856 17.745 98 24 48 1 1780057632 5579984 7195792
14:20:46 9363 8192000000 10724174656 11135033344 1756609824 17.656 97 28 57 1 1770593728 5590048 8393856
14:21:02 10708 8192000000 10708112896 11129520128 1770245280 17.769 98 20 40 0 1781307792 5313664 5748848
14:21:19 8172 8192000000 10704989536 11122831360 1764798160 17.724 98 30 60 0 1779289392 5514336 8976896
14:21:37 35994 8192000000 10693409712 11114876928 1768309504 17.753 98 34 68 1 1784701376 6556224 9835648
14:22:26 32846 8192000000 10732487568 11158786048 1808156896 18.081 99 29 58 1 1822094480 4958128 8979456
14:23:05 9629 8192000000 10748902160 11174989824 1834310944 18.294 100 21 42 1 1846883856 5799824 6773088
14:23:22 5254 8192000000 10743711056 11173597184 1821663072 18.191 99 34 68 2 1839300848 7634800 10002976
14:23:34 7412 8192000000 10757432192 11182063616 1840429456 18.344 100 31 62 2 1856296528 7115984 8751088
14:23:47 4659 8192000000 10776775456 11192471552 1850264576 18.424 100 49 98 3 1872091232 7790464 14036192
14:24:01 6455 8192000000 10775174448 11191840768 1849489360 18.418 100 31 62 2 1863934304 5679088 8765856
14:24:14 11535 8192000000 10764374208 11196903424 1854595216 18.459 100 19 36 2 1864717424 5083504 5038704
14:24:32 10892 8192000000 10770406016 11201859584 1859449712 18.499 100 20 40 1 1870369440 5254816 5664912
14:24:55 9929 8192000000 10776088944 11208450048 1866561056 18.556 100 20 39 2 1881955488 10185216 5209216
14:25:11 9162 8192000000 10796604960 11219738624 1872061200 18.601 100 28 57 0 1889480144 9567952 7850992
14:25:28 7147 8192000000 10793170032 11218878464 1871003472 18.592 100 19 38 0 1882297392 6118576 5175344
14:25:41 12742 8192000000 10774509360 11213180928 1869854784 18.583 100 13 26 2 1879073824 5718624 3500416
14:26:02 13423 8192000000 10781409616 11215437824 1872544160 18.605 100 25 49 1 1885844240 5700080 7600000
14:26:23 40387 8192000000 10779886032 11217707008 1874320768 18.619 100 25 48 3 1887642880 5216048 8106064
14:27:40 60749 8192000000 10828675968 11258667008 1906808720 18.881 100 34 67 2 1924055664 6667952 10578992
14:28:49 47409 8192000000 10845971616 11282731008 1921644832 19.000 100 37 74 0 1940069184 7968432 10455920
14:29:44 20191 8192000000 10880767008 11296145408 1934096416 19.100 100 46 91 2 1957423216 11028928 12297872
14:30:11 5609 8192000000 10871488800 11295207424 1941107312 19.156 100 49 97 2 1966635088 10955680 14572096
14:30:29 7391 8192000000 10883970800 11307814912 1944200912 19.180 100 54 106 1 1972124560 12597328 15326320
14:30:45 1756 8192000000 10901571984 11312873472 1950832512 19.233 100 68 136 0 1982029296 11352112 19844672
14:30:55 14888 8192000000 10886518448 11313197056 1949928688 19.226 100 54 108 2 1978240112 12934240 15377184
14:31:23 21055 8192000000 10906658512 11326455808 1955163552 19.268 100 55 109 1 1988615008 16692128 16759328
14:31:55 28698 8192000000 10888835344 11328630784 1960735280 19.312 100 35 70 0 1984722720 13856912 10130528
14:32:37 11088 8192000000 10901100784 11338428416 1970277728 19.388 100 46 90 1 1997201184 13217008 13706448
14:32:55 14082 8192000000 10909355904 11345260544 1975109984 19.426 100 44 87 0 2004568816 16847504 12611328
14:33:28 10017 8192000000 10930922464 11359838208 1982820720 19.487 100 49 97 2 2018224160 21284288 14119152
14:33:46 3910 8192000000 10943744400 11367612416 1987826560 19.527 100 63 126 2 2029326160 22573152 18926448
14:33:58 7378 8192000000 10936750848 11369226240 1988830848 19.535 100 62 124 5 2030773136 23554128 18388160
14:34:13 27617 8192000000 10941194656 11375411200 1987265408 19.522 100 49 98 0 2025427504 23943904 14218192
14:35:06 28812 8192000000 10934131792 11374891008 1985144720 19.505 100 41 81 0 2026500880 29340608 12015552
14:35:42 8982 8192000000 10944973728 11382951936 1993217552 19.569 100 43 86 0 2035473808 28517648 13738608
14:36:00 6707 8192000000 10943113888 11374780416 1988788976 19.534 100 45 90 1 2030792048 28883792 13119280
14:36:14 3336 8192000000 10943302544 11371999232 1987725744 19.526 100 60 118 1 2034267360 29390528 17151088
14:36:25 3633 8192000000 10944496544 11363962880 1972878032 19.408 99 58 113 1 2019599792 30052560 16669200
14:36:36 4484 8192000000 10951031472 11374104576 1986000128 19.512 100 66 132 0 2037989312 32564192 19424992
14:36:49 5347 8192000000 10955722368 11375562752 1977022384 19.441 99 72 140 1 2029589536 32459616 20107536
14:37:05 8373 8192000000 10941173520 11364925440 1970588976 19.390 99 70 138 2 2024628096 33307376 20731744
14:37:21 4037 8192000000 10956602432 11376365568 1984218160 19.498 100 82 161 1 2042225088 34913120 23093808
14:37:31 2223 8192000000 10947688112 11365502976 1966701744 19.359 99 79 157 1 2024216016 34086992 23427280
14:37:42 10729 8192000000 10944082448 11366313984 1959858656 19.305 99 68 136 0 2014913424 34948192 20106576
14:38:00 3590 8192000000 10949267968 11374485504 1981139872 19.474 100 63 126 0 2037912880 37289728 19483280
14:38:13 10004 8192000000 10945117232 11375742976 1964624224 19.343 99 55 110 1 2017092752 35685088 16783440
14:38:31 5483 8192000000 10956333632 11386273792 1989244544 19.538 100 53 106 0 2046519824 40543904 16731376
14:38:53 4989 8192000000 10974277584 11403366400 1983232928 19.490 99 65 128 2 2043833824 40582336 20018560
14:39:05 2218 8192000000 10983328944 11401965568 2000213632 19.624 100 76 150 1 2064767424 42570112 21983680
14:39:14 4021 8192000000 10981857424 11401781248 2001475520 19.634 100 82 164 1 2069842464 44123232 24243712
14:39:27 1635 8192000000 10962727712 11373367296 1971061200 19.394 98 82 164 0 2038777760 42516000 25200560
14:39:36 1765 8192000000 10983800864 11391467520 1993699408 19.573 100 88 176 1 2063432768 43429504 26303856
14:39:45 3552 8192000000 10987195440 11398160384 1995029344 19.584 100 85 171 2 2064741680 44155216 25557120
14:40:05 2481 8192000000 10995625232 11405418496 2001053728 19.631 100 88 174 1 2071661744 44869392 25738624
14:40:14 2413 8192000000 10990834224 11401904128 2001448896 19.634 100 91 182 3 2073603088 44675504 27478688
14:40:25 5275 8192000000 10985048672 11403759616 2001806096 19.637 100 83 166 0 2073708784 46514144 25388544
14:40:44 2487 8192000000 10981018272 11395006464 1993267648 19.570 100 84 168 1 2066256848 47673136 25316064
14:40:56 6851 8192000000 10980172928 11395301376 1994541776 19.580 100 76 152 0 2066342768 47897040 23903952
14:41:09 3432 8192000000 10981029744 11397447680 1991051296 19.552 100 71 140 4 2060411040 47668096 21691648
14:41:19 4748 8192000000 10984417216 11401113600 1996954752 19.599 100 76 152 1 2069355872 48869488 23531632
14:41:31 2695 8192000000 10989019536 11402469376 1985609136 19.509 99 86 172 2 2062028016 49802784 26616096
14:41:42 5569 8192000000 10972588592 11393183744 1988665008 19.533 100 75 150 3 2062449264 50017904 23766352
14:41:55 3055 8192000000 10971471872 11382452224 1974864144 19.424 99 87 173 4 2051340624 49877216 26599264
14:42:04 4621 8192000000 10981667136 11398983680 1980096208 19.465 99 84 167 1 2058222112 51070464 27055440
14:42:15 4372 8192000000 10987906864 11404402688 1994771024 19.581 100 66 131 0 2067460096 52137456 20551616
14:42:32 4069 8192000000 10999379792 11411386368 1999254176 19.617 100 85 168 0 2078407808 53294256 25859376
14:42:44 2145 8192000000 10996774576 11416670208 2005194464 19.664 100 73 142 0 2080999008 52427504 23377040
14:42:55 6504 8192000000 10983687600 11402780672 1975368688 19.428 99 70 141 0 2052718016 54400640 22948688
14:43:13 7829 8192000000 10978810480 11397648384 1972577456 19.406 99 66 130 0 2049238640 55115024 21546160
14:43:28 6247 8192000000 10973964512 11403522048 1985384928 19.507 100 58 116 1 2061086288 56742416 18958944
14:43:43 4003 8192000000 10979528784 11408560128 1997991088 19.607 100 68 135 0 2071427344 51177216 22259040
14:43:54 3750 8192000000 10991865632 11409940480 1981908304 19.480 99 78 156 1 2060150256 54047632 24194320
14:44:10 4765 8192000000 10977717040 11390992384 1949118416 19.219 98 84 168 2 2031973664 56382128 26473120
14:44:23 2396 8192000000 10986877216 11406270464 1989064608 19.536 100 75 150 1 2071301088 58201648 24034832
14:44:33 3354 8192000000 11000679728 11414679552 1996179792 19.593 100 76 150 2 2080946496 60156416 24610288
14:44:43 5892 8192000000 10995620400 11419181056 1996173264 19.593 100 66 131 1 2078455296 60478688 21803344
14:44:58 4367 8192000000 11001215216 11419463680 1997837664 19.606 100 68 136 2 2081281312 60261632 23182016
14:45:10 1853 8192000000 10986870784 11403988992 1972719472 19.407 99 83 166 2 2062046560 62086528 27240560
14:45:22 1865 8192000000 10996990688 11409358848 1985341536 19.507 100 83 167 3 2075156592 62378352 27436704
14:45:33 1476 8192000000 11003914880 11413114880 1988987712 19.536 100 87 169 1 2081962496 65446432 27528352
14:45:43 3409 8192000000 11007205408 11421425664 1990949728 19.551 100 84 165 2 2083873504 65807600 27116176
14:45:53 3672 8192000000 11018308256 11431698432 2000399808 19.626 100 84 167 2 2095762976 67690912 27672256
14:46:05 2801 8192000000 10997038224 11408031744 1966123280 19.355 99 90 181 0 2065525856 70328896 29073680
14:46:15 2473 8192000000 10999173760 11411668992 1984094608 19.497 100 88 174 1 2079433904 66814576 28524720
14:46:24 1923 8192000000 11001811360 11413807104 1985286864 19.507 100 88 176 1 2080774896 66682672 28805360
14:46:36 3999 8192000000 11008514112 11420676096 1993069680 19.568 100 84 168 1 2085438288 65092432 27276176
14:46:52 3758 8192000000 10998932896 11413225472 1971337248 19.396 99 79 158 1 2064228320 67158560 25732512
14:47:02 3950 8192000000 11009753040 11424174080 1989825856 19.542 100 86 173 2 2087815792 70285792 27704144
14:47:13 3711 8192000000 11017970864 11432828928 1995199008 19.585 100 87 174 0 2097099344 74256160 27644176
14:47:23 3237 8192000000 11012611152 11429416960 1994038032 19.576 100 83 165 1 2092645328 71607648 26999648
14:47:37 1429 8192000000 11017867264 11434934272 1997123360 19.600 100 81 161 2 2094630752 71546416 25960976
14:47:46 1534 8192000000 11000368144 11419930624 1992160240 19.561 100 82 162 2 2081611968 62988864 26462864
14:47:55 3479 8192000000 11002910320 11426955264 1994344352 19.578 100 71 142 3 2082426448 64667648 23414448
14:48:05 5164 8192000000 10995394592 11426525184 1995436768 19.587 100 59 118 1 2080236128 65485600 19313760
14:48:23 12046 8192000000 10980136896 11416354816 1970796832 19.392 99 42 84 1 2051990688 66807040 14386816
14:49:02 10866 8192000000 10963362848 11409076224 1961118432 19.315 99 39 78 0 2044458288 69150192 14189664
14:49:33 22191 8192000000 10939155728 11388850176 1934609456 19.104 98 30 60 0 1997947536 52792512 10545568
14:50:32 9654 8192000000 10957700304 11395264512 1970001776 19.385 100 46 93 2 2035783664 50092848 15689040
14:50:50 12919 8192000000 10949201296 11395416064 1967354176 19.364 100 29 56 1 2030986432 53062656 10569600
14:51:19 19777 8192000000 10932094176 11395620864 1943958512 19.178 99 28 56 1 2013650976 59152624 10539840
14:51:56 23059 8192000000 10924544016 11381837824 1953269808 19.253 100 21 42 0 2010318720 48888944 8159968
14:52:26 31364 8192000000 10905419584 11367464960 1928733808 19.057 99 15 29 2 1979997312 45579536 5683968
14:53:16 5253 8192000000 10892763840 11335647232 1915511920 18.951 99 37 73 2 1969700560 42679488 11509152
14:53:28 43277 8192000000 10860273632 11325231104 1917560832 18.967 99 11 21 1 1948372272 26489392 4322048
14:54:50 44789 8192000000 10868493408 11320152064 1902869280 18.849 98 13 24 1 1915887008 9244784 3772944
14:55:45 62471 8192000000 10874454672 11312295936 1884709248 18.703 97 22 42 1 1898077040 7849696 5518096
14:56:56 37855 8192000000 10885321872 11327778816 1919185744 18.980 99 25 50 3 1935694448 9647072 6861632
14:57:43 36547 8192000000 10879469664 11321868288 1915224896 18.949 98 18 36 1 1929488944 9825200 4438848
14:58:27 89504 8192000000 10913000416 11366395904 1964731248 19.344 100 18 36 2 1982645904 13498560 4416096
15:00:03 94618 8192000000 10929865968 11368202240 1959159488 19.299 99 33 66 0 1984303312 15171584 9972240
15:01:47 50355 8192000000 10912055664 11379531776 1966453104 19.357 99 41 82 3 1994474640 16621104 11400432
15:04:20 22015 8192000000 10915586672 11367059456 1938595488 19.136 98 18 34 0 1963336224 19468176 5272560
15:05:02 44159 8192000000 10900067824 11365781504 1938779584 19.137 98 18 36 1 1959692512 15668288 5244640
15:06:03 45813 8192000000 10901847824 11347423232 1918864000 18.978 97 52 104 0 1953619360 18331888 16423472
15:07:02 18875 8192000000 10949473744 11377950720 1972106928 19.402 100 57 114 1 2009285184 20070960 17107296
15:07:32 39954 8192000000 10902724832 11357802496 1926475312 19.039 98 42 79 0 1958032208 19078048 12478848
15:08:19 51148 8192000000 10890970528 11360239616 1968228880 19.371 100 13 26 1 1984666192 12041296 4396016
15:09:20 58468 8192000000 10885281648 11353735168 1930153856 19.068 98 7 15 0 1943507776 11425152 1928768
15:10:24 72568 8192000000 10903508704 11380662272 1970348320 19.388 100 19 38 0 1989641248 13581520 5711408
15:12:21 56294 8192000000 10898840880 11367247872 1955539728 19.271 99 17 34 0 1973546320 12849184 5157408
15:13:34 19587 8192000000 10897229280 11375005696 1973584432 19.414 100 15 30 1 1989280624 11305120 4391072
15:14:20 66072 8192000000 10898978528 11360694272 1938128400 19.132 98 26 52 2 1956650512 11109888 7412224
15:15:43 56469 8192000000 10886774400 11352694784 1934577792 19.103 98 22 43 1 1948025936 7210896 6237248
15:16:46 36904 8192000000 10895714096 11371540480 1975006016 19.425 100 26 52 0 1990872512 8469840 7396656
15:17:33 62838 8192000000 10904024560 11386593280 1975456448 19.429 100 7 14 0 1990347168 13155392 1735328
15:19:42 65919 8192000000 10890315024 11366412288 1961016512 19.314 99 14 27 0 1980101152 15401504 3683136
15:20:55 66922 8192000000 10901635536 11380846592 1985825472 19.511 100 20 40 0 1998839872 7542288 5472112
15:23:40 57854 8192000000 10937251824 11411525632 1997705680 19.605 100 21 42 1 2012546224 9001424 5839120
15:24:45 97828 8192000000 10909452624 11396911104 1941917728 19.162 97 16 32 0 1963463200 17174432 4371040
15:26:30 49314 8192000000 10899325680 11383148544 1944475728 19.182 98 12 24 1 1962220112 14760528 2983856
15:27:25 9880 8192000000 10921210304 11376005120 1969694192 19.383 99 45 90 1 1990355760 7983808 12677760
15:27:44 30624 8192000000 10913560000 11376336896 1945476608 19.190 98 30 60 2 1965243232 11868064 7898560
15:28:26 64235 8192000000 10902862128 11395334144 1949572000 19.223 98 21 42 1 1970636976 14842704 6222272
15:29:39 101073 8192000000 10903378032 11370618880 1850216880 18.424 93 20 40 2 1869649952 13706016 5727056
15:31:29 55671 8192000000 10892115792 11386966016 1950133408 19.228 99 10 20 1 1970498048 17310144 3054496
15:32:36 79658 8192000000 10883760480 11359092736 1858040704 18.487 95 4 8 0 1870757824 11914560 802560
15:34:01 44341 8192000000 10869776784 11324530688 1823155904 18.203 93 25 48 3 1838755824 9370224 6229696
15:34:52 16171 8192000000 10880732240 11326521344 1920351152 18.990 99 41 81 1 1941705136 10457456 10896528
15:35:15 65567 8192000000 10892757792 11348779008 1913871216 18.938 98 27 54 0 1932847072 11681712 7294144
15:36:31 91458 8192000000 10879809952 11344289792 1866782960 18.558 96 14 28 0 1885196320 14675040 3738320
15:38:13 129947 8192000000 10859648544 11319377920 1889131504 18.739 97 29 58 1 1910691984 12712368 8848112
15:40:30 60951 8192000000 10860840464 11321675776 1904548048 18.863 98 43 86 0 1928308912 10588368 13172496
15:41:37 9989 8192000000 10864976704 11302494208 1899730720 18.824 98 57 115 4 1926741344 10801728 16208896
15:41:54 30261 8192000000 10872625280 11311861760 1892540592 18.766 98 50 100 1 1920177248 13448576 14188080
15:42:33 117687 8192000000 10843975696 11326664704 1904030384 18.859 99 17 34 0 1923184112 13872384 5281344
15:44:37 36304 8192000000 10834181360 11303882752 1873899392 18.616 97 11 21 2 1890222976 12869040 3454544
15:45:47 91723 8192000000 10828263712 11300421632 1864915792 18.543 97 16 32 2 1879756816 9998384 4842640
15:47:25 40955 8192000000 10856220288 11312787456 1922345328 19.006 100 32 62 3 1940682992 8548672 9788992
15:48:23 65855 8192000000 10853413424 11327397888 1914423072 18.942 99 20 39 0 1935399200 15406592 5569536
15:49:34 74442 8192000000 10866326544 11333492736 1894772400 18.784 98 12 24 0 1914751968 16228944 3750624
15:50:58 34957 8192000000 10856332688 11320590336 1904134016 18.860 98 19 38 0 1916970144 7457824 5378304
15:51:43 26189 8192000000 10875927936 11332657152 1909854208 18.905 98 49 98 0 1936691376 12295120 14542048
15:52:16 62160 8192000000 10884915728 11361460224 1955517792 19.270 100 20 40 0 1975720656 14969392 5233472
15:53:36 64272 8192000000 10879364928 11346259968 1899581920 18.823 97 13 26 0 1915414480 12557056 3275504
15:54:46 42644 8192000000 10895859376 11361349632 1964009616 19.338 100 36 72 1 1987274288 13063168 10201504
15:55:35 95886 8192000000 10890469744 11381485568 1919785440 18.985 98 18 36 0 1942451216 17648080 5017696
15:57:17 56344 8192000000 10881987040 11334991872 1903657440 18.856 97 25 50 1 1918011744 7548672 6805632
15:58:20 38812 8192000000 10897115568 11352711168 1910845248 18.913 98 17 34 0 1926262032 10889712 4527072
15:59:05 83193 8192000000 10877507584 11331923968 1862488800 18.523 95 13 26 1 1877696992 12121408 3086784
16:00:34 12020 8192000000 10921048144 11353092096 1966824416 19.360 100 62 122 4 1992608672 8305248 17479008
16:00:54 16436 8192000000 10921496960 11369070592 1973035232 19.410 100 40 80 4 1996062096 11598320 11428544
16:01:17 53021 8192000000 10902394816 11376717824 1955382544 19.269 99 27 54 0 1976237920 13569504 7285872
16:03:06 56760 8192000000 10888978176 11356868608 1970529552 19.390 100 16 32 0 1983932592 9255168 4147872
16:04:09 48397 8192000000 10920145104 11374399488 1960070144 19.307 99 21 41 1 1972543824 6631360 5842320
16:05:07 59944 8192000000 10903041152 11375226880 1960838656 19.313 99 24 48 3 1978602896 11321600 6442640
16:06:21 21096 8192000000 10904984816 11379707904 1984622336 19.501 100 19 39 3 1999200944 8998672 5579936
16:06:49 6731 8192000000 10900407376 11369926656 1976456784 19.437 100 14 20 2 1986120256 7430608 2232864
16:07:07 71423 8192000000 10888611856 11363581952 1924821120 19.025 97 4 8 1 1933013344 7261296 930928
16:09:27 73384 8192000000 10914242192 11390205952 1976165072 19.434 99 18 36 0 1991328768 10063264 5100432
16:10:46 99878 8192000000 10935152256 11405455360 1992733024 19.565 100 20 40 1 2013451536 14845936 5872576
16:13:39 44823 8192000000 10915465488 11386413056 1954509968 19.262 98 10 20 1 1977481888 19690592 3281328
16:14:32 77373 8192000000 10910258240 11400597504 1950750400 19.232 98 9 18 0 1970532688 17115920 2666368
16:15:59 107282 8192000000 10879361248 11353645056 1845441600 18.385 93 10 20 0 1865332096 17302656 2587840
16:18:01 35777 8192000000 10853803312 11317641216 1831791776 18.274 93 16 30 1 1846975552 10352336 4831440
16:18:43 48621 8192000000 10860558416 11322494976 1892491648 18.766 98 17 34 1 1910431888 12885360 5054880
16:19:57 51436 8192000000 10862647424 11328983040 1901775168 18.841 98 20 40 0 1923078832 14641648 6662016
16:20:54 60998 8192000000 10844765040 11321614336 1847190048 18.399 96 6 12 0 1861790192 12845328 1754816
16:22:12 25467 8192000000 10896846320 11337916416 1917992416 18.971 99 26 50 2 1933589088 8316416 7280256
16:22:49 48706 8192000000 10870389920 11335856128 1880916448 18.673 97 38 76 1 1908621616 17127616 10577552
16:23:49 76252 8192000000 10880540928 11350200320 1906293440 18.877 98 17 34 1 1930253488 19594688 4365360
16:25:21 88390 8192000000 10856286560 11326840832 1900719376 18.832 98 14 28 0 1916538720 11795600 4023744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 13-01-2021 16:29:23 to 13-01-2021 16:29:54.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 87 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-01-2021 16:29:55 to 13-01-2021 16:29:57.

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          240313
MON$OLDEST_ACTIVE               240314
MON$OLDEST_SNAPSHOT             240314
MON$NEXT_TRANSACTION            240314
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                       2032544
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:862: 
:863: mscs-test-161.budzdorov.ru    Wed Jan 13 16:27:55 2021
:864:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:865: 
--- end of diff output ---

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

13.01.21 16:29:58. 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-01-13 16:30:00 No severe PSQL-related problems occured
13.01.21 16:30:02. End of report.