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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17085612 kB
MemAvailable 31180436 kB
Buffers 0 kB
Cached 14598504 kB
SwapCached 4772 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-10 19:27:20
DTS_END                         2021-02-10 19:27:20.6660
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44486
TRN_ID                          244213
ATT_ID                          722
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: 9263.51 22731 1111621
customer order: creation 177.55 336 21306
customer order: refuse 14.71 314 1765
order to supplier: creation 46.80 1318 5616
order to supplier: removal 3.54 99629 425
invoice (draft): creation 47.43 3587 5692
invoice (draft): removal 53.18 763 6382
invoice accept: apply 42.80 17885 5136
invoice accept: cancel 47.73 747 5728
customer reserve: creation 3924.55 178 470946
customer reserve: removal 4603.01 60 552361
realization accept: apply 87.07 181 10448
realization accept: cancel 80.94 111 9713
payment from customer: creation 60.78 128 7293
payment from customer: removal 5.98 84 717
payment to supplier: creation 51.11 152 6133
payment to supplier: removal 3.59 90 431
service: total inventory turnovers 4.50 1300 540
service: total monetary turnovers 7.20 24 864
service: aggregate perf. data 1.01 16141 121
service: refresh index statistics 0.03 311599 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-02-2021 19:28:39 to 10-02-2021 19:28:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3295
TEST_TIME 2 2348
TEST_TIME 3 3509
TEST_TIME 4 4657
TEST_TIME 5 4511
TEST_TIME 6 4555
TEST_TIME 7 4653
TEST_TIME 8 4985
TEST_TIME 9 5067
TEST_TIME 10 5268
TEST_TIME 11 5271
TEST_TIME 12 5679
TEST_TIME 13 6117
TEST_TIME 14 6493
TEST_TIME 15 6901
TEST_TIME 16 7223
TEST_TIME 17 7388
TEST_TIME 18 7310
TEST_TIME 19 7639
TEST_TIME 20 8318
TEST_TIME 21 8687
TEST_TIME 22 8836
TEST_TIME 23 9233
TEST_TIME 24 9888
TEST_TIME 25 9884
TEST_TIME 26 10082
TEST_TIME 27 10600
TEST_TIME 28 10694
TEST_TIME 29 10596
TEST_TIME 30 10428
TEST_TIME 31 10432
TEST_TIME 32 10385
TEST_TIME 33 10096
TEST_TIME 34 10117
TEST_TIME 35 10137
TEST_TIME 36 9927
TEST_TIME 37 9864
TEST_TIME 38 9761
TEST_TIME 39 9594
TEST_TIME 40 9730
TEST_TIME 41 9796
TEST_TIME 42 9798
TEST_TIME 43 9827
TEST_TIME 44 9723
TEST_TIME 45 9599
TEST_TIME 46 9744
TEST_TIME 47 9702
TEST_TIME 48 9742
TEST_TIME 49 9791
TEST_TIME 50 9912
TEST_TIME 51 9863
TEST_TIME 52 9843
TEST_TIME 53 9897
TEST_TIME 54 9834
TEST_TIME 55 9826
TEST_TIME 56 9929
TEST_TIME 57 10041
TEST_TIME 58 10083
TEST_TIME 59 10045
TEST_TIME 60 9979
TEST_TIME 61 9887
TEST_TIME 62 9847
TEST_TIME 63 9775
TEST_TIME 64 9727
TEST_TIME 65 9676
TEST_TIME 66 9688
TEST_TIME 67 9660
TEST_TIME 68 9647
TEST_TIME 69 9626
TEST_TIME 70 9573
TEST_TIME 71 9501
TEST_TIME 72 9567
TEST_TIME 73 9723
TEST_TIME 74 9659
TEST_TIME 75 9663
TEST_TIME 76 9727
TEST_TIME 77 9776
TEST_TIME 78 9748
TEST_TIME 79 9760
TEST_TIME 80 9657
TEST_TIME 81 9634
TEST_TIME 82 9561
TEST_TIME 83 9546
TEST_TIME 84 9497
TEST_TIME 85 9495
TEST_TIME 86 9474
TEST_TIME 87 9441
TEST_TIME 88 9362
TEST_TIME 89 9402
TEST_TIME 90 9382
TEST_TIME 91 9438
TEST_TIME 92 9434
TEST_TIME 93 9471
TEST_TIME 94 9489
TEST_TIME 95 9472
TEST_TIME 96 9485
TEST_TIME 97 9459
TEST_TIME 98 9454
TEST_TIME 99 9458
TEST_TIME 100 9540
TEST_TIME 101 9556
TEST_TIME 102 9523
TEST_TIME 103 9594
TEST_TIME 104 9586
TEST_TIME 105 9543
TEST_TIME 106 9506
TEST_TIME 107 9444
TEST_TIME 108 9444
TEST_TIME 109 9396
TEST_TIME 110 9358
TEST_TIME 111 9355
TEST_TIME 112 9329
TEST_TIME 113 9304
TEST_TIME 114 9279
TEST_TIME 115 9308
TEST_TIME 116 9372
TEST_TIME 117 9354
TEST_TIME 118 9334
TEST_TIME 119 9338
TEST_TIME 120 9267

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 10-02-2021 19:28:42 to 10-02-2021 19:28:46.

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 1547170 1547170 0 0.00 0 34930 7 0 0
doc_list_biud 1547169 1547169 0 0.00 0 35093 27 0 0
sp_add_invoice_to_stock 5256 5136 120 2.28 42 186801 17886 0 120
sp_cancel_adding_invoice 5728 5728 0 0.00 5 72514 747 0 0
sp_cancel_client_order 1765 1765 0 0.00 4 10139 315 0 0
sp_cancel_customer_reserve 552361 552361 0 0.00 1 27882 61 0 0
sp_cancel_pay_from_customer 717 717 0 0.00 3 5144 85 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 3 3655 90 0 0
sp_cancel_supplier_invoice 6390 6382 8 0.12 2 32679 764 0 8
sp_cancel_supplier_order 425 425 0 0.00 6 1109643 99630 0 0
sp_cancel_write_off 9713 9713 0 0.00 1 17252 112 0 0
sp_client_order 21306 21306 0 0.00 3 25836 336 0 0
sp_customer_reserve 470946 470946 0 0.00 0 84595 179 0 0
sp_fill_shopping_cart 32614 32614 0 0.00 1 32380 41 0 0
sp_fill_shopping_cart_clo_res 470942 470942 0 0.00 0 31193 13 0 0
sp_get_clo_for_invoice 5130 5130 0 0.00 0 30226 297 0 0
sp_kill_cost_storno 16589 16589 0 0.00 0 15213 54 0 0
sp_kill_qstorno_ret_qs2qd 1121242 1121242 0 0.00 0 32671 33 0 0
sp_kill_qty_storno 591952 591952 0 0.00 0 35092 70 0 0
sp_lock_selected_doc 21559 21559 0 0.00 0 11623 4 0 0
sp_make_cost_storno 29004 29004 0 0.00 0 34918 63 0 0
sp_multiply_rows_for_pdistr 29004 29004 0 0.00 0 24162 40 0 0
sp_multiply_rows_for_qdistr 21306 21306 0 0.00 0 14599 153 0 0
sp_pay_from_customer 7293 7293 0 0.00 4 33880 128 0 0
sp_pay_to_supplier 6133 6133 0 0.00 5 33856 152 0 0
sp_payment_common 13426 13426 0 0.00 1 24057 34 0 0
sp_qd_handle_on_cancel_clo 1765 1765 0 0.00 0 10131 294 0 0
sp_qd_handle_on_invoice_upd_sts 10858 10858 0 0.00 0 19253 321 0 0
sp_qd_handle_on_reserve_upd_sts 10448 10448 0 0.00 0 35091 56 0 0
sp_reserve_write_off 10448 10448 0 0.00 6 35149 181 0 0
sp_supplier_invoice 5692 5692 0 0.00 6 105395 3587 0 0
sp_supplier_order 5616 5616 0 0.00 5 44911 1318 0 0
srv_aggregate_perf_data 121 121 0 0.00 2179 242103 16142 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1075 143124 33602 0 0
srv_find_qd_qs_mism 1062275 1062275 0 0.00 0 16597 6 0 0
srv_make_invnt_saldo 540 540 0 0.00 52 115591 1301 0 0
srv_make_money_saldo 864 864 0 0.00 1 1896 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 218258 485958 311599 0 0
t$perf-abend:sp_add_invoice_to_stock 120 120 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-norm:sp_add_invoice_to_stock 5136 5136 0 0.00 0 11629 172 0 0
t$perf-norm:sp_cancel_adding_invoice 432 432 0 0.00 0 6095 82 0 0
t$perf-norm:sp_cancel_client_order 1765 1765 0 0.00 0 3462 13 0 0
t$perf-norm:sp_cancel_customer_reserve 716 716 0 0.00 0 3423 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 717 717 0 0.00 0 1109 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 3453 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 455 455 0 0.00 0 2223 14 0 0
t$perf-norm:sp_cancel_supplier_order 425 425 0 0.00 0 22098 1545 0 0
t$perf-norm:sp_cancel_write_off 1040 1040 0 0.00 0 7541 12 0 0
t$perf-norm:sp_client_order 21306 21306 0 0.00 0 7197 18 0 0
t$perf-norm:sp_customer_reserve 1061 1061 0 0.00 0 1782 6 0 0
t$perf-norm:sp_pay_from_customer 7293 7293 0 0.00 0 8976 9 0 0
t$perf-norm:sp_pay_to_supplier 6133 6133 0 0.00 0 6474 11 0 0
t$perf-norm:sp_reserve_write_off 10448 10448 0 0.00 0 6450 11 0 0
t$perf-norm:sp_supplier_invoice 5692 5692 0 0.00 0 9692 18 0 0
t$perf-norm:sp_supplier_order 5616 5616 0 0.00 0 3388 17 0 0
t$perf-norm:srv_aggregate_perf_data 121 121 0 0.00 0 364 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 474 9 0 0
t$perf-norm:srv_make_invnt_saldo 540 540 0 0.00 0 1194 21 0 0
t$perf-norm:srv_make_money_saldo 864 864 0 0.00 0 714 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 339 86 0 0
v_add_invoice_to_stock 10500 10260 240 2.28 0 3420 17 0 240
v_all_customers 38822 38822 0 0.00 0 116 1 0 0
v_all_suppliers 31622 31622 0 0.00 0 116 1 0 0
v_all_wares 42612 42612 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 864 864 0 0.00 0 346 6 0 0
v_cancel_client_order 3530 3530 0 0.00 0 1104 3 0 0
v_cancel_customer_prepayment 1434 1434 0 0.00 0 5128 13 0 0
v_cancel_customer_reserve 1432 1432 0 0.00 0 2660 6 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 2501 13 0 0
v_cancel_supplier_invoice 926 910 16 1.72 0 2117 22 0 16
v_cancel_supplier_order 850 850 0 0.00 0 1074 6 0 0
v_cancel_write_off 2080 2080 0 0.00 0 1214 12 0 0
v_max_id_clo_ord 5616 5616 0 0.00 0 613 1 0 0
v_max_id_clo_res 1061 1061 0 0.00 0 3454 15 0 0
v_max_id_ord_sup 5692 5692 0 0.00 0 2538 3 0 0
v_max_non_paid_invoice 1630 1630 0 0.00 0 387 2 0 0
v_max_non_paid_realizn 3981 3981 0 0.00 0 2435 3 0 0
v_min_id_clo_ord 5616 5616 0 0.00 0 3250 9 0 0
v_min_id_clo_res 1061 1061 0 0.00 0 3776 16 0 0
v_min_id_ord_sup 5692 5692 0 0.00 0 9614 14 0 0
v_min_non_paid_invoice 6133 6133 0 0.00 0 18621 25 0 0
v_min_non_paid_realizn 7293 7293 0 0.00 0 24045 23 0 0
v_our_firm 10414 10414 0 0.00 0 16 1 0 0
v_reserve_write_off 20896 20896 0 0.00 0 5077 6 0 0
x_lock_depdocs_on_canc_invoice 11655 11655 0 0.00 0 19978 109 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 5996 291 0 0
x_make_qstorno_1000_1200 5616 5616 0 0.00 2 44906 1241 0 0
x_make_qstorno_1200_2000 5692 5692 0 0.00 3 105336 3436 0 0
x_make_qstorno_2100_3300 470946 470946 0 0.00 0 84575 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-02-2021 19:28:47 to 10-02-2021 19:28:51.

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
16:57:24 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:30 12944 8192000000 10236118224 10537447424 872454608 9.625 68 50 100 2 892711376 2554272 17702496
16:57:51 15601 8192000000 10321209680 10636255232 1382430304 14.438 100 87 174 0 1415611424 4774896 28406224
16:58:17 28476 8192000000 10373737600 10695577600 1424363920 14.811 100 91 183 1 1460414384 6384064 29666400
16:58:54 27791 8192000000 10406917520 10734829568 1461093392 15.136 100 87 174 0 1497141088 7712368 28335328
16:59:33 16055 8192000000 10437669856 10768769024 1486669168 15.360 100 88 176 0 1523236112 8406864 28160080
17:00:01 19947 8192000000 10460809216 10796019712 1508172848 15.547 100 87 174 1 1544354976 9046512 27135616
17:00:32 18844 8192000000 10480787840 10821066752 1533484688 15.767 100 87 174 0 1570674016 9865392 27323936
17:01:00 25644 8192000000 10501466608 10842456064 1554861136 15.952 100 87 174 0 1592373024 10567216 26944672
17:01:37 17641 8192000000 10515286720 10864054272 1574619424 16.122 100 89 178 0 1613347200 11432320 27295456
17:02:16 19026 8192000000 10541152768 10895978496 1598771360 16.329 100 79 158 2 1633608144 11355824 23480960
17:02:43 10467 8192000000 10560703888 10919510016 1617620048 16.490 100 73 146 1 1651322544 11803856 21898640
17:03:03 14159 8192000000 10579349136 10936647680 1631414912 16.607 100 80 160 0 1667909712 12411168 24083632
17:03:31 19183 8192000000 10598177984 10959597568 1654611248 16.803 100 77 154 2 1690288256 13089920 22587088
17:03:59 7775 8192000000 10615698832 10979495936 1671739744 16.948 100 82 164 0 1709681680 13851936 24090000
17:04:16 12060 8192000000 10622215824 10998042624 1689018048 17.093 100 81 161 0 1728933072 16843776 23071248
17:04:37 7885 8192000000 10645155776 11018850304 1704854384 17.226 100 73 143 2 1736357824 10792752 20710688
17:04:53 7548 8192000000 10656636272 11034984448 1725593056 17.399 100 68 136 0 1756752144 11115424 20043664
17:05:07 8368 8192000000 10674658144 11054206976 1742858352 17.542 100 70 139 2 1774481600 10994816 20628432
17:05:23 6297 8192000000 10684658432 11065274368 1748351216 17.588 100 64 129 0 1777351584 11021664 17978704
17:05:36 4866 8192000000 10695360768 11079655424 1765188736 17.727 100 70 136 1 1795581760 11351280 19041744
17:05:48 7654 8192000000 10696364016 11084451840 1770829328 17.774 100 67 135 3 1800993376 11658752 18505296
17:06:06 4116 8192000000 10728987040 11108204544 1788522272 17.920 100 71 142 2 1820319104 11573408 20223424
17:06:17 4640 8192000000 10735188096 11118317568 1801334608 18.025 100 81 163 1 1837282064 12605456 23342000
17:06:29 2944 8192000000 10750163040 11134193664 1810380016 18.099 100 80 161 0 1845915744 13036000 22499728
17:06:39 5006 8192000000 10747475824 11136385024 1815623456 18.142 100 69 138 0 1846863120 11977408 19262256
17:06:51 4221 8192000000 10768237744 11154432000 1824454704 18.214 100 83 166 2 1859649440 11794320 23400416
17:07:03 2130 8192000000 10769625264 11158343680 1831692400 18.273 100 85 171 0 1869190608 13868432 23629776
17:07:12 3433 8192000000 10782136880 11169247232 1837214256 18.318 100 86 172 0 1876432656 14958384 24260016
17:07:22 2815 8192000000 10778603696 11170291712 1843606640 18.370 100 93 182 0 1882841920 13981360 25253920
17:07:32 1992 8192000000 10779080992 11168620544 1845871456 18.389 100 84 166 2 1880884944 11093888 23919600
17:07:41 1439 8192000000 10798011952 11184529408 1853116448 18.447 100 83 166 1 1888144736 11031952 23996336
17:07:49 2842 8192000000 10788420208 11184463872 1856083488 18.472 100 80 161 3 1890450880 10941008 23426384
17:07:59 2317 8192000000 10795508240 11186745344 1859623600 18.500 100 79 155 1 1892440944 10384880 22432464
17:08:08 2912 8192000000 10795701072 11185070080 1860934416 18.511 100 85 171 1 1896451392 11499024 24017952
17:08:18 2776 8192000000 10809738720 11195904000 1861981920 18.519 100 89 180 0 1899241072 12778768 24480384
17:08:27 2194 8192000000 10815303056 11201015808 1867408240 18.563 100 94 188 2 1907290064 12991280 26890544
17:08:36 2178 8192000000 10806307232 11198316544 1870111712 18.585 100 94 187 2 1910046016 12830064 27104240
17:08:44 2401 8192000000 10822511712 11206574080 1873009232 18.609 100 92 185 0 1911664320 12429168 26225920
17:08:54 1854 8192000000 10818219872 11204689920 1869724848 18.582 100 92 186 1 1910066672 14798608 25543216
17:09:02 26356 8192000000 10802799312 11203641344 1865943328 18.551 100 66 132 1 1897032816 12849808 18239680
17:09:36 5166 8192000000 10779730624 11197546496 1863185280 18.529 100 46 91 0 1886022880 9917872 12919728
17:09:48 2967 8192000000 10796155872 11205255168 1870099616 18.585 100 59 118 1 1896858864 9131904 17627344
17:09:59 2257 8192000000 10794732800 11203207168 1871678624 18.598 100 52 103 0 1896902384 10061904 15161856
17:10:10 4433 8192000000 10783732144 11204644864 1870458464 18.588 100 40 80 1 1890637664 8965152 11214048
17:10:20 7470 8192000000 10788737664 11204583424 1870272480 18.586 100 30 60 0 1886078832 7141360 8664992
17:10:34 7591 8192000000 10781688432 11205312512 1872763296 18.607 100 28 56 3 1887367728 6733024 7871408
17:10:48 5437 8192000000 10786585152 11217838080 1873970192 18.616 100 23 46 1 1891027856 10902576 6155088
17:11:01 7212 8192000000 10791871216 11213176832 1876313184 18.635 100 32 64 2 1892643200 7370912 8959104
17:11:17 8209 8192000000 10792263264 11217395712 1876914144 18.640 100 27 54 1 1891803472 7272560 7616768
17:11:32 14767 8192000000 10784662400 11216257024 1878091248 18.650 100 13 26 0 1887080224 5477120 3511856
17:11:53 9720 8192000000 10788728272 11221798912 1880668208 18.671 100 19 38 0 1892107408 6663664 4775536
17:12:11 10573 8192000000 10801341520 11221028864 1883117664 18.690 100 32 64 1 1899834048 7242944 9473440
17:12:28 10236 8192000000 10808729888 11226501120 1887858128 18.729 100 23 46 2 1899734944 5519600 6357216
17:12:49 71774 8192000000 10809577792 11238543360 1892834016 18.769 100 38 75 0 1908911888 5625936 10451936
17:14:09 7037 8192000000 10809945888 11239026688 1894607504 18.783 100 24 48 0 1908043952 6556176 6880272
17:14:23 6310 8192000000 10818451472 11244863488 1897549040 18.807 100 32 64 1 1913326624 6695840 9081744
17:14:38 4036 8192000000 10808254176 11243397120 1898311056 18.813 100 36 73 2 1915112592 6663856 10137680
17:14:48 6440 8192000000 10810736080 11245674496 1898727552 18.816 100 25 49 2 1911535744 5817264 6990928
17:15:02 5063 8192000000 10825721248 11251843072 1904453168 18.862 100 38 76 3 1922686608 7555344 10678096
17:15:18 7354 8192000000 10805153440 11248562176 1901888064 18.841 100 26 52 1 1916133488 7293008 6952416
17:15:32 8375 8192000000 10813464256 11252277248 1901743952 18.840 100 17 34 2 1913050976 6616864 4690160
17:15:47 5720 8192000000 10803767840 11223007232 1878497536 18.653 99 29 57 1 1892971856 5464016 9010304
17:16:00 10820 8192000000 10809790528 11246419968 1894016304 18.778 100 17 34 0 1909325184 10886560 4422320
17:16:17 8960 8192000000 10797260272 11230658560 1873237184 18.610 99 24 49 0 1885931216 5534928 7159104
17:16:32 9328 8192000000 10802641808 11242868736 1895444080 18.790 100 15 31 0 1905004864 5381888 4178896
17:16:48 5978 8192000000 10804480080 11235794944 1879119024 18.658 99 28 56 1 1893064496 5359408 8586064
17:17:02 9961 8192000000 10798027344 11231797248 1876616432 18.638 99 17 34 1 1887190592 5778352 4795808
17:17:20 11682 8192000000 10794832368 11213750272 1844456160 18.377 98 31 60 0 1859820064 5669744 9694160
17:17:41 56465 8192000000 10760612528 11176681472 1746465616 17.572 93 18 36 3 1757852944 5366016 6021312
17:18:44 16000 8192000000 10764833392 11189755904 1795445760 17.977 96 23 45 1 1812070208 10202720 6421728
17:19:06 5532 8192000000 10744188976 11168219136 1826248880 18.229 99 33 67 2 1842843888 6859360 9735648
17:19:18 5987 8192000000 10750856400 11170897920 1791468768 17.944 97 39 78 1 1810197232 6717072 12011392
17:19:34 5515 8192000000 10723926224 11146108928 1769882624 17.766 96 32 63 0 1784184224 5698928 8602672
17:19:46 5031 8192000000 10764895392 11186810880 1822088592 18.195 99 28 54 0 1836990096 7396144 7505360
17:20:02 6270 8192000000 10733446016 11152580608 1798303744 18.000 98 33 66 2 1814594224 7059216 9231264
17:20:18 5028 8192000000 10733977712 11149283328 1790659120 17.937 98 31 62 0 1805465216 5522224 9283872
17:20:29 7516 8192000000 10707347024 11115425792 1703977888 17.218 93 20 40 2 1715043056 5690336 5374832
17:20:46 11968 8192000000 10677386224 11091914752 1697861344 17.167 95 23 45 1 1710765344 5292016 7611984
17:21:04 9505 8192000000 10719877056 11135336448 1777228576 17.827 99 19 38 1 1787997376 4983104 5785696
17:21:21 9348 8192000000 10684669024 11089629184 1685951216 17.067 94 34 69 1 1701208576 5352432 9904928
17:21:40 11635 8192000000 10702259216 11122704384 1768397696 17.754 99 22 44 1 1780690016 6107040 6185280
17:21:58 10133 8192000000 10716692784 11132260352 1785366592 17.894 99 26 52 2 1799254928 5398112 8490224
17:22:16 64776 8192000000 10738140832 11152375808 1800047216 18.014 99 41 83 0 1816336672 4443088 11846368
17:23:34 12372 8192000000 10725930320 11156406272 1816992576 18.153 100 20 40 2 1829103216 6837856 5272784
17:23:53 10647 8192000000 10755478176 11171921920 1817377920 18.156 99 32 64 2 1832707184 6606080 8723184
17:24:10 7085 8192000000 10756245344 11172765696 1833310336 18.286 100 24 48 0 1845629136 4955280 7363520
17:24:27 5390 8192000000 10747888592 11177590784 1839125536 18.334 100 29 57 2 1854790704 6983008 8682160
17:24:40 7647 8192000000 10753452384 11180417024 1823457456 18.206 99 21 42 1 1835369824 6022080 5890288
17:24:56 4466 8192000000 10755781120 11184574464 1843744656 18.371 100 28 55 2 1858260240 6620912 7894672
17:25:09 8626 8192000000 10769533280 11192381440 1847488256 18.402 100 17 34 1 1857531792 5189632 4853904
17:25:26 13507 8192000000 10758514672 11185041408 1829926064 18.259 99 18 36 1 1840680288 5448976 5305248
17:25:46 9586 8192000000 10765622000 11195228160 1846267936 18.392 100 16 31 3 1861207888 10201232 4738720
17:26:01 9828 8192000000 10768884368 11199258624 1857289088 18.481 100 24 48 1 1870303600 5807776 7206736
17:26:21 10909 8192000000 10770283792 11203510272 1857043936 18.479 100 24 47 3 1873736752 9559488 7133328
17:26:38 8477 8192000000 10764935664 11200921600 1858799760 18.494 100 20 40 1 1870575904 6307648 5468496
17:26:54 11389 8192000000 10778176800 11208433664 1862860448 18.526 100 24 47 3 1876249568 7072448 6316672
17:27:15 39197 8192000000 10815154368 11231285248 1883735408 18.695 100 22 44 0 1894822176 5053120 6033648
17:28:02 4302 8192000000 10848046112 11253723136 1904253280 18.860 100 65 132 3 1934124048 11096240 18774528
17:28:15 124727 8192000000 10831900496 11260497920 1913526784 18.935 100 45 90 1 1935395728 9076992 12791952
17:30:35 15383 8192000000 10852555232 11279663104 1922700880 19.008 100 38 76 1 1945359920 12009936 10649104
17:30:59 11451 8192000000 10861458848 11288133632 1927730704 19.049 100 35 70 2 1950652096 12112960 10808432
17:31:18 14718 8192000000 10870387456 11295113216 1936410592 19.118 100 57 113 1 1964652560 11636496 16605472
17:31:42 23410 8192000000 10873826816 11304828928 1942657616 19.168 100 48 96 1 1970017696 13763008 13597072
17:32:15 27647 8192000000 10887672880 11320446976 1953922912 19.258 100 51 102 1 1986354448 17762912 14668624
17:32:51 20254 8192000000 10889832592 11322961920 1955524048 19.270 100 47 94 0 1987604880 18499536 13581296
17:33:18 14743 8192000000 10895539120 11327123456 1956925552 19.282 100 44 88 2 1987949152 17828512 13195088
17:33:50 4415 8192000000 10910978592 11336646656 1963967136 19.338 100 52 101 1 1997170176 19047664 14155376
17:34:09 6394 8192000000 10908825456 11334115328 1949644864 19.224 99 58 115 2 1985842832 19330816 16867152
17:34:24 25254 8192000000 10907485136 11339476992 1967457376 19.365 100 51 101 0 2004065136 21350528 15257232
17:34:58 13181 8192000000 10914231488 11345690624 1965445872 19.349 100 43 86 0 1998813264 20486528 12880864
17:35:20 18095 8192000000 10906625264 11346554880 1968308464 19.372 100 46 92 2 2007509408 25370960 13829984
17:35:52 14515 8192000000 10917442160 11353690112 1972437792 19.405 100 43 85 2 2006885184 21563632 12883760
17:36:18 15171 8192000000 10901196512 11340500992 1955976592 19.274 99 32 64 2 1989709088 23003392 10729104
17:36:42 9280 8192000000 10918971504 11344474112 1953905952 19.258 99 47 95 1 1988277488 20109120 14262416
17:36:59 7827 8192000000 10924963104 11352465408 1972676144 19.407 100 54 108 1 2011335936 22437168 16222624
17:37:17 2687 8192000000 10928441968 11348672512 1957600256 19.287 99 60 118 1 1998669072 23079552 17989264
17:37:28 9606 8192000000 10932852240 11354730496 1977932848 19.448 100 62 124 1 2019041392 22742784 18365760
17:37:48 4705 8192000000 10946017216 11369381888 1984000240 19.496 100 68 134 3 2027314080 23496960 19816880
17:38:01 9781 8192000000 10942389840 11365453824 1965080160 19.346 99 71 142 5 2010710480 24545136 21085184
17:38:21 4662 8192000000 10940369088 11363975168 1976131872 19.434 100 69 138 1 2022377776 25632480 20613424
17:38:33 4182 8192000000 10930723488 11356327936 1957623360 19.287 99 65 130 0 2006127696 28356192 20148144
17:38:44 3790 8192000000 10945055824 11365343232 1981858592 19.479 100 84 165 2 2035819216 28333888 25626736
17:38:57 6055 8192000000 10927170720 11355537408 1962416864 19.325 99 62 124 0 2011894848 30318400 19159584
17:39:10 11237 8192000000 10931464096 11365199872 1974182512 19.419 100 56 110 2 2026077072 34059744 17834816
17:39:31 2539 8192000000 10952540480 11380305920 1988167376 19.529 100 73 146 1 2044531728 33623216 22741136
17:39:43 7916 8192000000 10955329584 11384963072 1989388464 19.539 100 77 152 2 2048780816 35176448 24215904
17:39:57 5358 8192000000 10969771680 11388268544 1994913648 19.583 100 80 162 0 2052959328 33114192 24931488
17:40:10 3977 8192000000 10968446448 11392950272 1995643264 19.588 100 73 143 2 2052319024 34483328 22192432
17:40:21 1706 8192000000 10981294928 11400142848 2006618208 19.675 100 90 180 0 2067719696 33762736 27338752
17:40:30 4940 8192000000 10975791520 11400916992 2004637360 19.659 100 77 153 1 2064550192 36665408 23247424
17:40:46 4778 8192000000 10985927792 11411591168 2011911648 19.717 100 80 160 1 2072004096 35096400 24996048
17:40:57 6472 8192000000 10976274928 11396640768 2000492448 19.627 100 78 156 0 2058980800 34033456 24454896
17:41:14 3566 8192000000 10985093552 11406049280 2008271216 19.688 100 74 145 2 2063200960 32399088 22530656
17:41:25 5668 8192000000 10987456672 11405701120 1994862640 19.582 99 78 154 1 2053260240 34982992 23414608
17:41:41 3309 8192000000 10984231472 11408048128 1994763696 19.581 99 72 144 1 2054762656 37647152 22351808
17:41:52 3962 8192000000 11000501984 11425439744 2018835680 19.771 100 82 161 3 2083803008 39538336 25428992
17:42:03 2184 8192000000 10994322672 11420004352 2015639392 19.746 100 80 160 1 2081308416 41061712 24607312
17:42:13 3922 8192000000 10986911696 11411308544 2009462592 19.697 100 76 151 0 2070620480 36986256 24171632
17:42:26 1676 8192000000 10985517376 11403440128 1989415984 19.539 99 82 163 1 2053994608 38677696 25900928
17:42:34 3193 8192000000 10993053248 11406290944 1996200224 19.593 99 92 184 0 2062743184 37977088 28565872
17:42:45 3968 8192000000 10987757712 11409379328 2006542864 19.674 100 82 163 1 2070844992 39105392 25196736
17:42:56 1538 8192000000 10987795104 11401527296 2003146640 19.648 100 87 175 2 2067626400 38234016 26245744
17:43:06 1803 8192000000 10994514512 11410305024 2008594512 19.690 100 82 162 2 2071124864 38724672 23805680
17:43:15 2899 8192000000 10990991968 11406929920 2004932688 19.662 100 88 175 2 2070870448 39375056 26562704
17:43:25 2913 8192000000 11000029088 11417694208 2014119616 19.734 100 87 173 2 2081213088 40007296 27086176
17:43:35 3257 8192000000 10984188368 11408498688 2007223552 19.680 100 63 125 0 2065199600 39034944 18941104
17:43:48 1789 8192000000 10964951664 11396763648 1995831280 19.590 100 66 133 0 2054331328 38283712 20216336
17:44:04 2730 8192000000 10977136176 11401383936 1991998240 19.560 99 75 148 2 2055208176 39399584 23810352
17:44:13 4351 8192000000 10976882704 11397533696 1977610320 19.446 99 81 163 1 2045651280 42154784 25886176
17:44:26 5105 8192000000 10984967408 11403177984 1992925424 19.567 100 79 156 0 2061486560 44094752 24466384
17:44:38 4133 8192000000 10974171632 11393683456 1969717184 19.383 99 82 164 0 2041591744 46187984 25686576
17:44:49 2908 8192000000 10960216240 11383029760 1975952432 19.433 100 83 167 0 2047196912 44228992 27015488
17:45:01 1454 8192000000 10944537024 11359358976 1953791760 19.257 99 87 172 2 2023797792 43486208 26519824
17:45:09 3853 8192000000 10960332464 11378573312 1970053328 19.386 100 70 140 0 2038790880 45324432 23413120
17:45:24 7441 8192000000 10972195872 11392999424 1980346464 19.467 100 67 134 0 2049923776 47193312 22384000
17:45:40 11159 8192000000 10965751936 11384471552 1949903088 19.226 98 70 137 2 2019462352 47697456 21861808
17:45:59 6149 8192000000 10948472528 11372945408 1960611776 19.311 100 69 138 1 2034677648 51418224 22647648
17:46:15 3948 8192000000 10972754976 11387875328 1972550736 19.406 100 82 164 1 2050455232 51756288 26148208
17:46:32 5569 8192000000 10934858768 11356631040 1939423888 19.142 99 68 133 0 2014114816 52486400 22204528
17:46:45 2815 8192000000 10950748240 11366445056 1947621152 19.208 99 82 162 1 2027160160 52665456 26873552
17:46:55 1074 8192000000 10963251072 11381575680 1964354528 19.341 100 85 169 3 2046402160 54301088 27746544
17:47:03 7070 8192000000 10956905520 11379900416 1958574896 19.295 100 84 169 2 2042182176 55813360 27793920
17:47:21 3486 8192000000 10944868880 11347177472 1927720864 19.049 99 85 170 2 2012006368 57191456 27094048
17:47:31 2955 8192000000 10949022000 11372314624 1956981248 19.282 100 81 161 3 2037293984 54347968 25964768
17:47:41 5915 8192000000 10931454576 11357069312 1932159024 19.084 99 53 106 0 2001877744 52134832 17583888
17:47:54 6581 8192000000 10923155504 11362795520 1947211680 19.204 100 46 91 0 2010737568 48143120 15382768
17:48:09 11227 8192000000 10922694128 11351175168 1923235536 19.013 99 46 92 1 1984681616 46577472 14868608
17:48:28 11589 8192000000 10905656496 11339730944 1920103008 18.988 99 36 72 1 1973905488 41652928 12149552
17:48:47 14409 8192000000 10898333264 11335450624 1913422512 18.934 99 39 78 1 1967830096 40752640 13654944
17:49:21 7063 8192000000 10894333696 11328999424 1922548752 19.007 100 39 78 0 1976462672 40626848 13287072
17:49:57 12617 8192000000 10885542800 11336294400 1919740672 18.985 100 29 58 2 1977564240 47640448 10183120
17:50:23 25676 8192000000 10893333472 11344982016 1931907264 19.082 100 26 52 0 1981526032 40520800 9097968
17:50:56 21090 8192000000 10904572960 11351937024 1939222640 19.141 100 29 57 0 1987062176 38192384 9647152
17:51:24 20273 8192000000 10912436528 11368951808 1940706384 19.152 100 27 54 1 1997495312 47361744 9427184
17:52:07 40127 8192000000 10887417536 11348041728 1922343472 19.006 99 18 36 0 1959269184 31235328 5690384
17:53:51 59182 8192000000 10878130240 11339370496 1919167456 18.980 99 12 24 0 1953867648 30543840 4156352
17:54:58 61488 8192000000 10896771488 11329056768 1921929856 19.002 99 16 32 0 1936211680 10062800 4219024
17:56:07 48218 8192000000 10882585520 11335364608 1917563264 18.967 98 18 36 3 1930307664 7783856 4960544
17:57:07 67221 8192000000 10874368752 11324628992 1878356272 18.652 96 38 76 0 1898233904 9188112 10689520
17:58:21 59375 8192000000 10899393888 11341303808 1955319616 19.269 100 27 52 0 1970081312 7959152 6802544
17:59:28 79866 8192000000 10914750832 11345154048 1954824112 19.265 100 30 60 1 1969886832 6339840 8722880
18:00:54 13501 8192000000 10915441392 11362156544 1976000128 19.433 100 45 90 1 1999793024 11932624 11860272
18:01:16 27518 8192000000 10907992400 11366416384 1966147808 19.355 99 34 68 2 1986700960 11113104 9440048
18:02:00 59734 8192000000 10893184352 11364548608 1940497056 19.151 98 19 38 0 1956835760 11051248 5287456
18:03:06 143124 8192000000 10913530416 11369811968 1887254576 18.724 95 24 48 1 1903254784 9376688 6623520
18:05:40 40013 8192000000 10931712144 11372113920 1949266128 19.221 98 35 70 1 1973660560 13348304 11046128
18:06:31 20190 8192000000 10938002448 11378524160 1978427312 19.452 99 62 124 2 2013366144 16546752 18392080
18:07:02 32859 8192000000 10920363616 11394486272 1992794304 19.566 100 52 104 0 2027332800 18917008 15621488
18:08:09 102386 8192000000 10894171376 11372675072 1958620160 19.295 99 14 28 1 1978512512 15576976 4315376
18:10:16 41439 8192000000 10929937248 11381133312 1982692512 19.486 100 29 57 0 2007091440 16334384 8064544
18:11:27 80731 8192000000 10917755120 11391471616 1992968192 19.567 100 10 19 0 2006788352 11208480 2611680
18:13:57 41833 8192000000 10951422224 11404320768 2004693264 19.660 100 35 69 3 2027998448 12343616 10961568
18:15:06 72629 8192000000 10929948800 11399946240 1971075232 19.394 98 23 46 1 1987995968 10052704 6868032
18:16:40 93114 8192000000 10915067424 11402043392 1995166000 19.585 100 15 30 0 2016240560 16458992 4615568
18:18:20 85962 8192000000 10914237104 11378302976 1921163792 18.996 96 14 27 0 1934676288 9974880 3537616
18:19:57 63679 8192000000 10898386624 11368189952 1914535792 18.943 96 26 52 1 1931830944 10135584 7159568
18:21:07 56059 8192000000 10907990672 11369943040 1942985312 19.171 98 31 60 2 1962795040 11471568 8338160
18:22:10 38152 8192000000 10912783248 11384369152 1964270416 19.340 99 19 38 0 1984651376 14433760 5947200
18:23:01 38010 8192000000 10913201808 11387711488 1967165968 19.363 99 23 46 3 1991704416 18108624 6429824
18:24:35 115260 8192000000 10904657008 11387940864 1879470496 18.661 95 10 20 0 1900010368 18195504 2344368
18:26:49 139691 8192000000 10867651760 11317735424 1825556976 18.223 92 28 56 0 1844926048 11511152 7857920
18:29:27 37665 8192000000 10855457936 11301748736 1873961184 18.616 97 33 65 1 1891878336 9184336 8732816
18:30:11 37167 8192000000 10861803904 11304239104 1873499120 18.613 97 38 71 3 1892243216 8720640 10023456
18:31:06 89276 8192000000 10853443792 11321888768 1921880720 19.002 99 14 29 0 1935006976 9328304 3797952
18:33:38 60450 8192000000 10852100944 11317899264 1881679248 18.679 97 17 34 1 1894149680 7898592 4571840
18:34:49 53507 8192000000 10863626800 11325259776 1900741120 18.832 98 8 16 0 1912372672 9304048 2327504
18:35:50 36334 8192000000 10846765616 11317448704 1904235536 18.860 99 27 54 1 1919492048 7701040 7555472
18:36:35 29776 8192000000 10867152432 11323777024 1924100880 19.020 99 34 66 0 1945638368 12073760 9463728
18:37:12 36307 8192000000 10882986784 11329626112 1892361600 18.765 97 32 62 2 1916420224 14898032 9160592
18:37:55 85655 8192000000 10871086704 11339567104 1901815536 18.841 98 26 52 1 1931731248 22248880 7666832
18:39:31 82342 8192000000 10866675904 11356336128 1906964976 18.882 98 22 44 0 1936983296 23153568 6864752
18:40:59 65684 8192000000 10891844384 11352637440 1908653216 18.896 97 23 46 2 1928275888 12685824 6936848
18:42:12 37691 8192000000 10901965680 11358543872 1927400688 19.046 98 32 64 3 1953013584 16374064 9238832
18:43:05 39665 8192000000 10906893264 11372007424 1961596048 19.319 100 18 36 0 1983155056 16434288 5124720
18:43:56 57541 8192000000 10891990304 11376918528 1963925488 19.337 100 11 22 0 1985820320 18614272 3280560
18:45:09 90895 8192000000 10898302528 11324366848 1872367488 18.603 95 31 62 3 1891194768 10297024 8530256
18:46:49 80423 8192000000 10892368640 11355267072 1958157184 19.291 100 30 60 1 1977784912 11181824 8445904
18:48:27 89646 8192000000 10874574672 11342295040 1903092912 18.851 97 22 42 0 1917745520 8277328 6375280
18:50:06 6956 8192000000 10900298992 11357364224 1960297216 19.308 100 42 85 1 1980668752 9338512 11033024
18:50:20 13909 8192000000 10883823536 11354570752 1944583744 19.183 99 31 62 0 1964505040 11836880 8084416
18:50:40 11809 8192000000 10877830896 11345444864 1953682928 19.256 100 33 66 0 1974396464 11600000 9113536
18:51:06 86910 8192000000 10865734544 11350167552 1916407152 18.958 98 15 30 1 1933178624 12363296 4408176
18:52:41 35227 8192000000 10874217296 11365212160 1956537120 19.279 100 7 14 2 1971010432 12123200 2350112
18:53:22 23079 8192000000 10864471888 11353133056 1916326832 18.957 98 6 12 0 1930670864 12769424 1574608
18:53:51 72270 8192000000 10879299904 11355734016 1934540816 19.103 99 14 30 1 1951386800 12793520 4052464
18:55:21 61122 8192000000 10863604544 11350323200 1915997936 18.955 98 15 29 1 1932800912 12365024 4437952
18:56:28 62454 8192000000 10879269328 11351687168 1921821984 19.001 98 12 24 0 1931108608 6441984 2844640
18:57:55 83820 8192000000 10893661184 11365744640 1939677840 19.144 99 13 27 1 1956084464 12692656 3713968
18:59:31 73194 8192000000 10898769632 11376332800 1960885712 19.313 99 20 39 1 1976203904 9809920 5508272
19:00:51 65466 8192000000 10917349120 11391922176 1984250672 19.498 100 12 24 1 1996489232 8343696 3894864
19:02:14 45198 8192000000 10917521328 11391066112 1990666352 19.549 100 22 44 1 2010392832 13541120 6185360
19:03:13 62165 8192000000 10920576336 11381047296 1950913856 19.234 98 17 34 0 1964002864 8359536 4729472
19:04:27 19092 8192000000 10931216064 11386621952 1972932512 19.409 99 38 76 0 1992815904 9216800 10666592
19:04:55 15518 8192000000 10934564384 11389014016 1987152752 19.521 100 50 100 1 2013470448 12366784 13950912
19:05:23 12830 8192000000 10944485872 11393806336 1978112976 19.450 99 52 103 1 2003817104 11661248 14042880
19:05:53 10578 8192000000 10938743680 11393359872 1987635600 19.525 100 49 97 0 2013578688 12516336 13426752
19:06:10 13970 8192000000 10921228208 11378126848 1948380832 19.214 98 35 70 0 1973230688 15518064 9331792
19:06:31 49146 8192000000 10934707856 11402612736 1993835840 19.574 100 35 70 1 2018239488 15260672 9142976
19:07:26 90954 8192000000 10927661264 11406643200 1974291888 19.419 99 14 28 0 1988499792 10771488 3436416
19:09:17 42730 8192000000 10912179248 11381690368 1954417728 19.262 98 11 22 1 1968792064 11491792 2882544
19:10:06 65914 8192000000 10912630208 11378991104 1903654912 18.856 96 17 34 1 1925572880 16889008 5028960
19:11:19 102270 8192000000 10899055952 11387412480 1924696416 19.024 97 12 24 0 1944584288 16167648 3720224
19:13:51 49231 8192000000 10910249552 11375243264 1956461296 19.278 99 37 74 1 1977857584 10876240 10520048
19:14:47 45594 8192000000 10868061776 11345354752 1939702096 19.144 98 34 68 1 1960546112 11617072 9226944
19:15:39 30173 8192000000 10872774768 11357843456 1947242112 19.205 99 9 18 0 1956522688 6759936 2520640
19:16:30 63117 8192000000 10872509968 11349479424 1912783760 18.929 97 17 34 1 1926527776 8508784 5235232
19:18:23 64555 8192000000 10849925696 11332349952 1874816288 18.623 96 16 31 0 1890876944 11375248 4685408
19:20:07 52368 8192000000 10868520048 11348557824 1913510736 18.935 98 17 34 1 1929002992 10761472 4730784
19:21:14 101042 8192000000 10863553056 11338997760 1828257200 18.245 93 22 44 0 1849869520 15435696 6176624
19:23:03 62315 8192000000 10850097792 11338752000 1894944832 18.786 98 20 40 1 1913222160 12508192 5769136
19:24:14 45507 8192000000 10855481136 11320012800 1877441200 18.644 97 21 42 0 1890446160 6900960 6104000
19:25:06 35447 8192000000 10855070560 11313770496 1860616416 18.508 96 39 79 1 1882242544 10695632 10930496
19:25:48 105151 8192000000 9261659392 9523134464 398419296 4.637 21 8 14 1 409373440 8371376 2582768

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 10-02-2021 19:28:53 to 10-02-2021 19:29:24.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 120 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:01, from 10-02-2021 19:29:25 to 10-02-2021 19:29:26.

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          243084
MON$OLDEST_ACTIVE               244825
MON$OLDEST_SNAPSHOT             244825
MON$NEXT_TRANSACTION            244825
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                       2029344
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:179: 
:180: mscs-test-161.budzdorov.ru    Wed Feb 10 19:27:39 2021
:181:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:182: 
--- end of diff output ---

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

10.02.21 19:29:27. 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-10 19:29:30 No severe PSQL-related problems occured
10.02.21 19:29:31. End of report.