Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.02.2021 19: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 17311884 kB
MemAvailable 31211284 kB
Buffers 0 kB
Cached 14358736 kB
SwapCached 4876 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-01 19:27:16
DTS_END                         2021-02-01 19:27:16.3030
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/45600
TRN_ID                          243304
ATT_ID                          717
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: 9428.22 19812 1131386
customer order: creation 186.05 356 22326
customer order: refuse 15.70 322 1884
order to supplier: creation 49.02 1188 5882
order to supplier: removal 3.55 93303 426
invoice (draft): creation 48.45 3048 5814
invoice (draft): removal 52.73 754 6327
invoice accept: apply 43.30 17104 5196
invoice accept: cancel 46.94 767 5633
customer reserve: creation 4066.78 168 488014
customer reserve: removal 4601.00 56 552120
realization accept: apply 88.16 155 10579
realization accept: cancel 89.31 107 10717
payment from customer: creation 63.30 97 7596
payment from customer: removal 5.80 60 696
payment to supplier: creation 52.11 118 6253
payment to supplier: removal 3.67 67 440
service: total inventory turnovers 5.06 1103 607
service: total monetary turnovers 6.35 26 762
service: aggregate perf. data 0.92 18767 110
service: refresh index statistics 0.03 258681 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-02-2021 19:28:08 to 01-02-2021 19:28:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3696
TEST_TIME 2 5364
TEST_TIME 3 4801
TEST_TIME 4 5346
TEST_TIME 5 5126
TEST_TIME 6 5039
TEST_TIME 7 5169
TEST_TIME 8 5483
TEST_TIME 9 5541
TEST_TIME 10 5738
TEST_TIME 11 5777
TEST_TIME 12 5822
TEST_TIME 13 5894
TEST_TIME 14 5944
TEST_TIME 15 6035
TEST_TIME 16 6765
TEST_TIME 17 7108
TEST_TIME 18 7597
TEST_TIME 19 7983
TEST_TIME 20 8694
TEST_TIME 21 9145
TEST_TIME 22 9406
TEST_TIME 23 9304
TEST_TIME 24 9587
TEST_TIME 25 10793
TEST_TIME 26 10744
TEST_TIME 27 10542
TEST_TIME 28 10527
TEST_TIME 29 10403
TEST_TIME 30 10161
TEST_TIME 31 10172
TEST_TIME 32 10122
TEST_TIME 33 10025
TEST_TIME 34 9918
TEST_TIME 35 9889
TEST_TIME 36 9761
TEST_TIME 37 9949
TEST_TIME 38 9864
TEST_TIME 39 9854
TEST_TIME 40 9868
TEST_TIME 41 9916
TEST_TIME 42 9880
TEST_TIME 43 9886
TEST_TIME 44 9831
TEST_TIME 45 9746
TEST_TIME 46 9779
TEST_TIME 47 9882
TEST_TIME 48 9871
TEST_TIME 49 9813
TEST_TIME 50 9933
TEST_TIME 51 9892
TEST_TIME 52 9929
TEST_TIME 53 9861
TEST_TIME 54 10052
TEST_TIME 55 9982
TEST_TIME 56 9824
TEST_TIME 57 9800
TEST_TIME 58 9758
TEST_TIME 59 9731
TEST_TIME 60 9689
TEST_TIME 61 9728
TEST_TIME 62 9659
TEST_TIME 63 9556
TEST_TIME 64 9513
TEST_TIME 65 9555
TEST_TIME 66 9577
TEST_TIME 67 9629
TEST_TIME 68 9580
TEST_TIME 69 9574
TEST_TIME 70 9587
TEST_TIME 71 9613
TEST_TIME 72 9667
TEST_TIME 73 9682
TEST_TIME 74 9663
TEST_TIME 75 9664
TEST_TIME 76 9751
TEST_TIME 77 9703
TEST_TIME 78 9827
TEST_TIME 79 9726
TEST_TIME 80 9629
TEST_TIME 81 9568
TEST_TIME 82 9537
TEST_TIME 83 9509
TEST_TIME 84 9447
TEST_TIME 85 9449
TEST_TIME 86 9457
TEST_TIME 87 9388
TEST_TIME 88 9409
TEST_TIME 89 9392
TEST_TIME 90 9413
TEST_TIME 91 9403
TEST_TIME 92 9417
TEST_TIME 93 9445
TEST_TIME 94 9426
TEST_TIME 95 9445
TEST_TIME 96 9463
TEST_TIME 97 9594
TEST_TIME 98 9577
TEST_TIME 99 9634
TEST_TIME 100 9705
TEST_TIME 101 9684
TEST_TIME 102 9666
TEST_TIME 103 9601
TEST_TIME 104 9566
TEST_TIME 105 9522
TEST_TIME 106 9513
TEST_TIME 107 9467
TEST_TIME 108 9458
TEST_TIME 109 9437
TEST_TIME 110 9411
TEST_TIME 111 9413
TEST_TIME 112 9421
TEST_TIME 113 9402
TEST_TIME 114 9431
TEST_TIME 115 9435
TEST_TIME 116 9419
TEST_TIME 117 9407
TEST_TIME 118 9437
TEST_TIME 119 9465
TEST_TIME 120 9436

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-02-2021 19:28:12 to 01-02-2021 19:28:15.

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 1582319 1582319 0 0.00 0 23786 7 0 0
doc_list_biud 1582318 1582318 0 0.00 0 31779 25 0 0
sp_add_invoice_to_stock 5307 5196 111 2.09 27 138839 17105 0 111
sp_cancel_adding_invoice 5633 5633 0 0.00 5 64361 768 0 0
sp_cancel_client_order 1884 1884 0 0.00 4 23180 323 0 0
sp_cancel_customer_reserve 552120 552120 0 0.00 1 31781 57 0 0
sp_cancel_pay_from_customer 696 696 0 0.00 3 3436 61 0 0
sp_cancel_pay_to_supplier 440 440 0 0.00 3 6425 67 0 0
sp_cancel_supplier_invoice 6335 6327 8 0.12 1 22109 755 0 8
sp_cancel_supplier_order 426 426 0 0.00 6 1045717 93303 0 0
sp_cancel_write_off 10717 10717 0 0.00 1 6775 107 0 0
sp_client_order 22326 22326 0 0.00 3 29808 357 0 0
sp_customer_reserve 488014 488014 0 0.00 0 76129 168 0 0
sp_fill_shopping_cart 34018 34018 0 0.00 1 15852 38 0 0
sp_fill_shopping_cart_clo_res 488008 488008 0 0.00 0 17662 13 0 0
sp_get_clo_for_invoice 5184 5184 0 0.00 0 25508 265 0 0
sp_kill_cost_storno 17486 17486 0 0.00 0 5727 48 0 0
sp_kill_qstorno_ret_qs2qd 1121710 1121710 0 0.00 0 31776 31 0 0
sp_kill_qty_storno 592868 592868 0 0.00 0 31779 67 0 0
sp_lock_selected_doc 21808 21808 0 0.00 0 9815 5 0 0
sp_make_cost_storno 29610 29610 0 0.00 0 20088 42 0 0
sp_multiply_rows_for_pdistr 29610 29610 0 0.00 0 13790 26 0 0
sp_multiply_rows_for_qdistr 22326 22326 0 0.00 0 29800 175 0 0
sp_pay_from_customer 7596 7596 0 0.00 4 22504 97 0 0
sp_pay_to_supplier 6253 6253 0 0.00 4 20115 118 0 0
sp_payment_common 13849 13849 0 0.00 1 22493 27 0 0
sp_qd_handle_on_cancel_clo 1884 1884 0 0.00 0 23172 296 0 0
sp_qd_handle_on_invoice_upd_sts 10815 10815 0 0.00 0 16942 295 0 0
sp_qd_handle_on_reserve_upd_sts 10579 10579 0 0.00 0 22955 55 0 0
sp_reserve_write_off 10579 10579 0 0.00 6 22964 156 0 0
sp_supplier_invoice 5814 5814 0 0.00 6 81656 3049 0 0
sp_supplier_order 5882 5882 0 0.00 4 32417 1189 0 0
srv_aggregate_perf_data 110 110 0 0.00 2783 170747 18768 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 796 125939 33746 0 0
srv_find_qd_qs_mism 1080105 1080105 0 0.00 0 23786 7 0 0
srv_make_invnt_saldo 607 607 0 0.00 41 99533 1104 0 0
srv_make_money_saldo 762 762 0 0.00 1 2688 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 118235 364625 258681 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5196 5196 0 0.00 0 13511 142 0 0
t$perf-norm:sp_cancel_adding_invoice 378 378 0 0.00 0 4345 123 0 0
t$perf-norm:sp_cancel_client_order 1884 1884 0 0.00 0 4040 15 0 0
t$perf-norm:sp_cancel_customer_reserve 740 740 0 0.00 0 9389 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 696 696 0 0.00 0 2862 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 440 440 0 0.00 0 689 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 447 447 0 0.00 0 3306 19 0 0
t$perf-norm:sp_cancel_supplier_order 426 426 0 0.00 0 24665 1486 0 0
t$perf-norm:sp_cancel_write_off 1036 1036 0 0.00 0 532 3 0 0
t$perf-norm:sp_client_order 22326 22326 0 0.00 0 8349 16 0 0
t$perf-norm:sp_customer_reserve 1040 1040 0 0.00 0 977 5 0 0
t$perf-norm:sp_pay_from_customer 7596 7596 0 0.00 0 11361 10 0 0
t$perf-norm:sp_pay_to_supplier 6253 6253 0 0.00 0 6938 11 0 0
t$perf-norm:sp_reserve_write_off 10579 10579 0 0.00 0 15646 12 0 0
t$perf-norm:sp_supplier_invoice 5814 5814 0 0.00 0 10719 17 0 0
t$perf-norm:sp_supplier_order 5882 5882 0 0.00 0 9225 16 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 372 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 313 3 0 0
t$perf-norm:srv_make_invnt_saldo 607 607 0 0.00 0 3442 18 0 0
t$perf-norm:srv_make_money_saldo 762 762 0 0.00 0 1094 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 5 0 0
v_add_invoice_to_stock 10586 10364 222 2.09 0 6584 20 0 222
v_all_customers 40960 40960 0 0.00 0 133 0 0 0
v_all_suppliers 32574 32574 0 0.00 0 91 1 0 0
v_all_wares 44652 44652 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 756 756 0 0.00 0 9421 21 0 0
v_cancel_client_order 3768 3768 0 0.00 0 3376 6 0 0
v_cancel_customer_prepayment 1392 1392 0 0.00 0 3337 9 0 0
v_cancel_customer_reserve 1480 1480 0 0.00 0 650 3 0 0
v_cancel_payment_to_supplier 880 880 0 0.00 0 6385 10 0 0
v_cancel_supplier_invoice 910 894 16 1.75 0 2109 21 0 16
v_cancel_supplier_order 852 852 0 0.00 0 2335 8 0 0
v_cancel_write_off 2072 2072 0 0.00 0 2203 13 0 0
v_max_id_clo_ord 5882 5882 0 0.00 0 311 1 0 0
v_max_id_clo_res 1040 1040 0 0.00 0 2259 12 0 0
v_max_id_ord_sup 5809 5809 0 0.00 0 8763 5 0 0
v_max_non_paid_invoice 1657 1657 0 0.00 0 1068 3 0 0
v_max_non_paid_realizn 3826 3826 0 0.00 0 2435 5 0 0
v_min_id_clo_ord 5882 5882 0 0.00 0 13507 7 0 0
v_min_id_clo_res 1040 1040 0 0.00 0 2885 8 0 0
v_min_id_ord_sup 5809 5809 0 0.00 0 5917 8 0 0
v_min_non_paid_invoice 6253 6253 0 0.00 0 7211 14 0 0
v_min_non_paid_realizn 7595 7595 0 0.00 0 11591 16 0 0
v_our_firm 11230 11230 0 0.00 0 12 1 0 0
v_reserve_write_off 21158 21158 0 0.00 0 2769 5 0 0
x_lock_depdocs_on_canc_invoice 11513 11513 0 0.00 0 22081 112 0 0
x_lock_depdocs_on_canc_sup_ord 426 426 0 0.00 0 8175 339 0 0
x_make_qstorno_1000_1200 5882 5882 0 0.00 2 32392 1118 0 0
x_make_qstorno_1200_2000 5814 5814 0 0.00 3 81641 2903 0 0
x_make_qstorno_2100_3300 488013 488013 0 0.00 0 76128 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-02-2021 19:28:16 to 01-02-2021 19:28:20.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:20 10 8192000000 8803863808 8815874048 8438896 0.102 3 1 2 0 8559600 58144 62560
16:57:26 16419 8192000000 10242805376 10550939648 993015040 10.811 78 57 113 1 1015302160 2782864 19504256
16:57:53 21060 8192000000 10337763792 10650488832 1383615584 14.449 100 89 179 0 1418494752 4453408 30425760
16:58:23 25423 8192000000 10375395520 10697498624 1428299440 14.846 100 88 176 0 1461958992 5131808 28527744
16:58:58 26826 8192000000 10400473072 10723651584 1453151312 15.066 100 89 178 0 1488525312 6276928 29097072
16:59:36 21778 8192000000 10418421664 10744455168 1475388720 15.261 100 87 174 0 1510504944 6930128 28186096
17:00:12 29930 8192000000 10444183664 10774351872 1496276976 15.444 100 88 176 0 1532041888 7963984 27800928
17:01:00 22856 8192000000 10464488800 10803613696 1525434048 15.697 100 89 178 0 1562391024 8509248 28447728
17:01:39 23353 8192000000 10515887104 10865115136 1563898176 16.030 100 83 167 2 1598922480 9142736 25881568
17:02:11 14800 8192000000 10535325792 10893320192 1604461824 16.377 100 71 142 1 1635009568 9116672 21431072
17:02:36 11379 8192000000 10581665200 10939904000 1636632848 16.651 100 81 162 0 1670419696 10132080 23654768
17:02:57 11481 8192000000 10614659776 10974109696 1661991600 16.866 100 77 154 0 1695488864 10764944 22732320
17:03:20 9114 8192000000 10626248240 10991194112 1677651488 16.998 100 74 148 2 1710506176 11498416 21356272
17:03:38 8483 8192000000 10643914928 11012894720 1706452144 17.239 100 79 159 0 1740693936 11804000 22437792
17:03:57 9880 8192000000 10649486704 11020206080 1709773360 17.267 100 78 156 1 1744384560 12503872 22107328
17:04:14 7573 8192000000 10663704944 11036311552 1728608400 17.424 100 86 169 1 1765618624 12698096 24312128
17:04:30 7447 8192000000 10680342208 11053879296 1733962800 17.468 100 79 158 1 1768487616 12564208 21960608
17:04:47 7343 8192000000 10688804416 11067625472 1748793248 17.592 100 83 166 1 1785595696 13015248 23787200
17:05:02 4740 8192000000 10701599920 11077627904 1758818080 17.675 100 76 152 1 1794141136 13249632 22073424
17:05:13 8331 8192000000 10710128848 11089358848 1768985712 17.759 100 80 160 1 1804926896 13635456 22305728
17:05:29 5454 8192000000 10710190800 11089055744 1776581760 17.821 100 83 163 1 1813190736 13893632 22715344
17:05:42 5994 8192000000 10720805856 11101544448 1779072896 17.842 100 82 165 1 1816227424 13932608 23221920
17:05:55 4268 8192000000 10735917504 11112697856 1791347168 17.943 100 90 180 1 1829947472 13619360 24980944
17:06:06 3327 8192000000 10728548704 11109326848 1790255024 17.934 100 87 175 3 1829307040 14962512 24089504
17:06:17 3789 8192000000 10742845328 11122843648 1796759408 17.987 100 85 168 0 1834104384 14209792 23135184
17:06:27 3869 8192000000 10743157312 11126304768 1805673552 18.060 100 83 167 1 1841887856 13360032 22854272
17:06:39 3967 8192000000 10741062208 11129761792 1804869536 18.054 100 79 155 2 1839459360 13419168 21170656
17:06:51 5534 8192000000 10749999312 11130171392 1810033728 18.096 100 84 170 1 1847313888 13816864 23463296
17:07:03 3094 8192000000 10768862192 11151220736 1826380640 18.230 100 87 174 2 1865335664 14719488 24235536
17:07:13 2961 8192000000 10777358992 11156889600 1830818192 18.266 100 93 186 0 1872168960 15470528 25880240
17:07:23 2876 8192000000 10770702144 11154022400 1828129296 18.244 100 82 164 1 1866548192 15255632 23163264
17:07:33 2082 8192000000 10778443664 11161751552 1832708336 18.281 100 91 178 2 1871557392 14131136 24717920
17:07:41 3487 8192000000 10779157232 11164643328 1835390512 18.303 100 87 174 2 1874267056 14266048 24610496
17:07:51 1662 8192000000 10795211280 11177115648 1845155184 18.383 100 93 184 1 1884095056 13485488 25454384
17:07:59 1713 8192000000 10798095056 11182837760 1853110144 18.447 100 93 184 1 1892620704 13517920 25992640
17:08:08 2760 8192000000 10804593872 11189702656 1858263296 18.489 100 95 190 2 1899310800 13706304 27341200
17:08:17 2325 8192000000 10803277536 11189563392 1858731952 18.493 100 92 185 1 1898840432 13863760 26244720
17:08:26 2109 8192000000 10805346752 11193303040 1859227168 18.497 100 90 180 0 1897958640 13407616 25323856
17:08:36 1678 8192000000 10807940848 11192705024 1863972560 18.535 100 91 180 1 1903666496 13479008 26214928
17:08:44 2045 8192000000 10810169056 11197661184 1868752032 18.574 100 96 189 0 1909158736 13558496 26848208
17:08:52 1735 8192000000 10812283184 11197493248 1868427504 18.572 100 88 177 0 1905903472 12413872 25062096
17:09:01 1431 8192000000 10814854800 11201019904 1869317872 18.579 100 91 181 1 1907040272 12643008 25079392
17:09:09 1742 8192000000 10809685344 11200638976 1870332624 18.587 100 85 169 1 1907448608 12671024 24444960
17:09:17 18151 8192000000 10796262336 11201073152 1867512304 18.564 100 67 134 0 1897899840 11192672 19194864
17:09:42 12781 8192000000 10808253456 11203674112 1870979520 18.592 100 81 162 1 1907802912 13030224 23793168
17:10:02 1130 8192000000 10822544768 11210457088 1874336432 18.619 100 94 190 0 1915335472 13269504 27729536
17:10:09 4962 8192000000 10793908624 11203563520 1867733232 18.566 100 54 107 1 1892724224 10083680 14907312
17:10:23 4923 8192000000 10796491104 11206508544 1877893248 18.648 100 52 103 3 1901138032 8490480 14754304
17:10:34 4071 8192000000 10795206752 11211747328 1877787344 18.647 100 37 74 0 1896153888 8022112 10344432
17:10:45 3027 8192000000 10796030336 11214065664 1880783120 18.671 100 51 103 3 1903588192 8467152 14337920
17:10:58 3323 8192000000 10797154832 11215122432 1883900752 18.697 100 43 84 1 1904216672 8730384 11585536
17:11:09 4047 8192000000 10815533792 11222114304 1886923648 18.721 100 46 91 2 1906551504 6066848 13561008
17:11:20 5096 8192000000 10808034912 11226386432 1892465008 18.766 100 56 113 2 1917511312 8521584 16524720
17:11:33 9867 8192000000 10800015008 11226431488 1889225136 18.740 100 41 82 1 1908019200 7156912 11637152
17:12:27 16794 8192000000 10810496624 11234521088 1894159120 18.779 100 36 72 2 1910987312 7409584 9418608
17:12:50 4709 8192000000 10814639792 11237490688 1895760992 18.792 100 41 83 0 1915307920 7566848 11980080
17:13:02 6019 8192000000 10808350752 11234553856 1894365264 18.781 100 27 54 0 1908996128 6088240 8542624
17:13:17 2071 8192000000 10820775232 11241095168 1901382224 18.837 100 50 100 3 1922817600 6738208 14697168
17:13:25 6139 8192000000 10802568112 11240038400 1897898608 18.809 100 23 46 2 1911487504 7413840 6175056
17:13:40 5938 8192000000 10814345328 11242446848 1901071584 18.835 100 26 47 2 1914959296 6426656 7461056
17:13:52 4926 8192000000 10828552640 11249901568 1905746016 18.872 100 41 82 1 1925720912 8430864 11544032
17:14:03 6196 8192000000 10825488896 11249008640 1905627424 18.872 100 35 70 4 1922196736 6191168 10378144
17:14:17 8119 8192000000 10809201040 11245211648 1906847984 18.881 100 29 58 1 1922018512 6634592 8535936
17:14:31 7969 8192000000 10823059872 11251757056 1906070240 18.875 100 16 31 4 1915675200 5251888 4353072
17:14:51 7078 8192000000 10825108736 11255984128 1910938624 18.914 100 34 68 0 1927400640 7152368 9309648
17:15:10 7020 8192000000 10828962368 11257856000 1913916976 18.938 100 25 50 1 1926304016 6135056 6251984
17:15:25 8346 8192000000 10828704880 11258605568 1911546240 18.919 100 22 44 1 1923826848 6150992 6129616
17:15:40 10707 8192000000 10825443184 11248898048 1904928720 18.866 100 22 44 1 1917242560 6154320 6159520
17:15:59 59796 8192000000 10814027696 11244814336 1889159744 18.739 99 28 53 0 1906783072 9683488 7939840
17:17:07 8395 8192000000 10815566256 11249094656 1889113280 18.739 99 24 48 3 1902388640 6610800 6664560
17:17:22 4973 8192000000 10821211376 11248422912 1887686960 18.727 99 31 61 0 1903762624 7738432 8337232
17:17:34 4340 8192000000 10814771984 11246878720 1903743728 18.856 100 30 59 1 1917815248 5561920 8509600
17:17:46 7284 8192000000 10834426208 11260911616 1911470784 18.918 100 36 72 2 1928046320 6779408 9796128
17:18:00 6959 8192000000 10803078112 11241988096 1882205264 18.683 99 25 50 2 1897268288 7581424 7481600
17:18:15 8636 8192000000 10802421776 11228991488 1856622576 18.476 98 21 42 0 1868647424 5355616 6669232
17:18:30 6908 8192000000 10768823728 11196530688 1794195984 17.966 95 18 36 0 1804550880 5250784 5104112
17:18:44 10633 8192000000 10751991264 11176665088 1826432048 18.230 97 28 56 2 1840434544 5230496 8772000
17:19:04 9018 8192000000 10780701760 11206651904 1835262144 18.302 98 21 42 2 1846920224 5394048 6264032
17:19:20 5828 8192000000 10758856096 11190710272 1827212000 18.237 98 20 40 4 1837673184 5306208 5154976
17:19:32 11732 8192000000 10766324864 11187896320 1832164992 18.277 99 16 32 1 1842565968 6072368 4328608
17:19:50 6639 8192000000 10764259152 11187273728 1833146816 18.285 99 29 58 2 1847520592 5664976 8708800
17:20:04 12649 8192000000 10732195376 11151466496 1746342352 17.571 95 18 36 1 1760734032 9258096 5133584
17:20:23 2452 8192000000 10730499248 11139293184 1791483392 17.944 98 31 61 2 1806374832 6371488 8519952
17:20:31 8066 8192000000 10697742048 11102564352 1693292208 17.129 94 15 32 1 1702327248 4921216 4113824
17:20:47 28899 8192000000 10706256256 11120877568 1760440128 17.688 97 38 76 3 1777966512 5758688 11767696
17:21:55 23576 8192000000 10701723872 11115761664 1691823680 17.117 93 14 28 1 1700507232 4466832 4216720
17:22:28 7189 8192000000 10702105744 11118125056 1771548720 17.780 99 26 50 2 1785888816 6444000 7896096
17:22:43 4595 8192000000 10711043280 11120435200 1753896000 17.634 97 43 85 3 1772903728 6651856 12355872
17:22:55 9131 8192000000 10715179584 11143282688 1806516832 18.067 100 18 36 0 1818039808 6540000 4982976
17:23:10 6073 8192000000 10726884768 11145236480 1807969392 18.079 100 32 65 1 1827283920 10777376 8537152
17:23:23 6169 8192000000 10743289344 11144183808 1801373856 18.025 99 42 84 2 1820581440 6815376 12392208
17:23:35 6802 8192000000 10744663232 11155587072 1821582208 18.191 100 47 94 0 1843127296 7215216 14329872
17:23:54 8532 8192000000 10727861440 11153223680 1805467840 18.059 99 25 51 1 1818778960 6225424 7085696
17:24:12 9088 8192000000 10739880800 11168608256 1829775744 18.257 100 21 40 1 1841434208 5758896 5899568
17:24:27 10311 8192000000 10746508176 11177295872 1837554512 18.321 100 25 50 1 1851643360 6337248 7751600
17:24:43 10690 8192000000 10767016048 11183783936 1845359392 18.384 100 34 68 2 1861459712 5377968 10722352
17:25:02 14493 8192000000 10757341808 11182706688 1844748608 18.379 100 30 61 1 1859537232 4784464 10004160
17:25:23 10169 8192000000 10772428048 11194691584 1850113168 18.423 100 21 42 1 1861055824 4945936 5996720
17:25:40 53557 8192000000 10775404080 11195617280 1849511232 18.418 100 18 36 1 1860332928 5551104 5270592
17:26:52 21554 8192000000 10786263648 11212398592 1867166240 18.561 100 26 50 4 1879610944 5816320 6628384
17:27:28 23256 8192000000 10827226656 11241684992 1890884720 18.753 100 48 96 1 1910535120 6370560 13279840
17:28:13 20877 8192000000 10838565040 11253952512 1902246032 18.844 100 47 94 0 1926059408 10749360 13064016
17:28:49 10516 8192000000 10840836000 11257348096 1906308464 18.877 100 50 97 0 1932077216 12155056 13613696
17:29:07 16745 8192000000 10834776400 11264126976 1909945232 18.906 100 45 90 0 1934874560 12207728 12721600
17:29:32 13600 8192000000 10859358080 11273670656 1917246784 18.965 100 50 95 2 1942221952 11392624 13582544
17:29:52 20212 8192000000 10851576096 11277721600 1919013152 18.979 100 44 86 1 1943451008 11916896 12520960
17:30:22 28809 8192000000 10857151136 11287089152 1925121648 19.028 100 31 62 0 1946487456 12408896 8956912
17:31:05 8599 8192000000 10876648848 11301330944 1935864256 19.114 100 46 93 2 1967357040 17624016 13868768
17:31:21 26543 8192000000 10868753840 11306094592 1936014496 19.115 100 35 70 0 1965656496 19010032 10631968
17:31:55 18952 8192000000 10878660640 11309318144 1945211216 19.188 100 51 101 3 1977354448 16769648 15373584
17:32:22 10795 8192000000 10888260480 11317161984 1953272032 19.253 100 46 92 0 1987743968 20285280 14186656
17:32:46 13392 8192000000 10900179216 11327045632 1953549936 19.255 100 54 109 3 1990346848 20827472 15969440
17:33:07 7339 8192000000 10910200128 11333410816 1962567968 19.326 100 61 122 2 2002216048 22179104 17468976
17:33:27 23802 8192000000 10917830496 11345920000 1963876384 19.337 100 55 110 1 2006003584 25977456 16149744
17:33:59 30431 8192000000 10920298576 11353645056 1970662432 19.391 100 44 88 2 2010522096 26210064 13649600
17:34:36 6336 8192000000 10925568864 11357528064 1974063120 19.418 100 54 106 4 2017883696 27495936 16324640
17:34:51 10060 8192000000 10922554912 11356069888 1975035760 19.425 100 50 97 1 2021454032 31604624 14813648
17:35:21 11193 8192000000 10922516016 11358760960 1978469040 19.453 100 47 94 1 2020101600 26558688 15073872
17:35:43 19820 8192000000 10940060864 11372138496 1986961616 19.520 100 54 107 1 2032240464 28384128 16894720
17:36:17 12930 8192000000 10935124848 11377029120 1987024992 19.520 100 43 86 3 2027327072 27272192 13029888
17:36:39 14748 8192000000 10948080208 11388313600 1996134832 19.592 100 46 90 1 2037645472 27637504 13873136
17:37:08 9939 8192000000 10958967632 11393806336 2005902368 19.669 100 56 113 1 2053439504 30722800 16814336
17:37:30 9803 8192000000 10978544768 11409801216 2006828112 19.677 100 61 122 1 2064907520 40494080 17585328
17:37:51 7250 8192000000 10964459920 11399528448 2004768016 19.660 100 54 108 0 2053479984 32092880 16619088
17:38:08 5355 8192000000 10959882032 11393208320 1987904832 19.527 99 58 113 0 2038020048 32995392 17119824
17:38:22 3667 8192000000 10976202080 11398520832 2004857232 19.661 100 67 134 2 2058716800 33087664 20771904
17:38:36 7451 8192000000 10971124160 11396763648 2002772304 19.645 100 71 142 2 2059519648 35323504 21423840
17:38:50 5712 8192000000 10980184688 11402371072 2009691008 19.699 100 74 145 1 2064102800 33395808 21015984
17:39:08 11054 8192000000 10979386400 11409293312 2010808176 19.708 100 66 130 1 2064982832 34434256 19740400
17:39:26 2507 8192000000 10975109120 11400388608 2003702944 19.652 100 70 140 1 2060393984 34905536 21785504
17:39:43 21949 8192000000 10980352560 11406213120 2002669792 19.644 100 58 116 3 2055423600 34591472 18162336
17:40:12 4525 8192000000 10981966448 11408527360 2010369344 19.704 100 78 151 1 2070226800 36790608 23066848
17:40:24 3169 8192000000 10985575840 11413864448 2013817920 19.732 100 82 163 1 2075960496 37322912 24819664
17:40:35 13380 8192000000 10976445344 11410784256 1993217376 19.569 99 75 149 1 2054802912 39299408 22286128
17:41:00 5673 8192000000 10989759152 11416760320 2009825216 19.700 100 67 134 1 2072910512 41906096 21179200
17:41:13 5611 8192000000 10993514512 11426320384 2014433424 19.736 100 74 146 0 2078700736 41444464 22822848
17:41:27 3086 8192000000 10983596928 11414880256 2004895936 19.661 100 60 118 0 2066098624 42613904 18588784
17:41:39 4798 8192000000 10983131248 11411275776 1970860640 19.392 98 75 148 0 2037890960 43715136 23315184
17:41:52 5426 8192000000 10980597824 11414089728 2001541904 19.635 100 62 122 0 2068877280 47777536 19557840
17:42:07 2298 8192000000 10979721600 11414761472 2003777296 19.653 100 64 126 0 2072711488 48716160 20218032
17:42:20 5213 8192000000 10977510864 11405705216 1995705552 19.589 100 63 126 0 2064018640 47116176 21196912
17:42:33 1275 8192000000 10992499440 11417219072 2002281728 19.641 100 69 136 1 2073893008 48790496 22820784
17:42:42 7087 8192000000 10995915456 11426758656 2004953120 19.662 100 69 137 2 2077595952 50142752 22500080
17:43:00 2838 8192000000 11003741024 11425505280 2005802320 19.668 100 76 149 0 2082382608 52111376 24468912
17:43:11 5044 8192000000 10997288864 11423322112 2002773232 19.645 100 72 142 1 2079136880 53644496 22719152
17:43:23 4128 8192000000 11005283440 11428569088 2007911152 19.685 100 76 152 0 2085773440 53750608 24111680
17:43:35 4034 8192000000 11005519728 11431182336 2016813680 19.755 100 76 151 0 2091909072 51089136 24006256
17:43:47 3890 8192000000 10996283968 11430813696 2015088912 19.742 100 70 139 0 2084939680 48113760 21737008
17:43:59 4035 8192000000 10991422448 11427491840 2011274000 19.712 100 72 144 0 2083730784 49313168 23143616
17:44:13 5187 8192000000 10997825776 11426611200 2015617584 19.746 100 72 144 1 2083185104 44515568 23051952
17:44:26 3729 8192000000 11002856960 11426631680 1999658288 19.620 99 76 152 2 2068520816 45250320 23612208
17:44:37 1405 8192000000 10975886960 11392929792 1959974368 19.306 97 81 160 1 2031235472 47197584 24063520
17:44:46 3489 8192000000 10995052784 11415216128 2000542192 19.627 100 83 166 1 2076805184 50246032 26016960
17:44:57 2192 8192000000 11011862416 11431735296 2015535952 19.745 100 92 183 0 2094106976 50810224 27760800
17:45:08 3685 8192000000 11002032816 11424595968 2006168224 19.671 100 82 163 2 2083434496 51497504 25768768
17:45:18 2201 8192000000 10993700880 11415261184 1995085248 19.584 100 82 161 0 2075377232 55021584 25270400
17:45:29 11342 8192000000 10970325440 11413372928 1988347584 19.531 100 62 123 0 2062743456 54516960 19878912
17:45:58 7847 8192000000 10979362304 11417579520 1991634736 19.557 100 49 96 0 2060280048 51857808 16787504
17:46:13 11177 8192000000 10960044816 11410030592 1986329552 19.515 100 43 86 1 2055169504 54425952 14414000
17:46:40 7391 8192000000 10941489856 11383459840 1942684144 19.168 98 42 85 1 2007479424 50421104 14374176
17:46:56 11927 8192000000 10893780928 11335786496 1866217456 18.554 96 40 79 0 1928400544 48971920 13211168
17:47:15 4815 8192000000 10904576384 11340288000 1908750800 18.897 99 43 88 0 1977056448 54278976 14026672
17:47:28 9577 8192000000 10925906992 11363258368 1937667968 19.128 100 48 96 1 2010546160 57114416 15763776
17:47:44 9118 8192000000 10926688336 11367149568 1940538480 19.151 100 36 70 2 2008740768 56156160 12046128
17:48:15 9277 8192000000 10908619296 11346997248 1926851376 19.042 99 27 54 0 1975097792 39822864 8423552
17:48:32 12412 8192000000 10900609488 11349848064 1928874848 19.058 99 38 76 1 1985448784 44276032 12297904
17:48:51 18115 8192000000 10882789872 11330740224 1906196608 18.876 98 29 58 0 1957897088 41586800 10113680
17:49:18 38577 8192000000 10892843152 11345559552 1904497952 18.862 98 23 46 1 1946442736 34710896 7233888
17:50:03 37071 8192000000 10888069744 11342888960 1914617984 18.944 99 16 32 1 1964198240 43665664 5914592
17:50:46 44476 8192000000 10870237856 11333967872 1844496832 18.377 96 18 36 3 1905277664 53873504 6907328
17:51:37 18573 8192000000 10884932336 11341221888 1904753840 18.865 100 19 38 1 1967777952 56476016 6548096
17:52:03 72869 8192000000 10833906480 11291762688 1833468128 18.288 96 8 17 1 1861354496 25553824 2332544
17:53:24 76951 8192000000 10825707616 11273011200 1825048640 18.219 96 13 26 1 1838194224 9999632 3145952
17:54:51 82395 8192000000 10827753776 11278020608 1850479072 18.426 97 17 34 3 1867614528 12449504 4685952
17:56:28 112143 8192000000 10830251680 11291504640 1875151936 18.626 98 37 74 1 1893864240 8033776 10678528
17:58:27 60666 8192000000 10887469200 11331973120 1900763584 18.832 98 24 48 1 1917480496 10499904 6217008
17:59:34 48996 8192000000 10868362496 11338874880 1946348864 19.197 100 24 48 0 1968107872 15221440 6537568
18:00:44 19879 8192000000 10872888624 11339018240 1944895840 19.186 100 16 28 2 1960207856 11668976 3643040
18:01:11 14980 8192000000 10870107952 11318333440 1922385072 19.006 99 25 47 0 1938685104 9914976 6385056
18:01:33 6569 8192000000 10898145712 11340533760 1957245392 19.284 100 46 92 0 1983037120 13067152 12724576
18:01:47 18503 8192000000 10898841792 11348938752 1944217568 19.180 99 29 58 1 1966837408 14046224 8573616
18:02:24 26421 8192000000 10919074144 11368984576 1954696624 19.264 99 45 90 0 1990503664 22018880 13788160
18:03:04 38498 8192000000 10938327744 11380678656 1979992288 19.465 100 63 125 0 2019354208 20349840 19012080
18:03:54 60899 8192000000 10890763408 11358674944 1911371888 18.918 97 25 50 1 1938168944 18982000 7815056
18:05:08 61122 8192000000 10879470096 11351203840 1950546272 19.231 100 17 32 1 1977192208 22121552 4524384
18:06:18 67600 8192000000 10871962112 11349676032 1914044848 18.939 98 11 22 1 1935438592 18224752 3168992
18:07:48 43550 8192000000 10870802016 11342864384 1950642144 19.232 100 17 34 0 1968070304 11727536 5700624
18:08:39 38533 8192000000 10866832512 11337572352 1894188272 18.780 97 10 19 1 1905833232 9367664 2277296
18:09:24 37480 8192000000 10851974624 11322523648 1910296704 18.909 98 10 20 0 1924815696 11745296 2773696
18:10:09 48160 8192000000 10880909424 11339993088 1926470224 19.039 99 19 37 2 1944549696 13040176 5039296
18:11:13 35897 8192000000 10885201856 11345457152 1956706672 19.280 100 28 57 1 1972749568 8398864 7644032
18:11:59 20626 8192000000 10918103408 11358494720 1969107440 19.378 100 57 113 1 1992658864 7092544 16458880
18:12:27 23659 8192000000 10910361088 11372421120 1978008240 19.449 100 29 57 1 1996061728 9907840 8145648
18:12:57 40476 8192000000 10896010240 11358519296 1964735184 19.344 99 29 57 2 1984990112 11922224 8332704
18:13:44 68277 8192000000 10901555344 11371917312 1940962064 19.154 98 27 54 1 1969166768 20554160 7650544
18:15:06 68293 8192000000 10902082768 11370414080 1949374416 19.221 99 13 26 1 1967212384 14723328 3114640
18:16:25 21117 8192000000 10907457856 11362668544 1960143744 19.307 99 24 48 1 1975258480 7941712 7173024
18:16:56 37719 8192000000 10901849440 11379986432 1973884544 19.416 100 25 50 2 1993652480 12416080 7351856
18:17:42 125127 8192000000 10910636080 11377532928 1900784976 18.833 96 5 9 0 1912827120 11233696 808448
18:19:53 66249 8192000000 10919829792 11385942016 1968727088 19.375 99 17 34 0 1986336384 12259952 5349344
18:21:11 95911 8192000000 10899344240 11363987456 1922901840 19.010 97 8 16 0 1937094560 12529712 1663008
18:22:55 70353 8192000000 10905853344 11343835136 1931438224 19.078 98 18 36 0 1943289440 6908848 4942368
18:24:20 87692 8192000000 10886585536 11355684864 1876386848 18.636 95 21 42 1 1893655024 11089168 6179008
18:25:54 45148 8192000000 10889949072 11355820032 1944990032 19.187 99 21 42 2 1962413984 11617856 5806096
18:26:47 8796 8192000000 10885325728 11365646336 1965344944 19.349 100 9 18 1 1980884320 12331392 3207984
18:27:05 51517 8192000000 10919221824 11394760704 1989695280 19.541 100 29 59 0 2008579296 10849680 8034336
18:28:11 64067 8192000000 10884769008 11370840064 1928380896 19.054 97 4 8 0 1940401216 11480544 539776
18:29:27 76724 8192000000 10869285984 11336765440 1885264352 18.708 95 20 41 0 1902536736 11185600 6086784
18:30:58 56888 8192000000 10885674384 11353989120 1940379760 19.150 99 14 28 0 1955674064 11110496 4183808
18:32:02 60873 8192000000 10903335104 11379646464 1961194704 19.316 100 10 20 0 1978760480 14531824 3033952
18:33:09 43417 8192000000 10881898112 11350835200 1925764368 19.033 97 21 42 1 1942810416 11459696 5586352
18:33:59 35786 8192000000 10886635056 11351601152 1917288752 18.965 97 26 52 0 1935301280 10355760 7656768
18:34:46 43851 8192000000 10855250912 11314106368 1859690688 18.501 95 15 30 0 1871668016 7521040 4456288
18:35:39 34632 8192000000 10864676288 11317141504 1855418304 18.466 95 25 50 0 1871381264 8477536 7485424
18:36:20 32238 8192000000 10863617776 11325562880 1920038432 18.987 99 24 48 1 1937188704 10717008 6433264
18:36:58 39646 8192000000 10871121344 11333087232 1915668032 18.952 99 19 38 1 1931720032 10700704 5351296
18:37:45 34437 8192000000 10857965920 11318026240 1891173344 18.755 98 35 70 2 1916087632 14553056 10361232
18:38:30 57531 8192000000 10838778512 11310825472 1855897840 18.470 97 16 32 0 1872959920 12920272 4141808
18:39:34 125932 8192000000 10874983408 11327336448 1876982128 18.641 97 26 52 1 1897796304 13684384 7129792
18:41:58 15431 8192000000 10891376336 11331899392 1908649744 18.896 98 52 103 1 1935387648 12195968 14541936
18:42:22 24954 8192000000 10886262992 11337940992 1939254000 19.141 100 41 82 2 1965094016 14187728 11652288
18:42:56 72781 8192000000 10879066848 11338268672 1904732432 18.864 98 16 32 1 1927030352 18194096 4103824
18:44:15 51216 8192000000 10898481056 11345162240 1929082208 19.060 99 29 58 0 1948103536 10658512 8362816
18:45:16 73326 8192000000 10864921472 11337093120 1909189184 18.900 98 22 43 2 1929318320 13962720 6166416
18:47:04 89067 8192000000 10841906960 11313397760 1886818320 18.720 97 11 22 1 1895164496 5252224 3093952
18:48:52 796 8192000000 10872600736 11315032064 1933743344 19.097 100 42 82 0 1952020048 6588736 11687968
18:48:59 48365 8192000000 10858103104 11335565312 1929953088 19.067 99 37 74 1 1950715152 10180256 10581808
18:49:57 73288 8192000000 10850504848 11324833792 1906025088 18.875 98 8 16 0 1922864304 14361808 2477408
18:51:16 28042 8192000000 10853953840 11334651904 1938790112 19.137 100 4 8 1 1950461920 10676944 994864
18:51:55 35369 8192000000 10845895968 11316137984 1881110864 18.674 97 14 28 1 1897097008 11877184 4108960
18:52:38 73292 8192000000 10850729776 11315929088 1899168928 18.820 98 14 28 0 1914050592 11342960 3538704
18:54:01 53912 8192000000 10858541056 11330015232 1915905216 18.954 99 17 34 0 1926803088 5805744 5092128
18:55:05 92178 8192000000 10865258768 11356004352 1915467072 18.951 98 9 18 0 1929572352 11459760 2645520
18:56:44 66952 8192000000 10890587040 11355639808 1957129904 19.283 100 8 16 0 1967466192 8333392 2002896
18:57:57 15822 8192000000 10889962688 11345616896 1945430832 19.190 99 33 66 1 1962739808 7264064 10044912
18:58:23 28374 8192000000 10900197488 11363639296 1971400928 19.397 100 42 84 0 1992033984 8949024 11684032
18:59:01 37544 8192000000 10903533952 11376144384 1977478160 19.445 100 33 66 0 1997173856 10631456 9064240
18:59:48 99687 8192000000 10901704176 11377852416 1937901696 19.130 98 18 36 1 1956817200 13971248 4944256
19:01:36 39102 8192000000 10884919568 11345874944 1934717552 19.105 98 34 68 0 1954143584 9831840 9594192
19:02:25 33597 8192000000 10894034192 11354980352 1909843024 18.905 97 24 48 0 1930863552 13997152 7023376
19:03:09 32388 8192000000 10918606304 11378573312 1969060432 19.378 100 28 57 0 1997177088 19957840 8158816
19:04:57 45850 8192000000 10902595152 11373658112 1968132704 19.371 100 14 28 3 1987706848 15783760 3790384
19:05:53 72286 8192000000 10899346864 11381649408 1933411296 19.094 98 15 30 1 1956331712 18413792 4506624
19:07:11 92236 8192000000 10892318032 11374084096 1887237904 18.724 96 5 10 1 1904011584 15619408 1154272
19:08:50 35994 8192000000 10929358448 11371192320 1943893872 19.178 98 33 66 0 1961191648 7437648 9860128
19:09:44 106721 8192000000 10905917248 11379183616 1982638992 19.486 100 28 53 2 2001553520 11216128 7698400
19:11:37 69520 8192000000 10897414352 11367370752 1909412096 18.902 96 28 54 1 1923454208 7206656 6835456
19:12:57 25460 8192000000 10880326544 11352113152 1958621040 19.295 100 23 46 1 1975728064 10828512 6278512
19:13:29 20183 8192000000 10892285280 11361665024 1941844448 19.161 99 11 23 1 1952181808 7809104 2528256
19:13:59 34254 8192000000 10898612032 11360976896 1956191968 19.276 99 21 42 1 1973273088 10384064 6697056
19:16:09 54929 8192000000 10891196336 11375505408 1937999376 19.131 98 11 22 0 1956954560 15552288 3402896
19:17:53 68145 8192000000 10857154576 11332923392 1905095392 18.867 97 15 30 3 1927858496 17909120 4853984
19:19:15 43997 8192000000 10859750592 11329224704 1888662688 18.735 97 12 24 1 1901177680 9111472 3403520
19:20:05 71315 8192000000 10832979360 11288289280 1786758000 17.905 92 16 32 0 1802160464 10952752 4449712
19:21:25 51804 8192000000 10837188544 11311071232 1858098432 18.488 97 12 24 0 1875730128 13924624 3707072
19:22:23 41389 8192000000 10871643392 11319554048 1891327584 18.756 98 18 36 1 1904360608 8140240 4892784
19:23:12 11363 8192000000 10861132640 11316486144 1914422672 18.942 99 48 97 1 1937184208 8946128 13815408
19:23:37 37066 8192000000 10879757072 11332718592 1900122960 18.827 98 36 72 1 1922767168 12675968 9968240
19:24:25 32138 8192000000 10870660672 11334316032 1921000384 18.995 99 37 74 4 1944906592 12933280 10972928
19:25:04 72709 8192000000 10873363184 11346604032 1884097568 18.698 97 22 44 0 1903884992 13408528 6378896
19:26:26 58314 8192000000 9504601536 9816813568 597005936 6.792 31 4 8 0 604752832 6900608 846288

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 01-02-2021 19:28:22 to 01-02-2021 19:28:54.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-02-2021 19:28:54 to 01-02-2021 19:28:56.

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          243741
MON$OLDEST_ACTIVE               243742
MON$OLDEST_SNAPSHOT             243742
MON$NEXT_TRANSACTION            243742
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                       2002240
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.33411 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33411 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33411 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33411 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 ---
:35: 
:36: mscs-test-161.budzdorov.ru    Mon Feb  1 19:27:28 2021
:37:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:38: 
:39: 
:40: mscs-test-161.budzdorov.ru    Mon Feb  1 19:27:30 2021
:41:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:42: 
--- end of diff output ---

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

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