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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-11 22:27:09
DTS_END                         2021-01-11 22:27:09.0040
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/39806
TRN_ID                          242317
ATT_ID                          696
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: 9090.15 17658 1090818
customer order: creation 176.44 350 21173
customer order: refuse 15.08 354 1809
order to supplier: creation 46.83 1306 5619
order to supplier: removal 3.41 99097 409
invoice (draft): creation 45.86 3259 5503
invoice (draft): removal 50.14 781 6017
invoice accept: apply 42.45 18642 5094
invoice accept: cancel 44.78 788 5374
customer reserve: creation 3915.55 185 469866
customer reserve: removal 4451.83 61 534220
realization accept: apply 84.39 159 10127
realization accept: cancel 80.72 102 9686
payment from customer: creation 61.55 112 7386
payment from customer: removal 5.85 67 702
payment to supplier: creation 49.43 104 5932
payment to supplier: removal 3.18 60 381
service: total inventory turnovers 5.17 1096 620
service: total monetary turnovers 6.58 26 789
service: aggregate perf. data 0.89 17987 107
service: refresh index statistics 0.03 208622 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1945
TEST_TIME 2 2320
TEST_TIME 3 4523
TEST_TIME 4 4975
TEST_TIME 5 5168
TEST_TIME 6 5414
TEST_TIME 7 5666
TEST_TIME 8 5870
TEST_TIME 9 6070
TEST_TIME 10 6799
TEST_TIME 11 6875
TEST_TIME 12 7062
TEST_TIME 13 7139
TEST_TIME 14 7162
TEST_TIME 15 7230
TEST_TIME 16 7286
TEST_TIME 17 7590
TEST_TIME 18 8018
TEST_TIME 19 8173
TEST_TIME 20 8556
TEST_TIME 21 8397
TEST_TIME 22 8909
TEST_TIME 23 9338
TEST_TIME 24 9652
TEST_TIME 25 9686
TEST_TIME 26 9547
TEST_TIME 27 10198
TEST_TIME 28 10313
TEST_TIME 29 11400
TEST_TIME 30 11135
TEST_TIME 31 10914
TEST_TIME 32 10937
TEST_TIME 33 10863
TEST_TIME 34 10663
TEST_TIME 35 10469
TEST_TIME 36 10348
TEST_TIME 37 10240
TEST_TIME 38 10122
TEST_TIME 39 10065
TEST_TIME 40 9991
TEST_TIME 41 9921
TEST_TIME 42 9829
TEST_TIME 43 9810
TEST_TIME 44 9688
TEST_TIME 45 9606
TEST_TIME 46 9581
TEST_TIME 47 9524
TEST_TIME 48 9405
TEST_TIME 49 9380
TEST_TIME 50 9438
TEST_TIME 51 9433
TEST_TIME 52 9340
TEST_TIME 53 9243
TEST_TIME 54 9167
TEST_TIME 55 9189
TEST_TIME 56 9104
TEST_TIME 57 9103
TEST_TIME 58 9251
TEST_TIME 59 9216
TEST_TIME 60 9181
TEST_TIME 61 9204
TEST_TIME 62 9171
TEST_TIME 63 9318
TEST_TIME 64 9398
TEST_TIME 65 9434
TEST_TIME 66 9456
TEST_TIME 67 9436
TEST_TIME 68 9446
TEST_TIME 69 9538
TEST_TIME 70 9588
TEST_TIME 71 9558
TEST_TIME 72 9463
TEST_TIME 73 9455
TEST_TIME 74 9389
TEST_TIME 75 9353
TEST_TIME 76 9342
TEST_TIME 77 9292
TEST_TIME 78 9255
TEST_TIME 79 9253
TEST_TIME 80 9159
TEST_TIME 81 9112
TEST_TIME 82 9204
TEST_TIME 83 9170
TEST_TIME 84 9226
TEST_TIME 85 9223
TEST_TIME 86 9199
TEST_TIME 87 9233
TEST_TIME 88 9200
TEST_TIME 89 9283
TEST_TIME 90 9275
TEST_TIME 91 9259
TEST_TIME 92 9284
TEST_TIME 93 9295
TEST_TIME 94 9339
TEST_TIME 95 9374
TEST_TIME 96 9335
TEST_TIME 97 9250
TEST_TIME 98 9220
TEST_TIME 99 9211
TEST_TIME 100 9145
TEST_TIME 101 9175
TEST_TIME 102 9164
TEST_TIME 103 9138
TEST_TIME 104 9130
TEST_TIME 105 9201
TEST_TIME 106 9198
TEST_TIME 107 9201
TEST_TIME 108 9180
TEST_TIME 109 9220
TEST_TIME 110 9216
TEST_TIME 111 9300
TEST_TIME 112 9283
TEST_TIME 113 9252
TEST_TIME 114 9294
TEST_TIME 115 9343
TEST_TIME 116 9269
TEST_TIME 117 9207
TEST_TIME 118 9186
TEST_TIME 119 9161
TEST_TIME 120 9090

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-01-2021 22:29:44 to 11-01-2021 22:29:47.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1525209 1525209 0 0.00 0 16964 6 0 0
doc_list_biud 1525207 1525207 0 0.00 0 29986 27 0 0
sp_add_invoice_to_stock 5167 5094 73 1.41 30 160927 18642 0 73
sp_cancel_adding_invoice 5374 5374 0 0.00 5 38928 789 0 0
sp_cancel_client_order 1809 1809 0 0.00 4 24591 355 0 0
sp_cancel_customer_reserve 534220 534220 0 0.00 1 30012 61 0 0
sp_cancel_pay_from_customer 702 702 0 0.00 2 2847 67 0 0
sp_cancel_pay_to_supplier 381 381 0 0.00 3 1362 61 0 0
sp_cancel_supplier_invoice 6027 6017 10 0.16 1 12221 782 0 10
sp_cancel_supplier_order 409 409 0 0.00 8 1133101 99097 0 0
sp_cancel_write_off 9686 9686 0 0.00 1 12457 103 0 0
sp_client_order 21173 21173 0 0.00 4 25183 350 0 0
sp_customer_reserve 469866 469866 0 0.00 0 52345 185 0 0
sp_fill_shopping_cart 32282 32282 0 0.00 1 35488 38 0 0
sp_fill_shopping_cart_clo_res 469866 469866 0 0.00 0 17295 14 0 0
sp_get_clo_for_invoice 5094 5094 0 0.00 0 24945 339 0 0
sp_kill_cost_storno 16143 16143 0 0.00 0 11982 53 0 0
sp_kill_qstorno_ret_qs2qd 1084552 1084552 0 0.00 0 24636 33 0 0
sp_kill_qty_storno 572736 572736 0 0.00 0 29985 71 0 0
sp_lock_selected_doc 21091 21091 0 0.00 0 5348 5 0 0
sp_make_cost_storno 28539 28539 0 0.00 0 16951 46 0 0
sp_multiply_rows_for_pdistr 28539 28539 0 0.00 0 9529 28 0 0
sp_multiply_rows_for_qdistr 21173 21173 0 0.00 0 25006 154 0 0
sp_pay_from_customer 7386 7386 0 0.00 4 12608 113 0 0
sp_pay_to_supplier 5932 5932 0 0.00 4 12311 105 0 0
sp_payment_common 13318 13318 0 0.00 1 8606 23 0 0
sp_qd_handle_on_cancel_clo 1809 1809 0 0.00 0 24585 328 0 0
sp_qd_handle_on_invoice_upd_sts 10468 10468 0 0.00 0 23656 326 0 0
sp_qd_handle_on_reserve_upd_sts 10127 10127 0 0.00 0 15866 55 0 0
sp_reserve_write_off 10127 10127 0 0.00 6 16223 160 0 0
sp_supplier_invoice 5503 5503 0 0.00 6 90316 3259 0 0
sp_supplier_order 5619 5619 0 0.00 5 38674 1306 0 0
srv_aggregate_perf_data 108 107 1 0.92 2469 148657 17988 0 1
srv_fill_mon_cache_memory 164 164 0 0.00 1530 148191 32078 0 0
srv_find_qd_qs_mism 1041776 1041776 0 0.00 0 10707 5 0 0
srv_make_invnt_saldo 620 620 0 0.00 31 50640 1096 0 0
srv_make_money_saldo 789 789 0 0.00 0 1526 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 129349 327043 208622 0 0
t$perf-abend:sp_add_invoice_to_stock 73 73 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 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 5094 5094 0 0.00 0 21744 174 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 0 9003 103 0 0
t$perf-norm:sp_cancel_client_order 1809 1809 0 0.00 0 2080 10 0 0
t$perf-norm:sp_cancel_customer_reserve 703 703 0 0.00 0 956 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 702 702 0 0.00 0 4072 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 381 381 0 0.00 0 3163 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 428 428 0 0.00 0 2064 17 0 0
t$perf-norm:sp_cancel_supplier_order 409 409 0 0.00 0 27384 1543 0 0
t$perf-norm:sp_cancel_write_off 1038 1038 0 0.00 0 5406 19 0 0
t$perf-norm:sp_client_order 21173 21173 0 0.00 0 8908 17 0 0
t$perf-norm:sp_customer_reserve 1042 1042 0 0.00 0 7414 23 0 0
t$perf-norm:sp_pay_from_customer 7386 7386 0 0.00 0 16089 15 0 0
t$perf-norm:sp_pay_to_supplier 5932 5932 0 0.00 0 6685 11 0 0
t$perf-norm:sp_reserve_write_off 10127 10127 0 0.00 0 15768 13 0 0
t$perf-norm:sp_supplier_invoice 5503 5503 0 0.00 0 8863 17 0 0
t$perf-norm:sp_supplier_order 5619 5619 0 0.00 0 8445 15 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 925 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 2898 22 0 0
t$perf-norm:srv_make_invnt_saldo 620 620 0 0.00 0 1872 22 0 0
t$perf-norm:srv_make_money_saldo 789 789 0 0.00 0 619 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10334 10188 146 1.41 0 11152 16 0 146
v_all_customers 38250 38250 0 0.00 0 87 1 0 0
v_all_suppliers 30562 30562 0 0.00 0 102 1 0 0
v_all_wares 42344 42344 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 965 6 0 0
v_cancel_client_order 3618 3618 0 0.00 0 3922 6 0 0
v_cancel_customer_prepayment 1404 1404 0 0.00 0 1494 5 0 0
v_cancel_customer_reserve 1406 1406 0 0.00 0 1731 4 0 0
v_cancel_payment_to_supplier 762 762 0 0.00 0 1349 7 0 0
v_cancel_supplier_invoice 876 856 20 2.28 0 1626 15 0 20
v_cancel_supplier_order 818 818 0 0.00 0 8745 15 0 0
v_cancel_write_off 2076 2076 0 0.00 0 1934 15 0 0
v_max_id_clo_ord 5613 5613 0 0.00 0 517 1 0 0
v_max_id_clo_res 1042 1042 0 0.00 0 2972 25 0 0
v_max_id_ord_sup 5497 5497 0 0.00 0 6133 7 0 0
v_max_non_paid_invoice 1761 1761 0 0.00 0 2583 4 0 0
v_max_non_paid_realizn 4061 4061 0 0.00 0 3802 4 0 0
v_min_id_clo_ord 5613 5613 0 0.00 0 2833 7 0 0
v_min_id_clo_res 1042 1042 0 0.00 0 5015 18 0 0
v_min_id_ord_sup 5497 5497 0 0.00 0 4060 3 0 0
v_min_non_paid_invoice 5932 5932 0 0.00 0 6745 15 0 0
v_min_non_paid_realizn 7386 7386 0 0.00 0 8603 15 0 0
v_our_firm 10744 10744 0 0.00 0 14 1 0 0
v_reserve_write_off 20254 20254 0 0.00 0 11838 6 0 0
x_lock_depdocs_on_canc_invoice 10963 10963 0 0.00 0 24595 121 0 0
x_lock_depdocs_on_canc_sup_ord 409 409 0 0.00 0 13228 325 0 0
x_make_qstorno_1000_1200 5619 5619 0 0.00 1 38665 1227 0 0
x_make_qstorno_1200_2000 5503 5503 0 0.00 3 83626 3116 0 0
x_make_qstorno_2100_3300 469866 469866 0 0.00 0 52343 169 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:12 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:19 9599 8192000000 10197281936 10503704576 929753520 10.192 72 45 90 0 946520736 2272176 14495040
19:57:36 32096 8192000000 10365268288 10684882944 1392256832 14.526 100 83 166 1 1422739424 4200656 26281936
19:58:23 6873 8192000000 10386896016 10709737472 1448216208 15.022 100 89 178 0 1483167200 6482128 28468864
19:58:41 18769 8192000000 10407129456 10735386624 1464370208 15.164 100 91 182 1 1501304912 7550144 29384560
19:59:13 30437 8192000000 10445871888 10776428544 1489209984 15.382 100 88 176 1 1526133152 8782048 28141120
19:59:54 16962 8192000000 10456515264 10790662144 1510085664 15.564 100 91 182 0 1548698672 9764432 28848576
20:00:20 22962 8192000000 10481780976 10821083136 1526022576 15.703 100 89 178 1 1564802784 10643872 28136336
20:01:18 22156 8192000000 10515809264 10866974720 1565296352 16.042 100 83 166 0 1601562928 10649728 25616848
20:01:55 17274 8192000000 10538169072 10893119488 1600122272 16.340 100 87 175 0 1638336496 11651440 26562784
20:02:24 14402 8192000000 10559065600 10921590784 1619397664 16.505 100 76 152 0 1653598256 11441696 22758896
20:02:46 12271 8192000000 10580831904 10942509056 1639209040 16.673 100 84 168 1 1676716656 12001920 25505696
20:03:07 14605 8192000000 10599477600 10961932288 1661394544 16.861 100 83 165 0 1698430528 12678256 24357728
20:03:30 8236 8192000000 10610683808 10977849344 1669733344 16.931 100 80 160 0 1706748096 13521744 23493008
20:03:45 8191 8192000000 10623670256 10991579136 1689253744 17.095 100 81 160 0 1726082528 13232640 23596144
20:04:00 7661 8192000000 10645212960 11019243520 1698425856 17.172 100 71 142 3 1731855456 12499424 20930176
20:04:16 6992 8192000000 10657339840 11032969216 1721316848 17.363 100 74 148 0 1759012848 16491312 21204688
20:04:33 8359 8192000000 10662855616 11042476032 1732402912 17.455 100 68 133 3 1762669952 11814192 18452848
20:04:48 8221 8192000000 10683452848 11062812672 1746748512 17.575 100 75 150 0 1780353296 12218624 21386160
20:05:05 6804 8192000000 10701891840 11083190272 1764408656 17.721 100 71 140 2 1795893616 11130944 20354016
20:05:19 5421 8192000000 10709254912 11091951616 1775036816 17.809 100 74 146 1 1807891568 11924864 20929888
20:05:31 4106 8192000000 10717432688 11099254784 1780451280 17.853 100 75 149 0 1813486576 11810640 21224656
20:05:46 6413 8192000000 10724860656 11109933056 1789984880 17.932 100 69 139 1 1820605360 11742864 18877616
20:05:59 4558 8192000000 10723845728 11114467328 1790020800 17.932 100 68 136 0 1821871680 12124016 19726864
20:06:12 6099 8192000000 10751087952 11139133440 1807739920 18.077 100 69 135 2 1838901120 11857408 19303792
20:06:25 4472 8192000000 10761586528 11154087936 1821735040 18.192 100 80 160 1 1857334544 12583360 23016144
20:06:36 3689 8192000000 10769891376 11157716992 1831368656 18.270 100 80 160 1 1867438640 13420432 22649552
20:06:47 2839 8192000000 10779556576 11167023104 1837523392 18.321 100 84 168 2 1874564128 13361728 23679008
20:06:56 2054 8192000000 10779170976 11170639872 1841709680 18.355 100 89 177 0 1880709552 13733712 25266160
20:07:05 2476 8192000000 10788158432 11175821312 1846595232 18.394 100 92 185 1 1886676432 13328016 26753184
20:07:14 2203 8192000000 10787583920 11178586112 1849478464 18.418 100 89 176 0 1888634608 13485728 25670416
20:07:24 2539 8192000000 10797864048 11188994048 1859812528 18.502 100 91 182 3 1898931488 12857824 26261136
20:07:34 2903 8192000000 10806008496 11193344000 1861385936 18.515 100 88 176 0 1899059664 12898112 24775616
20:07:43 1737 8192000000 10802190704 11191083008 1865150464 18.545 100 90 175 1 1901744624 12634064 23960096
20:07:51 1393 8192000000 10811436528 11200999424 1866353696 18.555 100 88 174 0 1903408128 12168032 24886400
20:07:58 2347 8192000000 10816143680 11202461696 1871214352 18.594 100 89 177 1 1909724720 12825600 25684768
20:08:08 1979 8192000000 10820381680 11208790016 1871090112 18.593 100 94 188 1 1912342064 14168528 27083424
20:08:16 1813 8192000000 10819997184 11213840384 1874873072 18.624 100 92 185 0 1915793936 13827088 27093776
20:08:25 1933 8192000000 10825063232 11211194368 1883717936 18.695 100 95 190 2 1924034352 12632720 27683696
20:08:33 1648 8192000000 10821988720 11214401536 1880849648 18.672 100 93 186 0 1918780544 11128672 26802224
20:08:41 1277 8192000000 10824131424 11215740928 1884731680 18.703 100 95 190 4 1923961696 11802912 27427104
20:08:48 48509 8192000000 10811926000 11214700544 1875324304 18.627 100 56 112 2 1900355888 7525200 17506384
20:09:43 1624 8192000000 10827972336 11221774336 1883701760 18.695 100 90 180 2 1921874944 11050992 27122192
20:09:52 2787 8192000000 10832753744 11223629824 1882701248 18.687 100 86 172 1 1918622272 12225920 23695104
20:10:01 4916 8192000000 10800763232 11212611584 1876213984 18.635 100 48 97 1 1900841952 11222448 13405520
20:10:14 7904 8192000000 10793691296 11213361152 1878784736 18.655 100 48 96 1 1900293424 7621216 13887472
20:10:33 4141 8192000000 10793110448 11216986112 1877905472 18.648 100 42 84 2 1897218544 7326720 11986352
20:10:44 5903 8192000000 10796926784 11219800064 1880725552 18.671 100 40 80 2 1899566016 7489424 11351040
20:10:56 4565 8192000000 10783502608 11213406208 1877614512 18.646 100 23 47 2 1890910128 5983904 7311712
20:11:09 7525 8192000000 10791092784 11218382848 1878419536 18.652 100 25 48 0 1891620480 5972144 7228800
20:11:25 7102 8192000000 10796308448 11225796608 1881908800 18.681 100 34 68 0 1899361152 7850064 9602288
20:11:40 7489 8192000000 10793170800 11223166976 1880840032 18.672 100 21 42 2 1893573792 6595952 6137808
20:11:57 8020 8192000000 10793627696 11226882048 1886716608 18.719 100 29 58 2 1902755648 8105088 7933952
20:12:13 13916 8192000000 10783887968 11224825856 1887393408 18.725 100 20 40 1 1899339424 5843104 6102912
20:12:35 8102 8192000000 10806125216 11231707136 1889284176 18.740 100 24 48 0 1901415392 4968352 7162864
20:12:50 10098 8192000000 10798589200 11236065280 1891688240 18.759 100 26 51 2 1910695536 11360128 7647168
20:13:12 6381 8192000000 10801905664 11236765696 1894069360 18.779 100 22 44 1 1907189872 7193904 5926608
20:13:34 12425 8192000000 10809168224 11240448000 1898315280 18.813 100 24 48 1 1911821120 6312704 7193136
20:13:55 40274 8192000000 10831200320 11248361472 1900395504 18.829 100 20 41 0 1912019008 5127504 6496000
20:14:48 21453 8192000000 10845870464 11257487360 1909885952 18.906 100 59 120 4 1932607440 5529712 17191776
20:15:16 8619 8192000000 10820918672 11256463360 1907408560 18.886 100 27 54 1 1922639856 7433248 7798048
20:15:31 5095 8192000000 10830385632 11255164928 1890831696 18.752 99 38 78 0 1908295120 7135840 10327584
20:15:43 7187 8192000000 10824379904 11258368000 1903684384 18.856 100 31 63 0 1919271040 6691360 8895296
20:15:58 7436 8192000000 10826071408 11255967744 1906635008 18.880 100 34 66 2 1923356032 7518016 9203008
20:16:11 5907 8192000000 10815276560 11260551168 1909966320 18.906 100 33 66 1 1926719408 7368016 9385072
20:16:26 4302 8192000000 10812998896 11237580800 1879140960 18.658 99 31 62 2 1894640960 7028208 8471792
20:16:37 9125 8192000000 10794207008 11226656768 1869464352 18.580 99 20 39 2 1881187776 5972048 5751376
20:16:52 4709 8192000000 10813971664 11243036672 1888280288 18.732 100 34 68 0 1905010720 6998848 9731584
20:17:05 4840 8192000000 10806523344 11241123840 1896817696 18.801 100 33 66 1 1912453168 5057920 10577552
20:17:19 7722 8192000000 10773760688 11203371008 1850177904 18.424 98 22 44 1 1862253808 5572736 6503168
20:17:34 10305 8192000000 10780121296 11204734976 1807544704 18.076 96 22 44 1 1819685536 5540896 6599936
20:17:50 56545 8192000000 10722642704 11128033280 1691538192 17.114 91 30 58 1 1704197776 4581024 8078560
20:19:03 9786 8192000000 10719065280 11136065536 1749067424 17.594 96 13 26 1 1758199728 5334304 3798000
20:19:22 5406 8192000000 10690529392 11102490624 1755237088 17.645 97 38 74 2 1772108560 6762384 10109088
20:19:37 8370 8192000000 10703194576 11122479104 1732211520 17.454 96 29 58 3 1746496928 5981424 8303984
20:19:54 6099 8192000000 10696699424 11110281216 1743603424 17.549 97 36 73 0 1760977952 7373872 10000656
20:20:07 3437 8192000000 10703825744 11116388352 1770305968 17.770 98 43 86 2 1789964336 7184032 12474336
20:20:17 5658 8192000000 10724351872 11143569408 1799839248 18.013 100 24 48 3 1812644144 6234992 6569904
20:20:29 7328 8192000000 10716157760 11123118080 1773286272 17.794 99 20 40 1 1784209840 5356464 5567104
20:20:42 10145 8192000000 10718474032 11130912768 1763830288 17.716 98 30 60 0 1777751632 4988656 8932688
20:20:58 6465 8192000000 10717677856 11133476864 1802304144 18.033 100 30 60 2 1821067088 10712240 8050704
20:21:11 6545 8192000000 10715046096 11131252736 1779248704 17.843 99 35 70 0 1796416064 7073568 10093792
20:21:24 10879 8192000000 10707721264 11129823232 1781826992 17.865 99 22 44 1 1798211648 9869472 6515184
20:21:41 10832 8192000000 10748026944 11161948160 1821998576 18.194 100 29 57 2 1835646048 4963184 8684288
20:21:58 10092 8192000000 10733226064 11150467072 1789727712 17.930 98 18 36 0 1799869744 4770160 5371872
20:22:16 62424 8192000000 10767344816 11159552000 1781955072 17.866 97 59 118 1 1805017120 5735808 17326240
20:23:25 7213 8192000000 10744183120 11164905472 1828103376 18.244 100 22 44 1 1841206608 7057488 6045744
20:23:40 8238 8192000000 10749749664 11173527552 1835707056 18.306 100 25 48 1 1848643120 5207600 7728464
20:23:56 11008 8192000000 10747949472 11164663808 1822822336 18.201 99 32 65 0 1838566704 6032640 9711728
20:24:15 8288 8192000000 10761603072 11186081792 1845902464 18.389 100 27 52 1 1859794768 5518000 8374304
20:24:29 6668 8192000000 10766633904 11193204736 1856068352 18.471 100 35 68 5 1872654752 6102832 10483568
20:24:43 5915 8192000000 10771750544 11196403712 1857606976 18.484 100 31 62 1 1872656992 5286336 9763680
20:24:55 7815 8192000000 10774030032 11196624896 1858351568 18.490 100 29 58 0 1872883856 6234016 8298272
20:25:11 8758 8192000000 10774865632 11201351680 1859210288 18.497 100 19 38 1 1869289840 5037824 5041728
20:25:27 10627 8192000000 10782458368 11206946816 1862944240 18.527 100 21 42 2 1875130752 6323088 5863424
20:25:46 6553 8192000000 10796106464 11218882560 1868885856 18.575 100 26 49 2 1886710400 10201536 7623008
20:26:00 9721 8192000000 10791521792 11216187392 1869261472 18.578 100 24 48 1 1881697984 4921904 7514608
20:26:18 7342 8192000000 10785805552 11217752064 1874457872 18.620 100 21 42 2 1886043952 5674768 5911312
20:26:32 13864 8192000000 10796159184 11220930560 1877051968 18.641 100 18 36 3 1887507808 4982064 5473776
20:26:53 44145 8192000000 10791135728 11226456064 1884220368 18.699 100 33 67 1 1900259280 5689808 10349104
20:27:53 48649 8192000000 10845362160 11268034560 1912535984 18.927 100 42 84 1 1931151216 6934992 11680240
20:28:50 28780 8192000000 10856709744 11277033472 1923782544 19.017 100 49 96 0 1946433488 8854000 13796944
20:29:26 17200 8192000000 10863054720 11288313856 1933261536 19.093 100 52 104 1 1958656032 10830432 14564064
20:29:57 15132 8192000000 10860372560 11293851648 1937622704 19.128 100 42 84 1 1960932640 11313280 11996656
20:30:23 5022 8192000000 10875400304 11301556224 1946168496 19.196 100 50 96 2 1968082096 7578640 14334960
20:30:35 7539 8192000000 10883095776 11313221632 1953141328 19.251 100 50 100 1 1977053808 9328080 14584400
20:30:55 9726 8192000000 10896055088 11319029760 1956906224 19.281 100 54 106 0 1983887808 11636752 15344832
20:31:17 26079 8192000000 10901146848 11329806336 1962174768 19.323 100 56 112 1 1988186800 10789344 15222688
20:31:51 15011 8192000000 10909237872 11331170304 1968753248 19.376 100 51 100 1 1993658096 11176032 13728816
20:32:13 12059 8192000000 10917717392 11341131776 1973833056 19.416 100 53 103 2 2001363216 12440272 15089888
20:32:33 11631 8192000000 10908500768 11340935168 1976594160 19.438 100 48 96 0 2002402960 11769168 14039632
20:32:53 8817 8192000000 10909479536 11345543168 1978624112 19.454 100 50 96 1 2005155408 13069344 13461952
20:33:09 19355 8192000000 10914307568 11351355392 1981785696 19.479 100 53 106 1 2010871184 13754672 15330816
20:33:39 5582 8192000000 10934187664 11362299904 1988780608 19.534 100 54 108 3 2022258544 17019840 16458096
20:33:53 7030 8192000000 10938462960 11370835968 1994281328 19.578 100 59 118 3 2028260368 17310576 16668464
20:34:07 3366 8192000000 10941024688 11374575616 2000259168 19.625 100 62 124 1 2034887680 16835200 17793312
20:34:19 17458 8192000000 10934409792 11373162496 1982814880 19.487 99 49 97 0 2016005456 18273424 14917152
20:34:44 5614 8192000000 10948109088 11381870592 1999290256 19.617 100 52 104 2 2035418928 19679264 16449408
20:34:58 4393 8192000000 10955283216 11379372032 2001889648 19.638 100 62 122 0 2039176416 19046368 18240400
20:35:10 9441 8192000000 10949639232 11381612544 2005260384 19.664 100 62 123 1 2043726272 19369104 19096784
20:35:30 6944 8192000000 10958936560 11390119936 2008175536 19.687 100 60 120 1 2044747888 18924768 17647584
20:35:59 14806 8192000000 10953782576 11391590400 2009357952 19.696 100 52 104 1 2046858208 21568160 15932096
20:36:20 4460 8192000000 10963715184 11390640128 2007357712 19.681 100 66 132 4 2049061840 21612912 20091216
20:36:33 3468 8192000000 10945715824 11368173568 1984091536 19.497 99 65 129 1 2026715168 22597696 20025936
20:36:46 10259 8192000000 10964079232 11389489152 1998614032 19.612 100 69 137 1 2045128544 25667104 20847408
20:37:08 2005 8192000000 10952214768 11382255616 1997309040 19.602 100 50 97 4 2035103616 23602656 14191920
20:37:20 3398 8192000000 10959413968 11378737152 1986348272 19.515 99 63 126 1 2028501664 23107632 19045760
20:37:31 3535 8192000000 10962049872 11379974144 1967393936 19.365 98 85 169 2 2017454576 24140448 25920192
20:37:48 1957 8192000000 10963942928 11390296064 2003204320 19.648 100 64 128 1 2047058624 25276896 18577408
20:37:59 2155 8192000000 10969753312 11391598592 2006632624 19.675 100 87 173 4 2058399152 26333936 25432592
20:38:10 4132 8192000000 10970160048 11387064320 2001567328 19.635 100 76 150 0 2051151168 27814048 21769792
20:38:22 9600 8192000000 10969696656 11394863104 2005533824 19.666 100 72 144 0 2055265648 28253792 21478032
20:38:39 6294 8192000000 10965161232 11402993664 2013226496 19.727 100 66 132 3 2061278912 27460960 20591456
20:38:52 10890 8192000000 10953816000 11387899904 1994278720 19.578 100 59 118 1 2044520672 32075712 18166240
20:39:10 5360 8192000000 10959035360 11384918016 1995981040 19.591 100 65 130 1 2045834720 27704528 22149152
20:39:22 4408 8192000000 10966814464 11397914624 2005165840 19.663 100 65 130 0 2053697456 27940512 20591104
20:39:40 13076 8192000000 10968843264 11407671296 2011160480 19.711 100 43 86 1 2056409072 31247088 14001504
20:40:00 5360 8192000000 10979372336 11408695296 2012402640 19.720 100 70 140 0 2064214544 29859392 21952512
20:40:12 14633 8192000000 10971539568 11406725120 2013944192 19.733 100 57 114 2 2059384768 27294304 18146272
20:40:35 7455 8192000000 10961150784 11387162624 1991194096 19.553 99 67 133 1 2042176176 30150944 20831136
20:40:51 22559 8192000000 10965695712 11398934528 1988931248 19.535 99 48 97 0 2035264016 31311840 15020928
20:41:26 2598 8192000000 10955589936 11375706112 1977890784 19.448 99 66 133 2 2032078112 34660352 19526976
20:41:36 4465 8192000000 10940522144 11352444928 1948445024 19.214 98 72 144 0 2003400320 34091136 20864160
20:41:50 3518 8192000000 10960056688 11378388992 1985917824 19.512 100 81 161 1 2046594608 36481200 24195584
20:42:00 4189 8192000000 10956460224 11381440512 1991041056 19.552 100 73 146 3 2048164320 35538800 21584464
20:42:12 3282 8192000000 10965347040 11381821440 1986060272 19.513 100 79 153 0 2045658720 36643344 22955104
20:42:22 3729 8192000000 10930085248 11345027072 1948422528 19.214 98 74 148 1 2006284656 35742416 22119712
20:42:38 2389 8192000000 10972517808 11379863552 1982262672 19.483 100 90 176 3 2046854720 36329792 28262256
20:42:47 7402 8192000000 10963150864 11388223488 1987144752 19.521 100 72 143 1 2046658896 37480032 22034112
20:43:06 4929 8192000000 10937268416 11364638720 1945079216 19.187 98 55 109 1 2002116848 39952800 17084832
20:43:20 1667 8192000000 10948659568 11370057728 1969700000 19.383 100 76 152 0 2035181184 41142768 24338416
20:43:29 6356 8192000000 10934099584 11354284032 1954018384 19.258 100 50 99 2 2012365936 42530784 15816768
20:43:45 6410 8192000000 10919764208 11334332416 1929313120 19.061 99 70 139 1 1995302192 44406448 21582624
20:44:00 2146 8192000000 10952036880 11365707776 1971160496 19.395 100 85 170 1 2043995520 46319392 26515632
20:44:13 3389 8192000000 10937235184 11353268224 1952402800 19.246 100 79 159 1 2025509008 47639888 25466320
20:44:24 2364 8192000000 10948378624 11352190976 1948134576 19.212 100 80 158 3 2019501952 46846304 24521072
20:44:33 4186 8192000000 10924976144 11354644480 1951786704 19.241 100 52 104 1 2014682848 46228896 16667248
20:44:47 8697 8192000000 10890601600 11314458624 1910786128 18.913 98 49 98 3 1973780672 47243056 15751488
20:45:07 3859 8192000000 10947691904 11352850432 1948711872 19.216 100 74 145 3 2020003328 48153232 23138224
20:45:17 2823 8192000000 10951237648 11351678976 1950033008 19.227 100 85 170 4 2026075696 49763824 26278864
20:45:26 4656 8192000000 10950549440 11370618880 1961481392 19.318 100 66 132 1 2033602128 52063072 20057664
20:45:40 8864 8192000000 10919633680 11364098048 1936930096 19.122 99 36 72 0 1993918560 45404128 11584336
20:45:57 7817 8192000000 10922733776 11353714688 1936125408 19.116 99 47 94 0 1996707040 45541168 15040464
20:46:11 6548 8192000000 10940414384 11359719424 1951114112 19.235 100 53 103 4 2016479904 48336224 17029568
20:46:25 4289 8192000000 10947541264 11366375424 1953621392 19.255 100 65 130 0 2024862128 50238560 21002176
20:46:38 3643 8192000000 10960854640 11375124480 1966617888 19.359 100 74 147 0 2041339808 51640848 23081072
20:46:48 7947 8192000000 10953462112 11378323456 1965933936 19.353 100 66 132 2 2034182448 47227328 21021184
20:47:04 1664 8192000000 10963097968 11371286528 1961824496 19.321 100 90 176 0 2038389168 47296480 29268192
20:47:12 2039 8192000000 10961806688 11367780352 1944843632 19.185 99 86 165 1 2018900880 48206784 25850464
20:47:20 4889 8192000000 10933995136 11361714176 1955866704 19.273 100 49 98 1 2017886848 46233856 15786288
20:47:35 5178 8192000000 10920913536 11352260608 1941959776 19.162 100 47 93 3 2003681952 46694704 15027472
20:47:49 3495 8192000000 10925596528 11351855104 1949913872 19.226 100 55 109 0 2011728688 44845408 16969408
20:48:02 6833 8192000000 10932608384 11360571392 1950032160 19.227 100 47 94 0 2012272560 46818288 15422112
20:48:19 5124 8192000000 10939660832 11352526848 1939574528 19.143 99 67 134 0 2010413104 48619632 22218944
20:48:31 1876 8192000000 10949393888 11363115008 1939593248 19.144 99 78 156 1 2013920528 49872208 24455072
20:48:39 6838 8192000000 10953123904 11372269568 1955302496 19.269 100 69 139 0 2033547664 56114160 22131008
20:48:57 1529 8192000000 10963564944 11377840128 1958559712 19.295 100 78 155 0 2042516736 58462656 25494368
20:49:10 11940 8192000000 10960526768 11387822080 1958041152 19.290 100 55 110 1 2037115008 60481696 18592160
20:49:31 17973 8192000000 10952652864 11401252864 1962955056 19.330 100 35 69 1 2034428976 59430368 12043552
20:49:59 15451 8192000000 10968232560 11405250560 1974510400 19.421 100 42 83 0 2046098848 57103536 14484912
20:50:38 15345 8192000000 10937956832 11374645248 1954757648 19.264 99 32 62 2 2012382976 46956960 10668368
20:51:44 22079 8192000000 10954179680 11412766720 1979693552 19.462 100 34 68 1 2036632160 45811184 11127424
20:52:22 19523 8192000000 10923152080 11374010368 1917200064 18.964 97 29 58 1 1974006864 46905424 9901376
20:52:48 10947 8192000000 10928683104 11378532352 1934882752 19.106 99 31 62 0 1994034544 48910816 10240976
20:53:10 19946 8192000000 10928935872 11377668096 1923724864 19.017 98 36 70 2 1986091136 50171472 12194800
20:53:53 7464 8192000000 10938127504 11388964864 1954153680 19.260 100 31 62 0 2021004256 55687808 11162768
20:54:22 32931 8192000000 10918357456 11397885952 1956946272 19.282 100 20 40 2 2019867040 55168656 7752112
20:55:38 27953 8192000000 10894542160 11356291072 1913314608 18.933 99 15 30 0 1964817712 46082544 5420560
20:56:13 13800 8192000000 10911588112 11371868160 1946456016 19.198 100 24 48 0 1995988032 41545664 7986352
20:56:36 28224 8192000000 10862722432 11324936192 1910350752 18.909 98 11 22 1 1929791312 16325376 3115184
20:57:11 58138 8192000000 10871108512 11323736064 1919991104 18.987 98 25 51 1 1937917152 10293536 7632512
20:58:16 98020 8192000000 10874987376 11332952064 1863669840 18.533 95 30 60 1 1885032528 13515328 7847360
21:00:20 16898 8192000000 10876819008 11339214848 1953778112 19.257 100 25 50 0 1972513952 12172896 6562944
21:00:43 52176 8192000000 10884061888 11349241856 1954015680 19.258 100 11 22 0 1968283232 11738432 2529120
21:01:59 67639 8192000000 10883439840 11348873216 1947445152 19.206 99 14 28 1 1960962848 8950416 4567280
21:03:14 67479 8192000000 10879889968 11339923456 1905216832 18.868 97 25 52 2 1920785744 8281424 7287488
21:04:40 69113 8192000000 10908906496 11364085760 1972714560 19.407 100 26 52 1 1991670944 11655584 7300800
21:05:59 60860 8192000000 10894813136 11345096704 1934951840 19.106 98 26 50 1 1950265088 8353312 6959936
21:07:10 86671 8192000000 10867737728 11340152832 1927259648 19.045 98 11 22 1 1939068576 8468480 3340448
21:08:59 51765 8192000000 10880843984 11344658432 1925268752 19.029 98 12 24 0 1941696784 12442256 3985776
21:09:57 82274 8192000000 10878921952 11349868544 1959956320 19.306 100 30 60 2 1981676800 12746224 8974256
21:11:37 48194 8192000000 10913393568 11357896704 1958718048 19.296 99 45 90 0 1978929552 7996864 12214640
21:12:33 75878 8192000000 10896926464 11371368448 1967039216 19.362 99 41 82 0 1991879136 13203648 11636272
21:13:59 22222 8192000000 10894238272 11372773376 1977290128 19.443 100 6 12 1 1990556816 11440320 1826368
21:14:31 3311 8192000000 10910444928 11375837184 1982269904 19.483 100 20 39 2 1997974288 9396192 6308192
21:14:41 25651 8192000000 10887382064 11362140160 1944139312 19.180 98 15 30 0 1957834880 9245824 4449744
21:15:25 31634 8192000000 10937490400 11390513152 1990924416 19.551 100 38 76 0 2011286160 9124432 11237312
21:16:08 18802 8192000000 10938568656 11397701632 2006916992 19.677 100 44 87 2 2031476704 12266128 12293584
21:16:35 72164 8192000000 10912376560 11395940352 1983904128 19.496 99 18 36 0 1998560128 9345088 5310912
21:18:02 36393 8192000000 10898817536 11385933824 1974484784 19.421 99 8 16 0 1988342464 11304496 2553184
21:19:01 108413 8192000000 10917742160 11388149760 1992510832 19.564 100 15 28 1 2003834912 7388960 3935120
21:20:57 57442 8192000000 10917295808 11391258624 1986464896 19.516 99 33 66 1 2005237616 9317888 9454832
21:22:41 60329 8192000000 10906170368 11400396800 1972941536 19.409 99 4 8 0 1982601984 8749104 911344
21:23:47 42007 8192000000 10919217296 11400646656 1979098544 19.458 99 26 52 3 1999034496 12357712 7578240
21:24:37 91157 8192000000 10915094384 11412471808 1970713696 19.391 99 5 10 0 1988669136 16687312 1268128
21:26:25 59022 8192000000 10916138384 11379064832 1914724704 18.945 96 20 41 3 1930744304 10026016 5993584
21:27:30 46717 8192000000 10869978016 11330785280 1804908176 18.054 91 27 54 0 1823021056 10712608 7400272
21:28:23 61775 8192000000 10874337312 11339964416 1879548336 18.661 97 18 34 4 1898488032 14450800 4488896
21:29:31 46549 8192000000 10872417456 11362148352 1913697152 18.936 98 16 32 2 1935658176 17372128 4588896
21:30:24 132898 8192000000 10857491104 11326992384 1747396160 17.580 89 8 16 0 1759292048 10004624 1891264
21:32:43 90190 8192000000 10866759056 11320754176 1839946352 18.340 95 13 26 0 1856986768 13584384 3456032
21:34:24 46707 8192000000 10875899056 11334418432 1913492208 18.935 99 34 67 0 1935825728 13463072 8870448
21:37:36 71746 8192000000 10886322672 11333443584 1865251920 18.546 95 28 56 0 1884984048 12001424 7730704
21:38:59 89339 8192000000 10885065136 11323445248 1920566304 18.991 99 35 70 1 1945550448 14790656 10193488
21:40:41 87895 8192000000 10880131856 11341103104 1875064656 18.625 96 30 60 2 1896211040 12997056 8149328
21:42:15 9573 8192000000 10871161056 11338354688 1942318208 19.165 100 23 46 0 1961413792 12789456 6306128
21:42:31 22921 8192000000 10863447136 11323326464 1903024832 18.851 98 21 41 2 1920665760 11175664 6465264
21:43:02 56352 8192000000 10866029680 11336560640 1943750128 19.177 100 17 34 1 1954709792 6424496 4535168
21:44:05 32135 8192000000 10832125744 11303677952 1881462320 18.677 97 8 15 1 1890610832 6764736 2383776
21:44:43 28566 8192000000 10852078784 11323015168 1917105760 18.964 99 9 18 0 1926414368 6891504 2417104
21:45:19 80500 8192000000 10867242672 11335761920 1896310992 18.797 97 12 24 1 1909996304 10378160 3307152
21:46:56 80525 8192000000 10869995040 11331006464 1902850576 18.849 97 16 32 2 1918206528 10879168 4476784
21:48:22 18636 8192000000 10871688480 11337854976 1945563344 19.191 100 16 32 1 1965976880 15490512 4923024
21:49:36 49757 8192000000 10856116832 11323752448 1872995440 18.609 96 19 39 2 1886809216 8300032 5513744
21:50:57 36882 8192000000 10880091600 11327336448 1927217632 19.045 99 41 83 0 1948635808 9371952 12046224
21:51:40 35159 8192000000 10864600576 11328929792 1927502592 19.047 99 16 32 1 1939677664 7936896 4238176
21:52:23 46619 8192000000 10863813568 11319762944 1890859280 18.753 97 24 48 0 1905298192 7764720 6674192
21:53:23 34308 8192000000 10886464128 11339481088 1948567600 19.215 100 41 82 1 1971005328 9836496 12601232
21:54:08 78186 8192000000 10894451728 11365728256 1959692128 19.304 100 22 44 0 1982731584 16690384 6349072
21:55:50 54260 8192000000 10897457920 11376820224 1966983760 19.362 100 31 62 0 1993082000 17289968 8808272
21:56:57 37794 8192000000 10892676576 11351617536 1954532240 19.263 99 17 34 0 1966256656 7195632 4528784
21:57:41 60439 8192000000 10902615392 11362189312 1918666736 18.976 97 25 50 1 1933948976 8843408 6438832
21:59:01 70320 8192000000 10912753696 11376762880 1960343376 19.309 99 35 70 0 1985278416 15445216 9489824
22:00:18 42318 8192000000 10913680928 11377082368 1978592304 19.454 100 23 46 0 1998634464 13236560 6805600
22:01:10 52702 8192000000 10907120048 11369684992 1940588832 19.151 98 8 16 0 1953383040 10595136 2199072
22:02:10 140862 8192000000 10922987024 11381174272 1961527520 19.318 99 18 36 0 1986288192 20149120 4611552
22:04:37 89742 8192000000 10889918848 11354574848 1912302272 18.925 96 28 55 2 1930237392 10937760 6997360
22:06:13 83930 8192000000 10877163296 11355754496 1912328768 18.925 97 10 20 0 1927141088 11792896 3019424
22:07:44 51850 8192000000 10868879024 11348787200 1937031040 19.123 99 8 16 0 1956558416 16920256 2607120
22:09:30 37304 8192000000 10866983312 11335127040 1908802528 18.897 98 19 38 0 1923943168 9453216 5687424
22:10:13 72435 8192000000 10888676736 11361124352 1943005968 19.171 99 17 34 0 1962313088 13698400 5608720
22:11:38 79534 8192000000 10863712608 11344826368 1898424704 18.814 97 13 27 0 1919168736 16581872 4162160
22:13:03 69251 8192000000 10870686176 11331289088 1836528160 18.313 94 17 35 0 1852325152 10706304 5090688
22:14:19 53683 8192000000 10882950016 11354763264 1936554320 19.119 99 19 38 2 1954397440 12561872 5281248
22:15:21 97034 8192000000 10866412320 11338539008 1860367200 18.506 95 13 26 0 1877519472 13697616 3454656
22:17:05 93565 8192000000 10868709600 11350966272 1907108384 18.883 98 14 28 0 1927857360 15906272 4842704
22:18:50 80424 8192000000 10871373216 11328991232 1867570688 18.565 96 17 34 0 1882213984 9938688 4704608
22:20:19 36991 8192000000 10890814240 11334590464 1892863392 18.769 97 48 96 0 1919183024 12881184 13438448
22:21:08 42212 8192000000 10897564864 11360432128 1953752112 19.256 100 24 48 2 1977690528 17262816 6675600
22:22:11 148191 8192000000 10878171312 11337654272 1915266208 18.949 98 22 44 1 1941967792 21240448 5461136
22:24:48 35337 8192000000 10862193744 11314937856 1910508720 18.911 98 35 70 1 1929086416 8141184 10436512
22:25:31 65834 8192000000 10813723888 11287015424 1869305440 18.579 97 11 22 1 1880125568 7907360 2912768
22:26:42 32990 8192000000 9800130240 10157457408 924470528 10.140 48 9 18 0 931164224 4388304 2305392

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 11-01-2021 22:29:54 to 11-01-2021 22:30:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 73 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

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          242605
MON$OLDEST_ACTIVE               242606
MON$OLDEST_SNAPSHOT             242606
MON$NEXT_TRANSACTION            242606
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                       2034144
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:736: 
:737: mscs-test-161.budzdorov.ru    Mon Jan 11 22:27:28 2021
:738:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:739: 
:740: 
:741: mscs-test-161.budzdorov.ru    Mon Jan 11 22:27:31 2021
:742:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:743: 
:744: 
:745: mscs-test-161.budzdorov.ru    Mon Jan 11 22:27:35 2021
:746:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:747: 
:748: 
:749: mscs-test-161.budzdorov.ru    Mon Jan 11 22:27:35 2021
:750:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:751: 
:752: 
:753: mscs-test-161.budzdorov.ru    Mon Jan 11 22:27:36 2021
:754:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:755: 
--- end of diff output ---

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

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