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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17305892 kB
MemAvailable 31635344 kB
Buffers 0 kB
Cached 14397560 kB
SwapCached 0 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 2021-03-09 01:27:21
DTS_END                         2021-03-09 01:27:21.7000
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/42914
TRN_ID                          247942
ATT_ID                          735
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: 9381.65 23105 1125798
customer order: creation 180.21 278 21625
customer order: refuse 14.78 365 1773
order to supplier: creation 48.22 1201 5786
order to supplier: removal 3.53 104948 424
invoice (draft): creation 48.28 3419 5794
invoice (draft): removal 50.71 854 6085
invoice accept: apply 44.07 18746 5288
invoice accept: cancel 46.68 771 5601
customer reserve: creation 4046.13 187 485535
customer reserve: removal 4598.29 62 551795
realization accept: apply 88.39 173 10607
realization accept: cancel 76.38 108 9165
payment from customer: creation 62.48 93 7497
payment from customer: removal 6.05 102 726
payment to supplier: creation 51.60 103 6192
payment to supplier: removal 3.59 72 431
service: total inventory turnovers 4.85 1258 582
service: total monetary turnovers 6.53 26 783
service: aggregate perf. data 0.88 20275 105
service: refresh index statistics 0.03 309057 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-03-2021 01:29:27 to 09-03-2021 01:29:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2536
TEST_TIME 2 4150
TEST_TIME 3 5557
TEST_TIME 4 6509
TEST_TIME 5 6702
TEST_TIME 6 6505
TEST_TIME 7 6610
TEST_TIME 8 6560
TEST_TIME 9 6700
TEST_TIME 10 6624
TEST_TIME 11 6844
TEST_TIME 12 7386
TEST_TIME 13 7305
TEST_TIME 14 7184
TEST_TIME 15 7301
TEST_TIME 16 7432
TEST_TIME 17 7573
TEST_TIME 18 7696
TEST_TIME 19 7936
TEST_TIME 20 8134
TEST_TIME 21 8566
TEST_TIME 22 8429
TEST_TIME 23 9063
TEST_TIME 24 9251
TEST_TIME 25 9295
TEST_TIME 26 9565
TEST_TIME 27 9982
TEST_TIME 28 10743
TEST_TIME 29 11137
TEST_TIME 30 11013
TEST_TIME 31 10923
TEST_TIME 32 10844
TEST_TIME 33 10988
TEST_TIME 34 10987
TEST_TIME 35 10811
TEST_TIME 36 10716
TEST_TIME 37 10464
TEST_TIME 38 10450
TEST_TIME 39 10514
TEST_TIME 40 10292
TEST_TIME 41 10235
TEST_TIME 42 10186
TEST_TIME 43 10119
TEST_TIME 44 10107
TEST_TIME 45 10229
TEST_TIME 46 10201
TEST_TIME 47 10115
TEST_TIME 48 9982
TEST_TIME 49 9905
TEST_TIME 50 10124
TEST_TIME 51 10026
TEST_TIME 52 10140
TEST_TIME 53 10091
TEST_TIME 54 10077
TEST_TIME 55 10078
TEST_TIME 56 10133
TEST_TIME 57 10077
TEST_TIME 58 10066
TEST_TIME 59 10078
TEST_TIME 60 10009
TEST_TIME 61 10005
TEST_TIME 62 10159
TEST_TIME 63 10232
TEST_TIME 64 10100
TEST_TIME 65 10053
TEST_TIME 66 9979
TEST_TIME 67 9970
TEST_TIME 68 9931
TEST_TIME 69 9881
TEST_TIME 70 9922
TEST_TIME 71 9854
TEST_TIME 72 9804
TEST_TIME 73 9798
TEST_TIME 74 9751
TEST_TIME 75 9693
TEST_TIME 76 9767
TEST_TIME 77 9756
TEST_TIME 78 9703
TEST_TIME 79 9764
TEST_TIME 80 9730
TEST_TIME 81 9820
TEST_TIME 82 9768
TEST_TIME 83 9718
TEST_TIME 84 9752
TEST_TIME 85 9781
TEST_TIME 86 9755
TEST_TIME 87 9768
TEST_TIME 88 9824
TEST_TIME 89 9809
TEST_TIME 90 9876
TEST_TIME 91 9849
TEST_TIME 92 9755
TEST_TIME 93 9729
TEST_TIME 94 9675
TEST_TIME 95 9685
TEST_TIME 96 9630
TEST_TIME 97 9590
TEST_TIME 98 9563
TEST_TIME 99 9497
TEST_TIME 100 9503
TEST_TIME 101 9569
TEST_TIME 102 9544
TEST_TIME 103 9568
TEST_TIME 104 9574
TEST_TIME 105 9588
TEST_TIME 106 9560
TEST_TIME 107 9548
TEST_TIME 108 9578
TEST_TIME 109 9552
TEST_TIME 110 9553
TEST_TIME 111 9573
TEST_TIME 112 9553
TEST_TIME 113 9645
TEST_TIME 114 9663
TEST_TIME 115 9588
TEST_TIME 116 9545
TEST_TIME 117 9496
TEST_TIME 118 9472
TEST_TIME 119 9445
TEST_TIME 120 9383

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 09-03-2021 01:29:30 to 09-03-2021 01:29:34.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1574744 1574744 0 0.00 0 11114 6 0 0
doc_list_biud 1574744 1574744 0 0.00 0 39162 28 0 0
sp_add_invoice_to_stock 5401 5288 113 2.09 22 197874 18747 0 113
sp_cancel_adding_invoice 5601 5601 0 0.00 6 53138 772 0 0
sp_cancel_client_order 1773 1773 0 0.00 5 15204 365 0 0
sp_cancel_customer_reserve 551795 551795 0 0.00 1 39163 63 0 0
sp_cancel_pay_from_customer 726 726 0 0.00 3 5658 103 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 3 2167 73 0 0
sp_cancel_supplier_invoice 6096 6085 11 0.18 1 16593 854 0 11
sp_cancel_supplier_order 424 424 0 0.00 5 1148967 104948 0 0
sp_cancel_write_off 9165 9165 0 0.00 1 9042 109 0 0
sp_client_order 21625 21625 0 0.00 3 20148 278 0 0
sp_customer_reserve 485535 485535 0 0.00 0 46335 188 0 0
sp_fill_shopping_cart 33195 33195 0 0.00 1 14667 41 0 0
sp_fill_shopping_cart_clo_res 485532 485532 0 0.00 0 15867 11 0 0
sp_get_clo_for_invoice 5285 5285 0 0.00 0 21989 264 0 0
sp_kill_cost_storno 15923 15923 0 0.00 0 6503 57 0 0
sp_kill_qstorno_ret_qs2qd 1119264 1119264 0 0.00 0 39159 34 0 0
sp_kill_qty_storno 590735 590735 0 0.00 0 39162 73 0 0
sp_lock_selected_doc 21791 21791 0 0.00 0 10549 4 0 0
sp_make_cost_storno 29581 29581 0 0.00 0 10928 45 0 0
sp_multiply_rows_for_pdistr 29581 29581 0 0.00 0 4635 25 0 0
sp_multiply_rows_for_qdistr 21625 21625 0 0.00 0 8270 108 0 0
sp_pay_from_customer 7497 7497 0 0.00 4 18960 94 0 0
sp_pay_to_supplier 6192 6192 0 0.00 4 11120 103 0 0
sp_payment_common 13689 13689 0 0.00 1 4524 21 0 0
sp_qd_handle_on_cancel_clo 1773 1773 0 0.00 0 15198 331 0 0
sp_qd_handle_on_invoice_upd_sts 10886 10886 0 0.00 0 19617 345 0 0
sp_qd_handle_on_reserve_upd_sts 10607 10607 0 0.00 0 15933 67 0 0
sp_reserve_write_off 10607 10607 0 0.00 6 15949 174 0 0
sp_supplier_invoice 5794 5794 0 0.00 7 80510 3420 0 0
sp_supplier_order 5786 5786 0 0.00 5 28757 1202 0 0
srv_aggregate_perf_data 105 105 0 0.00 2117 424892 20275 0 0
srv_fill_mon_cache_memory 177 177 0 0.00 934 182381 29247 0 0
srv_find_qd_qs_mism 1075323 1075323 0 0.00 0 9142 6 0 0
srv_make_invnt_saldo 582 582 0 0.00 38 87503 1258 0 0
srv_make_money_saldo 783 783 0 0.00 1 1665 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 176663 522557 309057 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5288 5288 0 0.00 0 9770 191 0 0
t$perf-norm:sp_cancel_adding_invoice 436 436 0 0.00 1 6003 105 0 0
t$perf-norm:sp_cancel_client_order 1773 1773 0 0.00 0 4013 18 0 0
t$perf-norm:sp_cancel_customer_reserve 681 681 0 0.00 0 2780 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 726 726 0 0.00 0 958 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 139 1 0 0
t$perf-norm:sp_cancel_supplier_invoice 390 390 0 0.00 0 2417 27 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 23513 1654 0 0
t$perf-norm:sp_cancel_write_off 1038 1038 0 0.00 0 2045 12 0 0
t$perf-norm:sp_client_order 21625 21625 0 0.00 0 19182 24 0 0
t$perf-norm:sp_customer_reserve 1043 1043 0 0.00 0 330 2 0 0
t$perf-norm:sp_pay_from_customer 7497 7497 0 0.00 0 5463 11 0 0
t$perf-norm:sp_pay_to_supplier 6192 6192 0 0.00 0 5279 13 0 0
t$perf-norm:sp_reserve_write_off 10607 10607 0 0.00 0 22625 17 0 0
t$perf-norm:sp_supplier_invoice 5794 5794 0 0.00 0 4072 16 0 0
t$perf-norm:sp_supplier_order 5786 5786 0 0.00 0 3871 19 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 741 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 177 177 0 0.00 0 208 3 0 0
t$perf-norm:srv_make_invnt_saldo 582 582 0 0.00 0 1312 27 0 0
t$perf-norm:srv_make_money_saldo 783 783 0 0.00 0 833 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 65 19 0 0
v_add_invoice_to_stock 10796 10570 226 2.09 0 3567 18 0 226
v_all_customers 38942 38942 0 0.00 0 22 1 0 0
v_all_suppliers 32166 32166 0 0.00 0 117 1 0 0
v_all_wares 43250 43250 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 872 872 0 0.00 0 116 5 0 0
v_cancel_client_order 3546 3546 0 0.00 0 8044 10 0 0
v_cancel_customer_prepayment 1452 1452 0 0.00 0 4039 10 0 0
v_cancel_customer_reserve 1362 1362 0 0.00 0 3562 8 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 2148 9 0 0
v_cancel_supplier_invoice 802 780 22 2.74 0 1822 19 0 22
v_cancel_supplier_order 848 848 0 0.00 0 2044 8 0 0
v_cancel_write_off 2076 2076 0 0.00 0 6277 19 0 0
v_max_id_clo_ord 5786 5786 0 0.00 0 1385 2 0 0
v_max_id_clo_res 1043 1043 0 0.00 0 3301 13 0 0
v_max_id_ord_sup 5784 5784 0 0.00 0 6069 5 0 0
v_max_non_paid_invoice 1679 1679 0 0.00 0 423 3 0 0
v_max_non_paid_realizn 4313 4313 0 0.00 0 1505 4 0 0
v_min_id_clo_ord 5786 5786 0 0.00 0 1953 6 0 0
v_min_id_clo_res 1043 1043 0 0.00 0 4505 18 0 0
v_min_id_ord_sup 5784 5784 0 0.00 0 5897 10 0 0
v_min_non_paid_invoice 6192 6192 0 0.00 0 4291 13 0 0
v_min_non_paid_realizn 7497 7497 0 0.00 0 4514 11 0 0
v_our_firm 10676 10676 0 0.00 0 53 1 0 0
v_reserve_write_off 21214 21214 0 0.00 0 8661 8 0 0
x_lock_depdocs_on_canc_invoice 11296 11296 0 0.00 0 18045 137 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 15196 384 0 0
x_make_qstorno_1000_1200 5786 5786 0 0.00 2 28751 1118 0 0
x_make_qstorno_1200_2000 5794 5794 0 0.00 4 78986 3268 0 0
x_make_qstorno_2100_3300 485535 485535 0 0.00 0 46333 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-03-2021 01:29:35 to 09-03-2021 01:29:39.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:25 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:31 6831 8192000000 10018197888 10288758784 768822464 8.579 63 45 95 0 785706080 1920576 14963040
22:57:47 39984 8192000000 10334489760 10646355968 1369321632 14.321 100 91 182 0 1403370496 4479168 29569696
22:58:46 16113 8192000000 10368496672 10688049152 1419892064 14.772 100 94 188 0 1457384416 6702144 30790208
22:59:21 32621 8192000000 10396139872 10719748096 1443437536 14.980 100 89 178 1 1481206400 8182256 29586608
23:00:03 23905 8192000000 10408596736 10737029120 1461376640 15.138 100 87 174 0 1498442928 8510336 28555952
23:00:38 16290 8192000000 10430232064 10762997760 1482988816 15.328 100 91 182 0 1521871552 9094224 29788512
23:01:05 13489 8192000000 10448564880 10784428032 1499416880 15.471 100 84 168 1 1536098544 9618496 27063168
23:01:33 17511 8192000000 10488215440 10835374080 1536941184 15.797 100 85 170 1 1573800208 9941328 26917696
23:02:03 14527 8192000000 10512688688 10861215744 1572943856 16.108 100 85 169 0 1610090736 11348672 25798208
23:02:25 17049 8192000000 10532334272 10889494528 1589607216 16.250 100 76 154 0 1623376624 11069072 22700336
23:02:52 15352 8192000000 10561303600 10913226752 1621144528 16.520 100 83 166 0 1657971616 11661984 25165104
23:03:16 10801 8192000000 10583669440 10944942080 1643872032 16.713 100 85 170 0 1681726096 12371040 25483024
23:03:34 10292 8192000000 10608355408 10974048256 1666035760 16.900 100 83 166 0 1702638080 11987296 24615024
23:03:53 9923 8192000000 10620893120 10985844736 1680429024 17.021 100 81 163 1 1717371520 12959552 23982944
23:04:12 6495 8192000000 10635383424 11003748352 1698448064 17.172 100 82 162 3 1734261232 12211824 23601344
23:04:25 7072 8192000000 10645253584 11016982528 1706900864 17.243 100 73 146 0 1741112496 12243408 21968224
23:04:40 8727 8192000000 10662649696 11035779072 1723129472 17.378 100 77 155 0 1757659520 12659024 21871024
23:04:58 5355 8192000000 10691429152 11062726656 1747133360 17.578 100 82 162 1 1784136992 13208704 23794928
23:05:12 4878 8192000000 10696903408 11074461696 1756659808 17.657 100 87 173 3 1795852528 14303472 24889248
23:05:24 5801 8192000000 10701674288 11082375168 1765491248 17.730 100 82 162 1 1802274976 13042912 23740816
23:05:37 3404 8192000000 10720808880 11097903104 1776871712 17.824 100 73 146 0 1810616352 12585600 21159040
23:05:47 3318 8192000000 10719183936 11104595968 1786909440 17.906 100 80 157 1 1821054976 12325280 21820256
23:05:56 3960 8192000000 10736310784 11117096960 1794239200 17.967 100 80 155 3 1829702880 13627728 21835952
23:06:06 4049 8192000000 10743253632 11122778112 1801416656 18.026 100 86 170 0 1839212560 13994960 23800944
23:06:17 9671 8192000000 10735916800 11123367936 1805512976 18.059 100 79 158 2 1840725792 13557840 21654976
23:06:33 4459 8192000000 10762023152 11145437184 1810566848 18.101 100 83 166 0 1848479440 13590096 24322496
23:06:44 2282 8192000000 10769336448 11153702912 1825522480 18.223 100 89 179 0 1863958224 13508704 24927040
23:06:53 2192 8192000000 10766466000 11152707584 1826557392 18.231 100 89 178 3 1866097584 14616688 24923504
23:07:01 1829 8192000000 10776682272 11160268800 1832520160 18.280 100 91 183 1 1871696784 13495264 25681360
23:07:10 2006 8192000000 10783564976 11165437952 1835677888 18.306 100 97 194 0 1877718816 15107504 26933424
23:07:18 1373 8192000000 10787412880 11171049472 1842697792 18.363 100 92 185 2 1883131072 15119120 25314160
23:07:26 1516 8192000000 10798360544 11185344512 1851475312 18.434 100 92 185 5 1891010592 13455248 26080032
23:07:34 2038 8192000000 10802904240 11191664640 1862331216 18.522 100 93 187 1 1902189600 14182768 25675616
23:07:42 1961 8192000000 10805989280 11191607296 1861443264 18.515 100 94 188 0 1902278016 14661568 26173184
23:07:50 1863 8192000000 10808437440 11195486208 1865076288 18.544 100 92 184 2 1905088432 13604416 26407728
23:07:59 1512 8192000000 10807142592 11196981248 1868082928 18.569 100 94 189 1 1908469248 13394880 26991440
23:08:06 40891 8192000000 10797296192 11198173184 1862334256 18.522 100 70 138 2 1892628816 10583424 19711136
23:08:53 1341 8192000000 10791399104 11199373312 1863057584 18.528 100 63 126 3 1892408224 11481680 17868960
23:09:03 3200 8192000000 10783461792 11197624320 1863248496 18.530 100 46 92 0 1885457120 9404704 12803920
23:09:14 7982 8192000000 10777622048 11196895232 1860525696 18.508 100 31 63 1 1877504752 7955360 9023696
23:09:29 5149 8192000000 10784654768 11201138688 1864615968 18.541 100 32 64 1 1880768896 7572512 8580416
23:09:42 9917 8192000000 10785433904 11206111232 1868859632 18.575 100 31 64 1 1883966656 6730336 8376688
23:09:59 4474 8192000000 10788294400 11208671232 1870413552 18.588 100 35 70 0 1888630048 7889248 10327248
23:10:11 6219 8192000000 10775398224 11206967296 1870223328 18.586 100 26 52 3 1884304432 7005792 7075312
23:10:25 8625 8192000000 10778848816 11208765440 1871190928 18.594 100 25 50 2 1885276672 6732640 7353104
23:10:41 4234 8192000000 10781751504 11209961472 1871681040 18.598 100 19 38 0 1882644080 5893936 5069104
23:10:56 9017 8192000000 10783667344 11212005376 1877012448 18.641 100 26 53 0 1893751760 9731696 7007616
23:11:13 15124 8192000000 10776719488 11216318464 1876280192 18.635 100 14 28 0 1886162368 5767632 4114544
23:11:34 9542 8192000000 10787772944 11223527424 1879265952 18.659 100 21 40 2 1891548528 6042432 6240144
23:11:50 17403 8192000000 10793529920 11219197952 1880156384 18.666 100 27 55 1 1894211872 6005008 8050480
23:12:16 54964 8192000000 10839189312 11235938304 1887864048 18.729 100 61 121 1 1911064064 5424816 17775200
23:13:18 5687 8192000000 10796621648 11230535680 1887364048 18.725 100 35 70 0 1905725488 8659232 9702208
23:13:31 8222 8192000000 10803813552 11235688448 1888767104 18.736 100 33 65 0 1904612912 6959360 8886448
23:13:47 5799 8192000000 10809290144 11237044224 1890214848 18.748 100 29 58 2 1905581104 7545744 7820512
23:13:59 4149 8192000000 10816400304 11240124416 1894077408 18.779 100 41 80 0 1913672304 8140464 11454432
23:14:13 6897 8192000000 10814913744 11242037248 1897745488 18.808 100 35 70 2 1914826832 7667632 9413712
23:14:26 4300 8192000000 10822184464 11248119808 1899229904 18.820 100 38 77 0 1918757184 8559936 10967344
23:14:37 6152 8192000000 10813184784 11246981120 1900349744 18.829 100 46 92 1 1920815248 6895904 13569600
23:14:53 2945 8192000000 10830353776 11247394816 1902451984 18.846 100 47 94 2 1921615376 5899456 13263936
23:15:03 7406 8192000000 10817221456 11249061888 1898410640 18.814 100 29 59 1 1913382352 6908880 8062832
23:15:17 6085 8192000000 10812823008 11249995776 1897612928 18.807 100 16 32 2 1912858432 10577856 4667648
23:15:31 7634 8192000000 10809369856 11248021504 1901166000 18.836 100 22 44 1 1912968928 5435296 6367632
23:15:47 10136 8192000000 10798955072 11241353216 1894517968 18.782 100 14 28 2 1904260304 5986736 3755600
23:16:05 6209 8192000000 10813105856 11249549312 1902397968 18.846 100 22 44 2 1914717504 5747200 6572336
23:16:18 9770 8192000000 10801427536 11237425152 1863084016 18.528 98 21 42 1 1874849120 5737456 6027648
23:16:40 69133 8192000000 10758419888 11190960128 1762466256 17.705 93 31 63 1 1776174896 4995472 8713168
23:17:56 14700 8192000000 10737672208 11169599488 1769720976 17.765 95 13 26 2 1779210320 5477072 4012272
23:18:17 7629 8192000000 10716890112 11139342336 1720561952 17.357 93 28 56 0 1734651616 5200944 8888720
23:18:33 4803 8192000000 10734736992 11153915904 1811368240 18.107 99 31 61 2 1827623280 6767312 9487728
23:18:45 9177 8192000000 10733837200 11153408000 1750194976 17.603 95 24 49 3 1761952256 5312048 6445232
23:19:01 6703 8192000000 10679476320 11089391616 1679273936 17.011 93 15 30 3 1688346608 4819088 4253584
23:19:18 7085 8192000000 10670212288 11083362304 1693268048 17.129 95 30 60 2 1707797712 6108032 8421632
23:19:35 8929 8192000000 10681182992 11094593536 1717655440 17.333 97 19 38 1 1727732128 4779360 5297328
23:19:50 7781 8192000000 10710843568 11124523008 1791142944 17.941 100 34 67 2 1807621056 5588784 10889328
23:20:07 8140 8192000000 10711743104 11128324096 1767321840 17.745 98 21 41 1 1778967712 5756640 5889232
23:20:24 6116 8192000000 10709576560 11123871744 1737286448 17.496 96 36 72 1 1755038640 7181536 10570656
23:20:39 11547 8192000000 10706602608 11124502528 1712666176 17.291 95 23 46 1 1724837760 5636672 6534912
23:20:58 6764 8192000000 10721863088 11138953216 1791806176 17.947 99 22 44 0 1804953632 6181712 6965744
23:21:11 17733 8192000000 10712553088 11131371520 1731496864 17.448 96 10 20 0 1739251184 4983360 2770960
23:21:35 67844 8192000000 10692627472 11115597824 1722430864 17.372 95 35 70 0 1737871664 5464000 9976800
23:22:51 13095 8192000000 10731493312 11154534400 1819377104 18.173 100 28 56 0 1833199120 5927776 7894240
23:23:11 8132 8192000000 10757544064 11172880384 1829874912 18.258 100 35 69 1 1849766288 10854720 9036656
23:23:26 5559 8192000000 10747594592 11175661568 1834714912 18.298 100 26 51 1 1849970560 7671344 7584304
23:23:40 7742 8192000000 10761215280 11181158400 1843111584 18.366 100 31 62 1 1858608080 5756512 9739984
23:23:54 8300 8192000000 10749965616 11178639360 1842056128 18.358 100 28 56 1 1856710112 5959088 8694896
23:24:09 5922 8192000000 10748172144 11181649920 1841783392 18.355 100 14 28 1 1851531616 6111968 3636256
23:24:21 5410 8192000000 10757010576 11186921472 1849286192 18.416 100 26 53 5 1863370208 5988320 8095696
23:24:32 9020 8192000000 10763709856 11191148544 1853624176 18.452 100 18 36 0 1863980800 5608096 4748528
23:24:48 11168 8192000000 10768589328 11197714432 1853468640 18.450 100 17 34 1 1864289568 5754112 5066816
23:25:05 12165 8192000000 10773066624 11199787008 1859006432 18.495 100 22 43 3 1870536976 5353520 6177024
23:25:24 11979 8192000000 10772560592 11201679360 1859569360 18.500 100 21 40 2 1871653712 5921328 6163024
23:25:44 10463 8192000000 10766908272 11202809856 1861085056 18.512 100 13 26 0 1871272624 6158768 4028800
23:26:09 11911 8192000000 10779457168 11211554816 1866340736 18.555 100 11 22 0 1875523584 5417264 3765584
23:26:27 11701 8192000000 10781015888 11217211392 1870520096 18.588 100 9 17 1 1877930560 5202496 2207968
23:26:47 56711 8192000000 10796356848 11229487104 1878782528 18.655 100 19 39 1 1889662800 5191712 5688560
23:27:54 32455 8192000000 10821517024 11250495488 1900939152 18.834 100 43 83 1 1918764080 5212304 12612624
23:28:37 17779 8192000000 10834811856 11262771200 1914466576 18.942 100 34 68 2 1930237920 6291520 9479824
23:29:04 4207 8192000000 10855175728 11276210176 1923679296 19.016 100 61 116 2 1949156736 8652560 16824880
23:29:18 4555 8192000000 10880186512 11294777344 1934556160 19.103 100 81 161 2 1967613536 10449696 22607680
23:29:31 9775 8192000000 10872039472 11293093888 1936595216 19.120 100 61 120 0 1964774032 11440688 16738128
23:29:50 5506 8192000000 10880120528 11299467264 1938938576 19.138 100 61 122 1 1967042976 11324144 16780256
23:30:04 2612 8192000000 10879114432 11303612416 1943101504 19.171 100 63 125 4 1972046224 11349600 17595120
23:30:15 12552 8192000000 10879492832 11300634624 1947151808 19.204 100 66 131 1 1978305888 12196368 18957712
23:30:38 14482 8192000000 10884045968 11313483776 1946513248 19.199 100 50 100 1 1972104112 11538080 14052784
23:31:09 3384 8192000000 10906761152 11322134528 1956726032 19.280 100 62 124 1 1986363632 11599888 18037712
23:31:19 5813 8192000000 10908309056 11328974848 1962145344 19.323 100 63 126 0 1993023504 12426224 18451936
23:31:40 1652 8192000000 10918675744 11331489792 1971418432 19.397 100 84 168 4 2005382208 10604784 23358992
23:31:48 15973 8192000000 10901129072 11332464640 1968303088 19.372 100 54 106 2 1995712448 11668528 15740832
23:32:14 12110 8192000000 10920639536 11352150016 1974216384 19.419 100 52 105 0 2006944080 18573136 14154560
23:32:36 5389 8192000000 10929739264 11355975680 1982119856 19.481 100 53 106 0 2013334640 15899200 15315584
23:32:49 12883 8192000000 10923171584 11353616384 1986083936 19.513 100 55 110 0 2018064368 15933712 16046720
23:33:10 8792 8192000000 10922382096 11359268864 1992478000 19.563 100 56 109 2 2024349520 15621856 16249664
23:33:28 5868 8192000000 10930302128 11359993856 1987011216 19.520 100 59 118 2 2020917040 16785728 17120096
23:33:42 35251 8192000000 10921160272 11355717632 1982826928 19.487 100 48 96 1 2014905104 18030336 14047840
23:34:25 11258 8192000000 10928825440 11366617088 1988142480 19.529 100 49 97 1 2024355488 20908656 15304352
23:34:46 2373 8192000000 10944425312 11377467392 1999849472 19.622 100 75 148 2 2043495888 19441920 24204496
23:34:55 15303 8192000000 10930922976 11368521728 1975347968 19.428 99 57 114 0 2013344672 21416256 16580448
23:35:18 4331 8192000000 10939414800 11369713664 1989720928 19.542 100 53 104 1 2025512224 20681472 15109824
23:35:31 7269 8192000000 10937160064 11374727168 1994454032 19.579 100 53 106 1 2031652176 20641872 16556272
23:35:47 3823 8192000000 10953995984 11377922048 1996185712 19.593 100 57 111 1 2034256640 21184784 16886144
23:35:58 19663 8192000000 10944415200 11379814400 1979813200 19.463 99 54 107 0 2020470768 24105360 16552208
23:36:25 3938 8192000000 10950579488 11382362112 1997382416 19.602 100 62 124 0 2041608096 25334352 18891328
23:36:38 6747 8192000000 10952952432 11385929728 2002020080 19.639 100 64 128 1 2045627936 24132208 19475648
23:36:51 4238 8192000000 10967312928 11393396736 2001534976 19.635 100 55 110 1 2043626544 24211904 17879664
23:37:07 4206 8192000000 10961172064 11395002368 2004395152 19.657 100 64 127 1 2050084448 26329600 19359696
23:37:20 6642 8192000000 10935469552 11364982784 1966753568 19.360 99 76 151 3 2017010480 27614576 22642336
23:37:45 15664 8192000000 10913630480 11339358208 1932341600 19.086 98 63 123 1 1979239344 27833088 19064656
23:38:17 10617 8192000000 10922789888 11351277568 1946254416 19.197 99 63 126 1 1995035024 29769088 19011520
23:38:43 12487 8192000000 10898023984 11339948032 1937796944 19.129 99 41 82 2 1981144864 29975776 13372144
23:39:05 4213 8192000000 10906770800 11317960704 1933102352 19.092 99 62 120 1 1980961072 28827280 19031440
23:39:16 4212 8192000000 10908347104 11322822656 1930788480 19.073 99 68 135 3 1981346480 29940368 20617632
23:39:28 6327 8192000000 10913069856 11335974912 1948003536 19.211 99 74 148 0 1999824576 29393952 22427088
23:39:44 5383 8192000000 10916663568 11348176896 1959760592 19.304 100 59 118 1 2005849872 27853504 18235776
23:39:57 7061 8192000000 10941588800 11363880960 1975020560 19.425 100 76 152 1 2026088544 28447264 22620720
23:40:20 11656 8192000000 10928483536 11363536896 1970280848 19.388 100 57 114 0 2017675728 29596512 17798368
23:40:40 8065 8192000000 10920712400 11350593536 1940043792 19.147 98 55 110 1 1988036944 30580304 17412848
23:41:01 2083 8192000000 10922813328 11344375808 1938759456 19.137 99 62 122 3 1991671120 34780224 18131440
23:41:10 5213 8192000000 10937026864 11355467776 1966327888 19.356 100 81 157 2 2021770496 30955392 24487216
23:41:23 4443 8192000000 10928509264 11350437888 1959712528 19.304 100 68 134 0 2011985040 31705824 20566688
23:41:35 3120 8192000000 10935584880 11349254144 1951628976 19.239 99 79 156 1 2007409568 31725712 24054880
23:41:45 3800 8192000000 10937700800 11358097408 1970108480 19.386 100 80 160 2 2026120848 32638448 23373920
23:41:57 3158 8192000000 10950757936 11361501184 1967676976 19.367 100 86 168 2 2027185024 33868608 25639440
23:42:10 3402 8192000000 10942464816 11364352000 1973456944 19.413 100 70 138 2 2027951632 33714160 20780528
23:42:22 2095 8192000000 10939686400 11348217856 1959668048 19.303 99 85 171 1 2018220288 34142640 24409600
23:42:31 2962 8192000000 10925906448 11329540096 1937764992 19.129 99 81 160 2 1996878336 35086400 24026944
23:42:43 4462 8192000000 10942596352 11349499904 1955512688 19.270 100 84 168 1 2015597712 34945696 25139328
23:43:02 2496 8192000000 10925781536 11337945088 1949984480 19.226 100 80 159 0 2011164592 36192448 24987664
23:43:11 2335 8192000000 10929963008 11340169216 1941593264 19.159 99 89 178 1 2007052960 37895296 27564400
23:43:22 3975 8192000000 10933720160 11345534976 1950164384 19.228 100 76 151 4 2013451824 39310272 23977168
23:43:33 3857 8192000000 10948502400 11363426304 1965943440 19.353 100 84 168 2 2032854288 41147248 25763600
23:43:47 3986 8192000000 10955050320 11370074112 1974763632 19.423 100 79 157 1 2039174256 40043984 24366640
23:44:04 3419 8192000000 10969082256 11375845376 1977907136 19.448 100 86 174 1 2044026848 39149136 26970576
23:44:16 4809 8192000000 10966842848 11383336960 1985530608 19.508 100 77 154 1 2048542224 38816944 24194672
23:44:31 3616 8192000000 10959660544 11381870592 1985244960 19.506 100 67 132 0 2043231184 36907776 21078448
23:44:41 2998 8192000000 10980095312 11394052096 1999651024 19.620 100 91 181 2 2065976432 38249312 28076096
23:44:51 6911 8192000000 10975481408 11393527808 1993333648 19.570 100 83 166 1 2059401312 40254496 25813168
23:45:06 1981 8192000000 10985992096 11402760192 2003904608 19.654 100 83 166 0 2070731136 41301920 25524608
23:45:15 5318 8192000000 10980947328 11397914624 1994335712 19.578 100 82 164 1 2062374176 42391024 25647440
23:45:27 3919 8192000000 10973699440 11384815616 1987868624 19.527 100 88 170 1 2053452704 39917936 25666144
23:45:37 3695 8192000000 10975886672 11393921024 1991942592 19.559 100 86 172 1 2062679696 43827728 26909376
23:45:47 3943 8192000000 10962555072 11371536384 1966180416 19.355 99 88 176 2 2038208464 44548352 27479696
23:45:58 4857 8192000000 10987201888 11399757824 1989806800 19.542 100 83 166 2 2062799664 46600832 26392032
23:46:11 2774 8192000000 10987892944 11407331328 1995285808 19.586 100 85 169 0 2071319952 48565024 27469120
23:46:22 984 8192000000 10989348560 11397234688 1985631376 19.509 99 97 193 1 2064968576 49391216 29945984
23:46:31 2052 8192000000 10968860224 11375165440 1950643568 19.232 98 91 181 1 2029489872 50208880 28637424
23:46:39 3766 8192000000 10968141520 11378765824 1971440992 19.397 100 91 182 3 2052321200 51748496 29131712
23:46:50 4446 8192000000 10960475728 11379675136 1972554320 19.406 100 73 145 1 2043017936 47556192 22907424
23:47:02 2083 8192000000 10938567616 11345371136 1935631680 19.112 98 87 172 1 2013193312 49920672 27640960
23:47:11 1600 8192000000 10944340256 11354349568 1943515248 19.175 99 83 167 1 2016188480 47000784 25672448
23:47:21 3148 8192000000 10960020048 11369639936 1962028784 19.322 100 87 171 2 2037589024 48136704 27423536
23:47:32 4070 8192000000 10973350192 11383513088 1973687264 19.415 100 86 172 1 2049996192 49951088 26357840
23:47:44 2837 8192000000 10974164320 11384664064 1971917632 19.401 100 88 174 1 2050188192 50686400 27584160
23:47:55 3739 8192000000 10965742032 11382935552 1969730128 19.383 100 80 160 0 2047961568 52040112 26191328
23:48:06 7872 8192000000 10958612976 11384201216 1968227392 19.371 100 55 110 1 2038076848 51667888 18181568
23:48:20 2572 8192000000 10955742832 11377532928 1966674848 19.359 100 62 124 2 2036713824 50501888 19537088
23:48:32 1458 8192000000 10955788864 11379552256 1968946688 19.377 100 67 134 1 2041430832 51548128 20936016
23:48:41 5892 8192000000 10947186896 11376930816 1962530736 19.326 100 53 105 0 2034709120 55072336 17106048
23:48:54 4322 8192000000 10935681600 11364081664 1957864480 19.289 100 50 99 1 2020873600 45898928 17110192
23:49:07 8054 8192000000 10944698656 11369652224 1949122416 19.219 99 63 124 3 2015976160 47232960 19620784
23:49:25 5675 8192000000 10946986736 11363123200 1949498192 19.222 99 67 133 0 2022064720 50851232 21715296
23:49:37 2690 8192000000 10970354944 11382763520 1970229536 19.387 100 82 163 2 2048414752 52232592 25952624
23:49:47 1618 8192000000 10983725920 11393396736 1975640176 19.430 100 84 166 1 2053949520 51817984 26491360
23:49:57 3380 8192000000 10973409216 11391107072 1973923728 19.417 100 76 153 0 2053914800 55948496 24042576
23:50:06 7912 8192000000 10959671408 11394162688 1974364064 19.420 100 53 106 1 2045847488 53369392 18114032
23:50:26 7033 8192000000 10934055312 11373002752 1936795872 19.121 98 38 76 2 1992310144 43147168 12367104
23:50:47 9469 8192000000 10938830848 11375550464 1961622928 19.319 100 36 72 1 2020037680 46231072 12183680
23:51:04 12692 8192000000 10936912672 11375661056 1958845920 19.297 100 30 60 1 2016104576 47251104 10007552
23:51:30 11912 8192000000 10946861296 11383623680 1949488384 19.222 99 37 75 0 2013516048 51774032 12253632
23:51:58 15861 8192000000 10923594752 11370033152 1952938704 19.250 100 34 68 0 2015028624 50650144 11439776
23:52:23 16261 8192000000 10907514976 11348385792 1910079392 18.907 98 27 54 0 1967652320 47001920 10571008
23:52:52 15971 8192000000 10912117776 11360604160 1934257360 19.101 100 28 56 0 1995675728 51049472 10368896
23:53:21 13300 8192000000 10900688768 11349774336 1926197712 19.036 100 28 56 1 1983846448 47583264 10065472
23:54:07 17079 8192000000 10901257632 11347763200 1927219136 19.045 100 27 54 2 1982909280 45911232 9778912
23:54:31 37939 8192000000 10894958112 11358502912 1912666112 18.928 99 21 42 0 1967215712 46451824 8097776
23:56:52 59591 8192000000 10882636112 11327578112 1898953136 18.818 98 30 56 2 1918343984 12375472 7015376
23:57:59 35133 8192000000 10903077824 11325952000 1934650368 19.104 99 43 85 0 1954860528 7492336 12717824
23:58:55 31328 8192000000 10874511328 11326066688 1923001680 19.011 98 13 26 1 1935787184 9239808 3545696
23:59:33 49854 8192000000 10884421216 11348373504 1920199856 18.988 99 11 22 3 1935684160 12280992 3203312
00:00:30 161301 8192000000 10906379008 11341467648 1879918336 18.664 96 11 22 1 1902982880 20602576 2461968
00:03:39 154576 8192000000 10896547856 11353534464 1948896432 19.218 99 28 56 0 1965384512 8724848 7763232
00:06:26 97303 8192000000 10882594608 11344138240 1929266688 19.061 98 31 62 1 1947721568 10097872 8357008
00:08:10 2353 8192000000 10895704912 11353800704 1958521968 19.294 100 29 58 1 1977245392 11029168 7694256
00:08:19 934 8192000000 10909423696 11354517504 1966706768 19.359 100 43 84 1 1989279296 10390736 12181792
00:08:26 4380 8192000000 10902884688 11349741568 1953551104 19.255 99 46 90 1 1977801648 10487760 13762784
00:08:44 51122 8192000000 10903253360 11366133760 1971870992 19.400 100 22 44 1 1988969856 10878848 6220016
00:09:42 38880 8192000000 10918690032 11367940096 1975025568 19.425 100 18 36 1 1994173824 12846016 6302240
00:10:29 33147 8192000000 10935756896 11383263232 1987336352 19.523 100 55 110 1 2017466544 14333248 15796944
00:11:15 46149 8192000000 10926168320 11386236928 1984516704 19.500 100 33 66 0 2012100832 17698528 9885600
00:12:33 44643 8192000000 10897000560 11374288896 1963540352 19.334 99 9 18 0 1978532752 12614976 2377424
00:14:03 74257 8192000000 10898289152 11365687296 1938211040 19.132 98 18 36 0 1953764544 10542752 5010752
00:15:58 67625 8192000000 10884958464 11372040192 1952950288 19.250 99 11 22 0 1974152848 17226896 3975664
00:17:22 56362 8192000000 10884654336 11359375360 1950242576 19.228 99 13 27 0 1971066000 16882368 3941056
00:18:31 45827 8192000000 10873397504 11322789888 1895734288 18.792 96 35 70 2 1918044848 12264944 10045616
00:19:29 106694 8192000000 10887145792 11373678592 1900852176 18.833 97 12 24 0 1924121296 19597184 3671936
00:21:26 37739 8192000000 10890589152 11357143040 1965002848 19.346 100 30 60 4 1980609168 7446288 8160032
00:22:18 28397 8192000000 10887573056 11350106112 1933558304 19.095 98 34 66 2 1954432032 11916656 8957072
00:22:53 52726 8192000000 10872521744 11341709312 1891699744 18.759 96 28 56 1 1908905120 9244208 7961168
00:24:04 42937 8192000000 10869079888 11319930880 1869428272 18.580 96 31 62 1 1886228384 7506016 9294096
00:24:59 17855 8192000000 10865115120 11315511296 1914538128 18.943 99 26 52 0 1929744512 8378976 6827408
00:25:55 30227 8192000000 10856690048 11320999936 1892789248 18.768 98 32 64 2 1916845232 14947504 9108480
00:27:01 15836 8192000000 10867217344 11313278976 1911985152 18.923 98 41 82 2 1933601792 10334112 11282528
00:27:24 62297 8192000000 10869557136 11322023936 1870450208 18.588 96 22 43 1 1890070880 13339760 6280912
00:28:33 52599 8192000000 10842812848 11305238528 1891427728 18.757 98 13 26 1 1909203664 14290496 3485440
00:29:32 80194 8192000000 10854613840 11319607296 1864109024 18.537 96 12 24 0 1885233104 17349696 3774384
00:30:59 114998 8192000000 10854883392 11328299008 1886793008 18.720 97 12 24 1 1898484880 8548784 3143088
00:33:07 86343 8192000000 10830866032 11286560768 1837860528 18.323 94 30 61 2 1857676560 10911216 8904816
00:35:25 54070 8192000000 10852802752 11324350464 1911812672 18.921 99 25 48 0 1933977920 15265072 6900176
00:36:29 68870 8192000000 10842432336 11313274880 1869096048 18.577 97 11 22 0 1890928768 18868784 2963936
00:37:45 50466 8192000000 10851773744 11309899776 1890051952 18.746 98 13 26 1 1906341088 12642416 3646720
00:38:41 42613 8192000000 10860012704 11328675840 1934417760 19.102 100 18 37 2 1954531536 14557872 5555904
00:39:30 72068 8192000000 10852975760 11322519552 1903134608 18.851 98 16 32 1 1924245424 16086768 5024048
00:41:21 77008 8192000000 10865522464 11330101248 1896437344 18.798 98 24 48 3 1921141056 17505456 7198256
00:42:56 28403 8192000000 10852383232 11338072064 1933747888 19.097 100 17 34 0 1957608720 18914032 4946800
00:43:45 72428 8192000000 10840265936 11318648832 1871358448 18.595 97 6 12 0 1886414832 13666032 1390352
00:45:04 44134 8192000000 10854049488 11323949056 1908702384 18.896 99 23 46 1 1925340016 9929184 6708448
00:45:54 82461 8192000000 10885596128 11352612864 1916847680 18.962 99 12 24 0 1937378336 17038080 3492576
00:47:26 55284 8192000000 10874441728 11353505792 1949042816 19.219 100 30 60 2 1971646656 14152784 8451056
00:48:27 50646 8192000000 10857166656 11316649984 1852300480 18.441 95 9 18 0 1866545984 11730080 2515424
00:49:26 24929 8192000000 10874449040 11335618560 1923789616 19.017 99 25 48 1 1937464064 6630128 7044320
00:50:00 25706 8192000000 10886210000 11332087808 1907072032 18.883 98 38 75 2 1926474464 9187664 10214768
00:50:34 11105 8192000000 10894706704 11340890112 1931107664 19.076 99 64 129 0 1960632384 12208624 17316096
00:50:59 11092 8192000000 10903970720 11351003136 1952846064 19.249 100 60 120 1 1983321680 13742544 16733072
00:51:18 47500 8192000000 10895873152 11352219648 1937593952 19.128 99 44 87 0 1963502416 13712464 12196000
00:52:14 77966 8192000000 10856780624 11331952640 1872004192 18.600 96 16 32 1 1887745472 11523104 4218176
00:53:39 32866 8192000000 10903248000 11355033600 1954766176 19.264 100 40 79 0 1974551776 8269856 11515744
00:54:22 75060 8192000000 10887608784 11383705600 1957388096 19.285 100 11 22 1 1978771200 18012496 3370608
00:55:45 51907 8192000000 10901321920 11369582592 1959603520 19.303 100 11 22 0 1976189136 13659088 2926528
00:56:44 131335 8192000000 10894983952 11377348608 1892330416 18.765 96 14 28 2 1910592416 15044448 3217552
00:59:08 124063 8192000000 10886045824 11372146688 1945640992 19.192 98 26 53 1 1964075488 10504576 7929920
01:01:23 12467 8192000000 10882983184 11371982848 1948855504 19.217 99 5 8 0 1959730016 10329648 544864
01:01:41 21143 8192000000 10885127488 11364093952 1950103184 19.227 99 26 50 2 1968645136 11597408 6944544
01:02:17 101597 8192000000 10886098640 11374186496 1940260128 19.149 98 13 26 0 1953607312 9928512 3418672
01:04:05 50032 8192000000 10885777520 11365552128 1936807392 19.121 98 12 24 0 1946547376 6290368 3449616
01:05:02 70248 8192000000 10889275920 11374202880 1937000624 19.123 98 13 26 0 1950573552 10032592 3540336
01:06:57 55734 8192000000 10883325984 11368853504 1919647392 18.984 97 12 24 2 1942143168 18781808 3713968
01:08:18 53698 8192000000 10883099040 11362783232 1923048272 19.011 98 24 48 1 1944479472 14252256 7178944
01:09:21 55779 8192000000 10922558336 11386224640 1978920768 19.456 100 42 84 0 2002050272 10560640 12568864
01:10:29 77389 8192000000 10888453008 11363241984 1926193056 19.036 97 33 66 1 1945224688 9448304 9583328
01:11:53 80674 8192000000 10885779472 11365629952 1914266688 18.941 97 18 36 0 1930151888 10585856 5299344
01:13:25 50376 8192000000 10904175888 11368493056 1891279232 18.756 96 22 43 0 1905085264 8088128 5717904
01:14:22 46388 8192000000 10893643680 11364765696 1951010384 19.235 99 29 56 0 1969241296 10742400 7488512
01:15:40 45325 8192000000 10886327984 11352940544 1904166640 18.860 97 8 16 0 1913417760 7020336 2230784
01:16:33 34052 8192000000 10895559072 11355873280 1928322224 19.053 98 39 78 1 1948467440 9552480 10592736
01:17:15 33467 8192000000 10896120896 11358765056 1940359632 19.150 99 35 70 1 1960177152 10009584 9807936
01:18:00 57143 8192000000 10879701904 11349041152 1948773264 19.217 100 20 40 0 1963974784 9723008 5478512
01:19:04 30293 8192000000 10892904864 11350790144 1902973152 18.850 97 21 42 0 1917093216 8607488 5512576
01:19:43 47586 8192000000 10875554720 11356876800 1926721840 19.041 99 16 32 1 1947683904 16480288 4481776
01:20:44 182380 8192000000 10843243120 11322011648 1794913584 17.972 93 8 16 0 1825929664 28700208 2315872
01:24:01 88775 8192000000 10821453568 11302281216 1848367488 18.409 96 20 40 1 1866763184 12472336 5923360
01:25:36 52505 8192000000 10825472960 11306983424 1891285648 18.756 99 9 18 1 1901093808 7136768 2671392
01:26:34 53251 8192000000 9166812080 9417723904 334749696 3.925 18 3 6 0 338444784 2835152 859936

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 09-03-2021 01:29:40 to 09-03-2021 01:30:13.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 113 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-03-2021 01:30:14 to 09-03-2021 01:30:16.

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          249301
MON$OLDEST_ACTIVE               249302
MON$OLDEST_SNAPSHOT             249302
MON$NEXT_TRANSACTION            249302
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                       2055840
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
--- end of diff output ---

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

09.03.21 01:30:17. 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
2021-03-09 01:30:19 No severe PSQL-related problems occured
09.03.21 01:30:21. End of report.