Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 25.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 17515512 kB
MemAvailable 31464008 kB
Buffers 0 kB
Cached 14170408 kB
SwapCached 3304 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-25 01:27:02
DTS_END                         2020-11-25 01:27:02.3820
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44028
TRN_ID                          246209
ATT_ID                          703
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: 9200.04 19918 1104005
customer order: creation 179.90 338 21588
customer order: refuse 15.80 334 1896
order to supplier: creation 47.09 1277 5651
order to supplier: removal 3.46 103195 415
invoice (draft): creation 46.98 3307 5637
invoice (draft): removal 50.77 816 6092
invoice accept: apply 43.56 17173 5227
invoice accept: cancel 46.23 813 5547
customer reserve: creation 3945.90 172 473508
customer reserve: removal 4514.73 63 541767
realization accept: apply 88.03 169 10564
realization accept: cancel 81.25 103 9750
payment from customer: creation 63.06 99 7567
payment from customer: removal 6.14 80 737
payment to supplier: creation 50.33 124 6040
payment to supplier: removal 3.86 67 463
service: total inventory turnovers 5.58 1117 669
service: total monetary turnovers 6.37 28 764
service: aggregate perf. data 0.99 15691 119
service: refresh index statistics 0.03 253398 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 25-11-2020 01:27:48 to 25-11-2020 01:27:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6550
TEST_TIME 2 4442
TEST_TIME 3 4574
TEST_TIME 4 4712
TEST_TIME 5 4526
TEST_TIME 6 4688
TEST_TIME 7 4554
TEST_TIME 8 4697
TEST_TIME 9 5456
TEST_TIME 10 5569
TEST_TIME 11 5998
TEST_TIME 12 6213
TEST_TIME 13 6356
TEST_TIME 14 6362
TEST_TIME 15 6349
TEST_TIME 16 6599
TEST_TIME 17 6754
TEST_TIME 18 7334
TEST_TIME 19 7399
TEST_TIME 20 8231
TEST_TIME 21 8411
TEST_TIME 22 8794
TEST_TIME 23 8935
TEST_TIME 24 9226
TEST_TIME 25 9296
TEST_TIME 26 9626
TEST_TIME 27 10834
TEST_TIME 28 10750
TEST_TIME 29 10803
TEST_TIME 30 10637
TEST_TIME 31 10553
TEST_TIME 32 10562
TEST_TIME 33 10264
TEST_TIME 34 10177
TEST_TIME 35 10189
TEST_TIME 36 10045
TEST_TIME 37 9972
TEST_TIME 38 9825
TEST_TIME 39 9637
TEST_TIME 40 9583
TEST_TIME 41 9564
TEST_TIME 42 9437
TEST_TIME 43 9409
TEST_TIME 44 9664
TEST_TIME 45 9617
TEST_TIME 46 9485
TEST_TIME 47 9369
TEST_TIME 48 9321
TEST_TIME 49 9329
TEST_TIME 50 9255
TEST_TIME 51 9202
TEST_TIME 52 9199
TEST_TIME 53 9130
TEST_TIME 54 9073
TEST_TIME 55 9051
TEST_TIME 56 8936
TEST_TIME 57 8986
TEST_TIME 58 8995
TEST_TIME 59 8951
TEST_TIME 60 8987
TEST_TIME 61 9030
TEST_TIME 62 9129
TEST_TIME 63 9139
TEST_TIME 64 9171
TEST_TIME 65 9174
TEST_TIME 66 9196
TEST_TIME 67 9230
TEST_TIME 68 9375
TEST_TIME 69 9370
TEST_TIME 70 9393
TEST_TIME 71 9379
TEST_TIME 72 9389
TEST_TIME 73 9277
TEST_TIME 74 9227
TEST_TIME 75 9274
TEST_TIME 76 9220
TEST_TIME 77 9242
TEST_TIME 78 9188
TEST_TIME 79 9157
TEST_TIME 80 9168
TEST_TIME 81 9100
TEST_TIME 82 9057
TEST_TIME 83 9031
TEST_TIME 84 9021
TEST_TIME 85 8999
TEST_TIME 86 9013
TEST_TIME 87 8981
TEST_TIME 88 8983
TEST_TIME 89 9098
TEST_TIME 90 9075
TEST_TIME 91 9063
TEST_TIME 92 9147
TEST_TIME 93 9157
TEST_TIME 94 9145
TEST_TIME 95 9237
TEST_TIME 96 9261
TEST_TIME 97 9260
TEST_TIME 98 9237
TEST_TIME 99 9257
TEST_TIME 100 9267
TEST_TIME 101 9229
TEST_TIME 102 9214
TEST_TIME 103 9180
TEST_TIME 104 9188
TEST_TIME 105 9165
TEST_TIME 106 9146
TEST_TIME 107 9103
TEST_TIME 108 9098
TEST_TIME 109 9080
TEST_TIME 110 9050
TEST_TIME 111 9097
TEST_TIME 112 9098
TEST_TIME 113 9152
TEST_TIME 114 9125
TEST_TIME 115 9185
TEST_TIME 116 9208
TEST_TIME 117 9172
TEST_TIME 118 9233
TEST_TIME 119 9277
TEST_TIME 120 9200

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-11-2020 01:27:52 to 25-11-2020 01:27:55.

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 1542453 1542453 0 0.00 0 17347 6 0 0
doc_list_biud 1542453 1542453 0 0.00 0 56946 28 0 0
sp_add_invoice_to_stock 5371 5227 144 2.68 19 173616 17173 0 144
sp_cancel_adding_invoice 5547 5547 0 0.00 5 68290 814 0 0
sp_cancel_client_order 1896 1896 0 0.00 4 8850 334 0 0
sp_cancel_customer_reserve 541767 541767 0 0.00 1 41723 63 0 0
sp_cancel_pay_from_customer 737 737 0 0.00 3 6692 81 0 0
sp_cancel_pay_to_supplier 463 463 0 0.00 3 2221 68 0 0
sp_cancel_supplier_invoice 6107 6092 15 0.24 2 13792 816 0 15
sp_cancel_supplier_order 415 415 0 0.00 6 1285911 103195 0 0
sp_cancel_write_off 9750 9750 0 0.00 1 17397 103 0 0
sp_client_order 21588 21588 0 0.00 3 28133 339 0 0
sp_customer_reserve 473508 473508 0 0.00 0 71504 172 0 0
sp_fill_shopping_cart 32854 32854 0 0.00 1 12058 42 0 0
sp_fill_shopping_cart_clo_res 473507 473507 0 0.00 0 49714 15 0 0
sp_get_clo_for_invoice 5226 5226 0 0.00 0 55822 356 0 0
sp_kill_cost_storno 16497 16497 0 0.00 0 14361 55 0 0
sp_kill_qstorno_ret_qs2qd 1099791 1099791 0 0.00 0 41666 34 0 0
sp_kill_qty_storno 581257 581257 0 0.00 0 56946 73 0 0
sp_lock_selected_doc 21895 21895 0 0.00 0 8912 4 0 0
sp_make_cost_storno 29397 29397 0 0.00 0 13667 51 0 0
sp_multiply_rows_for_pdistr 29397 29397 0 0.00 0 10189 25 0 0
sp_multiply_rows_for_qdistr 21588 21588 0 0.00 0 9961 148 0 0
sp_pay_from_customer 7567 7567 0 0.00 4 7715 99 0 0
sp_pay_to_supplier 6040 6040 0 0.00 4 11817 124 0 0
sp_payment_common 13607 13607 0 0.00 1 7276 28 0 0
sp_qd_handle_on_cancel_clo 1896 1896 0 0.00 0 8843 314 0 0
sp_qd_handle_on_invoice_upd_sts 10773 10773 0 0.00 0 56944 315 0 0
sp_qd_handle_on_reserve_upd_sts 10564 10564 0 0.00 0 15529 59 0 0
sp_reserve_write_off 10564 10564 0 0.00 6 15574 169 0 0
sp_supplier_invoice 5637 5637 0 0.00 6 89827 3308 0 0
sp_supplier_order 5651 5651 0 0.00 5 42009 1277 0 0
srv_aggregate_perf_data 120 119 1 0.83 2858 163107 15692 0 1
srv_fill_mon_cache_memory 165 165 0 0.00 795 145155 32146 0 0
srv_find_qd_qs_mism 1054462 1054462 0 0.00 0 17344 5 0 0
srv_make_invnt_saldo 669 669 0 0.00 29 124031 1117 0 0
srv_make_money_saldo 764 764 0 0.00 1 1740 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 136560 414411 253399 0 0
t$perf-abend:sp_add_invoice_to_stock 144 144 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 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 5227 5227 0 0.00 0 7147 150 0 0
t$perf-norm:sp_cancel_adding_invoice 427 427 0 0.00 0 5261 82 0 0
t$perf-norm:sp_cancel_client_order 1896 1896 0 0.00 0 7158 15 0 0
t$perf-norm:sp_cancel_customer_reserve 694 694 0 0.00 0 1419 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 737 737 0 0.00 0 3122 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 463 463 0 0.00 0 1190 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 411 411 0 0.00 0 4623 19 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 18816 1441 0 0
t$perf-norm:sp_cancel_write_off 1062 1062 0 0.00 0 7852 14 0 0
t$perf-norm:sp_client_order 21588 21588 0 0.00 0 10929 19 0 0
t$perf-norm:sp_customer_reserve 1066 1066 0 0.00 0 4586 9 0 0
t$perf-norm:sp_pay_from_customer 7567 7567 0 0.00 0 5098 9 0 0
t$perf-norm:sp_pay_to_supplier 6040 6040 0 0.00 0 11651 12 0 0
t$perf-norm:sp_reserve_write_off 10564 10564 0 0.00 0 9803 11 0 0
t$perf-norm:sp_supplier_invoice 5637 5637 0 0.00 0 6193 18 0 0
t$perf-norm:sp_supplier_order 5651 5651 0 0.00 0 6895 16 0 0
t$perf-norm:srv_aggregate_perf_data 119 119 0 0.00 0 1290 19 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 280 3 0 0
t$perf-norm:srv_make_invnt_saldo 669 669 0 0.00 0 950 18 0 0
t$perf-norm:srv_make_money_saldo 764 764 0 0.00 0 1407 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 67 18 0 0
v_add_invoice_to_stock 10740 10452 288 2.68 0 3900 20 0 288
v_all_customers 38942 38942 0 0.00 0 16 1 0 0
v_all_suppliers 30966 30966 0 0.00 0 18 1 0 0
v_all_wares 43176 43176 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 854 854 0 0.00 0 1754 11 0 0
v_cancel_client_order 3792 3792 0 0.00 0 3882 4 0 0
v_cancel_customer_prepayment 1474 1474 0 0.00 0 3182 11 0 0
v_cancel_customer_reserve 1388 1388 0 0.00 0 1696 4 0 0
v_cancel_payment_to_supplier 926 926 0 0.00 0 2214 9 0 0
v_cancel_supplier_invoice 852 822 30 3.52 0 858 16 0 30
v_cancel_supplier_order 830 830 0 0.00 0 2680 8 0 0
v_cancel_write_off 2124 2124 0 0.00 0 3967 13 0 0
v_max_id_clo_ord 5651 5651 0 0.00 0 3814 2 0 0
v_max_id_clo_res 1066 1066 0 0.00 0 1925 15 0 0
v_max_id_ord_sup 5615 5615 0 0.00 0 4863 4 0 0
v_max_non_paid_invoice 1823 1823 0 0.00 0 708 4 0 0
v_max_non_paid_realizn 4265 4265 0 0.00 0 3590 5 0 0
v_min_id_clo_ord 5651 5651 0 0.00 0 4707 6 0 0
v_min_id_clo_res 1066 1066 0 0.00 0 13556 25 0 0
v_min_id_ord_sup 5615 5615 0 0.00 0 5629 7 0 0
v_min_non_paid_invoice 6040 6040 0 0.00 0 5242 17 0 0
v_min_non_paid_realizn 7567 7567 0 0.00 0 4852 15 0 0
v_our_firm 10838 10838 0 0.00 0 12 1 0 0
v_reserve_write_off 21128 21128 0 0.00 0 5097 8 0 0
x_lock_depdocs_on_canc_invoice 11228 11228 0 0.00 0 35783 125 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 4609 301 0 0
x_make_qstorno_1000_1200 5651 5651 0 0.00 2 41959 1186 0 0
x_make_qstorno_1200_2000 5637 5637 0 0.00 2 89425 3159 0 0
x_make_qstorno_2100_3300 473508 473508 0 0.00 0 71502 155 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 25-11-2020 01:27:56 to 25-11-2020 01:28:01.

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:06 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:12 10218 8192000000 10209564544 10509611008 854006624 9.440 68 58 118 0 876823200 2423088 20393488
22:57:31 26318 8192000000 10339441024 10655842304 1365716448 14.289 100 84 169 0 1396136896 4189968 26230480
22:58:13 27354 8192000000 10379897696 10699091968 1426272896 14.828 100 88 176 1 1461815072 6683296 28858880
22:58:51 28607 8192000000 10392348704 10716090368 1450379792 15.041 100 95 190 0 1489266688 7576048 31310848
22:59:30 27888 8192000000 10413172912 10741907456 1464694048 15.167 100 87 174 0 1501363456 8584032 28085376
23:00:06 22449 8192000000 10432469152 10766352384 1490126896 15.390 100 87 174 1 1527560368 9171568 28261904
23:00:41 19387 8192000000 10455666240 10795331584 1507409696 15.541 100 80 160 0 1543323008 9838768 26074544
23:01:09 18514 8192000000 10494811248 10842759168 1545083904 15.868 100 80 159 1 1580373392 10084656 25204832
23:01:43 16866 8192000000 10519841616 10875920384 1585917440 16.219 100 76 152 0 1620250224 10678208 23654576
23:02:10 10726 8192000000 10554240960 10908962816 1606271680 16.393 100 78 156 0 1640907952 10679696 23956576
23:02:34 12119 8192000000 10568445136 10930012160 1628855520 16.585 100 78 156 1 1663286128 11565520 22865088
23:02:59 12005 8192000000 10607019728 10968084480 1657458656 16.827 100 83 166 2 1694948096 12925216 24564224
23:03:18 10326 8192000000 10620249328 10983014400 1671014256 16.942 100 88 175 0 1710706064 13599152 26092656
23:03:35 9817 8192000000 10623242176 10993410048 1687367120 17.079 100 82 163 0 1724132928 13143664 23622144
23:03:53 10098 8192000000 10636457536 11003658240 1699186912 17.178 100 82 164 0 1737020832 13252784 24581136
23:04:10 10606 8192000000 10656948128 11023880192 1709542640 17.265 100 84 168 0 1747671968 13362752 24766576
23:04:29 6922 8192000000 10674085712 11051769856 1731704288 17.450 100 78 158 0 1767180752 12749312 22727152
23:04:43 6830 8192000000 10679264720 11059191808 1750348128 17.604 100 79 157 1 1785226464 12064944 22813392
23:04:59 4344 8192000000 10696986160 11075252224 1760183440 17.686 100 86 172 2 1797207600 12928448 24095712
23:05:12 3505 8192000000 10707296832 11090010112 1771500192 17.779 100 84 169 0 1808484528 12999488 23984848
23:05:23 4713 8192000000 10709822384 11093524480 1778022224 17.833 100 79 160 0 1813345440 13218448 22104768
23:05:36 4544 8192000000 10726171648 11104092160 1783552368 17.879 100 78 154 2 1818073808 12898640 21622800
23:05:48 2328 8192000000 10732861280 11115745280 1791289632 17.942 100 87 175 2 1828357168 12758976 24308560
23:05:56 3193 8192000000 10747491536 11128545280 1806415264 18.067 100 89 178 0 1844805264 13282112 25107888
23:06:07 2699 8192000000 10752006352 11136139264 1813211440 18.122 100 84 167 1 1849641520 12946064 23484016
23:06:16 2415 8192000000 10760591760 11140632576 1817927296 18.161 100 86 171 0 1855237264 13221520 24088448
23:06:25 2257 8192000000 10764577440 11148513280 1822981264 18.202 100 84 168 0 1861316208 14427440 23907504
23:06:34 10308 8192000000 10765822736 11151949824 1821985376 18.194 100 80 158 1 1858001392 13628144 22387872
23:06:51 4089 8192000000 10774597488 11158093824 1826603056 18.232 100 87 172 2 1865647536 14587664 24456816
23:07:02 2457 8192000000 10781348544 11167260672 1838613808 18.330 100 94 187 0 1878886688 14579072 25693808
23:07:11 1411 8192000000 10788719248 11173937152 1843503200 18.369 100 91 180 0 1883149440 14355808 25290432
23:07:19 1483 8192000000 10787919120 11176550400 1849353856 18.417 100 91 181 0 1889000944 14713760 24933328
23:07:27 2236 8192000000 10794220064 11179679744 1852525824 18.443 100 86 172 0 1890126576 12547424 25053328
23:07:35 1899 8192000000 10793847696 11180052480 1857103136 18.480 100 96 193 1 1897136192 12980816 27052240
23:07:44 1394 8192000000 10805011536 11192344576 1860794896 18.510 100 93 186 1 1898769632 12298336 25676400
23:07:52 2195 8192000000 10810965968 11196780544 1863089536 18.528 100 88 175 1 1900143344 12668160 24385648
23:08:00 1580 8192000000 10811315360 11200917504 1868781312 18.574 100 92 182 1 1907139760 12755488 25602960
23:08:08 1561 8192000000 10814293520 11201351680 1868543856 18.572 100 91 179 1 1905646128 13129440 23972832
23:08:16 24345 8192000000 10778980752 11197890560 1865960976 18.552 100 58 116 0 1894555232 12364208 16230048
23:09:08 1579 8192000000 10811065680 11209498624 1877770816 18.647 100 77 155 1 1910162176 9999648 22391712
23:09:15 9176 8192000000 10802611008 11208384512 1873767280 18.615 100 60 120 1 1901094192 11137392 16189520
23:09:31 11573 8192000000 10777225968 11208859648 1871653584 18.598 100 38 76 2 1892502400 9852432 10996384
23:09:52 5738 8192000000 10803737472 11215781888 1876607504 18.638 100 43 87 1 1895844320 7523648 11713168
23:10:05 2764 8192000000 10795347040 11216355328 1879253440 18.659 100 35 70 0 1896254368 7528208 9472720
23:10:14 3366 8192000000 10788130880 11215024128 1878174544 18.650 100 40 80 1 1897913056 8587216 11151296
23:10:27 4046 8192000000 10783413840 11214516224 1879391904 18.660 100 29 59 2 1893396512 5648688 8355920
23:10:37 5211 8192000000 10791014944 11215101952 1876063120 18.633 100 21 42 1 1888438800 6206624 6169056
23:10:50 11192 8192000000 10788998816 11214786560 1876516064 18.637 100 16 32 2 1886538176 5670720 4351392
23:11:10 7443 8192000000 10784220304 11219505152 1880125472 18.666 100 19 38 2 1892183728 6879344 5178912
23:11:28 14759 8192000000 10786152544 11219517440 1879737040 18.663 100 9 18 1 1887719056 5512352 2469664
23:11:49 19683 8192000000 10782631680 11222278144 1881133472 18.674 100 14 28 0 1890801488 5748048 3919968
23:12:19 5964 8192000000 10802894304 11230343168 1893489760 18.774 100 38 77 1 1911092416 7170048 10432608
23:12:31 11099 8192000000 10800466128 11231379456 1890219920 18.748 100 24 49 1 1903912336 6939696 6752720
23:12:49 6469 8192000000 10789735152 11225919488 1887041264 18.722 100 25 50 1 1900560416 6370928 7148224
23:13:02 10325 8192000000 10799946816 11231010816 1889966000 18.746 100 29 58 0 1908291888 9720464 8605424
23:13:18 55955 8192000000 10825820960 11246178304 1897407488 18.805 100 29 57 1 1910669584 5069376 8192720
23:14:22 30920 8192000000 10819842912 11254218752 1901534384 18.839 100 19 38 1 1912692848 5775040 5383424
23:15:03 7189 8192000000 10814544752 11247677440 1885084704 18.706 99 28 56 1 1899219008 5662816 8471488
23:15:16 5248 8192000000 10814241264 11244396544 1896112432 18.795 100 34 65 2 1912174336 6252160 9809744
23:15:31 3735 8192000000 10809787872 11247128576 1897123584 18.803 100 19 38 0 1908851536 6391408 5336544
23:15:42 6128 8192000000 10825515776 11253833728 1902381664 18.845 100 31 62 2 1916233136 5103072 8748400
23:15:55 3237 8192000000 10822047152 11251122176 1888060896 18.730 99 43 86 2 1912235280 11869872 12304512
23:16:04 7097 8192000000 10805192000 11245531136 1899197616 18.820 100 29 58 0 1914565200 6757744 8609840
23:16:18 7316 8192000000 10815730320 11250683904 1901853680 18.841 100 30 60 1 1915844096 5523504 8466912
23:16:32 10674 8192000000 10810770544 11245355008 1881534560 18.677 99 28 55 2 1895736896 5624096 8578240
23:16:51 7362 8192000000 10803354288 11236577280 1885678720 18.711 100 18 36 0 1896856384 5600224 5577440
23:17:06 9107 8192000000 10774506160 11202682880 1836034480 18.309 97 29 59 3 1849602016 5202928 8364608
23:17:21 10078 8192000000 10764490672 11190190080 1764524192 17.722 94 22 40 3 1776535200 5694672 6316336
23:17:37 10505 8192000000 10746561360 11172528128 1785816912 17.897 96 21 42 2 1802101632 9906624 6378096
23:17:54 18288 8192000000 10756084160 11191463936 1818736512 18.167 98 33 65 1 1833556784 5640400 9179872
23:18:55 25915 8192000000 10716190480 11139051520 1652461616 16.785 89 10 19 1 1659736112 4681184 2593312
23:19:27 10913 8192000000 10717188384 11133206528 1765832096 17.733 98 30 60 1 1780940720 7122496 7986128
23:19:44 7363 8192000000 10732658496 11146399744 1771560560 17.780 98 26 52 1 1785501696 6305808 7635328
23:19:57 7467 8192000000 10725864688 11130445824 1770385632 17.770 97 38 72 1 1785920624 5329776 10205216
23:20:11 8604 8192000000 10728678512 11133079552 1754261552 17.637 97 25 50 4 1767796480 5253664 8281264
23:20:26 7046 8192000000 10711677280 11121434624 1774224960 17.802 98 32 65 1 1790144576 6842416 9077200
23:20:40 7761 8192000000 10705367808 11122114560 1776011024 17.817 99 39 77 3 1793640656 6442240 11187392
23:20:56 9017 8192000000 10708903840 11132919808 1797558912 17.994 100 17 34 1 1807877088 5375744 4942432
23:21:12 5777 8192000000 10681016320 11092746240 1709591328 17.265 95 32 64 2 1724608416 5387728 9629360
23:21:24 9271 8192000000 10696503152 11111641088 1756069520 17.652 98 22 44 0 1769773744 5893968 7810256
23:21:39 12182 8192000000 10716472592 11132727296 1780903760 17.857 99 17 35 1 1791153440 5081520 5168160
23:22:00 13180 8192000000 10700053760 11123703808 1738135984 17.503 96 20 40 0 1749476624 5181664 6158976
23:22:20 12223 8192000000 10735355344 11150864384 1788078576 17.916 99 14 28 1 1801959744 9987312 3893856
23:22:41 67427 8192000000 10757242640 11178160128 1827536208 18.239 100 30 60 1 1841781552 5503024 8742320
23:23:57 17481 8192000000 10743337760 11169349632 1833830384 18.291 100 15 30 2 1843960752 5418032 4712336
23:24:21 6436 8192000000 10772472624 11186409472 1842559920 18.362 100 44 88 2 1861719024 6898800 12260304
23:24:36 6048 8192000000 10784082128 11198574592 1855054736 18.463 100 40 78 1 1873084064 6461600 11567728
23:24:49 6452 8192000000 10785357152 11202547712 1856803888 18.477 100 34 68 0 1873839936 7225968 9810080
23:25:03 7086 8192000000 10785661024 11205615616 1861627152 18.516 100 29 58 0 1876386512 6155424 8603936
23:25:18 7405 8192000000 10786019248 11207581696 1868368208 18.571 100 27 54 1 1882578496 5897216 8313072
23:25:31 7268 8192000000 10800143728 11218546688 1868337808 18.571 100 27 54 0 1886267424 9432400 8497216
23:25:45 6419 8192000000 10782667824 11215405056 1868222496 18.570 100 15 30 1 1878186032 5538288 4425248
23:26:04 8195 8192000000 10784858560 11218956288 1872859104 18.607 100 21 42 0 1884649952 5482064 6308784
23:26:18 14815 8192000000 10784475920 11221225472 1874704816 18.622 100 23 46 3 1887291680 5525040 7061824
23:26:42 14289 8192000000 10795759952 11227897856 1879822304 18.664 100 21 42 1 1891635328 5764880 6048144
23:27:08 1872 8192000000 10842738944 11244396544 1900829984 18.833 100 63 126 1 1924607760 4746800 19030976
23:27:16 3415 8192000000 10840560272 11258626048 1906848160 18.881 100 52 101 3 1927752784 5979568 14925056
23:27:27 120902 8192000000 10847063280 11279015936 1913292032 18.933 100 21 41 0 1923449552 4341456 5816064
23:29:35 21815 8192000000 10877831200 11298422784 1934441280 19.102 100 40 79 0 1955273152 10134752 10697120
23:30:08 18498 8192000000 10864045472 11288539136 1925303680 19.029 99 44 88 1 1952633216 15190880 12138656
23:30:40 18123 8192000000 10882156832 11312017408 1950522528 19.231 100 65 130 2 1983594112 14012032 19059552
23:31:06 12048 8192000000 10891124544 11316662272 1953091616 19.251 100 59 117 4 1983607392 13598272 16917504
23:32:05 17279 8192000000 10887700464 11322241024 1958539760 19.294 100 38 76 0 1981897632 12488160 10869712
23:32:31 19675 8192000000 10898535328 11329134592 1969432960 19.381 100 63 125 1 2002716160 13674160 19609040
23:33:05 20908 8192000000 10903445664 11343245312 1971495408 19.397 100 40 77 1 1996760272 13924336 11340528
23:33:39 15187 8192000000 10910262272 11349438464 1977689056 19.446 100 37 74 0 2005183184 16058528 11435600
23:34:07 9844 8192000000 10922928544 11356004352 1981760176 19.479 100 40 80 3 2009821104 15964416 12096512
23:34:30 9309 8192000000 10931636176 11360665600 1987362656 19.523 100 50 100 0 2020941568 18203056 15375856
23:34:47 9312 8192000000 10940205616 11371380736 1995211776 19.585 100 64 126 3 2031765808 18138544 18415488
23:35:08 6824 8192000000 10936954960 11372548096 1997607872 19.604 100 58 116 0 2034112480 19104304 17400304
23:35:27 5500 8192000000 10943072992 11373076480 1998826080 19.613 100 58 116 1 2035945584 20007168 17112336
23:35:42 9383 8192000000 10947151040 11380465664 1998139056 19.608 100 52 103 1 2034874768 20742928 15992784
23:36:00 3457 8192000000 10958588624 11383541760 2001178240 19.632 100 57 114 2 2039364640 21753312 16433088
23:36:10 3308 8192000000 10968134288 11387596800 2005845840 19.669 100 77 156 0 2050029888 20914240 23269808
23:36:21 5074 8192000000 10959329488 11382407168 2000949504 19.630 100 80 157 1 2047091136 23223008 22918624
23:36:35 9533 8192000000 10957997536 11386044416 2004550464 19.659 100 66 130 0 2047225664 23747328 18927872
23:36:53 1365 8192000000 10966646128 11385675776 2006398592 19.673 100 74 148 0 2049259392 21278608 21582192
23:37:01 15529 8192000000 10951781616 11382087680 1998517984 19.611 100 65 130 2 2040493952 22843296 19132672
23:37:26 2957 8192000000 10967680080 11392745472 2010681136 19.707 100 70 141 1 2056714592 24727968 21305488
23:37:36 2494 8192000000 10987936560 11402063872 2015991216 19.749 100 71 138 0 2061313648 24450960 20871472
23:37:47 2651 8192000000 10958991376 11385249792 1997897296 19.606 99 71 143 0 2045782272 26166352 21718624
23:37:56 4939 8192000000 10969432224 11393982464 1997107552 19.600 99 81 162 0 2047970704 26978000 23885152
23:38:08 2242 8192000000 10991020128 11406192640 2018591504 19.769 100 83 163 1 2069773824 27809904 23372416
23:38:17 4491 8192000000 10982485024 11409268736 2023582288 19.808 100 80 156 2 2076653520 29306448 23764784
23:38:29 4997 8192000000 10976589264 11407937536 2022804496 19.802 100 63 125 1 2069092400 27278160 19009744
23:38:45 2081 8192000000 10961439984 11388743680 2008581952 19.690 100 71 142 3 2055397888 25687024 21128912
23:38:55 6326 8192000000 10966911840 11393187840 2008098736 19.687 100 65 127 2 2054526640 26476656 19951248
23:39:08 3764 8192000000 10975690560 11401125888 2010464768 19.705 100 70 141 2 2059971472 27349232 22157472
23:39:18 5167 8192000000 10984282272 11404378112 2016734272 19.754 100 78 155 2 2066751904 27584736 22432896
23:39:31 5232 8192000000 10986620912 11413704704 2022980032 19.804 100 73 144 0 2073770608 29206848 21583728
23:39:50 5897 8192000000 10983667632 11411492864 2019448224 19.776 100 71 142 0 2071041664 30149600 21443840
23:40:04 4197 8192000000 10988829328 11405824000 2003221504 19.648 99 83 166 0 2061196160 32764080 25210576
23:40:15 3022 8192000000 10993576112 11414319104 2021767728 19.794 100 85 170 0 2080227440 32598704 25861008
23:40:26 4536 8192000000 10983492992 11403792384 2001142368 19.632 99 80 160 3 2059771472 34445872 24183232
23:40:41 5073 8192000000 10976048592 11397939200 2006982832 19.678 100 81 159 0 2066028464 34353552 24692080
23:40:54 11225 8192000000 10969142896 11398418432 1989041344 19.536 99 67 134 1 2046750976 36425040 21284592
23:41:15 6448 8192000000 10975175248 11400380416 2002026736 19.639 100 60 120 0 2058149696 36948208 19174752
23:41:28 2734 8192000000 10961868624 11376644096 1968504576 19.374 98 78 155 0 2030325536 36948256 24872704
23:41:38 6041 8192000000 10968283792 11380846592 1977317216 19.443 99 79 157 0 2040229360 38662080 24250064
23:41:52 4695 8192000000 10959989904 11379015680 1982615232 19.485 100 76 149 1 2044866672 39577632 22673808
23:42:07 5255 8192000000 10959327088 11380330496 1972277024 19.404 99 73 140 2 2033852128 39447856 22127248
23:42:23 6856 8192000000 10981440176 11400814592 1994467488 19.579 100 76 149 0 2058787072 41509392 22810192
23:42:38 1713 8192000000 10989199360 11403771904 1999046560 19.615 100 79 159 2 2067807184 43422944 25337680
23:42:49 2925 8192000000 10977574848 11391033344 1962738368 19.328 98 74 148 1 2030819728 45132448 22948912
23:43:03 792 8192000000 10991349040 11400675328 1991812032 19.558 100 92 184 1 2069608672 47702832 30093808
23:43:11 5405 8192000000 10985044752 11400359936 1980828048 19.471 99 84 168 0 2051756592 44964880 25963664
23:43:24 7305 8192000000 10993420432 11407065088 1999386192 19.618 100 73 145 1 2067491792 45500736 22604864
23:43:43 3972 8192000000 10987591104 11407269888 2001388096 19.634 100 84 165 2 2073319712 45834896 26096720
23:43:54 3414 8192000000 10990052352 11402264576 1996049680 19.592 100 75 147 1 2066585152 47099136 23436336
23:44:04 2865 8192000000 10983308224 11409043456 1999811216 19.621 100 74 147 1 2067751232 45076672 22863344
23:44:15 3348 8192000000 10974649440 11391234048 1962085344 19.323 98 74 146 0 2030926896 45809392 23032160
23:44:28 2653 8192000000 10984132848 11401072640 1994587296 19.580 100 81 162 0 2069374304 48462576 26324432
23:44:38 3663 8192000000 10973174768 11385401344 1978233584 19.451 100 74 148 0 2051715088 48941744 24539760
23:44:50 1807 8192000000 10974180352 11388256256 1980694128 19.470 100 81 162 0 2057278832 50375408 26209296
23:45:01 4579 8192000000 10953832832 11373146112 1963551712 19.334 100 75 150 1 2039761072 52326896 23882464
23:45:14 2522 8192000000 10955944384 11360358400 1946558064 19.199 100 85 169 1 2028860944 56240080 26062800
23:45:24 1596 8192000000 10962146736 11368935424 1954260832 19.260 100 88 178 1 2037902896 55199056 28443008
23:45:32 2645 8192000000 10970821056 11379007488 1967229664 19.363 100 89 179 0 2051859088 55784592 28844832
23:45:42 3007 8192000000 10966054016 11384061952 1967829664 19.368 100 71 143 0 2047686624 56426576 23430384
23:46:02 5959 8192000000 10939256912 11363540992 1954554608 19.263 100 58 110 1 2025024800 52414896 18055296
23:46:19 4567 8192000000 10944033600 11371429888 1958406288 19.293 100 50 100 1 2028261808 53328848 16526672
23:46:33 13352 8192000000 10951507152 11373907968 1961052176 19.314 100 65 130 1 2035949376 54154368 20742832
23:46:52 1887 8192000000 10956089632 11362279424 1933060448 19.091 99 92 184 1 2020972080 57655440 30256192
23:47:01 1626 8192000000 10963676944 11375374336 1956881216 19.281 100 87 175 0 2046085840 61110304 28094320
23:47:13 7455 8192000000 10938295504 11383201792 1955182464 19.268 100 65 129 2 2034765968 58372688 21210816
23:47:48 16091 8192000000 10938669184 11385815040 1964081696 19.338 100 37 74 1 2031088096 53618224 13388176
23:48:24 13399 8192000000 10927996240 11372236800 1942760416 19.169 99 37 73 2 2005678912 49976896 12941600
23:48:55 12941 8192000000 10933323008 11372326912 1937075024 19.123 99 32 64 1 2002415920 54174144 11166752
23:49:15 16211 8192000000 10937944848 11379376128 1956336000 19.277 100 28 56 2 2023615008 56950160 10328848
23:49:39 13082 8192000000 10947834480 11390046208 1965941616 19.353 100 37 74 0 2031468144 53289136 12237392
23:49:59 16706 8192000000 10945191792 11395952640 1971159264 19.395 100 32 62 4 2029342272 48176864 10006144
23:50:41 24331 8192000000 10927529072 11382571008 1959308544 19.301 100 29 59 1 2016511840 47833984 9369312
23:51:21 16854 8192000000 10933164592 11383840768 1960064784 19.307 100 23 46 1 2014304992 46131456 8108752
23:51:59 15688 8192000000 10923187712 11373809664 1940687840 19.152 99 22 44 0 1994051584 45442352 7921392
23:52:22 14235 8192000000 10927093792 11368919040 1947117840 19.204 100 31 62 0 2007764720 49784928 10861952
23:52:43 23468 8192000000 10928074592 11382816768 1952494768 19.246 100 19 38 0 2013166528 53486752 7185008
23:53:13 29814 8192000000 10927702192 11390296064 1936653472 19.120 99 25 48 2 2008003856 61747504 9602880
23:53:49 40889 8192000000 10911152592 11377139712 1930982784 19.075 99 22 44 0 1991318048 52897728 7437536
23:54:49 34794 8192000000 10867952864 11318951936 1862520640 18.524 96 11 22 0 1887302688 21895136 2886912
23:55:37 31441 8192000000 10873503984 11316518912 1905917936 18.874 99 29 58 1 1939045328 23999456 9127936
23:56:14 55632 8192000000 10857470880 11314597888 1904267856 18.861 99 17 34 3 1923287776 14433568 4586352
23:57:16 100850 8192000000 10901961344 11349999616 1946534432 19.199 100 28 56 0 1975829600 21084048 8211120
23:59:44 111342 8192000000 10864616048 11329261568 1920444528 18.990 98 15 30 0 1933577808 9323712 3809568
00:01:43 90951 8192000000 10873866224 11326164992 1913713408 18.936 98 16 31 0 1931157680 13056720 4387552
00:03:22 46812 8192000000 10882438112 11328151552 1932094208 19.084 99 28 57 0 1948984608 9051296 7839104
00:04:18 145154 8192000000 10907012256 11359133696 1948798160 19.217 99 14 28 0 1960960880 8404592 3758128
00:06:57 1275 8192000000 10936451872 11365867520 1985467744 19.508 100 64 124 2 2013782144 9723232 18591168
00:07:06 52336 8192000000 10920078304 11376173056 1987680096 19.525 100 30 61 2 2011735728 14889488 9166144
00:08:10 25832 8192000000 10917173184 11384246272 1987964432 19.528 100 25 50 2 2012210976 16512512 7734032
00:09:05 20544 8192000000 10921422640 11377741824 1979762256 19.463 100 25 50 1 2001656400 14731984 7162160
00:09:33 24873 8192000000 10934043200 11370622976 1969274608 19.380 99 59 119 0 2004513536 17832400 17406528
00:10:08 45355 8192000000 10894124144 11358404608 1961449648 19.318 99 31 61 1 1989167296 18302832 9414816
00:11:00 65755 8192000000 10893572688 11381649408 1962691920 19.327 100 7 14 0 1981223232 16553728 1977584
00:12:13 36348 8192000000 10897405440 11377471488 1965054832 19.346 100 6 12 0 1985202240 18145616 2001792
00:12:56 21195 8192000000 10903393392 11368484864 1975297920 19.427 100 17 34 0 1994968672 14991168 4679584
00:14:18 45277 8192000000 10903919360 11377827840 1982667456 19.486 100 12 24 1 1999590656 13080912 3842288
00:15:17 94976 8192000000 10902818464 11385151488 1951587840 19.239 98 27 54 0 1974259072 14764896 7906336
00:17:03 24352 8192000000 10907067808 11392643072 1981303712 19.475 100 8 16 2 2004792336 21059632 2428992
00:17:40 85880 8192000000 10893196160 11371696128 1955378208 19.269 99 16 32 0 1974398528 14839968 4180352
00:19:26 44733 8192000000 10873376496 11349692416 1935430336 19.110 98 10 20 1 1947431152 9421632 2579184
00:20:20 25479 8192000000 10885759584 11360919552 1973317216 19.412 100 13 26 1 1985558096 8783456 3457424
00:20:57 53551 8192000000 10892935648 11362799616 1955729696 19.272 99 14 27 0 1966757232 6837088 4190448
00:22:01 81176 8192000000 10902150496 11386576896 1982970080 19.488 100 20 40 1 1997215488 8598000 5647408
00:23:29 52725 8192000000 10896588880 11382792192 1966972384 19.361 99 5 10 0 1981013888 12529696 1511808
00:24:30 55043 8192000000 10902666400 11387572224 1969931392 19.385 99 9 18 1 1982159008 9632848 2594768
00:25:31 32187 8192000000 10904789408 11374673920 1954402336 19.262 98 18 36 1 1966325696 7059072 4864288
00:26:11 50418 8192000000 10922725344 11377246208 1953375216 19.253 98 38 76 3 1973953760 9642864 10935680
00:27:44 30349 8192000000 10907610176 11378720768 1983183600 19.490 100 23 46 2 1998117344 8867040 6066704
00:28:36 37183 8192000000 10913214400 11377868800 1955988352 19.274 98 26 52 1 1973292560 10531024 6773184
00:29:30 66537 8192000000 10895326000 11373154304 1932647440 19.088 97 18 36 1 1948687152 10267296 5772416
00:30:46 47336 8192000000 10907349408 11372646400 1935222032 19.109 97 26 52 0 1952191408 10131792 6837584
00:31:40 67687 8192000000 10878288800 11350474752 1879775632 18.663 95 27 54 0 1899413760 12440640 7197488
00:32:53 71604 8192000000 10901309872 11354906624 1866446608 18.556 95 17 34 1 1890515664 19121008 4948048
00:34:11 18659 8192000000 10875814096 11326406656 1918410928 18.974 98 38 76 0 1940271952 11371216 10489808
00:35:29 61413 8192000000 10873049728 11349868544 1915543280 18.951 99 9 18 0 1935821872 17911360 2367232
00:36:41 41531 8192000000 10840707056 11301785600 1825873744 18.226 94 12 23 1 1839105232 9453664 3777824
00:37:32 48405 8192000000 10861715120 11316023296 1868356064 18.571 97 15 31 0 1881213168 8767184 4089920
00:38:39 128578 8192000000 10870676480 11311026176 1878653008 18.654 97 29 57 0 1899244128 12259856 8331264
00:41:01 83346 8192000000 10877504976 11332603904 1882906624 18.689 97 33 66 0 1904050656 12085168 9058864
00:42:30 47427 8192000000 10860143408 11322626048 1916014368 18.955 99 20 40 1 1934906576 13293088 5599120
00:43:24 35397 8192000000 10843148192 11299393536 1894216112 18.780 98 31 62 0 1913925808 10764736 8944960
00:44:13 41624 8192000000 10834170992 11310936064 1892071344 18.762 98 12 24 3 1904585920 9058912 3455664
00:45:51 28274 8192000000 10845832528 11310288896 1904341072 18.861 99 22 44 0 1917766912 7057072 6368768
00:46:32 54102 8192000000 10848530224 11314954240 1873843568 18.615 97 21 42 0 1889472496 9727632 5901296
00:47:38 72018 8192000000 10826714304 11286142976 1883041040 18.690 98 16 32 1 1894769664 6551392 5177232
00:48:56 56862 8192000000 10832258448 11302256640 1902052720 18.843 99 16 31 1 1913754816 7515904 4186192
00:50:00 34319 8192000000 10831498320 11300487168 1890057872 18.746 98 11 22 0 1899828496 6804384 2966240
00:50:40 40266 8192000000 10848774320 11311239168 1921082944 18.996 100 31 62 3 1937226496 7939952 8203600
00:51:32 67535 8192000000 10836312560 11308527616 1890125728 18.747 98 3 6 0 1898943184 8027168 790288
00:52:47 60031 8192000000 10868341520 11329069056 1904738896 18.864 98 23 47 2 1919789872 8564960 6486016
00:53:56 36457 8192000000 10878687792 11335741440 1930911936 19.074 99 28 56 1 1956339232 17485968 7941328
00:54:41 71257 8192000000 10900888896 11364126720 1937842352 19.130 99 25 50 2 1962827472 18201408 6783712
00:55:58 66765 8192000000 10878598432 11346731008 1920012144 18.987 98 24 48 2 1936964880 10086624 6866112
00:57:11 22666 8192000000 10905507152 11342102528 1926359952 19.038 98 43 83 0 1949113008 12196224 10556832
00:57:43 44024 8192000000 10921955232 11378249728 1975206944 19.427 100 44 87 1 1997286000 10437664 11641392
00:58:33 50430 8192000000 10916578752 11385774080 1980801456 19.471 100 28 56 1 2004902496 16606960 7494080
00:59:43 96033 8192000000 10904621424 11370147840 1907652896 18.888 96 18 35 2 1924865792 12255936 4956960
01:01:30 27185 8192000000 10928193728 11378843648 1985388112 19.507 100 28 56 1 2000954048 7457392 8108544
01:02:04 93692 8192000000 10912328608 11396571136 1968042464 19.370 98 31 60 1 1991219024 14590464 8586096
01:03:45 92379 8192000000 10915442064 11385479168 1956065392 19.275 98 7 14 0 1968789824 10546624 2177808
01:05:23 36793 8192000000 10926099056 11366473728 1889002992 18.738 95 24 48 1 1905333136 10117920 6212224
01:06:07 67381 8192000000 10895538864 11372773376 1929034128 19.059 98 26 52 0 1953314896 16819616 7461152
01:08:25 73927 8192000000 10894977168 11344764928 1911688672 18.920 97 30 60 2 1927845264 7280480 8876112
01:09:46 40936 8192000000 10890678160 11349094400 1948664448 19.216 99 28 56 4 1965812560 9031312 8116800
01:10:35 14442 8192000000 10899451600 11352817664 1963932528 19.337 100 31 62 1 1980837568 8093328 8811712
01:10:56 43370 8192000000 10898991184 11376644096 1955495904 19.270 99 31 62 2 1973708576 9582960 8629712
01:11:47 46048 8192000000 10872074928 11346083840 1937507456 19.127 98 17 34 1 1954775680 12560416 4707808
01:12:39 62144 8192000000 10877859184 11342479360 1886807952 18.720 96 7 14 2 1895366272 6917504 1640816
01:13:48 58166 8192000000 10881709984 11353354240 1943261520 19.173 99 14 28 0 1955504704 8074880 4168304
01:14:55 95839 8192000000 10861502528 11346006016 1902679344 18.848 97 15 30 0 1914609616 7839216 4091056
01:16:37 66422 8192000000 10890112480 11356524544 1915671840 18.952 98 12 24 0 1936586096 17183584 3730672
01:17:49 50968 8192000000 10893636400 11353497600 1919658080 18.984 98 21 41 0 1945883536 20308384 5917072
01:18:46 77253 8192000000 10856399008 11322408960 1853779728 18.453 95 17 34 0 1875006032 16654848 4571456
01:20:11 63745 8192000000 10861029664 11315322880 1844410400 18.377 95 15 30 1 1861705984 12967840 4327744
01:21:24 29588 8192000000 10862360960 11322462208 1914107200 18.940 99 44 90 0 1940204336 13791824 12305312
01:22:07 54895 8192000000 10830723360 11307786240 1833934480 18.291 95 16 32 0 1851214272 12315024 4964768
01:23:11 54384 8192000000 10854034944 11301859328 1865176992 18.545 97 20 40 2 1883266848 12678656 5411200
01:24:13 57133 8192000000 10864748848 11314454528 1864254512 18.538 97 40 80 2 1886538432 10918672 11365248
01:25:22 72561 8192000000 10837242528 11300036608 1826479664 18.231 95 12 24 0 1844656592 14196672 3980256
01:26:49 26028 8192000000 9455080752 9759330304 590560656 6.724 32 4 8 0 599376192 8097072 718464

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 25-11-2020 01:28:02 to 25-11-2020 01:28:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 144 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

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

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          246466
MON$OLDEST_ACTIVE               246467
MON$OLDEST_SNAPSHOT             246467
MON$NEXT_TRANSACTION            246467
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                       2013568
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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 ---
:209: 
:210: mscs-test-161.budzdorov.ru    Wed Nov 25 01:27:19 2020
:211:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:212: 
:213: 
:214: mscs-test-161.budzdorov.ru    Wed Nov 25 01:27:21 2020
:215:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:216: 
--- end of diff output ---

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

25.11.20 01:28:38. 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-25 01:28:40 No severe PSQL-related problems occured
25.11.20 01:28:41. End of report.