Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 05.12.2020 19: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 17425484 kB
MemAvailable 31624336 kB
Buffers 0 kB
Cached 14297304 kB
SwapCached 1968 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-05 19:27:05
DTS_END                         2020-12-05 19:27:05.2420
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/49222
TRN_ID                          239605
ATT_ID                          707
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: 9775.52 14474 1173062
customer order: creation 178.46 353 21415
customer order: refuse 14.93 298 1792
order to supplier: creation 45.34 1209 5441
order to supplier: removal 3.91 81959 469
invoice (draft): creation 46.45 2899 5574
invoice (draft): removal 57.94 671 6953
invoice accept: apply 41.83 16139 5019
invoice accept: cancel 52.07 709 6248
customer reserve: creation 3900.53 159 468064
customer reserve: removal 5126.35 49 615162
realization accept: apply 83.70 148 10044
realization accept: cancel 92.41 99 11089
payment from customer: creation 60.24 106 7229
payment from customer: removal 5.73 88 688
payment to supplier: creation 50.31 127 6037
payment to supplier: removal 3.47 85 416
service: total inventory turnovers 4.78 944 574
service: total monetary turnovers 6.23 25 747
service: aggregate perf. data 0.81 20442 97
service: refresh index statistics 0.03 162980 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-12-2020 19:29:22 to 05-12-2020 19:29:24.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7381
TEST_TIME 2 7277
TEST_TIME 3 6451
TEST_TIME 4 5839
TEST_TIME 5 5827
TEST_TIME 6 6335
TEST_TIME 7 6070
TEST_TIME 8 6246
TEST_TIME 9 6127
TEST_TIME 10 6334
TEST_TIME 11 7092
TEST_TIME 12 7774
TEST_TIME 13 8194
TEST_TIME 14 7987
TEST_TIME 15 8700
TEST_TIME 16 9402
TEST_TIME 17 9351
TEST_TIME 18 9774
TEST_TIME 19 10155
TEST_TIME 20 10307
TEST_TIME 21 10573
TEST_TIME 22 10792
TEST_TIME 23 10976
TEST_TIME 24 11244
TEST_TIME 25 11905
TEST_TIME 26 11688
TEST_TIME 27 11574
TEST_TIME 28 11497
TEST_TIME 29 11407
TEST_TIME 30 11388
TEST_TIME 31 11472
TEST_TIME 32 11390
TEST_TIME 33 11369
TEST_TIME 34 11394
TEST_TIME 35 11273
TEST_TIME 36 10996
TEST_TIME 37 10941
TEST_TIME 38 10822
TEST_TIME 39 10743
TEST_TIME 40 10674
TEST_TIME 41 10694
TEST_TIME 42 10594
TEST_TIME 43 10661
TEST_TIME 44 10505
TEST_TIME 45 10412
TEST_TIME 46 10337
TEST_TIME 47 10383
TEST_TIME 48 10315
TEST_TIME 49 10317
TEST_TIME 50 10327
TEST_TIME 51 10387
TEST_TIME 52 10343
TEST_TIME 53 10268
TEST_TIME 54 10521
TEST_TIME 55 10436
TEST_TIME 56 10457
TEST_TIME 57 10457
TEST_TIME 58 10619
TEST_TIME 59 10568
TEST_TIME 60 10516
TEST_TIME 61 10694
TEST_TIME 62 10679
TEST_TIME 63 10599
TEST_TIME 64 10689
TEST_TIME 65 10536
TEST_TIME 66 10528
TEST_TIME 67 10516
TEST_TIME 68 10486
TEST_TIME 69 10451
TEST_TIME 70 10442
TEST_TIME 71 10374
TEST_TIME 72 10303
TEST_TIME 73 10307
TEST_TIME 74 10257
TEST_TIME 75 10175
TEST_TIME 76 10140
TEST_TIME 77 10092
TEST_TIME 78 10112
TEST_TIME 79 10096
TEST_TIME 80 10157
TEST_TIME 81 10133
TEST_TIME 82 10178
TEST_TIME 83 10196
TEST_TIME 84 10221
TEST_TIME 85 10173
TEST_TIME 86 10267
TEST_TIME 87 10254
TEST_TIME 88 10318
TEST_TIME 89 10343
TEST_TIME 90 10346
TEST_TIME 91 10258
TEST_TIME 92 10210
TEST_TIME 93 10179
TEST_TIME 94 10138
TEST_TIME 95 10122
TEST_TIME 96 10109
TEST_TIME 97 10079
TEST_TIME 98 10019
TEST_TIME 99 9995
TEST_TIME 100 9992
TEST_TIME 101 9957
TEST_TIME 102 9962
TEST_TIME 103 9966
TEST_TIME 104 9943
TEST_TIME 105 9936
TEST_TIME 106 9952
TEST_TIME 107 9979
TEST_TIME 108 10003
TEST_TIME 109 9968
TEST_TIME 110 10090
TEST_TIME 111 10049
TEST_TIME 112 10066
TEST_TIME 113 10044
TEST_TIME 114 10043
TEST_TIME 115 10006
TEST_TIME 116 9959
TEST_TIME 117 9917
TEST_TIME 118 9901
TEST_TIME 119 9864
TEST_TIME 120 9784

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-12-2020 19:29:25 to 05-12-2020 19:29:29.

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 1608335 1608335 0 0.00 0 18622 5 0 0
doc_list_biud 1608334 1608334 0 0.00 0 42192 24 0 0
sp_add_invoice_to_stock 5165 5019 146 2.82 37 187928 16140 0 146
sp_cancel_adding_invoice 6248 6248 0 0.00 3 59952 710 0 0
sp_cancel_client_order 1792 1792 0 0.00 4 15468 298 0 0
sp_cancel_customer_reserve 615162 615162 0 0.00 1 42193 49 0 0
sp_cancel_pay_from_customer 688 688 0 0.00 2 7815 89 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 3 3763 86 0 0
sp_cancel_supplier_invoice 6964 6953 11 0.15 1 14882 671 0 11
sp_cancel_supplier_order 469 469 0 0.00 7 973040 81960 0 0
sp_cancel_write_off 11089 11089 0 0.00 1 17469 99 0 0
sp_client_order 21415 21415 0 0.00 3 21353 353 0 0
sp_customer_reserve 468064 468064 0 0.00 0 107371 159 0 0
sp_fill_shopping_cart 32426 32426 0 0.00 1 8762 29 0 0
sp_fill_shopping_cart_clo_res 468053 468053 0 0.00 0 10705 13 0 0
sp_get_clo_for_invoice 5007 5007 0 0.00 0 26049 290 0 0
sp_kill_cost_storno 18441 18441 0 0.00 0 18615 46 0 0
sp_kill_qstorno_ret_qs2qd 1248835 1248835 0 0.00 0 42190 27 0 0
sp_kill_qty_storno 656764 656764 0 0.00 0 42192 58 0 0
sp_lock_selected_doc 21004 21004 0 0.00 0 9263 7 0 0
sp_make_cost_storno 28317 28317 0 0.00 0 13442 46 0 0
sp_multiply_rows_for_pdistr 28317 28317 0 0.00 0 10487 27 0 0
sp_multiply_rows_for_qdistr 21415 21415 0 0.00 0 20930 157 0 0
sp_pay_from_customer 7229 7229 0 0.00 4 14988 107 0 0
sp_pay_to_supplier 6037 6037 0 0.00 4 14987 127 0 0
sp_payment_common 13266 13266 0 0.00 1 12919 29 0 0
sp_qd_handle_on_cancel_clo 1792 1792 0 0.00 0 15458 274 0 0
sp_qd_handle_on_invoice_upd_sts 11255 11255 0 0.00 0 29432 272 0 0
sp_qd_handle_on_reserve_upd_sts 10044 10044 0 0.00 0 21803 48 0 0
sp_reserve_write_off 10044 10044 0 0.00 6 21844 148 0 0
sp_supplier_invoice 5574 5574 0 0.00 5 96854 2899 0 0
sp_supplier_order 5441 5441 0 0.00 5 36022 1210 0 0
srv_aggregate_perf_data 97 97 0 0.00 2624 187423 20443 0 0
srv_fill_mon_cache_memory 142 142 0 0.00 1442 187217 36938 0 0
srv_find_qd_qs_mism 1125369 1125369 0 0.00 0 14760 4 0 0
srv_make_invnt_saldo 574 574 0 0.00 38 42697 945 0 0
srv_make_money_saldo 747 747 0 0.00 1 2110 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 144933 171758 162980 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 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5019 5019 0 0.00 0 11137 139 0 0
t$perf-norm:sp_cancel_adding_invoice 422 422 0 0.00 0 2922 87 0 0
t$perf-norm:sp_cancel_client_order 1792 1792 0 0.00 0 4566 11 0 0
t$perf-norm:sp_cancel_customer_reserve 692 692 0 0.00 0 4280 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 688 688 0 0.00 0 799 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 429 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 574 8 0 0
t$perf-norm:sp_cancel_supplier_order 469 469 0 0.00 0 27407 1409 0 0
t$perf-norm:sp_cancel_write_off 1070 1070 0 0.00 0 7584 13 0 0
t$perf-norm:sp_client_order 21415 21415 0 0.00 0 9530 16 0 0
t$perf-norm:sp_customer_reserve 1060 1060 0 0.00 0 7183 14 0 0
t$perf-norm:sp_pay_from_customer 7229 7229 0 0.00 0 10247 11 0 0
t$perf-norm:sp_pay_to_supplier 6037 6037 0 0.00 0 15591 14 0 0
t$perf-norm:sp_reserve_write_off 10044 10044 0 0.00 0 7208 13 0 0
t$perf-norm:sp_supplier_invoice 5574 5574 0 0.00 0 9089 19 0 0
t$perf-norm:sp_supplier_order 5441 5441 0 0.00 0 10151 19 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 152 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 142 142 0 0.00 0 4510 73 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 5343 25 0 0
t$perf-norm:srv_make_money_saldo 747 747 0 0.00 0 5684 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 10 6 0 0
v_add_invoice_to_stock 10304 10012 292 2.83 0 7883 19 0 292
v_all_customers 39152 39152 0 0.00 0 14 0 0 0
v_all_suppliers 31222 31222 0 0.00 0 89 1 0 0
v_all_wares 42828 42828 0 0.00 0 69 1 0 0
v_cancel_adding_invoice 844 844 0 0.00 0 2808 9 0 0
v_cancel_client_order 3584 3584 0 0.00 0 818 3 0 0
v_cancel_customer_prepayment 1376 1376 0 0.00 0 5236 10 0 0
v_cancel_customer_reserve 1384 1384 0 0.00 0 3562 7 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 1988 8 0 0
v_cancel_supplier_invoice 832 810 22 2.64 0 5434 24 0 22
v_cancel_supplier_order 938 938 0 0.00 0 3361 12 0 0
v_cancel_write_off 2140 2140 0 0.00 0 5440 23 0 0
v_max_id_clo_ord 5441 5441 0 0.00 0 182 1 0 0
v_max_id_clo_res 1060 1060 0 0.00 0 1917 14 0 0
v_max_id_ord_sup 5571 5571 0 0.00 0 7068 4 0 0
v_max_non_paid_invoice 1438 1438 0 0.00 0 746 3 0 0
v_max_non_paid_realizn 3696 3696 0 0.00 0 1511 4 0 0
v_min_id_clo_ord 5441 5441 0 0.00 0 3681 5 0 0
v_min_id_clo_res 1060 1060 0 0.00 0 2435 8 0 0
v_min_id_ord_sup 5571 5571 0 0.00 0 6136 5 0 0
v_min_non_paid_invoice 6037 6037 0 0.00 0 12913 23 0 0
v_min_non_paid_realizn 7229 7229 0 0.00 0 6725 16 0 0
v_our_firm 10742 10742 0 0.00 0 13 1 0 0
v_reserve_write_off 20088 20088 0 0.00 0 5460 5 0 0
x_lock_depdocs_on_canc_invoice 12796 12796 0 0.00 0 21358 104 0 0
x_lock_depdocs_on_canc_sup_ord 469 469 0 0.00 0 11442 299 0 0
x_make_qstorno_1000_1200 5441 5441 0 0.00 2 36010 1143 0 0
x_make_qstorno_1200_2000 5574 5574 0 0.00 2 96823 2799 0 0
x_make_qstorno_2100_3300 468064 468064 0 0.00 0 107368 144 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-12-2020 19:29:30 to 05-12-2020 19:29:34.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:08 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:15 8788 8192000000 10200832848 10498977792 978640336 10.671 79 59 118 0 1001740048 2765456 20334256
16:57:31 29281 8192000000 10337270256 10652717056 1361845536 14.254 100 81 162 1 1392728848 4415360 26467952
16:58:09 23505 8192000000 10375625936 10696888320 1415202064 14.730 100 86 172 0 1448812624 5859616 27750944
16:58:41 23931 8192000000 10406602832 10733150208 1456867648 15.098 100 91 182 1 1493268848 6882784 29518416
16:59:15 26927 8192000000 10419663008 10749992960 1478851072 15.291 100 86 172 0 1513979696 7589712 27538912
17:00:04 23090 8192000000 10458103040 10792677376 1506261792 15.531 100 89 178 0 1543832304 9243712 28326800
17:00:38 13567 8192000000 10471719984 10811416576 1530180336 15.739 100 90 180 0 1567997376 9761024 28056016
17:01:00 13176 8192000000 10491442160 10834735104 1547458784 15.888 100 82 164 1 1582679520 10119952 25100784
17:01:36 15528 8192000000 10527202752 10880180224 1577757472 16.149 100 75 150 0 1611194272 10367232 23069568
17:02:00 14045 8192000000 10543092720 10899042304 1602322128 16.359 100 85 170 1 1639157472 11048784 25786560
17:02:29 12619 8192000000 10575095040 10934624256 1631054896 16.604 100 83 166 0 1667153984 11441712 24657376
17:02:48 9103 8192000000 10589638096 10951335936 1648204704 16.749 100 82 164 1 1684100640 11889456 24006480
17:03:06 9158 8192000000 10601290800 10963689472 1658503344 16.836 100 86 172 0 1696116240 12383488 25229408
17:03:24 5536 8192000000 10621744304 10986848256 1676625312 16.989 100 77 155 0 1711519712 11972176 22922224
17:03:41 9382 8192000000 10659358752 11027902464 1709788656 17.267 100 90 178 0 1747985312 12663600 25533056
17:03:58 7101 8192000000 10659727984 11034513408 1727283696 17.413 100 88 176 3 1766032512 13974144 24774672
17:04:13 6019 8192000000 10667910592 11039789056 1733015104 17.461 100 80 161 1 1769338464 13362400 22960960
17:04:26 6239 8192000000 10674604064 11053920256 1741871680 17.534 100 82 163 2 1778521280 12992176 23657424
17:04:38 6835 8192000000 10689015440 11069595648 1748666560 17.591 100 77 153 1 1782216448 12470352 21079536
17:04:52 5616 8192000000 10705560576 11079626752 1758982144 17.676 100 84 166 0 1795167088 12806288 23378656
17:05:04 4613 8192000000 10702484960 11084161024 1767368672 17.745 100 85 168 1 1804023136 13220320 23434144
17:05:17 2481 8192000000 10711260000 11090620416 1775606304 17.813 100 80 160 0 1811516416 12562432 23347680
17:05:26 3808 8192000000 10723902304 11104522240 1782135568 17.867 100 80 159 2 1817767520 13197184 22434768
17:05:36 2894 8192000000 10737246416 11112546304 1791940352 17.948 100 87 174 1 1830619168 13143024 25535792
17:05:45 2387 8192000000 10739944816 11120619520 1795632128 17.978 100 80 160 0 1829800080 12504176 21663776
17:05:55 2566 8192000000 10735833296 11121192960 1798941920 18.005 100 82 160 2 1834524176 13093424 22488832
17:06:04 2872 8192000000 10743912560 11125108736 1807268512 18.074 100 91 178 0 1845734896 13696256 24770128
17:06:13 2483 8192000000 10754710384 11138088960 1815771632 18.143 100 89 178 0 1854423328 14232272 24419424
17:06:22 3710 8192000000 10762870352 11144671232 1816196928 18.147 100 88 178 1 1855492400 14449312 24846160
17:06:33 3806 8192000000 10766456016 11147231232 1821362816 18.189 100 87 172 1 1859362032 14096160 23903056
17:06:44 2114 8192000000 10769040960 11155005440 1835727952 18.306 100 85 170 0 1872744656 13302976 23713728
17:06:52 1905 8192000000 10783845984 11170484224 1841524224 18.353 100 92 182 2 1881233360 13720176 25988960
17:07:01 2374 8192000000 10787139520 11170713600 1843632048 18.370 100 89 177 0 1882665392 14662288 24371056
17:07:10 1757 8192000000 10794540048 11180441600 1847101232 18.399 100 92 182 2 1887709296 15351872 25256192
17:07:18 1621 8192000000 10800636160 11183955968 1854714944 18.460 100 94 189 3 1895300496 14167584 26417968
17:07:26 1804 8192000000 10798764288 11183992832 1854108496 18.455 100 93 186 2 1893851392 12572224 27170672
17:07:34 1571 8192000000 10802893840 11190239232 1858977296 18.495 100 92 185 1 1898467840 12946960 26543584
17:07:42 1528 8192000000 10803597136 11191078912 1864627552 18.541 100 94 187 3 1904027488 12976832 26423104
17:07:49 40882 8192000000 10800466272 11199188992 1863765872 18.534 100 60 118 1 1889591184 8666992 17158320
17:08:37 1442 8192000000 10809973392 11212599296 1875699488 18.630 100 83 166 1 1909863776 9723536 24440752
17:08:46 14709 8192000000 10782918416 11205660672 1866761840 18.558 100 35 70 1 1884040000 7270528 10007632
17:09:08 6293 8192000000 10789734288 11212533760 1876132912 18.634 100 38 76 0 1894477824 7948224 10396688
17:09:20 5781 8192000000 10797419776 11218731008 1879237760 18.659 100 44 88 0 1900837392 9401024 12198608
17:09:35 5057 8192000000 10799215168 11220889600 1883459920 18.693 100 36 73 1 1899978016 6649296 9868800
17:09:49 3962 8192000000 10791880880 11218456576 1883379008 18.692 100 40 79 1 1901024960 7239808 10406144
17:10:02 9557 8192000000 10792495296 11219652608 1881615360 18.678 100 26 51 2 1895394272 6600032 7178880
17:10:18 5800 8192000000 10789143184 11220463616 1885020544 18.706 100 21 42 0 1897659664 6016832 6622288
17:10:33 9971 8192000000 10798501792 11230605312 1891522320 18.758 100 28 56 1 1906282080 6887760 7872000
17:10:49 8672 8192000000 10785468896 11227729920 1891812384 18.760 100 21 42 2 1903333856 5329424 6192048
17:11:05 8700 8192000000 10800595376 11234967552 1893533760 18.774 100 17 34 1 1904033232 6169776 4329696
17:11:22 7653 8192000000 10804634944 11239608320 1894926192 18.785 100 16 32 2 1910323680 10591456 4806032
17:11:36 6708 8192000000 10807551120 11240824832 1898469856 18.814 100 21 43 1 1915165728 10682928 6012944
17:11:51 9959 8192000000 10803164592 11238494208 1898669760 18.816 100 19 38 0 1910680928 6321760 5689408
17:12:08 7681 8192000000 10804060752 11243302912 1899105168 18.819 100 16 32 1 1909960720 6501312 4354240
17:12:21 10782 8192000000 10809965008 11239055360 1900103936 18.827 100 22 44 2 1911768576 6068272 5596368
17:12:42 73049 8192000000 10829564400 11254525952 1903196960 18.852 100 32 63 0 1917719840 5013536 9509344
17:14:01 1479 8192000000 10875379584 11274870784 1921336592 18.998 100 93 186 0 1958050672 10396848 26317232
17:14:12 6065 8192000000 10832735024 11259129856 1906615520 18.879 100 26 52 0 1921132880 7795792 6721568
17:14:24 5109 8192000000 10827906032 11262676992 1910117792 18.908 100 43 85 0 1930840432 8449008 12273632
17:14:37 4280 8192000000 10828231200 11260526592 1910389360 18.910 100 37 74 2 1928025552 7072176 10564016
17:14:49 4609 8192000000 10809089952 11250634752 1889220432 18.739 99 29 59 0 1904398304 6359536 8818336
17:15:00 5821 8192000000 10824444080 11260821504 1907684928 18.888 100 28 56 2 1926128480 10713200 7730352
17:15:14 5872 8192000000 10831068128 11267178496 1912710608 18.928 100 29 58 4 1928072400 7003456 8358336
17:15:29 12345 8192000000 10832624848 11268706304 1913098928 18.932 100 22 44 1 1925547936 6231344 6217664
17:15:48 11534 8192000000 10822498272 11265470464 1915658880 18.952 100 19 38 2 1927044832 6309296 5076656
17:16:06 49487 8192000000 10848499616 11270934528 1882862352 18.688 98 32 64 3 1897279632 5384016 9033264
17:17:02 21430 8192000000 10817859856 11246952448 1870299136 18.587 98 25 50 2 1883189632 5273376 7617120
17:17:29 5541 8192000000 10811840288 11249405952 1872910576 18.608 98 28 56 2 1887710848 6811376 7988896
17:17:41 6022 8192000000 10800596640 11232403456 1873035840 18.609 99 28 56 4 1886825040 5944656 7844544
17:17:55 7315 8192000000 10777258576 11207651328 1816498720 18.149 96 33 64 0 1831921792 6245200 9177872
17:18:12 4404 8192000000 10762035920 11185315840 1814664272 18.134 97 21 42 0 1830853536 9170368 7018896
17:18:23 4991 8192000000 10760786768 11190796288 1849965200 18.422 100 25 50 4 1864048224 7343616 6739408
17:18:35 3938 8192000000 10744767840 11162185728 1798917776 18.005 98 32 64 1 1815177216 6613248 9646192
17:18:47 7974 8192000000 10725171584 11147501568 1756730960 17.657 96 14 26 1 1769645440 9240032 3674448
17:19:03 9285 8192000000 10743479760 11161935872 1790475664 17.936 98 22 44 1 1802630480 5869184 6285632
17:19:18 4424 8192000000 10735124224 11160616960 1791983904 17.948 98 27 54 0 1808981888 9984704 7013280
17:19:29 8905 8192000000 10699576064 11123015680 1724054192 17.386 95 19 38 2 1734775376 5233008 5488176
17:19:47 14018 8192000000 10693009248 11113279488 1715985536 17.319 95 19 38 0 1726690224 5079280 5625408
17:20:07 12551 8192000000 10744583008 11146321920 1777518784 17.829 98 22 45 0 1789198336 5110416 6569136
17:20:26 60977 8192000000 10721451968 11143749632 1737772944 17.500 95 44 88 1 1758322816 7553632 12996240
17:21:34 7851 8192000000 10713493312 11129946112 1793300656 17.959 100 30 60 2 1807929360 6507888 8120816
17:21:50 8204 8192000000 10691821024 11113340928 1740856864 17.526 97 24 48 1 1753704080 6225744 6621472
17:22:05 6887 8192000000 10693170368 11110113280 1755548864 17.648 98 18 35 2 1774329040 13984272 4795904
17:22:18 7571 8192000000 10719300272 11134578688 1798492416 18.002 100 28 56 3 1813188624 6173152 8523056
17:22:32 7938 8192000000 10726010128 11144990720 1810523024 18.100 100 26 53 3 1823660192 5639760 7497408
17:22:47 8084 8192000000 10730354432 11156103168 1821107648 18.187 100 31 62 1 1835535920 5169232 9259040
17:23:01 5232 8192000000 10748821872 11165794304 1825550096 18.223 100 30 61 3 1839420480 5648064 8222320
17:23:14 6489 8192000000 10753422592 11175325696 1837778160 18.323 100 24 48 1 1851323328 6331840 7213328
17:23:30 10560 8192000000 10750410768 11178217472 1840353584 18.344 100 17 34 1 1850489904 5622048 4514272
17:23:48 5297 8192000000 10759093856 11184668672 1842600176 18.362 100 24 48 1 1855680160 6338656 6741328
17:24:02 9162 8192000000 10748608592 11179397120 1826891952 18.234 99 15 30 2 1836228096 5318016 4018128
17:24:19 13959 8192000000 10758290464 11187748864 1843615792 18.370 100 18 36 1 1853325056 4980944 4728320
17:24:39 11713 8192000000 10759775776 11192823808 1849336976 18.417 100 14 28 1 1858603952 5626160 3640816
17:24:58 9272 8192000000 10763911344 11199127552 1853999040 18.455 100 14 28 0 1863976224 6257296 3719888
17:25:17 64688 8192000000 10789266288 11211026432 1863397696 18.531 100 30 60 2 1876847040 5372896 8076448
17:26:28 9530 8192000000 10776013728 11208269824 1868224496 18.570 100 37 72 1 1885143296 6722720 10196080
17:26:49 13377 8192000000 10790477776 11215003648 1868879904 18.575 100 16 31 1 1879075056 5472864 4722288
17:27:12 21205 8192000000 10818777248 11240050688 1894218832 18.780 100 37 74 1 1911471712 6844352 10408528
17:27:40 15375 8192000000 10838007488 11257028608 1905753360 18.873 100 42 83 1 1925474896 7926880 11794656
17:28:10 9871 8192000000 10854465120 11273027584 1919175872 18.980 100 57 114 1 1943751568 9276544 15299152
17:28:34 5384 8192000000 10875809328 11290374144 1929576016 19.063 100 66 132 1 1960947648 13217632 18154000
17:28:56 10884 8192000000 10872174784 11292114944 1933582224 19.096 100 57 114 0 1962719008 13477232 15659552
17:29:15 16058 8192000000 10882969680 11302121472 1942356304 19.166 100 48 96 1 1968037952 12234240 13447408
17:29:38 10700 8192000000 10889982768 11307282432 1949180944 19.220 100 56 112 2 1977324976 12483168 15660864
17:30:02 22991 8192000000 10884526304 11311525888 1936780176 19.121 99 50 100 1 1966025104 14802272 14442656
17:30:48 14266 8192000000 10896224704 11322060800 1955524272 19.270 100 37 74 3 1983292896 16958064 10810560
17:31:17 14296 8192000000 10912700848 11338362880 1964178480 19.339 100 54 104 1 1997195760 17916976 15100304
17:31:46 12041 8192000000 10919678384 11346497536 1976399824 19.436 100 57 115 1 2013056208 19987680 16668704
17:32:14 22846 8192000000 10912654464 11349016576 1978946640 19.456 100 42 84 0 2010218000 18763200 12508160
17:32:52 48620 8192000000 10916806784 11360235520 1977193888 19.442 100 28 56 0 2008683392 22668240 8821264
17:33:48 23297 8192000000 10915267600 11368939520 1985681280 19.510 100 33 66 1 2014792400 19271776 9839344
17:34:20 12131 8192000000 10946407760 11376758784 1994979712 19.583 100 49 98 2 2029740416 19220752 15539952
17:34:41 14536 8192000000 10946455632 11378352128 1998182720 19.608 100 50 98 0 2034044144 20978016 14883408
17:35:04 3278 8192000000 10952599120 11383275520 2003934704 19.654 100 54 108 1 2042220864 22160496 16125664
17:35:15 3439 8192000000 10970299408 11393724416 2008679616 19.691 100 70 140 0 2053167456 23151696 21336144
17:35:26 11088 8192000000 10969948208 11400142848 2015505200 19.745 100 66 130 1 2061079856 25964208 19610448
17:35:54 10127 8192000000 10965305200 11406155776 2016816208 19.755 100 47 93 0 2058304640 27077632 14410800
17:36:12 9898 8192000000 10972562608 11409756160 2018575376 19.769 100 39 78 0 2056827808 25738304 12514128
17:36:34 4587 8192000000 10987143904 11421712384 2026083808 19.828 100 50 98 0 2071414064 29349760 15980496
17:36:47 4408 8192000000 10994122992 11424411648 2029823856 19.857 100 63 126 0 2080071728 30528848 19719024
17:37:00 2570 8192000000 11000688608 11427885056 2034407664 19.893 100 69 134 2 2087043360 31631408 21004288
17:37:12 7649 8192000000 10988378928 11420995584 2012902816 19.724 99 63 125 0 2063371312 31451712 19016784
17:37:35 6301 8192000000 10996296432 11431120896 2031527104 19.871 100 55 110 2 2083593824 34940656 17126064
17:37:50 6679 8192000000 10982183728 11411836928 2010795280 19.708 99 65 130 0 2067560496 36791072 19974144
17:38:08 2054 8192000000 10997763504 11418439680 2013828640 19.732 99 85 169 1 2078732448 38458976 26444832
17:38:18 7645 8192000000 11004092384 11435732992 2030630384 19.864 100 76 152 0 2095746768 41304208 23812176
17:38:37 2174 8192000000 11019189872 11436183552 2035460768 19.901 100 82 164 1 2096568176 36592384 24515024
17:38:46 6479 8192000000 11017603904 11442581504 2037382784 19.916 100 82 163 1 2102005664 39427120 25195760
17:39:02 2445 8192000000 11017637952 11442536448 2040692816 19.942 100 85 170 2 2105761616 39209232 25859568
17:39:12 1440 8192000000 11016513856 11436126208 2033628736 19.887 100 77 153 0 2097176848 40254768 23293344
17:39:19 3320 8192000000 10988009488 11408236544 2008210256 19.687 99 75 149 0 2071216096 39913472 23092368
17:39:32 2062 8192000000 11011820784 11435446272 2032723104 19.880 100 79 156 2 2097099424 39674816 24701504
17:39:42 1870 8192000000 11013052144 11431809024 2025467600 19.823 100 81 162 2 2089484656 39098352 24918704
17:39:51 2032 8192000000 11012069040 11432448000 2032365616 19.877 100 84 168 2 2094100704 35487792 26247296
17:40:00 7154 8192000000 10993115056 11420524544 2007096800 19.679 99 71 142 1 2064997312 36197376 21703136
17:40:16 1891 8192000000 11004350960 11420045312 2015272048 19.743 100 97 194 2 2085666800 41649696 28745056
17:40:25 9091 8192000000 10990044960 11425890304 2018161456 19.766 100 68 136 0 2077923264 39238976 20522832
17:40:42 7606 8192000000 10966851264 11407908864 2005920960 19.669 100 51 103 3 2058607984 36085600 16601424
17:41:04 8926 8192000000 10969409984 11415904256 2008680368 19.691 100 39 77 0 2057514928 36248944 12585616
17:41:33 7671 8192000000 10961093664 11388088320 1967914816 19.369 99 52 104 1 2024150032 39184960 17050256
17:41:49 4704 8192000000 10965648752 11393781760 1986258560 19.514 100 57 107 2 2045958656 41792160 17907936
17:42:04 3812 8192000000 10943311104 11375575040 1954987616 19.266 99 64 129 1 2017091520 40813616 21290288
17:42:18 12358 8192000000 10950206080 11382726656 1959519616 19.302 99 43 84 2 2017037712 42084928 15433168
17:42:37 5610 8192000000 10931840528 11359985664 1936342320 19.118 99 66 132 0 2006072496 47639344 22090832
17:42:53 19182 8192000000 10919589152 11370319872 1962260448 19.324 100 29 58 0 2014749152 42280800 10207904
17:43:35 17515 8192000000 10903940560 11349483520 1958177056 19.292 100 42 84 1 2005611712 33734432 13700224
17:44:02 9005 8192000000 10920392112 11358343168 1956300048 19.277 100 32 63 2 2000450608 33421120 10729440
17:44:18 8976 8192000000 10915852608 11353260032 1931859344 19.082 99 47 93 2 1980331056 33994320 14477392
17:44:33 9531 8192000000 10911657024 11350564864 1935364672 19.110 99 36 72 2 1982279472 35396624 11518176
17:44:50 5921 8192000000 10920119232 11356717056 1947834368 19.209 100 37 73 0 2001514448 42110608 11569472
17:45:14 5161 8192000000 10918168000 11352084480 1950624560 19.231 100 54 106 0 2010799264 43686576 16488128
17:45:30 9139 8192000000 10927365488 11357663232 1955520864 19.270 100 42 81 3 2006094672 38025744 12548064
17:45:46 12497 8192000000 10917220992 11365756928 1957845488 19.289 100 41 82 0 2011069280 40171984 13051808
17:46:09 11446 8192000000 10924510560 11358810112 1936749328 19.121 99 27 54 1 1986977728 41019952 9208448
17:46:26 19675 8192000000 10885830400 11324866560 1876914448 18.640 96 35 70 2 1932126032 43710496 11501088
17:46:53 15431 8192000000 10863206416 11297722368 1886980848 18.721 99 34 68 0 1936693312 38723984 10988480
17:47:31 13169 8192000000 10857758944 11302031360 1883925440 18.697 99 21 42 3 1925753392 34599408 7228544
17:47:50 14134 8192000000 10862552048 11307139072 1906499040 18.879 100 26 52 1 1949016576 33953136 8564400
17:48:14 21539 8192000000 10877708288 11317493760 1883943456 18.697 98 27 54 1 1931354080 37501456 9909168
17:48:42 21924 8192000000 10878677824 11318198272 1925169408 19.028 100 26 52 0 1964818080 30574928 9073744
17:49:20 28586 8192000000 10881314528 11320872960 1908207520 18.892 99 28 56 1 1952008160 34488864 9311776
17:50:06 25502 8192000000 10870109808 11316891648 1905131392 18.868 99 19 38 1 1942643472 30903168 6608912
17:50:59 32365 8192000000 10867632672 11325681664 1901187328 18.836 99 16 31 0 1943276480 36190096 5899056
17:51:46 27294 8192000000 10844648912 11314241536 1871638064 18.598 98 10 18 1 1904724688 29787328 3299296
17:52:22 34234 8192000000 10806333664 11254702080 1827558128 18.239 96 16 29 1 1838922096 6902768 4461200
17:53:31 57129 8192000000 10835898624 11263717376 1873113392 18.609 99 28 56 2 1891385904 9758096 8514416
17:54:36 78376 8192000000 10824593776 11272564736 1858866704 18.494 98 11 22 2 1874502784 12296976 3339104
17:56:03 92783 8192000000 10842413760 11285569536 1816186688 18.147 95 13 26 1 1830525152 11272944 3065520
17:57:42 35897 8192000000 10851240624 11301675008 1901262128 18.836 99 11 22 0 1914588240 10139008 3187104
17:58:26 187217 8192000000 10869333232 11329388544 1838719616 18.330 95 4 8 0 1853133632 13400416 1013600
18:02:51 82593 8192000000 10880027904 11330007040 1928548304 19.055 99 23 45 0 1951872320 16223200 7100816
18:04:20 52043 8192000000 10892634240 11339681792 1948956592 19.218 100 40 79 2 1969323056 9475392 10891072
18:05:18 91870 8192000000 10895862368 11344805888 1937979888 19.131 99 37 74 1 1958915968 10550240 10385840
18:07:05 41363 8192000000 10909682736 11354099712 1943228160 19.173 99 30 60 0 1962693360 10237568 9227632
18:07:52 53037 8192000000 10902983136 11362156544 1958729824 19.296 100 21 41 2 1978550016 13751344 6068848
18:08:53 48883 8192000000 10904236768 11383300096 1970320512 19.388 100 24 47 2 1998749056 21416976 7011568
18:09:50 54368 8192000000 10902383936 11376025600 1971529456 19.398 100 10 20 0 1992579824 17851552 3198816
18:10:54 125808 8192000000 10922007920 11397906432 1983510704 19.492 100 15 29 2 2000798112 12971600 4315808
18:13:07 60534 8192000000 10927439056 11403481088 1993326832 19.570 100 20 39 3 2019675520 19955360 6393328
18:14:14 40956 8192000000 10913810160 11392323584 1977050416 19.441 99 8 16 0 1995238208 16133888 2053904
18:15:09 65090 8192000000 10937456928 11401723904 1994675616 19.581 100 37 75 2 2025111664 19713232 10722816
18:17:00 64133 8192000000 10912350512 11395923968 1961111840 19.315 98 13 26 1 1977069888 12135440 3822608
18:18:37 72084 8192000000 10927736864 11404214272 1974434208 19.421 99 8 16 0 1987302384 10956976 1911200
18:20:00 48610 8192000000 10940549584 11412918272 1987949248 19.528 99 32 65 0 2013051232 16109296 8992688
18:21:47 29309 8192000000 10927889984 11392696320 1954056832 19.259 98 12 24 0 1974160864 16971744 3132288
18:22:23 51941 8192000000 10921626864 11381870592 1948269600 19.213 98 27 54 1 1965569008 9958128 7341280
18:23:35 54942 8192000000 10897147440 11357732864 1870354416 18.587 94 18 37 0 1886889104 11070096 5464592
18:24:36 106813 8192000000 10906051760 11354886144 1902047184 18.843 97 18 35 2 1922855536 15708944 5099408
18:26:30 28747 8192000000 10891934752 11351269376 1902976512 18.850 97 26 53 1 1919433568 9257360 7199696
18:27:07 41549 8192000000 10910411328 11378679808 1969676784 19.383 100 21 42 1 1987552096 11925648 5949664
18:27:55 78601 8192000000 10900172528 11367419904 1911079632 18.915 97 7 14 1 1927340128 14324832 1935664
18:29:22 55542 8192000000 10885844624 11353710592 1898492416 18.814 96 16 30 1 1911551872 8823376 4236080
18:30:25 122853 8192000000 10906121904 11381559296 1972046608 19.402 100 23 47 0 1991389488 13253616 6089264
18:32:47 63462 8192000000 10909196992 11382140928 1938925888 19.138 98 34 68 1 1962639120 14145632 9567600
18:34:12 74979 8192000000 10882971312 11360133120 1901170912 18.836 96 25 50 0 1928699904 20333360 7195632
18:36:05 40724 8192000000 10908527872 11366875136 1956133424 19.275 99 35 70 2 1976428048 10074608 10220016
18:37:08 59650 8192000000 10839193824 11311837184 1790657280 17.937 92 8 16 0 1801212176 7940976 2613920
18:38:19 66828 8192000000 10835574960 11299033088 1860250848 18.505 96 15 30 0 1872189808 7236032 4702928
18:39:32 38943 8192000000 10856455984 11322183680 1910702160 18.912 99 17 35 1 1928674784 13227792 4744832
18:40:34 41277 8192000000 10847163568 11328958464 1914744976 18.945 99 8 16 0 1927271440 10100080 2426384
18:41:24 10440 8192000000 10874424320 11342528512 1942914832 19.170 100 21 42 2 1957105792 8053424 6137536
18:41:44 51647 8192000000 10834838176 11300540416 1839584752 18.337 95 32 63 1 1858447168 9611344 9251072
18:43:12 94946 8192000000 10834698976 11320127488 1868501152 18.572 97 9 18 1 1885305984 14316144 2488688
18:44:53 45704 8192000000 10852165520 11323109376 1888688560 18.735 98 16 33 1 1902968608 10375808 3904240
18:45:53 37955 8192000000 10846959088 11303256064 1848156752 18.407 96 25 47 0 1864306320 9166624 6982944
18:46:37 51540 8192000000 10833075520 11297972224 1851054112 18.431 97 18 36 0 1869771232 13126960 5590160
18:47:35 47718 8192000000 10820997776 11274792960 1829742400 18.257 96 26 52 0 1851983888 14029312 8212176
18:48:29 50098 8192000000 10837679808 11300962304 1882495248 18.685 99 16 32 0 1902539504 15416688 4627568
18:49:32 57875 8192000000 10868335248 11314257920 1916655664 18.960 100 21 42 0 1935973968 13463440 5854864
18:50:39 94712 8192000000 10859300880 11326656512 1846105664 18.390 96 19 38 1 1864499184 13170624 5222896
18:52:21 20647 8192000000 10871886896 11331915776 1930735776 19.073 100 26 52 2 1954475776 16121296 7618704
18:52:52 50344 8192000000 10863861840 11326541824 1913257632 18.933 99 38 74 1 1938359312 14663328 10438352
18:53:53 31060 8192000000 10877841104 11352203264 1929967040 19.067 100 17 34 2 1950370160 15537680 4865440
18:54:31 39509 8192000000 10878902256 11344039936 1922055216 19.003 99 30 60 2 1946192992 15469952 8667824
18:55:43 40116 8192000000 10888189520 11353378816 1942639504 19.168 100 14 28 0 1961286640 14859248 3787888
18:56:29 89551 8192000000 10888387200 11359543296 1932267792 19.085 99 12 24 0 1954587648 19134608 3185248
18:58:06 124573 8192000000 10919274240 11381018624 1949363488 19.221 99 27 54 2 1968578320 11401424 7813408
19:00:18 68505 8192000000 10910201456 11388514304 1977902128 19.448 100 26 52 2 2006616224 21416064 7298032
19:01:35 45281 8192000000 10901096336 11380871168 1978116512 19.450 100 18 36 2 1998013696 14602624 5294560
19:02:34 48545 8192000000 10885506400 11374804992 1955258912 19.268 99 7 14 1 1967512960 10414992 1839056
19:03:31 43989 8192000000 10898667664 11372666880 1978431376 19.452 100 14 28 0 1990388528 7883584 4073568
19:04:28 85531 8192000000 10914457520 11391328256 1989774848 19.542 100 16 32 1 2006368448 12027696 4565904
19:07:32 64648 8192000000 10894419008 11379482624 1968372880 19.373 99 11 22 0 1983033488 11269424 3391184
19:08:54 55745 8192000000 10896607776 11381190656 1957298240 19.285 99 17 35 1 1970656800 8160128 5198432
19:09:56 57428 8192000000 10908936896 11381288960 1963154512 19.331 99 18 36 0 1979691056 10889552 5646992
19:11:03 38916 8192000000 10903560944 11383668736 1944900400 19.186 98 18 36 0 1957771264 7988400 4882464
19:11:59 54267 8192000000 10895845696 11363586048 1891392064 18.757 95 30 58 1 1910997856 11615056 7990736
19:13:03 56876 8192000000 10902261264 11365470208 1943417616 19.174 99 16 32 3 1961003152 12874976 4710560
19:14:09 44953 8192000000 10916222960 11376082944 1965859152 19.353 100 26 50 2 1988539552 15423056 7257344
19:15:01 60394 8192000000 10909644080 11377938432 1935575056 19.111 98 21 42 2 1951744208 10224240 5944912
19:16:08 25818 8192000000 10923575584 11388350464 1963740592 19.336 99 39 78 3 1988285184 13521936 11022656
19:16:42 39955 8192000000 10918307504 11387207680 1942789024 19.169 98 35 70 0 1971786544 19014256 9983264
19:17:30 66293 8192000000 10871638080 11350646784 1904374592 18.861 97 10 18 1 1924104624 17179120 2550912
19:18:43 71398 8192000000 10878059136 11352498176 1867700688 18.566 95 23 46 1 1887409360 13056720 6651952
19:20:05 53567 8192000000 10880517104 11334193152 1850265392 18.424 95 19 38 2 1865445264 9963440 5216432
19:21:06 29033 8192000000 10902920032 11358748672 1938708368 19.136 99 45 90 2 1964291920 12902560 12680992
19:21:52 41594 8192000000 10889557920 11356930048 1942894832 19.170 99 33 64 2 1962202800 10394192 8913776
19:23:17 86241 8192000000 10884727760 11353341952 1944912128 19.186 99 24 48 0 1963306480 11868656 6525696
19:24:58 51650 8192000000 10888229472 11372904448 1971783984 19.400 100 16 32 0 1988097824 10978576 5335264

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 05-12-2020 19:29:35 to 05-12-2020 19:30:05.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 05-12-2020 19:30:06 to 05-12-2020 19:30:07.

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          240071
MON$OLDEST_ACTIVE               240072
MON$OLDEST_SNAPSHOT             240072
MON$NEXT_TRANSACTION            240072
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

--- start of diff output ---
:11: 
:12: mscs-test-161.budzdorov.ru    Sat Dec  5 19:27:28 2020
:13:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:14: 
:15: 
:16: mscs-test-161.budzdorov.ru    Sat Dec  5 19:27:38 2020
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
--- end of diff output ---

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

05.12.20 19:30:08. 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-05 19:30:11 No severe PSQL-related problems occured
05.12.20 19:30:12. End of report.