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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17059848 kB
MemAvailable 31306248 kB
Buffers 0 kB
Cached 14599436 kB
SwapCached 4864 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-01-17 01:27:10
DTS_END                         2021-01-17 01:27:10.6120
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58042
TRN_ID                          245026
ATT_ID                          707
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: 9551.41 21590 1146169
customer order: creation 177.21 333 21265
customer order: refuse 15.89 374 1907
order to supplier: creation 48.73 1232 5848
order to supplier: removal 3.65 91857 438
invoice (draft): creation 47.16 3371 5659
invoice (draft): removal 53.75 787 6450
invoice accept: apply 43.50 15491 5220
invoice accept: cancel 48.83 770 5859
customer reserve: creation 4021.13 153 482535
customer reserve: removal 4788.87 54 574664
realization accept: apply 85.29 168 10235
realization accept: cancel 81.23 102 9748
payment from customer: creation 62.33 100 7480
payment from customer: removal 6.24 70 749
payment to supplier: creation 51.61 140 6193
payment to supplier: removal 3.71 56 445
service: total inventory turnovers 4.96 1019 595
service: total monetary turnovers 6.48 28 778
service: aggregate perf. data 0.81 23935 97
service: refresh index statistics 0.03 291762 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-01-2021 01:27:57 to 17-01-2021 01:27:59.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1457
TEST_TIME 2 2285
TEST_TIME 3 3489
TEST_TIME 4 3562
TEST_TIME 5 4404
TEST_TIME 6 4864
TEST_TIME 7 5430
TEST_TIME 8 5265
TEST_TIME 9 5268
TEST_TIME 10 5546
TEST_TIME 11 5566
TEST_TIME 12 5774
TEST_TIME 13 6158
TEST_TIME 14 6859
TEST_TIME 15 6898
TEST_TIME 16 7043
TEST_TIME 17 7299
TEST_TIME 18 7579
TEST_TIME 19 7772
TEST_TIME 20 8465
TEST_TIME 21 9016
TEST_TIME 22 9100
TEST_TIME 23 9245
TEST_TIME 24 9266
TEST_TIME 25 9379
TEST_TIME 26 9584
TEST_TIME 27 10002
TEST_TIME 28 10683
TEST_TIME 29 10584
TEST_TIME 30 10649
TEST_TIME 31 10544
TEST_TIME 32 10606
TEST_TIME 33 10567
TEST_TIME 34 10475
TEST_TIME 35 10610
TEST_TIME 36 10414
TEST_TIME 37 10259
TEST_TIME 38 10277
TEST_TIME 39 10285
TEST_TIME 40 10104
TEST_TIME 41 10072
TEST_TIME 42 9961
TEST_TIME 43 9936
TEST_TIME 44 9995
TEST_TIME 45 10057
TEST_TIME 46 9914
TEST_TIME 47 9969
TEST_TIME 48 9870
TEST_TIME 49 9969
TEST_TIME 50 10003
TEST_TIME 51 9998
TEST_TIME 52 9995
TEST_TIME 53 10017
TEST_TIME 54 9963
TEST_TIME 55 9921
TEST_TIME 56 9952
TEST_TIME 57 10038
TEST_TIME 58 10005
TEST_TIME 59 10053
TEST_TIME 60 10036
TEST_TIME 61 10072
TEST_TIME 62 10126
TEST_TIME 63 10151
TEST_TIME 64 10182
TEST_TIME 65 10154
TEST_TIME 66 10122
TEST_TIME 67 10045
TEST_TIME 68 9930
TEST_TIME 69 9923
TEST_TIME 70 9880
TEST_TIME 71 9818
TEST_TIME 72 9786
TEST_TIME 73 9744
TEST_TIME 74 9679
TEST_TIME 75 9668
TEST_TIME 76 9636
TEST_TIME 77 9572
TEST_TIME 78 9647
TEST_TIME 79 9574
TEST_TIME 80 9540
TEST_TIME 81 9524
TEST_TIME 82 9488
TEST_TIME 83 9481
TEST_TIME 84 9457
TEST_TIME 85 9521
TEST_TIME 86 9487
TEST_TIME 87 9540
TEST_TIME 88 9581
TEST_TIME 89 9569
TEST_TIME 90 9539
TEST_TIME 91 9609
TEST_TIME 92 9640
TEST_TIME 93 9664
TEST_TIME 94 9706
TEST_TIME 95 9717
TEST_TIME 96 9713
TEST_TIME 97 9798
TEST_TIME 98 9732
TEST_TIME 99 9719
TEST_TIME 100 9663
TEST_TIME 101 9644
TEST_TIME 102 9637
TEST_TIME 103 9582
TEST_TIME 104 9539
TEST_TIME 105 9566
TEST_TIME 106 9531
TEST_TIME 107 9557
TEST_TIME 108 9526
TEST_TIME 109 9506
TEST_TIME 110 9479
TEST_TIME 111 9498
TEST_TIME 112 9528
TEST_TIME 113 9517
TEST_TIME 114 9532
TEST_TIME 115 9553
TEST_TIME 116 9555
TEST_TIME 117 9505
TEST_TIME 118 9578
TEST_TIME 119 9621
TEST_TIME 120 9552

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 17-01-2021 01:28:00 to 17-01-2021 01:28:04.

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 1592893 1592893 0 0.00 0 46303 5 0 0
doc_list_biud 1592893 1592893 0 0.00 0 45471 25 0 0
sp_add_invoice_to_stock 5342 5220 122 2.28 33 185215 15491 0 122
sp_cancel_adding_invoice 5859 5859 0 0.00 4 60265 771 0 0
sp_cancel_client_order 1907 1907 0 0.00 4 18254 375 0 0
sp_cancel_customer_reserve 574664 574664 0 0.00 1 45473 55 0 0
sp_cancel_pay_from_customer 749 749 0 0.00 2 6136 70 0 0
sp_cancel_pay_to_supplier 445 445 0 0.00 3 3231 57 0 0
sp_cancel_supplier_invoice 6460 6450 10 0.15 2 24238 788 0 10
sp_cancel_supplier_order 438 438 0 0.00 12 1061834 91857 0 0
sp_cancel_write_off 9748 9748 0 0.00 1 9469 103 0 0
sp_client_order 21265 21265 0 0.00 3 31045 333 0 0
sp_customer_reserve 482535 482535 0 0.00 0 79597 154 0 0
sp_fill_shopping_cart 32749 32749 0 0.00 1 17421 36 0 0
sp_fill_shopping_cart_clo_res 482534 482534 0 0.00 0 16361 12 0 0
sp_get_clo_for_invoice 5219 5219 0 0.00 0 23062 263 0 0
sp_kill_cost_storno 16801 16801 0 0.00 0 6648 54 0 0
sp_kill_qstorno_ret_qs2qd 1165964 1165964 0 0.00 0 45466 30 0 0
sp_kill_qty_storno 614520 614520 0 0.00 0 45471 65 0 0
sp_lock_selected_doc 21585 21585 0 0.00 0 10898 4 0 0
sp_make_cost_storno 29127 29127 0 0.00 0 11729 46 0 0
sp_multiply_rows_for_pdistr 29127 29127 0 0.00 0 31456 27 0 0
sp_multiply_rows_for_qdistr 21265 21265 0 0.00 0 31036 142 0 0
sp_pay_from_customer 7480 7480 0 0.00 4 11007 101 0 0
sp_pay_to_supplier 6193 6193 0 0.00 5 31469 140 0 0
sp_payment_common 13673 13673 0 0.00 1 16441 24 0 0
sp_qd_handle_on_cancel_clo 1907 1907 0 0.00 0 18245 340 0 0
sp_qd_handle_on_invoice_upd_sts 11078 11078 0 0.00 0 39199 304 0 0
sp_qd_handle_on_reserve_upd_sts 10235 10235 0 0.00 0 30714 63 0 0
sp_reserve_write_off 10235 10235 0 0.00 6 30731 169 0 0
sp_supplier_invoice 5659 5659 0 0.00 5 119539 3372 0 0
sp_supplier_order 5848 5848 0 0.00 5 39028 1232 0 0
srv_aggregate_perf_data 98 97 1 1.02 2605 450556 23935 0 1
srv_fill_mon_cache_memory 168 168 0 0.00 1503 150441 32469 0 0
srv_find_qd_qs_mism 1096282 1096282 0 0.00 0 46257 4 0 0
srv_make_invnt_saldo 595 595 0 0.00 42 74697 1019 0 0
srv_make_money_saldo 778 778 0 0.00 1 3144 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 230046 349274 291763 0 0
t$perf-abend:sp_add_invoice_to_stock 122 122 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 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 5220 5220 0 0.00 0 16164 160 0 0
t$perf-norm:sp_cancel_adding_invoice 430 430 0 0.00 0 6810 121 0 0
t$perf-norm:sp_cancel_client_order 1907 1907 0 0.00 0 14835 23 0 0
t$perf-norm:sp_cancel_customer_reserve 742 742 0 0.00 0 2437 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 749 749 0 0.00 0 1059 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 445 445 0 0.00 0 7428 30 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 3571 31 0 0
t$perf-norm:sp_cancel_supplier_order 438 438 0 0.00 0 20159 1706 0 0
t$perf-norm:sp_cancel_write_off 1007 1007 0 0.00 0 3402 7 0 0
t$perf-norm:sp_client_order 21265 21265 0 0.00 0 11134 16 0 0
t$perf-norm:sp_customer_reserve 999 999 0 0.00 0 2733 8 0 0
t$perf-norm:sp_pay_from_customer 7480 7480 0 0.00 0 8265 9 0 0
t$perf-norm:sp_pay_to_supplier 6193 6193 0 0.00 0 5030 8 0 0
t$perf-norm:sp_reserve_write_off 10235 10235 0 0.00 0 9310 14 0 0
t$perf-norm:sp_supplier_invoice 5659 5659 0 0.00 0 4721 17 0 0
t$perf-norm:sp_supplier_order 5848 5848 0 0.00 0 14956 20 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 4911 65 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 478 9 0 0
t$perf-norm:srv_make_invnt_saldo 595 595 0 0.00 0 2051 17 0 0
t$perf-norm:srv_make_money_saldo 778 778 0 0.00 0 639 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 10682 10438 244 2.28 0 5906 19 0 244
v_all_customers 38862 38862 0 0.00 0 63 1 0 0
v_all_suppliers 32014 32014 0 0.00 0 19 1 0 0
v_all_wares 42530 42530 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 860 860 0 0.00 0 4293 14 0 0
v_cancel_client_order 3814 3814 0 0.00 0 5495 12 0 0
v_cancel_customer_prepayment 1498 1498 0 0.00 0 5738 8 0 0
v_cancel_customer_reserve 1484 1484 0 0.00 0 1212 7 0 0
v_cancel_payment_to_supplier 890 890 0 0.00 0 3167 8 0 0
v_cancel_supplier_invoice 846 826 20 2.36 0 2339 17 0 20
v_cancel_supplier_order 876 876 0 0.00 0 2274 6 0 0
v_cancel_write_off 2014 2014 0 0.00 0 6794 21 0 0
v_max_id_clo_ord 5848 5848 0 0.00 0 550 1 0 0
v_max_id_clo_res 999 999 0 0.00 0 1482 10 0 0
v_max_id_ord_sup 5634 5634 0 0.00 0 3827 4 0 0
v_max_non_paid_invoice 1668 1668 0 0.00 0 4893 7 0 0
v_max_non_paid_realizn 3994 3994 0 0.00 0 6008 6 0 0
v_min_id_clo_ord 5848 5848 0 0.00 0 2779 4 0 0
v_min_id_clo_res 999 999 0 0.00 0 1445 7 0 0
v_min_id_ord_sup 5634 5634 0 0.00 0 9047 10 0 0
v_min_non_paid_invoice 6193 6193 0 0.00 0 16437 18 0 0
v_min_non_paid_realizn 7480 7480 0 0.00 0 10564 14 0 0
v_our_firm 10640 10640 0 0.00 0 93 1 0 0
v_reserve_write_off 20470 20470 0 0.00 0 6766 8 0 0
x_lock_depdocs_on_canc_invoice 11896 11896 0 0.00 0 17319 103 0 0
x_lock_depdocs_on_canc_sup_ord 438 438 0 0.00 0 5686 270 0 0
x_make_qstorno_1000_1200 5848 5848 0 0.00 2 38685 1154 0 0
x_make_qstorno_1200_2000 5659 5659 0 0.00 2 119510 3233 0 0
x_make_qstorno_2100_3300 482535 482535 0 0.00 0 79579 140 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-01-2021 01:28:05 to 17-01-2021 01:28:09.

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:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:20 18931 8192000000 10276561408 10583842816 886446464 9.764 69 49 99 1 904697568 2553216 15697888
22:57:49 22996 8192000000 10349251600 10667802624 1394867552 14.549 100 86 172 0 1428191152 5470480 27853120
22:58:21 20279 8192000000 10385827840 10708254720 1434842176 14.904 100 87 174 1 1470694432 6923104 28929152
22:58:50 13633 8192000000 10393002752 10719301632 1449554688 15.034 100 80 160 0 1483376256 7760688 26060880
22:59:15 19980 8192000000 10422837280 10754453504 1466414192 15.182 100 84 168 0 1501956720 8483248 27059280
22:59:46 24017 8192000000 10450606032 10783920128 1492759808 15.413 100 88 176 0 1529719984 8916160 28044016
23:00:21 18793 8192000000 10470835760 10806784000 1521082032 15.660 100 88 176 0 1558402496 9681824 27638640
23:00:47 23314 8192000000 10472624128 10815610880 1533297616 15.766 100 89 178 1 1571659536 10071712 28290208
23:01:33 20121 8192000000 10520209408 10865754112 1566045952 16.048 100 84 168 1 1601624912 9919936 25659024
23:02:02 16620 8192000000 10536353792 10889719808 1593382192 16.283 100 84 168 1 1629555952 10592688 25581072
23:02:47 11581 8192000000 10566751296 10923208704 1617038368 16.485 100 75 150 1 1650652912 11270928 22343616
23:03:07 13547 8192000000 10587199328 10944835584 1644441264 16.717 100 89 178 0 1682827728 12056032 26330432
23:03:28 12755 8192000000 10599199328 10960232448 1657779760 16.830 100 87 174 0 1696669072 12615056 26274256
23:03:47 10364 8192000000 10614771104 10979561472 1666037616 16.900 100 80 160 3 1702259344 12604064 23617664
23:04:07 5329 8192000000 10617311072 10989117440 1683359520 17.046 100 76 152 0 1717598368 12071360 22167488
23:04:24 7931 8192000000 10643298368 11011026944 1698654560 17.174 100 84 167 1 1735342080 13138720 23548800
23:04:40 7037 8192000000 10656864080 11026030592 1708420256 17.256 100 84 168 0 1746206048 14062352 23723440
23:04:55 9514 8192000000 10667427776 11039502336 1725635168 17.399 100 88 176 0 1765010944 14075472 25300304
23:05:17 6753 8192000000 10675795936 11053355008 1737953168 17.502 100 76 152 2 1773605600 14444304 21208128
23:05:32 3594 8192000000 10686592928 11064967168 1754924080 17.642 100 82 164 0 1791572736 13416304 23232352
23:05:43 5227 8192000000 10708559616 11087089664 1770079952 17.768 100 84 168 1 1807461056 13839504 23541600
23:05:55 4156 8192000000 10712025408 11093000192 1775020864 17.808 100 76 153 2 1813651248 17509328 21121056
23:06:06 3575 8192000000 10717254976 11101409280 1786016448 17.899 100 77 152 3 1819871584 12215040 21640096
23:06:17 3706 8192000000 10728250048 11112239104 1793668384 17.962 100 85 168 0 1828632608 11825936 23138288
23:06:27 11091 8192000000 10733048672 11124486144 1799415168 18.009 100 76 150 4 1833847504 13665264 20767072
23:06:47 2635 8192000000 10751918704 11135295488 1804269120 18.049 100 80 160 1 1840184480 13883008 22032352
23:06:56 2556 8192000000 10763428064 11151233024 1824517440 18.215 100 86 172 0 1862463056 13815760 24129856
23:07:05 1630 8192000000 10758691216 11151118336 1831835840 18.274 100 85 171 1 1869959568 13709392 24414336
23:07:13 1870 8192000000 10778573584 11162386432 1836138912 18.309 100 89 176 3 1874170288 13304768 24726608
23:07:21 1778 8192000000 10786188208 11171758080 1844043312 18.374 100 95 191 2 1883074736 12476192 26555232
23:07:29 1660 8192000000 10791342656 11175403520 1846156352 18.391 100 90 180 3 1885354464 13681296 25516816
23:07:37 2341 8192000000 10792064208 11177668608 1848950128 18.414 100 89 178 2 1887907856 14177024 24780704
23:07:46 2864 8192000000 10794823312 11179802624 1849362992 18.417 100 83 167 1 1886580608 13660576 23557040
23:07:55 2801 8192000000 10798237200 11182620672 1857037312 18.479 100 86 171 0 1893775712 12927008 23811392
23:08:05 1175 8192000000 10799932672 11188027392 1856489680 18.475 100 89 180 0 1896353712 14187216 25676816
23:08:12 1403 8192000000 10805938704 11191644160 1859612720 18.500 100 94 188 1 1900111792 13392192 27106880
23:08:21 1440 8192000000 10819220736 11205189632 1867651792 18.565 100 92 183 1 1907711168 14178864 25880512
23:08:28 41683 8192000000 10769241856 11199000576 1865119696 18.545 100 56 111 0 1891107184 9773424 16214064
23:09:16 1823 8192000000 10797468544 11205890048 1875655232 18.630 100 54 105 2 1895842112 4538416 15648464
23:09:24 7490 8192000000 10781952368 11206262784 1873448048 18.612 100 36 71 4 1891686000 8674112 9563840
23:09:38 5822 8192000000 10789909040 11211247616 1873453664 18.612 100 26 52 1 1887075888 6460896 7161328
23:09:52 5502 8192000000 10784748544 11210887168 1875136720 18.626 100 30 60 1 1891124784 8030240 7957824
23:10:04 6583 8192000000 10784920368 11213262848 1876468528 18.637 100 27 54 2 1892140480 6572848 9099104
23:10:18 8073 8192000000 10793783200 11217670144 1879733728 18.663 100 27 54 1 1893521680 6178400 7609552
23:10:33 10589 8192000000 10783814544 11218067456 1881791648 18.680 100 23 47 0 1893967744 5737680 6438416
23:10:51 9754 8192000000 10789536592 11224801280 1883785872 18.696 100 22 44 0 1896372896 6261728 6325296
23:11:08 5676 8192000000 10808436144 11227348992 1885659584 18.711 100 22 45 2 1897613184 5850592 6103008
23:11:21 11729 8192000000 10795655648 11229077504 1886814864 18.720 100 20 39 2 1898114448 5835376 5464208
23:11:39 17266 8192000000 10793180336 11226906624 1885286000 18.708 100 9 18 1 1893694528 5902224 2506304
23:12:03 13688 8192000000 10801168496 11232260096 1893560688 18.774 100 29 58 2 1907390128 5974704 7854736
23:12:23 69128 8192000000 10828273312 11246010368 1895585968 18.791 100 43 87 3 1913552240 5396256 12570016
23:13:39 5467 8192000000 10814817696 11243302912 1895001792 18.786 100 36 73 4 1913581376 8824048 9755536
23:13:53 3634 8192000000 10807157568 11244273664 1899135680 18.819 100 34 66 2 1915925024 7095632 9693712
23:14:05 3451 8192000000 10836032032 11248345088 1900052960 18.827 100 40 80 1 1918742704 7380368 11309376
23:14:18 4502 8192000000 10828892864 11255799808 1901581456 18.839 100 35 71 1 1919156352 7023248 10551648
23:14:29 7769 8192000000 10823155552 11254472704 1901805856 18.841 100 24 48 1 1914128256 5705648 6616752
23:14:44 9560 8192000000 10810578000 11251499008 1904877248 18.866 100 37 74 0 1922652512 6871808 10903456
23:15:00 8766 8192000000 10823070528 11253727232 1900527536 18.831 100 15 29 2 1910218864 5369120 4322208
23:15:19 9930 8192000000 10827364496 11263500288 1906197504 18.876 100 16 32 1 1916603952 6065360 4341088
23:15:37 7015 8192000000 10823914768 11258163200 1890831536 18.752 99 19 38 2 1906338464 10319664 5187264
23:15:55 9295 8192000000 10821603552 11255341056 1905354560 18.869 100 23 46 1 1917882256 6170704 6356992
23:16:11 7050 8192000000 10818194304 11256475648 1905963616 18.874 100 16 31 2 1916105888 6096256 4046016
23:16:26 8454 8192000000 10819117888 11255296000 1893637696 18.775 99 16 31 2 1904028624 5470688 4920240
23:16:41 13382 8192000000 10809570016 11240312832 1868644464 18.573 98 18 36 1 1883523856 9997408 4881984
23:17:05 77160 8192000000 10790481696 11222790144 1778947776 17.841 93 37 74 2 1794211488 4726560 10537152
23:18:30 7133 8192000000 10789478576 11214151680 1835888688 18.307 97 29 58 2 1850083296 6509600 7685008
23:18:44 6820 8192000000 10760222784 11179503616 1808670848 18.085 97 26 51 1 1822620864 5877152 8072864
23:18:58 8355 8192000000 10769170272 11202465792 1855137968 18.464 100 22 44 0 1867439872 6098336 6203568
23:19:13 5203 8192000000 10772356768 11195240448 1840582528 18.346 99 30 60 1 1855056848 6061360 8412960
23:19:25 4713 8192000000 10722283968 11137236992 1749729072 17.599 95 34 68 2 1766284144 7026160 9528912
23:19:36 7788 8192000000 10713602656 11136491520 1718636928 17.341 94 20 40 0 1730554304 5572336 6345040
23:19:51 8444 8192000000 10652314416 11060006912 1617003984 16.484 89 31 62 2 1632950384 5725056 10221344
23:20:06 7901 8192000000 10662270128 11074756608 1652645312 16.787 93 24 48 2 1665193312 5077648 7470352
23:20:20 10266 8192000000 10690878048 11112660992 1762551088 17.705 99 26 53 0 1776447760 6684720 7211952
23:20:38 9955 8192000000 10691703408 11110608896 1752290720 17.621 98 21 42 0 1763676624 5280176 6105728
23:20:54 8846 8192000000 10689727168 11100549120 1689606848 17.098 94 32 64 2 1704327088 5395152 9325088
23:21:09 8768 8192000000 10695527328 11113013248 1766136400 17.735 99 23 46 1 1778164496 5428000 6600096
23:21:26 10763 8192000000 10723409392 11133734912 1798513424 18.002 100 23 46 0 1811160160 5102176 7544560
23:21:45 73242 8192000000 10703474432 11118256128 1758435312 17.671 97 37 74 1 1774477408 5317600 10724496
23:23:09 8279 8192000000 10698489200 11111424000 1761310576 17.695 98 33 63 1 1775723504 5643024 8769904
23:23:24 9885 8192000000 10719363744 11137536000 1800107888 18.015 100 37 75 1 1817697312 7572688 10016736
23:23:41 7864 8192000000 10741410944 11153051648 1813521264 18.125 100 38 76 0 1833931392 10423824 9986304
23:23:57 6159 8192000000 10744340224 11159711744 1824223024 18.212 100 43 86 2 1842881152 6303776 12354352
23:24:10 10880 8192000000 10749322864 11164672000 1830276928 18.262 100 23 46 2 1842538336 5742432 6518976
23:24:27 8022 8192000000 10744354048 11172925440 1836717088 18.314 100 22 43 3 1848618912 5759504 6142320
23:24:41 10821 8192000000 10752367280 11179692032 1843478576 18.369 100 23 46 1 1855855376 5256768 7120032
23:24:58 6536 8192000000 10753018576 11183591424 1846112320 18.391 100 22 44 4 1858110128 5510432 6487376
23:25:13 6658 8192000000 10761155744 11188137984 1850291616 18.424 100 27 53 2 1865090544 5862576 8936352
23:25:27 10824 8192000000 10771637008 11197308928 1850803664 18.429 100 23 47 1 1862590608 5065200 6721744
23:25:44 8820 8192000000 10777463200 11194818560 1852854736 18.445 100 19 38 0 1864725872 5792048 6079088
23:25:59 11157 8192000000 10772716048 11198955520 1856086224 18.472 100 15 28 1 1866260832 6462816 3711792
23:26:18 9290 8192000000 10783710960 11201691648 1861573264 18.516 100 17 34 1 1872271984 5650512 5048208
23:26:33 18532 8192000000 10785730800 11206225920 1867497600 18.564 100 25 50 2 1880176464 4985264 7693600
23:27:00 129789 8192000000 10818839456 11243528192 1886470080 18.717 100 33 66 1 1902075376 5690368 9914928
23:29:26 22830 8192000000 10841214832 11262386176 1910120192 18.908 100 33 66 3 1927727120 7827056 9779872
23:30:03 25758 8192000000 10836691040 11271806976 1919731136 18.985 100 33 66 1 1939899952 10613072 9555744
23:30:35 12142 8192000000 10856533808 11285901312 1931112192 19.076 100 39 78 0 1952648288 10319216 11216880
23:30:55 6018 8192000000 10880805392 11302985728 1944956384 19.186 100 59 120 0 1975031264 12292448 17782432
23:31:10 14838 8192000000 10882533984 11307036672 1950838992 19.233 100 55 104 3 1979464496 13573200 15052304
23:31:32 4240 8192000000 10894861392 11317497856 1954160224 19.260 100 63 128 1 1987167184 14069872 18937088
23:31:53 21952 8192000000 10897130160 11327787008 1958548304 19.295 100 53 105 0 1989754576 15965888 15240384
23:32:24 7665 8192000000 10901617984 11329544192 1964827488 19.344 100 55 110 1 1995673616 14875952 15970176
23:32:40 3912 8192000000 10917010336 11324968960 1962439568 19.325 100 72 141 0 1997604496 14081904 21083024
23:32:53 5278 8192000000 10905078528 11332079616 1968195696 19.371 100 56 111 1 1999362128 15122800 16043632
23:33:09 5829 8192000000 10928174928 11338801152 1972992736 19.409 100 69 137 0 2009601008 16366704 20241568
23:33:23 11794 8192000000 10917539040 11345944576 1972316256 19.404 100 59 118 1 2009092976 18281504 18495216
23:33:47 6810 8192000000 10927753168 11352330240 1976762480 19.439 100 58 116 0 2013533072 19541856 17228736
23:34:04 27505 8192000000 10908302816 11357929472 1979764432 19.463 100 40 80 1 2006476352 15027568 11684352
23:34:47 6599 8192000000 10925220944 11358040064 1985645520 19.509 100 42 84 1 2011781376 13969264 12166592
23:35:09 11886 8192000000 10935212368 11368923136 1997935056 19.606 100 60 120 2 2031621040 16349488 17336496
23:35:30 6075 8192000000 10951477808 11376148480 2002142400 19.640 100 59 118 1 2035684112 16697584 16844128
23:35:45 2551 8192000000 10957548080 11379298304 2007769472 19.684 100 70 138 2 2046116880 17083888 21263520
23:35:55 9515 8192000000 10959824320 11389906944 2011790064 19.716 100 59 118 0 2049410320 20611968 17008288
23:36:16 11338 8192000000 10960593696 11392466944 2010541568 19.706 100 57 114 1 2048823008 21084112 17197328
23:36:35 11199 8192000000 10960290352 11392204800 2012829488 19.724 100 60 118 3 2052616432 21932864 17854080
23:36:54 6640 8192000000 10964256912 11398914048 2014793136 19.739 100 54 108 1 2053603504 22634256 16176112
23:37:09 6326 8192000000 10964170784 11395141632 2016839792 19.755 100 60 120 1 2056241536 21167072 18234672
23:37:24 7557 8192000000 10963772704 11398602752 2017609024 19.761 100 55 109 1 2056575280 21570016 17396240
23:37:43 5125 8192000000 10964140352 11396030464 2014325088 19.736 100 65 130 1 2056419120 22756320 19337712
23:37:57 7637 8192000000 10960102000 11385483264 1999490000 19.619 99 68 136 1 2042830160 23259904 20080256
23:38:11 6577 8192000000 10970158496 11399933952 2015699536 19.746 100 66 131 0 2061150800 25291184 20160080
23:38:32 9795 8192000000 10978151712 11405307904 2019463936 19.776 100 61 122 1 2064004528 25450480 19090112
23:38:50 2470 8192000000 10969508048 11402121216 2014637376 19.738 100 56 109 1 2057472592 25459408 17375808
23:39:04 6786 8192000000 10983882992 11418980352 2023701040 19.809 100 58 113 1 2068099776 26465472 17933264
23:39:17 4679 8192000000 10982527680 11419525120 2021981136 19.796 100 55 109 0 2066399872 28185424 16233312
23:39:29 4522 8192000000 10988440512 11413446656 2011193840 19.711 99 80 160 1 2065560288 29836128 24530320
23:39:40 7612 8192000000 10993967776 11421278208 2027632320 19.840 100 74 148 1 2080818048 30588224 22597504
23:39:56 5408 8192000000 10978151952 11411263488 2017855648 19.763 100 62 122 0 2067982688 30996960 19130080
23:40:13 2680 8192000000 10992230512 11417255936 2025170320 19.821 100 83 162 0 2079974048 29517872 25285856
23:40:24 10289 8192000000 10971974096 11413286912 2013949056 19.733 100 58 116 2 2064528256 31752752 18826448
23:40:41 12751 8192000000 10975551840 11410808832 1997266048 19.601 99 49 98 2 2044409648 30452592 16691008
23:41:02 1689 8192000000 10980135536 11406524416 2010623872 19.706 100 63 124 2 2061087888 30138352 20325664
23:41:12 1502 8192000000 10962319856 11377704960 1983229136 19.490 99 81 163 1 2039816032 30729248 25857648
23:41:21 3877 8192000000 10960062320 11382784000 1989896592 19.543 100 69 137 1 2041176160 30267344 21012224
23:41:34 5040 8192000000 10952133024 11377393664 1984311152 19.499 100 72 144 1 2036231744 29909488 22011104
23:41:47 7202 8192000000 10942118352 11367899136 1979157088 19.458 100 73 147 0 2034741072 33401664 22182320
23:42:04 7492 8192000000 10947345632 11376820224 1984129360 19.497 100 53 105 0 2027520976 27599136 15792480
23:42:19 15152 8192000000 10951094208 11389612032 1989536384 19.540 100 51 101 1 2035132880 30602832 14993664
23:42:43 11821 8192000000 10962643104 11398561792 2003052784 19.647 100 53 106 1 2052399392 33219712 16126896
23:43:06 5809 8192000000 10922604336 11352690688 1943479104 19.175 98 60 118 1 1993461472 31845392 18136976
23:43:21 7366 8192000000 10938407792 11358625792 1933405504 19.094 98 57 113 0 1983808800 33413664 16989632
23:43:39 3390 8192000000 10954143040 11373756416 1973889168 19.416 100 73 145 2 2033389472 36954272 22546032
23:43:50 7143 8192000000 10928760784 11360669696 1951797200 19.241 99 56 110 2 2003779456 34867872 17114384
23:44:04 4150 8192000000 10939256688 11359825920 1935290352 19.109 98 73 144 0 1993327600 35181120 22856128
23:44:15 2552 8192000000 10964321632 11377131520 1975430608 19.429 100 89 176 1 2042276032 40019552 26825872
23:44:25 1562 8192000000 10973417072 11389239296 1985871632 19.511 100 92 183 1 2055492336 41864416 27756288
23:44:34 2070 8192000000 10961598144 11370135552 1971842448 19.400 100 93 183 0 2042984224 43338960 27802816
23:44:43 2807 8192000000 10952352928 11362746368 1960765104 19.312 100 90 180 0 2033558336 44891824 27901408
23:44:52 1956 8192000000 10953254544 11373248512 1965045632 19.346 100 86 172 2 2037252864 45174192 27033040
23:45:05 7087 8192000000 10932362416 11355553792 1946918816 19.202 100 59 117 3 2007301360 41873856 18508688
23:45:22 3235 8192000000 10923080352 11340615680 1945157184 19.188 100 66 131 0 2004587120 38743280 20686656
23:45:35 3608 8192000000 10928375504 11349123072 1937663952 19.128 99 66 130 1 1998459488 39531920 21263616
23:45:46 5161 8192000000 10944059248 11365949440 1964156688 19.339 100 74 148 1 2030397232 43160640 23079904
23:45:58 6678 8192000000 10932657568 11352379392 1941865408 19.162 99 73 145 2 2006841056 42652144 22323504
23:46:15 7825 8192000000 10941084944 11368198144 1942105440 19.164 99 53 106 1 2007886512 48383616 17397456
23:46:31 9336 8192000000 10946931888 11375722496 1962473760 19.326 100 54 109 4 2031855776 50938784 18443232
23:46:47 11500 8192000000 10956775088 11389071360 1970457520 19.389 100 40 80 1 2032592304 47584608 14550176
23:47:06 6538 8192000000 10971707936 11396591616 1980087680 19.465 100 58 117 2 2049746480 49691312 19967488
23:47:22 1788 8192000000 10978522400 11403657216 1982471600 19.484 100 69 136 2 2059154208 53934976 22747632
23:47:34 6258 8192000000 10954404416 11395325952 1961690464 19.319 99 44 88 2 2033527856 56025808 15811584
23:47:47 6336 8192000000 10956507840 11395190784 1976913904 19.440 100 45 89 1 2036378752 44250240 15214608
23:48:02 10677 8192000000 10942604752 11385655296 1950305504 19.229 99 39 78 2 2007951008 44257712 13387792
23:48:20 10146 8192000000 10936764736 11388645376 1967501664 19.366 100 28 56 2 2022745744 45354720 9889360
23:48:37 10420 8192000000 10916619296 11361218560 1926475216 19.039 98 33 66 2 1969381520 32645312 10260992
23:48:56 11639 8192000000 10921982704 11371094016 1962610464 19.327 100 24 48 1 2003409936 32932832 7866640
23:49:14 15731 8192000000 10910411600 11355684864 1925270464 19.029 98 27 54 2 1967691696 33932768 8488464
23:49:41 15222 8192000000 10925045936 11373637632 1964028208 19.338 100 34 68 1 2013129760 38085728 11015824
23:50:03 14780 8192000000 10932492960 11377643520 1970100320 19.386 100 23 46 0 2012782768 34993904 7688544
23:50:28 10098 8192000000 10894674752 11345297408 1920405408 18.990 99 21 42 1 1962571328 35153888 7012032
23:50:48 18387 8192000000 10894651296 11341430784 1907518000 18.887 98 25 50 0 1955195776 39542480 8135296
23:51:14 9895 8192000000 10914574080 11353948160 1941516416 19.159 100 32 63 1 1991114672 38963920 10634336
23:51:35 13536 8192000000 10926000224 11366502400 1952355680 19.245 100 28 57 1 2002368656 40759344 9253632
23:51:55 12337 8192000000 10897132624 11341713408 1908181776 18.892 98 30 61 2 1955196720 37297216 9717728
23:52:24 21845 8192000000 10906337792 11348094976 1934148896 19.100 100 26 52 0 1983154016 40165392 8839728
23:53:02 19005 8192000000 10892304048 11342950400 1924740592 19.025 99 25 50 1 1967374576 34629264 8004720
23:53:45 36397 8192000000 10883826016 11329495040 1906512656 18.879 99 21 42 2 1950367696 35875776 7979264
23:54:55 54677 8192000000 10848791664 11309502464 1887725184 18.727 98 8 16 1 1912112672 21894496 2492992
23:55:56 17558 8192000000 10862937904 11296854016 1894833728 18.785 98 51 97 1 1916143744 6930944 14379072
23:56:25 21587 8192000000 10850444560 11299651584 1902389776 18.846 99 23 46 1 1920223184 11225664 6607744
23:56:53 50692 8192000000 10870590848 11334524928 1925807408 19.033 100 10 20 0 1940169648 11762096 2600144
23:57:50 65177 8192000000 10877366848 11334668288 1918330592 18.973 98 32 62 2 1938365856 10776928 9258336
23:59:34 48638 8192000000 10904772064 11340283904 1939240944 19.141 99 24 47 1 1953988256 8645504 6101808
00:00:32 21300 8192000000 10877600800 11333849088 1935066352 19.107 99 19 38 1 1947968736 7683792 5218592
00:01:00 27126 8192000000 10889908096 11340173312 1936606352 19.120 99 14 28 1 1949517184 9054848 3855984
00:01:43 75579 8192000000 10910271728 11370536960 1932453376 19.086 99 11 22 0 1951209696 15896512 2859808
00:03:06 133429 8192000000 10900779408 11364720640 1958009936 19.290 100 25 49 2 1985873696 19761168 8102592
00:05:26 67052 8192000000 10890915472 11363454976 1946664688 19.200 99 30 60 0 1968679024 13081184 8933152
00:06:43 69022 8192000000 10892043840 11353817088 1906380608 18.878 97 24 48 0 1932675648 19876784 6418256
00:07:59 3735 8192000000 10895474816 11346329600 1961025296 19.314 100 44 84 1 1980085184 7357200 11702688
00:08:15 9499 8192000000 10916945168 11369607168 1976130080 19.434 100 41 82 3 2003000080 14902736 11967264
00:08:30 20586 8192000000 10900591360 11364708352 1973182976 19.411 100 24 48 1 1995299600 14943088 7173536
00:09:05 46757 8192000000 10920050976 11372421120 1957670672 19.288 99 41 79 1 1983286576 14454560 11161344
00:10:00 26903 8192000000 10936658864 11382571008 1980564880 19.469 100 45 90 2 2010270928 16565872 13140176
00:10:36 45760 8192000000 10920715200 11390083072 1989998768 19.544 100 40 79 1 2018335312 16015248 12321296
00:11:51 40468 8192000000 10907543968 11400081408 1980813520 19.471 100 18 36 4 2007724400 21017472 5893408
00:12:38 48510 8192000000 10912391584 11387854848 1971075488 19.394 99 16 32 1 1987724976 12145040 4504448
00:13:34 31314 8192000000 10915771952 11386347520 1984759152 19.502 100 8 16 0 2002669040 15072800 2837088
00:14:11 28289 8192000000 10924860336 11402543104 1989194832 19.537 100 16 32 0 2012942048 18557280 5189936
00:15:34 71541 8192000000 10907434768 11393253376 1955945024 19.274 98 17 34 1 1975756544 14646064 5165456
00:17:16 67005 8192000000 10914833120 11415027712 1987481456 19.524 100 17 34 1 2011064208 18928192 4654560
00:18:29 49634 8192000000 10930585552 11403583488 1998121008 19.608 100 16 31 1 2013817664 11930880 3765776
00:19:26 38642 8192000000 10927893648 11399909376 1970255968 19.387 98 33 66 0 1987869424 8071216 9542240
00:20:11 66451 8192000000 10892519152 11376091136 1898884288 18.817 95 14 26 3 1912028544 9293472 3850784
00:21:23 68281 8192000000 10911220256 11376545792 1887372352 18.725 95 18 36 0 1906638416 14938256 4327808
00:22:38 150441 8192000000 10875502752 11343323136 1795703120 17.979 91 14 28 2 1817069728 17088432 4278176
00:25:15 55425 8192000000 10902367664 11363336192 1940728272 19.153 99 21 42 1 1955624784 9172400 5724112
00:26:18 60326 8192000000 10884160000 11338784768 1867412272 18.563 95 26 52 3 1884133232 9482864 7238096
00:27:25 87500 8192000000 10881576352 11351707648 1844204656 18.375 94 15 30 3 1858508208 10519088 3784464
00:28:59 84942 8192000000 10883706016 11361468416 1913029392 18.931 98 13 26 0 1936804368 19893984 3880992
00:30:30 84838 8192000000 10849206048 11324715008 1793185008 17.958 92 6 12 0 1808663600 14270464 1208128
00:32:01 124510 8192000000 10875902672 11358625792 1931477536 19.079 99 15 28 2 1945825936 10314992 4033408
00:34:24 61640 8192000000 10892551904 11367325696 1961910496 19.321 100 22 44 1 1976078128 7564208 6603424
00:35:32 38158 8192000000 10898670048 11356856320 1917001776 18.963 97 43 86 1 1939033792 10137872 11894144
00:36:37 60800 8192000000 10819106048 11295244288 1831564160 18.272 94 7 14 0 1840406432 7062016 1780256
00:37:57 60962 8192000000 10833866784 11305955328 1851704848 18.436 96 8 16 1 1864481024 10950112 1826064
00:39:04 84721 8192000000 10832849040 11295899648 1816706192 18.151 94 11 21 0 1831010864 11444752 2859920
00:40:35 61818 8192000000 10875504784 11327385600 1926476560 19.039 100 14 29 1 1940966384 9984400 4505424
00:41:46 62905 8192000000 10840139120 11313487872 1877654880 18.646 97 17 34 0 1893568208 10726832 5186496
00:43:01 84622 8192000000 10858335488 11318702080 1909306800 18.901 99 29 58 0 1930091680 11878144 8906736
00:44:39 52227 8192000000 10859037712 11331149824 1914237520 18.941 99 39 78 1 1938343648 12228112 11878016
00:45:42 38685 8192000000 10842093984 11318894592 1917667712 18.968 100 14 28 1 1932479600 10580208 4231680
00:46:29 29029 8192000000 10839948800 11298402304 1883803856 18.696 98 39 78 1 1903643776 8721376 11118544
00:47:21 79604 8192000000 10843667552 11326275584 1907760080 18.889 99 19 38 0 1928064944 15185552 5119312
00:48:47 37855 8192000000 10840733056 11327934464 1920315952 18.989 100 8 16 0 1939313232 16980272 2017008
00:49:46 29538 8192000000 10845465456 11340034048 1904508464 18.863 99 5 10 0 1922177680 16509568 1159648
00:50:22 45056 8192000000 10850028192 11331899392 1894679520 18.783 98 15 30 1 1908816784 10074512 4062752
00:51:23 78605 8192000000 10862207264 11345924096 1934566464 19.103 100 8 16 1 1950826224 13888688 2371072
00:52:48 37674 8192000000 10879638752 11346173952 1929388128 19.062 99 25 49 0 1946420336 10338560 6693648
00:53:32 64872 8192000000 10894538944 11367489536 1955337888 19.269 100 28 56 0 1978967600 15634928 7994784
00:54:45 52965 8192000000 10885011680 11360280576 1956875088 19.281 100 11 21 0 1974621040 13987344 3758608
00:55:44 54886 8192000000 10885637696 11345461248 1904904128 18.866 97 25 50 0 1920076464 8090496 7081840
00:56:46 16056 8192000000 10916985872 11353812992 1957514192 19.286 100 57 112 0 1984598848 11162528 15922128
00:57:11 22127 8192000000 10920152896 11371155456 1965530784 19.350 100 50 99 0 1992219936 13537600 13151552
00:57:39 72261 8192000000 10880930464 11355418624 1904008064 18.859 97 18 36 2 1920460976 11719904 4733008
00:58:58 36177 8192000000 10908003616 11367784448 1950068208 19.227 99 20 39 1 1964883584 10121376 4694000
00:59:47 90920 8192000000 10904884208 11371900928 1931951632 19.082 98 18 36 1 1949303344 13168208 4183504
01:01:24 66151 8192000000 10887935520 11361038336 1907285120 18.885 97 9 19 0 1921361040 12099936 1975984
01:02:36 48872 8192000000 10906709584 11370692608 1957075424 19.283 99 25 47 3 1977629408 12594160 7959824
01:03:34 47435 8192000000 10899686096 11383324672 1948307952 19.213 99 10 20 0 1967957312 16194176 3455184
01:04:28 110013 8192000000 10884892576 11356700672 1912979488 18.931 97 19 38 0 1928541376 9806416 5755472
01:06:24 98524 8192000000 10889989696 11369394176 1919472896 18.983 97 20 40 1 1933919392 8801408 5645088
01:08:09 4708 8192000000 10893028960 11372683264 1968221984 19.371 100 25 49 1 1986782640 11310272 7250384
01:08:20 14926 8192000000 10883215376 11356381184 1954891616 19.265 100 13 26 0 1967811696 9078480 3841600
01:08:41 12843 8192000000 10885076048 11359911936 1962116576 19.323 100 15 29 0 1973059664 7238752 3704336
01:09:02 72229 8192000000 10865708400 11347873792 1916344672 18.958 97 10 19 2 1930139776 10507280 3287824
01:10:21 43178 8192000000 10876923728 11356602368 1920242512 18.989 98 8 16 0 1931176336 8960128 1973696
01:12:07 79486 8192000000 10857414304 11327148032 1880505664 18.669 96 13 26 1 1895636336 11417648 3713024
01:13:40 60469 8192000000 10868450464 11346919424 1938583776 19.135 100 9 18 0 1954826368 13462400 2780192
01:14:56 70656 8192000000 10870348512 11349102592 1917802368 18.969 98 14 28 1 1931935776 10419440 3713968
01:16:13 42083 8192000000 10865131088 11333816320 1922368448 19.006 98 25 49 1 1936280128 6113264 7798416
01:17:08 39724 8192000000 10864103776 11334750208 1929060432 19.059 99 16 33 2 1942450848 8653360 4737056
01:18:05 35805 8192000000 10858865520 11323174912 1918910640 18.978 99 40 81 1 1941582384 11348400 11323344
01:18:51 31787 8192000000 10860788032 11327713280 1918517488 18.975 99 33 64 0 1938404432 9886432 10000512
01:19:44 50111 8192000000 10830091744 11288600576 1862881136 18.527 96 24 48 0 1877782080 8125360 6775584
01:20:40 44582 8192000000 10866916496 11333832704 1912775744 18.929 99 17 35 1 1929028544 11273312 4979488
01:21:39 49368 8192000000 10853733568 11317579776 1879450608 18.661 97 16 32 0 1894592320 10975376 4166336
01:22:40 40600 8192000000 10869503024 11334492160 1935813808 19.113 100 21 42 3 1950085664 8780832 5491024
01:23:27 54616 8192000000 10871683280 11327029248 1868638208 18.573 96 27 54 2 1888314016 11966944 7708864
01:24:30 34176 8192000000 10891219392 11341905920 1926246512 19.037 99 41 82 2 1951966928 14276416 11444000
01:25:13 87797 8192000000 10799130560 11263062016 1802628720 18.035 94 16 32 1 1825457792 18302656 4526416
01:26:55 26688 8192000000 9255852576 9516683264 409100416 4.756 22 1 2 0 413156480 3993936 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 17-01-2021 01:28:11 to 17-01-2021 01:28:42.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 122 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-01-2021 01:28:43 to 17-01-2021 01:28:45.

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          245330
MON$OLDEST_ACTIVE               245331
MON$OLDEST_SNAPSHOT             245331
MON$NEXT_TRANSACTION            245331
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                       2043936
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:993: 
:994: mscs-test-161.budzdorov.ru    Sun Jan 17 01:27:23 2021
:995:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:996: 
:997: 
:998: mscs-test-161.budzdorov.ru    Sun Jan 17 01:27:23 2021
:999:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1000: 
--- end of diff output ---

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

17.01.21 01:28:46. 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-01-17 01:28:49 No severe PSQL-related problems occured
17.01.21 01:28:50. End of report.