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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-25 01:27:23
DTS_END                         2021-03-25 01:27:23.1870
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/38470
TRN_ID                          250379
ATT_ID                          709
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: 9575.28 19718 1149033
customer order: creation 186.19 345 22343
customer order: refuse 15.80 310 1896
order to supplier: creation 48.81 1321 5857
order to supplier: removal 3.42 108412 410
invoice (draft): creation 49.33 3471 5920
invoice (draft): removal 52.71 789 6325
invoice accept: apply 44.83 18720 5379
invoice accept: cancel 47.18 828 5662
customer reserve: creation 4151.96 184 498235
customer reserve: removal 4670.70 62 560484
realization accept: apply 88.95 172 10674
realization accept: cancel 79.58 114 9549
payment from customer: creation 62.06 122 7447
payment from customer: removal 6.07 97 728
payment to supplier: creation 51.05 133 6126
payment to supplier: removal 3.62 84 434
service: total inventory turnovers 5.05 962 606
service: total monetary turnovers 7.16 25 859
service: aggregate perf. data 0.79 25277 95
service: refresh index statistics 0.03 232938 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-03-2021 01:29:27 to 25-03-2021 01:29:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 542
TEST_TIME 2 1423
TEST_TIME 3 2112
TEST_TIME 4 3556
TEST_TIME 5 4086
TEST_TIME 6 4591
TEST_TIME 7 5001
TEST_TIME 8 5187
TEST_TIME 9 5292
TEST_TIME 10 5807
TEST_TIME 11 6252
TEST_TIME 12 6425
TEST_TIME 13 6387
TEST_TIME 14 6825
TEST_TIME 15 6900
TEST_TIME 16 7140
TEST_TIME 17 7254
TEST_TIME 18 7359
TEST_TIME 19 7307
TEST_TIME 20 7912
TEST_TIME 21 8053
TEST_TIME 22 8466
TEST_TIME 23 8981
TEST_TIME 24 8961
TEST_TIME 25 9481
TEST_TIME 26 9520
TEST_TIME 27 9470
TEST_TIME 28 9849
TEST_TIME 29 9705
TEST_TIME 30 10463
TEST_TIME 31 11251
TEST_TIME 32 11181
TEST_TIME 33 11148
TEST_TIME 34 11040
TEST_TIME 35 10978
TEST_TIME 36 10850
TEST_TIME 37 10658
TEST_TIME 38 10552
TEST_TIME 39 10334
TEST_TIME 40 10280
TEST_TIME 41 10405
TEST_TIME 42 10367
TEST_TIME 43 10245
TEST_TIME 44 10172
TEST_TIME 45 10133
TEST_TIME 46 10016
TEST_TIME 47 9989
TEST_TIME 48 10145
TEST_TIME 49 10248
TEST_TIME 50 10175
TEST_TIME 51 10067
TEST_TIME 52 10100
TEST_TIME 53 10144
TEST_TIME 54 10101
TEST_TIME 55 10053
TEST_TIME 56 10172
TEST_TIME 57 10098
TEST_TIME 58 10106
TEST_TIME 59 10057
TEST_TIME 60 10127
TEST_TIME 61 10125
TEST_TIME 62 10084
TEST_TIME 63 10110
TEST_TIME 64 10163
TEST_TIME 65 10156
TEST_TIME 66 10194
TEST_TIME 67 10243
TEST_TIME 68 10148
TEST_TIME 69 10072
TEST_TIME 70 10032
TEST_TIME 71 9947
TEST_TIME 72 9942
TEST_TIME 73 9908
TEST_TIME 74 9875
TEST_TIME 75 9850
TEST_TIME 76 9783
TEST_TIME 77 9802
TEST_TIME 78 9748
TEST_TIME 79 9692
TEST_TIME 80 9704
TEST_TIME 81 9660
TEST_TIME 82 9625
TEST_TIME 83 9665
TEST_TIME 84 9654
TEST_TIME 85 9653
TEST_TIME 86 9649
TEST_TIME 87 9667
TEST_TIME 88 9717
TEST_TIME 89 9681
TEST_TIME 90 9740
TEST_TIME 91 9712
TEST_TIME 92 9742
TEST_TIME 93 9798
TEST_TIME 94 9817
TEST_TIME 95 9795
TEST_TIME 96 9772
TEST_TIME 97 9751
TEST_TIME 98 9701
TEST_TIME 99 9680
TEST_TIME 100 9638
TEST_TIME 101 9590
TEST_TIME 102 9576
TEST_TIME 103 9525
TEST_TIME 104 9529
TEST_TIME 105 9498
TEST_TIME 106 9535
TEST_TIME 107 9538
TEST_TIME 108 9514
TEST_TIME 109 9564
TEST_TIME 110 9538
TEST_TIME 111 9555
TEST_TIME 112 9605
TEST_TIME 113 9594
TEST_TIME 114 9585
TEST_TIME 115 9617
TEST_TIME 116 9668
TEST_TIME 117 9675
TEST_TIME 118 9719
TEST_TIME 119 9647
TEST_TIME 120 9578

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-03-2021 01:29:31 to 25-03-2021 01:29:34.

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 1608815 1608815 0 0.00 0 35618 7 0 0
doc_list_biud 1608791 1608791 0 0.00 0 47685 27 0 0
sp_add_invoice_to_stock 5482 5379 103 1.87 22 230553 18720 0 103
sp_cancel_adding_invoice 5662 5662 0 0.00 5 61398 829 0 0
sp_cancel_client_order 1896 1896 0 0.00 3 10641 311 0 0
sp_cancel_customer_reserve 560484 560484 0 0.00 1 22943 63 0 0
sp_cancel_pay_from_customer 728 728 0 0.00 3 7475 97 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 3 7278 84 0 0
sp_cancel_supplier_invoice 6332 6325 7 0.11 2 24126 789 0 7
sp_cancel_supplier_order 410 410 0 0.00 7 1049650 108413 0 0
sp_cancel_write_off 9549 9549 0 0.00 1 18451 114 0 0
sp_client_order 22343 22343 0 0.00 3 20892 346 0 0
sp_customer_reserve 498235 498235 0 0.00 0 87205 184 0 0
sp_fill_shopping_cart 34112 34112 0 0.00 1 10572 34 0 0
sp_fill_shopping_cart_clo_res 498232 498232 0 0.00 0 39999 13 0 0
sp_get_clo_for_invoice 5376 5376 0 0.00 0 49955 289 0 0
sp_kill_cost_storno 16373 16373 0 0.00 0 9286 60 0 0
sp_kill_qstorno_ret_qs2qd 1137252 1137252 0 0.00 0 24113 33 0 0
sp_kill_qty_storno 600362 600362 0 0.00 0 47684 73 0 0
sp_lock_selected_doc 22167 22167 0 0.00 0 7468 5 0 0
sp_make_cost_storno 29623 29623 0 0.00 0 35597 61 0 0
sp_multiply_rows_for_pdistr 29599 29599 0 0.00 0 9086 26 0 0
sp_multiply_rows_for_qdistr 22343 22343 0 0.00 0 20876 154 0 0
sp_pay_from_customer 7447 7447 0 0.00 4 21401 122 0 0
sp_pay_to_supplier 6126 6126 0 0.00 5 21400 134 0 0
sp_payment_common 13563 13563 0 0.00 1 20912 28 0 0
sp_qd_handle_on_cancel_clo 1896 1896 0 0.00 0 10634 292 0 0
sp_qd_handle_on_invoice_upd_sts 11030 11030 0 0.00 0 47684 353 0 0
sp_qd_handle_on_reserve_upd_sts 10668 10668 0 0.00 0 11013 55 0 0
sp_reserve_write_off 10674 10674 0 0.00 6 24300 172 0 0
sp_supplier_invoice 5920 5920 0 0.00 6 114709 3472 0 0
sp_supplier_order 5857 5857 0 0.00 5 34903 1322 0 0
srv_aggregate_perf_data 96 95 1 1.04 2823 766759 25278 0 1
srv_fill_mon_cache_memory 182 182 0 0.00 947 131490 27809 0 0
srv_find_qd_qs_mism 1097217 1097217 0 0.00 0 17881 6 0 0
srv_make_invnt_saldo 606 606 0 0.00 28 23151 962 0 0
srv_make_money_saldo 859 859 0 0.00 1 762 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 133249 365581 232939 0 0
t$perf-abend:sp_add_invoice_to_stock 103 103 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 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 5379 5379 0 0.00 0 11436 174 0 0
t$perf-norm:sp_cancel_adding_invoice 421 421 0 0.00 0 2945 95 0 0
t$perf-norm:sp_cancel_client_order 1896 1896 0 0.00 0 4965 18 0 0
t$perf-norm:sp_cancel_customer_reserve 702 702 0 0.00 0 4799 28 0 0
t$perf-norm:sp_cancel_pay_from_customer 728 728 0 0.00 0 5274 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 2048 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 471 471 0 0.00 0 4217 26 0 0
t$perf-norm:sp_cancel_supplier_order 410 410 0 0.00 0 21321 1528 0 0
t$perf-norm:sp_cancel_write_off 1069 1069 0 0.00 0 3553 7 0 0
t$perf-norm:sp_client_order 22343 22343 0 0.00 0 7874 18 0 0
t$perf-norm:sp_customer_reserve 1014 1014 0 0.00 0 5500 17 0 0
t$perf-norm:sp_pay_from_customer 7447 7447 0 0.00 0 6360 13 0 0
t$perf-norm:sp_pay_to_supplier 6126 6126 0 0.00 0 5429 13 0 0
t$perf-norm:sp_reserve_write_off 10674 10674 0 0.00 0 12372 14 0 0
t$perf-norm:sp_supplier_invoice 5920 5920 0 0.00 0 8203 24 0 0
t$perf-norm:sp_supplier_order 5857 5857 0 0.00 0 8477 23 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 412 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 182 182 0 0.00 0 5564 39 0 0
t$perf-norm:srv_make_invnt_saldo 606 606 0 0.00 0 760 17 0 0
t$perf-norm:srv_make_money_saldo 859 859 0 0.00 0 2109 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10942 10736 206 1.88 0 6778 18 0 206
v_all_customers 40500 40500 0 0.00 0 26 1 0 0
v_all_suppliers 32300 32300 0 0.00 0 140 1 0 0
v_all_wares 44686 44686 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 842 842 0 0.00 0 3034 11 0 0
v_cancel_client_order 3792 3792 0 0.00 0 529 3 0 0
v_cancel_customer_prepayment 1456 1456 0 0.00 0 5162 12 0 0
v_cancel_customer_reserve 1404 1404 0 0.00 0 2361 8 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 1277 4 0 0
v_cancel_supplier_invoice 956 942 14 1.46 0 689 14 0 14
v_cancel_supplier_order 820 820 0 0.00 0 373 4 0 0
v_cancel_write_off 2138 2138 0 0.00 0 2177 13 0 0
v_max_id_clo_ord 5855 5855 0 0.00 0 6160 4 0 0
v_max_id_clo_res 1014 1014 0 0.00 0 2222 16 0 0
v_max_id_ord_sup 5914 5914 0 0.00 0 3498 4 0 0
v_max_non_paid_invoice 1740 1740 0 0.00 0 2199 4 0 0
v_max_non_paid_realizn 3990 3990 0 0.00 0 3514 4 0 0
v_min_id_clo_ord 5855 5855 0 0.00 0 4275 5 0 0
v_min_id_clo_res 1014 1014 0 0.00 0 3913 11 0 0
v_min_id_ord_sup 5914 5914 0 0.00 0 4054 5 0 0
v_min_non_paid_invoice 6121 6121 0 0.00 0 6686 15 0 0
v_min_non_paid_realizn 7442 7442 0 0.00 0 20910 19 0 0
v_our_firm 11090 11090 0 0.00 0 21 1 0 0
v_reserve_write_off 21336 21336 0 0.00 0 7641 7 0 0
x_lock_depdocs_on_canc_invoice 11516 11516 0 0.00 0 16466 135 0 0
x_lock_depdocs_on_canc_sup_ord 410 410 0 0.00 0 27373 543 0 0
x_make_qstorno_1000_1200 5857 5857 0 0.00 2 34899 1237 0 0
x_make_qstorno_1200_2000 5920 5920 0 0.00 3 111910 3362 0 0
x_make_qstorno_2100_3300 498235 498235 0 0.00 0 87203 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-03-2021 01:29:35 to 25-03-2021 01:29:39.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:26 9 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:33 8279 8192000000 10144040560 10430164992 818879568 9.087 67 52 105 0 839029200 2266560 17883072
22:57:51 21676 8192000000 10300889968 10612912128 1344562272 14.099 100 82 164 0 1376516544 4127264 27827008
22:58:22 23851 8192000000 10350544800 10669506560 1403285136 14.624 100 88 176 0 1437302272 5471712 28545424
22:58:55 39485 8192000000 10395549632 10718253056 1438661648 14.938 100 92 184 0 1476306208 7426064 30218496
22:59:45 20969 8192000000 10409697456 10733125632 1458112064 15.109 100 91 182 1 1496592864 8436560 30044240
23:00:16 14941 8192000000 10422710736 10753179648 1475666240 15.263 100 85 170 1 1511825904 8938528 27221136
23:00:46 25041 8192000000 10456447728 10793070592 1505129840 15.521 100 92 184 0 1544367744 9837136 29400768
23:01:19 18532 8192000000 10474997920 10819641344 1533437328 15.767 100 81 162 0 1568558000 10031024 25089648
23:01:48 18128 8192000000 10516159856 10864029696 1565251376 16.041 100 75 150 0 1598007744 10035376 22720992
23:02:18 14340 8192000000 10556490672 10908598272 1601435312 16.352 100 85 170 0 1638452208 10988000 26028896
23:02:41 17371 8192000000 10579872608 10938449920 1629533744 16.591 100 82 164 1 1666656688 11969552 25153392
23:03:08 12299 8192000000 10615468880 10975440896 1658172368 16.833 100 84 168 1 1695821824 12114304 25535152
23:03:31 14595 8192000000 10617544656 10986565632 1680369696 17.020 100 85 170 1 1718247648 12367616 25510336
23:03:55 9306 8192000000 10633380176 11001257984 1692223504 17.120 100 88 177 1 1730510880 12403248 25884128
23:04:11 9490 8192000000 10647346016 11012530176 1701689392 17.199 100 88 173 2 1740003616 13573616 24740608
23:04:29 7264 8192000000 10651846016 11019739136 1709159760 17.262 100 84 166 1 1746853872 14064000 23630112
23:04:43 5617 8192000000 10661642624 11031130112 1718230592 17.337 100 81 162 2 1754316448 13459744 22626112
23:04:57 5149 8192000000 10664062400 11040313344 1731549840 17.448 100 79 159 0 1767449952 13696480 22203632
23:05:11 7283 8192000000 10695270624 11066834944 1749134624 17.594 100 87 172 2 1788153216 14284272 24734320
23:05:25 3974 8192000000 10688956608 11066314752 1753144560 17.628 100 83 164 0 1790175056 13612656 23417840
23:05:36 6734 8192000000 10708329728 11085131776 1762415056 17.704 100 89 175 0 1801801328 14658976 24727296
23:05:49 2843 8192000000 10709157856 11089338368 1774307088 17.803 100 86 173 0 1812756432 13892032 24557312
23:05:59 4213 8192000000 10709561504 11096051712 1780295104 17.852 100 79 158 0 1815499984 13040432 22164448
23:06:10 3989 8192000000 10736525008 11114713088 1793861200 17.964 100 88 176 0 1831513760 13320720 24331840
23:06:21 2929 8192000000 10741058288 11126743040 1801493232 18.026 100 82 162 2 1838455408 14204048 22758128
23:06:31 2769 8192000000 10741142624 11118977024 1806168016 18.064 100 87 172 0 1842825024 12909744 23747264
23:06:40 11398 8192000000 10742186240 11128508416 1806380496 18.066 100 75 150 1 1840656544 13061776 21214272
23:06:58 5621 8192000000 10758994912 11141832704 1812267440 18.114 100 81 159 2 1846385280 12596816 21521024
23:07:10 2681 8192000000 10772570976 11155046400 1829955072 18.259 100 91 182 0 1869489200 13615888 25918240
23:07:19 2223 8192000000 10779346832 11161481216 1836827616 18.315 100 94 188 1 1877633936 14417072 26389248
23:07:28 2240 8192000000 10791953856 11176669184 1840320432 18.343 100 95 191 1 1882026272 14596416 27109424
23:07:36 1637 8192000000 10788879184 11172864000 1843750944 18.371 100 83 165 3 1881012528 14241936 23019648
23:07:45 2263 8192000000 10780096832 11169591296 1851416288 18.434 100 88 171 0 1888058992 12829040 23813664
23:07:53 1862 8192000000 10802746336 11191582720 1860439808 18.507 100 92 183 0 1898967248 12380944 26146496
23:08:02 1693 8192000000 10803691904 11190046720 1861094368 18.512 100 97 193 1 1900618624 12182384 27341872
23:08:10 1243 8192000000 10807830544 11195473920 1862977504 18.527 100 96 191 2 1902481280 12661104 26842672
23:08:18 1648 8192000000 10807685424 11198513152 1866162336 18.553 100 85 171 0 1902747024 11586480 24998208
23:08:26 1442 8192000000 10816588784 11206467584 1872651808 18.606 100 90 181 1 1910981136 12647024 25682304
23:08:34 37925 8192000000 10778698608 11198218240 1865195680 18.545 100 50 100 1 1889045216 9089504 14760032
23:09:18 4482 8192000000 10798024208 11204456448 1867964864 18.568 100 40 80 1 1885907968 7253408 10689696
23:09:32 5403 8192000000 10786099056 11209641984 1873849376 18.615 100 40 81 1 1893490928 8269840 11371712
23:09:43 6979 8192000000 10793561152 11212726272 1878445584 18.653 100 44 88 1 1898965920 8429520 12090816
23:09:59 6732 8192000000 10794312784 11213246464 1878331296 18.652 100 31 64 2 1893507328 6317488 8858544
23:10:12 7386 8192000000 10808234752 11225432064 1881151072 18.674 100 39 78 0 1900637344 7379488 12106784
23:10:27 6865 8192000000 10806891680 11222728704 1886062016 18.714 100 32 64 3 1900787008 5704160 9020832
23:10:40 6505 8192000000 10797945776 11225788416 1887394448 18.725 100 33 64 1 1903891744 7093760 9403536
23:10:55 7031 8192000000 10799717248 11227648000 1886141472 18.715 100 18 37 1 1897546640 5815744 5589424
23:11:12 6083 8192000000 10798374800 11227254784 1891098176 18.755 100 22 44 3 1903932064 5877840 6956048
23:11:28 6937 8192000000 10803271536 11232632832 1892940704 18.769 100 15 30 1 1904006240 5933648 5131888
23:11:42 10211 8192000000 10801097328 11237355520 1894505504 18.782 100 25 49 3 1908215296 7057024 6652768
23:11:59 16735 8192000000 10807367056 11236372480 1895014384 18.786 100 17 34 0 1905547648 5730608 4802656
23:12:23 5724 8192000000 10805843216 11237978112 1898150304 18.811 100 22 44 2 1911049600 6911344 5987952
23:12:36 15857 8192000000 10816280912 11245338624 1905313328 18.869 100 38 75 0 1921578592 5758304 10506960
23:12:58 73378 8192000000 10818277152 11254054912 1904812560 18.865 100 25 50 0 1916940592 4642368 7485664
23:14:20 6507 8192000000 10823572496 11258028032 1910089808 18.907 100 26 52 1 1924509232 6951360 7468064
23:14:33 4934 8192000000 10834087024 11260760064 1909533072 18.903 100 34 69 1 1925315328 5999984 9782272
23:14:46 4626 8192000000 10839439920 11262423040 1913672832 18.936 100 35 70 2 1930633824 7452160 9508832
23:14:59 8009 8192000000 10818873376 11259125760 1918136416 18.972 100 30 60 1 1932849536 5892544 8820576
23:15:15 7678 8192000000 10821141616 11264229376 1915564640 18.951 100 31 60 2 1930861024 6896864 8399520
23:15:30 7406 8192000000 10818755040 11263229952 1916257696 18.957 100 27 54 2 1930067584 6107104 7702784
23:15:44 12587 8192000000 10809598272 11251515392 1875723088 18.631 98 21 42 5 1887493424 5728400 6041936
23:16:05 10821 8192000000 10820115760 11259928576 1909684976 18.904 100 22 44 0 1921623952 5361712 6577264
23:16:25 12835 8192000000 10816940112 11248226304 1855523136 18.467 97 20 40 1 1866513008 5489184 5500688
23:16:48 6531 8192000000 10809907584 11240296448 1894410960 18.781 100 24 48 3 1907074112 6470592 6192560
23:17:01 5364 8192000000 10817587296 11239047168 1891805120 18.760 100 33 64 3 1906199392 5733008 8661264
23:17:12 8041 8192000000 10804030240 11231891456 1844344304 18.376 97 23 46 5 1855586320 5000976 6241040
23:17:28 16808 8192000000 10803931184 11213434880 1824038784 18.211 97 21 43 1 1839121824 9234272 5848768
23:17:51 52473 8192000000 10784584272 11183501312 1788913072 17.923 95 49 97 1 1808165264 5337568 13914624
23:18:50 4433 8192000000 10724455904 11150299136 1765645936 17.731 95 24 48 1 1780261728 8141488 6474304
23:19:01 7445 8192000000 10745437376 11168567296 1786596224 17.904 97 19 38 1 1798114112 5712400 5805488
23:19:14 5872 8192000000 10735000048 11155955712 1748009968 17.585 95 37 74 0 1769684224 10876464 10797792
23:19:26 5162 8192000000 10737836960 11150622720 1788239536 17.917 98 29 58 1 1802640672 5860848 8540288
23:19:39 6193 8192000000 10696355712 11107184640 1665101536 16.892 92 31 60 6 1679788048 6113216 8573296
23:19:52 7084 8192000000 10706585456 11126751232 1795778384 17.979 100 27 54 0 1809878384 6051344 8048656
23:20:07 7068 8192000000 10703980064 11112992768 1713334160 17.297 95 30 61 2 1727045424 4717616 8993648
23:20:21 6102 8192000000 10678763072 11092856832 1693326496 17.129 95 21 42 2 1704923312 5126800 6470016
23:20:34 7455 8192000000 10692765264 11107225600 1744100608 17.553 98 18 36 1 1754990576 5929200 4960768
23:20:50 5717 8192000000 10711497584 11129118720 1775180544 17.810 99 24 46 2 1787813648 4944768 7688336
23:21:03 7392 8192000000 10696739584 11110633472 1726576432 17.407 96 20 38 2 1737223568 5266544 5380592
23:21:21 5583 8192000000 10710290368 11117199360 1772418384 17.787 99 29 58 0 1786347920 5480768 8448768
23:21:35 9996 8192000000 10700384160 11112562688 1738759264 17.508 97 20 40 1 1750534752 5408064 6367424
23:21:52 14371 8192000000 10712005840 11117699072 1777263312 17.827 99 38 76 2 1793683744 4498224 11922208
23:22:13 61556 8192000000 10712510448 11131228160 1791482944 17.944 99 34 68 2 1807684480 5822064 10379472
23:23:22 8477 8192000000 10714258768 11132256256 1801211296 18.024 100 30 60 2 1816578976 6761184 8606496
23:23:37 9059 8192000000 10716615120 11139616768 1806268688 18.065 100 16 32 2 1817017008 5617312 5131008
23:23:52 8516 8192000000 10731600672 11151126528 1816185872 18.147 100 25 50 0 1828545504 5290976 7068656
23:24:08 7615 8192000000 10747488960 11163447296 1824232144 18.212 100 22 43 2 1836795296 5806224 6756928
23:24:24 6611 8192000000 10744207088 11164684288 1831616384 18.273 100 34 68 0 1848060448 6677856 9766208
23:24:39 7715 8192000000 10748396352 11169075200 1834012592 18.292 100 28 55 4 1849336432 6553280 8770560
23:24:53 9698 8192000000 10762432016 11176402944 1834835904 18.299 100 29 58 3 1847685536 5321616 7528016
23:25:09 10634 8192000000 10748329280 11169812480 1835413936 18.303 100 29 56 3 1852920816 9847040 7659840
23:25:25 6094 8192000000 10741305616 11170344960 1834960608 18.300 100 25 50 2 1848206896 5348144 7898144
23:25:38 10015 8192000000 10744760048 11174129664 1835324352 18.303 100 22 44 0 1847553904 5696368 6533184
23:25:55 9524 8192000000 10761442304 11184078848 1843915056 18.373 100 27 54 3 1857339984 5515968 7908960
23:26:11 12307 8192000000 10752168336 11176984576 1842375984 18.360 100 19 38 0 1853205648 5399312 5430352
23:26:31 10010 8192000000 10756913744 11182514176 1840976240 18.349 100 14 28 0 1850722560 5758992 3987328
23:26:50 10055 8192000000 10753720416 11186020352 1845535552 18.386 100 17 34 1 1855974512 5388528 5050432
23:27:06 24855 8192000000 10780439536 11208503296 1864435776 18.539 100 15 30 0 1874696896 4969360 5291760
23:28:23 79315 8192000000 10827431408 11242049536 1890638816 18.751 100 54 104 2 1914223120 8625328 14958976
23:29:51 7379 8192000000 10841168176 11251982336 1901506480 18.838 100 64 127 2 1929617488 10159712 17951296
23:30:08 8432 8192000000 10838743984 11256467456 1904275872 18.861 100 54 108 2 1929980752 10700512 15004368
23:30:26 30755 8192000000 10844823648 11268313088 1912941264 18.930 100 61 122 2 1942886000 12854704 17090032
23:31:11 13888 8192000000 10848867184 11272589312 1916913344 18.962 100 49 98 0 1943604736 12811168 13880224
23:31:37 17897 8192000000 10847952112 11277860864 1921809648 19.001 100 47 94 1 1950971584 15302016 13859920
23:32:03 28319 8192000000 10841906992 11276939264 1906583328 18.879 99 44 87 0 1931991360 11988624 13419408
23:32:38 29955 8192000000 10866770288 11291529216 1928835712 19.058 100 39 78 1 1952641440 11977712 11828016
23:33:17 11319 8192000000 10869393376 11297566720 1934132224 19.100 100 40 80 0 1958999776 13028416 11839136
23:33:42 9546 8192000000 10874596624 11302842368 1945156640 19.188 100 53 103 4 1971375920 10935520 15283760
23:34:15 3376 8192000000 10906458800 11325853696 1955924272 19.274 100 66 129 1 1989667920 14260128 19483520
23:34:32 10417 8192000000 10903443760 11329191936 1958294720 19.292 100 54 107 0 1987640560 13877872 15467968
23:34:50 8589 8192000000 10908666368 11333922816 1965381056 19.349 100 65 128 4 1998140960 12652272 20107632
23:35:09 11054 8192000000 10908621776 11338387456 1965664544 19.351 100 48 93 2 1993896384 15007680 13224160
23:35:32 4890 8192000000 10911541920 11345133568 1974711488 19.423 100 46 90 1 2002742544 15177600 12853456
23:35:46 7122 8192000000 10932804032 11355475968 1978785600 19.455 100 68 128 2 2012618672 15356560 18476512
23:36:00 6166 8192000000 10935255296 11355029504 1980932144 19.472 100 66 130 3 2016148640 16760896 18455600
23:36:17 3275 8192000000 10929973824 11353731072 1979014256 19.457 100 67 134 1 2016363808 18045264 19304288
23:36:33 4236 8192000000 10923495936 11350958080 1966353856 19.357 99 60 120 0 2005239760 21230832 17655072
23:36:46 4551 8192000000 10938297888 11363401728 1983480464 19.492 100 61 121 0 2022505920 21383552 17641904
23:37:02 7490 8192000000 10938280656 11365253120 1985370624 19.507 100 59 117 0 2024008704 21537664 17100416
23:37:23 4746 8192000000 10935294624 11357339648 1967460736 19.365 99 61 122 1 2006949248 21266544 18221968
23:37:34 3223 8192000000 10945705872 11370676224 1992529344 19.564 100 66 130 3 2032908272 20598176 19780752
23:37:44 2929 8192000000 10974053552 11386527744 2006595152 19.675 100 88 176 2 2055658976 23153024 25910800
23:37:55 2120 8192000000 10955486144 11373711360 1994587824 19.580 100 77 151 0 2038675248 22551008 21536416
23:38:08 2041 8192000000 10965911328 11387346944 2003842448 19.653 100 73 145 1 2045622960 20683344 21097168
23:38:17 6435 8192000000 10966211552 11391930368 2009029264 19.694 100 79 158 2 2053859248 22370784 22459200
23:38:31 2655 8192000000 10952767088 11369279488 1962217776 19.324 98 79 154 1 2006762128 21741200 22803152
23:38:41 3918 8192000000 10945766416 11366772736 1978529072 19.453 99 81 161 2 2024945280 22697264 23718944
23:38:53 3708 8192000000 10954253008 11377283072 1994962608 19.583 100 83 165 1 2043214720 23222784 25029328
23:39:04 1515 8192000000 10947321104 11369041920 1979652544 19.462 99 76 153 0 2025973808 23942880 22378384
23:39:16 3677 8192000000 10955769840 11380711424 1997231920 19.601 100 77 154 1 2043891760 23968512 22691328
23:39:26 4736 8192000000 10964792128 11379761152 1994498448 19.579 100 82 163 0 2044159136 24393248 25267440
23:39:38 5805 8192000000 10950861152 11377508352 1986283408 19.514 100 65 129 1 2032817744 26644672 19889664
23:39:51 2683 8192000000 10960679248 11388112896 1997699024 19.605 100 73 144 0 2048093584 28835328 21559232
23:40:02 5212 8192000000 10978997200 11399233536 2007827360 19.684 100 75 150 0 2061063952 30638592 22598000
23:40:16 2284 8192000000 10964893120 11386241024 1999910304 19.622 100 75 150 1 2054343104 31681328 22751472
23:40:25 8440 8192000000 10939879360 11362922496 1975601440 19.430 99 65 130 1 2027343568 32196400 19545728
23:40:40 5650 8192000000 10951449616 11372011520 1952933968 19.250 98 71 140 0 2007776544 33170464 21672112
23:40:55 8947 8192000000 10956078192 11362566144 1969354816 19.380 100 78 155 1 2028200064 34738192 24107056
23:41:10 3101 8192000000 10944036768 11370094592 1972477072 19.405 100 63 124 2 2027173024 35033456 19662496
23:41:21 3173 8192000000 10942725136 11370389504 1975606304 19.430 100 61 121 2 2026394512 32467104 18321104
23:41:31 3955 8192000000 10939563888 11361239040 1967320560 19.364 100 71 142 0 2023730960 33932016 22478384
23:41:42 2277 8192000000 10962474656 11375632384 1982183392 19.482 100 89 177 2 2043860640 34273152 27404096
23:41:50 4555 8192000000 10918158208 11340705792 1933242880 19.093 98 81 157 0 1992235456 34724016 24268560
23:42:02 5552 8192000000 10899346656 11311943680 1924632144 19.024 99 69 137 0 1978721808 32779744 21309920
23:42:20 11351 8192000000 10909797808 11330342912 1940280832 19.149 100 64 129 0 1990552752 30867856 19404064
23:42:39 3874 8192000000 10926247040 11340214272 1952244944 19.244 100 77 151 1 2008720752 33388480 23087328
23:42:50 3745 8192000000 10933366096 11352371200 1958302624 19.293 100 75 147 2 2015675984 34468048 22905312
23:43:08 2276 8192000000 10920776064 11344654336 1953345440 19.253 100 62 124 0 2007027184 34894512 18787232
23:43:19 2238 8192000000 10938722976 11357761536 1945508912 19.191 99 78 153 1 2004047120 35015472 23522736
23:43:30 1386 8192000000 10925766544 11339513856 1945628896 19.192 100 88 169 2 2006810704 35095792 26086016
23:43:37 1469 8192000000 10931931040 11340636160 1952780176 19.249 100 92 181 5 2015543808 33784928 28978704
23:43:46 2699 8192000000 10927377568 11341766656 1953310832 19.253 100 86 170 0 2014222848 34910272 26001744
23:43:57 6288 8192000000 10933431904 11351818240 1957289232 19.284 100 72 144 0 2015787184 36014880 22483072
23:44:11 4852 8192000000 10939579664 11352969216 1960226800 19.308 100 78 156 3 2021337184 37241008 23869376
23:44:26 3594 8192000000 10940933056 11362107392 1963489104 19.334 100 73 146 1 2026275392 40209136 22577152
23:44:39 9670 8192000000 10917401952 11336880128 1922274544 19.005 98 66 132 0 1983835776 40939408 20621824
23:44:55 3793 8192000000 10942392224 11356901376 1959526480 19.302 100 69 133 2 2021541904 40534624 21480800
23:45:07 1306 8192000000 10940689920 11345702912 1949804736 19.225 99 86 172 0 2017046784 40548256 26693792
23:45:18 2225 8192000000 10933801392 11343843328 1936459456 19.118 99 88 176 4 2005740480 41729856 27551168
23:45:29 2042 8192000000 10925393232 11337416704 1942914624 19.170 100 78 155 2 2007971808 41173840 23883344
23:45:40 2705 8192000000 10937381648 11346022400 1948670528 19.216 100 71 141 2 2014127984 43610656 21846800
23:45:50 3830 8192000000 10924488016 11331063808 1923911760 19.018 99 75 150 1 1991313024 43936608 23464656
23:46:02 1404 8192000000 10928001184 11338756096 1945253136 19.189 100 82 162 3 2015319104 43896592 26169376
23:46:10 1205 8192000000 10948534016 11352182784 1950383184 19.230 100 85 168 1 2022724080 45676752 26664144
23:46:18 4832 8192000000 10956026752 11367735296 1961675504 19.319 100 82 163 0 2041241728 53437184 26129040
23:46:43 2036 8192000000 10974460240 11378372608 1970456480 19.389 100 94 188 1 2051917328 52202384 29258464
23:46:52 2621 8192000000 10963066720 11374284800 1962771248 19.328 100 78 156 1 2041252880 53888464 24593168
23:47:06 8004 8192000000 10938859488 11365019648 1952824448 19.249 100 49 97 0 2018975440 50271056 15879936
23:47:21 11742 8192000000 10931482480 11363975168 1950656848 19.232 100 48 95 0 2016344096 48809648 16877600
23:47:43 4838 8192000000 10957166608 11377250304 1964656608 19.343 100 65 132 2 2035495200 49495760 21342832
23:47:57 4120 8192000000 10965181792 11379261440 1968501680 19.374 100 82 164 2 2043014240 48677168 25835392
23:48:08 4663 8192000000 10969780688 11387604992 1972845392 19.408 100 75 149 1 2048838928 52567648 23425888
23:48:19 1471 8192000000 10966031808 11376709632 1952279008 19.245 99 82 162 2 2032790512 54171808 26339696
23:48:28 3277 8192000000 10972333552 11385970688 1966865216 19.361 100 72 143 1 2045434288 55928832 22640240
23:48:47 14234 8192000000 10941369424 11378298880 1954274928 19.261 100 47 94 0 2027895392 57634304 15986160
23:49:13 7413 8192000000 10944126976 11377238016 1956413072 19.278 100 46 92 1 2027393392 55117184 15863136
23:49:28 8344 8192000000 10931681968 11366379520 1957123616 19.283 100 43 86 1 2024759232 52909312 14726304
23:49:44 5808 8192000000 10941092480 11367313408 1943559728 19.175 99 52 103 1 2008936800 48903872 16473200
23:49:56 3319 8192000000 10936577632 11368857600 1944147232 19.180 99 53 107 3 2011909856 51266432 16496192
23:50:28 14770 8192000000 10906512960 11344146432 1920491120 18.991 99 38 76 2 1982461312 48735344 13234848
23:50:58 24365 8192000000 10918503152 11359531008 1942425664 19.166 100 32 64 5 2004512416 50672400 11414352
23:51:35 14435 8192000000 10924398096 11358978048 1923476080 19.015 99 39 77 0 1984502432 48349600 12676752
23:52:02 9009 8192000000 10925876528 11358015488 1936420336 19.118 100 43 86 1 2006011680 54938656 14652688
23:52:21 12412 8192000000 10914180816 11370147840 1943404576 19.174 100 35 68 3 2011105072 56269888 11430608
23:52:48 24071 8192000000 10918812272 11363696640 1925487776 19.031 99 24 48 0 1980428208 46824912 8115520
23:53:22 9567 8192000000 10921870864 11359129600 1932402032 19.086 99 34 66 2 1994318912 50959296 10957584
23:54:01 22368 8192000000 10932886864 11385085952 1948190256 19.212 100 23 47 3 2009988656 53765152 8033248
23:54:54 5657 8192000000 10954252176 11395530752 1957752672 19.288 100 43 84 1 2028570192 56574528 14242992
23:55:13 21050 8192000000 10944238880 11393269760 1941111072 19.156 99 31 62 2 2006716640 55381824 10223744
23:55:59 37722 8192000000 10924548656 11378814976 1944353008 19.181 100 25 50 2 2005501344 51991872 9156464
23:56:47 25598 8192000000 10910121040 11376910336 1919139712 18.980 99 18 36 1 1988148080 62285616 6722752
23:57:32 21970 8192000000 10905664224 11363074048 1933159216 19.092 100 17 34 0 1993614160 54234080 6220864
23:58:21 47281 8192000000 10918684016 11360043008 1965405184 19.349 100 26 52 1 1991861632 19384704 7071744
23:59:15 9294 8192000000 10898853728 11349721088 1969897344 19.385 100 44 87 3 1991559248 9816336 11845568
23:59:31 35870 8192000000 10902515776 11369054208 1960831760 19.313 100 11 22 1 1979463264 15925152 2706352
00:00:13 93334 8192000000 10893934528 11363004416 1927291264 19.045 98 4 8 0 1939539456 11615056 633136
00:01:52 37221 8192000000 10921548272 11374002176 1959547888 19.302 99 18 35 1 1974740240 10309568 4882784
00:02:47 101324 8192000000 10910566352 11363782656 1959674832 19.303 99 28 57 0 1981986368 14446112 7865424
00:04:35 58299 8192000000 10911262752 11378532352 1968195024 19.371 99 37 74 1 1989154112 10813232 10145856
00:05:54 92807 8192000000 10941059664 11400609792 1980214288 19.466 100 29 58 0 1999147584 10278496 8654800
00:07:38 16361 8192000000 10949596480 11395293184 1998758656 19.613 100 62 123 1 2027012368 10806464 17447248
00:08:03 41692 8192000000 10929813616 11392684032 1988791744 19.534 100 40 80 2 2015499248 15326928 11380576
00:08:53 38779 8192000000 10937721104 11394289664 1994304544 19.578 100 29 56 0 2011230384 8451792 8474048
00:09:41 11163 8192000000 10936664224 11385954304 1975688304 19.431 99 55 110 0 1999667088 8194896 15783888
00:10:02 14948 8192000000 10932223104 11389968384 1974601568 19.422 99 38 76 0 1998519872 13412896 10505408
00:10:24 49530 8192000000 10938219152 11393335296 1975870512 19.432 99 53 107 1 2004747440 13404256 15472672
00:11:20 27456 8192000000 10940760816 11403943936 1995653280 19.588 100 32 64 2 2018305824 13548368 9104176
00:11:53 3077 8192000000 10960993344 11410980864 2005900912 19.669 100 43 86 0 2033900352 15854976 12144464
00:12:03 20256 8192000000 10938920832 11409674240 2003514128 19.650 100 25 50 0 2026838352 16125088 7199136
00:12:31 22327 8192000000 10938424176 11410448384 2002518112 19.643 100 15 29 1 2022651120 15398336 4734672
00:13:00 46404 8192000000 10947560560 11413909504 1966993136 19.362 98 24 48 0 1995748720 21743856 7011728
00:14:03 22550 8192000000 10981565072 11437326336 2020945184 19.788 100 63 126 0 2060251872 20295312 19011376
00:14:52 46141 8192000000 10949712416 11432034304 1984426448 19.500 99 19 38 0 2021113904 30190720 6496736
00:15:45 48420 8192000000 10939530672 11435421696 1998348800 19.610 100 16 32 0 2028413936 24978944 5086192
00:16:41 91603 8192000000 10927007328 11392847872 1947192320 19.204 97 14 28 1 1965056768 13321904 4542544
00:18:41 50286 8192000000 10903958336 11383451648 1963529392 19.334 99 12 24 1 1980833136 13538960 3764784
00:19:40 52181 8192000000 10874254976 11356848128 1935578352 19.111 98 11 22 0 1950823056 12062864 3181840
00:20:39 59898 8192000000 10905609456 11383033856 1942794944 19.169 98 16 32 0 1954943056 7335456 4812656
00:21:50 39878 8192000000 10938219408 11393671168 1970313952 19.388 99 42 84 3 1993276496 10685664 12276880
00:22:41 50697 8192000000 10899661088 11375820800 1921826704 19.001 97 18 36 0 1940433008 13361344 5244960
00:23:51 41597 8192000000 10923114448 11373371392 1927256080 19.045 98 25 46 0 1941684096 7893104 6534912
00:24:42 20474 8192000000 10907814400 11366068224 1955726704 19.272 99 46 92 2 1977222176 8627216 12868256
00:25:09 33332 8192000000 10887595296 11354021888 1907030944 18.883 97 21 42 0 1921716144 8991328 5693872
00:25:50 24200 8192000000 10871576432 11329757184 1897728672 18.808 97 31 63 2 1915595696 9556560 8310464
00:26:23 12061 8192000000 10898272304 11334369280 1906137712 18.876 98 56 112 0 1931747344 10494320 15115312
00:26:48 32462 8192000000 10882585872 11350417408 1946986688 19.202 100 39 78 1 1969918656 11959408 10972560
00:27:36 33635 8192000000 10816574640 11272429568 1785032896 17.891 92 15 30 0 1796210976 7095840 4082240
00:28:16 73808 8192000000 10839669120 11305189376 1790044336 17.932 94 22 44 1 1805899024 9249520 6605168
00:29:39 52490 8192000000 10834325840 11293270016 1813884640 18.128 95 23 46 0 1831107744 10512688 6710416
00:30:41 52844 8192000000 10852784992 11309441024 1865376496 18.547 97 33 66 0 1887571936 12916816 9278624
00:32:22 101270 8192000000 10875411136 11342823424 1861948256 18.519 96 16 30 2 1877547600 10540624 5058720
00:34:31 62832 8192000000 10866615840 11347976192 1919302128 18.981 99 7 14 2 1936508320 14979424 2226768
00:35:40 131490 8192000000 10848201648 11324547072 1868417168 18.571 96 31 62 1 1886931536 9502672 9011696
00:38:24 15603 8192000000 10858367824 11327508480 1913291168 18.933 99 18 36 0 1928682256 10053280 5337808
00:38:46 947 8192000000 10871948704 11325497344 1928965104 19.059 100 38 75 1 1947674192 7770704 10938384
00:38:54 19671 8192000000 10886275440 11336331264 1927239216 19.045 99 58 112 1 1951960864 9446128 15275520
00:39:23 46428 8192000000 10864287248 11334115328 1904273840 18.861 98 35 71 1 1922457360 8611872 9571648
00:40:16 63460 8192000000 10831193552 11308097536 1851107040 18.431 95 13 26 1 1867187040 12396992 3683008
00:41:26 87796 8192000000 10866054128 11337736192 1914602176 18.944 99 14 28 1 1933366400 14759104 4005120
00:43:00 63025 8192000000 10862443872 11339304960 1920190416 18.988 99 14 28 0 1935936928 11602896 4143616
00:44:19 85523 8192000000 10854179664 11327873024 1899144576 18.819 98 20 40 1 1913086208 8164928 5776704
00:46:23 31551 8192000000 10870959968 11349508096 1947422864 19.206 100 33 64 2 1965677312 8954560 9299888
00:47:41 78801 8192000000 10868066608 11352928256 1932318736 19.085 99 4 8 1 1940902576 7576640 1007200
00:49:06 47861 8192000000 10886952224 11372572672 1964683568 19.343 100 23 46 4 1979861392 8245008 6932816
00:50:00 28540 8192000000 10896606880 11363606528 1947483216 19.206 99 28 56 1 1963846128 7981296 8381616
00:50:44 71135 8192000000 10878200384 11364470784 1948106976 19.211 99 13 26 1 1962364400 10385856 3871568
00:52:01 34318 8192000000 10907369136 11378483200 1952136048 19.243 99 26 52 1 1970813488 11657376 7020064
00:52:46 39427 8192000000 10928599264 11403730944 1984723424 19.502 100 42 84 2 2011818704 14295984 12799296
00:53:34 28326 8192000000 10911635824 11392978944 1985759456 19.510 100 26 52 3 2005612576 11910944 7942176
00:54:09 37684 8192000000 10925603712 11398733824 1969876976 19.384 99 15 29 0 1984047216 10044672 4125568
00:55:17 62967 8192000000 10913538592 11392036864 1926648880 19.040 97 13 26 0 1939521872 9445504 3427488
00:56:32 25274 8192000000 10935098288 11407069184 1990998752 19.552 100 31 62 1 2012510832 12505632 9006448
00:57:09 61165 8192000000 10927871456 11391381504 1955186944 19.268 98 20 39 1 1976694416 15151168 6356304
00:58:17 66020 8192000000 10927675072 11416915968 1969354224 19.380 98 25 50 3 1986598720 9934368 7310128
00:59:34 101682 8192000000 10945073152 11421552640 1948662688 19.216 97 18 36 1 1970472128 16673056 5136384
01:01:22 71525 8192000000 10933901872 11416395776 1965495600 19.350 98 15 30 3 1980747136 10159568 5091968
01:02:46 61941 8192000000 10918752448 11411795968 1944408224 19.182 97 20 40 2 1971693120 21892560 5392336
01:04:09 82584 8192000000 10913011664 11397304320 1971664144 19.399 99 19 35 0 1984940704 9047344 4229216
01:05:40 31394 8192000000 10920750720 11403018240 1991631072 19.557 100 16 32 0 2005567984 9235360 4701552
01:06:17 25567 8192000000 10888110304 11379367936 1950165120 19.228 98 14 28 1 1962475168 8558464 3751584
01:06:50 59026 8192000000 10891919920 11382075392 1949827376 19.225 98 14 28 1 1961286096 7332544 4126176
01:07:57 61561 8192000000 10875337424 11362885632 1901829552 18.841 96 7 14 1 1913876512 9847936 2199024
01:09:05 36106 8192000000 10879996912 11367505920 1939825488 19.145 99 14 27 0 1953804400 10240016 3738896
01:09:50 39584 8192000000 10886675600 11367645184 1931279200 19.077 98 21 43 2 1946482192 9223744 5979248
01:10:56 82604 8192000000 10862236928 11363352576 1919335264 18.982 98 18 36 2 1942476592 17731792 5409536
01:12:25 49883 8192000000 10875906976 11357630464 1911116064 18.916 98 6 12 0 1926651888 13499488 2036336
01:13:21 30782 8192000000 10888326768 11357442048 1919825808 18.985 98 26 52 3 1933186640 5947280 7413552
01:13:58 21745 8192000000 10897723856 11368751104 1960013200 19.306 100 24 48 0 1974290704 7658432 6619072
01:14:30 39558 8192000000 10893348592 11371061248 1957165520 19.284 99 29 58 0 1980665392 15835024 7664848
01:15:17 27825 8192000000 10874949760 11345510400 1867794208 18.566 95 14 28 1 1880924960 9482304 3648448
01:15:55 48597 8192000000 10857690144 11338723328 1874230016 18.618 96 22 44 0 1894624336 13985488 6408832
01:16:52 46085 8192000000 10854016848 11323211776 1859438912 18.499 96 19 38 0 1874714832 10052784 5223136
01:17:44 53528 8192000000 10856523904 11329355776 1894237728 18.780 98 35 70 2 1918049312 13709760 10101824
01:18:51 69811 8192000000 10842700656 11311710208 1831405248 18.271 95 15 30 1 1849559536 13962128 4192160
01:20:08 49616 8192000000 10841904016 11310682112 1862008096 18.520 97 29 59 1 1879766928 9463808 8295024
01:21:04 45691 8192000000 10880428176 11338510336 1917781936 18.969 99 35 69 0 1941242288 14103824 9356528
01:21:58 42695 8192000000 10870366896 11340513280 1885745472 18.711 97 34 68 0 1908759360 13622224 9391664
01:22:57 38506 8192000000 10862389904 11341975552 1898893392 18.817 98 20 40 1 1916390608 12097984 5399232
01:25:44 108234 8192000000 9159774624 9416798208 299648352 3.528 16 5 9 0 303569312 2622576 1298384

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 25-03-2021 01:29:41 to 25-03-2021 01:30:14.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 103 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-03-2021 01:30:15 to 25-03-2021 01:30:17.

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          250724
MON$OLDEST_ACTIVE               250725
MON$OLDEST_SNAPSHOT             250725
MON$NEXT_TRANSACTION            250725
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                       2052128
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:261: 
:262: mscs-test-161.budzdorov.ru    Thu Mar 25 01:28:02 2021
:263:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:264: 
:265: 
:266: mscs-test-161.budzdorov.ru    Thu Mar 25 01:28:03 2021
:267:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:268: 
--- end of diff output ---

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

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