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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17483040 kB
MemAvailable 31466720 kB
Buffers 0 kB
Cached 14241584 kB
SwapCached 2856 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-13 01:26:59
DTS_END                         2020-11-13 01:26:59.2710
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/51690
TRN_ID                          241211
ATT_ID                          643
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: 9081.21 23245 1089745
customer order: creation 171.77 380 20612
customer order: refuse 14.79 380 1775
order to supplier: creation 46.77 1291 5612
order to supplier: removal 3.34 99409 401
invoice (draft): creation 46.72 3689 5606
invoice (draft): removal 50.79 724 6095
invoice accept: apply 42.04 19759 5045
invoice accept: cancel 45.61 796 5473
customer reserve: creation 3887.68 195 466522
customer reserve: removal 4470.11 58 536413
realization accept: apply 85.17 186 10220
realization accept: cancel 86.98 114 10437
payment from customer: creation 58.77 124 7052
payment from customer: removal 5.79 116 695
payment to supplier: creation 48.36 147 5803
payment to supplier: removal 3.65 95 438
service: total inventory turnovers 5.02 1145 602
service: total monetary turnovers 6.90 69 828
service: aggregate perf. data 0.93 17167 112
service: refresh index statistics 0.03 319056 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-11-2020 01:28:51 to 13-11-2020 01:28:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3064
TEST_TIME 2 3116
TEST_TIME 3 3127
TEST_TIME 4 3999
TEST_TIME 5 4448
TEST_TIME 6 5149
TEST_TIME 7 5611
TEST_TIME 8 5910
TEST_TIME 9 6398
TEST_TIME 10 6337
TEST_TIME 11 6443
TEST_TIME 12 6810
TEST_TIME 13 7177
TEST_TIME 14 7337
TEST_TIME 15 7403
TEST_TIME 16 7716
TEST_TIME 17 8150
TEST_TIME 18 8294
TEST_TIME 19 8434
TEST_TIME 20 8637
TEST_TIME 21 8725
TEST_TIME 22 8934
TEST_TIME 23 9024
TEST_TIME 24 9037
TEST_TIME 25 9307
TEST_TIME 26 9728
TEST_TIME 27 9886
TEST_TIME 28 10308
TEST_TIME 29 10454
TEST_TIME 30 10640
TEST_TIME 31 10533
TEST_TIME 32 10455
TEST_TIME 33 10377
TEST_TIME 34 10215
TEST_TIME 35 10237
TEST_TIME 36 10111
TEST_TIME 37 9945
TEST_TIME 38 10039
TEST_TIME 39 9802
TEST_TIME 40 9695
TEST_TIME 41 9734
TEST_TIME 42 9740
TEST_TIME 43 9646
TEST_TIME 44 9503
TEST_TIME 45 9371
TEST_TIME 46 9355
TEST_TIME 47 9272
TEST_TIME 48 9464
TEST_TIME 49 9476
TEST_TIME 50 9328
TEST_TIME 51 9242
TEST_TIME 52 9317
TEST_TIME 53 9199
TEST_TIME 54 9204
TEST_TIME 55 9180
TEST_TIME 56 9124
TEST_TIME 57 9056
TEST_TIME 58 9124
TEST_TIME 59 9110
TEST_TIME 60 9051
TEST_TIME 61 9123
TEST_TIME 62 9180
TEST_TIME 63 9209
TEST_TIME 64 9242
TEST_TIME 65 9280
TEST_TIME 66 9293
TEST_TIME 67 9311
TEST_TIME 68 9344
TEST_TIME 69 9356
TEST_TIME 70 9344
TEST_TIME 71 9400
TEST_TIME 72 9430
TEST_TIME 73 9335
TEST_TIME 74 9273
TEST_TIME 75 9293
TEST_TIME 76 9233
TEST_TIME 77 9230
TEST_TIME 78 9184
TEST_TIME 79 9139
TEST_TIME 80 9178
TEST_TIME 81 9090
TEST_TIME 82 9043
TEST_TIME 83 8978
TEST_TIME 84 9113
TEST_TIME 85 9091
TEST_TIME 86 9048
TEST_TIME 87 9190
TEST_TIME 88 9134
TEST_TIME 89 9178
TEST_TIME 90 9199
TEST_TIME 91 9196
TEST_TIME 92 9272
TEST_TIME 93 9234
TEST_TIME 94 9239
TEST_TIME 95 9278
TEST_TIME 96 9254
TEST_TIME 97 9205
TEST_TIME 98 9212
TEST_TIME 99 9149
TEST_TIME 100 9161
TEST_TIME 101 9135
TEST_TIME 102 9104
TEST_TIME 103 9068
TEST_TIME 104 9001
TEST_TIME 105 9031
TEST_TIME 106 8997
TEST_TIME 107 8999
TEST_TIME 108 9030
TEST_TIME 109 9012
TEST_TIME 110 9034
TEST_TIME 111 9053
TEST_TIME 112 9107
TEST_TIME 113 9105
TEST_TIME 114 9119
TEST_TIME 115 9105
TEST_TIME 116 9137
TEST_TIME 117 9124
TEST_TIME 118 9131
TEST_TIME 119 9137
TEST_TIME 120 9090
TEST_TIME 121 9015

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 13-11-2020 01:28:54 to 13-11-2020 01:28:58.

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 1520951 1520951 0 0.00 0 15049 7 0 0
doc_list_biud 1520943 1520943 0 0.00 0 20465 26 0 0
sp_add_invoice_to_stock 5133 5045 88 1.71 44 202657 19760 0 88
sp_cancel_adding_invoice 5473 5473 0 0.00 5 55101 797 0 0
sp_cancel_client_order 1775 1775 0 0.00 5 13454 380 0 0
sp_cancel_customer_reserve 536413 536413 0 0.00 1 20478 59 0 0
sp_cancel_pay_from_customer 695 695 0 0.00 3 7326 116 0 0
sp_cancel_pay_to_supplier 438 438 0 0.00 3 7331 95 0 0
sp_cancel_supplier_invoice 6103 6095 8 0.13 1 17847 725 0 8
sp_cancel_supplier_order 401 401 0 0.00 11 906311 99410 0 0
sp_cancel_write_off 10437 10437 0 0.00 1 18971 115 0 0
sp_client_order 20612 20612 0 0.00 3 21855 380 0 0
sp_customer_reserve 466522 466522 0 0.00 0 157260 195 0 0
sp_fill_shopping_cart 31825 31825 0 0.00 1 34848 51 0 0
sp_fill_shopping_cart_clo_res 466506 466506 0 0.00 0 16176 14 0 0
sp_get_clo_for_invoice 5025 5025 0 0.00 0 39975 339 0 0
sp_kill_cost_storno 17043 17043 0 0.00 0 14197 59 0 0
sp_kill_qstorno_ret_qs2qd 1089759 1089759 0 0.00 0 20290 31 0 0
sp_kill_qty_storno 575837 575837 0 0.00 0 20464 68 0 0
sp_lock_selected_doc 21055 21055 0 0.00 0 8919 7 0 0
sp_make_cost_storno 28100 28100 0 0.00 0 15032 60 0 0
sp_multiply_rows_for_pdistr 28099 28099 0 0.00 0 14850 34 0 0
sp_multiply_rows_for_qdistr 20612 20612 0 0.00 0 21841 189 0 0
sp_pay_from_customer 7052 7052 0 0.00 4 15045 125 0 0
sp_pay_to_supplier 5803 5803 0 0.00 4 14859 147 0 0
sp_payment_common 12854 12854 0 0.00 1 15038 34 0 0
sp_qd_handle_on_cancel_clo 1775 1775 0 0.00 0 13445 348 0 0
sp_qd_handle_on_invoice_upd_sts 10496 10496 0 0.00 0 13739 333 0 0
sp_qd_handle_on_reserve_upd_sts 10220 10220 0 0.00 0 14378 53 0 0
sp_reserve_write_off 10220 10220 0 0.00 6 15774 186 0 0
sp_supplier_invoice 5606 5606 0 0.00 5 114392 3689 0 0
sp_supplier_order 5612 5612 0 0.00 5 30545 1291 0 0
srv_aggregate_perf_data 112 112 0 0.00 2747 254484 17167 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 892 218755 31659 0 0
srv_find_qd_qs_mism 1041405 1041405 0 0.00 0 11144 6 0 0
srv_make_invnt_saldo 602 602 0 0.00 34 85041 1145 0 0
srv_make_money_saldo 828 828 0 0.00 1 32269 70 0 0
srv_recalc_idx_stat 4 4 0 0.00 222115 438598 319056 0 0
t$perf-abend:sp_add_invoice_to_stock 88 88 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5046 5046 0 0.00 0 27456 180 0 0
t$perf-norm:sp_cancel_adding_invoice 411 411 0 0.00 0 2650 66 0 0
t$perf-norm:sp_cancel_client_order 1775 1775 0 0.00 0 4535 23 0 0
t$perf-norm:sp_cancel_customer_reserve 691 691 0 0.00 0 5660 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 695 695 0 0.00 0 469 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 438 438 0 0.00 0 1121 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 597 12 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 33649 1806 0 0
t$perf-norm:sp_cancel_write_off 1004 1004 0 0.00 0 4520 19 0 0
t$perf-norm:sp_client_order 20612 20612 0 0.00 0 16890 23 0 0
t$perf-norm:sp_customer_reserve 946 946 0 0.00 0 14886 32 0 0
t$perf-norm:sp_pay_from_customer 7052 7052 0 0.00 0 10522 15 0 0
t$perf-norm:sp_pay_to_supplier 5803 5803 0 0.00 0 16980 15 0 0
t$perf-norm:sp_reserve_write_off 10220 10220 0 0.00 0 8446 13 0 0
t$perf-norm:sp_supplier_invoice 5607 5607 0 0.00 0 12986 20 0 0
t$perf-norm:sp_supplier_order 5612 5612 0 0.00 0 7844 18 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 315 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 1967 20 0 0
t$perf-norm:srv_make_invnt_saldo 602 602 0 0.00 0 1880 30 0 0
t$perf-norm:srv_make_money_saldo 828 828 0 0.00 0 1637 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 604 152 0 0
v_add_invoice_to_stock 10222 10046 176 1.72 0 7532 20 0 176
v_all_customers 37500 37500 0 0.00 0 21 1 0 0
v_all_suppliers 30746 30746 0 0.00 0 23 1 0 0
v_all_wares 41224 41224 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 822 822 0 0.00 0 5291 13 0 0
v_cancel_client_order 3550 3550 0 0.00 0 6438 10 0 0
v_cancel_customer_prepayment 1390 1390 0 0.00 0 4275 13 0 0
v_cancel_customer_reserve 1382 1382 0 0.00 0 2225 5 0 0
v_cancel_payment_to_supplier 876 876 0 0.00 0 1848 6 0 0
v_cancel_supplier_invoice 810 794 16 1.97 0 2413 21 0 16
v_cancel_supplier_order 802 802 0 0.00 0 1955 11 0 0
v_cancel_write_off 2008 2008 0 0.00 0 5819 24 0 0
v_max_id_clo_ord 5611 5611 0 0.00 0 4436 5 0 0
v_max_id_clo_res 946 946 0 0.00 0 3277 13 0 0
v_max_id_ord_sup 5602 5602 0 0.00 0 4452 5 0 0
v_max_non_paid_invoice 1642 1642 0 0.00 0 2602 5 0 0
v_max_non_paid_realizn 3846 3846 0 0.00 0 2932 6 0 0
v_min_id_clo_ord 5611 5611 0 0.00 0 11575 20 0 0
v_min_id_clo_res 946 946 0 0.00 0 2670 7 0 0
v_min_id_ord_sup 5602 5602 0 0.00 0 7763 13 0 0
v_min_non_paid_invoice 5802 5802 0 0.00 0 10174 23 0 0
v_min_non_paid_realizn 7052 7052 0 0.00 0 7950 19 0 0
v_our_firm 10136 10136 0 0.00 0 18 1 0 0
v_reserve_write_off 20440 20440 0 0.00 0 5942 7 0 0
x_lock_depdocs_on_canc_invoice 11171 11171 0 0.00 0 16325 124 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 7737 430 0 0
x_make_qstorno_1000_1200 5612 5612 0 0.00 1 30511 1177 0 0
x_make_qstorno_1200_2000 5606 5606 0 0.00 2 114167 3510 0 0
x_make_qstorno_2100_3300 466522 466522 0 0.00 0 157236 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-11-2020 01:28:59 to 13-11-2020 01:29:03.

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
22:57:03 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:09 6580 8192000000 10101055360 10385985536 750625520 8.393 61 44 92 0 768681168 2228048 15827600
22:57:23 28923 8192000000 10333927904 10650177536 1355304224 14.195 100 85 170 0 1387150256 4036656 27809376
22:58:06 13896 8192000000 10355227008 10675359744 1415630720 14.734 100 86 173 0 1449566960 5853152 28083088
22:58:29 29710 8192000000 10396370352 10720256000 1450086960 15.039 100 92 184 0 1486957536 6903088 29967488
22:59:08 23241 8192000000 10416454848 10745745408 1469586512 15.210 100 87 174 1 1506026512 7815840 28624160
22:59:42 24796 8192000000 10440129184 10771144704 1494796144 15.431 100 94 189 0 1533530544 8573312 30161088
23:00:26 15921 8192000000 10448137792 10786586624 1502227392 15.496 100 87 174 0 1539520816 9633392 27660032
23:00:54 20765 8192000000 10481547232 10824744960 1536429312 15.793 100 83 165 2 1572823264 10155520 26238432
23:01:24 16619 8192000000 10513286928 10862317568 1568272992 16.067 100 79 158 0 1602093632 9972224 23848416
23:01:51 15195 8192000000 10538972976 10892034048 1597800320 16.321 100 87 174 0 1635995408 11299200 26895888
23:02:20 13081 8192000000 10567954736 10926202880 1621891424 16.526 100 75 151 1 1655706368 11204752 22610192
23:02:43 14846 8192000000 10589205024 10954178560 1650035760 16.765 100 79 158 1 1685200928 11719872 23445296
23:03:06 12047 8192000000 10615015312 10980777984 1670012608 16.933 100 80 158 1 1706216096 12459024 23744464
23:03:30 5677 8192000000 10628420528 11000020992 1695592048 17.148 100 76 151 1 1729080224 12134512 21353664
23:03:44 7780 8192000000 10647184576 11017424896 1706897856 17.243 100 75 149 3 1740469360 12095920 21475584
23:04:00 7050 8192000000 10658293632 11038396416 1723669472 17.383 100 72 144 1 1757338496 12336912 21332112
23:04:16 5993 8192000000 10679902288 11055771648 1745191856 17.562 100 82 164 0 1781123728 12559040 23372832
23:04:30 4835 8192000000 10686603248 11066904576 1751437328 17.614 100 77 154 1 1786092928 12895296 21760304
23:04:42 4697 8192000000 10695706032 11075989504 1760615008 17.689 100 75 150 1 1794457264 12633488 21208768
23:04:55 5083 8192000000 10703673696 11086757888 1771176704 17.777 100 79 159 0 1806549456 13086960 22285792
23:05:07 6582 8192000000 10718243216 11102298112 1780542624 17.854 100 78 156 2 1815528128 13152208 21833296
23:05:22 3254 8192000000 10731268096 11112910848 1793835936 17.963 100 91 178 1 1831677520 13060224 24781360
23:05:32 10000 8192000000 10731440064 11115376640 1796392192 17.984 100 75 150 0 1831125008 14393568 20339248
23:05:50 3446 8192000000 10750136048 11136688128 1800919328 18.021 100 86 172 2 1840244928 15433616 23891984
23:06:00 2973 8192000000 10752607328 11140280320 1817839600 18.160 100 77 154 3 1853138208 13313472 21985136
23:06:09 3347 8192000000 10768646128 11153461248 1826368544 18.230 100 85 170 3 1865206432 14581760 24256128
23:06:19 2078 8192000000 10767298592 11157889024 1831552352 18.272 100 78 156 0 1866574224 13253776 21768096
23:06:28 2743 8192000000 10776555584 11169832960 1842452656 18.361 100 83 160 0 1877993744 12141552 23399536
23:06:37 3319 8192000000 10789813584 11176550400 1849839440 18.421 100 84 165 2 1885591648 11932096 23820112
23:06:48 2524 8192000000 10793671344 11181088768 1854526320 18.459 100 86 170 1 1891918256 13313088 24078848
23:06:57 3006 8192000000 10802411168 11189358592 1862714640 18.525 100 89 178 1 1899982960 12782384 24485936
23:07:06 2901 8192000000 10801872576 11192967168 1864174208 18.537 100 84 165 1 1900031744 12991664 22865872
23:07:16 1574 8192000000 10809761104 11198398464 1865899168 18.551 100 88 174 1 1905017296 14909536 24208592
23:07:24 2281 8192000000 10812368912 11203112960 1870148880 18.585 100 91 179 1 1909272336 14706944 24416512
23:07:33 2393 8192000000 10815482400 11204513792 1869443504 18.580 100 95 191 1 1910798256 14426064 26928688
23:07:42 2683 8192000000 10813574112 11203260416 1870507392 18.588 100 92 185 2 1910982144 14673136 25801616
23:07:52 1954 8192000000 10822883424 11209375744 1871651296 18.598 100 94 186 1 1912349424 15236144 25461984
23:08:00 1764 8192000000 10822499024 11211059200 1874396688 18.620 100 92 184 1 1914366672 14112608 25857376
23:08:09 11984 8192000000 10813993024 11209736192 1874534832 18.621 100 86 173 0 1910823344 12148320 24140192
23:08:27 1351 8192000000 10819707744 11211579392 1877763680 18.647 100 87 170 1 1915453136 13601920 24087536
23:08:35 1226 8192000000 10828878576 11218255872 1883092064 18.690 100 92 182 4 1923813680 14631280 26090336
23:08:43 2160 8192000000 10834478048 11223334912 1883505792 18.693 100 94 188 1 1924247968 14635568 26106608
23:08:52 3721 8192000000 10805618160 11211939840 1883160640 18.691 100 70 140 1 1915066832 12725888 19180304
23:09:03 3934 8192000000 10801157280 11216252928 1879820704 18.664 100 61 122 2 1908020176 11484960 16714512
23:09:13 2828 8192000000 10803580384 11209527296 1879803040 18.664 100 48 95 0 1903366800 9901104 13662656
23:09:22 4239 8192000000 10801864880 11214057472 1880940272 18.673 100 51 106 1 1904268992 8336048 14992672
23:09:33 8339 8192000000 10792069824 11216265216 1882995344 18.689 100 32 64 3 1899810752 7951312 8864096
23:09:48 9586 8192000000 10807151792 11231752192 1888199712 18.731 100 35 68 1 1910347328 12438448 9709168
23:10:04 7847 8192000000 10800091984 11222966272 1887755184 18.728 100 28 56 1 1902831152 6803152 8272816
23:10:21 10657 8192000000 10814933264 11240005632 1894441696 18.782 100 40 80 1 1916042512 10237984 11362832
23:10:38 4649 8192000000 10801866336 11229499392 1893797488 18.776 100 33 66 2 1910604576 7187824 9619264
23:10:52 56295 8192000000 10831100352 11242590208 1902638320 18.848 100 49 97 0 1922648000 5775200 14234480
23:11:54 4732 8192000000 10814263808 11244453888 1897573376 18.807 100 30 60 0 1914325904 8689600 8062928
23:12:09 5483 8192000000 10825122480 11250470912 1901150576 18.836 100 43 84 4 1924747088 11631504 11965008
23:12:22 4302 8192000000 10823411296 11254001664 1902113456 18.843 100 30 60 0 1922056896 11628256 8315184
23:12:36 7963 8192000000 10816323888 11249111040 1901619680 18.839 100 28 56 1 1916126144 6409776 8096688
23:12:50 6186 8192000000 10834706784 11256745984 1903976256 18.858 100 27 52 6 1917441168 6359008 7105904
23:13:03 4094 8192000000 10817667040 11250237440 1905379984 18.870 100 31 60 4 1920941664 6656304 8905376
23:13:14 5648 8192000000 10821976656 11252596736 1904829008 18.865 100 21 42 1 1916695264 5718096 6148160
23:13:26 7906 8192000000 10828083712 11260776448 1909775632 18.905 100 26 52 1 1923084048 6165600 7142816
23:13:43 8156 8192000000 10831572752 11260628992 1909032272 18.899 100 21 42 1 1921353104 5606800 6714032
23:14:02 5513 8192000000 10833740432 11267911680 1913733056 18.937 100 26 52 1 1931086208 10028032 7325120
23:14:16 7872 8192000000 10836394640 11266027520 1917777344 18.969 100 22 43 0 1933728672 10005072 5946256
23:14:34 8614 8192000000 10827193440 11264544768 1915862368 18.954 100 21 42 5 1927389136 5882816 5643952
23:14:49 9106 8192000000 10820540848 11259789312 1896198528 18.796 99 15 29 0 1905227552 5053344 3975680
23:15:05 8169 8192000000 10831962928 11263426560 1915445760 18.950 100 26 52 1 1929666848 6613744 7607344
23:15:19 22459 8192000000 10800897568 11244986368 1902525136 18.847 99 27 52 2 1916074720 5148016 8401568
23:16:23 21617 8192000000 10785527520 11219046400 1778094528 17.834 93 19 38 2 1788998032 5795760 5107744
23:16:53 8997 8192000000 10785159664 11213012992 1830581360 18.264 97 11 22 1 1838683072 4931712 3170000
23:17:08 6657 8192000000 10782899696 11205369856 1825672672 18.224 97 24 48 2 1838477648 6140240 6664736
23:17:22 4754 8192000000 10788358272 11220484096 1859678240 18.501 99 34 68 1 1876868432 6894128 10296064
23:17:33 4345 8192000000 10787752608 11208380416 1842229184 18.359 98 28 54 3 1856184800 6197776 7757840
23:17:47 5696 8192000000 10767388848 11192344576 1815882976 18.144 97 31 60 3 1830161920 6572656 7706288
23:18:00 8536 8192000000 10780091184 11202465792 1840932736 18.348 99 28 55 2 1854883872 5790416 8160720
23:18:15 5184 8192000000 10748138448 11169505280 1829159616 18.252 99 29 58 1 1844305360 6520192 8625552
23:18:27 9467 8192000000 10753030768 11184111616 1829976080 18.259 99 17 32 3 1840187328 5804352 4406896
23:18:46 7772 8192000000 10740323312 11160719360 1748266192 17.587 94 23 46 0 1760326752 5709216 6351344
23:19:04 5994 8192000000 10720364432 11139465216 1782710560 17.872 98 25 50 1 1795907248 6178624 7018064
23:19:16 8706 8192000000 10740330624 11153412096 1789587840 17.928 98 20 40 2 1800204624 4841664 5775120
23:19:33 10792 8192000000 10685996800 11096240128 1707271120 17.246 95 21 42 1 1719210048 5721520 6217408
23:19:50 47125 8192000000 10705837936 11111673856 1710135360 17.270 95 17 35 1 1720311216 5571968 4603888
23:20:43 29651 8192000000 10682880800 11096416256 1693386192 17.130 94 24 48 0 1705167728 4593856 7187680
23:21:25 6100 8192000000 10670855760 11083018240 1735175232 17.479 98 36 72 1 1751499584 6027216 10297136
23:21:37 6183 8192000000 10700973216 11117338624 1770844544 17.774 99 36 72 0 1788828544 7816912 10167088
23:21:50 4027 8192000000 10726746464 11133714432 1799987776 18.014 100 30 59 2 1814145008 6324144 7833088
23:22:00 6454 8192000000 10716288288 11138449408 1793340192 17.959 99 31 61 3 1809575488 6736688 9498608
23:22:16 6636 8192000000 10726806976 11141935104 1811117280 18.105 100 29 58 3 1825515120 5922160 8475680
23:22:30 5582 8192000000 10752384672 11156217856 1823416992 18.206 100 45 92 3 1841185440 4759504 13008944
23:22:42 8505 8192000000 10738217920 11162255360 1826888016 18.234 100 18 37 2 1837072960 5233472 4951472
23:22:58 9905 8192000000 10755292288 11172700160 1834917680 18.299 100 22 44 1 1847752448 5926560 6908208
23:23:14 8837 8192000000 10754427344 11172581376 1822187520 18.196 99 31 62 2 1837625008 6204704 9232784
23:23:29 13243 8192000000 10768051168 11183820800 1844025632 18.374 100 22 44 1 1855666784 5500976 6140176
23:23:49 10308 8192000000 10763977280 11183403008 1845874976 18.389 100 16 32 0 1856176656 5715088 4586592
23:24:07 11447 8192000000 10761033344 11189305344 1848826976 18.413 100 12 25 1 1856827136 4932544 3067616
23:24:26 12969 8192000000 10768306432 11186798592 1852069888 18.439 100 22 44 0 1865208192 6007744 7130560
23:24:46 66852 8192000000 10763085248 11195011072 1855945744 18.470 100 38 76 1 1873066960 6145216 10976000
23:26:02 9951 8192000000 10773502512 11203121152 1864001424 18.536 100 27 56 1 1877607888 6151968 7454496
23:26:18 3677 8192000000 10773781136 11207180288 1866311984 18.554 100 28 56 1 1881344048 7156576 7875488
23:26:28 11790 8192000000 10789548304 11207827456 1869260576 18.578 100 25 50 0 1882467872 5790688 7416608
23:26:48 5924 8192000000 10784214448 11209547776 1870969504 18.592 100 24 48 0 1883642576 5690816 6982256
23:27:00 3348 8192000000 10802952208 11218882560 1878775696 18.655 100 43 86 3 1897567008 6089648 12701664
23:27:14 42202 8192000000 10817306736 11235651584 1893816640 18.777 100 46 91 1 1914085648 7953792 12315216
23:28:05 45905 8192000000 10823619408 11251777536 1901662928 18.840 100 33 66 0 1919473968 8367776 9443264
23:29:06 62865 8192000000 10844904080 11277123584 1919269040 18.981 100 30 60 2 1940608240 12155264 9183936
23:30:15 15160 8192000000 10853868064 11284652032 1935326320 19.109 100 43 87 0 1962380064 13216960 13836784
23:30:41 39834 8192000000 10869698336 11303288832 1939521584 19.143 100 29 58 0 1963360864 14737856 9101424
23:31:31 13738 8192000000 10877705312 11310559232 1949113040 19.219 100 39 78 1 1975984672 15048352 11823280
23:31:53 12430 8192000000 10891878160 11320836096 1953106320 19.251 100 39 77 1 1981807744 17466320 11235104
23:32:12 42101 8192000000 10894961712 11323621376 1952461296 19.246 100 40 80 2 1982418864 18181568 11776000
23:33:02 5034 8192000000 10911436560 11334635520 1963608624 19.335 100 60 118 0 1997316768 16629280 17078864
23:33:15 5362 8192000000 10916265840 11335933952 1965521120 19.350 100 56 113 2 1997459344 16371328 15566896
23:33:30 14928 8192000000 10914534272 11338743808 1971268304 19.396 100 58 116 2 2005598448 18311216 16018928
23:33:52 5226 8192000000 10920007136 11346083840 1973215680 19.411 100 57 111 1 2006279248 17397744 15665824
23:34:06 5016 8192000000 10911194112 11336028160 1954267744 19.260 99 63 124 2 1989099424 17503872 17327808
23:34:24 4250 8192000000 10904482192 11335172096 1947534944 19.207 99 58 116 1 1982968224 18478112 16955168
23:34:36 8402 8192000000 10912620080 11342979072 1968556048 19.374 100 61 122 1 2004967232 18324192 18086992
23:34:53 13833 8192000000 10925560080 11349729280 1973177024 19.411 100 56 110 1 2010057840 20834304 16046512
23:35:15 4993 8192000000 10928036592 11355557888 1977478464 19.445 100 71 142 2 2019815616 20954480 21382672
23:35:31 6605 8192000000 10913554832 11347701760 1957676000 19.288 99 55 110 1 1997149040 23503152 15969888
23:35:56 3495 8192000000 10930493168 11355889664 1976506560 19.437 100 65 128 1 2016240640 21681760 18052320
23:36:08 1897 8192000000 10942918384 11361570816 1983701936 19.494 100 81 162 2 2030353264 22147936 24503392
23:36:17 3777 8192000000 10927639920 11358912512 1982075024 19.481 100 61 121 0 2019477568 19465440 17937104
23:36:35 7407 8192000000 10922855104 11348664320 1956541824 19.279 99 67 132 0 1995951024 20272640 19136560
23:36:50 14063 8192000000 10924598128 11352563712 1976959920 19.441 100 78 154 3 2021959280 21999376 22999984
23:37:21 5810 8192000000 10933757952 11362443264 1981173472 19.474 100 61 122 0 2022856320 24154496 17528352
23:37:35 3437 8192000000 10937987792 11354492928 1972849920 19.408 99 75 150 0 2018623936 24167312 21606704
23:37:46 6837 8192000000 10936368320 11354198016 1969427616 19.381 99 71 142 0 2016038576 25532224 21078736
23:38:02 1985 8192000000 10947524080 11366371328 1971761648 19.399 99 82 163 3 2021841856 26228912 23851296
23:38:12 3227 8192000000 10952476368 11372228608 1987471072 19.524 100 83 166 0 2038461440 26623648 24366720
23:38:22 2155 8192000000 10936518528 11345711104 1955128368 19.267 99 88 173 1 2008079872 27185408 25766096
23:38:32 9653 8192000000 10919782208 11342725120 1957215136 19.284 99 76 152 1 2008196960 28075632 22906192
23:38:50 2179 8192000000 10944243248 11354664960 1970531856 19.390 100 83 166 3 2021918320 26552496 24833968
23:39:00 6429 8192000000 10928770592 11357593600 1977746784 19.447 100 69 136 1 2024549776 26194448 20608544
23:39:14 3408 8192000000 10941782480 11366178816 1977394768 19.444 100 61 121 3 2025151664 29852816 17904080
23:39:24 3978 8192000000 10944791936 11365982208 1968024544 19.370 99 74 148 0 2022558864 32308864 22225456
23:39:36 4487 8192000000 10957061728 11376140288 1990222720 19.546 100 76 152 2 2042382800 29287440 22872640
23:39:48 4330 8192000000 10956380672 11379089408 1993780064 19.574 100 75 150 0 2045331696 29626768 21924864
23:39:59 1474 8192000000 10963691360 11373883392 1974040656 19.417 99 89 177 4 2032700064 30528848 28130560
23:40:07 1148 8192000000 10963592432 11370110976 1977970272 19.449 100 81 162 1 2034298960 31861200 24467488
23:40:16 2351 8192000000 10954308320 11361624064 1973325248 19.412 99 86 171 0 2030530480 31311184 25894048
23:40:27 3172 8192000000 10939622224 11357495296 1968440864 19.373 100 75 150 1 2024756336 34276384 22039088
23:40:39 4150 8192000000 10956701888 11370225664 1974740544 19.423 100 77 154 0 2032749536 34548992 23460000
23:40:50 4608 8192000000 10958984560 11376164864 1983968960 19.496 100 83 165 3 2044976992 36143392 24864640
23:41:05 6925 8192000000 10950013520 11368185856 1978878112 19.456 100 72 144 1 2034907360 34878544 21150704
23:41:19 4926 8192000000 10944209168 11362349056 1973674368 19.415 100 66 132 0 2029370928 35214688 20481872
23:41:32 6091 8192000000 10936143712 11355160576 1957186112 19.284 99 75 149 0 2014629136 34998880 22444144
23:41:48 3866 8192000000 10937443344 11344953344 1955976560 19.274 99 69 137 1 2013729008 36272336 21480112
23:41:59 2877 8192000000 10960662960 11367022592 1960749936 19.312 99 79 158 2 2022471632 37070272 24651424
23:42:09 1801 8192000000 10961800272 11371810816 1978132704 19.450 100 93 189 3 2044116608 38067680 27916224
23:42:18 2078 8192000000 10964127760 11374170112 1979453824 19.460 100 90 176 4 2045908480 39589072 26865584
23:42:27 2514 8192000000 10951932608 11363602432 1964731568 19.344 99 87 174 1 2031870320 40421104 26717648
23:42:37 891 8192000000 10958087376 11365777408 1969763216 19.384 100 91 180 1 2038865040 41506256 27595568
23:42:45 1383 8192000000 10954204528 11369570304 1977253008 19.443 100 82 161 2 2044466864 41869920 25343936
23:42:55 1894 8192000000 10962143232 11372961792 1979887728 19.464 100 81 161 4 2041627648 36919152 24820768
23:43:04 5413 8192000000 10936127440 11350671360 1943122560 19.172 99 73 141 3 2003028592 37406128 22499904
23:43:22 14585 8192000000 10920530640 11349606400 1950633792 19.232 100 41 81 1 1999345040 35787008 12924240
23:43:51 2888 8192000000 10940830608 11347152896 1949199536 19.220 100 80 161 0 2013625056 39179296 25246224
23:44:01 2192 8192000000 10925256800 11336679424 1937171776 19.124 99 77 152 0 1994317952 33069520 24076656
23:44:12 6410 8192000000 10899616848 11313025024 1894717488 18.784 97 67 132 1 1949429376 34010448 20701440
23:44:26 5603 8192000000 10904232688 11322601472 1921443904 18.998 99 66 133 1 1976912320 33772736 21695680
23:44:41 2636 8192000000 10931792704 11341086720 1949970912 19.226 100 79 157 0 2009319632 35073536 24275184
23:44:51 6293 8192000000 10904314112 11322175488 1926383248 19.038 100 68 134 1 1984670688 36514576 21772864
23:45:04 11979 8192000000 10858290096 11285241856 1890763616 18.752 98 48 96 1 1943110080 36670592 15675872
23:45:28 5810 8192000000 10863235840 11294879744 1885782352 18.712 98 42 82 1 1936601920 36724384 14095184
23:45:49 16572 8192000000 10884227472 11311308800 1915824064 18.953 100 66 133 3 1980470400 43506160 21140176
23:46:19 1695 8192000000 10905922000 11326423040 1928434064 19.054 100 59 119 1 1988822288 41435776 18952448
23:46:28 3936 8192000000 10907835712 11332214784 1935309312 19.109 100 58 114 1 1991096608 38047232 17740064
23:46:42 3718 8192000000 10924093520 11330392064 1937758800 19.129 100 85 170 0 2003573440 39628640 26186000
23:46:54 4956 8192000000 10926415936 11338788864 1944313760 19.181 100 71 142 1 2002947328 35526096 23107472
23:47:06 3931 8192000000 10928827344 11339915264 1948213328 19.212 100 83 162 2 2008829472 35598144 25018000
23:47:17 1165 8192000000 10945441104 11355590656 1959783712 19.304 100 88 176 1 2022651008 36059600 26807696
23:47:28 3577 8192000000 10938134368 11347705856 1941070928 19.155 99 78 157 1 2002541344 37314656 24155760
23:47:38 3333 8192000000 10941298416 11355791360 1963109040 19.331 100 72 144 3 2020980464 34725792 23145632
23:47:47 2807 8192000000 10950023520 11363336192 1969577504 19.382 100 81 163 1 2030839904 35427584 25834816
23:47:57 2578 8192000000 10954804752 11367821312 1974435360 19.421 100 83 166 2 2039345184 38551344 26358480
23:48:08 5291 8192000000 10954976688 11374096384 1972367696 19.404 100 68 137 0 2034816064 41036384 21411984
23:48:20 3677 8192000000 10947284336 11373981696 1971496784 19.397 100 57 113 0 2030477504 41310400 17670320
23:48:34 6252 8192000000 10947658176 11376758784 1974113856 19.418 100 51 102 1 2029216464 39050240 16052368
23:48:54 7703 8192000000 10938255056 11377938432 1974468736 19.421 100 44 89 1 2026829184 38075936 14284512
23:49:13 24211 8192000000 10932913008 11378855936 1966693136 19.359 100 40 80 0 2020929520 40206512 14029872
23:49:44 13551 8192000000 10936334240 11375435776 1972774192 19.407 100 33 65 2 2021444912 37010000 11660720
23:50:04 9247 8192000000 10927569312 11357007872 1942630640 19.168 99 39 77 2 1992041456 36638528 12772288
23:50:22 6448 8192000000 10933764416 11353927680 1958237120 19.292 100 58 114 0 2014862672 37153408 19472144
23:50:36 3012 8192000000 10941122176 11356622848 1955322208 19.269 100 75 150 2 2016506752 37621040 23563504
23:50:48 2226 8192000000 10947459104 11359612928 1960238720 19.308 100 76 150 0 2023905328 40126416 23540192
23:50:58 4227 8192000000 10949368720 11371741184 1970642752 19.391 100 76 151 0 2032263232 38116320 23504160
23:51:16 24818 8192000000 10912021360 11352985600 1928639024 19.056 98 38 76 0 1979013440 37901072 12473344
23:52:08 15270 8192000000 10904105984 11357102080 1940003216 19.147 99 27 54 2 1981669440 32480656 9185568
23:52:29 23890 8192000000 10919643696 11367186432 1956420432 19.278 100 32 64 2 2003509696 36137040 10952224
23:53:04 31345 8192000000 10899765216 11352920064 1928259792 19.053 99 21 42 2 1971886672 36253056 7373824
23:53:41 24336 8192000000 10896432128 11357437952 1922405936 19.006 99 18 36 1 1969804144 40904560 6493648
23:54:15 40647 8192000000 10871183728 11344936960 1924760272 19.025 100 15 30 0 1969226384 38986992 5479120
23:55:02 70635 8192000000 10856684640 11312676864 1893116448 18.771 98 20 40 2 1936523296 36980640 6426208
23:56:33 4635 8192000000 10868348160 11297648640 1891865856 18.761 98 46 91 0 1918974176 13864000 13244320
23:56:45 25022 8192000000 10864398672 11319877632 1930763552 19.073 100 27 54 1 1952164720 13840336 7560832
23:57:33 47556 8192000000 10880525472 11340144640 1941406576 19.158 100 13 27 1 1960684128 15534960 3742592
23:59:04 44371 8192000000 10876122272 11338764288 1952984432 19.250 100 19 39 1 1971558048 13420656 5152960
23:59:56 65975 8192000000 10882584560 11329392640 1935041408 19.107 99 11 22 0 1949844432 12237568 2565456
00:01:08 108197 8192000000 10903090080 11353026560 1963262928 19.332 100 12 26 0 1977463328 11140832 3059568
00:03:04 91944 8192000000 10907728704 11372584960 1978827152 19.455 100 21 42 0 1994563680 9548800 6187728
00:04:43 72113 8192000000 10910830528 11366555648 1984380528 19.499 100 26 51 1 2000217056 8867744 6968784
00:06:10 118615 8192000000 10920751680 11387310080 1992699200 19.565 100 32 60 1 2011002608 10031616 8271792
00:08:21 218755 8192000000 10961739584 11401191424 1906979696 18.882 95 30 61 1 1925977744 10400736 8597312
00:12:06 18313 8192000000 10957463152 11411423232 2019403552 19.775 100 48 96 0 2047303280 13203264 14696464
00:12:43 33488 8192000000 10950282400 11410702336 2013041648 19.725 100 21 42 1 2034490624 15003120 6445856
00:13:23 45987 8192000000 10959897424 11406450688 1989701456 19.541 99 30 60 0 2015572480 16656336 9214688
00:14:25 31637 8192000000 10929366160 11404447744 2004146208 19.655 100 27 52 0 2021408464 10145616 7116640
00:15:03 60550 8192000000 10915477648 11397009408 1965388720 19.349 98 8 16 0 1980361600 12577360 2395520
00:17:13 67748 8192000000 10916471776 11389898752 1997026736 19.599 100 21 42 2 2015108384 11767200 6314448
00:18:27 40591 8192000000 10919192224 11392442368 1996880752 19.598 100 11 22 3 2010917472 10696240 3340480
00:19:19 53743 8192000000 10934657472 11399913472 2006887840 19.677 100 16 33 2 2023460544 12206352 4366352
00:20:19 67915 8192000000 10928896816 11412701184 2007241184 19.680 100 15 30 1 2026835200 15219696 4374320
00:22:50 49232 8192000000 10913035024 11382857728 1950700624 19.232 97 25 50 1 1965350736 7158496 7491616
00:23:48 28881 8192000000 10917919504 11386728448 1964190032 19.339 98 23 46 1 1980528720 9325760 7012928
00:24:45 78264 8192000000 10938932496 11399782400 1960229856 19.308 98 23 43 0 1976309376 9886768 6192752
00:26:11 45926 8192000000 10944055856 11402338304 1985781376 19.510 99 27 53 1 2003403504 10102640 7519488
00:27:35 72032 8192000000 10916069952 11399475200 1985071712 19.505 100 8 16 0 1999044464 12246720 1726032
00:29:01 82773 8192000000 10901055264 11375853568 1911343056 18.917 95 20 41 0 1930176688 13478384 5355248
00:30:31 69587 8192000000 10909297056 11368947712 1886008480 18.714 95 12 24 0 1904626448 15634032 2983936
00:31:47 61831 8192000000 10900839712 11364769792 1898832448 18.817 96 24 48 1 1915012496 9639632 6540416
00:32:54 64304 8192000000 10883848032 11331977216 1874110448 18.618 95 23 44 1 1889760320 9315072 6334800
00:34:08 35936 8192000000 10880401312 11341139968 1901125600 18.835 97 34 68 0 1919962848 9802656 9034592
00:35:03 74114 8192000000 10874819664 11314581504 1814237968 18.131 93 22 44 1 1834656704 14741168 5677568
00:36:26 44478 8192000000 10881672256 11329531904 1909524304 18.903 98 29 58 0 1928400288 10738032 8137952
00:37:17 12946 8192000000 10876824144 11324510208 1907776352 18.889 98 39 78 0 1929524704 11190176 10558176
00:37:36 48784 8192000000 10868141392 11341455360 1920447536 18.990 99 32 64 0 1943317408 13934864 8935008
00:38:31 66339 8192000000 10854270704 11314405376 1862543296 18.524 96 14 28 0 1878494128 11306096 4644736
00:39:54 70748 8192000000 10864430480 11321069568 1913222112 18.933 99 17 34 0 1924660688 6961184 4477392
00:41:24 79939 8192000000 10847394528 11314585600 1881052688 18.674 97 30 61 0 1902140336 12978304 8109344
00:42:53 25261 8192000000 10857859760 11315490816 1927835808 19.050 100 21 42 0 1942372928 8051168 6485952
00:43:24 34847 8192000000 10835712560 11300687872 1895971824 18.794 98 15 28 2 1908525408 8354704 4198880
00:44:08 65402 8192000000 10880330384 11333554176 1941440848 19.158 100 12 24 0 1954120608 8445664 4234096
00:45:20 29798 8192000000 10863653872 11328602112 1928646144 19.056 99 20 40 0 1944422368 10483488 5292736
00:46:59 99747 8192000000 10862161600 11332390912 1910154848 18.908 98 14 28 0 1930441824 16090784 4196192
00:48:50 64096 8192000000 10886960096 11349155840 1936336848 19.118 99 13 26 0 1959176000 18946880 3892272
00:50:09 86817 8192000000 10883861840 11367559168 1937982704 19.131 99 11 22 0 1956849008 15782016 3084288
00:51:43 62234 8192000000 10891897200 11360686080 1948927472 19.218 99 22 45 1 1970373904 14948672 6497760
00:52:54 92083 8192000000 10887544992 11352137728 1919547872 18.983 98 10 20 0 1936964560 14288096 3128592
00:54:36 64661 8192000000 10883604320 11356958720 1942584688 19.167 99 21 42 2 1963148608 14362768 6201152
00:55:48 57038 8192000000 10905518832 11364294656 1922071328 19.003 98 20 40 0 1946078032 18334208 5672496
00:56:51 62477 8192000000 10909505824 11370594304 1963142624 19.331 100 31 62 0 1989269520 17874560 8252336
00:58:05 74645 8192000000 10904525824 11360391168 1938833376 19.137 98 15 30 0 1956038608 13718912 3486320
00:59:26 20877 8192000000 10935252464 11380318208 1983135136 19.490 100 33 66 0 2000394320 8060480 9198704
00:59:55 111565 8192000000 10919975376 11382546432 1933632176 19.096 97 28 56 0 1955527824 14326320 7569328
01:01:54 25985 8192000000 10936756528 11384057856 1993547392 19.572 100 41 82 2 2013792752 9279936 10965424
01:02:27 41956 8192000000 10947066352 11392425984 1978062768 19.449 99 40 80 0 2003457504 14492976 10901760
01:03:18 108359 8192000000 10920962416 11383476224 1972076128 19.402 99 31 60 1 1992405856 10803520 9526208
01:05:32 47464 8192000000 10898025728 11378016256 1952152368 19.244 98 10 20 1 1968001312 12953920 2895024
01:06:26 21817 8192000000 10901407616 11383939072 1986927536 19.520 100 11 22 1 2002814080 13519536 2367008
01:06:56 51954 8192000000 10912284480 11381415936 1973216336 19.411 99 10 20 2 1984764192 8304192 3243664
01:08:14 44725 8192000000 10902292800 11382779904 1979523024 19.461 99 7 15 0 1987431840 6003072 1905744
01:09:14 62216 8192000000 10890730624 11365007360 1929214688 19.061 97 16 32 0 1941752064 8126688 4410688
01:10:23 80377 8192000000 10886452336 11376095232 1962999888 19.330 99 21 42 2 1980061504 10976544 6085072
01:11:56 54528 8192000000 10881655264 11366977536 1970652640 19.391 100 4 8 0 1984164704 11817408 1694656
01:12:57 42600 8192000000 10892246704 11365724160 1964613712 19.343 100 29 58 2 1982071504 8816496 8641296
01:13:46 77334 8192000000 10887112800 11365089280 1906458672 18.878 96 17 34 2 1928182160 15985456 5738032
01:15:09 32998 8192000000 10901736416 11356999680 1948873120 19.218 99 47 90 2 1971767136 9654496 13239520
01:15:54 72623 8192000000 10875607520 11356184576 1892007280 18.762 96 20 40 2 1914527488 16760864 5759344
01:17:13 102427 8192000000 10856979872 11327746048 1869153248 18.577 96 11 23 1 1888240784 16264480 2823056
01:19:02 32091 8192000000 10858943440 11313508352 1869594464 18.581 96 43 86 1 1894252208 12239520 12418224
01:19:42 52020 8192000000 10859185248 11308503040 1836173248 18.310 95 33 66 1 1860471568 15111504 9186816
01:20:43 37954 8192000000 10860805600 11306127360 1881437536 18.677 98 29 58 0 1900000704 10621408 7941760
01:21:36 38675 8192000000 10875419632 11320926208 1898154496 18.811 98 44 88 3 1921968704 11555440 12258768
01:23:24 34298 8192000000 10884183632 11329695744 1918748624 18.977 99 35 70 0 1938596512 10445328 9402560
01:24:10 31457 8192000000 10898234240 11351109632 1947351648 19.205 100 34 68 1 1972966064 15857504 9756912
01:24:54 56749 8192000000 10850563440 11320541184 1882913024 18.689 97 24 48 2 1902497568 12819488 6765056
01:26:16 60591 8192000000 9784787840 10133909504 924608976 10.142 48 10 17 1 931478624 3855392 3014256

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 13-11-2020 01:29:05 to 13-11-2020 01:29:37.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 88 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 13-11-2020 01:29:38 to 13-11-2020 01:29:39.

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          241581
MON$OLDEST_ACTIVE               241582
MON$OLDEST_SNAPSHOT             241582
MON$NEXT_TRANSACTION            241582
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                       2021760
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
:37: 
:38: mscs-test-161.budzdorov.ru    Fri Nov 13 01:27:29 2020
:39:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:40: 
--- end of diff output ---

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

13.11.20 01:29:40. 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-13 01:29:43 No severe PSQL-related problems occured
13.11.20 01:29:44. End of report.