Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.02.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 16621184 kB
MemAvailable 31262828 kB
Buffers 0 kB
Cached 15090012 kB
SwapCached 4876 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-04 01:27:16
DTS_END                         2021-02-04 01:27:16.4200
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/52444
TRN_ID                          242487
ATT_ID                          729
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: 9161.04 20380 1099325
customer order: creation 174.75 329 20970
customer order: refuse 15.60 347 1872
order to supplier: creation 46.85 1366 5622
order to supplier: removal 3.31 116665 397
invoice (draft): creation 46.58 3907 5590
invoice (draft): removal 51.51 941 6181
invoice accept: apply 42.66 18240 5119
invoice accept: cancel 46.62 902 5594
customer reserve: creation 3893.60 181 467232
customer reserve: removal 4538.03 67 544564
realization accept: apply 86.52 206 10382
realization accept: cancel 84.36 107 10123
payment from customer: creation 59.24 132 7109
payment from customer: removal 5.93 84 712
payment to supplier: creation 49.18 137 5901
payment to supplier: removal 3.48 92 417
service: total inventory turnovers 4.91 1468 589
service: total monetary turnovers 7.12 46 854
service: aggregate perf. data 0.78 24525 93
service: refresh index statistics 0.03 237864 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-02-2021 01:29:02 to 04-02-2021 01:29:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6537
TEST_TIME 2 6314
TEST_TIME 3 5139
TEST_TIME 4 5062
TEST_TIME 5 5506
TEST_TIME 6 5554
TEST_TIME 7 5238
TEST_TIME 8 5614
TEST_TIME 9 5688
TEST_TIME 10 6006
TEST_TIME 11 6430
TEST_TIME 12 7776
TEST_TIME 13 7894
TEST_TIME 14 8078
TEST_TIME 15 8294
TEST_TIME 16 8292
TEST_TIME 17 8378
TEST_TIME 18 8752
TEST_TIME 19 8645
TEST_TIME 20 8694
TEST_TIME 21 8675
TEST_TIME 22 8964
TEST_TIME 23 9112
TEST_TIME 24 9271
TEST_TIME 25 9197
TEST_TIME 26 9397
TEST_TIME 27 9380
TEST_TIME 28 9344
TEST_TIME 29 9424
TEST_TIME 30 9732
TEST_TIME 31 9925
TEST_TIME 32 10741
TEST_TIME 33 11672
TEST_TIME 34 11454
TEST_TIME 35 11198
TEST_TIME 36 11017
TEST_TIME 37 11104
TEST_TIME 38 10922
TEST_TIME 39 10741
TEST_TIME 40 10729
TEST_TIME 41 10616
TEST_TIME 42 10533
TEST_TIME 43 10387
TEST_TIME 44 10298
TEST_TIME 45 10221
TEST_TIME 46 10275
TEST_TIME 47 10122
TEST_TIME 48 10004
TEST_TIME 49 10010
TEST_TIME 50 9932
TEST_TIME 51 9908
TEST_TIME 52 9878
TEST_TIME 53 9836
TEST_TIME 54 9706
TEST_TIME 55 9723
TEST_TIME 56 9701
TEST_TIME 57 9706
TEST_TIME 58 9747
TEST_TIME 59 9631
TEST_TIME 60 9515
TEST_TIME 61 9503
TEST_TIME 62 9400
TEST_TIME 63 9347
TEST_TIME 64 9294
TEST_TIME 65 9339
TEST_TIME 66 9389
TEST_TIME 67 9423
TEST_TIME 68 9404
TEST_TIME 69 9371
TEST_TIME 70 9531
TEST_TIME 71 9501
TEST_TIME 72 9454
TEST_TIME 73 9473
TEST_TIME 74 9496
TEST_TIME 75 9447
TEST_TIME 76 9499
TEST_TIME 77 9530
TEST_TIME 78 9534
TEST_TIME 79 9561
TEST_TIME 80 9455
TEST_TIME 81 9418
TEST_TIME 82 9464
TEST_TIME 83 9429
TEST_TIME 84 9398
TEST_TIME 85 9365
TEST_TIME 86 9322
TEST_TIME 87 9325
TEST_TIME 88 9266
TEST_TIME 89 9221
TEST_TIME 90 9269
TEST_TIME 91 9301
TEST_TIME 92 9319
TEST_TIME 93 9327
TEST_TIME 94 9324
TEST_TIME 95 9292
TEST_TIME 96 9328
TEST_TIME 97 9350
TEST_TIME 98 9348
TEST_TIME 99 9369
TEST_TIME 100 9340
TEST_TIME 101 9367
TEST_TIME 102 9419
TEST_TIME 103 9408
TEST_TIME 104 9445
TEST_TIME 105 9492
TEST_TIME 106 9436
TEST_TIME 107 9400
TEST_TIME 108 9388
TEST_TIME 109 9341
TEST_TIME 110 9312
TEST_TIME 111 9288
TEST_TIME 112 9277
TEST_TIME 113 9261
TEST_TIME 114 9268
TEST_TIME 115 9247
TEST_TIME 116 9205
TEST_TIME 117 9189
TEST_TIME 118 9267
TEST_TIME 119 9234
TEST_TIME 120 9165

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-02-2021 01:29:05 to 04-02-2021 01:29:09.

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 1531166 1531166 0 0.00 0 25088 7 0 0
doc_list_biud 1531164 1531164 0 0.00 0 73829 30 0 0
sp_add_invoice_to_stock 5279 5119 160 3.03 38 146908 18241 0 160
sp_cancel_adding_invoice 5594 5594 0 0.00 5 74383 903 0 0
sp_cancel_client_order 1872 1872 0 0.00 5 8913 347 0 0
sp_cancel_customer_reserve 544564 544564 0 0.00 1 73831 67 0 0
sp_cancel_pay_from_customer 712 712 0 0.00 3 3931 84 0 0
sp_cancel_pay_to_supplier 417 417 0 0.00 3 7438 92 0 0
sp_cancel_supplier_invoice 6197 6181 16 0.25 2 33496 941 0 16
sp_cancel_supplier_order 397 397 0 0.00 10 1108582 116666 0 0
sp_cancel_write_off 10123 10123 0 0.00 1 11492 108 0 0
sp_client_order 20970 20970 0 0.00 4 38950 330 0 0
sp_customer_reserve 467232 467232 0 0.00 0 68535 181 0 0
sp_fill_shopping_cart 32172 32172 0 0.00 1 35978 48 0 0
sp_fill_shopping_cart_clo_res 467231 467231 0 0.00 0 18932 15 0 0
sp_get_clo_for_invoice 5114 5114 0 0.00 0 30125 362 0 0
sp_kill_cost_storno 16846 16846 0 0.00 0 9602 57 0 0
sp_kill_qstorno_ret_qs2qd 1105829 1105829 0 0.00 0 73826 37 0 0
sp_kill_qty_storno 584226 584226 0 0.00 0 73828 79 0 0
sp_lock_selected_doc 21489 21489 0 0.00 0 9942 5 0 0
sp_make_cost_storno 28505 28505 0 0.00 0 25023 62 0 0
sp_multiply_rows_for_pdistr 28504 28504 0 0.00 0 16778 36 0 0
sp_multiply_rows_for_qdistr 20970 20970 0 0.00 0 38937 144 0 0
sp_pay_from_customer 7109 7109 0 0.00 4 16805 133 0 0
sp_pay_to_supplier 5901 5901 0 0.00 5 15030 138 0 0
sp_payment_common 13009 13009 0 0.00 1 16781 45 0 0
sp_qd_handle_on_cancel_clo 1872 1872 0 0.00 0 8895 316 0 0
sp_qd_handle_on_invoice_upd_sts 10708 10708 0 0.00 0 31153 345 0 0
sp_qd_handle_on_reserve_upd_sts 10381 10381 0 0.00 0 15123 63 0 0
sp_reserve_write_off 10382 10382 0 0.00 6 17427 207 0 0
sp_supplier_invoice 5590 5590 0 0.00 5 86739 3908 0 0
sp_supplier_order 5622 5622 0 0.00 5 70619 1367 0 0
srv_aggregate_perf_data 93 93 0 0.00 2952 340941 24526 0 0
srv_fill_mon_cache_memory 172 172 0 0.00 1046 129513 29570 0 0
srv_find_qd_qs_mism 1050631 1050631 0 0.00 0 12733 5 0 0
srv_make_invnt_saldo 589 589 0 0.00 21 127245 1468 0 0
srv_make_money_saldo 854 854 0 0.00 1 9216 47 0 0
srv_recalc_idx_stat 4 4 0 0.00 138348 344826 237864 0 0
t$perf-abend:sp_add_invoice_to_stock 160 160 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5120 5120 0 0.00 0 10036 178 0 0
t$perf-norm:sp_cancel_adding_invoice 427 427 0 0.00 0 6140 141 0 0
t$perf-norm:sp_cancel_client_order 1872 1872 0 0.00 0 2472 16 0 0
t$perf-norm:sp_cancel_customer_reserve 716 716 0 0.00 0 1368 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 712 712 0 0.00 0 2328 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 417 417 0 0.00 0 341 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 435 435 0 0.00 0 1501 23 0 0
t$perf-norm:sp_cancel_supplier_order 397 397 0 0.00 0 24996 1673 0 0
t$perf-norm:sp_cancel_write_off 1018 1018 0 0.00 0 1183 6 0 0
t$perf-norm:sp_client_order 20970 20970 0 0.00 0 23380 22 0 0
t$perf-norm:sp_customer_reserve 1052 1052 0 0.00 0 1366 7 0 0
t$perf-norm:sp_pay_from_customer 7109 7109 0 0.00 0 9187 13 0 0
t$perf-norm:sp_pay_to_supplier 5901 5901 0 0.00 0 3652 9 0 0
t$perf-norm:sp_reserve_write_off 10382 10382 0 0.00 0 5736 11 0 0
t$perf-norm:sp_supplier_invoice 5590 5590 0 0.00 0 6321 23 0 0
t$perf-norm:sp_supplier_order 5622 5622 0 0.00 0 5843 16 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 347 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 17507 117 0 0
t$perf-norm:srv_make_invnt_saldo 589 589 0 0.00 0 3656 40 0 0
t$perf-norm:srv_make_money_saldo 854 854 0 0.00 0 714 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 10548 10228 320 3.03 0 4645 20 0 320
v_all_customers 37298 37298 0 0.00 0 221 1 0 0
v_all_suppliers 30658 30658 0 0.00 0 113 1 0 0
v_all_wares 41940 41940 0 0.00 0 221 1 0 0
v_cancel_adding_invoice 854 854 0 0.00 0 1575 8 0 0
v_cancel_client_order 3744 3744 0 0.00 0 2403 5 0 0
v_cancel_customer_prepayment 1424 1424 0 0.00 0 3598 6 0 0
v_cancel_customer_reserve 1432 1432 0 0.00 0 360 4 0 0
v_cancel_payment_to_supplier 834 834 0 0.00 0 878 7 0 0
v_cancel_supplier_invoice 902 870 32 3.54 0 1217 15 0 32
v_cancel_supplier_order 794 794 0 0.00 0 2027 8 0 0
v_cancel_write_off 2036 2036 0 0.00 0 6133 17 0 0
v_max_id_clo_ord 5616 5616 0 0.00 0 1193 2 0 0
v_max_id_clo_res 1052 1052 0 0.00 0 2506 9 0 0
v_max_id_ord_sup 5586 5586 0 0.00 0 6281 3 0 0
v_max_non_paid_invoice 1773 1773 0 0.00 0 3391 4 0 0
v_max_non_paid_realizn 4124 4124 0 0.00 0 2178 3 0 0
v_min_id_clo_ord 5616 5616 0 0.00 0 5084 9 0 0
v_min_id_clo_res 1052 1052 0 0.00 0 7627 22 0 0
v_min_id_ord_sup 5586 5586 0 0.00 0 3397 6 0 0
v_min_non_paid_invoice 5900 5900 0 0.00 0 11769 28 0 0
v_min_non_paid_realizn 7109 7109 0 0.00 0 16754 30 0 0
v_our_firm 10612 10612 0 0.00 0 42 1 0 0
v_reserve_write_off 20762 20762 0 0.00 0 6123 7 0 0
x_lock_depdocs_on_canc_invoice 11340 11340 0 0.00 0 15494 135 0 0
x_lock_depdocs_on_canc_sup_ord 397 397 0 0.00 0 5238 388 0 0
x_make_qstorno_1000_1200 5622 5622 0 0.00 1 70581 1262 0 0
x_make_qstorno_1200_2000 5590 5590 0 0.00 2 82964 3739 0 0
x_make_qstorno_2100_3300 467232 467232 0 0.00 0 68505 163 0 0

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

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:20 21 8192000000 8829731568 8848384000 29520944 0.359 7 4 5 0 29824176 91472 211760
22:57:26 20004 8192000000 10233002448 10534174720 825700384 9.156 66 56 117 1 846695280 2344752 18650144
22:57:54 28322 8192000000 10332908800 10642214912 1369674320 14.324 100 88 177 0 1404015056 4814080 29526656
22:58:31 27311 8192000000 10365715264 10679283712 1415272352 14.731 100 88 177 1 1449999616 5840736 28886528
22:59:06 25630 8192000000 10405618672 10727657472 1450970032 15.046 100 86 173 0 1485263792 6595952 27697808
22:59:44 18255 8192000000 10419587216 10743259136 1473641888 15.246 100 91 182 0 1510705056 7387936 29675232
23:00:13 16992 8192000000 10434414800 10762420224 1484698096 15.343 100 85 170 1 1520206848 7885776 27622976
23:00:40 26138 8192000000 10459401216 10792833024 1509596784 15.560 100 84 166 1 1544629680 8595824 26437072
23:01:16 19562 8192000000 10477528320 10816262144 1528365392 15.723 100 84 168 0 1564208272 9279024 26563856
23:01:44 18026 8192000000 10514792576 10861264896 1559194352 15.989 100 76 152 2 1591913760 9490016 23229392
23:02:10 17688 8192000000 10548470992 10898989056 1599822944 16.338 100 77 154 0 1633128448 10257728 23047776
23:02:38 14911 8192000000 10563437232 10923905024 1628142736 16.579 100 79 158 0 1662367568 11024736 23200096
23:03:07 11096 8192000000 10588093808 10950848512 1650485664 16.768 100 77 154 0 1684554976 11242304 22827008
23:03:25 9667 8192000000 10613634608 10977349632 1672640848 16.955 100 79 158 0 1707505648 11440960 23423840
23:03:42 13544 8192000000 10629976960 10997309440 1685022576 17.060 100 75 149 2 1718480896 11696576 21761744
23:04:03 8799 8192000000 10638925728 11006238720 1696543040 17.156 100 74 148 2 1730451712 12537696 21370976
23:04:19 8847 8192000000 10651872576 11022725120 1710102432 17.270 100 82 164 1 1746954080 13059792 23791856
23:04:35 10700 8192000000 10656485568 11028996096 1710733264 17.275 100 66 132 0 1741924592 12686080 18505248
23:04:54 6301 8192000000 10662070496 11041423360 1734408096 17.472 100 76 152 0 1767823264 12135824 21279344
23:05:10 5576 8192000000 10681425856 11061559296 1747389760 17.580 100 75 148 0 1779603184 11248432 20964992
23:05:22 5631 8192000000 10689385408 11073728512 1758289088 17.670 100 74 145 2 1790653776 11431744 20932944
23:05:35 4124 8192000000 10715113248 11091030016 1771660384 17.781 100 75 150 2 1804050384 11879360 20510640
23:05:47 3867 8192000000 10714096416 11095031808 1779885968 17.849 100 81 162 2 1816064848 13036176 23142704
23:05:59 8474 8192000000 10718492928 11101736960 1785526768 17.895 100 72 144 0 1819458688 13625984 20305936
23:06:15 2724 8192000000 10739927568 11121893376 1796943504 17.989 100 81 159 1 1833193456 14220848 22029104
23:06:25 3072 8192000000 10750271728 11131506688 1809930848 18.095 100 89 177 1 1848166224 13565344 24670032
23:06:35 3575 8192000000 10750213600 11139829760 1812512096 18.116 100 79 158 0 1847343456 12715632 22115728
23:06:46 2543 8192000000 10755367104 11143688192 1823217472 18.204 100 81 162 0 1859241104 13127376 22896256
23:06:55 2170 8192000000 10766297168 11147935744 1830342928 18.262 100 89 178 1 1867795168 13363552 24088688
23:07:04 2832 8192000000 10768461872 11155030016 1830982624 18.267 100 89 178 2 1869623584 14197856 24443104
23:07:13 2236 8192000000 10777055632 11160915968 1833881504 18.291 100 85 170 2 1872030528 13931536 24217488
23:07:22 1929 8192000000 10782662416 11169304576 1840672112 18.346 100 89 176 1 1878374288 12740080 24962096
23:07:30 1961 8192000000 10785460720 11167932416 1844160640 18.375 100 88 175 1 1882341872 13277440 24903792
23:07:39 2003 8192000000 10785840160 11177627648 1848183104 18.407 100 89 174 0 1886264912 13368576 24713232
23:07:47 1914 8192000000 10790405456 11178012672 1849250000 18.416 100 82 165 1 1884914768 12681392 22983376
23:07:55 2476 8192000000 10789020144 11177308160 1852250272 18.440 100 88 176 1 1891072592 13438240 25384080
23:08:04 1804 8192000000 10804232336 11187916800 1856649312 18.476 100 92 183 3 1897432752 13136592 27646848
23:08:13 2062 8192000000 10801722336 11190476800 1858300576 18.489 100 95 190 2 1898461120 12603440 27557104
23:08:22 2677 8192000000 10800682704 11193540608 1860311024 18.506 100 86 170 2 1898227216 13340208 24575984
23:08:31 5851 8192000000 10787588928 11188887552 1859742608 18.501 100 78 156 1 1895051184 13368880 21939696
23:08:43 9673 8192000000 10808839232 11195015168 1859885840 18.502 100 76 155 0 1893605904 11105760 22614304
23:08:59 3544 8192000000 10815369968 11201257472 1868501488 18.572 100 96 192 0 1907018720 11381232 27136000
23:09:09 3558 8192000000 10811359120 11203280896 1868384624 18.571 100 84 168 3 1904653696 12307232 23961840
23:09:19 4515 8192000000 10788036272 11198550016 1863934640 18.535 100 45 90 1 1887046000 9948496 13162864
23:09:33 9402 8192000000 10769778496 11193348096 1862071568 18.520 100 32 64 1 1878917424 7824784 9021072
23:09:52 9267 8192000000 10772540416 11197775872 1866005104 18.552 100 38 77 1 1885445840 8912080 10528656
23:10:10 58563 8192000000 10788883392 11209293824 1871241568 18.594 100 50 98 2 1891691120 5410464 15039088
23:11:15 3891 8192000000 10804833920 11217170432 1880029888 18.665 100 75 150 0 1911133104 9579232 21523984
23:11:26 7825 8192000000 10781007504 11210231808 1867699696 18.566 100 20 40 1 1879466448 6392560 5374192
23:11:39 2953 8192000000 10793366064 11216965632 1875268560 18.627 100 43 86 1 1893536000 5881072 12386368
23:11:49 3260 8192000000 10802630176 11216756736 1879750432 18.663 100 44 89 1 1900012944 8142720 12119792
23:12:00 3417 8192000000 10805053104 11224772608 1879431152 18.661 100 46 92 0 1901907168 9950960 12525056
23:12:11 6710 8192000000 10804811216 11228160000 1880027232 18.665 100 36 72 1 1897374960 7759488 9588240
23:12:27 9676 8192000000 10811519632 11228172288 1879755680 18.663 100 20 39 1 1891626608 5441392 6429536
23:12:45 7837 8192000000 10804769984 11222106112 1884215152 18.699 100 27 53 2 1897557360 5997184 7345024
23:13:00 8287 8192000000 10811853328 11228172288 1886331216 18.716 100 35 71 2 1902238288 5866256 10040816
23:13:17 11042 8192000000 10791332464 11224072192 1884207008 18.699 100 20 39 2 1896609936 5731840 6671088
23:13:36 7856 8192000000 10799998944 11230343168 1893235264 18.772 100 26 52 1 1906917232 6229392 7452576
23:13:50 9624 8192000000 10800984624 11233247232 1890431200 18.749 100 26 52 0 1904799424 6737072 7631152
23:14:17 13471 8192000000 10795941632 11231080448 1892050704 18.762 100 18 37 1 1903602960 5910960 5641296
23:14:41 62623 8192000000 10824020752 11244687360 1895713632 18.792 100 34 68 1 1911961392 6187424 10060336
23:15:54 4904 8192000000 10812006832 11242688512 1896751696 18.800 100 25 50 2 1909769360 6433888 6583776
23:16:06 5922 8192000000 10818253472 11250110464 1901741472 18.840 100 28 56 1 1916708688 7009456 7957760
23:16:18 7519 8192000000 10836570944 11255078912 1907427568 18.886 100 36 72 5 1924062640 5794672 10840400
23:16:35 7967 8192000000 10825943904 11256078336 1907922704 18.890 100 29 56 2 1921991824 6003712 8065408
23:16:49 7775 8192000000 10806700736 11242926080 1897483920 18.806 100 23 46 3 1909372384 5984320 5904144
23:17:05 7809 8192000000 10812238784 11242229760 1882539504 18.686 99 28 55 0 1897178768 5810144 8829120
23:17:22 8334 8192000000 10759518368 11186675712 1808425888 18.083 96 25 50 1 1822011456 6234896 7350672
23:17:38 10316 8192000000 10791071680 11218673664 1860955760 18.511 99 19 38 3 1872213040 5366880 5890400
23:17:59 5618 8192000000 10767755472 11192320000 1801575088 18.027 96 23 46 1 1817375728 9616640 6184000
23:18:11 8515 8192000000 10768741360 11182247936 1784303792 17.885 96 17 35 2 1798725440 9103840 5317808
23:18:30 7698 8192000000 10744889776 11162812416 1802734544 18.036 98 34 68 1 1818857248 6925520 9197184
23:18:47 7153 8192000000 10737851232 11154337792 1791276992 17.942 98 36 72 1 1807674320 5839456 10557872
23:19:01 9247 8192000000 10742030368 11175546880 1809025568 18.088 98 17 35 1 1823430416 9425808 4979040
23:19:17 63999 8192000000 10699487424 11120254976 1686258976 17.070 92 29 57 2 1700434512 5205536 8970000
23:20:30 6422 8192000000 10700987136 11120037888 1731636288 17.449 96 17 34 2 1742315072 5839792 4838992
23:20:44 3463 8192000000 10718109840 11127750656 1757000816 17.660 97 38 74 2 1774228128 6194800 11032512
23:20:54 6259 8192000000 10714973152 11129716736 1752706096 17.624 97 46 92 0 1776890432 11326224 12858112
23:21:10 4746 8192000000 10722955984 11132903424 1759129296 17.677 97 42 84 1 1781424592 10446080 11849216
23:21:21 6617 8192000000 10726620352 11133693952 1788745312 17.921 99 23 47 1 1801552064 5882352 6924400
23:21:34 8776 8192000000 10715786032 11127435264 1749182384 17.595 97 23 46 1 1765315616 9420848 6712384
23:21:49 7297 8192000000 10701433408 11127545856 1765808272 17.732 98 23 45 4 1778555040 5766416 6980352
23:22:03 6272 8192000000 10723515344 11148791808 1814628784 18.134 100 25 49 3 1827760832 5684528 7447520
23:22:15 8143 8192000000 10719247072 11135066112 1758992736 17.676 97 22 44 1 1771125088 5857760 6274592
23:22:30 5268 8192000000 10724370128 11144368128 1809032432 18.088 100 28 56 0 1822988864 5575392 8381040
23:22:45 11174 8192000000 10737395376 11158540288 1807295952 18.074 99 20 40 0 1819131488 5496416 6339120
23:23:03 9821 8192000000 10754344544 11176042496 1834175680 18.293 100 32 63 1 1849427120 5551232 9700208
23:23:20 8616 8192000000 10754910752 11175485440 1835647280 18.305 100 21 41 2 1847376544 5459760 6269504
23:23:36 8146 8192000000 10752585696 11185627136 1841131584 18.350 100 12 24 0 1850221360 5868784 3220992
23:23:52 24469 8192000000 10760157392 11190460416 1850895040 18.429 100 27 51 3 1864006848 5622464 7489344
23:24:34 37498 8192000000 10768238128 11197456384 1854957568 18.462 100 17 32 3 1865077552 5395104 4724880
23:25:17 6000 8192000000 10781859264 11205398528 1863983056 18.536 100 37 75 3 1881392576 5595808 11813712
23:25:33 10311 8192000000 10782768416 11210227712 1868450544 18.572 100 37 71 5 1884395024 6839824 9104656
23:25:51 5648 8192000000 10774125952 11209510912 1871512464 18.597 100 30 60 0 1890591248 10328880 8749904
23:26:02 6888 8192000000 10792168496 11213127680 1875175968 18.626 100 40 81 0 1892830736 5426896 12227872
23:26:16 6351 8192000000 10796064576 11223724032 1876768736 18.639 100 36 72 2 1895036144 8282752 9984656
23:26:29 6032 8192000000 10797845648 11223388160 1875200320 18.626 100 28 55 3 1889187680 5928176 8059184
23:26:46 8199 8192000000 10799258992 11224195072 1877748816 18.647 100 20 40 0 1888928480 5601952 5577712
23:27:00 6401 8192000000 10807125264 11232215040 1886014496 18.714 100 21 42 1 1897054432 5330304 5709632
23:27:13 24146 8192000000 10827801648 11250999296 1898044560 18.811 100 25 49 1 1909431824 4838128 6549136
23:27:44 10197 8192000000 10844056656 11262656512 1911309088 18.917 100 42 84 0 1929028368 5927152 11792128
23:28:01 12024 8192000000 10853472592 11271282688 1920916480 18.994 100 51 102 1 1943430032 8377008 14136544
23:28:28 8501 8192000000 10860945088 11283116032 1928870384 19.058 100 56 112 2 1954964032 10384864 15708784
23:28:45 32733 8192000000 10879044288 11294138368 1931356368 19.078 100 49 96 1 1953415904 9266496 12793040
23:29:24 66957 8192000000 10864787136 11300405248 1938012368 19.131 100 45 90 1 1962012176 10232576 13767232
23:30:53 13572 8192000000 10875745728 11307180032 1946154448 19.196 100 36 70 0 1969284272 12973632 10156192
23:31:15 7380 8192000000 10890751712 11314774016 1950750752 19.232 100 42 83 2 1976077072 12866224 12460096
23:31:35 17168 8192000000 10897494336 11327438848 1961076960 19.315 100 53 106 2 1992311616 16163072 15071584
23:32:14 17067 8192000000 10905986272 11338821632 1964899216 19.345 100 33 66 0 1990568048 15755616 9913216
23:32:44 11674 8192000000 10907100688 11342684160 1974907504 19.424 100 43 86 1 2001616768 14584480 12124784
23:33:08 11024 8192000000 10921495440 11353894912 1979875408 19.464 100 46 92 0 2009439408 15872128 13691872
23:33:33 2850 8192000000 10927663856 11360866304 1985742512 19.510 100 53 104 2 2016624256 15957696 14924048
23:33:44 6137 8192000000 10932806560 11363024896 1984293024 19.499 100 48 96 1 2018357760 20132384 13932352
23:33:58 8341 8192000000 10921481712 11354083328 1968497408 19.374 99 54 108 1 1999811904 16153232 15161264
23:34:23 12265 8192000000 10924842288 11348090880 1969916080 19.385 99 58 115 0 2004689968 18078864 16695024
23:34:46 7248 8192000000 10931263696 11362222080 1987006912 19.520 100 59 118 1 2022557984 18720736 16830336
23:35:01 7521 8192000000 10927797024 11358973952 1981109968 19.473 100 54 107 0 2016320736 19342640 15868128
23:35:16 13057 8192000000 10934931888 11375104000 1992445648 19.563 100 50 98 1 2029919936 23536048 13938240
23:35:37 11159 8192000000 10952005952 11381530624 1994051568 19.576 100 54 108 2 2033499472 23236384 16211520
23:35:54 14914 8192000000 10939051712 11372625920 1993380880 19.570 100 60 120 1 2031969008 20959504 17628624
23:36:17 15395 8192000000 10919833616 11349016576 1964725184 19.344 99 50 98 2 2000187296 20162112 15300000
23:36:44 4609 8192000000 10936490288 11360026624 1985816672 19.511 100 71 140 1 2028099280 20845952 21436656
23:37:01 11547 8192000000 10940716048 11375198208 1985170800 19.506 100 52 101 1 2027948320 28199664 14577856
23:37:21 7636 8192000000 10945664768 11379433472 1991891536 19.559 100 52 104 0 2030863296 23412928 15558832
23:37:36 4890 8192000000 10932754512 11367735296 1972067152 19.402 99 64 128 1 2012382192 21177888 19137152
23:37:48 10443 8192000000 10919601824 11354546176 1962204496 19.324 99 62 124 1 2002532656 22055472 18272688
23:38:08 5287 8192000000 10934541728 11365048320 1979118448 19.458 100 51 102 0 2018265808 23431328 15716032
23:38:21 5263 8192000000 10937584560 11362942976 1982350032 19.483 100 63 124 1 2025701376 23966752 19384592
23:38:33 5369 8192000000 10941382592 11370545152 1979709184 19.462 100 65 129 1 2024801824 25291328 19801312
23:38:49 3840 8192000000 10942977440 11373002752 1985479696 19.508 100 71 142 1 2033186464 26266640 21440128
23:38:59 3036 8192000000 10928184944 11357691904 1972106656 19.402 100 65 129 0 2015929728 24457664 19365408
23:39:09 4712 8192000000 10953442448 11374985216 1987047088 19.520 100 72 145 2 2035531792 27312864 21171840
23:39:21 1978 8192000000 10954546080 11368177664 1985079616 19.505 100 90 180 2 2037597520 25726416 26791488
23:39:30 5194 8192000000 10945864736 11358523392 1974617552 19.422 100 75 147 1 2020195840 24611312 20966976
23:39:42 2412 8192000000 10938142368 11356315648 1973192816 19.411 100 93 186 1 2026220576 24742416 28285344
23:39:52 1046 8192000000 10948911632 11360841728 1976805152 19.439 100 91 181 1 2028938464 25489760 26643552
23:40:01 4256 8192000000 10919431168 11341639680 1962315680 19.324 100 74 148 1 2006500848 21721216 22463952
23:40:13 2959 8192000000 10916011376 11337596928 1959005536 19.298 100 77 153 1 2003362368 21810848 22545984
23:40:24 2628 8192000000 10936771824 11355959296 1969890064 19.385 100 80 158 3 2016100880 21046480 25164336
23:40:34 10921 8192000000 10883149392 11308679168 1915989600 18.955 98 64 128 0 1955915392 20724768 19201024
23:40:56 2781 8192000000 10906078944 11331887104 1951904208 19.242 100 67 134 4 1996031808 23719248 20408352
23:41:06 6758 8192000000 10926963984 11343831040 1962136208 19.323 100 65 130 0 2005203792 23514832 19552752
23:41:24 2118 8192000000 10917774576 11331108864 1938907008 19.138 99 84 166 2 1989306544 25182928 25216608
23:41:32 4523 8192000000 10888439152 11309314048 1918175536 18.972 99 66 132 2 1963832128 25755344 19901248
23:41:50 2318 8192000000 10910666752 11330777088 1941752080 19.161 100 70 139 0 1990710880 27646192 21312608
23:42:00 8929 8192000000 10909756640 11325943808 1942652976 19.168 100 72 142 1 1990693136 26969632 21070528
23:42:19 2446 8192000000 10930759360 11338858496 1954203504 19.260 100 80 160 0 2008503600 30862272 23437824
23:42:28 9719 8192000000 10918871168 11338235904 1955604368 19.271 100 72 144 1 2008620016 32108880 20906768
23:42:45 7434 8192000000 10896755568 11301871616 1906278704 18.877 98 71 138 0 1958056064 31563248 20214112
23:43:00 1869 8192000000 10919090784 11331244032 1949327936 19.221 100 86 171 2 2004331664 29213744 25789984
23:43:10 1263 8192000000 10913063488 11321663488 1938317872 19.133 99 79 157 0 1991320336 29561312 23441152
23:43:19 4941 8192000000 10916929248 11342143488 1948903600 19.218 100 66 132 3 1999822384 30983376 19935408
23:43:34 9508 8192000000 10910700320 11336765440 1927716032 19.049 99 59 118 0 1977860720 31359840 18784848
23:43:52 7623 8192000000 10908945456 11328389120 1939053392 19.139 100 65 129 0 1990987280 32699840 19234048
23:44:07 3390 8192000000 10878956400 11303682048 1919218144 18.981 100 62 122 2 1967020960 29671696 18131120
23:44:17 4296 8192000000 10875934928 11286745088 1895312400 18.789 99 81 164 1 1949540096 30258992 23968704
23:44:29 3872 8192000000 10884555136 11296989184 1912272848 18.925 100 77 152 0 1967057408 31768656 23015904
23:44:44 2860 8192000000 10891260256 11293282304 1911555872 18.919 100 71 141 0 1965839664 32894928 21388864
23:44:54 3643 8192000000 10894728736 11303260160 1918888752 18.978 100 79 156 2 1977659360 34913216 23857392
23:45:08 1267 8192000000 10895889808 11294281728 1908981600 18.898 99 87 173 1 1968803872 35001728 24820544
23:45:19 2368 8192000000 10905324112 11318579200 1930842080 19.074 100 80 158 1 1990606672 34908896 24855696
23:45:34 4337 8192000000 10865081328 11298816000 1889221824 18.740 98 51 102 1 1942849056 38077728 15549504
23:45:48 5180 8192000000 10895584160 11309252608 1928753280 19.057 100 66 128 0 1977895152 30563904 18577968
23:46:00 9138 8192000000 10896710768 11323711488 1938258320 19.133 100 48 96 1 1984433952 31776224 14399408
23:46:21 7242 8192000000 10897350240 11336159232 1943643088 19.176 100 59 118 1 1994978928 32795040 18540800
23:46:35 14875 8192000000 10887083344 11311636480 1900785344 18.833 98 45 86 3 1947070512 32133792 14151376
23:47:01 5438 8192000000 10924397296 11338031104 1942651776 19.168 100 68 130 1 1999736816 36585520 20499520
23:47:17 5110 8192000000 10914176528 11331354624 1935131600 19.108 99 61 120 2 1992795872 38333360 19330912
23:47:31 5520 8192000000 10917087376 11347652608 1952320960 19.245 100 49 98 1 2005134832 37078816 15735056
23:47:52 4119 8192000000 10921723552 11350269952 1955604512 19.271 100 51 102 1 2011789200 38913856 17270832
23:48:04 3644 8192000000 10927633616 11341062144 1943429024 19.174 99 74 149 3 2006680464 39935120 23316320
23:48:14 5883 8192000000 10931093008 11350454272 1938406560 19.134 99 63 126 1 1998378080 40338528 19632992
23:48:29 6852 8192000000 10926278656 11362955264 1953838288 19.257 100 45 90 0 2013828304 45417792 14572224
23:48:42 4546 8192000000 10928344784 11348774912 1944229360 19.180 99 66 128 1 2005727648 41671728 19826560
23:48:59 3181 8192000000 10933453136 11347759104 1950144576 19.228 99 75 146 3 2016284784 42551104 23589104
23:49:09 2657 8192000000 10940114848 11362062336 1967199712 19.363 100 72 144 1 2025921680 36137120 22584848
23:49:22 10946 8192000000 10942528240 11360624640 1947984016 19.210 99 50 100 2 2000305616 35033968 17287632
23:49:41 1821 8192000000 10943363920 11351502848 1952399936 19.246 99 74 149 4 2010644800 35993728 22251136
23:49:54 3247 8192000000 10967326912 11372810240 1973016976 19.409 100 90 179 2 2039803152 38569328 28216848
23:50:04 4883 8192000000 10959524576 11375222784 1972320256 19.404 100 74 148 2 2036603456 41655968 22627232
23:50:18 4909 8192000000 10952931776 11367579648 1964283552 19.340 99 67 131 2 2027409872 41612560 21513760
23:51:00 6702 8192000000 10948204512 11379396608 1956036672 19.275 99 45 89 0 2011431328 40835392 14559264
23:51:17 4185 8192000000 10954766192 11376619520 1962342000 19.325 99 60 119 1 2022972368 40746976 19883392
23:51:29 1377 8192000000 10962984240 11378618368 1984580880 19.501 100 87 174 1 2054603824 43303360 26719584
23:51:38 5302 8192000000 10972259008 11389739008 1982142928 19.482 100 65 130 1 2049793936 46462608 21188400
23:51:50 19014 8192000000 10932705824 11372003328 1958736192 19.296 99 44 88 0 2019097904 45387984 14973728
23:52:18 8029 8192000000 10963616048 11392438272 1978074368 19.449 100 46 92 1 2039331072 45872800 15383904
23:52:43 4337 8192000000 10967313120 11395231744 1972954288 19.409 99 55 110 1 2035406944 44949600 17503056
23:52:55 1784 8192000000 10981314384 11400544256 1988732288 19.534 100 74 147 3 2058937840 46332112 23873440
23:53:04 5676 8192000000 10975835088 11404955648 1989653792 19.541 100 52 104 1 2054924160 48291952 16978416
23:53:29 8242 8192000000 10987254320 11416481792 1997450752 19.603 100 49 98 2 2063337664 50068848 15818064
23:53:48 10612 8192000000 10974925600 11414458368 1997398880 19.602 100 38 74 0 2057073360 47432400 12242080
23:54:24 8286 8192000000 10980527712 11423510528 2002689056 19.644 100 43 86 0 2063883968 46811600 14383312
23:54:39 6632 8192000000 10990872720 11431428096 2007645840 19.683 100 40 79 2 2071939440 51146992 13146608
23:55:08 13179 8192000000 10997531488 11437604864 2006513760 19.674 100 42 84 2 2075244192 53988064 14742368
23:55:34 14677 8192000000 10981750672 11425165312 1998045680 19.607 100 40 80 1 2064658272 52466848 14145744
23:56:13 12366 8192000000 10998065696 11442147328 2001223024 19.632 100 39 78 1 2075538416 60370720 13944672
23:56:43 17033 8192000000 10976564336 11430350848 1984080432 19.497 100 30 60 1 2060072304 65095680 10896192
23:57:08 32958 8192000000 10971240320 11432013824 1985238448 19.506 100 32 65 0 2062741840 65685760 11817632
23:58:26 33152 8192000000 10968901392 11421945856 1968431312 19.373 100 24 48 1 2042616608 64661856 9523440
23:59:07 15291 8192000000 10971246736 11425779712 1976461552 19.437 100 33 66 0 2053445904 65125360 11858992
23:59:30 12632 8192000000 10966767488 11431739392 1977825360 19.447 100 27 54 0 2050745504 63005600 9914544
23:59:49 28789 8192000000 10944634080 11411136512 1975057456 19.426 100 17 34 1 2037026112 55489216 6479440
00:00:25 36301 8192000000 10919790976 11385090048 1961758336 19.320 99 13 26 2 1980036608 14287504 3990768
00:01:09 128948 8192000000 10913519616 11382853632 1982668928 19.486 100 13 26 1 2004088928 17268976 4151024
00:03:30 60664 8192000000 10909145072 11378733056 1971476512 19.397 99 37 74 1 1994595008 12433776 10684720
00:04:56 30919 8192000000 10937872528 11388547072 1997211216 19.601 100 65 128 1 2028253376 12076864 18965296
00:05:58 78676 8192000000 10921010768 11392450560 1993787920 19.574 100 16 34 0 2014583840 15525200 5270720
00:07:23 43344 8192000000 10909895536 11390443520 1972296720 19.404 99 18 37 1 1993105024 15875856 4932448
00:08:13 47159 8192000000 10905717280 11373547520 1959856736 19.305 99 16 32 2 1977376416 13270544 4249136
00:09:12 69248 8192000000 10928049456 11390214144 1985367744 19.507 100 20 40 0 2005154096 13688880 6097472
00:10:32 83881 8192000000 10927121856 11397328896 1993996048 19.575 100 20 40 0 2012622944 13546896 5080000
00:12:05 48924 8192000000 10914227712 11385458688 1942487280 19.167 97 21 42 0 1962669760 14216720 5965760
00:13:01 63919 8192000000 10922051312 11403702272 1984484720 19.500 100 15 30 1 2007622512 18605184 4532608
00:14:11 74533 8192000000 10901992288 11371737088 1933571184 19.095 97 18 36 0 1958236960 19528864 5136912
00:15:35 102113 8192000000 10915598464 11375652864 1956174544 19.276 99 19 38 0 1978947760 16877152 5896064
00:17:39 103735 8192000000 10901139232 11387645952 1896494976 18.798 95 18 36 1 1916618432 14839856 5283600
00:20:16 52521 8192000000 10874617168 11358093312 1946800496 19.201 99 9 18 0 1958623520 9492336 2330688
00:21:53 20995 8192000000 10877936528 11343355904 1939872272 19.146 99 35 70 1 1959369472 9273312 10223888
00:22:21 51318 8192000000 10877974416 11353944064 1940941952 19.154 99 15 29 4 1956399824 11075168 4382704
00:23:29 47566 8192000000 10911824528 11364061184 1933744288 19.097 98 43 86 1 1956233872 10276048 12213536
00:24:26 43007 8192000000 10884800288 11365851136 1945737568 19.193 99 27 54 0 1969719040 15922480 8058992
00:25:20 54254 8192000000 10877432608 11370962944 1956855392 19.281 100 10 20 2 1979245072 19227360 3162320
00:26:21 26178 8192000000 10877997920 11368075264 1960853120 19.313 100 5 10 0 1977061408 15177584 1030704
00:27:22 84912 8192000000 10858767840 11339427840 1848864032 18.413 94 18 36 0 1861220720 7298496 5058192
00:29:20 69944 8192000000 10859771328 11336847360 1915189072 18.948 98 12 24 0 1926682064 8872928 2620064
00:30:36 54416 8192000000 10856609728 11329122304 1845187232 18.383 94 15 30 2 1857788416 8316320 4284864
00:31:37 51707 8192000000 10865672176 11342995456 1902557904 18.847 98 16 32 2 1918449840 11476320 4415616
00:32:36 47546 8192000000 10840169312 11331211264 1864448688 18.539 96 12 24 0 1879590704 12299504 2842512
00:33:33 39216 8192000000 10867954080 11328684032 1888972400 18.737 97 34 68 0 1907057168 8706688 9378080
00:34:25 32717 8192000000 10854908400 11331002368 1921465968 18.999 99 29 56 1 1939622688 10446448 7710272
00:35:04 53439 8192000000 10892073872 11352784896 1914144096 18.940 98 24 48 2 1929339008 8517744 6677168
00:36:04 37624 8192000000 10864107744 11334361088 1929180832 19.060 99 31 62 2 1948184576 10347392 8656352
00:37:17 129513 8192000000 10883198672 11337334784 1888575632 18.734 97 13 26 0 1905786688 13603440 3607616
00:40:18 52766 8192000000 10820177136 11295723520 1824140480 18.212 94 16 32 0 1841425536 12864352 4420704
00:41:17 49188 8192000000 10851947776 11303022592 1829819888 18.258 95 25 50 3 1845119600 8009936 7289776
00:42:12 30619 8192000000 10842853728 11295862784 1869472032 18.580 98 28 56 1 1888282480 10966928 7843520
00:42:51 62106 8192000000 10863596016 11319795712 1922241568 19.005 100 36 68 3 1943472048 11012800 10217680
00:43:59 52139 8192000000 10864859696 11327799296 1894526704 18.782 98 26 52 2 1915433408 13847952 7058752
00:44:59 49585 8192000000 10863580272 11331235840 1899488176 18.822 98 27 54 0 1920506080 13575568 7442336
00:45:55 107163 8192000000 10869759248 11328638976 1915701312 18.952 99 23 46 2 1934849392 11844688 7303392
00:48:06 76153 8192000000 10875891280 11340480512 1937605776 19.128 100 36 72 3 1958233440 10692752 9934912
00:49:29 83381 8192000000 10874680816 11345235968 1946593936 19.199 100 27 54 0 1965174208 11588608 6991664
00:50:59 20190 8192000000 10877905952 11344551936 1931022176 19.075 99 30 59 2 1950487536 10624416 8840944
00:51:28 32872 8192000000 10879381216 11351506944 1949149168 19.220 100 16 32 0 1963763840 9874112 4740560
00:52:13 92640 8192000000 10888962672 11363594240 1958262352 19.292 100 16 32 0 1974537776 11601680 4673744
00:53:52 94050 8192000000 10888267024 11366322176 1930891008 19.074 98 17 34 1 1949399904 13430784 5078112
00:55:35 58974 8192000000 10889645440 11373395968 1964996160 19.346 100 16 32 0 1988220640 18437680 4786800
00:56:40 54321 8192000000 10886575936 11379138560 1965602928 19.351 100 18 36 0 1990046496 19320160 5123408
00:57:55 59939 8192000000 10893411456 11379994624 1939405984 19.142 98 16 33 1 1956576432 12426336 4744112
00:59:06 104845 8192000000 10878591024 11364098048 1893806560 18.776 96 8 16 1 1905935472 10386224 1742688
01:01:01 52265 8192000000 10894599280 11380146176 1975775120 19.431 100 26 52 1 1990926704 8132192 7019392
01:02:01 41883 8192000000 10915849584 11378970624 1930935248 19.074 97 36 72 2 1952977936 11251552 10791136
01:02:50 69389 8192000000 10895292272 11368120320 1915316672 18.949 97 32 60 0 1936328720 13004960 8007088
01:04:12 25234 8192000000 10908373936 11374432256 1955088752 19.267 99 28 56 2 1971980640 9095136 7796752
01:04:47 34123 8192000000 10905386048 11385282560 1958079632 19.291 99 30 60 1 1978602480 12019280 8503568
01:05:28 67603 8192000000 10895261392 11374698496 1920238336 18.989 97 20 40 1 1939947264 14253152 5455776
01:06:54 53200 8192000000 10908601072 11376803840 1938714592 19.136 98 29 58 1 1959229328 12132080 8382656
01:08:38 111133 8192000000 10904879072 11373805568 1870707984 18.590 95 12 24 0 1890405008 16135216 3561808
01:10:35 69864 8192000000 10889520016 11363311616 1891041856 18.754 96 10 20 0 1908430384 14359088 3029440
01:11:53 126498 8192000000 10849835456 11313201152 1799410224 18.009 92 16 31 1 1822953824 18659328 4884272
01:14:39 93770 8192000000 10871056592 11344666624 1919719536 18.985 99 17 34 1 1933413824 9089120 4605168
01:16:19 35786 8192000000 10867477744 11335192576 1923070960 19.011 99 27 54 0 1945305264 15070128 7164176
01:17:01 50690 8192000000 10860086176 11325210624 1894868256 18.785 98 23 46 3 1911006992 9899536 6239200
01:18:20 73748 8192000000 10854511600 11332755456 1898999776 18.818 98 10 20 1 1910460720 8748512 2712432
01:19:41 54426 8192000000 10845469648 11332870144 1898741808 18.816 98 10 20 1 1914663264 12632880 3288576
01:20:44 38537 8192000000 10848943200 11331944448 1913326592 18.933 99 15 31 1 1929568880 11914400 4327888
01:22:44 78289 8192000000 10852616992 11333304320 1903392608 18.854 98 13 26 1 1919123088 11637776 4092704
01:24:16 39417 8192000000 10837252512 11311075328 1912764560 18.929 99 17 34 1 1931823072 14037216 5021296
01:25:15 58148 8192000000 10806921168 11301179392 1850712752 18.428 96 9 18 0 1866010208 12568160 2729296
01:26:30 54528 8192000000 9773887568 10129068032 879182768 9.692 46 9 18 0 889429920 7689232 2557920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 04-02-2021 01:29:16 to 04-02-2021 01:29:48.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 160 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

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

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          242348
MON$OLDEST_ACTIVE               243402
MON$OLDEST_SNAPSHOT             243402
MON$NEXT_TRANSACTION            243402
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                       2091264
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:149: 
:150: mscs-test-161.budzdorov.ru    Thu Feb  4 01:27:34 2021
:151:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:152: 
:153: 
:154: mscs-test-161.budzdorov.ru    Thu Feb  4 01:27:35 2021
:155:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:156: 
:157: 
:158: mscs-test-161.budzdorov.ru    Thu Feb  4 01:27:36 2021
:159:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:160: 
--- end of diff output ---

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

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