Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 29.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 17051516 kB
MemAvailable 31291652 kB
Buffers 0 kB
Cached 14667348 kB
SwapCached 4868 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-29 22:27:17
DTS_END                         2021-01-29 22:27:17.2510
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/58362
TRN_ID                          252069
ATT_ID                          715
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: 9726.56 17510 1167187
customer order: creation 186.47 331 22376
customer order: refuse 15.63 328 1876
order to supplier: creation 49.53 1173 5944
order to supplier: removal 3.36 91002 403
invoice (draft): creation 48.77 2868 5852
invoice (draft): removal 52.63 701 6315
invoice accept: apply 45.15 16880 5418
invoice accept: cancel 48.18 756 5782
customer reserve: creation 4226.40 166 507168
customer reserve: removal 4732.05 51 567846
realization accept: apply 89.65 175 10758
realization accept: cancel 90.18 93 10822
payment from customer: creation 62.98 104 7557
payment from customer: removal 6.10 54 732
payment to supplier: creation 52.73 117 6327
payment to supplier: removal 3.86 55 463
service: total inventory turnovers 4.93 1096 591
service: total monetary turnovers 7.05 34 846
service: aggregate perf. data 0.89 18266 107
service: refresh index statistics 0.03 215941 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-01-2021 22:29:53 to 29-01-2021 22:29:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9471
TEST_TIME 2 7659
TEST_TIME 3 7353
TEST_TIME 4 6464
TEST_TIME 5 6253
TEST_TIME 6 5877
TEST_TIME 7 6043
TEST_TIME 8 6446
TEST_TIME 9 7207
TEST_TIME 10 7223
TEST_TIME 11 7283
TEST_TIME 12 7258
TEST_TIME 13 7132
TEST_TIME 14 7232
TEST_TIME 15 7638
TEST_TIME 16 8151
TEST_TIME 17 8310
TEST_TIME 18 8375
TEST_TIME 19 8847
TEST_TIME 20 9130
TEST_TIME 21 9338
TEST_TIME 22 9728
TEST_TIME 23 10393
TEST_TIME 24 10365
TEST_TIME 25 10652
TEST_TIME 26 11226
TEST_TIME 27 11139
TEST_TIME 28 10942
TEST_TIME 29 10977
TEST_TIME 30 11005
TEST_TIME 31 10828
TEST_TIME 32 10881
TEST_TIME 33 10850
TEST_TIME 34 10913
TEST_TIME 35 10954
TEST_TIME 36 10981
TEST_TIME 37 10970
TEST_TIME 38 10887
TEST_TIME 39 10620
TEST_TIME 40 10574
TEST_TIME 41 10510
TEST_TIME 42 10576
TEST_TIME 43 10411
TEST_TIME 44 10378
TEST_TIME 45 10321
TEST_TIME 46 10210
TEST_TIME 47 10245
TEST_TIME 48 10426
TEST_TIME 49 10330
TEST_TIME 50 10262
TEST_TIME 51 10274
TEST_TIME 52 10244
TEST_TIME 53 10191
TEST_TIME 54 10275
TEST_TIME 55 10282
TEST_TIME 56 10210
TEST_TIME 57 10365
TEST_TIME 58 10329
TEST_TIME 59 10270
TEST_TIME 60 10400
TEST_TIME 61 10395
TEST_TIME 62 10426
TEST_TIME 63 10439
TEST_TIME 64 10450
TEST_TIME 65 10470
TEST_TIME 66 10554
TEST_TIME 67 10473
TEST_TIME 68 10350
TEST_TIME 69 10376
TEST_TIME 70 10305
TEST_TIME 71 10236
TEST_TIME 72 10218
TEST_TIME 73 10190
TEST_TIME 74 10169
TEST_TIME 75 10157
TEST_TIME 76 10101
TEST_TIME 77 10079
TEST_TIME 78 10058
TEST_TIME 79 10037
TEST_TIME 80 10007
TEST_TIME 81 10021
TEST_TIME 82 9992
TEST_TIME 83 10057
TEST_TIME 84 10035
TEST_TIME 85 9999
TEST_TIME 86 10047
TEST_TIME 87 10018
TEST_TIME 88 10061
TEST_TIME 89 10045
TEST_TIME 90 10155
TEST_TIME 91 10151
TEST_TIME 92 10163
TEST_TIME 93 10111
TEST_TIME 94 10067
TEST_TIME 95 10007
TEST_TIME 96 9999
TEST_TIME 97 9979
TEST_TIME 98 9910
TEST_TIME 99 9861
TEST_TIME 100 9844
TEST_TIME 101 9851
TEST_TIME 102 9854
TEST_TIME 103 9825
TEST_TIME 104 9823
TEST_TIME 105 9840
TEST_TIME 106 9846
TEST_TIME 107 9839
TEST_TIME 108 9889
TEST_TIME 109 9869
TEST_TIME 110 9839
TEST_TIME 111 9904
TEST_TIME 112 9912
TEST_TIME 113 9897
TEST_TIME 114 9930
TEST_TIME 115 9854
TEST_TIME 116 9872
TEST_TIME 117 9850
TEST_TIME 118 9837
TEST_TIME 119 9799
TEST_TIME 120 9732

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 29-01-2021 22:29:56 to 29-01-2021 22:30:00.

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 1636581 1636581 0 0.00 0 18850 6 0 0
doc_list_biud 1636580 1636580 0 0.00 0 49282 23 0 0
sp_add_invoice_to_stock 5595 5418 177 3.16 38 230291 16881 0 177
sp_cancel_adding_invoice 5782 5782 0 0.00 5 82253 757 0 0
sp_cancel_client_order 1876 1876 0 0.00 4 15866 328 0 0
sp_cancel_customer_reserve 567846 567846 0 0.00 1 49283 52 0 0
sp_cancel_pay_from_customer 732 732 0 0.00 3 3371 55 0 0
sp_cancel_pay_to_supplier 463 463 0 0.00 3 2928 55 0 0
sp_cancel_supplier_invoice 6331 6315 16 0.25 1 37264 702 0 16
sp_cancel_supplier_order 403 403 0 0.00 8 1044296 91002 0 0
sp_cancel_write_off 10822 10822 0 0.00 1 13687 94 0 0
sp_client_order 22376 22376 0 0.00 4 45955 332 0 0
sp_customer_reserve 507168 507168 0 0.00 0 44674 166 0 0
sp_fill_shopping_cart 34165 34165 0 0.00 1 12654 35 0 0
sp_fill_shopping_cart_clo_res 507154 507154 0 0.00 0 15371 12 0 0
sp_get_clo_for_invoice 5404 5404 0 0.00 0 25626 257 0 0
sp_kill_cost_storno 17799 17799 0 0.00 0 18838 49 0 0
sp_kill_qstorno_ret_qs2qd 1153232 1153232 0 0.00 0 49280 28 0 0
sp_kill_qty_storno 609205 609205 0 0.00 0 49282 61 0 0
sp_lock_selected_doc 22222 22222 0 0.00 0 8397 6 0 0
sp_make_cost_storno 30046 30046 0 0.00 0 14081 50 0 0
sp_multiply_rows_for_pdistr 30046 30046 0 0.00 0 5377 23 0 0
sp_multiply_rows_for_qdistr 22376 22376 0 0.00 0 45937 142 0 0
sp_pay_from_customer 7557 7557 0 0.00 4 22077 104 0 0
sp_pay_to_supplier 6327 6327 0 0.00 4 12759 117 0 0
sp_payment_common 13884 13884 0 0.00 1 22070 27 0 0
sp_qd_handle_on_cancel_clo 1876 1876 0 0.00 0 15857 301 0 0
sp_qd_handle_on_invoice_upd_sts 11186 11186 0 0.00 0 22659 284 0 0
sp_qd_handle_on_reserve_upd_sts 10757 10757 0 0.00 0 19794 67 0 0
sp_reserve_write_off 10758 10758 0 0.00 6 19916 175 0 0
sp_supplier_invoice 5852 5852 0 0.00 7 78274 2868 0 0
sp_supplier_order 5944 5944 0 0.00 5 66856 1173 0 0
srv_aggregate_perf_data 108 107 1 0.92 2862 127095 18267 0 1
srv_fill_mon_cache_memory 167 167 0 0.00 1242 175117 31806 0 0
srv_find_qd_qs_mism 1115356 1115356 0 0.00 0 9279 5 0 0
srv_make_invnt_saldo 591 591 0 0.00 28 51997 1097 0 0
srv_make_money_saldo 846 846 0 0.00 0 9765 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 86462 353375 215942 0 0
t$perf-abend:sp_add_invoice_to_stock 177 177 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 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 5418 5418 0 0.00 0 13974 158 0 0
t$perf-norm:sp_cancel_adding_invoice 429 429 0 0.00 1 6896 119 0 0
t$perf-norm:sp_cancel_client_order 1876 1876 0 0.00 0 2265 11 0 0
t$perf-norm:sp_cancel_customer_reserve 699 699 0 0.00 0 2676 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 732 732 0 0.00 0 4437 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 463 463 0 0.00 0 334 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 430 430 0 0.00 0 612 11 0 0
t$perf-norm:sp_cancel_supplier_order 403 403 0 0.00 0 17105 1331 0 0
t$perf-norm:sp_cancel_write_off 1030 1030 0 0.00 0 2971 11 0 0
t$perf-norm:sp_client_order 22376 22376 0 0.00 0 5629 16 0 0
t$perf-norm:sp_customer_reserve 1064 1064 0 0.00 0 384 4 0 0
t$perf-norm:sp_pay_from_customer 7557 7557 0 0.00 0 4789 9 0 0
t$perf-norm:sp_pay_to_supplier 6327 6327 0 0.00 0 5162 10 0 0
t$perf-norm:sp_reserve_write_off 10758 10758 0 0.00 0 4103 10 0 0
t$perf-norm:sp_supplier_invoice 5852 5852 0 0.00 0 7957 25 0 0
t$perf-norm:sp_supplier_order 5944 5944 0 0.00 0 8565 19 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 194 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 2400 16 0 0
t$perf-norm:srv_make_invnt_saldo 591 591 0 0.00 0 5775 26 0 0
t$perf-norm:srv_make_money_saldo 846 846 0 0.00 0 2770 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 11160 10806 354 3.17 0 6989 21 0 354
v_all_customers 40384 40384 0 0.00 0 25 1 0 0
v_all_suppliers 32770 32770 0 0.00 0 22 1 0 0
v_all_wares 44750 44750 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 858 858 0 0.00 0 5455 18 0 0
v_cancel_client_order 3752 3752 0 0.00 0 6504 6 0 0
v_cancel_customer_prepayment 1464 1464 0 0.00 0 3366 6 0 0
v_cancel_customer_reserve 1398 1398 0 0.00 0 1919 5 0 0
v_cancel_payment_to_supplier 926 926 0 0.00 0 531 3 0 0
v_cancel_supplier_invoice 892 860 32 3.58 0 6223 21 0 32
v_cancel_supplier_order 806 806 0 0.00 0 3590 8 0 0
v_cancel_write_off 2060 2060 0 0.00 0 4429 19 0 0
v_max_id_clo_ord 5941 5941 0 0.00 0 2110 2 0 0
v_max_id_clo_res 1064 1064 0 0.00 0 3775 17 0 0
v_max_id_ord_sup 5848 5848 0 0.00 0 5328 6 0 0
v_max_non_paid_invoice 1731 1731 0 0.00 0 3268 4 0 0
v_max_non_paid_realizn 4105 4105 0 0.00 0 1520 3 0 0
v_min_id_clo_ord 5941 5941 0 0.00 0 3510 4 0 0
v_min_id_clo_res 1064 1064 0 0.00 0 5226 10 0 0
v_min_id_ord_sup 5848 5848 0 0.00 0 8794 6 0 0
v_min_non_paid_invoice 6326 6326 0 0.00 0 6519 15 0 0
v_min_non_paid_realizn 7557 7557 0 0.00 0 22066 19 0 0
v_our_firm 11270 11270 0 0.00 0 17 1 0 0
v_reserve_write_off 21514 21514 0 0.00 0 6532 7 0 0
x_lock_depdocs_on_canc_invoice 11667 11667 0 0.00 0 13747 96 0 0
x_lock_depdocs_on_canc_sup_ord 403 403 0 0.00 0 14390 307 0 0
x_make_qstorno_1000_1200 5944 5944 0 0.00 2 66841 1105 0 0
x_make_qstorno_1200_2000 5852 5852 0 0.00 3 78242 2740 0 0
x_make_qstorno_2100_3300 507168 507168 0 0.00 0 44672 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-01-2021 22:30:01 to 29-01-2021 22:30:05.

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:21 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:27 16499 8192000000 10251391760 10560954368 992582768 10.807 76 62 124 1 1015621808 2805616 20233424
19:57:53 34970 8192000000 10365097136 10683875328 1393358176 14.536 100 86 172 0 1426344544 4872016 28114352
19:58:42 16552 8192000000 10390782528 10711818240 1435755104 14.912 100 90 180 0 1472740688 7128032 29857552
19:59:09 19411 8192000000 10397297488 10726129664 1456064096 15.091 100 88 176 0 1493101792 8065376 28972320
19:59:42 24100 8192000000 10419307872 10749980672 1470721984 15.220 100 87 174 0 1507307808 8288336 28297488
20:00:15 23878 8192000000 10435957472 10768220160 1487164016 15.364 100 83 166 0 1523261328 9180720 26916592
20:00:54 15305 8192000000 10454151168 10791309312 1509698928 15.561 100 84 168 4 1546248560 9669072 26880560
20:01:18 8875 8192000000 10466283456 10810044416 1531717536 15.752 100 82 164 0 1567618272 9401760 26498976
20:01:38 18290 8192000000 10502977104 10850492416 1563063072 16.023 100 87 174 2 1599985536 10445552 26476912
20:02:05 17005 8192000000 10539622592 10893012992 1593463776 16.283 100 82 162 0 1628833792 10911296 24458720
20:02:29 9535 8192000000 10562148000 10918850560 1618345648 16.496 100 82 164 2 1654156464 11061008 24749808
20:02:46 13477 8192000000 10584000000 10942627840 1639434064 16.675 100 87 174 1 1676924656 11479504 26011088
20:03:07 11453 8192000000 10603934112 10972467200 1660626176 16.854 100 81 162 0 1696202880 12044512 23532192
20:03:29 7960 8192000000 10630964240 10995728384 1685669776 17.065 100 85 168 0 1723572736 13510384 24392576
20:03:46 9056 8192000000 10640483424 11009916928 1701212528 17.195 100 91 182 2 1741500480 13996384 26291568
20:04:01 6493 8192000000 10656130736 11022848000 1717889328 17.335 100 88 176 0 1757409136 14273712 25246096
20:04:16 7810 8192000000 10662781696 11034435584 1725554912 17.398 100 85 170 3 1764012112 14343072 24114128
20:04:31 5376 8192000000 10671402400 11045625856 1734692688 17.475 100 80 160 2 1771196224 13741472 22762064
20:04:44 4857 8192000000 10689752592 11061760000 1747081648 17.577 100 82 166 1 1782538096 12260704 23195744
20:04:56 4189 8192000000 10694658992 11070279680 1753021808 17.627 100 81 160 0 1788405520 12790128 22593584
20:05:07 2972 8192000000 10699158544 11076857856 1759186352 17.678 100 82 164 2 1796692400 12992480 24513568
20:05:18 5509 8192000000 10708172560 11086176256 1762922400 17.709 100 75 148 0 1797022240 12800624 21299216
20:05:32 2649 8192000000 10719286672 11096301568 1775288976 17.811 100 84 168 1 1813105888 14152768 23664144
20:05:41 2992 8192000000 10725041072 11107377152 1784873104 17.890 100 83 166 0 1824801616 17255472 22673040
20:05:51 2765 8192000000 10728258528 11108294656 1788414624 17.919 100 87 172 2 1825201440 12882768 23904048
20:06:00 4972 8192000000 10736758080 11121037312 1798967952 18.005 100 75 150 2 1832091104 11839456 21283696
20:06:12 2040 8192000000 10750491776 11131269120 1812555280 18.117 100 93 187 0 1850061824 11111376 26395168
20:06:21 1860 8192000000 10758059408 11140538368 1819642048 18.175 100 85 169 0 1855351184 11933696 23775440
20:06:30 3846 8192000000 10749224032 11139051520 1817580864 18.158 100 76 152 0 1850550944 12308672 20661408
20:06:40 4129 8192000000 10759621872 11143680000 1825714912 18.224 100 82 163 2 1861252288 13046048 22491328
20:06:50 2321 8192000000 10782035584 11168104448 1840098656 18.342 100 86 172 0 1877088608 12637792 24352160
20:06:59 2011 8192000000 10785985056 11172765696 1846011520 18.390 100 90 180 0 1885515440 13519504 25984416
20:07:07 1437 8192000000 10793367760 11178545152 1852095552 18.439 100 93 184 2 1891192272 13297904 25798816
20:07:15 1453 8192000000 10795350160 11181670400 1854351312 18.457 100 90 178 0 1893305696 13999488 24954896
20:07:23 1949 8192000000 10793039920 11186675712 1857453376 18.483 100 85 167 2 1892533168 11655232 23424560
20:07:31 1111 8192000000 10809239088 11195715584 1861095584 18.512 100 96 189 2 1902101056 14111248 26894224
20:07:38 1893 8192000000 10798760608 11191316480 1861308768 18.514 100 93 187 2 1901812112 13539520 26963824
20:07:47 19970 8192000000 10785145984 11192107008 1860525936 18.508 100 66 134 1 1890692176 11823264 18342976
20:08:13 22819 8192000000 10786622128 11200192512 1864831632 18.542 100 41 82 0 1884321760 8048704 11441424
20:08:43 1546 8192000000 10826784304 11218583552 1880538528 18.669 100 90 179 3 1916496464 11067328 24890608
20:08:51 8008 8192000000 10820411584 11219779584 1882306800 18.684 100 75 148 2 1913978688 11127984 20543904
20:09:06 4273 8192000000 10801069040 11218485248 1876969968 18.641 100 55 110 1 1908520432 16318192 15232272
20:09:17 2921 8192000000 10795238432 11212976128 1878167440 18.650 100 49 98 0 1899844160 7603824 14072896
20:09:27 5736 8192000000 10790890688 11210694656 1880797648 18.672 100 31 62 0 1896758736 7528864 8432224
20:09:41 3857 8192000000 10808221904 11216580608 1880454304 18.669 100 45 92 1 1900661776 7571872 12635600
20:09:51 5575 8192000000 10792973392 11215577088 1879660736 18.662 100 38 76 2 1899301520 9043312 10597472
20:10:05 7585 8192000000 10790068512 11217063936 1879484224 18.661 100 29 58 1 1894878144 7458768 7935152
20:10:20 9398 8192000000 10792599104 11216052224 1877682688 18.646 100 17 34 0 1888910352 6085200 5142464
20:10:37 4935 8192000000 10800396928 11219279872 1882717232 18.687 100 23 46 0 1896095664 7038016 6340416
20:10:49 8715 8192000000 10792286176 11222032384 1887182112 18.723 100 25 50 3 1900079392 5672976 7224304
20:11:06 5472 8192000000 10787603984 11223318528 1886976464 18.721 100 24 49 0 1903961536 10456896 6528176
20:11:18 10453 8192000000 10792577104 11223654400 1885920768 18.713 100 11 22 0 1894285648 5328048 3036832
20:11:37 15614 8192000000 10783787904 11225034752 1886806240 18.720 100 14 28 0 1896103792 5433040 3864512
20:12:00 20155 8192000000 10806590784 11232464896 1893944144 18.778 100 30 60 2 1909254368 5675808 9634416
20:12:27 75020 8192000000 10812811392 11248889856 1897751200 18.808 100 35 71 0 1917652816 9535296 10366320
20:13:53 3958 8192000000 10828541424 11254915072 1901503616 18.838 100 45 90 1 1921198192 7033808 12660768
20:14:04 6462 8192000000 10819981904 11250278400 1898518384 18.814 100 28 54 1 1913383552 7152352 7712816
20:14:18 3894 8192000000 10829410416 11250819072 1901165392 18.836 100 35 71 0 1918156944 6798144 10193408
20:14:31 7317 8192000000 10822881568 11251372032 1905301680 18.869 100 38 76 1 1923558672 7193984 11063008
20:14:48 7512 8192000000 10826410224 11257925632 1902774800 18.849 100 23 45 2 1914976208 5684352 6517056
20:15:02 9403 8192000000 10812717280 11251560448 1904282256 18.861 100 23 45 1 1916534224 5717392 6534576
20:15:21 5081 8192000000 10811198992 11247812608 1900720336 18.832 100 25 50 0 1914182240 6232704 7229200
20:15:32 8580 8192000000 10804832112 11240878080 1878659184 18.654 99 11 21 1 1887476272 5823840 2993248
20:15:48 6180 8192000000 10790371152 11226669056 1858142304 18.488 98 31 62 4 1874931104 6550848 10237952
20:16:01 7257 8192000000 10797499584 11227160576 1867238496 18.562 99 21 40 1 1879308576 5781056 6289024
20:16:16 11598 8192000000 10787137952 11221774336 1872592816 18.605 99 27 51 2 1885873808 5482528 7798464
20:16:37 13511 8192000000 10760968384 11195047936 1812158912 18.114 97 9 18 1 1819792752 5130976 2502864
20:16:56 52181 8192000000 10782927360 11200819200 1810378880 18.099 97 33 64 5 1825692160 5816576 9496704
20:17:56 18783 8192000000 10782065968 11180630016 1840186624 18.342 99 62 122 2 1865254032 5526064 19541344
20:18:21 17269 8192000000 10722459728 11143933952 1711963520 17.285 93 19 38 1 1726992016 9882256 5146240
20:18:44 6090 8192000000 10731250848 11138285568 1768855888 17.758 97 37 74 1 1787281968 7949536 10476544
20:18:58 6929 8192000000 10695554320 11108962304 1716899232 17.326 94 29 57 3 1731058304 6131168 8027904
20:19:13 7049 8192000000 10709329776 11123982336 1776368032 17.820 99 38 75 2 1793702608 5728656 11605920
20:19:26 7512 8192000000 10677750064 11084083200 1694346256 17.138 95 21 42 2 1709892528 9995184 5551088
20:19:40 6502 8192000000 10691437744 11105820672 1752750208 17.624 98 36 72 2 1770789600 7368624 10670768
20:19:52 3237 8192000000 10702457488 11109924864 1782734672 17.872 100 48 94 5 1801963200 5554448 13674080
20:20:03 7507 8192000000 10710763328 11126312960 1794465168 17.968 100 28 56 3 1808190480 4978160 8747152
20:20:18 6856 8192000000 10713078048 11123044352 1780011776 17.850 99 37 74 2 1800980944 9856128 11113040
20:20:33 7370 8192000000 10692110416 11102396416 1743320672 17.546 97 23 45 2 1755415488 5570352 6524464
20:20:49 9389 8192000000 10705334336 11107930112 1746830800 17.575 97 31 60 0 1761798704 4879760 10088144
20:21:04 8336 8192000000 10718139536 11122212864 1779560992 17.846 99 31 62 2 1793876656 5119824 9195840
20:21:23 60155 8192000000 10724672560 11146362880 1794279600 17.967 99 32 64 2 1810200832 5523248 10397984
20:22:30 10041 8192000000 10739531008 11158253568 1824575376 18.215 100 23 46 0 1837507696 5971760 6960560
20:22:48 6662 8192000000 10754699392 11169927168 1840296208 18.343 100 43 86 0 1860218608 7793856 12128544
20:23:02 9202 8192000000 10761115216 11181645824 1839967376 18.341 100 32 64 0 1859809808 11186752 8655680
20:23:20 4461 8192000000 10755868672 11181146112 1843912400 18.373 100 30 58 2 1858503440 5815216 8775824
20:23:33 11428 8192000000 10781848864 11190853632 1848105520 18.407 100 35 68 4 1868548544 10712016 9731008
20:23:53 5506 8192000000 10777935952 11190890496 1853247744 18.448 100 36 72 5 1869877936 6203200 10426992
20:24:08 10888 8192000000 10765537552 11192606720 1846834432 18.396 100 22 46 1 1862895088 9722672 6337984
20:24:27 8865 8192000000 10759941712 11188424704 1850866768 18.429 100 17 34 0 1861366960 5637936 4862256
20:24:44 8880 8192000000 10767900672 11194458112 1851238112 18.432 100 20 41 2 1861599680 5006736 5354832
20:25:01 6930 8192000000 10761474336 11189710848 1856525264 18.475 100 22 43 1 1867963440 5716352 5721824
20:25:14 16057 8192000000 10762723024 11193315328 1856210528 18.473 100 16 31 1 1866343776 5515888 4617360
20:25:38 13392 8192000000 10785521376 11202752512 1859132240 18.496 100 17 34 1 1869268960 5701856 4434864
20:25:58 70036 8192000000 10788234480 11215667200 1873252912 18.611 100 42 81 2 1892613360 5826256 13534192
20:27:14 8502 8192000000 10829077936 11244695552 1891883712 18.761 100 36 72 0 1911969504 10154288 9931504
20:27:30 6977 8192000000 10829963632 11254575104 1904589664 18.863 100 38 76 0 1922221424 6843520 10788240
20:27:45 21550 8192000000 10852805680 11269570560 1920498000 18.991 100 53 106 0 1943707168 8716256 14492912
20:28:15 14227 8192000000 10861107952 11277430784 1923019888 19.011 100 55 110 0 1951661264 13663504 14977872
20:28:38 14878 8192000000 10867182752 11287896064 1932129232 19.084 100 51 102 2 1959080096 11640944 15309920
20:29:02 20448 8192000000 10867311312 11293605888 1936882592 19.122 100 49 98 1 1961949120 11569712 13496816
20:29:33 10032 8192000000 10885011072 11303964672 1941239168 19.157 100 43 86 3 1965373696 11264864 12869664
20:29:51 5266 8192000000 10887070416 11313242112 1953322384 19.253 100 61 121 0 1988424912 16679248 18423280
20:30:09 6638 8192000000 10877450000 11299225600 1937622832 19.128 99 59 118 0 1972671744 17791968 17256944
20:30:23 10648 8192000000 10891147728 11312410624 1953898896 19.258 100 56 112 1 1983288160 13020832 16368432
20:30:41 8968 8192000000 10887894416 11315183616 1957390048 19.285 100 63 123 1 1989514992 13845136 18279808
20:31:28 33951 8192000000 10891330896 11329658880 1958828752 19.297 100 38 76 0 1983628256 13463104 11336400
20:32:13 34226 8192000000 10890754848 11328929792 1946797376 19.201 99 29 58 2 1968661216 12912272 8951568
20:32:55 29222 8192000000 10897362176 11338407936 1952497424 19.246 99 33 66 1 1979652944 17270896 9884624
20:33:37 12909 8192000000 10932116208 11357618176 1975717680 19.431 100 41 82 2 2007977968 19679296 12580992
20:34:03 9075 8192000000 10913972080 11343138816 1974486720 19.421 100 43 85 2 2007767056 20355568 12924768
20:34:23 11497 8192000000 10919270976 11348578304 1973138256 19.410 100 53 105 2 2008103440 18751776 16213408
20:34:41 2743 8192000000 10932933680 11354075136 1982322896 19.483 100 67 132 1 2021569040 19662224 19583920
20:34:51 7233 8192000000 10950169792 11362910208 1984130368 19.497 100 71 141 1 2031272480 26253920 20888192
20:35:15 2064 8192000000 10926030832 11331895296 1952672912 19.248 98 83 166 0 2002638800 25064224 24901664
20:35:24 3292 8192000000 10942261104 11360698368 1977941104 19.448 100 77 153 2 2027394080 26964880 22488096
20:35:34 3895 8192000000 10947091440 11364343808 1970469776 19.389 99 81 161 2 2021551728 27640656 23441296
20:35:45 15508 8192000000 10943980256 11365650432 1984856096 19.503 100 68 136 0 2034210032 29577200 19776736
20:36:08 5167 8192000000 10945382016 11374936064 1988908208 19.535 100 65 128 2 2038053968 29943376 19202384
20:36:19 4348 8192000000 10948425168 11378688000 1993525984 19.572 100 63 126 0 2039411424 26741152 19144288
20:36:31 1477 8192000000 10962855264 11372097536 1979492224 19.461 99 85 171 2 2029980560 25282288 25206048
20:36:40 3882 8192000000 10931472848 11349626880 1952464784 19.246 98 73 145 2 1998795872 25736288 20594800
20:36:51 5325 8192000000 10940399040 11357523968 1959848224 19.305 99 67 130 1 2004936720 26492544 18595952
20:37:03 5704 8192000000 10937098880 11357065216 1970210416 19.387 100 71 141 1 2018480128 27824080 20445632
20:37:18 7634 8192000000 10918962736 11339767808 1939009008 19.139 98 62 120 1 1985378096 28650160 17718928
20:37:33 4957 8192000000 10928920640 11349110784 1955137136 19.267 99 74 144 0 2005756544 28959808 21659600
20:37:47 3333 8192000000 10934182192 11345797120 1960515696 19.310 99 83 164 1 2015113808 30099056 24499056
20:38:00 2990 8192000000 10935974992 11344334848 1963104512 19.331 100 82 163 0 2018092864 30718096 24270256
20:38:11 1399 8192000000 10936829920 11352444928 1970118960 19.386 100 88 172 2 2025960848 30815328 25026560
20:38:27 5792 8192000000 10939031072 11362779136 1975183936 19.427 100 70 141 1 2028603072 31945648 21473488
20:38:42 11882 8192000000 10948614464 11378884608 1985691136 19.510 100 62 122 1 2039020144 34281872 19047136
20:39:02 6041 8192000000 10956400496 11370799104 1977755136 19.447 100 71 142 1 2032881184 33469440 21656608
20:39:15 2490 8192000000 10954283264 11377369088 1988400032 19.531 100 72 145 0 2044792288 32473472 23918784
20:39:25 5707 8192000000 10940699088 11352244224 1963660224 19.335 99 71 142 1 2019714960 34594144 21460592
20:39:40 4128 8192000000 10938934928 11360403456 1970285680 19.388 100 60 120 1 2024408208 35408576 18713952
20:39:53 10487 8192000000 10941199136 11369623552 1976343696 19.436 100 48 96 2 2028166320 36268112 15554512
20:40:12 6954 8192000000 10936914592 11348873216 1961894608 19.321 99 71 141 1 2018473616 35180016 21398992
20:40:26 3581 8192000000 10926318832 11340124160 1952359920 19.245 99 77 154 1 2012687808 36943856 23384032
20:40:38 4205 8192000000 10951513520 11361976320 1970020592 19.386 100 78 156 0 2032041760 38427136 23594032
20:40:52 2195 8192000000 10925022928 11337166848 1922757840 19.009 98 75 150 2 1985370384 39812464 22800080
20:41:01 3682 8192000000 10943402960 11357351936 1961020544 19.314 100 76 151 0 2025825920 41495920 23309456
20:41:11 3136 8192000000 10942023360 11351199744 1945206160 19.188 99 79 158 2 2013176288 43361296 24608832
20:41:21 2798 8192000000 10938255552 11357106176 1945048992 19.187 99 83 164 1 2014799376 43215056 26535328
20:41:30 2863 8192000000 10932715120 11343294464 1954538560 19.263 100 91 182 0 2027286144 43731584 29016000
20:41:42 3573 8192000000 10953270864 11366469632 1961978016 19.322 100 75 150 2 2034820848 49372592 23470240
20:41:53 2179 8192000000 10947428208 11351851008 1957678336 19.288 100 91 182 1 2032152832 46438528 28035968
20:42:03 4569 8192000000 10953401776 11359121408 1957321888 19.285 100 83 166 1 2031961920 48526000 26114032
20:42:15 2472 8192000000 10960772480 11368108032 1964268432 19.340 100 82 162 1 2037597376 47839232 25489712
20:42:26 2583 8192000000 10937531616 11345555456 1940649296 19.152 99 76 150 0 2011838608 48025856 23163456
20:42:35 9277 8192000000 10946864016 11363397632 1959625392 19.303 100 76 152 0 2030406128 47609248 23171488
20:42:57 3684 8192000000 10968315056 11374981120 1971841328 19.400 100 86 172 2 2044907600 46743808 26322464
20:43:07 4969 8192000000 10929370896 11338301440 1904528080 18.863 97 78 156 0 1974998128 46724576 23745472
20:43:19 1238 8192000000 10935806208 11339358208 1930734304 19.073 99 90 179 2 2005589104 47721456 27133344
20:43:27 4783 8192000000 10923327648 11323256832 1919732896 18.985 99 82 164 1 1986251536 40879216 25639424
20:43:43 2439 8192000000 10877484208 11293196288 1887899664 18.729 98 67 135 1 1950901776 42452736 20549376
20:43:52 12100 8192000000 10893895408 11325038592 1925352944 19.030 100 54 108 0 1985661920 42918864 17390112
20:44:16 10267 8192000000 10890016880 11313758208 1904669600 18.864 99 49 95 0 1960115520 39748944 15696976
20:44:35 1506 8192000000 10906988512 11320885248 1922255664 19.005 100 68 136 0 1988210064 44354768 21599632
20:44:43 5659 8192000000 10913676848 11336167424 1926409664 19.038 100 61 120 0 1993432768 47848896 19174208
20:44:58 8969 8192000000 10892113856 11327897600 1908859760 18.897 99 41 81 4 1968998400 46280880 13857760
20:45:17 10150 8192000000 10893276736 11325792256 1911277280 18.917 99 46 92 3 1974731072 47680512 15773280
20:45:36 12620 8192000000 10907698192 11330899968 1928409104 19.054 100 53 106 2 1993064160 47583120 17071936
20:45:56 9943 8192000000 10904244608 11338727424 1935002016 19.107 100 53 106 0 2000724688 48644000 17078672
20:46:18 5652 8192000000 10913917872 11348492288 1926208432 19.037 99 46 91 1 1991346112 49773264 15364416
20:46:35 8791 8192000000 10908709552 11351302144 1936885040 19.122 100 37 74 2 2001385008 51654624 12845344
20:46:58 9097 8192000000 10909224464 11343454208 1936576256 19.119 100 40 79 1 1997606944 46984640 14046048
20:47:15 7845 8192000000 10890248560 11312947200 1898749600 18.816 98 53 106 1 1958139840 42428320 16961920
20:47:37 9549 8192000000 10918270976 11345727488 1932183056 19.084 100 41 83 0 1988467856 42978560 13306240
20:48:03 16250 8192000000 10899203952 11335397376 1918249840 18.973 99 29 58 4 1979389136 50063488 11075808
20:48:30 10976 8192000000 10904683120 11352690688 1936985712 19.123 100 27 54 2 1997677824 51292528 9399584
20:48:48 13234 8192000000 10919711904 11355168768 1939391408 19.142 100 29 57 0 1995003392 46186688 9425296
20:49:08 13575 8192000000 10929235424 11377549312 1954738672 19.264 100 39 78 1 2016418992 49729920 11950400
20:49:29 10398 8192000000 10904167792 11346546688 1921675760 19.000 99 30 60 3 1975396336 44245392 9475184
20:49:55 14812 8192000000 10900150768 11346636800 1933507200 19.095 100 27 54 0 1985438448 42174784 9756464
20:50:22 18560 8192000000 10893013440 11349864448 1944651008 19.184 100 22 44 2 1986241376 34094528 7495840
20:51:06 28207 8192000000 10893782912 11345879040 1948607280 19.215 100 16 32 1 1979956080 26168096 5180704
20:52:17 28793 8192000000 10893614736 11352129536 1945803888 19.193 100 17 34 0 1985488960 33755216 5929856
20:52:52 27959 8192000000 10901838848 11363495936 1950113504 19.227 100 15 30 1 1986500112 31070400 5316208
20:54:31 90924 8192000000 10872456528 11321954304 1878307760 18.651 97 10 20 0 1904763056 24114464 2340832
20:56:37 93969 8192000000 10877021424 11338616832 1902345424 18.845 98 19 38 1 1916771648 9201200 5225024
20:58:17 107529 8192000000 10903037616 11352035328 1938590048 19.136 99 12 24 0 1955825776 13853920 3381808
21:00:11 100942 8192000000 10892053840 11364196352 1890527904 18.750 96 17 34 0 1920731552 25862352 4341296
21:01:58 129965 8192000000 10908043824 11375251456 1962957600 19.330 100 7 14 0 1978383024 13731296 1694128
21:04:14 175117 8192000000 10956757856 11397701632 1992587152 19.564 100 37 74 3 2015242176 11816896 10838128
21:07:17 84330 8192000000 10922308416 11400736768 1961611088 19.319 98 22 44 0 1979229184 12190720 5427376
21:08:48 46799 8192000000 10931145792 11399286784 1997531536 19.603 100 26 51 2 2021233632 16899808 6802288
21:09:46 29445 8192000000 10927196032 11393912832 2001968976 19.638 100 24 48 2 2015819616 6728368 7122272
21:10:44 36379 8192000000 10934665968 11388182528 1984437968 19.500 99 23 46 0 2000019616 9241856 6339792
21:11:27 17173 8192000000 10948769584 11409035264 1996820944 19.598 99 51 99 1 2027118528 16040416 14257168
21:11:56 35487 8192000000 10942034256 11417448448 2008731200 19.692 100 17 34 1 2029705280 15794480 5179600
21:12:42 17756 8192000000 10943487872 11406516224 1996117920 19.592 99 25 48 1 2015445200 12088080 7239200
21:13:06 35552 8192000000 10959329840 11421794304 2020634192 19.785 100 49 98 1 2048772880 13462896 14675792
21:14:17 49888 8192000000 10952691488 11431718912 2010862640 19.708 100 24 48 1 2041533472 23214096 7456736
21:15:13 46431 8192000000 10929864816 11417858048 1992841376 19.566 99 10 20 0 2012748912 17253472 2654064
21:16:06 42513 8192000000 10926429936 11418292224 1990504832 19.548 99 13 26 0 2011659344 17003216 4151296
21:16:55 5303 8192000000 10907761728 11385282560 1945451856 19.190 97 18 33 3 1965937136 15946080 4539200
21:17:07 17238 8192000000 10923716560 11396014080 1984247840 19.498 100 6 12 0 2000534272 14505792 1780640
21:17:36 20208 8192000000 10905293536 11387371520 1971540080 19.398 99 7 14 0 1988870544 15463104 1867360
21:18:04 14657 8192000000 10909271040 11392577536 1980930624 19.472 100 5 10 0 2000233536 17553600 1749312
21:18:24 8382 8192000000 10910338048 11395067904 1984443600 19.500 100 8 16 1 2007147968 20114096 2590272
21:18:44 7700 8192000000 10905504528 11397419008 1963625440 19.335 99 5 10 0 1986971488 21543792 1802256
21:19:11 22048 8192000000 10872347360 11356946432 1940820640 19.153 99 3 6 0 1952301232 10860528 620064
21:19:41 40776 8192000000 10887961552 11372789760 1927711392 19.049 98 14 28 0 1942255488 10276704 4267392
21:20:28 26907 8192000000 10916792784 11365412864 1933054512 19.091 98 33 66 1 1952892832 10170528 9667792
21:21:24 90481 8192000000 10900659600 11398107136 1941607072 19.160 99 8 14 0 1962192032 18706128 1878832
21:23:01 43606 8192000000 10917573808 11374776320 1956092848 19.275 99 25 50 0 1979859360 16852160 6914352
21:23:57 66148 8192000000 10886475344 11373707264 1933567584 19.095 98 11 22 0 1948723920 11831536 3324800
21:25:09 51661 8192000000 10915194288 11380658176 1955817024 19.273 99 14 28 0 1970008912 10470320 3721568
21:26:08 58119 8192000000 10887945344 11353915392 1879086624 18.658 95 30 60 0 1903621328 15560016 8974688
21:27:19 84485 8192000000 10881667136 11348271104 1882646288 18.686 96 18 36 0 1906201536 19096176 4459072
21:28:55 74365 8192000000 10844531552 11306725376 1794060976 17.965 92 6 12 1 1809532832 14250896 1220960
21:30:15 71850 8192000000 10842823328 11300446208 1840015392 18.341 95 11 22 2 1853532208 10433968 3082848
21:31:33 90362 8192000000 10879595216 11336974336 1831451664 18.271 95 14 28 1 1850997728 15752176 3793888
21:33:19 42017 8192000000 10883871424 11350044672 1917586912 18.968 99 23 46 1 1943992976 20055488 6350576
21:34:08 127542 8192000000 10858769552 11315892224 1845702912 18.387 95 25 51 0 1864789008 11558224 7527872
21:36:35 78785 8192000000 10845388976 11296296960 1823056384 18.203 94 23 46 0 1840568816 11433840 6078592
21:38:03 56371 8192000000 10859015664 11314782208 1896400064 18.797 98 49 96 1 1923372832 13459312 13513456
21:39:07 13565 8192000000 10863728768 11315769344 1922653280 19.008 100 33 66 1 1947239888 14806528 9780080
21:39:27 26932 8192000000 10857829536 11316396032 1908331984 18.893 99 35 71 0 1931575472 12527312 10716176
21:40:01 36684 8192000000 10849236000 11300925440 1883385328 18.692 98 23 45 2 1898359584 8436592 6537664
21:41:07 28445 8192000000 10842212464 11300282368 1901320128 18.837 99 35 69 0 1921841984 11238688 9283168
21:41:43 54794 8192000000 10857823696 11308077056 1906546544 18.879 99 30 60 1 1927575328 12628272 8400512
21:42:44 49880 8192000000 10839693200 11317411840 1891016800 18.754 98 12 24 0 1906407952 11901808 3489344
21:43:43 49227 8192000000 10842190672 11318616064 1911370272 18.918 99 7 14 1 1928894784 15434768 2089744
21:45:29 40054 8192000000 10822234128 11302600704 1882980528 18.689 98 7 14 1 1896045792 10844240 2221024
21:46:24 59859 8192000000 10829824848 11303288832 1872556032 18.605 98 17 34 0 1884682800 7757904 4368864
21:47:30 42102 8192000000 10855628752 11324600320 1909474736 18.902 99 15 30 1 1921094800 6862096 4757968
21:48:28 61261 8192000000 10853835088 11332059136 1914581600 18.943 99 14 28 2 1930943968 12367280 3995088
21:49:36 49423 8192000000 10880190720 11350478848 1949279568 19.221 100 19 38 1 1963425056 8956784 5188704
21:50:34 52434 8192000000 10869110624 11339005952 1912910288 18.930 98 4 8 0 1922493312 8712768 870256
21:51:34 31773 8192000000 10888047120 11354050560 1951209872 19.236 100 18 36 2 1964746080 8820320 4715888
21:52:20 29098 8192000000 10903783968 11364798464 1962501024 19.326 100 31 62 0 1983052080 11803280 8747776
21:52:56 61638 8192000000 10882264064 11347607552 1929045056 19.059 98 28 56 1 1957183072 20281344 7856672
21:54:12 70389 8192000000 10908242240 11378851840 1973812784 19.416 100 20 40 1 1992614016 13114272 5686960
21:56:03 68827 8192000000 10922843984 11391700992 1966925104 19.361 99 25 50 0 1986640464 12781632 6933728
21:57:22 69111 8192000000 10912887232 11387822080 1967836864 19.368 99 11 22 1 1984654576 13913552 2904160
21:58:37 97443 8192000000 10924533632 11383492608 1931583488 19.080 97 19 36 2 1945605616 9343600 4678528
22:00:24 81515 8192000000 10926850912 11388780544 1994162288 19.577 100 30 60 1 2010729280 8102544 8464448
22:01:59 60463 8192000000 10905977296 11381809152 1969232240 19.379 99 14 28 0 1980447664 7646528 3568896
22:03:10 28879 8192000000 10866960032 11336343552 1915892384 18.954 97 22 43 1 1928439568 6368720 6178464
22:03:50 39265 8192000000 10880756464 11342839808 1907535904 18.887 97 25 50 0 1923029872 8555584 6938384
22:04:42 59241 8192000000 10869210976 11349192704 1934372736 19.102 99 5 10 0 1944816752 9118832 1325184
22:06:35 45403 8192000000 10875455888 11350011904 1936115360 19.116 99 14 28 1 1949482560 9855904 3511296
22:07:27 46589 8192000000 10880299040 11358232576 1956393856 19.277 100 12 24 1 1978694832 18729760 3571216
22:08:20 73726 8192000000 10895075344 11364835328 1959513568 19.302 100 6 12 0 1971435264 10412512 1509184
22:09:44 58556 8192000000 10878314192 11351822336 1916276752 18.957 98 8 16 1 1930070656 11211616 2582288
22:10:51 47069 8192000000 10874886736 11349614592 1923036384 19.011 98 37 74 0 1941972832 8678032 10258416
22:11:45 49148 8192000000 10884579408 11347931136 1933585008 19.096 99 14 28 1 1947600256 8874992 5140256
22:12:41 43153 8192000000 10834407824 11298627584 1808200304 18.081 93 22 44 1 1824263680 10001152 6062224
22:13:31 74617 8192000000 10864162800 11317370880 1851420400 18.434 96 23 46 0 1869451440 11706496 6324544
22:15:01 63816 8192000000 10824973456 11298004992 1837988576 18.324 96 14 28 0 1854668464 12525232 4154656
22:16:11 72102 8192000000 10856772752 11299688448 1819887424 18.177 95 29 58 0 1837129840 9703648 7538768
22:17:34 20972 8192000000 10882144672 11323805696 1913485600 18.935 99 55 110 0 1940964944 12038832 15440512
22:18:05 25288 8192000000 10858579744 11312398336 1905181600 18.868 99 42 84 0 1930277664 13483216 11612848
22:19:00 89253 8192000000 10846744384 11316183040 1836542192 18.313 95 11 22 1 1857872832 17686816 3643824
22:20:45 66129 8192000000 10829686000 11273949184 1835378688 18.303 96 17 34 0 1853515616 13295456 4841472
22:21:59 117999 8192000000 10832656528 11297267712 1844388480 18.377 96 28 57 0 1865931360 13501520 8041360
22:24:04 32505 8192000000 10846665152 11300069376 1883846080 18.696 99 35 71 1 1905839232 12381200 9611952
22:24:42 32442 8192000000 10833433840 11293581312 1869405248 18.579 98 15 30 0 1893759696 20739792 3614656
22:25:29 29964 8192000000 10811078144 11288793088 1887521408 18.726 99 29 57 0 1903155504 7194704 8439392
22:26:06 44903 8192000000 10843123808 11300765696 1894929568 18.785 99 16 32 1 1904947712 5791360 4226784
22:27:09 23684 8192000000 9853838912 10219847680 991227104 10.793 52 2 4 0 994893600 3541872 124624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 29-01-2021 22:30:07 to 29-01-2021 22:30:38.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 177 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

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

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          252798
MON$OLDEST_ACTIVE               253241
MON$OLDEST_SNAPSHOT             253241
MON$NEXT_TRANSACTION            253241
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                       2042976
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:192: 
:193: mscs-test-161.budzdorov.ru    Fri Jan 29 22:27:48 2021
:194:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:195: 
:196: 
:197: mscs-test-161.budzdorov.ru    Fri Jan 29 22:27:57 2021
:198:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:199: 
:200: 
:201: mscs-test-161.budzdorov.ru    Fri Jan 29 22:27:57 2021
:202:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:203: 
:204: 
:205: mscs-test-161.budzdorov.ru    Fri Jan 29 22:27:57 2021
:206:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:207: 
--- end of diff output ---

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

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