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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17337596 kB
MemAvailable 31262436 kB
Buffers 0 kB
Cached 14334892 kB
SwapCached 4868 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-25 19:27:15
DTS_END                         2021-01-25 19:27:15.5380
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/53562
TRN_ID                          232181
ATT_ID                          666
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: 9214.52 20249 1105742
customer order: creation 167.63 356 20116
customer order: refuse 14.80 356 1776
order to supplier: creation 45.11 1253 5413
order to supplier: removal 3.50 101660 420
invoice (draft): creation 45.58 2993 5469
invoice (draft): removal 53.68 787 6441
invoice accept: apply 41.80 17142 5016
invoice accept: cancel 47.97 743 5756
customer reserve: creation 3818.33 172 458200
customer reserve: removal 4687.70 60 562524
realization accept: apply 81.53 190 9783
realization accept: cancel 80.31 99 9637
payment from customer: creation 57.74 123 6929
payment from customer: removal 5.68 80 681
payment to supplier: creation 48.11 135 5773
payment to supplier: removal 3.29 75 395
service: total inventory turnovers 4.34 1319 521
service: total monetary turnovers 6.58 30 790
service: aggregate perf. data 0.82 25745 98
service: refresh index statistics 0.03 251660 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-01-2021 19:28:23 to 25-01-2021 19:28:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10647
TEST_TIME 2 8781
TEST_TIME 3 7224
TEST_TIME 4 6658
TEST_TIME 5 6304
TEST_TIME 6 6109
TEST_TIME 7 6222
TEST_TIME 8 6006
TEST_TIME 9 6586
TEST_TIME 10 6507
TEST_TIME 11 6182
TEST_TIME 12 6321
TEST_TIME 13 6365
TEST_TIME 14 6675
TEST_TIME 15 6918
TEST_TIME 16 7291
TEST_TIME 17 7174
TEST_TIME 18 7757
TEST_TIME 19 7680
TEST_TIME 20 8493
TEST_TIME 21 8665
TEST_TIME 22 8631
TEST_TIME 23 9059
TEST_TIME 24 9192
TEST_TIME 25 9208
TEST_TIME 26 9210
TEST_TIME 27 10451
TEST_TIME 28 10577
TEST_TIME 29 10360
TEST_TIME 30 10219
TEST_TIME 31 10178
TEST_TIME 32 10227
TEST_TIME 33 10116
TEST_TIME 34 10128
TEST_TIME 35 10004
TEST_TIME 36 9897
TEST_TIME 37 9807
TEST_TIME 38 9653
TEST_TIME 39 9736
TEST_TIME 40 9925
TEST_TIME 41 9870
TEST_TIME 42 9715
TEST_TIME 43 9525
TEST_TIME 44 9642
TEST_TIME 45 9586
TEST_TIME 46 9480
TEST_TIME 47 9383
TEST_TIME 48 9329
TEST_TIME 49 9237
TEST_TIME 50 9299
TEST_TIME 51 9247
TEST_TIME 52 9393
TEST_TIME 53 9447
TEST_TIME 54 9420
TEST_TIME 55 9374
TEST_TIME 56 9487
TEST_TIME 57 9615
TEST_TIME 58 9682
TEST_TIME 59 9760
TEST_TIME 60 9788
TEST_TIME 61 9774
TEST_TIME 62 9634
TEST_TIME 63 9578
TEST_TIME 64 9503
TEST_TIME 65 9477
TEST_TIME 66 9463
TEST_TIME 67 9387
TEST_TIME 68 9340
TEST_TIME 69 9364
TEST_TIME 70 9331
TEST_TIME 71 9311
TEST_TIME 72 9295
TEST_TIME 73 9287
TEST_TIME 74 9348
TEST_TIME 75 9324
TEST_TIME 76 9392
TEST_TIME 77 9421
TEST_TIME 78 9397
TEST_TIME 79 9407
TEST_TIME 80 9420
TEST_TIME 81 9470
TEST_TIME 82 9500
TEST_TIME 83 9462
TEST_TIME 84 9401
TEST_TIME 85 9388
TEST_TIME 86 9317
TEST_TIME 87 9337
TEST_TIME 88 9289
TEST_TIME 89 9241
TEST_TIME 90 9179
TEST_TIME 91 9258
TEST_TIME 92 9244
TEST_TIME 93 9240
TEST_TIME 94 9245
TEST_TIME 95 9218
TEST_TIME 96 9300
TEST_TIME 97 9286
TEST_TIME 98 9291
TEST_TIME 99 9293
TEST_TIME 100 9358
TEST_TIME 101 9352
TEST_TIME 102 9403
TEST_TIME 103 9402
TEST_TIME 104 9417
TEST_TIME 105 9428
TEST_TIME 106 9440
TEST_TIME 107 9358
TEST_TIME 108 9341
TEST_TIME 109 9287
TEST_TIME 110 9269
TEST_TIME 111 9284
TEST_TIME 112 9305
TEST_TIME 113 9294
TEST_TIME 114 9270
TEST_TIME 115 9202
TEST_TIME 116 9286
TEST_TIME 117 9286
TEST_TIME 118 9300
TEST_TIME 119 9277
TEST_TIME 120 9217

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-01-2021 19:28:27 to 25-01-2021 19:28:30.

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 1529778 1529778 0 0.00 0 16245 6 0 0
doc_list_biud 1529773 1529773 0 0.00 0 48911 28 0 0
sp_add_invoice_to_stock 5114 5016 98 1.91 37 144992 17143 0 98
sp_cancel_adding_invoice 5756 5756 0 0.00 5 64709 744 0 0
sp_cancel_client_order 1776 1776 0 0.00 4 11518 357 0 0
sp_cancel_customer_reserve 562524 562524 0 0.00 1 28494 60 0 0
sp_cancel_pay_from_customer 681 681 0 0.00 2 4627 81 0 0
sp_cancel_pay_to_supplier 395 395 0 0.00 2 4111 76 0 0
sp_cancel_supplier_invoice 6448 6441 7 0.10 2 48916 787 0 7
sp_cancel_supplier_order 420 420 0 0.00 9 993525 101661 0 0
sp_cancel_write_off 9637 9637 0 0.00 1 12415 100 0 0
sp_client_order 20116 20116 0 0.00 3 40638 357 0 0
sp_customer_reserve 458200 458200 0 0.00 0 104468 172 0 0
sp_fill_shopping_cart 30990 30990 0 0.00 1 11357 37 0 0
sp_fill_shopping_cart_clo_res 458191 458191 0 0.00 0 16911 14 0 0
sp_get_clo_for_invoice 5007 5007 0 0.00 0 27368 322 0 0
sp_kill_cost_storno 16469 16469 0 0.00 0 8598 54 0 0
sp_kill_qstorno_ret_qs2qd 1141546 1141546 0 0.00 0 48909 33 0 0
sp_kill_qty_storno 601340 601340 0 0.00 0 48910 70 0 0
sp_lock_selected_doc 20596 20596 0 0.00 0 8198 7 0 0
sp_make_cost_storno 27492 27492 0 0.00 0 16181 56 0 0
sp_multiply_rows_for_pdistr 27492 27492 0 0.00 0 7740 29 0 0
sp_multiply_rows_for_qdistr 20116 20116 0 0.00 0 33931 167 0 0
sp_pay_from_customer 6929 6929 0 0.00 4 19043 124 0 0
sp_pay_to_supplier 5773 5773 0 0.00 4 13409 135 0 0
sp_payment_common 12701 12701 0 0.00 1 19034 36 0 0
sp_qd_handle_on_cancel_clo 1776 1776 0 0.00 0 11511 321 0 0
sp_qd_handle_on_invoice_upd_sts 10760 10760 0 0.00 0 15712 305 0 0
sp_qd_handle_on_reserve_upd_sts 9782 9782 0 0.00 0 21148 63 0 0
sp_reserve_write_off 9783 9783 0 0.00 6 22450 190 0 0
sp_supplier_invoice 5469 5469 0 0.00 7 84558 2994 0 0
sp_supplier_order 5413 5413 0 0.00 5 46117 1254 0 0
srv_aggregate_perf_data 98 98 0 0.00 2801 564020 25745 0 0
srv_fill_mon_cache_memory 147 147 0 0.00 1038 133888 34462 0 0
srv_find_qd_qs_mism 1058673 1058673 0 0.00 0 8740 5 0 0
srv_make_invnt_saldo 521 521 0 0.00 40 96050 1319 0 0
srv_make_money_saldo 790 790 0 0.00 1 8263 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 92207 362412 251660 0 0
t$perf-abend:sp_add_invoice_to_stock 98 98 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5016 5016 0 0.00 0 9090 163 0 0
t$perf-norm:sp_cancel_adding_invoice 391 391 0 0.00 0 4234 80 0 0
t$perf-norm:sp_cancel_client_order 1776 1776 0 0.00 0 3191 16 0 0
t$perf-norm:sp_cancel_customer_reserve 693 693 0 0.00 0 5119 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 681 681 0 0.00 0 3065 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 395 395 0 0.00 0 750 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 436 436 0 0.00 0 700 11 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 30198 1634 0 0
t$perf-norm:sp_cancel_write_off 1022 1022 0 0.00 0 4201 14 0 0
t$perf-norm:sp_client_order 20116 20116 0 0.00 0 8511 17 0 0
t$perf-norm:sp_customer_reserve 997 997 0 0.00 0 1165 5 0 0
t$perf-norm:sp_pay_from_customer 6929 6929 0 0.00 0 5395 14 0 0
t$perf-norm:sp_pay_to_supplier 5773 5773 0 0.00 0 8511 12 0 0
t$perf-norm:sp_reserve_write_off 9783 9783 0 0.00 0 5321 12 0 0
t$perf-norm:sp_supplier_invoice 5469 5469 0 0.00 0 5723 18 0 0
t$perf-norm:sp_supplier_order 5413 5413 0 0.00 0 5306 15 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 24 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 147 147 0 0.00 0 909 12 0 0
t$perf-norm:srv_make_invnt_saldo 521 521 0 0.00 0 6173 36 0 0
t$perf-norm:srv_make_money_saldo 790 790 0 0.00 0 2423 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 16 6 0 0
v_add_invoice_to_stock 10196 10000 196 1.92 0 4929 19 0 196
v_all_customers 36718 36718 0 0.00 0 37 1 0 0
v_all_suppliers 30126 30126 0 0.00 0 21 1 0 0
v_all_wares 40230 40230 0 0.00 0 12 1 0 0
v_cancel_adding_invoice 782 782 0 0.00 0 2874 18 0 0
v_cancel_client_order 3552 3552 0 0.00 0 2296 5 0 0
v_cancel_customer_prepayment 1362 1362 0 0.00 0 2642 9 0 0
v_cancel_customer_reserve 1386 1386 0 0.00 0 1391 5 0 0
v_cancel_payment_to_supplier 790 790 0 0.00 0 1084 6 0 0
v_cancel_supplier_invoice 886 872 14 1.58 0 1002 14 0 14
v_cancel_supplier_order 840 840 0 0.00 0 1482 6 0 0
v_cancel_write_off 2044 2044 0 0.00 0 3434 17 0 0
v_max_id_clo_ord 5410 5410 0 0.00 0 1022 1 0 0
v_max_id_clo_res 997 997 0 0.00 0 2198 12 0 0
v_max_id_ord_sup 5465 5465 0 0.00 0 4403 5 0 0
v_max_non_paid_invoice 1585 1585 0 0.00 0 2031 3 0 0
v_max_non_paid_realizn 3657 3657 0 0.00 0 5003 9 0 0
v_min_id_clo_ord 5410 5410 0 0.00 0 1624 6 0 0
v_min_id_clo_res 997 997 0 0.00 0 1728 7 0 0
v_min_id_ord_sup 5465 5465 0 0.00 0 6500 9 0 0
v_min_non_paid_invoice 5773 5773 0 0.00 0 7433 17 0 0
v_min_non_paid_realizn 6928 6928 0 0.00 0 19029 24 0 0
v_our_firm 10054 10054 0 0.00 0 21 1 0 0
v_reserve_write_off 19564 19564 0 0.00 0 3579 6 0 0
x_lock_depdocs_on_canc_invoice 11761 11761 0 0.00 0 15222 105 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 8547 361 0 0
x_make_qstorno_1000_1200 5413 5413 0 0.00 2 46110 1175 0 0
x_make_qstorno_1200_2000 5469 5469 0 0.00 4 84126 2863 0 0
x_make_qstorno_2100_3300 458200 458200 0 0.00 0 104466 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-01-2021 19:28:31 to 25-01-2021 19:28:35.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:19 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:25 25149 8192000000 10282966160 10597289984 1091205696 11.754 83 69 139 0 1116433984 3283248 21945040
16:58:04 24084 8192000000 10346692944 10667667456 1402722224 14.619 100 84 168 0 1435934176 5916656 27295296
16:58:41 21968 8192000000 10396255200 10720583680 1447359024 15.015 100 90 180 0 1483663552 6796640 29507888
16:59:11 12795 8192000000 10412732784 10735857664 1463968016 15.161 100 92 184 1 1501377680 7398352 30011312
16:59:42 24856 8192000000 10423852688 10755362816 1481601472 15.315 100 88 176 2 1517688800 7924144 28163184
17:00:17 21715 8192000000 10448745296 10780856320 1500361328 15.479 100 89 178 0 1537831056 8555088 28914640
17:00:49 21431 8192000000 10464817856 10803802112 1515064912 15.607 100 90 180 1 1552867600 9331152 28471536
17:01:22 9864 8192000000 10482002912 10823548928 1539245824 15.817 100 89 178 0 1576124656 9484272 27394560
17:01:47 13327 8192000000 10494636640 10843791360 1549509392 15.906 100 72 144 2 1581713968 9585424 22619152
17:02:10 16574 8192000000 10524473424 10880368640 1589968464 16.254 100 78 156 3 1624335200 10121504 24245232
17:02:41 13282 8192000000 10558595424 10917097472 1611883056 16.441 100 81 160 0 1646133440 9755216 24495168
17:03:05 10245 8192000000 10581478928 10942980096 1642376000 16.700 100 82 164 1 1677789632 10987888 24425744
17:03:24 10013 8192000000 10595285968 10958503936 1651861200 16.780 100 76 150 4 1685479664 11107296 22511168
17:03:44 7650 8192000000 10595147360 10966372352 1670413872 16.937 100 77 155 1 1704546048 11743760 22388416
17:04:00 9564 8192000000 10641510048 11008282624 1688968208 17.093 100 76 151 0 1721976080 11745616 21262256
17:04:16 9850 8192000000 10651144592 11024379904 1710423264 17.272 100 84 166 1 1751088320 17157712 23507344
17:04:34 7083 8192000000 10661008992 11032023040 1722564176 17.374 100 80 159 1 1758248752 13340304 22344272
17:04:49 8514 8192000000 10672821216 11048288256 1732943088 17.460 100 82 164 0 1770361664 14279152 23139424
17:05:05 5578 8192000000 10680875440 11054612480 1740349488 17.522 100 90 180 1 1780902256 15323216 25229552
17:05:19 4510 8192000000 10686304160 11060150272 1745378592 17.563 100 85 169 0 1784456736 15037888 24040256
17:05:30 4798 8192000000 10700121392 11078508544 1757931296 17.667 100 88 176 1 1798022992 14955312 25136384
17:05:43 4429 8192000000 10710163264 11090952192 1769233696 17.761 100 81 162 1 1806106752 13255104 23617952
17:05:54 4436 8192000000 10719609680 11096248320 1778763040 17.839 100 83 165 1 1814029312 12742528 22523744
17:06:05 3543 8192000000 10721850928 11103412224 1784480000 17.886 100 83 163 2 1819965616 12387104 23098512
17:06:15 5093 8192000000 10723607824 11103846400 1788250448 17.917 100 82 164 1 1823699200 12759600 22689152
17:06:28 4119 8192000000 10731894848 11117535232 1796495792 17.985 100 82 162 1 1832025360 12885904 22643664
17:06:42 7735 8192000000 10744751168 11129438208 1795546960 17.977 100 72 144 0 1827800384 11791808 20461616
17:06:56 2244 8192000000 10756819344 11138875392 1811407040 18.107 100 85 170 0 1848234768 12364848 24462880
17:07:05 3694 8192000000 10764568464 11149357056 1824222352 18.212 100 86 169 1 1860511920 12215776 24073792
17:07:16 2559 8192000000 10772261392 11156041728 1825558960 18.223 100 86 172 3 1862602144 12657984 24385200
17:07:25 2185 8192000000 10775986064 11159068672 1830427984 18.263 100 92 184 2 1869733760 13740112 25565664
17:07:33 2811 8192000000 10779850768 11163262976 1834486432 18.296 100 93 184 0 1875097856 14041392 26570032
17:07:44 2324 8192000000 10784639008 11169734656 1837557696 18.321 100 90 180 1 1875812576 13544464 24710416
17:07:53 2420 8192000000 10783840000 11173036032 1840390960 18.344 100 86 172 0 1877703600 13186016 24126624
17:08:01 3624 8192000000 10785238704 11174776832 1847872976 18.405 100 90 180 1 1885516704 12854544 24789184
17:08:12 2696 8192000000 10792295904 11179225088 1849547216 18.418 100 92 185 0 1890036320 14953152 25535952
17:08:21 1571 8192000000 10791180256 11180089344 1848072304 18.406 100 93 187 0 1889869008 15280720 26515984
17:08:30 3042 8192000000 10794605264 11184754688 1849346832 18.417 100 87 174 0 1890969504 16163104 25459568
17:08:39 1836 8192000000 10801406960 11190284288 1855057536 18.463 100 89 177 2 1896248032 14977040 26213456
17:08:47 1498 8192000000 10799165888 11186155520 1855970160 18.471 100 90 178 0 1893881824 12251744 25659920
17:08:56 3198 8192000000 10803444464 11191332864 1861629488 18.516 100 88 176 1 1898482016 11778320 25074208
17:09:06 1320 8192000000 10812548240 11198701568 1862626464 18.525 100 97 194 4 1902288656 12598560 27063632
17:09:14 2502 8192000000 10805889376 11196555264 1862592208 18.524 100 92 183 2 1901952080 13894400 25465472
17:09:23 2381 8192000000 10817067200 11204141056 1866801696 18.558 100 93 185 0 1907689152 15062480 25824976
17:09:31 2217 8192000000 10808619968 11198078976 1862283728 18.522 100 79 154 3 1897112256 13232000 21596528
17:09:40 2659 8192000000 10816809104 11209543680 1872266496 18.603 100 84 169 1 1909072016 11878816 24926704
17:09:50 14694 8192000000 10812756800 11204083712 1869427008 18.580 100 81 160 1 1904437024 13048144 21961872
17:10:12 1457 8192000000 10825264528 11211104256 1873038176 18.609 100 90 180 3 1913057104 14253616 25765312
17:10:19 2447 8192000000 10824148832 11214827520 1877830448 18.648 100 93 186 1 1918989248 14403472 26755328
17:10:28 2297 8192000000 10801581728 11203231744 1872103024 18.601 100 71 142 1 1904726720 13567184 19056512
17:10:37 1815 8192000000 10801735600 11206385664 1875949056 18.632 100 70 141 0 1907830640 11600608 20280976
17:10:45 2365 8192000000 10815772544 11208462336 1879416976 18.660 100 86 174 1 1914073088 10927968 23728144
17:10:55 20242 8192000000 10815348560 11218485248 1874980240 18.625 100 53 106 1 1898949920 8495200 15474480
17:11:22 2871 8192000000 10819642992 11226324992 1884097312 18.698 100 72 143 2 1915189616 11081456 20010848
17:11:31 3291 8192000000 10794817600 11217580032 1877612400 18.646 100 37 75 0 1897119280 9306800 10200080
17:11:44 1627 8192000000 10809224448 11217780736 1881194528 18.675 100 44 91 1 1898908208 5092448 12621232
17:11:52 3714 8192000000 10809989728 11221434368 1881990032 18.681 100 31 58 1 1896455632 6304432 8161168
17:12:04 3319 8192000000 10809377856 11226845184 1890432832 18.749 100 34 67 2 1907902416 7218800 10250784
17:12:15 4190 8192000000 10796555984 11227799552 1889919648 18.745 100 22 44 0 1903646192 7157840 6568704
17:12:27 8937 8192000000 10806249472 11232673792 1892326640 18.765 100 22 44 0 1905558512 6609392 6622480
17:12:44 5797 8192000000 10832530528 11245608960 1902819648 18.849 100 48 96 0 1927761360 11320704 13621008
17:12:56 3949 8192000000 10827511456 11241975808 1906752656 18.881 100 59 117 2 1929871872 5531024 17588192
17:13:06 49275 8192000000 10823942256 11240812544 1901840640 18.841 100 44 89 3 1920436704 5023968 13572096
17:14:02 4044 8192000000 10821392560 11250229248 1905739648 18.872 100 54 108 0 1930737824 9284560 15713616
17:14:17 3682 8192000000 10825394128 11247304704 1900750128 18.832 100 28 56 0 1915950992 6051536 9149328
17:14:27 3814 8192000000 10814030928 11246297088 1904158944 18.860 100 33 62 0 1920341744 6744224 9438576
17:14:39 7254 8192000000 10818265184 11246972928 1905483664 18.870 100 28 53 1 1919196672 6566576 7146432
17:14:54 6116 8192000000 10818048384 11253485568 1911684576 18.920 100 42 84 1 1933994112 10866720 11442816
17:15:10 3262 8192000000 10831257360 11254595584 1912669056 18.928 100 34 66 2 1929664336 6807648 10187632
17:15:21 2544 8192000000 10841827424 11263324160 1918905136 18.978 100 53 106 2 1941435664 7274656 15255872
17:15:30 4635 8192000000 10833259472 11260788736 1916332560 18.957 100 26 50 2 1929605872 5608048 7665264
17:15:41 11144 8192000000 10829773168 11262304256 1916333776 18.957 100 21 40 1 1926980768 5062592 5584400
17:15:59 7299 8192000000 10833203776 11264364544 1918078800 18.971 100 20 41 1 1929563056 4968416 6515840
17:16:14 8291 8192000000 10819561712 11259572224 1917153552 18.964 100 29 58 5 1932935808 7139520 8642736
17:16:29 20189 8192000000 10803633728 11234308096 1879202192 18.659 98 33 66 3 1893345904 4542400 9601312
17:16:57 61904 8192000000 10793234560 11213008896 1811889056 18.111 95 31 62 0 1826251648 4913536 9449056
17:18:05 7732 8192000000 10778547536 11204780032 1848290896 18.408 98 26 53 1 1862215504 6445264 7479344
17:18:19 4324 8192000000 10796846112 11215233024 1843741856 18.371 98 47 93 2 1865318528 8333984 13242688
17:18:32 1776 8192000000 10805138848 11207569408 1855035968 18.463 99 53 106 2 1877069648 5699056 16334624
17:18:41 5601 8192000000 10800544016 11221839872 1877482256 18.645 100 37 75 2 1895577904 8022096 10073552
17:18:53 5996 8192000000 10800422960 11216678912 1827730000 18.241 97 38 76 0 1844264384 6471760 10062624
17:19:06 3769 8192000000 10790986736 11206914048 1853531696 18.451 99 40 80 1 1873100448 8818416 10750336
17:19:18 5539 8192000000 10745360320 11167150080 1779338032 17.844 96 27 54 2 1793089168 6436176 7314960
17:19:32 4574 8192000000 10769369552 11187892224 1831404384 18.271 99 36 71 1 1848160912 6923568 9832960
17:19:43 6066 8192000000 10751659984 11176034304 1817001664 18.153 98 28 56 3 1831274096 6592512 7679920
17:20:01 8750 8192000000 10753418064 11176972288 1811898080 18.111 98 23 45 1 1823965280 5584672 6482528
17:20:16 8441 8192000000 10712880624 11118350336 1725969824 17.402 96 28 56 1 1740118144 5863248 8285072
17:20:33 6414 8192000000 10715654096 11137257472 1782728800 17.872 98 27 53 1 1795994224 4909104 8356320
17:20:45 15101 8192000000 10721315264 11123458048 1731996288 17.452 95 42 84 1 1750198320 5099488 13102544
17:21:19 38730 8192000000 10694574144 11107053568 1704491600 17.223 94 39 78 2 1722562208 6157696 11912912
17:22:07 11749 8192000000 10691557264 11096801280 1668411936 16.920 93 19 38 0 1679082512 5438608 5231968
17:22:30 5635 8192000000 10714827520 11127345152 1775993280 17.816 99 32 65 0 1792470992 7594048 8883664
17:22:42 3832 8192000000 10737627856 11143028736 1808780944 18.086 100 54 108 1 1830020736 7010160 14229632
17:22:55 9590 8192000000 10727354192 11142209536 1791802976 17.947 99 22 44 1 1803044192 5593520 5647696
17:23:12 5053 8192000000 10732223952 11139600384 1794479776 17.969 99 43 86 1 1813232832 6481088 12271968
17:23:27 6941 8192000000 10728435184 11147616256 1804401088 18.050 99 45 91 2 1823536416 5692192 13443136
17:23:42 9792 8192000000 10724057440 11150184448 1799980672 18.014 99 26 49 3 1812943280 5132160 7830448
17:24:00 4814 8192000000 10759655664 11168788480 1827802208 18.241 100 26 52 2 1840467088 5214816 7450064
17:24:12 6169 8192000000 10752914640 11177631744 1839694656 18.338 100 31 62 2 1856041232 8058624 8287952
17:24:25 7280 8192000000 10775554960 11184398336 1843229408 18.367 100 36 71 2 1858290304 5122256 9938640
17:24:45 8252 8192000000 10764324192 11185319936 1849833424 18.421 100 30 60 1 1864909584 5819616 9256544
17:25:05 6403 8192000000 10755912320 11185651712 1844679520 18.379 100 23 46 1 1861156080 9876848 6599712
17:25:18 10422 8192000000 10748082064 11176873984 1839622544 18.338 100 25 46 1 1852512848 5208992 7681312
17:25:36 15562 8192000000 10765395872 11184955392 1846815200 18.396 100 26 52 0 1860441104 5913984 7711920
17:26:00 60388 8192000000 10756309488 11187396608 1848405792 18.409 100 19 38 1 1859220384 5298464 5516128
17:27:06 16788 8192000000 10804736672 11215794176 1876552864 18.637 100 47 90 0 1895143616 5918064 12672688
17:27:35 3905 8192000000 10825258672 11229380608 1885329168 18.708 100 59 118 1 1910838688 8466496 17043024
17:27:48 19016 8192000000 10832951168 11242868736 1897742864 18.808 100 70 138 3 1927745600 10663792 19338944
17:28:14 5173 8192000000 10845031600 11252957184 1901528704 18.839 100 70 139 1 1932886704 11295296 20062704
17:28:30 2479 8192000000 10848887392 11258142720 1908211504 18.892 100 67 132 2 1939014480 11558944 19244032
17:28:40 4773 8192000000 10852866896 11259834368 1910797536 18.913 100 75 149 2 1944278624 11638800 21842288
17:28:51 4402 8192000000 10847905200 11261841408 1908698272 18.896 100 57 113 0 1935399328 11003280 15697776
17:29:13 15731 8192000000 10831950464 11262722048 1914032800 18.939 100 42 84 1 1934259296 8409008 11817488
17:29:36 22260 8192000000 10849521760 11274190848 1919529120 18.983 100 42 84 2 1940249920 9087712 11633088
17:30:08 10968 8192000000 10857406368 11278082048 1932028160 19.083 100 58 116 2 1957991120 9850640 16112320
17:30:28 5655 8192000000 10869323632 11288469504 1934159968 19.100 100 51 101 2 1958796400 10016464 14619968
17:30:42 22905 8192000000 10887893424 11304316928 1941374224 19.158 100 59 118 1 1969312144 10978080 16959840
17:31:48 35962 8192000000 10877380352 11309219840 1947264080 19.205 100 44 86 1 1976466352 15965840 13236432
17:32:33 20829 8192000000 10873436304 11311022080 1947265488 19.205 100 33 64 1 1972994992 16209216 9520288
17:33:01 6904 8192000000 10881540896 11314384896 1950667344 19.232 100 36 71 4 1976331088 15341904 10321840
17:33:23 21174 8192000000 10907170352 11329810432 1957438976 19.286 100 49 98 1 1991091840 18546096 15106768
17:33:54 8401 8192000000 10902196096 11334864896 1961420336 19.317 100 50 99 1 1997256000 21159616 14676048
17:34:15 11372 8192000000 10906769344 11340787712 1965512144 19.350 100 43 86 1 1996336800 18751136 12073520
17:34:38 8063 8192000000 10923729680 11349487616 1973760544 19.415 100 53 106 3 2010211088 21094832 15355712
17:34:54 7406 8192000000 10933516896 11356246016 1980175920 19.466 100 68 134 2 2022668912 22257568 20235424
17:35:08 13078 8192000000 10936811936 11357294592 1980538592 19.469 100 63 126 1 2026607760 27878752 18190416
17:35:29 8080 8192000000 10938015824 11365273600 1981615360 19.477 100 60 121 1 2024074240 24777968 17680912
17:36:10 4261 8192000000 10940248144 11372683264 1992673440 19.565 100 61 122 1 2035717280 24148352 18895488
17:36:21 7737 8192000000 10937637696 11371843584 1990400400 19.547 100 50 100 2 2028924048 23167328 15356320
17:36:40 31820 8192000000 10928056672 11368091648 1970075168 19.386 99 45 86 0 2004312944 20871952 13365824
17:37:24 14222 8192000000 10933254080 11375075328 1992077248 19.560 100 41 80 2 2028389920 23022256 13290416
17:37:54 5488 8192000000 10942400912 11383840768 1999173376 19.616 100 46 91 2 2035523392 22675680 13674336
17:38:09 6715 8192000000 10947101936 11382321152 1982433200 19.484 99 49 97 2 2018227312 21220032 14574080
17:38:26 11319 8192000000 10952523664 11385552896 2002759456 19.644 100 55 110 1 2041740928 22413776 16567696
17:38:45 12358 8192000000 10959452704 11388293120 2005220752 19.664 100 58 116 0 2048703344 26182752 17299840
17:39:08 7337 8192000000 10954570176 11394891776 2007192848 19.679 100 49 98 0 2046629936 24147632 15289456
17:39:23 11344 8192000000 10954352560 11390054400 1989190848 19.537 99 54 107 0 2030595968 25167104 16238016
17:39:45 8859 8192000000 10952373584 11392815104 2002877312 19.645 100 50 100 4 2043845968 25147104 15821552
17:40:13 6167 8192000000 10964672976 11400249344 2008798464 19.692 100 60 118 3 2055276240 26691264 19786512
17:40:33 8814 8192000000 10952593552 11389444096 1998793616 19.613 100 57 115 2 2046292944 28879760 18619568
17:40:50 3064 8192000000 10959381952 11389100032 1996762560 19.597 100 60 120 2 2044009440 28073856 19173024
17:41:01 3542 8192000000 10962171136 11388133376 1997175648 19.600 100 71 139 1 2046905344 28719056 21010640
17:41:11 1650 8192000000 10974282752 11390889984 2004624960 19.659 100 83 163 0 2056552208 27930656 23996592
17:41:20 12168 8192000000 10985264096 11404898304 2013019360 19.725 100 67 134 0 2063230592 30285312 19925920
17:41:39 3187 8192000000 10970616816 11393818624 1994451376 19.579 99 79 158 1 2050933792 32389248 24093168
17:41:49 3116 8192000000 10973069680 11400159232 2006870176 19.677 100 76 152 0 2061700112 30546640 24283296
17:41:59 2894 8192000000 10987966176 11407609856 2012930400 19.725 100 85 170 1 2071052896 31660352 26462144
17:42:09 4172 8192000000 10982077040 11405324288 2008710400 19.691 100 65 128 1 2060465536 32366864 19388272
17:42:20 3308 8192000000 10983202000 11406680064 1994843520 19.582 99 71 142 0 2051133040 33770480 22519040
17:42:31 2520 8192000000 10983271552 11411767296 2013242736 19.727 100 67 134 0 2070054944 35195360 21616848
17:42:41 4370 8192000000 10992848224 11416608768 2019024736 19.772 100 74 147 1 2080286064 36596944 24664384
17:42:52 3733 8192000000 11000517424 11428270080 2023614160 19.809 100 71 141 2 2082284064 37138832 21531072
17:43:07 4194 8192000000 10972282576 11399839744 1989723760 19.542 99 72 141 1 2046098592 34591552 21783280
17:43:25 2073 8192000000 10982960704 11405271040 2008775120 19.692 100 84 164 1 2068322464 34081824 25465520
17:43:35 5179 8192000000 10969160336 11397300224 1995766816 19.589 100 72 144 1 2054053696 35220544 23066336
17:44:04 11132 8192000000 10960075472 11395031040 1973797152 19.416 99 56 112 2 2029704912 37485344 18422416
17:44:26 7262 8192000000 10969376288 11404914688 1999049008 19.615 100 52 104 0 2055549040 38773280 17726752
17:44:46 4482 8192000000 10994826832 11416903680 2009024512 19.694 100 66 131 2 2072948656 42170352 21753792
17:45:04 2518 8192000000 10983072672 11404075008 1996820656 19.598 100 81 160 0 2067686384 44532192 26333536
17:45:14 7373 8192000000 10961247456 11390390272 1976266304 19.435 99 82 164 0 2046142928 43502880 26373744
17:45:29 4202 8192000000 10941319200 11368615936 1962499184 19.326 99 66 130 0 2018586960 35615248 20472528
17:45:42 1772 8192000000 10935851344 11358072832 1952709456 19.248 98 68 136 0 2011079280 37275056 21094768
17:45:51 2708 8192000000 10963446608 11373780992 1968783632 19.376 99 87 171 0 2032512896 37344016 26385248
17:46:02 3395 8192000000 10941064512 11350392832 1947014656 19.203 98 80 160 2 2010513360 38976048 24522656
17:46:13 2073 8192000000 10980818656 11390697472 1988298192 19.530 100 96 192 4 2059478512 40993760 30186560
17:46:23 1035 8192000000 10966716208 11377876992 1974645424 19.422 100 87 172 1 2044739392 42410112 27683856
17:46:31 6840 8192000000 10952567392 11370770432 1953906368 19.258 99 81 162 1 2025314864 45554880 25853616
17:46:57 3323 8192000000 10978960240 11394093056 1982416816 19.484 100 86 172 0 2062509840 52933872 27159152
17:47:08 3176 8192000000 10987453984 11404832768 1987548976 19.524 100 79 158 0 2065716768 52926992 25240800
17:47:19 3134 8192000000 10963660528 11388194816 1972557120 19.406 100 75 151 1 2049407520 52432144 24418256
17:47:34 5725 8192000000 10952282656 11387191296 1960388480 19.309 99 66 132 3 2037319280 55252384 21678416
17:47:51 12009 8192000000 10947352512 11392122880 1978395648 19.452 100 39 77 1 2034138016 42654944 13087424
17:48:13 16071 8192000000 10927666688 11380883456 1950715824 19.232 99 39 78 1 2006476400 41802848 13957728
17:48:38 18113 8192000000 10934506256 11377348608 1947699504 19.208 99 39 78 1 2005513280 45072832 12740944
17:49:06 12073 8192000000 10913143840 11354009600 1929872000 19.066 99 45 90 0 1984269872 39055952 15341920
17:49:55 5408 8192000000 10923072656 11354640384 1917824672 18.969 98 57 114 1 1980965552 45249440 17891440
17:50:12 11473 8192000000 10914716528 11361058816 1930823104 19.073 99 36 72 2 1982442512 39481616 12137792
17:50:44 8202 8192000000 10920051280 11365228544 1951877040 19.241 100 40 80 0 2004436576 39504672 13054864
17:51:12 26470 8192000000 10888181904 11335847936 1893008320 18.770 97 26 51 2 1938124448 36504704 8611424
17:51:56 55325 8192000000 10899150304 11357097984 1918581408 18.975 99 18 36 2 1975564336 50491552 6491376
17:53:00 34338 8192000000 10891688336 11348336640 1919989872 18.987 100 17 34 2 1979106000 52036368 7079760
17:53:44 25735 8192000000 10890924656 11359092736 1909249536 18.901 99 18 36 1 1967365104 51199872 6915696
17:54:17 25504 8192000000 10851367440 11316924416 1857337952 18.482 97 13 26 0 1901215392 39146416 4731024
17:54:48 29219 8192000000 10825669872 11285188608 1846998608 18.398 97 14 28 2 1865753520 14913040 3841872
17:55:26 53163 8192000000 10861137936 11270864896 1864266752 18.538 98 35 68 3 1883012896 8637008 10109136
17:56:28 41552 8192000000 10873761056 11305218048 1899190000 18.820 99 25 48 0 1915719776 9278352 7251424
17:57:18 59809 8192000000 10889671232 11342598144 1952632864 19.247 100 33 66 0 1976127792 14857968 8636960
17:58:31 75498 8192000000 10823913152 11277611008 1802600320 18.035 93 25 50 0 1828106336 18095904 7410112
17:59:54 127170 8192000000 10824925328 11279114240 1811325376 18.107 95 21 41 0 1825062224 7407856 6328992
18:02:08 133888 8192000000 10858446032 11312906240 1874077776 18.617 97 21 42 1 1891620384 11228160 6314448
18:04:30 30452 8192000000 10877862272 11330461696 1948503024 19.215 100 26 53 0 1966875040 10459536 7912480
18:05:10 44418 8192000000 10884623072 11330289664 1937094368 19.124 99 45 90 0 1963934480 12789232 14050880
18:06:04 60720 8192000000 10869249056 11337125888 1931812272 19.081 99 19 38 1 1952156448 14067328 6276848
18:07:12 36339 8192000000 10859959824 11347451904 1939396592 19.142 100 10 20 1 1955913312 13605584 2911136
18:07:55 46821 8192000000 10871956192 11336589312 1931522768 19.079 99 15 29 0 1948805776 13301328 3981680
18:08:56 43606 8192000000 10870491744 11338768384 1950969696 19.234 100 10 20 2 1963234656 8946432 3318528
18:09:45 79532 8192000000 10867871072 11334488064 1936515312 19.119 99 24 48 3 1952889808 9282864 7091632
18:12:23 36306 8192000000 10875455840 11339505664 1956761712 19.280 100 28 53 0 1972495632 8578368 7155552
18:13:06 64540 8192000000 10869843088 11341418496 1956616144 19.279 100 15 30 0 1969820976 9285488 3919344
18:14:48 78749 8192000000 10853664816 11329826816 1922443728 19.006 98 15 30 1 1934346976 8317744 3585504
18:16:12 65301 8192000000 10888496224 11369590784 1946943200 19.202 99 6 12 0 1961994256 13391552 1659504
18:18:39 92594 8192000000 10881089008 11353501696 1912664016 18.928 97 10 20 0 1927004752 11630848 2709888
18:20:21 113944 8192000000 10902204144 11373887488 1909798384 18.905 97 17 34 1 1929236048 14745520 4692144
18:23:10 76217 8192000000 10908337520 11388588032 1953345584 19.253 99 13 27 0 1989619840 31562128 4712128
18:24:40 65721 8192000000 10911293904 11371122688 1963142896 19.331 100 12 24 1 1978340768 12025968 3171904
18:25:52 90348 8192000000 10920825952 11406950400 1963621520 19.335 99 16 32 1 1984507984 16644656 4241808
18:27:29 106179 8192000000 10917014320 11384193024 1975455888 19.429 99 12 25 1 1993030368 14837264 2737216
18:29:47 54972 8192000000 10931283984 11394772992 1983162672 19.490 99 39 78 0 2000711280 7239760 10308848
18:30:53 40294 8192000000 10932168464 11380862976 1948336672 19.213 97 42 85 1 1970926864 10699808 11890384
18:31:39 39615 8192000000 10879030176 11357884416 1950347632 19.229 98 18 36 2 1966100160 10580256 5172272
18:32:26 65533 8192000000 10878630032 11355164672 1927995392 19.051 97 13 26 1 1945370112 13090704 4284016
18:33:44 20879 8192000000 10867342272 11350331392 1938768640 19.137 99 4 8 1 1952272976 12394032 1110304
18:34:43 57170 8192000000 10890893680 11358015488 1947140544 19.204 99 10 20 0 1959333616 9637056 2556016
18:35:57 47239 8192000000 10868360112 11356086272 1931068816 19.075 98 24 47 1 1949525808 11942208 6514784
18:36:57 64801 8192000000 10870451536 11340595200 1885930384 18.713 96 13 26 0 1897064208 7627536 3506288
18:38:09 31089 8192000000 10883705152 11343376384 1923069408 19.011 98 29 58 0 1938740144 7638400 8032336
18:38:55 65928 8192000000 10857054416 11323011072 1825206096 18.220 93 19 36 1 1839270560 8888256 5176208
18:41:46 87424 8192000000 10840436640 11302731776 1775927056 17.816 91 26 52 1 1794383136 11047520 7408560
18:43:46 77135 8192000000 10861678336 11325308928 1903439616 18.854 98 16 31 1 1917748848 10440544 3868688
18:45:09 15590 8192000000 10889224544 11332145152 1934263600 19.101 99 51 102 0 1957111744 8498752 14349392
18:45:32 42710 8192000000 10866537664 11325927424 1910192192 18.908 98 35 70 2 1932097024 12562944 9341888
18:47:28 31341 8192000000 10813490592 11262255104 1806266928 18.065 95 25 50 0 1823918784 10535664 7116192
18:48:14 24885 8192000000 10834840944 11296137216 1897734720 18.808 100 19 38 2 1914648704 12032144 4881840
18:48:47 46353 8192000000 10842898240 11307663360 1882711296 18.687 98 23 44 2 1900606016 11568304 6326416
18:49:39 75339 8192000000 10839393424 11309666304 1849894096 18.421 96 19 36 1 1866529744 11022928 5612720
18:51:23 86929 8192000000 10868230656 11311988736 1850891488 18.429 96 26 50 1 1866100320 8241120 6967712
18:52:59 35425 8192000000 10864730672 11309199360 1915840416 18.954 99 43 84 0 1938563728 11328368 11394944
18:53:41 26034 8192000000 10873786832 11306287104 1900479200 18.830 98 42 83 1 1924452784 11644816 12328768
18:54:34 76202 8192000000 10857175904 11332059136 1934695808 19.104 100 16 32 0 1950553520 11058048 4799664
18:55:56 26462 8192000000 10854338912 11328425984 1923299888 19.013 99 6 12 0 1936068800 11117008 1651904
18:56:58 65002 8192000000 10890293280 11347947520 1947612688 19.207 100 19 38 1 1967055808 14150704 5292416
18:58:10 76839 8192000000 10894225568 11370463232 1946487056 19.198 99 11 22 0 1964067200 14838848 2741296
18:59:35 76730 8192000000 10899564544 11365498880 1956204160 19.276 99 16 33 0 1970269680 9872448 4193072
19:00:59 44836 8192000000 10915668672 11378667520 1963801984 19.336 99 12 24 0 1981343008 13907904 3633120
19:01:57 68268 8192000000 10918129664 11382484992 1968892848 19.377 99 22 44 0 1989003296 14079968 6030480
19:03:12 38526 8192000000 10915506400 11385339904 1971833936 19.400 99 28 56 0 1989129920 9077248 8218736
19:03:56 67443 8192000000 10933848832 11379945472 1991394672 19.555 100 27 55 1 2007430176 9284944 6750560
19:05:13 34678 8192000000 10944201808 11403198464 2004459648 19.658 100 43 84 2 2024543216 8787488 11296080
19:06:39 41860 8192000000 10920428784 11383844864 1956734032 19.280 98 26 52 1 1979141360 15007904 7399424
19:07:30 81731 8192000000 10919322416 11377426432 1933046416 19.091 97 13 26 0 1949004672 12437648 3520608
19:08:59 126998 8192000000 10936222704 11402264576 1955619680 19.271 98 21 42 0 1973913184 12741072 5552432
19:11:12 109517 8192000000 10901225008 11353387008 1896658032 18.799 95 12 24 1 1914788656 14753360 3377264
19:13:10 111226 8192000000 10920972352 11374837760 1983272080 19.491 100 17 34 0 2001887664 13990016 4625568
19:15:08 57406 8192000000 10899921888 11373715456 1932799248 19.089 97 18 36 2 1944934160 7600944 4533968
19:16:12 71599 8192000000 10927790624 11395215360 1979860512 19.464 99 30 60 2 2001838992 13125632 8852848
19:19:02 40312 8192000000 10901314096 11398381568 1975038160 19.425 100 5 9 1 1995637360 18923536 1675664
19:20:37 89419 8192000000 10901174768 11376930816 1943824080 19.177 98 9 18 1 1960125712 13412016 2889616
19:22:12 72246 8192000000 10880086720 11359686656 1913729568 18.937 97 15 30 1 1934553856 16314528 4509760
19:23:31 64484 8192000000 10897768672 11378634752 1938998528 19.139 99 9 18 0 1956734384 15491712 2244144
19:24:44 68198 8192000000 10885076016 11360055296 1918684000 18.976 97 12 24 0 1930157200 8831808 2641392
19:25:59 61759 8192000000 10905178752 11363192832 1926357344 19.038 98 24 48 0 1941131168 7734960 7038864
19:27:09 13499 8192000000 9234755024 9490944000 391443296 4.560 21 3 6 0 396626912 4564800 618816

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 25-01-2021 19:28:37 to 25-01-2021 19:29:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 98 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-01-2021 19:29:09 to 25-01-2021 19:29:11.

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          232752
MON$OLDEST_ACTIVE               232753
MON$OLDEST_SNAPSHOT             232753
MON$NEXT_TRANSACTION            232753
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                       2008192
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:415: 
:416: mscs-test-161.budzdorov.ru    Mon Jan 25 19:27:25 2021
:417:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:418: 
:419: 
:420: mscs-test-161.budzdorov.ru    Mon Jan 25 19:27:25 2021
:421:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:422: 
--- end of diff output ---

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

25.01.21 19:29:12. 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-25 19:29:14 No severe PSQL-related problems occured
25.01.21 19:29:16. End of report.