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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16985860 kB
MemAvailable 31112064 kB
Buffers 0 kB
Cached 14737520 kB
SwapCached 3280 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-28 22:27:18
DTS_END                         2021-02-28 22:27:18.0080
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/43048
TRN_ID                          243338
ATT_ID                          649
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: 9036.01 24165 1084321
customer order: creation 175.17 350 21020
customer order: refuse 14.65 349 1758
order to supplier: creation 46.80 1263 5616
order to supplier: removal 3.19 120411 383
invoice (draft): creation 46.89 3514 5627
invoice (draft): removal 49.54 902 5945
invoice accept: apply 42.45 17843 5094
invoice accept: cancel 45.19 814 5423
customer reserve: creation 3903.83 176 468460
customer reserve: removal 4414.19 68 529703
realization accept: apply 85.54 199 10265
realization accept: cancel 76.33 110 9159
payment from customer: creation 60.23 124 7228
payment from customer: removal 6.02 74 722
payment to supplier: creation 50.13 134 6016
payment to supplier: removal 3.28 90 393
service: total inventory turnovers 4.90 1291 588
service: total monetary turnovers 6.83 32 820
service: aggregate perf. data 0.81 20688 97
service: refresh index statistics 0.03 314871 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-02-2021 22:29:31 to 28-02-2021 22:29:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5881
TEST_TIME 2 4830
TEST_TIME 3 5339
TEST_TIME 4 5039
TEST_TIME 5 6141
TEST_TIME 6 6357
TEST_TIME 7 6500
TEST_TIME 8 6231
TEST_TIME 9 6018
TEST_TIME 10 5813
TEST_TIME 11 5652
TEST_TIME 12 5780
TEST_TIME 13 5842
TEST_TIME 14 6025
TEST_TIME 15 5950
TEST_TIME 16 6049
TEST_TIME 17 6259
TEST_TIME 18 6452
TEST_TIME 19 6448
TEST_TIME 20 6781
TEST_TIME 21 7543
TEST_TIME 22 7731
TEST_TIME 23 7947
TEST_TIME 24 8411
TEST_TIME 25 8562
TEST_TIME 26 8872
TEST_TIME 27 9100
TEST_TIME 28 9661
TEST_TIME 29 10785
TEST_TIME 30 10847
TEST_TIME 31 10674
TEST_TIME 32 10817
TEST_TIME 33 10783
TEST_TIME 34 10680
TEST_TIME 35 10460
TEST_TIME 36 10269
TEST_TIME 37 10168
TEST_TIME 38 10290
TEST_TIME 39 10354
TEST_TIME 40 10220
TEST_TIME 41 10153
TEST_TIME 42 9992
TEST_TIME 43 9995
TEST_TIME 44 9870
TEST_TIME 45 9761
TEST_TIME 46 9590
TEST_TIME 47 9475
TEST_TIME 48 9514
TEST_TIME 49 9526
TEST_TIME 50 9381
TEST_TIME 51 9384
TEST_TIME 52 9417
TEST_TIME 53 9337
TEST_TIME 54 9290
TEST_TIME 55 9189
TEST_TIME 56 9284
TEST_TIME 57 9341
TEST_TIME 58 9319
TEST_TIME 59 9353
TEST_TIME 60 9320
TEST_TIME 61 9280
TEST_TIME 62 9442
TEST_TIME 63 9468
TEST_TIME 64 9417
TEST_TIME 65 9423
TEST_TIME 66 9437
TEST_TIME 67 9469
TEST_TIME 68 9442
TEST_TIME 69 9464
TEST_TIME 70 9419
TEST_TIME 71 9309
TEST_TIME 72 9306
TEST_TIME 73 9271
TEST_TIME 74 9265
TEST_TIME 75 9216
TEST_TIME 76 9182
TEST_TIME 77 9128
TEST_TIME 78 9128
TEST_TIME 79 9135
TEST_TIME 80 9161
TEST_TIME 81 9114
TEST_TIME 82 9201
TEST_TIME 83 9167
TEST_TIME 84 9188
TEST_TIME 85 9216
TEST_TIME 86 9190
TEST_TIME 87 9264
TEST_TIME 88 9216
TEST_TIME 89 9201
TEST_TIME 90 9410
TEST_TIME 91 9369
TEST_TIME 92 9398
TEST_TIME 93 9318
TEST_TIME 94 9234
TEST_TIME 95 9220
TEST_TIME 96 9184
TEST_TIME 97 9154
TEST_TIME 98 9180
TEST_TIME 99 9148
TEST_TIME 100 9148
TEST_TIME 101 9152
TEST_TIME 102 9214
TEST_TIME 103 9302
TEST_TIME 104 9264
TEST_TIME 105 9316
TEST_TIME 106 9275
TEST_TIME 107 9334
TEST_TIME 108 9310
TEST_TIME 109 9322
TEST_TIME 110 9375
TEST_TIME 111 9353
TEST_TIME 112 9283
TEST_TIME 113 9246
TEST_TIME 114 9208
TEST_TIME 115 9195
TEST_TIME 116 9187
TEST_TIME 117 9148
TEST_TIME 118 9160
TEST_TIME 119 9106
TEST_TIME 120 9038

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-02-2021 22:29:35 to 28-02-2021 22:29:38.

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 1518504 1518504 0 0.00 0 21655 6 0 0
doc_list_biud 1518501 1518501 0 0.00 0 57687 30 0 0
sp_add_invoice_to_stock 5265 5094 171 3.24 60 148633 17843 0 171
sp_cancel_adding_invoice 5423 5423 0 0.00 6 67680 815 0 0
sp_cancel_client_order 1758 1758 0 0.00 3 10474 350 0 0
sp_cancel_customer_reserve 529703 529703 0 0.00 1 57689 68 0 0
sp_cancel_pay_from_customer 722 722 0 0.00 3 3684 74 0 0
sp_cancel_pay_to_supplier 393 393 0 0.00 2 4912 91 0 0
sp_cancel_supplier_invoice 5953 5945 8 0.13 2 20339 903 0 8
sp_cancel_supplier_order 383 383 0 0.00 9 1066720 120411 0 0
sp_cancel_write_off 9159 9159 0 0.00 1 13863 110 0 0
sp_client_order 21020 21020 0 0.00 3 28762 350 0 0
sp_customer_reserve 468460 468460 0 0.00 0 33878 177 0 0
sp_fill_shopping_cart 32250 32250 0 0.00 1 12103 41 0 0
sp_fill_shopping_cart_clo_res 468454 468454 0 0.00 0 22283 14 0 0
sp_get_clo_for_invoice 5088 5088 0 0.00 0 26157 307 0 0
sp_kill_cost_storno 15697 15697 0 0.00 0 5632 61 0 0
sp_kill_qstorno_ret_qs2qd 1074893 1074893 0 0.00 0 57684 37 0 0
sp_kill_qty_storno 567724 567724 0 0.00 0 57687 79 0 0
sp_lock_selected_doc 21225 21225 0 0.00 0 8399 6 0 0
sp_make_cost_storno 28597 28597 0 0.00 0 21512 62 0 0
sp_multiply_rows_for_pdistr 28597 28597 0 0.00 0 21562 31 0 0
sp_multiply_rows_for_qdistr 21020 21020 0 0.00 0 11990 147 0 0
sp_pay_from_customer 7228 7228 0 0.00 4 21709 125 0 0
sp_pay_to_supplier 6016 6016 0 0.00 5 13019 134 0 0
sp_payment_common 13244 13244 0 0.00 1 21642 32 0 0
sp_qd_handle_on_cancel_clo 1758 1758 0 0.00 0 10468 315 0 0
sp_qd_handle_on_invoice_upd_sts 10511 10511 0 0.00 0 20823 350 0 0
sp_qd_handle_on_reserve_upd_sts 10265 10265 0 0.00 0 13177 62 0 0
sp_reserve_write_off 10265 10265 0 0.00 6 21701 200 0 0
sp_supplier_invoice 5627 5627 0 0.00 5 97506 3515 0 0
sp_supplier_order 5616 5616 0 0.00 5 40108 1263 0 0
srv_aggregate_perf_data 98 97 1 1.02 3436 220067 20688 0 1
srv_fill_mon_cache_memory 169 169 0 0.00 925 169972 31658 0 0
srv_find_qd_qs_mism 1035941 1035941 0 0.00 0 18204 5 0 0
srv_make_invnt_saldo 588 588 0 0.00 42 152905 1292 0 0
srv_make_money_saldo 820 820 0 0.00 1 5172 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 257040 448828 314872 0 0
t$perf-abend:sp_add_invoice_to_stock 171 171 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 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 5095 5095 0 0.00 0 11929 168 0 0
t$perf-norm:sp_cancel_adding_invoice 419 419 0 0.00 1 8905 86 0 0
t$perf-norm:sp_cancel_client_order 1758 1758 0 0.00 0 1598 12 0 0
t$perf-norm:sp_cancel_customer_reserve 699 699 0 0.00 0 7393 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 722 722 0 0.00 0 6825 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 393 393 0 0.00 0 2098 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 1608 15 0 0
t$perf-norm:sp_cancel_supplier_order 383 383 0 0.00 0 25681 1690 0 0
t$perf-norm:sp_cancel_write_off 1102 1102 0 0.00 0 4446 9 0 0
t$perf-norm:sp_client_order 21020 21020 0 0.00 0 6398 18 0 0
t$perf-norm:sp_customer_reserve 1049 1049 0 0.00 0 3183 12 0 0
t$perf-norm:sp_pay_from_customer 7228 7228 0 0.00 0 6688 9 0 0
t$perf-norm:sp_pay_to_supplier 6016 6016 0 0.00 0 3456 10 0 0
t$perf-norm:sp_reserve_write_off 10265 10265 0 0.00 0 11211 9 0 0
t$perf-norm:sp_supplier_invoice 5627 5627 0 0.00 0 7149 17 0 0
t$perf-norm:sp_supplier_order 5616 5616 0 0.00 0 6726 15 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 525 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 240 5 0 0
t$perf-norm:srv_make_invnt_saldo 588 588 0 0.00 0 4650 33 0 0
t$perf-norm:srv_make_money_saldo 820 820 0 0.00 0 754 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 10516 10174 342 3.25 0 7889 21 0 342
v_all_customers 37778 37778 0 0.00 0 108 1 0 0
v_all_suppliers 31172 31172 0 0.00 0 22 1 0 0
v_all_wares 42040 42040 0 0.00 0 201 1 0 0
v_cancel_adding_invoice 838 838 0 0.00 0 1149 8 0 0
v_cancel_client_order 3516 3516 0 0.00 0 4854 7 0 0
v_cancel_customer_prepayment 1444 1444 0 0.00 0 2617 5 0 0
v_cancel_customer_reserve 1398 1398 0 0.00 0 2936 9 0 0
v_cancel_payment_to_supplier 786 786 0 0.00 0 2568 15 0 0
v_cancel_supplier_invoice 810 794 16 1.97 0 1589 19 0 16
v_cancel_supplier_order 766 766 0 0.00 0 1673 7 0 0
v_cancel_write_off 2204 2204 0 0.00 0 2580 15 0 0
v_max_id_clo_ord 5613 5613 0 0.00 0 1581 2 0 0
v_max_id_clo_res 1049 1049 0 0.00 0 1956 14 0 0
v_max_id_ord_sup 5616 5616 0 0.00 0 5310 5 0 0
v_max_non_paid_invoice 1659 1659 0 0.00 0 2485 4 0 0
v_max_non_paid_realizn 4142 4142 0 0.00 0 2885 5 0 0
v_min_id_clo_ord 5613 5613 0 0.00 0 4066 7 0 0
v_min_id_clo_res 1049 1049 0 0.00 0 4717 10 0 0
v_min_id_ord_sup 5616 5616 0 0.00 0 6880 8 0 0
v_min_non_paid_invoice 6016 6016 0 0.00 0 6074 16 0 0
v_min_non_paid_realizn 7228 7228 0 0.00 0 20312 24 0 0
v_our_firm 10434 10434 0 0.00 0 17 1 0 0
v_reserve_write_off 20530 20530 0 0.00 0 4861 8 0 0
x_lock_depdocs_on_canc_invoice 10971 10971 0 0.00 0 15877 126 0 0
x_lock_depdocs_on_canc_sup_ord 383 383 0 0.00 0 4850 393 0 0
x_make_qstorno_1000_1200 5616 5616 0 0.00 2 40102 1180 0 0
x_make_qstorno_1200_2000 5627 5627 0 0.00 2 97457 3367 0 0
x_make_qstorno_2100_3300 468460 468460 0 0.00 0 33876 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-02-2021 22:29:39 to 28-02-2021 22:29:43.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:21 4 8192000000 8808330816 8821444608 13400128 0.163 3 2 3 0 13579920 67504 112288
19:57:28 14478 8192000000 10215244656 10517794816 906230720 9.960 72 52 105 0 926577536 2614256 17732560
19:57:50 22199 8192000000 10315345552 10631528448 1366519120 14.296 100 76 152 0 1395610768 4437920 24653728
19:58:22 35158 8192000000 10389737136 10711654400 1429099600 14.853 100 85 171 1 1462905744 6098416 27707728
19:59:09 18662 8192000000 10408288272 10735394816 1460617856 15.131 100 84 168 0 1494664432 6966144 27080432
19:59:47 21259 8192000000 10435799408 10772668416 1491946816 15.406 100 83 166 0 1527305104 8312448 27045840
20:00:17 24063 8192000000 10467166832 10805460992 1517830880 15.631 100 86 172 2 1554087024 8759440 27496704
20:00:55 20331 8192000000 10508432992 10848989184 1551035536 15.919 100 87 174 1 1588435504 9698416 27701552
20:01:25 8664 8192000000 10496852288 10849955840 1565352496 16.042 100 78 156 1 1599070256 10047392 23670368
20:01:56 16593 8192000000 10539110176 10892361728 1595619440 16.302 100 81 163 0 1630709264 10622320 24467504
20:02:21 20827 8192000000 10567539520 10924822528 1615892112 16.475 100 79 158 3 1654779424 15555536 23331776
20:02:51 16252 8192000000 10580972320 10939695104 1641441872 16.692 100 84 167 0 1678456272 12178816 24835584
20:03:16 13784 8192000000 10598163520 10961231872 1652708208 16.787 100 87 174 1 1692226416 13543024 25975184
20:03:41 8609 8192000000 10606851920 10973024256 1668336864 16.919 100 78 156 0 1703894512 13178864 22378784
20:03:57 8875 8192000000 10628757248 10996981760 1676827328 16.991 100 84 168 0 1714449888 12931056 24691504
20:04:13 7995 8192000000 10634866624 11004514304 1700470464 17.189 100 77 154 0 1735515584 12864288 22180832
20:04:30 8033 8192000000 10657581280 11034275840 1718484720 17.340 100 70 138 0 1750135856 11235824 20415312
20:04:46 6747 8192000000 10667664192 11047931904 1734879648 17.476 100 75 150 0 1768264848 12040480 21344720
20:05:01 9118 8192000000 10692624032 11065245696 1753027856 17.627 100 85 169 1 1789408048 12006800 24373392
20:05:20 5816 8192000000 10704888032 11078631424 1764215312 17.719 100 82 164 1 1800718464 13084288 23418864
20:05:32 3587 8192000000 10706277744 11086045184 1772019328 17.784 100 77 154 1 1805918752 12405040 21494384
20:05:43 5399 8192000000 10717325568 11094532096 1779990512 17.849 100 86 172 2 1818122640 13581696 24550432
20:05:55 4282 8192000000 10722512240 11103764480 1786565984 17.904 100 86 170 3 1824326800 14345136 23415680
20:06:07 2287 8192000000 10735344464 11111727104 1787833664 17.914 100 86 172 1 1826877712 14615184 24428864
20:06:17 2846 8192000000 10738621504 11119812608 1794957296 17.973 100 89 176 0 1832976240 13763248 24255696
20:06:26 2624 8192000000 10743507104 11119898624 1796613248 17.986 100 81 162 1 1832851680 13920240 22318192
20:06:36 8815 8192000000 10746737648 11126685696 1801858672 18.029 100 87 174 0 1841451264 15089248 24503344
20:06:51 2365 8192000000 10746215536 11128147968 1807975648 18.079 100 90 178 1 1845832656 13407120 24449888
20:07:00 3724 8192000000 10763503296 11145863168 1809115104 18.089 100 84 165 2 1845443184 13634896 22693184
20:07:11 2526 8192000000 10770407248 11151605760 1823871792 18.209 100 88 174 0 1863345680 14556992 24916896
20:07:20 2449 8192000000 10769210128 11154624512 1830077840 18.260 100 82 164 2 1866861248 13494016 23289392
20:07:29 2734 8192000000 10778708576 11166814208 1834153520 18.293 100 88 176 2 1871571648 13336320 24081808
20:07:38 2770 8192000000 10779499232 11163721728 1835577488 18.305 100 85 167 1 1871293216 11926272 23789456
20:07:48 3421 8192000000 10784109616 11172110336 1845237264 18.383 100 89 178 4 1882439088 12209296 24992528
20:07:58 2358 8192000000 10790687728 11180711936 1850685904 18.428 100 87 173 1 1891329488 16564272 24079312
20:08:07 2277 8192000000 10801273776 11191083008 1855012784 18.463 100 89 177 1 1893023152 13611152 24399216
20:08:17 2089 8192000000 10801815120 11187449856 1856616160 18.476 100 89 180 0 1895674576 14382400 24676016
20:08:25 1556 8192000000 10807713904 11192459264 1858568144 18.492 100 97 195 4 1900722480 14814560 27339776
20:08:33 2317 8192000000 10807179920 11196145664 1861454784 18.515 100 89 177 2 1900584384 13531136 25598464
20:08:42 1388 8192000000 10814828016 11202793472 1868364720 18.571 100 95 188 1 1908471232 13327776 26778736
20:08:50 1355 8192000000 10811171472 11199721472 1867519120 18.564 100 94 186 5 1907653504 13667136 26467248
20:08:58 32832 8192000000 10789344112 11194966016 1863482016 18.532 100 58 116 1 1891879392 11980912 16416464
20:09:37 5727 8192000000 10797009632 11194064896 1862339952 18.522 100 53 105 2 1884980144 7289584 15350608
20:09:49 7117 8192000000 10778976400 11192893440 1861551760 18.516 100 42 85 0 1882497200 9242832 11702608
20:10:03 6398 8192000000 10770654528 11196588032 1867496064 18.564 100 46 92 0 1889908352 10244208 12168080
20:10:17 3821 8192000000 10788741200 11202727936 1864510912 18.540 100 35 68 2 1881051856 6535744 10005200
20:10:27 6865 8192000000 10774884720 11199340544 1865746144 18.550 100 22 44 1 1879084864 7541840 5796880
20:10:45 5613 8192000000 10775882896 11205193728 1868333520 18.571 100 16 32 1 1878787088 6098048 4355520
20:10:57 5453 8192000000 10785100048 11210493952 1873447456 18.612 100 31 61 1 1888890096 6834336 8608304
20:11:10 7288 8192000000 10791366784 11217035264 1879336992 18.660 100 30 60 0 1895176944 7065392 8774560
20:11:26 5342 8192000000 10805635264 11223175168 1882984080 18.689 100 40 80 2 1900039568 5442464 11613024
20:11:39 9138 8192000000 10798136000 11223162880 1884238528 18.699 100 30 61 3 1900706848 8600096 7868224
20:11:58 8905 8192000000 10813796992 11229790208 1889388192 18.741 100 35 70 0 1910336384 10882064 10066128
20:12:13 9450 8192000000 10790140560 11224342528 1888470000 18.733 100 22 44 2 1901193936 6671456 6052480
20:12:32 14518 8192000000 10805229856 11235074048 1894946048 18.786 100 27 54 1 1909854352 6152480 8755824
20:12:54 61251 8192000000 10806585152 11243208704 1895215920 18.788 100 21 42 0 1906724624 5527440 5981264
20:14:07 7581 8192000000 10813476416 11245936640 1898819744 18.817 100 23 46 1 1911971936 6851600 6300592
20:14:24 3572 8192000000 10824581856 11248377856 1903493600 18.854 100 33 64 5 1920247856 6743696 10010560
20:14:36 6175 8192000000 10815052112 11245957120 1902966896 18.850 100 24 48 0 1915956192 5910864 7078432
20:14:48 6218 8192000000 10832346848 11261435904 1903911632 18.858 100 22 46 1 1924487264 14389472 6186160
20:15:01 8630 8192000000 10823707568 11255021568 1909704384 18.904 100 25 48 0 1922862640 6544160 6614096
20:15:20 10681 8192000000 10828575680 11257008128 1909708864 18.904 100 23 46 0 1921981264 4927424 7344976
20:15:38 6914 8192000000 10820802448 11255451648 1909525472 18.903 100 21 42 2 1921428016 5808624 6093920
20:15:52 10966 8192000000 10820669680 11256381440 1908037440 18.891 100 14 28 0 1917926832 6118080 3771312
20:16:10 6154 8192000000 10829293008 11261509632 1913647584 18.936 100 26 51 2 1927120368 6413248 7059536
20:16:23 11523 8192000000 10805954128 11242156032 1870194080 18.586 98 15 32 0 1880022560 4916544 4911936
20:16:40 10493 8192000000 10809387760 11246387200 1885656400 18.711 99 21 41 1 1897987904 5442912 6888592
20:17:01 9654 8192000000 10804755792 11235889152 1873394464 18.612 99 20 39 2 1884709664 6126336 5188864
20:17:18 13946 8192000000 10803105872 11237683200 1892273056 18.764 100 11 22 1 1901169824 5690304 3206464
20:17:43 15319 8192000000 10770964976 11187060736 1749199104 17.595 93 35 67 1 1765502208 6394128 9908976
20:18:05 59383 8192000000 10757379104 11194355712 1849442720 18.418 100 24 48 2 1861531600 4867264 7221616
20:19:11 13888 8192000000 10728304688 11159732224 1706782368 17.242 92 13 26 0 1715792272 5383424 3626480
20:19:32 7988 8192000000 10733753376 11160772608 1775007536 17.808 97 21 42 2 1787488528 6392048 6088944
20:19:48 4917 8192000000 10722680224 11138125824 1792854976 17.955 98 45 90 1 1811737808 5897168 12985664
20:19:59 5961 8192000000 10730388064 11144683520 1793627360 17.962 99 23 46 0 1806111360 6148992 6335008
20:20:11 6343 8192000000 10733173696 11150307328 1785580416 17.895 98 34 68 1 1802607760 6149088 10878256
20:20:26 9053 8192000000 10733113168 11156258816 1804366960 18.050 99 17 34 0 1814932960 5654864 4911136
20:20:42 7088 8192000000 10736268960 11145400320 1780591824 17.854 98 26 52 0 1793694672 5964624 7138224
20:20:55 7186 8192000000 10721550368 11139518464 1747180448 17.578 96 28 56 2 1761434592 6057632 8196512
20:21:09 6333 8192000000 10713477136 11138633728 1773609456 17.797 98 30 60 2 1792816288 10791568 8415264
20:21:23 8360 8192000000 10701356160 11113783296 1713265680 17.296 95 20 40 2 1724276336 4989904 6020752
20:21:39 5532 8192000000 10714631792 11130331136 1786674064 17.904 99 41 82 2 1808792800 10251568 11867168
20:21:50 6096 8192000000 10697543408 11106971648 1771663888 17.781 99 30 60 3 1785953056 5237296 9051872
20:22:03 6587 8192000000 10733500864 11141574656 1802154544 18.032 100 26 53 3 1815497968 5445408 7898016
20:22:19 10415 8192000000 10723157856 11142860800 1764764000 17.724 97 24 47 3 1776986576 5062240 7160336
20:22:36 11273 8192000000 10740636464 11162918912 1823048000 18.203 100 30 60 0 1837856688 5213520 9595168
20:22:54 39280 8192000000 10736524784 11161608192 1797817136 17.996 98 30 59 1 1812709376 5158032 9734208
20:24:03 34326 8192000000 10752383440 11170947072 1815400864 18.140 99 29 59 1 1829160544 5360560 8399120
20:24:45 7367 8192000000 10747642432 11179642880 1838900608 18.332 100 26 51 1 1853003440 7006992 7095840
20:25:01 5501 8192000000 10759452928 11184345088 1842082496 18.358 100 29 59 0 1857117920 5715232 9320192
20:25:15 8166 8192000000 10764322496 11188928512 1846430688 18.393 100 26 52 0 1860283248 6477440 7375120
20:25:31 7482 8192000000 10764896976 11192295424 1851216496 18.432 100 29 57 1 1865255472 5469280 8569696
20:25:50 7386 8192000000 10783058048 11200286720 1854391232 18.458 100 25 49 4 1870354048 8763264 7199552
20:26:03 8843 8192000000 10767699072 11197116416 1853230096 18.448 100 19 38 1 1864630384 5544208 5856080
20:26:18 5594 8192000000 10771375280 11198390272 1855639056 18.468 100 23 46 0 1868077120 5178384 7259680
20:26:34 7508 8192000000 10767104272 11202899968 1857760320 18.485 100 15 29 0 1868354256 6209664 4384272
20:26:53 7873 8192000000 10779003088 11209097216 1861272592 18.514 100 19 35 2 1872477248 5604608 5600048
20:27:08 23333 8192000000 10803826704 11227848704 1880957952 18.673 100 15 30 1 1890196256 4808304 4430000
20:27:41 3447 8192000000 10834723040 11248050176 1901262448 18.836 100 54 106 3 1923382208 7200736 14919024
20:27:51 27506 8192000000 10840656352 11259355136 1908977248 18.898 100 59 118 1 1935021456 9335152 16709056
20:28:29 124264 8192000000 10838943200 11282157568 1920542224 18.991 100 43 86 0 1943213904 9334384 13337296
20:30:39 54679 8192000000 10860792848 11290947584 1931676576 19.080 100 31 62 0 1950011152 9093744 9240832
20:31:52 21272 8192000000 10875577312 11312349184 1945400880 19.190 100 48 96 0 1974568160 14754496 14412784
20:32:30 11722 8192000000 10886482640 11320516608 1951561456 19.239 100 43 86 2 1976839344 12594112 12683776
20:32:52 4490 8192000000 10914620416 11329429504 1961219648 19.316 100 65 130 1 1994117440 14175408 18722384
20:33:04 5709 8192000000 10908281296 11332673536 1963690336 19.335 100 54 109 0 1993344272 14486256 15167680
20:33:18 2396 8192000000 10930100784 11341361152 1976280832 19.435 100 83 166 0 2016901056 16611712 24008512
20:33:33 4972 8192000000 10939646288 11356172288 1985393312 19.507 100 85 170 2 2030336528 20335296 24607920
20:33:44 4054 8192000000 10935727024 11357388800 1981929888 19.480 100 72 144 1 2022960544 20237440 20793216
20:34:02 28044 8192000000 10934377392 11359264768 1979633424 19.462 100 68 136 1 2022066688 22689360 19743904
20:34:42 9003 8192000000 10926309616 11364438016 1982263712 19.483 100 53 105 1 2019158336 21846752 15047872
20:35:00 11135 8192000000 10927075024 11362877440 1983818352 19.495 100 46 91 3 2016514112 19612064 13083696
20:35:23 10421 8192000000 10923656496 11363876864 1969845680 19.384 99 43 85 1 2004308592 21422416 13040496
20:35:44 7494 8192000000 10930697184 11369263104 1988835952 19.535 100 52 102 2 2025728016 22046688 14845376
20:36:02 35721 8192000000 10935248992 11379724288 1991552496 19.556 100 45 90 1 2029193392 24336960 13303936
20:36:47 17640 8192000000 10942580080 11383959552 1995118848 19.584 100 41 82 2 2030484832 23062368 12303616
20:37:17 13283 8192000000 10943381568 11385286656 1998858448 19.614 100 42 84 2 2035243120 23815216 12569456
20:37:42 22922 8192000000 10939694688 11381645312 1976112320 19.434 99 49 98 3 2014827712 24512768 14202624
20:38:21 4666 8192000000 10952104144 11390480384 1999291792 19.617 100 44 88 0 2042381008 29609536 13479680
20:38:38 8042 8192000000 10955589312 11391922176 2000817408 19.629 100 51 102 0 2046786304 30102560 15866336
20:39:02 2364 8192000000 10982244848 11409477632 2013439216 19.729 100 75 150 1 2067588224 32392016 21756992
20:39:12 3494 8192000000 10990298112 11408363520 2012250448 19.719 100 81 159 2 2069085856 33129728 23705680
20:39:27 7289 8192000000 10971374304 11407036416 2007520032 19.682 100 59 117 0 2058020080 33307360 17192688
20:39:43 6592 8192000000 10976784688 11414482944 2018462816 19.768 100 51 102 2 2065839888 32249008 15128064
20:39:57 4868 8192000000 10975898384 11411845120 2013351344 19.728 100 57 114 0 2063587552 32703184 17533024
20:40:09 2670 8192000000 10982693040 11411386368 2001623968 19.636 99 77 154 3 2058141920 33109872 23408080
20:40:20 5133 8192000000 10987060016 11403386880 2004981696 19.662 100 70 138 0 2060689280 34846160 20861424
20:40:32 3673 8192000000 10959276928 11388780544 1990752336 19.550 99 64 126 2 2044968880 34937472 19279072
20:40:43 1252 8192000000 10988058496 11408162816 2012722800 19.723 100 76 151 1 2068974784 33912960 22339024
20:40:54 16378 8192000000 10962866768 11393482752 1990006544 19.544 99 57 114 0 2042274224 35023376 17244304
20:41:18 5737 8192000000 10947335648 11381760000 1969054176 19.378 98 54 107 0 2019957072 34780672 16122224
20:41:31 1722 8192000000 10950641264 11367288832 1978298672 19.451 99 75 148 0 2036007696 35147168 22561856
20:41:41 9010 8192000000 10935204576 11372089344 1976240496 19.435 99 56 111 1 2028540128 35352304 16947328
20:41:59 7769 8192000000 10968797536 11398176768 1999651856 19.620 100 62 123 2 2058133888 39307504 19174528
20:42:18 4831 8192000000 10970036272 11397586944 1983462784 19.492 99 66 130 2 2044574848 39839200 21272864
20:42:29 5308 8192000000 10978511296 11402178560 2000583456 19.627 100 66 132 0 2061732192 40219040 20929696
20:42:41 2640 8192000000 10999476256 11419459584 2013162176 19.726 100 81 162 1 2080809264 42711056 24936032
20:42:51 3268 8192000000 10992232160 11417419776 2010407584 19.705 100 75 150 0 2078175824 43618448 24149792
20:43:04 6448 8192000000 10998734160 11420954624 2013917744 19.732 100 70 140 1 2081256912 45397440 21941728
20:43:18 4924 8192000000 11004131344 11427807232 2020227536 19.782 100 71 140 3 2088593568 46051216 22314816
20:43:34 1859 8192000000 10999522272 11411542016 1992628624 19.565 99 78 156 1 2065335008 47218656 25487728
20:43:45 2257 8192000000 11016457088 11432632320 2021302256 19.790 100 90 180 1 2099270576 49429296 28539024
20:43:53 1293 8192000000 11008283296 11424137216 2014876256 19.740 100 83 165 0 2090935792 50641760 25417776
20:44:03 3484 8192000000 11000049984 11419033600 2007881632 19.685 100 84 168 2 2084934848 50952624 26100592
20:44:14 4077 8192000000 11021297728 11438567424 2018408576 19.768 100 82 161 0 2098498512 54179488 25910448
20:44:34 5331 8192000000 10991447008 11411607552 1998505232 19.611 99 67 134 0 2075696768 55282384 21909152
20:44:46 4339 8192000000 11017892400 11437371392 2021884800 19.795 100 75 149 1 2099132256 53922928 23324528
20:45:00 4033 8192000000 11009887264 11439689728 2021884688 19.795 100 70 140 1 2098576608 54062752 22629168
20:45:11 1164 8192000000 11016339520 11427864576 2011598592 19.714 100 87 172 0 2092549088 54354256 26596240
20:45:21 4214 8192000000 11020504976 11443208192 2016550720 19.753 100 77 154 0 2100786432 59877328 24358384
20:45:34 1919 8192000000 10997706880 11415158784 1991390688 19.555 99 83 166 3 2077903520 60488416 26024416
20:45:44 1517 8192000000 10996487696 11412758528 1983737696 19.494 99 89 178 0 2069696784 57859024 28100064
20:45:55 2462 8192000000 10997690256 11414552576 1995423120 19.587 100 87 171 2 2081306256 59127952 26755184
20:46:04 2880 8192000000 11013876560 11427713024 2005667632 19.667 100 87 175 0 2094445696 61066768 27711296
20:46:16 3988 8192000000 11004322896 11415965696 1991693712 19.557 99 85 170 0 2081619760 63093296 26832752
20:46:29 2989 8192000000 11021166288 11435016192 1999647152 19.620 99 90 180 1 2092481552 64281008 28553392
20:46:39 1633 8192000000 11031584976 11446099968 2017848704 19.763 100 88 175 0 2112152096 66230928 28072464
20:46:48 6121 8192000000 11007352688 11423465472 1981535760 19.477 98 87 171 1 2075383744 66545488 27302496
20:47:01 3308 8192000000 11021410832 11442020352 2009078624 19.694 100 82 163 2 2102865664 67904304 25882736
20:47:15 4853 8192000000 11036234048 11459268608 2021008160 19.788 100 74 148 3 2115098320 69033472 25056688
20:47:32 3476 8192000000 11013656784 11438010368 2000691040 19.628 99 66 132 0 2092380208 69414192 22274976
20:47:42 3502 8192000000 11019816976 11442262016 2007407376 19.681 100 72 145 1 2100573184 69548400 23617408
20:48:02 1847 8192000000 11014162720 11427323904 1984209936 19.498 99 78 156 0 2080860544 70396080 26254528
20:48:11 1823 8192000000 11027447488 11440500736 2000268800 19.625 99 95 189 3 2100208464 69954576 29985088
20:48:20 923 8192000000 11024706144 11439316992 2004376064 19.657 100 91 178 2 2103733232 70687664 28669504
20:48:28 2450 8192000000 10998486608 11422474240 1978204768 19.450 99 81 162 0 2074377760 69962096 26210896
20:48:39 5087 8192000000 11002757024 11421790208 1979681504 19.462 99 79 157 0 2071326944 66155776 25489664
20:48:54 4816 8192000000 10981674736 11409911808 1974200368 19.419 100 62 124 1 2068552512 73299264 21052880
20:49:05 9279 8192000000 10962571520 11401207808 1967801136 19.368 100 46 92 0 2047868912 63919728 16148048
20:49:23 8635 8192000000 10971484080 11410403328 1975942592 19.433 100 38 76 1 2056351776 67248800 13160384
20:49:44 5579 8192000000 10980218560 11413843968 1983643680 19.494 100 49 98 1 2062189200 62000864 16544656
20:49:58 6851 8192000000 10984395504 11417350144 1987078848 19.521 100 49 95 0 2063542928 60244416 16219664
20:50:16 13872 8192000000 10973945856 11422543872 1985500000 19.508 100 42 84 1 2062289184 62333440 14455744
20:50:51 11780 8192000000 10979431824 11413606400 1983183280 19.490 100 43 86 1 2060078928 62192000 14703648
20:51:10 19572 8192000000 10965792592 11407757312 1974791792 19.423 100 39 78 0 2053320208 64878848 13649568
20:51:43 20667 8192000000 10949073760 11401846784 1969920128 19.385 100 32 64 1 2037659040 56586656 11152256
20:52:15 13578 8192000000 10944319728 11395223552 1947658672 19.208 99 31 62 3 2016846176 57799232 11388272
20:52:40 22180 8192000000 10941048752 11389652992 1957244864 19.284 100 29 58 1 2027394016 59608160 10540992
20:53:28 25434 8192000000 10929042128 11378757632 1931797280 19.081 99 33 67 0 2000296768 56426768 12072720
20:54:04 12975 8192000000 10921891760 11379417088 1934227936 19.101 100 25 50 1 2003964720 60032304 9704480
20:54:36 47514 8192000000 10912434768 11376615424 1917677008 18.968 99 24 48 0 1986403024 59182480 9543536
20:55:31 24482 8192000000 10910036944 11375271936 1940036944 19.147 100 25 49 1 2000929600 51256656 9636000
20:56:21 54861 8192000000 10858017680 11328151552 1873102672 18.609 96 4 8 1 1887640512 12861088 1676752
20:57:24 57707 8192000000 10873781488 11321167872 1885054016 18.706 97 11 22 0 1896386000 8615824 2716160
20:58:31 2764 8192000000 10891065552 11325181952 1952073104 19.243 100 57 115 4 1975061536 6888672 16099760
20:58:46 16236 8192000000 10880258432 11329384448 1915587488 18.951 98 41 80 0 1936131888 9938112 10606288
20:59:17 83070 8192000000 10902451200 11367575552 1917515936 18.967 98 9 18 0 1932746304 12817888 2412480
21:00:46 49892 8192000000 10878457552 11338706944 1884255488 18.699 96 11 22 2 1902285424 15089152 2940784
21:01:51 41844 8192000000 10907025808 11357790208 1967457296 19.365 100 57 113 1 1994595520 10552864 16585360
21:02:46 72372 8192000000 10905852640 11348938752 1922668112 19.008 97 40 80 3 1947203312 13001296 11533904
21:04:13 99129 8192000000 10905117456 11377975296 1965198960 19.347 100 29 59 3 1998676544 24784416 8693168
21:05:59 91067 8192000000 10898676880 11379560448 1920804080 18.993 98 4 8 0 1945704944 24167392 733472
21:07:43 47613 8192000000 10883969344 11365441536 1950541504 19.231 100 9 18 0 1980279648 27501376 2236768
21:08:43 5003 8192000000 10892542144 11374546944 1959724816 19.304 100 5 10 0 1988135728 27094992 1315920
21:08:55 19809 8192000000 10889108848 11360043008 1963197280 19.331 100 12 24 0 1979465744 13109952 3158512
21:09:22 23189 8192000000 10896367088 11345907712 1952730832 19.248 99 27 54 1 1968495824 8772992 6992000
21:09:57 22321 8192000000 10888934112 11353202688 1965051040 19.346 100 20 40 2 1980740336 9840656 5848640
21:10:31 28178 8192000000 10891366960 11359784960 1973829104 19.416 100 27 54 0 1987861584 6330320 7702160
21:11:06 32814 8192000000 10905831936 11362758656 1976528672 19.437 100 16 32 1 1988075184 6315888 5230624
21:11:46 27161 8192000000 10912949568 11376017408 1982941648 19.488 100 10 20 0 1993019584 7133872 2944064
21:12:21 169958 8192000000 10907270080 11382775808 1975120800 19.426 99 21 42 1 1992324416 10924048 6279568
21:15:18 72348 8192000000 10898630864 11374292992 1948493168 19.214 98 16 32 0 1964857536 11920464 4443904
21:16:40 37421 8192000000 10898860272 11376140288 1978245232 19.451 100 12 24 1 1989576208 7928688 3402288
21:17:25 12003 8192000000 10908474880 11376734208 1987878816 19.527 100 21 41 1 2002064768 7527856 6658096
21:17:57 1866 8192000000 10943160304 11388129280 2000345952 19.625 100 59 118 1 2026164480 8374768 17443760
21:18:06 17555 8192000000 10914146848 11383189504 1975530688 19.429 99 27 54 1 1992723824 9694480 7498656
21:18:35 66223 8192000000 10893602416 11380367360 1954093040 19.259 98 21 42 0 1971743728 11262384 6388304
21:19:47 35625 8192000000 10891501552 11367501824 1939478512 19.143 98 18 34 0 1957664528 13034928 5151088
21:20:55 38702 8192000000 10885588768 11362340864 1941670368 19.160 98 27 54 1 1964553488 15174128 7708992
21:21:42 81285 8192000000 10875748560 11343118336 1884318128 18.700 96 11 21 1 1902397216 14630928 3448160
21:23:28 59202 8192000000 10880310352 11379068928 1960831248 19.313 100 15 30 0 1984905424 19610336 4463840
21:24:35 73307 8192000000 10898277472 11362652160 1930722832 19.073 98 12 24 0 1945305232 11293072 3289328
21:25:55 31269 8192000000 10926056080 11378913280 1983093360 19.489 100 38 75 2 2002492752 8841504 10557888
21:26:32 50225 8192000000 10899510768 11367698432 1941233200 19.157 98 37 74 0 1962193328 11289568 9670560
21:27:33 36639 8192000000 10907846400 11358384128 1904470320 18.862 96 30 60 1 1920552672 8471648 7610704
21:28:18 105625 8192000000 10894154592 11377602560 1942396432 19.166 98 24 48 2 1960657184 11662224 6598528
21:30:10 96520 8192000000 10923973792 11369570304 1917738144 18.969 96 26 52 1 1937330032 12291088 7300800
21:31:53 26577 8192000000 10901212752 11359584256 1918540000 18.975 97 44 88 0 1942423904 11344848 12539056
21:32:34 97378 8192000000 10915862448 11382947840 1921141712 18.996 97 27 54 3 1941387808 13065136 7180960
21:34:22 97480 8192000000 10890126304 11357167616 1841535376 18.353 93 16 32 0 1855395712 9776320 4084016
21:36:07 63085 8192000000 10888023488 11352420352 1930635312 19.072 98 29 58 0 1950124960 11650704 7838944
21:37:16 104901 8192000000 10927907808 11370483712 1936192192 19.116 98 27 54 0 1950631664 7156656 7282816
21:39:32 65185 8192000000 10865641760 11327709184 1830968784 18.267 93 28 56 0 1854266192 14678704 8618704
21:41:02 11727 8192000000 10873711456 11337437184 1942275856 19.165 100 29 58 0 1960769392 10659824 7833712
21:41:21 9606 8192000000 10852613888 11324440576 1937030752 19.123 100 17 34 3 1948578448 6982416 4565280
21:41:40 19398 8192000000 10852717280 11328430080 1935897216 19.114 99 36 73 0 1954397360 7695200 10804944
21:42:07 61737 8192000000 10844216512 11314737152 1864543184 18.540 96 16 32 1 1876663888 7772896 4347808
21:43:20 42036 8192000000 10841598864 11312177152 1884853488 18.704 98 19 35 1 1902361088 12778016 4729584
21:44:15 45736 8192000000 10829804912 11298312192 1863673280 18.533 97 13 26 1 1880490224 12825120 3991824
21:45:09 45005 8192000000 10857180368 11315691520 1919866160 18.986 100 13 26 2 1935220432 11823280 3530992
21:46:22 38295 8192000000 10851217488 11320971264 1906316320 18.877 99 10 20 0 1919865440 10720944 2828176
21:47:09 52276 8192000000 10854080672 11335569408 1915472816 18.951 99 6 12 0 1928080512 10981936 1625760
21:48:15 35855 8192000000 10856167936 11319730176 1910883712 18.914 99 23 46 0 1927280032 9808800 6587520
21:49:00 50755 8192000000 10877960720 11347386368 1938885808 19.138 100 19 37 0 1952490928 8351392 5253728
21:49:57 37853 8192000000 10881976384 11344420864 1935809056 19.113 99 17 34 0 1948808816 8274224 4725536
21:50:48 38730 8192000000 10867584128 11345678336 1920021216 18.987 98 34 68 0 1942386288 12643504 9721568
21:51:40 45788 8192000000 10859359680 11334537216 1892128944 18.763 97 22 44 1 1908270176 9773200 6368032
21:52:32 42237 8192000000 10883466032 11350564864 1942577360 19.167 100 17 34 1 1956590208 9030256 4982592
21:53:20 47268 8192000000 10886793280 11347324928 1931256448 19.077 99 15 30 0 1947391872 11475040 4660384
21:54:15 32554 8192000000 10897773488 11355553792 1917606896 18.968 98 23 46 1 1933619328 9868768 6143664
21:54:56 30100 8192000000 10896335440 11363745792 1949857024 19.225 100 23 46 0 1974426992 18020640 6549328
21:55:32 65687 8192000000 10898953952 11374374912 1939717328 19.145 99 13 26 0 1974595520 30989648 3888544
21:56:44 77889 8192000000 10866750208 11338387456 1852181520 18.440 95 14 28 2 1878103648 21695152 4226976
21:58:13 83944 8192000000 10895809904 11356921856 1926075136 19.035 98 26 52 0 1941717280 8904384 6737760
21:59:43 111248 8192000000 10891178288 11348160512 1944989840 19.187 99 28 57 1 1959969136 6778512 8200784
22:01:42 22054 8192000000 10892158096 11341881344 1930191056 19.068 98 49 97 2 1951328208 7506912 13630240
22:02:11 32550 8192000000 10899027856 11353059328 1954899408 19.265 100 45 90 1 1978339392 11071152 12368832
22:02:57 63211 8192000000 10871467072 11351773184 1952209184 19.244 100 18 36 0 1968407168 11042496 5155488
22:04:06 50698 8192000000 10881363664 11358089216 1950194784 19.228 99 12 24 1 1966333376 13187312 2951280
22:05:03 63853 8192000000 10896286528 11370627072 1959317872 19.301 100 10 18 2 1979198896 16934576 2946448
22:06:22 27001 8192000000 10908096448 11378434048 1964967584 19.346 99 24 48 1 1984258896 11747680 7543632
22:06:58 34842 8192000000 10896810928 11374346240 1950779408 19.233 99 28 56 1 1979245728 20419216 8047104
22:07:48 37277 8192000000 10898119824 11364896768 1939451264 19.142 98 51 103 1 1969544112 14195760 15897088
22:08:33 87577 8192000000 10887306800 11374731264 1935913616 19.114 99 14 28 1 1963889040 23690352 4285072
22:10:09 98383 8192000000 10893522816 11345719296 1893761664 18.776 97 17 34 0 1922269936 23245744 5262528
22:11:56 102710 8192000000 10877715920 11349897216 1872691696 18.606 96 7 14 0 1887073952 12456112 1926144
22:13:45 48266 8192000000 10886270944 11364356096 1956065648 19.275 100 30 60 0 1975948592 11201056 8681888
22:14:43 55055 8192000000 10900192864 11366096896 1946819760 19.201 99 33 65 0 1965424224 9313296 9291168
22:15:50 63907 8192000000 10905796656 11371692032 1925573776 19.031 98 16 32 0 1939078848 9560496 3944576
22:17:28 144604 8192000000 10889178880 11370475520 1930483360 19.071 98 11 22 1 1947590528 14147344 2959824
22:20:15 52113 8192000000 10880218064 11345481728 1887951136 18.729 96 23 46 0 1900143600 6207344 5985120
22:21:14 32584 8192000000 10860273664 11320123392 1877301248 18.643 96 34 68 0 1893535728 6970432 9264048
22:21:52 42887 8192000000 10832839424 11313999872 1890258416 18.748 98 8 16 0 1899063200 6562240 2242544
22:22:42 40654 8192000000 10819800304 11295559680 1853482768 18.450 96 12 24 0 1864338672 7703536 3152368
22:25:03 59645 8192000000 10863809360 11354374144 1921976656 19.003 99 8 16 0 1935542032 11500512 2064864
22:26:09 57343 8192000000 10857376896 11341438976 1909094288 18.899 98 13 26 0 1924719056 11573296 4051472

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 28-02-2021 22:29:45 to 28-02-2021 22:30:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 171 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-02-2021 22:30:18 to 28-02-2021 22:30:20.

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          239572
MON$OLDEST_ACTIVE               243535
MON$OLDEST_SNAPSHOT             243535
MON$NEXT_TRANSACTION            243535
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                       2033696
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:456: 
:457: mscs-test-161.budzdorov.ru    Sun Feb 28 22:27:28 2021
:458:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:459: 
:460: 
:461: mscs-test-161.budzdorov.ru    Sun Feb 28 22:27:30 2021
:462:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:463: 
:464: 
:465: mscs-test-161.budzdorov.ru    Sun Feb 28 22:27:42 2021
:466:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:467: 
--- end of diff output ---

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

28.02.21 22:30:21. 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-28 22:30:23 No severe PSQL-related problems occured
28.02.21 22:30:25. End of report.