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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17406972 kB
MemAvailable 31458116 kB
Buffers 0 kB
Cached 14246208 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-30 19:27:27
DTS_END                         2021-03-30 19:27:27.7780
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(345:9) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41156
TRN_ID                          247469
ATT_ID                          645
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: 9203.76 24588 1104451
customer order: creation 175.90 328 21108
customer order: refuse 15.38 349 1845
order to supplier: creation 48.38 1164 5805
order to supplier: removal 3.53 94052 424
invoice (draft): creation 46.77 3263 5612
invoice (draft): removal 51.58 722 6190
invoice accept: apply 42.83 16928 5140
invoice accept: cancel 46.73 735 5607
customer reserve: creation 3901.71 169 468205
customer reserve: removal 4556.60 58 546792
realization accept: apply 87.53 175 10503
realization accept: cancel 92.13 105 11056
payment from customer: creation 62.59 97 7511
payment from customer: removal 6.19 74 743
payment to supplier: creation 50.16 121 6019
payment to supplier: removal 3.61 86 433
service: total inventory turnovers 4.59 1129 551
service: total monetary turnovers 6.81 23 817
service: aggregate perf. data 0.72 27737 86
service: refresh index statistics 0.03 344445 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-03-2021 19:28:13 to 30-03-2021 19:28:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1413
TEST_TIME 2 1929
TEST_TIME 3 3863
TEST_TIME 4 4931
TEST_TIME 5 5644
TEST_TIME 6 5684
TEST_TIME 7 5284
TEST_TIME 8 5443
TEST_TIME 9 5295
TEST_TIME 10 5721
TEST_TIME 11 5736
TEST_TIME 12 5837
TEST_TIME 13 6039
TEST_TIME 14 6393
TEST_TIME 15 6550
TEST_TIME 16 6668
TEST_TIME 17 6841
TEST_TIME 18 7641
TEST_TIME 19 7583
TEST_TIME 20 8038
TEST_TIME 21 8309
TEST_TIME 22 8485
TEST_TIME 23 8924
TEST_TIME 24 8879
TEST_TIME 25 9247
TEST_TIME 26 9469
TEST_TIME 27 9565
TEST_TIME 28 9665
TEST_TIME 29 10293
TEST_TIME 30 10726
TEST_TIME 31 10429
TEST_TIME 32 10181
TEST_TIME 33 9980
TEST_TIME 34 10075
TEST_TIME 35 10147
TEST_TIME 36 10072
TEST_TIME 37 9984
TEST_TIME 38 9851
TEST_TIME 39 9821
TEST_TIME 40 9733
TEST_TIME 41 9684
TEST_TIME 42 9546
TEST_TIME 43 9425
TEST_TIME 44 9311
TEST_TIME 45 9220
TEST_TIME 46 9289
TEST_TIME 47 9452
TEST_TIME 48 9373
TEST_TIME 49 9315
TEST_TIME 50 9334
TEST_TIME 51 9263
TEST_TIME 52 9196
TEST_TIME 53 9162
TEST_TIME 54 9142
TEST_TIME 55 9075
TEST_TIME 56 9062
TEST_TIME 57 9053
TEST_TIME 58 9052
TEST_TIME 59 9104
TEST_TIME 60 9107
TEST_TIME 61 9076
TEST_TIME 62 9117
TEST_TIME 63 9183
TEST_TIME 64 9316
TEST_TIME 65 9337
TEST_TIME 66 9299
TEST_TIME 67 9326
TEST_TIME 68 9368
TEST_TIME 69 9422
TEST_TIME 70 9390
TEST_TIME 71 9362
TEST_TIME 72 9250
TEST_TIME 73 9228
TEST_TIME 74 9224
TEST_TIME 75 9219
TEST_TIME 76 9173
TEST_TIME 77 9164
TEST_TIME 78 9135
TEST_TIME 79 9113
TEST_TIME 80 9038
TEST_TIME 81 9095
TEST_TIME 82 9052
TEST_TIME 83 9079
TEST_TIME 84 9100
TEST_TIME 85 9111
TEST_TIME 86 9140
TEST_TIME 87 9215
TEST_TIME 88 9241
TEST_TIME 89 9214
TEST_TIME 90 9270
TEST_TIME 91 9318
TEST_TIME 92 9377
TEST_TIME 93 9339
TEST_TIME 94 9318
TEST_TIME 95 9359
TEST_TIME 96 9349
TEST_TIME 97 9271
TEST_TIME 98 9231
TEST_TIME 99 9247
TEST_TIME 100 9225
TEST_TIME 101 9254
TEST_TIME 102 9226
TEST_TIME 103 9214
TEST_TIME 104 9182
TEST_TIME 105 9141
TEST_TIME 106 9101
TEST_TIME 107 9062
TEST_TIME 108 9124
TEST_TIME 109 9089
TEST_TIME 110 9087
TEST_TIME 111 9153
TEST_TIME 112 9140
TEST_TIME 113 9133
TEST_TIME 114 9158
TEST_TIME 115 9192
TEST_TIME 116 9160
TEST_TIME 117 9202
TEST_TIME 118 9224
TEST_TIME 119 9240
TEST_TIME 120 9204

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 30-03-2021 19:28:16 to 30-03-2021 19:28:20.

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 1537452 1537452 0 0.00 0 26143 6 0 0
doc_list_biud 1537452 1537452 0 0.00 0 85515 26 0 0
sp_add_invoice_to_stock 5242 5140 102 1.94 49 141167 16928 0 102
sp_cancel_adding_invoice 5607 5607 0 0.00 5 50176 736 0 0
sp_cancel_client_order 1845 1845 0 0.00 4 14674 350 0 0
sp_cancel_customer_reserve 546792 546792 0 0.00 1 85519 58 0 0
sp_cancel_pay_from_customer 743 743 0 0.00 2 6221 75 0 0
sp_cancel_pay_to_supplier 433 433 0 0.00 3 5024 86 0 0
sp_cancel_supplier_invoice 6195 6190 5 0.08 2 12087 722 0 5
sp_cancel_supplier_order 424 424 0 0.00 6 996338 94053 0 0
sp_cancel_write_off 11056 11056 0 0.00 1 13889 105 0 0
sp_client_order 21108 21108 0 0.00 4 21108 329 0 0
sp_customer_reserve 468205 468205 0 0.00 0 118750 170 0 0
sp_fill_shopping_cart 32517 32517 0 0.00 1 24775 43 0 0
sp_fill_shopping_cart_clo_res 468204 468204 0 0.00 0 19972 14 0 0
sp_get_clo_for_invoice 5139 5139 0 0.00 0 47293 312 0 0
sp_kill_cost_storno 17839 17839 0 0.00 0 13887 51 0 0
sp_kill_qstorno_ret_qs2qd 1111254 1111254 0 0.00 0 85511 31 0 0
sp_kill_qty_storno 587556 587556 0 0.00 0 85515 68 0 0
sp_lock_selected_doc 21706 21706 0 0.00 0 7524 5 0 0
sp_make_cost_storno 29172 29172 0 0.00 0 26138 48 0 0
sp_multiply_rows_for_pdistr 29172 29172 0 0.00 0 22088 27 0 0
sp_multiply_rows_for_qdistr 21108 21108 0 0.00 0 12557 159 0 0
sp_pay_from_customer 7511 7511 0 0.00 4 21330 98 0 0
sp_pay_to_supplier 6019 6019 0 0.00 5 22106 121 0 0
sp_payment_common 13530 13530 0 0.00 2 7216 23 0 0
sp_qd_handle_on_cancel_clo 1845 1845 0 0.00 0 14644 326 0 0
sp_qd_handle_on_invoice_upd_sts 10746 10746 0 0.00 0 38841 320 0 0
sp_qd_handle_on_reserve_upd_sts 10503 10503 0 0.00 0 14989 66 0 0
sp_reserve_write_off 10503 10503 0 0.00 6 26153 176 0 0
sp_supplier_invoice 5612 5612 0 0.00 7 91870 3263 0 0
sp_supplier_order 5805 5805 0 0.00 5 36587 1164 0 0
srv_aggregate_perf_data 87 86 1 1.14 3173 568986 27737 0 1
srv_fill_mon_cache_memory 150 150 0 0.00 1609 192835 35926 0 0
srv_find_qd_qs_mism 1055155 1055155 0 0.00 0 10179 5 0 0
srv_make_invnt_saldo 551 551 0 0.00 37 94200 1130 0 0
srv_make_money_saldo 817 817 0 0.00 1 1274 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 248386 528887 344445 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 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 5140 5140 0 0.00 0 24325 160 0 0
t$perf-norm:sp_cancel_adding_invoice 425 425 0 0.00 0 8075 99 0 0
t$perf-norm:sp_cancel_client_order 1845 1845 0 0.00 0 8812 16 0 0
t$perf-norm:sp_cancel_customer_reserve 706 706 0 0.00 0 2730 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 743 743 0 0.00 0 1230 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 433 433 0 0.00 0 2089 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 407 407 0 0.00 0 1075 14 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 17785 1323 0 0
t$perf-norm:sp_cancel_write_off 1081 1081 0 0.00 0 1266 3 0 0
t$perf-norm:sp_client_order 21108 21108 0 0.00 0 6748 16 0 0
t$perf-norm:sp_customer_reserve 1054 1054 0 0.00 0 908 5 0 0
t$perf-norm:sp_pay_from_customer 7511 7511 0 0.00 0 5130 9 0 0
t$perf-norm:sp_pay_to_supplier 6019 6019 0 0.00 0 14594 15 0 0
t$perf-norm:sp_reserve_write_off 10503 10503 0 0.00 0 7628 11 0 0
t$perf-norm:sp_supplier_invoice 5612 5612 0 0.00 0 3892 17 0 0
t$perf-norm:sp_supplier_order 5805 5805 0 0.00 0 5336 20 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 84 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 150 150 0 0.00 0 3236 29 0 0
t$perf-norm:srv_make_invnt_saldo 551 551 0 0.00 0 1851 19 0 0
t$perf-norm:srv_make_money_saldo 817 817 0 0.00 0 13836 32 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 16 6 0 0
v_add_invoice_to_stock 10482 10278 204 1.94 0 7482 18 0 204
v_all_customers 39358 39358 0 0.00 0 14 1 0 0
v_all_suppliers 31456 31456 0 0.00 0 81 1 0 0
v_all_wares 42216 42216 0 0.00 0 75 1 0 0
v_cancel_adding_invoice 850 850 0 0.00 0 2142 8 0 0
v_cancel_client_order 3690 3690 0 0.00 0 1850 3 0 0
v_cancel_customer_prepayment 1486 1486 0 0.00 0 1822 8 0 0
v_cancel_customer_reserve 1412 1412 0 0.00 0 3608 9 0 0
v_cancel_payment_to_supplier 866 866 0 0.00 0 1630 9 0 0
v_cancel_supplier_invoice 824 814 10 1.21 0 905 17 0 10
v_cancel_supplier_order 848 848 0 0.00 0 3631 11 0 0
v_cancel_write_off 2162 2162 0 0.00 0 580 11 0 0
v_max_id_clo_ord 5805 5805 0 0.00 0 406 1 0 0
v_max_id_clo_res 1054 1054 0 0.00 0 1948 19 0 0
v_max_id_ord_sup 5604 5604 0 0.00 0 5099 3 0 0
v_max_non_paid_invoice 1700 1700 0 0.00 0 1248 3 0 0
v_max_non_paid_realizn 3768 3768 0 0.00 0 1156 3 0 0
v_min_id_clo_ord 5805 5805 0 0.00 0 4357 7 0 0
v_min_id_clo_res 1054 1054 0 0.00 0 3338 9 0 0
v_min_id_ord_sup 5604 5604 0 0.00 0 8093 12 0 0
v_min_non_paid_invoice 6019 6019 0 0.00 0 6007 12 0 0
v_min_non_paid_realizn 7511 7511 0 0.00 0 6182 14 0 0
v_our_firm 10344 10344 0 0.00 0 17 1 0 0
v_reserve_write_off 21006 21006 0 0.00 0 9325 7 0 0
x_lock_depdocs_on_canc_invoice 11390 11390 0 0.00 0 19280 114 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 30907 445 0 0
x_make_qstorno_1000_1200 5805 5805 0 0.00 1 36580 1080 0 0
x_make_qstorno_1200_2000 5612 5612 0 0.00 2 83443 3108 0 0
x_make_qstorno_2100_3300 468205 468205 0 0.00 0 118735 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-03-2021 19:28:21 to 30-03-2021 19:28:25.

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
16:57:30 9 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:37 28975 8192000000 10296101152 10609250304 891319952 9.812 68 54 109 0 910563024 2207392 17035680
16:58:22 32173 8192000000 10364830432 10687668224 1403856576 14.629 100 85 169 0 1437351440 6009312 27485552
16:59:08 16827 8192000000 10401421792 10726764544 1456890208 15.099 100 90 180 0 1493887392 7655616 29341568
16:59:36 19165 8192000000 10415778080 10746380288 1469365856 15.208 100 89 177 0 1506631664 8612944 28652864
17:00:02 20713 8192000000 10445956352 10777055232 1497812768 15.457 100 92 184 0 1537032416 9441904 29777744
17:00:31 16875 8192000000 10465758720 10799202304 1516203232 15.617 100 92 184 0 1555940848 10236848 29500768
17:01:01 16602 8192000000 10476370640 10815524864 1528390720 15.723 100 86 172 0 1567042176 10919264 27732192
17:01:31 15030 8192000000 10493434800 10836090880 1546575696 15.880 100 89 178 0 1590020048 15384768 28059584
17:01:55 14953 8192000000 10500578736 10846511104 1559121072 15.989 100 85 170 1 1596976352 11147344 26707936
17:02:22 17346 8192000000 10521659088 10874224640 1577046672 16.143 100 81 162 0 1613733040 11410800 25275568
17:02:48 13606 8192000000 10540364240 10897821696 1598134288 16.323 100 81 162 0 1634540432 11338768 25067376
17:03:09 12000 8192000000 10556618800 10913218560 1613416192 16.454 100 74 148 0 1647577808 11333488 22828128
17:03:28 12521 8192000000 10575033728 10937417728 1634631456 16.634 100 78 156 2 1670387152 12014608 23741088
17:03:51 8302 8192000000 10590730624 10956054528 1656309808 16.818 100 76 152 2 1690899808 11757104 22832896
17:04:06 10559 8192000000 10616647504 10983084032 1673312640 16.961 100 78 156 0 1708069232 11707392 23049200
17:04:25 7945 8192000000 10631970992 11001810944 1693596704 17.131 100 69 136 1 1725628560 12106608 19925248
17:04:41 8300 8192000000 10644193456 11019235328 1706947696 17.243 100 75 149 0 1740940016 12324656 21667664
17:04:57 6713 8192000000 10661929456 11037007872 1726650224 17.408 100 72 144 0 1759087808 12357216 20080368
17:05:11 6096 8192000000 10674189840 11051864064 1737708512 17.500 100 75 150 1 1771592960 12178544 21705904
17:05:24 6493 8192000000 10694987088 11070009344 1753167072 17.628 100 80 161 0 1788607248 12527024 22913152
17:05:37 5241 8192000000 10688698240 11069546496 1756998912 17.660 100 70 138 3 1788268880 11798464 19471504
17:05:49 4285 8192000000 10715228112 11092037632 1769017968 17.759 100 82 165 3 1805809008 13358288 23432752
17:06:00 4002 8192000000 10709195200 11091791872 1779594400 17.846 100 82 162 1 1815480000 13110208 22775392
17:06:12 3580 8192000000 10725411632 11109851136 1785792704 17.897 100 75 150 1 1819681040 12479296 21409040
17:06:22 3307 8192000000 10738615552 11122225152 1801173856 18.024 100 89 174 2 1837767264 12336400 24257008
17:06:32 9217 8192000000 10745243600 11130273792 1809684656 18.093 100 85 170 0 1847360448 13983152 23692640
17:06:48 5427 8192000000 10752381072 11137662976 1811915680 18.112 100 80 158 1 1847548096 13824352 21808064
17:07:00 2504 8192000000 10769362448 11154903040 1831818448 18.274 100 87 174 3 1870859984 13935280 25106256
17:07:09 2562 8192000000 10783437360 11164512256 1831809120 18.274 100 89 178 1 1870315728 12668288 25838320
17:07:18 2407 8192000000 10785603808 11170414592 1840714736 18.347 100 88 175 0 1878808304 13633632 24459936
17:07:27 2513 8192000000 10795729136 11182108672 1846858272 18.397 100 92 182 2 1887263712 14131712 26273728
17:07:36 2187 8192000000 10795096288 11184549888 1849913696 18.421 100 79 159 0 1885524512 13827792 21783024
17:07:44 2077 8192000000 10797858480 11185602560 1858120992 18.488 100 92 184 1 1897901408 14241616 25538800
17:07:53 1429 8192000000 10804636016 11190902784 1863198144 18.529 100 88 179 2 1900530688 12628384 24704160
17:08:00 2530 8192000000 10808424928 11195633664 1865471856 18.548 100 93 185 2 1903675472 12691152 25512464
17:08:09 1937 8192000000 10813021328 11198480384 1865959152 18.552 100 95 190 1 1905065248 12391088 26715008
17:08:18 2357 8192000000 10807200672 11197403136 1869911136 18.584 100 89 177 0 1908081312 12728688 25441488
17:08:27 1430 8192000000 10813712400 11200819200 1871317936 18.595 100 97 194 0 1913718704 14355296 28045472
17:08:34 1652 8192000000 10826020688 11212382208 1873323744 18.611 100 93 186 0 1914047024 14346144 26377136
17:08:43 1902 8192000000 10822703264 11211591680 1877059888 18.641 100 87 174 2 1914917760 13261296 24596576
17:08:51 15117 8192000000 10798497344 11204591616 1873525008 18.613 100 64 128 0 1907285376 15986304 17774064
17:09:13 11746 8192000000 10825051664 11215634432 1879921184 18.664 100 87 175 1 1915984544 9961824 26101536
17:09:31 2125 8192000000 10824031440 11217440768 1884373056 18.700 100 97 195 1 1922578928 9854416 28351456
17:09:41 7543 8192000000 10814256608 11210792960 1878573952 18.654 100 77 154 1 1909506512 9169424 21763136
17:09:55 16882 8192000000 10793814240 11210260480 1876182320 18.634 100 54 109 0 1901941248 10223856 15535072
17:10:20 4593 8192000000 10793936160 11210928128 1878897376 18.656 100 49 98 0 1900401424 7859840 13644208
17:10:32 4369 8192000000 10793826128 11214106624 1881334016 18.676 100 31 62 0 1897851936 8304000 8213920
17:10:45 4444 8192000000 10807725152 11220688896 1884911440 18.705 100 41 80 1 1901872704 5045680 11915584
17:10:58 3149 8192000000 10816103120 11223511040 1887340560 18.724 100 51 102 0 1909767728 8243296 14183872
17:11:09 4020 8192000000 10804834304 11225305088 1888586688 18.734 100 42 84 1 1909388432 9012288 11789456
17:11:20 3515 8192000000 10798953472 11224772608 1887094304 18.722 100 32 65 2 1904397328 8396096 8906928
17:11:32 8063 8192000000 10791245104 11225608192 1887289024 18.724 100 16 32 0 1898265104 6151264 4824816
17:11:48 10221 8192000000 10803756864 11230695424 1896492848 18.798 100 25 48 2 1910283824 6283360 7507616
17:12:08 10301 8192000000 10806675360 11233873920 1898679456 18.816 100 26 52 1 1912514688 6284560 7550672
17:12:27 10294 8192000000 10804435472 11239190528 1897178576 18.804 100 16 32 3 1908031008 5993600 4858832
17:12:44 8199 8192000000 10807179456 11236368384 1899125648 18.819 100 19 38 0 1911431840 6513920 5792272
17:12:58 8032 8192000000 10812786896 11245772800 1905933152 18.874 100 24 48 2 1918418528 5871648 6613728
17:13:12 8036 8192000000 10819771344 11251228672 1907991264 18.891 100 26 52 1 1925836080 10523728 7321088
17:13:30 7264 8192000000 10842203744 11254087680 1919065568 18.979 100 57 113 1 1941491984 4856224 17570192
17:13:44 67991 8192000000 10862413312 11265236992 1919077424 18.979 100 60 121 3 1942868320 5679696 18111200
17:14:58 9864 8192000000 10826746736 11264929792 1913441152 18.934 100 29 58 1 1930592544 9062816 8088576
17:15:15 4829 8192000000 10819443440 11257552896 1912882032 18.930 100 28 56 1 1927432144 6578544 7971568
17:15:27 8932 8192000000 10828287488 11262144512 1913359952 18.934 100 23 46 1 1925782592 6300448 6122192
17:15:42 3402 8192000000 10833321120 11265753088 1915924624 18.954 100 29 58 0 1931060736 6473312 8662800
17:15:52 6975 8192000000 10832545408 11265794048 1915362736 18.950 100 26 52 3 1928731552 5303760 8065056
17:16:10 8534 8192000000 10821178816 11265146880 1917489296 18.967 100 27 54 0 1932059616 6262272 8308048
17:16:24 7600 8192000000 10816786128 11246637056 1875111312 18.626 98 31 63 1 1891047184 7223808 8712064
17:16:40 5708 8192000000 10813626064 11240718336 1892987296 18.770 100 25 50 2 1905915056 5223312 7704448
17:16:52 9021 8192000000 10792469280 11228975104 1883995136 18.697 100 20 40 2 1895699136 6421424 5282576
17:17:07 7612 8192000000 10798234544 11228205056 1857164592 18.480 98 31 62 1 1873125264 6286720 9673952
17:17:21 11135 8192000000 10826517888 11234873344 1854290880 18.457 98 34 68 3 1870359376 6071552 9996944
17:17:44 54206 8192000000 10783926368 11221716992 1854832576 18.461 98 35 69 2 1869918064 5222016 9863472
17:18:44 9421 8192000000 10771546512 11199139840 1811379680 18.107 96 20 40 2 1822552320 5434512 5738128
17:19:02 8099 8192000000 10769677152 11190214656 1823078560 18.203 98 35 70 1 1840926816 7278160 10570096
17:19:20 4441 8192000000 10756260640 11174121472 1824767616 18.217 99 41 82 0 1844287776 7416384 12103776
17:19:31 6066 8192000000 10707830736 11118227456 1728537920 17.423 95 33 66 1 1744237488 6240288 9459280
17:19:43 5729 8192000000 10713917408 11128803328 1772185072 17.785 98 36 72 1 1792514512 10259536 10069904
17:19:59 5170 8192000000 10695427152 11099176960 1723152544 17.378 96 38 77 2 1741036032 6808592 11074896
17:20:11 8468 8192000000 10658211728 11062878208 1691610080 17.115 94 24 48 1 1704746288 5726912 7409296
17:20:26 5469 8192000000 10713703088 11132076032 1797584400 17.994 100 31 62 2 1813348864 6331424 9433040
17:20:40 6967 8192000000 10721169072 11139067904 1780244544 17.851 98 35 70 1 1796827120 6112976 10469600
17:20:53 5219 8192000000 10730534320 11143782400 1805777344 18.061 100 35 70 3 1822575024 6877232 9920448
17:21:09 5060 8192000000 10732252944 11140071424 1806081392 18.064 100 36 71 1 1822181968 5562880 10537696
17:21:21 8363 8192000000 10705686800 11127595008 1766543424 17.738 98 26 53 2 1779313760 5728976 7041360
17:21:38 10848 8192000000 10706642352 11127390208 1767456432 17.746 98 17 34 1 1778250496 5717840 5076224
17:21:56 16351 8192000000 10699745952 11121897472 1767848384 17.749 98 22 44 0 1780048496 5591248 6608864
17:22:19 53263 8192000000 10734934336 11155070976 1800731584 18.020 99 34 66 1 1815875472 5192976 9950912
17:23:18 15328 8192000000 10736911424 11164237824 1806875200 18.070 99 25 50 0 1820163824 6088064 7200560
17:23:41 8030 8192000000 10758613616 11180240896 1837206304 18.318 100 31 62 0 1852450416 7086560 8157552
17:23:55 7252 8192000000 10750812592 11174727680 1837754704 18.323 100 29 56 1 1852884960 5736832 9393424
17:24:10 6896 8192000000 10759229216 11185594368 1841377376 18.352 100 21 42 0 1853762688 6584608 5800704
17:24:23 6173 8192000000 10773859680 11193839616 1851439888 18.434 100 29 58 3 1865281632 5158176 8683568
17:24:39 8038 8192000000 10756689600 11192573952 1851655776 18.436 100 11 22 1 1859706112 4903072 3147264
17:24:56 10077 8192000000 10767847200 11202281472 1859975632 18.503 100 20 40 1 1875317872 9982272 5359968
17:25:15 13097 8192000000 10768046416 11200708608 1828919952 18.251 98 22 42 0 1840112608 5201616 5991040
17:25:39 6223 8192000000 10776718848 11210014720 1868388016 18.571 100 21 42 1 1880128224 5460288 6279920
17:25:54 18411 8192000000 10786574480 11217641472 1869114448 18.577 100 17 34 0 1879301136 5441424 4745264
17:26:19 15118 8192000000 10785872528 11217031168 1875859504 18.632 100 24 48 0 1888609824 5780624 6969696
17:26:41 15434 8192000000 10787726432 11219030016 1873797792 18.615 100 12 24 0 1882913280 4912048 4203440
17:27:04 85704 8192000000 10839537936 11256950784 1899514544 18.822 100 35 71 2 1918139904 8786624 9838736
17:28:38 60496 8192000000 10832157712 11265761280 1911944208 18.922 100 37 74 1 1929850032 7103488 10802336
17:29:47 15012 8192000000 10858267104 11280912384 1923837824 19.018 100 35 69 2 1942463328 9675840 8949664
17:30:14 12550 8192000000 10861680704 11289587712 1933305408 19.093 100 42 84 1 1957197936 11832144 12060384
17:30:34 10129 8192000000 10863725552 11293360128 1936026576 19.115 100 41 80 1 1960336512 12717664 11592272
17:30:52 20945 8192000000 10860661344 11292762112 1921416672 18.998 99 43 84 0 1945167456 11970192 11780592
17:31:21 6762 8192000000 10881809504 11303456768 1944093872 19.179 100 51 102 2 1972709264 13625104 14990288
17:31:35 6526 8192000000 10886309792 11313672192 1951226768 19.236 100 60 118 3 1982949136 14714432 17007936
17:31:51 5118 8192000000 10884339120 11313537024 1948570512 19.215 100 58 116 0 1978673376 13048672 17054192
17:32:09 6223 8192000000 10878550416 11313807360 1952356064 19.245 100 51 102 1 1981155936 13858272 14941600
17:32:25 10445 8192000000 10886677520 11317727232 1956987552 19.282 100 45 90 1 1982782752 13313664 12481536
17:32:47 27077 8192000000 10891951712 11333767168 1963628864 19.335 100 40 79 0 1986883680 11636560 11618256
17:33:21 10202 8192000000 10906976848 11345395712 1969867520 19.384 100 39 78 0 1992938560 12211808 10859232
17:33:40 23315 8192000000 10907873760 11342360576 1959494848 19.302 99 49 98 0 1987363024 13919968 13948208
17:34:15 8092 8192000000 10912366544 11345715200 1975344288 19.428 100 51 102 1 2003416912 13648816 14423808
17:34:31 31740 8192000000 10918516656 11356344320 1982476784 19.484 100 53 106 0 2012615408 14393120 15745504
17:35:24 7855 8192000000 10934196256 11371843584 1995456000 19.587 100 49 93 2 2025427264 16385888 13585376
17:35:40 6842 8192000000 10945239440 11378970624 2005373472 19.665 100 72 145 1 2043746256 17516464 20856320
17:35:57 5877 8192000000 10968457808 11390799872 2008829360 19.692 100 69 135 2 2050522912 22221984 19471568
17:36:17 6084 8192000000 10968675840 11394879488 2014540272 19.737 100 68 136 0 2054162608 19769008 19853328
17:36:32 6068 8192000000 10967116512 11396272128 2015853472 19.748 100 74 148 2 2057849632 20726096 21270064
17:36:58 7772 8192000000 10965006304 11398103040 2016279152 19.751 100 59 118 1 2055416096 21127424 18009520
17:37:21 5439 8192000000 10955323728 11387363328 2004680048 19.660 100 62 124 1 2044028560 21027600 18320912
17:37:36 14899 8192000000 10944728656 11391299584 2008886880 19.693 100 48 96 1 2044578000 21231344 14459776
17:38:04 6266 8192000000 10956004768 11397644288 2014984160 19.741 100 41 82 0 2045805728 18077936 12743632
17:38:18 4601 8192000000 10943745152 11374891008 1996913696 19.598 99 57 114 1 2034407600 19745856 17748048
17:38:30 2573 8192000000 10971644384 11400486912 2015460128 19.744 100 59 118 2 2054904176 21706768 17737280
17:38:41 4902 8192000000 10972322912 11402231808 2016887552 19.756 100 75 150 0 2062554784 22998176 22669056
17:38:55 3513 8192000000 10949011424 11378823168 1978203360 19.450 98 57 112 0 2017043136 22178816 16660960
17:39:07 3436 8192000000 10975351360 11403444224 2014177584 19.734 100 78 157 3 2062998800 24728656 24092560
17:39:17 2886 8192000000 10966824288 11391651840 2003339808 19.649 100 77 152 1 2054561792 27976448 23245536
17:39:26 1746 8192000000 10972384992 11390943232 2000927504 19.630 100 85 169 1 2054875456 29121664 24826288
17:39:35 6348 8192000000 10936308640 11351822336 1939867312 19.146 97 70 138 0 1990315760 29701696 20746752
17:39:51 5024 8192000000 10925286816 11341217792 1943271840 19.173 98 78 151 0 1997561168 31387840 22901488
17:40:03 7148 8192000000 10931868880 11361423360 1969113264 19.378 100 65 130 1 2021365760 32063104 20189392
17:40:30 3654 8192000000 10928173984 11349061632 1960246720 19.308 100 72 142 3 2014125648 32169328 21709600
17:40:40 2204 8192000000 10937745072 11352391680 1962713632 19.328 100 76 152 2 2018692416 32441008 23537776
17:40:51 4929 8192000000 10941546560 11360440320 1970074896 19.386 100 66 128 3 2023000640 33123376 19802368
17:41:07 10409 8192000000 10934640048 11358031872 1955020144 19.266 99 68 135 0 2010627136 35143008 20463984
17:41:28 5089 8192000000 10929594160 11345063936 1926721920 19.041 98 81 159 2 1989009344 37573184 24714240
17:41:40 3555 8192000000 10930190000 11341148160 1939272672 19.141 99 79 155 2 2001058496 37728912 24056912
17:41:50 1790 8192000000 10919995232 11328901120 1932666576 19.088 99 82 162 0 1992208800 34774912 24767312
17:42:00 6139 8192000000 10919637056 11334426624 1932287840 19.085 99 73 142 0 1990451328 36378320 21785168
17:42:13 1957 8192000000 10931975856 11339636736 1933049680 19.091 99 80 157 1 1994248064 37073968 24124416
17:42:24 5291 8192000000 10926626928 11332202496 1921744016 19.001 98 70 138 2 1980812176 36754352 22313808
17:42:38 2341 8192000000 10941058080 11345862656 1952154752 19.244 100 88 173 0 2015322528 36453248 26714528
17:42:47 3169 8192000000 10936102496 11344117760 1951320784 19.237 100 84 169 1 2014919648 37366816 26232048
17:42:59 4787 8192000000 10932356832 11358527488 1966543472 19.358 100 76 151 0 2028236064 37854096 23838496
17:43:12 9147 8192000000 10936957440 11354877952 1961613744 19.319 100 65 129 1 2017632512 35965008 20053760
17:43:30 7112 8192000000 10950005344 11366334464 1971221488 19.395 100 74 147 1 2030052080 35733408 23097184
17:43:47 3245 8192000000 10963092816 11377668096 1978270976 19.451 100 85 170 0 2044841536 39704832 26865728
17:43:58 2797 8192000000 10951024352 11371491328 1972038416 19.402 100 71 142 2 2034988768 40766832 22183520
17:44:12 5270 8192000000 10952667840 11372847104 1973695776 19.415 100 77 151 1 2040219200 42986448 23536976
17:44:25 2404 8192000000 10975320496 11382382592 1979619200 19.462 100 78 150 1 2046304288 42985200 23699888
17:44:36 1609 8192000000 10969967408 11385901056 1982910960 19.488 100 75 150 2 2050641824 44502400 23228464
17:44:46 4939 8192000000 10940844720 11357044736 1922173936 19.004 97 73 146 1 1990073856 44995472 22904448
17:44:58 2566 8192000000 10951129280 11363401728 1960980048 19.314 100 74 149 0 2027757584 44138848 22638688
17:45:09 1985 8192000000 10966299200 11374530560 1970638880 19.391 100 92 184 1 2044395696 46370640 27386176
17:45:17 3686 8192000000 10961298576 11365892096 1963483616 19.334 100 93 186 1 2038540960 46224032 28833312
17:45:28 2185 8192000000 10955635440 11366019072 1961271984 19.316 100 85 171 3 2035159680 47716176 26171520
17:45:38 3617 8192000000 10927329840 11355353088 1946125472 19.196 99 60 119 1 2010547776 45711808 18710496
17:45:54 10758 8192000000 10878060896 11311726592 1895096752 18.787 97 34 68 0 1944963104 38434976 11431376
17:46:13 8002 8192000000 10903711152 11333230592 1935733104 19.113 100 56 111 3 1989200464 35281408 18185952
17:46:27 2677 8192000000 10938663440 11357450240 1955640688 19.271 100 77 154 1 2019237536 39113920 24482928
17:46:44 2662 8192000000 10948829568 11364257792 1957329744 19.285 100 89 176 0 2029250704 44052960 27868000
17:46:53 3680 8192000000 10942972720 11367424000 1961328304 19.317 100 67 133 1 2028580224 46308048 20943872
17:47:06 4308 8192000000 10939813520 11373809664 1962824768 19.328 100 62 124 3 2029501984 46760064 19917152
17:47:23 17796 8192000000 10923741984 11361161216 1941310032 19.157 99 44 88 0 1996146688 40894720 13941936
17:47:49 11937 8192000000 10909794848 11358793728 1947857728 19.209 100 38 76 1 2001448448 40685888 12904832
17:48:22 11370 8192000000 10908281056 11362562048 1949835296 19.225 100 30 60 1 1998847936 38957664 10054976
17:48:46 7153 8192000000 10912689280 11346280448 1932166096 19.084 99 41 79 2 1981396688 35965616 13264976
17:49:06 13129 8192000000 10898682928 11348299776 1927894736 19.050 99 31 62 1 1977638528 39442560 10301232
17:49:49 6664 8192000000 10923760736 11365441536 1959483040 19.302 100 53 106 0 2015356848 38850656 17023152
17:50:06 7337 8192000000 10925385152 11363495936 1957674832 19.288 100 44 87 4 2007904912 35848576 14381504
17:50:34 11763 8192000000 10928928496 11376971776 1967764448 19.368 100 33 64 2 2015406176 37035072 10606656
17:50:57 9379 8192000000 10923275072 11362914304 1947981600 19.210 99 32 63 1 1993415328 34999152 10434576
17:51:16 17219 8192000000 10895866048 11342536704 1914539712 18.943 98 30 60 0 1956022272 31856800 9625760
17:51:43 12388 8192000000 10897716224 11340099584 1936772240 19.121 100 27 54 1 1981625968 35369152 9484576
17:52:07 17510 8192000000 10905574496 11347697664 1938895936 19.138 100 36 72 1 1991277888 40031296 12350656
17:52:53 20861 8192000000 10906055168 11354574848 1946799120 19.201 100 27 54 0 1992174672 36145328 9230224
17:53:53 32231 8192000000 10908531456 11369959424 1954748928 19.264 100 18 36 1 1994870496 34139296 5982272
17:54:32 45965 8192000000 10920641840 11370393600 1956402384 19.277 100 18 34 2 2001833232 39287248 6143600
17:55:32 38611 8192000000 10906158352 11369635840 1939653936 19.144 99 22 44 0 1989931360 42475840 7801584
17:56:25 54980 8192000000 10892757392 11372101632 1952234736 19.244 100 14 28 1 2000845008 43725488 4884784
17:57:31 72743 8192000000 10879176064 11330674688 1909551392 18.903 97 20 39 1 1927361184 12188416 5621376
17:58:51 59163 8192000000 10908997280 11354537984 1961186320 19.315 100 26 50 0 1978149344 9902176 7060848
17:59:57 108504 8192000000 10887636288 11358482432 1901613936 18.839 96 19 38 0 1922472672 15554832 5303904
18:01:52 73384 8192000000 10887287968 11369340928 1959903728 19.305 100 7 14 0 1981252544 19523072 1825744
18:03:16 77493 8192000000 10882929472 11354394624 1948571456 19.215 99 12 24 0 1959593920 8121120 2901344
18:04:40 53225 8192000000 10890026864 11363127296 1953225504 19.252 99 12 23 0 1966338272 10694784 2417984
18:05:40 90019 8192000000 10902270928 11377147904 1981949776 19.480 100 19 39 1 1995009360 7674240 5385344
18:07:18 128929 8192000000 10906462080 11375419392 1970100832 19.386 99 19 38 0 1985518720 9308640 6109248
18:09:34 97667 8192000000 10912527584 11374100480 1942679312 19.168 97 29 59 1 1959674608 7770752 9224544
18:11:30 192835 8192000000 10899765376 11371294720 1961213520 19.316 98 26 52 0 1987984976 18387440 8384016
18:15:25 25626 8192000000 10917985424 11380301824 1972391632 19.404 99 27 54 1 1986719824 7025920 7302272
18:15:57 49491 8192000000 10932272864 11399417856 1998816304 19.613 100 35 70 2 2021981264 13040624 10124336
18:17:06 58732 8192000000 10917789168 11394048000 1982162512 19.482 99 17 34 1 2000400048 13432752 4804784
18:18:14 79964 8192000000 10913008528 11386826752 1944295872 19.181 97 21 42 0 1962965904 12159312 6510720
18:19:45 94348 8192000000 10891600336 11380858880 1949585312 19.223 98 18 36 0 1975953376 20893856 5474208
18:21:32 72287 8192000000 10912055792 11386642432 1965656240 19.351 99 18 36 0 1978168288 8031664 4480384
18:22:51 68863 8192000000 10870276912 11332100096 1858999424 18.495 94 20 41 1 1876348832 11957136 5392272
18:24:08 45675 8192000000 10898974016 11359236096 1954989456 19.266 100 18 34 2 1968179264 8194400 4995408
18:25:01 28698 8192000000 10896106464 11360956416 1934551552 19.103 98 33 67 1 1951935344 8080528 9303264
18:25:51 74705 8192000000 10859292816 11330605056 1804494832 18.051 92 21 42 2 1824113792 13792336 5826624
18:27:12 62184 8192000000 10869861920 11331502080 1885457360 18.709 97 10 20 0 1896176416 8472176 2246880
18:28:26 49881 8192000000 10874638240 11335725056 1894638336 18.783 97 28 54 1 1915638384 13369328 7630720
18:29:24 83887 8192000000 10882164080 11342602240 1888857168 18.737 97 19 38 0 1910578768 16223664 5497936
18:30:54 64216 8192000000 10865951984 11343675392 1860391344 18.506 95 24 48 1 1880372496 13243232 6737920
18:32:11 56221 8192000000 10873757392 11340300288 1897195520 18.804 97 21 42 0 1912258864 9398480 5664864
18:33:13 57464 8192000000 10891894544 11339296768 1865052448 18.544 95 32 64 0 1882438784 8613712 8772624
18:34:18 52828 8192000000 10877626528 11345055744 1892061504 18.762 97 28 56 0 1914018704 14176768 7780432
18:35:17 89028 8192000000 10877975552 11353890816 1895993456 18.794 97 12 24 1 1919224544 20020240 3210848
18:37:08 80248 8192000000 10859893184 11328811008 1841029072 18.349 95 32 65 1 1861336048 10482080 9824896
18:39:07 64819 8192000000 10868547120 11335708672 1919440336 18.982 99 30 60 1 1940508912 12348160 8720416
18:40:28 106519 8192000000 10873434976 11334135808 1890287024 18.748 97 22 44 1 1912701776 16200544 6214208
18:42:37 3955 8192000000 10869624720 11339280384 1938427520 19.134 100 19 38 0 1955005824 11210800 5367504
18:42:49 34306 8192000000 10873074848 11335356416 1926035856 19.035 99 27 54 1 1944221984 10594080 7592048
18:43:47 94823 8192000000 10889122144 11349557248 1932770976 19.089 99 13 26 0 1949431168 12835456 3824736
18:45:29 59766 8192000000 10876873472 11362902016 1960670752 19.311 100 14 28 3 1977236464 12148096 4417616
18:46:39 57004 8192000000 10892259344 11370192896 1971855392 19.400 100 15 30 2 1988781072 12202224 4723456
18:48:14 70533 8192000000 10896373776 11378130944 1951108928 19.235 99 7 14 0 1960489504 7671120 1709456
18:49:31 60285 8192000000 10896354928 11372716032 1942040608 19.163 98 25 50 1 1960360464 10853808 7466048
18:50:50 66098 8192000000 10895782784 11377299456 1939942656 19.146 98 13 26 2 1953502048 9564288 3995104
18:52:08 60216 8192000000 10894365184 11363962880 1940312256 19.149 98 27 54 0 1964227552 15777168 8138128
18:53:17 72636 8192000000 10898323392 11372167168 1937266272 19.125 98 18 36 2 1962228096 18908016 6053808
18:54:48 107342 8192000000 10899814464 11384840192 1951434112 19.238 99 12 24 2 1965538832 10823632 3281088
18:57:03 54584 8192000000 10922362800 11400241152 1974847712 19.424 99 21 42 2 1996763920 15816384 6099824
18:58:09 67834 8192000000 10911367536 11374346240 1948640400 19.216 98 13 26 0 1963476944 11645664 3190880
18:59:26 79356 8192000000 10897782640 11364446208 1903651616 18.856 96 12 24 0 1917789568 11178352 2959600
19:00:59 38437 8192000000 10924131824 11381293056 1945391472 19.190 98 24 48 0 1960863328 8508320 6963536
19:02:36 126919 8192000000 10907489488 11387797504 1964227680 19.340 99 14 28 0 1981387488 13258848 3900960
19:04:57 36550 8192000000 10912274416 11372965888 1946014352 19.195 98 44 88 0 1966132416 7567904 12550160
19:05:45 63750 8192000000 10893051680 11363426304 1875451440 18.628 95 22 44 1 1898268096 16388080 6428576
19:07:35 32961 8192000000 10915276880 11378606080 1979230800 19.459 100 23 46 1 1997408352 11625088 6552464
19:08:14 36297 8192000000 10905148208 11379871744 1967352848 19.364 99 26 49 2 1981252608 6919856 6979904
19:08:56 56816 8192000000 10884909040 11358527488 1930219968 19.069 98 16 32 1 1946021648 11456224 4345456
19:10:19 41978 8192000000 10880607664 11365728256 1953781024 19.257 99 6 12 0 1962768560 7650224 1337312
19:11:07 69781 8192000000 10901095952 11378249728 1959659392 19.303 99 12 24 0 1970193856 7048224 3486240
19:12:24 69460 8192000000 10891708336 11368882176 1942209568 19.164 98 13 26 0 1960092512 13779568 4103376
19:14:24 84298 8192000000 10871183088 11365711872 1917932736 18.970 98 11 22 0 1934833792 13922768 2978288
19:15:55 36702 8192000000 10874847680 11344957440 1918501056 18.975 98 17 34 1 1933652720 9983936 5167728
19:16:47 38952 8192000000 10862926320 11335483392 1918641984 18.976 98 27 53 2 1938053328 12469696 6941648
19:17:35 52724 8192000000 10859520128 11331403776 1854321920 18.457 95 26 52 0 1872369344 10716704 7330720
19:18:37 55099 8192000000 10847822400 11309256704 1857613072 18.484 96 18 36 0 1875489984 12863152 5013760
19:19:38 62803 8192000000 10863475104 11324121088 1909547360 18.903 99 19 38 2 1925956016 10567360 5841296
19:20:53 21375 8192000000 10877497792 11331133440 1934952000 19.106 100 45 90 0 1960000384 12697344 12351040
19:21:27 39987 8192000000 10842865104 11302195200 1860241328 18.505 96 33 66 0 1884560496 15168544 9150624
19:22:15 68778 8192000000 10869740048 11331416064 1883031408 18.690 98 24 48 0 1905112384 15249760 6831216
19:23:34 88356 8192000000 10830316320 11303845888 1776275648 17.819 92 23 45 0 1796245520 13706704 6263168
19:25:22 134436 8192000000 9285052304 9557946368 417599568 4.850 22 3 6 0 427286288 8910528 776192

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 30-03-2021 19:28:27 to 30-03-2021 19:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 102 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

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

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          247090
MON$OLDEST_ACTIVE               247792
MON$OLDEST_SNAPSHOT             247792
MON$NEXT_TRANSACTION            247792
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                       2020480
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
:195: 
:196: mscs-test-161.budzdorov.ru    Tue Mar 30 19:27:40 2021
:197:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:198: 
:199: 
:200: mscs-test-161.budzdorov.ru    Tue Mar 30 19:27:45 2021
:201:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:202: 
--- end of diff output ---

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

30.03.21 19:29:01. 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-30 19:29:03 No severe PSQL-related problems occured
30.03.21 19:29:05. End of report.