Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 16.02.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 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 17035308 kB
MemAvailable 31187896 kB
Buffers 0 kB
Cached 14687812 kB
SwapCached 4384 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-16 01:27:17
DTS_END                         2021-02-16 01:27:17.9200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41062
TRN_ID                          238984
ATT_ID                          702
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: 9207.40 20777 1104888
customer order: creation 176.22 350 21146
customer order: refuse 15.12 336 1814
order to supplier: creation 44.66 1304 5359
order to supplier: removal 3.45 100049 414
invoice (draft): creation 46.94 3316 5633
invoice (draft): removal 53.42 761 6410
invoice accept: apply 41.58 18710 4989
invoice accept: cancel 48.36 795 5803
customer reserve: creation 3764.68 189 451761
customer reserve: removal 4709.91 57 565189
realization accept: apply 84.63 176 10156
realization accept: cancel 88.07 108 10568
payment from customer: creation 58.77 130 7052
payment from customer: removal 5.93 55 712
payment to supplier: creation 50.05 148 6006
payment to supplier: removal 3.20 95 384
service: total inventory turnovers 4.87 977 584
service: total monetary turnovers 6.68 25 801
service: aggregate perf. data 0.86 21037 103
service: refresh index statistics 0.03 266921 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-02-2021 01:29:17 to 16-02-2021 01:29:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7411
TEST_TIME 2 6246
TEST_TIME 3 6002
TEST_TIME 4 6146
TEST_TIME 5 6041
TEST_TIME 6 6447
TEST_TIME 7 6169
TEST_TIME 8 6242
TEST_TIME 9 6587
TEST_TIME 10 6392
TEST_TIME 11 6290
TEST_TIME 12 6192
TEST_TIME 13 6506
TEST_TIME 14 6670
TEST_TIME 15 6844
TEST_TIME 16 6906
TEST_TIME 17 6950
TEST_TIME 18 7566
TEST_TIME 19 7864
TEST_TIME 20 8019
TEST_TIME 21 8787
TEST_TIME 22 8798
TEST_TIME 23 9096
TEST_TIME 24 9436
TEST_TIME 25 9758
TEST_TIME 26 10089
TEST_TIME 27 10198
TEST_TIME 28 10979
TEST_TIME 29 10892
TEST_TIME 30 10805
TEST_TIME 31 10625
TEST_TIME 32 10528
TEST_TIME 33 10326
TEST_TIME 34 10189
TEST_TIME 35 10331
TEST_TIME 36 10204
TEST_TIME 37 10011
TEST_TIME 38 10098
TEST_TIME 39 10009
TEST_TIME 40 9923
TEST_TIME 41 9799
TEST_TIME 42 9954
TEST_TIME 43 9867
TEST_TIME 44 9880
TEST_TIME 45 9876
TEST_TIME 46 9719
TEST_TIME 47 9737
TEST_TIME 48 9608
TEST_TIME 49 9602
TEST_TIME 50 9536
TEST_TIME 51 9414
TEST_TIME 52 9412
TEST_TIME 53 9419
TEST_TIME 54 9451
TEST_TIME 55 9460
TEST_TIME 56 9533
TEST_TIME 57 9521
TEST_TIME 58 9572
TEST_TIME 59 9601
TEST_TIME 60 9572
TEST_TIME 61 9719
TEST_TIME 62 9718
TEST_TIME 63 9761
TEST_TIME 64 9763
TEST_TIME 65 9748
TEST_TIME 66 9791
TEST_TIME 67 9709
TEST_TIME 68 9644
TEST_TIME 69 9672
TEST_TIME 70 9578
TEST_TIME 71 9588
TEST_TIME 72 9533
TEST_TIME 73 9482
TEST_TIME 74 9518
TEST_TIME 75 9452
TEST_TIME 76 9412
TEST_TIME 77 9435
TEST_TIME 78 9396
TEST_TIME 79 9411
TEST_TIME 80 9420
TEST_TIME 81 9507
TEST_TIME 82 9517
TEST_TIME 83 9506
TEST_TIME 84 9622
TEST_TIME 85 9568
TEST_TIME 86 9612
TEST_TIME 87 9646
TEST_TIME 88 9703
TEST_TIME 89 9687
TEST_TIME 90 9591
TEST_TIME 91 9551
TEST_TIME 92 9498
TEST_TIME 93 9485
TEST_TIME 94 9414
TEST_TIME 95 9375
TEST_TIME 96 9346
TEST_TIME 97 9320
TEST_TIME 98 9317
TEST_TIME 99 9366
TEST_TIME 100 9406
TEST_TIME 101 9384
TEST_TIME 102 9396
TEST_TIME 103 9524
TEST_TIME 104 9503
TEST_TIME 105 9467
TEST_TIME 106 9501
TEST_TIME 107 9479
TEST_TIME 108 9481
TEST_TIME 109 9511
TEST_TIME 110 9496
TEST_TIME 111 9446
TEST_TIME 112 9398
TEST_TIME 113 9377
TEST_TIME 114 9381
TEST_TIME 115 9339
TEST_TIME 116 9291
TEST_TIME 117 9324
TEST_TIME 118 9272
TEST_TIME 119 9288
TEST_TIME 120 9215

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 16-02-2021 01:29:20 to 16-02-2021 01:29:24.

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 1523186 1523186 0 0.00 0 32615 7 0 0
doc_list_biud 1523186 1523186 0 0.00 0 31689 27 0 0
sp_add_invoice_to_stock 5122 4989 133 2.59 34 209245 18710 0 133
sp_cancel_adding_invoice 5803 5803 0 0.00 4 52594 795 0 0
sp_cancel_client_order 1814 1814 0 0.00 4 8073 336 0 0
sp_cancel_customer_reserve 565189 565189 0 0.00 1 31693 58 0 0
sp_cancel_pay_from_customer 712 712 0 0.00 3 1800 55 0 0
sp_cancel_pay_to_supplier 384 384 0 0.00 3 6611 95 0 0
sp_cancel_supplier_invoice 6421 6410 11 0.17 2 11060 761 0 11
sp_cancel_supplier_order 414 414 0 0.00 8 1122057 100050 0 0
sp_cancel_write_off 10568 10568 0 0.00 1 15321 109 0 0
sp_client_order 21146 21146 0 0.00 4 32916 350 0 0
sp_customer_reserve 451761 451761 0 0.00 0 103699 189 0 0
sp_fill_shopping_cart 32133 32133 0 0.00 1 14910 40 0 0
sp_fill_shopping_cart_clo_res 451746 451746 0 0.00 0 14626 13 0 0
sp_get_clo_for_invoice 4974 4974 0 0.00 0 22285 261 0 0
sp_kill_cost_storno 17467 17467 0 0.00 0 6906 51 0 0
sp_kill_qstorno_ret_qs2qd 1147770 1147770 0 0.00 0 31686 31 0 0
sp_kill_qty_storno 605328 605328 0 0.00 0 31688 67 0 0
sp_lock_selected_doc 20967 20967 0 0.00 0 8228 6 0 0
sp_make_cost_storno 28188 28188 0 0.00 0 15188 57 0 0
sp_multiply_rows_for_pdistr 28188 28188 0 0.00 0 10030 32 0 0
sp_multiply_rows_for_qdistr 21146 21146 0 0.00 0 14542 155 0 0
sp_pay_from_customer 7052 7052 0 0.00 4 31300 130 0 0
sp_pay_to_supplier 6006 6006 0 0.00 5 17820 149 0 0
sp_payment_common 13058 13058 0 0.00 2 31282 39 0 0
sp_qd_handle_on_cancel_clo 1814 1814 0 0.00 0 8067 307 0 0
sp_qd_handle_on_invoice_upd_sts 10777 10777 0 0.00 0 23189 330 0 0
sp_qd_handle_on_reserve_upd_sts 10156 10156 0 0.00 0 11721 49 0 0
sp_reserve_write_off 10156 10156 0 0.00 7 11862 177 0 0
sp_supplier_invoice 5633 5633 0 0.00 5 69216 3316 0 0
sp_supplier_order 5359 5359 0 0.00 6 35142 1304 0 0
srv_aggregate_perf_data 104 103 1 0.96 2563 449445 21038 0 1
srv_fill_mon_cache_memory 159 159 0 0.00 1279 164472 30435 0 0
srv_find_qd_qs_mism 1057184 1057184 0 0.00 0 32615 6 0 0
srv_make_invnt_saldo 584 584 0 0.00 33 39191 978 0 0
srv_make_money_saldo 801 801 0 0.00 1 1542 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 103508 397923 266922 0 0
t$perf-abend:sp_add_invoice_to_stock 133 133 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 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 4989 4989 0 0.00 0 15721 171 0 0
t$perf-norm:sp_cancel_adding_invoice 417 417 0 0.00 1 3100 91 0 0
t$perf-norm:sp_cancel_client_order 1814 1814 0 0.00 0 5736 16 0 0
t$perf-norm:sp_cancel_customer_reserve 698 698 0 0.00 0 4680 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 712 712 0 0.00 0 5432 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 384 384 0 0.00 0 286 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 382 382 0 0.00 0 4410 32 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 16673 1445 0 0
t$perf-norm:sp_cancel_write_off 1016 1016 0 0.00 0 4755 9 0 0
t$perf-norm:sp_client_order 21146 21146 0 0.00 0 10802 17 0 0
t$perf-norm:sp_customer_reserve 994 994 0 0.00 0 7963 21 0 0
t$perf-norm:sp_pay_from_customer 7052 7052 0 0.00 0 9063 11 0 0
t$perf-norm:sp_pay_to_supplier 6006 6006 0 0.00 0 5292 8 0 0
t$perf-norm:sp_reserve_write_off 10156 10156 0 0.00 0 8004 15 0 0
t$perf-norm:sp_supplier_invoice 5633 5633 0 0.00 0 6890 22 0 0
t$perf-norm:sp_supplier_order 5359 5359 0 0.00 0 17696 24 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 1109 22 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 570 7 0 0
t$perf-norm:srv_make_invnt_saldo 584 584 0 0.00 0 4101 36 0 0
t$perf-norm:srv_make_money_saldo 801 801 0 0.00 0 2129 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10214 9948 266 2.60 0 7926 19 0 266
v_all_customers 38354 38354 0 0.00 0 56 1 0 0
v_all_suppliers 30676 30676 0 0.00 0 58 1 0 0
v_all_wares 42292 42292 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 834 834 0 0.00 0 1006 8 0 0
v_cancel_client_order 3628 3628 0 0.00 0 1937 4 0 0
v_cancel_customer_prepayment 1424 1424 0 0.00 0 1721 5 0 0
v_cancel_customer_reserve 1396 1396 0 0.00 0 4675 7 0 0
v_cancel_payment_to_supplier 768 768 0 0.00 0 6518 15 0 0
v_cancel_supplier_invoice 786 764 22 2.79 0 964 16 0 22
v_cancel_supplier_order 828 828 0 0.00 0 1042 6 0 0
v_cancel_write_off 2032 2032 0 0.00 0 1232 12 0 0
v_max_id_clo_ord 5359 5359 0 0.00 0 218 1 0 0
v_max_id_clo_res 994 994 0 0.00 0 2019 14 0 0
v_max_id_ord_sup 5628 5628 0 0.00 0 2738 2 0 0
v_max_non_paid_invoice 1655 1655 0 0.00 0 10002 11 0 0
v_max_non_paid_realizn 3851 3851 0 0.00 0 6317 9 0 0
v_min_id_clo_ord 5359 5359 0 0.00 0 3210 7 0 0
v_min_id_clo_res 994 994 0 0.00 0 10922 19 0 0
v_min_id_ord_sup 5628 5628 0 0.00 0 5047 9 0 0
v_min_non_paid_invoice 6006 6006 0 0.00 0 7603 21 0 0
v_min_non_paid_realizn 7052 7052 0 0.00 0 8783 24 0 0
v_our_firm 10340 10340 0 0.00 0 20 1 0 0
v_reserve_write_off 20312 20312 0 0.00 0 6698 5 0 0
x_lock_depdocs_on_canc_invoice 11831 11831 0 0.00 0 12711 119 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 7574 352 0 0
x_make_qstorno_1000_1200 5359 5359 0 0.00 2 35130 1225 0 0
x_make_qstorno_1200_2000 5633 5633 0 0.00 2 69194 3166 0 0
x_make_qstorno_2100_3300 451761 451761 0 0.00 0 103699 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-02-2021 01:29:25 to 16-02-2021 01:29:29.

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:21 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:28 18545 8192000000 10262186720 10569306112 1037076688 11.237 81 62 124 0 1061126048 2847936 21201424
22:57:55 24714 8192000000 10337865040 10655936512 1395375936 14.554 100 83 166 1 1427236624 4732416 27128272
22:58:30 21347 8192000000 10366938752 10688253952 1426480432 14.830 100 92 184 0 1462602912 6319216 29803264
22:59:03 30291 8192000000 10406735584 10729992192 1454036912 15.073 100 92 183 0 1490929936 7194832 29698192
22:59:43 23205 8192000000 10422557568 10751631360 1476718832 15.273 100 90 180 0 1513622096 7852640 29050624
23:00:16 22577 8192000000 10440958800 10770804736 1496437136 15.445 100 93 186 0 1534838896 8446592 29955168
23:00:45 16334 8192000000 10454578784 10787823616 1508268240 15.548 100 85 170 1 1544457472 8709824 27479408
23:01:18 17592 8192000000 10472706928 10813444096 1524751216 15.691 100 84 168 0 1560922544 9386832 26784496
23:01:45 16051 8192000000 10488103760 10833350656 1548724976 15.899 100 85 170 0 1585226928 9740144 26761808
23:02:09 17144 8192000000 10506992944 10858938368 1566222560 16.050 100 76 153 1 1599393456 9992352 23178544
23:02:35 9635 8192000000 10531103792 10884325376 1586619376 16.225 100 65 130 0 1616207136 9633216 19954544
23:02:53 13524 8192000000 10554633488 10911977472 1612271712 16.444 100 75 149 0 1644650544 9641312 22737520
23:03:16 9958 8192000000 10573141072 10935152640 1634775808 16.635 100 77 154 0 1667939728 10200016 22963904
23:03:34 9694 8192000000 10586282528 10955141120 1654377872 16.801 100 78 154 3 1688341232 10823936 23139424
23:03:53 11635 8192000000 10622258608 10994827264 1680412240 17.021 100 68 136 0 1710560336 10609312 19538784
23:04:14 3689 8192000000 10632874160 11003326464 1701390256 17.197 100 81 162 1 1736253712 11433200 23430256
23:04:27 9354 8192000000 10657309984 11027431424 1713798256 17.300 100 76 152 2 1746925968 11802928 21324784
23:04:45 8505 8192000000 10673069104 11043778560 1730045600 17.436 100 78 156 2 1765416368 13424080 21946688
23:05:02 6761 8192000000 10690738016 11061313536 1749174848 17.595 100 82 164 0 1785777552 13253056 23349648
23:05:17 5007 8192000000 10693293536 11068559360 1751951344 17.618 100 76 152 0 1786758784 13568368 21239072
23:05:30 3811 8192000000 10707717456 11087151104 1764872128 17.725 100 77 155 0 1800586816 13925776 21788912
23:05:40 4171 8192000000 10715492864 11095777280 1775005376 17.808 100 84 169 1 1811942592 13182288 23754928
23:05:51 9906 8192000000 10710872480 11095584768 1778992048 17.841 100 78 156 1 1814624976 13759072 21873856
23:06:08 5928 8192000000 10722193296 11102789632 1782081184 17.867 100 76 152 0 1817364176 13676976 21606016
23:06:22 4111 8192000000 10737296976 11124076544 1798276704 18.000 100 72 144 1 1832185872 13958128 19951040
23:06:33 3224 8192000000 10745737392 11132112896 1808287056 18.082 100 82 164 0 1844168192 12849296 23031840
23:06:43 3474 8192000000 10745863552 11138920448 1814241040 18.131 100 78 157 0 1848147744 11722672 22184032
23:06:53 3241 8192000000 10755152896 11142791168 1822599104 18.199 100 75 148 3 1855498960 11509408 21390448
23:07:04 3419 8192000000 10766611760 11154808832 1832672192 18.281 100 89 179 1 1871327904 14024992 24630720
23:07:14 3476 8192000000 10781195776 11166707712 1834977088 18.300 100 89 178 1 1874677216 14336192 25363936
23:07:24 2852 8192000000 10774665936 11163013120 1835754176 18.306 100 91 184 1 1876368864 14877616 25737072
23:07:34 2980 8192000000 10776229408 11166416896 1838994512 18.333 100 85 170 0 1876207872 13759792 23453568
23:07:44 2083 8192000000 10795256384 11179638784 1848987024 18.414 100 95 190 3 1889571568 13902064 26682480
23:07:53 2691 8192000000 10803241136 11187298304 1854315296 18.457 100 95 192 0 1895703472 15000000 26388176
23:08:02 1598 8192000000 10801212128 11189010432 1857167984 18.480 100 94 188 3 1897118896 13402864 26548048
23:08:10 2406 8192000000 10804867200 11191083008 1863354080 18.530 100 95 191 1 1907722160 18243056 26125024
23:08:19 2230 8192000000 10807711280 11199488000 1863483040 18.532 100 87 174 0 1900805328 12665472 24656816
23:08:30 1982 8192000000 10805724832 11195248640 1869016656 18.576 100 91 183 1 1908181376 12475312 26689408
23:08:38 2073 8192000000 10819160128 11207004160 1874280544 18.619 100 97 193 1 1913027200 12507392 26239264
23:08:46 4821 8192000000 10798780800 11203080192 1872143744 18.602 100 79 158 0 1908511824 13677552 22690528
23:08:58 16121 8192000000 10801113200 11202064384 1870066512 18.585 100 61 125 1 1897025152 8661824 18296816
23:09:21 4224 8192000000 10784397264 11197714432 1865256912 18.546 100 45 90 1 1886989104 8929152 12803040
23:09:32 5517 8192000000 10794436576 11200557056 1870730304 18.590 100 60 120 1 1896704464 8740112 17234048
23:09:45 7287 8192000000 10795319888 11206701056 1872988576 18.608 100 45 90 0 1894789056 9812512 11987968
23:09:59 2551 8192000000 10801494288 11210829824 1877103408 18.642 100 54 107 2 1902363120 10330000 14929712
23:10:08 2029 8192000000 10809235392 11216158720 1881169056 18.675 100 63 127 3 1909493936 9430208 18894672
23:10:19 5611 8192000000 10789481728 11211431936 1877370144 18.644 100 37 74 2 1895841216 7909392 10561680
23:10:30 7866 8192000000 10786995712 11210399744 1877482816 18.645 100 31 62 0 1897100192 10860496 8756880
23:10:52 7235 8192000000 10781746576 11213840384 1880758080 18.671 100 27 52 1 1895176928 6004192 8414656
23:11:12 7104 8192000000 10797022592 11224227840 1887914944 18.729 100 32 62 3 1903440848 6620224 8905680
23:11:27 10502 8192000000 10804297792 11224973312 1890782928 18.752 100 29 58 0 1905225856 6352624 8090304
23:11:49 63977 8192000000 10799780448 11237056512 1891812624 18.760 100 33 66 2 1908019616 5924016 10282976
23:13:01 4332 8192000000 10810454736 11240472576 1893098224 18.771 100 31 64 4 1908518128 6492496 8927408
23:13:12 2529 8192000000 10823698192 11245199360 1895591328 18.791 100 37 74 3 1913915232 8018912 10304992
23:13:21 3556 8192000000 10824020576 11243196416 1897058112 18.803 100 33 66 1 1912355168 6466784 8830272
23:13:31 4193 8192000000 10829318992 11249336320 1905413424 18.870 100 49 98 2 1927884528 8608528 13862576
23:13:42 5669 8192000000 10819920688 11248001024 1899651504 18.823 100 35 68 1 1916759088 7437952 9669632
23:13:54 5249 8192000000 10821624672 11250237440 1902337648 18.845 100 31 62 1 1918598928 7560848 8700432
23:14:07 4298 8192000000 10820943856 11249524736 1908494064 18.895 100 35 66 0 1924777744 7544624 8739056
23:14:19 5039 8192000000 10826515072 11253174272 1906213664 18.876 100 44 88 3 1929886656 10830064 12842928
23:14:31 8179 8192000000 10822308016 11253014528 1907873376 18.890 100 30 60 1 1923128176 6220768 9034032
23:14:48 9787 8192000000 10819366960 11255140352 1907706320 18.888 100 23 45 0 1920559424 6747344 6105760
23:15:05 10373 8192000000 10824429312 11256270848 1908622432 18.896 100 21 42 0 1920338624 5636336 6079856
23:15:21 6490 8192000000 10821052560 11254480896 1909491728 18.903 100 25 51 1 1922304672 5201600 7611344
23:15:34 9528 8192000000 10815027056 11255484416 1907614176 18.887 100 14 27 1 1917404224 5706016 4084032
23:15:50 57737 8192000000 10861564496 11265679360 1914825424 18.945 100 54 109 0 1937370480 6389696 16155360
23:16:54 6673 8192000000 10806476544 11230662656 1853040736 18.447 97 30 60 1 1869745792 8766944 7938112
23:17:08 6796 8192000000 10815723280 11253735424 1902097712 18.843 100 24 48 3 1914441792 5860368 6483712
23:17:22 3949 8192000000 10832440304 11262451712 1912481024 18.927 100 40 81 1 1930049840 6646368 10922448
23:17:32 8416 8192000000 10819892752 11250683904 1876470384 18.637 98 28 56 0 1890255968 5731744 8053840
23:17:47 6031 8192000000 10839025280 11258310656 1908129680 18.892 100 35 69 2 1924811856 6663328 10018848
23:18:01 9042 8192000000 10751320592 11172192256 1742626512 17.540 92 30 60 2 1761041088 9850272 8564304
23:18:19 6719 8192000000 10762678368 11189944320 1840099056 18.342 99 38 75 1 1857458032 6021024 11337952
23:18:32 7255 8192000000 10769257888 11189792768 1827996624 18.243 98 32 65 2 1842740496 5634416 9109456
23:18:50 6975 8192000000 10766874128 11190812672 1837072688 18.317 99 22 44 2 1849065856 6011824 5981344
23:19:03 7768 8192000000 10736060064 11163488256 1802595984 18.035 97 16 32 1 1813418896 6132256 4690656
23:19:17 9483 8192000000 10711892208 11132760064 1721417472 17.364 94 21 42 1 1732503904 5113472 5972960
23:19:34 12730 8192000000 10740330464 11162456064 1809629520 18.093 99 11 22 0 1818465696 5547136 3289040
23:19:56 7470 8192000000 10706860544 11125366784 1771301712 17.778 97 23 46 2 1783992464 6234944 6455808
23:20:11 30711 8192000000 10643696256 11043545088 1615829072 16.474 89 32 64 2 1629724400 4634944 9260384
23:21:01 28385 8192000000 10663304704 11076087808 1683119408 17.044 94 29 58 1 1697834192 6254896 8459888
23:21:36 10770 8192000000 10691483024 11107975168 1738532640 17.506 97 26 52 1 1751947312 6184064 7230608
23:21:53 6113 8192000000 10708880912 11118538752 1774093968 17.801 99 34 67 1 1791208144 7583280 9530896
23:22:07 7268 8192000000 10695304016 11105570816 1738389168 17.505 97 29 56 0 1752337248 6717392 7230688
23:22:22 4691 8192000000 10720389872 11122610176 1796645760 17.986 100 34 68 1 1812987856 6461248 9880848
23:22:34 9181 8192000000 10710086624 11121061888 1765963072 17.734 98 24 48 3 1778234544 5405216 6866256
23:22:49 8896 8192000000 10716825712 11134722048 1784238656 17.884 99 29 58 1 1799107280 6071344 8797280
23:23:06 14841 8192000000 10705550336 11131809792 1774923280 17.808 98 28 57 0 1788850752 5771424 8156048
23:23:27 9426 8192000000 10734747376 11150282752 1813287056 18.123 100 26 51 2 1830939584 10312864 7339664
23:23:43 6416 8192000000 10735062736 11158798336 1825716112 18.224 100 20 38 2 1837334928 5423680 6195136
23:23:57 11810 8192000000 10755809824 11171680256 1833530880 18.288 100 25 48 1 1846627072 5322848 7773344
23:24:15 13036 8192000000 10751293872 11173302272 1837435984 18.320 100 15 30 1 1847524688 5390736 4697968
23:24:38 12755 8192000000 10746811728 11176554496 1840264928 18.343 100 18 36 0 1850757232 5039504 5452800
23:24:59 35775 8192000000 10764704880 11185934336 1842558144 18.362 100 23 45 3 1853329424 4944608 5826672
23:25:42 50512 8192000000 10770184352 11191427072 1850085120 18.423 100 28 55 2 1863721888 5266288 8370480
23:26:42 5254 8192000000 10765380640 11195486208 1853183344 18.448 100 23 45 0 1866336256 6461776 6691136
23:26:55 4972 8192000000 10776795744 11200425984 1858919808 18.495 100 30 60 0 1874667968 7188384 8559776
23:27:06 6850 8192000000 10798563040 11218919424 1874801680 18.623 100 38 76 1 1900064832 15025472 10237680
23:27:19 8032 8192000000 10819535552 11232145408 1885947520 18.713 100 37 74 2 1903244784 5900048 11397216
23:27:35 16346 8192000000 10837586640 11249348608 1901175392 18.836 100 54 106 1 1924469152 7692720 15601040
23:27:59 20501 8192000000 10838957264 11257425920 1905622080 18.871 100 49 95 0 1926978112 8872096 12483936
23:28:27 15623 8192000000 10846679632 11267604480 1918503328 18.975 100 58 115 0 1945362544 11109056 15750160
23:28:50 16890 8192000000 10858096512 11275804672 1925551120 19.031 100 65 131 1 1955648720 11266560 18831040
23:29:20 15516 8192000000 10856818560 11281543168 1927581760 19.048 100 46 92 1 1950289152 9339264 13368128
23:29:46 23821 8192000000 10865791984 11290570752 1930073040 19.067 100 43 86 0 1953682976 11599056 12010880
23:30:27 23836 8192000000 10873542704 11303129088 1936803904 19.121 100 46 92 2 1962758048 12927264 13026880
23:31:16 24697 8192000000 10885951392 11311783936 1946439184 19.198 100 37 75 2 1966995808 9863968 10692656
23:32:03 47966 8192000000 10893316400 11326963712 1955362880 19.269 100 42 84 2 1984370112 16269952 12737280
23:33:01 8254 8192000000 10905666704 11331792896 1964339872 19.341 100 48 95 2 1993337392 15388112 13609408
23:33:18 4873 8192000000 10912808864 11336634368 1968688576 19.375 100 60 117 1 2000954336 15137840 17127920
23:33:32 3240 8192000000 10925973632 11340210176 1975262384 19.427 100 67 133 1 2010092912 15958992 18871536
23:33:52 5675 8192000000 10916842032 11343093760 1973388992 19.412 100 54 107 2 2004075952 15291136 15395824
23:34:18 3140 8192000000 10921289776 11352481792 1980209392 19.466 100 57 112 1 2012312816 15825920 16277504
23:34:30 7781 8192000000 10927489808 11360591872 1983542240 19.493 100 48 97 1 2015358176 17999984 13815952
23:34:44 10823 8192000000 10931514048 11354644480 1980169808 19.466 100 62 124 2 2017016256 18650592 18195856
23:35:03 12177 8192000000 10920938496 11356418048 1982051680 19.481 100 57 114 1 2017089408 18568032 16469696
23:35:23 2192 8192000000 10927470016 11347476480 1966457104 19.357 99 77 152 1 2009122240 21154976 21510160
23:35:33 7476 8192000000 10926038272 11351777280 1959904080 19.305 99 61 122 0 1999605456 21971008 17730368
23:35:47 7411 8192000000 10931176688 11349979136 1973075056 19.410 100 63 126 1 2013677744 22245392 18357296
23:36:01 4907 8192000000 10935293488 11363966976 1985921520 19.512 100 64 128 1 2026468272 21641904 18904848
23:36:14 16042 8192000000 10920859776 11353305088 1973538608 19.414 100 55 109 0 2010968144 22050848 15378688
23:36:43 19437 8192000000 10927706352 11363758080 1979588352 19.461 100 47 92 0 2020204864 27047584 13568928
23:37:13 11019 8192000000 10936262576 11371925504 1984810064 19.503 100 46 91 1 2024061360 26146960 13104336
23:37:30 1732 8192000000 10962551520 11387396096 1998973040 19.615 100 63 126 1 2048617856 30234736 19410080
23:37:42 12020 8192000000 10951204736 11384188928 1997625856 19.604 100 50 100 1 2040510000 27286496 15597648
23:38:00 3979 8192000000 10958823008 11389857792 2002689424 19.644 100 57 113 2 2046795328 27793216 16312688
23:38:12 5259 8192000000 10968142880 11399077888 2006886656 19.677 100 64 128 1 2055078160 28815088 19376416
23:38:29 12288 8192000000 10969735264 11391627264 2005105728 19.663 100 62 122 2 2051751744 28375440 18270576
23:38:54 14918 8192000000 10968656016 11400269824 2009995456 19.701 100 55 108 1 2055029200 28763984 16269760
23:39:15 2783 8192000000 10978822080 11402498048 2013430384 19.729 100 82 164 2 2070768080 32906000 24431696
23:39:25 7314 8192000000 10983899264 11413934080 2017088864 19.757 100 72 143 0 2071610928 33129280 21392784
23:39:39 10405 8192000000 10996260288 11424370688 2027044416 19.835 100 72 144 0 2083420432 35002000 21374016
23:39:57 3260 8192000000 11000998752 11428798464 2033632352 19.887 100 81 161 0 2094199968 36038368 24529248
23:40:07 1981 8192000000 11003498832 11426938880 2029326288 19.853 100 83 166 2 2091944720 36176304 26442128
23:40:16 3426 8192000000 10993689200 11422855168 2029606480 19.856 100 75 147 1 2088163968 36316512 22240976
23:40:30 5124 8192000000 11006487392 11438141440 2030851904 19.865 100 62 122 2 2083430896 34064416 18514576
23:40:42 2888 8192000000 10989170240 11409039360 2009174064 19.695 100 81 162 1 2071230496 37493920 24562512
23:40:51 5455 8192000000 10985814432 11416477696 2015025408 19.741 100 73 146 0 2075665520 38837168 21802944
23:41:03 3543 8192000000 10995757184 11418951680 2007394112 19.681 99 75 150 1 2067289312 37091216 22803984
23:41:14 6721 8192000000 10998237600 11420766208 2018628224 19.769 100 81 161 3 2081700352 38492528 24579600
23:41:28 1351 8192000000 10963361104 11377139712 1975814656 19.432 98 83 166 2 2039089024 38595104 24679264
23:41:37 2645 8192000000 10971098880 11382714368 1980354304 19.468 99 79 159 1 2043903840 39542768 24006768
23:41:48 3593 8192000000 10984052384 11402141696 2002577376 19.643 100 82 164 1 2069223248 40875056 25770816
23:42:02 2770 8192000000 10986185616 11407175680 2000508944 19.627 100 79 159 0 2066305280 41342512 24453824
23:42:12 4265 8192000000 10990191744 11410743296 2006228512 19.672 100 83 165 0 2072182656 41122448 24831696
23:42:24 2464 8192000000 10983951936 11397885952 1995023296 19.583 100 86 171 0 2063082176 41419648 26639232
23:42:35 3000 8192000000 10990260240 11404165120 1999697152 19.620 100 85 167 3 2066678112 41430896 25550064
23:42:45 2956 8192000000 10973474512 11390570496 1979727312 19.463 99 90 177 2 2049390048 42651120 27011616
23:42:55 3034 8192000000 10969381888 11384487936 1981577888 19.477 100 82 164 2 2050354944 43742240 25034816
23:43:05 2022 8192000000 10978855616 11389763584 1986424880 19.516 100 88 180 1 2056966832 43643872 26898080
23:43:14 1538 8192000000 10987895232 11397939200 1994886272 19.582 100 91 180 1 2066927680 44287856 27753552
23:43:24 1621 8192000000 10983068464 11395280896 1990264816 19.546 100 83 164 2 2061422640 45172304 25985520
23:43:36 3123 8192000000 10986155488 11408158720 2000487584 19.627 100 79 158 0 2070123296 44734560 24901152
23:43:47 3636 8192000000 10968944256 11394674688 1979027232 19.457 99 72 144 2 2048614784 45620976 23966576
23:44:00 7253 8192000000 10978975072 11404881920 1994672192 19.581 100 64 126 2 2062029936 46238192 21119552
23:44:15 1614 8192000000 10973418592 11396423680 1989058304 19.536 100 76 148 0 2059248752 45485840 24704608
23:44:24 1956 8192000000 10989229856 11400216576 1992317312 19.562 100 91 182 0 2068177072 48051520 27808240
23:44:34 2978 8192000000 10979967408 11398287360 1986052672 19.513 100 86 172 3 2063248848 48808000 28388176
23:44:44 3252 8192000000 10972966592 11397844992 1984723328 19.502 100 70 139 1 2057000000 49880624 22396048
23:44:57 3885 8192000000 10958511504 11378036736 1964833696 19.344 99 78 155 3 2040845696 50824096 25187904
23:45:11 2342 8192000000 10968920928 11385294848 1971706256 19.399 100 80 160 0 2050529456 52892912 25930288
23:45:19 1711 8192000000 10983995568 11400040448 1984615472 19.501 100 89 179 0 2067176832 53733456 28827904
23:45:30 2591 8192000000 10957821536 11376705536 1941937264 19.162 98 85 168 0 2023513920 54714768 26861888
23:45:40 1583 8192000000 10983360544 11395862528 1977550240 19.445 100 89 175 2 2059663264 54847392 27265632
23:45:48 4509 8192000000 10969544656 11400257536 1980182960 19.466 100 70 140 0 2058949760 55630720 23136080
23:46:00 8482 8192000000 10945859360 11397185536 1976896048 19.440 100 47 94 1 2042233872 49627744 15710080
23:46:18 6475 8192000000 10955618144 11388379136 1958701072 19.296 99 41 82 0 2020501344 47416976 14383296
23:46:32 9023 8192000000 10954554192 11394908160 1976389200 19.436 100 45 89 0 2041215808 50028640 14797968
23:46:51 2022 8192000000 10978909360 11403816960 1981102016 19.473 100 67 135 2 2056118928 52565248 22451664
23:47:00 4754 8192000000 10958786256 11395506176 1974933440 19.425 100 50 99 2 2043517712 52007536 16576736
23:47:16 14279 8192000000 10937751808 11372417024 1941806400 19.161 99 45 90 0 2009543984 51381552 16356032
23:47:37 5616 8192000000 10947830080 11375804416 1958133328 19.291 100 56 111 2 2029240592 52079072 19028192
23:47:50 2864 8192000000 10955038336 11373006848 1949312288 19.221 99 83 164 0 2028270688 52361600 26596800
23:48:01 3696 8192000000 10957854192 11373019136 1933994272 19.099 98 88 176 2 2015188512 53892064 27302176
23:48:11 3601 8192000000 10948261152 11369963520 1949753296 19.225 99 76 151 1 2029026416 54917120 24356000
23:48:23 12276 8192000000 10928515568 11393949696 1964062448 19.338 100 40 80 0 2029801072 51813376 13925248
23:48:53 10150 8192000000 10926503584 11358707712 1916789104 18.961 97 53 106 4 1974895520 40660272 17446144
23:49:14 8046 8192000000 10905343392 11329073152 1921903216 19.002 98 53 105 0 1984098384 44910736 17284432
23:49:29 3404 8192000000 10963115824 11377844224 1963885424 19.337 100 69 139 1 2036245328 49288368 23071536
23:49:39 5082 8192000000 10963398400 11394166784 1968008000 19.370 100 57 113 2 2043282496 56407952 18866544
23:49:53 20618 8192000000 10934532368 11383005184 1964400464 19.341 100 41 82 2 2031272608 52509312 14362832
23:50:25 15415 8192000000 10941408704 11388719104 1966476352 19.357 100 43 86 1 2029499200 47910224 15112624
23:51:13 22524 8192000000 10937224096 11380301824 1962679104 19.327 100 30 60 1 2024369552 51081792 10608656
23:51:51 31875 8192000000 10927629232 11391721472 1966612688 19.359 100 28 56 0 2026982400 50610576 9759136
23:53:06 16875 8192000000 10931375104 11391774720 1966616272 19.359 100 24 48 0 2016838320 42055024 8167024
23:53:29 53766 8192000000 10911348000 11370606592 1943605904 19.176 99 20 40 0 1991268928 40966864 6696160
23:54:31 32384 8192000000 10900572768 11362729984 1941187632 19.156 100 14 28 1 1984735680 38242176 5305872
23:55:10 61186 8192000000 10889581872 11359248384 1939368656 19.142 99 13 26 0 1963695520 19891024 4435840
23:56:17 84004 8192000000 10897314928 11333660672 1868593600 18.573 95 32 64 1 1890727872 13511328 8622944
23:57:53 164471 8192000000 10905124496 11347337216 1922538000 19.007 98 41 82 0 1947108160 12338272 12231888
00:00:45 14906 8192000000 10877130432 11332235264 1944244096 19.181 99 26 52 1 1961768784 10268784 7255904
00:01:09 110499 8192000000 10877950032 11312775168 1847836032 18.405 94 18 35 1 1861607888 8800240 4971616
00:04:00 44920 8192000000 10893291344 11340001280 1941392576 19.158 99 37 71 1 1966489392 13910608 11186208
00:04:51 2729 8192000000 10911407808 11347701760 1962885968 19.329 100 57 115 2 1995130032 14950688 17293376
00:05:01 23158 8192000000 10891923904 11355504640 1966320448 19.356 100 16 32 1 1983353520 12133280 4899792
00:05:51 44884 8192000000 10919360368 11369361408 1957024080 19.282 99 25 50 2 1975803984 11882384 6897520
00:06:43 35133 8192000000 10930109072 11377897472 1981679104 19.478 100 30 60 1 2003721328 13700720 8341504
00:07:25 29889 8192000000 10927797072 11393806336 1993931280 19.575 100 33 66 1 2021226512 17689808 9605424
00:08:04 53134 8192000000 10916996128 11385991168 1967771248 19.368 99 19 38 0 1993129808 19260640 6097920
00:09:15 112650 8192000000 10889540368 11356229632 1911051152 18.915 96 16 32 0 1926836240 10817344 4967744
00:11:15 58305 8192000000 10880319584 11350339584 1944628832 19.184 99 19 38 0 1963974176 13572656 5772688
00:12:32 60821 8192000000 10890181216 11364646912 1969552032 19.382 100 21 42 1 1984204240 8388256 6263952
00:15:20 42090 8192000000 10875912400 11350671360 1925457920 19.031 98 15 30 1 1946149168 16462704 4228544
00:16:09 39142 8192000000 10875572256 11346075648 1939374688 19.142 99 28 56 0 1960515936 13602064 7539184
00:16:58 60317 8192000000 10881572304 11358072832 1934357264 19.102 98 14 28 1 1953801104 15524992 3918848
00:19:22 57185 8192000000 10902530560 11381932032 1971119376 19.394 100 4 8 0 1986818112 14534544 1164192
00:20:25 60529 8192000000 10928287248 11386454016 1981263104 19.475 100 19 38 0 1996222176 9639408 5319664
00:21:32 18985 8192000000 10921859264 11376402432 1931386512 19.078 97 39 77 2 1951681008 9612896 10681600
00:22:07 41866 8192000000 10900051680 11370754048 1940525712 19.151 98 42 84 4 1966787680 14473424 11788544
00:22:59 57623 8192000000 10891847312 11378028544 1950752096 19.232 99 13 26 0 1970962624 16598144 3612384
00:24:03 27881 8192000000 10892718208 11366236160 1950385184 19.230 99 32 63 2 1969759472 10070384 9303904
00:24:41 39175 8192000000 10897889936 11367944192 1963649040 19.335 100 35 70 0 1983374960 10076368 9649552
00:26:12 46136 8192000000 10933058736 11374198784 1947171200 19.204 99 24 48 1 1965399200 11137440 7090560
00:27:08 52183 8192000000 10897341360 11368894464 1936397056 19.118 98 25 50 0 1961126064 17137888 7591120
00:28:24 156771 8192000000 10871783808 11342233600 1736732160 17.491 88 11 22 0 1758698240 18943024 3023056
00:31:17 87606 8192000000 10873204512 11326951424 1769137328 17.760 91 14 28 0 1782384336 8655648 4591360
00:33:11 79281 8192000000 10849918560 11328417792 1889423760 18.741 98 22 43 0 1909700144 14619840 5656544
00:35:46 104755 8192000000 10869597088 11347492864 1921497616 18.999 99 20 41 0 1948077632 20958128 5621888
00:37:39 4615 8192000000 10874524336 11353395200 1945469632 19.190 100 11 22 0 1966277888 17611056 3197200
00:37:50 1278 8192000000 10873759344 11357908992 1947212192 19.204 100 5 10 0 1966332112 17760144 1359776
00:38:10 66241 8192000000 10849973792 11333881856 1901268880 18.836 98 20 40 0 1917976816 10849952 5857984
00:39:24 49645 8192000000 10857915232 11340201984 1921265184 18.997 99 8 16 0 1934956080 11405232 2285664
00:40:36 60990 8192000000 10871568752 11353595904 1934511744 19.103 99 16 32 1 1947139488 8034944 4592800
00:41:44 74062 8192000000 10885636608 11359756288 1956311088 19.277 100 13 26 0 1968763984 8084960 4367936
00:43:07 40587 8192000000 10904127168 11354787840 1924924592 19.026 98 21 43 0 1937749904 6940432 5884880
00:43:57 90190 8192000000 10896900144 11376635904 1931757408 19.081 98 24 48 1 1950164272 11782336 6624528
00:46:51 61414 8192000000 10895962480 11359309824 1912326272 18.925 97 18 36 0 1934904208 17050832 5527104
00:48:00 82645 8192000000 10890260880 11362234368 1922752672 19.009 98 21 42 1 1949470672 20902624 5815376
00:49:41 95066 8192000000 10896018352 11375243264 1931038720 19.075 98 15 31 0 1952627344 17216160 4372464
00:51:25 65615 8192000000 10896814112 11353944064 1940676112 19.152 99 22 43 1 1957040384 10113440 6250832
00:52:39 31444 8192000000 10906713248 11364810752 1930850704 19.074 98 40 80 0 1953893296 11962992 11079600
00:53:39 44584 8192000000 10899994384 11354464256 1921797248 19.001 98 35 70 4 1945402640 13868240 9737152
00:54:50 55931 8192000000 10876043376 11348934656 1892471520 18.766 97 25 50 0 1916909824 17704944 6733360
00:55:53 87395 8192000000 10852638048 11320336384 1848368576 18.409 95 10 21 0 1862800512 11711184 2720752
00:58:25 47656 8192000000 10868270240 11336343552 1943651216 19.176 100 25 50 3 1958854480 8198160 7005104
00:59:31 42651 8192000000 10877437984 11353366528 1958137104 19.291 100 28 56 0 1974278528 8808192 7333232
01:03:17 76791 8192000000 10903724560 11374526464 1964301344 19.340 100 12 24 0 1976813472 9328480 3183648
01:04:44 47577 8192000000 10927620368 11401916416 1986403536 19.515 100 24 47 1 2013811376 19944880 7462960
01:05:43 100547 8192000000 10897122224 11391938560 1962520368 19.326 99 10 20 1 1985460608 20175216 2765024
01:07:32 35877 8192000000 10903093312 11368030208 1926542880 19.039 97 29 58 2 1947449920 12435568 8471472
01:09:02 88064 8192000000 10920493600 11400683520 1971468480 19.397 100 19 38 0 1997139008 20251504 5419024
01:11:23 46994 8192000000 10900839920 11361558528 1928934912 19.058 98 33 66 2 1946107120 7837104 9335104
01:12:18 34233 8192000000 10911367680 11369287680 1966257456 19.356 100 37 74 0 1990562400 13914672 10390272
01:13:03 25965 8192000000 10894230944 11371642880 1943963024 19.178 99 26 52 2 1969919056 18495504 7460528
01:13:38 25158 8192000000 10872718976 11330555904 1871421248 18.596 95 36 72 0 1890257952 8839600 9997104
01:14:10 55881 8192000000 10890844288 11333140480 1883686160 18.695 97 39 76 3 1904655360 10623488 10345712
01:15:12 32884 8192000000 10884234064 11331579904 1916992944 18.963 99 44 88 3 1942072256 12984976 12094336
01:16:23 63090 8192000000 10834330000 11291529216 1815708048 18.143 94 32 64 3 1840895856 16362544 8825264
01:17:40 48645 8192000000 10818808784 11289673728 1878700304 18.655 99 10 20 2 1895338736 13766720 2871712
01:18:36 67637 8192000000 10853415680 11311869952 1899598912 18.823 99 17 34 1 1911465328 7374752 4491664
01:19:50 67943 8192000000 10824993184 11304771584 1871014432 18.592 97 10 20 0 1882189072 7941504 3233136
01:21:05 72568 8192000000 10833162000 11306823680 1904498144 18.862 99 11 22 1 1919775232 12201008 3076080
01:22:28 35395 8192000000 10848111056 11324796928 1923535968 19.015 100 12 24 0 1937199680 10173456 3490256
01:23:10 68064 8192000000 10878658240 11346407424 1938911488 19.138 100 16 32 0 1958139440 14381520 4846432
01:24:28 65528 8192000000 10851215424 11324973056 1909028608 18.899 98 19 38 0 1924081808 9599344 5453856
01:25:40 53463 8192000000 10878120640 11345289216 1939411456 19.142 100 19 38 0 1955108656 10139776 5557424
01:26:39 46658 8192000000 9888018576 10261798912 1018741248 11.060 52 5 10 0 1027428048 7341936 1344864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 133 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

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

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          239229
MON$OLDEST_ACTIVE               239230
MON$OLDEST_SNAPSHOT             239230
MON$NEXT_TRANSACTION            239230
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                       2033120
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:457: 
:458: mscs-test-161.budzdorov.ru    Tue Feb 16 01:27:35 2021
:459:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:460: 
--- end of diff output ---

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

16.02.21 01:30:06. 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-16 01:30:08 No severe PSQL-related problems occured
16.02.21 01:30:09. End of report.