Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.02.2021 16:32
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 16890468 kB
MemAvailable 31225824 kB
Buffers 0 kB
Cached 14781664 kB
SwapCached 4876 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-01 16:31:33
DTS_END                         2021-02-01 16:31:33.9470
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/43294
TRN_ID                          246064
ATT_ID                          657
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: 9601.43 17642 1152172
customer order: creation 180.08 335 21609
customer order: refuse 15.23 351 1827
order to supplier: creation 47.72 1387 5726
order to supplier: removal 3.62 101984 434
invoice (draft): creation 46.87 3767 5624
invoice (draft): removal 57.53 781 6904
invoice accept: apply 42.51 18466 5101
invoice accept: cancel 51.13 743 6136
customer reserve: creation 3854.63 186 462556
customer reserve: removal 5000.45 57 600054
realization accept: apply 85.76 201 10291
realization accept: cancel 83.06 103 9967
payment from customer: creation 60.94 113 7313
payment from customer: removal 5.86 105 703
payment to supplier: creation 49.65 132 5958
payment to supplier: removal 3.50 85 420
service: total inventory turnovers 5.09 1088 611
service: total monetary turnovers 6.93 29 832
service: aggregate perf. data 0.85 19059 102
service: refresh index statistics 0.03 203875 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-02-2021 16:32:25 to 01-02-2021 16:32:27.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9257
TEST_TIME 2 6771
TEST_TIME 3 5918
TEST_TIME 4 5823
TEST_TIME 5 5865
TEST_TIME 6 5643
TEST_TIME 7 5462
TEST_TIME 8 5710
TEST_TIME 9 5852
TEST_TIME 10 5856
TEST_TIME 11 6117
TEST_TIME 12 6182
TEST_TIME 13 6292
TEST_TIME 14 6248
TEST_TIME 15 6276
TEST_TIME 16 6593
TEST_TIME 17 6972
TEST_TIME 18 7129
TEST_TIME 19 7402
TEST_TIME 20 7350
TEST_TIME 21 7677
TEST_TIME 22 7773
TEST_TIME 23 8355
TEST_TIME 24 8688
TEST_TIME 25 8873
TEST_TIME 26 9314
TEST_TIME 27 9714
TEST_TIME 28 10462
TEST_TIME 29 10761
TEST_TIME 30 10815
TEST_TIME 31 10578
TEST_TIME 32 10400
TEST_TIME 33 10482
TEST_TIME 34 10610
TEST_TIME 35 10674
TEST_TIME 36 10652
TEST_TIME 37 10537
TEST_TIME 38 10376
TEST_TIME 39 10358
TEST_TIME 40 10191
TEST_TIME 41 10190
TEST_TIME 42 10076
TEST_TIME 43 10082
TEST_TIME 44 10046
TEST_TIME 45 10022
TEST_TIME 46 10040
TEST_TIME 47 9974
TEST_TIME 48 9965
TEST_TIME 49 10013
TEST_TIME 50 9969
TEST_TIME 51 9886
TEST_TIME 52 9778
TEST_TIME 53 9705
TEST_TIME 54 9729
TEST_TIME 55 9675
TEST_TIME 56 9569
TEST_TIME 57 9593
TEST_TIME 58 9526
TEST_TIME 59 9598
TEST_TIME 60 9536
TEST_TIME 61 9627
TEST_TIME 62 9679
TEST_TIME 63 9624
TEST_TIME 64 9752
TEST_TIME 65 9730
TEST_TIME 66 9782
TEST_TIME 67 9862
TEST_TIME 68 9794
TEST_TIME 69 9838
TEST_TIME 70 9862
TEST_TIME 71 9851
TEST_TIME 72 9841
TEST_TIME 73 9780
TEST_TIME 74 9792
TEST_TIME 75 9751
TEST_TIME 76 9662
TEST_TIME 77 9668
TEST_TIME 78 9614
TEST_TIME 79 9613
TEST_TIME 80 9527
TEST_TIME 81 9511
TEST_TIME 82 9648
TEST_TIME 83 9611
TEST_TIME 84 9629
TEST_TIME 85 9624
TEST_TIME 86 9631
TEST_TIME 87 9598
TEST_TIME 88 9610
TEST_TIME 89 9617
TEST_TIME 90 9655
TEST_TIME 91 9634
TEST_TIME 92 9731
TEST_TIME 93 9726
TEST_TIME 94 9740
TEST_TIME 95 9771
TEST_TIME 96 9789
TEST_TIME 97 9841
TEST_TIME 98 9801
TEST_TIME 99 9731
TEST_TIME 100 9726
TEST_TIME 101 9698
TEST_TIME 102 9690
TEST_TIME 103 9649
TEST_TIME 104 9599
TEST_TIME 105 9577
TEST_TIME 106 9562
TEST_TIME 107 9504
TEST_TIME 108 9441
TEST_TIME 109 9503
TEST_TIME 110 9603
TEST_TIME 111 9577
TEST_TIME 112 9571
TEST_TIME 113 9563
TEST_TIME 114 9536
TEST_TIME 115 9589
TEST_TIME 116 9578
TEST_TIME 117 9609
TEST_TIME 118 9633
TEST_TIME 119 9616
TEST_TIME 120 9607

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 01-02-2021 16:32:28 to 01-02-2021 16:32:32.

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 1581879 1581879 0 0.00 0 23064 6 0 0
doc_list_biud 1581879 1581879 0 0.00 0 106749 28 0 0
sp_add_invoice_to_stock 5219 5101 118 2.26 28 164076 18467 0 118
sp_cancel_adding_invoice 6136 6136 0 0.00 4 51871 743 0 0
sp_cancel_client_order 1827 1827 0 0.00 4 13507 351 0 0
sp_cancel_customer_reserve 600054 600054 0 0.00 1 37379 58 0 0
sp_cancel_pay_from_customer 703 703 0 0.00 2 7510 105 0 0
sp_cancel_pay_to_supplier 420 420 0 0.00 2 2787 86 0 0
sp_cancel_supplier_invoice 6910 6904 6 0.08 2 106774 781 0 6
sp_cancel_supplier_order 434 434 0 0.00 8 1116599 101984 0 0
sp_cancel_write_off 9967 9967 0 0.00 1 26855 104 0 0
sp_client_order 21609 21609 0 0.00 3 30921 335 0 0
sp_customer_reserve 462556 462556 0 0.00 0 69068 187 0 0
sp_fill_shopping_cart 32955 32955 0 0.00 1 12403 39 0 0
sp_fill_shopping_cart_clo_res 462550 462550 0 0.00 0 11970 10 0 0
sp_get_clo_for_invoice 5095 5095 0 0.00 0 20303 238 0 0
sp_kill_cost_storno 17226 17226 0 0.00 0 6164 53 0 0
sp_kill_qstorno_ret_qs2qd 1217413 1217413 0 0.00 0 106718 31 0 0
sp_kill_qty_storno 640708 640708 0 0.00 0 106736 68 0 0
sp_lock_selected_doc 21450 21450 0 0.00 0 9266 6 0 0
sp_make_cost_storno 28657 28657 0 0.00 0 23060 55 0 0
sp_multiply_rows_for_pdistr 28657 28657 0 0.00 0 6488 32 0 0
sp_multiply_rows_for_qdistr 21609 21609 0 0.00 0 15492 145 0 0
sp_pay_from_customer 7313 7313 0 0.00 4 17836 114 0 0
sp_pay_to_supplier 5958 5958 0 0.00 4 23069 133 0 0
sp_payment_common 13271 13271 0 0.00 1 17825 26 0 0
sp_qd_handle_on_cancel_clo 1827 1827 0 0.00 0 13493 330 0 0
sp_qd_handle_on_invoice_upd_sts 11231 11231 0 0.00 0 17590 318 0 0
sp_qd_handle_on_reserve_upd_sts 10291 10291 0 0.00 0 32208 77 0 0
sp_reserve_write_off 10291 10291 0 0.00 7 32296 202 0 0
sp_supplier_invoice 5624 5624 0 0.00 8 105614 3767 0 0
sp_supplier_order 5726 5726 0 0.00 5 37563 1387 0 0
srv_aggregate_perf_data 102 102 0 0.00 3210 332617 19060 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1249 188342 29745 0 0
srv_find_qd_qs_mism 1104101 1104101 0 0.00 0 10630 5 0 0
srv_make_invnt_saldo 611 611 0 0.00 27 106387 1088 0 0
srv_make_money_saldo 832 832 0 0.00 1 2633 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 50580 350776 203876 0 0
t$perf-abend:sp_add_invoice_to_stock 118 118 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5101 5101 0 0.00 0 11830 175 0 0
t$perf-norm:sp_cancel_adding_invoice 436 436 0 0.00 0 5179 82 0 0
t$perf-norm:sp_cancel_client_order 1827 1827 0 0.00 0 1720 13 0 0
t$perf-norm:sp_cancel_customer_reserve 729 729 0 0.00 0 3095 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 703 703 0 0.00 0 863 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 420 420 0 0.00 0 430 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 458 458 0 0.00 0 12020 48 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 22849 1624 0 0
t$perf-norm:sp_cancel_write_off 1057 1057 0 0.00 0 1363 7 0 0
t$perf-norm:sp_client_order 21609 21609 0 0.00 0 11031 22 0 0
t$perf-norm:sp_customer_reserve 1039 1039 0 0.00 0 5408 14 0 0
t$perf-norm:sp_pay_from_customer 7313 7313 0 0.00 0 8341 15 0 0
t$perf-norm:sp_pay_to_supplier 5958 5958 0 0.00 0 5938 11 0 0
t$perf-norm:sp_reserve_write_off 10291 10291 0 0.00 0 8715 13 0 0
t$perf-norm:sp_supplier_invoice 5624 5624 0 0.00 0 6357 23 0 0
t$perf-norm:sp_supplier_order 5726 5726 0 0.00 0 13304 22 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 366 21 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 336 5 0 0
t$perf-norm:srv_make_invnt_saldo 611 611 0 0.00 0 5189 31 0 0
t$perf-norm:srv_make_money_saldo 832 832 0 0.00 0 2566 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 3 0 0
v_add_invoice_to_stock 10426 10190 236 2.26 0 8203 20 0 236
v_all_customers 39260 39260 0 0.00 0 18 1 0 0
v_all_suppliers 31292 31292 0 0.00 0 20 1 0 0
v_all_wares 43218 43218 0 0.00 0 113 1 0 0
v_cancel_adding_invoice 872 872 0 0.00 0 552 6 0 0
v_cancel_client_order 3654 3654 0 0.00 0 1712 5 0 0
v_cancel_customer_prepayment 1406 1406 0 0.00 0 1104 4 0 0
v_cancel_customer_reserve 1458 1458 0 0.00 0 2830 6 0 0
v_cancel_payment_to_supplier 840 840 0 0.00 0 1031 6 0 0
v_cancel_supplier_invoice 928 916 12 1.29 0 3737 15 0 12
v_cancel_supplier_order 868 868 0 0.00 0 2161 6 0 0
v_cancel_write_off 2114 2114 0 0.00 0 3466 17 0 0
v_max_id_clo_ord 5726 5726 0 0.00 0 1311 2 0 0
v_max_id_clo_res 1039 1039 0 0.00 0 2756 15 0 0
v_max_id_ord_sup 5620 5620 0 0.00 0 5882 10 0 0
v_max_non_paid_invoice 1658 1658 0 0.00 0 1240 4 0 0
v_max_non_paid_realizn 3843 3843 0 0.00 0 1315 5 0 0
v_min_id_clo_ord 5726 5726 0 0.00 0 3485 7 0 0
v_min_id_clo_res 1039 1039 0 0.00 0 8383 17 0 0
v_min_id_ord_sup 5620 5620 0 0.00 0 7003 12 0 0
v_min_non_paid_invoice 5958 5958 0 0.00 0 4145 16 0 0
v_min_non_paid_realizn 7313 7313 0 0.00 0 6531 14 0 0
v_our_firm 10898 10898 0 0.00 0 21 1 0 0
v_reserve_write_off 20582 20582 0 0.00 0 5591 7 0 0
x_lock_depdocs_on_canc_invoice 12582 12582 0 0.00 0 24631 126 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 10763 379 0 0
x_make_qstorno_1000_1200 5726 5726 0 0.00 2 37531 1296 0 0
x_make_qstorno_1200_2000 5624 5624 0 0.00 3 100643 3634 0 0
x_make_qstorno_2100_3300 462556 462556 0 0.00 0 69046 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-02-2021 16:32:33 to 01-02-2021 16:32:37.

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
14:01:37 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:01:43 10887 8192000000 10224814160 10529665024 803823152 8.935 63 54 109 0 824109088 2289136 17996800
14:02:03 38744 8192000000 10331430352 10646540288 1366198320 14.293 100 82 164 0 1397845664 4656416 26990928
14:02:51 19441 8192000000 10355208576 10675752960 1413395952 14.714 100 90 180 0 1449667280 6010240 30261088
14:03:20 25402 8192000000 10385746880 10710986752 1439295024 14.943 100 83 166 0 1474090240 6575280 28219936
14:03:55 23262 8192000000 10414181200 10740867072 1469990640 15.214 100 90 180 0 1506555872 7354416 29210816
14:04:26 20606 8192000000 10428447696 10761265152 1483317440 15.330 100 90 181 0 1521225728 8202544 29705744
14:05:02 24956 8192000000 10453286464 10792308736 1503755664 15.509 100 81 162 0 1538039328 8271232 26012432
14:05:42 10730 8192000000 10469243008 10812264448 1529241632 15.730 100 81 162 0 1562944624 8490624 25212368
14:06:02 16817 8192000000 10503326768 10853199872 1558671728 15.985 100 77 154 0 1591117088 8765280 23680080
14:06:26 24734 8192000000 10539365760 10892271616 1589672768 16.251 100 77 154 0 1622621424 9405792 23542864
14:07:01 12664 8192000000 10573379568 10929844224 1629136224 16.588 100 84 167 1 1664228768 10704800 24387744
14:07:22 11609 8192000000 10602656736 10958872576 1649998080 16.764 100 84 168 3 1686744000 11986944 24758976
14:07:41 10984 8192000000 10612431152 10971484160 1665235072 16.893 100 82 164 1 1701851760 12061376 24555312
14:08:01 9372 8192000000 10611227296 10980515840 1671910016 16.949 100 76 150 1 1706850208 12415984 22524208
14:08:19 7419 8192000000 10636774624 11002716160 1690565728 17.106 100 80 160 1 1726883968 12461040 23857200
14:08:34 6304 8192000000 10639128256 11016396800 1709310928 17.263 100 77 154 1 1743345648 11784432 22250288
14:08:50 7718 8192000000 10668340144 11040550912 1728067392 17.419 100 76 152 1 1761510592 11865280 21577920
14:09:06 8279 8192000000 10681312448 11056263168 1741500272 17.531 100 75 151 0 1775316096 12378784 21437040
14:09:21 6045 8192000000 10685765536 11062575104 1754924864 17.642 100 80 156 2 1790804352 12894736 22984752
14:09:34 5749 8192000000 10700456192 11076702208 1764459280 17.721 100 81 161 0 1800189184 13311472 22418432
14:09:47 4515 8192000000 10717349280 11093254144 1771907744 17.783 100 84 169 1 1809418320 13317344 24193232
14:09:58 4146 8192000000 10718560384 11097325568 1777430272 17.828 100 75 149 0 1810980144 12540880 21008992
14:10:09 3225 8192000000 10726637856 11106803712 1788431632 17.919 100 83 163 2 1824395616 12305296 23658688
14:10:18 3423 8192000000 10741291664 11122528256 1797956336 17.997 100 85 169 4 1834488448 13090112 23442000
14:10:28 2725 8192000000 10750029696 11129335808 1811688608 18.110 100 87 173 0 1848726752 13105184 23932960
14:10:38 1984 8192000000 10753939584 11133038592 1814229456 18.130 100 95 188 1 1853975216 14160192 25585568
14:10:46 5828 8192000000 10752803376 11138678784 1810521904 18.100 100 81 158 0 1846748112 13789536 22436672
14:10:59 2152 8192000000 10768236304 11150372864 1826716928 18.233 100 80 159 0 1862793328 13691168 22385232
14:11:07 2117 8192000000 10767407648 11153608704 1833589168 18.289 100 90 180 2 1873388064 14961616 24837280
14:11:16 2422 8192000000 10783319584 11167612928 1839749968 18.339 100 94 188 4 1879381872 13706992 25924912
14:11:25 2487 8192000000 10787990096 11176194048 1844419792 18.377 100 84 169 1 1882595216 14549792 23625632
14:11:34 1794 8192000000 10791871296 11180404736 1851235728 18.432 100 88 178 0 1889524400 12849552 25439120
14:11:42 2038 8192000000 10799188144 11186638848 1857750656 18.485 100 92 181 0 1895589040 12404912 25433472
14:11:50 1930 8192000000 10805773184 11195154432 1861268960 18.514 100 89 180 1 1898913984 12719408 24925616
14:11:58 1555 8192000000 10810945360 11198074880 1865174352 18.545 100 92 184 0 1904583104 13321728 26087024
14:12:06 1856 8192000000 10814297696 11202441216 1868468656 18.572 100 92 184 1 1909331200 14711136 26151408
14:12:14 1209 8192000000 10814461024 11202887680 1871631232 18.597 100 96 191 2 1912509216 13944368 26933616
14:12:22 1667 8192000000 10811609440 11204657152 1871250464 18.594 100 94 189 3 1912410688 13977600 27182624
14:12:30 6315 8192000000 10802930512 11201269760 1866624256 18.557 100 66 129 0 1897248864 12377216 18247392
14:12:44 18858 8192000000 10805872400 11203575808 1868590512 18.573 100 64 128 2 1898048288 11425408 18032368
14:13:09 7287 8192000000 10796464352 11213152256 1881263088 18.675 100 83 166 0 1917154224 12164928 23726208
14:13:37 20910 8192000000 10770617040 11202363392 1868738944 18.574 100 26 52 1 1882177600 5938080 7500576
14:14:07 10260 8192000000 10783430144 11211141120 1872649392 18.606 100 22 43 0 1885133808 6350672 6133744
14:14:24 11341 8192000000 10777102240 11211399168 1872816688 18.607 100 18 37 0 1883935072 6682288 4436096
14:14:42 8427 8192000000 10787867072 11211640832 1875805520 18.631 100 21 42 0 1888010256 6260992 5943744
14:14:59 10793 8192000000 10791430352 11220262912 1877548992 18.645 100 17 34 2 1887923792 5935600 4439200
14:15:17 10083 8192000000 10788960016 11219070976 1879137264 18.658 100 23 46 3 1892476208 6866336 6472608
14:15:39 10776 8192000000 10791321184 11224002560 1881370944 18.676 100 12 24 0 1890706128 6101936 3233248
14:15:59 12215 8192000000 10788536176 11219869696 1882837984 18.688 100 17 34 1 1893516128 5890160 4787984
14:16:19 7438 8192000000 10793353504 11226529792 1884908432 18.705 100 25 50 2 1898340192 6421984 7009776
14:16:35 11280 8192000000 10794064032 11222970368 1882046400 18.682 100 10 20 0 1890352048 5656640 2649008
14:16:54 12262 8192000000 10794174464 11227422720 1887578656 18.726 100 17 34 2 1898371696 6109664 4683376
14:17:13 10566 8192000000 10790160592 11229458432 1888674288 18.735 100 16 32 1 1899199216 5968352 4556576
14:17:30 26962 8192000000 10803527920 11242872832 1897102272 18.803 100 31 63 1 1911776880 4877728 9796880
14:18:28 30907 8192000000 10804111264 11241455616 1878078480 18.650 99 26 52 2 1892736192 7108256 7549456
14:19:07 5407 8192000000 10811155568 11246297088 1894877760 18.785 100 28 55 3 1909232944 6782640 7572544
14:19:20 5647 8192000000 10828485728 11257688064 1904767168 18.865 100 36 72 1 1922916192 8247856 9901168
14:19:37 3488 8192000000 10825505872 11253284864 1888937328 18.737 99 35 68 3 1905478128 6512464 10028336
14:19:46 5779 8192000000 10820740000 11256422400 1899917280 18.826 100 22 44 2 1912300768 5685920 6697568
14:20:00 7334 8192000000 10819768224 11259727872 1904369552 18.861 100 22 44 0 1916558352 5918864 6269936
14:20:13 7504 8192000000 10819697328 11252899840 1886854608 18.720 99 18 36 0 1898553712 6183776 5515328
14:20:27 5777 8192000000 10823695088 11259953152 1904032848 18.859 100 30 60 1 1919480640 6486240 8961552
14:20:43 10397 8192000000 10812718512 11247509504 1894347024 18.781 100 23 46 0 1906933024 5671280 6914720
14:21:00 7777 8192000000 10801298048 11240226816 1859844496 18.502 98 21 42 0 1871337248 5351216 6141536
14:21:18 7405 8192000000 10803401808 11226324992 1876913056 18.640 99 18 36 0 1887628864 5683536 5032272
14:21:32 6769 8192000000 10811090240 11244314624 1891693200 18.759 100 23 46 0 1904651936 5784688 7174048
14:21:46 9464 8192000000 10780377904 11217620992 1845141712 18.383 98 12 24 0 1853618496 5291376 3185408
14:22:04 8190 8192000000 10723264016 11152576512 1784440176 17.886 95 17 33 0 1794446576 5614560 4391840
14:22:21 37336 8192000000 10748051504 11177394176 1768446096 17.754 95 41 81 2 1786719968 5881200 12392672
14:23:12 25267 8192000000 10717154096 11127349248 1652342176 16.784 89 16 32 0 1661482880 4501536 4639168
14:23:44 7878 8192000000 10734917696 11142246400 1779467696 17.845 98 32 65 1 1793930912 5491120 8972096
14:23:58 8763 8192000000 10717873728 11118292992 1691511872 17.114 93 32 60 1 1705400080 4955392 8932816
14:24:13 8982 8192000000 10694069376 11109150720 1708293936 17.254 94 23 46 2 1720972208 5721952 6956320
14:24:30 9042 8192000000 10712462576 11120308224 1720333952 17.355 95 30 60 2 1734583728 5819936 8429840
14:24:49 6615 8192000000 10717140384 11130597376 1764820352 17.724 98 28 54 2 1778676336 5696944 8159040
14:25:04 6310 8192000000 10687913440 11106955264 1736395760 17.489 97 23 45 1 1749123776 5538576 7189440
14:25:17 6599 8192000000 10699731008 11103244288 1743620176 17.549 97 31 62 0 1758535312 4829408 10085728
14:25:32 5642 8192000000 10700243184 11105853440 1762710752 17.707 99 34 69 0 1777953664 5067280 10175632
14:25:44 7443 8192000000 10708332672 11128397824 1774088576 17.801 99 17 34 1 1785335056 6283040 4963440
14:25:58 5387 8192000000 10730783680 11141795840 1806041008 18.063 100 29 59 0 1821575616 5997152 9537456
14:26:10 8094 8192000000 10734438112 11153326080 1796344480 17.984 99 20 38 2 1808582144 5177360 7060304
14:26:27 10194 8192000000 10736813760 11163291648 1809592688 18.093 99 22 45 2 1822860256 5906832 7360736
14:26:45 10616 8192000000 10738742752 11162804224 1810203888 18.098 99 21 40 0 1820680096 4902800 5573408
14:27:02 69143 8192000000 10752326272 11182514176 1843670080 18.371 100 35 68 3 1859184896 5275936 10238880
14:28:17 11158 8192000000 10761415728 11186360320 1847843120 18.405 100 28 56 1 1862112384 6772528 7496736
14:28:35 8143 8192000000 10767519472 11199016960 1853426928 18.450 100 20 40 1 1864872672 5661744 5784000
14:28:49 8315 8192000000 10782652800 11203514368 1860913968 18.511 100 38 75 0 1878425200 7094480 10416752
14:29:06 9951 8192000000 10768244480 11202416640 1859795888 18.502 100 19 38 1 1870712112 5499408 5416816
14:29:22 9023 8192000000 10777276720 11204550656 1861559776 18.516 100 18 36 0 1873390480 6579392 5251312
14:29:40 8044 8192000000 10782216320 11209531392 1869198464 18.578 100 35 70 0 1886061216 6477104 10385648
14:29:56 7101 8192000000 10796238320 11217522688 1871286080 18.595 100 22 43 2 1884233584 5473056 7474448
14:30:10 6139 8192000000 10795158752 11221762048 1873633632 18.614 100 18 36 1 1883838592 5108384 5096576
14:30:23 5270 8192000000 10800801168 11225485312 1879050368 18.657 100 41 80 0 1897372112 6133872 12187872
14:30:35 8261 8192000000 10781653872 11222171648 1878824368 18.656 100 18 36 0 1890116992 6008432 5284192
14:30:49 6497 8192000000 10787875856 11221581824 1878554896 18.653 100 19 38 0 1890083248 5873264 5655088
14:31:02 5364 8192000000 10807827872 11237306368 1886477824 18.717 100 23 47 2 1898619168 4914352 7226992
14:31:14 12040 8192000000 10821784240 11250556928 1900303104 18.829 100 15 29 1 1909724016 5232208 4188704
14:31:32 8065 8192000000 10832114720 11248414720 1901963776 18.842 100 23 46 1 1913272480 5193120 6115584
14:31:49 16418 8192000000 10852657632 11270094848 1920747408 18.993 100 49 97 3 1942138848 6723312 14668128
14:32:19 60321 8192000000 10858060032 11296194560 1932832176 19.090 100 36 72 2 1952809088 10197392 9779520
14:33:28 25003 8192000000 10879455888 11301654528 1945064880 19.187 100 65 127 4 1970476032 6734368 18676784
14:34:02 4200 8192000000 10887441856 11315027968 1952539680 19.247 100 58 114 0 1977238960 8910512 15788768
14:34:15 12780 8192000000 10902672752 11321020416 1960849968 19.313 100 65 131 2 1989626512 10705168 18071376
14:34:59 5973 8192000000 10899943104 11331403776 1970093552 19.386 100 64 126 5 1998723664 10868240 17761872
14:35:17 9751 8192000000 10905868560 11337035776 1974435024 19.421 100 58 116 1 2001992608 11054128 16503456
14:35:43 8605 8192000000 10914447024 11342098432 1972608464 19.406 100 55 109 1 2001487344 12524832 16354048
14:35:59 17557 8192000000 10918263904 11347476480 1980271312 19.467 100 58 114 1 2009816544 13208576 16336656
14:36:23 20274 8192000000 10920376144 11354722304 1983976064 19.496 100 52 104 2 2011599392 12399680 15223648
14:37:18 16570 8192000000 10906184624 11354873856 1982250624 19.483 100 31 61 1 2003807312 12406880 9149808
14:37:42 9675 8192000000 10917614480 11357851648 1986793456 19.518 100 41 80 1 2011508256 13001632 11713168
14:38:05 12008 8192000000 10930983664 11355754496 1984864800 19.503 100 58 116 1 2015772640 13926064 16981776
14:38:28 5406 8192000000 10929067024 11356958720 1985391184 19.507 100 69 133 3 2020305328 15736128 19178016
14:38:52 3782 8192000000 10938321360 11358674944 1985308256 19.507 100 62 124 4 2018504592 15731280 17465056
14:39:05 20898 8192000000 10941293536 11371077632 1993554064 19.572 100 59 118 1 2030691264 19967872 17169328
14:39:37 20247 8192000000 10930392608 11371048960 1988990064 19.536 100 50 99 4 2022386544 19248720 14147760
14:40:05 7279 8192000000 10934469040 11370299392 1993308112 19.570 100 58 115 2 2027544560 17807808 16428640
14:40:19 7907 8192000000 10940913904 11370029056 1992222736 19.561 100 56 111 0 2027015648 18034240 16758672
14:40:34 11266 8192000000 10947147296 11375767552 1996065296 19.592 100 55 109 0 2031104704 18281680 16757728
14:40:56 2313 8192000000 10940879760 11370405888 1993822416 19.574 100 64 126 0 2031765168 18876784 19065968
14:41:05 6810 8192000000 10922429696 11349610496 1965490864 19.350 99 61 121 2 2000881248 17613776 17776608
14:41:21 14318 8192000000 10936959520 11363573760 1987718768 19.526 100 66 129 2 2026480240 19183952 19577520
14:41:45 11486 8192000000 10936201440 11364384768 1976493152 19.437 99 51 102 0 2012160752 20137744 15529856
14:42:03 2021 8192000000 10928931984 11348303872 1970985568 19.393 99 62 122 1 2007680256 19597344 17097344
14:42:16 12368 8192000000 10945326176 11377745920 1990749088 19.550 100 56 112 2 2025915792 18833728 16332976
14:42:37 3287 8192000000 10954902656 11376295936 1995703616 19.589 100 72 145 0 2039607072 22981776 20921680
14:42:47 9467 8192000000 10936971632 11355152384 1973819072 19.416 99 74 148 1 2019488880 24165664 21504144
14:43:05 3888 8192000000 10955135184 11370999808 1989290368 19.538 100 84 166 2 2039553184 25450352 24812464
14:43:16 14268 8192000000 10928329264 11358584832 1974963120 19.425 99 68 136 1 2021816784 26204256 20649408
14:43:41 11221 8192000000 10947974928 11377270784 1993859984 19.574 100 61 122 1 2037907856 25357776 18690096
14:44:03 20527 8192000000 10962942272 11396837376 2001868304 19.637 100 45 90 3 2044902752 28846960 14187488
14:44:30 4260 8192000000 10975479680 11387256832 1998411440 19.610 100 70 139 2 2049233424 29553184 21268800
14:44:41 5621 8192000000 10963866096 11388047360 1997854192 19.606 100 69 136 2 2049147952 31296768 19996992
14:44:54 4473 8192000000 10968995904 11391549440 1996464576 19.595 100 71 140 2 2050066528 32175744 21426208
14:45:05 6442 8192000000 10964861728 11384545280 1994746512 19.581 100 76 149 0 2047187488 30405664 22035312
14:45:19 4956 8192000000 10949255984 11374292992 1986230288 19.514 100 60 118 1 2037325200 33085376 18009536
14:45:34 9725 8192000000 10950647824 11368706048 1963996880 19.338 99 70 139 2 2019248768 34113968 21137920
14:45:52 8281 8192000000 10935032448 11358212096 1956832816 19.281 99 59 116 1 2012224336 37215872 18175648
14:46:08 8555 8192000000 10937856944 11358466048 1964774416 19.344 100 62 122 2 2021871696 38093216 19004064
14:46:34 12384 8192000000 10934640944 11364560896 1967011920 19.362 100 58 115 0 2024688928 38399360 19277648
14:46:54 2736 8192000000 10950468720 11374661632 1978309616 19.451 100 56 112 3 2035859216 38909472 18640128
14:47:06 3550 8192000000 10975143568 11393732608 1989585232 19.541 100 68 136 3 2053417392 42469392 21362768
14:47:17 1835 8192000000 10973157952 11384229888 1974229664 19.419 99 89 176 1 2043913824 43392608 26291552
14:47:27 3435 8192000000 10958302096 11366408192 1965310416 19.348 99 81 162 1 2035526960 45355744 24860800
14:47:38 2274 8192000000 10976259392 11382214656 1978554976 19.453 100 82 162 1 2049588176 45570256 25462944
14:47:47 4645 8192000000 10939633184 11345408000 1946141360 19.196 99 82 162 1 2020586896 48908720 25536816
14:47:59 1472 8192000000 10965110464 11379249152 1975394944 19.428 100 94 188 2 2053731616 49473824 28862848
14:48:09 3705 8192000000 10941398896 11364134912 1961551600 19.318 100 60 120 0 2025156672 44118512 19486560
14:48:24 8211 8192000000 10946669632 11373637632 1973477776 19.413 100 59 118 2 2033223456 40349936 19395744
14:48:41 1837 8192000000 10946651856 11360882688 1966350416 19.356 99 76 148 2 2029742832 40573200 22819216
14:48:49 1715 8192000000 10936355744 11347230720 1948464272 19.214 99 87 174 0 2016977280 42124640 26388368
14:48:58 3210 8192000000 10962237840 11375431680 1970498960 19.389 100 78 157 1 2038945008 43891440 24554608
14:49:09 2831 8192000000 10962273120 11380793344 1979468816 19.460 100 71 142 2 2045951728 44147232 22335680
14:49:18 2500 8192000000 10971653888 11386392576 1965539024 19.350 99 76 152 1 2039533072 49668752 24325296
14:49:28 6249 8192000000 10969241744 11384451072 1981853920 19.479 100 71 142 0 2047778608 44075392 21849296
14:49:41 4302 8192000000 10969694816 11385049088 1986392624 19.515 100 89 175 1 2059046624 45118624 27535376
14:49:53 1246 8192000000 10972710672 11379879936 1978017968 19.449 100 87 173 3 2050303776 45871008 26414800
14:50:00 3085 8192000000 10969343344 11385638912 1979386192 19.460 100 77 153 1 2049795552 46234976 24174384
14:50:10 2705 8192000000 10970394656 11385016320 1979022448 19.457 100 80 160 1 2049468656 45213344 25232864
14:50:22 3960 8192000000 10947158032 11369103360 1957464224 19.286 99 57 112 0 2017465664 42116512 17884928
14:50:32 4370 8192000000 10965142736 11381354496 1981132368 19.474 100 70 138 0 2044737184 41497744 22107072
14:50:44 2690 8192000000 10960465184 11375759360 1975497776 19.429 100 84 166 1 2045479456 43532064 26449616
14:50:55 2968 8192000000 10974436096 11381788672 1978984832 19.457 100 80 155 0 2047957488 44950080 24022576
14:51:05 2324 8192000000 10973134176 11376115712 1971313216 19.396 100 84 162 1 2045793168 49063760 25416192
14:51:14 2926 8192000000 10977588896 11387248640 1984315232 19.499 100 93 186 0 2062927104 49800240 28811632
14:51:24 3978 8192000000 10978382784 11387482112 1979904832 19.464 100 86 172 0 2058391824 51503376 26983616
14:51:35 11676 8192000000 10979635568 11397689344 1983928480 19.496 100 72 144 1 2059069504 52259872 22881152
14:51:55 3068 8192000000 10976967824 11381506048 1969295520 19.380 99 80 157 1 2047302688 53186336 24820832
14:52:05 3194 8192000000 11003472608 11408560128 1994510880 19.579 100 85 170 2 2075050144 52927936 27611328
14:52:16 1711 8192000000 11006590400 11414327296 1998921984 19.614 100 83 167 3 2080115536 54807920 26385632
14:52:24 1719 8192000000 11013945728 11418689536 2001519248 19.635 100 94 190 2 2088106272 57928864 28658160
14:52:33 3052 8192000000 11007766384 11426025472 1999416096 19.618 100 77 154 3 2083720576 59634720 24669760
14:52:49 10526 8192000000 10981384160 11415212032 1993314560 19.570 100 51 102 0 2063371904 52160800 17896544
14:53:07 9953 8192000000 10978402560 11409936384 1994316624 19.578 100 54 106 1 2065792576 54066256 17409696
14:53:24 10450 8192000000 10976101872 11411017728 1989913168 19.543 100 50 100 0 2061236368 53998800 17324400
14:53:46 3137 8192000000 10975695968 11404578816 1970401776 19.389 99 51 102 2 2044803472 56638848 17762848
14:53:56 5163 8192000000 10989077184 11408084992 1983894368 19.496 100 66 132 3 2062626432 56398480 22333584
14:54:14 7843 8192000000 10965354240 11401404416 1980166176 19.466 100 50 99 1 2049204528 52615488 16422864
14:54:32 7320 8192000000 10974343152 11400912896 1978360176 19.452 100 55 106 0 2052427872 55884096 18183600
14:54:56 26481 8192000000 10960521552 11397898240 1978927344 19.456 100 40 80 2 2047324112 54596816 13799952
14:55:32 24731 8192000000 10960434480 11406860288 1979579072 19.461 100 43 84 2 2046304848 51848864 14876912
14:56:07 10911 8192000000 10968397792 11416059904 1984822880 19.503 100 39 79 2 2052147568 53784096 13540592
14:56:25 7302 8192000000 10958370112 11422117888 1982051968 19.481 100 29 58 1 2052934480 60497312 10385200
14:56:43 17628 8192000000 10947750544 11400986624 1968490832 19.373 100 27 54 0 2031183392 52733984 9958576
14:57:28 38635 8192000000 10917043664 11370811392 1906895440 18.882 97 21 42 3 1963692016 49010192 7786384
14:58:39 65575 8192000000 10874492016 11311558656 1859720256 18.501 96 21 43 1 1908935888 42144096 7071536
14:59:51 4509 8192000000 10902774336 11326717952 1936732048 19.121 100 77 153 0 1980475728 20355952 23387728
15:00:02 6512 8192000000 10876865392 11314200576 1907294960 18.885 99 70 140 0 1951730736 23442608 20993168
15:00:18 15320 8192000000 10860073792 11317198848 1923689120 19.016 100 37 74 0 1949062608 14702928 10670560
15:00:41 57143 8192000000 10840620736 11298955264 1876195072 18.634 97 12 24 0 1894815440 14519664 4100704
15:02:15 49659 8192000000 10913899056 11346067456 1957736688 19.288 100 35 71 1 1981621936 14234336 9650912
15:03:22 31614 8192000000 10899561168 11334758400 1949353344 19.221 99 47 94 3 1974878240 11684528 13840368
15:04:02 32796 8192000000 10878037248 11338588160 1929044848 19.059 99 14 27 0 1950327664 16862848 4419968
15:04:44 46704 8192000000 10880583168 11353985024 1946699280 19.200 100 6 12 0 1967478720 19301216 1478224
15:05:38 188327 8192000000 10872459424 11334553600 1857748752 18.485 95 9 18 1 1874737296 14663792 2324752
15:09:04 33015 8192000000 10928843376 11360886784 1965660512 19.351 100 27 55 2 1985547504 11155424 8731568
15:09:44 76355 8192000000 10913384672 11371970560 1975004880 19.425 100 32 64 3 1994708416 10357536 9346000
15:11:41 45163 8192000000 10915949472 11375824896 1979320912 19.459 100 29 58 3 1996123984 7606800 9196272
15:12:42 58783 8192000000 10943728928 11397902336 1985821008 19.511 100 25 49 0 2002719408 9469376 7429024
15:13:50 75392 8192000000 10922976128 11392430080 1988752544 19.534 100 20 40 0 2005682256 11017392 5912320
15:15:23 11749 8192000000 10911222464 11382415360 1974089408 19.418 99 20 40 0 1991824160 12243728 5491024
15:15:41 4139 8192000000 10943275600 11386994688 1993573344 19.572 100 62 125 2 2019971520 7311008 19087168
15:15:52 62094 8192000000 10896538688 11364917248 1928140848 19.052 97 19 38 0 1941803824 8372976 5290000
15:17:05 41022 8192000000 10914037056 11372662784 1955766864 19.272 99 20 41 2 1969771536 7956320 6048352
15:17:53 39941 8192000000 10920810912 11380895744 1966073920 19.354 99 33 65 0 1987603968 11583872 9946176
15:19:02 21536 8192000000 10944411776 11400634368 1997909728 19.606 100 39 76 0 2023242048 14508416 10823904
15:20:01 51339 8192000000 10918807632 11405176832 1988103472 19.529 100 9 18 0 2005110416 14342800 2664144
15:21:10 98268 8192000000 10910709280 11387879424 1955420800 19.270 98 17 34 1 1970800896 11026256 4353840
15:23:05 57853 8192000000 10909349376 11390726144 1983927248 19.496 100 14 28 0 2000245056 12463792 3854016
15:26:03 43688 8192000000 10892957104 11374632960 1961722448 19.320 99 22 44 1 1978901856 11193312 5986096
15:27:09 26456 8192000000 10882199248 11360169984 1937064960 19.123 98 13 26 0 1950927056 10051952 3810144
15:27:42 69234 8192000000 10887675200 11384111104 1972105520 19.402 100 9 18 2 1985560160 10671264 2783376
15:28:58 40749 8192000000 10881757760 11365814272 1892636448 18.767 96 5 10 0 1906843696 13381984 825264
15:29:51 46736 8192000000 10885912560 11369877504 1941600464 19.160 99 20 40 1 1956882784 9334096 5948224
15:30:54 51377 8192000000 10840163728 11307597824 1810868576 18.103 93 10 20 1 1825599088 12082736 2647776
15:31:53 49168 8192000000 10886495216 11348025344 1924222800 19.021 99 23 46 1 1943370368 12403616 6743952
15:33:24 110530 8192000000 10869613504 11344011264 1820405568 18.181 93 12 24 1 1847098128 23563344 3129216
15:35:21 54379 8192000000 10860330448 11322830848 1870940704 18.592 96 12 24 1 1882165456 7838864 3385888
15:36:21 20868 8192000000 10886172336 11326033920 1887541328 18.726 97 52 104 2 1910535072 7696912 15296832
15:36:50 13067 8192000000 10891230576 11340357632 1941307648 19.157 100 45 90 0 1966693664 12719344 12666672
15:37:16 49509 8192000000 10878494736 11338141696 1904858192 18.865 98 24 48 3 1925779200 13889536 7031472
15:38:37 47455 8192000000 10859809312 11289444352 1849661840 18.419 96 21 41 0 1865603712 10870544 5071328
15:39:32 23895 8192000000 10878236256 11331870720 1933293040 19.093 100 46 92 1 1958584912 11618592 13673280
15:40:16 81078 8192000000 10859548480 11343740928 1894802656 18.784 98 17 34 0 1915291344 15872240 4616448
15:41:44 59325 8192000000 10873483072 11332108288 1847956368 18.406 95 22 44 1 1864010800 9652992 6401440
15:42:53 30821 8192000000 10884700064 11330756608 1900515424 18.830 98 29 58 0 1918889120 9882832 8490864
15:43:36 159917 8192000000 10843361056 11307651072 1839929680 18.340 95 33 66 4 1861305968 12094096 9282192
15:46:25 53125 8192000000 10842647840 11312078848 1888645872 18.735 98 22 44 2 1905055632 9884192 6525568
15:47:31 62567 8192000000 10861748976 11324178432 1889014800 18.738 98 24 48 1 1909377296 11543264 8819232
15:48:47 69813 8192000000 10851467024 11330117632 1902506336 18.846 99 13 26 0 1922638912 16202288 3930288
15:50:36 73517 8192000000 10844452816 11319185408 1877514752 18.645 98 13 26 2 1903157168 21241328 4401088
15:52:27 53368 8192000000 10845509712 11330772992 1894586704 18.783 99 19 38 0 1928859840 27759344 6513792
15:53:27 44004 8192000000 10834012480 11321536512 1911650976 18.920 100 12 23 2 1936048864 20550272 3847616
15:54:33 42024 8192000000 10856207584 11328262144 1894954000 18.786 98 18 36 2 1911183376 11495680 4733696
15:55:21 44875 8192000000 10843273648 11317055488 1851705120 18.436 96 18 36 1 1870871328 13874096 5292112
15:56:12 59812 8192000000 10865096960 11317997568 1903647792 18.856 99 26 52 1 1919215648 7611232 7956624
15:57:21 32913 8192000000 10856591840 11334848512 1936881792 19.122 100 42 84 1 1957810704 9931360 10997552
15:58:01 52368 8192000000 10872596544 11340070912 1922071920 19.003 99 17 34 0 1935849088 8855424 4921744
15:59:03 40097 8192000000 10871727616 11345022976 1921349824 18.998 99 20 40 1 1937433184 10394416 5688944
15:59:52 39354 8192000000 10882910080 11353280512 1941667920 19.160 100 15 30 2 1955108768 9068672 4372176
16:01:22 79652 8192000000 10901240272 11373146112 1950823072 19.233 99 28 56 1 1971808896 13582096 7403728
16:02:49 72304 8192000000 10890518288 11380297728 1909833216 18.905 97 14 28 2 1934176896 20512528 3831152
16:04:07 54382 8192000000 10913460800 11372818432 1931900112 19.082 98 26 52 0 1954912800 15812864 7199824
16:05:12 23906 8192000000 10909573648 11370971136 1963582464 19.335 100 26 52 2 1979774160 9114416 7077280
16:05:43 10802 8192000000 10909432384 11371995136 1961206976 19.316 100 22 44 2 1975683808 8568288 5908544
16:06:03 58098 8192000000 10903576416 11392004096 1954154864 19.260 99 27 54 1 1974864960 13150496 7559600
16:07:09 97441 8192000000 10915666016 11398995968 1937827952 19.129 98 8 15 0 1961400192 21351600 2220640
16:08:53 90247 8192000000 10898149680 11369259008 1937276896 19.125 98 14 28 1 1956630528 15178816 4174816
16:11:02 75715 8192000000 10893786288 11379412992 1956925088 19.282 99 17 34 2 1972527440 10971456 4630896
16:12:25 36701 8192000000 10886991600 11369172992 1956666944 19.280 99 11 21 2 1969518960 9579504 3272512
16:13:23 49567 8192000000 10874287392 11363762176 1943723312 19.176 99 4 8 0 1952476960 7779216 974432
16:14:19 43453 8192000000 10881882000 11360514048 1949065808 19.219 99 15 31 0 1963791120 10374048 4351264
16:15:14 56335 8192000000 10902277344 11386662912 1956663328 19.280 99 18 36 1 1976887984 14913248 5311408
16:16:17 81093 8192000000 10909138544 11381932032 1910664304 18.912 96 18 36 1 1929074400 13368304 5041792
16:19:13 84504 8192000000 10903138368 11390574592 1967484144 19.365 100 18 36 0 1993891024 20732384 5674496
16:21:16 96270 8192000000 10875134960 11365355520 1907444112 18.886 97 9 18 0 1923708736 13885904 2378720
16:22:59 23377 8192000000 10908741648 11360419840 1962189088 19.323 100 52 103 4 1985061600 7027136 15845376
16:24:11 40260 8192000000 10853140064 11326808064 1897077424 18.803 98 23 46 0 1914305280 10162176 7065680
16:25:06 31633 8192000000 10902367728 11348819968 1915357808 18.950 98 49 98 2 1942088880 12162288 14568784
16:25:46 21992 8192000000 10888079280 11348160512 1948903232 19.218 100 49 98 0 1976313504 14297760 13112512
16:26:18 86936 8192000000 10849961104 11318022144 1795224560 17.975 92 27 54 1 1818117216 14787472 8105184
16:27:58 42070 8192000000 10870617568 11329306624 1888858352 18.737 98 34 68 4 1911954624 13083072 10013200
16:29:41 48981 8192000000 10858218592 11325562880 1876435200 18.636 97 26 52 0 1894152384 10753888 6963296
16:30:36 18228 8192000000 10886716560 11345911808 1939375696 19.142 100 35 70 1 1962104096 12752848 9975552
16:31:03 52422 8192000000 9661560896 9996787712 788423264 8.779 41 6 12 1 802887440 12967632 1496544

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 01-02-2021 16:32:38 to 01-02-2021 16:33:10.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 118 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-02-2021 16:33:11 to 01-02-2021 16:33:13.

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          245857
MON$OLDEST_ACTIVE               246986
MON$OLDEST_SNAPSHOT             246986
MON$NEXT_TRANSACTION            246986
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                       2055392
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.33411 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33411 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33411 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33411 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Mon Feb  1 16:31:58 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Mon Feb  1 16:31:59 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
:14: 
:15: mscs-test-161.budzdorov.ru    Mon Feb  1 16:31:59 2021
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:17: 
:18: 
:19: mscs-test-161.budzdorov.ru    Mon Feb  1 16:31:59 2021
:20:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:21: 
:22: 
:23: mscs-test-161.budzdorov.ru    Mon Feb  1 16:31:59 2021
:24:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:25: 
:26: 
:27: mscs-test-161.budzdorov.ru    Mon Feb  1 16:31:59 2021
:28:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:29: 
--- end of diff output ---

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

01.02.21 16:33:14. 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-01 16:33:17 No severe PSQL-related problems occured
01.02.21 16:33:18. End of report.