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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17315956 kB
MemAvailable 31493876 kB
Buffers 0 kB
Cached 14375228 kB
SwapCached 3696 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 2020-12-22 01:27:09
DTS_END                         2020-12-22 01:27:09.2550
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/50924
TRN_ID                          259705
ATT_ID                          686
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: 9824.44 17692 1178933
customer order: creation 191.83 338 23019
customer order: refuse 15.37 253 1844
order to supplier: creation 50.83 1128 6100
order to supplier: removal 3.68 82316 442
invoice (draft): creation 50.27 2991 6032
invoice (draft): removal 54.09 683 6491
invoice accept: apply 45.28 16290 5433
invoice accept: cancel 48.88 641 5865
customer reserve: creation 4199.78 162 503974
customer reserve: removal 4841.94 49 581033
realization accept: apply 91.11 165 10933
realization accept: cancel 89.19 97 10703
payment from customer: creation 64.08 113 7690
payment from customer: removal 6.35 72 762
payment to supplier: creation 54.18 130 6501
payment to supplier: removal 3.83 56 460
service: total inventory turnovers 5.52 818 662
service: total monetary turnovers 7.33 22 880
service: aggregate perf. data 0.88 20137 105
service: refresh index statistics 0.03 227387 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-12-2020 01:28:52 to 22-12-2020 01:28:54.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6529
TEST_TIME 2 4899
TEST_TIME 3 4736
TEST_TIME 4 4560
TEST_TIME 5 5359
TEST_TIME 6 6100
TEST_TIME 7 6174
TEST_TIME 8 6304
TEST_TIME 9 6533
TEST_TIME 10 7065
TEST_TIME 11 7385
TEST_TIME 12 7570
TEST_TIME 13 7816
TEST_TIME 14 7896
TEST_TIME 15 8321
TEST_TIME 16 8516
TEST_TIME 17 9265
TEST_TIME 18 9550
TEST_TIME 19 10608
TEST_TIME 20 10780
TEST_TIME 21 10502
TEST_TIME 22 11255
TEST_TIME 23 12251
TEST_TIME 24 12343
TEST_TIME 25 12305
TEST_TIME 26 12304
TEST_TIME 27 12383
TEST_TIME 28 12032
TEST_TIME 29 11772
TEST_TIME 30 11729
TEST_TIME 31 11626
TEST_TIME 32 11471
TEST_TIME 33 11393
TEST_TIME 34 11434
TEST_TIME 35 11309
TEST_TIME 36 11150
TEST_TIME 37 11054
TEST_TIME 38 10922
TEST_TIME 39 10879
TEST_TIME 40 10929
TEST_TIME 41 10866
TEST_TIME 42 10832
TEST_TIME 43 10897
TEST_TIME 44 10944
TEST_TIME 45 10885
TEST_TIME 46 10859
TEST_TIME 47 10863
TEST_TIME 48 10836
TEST_TIME 49 10819
TEST_TIME 50 10762
TEST_TIME 51 10733
TEST_TIME 52 10686
TEST_TIME 53 10548
TEST_TIME 54 10467
TEST_TIME 55 10435
TEST_TIME 56 10445
TEST_TIME 57 10314
TEST_TIME 58 10304
TEST_TIME 59 10261
TEST_TIME 60 10240
TEST_TIME 61 10202
TEST_TIME 62 10294
TEST_TIME 63 10277
TEST_TIME 64 10290
TEST_TIME 65 10307
TEST_TIME 66 10259
TEST_TIME 67 10282
TEST_TIME 68 10363
TEST_TIME 69 10398
TEST_TIME 70 10405
TEST_TIME 71 10412
TEST_TIME 72 10396
TEST_TIME 73 10428
TEST_TIME 74 10460
TEST_TIME 75 10373
TEST_TIME 76 10286
TEST_TIME 77 10233
TEST_TIME 78 10208
TEST_TIME 79 10188
TEST_TIME 80 10133
TEST_TIME 81 10052
TEST_TIME 82 10036
TEST_TIME 83 10064
TEST_TIME 84 10037
TEST_TIME 85 10009
TEST_TIME 86 9983
TEST_TIME 87 10046
TEST_TIME 88 10027
TEST_TIME 89 10071
TEST_TIME 90 10054
TEST_TIME 91 10016
TEST_TIME 92 10137
TEST_TIME 93 10174
TEST_TIME 94 10164
TEST_TIME 95 10203
TEST_TIME 96 10162
TEST_TIME 97 10168
TEST_TIME 98 10153
TEST_TIME 99 10104
TEST_TIME 100 10034
TEST_TIME 101 10018
TEST_TIME 102 10003
TEST_TIME 103 9939
TEST_TIME 104 9870
TEST_TIME 105 9823
TEST_TIME 106 9791
TEST_TIME 107 9875
TEST_TIME 108 9846
TEST_TIME 109 9829
TEST_TIME 110 9800
TEST_TIME 111 9817
TEST_TIME 112 9895
TEST_TIME 113 9871
TEST_TIME 114 9900
TEST_TIME 115 9883
TEST_TIME 116 9917
TEST_TIME 117 9951
TEST_TIME 118 9934
TEST_TIME 119 9903
TEST_TIME 120 9828

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 22-12-2020 01:28:55 to 22-12-2020 01:28:59.

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 1647521 1647521 0 0.00 0 44169 6 0 0
doc_list_biud 1647521 1647521 0 0.00 0 53940 22 0 0
sp_add_invoice_to_stock 5591 5433 158 2.82 38 200019 16290 0 158
sp_cancel_adding_invoice 5865 5865 0 0.00 4 59380 641 0 0
sp_cancel_client_order 1844 1844 0 0.00 4 9789 253 0 0
sp_cancel_customer_reserve 581033 581033 0 0.00 1 26590 49 0 0
sp_cancel_pay_from_customer 762 762 0 0.00 3 4148 73 0 0
sp_cancel_pay_to_supplier 460 460 0 0.00 2 2825 57 0 0
sp_cancel_supplier_invoice 6503 6491 12 0.18 1 15967 683 0 12
sp_cancel_supplier_order 442 442 0 0.00 5 1001193 82316 0 0
sp_cancel_write_off 10703 10703 0 0.00 1 18029 97 0 0
sp_client_order 23019 23019 0 0.00 3 37717 339 0 0
sp_customer_reserve 503974 503974 0 0.00 0 163313 163 0 0
sp_fill_shopping_cart 35144 35144 0 0.00 1 43935 40 0 0
sp_fill_shopping_cart_clo_res 503970 503970 0 0.00 0 42757 11 0 0
sp_get_clo_for_invoice 5428 5428 0 0.00 0 22392 241 0 0
sp_kill_cost_storno 17790 17790 0 0.00 0 11863 45 0 0
sp_kill_qstorno_ret_qs2qd 1179702 1179702 0 0.00 0 21829 27 0 0
sp_kill_qty_storno 622739 622739 0 0.00 0 53938 57 0 0
sp_lock_selected_doc 22641 22641 0 0.00 0 10195 6 0 0
sp_make_cost_storno 30552 30552 0 0.00 0 17277 64 0 0
sp_multiply_rows_for_pdistr 30552 30552 0 0.00 0 12360 25 0 0
sp_multiply_rows_for_qdistr 23019 23019 0 0.00 0 33337 160 0 0
sp_pay_from_customer 7690 7690 0 0.00 4 16618 113 0 0
sp_pay_to_supplier 6501 6501 0 0.00 5 16272 130 0 0
sp_payment_common 14191 14191 0 0.00 1 15594 39 0 0
sp_qd_handle_on_cancel_clo 1844 1844 0 0.00 0 9784 222 0 0
sp_qd_handle_on_invoice_upd_sts 11293 11293 0 0.00 0 53938 254 0 0
sp_qd_handle_on_reserve_upd_sts 10933 10933 0 0.00 0 14722 44 0 0
sp_reserve_write_off 10933 10933 0 0.00 6 16706 166 0 0
sp_supplier_invoice 6032 6032 0 0.00 6 146081 2992 0 0
sp_supplier_order 6100 6100 0 0.00 5 34544 1128 0 0
srv_aggregate_perf_data 105 105 0 0.00 2670 347123 20138 0 0
srv_fill_mon_cache_memory 145 145 0 0.00 1145 170750 37722 0 0
srv_find_qd_qs_mism 1127429 1127429 0 0.00 0 44167 5 0 0
srv_make_invnt_saldo 662 662 0 0.00 31 55132 818 0 0
srv_make_money_saldo 880 880 0 0.00 1 1616 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 99908 297402 227388 0 0
t$perf-abend:sp_add_invoice_to_stock 158 158 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5433 5433 0 0.00 0 13480 115 0 0
t$perf-norm:sp_cancel_adding_invoice 455 455 0 0.00 1 4059 62 0 0
t$perf-norm:sp_cancel_client_order 1844 1844 0 0.00 0 9053 12 0 0
t$perf-norm:sp_cancel_customer_reserve 804 804 0 0.00 0 4377 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 762 762 0 0.00 0 3479 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 460 460 0 0.00 0 698 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 433 433 0 0.00 0 424 8 0 0
t$perf-norm:sp_cancel_supplier_order 442 442 0 0.00 0 31423 1257 0 0
t$perf-norm:sp_cancel_write_off 1083 1083 0 0.00 0 5859 16 0 0
t$perf-norm:sp_client_order 23019 23019 0 0.00 0 8753 12 0 0
t$perf-norm:sp_customer_reserve 1143 1143 0 0.00 0 7846 14 0 0
t$perf-norm:sp_pay_from_customer 7690 7690 0 0.00 0 13901 9 0 0
t$perf-norm:sp_pay_to_supplier 6501 6501 0 0.00 0 3836 7 0 0
t$perf-norm:sp_reserve_write_off 10933 10933 0 0.00 0 26502 10 0 0
t$perf-norm:sp_supplier_invoice 6032 6032 0 0.00 0 10523 16 0 0
t$perf-norm:sp_supplier_order 6100 6100 0 0.00 0 9763 13 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 208 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 145 145 0 0.00 0 331 7 0 0
t$perf-norm:srv_make_invnt_saldo 662 662 0 0.00 0 3439 14 0 0
t$perf-norm:srv_make_money_saldo 880 880 0 0.00 0 2001 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 11166 10850 316 2.83 0 4501 18 0 316
v_all_customers 41968 41968 0 0.00 0 19 1 0 0
v_all_suppliers 33790 33790 0 0.00 0 45 1 0 0
v_all_wares 46038 46038 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 910 910 0 0.00 0 2703 9 0 0
v_cancel_client_order 3688 3688 0 0.00 0 4957 6 0 0
v_cancel_customer_prepayment 1524 1524 0 0.00 0 1802 7 0 0
v_cancel_customer_reserve 1608 1608 0 0.00 0 2180 7 0 0
v_cancel_payment_to_supplier 920 920 0 0.00 0 1163 4 0 0
v_cancel_supplier_invoice 890 866 24 2.69 0 1859 19 0 24
v_cancel_supplier_order 884 884 0 0.00 0 538 4 0 0
v_cancel_write_off 2166 2166 0 0.00 0 5039 15 0 0
v_max_id_clo_ord 6100 6100 0 0.00 0 3621 2 0 0
v_max_id_clo_res 1143 1143 0 0.00 0 2044 11 0 0
v_max_id_ord_sup 6025 6025 0 0.00 0 3128 4 0 0
v_max_non_paid_invoice 1731 1731 0 0.00 0 1172 4 0 0
v_max_non_paid_realizn 4015 4015 0 0.00 0 4044 6 0 0
v_min_id_clo_ord 6100 6100 0 0.00 0 20898 13 0 0
v_min_id_clo_res 1143 1143 0 0.00 0 11884 17 0 0
v_min_id_ord_sup 6025 6025 0 0.00 0 20524 12 0 0
v_min_non_paid_invoice 6501 6501 0 0.00 0 9793 28 0 0
v_min_non_paid_realizn 7690 7690 0 0.00 0 10529 28 0 0
v_our_firm 11420 11420 0 0.00 0 11 1 0 0
v_reserve_write_off 21866 21866 0 0.00 0 5292 7 0 0
x_lock_depdocs_on_canc_invoice 11923 11923 0 0.00 0 13906 99 0 0
x_lock_depdocs_on_canc_sup_ord 442 442 0 0.00 0 6363 291 0 0
x_make_qstorno_1000_1200 6100 6100 0 0.00 2 26811 1060 0 0
x_make_qstorno_1200_2000 6032 6032 0 0.00 3 146008 2838 0 0
x_make_qstorno_2100_3300 503974 503974 0 0.00 0 163307 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-12-2020 01:29:00 to 22-12-2020 01:29:04.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:13 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:19 7891 8192000000 10165219680 10460061696 851270624 9.413 70 49 102 1 871018688 2385696 17362368
22:57:34 19578 8192000000 10312161296 10628354048 1354455296 14.188 100 77 153 0 1384216304 3831488 25929520
22:58:04 15484 8192000000 10350398400 10670735360 1404915200 14.639 100 86 174 1 1438345840 4979104 28451536
22:58:30 23354 8192000000 10397487360 10724941824 1437661056 14.929 100 91 182 1 1473901952 6395904 29844992
22:59:03 22217 8192000000 10424151280 10753298432 1474564096 15.254 100 92 185 0 1511613728 7207488 29842144
22:59:32 10246 8192000000 10434143680 10765508608 1489228896 15.382 100 94 188 1 1527543648 7725360 30589392
22:59:51 24283 8192000000 10452648896 10789150720 1501848176 15.492 100 88 176 0 1538115968 8294464 27973328
23:00:26 13209 8192000000 10462424832 10800054272 1522492064 15.672 100 90 180 0 1559828800 8866512 28470224
23:00:50 15086 8192000000 10479808560 10824572928 1540974688 15.832 100 85 170 0 1576887424 9087984 26824752
23:01:14 14491 8192000000 10498234064 10847588352 1562232128 16.015 100 80 160 0 1596684640 9209248 25243264
23:01:37 14799 8192000000 10530175088 10882121728 1588304816 16.239 100 78 156 0 1621751072 9470432 23975824
23:02:01 15884 8192000000 10562184160 10917683200 1617783952 16.491 100 80 159 1 1652376928 10309728 24283248
23:02:28 14336 8192000000 10580598144 10942541824 1630922288 16.603 100 74 148 1 1663077024 10327456 21827280
23:02:51 8958 8192000000 10600860192 10965200896 1657924992 16.831 100 79 158 1 1692157424 11250736 22981696
23:03:08 14212 8192000000 10614046944 10987081728 1678708144 17.006 100 77 154 1 1713211504 11993168 22510192
23:03:34 8411 8192000000 10648263904 11020566528 1710032736 17.269 100 79 158 1 1745386496 12535824 22817936
23:03:49 7899 8192000000 10650304480 11029889024 1720401632 17.356 100 71 142 2 1753173056 12643952 20127472
23:04:04 4847 8192000000 10664605968 11041669120 1728812480 17.426 100 72 144 0 1761609840 12279216 20518144
23:04:17 5570 8192000000 10664142096 11042701312 1733777696 17.467 100 70 140 1 1765814752 12412480 19624576
23:04:29 4153 8192000000 10687839408 11068747776 1754721088 17.641 100 75 149 4 1788272640 12389008 21162544
23:04:41 4646 8192000000 10699734720 11082129408 1767085520 17.743 100 76 152 2 1800704880 12577920 21041440
23:04:53 6828 8192000000 10714846832 11096625152 1775349504 17.811 100 83 162 1 1811444016 13431872 22662640
23:05:07 3024 8192000000 10724455664 11105595392 1782756048 17.872 100 81 160 0 1818794704 14187328 21851328
23:05:16 6493 8192000000 10728084208 11113521152 1786969776 17.907 100 80 159 0 1822160448 13089168 22101504
23:05:32 5020 8192000000 10728489344 11113746432 1791612992 17.945 100 79 158 1 1827591056 14091632 21886432
23:05:43 4348 8192000000 10753799856 11140055040 1814289792 18.131 100 81 161 2 1850257760 13445504 22522464
23:05:54 2338 8192000000 10760801904 11145138176 1820436048 18.181 100 89 176 2 1860225216 13677296 26111872
23:06:04 2466 8192000000 10763570160 11150635008 1825076544 18.219 100 77 153 1 1859567792 12659888 21831360
23:06:13 3104 8192000000 10764214320 11155988480 1833615680 18.289 100 77 152 4 1865487984 10638784 21233520
23:06:23 2558 8192000000 10782451872 11168030720 1845189280 18.383 100 89 178 4 1883218704 12680736 25348688
23:06:32 1837 8192000000 10787319456 11175919616 1844916144 18.381 100 88 177 1 1882488960 12935920 24636896
23:06:40 2307 8192000000 10796296544 11181633536 1851359200 18.433 100 87 174 2 1890035808 13559504 25117104
23:06:48 1586 8192000000 10797865600 11182567424 1853472208 18.450 100 84 167 2 1889892208 13294656 23125344
23:06:56 1763 8192000000 10805011456 11191066624 1855533280 18.467 100 88 173 2 1893529120 13494112 24501728
23:07:05 2069 8192000000 10809938336 11197444096 1860572320 18.508 100 90 180 1 1899459232 13239984 25646928
23:07:13 1532 8192000000 10805086080 11194056704 1863534992 18.532 100 94 189 1 1902549568 11281840 27732736
23:07:21 1280 8192000000 10811340064 11198627840 1870846288 18.591 100 91 180 2 1906602848 10618032 25138528
23:07:29 1159 8192000000 10818190928 11204960256 1872062336 18.601 100 97 196 0 1912589648 13334016 27193296
23:07:36 25822 8192000000 10781364384 11194322944 1863028592 18.528 100 56 112 2 1889868528 11159280 15680656
23:08:09 12943 8192000000 10807458928 11206541312 1869224416 18.578 100 63 124 3 1896496032 10206752 17064864
23:08:28 22040 8192000000 10789038352 11202301952 1869832784 18.583 100 62 124 1 1897577456 9853248 17891424
23:08:58 9097 8192000000 10770842800 11197292544 1866410816 18.555 100 36 72 3 1883535008 6795584 10328608
23:09:15 3962 8192000000 10776891280 11200946176 1870792768 18.591 100 35 70 2 1888207104 7226688 10187648
23:09:25 7169 8192000000 10773319552 11202752512 1867934448 18.568 100 28 57 1 1883145424 6654368 8556608
23:09:42 6813 8192000000 10784266416 11208368128 1872835696 18.607 100 32 64 1 1888945600 7101488 9008416
23:09:55 11303 8192000000 10769662096 11204313088 1871569904 18.597 100 18 37 0 1883464640 6423184 5471552
23:10:13 5880 8192000000 10790728928 11218698240 1883384480 18.692 100 26 52 1 1896411728 5688352 7338896
23:10:27 10735 8192000000 10792843360 11219759104 1882425152 18.685 100 12 24 0 1891804592 5647904 3731536
23:10:47 14838 8192000000 10791627328 11222573056 1885272592 18.708 100 13 26 1 1894997872 5813872 3911408
23:11:09 13371 8192000000 10799971824 11227959296 1888433120 18.733 100 15 29 4 1898759472 5666320 4660032
23:11:28 9173 8192000000 10803584848 11237883904 1895232688 18.788 100 17 34 2 1906255248 5666624 5355936
23:11:44 8891 8192000000 10802841552 11240218624 1896509264 18.798 100 18 36 0 1907835072 6212000 5113808
23:12:06 12865 8192000000 10804791616 11244376064 1901893232 18.842 100 17 34 1 1912301456 5795472 4612752
23:12:25 16997 8192000000 10834461392 11254317056 1903674032 18.856 100 20 40 0 1914672720 5682064 5316624
23:12:52 61154 8192000000 10822045408 11254726656 1906557760 18.879 100 25 47 3 1918559248 5270224 6731264
23:14:00 3657 8192000000 10815783424 11255369728 1910864160 18.914 100 23 46 1 1923585136 6312432 6408544
23:14:11 8087 8192000000 10817882016 11259731968 1911326880 18.917 100 28 56 0 1925562880 6205600 8030400
23:14:28 9902 8192000000 10827536288 11261734912 1911593728 18.919 100 25 46 0 1924838976 6431312 6813936
23:14:45 3854 8192000000 10835968256 11265110016 1914383808 18.942 100 39 79 3 1931617856 6205888 11028160
23:14:55 9233 8192000000 10820520656 11256066048 1896293712 18.796 99 21 40 1 1908099472 6317056 5488704
23:15:12 6625 8192000000 10825493632 11261153280 1908958960 18.898 100 21 42 0 1920767856 5975168 5833728
23:15:26 14657 8192000000 10821619920 11259002880 1898294960 18.813 99 32 64 2 1914826320 7675232 8856128
23:15:46 13261 8192000000 10827049168 11263270912 1911474384 18.918 100 24 48 4 1928320080 10091168 6754528
23:16:06 8862 8192000000 10797289008 11235516416 1848604480 18.411 97 28 56 1 1861895536 5720672 7570384
23:16:21 16638 8192000000 10737709904 11173847040 1742032528 17.536 93 14 28 2 1751298384 5532400 3733456
23:16:46 5669 8192000000 10747945712 11179200512 1816980512 18.153 98 24 48 1 1830619312 6655712 6983088
23:16:59 12987 8192000000 10741208256 11165696000 1752597616 17.623 94 19 38 2 1763736432 5998928 5139888
23:17:20 15853 8192000000 10740993664 11171590144 1784756592 17.889 97 10 20 0 1793027504 5351296 2919616
23:17:43 59064 8192000000 10744892080 11146133504 1758159424 17.669 96 37 71 1 1774581456 5559824 10862208
23:18:50 11347 8192000000 10728895504 11154280448 1800063344 18.014 99 19 38 2 1811105792 5259600 5782848
23:19:08 7049 8192000000 10759381232 11172569088 1797089616 17.990 98 24 46 1 1810060352 5766992 7203744
23:19:23 2727 8192000000 10707204704 11107135488 1758161008 17.669 97 49 99 2 1779174720 6655936 14357776
23:19:32 5269 8192000000 10632270912 11028762624 1605239728 16.384 90 32 63 2 1619077456 4987168 8850560
23:19:45 6638 8192000000 10684644272 11094253568 1715910160 17.318 97 21 41 1 1727717392 5862464 5944768
23:20:01 9191 8192000000 10697113072 11114074112 1766562736 17.739 99 24 47 1 1779613600 6598720 6452144
23:20:17 4361 8192000000 10694414960 11104366592 1749921248 17.601 98 36 73 2 1766041408 6480096 9640064
23:20:28 6551 8192000000 10719914640 11128901632 1762721776 17.707 98 35 70 1 1779470576 6302880 10445920
23:20:43 7363 8192000000 10719335792 11137400832 1790917600 17.939 99 27 53 3 1804325040 4966512 8440928
23:20:57 6268 8192000000 10729313600 11143413760 1808284096 18.082 100 31 60 3 1823268000 5782400 9201504
23:21:12 8583 8192000000 10725652256 11151708160 1805424624 18.058 99 25 50 1 1817820400 5139216 7256560
23:21:28 13011 8192000000 10755654608 11169050624 1811540208 18.108 99 16 32 1 1821550384 5353792 4656384
23:21:47 4117 8192000000 10744627952 11159683072 1811418832 18.107 99 35 70 0 1831835200 9881472 10534896
23:21:58 8942 8192000000 10747304432 11170435072 1830415280 18.263 100 21 41 2 1842049856 5383472 6251104
23:22:14 85806 8192000000 10757119744 11189366784 1833131504 18.285 99 34 69 2 1849293056 5232480 10929072
23:23:46 7714 8192000000 10777249392 11199004672 1854520640 18.459 100 27 54 1 1868904464 6989152 7394672
23:24:00 4648 8192000000 10788585248 11205795840 1861670096 18.517 100 32 64 1 1877642336 6789504 9182736
23:24:11 7064 8192000000 10785580672 11208163328 1863204064 18.529 100 25 50 2 1876823328 6429888 7189376
23:24:26 5277 8192000000 10792797616 11218530304 1868772144 18.574 100 29 58 1 1886989840 9375280 8842416
23:24:40 4057 8192000000 10781905648 11213975552 1866457872 18.556 100 21 43 2 1882175584 9863424 5854288
23:24:51 9995 8192000000 10778870960 11208392704 1866506192 18.556 100 20 40 1 1877813984 5681968 5625824
23:25:12 8871 8192000000 10777473952 11210334208 1868810480 18.575 100 21 41 3 1880134464 5032128 6291856
23:25:28 8910 8192000000 10781459616 11214712832 1873379824 18.612 100 20 40 1 1884848480 5511056 5957600
23:25:43 7733 8192000000 10794414176 11222564864 1872866224 18.607 100 17 34 0 1883542368 5958704 4717440
23:25:57 7763 8192000000 10784002144 11220357120 1874819248 18.623 100 13 27 1 1883876480 5528400 3528832
23:26:11 10483 8192000000 10796954928 11226607616 1878888848 18.656 100 20 40 0 1889915824 4860864 6166112
23:26:28 9987 8192000000 10789052080 11225579520 1879161856 18.658 100 11 22 1 1887781968 5529312 3090800
23:26:45 8325 8192000000 10803376752 11229958144 1882163232 18.683 100 23 44 4 1894074544 4805040 7106272
23:26:59 9561 8192000000 10814848928 11239460864 1891671488 18.759 100 14 28 2 1899716736 4817840 3227408
23:27:17 32608 8192000000 10851470608 11267043328 1913870480 18.938 100 37 74 0 1930303088 5520656 10911952
23:27:56 15886 8192000000 10873948576 11291324416 1932931312 19.090 100 47 93 1 1953792848 8507584 12353952
23:28:20 9310 8192000000 10868094304 11293335552 1936809728 19.121 100 45 90 0 1958804544 8772048 13222768
23:28:39 145858 8192000000 10889247344 11330252800 1952363616 19.245 100 40 80 1 1979959536 15764976 11830944
23:31:15 43539 8192000000 10879395232 11326476288 1938779728 19.137 99 20 40 1 1961557696 17062288 5715680
23:32:14 28159 8192000000 10898985744 11334705152 1962820832 19.328 100 24 48 0 1987498336 17781104 6896400
23:32:50 9923 8192000000 10898178896 11338915840 1947445168 19.206 99 42 85 1 1978859872 18606624 12808080
23:33:12 4066 8192000000 10917001312 11349278720 1973944416 19.417 100 52 103 1 2007939600 18679664 15315520
23:33:24 5442 8192000000 10929083520 11365502976 1979510176 19.461 100 53 106 0 2018656128 24059712 15086240
23:33:38 3860 8192000000 10924944944 11352809472 1975686320 19.431 100 54 107 1 2010879840 19638320 15555200
23:33:49 6447 8192000000 10927512112 11353788416 1967001920 19.362 99 60 119 0 2004502512 21369248 16131344
23:34:01 6287 8192000000 10944619840 11368390656 1987188720 19.522 100 77 153 1 2035778864 27046480 21543664
23:34:27 9936 8192000000 10946264672 11374362624 1991911024 19.559 100 66 131 0 2037790800 26853536 19026240
23:34:45 3654 8192000000 10926589072 11359182848 1969870176 19.384 99 50 100 0 2009021200 23877184 15273840
23:34:59 1968 8192000000 10924066656 11355955200 1963411584 19.333 99 77 147 0 2007758448 22625632 21721232
23:35:08 6843 8192000000 10913214864 11346112512 1951232464 19.236 99 54 106 0 1991852400 24558944 16060992
23:35:29 5041 8192000000 10923691248 11357786112 1971993376 19.401 100 54 108 1 2015226112 26966688 16266048
23:35:42 7440 8192000000 10925418160 11351818240 1968035552 19.370 100 62 122 0 2013931552 28050192 17845808
23:35:59 1580 8192000000 10939445936 11364433920 1980582928 19.469 100 74 147 0 2031286496 28584480 22119088
23:36:08 7879 8192000000 10930964640 11352989696 1971553632 19.398 100 60 120 0 2017334896 28655440 17125824
23:36:24 2251 8192000000 10940337344 11363741696 1977107248 19.442 100 78 155 1 2032952944 31603712 24241984
23:36:33 3713 8192000000 10937099536 11358212096 1973450368 19.413 100 71 137 0 2026619744 33024096 20145280
23:36:48 8509 8192000000 10929612688 11359690752 1969247600 19.379 100 71 141 2 2027100336 36223968 21628768
23:37:08 5090 8192000000 10941009760 11370831872 1977082272 19.442 100 62 124 2 2032212832 36676720 18453840
23:37:20 5237 8192000000 10923686112 11352506368 1954011280 19.258 99 51 102 1 2006801168 37192112 15597776
23:37:33 16092 8192000000 10941613648 11370311680 1973207152 19.411 100 61 122 1 2028534896 37079792 18247952
23:37:57 1852 8192000000 10972848160 11390791680 1991891536 19.559 100 82 164 1 2054170576 37826144 24452896
23:38:05 2185 8192000000 10970573712 11386662912 1989730752 19.542 100 87 174 2 2053407776 37829376 25847648
23:38:15 2036 8192000000 10963218352 11376013312 1982426800 19.484 100 88 176 1 2046907792 38681456 25799536
23:38:25 3070 8192000000 10955988560 11364134912 1957964960 19.290 99 88 176 3 2021755008 39340400 24449648
23:38:35 6142 8192000000 10923057968 11344613376 1946212864 19.196 99 72 141 0 2006749520 39780944 20755712
23:38:51 1957 8192000000 10957680176 11368751104 1976414384 19.436 100 86 173 2 2042848000 40718048 25715568
23:39:01 3092 8192000000 10959604048 11374342144 1975549808 19.429 100 85 169 1 2042009680 41731296 24728576
23:39:12 2370 8192000000 10960581360 11370328064 1961575760 19.319 99 92 184 2 2029696784 41026976 27094048
23:39:27 6314 8192000000 10951067312 11372920832 1973089728 19.410 100 68 135 0 2033872624 40144672 20638224
23:39:40 2352 8192000000 10970901760 11389288448 1986884672 19.519 100 76 150 1 2055007008 45072224 23050112
23:39:49 1622 8192000000 10978362832 11394703360 1995997584 19.591 100 87 172 1 2063133792 40857184 26279024
23:39:58 1737 8192000000 10977257632 11393003520 1993098400 19.568 100 82 164 2 2063472624 44271776 26102448
23:40:08 5676 8192000000 10970296144 11389902848 1988006096 19.528 100 77 154 1 2055585920 44242048 23337776
23:40:25 1144 8192000000 10940590816 11354693632 1957461488 19.286 99 67 134 2 2023489456 45459712 20568256
23:40:34 1823 8192000000 10981110176 11396714496 1994771296 19.581 100 90 180 3 2070980944 48392144 27817504
23:40:43 8846 8192000000 10973141904 11395543040 1986038832 19.512 100 74 148 1 2059508816 50420544 23049440
23:41:02 3260 8192000000 10989451440 11408498688 1992762896 19.566 100 77 153 2 2070087200 53551184 23773120
23:41:20 4714 8192000000 10984027200 11410694144 1976373184 19.436 99 66 132 1 2050548816 53851280 20324352
23:41:32 1492 8192000000 10972152944 11395989504 1979033472 19.457 100 58 116 1 2053608688 56051344 18523872
23:41:41 2412 8192000000 10984122528 11405385728 1990842400 19.550 100 77 151 1 2070817504 55999312 23975792
23:41:52 1969 8192000000 10991997440 11408347136 1991410144 19.555 100 76 153 0 2073516432 56974400 25131888
23:42:02 3486 8192000000 10985938432 11403042816 1967815104 19.368 99 73 145 2 2051984144 60918112 23250928
23:42:14 4546 8192000000 10988534288 11414499328 1990660272 19.549 100 68 134 2 2074930352 62545152 21724928
23:42:26 5559 8192000000 10998144448 11427131392 1999663200 19.620 100 65 130 1 2084255520 63273840 21318480
23:42:38 7302 8192000000 10972466832 11406868480 1974048112 19.418 99 52 102 2 2055235888 63894912 17292864
23:42:56 15957 8192000000 10981237296 11417595904 1988769136 19.534 100 46 90 4 2066199328 61230768 16199424
23:43:20 7619 8192000000 10969790432 11411460096 1971195712 19.395 99 46 92 0 2043614320 56611248 15807360
23:43:34 15145 8192000000 10977710960 11420061696 1989610096 19.541 100 40 80 0 2061833296 58173648 14049552
23:43:56 11269 8192000000 10986443024 11425550336 1992491536 19.563 100 44 86 2 2070068832 62118448 15458848
23:44:17 15352 8192000000 10984045792 11428626432 1994829680 19.582 100 39 78 1 2073957568 64329440 14798448
23:44:40 13149 8192000000 10975283712 11427610624 1990344096 19.547 100 40 80 1 2068021312 63246272 14430944
23:45:00 13032 8192000000 10937595488 11378438144 1929217040 19.061 98 33 66 0 2002657056 61526800 11913216
23:45:23 15205 8192000000 10937341904 11380879360 1927438176 19.046 98 41 83 0 2004179184 62495088 14245920
23:45:46 34196 8192000000 10935341264 11389255680 1961516128 19.318 100 33 66 3 2032828656 60042432 11270096
23:46:33 23477 8192000000 10909696432 11369721856 1915742000 18.953 98 23 46 1 1978210080 54465568 8002512
23:47:12 14206 8192000000 10908820288 11362574336 1932154416 19.084 99 30 60 1 1987774448 46320272 9299760
23:47:39 27082 8192000000 10892364736 11352502272 1919195360 18.980 99 23 47 2 1967012288 40690624 7126304
23:49:16 54612 8192000000 10877289248 11332800512 1894630000 18.783 99 17 35 0 1956046336 55244544 6171792
23:50:32 45686 8192000000 10860123616 11319779328 1893346208 18.773 98 16 32 1 1929237088 30973024 4917856
23:51:52 49318 8192000000 10877150336 11332300800 1909998160 18.907 99 20 40 2 1941521840 25497200 6026480
23:52:57 49205 8192000000 10875697040 11319476224 1897065680 18.803 98 25 48 1 1920244208 16375536 6802992
23:54:25 170750 8192000000 10853476640 11301187584 1849976864 18.422 96 32 59 1 1865763856 7882096 7904896
23:57:25 69286 8192000000 10874716912 11319070720 1927626592 19.048 100 38 76 1 1950678256 13323360 9728304
23:58:41 56697 8192000000 10887594080 11322933248 1927282096 19.045 99 39 76 0 1945543680 7515408 10746176
23:59:44 88678 8192000000 10909927184 11362230272 1964206336 19.339 100 34 69 2 1981727888 7879968 9641584
00:01:24 26998 8192000000 10900481888 11366223872 1966978096 19.361 100 18 36 2 1982355744 10613648 4764000
00:01:59 25508 8192000000 10926776288 11376394240 1977259696 19.443 100 31 62 0 1999524576 13484592 8780288
00:02:36 70925 8192000000 10904510176 11373813760 1974995600 19.425 100 11 22 0 1990185600 12092688 3097312
00:03:54 126418 8192000000 10907776224 11378008064 1942610304 19.168 98 16 33 0 1964637824 17536336 4491184
00:06:06 24919 8192000000 10911640192 11378737152 1973247472 19.411 100 10 20 1 2000430816 24444656 2738688
00:06:53 34118 8192000000 10911343168 11398148096 1971983552 19.401 100 8 16 1 1994597088 20243632 2369904
00:07:50 45404 8192000000 10930845984 11374215168 1965347728 19.349 99 31 62 1 1985731168 11128640 9254800
00:08:42 46887 8192000000 10918529792 11388141568 1983931312 19.496 100 17 34 2 2001004768 11819376 5254080
00:09:38 46735 8192000000 10907378832 11385655296 1966175376 19.355 99 15 30 1 1983355136 12453664 4726096
00:10:35 62103 8192000000 10890202672 11365396480 1904696096 18.864 96 27 54 2 1921981056 8782128 8502832
00:12:12 22669 8192000000 10909454080 11363241984 1957325408 19.285 99 35 69 1 1974786720 7076864 10384448
00:12:41 42011 8192000000 10886684016 11352104960 1931260464 19.077 98 18 36 0 1945474240 9235136 4978640
00:13:36 73785 8192000000 10902004080 11371212800 1915245280 18.949 97 26 52 0 1932992496 9535200 8212016
00:15:35 72516 8192000000 10887489264 11361845248 1909393584 18.902 97 8 16 0 1920135312 8780800 1960928
00:16:56 28780 8192000000 10882824448 11340132352 1870975168 18.592 95 20 40 0 1883297632 6494080 5828384
00:17:34 22622 8192000000 10878681744 11331653632 1917435376 18.966 98 19 36 1 1929919152 7693248 4790528
00:18:03 29065 8192000000 10870712784 11327447040 1877483344 18.645 96 27 54 0 1893868256 9188784 7196128
00:18:38 22652 8192000000 10895750160 11335589888 1923374128 19.014 99 36 72 0 1942461216 9014464 10072624
00:19:09 55425 8192000000 10809720464 11261808640 1845666944 18.387 95 41 82 0 1867092704 9768000 11657760
00:20:50 39153 8192000000 10848902224 11306684416 1873296320 18.611 97 19 38 0 1886781280 8597696 4887264
00:21:38 62385 8192000000 10844383200 11308388352 1886199024 18.715 98 43 86 2 1909150848 10035008 12916816
00:22:59 34391 8192000000 10850187984 11328892928 1933452560 19.094 100 27 54 1 1952808096 11354912 8000624
00:23:43 56662 8192000000 10848694192 11327918080 1897897984 18.809 98 12 25 0 1914033392 12877808 3257600
00:24:46 42811 8192000000 10837440416 11312435200 1879122512 18.658 98 6 12 0 1898148352 16796352 2229488
00:25:36 39043 8192000000 10844705040 11317891072 1915336976 18.949 100 13 26 0 1930755280 11554320 3863984
00:26:29 53155 8192000000 10841659648 11306864640 1859388448 18.498 96 16 32 0 1869956496 6137408 4430640
00:27:28 80047 8192000000 10863645776 11326656512 1845082816 18.382 95 11 22 1 1858110560 10340688 2687056
00:29:06 64291 8192000000 10859938096 11317256192 1844433504 18.377 95 13 26 0 1859771472 11650608 3687360
00:30:21 27767 8192000000 10864061168 11305848832 1852714512 18.444 96 26 52 2 1870340528 10975808 6650208
00:31:00 37268 8192000000 10875205840 11342495744 1914040208 18.939 99 34 68 1 1933575360 10056944 9478208
00:31:44 45628 8192000000 10894734480 11346235392 1921279552 18.997 99 15 30 1 1933846544 8688304 3878688
00:32:36 26362 8192000000 10899972992 11356221440 1939599376 19.144 99 46 92 1 1962061840 9741808 12720656
00:33:09 39561 8192000000 10913922704 11362357248 1939633680 19.144 99 33 66 2 1963982592 15460592 8888320
00:33:56 24139 8192000000 10892452880 11348099072 1937599152 19.128 99 32 64 0 1962823296 16236656 8987488
00:34:30 51641 8192000000 10889091504 11358060544 1929976736 19.067 99 28 56 1 1951981152 14460928 7543488
00:35:29 75757 8192000000 10882121712 11356848128 1923161072 19.012 98 21 42 1 1943284144 14555408 5567664
00:36:53 104363 8192000000 10868788960 11331133440 1823356368 18.205 93 14 28 0 1838032224 10562832 4113024
00:38:43 101097 8192000000 10880476464 11354259456 1887869184 18.729 97 16 32 0 1903119904 10811680 4439040
00:40:31 56294 8192000000 10902804400 11358924800 1920751136 18.993 98 16 30 1 1940310224 15294032 4265056
00:41:50 111712 8192000000 10860021920 11324121088 1922468336 19.007 98 17 34 0 1937483136 10212576 4802224
00:43:54 74111 8192000000 10901113840 11380461568 1972671008 19.407 100 18 36 0 1993052944 15509504 4872432
00:45:14 50723 8192000000 10899588992 11374108672 1977203424 19.443 100 20 40 1 1994850496 11716160 5930912
00:46:11 83492 8192000000 10888525824 11371679744 1958001072 19.290 99 15 31 2 1969967984 7797568 4169344
00:47:40 49863 8192000000 10908082768 11383435264 1981685872 19.478 100 13 26 1 1993705664 8318944 3700848
00:48:38 87075 8192000000 10901089760 11397287936 1971942640 19.401 99 19 38 0 1992338144 14172736 6222768
00:50:36 44721 8192000000 10884558560 11365339136 1912733552 18.929 97 7 14 1 1923920384 8585280 2601552
00:51:27 31394 8192000000 10903659088 11378438144 1971115216 19.394 100 32 64 3 1989041088 8318512 9607360
00:52:07 52514 8192000000 10899193792 11365511168 1896625024 18.799 96 15 30 0 1907410128 6825648 3959456
00:53:08 62179 8192000000 10898622144 11373842432 1959550720 19.302 99 27 55 0 1977592864 10364208 7677936
00:54:16 66584 8192000000 10906341504 11370754048 1930234416 19.069 98 13 26 0 1941765120 7652864 3877840
00:55:38 100719 8192000000 10880156720 11356381184 1859477824 18.499 94 18 36 0 1873583344 8727136 5378384
00:57:38 76700 8192000000 10918202432 11384709120 1901750976 18.840 96 24 48 3 1921448480 13057728 6639776
01:00:22 73379 8192000000 10887705152 11362594816 1917081088 18.963 97 9 18 0 1932859936 13697280 2081568
01:01:42 113763 8192000000 10900059248 11354587136 1837624336 18.321 93 15 30 1 1851596480 10121328 3850816
01:03:50 36768 8192000000 10900865392 11338821632 1893201248 18.772 97 39 78 1 1916135248 11516864 11417136
01:04:34 39978 8192000000 10898163952 11350618112 1929958480 19.067 99 46 92 0 1956031872 12742704 13330688
01:05:25 137896 8192000000 10882958256 11349352448 1919197904 18.980 98 26 52 0 1941916976 15426528 7292544
01:07:58 16257 8192000000 10875676320 11337924608 1931017760 19.075 99 21 42 1 1952039456 15196368 5825328
01:08:20 19614 8192000000 10845843744 11325575168 1899255776 18.820 98 5 10 0 1914909408 13796960 1856672
01:09:08 89990 8192000000 10841168336 11321032704 1844387616 18.377 95 15 29 2 1862258816 13341760 4529440
01:10:46 58634 8192000000 10882820896 11356532736 1934137232 19.100 100 8 16 1 1951289760 14723328 2429200
01:11:54 79838 8192000000 10866090720 11341856768 1877811456 18.647 96 14 28 1 1898401984 16383552 4206976
01:13:25 62946 8192000000 10892809040 11358019584 1917131344 18.964 99 16 32 0 1943687552 21774928 4781280
01:14:47 37782 8192000000 10852827056 11322531840 1921239312 18.997 99 12 23 0 1930464720 6394416 2830992
01:15:33 28950 8192000000 10857870448 11316289536 1908176992 18.892 98 35 68 1 1927488192 9973744 9337456
01:16:15 73438 8192000000 10882953280 11350507520 1924605376 19.024 99 20 40 0 1944299760 14345520 5348864
01:17:34 59054 8192000000 10876224624 11344060416 1877726496 18.647 96 14 29 1 1898770416 15812592 5231328
01:18:47 65938 8192000000 10843289536 11323772928 1862817952 18.526 96 22 44 0 1885094048 15444896 6831200
01:20:04 89412 8192000000 10852161216 11330908160 1888152560 18.731 98 18 36 1 1906872944 14096160 4624224
01:21:42 27050 8192000000 10864940064 11319431168 1900278432 18.829 98 32 65 0 1918675888 9139856 9257600
01:22:19 19198 8192000000 10893506656 11335000064 1916469120 18.959 99 58 114 3 1945188560 11609664 17109776
01:23:23 91535 8192000000 10844862720 11321298944 1831673008 18.273 95 13 26 0 1851281264 16149952 3458304
01:25:04 68338 8192000000 10876482288 11345780736 1934436992 19.102 100 23 44 2 1950374000 9910752 6026256
01:26:19 73077 8192000000 9906122240 10278084608 1025098000 11.121 53 5 10 0 1038705488 12199616 1407872

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 22-12-2020 01:29:06 to 22-12-2020 01:29:36.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 22-12-2020 01:29:37 to 22-12-2020 01:29:38.

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          259704
MON$OLDEST_ACTIVE               260375
MON$OLDEST_SNAPSHOT             260375
MON$NEXT_TRANSACTION            260375
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                       2038880
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:209: 
:210: mscs-test-161.budzdorov.ru    Tue Dec 22 01:27:45 2020
:211:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:212: 
:213: 
:214: mscs-test-161.budzdorov.ru    Tue Dec 22 01:27:47 2020
:215:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:216: 
:217: 
:218: mscs-test-161.budzdorov.ru    Tue Dec 22 01:27:48 2020
:219:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:220: 
--- end of diff output ---

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

22.12.20 01:29:40. 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
2020-12-22 01:29:42 No severe PSQL-related problems occured
22.12.20 01:29:43. End of report.