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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 16858372 kB
MemAvailable 31106740 kB
Buffers 0 kB
Cached 14821928 kB
SwapCached 3892 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-02-23 22:27:20
DTS_END                         2021-02-23 22:27:20.3160
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/50314
TRN_ID                          240880
ATT_ID                          670
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: 9535.04 21609 1144205
customer order: creation 176.41 370 21169
customer order: refuse 14.56 331 1747
order to supplier: creation 45.78 1367 5493
order to supplier: removal 3.61 107337 433
invoice (draft): creation 46.43 3474 5572
invoice (draft): removal 55.94 779 6713
invoice accept: apply 42.78 17996 5133
invoice accept: cancel 49.64 816 5957
customer reserve: creation 3958.86 177 475063
customer reserve: removal 4828.56 63 579427
realization accept: apply 83.60 214 10032
realization accept: cancel 95.86 110 11503
payment from customer: creation 59.78 140 7173
payment from customer: removal 5.80 78 696
payment to supplier: creation 50.97 127 6116
payment to supplier: removal 3.34 86 401
service: total inventory turnovers 5.08 985 609
service: total monetary turnovers 7.18 21 861
service: aggregate perf. data 0.86 19583 103
service: refresh index statistics 0.03 278120 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-02-2021 22:28:07 to 23-02-2021 22:28:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4075
TEST_TIME 2 4326
TEST_TIME 3 3845
TEST_TIME 4 4224
TEST_TIME 5 4103
TEST_TIME 6 4129
TEST_TIME 7 5457
TEST_TIME 8 5271
TEST_TIME 9 5355
TEST_TIME 10 5699
TEST_TIME 11 6258
TEST_TIME 12 6404
TEST_TIME 13 6577
TEST_TIME 14 6773
TEST_TIME 15 6733
TEST_TIME 16 6742
TEST_TIME 17 7144
TEST_TIME 18 7494
TEST_TIME 19 7647
TEST_TIME 20 8007
TEST_TIME 21 8121
TEST_TIME 22 8092
TEST_TIME 23 8233
TEST_TIME 24 8634
TEST_TIME 25 8749
TEST_TIME 26 9503
TEST_TIME 27 9657
TEST_TIME 28 9991
TEST_TIME 29 10853
TEST_TIME 30 10646
TEST_TIME 31 10639
TEST_TIME 32 10847
TEST_TIME 33 10715
TEST_TIME 34 10534
TEST_TIME 35 10549
TEST_TIME 36 10506
TEST_TIME 37 10395
TEST_TIME 38 10470
TEST_TIME 39 10464
TEST_TIME 40 10293
TEST_TIME 41 10121
TEST_TIME 42 10035
TEST_TIME 43 10124
TEST_TIME 44 9968
TEST_TIME 45 9967
TEST_TIME 46 9935
TEST_TIME 47 9903
TEST_TIME 48 9810
TEST_TIME 49 9866
TEST_TIME 50 9843
TEST_TIME 51 9951
TEST_TIME 52 9838
TEST_TIME 53 9802
TEST_TIME 54 9720
TEST_TIME 55 9702
TEST_TIME 56 9773
TEST_TIME 57 9639
TEST_TIME 58 9576
TEST_TIME 59 9559
TEST_TIME 60 9503
TEST_TIME 61 9557
TEST_TIME 62 9547
TEST_TIME 63 9626
TEST_TIME 64 9708
TEST_TIME 65 9743
TEST_TIME 66 9727
TEST_TIME 67 9824
TEST_TIME 68 9866
TEST_TIME 69 9846
TEST_TIME 70 9863
TEST_TIME 71 9951
TEST_TIME 72 9937
TEST_TIME 73 9895
TEST_TIME 74 9799
TEST_TIME 75 9770
TEST_TIME 76 9729
TEST_TIME 77 9649
TEST_TIME 78 9686
TEST_TIME 79 9643
TEST_TIME 80 9606
TEST_TIME 81 9539
TEST_TIME 82 9535
TEST_TIME 83 9462
TEST_TIME 84 9439
TEST_TIME 85 9428
TEST_TIME 86 9425
TEST_TIME 87 9407
TEST_TIME 88 9389
TEST_TIME 89 9387
TEST_TIME 90 9529
TEST_TIME 91 9549
TEST_TIME 92 9590
TEST_TIME 93 9559
TEST_TIME 94 9630
TEST_TIME 95 9620
TEST_TIME 96 9598
TEST_TIME 97 9575
TEST_TIME 98 9679
TEST_TIME 99 9621
TEST_TIME 100 9556
TEST_TIME 101 9538
TEST_TIME 102 9515
TEST_TIME 103 9487
TEST_TIME 104 9429
TEST_TIME 105 9405
TEST_TIME 106 9380
TEST_TIME 107 9317
TEST_TIME 108 9361
TEST_TIME 109 9400
TEST_TIME 110 9371
TEST_TIME 111 9413
TEST_TIME 112 9398
TEST_TIME 113 9392
TEST_TIME 114 9416
TEST_TIME 115 9447
TEST_TIME 116 9431
TEST_TIME 117 9433
TEST_TIME 118 9428
TEST_TIME 119 9602
TEST_TIME 120 9538

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 23-02-2021 22:28:10 to 23-02-2021 22:28:14.

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 1584217 1584217 0 0.00 0 21638 6 0 0
doc_list_biud 1584215 1584215 0 0.00 0 57188 29 0 0
sp_add_invoice_to_stock 5283 5133 150 2.83 41 170877 17996 0 150
sp_cancel_adding_invoice 5957 5957 0 0.00 4 54591 817 0 0
sp_cancel_client_order 1747 1747 0 0.00 4 7224 332 0 0
sp_cancel_customer_reserve 579427 579427 0 0.00 1 57193 63 0 0
sp_cancel_pay_from_customer 696 696 0 0.00 2 5457 79 0 0
sp_cancel_pay_to_supplier 401 401 0 0.00 3 4076 87 0 0
sp_cancel_supplier_invoice 6725 6713 12 0.17 1 31171 780 0 12
sp_cancel_supplier_order 433 433 0 0.00 5 906279 107337 0 0
sp_cancel_write_off 11503 11503 0 0.00 1 8753 111 0 0
sp_client_order 21169 21169 0 0.00 4 37294 371 0 0
sp_customer_reserve 475063 475063 0 0.00 0 113862 177 0 0
sp_fill_shopping_cart 32233 32233 0 0.00 1 10908 39 0 0
sp_fill_shopping_cart_clo_res 475054 475054 0 0.00 0 13427 13 0 0
sp_get_clo_for_invoice 5123 5123 0 0.00 0 18344 280 0 0
sp_kill_cost_storno 18557 18557 0 0.00 0 9787 53 0 0
sp_kill_qstorno_ret_qs2qd 1177503 1177503 0 0.00 0 57165 34 0 0
sp_kill_qty_storno 620935 620935 0 0.00 0 57188 74 0 0
sp_lock_selected_doc 20940 20940 0 0.00 0 8493 8 0 0
sp_make_cost_storno 28444 28444 0 0.00 0 13353 56 0 0
sp_multiply_rows_for_pdistr 28444 28444 0 0.00 0 9822 33 0 0
sp_multiply_rows_for_qdistr 21169 21169 0 0.00 0 12666 157 0 0
sp_pay_from_customer 7173 7173 0 0.00 4 21628 141 0 0
sp_pay_to_supplier 6116 6116 0 0.00 4 14211 128 0 0
sp_payment_common 13289 13289 0 0.00 1 21621 35 0 0
sp_qd_handle_on_cancel_clo 1747 1747 0 0.00 0 7217 301 0 0
sp_qd_handle_on_invoice_upd_sts 11080 11080 0 0.00 0 46702 372 0 0
sp_qd_handle_on_reserve_upd_sts 10032 10032 0 0.00 0 25773 81 0 0
sp_reserve_write_off 10032 10032 0 0.00 6 25853 215 0 0
sp_supplier_invoice 5572 5572 0 0.00 6 89095 3474 0 0
sp_supplier_order 5493 5493 0 0.00 5 22704 1367 0 0
srv_aggregate_perf_data 104 103 1 0.96 2229 279423 19583 0 1
srv_fill_mon_cache_memory 162 162 0 0.00 1068 162692 31915 0 0
srv_find_qd_qs_mism 1095386 1095386 0 0.00 0 21637 5 0 0
srv_make_invnt_saldo 609 609 0 0.00 37 22572 986 0 0
srv_make_money_saldo 861 861 0 0.00 0 258 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 241049 341814 278121 0 0
t$perf-abend:sp_add_invoice_to_stock 150 150 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 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 5133 5133 0 0.00 0 14417 158 0 0
t$perf-norm:sp_cancel_adding_invoice 395 395 0 0.00 0 5422 109 0 0
t$perf-norm:sp_cancel_client_order 1747 1747 0 0.00 0 2565 13 0 0
t$perf-norm:sp_cancel_customer_reserve 674 674 0 0.00 0 3846 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 696 696 0 0.00 0 301 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 401 401 0 0.00 0 229 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 424 424 0 0.00 0 519 12 0 0
t$perf-norm:sp_cancel_supplier_order 433 433 0 0.00 0 22361 1494 0 0
t$perf-norm:sp_cancel_write_off 1015 1015 0 0.00 0 2904 11 0 0
t$perf-norm:sp_client_order 21169 21169 0 0.00 0 7911 22 0 0
t$perf-norm:sp_customer_reserve 1020 1020 0 0.00 0 1174 5 0 0
t$perf-norm:sp_pay_from_customer 7173 7173 0 0.00 0 5234 9 0 0
t$perf-norm:sp_pay_to_supplier 6116 6116 0 0.00 0 4746 10 0 0
t$perf-norm:sp_reserve_write_off 10032 10032 0 0.00 0 8882 15 0 0
t$perf-norm:sp_supplier_invoice 5572 5572 0 0.00 0 2654 16 0 0
t$perf-norm:sp_supplier_order 5493 5493 0 0.00 0 3660 16 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 1920 25 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 356 7 0 0
t$perf-norm:srv_make_invnt_saldo 609 609 0 0.00 0 1685 20 0 0
t$perf-norm:srv_make_money_saldo 861 861 0 0.00 0 835 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 10 5 0 0
v_add_invoice_to_stock 10546 10246 300 2.84 0 9598 26 0 300
v_all_customers 38412 38412 0 0.00 0 16 1 0 0
v_all_suppliers 30976 30976 0 0.00 0 22 1 0 0
v_all_wares 42338 42338 0 0.00 0 53 1 0 0
v_cancel_adding_invoice 790 790 0 0.00 0 3527 17 0 0
v_cancel_client_order 3494 3494 0 0.00 0 2813 6 0 0
v_cancel_customer_prepayment 1392 1392 0 0.00 0 3818 9 0 0
v_cancel_customer_reserve 1348 1348 0 0.00 0 1246 5 0 0
v_cancel_payment_to_supplier 802 802 0 0.00 0 3118 12 0 0
v_cancel_supplier_invoice 872 848 24 2.75 0 5715 27 0 24
v_cancel_supplier_order 866 866 0 0.00 0 5956 21 0 0
v_cancel_write_off 2030 2030 0 0.00 0 6054 20 0 0
v_max_id_clo_ord 5492 5492 0 0.00 0 396 1 0 0
v_max_id_clo_res 1020 1020 0 0.00 0 2697 13 0 0
v_max_id_ord_sup 5572 5572 0 0.00 0 3759 4 0 0
v_max_non_paid_invoice 1692 1692 0 0.00 0 1298 3 0 0
v_max_non_paid_realizn 3789 3789 0 0.00 0 2953 6 0 0
v_min_id_clo_ord 5492 5492 0 0.00 0 10854 10 0 0
v_min_id_clo_res 1020 1020 0 0.00 0 4896 14 0 0
v_min_id_ord_sup 5572 5572 0 0.00 0 6575 10 0 0
v_min_non_paid_invoice 6116 6116 0 0.00 0 9958 16 0 0
v_min_non_paid_realizn 7173 7173 0 0.00 0 21619 25 0 0
v_our_firm 10694 10694 0 0.00 0 13 1 0 0
v_reserve_write_off 20064 20064 0 0.00 0 6418 7 0 0
x_lock_depdocs_on_canc_invoice 12246 12246 0 0.00 0 12606 116 0 0
x_lock_depdocs_on_canc_sup_ord 433 433 0 0.00 0 27142 463 0 0
x_make_qstorno_1000_1200 5493 5493 0 0.00 2 22675 1279 0 0
x_make_qstorno_1200_2000 5572 5572 0 0.00 3 89082 3335 0 0
x_make_qstorno_2100_3300 475063 475063 0 0.00 0 113861 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-02-2021 22:28:15 to 23-02-2021 22:28:19.

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:24 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:30 20056 8192000000 10264715536 10572795904 911125568 10.008 71 54 108 2 932058176 2632880 18299728
19:58:01 18236 8192000000 10323378208 10639929344 1376731424 14.387 100 84 168 0 1408318848 4796224 26791200
19:58:30 23272 8192000000 10367667600 10690699264 1414767536 14.726 100 88 176 0 1450506256 6097600 29641120
19:59:01 20354 8192000000 10391222528 10713993216 1438765200 14.939 100 87 174 1 1474594704 6954032 28875472
19:59:31 16214 8192000000 10407258528 10737180672 1461705136 15.141 100 83 166 1 1496406496 7718768 26982592
20:00:03 21161 8192000000 10448224976 10780631040 1503795728 15.509 100 90 180 1 1541348096 8381488 29170880
20:00:37 25957 8192000000 10466050768 10803978240 1520751520 15.657 100 88 176 1 1558803376 9447072 28604784
20:01:28 15649 8192000000 10475893072 10821709824 1538988976 15.815 100 76 152 0 1572142112 9542592 23610544
20:01:57 17010 8192000000 10507024128 10858287104 1568878416 16.073 100 78 155 3 1602739200 9320000 24540784
20:02:29 11239 8192000000 10550390272 10904481792 1613132400 16.451 100 85 170 0 1648904752 9692976 26079376
20:02:51 15963 8192000000 10577446256 10933964800 1633667360 16.626 100 82 164 0 1669534896 10982976 24884560
20:03:19 11817 8192000000 10591525024 10953748480 1649446592 16.760 100 76 152 1 1683843280 11705344 22691344
20:03:37 14385 8192000000 10604244544 10968227840 1662019968 16.866 100 80 160 2 1697938416 11917376 24001072
20:04:00 11196 8192000000 10621219984 10990804992 1679370448 17.012 100 74 148 1 1713458224 12341872 21745904
20:04:19 8536 8192000000 10642601920 11008360448 1701142304 17.195 100 83 166 1 1738480112 12991120 24346688
20:04:38 8196 8192000000 10655359520 11027456000 1709428320 17.264 100 80 157 3 1744612048 13209440 21974288
20:04:53 5321 8192000000 10664140576 11037081600 1725003920 17.394 100 78 154 3 1760548720 13301584 22243216
20:05:05 5762 8192000000 10677867920 11054178304 1738549968 17.507 100 83 166 0 1775985872 13846352 23589552
20:05:18 4887 8192000000 10689051520 11069698048 1750504464 17.606 100 80 156 4 1785755584 12635344 22615776
20:05:29 6886 8192000000 10704768864 11082317824 1765095552 17.727 100 85 170 0 1800988848 11815200 24078096
20:05:43 4557 8192000000 10706732336 11088166912 1777070208 17.825 100 84 168 1 1812917392 11976240 23870944
20:05:54 4780 8192000000 10722887248 11103420416 1787324320 17.910 100 80 160 0 1821624384 12208864 22091200
20:06:06 3346 8192000000 10730429744 11106152448 1784536928 17.887 100 84 165 1 1820296576 13140160 22619488
20:06:16 3472 8192000000 10730685792 11111530496 1791302800 17.942 100 83 164 1 1827650112 13416880 22930432
20:06:26 2882 8192000000 10742656368 11121254400 1797150576 17.991 100 81 160 0 1834085904 13539232 23396096
20:06:35 7718 8192000000 10735789648 11119357952 1802484000 18.034 100 85 169 2 1840201952 14099088 23618864
20:06:51 6947 8192000000 10741002624 11128950784 1803651312 18.044 100 75 148 2 1838419472 13653504 21114656
20:07:05 3369 8192000000 10765616752 11148840960 1823782832 18.209 100 90 180 3 1862411840 13872384 24756624
20:07:15 2410 8192000000 10771321776 11156508672 1827909120 18.242 100 85 173 0 1866334784 14694720 23730944
20:07:24 2720 8192000000 10777312704 11162755072 1832877008 18.283 100 92 185 1 1873247968 13813696 26557264
20:07:34 2815 8192000000 10780680400 11166699520 1837868240 18.323 100 89 176 0 1875283312 12625200 24789872
20:07:43 2500 8192000000 10782981520 11167625216 1842334208 18.360 100 94 186 1 1882329536 13480688 26514640
20:07:52 1711 8192000000 10785543632 11169406976 1842901280 18.364 100 90 181 3 1880215616 13137920 24176416
20:08:00 2531 8192000000 10791408192 11175067648 1842408000 18.360 100 95 190 0 1884370432 14320496 27641936
20:08:09 2061 8192000000 10788040800 11176615936 1847361264 18.401 100 89 176 0 1885653744 13495120 24797360
20:08:17 1760 8192000000 10796365392 11180183552 1852591312 18.443 100 90 184 0 1892718512 13949552 26177648
20:08:26 3145 8192000000 10792957280 11181252608 1853254416 18.449 100 87 174 2 1891612528 13453680 24904432
20:08:36 2211 8192000000 10794960736 11185856512 1855974752 18.471 100 92 184 1 1894682784 12715104 25992928
20:08:45 7719 8192000000 10800634432 11188305920 1857232304 18.481 100 90 180 1 1895241808 12651296 25358208
20:09:00 2229 8192000000 10811075936 11193917440 1861255456 18.513 100 96 194 4 1900652000 12425872 26970672
20:09:09 1378 8192000000 10809382368 11195809792 1861574672 18.516 100 96 192 3 1902347760 13774160 26998928
20:09:17 1624 8192000000 10805248752 11200208896 1861405312 18.515 100 83 166 0 1899768816 14416512 23946992
20:09:24 3354 8192000000 10784838528 11192197120 1859130672 18.496 100 57 114 2 1886338992 11711232 15497088
20:09:34 4178 8192000000 10790053824 11199639552 1857326048 18.482 100 52 104 1 1886395408 14769968 14299392
20:09:48 4836 8192000000 10779140928 11194023936 1858687920 18.493 100 37 74 1 1878013328 9093632 10231776
20:09:59 3434 8192000000 10783049632 11198738432 1862054080 18.520 100 51 101 2 1889726688 13525056 14147552
20:10:16 18122 8192000000 10792677552 11202162688 1866612416 18.557 100 64 128 2 1893662256 8475312 18574528
20:10:42 23688 8192000000 10758126352 11191689216 1858219392 18.489 100 12 24 0 1866527008 4703280 3604336
20:11:13 5090 8192000000 10770658496 11197292544 1864367712 18.539 100 28 56 1 1879147648 6369104 8410832
20:11:24 8306 8192000000 10767041024 11201286144 1865740000 18.550 100 21 42 1 1877884320 5874320 6270000
20:11:40 6429 8192000000 10774945216 11204395008 1866678528 18.557 100 25 48 1 1879893376 6237120 6977728
20:11:53 5283 8192000000 10791927216 11220860928 1875455056 18.628 100 22 44 0 1895215952 13987936 5772960
20:12:04 12449 8192000000 10778868784 11217235968 1880650656 18.670 100 16 32 1 1890258896 5154560 4453680
20:12:23 9754 8192000000 10791462880 11221385216 1881064992 18.674 100 15 30 3 1890917456 5510736 4341728
20:12:40 12502 8192000000 10784733200 11222466560 1885796960 18.712 100 19 38 2 1896734768 5743840 5193968
20:12:59 12452 8192000000 10793244128 11226193920 1886283040 18.716 100 18 36 3 1897909776 6799344 4827392
20:13:21 18560 8192000000 10786506112 11226329088 1888111072 18.731 100 15 30 1 1897890240 5587888 4191280
20:13:46 10715 8192000000 10804203584 11232440320 1889781568 18.744 100 18 34 2 1899931136 5224592 4924976
20:14:04 21668 8192000000 10793927840 11230818304 1892597584 18.767 100 17 34 0 1903850512 5899088 5353840
20:14:32 65831 8192000000 10823904640 11235864576 1861386272 18.515 98 43 86 0 1879648768 4772448 13490048
20:15:44 3317 8192000000 10804396976 11231879168 1887489440 18.726 100 63 126 1 1915031680 9546528 17995712
20:15:54 6685 8192000000 10802515792 11230228480 1883240752 18.691 100 24 49 1 1896939824 6609920 7089152
20:16:11 8089 8192000000 10818034800 11239940096 1893508224 18.774 100 29 59 0 1908435040 6770928 8155888
20:16:28 4087 8192000000 10816118464 11246534656 1898846192 18.817 100 46 92 2 1918403888 6154528 13403168
20:16:39 5916 8192000000 10800093568 11239309312 1892050944 18.762 100 27 54 1 1905798032 5637072 8110016
20:16:52 7139 8192000000 10811843584 11242545152 1891458064 18.758 100 14 28 0 1901667776 5875216 4334496
20:17:09 3352 8192000000 10811057776 11245256704 1899891600 18.825 100 36 71 2 1916294384 6555200 9847584
20:17:20 7191 8192000000 10809992592 11247931392 1900190064 18.828 100 24 48 0 1913265504 6361968 6713472
20:17:36 9177 8192000000 10799020512 11232034816 1870927552 18.592 99 23 44 0 1883481168 5993376 6560240
20:17:53 7257 8192000000 10771850368 11199852544 1778660240 17.838 94 26 52 1 1791782640 5559760 7562640
20:18:07 5701 8192000000 10786450064 11208380416 1863343568 18.530 100 24 46 1 1876498944 6389664 6765712
20:18:21 9566 8192000000 10774788832 11209904128 1855753536 18.469 99 31 61 4 1870440080 5839920 8846624
20:18:39 11801 8192000000 10752837584 11186667520 1779651728 17.847 95 17 33 1 1789233488 5119536 4462224
20:19:01 58930 8192000000 10733067312 11153195008 1682242496 17.036 91 35 70 1 1698074432 5069552 10762384
20:20:06 7623 8192000000 10672382416 11087917056 1662036768 16.866 92 19 38 0 1672826256 5267936 5521552
20:20:24 7384 8192000000 10697342448 11114754048 1760517216 17.689 98 21 40 3 1772298528 5682000 6099312
20:20:38 8415 8192000000 10700404992 11101409280 1679463696 17.013 93 31 62 1 1694757120 5797424 9496000
20:20:56 10652 8192000000 10709320608 11129888768 1766412560 17.737 98 17 34 0 1776562544 5132896 5017088
20:21:13 4943 8192000000 10733592240 11146502144 1813256816 18.123 100 39 79 3 1830475376 6476304 10742256
20:21:24 6073 8192000000 10736664672 11162910720 1826372432 18.230 100 35 70 0 1842446304 5850432 10223440
20:21:37 6947 8192000000 10687149376 11093164032 1657904912 16.831 91 30 60 2 1671197536 4454304 8838320
20:21:52 8933 8192000000 10700084256 11122188288 1751115648 17.611 98 21 42 0 1762199744 4879536 6204560
20:22:07 11233 8192000000 10710933888 11133001728 1774110720 17.801 98 17 34 1 1784497712 5340544 5046448
20:22:24 7961 8192000000 10737643408 11155333120 1795611568 17.978 99 29 58 6 1815060048 10315952 9132528
20:22:40 10237 8192000000 10729903136 11147120640 1798591856 18.002 99 26 52 2 1811544016 5282080 7670080
20:22:59 7887 8192000000 10736915312 11157250048 1806391376 18.066 99 32 62 1 1821295008 5808432 9095200
20:23:15 6369 8192000000 10737204960 11167977472 1831845856 18.274 100 29 58 0 1847013728 5753744 9414128
20:23:32 60104 8192000000 10773587488 11174793216 1820334128 18.180 99 45 88 2 1838815328 5168560 13312640
20:24:38 8566 8192000000 10747856848 11175337984 1822330768 18.197 99 39 78 0 1842211600 8141280 11739552
20:25:00 8410 8192000000 10747361968 11173130240 1824229712 18.212 99 40 80 2 1841259808 5794288 11235808
20:25:14 8048 8192000000 10748237536 11173408768 1837963776 18.324 100 27 54 1 1851889552 5594080 8331696
20:25:29 3774 8192000000 10772075072 11183796224 1849423760 18.417 100 49 98 4 1870082512 6148864 14509888
20:25:40 6766 8192000000 10763983856 11194515456 1851924544 18.438 100 26 53 0 1864083536 5423344 6735648
20:25:55 9379 8192000000 10766977872 11199614976 1858496736 18.491 100 21 42 1 1870471888 6124800 5850352
20:26:12 5955 8192000000 10778027840 11204669440 1863657904 18.533 100 36 74 2 1880170320 5847952 10664464
20:26:25 4736 8192000000 10772321728 11205836800 1865925456 18.551 100 26 53 0 1879300384 5535856 7839072
20:26:41 6974 8192000000 10773274560 11208089600 1867179872 18.561 100 16 32 0 1876951232 5247152 4524208
20:27:00 13783 8192000000 10805334080 11232391168 1880633376 18.670 100 25 48 1 1892621856 5432208 6556272
20:27:20 52984 8192000000 10823441072 11242713088 1895426112 18.789 100 29 58 2 1908785600 5401024 7958464
20:28:28 8738 8192000000 10842047280 11260915712 1913493904 18.935 100 49 92 2 1933972720 7426288 13052528
20:28:48 16627 8192000000 10849202400 11271753728 1920082352 18.988 100 48 96 1 1943071776 9773568 13215856
20:29:13 16715 8192000000 10863324400 11281584128 1930535472 19.071 100 53 105 1 1955487872 9930848 15021552
20:29:47 47792 8192000000 10867964000 11292020736 1935940320 19.114 100 55 110 1 1963747184 11588608 16218256
20:31:02 50491 8192000000 10862903312 11303845888 1938594400 19.136 100 28 56 0 1958670720 11511568 8564752
20:32:03 64800 8192000000 10882436192 11319382016 1943848400 19.177 100 19 38 1 1963631840 14217472 5565968
20:33:15 18329 8192000000 10889754016 11322236928 1958202176 19.292 100 35 68 2 1980256624 11458464 10595984
20:33:40 4955 8192000000 10891382480 11323617280 1962076848 19.323 100 36 72 1 1986123952 13127456 10919648
20:33:54 6063 8192000000 10902270832 11336445952 1965022624 19.346 100 45 90 4 1997172336 19024128 13125584
20:34:14 15390 8192000000 10908838592 11337207808 1972488368 19.405 100 50 100 1 2002637696 14900240 15249088
20:34:37 3015 8192000000 10908336816 11336855552 1972634400 19.406 100 57 113 2 2002721376 13449632 16637344
20:34:46 1914 8192000000 10922331392 11343572992 1973828496 19.416 100 60 120 1 2003639744 12264784 17546464
20:34:55 3735 8192000000 10925696048 11350118400 1979676496 19.462 100 66 132 0 2011588864 12770768 19141600
20:35:12 24448 8192000000 10923996864 11356393472 1978981840 19.457 100 47 93 2 2005889360 13215936 13691584
20:35:44 6810 8192000000 10928239472 11354542080 1981207328 19.474 100 58 112 1 2012893776 15998848 15687600
20:35:59 5710 8192000000 10929642800 11352461312 1981277648 19.475 100 70 138 2 2020094224 17965696 20850880
20:36:16 6280 8192000000 10925468976 11354415104 1980432896 19.468 100 64 127 1 2022396912 23055984 18908032
20:36:30 5279 8192000000 10929251440 11356332032 1981361760 19.475 100 58 116 1 2017591488 18911296 17318432
20:36:43 13743 8192000000 10931695120 11361398784 1984266080 19.498 100 57 114 1 2021221648 19919776 17035792
20:37:11 6250 8192000000 10919067488 11345080320 1969886112 19.385 99 59 117 1 2006258768 19600512 16772144
20:37:26 5076 8192000000 10942406048 11361890304 1985806496 19.511 100 68 135 2 2025449344 19945376 19697472
20:37:39 7127 8192000000 10946473456 11368689664 1993553376 19.572 100 77 154 1 2037605568 21152864 22899328
20:37:58 2790 8192000000 10964452752 11381932032 2002194976 19.640 100 88 174 1 2052506464 24814672 25496816
20:38:14 3591 8192000000 10955619472 11380371456 1997096384 19.600 100 71 142 3 2043459200 25969536 20393280
20:38:25 6845 8192000000 10963289216 11377565696 1998978160 19.615 100 79 156 1 2042565328 21155488 22431680
20:38:39 10402 8192000000 10958023280 11384868864 2005264528 19.664 100 73 145 3 2049458336 22057600 22136208
20:39:06 3652 8192000000 10965977520 11391508480 2006317440 19.673 100 59 115 1 2044765760 21010608 17437712
20:39:20 2691 8192000000 10962875760 11387236352 2009702608 19.699 100 76 150 3 2051740432 19623024 22414800
20:39:30 2434 8192000000 10957500384 11380297728 2001851296 19.637 100 76 152 0 2046517712 22077520 22588896
20:39:42 7290 8192000000 10968383776 11393916928 2006716160 19.676 100 79 157 1 2053528672 23874768 22937744
20:39:57 3740 8192000000 10977243168 11392262144 2009584576 19.698 100 83 167 1 2057810000 23652288 24573136
20:40:08 6048 8192000000 10959386736 11389251584 1988542864 19.532 99 71 142 1 2034212384 24413584 21255936
20:40:21 4057 8192000000 10957843184 11381190656 1988707600 19.534 99 73 144 3 2037421120 26765392 21948128
20:40:33 7525 8192000000 10958225616 11378200576 1975118864 19.426 99 63 126 0 2020400752 25665168 19616720
20:40:49 2666 8192000000 10947017120 11371790336 1986710496 19.518 100 62 124 0 2032538096 26459472 19368128
20:41:00 2708 8192000000 10926730528 11344273408 1951238832 19.236 98 82 163 1 2002177984 25762240 25176912
20:41:09 1680 8192000000 10941241808 11364528128 1979846192 19.463 100 69 137 1 2027912912 26724912 21341808
20:41:18 3656 8192000000 10960196816 11378737152 1991610736 19.557 100 77 154 1 2043279696 28654304 23014656
20:41:31 8294 8192000000 10942149664 11368644608 1966523248 19.358 99 71 141 0 2017737056 29842272 21371536
20:41:51 2365 8192000000 10961050560 11371315200 1988042304 19.528 100 83 167 1 2043276496 30667600 24566592
20:42:01 3949 8192000000 10967793264 11377889280 1985957584 19.512 100 78 155 0 2039506880 30220064 23329232
20:42:11 4935 8192000000 10954411104 11371630592 1981993296 19.480 100 81 159 2 2037823824 31189184 24641344
20:42:24 4211 8192000000 10949380608 11368161280 1967928528 19.369 99 81 160 0 2025023856 31994336 25100992
20:42:36 6727 8192000000 10960686480 11380183040 1985490720 19.508 100 72 144 1 2041150144 33492768 22166656
20:42:52 8528 8192000000 10948255968 11376676864 1978081600 19.450 100 58 113 1 2032829360 36584544 18163216
20:43:07 6487 8192000000 10947982976 11372498944 1973963248 19.417 100 69 138 2 2033777120 37721024 22092848
20:43:27 4964 8192000000 10926248560 11350929408 1938705680 19.136 99 57 114 0 1997688624 40753520 18229424
20:43:39 6810 8192000000 10943588048 11369689088 1968772192 19.376 100 65 128 0 2031886176 41807632 21306352
20:43:53 4846 8192000000 10963085424 11381489664 1978917440 19.456 100 78 156 4 2048087280 43520272 25649568
20:44:06 6086 8192000000 10965245232 11384406016 1982372368 19.483 100 71 143 2 2047555040 41884480 23298192
20:44:22 2283 8192000000 10960153312 11382775808 1972238176 19.403 99 63 125 0 2037698272 45084592 20375504
20:44:33 3994 8192000000 10974401072 11393585152 1990866816 19.551 100 73 146 1 2056875360 42314560 23693984
20:44:46 2757 8192000000 10987192928 11395608576 1989564576 19.540 100 90 180 3 2063092400 44415552 29112272
20:44:56 9303 8192000000 10978635424 11397677056 1993760176 19.573 100 78 154 2 2059066080 41850160 23455744
20:45:14 2409 8192000000 10974804672 11386912768 1979308576 19.459 99 83 164 1 2048258688 42855888 26094224
20:45:27 1061 8192000000 10975536256 11385688064 1980322176 19.467 100 88 174 2 2053404544 45055248 28027120
20:45:35 3347 8192000000 10975489872 11389100032 1975397760 19.428 99 88 175 2 2046093936 43737856 26958320
20:45:45 3831 8192000000 10974188448 11389095936 1988870576 19.535 100 88 175 2 2058192832 42422736 26899520
20:46:00 3005 8192000000 10975170320 11386302464 1985074464 19.505 100 86 171 2 2052511952 41576240 25861248
20:46:15 1444 8192000000 10954562528 11369054208 1947069264 19.203 98 78 156 1 2013296880 42231200 23996416
20:46:24 2430 8192000000 10973025184 11382861824 1977164048 19.442 100 91 182 2 2051534192 46029376 28340768
20:46:34 3134 8192000000 10976020352 11390242816 1985312880 19.507 100 84 167 1 2057732592 47493776 24925936
20:46:44 4234 8192000000 10956272256 11375943680 1958224192 19.292 99 69 136 0 2025013824 45431568 21358064
20:46:58 2040 8192000000 10965718848 11386933248 1985672144 19.510 100 80 159 0 2056604864 46228016 24704704
20:47:13 3005 8192000000 10963707488 11395366912 1982680704 19.486 100 52 104 1 2046806576 47105104 17020768
20:47:31 11397 8192000000 10954923312 11394482176 1985940896 19.512 100 44 86 1 2041967776 41694704 14332176
20:47:51 10327 8192000000 10971068304 11403542528 1994446960 19.579 100 46 90 2 2050532592 41326272 14759360
20:48:09 14503 8192000000 10953839664 11396952064 1989874320 19.543 100 43 86 0 2046161184 42160384 14126480
20:48:55 14097 8192000000 10961145664 11399823360 1987319424 19.523 100 43 86 1 2045103232 43106688 14677120
20:49:17 5131 8192000000 10971638624 11407851520 1991817792 19.558 100 47 91 3 2051724848 44026688 15880368
20:49:30 2984 8192000000 10984100080 11408158720 1993932160 19.575 100 68 136 1 2061615504 46285520 21397824
20:49:41 3415 8192000000 10958597680 11380670464 1970746512 19.391 100 74 148 3 2042295328 47621264 23927552
20:49:51 9212 8192000000 10954630048 11388293120 1969104832 19.378 100 52 104 1 2039598192 52979664 17513696
20:50:09 3270 8192000000 10981607152 11399307264 1978194208 19.450 100 65 130 0 2055824672 56298192 21332272
20:50:23 8689 8192000000 10963598208 11405131776 1976659376 19.438 100 38 77 0 2048212528 58031584 13521568
20:50:43 12545 8192000000 10963761872 11400839168 1977450976 19.445 100 41 82 2 2048000096 56062640 14486480
20:51:05 8547 8192000000 10964093200 11406716928 1980209408 19.466 100 46 92 1 2056704416 59585568 16909440
20:51:28 31461 8192000000 10934867360 11378597888 1911734592 18.921 97 37 72 0 1982297920 57352000 13211328
20:52:06 16417 8192000000 10932508048 11380264960 1950516768 19.231 100 38 76 1 2017062464 53155792 13389904
20:52:29 22463 8192000000 10934409216 11383046144 1947412064 19.206 100 26 52 0 2016350896 58809888 10128944
20:52:58 17223 8192000000 10943462176 11389415424 1955692080 19.272 100 34 68 0 2029681456 60825440 13163936
20:53:41 34218 8192000000 10926480368 11379433472 1948752784 19.217 100 30 60 2 2004929488 45944400 10232304
20:54:22 23455 8192000000 10936786464 11383291904 1957743680 19.288 100 31 63 0 2013686880 45924688 10018512
20:54:54 26975 8192000000 10921290032 11373330432 1917136832 18.964 98 27 54 3 1972349808 45849664 9363312
20:55:28 26638 8192000000 10881865904 11339313152 1901770064 18.841 98 13 26 0 1944118112 37443904 4904144
20:56:07 37183 8192000000 10858990432 11337375744 1918750560 18.977 99 18 36 0 1967257232 42191088 6315584
20:57:05 42987 8192000000 10915947360 11355951104 1947436192 19.206 100 46 90 2 1976758608 16400368 12922048
20:57:55 10773 8192000000 10906292624 11354492928 1950029856 19.227 99 52 103 2 1979186336 14558176 14598304
20:58:33 89074 8192000000 10887091488 11370037248 1937366848 19.126 99 9 18 0 1962254656 22023888 2863920
21:00:08 96332 8192000000 10894144896 11360264192 1946004704 19.195 99 23 46 1 1963805200 11758192 6042304
21:01:55 27405 8192000000 10899179168 11339173888 1908831808 18.897 97 40 80 2 1931041568 11186896 11022864
21:02:33 91755 8192000000 10909341456 11376242688 1949749232 19.224 99 15 30 0 1963513664 9227856 4536576
21:04:11 34172 8192000000 10916457136 11369017344 1944073664 19.179 98 16 32 0 1956762240 7972032 4716544
21:04:52 47957 8192000000 10915239344 11393531904 1983490848 19.492 100 17 35 3 2002144768 13241664 5412256
21:05:49 101334 8192000000 10911254752 11376070656 1921927520 19.002 97 12 24 0 1938719728 13411840 3380368
21:07:39 100860 8192000000 10935791760 11392516096 1981957776 19.480 100 26 52 1 2001347568 11564048 7825744
21:09:27 94078 8192000000 10915546000 11379838976 1947258624 19.205 98 32 64 1 1972911328 15866560 9786144
21:11:11 48074 8192000000 10911997712 11374252032 1955815936 19.273 99 24 48 1 1977663376 14629856 7217584
21:12:07 16430 8192000000 10882658544 11350134784 1953193840 19.252 99 27 54 3 1975702672 14532176 7976656
21:12:36 20832 8192000000 10892618992 11351662592 1943295920 19.173 98 43 85 1 1967807616 12465680 12046016
21:13:09 11123 8192000000 10898077568 11363999744 1969484592 19.381 100 15 30 3 1984061808 10392448 4184768
21:13:26 69061 8192000000 10930068864 11391746048 1958801584 19.297 99 16 32 0 1975777344 12244592 4731168
21:14:44 34545 8192000000 10924922160 11388772352 1988286608 19.530 100 33 66 0 2011877104 13755184 9835312
21:15:47 32833 8192000000 10952102496 11398631424 1995734080 19.589 100 36 71 1 2026202432 19070192 11398160
21:16:27 23426 8192000000 10927725472 11392892928 1979432432 19.460 99 33 66 1 2006031856 17158704 9440720
21:17:34 101736 8192000000 10899240208 11386298368 1960210336 19.308 98 12 24 0 1975704320 12028080 3465904
21:19:23 35236 8192000000 10911431760 11381743616 1984727200 19.502 100 20 40 2 2000715456 10051632 5936624
21:20:09 162692 8192000000 10899637856 11391455232 1931716944 19.081 97 13 26 0 1948761440 13547008 3497488
21:22:58 2149 8192000000 10902339712 11389800448 1975970528 19.433 100 11 22 0 1995590800 16048480 3571792
21:23:37 47881 8192000000 10890373120 11377106944 1956156992 19.275 99 22 43 2 1974462752 11976112 6329648
21:25:43 86955 8192000000 10883785360 11371708416 1912445712 18.926 97 14 28 2 1924377744 8846144 3085888
21:27:16 50863 8192000000 10883847488 11355373568 1895890848 18.793 96 17 34 0 1912501600 11862704 4748048
21:28:13 40915 8192000000 10877140592 11337863168 1894277056 18.780 97 12 24 1 1906656816 9584112 2795648
21:29:02 53238 8192000000 10904928512 11373117440 1959487312 19.302 100 12 24 0 1974318128 11710160 3120656
21:30:16 62291 8192000000 10856357088 11330732032 1870946016 18.592 95 14 28 0 1893128016 17697616 4484384
21:31:36 65286 8192000000 10881781360 11334946816 1872012528 18.601 96 23 46 0 1896313776 17447936 6853312
21:32:54 49912 8192000000 10880220592 11352829952 1925794192 19.033 99 23 46 2 1948985088 16237840 6953056
21:33:54 75286 8192000000 10879667520 11362627584 1882478000 18.685 96 25 50 0 1912507056 22644064 7384992
21:37:08 59170 8192000000 10900310592 11360526336 1898541408 18.815 97 16 32 0 1916739696 13815264 4383024
21:38:15 111979 8192000000 10899312896 11360845824 1902270144 18.845 97 29 58 0 1930591600 20440896 7880560
21:40:14 55599 8192000000 10881148192 11342495744 1922350496 19.006 98 29 58 2 1938095184 7508400 8236288
21:41:19 139797 8192000000 10847459504 11310583808 1811280592 18.106 93 21 42 1 1827078288 9758176 6039520
21:43:53 55296 8192000000 10886234384 11334979584 1933024416 19.091 99 46 91 1 1959307936 13681280 12602240
21:44:55 42891 8192000000 10861666400 11333615616 1912944576 18.930 98 39 76 0 1934439264 10142032 11352656
21:46:38 61811 8192000000 10868266912 11337232384 1912580944 18.927 98 9 18 0 1921660864 6754800 2325120
21:47:55 49979 8192000000 10881063152 11353575424 1943419184 19.174 99 20 39 1 1956789088 7974272 5395632
21:50:19 75456 8192000000 10860497184 11341946880 1914314192 18.941 98 16 32 0 1925996624 7310016 4372416
21:51:40 27405 8192000000 10845307344 11328335872 1881711584 18.679 97 5 10 0 1889980032 6955840 1312608
21:52:14 39085 8192000000 10854349664 11326910464 1885449968 18.709 97 11 22 0 1895700608 7390304 2860336
21:52:59 15564 8192000000 10875270096 11338018816 1948641776 19.216 100 35 68 2 1964735248 6452800 9640672
21:53:23 24635 8192000000 10901734992 11361415168 1956637872 19.279 100 42 84 0 1978025296 9936272 11451152
21:54:00 50357 8192000000 10904721808 11359178752 1926465008 19.039 98 20 40 0 1942700848 10702480 5533360
21:55:03 28105 8192000000 10904776960 11372146688 1970169120 19.387 100 28 55 2 1991082272 11522128 9391024
21:55:39 35622 8192000000 10922108736 11389292544 1977143648 19.442 100 32 64 1 1999586464 13508240 8934576
21:56:41 105297 8192000000 10888278112 11361906688 1914633408 18.944 97 19 38 0 1934552928 14578784 5340736
21:58:32 123583 8192000000 10898377232 11376959488 1837075760 18.317 93 13 25 0 1850442496 10405552 2961184
22:00:42 88081 8192000000 10891390864 11373096960 1958535472 19.294 99 13 26 0 1983169808 20915232 3719104
22:02:16 65199 8192000000 10927964864 11400908800 1963743424 19.336 99 14 28 0 1981728608 14432288 3552896
22:03:28 49636 8192000000 10940629008 11404857344 1998852032 19.614 100 23 46 0 2015654176 10420000 6382144
22:04:27 17266 8192000000 10944325504 11392765952 1979352576 19.460 99 54 109 1 2005052720 10640592 15059552
22:04:53 30970 8192000000 10919427024 11403120640 1988098208 19.529 100 38 76 1 2015720192 16731072 10890912
22:05:34 104430 8192000000 10909153632 11375550464 1908967408 18.898 96 19 38 0 1924379008 9664192 5747408
22:07:42 72725 8192000000 10895359184 11367841792 1920226704 18.989 97 27 54 0 1935563248 8561392 6775152
22:09:10 22990 8192000000 10901221984 11363991552 1955679328 19.272 99 34 68 0 1974614912 9421712 9513872
22:09:40 27769 8192000000 10891219648 11354292224 1931079392 19.076 98 36 73 0 1949879584 8052128 10748064
22:10:16 66523 8192000000 10862803792 11348189184 1931074608 19.075 99 7 14 0 1939728416 6805984 1847824
22:11:36 36640 8192000000 10875897280 11356106752 1939468896 19.143 99 15 30 0 1953228272 9235632 4523744
22:12:19 61249 8192000000 10894268288 11375423488 1948705680 19.216 99 21 42 0 1968588640 13769744 6113216
22:13:28 51947 8192000000 10870635792 11356180480 1916162592 18.956 97 14 28 0 1935857552 15678944 4016016
22:14:39 78193 8192000000 10856580160 11353178112 1895985200 18.794 97 9 18 0 1918952928 19983184 2984544
22:16:11 68323 8192000000 10876589040 11353989120 1891748832 18.760 97 11 22 0 1909024224 14390208 2885184
22:17:28 34150 8192000000 10874656400 11347824640 1930391536 19.070 99 18 36 3 1946537632 11279792 4866304
22:18:22 35168 8192000000 10876528768 11350351872 1925076976 19.027 99 24 48 0 1942158400 9940064 7141360
22:19:06 43855 8192000000 10863977840 11329441792 1894305936 18.780 97 27 54 0 1912359168 10326928 7726304
22:20:03 41353 8192000000 10880145280 11340693504 1907878416 18.890 98 43 85 1 1935191888 14649200 12664272
22:20:56 44688 8192000000 10871470544 11343691776 1911316464 18.917 98 37 72 1 1938735312 17819856 9598992
22:21:53 72768 8192000000 10861845536 11336126464 1848693328 18.412 95 32 64 2 1871966512 14344880 8928304
22:23:20 66389 8192000000 10857058992 11323789312 1843651984 18.371 95 17 34 1 1867951232 18142944 6156304
22:24:57 38856 8192000000 10882727824 11346604032 1920645744 18.992 99 35 69 1 1950046000 19461232 9939024
22:25:48 57824 8192000000 10859327408 11366473728 1893068320 18.771 98 15 30 1 1924779728 27591072 4120336
22:26:52 43211 8192000000 9378515440 9665220608 510642720 5.867 27 1 2 0 517967008 7262160 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 23-02-2021 22:28:20 to 23-02-2021 22:28:52.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 150 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-02-2021 22:28:53 to 23-02-2021 22:28:55.

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          241493
MON$OLDEST_ACTIVE               241494
MON$OLDEST_SNAPSHOT             241494
MON$NEXT_TRANSACTION            241494
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                       2045024
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:216: 
:217: mscs-test-161.budzdorov.ru    Tue Feb 23 22:27:37 2021
:218:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:219: 
:220: 
:221: mscs-test-161.budzdorov.ru    Tue Feb 23 22:27:37 2021
:222:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:223: 
:224: 
:225: mscs-test-161.budzdorov.ru    Tue Feb 23 22:27:37 2021
:226:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:227: 
--- end of diff output ---

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

23.02.21 22:28:56. 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-02-23 22:28:58 No severe PSQL-related problems occured
23.02.21 22:28:59. End of report.