Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.12.2020 22: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 17205408 kB
MemAvailable 31452180 kB
Buffers 0 kB
Cached 14459084 kB
SwapCached 3700 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-24 22:27:09
DTS_END                         2020-12-24 22:27:09.1730
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/40678
TRN_ID                          254706
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: 9830.30 19056 1179636
customer order: creation 187.29 306 22475
customer order: refuse 16.82 261 2018
order to supplier: creation 49.26 1070 5911
order to supplier: removal 3.63 75045 436
invoice (draft): creation 49.61 2737 5953
invoice (draft): removal 54.85 576 6582
invoice accept: apply 45.61 14676 5473
invoice accept: cancel 50.40 597 6048
customer reserve: creation 4161.64 148 499397
customer reserve: removal 4891.93 44 587031
realization accept: apply 90.18 149 10822
realization accept: cancel 89.68 84 10761
payment from customer: creation 63.89 98 7667
payment from customer: removal 6.29 68 755
payment to supplier: creation 52.31 113 6277
payment to supplier: removal 4.04 86 485
service: total inventory turnovers 5.11 902 613
service: total monetary turnovers 6.86 28 823
service: aggregate perf. data 0.88 20518 105
service: refresh index statistics 0.03 263608 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10302
TEST_TIME 2 7775
TEST_TIME 3 6604
TEST_TIME 4 6060
TEST_TIME 5 6642
TEST_TIME 6 6543
TEST_TIME 7 6847
TEST_TIME 8 7214
TEST_TIME 9 7374
TEST_TIME 10 7775
TEST_TIME 11 8229
TEST_TIME 12 8165
TEST_TIME 13 9032
TEST_TIME 14 9686
TEST_TIME 15 9823
TEST_TIME 16 9990
TEST_TIME 17 10461
TEST_TIME 18 10999
TEST_TIME 19 11445
TEST_TIME 20 11779
TEST_TIME 21 12004
TEST_TIME 22 12359
TEST_TIME 23 12027
TEST_TIME 24 12024
TEST_TIME 25 11760
TEST_TIME 26 11757
TEST_TIME 27 11795
TEST_TIME 28 11785
TEST_TIME 29 11868
TEST_TIME 30 11556
TEST_TIME 31 11233
TEST_TIME 32 11108
TEST_TIME 33 10996
TEST_TIME 34 10852
TEST_TIME 35 11095
TEST_TIME 36 10948
TEST_TIME 37 10853
TEST_TIME 38 10702
TEST_TIME 39 10505
TEST_TIME 40 10373
TEST_TIME 41 10652
TEST_TIME 42 10543
TEST_TIME 43 10489
TEST_TIME 44 10484
TEST_TIME 45 10483
TEST_TIME 46 10507
TEST_TIME 47 10718
TEST_TIME 48 10693
TEST_TIME 49 10620
TEST_TIME 50 10671
TEST_TIME 51 10676
TEST_TIME 52 10643
TEST_TIME 53 10716
TEST_TIME 54 10528
TEST_TIME 55 10511
TEST_TIME 56 10421
TEST_TIME 57 10338
TEST_TIME 58 10372
TEST_TIME 59 10271
TEST_TIME 60 10218
TEST_TIME 61 10170
TEST_TIME 62 10148
TEST_TIME 63 10086
TEST_TIME 64 10217
TEST_TIME 65 10246
TEST_TIME 66 10205
TEST_TIME 67 10243
TEST_TIME 68 10298
TEST_TIME 69 10228
TEST_TIME 70 10171
TEST_TIME 71 10290
TEST_TIME 72 10273
TEST_TIME 73 10328
TEST_TIME 74 10354
TEST_TIME 75 10334
TEST_TIME 76 10377
TEST_TIME 77 10361
TEST_TIME 78 10237
TEST_TIME 79 10182
TEST_TIME 80 10158
TEST_TIME 81 10065
TEST_TIME 82 10137
TEST_TIME 83 10062
TEST_TIME 84 10026
TEST_TIME 85 10083
TEST_TIME 86 10093
TEST_TIME 87 10090
TEST_TIME 88 10116
TEST_TIME 89 10098
TEST_TIME 90 10085
TEST_TIME 91 10091
TEST_TIME 92 10112
TEST_TIME 93 10095
TEST_TIME 94 10065
TEST_TIME 95 10105
TEST_TIME 96 10097
TEST_TIME 97 10146
TEST_TIME 98 10159
TEST_TIME 99 10164
TEST_TIME 100 10158
TEST_TIME 101 10123
TEST_TIME 102 10047
TEST_TIME 103 10102
TEST_TIME 104 10067
TEST_TIME 105 10062
TEST_TIME 106 10006
TEST_TIME 107 9997
TEST_TIME 108 9956
TEST_TIME 109 9923
TEST_TIME 110 9899
TEST_TIME 111 9884
TEST_TIME 112 9871
TEST_TIME 113 9861
TEST_TIME 114 9871
TEST_TIME 115 9837
TEST_TIME 116 9851
TEST_TIME 117 9941
TEST_TIME 118 9903
TEST_TIME 119 9887
TEST_TIME 120 9837

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 24-12-2020 22:28:30 to 24-12-2020 22:28:34.

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 1641674 1641674 0 0.00 0 15416 5 0 0
doc_list_biud 1641674 1641674 0 0.00 0 43758 20 0 0
sp_add_invoice_to_stock 5638 5473 165 2.92 33 173052 14677 0 165
sp_cancel_adding_invoice 6048 6048 0 0.00 5 56854 598 0 0
sp_cancel_client_order 2018 2018 0 0.00 4 28817 261 0 0
sp_cancel_customer_reserve 587031 587031 0 0.00 1 43762 44 0 0
sp_cancel_pay_from_customer 755 755 0 0.00 3 4799 69 0 0
sp_cancel_pay_to_supplier 485 485 0 0.00 3 7573 87 0 0
sp_cancel_supplier_invoice 6599 6582 17 0.25 2 37064 576 0 17
sp_cancel_supplier_order 436 436 0 0.00 6 893497 75045 0 0
sp_cancel_write_off 10761 10761 0 0.00 1 11203 85 0 0
sp_client_order 22475 22475 0 0.00 3 31331 307 0 0
sp_customer_reserve 499397 499397 0 0.00 0 46985 148 0 0
sp_fill_shopping_cart 34325 34325 0 0.00 1 10282 30 0 0
sp_fill_shopping_cart_clo_res 499385 499385 0 0.00 0 14032 13 0 0
sp_get_clo_for_invoice 5461 5461 0 0.00 0 25711 299 0 0
sp_kill_cost_storno 18049 18049 0 0.00 0 11255 37 0 0
sp_kill_qstorno_ret_qs2qd 1191841 1191841 0 0.00 0 43755 24 0 0
sp_kill_qty_storno 629158 629158 0 0.00 0 43757 52 0 0
sp_lock_selected_doc 22659 22659 0 0.00 0 7565 5 0 0
sp_make_cost_storno 30226 30226 0 0.00 0 15415 42 0 0
sp_multiply_rows_for_pdistr 30226 30226 0 0.00 0 8147 24 0 0
sp_multiply_rows_for_qdistr 22475 22475 0 0.00 0 11234 145 0 0
sp_pay_from_customer 7667 7667 0 0.00 4 13618 99 0 0
sp_pay_to_supplier 6277 6277 0 0.00 5 15419 114 0 0
sp_payment_common 13944 13944 0 0.00 1 13485 29 0 0
sp_qd_handle_on_cancel_clo 2018 2018 0 0.00 0 28810 236 0 0
sp_qd_handle_on_invoice_upd_sts 11508 11508 0 0.00 0 27262 253 0 0
sp_qd_handle_on_reserve_upd_sts 10822 10822 0 0.00 0 32520 51 0 0
sp_reserve_write_off 10822 10822 0 0.00 6 32538 150 0 0
sp_supplier_invoice 5953 5953 0 0.00 7 73626 2737 0 0
sp_supplier_order 5911 5911 0 0.00 5 70770 1071 0 0
srv_aggregate_perf_data 105 105 0 0.00 2779 476422 20519 0 0
srv_fill_mon_cache_memory 144 144 0 0.00 1269 164577 37917 0 0
srv_find_qd_qs_mism 1127831 1127831 0 0.00 0 7308 5 0 0
srv_make_invnt_saldo 613 613 0 0.00 43 60954 902 0 0
srv_make_money_saldo 823 823 0 0.00 1 6275 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 176213 364050 263608 0 0
t$perf-abend:sp_add_invoice_to_stock 165 165 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 17 17 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5473 5473 0 0.00 0 12775 135 0 0
t$perf-norm:sp_cancel_adding_invoice 455 455 0 0.00 0 14852 110 0 0
t$perf-norm:sp_cancel_client_order 2018 2018 0 0.00 0 1901 8 0 0
t$perf-norm:sp_cancel_customer_reserve 699 699 0 0.00 0 5215 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 755 755 0 0.00 0 2702 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 485 485 0 0.00 0 6932 20 0 0
t$perf-norm:sp_cancel_supplier_invoice 444 444 0 0.00 0 2911 17 0 0
t$perf-norm:sp_cancel_supplier_order 436 436 0 0.00 0 34540 1258 0 0
t$perf-norm:sp_cancel_write_off 1085 1085 0 0.00 0 510 3 0 0
t$perf-norm:sp_client_order 22475 22475 0 0.00 0 11604 14 0 0
t$perf-norm:sp_customer_reserve 1040 1040 0 0.00 0 240 2 0 0
t$perf-norm:sp_pay_from_customer 7667 7667 0 0.00 0 6641 9 0 0
t$perf-norm:sp_pay_to_supplier 6277 6277 0 0.00 0 6890 9 0 0
t$perf-norm:sp_reserve_write_off 10822 10822 0 0.00 0 8901 10 0 0
t$perf-norm:sp_supplier_invoice 5953 5953 0 0.00 0 4137 12 0 0
t$perf-norm:sp_supplier_order 5911 5911 0 0.00 0 6702 13 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 31 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 144 144 0 0.00 0 204 3 0 0
t$perf-norm:srv_make_invnt_saldo 613 613 0 0.00 0 8590 29 0 0
t$perf-norm:srv_make_money_saldo 823 823 0 0.00 0 4906 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 156 41 0 0
v_add_invoice_to_stock 11250 10920 330 2.93 0 5473 16 0 330
v_all_customers 40466 40466 0 0.00 0 156 0 0 0
v_all_suppliers 32312 32312 0 0.00 0 23 1 0 0
v_all_wares 44950 44950 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 910 910 0 0.00 0 2861 10 0 0
v_cancel_client_order 4036 4036 0 0.00 0 3619 4 0 0
v_cancel_customer_prepayment 1510 1510 0 0.00 0 4754 8 0 0
v_cancel_customer_reserve 1398 1398 0 0.00 0 4963 7 0 0
v_cancel_payment_to_supplier 970 970 0 0.00 0 1827 4 0 0
v_cancel_supplier_invoice 922 888 34 3.68 0 1768 15 0 34
v_cancel_supplier_order 872 872 0 0.00 0 2063 5 0 0
v_cancel_write_off 2170 2170 0 0.00 0 1910 12 0 0
v_max_id_clo_ord 5911 5911 0 0.00 0 274 1 0 0
v_max_id_clo_res 1040 1040 0 0.00 0 3233 16 0 0
v_max_id_ord_sup 5939 5939 0 0.00 0 3459 3 0 0
v_max_non_paid_invoice 1971 1971 0 0.00 0 313 2 0 0
v_max_non_paid_realizn 4246 4246 0 0.00 0 3341 5 0 0
v_min_id_clo_ord 5911 5911 0 0.00 0 6293 8 0 0
v_min_id_clo_res 1040 1040 0 0.00 0 1123 3 0 0
v_min_id_ord_sup 5939 5939 0 0.00 0 4464 7 0 0
v_min_non_paid_invoice 6277 6277 0 0.00 0 7524 21 0 0
v_min_non_paid_realizn 7667 7667 0 0.00 0 13481 15 0 0
v_our_firm 11326 11326 0 0.00 0 14 1 0 0
v_reserve_write_off 21644 21644 0 0.00 0 6959 4 0 0
x_lock_depdocs_on_canc_invoice 12186 12186 0 0.00 0 14352 104 0 0
x_lock_depdocs_on_canc_sup_ord 436 436 0 0.00 0 4604 234 0 0
x_make_qstorno_1000_1200 5911 5911 0 0.00 2 70754 1004 0 0
x_make_qstorno_1200_2000 5953 5953 0 0.00 2 73608 2636 0 0
x_make_qstorno_2100_3300 499397 499397 0 0.00 0 46981 134 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-12-2020 22:28:35 to 24-12-2020 22:28:39.

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:12 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:18 18384 8192000000 10260438384 10572857344 898628832 9.885 69 54 109 0 918659184 2411664 17618688
19:57:45 33643 8192000000 10370798528 10688770048 1399234880 14.588 100 80 160 0 1429342928 4551008 25557040
19:58:29 21915 8192000000 10399945712 10721832960 1448412992 15.024 100 91 181 0 1483935312 6755552 28766768
19:59:06 13461 8192000000 10417521296 10746380288 1470050512 15.214 100 88 176 0 1506032544 7638400 28343632
19:59:29 15830 8192000000 10438893840 10772348928 1494003152 15.424 100 85 170 1 1529411104 7815360 27592592
19:59:58 24013 8192000000 10465901600 10801102848 1514807888 15.605 100 87 174 0 1551007216 8709264 27490064
20:00:40 20579 8192000000 10483262192 10821873664 1537207472 15.799 100 92 184 0 1575851936 9616240 29028224
20:01:13 12802 8192000000 10487311952 10830888960 1543591424 15.855 100 80 160 1 1578307264 9906976 24808864
20:01:41 13099 8192000000 10514525872 10865324032 1571147936 16.092 100 78 156 2 1605195088 9798928 24248224
20:02:02 11709 8192000000 10530300864 10886754304 1594475648 16.292 100 77 154 2 1628663232 10389712 23797872
20:02:23 12202 8192000000 10562089616 10923950080 1625516592 16.557 100 73 146 1 1657853360 10162480 22174288
20:02:42 10400 8192000000 10576332224 10937982976 1639030960 16.672 100 80 160 1 1674098272 10905312 24162000
20:03:00 11837 8192000000 10602990336 10967568384 1661250304 16.859 100 71 142 0 1693213648 10848992 21114352
20:03:19 7770 8192000000 10612323264 10980388864 1675704736 16.981 100 69 138 0 1706570944 11146992 19719216
20:03:35 7065 8192000000 10632926608 11003740160 1698980256 17.177 100 81 162 2 1734693152 11523872 24189024
20:03:50 8328 8192000000 10661849520 11029577728 1713424288 17.297 100 83 166 0 1748579408 11968768 23186352
20:04:08 4077 8192000000 10671873088 11045855232 1730359568 17.438 100 84 168 1 1767254624 13099552 23795504
20:04:18 5148 8192000000 10678328688 11052269568 1736668592 17.491 100 85 170 0 1773105792 12425024 24012176
20:04:30 4698 8192000000 10696216032 11068305408 1753110352 17.627 100 86 172 2 1789904496 12645152 24148992
20:04:41 4901 8192000000 10703097376 11077918720 1757994704 17.668 100 84 164 1 1794661856 13120016 23547136
20:04:53 4191 8192000000 10702122800 11080888320 1768104048 17.751 100 76 150 3 1802349728 13632512 20613168
20:05:04 4237 8192000000 10716368336 11094421504 1780845248 17.856 100 83 166 2 1817685552 13576112 23264192
20:05:15 3382 8192000000 10722085520 11103453184 1786178560 17.900 100 85 170 0 1822849984 13169104 23502320
20:05:25 3369 8192000000 10736222096 11115044864 1790377120 17.935 100 94 189 0 1829998432 14021872 25599440
20:05:35 3507 8192000000 10744658272 11120926720 1796989568 17.989 100 91 182 3 1836968096 15001392 24977136
20:05:45 2385 8192000000 10745484112 11125538816 1803150480 18.040 100 88 176 0 1841682480 13973248 24558752
20:05:54 2220 8192000000 10754576272 11132231680 1807631776 18.076 100 85 169 0 1844908944 13754416 23522752
20:06:02 3263 8192000000 10747011008 11131514880 1811678512 18.110 100 84 167 0 1849561600 14793008 23090080
20:06:12 2870 8192000000 10760962688 11141885952 1813061552 18.121 100 84 169 1 1850642128 14235040 23345536
20:06:22 1903 8192000000 10780540864 11161837568 1832072560 18.276 100 95 191 3 1872749152 13932112 26744480
20:06:30 2029 8192000000 10774858528 11160793088 1839587392 18.337 100 84 167 0 1876809424 13688496 23533536
20:06:39 2138 8192000000 10784983408 11172491264 1844663936 18.379 100 90 179 1 1882456368 13022304 24770128
20:06:47 1634 8192000000 10795780304 11178389504 1849221216 18.416 100 94 186 1 1889285936 14116960 25947760
20:06:55 2042 8192000000 10796048944 11183493120 1850207440 18.424 100 84 169 0 1887475104 13642784 23624880
20:07:04 1360 8192000000 10797089952 11186188288 1853954992 18.454 100 91 185 3 1893464160 14125840 25383328
20:07:12 1412 8192000000 10803027888 11190706176 1859006672 18.495 100 94 189 2 1899888720 13690384 27191664
20:07:20 1267 8192000000 10802670016 11191988224 1864621056 18.541 100 94 187 0 1905871264 14354816 26895392
20:07:27 1838 8192000000 10808334144 11198156800 1864290400 18.538 100 97 194 3 1906010608 14620640 27099568
20:07:35 1172 8192000000 10811630960 11200118784 1870400960 18.588 100 98 195 3 1911131712 12794912 27935840
20:07:43 1389 8192000000 10814550368 11204427776 1869440112 18.580 100 89 176 1 1907598464 13719376 24438976
20:07:50 1111 8192000000 10818962128 11206295552 1873722272 18.614 100 89 181 0 1911585104 11209872 26652960
20:07:57 36324 8192000000 10783963568 11202658304 1871965568 18.600 100 50 99 0 1895252304 8986176 14300560
20:08:43 3811 8192000000 10802607824 11213197312 1875738688 18.631 100 60 120 1 1900673504 7590512 17344304
20:08:59 9357 8192000000 10795919888 11213611008 1877114256 18.642 100 34 67 1 1892646912 6480640 9052016
20:09:15 8607 8192000000 10783769552 11213656064 1882582960 18.686 100 28 56 4 1896764464 5879552 8301952
20:09:30 9267 8192000000 10797309072 11224190976 1883333936 18.692 100 30 60 0 1899616400 7710272 8572192
20:09:48 11159 8192000000 10796924736 11227602944 1885549808 18.710 100 13 26 0 1895233600 5574720 4109072
20:10:07 5700 8192000000 10809930896 11232026624 1889895840 18.745 100 35 70 0 1907977552 8092384 9989328
20:10:19 12777 8192000000 10801980112 11232034816 1888747184 18.736 100 16 33 0 1899299152 5646192 4905776
20:10:38 12597 8192000000 10812317104 11240660992 1895047280 18.786 100 19 38 3 1905507456 5506336 4953840
20:10:57 6444 8192000000 10807638128 11240857600 1895291648 18.788 100 17 34 1 1906014240 5864192 4858400
20:11:10 9963 8192000000 10802425536 11239743488 1897409424 18.805 100 19 38 1 1909560352 6412864 5738064
20:11:28 12914 8192000000 10807188336 11245404160 1900216432 18.828 100 22 44 0 1912716576 6452272 6047872
20:11:48 10643 8192000000 10811698912 11246505984 1903638096 18.856 100 24 49 1 1916608336 6565776 6404464
20:12:07 76824 8192000000 10830305712 11262169088 1908070960 18.891 100 28 55 1 1921668752 5480800 8116992
20:13:30 1290 8192000000 10867096256 11273076736 1920049744 18.987 100 92 186 0 1957098160 9902848 27145568
20:13:38 4292 8192000000 10835791616 11261415424 1908295008 18.893 100 24 48 3 1921357328 6010528 7051792
20:13:50 6722 8192000000 10828908400 11264483328 1913372160 18.934 100 26 52 2 1926482688 6363952 6746576
20:14:03 6349 8192000000 10842625072 11269468160 1913502960 18.935 100 30 60 2 1928384032 6437184 8443888
20:14:16 4348 8192000000 10838388224 11267796992 1917756848 18.969 100 35 71 0 1938252848 10729792 9766208
20:14:27 5970 8192000000 10832950624 11259523072 1910769648 18.913 100 32 64 1 1927680592 7461056 9449888
20:14:39 5985 8192000000 10822199120 11256082432 1894649792 18.783 99 31 62 0 1910688928 6548192 9490944
20:14:53 5727 8192000000 10812768880 11245068288 1873255472 18.611 98 29 58 2 1888005360 6029008 8720880
20:15:06 5806 8192000000 10816986464 11248771072 1901490912 18.838 100 27 54 2 1915935504 7129360 7315232
20:15:20 5494 8192000000 10809774656 11243433984 1884976144 18.705 99 35 71 4 1901450688 6395088 10079456
20:15:32 33436 8192000000 10798124000 11217629184 1804895376 18.054 95 33 64 3 1819851360 5448784 9507200
20:16:11 18020 8192000000 10802059056 11227828224 1841519696 18.353 98 18 36 2 1856500048 9942672 5037680
20:16:39 6564 8192000000 10811914480 11240505344 1890601744 18.751 100 40 79 3 1913304384 11413632 11289008
20:16:54 8520 8192000000 10822616576 11243905024 1871851504 18.599 99 35 70 1 1892016960 10468944 9696512
20:17:09 8541 8192000000 10807305840 11240255488 1875657792 18.630 99 20 40 0 1888517328 7483744 5375792
20:17:23 4276 8192000000 10788242400 11213983744 1843440048 18.369 98 27 54 2 1857219088 5496000 8283040
20:17:34 4774 8192000000 10757078784 11182223360 1823467344 18.206 98 29 55 3 1838544208 6746208 8330656
20:17:45 5206 8192000000 10716349760 11124633600 1704652848 17.224 92 26 53 0 1718618400 5614992 8350560
20:17:58 8661 8192000000 10736328096 11153727488 1751607008 17.615 96 28 56 2 1766077952 5513840 8957104
20:18:14 3953 8192000000 10730801216 11150041088 1782145296 17.867 98 28 57 3 1796556000 5879328 8531376
20:18:25 5176 8192000000 10726596384 11140976640 1788242672 17.917 99 36 72 0 1808674944 10411024 10021248
20:18:36 8289 8192000000 10683728880 11097681920 1714359952 17.305 95 11 22 0 1726459008 9081216 3017840
20:18:51 8072 8192000000 10698529136 11111972864 1750555456 17.606 98 18 34 2 1760996720 5540976 4900288
20:19:06 8602 8192000000 10692029168 11111415808 1738694544 17.508 97 22 43 2 1750666432 5488304 6483584
20:19:22 13623 8192000000 10701755632 11123331072 1724222352 17.387 96 23 46 0 1736257696 5475264 6560080
20:19:42 75826 8192000000 10687924992 11107274752 1707549744 17.248 95 28 54 1 1721469680 5272896 8647040
20:21:07 8415 8192000000 10730305040 11144622080 1791705920 17.946 99 38 76 3 1809076608 6523376 10847312
20:21:22 7043 8192000000 10702009536 11114192896 1772368288 17.787 98 43 85 2 1792048608 6878576 12801744
20:21:37 8108 8192000000 10706158304 11126448128 1765870320 17.733 98 24 48 5 1778813328 6053792 6889216
20:21:53 6511 8192000000 10736481136 11150848000 1810450480 18.100 100 24 47 1 1822106544 4977232 6678832
20:22:06 7690 8192000000 10730936640 11159670784 1824060272 18.211 100 23 46 1 1836030064 6026464 5943328
20:22:20 8369 8192000000 10751683728 11166969856 1833245680 18.286 100 39 78 1 1850983616 5580864 12157072
20:22:35 6402 8192000000 10760719472 11179917312 1833134976 18.285 100 22 44 1 1846136384 6238656 6762752
20:22:47 7460 8192000000 10750978448 11179552768 1838381072 18.328 100 15 30 1 1848208416 5618016 4209328
20:23:01 7975 8192000000 10770875920 11189829632 1847822624 18.404 100 24 48 2 1860300000 5942048 6535328
20:23:18 10068 8192000000 10761442352 11193270272 1852139744 18.440 100 21 41 1 1863440928 5496448 5804736
20:23:34 7692 8192000000 10770815072 11199057920 1855105312 18.464 100 16 32 0 1864754896 5194768 4454816
20:23:51 14882 8192000000 10775559184 11209117696 1863715824 18.533 100 15 30 0 1873578080 5484816 4377440
20:24:16 14212 8192000000 10782162496 11211923456 1870471456 18.588 100 29 57 2 1885691376 6552528 8667392
20:24:38 74047 8192000000 10777423664 11213365248 1871791664 18.599 100 38 76 0 1888984720 5981904 11211152
20:25:59 11717 8192000000 10783024800 11215298560 1871344864 18.595 100 23 46 0 1883638656 5032288 7261504
20:26:20 6241 8192000000 10788410304 11218792448 1871946592 18.600 100 29 58 2 1886489504 6709856 7833056
20:26:36 6412 8192000000 10792871648 11224473600 1877545232 18.645 100 36 72 3 1894949200 5425360 11978608
20:26:49 8271 8192000000 10795604672 11225870336 1877656704 18.646 100 36 72 2 1894933504 6949344 10327456
20:27:06 8687 8192000000 10821616256 11238944768 1891205856 18.755 100 27 55 1 1903500752 4742656 7552240
20:27:26 14008 8192000000 10852499920 11270152192 1913036944 18.931 100 36 68 2 1928807152 5928352 9841856
20:27:52 4544 8192000000 10851690912 11275427840 1924161296 19.020 100 50 100 2 1946459728 8238768 14059664
20:28:07 6162 8192000000 10860803520 11282837504 1929852768 19.066 100 57 111 2 1954780144 9065968 15861408
20:28:25 26764 8192000000 10864277888 11291717632 1931631808 19.080 100 48 96 0 1954478976 9433600 13413568
20:29:10 39482 8192000000 10865361584 11303522304 1938783664 19.137 100 30 60 0 1955159120 8128384 8247072
20:29:58 15334 8192000000 10881541456 11311513600 1950358272 19.229 100 44 88 1 1974321088 11111424 12851392
20:30:20 8680 8192000000 10892198096 11321044992 1955642080 19.271 100 53 106 1 1984297120 13240752 15414288
20:30:40 25146 8192000000 10890554976 11321888768 1960386672 19.309 100 48 96 2 1988370224 14232224 13751328
20:31:14 27943 8192000000 10885167440 11324715008 1956585776 19.279 100 39 75 0 1981585904 13030112 11970016
20:31:49 41848 8192000000 10910988368 11351756800 1968256848 19.372 100 36 72 2 2003911952 24723120 10931984
20:32:38 16934 8192000000 10912503600 11350401024 1976412768 19.436 100 45 90 1 2007989728 18221040 13355920
20:33:07 10985 8192000000 10902174032 11340701696 1963269696 19.332 100 40 80 1 1992500640 16887376 12343568
20:33:26 18302 8192000000 10902195616 11332657152 1941659232 19.160 99 46 91 1 1973563264 18812448 13091584
20:33:52 6881 8192000000 10912424672 11342659584 1963958016 19.337 100 44 88 1 1998074672 21084704 13031952
20:34:13 17170 8192000000 10925101728 11356569600 1973328816 19.412 100 54 108 0 2008895536 19410112 16156608
20:34:37 3595 8192000000 10930470336 11363262464 1980041520 19.465 100 56 111 2 2019323888 22964448 16317920
20:34:52 6450 8192000000 10935422944 11362095104 1980322160 19.467 100 62 124 1 2021402672 22838000 18242512
20:35:06 9585 8192000000 10943005408 11370242048 1986339216 19.515 100 63 126 1 2031904912 27080432 18485264
20:35:23 3151 8192000000 10935891104 11365761024 1971725312 19.399 99 59 117 4 2017215168 26606288 18883568
20:35:33 9533 8192000000 10934116736 11358953472 1953142320 19.251 98 73 146 4 1999898752 25755920 21000512
20:35:50 4316 8192000000 10946729072 11373047808 1984132848 19.497 100 56 112 3 2026249440 25388096 16728496
20:36:03 4421 8192000000 10962570000 11384094720 1995363008 19.586 100 66 131 1 2041918496 27556416 18999072
20:36:15 1702 8192000000 10960905552 11382902784 1998450368 19.611 100 70 140 1 2047443888 28336608 20656912
20:36:24 9269 8192000000 10944319952 11366178816 1971057824 19.394 99 58 115 0 2019814784 32127120 16629840
20:36:41 1914 8192000000 10960926800 11378421760 1986573904 19.517 100 76 148 2 2038593776 30525344 21494528
20:36:49 5513 8192000000 10942539728 11370835968 1972576720 19.406 99 73 144 0 2024987616 30745120 21665776
20:37:03 6005 8192000000 10948141424 11368779776 1968336816 19.372 99 62 123 1 2018992736 31532992 19122928
20:37:16 1269 8192000000 10935849568 11349061632 1960568064 19.311 99 86 170 2 2019096736 32779504 25749168
20:37:24 1452 8192000000 10956121824 11371724800 1984314992 19.499 100 85 168 0 2041446304 31874416 25256896
20:37:32 1288 8192000000 10954406576 11362267136 1961649168 19.319 99 87 172 2 2020219408 32750832 25819408
20:37:41 4311 8192000000 10955847728 11373015040 1967293472 19.364 99 74 148 1 2022376480 33243616 21839392
20:37:52 6403 8192000000 10953859280 11371634688 1984628912 19.501 100 79 159 2 2042016512 33999392 23388208
20:38:08 4318 8192000000 10958957440 11375714304 1984027888 19.497 100 78 156 1 2041667264 34688144 22951232
20:38:21 2186 8192000000 10949240832 11362639872 1973245648 19.411 100 85 168 2 2034806912 36181968 25379296
20:38:35 1833 8192000000 10957515472 11368648704 1972677184 19.407 100 92 185 1 2038628208 37416960 28534064
20:38:46 2417 8192000000 10948520224 11365720064 1972826048 19.408 100 74 148 0 2032123008 36726896 22570064
20:38:56 1878 8192000000 10942884704 11360546816 1971319840 19.396 100 72 141 1 2027748608 35497856 20930912
20:39:07 2929 8192000000 10967002208 11375259648 1977316624 19.443 100 83 166 1 2040161376 37785648 25059104
20:39:18 5250 8192000000 10951247424 11367170048 1975263600 19.427 100 76 150 1 2037732096 39321984 23146512
20:39:31 2443 8192000000 10962954720 11372748800 1980767456 19.471 100 81 161 0 2044613776 39031680 24814640
20:39:40 5868 8192000000 10924943920 11331698688 1923620448 19.016 98 77 153 2 1988942496 41496080 23825968
20:39:53 3204 8192000000 10950417552 11360792576 1964838688 19.344 100 84 168 0 2034917872 43746736 26332448
20:40:03 2572 8192000000 10926996432 11329134592 1925318848 19.029 99 80 156 1 1989050400 38964416 24767136
20:40:15 7400 8192000000 10907630016 11336257536 1946355040 19.197 100 60 120 1 2003148096 38239952 18553104
20:40:37 18459 8192000000 10924461760 11343781888 1944385920 19.182 99 42 84 0 1991438656 32924048 14128688
20:41:02 3400 8192000000 10916236336 11334840320 1920972784 18.995 98 63 127 1 1981112432 39707984 20431664
20:41:13 2502 8192000000 10939167456 11352674304 1955636176 19.271 100 84 166 0 2022564336 41440400 25487760
20:41:23 22122 8192000000 10924256288 11361984512 1943533472 19.175 99 42 84 3 2001692064 44099648 14058944
20:41:57 19645 8192000000 10881419728 11316105216 1865080992 18.544 96 28 56 0 1913877744 38916368 9880384
20:42:25 7596 8192000000 10904737104 11329056768 1931152560 19.076 100 40 79 2 1980070400 36765488 12152352
20:42:40 15970 8192000000 10878455456 11311833088 1887481232 18.725 98 27 54 0 1934188928 37511344 9196352
20:43:05 3993 8192000000 10904963600 11317706752 1918371184 18.974 100 68 136 4 1980853024 40005616 22476224
20:43:16 4114 8192000000 10937257120 11344629760 1939429008 19.142 100 78 157 1 2009090768 44732032 24929728
20:43:26 4658 8192000000 10928957504 11352772608 1926362400 19.038 99 60 120 0 1995175248 49994832 18818016
20:43:47 26595 8192000000 10901466848 11341778944 1903998912 18.858 98 27 54 1 1963908640 50984032 8925696
20:44:24 8228 8192000000 10909808352 11353157632 1945691264 19.192 100 39 78 1 2003841840 45378496 12772080
20:44:41 19373 8192000000 10893319072 11334012928 1901957712 18.842 98 30 60 2 1955786000 43592688 10235600
20:45:08 37064 8192000000 10837969840 11276173312 1841056016 18.349 96 23 45 2 1889014464 39921536 8036912
20:45:54 23428 8192000000 10857182816 11306082304 1899291376 18.821 100 19 38 0 1948547952 42653120 6603456
20:46:28 32610 8192000000 10862892896 11318370304 1897769296 18.808 99 15 30 1 1929417184 26962928 4684960
20:47:08 35716 8192000000 10880881152 11332980736 1921274496 18.997 100 23 46 2 1967837888 39528864 7034528
20:48:06 34561 8192000000 10851695200 11310297088 1858615168 18.492 97 17 34 3 1894484768 30582464 5287136
20:48:47 66204 8192000000 10833198640 11290972160 1851512912 18.434 97 9 18 0 1868680464 14696656 2470896
20:50:00 30105 8192000000 10853178624 11294707712 1904235200 18.860 99 47 95 3 1923442624 6105728 13101696
20:50:38 20365 8192000000 10855966592 11293081600 1903514032 18.855 99 61 122 2 1929320000 8197984 17607984
20:51:09 88290 8192000000 10857358896 11302092800 1883271872 18.692 98 23 44 7 1899529296 10137728 6119696
20:52:49 86522 8192000000 10862442304 11329560576 1891756656 18.760 98 9 18 0 1905015056 10773920 2484480
20:54:21 105803 8192000000 10882862272 11332481024 1897225888 18.804 98 9 18 0 1916940144 16911520 2802736
20:56:15 88991 8192000000 10882252624 11337728000 1948998896 19.219 100 12 24 1 1963470352 11435968 3035488
20:57:59 85085 8192000000 10910474928 11366883328 1966967664 19.361 100 34 67 1 1983822576 6631520 10223392
21:00:58 44646 8192000000 10919208912 11374862336 1981418368 19.476 100 26 52 2 2004709040 15140144 8150528
21:01:49 32441 8192000000 10897388288 11369656320 1957155456 19.283 99 21 42 1 1978211600 14792576 6263568
21:02:27 86485 8192000000 10878494816 11347976192 1859943664 18.503 94 11 22 0 1878842224 15678672 3219888
21:04:02 31153 8192000000 10874960400 11338133504 1930217056 19.069 99 11 22 0 1946046000 11664192 4164752
21:04:39 19173 8192000000 10887020272 11345768448 1950992960 19.234 100 9 18 1 1964632016 11250416 2388640
21:05:08 54630 8192000000 10892789728 11363049472 1962949296 19.329 100 22 44 3 1983588160 14272336 6366528
21:06:09 39622 8192000000 10899546800 11364843520 1958062368 19.291 99 18 36 1 1981039952 17497088 5480496
21:06:56 62551 8192000000 10894655616 11367632896 1946960304 19.202 99 14 28 0 1972218704 21031184 4227216
21:08:04 12403 8192000000 10883104848 11373236224 1957981856 19.290 100 7 14 1 1979501104 19367408 2151840
21:08:53 50745 8192000000 10913101664 11358179328 1951650736 19.240 99 18 36 2 1964323536 7796096 4876704
21:09:50 28948 8192000000 10895564544 11364134912 1958141072 19.291 99 29 56 1 1979401088 13132464 8127552
21:10:36 49908 8192000000 10927887984 11381743616 1942496000 19.167 98 23 46 1 1959417600 10037632 6883968
21:11:34 50093 8192000000 10906638944 11355811840 1895989456 18.794 96 30 60 1 1914700080 10313024 8397600
21:12:30 39472 8192000000 10918052992 11377336320 1966256128 19.356 100 21 42 0 1994782016 22477376 6048512
21:13:25 57393 8192000000 10905575200 11379556352 1976390032 19.436 100 24 48 3 2003518608 19864192 7264384
21:14:30 48190 8192000000 10913707920 11397828608 1950567248 19.231 99 10 20 0 1970340624 17248064 2525312
21:15:31 90502 8192000000 10925739552 11391795200 1962334160 19.325 99 24 48 0 1984377552 15173488 6869904
21:17:08 76494 8192000000 10916421536 11396374528 1954908144 19.266 98 16 32 1 1978769728 19414928 4446656
21:18:33 17393 8192000000 10932781328 11371765760 1978836944 19.455 99 56 108 2 2003289456 9185712 15266800
21:18:58 62298 8192000000 10888023024 11334266880 1810457760 18.100 92 40 80 1 1837863600 16017312 11388528
21:20:11 69954 8192000000 10863648368 11337809920 1927454240 19.047 100 14 28 1 1950538592 19125072 3959280
21:22:26 57136 8192000000 10870517504 11350503424 1954331888 19.261 100 16 32 1 1969532688 10360096 4840704
21:23:30 20987 8192000000 10862802384 11320688640 1882126448 18.682 96 14 28 0 1896852704 11001296 3724960
21:23:58 69820 8192000000 10856131264 11332423680 1935640752 19.112 100 14 28 1 1953914272 13716800 4556720
21:25:16 36161 8192000000 10842173344 11324137472 1908037248 18.891 99 7 14 0 1919778352 9660032 2081072
21:25:59 22887 8192000000 10844639728 11322085376 1913373920 18.934 99 10 20 2 1925898496 9799840 2724736
21:26:53 61527 8192000000 10869965776 11340742656 1908996272 18.899 98 11 22 0 1922968656 11058832 2913552
21:28:13 44684 8192000000 10871699632 11341611008 1919342656 18.982 98 15 30 2 1941292560 18347168 3602736
21:29:19 54941 8192000000 10864434032 11335389184 1890162720 18.747 97 22 44 3 1920860400 24570000 6127680
21:30:20 68817 8192000000 10839724896 11318263808 1834471008 18.296 95 12 24 0 1855450304 18001648 2977648
21:31:35 73751 8192000000 10874622816 11339866112 1897642432 18.807 98 14 28 0 1914786896 13299488 3844976
21:33:29 64420 8192000000 10874519760 11336192000 1909810416 18.905 98 34 68 0 1930268864 11187888 9270560
21:34:40 45455 8192000000 10849823328 11309752320 1891417520 18.757 97 19 37 1 1914750704 17935744 5397440
21:35:31 76703 8192000000 10868590176 11324321792 1860231584 18.505 96 23 46 2 1883690656 17194368 6264704
21:36:54 48909 8192000000 10893828384 11342807040 1926538064 19.039 99 30 58 1 1946905008 11913040 8453904
21:37:51 28154 8192000000 10884989648 11343458304 1932030000 19.083 99 34 68 1 1957448752 15663824 9754928
21:38:30 75684 8192000000 10872680832 11344863232 1908633392 18.896 98 12 24 1 1922214960 10455152 3126416
21:39:52 67839 8192000000 10869922928 11343175680 1881798992 18.680 96 14 26 1 1896112896 10095424 4218480
21:41:12 98512 8192000000 10886113120 11358617600 1914635360 18.944 98 16 32 2 1931314720 12412592 4266768
21:42:58 53952 8192000000 10868903472 11336691712 1850965024 18.430 95 15 30 1 1869475728 14156544 4354160
21:43:59 164576 8192000000 10887826720 11349913600 1948483008 19.214 100 21 42 2 1966868112 12568000 5817104
21:46:50 13218 8192000000 10901440976 11351842816 1948959136 19.218 99 41 81 0 1973834944 12992352 11883456
21:47:22 75129 8192000000 10909605024 11380510720 1953487936 19.254 99 17 34 0 1980242880 21355376 5399568
21:48:46 62072 8192000000 10884586992 11376222208 1948990736 19.218 99 12 24 1 1977704176 25024240 3689200
21:49:59 37471 8192000000 10890885040 11376279552 1960337424 19.309 100 10 20 0 1983742880 19769360 3636096
21:50:43 49566 8192000000 10903091264 11372457984 1955576368 19.271 99 19 38 0 1979254080 18358560 5319152
21:52:14 69403 8192000000 10887441408 11360727040 1930211040 19.069 98 18 35 0 1947665088 12412400 5041648
21:53:37 81720 8192000000 10874618656 11357171712 1936505040 19.119 99 19 38 0 1952605760 10150816 5949904
21:55:07 36741 8192000000 10880836992 11349868544 1955113408 19.267 100 13 26 2 1966974976 7764640 4096928
21:55:50 65339 8192000000 10883484016 11344080896 1878992112 18.657 96 11 22 3 1889805888 7699376 3114400
21:57:03 43908 8192000000 10849998688 11306057728 1834701696 18.298 94 24 48 2 1848460768 7672800 6086272
21:58:01 45652 8192000000 10884845808 11347062784 1945528672 19.191 100 24 48 0 1967544640 15308112 6707856
21:58:53 88486 8192000000 10881643248 11339505664 1878249568 18.651 96 17 34 1 1895256240 12761920 4244752
22:00:36 41331 8192000000 10880216512 11335770112 1898673696 18.816 97 26 52 1 1914841408 9374832 6792880
22:01:23 34322 8192000000 10891007056 11339390976 1913648720 18.936 98 41 82 1 1941242912 16605680 10988512
22:02:06 12450 8192000000 10902652864 11356536832 1956122512 19.275 100 46 92 0 1983411200 14559376 12729312
22:02:26 70329 8192000000 10868872400 11328659456 1881967264 18.681 96 29 59 1 1903487648 13836320 7684064
22:03:44 20810 8192000000 10893292208 11335090176 1928445712 19.054 99 38 76 1 1948923120 10354032 10123376
22:04:11 30231 8192000000 10882813232 11337072640 1914900128 18.946 98 34 68 2 1938820688 14200208 9720352
22:04:52 98652 8192000000 10867333952 11344289792 1895798368 18.792 97 20 40 2 1915397376 14158592 5440416
22:07:59 92599 8192000000 10887698448 11347070976 1932992688 19.091 99 15 26 1 1955327744 18647488 3687568
22:09:39 103853 8192000000 10874225248 11342618624 1877608624 18.646 96 18 36 1 1902031440 19341056 5081760
22:11:36 61838 8192000000 10871780560 11345747968 1914621360 18.944 98 15 28 1 1927876208 9365456 3889392
22:13:22 60531 8192000000 10849300576 11320979456 1841505024 18.353 94 11 22 1 1850874384 6843056 2526304
22:14:36 79392 8192000000 10865173344 11334365184 1908959808 18.898 98 11 22 0 1920738096 8229904 3548384
22:16:33 62616 8192000000 10867353984 11346456576 1930743888 19.073 99 10 20 0 1944919920 11094416 3081616
22:18:37 91538 8192000000 10833099312 11308552192 1842883488 18.364 95 14 28 0 1854715232 8155856 3675888
22:20:15 81424 8192000000 10856894464 11320578048 1876259936 18.635 97 22 44 0 1891694544 9696752 5737856
22:21:48 50088 8192000000 10883523312 11351371776 1949187552 19.220 100 24 48 0 1966315264 10353056 6774656
22:22:44 76245 8192000000 10874770992 11333636096 1918861264 18.978 98 16 32 1 1936004832 12124944 5018624
22:24:22 49480 8192000000 10890086048 11362054144 1949779984 19.225 100 8 16 0 1969714384 17667136 2267264
22:25:28 52224 8192000000 10912882624 11369046016 1955287104 19.269 99 46 92 1 1983640976 15046688 13307184
22:26:26 58933 8192000000 9352180448 9684353024 456804016 5.281 23 7 14 0 469922304 11069648 2048640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 24-12-2020 22:28:41 to 24-12-2020 22:29:11.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 165 v_add_invoice_to_stock 335544517
except 17 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-12-2020 22:29:12 to 24-12-2020 22:29:14.

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          256842
MON$OLDEST_ACTIVE               256843
MON$OLDEST_SNAPSHOT             256843
MON$NEXT_TRANSACTION            256843
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                       2042336
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 ---
:336: 
:337: mscs-test-161.budzdorov.ru    Thu Dec 24 22:27:26 2020
:338:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:339: 
:340: 
:341: mscs-test-161.budzdorov.ru    Thu Dec 24 22:27:32 2020
:342:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:343: 
:344: 
:345: mscs-test-161.budzdorov.ru    Thu Dec 24 22:27:55 2020
:346:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:347: 
--- end of diff output ---

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

24.12.20 22:29:15. 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-24 22:29:17 No severe PSQL-related problems occured
24.12.20 22:29:18. End of report.