Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.03.2021 16:29
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 17361220 kB
MemAvailable 31580348 kB
Buffers 0 kB
Cached 14336228 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-18 16:27:21
DTS_END                         2021-03-18 16:27:21.5980
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/51736
TRN_ID                          239407
ATT_ID                          661
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: 9238.23 18160 1108587
customer order: creation 176.64 357 21197
customer order: refuse 14.67 346 1760
order to supplier: creation 46.50 1258 5580
order to supplier: removal 3.61 104928 433
invoice (draft): creation 48.05 3645 5766
invoice (draft): removal 51.73 825 6207
invoice accept: apply 43.00 18241 5160
invoice accept: cancel 46.62 813 5594
customer reserve: creation 3954.54 181 474545
customer reserve: removal 4549.38 65 545925
realization accept: apply 85.84 185 10301
realization accept: cancel 86.89 111 10427
payment from customer: creation 59.18 118 7102
payment from customer: removal 5.83 81 700
payment to supplier: creation 50.36 132 6043
payment to supplier: removal 3.33 107 399
service: total inventory turnovers 4.52 1354 542
service: total monetary turnovers 6.78 39 814
service: aggregate perf. data 0.73 26131 88
service: refresh index statistics 0.03 204290 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-03-2021 16:29:23 to 18-03-2021 16:29:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6112
TEST_TIME 2 5533
TEST_TIME 3 4862
TEST_TIME 4 4830
TEST_TIME 5 5259
TEST_TIME 6 5482
TEST_TIME 7 5484
TEST_TIME 8 5469
TEST_TIME 9 5664
TEST_TIME 10 5670
TEST_TIME 11 5728
TEST_TIME 12 5837
TEST_TIME 13 6251
TEST_TIME 14 6716
TEST_TIME 15 6996
TEST_TIME 16 7349
TEST_TIME 17 7285
TEST_TIME 18 7473
TEST_TIME 19 7785
TEST_TIME 20 7664
TEST_TIME 21 7829
TEST_TIME 22 7873
TEST_TIME 23 8389
TEST_TIME 24 8342
TEST_TIME 25 8453
TEST_TIME 26 8998
TEST_TIME 27 9265
TEST_TIME 28 9607
TEST_TIME 29 9599
TEST_TIME 30 10800
TEST_TIME 31 10777
TEST_TIME 32 10703
TEST_TIME 33 10773
TEST_TIME 34 10670
TEST_TIME 35 10573
TEST_TIME 36 10411
TEST_TIME 37 10269
TEST_TIME 38 10362
TEST_TIME 39 10342
TEST_TIME 40 10194
TEST_TIME 41 10037
TEST_TIME 42 9989
TEST_TIME 43 9953
TEST_TIME 44 10254
TEST_TIME 45 10149
TEST_TIME 46 10053
TEST_TIME 47 10024
TEST_TIME 48 9890
TEST_TIME 49 10011
TEST_TIME 50 9877
TEST_TIME 51 9785
TEST_TIME 52 9726
TEST_TIME 53 9634
TEST_TIME 54 9507
TEST_TIME 55 9660
TEST_TIME 56 9639
TEST_TIME 57 9555
TEST_TIME 58 9537
TEST_TIME 59 9507
TEST_TIME 60 9694
TEST_TIME 61 9689
TEST_TIME 62 9706
TEST_TIME 63 9747
TEST_TIME 64 9818
TEST_TIME 65 9748
TEST_TIME 66 9863
TEST_TIME 67 9890
TEST_TIME 68 9923
TEST_TIME 69 9918
TEST_TIME 70 9988
TEST_TIME 71 9855
TEST_TIME 72 9791
TEST_TIME 73 9788
TEST_TIME 74 9741
TEST_TIME 75 9696
TEST_TIME 76 9653
TEST_TIME 77 9611
TEST_TIME 78 9564
TEST_TIME 79 9511
TEST_TIME 80 9526
TEST_TIME 81 9466
TEST_TIME 82 9474
TEST_TIME 83 9508
TEST_TIME 84 9546
TEST_TIME 85 9561
TEST_TIME 86 9594
TEST_TIME 87 9631
TEST_TIME 88 9607
TEST_TIME 89 9566
TEST_TIME 90 9647
TEST_TIME 91 9747
TEST_TIME 92 9698
TEST_TIME 93 9631
TEST_TIME 94 9589
TEST_TIME 95 9559
TEST_TIME 96 9498
TEST_TIME 97 9442
TEST_TIME 98 9446
TEST_TIME 99 9419
TEST_TIME 100 9415
TEST_TIME 101 9366
TEST_TIME 102 9444
TEST_TIME 103 9424
TEST_TIME 104 9417
TEST_TIME 105 9379
TEST_TIME 106 9379
TEST_TIME 107 9392
TEST_TIME 108 9445
TEST_TIME 109 9448
TEST_TIME 110 9459
TEST_TIME 111 9472
TEST_TIME 112 9490
TEST_TIME 113 9490
TEST_TIME 114 9427
TEST_TIME 115 9396
TEST_TIME 116 9347
TEST_TIME 117 9313
TEST_TIME 118 9334
TEST_TIME 119 9289
TEST_TIME 120 9242

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 18-03-2021 16:29:26 to 18-03-2021 16:29:30.

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 1549180 1549180 0 0.00 0 16165 6 0 0
doc_list_biud 1549180 1549180 0 0.00 0 36088 29 0 0
sp_add_invoice_to_stock 5250 5160 90 1.71 46 165752 18242 0 90
sp_cancel_adding_invoice 5594 5594 0 0.00 3 52063 813 0 0
sp_cancel_client_order 1760 1760 0 0.00 4 17556 347 0 0
sp_cancel_customer_reserve 545925 545925 0 0.00 1 22151 66 0 0
sp_cancel_pay_from_customer 700 700 0 0.00 2 3841 82 0 0
sp_cancel_pay_to_supplier 399 399 0 0.00 3 7346 107 0 0
sp_cancel_supplier_invoice 6213 6207 6 0.09 1 36094 825 0 6
sp_cancel_supplier_order 433 433 0 0.00 4 1057375 104928 0 0
sp_cancel_write_off 10427 10427 0 0.00 1 7551 112 0 0
sp_client_order 21197 21197 0 0.00 3 31592 357 0 0
sp_customer_reserve 474545 474545 0 0.00 0 42186 182 0 0
sp_fill_shopping_cart 32532 32532 0 0.00 1 15914 40 0 0
sp_fill_shopping_cart_clo_res 474541 474541 0 0.00 0 14197 15 0 0
sp_get_clo_for_invoice 5156 5156 0 0.00 0 23633 276 0 0
sp_kill_cost_storno 17120 17120 0 0.00 0 11052 63 0 0
sp_kill_qstorno_ret_qs2qd 1108917 1108917 0 0.00 0 36083 35 0 0
sp_kill_qty_storno 585803 585803 0 0.00 0 36086 76 0 0
sp_lock_selected_doc 21259 21259 0 0.00 0 7649 5 0 0
sp_make_cost_storno 28602 28602 0 0.00 0 10749 51 0 0
sp_multiply_rows_for_pdistr 28602 28602 0 0.00 0 16159 30 0 0
sp_multiply_rows_for_qdistr 21197 21197 0 0.00 0 31585 170 0 0
sp_pay_from_customer 7102 7102 0 0.00 4 12993 118 0 0
sp_pay_to_supplier 6043 6043 0 0.00 5 16169 132 0 0
sp_payment_common 13145 13145 0 0.00 1 11815 31 0 0
sp_qd_handle_on_cancel_clo 1760 1760 0 0.00 0 17550 316 0 0
sp_qd_handle_on_invoice_upd_sts 10750 10750 0 0.00 0 29601 335 0 0
sp_qd_handle_on_reserve_upd_sts 10301 10301 0 0.00 0 20126 67 0 0
sp_reserve_write_off 10301 10301 0 0.00 6 20143 186 0 0
sp_supplier_invoice 5766 5766 0 0.00 6 107700 3646 0 0
sp_supplier_order 5580 5580 0 0.00 5 23629 1258 0 0
srv_aggregate_perf_data 89 88 1 1.12 2704 523344 26131 0 1
srv_fill_mon_cache_memory 173 173 0 0.00 1252 119277 29864 0 0
srv_find_qd_qs_mism 1060377 1060377 0 0.00 0 11061 5 0 0
srv_make_invnt_saldo 542 542 0 0.00 69 113025 1355 0 0
srv_make_money_saldo 814 814 0 0.00 1 7487 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 94407 376861 204290 0 0
t$perf-abend:sp_add_invoice_to_stock 90 90 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 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 5160 5160 0 0.00 0 12701 168 0 0
t$perf-norm:sp_cancel_adding_invoice 406 406 0 0.00 0 3037 87 0 0
t$perf-norm:sp_cancel_client_order 1760 1760 0 0.00 0 10525 20 0 0
t$perf-norm:sp_cancel_customer_reserve 717 717 0 0.00 0 3245 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 700 700 0 0.00 0 458 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 399 399 0 0.00 0 961 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 384 384 0 0.00 0 2194 17 0 0
t$perf-norm:sp_cancel_supplier_order 433 433 0 0.00 0 22848 1709 0 0
t$perf-norm:sp_cancel_write_off 1004 1004 0 0.00 0 1946 10 0 0
t$perf-norm:sp_client_order 21197 21197 0 0.00 0 9947 20 0 0
t$perf-norm:sp_customer_reserve 1056 1056 0 0.00 0 2893 9 0 0
t$perf-norm:sp_pay_from_customer 7102 7102 0 0.00 0 10540 14 0 0
t$perf-norm:sp_pay_to_supplier 6043 6043 0 0.00 0 8418 15 0 0
t$perf-norm:sp_reserve_write_off 10301 10301 0 0.00 0 6180 11 0 0
t$perf-norm:sp_supplier_invoice 5766 5766 0 0.00 0 5106 19 0 0
t$perf-norm:sp_supplier_order 5580 5580 0 0.00 0 5770 18 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 1106 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 1317 21 0 0
t$perf-norm:srv_make_invnt_saldo 542 542 0 0.00 0 2689 36 0 0
t$perf-norm:srv_make_money_saldo 814 814 0 0.00 0 3628 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 5 0 0
v_add_invoice_to_stock 10490 10310 180 1.71 0 5854 18 0 180
v_all_customers 37952 37952 0 0.00 0 86 1 0 0
v_all_suppliers 31130 31130 0 0.00 0 18 1 0 0
v_all_wares 42394 42394 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 812 812 0 0.00 0 1446 9 0 0
v_cancel_client_order 3520 3520 0 0.00 0 3813 6 0 0
v_cancel_customer_prepayment 1400 1400 0 0.00 0 2750 9 0 0
v_cancel_customer_reserve 1434 1434 0 0.00 0 2601 8 0 0
v_cancel_payment_to_supplier 798 798 0 0.00 0 1193 5 0 0
v_cancel_supplier_invoice 780 768 12 1.53 0 5203 32 0 12
v_cancel_supplier_order 866 866 0 0.00 0 1011 6 0 0
v_cancel_write_off 2008 2008 0 0.00 0 4349 19 0 0
v_max_id_clo_ord 5575 5575 0 0.00 0 798 2 0 0
v_max_id_clo_res 1056 1056 0 0.00 0 1983 13 0 0
v_max_id_ord_sup 5760 5760 0 0.00 0 5541 5 0 0
v_max_non_paid_invoice 1813 1813 0 0.00 0 4463 9 0 0
v_max_non_paid_realizn 3925 3925 0 0.00 0 567 3 0 0
v_min_id_clo_ord 5575 5575 0 0.00 0 4201 7 0 0
v_min_id_clo_res 1056 1056 0 0.00 0 5977 10 0 0
v_min_id_ord_sup 5760 5760 0 0.00 0 13132 13 0 0
v_min_non_paid_invoice 6043 6043 0 0.00 0 8157 23 0 0
v_min_non_paid_realizn 7102 7102 0 0.00 0 11809 16 0 0
v_our_firm 10796 10796 0 0.00 0 73 1 0 0
v_reserve_write_off 20602 20602 0 0.00 0 8155 7 0 0
x_lock_depdocs_on_canc_invoice 11417 11417 0 0.00 0 22233 118 0 0
x_lock_depdocs_on_canc_sup_ord 433 433 0 0.00 0 20275 397 0 0
x_make_qstorno_1000_1200 5580 5580 0 0.00 2 21938 1173 0 0
x_make_qstorno_1200_2000 5766 5766 0 0.00 3 107665 3499 0 0
x_make_qstorno_2100_3300 474545 474545 0 0.00 0 40526 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-03-2021 16:29:31 to 18-03-2021 16:29:35.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:25 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:31 14590 8192000000 10217327008 10513559552 957201488 10.462 78 59 119 0 980453952 2695024 20557440
13:57:55 45142 8192000000 10341196944 10654314496 1363549712 14.269 100 85 170 1 1396645824 4695600 28400512
13:58:49 20997 8192000000 10358676528 10682548224 1411135488 14.694 100 85 170 0 1445608976 6247520 28225968
13:59:22 31010 8192000000 10406089216 10731466752 1453043728 15.065 100 84 168 0 1486815152 6878032 26893392
14:00:03 25984 8192000000 10424982752 10754744320 1479750384 15.299 100 89 178 0 1516371552 7823584 28797584
14:00:41 14616 8192000000 10449658544 10779582464 1498296928 15.461 100 92 184 0 1536482112 8521104 29664080
14:01:05 16085 8192000000 10452630352 10790653952 1515892592 15.615 100 85 170 1 1551009152 8674688 26441872
14:01:31 19470 8192000000 10488528704 10828869632 1536804576 15.796 100 86 172 1 1572868320 9152272 26911472
14:02:01 15279 8192000000 10516024640 10857136128 1556865216 15.969 100 81 162 0 1591211984 9472064 24874704
14:02:26 10861 8192000000 10529621264 10884513792 1588397360 16.240 100 77 154 0 1621879264 10339232 23142672
14:02:52 14677 8192000000 10574498752 10928283648 1621776400 16.525 100 78 156 2 1655914784 10693584 23444800
14:03:16 9319 8192000000 10582762848 10943950848 1638318224 16.665 100 79 156 2 1673513280 11745696 23449360
14:03:39 11284 8192000000 10593616704 10958635008 1661285312 16.860 100 73 146 0 1694293408 11651504 21356592
14:03:57 9788 8192000000 10619912720 10985811968 1685119376 17.060 100 85 170 3 1722644832 12482320 25043136
14:04:16 10536 8192000000 10626331584 11000262656 1691332272 17.112 100 78 156 0 1726593808 12757776 22503760
14:04:36 8640 8192000000 10644284112 11015946240 1704924560 17.226 100 80 160 0 1740596928 12616208 23056160
14:04:51 8452 8192000000 10656132048 11032248320 1719940384 17.352 100 75 150 1 1757722400 17075424 20706592
14:05:08 5491 8192000000 10663009792 11041878016 1732228272 17.454 100 77 154 0 1766323888 12373440 21722176
14:05:21 5959 8192000000 10683071664 11060600832 1746815696 17.575 100 82 164 1 1781774912 12331920 22627296
14:05:35 5766 8192000000 10687621968 11064721408 1750200288 17.603 100 73 147 1 1783061616 12511824 20349504
14:05:48 4975 8192000000 10699661440 11079225344 1759686448 17.682 100 79 156 0 1794783520 13522624 21574448
14:05:59 3307 8192000000 10703737024 11083530240 1766855104 17.741 100 83 166 2 1803851056 13815840 23180112
14:06:09 9113 8192000000 10708054784 11088744448 1769886864 17.766 100 71 142 1 1802536064 13205264 19443936
14:06:26 4174 8192000000 10733542096 11113213952 1782353072 17.869 100 74 148 0 1816785296 13141824 21290400
14:06:37 3798 8192000000 10745463088 11126202368 1802350944 18.033 100 80 160 1 1837059200 13085536 21622720
14:06:49 3099 8192000000 10754366352 11135197184 1808447200 18.083 100 76 152 1 1843009920 12902640 21660080
14:06:59 2834 8192000000 10749419952 11142397952 1819658720 18.175 100 74 148 1 1854092912 12420624 22013568
14:07:08 2398 8192000000 10760939008 11145641984 1822356032 18.197 100 81 161 3 1858105552 12460608 23288912
14:07:17 3328 8192000000 10770345296 11155365888 1830587248 18.264 100 80 161 0 1864499328 11076816 22835264
14:07:28 1818 8192000000 10784885280 11168915456 1839512432 18.337 100 87 175 1 1876471408 12406176 24552800
14:07:36 2115 8192000000 10784945536 11169415168 1848027408 18.406 100 93 185 1 1886914480 13041856 25845216
14:07:45 1421 8192000000 10791902304 11178156032 1848128976 18.407 100 92 184 2 1888113360 13730240 26254144
14:07:53 1737 8192000000 10797183600 11186475008 1854697936 18.460 100 94 187 1 1895074576 13223136 27153504
14:08:01 1677 8192000000 10803164240 11188101120 1855217664 18.464 100 91 182 1 1896161200 14354240 26589296
14:08:09 2389 8192000000 10804963984 11188477952 1863561568 18.532 100 95 185 0 1903010256 13303584 26145104
14:08:17 1407 8192000000 10811920832 11199193088 1865430784 18.547 100 91 182 0 1906043536 14609808 26002944
14:08:25 1877 8192000000 10813148272 11201945600 1867950208 18.568 100 88 177 0 1908133696 15080784 25102704
14:08:33 1674 8192000000 10818820192 11207118848 1871081232 18.593 100 89 178 0 1909923568 13138128 25704208
14:08:41 2034 8192000000 10821132656 11208896512 1872928928 18.608 100 89 178 2 1911331024 12497520 25904576
14:08:50 8819 8192000000 10794610880 11198447616 1870474448 18.588 100 66 133 1 1899822256 10979536 18368272
14:09:05 3458 8192000000 10808316640 11205140480 1873545760 18.613 100 62 125 0 1902279248 10720640 18012848
14:09:17 12728 8192000000 10820335024 11212533760 1881675136 18.679 100 85 172 1 1916509360 11172336 23661888
14:09:36 3247 8192000000 10809588512 11216302080 1879742272 18.663 100 78 156 0 1914369584 12564864 22062448
14:09:45 9728 8192000000 10812151056 11216715776 1880678336 18.671 100 69 138 0 1912486688 12061248 19747104
14:10:04 5567 8192000000 10797164064 11215155200 1879129776 18.658 100 41 83 1 1899576352 8742496 11704080
14:10:17 4196 8192000000 10813136832 11221790720 1885168288 18.707 100 49 99 3 1906771520 7342336 14260896
14:10:32 5807 8192000000 10804489744 11222679552 1888961888 18.737 100 45 90 1 1910182272 7290960 13929424
14:10:45 3839 8192000000 10816251968 11229675520 1890837600 18.753 100 46 93 0 1913111760 9520656 12753504
14:10:58 6204 8192000000 10797470688 11222880256 1889823360 18.744 100 41 82 2 1909910608 8881328 11205920
14:11:12 10460 8192000000 10789290432 11222503424 1890951264 18.753 100 24 49 1 1904243360 6625584 6666512
14:11:29 3427 8192000000 10806732736 11228041216 1894295024 18.780 100 36 72 1 1912208000 6585344 11327632
14:11:39 14684 8192000000 10797912304 11229069312 1893892208 18.777 100 15 29 1 1903363024 5358912 4111904
14:12:01 8400 8192000000 10804917088 11236257792 1897835376 18.809 100 26 52 0 1912489376 7508896 7145104
14:12:20 7537 8192000000 10805628432 11237429248 1904577040 18.863 100 25 50 1 1918063120 6779584 6706496
14:12:39 13143 8192000000 10808335760 11236925440 1899610384 18.823 100 20 40 0 1911902144 6874576 5417184
14:13:00 11559 8192000000 10808717632 11241250816 1900895424 18.833 100 12 24 2 1910035600 5924688 3215488
14:13:21 15609 8192000000 10808001360 11240542208 1911496000 18.919 100 37 74 1 1929102000 5106624 12499376
14:13:43 69457 8192000000 10805797584 11249758208 1905809312 18.873 100 27 51 2 1918300624 5283920 7207392
14:15:01 8598 8192000000 10822212064 11254767616 1906084144 18.875 100 11 22 0 1914291424 5491584 2715696
14:15:16 8068 8192000000 10828446176 11258155008 1910095424 18.907 100 24 48 0 1922846064 5347312 7403328
14:15:31 5257 8192000000 10826583216 11261509632 1909912272 18.906 100 24 46 2 1926853520 10678048 6263200
14:15:43 5318 8192000000 10828380912 11261751296 1913128176 18.932 100 32 63 2 1929145760 6810176 9207408
14:15:55 5150 8192000000 10820885888 11258851328 1913484864 18.935 100 20 40 0 1924850752 4890032 6475856
14:16:06 12316 8192000000 10831982208 11266445312 1913954464 18.938 100 21 41 1 1926211920 5993840 6263616
14:16:25 8150 8192000000 10818731632 11262341120 1918083424 18.971 100 27 54 1 1931861776 6143168 7635184
14:16:39 7835 8192000000 10815363152 11248095232 1876262736 18.635 98 17 32 2 1886535488 5389824 4882928
14:16:55 9646 8192000000 10817564320 11250167808 1889585392 18.742 99 21 43 0 1901681312 5657520 6438400
14:17:11 8589 8192000000 10824742320 11255615488 1885146336 18.707 99 25 51 2 1902714080 10688048 6879696
14:17:28 7930 8192000000 10801697376 11235303424 1866598160 18.557 98 20 40 1 1877758272 5377248 5782864
14:17:45 8355 8192000000 10780953968 11204362240 1829274464 18.253 97 13 26 3 1838516064 5554560 3687040
14:18:01 9985 8192000000 10791828768 11223613440 1845048912 18.382 98 15 30 1 1854916400 5174608 4692880
14:18:19 7805 8192000000 10754189920 11186970624 1807919696 18.079 96 13 26 0 1817026672 5367136 3739840
14:18:33 14329 8192000000 10741881536 11167559680 1756879712 17.659 94 21 40 0 1767872912 5288704 5704496
14:18:54 65628 8192000000 10723790208 11140329472 1711402128 17.280 93 24 46 0 1724486688 5727856 7356704
14:20:07 13405 8192000000 10731737648 11138740224 1706159904 17.237 93 26 52 1 1718358592 4588784 7609904
14:20:29 9307 8192000000 10731143872 11145551872 1785370960 17.894 98 19 38 0 1796102848 5473456 5258432
14:20:45 3481 8192000000 10734091168 11139436544 1760852448 17.691 97 42 84 2 1780267680 8052032 11363200
14:20:55 5510 8192000000 10721264512 11130920960 1758721376 17.674 97 35 67 1 1775283296 6437776 10124144
14:21:08 5690 8192000000 10710138880 11118747648 1782705104 17.872 99 32 62 3 1801001472 9117664 9178704
14:21:22 8370 8192000000 10674281680 11092434944 1737859424 17.501 97 24 48 0 1750348896 5676976 6812496
14:21:38 10520 8192000000 10655123872 11069988864 1690882112 17.109 96 20 41 1 1701742240 4550432 6309696
14:21:56 5443 8192000000 10669877616 11079933952 1739612016 17.515 98 33 66 0 1755779952 6625792 9542144
14:22:10 8497 8192000000 10705323104 11117940736 1771965888 17.783 99 21 43 0 1787662592 9618352 6078352
14:22:25 6484 8192000000 10729757888 11141373952 1799136768 18.007 100 22 43 3 1811561904 5532784 6892352
14:22:38 14416 8192000000 10730737568 11151609856 1800073040 18.015 99 20 40 1 1811834880 6350304 5411536
14:22:59 10246 8192000000 10757110832 11174903808 1832113488 18.277 100 29 58 1 1846199040 5551184 8534368
14:23:19 13922 8192000000 10749825920 11177500672 1838100000 18.325 100 18 36 0 1848852128 5666272 5085856
14:23:41 67845 8192000000 10775842560 11194298368 1835149616 18.301 99 44 88 1 1854050688 5387344 13513728
14:24:58 16484 8192000000 10768915600 11197648896 1854480832 18.459 100 33 66 1 1870654528 7188928 8984768
14:25:23 6860 8192000000 10774597792 11201794048 1856776240 18.477 100 27 54 0 1873492624 9393760 7322624
14:25:38 8320 8192000000 10796545968 11208847360 1863510432 18.532 100 34 68 0 1879073696 5633456 9929808
14:25:53 5351 8192000000 10779169520 11207241728 1862483120 18.523 100 26 53 1 1879994080 10404720 7106240
14:26:10 11710 8192000000 10778871088 11209056256 1866509328 18.556 100 17 35 0 1877151808 5580352 5062128
14:26:29 4566 8192000000 10785385232 11216785408 1869523264 18.580 100 32 65 4 1889921184 11507568 8890352
14:26:42 7904 8192000000 10774658016 11212873728 1869068448 18.577 100 13 26 2 1878882688 5372816 4441424
14:26:56 5983 8192000000 10799035904 11222466560 1873694656 18.614 100 23 46 0 1886182400 5715952 6771792
14:27:09 4745 8192000000 10806395792 11233341440 1886735664 18.719 100 21 42 0 1897944128 5258320 5950144
14:27:24 9520 8192000000 10822906784 11244040192 1898700816 18.816 100 37 74 1 1914394672 5103552 10590304
14:27:42 8631 8192000000 10831667392 11251974144 1905672144 18.872 100 46 91 3 1925191552 6248496 13270912
14:28:01 4512 8192000000 10847828144 11269259264 1918496032 18.975 100 60 119 3 1944327920 7368688 18463200
14:28:19 14745 8192000000 10859829136 11278434304 1924213136 19.021 100 52 103 1 1946575200 7705984 14656080
14:28:52 14336 8192000000 10857046336 11284307968 1927136624 19.044 100 43 84 1 1947933088 8194752 12601712
14:29:14 7380 8192000000 10883407136 11298852864 1937837840 19.129 100 58 116 0 1966057536 12051712 16167984
14:29:30 91819 8192000000 10881301776 11314044928 1943690576 19.176 100 46 92 1 1970866480 13729808 13446096
14:31:13 6528 8192000000 10877989472 11316424704 1947535776 19.207 100 34 68 2 1972112560 15005312 9571472
14:31:27 28384 8192000000 10883548080 11321114624 1954713984 19.264 100 42 84 1 1980848160 14209728 11924448
14:32:09 12479 8192000000 10892781584 11327897600 1959133152 19.299 100 53 103 5 1988265040 14574592 14557296
14:32:42 6370 8192000000 10909696112 11337961472 1968259536 19.372 100 52 104 3 1997492784 14089232 15144016
14:32:58 4805 8192000000 10921370688 11340611584 1975014256 19.425 100 59 118 1 2007237744 15745568 16477920
14:33:10 2294 8192000000 10923868768 11346366464 1974994944 19.425 100 64 126 0 2008701792 15211056 18495792
14:33:19 4095 8192000000 10918898256 11345813504 1977567056 19.445 100 63 125 3 2011174048 16309328 17297664
14:33:30 12811 8192000000 10929517424 11352715264 1984353600 19.499 100 70 138 1 2022367632 18273552 19740480
14:33:50 11606 8192000000 10927408208 11357069312 1983335680 19.491 100 61 120 3 2018314624 17419616 17559328
14:34:10 5638 8192000000 10927120832 11359645696 1988477136 19.532 100 58 115 2 2022388736 17603088 16308512
14:34:24 5249 8192000000 10934551936 11364753408 1989389344 19.539 100 55 109 0 2022316624 17161744 15765536
14:34:39 8969 8192000000 10926419904 11365527552 1994162128 19.577 100 62 122 4 2029699584 17566384 17971072
14:34:59 19286 8192000000 10945729104 11379814400 1995784832 19.589 100 44 88 1 2027812192 19267504 12759856
14:35:27 15601 8192000000 10951763328 11385470976 1986088704 19.513 99 48 96 1 2025081392 24771664 14221024
14:35:51 9555 8192000000 10960278976 11391664128 2009814976 19.700 100 61 122 1 2050269696 21333616 19121104
14:36:13 1433 8192000000 10972790832 11400458240 2017548976 19.761 100 66 132 3 2057271728 19939984 19782768
14:36:22 7554 8192000000 10955371808 11393363968 2012585936 19.722 100 53 106 1 2049837184 21282224 15969024
14:36:38 14545 8192000000 10963714176 11398094848 2016687248 19.754 100 57 113 3 2056102080 23393792 16021040
14:36:59 3697 8192000000 10971196608 11405549568 2021253952 19.790 100 64 127 1 2067087024 26425296 19407776
14:37:09 10801 8192000000 10979523008 11413893120 2024444016 19.815 100 61 120 1 2069404464 27188208 17772240
14:37:27 12854 8192000000 10985061824 11420241920 2026172912 19.829 100 61 122 2 2074419152 29168464 19077776
14:37:48 6843 8192000000 10981493088 11422756864 2027833488 19.842 100 54 108 0 2080168672 35914896 16420288
14:38:05 5305 8192000000 10955217168 11385008128 1973064528 19.410 97 61 122 0 2023083184 31129696 18888960
14:38:18 1252 8192000000 10973164368 11393441792 1992432432 19.563 99 82 157 4 2046125152 29841056 23851664
14:38:27 6332 8192000000 10972341312 11395559424 1989238336 19.538 99 75 150 1 2044464992 32765616 22461040
14:38:45 4289 8192000000 10963741568 11391803392 1993629520 19.572 100 58 116 0 2046877952 36082448 17165984
14:38:57 3230 8192000000 10956001488 11386195968 1992194928 19.561 100 56 112 1 2045619040 36286880 17137232
14:39:07 8541 8192000000 10962632736 11393830912 1983196592 19.490 99 54 108 0 2035202448 35331776 16674080
14:39:24 3881 8192000000 10973142736 11391315968 1997526992 19.603 100 70 137 4 2054654224 36748624 20378608
14:39:39 5076 8192000000 10991202080 11412152320 2013222864 19.727 100 71 142 0 2073805712 38844320 21738528
14:39:52 5431 8192000000 10984594544 11414589440 2012138032 19.718 100 64 128 0 2072316496 40270336 19908128
14:40:05 4054 8192000000 10977017168 11398934528 1990010336 19.544 99 80 160 1 2059014464 43476320 25527808
14:40:22 6828 8192000000 10980590000 11409108992 2000058928 19.623 100 67 134 2 2065535296 44711920 20764448
14:40:37 4808 8192000000 10986254560 11413057536 2008507840 19.690 100 73 143 2 2071436960 40255920 22673200
14:40:51 7282 8192000000 10959903680 11394744320 1977653216 19.446 99 60 120 0 2038469024 41761984 19053824
14:41:06 2419 8192000000 10956035424 11381501952 1979973888 19.464 100 68 135 2 2039619200 38386816 21258496
14:41:16 8437 8192000000 10958744528 11392061440 1993202624 19.569 100 64 129 0 2050386752 37163904 20020224
14:41:31 11813 8192000000 10954864544 11394777088 1994684320 19.581 100 48 95 2 2045277056 36128544 14464192
14:41:54 6772 8192000000 10955671808 11394359296 1979224528 19.459 99 44 88 0 2029946192 36903232 13818432
14:42:10 5101 8192000000 10963092160 11389104128 1956984112 19.282 98 59 118 0 2015014864 39370864 18659888
14:42:22 2507 8192000000 10970003488 11385147392 1978628640 19.454 99 89 177 3 2045637728 40777520 26231568
14:42:34 4152 8192000000 10940639312 11366137856 1956823136 19.281 99 64 128 3 2013354320 35975024 20556160
14:42:47 3183 8192000000 10945973600 11370635264 1952962848 19.250 99 72 142 2 2016124288 41125760 22035680
14:42:58 2677 8192000000 10963780304 11380371456 1981318032 19.475 100 72 144 1 2042206000 38403552 22484416
14:43:12 2744 8192000000 10943685664 11367112704 1967285344 19.364 99 70 141 1 2029869152 41058672 21525136
14:43:24 2738 8192000000 10943868464 11361734656 1929562752 19.063 97 81 162 1 1997964928 43631248 24770928
14:43:34 9467 8192000000 10935767776 11373424640 1966659376 19.359 100 50 100 0 2026264096 44246208 15358512
14:44:03 3932 8192000000 10953542240 11381325824 1976877792 19.440 100 56 112 1 2038863536 44573248 17412496
14:44:16 7233 8192000000 10940040400 11370278912 1963607056 19.335 100 54 109 0 2027582000 46452048 17522896
14:44:37 7374 8192000000 10947531264 11376754688 1972564032 19.406 100 62 123 1 2038651488 46648320 19439136
14:44:53 9654 8192000000 10944407392 11380068352 1956819408 19.281 99 49 96 1 2022705616 50278912 15607296
14:45:13 7120 8192000000 10930771296 11366293504 1940258784 19.149 98 49 97 1 2005146800 49019616 15868400
14:45:33 3802 8192000000 10945509840 11372609536 1961022464 19.314 100 52 104 2 2025344336 48294368 16027504
14:45:46 4082 8192000000 10946635712 11363872768 1945105584 19.187 99 79 159 1 2016336176 47524480 23706112
14:46:00 6774 8192000000 10935920032 11355803648 1944465840 19.182 99 65 129 2 2014214144 49785888 19962416
14:46:14 1900 8192000000 10958791312 11372761088 1952277568 19.245 99 87 173 0 2027275968 48015504 26982896
14:46:22 3116 8192000000 10968926224 11387285504 1977813232 19.447 100 76 152 1 2050536480 49679856 23043392
14:46:32 5267 8192000000 10967155680 11379621888 1969435952 19.381 100 76 152 0 2043141088 50129264 23575872
14:46:45 1871 8192000000 10976427456 11389046784 1979171120 19.458 100 80 160 2 2052786944 50250448 23365376
14:46:56 4719 8192000000 10963371424 11388194816 1977577536 19.446 100 62 124 1 2044364448 47389136 19397776
14:47:09 5246 8192000000 10968418544 11396042752 1984129104 19.497 100 68 134 0 2053814192 48934560 20750528
14:47:24 8017 8192000000 10942083776 11375796224 1965243264 19.348 100 41 82 1 2023911856 45610224 13058368
14:47:47 7123 8192000000 10961308912 11382992896 1973753968 19.415 100 72 144 0 2044066176 47374512 22937696
14:48:01 8068 8192000000 10954641952 11373281280 1954064368 19.259 99 69 138 1 2032031952 56369280 21598304
14:48:17 1846 8192000000 10973509408 11383820288 1966509872 19.358 100 88 176 1 2052083600 58198896 27374832
14:48:30 3615 8192000000 10982829776 11397410816 1981414464 19.476 100 85 171 1 2062371632 54224848 26732320
14:48:45 3096 8192000000 10974688144 11390930944 1970308320 19.388 100 89 176 0 2053657760 55769472 27579968
14:48:57 2826 8192000000 10983173328 11399032832 1980928976 19.472 100 85 171 3 2063714944 55753824 27032144
14:49:10 3367 8192000000 10969554400 11374587904 1957534336 19.286 99 80 156 3 2039385696 57250368 24600992
14:49:20 3466 8192000000 10986219008 11401912320 1981152608 19.474 100 80 160 1 2067519120 61067456 25299056
14:49:32 2811 8192000000 10990926480 11409555456 1981503808 19.477 100 74 148 1 2067206032 61588592 24113632
14:49:42 2340 8192000000 11004820368 11415547904 1993607184 19.572 100 83 168 0 2079393152 60300656 25485312
14:49:52 3480 8192000000 11004307728 11421130752 1994198720 19.577 100 83 167 1 2082099312 61260224 26640368
14:50:03 7104 8192000000 11005166320 11429326848 1998348352 19.610 100 78 156 0 2086490352 63108832 25033168
14:50:20 8245 8192000000 10999930096 11428638720 1997595216 19.604 100 59 117 2 2079173344 62464160 19113968
14:50:39 9378 8192000000 10962989184 11415511040 1979518208 19.461 100 36 72 3 2051201264 59414688 12268368
14:50:56 20419 8192000000 10972237760 11415306240 1987162576 19.521 100 29 58 1 2052309952 55713904 9433472
14:51:34 9653 8192000000 10982094992 11421523968 1974650672 19.422 99 37 74 3 2048373648 61580608 12142368
14:51:51 9412 8192000000 10973347280 11418144768 1983274592 19.491 100 38 78 0 2058461632 62495792 12691248
14:52:17 15975 8192000000 10975538464 11423682560 1988816240 19.534 100 38 76 3 2064630592 62657792 13156560
14:52:39 6868 8192000000 10980163936 11425107968 1990609728 19.549 100 49 95 0 2065855248 59265328 15980192
14:53:02 19234 8192000000 10969304192 11424346112 1967420352 19.365 99 35 68 1 2044242128 64934416 11887360
14:54:08 14950 8192000000 10945128672 11398750208 1963162640 19.331 100 29 58 1 2032616304 59166560 10287104
14:54:38 12555 8192000000 10938513168 11393552384 1962214400 19.324 100 24 48 1 2021066432 50282064 8569968
14:55:20 26044 8192000000 10921893808 11380445184 1952488272 19.246 100 18 36 1 2013097632 53874864 6734496
14:55:52 32511 8192000000 10927089376 11379118080 1930338416 19.070 99 12 24 0 1988483968 53332752 4812800
14:57:46 59464 8192000000 10851444544 11302608896 1843251744 18.367 95 8 16 0 1860429792 14777456 2400592
14:58:55 72039 8192000000 10868967712 11327795200 1874761184 18.623 97 23 46 1 1893157680 11970032 6426464
15:00:58 45426 8192000000 10888672176 11332325376 1946696640 19.200 100 32 64 2 1964190880 8204544 9289696
15:02:08 97926 8192000000 10903916144 11359178752 1965396272 19.349 100 27 54 1 1984362448 10987984 7978192
15:04:03 92235 8192000000 10913818736 11369193472 1956948176 19.282 99 31 62 2 1984646976 17633680 10065120
15:06:00 36118 8192000000 10926017280 11372756992 1979760304 19.463 100 31 61 2 1999292592 11238144 8294144
15:06:53 94067 8192000000 10905251296 11368251392 1961933968 19.321 99 18 36 2 1976730976 9411760 5385248
15:08:34 7539 8192000000 10945196448 11386621952 1990857840 19.551 100 54 107 5 2016238432 10589360 14791232
15:08:48 35201 8192000000 10929806160 11390353408 1997041104 19.599 100 36 72 2 2021131536 13813376 10277056
15:09:38 61389 8192000000 10933715824 11376140288 1970292464 19.388 99 25 49 1 1991615584 13925360 7397760
15:10:45 58067 8192000000 10907130912 11389325312 1968779104 19.376 99 40 80 0 1998066608 17142832 12144672
15:12:17 24533 8192000000 10888354416 11349213184 1943985152 19.179 98 37 72 0 1963559616 8367680 11206784
15:12:52 47332 8192000000 10897119296 11358269440 1938473344 19.135 98 26 52 0 1954661600 8864240 7324016
15:13:48 46691 8192000000 10893448576 11373580288 1969353040 19.380 100 13 26 0 1990439376 17176640 3909696
15:14:42 22124 8192000000 10888492000 11365126144 1954983968 19.266 99 8 16 1 1968949664 11687008 2278688
15:15:15 7192 8192000000 10875796288 11352350720 1944617408 19.184 99 7 14 0 1958250720 11793248 1840064
15:15:33 45136 8192000000 10906282960 11377672192 1968721488 19.375 100 24 47 2 1994899856 18820832 7357536
15:16:28 44599 8192000000 10893333136 11376345088 1971218992 19.395 100 12 24 1 1993162864 18662256 3281616
15:17:19 61988 8192000000 10882484736 11343740928 1932564976 19.087 98 14 28 0 1942690624 6699952 3425696
15:18:30 47113 8192000000 10896863488 11357138944 1960304928 19.308 99 27 54 1 1979171840 12135200 6731712
15:19:25 72597 8192000000 10899722464 11383336960 1986000496 19.512 100 19 38 0 2007726352 16335904 5389952
15:21:08 65215 8192000000 10904797296 11391004672 1991764000 19.558 100 16 32 0 2006997312 10435488 4797824
15:22:33 91940 8192000000 10894568928 11383742464 1939098720 19.140 98 7 14 0 1949594672 9041056 1454896
15:24:11 37514 8192000000 10926732288 11377410048 1946890640 19.202 98 22 44 1 1961891056 8979520 6020896
15:24:56 24240 8192000000 10921798144 11385057280 1985487488 19.508 100 41 82 1 2010397264 13373536 11536240
15:25:26 36837 8192000000 10912199184 11375837184 1963413392 19.333 99 24 48 1 1983518544 13298576 6806576
15:26:18 66730 8192000000 10861502800 11331665920 1859391040 18.498 94 15 30 1 1883297872 18868816 5038016
15:27:31 32827 8192000000 10877236384 11321778176 1861884608 18.519 95 35 70 1 1877577264 5910000 9782656
15:28:11 30311 8192000000 10853679968 11309121536 1867120976 18.561 96 37 74 2 1887924592 10750752 10052864
15:28:48 27252 8192000000 10846881472 11302658048 1850929088 18.430 96 24 48 0 1870483648 13242640 6311920
15:29:21 23573 8192000000 10858109984 11321413632 1905478592 18.870 99 38 76 3 1931214112 15267104 10468416
15:29:54 77816 8192000000 10832631376 11293544448 1810621136 18.101 94 18 36 0 1831287264 15674848 4991280
15:31:19 66315 8192000000 10866296240 11326861312 1893371424 18.773 98 14 28 1 1917678864 20275984 4031456
15:32:35 33830 8192000000 10861351776 11312496640 1869823888 18.583 97 36 72 1 1896624304 15985792 10814624
15:33:22 33891 8192000000 10868103952 11326283776 1931319504 19.077 100 16 32 3 1950476384 14362912 4793968
15:34:05 36313 8192000000 10884593840 11351982080 1949308368 19.221 100 26 52 1 1969686912 13044096 7334448
15:34:48 56829 8192000000 10861624400 11340263424 1905922736 18.874 98 15 30 1 1921623824 11608096 4092992
15:35:51 72893 8192000000 10879477360 11349233664 1885239088 18.707 97 20 40 2 1908839584 17488384 6112112
15:37:10 110580 8192000000 10878786064 11332403200 1922270064 19.005 99 10 20 0 1934926160 9919040 2737056
15:39:15 59834 8192000000 10862311232 11319312384 1892610592 18.767 97 34 68 0 1911417232 9687664 9118976
15:40:22 43452 8192000000 10876332768 11339902976 1923198848 19.012 99 28 57 0 1941124400 9803760 8121792
15:41:34 50328 8192000000 10862018672 11333726208 1928385568 19.054 99 18 36 1 1943253968 9715184 5153216
15:42:39 64515 8192000000 10851538320 11328217088 1908789408 18.897 98 14 28 0 1919502960 7172080 3541472
15:43:50 75536 8192000000 10854481872 11322093568 1886691728 18.719 97 12 24 0 1897076880 6878608 3506544
15:45:28 119277 8192000000 10865531392 11348049920 1947181264 19.204 100 23 46 2 1967254688 13118304 6955120
15:47:51 33688 8192000000 10875369920 11359051776 1938255888 19.133 99 9 18 0 1952674256 11855920 2562448
15:48:30 42998 8192000000 10871796560 11349282816 1908693936 18.896 97 27 54 0 1926716432 10604432 7418064
15:49:33 25334 8192000000 10895899056 11354284032 1953953952 19.258 100 34 68 1 1977406560 13216336 10236272
15:50:11 79469 8192000000 10877804160 11355545600 1934428688 19.102 99 15 30 1 1955663056 17233472 4000896
15:51:37 58221 8192000000 10912063664 11375341568 1970838528 19.392 100 20 40 0 1985196592 9033408 5324656
15:53:05 79603 8192000000 10884012240 11361476608 1940947024 19.154 99 18 36 0 1956976288 10858208 5171056
15:54:35 63058 8192000000 10884350160 11340173312 1862078000 18.520 95 17 32 2 1874824640 8291968 4454672
15:55:47 31878 8192000000 10882771296 11333988352 1898302896 18.813 97 46 91 3 1919881616 8625936 12952784
15:56:27 61635 8192000000 10882682672 11361038336 1934502880 19.103 99 24 48 1 1956200432 14892304 6805248
15:57:38 82497 8192000000 10888413600 11380654080 1933784432 19.097 99 6 12 0 1964797696 29561840 1451424
15:59:27 28889 8192000000 10921534032 11364818944 1949843776 19.225 99 51 98 2 1972472416 8354000 14274640
16:00:06 14633 8192000000 10915072544 11363409920 1953086096 19.251 99 51 102 1 1979881872 12421744 14374032
16:00:33 96391 8192000000 10882023568 11354030080 1946777392 19.201 99 24 48 0 1961841904 8689840 6374672
16:02:15 46612 8192000000 10875004752 11362238464 1945507184 19.191 99 10 20 0 1955486848 7356544 2623120
16:03:14 23925 8192000000 10884866272 11365576704 1968148608 19.371 100 8 16 0 1978737232 8333008 2255616
16:03:47 44106 8192000000 10875132608 11360657408 1949568224 19.223 99 7 14 0 1960291344 8755952 1967168
16:04:38 30381 8192000000 10885979408 11366469632 1962394544 19.325 100 6 12 0 1973089056 9112592 1581920
16:06:06 82116 8192000000 10900727248 11374923776 1936988608 19.123 98 15 30 0 1949586032 8526144 4071280
16:07:41 73743 8192000000 10936116032 11395592192 1985963936 19.512 100 26 49 2 2007271280 12616656 8690688
16:09:13 86074 8192000000 10909279056 11380772864 1951258848 19.237 98 16 32 1 1964073040 8432032 4382160
16:10:52 43721 8192000000 10891901296 11370299392 1959622112 19.303 99 17 34 1 1971906016 7469376 4814528
16:11:43 19090 8192000000 10899988656 11374084096 1977689920 19.446 100 35 69 0 1995008736 7166000 10152816
16:12:14 24224 8192000000 10878653520 11344433152 1910646400 18.912 97 26 52 2 1926310464 8656224 7007840
16:12:51 40577 8192000000 10889960480 11370369024 1948414720 19.214 99 31 62 0 1967294496 10411120 8468656
16:13:50 92448 8192000000 10902153776 11392204800 1974528368 19.421 100 18 36 1 1995027424 15147168 5351888
16:15:33 43598 8192000000 10877602384 11346309120 1915766224 18.953 97 9 18 0 1929489456 11793920 1929312
16:16:27 66275 8192000000 10871955008 11345137664 1840751840 18.347 94 15 30 1 1852695408 7621424 4322144
16:17:40 59449 8192000000 10852542624 11329138688 1843304528 18.368 95 24 48 1 1863789152 13856864 6627760
16:18:55 91320 8192000000 10827145504 11309342720 1798912208 18.005 93 13 26 1 1821270752 18369472 3989072
16:20:37 92990 8192000000 10831251616 11296141312 1856770080 18.477 97 22 44 2 1870088272 7048352 6269840
16:22:16 90638 8192000000 10823080368 11287859200 1869583408 18.581 97 22 44 0 1884822480 8803840 6435232
16:23:54 55725 8192000000 10861721184 11339694080 1930924144 19.074 100 18 36 0 1946537968 10456176 5157648
16:24:59 60932 8192000000 10857966912 11351732224 1919563808 18.983 99 8 16 2 1934163760 12249728 2350224
16:26:07 44093 8192000000 10851120608 11336458240 1904184736 18.860 98 14 28 1 1920929264 12697008 4047520
16:27:04 34022 8192000000 9707396720 10054479872 816852464 9.067 42 4 8 0 828027728 10316496 858768

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 18-03-2021 16:29:37 to 18-03-2021 16:30:09.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 90 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-03-2021 16:30:10 to 18-03-2021 16:30:12.

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          239406
MON$OLDEST_ACTIVE               242144
MON$OLDEST_SNAPSHOT             242144
MON$NEXT_TRANSACTION            242144
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                       2041248
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.33427 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33427 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33427 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33427 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 ---
:54: 
:55: mscs-test-161.budzdorov.ru    Thu Mar 18 16:27:40 2021
:56:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:57: 
:58: 
:59: mscs-test-161.budzdorov.ru    Thu Mar 18 16:27:40 2021
:60:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:61: 
:62: 
:63: mscs-test-161.budzdorov.ru    Thu Mar 18 16:27:40 2021
:64:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:65: 
:66: 
:67: mscs-test-161.budzdorov.ru    Thu Mar 18 16:27:41 2021
:68:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:69: 
:70: 
:71: mscs-test-161.budzdorov.ru    Thu Mar 18 16:27:41 2021
:72:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:73: 
:74: 
:75: mscs-test-161.budzdorov.ru    Thu Mar 18 16:27:50 2021
:76:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:77: 
--- end of diff output ---

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

18.03.21 16:30:13. 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-18 16:30:16 No severe PSQL-related problems occured
18.03.21 16:30:17. End of report.