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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17337520 kB
MemAvailable 31408592 kB
Buffers 0 kB
Cached 14340224 kB
SwapCached 3492 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-15 16:27:02
DTS_END                         2020-11-15 16:27:02.5310
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(131:22) ==> SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36854
TRN_ID                          235410
ATT_ID                          711
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: 8904.38 23248 1068526
customer order: creation 167.73 369 20127
customer order: refuse 14.53 413 1743
order to supplier: creation 44.22 1395 5306
order to supplier: removal 3.40 103794 408
invoice (draft): creation 44.83 3811 5379
invoice (draft): removal 50.68 740 6082
invoice accept: apply 40.88 19883 4905
invoice accept: cancel 45.86 901 5503
customer reserve: creation 3756.68 195 450801
customer reserve: removal 4442.11 62 533053
realization accept: apply 81.43 217 9771
realization accept: cancel 84.18 131 10102
payment from customer: creation 57.83 135 6939
payment from customer: removal 5.84 75 701
payment to supplier: creation 48.57 149 5828
payment to supplier: removal 3.47 73 416
service: total inventory turnovers 4.82 1047 578
service: total monetary turnovers 6.59 27 791
service: aggregate perf. data 0.74 20392 89
service: refresh index statistics 0.03 311152 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-11-2020 16:27:51 to 15-11-2020 16:27:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9999
TEST_TIME 2 7883
TEST_TIME 3 6815
TEST_TIME 4 6136
TEST_TIME 5 6505
TEST_TIME 6 6585
TEST_TIME 7 6853
TEST_TIME 8 6871
TEST_TIME 9 7301
TEST_TIME 10 7411
TEST_TIME 11 7700
TEST_TIME 12 7742
TEST_TIME 13 7813
TEST_TIME 14 8047
TEST_TIME 15 8215
TEST_TIME 16 8304
TEST_TIME 17 8337
TEST_TIME 18 8900
TEST_TIME 19 8992
TEST_TIME 20 9114
TEST_TIME 21 9177
TEST_TIME 22 9313
TEST_TIME 23 9634
TEST_TIME 24 9803
TEST_TIME 25 9624
TEST_TIME 26 10133
TEST_TIME 27 10578
TEST_TIME 28 10745
TEST_TIME 29 10480
TEST_TIME 30 10482
TEST_TIME 31 10382
TEST_TIME 32 10230
TEST_TIME 33 10081
TEST_TIME 34 10082
TEST_TIME 35 9988
TEST_TIME 36 9965
TEST_TIME 37 9774
TEST_TIME 38 9759
TEST_TIME 39 9720
TEST_TIME 40 9906
TEST_TIME 41 9936
TEST_TIME 42 9786
TEST_TIME 43 9659
TEST_TIME 44 9591
TEST_TIME 45 9639
TEST_TIME 46 9561
TEST_TIME 47 9504
TEST_TIME 48 9511
TEST_TIME 49 9416
TEST_TIME 50 9269
TEST_TIME 51 9241
TEST_TIME 52 9271
TEST_TIME 53 9296
TEST_TIME 54 9240
TEST_TIME 55 9131
TEST_TIME 56 9089
TEST_TIME 57 9059
TEST_TIME 58 9014
TEST_TIME 59 8910
TEST_TIME 60 8865
TEST_TIME 61 8896
TEST_TIME 62 8858
TEST_TIME 63 8941
TEST_TIME 64 8890
TEST_TIME 65 8904
TEST_TIME 66 9154
TEST_TIME 67 9091
TEST_TIME 68 9098
TEST_TIME 69 9120
TEST_TIME 70 9121
TEST_TIME 71 9115
TEST_TIME 72 9197
TEST_TIME 73 9188
TEST_TIME 74 9202
TEST_TIME 75 9290
TEST_TIME 76 9263
TEST_TIME 77 9150
TEST_TIME 78 9159
TEST_TIME 79 9116
TEST_TIME 80 9076
TEST_TIME 81 9069
TEST_TIME 82 9007
TEST_TIME 83 8943
TEST_TIME 84 8944
TEST_TIME 85 8909
TEST_TIME 86 8941
TEST_TIME 87 9007
TEST_TIME 88 9040
TEST_TIME 89 9064
TEST_TIME 90 9021
TEST_TIME 91 8977
TEST_TIME 92 8997
TEST_TIME 93 9228
TEST_TIME 94 9214
TEST_TIME 95 9229
TEST_TIME 96 9243
TEST_TIME 97 9268
TEST_TIME 98 9246
TEST_TIME 99 9184
TEST_TIME 100 9117
TEST_TIME 101 9144
TEST_TIME 102 9097
TEST_TIME 103 9090
TEST_TIME 104 9045
TEST_TIME 105 8996
TEST_TIME 106 8985
TEST_TIME 107 8958
TEST_TIME 108 8962
TEST_TIME 109 8910
TEST_TIME 110 8926
TEST_TIME 111 8915
TEST_TIME 112 8922
TEST_TIME 113 8911
TEST_TIME 114 8945
TEST_TIME 115 8933
TEST_TIME 116 8945
TEST_TIME 117 8935
TEST_TIME 118 9010
TEST_TIME 119 8987
TEST_TIME 120 8914

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-11-2020 16:27:55 to 15-11-2020 16:27: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 1485790 1485790 0 0.00 0 22467 7 0 0
doc_list_biud 1485790 1485790 0 0.00 0 54211 29 0 0
sp_add_invoice_to_stock 5016 4905 111 2.21 24 173794 19883 0 111
sp_cancel_adding_invoice 5503 5503 0 0.00 4 87298 902 0 0
sp_cancel_client_order 1743 1743 0 0.00 4 12072 414 0 0
sp_cancel_customer_reserve 533053 533053 0 0.00 1 54218 63 0 0
sp_cancel_pay_from_customer 701 701 0 0.00 3 3073 75 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 3 2069 73 0 0
sp_cancel_supplier_invoice 6089 6082 7 0.11 1 22897 741 0 7
sp_cancel_supplier_order 408 408 0 0.00 8 922685 103795 0 0
sp_cancel_write_off 10102 10102 0 0.00 1 9495 132 0 0
sp_client_order 20127 20127 0 0.00 3 21635 369 0 0
sp_customer_reserve 450801 450801 0 0.00 0 35006 196 0 0
sp_fill_shopping_cart 30800 30800 0 0.00 1 13313 45 0 0
sp_fill_shopping_cart_clo_res 450783 450783 0 0.00 0 12545 14 0 0
sp_get_clo_for_invoice 4887 4887 0 0.00 0 43101 352 0 0
sp_kill_cost_storno 16722 16722 0 0.00 0 10913 62 0 0
sp_kill_qstorno_ret_qs2qd 1082698 1082698 0 0.00 0 54183 33 0 0
sp_kill_qty_storno 571549 571549 0 0.00 0 54209 74 0 0
sp_lock_selected_doc 20460 20460 0 0.00 0 11382 7 0 0
sp_make_cost_storno 27425 27425 0 0.00 0 19328 66 0 0
sp_multiply_rows_for_pdistr 27425 27425 0 0.00 0 11241 30 0 0
sp_multiply_rows_for_qdistr 20127 20127 0 0.00 0 13654 157 0 0
sp_pay_from_customer 6939 6939 0 0.00 4 13460 135 0 0
sp_pay_to_supplier 5828 5828 0 0.00 5 19334 150 0 0
sp_payment_common 12767 12767 0 0.00 1 13417 42 0 0
sp_qd_handle_on_cancel_clo 1743 1743 0 0.00 0 12062 386 0 0
sp_qd_handle_on_invoice_upd_sts 10390 10390 0 0.00 0 26719 396 0 0
sp_qd_handle_on_reserve_upd_sts 9771 9771 0 0.00 0 19405 69 0 0
sp_reserve_write_off 9771 9771 0 0.00 6 19547 217 0 0
sp_supplier_invoice 5379 5379 0 0.00 7 64210 3811 0 0
sp_supplier_order 5306 5306 0 0.00 5 26294 1395 0 0
srv_aggregate_perf_data 89 89 0 0.00 3018 237246 20393 0 0
srv_fill_mon_cache_memory 172 172 0 0.00 1413 114184 29309 0 0
srv_find_qd_qs_mism 1021742 1021742 0 0.00 0 22466 6 0 0
srv_make_invnt_saldo 578 578 0 0.00 45 29372 1047 0 0
srv_make_money_saldo 791 791 0 0.00 1 643 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 101985 594799 311153 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4905 4905 0 0.00 0 18603 218 0 0
t$perf-norm:sp_cancel_adding_invoice 406 406 0 0.00 0 8145 157 0 0
t$perf-norm:sp_cancel_client_order 1743 1743 0 0.00 0 9796 27 0 0
t$perf-norm:sp_cancel_customer_reserve 701 701 0 0.00 0 2108 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 701 701 0 0.00 0 14615 26 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 754 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 408 408 0 0.00 0 617 15 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 25520 1622 0 0
t$perf-norm:sp_cancel_write_off 1020 1020 0 0.00 0 2382 10 0 0
t$perf-norm:sp_client_order 20127 20127 0 0.00 0 6456 19 0 0
t$perf-norm:sp_customer_reserve 938 938 0 0.00 0 5983 13 0 0
t$perf-norm:sp_pay_from_customer 6939 6939 0 0.00 0 8479 17 0 0
t$perf-norm:sp_pay_to_supplier 5828 5828 0 0.00 0 6244 13 0 0
t$perf-norm:sp_reserve_write_off 9771 9771 0 0.00 0 7952 11 0 0
t$perf-norm:sp_supplier_invoice 5379 5379 0 0.00 0 8879 23 0 0
t$perf-norm:sp_supplier_order 5306 5306 0 0.00 0 12087 23 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 133 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 607 9 0 0
t$perf-norm:srv_make_invnt_saldo 578 578 0 0.00 0 4688 31 0 0
t$perf-norm:srv_make_money_saldo 791 791 0 0.00 0 1872 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 9994 9772 222 2.22 0 12827 21 0 222
v_all_customers 36820 36820 0 0.00 0 21 1 0 0
v_all_suppliers 29798 29798 0 0.00 0 16 1 0 0
v_all_wares 40252 40252 0 0.00 0 99 1 0 0
v_cancel_adding_invoice 812 812 0 0.00 0 2920 9 0 0
v_cancel_client_order 3486 3486 0 0.00 0 2296 6 0 0
v_cancel_customer_prepayment 1402 1402 0 0.00 0 1698 6 0 0
v_cancel_customer_reserve 1402 1402 0 0.00 0 3270 6 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 1685 5 0 0
v_cancel_supplier_invoice 830 816 14 1.68 0 1041 15 0 14
v_cancel_supplier_order 816 816 0 0.00 0 3813 9 0 0
v_cancel_write_off 2040 2040 0 0.00 0 4538 20 0 0
v_max_id_clo_ord 5302 5302 0 0.00 0 786 1 0 0
v_max_id_clo_res 938 938 0 0.00 0 3706 14 0 0
v_max_id_ord_sup 5372 5372 0 0.00 0 4018 4 0 0
v_max_non_paid_invoice 1603 1603 0 0.00 0 335 3 0 0
v_max_non_paid_realizn 3685 3685 0 0.00 0 9127 10 0 0
v_min_id_clo_ord 5302 5302 0 0.00 0 7822 9 0 0
v_min_id_clo_res 938 938 0 0.00 0 467 2 0 0
v_min_id_ord_sup 5372 5372 0 0.00 0 3698 5 0 0
v_min_non_paid_invoice 5828 5828 0 0.00 0 11221 30 0 0
v_min_non_paid_realizn 6939 6939 0 0.00 0 11893 25 0 0
v_our_firm 9940 9940 0 0.00 0 17 1 0 0
v_reserve_write_off 19542 19542 0 0.00 0 3503 7 0 0
x_lock_depdocs_on_canc_invoice 11177 11177 0 0.00 0 22241 138 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 25610 424 0 0
x_make_qstorno_1000_1200 5306 5306 0 0.00 1 26273 1302 0 0
x_make_qstorno_1200_2000 5379 5379 0 0.00 3 62549 3651 0 0
x_make_qstorno_2100_3300 450801 450801 0 0.00 0 34369 179 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-11-2020 16:27:59 to 15-11-2020 16:28: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
13:57:06 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:13 10976 8192000000 10207831712 10509164544 940271760 10.296 76 57 115 0 961718752 2570112 18876880
13:57:31 27264 8192000000 10329984640 10646863872 1354672096 14.189 100 86 172 0 1387516240 4194976 28649168
13:58:08 23678 8192000000 10378663728 10699612160 1425108384 14.818 100 90 181 1 1459777728 5710896 28958448
13:58:40 30105 8192000000 10402743104 10729771008 1452310176 15.058 100 82 164 0 1485816192 7000304 26505712
13:59:23 17232 8192000000 10426912848 10753548288 1481441952 15.314 100 89 178 0 1517613696 7644672 28527072
13:59:47 8706 8192000000 10433756352 10764124160 1488997536 15.380 100 86 172 1 1524796464 8292032 27506896
14:00:08 20851 8192000000 10461761808 10794811392 1512482928 15.585 100 90 180 0 1549713424 8589184 28641312
14:00:37 24054 8192000000 10469407632 10805518336 1524901776 15.693 100 93 186 0 1563765600 9568640 29295184
14:01:10 20645 8192000000 10477262800 10822684672 1535549824 15.785 100 82 164 1 1571230640 9913920 25766896
14:01:39 21106 8192000000 10518714160 10871627776 1568790512 16.072 100 77 154 0 1602115584 10160304 23164768
14:02:10 19855 8192000000 10547043696 10903523328 1602095008 16.357 100 83 166 0 1638430752 11024816 25310928
14:02:38 13018 8192000000 10582897568 10942947328 1630144480 16.596 100 76 152 3 1663968848 11406448 22417920
14:03:00 11224 8192000000 10591271728 10951790592 1650414192 16.768 100 82 160 3 1687058848 12362992 24281664
14:03:24 11688 8192000000 10600340608 10965577728 1661466112 16.861 100 74 148 1 1694960720 11679888 21814720
14:03:48 7880 8192000000 10625965952 10993819648 1685159376 17.061 100 78 154 1 1720293728 12507968 22626384
14:04:04 6171 8192000000 10637847536 11006873600 1697995872 17.168 100 79 158 0 1732808080 12279520 22532688
14:04:19 8213 8192000000 10644817328 11021504512 1712378096 17.289 100 73 146 0 1746690752 13017472 21295184
14:04:36 7580 8192000000 10662152000 11038871552 1730891776 17.443 100 74 146 2 1763366720 11751088 20723856
14:04:51 8395 8192000000 10678530992 11055542272 1741322272 17.530 100 80 160 0 1776936784 12767232 22847280
14:05:07 4995 8192000000 10698691856 11075354624 1755325024 17.646 100 86 173 1 1793727376 14232416 24169936
14:05:20 12874 8192000000 10703315616 11086471168 1763807296 17.716 100 73 146 1 1798300000 14002288 20490416
14:05:41 4218 8192000000 10717774576 11097227264 1778046432 17.833 100 78 155 1 1813926528 13845712 22034384
14:05:52 2563 8192000000 10726271264 11110309888 1792501488 17.952 100 81 162 1 1828971792 13339200 23131104
14:06:01 2116 8192000000 10735251808 11120132096 1799621856 18.011 100 80 160 0 1834997856 13422032 21953968
14:06:10 3329 8192000000 10750376016 11131056128 1807254288 18.073 100 79 159 1 1842088112 12909200 21924624
14:06:20 2812 8192000000 10753064368 11137363968 1819314368 18.172 100 81 162 0 1855327072 13954208 22058496
14:06:30 1864 8192000000 10764573392 11148996608 1822834208 18.201 100 79 160 0 1858568576 13607280 22127088
14:06:38 1646 8192000000 10775225168 11159977984 1835133552 18.301 100 90 176 1 1872324288 12463360 24727376
14:06:46 1731 8192000000 10784700800 11167240192 1836717504 18.314 100 93 185 1 1876776576 13868576 26190496
14:06:54 1790 8192000000 10780233264 11169820672 1850647648 18.427 100 90 177 1 1887788928 12900544 24240736
14:07:03 1537 8192000000 10791092624 11174891520 1846512032 18.394 100 90 181 1 1884542912 12792096 25238784
14:07:11 1897 8192000000 10789026768 11174146048 1849488144 18.418 100 89 178 3 1888482752 13722672 25271936
14:07:19 1561 8192000000 10804940368 11188097024 1857102240 18.480 100 97 194 1 1898911200 15396768 26412192
14:07:27 1122 8192000000 10806109568 11191582720 1855109568 18.464 100 88 177 2 1894686896 14318864 25258464
14:07:34 1377 8192000000 10804673360 11191758848 1860578640 18.508 100 90 181 2 1898543824 13035776 24929408
14:07:42 1482 8192000000 10805470688 11193552896 1862594176 18.524 100 93 185 2 1902474192 13232432 26647584
14:07:50 1234 8192000000 10807317536 11197681664 1866045056 18.552 100 91 183 1 1904188496 11645344 26498096
14:07:58 33708 8192000000 10801361920 11202351104 1864667408 18.541 100 54 108 1 1890094240 9005600 16421232
14:08:38 3736 8192000000 10784589136 11204198400 1869963040 18.584 100 46 92 1 1893006400 10158944 12884416
14:08:51 6380 8192000000 10777924384 11201462272 1868681056 18.574 100 37 75 0 1886272736 7327728 10263952
14:09:04 4975 8192000000 10782193136 11207708672 1872615408 18.605 100 30 60 0 1889211072 8430592 8165072
14:09:15 3826 8192000000 10800459088 11217182720 1876573024 18.637 100 38 76 1 1894678448 7744032 10361392
14:09:25 5790 8192000000 10787616608 11211952128 1877705232 18.647 100 31 62 0 1894443088 7924480 8813376
14:09:37 7003 8192000000 10798858384 11217063936 1878801264 18.655 100 24 46 2 1891660064 5654640 7204160
14:09:53 10664 8192000000 10780478480 11215650816 1878332688 18.652 100 18 35 1 1889392768 6373360 4686720
14:10:12 5435 8192000000 10790531984 11219939328 1883263840 18.691 100 33 66 1 1899684192 6459760 9960592
14:10:25 9378 8192000000 10785956688 11222478848 1880080848 18.666 100 17 33 2 1891083328 5610800 5391680
14:10:41 8660 8192000000 10791588000 11221950464 1887943584 18.729 100 30 58 0 1902940720 7029200 7967936
14:10:57 16333 8192000000 10795744096 11226177536 1888035360 18.730 100 14 28 1 1897516544 5627728 3853456
14:11:22 52177 8192000000 10808380000 11238035456 1889010768 18.738 100 20 40 2 1900138512 4942656 6185088
14:12:21 33423 8192000000 10811899168 11237801984 1893609440 18.775 100 26 52 2 1908073360 5957024 8506896
14:13:00 5586 8192000000 10820507120 11247669248 1898773760 18.816 100 32 65 2 1914348656 6947200 8627696
14:13:13 6645 8192000000 10819353120 11251441664 1902153824 18.844 100 31 61 2 1917214624 6657728 8403072
14:13:28 5630 8192000000 10822813648 11253469184 1903621632 18.855 100 33 66 1 1919558176 6604880 9331664
14:13:42 6046 8192000000 10821990864 11259072512 1907399728 18.886 100 29 59 1 1925883264 10479280 8004256
14:13:57 4481 8192000000 10821055536 11256733696 1906955360 18.882 100 22 45 0 1919188272 6254832 5978080
14:14:07 5479 8192000000 10827435712 11259179008 1908630416 18.896 100 27 54 1 1923374544 6043824 8700304
14:14:22 6660 8192000000 10817868784 11250180096 1890049680 18.746 99 18 36 0 1900552256 5713376 4789200
14:14:35 8483 8192000000 10820709664 11257561088 1906044688 18.875 100 20 40 0 1917614944 6052704 5517552
14:14:51 9927 8192000000 10811751536 11249934336 1886749760 18.720 99 25 50 1 1899247840 5416464 7081616
14:15:10 11381 8192000000 10825130112 11260575744 1905863024 18.873 100 16 33 0 1915441600 5123904 4454672
14:15:28 11083 8192000000 10818463840 11256754176 1907031904 18.883 100 19 38 2 1917563936 5341232 5190800
14:15:45 12873 8192000000 10822470448 11252674560 1891215120 18.756 99 24 49 3 1908358816 9696896 7446800
14:16:07 9885 8192000000 10803524784 11239268352 1880254768 18.667 99 14 26 0 1890027248 6093344 3679136
14:16:24 56974 8192000000 10842235776 11245748224 1885983392 18.713 99 48 94 0 1905804064 6200016 13620656
14:17:27 8229 8192000000 10806849344 11240984576 1863457104 18.531 98 26 52 1 1877934192 7148224 7328864
14:17:42 6651 8192000000 10784354672 11220353024 1822201008 18.196 96 20 40 3 1833515792 6185552 5129232
14:17:57 6818 8192000000 10779204176 11200749568 1823093920 18.203 98 37 73 4 1840861536 6992672 10774944
14:18:11 7060 8192000000 10779108416 11203928064 1845649344 18.387 99 39 76 3 1864255312 7683792 10922176
14:18:24 5133 8192000000 10775405968 11194994688 1852906400 18.446 100 47 94 3 1874997952 9076960 13014592
14:18:38 5390 8192000000 10756801136 11180044288 1824767184 18.217 99 32 65 1 1840510400 6953856 8789360
14:18:52 4338 8192000000 10711531568 11120443392 1748894256 17.592 96 35 69 0 1770720880 12682960 9143664
14:19:03 3491 8192000000 10741615712 11157430272 1806899616 18.070 99 46 92 1 1828577088 8668448 13009024
14:19:12 6520 8192000000 10719523552 11143987200 1768912928 17.758 97 28 56 0 1784171952 7270256 7988768
14:19:25 4225 8192000000 10715573376 11140042752 1781524816 17.862 98 26 52 0 1794556464 5407888 7623760
14:19:39 10266 8192000000 10719259696 11127652352 1725792672 17.400 95 33 65 3 1741046176 5269568 9983936
14:19:55 16559 8192000000 10729519008 11159355392 1796819920 17.988 99 13 26 1 1806090128 5347744 3922464
14:20:19 7159 8192000000 10703638912 11115757568 1741653728 17.532 96 28 55 2 1755419712 5605888 8160096
14:20:33 48283 8192000000 10714842832 11141488640 1778469808 17.837 98 25 50 1 1791138848 5695776 6973264
14:21:28 30445 8192000000 10718863184 11137912832 1783629792 17.879 98 21 42 1 1795425376 5517376 6278208
14:22:07 8183 8192000000 10716790336 11135463424 1790302672 17.934 99 23 46 4 1802979824 6033344 6643808
14:22:22 5369 8192000000 10712915472 11131297792 1781971408 17.866 98 32 64 1 1798160592 6736160 9453024
14:22:38 11698 8192000000 10739883792 11157815296 1808444848 18.083 99 26 52 0 1822184336 6264048 7475440
14:23:00 8188 8192000000 10745942016 11167850496 1818038816 18.162 99 29 58 1 1832887664 6595344 8253504
14:23:15 9446 8192000000 10747183104 11169579008 1833747360 18.290 100 20 40 1 1845804032 5956560 6100112
14:23:31 13288 8192000000 10757357136 11184168960 1840980944 18.349 100 14 27 1 1850380928 5327616 4072368
14:23:50 7983 8192000000 10751512560 11181330432 1828416736 18.246 99 23 47 4 1840866816 5857216 6592864
14:24:06 8539 8192000000 10755212320 11188166656 1848133216 18.407 100 19 38 3 1859216112 6058336 5024560
14:24:21 9668 8192000000 10761334496 11193241600 1851489056 18.434 100 32 65 1 1867368496 5992096 9887344
14:24:39 9636 8192000000 10771913456 11198996480 1853704160 18.452 100 25 48 3 1867884416 6670992 7509264
14:24:57 7935 8192000000 10766705520 11199356928 1857329808 18.482 100 20 38 0 1867942176 5144080 5468288
14:25:13 3896 8192000000 10784836320 11207938048 1866193584 18.553 100 41 80 1 1883943104 6180944 11568576
14:25:27 58514 8192000000 10774335680 11208019968 1860869232 18.510 100 25 50 0 1872718784 4616416 7233136
14:26:36 9870 8192000000 10797283616 11217760256 1868400496 18.571 100 29 58 1 1882063792 5637056 8026240
14:26:55 7319 8192000000 10794291376 11218743296 1869088640 18.577 100 36 68 2 1889338192 11195296 9054256
14:27:13 20967 8192000000 10821912256 11238825984 1892122480 18.763 100 52 103 3 1915120384 7154960 15842944
14:27:54 1761 8192000000 10845492576 11256688640 1906243184 18.876 100 56 106 1 1930830448 9311568 15275696
14:28:04 3490 8192000000 10856597488 11267158016 1914214160 18.940 100 63 123 3 1947338848 15464848 17659840
14:28:17 12486 8192000000 10856240368 11276165120 1917479040 18.967 100 50 100 0 1942781168 11087184 14214944
14:28:37 7050 8192000000 10869599040 11284234240 1929937952 19.066 100 51 100 0 1955057872 11304160 13815760
14:28:53 8327 8192000000 10873569344 11294334976 1938082192 19.131 100 51 103 1 1965076144 12124528 14869424
14:29:10 29875 8192000000 10873146288 11301982208 1941549296 19.159 100 52 104 2 1968967328 12131024 15287008
14:29:52 45008 8192000000 10883340768 11320537088 1952318080 19.245 100 41 82 3 1979853088 15002992 12532016
14:31:08 46328 8192000000 10879664528 11317956608 1939332368 19.141 99 46 88 3 1968540512 16152736 13055408
14:32:01 15812 8192000000 10886474768 11321208832 1950998640 19.234 100 41 82 3 1979267680 16716928 11552112
14:32:27 36815 8192000000 10888417280 11330654208 1953678432 19.256 100 37 74 3 1982172240 17398256 11095552
14:33:10 5590 8192000000 10897556976 11331915776 1960660560 19.311 100 37 73 2 1985100912 13511232 10929120
14:33:25 4251 8192000000 10917465936 11328737280 1959788976 19.304 100 53 107 1 1989763392 14684128 15290288
14:33:37 8786 8192000000 10903979264 11326672896 1945407728 19.190 99 72 144 0 1983901712 17939280 20554704
14:33:54 8301 8192000000 10906853824 11330469888 1961962880 19.322 100 58 117 1 1996647760 17990752 16694128
14:34:12 13976 8192000000 10921380640 11347652608 1968793808 19.376 100 59 116 1 2004369376 18030672 17544896
14:34:33 4837 8192000000 10932296864 11359780864 1979910848 19.464 100 62 124 2 2016704960 17898480 18895632
14:34:44 7089 8192000000 10923461872 11344957440 1973278432 19.411 100 69 134 2 2011331024 17910784 20141808
14:34:59 12529 8192000000 10933089280 11349110784 1981126960 19.474 100 57 114 0 2017044496 19340768 16576768
14:35:19 13773 8192000000 10924801248 11339436032 1966444736 19.357 99 71 142 3 2008168672 21424688 20299248
14:35:43 1803 8192000000 10958781312 11372740608 1992823808 19.566 100 93 186 2 2048175296 28472864 26878624
14:35:52 7962 8192000000 10950279984 11367858176 1989431200 19.539 100 78 154 3 2035061088 23486656 22143232
14:36:07 2453 8192000000 10950260096 11370463232 1990583504 19.548 100 78 155 0 2036798240 23311264 22903472
14:36:17 4780 8192000000 10952704640 11376566272 1995120816 19.584 100 74 148 4 2040529952 23682624 21726512
14:36:31 1412 8192000000 10948885984 11368701952 1990360336 19.547 100 80 158 0 2037366976 24136096 22870544
14:36:40 3096 8192000000 10959448592 11380760576 1994516624 19.579 100 77 154 3 2039967280 23431168 22019488
14:36:50 7819 8192000000 10953222336 11376537600 1995808384 19.590 100 69 136 0 2041272144 25322240 20141520
14:37:06 5304 8192000000 10947243920 11369156608 1993523056 19.572 100 77 154 4 2041767616 25460528 22784032
14:37:21 7338 8192000000 10925208432 11359047680 1971501904 19.397 99 51 101 2 2010509136 23399216 15608016
14:37:39 4756 8192000000 10953549440 11380723712 1990704848 19.549 100 52 103 1 2029381344 22919632 15756864
14:37:50 6536 8192000000 10965449888 11390951424 1999162128 19.616 100 61 122 1 2047018400 29255216 18601056
14:38:08 6695 8192000000 10959121312 11380277248 1996458048 19.595 100 74 147 1 2045464304 26288768 22717488
14:38:23 10469 8192000000 10940627472 11362566144 1974416816 19.420 99 57 109 0 2016415392 25458816 16539760
14:38:53 15645 8192000000 10941709696 11378913280 1993480624 19.571 100 47 94 1 2029719824 21327376 14911824
14:39:19 19483 8192000000 10929737088 11366080512 1967093344 19.362 99 50 100 1 2005936352 22918528 15924480
14:39:51 6378 8192000000 10931112832 11363569664 1971354304 19.396 99 59 118 1 2014939648 25995536 17589808
14:40:09 10012 8192000000 10937459152 11365396480 1965033120 19.346 99 65 130 2 2010914064 25844592 20036352
14:40:26 1550 8192000000 10960528464 11380822016 1994325728 19.578 100 85 170 0 2046664848 25981616 26357504
14:40:35 4853 8192000000 10944456672 11359948800 1973938192 19.417 100 84 166 1 2027765200 27900096 25926912
14:40:49 2968 8192000000 10919390064 11331399680 1945961888 19.194 99 75 150 3 1997740704 28450752 23328064
14:41:00 3732 8192000000 10935310624 11355533312 1969024000 19.378 100 79 158 0 2023030208 29560768 24445440
14:41:14 3565 8192000000 10937751312 11353116672 1954684016 19.264 99 79 157 2 2010246896 30482880 25080000
14:41:26 2623 8192000000 10930731600 11348152320 1954974992 19.266 100 75 150 0 2012380208 33910112 23495104
14:41:36 3756 8192000000 10915950240 11336843264 1949728192 19.224 100 74 148 2 2001291408 29190064 22373152
14:41:50 3757 8192000000 10929189568 11348180992 1942892912 19.170 99 77 149 1 1995934960 30260928 22781120
14:42:00 2236 8192000000 10932880928 11351740416 1965629760 19.351 100 87 171 2 2022999632 31871568 25498304
14:42:14 3512 8192000000 10878117232 11300204544 1917331136 18.965 98 58 115 0 1957633312 23420736 16881440
14:42:26 3674 8192000000 10903990272 11315400704 1919926912 18.986 98 69 139 2 1965547632 24694304 20926416
14:42:39 3102 8192000000 10915594176 11328270336 1948897648 19.218 100 70 139 2 1996795664 25749520 22148496
14:42:53 2647 8192000000 10893129552 11300900864 1929323952 19.061 100 87 173 1 1981491840 26259504 25908384
14:43:09 5947 8192000000 10907968688 11323826176 1945610128 19.191 100 67 133 0 1992583536 26884672 20088736
14:43:23 3327 8192000000 10898834224 11308240896 1930154256 19.068 99 83 164 2 1986116352 29866592 26095504
14:43:39 4500 8192000000 10926564704 11342184448 1950730064 19.232 100 70 140 2 2007331072 34362864 22238144
14:43:53 2832 8192000000 10936195632 11349553152 1962044592 19.322 100 73 146 2 2014632608 29880736 22707280
14:44:02 2813 8192000000 10923884256 11332407296 1938932752 19.138 99 83 164 0 1993899680 29608704 25358224
14:44:12 1722 8192000000 10927821152 11331682304 1940895728 19.154 99 85 170 1 1997443744 30606848 25941168
14:44:20 3099 8192000000 10913251648 11319828480 1928454048 19.055 99 86 172 0 1986963920 31911792 26598080
14:44:30 1717 8192000000 10942382736 11342528512 1951452896 19.238 100 93 182 3 2011929296 32704944 27771456
14:44:42 1876 8192000000 10927120880 11332202496 1940597504 19.152 100 87 173 2 1999836672 32599840 26639328
14:44:52 2359 8192000000 10928561616 11338948608 1949265088 19.221 100 80 158 1 2008818256 34800400 24752768
14:45:03 2537 8192000000 10925827408 11334049792 1944401232 19.182 100 84 167 2 2005681024 35736800 25542992
14:45:12 3323 8192000000 10929457136 11348180992 1955788928 19.273 100 86 169 2 2018620128 36832368 25998832
14:45:22 7108 8192000000 10930097808 11360886784 1959644608 19.303 100 54 108 0 2017968752 41285552 17038592
14:45:40 6604 8192000000 10912785216 11348910080 1947969248 19.210 100 35 70 2 1993262848 33932000 11361600
14:45:54 7349 8192000000 10914709696 11344805888 1953008592 19.250 100 44 85 1 1998254896 31759008 13487296
14:46:08 4204 8192000000 10926316560 11345920000 1956871904 19.281 100 67 132 1 2011016128 34105744 20038480
14:46:21 3604 8192000000 10918715920 11342032896 1951366640 19.237 100 63 126 0 2007111408 36280704 19464064
14:46:32 8085 8192000000 10922720320 11351437312 1956826192 19.281 100 53 106 0 2012315984 38452848 17036944
14:46:47 19487 8192000000 10907951968 11331731456 1918359824 18.974 98 42 84 0 1971927648 39360368 14207456
14:47:15 2837 8192000000 10934953024 11346382848 1936631408 19.120 99 78 157 2 1996676512 34778784 25266320
14:47:28 4957 8192000000 10928896832 11349684224 1954942288 19.266 100 63 126 1 2012207440 37267536 19997616
14:47:40 10219 8192000000 10890950592 11321176064 1928075168 19.051 99 40 80 0 1978846160 37681424 13089568
14:47:56 8752 8192000000 10916100800 11346264064 1947455808 19.206 100 36 71 1 1995135440 35890768 11788864
14:48:15 7197 8192000000 10938053232 11359526912 1965120112 19.347 100 74 146 1 2022539248 34715760 22703376
14:48:31 1665 8192000000 10968898144 11377340416 1980522528 19.469 100 92 183 2 2050264128 40773680 28967920
14:48:41 1570 8192000000 10960559536 11365949440 1968340768 19.372 100 90 182 0 2038177920 41467264 28369888
14:48:50 3721 8192000000 10941162464 11359059968 1961002640 19.314 100 66 132 0 2023715760 41937744 20775376
14:49:04 6093 8192000000 10937659664 11362680832 1960477072 19.310 100 56 110 2 2019215360 41413216 17325072
14:49:21 1481 8192000000 10962490432 11365191680 1964044688 19.338 100 95 190 0 2037486800 43661424 29780688
14:49:29 4124 8192000000 10923760240 11335602176 1933049136 19.091 99 69 138 4 2000361344 45585040 21727168
14:49:44 2662 8192000000 10919122288 11338690560 1933211152 19.093 100 63 125 1 1998818400 45311616 20295632
14:49:56 6920 8192000000 10912525008 11348094976 1941808064 19.161 100 53 106 1 2004846176 45969824 17068288
14:50:16 30363 8192000000 10897763808 11340427264 1911791584 18.921 98 41 82 0 1969763424 44169952 13801888
14:51:00 9336 8192000000 10907668400 11343482880 1938584240 19.135 100 36 72 1 1990123136 39629152 11909744
14:51:17 14068 8192000000 10902644192 11344207872 1942024128 19.163 100 27 54 1 1990134176 39063952 9046096
14:51:42 13066 8192000000 10908663328 11353526272 1948368528 19.213 100 28 54 2 1994948224 38031600 8548096
14:52:03 34666 8192000000 10922096320 11357237248 1951713536 19.240 100 40 78 2 2002077216 37452752 12910928
14:52:48 11908 8192000000 10924079952 11362902016 1947581760 19.207 100 45 90 1 2006163632 44189920 14391952
14:53:08 11172 8192000000 10895033472 11351977984 1931608000 19.080 100 22 44 1 1982119312 42632480 7878832
14:54:01 52935 8192000000 10890234784 11361239040 1939749504 19.145 100 24 48 3 1982587168 34224848 8612816
14:55:22 23877 8192000000 10858302240 11330445312 1889713872 18.743 98 9 18 1 1919552400 27215904 2622624
14:56:18 22426 8192000000 10884087616 11342422016 1938509344 19.135 100 21 42 0 1971118496 26460384 6148768
14:56:47 42588 8192000000 10886823216 11344150528 1941934016 19.162 100 15 30 1 1969752192 23285152 4533024
14:57:36 41629 8192000000 10908994048 11349037056 1956485200 19.278 100 31 63 0 1984988816 19019136 9484480
14:58:25 12962 8192000000 10912066608 11358031872 1962439568 19.325 100 23 46 1 1985718704 16739840 6539296
14:58:58 12789 8192000000 10909602784 11359166464 1968440544 19.373 100 27 53 3 1996630240 20117456 8072240
14:59:18 57173 8192000000 10910518416 11361128448 1970121776 19.386 100 24 48 1 1998069264 20390848 7556640
15:00:22 60483 8192000000 10898130848 11355119616 1934275728 19.101 98 40 82 0 1967986736 21416224 12294784
15:01:58 19361 8192000000 10894315776 11358318592 1958332128 19.293 100 22 44 1 1988237088 22937776 6967184
15:02:25 17781 8192000000 10896163152 11354988544 1960394032 19.309 100 17 34 0 1988926080 23326016 5206032
15:02:50 29474 8192000000 10893232528 11348979712 1942417824 19.166 99 12 24 1 1962269984 16010688 3841472
15:03:31 32989 8192000000 10909375008 11356708864 1967798224 19.368 100 19 37 0 1988510816 15872352 4840240
15:04:48 78059 8192000000 10914214592 11366486016 1963719952 19.336 99 33 66 4 1986641040 13844544 9076544
15:06:13 72381 8192000000 10904626080 11373875200 1958984928 19.298 99 15 30 1 1985758992 22157280 4616784
15:07:56 56037 8192000000 10878088448 11360567296 1945719008 19.192 99 8 16 0 1964094272 15639312 2735952
15:09:05 18559 8192000000 10924785408 11363934208 1976944608 19.441 100 45 93 0 1998520096 9578512 11996976
15:09:33 61348 8192000000 10914784112 11380006912 1984190848 19.498 100 32 64 1 2008755552 15058736 9505968
15:11:00 2604 8192000000 10937846128 11381260288 1993037616 19.568 100 58 117 3 2022334512 12554960 16741936
15:11:24 81349 8192000000 10903162992 11376119808 1946421008 19.198 98 15 30 0 1966392256 15000656 4970592
15:13:39 87683 8192000000 10925459936 11376910336 1969115952 19.378 99 44 88 1 1990533120 9019520 12397648
15:15:14 36295 8192000000 10910102816 11375161344 1992123680 19.561 100 46 92 1 2015412416 10282624 13006112
15:15:58 85861 8192000000 10894953696 11355107328 1949364400 19.221 98 22 43 0 1961880080 6500352 6015328
15:17:59 12777 8192000000 10923466480 11372408832 1983869408 19.495 100 43 87 0 2006415600 9543200 13002992
15:18:19 21183 8192000000 10916078160 11382005760 1993088448 19.568 100 32 64 1 2013439440 11028832 9322160
15:18:48 57864 8192000000 10914795904 11362123776 1969693456 19.383 99 33 67 0 1992955680 13021056 10241168
15:20:05 61465 8192000000 10899446608 11378696192 1967932896 19.369 99 26 52 0 1985670944 9984176 7753872
15:21:12 55661 8192000000 10909161040 11383320576 1988179920 19.529 100 8 16 1 2000796912 10543328 2073664
15:22:25 48152 8192000000 10889928816 11375341568 1965086864 19.346 99 6 12 0 1982500512 15398768 2014880
15:23:40 88485 8192000000 10865789504 11340181504 1876599456 18.638 95 17 34 1 1888218480 6727200 4891824
15:26:27 86592 8192000000 10863894896 11336527872 1929257280 19.061 99 11 22 0 1946081232 13459056 3364896
15:28:50 58596 8192000000 10849212272 11319803904 1882896912 18.688 96 16 32 1 1899140128 11888048 4355168
15:29:56 81451 8192000000 10881283152 11350851584 1906251712 18.877 97 19 38 2 1928019568 16169360 5598496
15:31:23 33001 8192000000 10884689232 11348586496 1914322880 18.941 97 32 64 2 1940575712 17111360 9141472
15:32:10 52735 8192000000 10871475744 11343663104 1896432400 18.798 97 21 42 0 1925122464 22311600 6378464
15:34:20 45342 8192000000 10898024560 11354599424 1941242800 19.157 99 32 63 1 1963296416 13160144 8893472
15:35:17 28207 8192000000 10886106496 11342569472 1952387776 19.245 100 32 61 1 1971352688 10161680 8803232
15:35:51 76252 8192000000 10876923184 11338821632 1884021984 18.698 96 27 55 2 1903308448 11887936 7398528
15:37:14 66768 8192000000 10869003552 11330646016 1868605648 18.573 96 24 48 0 1886682544 11264080 6812816
15:38:41 69351 8192000000 10853788752 11322761216 1869957200 18.584 96 23 46 2 1894623744 17973664 6692880
15:39:57 59704 8192000000 10857313040 11319619584 1877496944 18.645 97 9 18 0 1894525472 14988448 2040080
15:41:04 29259 8192000000 10891342928 11348656128 1930238624 19.069 99 23 46 2 1949383264 12618976 6525664
15:41:46 114184 8192000000 10859565184 11321782272 1855524560 18.467 96 8 16 0 1874161568 16716880 1920128
15:43:48 89428 8192000000 10849064336 11307782144 1887138400 18.723 98 23 46 0 1902998048 9279568 6580080
15:45:27 89476 8192000000 10854505504 11316658176 1908561872 18.895 98 26 52 0 1929634416 13405536 7667008
15:47:06 18501 8192000000 10866540736 11337900032 1944613488 19.184 100 16 30 4 1960035040 10278512 5143040
15:47:47 24824 8192000000 10865988080 11335200768 1949821024 19.225 100 35 70 1 1967081136 7114128 10145984
15:48:18 59432 8192000000 10846970448 11315208192 1854011152 18.455 95 9 17 1 1863377616 7083280 2283184
15:49:24 70782 8192000000 10856264976 11321737216 1904305616 18.861 98 15 30 1 1918002992 9593152 4104224
15:50:47 74955 8192000000 10851053984 11324866560 1921897776 19.002 99 16 32 1 1940629072 13428192 5303104
15:52:52 59000 8192000000 10848321632 11317747712 1878591440 18.654 97 17 34 1 1893891904 10488496 4811968
15:54:02 73661 8192000000 10842293488 11315224576 1886075632 18.714 98 11 22 1 1899308048 10093584 3138832
15:55:33 49096 8192000000 10864713536 11308486656 1895839376 18.793 98 35 69 1 1916536192 12090048 8606768
15:56:30 53004 8192000000 10855946032 11321438208 1911697536 18.920 99 16 32 1 1925150592 9012064 4440992
15:57:29 30269 8192000000 10896631680 11333005312 1921584928 19.000 98 44 87 1 1949702112 15493744 12623440
15:58:07 46375 8192000000 10930238048 11381608448 1974960464 19.425 100 36 72 1 2007713248 22550576 10202208
15:59:04 90523 8192000000 10894628864 11387166720 1951620000 19.239 99 18 36 0 1989910480 32654208 5636272
16:00:47 99259 8192000000 10893169824 11355615232 1930842512 19.074 98 8 16 0 1946802384 13806352 2153520
16:02:38 48172 8192000000 10906360016 11368161280 1958519200 19.294 99 16 32 1 1970760688 7878656 4362832
16:03:33 74390 8192000000 10905028624 11383992320 1975202752 19.427 100 12 25 1 1991475040 12880528 3391760
16:04:53 82227 8192000000 10903728880 11355389952 1924355536 19.022 97 27 54 2 1943661136 11696784 7608816
16:06:26 25486 8192000000 10936299696 11374923776 1978411808 19.452 100 63 125 0 2011056256 15268144 17376304
16:07:00 89005 8192000000 10926275040 11381583872 1987527072 19.524 100 52 104 0 2017300016 15147856 14625088
16:08:51 39133 8192000000 10883201616 11344695296 1937589456 19.128 98 5 10 1 1948251712 9083616 1578640
16:09:37 46206 8192000000 10879614304 11361239040 1974652608 19.422 100 28 56 0 1991242848 8426800 8163440
16:10:30 53331 8192000000 10884635200 11364896768 1958230112 19.292 99 8 16 0 1968639952 8308992 2100848
16:11:46 69588 8192000000 10906462192 11377967104 1972590352 19.406 100 13 26 0 1990801440 14637776 3573312
16:13:12 69968 8192000000 10892212624 11366973440 1948226016 19.212 98 13 26 0 1962416512 10574544 3615952
16:14:28 61749 8192000000 10910478016 11367051264 1939179216 19.140 98 24 48 1 1959704784 14096848 6428720
16:15:37 61222 8192000000 10885126752 11358871552 1951914800 19.242 99 10 20 0 1964186208 9422992 2848416
16:16:54 62336 8192000000 10893358272 11373322240 1958870544 19.297 99 20 40 2 1975282544 10110688 6301312
16:18:12 44534 8192000000 10872702176 11346599936 1900307664 18.829 96 12 23 2 1911459840 8013696 3138480
16:19:04 44078 8192000000 10882551392 11349442560 1953525648 19.255 100 16 31 2 1966480048 8451424 4502976
16:19:54 43013 8192000000 10878548192 11344105472 1920736528 18.993 98 15 30 1 1934925328 9411200 4777600
16:20:44 37912 8192000000 10888946896 11348824064 1927233984 19.045 98 31 60 3 1946640736 10875648 8531104
16:21:28 39502 8192000000 10866323024 11329900544 1865138720 18.545 95 29 58 2 1881138816 8053520 7946576
16:22:23 37645 8192000000 10841534144 11288924160 1836551136 18.313 95 24 48 2 1854329952 10758512 7020304
16:23:09 33216 8192000000 10839055344 11290501120 1876719264 18.639 98 28 56 0 1894887280 10590496 7577520
16:23:50 32585 8192000000 10866946032 11323367424 1925128496 19.028 100 36 71 1 1946164224 10691264 10344464
16:24:32 24276 8192000000 10890891968 11334713344 1938519856 19.135 100 43 87 2 1967475872 16654784 12301232
16:25:02 22075 8192000000 10893938496 11340091392 1927055248 19.043 99 46 91 0 1957509712 17784912 12669552
16:26:11 59342 8192000000 9230396128 9482891264 370925344 4.331 20 2 2 1 376369136 4884112 559680

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 15-11-2020 16:28:05 to 15-11-2020 16:28:37.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 111 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-11-2020 16:28:38 to 15-11-2020 16:28:40.

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          236336
MON$OLDEST_ACTIVE               236672
MON$OLDEST_SNAPSHOT             236672
MON$NEXT_TRANSACTION            236672
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                       2032992
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 ---
:118: 
:119: mscs-test-161.budzdorov.ru    Sun Nov 15 16:27:19 2020
:120:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:121: 
--- end of diff output ---

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

15.11.20 16:28:41. 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-15 16:28:43 No severe PSQL-related problems occured
15.11.20 16:28:45. End of report.