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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 58e1ddde69c44dad93d327777e5becec
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 2021-05-09 08:45
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 4793.92
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 16894348 kB
MemAvailable 31345376 kB
Buffers 0 kB
Cached 14735188 kB
SwapCached 2432 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-06-21 01:27:40
DTS_END                         2021-06-21 01:27:40.1140
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60196
TRN_ID                          258166
ATT_ID                          745
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: 9357.76 22403 1122931
customer order: creation 185.46 323 22255
customer order: refuse 15.69 366 1883
order to supplier: creation 47.94 1370 5753
order to supplier: removal 3.51 87559 421
invoice (draft): creation 49.98 3596 5997
invoice (draft): removal 53.01 788 6361
invoice accept: apply 44.75 18117 5370
invoice accept: cancel 46.67 906 5600
customer reserve: creation 4009.51 185 481141
customer reserve: removal 4586.00 52 550320
realization accept: apply 88.21 167 10585
realization accept: cancel 87.58 100 10509
payment from customer: creation 63.13 110 7575
payment from customer: removal 6.36 64 763
payment to supplier: creation 52.86 124 6343
payment to supplier: removal 3.88 97 465
service: total inventory turnovers 5.03 1003 603
service: total monetary turnovers 7.23 26 867
service: aggregate perf. data 0.97 17630 116
service: refresh index statistics 0.03 315478 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 21-06-2021 01:28:21 to 21-06-2021 01:28:24.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2515
TEST_TIME 2 3048
TEST_TIME 3 4362
TEST_TIME 4 4914
TEST_TIME 5 4887
TEST_TIME 6 4958
TEST_TIME 7 5307
TEST_TIME 8 5472
TEST_TIME 9 5827
TEST_TIME 10 6380
TEST_TIME 11 6526
TEST_TIME 12 6868
TEST_TIME 13 7308
TEST_TIME 14 7440
TEST_TIME 15 7433
TEST_TIME 16 7674
TEST_TIME 17 7774
TEST_TIME 18 7751
TEST_TIME 19 7669
TEST_TIME 20 8101
TEST_TIME 21 8831
TEST_TIME 22 8864
TEST_TIME 23 8961
TEST_TIME 24 9143
TEST_TIME 25 9829
TEST_TIME 26 9822
TEST_TIME 27 10046
TEST_TIME 28 10044
TEST_TIME 29 10287
TEST_TIME 30 10103
TEST_TIME 31 10207
TEST_TIME 32 10575
TEST_TIME 33 10429
TEST_TIME 34 10296
TEST_TIME 35 10245
TEST_TIME 36 10365
TEST_TIME 37 10246
TEST_TIME 38 10210
TEST_TIME 39 10131
TEST_TIME 40 10197
TEST_TIME 41 10220
TEST_TIME 42 10214
TEST_TIME 43 10101
TEST_TIME 44 9902
TEST_TIME 45 9899
TEST_TIME 46 9917
TEST_TIME 47 9898
TEST_TIME 48 9796
TEST_TIME 49 9816
TEST_TIME 50 9726
TEST_TIME 51 9720
TEST_TIME 52 9857
TEST_TIME 53 9764
TEST_TIME 54 9691
TEST_TIME 55 9681
TEST_TIME 56 9618
TEST_TIME 57 9595
TEST_TIME 58 9615
TEST_TIME 59 9584
TEST_TIME 60 9552
TEST_TIME 61 9426
TEST_TIME 62 9397
TEST_TIME 63 9343
TEST_TIME 64 9441
TEST_TIME 65 9454
TEST_TIME 66 9490
TEST_TIME 67 9541
TEST_TIME 68 9552
TEST_TIME 69 9609
TEST_TIME 70 9595
TEST_TIME 71 9577
TEST_TIME 72 9632
TEST_TIME 73 9647
TEST_TIME 74 9668
TEST_TIME 75 9685
TEST_TIME 76 9735
TEST_TIME 77 9734
TEST_TIME 78 9619
TEST_TIME 79 9593
TEST_TIME 80 9566
TEST_TIME 81 9514
TEST_TIME 82 9519
TEST_TIME 83 9453
TEST_TIME 84 9470
TEST_TIME 85 9461
TEST_TIME 86 9389
TEST_TIME 87 9387
TEST_TIME 88 9399
TEST_TIME 89 9364
TEST_TIME 90 9393
TEST_TIME 91 9396
TEST_TIME 92 9409
TEST_TIME 93 9510
TEST_TIME 94 9486
TEST_TIME 95 9445
TEST_TIME 96 9569
TEST_TIME 97 9604
TEST_TIME 98 9569
TEST_TIME 99 9660
TEST_TIME 100 9615
TEST_TIME 101 9574
TEST_TIME 102 9506
TEST_TIME 103 9510
TEST_TIME 104 9470
TEST_TIME 105 9466
TEST_TIME 106 9451
TEST_TIME 107 9431
TEST_TIME 108 9416
TEST_TIME 109 9357
TEST_TIME 110 9314
TEST_TIME 111 9321
TEST_TIME 112 9324
TEST_TIME 113 9358
TEST_TIME 114 9341
TEST_TIME 115 9338
TEST_TIME 116 9389
TEST_TIME 117 9358
TEST_TIME 118 9396
TEST_TIME 119 9392
TEST_TIME 120 9361

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 21-06-2021 01:28:25 to 21-06-2021 01:28:29.

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 1570167 1570167 0 0.00 0 23630 6 0 0
doc_list_biud 1570162 1570162 0 0.00 0 55262 24 0 0
sp_add_invoice_to_stock 5510 5370 140 2.54 41 195946 18118 0 140
sp_cancel_adding_invoice 5600 5600 0 0.00 4 76791 907 0 0
sp_cancel_client_order 1883 1883 0 0.00 4 17223 366 0 0
sp_cancel_customer_reserve 550320 550320 0 0.00 1 55264 52 0 0
sp_cancel_pay_from_customer 763 763 0 0.00 3 2638 64 0 0
sp_cancel_pay_to_supplier 465 465 0 0.00 3 8892 97 0 0
sp_cancel_supplier_invoice 6369 6361 8 0.12 1 19190 788 0 8
sp_cancel_supplier_order 421 421 0 0.00 12 1057443 87559 0 0
sp_cancel_write_off 10509 10509 0 0.00 1 21226 101 0 0
sp_client_order 22255 22255 0 0.00 3 47661 324 0 0
sp_customer_reserve 481141 481141 0 0.00 0 126915 186 0 0
sp_fill_shopping_cart 33990 33990 0 0.00 1 20633 39 0 0
sp_fill_shopping_cart_clo_res 481139 481139 0 0.00 0 17391 11 0 0
sp_get_clo_for_invoice 5364 5364 0 0.00 0 22461 237 0 0
sp_kill_cost_storno 17337 17337 0 0.00 0 8166 48 0 0
sp_kill_qstorno_ret_qs2qd 1117931 1117931 0 0.00 0 55256 29 0 0
sp_kill_qty_storno 591043 591043 0 0.00 0 55262 64 0 0
sp_lock_selected_doc 22207 22207 0 0.00 0 8052 5 0 0
sp_make_cost_storno 29867 29867 0 0.00 0 16791 51 0 0
sp_multiply_rows_for_pdistr 29867 29867 0 0.00 0 9259 29 0 0
sp_multiply_rows_for_qdistr 22255 22255 0 0.00 0 47649 140 0 0
sp_pay_from_customer 7575 7575 0 0.00 4 12540 110 0 0
sp_pay_to_supplier 6343 6343 0 0.00 5 13006 124 0 0
sp_payment_common 13917 13917 0 0.00 1 5128 22 0 0
sp_qd_handle_on_cancel_clo 1883 1883 0 0.00 0 17174 336 0 0
sp_qd_handle_on_invoice_upd_sts 10964 10964 0 0.00 0 25377 345 0 0
sp_qd_handle_on_reserve_upd_sts 10585 10585 0 0.00 0 18623 53 0 0
sp_reserve_write_off 10585 10585 0 0.00 6 18644 167 0 0
sp_supplier_invoice 5997 5997 0 0.00 6 81306 3597 0 0
sp_supplier_order 5753 5753 0 0.00 5 48570 1371 0 0
srv_aggregate_perf_data 117 116 1 0.85 2268 249483 17630 0 1
srv_fill_mon_cache_memory 176 176 0 0.00 882 132178 29872 0 0
srv_find_qd_qs_mism 1073038 1073038 0 0.00 0 23628 6 0 0
srv_make_invnt_saldo 603 603 0 0.00 39 44920 1004 0 0
srv_make_money_saldo 867 867 0 0.00 1 2299 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 148953 430105 315479 0 0
t$perf-abend:sp_add_invoice_to_stock 140 140 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5370 5370 0 0.00 0 8140 183 0 0
t$perf-norm:sp_cancel_adding_invoice 450 450 0 0.00 0 4924 116 0 0
t$perf-norm:sp_cancel_client_order 1883 1883 0 0.00 0 6504 29 0 0
t$perf-norm:sp_cancel_customer_reserve 754 754 0 0.00 0 940 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 763 763 0 0.00 0 711 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 465 465 0 0.00 0 4606 34 0 0
t$perf-norm:sp_cancel_supplier_invoice 436 436 0 0.00 0 3510 28 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 37028 1650 0 0
t$perf-norm:sp_cancel_write_off 1086 1086 0 0.00 0 3473 10 0 0
t$perf-norm:sp_client_order 22255 22255 0 0.00 0 9450 19 0 0
t$perf-norm:sp_customer_reserve 1113 1113 0 0.00 0 9574 25 0 0
t$perf-norm:sp_pay_from_customer 7575 7575 0 0.00 0 7272 13 0 0
t$perf-norm:sp_pay_to_supplier 6343 6343 0 0.00 0 3938 8 0 0
t$perf-norm:sp_reserve_write_off 10585 10585 0 0.00 0 7020 11 0 0
t$perf-norm:sp_supplier_invoice 5997 5997 0 0.00 0 7035 23 0 0
t$perf-norm:sp_supplier_order 5753 5753 0 0.00 0 6716 16 0 0
t$perf-norm:srv_aggregate_perf_data 116 116 0 0.00 0 357 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 176 176 0 0.00 0 1003 12 0 0
t$perf-norm:srv_make_invnt_saldo 603 603 0 0.00 0 4394 33 0 0
t$perf-norm:srv_make_money_saldo 867 867 0 0.00 0 797 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 11000 10720 280 2.54 0 4925 18 0 280
v_all_customers 40220 40220 0 0.00 0 120 1 0 0
v_all_suppliers 32338 32338 0 0.00 0 45 1 0 0
v_all_wares 44498 44498 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 900 900 0 0.00 0 1119 8 0 0
v_cancel_client_order 3766 3766 0 0.00 0 3742 5 0 0
v_cancel_customer_prepayment 1526 1526 0 0.00 0 2626 5 0 0
v_cancel_customer_reserve 1508 1508 0 0.00 0 3007 6 0 0
v_cancel_payment_to_supplier 930 930 0 0.00 0 4116 12 0 0
v_cancel_supplier_invoice 888 872 16 1.80 0 2581 23 0 16
v_cancel_supplier_order 842 842 0 0.00 0 2570 7 0 0
v_cancel_write_off 2172 2172 0 0.00 0 2629 14 0 0
v_max_id_clo_ord 5745 5745 0 0.00 0 154 1 0 0
v_max_id_clo_res 1113 1113 0 0.00 0 2730 10 0 0
v_max_id_ord_sup 5993 5993 0 0.00 0 1645 2 0 0
v_max_non_paid_invoice 1911 1911 0 0.00 0 2409 4 0 0
v_max_non_paid_realizn 4143 4143 0 0.00 0 1062 3 0 0
v_min_id_clo_ord 5745 5745 0 0.00 0 4442 8 0 0
v_min_id_clo_res 1113 1113 0 0.00 0 11085 40 0 0
v_min_id_ord_sup 5993 5993 0 0.00 0 14576 10 0 0
v_min_non_paid_invoice 6342 6342 0 0.00 0 4878 14 0 0
v_min_non_paid_realizn 7575 7575 0 0.00 0 4669 13 0 0
v_our_firm 11142 11142 0 0.00 0 17 1 0 0
v_reserve_write_off 21168 21168 0 0.00 0 5893 6 0 0
x_lock_depdocs_on_canc_invoice 11525 11525 0 0.00 0 20585 116 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 7374 341 0 0
x_make_qstorno_1000_1200 5753 5753 0 0.00 1 48515 1289 0 0
x_make_qstorno_1200_2000 5997 5997 0 0.00 3 81215 3454 0 0
x_make_qstorno_2100_3300 481141 481141 0 0.00 0 126913 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-06-2021 01:28:30 to 21-06-2021 01:28:34.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:43 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
22:57:49 20828 8192000000 10285542688 10592452608 1042250736 11.286 81 56 112 2 1064163792 2837200 19075856
22:58:20 22971 8192000000 10361270592 10681626624 1408617840 14.672 100 88 177 0 1442865152 4907920 29339392
22:58:53 24485 8192000000 10406595280 10732142592 1454499136 15.077 100 88 176 0 1488924624 6489936 27935552
22:59:29 30457 8192000000 10439717264 10771288064 1487056528 15.363 100 86 172 1 1522036752 7565392 27414832
23:00:11 27009 8192000000 10457651248 10791641088 1507170800 15.539 100 87 174 0 1543158288 8602064 27385424
23:00:49 11591 8192000000 10467456224 10802356224 1522793648 15.674 100 88 176 0 1559835184 9504848 27536688
23:01:22 23492 8192000000 10492719824 10833252352 1541522352 15.837 100 90 180 2 1579740560 9688864 28529344
23:01:56 14020 8192000000 10512815120 10859786240 1570071104 16.083 100 80 160 0 1603803088 9376544 24355440
23:02:33 22513 8192000000 10559808288 10912153600 1604916848 16.381 100 78 156 0 1639048400 10514368 23617184
23:03:08 12941 8192000000 10584547536 10938941440 1636146976 16.647 100 80 160 0 1670907200 10917152 23843072
23:03:31 16750 8192000000 10591360896 10955788288 1658305488 16.835 100 83 166 2 1694625136 11671024 24648624
23:03:56 12500 8192000000 10621021568 10987778048 1677194352 16.994 100 76 152 1 1711050768 12266336 21590080
23:04:16 7588 8192000000 10629174960 10998337536 1693035696 17.127 100 73 146 2 1726578096 12524944 21017456
23:04:33 8214 8192000000 10659664208 11032825856 1715654496 17.316 100 75 150 2 1749664128 12703824 21305808
23:04:50 6283 8192000000 10670983600 11044143104 1733636608 17.466 100 79 158 2 1769317120 13448976 22231536
23:05:03 6928 8192000000 10688390112 11063226368 1741554080 17.532 100 78 156 1 1776996304 13422288 22019936
23:05:18 5477 8192000000 10689302672 11067617280 1753914944 17.634 100 79 159 1 1790056656 13859200 22282512
23:05:30 5574 8192000000 10701770752 11077545984 1759367504 17.679 100 77 154 0 1794433840 13179456 21886880
23:05:44 3289 8192000000 10697837504 11084689408 1766582976 17.739 100 76 152 3 1802087840 14036528 21468336
23:05:54 1685 8192000000 10719126048 11094515712 1775257056 17.810 100 81 162 0 1815851744 17864608 22730080
23:06:03 4287 8192000000 10730137744 11110469632 1787848368 17.914 100 83 166 0 1825904896 14608480 23448048
23:06:14 3159 8192000000 10737844480 11116531712 1792397920 17.951 100 88 175 0 1831032832 14561632 24073280
23:06:25 4181 8192000000 10729397440 11113332736 1795930912 17.981 100 78 154 2 1830797168 13292320 21573936
23:06:36 5203 8192000000 10748941536 11133857792 1803785056 18.045 100 79 157 1 1838168112 12938768 21444288
23:06:47 2851 8192000000 10756506656 11141066752 1816904016 18.152 100 77 154 1 1850571728 12138560 21529152
23:06:57 2218 8192000000 10773762464 11158462464 1830936560 18.267 100 87 172 3 1867462320 11872768 24652992
23:07:06 2117 8192000000 10768316576 11161059328 1833572192 18.288 100 75 150 0 1867104736 12406960 21125584
23:07:14 2285 8192000000 10781193232 11168387072 1839954784 18.340 100 86 169 1 1876077056 12739968 23382304
23:07:23 1280 8192000000 10787767600 11172093952 1844121968 18.374 100 81 160 1 1878623808 12747152 21754688
23:07:31 2062 8192000000 10788145232 11175243776 1849788448 18.420 100 86 170 1 1885628384 11703008 24136928
23:07:40 1769 8192000000 10800741568 11185221632 1853695632 18.452 100 87 175 2 1889976736 11535120 24745984
23:07:48 1621 8192000000 10794030720 11190128640 1860929792 18.511 100 86 171 0 1898232048 12992960 24309296
23:07:56 1699 8192000000 10803172368 11188064256 1857533856 18.483 100 90 180 1 1895228816 12734224 24960736
23:08:04 1594 8192000000 10794609648 11187564544 1857077904 18.480 100 83 166 1 1892950048 12887568 22984576
23:08:12 1298 8192000000 10811749696 11198656512 1864317024 18.538 100 96 190 1 1906029504 13878448 27834032
23:08:20 1511 8192000000 10805217664 11195699200 1865612544 18.549 100 90 181 1 1903257568 12079216 25565808
23:08:28 2023 8192000000 10807195904 11200561152 1863902592 18.535 100 90 183 1 1901695536 11810128 25982816
23:08:36 41770 8192000000 10782469072 11204046848 1859419616 18.499 100 47 94 1 1885416544 13272640 12724288
23:09:24 4587 8192000000 10783998848 11203702784 1867257216 18.562 100 46 92 0 1889019184 8970864 12791104
23:09:35 6360 8192000000 10799045488 11205681152 1869537824 18.581 100 46 93 1 1889939984 7428480 12973680
23:09:48 6538 8192000000 10787838944 11206094848 1870017072 18.584 100 47 94 1 1892128672 9426288 12685312
23:10:04 8504 8192000000 10780953296 11204698112 1871652304 18.598 100 28 56 1 1886998608 6919488 8426816
23:10:20 10055 8192000000 10779211712 11208167424 1876628464 18.638 100 33 65 1 1891414048 5864080 8921504
23:10:37 6277 8192000000 10794393360 11214426112 1872073200 18.601 100 20 39 3 1883216176 5635696 5507280
23:10:49 7792 8192000000 10797009872 11218595840 1873614080 18.614 100 18 36 0 1888634176 10347488 4672608
23:11:10 6801 8192000000 10790602880 11221839872 1880295184 18.667 100 24 48 2 1893750784 7154832 6300768
23:11:29 12001 8192000000 10786154384 11223523328 1882030336 18.681 100 20 39 1 1893049552 5680672 5338544
23:11:47 11587 8192000000 10802291424 11226906624 1883413216 18.693 100 20 39 0 1894388064 5752928 5221920
23:12:12 12108 8192000000 10798410256 11232423936 1890061088 18.746 100 17 34 1 1901247984 6012896 5174000
23:12:30 17639 8192000000 10804138976 11237957632 1896288864 18.796 100 25 52 0 1910357328 5429024 8639440
23:12:55 76390 8192000000 10819815696 11259830272 1908558384 18.895 100 45 90 0 1928939600 6950128 13431088
23:14:19 7474 8192000000 10821411376 11255963648 1908628448 18.896 100 24 48 2 1921248944 6016560 6603936
23:14:33 6791 8192000000 10834613584 11258339328 1914357424 18.942 100 35 70 4 1929929968 6462144 9110400
23:14:47 6644 8192000000 10839444688 11265675264 1909934624 18.906 100 36 72 0 1926922288 7022096 9965568
23:15:03 4549 8192000000 10839716560 11268964352 1915134688 18.948 100 32 64 0 1934905824 10739200 9031936
23:15:13 10707 8192000000 10841959392 11265056768 1916278176 18.957 100 28 56 2 1930160448 6320800 7561472
23:15:30 7384 8192000000 10837946912 11267584000 1915295360 18.949 100 34 67 1 1930816272 5707648 9813264
23:15:44 6636 8192000000 10824932064 11265273856 1915160640 18.948 100 18 36 0 1926507696 5862080 5484976
23:15:56 8343 8192000000 10832783056 11268399104 1916467920 18.959 100 17 34 1 1926713648 5225360 5020368
23:16:16 9286 8192000000 10822796144 11256963072 1893353792 18.773 99 21 42 0 1906530208 5894320 7282096
23:16:32 15249 8192000000 10822282176 11256786944 1874420976 18.620 98 14 28 2 1887975568 9514896 4039696
23:16:58 11259 8192000000 10819538608 11254161408 1887367952 18.725 99 13 26 1 1896383168 5462816 3552400
23:17:17 13665 8192000000 10745250192 11173871616 1713788128 17.300 91 17 35 2 1724109072 5225408 5095536
23:17:38 13157 8192000000 10740092544 11151826944 1786271088 17.901 97 35 71 3 1803489184 6781328 10436768
23:18:00 59791 8192000000 10737657648 11163860992 1700359312 17.188 92 34 69 1 1719102976 9226832 9516832
23:19:06 10783 8192000000 10703234656 11113287680 1672258224 16.952 92 25 48 0 1684336752 5475792 6602736
23:19:28 8291 8192000000 10695572144 11110473728 1713575408 17.299 95 27 54 2 1727751792 6164976 8011408
23:19:43 9662 8192000000 10689957232 11105980416 1684529936 17.055 94 27 52 3 1701528768 9307088 7691744
23:20:00 5298 8192000000 10668801888 11077066752 1751303504 17.612 100 32 65 4 1766621776 5554752 9763520
23:20:14 7927 8192000000 10675402672 11089813504 1730759840 17.442 98 23 46 2 1742661136 5494576 6406720
23:20:31 5490 8192000000 10683875008 11091722240 1736654192 17.491 98 26 52 0 1750762176 6610288 7497696
23:20:44 7445 8192000000 10682967968 11104108544 1762483040 17.705 99 27 54 0 1776730256 6065824 8181392
23:20:59 9900 8192000000 10725343792 11138232320 1798631760 18.003 100 19 38 2 1809397920 5308672 5457488
23:21:16 8695 8192000000 10706580784 11123671040 1747140080 17.578 97 19 38 0 1757778384 5462096 5176208
23:21:34 5108 8192000000 10711431968 11122884608 1788611792 17.920 99 34 68 2 1809505072 11442944 9450336
23:21:45 6424 8192000000 10732905360 11154022400 1814640144 18.134 100 19 38 2 1829837248 9977312 5219792
23:21:59 11764 8192000000 10756875888 11172380672 1828320688 18.246 100 23 46 0 1840355584 4845248 7189648
23:22:20 11686 8192000000 10749540096 11172524032 1816997488 18.153 99 18 36 1 1832152736 9988336 5166912
23:22:47 63485 8192000000 10753291904 11178356736 1808431488 18.083 98 30 58 0 1821956608 5091872 8433248
23:23:57 6817 8192000000 10780858368 11201761280 1851323632 18.433 100 32 64 1 1871701024 11204848 9172544
23:24:11 8060 8192000000 10769181024 11194327040 1854893856 18.462 100 30 58 2 1869351984 6152432 8305696
23:24:25 5875 8192000000 10771604096 11202011136 1861912032 18.519 100 35 71 2 1881751776 10717968 9121776
23:24:39 6288 8192000000 10788336768 11205615616 1862725744 18.525 100 22 44 2 1874077968 4647408 6704816
23:24:53 6676 8192000000 10780230352 11208388608 1867215632 18.562 100 18 36 1 1878045920 5738448 5091840
23:25:06 8777 8192000000 10778974096 11207901184 1867984448 18.568 100 20 39 4 1879899104 5907984 6006672
23:25:22 10074 8192000000 10788602000 11214573568 1873533392 18.613 100 39 78 1 1894827936 9764400 11530144
23:25:39 11616 8192000000 10781885968 11212820480 1870606640 18.589 100 18 36 0 1881167328 5349600 5211088
23:26:00 9857 8192000000 10793768704 11228475392 1875229488 18.627 100 20 40 0 1891690560 10403520 6057552
23:26:16 9280 8192000000 10799920816 11223687168 1864020640 18.536 99 29 59 2 1878137792 5000960 9116192
23:26:33 15033 8192000000 10787114960 11225456640 1881968112 18.681 100 16 32 0 1893054384 6414560 4671712
23:26:55 7387 8192000000 10794475808 11226095616 1884898992 18.705 100 22 44 1 1897623792 5536688 7188112
23:27:11 17037 8192000000 10814205856 11244310528 1899733488 18.824 100 10 20 0 1906894240 4729760 2430992
23:27:35 55898 8192000000 10833598880 11257757696 1911531984 18.919 100 29 58 3 1925093552 4876080 8685488
23:28:52 32392 8192000000 10854569424 11278135296 1924600256 19.024 100 43 85 0 1942864880 6800208 11464416
23:29:31 5614 8192000000 10859362416 11285336064 1932337472 19.086 100 48 93 3 1955870160 10122784 13409904
23:29:44 19516 8192000000 10878879712 11300212736 1936595200 19.120 100 51 102 3 1962008784 11563472 13850112
23:30:12 3420 8192000000 10878414544 11298394112 1943865472 19.178 100 64 127 2 1974728992 12593840 18269680
23:30:32 10949 8192000000 10881095968 11309867008 1949622864 19.223 100 48 94 0 1974899408 11657472 13619072
23:30:51 7235 8192000000 10885397312 11314503680 1954261696 19.260 100 45 90 0 1977758208 10900880 12595632
23:31:05 4352 8192000000 10897347296 11322839040 1959170848 19.299 100 47 94 1 1984307184 11301920 13834416
23:31:16 6249 8192000000 10889769664 11320299520 1959790176 19.304 100 45 90 1 1985116016 11665136 13660704
23:31:30 1550 8192000000 10913159760 11325210624 1965402736 19.349 100 63 123 0 1994818256 10609280 18806240
23:31:39 16319 8192000000 10905595376 11337850880 1969377312 19.381 100 50 98 0 1996381472 13280768 13723392
23:32:02 9567 8192000000 10924631616 11338952704 1976886944 19.440 100 58 116 2 2005899184 12189568 16822672
23:32:20 7519 8192000000 10909437232 11338539008 1972323008 19.404 100 53 106 0 2004422112 16953840 15145264
23:32:36 12360 8192000000 10920292608 11342868480 1978419792 19.452 100 59 118 0 2008555456 13047200 17088464
23:33:00 7386 8192000000 10916641264 11340455936 1962908448 19.329 99 60 116 3 1993833120 13384544 17540128
23:33:14 10421 8192000000 10915335760 11343872000 1964642160 19.343 99 59 118 0 1996592016 14928368 17021488
23:33:36 6375 8192000000 10910156768 11327623168 1953008816 19.250 99 57 113 0 1983559744 14226288 16324640
23:33:55 6347 8192000000 10913538352 11334782976 1966539088 19.358 100 59 119 0 1998846544 15097728 17209728
23:34:14 6162 8192000000 10913385120 11331051520 1953496912 19.254 99 65 130 0 1987718304 15435552 18785840
23:34:27 5716 8192000000 10900725328 11326414848 1962237792 19.324 100 61 122 0 1996069968 16185760 17646416
23:34:53 8919 8192000000 10902213728 11336544256 1969630176 19.383 100 54 108 2 2001302320 15336848 16335296
23:35:10 14588 8192000000 10919935408 11345227776 1981101216 19.473 100 62 124 1 2015546112 16276240 18168656
23:35:33 1737 8192000000 10918403968 11345342464 1973298576 19.412 100 64 125 3 2009761296 18063056 18399664
23:35:49 8765 8192000000 10897915104 11324776448 1943910224 19.178 99 51 103 0 1977115632 17983472 15221936
23:36:05 4901 8192000000 10886694880 11302834176 1908365504 18.894 97 63 124 0 1945364288 19770192 17228592
23:36:16 3982 8192000000 10897221728 11311071232 1925570416 19.031 99 72 144 0 1969399664 20860592 22968656
23:36:28 3896 8192000000 10913067552 11328880640 1956970512 19.282 100 77 152 1 2001077296 21272000 22834784
23:36:45 3003 8192000000 10880830640 11297865728 1904389424 18.862 98 70 140 1 1946363392 20887552 21086416
23:36:56 15538 8192000000 10853891360 11269029888 1888780704 18.736 98 61 120 1 1933272864 26322672 18169488
23:37:18 1425 8192000000 10903638688 11309334528 1945510736 19.191 100 93 181 2 1992587680 20417456 26659488
23:37:26 7894 8192000000 10881440000 11300794368 1916538176 18.959 99 69 138 2 1959002544 21921824 20542544
23:37:41 2303 8192000000 10876510160 11288858624 1917153168 18.964 100 71 142 0 1962630464 23566848 21910448
23:37:50 6757 8192000000 10850369136 11267674112 1878828848 18.656 98 65 129 3 1922721936 23839856 20053232
23:38:06 10428 8192000000 10859219344 11277078528 1899131264 18.819 99 66 131 2 1942971424 24299984 19540176
23:38:27 11321 8192000000 10879497296 11299348480 1921066048 18.995 100 56 112 1 1965069712 26819216 17184448
23:38:47 6107 8192000000 10865787264 11281854464 1909096656 18.899 100 60 120 1 1952309664 25222384 17990624
23:39:07 18112 8192000000 10860610464 11287339008 1885295712 18.708 98 53 104 1 1927882032 26531984 16054336
23:39:41 5345 8192000000 10831853296 11257425920 1883221056 18.691 100 42 84 1 1921343664 24740992 13381616
23:39:55 4494 8192000000 10853594192 11277324288 1901011088 18.834 100 56 111 0 1941668544 24138544 16518912
23:40:12 20302 8192000000 10854131504 11291586560 1906295136 18.877 100 55 110 1 1948373424 25703600 16374688
23:40:40 13821 8192000000 10859774304 11282632704 1912368096 18.926 100 64 128 0 1952306624 21344592 18593936
23:41:04 2283 8192000000 10875769280 11287257088 1917267280 18.965 100 74 148 1 1961392208 21286640 22838288
23:41:13 1288 8192000000 10875936624 11273428992 1908307024 18.893 100 94 185 1 1958173008 22970656 26895328
23:41:21 6235 8192000000 10869863296 11271655424 1907028816 18.883 99 87 174 0 1957410160 24946640 25434704
23:41:36 4199 8192000000 10890743600 11294826496 1921533424 18.999 100 82 162 0 1971859040 26576624 23748992
23:41:47 6017 8192000000 10880835616 11293130752 1917974384 18.971 100 72 144 1 1966146656 26634432 21537840
23:42:04 1490 8192000000 10865305168 11266674688 1899654272 18.824 99 76 150 0 1946409984 25071200 21684512
23:42:14 2620 8192000000 10880963104 11288584192 1917913616 18.970 100 86 174 1 1969100608 25381168 25805824
23:42:26 12037 8192000000 10863193824 11277336576 1882040896 18.682 98 62 125 1 1924175312 24179776 17954640
23:42:47 7406 8192000000 10867384656 11290103808 1918843248 18.978 100 57 113 0 1961513600 24844048 17826304
23:43:05 2484 8192000000 10908740080 11309625344 1937111088 19.124 100 87 174 0 1989785248 25482960 27191200
23:43:16 4679 8192000000 10885377648 11290894336 1902485488 18.846 98 82 164 0 1953895472 26554400 24855584
23:43:29 2660 8192000000 10901669936 11306164224 1930335824 19.070 100 82 164 1 1984820784 29485408 24999552
23:43:38 1496 8192000000 10893497056 11300229120 1923194592 19.012 100 84 164 0 1977784864 29381920 25208352
23:43:46 6999 8192000000 10887291184 11299545088 1923308320 19.013 100 74 145 1 1973509008 27503568 22697120
23:44:01 2709 8192000000 10907204944 11312603136 1936848288 19.122 100 89 175 2 1990182064 26629040 26704736
23:44:15 4799 8192000000 10905254224 11316940800 1920246528 18.989 99 73 145 1 1972994736 31045168 21703040
23:44:29 2140 8192000000 10920078656 11326074880 1943544400 19.175 100 92 184 1 2001464208 30069120 27850688
23:44:38 5251 8192000000 10909565456 11317018624 1938432096 19.134 100 81 161 1 1993234896 31005152 23797648
23:44:56 1691 8192000000 10919827232 11327119360 1948258496 19.213 100 88 177 0 2005175600 29548560 27368544
23:45:05 1987 8192000000 10927279184 11337449472 1950352048 19.229 100 78 156 1 2005665712 32301648 23012016
23:45:14 881 8192000000 10936541440 11338342400 1957255840 19.284 100 93 188 2 2017164096 30724976 29183280
23:45:23 3307 8192000000 10926013152 11338096640 1953669600 19.256 100 74 148 2 2008765664 31666656 23429408
23:45:34 3553 8192000000 10937165200 11350691840 1962441728 19.325 100 80 160 1 2019607120 32119600 25045792
23:45:44 2949 8192000000 10922596112 11333361664 1947089712 19.203 100 75 148 0 2004167872 33406592 23671568
23:45:55 4521 8192000000 10934342688 11340476416 1951957504 19.242 100 88 177 2 2014073792 34993584 27122704
23:46:08 4267 8192000000 10931967744 11345305600 1955690192 19.272 100 80 160 1 2015149104 34616448 24842464
23:46:19 3583 8192000000 10916823680 11331190784 1946837776 19.201 100 70 135 1 2002531936 34590384 21103776
23:46:34 4658 8192000000 10930051824 11346546688 1956478624 19.278 100 75 149 1 2016320064 37088240 22753200
23:46:48 9942 8192000000 10943623152 11355475968 1953957200 19.258 100 74 147 0 2018930160 41817328 23155632
23:47:07 4603 8192000000 10926959488 11354116096 1956626624 19.279 100 57 114 1 2015539040 40294272 18618144
23:47:18 7165 8192000000 10931631232 11364945920 1961847680 19.321 100 51 103 1 2018929840 39861792 17220368
23:47:33 4878 8192000000 10928426544 11353128960 1950526736 19.231 99 60 117 4 2012042176 40367680 21147760
23:47:47 8132 8192000000 10927985120 11350171648 1941947280 19.162 99 50 97 1 2001714480 42658336 17108864
23:48:01 12999 8192000000 10922135424 11362119680 1956748864 19.280 100 44 88 0 2014356880 42565520 15042496
23:48:25 10507 8192000000 10916902384 11360845824 1943661952 19.176 99 39 78 1 1996436304 39965040 12809312
23:48:50 6013 8192000000 10910401600 11331141632 1925393168 19.030 98 43 86 2 1968681888 29935888 13352832
23:49:02 11271 8192000000 10915574464 11361239040 1963246928 19.332 100 37 74 0 2007418720 32482256 11689536
23:49:20 12490 8192000000 10911783632 11353391104 1924662576 19.024 98 35 68 1 1970103312 34280000 11160736
23:49:39 8721 8192000000 10914863088 11354042368 1950329328 19.229 100 31 63 0 1997092512 36293072 10470112
23:50:05 13469 8192000000 10913170848 11352137728 1951494272 19.238 100 34 68 2 1997286640 34162960 11629408
23:50:25 7912 8192000000 10919379744 11353178112 1932686048 19.088 99 47 94 1 1985028464 36723760 15618656
23:50:55 9330 8192000000 10918777504 11356672000 1932507472 19.087 99 33 66 0 1984034208 40079616 11447120
23:51:12 6369 8192000000 10927115040 11363151872 1950903456 19.234 100 37 74 1 2006844352 43503856 12437040
23:51:27 17843 8192000000 10932802192 11371974656 1954387088 19.261 100 37 74 0 2014537520 47197424 12953008
23:51:56 15082 8192000000 10924364048 11372892160 1952564240 19.247 100 36 72 0 2008766144 44078496 12123408
23:52:22 23275 8192000000 10921644672 11363835904 1959351248 19.301 100 36 71 3 2013002064 40933776 12717040
23:53:03 13684 8192000000 10907800672 11353710592 1957094352 19.283 100 33 64 4 1996296896 27189040 12013504
23:53:24 11431 8192000000 10952565360 11377594368 1976556016 19.437 100 63 126 3 2023878672 27356368 19966288
23:53:43 29038 8192000000 10920281152 11387400192 1974756048 19.423 100 42 84 2 2020479152 31929856 13793248
23:54:35 21332 8192000000 10934346400 11375304704 1975177456 19.426 100 36 72 1 2007421664 21939216 10304992
23:55:04 13718 8192000000 10926143600 11379625984 1977031680 19.441 100 25 49 0 2006689040 22261200 7396160
23:55:24 26745 8192000000 10920870384 11380899840 1976907792 19.440 100 19 38 1 2007823312 24775408 6140112
23:56:08 33223 8192000000 10917281840 11383648256 1974051568 19.418 100 20 40 0 2006269696 26561856 5656272
23:56:50 73353 8192000000 10923815456 11374948352 1983353536 19.491 100 19 37 2 2008766784 20548672 4864576
23:58:15 57372 8192000000 10931017040 11400208384 1965475984 19.350 99 16 32 1 1994323584 23332288 5515312
23:59:20 114467 8192000000 10932366096 11382951936 1993107936 19.568 100 10 20 0 2009482960 13647520 2727504
00:01:33 25817 8192000000 10942892944 11401146368 2008341408 19.688 100 44 83 3 2026546160 6459616 11745136
00:02:17 57375 8192000000 10920504256 11387584512 1961466032 19.318 98 5 10 1 1973872112 11230064 1176016
00:03:24 82424 8192000000 10937173760 11374395392 1960642496 19.311 98 23 46 1 1977637232 10319616 6675120
00:04:54 45653 8192000000 10922690336 11378065408 1954459968 19.262 98 25 50 3 1970639840 8978864 7201008
00:05:46 53417 8192000000 10920547184 11382874112 1985726224 19.510 100 21 40 0 2005295024 13735328 5833472
00:06:47 14066 8192000000 10950045664 11388674048 1980876000 19.472 99 36 71 0 2005228416 13636864 10715552
00:07:39 132171 8192000000 10913130960 11384012800 1889523248 18.742 95 8 16 0 1910162720 18173712 2465760
00:09:57 97234 8192000000 10899499344 11358765056 1927925664 19.050 97 25 50 0 1945244032 9674656 7643712
00:11:46 32865 8192000000 10900710432 11345477632 1938414656 19.134 98 40 80 1 1959364784 10011792 10938336
00:12:30 71291 8192000000 10902948912 11348586496 1899650976 18.823 97 29 54 3 1920173008 13296304 7225728
00:13:49 77159 8192000000 10875789760 11341905920 1927028272 19.043 98 44 87 0 1947844656 8863104 11953280
00:15:14 95639 8192000000 10872248048 11338383360 1869838544 18.583 95 24 46 2 1886302816 10027248 6437024
00:17:28 53812 8192000000 10910885856 11348983808 1939013584 19.139 99 48 96 1 1965146144 11748976 14383584
00:18:33 36554 8192000000 10874287056 11338743808 1940586192 19.151 99 31 62 1 1964430576 14328656 9515728
00:19:20 51981 8192000000 10851079728 11317661696 1874226032 18.618 96 13 25 1 1887526448 9059040 4241376
00:20:19 5320 8192000000 10865738352 11323678720 1928416608 19.054 99 29 58 0 1943754848 6609776 8728464
00:20:31 18717 8192000000 10853769328 11314958336 1919763472 18.985 99 14 29 1 1929716672 6509488 3443712
00:21:00 85051 8192000000 10873596928 11350814720 1922810560 19.009 99 25 50 1 1946202688 16168976 7223152
00:22:37 36181 8192000000 10864747808 11342811136 1928391440 19.054 99 10 20 0 1947170832 16074384 2705008
00:23:19 53522 8192000000 10847064256 11322105856 1907409888 18.886 98 15 29 1 1922333424 10653264 4270272
00:24:19 56895 8192000000 10879421488 11352510464 1946298656 19.197 100 20 40 1 1961826624 10282976 5244992
00:25:28 47243 8192000000 10869105008 11330879488 1906231904 18.876 98 21 42 0 1925511776 14244000 5035872
00:26:24 43843 8192000000 10842678336 11307958272 1880296224 18.667 97 16 32 1 1891480816 6545600 4638992
00:27:14 71277 8192000000 10844026880 11319943168 1888377376 18.733 97 12 24 1 1901234432 8776096 4080960
00:28:38 61158 8192000000 10840859568 11321946112 1893290992 18.772 98 8 16 0 1901893344 6395936 2206416
00:29:59 53485 8192000000 10854581040 11325181952 1861883600 18.519 96 12 24 0 1875953040 11187488 2881952
00:30:59 97862 8192000000 10859469328 11332595712 1853061792 18.447 96 8 16 0 1866380768 11605248 1713728
00:32:43 23136 8192000000 10858192448 11316264960 1910043984 18.907 99 14 28 1 1922270944 8346704 3880256
00:33:17 52994 8192000000 10861468064 11320639488 1844747632 18.379 95 27 54 2 1861927088 9333152 7846304
00:34:21 32334 8192000000 10864135024 11335110656 1931832336 19.082 100 16 32 0 1950112752 13253504 5026912
00:35:05 54518 8192000000 10857533696 11322585088 1865554576 18.548 96 14 28 0 1883840992 14364384 3922032
00:36:25 45173 8192000000 10880574016 11337351168 1919206864 18.980 99 21 41 1 1942837968 17029024 6602080
00:37:20 22203 8192000000 10907707088 11345874944 1926229696 19.037 99 45 90 0 1946125152 7158784 12736672
00:37:50 17584 8192000000 10908199760 11358969856 1956094368 19.275 100 45 90 0 1978793840 10231568 12467904
00:38:30 99982 8192000000 10870464624 11349606400 1867065168 18.561 95 28 56 0 1893301088 18380768 7855152
00:40:16 59699 8192000000 10885181376 11330252800 1865437104 18.547 96 32 64 0 1885955632 11522336 8996192
00:41:24 24169 8192000000 10882805824 11340963840 1940779776 19.153 100 29 58 1 1958811376 10102400 7929200
00:41:59 73233 8192000000 10888694768 11353747456 1923542704 19.015 98 23 46 0 1942511568 12582496 6386368
00:43:24 42975 8192000000 10899513008 11355283456 1951947936 19.242 100 23 46 2 1970687648 12460464 6279248
00:44:16 110628 8192000000 10901990432 11355049984 1937290976 19.125 99 20 39 2 1952630224 9689824 5649424
00:46:16 33453 8192000000 10891698560 11346690048 1936294464 19.117 99 15 30 0 1948404112 7877520 4232128
00:47:05 57747 8192000000 10887915088 11357663232 1946840016 19.201 99 34 68 0 1967486096 10866112 9779968
00:48:10 19542 8192000000 10899706064 11363180544 1961205488 19.316 100 27 54 2 1984059232 15668176 7185568
00:48:36 17483 8192000000 10905423040 11370790912 1969536336 19.382 100 28 56 0 1988568800 11099600 7932864
00:49:02 10182 8192000000 10894456880 11359141888 1962962192 19.330 99 65 129 3 1990847952 9287568 18598192
00:49:28 81137 8192000000 10885871712 11358171136 1940050144 19.147 99 16 32 0 1953274256 8601984 4622128
00:50:56 50548 8192000000 10875413808 11361243136 1926980272 19.043 98 16 32 0 1951032672 19391936 4660464
00:52:01 49733 8192000000 10876777504 11358150656 1961507904 19.318 100 18 36 1 1977031184 9877232 5646048
00:53:04 90872 8192000000 10881506976 11363078144 1910228896 18.908 97 16 34 1 1924275264 9175024 4871344
00:54:41 55819 8192000000 10855879536 11329032192 1896014688 18.794 97 10 20 0 1911544624 13033456 2496480
00:55:43 59858 8192000000 10887688544 11356991488 1932677696 19.088 99 20 40 2 1947746928 9496896 5572336
00:57:06 44778 8192000000 10877545776 11346223104 1904129872 18.859 97 27 54 0 1923919376 12313344 7476160
00:58:05 58591 8192000000 10895736320 11361058816 1922030608 19.003 98 17 34 1 1937686736 10559328 5096800
00:59:23 65023 8192000000 10911617184 11386753024 1928349648 19.054 98 15 30 0 1951397248 18814704 4232896
01:01:32 85045 8192000000 10911578768 11380408320 1942080192 19.163 98 14 28 0 1959322240 13008880 4233168
01:03:04 28647 8192000000 10924229936 11385143296 1967543168 19.366 99 30 60 0 1993112656 15698864 9870624
01:03:46 46223 8192000000 10896179792 11376427008 1915533056 18.951 97 12 24 0 1939639488 20955600 3150832
01:04:45 81656 8192000000 10892959968 11366301696 1892990560 18.770 96 26 52 1 1914966400 14921168 7054672
01:06:15 78977 8192000000 10892639360 11362377728 1887401824 18.725 96 22 41 3 1905460000 12420480 5637696
01:07:44 25317 8192000000 10910910208 11370848256 1963421888 19.333 100 23 46 0 1979272704 9633184 6217632
01:08:25 76296 8192000000 10913010784 11373920256 1974011584 19.417 100 42 84 0 1997480576 11480512 11988480
01:10:03 71952 8192000000 10888072800 11363602432 1880656640 18.670 95 20 40 2 1897255936 11269792 5329504
01:11:23 46325 8192000000 10907557616 11361931264 1966298720 19.356 100 34 67 1 1987013264 11339840 9374704
01:12:37 52772 8192000000 10859949168 11340591104 1899161024 18.820 97 21 42 1 1920216592 15062336 5993232
01:13:44 32235 8192000000 10864637552 11345375232 1925240096 19.029 99 8 16 0 1940948464 13705872 2002496
01:14:44 38798 8192000000 10840702128 11321708544 1885265248 18.708 97 12 24 1 1895471296 7230000 2976048
01:15:31 32853 8192000000 10795700624 11263524864 1854056288 18.455 96 11 22 1 1863068048 6159984 2851776
01:16:11 83129 8192000000 10847485728 11317968896 1892070128 18.762 98 16 32 0 1904722240 8065792 4586320
01:18:34 49311 8192000000 10873845904 11352924160 1927117168 19.044 99 13 26 1 1940049168 9083600 3848400
01:19:36 40642 8192000000 10867808736 11328917504 1899573504 18.823 98 25 50 1 1914113440 6975232 7564704
01:20:23 35814 8192000000 10852430224 11321270272 1877403728 18.644 97 19 36 3 1890444384 7817808 5222848
01:21:14 29847 8192000000 10870459536 11342245888 1936793952 19.121 100 23 46 0 1954623488 10868800 6960736
01:21:53 37635 8192000000 10891394000 11361779712 1952701040 19.248 100 29 58 2 1976577904 15406992 8469872
01:22:37 89267 8192000000 10855187168 11338514432 1854548048 18.459 95 12 24 1 1873077840 15083216 3446576
01:24:12 25212 8192000000 10867864736 11332640768 1923849568 19.018 99 21 42 1 1937190752 7623312 5717872
01:24:44 22687 8192000000 10910366384 11363409920 1956549888 19.279 100 51 102 1 1980917984 10152496 14215600
01:25:15 25432 8192000000 10907629696 11367809024 1943476736 19.174 99 44 88 1 1969824704 13860704 12487264
01:25:50 56208 8192000000 10887863216 11364450304 1946228960 19.196 99 26 52 1 1967274592 13461488 7584144
01:26:53 52022 8192000000 8889388256 9203920896 5227504 0.063 1 1 2 0 5351888 62256 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 21-06-2021 01:28:35 to 21-06-2021 01:29:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 140 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-06-2021 01:29:09 to 21-06-2021 01:29:11.

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          258490
MON$OLDEST_ACTIVE               258491
MON$OLDEST_SNAPSHOT             258491
MON$NEXT_TRANSACTION            258491
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                       2063968
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

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

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

21.06.21 01:29:12. 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-06-21 01:29:14 No severe PSQL-related problems occured
21.06.21 01:29:15. End of report.