Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.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 17218720 kB
MemAvailable 31462204 kB
Buffers 0 kB
Cached 14498504 kB
SwapCached 4820 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-01 01:27:07
DTS_END                         2021-01-01 01:27:07.9260
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/39598
TRN_ID                          239641
ATT_ID                          671
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: 9336.74 17986 1120409
customer order: creation 175.08 363 21009
customer order: refuse 14.94 358 1793
order to supplier: creation 45.72 1276 5486
order to supplier: removal 3.64 96503 437
invoice (draft): creation 46.22 3259 5546
invoice (draft): removal 53.22 737 6386
invoice accept: apply 42.33 17806 5079
invoice accept: cancel 48.44 856 5813
customer reserve: creation 3885.26 176 466231
customer reserve: removal 4717.36 58 566083
realization accept: apply 84.00 201 10080
realization accept: cancel 89.60 107 10752
payment from customer: creation 59.70 140 7164
payment from customer: removal 6.03 93 724
payment to supplier: creation 49.02 139 5882
payment to supplier: removal 3.38 139 405
service: total inventory turnovers 4.96 1209 595
service: total monetary turnovers 6.89 36 827
service: aggregate perf. data 0.94 17992 113
service: refresh index statistics 0.03 218266 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-01-2021 01:28:37 to 01-01-2021 01:28:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5328
TEST_TIME 2 6124
TEST_TIME 3 5957
TEST_TIME 4 6310
TEST_TIME 5 5712
TEST_TIME 6 5977
TEST_TIME 7 5885
TEST_TIME 8 6136
TEST_TIME 9 6012
TEST_TIME 10 6145
TEST_TIME 11 6401
TEST_TIME 12 6543
TEST_TIME 13 7016
TEST_TIME 14 6980
TEST_TIME 15 7455
TEST_TIME 16 7722
TEST_TIME 17 8207
TEST_TIME 18 8553
TEST_TIME 19 8675
TEST_TIME 20 8718
TEST_TIME 21 9073
TEST_TIME 22 9310
TEST_TIME 23 9774
TEST_TIME 24 9655
TEST_TIME 25 10183
TEST_TIME 26 9848
TEST_TIME 27 9946
TEST_TIME 28 10330
TEST_TIME 29 10894
TEST_TIME 30 10743
TEST_TIME 31 10824
TEST_TIME 32 10620
TEST_TIME 33 10589
TEST_TIME 34 10505
TEST_TIME 35 10362
TEST_TIME 36 10392
TEST_TIME 37 10474
TEST_TIME 38 10411
TEST_TIME 39 10302
TEST_TIME 40 10324
TEST_TIME 41 10415
TEST_TIME 42 10346
TEST_TIME 43 10319
TEST_TIME 44 10133
TEST_TIME 45 9957
TEST_TIME 46 10057
TEST_TIME 47 9973
TEST_TIME 48 9900
TEST_TIME 49 9882
TEST_TIME 50 9871
TEST_TIME 51 9854
TEST_TIME 52 9898
TEST_TIME 53 9878
TEST_TIME 54 9812
TEST_TIME 55 9702
TEST_TIME 56 9772
TEST_TIME 57 9645
TEST_TIME 58 9693
TEST_TIME 59 9670
TEST_TIME 60 9642
TEST_TIME 61 9661
TEST_TIME 62 9698
TEST_TIME 63 9744
TEST_TIME 64 9746
TEST_TIME 65 9845
TEST_TIME 66 9807
TEST_TIME 67 9788
TEST_TIME 68 9801
TEST_TIME 69 9766
TEST_TIME 70 9758
TEST_TIME 71 9798
TEST_TIME 72 9947
TEST_TIME 73 9926
TEST_TIME 74 9942
TEST_TIME 75 9851
TEST_TIME 76 9809
TEST_TIME 77 9790
TEST_TIME 78 9717
TEST_TIME 79 9679
TEST_TIME 80 9606
TEST_TIME 81 9669
TEST_TIME 82 9619
TEST_TIME 83 9584
TEST_TIME 84 9511
TEST_TIME 85 9558
TEST_TIME 86 9498
TEST_TIME 87 9567
TEST_TIME 88 9526
TEST_TIME 89 9553
TEST_TIME 90 9573
TEST_TIME 91 9545
TEST_TIME 92 9542
TEST_TIME 93 9569
TEST_TIME 94 9576
TEST_TIME 95 9634
TEST_TIME 96 9665
TEST_TIME 97 9657
TEST_TIME 98 9714
TEST_TIME 99 9680
TEST_TIME 100 9714
TEST_TIME 101 9726
TEST_TIME 102 9723
TEST_TIME 103 9693
TEST_TIME 104 9616
TEST_TIME 105 9614
TEST_TIME 106 9578
TEST_TIME 107 9583
TEST_TIME 108 9581
TEST_TIME 109 9599
TEST_TIME 110 9560
TEST_TIME 111 9562
TEST_TIME 112 9534
TEST_TIME 113 9510
TEST_TIME 114 9484
TEST_TIME 115 9445
TEST_TIME 116 9427
TEST_TIME 117 9408
TEST_TIME 118 9449
TEST_TIME 119 9413
TEST_TIME 120 9340

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 01-01-2021 01:28:40 to 01-01-2021 01:28:44.

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 1551494 1551494 0 0.00 0 22756 6 0 0
doc_list_biud 1551494 1551494 0 0.00 0 45917 27 0 0
sp_add_invoice_to_stock 5236 5079 157 2.99 31 172322 17806 0 157
sp_cancel_adding_invoice 5813 5813 0 0.00 5 64807 856 0 0
sp_cancel_client_order 1793 1793 0 0.00 4 11586 358 0 0
sp_cancel_customer_reserve 566083 566083 0 0.00 1 24750 59 0 0
sp_cancel_pay_from_customer 724 724 0 0.00 3 9828 94 0 0
sp_cancel_pay_to_supplier 405 405 0 0.00 3 14932 139 0 0
sp_cancel_supplier_invoice 6406 6386 20 0.31 1 15680 737 0 20
sp_cancel_supplier_order 437 437 0 0.00 10 1043146 96504 0 0
sp_cancel_write_off 10752 10752 0 0.00 1 12409 108 0 0
sp_client_order 21009 21009 0 0.00 3 50264 363 0 0
sp_customer_reserve 466231 466231 0 0.00 0 43150 177 0 0
sp_fill_shopping_cart 32024 32024 0 0.00 1 28650 35 0 0
sp_fill_shopping_cart_clo_res 466222 466222 0 0.00 0 16894 13 0 0
sp_get_clo_for_invoice 5067 5067 0 0.00 0 22927 297 0 0
sp_kill_cost_storno 17694 17694 0 0.00 0 8000 55 0 0
sp_kill_qstorno_ret_qs2qd 1149741 1149741 0 0.00 0 37814 32 0 0
sp_kill_qty_storno 606410 606410 0 0.00 0 45914 69 0 0
sp_lock_selected_doc 21012 21012 0 0.00 0 10595 7 0 0
sp_make_cost_storno 28192 28192 0 0.00 0 15234 56 0 0
sp_multiply_rows_for_pdistr 28192 28192 0 0.00 0 14959 35 0 0
sp_multiply_rows_for_qdistr 21009 21009 0 0.00 0 32048 150 0 0
sp_pay_from_customer 7164 7164 0 0.00 4 16690 140 0 0
sp_pay_to_supplier 5882 5882 0 0.00 4 15916 139 0 0
sp_payment_common 13046 13046 0 0.00 1 16686 37 0 0
sp_qd_handle_on_cancel_clo 1793 1793 0 0.00 0 9462 322 0 0
sp_qd_handle_on_invoice_upd_sts 10879 10879 0 0.00 0 45910 373 0 0
sp_qd_handle_on_reserve_upd_sts 10080 10080 0 0.00 0 19745 60 0 0
sp_reserve_write_off 10080 10080 0 0.00 6 20317 202 0 0
sp_supplier_invoice 5546 5546 0 0.00 7 105898 3260 0 0
sp_supplier_order 5486 5486 0 0.00 5 29580 1277 0 0
srv_aggregate_perf_data 113 113 0 0.00 2643 192191 17992 0 0
srv_fill_mon_cache_memory 171 171 0 0.00 1272 121244 30744 0 0
srv_find_qd_qs_mism 1071876 1071876 0 0.00 0 22755 5 0 0
srv_make_invnt_saldo 595 595 0 0.00 32 86944 1210 0 0
srv_make_money_saldo 827 827 0 0.00 1 9416 36 0 0
srv_recalc_idx_stat 4 4 0 0.00 137772 293048 218266 0 0
t$perf-abend:sp_add_invoice_to_stock 157 157 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 20 20 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5079 5079 0 0.00 0 7935 172 0 0
t$perf-norm:sp_cancel_adding_invoice 392 392 0 0.00 0 4006 102 0 0
t$perf-norm:sp_cancel_client_order 1793 1793 0 0.00 0 1378 7 0 0
t$perf-norm:sp_cancel_customer_reserve 701 701 0 0.00 0 2263 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 724 724 0 0.00 0 2834 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 405 405 0 0.00 0 615 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 396 396 0 0.00 0 2377 27 0 0
t$perf-norm:sp_cancel_supplier_order 437 437 0 0.00 0 41529 1667 0 0
t$perf-norm:sp_cancel_write_off 1019 1019 0 0.00 0 2657 15 0 0
t$perf-norm:sp_client_order 21009 21009 0 0.00 0 6518 18 0 0
t$perf-norm:sp_customer_reserve 999 999 0 0.00 0 1615 6 0 0
t$perf-norm:sp_pay_from_customer 7164 7164 0 0.00 0 8534 14 0 0
t$perf-norm:sp_pay_to_supplier 5882 5882 0 0.00 0 8556 15 0 0
t$perf-norm:sp_reserve_write_off 10080 10080 0 0.00 0 15439 15 0 0
t$perf-norm:sp_supplier_invoice 5546 5546 0 0.00 0 7759 20 0 0
t$perf-norm:sp_supplier_order 5486 5486 0 0.00 0 7682 18 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 4801 53 0 0
t$perf-norm:srv_fill_mon_cache_memory 171 171 0 0.00 0 2478 21 0 0
t$perf-norm:srv_make_invnt_saldo 595 595 0 0.00 0 541 16 0 0
t$perf-norm:srv_make_money_saldo 827 827 0 0.00 0 1113 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10444 10130 314 3.00 0 9767 22 0 314
v_all_customers 38456 38456 0 0.00 0 37 1 0 0
v_all_suppliers 30144 30144 0 0.00 0 78 1 0 0
v_all_wares 42018 42018 0 0.00 0 51 1 0 0
v_cancel_adding_invoice 784 784 0 0.00 0 432 7 0 0
v_cancel_client_order 3586 3586 0 0.00 0 9823 8 0 0
v_cancel_customer_prepayment 1448 1448 0 0.00 0 9787 22 0 0
v_cancel_customer_reserve 1402 1402 0 0.00 0 2540 6 0 0
v_cancel_payment_to_supplier 810 810 0 0.00 0 906 6 0 0
v_cancel_supplier_invoice 832 792 40 4.80 0 3160 19 0 40
v_cancel_supplier_order 874 874 0 0.00 0 5788 10 0 0
v_cancel_write_off 2038 2038 0 0.00 0 3262 19 0 0
v_max_id_clo_ord 5486 5486 0 0.00 0 1732 1 0 0
v_max_id_clo_res 999 999 0 0.00 0 1381 10 0 0
v_max_id_ord_sup 5529 5529 0 0.00 0 6390 5 0 0
v_max_non_paid_invoice 1825 1825 0 0.00 0 9067 19 0 0
v_max_non_paid_realizn 3700 3700 0 0.00 0 6891 7 0 0
v_min_id_clo_ord 5486 5486 0 0.00 0 2237 6 0 0
v_min_id_clo_res 999 999 0 0.00 0 12317 31 0 0
v_min_id_ord_sup 5529 5529 0 0.00 0 6764 7 0 0
v_min_non_paid_invoice 5882 5882 0 0.00 0 9451 18 0 0
v_min_non_paid_realizn 7164 7164 0 0.00 0 9407 19 0 0
v_our_firm 10490 10490 0 0.00 0 13 1 0 0
v_reserve_write_off 20160 20160 0 0.00 0 9827 11 0 0
x_lock_depdocs_on_canc_invoice 11803 11803 0 0.00 0 39412 107 0 0
x_lock_depdocs_on_canc_sup_ord 437 437 0 0.00 0 8414 283 0 0
x_make_qstorno_1000_1200 5486 5486 0 0.00 1 24375 1185 0 0
x_make_qstorno_1200_2000 5546 5546 0 0.00 3 105682 3145 0 0
x_make_qstorno_2100_3300 466231 466231 0 0.00 0 43126 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-01-2021 01:28:45 to 01-01-2021 01:28:49.

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:11 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:18 14919 8192000000 10238113312 10548871168 980613792 10.690 77 57 118 0 1002266336 2699712 18952832
22:57:41 24608 8192000000 10349963488 10667909120 1378898320 14.407 100 81 163 0 1410489296 4562736 27028240
22:58:16 23336 8192000000 10357472976 10681278464 1413546848 14.715 100 88 177 0 1448071136 6245696 28278592
22:58:51 19338 8192000000 10387084640 10712977408 1444447056 14.989 100 90 180 0 1480514304 6820736 29246512
22:59:24 24278 8192000000 10418732400 10747371520 1463469760 15.156 100 82 164 1 1497800304 7764048 26566496
23:00:05 13482 8192000000 10454449872 10791301120 1509740368 15.561 100 86 172 1 1545224880 8649632 26834880
23:00:37 28233 8192000000 10482333360 10823192576 1536270960 15.791 100 87 174 0 1573653632 9973552 27409120
23:01:15 9803 8192000000 10504002224 10847113216 1554456816 15.948 100 85 170 0 1590843184 10209968 26176400
23:01:39 11526 8192000000 10515891040 10862768128 1569838576 16.081 100 79 158 1 1604720544 10495376 24386592
23:02:00 18599 8192000000 10542094688 10893127680 1596621520 16.310 100 84 168 1 1633253600 11229488 25402592
23:02:25 9991 8192000000 10536202112 10896203776 1607282048 16.402 100 76 152 1 1641235216 11287056 22666112
23:02:42 13452 8192000000 10570514320 10929987584 1630186752 16.596 100 79 158 0 1665023600 11305920 23530928
23:03:04 11483 8192000000 10595587024 10955608064 1648469760 16.751 100 73 146 0 1682062064 11869680 21722624
23:03:24 9397 8192000000 10606578096 10973655040 1668589344 16.921 100 79 158 2 1704243232 12553360 23100528
23:03:41 8850 8192000000 10627035472 10995609600 1689033792 17.093 100 79 159 1 1724485632 12230720 23221120
23:04:01 7197 8192000000 10648488496 11015712768 1705165872 17.228 100 79 156 1 1741163584 13154784 22842928
23:04:16 5853 8192000000 10649409344 11024310272 1713628048 17.299 100 77 154 1 1748421696 12353840 22439808
23:04:28 6444 8192000000 10673864432 11048726528 1736496064 17.490 100 78 157 5 1770835920 12180720 22159136
23:04:42 5262 8192000000 10681882960 11061972992 1743890096 17.551 100 75 151 1 1776577216 11965712 20721408
23:04:55 4500 8192000000 10693301408 11068383232 1750870688 17.609 100 80 160 1 1786196736 12641920 22684128
23:05:08 6295 8192000000 10693038752 11075158016 1763557376 17.714 100 85 168 0 1799899952 12624256 23718320
23:05:22 3370 8192000000 10703858928 11082117120 1768417472 17.754 100 83 166 1 1803733504 12590736 22725296
23:05:32 4430 8192000000 10712979888 11091226624 1773693808 17.797 100 84 168 0 1810454256 13169664 23590784
23:05:44 3625 8192000000 10724563408 11100925952 1784337888 17.885 100 93 186 2 1825327632 14720464 26269280
23:05:54 4945 8192000000 10727947712 11110735872 1788117440 17.916 100 86 172 0 1826454832 15048160 23289232
23:06:05 2120 8192000000 10735271008 11122532352 1796220832 17.983 100 93 185 1 1837274016 14992976 26060208
23:06:14 3675 8192000000 10745610864 11127705600 1803174784 18.040 100 82 165 0 1839337792 13239152 22923856
23:06:28 4296 8192000000 10742920944 11130818560 1806858576 18.070 100 71 142 3 1838768432 12025920 19883936
23:06:40 2680 8192000000 10759167664 11146326016 1825482736 18.222 100 92 182 1 1864566912 12597456 26486720
23:06:48 2151 8192000000 10772815696 11162910720 1834501616 18.296 100 87 172 2 1871345008 12768912 24074480
23:06:58 2248 8192000000 10779682800 11163140096 1838877728 18.332 100 87 173 0 1874799712 12092208 23829776
23:07:06 2099 8192000000 10787731184 11173863424 1847845776 18.405 100 93 185 0 1886930432 13048048 26036608
23:07:15 1874 8192000000 10792945952 11179536384 1850738752 18.428 100 96 190 2 1891053392 13425008 26889632
23:07:23 2172 8192000000 10797332480 11183308800 1856849632 18.478 100 91 182 3 1896635984 13498864 26287488
23:07:32 1781 8192000000 10801024960 11188846592 1857428816 18.482 100 92 185 1 1897235904 13918000 25889088
23:07:40 1548 8192000000 10810436800 11195305984 1859256336 18.497 100 95 191 1 1900343584 14413136 26674112
23:07:48 1919 8192000000 10811136672 11198107648 1861815456 18.518 100 94 188 1 1901265280 13332832 26116992
23:07:56 1051 8192000000 10806981328 11196198912 1865555728 18.548 100 87 175 1 1903459232 12703312 25200192
23:08:05 1828 8192000000 10809167568 11198681088 1864798672 18.542 100 90 182 1 1902745632 13005088 24941872
23:08:14 6599 8192000000 10811533152 11199197184 1867420768 18.563 100 85 170 2 1905006384 14153888 23431728
23:08:27 22600 8192000000 10801169024 11207917568 1869763904 18.582 100 69 136 2 1904520096 15368640 19387552
23:08:57 3425 8192000000 10813473392 11213643776 1877064624 18.641 100 53 104 2 1900051648 9056752 13930272
23:09:06 3815 8192000000 10802033728 11213299712 1875956224 18.632 100 56 112 0 1901847936 10749504 15142208
23:09:18 1571 8192000000 10803429936 11215708160 1879981296 18.665 100 51 102 0 1904017616 10548720 13487600
23:09:25 4409 8192000000 10796265184 11214946304 1880268000 18.667 100 46 93 2 1903179168 9476944 13434224
23:09:36 8414 8192000000 10785927968 11211120640 1878832912 18.656 100 31 63 2 1894232768 6798608 8601248
23:09:51 2662 8192000000 10791043728 11217977344 1884785088 18.704 100 39 79 1 1902884896 7273008 10826800
23:10:01 5073 8192000000 10795492944 11217678336 1887951808 18.729 100 43 86 2 1907378656 6741312 12685536
23:10:15 5628 8192000000 10789098544 11220799488 1886232080 18.715 100 26 52 0 1900493296 6852640 7408576
23:10:30 10820 8192000000 10796164496 11228094464 1888184544 18.731 100 20 40 0 1900523904 7004992 5334368
23:10:47 9891 8192000000 10801321504 11227570176 1890003984 18.746 100 18 36 2 1901483040 6358672 5120384
23:11:06 9238 8192000000 10801815984 11235553280 1895058704 18.787 100 30 60 0 1910658304 6221536 9378064
23:11:21 7542 8192000000 10801824688 11233181696 1894871264 18.785 100 27 54 2 1909500304 6215008 8414032
23:11:35 14850 8192000000 10800777792 11230814208 1897379424 18.805 100 36 71 2 1913489264 6460752 9649088
23:11:59 67292 8192000000 10809388864 11242807296 1900116528 18.827 100 33 67 0 1915779024 6177040 9485456
23:13:13 23769 8192000000 10810182944 11246800896 1902070128 18.843 100 19 38 2 1912427376 5548816 4808432
23:13:46 5726 8192000000 10828438944 11256438784 1906909472 18.882 100 33 66 2 1923499488 6999296 9590720
23:13:58 3870 8192000000 10830701600 11260362752 1913451248 18.934 100 46 93 0 1935439360 8271712 13716400
23:14:09 7407 8192000000 10814742096 11253542912 1910515248 18.911 100 33 69 1 1925621968 5642992 9463728
23:14:23 4331 8192000000 10825942880 11259768832 1907724928 18.888 100 30 58 0 1922316496 6522320 8069248
23:14:33 5549 8192000000 10825036960 11256467456 1905580160 18.871 100 17 33 1 1915678032 5528560 4569312
23:14:46 9213 8192000000 10820541424 11255820288 1911669600 18.920 100 29 56 1 1925440432 5746880 8023952
23:15:01 5982 8192000000 10824776208 11261652992 1913598416 18.936 100 20 40 1 1924978240 5594304 5785520
23:15:14 14269 8192000000 10822041808 11264327680 1911761856 18.921 100 14 28 0 1921622784 6061280 3799648
23:15:35 5191 8192000000 10826296752 11259936768 1912055344 18.923 100 22 44 3 1924860448 6790704 6014400
23:15:48 7918 8192000000 10824427680 11262468096 1914762544 18.945 100 22 44 2 1927068912 6171568 6134800
23:16:05 8743 8192000000 10799960720 11224760320 1831060992 18.268 96 13 26 0 1840381472 5780928 3539552
23:16:20 10388 8192000000 10812335024 11246116864 1882177888 18.683 99 17 34 0 1900883504 14675840 4029776
23:16:40 14632 8192000000 10795978448 11214548992 1814453632 18.132 96 23 46 2 1827282928 5530704 7298592
23:17:02 62317 8192000000 10773468592 11202023424 1786060352 17.899 95 28 56 1 1799106976 4581104 8465520
23:18:11 7770 8192000000 10753341040 11170926592 1764110048 17.718 95 29 56 1 1778264544 6067312 8087184
23:18:28 4357 8192000000 10734090240 11146821632 1782965440 17.874 98 39 74 3 1799656368 5957424 10733504
23:18:39 6418 8192000000 10720720016 11142017024 1782938912 17.874 98 28 56 0 1797189536 6036720 8213904
23:18:52 5339 8192000000 10736654768 11160813568 1809362816 18.091 99 29 58 1 1823450208 5959520 8127872
23:19:03 6931 8192000000 10747211168 11161972736 1785985056 17.899 97 27 54 2 1798811552 5600560 7225936
23:19:20 8402 8192000000 10753734400 11175854080 1833843120 18.291 100 29 58 2 1847305808 5464016 7998672
23:19:39 6669 8192000000 10735400128 11157438464 1794005936 17.965 98 25 50 2 1811441152 10641344 6793872
23:19:52 6641 8192000000 10706622576 11130630144 1753307136 17.629 96 21 40 1 1765153120 5718608 6127376
23:20:04 6433 8192000000 10734744592 11150921728 1790349088 17.935 98 35 70 3 1807898240 7662016 9887136
23:20:17 6103 8192000000 10734999856 11146256384 1772785104 17.790 97 28 56 0 1787473504 5984368 8704032
23:20:31 5697 8192000000 10738060528 11159363584 1815046832 18.137 99 28 56 0 1828460848 5505344 7908672
23:20:43 7038 8192000000 10709078432 11116662784 1724305104 17.388 95 27 52 2 1737847952 5855136 7687712
23:20:57 8280 8192000000 10690271888 11102724096 1723113952 17.378 96 34 69 0 1737955648 4821152 10020544
23:21:13 53074 8192000000 10711824208 11118063616 1736017248 17.486 97 19 38 1 1746810624 5397488 5395888
23:22:20 27628 8192000000 10715645520 11141984256 1789462224 17.927 99 19 39 0 1800007952 5566816 4978912
23:22:55 6584 8192000000 10759108672 11163820032 1823086544 18.203 100 39 78 2 1840845824 6562016 11197264
23:23:10 4393 8192000000 10751141184 11163824128 1827452144 18.239 100 40 80 2 1846945840 8378720 11114976
23:23:23 3903 8192000000 10773002992 11184070656 1838412192 18.328 100 52 104 1 1865915008 12323472 15179344
23:23:34 6235 8192000000 10748917408 11173679104 1839467216 18.336 100 33 66 1 1855820624 6147168 10206240
23:23:47 7850 8192000000 10768645648 11179573248 1842445456 18.361 100 26 50 2 1856167920 5713008 8009456
23:24:02 9344 8192000000 10751726320 11180908544 1844850800 18.380 100 28 56 1 1858951472 5268064 8832608
23:24:20 11046 8192000000 10760029856 11184504832 1830564320 18.264 99 29 58 2 1844588768 5508656 8515792
23:24:38 8284 8192000000 10757485392 11189161984 1847545232 18.402 100 23 47 2 1859777440 5401440 6830768
23:24:56 4631 8192000000 10766423856 11194798080 1853377184 18.450 100 25 52 1 1866274768 5048224 7849360
23:25:07 6254 8192000000 10771763920 11199074304 1855980816 18.471 100 26 52 2 1869670400 5947056 7742528
23:25:19 10395 8192000000 10771697024 11202134016 1858077328 18.488 100 24 47 3 1870754816 5824320 6853168
23:25:36 11353 8192000000 10770573504 11201716224 1863050000 18.528 100 18 36 1 1873793936 5076752 5667184
23:25:56 18772 8192000000 10793839872 11211210752 1867448512 18.564 100 34 67 2 1882883168 5342880 10091776
23:26:22 82332 8192000000 10811026560 11234344960 1880452000 18.669 100 36 72 1 1896189024 5879664 9857360
23:27:57 15483 8192000000 10835462352 11250884608 1896031984 18.794 100 40 78 0 1914937408 7691392 11214032
23:28:19 8592 8192000000 10832192880 11254763520 1905662336 18.872 100 31 61 1 1921443616 7132800 8648480
23:28:38 24848 8192000000 10850334176 11269992448 1920306336 18.989 100 55 111 0 1945205632 9164416 15734880
23:29:09 3593 8192000000 10867740112 11279400960 1928073424 19.051 100 64 126 2 1955927600 10024080 17830096
23:29:20 6552 8192000000 10868591840 11289243648 1935158112 19.108 100 68 136 0 1966323472 11406880 19758480
23:29:35 9439 8192000000 10869077312 11292667904 1937020000 19.123 100 62 124 1 1965143536 10247232 17876304
23:30:11 23697 8192000000 10876181056 11304566784 1947090416 19.203 100 45 90 3 1974814928 14810880 12913632
23:30:44 22061 8192000000 10867988384 11305902080 1932688448 19.088 99 35 70 1 1955678656 12482752 10507456
23:31:13 23595 8192000000 10885541456 11319963648 1953322096 19.253 100 32 62 0 1970870768 8157472 9391200
23:31:43 16273 8192000000 10892688656 11326414848 1963372608 19.333 100 47 92 1 1985528880 9221616 12934656
23:32:07 10252 8192000000 10902335920 11327328256 1965608176 19.351 100 44 89 1 1988253584 10053280 12592128
23:32:25 21932 8192000000 10902561744 11333332992 1972308096 19.404 100 47 94 1 1997515024 11967952 13238976
23:32:58 10702 8192000000 10909346832 11342274560 1974205872 19.419 100 44 87 1 1998849008 11974368 12668768
23:33:17 15855 8192000000 10925504448 11354468352 1979174416 19.458 100 52 104 0 2007108112 13411936 14521760
23:33:42 6126 8192000000 10922972496 11353485312 1987733216 19.526 100 61 122 4 2019475808 13633376 18109216
23:33:56 12276 8192000000 10927552160 11349762048 1980708864 19.470 100 64 127 1 2012807792 13903536 18195392
23:34:19 1755 8192000000 10942032208 11351072768 1987841264 19.527 100 77 156 2 2025044272 14438928 22764080
23:34:27 5039 8192000000 10930272448 11356504064 1988759440 19.534 100 76 151 0 2026641232 15517584 22364208
23:34:43 10286 8192000000 10934641488 11366793216 1991606144 19.556 100 58 116 0 2028323232 20254912 16462176
23:35:00 20507 8192000000 10932489632 11361705984 1958645984 19.295 98 60 120 0 1996249808 20828304 16775520
23:35:35 12121 8192000000 10928654752 11367493632 1988670864 19.533 100 47 93 1 2020143344 17791760 13680720
23:35:54 9240 8192000000 10935912912 11366821888 1977297632 19.443 99 46 92 0 2008466672 17200832 13968208
23:36:13 4134 8192000000 10939306944 11359502336 1976175760 19.434 99 58 113 1 2012087552 18945584 16966208
23:36:27 6752 8192000000 10955491968 11376480256 1997773600 19.605 100 64 126 2 2037700240 21111216 18815424
23:36:42 5789 8192000000 10944900528 11374338048 1998264688 19.609 100 65 130 2 2040601024 22505184 19831152
23:36:54 4837 8192000000 10961307824 11384107008 2002363600 19.641 100 70 137 2 2045241328 23206160 19671568
23:37:07 3690 8192000000 10962558112 11385499648 2009063328 19.694 100 78 156 0 2056433680 23649216 23721136
23:37:17 16061 8192000000 10959481680 11392237568 2006602128 19.675 100 61 121 0 2047428048 22207248 18618672
23:37:49 27466 8192000000 10950489840 11385536512 1989552560 19.540 99 51 100 2 2030431648 25015200 15863888
23:38:24 6671 8192000000 10957972496 11391381504 1989783216 19.542 99 65 130 3 2036034544 26118368 20132960
23:38:40 6292 8192000000 10961070176 11397984256 2007673952 19.683 100 53 105 0 2049975248 25832848 16468448
23:38:55 5893 8192000000 10970509488 11403358208 2013336416 19.728 100 63 126 2 2060995824 27267520 20391888
23:39:11 5164 8192000000 10971614880 11409301504 2015549456 19.745 100 58 116 2 2060731664 27532032 17650176
23:39:22 3816 8192000000 10975145280 11402039296 2012452736 19.721 100 70 140 2 2060694912 26625248 21616928
23:39:36 4067 8192000000 10978950288 11408695296 2018881168 19.771 100 73 145 2 2068429360 27440016 22108176
23:39:47 1602 8192000000 10979985392 11407261696 2014268464 19.735 100 72 144 0 2066251104 29597520 22385120
23:39:57 2660 8192000000 10972205952 11394818048 1991710384 19.557 99 81 162 1 2046737728 30253184 24774160
23:40:12 3830 8192000000 10967686576 11402747904 2008847312 19.692 100 61 122 2 2056627072 28415520 19364240
23:40:26 2568 8192000000 10965782320 11388624896 2001658128 19.636 99 72 142 1 2050592352 26806144 22128080
23:40:35 11180 8192000000 10962281744 11386843136 1993822560 19.574 99 67 134 3 2040527440 26580672 20124208
23:40:54 2456 8192000000 10968994256 11394736128 2004453360 19.658 100 70 139 1 2052404608 27100656 20850592
23:41:04 2311 8192000000 10974485616 11389603840 2000373408 19.626 100 84 167 0 2055079392 28508832 26197152
23:41:14 7121 8192000000 10953072832 11382427648 1980400464 19.468 99 66 132 1 2029301440 28390032 20510944
23:41:34 7655 8192000000 10961248560 11384950784 1982236528 19.482 99 72 143 0 2033320496 29409600 21674368
23:41:49 3353 8192000000 10950391520 11376439296 1986452816 19.516 100 74 148 1 2040176288 31106976 22616496
23:41:59 2693 8192000000 10975899488 11393445888 1998899952 19.614 100 83 164 1 2057362032 33523664 24938416
23:42:10 4254 8192000000 10949027088 11372621824 1974922832 19.424 99 71 142 1 2031267968 34640400 21704736
23:42:21 6518 8192000000 10967235472 11379580928 1988148288 19.529 100 75 149 2 2043368656 31975008 23245360
23:42:38 5424 8192000000 10960376992 11388809216 1994289120 19.578 100 70 138 0 2047552128 31923648 21339360
23:42:57 1264 8192000000 10952456192 11372232704 1980981760 19.472 100 81 161 0 2036009728 30445424 24582544
23:43:06 5926 8192000000 10952648144 11377221632 1980487328 19.469 100 73 146 0 2036007392 32736288 22783776
23:43:20 8012 8192000000 10944185152 11369607168 1974447472 19.421 100 76 151 1 2028405968 30544976 23413520
23:43:36 3756 8192000000 10957089792 11379871744 1988061920 19.528 100 73 147 0 2041459632 29959824 23437888
23:43:49 2137 8192000000 10958396112 11376410624 1977846784 19.448 99 80 159 2 2033240000 31406208 23987008
23:43:59 4247 8192000000 10944444960 11366174720 1973565312 19.414 100 69 135 0 2026333904 32109456 20659136
23:44:11 8496 8192000000 10916785904 11348480000 1933196192 19.092 98 59 118 3 1983667744 32145456 18326096
23:44:27 15534 8192000000 10912005920 11361902592 1965440320 19.349 100 39 78 0 2010726592 32361904 12924368
23:44:56 8052 8192000000 10937323728 11374792704 1978979376 19.457 100 39 77 3 2019935600 28352272 12603952
23:45:11 2727 8192000000 10953467152 11385561088 1995505168 19.587 100 61 119 0 2042656304 28445856 18705280
23:45:21 1994 8192000000 10962782320 11387379712 1994101808 19.576 100 78 155 0 2047363264 29550752 23710704
23:45:32 3793 8192000000 10953149248 11378659328 1959930272 19.305 98 73 147 0 2011115824 28512464 22673088
23:45:42 7584 8192000000 10937285632 11383480320 1985665088 19.510 100 41 81 1 2024257392 26040176 12552128
23:45:59 8292 8192000000 10940417664 11377782784 1968079152 19.370 99 40 80 0 2006935568 26077440 12778976
23:46:17 1757 8192000000 10956095728 11379527680 1986876016 19.519 100 81 163 0 2041206224 29509088 24821120
23:46:25 3791 8192000000 10930071664 11346120704 1931543616 19.079 97 87 172 2 1989130960 31863216 25724128
23:46:36 4228 8192000000 10949266816 11372621824 1971574192 19.398 100 80 158 2 2031100608 35313760 24212656
23:46:47 13055 8192000000 10936476928 11362004992 1950953696 19.234 99 51 103 1 1997751760 31731072 15066992
23:47:08 10103 8192000000 10912401552 11350061056 1930047552 19.067 98 38 75 0 1974827616 32550976 12229088
23:47:28 10991 8192000000 10904733344 11342123008 1940182528 19.148 99 42 84 1 1988404832 34833936 13388368
23:47:46 3610 8192000000 10909165456 11337723904 1925948544 19.034 99 46 91 2 1974406384 33765552 14692288
23:47:57 3168 8192000000 10930662336 11351855104 1961826624 19.321 100 78 156 2 2022183024 35181216 25175184
23:48:10 4717 8192000000 10948877696 11363950592 1961443152 19.318 100 73 146 2 2021451792 37313264 22695376
23:48:21 2146 8192000000 10963153536 11370868736 1974958544 19.425 100 89 175 1 2036791024 34214064 27618416
23:48:30 3128 8192000000 10977460016 11393155072 1990266288 19.546 100 74 148 4 2053087840 39366432 23455120
23:48:39 3272 8192000000 10951568880 11375022080 1974069824 19.418 99 75 151 1 2035069744 37268992 23730928
23:48:50 2992 8192000000 10955186384 11386359808 1983439552 19.492 100 53 105 1 2035453440 35931456 16082432
23:48:59 7100 8192000000 10933582288 11373674496 1960530640 19.310 99 38 76 0 2008084912 35046192 12508080
23:49:17 10936 8192000000 10936740960 11376414720 1961943200 19.321 99 45 91 0 2014872016 37796944 15131872
23:49:38 8015 8192000000 10950207024 11382980608 1962786624 19.328 99 44 86 0 2019089952 42308720 13994608
23:49:52 6173 8192000000 10935921696 11373879296 1962520448 19.326 99 44 86 2 2011373488 34741008 14112032
23:50:08 2061 8192000000 10965098656 11384369152 1984251600 19.498 100 84 167 5 2047563792 35862688 27449504
23:50:19 9883 8192000000 10941610176 11371761664 1965166848 19.347 99 53 106 1 2021484672 39451088 16866736
23:50:36 11969 8192000000 10937954464 11388518400 1978643008 19.454 100 37 74 0 2025360688 34105296 12612384
23:50:54 7903 8192000000 10931675888 11380281344 1972836976 19.408 100 28 56 2 2015743504 33054064 9852464
23:51:14 11567 8192000000 10928368240 11373658112 1967764080 19.368 100 36 72 0 2014378688 34766512 11848096
23:51:32 16800 8192000000 10931207792 11367063552 1954882368 19.265 100 40 80 0 2008943680 40805344 13255968
23:51:59 15466 8192000000 10926324240 11371073536 1958259008 19.292 100 28 56 2 2008623264 40684144 9680112
23:52:24 11072 8192000000 10931523120 11374968832 1939416992 19.142 99 29 58 2 2003192096 53940928 9834176
23:52:42 44589 8192000000 10900592112 11349442560 1939022720 19.139 99 27 55 2 1973085744 25206032 8856992
23:54:25 12466 8192000000 10908312032 11357364224 1953199936 19.252 100 39 78 0 1997591200 31341760 13049504
23:54:48 21287 8192000000 10886062368 11346575360 1925678976 19.032 99 19 38 3 1962327520 29334112 7314432
23:55:16 25905 8192000000 10880461424 11356127232 1942753488 19.169 100 17 34 1 1981289808 32196752 6339568
23:56:01 29008 8192000000 10894057792 11358511104 1942640720 19.168 100 17 34 0 1980195024 32463952 5090352
23:56:38 57371 8192000000 10868189040 11330555904 1885548496 18.710 97 16 32 1 1910625344 20516256 4560592
23:57:42 26927 8192000000 10884671392 11334664192 1948094608 19.211 100 47 95 0 1971653920 9837744 13721568
23:58:15 102797 8192000000 10897430560 11344601088 1914937904 18.946 98 13 26 0 1931744000 13538048 3268048
00:00:09 83035 8192000000 10901787296 11354968064 1967050160 19.362 100 22 44 0 1981314240 8372240 5891840
00:01:47 42598 8192000000 10898807344 11348733952 1933902592 19.098 98 20 39 0 1948083600 9007744 5173264
00:03:17 66957 8192000000 10905631552 11344084992 1947670512 19.208 99 39 77 0 1972533392 13201328 11661552
00:04:32 75545 8192000000 10896298496 11365748736 1927879008 19.050 98 7 14 1 1945427296 15638640 1909648
00:05:55 82077 8192000000 10912801136 11375177728 1937642256 19.128 98 12 24 0 1954863248 13988592 3232400
00:08:17 72718 8192000000 10939551312 11369455616 1944613728 19.184 98 30 59 1 1964576544 11501568 8461248
00:09:36 16548 8192000000 10915956304 11369402368 1980678496 19.470 100 24 48 1 1996240016 9050480 6511040
00:10:06 27997 8192000000 10920004448 11372212224 1965712528 19.351 99 25 48 0 1984799824 11940880 7146416
00:10:40 41046 8192000000 10945620112 11396141056 1996148080 19.592 100 27 54 1 2021519456 17448528 7922848
00:11:44 81678 8192000000 10952153248 11407351808 1999363056 19.618 100 40 80 0 2031155920 19944832 11848032
00:13:31 30865 8192000000 10923342528 11387232256 1966890704 19.361 98 34 68 0 1985590320 9468608 9231008
00:15:32 19000 8192000000 10926860128 11394371584 1992970880 19.567 100 26 52 1 2009649648 9401056 7277712
00:15:57 45119 8192000000 10953356544 11403661312 1987805072 19.526 99 41 82 1 2012996512 12108864 13082576
00:16:51 44034 8192000000 10925645424 11393597440 1967200240 19.363 98 34 67 0 1989594768 12731520 9663008
00:17:41 18439 8192000000 10933605552 11383930880 1958919936 19.297 98 47 94 3 1984543520 11146560 14477024
00:18:10 34817 8192000000 10911525136 11387154432 1966467024 19.357 99 23 47 2 1988978480 15233760 7277696
00:18:51 14585 8192000000 10919990448 11391406080 1988796144 19.534 100 25 49 1 2010796448 14392784 7607520
00:19:15 47682 8192000000 10898915392 11385192448 1969580304 19.382 99 12 24 2 1990833712 17525216 3728192
00:20:13 51559 8192000000 10911832320 11384442880 1961860288 19.321 99 14 28 0 1977297744 11424368 4013088
00:21:10 91645 8192000000 10903145008 11378638848 1981040048 19.473 100 14 28 1 1995748384 10362992 4345344
00:22:50 43717 8192000000 10922260432 11398393856 1995564112 19.588 100 23 47 0 2016214432 14250112 6400208
00:23:41 45981 8192000000 10911199808 11386925056 1957254848 19.284 98 13 26 1 1968664432 7765664 3643920
00:24:55 69748 8192000000 10892157328 11381678080 1946105840 19.195 98 14 28 0 1963367776 13390432 3871504
00:26:29 43579 8192000000 10900687344 11378708480 1952022464 19.243 99 7 14 0 1967890832 13995744 1872624
00:27:22 66053 8192000000 10891473472 11364917248 1912879552 18.930 96 15 30 0 1928475920 11738048 3858320
00:28:34 58035 8192000000 10889109808 11349536768 1877393680 18.644 95 22 44 0 1898814224 15058896 6361648
00:29:38 39273 8192000000 10855244544 11308429312 1827411264 18.238 93 29 59 2 1845940160 10332400 8196496
00:30:23 53833 8192000000 10871939408 11336761344 1899538160 18.823 98 15 30 1 1915359440 11833024 3988256
00:31:23 67157 8192000000 10880163424 11353178112 1854304176 18.457 95 19 38 0 1874089504 14535408 5249920
00:32:37 71751 8192000000 10882772688 11325509632 1837901200 18.324 94 22 44 1 1857087744 12848320 6338224
00:33:57 11849 8192000000 10902009328 11351355392 1956535952 19.278 100 45 90 1 1978336608 9506016 12294640
00:34:23 20747 8192000000 10905747856 11357298688 1939596464 19.144 99 53 106 2 1969202896 15128800 14477632
00:34:53 41039 8192000000 10883253760 11348242432 1897118544 18.803 97 36 72 1 1923667648 16607232 9941872
00:35:41 55602 8192000000 10894087392 11348299776 1877124624 18.642 96 22 44 0 1894226976 11145168 5957184
00:36:48 57248 8192000000 10885725456 11333292032 1878643600 18.654 96 24 47 1 1900935296 15025648 7266048
00:37:55 65542 8192000000 10875109504 11350671360 1898108320 18.811 98 20 40 0 1921352000 17408208 5835472
00:39:14 90386 8192000000 10867821504 11336028160 1895689104 18.792 98 7 13 1 1913817664 16677184 1451376
00:41:04 45201 8192000000 10881228624 11352772608 1922443536 19.006 99 16 31 0 1944401056 18115792 3841728
00:41:56 121240 8192000000 10881442576 11365040128 1954009488 19.258 100 21 42 3 1979660080 19638272 6012320
00:44:06 43603 8192000000 10861116688 11319341056 1906428416 18.878 97 34 68 0 1924142000 8078288 9635296
00:44:56 41512 8192000000 10869336832 11324047360 1910152192 18.908 98 41 82 1 1934646656 13333984 11160480
00:45:49 14583 8192000000 10868857392 11314606080 1917642128 18.968 99 38 75 1 1941632688 13666096 10324464
00:46:12 15724 8192000000 10891419328 11341066240 1936117504 19.116 100 30 60 0 1966586048 22254320 8214224
00:46:50 79355 8192000000 10867296848 11341402112 1914229840 18.941 98 20 39 3 1934303312 14633680 5439792
00:49:21 34809 8192000000 10882041856 11356291072 1937366432 19.126 99 23 44 3 1953963984 9867824 6729728
00:50:02 58058 8192000000 10866989568 11347099648 1904374800 18.861 97 16 32 0 1922823744 13661808 4787136
00:51:14 37311 8192000000 10886259168 11366076416 1954361104 19.261 100 21 43 0 1974608272 14170800 6076368
00:51:58 63848 8192000000 10896083152 11384217600 1965485280 19.350 100 19 38 0 1991050944 19779296 5786368
00:53:09 60599 8192000000 10904893776 11380154368 1956515008 19.278 99 20 41 0 1977645232 15365680 5764544
00:54:20 94981 8192000000 10871715216 11355377664 1922523392 19.007 98 14 28 0 1946075936 19275952 4276592
00:56:07 78052 8192000000 10894672224 11377696768 1948643024 19.216 99 6 12 1 1965145248 14786464 1715760
00:57:34 48468 8192000000 10885008320 11359358976 1911959312 18.922 97 10 20 0 1925984544 11659184 2366048
00:58:31 25018 8192000000 10905147984 11373875200 1956118768 19.275 99 34 68 2 1974518176 9253424 9145984
00:59:10 63694 8192000000 10916706368 11393814528 1985927840 19.512 100 19 38 2 2002288576 10328560 6032176
01:00:25 52804 8192000000 10919642368 11383799808 1968560544 19.374 99 28 56 1 1985474352 9058352 7855456
01:01:27 31384 8192000000 10914274624 11387047936 1966478784 19.358 99 35 70 1 1989226208 12780544 9966880
01:02:04 49967 8192000000 10918601904 11404746752 1980382832 19.468 100 17 34 1 2001020640 15928768 4709040
01:03:08 66800 8192000000 10921011280 11387338752 1946730880 19.200 98 15 31 0 1964696400 13934096 4031424
01:04:30 54053 8192000000 10905086672 11381899264 1936318224 19.117 98 27 54 2 1955550576 11921280 7311072
01:05:31 110114 8192000000 10910260368 11391033344 1940893088 19.154 98 10 20 1 1953944352 10206848 2844416
01:07:29 89702 8192000000 10901288560 11387383808 1900537536 18.831 96 3 6 0 1916615968 15233280 845152
01:09:13 67235 8192000000 10901559312 11368624128 1918274624 18.973 97 9 18 0 1929933120 9463440 2195056
01:10:26 67700 8192000000 10889422576 11361402880 1924863040 19.026 97 27 54 2 1942098784 9968288 7267456
01:12:24 96661 8192000000 10906467120 11348770816 1903382016 18.853 97 21 42 0 1920728128 11173152 6172960
01:14:09 58981 8192000000 10904085184 11368341504 1947934800 19.210 99 33 66 0 1970723920 13085792 9703328
01:15:15 50124 8192000000 10873895712 11353145344 1941032288 19.155 99 35 70 1 1962760016 11689888 10037840
01:16:19 96811 8192000000 10877728032 11361193984 1922388976 19.006 98 8 16 0 1938013840 13284464 2340400
01:18:21 71979 8192000000 10856717488 11336425472 1832555424 18.280 94 11 20 1 1842983120 7717584 2710112
01:19:39 83571 8192000000 10865581632 11347058688 1922450352 19.006 99 10 20 2 1935560896 10092448 3018096
01:21:10 58758 8192000000 10857930304 11329302528 1912634320 18.928 98 16 32 0 1930323088 13227440 4461328
01:22:25 43524 8192000000 10872358080 11336282112 1920306496 18.989 99 29 58 0 1943565664 15448656 7810512
01:23:20 75896 8192000000 10847102848 11328118784 1899376976 18.821 98 10 20 0 1916124640 13839648 2908016
01:25:25 76426 8192000000 10859083376 11360366592 1917782000 18.969 99 11 22 1 1935143184 14143296 3217888
01:27:02 14168 8192000000 9627746928 9955897344 771681984 8.608 40 2 2 0 775965600 3645456 638160

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-01-2021 01:28:51 to 01-01-2021 01:29:23.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 157 v_add_invoice_to_stock 335544517
except 20 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          240252
MON$OLDEST_ACTIVE               240253
MON$OLDEST_SNAPSHOT             240253
MON$NEXT_TRANSACTION            240253
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                       2044128
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'

01.01.21 01:29:27. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-01-01 01:29:29 No severe PSQL-related problems occured
01.01.21 01:29:30. End of report.