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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17041688 kB
MemAvailable 31485008 kB
Buffers 0 kB
Cached 14633036 kB
SwapCached 3088 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-11-23 19:27:04
DTS_END                         2020-11-23 19:27:04.4720
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/52708
TRN_ID                          250196
ATT_ID                          695
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: 9692.67 21073 1163120
customer order: creation 181.77 356 21812
customer order: refuse 15.34 348 1841
order to supplier: creation 48.30 1300 5796
order to supplier: removal 3.58 101353 429
invoice (draft): creation 47.93 3403 5752
invoice (draft): removal 55.25 746 6630
invoice accept: apply 43.49 17523 5219
invoice accept: cancel 50.13 847 6015
customer reserve: creation 3979.52 174 477542
customer reserve: removal 4951.75 58 594210
realization accept: apply 87.55 182 10506
realization accept: cancel 91.82 105 11018
payment from customer: creation 61.89 108 7427
payment from customer: removal 6.25 91 750
payment to supplier: creation 51.69 132 6203
payment to supplier: removal 3.71 91 445
service: total inventory turnovers 5.15 1154 618
service: total monetary turnovers 6.71 47 805
service: aggregate perf. data 0.82 23079 98
service: refresh index statistics 0.03 270354 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 23-11-2020 19:27:52 to 23-11-2020 19:27:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8912
TEST_TIME 2 6214
TEST_TIME 3 5383
TEST_TIME 4 6096
TEST_TIME 5 5729
TEST_TIME 6 5425
TEST_TIME 7 5598
TEST_TIME 8 5710
TEST_TIME 9 5870
TEST_TIME 10 6170
TEST_TIME 11 6617
TEST_TIME 12 6703
TEST_TIME 13 6731
TEST_TIME 14 7354
TEST_TIME 15 7581
TEST_TIME 16 7709
TEST_TIME 17 8172
TEST_TIME 18 8351
TEST_TIME 19 8411
TEST_TIME 20 8423
TEST_TIME 21 8921
TEST_TIME 22 9003
TEST_TIME 23 9151
TEST_TIME 24 9154
TEST_TIME 25 9131
TEST_TIME 26 9299
TEST_TIME 27 9633
TEST_TIME 28 9882
TEST_TIME 29 10150
TEST_TIME 30 10133
TEST_TIME 31 10246
TEST_TIME 32 11303
TEST_TIME 33 11302
TEST_TIME 34 11271
TEST_TIME 35 11027
TEST_TIME 36 11014
TEST_TIME 37 10850
TEST_TIME 38 10740
TEST_TIME 39 10638
TEST_TIME 40 10614
TEST_TIME 41 10441
TEST_TIME 42 10468
TEST_TIME 43 10421
TEST_TIME 44 10277
TEST_TIME 45 10183
TEST_TIME 46 10114
TEST_TIME 47 10153
TEST_TIME 48 10216
TEST_TIME 49 10211
TEST_TIME 50 10105
TEST_TIME 51 10027
TEST_TIME 52 9880
TEST_TIME 53 10027
TEST_TIME 54 10006
TEST_TIME 55 10001
TEST_TIME 56 10003
TEST_TIME 57 10001
TEST_TIME 58 10028
TEST_TIME 59 10057
TEST_TIME 60 10018
TEST_TIME 61 10115
TEST_TIME 62 10067
TEST_TIME 63 10142
TEST_TIME 64 10146
TEST_TIME 65 10169
TEST_TIME 66 10181
TEST_TIME 67 10159
TEST_TIME 68 10070
TEST_TIME 69 10007
TEST_TIME 70 10085
TEST_TIME 71 10053
TEST_TIME 72 10018
TEST_TIME 73 9977
TEST_TIME 74 9909
TEST_TIME 75 9848
TEST_TIME 76 9887
TEST_TIME 77 9847
TEST_TIME 78 9770
TEST_TIME 79 9772
TEST_TIME 80 9753
TEST_TIME 81 9737
TEST_TIME 82 9680
TEST_TIME 83 9640
TEST_TIME 84 9647
TEST_TIME 85 9634
TEST_TIME 86 9659
TEST_TIME 87 9610
TEST_TIME 88 9595
TEST_TIME 89 9550
TEST_TIME 90 9686
TEST_TIME 91 9816
TEST_TIME 92 9844
TEST_TIME 93 9832
TEST_TIME 94 9875
TEST_TIME 95 9891
TEST_TIME 96 9916
TEST_TIME 97 9933
TEST_TIME 98 9855
TEST_TIME 99 9819
TEST_TIME 100 9802
TEST_TIME 101 9764
TEST_TIME 102 9766
TEST_TIME 103 9746
TEST_TIME 104 9713
TEST_TIME 105 9712
TEST_TIME 106 9683
TEST_TIME 107 9615
TEST_TIME 108 9645
TEST_TIME 109 9622
TEST_TIME 110 9643
TEST_TIME 111 9618
TEST_TIME 112 9630
TEST_TIME 113 9657
TEST_TIME 114 9679
TEST_TIME 115 9684
TEST_TIME 116 9699
TEST_TIME 117 9774
TEST_TIME 118 9765
TEST_TIME 119 9763
TEST_TIME 120 9696

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 23-11-2020 19:27:56 to 23-11-2020 19:27:59.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1606693 1606693 0 0.00 0 24591 6 0 0
doc_list_biud 1606691 1606691 0 0.00 0 48083 27 0 0
sp_add_invoice_to_stock 5340 5219 121 2.26 48 163475 17523 0 121
sp_cancel_adding_invoice 6015 6015 0 0.00 3 63844 848 0 0
sp_cancel_client_order 1841 1841 0 0.00 4 11507 349 0 0
sp_cancel_customer_reserve 594210 594210 0 0.00 1 24417 58 0 0
sp_cancel_pay_from_customer 750 750 0 0.00 2 7559 91 0 0
sp_cancel_pay_to_supplier 445 445 0 0.00 3 6785 91 0 0
sp_cancel_supplier_invoice 6635 6630 5 0.07 2 23055 747 0 5
sp_cancel_supplier_order 429 429 0 0.00 12 1068193 101353 0 0
sp_cancel_write_off 11018 11018 0 0.00 1 10231 106 0 0
sp_client_order 21812 21812 0 0.00 3 29260 356 0 0
sp_customer_reserve 477542 477542 0 0.00 0 88350 175 0 0
sp_fill_shopping_cart 33338 33338 0 0.00 1 30176 38 0 0
sp_fill_shopping_cart_clo_res 477539 477539 0 0.00 0 39038 13 0 0
sp_get_clo_for_invoice 5215 5215 0 0.00 0 38293 300 0 0
sp_kill_cost_storno 18228 18228 0 0.00 0 21731 55 0 0
sp_kill_qstorno_ret_qs2qd 1206497 1206497 0 0.00 0 24380 31 0 0
sp_kill_qty_storno 635862 635862 0 0.00 0 48081 68 0 0
sp_lock_selected_doc 21842 21842 0 0.00 0 12693 5 0 0
sp_make_cost_storno 29350 29350 0 0.00 0 13959 55 0 0
sp_multiply_rows_for_pdistr 29349 29349 0 0.00 0 8747 29 0 0
sp_multiply_rows_for_qdistr 21811 21811 0 0.00 0 23576 173 0 0
sp_pay_from_customer 7427 7427 0 0.00 3 13697 108 0 0
sp_pay_to_supplier 6203 6203 0 0.00 4 18299 132 0 0
sp_payment_common 13630 13630 0 0.00 1 11816 28 0 0
sp_qd_handle_on_cancel_clo 1841 1841 0 0.00 0 11498 318 0 0
sp_qd_handle_on_invoice_upd_sts 11229 11229 0 0.00 0 48078 336 0 0
sp_qd_handle_on_reserve_upd_sts 10505 10505 0 0.00 0 18898 60 0 0
sp_reserve_write_off 10506 10506 0 0.00 6 19118 182 0 0
sp_supplier_invoice 5752 5752 0 0.00 6 100255 3403 0 0
sp_supplier_order 5796 5796 0 0.00 5 61319 1301 0 0
srv_aggregate_perf_data 98 98 0 0.00 3013 227206 23080 0 0
srv_fill_mon_cache_memory 179 179 0 0.00 1013 149063 28855 0 0
srv_find_qd_qs_mism 1113876 1113876 0 0.00 0 24590 5 0 0
srv_make_invnt_saldo 618 618 0 0.00 35 70131 1154 0 0
srv_make_money_saldo 805 805 0 0.00 1 12966 47 0 0
srv_recalc_idx_stat 4 4 0 0.00 108400 381064 270354 0 0
t$perf-abend:sp_add_invoice_to_stock 121 121 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5220 5220 0 0.00 0 12900 211 0 0
t$perf-norm:sp_cancel_adding_invoice 451 451 0 0.00 1 3393 107 0 0
t$perf-norm:sp_cancel_client_order 1841 1841 0 0.00 0 7171 27 0 0
t$perf-norm:sp_cancel_customer_reserve 739 739 0 0.00 0 865 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 750 750 0 0.00 0 2440 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 445 445 0 0.00 0 2473 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 2446 26 0 0
t$perf-norm:sp_cancel_supplier_order 429 429 0 0.00 0 35069 1845 0 0
t$perf-norm:sp_cancel_write_off 1070 1070 0 0.00 0 7142 19 0 0
t$perf-norm:sp_client_order 21812 21812 0 0.00 0 11022 23 0 0
t$perf-norm:sp_customer_reserve 990 990 0 0.00 0 1150 4 0 0
t$perf-norm:sp_pay_from_customer 7427 7427 0 0.00 0 10661 11 0 0
t$perf-norm:sp_pay_to_supplier 6203 6203 0 0.00 0 9220 12 0 0
t$perf-norm:sp_reserve_write_off 10506 10506 0 0.00 0 15948 14 0 0
t$perf-norm:sp_supplier_invoice 5752 5752 0 0.00 0 9486 20 0 0
t$perf-norm:sp_supplier_order 5796 5796 0 0.00 0 6058 17 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 1792 31 0 0
t$perf-norm:srv_fill_mon_cache_memory 179 179 0 0.00 0 2193 20 0 0
t$perf-norm:srv_make_invnt_saldo 618 618 0 0.00 0 2390 23 0 0
t$perf-norm:srv_make_money_saldo 805 805 0 0.00 0 2476 28 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 12 7 0 0
v_add_invoice_to_stock 10670 10428 242 2.26 0 6392 18 0 242
v_all_customers 39336 39336 0 0.00 0 48 1 0 0
v_all_suppliers 31962 31962 0 0.00 0 27 1 0 0
v_all_wares 43614 43614 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 902 902 0 0.00 0 839 9 0 0
v_cancel_client_order 3682 3682 0 0.00 0 2755 9 0 0
v_cancel_customer_prepayment 1500 1500 0 0.00 0 1924 5 0 0
v_cancel_customer_reserve 1478 1478 0 0.00 0 1260 4 0 0
v_cancel_payment_to_supplier 890 890 0 0.00 0 2135 7 0 0
v_cancel_supplier_invoice 808 798 10 1.23 0 1105 16 0 10
v_cancel_supplier_order 858 858 0 0.00 0 1143 5 0 0
v_cancel_write_off 2140 2140 0 0.00 0 2398 14 0 0
v_max_id_clo_ord 5789 5789 0 0.00 0 246 1 0 0
v_max_id_clo_res 990 990 0 0.00 0 2717 18 0 0
v_max_id_ord_sup 5741 5741 0 0.00 0 7020 6 0 0
v_max_non_paid_invoice 1751 1751 0 0.00 0 1331 3 0 0
v_max_non_paid_realizn 4055 4055 0 0.00 0 10048 6 0 0
v_min_id_clo_ord 5789 5789 0 0.00 0 6366 15 0 0
v_min_id_clo_res 990 990 0 0.00 0 15051 29 0 0
v_min_id_ord_sup 5741 5741 0 0.00 0 10246 7 0 0
v_min_non_paid_invoice 6203 6203 0 0.00 0 8198 20 0 0
v_min_non_paid_realizn 7427 7427 0 0.00 0 7854 17 0 0
v_our_firm 11022 11022 0 0.00 0 21 1 0 0
v_reserve_write_off 21008 21008 0 0.00 0 5472 6 0 0
x_lock_depdocs_on_canc_invoice 12246 12246 0 0.00 0 17725 115 0 0
x_lock_depdocs_on_canc_sup_ord 429 429 0 0.00 0 27953 426 0 0
x_make_qstorno_1000_1200 5796 5796 0 0.00 2 61307 1200 0 0
x_make_qstorno_1200_2000 5752 5752 0 0.00 3 100240 3282 0 0
x_make_qstorno_2100_3300 477542 477542 0 0.00 0 88311 159 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 23-11-2020 19:28:00 to 23-11-2020 19:28:05.

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:14 19301 8192000000 10267677408 10574069760 925393280 10.149 72 57 114 0 947897184 2844768 19659136
16:57:41 23347 8192000000 10338287248 10653745152 1380672176 14.423 100 86 171 2 1413431392 4698960 28060256
16:58:14 23328 8192000000 10378089344 10700689408 1424121264 14.809 100 84 167 0 1457516784 6385504 27010016
16:58:48 17323 8192000000 10410225568 10739400704 1465666208 15.176 100 89 178 1 1501960400 7446704 28847488
16:59:26 12166 8192000000 10435267344 10768777216 1493024384 15.415 100 87 174 0 1529025728 8364864 27636480
16:59:46 22999 8192000000 10449229200 10782822400 1504560656 15.516 100 92 184 1 1543006608 9160000 29285952
17:00:22 22094 8192000000 10477285104 10814418944 1526004864 15.702 100 87 174 2 1563217712 9853424 27359424
17:00:55 21599 8192000000 10496814736 10839326720 1548677792 15.899 100 87 174 0 1585875792 10406720 26791280
17:01:27 25866 8192000000 10526924688 10875428864 1573370464 16.111 100 84 168 1 1610450784 11367264 25713056
17:02:04 14371 8192000000 10531454944 10887897088 1594390528 16.291 100 80 160 0 1631171616 11669552 25111536
17:02:26 12271 8192000000 10548481904 10909384704 1603832432 16.372 100 73 146 1 1637357888 11086096 22439360
17:02:50 14207 8192000000 10576818528 10938638336 1632237888 16.614 100 79 158 3 1667676816 11721152 23717776
17:03:15 10137 8192000000 10586257392 10954522624 1649968000 16.764 100 76 152 0 1684998944 12227840 22803104
17:03:36 8137 8192000000 10607830704 10976337920 1669077792 16.925 100 79 158 2 1704273888 11337536 23858560
17:03:52 10182 8192000000 10623316832 10992377856 1683504512 17.047 100 75 148 2 1716703760 11597696 21601552
17:04:13 8536 8192000000 10645216640 11018887168 1705099744 17.228 100 79 158 1 1740254432 12308064 22846624
17:04:30 6833 8192000000 10642993824 11022934016 1715358272 17.313 100 76 151 3 1749024448 11598832 22067344
17:04:44 5764 8192000000 10671659456 11050733568 1732514608 17.456 100 68 136 3 1762995568 11562384 18918576
17:04:59 4770 8192000000 10683960512 11064979456 1750977424 17.610 100 70 138 1 1781803456 11555648 19270384
17:05:11 4749 8192000000 10699869552 11077275648 1758557264 17.672 100 73 146 1 1790798032 12037952 20202816
17:05:23 3185 8192000000 10705647152 11089797120 1773256128 17.794 100 73 145 2 1806743264 12489424 20997712
17:05:33 8895 8192000000 10725017152 11107745792 1788873136 17.923 100 81 164 0 1823849904 11759888 23216880
17:05:49 4401 8192000000 10745321392 11131076608 1798880720 18.005 100 73 146 1 1831492512 12537440 20074352
17:06:00 3095 8192000000 10747818880 11137613824 1811182256 18.106 100 75 150 0 1844466928 12878832 20405840
17:06:11 2412 8192000000 10761615664 11148128256 1821416912 18.189 100 86 172 2 1859727472 14152176 24158384
17:06:20 3236 8192000000 10774149152 11158724608 1826015712 18.227 100 89 179 3 1866167680 14650896 25501072
17:06:30 1798 8192000000 10770847520 11159248896 1829985760 18.259 100 82 161 0 1866373584 14090080 22297744
17:06:38 1754 8192000000 10778167584 11163369472 1841359680 18.352 100 94 189 1 1882843504 14817712 26666112
17:06:47 1309 8192000000 10783566096 11169214464 1845527920 18.386 100 93 186 1 1886741600 15398080 25815600
17:06:54 2464 8192000000 10792628752 11178504192 1842360160 18.360 100 92 185 0 1883474480 15125344 25988976
17:07:03 1752 8192000000 10789147856 11178475520 1844797936 18.380 100 89 177 1 1884531840 15171248 24562656
17:07:11 2316 8192000000 10791922288 11182710784 1852540400 18.443 100 88 176 0 1891751408 13983280 25227728
17:07:20 1164 8192000000 10798366048 11185934336 1855242336 18.465 100 94 189 0 1895756848 14605168 25909344
17:07:27 1689 8192000000 10799103744 11186036736 1858796928 18.494 100 89 177 3 1896872688 13323568 24752192
17:07:36 2175 8192000000 10804311312 11193729024 1859090224 18.496 100 88 177 3 1897503360 13996240 24416896
17:07:45 1410 8192000000 10809870848 11196665856 1861287344 18.514 100 93 187 2 1901921200 14023040 26610816
17:07:53 1517 8192000000 10793828736 11195052032 1861236288 18.513 100 70 141 1 1894173728 13205552 19731888
17:08:01 2012 8192000000 10790425136 11197616128 1864239344 18.538 100 72 143 2 1897004240 12004992 20759904
17:08:11 2810 8192000000 10792497120 11198869504 1865467792 18.548 100 65 131 3 1894473376 10370976 18634608
17:08:20 4397 8192000000 10788944992 11198443520 1865695840 18.549 100 44 89 1 1887527312 9719648 12111824
17:08:31 2600 8192000000 10793589104 11204313088 1868209216 18.570 100 53 107 1 1893254544 9768912 15276416
17:08:41 2237 8192000000 10793540880 11201134592 1868095312 18.569 100 48 98 1 1890997488 9683760 13218416
17:08:50 10229 8192000000 10768873168 11200888832 1869061536 18.577 100 52 105 1 1892962048 8486256 15414256
17:09:33 17608 8192000000 10781743552 11204599808 1868251744 18.570 100 30 58 2 1882297888 5519328 8526816
17:10:00 10472 8192000000 10782175024 11206598656 1868849360 18.575 100 23 46 1 1881712688 6851840 6011488
17:10:18 7912 8192000000 10781926336 11206782976 1872294992 18.603 100 20 40 2 1883773296 5432928 6045376
17:10:35 16127 8192000000 10774443344 11211939840 1872691280 18.606 100 17 34 0 1883935328 6363408 4880640
17:10:58 9646 8192000000 10795696016 11219763200 1877574896 18.646 100 12 22 1 1887864384 5720432 4569056
17:11:14 10942 8192000000 10787100672 11224047616 1881600944 18.678 100 14 28 3 1891415904 6087104 3727856
17:11:31 8221 8192000000 10789795328 11224838144 1884093088 18.698 100 20 40 1 1896061984 6687568 5281328
17:11:45 14573 8192000000 10788863200 11224150016 1883211472 18.691 100 15 30 0 1893162576 5957664 3993440
17:12:06 8787 8192000000 10794865872 11225780224 1889861888 18.745 100 30 59 2 1904655264 6770304 8023072
17:12:25 10640 8192000000 10793318240 11231494144 1890251744 18.748 100 19 36 3 1902275936 6494032 5530160
17:12:42 9857 8192000000 10806760400 11236573184 1892700256 18.768 100 22 43 2 1904531280 6240224 5590800
17:13:03 77714 8192000000 10813582704 11250425856 1899516144 18.822 100 27 54 1 1916272560 8765248 7991168
17:14:32 9988 8192000000 10813134096 11251662848 1899765264 18.824 100 22 45 1 1911938496 5296208 6877024
17:14:53 8415 8192000000 10819795616 11257475072 1901792800 18.841 100 26 52 2 1919529616 11006512 6730304
17:15:08 5778 8192000000 10832622128 11260194816 1904352544 18.861 100 31 61 0 1923974368 11031600 8590224
17:15:22 4074 8192000000 10812387968 11253227520 1904482432 18.862 100 30 60 0 1920006832 6417008 9107392
17:15:33 8120 8192000000 10807479296 11245514752 1882991568 18.689 99 22 44 3 1894972176 5963824 6016784
17:15:49 6575 8192000000 10820826464 11256565760 1900162432 18.828 100 20 40 2 1916196960 10919360 5115168
17:16:02 3452 8192000000 10819966608 11245764608 1894808976 18.785 100 31 62 1 1914081376 10694048 8578352
17:16:13 7837 8192000000 10806671760 11246084096 1896615536 18.799 100 16 32 1 1907204208 5882576 4706096
17:16:32 6334 8192000000 10803958592 11233636352 1874881232 18.624 99 31 62 1 1889705040 6016448 8807360
17:16:45 6609 8192000000 10806775744 11238305792 1874800656 18.623 99 24 48 2 1887850448 6425952 6623840
17:17:00 7274 8192000000 10773979904 11203489792 1837471408 18.320 98 20 39 2 1847867136 4930128 5465600
17:17:14 7667 8192000000 10761762448 11188322304 1813291040 18.123 97 30 60 1 1827877568 6007616 8578912
17:17:31 15848 8192000000 10743631408 11169312768 1711424032 17.281 92 18 36 0 1721755088 4762096 5568960
17:17:55 64525 8192000000 10783285680 11183763456 1765044656 17.726 95 46 90 1 1789342592 9378880 14919056
17:19:06 7478 8192000000 10745467664 11174125568 1816272960 18.147 99 16 32 0 1826343760 5618336 4452464
17:19:21 7465 8192000000 10723436528 11141574656 1781074368 17.858 98 24 48 1 1797535648 9388384 7072896
17:19:35 7216 8192000000 10717747136 11132407808 1716517808 17.323 94 25 50 2 1729924160 6125568 7280784
17:19:49 5689 8192000000 10668490592 11082887168 1695332848 17.146 95 29 58 2 1709030144 5915792 7781504
17:20:02 4860 8192000000 10677189168 11087683584 1716110112 17.320 97 32 65 1 1734997280 10051728 8835440
17:20:13 4862 8192000000 10662232544 11076108288 1723018128 17.377 97 27 54 0 1741765632 10833584 7913920
17:20:25 9324 8192000000 10694501936 11111485440 1736478976 17.489 97 19 38 2 1747716624 5345200 5892448
17:20:41 10799 8192000000 10691523728 11108290560 1751454688 17.614 98 27 52 3 1765000576 5991328 7554560
17:20:58 9661 8192000000 10698709472 11115630592 1770934384 17.775 99 20 39 5 1781745360 5541744 5269232
17:21:14 7382 8192000000 10700600960 11110789120 1759315360 17.679 98 23 45 2 1771182016 5870304 5996352
17:21:28 11837 8192000000 10717353504 11124936704 1762120784 17.702 98 21 42 1 1773608688 5555376 5932528
17:21:47 9521 8192000000 10732080880 11148857344 1813232672 18.122 100 15 30 0 1822783312 5109408 4441232
17:22:05 13976 8192000000 10737415696 11162365952 1827233168 18.237 100 20 38 3 1838524064 5398944 5891952
17:22:32 30291 8192000000 10732504704 11158142976 1824044864 18.211 100 27 54 3 1837627376 5301664 8280848
17:23:16 39461 8192000000 10761927984 11180912640 1837538624 18.321 100 35 70 0 1853919952 6857296 9524032
17:24:05 16602 8192000000 10774576144 11192705024 1848944320 18.414 100 22 44 2 1860935632 6027616 5963696
17:24:28 8235 8192000000 10766751456 11192422400 1853546384 18.451 100 35 70 2 1870624928 6862864 10215680
17:24:43 4226 8192000000 10782358208 11201376256 1861649200 18.517 100 55 110 1 1884259024 6647136 15962688
17:24:58 4755 8192000000 10773504320 11200344064 1860272400 18.505 100 21 41 0 1875713632 9727424 5713808
17:25:10 5366 8192000000 10787367136 11209482240 1864834400 18.542 100 25 50 0 1877447504 5057264 7555840
17:25:23 8711 8192000000 10782409488 11211436032 1867631328 18.565 100 16 30 0 1876986080 5455280 3899472
17:25:39 6893 8192000000 10795272064 11219243008 1874114720 18.618 100 24 46 2 1886165808 5013312 7037776
17:25:52 10915 8192000000 10800025152 11225653248 1878128992 18.650 100 20 40 0 1889441920 5146848 6166080
17:26:10 13749 8192000000 10802347488 11232755712 1881681488 18.679 100 15 31 1 1891853888 5798016 4374384
17:26:30 15198 8192000000 10798999376 11232284672 1889833072 18.744 100 18 36 0 1901274912 6287776 5154064
17:26:51 9255 8192000000 10801004496 11230617600 1886935120 18.721 100 18 35 2 1897812848 5427184 5450544
17:27:08 4387 8192000000 10835606752 11254280192 1907780416 18.889 100 39 77 1 1922825504 4274256 10770832
17:27:21 18103 8192000000 10856917312 11271929856 1919847664 18.986 100 51 102 0 1941158496 7130656 14180176
17:27:47 20852 8192000000 10858118288 11284385792 1931546544 19.079 100 45 91 2 1953405808 9535136 12324128
17:28:16 15211 8192000000 10867573008 11283759104 1916335440 18.957 99 50 97 0 1937231808 7513376 13382992
17:28:40 11680 8192000000 10861449728 11289337856 1934430576 19.102 100 44 87 0 1954763568 7725456 12607536
17:28:59 50144 8192000000 10866802000 11299610624 1939352176 19.142 100 35 68 1 1956376080 7048640 9975264
17:30:10 54065 8192000000 10892543872 11318046720 1955562752 19.271 100 48 96 1 1979868896 9131680 15174464
17:31:11 19536 8192000000 10885134496 11321151488 1962464720 19.326 100 43 86 2 1985243920 10326400 12452800
17:31:39 11839 8192000000 10881883264 11318435840 1946913024 19.202 99 38 76 2 1966427920 8308752 11206144
17:32:01 20062 8192000000 10900545360 11332210688 1969364208 19.380 100 42 81 3 1992579264 11103440 12111616
17:32:28 5184 8192000000 10912208176 11343278080 1976236976 19.435 100 54 106 2 2004073456 12530832 15305648
17:32:50 21282 8192000000 10924183072 11351662592 1981525056 19.477 100 49 98 0 2009010432 13107664 14377712
17:33:26 21888 8192000000 10928425440 11362983936 1989129680 19.537 100 50 100 2 2018341872 14838176 14374016
17:33:56 13363 8192000000 10932258640 11368996864 1994137392 19.576 100 53 106 1 2024807568 15299312 15370864
17:34:16 6554 8192000000 10943405392 11370926080 2000174496 19.624 100 62 123 1 2035300544 15929008 19197040
17:34:31 19981 8192000000 10933498880 11379949568 1998382864 19.610 100 49 98 0 2029374192 16375568 14615760
17:35:00 6594 8192000000 10940004176 11382673408 2003713360 19.652 100 51 98 3 2033309936 14876736 14719840
17:35:18 5732 8192000000 10960370160 11386974208 2007554480 19.682 100 61 122 0 2040736256 15806560 17375216
17:35:36 7254 8192000000 10962372304 11392122880 2011891632 19.716 100 57 114 0 2045731136 16500816 17338688
17:35:50 23924 8192000000 10953099936 11394945024 2014721376 19.739 100 58 116 0 2049347216 17278080 17347760
17:36:58 15660 8192000000 10943861936 11388346368 1992729488 19.565 99 50 100 0 2024500544 17070240 14700816
17:37:24 7754 8192000000 10940759488 11368689664 1975529280 19.429 99 59 118 0 2012001984 19139008 17333696
17:37:39 3170 8192000000 10946141344 11366166528 1971986672 19.401 99 80 160 0 2017097536 21271952 23838912
17:37:49 8456 8192000000 10938364880 11357851648 1965926256 19.353 99 66 132 2 2008118544 22915344 19276944
17:38:05 8302 8192000000 10937165104 11368181760 1989465680 19.540 100 65 129 1 2032702912 22799200 20438032
17:38:22 3478 8192000000 10947074176 11379789824 1993894048 19.575 100 64 128 1 2040704320 27862064 18948208
17:38:34 8029 8192000000 10939917968 11378991104 1994990064 19.583 100 57 112 2 2036433488 23812896 17630528
17:38:57 17056 8192000000 10931260944 11374714880 1987949744 19.528 100 37 75 1 2020631904 21532816 11149344
17:39:23 2170 8192000000 10954012768 11375968256 1968498288 19.374 98 71 139 3 2010702208 20359680 21844240
17:39:39 6853 8192000000 10953265648 11375091712 1979459488 19.460 99 59 118 3 2018878160 21147200 18271472
17:39:55 10397 8192000000 10956251728 11384729600 1996581072 19.596 100 61 122 1 2039755216 24383408 18790736
17:40:13 3096 8192000000 10975042688 11392450560 2005799520 19.668 100 85 171 0 2058399808 26714512 25885776
17:40:23 2200 8192000000 10976256336 11390214144 1999638768 19.620 100 81 162 0 2053006800 29019392 24348640
17:40:34 1547 8192000000 10983426288 11402686464 2007726672 19.684 100 82 161 1 2060267328 28699712 23840944
17:40:44 2073 8192000000 10976947120 11399684096 2010406112 19.705 100 81 162 2 2064545840 29802768 24336960
17:40:57 2336 8192000000 10971237264 11381997568 1993669040 19.573 100 87 174 3 2050267632 30240352 26358240
17:41:06 2829 8192000000 10974919648 11390193664 1994105392 19.576 100 80 160 2 2049081264 30971152 24004720
17:41:16 3443 8192000000 10965344736 11385663488 1995524160 19.587 100 73 146 2 2048645856 31325248 21796448
17:41:28 2034 8192000000 10930816624 11352899584 1949732464 19.224 98 70 140 0 2001632560 30906512 20993584
17:41:37 1534 8192000000 10930983408 11336241152 1929665488 19.064 98 85 172 3 1985578224 30442816 25469920
17:41:45 1459 8192000000 10909759344 11315056640 1926873680 19.042 99 86 172 2 1984508560 31498304 26136576
17:41:53 3152 8192000000 10916222336 11324936192 1942574080 19.167 100 89 176 1 1999244464 30260784 26409600
17:42:06 4224 8192000000 10909458512 11321954304 1927716544 19.049 99 75 148 0 1980437552 30083904 22637104
17:42:16 1757 8192000000 10919528112 11326685184 1942668384 19.168 100 83 166 1 1997953296 29919152 25365760
17:42:24 1194 8192000000 10909438608 11312889856 1919153568 18.980 99 83 165 1 1976145520 31100560 25891392
17:42:32 4929 8192000000 10920580304 11325800448 1938603488 19.136 100 81 161 1 1994145488 31856768 23685232
17:42:45 3243 8192000000 10909114176 11320549376 1933114560 19.092 100 68 136 1 1985080928 31120880 20845488
17:42:56 4832 8192000000 10908870464 11319451648 1921054624 18.995 99 75 147 4 1974306336 31399584 21852128
17:43:09 8019 8192000000 10907869472 11320053760 1920590000 18.992 99 78 156 1 1974434208 30581584 23262624
17:43:24 3132 8192000000 10919476784 11332263936 1944156112 19.180 100 80 160 1 2002655632 33970832 24528688
17:43:34 6864 8192000000 10921324208 11335094272 1945881984 19.194 100 71 142 1 2001686176 34425776 21378416
17:43:53 4780 8192000000 10898442496 11302363136 1897402592 18.805 98 75 150 2 1957798288 36553648 23842048
17:44:05 3514 8192000000 10915031776 11326828544 1934530752 19.103 100 75 148 2 1994777344 37361120 22885472
17:44:16 1736 8192000000 10909034752 11310661632 1920293744 18.989 100 88 175 1 1985747920 38905488 26548688
17:44:25 4502 8192000000 10912141360 11321143296 1932401216 19.086 100 81 159 2 1994427712 37960352 24066144
17:44:37 1011 8192000000 10922025616 11332083712 1938726160 19.137 100 84 167 1 2003601936 38638160 26237616
17:44:47 3525 8192000000 10931282496 11341221888 1949928416 19.226 100 84 164 3 2008394464 33026944 25439104
17:44:58 2249 8192000000 10929100896 11340554240 1948916160 19.218 100 79 158 1 2006520304 33648064 23956080
17:45:07 6200 8192000000 10933258960 11345448960 1955008576 19.266 100 78 156 2 2013072544 34312224 23751744
17:45:21 2032 8192000000 10935462768 11342958592 1952254752 19.244 100 82 159 4 2010412928 33463520 24694656
17:45:30 4916 8192000000 10933132304 11347517440 1954297552 19.261 100 80 157 3 2013411712 35346416 23767744
17:45:42 2299 8192000000 10917615776 11318169600 1925370768 19.030 99 86 172 2 1990394512 37043296 27980448
17:45:52 3718 8192000000 10911717536 11329740800 1925124608 19.028 99 73 147 0 1981983712 34621808 22237296
17:46:03 5806 8192000000 10903889856 11327021056 1923232864 19.013 99 63 126 0 1980671328 37721728 19716736
17:46:15 4985 8192000000 10903560496 11324547072 1921159216 18.996 99 63 125 3 1976424016 35890992 19373808
17:46:29 3464 8192000000 10922831920 11337834496 1940627296 19.152 100 57 113 1 1994862304 36881584 17353424
17:46:40 5379 8192000000 10919647680 11325255680 1931937168 19.082 99 68 134 1 1991694576 39759264 19998144
17:46:52 4886 8192000000 10924833264 11328126976 1935812736 19.113 99 80 161 1 2000355984 39911728 24631520
17:47:04 13075 8192000000 10936383488 11353694208 1953225936 19.252 100 64 128 2 2011206464 38956016 19024512
17:47:24 1808 8192000000 10940711216 11361677312 1959775760 19.304 100 71 140 1 2020184544 39748304 20660480
17:47:34 1549 8192000000 10958855424 11367829504 1969941808 19.385 100 79 158 1 2033683792 40338608 23403376
17:47:44 3402 8192000000 10952797344 11364532224 1964277984 19.340 100 86 169 2 2031921120 41031680 26611456
17:47:54 4147 8192000000 10945259408 11356024832 1945608144 19.191 99 82 159 1 2012369856 42244304 24517408
17:48:06 5620 8192000000 10942646304 11360047104 1966478336 19.358 100 72 145 1 2026349856 38158752 21712768
17:48:20 3665 8192000000 10957845072 11372183552 1973994416 19.417 100 80 161 1 2036894832 38494400 24406016
17:48:35 1528 8192000000 10977059984 11391303680 1986955888 19.520 100 88 176 0 2053698960 40312208 26430864
17:48:43 4829 8192000000 10947819872 11372998656 1974574448 19.422 100 62 124 2 2030595120 37075248 18945424
17:48:54 4025 8192000000 10942484240 11368558592 1974248320 19.419 100 53 106 4 2027098320 36587456 16262544
17:49:12 2785 8192000000 10961192784 11373985792 1976637824 19.438 100 79 155 2 2037289248 36695360 23956064
17:49:22 3337 8192000000 10937975792 11356925952 1948559136 19.215 99 55 109 1 2002336448 36964320 16812992
17:49:33 3833 8192000000 10959097824 11370295296 1970433648 19.389 100 79 158 2 2033466064 38649968 24382448
17:49:44 8521 8192000000 10928581760 11364548608 1961584640 19.319 100 43 84 2 2015268352 39427072 14256640
17:50:04 5903 8192000000 10928621888 11361677312 1957723760 19.288 100 46 91 2 2008968864 37236000 14009104
17:50:22 13350 8192000000 10917928368 11353542656 1924431664 19.022 98 36 72 1 1973963072 37618304 11913104
17:50:46 13438 8192000000 10911981920 11348946944 1933165952 19.092 99 36 71 1 1980236064 35751584 11318528
17:51:06 8977 8192000000 10927361712 11362127872 1953272656 19.253 100 32 64 3 2004868176 41009936 10585584
17:51:27 18370 8192000000 10928994416 11366903808 1959642400 19.303 100 30 60 1 2007504400 37550000 10312000
17:51:55 19929 8192000000 10936332000 11380174848 1965736832 19.352 100 30 60 0 2014690768 38284704 10669232
17:52:28 8510 8192000000 10941574800 11383447552 1964975648 19.346 100 37 74 1 2024216992 46443504 12797840
17:52:55 10865 8192000000 10939978112 11385663488 1965920640 19.353 100 40 80 0 2024909008 45117696 13870672
17:53:13 15514 8192000000 10934332544 11384311808 1951453808 19.238 99 40 78 1 2011511360 46746592 13310960
17:53:47 4665 8192000000 10975785152 11403255808 1975233424 19.427 100 65 128 2 2044624448 49440768 19950256
17:53:58 8511 8192000000 10929197344 11370848256 1931304864 19.077 98 34 68 0 1994125744 51210880 11610000
17:54:15 15052 8192000000 10932286480 11371925504 1931752432 19.081 99 34 68 1 1997942256 54746640 11443184
17:54:39 5345 8192000000 10938380096 11373715456 1950113024 19.227 100 44 87 1 2018795296 54026528 14655744
17:55:02 18387 8192000000 10923561024 11367178240 1944223856 19.180 100 37 74 0 2005811680 49380448 12207376
17:55:29 19400 8192000000 10914848048 11354996736 1943325216 19.173 100 24 48 1 1992524064 40760320 8438528
17:56:02 16245 8192000000 10918452720 11365298176 1947834128 19.209 100 30 60 0 2001619440 43775328 10009984
17:56:25 9124 8192000000 10917028688 11369914368 1951270144 19.237 100 37 74 2 2004830576 41999184 11561248
17:56:42 9718 8192000000 10914343120 11375611904 1953419200 19.254 100 29 58 1 2006368704 43562464 9387040
17:57:08 26022 8192000000 10917430800 11370270720 1951239280 19.236 100 21 41 2 2001223920 42759536 7225104
17:57:40 17017 8192000000 10930733904 11381452800 1958252480 19.292 100 20 40 1 2006926848 42379328 6295040
17:58:08 22446 8192000000 10923195120 11384496128 1947710288 19.208 100 16 32 1 1991752576 38633904 5408384
17:58:37 12756 8192000000 10927772304 11379200000 1950456208 19.230 100 14 28 5 2000025584 44586480 4982896
18:00:05 56736 8192000000 10904430352 11373297664 1959232496 19.300 100 8 16 0 1980419136 18845232 2341408
18:01:08 76764 8192000000 10913047936 11349250048 1950301200 19.229 99 9 18 1 1970663168 18427184 1934784
18:02:34 13618 8192000000 10932124112 11366592512 1967594128 19.366 99 57 109 1 1994189520 9453056 17142336
18:03:00 46685 8192000000 10915818416 11372695552 1961522720 19.318 99 32 64 0 1979440896 9203440 8714736
18:04:01 28573 8192000000 10913249040 11362181120 1963516688 19.334 99 34 68 0 1982278912 8380448 10381776
18:04:49 132321 8192000000 10934166656 11374297088 1961554992 19.318 99 27 54 1 1979914752 10012688 8347072
18:07:10 2913 8192000000 10930242416 11371778048 1985387536 19.507 100 59 120 2 2012715712 9541664 17786512
18:07:21 103121 8192000000 10917678784 11384610816 1983361840 19.491 100 28 56 0 2002781040 11036528 8382672
18:09:12 74604 8192000000 10902279200 11373088768 1961690560 19.319 99 27 54 0 1985274576 16048240 7535776
18:10:37 36783 8192000000 10903251632 11373727744 1979583520 19.461 100 15 30 3 1991923680 7605024 4735136
18:11:35 28270 8192000000 10900572000 11366113280 1971600032 19.398 99 20 40 1 1986028272 8727472 5700768
18:12:09 21904 8192000000 10939421952 11392880640 1997204096 19.601 100 40 80 1 2020155808 11196960 11754752
18:12:43 33817 8192000000 10924516048 11395239936 1999283552 19.617 100 29 58 1 2021084656 13155680 8645424
18:13:26 37293 8192000000 10953803824 11394711552 1986080144 19.513 99 37 75 1 2007877968 11790176 10007648
18:14:15 50679 8192000000 10917947856 11389267968 1946083536 19.195 97 53 109 0 1979596960 17834928 15678496
18:15:16 51182 8192000000 10915114288 11395850240 1986085328 19.513 100 17 34 0 2005515632 14850416 4579888
18:16:21 17873 8192000000 10901234832 11382771712 1966624272 19.359 99 16 32 1 1986303616 14679136 5000208
18:16:46 11978 8192000000 10896062528 11384086528 1977238832 19.443 100 5 9 0 1989573200 11450656 883712
18:17:04 2350 8192000000 10895328800 11384074240 1976982560 19.441 100 3 6 0 1988890512 11015776 892176
18:17:12 14506 8192000000 10899046912 11375812608 1966693904 19.359 99 11 21 0 1980166320 10729376 2743040
18:18:46 113760 8192000000 10910292480 11399884800 1953841456 19.257 98 15 30 1 1981630960 23367296 4422208
18:20:58 37790 8192000000 10908725536 11379548160 1974442240 19.421 100 10 18 0 1984686352 7308304 2935808
18:21:48 41929 8192000000 10896925824 11372728320 1952228336 19.244 98 26 50 2 1968787200 9547968 7010896
18:22:37 45289 8192000000 10891188960 11369115648 1904723328 18.864 96 16 30 1 1916340368 7447648 4169392
18:23:39 21646 8192000000 10865897488 11329929216 1887409296 18.725 96 27 54 0 1902013600 7169696 7434608
18:24:11 64274 8192000000 10885758272 11352080384 1915754976 18.953 98 16 32 0 1930772624 10541712 4475936
18:25:39 73065 8192000000 10851425136 11313819648 1830858304 18.266 94 18 36 2 1850354400 14178288 5317808
18:27:01 61720 8192000000 10854687904 11304857600 1837034112 18.317 95 20 40 0 1849359792 6779216 5546464
18:28:09 67023 8192000000 10846508480 11314712576 1865351552 18.547 97 23 46 0 1885512464 13786560 6374352
18:29:24 51751 8192000000 10835181008 11305742336 1821114720 18.187 95 15 30 1 1842483184 17497120 3871344
18:30:24 108565 8192000000 10846782320 11311558656 1827103568 18.236 95 8 16 1 1843981328 14554000 2323760
18:32:19 62115 8192000000 10840895936 11304714240 1810856944 18.103 94 12 23 0 1826496688 12320736 3319008
18:33:27 86044 8192000000 10874835888 11340017664 1853557328 18.451 96 18 35 1 1873491712 15179104 4755280
18:35:15 100412 8192000000 10870422496 11333943296 1910047344 18.907 99 22 44 0 1939364992 22199520 7118128
18:37:02 77387 8192000000 10857485328 11322617856 1904155440 18.860 99 29 58 1 1933299424 19794144 9349840
18:38:39 21885 8192000000 10857886496 11322408960 1910957936 18.914 99 27 54 1 1929903008 11178800 7766272
18:39:08 24788 8192000000 10873921856 11318382592 1894133232 18.779 98 37 74 0 1916498880 11747120 10618528
18:39:52 99849 8192000000 10866600992 11331624960 1908227216 18.892 98 14 28 0 1923030976 11148432 3655328
18:41:43 51489 8192000000 10873097008 11339059200 1929672336 19.064 99 15 30 0 1944309680 10730032 3907312
18:43:57 60525 8192000000 10877471664 11350986752 1936940704 19.122 99 11 22 0 1956034960 15744272 3349984
18:45:04 44704 8192000000 10885580032 11358097408 1958929392 19.298 100 9 18 0 1972584576 10843760 2811424
18:45:57 76046 8192000000 10873292928 11333586944 1925728000 19.033 98 15 30 2 1940254272 10627488 3898784
18:47:24 21367 8192000000 10884510592 11343298560 1937016672 19.123 99 22 44 0 1950377904 7427648 5933584
18:47:52 56205 8192000000 10867209568 11350024192 1947304928 19.205 100 19 38 2 1965201776 12394400 5502448
18:48:55 89809 8192000000 10869197760 11357835264 1954330752 19.261 100 6 12 0 1967988064 11966928 1690384
18:50:34 61445 8192000000 10878590048 11359473664 1925549024 19.031 98 11 22 0 1941558128 13050656 2958448
18:51:45 65928 8192000000 10885871072 11367235584 1940667712 19.152 99 14 28 0 1957928432 13069488 4191232
18:52:57 56216 8192000000 10902841568 11370319872 1949224048 19.220 99 13 26 0 1961432272 8653056 3555168
18:54:02 16477 8192000000 10900574576 11365683200 1956140928 19.275 99 27 54 0 1971210592 7518896 7550768
18:54:29 24364 8192000000 10912313152 11371065344 1939100624 19.140 98 34 68 0 1964886544 16359424 9426496
18:55:06 77185 8192000000 10926008448 11395801088 1965289280 19.348 99 24 48 1 1989695392 17283136 7122976
18:56:41 52594 8192000000 10940197792 11407638528 1982280656 19.483 100 21 41 0 2015223840 26211168 6732016
18:57:47 52461 8192000000 10917922784 11402526720 1981048832 19.473 100 12 24 1 2008348192 23498720 3800640
18:58:46 96690 8192000000 10891926544 11368845312 1892625264 18.767 95 11 22 1 1905374000 9453232 3295504
19:00:30 149063 8192000000 10921021904 11392364544 1903304448 18.853 96 16 32 0 1919148896 11726400 4118048
19:03:10 48842 8192000000 10916442080 11389186048 1926356272 19.038 97 7 12 0 1937350880 9215840 1778768
19:04:06 44447 8192000000 10926414208 11399557120 1985733312 19.510 100 14 28 2 2003273328 14117968 3422048
19:04:58 141177 8192000000 10928166656 11399380992 1978337440 19.452 99 25 50 1 1994491216 9163808 6989968
19:07:33 34293 8192000000 10937871696 11395833856 1996628640 19.596 100 51 102 0 2023180304 12533216 14018448
19:08:20 27927 8192000000 10941177056 11402588160 2000080784 19.623 100 49 98 0 2030501056 16904400 13515872
19:08:55 17522 8192000000 10907743216 11382665216 1969083392 19.378 99 22 44 2 1991778672 16012208 6683072
19:09:27 17432 8192000000 10896827152 11380097024 1974696560 19.423 100 5 10 1 1987530320 11334896 1498864
19:09:50 68293 8192000000 10883531344 11363069952 1896126624 18.795 96 6 12 0 1906824144 9073472 1624048
19:11:09 70156 8192000000 10870941920 11344486400 1923435616 19.014 98 19 38 1 1936784592 7973824 5375152
19:12:28 65925 8192000000 10886030768 11366916096 1949346592 19.221 99 26 52 0 1972048208 14580992 8120624
19:13:45 68444 8192000000 10876267360 11351773184 1877729488 18.647 96 8 16 1 1890718304 10757920 2230896
19:16:18 54586 8192000000 10884950544 11356303360 1917535152 18.967 98 14 28 0 1935526976 14278464 3713360
19:17:18 30881 8192000000 10858906992 11331305472 1881994000 18.681 96 17 36 0 1896998528 10307744 4696784
19:17:58 55053 8192000000 10891820064 11359412224 1941345824 19.157 99 30 58 1 1960117936 10785584 7986528
19:18:59 72966 8192000000 10871700336 11347079168 1865612464 18.549 95 21 42 2 1890870544 18679024 6579056
19:20:23 79546 8192000000 10878133200 11346448384 1907965984 18.890 98 17 34 2 1927534960 14734528 4834448
19:21:50 70562 8192000000 10875016160 11337646080 1854576448 18.459 95 24 47 1 1874303424 12862240 6864736
19:23:07 68684 8192000000 10864317488 11334918144 1859530400 18.499 96 25 48 1 1886196352 19975536 6690416
19:24:29 60360 8192000000 10844803296 11336323072 1902515792 18.847 99 15 30 0 1927732432 20968224 4248416
19:25:36 74491 8192000000 10855666880 11323273216 1856283792 18.473 96 19 38 2 1872982544 11594528 5104224

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 23-11-2020 19:28:06 to 23-11-2020 19:28:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 121 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-11-2020 19:28:40 to 23-11-2020 19:28:42.

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          250062
MON$OLDEST_ACTIVE               250500
MON$OLDEST_SNAPSHOT             250500
MON$NEXT_TRANSACTION            250500
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                       2071008
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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 ---
:131: 
:132: mscs-test-161.budzdorov.ru    Mon Nov 23 19:27:18 2020
:133:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:134: 
:135: 
:136: mscs-test-161.budzdorov.ru    Mon Nov 23 19:27:19 2020
:137:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:138: 
:139: 
:140: mscs-test-161.budzdorov.ru    Mon Nov 23 19:27:20 2020
:141:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:142: 
:143: 
:144: mscs-test-161.budzdorov.ru    Mon Nov 23 19:27:23 2020
:145:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:146: 
:147: 
:148: mscs-test-161.budzdorov.ru    Mon Nov 23 19:27:23 2020
:149:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:150: 
:151: 
:152: mscs-test-161.budzdorov.ru    Mon Nov 23 19:27:23 2020
:153:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:154: 
--- end of diff output ---

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

23.11.20 19:28:43. 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-11-23 19:28:45 No severe PSQL-related problems occured
23.11.20 19:28:47. End of report.