Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.03.2021 01: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 df9f488d08424df294c459d6c283e9c3
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-03-04 16:07
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.26
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 17365036 kB
MemAvailable 31548640 kB
Buffers 0 kB
Cached 14334856 kB
SwapCached 0 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-03-24 01:27:22
DTS_END                         2021-03-24 01:27:22.8240
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(76:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50604
TRN_ID                          238918
ATT_ID                          646
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: 9179.15 19729 1101498
customer order: creation 172.57 343 20708
customer order: refuse 14.78 360 1774
order to supplier: creation 46.03 1261 5523
order to supplier: removal 3.47 102545 416
invoice (draft): creation 45.83 3920 5500
invoice (draft): removal 51.37 811 6164
invoice accept: apply 42.17 18815 5060
invoice accept: cancel 46.52 832 5582
customer reserve: creation 3895.98 186 467518
customer reserve: removal 4563.59 60 547631
realization accept: apply 84.86 195 10183
realization accept: cancel 82.78 106 9934
payment from customer: creation 57.72 138 6926
payment from customer: removal 5.92 72 710
payment to supplier: creation 49.51 140 5941
payment to supplier: removal 3.47 50 416
service: total inventory turnovers 5.17 1041 620
service: total monetary turnovers 6.51 27 781
service: aggregate perf. data 0.89 19903 107
service: refresh index statistics 0.03 243772 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-03-2021 01:28:59 to 24-03-2021 01:29:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4859
TEST_TIME 2 6144
TEST_TIME 3 6498
TEST_TIME 4 5950
TEST_TIME 5 6018
TEST_TIME 6 6373
TEST_TIME 7 7141
TEST_TIME 8 6912
TEST_TIME 9 6680
TEST_TIME 10 6389
TEST_TIME 11 6293
TEST_TIME 12 6226
TEST_TIME 13 6186
TEST_TIME 14 6653
TEST_TIME 15 6592
TEST_TIME 16 6608
TEST_TIME 17 6710
TEST_TIME 18 6892
TEST_TIME 19 7022
TEST_TIME 20 7219
TEST_TIME 21 7424
TEST_TIME 22 7856
TEST_TIME 23 8177
TEST_TIME 24 8128
TEST_TIME 25 8591
TEST_TIME 26 8737
TEST_TIME 27 9005
TEST_TIME 28 9663
TEST_TIME 29 10191
TEST_TIME 30 10461
TEST_TIME 31 10355
TEST_TIME 32 10472
TEST_TIME 33 10489
TEST_TIME 34 10346
TEST_TIME 35 10143
TEST_TIME 36 10108
TEST_TIME 37 10018
TEST_TIME 38 10060
TEST_TIME 39 9988
TEST_TIME 40 10036
TEST_TIME 41 9898
TEST_TIME 42 9821
TEST_TIME 43 9751
TEST_TIME 44 9870
TEST_TIME 45 9757
TEST_TIME 46 9770
TEST_TIME 47 9647
TEST_TIME 48 9583
TEST_TIME 49 9535
TEST_TIME 50 9566
TEST_TIME 51 9671
TEST_TIME 52 9620
TEST_TIME 53 9600
TEST_TIME 54 9541
TEST_TIME 55 9481
TEST_TIME 56 9575
TEST_TIME 57 9520
TEST_TIME 58 9549
TEST_TIME 59 9608
TEST_TIME 60 9632
TEST_TIME 61 9693
TEST_TIME 62 9695
TEST_TIME 63 9680
TEST_TIME 64 9707
TEST_TIME 65 9725
TEST_TIME 66 9779
TEST_TIME 67 9817
TEST_TIME 68 9712
TEST_TIME 69 9651
TEST_TIME 70 9583
TEST_TIME 71 9549
TEST_TIME 72 9527
TEST_TIME 73 9465
TEST_TIME 74 9410
TEST_TIME 75 9342
TEST_TIME 76 9328
TEST_TIME 77 9369
TEST_TIME 78 9391
TEST_TIME 79 9348
TEST_TIME 80 9332
TEST_TIME 81 9410
TEST_TIME 82 9401
TEST_TIME 83 9401
TEST_TIME 84 9385
TEST_TIME 85 9432
TEST_TIME 86 9404
TEST_TIME 87 9417
TEST_TIME 88 9458
TEST_TIME 89 9436
TEST_TIME 90 9369
TEST_TIME 91 9349
TEST_TIME 92 9313
TEST_TIME 93 9364
TEST_TIME 94 9325
TEST_TIME 95 9297
TEST_TIME 96 9298
TEST_TIME 97 9292
TEST_TIME 98 9288
TEST_TIME 99 9357
TEST_TIME 100 9318
TEST_TIME 101 9344
TEST_TIME 102 9305
TEST_TIME 103 9335
TEST_TIME 104 9437
TEST_TIME 105 9463
TEST_TIME 106 9431
TEST_TIME 107 9439
TEST_TIME 108 9530
TEST_TIME 109 9456
TEST_TIME 110 9386
TEST_TIME 111 9373
TEST_TIME 112 9347
TEST_TIME 113 9361
TEST_TIME 114 9323
TEST_TIME 115 9290
TEST_TIME 116 9272
TEST_TIME 117 9235
TEST_TIME 118 9202
TEST_TIME 119 9248
TEST_TIME 120 9181

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 24-03-2021 01:29:02 to 24-03-2021 01:29:06.

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 1534714 1534714 0 0.00 0 19693 6 0 0
doc_list_biud 1534712 1534712 0 0.00 0 68315 28 0 0
sp_add_invoice_to_stock 5171 5060 111 2.14 25 204184 18816 0 111
sp_cancel_adding_invoice 5582 5582 0 0.00 5 75380 833 0 0
sp_cancel_client_order 1774 1774 0 0.00 4 11216 360 0 0
sp_cancel_customer_reserve 547631 547631 0 0.00 1 68317 61 0 0
sp_cancel_pay_from_customer 710 710 0 0.00 3 2785 72 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 3 1786 50 0 0
sp_cancel_supplier_invoice 6173 6164 9 0.14 2 21880 811 0 9
sp_cancel_supplier_order 416 416 0 0.00 5 1221255 102546 0 0
sp_cancel_write_off 9934 9934 0 0.00 1 16612 107 0 0
sp_client_order 20708 20708 0 0.00 3 20942 344 0 0
sp_customer_reserve 467518 467518 0 0.00 0 122672 186 0 0
sp_fill_shopping_cart 31715 31715 0 0.00 1 24275 40 0 0
sp_fill_shopping_cart_clo_res 467514 467514 0 0.00 0 17367 14 0 0
sp_get_clo_for_invoice 5056 5056 0 0.00 0 38782 291 0 0
sp_kill_cost_storno 16642 16642 0 0.00 0 11106 58 0 0
sp_kill_qstorno_ret_qs2qd 1111776 1111776 0 0.00 0 68312 33 0 0
sp_kill_qty_storno 586740 586740 0 0.00 0 68314 72 0 0
sp_lock_selected_doc 21094 21094 0 0.00 0 6617 6 0 0
sp_make_cost_storno 28106 28106 0 0.00 0 19685 64 0 0
sp_multiply_rows_for_pdistr 28106 28106 0 0.00 0 13124 29 0 0
sp_multiply_rows_for_qdistr 20708 20708 0 0.00 0 12087 165 0 0
sp_pay_from_customer 6926 6926 0 0.00 4 20024 139 0 0
sp_pay_to_supplier 5941 5941 0 0.00 4 19650 141 0 0
sp_payment_common 12867 12867 0 0.00 1 19755 45 0 0
sp_qd_handle_on_cancel_clo 1774 1774 0 0.00 0 11207 330 0 0
sp_qd_handle_on_invoice_upd_sts 10638 10638 0 0.00 0 41093 359 0 0
sp_qd_handle_on_reserve_upd_sts 10183 10183 0 0.00 0 23139 66 0 0
sp_reserve_write_off 10183 10183 0 0.00 7 23156 196 0 0
sp_supplier_invoice 5500 5500 0 0.00 6 114851 3921 0 0
sp_supplier_order 5523 5523 0 0.00 6 26269 1262 0 0
srv_aggregate_perf_data 108 107 1 0.92 2226 182237 19903 0 1
srv_fill_mon_cache_memory 165 165 0 0.00 1199 159785 30847 0 0
srv_find_qd_qs_mism 1053738 1053738 0 0.00 0 15971 5 0 0
srv_make_invnt_saldo 620 620 0 0.00 45 68855 1041 0 0
srv_make_money_saldo 781 781 0 0.00 1 2929 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 142421 312399 243772 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 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 5060 5060 0 0.00 0 11719 190 0 0
t$perf-norm:sp_cancel_adding_invoice 419 419 0 0.00 0 7544 109 0 0
t$perf-norm:sp_cancel_client_order 1774 1774 0 0.00 0 7508 25 0 0
t$perf-norm:sp_cancel_customer_reserve 705 705 0 0.00 0 3921 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 710 710 0 0.00 0 4010 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 4146 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 392 392 0 0.00 0 9514 36 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 17537 1530 0 0
t$perf-norm:sp_cancel_write_off 1023 1023 0 0.00 0 2161 7 0 0
t$perf-norm:sp_client_order 20708 20708 0 0.00 0 9697 24 0 0
t$perf-norm:sp_customer_reserve 1006 1006 0 0.00 0 5861 22 0 0
t$perf-norm:sp_pay_from_customer 6926 6926 0 0.00 0 10860 15 0 0
t$perf-norm:sp_pay_to_supplier 5941 5941 0 0.00 0 9458 13 0 0
t$perf-norm:sp_reserve_write_off 10183 10183 0 0.00 0 13738 19 0 0
t$perf-norm:sp_supplier_invoice 5500 5500 0 0.00 0 7487 25 0 0
t$perf-norm:sp_supplier_order 5523 5523 0 0.00 0 4731 18 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 111 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 624 7 0 0
t$perf-norm:srv_make_invnt_saldo 621 621 0 0.00 0 1007 21 0 0
t$perf-norm:srv_make_money_saldo 781 781 0 0.00 0 1643 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 13 5 0 0
v_add_invoice_to_stock 10334 10112 222 2.14 0 7941 18 0 222
v_all_customers 36902 36902 0 0.00 0 107 1 0 0
v_all_suppliers 30612 30612 0 0.00 0 107 1 0 0
v_all_wares 41416 41416 0 0.00 0 115 1 0 0
v_cancel_adding_invoice 838 838 0 0.00 0 622 8 0 0
v_cancel_client_order 3548 3548 0 0.00 0 2548 6 0 0
v_cancel_customer_prepayment 1420 1420 0 0.00 0 2745 6 0 0
v_cancel_customer_reserve 1410 1410 0 0.00 0 4865 7 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 547 3 0 0
v_cancel_supplier_invoice 802 784 18 2.24 0 1708 19 0 18
v_cancel_supplier_order 832 832 0 0.00 0 1188 8 0 0
v_cancel_write_off 2046 2046 0 0.00 0 1180 12 0 0
v_max_id_clo_ord 5522 5522 0 0.00 0 2700 2 0 0
v_max_id_clo_res 1006 1006 0 0.00 0 2107 13 0 0
v_max_id_ord_sup 5485 5485 0 0.00 0 11981 6 0 0
v_max_non_paid_invoice 1642 1642 0 0.00 0 736 3 0 0
v_max_non_paid_realizn 3926 3926 0 0.00 0 5639 5 0 0
v_min_id_clo_ord 5522 5522 0 0.00 0 9022 14 0 0
v_min_id_clo_res 1006 1006 0 0.00 0 2692 10 0 0
v_min_id_ord_sup 5485 5485 0 0.00 0 9996 13 0 0
v_min_non_paid_invoice 5941 5941 0 0.00 0 19596 35 0 0
v_min_non_paid_realizn 6926 6926 0 0.00 0 19748 35 0 0
v_our_firm 10514 10514 0 0.00 0 27 1 0 0
v_reserve_write_off 20366 20366 0 0.00 0 9196 7 0 0
x_lock_depdocs_on_canc_invoice 11354 11354 0 0.00 0 16425 121 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 4915 350 0 0
x_make_qstorno_1000_1200 5523 5523 0 0.00 2 26059 1169 0 0
x_make_qstorno_1200_2000 5500 5500 0 0.00 3 114818 3786 0 0
x_make_qstorno_2100_3300 467518 467518 0 0.00 0 122671 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-03-2021 01:29:07 to 24-03-2021 01:29:11.

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:26 6 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:32 21091 8192000000 10251676368 10552311808 909246576 9.990 71 60 120 0 932255296 2741936 20266784
22:58:06 37452 8192000000 10330671696 10645176320 1367133696 14.301 100 86 171 2 1400677200 5255056 28288448
22:58:51 27138 8192000000 10370641456 10692321280 1415677968 14.734 100 85 170 0 1450287232 6592800 28016464
22:59:29 29588 8192000000 10407923392 10731483136 1451881680 15.054 100 86 171 1 1487838096 7833360 28123056
23:00:07 23157 8192000000 10429656640 10757038080 1479876128 15.300 100 93 186 0 1518096992 8390480 29830384
23:00:39 22244 8192000000 10445030864 10773970944 1495297616 15.435 100 92 184 1 1533917312 8917008 29702688
23:01:16 16320 8192000000 10457826944 10792230912 1507526720 15.542 100 86 172 0 1544199520 9316560 27356240
23:01:49 15533 8192000000 10487298880 10831949824 1546129152 15.877 100 80 160 0 1580566864 9858160 24579552
23:02:13 15353 8192000000 10519494480 10871951360 1579032192 16.160 100 78 156 1 1612586320 10053072 23501056
23:02:38 14443 8192000000 10559887568 10918879232 1614160640 16.460 100 77 155 0 1648238816 10587504 23490672
23:03:02 6348 8192000000 10586520432 10945728512 1643612224 16.710 100 76 151 0 1676748400 10888720 22247456
23:03:17 7686 8192000000 10608485600 10971570176 1666528544 16.904 100 76 152 0 1700293728 11182720 22582464
23:03:34 9043 8192000000 10619011552 10986102784 1680888400 17.025 100 77 154 3 1715781392 11866384 23026608
23:03:52 11971 8192000000 10629056832 10998902784 1693304400 17.129 100 71 142 1 1726317184 11745680 21267104
23:04:14 9854 8192000000 10663038928 11038674944 1722466688 17.373 100 78 157 1 1756894800 11656272 22771840
23:04:32 10573 8192000000 10676182208 11056902144 1740299664 17.521 100 71 142 1 1772672112 12148256 20224192
23:04:50 6656 8192000000 10691050784 11071270912 1755999072 17.651 100 75 150 1 1789922816 12811824 21111920
23:05:04 5763 8192000000 10696121184 11076182016 1765740224 17.732 100 78 156 1 1801064384 12781920 22542240
23:05:16 5562 8192000000 10713967136 11092414464 1774058800 17.801 100 84 168 0 1811563360 13617040 23887520
23:05:29 7747 8192000000 10720962944 11105058816 1782860240 17.873 100 78 156 1 1818516048 14052400 21603408
23:05:49 7809 8192000000 10738067392 11119058944 1788499504 17.919 100 82 162 3 1825163184 14330528 22333152
23:06:03 5027 8192000000 10746011424 11126329344 1799713872 18.012 100 84 167 2 1837873584 14843520 23316192
23:06:15 3008 8192000000 10743987376 11130400768 1808044480 18.080 100 80 160 2 1843317680 13210672 22062528
23:06:25 3358 8192000000 10758307120 11142586368 1813042784 18.121 100 85 171 0 1850947616 14316048 23588784
23:06:35 3428 8192000000 10760687856 11147546624 1817679680 18.159 100 80 158 2 1854726928 14742624 22304624
23:06:47 3515 8192000000 10767629248 11156697088 1823526688 18.206 100 80 160 0 1859282144 13655136 22100320
23:06:57 2696 8192000000 10774101792 11158929408 1830921872 18.267 100 85 168 0 1869480240 14479584 24078784
23:07:07 2418 8192000000 10780743568 11169554432 1836940944 18.316 100 88 177 1 1876060208 13652000 25467264
23:07:16 2822 8192000000 10787877184 11177816064 1843597520 18.370 100 91 183 0 1883316336 14019968 25698848
23:07:26 2818 8192000000 10787036704 11178139648 1849405088 18.417 100 84 169 0 1885239264 12078448 23755728
23:07:36 2145 8192000000 10783241056 11175702528 1851145824 18.431 100 86 172 1 1888567424 13539984 23881616
23:07:45 1754 8192000000 10799858384 11186786304 1855426320 18.466 100 86 168 1 1892364672 12555264 24383088
23:07:54 2822 8192000000 10797277376 11189383168 1862665504 18.525 100 86 172 3 1900007456 13244848 24097104
23:08:03 3160 8192000000 10807892960 11197304832 1867791440 18.566 100 91 182 0 1907444208 14500272 25152496
23:08:13 2033 8192000000 10808848784 11198812160 1863282992 18.530 100 87 174 4 1901306512 14104032 23919488
23:08:21 3029 8192000000 10805226160 11195592704 1866294912 18.554 100 92 185 2 1906848816 13790048 26763856
23:08:31 2204 8192000000 10801283376 11194081280 1867759120 18.566 100 87 175 1 1904753296 12668128 24326048
23:08:39 2353 8192000000 10809265936 11203465216 1871417648 18.596 100 89 177 0 1907819504 11477040 24924816
23:08:48 2391 8192000000 10818003408 11208417280 1874329584 18.619 100 91 180 2 1912678496 12850656 25498256
23:08:57 1715 8192000000 10815008336 11211067392 1875180432 18.626 100 88 176 0 1912677232 13232288 24264512
23:09:06 1632 8192000000 10818994560 11210559488 1882343872 18.684 100 87 175 2 1919947168 12968320 24634976
23:09:14 2708 8192000000 10809067616 11210895360 1885054256 18.706 100 87 174 1 1922079568 12940528 24084784
23:09:24 15829 8192000000 10829007840 11223302144 1881075024 18.674 100 68 136 1 1911544048 10966704 19502320
23:09:46 5354 8192000000 10818518480 11221692416 1884383872 18.700 100 73 144 0 1916118320 11691056 20043392
23:10:12 1606 8192000000 10822751024 11222605824 1888743600 18.736 100 82 164 1 1924563584 12728512 23091472
23:10:20 1634 8192000000 10821505632 11222675456 1888605952 18.735 100 80 161 0 1924396448 13549392 22241104
23:10:28 1860 8192000000 10823734752 11227963392 1885705248 18.711 100 68 136 0 1918240272 13550864 18984160
23:10:36 2769 8192000000 10814366288 11224571904 1886800432 18.720 100 60 120 1 1915181728 12490256 15891040
23:10:45 2734 8192000000 10816102448 11222224896 1885125472 18.706 100 43 89 0 1904987440 7995536 11866432
23:10:55 3987 8192000000 10813416832 11222298624 1887663120 18.727 100 48 96 0 1910469280 9145168 13660992
23:11:05 9002 8192000000 10788759632 11219025920 1888565024 18.734 100 37 72 2 1904998128 6588400 9844704
23:11:25 6766 8192000000 10793022032 11219521536 1883661904 18.695 100 20 40 2 1895998400 6584752 5751744
23:11:39 6640 8192000000 10799383008 11227332608 1892043056 18.762 100 25 50 3 1905447008 6139552 7264400
23:11:55 5398 8192000000 10802270416 11226308608 1893917952 18.777 100 33 67 0 1910327856 7345488 9064416
23:12:09 13290 8192000000 10805484800 11235819520 1897425200 18.806 100 30 60 1 1913718672 7499136 8794336
23:12:31 62440 8192000000 10837835536 11250966528 1902741008 18.848 100 45 90 1 1920740688 4289584 13710096
23:13:40 1330 8192000000 10868234320 11264991232 1913812704 18.937 100 93 187 0 1950589408 10152928 26623776
23:13:47 3735 8192000000 10829436320 11256737792 1906680912 18.880 100 53 104 1 1932936736 11618640 14637184
23:13:57 4879 8192000000 10826285008 11251736576 1902434160 18.846 100 30 60 1 1919530480 8506496 8589824
23:14:11 4657 8192000000 10826640880 11250855936 1902800032 18.849 100 35 70 0 1920008144 7429184 9778928
23:14:22 5840 8192000000 10828053968 11254050816 1906924528 18.882 100 40 78 2 1925432736 6919808 11588400
23:14:36 6271 8192000000 10836264912 11262738432 1905347952 18.869 100 28 56 1 1923822912 10696144 7778816
23:14:50 4830 8192000000 10833490496 11261939712 1911961872 18.922 100 40 80 2 1929661712 6159584 11540256
23:15:06 43509 8192000000 10818452400 11258687488 1915624064 18.952 100 37 74 1 1933096272 6303360 11168848
23:15:58 7814 8192000000 10835642336 11266211840 1916704224 18.960 100 32 64 5 1933034288 6973152 9356912
23:16:13 9054 8192000000 10818257856 11246432256 1896559648 18.799 99 32 64 1 1912401440 6289664 9552128
23:16:28 7314 8192000000 10831123232 11263741952 1914084832 18.939 100 33 65 4 1929217504 5791264 9341408
23:16:45 6972 8192000000 10814297280 11249401856 1904116592 18.859 100 28 55 0 1917332128 5727136 7488400
23:16:59 5236 8192000000 10833511456 11261149184 1907272528 18.885 100 47 94 1 1928654528 8274016 13107984
23:17:11 3689 8192000000 10817886064 11247554560 1900722752 18.832 100 44 89 2 1921134656 7502608 12909296
23:17:22 6211 8192000000 10830534448 11255103488 1907014032 18.883 100 28 56 2 1920941200 5794288 8132880
23:17:34 5728 8192000000 10815857472 11242594304 1879367088 18.660 99 39 79 1 1897262416 6250576 11644752
23:17:48 4465 8192000000 10808530096 11234697216 1892551920 18.766 100 30 61 2 1907338128 5797040 8989168
23:17:59 6067 8192000000 10761340848 11186049024 1766204752 17.736 93 31 63 0 1781605920 5626352 9774816
23:18:11 9963 8192000000 10787046336 11215011840 1852816016 18.445 99 21 42 2 1864787360 6234608 5736736
23:18:28 8183 8192000000 10739395120 11161571328 1758349136 17.671 94 19 38 0 1769402208 6035376 5017696
23:18:44 54212 8192000000 10765497392 11185278976 1746560464 17.573 94 16 32 0 1756975024 5342864 5071696
23:19:49 15739 8192000000 10749244192 11172237312 1784004032 17.882 96 30 60 1 1798219792 5300944 8914816
23:20:12 6801 8192000000 10736484864 11149963264 1790695296 17.937 98 34 67 1 1807663168 6213888 10753984
23:20:25 5950 8192000000 10734136208 11144507392 1776949568 17.824 97 29 57 1 1791230688 5717744 8563376
23:20:37 5565 8192000000 10731556240 11150479360 1789819216 17.930 98 41 80 3 1808590960 8254768 10516976
23:20:51 4421 8192000000 10687831424 11095732224 1739960464 17.518 96 52 102 2 1761664512 6753344 14950704
23:21:03 5993 8192000000 10730091216 11144998912 1793740432 17.963 99 34 68 1 1810565792 6939424 9885936
23:21:16 4593 8192000000 10720995136 11136417792 1778739392 17.839 98 34 68 5 1795686048 6996912 9949744
23:21:27 8513 8192000000 10723944688 11142844416 1800880032 18.021 99 23 46 3 1814083552 6658608 6544912
23:21:42 9795 8192000000 10703622288 11110825984 1703069664 17.211 94 27 54 2 1715837008 4996400 7770944
23:21:58 11930 8192000000 10727518864 11135950848 1768603664 17.755 98 29 58 1 1782451712 4959968 8888080
23:22:16 9016 8192000000 10736314976 11146530816 1808517424 18.084 100 37 74 1 1825336880 4831728 11987728
23:22:32 8525 8192000000 10720424512 11135299584 1728944896 17.427 95 30 59 0 1743299088 5185792 9168400
23:22:50 8560 8192000000 10725134400 11148427264 1811119120 18.105 100 15 30 2 1821621872 5899600 4603152
23:23:05 12225 8192000000 10737831824 11161526272 1792493328 17.952 98 18 36 2 1803452464 5896288 5062848
23:23:29 15086 8192000000 10754685360 11174293504 1838139424 18.326 100 26 52 0 1852980992 6071536 8770032
23:23:59 64612 8192000000 10766306080 11184472064 1805616208 18.060 98 23 46 0 1821202400 9356352 6229840
23:25:11 7735 8192000000 10764324944 11191078912 1851065808 18.431 100 32 64 1 1866214960 6243472 8905680
23:25:25 6955 8192000000 10774556352 11196702720 1853108688 18.447 100 26 52 0 1866867920 6431344 7327888
23:25:39 9696 8192000000 10773132512 11203653632 1860627840 18.508 100 32 64 1 1877057616 7350592 9079184
23:25:55 9406 8192000000 10766606016 11202281472 1860031056 18.504 100 19 38 1 1871006944 5515680 5460208
23:26:13 10251 8192000000 10768149584 11201310720 1860260352 18.505 100 21 42 0 1872198096 5913056 6024688
23:26:30 12477 8192000000 10781380512 11210854400 1866669904 18.557 100 29 59 0 1881781392 6401760 8709728
23:26:50 10401 8192000000 10780279248 11212414976 1872157696 18.602 100 30 60 2 1886561968 5365040 9039232
23:27:08 8027 8192000000 10800597680 11229954048 1886019744 18.714 100 24 48 0 1898359328 5465168 6874416
23:27:23 29306 8192000000 10822544160 11239895040 1897550672 18.807 100 39 78 0 1915020112 5096528 12372912
23:28:07 4869 8192000000 10842716016 11254349824 1907217632 18.884 100 62 125 1 1934091312 8137584 18736096
23:28:23 12823 8192000000 10846653024 11261222912 1913767920 18.937 100 52 106 1 1937610224 8629232 15213072
23:28:44 46617 8192000000 10851958416 11273838592 1917293632 18.965 100 40 79 3 1936321472 7820688 11207152
23:29:38 35048 8192000000 10855907456 11280297984 1914465904 18.942 99 53 106 2 1937806688 7265600 16075184
23:30:25 16005 8192000000 10862567200 11292344320 1929488048 19.063 100 33 65 0 1947444832 8529968 9426816
23:30:48 9695 8192000000 10863203952 11293179904 1934740144 19.105 100 33 64 0 1950703456 7071248 8892064
23:31:09 15122 8192000000 10870707408 11300655104 1945250752 19.189 100 50 100 4 1967777648 8127472 14399424
23:31:31 12839 8192000000 10873446240 11306192896 1947966304 19.210 100 55 110 0 1973315600 9179904 16169392
23:31:50 2293 8192000000 10896313552 11314978816 1954802112 19.265 100 69 139 2 1985075472 10257408 20015952
23:32:00 14558 8192000000 10893614448 11318255616 1956804528 19.281 100 60 121 1 1984785552 11271936 16709088
23:32:23 8451 8192000000 10894124528 11319513088 1958220736 19.292 100 52 104 1 1984973232 11982960 14769536
23:32:40 37280 8192000000 10892360464 11326971904 1964198784 19.339 100 60 117 1 1991668848 10712176 16757888
23:33:30 2967 8192000000 10912184576 11337912320 1968698000 19.375 100 61 122 1 2001805744 15913136 17194608
23:33:41 2108 8192000000 10926086432 11331862528 1965546768 19.350 100 75 150 0 2005324624 17261824 22516032
23:33:49 1854 8192000000 10931351248 11336646656 1972560208 19.406 100 93 187 1 2019467536 19461920 27445408
23:33:58 1679 8192000000 10910823328 11326889984 1950044560 19.227 99 78 153 2 1991283344 18865216 22373568
23:34:06 1887 8192000000 10917832528 11336241152 1966031792 19.354 100 75 148 1 2009072576 21050496 21990288
23:34:16 7652 8192000000 10920760160 11328061440 1961083008 19.315 100 71 140 2 2001978640 21477024 19418608
23:34:33 8244 8192000000 10907189936 11335938048 1963777296 19.336 100 60 119 2 2003159152 22248320 17133536
23:34:52 5327 8192000000 10917481424 11340709888 1966630224 19.359 100 67 134 1 2008915920 22523152 19762544
23:35:10 12822 8192000000 10912505200 11342864384 1966151760 19.355 100 60 118 0 2001926928 18933024 16842144
23:35:42 48786 8192000000 10909115696 11348025344 1969797952 19.384 100 38 76 3 1997539920 16267360 11474608
23:36:43 21645 8192000000 10912961920 11356053504 1978106016 19.450 100 37 74 2 2007335728 17774608 11455104
23:37:19 19930 8192000000 10890953760 11336065024 1939796640 19.145 98 27 54 1 1965026112 16898544 8330928
23:37:46 7888 8192000000 10909021744 11348754432 1973276096 19.411 100 34 66 2 2000469744 16964800 10228848
23:38:04 8019 8192000000 10917310224 11351400448 1957287920 19.284 99 41 78 2 1987207248 17727488 12191840
23:38:22 7935 8192000000 10915304992 11349139456 1960085152 19.307 99 45 89 0 1990820544 17855344 12880048
23:38:46 7350 8192000000 10926114096 11359477760 1981765312 19.479 100 46 93 1 2014201520 18382800 14053408
23:39:00 6530 8192000000 10919954752 11354021888 1965690800 19.351 99 45 88 0 1998291600 18621136 13979664
23:39:14 6456 8192000000 10930112064 11357052928 1976742880 19.439 100 53 106 1 2012998928 19796672 16459376
23:39:35 3370 8192000000 10918058096 11339096064 1953238848 19.252 99 76 150 1 1997666112 21045120 23382144
23:39:47 18832 8192000000 10900186272 11331989504 1950224720 19.228 99 56 110 0 1989392832 21815264 17352848
23:40:18 6936 8192000000 10900693600 11318546432 1936106368 19.116 98 62 121 1 1978489136 23648192 18734576
23:40:33 6018 8192000000 10911964544 11337150464 1959940896 19.306 100 57 114 0 2002128416 24669872 17517648
23:40:52 7955 8192000000 10926333376 11353628672 1971079008 19.394 100 60 119 1 2015668736 25073600 19516128
23:41:08 16698 8192000000 10936106720 11367956480 1980532480 19.469 100 63 120 5 2027171040 28475616 18162944
23:41:32 12205 8192000000 10937617008 11383414784 1988204096 19.530 100 40 80 3 2031067568 29255040 13608432
23:41:51 4296 8192000000 10938191520 11361419264 1957734320 19.288 98 63 127 2 2005605792 28226768 19644704
23:42:03 7025 8192000000 10952330768 11378343936 1987665152 19.525 100 59 118 1 2035655776 29577376 18413248
23:42:17 5648 8192000000 10967661200 11388723200 1999523008 19.619 100 72 144 1 2052390112 31125504 21741600
23:42:34 4678 8192000000 10957072064 11382657024 1984714224 19.502 99 68 134 0 2035262016 30166512 20381280
23:42:52 7089 8192000000 10966894672 11389075456 1975820064 19.432 99 63 127 0 2026461952 30402480 20239408
23:43:09 4659 8192000000 10933774672 11354411008 1927728784 19.049 97 64 127 0 1981068224 33283312 20056128
23:43:23 5144 8192000000 10940150976 11366801408 1970100896 19.386 100 63 125 2 2024374608 34434224 19839488
23:43:35 4363 8192000000 10946926208 11370971136 1977207184 19.443 100 62 123 0 2031796080 35379568 19209328
23:43:47 4472 8192000000 10970418848 11385384960 1973550080 19.414 99 77 154 2 2035740240 38087184 24102976
23:43:59 4388 8192000000 10968921760 11388116992 1991763840 19.558 100 74 148 1 2054412176 39578944 23069392
23:44:11 1617 8192000000 10988957040 11396747264 2000765024 19.629 100 87 174 0 2065580640 38890944 25924672
23:44:19 4407 8192000000 10965666128 11386212352 1975836672 19.432 99 73 146 3 2037771344 39328368 22606304
23:44:34 4915 8192000000 10975627552 11389317120 1990333216 19.546 100 89 177 1 2057955200 40544448 27077536
23:44:51 2786 8192000000 10974956864 11390144512 1990728544 19.550 100 81 163 1 2057519808 41169088 25622176
23:45:01 1940 8192000000 10972431584 11383574528 1980649552 19.470 99 91 182 2 2052131504 42696160 28785792
23:45:12 3340 8192000000 10989080112 11407265792 2001856112 19.637 100 84 164 1 2071073024 43516416 25700496
23:45:22 3105 8192000000 10988194400 11405524992 2004027872 19.654 100 84 166 1 2073224688 43650000 25546816
23:45:34 3607 8192000000 10982741408 11406016512 2002512352 19.643 100 77 150 1 2070530544 43396528 24621664
23:45:46 3817 8192000000 10988460592 11405336576 2001382528 19.634 100 79 159 1 2069240880 43106672 24751680
23:45:58 4960 8192000000 10985104112 11397672960 1995878416 19.590 100 86 169 2 2065618576 43467264 26272896
23:46:11 2189 8192000000 10959134288 11369762816 1975122208 19.426 99 86 171 0 2045894784 43375152 27397424
23:46:20 5336 8192000000 10973457008 11387547648 1989687424 19.541 100 78 156 2 2055037168 41057600 24292144
23:46:32 2246 8192000000 10978663968 11388723200 1988321696 19.531 100 87 175 1 2056572656 41374192 26876768
23:46:41 3266 8192000000 10997602672 11404492800 2001670736 19.636 100 92 184 0 2073610752 44177440 27762576
23:46:52 5361 8192000000 10993387088 11401179136 1998505168 19.611 100 91 182 0 2073569920 46159600 28905152
23:47:04 1584 8192000000 10989684096 11397443584 1992410816 19.563 100 91 182 2 2068206320 47850208 27945296
23:47:13 2158 8192000000 10991227216 11401977856 1995289872 19.586 100 87 172 1 2069842240 47487232 27065136
23:47:22 3426 8192000000 10968861472 11386748928 1968092912 19.370 99 84 168 0 2042493744 48029680 26371152
23:47:35 5067 8192000000 10962729312 11381809152 1978154032 19.450 100 77 152 3 2050075232 47740000 24181200
23:47:47 1224 8192000000 10979546288 11393048576 1984928144 19.504 100 79 156 1 2057324384 47756640 24639600
23:47:57 3941 8192000000 10984524800 11400990720 1994132416 19.576 100 84 166 3 2068094960 48561104 25401440
23:48:08 8100 8192000000 10988464608 11408703488 1999182768 19.616 100 85 166 3 2073838736 49005456 25650512
23:48:24 2898 8192000000 10976280624 11389243392 1979051312 19.457 99 75 150 3 2049234240 46535424 23647504
23:48:34 2584 8192000000 10990604928 11406733312 1993937536 19.575 100 91 182 0 2071623744 49381216 28304992
23:48:44 4092 8192000000 10992933632 11404181504 1990526784 19.548 100 81 161 1 2066092720 50911712 24654224
23:48:56 1839 8192000000 10986244656 11400683520 1987048272 19.520 100 86 172 1 2067887936 52842096 27997568
23:49:06 2341 8192000000 10974726336 11384299520 1959328928 19.301 99 82 164 0 2037612032 52348000 25935104
23:49:17 1197 8192000000 10978078976 11391442944 1979739504 19.463 100 81 163 2 2059750080 53489168 26521408
23:49:25 8363 8192000000 10945337248 11390148608 1971500256 19.397 100 63 124 3 2047889456 56087408 20301792
23:49:49 12628 8192000000 10930301008 11366481920 1929949296 19.066 98 46 92 3 1992024080 47151328 14923456
23:50:09 10471 8192000000 10938930656 11376308224 1962532112 19.326 100 42 84 0 2024033408 47713216 13788080
23:50:41 7655 8192000000 10936896000 11376717824 1957898736 19.289 100 40 79 2 2019506592 47819184 13788672
23:50:56 8636 8192000000 10928966816 11362164736 1941263888 19.157 99 45 90 0 2001375776 45274464 14837424
23:51:12 9299 8192000000 10938370832 11368697856 1955440912 19.270 100 51 103 0 2020104256 47632864 17030480
23:51:30 6800 8192000000 10936868016 11371315200 1950985120 19.234 100 41 82 0 2015614464 50856016 13773328
23:51:44 8024 8192000000 10939153776 11377192960 1956376640 19.277 100 35 71 1 2024221264 55461440 12383184
23:52:02 16323 8192000000 10943305856 11387400192 1961841488 19.321 100 31 62 3 2027437104 54497536 11098080
23:52:26 7551 8192000000 10945080608 11382943744 1946749392 19.201 99 44 86 3 2014982752 53629392 14603968
23:52:41 25814 8192000000 10930500656 11388026880 1963320192 19.332 100 33 66 1 2027477680 52748800 11408688
23:53:25 20061 8192000000 10921479648 11358240768 1935862864 19.114 99 31 62 0 1992784992 45565216 11356912
23:54:08 17587 8192000000 10920343552 11353395200 1933682528 19.096 99 47 94 0 1999086368 50031824 15372016
23:54:43 16984 8192000000 10908905872 11361202176 1935433568 19.110 100 27 52 1 1991391280 46392208 9565504
23:55:06 25946 8192000000 10912609632 11368906752 1944886944 19.186 100 21 42 1 1997328592 44992832 7448816
23:55:40 30037 8192000000 10901985104 11375230976 1933853344 19.098 99 21 42 2 1984032336 43018384 7160608
23:56:54 34256 8192000000 10882751488 11356434432 1915457952 18.950 98 9 18 0 1941566096 23693296 2414848
23:57:34 86520 8192000000 10920114928 11358859264 1936848560 19.122 98 15 30 1 1952979328 12422800 3707968
23:59:09 7895 8192000000 10910591584 11355537408 1952575040 19.247 99 51 104 1 1980437648 14197584 13665024
23:59:24 48223 8192000000 10903927584 11371249664 1961805200 19.320 100 10 20 1 1973975120 9713584 2456336
00:00:18 61138 8192000000 10903811904 11380621312 1965406288 19.349 99 20 41 0 1983114912 12309952 5398672
00:01:26 62735 8192000000 10914155856 11359764480 1958103472 19.291 99 26 52 1 1977000608 11596896 7300240
00:02:37 42682 8192000000 10922827264 11383005184 1987675872 19.525 100 45 91 0 2011247968 10723440 12848656
00:04:42 112135 8192000000 10885705664 11345006592 1897871600 18.809 95 18 36 1 1918342048 15338272 5132176
00:06:40 159785 8192000000 10886902528 11358941184 1886610432 18.718 96 9 18 0 1902251328 12936160 2704736
00:09:42 18509 8192000000 10908950288 11362955264 1958524720 19.294 99 18 36 1 1975463488 10701248 6237520
00:10:14 48309 8192000000 10892727056 11344031744 1910588048 18.911 97 32 64 2 1938656976 18473984 9594944
00:11:37 81651 8192000000 10902263408 11369152512 1960490320 19.310 100 14 28 1 1976442512 11759440 4192752
00:13:07 60855 8192000000 10895894528 11370668032 1956129024 19.275 99 5 10 0 1969249776 11918224 1202528
00:14:14 53178 8192000000 10908133056 11379605504 1978744960 19.455 100 8 16 1 1991511472 10410432 2356080
00:15:14 62830 8192000000 10923784784 11399548928 1993776576 19.574 100 17 33 1 2011566080 12682496 5107008
00:16:56 31393 8192000000 10927432016 11397689344 1994496192 19.579 100 21 40 1 2014943936 14447728 6000016
00:17:36 31812 8192000000 10911726720 11404980224 1992001440 19.560 100 16 32 1 2012852992 16207136 4644416
00:19:00 56490 8192000000 10921934224 11399262208 1998936816 19.614 100 33 66 1 2019027168 10791728 9298624
00:20:03 46429 8192000000 10896677216 11389669376 1956027200 19.274 98 8 16 0 1966923056 8858576 2037280
00:20:58 65875 8192000000 10901238368 11380518912 1913570128 18.935 96 8 16 0 1922442432 6925392 1946912
00:22:14 55603 8192000000 10906869744 11396374528 1970914624 19.393 99 15 28 2 1988097840 12657200 4526016
00:23:17 62195 8192000000 10945207824 11397414912 1979293152 19.459 99 25 50 0 1996583712 10466656 6823904
00:24:31 47329 8192000000 10921779552 11391909888 1962465072 19.326 98 22 42 1 1984088848 14925904 6697872
00:25:24 53474 8192000000 10928350656 11402153984 1988388352 19.531 100 20 40 1 2006035904 11737264 5910288
00:26:25 49449 8192000000 10923538656 11393560576 1951297648 19.237 98 9 18 0 1970438880 16465456 2675776
00:27:20 67526 8192000000 10901524032 11385790464 1914026384 18.939 96 11 21 3 1933460896 16489904 2944608
00:28:40 86594 8192000000 10900828448 11364892672 1881506928 18.677 95 10 20 0 1892218336 8654416 2056992
00:30:13 64941 8192000000 10893978960 11366092800 1918750256 18.977 97 20 40 0 1934793072 10591408 5451408
00:31:24 50015 8192000000 10891046544 11359518720 1876280368 18.635 95 12 24 3 1890993664 10851824 3861472
00:32:29 88025 8192000000 10878425872 11326500864 1810496480 18.100 92 30 60 2 1834028864 15078432 8453952
00:34:05 46393 8192000000 10873769792 11328458752 1875388080 18.628 97 55 110 2 1906767392 14270688 17108624
00:35:05 97087 8192000000 10837292768 11297882112 1892390176 18.765 99 29 58 2 1915597600 14927824 8279600
00:37:00 26761 8192000000 10843422000 11296710656 1908674624 18.896 99 34 67 0 1926598192 8809712 9113856
00:37:51 23108 8192000000 10844746736 11300945920 1877270128 18.643 97 40 76 2 1898076608 9832448 10974032
00:38:25 50990 8192000000 10811617360 11282915328 1870788800 18.591 97 24 48 2 1886260960 7724544 7747616
00:39:40 55082 8192000000 10834411440 11312496640 1901772640 18.841 99 9 18 0 1911989184 7899168 2317376
00:41:16 61489 8192000000 10850740528 11322413056 1885853456 18.712 98 16 33 0 1900766944 10546736 4366752
00:42:24 82894 8192000000 10854693088 11325837312 1912901648 18.930 99 17 34 0 1931470336 13844560 4724128
00:44:01 68895 8192000000 10837697680 11312230400 1889867376 18.745 98 10 20 0 1907360064 14409984 3082704
00:45:16 65423 8192000000 10864587584 11340894208 1939151632 19.140 100 20 40 0 1954775792 9918144 5706016
00:46:28 42696 8192000000 10865914048 11330945024 1873269824 18.611 96 18 36 0 1890441472 12126704 5044944
00:49:05 46119 8192000000 10873377408 11329331200 1934182176 19.100 100 16 32 0 1948805040 10136848 4486016
00:50:02 27127 8192000000 10863245440 11321397248 1887433600 18.725 97 43 87 0 1909560144 10248144 11878400
00:50:46 24490 8192000000 10883899712 11335548928 1924223648 19.021 99 42 82 1 1946974736 11604016 11147072
00:51:26 21143 8192000000 10893451408 11343450112 1950100800 19.227 100 50 100 0 1977040976 12805472 14134704
00:51:58 39073 8192000000 10888913376 11360419840 1952336464 19.245 100 38 76 2 1975905200 12511968 11056768
00:52:53 88730 8192000000 10866490816 11338371072 1839715456 18.338 94 19 38 0 1855742288 10962032 5064800
00:54:28 52129 8192000000 10873996384 11335241728 1933097920 19.092 100 27 54 2 1955665744 14849264 7718560
00:55:30 17255 8192000000 10875199728 11328823296 1924377280 19.022 99 30 60 1 1940981696 7874368 8730048
00:55:55 18922 8192000000 10893690416 11341598720 1925095456 19.028 99 49 98 1 1950083728 11406544 13581728
00:56:23 87795 8192000000 10886396704 11344896000 1928934128 19.058 99 49 98 2 1958642448 15523888 14184432
00:57:57 48792 8192000000 10887410976 11355406336 1937372864 19.126 99 26 52 2 1955842016 11990544 6478608
00:58:52 30556 8192000000 10899054144 11356626944 1943808464 19.177 99 37 74 0 1970793888 16128768 10856656
00:59:29 34227 8192000000 10883855632 11362603008 1961315568 19.316 100 21 42 0 1984169744 17260816 5593360
01:02:25 77127 8192000000 10881388656 11358052352 1939974528 19.147 99 14 28 0 1955211584 10740480 4496576
01:04:17 59162 8192000000 10899038752 11378487296 1973501312 19.413 100 15 30 2 1988422432 10287040 4634080
01:05:30 56169 8192000000 10891747264 11358527488 1943029840 19.171 98 29 57 0 1960640224 9247776 8362608
01:06:34 65353 8192000000 10880205760 11348459520 1900592784 18.831 97 21 42 1 1920064032 13572112 5899136
01:07:46 57168 8192000000 10870083952 11347456000 1907293728 18.885 98 16 32 0 1920856304 9301856 4260720
01:08:55 48329 8192000000 10905441264 11368275968 1929730560 19.065 98 25 50 0 1952978640 16185632 7062448
01:10:13 82226 8192000000 10871865696 11355402240 1879507488 18.661 96 6 12 1 1903582624 21941936 2133200
01:11:43 112686 8192000000 10872880240 11328663552 1826601488 18.232 93 14 28 0 1841625856 11292400 3731968
01:13:47 93737 8192000000 10922857184 11380625408 1927534080 19.047 99 27 54 0 1948680784 13676080 7470624
01:15:29 93611 8192000000 10886952672 11379433472 1960866512 19.313 100 10 20 0 1984647856 20977744 2803600
01:17:10 117111 8192000000 10869004912 11338547200 1872644080 18.606 95 17 32 1 1887100336 10075040 4381216
01:19:22 42713 8192000000 10853914928 11326492672 1900452480 18.830 97 27 53 0 1920400448 12959296 6988672
01:20:20 47040 8192000000 10860866064 11354611712 1947538352 19.207 100 8 16 1 1960201968 10255152 2408464
01:21:13 76026 8192000000 10851207264 11335274496 1874170896 18.618 96 6 12 0 1882652000 7204768 1276336
01:22:51 42702 8192000000 10873528992 11356999680 1950791568 19.233 100 21 42 2 1964035664 7126800 6117296
01:23:40 43041 8192000000 10880906448 11365523456 1939698080 19.144 99 11 22 1 1954011568 11149184 3164304
01:24:30 72343 8192000000 10856033872 11348242432 1912529568 18.927 98 14 28 1 1934394928 17490144 4375216
01:26:07 37608 8192000000 10856610512 11355869184 1931758416 19.081 100 11 22 0 1954744752 19570320 3416016
01:26:55 37178 8192000000 9645702464 9990733824 764176848 8.532 40 1 2 0 770058400 5819424 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 24-03-2021 01:29:13 to 24-03-2021 01:29:45.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 111 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-03-2021 01:29:46 to 24-03-2021 01:29:48.

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          239223
MON$OLDEST_ACTIVE               239224
MON$OLDEST_SNAPSHOT             239224
MON$NEXT_TRANSACTION            239224
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                       2035808
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:193: 
:194: mscs-test-161.budzdorov.ru    Wed Mar 24 01:27:34 2021
:195:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:196: 
:197: 
:198: mscs-test-161.budzdorov.ru    Wed Mar 24 01:27:36 2021
:199:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:200: 
:201: 
:202: mscs-test-161.budzdorov.ru    Wed Mar 24 01:27:36 2021
:203:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:204: 
:205: 
:206: mscs-test-161.budzdorov.ru    Wed Mar 24 01:27:36 2021
:207:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:208: 
--- end of diff output ---

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

24.03.21 01:29:49. 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-03-24 01:29:51 No severe PSQL-related problems occured
24.03.21 01:29:52. End of report.