Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.12.2020 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 17248384 kB
MemAvailable 31464816 kB
Buffers 0 kB
Cached 14404472 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-19 22:27:03
DTS_END                         2020-12-19 22:27:03.9420
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/45238
TRN_ID                          258328
ATT_ID                          736
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: 10069.22 22245 1208306
customer order: creation 188.16 324 22579
customer order: refuse 16.43 236 1972
order to supplier: creation 50.16 1128 6019
order to supplier: removal 3.66 83277 439
invoice (draft): creation 50.54 2910 6065
invoice (draft): removal 55.85 695 6702
invoice accept: apply 46.27 17934 5552
invoice accept: cancel 49.83 678 5980
customer reserve: creation 4377.13 175 525256
customer reserve: removal 4910.22 49 589226
realization accept: apply 92.75 162 11130
realization accept: cancel 86.58 98 10390
payment from customer: creation 64.18 93 7701
payment from customer: removal 6.27 67 752
payment to supplier: creation 54.02 115 6482
payment to supplier: removal 3.75 87 450
service: total inventory turnovers 5.11 1111 613
service: total monetary turnovers 7.32 41 878
service: aggregate perf. data 0.97 15772 116
service: refresh index statistics 0.03 319956 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-12-2020 22:27:41 to 19-12-2020 22:27:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5194
TEST_TIME 2 4659
TEST_TIME 3 5518
TEST_TIME 4 5521
TEST_TIME 5 6034
TEST_TIME 6 6835
TEST_TIME 7 7187
TEST_TIME 8 7250
TEST_TIME 9 7427
TEST_TIME 10 7610
TEST_TIME 11 7917
TEST_TIME 12 7955
TEST_TIME 13 8321
TEST_TIME 14 8778
TEST_TIME 15 9508
TEST_TIME 16 9923
TEST_TIME 17 10169
TEST_TIME 18 10315
TEST_TIME 19 10682
TEST_TIME 20 11114
TEST_TIME 21 12525
TEST_TIME 22 12700
TEST_TIME 23 12698
TEST_TIME 24 12662
TEST_TIME 25 12351
TEST_TIME 26 12391
TEST_TIME 27 12464
TEST_TIME 28 12302
TEST_TIME 29 12101
TEST_TIME 30 11748
TEST_TIME 31 11685
TEST_TIME 32 11800
TEST_TIME 33 11636
TEST_TIME 34 11513
TEST_TIME 35 11475
TEST_TIME 36 11371
TEST_TIME 37 11192
TEST_TIME 38 11264
TEST_TIME 39 11095
TEST_TIME 40 11124
TEST_TIME 41 11156
TEST_TIME 42 11209
TEST_TIME 43 11247
TEST_TIME 44 11259
TEST_TIME 45 11146
TEST_TIME 46 11175
TEST_TIME 47 11172
TEST_TIME 48 11150
TEST_TIME 49 11117
TEST_TIME 50 11154
TEST_TIME 51 11152
TEST_TIME 52 11037
TEST_TIME 53 10897
TEST_TIME 54 10812
TEST_TIME 55 10794
TEST_TIME 56 10730
TEST_TIME 57 10637
TEST_TIME 58 10606
TEST_TIME 59 10525
TEST_TIME 60 10641
TEST_TIME 61 10610
TEST_TIME 62 10538
TEST_TIME 63 10554
TEST_TIME 64 10648
TEST_TIME 65 10633
TEST_TIME 66 10621
TEST_TIME 67 10629
TEST_TIME 68 10701
TEST_TIME 69 10735
TEST_TIME 70 10667
TEST_TIME 71 10705
TEST_TIME 72 10700
TEST_TIME 73 10680
TEST_TIME 74 10782
TEST_TIME 75 10744
TEST_TIME 76 10617
TEST_TIME 77 10601
TEST_TIME 78 10526
TEST_TIME 79 10542
TEST_TIME 80 10459
TEST_TIME 81 10386
TEST_TIME 82 10367
TEST_TIME 83 10278
TEST_TIME 84 10370
TEST_TIME 85 10341
TEST_TIME 86 10303
TEST_TIME 87 10310
TEST_TIME 88 10379
TEST_TIME 89 10335
TEST_TIME 90 10341
TEST_TIME 91 10312
TEST_TIME 92 10373
TEST_TIME 93 10363
TEST_TIME 94 10389
TEST_TIME 95 10347
TEST_TIME 96 10459
TEST_TIME 97 10445
TEST_TIME 98 10393
TEST_TIME 99 10298
TEST_TIME 100 10278
TEST_TIME 101 10276
TEST_TIME 102 10228
TEST_TIME 103 10227
TEST_TIME 104 10228
TEST_TIME 105 10184
TEST_TIME 106 10134
TEST_TIME 107 10091
TEST_TIME 108 10141
TEST_TIME 109 10130
TEST_TIME 110 10107
TEST_TIME 111 10107
TEST_TIME 112 10099
TEST_TIME 113 10133
TEST_TIME 114 10099
TEST_TIME 115 10119
TEST_TIME 116 10088
TEST_TIME 117 10107
TEST_TIME 118 10118
TEST_TIME 119 10149
TEST_TIME 120 10073

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-12-2020 22:27:45 to 19-12-2020 22:27:48.

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 1692584 1692584 0 0.00 0 22274 7 0 0
doc_list_biud 1692584 1692584 0 0.00 0 89171 22 0 0
sp_add_invoice_to_stock 5698 5552 146 2.56 18 162291 17935 0 146
sp_cancel_adding_invoice 5980 5980 0 0.00 6 64435 679 0 0
sp_cancel_client_order 1972 1972 0 0.00 4 9904 236 0 0
sp_cancel_customer_reserve 589226 589226 0 0.00 1 50121 50 0 0
sp_cancel_pay_from_customer 752 752 0 0.00 2 7640 68 0 0
sp_cancel_pay_to_supplier 450 450 0 0.00 3 8151 87 0 0
sp_cancel_supplier_invoice 6712 6702 10 0.14 2 97559 696 0 10
sp_cancel_supplier_order 439 439 0 0.00 8 1066228 83278 0 0
sp_cancel_write_off 10390 10390 0 0.00 1 7760 98 0 0
sp_client_order 22579 22579 0 0.00 3 33444 324 0 0
sp_customer_reserve 525256 525256 0 0.00 0 99110 176 0 0
sp_fill_shopping_cart 34639 34639 0 0.00 1 9805 32 0 0
sp_fill_shopping_cart_clo_res 525242 525242 0 0.00 0 30453 12 0 0
sp_get_clo_for_invoice 5533 5533 0 0.00 0 28303 235 0 0
sp_kill_cost_storno 17572 17572 0 0.00 0 7409 41 0 0
sp_kill_qstorno_ret_qs2qd 1195983 1195983 0 0.00 0 89169 27 0 0
sp_kill_qty_storno 631370 631370 0 0.00 0 89170 58 0 0
sp_lock_selected_doc 23021 23021 0 0.00 0 8143 8 0 0
sp_make_cost_storno 30844 30844 0 0.00 0 15879 46 0 0
sp_multiply_rows_for_pdistr 30844 30844 0 0.00 0 22224 23 0 0
sp_multiply_rows_for_qdistr 22579 22579 0 0.00 0 19856 149 0 0
sp_pay_from_customer 7701 7701 0 0.00 4 15207 94 0 0
sp_pay_to_supplier 6482 6482 0 0.00 5 22280 115 0 0
sp_payment_common 14183 14183 0 0.00 1 11344 22 0 0
sp_qd_handle_on_cancel_clo 1972 1972 0 0.00 0 9893 208 0 0
sp_qd_handle_on_invoice_upd_sts 11511 11511 0 0.00 0 27452 257 0 0
sp_qd_handle_on_reserve_upd_sts 11130 11130 0 0.00 0 21840 47 0 0
sp_reserve_write_off 11130 11130 0 0.00 6 22191 163 0 0
sp_supplier_invoice 6065 6065 0 0.00 6 98555 2911 0 0
sp_supplier_order 6019 6019 0 0.00 5 44938 1129 0 0
srv_aggregate_perf_data 116 116 0 0.00 3237 125317 15773 0 0
srv_fill_mon_cache_memory 150 150 0 0.00 1304 138170 36118 0 0
srv_find_qd_qs_mism 1154300 1154300 0 0.00 0 10819 7 0 0
srv_make_invnt_saldo 613 613 0 0.00 35 98498 1111 0 0
srv_make_money_saldo 878 878 0 0.00 1 10889 42 0 0
srv_recalc_idx_stat 4 4 0 0.00 216757 429850 319956 0 0
t$perf-abend:sp_add_invoice_to_stock 146 146 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5552 5552 0 0.00 0 13353 129 0 0
t$perf-norm:sp_cancel_adding_invoice 484 484 0 0.00 0 9437 91 0 0
t$perf-norm:sp_cancel_client_order 1972 1972 0 0.00 0 5848 12 0 0
t$perf-norm:sp_cancel_customer_reserve 735 735 0 0.00 0 4837 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 752 752 0 0.00 0 1310 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 450 450 0 0.00 0 197 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 441 441 0 0.00 0 635 11 0 0
t$perf-norm:sp_cancel_supplier_order 439 439 0 0.00 0 14928 1174 0 0
t$perf-norm:sp_cancel_write_off 1090 1090 0 0.00 0 1350 6 0 0
t$perf-norm:sp_client_order 22579 22579 0 0.00 0 8226 11 0 0
t$perf-norm:sp_customer_reserve 1185 1185 0 0.00 0 2630 8 0 0
t$perf-norm:sp_pay_from_customer 7701 7701 0 0.00 0 4232 8 0 0
t$perf-norm:sp_pay_to_supplier 6482 6482 0 0.00 0 7994 10 0 0
t$perf-norm:sp_reserve_write_off 11130 11130 0 0.00 0 3901 9 0 0
t$perf-norm:sp_supplier_invoice 6065 6065 0 0.00 0 9817 13 0 0
t$perf-norm:sp_supplier_order 6019 6019 0 0.00 0 4433 11 0 0
t$perf-norm:srv_aggregate_perf_data 116 116 0 0.00 0 398 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 150 150 0 0.00 0 363 4 0 0
t$perf-norm:srv_make_invnt_saldo 613 613 0 0.00 0 868 7 0 0
t$perf-norm:srv_make_money_saldo 878 878 0 0.00 0 503 5 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 4 3 0 0
v_add_invoice_to_stock 11348 11056 292 2.57 0 21207 21 0 292
v_all_customers 40788 40788 0 0.00 0 38 0 0 0
v_all_suppliers 33958 33958 0 0.00 0 28 1 0 0
v_all_wares 45158 45158 0 0.00 0 62 1 0 0
v_cancel_adding_invoice 968 968 0 0.00 0 3000 9 0 0
v_cancel_client_order 3944 3944 0 0.00 0 3102 3 0 0
v_cancel_customer_prepayment 1504 1504 0 0.00 0 3484 6 0 0
v_cancel_customer_reserve 1470 1470 0 0.00 0 2579 9 0 0
v_cancel_payment_to_supplier 900 900 0 0.00 0 4125 7 0 0
v_cancel_supplier_invoice 902 882 20 2.21 0 8346 26 0 20
v_cancel_supplier_order 878 878 0 0.00 0 3604 9 0 0
v_cancel_write_off 2180 2180 0 0.00 0 4586 19 0 0
v_max_id_clo_ord 6019 6019 0 0.00 0 656 1 0 0
v_max_id_clo_res 1185 1185 0 0.00 0 1797 8 0 0
v_max_id_ord_sup 6041 6041 0 0.00 0 5876 4 0 0
v_max_non_paid_invoice 1563 1563 0 0.00 0 2056 5 0 0
v_max_non_paid_realizn 4170 4170 0 0.00 0 3351 3 0 0
v_min_id_clo_ord 6019 6019 0 0.00 0 2357 4 0 0
v_min_id_clo_res 1185 1185 0 0.00 0 4984 11 0 0
v_min_id_ord_sup 6041 6041 0 0.00 0 7119 8 0 0
v_min_non_paid_invoice 6482 6482 0 0.00 0 4968 12 0 0
v_min_non_paid_realizn 7701 7701 0 0.00 0 11338 13 0 0
v_our_firm 11432 11432 0 0.00 0 19 1 0 0
v_reserve_write_off 22260 22260 0 0.00 0 20811 11 0 0
x_lock_depdocs_on_canc_invoice 12241 12241 0 0.00 0 30253 106 0 0
x_lock_depdocs_on_canc_sup_ord 439 439 0 0.00 0 10330 256 0 0
x_make_qstorno_1000_1200 6019 6019 0 0.00 1 44897 1071 0 0
x_make_qstorno_1200_2000 6065 6065 0 0.00 2 98485 2782 0 0
x_make_qstorno_2100_3300 525256 525256 0 0.00 0 99109 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-12-2020 22:27:49 to 19-12-2020 22:27:53.

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:07 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:14 17272 8192000000 10255789040 10560532480 942960000 10.322 73 50 100 0 961670080 2667840 16042240
19:57:38 18152 8192000000 10334586528 10651783168 1382124240 14.436 100 85 170 0 1414286352 4439776 27722336
19:58:06 29770 8192000000 10391598288 10713264128 1430255232 14.864 100 89 177 2 1465268928 6301344 28712352
19:58:44 20959 8192000000 10411704384 10737795072 1461858000 15.142 100 96 192 0 1500449616 7479216 31112400
19:59:17 17360 8192000000 10428293376 10758569984 1482287248 15.321 100 91 182 1 1519874448 8266592 29320608
19:59:44 32138 8192000000 10442117008 10777493504 1493011728 15.415 100 90 180 0 1530338912 8492192 28834992
20:00:27 17262 8192000000 10453486336 10789339136 1506764704 15.535 100 82 164 1 1541965312 9022848 26177760
20:00:54 22051 8192000000 10485114752 10824011776 1534420432 15.775 100 88 176 2 1572404656 9968000 28016224
20:01:28 11761 8192000000 10514474272 10861064192 1558997440 15.988 100 76 152 0 1592876272 9885840 23992992
20:01:49 12977 8192000000 10544160080 10898911232 1588193168 16.238 100 78 156 2 1622263136 10065248 24004720
20:02:10 12780 8192000000 10567102608 10923683840 1620308720 16.513 100 83 166 1 1656088448 10641408 25138320
20:02:34 9968 8192000000 10587700976 10945736704 1642808192 16.704 100 81 163 3 1677347840 10968768 23570880
20:02:53 7622 8192000000 10597610816 10965671936 1655290864 16.809 100 75 148 3 1688887504 11296816 22299824
20:03:15 9518 8192000000 10628084960 10999439360 1694189584 17.136 100 74 148 1 1727417680 11795984 21432112
20:03:32 7667 8192000000 10647717888 11021340672 1709543328 17.265 100 76 152 2 1744340976 12825632 21972016
20:03:48 6867 8192000000 10659205328 11039043584 1730605344 17.441 100 85 169 2 1768480784 13210112 24665328
20:04:02 7694 8192000000 10670134752 11049455616 1734393360 17.472 100 79 156 0 1769937792 12787184 22757248
20:04:17 4824 8192000000 10695928080 11072798720 1756586656 17.656 100 78 156 2 1790855808 12564336 21704816
20:04:30 4845 8192000000 10703473232 11082055680 1766437488 17.738 100 81 160 3 1802309392 13198960 22672944
20:04:42 3862 8192000000 10711942352 11092025344 1771311648 17.778 100 74 142 0 1802807104 11802864 19692592
20:04:53 4404 8192000000 10720702640 11106541568 1785555776 17.895 100 78 154 0 1820495264 12742480 22197008
20:05:04 8385 8192000000 10714780208 11103399936 1788025520 17.916 100 70 138 2 1820212960 12897728 19289712
20:05:19 2890 8192000000 10742760800 11125948416 1805309008 18.057 100 78 156 0 1839547216 12777616 21460592
20:05:28 2608 8192000000 10748071040 11137507328 1811033360 18.104 100 79 156 1 1846377584 13057328 22286896
20:05:37 2335 8192000000 10751299744 11145756672 1820584064 18.182 100 85 169 3 1857453376 12731984 24137328
20:05:46 2151 8192000000 10761988304 11147493376 1826480080 18.231 100 82 161 2 1862055744 12583568 22992096
20:05:55 1875 8192000000 10768424240 11154399232 1830522880 18.264 100 86 172 1 1868437696 14104080 23810736
20:06:03 2165 8192000000 10777177280 11158831104 1832030608 18.276 100 91 183 0 1871922304 15017488 24874208
20:06:12 2069 8192000000 10781565232 11168436224 1837418160 18.320 100 83 165 1 1874651456 13418016 23815280
20:06:20 2204 8192000000 10796499760 11179737088 1844884432 18.381 100 90 180 2 1883719472 13608096 25226944
20:06:29 2244 8192000000 10796144352 11182325760 1853170272 18.448 100 98 196 2 1894053360 14277488 26605600
20:06:37 1120 8192000000 10801553152 11187339264 1853336416 18.449 100 95 191 2 1892627552 13324880 25966256
20:06:45 1575 8192000000 10801745632 11190198272 1859262688 18.497 100 91 182 2 1897510672 12656576 25591408
20:06:52 1141 8192000000 10800624032 11191877632 1856053728 18.471 100 91 181 0 1894991216 12747056 26190432
20:07:00 1913 8192000000 10803384928 11193163776 1861228272 18.513 100 96 193 2 1902234064 13160352 27845440
20:07:08 1635 8192000000 10809429808 11198021632 1864631232 18.541 100 95 189 1 1905909600 14179760 27098608
20:07:16 1661 8192000000 10816994752 11205591040 1872574176 18.605 100 91 182 0 1911605984 13061392 25970416
20:07:24 28205 8192000000 10789114688 11204575232 1868143760 18.569 100 63 126 3 1898269360 12246208 17879392
20:07:59 6274 8192000000 10768289264 11197558784 1864687152 18.541 100 29 58 4 1879938752 7103920 8147680
20:08:14 6710 8192000000 10780321360 11204976640 1868310592 18.571 100 31 62 2 1883594736 6193888 9090256
20:08:27 6090 8192000000 10792234144 11208163328 1874294464 18.619 100 43 87 2 1894850928 8899552 11656912
20:08:44 4004 8192000000 10789694576 11209289728 1872544208 18.605 100 34 68 1 1889675072 8032464 9098400
20:08:55 11207 8192000000 10787334592 11207925760 1872679584 18.606 100 24 48 0 1885814640 6340384 6794672
20:09:16 8704 8192000000 10788229264 11218173952 1879456480 18.661 100 29 58 2 1894727024 7480224 7790320
20:09:31 7891 8192000000 10790790224 11219963904 1878997104 18.657 100 24 48 2 1891975776 5836480 7142192
20:09:46 10108 8192000000 10789555600 11222081536 1882128656 18.682 100 19 38 2 1893951664 6497568 5325440
20:10:05 7609 8192000000 10790930016 11224072192 1884522304 18.702 100 14 28 2 1894632896 5765632 4344960
20:10:19 9467 8192000000 10794192800 11229265920 1888213120 18.731 100 25 50 1 1903289856 7219024 7857712
20:10:39 35032 8192000000 10802554912 11238227968 1890593232 18.751 100 27 54 2 1903940160 5385648 7961280
20:11:46 35378 8192000000 10819244848 11249864704 1891942976 18.761 100 20 38 3 1906813824 9445040 5425808
20:12:29 5882 8192000000 10818947776 11249737728 1895295840 18.788 100 32 64 3 1915469152 11318576 8854736
20:12:43 4910 8192000000 10811537632 11243843584 1898132672 18.811 100 40 80 2 1917342448 7251040 11958736
20:12:55 5318 8192000000 10809956256 11249123328 1899843088 18.825 100 25 50 3 1913904112 6830976 7230048
20:13:09 7549 8192000000 10816691888 11252281344 1905053424 18.867 100 33 66 2 1920841584 6257392 9530768
20:13:23 8248 8192000000 10816669920 11258011648 1903987424 18.858 100 12 24 0 1913190080 5703152 3499504
20:13:41 9195 8192000000 10820415984 11257823232 1906358752 18.877 100 10 21 0 1915072864 5734400 2979712
20:13:57 10661 8192000000 10821368496 11261718528 1910020192 18.907 100 23 46 4 1922669280 5890000 6759088
20:14:15 8187 8192000000 10814132688 11256733696 1904433936 18.862 100 12 24 0 1913486160 5707296 3344928
20:14:29 10998 8192000000 10817547856 11260395520 1906546160 18.879 100 24 46 3 1923489776 10121760 6821856
20:14:47 9792 8192000000 10831874880 11269464064 1912653088 18.928 100 21 42 3 1923750032 5150288 5946656
20:15:03 6772 8192000000 10822990688 11259719680 1895197104 18.788 99 23 46 0 1907435728 5548704 6689920
20:15:17 10561 8192000000 10808189184 11247763456 1870034864 18.585 98 14 28 2 1879831904 5320816 4476224
20:15:34 27765 8192000000 10812521248 11251970048 1902671712 18.848 100 27 54 1 1916896560 6104192 8120656
20:16:12 50389 8192000000 10740659664 11172331520 1705966720 17.235 90 27 54 0 1718858336 5009008 7882608
20:17:10 11845 8192000000 10737440704 11157389312 1763348464 17.712 95 17 33 2 1772911632 5401648 4161520
20:17:29 5883 8192000000 10732840512 11161997312 1819579936 18.174 100 26 52 1 1834557056 7307728 7669392
20:17:41 4311 8192000000 10723787280 11144347648 1764436064 17.721 97 25 50 0 1778456704 6502560 7518080
20:17:53 5900 8192000000 10742581328 11156156416 1777556928 17.829 97 38 76 0 1795404816 6818160 11029728
20:18:10 8438 8192000000 10733613952 11155697664 1780781456 17.856 97 33 66 3 1796764624 5866128 10117040
20:18:25 6740 8192000000 10700623216 11125010432 1753330176 17.629 97 20 40 3 1764587568 5216208 6041184
20:18:38 5908 8192000000 10703903296 11119595520 1767575776 17.747 98 29 59 2 1780875856 4747024 8553056
20:18:51 7033 8192000000 10704152592 11127234560 1782231744 17.868 99 22 42 1 1794213008 5827136 6154128
20:19:04 13039 8192000000 10690513856 11109261312 1692294992 17.121 94 18 36 3 1703296496 5348304 5653200
20:19:24 9230 8192000000 10702706320 11116781568 1757253136 17.662 98 28 56 3 1771595792 5319872 9022784
20:19:48 6156 8192000000 10683159040 11099131904 1746663968 17.574 98 31 62 0 1761999616 5231680 10103968
20:20:01 8545 8192000000 10723479584 11136974848 1774797232 17.807 99 34 67 2 1790519776 5295488 10427056
20:20:16 5077 8192000000 10728667616 11134623744 1787888656 17.914 99 32 64 0 1803204800 5877312 9438832
20:20:31 9111 8192000000 10726089680 11151740928 1815440800 18.140 100 15 31 1 1825307120 5706800 4159520
20:20:48 15465 8192000000 10742731632 11165536256 1813060000 18.121 99 32 62 3 1828063296 5590384 9412912
20:21:52 14977 8192000000 10744892768 11168079872 1819295280 18.172 99 17 32 1 1830518432 4782016 6441136
20:22:15 9220 8192000000 10726901040 11158728704 1791440464 17.944 98 16 31 1 1801576928 5509216 4627248
20:22:36 6518 8192000000 10766254336 11186954240 1842488192 18.361 100 28 56 3 1856888320 6233168 8166960
20:22:49 5731 8192000000 10765916896 11191148544 1847265488 18.400 100 27 54 1 1860075232 4900064 7909680
20:23:02 9804 8192000000 10776150112 11203338240 1857834128 18.486 100 27 54 2 1871861888 6293232 7734528
20:23:20 11642 8192000000 10768740736 11197480960 1842447664 18.361 99 23 46 1 1854696752 5003408 7245680
20:23:40 7738 8192000000 10786531424 11210477568 1862492864 18.523 100 24 48 1 1875774608 6062544 7219200
20:23:57 12278 8192000000 10781648624 11211341824 1869834144 18.583 100 27 54 1 1883016304 5479968 7702192
20:24:15 9171 8192000000 10787977744 11220172800 1873189168 18.610 100 26 51 2 1886839616 5374928 8275520
20:24:30 9341 8192000000 10783360032 11217760256 1876113072 18.634 100 30 60 5 1890692512 5075040 9504400
20:24:51 15784 8192000000 10786296672 11223023616 1875027840 18.625 100 15 30 0 1884871200 5670752 4172608
20:25:13 9327 8192000000 10794391328 11222290432 1877948864 18.649 100 23 46 1 1889942176 5046192 6947120
20:25:30 11444 8192000000 10797357200 11224985600 1879936880 18.665 100 16 32 1 1889661520 5421616 4303024
20:25:48 10800 8192000000 10790119408 11224678400 1882194576 18.683 100 12 24 2 1890849136 5038240 3616320
20:26:08 75673 8192000000 10821778592 11240673280 1889030368 18.738 100 47 94 1 1908502336 5709264 13762704
20:27:52 72505 8192000000 10840253136 11272704000 1916795952 18.961 100 31 60 4 1935043168 9661248 8585968
20:29:11 11662 8192000000 10870512544 11291222016 1933202032 19.092 100 39 78 1 1954924160 10819376 10902752
20:29:39 16206 8192000000 10867842432 11300093952 1941509104 19.159 100 48 94 0 1967714544 12745600 13459840
20:30:14 15672 8192000000 10876062320 11309580288 1949616544 19.223 100 42 80 2 1973559040 11828480 12114016
20:30:46 16140 8192000000 10891770192 11325861888 1956371936 19.277 100 38 76 4 1980756784 13100560 11284288
20:31:11 8957 8192000000 10898254208 11327619072 1969838976 19.384 100 61 118 2 2000946384 13540208 17567200
20:31:28 17430 8192000000 10911583248 11343458304 1976496064 19.437 100 49 97 4 2006306080 15400656 14409360
20:31:57 13232 8192000000 10909117072 11341426688 1974944288 19.425 100 42 84 1 2002755568 14581520 13229760
20:32:19 16071 8192000000 10896862624 11334578176 1957324784 19.285 99 29 56 1 1981630912 15542832 8763296
20:32:45 15668 8192000000 10931148240 11357974528 1984538464 19.501 100 54 108 0 2019289248 17575376 17175408
20:33:12 8105 8192000000 10930729664 11365429248 1987875488 19.527 100 57 114 2 2023102992 17825088 17402416
20:33:32 7967 8192000000 10938986064 11370098688 1995327568 19.586 100 57 112 0 2031229424 18678128 17223728
20:33:52 8335 8192000000 10943524288 11377790976 1997093632 19.600 100 49 98 0 2029345392 17590000 14661760
20:34:09 8091 8192000000 10936931488 11372888064 1996759728 19.597 100 45 89 3 2024450304 14476816 13213760
20:34:27 16167 8192000000 10923373200 11370569728 1978581600 19.453 99 39 77 0 2004332608 14160640 11590368
20:34:54 10003 8192000000 10937520176 11376873472 1986201216 19.514 99 48 94 1 2018614512 17959344 14453952
20:35:12 7831 8192000000 10935652112 11370979328 1992679904 19.565 100 54 108 3 2028511008 19522176 16308928
20:35:30 14376 8192000000 10962118368 11395108864 2011629392 19.714 100 59 118 1 2049012480 19970080 17413008
20:35:51 1944 8192000000 10976117520 11392667648 1999308016 19.617 99 66 130 1 2039450784 21764496 18378272
20:36:00 14406 8192000000 10964539056 11391926272 2003434688 19.650 100 62 122 1 2044104880 23143456 17526736
20:36:22 5057 8192000000 10953888896 11379998720 1987554592 19.524 99 67 132 3 2031611088 24206848 19849648
20:36:36 2478 8192000000 10973823856 11399770112 2011477008 19.713 100 65 130 1 2056830912 25920416 19433488
20:36:46 2381 8192000000 10959124640 11377786880 1996168624 19.593 99 73 146 1 2044566544 26106240 22291680
20:36:56 2195 8192000000 10977722640 11394150400 2008146944 19.687 100 80 159 0 2055261952 23793520 23321488
20:37:06 1411 8192000000 10981239488 11397054464 2012888800 19.724 100 77 154 1 2061601792 25780208 22932784
20:37:15 2137 8192000000 10976316656 11393880064 2010035328 19.702 100 87 171 2 2062311856 26931072 25345456
20:37:23 3703 8192000000 10963671296 11389366272 2003522512 19.651 100 75 150 2 2053709984 27840480 22346992
20:37:35 6774 8192000000 10965917552 11390029824 2006548720 19.674 100 79 157 1 2060199872 28467760 25183392
20:37:48 3631 8192000000 10937569712 11359150080 1950532256 19.231 98 63 124 0 2000108528 30290080 19286192
20:38:00 4929 8192000000 10937921360 11366191104 1976403504 19.436 100 64 123 0 2026173440 30353872 19416064
20:38:12 4291 8192000000 10942290400 11371814912 1979767216 19.463 100 55 108 1 2027679072 31137808 16774048
20:38:25 7558 8192000000 10957304464 11378528256 1986271120 19.514 100 70 138 2 2039504288 31167440 22065728
20:38:40 7707 8192000000 10960089200 11388076032 1992003664 19.560 100 66 132 0 2045034112 33034912 19995536
20:39:00 3661 8192000000 10964570944 11387334656 1991272592 19.554 100 57 114 1 2039193168 30566272 17354304
20:39:11 2502 8192000000 10949170080 11375001600 1977902448 19.448 99 75 150 0 2032087760 31019520 23165792
20:39:21 2851 8192000000 10973278848 11388166144 1992835792 19.566 100 76 148 3 2047809504 32180688 22793024
20:39:34 2550 8192000000 10962748528 11382980608 1986932128 19.520 100 80 159 2 2045905056 34826720 24146208
20:39:43 2741 8192000000 10968704272 11389992960 1976537872 19.437 99 76 148 3 2038442112 37964208 23940032
20:39:53 1945 8192000000 10964099104 11379388416 1980834752 19.471 100 74 148 0 2043075440 39161088 23079600
20:40:02 6417 8192000000 10969687536 11390857216 1985845184 19.511 100 75 150 0 2048598880 39471984 23281712
20:40:16 2918 8192000000 10965063312 11389341696 1986881984 19.519 100 74 148 1 2054067040 43943424 23241632
20:40:27 2857 8192000000 10958339776 11376496640 1976661632 19.438 100 79 159 1 2044607568 43177600 24768336
20:40:37 2333 8192000000 10951663600 11362639872 1955562672 19.271 99 90 181 0 2028187216 44365744 28258800
20:40:47 1303 8192000000 10922234800 11337441280 1924805904 19.025 99 76 147 1 1992492976 44751184 22935888
20:40:55 5119 8192000000 10932634064 11351773184 1946409024 19.198 100 68 134 3 2012631408 45266752 20955632
20:41:07 4894 8192000000 10917401680 11354943488 1946606576 19.199 100 43 86 2 2006703824 45642192 14455056
20:41:21 3990 8192000000 10931395264 11355770880 1952709952 19.248 100 62 125 1 2015045776 42812576 19523248
20:41:32 2222 8192000000 10944758384 11354632192 1952426912 19.246 100 73 149 1 2023202288 46898032 23877344
20:41:40 7616 8192000000 10928581232 11365244928 1957963616 19.290 100 42 84 0 2020842288 48957088 13921584
20:42:06 17495 8192000000 10923009520 11360071680 1920195248 18.988 98 38 76 2 1981730208 48179456 13355504
20:42:30 18044 8192000000 10928035920 11362586624 1936205024 19.116 99 40 80 1 1997085184 46506592 14373568
20:43:01 10636 8192000000 10912251216 11348049920 1900290128 18.829 97 41 82 0 1959689728 45826912 13572688
20:43:21 14037 8192000000 10904344080 11349843968 1924374768 19.022 99 32 64 0 1980015008 44824000 10816240
20:43:59 8987 8192000000 10916113440 11349561344 1927511424 19.047 99 44 88 2 1989186928 47559232 14116272
20:44:18 9455 8192000000 10934017168 11364794368 1953929936 19.258 100 55 110 1 2019636544 48481344 17225264
20:44:34 16134 8192000000 10896701280 11345592320 1916645744 18.960 99 29 58 7 1977351280 50561360 10144176
20:44:56 13746 8192000000 10915175088 11358232576 1938464688 19.135 100 32 63 1 2002913232 54106768 10341776
20:45:17 29357 8192000000 10882520064 11325726720 1846063264 18.390 95 30 60 0 1907049184 50520496 10465424
20:45:53 22546 8192000000 10874177104 11316248576 1877406080 18.644 98 26 52 0 1936521248 49823808 9291360
20:46:22 35912 8192000000 10879460560 11321335808 1876984704 18.641 98 32 64 1 1943049136 55328432 10736000
20:47:04 27329 8192000000 10848458512 11288879104 1836198160 18.310 97 27 54 0 1894556720 48437744 9920816
20:47:45 20211 8192000000 10850823248 11293892608 1862889456 18.527 99 26 51 0 1920302256 48427136 8985664
20:48:16 24124 8192000000 10839528560 11296796672 1884893424 18.705 100 23 46 3 1941188752 47852976 8442352
20:48:50 21838 8192000000 10831254704 11295019008 1891437184 18.757 100 11 22 0 1922413584 27324544 3651856
20:49:31 90198 8192000000 10858934080 11326001152 1894169824 18.779 99 14 29 2 1925965440 28306912 3488704
20:51:15 70232 8192000000 10866564128 11310522368 1899029600 18.818 98 17 34 0 1922374880 18607616 4737664
20:52:37 66695 8192000000 10878171920 11337625600 1939437856 19.142 100 30 60 2 1960853936 12970240 8445840
20:54:12 70779 8192000000 10870935296 11328548864 1925274912 19.029 99 8 16 1 1943646496 16366064 2005520
20:55:49 33142 8192000000 10891366752 11333398528 1951597376 19.239 100 40 77 2 1970679584 7794896 11287312
20:56:29 111201 8192000000 10889542480 11348189184 1933854496 19.098 99 27 52 2 1952378416 10659424 7864496
20:58:34 71613 8192000000 10878134592 11353956352 1925950528 19.034 98 23 44 0 1944416464 12275296 6190640
20:59:52 101346 8192000000 10896674880 11356114944 1952723440 19.248 99 30 60 1 1968337888 7499552 8114896
21:01:42 12984 8192000000 10930974192 11372335104 1963434256 19.333 99 53 106 0 1987355728 8949312 14972160
21:02:01 24292 8192000000 10923852640 11381293056 1987088640 19.521 100 52 104 2 2017037376 15469744 14478992
21:02:35 36168 8192000000 10917957728 11379109888 1983857280 19.495 100 35 70 3 2008945280 15135136 9952864
21:03:22 135367 8192000000 10931133088 11396251648 1974932976 19.425 99 14 28 0 1996324592 17168224 4223392
21:05:47 42262 8192000000 10908788208 11379806208 1969803024 19.384 99 11 22 2 1996481040 23046768 3631248
21:06:36 46152 8192000000 10920714432 11390877696 1981071728 19.473 100 14 28 0 2001833360 16199424 4562208
21:07:35 53971 8192000000 10915336672 11397210112 1987191856 19.522 100 14 28 1 2008900176 17090112 4618208
21:08:36 78171 8192000000 10935135776 11416530944 1973388336 19.412 99 21 40 0 1996002768 16821296 5793136
21:10:13 42573 8192000000 10937493760 11415023616 1996583696 19.596 100 15 30 0 2020841632 20145504 4112432
21:11:08 72862 8192000000 10935461488 11394093056 1971937792 19.401 99 12 24 0 2002228720 27040512 3250416
21:12:31 28699 8192000000 10954741808 11393941504 1982857712 19.487 99 54 107 0 2009569280 10866544 15845024
21:13:08 15997 8192000000 10938513984 11399380992 1996913488 19.598 100 36 72 0 2021242112 14629088 9699536
21:13:30 20814 8192000000 10919345472 11383275520 1976011872 19.433 99 20 40 0 1989752656 8380720 5360064
21:14:01 19778 8192000000 10913938784 11363696640 1923462672 19.015 97 22 44 2 1937919600 8778832 5678096
21:14:26 34791 8192000000 10910743776 11375558656 1974102496 19.418 100 34 68 1 1994851088 10965440 9783152
21:15:08 50909 8192000000 10900266768 11358969856 1916144304 18.956 97 20 40 1 1929460000 8122784 5192912
21:16:08 12951 8192000000 10909146000 11356028928 1955048064 19.267 99 59 115 2 1980241360 8450880 16742416
21:16:28 34721 8192000000 10912119888 11369070592 1954677200 19.264 99 31 62 0 1976465008 12834000 8953808
21:17:10 23547 8192000000 10922359552 11375521792 1972803056 19.408 100 27 54 1 1995170960 15081344 7286560
21:17:46 84645 8192000000 10878446464 11342430208 1863369216 18.531 94 15 30 0 1878984384 12283328 3331840
21:19:16 47348 8192000000 10903916448 11343175680 1862056032 18.520 95 26 52 2 1876096336 6572016 7468288
21:20:27 74517 8192000000 10866914976 11326615552 1923961856 19.019 99 32 64 1 1941499152 8585984 8951312
21:21:48 47917 8192000000 10855479952 11307053056 1848095600 18.407 95 25 50 0 1861562800 7059696 6407504
21:22:43 56300 8192000000 10863060400 11314622464 1882592752 18.686 97 37 74 1 1904750624 11226288 10931584
21:23:46 17264 8192000000 10829945024 11284590592 1874252416 18.619 97 49 98 1 1895926720 7571248 14103056
21:24:15 89259 8192000000 10857208048 11323142144 1895164912 18.787 98 20 40 1 1915818304 14442640 6210752
21:26:21 63758 8192000000 10842710976 11318857728 1890145632 18.747 98 17 34 0 1911383280 15688704 5548944
21:27:51 65296 8192000000 10845237184 11314302976 1838665472 18.330 96 9 18 0 1852058944 11202560 2190912
21:29:02 102906 8192000000 10868066352 11339685888 1861316992 18.514 96 20 41 1 1885453088 18756576 5379520
21:31:44 36437 8192000000 10831116736 11273695232 1777768464 17.831 92 32 63 1 1793890848 7313392 8808992
21:32:26 59983 8192000000 10825039360 11278151680 1858240352 18.489 97 40 80 1 1880171744 10440224 11491168
21:33:33 40814 8192000000 10845476448 11299282944 1868396592 18.571 98 20 40 0 1888095680 13868720 5830368
21:34:25 75402 8192000000 10835533280 11315396608 1835337984 18.303 96 19 38 0 1859483712 18884752 5260976
21:35:51 115293 8192000000 10864166608 11309543424 1808036224 18.080 94 17 34 0 1822736112 10208976 4490912
21:37:53 16139 8192000000 10879005712 11324813312 1929830096 19.066 100 48 96 1 1956437248 12992976 13614176
21:38:19 35264 8192000000 10880623920 11333206016 1932818656 19.089 100 33 66 2 1960463808 18649232 8995920
21:39:07 17586 8192000000 10906783808 11346579456 1944783120 19.185 100 42 85 1 1966835696 10864848 11187728
21:39:31 48246 8192000000 10889556496 11353088000 1949985232 19.226 100 30 60 1 1971304960 13209504 8110224
21:40:29 37956 8192000000 10914212864 11369324544 1960825712 19.313 100 43 86 0 1987721632 14510832 12385088
21:41:44 80120 8192000000 10882576832 11353833472 1937749536 19.129 99 20 40 1 1958425616 14845968 5830112
21:43:13 90708 8192000000 10891183664 11357302784 1960889488 19.313 100 31 62 2 1978221232 7836080 9495664
21:44:50 58258 8192000000 10911483008 11372937216 1976840800 19.440 100 46 92 0 2001198032 10366112 13991120
21:45:55 43705 8192000000 10893411632 11384012800 1974903792 19.424 100 25 50 1 1995410544 13785904 6720848
21:46:55 63607 8192000000 10917068112 11396825088 1986056832 19.513 100 8 16 0 1995452176 6999040 2396304
21:48:05 99381 8192000000 10927763024 11410010112 1977192064 19.442 99 15 30 0 1995695200 13765392 4737744
21:50:14 84062 8192000000 10919541504 11414179840 1988221088 19.530 100 13 26 0 2008632448 16340544 4070816
21:52:49 47090 8192000000 10907716544 11392995328 1954676496 19.264 98 18 36 1 1970500256 10236160 5587600
21:53:44 55642 8192000000 10915496368 11393724416 1968103872 19.370 99 20 40 0 1985257904 11469888 5684144
21:54:46 95053 8192000000 10897933024 11381542912 1944051200 19.179 98 10 20 1 1959897552 13074352 2772000
21:56:30 43236 8192000000 10921411408 11392905216 1986784816 19.518 100 13 25 1 1997673856 7241632 3647408
21:57:30 61393 8192000000 10901513936 11365294080 1897035984 18.802 95 19 37 1 1912759568 10780560 4943024
21:59:53 64871 8192000000 10908914784 11376406528 1931402112 19.078 98 17 34 0 1946344240 10559760 4382368
22:01:07 85278 8192000000 10905803328 11382124544 1899820688 18.825 96 10 20 0 1913557680 11445616 2291376
22:02:59 35754 8192000000 10900144912 11377238016 1966315328 19.356 100 16 32 0 1985550080 14756448 4478304
22:03:41 78591 8192000000 10892506224 11363000320 1883861472 18.696 96 6 12 0 1905853296 20381792 1610032
22:05:14 138170 8192000000 10889304992 11350769664 1901717920 18.840 97 27 54 1 1920510912 10947728 7845264
22:07:38 60909 8192000000 10900130480 11368239104 1941264960 19.157 99 31 61 1 1962961568 13774752 7921856
22:09:20 61100 8192000000 10878186256 11356262400 1908891152 18.898 97 16 33 0 1923996832 9673056 5432624
22:11:38 37481 8192000000 10888361968 11355389952 1944656432 19.184 99 29 58 2 1970336496 17609216 8070848
22:12:24 54390 8192000000 10857617072 11323543552 1862494432 18.523 95 22 44 0 1879136672 10324576 6317664
22:13:27 78601 8192000000 10867113632 11336822784 1926904336 19.042 99 21 42 1 1946417072 13123072 6389664
22:14:54 49070 8192000000 10864328336 11353976832 1924321728 19.021 99 10 20 1 1940493040 13133040 3038272
22:15:49 50711 8192000000 10832515776 11308560384 1848607008 18.411 95 17 34 0 1860767504 7889904 4270592
22:16:52 18168 8192000000 10825651392 11288408064 1882057232 18.682 98 25 50 1 1895847232 6222288 7567712
22:17:20 24561 8192000000 10833947056 11286859776 1835846592 18.307 96 30 60 2 1851782976 7817888 8118496
22:17:51 17525 8192000000 10840058944 11294756864 1893968704 18.778 99 38 76 0 1914011936 9775248 10267984
22:18:48 28847 8192000000 10841212608 11296444416 1856159648 18.472 97 38 76 1 1877892208 11094032 10638528
22:19:25 23818 8192000000 10856963632 11292921856 1871662240 18.598 98 41 81 0 1893740320 10559104 11518976
22:19:57 46381 8192000000 10813796480 11280011264 1820604736 18.183 96 21 42 2 1836930400 10596720 5728944
22:20:50 30201 8192000000 10827159616 11276124160 1846990704 18.398 97 32 64 3 1864366400 8091184 9284512
22:21:29 19718 8192000000 10832906944 11281584128 1877012992 18.641 99 38 76 1 1897113808 9645584 10455232
22:21:57 20867 8192000000 10846614912 11289358336 1878306160 18.651 99 46 92 1 1907671312 17035424 12329728
22:22:24 26341 8192000000 10844631312 11299119104 1885931216 18.713 99 42 83 2 1910109440 12586304 11591920
22:22:57 35949 8192000000 10863291920 11309580288 1894757712 18.784 99 45 90 2 1921094080 13175856 13160512
22:23:40 37590 8192000000 10881265072 11328274432 1916082016 18.955 100 50 100 0 1947237280 17382384 13772880
22:24:26 83315 8192000000 10881405216 11335397376 1907511632 18.887 99 33 66 2 1932391168 15916720 8962816
22:25:55 75993 8192000000 9373058416 9744703488 470330848 5.429 25 3 6 0 477107552 6076352 700352

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 19-12-2020 22:27:55 to 19-12-2020 22:28:25.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 146 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-12-2020 22:28:26 to 19-12-2020 22:28:28.

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          258288
MON$OLDEST_ACTIVE               258609
MON$OLDEST_SNAPSHOT             258609
MON$NEXT_TRANSACTION            258609
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                       2041696
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 ---
:120: 
:121: mscs-test-161.budzdorov.ru    Sat Dec 19 22:27:14 2020
:122:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:123: 
:124: 
:125: mscs-test-161.budzdorov.ru    Sat Dec 19 22:27:14 2020
:126:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:127: 
--- end of diff output ---

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

19.12.20 22:28:29. 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-19 22:28:31 No severe PSQL-related problems occured
19.12.20 22:28:32. End of report.