Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.04.2021 19:27
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 df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17292684 kB
MemAvailable 31445112 kB
Buffers 0 kB
Cached 14353484 kB
SwapCached 0 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-04-02 19:27:28
DTS_END                         2021-04-02 19:27:28.4060
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/59810
TRN_ID                          238631
ATT_ID                          675
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: 9579.48 20688 1149538
customer order: creation 170.73 370 20488
customer order: refuse 14.35 309 1722
order to supplier: creation 45.99 1256 5519
order to supplier: removal 3.59 99186 431
invoice (draft): creation 44.76 3115 5371
invoice (draft): removal 55.80 788 6696
invoice accept: apply 42.14 17516 5057
invoice accept: cancel 50.74 713 6089
customer reserve: creation 3917.80 173 470136
customer reserve: removal 4936.72 56 592406
realization accept: apply 82.40 167 9888
realization accept: cancel 86.09 107 10331
payment from customer: creation 58.58 102 7029
payment from customer: removal 5.43 63 652
payment to supplier: creation 48.94 119 5873
payment to supplier: removal 3.58 96 430
service: total inventory turnovers 4.46 1088 535
service: total monetary turnovers 6.48 21 778
service: aggregate perf. data 0.86 16212 103
service: refresh index statistics 0.03 272294 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-04-2021 19:28:16 to 02-04-2021 19:28:18.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3779
TEST_TIME 2 5094
TEST_TIME 3 4597
TEST_TIME 4 4736
TEST_TIME 5 4565
TEST_TIME 6 5742
TEST_TIME 7 5212
TEST_TIME 8 5232
TEST_TIME 9 5451
TEST_TIME 10 5488
TEST_TIME 11 5558
TEST_TIME 12 5695
TEST_TIME 13 6173
TEST_TIME 14 6501
TEST_TIME 15 6881
TEST_TIME 16 6939
TEST_TIME 17 7840
TEST_TIME 18 8079
TEST_TIME 19 8245
TEST_TIME 20 8395
TEST_TIME 21 8681
TEST_TIME 22 8630
TEST_TIME 23 9035
TEST_TIME 24 9499
TEST_TIME 25 10086
TEST_TIME 26 10138
TEST_TIME 27 9849
TEST_TIME 28 9575
TEST_TIME 29 9644
TEST_TIME 30 9692
TEST_TIME 31 10139
TEST_TIME 32 10576
TEST_TIME 33 10445
TEST_TIME 34 10241
TEST_TIME 35 10186
TEST_TIME 36 10133
TEST_TIME 37 10338
TEST_TIME 38 10278
TEST_TIME 39 10147
TEST_TIME 40 10037
TEST_TIME 41 10231
TEST_TIME 42 10237
TEST_TIME 43 10210
TEST_TIME 44 10219
TEST_TIME 45 10169
TEST_TIME 46 9973
TEST_TIME 47 9822
TEST_TIME 48 9797
TEST_TIME 49 9807
TEST_TIME 50 9801
TEST_TIME 51 9771
TEST_TIME 52 9670
TEST_TIME 53 9715
TEST_TIME 54 9766
TEST_TIME 55 9762
TEST_TIME 56 9670
TEST_TIME 57 9583
TEST_TIME 58 9551
TEST_TIME 59 9492
TEST_TIME 60 9521
TEST_TIME 61 9521
TEST_TIME 62 9477
TEST_TIME 63 9481
TEST_TIME 64 9542
TEST_TIME 65 9483
TEST_TIME 66 9525
TEST_TIME 67 9559
TEST_TIME 68 9563
TEST_TIME 69 9684
TEST_TIME 70 9643
TEST_TIME 71 9664
TEST_TIME 72 9665
TEST_TIME 73 9708
TEST_TIME 74 9685
TEST_TIME 75 9805
TEST_TIME 76 9814
TEST_TIME 77 9705
TEST_TIME 78 9614
TEST_TIME 79 9575
TEST_TIME 80 9569
TEST_TIME 81 9512
TEST_TIME 82 9508
TEST_TIME 83 9508
TEST_TIME 84 9477
TEST_TIME 85 9418
TEST_TIME 86 9425
TEST_TIME 87 9433
TEST_TIME 88 9378
TEST_TIME 89 9410
TEST_TIME 90 9494
TEST_TIME 91 9500
TEST_TIME 92 9517
TEST_TIME 93 9525
TEST_TIME 94 9503
TEST_TIME 95 9532
TEST_TIME 96 9539
TEST_TIME 97 9622
TEST_TIME 98 9612
TEST_TIME 99 9638
TEST_TIME 100 9576
TEST_TIME 101 9532
TEST_TIME 102 9545
TEST_TIME 103 9512
TEST_TIME 104 9481
TEST_TIME 105 9503
TEST_TIME 106 9508
TEST_TIME 107 9495
TEST_TIME 108 9450
TEST_TIME 109 9456
TEST_TIME 110 9471
TEST_TIME 111 9454
TEST_TIME 112 9469
TEST_TIME 113 9454
TEST_TIME 114 9533
TEST_TIME 115 9522
TEST_TIME 116 9510
TEST_TIME 117 9534
TEST_TIME 118 9565
TEST_TIME 119 9609
TEST_TIME 120 9584

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-04-2021 19:28:20 to 02-04-2021 19:28:23.

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 1584568 1584568 0 0.00 0 12493 6 0 0
doc_list_biud 1584566 1584566 0 0.00 0 33376 27 0 0
sp_add_invoice_to_stock 5173 5057 116 2.24 18 187657 17516 0 116
sp_cancel_adding_invoice 6089 6089 0 0.00 6 69859 714 0 0
sp_cancel_client_order 1722 1722 0 0.00 4 13187 310 0 0
sp_cancel_customer_reserve 592406 592406 0 0.00 1 19597 57 0 0
sp_cancel_pay_from_customer 652 652 0 0.00 3 2710 63 0 0
sp_cancel_pay_to_supplier 430 430 0 0.00 3 6727 97 0 0
sp_cancel_supplier_invoice 6708 6696 12 0.17 1 33472 789 0 12
sp_cancel_supplier_order 431 431 0 0.00 9 935014 99186 0 0
sp_cancel_write_off 10331 10331 0 0.00 1 13298 107 0 0
sp_client_order 20488 20488 0 0.00 4 23475 371 0 0
sp_customer_reserve 470136 470136 0 0.00 0 100534 173 0 0
sp_fill_shopping_cart 31375 31375 0 0.00 1 9006 34 0 0
sp_fill_shopping_cart_clo_res 470121 470121 0 0.00 0 11848 14 0 0
sp_get_clo_for_invoice 5041 5041 0 0.00 0 28501 257 0 0
sp_kill_cost_storno 17502 17502 0 0.00 0 10044 55 0 0
sp_kill_qstorno_ret_qs2qd 1202270 1202270 0 0.00 0 33374 31 0 0
sp_kill_qty_storno 632602 632602 0 0.00 0 33376 66 0 0
sp_lock_selected_doc 20638 20638 0 0.00 0 10837 5 0 0
sp_make_cost_storno 27831 27831 0 0.00 0 12490 48 0 0
sp_multiply_rows_for_pdistr 27831 27831 0 0.00 0 6839 28 0 0
sp_multiply_rows_for_qdistr 20488 20488 0 0.00 0 13619 169 0 0
sp_pay_from_customer 7029 7029 0 0.00 4 10957 103 0 0
sp_pay_to_supplier 5873 5873 0 0.00 4 12535 119 0 0
sp_payment_common 12902 12902 0 0.00 1 12523 24 0 0
sp_qd_handle_on_cancel_clo 1722 1722 0 0.00 0 13181 271 0 0
sp_qd_handle_on_invoice_upd_sts 11128 11128 0 0.00 0 27255 313 0 0
sp_qd_handle_on_reserve_upd_sts 9888 9888 0 0.00 0 16840 50 0 0
sp_reserve_write_off 9888 9888 0 0.00 6 16892 167 0 0
sp_supplier_invoice 5371 5371 0 0.00 6 88578 3115 0 0
sp_supplier_order 5519 5519 0 0.00 5 26518 1256 0 0
srv_aggregate_perf_data 103 103 0 0.00 3701 96467 16213 0 0
srv_fill_mon_cache_memory 151 151 0 0.00 1491 130274 33104 0 0
srv_find_qd_qs_mism 1101599 1101599 0 0.00 0 10500 5 0 0
srv_make_invnt_saldo 535 535 0 0.00 32 53616 1089 0 0
srv_make_money_saldo 778 778 0 0.00 1 1237 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 68512 462890 272294 0 0
t$perf-abend:sp_add_invoice_to_stock 116 116 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5057 5057 0 0.00 0 22676 157 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 0 6537 100 0 0
t$perf-norm:sp_cancel_client_order 1722 1722 0 0.00 0 2228 13 0 0
t$perf-norm:sp_cancel_customer_reserve 703 703 0 0.00 0 1791 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 652 652 0 0.00 0 5303 21 0 0
t$perf-norm:sp_cancel_pay_to_supplier 430 430 0 0.00 0 239 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 385 385 0 0.00 0 4194 23 0 0
t$perf-norm:sp_cancel_supplier_order 431 431 0 0.00 0 20573 1442 0 0
t$perf-norm:sp_cancel_write_off 985 985 0 0.00 0 3104 6 0 0
t$perf-norm:sp_client_order 20488 20488 0 0.00 0 13894 17 0 0
t$perf-norm:sp_customer_reserve 1048 1048 0 0.00 0 1710 7 0 0
t$perf-norm:sp_pay_from_customer 7029 7029 0 0.00 0 10717 13 0 0
t$perf-norm:sp_pay_to_supplier 5873 5873 0 0.00 0 2239 5 0 0
t$perf-norm:sp_reserve_write_off 9888 9888 0 0.00 0 5140 11 0 0
t$perf-norm:sp_supplier_invoice 5371 5371 0 0.00 0 9862 21 0 0
t$perf-norm:sp_supplier_order 5519 5519 0 0.00 0 5364 17 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 270 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 151 151 0 0.00 0 204 5 0 0
t$perf-norm:srv_make_invnt_saldo 535 535 0 0.00 0 2893 26 0 0
t$perf-norm:srv_make_money_saldo 778 778 0 0.00 0 1637 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 10300 10068 232 2.25 0 5928 20 0 232
v_all_customers 37572 37572 0 0.00 0 18 1 0 0
v_all_suppliers 30252 30252 0 0.00 0 84 1 0 0
v_all_wares 40976 40976 0 0.00 0 56 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 5792 13 0 0
v_cancel_client_order 3444 3444 0 0.00 0 3086 5 0 0
v_cancel_customer_prepayment 1304 1304 0 0.00 0 1107 3 0 0
v_cancel_customer_reserve 1406 1406 0 0.00 0 2711 5 0 0
v_cancel_payment_to_supplier 860 860 0 0.00 0 6445 22 0 0
v_cancel_supplier_invoice 794 770 24 3.02 0 244 12 0 24
v_cancel_supplier_order 862 862 0 0.00 0 5288 13 0 0
v_cancel_write_off 1970 1970 0 0.00 0 5634 13 0 0
v_max_id_clo_ord 5519 5519 0 0.00 0 855 1 0 0
v_max_id_clo_res 1048 1048 0 0.00 0 7797 26 0 0
v_max_id_ord_sup 5368 5368 0 0.00 0 6263 5 0 0
v_max_non_paid_invoice 1634 1634 0 0.00 0 1677 3 0 0
v_max_non_paid_realizn 3645 3645 0 0.00 0 2458 3 0 0
v_min_id_clo_ord 5519 5519 0 0.00 0 7696 10 0 0
v_min_id_clo_res 1048 1048 0 0.00 0 7042 11 0 0
v_min_id_ord_sup 5368 5368 0 0.00 0 3793 4 0 0
v_min_non_paid_invoice 5873 5873 0 0.00 0 12516 15 0 0
v_min_non_paid_realizn 7029 7029 0 0.00 0 9608 14 0 0
v_our_firm 10172 10172 0 0.00 0 15 1 0 0
v_reserve_write_off 19776 19776 0 0.00 0 5884 7 0 0
x_lock_depdocs_on_canc_invoice 12400 12400 0 0.00 0 22692 107 0 0
x_lock_depdocs_on_canc_sup_ord 431 431 0 0.00 0 9223 361 0 0
x_make_qstorno_1000_1200 5519 5519 0 0.00 2 26494 1175 0 0
x_make_qstorno_1200_2000 5371 5371 0 0.00 3 88569 3005 0 0
x_make_qstorno_2100_3300 470136 470136 0 0.00 0 100532 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-04-2021 19:28:24 to 02-04-2021 19:28:28.

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:32 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:39 8852 8192000000 10167408224 10457280512 825632720 9.155 67 47 95 0 843370416 2068160 15669536
16:58:03 23290 8192000000 10328928912 10642968576 1363981696 14.273 100 84 167 2 1396842112 4930064 27930352
16:58:36 24186 8192000000 10365796944 10682257408 1417817168 14.753 100 89 178 0 1453094528 5774336 29503024
16:59:12 22780 8192000000 10396965904 10719752192 1452433888 15.059 100 91 182 0 1489034960 6954016 29647056
16:59:47 26074 8192000000 10425159520 10751897600 1472850752 15.239 100 91 182 0 1509711664 7545616 29315296
17:00:22 29811 8192000000 10450259024 10781671424 1497721344 15.456 100 92 184 1 1535675104 8799120 29154640
17:01:12 22340 8192000000 10481707952 10821267456 1526148320 15.704 100 85 170 1 1561877120 8718464 27010336
17:01:46 17005 8192000000 10516863728 10861588480 1566797728 16.055 100 89 178 0 1604098352 9567072 27733552
17:02:12 8578 8192000000 10536721392 10886520832 1589285152 16.248 100 77 154 1 1622271824 9981792 23004880
17:02:29 20821 8192000000 10565092144 10920448000 1617127040 16.485 100 78 156 3 1650909776 10264928 23517808
17:03:02 8500 8192000000 10568178864 10933317632 1638952448 16.671 100 75 150 1 1672057632 11039504 22065680
17:03:18 8893 8192000000 10621169552 10979573760 1671635440 16.947 100 83 166 0 1707977648 11561936 24780272
17:03:39 15552 8192000000 10630068928 10999488512 1688143120 17.086 100 84 168 0 1725422480 13033568 24245792
17:04:01 6204 8192000000 10640633232 11013365760 1700608032 17.190 100 76 152 1 1734671824 12347472 21716320
17:04:16 10727 8192000000 10669879680 11040309248 1722637632 17.374 100 82 163 1 1758766912 12551856 23577424
17:04:34 4718 8192000000 10670798864 11045634048 1736077632 17.486 100 80 160 2 1772755440 13176592 23501216
17:04:46 5518 8192000000 10688120048 11058225152 1743251440 17.546 100 81 159 1 1779525680 12509184 23765056
17:04:59 5233 8192000000 10698919200 11075018752 1762138752 17.702 100 89 178 2 1799130400 11894176 25097472
17:05:11 4440 8192000000 10715058336 11094908928 1775128272 17.809 100 85 171 2 1811554784 12608096 23818416
17:05:22 3831 8192000000 10721894416 11098509312 1782355248 17.869 100 76 152 2 1817054288 13369248 21329792
17:05:34 2860 8192000000 10733170720 11109912576 1791356288 17.943 100 85 170 0 1827737216 13037072 23343856
17:05:44 3590 8192000000 10740770320 11116904448 1797406256 17.993 100 91 182 2 1836385680 14265184 24714240
17:05:55 3538 8192000000 10747900320 11130167296 1804339072 18.049 100 84 168 1 1842168048 14773808 23055168
17:06:05 3320 8192000000 10752354992 11136499712 1811454656 18.108 100 88 172 2 1849697424 14410512 23832256
17:06:14 2267 8192000000 10758923424 11139956736 1819582464 18.174 100 84 168 0 1857585984 13977552 24025968
17:06:23 2398 8192000000 10759498032 11143249920 1821706384 18.192 100 88 175 1 1859519776 13472160 24341232
17:06:33 6058 8192000000 10749492352 11139649536 1821438016 18.189 100 74 148 0 1855117600 13612368 20067216
17:06:46 3165 8192000000 10781179184 11165175808 1829785840 18.258 100 82 165 2 1865505360 12657984 23061536
17:06:55 2270 8192000000 10790749936 11173597184 1841668496 18.354 100 90 180 1 1880545248 13298208 25578544
17:07:04 1899 8192000000 10784779504 11175940096 1849347536 18.417 100 83 167 1 1885879856 13065008 23467312
17:07:12 1945 8192000000 10796774096 11184173056 1855465712 18.467 100 91 180 0 1893436784 13174128 24796944
17:07:21 1600 8192000000 10801364720 11191668736 1860303984 18.506 100 93 187 1 1900344320 14136368 25903968
17:07:29 1982 8192000000 10808723088 11194613760 1862129632 18.521 100 91 180 2 1902553888 14712896 25711360
17:07:37 1500 8192000000 10808089952 11193733120 1863324400 18.530 100 89 178 2 1901549344 12354464 25870480
17:07:45 2236 8192000000 10803713616 11196088320 1863640400 18.533 100 78 156 0 1897877968 11836016 22401552
17:07:54 1809 8192000000 10801173952 11194740736 1867890800 18.567 100 80 161 0 1901698496 10735568 23072128
17:08:03 2146 8192000000 10818730592 11207856128 1872019408 18.601 100 92 183 3 1910386496 12301184 26065904
17:08:11 11332 8192000000 10812364080 11205804032 1872703632 18.606 100 75 151 2 1905431424 11387312 21340480
17:08:29 2778 8192000000 10809626480 11208888320 1874020592 18.617 100 64 126 1 1903166240 11678928 17466720
17:08:38 2577 8192000000 10798777568 11207213056 1874819872 18.623 100 57 115 2 1901722640 10370624 16532144
17:08:47 6524 8192000000 10796693984 11209273344 1876608464 18.638 100 37 74 2 1893824960 7143376 10073120
17:09:02 5975 8192000000 10785755056 11210256384 1876852640 18.640 100 25 49 4 1890751344 7063424 6835280
17:09:19 8879 8192000000 10786541040 11211984896 1881125920 18.674 100 28 56 0 1894811840 5628736 8057184
17:09:34 5022 8192000000 10794266832 11218259968 1884650448 18.703 100 32 64 2 1900462688 6483968 9328272
17:09:46 7361 8192000000 10788132736 11218448384 1885610928 18.710 100 35 70 1 1903814928 7913680 10290320
17:10:03 7035 8192000000 10791401616 11216367616 1884824224 18.704 100 23 46 2 1897000704 6093200 6083280
17:10:18 8088 8192000000 10792691712 11222503424 1886538640 18.718 100 27 52 1 1900206688 6116000 7552048
17:10:34 17216 8192000000 10802172304 11223855104 1887722592 18.727 100 24 49 0 1900641936 5555296 7364048
17:10:58 66867 8192000000 10816985504 11241013248 1895755136 18.792 100 41 80 2 1914097824 7067952 11274736
17:12:11 4439 8192000000 10816123056 11236679680 1892876096 18.769 100 35 70 2 1909806656 7212560 9718000
17:12:24 6130 8192000000 10812236096 11240828928 1891116336 18.755 100 27 54 4 1908810384 10087536 7606512
17:12:38 3694 8192000000 10819955360 11245043712 1899282784 18.821 100 54 108 0 1923816624 9494048 15039792
17:12:50 8081 8192000000 10817507296 11242545152 1895648112 18.791 100 31 60 2 1910669344 6036112 8985120
17:13:05 8678 8192000000 10805658976 11242663936 1897283424 18.804 100 31 60 3 1913337536 6443952 9610160
17:13:23 6866 8192000000 10804968464 11245043712 1899493888 18.822 100 29 58 0 1914876336 7214128 8168320
17:13:36 7261 8192000000 10827239376 11254632448 1901561968 18.839 100 29 57 1 1915204320 5482496 8159856
17:13:50 6478 8192000000 10818913248 11250601984 1901305968 18.837 100 38 75 2 1923327520 11733952 10287600
17:14:04 7787 8192000000 10815020384 11248390144 1900190528 18.828 100 25 49 1 1913452672 6461744 6800400
17:14:22 9638 8192000000 10815470272 11248644096 1902449136 18.846 100 29 58 2 1916119056 5493664 8176256
17:14:37 8914 8192000000 10818632640 11251040256 1901936688 18.842 100 18 36 0 1913847472 6613936 5296848
17:14:57 13809 8192000000 10821452464 11258511360 1907784928 18.889 100 22 41 5 1920254128 5774256 6694944
17:15:17 71543 8192000000 10812535856 11253526528 1908792480 18.897 100 28 56 1 1923596864 5380432 9423952
17:16:36 9818 8192000000 10814010208 11250561024 1895391104 18.789 99 30 60 1 1910088448 6042528 8654816
17:16:54 5432 8192000000 10801508128 11243802624 1887056000 18.722 99 28 56 0 1901541888 6433360 8052528
17:17:05 10476 8192000000 10808952624 11241787392 1879517600 18.661 99 27 54 0 1893725152 6900000 7307552
17:17:23 7865 8192000000 10787387040 11214209024 1840290432 18.343 97 15 30 1 1854161168 9574224 4296512
17:17:39 6574 8192000000 10785796688 11216986112 1845444272 18.385 98 12 24 1 1854272304 5168816 3659216
17:17:53 6695 8192000000 10780566416 11213373440 1839904208 18.340 98 22 42 4 1851388384 5232336 6251840
17:18:06 5224 8192000000 10766541312 11191332864 1809735632 18.094 97 29 58 4 1824224000 6024064 8464304
17:18:17 11793 8192000000 10746407232 11173257216 1772280400 17.786 96 17 34 1 1782400400 5085904 5034096
17:18:35 4654 8192000000 10732721888 11163983872 1799971280 18.014 98 25 50 1 1813554912 6678288 6905344
17:18:47 8781 8192000000 10713761696 11127369728 1717870752 17.334 94 27 54 1 1731354384 5901920 7581712
17:19:06 13226 8192000000 10658004288 11072417792 1596294752 16.308 89 17 34 0 1606204896 5132608 4777536
17:19:28 7813 8192000000 10674106512 11094839296 1733143056 17.462 98 28 55 1 1747118672 5163008 8812608
17:19:43 5495 8192000000 10697376160 11112161280 1776480848 17.820 100 21 43 1 1788375104 6286592 5607664
17:19:58 10683 8192000000 10700153632 11121111040 1763390400 17.712 98 24 46 1 1775616176 5174528 7051248
17:20:17 68049 8192000000 10686714896 11100254208 1724243088 17.388 96 22 44 0 1735799232 5023376 6532768
17:21:32 10044 8192000000 10690596496 11102674944 1716931872 17.327 96 31 62 2 1732148608 6322416 8894320
17:21:54 5695 8192000000 10676457216 11084201984 1743035024 17.544 99 44 88 3 1763940176 7935472 12969680
17:22:06 4967 8192000000 10688257360 11094401024 1766467856 17.738 100 37 74 2 1783226240 6109872 10648512
17:22:20 7299 8192000000 10701060768 11115114496 1785218672 17.892 100 31 63 2 1800453984 6113984 9121328
17:22:34 7016 8192000000 10722945424 11136921600 1803564000 18.043 100 30 59 3 1819330880 7146432 8620448
17:22:47 5844 8192000000 10735775312 11151597568 1816184832 18.146 100 34 66 1 1832178752 6152736 9841184
17:23:01 8065 8192000000 10745891984 11164733440 1827207296 18.237 100 26 51 3 1840846880 6113744 7525840
17:23:18 6307 8192000000 10754296912 11174141952 1836976224 18.316 100 34 68 1 1854106288 6759200 10370864
17:23:32 6584 8192000000 10772067216 11185987584 1838609584 18.329 100 29 58 4 1852378352 5209280 8559488
17:23:47 11155 8192000000 10762250928 11184390144 1843874624 18.372 100 32 62 5 1860089760 6207744 10007392
17:24:04 8492 8192000000 10765186880 11187384320 1846002000 18.390 100 26 52 1 1859730864 5602224 8126640
17:24:19 8677 8192000000 10775261392 11192786944 1850311680 18.425 100 29 59 4 1864552976 5551376 8689920
17:24:34 10725 8192000000 10767155472 11191275520 1852528544 18.443 100 20 39 3 1863729696 5369216 5831936
17:24:53 18948 8192000000 10765245216 11198267392 1861013120 18.511 100 32 65 0 1876038784 6079264 8946400
17:25:27 67460 8192000000 10766115600 11202646016 1866340144 18.555 100 37 74 1 1882361952 5473984 10547824
17:26:44 10555 8192000000 10776825168 11209236480 1866420912 18.555 100 17 34 0 1876765328 5222432 5121984
17:27:02 10054 8192000000 10796313088 11226681344 1879441008 18.661 100 23 46 1 1890815536 4931984 6442544
17:27:19 11274 8192000000 10809812384 11231850496 1890264160 18.748 100 22 44 1 1901364896 4569488 6531248
17:27:42 4818 8192000000 10832705456 11246534656 1900152368 18.828 100 55 109 2 1922398640 6374816 15871456
17:27:56 13265 8192000000 10839668400 11254476800 1910943888 18.914 100 48 97 0 1931931232 7587264 13400080
17:28:16 7416 8192000000 10858825904 11270864896 1918527408 18.975 100 56 112 0 1944311392 9445536 16338448
17:28:31 38934 8192000000 10854469936 11281690624 1924750176 19.025 100 48 95 0 1947935680 9627696 13557808
17:29:17 20635 8192000000 10864980016 11290578944 1932186560 19.084 100 41 82 0 1954834736 10677632 11970544
17:29:44 11897 8192000000 10863736304 11287547904 1935363936 19.110 100 42 83 0 1955367680 8405392 11598352
17:30:04 7460 8192000000 10874232992 11298484224 1941071072 19.155 100 53 106 1 1966805760 9789600 15945088
17:30:24 10287 8192000000 10891765520 11309023232 1947104512 19.203 100 55 107 1 1973105104 10714640 15285952
17:30:44 8092 8192000000 10886044752 11309268992 1950350064 19.229 100 58 116 2 1980112720 12485648 17277008
17:30:59 28357 8192000000 10892974256 11313000448 1934734784 19.105 99 49 98 1 1962279360 12640320 14904256
17:31:38 11859 8192000000 10887762176 11318525952 1953600624 19.255 100 45 90 1 1980999408 14287904 13110880
17:31:58 21232 8192000000 10899155216 11333435392 1961028768 19.314 100 45 90 0 1988063968 14062720 12972480
17:32:28 85726 8192000000 10902420016 11341426688 1968521184 19.374 100 36 72 0 1999838976 19525808 11791984
17:34:15 32034 8192000000 10922870384 11358093312 1982797888 19.487 100 46 92 1 2012948752 16373376 13777488
17:34:57 21623 8192000000 10919934976 11355893760 1976829168 19.440 100 38 76 0 2005907104 17849888 11228048
17:35:36 13454 8192000000 10933135392 11370704896 1990874688 19.551 100 47 94 4 2025101664 18852016 15374960
17:35:59 10945 8192000000 10934865392 11375718400 1996057328 19.592 100 41 82 0 2027159088 18824800 12276960
17:36:16 2977 8192000000 10938022320 11378675712 1999949280 19.622 100 48 94 3 2032775984 18971488 13855216
17:36:37 4871 8192000000 10950911600 11380514816 2001311392 19.633 100 50 100 0 2034387664 18902256 14174016
17:36:49 5871 8192000000 10961434112 11390046208 2007728432 19.684 100 58 116 0 2045625008 20185504 17711072
17:37:03 4825 8192000000 10969196000 11395375104 2013088704 19.726 100 67 132 1 2052626160 20906640 18630816
17:37:23 9113 8192000000 10969082640 11402141696 2021488288 19.792 100 65 129 1 2062040480 21128208 19423984
17:37:42 9185 8192000000 10964313536 11399790592 2002099712 19.639 99 71 138 1 2043992032 20864032 21028288
17:38:04 12266 8192000000 10969444880 11407364096 2018208800 19.766 100 50 100 1 2058989120 25263152 15517168
17:38:24 6520 8192000000 10965314528 11408748544 2018780592 19.771 100 47 94 2 2060246896 26491520 14974784
17:38:37 7547 8192000000 10988074480 11416604672 2022823168 19.802 100 58 114 0 2066474368 26819792 16831408
17:39:00 2039 8192000000 10990292080 11417989120 2025072864 19.820 100 68 136 0 2072510704 26262528 21175312
17:39:10 3992 8192000000 10982770992 11402653696 2008619168 19.691 99 85 170 1 2062230544 27446704 26164672
17:39:24 1645 8192000000 10995050784 11415732224 2025524320 19.824 100 80 160 3 2078312224 29594848 23193056
17:39:33 4294 8192000000 10981140032 11412672512 2020452096 19.784 100 66 132 0 2071116080 30627424 20036560
17:39:46 1490 8192000000 10988662384 11402010624 2000301408 19.625 99 89 178 2 2057291056 30502464 26487184
17:39:54 2626 8192000000 10984876432 11403571200 2010347200 19.704 100 81 162 1 2067310352 32608816 24354336
17:40:04 2679 8192000000 10981152144 11400663040 2007762016 19.684 100 83 163 2 2064155632 31498496 24895120
17:40:17 11067 8192000000 10983082576 11409149952 2007784944 19.684 100 68 136 0 2068453360 38727632 21940784
17:40:38 7135 8192000000 10972205712 11401682944 2006528496 19.674 100 71 140 1 2060879776 32848832 21502448
17:40:55 5598 8192000000 10971286928 11404173312 2000804336 19.629 99 68 135 1 2057170400 35698128 20667936
17:41:13 2585 8192000000 11014306928 11439554560 2033064928 19.883 100 81 161 2 2094540672 36237264 25238480
17:41:23 1624 8192000000 11019303072 11437346816 2034652912 19.895 100 80 160 0 2095674512 36411664 24609936
17:41:31 2892 8192000000 10991855360 11415048192 2011940368 19.717 99 82 164 1 2075550576 37243824 26366384
17:41:42 3805 8192000000 11002223216 11424501760 2019965168 19.780 100 77 154 0 2081190704 37415392 23810144
17:41:56 9377 8192000000 10988057504 11420041216 2000913696 19.630 99 66 130 0 2058926416 36991216 21021504
17:42:13 3876 8192000000 10979764000 11418693632 2014940848 19.740 100 61 122 2 2071414224 36374240 20099136
17:42:26 3204 8192000000 10965068752 11378126848 1967514320 19.366 98 83 163 2 2027998992 35331488 25153184
17:42:35 2635 8192000000 10978497600 11392565248 1994527072 19.580 100 87 174 2 2059567632 37592880 27447680
17:42:45 5573 8192000000 10967008240 11380424704 1966214416 19.355 99 79 155 1 2028915984 38184000 24517568
17:42:59 1751 8192000000 10966789040 11377356800 1981584240 19.477 100 91 182 1 2050321296 40502160 28234896
17:43:08 3309 8192000000 10963173824 11377762304 1975638368 19.430 100 85 168 1 2044704896 42406528 26660000
17:43:19 4324 8192000000 10963520752 11382788096 1980106912 19.466 100 79 156 3 2047423728 43254992 24061824
17:43:31 3389 8192000000 10976122416 11397341184 1988533104 19.532 100 84 164 1 2060001696 45620192 25848400
17:43:41 3687 8192000000 10980923312 11402805248 1995382336 19.586 100 75 151 1 2064436176 45637616 23416224
17:43:53 2191 8192000000 10999931664 11414704128 2006009664 19.670 100 90 178 0 2081119408 46563856 28545888
17:44:05 1570 8192000000 10996414784 11415302144 2007121616 19.679 100 82 164 1 2077962384 44901216 25939552
17:44:20 3690 8192000000 10971801280 11402883072 1992930080 19.567 100 76 151 1 2061896864 44563776 24403008
17:44:34 7341 8192000000 10947963536 11378921472 1949528304 19.223 98 61 121 2 2010281728 41085056 19668368
17:44:48 9674 8192000000 10937463392 11374088192 1970764992 19.392 100 44 86 2 2025171392 39846448 14559952
17:45:06 18983 8192000000 10938465664 11386064896 1979480640 19.461 100 39 78 1 2027647424 35635008 12531776
17:45:33 18367 8192000000 10940796352 11381420032 1976801104 19.439 100 39 78 2 2023593712 34514656 12277952
17:46:00 6648 8192000000 10928187248 11370823680 1954633712 19.263 99 42 84 1 2000583520 32761248 13188560
17:46:15 2020 8192000000 10948106992 11383431168 1986674608 19.518 100 63 125 3 2038177744 32153072 19350064
17:46:42 6532 8192000000 10931555264 11362484224 1960027696 19.306 100 47 91 0 2007412416 33093216 14291504
17:46:58 11335 8192000000 10938506688 11375489024 1970171312 19.387 100 48 96 0 2020995168 35606560 15217296
17:47:16 12436 8192000000 10933113056 11371556864 1958246496 19.292 99 45 88 2 2009511744 37693200 13572048
17:47:37 15450 8192000000 10917473248 11369406464 1943399984 19.174 99 41 82 0 1997923264 40934816 13588464
17:48:11 22560 8192000000 10920937984 11376136192 1960394208 19.309 100 36 72 0 2010668192 37937248 12336736
17:48:44 20013 8192000000 10893460400 11339878400 1908269296 18.893 98 31 62 3 1953287920 34815488 10203136
17:49:21 14763 8192000000 10903151280 11350847488 1940092704 19.147 100 36 71 3 1989562624 37618368 11851552
17:49:57 14637 8192000000 10891807136 11341721600 1902955744 18.850 98 30 60 1 1955244048 41390368 10897936
17:50:36 24512 8192000000 10889282784 11338260480 1884135568 18.698 98 27 54 0 1937977248 43920016 9921664
17:51:07 8424 8192000000 10882771424 11334057984 1905959424 18.874 99 27 54 0 1956909488 41121360 9828704
17:51:29 22316 8192000000 10898794304 11342913536 1904727616 18.864 99 25 50 0 1956839568 43151232 8960720
17:52:01 6132 8192000000 10878781808 11322458112 1902415840 18.846 100 25 50 2 1952337104 41072752 8848512
17:52:14 15632 8192000000 10887908640 11335364608 1915466560 18.951 100 29 58 0 1970108032 44828176 9813296
17:52:50 17185 8192000000 10897103584 11344535552 1930460224 19.071 100 20 40 1 1967655152 31089648 6105280
17:53:14 6893 8192000000 10905853552 11355000832 1942308624 19.165 100 24 48 2 1984388624 32712016 9367984
17:53:44 43245 8192000000 10907496240 11357540352 1949452528 19.222 100 23 46 1 1987977712 31002048 7523136
17:54:57 50631 8192000000 10903216688 11346542592 1918834288 18.978 98 43 86 0 1962693552 30485344 13373920
17:55:59 29133 8192000000 10900352096 11348791296 1934245680 19.101 100 28 56 1 1979962144 36282256 9434208
17:56:38 36817 8192000000 10897069520 11360690176 1941882944 19.162 100 25 50 3 1982913104 33312912 7717248
17:57:51 57084 8192000000 10882567216 11364503552 1884511296 18.702 98 13 26 1 1944792000 55627840 4652864
17:58:55 11553 8192000000 10872199872 11369885696 1898516032 18.814 99 9 17 2 1938389408 36824128 3049248
18:00:33 27513 8192000000 10865758944 11317739520 1927269760 19.045 100 31 62 1 1942476208 6925872 8280576
18:01:13 70066 8192000000 10881175824 11334029312 1911305744 18.917 98 34 68 2 1935100272 13794544 9999984
18:02:31 32789 8192000000 10880146064 11337428992 1920054144 18.987 99 12 24 1 1937869968 14544656 3271168
18:03:10 96401 8192000000 10878505264 11349680128 1926107264 19.036 99 9 18 0 1951190784 22513680 2569840
18:04:54 44507 8192000000 10864424208 11315507200 1908603216 18.895 98 20 40 0 1921537648 7291232 5643200
18:05:58 53700 8192000000 10920179568 11344007168 1949921248 19.226 100 42 84 0 1970946192 9339760 11685184
18:07:08 79705 8192000000 10884959824 11364528128 1961285168 19.316 100 45 90 0 1986274368 11382656 13606544
18:10:06 77075 8192000000 10887887632 11356565504 1926715728 19.041 98 10 20 1 1942820608 13282848 2822032
18:11:29 86038 8192000000 10894714768 11367358464 1927840656 19.050 98 23 46 0 1949317584 14882320 6594608
18:13:01 28506 8192000000 10883040224 11355873280 1954243584 19.260 100 7 14 1 1971625952 15434576 1947792
18:14:10 66465 8192000000 10907191072 11373215744 1974088272 19.418 100 29 58 1 1992243344 10207152 7947920
18:15:30 60150 8192000000 10943935552 11393028096 1965445664 19.349 99 32 64 1 1985812560 11251840 9115056
18:18:39 89187 8192000000 10925253904 11380887552 1979812864 19.463 100 28 56 1 2000002928 11730752 8459312
18:20:30 38325 8192000000 10912821712 11378626560 1967529728 19.366 99 45 90 1 1993948848 12260704 14158416
18:21:20 28268 8192000000 10920886016 11388350464 1984766448 19.502 100 22 44 0 2002338544 10376880 7195216
18:22:30 29510 8192000000 10896978096 11380436992 1948648288 19.216 98 6 12 1 1959558640 9400992 1509360
18:23:13 50315 8192000000 10899401456 11378036736 1975244736 19.427 100 9 18 1 1988863008 11100176 2518096
18:24:09 39531 8192000000 10897352672 11363405824 1963399696 19.333 99 18 36 2 1980281440 12127648 4754096
18:24:56 40284 8192000000 10909776672 11387224064 1979106256 19.458 100 19 38 0 1997418224 12537328 5774640
18:26:01 60538 8192000000 10910064160 11392241664 1982522400 19.485 100 15 31 0 1999821824 12928656 4370768
18:27:08 55689 8192000000 10904871792 11382530048 1968716320 19.375 99 11 22 0 1981494576 9676640 3101616
18:28:09 42782 8192000000 10886694032 11360329728 1928025632 19.051 97 18 36 1 1940689728 7638656 5025440
18:29:34 77865 8192000000 10878821648 11358167040 1912590448 18.927 97 12 24 0 1926049984 10373312 3086224
18:30:58 55760 8192000000 10881808960 11348705280 1891007344 18.754 96 13 26 1 1910291408 15804400 3479664
18:32:00 35997 8192000000 10903483520 11365261312 1944929376 19.186 99 20 40 0 1958072624 7393536 5749712
18:32:42 30353 8192000000 10894149616 11365433344 1950105936 19.227 99 21 42 1 1966167408 10138224 5923248
18:33:18 41004 8192000000 10889420240 11360915456 1943482592 19.175 99 18 36 0 1959548400 10332624 5733184
18:34:14 38696 8192000000 10908092592 11366608896 1938659760 19.136 98 34 68 0 1957451008 9277424 9513824
18:35:03 31961 8192000000 10903602816 11364061184 1937881088 19.130 98 41 82 1 1962194320 12608608 11704624
18:35:45 74511 8192000000 10881270224 11357720576 1896482208 18.798 97 10 20 0 1910070240 10665904 2922128
18:37:10 38581 8192000000 10902263984 11359834112 1925932608 19.034 98 31 62 1 1943328224 8338672 9056944
18:37:59 74295 8192000000 10864854080 11314569216 1846326320 18.392 94 24 48 1 1864867488 12118800 6422368
18:39:20 31904 8192000000 10885284592 11355189248 1948882960 19.218 100 26 52 1 1965969376 9494352 7592064
18:40:05 63338 8192000000 10867864128 11346345984 1905307680 18.869 98 10 20 1 1921779536 13421008 3050848
18:41:15 49824 8192000000 10857989808 11319836672 1826482064 18.231 94 19 38 1 1845602768 13965792 5154912
18:42:25 76420 8192000000 10841726256 11299737600 1832291568 18.278 95 9 18 1 1847242752 12493520 2457664
18:43:48 117982 8192000000 10827950512 11285327872 1824312432 18.213 95 28 56 2 1841746576 9638768 7795376
18:46:02 53816 8192000000 10863911472 11318448128 1915283072 18.949 99 37 72 0 1935879072 9869264 10726736
18:47:03 75651 8192000000 10840370432 11322482688 1908712544 18.896 99 22 44 1 1926368544 11120320 6535680
18:50:04 53023 8192000000 10817325648 11292663808 1864547408 18.540 97 17 34 0 1882422176 12444208 5430560
18:51:08 64591 8192000000 10841644480 11324514304 1921042672 18.995 100 11 23 0 1934241248 9877664 3320912
18:52:19 68391 8192000000 10847846928 11327635456 1898890992 18.817 98 12 24 0 1915989424 13984256 3114176
18:53:46 43549 8192000000 10855180160 11320119296 1898826832 18.817 98 18 37 1 1911746384 7593872 5325680
18:54:36 50673 8192000000 10865278432 11335450624 1893653888 18.775 98 14 28 0 1908548928 11084576 3810464
18:55:37 47956 8192000000 10870032176 11332509696 1931598816 19.080 99 42 84 1 1956976304 12832048 12545440
18:56:48 75305 8192000000 10872844272 11342069760 1924384256 19.022 99 12 24 0 1942112064 14663472 3064336
18:58:10 38610 8192000000 10897971392 11359084544 1957792432 19.288 100 27 54 0 1973911792 8456208 7663152
18:59:05 50647 8192000000 10888305904 11359838208 1951432656 19.238 99 19 38 0 1967228640 10694992 5100992
19:00:02 52370 8192000000 10878477632 11345776640 1901860096 18.841 96 14 28 0 1912881072 7712304 3308672
19:01:08 32322 8192000000 10902962976 11364208640 1930786704 19.073 98 47 94 1 1958422800 14031328 13604768
19:01:47 36718 8192000000 10906754560 11374055424 1967738512 19.368 100 29 57 1 1987485872 11555456 8191904
19:02:46 43955 8192000000 10923136736 11391217664 1974307296 19.420 100 31 62 2 1996431376 13011104 9112976
19:03:42 130274 8192000000 10905664768 11384180736 1942632048 19.168 98 10 20 0 1959362128 14629296 2100784
19:06:02 71013 8192000000 10911160704 11374145536 1928890608 19.058 97 22 44 2 1945035056 10236880 5907568
19:07:23 96906 8192000000 10893397616 11374673920 1961450768 19.318 99 31 62 1 1978937856 8518032 8969056
19:09:06 66322 8192000000 10917500944 11401572352 1983335056 19.491 100 25 50 2 2007000480 16469184 7196240
19:10:19 18988 8192000000 10917254912 11398291456 1969575408 19.382 99 25 50 0 1994178224 17351520 7251296
19:10:47 45016 8192000000 10895860064 11395964928 1964237568 19.340 99 19 38 0 1985500896 14819824 6443504
19:13:31 50990 8192000000 10900996608 11388833792 1983512496 19.492 100 21 41 2 1997688336 8442384 5733456
19:14:39 56063 8192000000 10902926272 11382882304 1950662256 19.232 98 19 38 1 1964101184 8174368 5264560
19:15:48 72944 8192000000 10880158656 11371790336 1881998496 18.681 95 5 9 0 1892498480 9341536 1158448
19:17:07 51597 8192000000 10898018496 11383398400 1969582992 19.382 100 23 46 2 1983988816 7742016 6663808
19:18:05 50428 8192000000 10894790784 11372027904 1896392976 18.797 96 14 28 1 1911423408 10945520 4084912
19:19:03 55885 8192000000 10915212736 11397074944 1972912832 19.409 100 14 28 0 1986523840 9837760 3773248
19:20:09 51892 8192000000 10910385600 11391758336 1945328208 19.189 98 17 34 0 1964076624 13776448 4971968
19:21:08 64344 8192000000 10886164224 11362947072 1909137120 18.900 97 24 46 0 1927403344 11923584 6342640
19:22:19 42566 8192000000 10892439936 11365806080 1924381936 19.022 98 28 55 3 1946335328 13611024 8342368
19:23:13 35672 8192000000 10892110976 11344384000 1902496000 18.846 97 29 58 2 1918357248 8353728 7507520
19:23:58 105697 8192000000 10886943680 11375742976 1904287824 18.861 97 13 26 1 1924552208 16580576 3683808
19:26:26 73699 8192000000 9150918704 9385824256 307262912 3.615 16 4 8 1 315697056 7241504 1192640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 02-04-2021 19:28:30 to 02-04-2021 19:29:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 116 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

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

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          239461
MON$OLDEST_ACTIVE               239462
MON$OLDEST_SNAPSHOT             239462
MON$NEXT_TRANSACTION            239462
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                       2034784
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.33431 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33431 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33431 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33431 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 ---
:11: 
:12: mscs-test-161.budzdorov.ru    Fri Apr  2 19:27:44 2021
:13:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:14: 
:15: 
:16: mscs-test-161.budzdorov.ru    Fri Apr  2 19:27:49 2021
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
:19: 
:20: mscs-test-161.budzdorov.ru    Fri Apr  2 19:27:49 2021
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
--- end of diff output ---

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

02.04.21 19:29:04. 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-04-02 19:29:07 No severe PSQL-related problems occured
02.04.21 19:29:08. End of report.