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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17364912 kB
MemAvailable 31535484 kB
Buffers 0 kB
Cached 14361132 kB
SwapCached 3696 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-21 01:27:07
DTS_END                         2020-12-21 01:27:07.3930
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35312
TRN_ID                          244404
ATT_ID                          728
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: 9557.31 20433 1146877
customer order: creation 175.28 347 21033
customer order: refuse 14.88 306 1786
order to supplier: creation 46.27 1152 5552
order to supplier: removal 3.43 85368 412
invoice (draft): creation 46.76 3072 5611
invoice (draft): removal 54.73 612 6567
invoice accept: apply 42.86 16572 5143
invoice accept: cancel 49.67 702 5960
customer reserve: creation 3924.94 164 470993
customer reserve: removal 4906.05 47 588726
realization accept: apply 83.53 155 10023
realization accept: cancel 79.72 96 9567
payment from customer: creation 59.42 100 7130
payment from customer: removal 5.74 65 689
payment to supplier: creation 48.84 110 5861
payment to supplier: removal 3.18 72 381
service: total inventory turnovers 4.82 992 578
service: total monetary turnovers 6.36 28 763
service: aggregate perf. data 0.82 20832 98
service: refresh index statistics 0.03 277870 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-12-2020 01:29:24 to 21-12-2020 01:29:26.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7612
TEST_TIME 2 6936
TEST_TIME 3 6226
TEST_TIME 4 5936
TEST_TIME 5 6718
TEST_TIME 6 7105
TEST_TIME 7 7608
TEST_TIME 8 7608
TEST_TIME 9 7729
TEST_TIME 10 7936
TEST_TIME 11 8479
TEST_TIME 12 8464
TEST_TIME 13 9119
TEST_TIME 14 9241
TEST_TIME 15 9681
TEST_TIME 16 10420
TEST_TIME 17 10173
TEST_TIME 18 10103
TEST_TIME 19 10500
TEST_TIME 20 10663
TEST_TIME 21 11329
TEST_TIME 22 11995
TEST_TIME 23 12206
TEST_TIME 24 11796
TEST_TIME 25 11592
TEST_TIME 26 11443
TEST_TIME 27 11409
TEST_TIME 28 11263
TEST_TIME 29 11073
TEST_TIME 30 10854
TEST_TIME 31 10735
TEST_TIME 32 10622
TEST_TIME 33 10635
TEST_TIME 34 10468
TEST_TIME 35 10439
TEST_TIME 36 10399
TEST_TIME 37 10382
TEST_TIME 38 10297
TEST_TIME 39 10424
TEST_TIME 40 10296
TEST_TIME 41 10341
TEST_TIME 42 10333
TEST_TIME 43 10321
TEST_TIME 44 10440
TEST_TIME 45 10668
TEST_TIME 46 10579
TEST_TIME 47 10714
TEST_TIME 48 10655
TEST_TIME 49 10506
TEST_TIME 50 10400
TEST_TIME 51 10326
TEST_TIME 52 10244
TEST_TIME 53 10171
TEST_TIME 54 10081
TEST_TIME 55 9976
TEST_TIME 56 9939
TEST_TIME 57 9900
TEST_TIME 58 9834
TEST_TIME 59 10010
TEST_TIME 60 9984
TEST_TIME 61 9914
TEST_TIME 62 9986
TEST_TIME 63 10034
TEST_TIME 64 10011
TEST_TIME 65 10119
TEST_TIME 66 10026
TEST_TIME 67 10128
TEST_TIME 68 10108
TEST_TIME 69 10095
TEST_TIME 70 10124
TEST_TIME 71 10220
TEST_TIME 72 10228
TEST_TIME 73 10093
TEST_TIME 74 10034
TEST_TIME 75 10002
TEST_TIME 76 9944
TEST_TIME 77 9867
TEST_TIME 78 9826
TEST_TIME 79 9751
TEST_TIME 80 9773
TEST_TIME 81 9834
TEST_TIME 82 9872
TEST_TIME 83 9819
TEST_TIME 84 9832
TEST_TIME 85 9815
TEST_TIME 86 9892
TEST_TIME 87 9958
TEST_TIME 88 9976
TEST_TIME 89 9968
TEST_TIME 90 9940
TEST_TIME 91 9981
TEST_TIME 92 10063
TEST_TIME 93 9974
TEST_TIME 94 9891
TEST_TIME 95 9846
TEST_TIME 96 9830
TEST_TIME 97 9829
TEST_TIME 98 9809
TEST_TIME 99 9766
TEST_TIME 100 9739
TEST_TIME 101 9758
TEST_TIME 102 9833
TEST_TIME 103 9813
TEST_TIME 104 9782
TEST_TIME 105 9741
TEST_TIME 106 9806
TEST_TIME 107 9834
TEST_TIME 108 9848
TEST_TIME 109 9803
TEST_TIME 110 9929
TEST_TIME 111 9872
TEST_TIME 112 9798
TEST_TIME 113 9783
TEST_TIME 114 9767
TEST_TIME 115 9760
TEST_TIME 116 9720
TEST_TIME 117 9683
TEST_TIME 118 9661
TEST_TIME 119 9627
TEST_TIME 120 9565

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-12-2020 01:29:28 to 21-12-2020 01:29:31.

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 1584441 1584441 0 0.00 0 17441 5 0 0
doc_list_biud 1584440 1584440 0 0.00 0 46265 22 0 0
sp_add_invoice_to_stock 5260 5143 117 2.22 35 147558 16572 0 117
sp_cancel_adding_invoice 5960 5960 0 0.00 5 74197 702 0 0
sp_cancel_client_order 1786 1786 0 0.00 4 15393 306 0 0
sp_cancel_customer_reserve 588726 588726 0 0.00 1 46270 48 0 0
sp_cancel_pay_from_customer 689 689 0 0.00 3 4589 66 0 0
sp_cancel_pay_to_supplier 381 381 0 0.00 3 6605 72 0 0
sp_cancel_supplier_invoice 6576 6567 9 0.13 2 15739 612 0 9
sp_cancel_supplier_order 412 412 0 0.00 7 942316 85369 0 0
sp_cancel_write_off 9567 9567 0 0.00 1 10355 96 0 0
sp_client_order 21033 21033 0 0.00 4 34255 347 0 0
sp_customer_reserve 470993 470993 0 0.00 0 92652 165 0 0
sp_fill_shopping_cart 32182 32182 0 0.00 1 12122 36 0 0
sp_fill_shopping_cart_clo_res 470977 470977 0 0.00 0 16363 14 0 0
sp_get_clo_for_invoice 5125 5125 0 0.00 0 30963 369 0 0
sp_kill_cost_storno 16597 16597 0 0.00 0 8011 44 0 0
sp_kill_qstorno_ret_qs2qd 1193998 1193998 0 0.00 0 44479 26 0 0
sp_kill_qty_storno 628166 628166 0 0.00 0 46264 56 0 0
sp_lock_selected_doc 20946 20946 0 0.00 0 6501 6 0 0
sp_make_cost_storno 28139 28139 0 0.00 0 17427 49 0 0
sp_multiply_rows_for_pdistr 28139 28139 0 0.00 0 6800 23 0 0
sp_multiply_rows_for_qdistr 21033 21033 0 0.00 0 34247 158 0 0
sp_pay_from_customer 7130 7130 0 0.00 4 13077 101 0 0
sp_pay_to_supplier 5861 5861 0 0.00 5 10072 111 0 0
sp_payment_common 12991 12991 0 0.00 1 13066 28 0 0
sp_qd_handle_on_cancel_clo 1786 1786 0 0.00 0 15376 274 0 0
sp_qd_handle_on_invoice_upd_sts 11085 11085 0 0.00 0 26585 285 0 0
sp_qd_handle_on_reserve_upd_sts 10023 10023 0 0.00 0 20016 52 0 0
sp_reserve_write_off 10023 10023 0 0.00 6 20071 156 0 0
sp_supplier_invoice 5611 5611 0 0.00 7 79063 3073 0 0
sp_supplier_order 5552 5552 0 0.00 5 40625 1152 0 0
srv_aggregate_perf_data 98 98 0 0.00 2378 488618 20832 0 0
srv_fill_mon_cache_memory 144 144 0 0.00 1521 186740 37009 0 0
srv_find_qd_qs_mism 1099281 1099281 0 0.00 0 17357 4 0 0
srv_make_invnt_saldo 578 578 0 0.00 30 40020 992 0 0
srv_make_money_saldo 763 763 0 0.00 0 4274 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 118499 474923 277870 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5143 5143 0 0.00 0 18419 173 0 0
t$perf-norm:sp_cancel_adding_invoice 427 427 0 0.00 0 3623 85 0 0
t$perf-norm:sp_cancel_client_order 1786 1786 0 0.00 0 3446 13 0 0
t$perf-norm:sp_cancel_customer_reserve 756 756 0 0.00 0 2318 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 689 689 0 0.00 0 4482 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 381 381 0 0.00 0 4671 19 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 2417 14 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 17778 1402 0 0
t$perf-norm:sp_cancel_write_off 961 961 0 0.00 0 2445 12 0 0
t$perf-norm:sp_client_order 21033 21033 0 0.00 0 6543 15 0 0
t$perf-norm:sp_customer_reserve 1058 1058 0 0.00 0 7607 12 0 0
t$perf-norm:sp_pay_from_customer 7130 7130 0 0.00 0 7691 12 0 0
t$perf-norm:sp_pay_to_supplier 5861 5861 0 0.00 0 15100 16 0 0
t$perf-norm:sp_reserve_write_off 10023 10023 0 0.00 0 8557 11 0 0
t$perf-norm:sp_supplier_invoice 5611 5611 0 0.00 0 8996 17 0 0
t$perf-norm:sp_supplier_order 5552 5552 0 0.00 0 5762 15 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 249 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 144 144 0 0.00 0 647 7 0 0
t$perf-norm:srv_make_invnt_saldo 578 578 0 0.00 0 2055 21 0 0
t$perf-norm:srv_make_money_saldo 763 763 0 0.00 0 2008 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 10484 10250 234 2.23 0 5762 19 0 234
v_all_customers 37880 37880 0 0.00 0 70 1 0 0
v_all_suppliers 30682 30682 0 0.00 0 70 1 0 0
v_all_wares 42064 42064 0 0.00 0 42 1 0 0
v_cancel_adding_invoice 854 854 0 0.00 0 1894 7 0 0
v_cancel_client_order 3572 3572 0 0.00 0 4536 8 0 0
v_cancel_customer_prepayment 1378 1378 0 0.00 0 1283 4 0 0
v_cancel_customer_reserve 1512 1512 0 0.00 0 1195 4 0 0
v_cancel_payment_to_supplier 762 762 0 0.00 0 6598 16 0 0
v_cancel_supplier_invoice 790 772 18 2.27 0 5208 23 0 18
v_cancel_supplier_order 824 824 0 0.00 0 1771 6 0 0
v_cancel_write_off 1922 1922 0 0.00 0 4372 15 0 0
v_max_id_clo_ord 5547 5547 0 0.00 0 1083 1 0 0
v_max_id_clo_res 1058 1058 0 0.00 0 3011 10 0 0
v_max_id_ord_sup 5601 5601 0 0.00 0 7179 5 0 0
v_max_non_paid_invoice 1668 1668 0 0.00 0 4331 7 0 0
v_max_non_paid_realizn 3975 3975 0 0.00 0 1562 3 0 0
v_min_id_clo_ord 5547 5547 0 0.00 0 659 3 0 0
v_min_id_clo_res 1058 1058 0 0.00 0 7394 31 0 0
v_min_id_ord_sup 5601 5601 0 0.00 0 7420 7 0 0
v_min_non_paid_invoice 5861 5861 0 0.00 0 5888 15 0 0
v_min_non_paid_realizn 7130 7130 0 0.00 0 10240 18 0 0
v_our_firm 10494 10494 0 0.00 0 15 1 0 0
v_reserve_write_off 20046 20046 0 0.00 0 7331 7 0 0
x_lock_depdocs_on_canc_invoice 12141 12141 0 0.00 0 11941 110 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 7046 313 0 0
x_make_qstorno_1000_1200 5552 5552 0 0.00 2 40612 1081 0 0
x_make_qstorno_1200_2000 5611 5611 0 0.00 3 79053 2943 0 0
x_make_qstorno_2100_3300 470992 470992 0 0.00 0 92649 148 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-12-2020 01:29:32 to 21-12-2020 01:29:36.

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:11 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:17 4219 8192000000 10032867504 10306932736 834302176 9.243 69 55 116 1 856411632 2309136 19800320
22:57:29 31613 8192000000 10326071424 10639712256 1344607600 14.099 100 85 170 0 1376590944 3983952 27999392
22:58:10 30126 8192000000 10373444560 10698145792 1417332416 14.749 100 90 180 0 1452156144 5920944 28902784
22:58:49 23734 8192000000 10404787024 10733142016 1450914784 15.046 100 89 178 1 1486902096 7336624 28650688
22:59:21 18257 8192000000 10423118624 10754007040 1480703280 15.308 100 87 174 0 1516747040 8034944 28008816
22:59:50 22873 8192000000 10430130080 10763186176 1483339296 15.331 100 91 182 0 1521574656 8931136 29304224
23:00:25 21073 8192000000 10451824736 10788102144 1498537632 15.463 100 86 172 1 1535945456 9456960 27950864
23:01:00 13673 8192000000 10475318464 10815270912 1526477840 15.706 100 81 162 2 1561788736 9619520 25691376
23:01:22 15983 8192000000 10507438464 10853519360 1551308800 15.921 100 82 164 1 1586407600 9957584 25141216
23:01:47 13188 8192000000 10525127936 10879860736 1581964864 16.185 100 78 156 0 1617047616 10596016 24486736
23:02:08 13206 8192000000 10548969040 10903764992 1601059104 16.348 100 73 147 1 1633948928 10675264 22214560
23:02:31 10736 8192000000 10575772896 10937131008 1629563872 16.591 100 73 146 2 1663097952 11720560 21813520
23:02:49 7419 8192000000 10597775216 10960244736 1654789824 16.805 100 81 162 3 1690363936 11734880 23839232
23:03:08 11422 8192000000 10616878688 10986815488 1677550976 16.997 100 79 158 0 1713128048 12614368 22962704
23:03:27 8220 8192000000 10636058608 11005206528 1691617536 17.115 100 82 164 1 1727447568 12232896 23597136
23:03:45 6381 8192000000 10642926960 11014307840 1704680032 17.224 100 77 153 0 1739183904 12141792 22362080
23:03:58 5815 8192000000 10659632768 11036520448 1725788256 17.400 100 69 138 1 1757268384 11750240 19729888
23:04:11 6622 8192000000 10691261712 11064840192 1746721728 17.574 100 80 156 1 1781268928 12523120 22024080
23:04:26 4377 8192000000 10692722144 11073331200 1758207424 17.670 100 82 163 1 1794510528 13268624 23034480
23:04:37 4445 8192000000 10707707680 11090190336 1771358816 17.778 100 84 164 2 1811160768 16673360 23128592
23:04:48 4474 8192000000 10716748368 11095891968 1780577632 17.854 100 86 172 3 1818545712 13876896 24091184
23:04:59 3788 8192000000 10724529504 11108540416 1790103328 17.933 100 84 168 0 1827339344 14189808 23046208
23:05:09 2994 8192000000 10743673040 11121057792 1794404960 17.968 100 91 181 0 1833809664 14403376 25001328
23:05:19 3062 8192000000 10735848272 11124396032 1797895536 17.997 100 78 156 2 1833615888 13741456 21978896
23:05:28 2530 8192000000 10754054656 11135533056 1808017632 18.080 100 93 185 4 1848495584 14982304 25495648
23:05:38 2924 8192000000 10757508928 11140501504 1813571600 18.125 100 93 184 2 1854171040 15285600 25313840
23:05:47 4985 8192000000 10751842096 11141046272 1814968304 18.137 100 77 154 0 1850719344 15176688 20574352
23:05:59 2446 8192000000 10773017872 11157577728 1823078256 18.203 100 90 180 0 1861558864 13757472 24723136
23:06:08 2565 8192000000 10774414496 11162619904 1836552112 18.313 100 86 172 2 1873375392 13173248 23650032
23:06:16 1797 8192000000 10777037360 11167662080 1837923648 18.324 100 80 160 1 1873402320 12749392 22729280
23:06:25 1900 8192000000 10784520368 11174330368 1845871808 18.389 100 86 172 0 1882253008 11882560 24498640
23:06:33 1669 8192000000 10795588784 11182911488 1849720064 18.420 100 86 171 0 1886408128 12300912 24387152
23:06:41 2384 8192000000 10799594848 11186876416 1855999728 18.471 100 96 192 0 1897081792 13853584 27228480
23:06:50 1605 8192000000 10805680928 11195420672 1861564160 18.516 100 88 177 1 1898770000 11928144 25277696
23:06:58 1524 8192000000 10807789056 11198599168 1864012432 18.536 100 87 174 2 1900142560 12009104 24121024
23:07:06 19934 8192000000 10805573536 11199041536 1863560736 18.532 100 81 159 2 1896108080 10323264 22224080
23:07:32 8449 8192000000 10780474480 11195092992 1861984912 18.519 100 37 74 1 1880087312 7302640 10799760
23:07:47 5052 8192000000 10782465872 11200040960 1862788624 18.526 100 30 60 2 1878935728 7865200 8281904
23:08:00 4550 8192000000 10779003744 11202883584 1868231040 18.570 100 38 76 3 1885861024 6060736 11569248
23:08:11 6993 8192000000 10777967600 11208093696 1866076112 18.553 100 22 44 1 1883156656 11228976 5851568
23:08:25 6158 8192000000 10778897424 11206008832 1870185824 18.586 100 30 63 2 1888550480 10383344 7981312
23:08:38 8607 8192000000 10780625136 11206361088 1871401648 18.596 100 24 48 0 1884475712 6730304 6343760
23:08:57 6658 8192000000 10786408288 11209510912 1874201504 18.618 100 23 46 0 1887279184 6071040 7006640
23:09:10 4454 8192000000 10786693952 11213676544 1879939648 18.665 100 28 56 0 1894083216 6489696 7653872
23:09:21 8356 8192000000 10781240464 11218571264 1880143760 18.666 100 17 33 2 1891608768 6829696 4635312
23:09:37 12572 8192000000 10786777408 11221016576 1884664208 18.703 100 20 40 1 1895726272 5637728 5424336
23:10:00 8909 8192000000 10789598576 11220889600 1885218080 18.707 100 19 38 2 1895798912 5257888 5322944
23:10:15 15379 8192000000 10796992320 11226791936 1889521744 18.742 100 22 45 1 1900926912 5301744 6103424
23:10:39 65566 8192000000 10820176464 11250032640 1892934464 18.769 100 27 54 0 1906393216 5082928 8375824
23:11:52 14291 8192000000 10808040576 11246743552 1898903936 18.817 100 29 58 0 1913577968 5500128 9173904
23:12:16 5947 8192000000 10828953632 11260260352 1903523824 18.855 100 34 67 1 1923335776 10738064 9073888
23:12:29 4189 8192000000 10818791152 11254575104 1904014064 18.859 100 27 54 0 1918879536 7147984 7717488
23:12:41 2388 8192000000 10837205984 11262910464 1910167840 18.908 100 46 91 2 1930434080 7584416 12681824
23:12:51 3690 8192000000 10822882448 11263561728 1908114000 18.892 100 29 58 1 1923234016 6965408 8154608
23:13:01 8780 8192000000 10836229552 11265245184 1912083280 18.923 100 29 58 1 1926090096 4992416 9014400
23:13:17 7164 8192000000 10837199536 11266555904 1912647216 18.928 100 30 60 1 1927322144 5964736 8710192
23:13:31 5276 8192000000 10832842192 11267366912 1911901408 18.922 100 25 49 0 1925437728 6218336 7317984
23:13:43 7916 8192000000 10836084624 11271745536 1912311136 18.925 100 21 42 0 1924374128 6108912 5954080
23:13:59 7421 8192000000 10836825200 11271704576 1912472016 18.926 100 22 44 0 1924575232 6078896 6024320
23:14:14 13219 8192000000 10833202400 11275235328 1914398704 18.942 100 16 31 1 1929061968 10446112 4217152
23:14:35 7554 8192000000 10826170176 11269300224 1902080144 18.843 99 22 42 0 1918657600 10283328 6294128
23:14:54 11554 8192000000 10814704704 11254849536 1888536496 18.734 99 22 44 5 1901804976 7392832 5875648
23:15:14 24154 8192000000 10785591936 11221225472 1798096016 17.998 94 20 41 4 1809255072 5244608 5914448
23:16:10 29918 8192000000 10789844928 11218280448 1813092352 18.121 96 30 61 2 1832303680 11092624 8118704
23:16:47 13906 8192000000 10795952192 11217776640 1843512672 18.369 98 24 46 0 1855911696 6140416 6258608
23:17:07 7727 8192000000 10762182608 11186577408 1789687312 17.929 96 25 50 1 1807166608 10895472 6583824
23:17:26 7119 8192000000 10712579456 11132907520 1730132000 17.437 94 33 66 1 1745833456 5989152 9712304
23:17:40 7595 8192000000 10713156080 11124965376 1752799648 17.625 96 22 45 0 1765385520 5714544 6871328
23:17:54 7170 8192000000 10723555952 11143761920 1763992528 17.717 97 24 48 1 1777815664 6993408 6829728
23:18:08 9736 8192000000 10725448080 11151872000 1784322528 17.885 98 24 48 2 1797024304 5070336 7631440
23:18:26 6917 8192000000 10726364208 11149312000 1814769120 18.135 100 25 50 3 1828784464 6582752 7432592
23:18:40 6377 8192000000 10726462816 11142336512 1774977040 17.808 98 18 36 0 1785126480 4898704 5250736
23:18:54 9318 8192000000 10725588832 11142590464 1745668464 17.566 96 18 36 2 1756053344 5325872 5059008
23:19:09 11060 8192000000 10713277552 11125764096 1745014528 17.560 97 20 40 1 1756842624 5944928 5883168
23:19:26 11033 8192000000 10724684048 11128631296 1745853696 17.567 97 20 38 0 1760644800 9392080 5399024
23:19:44 10119 8192000000 10702910256 11121684480 1731209456 17.446 96 17 34 0 1742194752 5872464 5112832
23:20:01 9485 8192000000 10692295920 11109244928 1751639104 17.615 98 13 26 0 1760565168 5173168 3752896
23:20:19 65298 8192000000 10730588336 11137458176 1757917664 17.667 97 29 55 1 1771296192 4782528 8596000
23:21:30 27691 8192000000 10733557712 11145555968 1763497184 17.713 97 32 63 2 1777820352 5863776 8459392
23:22:09 5559 8192000000 10736812528 11162529792 1812081296 18.113 99 28 56 3 1826437104 5959312 8396496
23:22:22 6001 8192000000 10755877824 11177123840 1837290448 18.319 100 26 52 0 1851341872 6641568 7409856
23:22:37 5433 8192000000 10754414752 11178995712 1842016608 18.357 100 32 64 0 1857390544 6088880 9285056
23:22:49 9189 8192000000 10768146112 11190996992 1845929632 18.389 100 30 58 1 1861290672 6271552 9089488
23:23:06 11511 8192000000 10776788624 11197640704 1851799280 18.437 100 27 53 2 1864926896 5452784 7674832
23:23:26 5032 8192000000 10770178032 11195953152 1854190144 18.456 100 31 60 1 1869306400 6258160 8858096
23:23:38 10651 8192000000 10764304640 11195314176 1853237712 18.448 100 18 34 1 1863733232 5521168 4974352
23:23:56 7970 8192000000 10771296672 11204157440 1858722432 18.493 100 21 42 3 1878240272 13750736 5767104
23:24:10 10237 8192000000 10770119680 11203125248 1863474800 18.531 100 18 36 1 1874417296 5112720 5829776
23:24:26 6322 8192000000 10783890816 11210108928 1865638128 18.549 100 25 50 2 1879421776 5677616 8106032
23:24:38 10609 8192000000 10774650256 11208556544 1867160320 18.561 100 23 46 0 1879299776 5324384 6815072
23:24:55 17373 8192000000 10775861008 11208945664 1865403856 18.547 100 14 27 1 1873730960 4862128 3464976
23:25:21 61602 8192000000 10787140800 11220115456 1872406080 18.604 100 34 68 4 1888937696 5758256 10773360
23:26:39 11152 8192000000 10789983328 11220983808 1871431488 18.596 100 22 44 0 1883912160 5848800 6631872
23:26:56 9115 8192000000 10800290720 11226370048 1879528960 18.661 100 26 52 1 1892578096 5800512 7248624
23:27:11 12647 8192000000 10829007264 11247501312 1896954464 18.802 100 46 88 3 1916140752 6683296 12502992
23:27:47 20546 8192000000 10856069136 11269758976 1918153824 18.972 100 60 120 0 1945112912 10343952 16615136
23:28:19 9254 8192000000 10861489936 11280502784 1925053696 19.027 100 61 118 1 1954333008 12609744 16669568
23:28:36 14149 8192000000 10868058416 11283152896 1929755936 19.065 100 61 122 2 1958982512 12570864 16655712
23:29:00 14316 8192000000 10883526272 11302465536 1939351872 19.142 100 53 105 3 1968329632 14376368 14601392
23:29:36 32683 8192000000 10881045968 11311071232 1944461536 19.182 100 37 74 1 1969240608 13793328 10985744
23:30:19 10275 8192000000 10889818352 11317198848 1951042784 19.235 100 41 81 1 1977818960 14872128 11904048
23:30:40 8546 8192000000 10896424032 11324055552 1955591600 19.271 100 49 99 2 1984663152 14407936 14663616
23:31:03 29511 8192000000 10895069328 11336282112 1964975952 19.346 100 43 86 2 1994787488 17167696 12643840
23:32:19 20496 8192000000 10903701008 11342053376 1964794384 19.344 100 29 58 0 1992682304 18602192 9285728
23:32:49 11063 8192000000 10918578304 11346100224 1954016896 19.258 99 48 96 1 1985594544 17322848 14254800
23:33:08 14602 8192000000 10921342208 11348578304 1970596720 19.390 100 63 124 5 2008501664 19275248 18629696
23:33:41 13881 8192000000 10914606688 11348234240 1957225200 19.284 99 50 96 0 1989509024 18134416 14149408
23:34:04 4336 8192000000 10932993008 11357855744 1980785792 19.471 100 67 134 3 2019768848 18867808 20115248
23:34:15 2714 8192000000 10921590144 11335532544 1945491056 19.191 99 75 150 2 1987178448 20250656 21436736
23:34:26 7701 8192000000 10905655424 11326164992 1919359440 18.982 98 67 130 0 1958795392 20707728 18728224
23:34:42 2948 8192000000 10922480640 11335827456 1963563632 19.334 100 80 159 0 2009359216 22478704 23316880
23:34:51 2896 8192000000 10920279216 11340603392 1963871040 19.337 100 65 130 0 2004198944 21750560 18577344
23:35:02 10536 8192000000 10922759504 11340525568 1968555056 19.374 100 68 136 1 2010233536 21868752 19809728
23:35:19 2522 8192000000 10935998256 11351105536 1969461728 19.381 100 86 169 1 2020582960 26619184 24502048
23:35:28 3733 8192000000 10933614480 11354243072 1971038000 19.394 100 72 142 1 2018404080 26891760 20474320
23:35:41 6067 8192000000 10932972192 11360694272 1979605200 19.462 100 69 137 4 2025003312 26691056 18707056
23:35:53 3542 8192000000 10950304208 11367948288 1985624224 19.509 100 72 142 1 2033210928 27407360 20179344
23:36:03 9344 8192000000 10953818992 11380264960 1994926240 19.583 100 65 130 1 2042056800 27744288 19386272
23:36:25 7248 8192000000 10956386672 11380568064 1981639312 19.478 99 71 143 1 2030726096 28200752 20886032
23:36:41 2328 8192000000 10947493296 11372384256 1990925520 19.551 100 73 145 0 2041072608 29103056 21044032
23:36:51 2320 8192000000 10953133760 11372589056 1985515072 19.508 100 88 176 2 2042269744 30454496 26300176
23:37:01 7275 8192000000 10949472112 11378671616 1989379776 19.539 100 62 124 0 2037408240 29529280 18499184
23:37:16 3354 8192000000 10970776816 11393470464 2000961264 19.630 100 72 140 0 2054059872 32408144 20690464
23:37:26 2169 8192000000 10959856880 11376082944 1976318656 19.436 99 68 134 1 2028342208 32167584 19855968
23:37:35 4413 8192000000 10934731840 11356082176 1963016912 19.330 100 74 146 1 2018616224 33012976 22586336
23:37:50 5466 8192000000 10920996384 11347443712 1957118240 19.283 100 60 120 2 2010548352 33966160 19463952
23:38:04 3448 8192000000 10936747376 11356205056 1949651424 19.224 99 78 154 0 2009684256 35534736 24498096
23:38:14 6562 8192000000 10933311344 11344465920 1942279232 19.165 99 87 174 2 2004688928 35535936 26873760
23:38:29 5418 8192000000 10903354400 11317301248 1915640464 18.952 98 61 121 2 1966914240 32925872 18347904
23:38:41 1533 8192000000 10920163536 11335835648 1947350640 19.205 100 78 154 3 2003223568 33096800 22776128
23:38:50 5107 8192000000 10912432608 11327045632 1932036944 19.083 99 71 142 2 1987834976 33721168 22076864
23:39:06 2988 8192000000 10925760400 11334696960 1940496912 19.151 99 83 166 2 2001448976 35645520 25306544
23:39:18 3561 8192000000 10917828048 11327778816 1937854160 19.130 99 77 155 3 1997441408 36313920 23273328
23:39:29 2533 8192000000 10938981328 11353767936 1956981824 19.282 100 78 156 1 2017903776 37400048 23521904
23:39:39 2573 8192000000 10928987680 11339837440 1947178432 19.204 100 84 168 1 2011972784 38941120 25853232
23:39:49 4634 8192000000 10918608192 11329421312 1946572384 19.199 100 79 158 1 2009866912 39620048 23674480
23:40:06 1520 8192000000 10928408208 11336953856 1945670752 19.192 100 83 165 1 2011070544 40365712 25034080
23:40:14 7297 8192000000 10936650592 11350233088 1954332048 19.261 100 71 143 2 2015898048 39772624 21793376
23:40:35 1538 8192000000 10926478128 11332308992 1936180208 19.116 100 83 163 1 2001158832 39795952 25182672
23:40:43 2650 8192000000 10913785040 11323600896 1933460656 19.095 100 81 161 2 1993079968 34269952 25349360
23:40:53 2529 8192000000 10916596464 11330445312 1941634960 19.160 100 68 134 3 1998320880 35715984 20969936
23:41:02 3501 8192000000 10919949376 11328253952 1937732192 19.129 100 79 157 3 2000626288 37495264 25398832
23:41:13 6628 8192000000 10931535504 11345539072 1953269104 19.253 100 75 150 1 2012806592 35619488 23918000
23:41:28 6103 8192000000 10922449456 11339075584 1934809232 19.105 99 80 160 0 1998686752 39091904 24785616
23:41:42 4861 8192000000 10935589824 11346386944 1934853952 19.106 99 81 158 0 2002277856 42668976 24754928
23:42:05 1795 8192000000 10936839616 11348811776 1952774544 19.249 100 84 168 4 2022380528 42222896 27383088
23:42:14 2269 8192000000 10945290288 11363917824 1962450528 19.326 100 84 168 0 2033172784 43684688 27037568
23:42:23 3731 8192000000 10950991392 11363516416 1965604624 19.351 100 77 154 2 2031756256 41829712 24321920
23:42:33 8371 8192000000 10920763376 11346935808 1934288880 19.101 99 53 104 1 1991542688 40634528 16619280
23:42:49 10180 8192000000 10917838592 11345395712 1943654192 19.176 100 46 91 0 1998990992 40197040 15139760
23:43:05 1542 8192000000 10946236480 11362988032 1966008816 19.354 100 78 156 1 2034321424 41428512 26884096
23:43:13 2912 8192000000 10955857104 11377987584 1969495936 19.381 100 72 144 0 2037911440 45812304 22603200
23:43:25 4172 8192000000 10943712720 11369119744 1958461072 19.294 100 61 121 1 2025508240 48121456 18925712
23:43:42 7314 8192000000 10900024080 11339096064 1889696912 18.743 97 32 62 2 1938654864 37623808 11334144
23:43:58 18378 8192000000 10901521168 11344830464 1944232304 19.181 100 35 70 0 1989971440 34844848 10894288
23:44:31 10153 8192000000 10927866448 11364802560 1960979072 19.314 100 41 80 0 2009208208 35176848 13052288
23:44:55 9969 8192000000 10910519456 11349196800 1945812144 19.193 100 38 76 0 1995791712 37448816 12530752
23:45:34 16942 8192000000 10890201936 11329146880 1908993792 18.899 99 28 56 0 1961386224 42643568 9748864
23:46:02 13881 8192000000 10892558192 11335860224 1912237072 18.925 99 28 56 0 1967098272 45163232 9697968
23:46:23 20500 8192000000 10888394624 11333521408 1907202144 18.884 99 27 54 2 1956099248 39578480 9318624
23:46:50 26418 8192000000 10898306192 11345612800 1939633632 19.144 100 25 50 0 1984648416 36707728 8307056
23:47:23 22117 8192000000 10891524944 11341217792 1920490976 18.991 99 17 34 2 1961111840 34759264 5861600
23:48:11 21300 8192000000 10884910384 11324329984 1898507648 18.814 99 23 46 1 1953932464 47511728 7913088
23:49:07 68622 8192000000 10850734752 11323932672 1872903520 18.608 98 12 24 0 1916677776 39993040 3781216
23:50:22 59521 8192000000 10859492352 11301015552 1897572016 18.807 99 30 60 0 1917124832 10836752 8716064
23:51:27 142025 8192000000 10853637136 11314036736 1909250528 18.901 99 20 40 0 1926367776 11544944 5572304
23:53:56 64329 8192000000 10853327312 11309051904 1877457648 18.645 97 34 66 2 1893629136 7102368 9069120
23:55:12 62845 8192000000 10855744784 11313336320 1915380032 18.950 99 26 52 2 1930202352 7778192 7044128
23:56:22 37334 8192000000 10852720384 11313524736 1930746832 19.073 100 17 33 3 1942694176 7414976 4532368
23:57:12 69265 8192000000 10864949024 11322724352 1914800528 18.945 98 13 26 1 1927067344 8668896 3597920
23:58:28 57560 8192000000 10859268016 11317911552 1916538656 18.959 98 11 22 0 1930173536 10737680 2897200
23:59:32 26656 8192000000 10883590640 11331940352 1950447344 19.230 100 21 42 0 1968770064 11782240 6540480
00:00:04 50219 8192000000 10891418656 11357708288 1967023408 19.362 100 26 53 0 1983010896 7995392 7992096
00:01:32 54797 8192000000 10891484800 11364220928 1975374400 19.428 100 23 46 0 1994462656 13028000 6060256
00:02:42 46536 8192000000 10893199024 11369480192 1970083248 19.386 100 8 16 1 1986099184 13646768 2369168
00:03:35 47695 8192000000 10894602624 11372957696 1953952816 19.258 99 7 14 0 1966640112 10666752 2020544
00:04:30 47863 8192000000 10915505552 11383390208 1986822640 19.519 100 14 27 1 2001870512 11523712 3524160
00:05:40 30257 8192000000 10928316064 11387084800 1977700880 19.446 99 29 58 0 1998813792 12247312 8865600
00:06:16 46257 8192000000 10909686992 11387269120 1965834640 19.352 99 7 15 0 1979124368 10880448 2409280
00:07:09 32221 8192000000 10941459216 11387514880 1981465920 19.476 99 40 80 0 2001216704 8193584 11557200
00:07:50 32129 8192000000 10937799520 11405979648 2001215072 19.632 100 32 64 2 2020930768 10638656 9077040
00:08:36 76725 8192000000 10943609504 11398766592 1941387696 19.158 97 23 46 1 1961237984 13205360 6644928
00:10:00 99841 8192000000 10941543824 11428966400 1981318736 19.475 99 18 36 1 2018179376 31567136 5293504
00:12:47 186740 8192000000 10901778496 11357057024 1814736048 18.135 91 5 10 0 1834540048 18609216 1194784
00:16:00 115245 8192000000 10912947776 11386064896 1991685376 19.557 100 34 68 2 2011505120 9373440 10446304
00:18:35 26696 8192000000 10927532784 11377508352 1985810960 19.511 100 25 50 0 2000019920 6757872 7451088
00:19:10 34241 8192000000 10888030144 11359633408 1946622000 19.200 98 15 30 0 1956637136 5362992 4652144
00:19:50 63275 8192000000 10887754960 11363348480 1920432304 18.990 97 9 18 0 1929307920 6309232 2566384
00:21:30 79447 8192000000 10889028768 11361312768 1887456720 18.725 95 14 27 1 1905442944 14117840 3868384
00:22:57 73102 8192000000 10875295824 11345489920 1911170992 18.916 97 16 33 0 1934261776 18329760 4761024
00:24:40 38346 8192000000 10890139296 11361431552 1958965680 19.298 100 26 52 2 1983105632 16059408 8080544
00:25:25 62012 8192000000 10889335552 11376230400 1950442656 19.230 99 20 40 0 1969753824 13473200 5837968
00:26:48 82616 8192000000 10890096320 11360927744 1889832992 18.744 95 17 34 1 1904690560 10395456 4462112
00:28:25 46788 8192000000 10889650368 11354316800 1912631984 18.928 97 22 44 1 1931878992 12964752 6282256
00:29:19 48086 8192000000 10893089824 11362119680 1921055904 18.995 97 27 54 1 1941244608 12665648 7523056
00:30:52 94917 8192000000 10903126304 11383480320 1932123744 19.084 98 11 22 0 1953022288 18302464 2596080
00:32:37 70546 8192000000 10918532608 11389493248 1950514704 19.231 98 15 30 0 1967576224 12855440 4206080
00:33:55 29670 8192000000 10918521936 11381096448 1966044432 19.354 99 28 56 1 1989042400 13921792 9076176
00:34:31 33189 8192000000 10873328224 11338211328 1872098928 18.601 95 21 42 1 1892110896 13614048 6397920
00:35:18 77772 8192000000 10890302464 11352014848 1862830448 18.526 95 24 48 0 1887894032 17725504 7338080
00:36:43 42975 8192000000 10910226160 11368349696 1938825584 19.137 99 29 58 2 1962211200 15133136 8252480
00:38:03 141156 8192000000 10867691600 11341119488 1830142880 18.260 93 4 8 0 1842882400 11988464 751056
00:40:32 53856 8192000000 10866739632 11324022784 1912971856 18.930 98 40 80 1 1932338592 7335936 12030800
00:41:32 63549 8192000000 10856758960 11315335168 1865888752 18.551 96 15 30 1 1878504816 8300608 4315456
00:42:42 21073 8192000000 10860610176 11325456384 1932595376 19.088 100 14 28 0 1944035776 7451232 3989168
00:43:10 18250 8192000000 10848170992 11322253312 1931334304 19.078 100 6 12 0 1943183456 10150256 1698896
00:43:39 97846 8192000000 10851441552 11327754240 1921130816 18.996 99 10 20 0 1933317328 9607728 2578784
00:45:29 65154 8192000000 10865280832 11335938048 1927943136 19.050 99 7 14 0 1942948624 13322448 1683040
00:46:41 60770 8192000000 10873366672 11346452480 1933536432 19.095 99 17 34 0 1953261440 14864640 4860368
00:47:47 41761 8192000000 10865318048 11331473408 1909812432 18.905 98 19 40 2 1927981712 12213920 5955360
00:48:45 49903 8192000000 10885810400 11351416832 1941090720 19.155 100 11 22 0 1957174656 12956640 3127296
00:49:57 39054 8192000000 10910037200 11357560832 1944957376 19.186 99 18 35 0 1960461376 10792016 4711984
00:50:44 22414 8192000000 10908903456 11356622848 1970367072 19.388 100 50 100 1 1992543504 8158832 14017600
00:51:13 48423 8192000000 10889145360 11353964544 1925899344 19.034 98 31 62 1 1944964944 10202896 8862704
00:52:22 100453 8192000000 10895313728 11374850048 1941548176 19.159 99 13 26 0 1960421536 15134448 3738912
00:54:09 93202 8192000000 10897214752 11380858880 1944605392 19.183 99 8 16 0 1969758080 22942896 2209792
00:55:49 99085 8192000000 10896162560 11348701184 1896149360 18.795 96 23 46 0 1910562672 7761888 6651424
00:57:41 30358 8192000000 10910024736 11360616448 1970599984 19.390 100 45 89 0 1993421552 11042112 11779456
00:58:28 58635 8192000000 10912879600 11381964800 1957736016 19.288 99 23 47 0 1976551200 12528000 6287184
01:00:02 103866 8192000000 10901734672 11360985088 1925987584 19.035 97 22 42 0 1939372912 7607360 5777968
01:01:57 74670 8192000000 10898205008 11374075904 1977943008 19.448 100 36 72 1 1998525792 10391072 10191712
01:04:52 95742 8192000000 10911044864 11388751872 1967424384 19.365 99 13 26 0 1982657024 11436192 3796448
01:07:10 44588 8192000000 10943305952 11404304384 2003325632 19.649 100 42 83 1 2030828096 15054336 12448128
01:08:05 94793 8192000000 10898515584 11387482112 1927716800 19.049 97 12 24 0 1953184880 21896480 3571600
01:09:45 74384 8192000000 10883932192 11359338496 1883507840 18.693 95 7 14 0 1894493184 9112464 1872880
01:11:09 46540 8192000000 10895497312 11358220288 1923153520 19.012 98 18 36 0 1936722384 8757664 4811200
01:12:07 34220 8192000000 10937695488 11380477952 1978015904 19.449 100 42 84 3 2006028336 15727664 12284768
01:13:01 39748 8192000000 10901890112 11374297088 1951914544 19.242 99 22 44 3 1975439792 17426336 6098912
01:13:48 138977 8192000000 10886854464 11352842240 1789847232 17.931 91 10 20 0 1806882192 14195584 2839376
01:16:33 119501 8192000000 10894135184 11361583104 1876966064 18.641 96 10 20 0 1895459744 15958016 2535664
01:18:42 100577 8192000000 10873489376 11343843328 1936929248 19.122 99 19 38 2 1952420352 10131296 5359808
01:20:32 36804 8192000000 10841642848 11289616384 1867370624 18.563 96 37 74 1 1888830112 11029888 10429600
01:21:15 40223 8192000000 10857902000 11322748928 1915367776 18.950 99 38 76 2 1938488160 12733856 10386528
01:22:09 75020 8192000000 10823476704 11307270144 1868318960 18.571 97 8 16 0 1881803024 11282672 2201392
01:23:30 28348 8192000000 10842879632 11314184192 1919801168 18.985 100 9 18 2 1931305280 8836432 2667680
01:24:05 68984 8192000000 10846779760 11311378432 1872385104 18.604 97 12 24 1 1884353680 8353248 3615328
01:25:30 43409 8192000000 10834891344 11308404736 1913982928 18.939 99 16 32 0 1927898976 9199728 4716320
01:26:49 25601 8192000000 10090635456 10484252672 1215172080 12.917 63 8 16 0 1228614768 11018800 2423888

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 21-12-2020 01:29:38 to 21-12-2020 01:30:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 117 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-12-2020 01:30:08 to 21-12-2020 01:30:10.

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          244837
MON$OLDEST_ACTIVE               245229
MON$OLDEST_SNAPSHOT             245229
MON$NEXT_TRANSACTION            245229
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                       2035296
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:165: 
:166: mscs-test-161.budzdorov.ru    Mon Dec 21 01:27:28 2020
:167:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:168: 
:169: 
:170: mscs-test-161.budzdorov.ru    Mon Dec 21 01:27:28 2020
:171:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:172: 
:173: 
:174: mscs-test-161.budzdorov.ru    Mon Dec 21 01:27:28 2020
:175:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:176: 
:177: 
:178: mscs-test-161.budzdorov.ru    Mon Dec 21 01:27:28 2020
:179:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:180: 
--- end of diff output ---

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

21.12.20 01:30:11. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2020-12-21 01:30:13 No severe PSQL-related problems occured
21.12.20 01:30:15. End of report.