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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-29 01:27:17
DTS_END                         2021-01-29 01:27:17.5120
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47408
TRN_ID                          240357
ATT_ID                          670
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: 9375.37 20690 1125044
customer order: creation 172.18 349 20662
customer order: refuse 15.14 371 1817
order to supplier: creation 45.91 1290 5509
order to supplier: removal 3.50 105016 420
invoice (draft): creation 47.11 3693 5653
invoice (draft): removal 52.98 774 6357
invoice accept: apply 42.04 18290 5045
invoice accept: cancel 48.64 913 5837
customer reserve: creation 3885.18 180 466221
customer reserve: removal 4753.10 60 570372
realization accept: apply 85.88 190 10305
realization accept: cancel 90.36 115 10843
payment from customer: creation 60.63 144 7275
payment from customer: removal 6.11 80 733
payment to supplier: creation 51.13 157 6135
payment to supplier: removal 3.50 91 420
service: total inventory turnovers 4.58 1299 549
service: total monetary turnovers 6.67 31 800
service: aggregate perf. data 0.73 22062 87
service: refresh index statistics 0.03 258704 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-01-2021 01:28:40 to 29-01-2021 01:28:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5266
TEST_TIME 2 5027
TEST_TIME 3 4449
TEST_TIME 4 5113
TEST_TIME 5 5204
TEST_TIME 6 5304
TEST_TIME 7 5048
TEST_TIME 8 5368
TEST_TIME 9 5772
TEST_TIME 10 5658
TEST_TIME 11 5787
TEST_TIME 12 5719
TEST_TIME 13 6365
TEST_TIME 14 6394
TEST_TIME 15 6886
TEST_TIME 16 7587
TEST_TIME 17 7542
TEST_TIME 18 7980
TEST_TIME 19 8160
TEST_TIME 20 8197
TEST_TIME 21 8176
TEST_TIME 22 8287
TEST_TIME 23 8263
TEST_TIME 24 8598
TEST_TIME 25 8865
TEST_TIME 26 9028
TEST_TIME 27 9259
TEST_TIME 28 9357
TEST_TIME 29 9139
TEST_TIME 30 9976
TEST_TIME 31 10144
TEST_TIME 32 10753
TEST_TIME 33 10656
TEST_TIME 34 10678
TEST_TIME 35 10562
TEST_TIME 36 10488
TEST_TIME 37 10414
TEST_TIME 38 10384
TEST_TIME 39 10546
TEST_TIME 40 10455
TEST_TIME 41 10285
TEST_TIME 42 10316
TEST_TIME 43 10290
TEST_TIME 44 10204
TEST_TIME 45 9996
TEST_TIME 46 9903
TEST_TIME 47 10062
TEST_TIME 48 9940
TEST_TIME 49 9924
TEST_TIME 50 9889
TEST_TIME 51 9870
TEST_TIME 52 9877
TEST_TIME 53 9895
TEST_TIME 54 9931
TEST_TIME 55 9824
TEST_TIME 56 9741
TEST_TIME 57 9776
TEST_TIME 58 9678
TEST_TIME 59 9548
TEST_TIME 60 9573
TEST_TIME 61 9520
TEST_TIME 62 9493
TEST_TIME 63 9525
TEST_TIME 64 9490
TEST_TIME 65 9456
TEST_TIME 66 9591
TEST_TIME 67 9653
TEST_TIME 68 9606
TEST_TIME 69 9605
TEST_TIME 70 9770
TEST_TIME 71 9708
TEST_TIME 72 9685
TEST_TIME 73 9717
TEST_TIME 74 9774
TEST_TIME 75 9827
TEST_TIME 76 9794
TEST_TIME 77 9684
TEST_TIME 78 9718
TEST_TIME 79 9740
TEST_TIME 80 9654
TEST_TIME 81 9631
TEST_TIME 82 9580
TEST_TIME 83 9630
TEST_TIME 84 9597
TEST_TIME 85 9523
TEST_TIME 86 9510
TEST_TIME 87 9459
TEST_TIME 88 9476
TEST_TIME 89 9491
TEST_TIME 90 9501
TEST_TIME 91 9476
TEST_TIME 92 9533
TEST_TIME 93 9547
TEST_TIME 94 9583
TEST_TIME 95 9593
TEST_TIME 96 9627
TEST_TIME 97 9595
TEST_TIME 98 9685
TEST_TIME 99 9665
TEST_TIME 100 9726
TEST_TIME 101 9720
TEST_TIME 102 9718
TEST_TIME 103 9781
TEST_TIME 104 9695
TEST_TIME 105 9662
TEST_TIME 106 9617
TEST_TIME 107 9603
TEST_TIME 108 9613
TEST_TIME 109 9567
TEST_TIME 110 9520
TEST_TIME 111 9532
TEST_TIME 112 9490
TEST_TIME 113 9473
TEST_TIME 114 9446
TEST_TIME 115 9445
TEST_TIME 116 9427
TEST_TIME 117 9403
TEST_TIME 118 9400
TEST_TIME 119 9408
TEST_TIME 120 9377

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 29-01-2021 01:28:43 to 29-01-2021 01:28:47.

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 1557727 1557727 0 0.00 0 18782 6 0 0
doc_list_biud 1557727 1557727 0 0.00 0 36037 28 0 0
sp_add_invoice_to_stock 5202 5045 157 3.01 41 179305 18291 0 157
sp_cancel_adding_invoice 5837 5837 0 0.00 4 68821 914 0 0
sp_cancel_client_order 1817 1817 0 0.00 4 10006 372 0 0
sp_cancel_customer_reserve 570372 570372 0 0.00 1 21812 60 0 0
sp_cancel_pay_from_customer 733 733 0 0.00 3 5539 80 0 0
sp_cancel_pay_to_supplier 420 420 0 0.00 3 4454 92 0 0
sp_cancel_supplier_invoice 6371 6357 14 0.21 2 33313 774 0 14
sp_cancel_supplier_order 420 420 0 0.00 9 1045184 105017 0 0
sp_cancel_write_off 10843 10843 0 0.00 1 36079 115 0 0
sp_client_order 20662 20662 0 0.00 4 40882 349 0 0
sp_customer_reserve 466221 466221 0 0.00 0 104104 180 0 0
sp_fill_shopping_cart 31805 31805 0 0.00 1 29810 38 0 0
sp_fill_shopping_cart_clo_res 466220 466220 0 0.00 0 16632 13 0 0
sp_get_clo_for_invoice 5044 5044 0 0.00 0 28442 309 0 0
sp_kill_cost_storno 17833 17833 0 0.00 0 8382 57 0 0
sp_kill_qstorno_ret_qs2qd 1158364 1158364 0 0.00 0 36035 33 0 0
sp_kill_qty_storno 610995 610995 0 0.00 0 36037 72 0 0
sp_lock_selected_doc 21301 21301 0 0.00 0 9665 7 0 0
sp_make_cost_storno 28759 28759 0 0.00 0 15815 63 0 0
sp_multiply_rows_for_pdistr 28759 28759 0 0.00 0 18777 33 0 0
sp_multiply_rows_for_qdistr 20662 20662 0 0.00 0 24220 146 0 0
sp_pay_from_customer 7275 7275 0 0.00 4 18787 144 0 0
sp_pay_to_supplier 6135 6135 0 0.00 4 16994 158 0 0
sp_payment_common 13410 13410 0 0.00 1 16929 39 0 0
sp_qd_handle_on_cancel_clo 1817 1817 0 0.00 0 10000 349 0 0
sp_qd_handle_on_invoice_upd_sts 10881 10881 0 0.00 0 29314 397 0 0
sp_qd_handle_on_reserve_upd_sts 10305 10305 0 0.00 0 20203 65 0 0
sp_reserve_write_off 10305 10305 0 0.00 7 20311 191 0 0
sp_supplier_invoice 5653 5653 0 0.00 6 85395 3694 0 0
sp_supplier_order 5509 5509 0 0.00 5 31569 1291 0 0
srv_aggregate_perf_data 88 87 1 1.13 1907 158259 22062 0 1
srv_fill_mon_cache_memory 179 179 0 0.00 1230 151811 30079 0 0
srv_find_qd_qs_mism 1077088 1077088 0 0.00 0 7685 5 0 0
srv_make_invnt_saldo 549 549 0 0.00 39 79380 1299 0 0
srv_make_money_saldo 800 800 0 0.00 0 1201 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 88778 523751 258704 0 0
t$perf-abend:sp_add_invoice_to_stock 157 157 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 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 5045 5045 0 0.00 0 12793 173 0 0
t$perf-norm:sp_cancel_adding_invoice 455 455 0 0.00 0 4674 102 0 0
t$perf-norm:sp_cancel_client_order 1817 1817 0 0.00 0 6523 13 0 0
t$perf-norm:sp_cancel_customer_reserve 691 691 0 0.00 0 1187 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 733 733 0 0.00 0 4441 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 420 420 0 0.00 0 2045 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 398 398 0 0.00 0 1053 21 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 28420 1570 0 0
t$perf-norm:sp_cancel_write_off 1018 1018 0 0.00 0 10451 20 0 0
t$perf-norm:sp_client_order 20662 20662 0 0.00 0 6866 18 0 0
t$perf-norm:sp_customer_reserve 1035 1035 0 0.00 0 2962 15 0 0
t$perf-norm:sp_pay_from_customer 7275 7275 0 0.00 0 6264 12 0 0
t$perf-norm:sp_pay_to_supplier 6136 6136 0 0.00 0 3936 12 0 0
t$perf-norm:sp_reserve_write_off 10305 10305 0 0.00 0 7993 12 0 0
t$perf-norm:sp_supplier_invoice 5654 5654 0 0.00 0 6429 18 0 0
t$perf-norm:sp_supplier_order 5509 5509 0 0.00 0 6512 20 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 395 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 179 179 0 0.00 0 2641 20 0 0
t$perf-norm:srv_make_invnt_saldo 549 549 0 0.00 0 1060 26 0 0
t$perf-norm:srv_make_money_saldo 800 800 0 0.00 0 909 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 7 3 0 0
v_add_invoice_to_stock 10400 10086 314 3.01 0 6896 19 0 314
v_all_customers 37336 37336 0 0.00 0 28 1 0 0
v_all_suppliers 31380 31380 0 0.00 0 18 1 0 0
v_all_wares 41324 41324 0 0.00 0 84 1 0 0
v_cancel_adding_invoice 910 910 0 0.00 0 4039 12 0 0
v_cancel_client_order 3634 3634 0 0.00 0 1901 4 0 0
v_cancel_customer_prepayment 1466 1466 0 0.00 0 3043 5 0 0
v_cancel_customer_reserve 1382 1382 0 0.00 0 4128 6 0 0
v_cancel_payment_to_supplier 840 840 0 0.00 0 4005 16 0 0
v_cancel_supplier_invoice 824 796 28 3.39 0 9727 25 0 28
v_cancel_supplier_order 840 840 0 0.00 0 271 3 0 0
v_cancel_write_off 2036 2036 0 0.00 0 6471 20 0 0
v_max_id_clo_ord 5505 5505 0 0.00 0 1523 2 0 0
v_max_id_clo_res 1035 1035 0 0.00 0 2099 8 0 0
v_max_id_ord_sup 5638 5638 0 0.00 0 7532 7 0 0
v_max_non_paid_invoice 1588 1588 0 0.00 0 1298 3 0 0
v_max_non_paid_realizn 3866 3866 0 0.00 0 2820 4 0 0
v_min_id_clo_ord 5505 5505 0 0.00 0 7888 9 0 0
v_min_id_clo_res 1035 1035 0 0.00 0 5667 13 0 0
v_min_id_ord_sup 5638 5638 0 0.00 0 6980 7 0 0
v_min_non_paid_invoice 6135 6135 0 0.00 0 7383 24 0 0
v_min_non_paid_realizn 7275 7275 0 0.00 0 11070 25 0 0
v_our_firm 10806 10806 0 0.00 0 21 1 0 0
v_reserve_write_off 20610 20610 0 0.00 0 7072 6 0 0
x_lock_depdocs_on_canc_invoice 11796 11796 0 0.00 0 11157 115 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 3554 330 0 0
x_make_qstorno_1000_1200 5509 5509 0 0.00 2 31559 1200 0 0
x_make_qstorno_1200_2000 5653 5653 0 0.00 3 80063 3569 0 0
x_make_qstorno_2100_3300 466221 466221 0 0.00 0 104053 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-01-2021 01:28:48 to 29-01-2021 01:28:52.

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:21 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:27 20340 8192000000 10235365472 10552750080 929173216 10.186 72 52 105 0 949145152 2569120 17402816
22:58:01 37709 8192000000 10365063904 10687709184 1393819008 14.540 100 84 168 0 1426416736 4786784 27810944
22:58:45 16742 8192000000 10399465760 10722275328 1451045920 15.047 100 88 177 0 1485790816 6204720 28540176
22:59:10 30125 8192000000 10431107312 10759192576 1475303280 15.260 100 83 166 1 1509359776 7223952 26832544
22:59:50 23067 8192000000 10445235248 10775429120 1501191520 15.487 100 95 190 0 1539923568 8053664 30678384
23:00:27 17845 8192000000 10458544560 10796527616 1512144896 15.582 100 85 170 1 1547961280 8584144 27232240
23:00:57 8578 8192000000 10483798944 10823880704 1537333968 15.801 100 86 172 2 1573625840 9187328 27104544
23:01:13 20745 8192000000 10504627728 10848444416 1557673008 15.976 100 82 162 1 1592451072 9459968 25318096
23:01:47 5062 8192000000 10520310800 10869276672 1575678768 16.131 100 80 160 1 1609978896 9690752 24609376
23:02:08 15937 8192000000 10555317168 10910703616 1608903440 16.415 100 78 154 1 1642236752 10247920 23085392
23:02:38 13038 8192000000 10583818480 10941648896 1639232272 16.673 100 77 154 0 1672878800 10822576 22823952
23:03:04 13119 8192000000 10594070448 10957299712 1653432768 16.793 100 79 158 2 1688460048 11379856 23647424
23:03:25 13750 8192000000 10619146928 10983620608 1671693248 16.947 100 81 163 2 1707569040 11917248 23958544
23:03:49 10424 8192000000 10632851536 10998738944 1689960736 17.101 100 79 158 0 1726412640 13596992 22854912
23:04:09 6371 8192000000 10644738832 11012091904 1700611392 17.190 100 79 160 2 1736796752 13076288 23109072
23:04:29 6393 8192000000 10654386688 11027001344 1712091328 17.286 100 76 152 0 1746984192 12988560 21904304
23:04:43 8148 8192000000 10666939024 11040153600 1727857776 17.418 100 76 151 0 1762027568 12378336 21791456
23:04:58 5073 8192000000 10677485360 11054137344 1742997600 17.544 100 77 153 2 1776856128 12550368 21308160
23:05:13 5711 8192000000 10690927136 11069464576 1754303792 17.637 100 85 169 0 1790169504 12576656 23289056
23:05:26 6396 8192000000 10696051424 11077128192 1759074224 17.677 100 81 159 1 1794981312 12940592 22966496
23:05:41 3499 8192000000 10711316752 11094634496 1766043840 17.734 100 69 138 1 1798435328 13049264 19342224
23:05:51 3789 8192000000 10708935712 11095425024 1777440064 17.828 100 78 156 0 1812889488 13265200 22184224
23:06:02 5096 8192000000 10723069472 11109953536 1785667264 17.896 100 72 144 0 1818098816 12716704 19714848
23:06:14 3120 8192000000 10735489680 11116490752 1793962816 17.964 100 78 152 3 1828468624 12520704 21985104
23:06:23 3293 8192000000 10743095536 11124506624 1805358432 18.058 100 89 177 0 1842911664 13045856 24507376
23:06:42 4712 8192000000 10746658912 11133198336 1810109808 18.097 100 78 153 3 1845068320 14089648 20868864
23:06:54 2148 8192000000 10770357424 11152977920 1823836256 18.209 100 87 175 1 1863265040 14820048 24608736
23:07:02 2602 8192000000 10769221008 11158994944 1831952352 18.275 100 88 176 1 1870066640 13530816 24583472
23:07:11 3792 8192000000 10772427536 11166212096 1834784528 18.298 100 90 178 1 1873392112 13747056 24860528
23:07:21 2377 8192000000 10785671376 11168006144 1837642016 18.322 100 79 158 1 1876568624 17278128 21648480
23:07:30 2424 8192000000 10788837920 11176374272 1846273024 18.392 100 91 182 1 1885883104 14143696 25466384
23:07:39 1362 8192000000 10798567264 11186270208 1854782752 18.461 100 92 184 0 1898060864 18041504 25236608
23:07:48 2315 8192000000 10798278288 11187740672 1852574960 18.443 100 90 181 1 1892981904 14059984 26346960
23:07:56 1910 8192000000 10799103392 11186073600 1855164688 18.464 100 88 176 0 1891911536 11841488 24905360
23:08:05 2341 8192000000 10812463184 11199680512 1862244256 18.521 100 88 176 2 1904063344 17032784 24786304
23:08:14 2598 8192000000 10812434400 11200438272 1864168832 18.537 100 88 174 0 1903348512 14225376 24954304
23:08:23 1389 8192000000 10808934304 11195260928 1865323856 18.546 100 93 186 0 1905823600 14365776 26133968
23:08:31 2877 8192000000 10817637120 11205701632 1870374800 18.587 100 93 186 4 1910510672 13308736 26827136
23:08:42 1949 8192000000 10807131104 11205210112 1872777456 18.607 100 84 169 0 1909672800 12948656 23946688
23:08:50 1448 8192000000 10820736720 11213524992 1878696080 18.655 100 86 168 1 1915674304 12558032 24420192
23:08:58 3032 8192000000 10796112928 11210932224 1878584736 18.654 100 58 116 0 1907056048 12827184 15644128
23:09:09 3060 8192000000 10799725200 11217195008 1878259952 18.651 100 53 104 3 1908041712 15596736 14185024
23:09:19 2742 8192000000 10787590432 11209605120 1879450144 18.661 100 49 94 3 1901576304 8626464 13499696
23:09:28 8002 8192000000 10791747408 11216318464 1880697408 18.671 100 47 94 3 1902176224 8021472 13457344
23:09:49 23009 8192000000 10814031968 11222110208 1887838272 18.728 100 68 136 0 1913756944 6368656 19550016
23:10:19 12790 8192000000 10822466256 11233153024 1893161360 18.771 100 59 113 0 1917975952 9589856 15224736
23:10:39 2746 8192000000 10817556720 11234807808 1891236576 18.756 100 52 104 0 1916175984 10744192 14195216
23:10:51 4716 8192000000 10808646576 11225980928 1890367008 18.749 100 41 81 1 1910839456 8594496 11877952
23:11:02 6602 8192000000 10812939168 11235241984 1892395136 18.765 100 28 56 1 1907658384 7482160 7781088
23:11:16 3898 8192000000 10805903456 11233255424 1896199904 18.796 100 42 85 2 1915938320 7285888 12452528
23:11:26 4379 8192000000 10814112432 11242504192 1898055840 18.811 100 46 92 1 1922869984 10769552 14044592
23:11:36 8731 8192000000 10811920544 11235622912 1893759840 18.776 100 20 40 3 1904573216 5378272 5435104
23:11:51 6264 8192000000 10810825184 11236700160 1897488192 18.806 100 26 52 1 1912136272 6327792 8320288
23:12:06 7528 8192000000 10807394576 11238477824 1897643344 18.807 100 23 46 2 1910783616 6612048 6528224
23:12:20 8856 8192000000 10797273296 11233792000 1897249264 18.804 100 21 42 1 1909127600 5135536 6742800
23:12:35 11854 8192000000 10807426576 11239952384 1897980160 18.810 100 19 38 2 1909023632 5739600 5303872
23:12:54 12636 8192000000 10799944624 11242745856 1898754048 18.816 100 15 30 3 1908916880 5780560 4382272
23:13:15 8421 8192000000 10823304160 11253846016 1905512640 18.871 100 17 34 1 1916026304 6094416 4419248
23:13:30 11430 8192000000 10840653952 11249287168 1913326176 18.933 100 30 59 3 1927409024 5901552 8181296
23:13:49 29983 8192000000 10812464368 11259465728 1910667600 18.912 100 14 28 0 1920380160 5330704 4381856
23:14:55 28289 8192000000 10830414720 11269476352 1914690432 18.944 100 14 28 0 1923332368 4713216 3928720
23:15:30 10061 8192000000 10826280784 11271467008 1917975152 18.971 100 23 45 2 1930337104 5590608 6771344
23:15:46 7579 8192000000 10855672576 11283193856 1925214496 19.029 100 28 56 2 1943286560 9847888 8224176
23:16:02 6836 8192000000 10849999776 11282182144 1921514656 18.999 100 19 38 1 1936497712 9683328 5299728
23:16:16 5218 8192000000 10831093088 11269468160 1919125488 18.980 100 27 55 1 1933283968 5841920 8316560
23:16:28 8975 8192000000 10831102256 11268845568 1914569088 18.943 100 20 40 0 1926190000 6032064 5588848
23:16:44 4895 8192000000 10831984208 11268542464 1912981728 18.931 100 16 32 1 1927463520 10170048 4311744
23:16:55 8708 8192000000 10803342096 11237761024 1879773216 18.663 99 19 39 0 1891771136 6362448 5635472
23:17:12 5864 8192000000 10815646784 11245080576 1896298624 18.797 100 24 48 0 1909628096 6077632 7251840
23:17:30 5481 8192000000 10776973760 11201089536 1850063776 18.423 98 12 24 0 1859019024 5442096 3513152
23:17:46 7119 8192000000 10776616320 11210924032 1840604560 18.346 98 34 68 2 1861540832 11660864 9275408
23:18:05 9713 8192000000 10775313856 11199393792 1828447248 18.247 98 20 40 1 1839908768 5669696 5791824
23:18:23 6412 8192000000 10763639312 11186704384 1805160800 18.056 97 17 34 2 1814653552 5219072 4273680
23:18:42 8186 8192000000 10761462080 11182628864 1819806960 18.176 99 24 46 1 1833573120 6192576 7573584
23:18:56 16668 8192000000 10720856496 11109834752 1689799392 17.100 92 35 70 2 1706189408 4674896 11715120
23:19:19 70962 8192000000 10708455040 11137794048 1724056336 17.386 95 25 49 0 1737117456 5851216 7209904
23:20:37 9910 8192000000 10677859360 11098238976 1676626224 16.989 93 20 41 2 1688005744 5672480 5707040
23:20:53 5251 8192000000 10703288448 11116003328 1757303072 17.662 98 32 64 2 1775927088 10563904 8060112
23:21:06 4345 8192000000 10723837360 11132366848 1797608352 17.994 100 47 94 2 1819353392 8241792 13503248
23:21:22 5963 8192000000 10739303200 11156082688 1818434240 18.165 100 43 86 2 1838929888 8010288 12485360
23:21:34 4369 8192000000 10754972560 11162648576 1825187408 18.220 100 41 80 2 1842493104 6341456 10964240
23:21:45 6838 8192000000 10716470672 11139362816 1791401328 17.943 99 39 78 3 1810279824 7934816 10943680
23:22:01 5605 8192000000 10707846560 11117715456 1760044784 17.685 98 40 80 2 1778026336 6409040 11572512
23:22:14 5763 8192000000 10716363024 11129069568 1772569568 17.788 98 28 56 0 1786829568 5844496 8415504
23:22:25 6039 8192000000 10717521600 11134697472 1783354496 17.877 99 28 55 2 1796790912 5703056 7733360
23:22:37 4525 8192000000 10724926208 11138580480 1802038960 18.031 100 16 32 1 1813120960 6055920 5026080
23:22:48 12491 8192000000 10742318752 11160887296 1823743632 18.208 100 19 38 2 1834637776 5407360 5486784
23:23:12 12998 8192000000 10757705552 11175399424 1838182304 18.326 100 27 54 1 1851949616 5607024 8160288
23:23:36 11517 8192000000 10767449936 11190718464 1846388976 18.393 100 28 55 2 1863408944 9660160 7359808
23:23:54 6098 8192000000 10764244640 11186728960 1848145824 18.407 100 24 48 3 1861256480 5735056 7375600
23:24:06 60664 8192000000 10808560560 11198885888 1856371696 18.474 100 59 119 3 1880277888 6572528 17333664
23:25:14 8639 8192000000 10766372800 11189469184 1849862064 18.421 100 25 51 3 1862712448 5466160 7384224
23:25:29 5682 8192000000 10765669872 11193667584 1855889808 18.470 100 30 60 1 1870734608 6378384 8466416
23:25:43 9879 8192000000 10777040976 11199991808 1856661344 18.476 100 28 56 1 1875693056 11682752 7348960
23:26:03 7678 8192000000 10784317760 11201126400 1861770544 18.518 100 41 83 2 1880809040 7382528 11655968
23:26:19 5264 8192000000 10782219968 11202187264 1858720720 18.493 100 26 49 2 1870600688 5403008 6476960
23:26:35 6607 8192000000 10774333008 11201486848 1860218800 18.505 100 30 60 0 1878995632 10460368 8316464
23:26:50 8318 8192000000 10777633072 11207675904 1861806384 18.518 100 29 58 3 1876366368 6756144 7803840
23:27:06 7763 8192000000 10800272688 11223367680 1878290096 18.651 100 34 69 0 1897046208 8601792 10154320
23:27:21 9683 8192000000 10825723520 11238711296 1893722864 18.776 100 60 116 3 1915731440 4694160 17314416
23:27:40 19319 8192000000 10840806160 11250479104 1904362048 18.861 100 59 116 1 1929129072 7599200 17167824
23:28:07 39440 8192000000 10847171760 11265507328 1909146832 18.900 100 47 94 0 1930778736 8175120 13456784
23:28:54 5427 8192000000 10865910160 11274022912 1922815040 19.009 100 69 137 1 1952763072 11245584 18702448
23:29:08 10990 8192000000 10845704144 11273715712 1924266304 19.021 100 51 102 1 1949946096 10974464 14705328
23:29:29 98108 8192000000 10864385472 11295309824 1923964736 19.019 100 36 72 1 1945238352 10706464 10567152
23:31:14 16472 8192000000 10874653520 11303522304 1939265552 19.141 100 40 80 3 1964199792 13110384 11823856
23:31:48 30865 8192000000 10870339232 11304026112 1943573472 19.175 100 35 69 1 1964547120 11513120 9460528
23:32:29 10934 8192000000 10892066752 11320164352 1954213984 19.260 100 44 86 2 1984109904 17637584 12258336
23:32:49 20611 8192000000 10895421040 11326484480 1956287040 19.277 100 35 70 0 1979910240 13925280 9697920
23:33:17 19901 8192000000 10907684416 11336126464 1963358496 19.333 100 55 108 1 1993619440 14089312 16171632
23:33:47 8512 8192000000 10916479392 11340902400 1968710160 19.375 100 43 82 4 1997956592 17549168 11697264
23:34:08 13195 8192000000 10905468512 11344805888 1973670240 19.415 100 47 93 0 2002373072 14846784 13856048
23:34:29 7422 8192000000 10910432576 11345600512 1969976656 19.385 100 55 109 0 2001137728 14883840 16277232
23:34:45 20728 8192000000 10912893648 11348066304 1971751984 19.399 100 46 92 2 2002673808 17359600 13562224
23:35:13 3750 8192000000 10918126976 11348586496 1973220656 19.411 100 60 116 0 2008801488 18475600 17105232
23:35:24 2724 8192000000 10930069856 11345494016 1958861904 19.297 99 76 150 3 1998913648 18928832 21122912
23:35:38 20682 8192000000 10920297552 11352350720 1975252352 19.427 100 55 110 1 2012158176 21100976 15804848
23:36:08 4821 8192000000 10925821248 11359035392 1978975584 19.457 100 46 93 1 2014798592 22146000 13677008
23:36:20 7993 8192000000 10938221504 11371601920 1967237104 19.364 99 57 115 1 2008691312 24411088 17043120
23:36:38 11838 8192000000 10939588960 11365720064 1983795664 19.495 100 58 115 1 2025165776 25191344 16178768
23:36:59 3061 8192000000 10915471040 11329826816 1943283088 19.173 98 63 125 1 1985744816 22957088 19504640
23:37:12 8268 8192000000 10929420000 11356467200 1976950976 19.441 100 61 121 1 2019374784 24392864 18030944
23:37:32 11063 8192000000 10937019984 11357921280 1960978912 19.314 99 63 126 0 2008277120 28225792 19072416
23:37:53 7764 8192000000 10933798240 11363713024 1977941120 19.448 100 62 122 1 2023504896 26888544 18675232
23:38:08 6681 8192000000 10948039536 11369451520 1983613680 19.493 100 65 126 2 2030110512 27156000 19340832
23:38:22 3606 8192000000 10941390608 11361484800 1978205472 19.450 100 68 133 0 2025525344 27631696 19688176
23:38:33 3213 8192000000 10950212192 11371909120 1984609760 19.501 100 73 143 2 2035294720 28861248 21823712
23:38:45 5168 8192000000 10937537168 11357675520 1972174512 19.403 100 71 143 2 2024317072 30156048 21986512
23:38:59 7451 8192000000 10946116608 11372580864 1982255488 19.483 100 71 140 3 2035151424 31091760 21804176
23:39:19 4182 8192000000 10947149152 11369259008 1979944256 19.464 100 67 135 0 2034265024 34250720 20070048
23:39:34 8804 8192000000 10949723584 11379896320 1983405632 19.492 100 61 122 2 2039261824 36079328 19776864
23:39:50 9870 8192000000 10947183040 11382304768 1984326688 19.499 100 54 108 1 2038907920 36632912 17948320
23:40:09 10515 8192000000 10947602944 11375431680 1979599424 19.462 100 66 133 2 2037397040 36358704 21438912
23:40:28 6085 8192000000 10954391120 11386912768 1986690832 19.518 100 65 129 1 2043616512 36597072 20328608
23:40:46 3349 8192000000 10968541920 11386519552 1990478976 19.548 100 82 164 1 2052214720 36617008 25118736
23:40:57 2275 8192000000 10958643200 11378425856 1982729984 19.486 100 82 164 1 2044383088 35833808 25819296
23:41:05 4700 8192000000 10960505616 11379798016 1986121184 19.513 100 81 162 1 2046170992 35782768 24267040
23:41:17 3772 8192000000 10936994064 11346059264 1958222080 19.292 99 83 164 1 2018785744 36578512 23985152
23:41:28 1689 8192000000 10946216944 11355570176 1951834320 19.241 99 89 181 3 2016386448 37869440 26682688
23:41:39 7782 8192000000 10936552304 11355283456 1960598576 19.311 100 71 142 1 2021484688 38975568 21910544
23:42:00 3463 8192000000 10955775712 11369390080 1971401216 19.397 100 78 155 1 2036107808 40831760 23874832
23:42:14 2032 8192000000 10976037824 11384037376 1984536240 19.501 100 88 175 1 2052490112 41523344 26430528
23:42:23 3966 8192000000 10955183424 11373268992 1976103792 19.434 100 81 162 1 2043222464 42732832 24385840
23:42:34 3869 8192000000 10946901088 11363610624 1964735920 19.344 100 84 168 1 2032339088 42212992 25390176
23:42:48 3837 8192000000 10952553984 11368583168 1972212064 19.403 100 74 148 1 2036542752 41455408 22875280
23:43:00 1744 8192000000 10966971504 11381026816 1985243632 19.506 100 90 179 0 2052123696 39873424 27006640
23:43:10 3173 8192000000 10954120560 11374247936 1983053024 19.489 100 63 126 0 2035412400 32667936 19691440
23:43:20 2220 8192000000 10951176032 11359920128 1957462080 19.286 99 92 182 1 2017657600 33435120 26760400
23:43:29 1228 8192000000 10921614048 11328282624 1924609984 19.024 98 93 187 0 1985967344 33804128 27553232
23:43:39 8491 8192000000 10894287728 11322994688 1918977552 18.979 99 59 118 2 1971771648 34136352 18657744
23:43:57 4443 8192000000 10906864304 11327737856 1938622544 19.136 100 70 141 2 1990949840 30734928 21592368
23:44:09 6937 8192000000 10916748352 11342807040 1947203456 19.204 100 61 122 0 1998639216 32455184 18980576
23:44:25 5380 8192000000 10922925632 11349737472 1955383520 19.269 100 62 124 1 2009373152 34604784 19384848
23:44:40 3734 8192000000 10920647088 11351142400 1955226000 19.268 100 51 102 1 2007027552 34964032 16837520
23:44:51 7698 8192000000 10944102928 11363401728 1966107536 19.355 100 74 148 1 2023917088 34592320 23217232
23:45:06 1944 8192000000 10960593136 11374415872 1972754416 19.407 100 81 162 0 2035634016 36961376 25918224
23:45:16 4732 8192000000 10936789872 11365298176 1970582448 19.390 100 52 104 0 2018622672 31655472 16384752
23:45:28 8565 8192000000 10931459936 11360813056 1969910864 19.385 100 52 101 0 2014489648 28963520 15615264
23:45:45 7687 8192000000 10912013792 11346939904 1940782224 19.153 99 59 118 2 1987406928 29155920 17468784
23:45:59 3186 8192000000 10931697184 11350392832 1957314752 19.285 100 78 156 0 2013817824 32290368 24212704
23:46:18 4466 8192000000 10928598448 11353108480 1944282896 19.181 99 60 120 1 1996080624 32954000 18843728
23:46:35 4784 8192000000 10921965552 11353997312 1954834416 19.265 100 60 120 1 2006943248 33939792 18169040
23:46:49 7039 8192000000 10923604336 11354963968 1961934992 19.321 100 53 104 0 2011749312 33231744 16582576
23:47:03 3339 8192000000 10917653616 11338907648 1925525696 19.031 98 70 142 2 1979377008 32482928 21368384
23:47:15 1296 8192000000 10924055104 11332354048 1939779232 19.145 99 88 171 3 1999787760 33406352 26602176
23:47:25 1412 8192000000 10947270896 11353661440 1959953776 19.306 100 79 157 1 2023826352 40045904 23826672
23:47:34 2000 8192000000 10946453840 11351080960 1953351024 19.253 100 93 185 0 2019319344 36952304 29016016
23:47:43 1419 8192000000 10941368816 11360059392 1961532560 19.318 100 76 152 1 2025038384 40544208 22961616
23:47:52 8998 8192000000 10915578960 11351842816 1937667088 19.128 99 53 106 0 1995189904 41022192 16500624
23:48:16 10209 8192000000 10899313648 11325763584 1901255088 18.836 97 41 81 2 1948937472 34956688 12725696
23:48:37 2902 8192000000 10914916432 11337707520 1941435392 19.158 100 58 116 1 1997616544 38162096 18019056
23:48:47 11947 8192000000 10925468384 11349938176 1947784880 19.209 100 56 112 3 2007697184 41303344 18608960
23:49:05 2356 8192000000 10936622944 11349630976 1947047872 19.203 100 83 164 3 2016946288 43485984 26412432
23:49:14 2365 8192000000 10952730560 11360747520 1960034832 19.306 100 91 181 1 2033216352 44659280 28522240
23:49:24 6961 8192000000 10937692192 11370364928 1957096192 19.283 100 46 92 3 2020952848 48367888 15488768
23:49:42 5138 8192000000 10945645088 11365998592 1959128752 19.299 100 65 127 0 2027296752 48254592 19913408
23:49:55 2417 8192000000 10933395616 11344945152 1937207200 19.124 99 80 161 0 2013054400 48489296 27357904
23:50:05 7024 8192000000 10950262400 11364933632 1957998432 19.290 100 70 140 0 2028501888 48125584 22377872
23:50:21 1375 8192000000 10964260208 11376418816 1970186560 19.387 100 87 172 1 2045159008 47394192 27578256
23:50:31 1792 8192000000 10960580816 11363352576 1955552400 19.271 100 84 168 3 2032617808 50476848 26588560
23:50:40 12454 8192000000 10948634640 11373498368 1957330112 19.285 100 63 126 2 2034900720 56620304 20950304
23:51:03 4058 8192000000 10952714544 11371261952 1953514272 19.254 100 61 122 2 2034497040 60237248 20745520
23:51:17 8016 8192000000 10947858896 11379220480 1957207824 19.284 100 53 106 2 2035759744 60795728 17756192
23:51:31 14504 8192000000 10953115296 11390259200 1959057856 19.299 100 42 84 0 2032945296 59559168 14328272
23:51:54 6945 8192000000 10948051776 11379310592 1953935616 19.258 100 36 72 1 2023134032 57074528 12123888
23:52:10 7573 8192000000 10942888112 11381403648 1954923776 19.266 100 46 92 0 2029409824 59361152 15124896
23:52:25 16268 8192000000 10932821728 11374567424 1943970448 19.178 99 38 76 2 2008674960 52218704 12485808
23:52:51 6963 8192000000 10949825056 11382300672 1962667056 19.327 100 48 96 1 2028856704 51257600 14932048
23:53:12 12692 8192000000 10945990560 11385511936 1967224448 19.363 100 35 70 2 2025818144 47229424 11364272
23:53:31 10118 8192000000 10937677536 11378053120 1954314688 19.261 99 29 58 3 2008324704 44351200 9658816
23:53:48 10385 8192000000 10943054576 11380633600 1966741088 19.360 100 36 72 1 2025563680 46016720 12805872
23:54:09 6242 8192000000 10935477088 11378880512 1957480800 19.286 100 31 62 2 2016845856 48171104 11193952
23:54:37 21251 8192000000 10925825456 11378053120 1952617808 19.247 100 31 62 0 2011367152 48162960 10586384
23:55:08 25661 8192000000 10930386768 11389087744 1961498928 19.318 100 27 54 0 2016485264 46230576 8755760
23:55:47 37635 8192000000 10932658192 11381956608 1938126240 19.132 99 33 66 1 1999995232 49685344 12183648
23:56:54 27390 8192000000 10929504352 11374350336 1940608368 19.152 100 39 78 0 2015536256 61452368 13475520
23:57:29 23311 8192000000 10915475296 11384025088 1937919744 19.130 100 30 60 1 2010734336 62191840 10622752
23:58:16 8895 8192000000 10911475952 11365793792 1938566976 19.135 100 32 62 2 1993321952 44017712 10737264
23:58:32 39701 8192000000 10893530144 11357073408 1913703536 18.936 98 19 37 1 1956036256 36633008 5699712
23:59:25 96340 8192000000 10906001632 11358818304 1935089856 19.108 99 14 28 0 1958409280 19143136 4176288
00:01:08 113680 8192000000 10902962784 11355844608 1928273472 19.053 98 13 26 1 1947574784 16270672 3030640
00:03:12 85586 8192000000 10917291072 11375120384 1923736944 19.017 97 13 26 1 1939332576 12294176 3301456
00:04:48 56325 8192000000 10906583184 11377569792 1964561552 19.342 99 11 22 1 1981460432 13720832 3178048
00:06:14 86219 8192000000 10934877376 11385188352 1979119888 19.458 100 16 33 0 1993635472 9894528 4621056
00:07:49 44718 8192000000 10950392464 11391381504 1989430160 19.539 100 32 64 0 2009188176 10693920 9064096
00:08:47 28480 8192000000 10957532080 11388043264 2001182560 19.632 100 46 92 1 2026413904 11824704 13406640
00:09:23 19943 8192000000 10934694928 11385860096 1992841008 19.566 100 46 90 0 2017141840 10869632 13431200
00:09:54 20541 8192000000 10929009024 11393429504 1992552304 19.564 100 27 55 2 2012257488 11642880 8062304
00:10:42 124372 8192000000 10933063296 11392999424 1978099888 19.450 99 28 56 1 2001569184 15560912 7908384
00:12:53 86950 8192000000 10959647088 11418984448 1983039840 19.489 99 27 54 1 2011790304 20803376 7947088
00:14:39 151811 8192000000 10944705296 11406467072 1987608864 19.525 99 32 63 1 2019647488 23142736 8895888
00:17:21 37376 8192000000 10937496832 11411181568 1993459008 19.571 99 28 56 2 2018892592 17271296 8162288
00:18:11 62031 8192000000 10949015664 11394572288 1965857664 19.353 98 23 46 1 1985677584 12937776 6882144
00:19:19 19720 8192000000 10943494768 11398012928 1998345440 19.610 100 41 82 4 2024416848 13821984 12249424
00:19:47 47475 8192000000 10917474800 11395477504 1974854160 19.424 99 25 50 0 1996234928 13858256 7522512
00:20:42 63762 8192000000 10903146368 11374637056 1953221456 19.252 98 15 30 0 1970468176 12884864 4361856
00:21:58 18362 8192000000 10901095376 11377684480 1981429424 19.476 100 5 10 0 1988064320 5398032 1236864
00:22:22 12696 8192000000 10916834800 11392196608 1993797440 19.574 100 18 35 0 2007175232 8641040 4736752
00:22:41 61943 8192000000 10944381760 11409960960 2004892304 19.661 100 33 66 0 2027477472 13208048 9377120
00:23:51 57856 8192000000 10918228048 11401510912 1942430544 19.166 97 14 28 0 1965064384 18911664 3722176
00:24:59 1481 8192000000 10916152752 11403038720 1985734128 19.510 100 8 15 0 2005797632 18196544 1866960
00:25:07 6716 8192000000 10887669200 11368972288 1940822784 19.153 98 10 20 0 1960945120 17924976 2197360
00:25:29 29214 8192000000 10894011984 11378020352 1967265056 19.364 100 13 26 0 1983978240 13019920 3693264
00:26:11 33552 8192000000 10891410560 11371560960 1969587040 19.382 100 9 18 0 1989672384 17624496 2460848
00:27:21 61654 8192000000 10883116592 11366227968 1926241808 19.037 97 19 38 1 1936706336 5371904 5092624
00:28:29 36232 8192000000 10923296448 11387473920 1987386352 19.523 100 25 50 1 2003136480 9104272 6645856
00:29:12 24184 8192000000 10902104944 11380498432 1985902976 19.511 100 12 24 1 2000164560 10942080 3319504
00:29:43 94737 8192000000 10886139072 11375890432 1904780512 18.865 96 5 10 0 1915857728 9736112 1341104
00:31:24 48062 8192000000 10913673488 11369734144 1917752896 18.969 97 24 48 0 1931891056 7824208 6313952
00:32:18 46725 8192000000 10912566400 11381379072 1964784704 19.344 99 38 76 1 1989810704 14338512 10687488
00:33:12 71807 8192000000 10896860416 11382333440 1910408880 18.910 97 21 42 0 1933228576 16700416 6119280
00:34:31 48662 8192000000 10862619440 11329388544 1824669520 18.216 93 20 40 0 1839455680 9429456 5356704
00:35:26 28512 8192000000 10881427152 11328073728 1892828784 18.769 97 38 76 1 1915738480 12139712 10769984
00:36:43 84116 8192000000 10831948592 11307347968 1805576176 18.060 93 7 14 1 1824173136 16580512 2016448
00:38:14 87161 8192000000 10888927792 11344879616 1910142848 18.908 98 26 52 0 1925683392 7768752 7771792
00:39:48 18887 8192000000 10887344928 11328176128 1927529648 19.047 99 47 93 1 1950682000 9874816 13277536
00:40:14 20809 8192000000 10870595696 11322843136 1921152592 18.996 99 43 86 1 1946160240 12761392 12246256
00:40:50 85304 8192000000 10863939808 11333472256 1842772768 18.363 95 13 26 2 1860866800 14674016 3420016
00:42:27 81736 8192000000 10873527936 11313512448 1831694160 18.273 95 17 34 0 1847364272 10972496 4697616
00:44:06 103989 8192000000 10829948624 11303342080 1881470208 18.677 98 36 72 1 1901704592 9845728 10388656
00:46:05 84838 8192000000 10832163696 11304701952 1906210928 18.876 99 23 46 1 1926634416 13460112 6963376
00:47:45 46255 8192000000 10828732080 11301421056 1886385616 18.717 98 19 38 0 1902865936 11329136 5151184
00:48:38 64017 8192000000 10857901776 11327078400 1929007488 19.059 100 25 50 1 1947369280 10963568 7398224
00:49:48 75289 8192000000 10849302384 11335798784 1914722032 18.945 99 7 14 1 1931315792 14570000 2023760
00:51:25 43739 8192000000 10850061968 11329294336 1919375008 18.982 99 13 26 0 1932873088 10090928 3407152
00:52:19 72108 8192000000 10872557856 11343376384 1943428416 19.174 100 15 30 0 1956958832 9559968 3970448
00:53:55 23201 8192000000 10853196400 11324788736 1924322592 19.021 99 18 36 0 1939142928 9608704 5211632
00:54:25 14591 8192000000 10849854352 11328323584 1919017472 18.979 99 14 26 2 1935498624 12292096 4189056
00:54:53 39993 8192000000 10854695056 11350720512 1931717328 19.081 100 8 16 0 1949307168 14803824 2786016
00:55:39 25305 8192000000 10851347728 11344134144 1897623520 18.807 98 6 12 2 1915979536 16832400 1523616
00:56:30 60468 8192000000 10866670752 11349979136 1939684416 19.144 100 13 26 2 1957063360 14218704 3160240
00:57:37 47356 8192000000 10877269824 11342118912 1915181584 18.948 98 17 34 0 1927518448 7804208 4532656
00:58:32 54798 8192000000 10872286160 11338784768 1927035168 19.043 98 26 52 0 1944394944 10417952 6941824
00:59:48 73336 8192000000 10890100256 11360317440 1930066896 19.067 98 23 46 3 1949326000 12617712 6641392
01:01:08 35929 8192000000 10899909312 11371704320 1968637552 19.375 100 25 50 2 1986290336 10558176 7094608
01:01:52 61119 8192000000 10878348064 11357380608 1909494256 18.903 97 14 28 0 1923777712 10597808 3685648
01:02:59 40592 8192000000 10913864368 11373756416 1969486176 19.381 100 34 67 1 1994140496 15690864 8963456
01:03:51 42544 8192000000 10909938400 11371360256 1919722560 18.985 97 32 65 0 1937854608 9634928 8497120
01:04:46 57821 8192000000 10907615584 11396837376 1974340080 19.420 100 26 52 1 2000448528 18830256 7278192
01:05:50 84444 8192000000 10921220720 11386589184 1942078560 19.163 98 22 44 1 1963111056 15207232 5825264
01:07:21 86493 8192000000 10911101152 11380695040 1938533104 19.135 98 14 28 2 1953612352 11170288 3908960
01:08:55 53523 8192000000 10931639872 11403218944 1991433776 19.555 100 26 52 0 2010772976 11725200 7614000
01:10:01 134369 8192000000 10919100896 11392057344 1953020048 19.251 98 12 24 0 1972946992 16562032 3364912
01:12:34 99269 8192000000 10895425376 11350626304 1823159632 18.203 91 33 66 2 1841837216 9166128 9511456
01:14:21 29735 8192000000 10905897232 11369459712 1941109424 19.156 99 30 60 1 1960502400 11026000 8366976
01:15:02 34621 8192000000 10878114352 11355922432 1907428064 18.886 97 18 36 2 1923328336 9951088 5949184
01:15:51 39865 8192000000 10878786240 11363061760 1942114912 19.164 99 20 40 1 1959466768 11677152 5674704
01:16:37 32836 8192000000 10876065168 11355914240 1918635424 18.976 98 9 18 0 1932552624 11468544 2448656
01:17:17 32389 8192000000 10884839984 11367841792 1961030128 19.314 100 9 18 1 1978905136 14974528 2900480
01:17:56 31301 8192000000 10886576752 11370532864 1959321328 19.301 100 6 12 0 1976488192 15240464 1926400
01:18:38 54986 8192000000 10868370560 11338465280 1914519008 18.943 98 6 12 0 1926697984 10561936 1617040
01:19:47 80266 8192000000 10863713968 11338403840 1907663440 18.888 98 17 34 0 1921575904 8728160 5184304
01:21:15 85265 8192000000 10858709872 11348123648 1920317632 18.989 98 27 54 0 1938472928 10019920 8135376
01:22:49 60699 8192000000 10895805952 11362848768 1929383552 19.062 99 7 14 0 1939649456 8568896 1697008
01:23:56 56116 8192000000 10882994432 11345747968 1872245184 18.602 95 18 36 0 1887729840 10143200 5341456
01:24:59 46726 8192000000 10862302672 11328552960 1876331488 18.635 96 27 54 0 1895832112 11641488 7859136
01:25:53 48584 8192000000 10854079104 11330203648 1902117312 18.843 98 17 34 1 1921438816 14272240 5049264
01:26:53 39058 8192000000 9035046160 9239060480 201360992 2.399 11 3 5 0 208308992 6063024 884976

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 29-01-2021 01:28:54 to 29-01-2021 01:29:27.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 157 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-01-2021 01:29:28 to 29-01-2021 01:29:30.

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          241686
MON$OLDEST_ACTIVE               241687
MON$OLDEST_SNAPSHOT             241687
MON$NEXT_TRANSACTION            241687
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                       2050080
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 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 ---
:165: 
:166: mscs-test-161.budzdorov.ru    Fri Jan 29 01:27:53 2021
:167:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:168: 
--- end of diff output ---

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

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