Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 31.12.2020 19:29
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 17084664 kB
MemAvailable 31465180 kB
Buffers 0 kB
Cached 14631608 kB
SwapCached 4820 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-31 19:27:08
DTS_END                         2020-12-31 19:27:08.0710
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/35532
TRN_ID                          247949
ATT_ID                          692
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: 9462.65 23086 1135518
customer order: creation 178.29 356 21395
customer order: refuse 15.07 379 1808
order to supplier: creation 47.56 1260 5707
order to supplier: removal 3.81 103709 457
invoice (draft): creation 47.88 3865 5746
invoice (draft): removal 55.22 825 6626
invoice accept: apply 42.68 18771 5122
invoice accept: cancel 49.25 841 5910
customer reserve: creation 3916.93 185 470032
customer reserve: removal 4800.66 64 576079
realization accept: apply 86.48 196 10378
realization accept: cancel 84.40 129 10128
payment from customer: creation 60.27 129 7232
payment from customer: removal 6.24 94 749
payment to supplier: creation 51.13 132 6135
payment to supplier: removal 3.76 104 451
service: total inventory turnovers 5.12 1098 614
service: total monetary turnovers 7.22 62 866
service: aggregate perf. data 0.66 29768 79
service: refresh index statistics 0.03 299743 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 31-12-2020 19:29:22 to 31-12-2020 19:29:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8720
TEST_TIME 2 5049
TEST_TIME 3 7317
TEST_TIME 4 7033
TEST_TIME 5 6665
TEST_TIME 6 7044
TEST_TIME 7 7088
TEST_TIME 8 7131
TEST_TIME 9 7500
TEST_TIME 10 7388
TEST_TIME 11 7423
TEST_TIME 12 7786
TEST_TIME 13 7769
TEST_TIME 14 7794
TEST_TIME 15 8212
TEST_TIME 16 8367
TEST_TIME 17 8191
TEST_TIME 18 8489
TEST_TIME 19 8509
TEST_TIME 20 8429
TEST_TIME 21 8732
TEST_TIME 22 8525
TEST_TIME 23 9117
TEST_TIME 24 9146
TEST_TIME 25 9424
TEST_TIME 26 9449
TEST_TIME 27 9546
TEST_TIME 28 9663
TEST_TIME 29 10128
TEST_TIME 30 10471
TEST_TIME 31 10637
TEST_TIME 32 11060
TEST_TIME 33 10948
TEST_TIME 34 10761
TEST_TIME 35 10729
TEST_TIME 36 10699
TEST_TIME 37 10698
TEST_TIME 38 10761
TEST_TIME 39 10618
TEST_TIME 40 10410
TEST_TIME 41 10257
TEST_TIME 42 10180
TEST_TIME 43 10153
TEST_TIME 44 10019
TEST_TIME 45 10091
TEST_TIME 46 10019
TEST_TIME 47 10007
TEST_TIME 48 9988
TEST_TIME 49 10075
TEST_TIME 50 9982
TEST_TIME 51 9866
TEST_TIME 52 9872
TEST_TIME 53 9902
TEST_TIME 54 9992
TEST_TIME 55 9913
TEST_TIME 56 9945
TEST_TIME 57 10013
TEST_TIME 58 10004
TEST_TIME 59 9961
TEST_TIME 60 9994
TEST_TIME 61 10056
TEST_TIME 62 10051
TEST_TIME 63 10117
TEST_TIME 64 10101
TEST_TIME 65 10190
TEST_TIME 66 10158
TEST_TIME 67 10056
TEST_TIME 68 10033
TEST_TIME 69 10014
TEST_TIME 70 9940
TEST_TIME 71 9847
TEST_TIME 72 9883
TEST_TIME 73 9914
TEST_TIME 74 9863
TEST_TIME 75 9813
TEST_TIME 76 9775
TEST_TIME 77 9690
TEST_TIME 78 9658
TEST_TIME 79 9691
TEST_TIME 80 9701
TEST_TIME 81 9816
TEST_TIME 82 9765
TEST_TIME 83 9752
TEST_TIME 84 9828
TEST_TIME 85 9838
TEST_TIME 86 9834
TEST_TIME 87 9797
TEST_TIME 88 9867
TEST_TIME 89 9848
TEST_TIME 90 9927
TEST_TIME 91 9914
TEST_TIME 92 9817
TEST_TIME 93 9800
TEST_TIME 94 9765
TEST_TIME 95 9723
TEST_TIME 96 9729
TEST_TIME 97 9683
TEST_TIME 98 9652
TEST_TIME 99 9632
TEST_TIME 100 9678
TEST_TIME 101 9657
TEST_TIME 102 9631
TEST_TIME 103 9694
TEST_TIME 104 9672
TEST_TIME 105 9679
TEST_TIME 106 9722
TEST_TIME 107 9694
TEST_TIME 108 9738
TEST_TIME 109 9761
TEST_TIME 110 9779
TEST_TIME 111 9765
TEST_TIME 112 9705
TEST_TIME 113 9663
TEST_TIME 114 9664
TEST_TIME 115 9638
TEST_TIME 116 9627
TEST_TIME 117 9604
TEST_TIME 118 9578
TEST_TIME 119 9540
TEST_TIME 120 9465

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 31-12-2020 19:29:26 to 31-12-2020 19:29:30.

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 1573931 1573931 0 0.00 0 13251 7 0 0
doc_list_biud 1573931 1573931 0 0.00 0 80201 30 0 0
sp_add_invoice_to_stock 5239 5122 117 2.23 45 158064 18771 0 117
sp_cancel_adding_invoice 5910 5910 0 0.00 6 90266 841 0 0
sp_cancel_client_order 1808 1808 0 0.00 4 11611 380 0 0
sp_cancel_customer_reserve 576079 576079 0 0.00 1 55945 64 0 0
sp_cancel_pay_from_customer 749 749 0 0.00 3 5797 95 0 0
sp_cancel_pay_to_supplier 451 451 0 0.00 3 6212 104 0 0
sp_cancel_supplier_invoice 6640 6626 14 0.21 2 80273 825 0 14
sp_cancel_supplier_order 457 457 0 0.00 8 989359 103710 0 0
sp_cancel_write_off 10128 10128 0 0.00 1 11999 129 0 0
sp_client_order 21395 21395 0 0.00 3 54407 357 0 0
sp_customer_reserve 470032 470032 0 0.00 0 40927 186 0 0
sp_fill_shopping_cart 32838 32838 0 0.00 1 28151 39 0 0
sp_fill_shopping_cart_clo_res 470028 470028 0 0.00 0 13795 12 0 0
sp_get_clo_for_invoice 5117 5117 0 0.00 0 22984 288 0 0
sp_kill_cost_storno 17238 17238 0 0.00 0 5514 63 0 0
sp_kill_qstorno_ret_qs2qd 1169369 1169369 0 0.00 0 80200 35 0 0
sp_kill_qty_storno 616503 616503 0 0.00 0 80201 75 0 0
sp_lock_selected_doc 21601 21601 0 0.00 0 7500 6 0 0
sp_make_cost_storno 28862 28862 0 0.00 0 13238 54 0 0
sp_multiply_rows_for_pdistr 28862 28862 0 0.00 0 8337 34 0 0
sp_multiply_rows_for_qdistr 21395 21395 0 0.00 0 54396 163 0 0
sp_pay_from_customer 7232 7232 0 0.00 4 20562 130 0 0
sp_pay_to_supplier 6135 6135 0 0.00 5 16001 133 0 0
sp_payment_common 13367 13367 0 0.00 2 20556 25 0 0
sp_qd_handle_on_cancel_clo 1808 1808 0 0.00 0 11605 344 0 0
sp_qd_handle_on_invoice_upd_sts 11027 11027 0 0.00 0 36513 371 0 0
sp_qd_handle_on_reserve_upd_sts 10378 10378 0 0.00 0 16557 70 0 0
sp_reserve_write_off 10378 10378 0 0.00 6 16578 196 0 0
sp_supplier_invoice 5746 5746 0 0.00 5 84533 3866 0 0
sp_supplier_order 5707 5707 0 0.00 5 32217 1261 0 0
srv_aggregate_perf_data 79 79 0 0.00 3128 445974 29768 0 0
srv_fill_mon_cache_memory 186 186 0 0.00 1059 182108 27662 0 0
srv_find_qd_qs_mism 1087940 1087940 0 0.00 0 12611 5 0 0
srv_make_invnt_saldo 614 614 0 0.00 41 55453 1098 0 0
srv_make_money_saldo 866 866 0 0.00 1 22882 62 0 0
srv_recalc_idx_stat 4 4 0 0.00 87496 539939 299744 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5122 5122 0 0.00 0 21385 178 0 0
t$perf-norm:sp_cancel_adding_invoice 415 415 0 0.00 0 5050 83 0 0
t$perf-norm:sp_cancel_client_order 1808 1808 0 0.00 0 3017 19 0 0
t$perf-norm:sp_cancel_customer_reserve 731 731 0 0.00 0 821 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 749 749 0 0.00 0 7056 24 0 0
t$perf-norm:sp_cancel_pay_to_supplier 451 451 0 0.00 0 5295 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 431 431 0 0.00 0 1435 22 0 0
t$perf-norm:sp_cancel_supplier_order 457 457 0 0.00 0 36555 1705 0 0
t$perf-norm:sp_cancel_write_off 1065 1065 0 0.00 0 1910 10 0 0
t$perf-norm:sp_client_order 21395 21395 0 0.00 0 27152 22 0 0
t$perf-norm:sp_customer_reserve 1007 1007 0 0.00 0 4946 12 0 0
t$perf-norm:sp_pay_from_customer 7232 7232 0 0.00 0 11538 11 0 0
t$perf-norm:sp_pay_to_supplier 6135 6135 0 0.00 0 21789 11 0 0
t$perf-norm:sp_reserve_write_off 10378 10378 0 0.00 0 4561 10 0 0
t$perf-norm:sp_supplier_invoice 5746 5746 0 0.00 0 4766 23 0 0
t$perf-norm:sp_supplier_order 5707 5707 0 0.00 0 7444 20 0 0
t$perf-norm:srv_aggregate_perf_data 79 79 0 0.00 0 858 23 0 0
t$perf-norm:srv_fill_mon_cache_memory 186 186 0 0.00 0 185 6 0 0
t$perf-norm:srv_make_invnt_saldo 614 614 0 0.00 0 4078 33 0 0
t$perf-norm:srv_make_money_saldo 866 866 0 0.00 0 1776 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10466 10232 234 2.23 0 10335 19 0 234
v_all_customers 38846 38846 0 0.00 0 26 1 0 0
v_all_suppliers 31768 31768 0 0.00 0 115 1 0 0
v_all_wares 42790 42790 0 0.00 0 200 1 0 0
v_cancel_adding_invoice 830 830 0 0.00 0 489 6 0 0
v_cancel_client_order 3616 3616 0 0.00 0 10439 9 0 0
v_cancel_customer_prepayment 1498 1498 0 0.00 0 2966 8 0 0
v_cancel_customer_reserve 1462 1462 0 0.00 0 12020 15 0 0
v_cancel_payment_to_supplier 902 902 0 0.00 0 628 4 0 0
v_cancel_supplier_invoice 890 862 28 3.14 0 1100 17 0 28
v_cancel_supplier_order 914 914 0 0.00 0 2141 10 0 0
v_cancel_write_off 2130 2130 0 0.00 0 5431 16 0 0
v_max_id_clo_ord 5704 5704 0 0.00 0 204 1 0 0
v_max_id_clo_res 1007 1007 0 0.00 0 3751 15 0 0
v_max_id_ord_sup 5739 5739 0 0.00 0 6482 4 0 0
v_max_non_paid_invoice 1694 1694 0 0.00 0 2324 4 0 0
v_max_non_paid_realizn 3987 3987 0 0.00 0 2710 4 0 0
v_min_id_clo_ord 5704 5704 0 0.00 0 2572 6 0 0
v_min_id_clo_res 1007 1007 0 0.00 0 3911 5 0 0
v_min_id_ord_sup 5739 5739 0 0.00 0 15986 9 0 0
v_min_non_paid_invoice 6135 6135 0 0.00 0 8113 13 0 0
v_min_non_paid_realizn 7232 7232 0 0.00 0 20546 19 0 0
v_our_firm 10434 10434 0 0.00 0 23 1 0 0
v_reserve_write_off 20756 20756 0 0.00 0 15705 7 0 0
x_lock_depdocs_on_canc_invoice 12105 12105 0 0.00 0 26760 130 0 0
x_lock_depdocs_on_canc_sup_ord 457 457 0 0.00 0 5802 343 0 0
x_make_qstorno_1000_1200 5707 5707 0 0.00 1 32211 1168 0 0
x_make_qstorno_1200_2000 5746 5746 0 0.00 3 84499 3730 0 0
x_make_qstorno_2100_3300 470032 470032 0 0.00 0 40828 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-12-2020 19:29:31 to 31-12-2020 19:29:35.

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:11 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:17 16984 8192000000 10226189328 10534498304 946809184 10.360 75 46 92 1 965569888 2745792 16014912
16:57:42 20543 8192000000 10339212608 10652299264 1375414864 14.376 100 83 167 1 1406211952 4236064 26561024
16:58:16 25947 8192000000 10368287952 10689191936 1418151872 14.756 100 89 179 0 1453692112 6284144 29256096
16:58:56 25162 8192000000 10406135504 10734014464 1459990272 15.126 100 90 180 1 1496205520 7360448 28854800
16:59:33 26641 8192000000 10424469120 10756169728 1480058160 15.302 100 92 184 0 1517895392 8308512 29528720
17:00:10 18353 8192000000 10434805088 10769580032 1491670528 15.403 100 89 177 0 1528645680 8699440 28275712
17:00:37 7812 8192000000 10448728736 10783051776 1506158512 15.530 100 90 180 1 1543472944 9097888 28216544
17:00:54 21640 8192000000 10470703904 10807582720 1512970976 15.589 100 84 168 0 1549286752 9633728 26682048
17:01:27 6208 8192000000 10479302976 10820943872 1537523792 15.802 100 90 180 1 1576008512 10662304 27822416
17:01:46 18930 8192000000 10501805072 10851024896 1558339744 15.982 100 81 162 1 1593435600 10228320 24867536
17:02:19 13042 8192000000 10545107136 10898759680 1603266592 16.367 100 79 158 0 1637862064 10839696 23755776
17:02:41 7992 8192000000 10559855296 10918096896 1619747024 16.508 100 71 142 0 1651966944 10775392 21444528
17:02:59 11178 8192000000 10576164848 10939318272 1639834624 16.678 100 79 158 0 1674594224 10957104 23802496
17:03:18 8309 8192000000 10590782256 10956775424 1653147312 16.791 100 65 126 3 1681851840 10399376 18305152
17:03:33 7614 8192000000 10619612336 10989281280 1678724416 17.007 100 75 149 0 1711006656 10985072 21297168
17:03:49 10432 8192000000 10635175712 11009966080 1707928832 17.251 100 75 148 1 1740990000 11480608 21580560
17:04:08 7319 8192000000 10657411216 11032055808 1718595968 17.340 100 77 154 1 1753146080 12483200 22066912
17:04:22 6725 8192000000 10673886400 11049828352 1736451904 17.489 100 83 165 1 1773428272 13016752 23959616
17:04:36 4812 8192000000 10690931456 11065413632 1748936288 17.593 100 90 179 2 1788530352 14143248 25450816
17:04:49 4377 8192000000 10696739968 11069911040 1756645232 17.657 100 85 167 1 1795052768 14364656 24042880
17:05:00 5277 8192000000 10704620800 11081691136 1765253152 17.728 100 82 164 1 1802563040 14197008 23112880
17:05:13 3015 8192000000 10708470768 11090415616 1767165920 17.744 100 83 166 2 1804488128 13989872 23332336
17:05:22 3373 8192000000 10719607568 11098312704 1782671184 17.871 100 90 180 2 1821628560 14158976 24798400
17:05:33 3160 8192000000 10720373328 11101642752 1789344688 17.926 100 88 176 0 1827983936 14577888 24061360
17:05:43 4173 8192000000 10741061552 11120861184 1795101920 17.974 100 91 183 1 1836316784 16051424 25163440
17:05:54 2309 8192000000 10744085200 11123949568 1806787536 18.070 100 94 188 2 1847576512 15060768 25728208
17:06:03 6656 8192000000 10751582880 11140722688 1807231552 18.073 100 73 146 2 1841146944 14395920 19519472
17:06:17 2807 8192000000 10765996928 11148021760 1813920368 18.128 100 76 152 0 1849198784 12557776 22720640
17:06:26 2953 8192000000 10778135168 11167186944 1833298272 18.286 100 89 178 1 1872152432 13348464 25505696
17:06:36 2327 8192000000 10777727040 11167543296 1836727904 18.314 100 80 159 1 1871011952 11957488 22326560
17:06:45 2769 8192000000 10785208960 11171360768 1846162320 18.391 100 93 186 2 1886209696 13619552 26427824
17:06:54 2297 8192000000 10790476768 11177201664 1849379440 18.417 100 95 190 2 1890269808 14334368 26556000
17:07:03 1691 8192000000 10794511952 11185512448 1855579792 18.467 100 90 179 1 1893387136 13091152 24716192
17:07:11 1755 8192000000 10802223680 11187851264 1865809008 18.550 100 89 176 3 1903452784 12862176 24781600
17:07:19 1965 8192000000 10804650176 11199741952 1865314896 18.546 100 81 163 0 1899735216 12386496 22033824
17:07:27 1610 8192000000 10809307312 11200208896 1866277408 18.554 100 86 173 1 1903959504 13624848 24057248
17:07:35 4940 8192000000 10785607360 11195469824 1866158080 18.553 100 73 147 0 1900648880 13706528 20784272
17:07:46 7038 8192000000 10802351952 11201634304 1869967040 18.584 100 71 141 1 1900547136 10789184 19790912
17:08:03 2060 8192000000 10810803728 11208392704 1874024384 18.617 100 80 160 1 1908887744 11395216 23468144
17:08:12 6178 8192000000 10788422304 11204620288 1871337776 18.595 100 54 108 1 1897770080 10500736 15931568
17:08:26 8693 8192000000 10791047872 11208957952 1871979600 18.600 100 37 73 2 1890155632 7776832 10399200
17:08:44 7224 8192000000 10786817856 11208318976 1874622368 18.622 100 36 72 0 1892321936 7508976 10190592
17:08:58 5070 8192000000 10792676608 11208896512 1875928688 18.632 100 43 86 3 1895297904 7391840 11977376
17:09:09 3527 8192000000 10793244368 11211788288 1876161152 18.634 100 32 64 0 1893649840 8091264 9397424
17:09:20 8665 8192000000 10789111024 11217670144 1882833984 18.688 100 33 66 0 1899354032 7586768 8933280
17:10:17 27231 8192000000 10798124496 11227930624 1883620432 18.694 100 32 61 5 1899938992 7482176 8836384
17:10:50 3182 8192000000 10806532400 11229696000 1886328784 18.716 100 29 59 2 1900730480 5930912 8470784
17:11:00 7360 8192000000 10795395056 11230650368 1886779504 18.720 100 25 50 2 1900311584 6724800 6807280
17:11:16 5433 8192000000 10789108128 11230515200 1886814672 18.720 100 24 48 1 1900660080 6489664 7355744
17:11:31 5710 8192000000 10809562752 11236999168 1892513264 18.766 100 27 54 2 1906535600 6977456 7044880
17:11:44 8562 8192000000 10798362160 11232444416 1891829184 18.761 100 27 54 1 1906776288 6940832 8006272
17:11:58 6534 8192000000 10800954496 11237150720 1894746672 18.784 100 23 46 2 1907531248 6509024 6275552
17:12:11 9232 8192000000 10809879632 11241316352 1895463440 18.790 100 21 42 2 1907792256 5523840 6804976
17:12:32 6252 8192000000 10814172896 11242942464 1897276944 18.804 100 16 32 0 1908262096 5522672 5462480
17:12:44 4834 8192000000 10817899392 11249258496 1902545136 18.847 100 23 46 0 1915840048 6934848 6360064
17:12:58 6739 8192000000 10813588592 11246026752 1902512848 18.847 100 27 54 1 1916058832 5989056 7556928
17:13:16 8511 8192000000 10821430032 11254820864 1903480544 18.854 100 26 52 3 1922358608 11529600 7348464
17:13:30 8547 8192000000 10802746048 11242082304 1899512576 18.822 100 19 38 0 1911242128 5896864 5832688
17:13:49 10926 8192000000 10824435296 11256553472 1907843536 18.889 100 17 32 0 1918871232 5315872 5711824
17:14:06 14550 8192000000 10822821248 11256512512 1909586528 18.903 100 21 42 1 1920962720 5618688 5757504
17:14:27 61030 8192000000 10844814080 11273818112 1895976272 18.794 99 39 77 1 1912251216 5698784 10576160
17:15:34 14113 8192000000 10824055360 11258908672 1908643760 18.896 100 18 36 2 1919793840 6116016 5034064
17:15:54 5287 8192000000 10825632768 11264098304 1914840032 18.945 100 30 60 3 1930003088 6352672 8810384
17:16:07 5845 8192000000 10825279536 11269079040 1919099552 18.980 100 28 56 0 1934214752 6729936 8385264
17:16:19 8164 8192000000 10837693264 11267719168 1914341456 18.941 100 31 62 1 1928973120 6737872 7893792
17:16:35 8188 8192000000 10821338400 11257643008 1883506160 18.693 98 27 53 0 1900297248 9292256 7498832
17:16:51 7814 8192000000 10792572080 11230855168 1854746720 18.461 97 32 64 2 1870188944 6557072 8885152
17:17:05 9741 8192000000 10798879456 11236888576 1860322752 18.506 98 22 44 2 1871889984 5896192 5671040
17:17:21 5850 8192000000 10807128880 11235454976 1873569712 18.613 99 19 39 0 1886149936 6318160 6262064
17:17:35 11319 8192000000 10784049744 11215589376 1855139536 18.464 99 28 56 1 1873173200 10327680 7705984
17:17:54 9450 8192000000 10769693424 11197743104 1827631040 18.240 98 23 44 0 1839323360 5825904 5866416
17:18:12 7399 8192000000 10739122384 11165642752 1775175120 17.810 96 27 54 2 1788202224 5433808 7593296
17:18:25 7759 8192000000 10755466416 11177758720 1825743264 18.225 99 26 52 1 1843691200 10084656 7863280
17:18:41 11820 8192000000 10742651536 11164049408 1794859888 17.972 97 23 45 1 1806976800 5543136 6573776
17:19:00 68669 8192000000 10695419712 11098923008 1599030512 16.331 87 42 84 0 1616707760 4023248 13654000
17:20:15 13640 8192000000 10682759920 11088064512 1664495680 16.887 93 31 61 1 1679868752 6160064 9213008
17:20:35 6258 8192000000 10697492368 11107971072 1751409488 17.613 98 38 76 1 1769187584 7269360 10508736
17:20:48 8261 8192000000 10680625392 11093946368 1726417904 17.406 97 32 63 2 1741166656 6158144 8590608
17:21:05 8183 8192000000 10689468560 11101872128 1752967808 17.626 98 23 46 1 1765235312 5646048 6621456
17:21:22 7167 8192000000 10685619584 11098406912 1719463296 17.348 96 28 56 0 1733107072 5356352 8287424
17:21:39 8000 8192000000 10699903824 11123363840 1795687792 17.979 100 29 58 5 1810285120 5719392 8877936
17:21:55 8030 8192000000 10736904496 11151036416 1815609312 18.142 100 32 64 3 1831346144 6580736 9156096
17:22:11 8852 8192000000 10745544496 11166449664 1830580992 18.264 100 21 42 1 1842363136 6082768 5699376
17:22:27 11086 8192000000 10745646704 11165794304 1828168112 18.244 100 24 48 0 1840769040 5656080 6944848
17:22:48 12267 8192000000 10747077792 11166363648 1830837760 18.266 100 15 30 0 1840308816 5300448 4170608
17:23:12 8093 8192000000 10757843664 11181682688 1843569760 18.370 100 28 56 2 1857944192 5525344 8849088
17:23:27 20356 8192000000 10758768304 11181314048 1847653904 18.403 100 22 42 2 1859965856 5478144 6833808
17:23:57 66402 8192000000 10751885040 11189825536 1854522272 18.459 100 47 94 1 1874154912 5164336 14468304
17:25:09 8082 8192000000 10767649648 11193774080 1851213280 18.432 100 20 40 1 1861836032 5397040 5225712
17:25:25 7880 8192000000 10772687136 11195023360 1852810192 18.445 100 25 50 0 1865590512 5089232 7691088
17:25:40 8321 8192000000 10762973312 11196993536 1861158416 18.513 100 36 73 0 1877284384 6141296 9984672
17:25:56 9758 8192000000 10771072048 11200606208 1859202048 18.497 100 19 38 0 1870387920 5646800 5539072
17:26:12 7860 8192000000 10776963568 11205070848 1861817328 18.518 100 22 44 2 1873729312 5777872 6134112
17:26:26 6472 8192000000 10774787424 11204239360 1863990688 18.536 100 26 53 0 1876842720 5489408 7362624
17:26:39 7870 8192000000 10777825536 11209105408 1865905616 18.551 100 29 58 1 1880294528 5790912 8598000
17:26:53 7923 8192000000 10779459280 11213295616 1871762992 18.599 100 21 40 2 1883544208 5876608 5904608
17:27:07 12387 8192000000 10817048512 11233009664 1890511216 18.750 100 26 51 1 1902851184 4946800 7393168
17:27:27 8347 8192000000 10845697856 11261259776 1915958128 18.954 100 67 134 2 1941620336 7178448 18483760
17:27:50 6037 8192000000 10846741232 11264790528 1918593600 18.976 100 58 115 1 1942489376 7888928 16006848
17:28:07 3963 8192000000 10863457440 11277848576 1927672704 19.048 100 59 118 1 1952240944 8914384 15653856
17:28:19 9310 8192000000 10871684064 11280064512 1933393632 19.094 100 65 130 0 1960991104 9155184 18442288
17:28:38 88940 8192000000 10876821216 11301105664 1939788608 19.145 100 62 124 2 1969024192 11149104 18086480
17:30:13 26405 8192000000 10853384784 11299233792 1934312592 19.101 100 21 42 1 1949242192 8929984 5999616
17:31:04 23130 8192000000 10868267616 11298418688 1929780368 19.065 99 34 68 1 1949957760 10181552 9995840
17:31:37 5743 8192000000 10884693472 11306459136 1950037232 19.227 100 63 126 0 1977540832 9109136 18394464
17:31:50 4190 8192000000 10900633328 11318489088 1958456544 19.294 100 65 129 0 1989313264 10645056 20211664
17:32:06 25890 8192000000 10892837328 11319599104 1957015120 19.282 100 54 108 0 1984147440 12169952 14962368
17:32:42 5422 8192000000 10892748800 11325460480 1943471984 19.174 99 46 90 0 1970485776 13929552 13084240
17:32:59 9895 8192000000 10905572608 11334909952 1964402032 19.341 100 45 90 2 1991463968 14089568 12972368
17:33:17 11281 8192000000 10897046032 11316502528 1930497264 19.071 98 60 116 1 1962834176 14927424 17409488
17:33:37 8065 8192000000 10906570704 11332968448 1963172976 19.331 100 61 122 1 1997445632 16558160 17714496
17:33:53 14590 8192000000 10921159760 11339399168 1969860960 19.384 100 58 116 1 2001214048 14786512 16566576
17:34:15 9230 8192000000 10926458400 11346939904 1975244560 19.427 100 70 139 0 2011439104 15536608 20657936
17:34:31 9665 8192000000 10927657424 11350867968 1980632704 19.470 100 69 137 1 2016833744 16790064 19410976
17:34:51 6151 8192000000 10935730464 11353681920 1986518704 19.516 100 75 150 1 2025766560 16770512 22477344
17:35:05 10679 8192000000 10925994272 11355078656 1984093456 19.497 100 59 118 1 2016832176 16173456 16565264
17:35:29 15578 8192000000 10907158592 11340587008 1971285312 19.396 100 48 97 1 2000075552 15112128 13678112
17:36:01 6157 8192000000 10932596800 11356008448 1983790576 19.495 100 54 108 2 2015832448 16047840 15994032
17:36:14 2755 8192000000 10915258688 11335647232 1966971408 19.361 99 65 127 0 2000738080 14474736 19291936
17:36:24 8811 8192000000 10928089488 11361480704 1986830960 19.519 100 57 113 1 2019576768 15767952 16977856
17:36:46 4794 8192000000 10916986240 11348480000 1976783312 19.439 100 59 116 1 2009768656 15819552 17165792
17:37:00 6850 8192000000 10931953728 11358420992 1989281344 19.538 100 63 125 2 2022386592 15165472 17939776
17:37:16 3309 8192000000 10945076704 11362656256 1987784336 19.526 100 75 151 2 2028282672 19457152 21041184
17:37:26 11655 8192000000 10922044688 11352473600 1966655056 19.359 99 61 122 0 2004006048 19580448 17770544
17:37:48 5418 8192000000 10920819168 11350183936 1976846928 19.440 100 65 128 3 2013026064 17502928 18676208
17:38:05 7244 8192000000 10922364912 11349549056 1974156048 19.418 100 63 124 1 2009578720 17388592 18034080
17:38:22 2972 8192000000 10931421728 11356884992 1983713248 19.494 100 57 114 1 2020258784 19116736 17428800
17:38:32 2172 8192000000 10952180192 11363106816 1993358592 19.570 100 79 158 1 2036593424 18488208 24746624
17:38:43 3576 8192000000 10921631392 11343511552 1958897872 19.297 99 64 128 1 1998844256 20211280 19735104
17:38:53 2835 8192000000 10939762480 11361058816 1985011712 19.504 100 79 157 3 2029672720 19583232 25077776
17:39:03 7364 8192000000 10934752112 11365003264 1987530144 19.524 100 61 120 0 2026959200 21039248 18389808
17:39:17 2273 8192000000 10960602656 11373154304 1996126784 19.592 100 76 151 0 2039130368 19956496 23047088
17:39:26 5429 8192000000 10928186112 11352891392 1975202896 19.427 99 68 137 1 2018542240 22733104 20606240
17:39:39 3907 8192000000 10931391920 11344637952 1977187408 19.442 100 87 171 2 2022758864 17980928 27590528
17:39:50 2880 8192000000 10936267024 11354021888 1977764480 19.447 100 81 162 1 2022298928 19587600 24946848
17:40:01 2884 8192000000 10951787328 11363602432 1989126064 19.537 100 79 156 0 2030836320 19088544 22621712
17:40:10 3492 8192000000 10933088144 11359129600 1984829728 19.503 100 72 140 1 2024437680 18403696 21204256
17:40:21 2938 8192000000 10931802032 11353411584 1977933856 19.448 100 64 127 1 2015457456 18462608 19060992
17:40:34 4065 8192000000 10935835632 11350183936 1975376208 19.428 100 75 148 1 2017044112 19291456 22376448
17:40:44 6624 8192000000 10915800672 11343196160 1953202688 19.252 99 69 138 0 1993582768 20180768 20199312
17:41:00 4726 8192000000 10906972608 11317039104 1938930928 19.138 99 74 145 1 1981550048 20601280 22017840
17:41:13 3232 8192000000 10915333040 11336003584 1956724160 19.280 100 68 135 0 2000463200 22031472 21707568
17:41:23 3077 8192000000 10899012112 11311046656 1929960016 19.067 99 86 172 2 1979573264 23361008 26252240
17:41:39 6094 8192000000 10905222752 11316920320 1929304176 19.061 99 68 135 1 1973245840 23290352 20651312
17:41:53 3634 8192000000 10915778544 11317391360 1942818752 19.169 100 78 153 1 1991109360 24775136 23515472
17:42:03 1461 8192000000 10923595808 11329081344 1941375664 19.158 99 89 179 2 1992386864 23661216 27349984
17:42:12 8870 8192000000 10842867664 11238318080 1866185184 18.553 97 82 163 2 1912583664 22688880 23709600
17:42:28 2497 8192000000 10879633040 11287793664 1911587360 18.919 100 68 137 1 1953837520 22137760 20112400
17:42:39 11082 8192000000 10886558720 11305320448 1926652496 19.040 100 68 135 2 1970208592 22954992 20601104
17:43:01 1771 8192000000 10889378592 11304607744 1923658464 19.016 99 64 127 3 1962271408 19723488 18889456
17:43:11 1106 8192000000 10894650032 11294547968 1913028800 18.931 98 96 195 2 1962269152 20696768 28543584
17:43:20 4439 8192000000 10900942240 11315601408 1940692880 19.152 100 67 134 0 1982699808 21683616 20323312
17:43:34 2997 8192000000 10893154272 11304308736 1920542736 18.991 99 69 137 0 1964600272 22485456 21572080
17:43:46 5262 8192000000 10886696688 11301064704 1924935680 19.026 99 64 128 1 1965712288 20824992 19951616
17:44:00 2883 8192000000 10917759440 11325943808 1948756432 19.217 100 84 166 0 1996587520 22067952 25763136
17:44:09 3763 8192000000 10921451040 11333492736 1954353168 19.261 100 75 150 0 2000705920 23059088 23293664
17:44:19 3358 8192000000 10925063680 11332464640 1954698016 19.264 100 73 145 1 2000814288 24004080 22112192
17:44:32 5624 8192000000 10913008656 11326083072 1948586000 19.215 100 75 148 0 1996724848 25094624 23044224
17:44:54 4538 8192000000 10914115904 11330539520 1953504720 19.254 100 68 136 1 2001164256 26548112 21111424
17:45:07 3992 8192000000 10925853776 11335409664 1943725568 19.176 99 70 141 3 1991948608 25901232 22321808
17:45:19 5303 8192000000 10938961664 11355463680 1968225888 19.371 100 73 144 1 2018869376 27677840 22965648
17:45:31 2038 8192000000 10935589648 11346714624 1964061632 19.338 100 86 169 1 2019237312 29201616 25974064
17:45:40 1971 8192000000 10927986240 11336171520 1953491088 19.254 100 87 172 2 2009585936 28506032 27588816
17:45:49 3807 8192000000 10935593376 11340197888 1959846704 19.305 100 74 144 4 2008535536 26745728 21943104
17:45:59 4076 8192000000 10939649792 11350032384 1966736848 19.360 100 78 154 0 2019618128 27885584 24995696
17:46:14 3668 8192000000 10930151904 11341672448 1956949936 19.282 100 77 154 2 2009286192 28408944 23927312
17:46:24 1969 8192000000 10931689440 11347165184 1964282256 19.340 100 77 153 2 2016762336 28255312 24224768
17:46:35 3582 8192000000 10928120560 11348520960 1967849984 19.368 100 62 121 1 2013509040 26599616 19059440
17:46:46 3168 8192000000 10927783296 11333775360 1955251696 19.268 99 82 161 2 2009746336 29096720 25397920
17:46:56 3060 8192000000 10953840992 11363463168 1977902112 19.448 100 81 158 1 2032326784 29856784 24567888
17:47:07 4578 8192000000 10936094144 11354308608 1958004656 19.290 99 80 161 2 2012460864 29788320 24667888
17:47:20 1789 8192000000 10969561168 11372834816 1980637616 19.470 100 88 175 1 2039034432 31166704 27230112
17:47:31 4189 8192000000 10957052304 11368599552 1980454016 19.468 100 78 156 2 2036793968 32646624 23693328
17:47:43 6157 8192000000 10944152928 11364769792 1977733568 19.447 100 74 147 1 2033509632 32909984 22866080
17:47:58 6414 8192000000 10959216896 11368570880 1977836016 19.448 100 82 161 0 2036939792 33978912 25124864
17:48:14 1222 8192000000 10977097088 11382423552 1986976752 19.520 100 86 173 2 2050792912 36025552 27790608
17:48:23 4564 8192000000 10983232128 11391881216 1993379920 19.570 100 91 183 1 2061263088 38164464 29718704
17:48:35 1371 8192000000 10969540816 11388694528 1990674400 19.549 100 74 145 1 2051684256 37455072 23554784
17:48:46 2818 8192000000 10978069936 11393093632 1996122432 19.592 100 83 167 3 2062022144 39230448 26669264
17:48:56 3732 8192000000 10964276928 11385143296 1995239616 19.585 100 70 141 2 2050878656 33042976 22596064
17:49:08 2742 8192000000 10969614896 11393351680 1997707600 19.605 100 73 142 2 2052548912 32215632 22625680
17:49:19 6693 8192000000 10979163264 11399270400 2005369168 19.665 100 78 156 0 2064585968 34009232 25207568
17:49:33 1862 8192000000 10994682576 11408195584 2010317312 19.704 100 93 186 3 2075119824 35944656 28857856
17:49:42 6900 8192000000 10992498800 11412054016 2009642800 19.699 100 75 150 1 2072086016 38265424 24177792
17:49:58 1572 8192000000 11006551392 11421528064 2020002000 19.780 100 85 170 0 2087723904 39992448 27729456
17:50:07 3536 8192000000 11003608096 11419074560 2013522384 19.729 100 80 159 0 2080806416 41602128 25681904
17:50:20 3348 8192000000 11012198784 11427127296 2023832448 19.810 100 92 182 1 2094071104 41427968 28810688
17:50:30 3836 8192000000 11009736224 11425263616 2018697552 19.770 100 82 162 1 2085698736 41230320 25770864
17:50:41 1058 8192000000 11017761152 11431055360 2024439024 19.815 100 93 185 0 2092679344 38896224 29344096
17:50:53 5231 8192000000 10991387216 11420348416 2017709536 19.762 100 67 134 1 2071769984 33110944 20949504
17:51:06 11871 8192000000 10982958992 11416596480 2014918576 19.740 100 60 120 1 2066094336 31560176 19615584
17:51:25 5680 8192000000 10993756752 11425898496 2018105664 19.765 100 61 120 1 2073860096 34682496 21071936
17:51:41 2658 8192000000 10985198000 11405283328 1994015920 19.576 99 84 168 1 2058108944 36261888 27831136
17:51:53 5370 8192000000 10982274752 11412590592 2002363840 19.641 100 64 128 0 2063703888 40270096 21069952
17:52:09 6254 8192000000 11002633264 11420790784 2012078912 19.718 100 77 154 0 2078514128 41821904 24613312
17:52:27 12512 8192000000 10973188192 11416567808 2010880496 19.708 100 51 102 2 2063414592 35765824 16768272
17:52:50 21479 8192000000 10977005712 11415306240 2008282192 19.688 100 56 110 1 2060381600 34034320 18065088
17:53:21 2023 8192000000 11003837392 11421999104 2016220720 19.750 100 77 153 2 2078195888 37024048 24951120
17:53:30 4293 8192000000 10995259040 11421442048 2015807120 19.747 100 68 134 1 2076416448 39081872 21527456
17:53:51 8560 8192000000 10978961968 11429834752 2013941600 19.733 100 46 91 0 2067752112 37477312 16333200
17:54:17 11377 8192000000 10980387872 11428663296 2012131152 19.718 100 48 96 2 2066035088 37883280 16020656
17:54:42 12721 8192000000 10983043312 11435319296 2008849840 19.692 100 34 68 1 2059948496 39479216 11619440
17:55:03 16608 8192000000 10961154112 11407773696 1995883072 19.590 100 36 72 0 2053520288 45457296 12179920
17:55:40 8885 8192000000 10949062848 11408924672 1968622272 19.375 99 33 66 1 2024750320 45260224 10867824
17:56:12 19210 8192000000 10930852400 11413721088 1972729280 19.407 100 28 56 1 2029723168 46997328 9996560
17:56:40 21101 8192000000 10936653968 11419709440 1974796528 19.423 100 17 34 1 2019705440 38551792 6357120
17:57:45 39613 8192000000 10924650944 11390779392 1944269952 19.181 99 13 26 0 1993368496 44753776 4344768
17:58:31 88667 8192000000 10882962272 11339980800 1888618912 18.735 96 4 8 0 1907714400 18091024 1004464
18:00:11 98104 8192000000 10881190208 11331379200 1843860448 18.372 93 23 46 0 1856246752 6691248 5695056
18:01:56 9773 8192000000 10897367776 11334340608 1949057104 19.219 100 54 107 2 1971479200 7363440 15058656
18:02:13 20170 8192000000 10909284448 11345018880 1955684864 19.272 100 46 90 2 1979028720 10659232 12684624
18:03:13 107091 8192000000 10920014848 11372388352 1966793744 19.360 100 16 31 1 1983042272 11316112 4932416
18:05:13 55850 8192000000 10912748128 11376205824 1980639184 19.470 100 17 34 1 1995398624 10318528 4440912
18:06:22 66312 8192000000 10912829008 11359309824 1951591728 19.239 98 25 50 4 1967572960 8870592 7110640
18:07:35 84897 8192000000 10922578848 11387318272 1985635440 19.509 100 38 74 3 2006885408 10140448 11109520
18:09:09 12045 8192000000 10950629264 11396145152 1996972560 19.599 100 56 112 2 2023988496 11320400 15695536
18:09:31 25937 8192000000 10944680256 11398074368 2000328224 19.625 100 53 106 0 2028568112 13674272 14565616
18:10:14 53128 8192000000 10918049904 11376783360 1980645312 19.470 99 35 69 1 2003164576 12621024 9898240
18:12:44 52361 8192000000 10938860752 11406696448 2004417872 19.658 100 18 35 0 2022588992 13271504 4899616
18:13:45 25148 8192000000 10952167824 11415179264 2014484640 19.737 100 26 52 1 2036996624 14362896 8149088
18:14:21 36111 8192000000 10940680352 11412836352 1989716320 19.542 99 29 58 0 2016324096 16516192 10091584
18:15:13 53623 8192000000 10939107472 11416104960 1985376544 19.507 99 19 38 0 2010141232 18747344 6017344
18:16:14 44086 8192000000 10916434016 11404677120 1989670784 19.541 100 8 16 1 2010192592 18138592 2383216
18:17:09 31496 8192000000 10902893408 11376443392 1957987344 19.290 98 21 42 0 1978013488 14076704 5949440
18:17:58 38309 8192000000 10906398160 11388243968 1965075712 19.346 99 12 24 1 1985664416 16788928 3799776
18:18:44 18630 8192000000 10899019520 11371663360 1940557648 19.151 98 7 14 0 1962565568 19856288 2151632
18:19:11 55963 8192000000 10893862288 11375042560 1951422992 19.238 99 11 22 0 1970861264 16280784 3157488
18:20:26 96042 8192000000 10912053888 11400613888 1988162368 19.529 100 7 14 0 2004453120 14281920 2008832
18:22:22 55974 8192000000 10897598768 11365154816 1910526384 18.911 96 30 60 2 1928852752 9432880 8893488
18:23:30 61565 8192000000 10869938176 11353825280 1861487008 18.515 95 16 32 1 1878789136 12440784 4861344
18:24:43 53517 8192000000 10881721504 11347976192 1903235904 18.852 97 23 46 1 1918810528 8992544 6582080
18:25:43 56713 8192000000 10869807776 11332976640 1863822784 18.534 95 28 57 0 1884418416 12451536 8144096
18:26:53 88806 8192000000 10858979440 11344363520 1869133136 18.577 96 7 14 0 1888574560 17595824 1845600
18:28:29 110714 8192000000 10836485952 11294769152 1762582160 17.706 91 15 30 2 1778674944 12321200 3771584
18:30:26 177212 8192000000 10862952928 11335815168 1845073696 18.382 96 12 24 0 1864242384 16119040 3049648
18:33:30 36603 8192000000 10840060960 11302801408 1857222112 18.481 96 11 22 0 1871551776 11310464 3019200
18:34:21 75318 8192000000 10824607264 11284709376 1859540336 18.500 97 26 52 1 1882668976 15790224 7338416
18:36:13 57950 8192000000 10833091312 11299753984 1878671840 18.654 98 18 36 0 1889513632 5881104 4960688
18:37:19 76555 8192000000 10845669312 11312308224 1887395680 18.725 98 28 56 2 1907951104 12783264 7772160
18:38:42 9059 8192000000 10838355728 11300126720 1892539456 18.766 99 20 40 1 1912055792 13890560 5625776
18:38:58 21679 8192000000 10827806560 11301244928 1903379360 18.853 100 19 38 0 1920847392 11954384 5513648
18:39:26 25654 8192000000 10824546672 11298893824 1897898496 18.809 99 29 57 0 1917185088 11036448 8250144
18:39:58 74052 8192000000 10850081840 11337093120 1928361328 19.054 100 17 34 1 1942784016 9791392 4631296
18:41:19 77703 8192000000 10872460752 11346722816 1917171472 18.964 99 14 28 0 1935057552 13366304 4519776
18:42:44 57436 8192000000 10860047616 11335946240 1915271744 18.949 98 16 31 1 1932042688 12293792 4477152
18:43:47 43614 8192000000 10857803792 11328073728 1926554976 19.039 99 18 36 0 1942954704 11354576 5045152
18:44:47 79272 8192000000 10882069936 11364712448 1950928192 19.234 100 11 22 1 1969469216 14989056 3551968
18:46:26 68011 8192000000 10892737088 11375116288 1949742000 19.224 99 18 36 3 1973325360 17895632 5687728
18:47:40 52296 8192000000 10871505456 11350171648 1879193664 18.659 96 7 14 1 1893237920 12150848 1893408
18:49:13 87759 8192000000 10911095760 11375943680 1950812720 19.233 99 28 57 2 1968587376 10126720 7647936
18:51:19 64200 8192000000 10885114048 11352436736 1915909008 18.954 98 21 42 0 1931819488 10432304 5478176
18:52:34 52516 8192000000 10886759376 11363086336 1938000816 19.131 99 21 43 1 1960662176 17318864 5342496
18:53:33 32224 8192000000 10897855328 11364732928 1963425584 19.333 100 35 69 2 1987380272 14300128 9654560
18:54:13 23366 8192000000 10886079760 11347230720 1903087792 18.851 97 25 50 0 1919007984 9246032 6674160
18:54:43 16066 8192000000 10908933056 11359358976 1939529168 19.143 99 32 64 1 1958937888 10282064 9126656
18:55:10 50170 8192000000 10890177760 11379273728 1960320000 19.309 100 32 64 1 1985455232 15969200 9166032
18:56:06 31471 8192000000 10922286752 11378905088 1966769440 19.360 100 25 50 0 1989757968 15716992 7271536
18:56:44 78091 8192000000 10895726064 11367923712 1933721616 19.097 98 32 64 0 1961269088 18825264 8722208
18:58:17 182108 8192000000 10913651200 11390824448 1959177728 19.300 99 18 36 0 1978601376 14995056 4428592
19:01:25 50383 8192000000 10906695984 11390402560 1978404128 19.452 100 11 22 1 1995672336 14748896 2519312
19:02:46 49877 8192000000 10889309744 11374628864 1943297248 19.173 98 10 20 1 1958510976 12434768 2778960
19:03:43 53491 8192000000 10893671904 11373420544 1933681872 19.096 98 13 26 0 1955092320 18086608 3323840
19:04:46 68165 8192000000 10880085680 11358973952 1932434448 19.086 98 8 16 0 1944822880 10126704 2261728
19:06:00 76698 8192000000 10867706768 11354316800 1869666880 18.582 95 11 23 0 1893511840 21006704 2838256
19:07:23 36722 8192000000 10881953472 11339571200 1905837632 18.873 98 33 67 2 1927930272 12649824 9442816
19:08:09 16697 8192000000 10901324320 11361742848 1954692704 19.264 100 42 81 0 1973169408 7824096 10652608
19:08:41 65284 8192000000 10911678720 11389997056 1975575104 19.430 100 20 40 2 1991246768 10055808 5615856
19:09:59 58006 8192000000 10909537520 11377016832 1956497024 19.278 99 13 26 1 1975634368 15478400 3658944
19:11:07 21467 8192000000 10920026432 11381841920 1958454240 19.294 99 39 80 2 1982253968 13088128 10711600
19:11:40 36140 8192000000 10903328832 11367583744 1929385568 19.062 98 18 36 0 1943652576 9136704 5130304
19:12:22 51627 8192000000 10875932272 11337818112 1844260400 18.375 94 25 50 1 1860850240 9448576 7141264
19:13:20 113260 8192000000 10859554064 11332378624 1823892864 18.209 94 7 14 0 1846289504 20920368 1476272
19:15:43 46004 8192000000 10862904736 11329474560 1872593440 18.605 97 19 38 0 1890009232 12255056 5160736
19:16:40 90962 8192000000 10866548704 11344482304 1893092576 18.771 98 12 24 0 1910793248 14496608 3204064
19:18:28 74747 8192000000 10858864272 11325763584 1861797696 18.518 96 17 34 1 1874578256 8281984 4498576
19:20:21 99520 8192000000 10845153216 11316776960 1845152944 18.383 95 32 63 1 1864289776 10178848 8957984
19:22:11 19822 8192000000 10850399728 11320524800 1916533088 18.959 100 33 65 1 1939893344 14072736 9287520
19:22:40 32534 8192000000 10832758944 11324002304 1904078080 18.859 99 5 10 1 1917590512 11919952 1592480
19:23:19 6746 8192000000 10831244768 11320397824 1898881360 18.817 99 4 8 0 1912641600 12880768 879472
19:23:32 37321 8192000000 10829743312 11298304000 1890253952 18.748 99 5 10 0 1901147408 9702880 1190576
19:24:18 44584 8192000000 10833575920 11312795648 1880305312 18.668 98 11 22 0 1892958032 9383728 3268992
19:25:09 117064 8192000000 10846324512 11319230464 1887134960 18.723 98 10 20 0 1899718336 9653312 2930064

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:34, from 31-12-2020 19:29:36 to 31-12-2020 19:30:10.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 117 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 31-12-2020 19:30:11 to 31-12-2020 19:30:13.

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          247010
MON$OLDEST_ACTIVE               248152
MON$OLDEST_SNAPSHOT             248152
MON$NEXT_TRANSACTION            248152
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                       2062176
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:167: 
:168: mscs-test-161.budzdorov.ru    Thu Dec 31 19:27:20 2020
:169:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:170: 
:171: 
:172: mscs-test-161.budzdorov.ru    Thu Dec 31 19:27:20 2020
:173:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:174: 
:175: 
:176: mscs-test-161.budzdorov.ru    Thu Dec 31 19:27:48 2020
:177:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:178: 
--- end of diff output ---

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

31.12.20 19:30:14. 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-31 19:30:16 No severe PSQL-related problems occured
31.12.20 19:30:18. End of report.