Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.01.2021 22: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 17338100 kB
MemAvailable 31379612 kB
Buffers 0 kB
Cached 14326032 kB
SwapCached 4864 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-03 22:27:07
DTS_END                         2021-01-03 22:27:07.6160
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/56410
TRN_ID                          244920
ATT_ID                          725
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: 9359.23 20983 1123107
customer order: creation 178.47 385 21416
customer order: refuse 14.89 369 1787
order to supplier: creation 47.28 1228 5673
order to supplier: removal 3.49 108483 419
invoice (draft): creation 48.25 3099 5790
invoice (draft): removal 51.62 848 6194
invoice accept: apply 43.51 17330 5221
invoice accept: cancel 46.33 842 5560
customer reserve: creation 4071.71 168 488605
customer reserve: removal 4553.97 66 546476
realization accept: apply 86.74 186 10409
realization accept: cancel 80.52 112 9662
payment from customer: creation 60.62 101 7274
payment from customer: removal 5.80 98 696
payment to supplier: creation 49.88 136 5985
payment to supplier: removal 3.65 96 438
service: total inventory turnovers 4.72 1296 566
service: total monetary turnovers 6.82 45 818
service: aggregate perf. data 0.95 20174 114
service: refresh index statistics 0.03 264589 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 03-01-2021 22:28:11 to 03-01-2021 22:28:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5306
TEST_TIME 2 6330
TEST_TIME 3 6251
TEST_TIME 4 6062
TEST_TIME 5 5606
TEST_TIME 6 6023
TEST_TIME 7 6243
TEST_TIME 8 6346
TEST_TIME 9 6085
TEST_TIME 10 5984
TEST_TIME 11 6421
TEST_TIME 12 6458
TEST_TIME 13 6697
TEST_TIME 14 7281
TEST_TIME 15 7459
TEST_TIME 16 7577
TEST_TIME 17 8051
TEST_TIME 18 8114
TEST_TIME 19 8164
TEST_TIME 20 8573
TEST_TIME 21 8958
TEST_TIME 22 8994
TEST_TIME 23 9211
TEST_TIME 24 9417
TEST_TIME 25 9675
TEST_TIME 26 10161
TEST_TIME 27 11164
TEST_TIME 28 11622
TEST_TIME 29 11309
TEST_TIME 30 11122
TEST_TIME 31 11076
TEST_TIME 32 10973
TEST_TIME 33 10900
TEST_TIME 34 11023
TEST_TIME 35 10776
TEST_TIME 36 10729
TEST_TIME 37 10596
TEST_TIME 38 10659
TEST_TIME 39 10718
TEST_TIME 40 10521
TEST_TIME 41 10448
TEST_TIME 42 10400
TEST_TIME 43 10245
TEST_TIME 44 10126
TEST_TIME 45 10085
TEST_TIME 46 9989
TEST_TIME 47 9986
TEST_TIME 48 9863
TEST_TIME 49 9813
TEST_TIME 50 9801
TEST_TIME 51 9771
TEST_TIME 52 9765
TEST_TIME 53 9752
TEST_TIME 54 9746
TEST_TIME 55 9794
TEST_TIME 56 9771
TEST_TIME 57 9793
TEST_TIME 58 9937
TEST_TIME 59 9934
TEST_TIME 60 9964
TEST_TIME 61 9983
TEST_TIME 62 9950
TEST_TIME 63 9954
TEST_TIME 64 9922
TEST_TIME 65 9878
TEST_TIME 66 9816
TEST_TIME 67 9715
TEST_TIME 68 9673
TEST_TIME 69 9650
TEST_TIME 70 9575
TEST_TIME 71 9554
TEST_TIME 72 9544
TEST_TIME 73 9535
TEST_TIME 74 9496
TEST_TIME 75 9486
TEST_TIME 76 9444
TEST_TIME 77 9462
TEST_TIME 78 9541
TEST_TIME 79 9556
TEST_TIME 80 9595
TEST_TIME 81 9546
TEST_TIME 82 9607
TEST_TIME 83 9614
TEST_TIME 84 9594
TEST_TIME 85 9650
TEST_TIME 86 9641
TEST_TIME 87 9564
TEST_TIME 88 9508
TEST_TIME 89 9532
TEST_TIME 90 9503
TEST_TIME 91 9436
TEST_TIME 92 9395
TEST_TIME 93 9369
TEST_TIME 94 9481
TEST_TIME 95 9467
TEST_TIME 96 9464
TEST_TIME 97 9497
TEST_TIME 98 9526
TEST_TIME 99 9502
TEST_TIME 100 9534
TEST_TIME 101 9543
TEST_TIME 102 9527
TEST_TIME 103 9548
TEST_TIME 104 9608
TEST_TIME 105 9601
TEST_TIME 106 9590
TEST_TIME 107 9575
TEST_TIME 108 9611
TEST_TIME 109 9533
TEST_TIME 110 9482
TEST_TIME 111 9485
TEST_TIME 112 9480
TEST_TIME 113 9439
TEST_TIME 114 9405
TEST_TIME 115 9396
TEST_TIME 116 9396
TEST_TIME 117 9399
TEST_TIME 118 9412
TEST_TIME 119 9439
TEST_TIME 120 9366

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 03-01-2021 22:28:15 to 03-01-2021 22:28:18.

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 1574588 1574588 0 0.00 0 12147 6 0 0
doc_list_biud 1574588 1574588 0 0.00 0 42791 29 0 0
sp_add_invoice_to_stock 5305 5221 84 1.58 26 159542 17331 0 84
sp_cancel_adding_invoice 5560 5560 0 0.00 4 59590 843 0 0
sp_cancel_client_order 1787 1787 0 0.00 4 22767 370 0 0
sp_cancel_customer_reserve 546476 546476 0 0.00 1 42795 66 0 0
sp_cancel_pay_from_customer 696 696 0 0.00 2 6765 98 0 0
sp_cancel_pay_to_supplier 438 438 0 0.00 3 7762 96 0 0
sp_cancel_supplier_invoice 6200 6194 6 0.09 1 29823 848 0 6
sp_cancel_supplier_order 419 419 0 0.00 5 1162799 108483 0 0
sp_cancel_write_off 9662 9662 0 0.00 1 7232 113 0 0
sp_client_order 21416 21416 0 0.00 4 40684 386 0 0
sp_customer_reserve 488605 488605 0 0.00 0 54925 168 0 0
sp_fill_shopping_cart 32860 32860 0 0.00 1 27179 37 0 0
sp_fill_shopping_cart_clo_res 488597 488597 0 0.00 0 26075 14 0 0
sp_get_clo_for_invoice 5210 5210 0 0.00 0 31384 309 0 0
sp_kill_cost_storno 16356 16356 0 0.00 0 8726 61 0 0
sp_kill_qstorno_ret_qs2qd 1109227 1109227 0 0.00 0 42786 36 0 0
sp_kill_qty_storno 585717 585717 0 0.00 0 42790 76 0 0
sp_lock_selected_doc 21649 21649 0 0.00 0 7542 6 0 0
sp_make_cost_storno 28878 28878 0 0.00 0 12132 52 0 0
sp_multiply_rows_for_pdistr 28878 28878 0 0.00 0 9200 30 0 0
sp_multiply_rows_for_qdistr 21416 21416 0 0.00 0 19245 183 0 0
sp_pay_from_customer 7274 7274 0 0.00 4 13194 101 0 0
sp_pay_to_supplier 5985 5985 0 0.00 5 15242 137 0 0
sp_payment_common 13259 13259 0 0.00 1 15084 28 0 0
sp_qd_handle_on_cancel_clo 1787 1787 0 0.00 0 22759 328 0 0
sp_qd_handle_on_invoice_upd_sts 10770 10770 0 0.00 0 33078 337 0 0
sp_qd_handle_on_reserve_upd_sts 10409 10409 0 0.00 0 24898 63 0 0
sp_reserve_write_off 10409 10409 0 0.00 6 25067 186 0 0
sp_supplier_invoice 5790 5790 0 0.00 6 84371 3100 0 0
sp_supplier_order 5673 5673 0 0.00 4 45954 1228 0 0
srv_aggregate_perf_data 114 114 0 0.00 2927 366202 20175 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1043 140362 31498 0 0
srv_find_qd_qs_mism 1072965 1072965 0 0.00 0 10913 5 0 0
srv_make_invnt_saldo 566 566 0 0.00 20 85085 1297 0 0
srv_make_money_saldo 818 818 0 0.00 1 11486 46 0 0
srv_recalc_idx_stat 4 4 0 0.00 147250 398704 264590 0 0
t$perf-abend:sp_add_invoice_to_stock 84 84 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5221 5221 0 0.00 0 8423 151 0 0
t$perf-norm:sp_cancel_adding_invoice 424 424 0 0.00 0 4085 84 0 0
t$perf-norm:sp_cancel_client_order 1787 1787 0 0.00 0 4984 13 0 0
t$perf-norm:sp_cancel_customer_reserve 754 754 0 0.00 0 1877 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 696 696 0 0.00 0 1234 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 438 438 0 0.00 0 2847 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 446 446 0 0.00 0 468 11 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 20470 1556 0 0
t$perf-norm:sp_cancel_write_off 1066 1066 0 0.00 0 2840 8 0 0
t$perf-norm:sp_client_order 21416 21416 0 0.00 0 7739 17 0 0
t$perf-norm:sp_customer_reserve 1033 1033 0 0.00 0 2275 7 0 0
t$perf-norm:sp_pay_from_customer 7274 7274 0 0.00 0 7805 11 0 0
t$perf-norm:sp_pay_to_supplier 5985 5985 0 0.00 0 9160 12 0 0
t$perf-norm:sp_reserve_write_off 10409 10409 0 0.00 0 8151 12 0 0
t$perf-norm:sp_supplier_invoice 5790 5790 0 0.00 0 3192 16 0 0
t$perf-norm:sp_supplier_order 5673 5673 0 0.00 0 6331 16 0 0
t$perf-norm:srv_aggregate_perf_data 114 114 0 0.00 0 224 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 292 4 0 0
t$perf-norm:srv_make_invnt_saldo 566 566 0 0.00 0 1783 23 0 0
t$perf-norm:srv_make_money_saldo 818 818 0 0.00 0 959 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10588 10420 168 1.58 0 16654 21 0 168
v_all_customers 39110 39110 0 0.00 0 30 1 0 0
v_all_suppliers 31684 31684 0 0.00 0 149 1 0 0
v_all_wares 42832 42832 0 0.00 0 194 1 0 0
v_cancel_adding_invoice 848 848 0 0.00 0 1790 11 0 0
v_cancel_client_order 3574 3574 0 0.00 0 7539 8 0 0
v_cancel_customer_prepayment 1392 1392 0 0.00 0 6578 13 0 0
v_cancel_customer_reserve 1508 1508 0 0.00 0 974 4 0 0
v_cancel_payment_to_supplier 876 876 0 0.00 0 6456 18 0 0
v_cancel_supplier_invoice 904 892 12 1.32 0 7343 28 0 12
v_cancel_supplier_order 838 838 0 0.00 0 587 5 0 0
v_cancel_write_off 2132 2132 0 0.00 0 4284 19 0 0
v_max_id_clo_ord 5672 5672 0 0.00 0 3285 2 0 0
v_max_id_clo_res 1033 1033 0 0.00 0 1619 14 0 0
v_max_id_ord_sup 5772 5772 0 0.00 0 6644 5 0 0
v_max_non_paid_invoice 1587 1587 0 0.00 0 500 2 0 0
v_max_non_paid_realizn 3892 3892 0 0.00 0 1811 4 0 0
v_min_id_clo_ord 5672 5672 0 0.00 0 3223 7 0 0
v_min_id_clo_res 1033 1033 0 0.00 0 4551 8 0 0
v_min_id_ord_sup 5772 5772 0 0.00 0 5321 8 0 0
v_min_non_paid_invoice 5985 5985 0 0.00 0 7542 16 0 0
v_min_non_paid_realizn 7274 7274 0 0.00 0 13185 16 0 0
v_our_firm 10486 10486 0 0.00 0 165 1 0 0
v_reserve_write_off 20818 20818 0 0.00 0 6707 6 0 0
x_lock_depdocs_on_canc_invoice 11308 11308 0 0.00 0 21639 127 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 17668 369 0 0
x_make_qstorno_1000_1200 5673 5673 0 0.00 2 45945 1145 0 0
x_make_qstorno_1200_2000 5790 5790 0 0.00 2 75062 2968 0 0
x_make_qstorno_2100_3300 488605 488605 0 0.00 0 54923 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-01-2021 22:28:19 to 03-01-2021 22:28:23.

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
19:57:11 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:18 12679 8192000000 10187476176 10483843072 843123120 9.331 68 52 105 0 863610384 2116704 18370560
19:57:39 22554 8192000000 10310906704 10626269184 1342808880 14.083 100 81 163 0 1373158800 4192576 26157344
19:58:09 37375 8192000000 10362015664 10683285504 1399650576 14.592 100 83 166 0 1433401968 6013808 27737584
19:59:02 24648 8192000000 10381019200 10711830528 1440058368 14.950 100 84 168 1 1475665344 7126400 28480576
19:59:35 28912 8192000000 10410946144 10738946048 1463804096 15.159 100 89 178 0 1500436848 7636656 28996096
20:00:14 16355 8192000000 10444749648 10774540288 1488144896 15.373 100 91 183 1 1526489568 8474880 29869792
20:00:41 13385 8192000000 10441417248 10777108480 1498126016 15.460 100 87 174 0 1535141904 8628384 28387504
20:01:02 18430 8192000000 10466095904 10803376128 1515689088 15.613 100 84 168 2 1551260304 9021200 26550016
20:01:31 12086 8192000000 10488630816 10834862080 1543834240 15.857 100 84 168 0 1579537392 9394768 26308384
20:01:52 12358 8192000000 10517106240 10869665792 1576356944 16.137 100 82 164 1 1615452384 14014832 25080608
20:02:16 11753 8192000000 10542291328 10898579456 1601674464 16.354 100 74 148 1 1633490816 9652240 22164112
20:02:38 16738 8192000000 10575727184 10938953728 1630385712 16.598 100 71 142 1 1662263472 10352272 21525488
20:03:03 13572 8192000000 10596804176 10960076800 1654168176 16.800 100 78 156 2 1688305808 10897584 23240048
20:03:25 9542 8192000000 10616320464 10984624128 1680990336 17.026 100 78 156 1 1714879488 11063248 22825904
20:03:42 4936 8192000000 10634084032 11003412480 1701546672 17.198 100 79 157 2 1735530288 11139968 22843648
20:03:54 7173 8192000000 10650518304 11018186752 1705386512 17.230 100 76 152 2 1739556288 11916880 22252896
20:04:10 11166 8192000000 10667409840 11039080448 1721248144 17.363 100 80 160 1 1758015632 13301280 23466208
20:04:29 6862 8192000000 10680904704 11056390144 1739934784 17.518 100 80 160 1 1775513200 12395104 23183312
20:04:43 7776 8192000000 10695409680 11072602112 1752856288 17.625 100 77 154 1 1788235328 13090384 22288656
20:04:58 6115 8192000000 10704563248 11082416128 1763207888 17.711 100 78 156 1 1797345648 12422320 21715440
20:05:12 4673 8192000000 10714941840 11096297472 1775667088 17.814 100 85 170 1 1812772816 12923968 24181760
20:05:25 4372 8192000000 10721999440 11102416896 1785110080 17.892 100 84 169 0 1822205296 13248336 23846880
20:05:36 3348 8192000000 10727991504 11110305792 1789988896 17.932 100 86 171 2 1827356688 13572608 23795184
20:05:45 3673 8192000000 10730353616 11115479040 1796197168 17.983 100 83 166 0 1833021984 13697744 23127072
20:05:56 3847 8192000000 10741864928 11127832576 1802841408 18.037 100 78 156 2 1837428640 13296880 21290352
20:06:07 3034 8192000000 10753125744 11139559424 1814872144 18.136 100 85 170 1 1851492272 12529776 24090352
20:06:17 2677 8192000000 10768397504 11151425536 1825153664 18.220 100 88 176 1 1862760592 13086352 24520576
20:06:26 8465 8192000000 10766014560 11154776064 1825250192 18.221 100 73 144 3 1857428640 12691648 19486800
20:06:43 3497 8192000000 10784620400 11172331520 1830966144 18.267 100 86 172 3 1868448640 13732592 23749904
20:06:53 2403 8192000000 10790824720 11177885696 1848188944 18.407 100 88 176 1 1886306128 12969264 25147920
20:07:02 2095 8192000000 10795557648 11183919104 1849256448 18.416 100 88 176 1 1888024656 13428608 25339600
20:07:10 1750 8192000000 10799811712 11188842496 1852677936 18.444 100 89 176 2 1889582800 12925312 23979552
20:07:18 2115 8192000000 10807299360 11194425344 1856146928 18.472 100 91 182 3 1896173616 14422080 25604608
20:07:27 2255 8192000000 10797232880 11188858880 1858353424 18.490 100 86 173 1 1895557792 13113904 24090464
20:07:35 1478 8192000000 10809580640 11198832640 1862360800 18.522 100 92 181 3 1902825840 14167888 26297152
20:07:43 1518 8192000000 10804728160 11195752448 1863644720 18.533 100 89 179 1 1902340736 12679296 26016720
20:07:51 1695 8192000000 10810416656 11201085440 1863947248 18.535 100 88 178 0 1902932560 14101040 24884272
20:07:59 6769 8192000000 10786563152 11199684608 1866514464 18.556 100 65 130 0 1897852880 13580960 17757456
20:08:20 1291 8192000000 10805274000 11206393856 1879321184 18.660 100 81 160 2 1912774176 11239504 22213488
20:08:29 3087 8192000000 10791382912 11201507328 1869671648 18.582 100 54 104 3 1895564368 11055520 14837200
20:08:38 4133 8192000000 10794616464 11206336512 1878392096 18.652 100 69 136 1 1908180896 10806880 18981920
20:08:52 6176 8192000000 10787142208 11207270400 1875401904 18.628 100 52 104 0 1898626336 8316400 14908032
20:09:06 5013 8192000000 10788554224 11208998912 1874299776 18.619 100 46 93 1 1894649920 7240272 13109872
20:09:20 4713 8192000000 10798705504 11215339520 1879434112 18.661 100 39 79 4 1898131424 8132336 10564976
20:09:31 4110 8192000000 10795089744 11215552512 1883282224 18.692 100 41 80 0 1901276560 6855248 11139088
20:09:41 6074 8192000000 10789527440 11219202048 1886738064 18.719 100 33 65 2 1903331712 7794176 8799472
20:09:54 7661 8192000000 10792808048 11222192128 1884802432 18.704 100 18 36 0 1896145552 6695344 4647776
20:10:19 6209 8192000000 10796822640 11224526848 1889096896 18.739 100 29 58 0 1904265216 7217392 7950928
20:10:36 15426 8192000000 10793326640 11225063424 1888822400 18.736 100 17 34 0 1900041408 6211824 5007184
20:11:00 4302 8192000000 10820846128 11236880384 1901859184 18.841 100 63 129 1 1927114912 6810384 18445344
20:11:11 69129 8192000000 10806245888 11240534016 1897953520 18.810 100 37 74 0 1914083456 5246672 10883264
20:12:26 10986 8192000000 10811964704 11242110976 1897355200 18.805 100 24 48 2 1914882096 10807376 6719520
20:12:48 5315 8192000000 10812774528 11247616000 1900512528 18.830 100 33 66 0 1917899568 8073712 9313328
20:13:01 5277 8192000000 10827936640 11252207616 1903163808 18.852 100 37 72 4 1921889136 6555216 12170112
20:13:14 5890 8192000000 10815566240 11251367936 1901483664 18.838 100 23 46 3 1914466944 6346640 6636640
20:13:35 6545 8192000000 10815190528 11249475584 1900993328 18.834 100 22 44 2 1912822736 5913232 5916176
20:13:47 9435 8192000000 10813590528 11253219328 1905668112 18.872 100 25 50 1 1919067312 5857456 7541744
20:14:04 7510 8192000000 10829450656 11260170240 1909083360 18.899 100 28 56 1 1923719408 7194704 7441344
20:14:19 5913 8192000000 10826922400 11260686336 1906370560 18.878 100 13 26 1 1916051360 6009904 3670896
20:14:31 7223 8192000000 10827375088 11265634304 1914803360 18.945 100 20 40 1 1926318720 6205744 5309616
20:14:44 6331 8192000000 10832199264 11268317184 1916063904 18.955 100 36 70 3 1933237152 5831552 11341696
20:14:57 10167 8192000000 10811601264 11245600768 1894427680 18.781 99 19 38 2 1905853152 6046848 5378624
20:15:18 8426 8192000000 10811246784 11246546944 1853916848 18.454 97 20 38 1 1864826736 5099920 5809968
20:15:32 13029 8192000000 10805620368 11244466176 1894609184 18.783 100 20 40 1 1907277456 6674768 5993504
20:15:52 15788 8192000000 10809342256 11241861120 1851534784 18.435 97 40 79 2 1873194192 10174256 11485152
20:16:53 26206 8192000000 10793602976 11229581312 1852590368 18.443 98 14 26 2 1861440496 5275648 3574480
20:17:28 7882 8192000000 10759201248 11185532928 1818142992 18.163 97 29 57 1 1831741456 5080320 8518144
20:17:42 7406 8192000000 10777769040 11213639680 1858275840 18.489 99 23 45 1 1871692880 6368512 7048528
20:17:55 3763 8192000000 10799043264 11222773760 1862475968 18.523 99 44 89 1 1883178720 7582336 13120416
20:18:07 6593 8192000000 10769637728 11195793408 1797266272 17.991 96 27 53 3 1810975552 6498672 7210608
20:18:22 9904 8192000000 10682332928 11103739904 1689143056 17.094 92 20 40 1 1700933744 5813712 5976976
20:18:38 5507 8192000000 10687569120 11103629312 1702489632 17.206 94 21 42 0 1713928816 5117200 6321984
20:18:50 4929 8192000000 10711115040 11136446464 1782935072 17.874 99 23 46 1 1795438576 6134848 6368656
20:19:04 8210 8192000000 10706409584 11127439360 1758146464 17.669 97 20 39 0 1769424336 5660560 5617312
20:19:19 13421 8192000000 10710122832 11129790464 1751020496 17.610 97 12 24 0 1759991664 5337088 3634080
20:19:40 9384 8192000000 10665444080 11072638976 1678639920 17.006 93 22 44 0 1690446864 5081664 6725280
20:19:57 10141 8192000000 10680587104 11094282240 1747956400 17.585 99 31 62 0 1763201024 5315184 9929440
20:20:14 10490 8192000000 10695687696 11114975232 1761961344 17.701 99 15 30 2 1771842496 5396432 4484720
20:20:30 10268 8192000000 10708680240 11117793280 1716747104 17.325 96 16 32 2 1726297088 5217696 4332288
20:20:47 85614 8192000000 10701300144 11123781632 1679587952 17.014 93 44 88 1 1697961312 4738416 13634944
20:22:19 9217 8192000000 10736263280 11146100736 1807329504 18.074 100 20 40 1 1817732240 5028896 5373840
20:22:34 7093 8192000000 10738788208 11160461312 1816288464 18.147 100 23 46 3 1828820880 5986352 6546064
20:22:49 6247 8192000000 10745459248 11160129536 1823532864 18.207 100 45 90 1 1844751568 9005024 12213680
20:23:04 12739 8192000000 10754569104 11170246656 1825855520 18.226 100 31 62 1 1841063040 6291904 8915616
20:23:25 6238 8192000000 10741152112 11164528640 1816633024 18.150 99 23 46 1 1829695664 5873728 7188912
20:23:39 11254 8192000000 10743365504 11170353152 1830760384 18.266 100 23 45 2 1843108576 5678752 6669440
20:23:57 12321 8192000000 10750156528 11175047168 1832003216 18.276 100 17 33 1 1843044464 5826000 5215248
20:24:16 8525 8192000000 10768146192 11188965376 1846958496 18.397 100 34 69 4 1861703856 5090816 9654544
20:24:32 10148 8192000000 10760438224 11187290112 1849144976 18.415 100 27 54 0 1862822832 5788160 7889696
20:24:49 11587 8192000000 10764245472 11192365056 1845805088 18.388 100 19 38 2 1860789840 9573888 5410864
20:25:07 7061 8192000000 10774317728 11192483840 1851137568 18.431 100 19 38 0 1861352752 4948816 5266368
20:25:22 13016 8192000000 10766276752 11200061440 1853441680 18.450 100 14 28 1 1863144304 5501536 4201088
20:25:41 19042 8192000000 10796903104 11214589952 1857110768 18.480 100 10 20 0 1864727024 5243952 2372304
20:26:06 100857 8192000000 10802453664 11225329664 1871472704 18.596 100 30 60 1 1884945104 4719264 8753136
20:27:56 17474 8192000000 10840893392 11257528320 1902825312 18.849 100 53 105 1 1929253424 11607152 14820960
20:28:21 25474 8192000000 10853304224 11269496832 1914550672 18.943 100 59 118 1 1940987120 10105424 16331024
20:28:54 11453 8192000000 10854431248 11273703424 1921713200 19.001 100 56 112 2 1948068304 10909872 15445232
20:29:18 5749 8192000000 10861750576 11281227776 1927109024 19.044 100 51 98 2 1950396640 9633136 13654480
20:29:30 2784 8192000000 10884862816 11294789632 1936508992 19.119 100 72 142 2 1968374960 11220432 20645536
20:29:45 8095 8192000000 10879466672 11299110912 1937355600 19.126 100 61 122 3 1966544304 11696848 17491856
20:30:02 15233 8192000000 10875628896 11301253120 1940993936 19.155 100 64 128 0 1971411232 11944512 18472784
20:30:26 30369 8192000000 10875479840 11301232640 1943552160 19.175 100 48 96 1 1971379408 14146448 13680800
20:31:05 16763 8192000000 10880991712 11312320512 1948479888 19.214 100 52 104 4 1977205984 13376656 15349440
20:31:32 15899 8192000000 10883904848 11318996992 1950820512 19.233 100 39 77 2 1974991360 13318848 10852000
20:31:55 15822 8192000000 10895654224 11329449984 1960939680 19.314 100 50 100 1 1994491056 18853072 14698304
20:32:32 9626 8192000000 10907621760 11335340032 1963307584 19.332 100 40 80 1 1991979808 16728816 11943408
20:32:57 16116 8192000000 10922106720 11350675456 1974132992 19.418 100 61 118 0 2009871264 18669344 17068928
20:33:21 4778 8192000000 10912907232 11349798912 1974580624 19.422 100 46 90 0 2008877408 21295360 13001424
20:33:38 6625 8192000000 10920049536 11352395776 1975740224 19.431 100 44 87 1 2009501376 21066352 12694800
20:33:53 14843 8192000000 10922903968 11353903104 1976913456 19.440 100 48 96 0 2011786512 20136032 14737024
20:34:33 10747 8192000000 10923091888 11359285248 1967937248 19.369 99 52 104 1 2006138240 22352656 15848336
20:34:56 13401 8192000000 10925899968 11372445696 1982878064 19.487 100 43 84 2 2019949392 23871872 13199456
20:35:26 9371 8192000000 10927594208 11367075840 1975570512 19.430 99 40 80 0 2006211408 18424000 12216896
20:35:44 13722 8192000000 10921142848 11361443840 1971672320 19.399 99 37 74 1 2001875280 19168560 11034400
20:36:08 9903 8192000000 10935947680 11369369600 1991654720 19.557 100 48 96 3 2027888400 22168528 14065152
20:36:27 14120 8192000000 10950947472 11385794560 2002175168 19.640 100 50 100 1 2041761152 24395504 15190480
20:36:51 14623 8192000000 10962902832 11397087232 2008569632 19.690 100 63 127 0 2053312064 25968832 18773600
20:37:14 12435 8192000000 10965455360 11405705216 2016201856 19.750 100 58 115 0 2062067776 27615152 18250768
20:37:37 6639 8192000000 10975479104 11402928128 2016160960 19.750 100 78 154 4 2066099520 26838832 23099728
20:37:58 6820 8192000000 10986459552 11410079744 2013616272 19.730 100 73 143 2 2067328560 33031664 20680624
20:38:13 2280 8192000000 10989539392 11410755584 2022841664 19.802 100 75 144 2 2077485152 33662448 20981040
20:38:22 3732 8192000000 10973544400 11388391424 1988449552 19.532 98 78 156 1 2045327392 33751440 23126400
20:38:33 2939 8192000000 10972032224 11399577600 2007870464 19.685 100 69 136 1 2059081920 30446672 20764784
20:38:44 5424 8192000000 10979482656 11406979072 2012935200 19.725 100 66 131 1 2063079840 29810544 20334096
20:38:58 5550 8192000000 10980037680 11411062784 2016394176 19.752 100 65 131 2 2065246960 29124720 19728064
20:39:11 3971 8192000000 10987036128 11412865024 2016102432 19.750 100 58 111 2 2061263344 28411232 16749680
20:39:24 2671 8192000000 10980072256 11392704512 2000070192 19.623 99 80 156 1 2054839216 31547648 23221376
20:39:33 2842 8192000000 10988037680 11407486976 2017684896 19.762 100 84 167 3 2076827952 33472032 25671024
20:39:43 3084 8192000000 11009735344 11421863936 2027262176 19.837 100 80 158 2 2086307072 35729600 23315296
20:39:53 1167 8192000000 11009264576 11429310464 2032426512 19.878 100 78 154 1 2092091120 36643120 23021488
20:40:02 2226 8192000000 10997860400 11421425664 2020797360 19.786 100 80 160 1 2084792736 39416224 24579152
20:40:13 4320 8192000000 11001436368 11425558528 2023481152 19.807 100 79 158 0 2087214000 39757456 23975392
20:40:28 2275 8192000000 11002094080 11426058240 2020773568 19.786 100 76 153 0 2086059424 42155024 23130832
20:40:37 5393 8192000000 11011004016 11436601344 2024669968 19.817 100 72 145 1 2090067488 42855264 22542256
20:40:51 8464 8192000000 10984848576 11404300288 1987524960 19.524 99 75 149 1 2053563536 43397792 22640784
20:41:07 2612 8192000000 10998132096 11410849792 2006611424 19.675 100 73 145 2 2073349408 44615312 22122672
20:41:17 2461 8192000000 11002872768 11420749824 2015139904 19.742 100 85 170 0 2088767696 47585104 26042688
20:41:25 2243 8192000000 10982064224 11408564224 1998114144 19.608 100 75 150 1 2069810672 48443344 23253184
20:41:35 3264 8192000000 10974978560 11400060928 1991439952 19.555 100 71 142 0 2061694480 47006544 23247984
20:41:47 4589 8192000000 10972547408 11398160384 1998084960 19.608 100 77 153 0 2064163152 43547840 22530352
20:42:00 7508 8192000000 10976228032 11396460544 1988816016 19.534 100 75 150 2 2056524576 45628016 22080544
20:42:16 3311 8192000000 10992765936 11409293312 2000672672 19.628 100 83 165 0 2074426800 48184864 25569264
20:42:30 5094 8192000000 10984763168 11413188608 2005383744 19.665 100 73 146 1 2075374976 47153904 22837328
20:42:42 2219 8192000000 10946293952 11361021952 1935233344 19.109 97 86 172 0 2008057520 46344720 26479456
20:42:54 5326 8192000000 10953157264 11371786240 1969151664 19.379 100 74 149 1 2039627248 47394320 23081264
20:43:08 3645 8192000000 10960692176 11376869376 1970137360 19.387 100 84 166 1 2044464944 48721888 25605696
20:43:27 3826 8192000000 10969266976 11381866496 1975049264 19.425 100 79 157 2 2048200640 48505824 24645552
20:43:37 1539 8192000000 10992428432 11400339456 1996227120 19.593 100 87 169 1 2071997008 49917376 25852512
20:43:45 2066 8192000000 10998715632 11406315520 1994816736 19.582 100 94 184 0 2076641728 53005024 28819968
20:43:54 1041 8192000000 10998322128 11411087360 1994982144 19.583 100 94 189 2 2078879536 55232976 28664416
20:44:02 5938 8192000000 10970157840 11388125184 1968684560 19.375 99 83 166 0 2049777024 54995792 26096672
20:44:18 1350 8192000000 10993677328 11405033472 1989494256 19.540 100 91 182 1 2070913920 53237200 28182464
20:44:26 4067 8192000000 10988955376 11410284544 1990862800 19.551 100 82 162 3 2071084416 54282992 25938624
20:44:37 3136 8192000000 10993097920 11401621504 1983998976 19.496 100 91 182 1 2065739888 52450480 29290432
20:44:50 3212 8192000000 10986179568 11401658368 1986513024 19.516 100 83 168 1 2063816320 49525424 27777872
20:45:02 2462 8192000000 10994294432 11414867968 1999323904 19.617 100 88 176 0 2076892928 48702176 28866848
20:45:14 2838 8192000000 10980966640 11399946240 1992791376 19.566 100 83 164 1 2066184128 48148368 25244384
20:45:27 6602 8192000000 10982750912 11409129472 1992401504 19.563 100 69 138 0 2063799216 49440928 21956784
20:45:44 4342 8192000000 10995926400 11419758592 2001665200 19.636 100 68 135 4 2076370384 53632720 21072464
20:45:55 5661 8192000000 11000657088 11425030144 2003074608 19.647 100 82 163 1 2084181696 54908384 26198704
20:46:11 7670 8192000000 10993603184 11421810688 2001212768 19.632 100 66 130 1 2075857616 53503936 21140912
20:46:26 2136 8192000000 11014898512 11428786176 2006787856 19.676 100 84 165 4 2088439824 55247728 26404240
20:46:35 2422 8192000000 11004130480 11418370048 1995726880 19.589 100 87 174 1 2082216240 57847520 28641840
20:46:46 3626 8192000000 11007668256 11421736960 2002656336 19.644 100 86 170 2 2086014624 57060528 26297760
20:46:56 2490 8192000000 11010697744 11424276480 2004325520 19.657 100 89 180 1 2090728256 58448560 27954176
20:47:09 4188 8192000000 11025796080 11434274816 2014263728 19.735 100 91 179 1 2104495312 61872928 28358656
20:47:20 1180 8192000000 11021456576 11434967040 2006265360 19.672 100 87 174 0 2097251904 63195120 27791424
20:47:28 4348 8192000000 11023925888 11449675776 2011849264 19.716 100 82 163 1 2104982000 66982912 26149824
20:47:39 8262 8192000000 10997821920 11430346752 2004909008 19.661 100 58 116 0 2089627936 65094016 19624912
20:47:55 5911 8192000000 10993344176 11432620032 2003391392 19.649 100 48 96 0 2078072464 58179648 16501424
20:48:10 11022 8192000000 10980517184 11416252416 1974361120 19.420 99 44 88 0 2046487696 56709088 15417488
20:48:28 8382 8192000000 10972204112 11415257088 1979378544 19.460 99 51 102 3 2048238368 51883440 16976384
20:48:48 10254 8192000000 10961128384 11397734400 1971144928 19.395 99 40 80 1 2036890800 52060464 13685408
20:49:11 14393 8192000000 10978948176 11414999040 1990515408 19.548 100 50 100 1 2064253280 57125168 16612704
20:49:32 9585 8192000000 10986967376 11427975168 1993936112 19.575 100 49 98 0 2071244976 60560512 16748352
20:50:03 25727 8192000000 10969595248 11433099264 1992338960 19.562 100 28 56 0 2055397424 53105200 9953264
20:50:43 17476 8192000000 10980168432 11428491264 1995438448 19.587 100 33 66 0 2063818240 56574768 11805024
20:51:11 19693 8192000000 10988286768 11441594368 1998380624 19.610 100 36 72 0 2072655456 61590032 12684800
20:51:45 28499 8192000000 10938498688 11402018816 1923387552 19.014 97 27 54 3 1992004272 58663632 9953088
20:52:21 14172 8192000000 10941236432 11395047424 1942461872 19.166 99 21 42 3 2008701008 58033360 8205776
20:52:56 22664 8192000000 10939187344 11384385536 1922785728 19.009 98 34 69 1 1993960288 59021648 12152912
20:53:25 30297 8192000000 10922434816 11383402496 1883556992 18.694 97 21 42 0 1957760176 65742864 8460320
20:55:16 101142 8192000000 10848665328 11291115520 1840052672 18.341 95 15 30 0 1858719472 14328576 4338224
20:57:03 109522 8192000000 10871622096 11338719232 1907877008 18.890 99 20 40 1 1923816752 10601664 5338080
20:59:11 94075 8192000000 10892669152 11349155840 1891352800 18.757 96 22 43 0 1906398480 9395072 5650608
21:00:53 64334 8192000000 10868051248 11332812800 1889385984 18.741 96 22 44 0 1903440704 8382144 5672576
21:02:06 46010 8192000000 10903134672 11353444352 1967402384 19.365 100 26 52 2 1983819680 9606640 6810656
21:02:59 12627 8192000000 10920122064 11362635776 1976916256 19.440 100 31 62 2 1996407728 10994032 8497440
21:03:19 6767 8192000000 10902977712 11347464192 1954543312 19.263 99 60 121 1 1986810176 15219360 17047504
21:03:32 89657 8192000000 10923030048 11378814976 1984297280 19.499 100 26 52 1 2004253136 12570464 7385392
21:05:22 46028 8192000000 10915093792 11386462208 1968569488 19.374 99 17 34 1 1989851296 16730480 4551328
21:07:12 52106 8192000000 10883087344 11355172864 1947203664 19.204 98 16 32 0 1964731168 13059296 4468208
21:08:10 46707 8192000000 10884209216 11357048832 1934787104 19.105 98 14 28 0 1950063616 11333168 3943344
21:09:07 67491 8192000000 10906496320 11368308736 1955268288 19.268 99 22 45 2 1980192080 17643104 7280688
21:10:20 112093 8192000000 10899990704 11377676288 1981771216 19.479 100 21 42 1 1995682944 7894288 6017440
21:12:55 19430 8192000000 10906043664 11382157312 1986205280 19.514 100 16 32 4 1998833712 7891040 4737392
21:13:23 22959 8192000000 10910418224 11382972416 1990931072 19.551 100 13 26 3 2003056064 7695552 4429440
21:14:36 63918 8192000000 10913751568 11394682880 1961719376 19.320 98 13 26 1 1977485856 11758016 4008464
21:15:46 31784 8192000000 10910048224 11393564672 1993236880 19.569 100 12 24 1 2011255232 14608288 3410064
21:16:31 50945 8192000000 10906183184 11392913408 1987898880 19.527 100 10 21 1 2003027120 11899824 3228416
21:17:28 85736 8192000000 10911552496 11393007616 1972327520 19.404 99 9 16 1 1989168608 15017936 1823152
21:19:00 30273 8192000000 10913605632 11377266688 1937224624 19.125 97 26 52 2 1957526544 12806192 7495728
21:19:36 32809 8192000000 10916629824 11369336832 1947081616 19.203 98 35 70 3 1965235120 8853728 9299776
21:20:22 65669 8192000000 10892134288 11372060672 1926033056 19.035 97 30 60 3 1945885328 12002928 7849344
21:21:40 51794 8192000000 10893948016 11374227456 1958361328 19.293 99 24 48 3 1978196768 12767664 7067776
21:22:59 80205 8192000000 10917833264 11394473984 1945475632 19.190 97 18 36 0 1968249840 17361376 5412832
21:24:25 67878 8192000000 10907229696 11381579776 1922021760 19.003 97 15 30 0 1953146336 26535920 4588656
21:25:45 46130 8192000000 10870365168 11330433024 1874516800 18.621 95 19 38 1 1888153680 8750352 4886528
21:26:38 51567 8192000000 10869382432 11333296128 1867189232 18.562 96 22 44 1 1885878256 11498896 7190128
21:27:50 65826 8192000000 10870046400 11341680640 1890817056 18.752 97 17 34 2 1907358432 12022944 4518432
21:29:09 55119 8192000000 10870006080 11320602624 1881625312 18.678 97 17 34 0 1898184048 12237696 4321040
21:30:17 60109 8192000000 10888663680 11341688832 1938828864 19.137 99 29 58 4 1961344912 14795360 7720688
21:31:31 123196 8192000000 10895052304 11376799744 1964093072 19.339 100 29 58 0 1996481680 23395040 8993568
21:34:09 61565 8192000000 10863423232 11326509056 1862713968 18.525 95 23 46 0 1876589152 7512288 6362896
21:35:20 45306 8192000000 10862108128 11336663040 1919200512 18.980 98 37 74 1 1940348928 10115376 11033040
21:36:36 44251 8192000000 10854919072 11334291456 1927561232 19.047 99 6 12 0 1937465936 8293184 1611520
21:37:27 30613 8192000000 10832884224 11303403520 1905855920 18.873 99 22 43 2 1920524512 8221856 6446736
21:38:04 52779 8192000000 10859736240 11332075520 1929123680 19.060 100 11 22 0 1943299008 10619056 3556272
21:40:15 79749 8192000000 10867485264 11338387456 1875964688 18.633 97 8 16 0 1891711136 13666544 2079904
21:41:41 41407 8192000000 10862080240 11320774656 1908202064 18.892 98 22 44 1 1927894224 13438192 6253968
21:42:32 53102 8192000000 10862801776 11331817472 1880210528 18.667 97 19 38 0 1901356720 15068800 6077392
21:43:38 101008 8192000000 10834705904 11323187200 1861454416 18.515 96 22 44 1 1882887152 15217648 6215088
21:45:25 27413 8192000000 10883686496 11331973120 1934857728 19.106 100 24 48 0 1952507136 10582784 7066624
21:45:59 45223 8192000000 10869632992 11332792320 1909891168 18.906 98 33 66 1 1928799680 9675120 9233392
21:46:58 68824 8192000000 10843649200 11310866432 1793602976 17.961 93 10 21 0 1807239520 10386224 3250320
21:48:23 24755 8192000000 10877175424 11325624320 1925214944 19.029 100 36 71 1 1946116352 10423152 10478256
21:48:54 58061 8192000000 10855845248 11318063104 1871047792 18.593 97 24 48 0 1895637680 17652864 6937024
21:50:02 50822 8192000000 10864770544 11326451712 1887452032 18.725 98 28 53 3 1909951024 13847056 8651936
21:50:59 31330 8192000000 10885985152 11336867840 1922124272 19.004 99 44 89 3 1948218944 13166576 12928096
21:52:19 77377 8192000000 10875813888 11341283328 1902438976 18.846 98 19 38 4 1933286544 25448272 5399296
21:53:43 140361 8192000000 10884351776 11339415552 1921401568 18.998 99 18 36 0 1936162928 9896416 4864944
21:56:32 56491 8192000000 10882308144 11362033664 1963208912 19.332 100 20 39 2 1981532000 12155552 6167536
21:57:40 52118 8192000000 10872006800 11353567232 1946779568 19.201 99 8 16 2 1960453856 11616976 2057312
21:58:40 39950 8192000000 10886871248 11363901440 1939770000 19.145 99 8 16 2 1953570592 11842864 1957728
21:59:33 78984 8192000000 10898568160 11370160128 1939414336 19.142 98 16 32 0 1961336032 16936912 4984784
22:01:04 67522 8192000000 10893037488 11363680256 1932271856 19.085 98 12 24 0 1949132752 13548560 3312336
22:02:23 43748 8192000000 10893289312 11371134976 1972156144 19.403 100 19 38 2 1985707904 9218304 4333456
22:03:14 52082 8192000000 10914732048 11389091840 1988780368 19.534 100 30 60 2 2007521216 10333984 8406864
22:04:13 63364 8192000000 10912976288 11386675200 1969877568 19.384 99 41 82 4 1993230064 11400144 11952352
22:05:22 92108 8192000000 10911732288 11384016896 1948958752 19.218 98 14 28 2 1961918080 9406864 3552464
22:07:01 28665 8192000000 10910348800 11375685632 1929435888 19.062 97 41 81 2 1953156272 12034512 11685872
22:07:36 72239 8192000000 10904583088 11383554048 1915451440 18.950 97 18 36 1 1933174864 12696480 5026944
22:09:02 62549 8192000000 10896810752 11372376064 1935650784 19.112 98 18 36 0 1952902576 12188080 5063712
22:10:30 41875 8192000000 10896419040 11361193984 1903488000 18.854 96 37 73 2 1922600496 9220832 9891664
22:11:31 111772 8192000000 10877716208 11331166208 1804439344 18.050 92 14 28 0 1820715424 12121376 4154704
22:13:33 47412 8192000000 10864529600 11331969024 1891305936 18.756 97 16 32 0 1904054512 8498912 4249664
22:14:31 35150 8192000000 10891386640 11341836288 1947679600 19.208 100 38 76 2 1967677984 9289648 10708736
22:15:12 63616 8192000000 10822240000 11284250624 1845065680 18.382 95 17 34 0 1858681840 8943408 4672752
22:17:23 66139 8192000000 10835411648 11308929024 1917123632 18.964 99 28 57 1 1937109600 11887904 8098064
22:18:36 19146 8192000000 10847930256 11315904512 1914973760 18.947 99 14 28 1 1925520160 6488544 4057856
22:19:03 54029 8192000000 10843731744 11328933888 1914675072 18.944 99 12 24 0 1925197824 7245616 3277136
22:20:03 30008 8192000000 10847556144 11330056192 1917932752 18.970 99 11 21 2 1929342208 8783168 2626288
22:20:39 59895 8192000000 10841717408 11317280768 1898644208 18.815 98 7 14 0 1911395760 10622192 2129360
22:22:52 67931 8192000000 10855203136 11324981248 1901010752 18.834 99 8 16 1 1913329856 10711984 1607120
22:24:06 57711 8192000000 10868858800 11342192640 1947792720 19.209 100 20 40 1 1963408224 10273968 5341536
22:25:17 52251 8192000000 10854928400 11336781824 1895147792 18.787 97 26 51 1 1912799376 9462416 8189168
22:26:46 30051 8192000000 9178990064 9425616896 341359168 4.000 18 2 2 1 345812192 4034384 418640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 03-01-2021 22:28:25 to 03-01-2021 22:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 84 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-01-2021 22:28:57 to 03-01-2021 22:28:59.

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          245497
MON$OLDEST_ACTIVE               245498
MON$OLDEST_SNAPSHOT             245498
MON$NEXT_TRANSACTION            245498
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                       2023424
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:316: 
:317: mscs-test-161.budzdorov.ru    Sun Jan  3 22:27:18 2021
:318:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:319: 
--- end of diff output ---

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

03.01.21 22:29:00. 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-03 22:29:03 No severe PSQL-related problems occured
03.01.21 22:29:04. End of report.