Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.11.2020 01: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 17744412 kB
MemAvailable 31615292 kB
Buffers 0 kB
Cached 13935908 kB
SwapCached 2020 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 2020-11-28 01:27:08
DTS_END                         2020-11-28 01:27:08.5180
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/49592
TRN_ID                          241125
ATT_ID                          664
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: 9265.77 21649 1111892
customer order: creation 173.39 381 20807
customer order: refuse 14.58 318 1749
order to supplier: creation 45.38 1308 5445
order to supplier: removal 3.72 87896 446
invoice (draft): creation 45.96 3335 5515
invoice (draft): removal 53.01 660 6361
invoice accept: apply 42.06 18069 5047
invoice accept: cancel 47.18 722 5661
customer reserve: creation 3926.13 177 471136
customer reserve: removal 4621.04 56 554525
realization accept: apply 85.06 177 10207
realization accept: cancel 77.42 115 9290
payment from customer: creation 60.15 136 7218
payment from customer: removal 5.57 61 668
payment to supplier: creation 50.12 148 6014
payment to supplier: removal 3.22 55 386
service: total inventory turnovers 4.46 1295 535
service: total monetary turnovers 6.33 30 760
service: aggregate perf. data 0.98 16933 118
service: refresh index statistics 0.03 301114 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-11-2020 01:27:58 to 28-11-2020 01:28:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3561
TEST_TIME 2 5049
TEST_TIME 3 5625
TEST_TIME 4 4462
TEST_TIME 5 4321
TEST_TIME 6 4751
TEST_TIME 7 5074
TEST_TIME 8 5227
TEST_TIME 9 5530
TEST_TIME 10 5627
TEST_TIME 11 5798
TEST_TIME 12 6458
TEST_TIME 13 7201
TEST_TIME 14 8024
TEST_TIME 15 8550
TEST_TIME 16 8550
TEST_TIME 17 8632
TEST_TIME 18 8767
TEST_TIME 19 8701
TEST_TIME 20 8857
TEST_TIME 21 9023
TEST_TIME 22 9003
TEST_TIME 23 9869
TEST_TIME 24 10232
TEST_TIME 25 10792
TEST_TIME 26 11349
TEST_TIME 27 11039
TEST_TIME 28 10896
TEST_TIME 29 10772
TEST_TIME 30 10688
TEST_TIME 31 10496
TEST_TIME 32 10341
TEST_TIME 33 10227
TEST_TIME 34 10395
TEST_TIME 35 10314
TEST_TIME 36 10100
TEST_TIME 37 10028
TEST_TIME 38 9997
TEST_TIME 39 9869
TEST_TIME 40 9759
TEST_TIME 41 9680
TEST_TIME 42 9600
TEST_TIME 43 9549
TEST_TIME 44 9578
TEST_TIME 45 9406
TEST_TIME 46 9355
TEST_TIME 47 9287
TEST_TIME 48 9419
TEST_TIME 49 9444
TEST_TIME 50 9495
TEST_TIME 51 9416
TEST_TIME 52 9375
TEST_TIME 53 9428
TEST_TIME 54 9498
TEST_TIME 55 9508
TEST_TIME 56 9466
TEST_TIME 57 9627
TEST_TIME 58 9610
TEST_TIME 59 9582
TEST_TIME 60 9716
TEST_TIME 61 9566
TEST_TIME 62 9473
TEST_TIME 63 9461
TEST_TIME 64 9446
TEST_TIME 65 9383
TEST_TIME 66 9379
TEST_TIME 67 9332
TEST_TIME 68 9307
TEST_TIME 69 9285
TEST_TIME 70 9243
TEST_TIME 71 9427
TEST_TIME 72 9389
TEST_TIME 73 9368
TEST_TIME 74 9412
TEST_TIME 75 9473
TEST_TIME 76 9417
TEST_TIME 77 9460
TEST_TIME 78 9531
TEST_TIME 79 9590
TEST_TIME 80 9557
TEST_TIME 81 9466
TEST_TIME 82 9388
TEST_TIME 83 9399
TEST_TIME 84 9365
TEST_TIME 85 9318
TEST_TIME 86 9270
TEST_TIME 87 9201
TEST_TIME 88 9221
TEST_TIME 89 9203
TEST_TIME 90 9223
TEST_TIME 91 9192
TEST_TIME 92 9202
TEST_TIME 93 9245
TEST_TIME 94 9321
TEST_TIME 95 9300
TEST_TIME 96 9331
TEST_TIME 97 9371
TEST_TIME 98 9368
TEST_TIME 99 9357
TEST_TIME 100 9395
TEST_TIME 101 9375
TEST_TIME 102 9442
TEST_TIME 103 9401
TEST_TIME 104 9341
TEST_TIME 105 9285
TEST_TIME 106 9270
TEST_TIME 107 9218
TEST_TIME 108 9228
TEST_TIME 109 9225
TEST_TIME 110 9245
TEST_TIME 111 9238
TEST_TIME 112 9246
TEST_TIME 113 9206
TEST_TIME 114 9236
TEST_TIME 115 9280
TEST_TIME 116 9285
TEST_TIME 117 9323
TEST_TIME 118 9341
TEST_TIME 119 9336
TEST_TIME 120 9271

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-11-2020 01:28:02 to 28-11-2020 01:28:05.

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 1547940 1547940 0 0.00 0 20147 6 0 0
doc_list_biud 1547936 1547936 0 0.00 0 39532 25 0 0
sp_add_invoice_to_stock 5131 5047 84 1.63 27 190535 18069 0 84
sp_cancel_adding_invoice 5661 5661 0 0.00 3 48580 722 0 0
sp_cancel_client_order 1749 1749 0 0.00 4 9684 318 0 0
sp_cancel_customer_reserve 554525 554525 0 0.00 1 39535 57 0 0
sp_cancel_pay_from_customer 668 668 0 0.00 2 1761 62 0 0
sp_cancel_pay_to_supplier 386 386 0 0.00 2 2084 56 0 0
sp_cancel_supplier_invoice 6367 6361 6 0.09 1 17035 660 0 6
sp_cancel_supplier_order 446 446 0 0.00 7 853204 87896 0 0
sp_cancel_write_off 9290 9290 0 0.00 1 20180 115 0 0
sp_client_order 20807 20807 0 0.00 3 25734 382 0 0
sp_customer_reserve 471136 471136 0 0.00 0 58501 177 0 0
sp_fill_shopping_cart 31758 31758 0 0.00 1 20535 40 0 0
sp_fill_shopping_cart_clo_res 471129 471129 0 0.00 0 11944 14 0 0
sp_get_clo_for_invoice 5038 5038 0 0.00 0 31897 341 0 0
sp_kill_cost_storno 16005 16005 0 0.00 0 20142 49 0 0
sp_kill_qstorno_ret_qs2qd 1125147 1125147 0 0.00 0 39516 30 0 0
sp_kill_qty_storno 593275 593275 0 0.00 0 39532 65 0 0
sp_lock_selected_doc 20909 20909 0 0.00 0 7077 5 0 0
sp_make_cost_storno 28477 28477 0 0.00 0 13958 57 0 0
sp_multiply_rows_for_pdistr 28477 28477 0 0.00 0 15954 34 0 0
sp_multiply_rows_for_qdistr 20807 20807 0 0.00 0 17080 184 0 0
sp_pay_from_customer 7218 7218 0 0.00 4 17743 137 0 0
sp_pay_to_supplier 6014 6014 0 0.00 4 16813 148 0 0
sp_payment_common 13232 13232 0 0.00 2 17739 34 0 0
sp_qd_handle_on_cancel_clo 1749 1749 0 0.00 0 9676 279 0 0
sp_qd_handle_on_invoice_upd_sts 10696 10696 0 0.00 0 25240 301 0 0
sp_qd_handle_on_reserve_upd_sts 10207 10207 0 0.00 0 17161 56 0 0
sp_reserve_write_off 10207 10207 0 0.00 6 17347 178 0 0
sp_supplier_invoice 5515 5515 0 0.00 6 87475 3335 0 0
sp_supplier_order 5445 5445 0 0.00 5 39106 1308 0 0
srv_aggregate_perf_data 119 118 1 0.84 2536 175501 16933 0 1
srv_fill_mon_cache_memory 158 158 0 0.00 965 147688 33273 0 0
srv_find_qd_qs_mism 1063470 1063470 0 0.00 0 12021 5 0 0
srv_make_invnt_saldo 535 535 0 0.00 50 176962 1295 0 0
srv_make_money_saldo 760 760 0 0.00 1 2703 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 145294 363084 301114 0 0
t$perf-abend:sp_add_invoice_to_stock 84 84 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 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 5047 5047 0 0.00 0 7744 140 0 0
t$perf-norm:sp_cancel_adding_invoice 404 404 0 0.00 0 1299 72 0 0
t$perf-norm:sp_cancel_client_order 1749 1749 0 0.00 0 21641 30 0 0
t$perf-norm:sp_cancel_customer_reserve 639 639 0 0.00 0 497 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 668 668 0 0.00 0 977 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 386 386 0 0.00 0 569 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 424 424 0 0.00 0 2038 25 0 0
t$perf-norm:sp_cancel_supplier_order 446 446 0 0.00 0 38039 1387 0 0
t$perf-norm:sp_cancel_write_off 954 954 0 0.00 0 1673 7 0 0
t$perf-norm:sp_client_order 20807 20807 0 0.00 0 5929 15 0 0
t$perf-norm:sp_customer_reserve 1042 1042 0 0.00 0 1320 4 0 0
t$perf-norm:sp_pay_from_customer 7218 7218 0 0.00 0 9168 9 0 0
t$perf-norm:sp_pay_to_supplier 6014 6014 0 0.00 0 7173 14 0 0
t$perf-norm:sp_reserve_write_off 10207 10207 0 0.00 0 9411 11 0 0
t$perf-norm:sp_supplier_invoice 5515 5515 0 0.00 0 7127 17 0 0
t$perf-norm:sp_supplier_order 5445 5445 0 0.00 0 2457 15 0 0
t$perf-norm:srv_aggregate_perf_data 118 118 0 0.00 0 497 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 1898 16 0 0
t$perf-norm:srv_make_invnt_saldo 535 535 0 0.00 0 431 14 0 0
t$perf-norm:srv_make_money_saldo 760 760 0 0.00 0 2460 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10232 10064 168 1.64 0 10434 22 0 168
v_all_customers 38054 38054 0 0.00 0 21 1 0 0
v_all_suppliers 31070 31070 0 0.00 0 17 1 0 0
v_all_wares 41614 41614 0 0.00 0 70 1 0 0
v_cancel_adding_invoice 808 808 0 0.00 0 7345 19 0 0
v_cancel_client_order 3498 3498 0 0.00 0 7641 10 0 0
v_cancel_customer_prepayment 1336 1336 0 0.00 0 1742 6 0 0
v_cancel_customer_reserve 1278 1278 0 0.00 0 7350 16 0 0
v_cancel_payment_to_supplier 772 772 0 0.00 0 2059 7 0 0
v_cancel_supplier_invoice 860 848 12 1.39 0 2759 21 0 12
v_cancel_supplier_order 892 892 0 0.00 0 2605 14 0 0
v_cancel_write_off 1908 1908 0 0.00 0 10307 32 0 0
v_max_id_clo_ord 5445 5445 0 0.00 0 5982 3 0 0
v_max_id_clo_res 1042 1042 0 0.00 0 3112 18 0 0
v_max_id_ord_sup 5506 5506 0 0.00 0 2473 3 0 0
v_max_non_paid_invoice 1430 1430 0 0.00 0 55 2 0 0
v_max_non_paid_realizn 3828 3828 0 0.00 0 6556 5 0 0
v_min_id_clo_ord 5445 5445 0 0.00 0 3221 6 0 0
v_min_id_clo_res 1042 1042 0 0.00 0 1462 5 0 0
v_min_id_ord_sup 5506 5506 0 0.00 0 6112 10 0 0
v_min_non_paid_invoice 6014 6014 0 0.00 0 14543 26 0 0
v_min_non_paid_realizn 7218 7218 0 0.00 0 17725 24 0 0
v_our_firm 10340 10340 0 0.00 0 14 1 0 0
v_reserve_write_off 20414 20414 0 0.00 0 6212 7 0 0
x_lock_depdocs_on_canc_invoice 11598 11598 0 0.00 0 21321 115 0 0
x_lock_depdocs_on_canc_sup_ord 446 446 0 0.00 0 10030 334 0 0
x_make_qstorno_1000_1200 5445 5445 0 0.00 2 39091 1225 0 0
x_make_qstorno_1200_2000 5515 5515 0 0.00 2 85304 3189 0 0
x_make_qstorno_2100_3300 471136 471136 0 0.00 0 58497 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-11-2020 01:28:06 to 28-11-2020 01:28:10.

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:12 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:18 40580 8192000000 10294618224 10611965952 1004494912 10.922 78 62 126 0 1027758704 2921616 20342176
22:58:08 20546 8192000000 10358748192 10675245056 1409805648 14.682 100 91 182 0 1445584848 5846688 29932512
22:58:38 18505 8192000000 10389171776 10709270528 1435980512 14.914 100 90 180 0 1471767504 6678976 29108016
22:59:05 24064 8192000000 10410292592 10738823168 1468970128 15.205 100 93 186 0 1506428064 7768256 29689680
22:59:42 9162 8192000000 10420761856 10751033344 1481050688 15.311 100 87 174 0 1516850464 8288784 27510992
23:00:06 19548 8192000000 10450853424 10782515200 1499452992 15.471 100 87 174 0 1536412112 9069408 27889712
23:00:39 26260 8192000000 10483914256 10820145152 1529162576 15.730 100 88 176 3 1566564384 9632320 27769488
23:01:19 16516 8192000000 10503769680 10849173504 1553326944 15.939 100 77 154 0 1587390208 10200592 23862672
23:01:46 11673 8192000000 10532608208 10883563520 1590246304 16.256 100 87 174 1 1627698720 10744032 26708384
23:02:05 13992 8192000000 10560104128 10913648640 1606758288 16.397 100 77 152 1 1641202544 10932224 23512032
23:02:29 13159 8192000000 10577622016 10935173120 1631618560 16.609 100 85 170 1 1669333280 11822944 25891776
23:02:52 12272 8192000000 10593287888 10951118848 1648710400 16.753 100 79 158 1 1684947696 12826688 23410608
23:03:13 8408 8192000000 10610845296 10971684864 1664850336 16.890 100 81 162 0 1702774816 13768896 24155584
23:03:29 6489 8192000000 10617714688 10984603648 1676245488 16.986 100 76 152 0 1711574864 12757008 22572368
23:03:46 10600 8192000000 10645851952 11018674176 1705719744 17.233 100 81 162 0 1742685840 12210672 24755424
23:04:07 7502 8192000000 10658995984 11026886656 1714408624 17.306 100 83 166 0 1751632384 12878816 24344944
23:04:22 5916 8192000000 10653142784 11034836992 1729331104 17.430 100 79 158 0 1765704032 12717888 23655040
23:04:35 4989 8192000000 10675320208 11053195264 1741866208 17.534 100 78 150 1 1775320064 11252416 22201440
23:04:47 4517 8192000000 10694834096 11074035712 1758212576 17.670 100 79 159 0 1792141392 11213392 22715424
23:04:59 3765 8192000000 10708988992 11082510336 1766477808 17.738 100 86 172 2 1802787920 12190864 24119248
23:05:10 5912 8192000000 10712864528 11091689472 1773772160 17.798 100 82 165 0 1809644368 12858096 23014112
23:05:23 3488 8192000000 10716779136 11094716416 1777155744 17.826 100 83 166 2 1813929520 13070704 23703072
23:05:33 3898 8192000000 10726903552 11106025472 1786797264 17.905 100 80 158 2 1821795440 12582976 22415200
23:05:44 2931 8192000000 10734202496 11114385408 1795961008 17.981 100 85 170 0 1833418944 13745008 23712928
23:05:54 3728 8192000000 10745134464 11128823808 1805069456 18.055 100 83 166 0 1842948176 13894016 23984704
23:06:04 4936 8192000000 10758191248 11142467584 1815448496 18.140 100 81 161 2 1850569824 12671264 22450064
23:06:16 2300 8192000000 10764305664 11147571200 1820783168 18.184 100 86 167 2 1856975664 12548544 23643952
23:06:24 2190 8192000000 10774285344 11157204992 1834340512 18.295 100 92 180 1 1871396144 12161680 24893952
23:06:33 6359 8192000000 10763465696 11155345408 1832080624 18.276 100 80 161 1 1867265344 12850976 22333744
23:06:46 5406 8192000000 10777658240 11170291712 1840484384 18.345 100 80 158 1 1875026528 13077792 21464352
23:06:58 2099 8192000000 10797382288 11183611904 1860239008 18.505 100 94 189 2 1900357120 14035616 26082496
23:07:06 2078 8192000000 10803235024 11188989952 1859843056 18.502 100 91 184 1 1898752656 13547520 25362080
23:07:15 2204 8192000000 10799608928 11187580928 1860424768 18.507 100 87 173 0 1898514960 13512240 24577952
23:07:23 2290 8192000000 10806597392 11193135104 1865200736 18.545 100 91 180 1 1904216320 13836544 25179040
23:07:32 1727 8192000000 10812035456 11198353408 1864295152 18.538 100 90 179 2 1902612000 13192432 25124416
23:07:40 2037 8192000000 10807087296 11201454080 1869588848 18.581 100 88 177 1 1906447568 11690576 25168144
23:07:49 1508 8192000000 10820583568 11208269824 1872438672 18.604 100 90 180 0 1910997552 13097392 25461488
23:07:56 1871 8192000000 10822084000 11210510336 1872937808 18.608 100 96 190 0 1914121056 13716432 27466816
23:08:05 1439 8192000000 10823800640 11213836288 1877528560 18.645 100 93 187 2 1917305760 13368160 26409040
23:08:12 1770 8192000000 10830533216 11219312640 1883888880 18.696 100 94 190 2 1924571072 13831264 26850928
23:08:20 1417 8192000000 10825470960 11216990208 1883844832 18.696 100 93 188 2 1923033856 13043952 26145072
23:08:28 1932 8192000000 10829325344 11221336064 1885739872 18.711 100 95 188 1 1925263664 12901616 26622176
23:08:36 1105 8192000000 10837111312 11227164672 1894974480 18.786 100 95 192 0 1936511648 13683104 27854064
23:08:43 1349 8192000000 10828613744 11231457280 1890347776 18.749 100 84 169 1 1928111264 14116368 23647120
23:08:53 46716 8192000000 10823153744 11226263552 1885716176 18.711 100 46 91 2 1906077296 7044304 13316816
23:09:46 29422 8192000000 10785455456 11227709440 1889878272 18.745 100 42 84 0 1910238656 8243312 12117072
23:10:25 5990 8192000000 10823147696 11237658624 1893943840 18.778 100 30 61 2 1908562832 6142608 8476384
23:10:39 5738 8192000000 10811249392 11233284096 1895001472 18.786 100 38 77 0 1913265888 5475056 12789360
23:10:55 7265 8192000000 10810882208 11236978688 1894181760 18.779 100 36 72 0 1911486016 6870432 10433824
23:11:09 5071 8192000000 10807704240 11239841792 1895877920 18.793 100 30 60 1 1911333584 6884016 8571648
23:11:24 6108 8192000000 10805312080 11239649280 1899074480 18.819 100 19 38 1 1910897472 6790992 5032000
23:11:36 11218 8192000000 10808761152 11241844736 1899063440 18.819 100 17 34 2 1909118288 5625744 4429104
23:11:55 11302 8192000000 10816727376 11249332224 1903698240 18.856 100 19 37 1 1919492688 10449472 5344976
23:12:13 9829 8192000000 10822642320 11253792768 1909541296 18.903 100 26 52 0 1927647056 10527136 7578624
23:12:29 6025 8192000000 10819040896 11256651776 1909706064 18.904 100 22 42 2 1921650560 6109568 5834928
23:12:41 11075 8192000000 10829532784 11258195968 1911226960 18.916 100 22 44 1 1923412608 6191152 5994496
23:12:59 9697 8192000000 10824682000 11258257408 1912029376 18.923 100 16 32 2 1922551744 5235440 5286928
23:13:17 9190 8192000000 10823587936 11266727936 1915537248 18.951 100 27 54 4 1934716320 10865664 8313408
23:13:39 15533 8192000000 10816611168 11260755968 1914288784 18.941 100 14 28 0 1924328928 5995760 4044384
23:14:02 14101 8192000000 10818147424 11259387904 1914416160 18.942 100 13 26 1 1925438816 6320080 4702576
23:14:22 27267 8192000000 10828851968 11272052736 1919929568 18.986 100 22 43 0 1932823392 5822544 7071280
23:15:35 25639 8192000000 10834303648 11274997760 1920897136 18.994 100 19 37 2 1932206640 5978336 5331168
23:16:09 11033 8192000000 10814298352 11251863552 1880883248 18.672 98 18 36 2 1891220384 5575840 4761296
23:16:30 5962 8192000000 10827612128 11265064960 1909566880 18.903 100 31 62 1 1929037120 10826816 8643424
23:16:43 8709 8192000000 10781232544 11206225920 1824141568 18.212 96 21 42 1 1835876448 5322928 6411952
23:16:57 7326 8192000000 10787517088 11218096128 1860362016 18.506 99 23 46 1 1873619680 7018928 6238736
23:17:12 10458 8192000000 10786026752 11212898304 1844547312 18.378 98 16 32 0 1854425296 5208624 4669360
23:17:30 3187 8192000000 10774363056 11194863616 1836558992 18.313 98 19 38 1 1847638944 5086720 5993232
23:17:42 7970 8192000000 10753702592 11174731776 1781693792 17.863 96 14 28 1 1791060560 5211056 4155712
23:17:56 11652 8192000000 10761712336 11185713152 1813316768 18.123 98 14 28 2 1823344544 5751968 4275808
23:18:14 8422 8192000000 10726404640 11149860864 1770407968 17.770 96 13 26 1 1779626976 5588400 3630608
23:18:28 8790 8192000000 10719311968 11146756096 1782051248 17.866 98 18 36 2 1792835104 6023168 4760688
23:18:43 14680 8192000000 10713833984 11134435328 1664193312 16.884 91 16 30 0 1673388768 4923696 4271760
23:19:05 9072 8192000000 10734608976 11150454784 1792085184 17.949 99 28 56 0 1809344320 9741632 7517504
23:19:21 16213 8192000000 10720219104 11118678016 1720449952 17.356 95 17 35 2 1730662816 5509072 4703792
23:19:44 59428 8192000000 10667415488 11085840384 1685561824 17.064 93 30 59 0 1699814768 4523888 9729056
23:20:50 10155 8192000000 10704801360 11121303552 1727705488 17.416 96 19 38 2 1738891696 5636448 5549760
23:21:08 6844 8192000000 10718014384 11139330048 1779114304 17.842 98 26 52 0 1793265088 6848384 7302400
23:21:23 4979 8192000000 10708978016 11122061312 1764698720 17.723 98 33 65 0 1779274928 4917600 9658608
23:21:34 6090 8192000000 10701664480 11116855296 1774478384 17.804 99 32 64 2 1790099120 6792912 8827824
23:21:47 6880 8192000000 10711004224 11130486784 1784865744 17.890 99 24 48 1 1797897440 5922752 7108944
23:22:00 8766 8192000000 10724634848 11146510336 1791660560 17.945 99 19 38 0 1802527568 4977872 5889136
23:22:17 5948 8192000000 10703631472 11120517120 1759555312 17.681 97 21 40 2 1771435360 6212960 5667088
23:22:30 8877 8192000000 10737372416 11159269376 1820184896 18.179 100 27 54 0 1833370368 5442768 7742704
23:22:47 8132 8192000000 10740352576 11167653888 1829614000 18.256 100 24 46 2 1843113248 6319808 7179440
23:23:02 7931 8192000000 10747816912 11168985088 1833310160 18.286 100 24 48 2 1845329104 5292304 6726640
23:23:20 8243 8192000000 10749703824 11175149568 1836343040 18.311 100 23 46 3 1848610832 5284032 6983760
23:23:35 12747 8192000000 10781794576 11197722624 1850203744 18.424 100 25 50 0 1868012336 9862736 7945856
23:23:58 12262 8192000000 10766404192 11191341056 1851915088 18.438 100 18 36 1 1862261472 4785712 5560672
23:24:20 35455 8192000000 10775953696 11201712128 1861418240 18.515 100 35 72 3 1877641488 5049168 11174080
23:25:26 17649 8192000000 10779106816 11206049792 1865058000 18.544 100 27 54 2 1878949344 6405696 7485648
23:25:54 11454 8192000000 10784877536 11207757824 1864402752 18.539 100 25 50 0 1876429984 4980192 7047040
23:26:13 6524 8192000000 10781710944 11209850880 1867378704 18.563 100 31 62 1 1882984880 7180848 8425328
23:26:26 9823 8192000000 10795135616 11215507456 1867925904 18.567 100 23 46 3 1879794000 5663584 6204512
23:26:43 8126 8192000000 10775355600 11207716864 1867476352 18.564 100 32 64 4 1882542176 5137248 9928576
23:26:57 4002 8192000000 10779051776 11207942144 1868211168 18.570 100 29 56 3 1881950800 6076336 7663296
23:27:08 20947 8192000000 10812255376 11230846976 1885045968 18.706 100 32 64 1 1899508960 5903344 8559648
23:27:49 16382 8192000000 10831893344 11246669824 1898945808 18.818 100 51 100 0 1922533856 9797232 13790816
23:28:15 28132 8192000000 10847445888 11264704512 1910957776 18.914 100 53 105 0 1937017584 11316592 14743216
23:28:56 13368 8192000000 10862466560 11282677760 1922300128 19.005 100 53 106 0 1952227392 15159104 14768160
23:29:17 7965 8192000000 10874198688 11286818816 1930627216 19.072 100 56 112 1 1964164048 17574496 15962336
23:29:36 25277 8192000000 10867746576 11293835264 1933287760 19.093 100 44 88 3 1963268576 17125376 12855440
23:30:20 14453 8192000000 10862891040 11300847616 1936464064 19.119 100 37 71 1 1962730512 15601088 10665360
23:30:43 14745 8192000000 10879906192 11305623552 1940393360 19.150 100 38 74 0 1965761968 15026656 10341952
23:31:06 106958 8192000000 10883756448 11322781696 1944035216 19.179 100 31 62 1 1971608800 18424720 9148864
23:33:18 20844 8192000000 10889291296 11326590976 1959161840 19.299 100 34 68 1 1988968304 19651152 10155312
23:33:46 20239 8192000000 10895104384 11331928064 1960982512 19.314 100 38 76 1 1992576160 19157632 12436016
23:34:16 19393 8192000000 10907411872 11342278656 1965411216 19.349 100 37 74 3 1996479536 19509024 11559296
23:34:45 14038 8192000000 10921257040 11356024832 1974064864 19.418 100 55 110 1 2010118672 18924000 17129808
23:35:08 8771 8192000000 10911904016 11351326720 1977184400 19.442 100 47 93 1 2011083104 19657680 14241024
23:35:23 9502 8192000000 10925908160 11350360064 1975914304 19.432 100 73 147 1 2018835536 20759952 22161280
23:35:41 13531 8192000000 10929979376 11363356672 1981220720 19.474 100 58 116 0 2020502880 21642096 17640064
23:36:01 6564 8192000000 10933060416 11363237888 1984867616 19.503 100 64 127 0 2026729056 22871360 18990080
23:36:26 5647 8192000000 10940563456 11358810112 1979087344 19.457 100 69 138 2 2022718592 23339200 20292048
23:36:39 4220 8192000000 10938814224 11349884928 1958374448 19.293 99 77 151 1 2005154016 24502000 22277568
23:36:53 2769 8192000000 10937431616 11358638080 1975747936 19.431 100 73 144 3 2021626208 25608704 20269568
23:37:03 4748 8192000000 10923111584 11347939328 1954033264 19.259 99 64 128 0 1998364544 24704160 19627120
23:37:17 7509 8192000000 10921072368 11345113088 1970360512 19.388 100 65 130 1 2012958352 23979840 18618000
23:37:34 12386 8192000000 10915774128 11341758464 1949333520 19.221 99 49 98 1 1988094384 24082336 14678528
23:37:59 4027 8192000000 10916034336 11342929920 1958765424 19.296 100 60 120 3 2001743680 25259680 17718576
23:38:10 2344 8192000000 10921498128 11330985984 1957733808 19.288 100 83 166 0 2008770160 25365344 25671008
23:38:22 4445 8192000000 10922759632 11339845632 1962883152 19.329 100 75 148 2 2012096656 26860880 22352624
23:38:37 2552 8192000000 10939740160 11354570752 1967747712 19.368 100 74 145 2 2019100080 29187904 22164464
23:38:48 10946 8192000000 10937981712 11365691392 1971387712 19.396 100 56 112 0 2019836800 30206576 18242512
23:39:06 2340 8192000000 10944611456 11365478400 1977382896 19.444 100 81 159 0 2034484080 32341696 24759488
23:39:15 1435 8192000000 10947020544 11363086336 1974146704 19.418 100 80 160 1 2032109632 33510000 24452928
23:39:24 1719 8192000000 10958613664 11377672192 1984612784 19.501 100 76 153 0 2042211440 34222064 23376592
23:39:33 13625 8192000000 10953530000 11378253824 1984065472 19.497 100 67 132 0 2040876640 36203648 20607520
23:39:54 2973 8192000000 10969801712 11391008768 1995753552 19.589 100 82 165 3 2055933392 34380000 25799840
23:40:04 2279 8192000000 10958172416 11368779776 1978470208 19.453 99 81 161 2 2039292864 35734272 25088384
23:40:15 3129 8192000000 10936230624 11357925376 1936782320 19.121 97 73 146 3 1994657072 35678928 22195824
23:40:26 3459 8192000000 10947593856 11365961728 1962516512 19.326 99 80 160 0 2022547056 34429488 25601056
23:40:36 2480 8192000000 10948673328 11364892672 1972965440 19.409 100 83 167 0 2030631600 31645136 26021024
23:40:48 2372 8192000000 10944386896 11362996224 1978537360 19.453 100 72 144 0 2032107104 30825120 22744624
23:40:57 2399 8192000000 10956012352 11366895616 1977906864 19.448 100 72 143 0 2032231472 32185744 22138864
23:41:07 5250 8192000000 10895508032 11315134464 1913704784 18.936 97 69 138 2 1968341088 33131280 21505024
23:41:22 2209 8192000000 10929957328 11342655488 1942718240 19.168 99 83 164 2 2003758144 35256112 25783792
23:41:34 3232 8192000000 10930999392 11353640960 1964726736 19.344 100 73 143 3 2016521328 28387360 23407232
23:41:50 10189 8192000000 10904545872 11343429632 1941778848 19.161 99 63 125 2 1991290112 29489424 20021840
23:42:07 9379 8192000000 10904926416 11344437248 1955335952 19.269 100 34 65 3 1990823344 24601392 10886000
23:42:27 6345 8192000000 10899670432 11322011648 1939775616 19.145 99 63 127 1 1987544944 27032016 20737312
23:42:40 8410 8192000000 10882452976 11326091264 1933014800 19.091 99 46 91 0 1970612448 23467024 14130624
23:42:58 13271 8192000000 10903495952 11338862592 1953769088 19.256 100 47 94 1 1990349664 21911120 14669456
23:43:20 3666 8192000000 10926168304 11354824704 1961329568 19.317 100 62 122 3 2011088976 30494912 19264496
23:43:31 3078 8192000000 10929897024 11350036480 1953470976 19.254 99 83 166 0 2008413088 29073504 25868608
23:43:42 2204 8192000000 10926046080 11334615040 1932514624 19.087 98 85 168 1 1981170816 23249744 25406448
23:43:51 3708 8192000000 10935508272 11352326144 1966358848 19.357 100 86 172 0 2016007152 24500832 25147472
23:44:01 2401 8192000000 10915242512 11340005376 1932770336 19.089 98 82 162 0 1984399872 26838080 24791456
23:44:11 4192 8192000000 10948264432 11365027840 1973350576 19.412 100 88 175 2 2029799568 29876336 26572656
23:44:23 2237 8192000000 10961966512 11369181184 1981762368 19.479 100 87 175 1 2039808976 31235664 26810944
23:44:31 4624 8192000000 10947356400 11368804352 1978804784 19.455 100 61 123 0 2026523280 29380864 18337632
23:44:45 965 8192000000 10961873072 11375071232 1989420288 19.539 100 90 182 0 2046241216 29801456 27019472
23:44:53 6385 8192000000 10947767088 11367952384 1979768064 19.463 100 83 166 2 2036518096 29913808 26836224
23:45:08 3440 8192000000 10964259696 11384082432 1991464704 19.555 100 72 143 0 2046119328 32124944 22529680
23:45:22 2414 8192000000 10961695152 11380051968 1987669168 19.525 100 73 144 1 2044563648 33661728 23232752
23:45:32 3382 8192000000 10977274448 11390771200 1995628784 19.588 100 83 165 0 2055615664 34341600 25645280
23:45:43 6107 8192000000 10931389808 11357437952 1953717104 19.256 99 63 126 1 2007442032 33488880 20236048
23:45:56 3357 8192000000 10887757920 11322761216 1917207952 18.964 98 52 104 0 1966166736 31789120 17169664
23:46:09 16463 8192000000 10890090512 11310227456 1904795584 18.865 98 49 98 1 1953058064 32192064 16070416
23:46:34 2481 8192000000 10904194640 11316273152 1901547104 18.839 98 77 154 0 1964174672 36872976 25754592
23:46:43 2425 8192000000 10907528560 11320197120 1928365264 19.054 100 74 148 2 1991037296 38026864 24645168
23:46:54 2171 8192000000 10934320464 11339841536 1943805888 19.177 100 82 164 0 2009389280 38672528 26910864
23:47:03 4862 8192000000 10925596208 11345522688 1949185408 19.220 100 65 131 1 2009554352 39516544 20852400
23:47:18 8745 8192000000 10906461056 11342209024 1930968192 19.075 99 40 80 0 1979072832 34480016 13624624
23:47:33 4602 8192000000 10934046624 11356717056 1955926096 19.274 100 49 96 1 2012274352 40848448 15499808
23:47:48 6668 8192000000 10912115072 11341352960 1934889248 19.106 99 47 94 1 1988213840 37785952 15538640
23:48:06 5087 8192000000 10913196560 11341373440 1942970800 19.170 100 43 86 2 1992661520 35698800 13991920
23:48:22 10172 8192000000 10906149504 11338592256 1939661024 19.144 100 41 83 2 1990268912 36938208 13669680
23:48:41 15287 8192000000 10903922944 11338698752 1926837712 19.042 99 34 68 0 1976848544 38074016 11936816
23:49:04 7859 8192000000 10910789120 11343466496 1946147824 19.196 100 39 78 0 1998529280 38983184 13398272
23:49:19 11854 8192000000 10885782032 11320573952 1918935744 18.978 99 38 75 2 1974662416 42419728 13306944
23:49:45 8714 8192000000 10897210800 11329359872 1914224544 18.941 99 37 74 1 1969939184 42446624 13268016
23:50:02 7937 8192000000 10893464768 11323527168 1889574352 18.742 98 45 91 1 1952347904 47166544 15607008
23:50:20 12682 8192000000 10901455680 11338739712 1923936656 19.018 100 37 74 1 1986094368 48821264 13336448
23:50:40 20038 8192000000 10887662816 11334643712 1928123248 19.052 100 26 52 3 1975877648 38669104 9085296
23:51:30 20710 8192000000 10887631168 11339481088 1915799808 18.953 100 19 38 1 1966958064 43835760 7322496
23:51:58 8703 8192000000 10883299920 11350827008 1916653648 18.960 100 15 30 3 1967029904 45243696 5132560
23:52:30 14838 8192000000 10852691136 11304497152 1871069760 18.593 98 15 30 0 1909201376 32678064 5453552
23:52:56 31092 8192000000 10835160944 11311144960 1892286288 18.764 99 17 34 1 1926873568 28406160 6181120
23:53:42 64759 8192000000 10822332432 11264724992 1858895392 18.494 97 56 109 1 1883186160 7532384 16758384
23:54:55 40450 8192000000 10853594624 11307823104 1923797600 19.017 100 43 86 2 1950379344 14593968 11987776
23:56:04 21407 8192000000 10819886064 11269734400 1890334448 18.748 99 18 36 1 1907227952 11952544 4940960
23:56:36 102644 8192000000 10857170256 11324157952 1903857904 18.857 99 15 30 1 1919517264 11602064 4057296
23:58:53 147688 8192000000 10861105904 11320418304 1893003680 18.770 97 15 30 0 1913758576 16100928 4653968
00:01:27 99756 8192000000 10882243120 11350056960 1958818048 19.297 100 14 28 0 1975259392 12596896 3844448
00:03:14 94615 8192000000 10892340592 11351261184 1951579312 19.239 99 30 60 1 1974857264 14111968 9165984
00:05:05 76123 8192000000 10886740816 11352367104 1966647056 19.359 100 20 39 2 1978631344 6464640 5519648
00:06:45 21090 8192000000 10891273296 11363983360 1976047600 19.433 100 25 50 1 1993241296 10455008 6738688
00:07:12 15184 8192000000 10914146000 11362418688 1954781040 19.265 99 18 33 2 1969624832 9916656 4927136
00:07:39 42482 8192000000 10892264400 11362693120 1976110064 19.434 100 36 73 1 1996118208 9943584 10064560
00:08:42 90530 8192000000 10899457216 11376750592 1982033136 19.481 100 12 24 0 1997549632 11719840 3796656
00:10:52 53109 8192000000 10902586368 11379744768 1960552400 19.310 99 14 28 2 1981454352 16605728 4296224
00:11:54 97198 8192000000 10912190672 11385389056 1990637488 19.549 100 21 42 1 2009784272 13026272 6120512
00:13:50 28921 8192000000 10900284112 11376295936 1974133520 19.418 99 13 26 0 1991600224 13113232 4353472
00:14:33 49926 8192000000 10920567296 11404906496 1988436608 19.531 100 12 24 0 2009755328 17762800 3555920
00:16:09 45294 8192000000 10908953568 11389210624 1963296144 19.332 98 24 49 1 1980680528 10526736 6857648
00:17:02 71985 8192000000 10917438976 11393789952 1992495904 19.564 100 14 28 1 2005750080 9027968 4226208
00:18:21 37909 8192000000 10925284096 11386544128 1981998032 19.481 99 39 78 0 2000756736 7813808 10944896
00:19:05 30231 8192000000 10924492784 11389886464 1983323040 19.491 99 36 72 3 2003869808 10452864 10093904
00:19:52 56453 8192000000 10918565344 11398254592 1964528400 19.342 98 19 38 0 1987005360 16684112 5792848
00:21:47 32120 8192000000 10921013200 11379113984 1968574352 19.374 99 24 48 1 1987841696 12617104 6650240
00:22:43 66139 8192000000 10916378688 11378208768 1964086400 19.339 99 15 30 0 1980562208 12560496 3915312
00:23:56 41746 8192000000 10923115200 11385671680 1994387664 19.578 100 34 68 0 2017419648 13670608 9361376
00:24:54 82890 8192000000 10921141840 11382910976 1929549152 19.063 97 4 8 0 1942687024 12366848 771024
00:26:35 78539 8192000000 10886895488 11362988032 1884189328 18.699 95 18 35 1 1904881920 16153456 4539136
00:27:59 84292 8192000000 10904341936 11369435136 1976722624 19.439 100 18 36 0 1992379936 10503840 5153472
00:29:30 49200 8192000000 10900700528 11363356672 1963281088 19.332 99 29 59 1 1981635616 10461520 7893008
00:30:25 24853 8192000000 10886307856 11336773632 1892775168 18.768 96 34 68 0 1910986864 9084656 9127040
00:31:11 36046 8192000000 10852747104 11326689280 1937075824 19.123 99 12 20 1 1946637296 6740432 2821040
00:31:53 18575 8192000000 10850139216 11326169088 1940494016 19.151 100 3 6 0 1947225232 6261312 469904
00:32:18 13692 8192000000 10863651392 11341873152 1949864176 19.225 100 6 12 0 1957512320 6283520 1364624
00:32:38 28308 8192000000 10857545984 11323744256 1893268224 18.772 97 10 18 2 1901988272 6699328 2020720
00:33:13 55495 8192000000 10867497024 11348353024 1953127808 19.251 100 9 18 0 1963474368 7991872 2354688
00:34:17 56878 8192000000 10884194320 11341520896 1905976480 18.874 97 11 22 0 1916612240 7556224 3079536
00:35:22 70151 8192000000 10861188032 11331432448 1845153520 18.383 94 25 49 1 1867417664 15327136 6937008
00:36:44 71549 8192000000 10882082832 11339857920 1887777760 18.728 97 20 39 4 1910128992 16336928 6014304
00:38:02 74144 8192000000 10844625424 11315847168 1865885968 18.551 96 14 28 0 1886089872 16437408 3766496
00:39:23 54561 8192000000 10867418832 11314622464 1816434992 18.149 94 13 26 0 1828885744 8766208 3684544
00:40:38 79390 8192000000 10845189440 11299463168 1821692000 18.192 94 16 32 2 1839100944 12787360 4621584
00:42:08 70206 8192000000 10844968256 11275096064 1822045424 18.194 95 22 43 0 1840454480 12674048 5735008
00:43:34 20778 8192000000 10833579360 11272863744 1844788144 18.380 97 32 64 1 1864116592 10071440 9257008
00:44:00 44264 8192000000 10848573216 11298136064 1882485216 18.685 99 35 69 0 1902574464 10274720 9814528
00:44:55 39611 8192000000 10829434480 11279212544 1853774864 18.453 97 29 58 1 1873158256 11189008 8194384
00:45:43 123458 8192000000 10849929888 11307139072 1833317776 18.286 96 18 36 1 1852764080 14527280 4919024
00:47:52 141219 8192000000 10834301392 11304701952 1881404272 18.676 98 19 38 0 1898701280 11275088 6021920
00:51:04 62261 8192000000 10836445552 11308445696 1882702000 18.687 98 8 16 0 1893043392 8030944 2310448
00:53:45 50516 8192000000 10880668352 11340156928 1951017440 19.235 100 27 54 0 1965894896 7307552 7569904
00:54:42 77190 8192000000 10863244208 11348987904 1933100896 19.092 99 16 32 1 1948530448 10623680 4805872
00:56:05 73890 8192000000 10861640000 11332214784 1916391760 18.958 98 16 32 1 1930091232 9779136 3920336
00:57:25 58968 8192000000 10900796336 11359608832 1964951616 19.345 100 20 40 1 1978007872 8110080 4946176
00:58:35 28499 8192000000 10900593104 11361013760 1964875584 19.345 99 33 66 1 1988153712 14239472 9038656
00:59:10 52655 8192000000 10921059792 11381870592 1979737872 19.463 100 27 54 2 2000925504 13452992 7734640
01:00:12 125727 8192000000 10914455616 11399753728 1970559072 19.390 99 15 30 3 1988057056 13517216 3980768
01:02:31 51657 8192000000 10949389120 11406409728 1999389888 19.618 100 27 53 2 2018510352 11589920 7530544
01:03:31 78633 8192000000 10933953632 11415052288 1985010352 19.504 99 21 42 1 2007088176 16148128 5929696
01:05:02 35633 8192000000 10940049936 11414601728 1988104480 19.529 99 28 56 0 2007029520 11171152 7753888
01:05:48 51402 8192000000 10926679520 11388772352 1944016720 19.179 97 37 71 2 1965888224 11782736 10088768
01:06:46 33690 8192000000 10942565312 11393400832 1970894816 19.393 99 36 72 0 1989964560 9478928 9590816
01:07:27 51102 8192000000 10925057760 11401052160 1974044544 19.418 99 32 64 1 1998953472 15941744 8967184
01:08:27 46869 8192000000 10923785968 11406823424 1998842976 19.614 100 30 60 2 2018894928 11319232 8732720
01:09:24 109510 8192000000 10907111744 11373363200 1944315248 19.181 97 22 42 1 1959419632 8325616 6778768
01:11:58 79902 8192000000 10906289216 11382636544 1958308464 19.293 98 22 44 0 1976337536 11739664 6289408
01:13:33 40561 8192000000 10911151552 11389812736 1986001008 19.512 100 6 12 0 1998392224 10744240 1646976
01:14:23 49800 8192000000 10913735008 11396186112 1992486928 19.563 100 8 16 0 2009439392 14694784 2257680
01:16:31 84012 8192000000 10898528640 11383492608 1932815376 19.089 97 10 19 0 1943545920 8100640 2629904
01:18:08 59569 8192000000 10886444016 11364454400 1889964480 18.745 95 14 28 2 1903168112 9587248 3616384
01:19:15 28392 8192000000 10903780016 11365326848 1970905872 19.393 100 30 60 1 1987685136 8125952 8653312
01:19:56 28630 8192000000 10899563536 11364450304 1946968656 19.202 99 19 38 1 1959245888 7105600 5171632
01:20:31 59872 8192000000 10900886192 11375067136 1941656288 19.160 98 38 76 1 1967143840 14478928 11008624
01:21:54 52828 8192000000 10888763504 11357327360 1919789296 18.985 98 12 24 0 1932843360 9776816 3277248
01:22:54 89147 8192000000 10852430304 11312865280 1833690320 18.289 93 16 32 0 1854355232 15726432 4938480
01:24:38 58503 8192000000 10883217376 11349385216 1896993536 18.802 97 18 36 1 1910499520 8162720 5343264
01:25:43 58466 8192000000 10911673664 11359371264 1876500448 18.637 96 24 48 0 1898578000 15363888 6713664
01:26:51 38303 8192000000 9356947840 9640366080 500756992 5.760 26 1 2 0 508981744 8162624 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 28-11-2020 01:28:12 to 28-11-2020 01:28:43.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 84 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-11-2020 01:28:44 to 28-11-2020 01:28:46.

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          242079
MON$OLDEST_ACTIVE               242080
MON$OLDEST_SNAPSHOT             242080
MON$NEXT_TRANSACTION            242080
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                       2009472
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:37: 
:38: mscs-test-161.budzdorov.ru    Sat Nov 28 01:27:30 2020
:39:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:40: 
:41: 
:42: mscs-test-161.budzdorov.ru    Sat Nov 28 01:27:33 2020
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:44: 
:45: 
:46: mscs-test-161.budzdorov.ru    Sat Nov 28 01:27:33 2020
:47:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:48: 
--- end of diff output ---

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

28.11.20 01:28:47. 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
2020-11-28 01:28:50 No severe PSQL-related problems occured
28.11.20 01:28:51. End of report.