Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.01.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 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 17167620 kB
MemAvailable 31253484 kB
Buffers 0 kB
Cached 14497940 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-26 19:27:12
DTS_END                         2021-01-26 19:27:12.8500
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(526:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/40614
TRN_ID                          238199
ATT_ID                          660
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: 9403.50 24586 1128420
customer order: creation 164.58 390 19749
customer order: refuse 13.88 342 1665
order to supplier: creation 44.21 1367 5305
order to supplier: removal 3.49 104281 419
invoice (draft): creation 43.84 3545 5261
invoice (draft): removal 55.52 746 6662
invoice accept: apply 40.42 18746 4850
invoice accept: cancel 50.09 802 6011
customer reserve: creation 3755.03 185 450603
customer reserve: removal 4936.94 58 592433
realization accept: apply 80.53 214 9663
realization accept: cancel 90.50 114 10860
payment from customer: creation 57.33 145 6879
payment from customer: removal 5.61 81 673
payment to supplier: creation 47.04 171 5645
payment to supplier: removal 3.05 70 366
service: total inventory turnovers 4.57 969 548
service: total monetary turnovers 6.05 56 726
service: aggregate perf. data 0.82 17184 98
service: refresh index statistics 0.03 342261 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5282
TEST_TIME 2 4112
TEST_TIME 3 3965
TEST_TIME 4 4390
TEST_TIME 5 4340
TEST_TIME 6 4448
TEST_TIME 7 4503
TEST_TIME 8 4431
TEST_TIME 9 4558
TEST_TIME 10 4783
TEST_TIME 11 4832
TEST_TIME 12 5069
TEST_TIME 13 5491
TEST_TIME 14 5743
TEST_TIME 15 6250
TEST_TIME 16 6841
TEST_TIME 17 7385
TEST_TIME 18 7780
TEST_TIME 19 8037
TEST_TIME 20 8237
TEST_TIME 21 9150
TEST_TIME 22 9769
TEST_TIME 23 10296
TEST_TIME 24 10308
TEST_TIME 25 11432
TEST_TIME 26 11132
TEST_TIME 27 11117
TEST_TIME 28 10838
TEST_TIME 29 10805
TEST_TIME 30 10711
TEST_TIME 31 10576
TEST_TIME 32 10559
TEST_TIME 33 10610
TEST_TIME 34 10497
TEST_TIME 35 10312
TEST_TIME 36 10240
TEST_TIME 37 10042
TEST_TIME 38 9836
TEST_TIME 39 10013
TEST_TIME 40 9957
TEST_TIME 41 10114
TEST_TIME 42 10026
TEST_TIME 43 10063
TEST_TIME 44 9989
TEST_TIME 45 9874
TEST_TIME 46 10001
TEST_TIME 47 9925
TEST_TIME 48 9940
TEST_TIME 49 9887
TEST_TIME 50 9894
TEST_TIME 51 10011
TEST_TIME 52 10078
TEST_TIME 53 10093
TEST_TIME 54 9967
TEST_TIME 55 9838
TEST_TIME 56 9822
TEST_TIME 57 9877
TEST_TIME 58 9815
TEST_TIME 59 9752
TEST_TIME 60 9699
TEST_TIME 61 9648
TEST_TIME 62 9538
TEST_TIME 63 9436
TEST_TIME 64 9398
TEST_TIME 65 9421
TEST_TIME 66 9502
TEST_TIME 67 9564
TEST_TIME 68 9566
TEST_TIME 69 9585
TEST_TIME 70 9589
TEST_TIME 71 9602
TEST_TIME 72 9707
TEST_TIME 73 9738
TEST_TIME 74 9717
TEST_TIME 75 9675
TEST_TIME 76 9770
TEST_TIME 77 9743
TEST_TIME 78 9721
TEST_TIME 79 9718
TEST_TIME 80 9606
TEST_TIME 81 9609
TEST_TIME 82 9540
TEST_TIME 83 9537
TEST_TIME 84 9522
TEST_TIME 85 9487
TEST_TIME 86 9461
TEST_TIME 87 9435
TEST_TIME 88 9380
TEST_TIME 89 9363
TEST_TIME 90 9441
TEST_TIME 91 9474
TEST_TIME 92 9511
TEST_TIME 93 9453
TEST_TIME 94 9582
TEST_TIME 95 9552
TEST_TIME 96 9537
TEST_TIME 97 9610
TEST_TIME 98 9608
TEST_TIME 99 9613
TEST_TIME 100 9581
TEST_TIME 101 9627
TEST_TIME 102 9669
TEST_TIME 103 9645
TEST_TIME 104 9635
TEST_TIME 105 9562
TEST_TIME 106 9525
TEST_TIME 107 9558
TEST_TIME 108 9507
TEST_TIME 109 9485
TEST_TIME 110 9454
TEST_TIME 111 9457
TEST_TIME 112 9427
TEST_TIME 113 9392
TEST_TIME 114 9384
TEST_TIME 115 9386
TEST_TIME 116 9392
TEST_TIME 117 9398
TEST_TIME 118 9438
TEST_TIME 119 9459
TEST_TIME 120 9404

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-01-2021 19:28:29 to 26-01-2021 19:28:32.

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 1546227 1546227 0 0.00 0 31357 7 0 0
doc_list_biud 1546186 1546186 0 0.00 0 46603 28 0 0
sp_add_invoice_to_stock 4967 4850 117 2.35 39 176863 18747 0 117
sp_cancel_adding_invoice 6011 6011 0 0.00 5 91717 802 0 0
sp_cancel_client_order 1665 1665 0 0.00 5 14172 343 0 0
sp_cancel_customer_reserve 592433 592433 0 0.00 1 46609 59 0 0
sp_cancel_pay_from_customer 673 673 0 0.00 3 7591 82 0 0
sp_cancel_pay_to_supplier 366 366 0 0.00 3 4417 71 0 0
sp_cancel_supplier_invoice 6671 6662 9 0.13 2 29621 747 0 9
sp_cancel_supplier_order 419 419 0 0.00 6 1098718 104281 0 0
sp_cancel_write_off 10860 10860 0 0.00 1 11904 114 0 0
sp_client_order 19749 19749 0 0.00 4 15952 390 0 0
sp_customer_reserve 450603 450603 0 0.00 0 40791 185 0 0
sp_fill_shopping_cart 30313 30313 0 0.00 1 15094 39 0 0
sp_fill_shopping_cart_clo_res 450601 450601 0 0.00 0 18773 13 0 0
sp_get_clo_for_invoice 4848 4848 0 0.00 0 19924 288 0 0
sp_kill_cost_storno 17910 17910 0 0.00 0 13493 56 0 0
sp_kill_qstorno_ret_qs2qd 1202807 1202807 0 0.00 0 46595 32 0 0
sp_kill_qty_storno 632532 632532 0 0.00 0 46602 68 0 0
sp_lock_selected_doc 20042 20042 0 0.00 0 7583 6 0 0
sp_make_cost_storno 27035 27035 0 0.00 0 31010 80 0 0
sp_multiply_rows_for_pdistr 26995 26995 0 0.00 0 18379 31 0 0
sp_multiply_rows_for_qdistr 19749 19749 0 0.00 0 11405 150 0 0
sp_pay_from_customer 6879 6879 0 0.00 4 19881 146 0 0
sp_pay_to_supplier 5645 5645 0 0.00 5 18557 171 0 0
sp_payment_common 12513 12513 0 0.00 1 19632 32 0 0
sp_qd_handle_on_cancel_clo 1665 1665 0 0.00 0 14144 320 0 0
sp_qd_handle_on_invoice_upd_sts 10848 10848 0 0.00 0 41589 328 0 0
sp_qd_handle_on_reserve_upd_sts 9645 9645 0 0.00 0 17664 68 0 0
sp_reserve_write_off 9663 9663 0 0.00 6 20520 215 0 0
sp_supplier_invoice 5261 5261 0 0.00 6 72541 3545 0 0
sp_supplier_order 5305 5305 0 0.00 4 45550 1367 0 0
srv_aggregate_perf_data 98 98 0 0.00 2972 226429 17184 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 1167 131536 34147 0 0
srv_find_qd_qs_mism 1082585 1082585 0 0.00 0 24409 5 0 0
srv_make_invnt_saldo 548 548 0 0.00 44 50771 970 0 0
srv_make_money_saldo 726 726 0 0.00 1 9907 56 0 0
srv_recalc_idx_stat 4 4 0 0.00 178996 493816 342261 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4850 4850 0 0.00 0 17816 153 0 0
t$perf-norm:sp_cancel_adding_invoice 399 399 0 0.00 0 5482 122 0 0
t$perf-norm:sp_cancel_client_order 1665 1665 0 0.00 0 12131 30 0 0
t$perf-norm:sp_cancel_customer_reserve 665 665 0 0.00 0 1113 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 673 673 0 0.00 0 3348 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 366 366 0 0.00 0 463 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 458 10 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 31443 1594 0 0
t$perf-norm:sp_cancel_write_off 968 968 0 0.00 0 10154 30 0 0
t$perf-norm:sp_client_order 19749 19749 0 0.00 0 10993 19 0 0
t$perf-norm:sp_customer_reserve 973 973 0 0.00 0 2824 9 0 0
t$perf-norm:sp_pay_from_customer 6879 6879 0 0.00 0 6028 11 0 0
t$perf-norm:sp_pay_to_supplier 5645 5645 0 0.00 0 15430 23 0 0
t$perf-norm:sp_reserve_write_off 9663 9663 0 0.00 0 9444 14 0 0
t$perf-norm:sp_supplier_invoice 5261 5261 0 0.00 0 8120 18 0 0
t$perf-norm:sp_supplier_order 5305 5305 0 0.00 0 6303 14 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 337 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 5632 48 0 0
t$perf-norm:srv_make_invnt_saldo 548 548 0 0.00 0 679 13 0 0
t$perf-norm:srv_make_money_saldo 726 726 0 0.00 0 1865 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 9908 9674 234 2.36 0 5627 17 0 234
v_all_customers 36228 36228 0 0.00 0 156 1 0 0
v_all_suppliers 29392 29392 0 0.00 0 152 1 0 0
v_all_wares 39496 39496 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 798 798 0 0.00 0 2541 10 0 0
v_cancel_client_order 3330 3330 0 0.00 0 1535 5 0 0
v_cancel_customer_prepayment 1346 1346 0 0.00 0 2716 6 0 0
v_cancel_customer_reserve 1330 1330 0 0.00 0 1754 5 0 0
v_cancel_payment_to_supplier 732 732 0 0.00 0 1218 6 0 0
v_cancel_supplier_invoice 828 810 18 2.17 0 875 13 0 18
v_cancel_supplier_order 838 838 0 0.00 0 2150 8 0 0
v_cancel_write_off 1936 1936 0 0.00 0 2123 19 0 0
v_max_id_clo_ord 5304 5304 0 0.00 0 3903 2 0 0
v_max_id_clo_res 973 973 0 0.00 0 2209 15 0 0
v_max_id_ord_sup 5261 5261 0 0.00 0 5089 6 0 0
v_max_non_paid_invoice 1506 1506 0 0.00 0 3549 6 0 0
v_max_non_paid_realizn 3627 3627 0 0.00 0 3786 6 0 0
v_min_id_clo_ord 5304 5304 0 0.00 0 4125 6 0 0
v_min_id_clo_res 973 973 0 0.00 0 4380 18 0 0
v_min_id_ord_sup 5261 5261 0 0.00 0 6508 8 0 0
v_min_non_paid_invoice 5637 5637 0 0.00 0 5111 19 0 0
v_min_non_paid_realizn 6875 6875 0 0.00 0 9723 19 0 0
v_our_firm 9764 9764 0 0.00 0 100 1 0 0
v_reserve_write_off 19290 19290 0 0.00 0 3019 5 0 0
x_lock_depdocs_on_canc_invoice 12268 12268 0 0.00 0 12695 115 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 3962 302 0 0
x_make_qstorno_1000_1200 5305 5305 0 0.00 2 45543 1290 0 0
x_make_qstorno_1200_2000 5261 5261 0 0.00 2 68155 3406 0 0
x_make_qstorno_2100_3300 450603 450603 0 0.00 0 35390 170 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-01-2021 19:28:33 to 26-01-2021 19:28:37.

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:16 7 8192000000 8802267008 8813711360 8233680 0.100 2 1 2 0 8353088 56848 62560
16:57:22 9467 8192000000 10209349056 10510061568 838613088 9.286 67 52 105 0 859056720 2199136 18244496
16:57:40 25638 8192000000 10343095120 10659528704 1377228096 14.392 100 83 167 0 1408052832 4455328 26369408
16:58:15 13410 8192000000 10369427552 10692321280 1428979792 14.852 100 90 180 0 1464827520 6293280 29554448
16:58:38 32516 8192000000 10413296032 10739699712 1460612016 15.131 100 87 174 2 1496243280 7325920 28305344
16:59:20 20810 8192000000 10435055008 10766467072 1489958368 15.389 100 90 179 2 1526925264 8154112 28812784
16:59:48 25596 8192000000 10453343952 10786271232 1507911216 15.545 100 93 186 0 1546057376 8333488 29812672
17:00:28 28418 8192000000 10474495840 10809937920 1531171808 15.747 100 90 180 0 1568816400 9133248 28511344
17:01:04 18645 8192000000 10490855280 10831634432 1541179344 15.834 100 89 178 1 1578900512 9726848 27994320
17:01:34 16957 8192000000 10504509824 10850349056 1560562544 16.001 100 82 164 2 1595456544 9870896 25023104
17:01:58 13363 8192000000 10513115696 10867376128 1576528848 16.138 100 75 150 2 1609599712 10276464 22794400
17:02:20 11467 8192000000 10553588416 10910601216 1609875152 16.424 100 73 146 1 1641453488 10255696 21322640
17:02:39 10169 8192000000 10589202368 10949869568 1648538096 16.752 100 78 156 0 1682350048 11227792 22584160
17:02:58 10975 8192000000 10614062144 10977882112 1667044896 16.908 100 82 164 1 1703637104 12197360 24394848
17:03:18 10759 8192000000 10631945072 10998972416 1683191600 17.044 100 77 154 1 1717539232 12756912 21590720
17:03:37 8314 8192000000 10643302192 11016069120 1703312384 17.213 100 79 158 3 1738881328 12933616 22635328
17:03:55 7693 8192000000 10663119600 11037941760 1717390096 17.330 100 75 150 0 1751456432 12201104 21865232
17:04:12 6419 8192000000 10675613056 11050106880 1733934528 17.468 100 78 156 1 1768262704 12052208 22275968
17:04:26 7753 8192000000 10689309472 11063349248 1746409264 17.572 100 76 152 1 1780570064 12263344 21897456
17:04:41 5297 8192000000 10700176768 11075203072 1757718160 17.666 100 81 162 2 1793011920 12286544 23007216
17:04:53 6924 8192000000 10702906304 11080601600 1766074720 17.735 100 82 163 0 1801645072 12599952 22970400
17:05:07 4939 8192000000 10708115760 11093057536 1773939104 17.800 100 78 155 0 1808485712 12578032 21968576
17:05:19 3641 8192000000 10718011120 11097198592 1779303136 17.844 100 74 148 1 1812802416 13342624 20156656
17:05:30 3455 8192000000 10727443360 11109584896 1787277152 17.909 100 83 166 0 1824383072 13316992 23788928
17:05:41 3456 8192000000 10734377808 11119132672 1793301168 17.959 100 79 159 2 1829986560 13895328 22790064
17:05:52 3085 8192000000 10745941392 11125477376 1802239472 18.032 100 87 174 0 1839757520 13132720 24385328
17:06:02 4069 8192000000 10750193456 11136241664 1805885040 18.062 100 80 156 2 1841168784 12787216 22496528
17:06:13 3293 8192000000 10751342912 11137794048 1811296448 18.106 100 80 160 0 1846068448 12084976 22687024
17:06:24 3315 8192000000 10767248160 11150786560 1821856032 18.193 100 88 174 4 1857911184 11914672 24140480
17:06:34 10147 8192000000 10765347072 11155910656 1825150368 18.220 100 81 162 1 1860504448 13267360 22086720
17:06:51 5020 8192000000 10757607616 11146444800 1828346768 18.246 100 81 162 1 1864326288 13896192 22083328
17:07:02 2439 8192000000 10778732144 11173511168 1845866336 18.389 100 89 178 3 1886079488 14570112 25643040
17:07:12 1932 8192000000 10795702096 11183529984 1853248480 18.449 100 94 186 1 1893139440 13537936 26353024
17:07:20 1708 8192000000 10803545152 11191844864 1855747648 18.469 100 87 175 4 1893126224 13034992 24343584
17:07:29 1699 8192000000 10811621696 11198353408 1867171600 18.561 100 86 173 0 1904580704 13556656 23852448
17:07:37 2263 8192000000 10806136144 11201454080 1871234448 18.594 100 88 173 1 1908533456 12661008 24638000
17:07:45 2215 8192000000 10817397328 11208863744 1876430512 18.636 100 94 191 1 1916981696 13949184 26602000
17:07:54 1463 8192000000 10823653808 11214467072 1877378432 18.644 100 95 191 0 1918034768 13872960 26783376
17:08:02 1396 8192000000 10823206784 11215335424 1882357680 18.684 100 90 179 1 1920742000 12581344 25802976
17:08:09 1914 8192000000 10820693552 11214991360 1879282528 18.659 100 85 168 0 1915195088 12047424 23865136
17:08:18 9940 8192000000 10813715760 11213852672 1879303904 18.659 100 69 136 0 1910633152 12402624 18926624
17:08:36 6280 8192000000 10817777344 11216093184 1879262720 18.659 100 78 154 4 1913694768 12327584 22104464
17:08:48 1417 8192000000 10825909072 11218116608 1883691040 18.695 100 91 182 2 1922095968 12788768 25616160
17:08:56 14558 8192000000 10807160784 11215568896 1879504576 18.661 100 54 111 2 1904300304 9041120 15754608
17:09:18 3586 8192000000 10802342368 11218194432 1881352416 18.676 100 44 88 0 1903527296 10141728 12033152
17:09:28 1807 8192000000 10804697232 11220082688 1884163152 18.699 100 57 114 1 1909740608 9415184 16162272
17:09:38 6452 8192000000 10800222800 11217612800 1883469312 18.693 100 47 94 0 1907726080 11329696 12927072
17:09:51 9160 8192000000 10786636736 11217514496 1886018864 18.714 100 31 62 0 1901703472 7019696 8664912
17:10:08 4661 8192000000 10798266080 11225227264 1887339456 18.724 100 34 69 0 1907823472 11067296 9416720
17:10:18 4726 8192000000 10791094944 11221843968 1886021904 18.714 100 24 48 2 1899429568 6713904 6693760
17:10:30 9712 8192000000 10790282192 11227271168 1885584096 18.710 100 13 26 0 1895022208 5539168 3898944
17:10:46 9473 8192000000 10807683184 11234136064 1891628576 18.759 100 31 62 0 1907599408 7022416 8948416
17:11:06 19472 8192000000 10807829680 11231047680 1892666000 18.767 100 9 18 2 1900755440 5165984 2923456
17:11:35 10696 8192000000 10809942208 11241725952 1901207456 18.836 100 15 30 0 1911020000 5100544 4712000
17:11:52 7758 8192000000 10794436880 11238334464 1899153584 18.819 100 14 29 0 1908741984 5499360 4089040
17:12:08 5787 8192000000 10801183024 11239780352 1899681744 18.824 100 17 34 2 1910496016 6114880 4699392
17:12:22 9037 8192000000 10834623024 11260182528 1902680368 18.848 100 21 44 3 1914171536 5381024 6110144
17:12:40 59346 8192000000 10831910768 11260317696 1909999152 18.907 100 25 50 3 1923226080 5067312 8159616
17:13:52 15843 8192000000 10829464016 11264917504 1909072608 18.899 100 26 53 0 1921101088 5064016 6964464
17:14:14 10955 8192000000 10832723696 11266355200 1911440064 18.918 100 28 57 1 1925739424 6471792 7827568
17:14:31 11548 8192000000 10824157728 11263856640 1911036688 18.915 100 19 38 0 1923120032 6170496 5912848
17:14:51 5335 8192000000 10827667136 11266166784 1915302496 18.949 100 29 55 1 1931014720 6654576 9057648
17:15:05 7759 8192000000 10818731952 11263856640 1912275152 18.925 100 19 38 0 1923181152 5620976 5285024
17:15:20 6000 8192000000 10815762000 11253895168 1906235760 18.876 100 27 55 2 1920538080 6402320 7900000
17:15:34 5933 8192000000 10820020928 11257556992 1904325488 18.861 100 24 47 1 1916554336 5315456 6913392
17:15:46 7805 8192000000 10832101968 11262152704 1909960960 18.906 100 26 51 1 1923884000 5158368 8764672
17:16:02 7426 8192000000 10809665520 11243454464 1871226368 18.594 98 27 54 1 1885845120 6500144 8118608
17:16:17 5889 8192000000 10811372256 11240902656 1866094928 18.553 98 27 53 3 1880691968 6452592 8144448
17:16:31 10845 8192000000 10812946000 11248754688 1896519904 18.798 100 14 28 3 1906608320 5346912 4741504
17:16:49 11072 8192000000 10799609328 11236483072 1844725072 18.379 97 16 32 0 1854851552 5322992 4803488
17:17:06 9588 8192000000 10753561056 11180400640 1722807856 17.376 91 19 38 1 1737694176 9114496 5771824
17:17:25 48851 8192000000 10751360480 11172048896 1769927888 17.766 96 19 38 1 1780378784 4910576 5540320
17:18:32 20976 8192000000 10690519120 11113562112 1679193328 17.011 91 14 28 2 1688560512 4684240 4682944
17:18:59 5495 8192000000 10699019808 11116425216 1774067008 17.801 99 31 62 2 1789519200 6702928 8749264
17:19:13 3902 8192000000 10725931392 11132231680 1779581920 17.846 98 31 60 0 1794700240 6574992 8543328
17:19:23 5823 8192000000 10732249472 11152478208 1794211952 17.966 99 32 64 2 1810331936 7240592 8879392
17:19:35 5115 8192000000 10723579120 11126575104 1754527616 17.639 97 34 68 0 1770460576 6287744 9645216
17:19:47 5161 8192000000 10729904384 11150618624 1809119296 18.089 100 35 71 2 1830294688 11335680 9839712
17:19:58 9350 8192000000 10714198928 11135373312 1747344976 17.580 96 28 56 1 1761656384 5616672 8694736
17:20:13 5613 8192000000 10712443984 11127554048 1769302688 17.761 98 36 71 1 1784645168 4528320 10814160
17:20:25 6297 8192000000 10714476256 11135430656 1786942784 17.907 99 36 72 1 1804529248 6972672 10613792
17:20:38 7954 8192000000 10708106624 11125571584 1742340784 17.538 96 25 50 1 1755805808 5383552 8081472
17:20:55 3562 8192000000 10698952992 11109605376 1754249504 17.637 98 34 68 0 1770883104 6910944 9722656
17:21:05 7212 8192000000 10716688208 11121438720 1750220992 17.603 97 40 81 2 1767309872 5518288 11570592
17:21:21 11443 8192000000 10713935248 11126992896 1785605344 17.896 99 24 48 0 1798755152 5273552 7876256
17:21:38 8497 8192000000 10736956336 11153772544 1802751968 18.036 99 25 49 3 1815302688 5672336 6878384
17:21:55 10217 8192000000 10724634416 11150192640 1769688096 17.764 97 24 48 1 1786634080 9937728 7008256
17:22:12 21749 8192000000 10727124016 11157295104 1787210224 17.909 98 32 63 0 1802257248 5959056 9087968
17:23:06 32079 8192000000 10741583520 11170308096 1831293632 18.270 100 27 53 2 1845254688 6509472 7451584
17:23:44 8607 8192000000 10762840192 11181858816 1844799744 18.380 100 23 46 3 1857333328 5764224 6769360
17:23:59 8245 8192000000 10757282192 11185758208 1847424752 18.401 100 33 67 1 1863326176 6441216 9460208
17:24:16 5951 8192000000 10774291840 11194109952 1852835200 18.445 100 48 95 2 1873827744 8083072 12909472
17:24:29 8577 8192000000 10768216288 11192528896 1852963312 18.446 100 30 60 0 1868669312 7306512 8399488
17:24:45 7276 8192000000 10770804960 11193487360 1854595840 18.459 100 22 42 2 1866130064 5540272 5993952
17:24:58 10997 8192000000 10769267136 11197091840 1854458048 18.458 100 20 40 0 1866715616 5914272 6343296
17:25:17 7027 8192000000 10770413344 11199414272 1857452576 18.483 100 31 63 1 1873588464 7243744 8892144
17:25:31 7123 8192000000 10769147136 11195392000 1855307904 18.465 100 20 40 1 1866597424 5520096 5769424
17:25:45 10578 8192000000 10763206752 11200081920 1857535072 18.483 100 18 35 0 1867709488 5117120 5057296
17:26:02 8508 8192000000 10775535920 11203792896 1859624000 18.500 100 24 48 1 1872621184 5980944 7016240
17:26:16 10203 8192000000 10769447632 11207368704 1860893408 18.511 100 17 34 0 1870972432 5561584 4517440
17:26:33 10607 8192000000 10779951056 11213303808 1865733808 18.550 100 17 34 0 1876218352 5464704 5019840
17:26:58 35449 8192000000 10808341808 11230326784 1878807728 18.655 100 28 56 0 1892262416 4314384 9140304
17:27:57 13814 8192000000 10834654576 11251011584 1898997536 18.818 100 43 86 1 1919186480 8329056 11859888
17:28:17 68001 8192000000 10833920960 11259666432 1892613440 18.767 99 42 84 3 1913754640 8771088 12370112
17:29:33 46685 8192000000 10858450288 11285688320 1918005264 18.971 100 52 104 0 1943785504 11277856 14502384
17:30:32 24796 8192000000 10860334400 11293908992 1931848624 19.082 100 44 87 0 1957836352 13386144 12601584
17:31:04 16972 8192000000 10883817792 11310022656 1944898560 19.186 100 54 107 3 1974906352 14311984 15695808
17:31:30 17328 8192000000 10896597632 11320623104 1950510032 19.231 100 46 90 2 1978947600 15123200 13314368
17:31:54 9933 8192000000 10906542784 11331375104 1959623520 19.303 100 56 110 2 1993857600 17131280 17102800
17:32:18 24636 8192000000 10903884912 11341533184 1965749216 19.352 100 47 92 0 1998792432 19553664 13489552
17:33:03 17060 8192000000 10913377712 11349180416 1973067376 19.410 100 35 68 2 2005308752 21657248 10584128
17:33:28 6261 8192000000 10915149328 11341910016 1956718128 19.280 99 53 105 2 1994838832 22134240 15986464
17:33:44 19550 8192000000 10918433104 11348791296 1956135984 19.275 99 54 107 1 1997982752 25411120 16435648
17:34:13 26625 8192000000 10925860496 11361095680 1977933232 19.448 100 47 94 2 2019272704 26525232 14814240
17:34:52 11936 8192000000 10927894976 11360186368 1976623712 19.438 100 39 77 2 2015047040 26670064 11753264
17:35:14 5029 8192000000 10932068080 11361357824 1980642704 19.470 100 45 89 0 2022022560 27158656 14221200
17:35:28 9357 8192000000 10939031360 11369951232 1989167600 19.537 100 60 120 0 2036448464 29051296 18229568
17:35:46 9606 8192000000 10918956672 11347943424 1948339344 19.213 98 57 114 1 1995799520 29552192 17907984
17:36:06 8927 8192000000 10937759088 11359932416 1965115168 19.347 99 59 116 1 2013252096 30635120 17501808
17:36:27 4197 8192000000 10942716272 11365335040 1964769344 19.344 99 60 121 0 2013928208 31373488 17785376
17:36:40 5351 8192000000 10952553776 11376295936 1989483696 19.540 100 61 120 1 2039594896 31379712 18731488
17:36:57 6279 8192000000 10952603760 11372752896 1987623008 19.525 100 56 110 0 2037795344 33199168 16973168
17:37:13 3656 8192000000 10962819008 11387256832 1996949984 19.599 100 64 124 2 2050726784 34605808 19170992
17:37:24 8251 8192000000 10976172832 11396444160 2004334048 19.657 100 78 155 0 2063061488 35597120 23130320
17:37:43 11037 8192000000 10962226304 11388510208 1985745392 19.510 99 55 110 0 2038408816 35761456 16901968
17:38:02 3770 8192000000 10984263744 11402498048 2008809232 19.692 100 71 141 1 2069366016 39011168 21545616
17:38:14 7215 8192000000 10982362928 11409485824 2011201360 19.711 100 69 138 0 2071531296 39723104 20606832
17:38:32 7968 8192000000 10987657856 11406774272 2005688912 19.668 100 71 143 0 2067636192 40628144 21319136
17:39:00 3049 8192000000 10990212560 11408928768 2013739392 19.731 100 86 167 2 2082788032 43620592 25428048
17:39:11 10569 8192000000 10988275440 11410915328 1996704288 19.597 99 71 142 1 2064592416 45280688 22607440
17:39:41 2029 8192000000 10976448672 11395940352 1976445872 19.437 98 70 136 3 2043514688 45474656 21594160
17:39:52 5531 8192000000 10997892880 11417485312 2009094032 19.694 100 75 150 1 2080750032 47698432 23957568
17:40:06 2457 8192000000 10987709568 11398623232 1994610960 19.580 100 77 154 1 2067154896 48405104 24138832
17:40:16 2678 8192000000 10985338384 11398242304 1983746480 19.494 99 84 168 1 2058708480 49233680 25728320
17:40:26 1165 8192000000 10957488064 11357241344 1931512416 19.079 98 93 185 1 2009822000 50055824 28253760
17:40:37 6651 8192000000 10956538064 11364179968 1964917264 19.345 100 81 162 5 2039912736 49317792 25677680
17:40:52 3009 8192000000 10949018160 11359653888 1955902240 19.273 100 78 155 3 2031517056 50861584 24753232
17:41:04 5969 8192000000 10959925648 11371577344 1968046384 19.370 100 73 146 0 2043866288 52788608 23031296
17:41:20 6215 8192000000 10907905600 11317809152 1885256720 18.708 96 70 140 0 1960657168 53098656 22301792
17:41:35 3488 8192000000 10957964960 11363078144 1952568320 19.247 100 87 175 1 2038540928 57894256 28078352
17:41:46 2943 8192000000 10933863296 11340451840 1932014400 19.083 99 73 144 1 2014510096 59028704 23466992
17:41:55 4429 8192000000 10950445776 11365593088 1952033760 19.243 100 75 149 1 2033273504 57674448 23565296
17:42:08 5142 8192000000 10960289856 11376783360 1962578160 19.327 100 75 150 2 2045649264 58525056 24546048
17:42:23 3517 8192000000 10962030880 11370811392 1961573440 19.319 100 79 158 1 2042163872 55577520 25012912
17:42:34 2201 8192000000 10967995056 11377065984 1968179408 19.371 100 91 178 1 2054480624 58029232 28271984
17:42:43 2056 8192000000 10977567584 11382341632 1970875920 19.392 100 86 173 0 2053866352 56043280 26947152
17:42:53 9737 8192000000 10978421120 11391401984 1974315168 19.420 100 80 161 3 2056933200 57950128 24667904
17:43:12 3520 8192000000 10969541520 11388780544 1953158768 19.252 99 72 141 2 2034571136 59372512 22039856
17:43:26 2633 8192000000 10966953600 11379892224 1963765488 19.336 100 76 152 1 2047718368 60160672 23792208
17:43:35 1913 8192000000 10980680784 11385888768 1966646864 19.359 100 93 182 0 2058104800 62072784 29385152
17:43:45 6058 8192000000 10969748592 11390115840 1969625568 19.382 100 75 150 2 2054894640 60677952 24591120
17:44:01 2703 8192000000 10979226096 11391115264 1977686656 19.446 100 89 178 3 2061352544 56006224 27659664
17:44:10 1720 8192000000 10965976576 11378663424 1970490256 19.389 100 83 162 0 2048547360 52822352 25234752
17:44:20 1797 8192000000 10973920048 11390148608 1976636432 19.438 100 88 176 4 2058674880 53978512 28059936
17:44:29 4028 8192000000 10954633440 11378987008 1965632368 19.351 100 68 136 1 2043088304 55730640 21725296
17:44:52 11811 8192000000 10934694352 11368120320 1953460880 19.254 100 35 70 0 2019572864 53810800 12301184
17:45:14 5047 8192000000 10970769440 11390423040 1968535072 19.374 100 59 118 4 2042801584 55477072 18789440
17:45:26 2333 8192000000 10975654800 11390824448 1972890016 19.408 100 86 172 0 2058129152 57748864 27490272
17:45:35 2613 8192000000 10960113008 11373211648 1955446272 19.270 99 71 140 2 2035332608 57815248 22071088
17:45:48 2109 8192000000 10947793136 11380752384 1961404192 19.317 100 61 120 1 2036516640 54915344 20197104
17:46:00 11933 8192000000 10951046784 11381157888 1948016624 19.211 99 47 94 3 2017640128 54037312 15586192
17:46:19 6399 8192000000 10950859696 11368497152 1925428096 19.030 98 58 109 1 2000846160 57809648 17608416
17:46:35 4407 8192000000 10952241008 11375005696 1951490528 19.238 100 70 140 1 2035533920 61454224 22589168
17:46:49 2806 8192000000 10966516736 11380920320 1965348400 19.349 100 90 178 1 2051017648 56428016 29241232
17:47:01 14888 8192000000 10945745696 11379052544 1956785296 19.280 100 48 96 1 2030469376 57382128 16301952
17:47:24 5008 8192000000 10966492592 11391234048 1947649216 19.208 99 58 114 1 2026001760 59255744 19096800
17:47:35 3831 8192000000 10965780768 11392815104 1969046912 19.378 100 65 131 1 2049825072 59546592 21231568
17:47:47 5915 8192000000 10966822576 11396771840 1968311504 19.372 100 57 113 3 2046753776 60079072 18363200
17:48:02 6287 8192000000 10955936304 11395563520 1953581104 19.255 99 50 100 2 2031556432 60913776 17061552
17:48:16 2413 8192000000 10949255712 11383189504 1963131520 19.331 100 50 100 0 2039214688 58228288 17854880
17:48:30 17826 8192000000 10931635920 11392614400 1960931168 19.313 100 38 76 0 2034100000 59606000 13562832
17:48:55 19110 8192000000 10935685168 11381166080 1944528240 19.183 99 32 64 0 2007360208 52130736 10701232
17:49:39 19687 8192000000 10929250272 11391422464 1962783328 19.328 100 27 53 1 2025816784 53919984 9113472
17:50:09 26782 8192000000 10924265776 11381223424 1956493056 19.278 100 17 34 2 2005061024 42139600 6428368
17:50:43 25123 8192000000 10912501696 11388952576 1958022672 19.290 100 19 38 1 2005001712 40533248 6445792
17:51:22 45687 8192000000 10911889488 11363639296 1911902928 18.922 98 17 34 0 1954211984 36127568 6181488
17:52:14 43037 8192000000 10870437904 11342688256 1890045040 18.746 97 16 32 2 1937919488 42386192 5488256
17:53:03 72147 8192000000 10900068512 11343147008 1935799552 19.113 99 42 84 1 1957290832 9274512 12216768
17:54:30 60052 8192000000 10892101360 11333664768 1915602192 18.952 98 36 72 1 1933689264 6844752 11242320
17:55:41 25753 8192000000 10894080896 11344551936 1943448704 19.174 99 60 121 2 1969305504 8991872 16864928
17:56:17 72109 8192000000 10885055088 11348561920 1955349168 19.269 100 24 48 1 1973275952 11038640 6888144
17:57:36 19802 8192000000 10876506864 11329597440 1901522640 18.839 97 24 50 2 1916788800 8364208 6901952
17:58:13 14701 8192000000 10896614560 11346898944 1958944880 19.298 100 24 46 1 1973854496 8662544 6247072
17:58:49 18896 8192000000 10916533312 11355111424 1965138048 19.347 100 39 78 1 1986664560 10176560 11349952
17:59:24 43985 8192000000 10899642464 11361538048 1955254144 19.268 99 31 62 0 1979954848 15108560 9592144
18:00:14 40999 8192000000 10894447648 11370356736 1969756480 19.384 100 10 20 0 1991538192 19400240 2381472
18:01:03 25463 8192000000 10878623248 11349819392 1913377936 18.934 97 10 20 1 1937966272 22123552 2464784
18:01:35 13430 8192000000 10892520752 11363151872 1958072960 19.291 100 11 22 1 1978786512 18093696 2619856
18:02:40 20215 8192000000 10901562880 11360870400 1971515024 19.397 100 15 30 0 1988904512 13400928 3988560
18:03:07 53839 8192000000 10900485568 11369951232 1980470768 19.468 100 18 36 1 2001043120 15355648 5216704
18:04:38 65608 8192000000 10895454624 11358924800 1958800048 19.297 99 19 38 1 1983917984 17878864 7239072
18:06:02 26014 8192000000 10903141808 11388956672 1974655744 19.422 100 17 34 2 1996866080 16343616 5866720
18:07:23 131536 8192000000 10907200816 11368284160 1945766480 19.193 98 17 34 0 1971531440 20724832 5040128
18:09:42 28194 8192000000 10928153008 11371196416 1964332496 19.340 99 37 74 0 1982895776 8173760 10389520
18:10:21 82854 8192000000 10862628032 11335282688 1860019136 18.503 94 19 38 0 1874843136 9805600 5018400
18:11:50 29200 8192000000 10890634720 11344822272 1941554672 19.159 99 13 26 1 1952734736 7695280 3484784
18:12:36 33832 8192000000 10901916224 11352809472 1961002000 19.314 100 34 68 2 1981083424 10569424 9512000
18:13:17 98449 8192000000 10901997872 11362549760 1950710464 19.232 99 15 30 0 1966764560 11765216 4288880
18:15:12 33361 8192000000 10923854480 11371745280 1960798320 19.312 99 28 56 0 1977996800 9273376 7925104
18:15:59 34250 8192000000 10899847552 11354517504 1940378160 19.150 98 27 54 0 1957036496 9427296 7231040
18:16:46 36573 8192000000 10887360832 11338936320 1914017920 18.939 97 30 60 0 1937090800 14648336 8424544
18:17:37 54101 8192000000 10901486352 11354222592 1920238032 18.989 98 24 48 2 1949509440 22857536 6413872
18:18:41 73664 8192000000 10879377104 11362369536 1894933040 18.786 97 8 16 0 1919114368 22115760 2065568
18:20:03 40082 8192000000 10892344304 11340496896 1925892000 19.034 98 36 72 1 1949621728 12733936 10995792
18:21:51 41399 8192000000 10888483264 11329404928 1921569936 18.999 98 60 120 3 1950921200 10757968 18593296
18:22:38 118124 8192000000 10861755088 11336003584 1896013504 18.794 97 20 40 1 1922207584 20516448 5677632
18:24:46 23768 8192000000 10873302672 11315027968 1910210896 18.908 99 18 36 1 1928342848 13072016 5059936
18:25:26 54146 8192000000 10821471952 11285815296 1866384896 18.555 97 14 28 0 1878335424 8036800 3913728
18:26:39 41697 8192000000 10811864768 11272220672 1859984400 18.503 98 14 28 1 1871435536 8060960 3390176
18:27:30 29931 8192000000 10839751376 11301818368 1916917824 18.962 100 19 37 1 1927701648 6116432 4667392
18:28:06 72915 8192000000 10855990560 11327655936 1920887280 18.994 99 13 26 1 1933692384 9195792 3609312
18:29:25 35763 8192000000 10868942032 11334291456 1947028032 19.203 100 12 24 0 1959455120 8836656 3590432
18:31:38 60761 8192000000 10879344512 11344957440 1859793744 18.502 95 21 40 1 1881263568 15330688 6139136
18:32:46 49248 8192000000 10878793504 11340382208 1914861632 18.946 98 15 30 2 1936015712 16699040 4455040
18:33:57 80991 8192000000 10879247200 11350667264 1897744704 18.808 97 17 34 2 1922819744 20480240 4594800
18:35:44 43952 8192000000 10880842800 11344576512 1926678336 19.040 99 21 42 1 1949055824 16464480 5913008
18:36:34 54513 8192000000 10903961360 11343843328 1924030048 19.019 99 37 73 1 1955150960 19866016 11254896
18:37:36 65071 8192000000 10891163568 11350241280 1924815440 19.025 99 28 56 0 1949336464 16779728 7741296
18:38:49 51594 8192000000 10873991728 11328360448 1886744784 18.720 97 16 32 0 1911707984 20109680 4853520
18:39:47 71907 8192000000 10877589872 11336548352 1879801152 18.664 97 26 52 0 1901865408 14927168 7137088
18:41:06 63435 8192000000 10899611584 11352903680 1937014992 19.123 99 29 58 0 1956620448 11542016 8063440
18:42:30 46720 8192000000 10898651664 11371347968 1960379200 19.309 100 30 60 0 1984902224 16460144 8062880
18:43:23 78710 8192000000 10910394208 11342360576 1882672224 18.687 96 22 44 3 1899847088 11164576 6010288
18:44:54 53584 8192000000 10888297552 11331932160 1876008448 18.633 96 29 58 1 1895563520 11624848 7930224
18:45:58 35141 8192000000 10890856064 11328880640 1931893088 19.082 99 43 86 0 1955586736 11430528 12263120
18:46:40 114233 8192000000 10871252880 11339730944 1929415728 19.062 99 37 74 3 1949240432 9118800 10705904
18:48:44 57105 8192000000 10849267024 11324362752 1903497008 18.854 98 15 30 0 1920719568 12681616 4540944
18:49:47 1536 8192000000 10873206336 11330895872 1938102384 19.132 100 38 75 1 1961944992 13479920 10362688
18:49:54 27442 8192000000 10879517456 11331215360 1915327776 18.949 98 37 74 2 1940143520 14421680 10394064
18:50:36 68120 8192000000 10857855568 11335753728 1925987344 19.035 99 26 52 0 1946816224 13401360 7427520
18:52:05 47233 8192000000 10839223936 11317571584 1907585856 18.887 98 8 16 3 1919958128 10044704 2327568
18:53:07 30137 8192000000 10863316000 11340922880 1936174352 19.116 100 16 32 0 1953899776 12827232 4898192
18:53:45 82992 8192000000 10880498336 11353997312 1952576704 19.247 100 16 31 2 1970510672 13291264 4642704
18:55:17 50652 8192000000 10871337088 11339325440 1923770448 19.017 98 14 28 0 1941245696 13345408 4129840
18:56:19 62851 8192000000 10883841264 11363311616 1933034448 19.091 99 6 12 0 1952940736 18235072 1671216
18:57:30 86205 8192000000 10901448944 11374575616 1966530048 19.358 100 17 35 1 1980981456 9962448 4488960
18:59:15 69073 8192000000 10924771808 11386413056 1988704800 19.534 100 15 30 0 2003938784 11315296 3918688
19:00:48 31152 8192000000 10952009952 11403321344 2004240352 19.656 100 49 98 2 2030692016 11780224 14671440
19:01:25 61944 8192000000 10922268112 11407163392 1977644432 19.446 99 22 44 2 1999113648 14581184 6888032
19:02:34 68128 8192000000 10930839488 11379773440 1945990080 19.195 98 14 28 0 1966623968 16147984 4485904
19:04:03 36165 8192000000 10908720384 11378655232 1979798928 19.463 100 21 42 1 1996115008 10474048 5842032
19:04:47 125678 8192000000 10897439008 11359141888 1865327200 18.546 94 13 26 0 1879765904 11095680 3343024
19:07:02 37269 8192000000 10914593856 11361665024 1936311280 19.117 98 31 62 0 1954769184 10222352 8235552
19:07:53 120487 8192000000 10898131168 11365330944 1893476016 18.774 96 26 52 1 1918199920 17541568 7182336
19:10:00 60904 8192000000 10901266880 11356237824 1922998176 19.011 98 17 34 1 1938539904 10684352 4857376
19:11:11 110804 8192000000 10828560512 11270160384 1837284320 18.319 94 20 40 1 1852794176 9708512 5801344
19:13:10 66357 8192000000 10890441568 11355557888 1955963056 19.274 100 18 36 1 1971452000 10608448 4880496
19:15:03 58605 8192000000 10870616528 11340607488 1918813328 18.977 98 14 25 1 1935607104 13162016 3631760
19:16:08 74223 8192000000 10873177232 11348045824 1938872256 19.138 99 12 24 0 1954697440 11975008 3850176
19:17:29 37792 8192000000 10876308352 11349336064 1947259264 19.205 100 14 29 0 1966967648 14789408 4918976
19:18:13 64025 8192000000 10895396176 11359883264 1963201184 19.331 100 15 30 2 1980266992 12641888 4423920
19:19:30 126111 8192000000 10854101888 11321479168 1850947776 18.430 94 19 39 0 1869450912 12924912 5578224
19:21:42 46246 8192000000 10863965792 11329257472 1927771920 19.049 100 12 24 2 1946882400 15486480 3624000
19:22:49 91552 8192000000 10850275360 11314475008 1826440016 18.230 94 18 36 0 1853424016 21830784 5153216
19:24:42 47292 8192000000 10871797584 11320033280 1900134528 18.827 98 36 72 0 1926175056 15332192 10708336
19:26:00 85818 8192000000 9103867984 9326391296 259834256 3.074 14 5 9 1 268105216 7167104 1103856

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 26-01-2021 19:28:39 to 26-01-2021 19:29:10.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 117 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

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

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          238198
MON$OLDEST_ACTIVE               238604
MON$OLDEST_SNAPSHOT             238604
MON$NEXT_TRANSACTION            238604
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                       2029088
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 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 ---
:19: 
:20: mscs-test-161.budzdorov.ru    Tue Jan 26 19:27:35 2021
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
:23: 
:24: mscs-test-161.budzdorov.ru    Tue Jan 26 19:27:35 2021
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
--- end of diff output ---

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

26.01.21 19:29:14. 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-26 19:29:16 No severe PSQL-related problems occured
26.01.21 19:29:18. End of report.