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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16795480 kB
MemAvailable 31143676 kB
Buffers 0 kB
Cached 14903020 kB
SwapCached 3892 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-02-20 19:27:15
DTS_END                         2021-02-20 19:27:15.6750
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58096
TRN_ID                          245555
ATT_ID                          653
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: 9558.84 16852 1147061
customer order: creation 177.72 349 21326
customer order: refuse 15.39 372 1847
order to supplier: creation 47.53 1246 5703
order to supplier: removal 3.26 109667 391
invoice (draft): creation 47.10 3171 5652
invoice (draft): removal 53.49 832 6419
invoice accept: apply 43.23 19715 5188
invoice accept: cancel 48.72 838 5846
customer reserve: creation 4084.43 191 490131
customer reserve: removal 4730.10 58 567612
realization accept: apply 86.52 186 10382
realization accept: cancel 89.65 118 10758
payment from customer: creation 60.18 134 7221
payment from customer: removal 5.85 67 702
payment to supplier: creation 49.78 147 5974
payment to supplier: removal 3.58 67 429
service: total inventory turnovers 4.79 1052 575
service: total monetary turnovers 6.69 34 803
service: aggregate perf. data 0.82 18532 98
service: refresh index statistics 0.03 180269 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-02-2021 19:29:11 to 20-02-2021 19:29:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4490
TEST_TIME 2 5821
TEST_TIME 3 6545
TEST_TIME 4 6770
TEST_TIME 5 6696
TEST_TIME 6 6382
TEST_TIME 7 6364
TEST_TIME 8 6353
TEST_TIME 9 6566
TEST_TIME 10 6618
TEST_TIME 11 6602
TEST_TIME 12 6609
TEST_TIME 13 6593
TEST_TIME 14 6708
TEST_TIME 15 7047
TEST_TIME 16 6873
TEST_TIME 17 6747
TEST_TIME 18 7042
TEST_TIME 19 6955
TEST_TIME 20 7073
TEST_TIME 21 7146
TEST_TIME 22 7793
TEST_TIME 23 7960
TEST_TIME 24 8241
TEST_TIME 25 8217
TEST_TIME 26 8794
TEST_TIME 27 9168
TEST_TIME 28 9885
TEST_TIME 29 10294
TEST_TIME 30 11098
TEST_TIME 31 10907
TEST_TIME 32 10704
TEST_TIME 33 10901
TEST_TIME 34 10794
TEST_TIME 35 10684
TEST_TIME 36 10774
TEST_TIME 37 10780
TEST_TIME 38 10787
TEST_TIME 39 10749
TEST_TIME 40 10594
TEST_TIME 41 10451
TEST_TIME 42 10367
TEST_TIME 43 10278
TEST_TIME 44 10260
TEST_TIME 45 10156
TEST_TIME 46 10164
TEST_TIME 47 10106
TEST_TIME 48 9989
TEST_TIME 49 10069
TEST_TIME 50 10169
TEST_TIME 51 10117
TEST_TIME 52 10032
TEST_TIME 53 10012
TEST_TIME 54 9996
TEST_TIME 55 10166
TEST_TIME 56 10129
TEST_TIME 57 10092
TEST_TIME 58 10074
TEST_TIME 59 10100
TEST_TIME 60 10128
TEST_TIME 61 10205
TEST_TIME 62 10173
TEST_TIME 63 10169
TEST_TIME 64 10132
TEST_TIME 65 10115
TEST_TIME 66 10239
TEST_TIME 67 10226
TEST_TIME 68 10193
TEST_TIME 69 10119
TEST_TIME 70 10041
TEST_TIME 71 10049
TEST_TIME 72 10013
TEST_TIME 73 9970
TEST_TIME 74 9935
TEST_TIME 75 9947
TEST_TIME 76 9931
TEST_TIME 77 9935
TEST_TIME 78 9854
TEST_TIME 79 9833
TEST_TIME 80 9768
TEST_TIME 81 9789
TEST_TIME 82 9816
TEST_TIME 83 9831
TEST_TIME 84 9819
TEST_TIME 85 9883
TEST_TIME 86 9900
TEST_TIME 87 9875
TEST_TIME 88 9918
TEST_TIME 89 9870
TEST_TIME 90 9874
TEST_TIME 91 9882
TEST_TIME 92 10012
TEST_TIME 93 9992
TEST_TIME 94 9990
TEST_TIME 95 9903
TEST_TIME 96 9912
TEST_TIME 97 9872
TEST_TIME 98 9843
TEST_TIME 99 9782
TEST_TIME 100 9778
TEST_TIME 101 9754
TEST_TIME 102 9691
TEST_TIME 103 9664
TEST_TIME 104 9640
TEST_TIME 105 9658
TEST_TIME 106 9632
TEST_TIME 107 9622
TEST_TIME 108 9651
TEST_TIME 109 9658
TEST_TIME 110 9665
TEST_TIME 111 9668
TEST_TIME 112 9640
TEST_TIME 113 9652
TEST_TIME 114 9644
TEST_TIME 115 9673
TEST_TIME 116 9694
TEST_TIME 117 9690
TEST_TIME 118 9650
TEST_TIME 119 9613
TEST_TIME 120 9560

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 20-02-2021 19:29:14 to 20-02-2021 19:29:18.

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 1597940 1597940 0 0.00 0 20077 7 0 0
doc_list_biud 1597938 1597938 0 0.00 0 32491 27 0 0
sp_add_invoice_to_stock 5274 5188 86 1.63 23 202815 19716 0 86
sp_cancel_adding_invoice 5846 5846 0 0.00 5 97398 838 0 0
sp_cancel_client_order 1847 1847 0 0.00 4 8557 372 0 0
sp_cancel_customer_reserve 567612 567612 0 0.00 1 19710 59 0 0
sp_cancel_pay_from_customer 702 702 0 0.00 3 2592 68 0 0
sp_cancel_pay_to_supplier 429 429 0 0.00 3 3211 67 0 0
sp_cancel_supplier_invoice 6427 6419 8 0.12 2 18129 832 0 8
sp_cancel_supplier_order 391 391 0 0.00 9 1223782 109668 0 0
sp_cancel_write_off 10758 10758 0 0.00 1 9115 119 0 0
sp_client_order 21326 21326 0 0.00 3 18243 350 0 0
sp_customer_reserve 490131 490131 0 0.00 0 61608 191 0 0
sp_fill_shopping_cart 32672 32672 0 0.00 1 17324 39 0 0
sp_fill_shopping_cart_clo_res 490126 490126 0 0.00 0 20174 14 0 0
sp_get_clo_for_invoice 5183 5183 0 0.00 0 31260 308 0 0
sp_kill_cost_storno 17735 17735 0 0.00 0 7364 57 0 0
sp_kill_qstorno_ret_qs2qd 1152792 1152792 0 0.00 0 19668 32 0 0
sp_kill_qty_storno 608437 608437 0 0.00 0 32488 70 0 0
sp_lock_selected_doc 21456 21456 0 0.00 0 8905 6 0 0
sp_make_cost_storno 28760 28760 0 0.00 0 20075 56 0 0
sp_multiply_rows_for_pdistr 28759 28759 0 0.00 0 8469 28 0 0
sp_multiply_rows_for_qdistr 21326 21326 0 0.00 0 18230 155 0 0
sp_pay_from_customer 7221 7221 0 0.00 4 23157 135 0 0
sp_pay_to_supplier 5974 5974 0 0.00 5 20093 148 0 0
sp_payment_common 13195 13195 0 0.00 1 23139 35 0 0
sp_qd_handle_on_cancel_clo 1847 1847 0 0.00 0 8541 335 0 0
sp_qd_handle_on_invoice_upd_sts 11028 11028 0 0.00 0 32483 339 0 0
sp_qd_handle_on_reserve_upd_sts 10382 10382 0 0.00 0 11677 57 0 0
sp_reserve_write_off 10382 10382 0 0.00 6 15821 187 0 0
sp_supplier_invoice 5652 5652 0 0.00 7 80947 3172 0 0
sp_supplier_order 5703 5703 0 0.00 5 21068 1247 0 0
srv_aggregate_perf_data 99 98 1 1.01 3490 200505 18533 0 1
srv_fill_mon_cache_memory 174 174 0 0.00 442 120153 30086 0 0
srv_find_qd_qs_mism 1096030 1096030 0 0.00 0 10815 6 0 0
srv_make_invnt_saldo 575 575 0 0.00 34 30652 1053 0 0
srv_make_money_saldo 803 803 0 0.00 1 5757 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 130038 241156 180270 0 0
t$perf-abend:sp_add_invoice_to_stock 86 86 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5188 5188 0 0.00 0 15987 186 0 0
t$perf-norm:sp_cancel_adding_invoice 410 410 0 0.00 0 2064 79 0 0
t$perf-norm:sp_cancel_client_order 1847 1847 0 0.00 0 3248 14 0 0
t$perf-norm:sp_cancel_customer_reserve 692 692 0 0.00 0 1089 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 702 702 0 0.00 0 2193 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 429 429 0 0.00 0 3052 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 404 404 0 0.00 0 1782 24 0 0
t$perf-norm:sp_cancel_supplier_order 391 391 0 0.00 0 19652 1615 0 0
t$perf-norm:sp_cancel_write_off 1017 1017 0 0.00 0 1199 7 0 0
t$perf-norm:sp_client_order 21326 21326 0 0.00 0 14246 19 0 0
t$perf-norm:sp_customer_reserve 1059 1059 0 0.00 0 15131 21 0 0
t$perf-norm:sp_pay_from_customer 7221 7221 0 0.00 0 3820 8 0 0
t$perf-norm:sp_pay_to_supplier 5974 5974 0 0.00 0 17007 12 0 0
t$perf-norm:sp_reserve_write_off 10382 10382 0 0.00 0 8588 11 0 0
t$perf-norm:sp_supplier_invoice 5652 5652 0 0.00 0 4235 17 0 0
t$perf-norm:sp_supplier_order 5703 5703 0 0.00 0 8551 20 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 341 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 62 1 0 0
t$perf-norm:srv_make_invnt_saldo 575 575 0 0.00 0 4246 27 0 0
t$perf-norm:srv_make_money_saldo 803 803 0 0.00 0 1337 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10536 10364 172 1.63 0 6123 21 0 172
v_all_customers 38564 38564 0 0.00 0 32 1 0 0
v_all_suppliers 30988 30988 0 0.00 0 18 1 0 0
v_all_wares 42652 42652 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 820 820 0 0.00 0 978 7 0 0
v_cancel_client_order 3694 3694 0 0.00 0 3947 9 0 0
v_cancel_customer_prepayment 1404 1404 0 0.00 0 2575 7 0 0
v_cancel_customer_reserve 1384 1384 0 0.00 0 4404 14 0 0
v_cancel_payment_to_supplier 858 858 0 0.00 0 3130 10 0 0
v_cancel_supplier_invoice 824 808 16 1.94 0 2546 19 0 16
v_cancel_supplier_order 782 782 0 0.00 0 5933 17 0 0
v_cancel_write_off 2034 2034 0 0.00 0 5365 19 0 0
v_max_id_clo_ord 5701 5701 0 0.00 0 2018 3 0 0
v_max_id_clo_res 1059 1059 0 0.00 0 2548 16 0 0
v_max_id_ord_sup 5645 5645 0 0.00 0 2291 3 0 0
v_max_non_paid_invoice 1826 1826 0 0.00 0 2998 4 0 0
v_max_non_paid_realizn 3873 3873 0 0.00 0 4226 5 0 0
v_min_id_clo_ord 5701 5701 0 0.00 0 3922 10 0 0
v_min_id_clo_res 1059 1059 0 0.00 0 9544 19 0 0
v_min_id_ord_sup 5645 5645 0 0.00 0 5153 8 0 0
v_min_non_paid_invoice 5974 5974 0 0.00 0 12469 21 0 0
v_min_non_paid_realizn 7221 7221 0 0.00 0 23134 28 0 0
v_our_firm 10784 10784 0 0.00 0 15 1 0 0
v_reserve_write_off 20764 20764 0 0.00 0 8211 8 0 0
x_lock_depdocs_on_canc_invoice 11861 11861 0 0.00 0 23301 124 0 0
x_lock_depdocs_on_canc_sup_ord 391 391 0 0.00 0 10344 366 0 0
x_make_qstorno_1000_1200 5703 5703 0 0.00 2 18253 1154 0 0
x_make_qstorno_1200_2000 5652 5652 0 0.00 4 70482 3043 0 0
x_make_qstorno_2100_3300 490131 490131 0 0.00 0 61607 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-02-2021 19:29:19 to 20-02-2021 19:29:23.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:18 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:25 30393 8192000000 10297766368 10610561024 885732480 9.757 68 51 103 1 904913328 2477296 16703552
16:58:04 31461 8192000000 10368562304 10687799296 1416320992 14.740 100 87 174 0 1449678048 5380112 27976944
16:58:42 17621 8192000000 10382409280 10708406272 1442467536 14.971 100 83 166 0 1476727056 7023696 27235824
16:59:14 10780 8192000000 10416789680 10746118144 1472992944 15.240 100 86 172 0 1508593632 7755168 27845520
16:59:43 25046 8192000000 10449473744 10781089792 1499456416 15.471 100 92 184 0 1537480928 8758096 29266416
17:00:17 15096 8192000000 10463966576 10797625344 1516150336 15.617 100 90 180 0 1554527680 9714384 28662960
17:00:43 11444 8192000000 10473203152 10813333504 1530093648 15.738 100 90 180 1 1568756464 10457024 28205792
17:01:17 16271 8192000000 10493410960 10839228416 1548584896 15.898 100 82 162 2 1584333952 10501392 25247664
17:01:47 10188 8192000000 10522690896 10869665792 1574629440 16.122 100 87 174 1 1613245280 11444304 27171536
17:02:13 17618 8192000000 10545644384 10900656128 1589769744 16.252 100 80 160 1 1625338320 11189920 24378656
17:02:39 14829 8192000000 10566491792 10923724800 1620777520 16.517 100 80 160 2 1657428560 11630064 25020976
17:03:01 13883 8192000000 10593602112 10954248192 1641686096 16.694 100 81 162 0 1678350496 12833824 23830576
17:03:23 11096 8192000000 10612635360 10973499392 1662319216 16.868 100 85 170 1 1700950688 13748240 24883232
17:03:43 11092 8192000000 10624247952 10985922560 1678400272 17.004 100 88 174 1 1718201712 14166832 25634608
17:04:03 7110 8192000000 10636158416 11004141568 1691458416 17.114 100 79 158 1 1727360032 13100208 22801408
17:04:19 9765 8192000000 10647492800 11020013568 1708362624 17.255 100 78 157 2 1743978800 13098336 22517840
17:04:37 5454 8192000000 10654809696 11026681856 1722687936 17.375 100 86 170 0 1760500256 14144288 23668032
17:04:50 5915 8192000000 10668411744 11049476096 1732027232 17.452 100 72 142 2 1764202272 12219008 19956032
17:05:03 4775 8192000000 10691996192 11066163200 1751320336 17.613 100 82 164 1 1786540704 11818368 23402000
17:05:15 4464 8192000000 10702290304 11079962624 1764651968 17.723 100 86 171 4 1800883696 12269088 23962640
17:05:28 3776 8192000000 10708647152 11087839232 1771853200 17.782 100 84 166 0 1807790816 12434384 23503232
17:05:38 4016 8192000000 10722116736 11097673728 1779304208 17.844 100 85 169 0 1815765440 12808528 23652704
17:05:49 3512 8192000000 10722086944 11102658560 1792105264 17.949 100 82 165 0 1828226352 13096304 23024784
17:05:59 3953 8192000000 10730999472 11116691456 1793579456 17.961 100 73 146 2 1827227728 12972048 20676224
17:06:11 2739 8192000000 10752031424 11134783488 1815233936 18.139 100 82 164 0 1851072128 13153040 22685152
17:06:20 2637 8192000000 10759861920 11144597504 1821782032 18.192 100 86 173 0 1859204688 13390512 24032144
17:06:30 6857 8192000000 10753036448 11143094272 1828207632 18.245 100 89 176 2 1867301616 15258480 23835504
17:06:44 4835 8192000000 10772304640 11161948160 1829180976 18.253 100 81 158 0 1865579504 15466080 20932448
17:06:56 1985 8192000000 10782592320 11170078720 1845999088 18.390 100 86 172 2 1884047088 14192448 23855552
17:07:04 1726 8192000000 10796833536 11182411776 1851291344 18.433 100 90 180 4 1889594048 13139392 25163312
17:07:12 2113 8192000000 10799224080 11184898048 1853928416 18.454 100 93 186 1 1893238832 13718848 25591568
17:07:21 1745 8192000000 10810016864 11199094784 1863449520 18.531 100 96 192 0 1904690128 14611200 26629408
17:07:29 1852 8192000000 10809480736 11201073152 1866588736 18.557 100 87 173 1 1904225792 13601312 24035744
17:07:37 2148 8192000000 10810590032 11201978368 1869181504 18.578 100 84 167 0 1906331056 12926016 24223536
17:07:46 1675 8192000000 10819336736 11207696384 1876359488 18.636 100 93 187 1 1916275088 13834608 26080992
17:07:54 1165 8192000000 10820061216 11213086720 1879940832 18.665 100 92 183 3 1917607936 12037712 25629392
17:08:01 1329 8192000000 10827154384 11219292160 1885157200 18.707 100 93 186 2 1923469776 12636656 25675920
17:08:10 2977 8192000000 10823785728 11219800064 1886405792 18.717 100 93 187 1 1926976608 13777456 26793360
17:08:20 3180 8192000000 10830240352 11223592960 1890151936 18.747 100 92 184 0 1930417888 13941328 26324624
17:08:29 3717 8192000000 10825195456 11221925888 1885050864 18.706 100 79 159 2 1920215408 12938160 22226384
17:08:50 1430 8192000000 10833193440 11230904320 1888101328 18.730 100 88 176 0 1927539056 15279120 24158608
17:08:57 36419 8192000000 10796874624 11220877312 1881456176 18.677 100 42 84 1 1902272944 8310704 12506064
17:09:42 4544 8192000000 10804746608 11224719360 1886576880 18.718 100 39 78 1 1904450928 7022688 10851360
17:09:54 5016 8192000000 10799154256 11225255936 1886172240 18.715 100 33 66 0 1904610192 8340432 10097520
17:10:06 7613 8192000000 10793177552 11221135360 1885094176 18.706 100 28 56 2 1899887552 6969360 7824016
17:10:23 5426 8192000000 10801834080 11226816512 1884653152 18.703 100 22 44 0 1897523120 6886256 5983712
17:10:37 4821 8192000000 10807108336 11231928320 1890819008 18.752 100 36 72 2 1908409408 7723248 9867152
17:10:49 7471 8192000000 10804824896 11232657408 1892485360 18.766 100 31 63 0 1908620528 7721888 8413280
17:11:07 10319 8192000000 10805600688 11233480704 1895767168 18.792 100 27 53 1 1909683360 6891248 7024944
17:11:24 9194 8192000000 10803421024 11238551552 1896200256 18.796 100 21 42 2 1912052720 10108112 5744352
17:11:39 12007 8192000000 10803039312 11243991040 1898028896 18.810 100 22 44 1 1910484112 6189776 6265440
17:12:01 7977 8192000000 10808024512 11243614208 1901220016 18.836 100 19 38 2 1912474880 6372176 4882688
17:12:15 17994 8192000000 10809375040 11245568000 1900166752 18.828 100 12 24 3 1909633040 6223376 3242912
17:12:42 13525 8192000000 10836442976 11245330432 1904289776 18.861 100 14 28 4 1913486432 5900384 3296272
17:13:02 5482 8192000000 10825101904 11251253248 1910265376 18.909 100 37 74 1 1926891664 6008928 10617360
17:13:14 56025 8192000000 10821275712 11258155008 1911358592 18.918 100 33 65 2 1925764976 5571296 8835088
17:14:18 12933 8192000000 10817290192 11251687424 1893178384 18.771 99 26 51 2 1905327984 4801808 7347792
17:14:38 7865 8192000000 10824874544 11256127488 1903809200 18.857 100 22 44 0 1916083808 6197280 6077328
17:14:54 4640 8192000000 10821763024 11258343424 1907848736 18.889 100 36 72 0 1925263888 7661696 9753456
17:15:05 4907 8192000000 10820806640 11256528896 1905857504 18.873 100 46 92 3 1926764272 8054624 12852144
17:15:17 5116 8192000000 10822903456 11260940288 1911784688 18.921 100 47 94 2 1934039184 8240288 14014208
17:15:28 7543 8192000000 10833562640 11258036224 1906136224 18.876 100 28 56 0 1920532688 5514160 8882304
17:15:42 6542 8192000000 10816907744 11248840704 1891642128 18.759 99 35 72 0 1907660640 6172560 9845952
17:15:57 7734 8192000000 10815662016 11254878208 1903419792 18.854 100 20 40 0 1914737904 5496736 5821376
17:16:14 8822 8192000000 10816806816 11258302464 1909739232 18.905 100 18 36 0 1920222784 5411632 5071920
17:16:29 4727 8192000000 10825892144 11264835584 1911882848 18.922 100 14 27 3 1921318992 5810784 3625360
17:16:39 12370 8192000000 10800226192 11238760448 1857691840 18.485 97 24 48 1 1870353328 5496256 7165232
17:17:00 16562 8192000000 10790039904 11223371776 1810493888 18.100 95 12 24 0 1819265152 5427200 3344064
17:17:23 14909 8192000000 10778046160 11202400256 1788618656 17.920 95 13 26 1 1797013392 4628400 3766336
17:17:48 56900 8192000000 10756948912 11179393024 1776280144 17.819 95 25 49 1 1787759472 4660976 6818352
17:18:51 6774 8192000000 10703958464 11130392576 1750137424 17.603 95 19 38 1 1762027616 5876896 6013296
17:19:04 3854 8192000000 10715154592 11136544768 1760295008 17.687 97 24 47 3 1773101744 6212624 6594112
17:19:15 5100 8192000000 10717507936 11125952512 1769536576 17.763 97 35 70 0 1786459008 7113152 9809280
17:19:28 5821 8192000000 10739443696 11162394624 1806651856 18.068 99 31 62 2 1821361744 6002560 8707328
17:19:42 4986 8192000000 10698532752 11117420544 1739985856 17.519 96 51 102 1 1762167216 7076112 15105248
17:19:53 8465 8192000000 10679960480 11094638592 1698256320 17.171 95 21 42 3 1709415536 4940672 6218544
17:20:09 11312 8192000000 10716389216 11133603840 1762276432 17.703 98 32 64 1 1781863040 10580144 9006464
17:20:26 10791 8192000000 10699126464 11116273664 1723392128 17.380 96 16 32 1 1732804784 5120928 4291728
17:20:48 7885 8192000000 10692454944 11107401728 1725311408 17.396 96 24 47 0 1737546256 4710688 7524160
17:21:04 11886 8192000000 10715190432 11137384448 1789249216 17.926 99 19 38 1 1800171376 5324224 5597936
17:21:22 6170 8192000000 10718160800 11131670528 1762740016 17.707 97 22 44 0 1777799840 9152512 5907312
17:21:35 12669 8192000000 10720910720 11139334144 1801826944 18.029 100 25 50 0 1815244128 5817168 7600016
17:21:55 8373 8192000000 10731816048 11140587520 1788053248 17.916 99 19 38 2 1798738912 5327168 5358496
17:22:13 15792 8192000000 10737362960 11160649728 1821660400 18.191 100 21 42 3 1834195584 6511968 6023216
17:22:38 17826 8192000000 10755576784 11176521728 1838662496 18.330 100 22 44 2 1850923392 5147168 7113728
17:23:15 53060 8192000000 10773838208 11191410688 1848625216 18.411 100 31 62 1 1862776864 5331616 8820032
17:24:15 12698 8192000000 10763580272 11196137472 1854262000 18.457 100 22 44 2 1866644768 5028912 7353856
17:24:34 7273 8192000000 10785921520 11209822208 1864271440 18.538 100 24 48 0 1877004208 5731488 7001280
17:24:47 6079 8192000000 10789561312 11212017664 1870377696 18.587 100 31 62 2 1885118960 5665904 9075360
17:25:00 7319 8192000000 10785556992 11216433152 1874154880 18.618 100 24 48 0 1886946192 6204816 6586496
17:25:13 7218 8192000000 10789447840 11217055744 1875106960 18.626 100 30 60 3 1890284528 5953264 9224304
17:25:29 8711 8192000000 10798764880 11222548480 1874391488 18.620 100 17 34 0 1884629184 5442784 4794912
17:25:44 7095 8192000000 10807237184 11228540928 1880429920 18.669 100 27 53 3 1893317520 5415808 7471792
17:25:59 6960 8192000000 10806693312 11227992064 1882853040 18.688 100 31 62 1 1898697136 5875344 9968752
17:26:13 7631 8192000000 10797994112 11228205056 1881406336 18.676 100 13 26 0 1890374640 4754144 4214160
17:26:27 8979 8192000000 10818257632 11238211584 1886286288 18.716 100 32 65 3 1901169392 4740624 10142480
17:26:43 6215 8192000000 10803000000 11235418112 1886931744 18.721 100 19 38 1 1898608032 6030704 5645584
17:26:58 10762 8192000000 10821676000 11246022656 1893244096 18.772 100 22 44 1 1905021392 5110096 6667200
17:27:19 14832 8192000000 10843399872 11266039808 1917309792 18.965 100 35 68 0 1932696016 5640368 9745856
17:27:41 13447 8192000000 10862916768 11282202624 1930414784 19.070 100 56 112 1 1953835008 7693312 15726912
17:28:02 26520 8192000000 10872447088 11293204480 1941257936 19.157 100 62 124 2 1967540800 9312944 16969920
17:29:01 42560 8192000000 10872255376 11300397056 1945074272 19.187 100 50 99 2 1968094576 9007904 14012400
17:29:52 21573 8192000000 10883559840 11310743552 1950882352 19.234 100 55 110 0 1979551072 13021024 15647696
17:30:24 10441 8192000000 10889972784 11310190592 1948015712 19.211 100 57 112 1 1973557360 9927584 15614064
17:30:46 10028 8192000000 10893240176 11323826176 1957005600 19.282 100 57 114 4 1983858560 10618256 16234704
17:31:03 2544 8192000000 10882484528 11304308736 1943029584 19.171 99 67 130 3 1971097712 10169488 17898640
17:31:13 3490 8192000000 10898738928 11324071936 1962993072 19.330 100 69 138 1 1993519072 11367936 19158064
17:31:28 14904 8192000000 10888190960 11317567488 1940115472 19.148 99 53 106 0 1965805888 11052768 14637648
17:31:56 14834 8192000000 10907279424 11327770624 1960606752 19.311 100 61 123 1 1990128000 11841328 17679920
17:32:18 14505 8192000000 10906863376 11333165056 1969982640 19.385 100 65 129 1 1999844256 11776816 18084800
17:32:40 19829 8192000000 10906373232 11343388672 1976255280 19.435 100 51 100 0 2002305872 10599056 15451536
17:33:12 10037 8192000000 10922329792 11356065792 1983447600 19.492 100 64 128 1 2015799552 13751936 18600016
17:33:30 12420 8192000000 10928008528 11360751616 1985414112 19.508 100 63 126 1 2020042672 16548912 18079648
17:34:00 8364 8192000000 10933709632 11359371264 1986266624 19.514 100 71 142 0 2022167824 15230432 20670768
17:34:27 5147 8192000000 10927035344 11362250752 1987558608 19.524 100 49 98 0 2016185920 14638480 13988832
17:34:47 27122 8192000000 10923273472 11364327424 1992817168 19.566 100 45 90 1 2020222832 14465824 12939840
17:35:53 13942 8192000000 10931230976 11373662208 1996687264 19.597 100 38 76 0 2022600608 14365888 11547456
17:36:16 16031 8192000000 10949925888 11382775808 2004330544 19.657 100 53 106 1 2039281824 19580144 15371136
17:36:48 21508 8192000000 10941567024 11388682240 2003798352 19.653 100 35 69 2 2033080128 19140672 10141104
17:37:17 11942 8192000000 10946466992 11389845504 2005772816 19.668 100 36 72 1 2036508672 19211152 11524704
17:37:36 7626 8192000000 10939155744 11375665152 1970432432 19.389 98 58 116 1 2007740304 19209024 18098848
17:37:53 4069 8192000000 10945520848 11384422400 2004092304 19.655 100 53 106 1 2038001392 18481184 15427904
17:38:04 9773 8192000000 10945585184 11383758848 1987853264 19.527 99 55 110 1 2024877632 20600384 16423984
17:38:25 11293 8192000000 10954408624 11394424832 2005167824 19.663 100 50 100 2 2041824064 22091984 14564256
17:38:53 8094 8192000000 10964509808 11404324864 2011805504 19.716 100 50 100 1 2051453088 24525712 15121872
17:39:10 8061 8192000000 10969496640 11406675968 2015491696 19.745 100 68 134 0 2059108304 24287632 19328976
17:39:26 3571 8192000000 10957911136 11394883584 1995041872 19.584 99 56 111 3 2034580144 22971408 16566864
17:39:39 3980 8192000000 10956253056 11392045056 2005799088 19.668 100 57 108 1 2045464336 23721088 15944160
17:39:51 14383 8192000000 10950941728 11386806272 1984624240 19.501 99 60 118 2 2029193072 26773936 17794896
17:40:17 3903 8192000000 10958954576 11393888256 2001257808 19.633 100 72 143 2 2056157968 32507376 22392784
17:40:29 6177 8192000000 10951627872 11377037312 1981564304 19.477 99 69 137 1 2034244016 32154000 20525712
17:40:46 7493 8192000000 10953767936 11384664064 1991348240 19.554 100 60 119 0 2042589520 33613888 17627392
17:41:00 6368 8192000000 10959228080 11382378496 1985425232 19.508 100 66 133 0 2041744224 36562192 19756800
17:41:14 1891 8192000000 10944474928 11359252480 1950954544 19.234 99 62 118 2 2004923840 35387568 18581728
17:41:25 4122 8192000000 10934431600 11359883264 1942372112 19.166 98 61 121 1 1998404800 37595040 18437648
17:41:36 1571 8192000000 10947191920 11359182848 1965840512 19.352 100 80 161 2 2030085056 39115392 25129152
17:41:46 8049 8192000000 10911659440 11339751424 1919048000 18.979 98 61 122 2 1977793344 39704976 19040368
17:42:03 6804 8192000000 10946005648 11363860480 1970617616 19.390 100 80 159 1 2036516720 41386800 24512304
17:42:24 5741 8192000000 10942095456 11368075264 1967179264 19.363 100 65 131 3 2026127520 39002864 19945392
17:42:39 19546 8192000000 10936475136 11374112768 1960309200 19.308 99 55 108 0 2018037392 40487616 17240576
17:43:11 5789 8192000000 10926331744 11354755072 1958270912 19.292 99 50 100 0 2011498464 37373392 15854160
17:43:25 6304 8192000000 10927431792 11350974464 1930580432 19.072 98 63 126 2 1991442432 40724224 20137776
17:43:42 14870 8192000000 10906362112 11331391488 1922995792 19.011 99 56 112 2 1982230128 41792608 17441728
17:44:07 13167 8192000000 10918065136 11339669504 1921745536 19.001 99 57 114 1 1984527600 44998144 17783920
17:44:31 6477 8192000000 10936039008 11361026048 1953207520 19.252 100 55 110 0 2015845472 44993968 17643984
17:44:44 2906 8192000000 10939017776 11351994368 1940757200 19.153 99 80 159 0 2011800464 46458512 24584752
17:44:56 3507 8192000000 10937633376 11357949952 1954752560 19.264 100 63 124 2 2022210720 47985008 19473152
17:45:07 1095 8192000000 10960073088 11370065920 1967555936 19.366 100 83 166 1 2042297776 48531392 26210448
17:45:15 3526 8192000000 10959742832 11365322752 1964164576 19.339 100 84 165 3 2038126160 48624112 25337472
17:45:26 2385 8192000000 10969582432 11381067776 1973951344 19.417 100 80 160 0 2049025504 49427648 25646512
17:45:35 3890 8192000000 10950096096 11373588480 1967016912 19.362 100 62 125 0 2038232064 51655392 19559760
17:45:47 8228 8192000000 10920406784 11359428608 1926735216 19.041 98 40 80 0 1989133456 49262256 13135984
17:46:05 5535 8192000000 10939216720 11370962944 1958499216 19.294 100 41 82 2 2022626576 49799776 14327584
17:46:19 7330 8192000000 10908878608 11327700992 1911892656 18.922 98 60 120 2 1982149456 51083904 19172896
17:46:33 4163 8192000000 10919635104 11329540096 1929042320 19.059 100 76 152 2 2006198368 52426480 24729568
17:46:45 2259 8192000000 10935462592 11341713408 1938794000 19.137 100 86 170 2 2018448224 53362928 26291296
17:46:55 2354 8192000000 10932066016 11331432448 1929850016 19.066 99 91 181 1 2012565392 54890848 27824528
17:47:04 1463 8192000000 10954088560 11357147136 1950280096 19.229 100 94 185 2 2034765088 55709168 28775824
17:47:12 2544 8192000000 10946478768 11363393536 1952414096 19.246 100 71 142 2 2031658624 57029872 22214656
17:47:25 3814 8192000000 10945647984 11364470784 1954625456 19.263 100 71 142 0 2033909008 56295840 22987712
17:47:37 3881 8192000000 10946740848 11361492992 1936902384 19.122 99 72 138 3 2015711408 56652320 22156704
17:47:49 2441 8192000000 10936715936 11341991936 1933879024 19.098 99 90 178 2 2021000592 58423664 28697904
17:47:58 6078 8192000000 10965362800 11375546368 1955620192 19.271 100 72 144 5 2041667600 62595408 23452000
17:48:13 5051 8192000000 10969296784 11383345152 1962487536 19.326 100 78 155 0 2051919424 64267664 25164224
17:48:28 3357 8192000000 10972317696 11385991168 1964786768 19.344 100 75 152 0 2052834768 63466272 24581728
17:48:38 8225 8192000000 10975181696 11391246336 1967241152 19.364 100 76 152 2 2057804016 65133536 25429328
17:48:55 2410 8192000000 10976793904 11383242752 1949091488 19.219 99 82 162 3 2040222704 65135952 25995264
17:49:04 1338 8192000000 10981842992 11393552384 1967728560 19.367 100 87 175 2 2061809504 65624992 28455952
17:49:13 1663 8192000000 10987956512 11394002944 1965657200 19.351 100 95 189 1 2066208880 70209424 30342256
17:49:23 2060 8192000000 10976454496 11391381504 1960243840 19.308 100 78 155 1 2056373616 71293760 24836016
17:49:32 6302 8192000000 10962409728 11383701504 1958419120 19.293 100 68 135 0 2048965744 68512800 22033824
17:49:46 13505 8192000000 10963534320 11400593408 1965176736 19.347 100 44 88 2 2046208192 65938336 15093120
17:50:18 7157 8192000000 10944125840 11385540608 1948683168 19.216 99 40 80 0 2020266784 58453648 13129968
17:50:32 7895 8192000000 10963430992 11394023424 1966045760 19.354 100 41 82 2 2040728768 60817600 13865408
17:50:54 10708 8192000000 10951537648 11389865984 1940269040 19.149 99 36 67 0 2018180800 66743360 11168400
17:51:13 13350 8192000000 10956184000 11398582272 1965130160 19.347 100 40 78 1 2044707360 66381376 13195824
17:51:36 6055 8192000000 10959283248 11400122368 1947458400 19.206 99 46 94 1 2026825456 63981984 15385072
17:51:50 9003 8192000000 10959285440 11394224128 1959219040 19.300 100 42 84 1 2035782832 61702432 14861360
17:52:22 14048 8192000000 10975304224 11414777856 1971199200 19.395 100 38 74 1 2051928592 67984384 12745008
17:52:43 30325 8192000000 10961330112 11413221376 1948935472 19.218 99 32 64 2 2037823856 77299152 11589232
17:53:20 11847 8192000000 10945905584 11407527936 1942082176 19.163 99 33 66 0 2025284224 71748256 11453792
17:53:51 28167 8192000000 10953397872 11400577024 1951164400 19.236 100 27 54 0 2032679584 71462512 10052672
17:54:42 23419 8192000000 10923364048 11370995712 1926789216 19.041 99 27 53 0 2010333104 73080080 10463808
17:55:13 14060 8192000000 10930274816 11377655808 1940438992 19.150 100 26 52 2 2009888112 59383168 10065952
17:55:44 18525 8192000000 10904407600 11374379008 1939158144 19.140 100 20 40 2 1999077776 52522432 7397200
17:56:10 43109 8192000000 10902743472 11364794368 1915480224 18.951 99 17 34 1 1971403616 50041408 5881984
17:57:03 25554 8192000000 10899222512 11356356608 1941405104 19.158 100 23 46 1 1986903824 37215968 8282752
17:57:35 59020 8192000000 10885711840 11343978496 1928783744 19.057 99 15 30 0 1953744880 20235696 4725440
17:58:40 40762 8192000000 10899082512 11345985536 1942231024 19.165 99 21 43 2 1958874720 10877104 5766592
17:59:33 35054 8192000000 10890748240 11350659072 1937530176 19.127 99 19 38 0 1957520880 14233248 5757456
18:00:15 61124 8192000000 10891789728 11357306880 1949386880 19.222 99 15 30 0 1960743264 7731264 3625120
18:01:28 52425 8192000000 10907295904 11349225472 1923580640 19.016 98 19 38 1 1939865776 10599264 5685872
18:02:31 56216 8192000000 10904298528 11356934144 1934148640 19.100 98 44 88 1 1954759360 7936256 12674464
18:03:41 101765 8192000000 10893818096 11365949440 1921065344 18.995 98 8 16 0 1938525344 15244224 2215776
18:05:29 114751 8192000000 10905484544 11360440320 1953307728 19.253 99 15 31 1 1976377168 18268704 4800736
18:07:32 112147 8192000000 10921611888 11379867648 1962170400 19.323 99 38 76 1 1980822304 7518704 11133200
18:09:58 40911 8192000000 10940025296 11390119936 1988126832 19.529 100 42 84 0 2010416064 10282160 12007072
18:10:55 56829 8192000000 10912572416 11379884032 1971300112 19.396 99 43 86 2 1994772304 11591888 11880304
18:12:00 43374 8192000000 10920385712 11386273792 1985935856 19.512 100 21 42 0 2001856496 10025552 5895088
18:12:51 2298 8192000000 10915630192 11379093504 1981604304 19.477 100 21 42 0 1997657728 9721536 6331888
18:12:59 13732 8192000000 10898131248 11363352576 1962947296 19.329 99 28 57 1 1984284464 13531696 7805472
18:13:40 32523 8192000000 10910977744 11376799744 1973961616 19.417 100 24 48 2 1993911200 12837712 7111872
18:14:21 29867 8192000000 10922733584 11382333440 1975799648 19.431 100 22 44 1 1996260048 14046400 6414000
18:14:59 13292 8192000000 10947774080 11396419584 1996754768 19.597 100 55 110 1 2028688816 15404368 16529680
18:15:24 26591 8192000000 10945772656 11403022336 1999432464 19.618 100 51 101 1 2033947984 19901408 14614112
18:16:04 18461 8192000000 10930795120 11386429440 1973027984 19.409 99 43 86 0 2006564592 20074240 13462368
18:16:29 46322 8192000000 10933917200 11407368192 1982402848 19.484 100 25 49 1 2013060096 22818208 7839040
18:17:23 26598 8192000000 10925777184 11413782528 1984839152 19.503 100 15 31 0 2016293328 26590224 4863952
18:19:15 32619 8192000000 10927993184 11404656640 1996456448 19.595 100 17 33 1 2014638352 13780496 4401408
18:20:30 47930 8192000000 10913655664 11393622016 1977184240 19.442 99 34 68 1 1999167968 12102608 9881120
18:21:26 55979 8192000000 10893582656 11386216448 1924141776 19.020 97 6 12 0 1947577536 21615904 1819856
18:22:28 52508 8192000000 10907615840 11359301632 1907263856 18.885 97 27 54 1 1922613760 7465696 7884208
18:23:30 61846 8192000000 10880379408 11353001984 1894544800 18.782 96 18 36 1 1910330416 10671072 5114544
18:24:38 27596 8192000000 10876341568 11319726080 1880357376 18.668 96 43 86 1 1899810512 7957456 11495680
18:25:15 18365 8192000000 10871256832 11325358080 1879921824 18.664 97 45 90 0 1902781744 10419840 12440080
18:25:44 58818 8192000000 10860219600 11310718976 1838320080 18.327 95 20 40 0 1855313296 11482224 5510992
18:26:49 48115 8192000000 10850114320 11315400704 1863711056 18.533 97 10 20 1 1883805104 17620736 2473312
18:27:51 74405 8192000000 10847447696 11324145664 1899551520 18.823 98 14 28 1 1915184992 11912784 3720688
18:29:21 62775 8192000000 10855266560 11299794944 1817416288 18.157 94 18 35 1 1831078128 9108608 4553232
18:30:31 85247 8192000000 10861495504 11303194624 1805629136 18.060 94 16 32 1 1818802512 8844352 4329024
18:32:04 11066 8192000000 10881422880 11319066624 1925975264 19.035 100 63 126 1 1955731936 11372400 18384272
18:32:23 111073 8192000000 10837046512 11325333504 1804937680 18.054 94 11 22 0 1822114784 14187424 2989680
18:34:20 57086 8192000000 10866474176 11316785152 1876800832 18.639 98 15 30 0 1891301776 10583216 3917728
18:35:32 41422 8192000000 10866574992 11329327104 1932321136 19.085 100 38 76 0 1954800784 12166016 10313632
18:36:21 81531 8192000000 10880459664 11339472896 1934312912 19.101 100 31 62 0 1950590832 7886976 8390944
18:37:59 101700 8192000000 10864718464 11355041792 1922111200 19.004 99 9 18 1 1946866640 22585328 2170112
18:39:47 22486 8192000000 10880333968 11322929152 1928777840 19.057 99 50 103 2 1952366112 9237520 14350752
18:40:15 6891 8192000000 10891795168 11349495808 1958505984 19.294 100 76 153 0 1991266128 10604080 22156064
18:40:39 26750 8192000000 10906843872 11363151872 1963009056 19.330 100 65 130 3 1996250768 14225312 19016400
18:41:20 73052 8192000000 10879844176 11350683648 1899626128 18.823 97 20 40 0 1920825632 15417728 5781776
18:42:45 63269 8192000000 10860219360 11345432576 1938105152 19.132 100 16 32 1 1955571056 12707456 4758448
18:43:58 43099 8192000000 10870066688 11349786624 1927056160 19.043 99 16 32 0 1942489056 10593600 4839296
18:44:47 55415 8192000000 10839704208 11312189440 1865943184 18.551 96 10 20 0 1879227120 10253856 3030080
18:45:49 39760 8192000000 10852778912 11327537152 1905731152 18.872 99 18 34 0 1924214320 13121552 5361616
18:46:48 58085 8192000000 10854628160 11330723840 1893331312 18.773 98 20 40 0 1915297584 16287632 5678640
18:47:53 38394 8192000000 10861013136 11340132352 1905249872 18.868 99 12 24 0 1926817344 17819520 3747952
18:48:38 51370 8192000000 10861307072 11344031744 1930884912 19.074 100 14 28 1 1954780640 19468544 4427184
18:49:38 30987 8192000000 10909563424 11361361920 1954830208 19.265 100 50 100 1 1979645024 10993104 13821712
18:50:18 107893 8192000000 10890705472 11367284736 1934556064 19.103 99 18 36 0 1955221344 15708432 4956848
18:52:17 76439 8192000000 10889079504 11385438208 1953269408 19.253 100 16 32 1 1973852896 16129856 4453632
18:54:02 44336 8192000000 10883103856 11349991424 1904894528 18.866 97 35 70 1 1923760432 8734928 10130976
18:54:56 87177 8192000000 10902176464 11367055360 1940502912 19.151 99 21 42 1 1958627440 12579984 5544544
18:56:29 13103 8192000000 10918062032 11371802624 1970995632 19.393 100 45 90 0 1992790400 9295264 12499504
18:56:58 43277 8192000000 10919160912 11384057856 1977563600 19.445 100 40 80 1 1999175440 11186112 10425728
18:57:49 43771 8192000000 10930777792 11393474560 1971507072 19.397 99 31 62 1 1990822592 10933680 8381840
18:58:40 26543 8192000000 10935031920 11397365760 1969498352 19.381 99 30 60 0 1989678656 11294672 8885632
18:59:42 106022 8192000000 10916541344 11396845568 1919079840 18.979 97 10 20 0 1940949376 19314176 2555360
19:02:13 120153 8192000000 10903083024 11387158528 1924238560 19.021 97 13 26 0 1944017584 16146400 3632624
19:04:20 27186 8192000000 10904229568 11394125824 1976548224 19.437 100 6 12 0 1996045584 18057856 1439504
19:04:54 1683 8192000000 10905805120 11397074944 1977999440 19.449 100 2 4 0 1995900160 17567600 333120
19:05:02 905 8192000000 10907422000 11397210112 1978851568 19.456 100 6 12 0 1998177200 17764624 1561008
19:05:09 442 8192000000 10891616752 11386716160 1967747936 19.368 100 1 2 0 1985171312 17361248 62128
19:05:20 66036 8192000000 10908940576 11393220608 1974533248 19.421 99 13 26 0 1985559056 7581936 3443872
19:06:32 55854 8192000000 10909157056 11394367488 1969346464 19.380 99 11 22 0 1986130048 13648336 3135248
19:07:35 24393 8192000000 10901809776 11396190208 1966356992 19.357 99 10 20 0 1983306624 14387936 2561696
19:08:20 67097 8192000000 10894938336 11383189504 1964509792 19.342 99 8 16 0 1974145248 7636352 1999104
19:09:39 54564 8192000000 10878620304 11365818368 1943212528 19.172 98 10 20 0 1952767808 6846912 2708368
19:10:40 16404 8192000000 10897004480 11381526528 1972989536 19.409 100 24 48 0 1987345536 7784656 6571344
19:11:03 44776 8192000000 10886599744 11368796160 1921836112 19.002 97 10 20 0 1932317712 7768192 2713408
19:11:55 75503 8192000000 10879273136 11359129600 1909168032 18.900 97 11 22 0 1921594288 9384752 3041504
19:13:24 53349 8192000000 10841858336 11322257408 1810922208 18.103 93 17 34 0 1824051888 8095984 5033696
19:14:40 49935 8192000000 10823590288 11291373568 1826438240 18.230 95 21 42 1 1841091472 8500608 6152624
19:15:54 38537 8192000000 10838052832 11293696000 1821008416 18.186 95 28 56 3 1837424896 8481456 7935024
19:16:40 59142 8192000000 10853232624 11318042624 1876330784 18.635 98 17 34 0 1890376048 9664832 4380432
19:17:53 97948 8192000000 10853647936 11317571584 1849040928 18.414 96 11 22 0 1863622192 11788816 2792448
19:19:40 34045 8192000000 10873858160 11328040960 1913026256 18.931 99 28 56 2 1929316816 8303792 7986768
19:20:25 51479 8192000000 10862270752 11331739648 1876081072 18.633 97 33 66 0 1897860384 12646752 9132560
19:21:23 62076 8192000000 10831399328 11294945280 1821257360 18.188 95 20 40 0 1841910752 15313680 5339712
19:22:35 60965 8192000000 10862996016 11337486336 1911229168 18.917 100 16 32 1 1933392288 17691536 4471584
19:23:42 85395 8192000000 10868410624 11334471680 1883482176 18.693 98 14 28 0 1905708928 18606096 3620656
19:25:15 77054 8192000000 10831207312 11304001536 1885986096 18.713 98 14 28 0 1901605664 11027040 4592528
19:26:47 37774 8192000000 9420169600 9724588032 555455632 6.349 30 7 12 1 560779888 3652592 1671664

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 20-02-2021 19:29:25 to 20-02-2021 19:29:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 86 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-02-2021 19:29:58 to 20-02-2021 19:30:00.

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          245801
MON$OLDEST_ACTIVE               245802
MON$OLDEST_SNAPSHOT             245802
MON$NEXT_TRANSACTION            245802
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                       2054304
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:63: 
:64: mscs-test-161.budzdorov.ru    Sat Feb 20 19:28:01 2021
:65:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:66: 
--- end of diff output ---

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

20.02.21 19:30:01. 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-02-20 19:30:03 No severe PSQL-related problems occured
20.02.21 19:30:05. End of report.