Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.01.2021 01: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 17205904 kB
MemAvailable 31412128 kB
Buffers 0 kB
Cached 14511000 kB
SwapCached 4864 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-01-10 01:27:12
DTS_END                         2021-01-10 01:27:12.9740
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/39242
TRN_ID                          243243
ATT_ID                          714
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: 9284.88 21397 1114185
customer order: creation 176.31 345 21157
customer order: refuse 14.88 295 1785
order to supplier: creation 47.29 1154 5675
order to supplier: removal 3.58 95483 430
invoice (draft): creation 46.76 3303 5611
invoice (draft): removal 50.75 854 6090
invoice accept: apply 42.56 16798 5107
invoice accept: cancel 46.21 853 5545
customer reserve: creation 3992.34 164 479081
customer reserve: removal 4567.29 59 548075
realization accept: apply 85.16 163 10219
realization accept: cancel 78.04 112 9365
payment from customer: creation 60.71 114 7285
payment from customer: removal 5.99 121 719
payment to supplier: creation 50.86 111 6103
payment to supplier: removal 3.62 58 434
service: total inventory turnovers 4.96 951 595
service: total monetary turnovers 6.72 44 806
service: aggregate perf. data 0.83 21282 99
service: refresh index statistics 0.03 285677 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-01-2021 01:28:50 to 10-01-2021 01:28:52.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1825
TEST_TIME 2 3019
TEST_TIME 3 3470
TEST_TIME 4 3682
TEST_TIME 5 4042
TEST_TIME 6 5227
TEST_TIME 7 5046
TEST_TIME 8 5278
TEST_TIME 9 5240
TEST_TIME 10 5360
TEST_TIME 11 5507
TEST_TIME 12 5528
TEST_TIME 13 5635
TEST_TIME 14 5755
TEST_TIME 15 6341
TEST_TIME 16 6735
TEST_TIME 17 6917
TEST_TIME 18 7447
TEST_TIME 19 8493
TEST_TIME 20 8607
TEST_TIME 21 8678
TEST_TIME 22 8949
TEST_TIME 23 9047
TEST_TIME 24 9283
TEST_TIME 25 9107
TEST_TIME 26 9779
TEST_TIME 27 10746
TEST_TIME 28 11096
TEST_TIME 29 10931
TEST_TIME 30 10799
TEST_TIME 31 10719
TEST_TIME 32 10761
TEST_TIME 33 10718
TEST_TIME 34 10725
TEST_TIME 35 10755
TEST_TIME 36 10553
TEST_TIME 37 10319
TEST_TIME 38 10291
TEST_TIME 39 10169
TEST_TIME 40 10111
TEST_TIME 41 10027
TEST_TIME 42 9917
TEST_TIME 43 10034
TEST_TIME 44 9943
TEST_TIME 45 10055
TEST_TIME 46 10009
TEST_TIME 47 10022
TEST_TIME 48 9938
TEST_TIME 49 9811
TEST_TIME 50 9733
TEST_TIME 51 9692
TEST_TIME 52 9635
TEST_TIME 53 9560
TEST_TIME 54 9510
TEST_TIME 55 9535
TEST_TIME 56 9566
TEST_TIME 57 9564
TEST_TIME 58 9541
TEST_TIME 59 9566
TEST_TIME 60 9547
TEST_TIME 61 9658
TEST_TIME 62 9725
TEST_TIME 63 9823
TEST_TIME 64 9882
TEST_TIME 65 9837
TEST_TIME 66 9891
TEST_TIME 67 9831
TEST_TIME 68 9728
TEST_TIME 69 9741
TEST_TIME 70 9678
TEST_TIME 71 9620
TEST_TIME 72 9627
TEST_TIME 73 9546
TEST_TIME 74 9626
TEST_TIME 75 9590
TEST_TIME 76 9511
TEST_TIME 77 9490
TEST_TIME 78 9496
TEST_TIME 79 9547
TEST_TIME 80 9493
TEST_TIME 81 9494
TEST_TIME 82 9552
TEST_TIME 83 9538
TEST_TIME 84 9631
TEST_TIME 85 9650
TEST_TIME 86 9594
TEST_TIME 87 9602
TEST_TIME 88 9644
TEST_TIME 89 9699
TEST_TIME 90 9692
TEST_TIME 91 9610
TEST_TIME 92 9546
TEST_TIME 93 9532
TEST_TIME 94 9501
TEST_TIME 95 9467
TEST_TIME 96 9461
TEST_TIME 97 9420
TEST_TIME 98 9381
TEST_TIME 99 9421
TEST_TIME 100 9388
TEST_TIME 101 9490
TEST_TIME 102 9507
TEST_TIME 103 9550
TEST_TIME 104 9592
TEST_TIME 105 9554
TEST_TIME 106 9552
TEST_TIME 107 9555
TEST_TIME 108 9570
TEST_TIME 109 9598
TEST_TIME 110 9582
TEST_TIME 111 9509
TEST_TIME 112 9481
TEST_TIME 113 9464
TEST_TIME 114 9462
TEST_TIME 115 9436
TEST_TIME 116 9416
TEST_TIME 117 9401
TEST_TIME 118 9342
TEST_TIME 119 9351
TEST_TIME 120 9287

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-01-2021 01:28:54 to 10-01-2021 01:28:57.

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 1558871 1558871 0 0.00 0 16306 6 0 0
doc_list_biud 1558869 1558869 0 0.00 0 34830 26 0 0
sp_add_invoice_to_stock 5257 5107 150 2.85 45 163344 16799 0 150
sp_cancel_adding_invoice 5545 5545 0 0.00 4 53518 854 0 0
sp_cancel_client_order 1785 1785 0 0.00 4 9584 296 0 0
sp_cancel_customer_reserve 548075 548075 0 0.00 1 30856 60 0 0
sp_cancel_pay_from_customer 719 719 0 0.00 3 26336 122 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 2 5870 59 0 0
sp_cancel_supplier_invoice 6103 6090 13 0.21 2 18384 855 0 13
sp_cancel_supplier_order 430 430 0 0.00 6 1208554 95483 0 0
sp_cancel_write_off 9365 9365 0 0.00 1 17190 113 0 0
sp_client_order 21157 21157 0 0.00 3 32205 346 0 0
sp_customer_reserve 479081 479081 0 0.00 0 102061 164 0 0
sp_fill_shopping_cart 32433 32433 0 0.00 1 24126 40 0 0
sp_fill_shopping_cart_clo_res 479072 479072 0 0.00 0 24585 12 0 0
sp_get_clo_for_invoice 5098 5098 0 0.00 0 38611 296 0 0
sp_kill_cost_storno 16063 16063 0 0.00 0 6636 55 0 0
sp_kill_qstorno_ret_qs2qd 1112035 1112035 0 0.00 0 30851 33 0 0
sp_kill_qty_storno 586605 586605 0 0.00 0 34828 69 0 0
sp_lock_selected_doc 21308 21308 0 0.00 0 7988 5 0 0
sp_make_cost_storno 28704 28704 0 0.00 0 16300 52 0 0
sp_multiply_rows_for_pdistr 28704 28704 0 0.00 0 6457 26 0 0
sp_multiply_rows_for_qdistr 21157 21157 0 0.00 0 20918 159 0 0
sp_pay_from_customer 7285 7285 0 0.00 4 18561 114 0 0
sp_pay_to_supplier 6103 6103 0 0.00 5 10761 112 0 0
sp_payment_common 13387 13387 0 0.00 1 18474 29 0 0
sp_qd_handle_on_cancel_clo 1785 1785 0 0.00 0 9576 273 0 0
sp_qd_handle_on_invoice_upd_sts 10642 10642 0 0.00 0 34824 304 0 0
sp_qd_handle_on_reserve_upd_sts 10218 10218 0 0.00 0 8939 47 0 0
sp_reserve_write_off 10219 10219 0 0.00 6 23566 163 0 0
sp_supplier_invoice 5611 5611 0 0.00 7 116235 3303 0 0
sp_supplier_order 5675 5675 0 0.00 6 38926 1154 0 0
srv_aggregate_perf_data 99 99 0 0.00 2738 294688 21283 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1250 147903 34479 0 0
srv_find_qd_qs_mism 1065474 1065474 0 0.00 0 13475 5 0 0
srv_make_invnt_saldo 595 595 0 0.00 43 41143 952 0 0
srv_make_money_saldo 806 806 0 0.00 1 12537 44 0 0
srv_recalc_idx_stat 4 4 0 0.00 229621 344829 285678 0 0
t$perf-abend:sp_add_invoice_to_stock 150 150 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5107 5107 0 0.00 0 8789 128 0 0
t$perf-norm:sp_cancel_adding_invoice 448 448 0 0.00 0 5149 129 0 0
t$perf-norm:sp_cancel_client_order 1785 1785 0 0.00 0 8011 20 0 0
t$perf-norm:sp_cancel_customer_reserve 736 736 0 0.00 0 1279 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 719 719 0 0.00 0 2201 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 1229 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 396 396 0 0.00 0 1183 15 0 0
t$perf-norm:sp_cancel_supplier_order 430 430 0 0.00 0 21365 1407 0 0
t$perf-norm:sp_cancel_write_off 1047 1047 0 0.00 0 10991 17 0 0
t$perf-norm:sp_client_order 21157 21157 0 0.00 0 6623 16 0 0
t$perf-norm:sp_customer_reserve 1052 1052 0 0.00 0 2450 7 0 0
t$perf-norm:sp_pay_from_customer 7285 7285 0 0.00 0 7373 10 0 0
t$perf-norm:sp_pay_to_supplier 6103 6103 0 0.00 0 9928 11 0 0
t$perf-norm:sp_reserve_write_off 10219 10219 0 0.00 0 6429 10 0 0
t$perf-norm:sp_supplier_invoice 5611 5611 0 0.00 0 7388 22 0 0
t$perf-norm:sp_supplier_order 5675 5675 0 0.00 0 8698 16 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 618 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 2506 20 0 0
t$perf-norm:srv_make_invnt_saldo 595 595 0 0.00 0 1748 17 0 0
t$perf-norm:srv_make_money_saldo 806 806 0 0.00 0 1086 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 67 18 0 0
v_add_invoice_to_stock 10492 10192 300 2.85 0 7254 18 0 300
v_all_customers 38582 38582 0 0.00 0 76 1 0 0
v_all_suppliers 31583 31583 0 0.00 0 375 1 0 0
v_all_wares 42314 42314 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 896 896 0 0.00 0 11337 23 0 0
v_cancel_client_order 3570 3570 0 0.00 0 5136 5 0 0
v_cancel_customer_prepayment 1438 1438 0 0.00 0 26321 27 0 0
v_cancel_customer_reserve 1472 1472 0 0.00 0 22909 19 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 2719 8 0 0
v_cancel_supplier_invoice 818 792 26 3.17 0 1637 15 0 26
v_cancel_supplier_order 860 860 0 0.00 0 1736 7 0 0
v_cancel_write_off 2094 2094 0 0.00 0 11358 19 0 0
v_max_id_clo_ord 5671 5671 0 0.00 0 400 1 0 0
v_max_id_clo_res 1052 1052 0 0.00 0 1948 10 0 0
v_max_id_ord_sup 5603 5603 0 0.00 0 4748 4 0 0
v_max_non_paid_invoice 1584 1584 0 0.00 0 2014 3 0 0
v_max_non_paid_realizn 3915 3915 0 0.00 0 3631 4 0 0
v_min_id_clo_ord 5671 5671 0 0.00 0 1820 4 0 0
v_min_id_clo_res 1052 1052 0 0.00 0 7911 10 0 0
v_min_id_ord_sup 5603 5603 0 0.00 0 6861 14 0 0
v_min_non_paid_invoice 6102 6102 0 0.00 0 5716 14 0 0
v_min_non_paid_realizn 7284 7284 0 0.00 0 12994 19 0 0
v_our_firm 10470 10470 0 0.00 0 27 1 0 0
v_reserve_write_off 20434 20434 0 0.00 0 22911 10 0 0
x_lock_depdocs_on_canc_invoice 11239 11239 0 0.00 0 17783 107 0 0
x_lock_depdocs_on_canc_sup_ord 430 430 0 0.00 0 18585 343 0 0
x_make_qstorno_1000_1200 5675 5675 0 0.00 2 38911 1083 0 0
x_make_qstorno_1200_2000 5611 5611 0 0.00 4 116171 3146 0 0
x_make_qstorno_2100_3300 479081 479081 0 0.00 0 102058 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-01-2021 01:28:58 to 10-01-2021 01:29:02.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:16 8 8192000000 8800796256 8812003328 6918096 0.084 2 1 2 0 7037472 56816 62560
22:57:23 10925 8192000000 10150804736 10446827520 825008672 9.149 67 53 108 0 846231584 2339824 18883088
22:57:44 24400 8192000000 10326772752 10645225472 1374409264 14.367 100 87 175 0 1407688208 4417456 28861488
22:58:16 34825 8192000000 10385404064 10710233088 1425842016 14.824 100 81 161 1 1456791648 5375024 25574608
22:59:00 21463 8192000000 10419054000 10748645376 1464395696 15.165 100 89 178 0 1500047568 6675504 28976368
22:59:30 21603 8192000000 10438740704 10775449600 1492140048 15.408 100 84 168 0 1526629168 7862896 26626224
23:00:02 25505 8192000000 10471777136 10809757696 1522644128 15.673 100 91 182 0 1560398048 8712288 29041632
23:00:34 19210 8192000000 10480612016 10821885952 1538330080 15.809 100 87 174 0 1575149488 9747984 27071424
23:01:06 10082 8192000000 10496865792 10842902528 1556555328 15.967 100 90 181 0 1594468720 10201904 27711488
23:01:26 14962 8192000000 10519167056 10870968320 1574833008 16.124 100 83 166 0 1610479536 10531296 25115232
23:01:50 13843 8192000000 10553419488 10903482368 1599114064 16.332 100 81 162 0 1634234688 10946416 24174208
23:02:13 12470 8192000000 10573443616 10928447488 1621983792 16.527 100 83 166 0 1658747200 12074880 24688528
23:02:34 14733 8192000000 10582533488 10942828544 1641574816 16.693 100 83 166 1 1678103776 12105856 24423104
23:02:59 13935 8192000000 10595848720 10958807040 1657618384 16.829 100 81 162 0 1693733424 12481360 23633680
23:03:25 9866 8192000000 10606284688 10975014912 1674782800 16.973 100 80 160 2 1710292640 12641136 22868704
23:03:48 9343 8192000000 10639783520 11008946176 1695500496 17.147 100 83 166 2 1732630832 13394224 23736112
23:04:06 10613 8192000000 10652802240 11021754368 1706317056 17.238 100 86 172 1 1744813792 13642256 24854480
23:04:24 7084 8192000000 10656078672 11026546688 1714850256 17.309 100 81 161 0 1751711312 13625264 23235792
23:04:38 7155 8192000000 10668836192 11045662720 1728299264 17.421 100 79 158 0 1763782224 13204064 22278896
23:04:52 6663 8192000000 10690000416 11064516608 1747688144 17.582 100 81 162 0 1783509712 12348560 23473008
23:05:07 5489 8192000000 10691609168 11072004096 1750067408 17.602 100 72 140 1 1781533904 11753072 19713424
23:05:21 4090 8192000000 10700085296 11079852032 1761614448 17.698 100 86 170 2 1797335968 11289152 24432368
23:05:32 3567 8192000000 10714149216 11089289216 1771846736 17.782 100 88 172 1 1808879728 12382144 24650848
23:05:42 4366 8192000000 10718790624 11101876224 1785191712 17.892 100 85 168 4 1821587424 12451712 23944000
23:05:54 5530 8192000000 10721448064 11109855232 1788890976 17.923 100 72 144 0 1820966816 11614880 20460960
23:06:08 2671 8192000000 10727082448 11113496576 1797531936 17.994 100 84 168 1 1833973904 12268320 24173648
23:06:16 2631 8192000000 10742045584 11127173120 1806913648 18.071 100 88 175 4 1843035168 12009296 24112224
23:06:25 2523 8192000000 10755291424 11138928640 1813617760 18.125 100 84 169 0 1850117248 12364768 24134720
23:06:35 8614 8192000000 10751684464 11140804608 1817540656 18.158 100 80 160 0 1854387664 13497152 23349856
23:06:50 4181 8192000000 10756124032 11147603968 1820943392 18.185 100 77 154 1 1854721984 12917152 20861440
23:07:01 2288 8192000000 10782530848 11164278784 1836780000 18.315 100 85 170 2 1873054528 12316896 23957632
23:07:10 2503 8192000000 10787791408 11172921344 1843720784 18.371 100 91 183 1 1882294656 13786176 24787696
23:07:19 1965 8192000000 10791135456 11178610688 1846499712 18.394 100 90 181 0 1885566032 14146592 24919728
23:07:28 2540 8192000000 10789859648 11178098688 1846964160 18.397 100 88 176 3 1885752960 14730160 24058640
23:07:36 2136 8192000000 10803512960 11190181888 1854654592 18.460 100 95 191 0 1896826128 14824336 27347200
23:07:45 1753 8192000000 10804693008 11191627776 1858123408 18.488 100 84 166 1 1894725472 12569376 24032688
23:07:53 2616 8192000000 10810966352 11196727296 1866959744 18.560 100 91 182 1 1906325408 13607648 25758016
23:08:02 1251 8192000000 10814197744 11202187264 1870434336 18.588 100 92 184 1 1908945552 12650416 25860800
23:08:10 1472 8192000000 10808002704 11199270912 1866360064 18.555 100 84 166 0 1902939152 13467424 23111664
23:08:18 1725 8192000000 10816424544 11204882432 1870973312 18.592 100 93 186 3 1909931520 12891696 26066512
23:08:26 3816 8192000000 10798476528 11197890560 1871544720 18.597 100 78 156 0 1906693168 12934880 22213568
23:08:36 8842 8192000000 10809236048 11201433600 1869709312 18.582 100 71 140 4 1900371616 11332048 19330256
23:08:51 4410 8192000000 10804016992 11205054464 1872642448 18.606 100 64 128 1 1900805088 10516752 17645888
23:09:04 8831 8192000000 10813064576 11205476352 1874056480 18.617 100 80 159 0 1908750928 11789248 22905200
23:09:20 15463 8192000000 10782779088 11207307264 1873301648 18.611 100 66 133 0 1903815744 11486368 19027728
23:09:55 5601 8192000000 10792411504 11209306112 1871008016 18.592 100 40 80 2 1889253200 6795664 11449520
23:10:10 7534 8192000000 10787409376 11205271552 1871295808 18.595 100 27 54 0 1885789216 6864816 7628592
23:10:25 4712 8192000000 10791608272 11214073856 1876385616 18.636 100 35 71 0 1899279104 12439264 10454224
23:10:40 6567 8192000000 10783745696 11210711040 1877972752 18.649 100 27 54 3 1892973520 7771488 7229280
23:10:54 6420 8192000000 10793598880 11214946304 1880642816 18.670 100 41 82 0 1899941904 8019360 11279728
23:11:07 6885 8192000000 10788902336 11214962688 1878958160 18.657 100 23 46 3 1891707824 5864176 6885488
23:11:20 8817 8192000000 10797187088 11221946368 1882257808 18.683 100 20 40 0 1894079936 6072512 5749616
23:11:40 8461 8192000000 10787294416 11218341888 1883892720 18.697 100 21 42 1 1896791600 6554720 6344160
23:12:00 5510 8192000000 10791731584 11222331392 1885324800 18.708 100 28 56 2 1899698080 6030656 8342624
23:12:11 11896 8192000000 10786255024 11219091456 1883352688 18.692 100 18 36 1 1894804032 6569680 4881664
23:12:29 11620 8192000000 10789193552 11225337856 1883838368 18.696 100 13 26 0 1893176288 5421744 3916176
23:12:47 10935 8192000000 10787280016 11227922432 1891124752 18.755 100 24 48 0 1905184240 7777056 6282432
23:13:09 14562 8192000000 10805208544 11230572544 1892146592 18.763 100 31 62 0 1906733472 4875872 9711008
23:13:33 64089 8192000000 10846754416 11247366144 1896877200 18.801 100 54 108 0 1918757856 5518432 16362224
23:14:44 6112 8192000000 10813592672 11247878144 1895347072 18.789 100 36 72 0 1913504896 8439776 9718048
23:14:56 9354 8192000000 10815129184 11244867584 1897478592 18.806 100 31 63 1 1912745600 5930096 9336912
23:15:15 4061 8192000000 10827218016 11249061888 1899699392 18.824 100 35 68 1 1916575872 7321744 9554736
23:15:27 9090 8192000000 10806750704 11244220416 1894725168 18.784 100 19 38 1 1906527664 6854128 4948368
23:15:44 6556 8192000000 10805314352 11227185152 1857262976 18.481 98 27 54 0 1870517312 5338960 7915376
23:15:58 6754 8192000000 10800200560 11238674432 1894674384 18.783 100 31 63 2 1909519424 5681856 9163184
23:16:16 8077 8192000000 10816686704 11238109184 1893798064 18.776 100 28 56 0 1907736256 5675120 8263072
23:16:30 8845 8192000000 10790196336 11231150080 1872879056 18.608 99 14 28 0 1882759696 6314656 3565984
23:16:47 9025 8192000000 10800846896 11233316864 1886804528 18.720 100 16 32 1 1897244624 5907088 4533008
23:17:02 12804 8192000000 10776669680 11215015936 1817940048 18.161 96 12 24 1 1826682816 5414432 3328336
23:17:23 11687 8192000000 10769983792 11203158016 1850909056 18.430 99 19 38 1 1862468448 5973936 5585456
23:18:18 21097 8192000000 10757423872 11192426496 1775854912 17.815 95 22 43 2 1787880000 6159424 5865664
23:18:46 9386 8192000000 10761536816 11183194112 1792782912 17.955 97 27 52 0 1806687152 6536144 7368096
23:19:01 8153 8192000000 10771183008 11181121536 1806096672 18.064 98 33 66 0 1821808016 6085888 9625456
23:19:20 8109 8192000000 10748852000 11163656192 1817560064 18.158 99 24 48 3 1830244928 5560768 7124096
23:19:34 5672 8192000000 10685948400 11096190976 1748773088 17.591 96 24 45 2 1760816528 4765568 7277872
23:19:46 7731 8192000000 10741414368 11161292800 1821373744 18.189 100 24 48 0 1834042656 5952992 6715920
23:20:00 7248 8192000000 10731780224 11148484608 1772317712 17.786 97 23 46 1 1783734272 4667568 6748992
23:20:14 6940 8192000000 10710485040 11123601408 1782625296 17.871 99 33 67 1 1798482320 6376384 9480640
23:20:29 7106 8192000000 10667845968 11075649536 1686584768 17.073 95 21 43 0 1697976208 5084320 6307120
23:20:42 10519 8192000000 10671959808 11087974400 1725412288 17.397 97 18 37 2 1736012208 5561088 5038832
23:20:59 7681 8192000000 10696507856 11103207424 1709386048 17.264 95 26 52 0 1722330336 5513408 7430880
23:21:14 11405 8192000000 10697405360 11115999232 1752321248 17.621 98 17 34 0 1762809712 5701040 4787424
23:21:38 9078 8192000000 10714507808 11129630720 1765543504 17.730 98 18 36 1 1776671184 5327760 5799920
23:21:53 9674 8192000000 10732790560 11143585792 1808034080 18.080 100 30 60 0 1823136832 6296560 8806192
23:22:41 35286 8192000000 10697866144 11126210560 1747943184 17.585 96 25 49 0 1760807280 5382464 7481632
23:23:22 5950 8192000000 10723488320 11140460544 1773432640 17.795 98 20 40 0 1784835552 5570576 5832336
23:23:35 6988 8192000000 10740955024 11163127808 1829915648 18.259 100 30 58 1 1845205920 6995888 8294384
23:23:51 3279 8192000000 10746629920 11171209216 1832574208 18.280 100 25 50 1 1846428512 6271168 7583136
23:24:03 8818 8192000000 10756248848 11182833664 1845269824 18.384 100 24 48 0 1858371568 6273376 6828368
23:24:20 7083 8192000000 10770632384 11193139200 1847315600 18.400 100 18 36 1 1857657248 5213632 5128016
23:24:35 8129 8192000000 10761577760 11189112832 1848339968 18.409 100 28 56 2 1862890688 6395296 8155424
23:24:51 5003 8192000000 10764670896 11193368576 1851286112 18.433 100 23 46 3 1864379984 6822800 6271072
23:25:02 8922 8192000000 10759726240 11193499648 1854805056 18.461 100 32 64 1 1870029120 6068704 9155360
23:25:22 15131 8192000000 10771603520 11199979520 1857279280 18.481 100 18 36 0 1868193920 5541712 5372928
23:25:44 10367 8192000000 10766628720 11204014080 1860266928 18.505 100 18 36 0 1871621648 5496496 5858224
23:26:01 7307 8192000000 10786529232 11210608640 1867543280 18.564 100 28 56 0 1881281776 4693792 9044704
23:26:18 6727 8192000000 10780701744 11212460032 1867336848 18.563 100 17 34 0 1878020160 5546464 5136848
23:26:31 8031 8192000000 10778384640 11214675968 1874684224 18.622 100 22 42 4 1887030672 5597456 6748992
23:26:48 8908 8192000000 10782690032 11216494592 1871651856 18.598 100 15 30 1 1881782896 6056448 4074592
23:27:06 126847 8192000000 10838475888 11260207104 1900973792 18.834 100 37 74 3 1917650528 5632320 11044416
23:29:25 7944 8192000000 10845537376 11266273280 1915953248 18.954 100 49 95 1 1938329952 8618048 13758656
23:29:40 3667 8192000000 10859872512 11277004800 1920199088 18.988 100 49 97 0 1942506816 8411168 13896560
23:29:51 40276 8192000000 10850786416 11283881984 1931558496 19.079 100 44 88 2 1953716192 9610528 12547168
23:30:48 6916 8192000000 10878071408 11300646912 1939751120 19.145 100 39 75 1 1961998160 10578656 11668384
23:31:02 4495 8192000000 10887503232 11308384256 1949349680 19.221 100 63 126 0 1980050752 11796592 18904480
23:31:15 36387 8192000000 10888836752 11316514816 1952197104 19.244 100 52 104 2 1980772464 14090080 14485280
23:31:59 10720 8192000000 10914650144 11325632512 1958364064 19.293 100 59 119 0 1990289008 14875696 17049248
23:32:29 14987 8192000000 10908520336 11333197824 1960973312 19.314 100 57 114 0 1993859824 15786816 17099696
23:33:00 44557 8192000000 10899128768 11342118912 1965614208 19.351 100 50 100 1 2000003904 19512128 14877568
23:33:54 22092 8192000000 10909781344 11350339584 1970370352 19.388 100 34 66 2 1996072016 16175184 9526480
23:34:24 33925 8192000000 10918866448 11356925952 1958360160 19.293 99 44 88 0 1990362416 19125168 12877088
23:35:09 14147 8192000000 10931368000 11371421696 1985384128 19.507 100 40 80 0 2021393824 23802560 12207136
23:35:39 15726 8192000000 10945546448 11379523584 1997100496 19.600 100 53 106 0 2034523664 21416304 16006864
23:36:07 5181 8192000000 10953660128 11376799744 1986127488 19.513 99 60 120 2 2023265136 20042640 17095008
23:36:20 10328 8192000000 10945014528 11371802624 1979449184 19.460 99 56 112 0 2018198352 21889056 16860112
23:36:37 12530 8192000000 10938843968 11366563840 1974255856 19.419 99 65 130 1 2016016000 23023280 18736864
23:37:06 1739 8192000000 10941627984 11369488384 1989347984 19.539 100 60 120 1 2029644976 22844832 17452160
23:37:15 2065 8192000000 10954335472 11375665152 1996313584 19.594 100 78 159 1 2042735104 22139056 24282464
23:37:24 8497 8192000000 10951018432 11378601984 1999781152 19.621 100 60 120 1 2040053360 22335744 17936464
23:37:45 10078 8192000000 10948527664 11388096512 2002396960 19.642 100 55 110 1 2041459328 22706960 16355408
23:38:02 2239 8192000000 10983751664 11400069120 2013145696 19.726 100 81 159 1 2061965712 23906704 24913312
23:38:11 3602 8192000000 10973140784 11400765440 2012964336 19.725 100 71 142 0 2060142208 25373296 21804576
23:38:21 7960 8192000000 10962883296 11387707392 1995780048 19.589 99 68 136 0 2043569088 26810656 20978384
23:38:36 11228 8192000000 10971625872 11402731520 2010999728 19.709 100 58 116 2 2057789744 29099536 17690480
23:39:03 3601 8192000000 10972871392 11403829248 1999895376 19.622 99 63 125 1 2049938896 30549936 19493584
23:39:15 5799 8192000000 10980118192 11404238848 2017451024 19.760 100 66 130 1 2065776480 28560352 19765104
23:39:30 1284 8192000000 10980722128 11397767168 1998407216 19.610 99 77 152 0 2052659328 30506048 23746064
23:39:38 2064 8192000000 10982528496 11409842176 2017242880 19.758 100 69 138 1 2069999856 32322912 20434064
23:39:48 1898 8192000000 11000681088 11424399360 2028918976 19.850 100 78 156 0 2087308528 33457920 24931632
23:39:58 3066 8192000000 11005886016 11429392384 2034411056 19.893 100 76 153 1 2092932544 34991008 23530480
23:40:13 3489 8192000000 11010528096 11436335104 2033528368 19.886 100 75 149 2 2091413776 35108928 22776480
23:40:27 10797 8192000000 11005054112 11436351488 2030204736 19.860 100 62 124 0 2087257808 37532464 19520608
23:40:49 5232 8192000000 11002473872 11434008576 2030006160 19.859 100 72 145 0 2093211488 40509392 22695936
23:41:04 4453 8192000000 11010925328 11441471488 2031895744 19.873 100 66 132 1 2096122608 42401008 21825856
23:41:19 5456 8192000000 11018835488 11443605504 2030877040 19.866 100 66 132 1 2095214624 42949440 21388144
23:41:32 1963 8192000000 11011968640 11437809664 2032206304 19.876 100 75 150 3 2099395120 42143216 25045600
23:41:41 2138 8192000000 11021976608 11445805056 2033941888 19.890 100 77 155 0 2103213360 44589360 24682112
23:41:55 6967 8192000000 11026619296 11454758912 2035395344 19.901 100 70 140 1 2108448672 50681888 22371440
23:42:09 16032 8192000000 11017441312 11447586816 2031004512 19.867 100 66 130 0 2099744896 47254784 21485600
23:42:33 12728 8192000000 11005273696 11442872320 2013492832 19.729 99 62 122 0 2075964336 42752720 19718784
23:42:52 2964 8192000000 11017059936 11447971840 2036067184 19.906 100 79 159 0 2107284928 44752928 26464816
23:43:03 3766 8192000000 11018725232 11448532992 2034117584 19.891 100 78 156 1 2103711136 44629088 24964464
23:43:13 3958 8192000000 11014745136 11437350912 2027542448 19.839 100 78 152 1 2096369840 44647264 24180128
23:43:24 2754 8192000000 11025072032 11440328704 2028106688 19.844 100 84 168 2 2102652608 47440240 27105680
23:43:35 5624 8192000000 11015512544 11430453248 2015860256 19.748 100 84 167 0 2089976528 48214064 25902208
23:43:47 1599 8192000000 11016285856 11436691456 2019162512 19.774 100 88 175 2 2095009264 49352272 26494480
23:43:57 1685 8192000000 11017433504 11435704320 2022202656 19.797 100 83 166 1 2095601488 47148288 26250544
23:44:05 1247 8192000000 11022742560 11443392512 2030800176 19.865 100 90 180 3 2111530912 52830240 27900496
23:44:13 3230 8192000000 11025601744 11442970624 2010722960 19.707 99 78 156 1 2084664208 49693040 24248208
23:44:23 3897 8192000000 11008906832 11435479040 2006816032 19.676 99 79 158 1 2081540688 50100464 24624192
23:44:35 3715 8192000000 10994916608 11415531520 1997585264 19.604 99 80 160 0 2072532736 49824016 25123456
23:44:49 2061 8192000000 11008144752 11423113216 2002900128 19.646 100 94 184 3 2085231648 53797216 28534304
23:45:00 3473 8192000000 10976313024 11389812736 1953400096 19.254 98 76 153 0 2034519872 55825024 25294752
23:45:10 4125 8192000000 10994894848 11416907776 1991331296 19.554 100 83 166 4 2077533808 59254368 26948144
23:45:23 9379 8192000000 10953159888 11394576384 1962840976 19.329 99 49 98 0 2031099520 51979744 16278800
23:45:40 6068 8192000000 10952669008 11383734272 1962184272 19.323 99 53 106 2 2030927440 50536992 18206176
23:46:06 2352 8192000000 10978949568 11400671232 1985438800 19.508 100 69 133 1 2058463472 50857152 22167520
23:46:16 4514 8192000000 10972939424 11400503296 1982776992 19.487 100 70 136 2 2049218256 45521248 20920016
23:46:28 4831 8192000000 10959178400 11393187840 1976999616 19.441 100 56 111 3 2041315792 46609392 17706784
23:46:41 13323 8192000000 10934085040 11376930816 1947779776 19.209 99 40 80 3 2007512144 46521680 13210688
23:47:07 16656 8192000000 10918844656 11373240320 1949367872 19.221 99 23 46 2 1990647136 33725120 7554144
23:47:41 5172 8192000000 10923039008 11364986880 1957779824 19.288 100 42 84 0 2004426432 32683520 13963088
23:47:58 16039 8192000000 10900807600 11338313728 1930272672 19.069 98 36 72 2 1974877408 33200352 11404384
23:48:23 11216 8192000000 10917053552 11353440256 1921136656 18.996 98 34 68 2 1968824256 37209840 10477760
23:48:40 12331 8192000000 10913768832 11357192192 1951092368 19.235 100 40 80 1 2005026256 41360832 12573056
23:49:01 12624 8192000000 10911644544 11343867904 1910548448 18.911 98 34 67 1 1963767376 42038736 11180192
23:49:20 5878 8192000000 10934160944 11368140800 1953911232 19.258 100 44 89 1 2013343152 45321664 14110256
23:49:35 15762 8192000000 10916534832 11365810176 1921785456 19.001 98 29 58 1 1978448672 46693152 9970064
23:50:09 19118 8192000000 10916103968 11357974528 1924630944 19.024 99 29 58 1 1982197312 47225280 10341088
23:50:39 14996 8192000000 10919085808 11364384768 1944743664 19.185 100 26 52 2 1999941632 46207744 8990224
23:51:14 17971 8192000000 10909662672 11351040000 1914177680 18.940 99 32 64 0 1971704224 46904816 10621728
23:51:42 28541 8192000000 10906221264 11356975104 1918063392 18.971 99 23 46 0 1979776304 53348288 8364624
23:52:17 17161 8192000000 10913035328 11355541504 1913580624 18.935 99 24 48 1 1977187456 54555792 9051040
23:52:42 33539 8192000000 10911830576 11363733504 1922710416 19.009 99 27 53 2 1991666640 59357952 9598272
23:53:22 19020 8192000000 10915601936 11374497792 1937772928 19.129 100 26 52 2 2004024640 56294000 9957712
23:53:49 36287 8192000000 10886964128 11351506944 1912684096 18.928 99 15 30 0 1961492832 43012752 5795984
23:54:33 46543 8192000000 10824426896 11287515136 1821069872 18.186 95 16 32 1 1848164112 22342912 4751328
23:55:25 50066 8192000000 10829930656 11286773760 1882910560 18.689 99 7 13 0 1893132112 8117904 2103648
23:56:22 92417 8192000000 10856075120 11305209856 1884116112 18.698 98 37 74 2 1903066864 7882768 11067984
23:58:09 34404 8192000000 10838890880 11279126528 1837894208 18.324 95 16 32 1 1849273808 7322992 4056608
23:58:50 90088 8192000000 10881811008 11327045632 1907476064 18.886 99 12 25 0 1920292768 9706160 3110544
00:00:27 57039 8192000000 10877126208 11344605184 1938712880 19.136 100 14 28 1 1956704448 14561472 3430096
00:02:01 147899 8192000000 10885582368 11337826304 1913519120 18.935 98 20 40 1 1933893600 14088336 6286144
00:04:40 37753 8192000000 10899505728 11343486976 1940125024 19.148 99 48 95 0 1963642672 8848640 14669008
00:05:30 37243 8192000000 10897966736 11345035264 1942822832 19.169 99 59 117 0 1967775152 8388992 16563328
00:06:18 136657 8192000000 10891226464 11357110272 1950424656 19.230 99 16 32 0 1968753712 13700672 4628384
00:08:41 46973 8192000000 10931660768 11381714944 1976446384 19.437 100 38 74 1 1999542000 12361936 10733680
00:09:37 32933 8192000000 10920015632 11369406464 1942585024 19.167 98 41 81 0 1968889984 15239776 11065184
00:10:51 32288 8192000000 10916782224 11377176576 1975317696 19.428 100 36 72 1 2002784032 16681776 10784560
00:11:34 35950 8192000000 10909017056 11378466816 1976598960 19.438 100 22 44 1 1999255840 16430880 6226000
00:12:39 29851 8192000000 10904372048 11393695744 1979153536 19.458 100 7 14 0 1994336160 12610832 2571792
00:13:15 43938 8192000000 10917086224 11388776448 1982035072 19.481 100 14 28 0 1998995040 12975744 3984224
00:14:10 52851 8192000000 10903432864 11385446400 1963822288 19.336 99 21 42 1 1983384000 13305968 6255744
00:15:09 22489 8192000000 10885511504 11351326720 1943889104 19.178 98 23 47 0 1956717744 6673808 6154832
00:15:38 70313 8192000000 10884395600 11368345600 1973760976 19.415 100 15 30 0 1985865136 7953664 4150496
00:17:10 54642 8192000000 10902180208 11379445760 1975300816 19.427 100 21 42 1 1990042608 9208288 5533504
00:18:11 32485 8192000000 10899420960 11388043264 1982323264 19.483 100 19 38 0 1998525360 11003808 5198288
00:18:53 30844 8192000000 10902227792 11386966016 1983830704 19.495 100 4 8 0 1996335776 11492400 1012672
00:19:42 60500 8192000000 10896737296 11387359232 1964331936 19.340 99 11 22 1 1975885152 8233184 3320032
00:20:48 47547 8192000000 10890498032 11373195264 1925230256 19.029 97 11 22 1 1938934736 9532992 4171488
00:21:42 57071 8192000000 10902432784 11391336448 1962549152 19.326 99 18 36 1 1977357648 9598528 5209968
00:22:45 45004 8192000000 10901195264 11383214080 1962821840 19.328 99 10 20 1 1980018192 14346560 2849792
00:23:48 33310 8192000000 10914298352 11384180736 1970307216 19.388 99 32 64 0 1988513520 9238688 8967616
00:24:29 24224 8192000000 10907653712 11368488960 1931122240 19.076 97 29 59 1 1948366704 8953296 8291168
00:25:06 41170 8192000000 10929018064 11397017600 1974365840 19.420 99 26 52 1 1995170544 13258320 7546384
00:25:56 57032 8192000000 10885529168 11365318656 1885217232 18.707 95 14 28 0 1905757168 16602528 3937408
00:27:03 52785 8192000000 10880975104 11333140480 1864047968 18.536 95 19 38 0 1890390848 20604240 5738640
00:28:03 49610 8192000000 10888538384 11344109568 1905925792 18.874 98 20 40 1 1922351952 11104112 5322048
00:28:59 68899 8192000000 10864872640 11341189120 1886996464 18.722 97 21 42 1 1913120288 19932656 6191168
00:30:15 45965 8192000000 10887710560 11358367744 1920945984 18.994 98 19 36 1 1937440784 11800416 4694384
00:31:15 71733 8192000000 10891676032 11334107136 1820211328 18.179 93 21 42 0 1840639632 15231184 5197120
00:32:40 73351 8192000000 10879311440 11320893440 1832488800 18.280 94 16 32 0 1847828928 10437264 4902864
00:34:00 14077 8192000000 10865400672 11316846592 1912820880 18.929 99 21 42 1 1926572592 8074032 5677680
00:34:28 19329 8192000000 10859114288 11300384768 1875120672 18.626 97 56 112 1 1900940576 9616144 16203760
00:34:55 83555 8192000000 10883679408 11318403072 1912952304 18.930 99 46 92 0 1938024208 11779632 13292272
00:36:32 99174 8192000000 10846938784 11319996416 1884654272 18.703 97 24 48 4 1900432224 8945040 6832912
00:38:19 10705 8192000000 10876235600 11328970752 1938419520 19.134 100 53 106 1 1961701920 7960528 15321872
00:38:38 46695 8192000000 10870212016 11336552448 1918877392 18.978 98 38 76 1 1942091824 12468816 10745616
00:39:50 75310 8192000000 10863582608 11340894208 1906239088 18.876 98 9 18 0 1924840624 16101184 2500352
00:41:15 26581 8192000000 10851787280 11328143360 1907202656 18.884 99 17 33 0 1932360656 20304288 4853712
00:41:49 26495 8192000000 10853586704 11335303168 1925714416 19.033 100 7 14 0 1941174368 13471168 1988784
00:42:22 73420 8192000000 10856865968 11339505664 1926019248 19.035 99 10 19 1 1936222928 7541616 2662064
00:43:42 37407 8192000000 10856260432 11335692288 1902494768 18.846 98 11 22 0 1913011792 6861392 3655632
00:44:26 57277 8192000000 10860057760 11330723840 1911896928 18.922 98 20 40 1 1928004768 10694544 5413296
00:45:29 43761 8192000000 10846097392 11317465088 1880481888 18.669 97 17 34 2 1897988064 12734880 4771296
00:46:36 86735 8192000000 10869299616 11331440640 1863443904 18.531 96 14 28 1 1883094576 15755008 3895664
00:48:18 49356 8192000000 10889888624 11350028288 1942773328 19.169 100 16 32 2 1959242208 11965600 4503280
00:49:14 68900 8192000000 10899729792 11360067584 1941533504 19.159 99 26 52 0 1958080208 9373104 7173600
00:50:29 56407 8192000000 10913215152 11384651776 1951943904 19.242 99 20 40 1 1970444432 12703872 5796656
00:51:47 96185 8192000000 10917365056 11367919616 1911147568 18.916 97 15 31 2 1930851568 15143984 4560016
00:53:31 18484 8192000000 10920456192 11373461504 1958687392 19.296 99 50 99 1 1986375904 14418480 13270032
00:53:58 12058 8192000000 10929551392 11374305280 1959213456 19.300 99 66 132 1 1989405968 11589232 18603280
00:54:17 48608 8192000000 10926654960 11389329408 1956546320 19.279 99 39 79 3 1978262528 11003264 10712944
00:55:13 85176 8192000000 10902836224 11391078400 1966318752 19.356 99 13 25 2 1993421744 23629952 3473040
00:56:52 140647 8192000000 10903622672 11359170560 1922390992 19.006 96 23 46 0 1938428032 9373264 6663776
00:59:21 56035 8192000000 10927968704 11392049152 1980055360 19.465 99 28 56 0 1997011776 9044512 7911904
01:00:28 39517 8192000000 10915817616 11399331840 1999236592 19.617 100 17 34 2 2012284384 8581184 4466608
01:01:15 53794 8192000000 10912231168 11402735616 1983472208 19.492 99 5 10 0 1993429664 8859392 1098064
01:02:16 31853 8192000000 10927848016 11409514496 2003032080 19.647 100 18 35 1 2015662320 8275440 4354800
01:02:55 50958 8192000000 10924269680 11414843392 2005863104 19.669 100 9 18 0 2015300128 6687152 2749872
01:04:02 50357 8192000000 10936973344 11402178560 1958321392 19.293 97 26 52 0 1973494560 8028352 7144816
01:04:59 53738 8192000000 10905564960 11378810880 1923531600 19.015 96 16 32 2 1937841504 9868032 4441872
01:06:32 60934 8192000000 10925864848 11401334784 1955803440 19.273 98 22 44 1 1976645536 14347472 6494624
01:07:42 97685 8192000000 10938807936 11432083456 2003677152 19.652 100 15 30 1 2029873504 21270304 4926048
01:09:26 107016 8192000000 10922621792 11400822784 1976612608 19.438 99 13 26 1 2001223744 20923440 3687696
01:11:23 70307 8192000000 10912978256 11369996288 1883450176 18.693 94 15 30 0 1895885360 8345520 4089664
01:12:40 23974 8192000000 10899694560 11352408064 1939772096 19.145 98 30 60 0 1955712112 7699808 8240208
01:13:13 45260 8192000000 10909883712 11372081152 1926901056 19.042 97 38 76 1 1948992944 11581008 10510880
01:14:05 24049 8192000000 10900274784 11352379392 1895998480 18.794 96 45 90 0 1922680224 14266048 12415696
01:14:47 64534 8192000000 10900624912 11375702016 1926585008 19.040 98 20 40 0 1942093584 10595776 4912800
01:16:03 54616 8192000000 10891167296 11366014976 1926337408 19.038 98 10 20 0 1939032432 9999120 2695904
01:17:04 119012 8192000000 10881309072 11352600576 1949453104 19.222 99 14 28 0 1971687264 18209680 4024480
01:19:14 96932 8192000000 10894473936 11366952960 1924471920 19.023 97 15 30 1 1935705104 7174464 4058720
01:21:04 68102 8192000000 10852320368 11337547776 1895132224 18.787 97 5 10 0 1905678736 9101904 1444608
01:22:18 27857 8192000000 10853446768 11333238784 1933032256 19.091 100 7 13 0 1947046736 12108816 1905664
01:22:52 40147 8192000000 10849313408 11327406080 1896034640 18.794 98 8 15 1 1909734400 11423184 2276576
01:24:01 64504 8192000000 10848885824 11324129280 1872343776 18.603 96 20 39 0 1894281664 15325632 6612256
01:25:20 39756 8192000000 10865628704 11339063296 1941884688 19.162 100 14 28 0 1956178672 10304160 3989824
01:26:06 43343 8192000000 10864381728 11344990208 1927766512 19.049 99 9 16 2 1941777728 11078416 2932800

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-01-2021 01:29:04 to 10-01-2021 01:29:35.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 150 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-01-2021 01:29:36 to 10-01-2021 01:29:38.

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          244807
MON$OLDEST_ACTIVE               244808
MON$OLDEST_SNAPSHOT             244808
MON$NEXT_TRANSACTION            244808
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                       2043872
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
--- end of diff output ---

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

10.01.21 01:29:39. 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-01-10 01:29:42 No severe PSQL-related problems occured
10.01.21 01:29:43. End of report.