Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.12.2020 16:33
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 17316108 kB
MemAvailable 31591384 kB
Buffers 0 kB
Cached 14404648 kB
SwapCached 3708 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-11 16:31:57
DTS_END                         2020-12-11 16:31:57.1880
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/57234
TRN_ID                          254814
ATT_ID                          662
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: 9614.73 22725 1153767
customer order: creation 181.08 337 21729
customer order: refuse 15.59 295 1871
order to supplier: creation 48.23 1188 5787
order to supplier: removal 3.44 93990 413
invoice (draft): creation 48.07 3132 5768
invoice (draft): removal 53.53 750 6423
invoice accept: apply 44.05 16928 5286
invoice accept: cancel 48.66 740 5839
customer reserve: creation 4082.88 167 489945
customer reserve: removal 4778.72 53 573446
realization accept: apply 88.60 193 10632
realization accept: cancel 87.68 101 10521
payment from customer: creation 61.99 151 7439
payment from customer: removal 5.53 65 663
payment to supplier: creation 50.83 164 6099
payment to supplier: removal 3.74 100 449
service: total inventory turnovers 4.93 1155 592
service: total monetary turnovers 6.33 31 760
service: aggregate perf. data 0.84 20208 101
service: refresh index statistics 0.03 314746 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-12-2020 16:33:40 to 11-12-2020 16:33:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4115
TEST_TIME 2 2963
TEST_TIME 3 3410
TEST_TIME 4 3974
TEST_TIME 5 4103
TEST_TIME 6 4791
TEST_TIME 7 5123
TEST_TIME 8 6424
TEST_TIME 9 6626
TEST_TIME 10 6770
TEST_TIME 11 6893
TEST_TIME 12 6991
TEST_TIME 13 7332
TEST_TIME 14 7429
TEST_TIME 15 7741
TEST_TIME 16 7988
TEST_TIME 17 8492
TEST_TIME 18 8681
TEST_TIME 19 8812
TEST_TIME 20 9023
TEST_TIME 21 9352
TEST_TIME 22 9194
TEST_TIME 23 9737
TEST_TIME 24 9729
TEST_TIME 25 10864
TEST_TIME 26 11236
TEST_TIME 27 11539
TEST_TIME 28 11406
TEST_TIME 29 11079
TEST_TIME 30 11215
TEST_TIME 31 11202
TEST_TIME 32 10905
TEST_TIME 33 10644
TEST_TIME 34 10759
TEST_TIME 35 10672
TEST_TIME 36 10595
TEST_TIME 37 10545
TEST_TIME 38 10457
TEST_TIME 39 10421
TEST_TIME 40 10410
TEST_TIME 41 10400
TEST_TIME 42 10321
TEST_TIME 43 10324
TEST_TIME 44 10337
TEST_TIME 45 10236
TEST_TIME 46 10146
TEST_TIME 47 10076
TEST_TIME 48 10048
TEST_TIME 49 10072
TEST_TIME 50 10086
TEST_TIME 51 9936
TEST_TIME 52 9962
TEST_TIME 53 9869
TEST_TIME 54 9821
TEST_TIME 55 9823
TEST_TIME 56 9791
TEST_TIME 57 9823
TEST_TIME 58 9892
TEST_TIME 59 9896
TEST_TIME 60 9933
TEST_TIME 61 10027
TEST_TIME 62 9978
TEST_TIME 63 10036
TEST_TIME 64 10093
TEST_TIME 65 10164
TEST_TIME 66 10124
TEST_TIME 67 10257
TEST_TIME 68 10190
TEST_TIME 69 10096
TEST_TIME 70 10020
TEST_TIME 71 9984
TEST_TIME 72 9953
TEST_TIME 73 9953
TEST_TIME 74 9863
TEST_TIME 75 9838
TEST_TIME 76 9795
TEST_TIME 77 9804
TEST_TIME 78 9823
TEST_TIME 79 9793
TEST_TIME 80 9801
TEST_TIME 81 9776
TEST_TIME 82 9885
TEST_TIME 83 9893
TEST_TIME 84 9965
TEST_TIME 85 9916
TEST_TIME 86 9954
TEST_TIME 87 9989
TEST_TIME 88 9985
TEST_TIME 89 10017
TEST_TIME 90 10003
TEST_TIME 91 9923
TEST_TIME 92 9924
TEST_TIME 93 9881
TEST_TIME 94 9836
TEST_TIME 95 9840
TEST_TIME 96 9796
TEST_TIME 97 9773
TEST_TIME 98 9841
TEST_TIME 99 9812
TEST_TIME 100 9801
TEST_TIME 101 9786
TEST_TIME 102 9827
TEST_TIME 103 9780
TEST_TIME 104 9867
TEST_TIME 105 9844
TEST_TIME 106 9883
TEST_TIME 107 9887
TEST_TIME 108 9885
TEST_TIME 109 9886
TEST_TIME 110 9872
TEST_TIME 111 9794
TEST_TIME 112 9783
TEST_TIME 113 9760
TEST_TIME 114 9762
TEST_TIME 115 9713
TEST_TIME 116 9724
TEST_TIME 117 9723
TEST_TIME 118 9668
TEST_TIME 119 9657
TEST_TIME 120 9618

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-12-2020 16:33:44 to 11-12-2020 16:33:47.

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 1608670 1608670 0 0.00 0 36604 7 0 0
doc_list_biud 1608670 1608670 0 0.00 0 34627 24 0 0
sp_add_invoice_to_stock 5435 5286 149 2.74 29 201337 16929 0 149
sp_cancel_adding_invoice 5839 5839 0 0.00 5 73908 740 0 0
sp_cancel_client_order 1871 1871 0 0.00 4 11015 296 0 0
sp_cancel_customer_reserve 573446 573446 0 0.00 1 33748 54 0 0
sp_cancel_pay_from_customer 663 663 0 0.00 3 4763 65 0 0
sp_cancel_pay_to_supplier 449 449 0 0.00 3 10580 101 0 0
sp_cancel_supplier_invoice 6437 6423 14 0.21 1 13207 750 0 14
sp_cancel_supplier_order 413 413 0 0.00 7 1028866 93991 0 0
sp_cancel_write_off 10521 10521 0 0.00 1 27337 101 0 0
sp_client_order 21729 21729 0 0.00 4 48688 338 0 0
sp_customer_reserve 489945 489945 0 0.00 0 133276 168 0 0
sp_fill_shopping_cart 33277 33277 0 0.00 1 24022 41 0 0
sp_fill_shopping_cart_clo_res 489940 489940 0 0.00 0 13869 13 0 0
sp_get_clo_for_invoice 5281 5281 0 0.00 0 39184 286 0 0
sp_kill_cost_storno 17472 17472 0 0.00 0 18358 49 0 0
sp_kill_qstorno_ret_qs2qd 1164249 1164249 0 0.00 0 33733 29 0 0
sp_kill_qty_storno 614426 614426 0 0.00 0 34625 63 0 0
sp_lock_selected_doc 22000 22000 0 0.00 0 9962 6 0 0
sp_make_cost_storno 29451 29451 0 0.00 0 36592 73 0 0
sp_multiply_rows_for_pdistr 29451 29451 0 0.00 0 18386 33 0 0
sp_multiply_rows_for_qdistr 21729 21729 0 0.00 0 48678 158 0 0
sp_pay_from_customer 7439 7439 0 0.00 4 31379 152 0 0
sp_pay_to_supplier 6099 6099 0 0.00 5 36662 164 0 0
sp_payment_common 13538 13538 0 0.00 1 25482 43 0 0
sp_qd_handle_on_cancel_clo 1871 1871 0 0.00 0 7975 265 0 0
sp_qd_handle_on_invoice_upd_sts 11120 11120 0 0.00 0 34623 287 0 0
sp_qd_handle_on_reserve_upd_sts 10632 10632 0 0.00 0 11789 49 0 0
sp_reserve_write_off 10632 10632 0 0.00 6 35850 194 0 0
sp_supplier_invoice 5768 5768 0 0.00 7 89989 3132 0 0
sp_supplier_order 5787 5787 0 0.00 4 24599 1188 0 0
srv_aggregate_perf_data 101 101 0 0.00 2693 364530 20208 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1427 173650 33230 0 0
srv_find_qd_qs_mism 1104227 1104227 0 0.00 0 28067 5 0 0
srv_make_invnt_saldo 592 592 0 0.00 27 39257 1156 0 0
srv_make_money_saldo 760 760 0 0.00 1 3774 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 175587 421623 314747 0 0
t$perf-abend:sp_add_invoice_to_stock 149 149 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5286 5286 0 0.00 0 18898 187 0 0
t$perf-norm:sp_cancel_adding_invoice 444 444 0 0.00 0 3031 90 0 0
t$perf-norm:sp_cancel_client_order 1871 1871 0 0.00 0 3362 14 0 0
t$perf-norm:sp_cancel_customer_reserve 727 727 0 0.00 0 849 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 663 663 0 0.00 0 1772 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 449 449 0 0.00 0 4285 22 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 648 12 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 19544 1398 0 0
t$perf-norm:sp_cancel_write_off 1107 1107 0 0.00 0 589 4 0 0
t$perf-norm:sp_client_order 21729 21729 0 0.00 0 6936 16 0 0
t$perf-norm:sp_customer_reserve 1062 1062 0 0.00 0 448 2 0 0
t$perf-norm:sp_pay_from_customer 7439 7439 0 0.00 0 8745 13 0 0
t$perf-norm:sp_pay_to_supplier 6099 6099 0 0.00 0 6926 12 0 0
t$perf-norm:sp_reserve_write_off 10632 10632 0 0.00 0 19915 12 0 0
t$perf-norm:sp_supplier_invoice 5768 5768 0 0.00 0 5538 16 0 0
t$perf-norm:sp_supplier_order 5787 5787 0 0.00 0 5689 16 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 334 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 202 4 0 0
t$perf-norm:srv_make_invnt_saldo 592 592 0 0.00 0 5164 34 0 0
t$perf-norm:srv_make_money_saldo 760 760 0 0.00 0 2362 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 7 4 0 0
v_add_invoice_to_stock 10860 10562 298 2.74 0 10516 21 0 298
v_all_customers 39568 39568 0 0.00 0 134 1 0 0
v_all_suppliers 31464 31464 0 0.00 0 14 1 0 0
v_all_wares 43458 43458 0 0.00 0 65 1 0 0
v_cancel_adding_invoice 888 888 0 0.00 0 5071 15 0 0
v_cancel_client_order 3742 3742 0 0.00 0 10603 8 0 0
v_cancel_customer_prepayment 1326 1326 0 0.00 0 1894 7 0 0
v_cancel_customer_reserve 1454 1454 0 0.00 0 437 3 0 0
v_cancel_payment_to_supplier 898 898 0 0.00 0 10555 16 0 0
v_cancel_supplier_invoice 854 826 28 3.27 0 1952 19 0 28
v_cancel_supplier_order 826 826 0 0.00 0 1250 4 0 0
v_cancel_write_off 2214 2214 0 0.00 0 3019 14 0 0
v_max_id_clo_ord 5785 5785 0 0.00 0 733 1 0 0
v_max_id_clo_res 1062 1062 0 0.00 0 1315 9 0 0
v_max_id_ord_sup 5763 5763 0 0.00 0 6611 4 0 0
v_max_non_paid_invoice 1915 1915 0 0.00 0 1743 4 0 0
v_max_non_paid_realizn 3941 3941 0 0.00 0 6641 6 0 0
v_min_id_clo_ord 5785 5785 0 0.00 0 8880 10 0 0
v_min_id_clo_res 1062 1062 0 0.00 0 6506 18 0 0
v_min_id_ord_sup 5763 5763 0 0.00 0 10611 13 0 0
v_min_non_paid_invoice 6099 6099 0 0.00 0 15112 22 0 0
v_min_non_paid_realizn 7439 7439 0 0.00 0 18369 27 0 0
v_our_firm 10886 10886 0 0.00 0 12 1 0 0
v_reserve_write_off 21264 21264 0 0.00 0 10605 6 0 0
x_lock_depdocs_on_canc_invoice 11849 11849 0 0.00 0 23223 112 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 4798 303 0 0
x_make_qstorno_1000_1200 5787 5787 0 0.00 1 24544 1109 0 0
x_make_qstorno_1200_2000 5768 5768 0 0.00 3 89955 2982 0 0
x_make_qstorno_2100_3300 489945 489945 0 0.00 0 133163 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-12-2020 16:33:48 to 11-12-2020 16:33:52.

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
14:02:01 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:07 14122 8192000000 10266752720 10577973248 1016294320 11.036 79 56 111 1 1037293104 2581376 18417408
14:02:28 28507 8192000000 10353048560 10674507776 1399423280 14.590 100 90 180 0 1432671344 4857808 28390256
14:03:08 22562 8192000000 10404589232 10729439232 1456441488 15.095 100 88 176 0 1491361488 7103760 27816240
14:03:44 25452 8192000000 10428586608 10761302016 1479406208 15.296 100 93 186 1 1517684048 8520960 29756880
14:04:32 15568 8192000000 10460244752 10796376064 1511497792 15.576 100 86 173 2 1548273712 9740864 27035056
14:05:05 17945 8192000000 10482112448 10824294400 1543247696 15.852 100 88 177 1 1581128832 10594096 27287040
14:05:33 19992 8192000000 10502308976 10851581952 1557264064 15.973 100 85 170 1 1594004256 11109696 25630496
14:06:01 13446 8192000000 10535776016 10883903488 1583184576 16.195 100 83 166 0 1619055328 10865504 25005248
14:06:26 17290 8192000000 10557367312 10910515200 1608202112 16.409 100 80 160 1 1644112144 11835872 24074160
14:06:52 16124 8192000000 10571448800 10932637696 1629296016 16.589 100 79 158 0 1664611888 11912064 23403808
14:07:18 16537 8192000000 10593411584 10951626752 1641837824 16.695 100 81 160 1 1677735776 12386640 23511312
14:07:46 10843 8192000000 10595744864 10961633280 1659048080 16.841 100 79 158 1 1694851184 12804528 22998576
14:08:06 11871 8192000000 10615007424 10984476672 1672212192 16.952 100 79 158 3 1708079472 12942976 22924304
14:08:27 9257 8192000000 10635831072 11007143936 1691795120 17.116 100 76 152 0 1727109072 13320384 21993568
14:08:44 8796 8192000000 10652429328 11027525632 1707585472 17.249 100 82 162 4 1744112672 13704576 22822624
14:08:59 6427 8192000000 10656418576 11029667840 1718408784 17.339 100 75 150 1 1753341344 14236144 20696416
14:09:12 3375 8192000000 10665384480 11039162368 1728563936 17.424 100 85 168 0 1766868976 15016528 23288512
14:09:23 5006 8192000000 10675890352 11052711936 1743890080 17.551 100 83 167 2 1780409952 13311504 23208368
14:09:36 5177 8192000000 10685662816 11068645376 1755553152 17.648 100 66 132 0 1785703920 11966624 18184144
14:09:48 4172 8192000000 10710557872 11091030016 1773389424 17.795 100 79 157 1 1807899504 12554432 21955648
14:09:59 4606 8192000000 10714406784 11098017792 1781398096 17.861 100 76 152 0 1816004800 13112992 21493712
14:10:10 1723 8192000000 10723854912 11110264832 1786427168 17.902 100 72 144 1 1819904096 13029328 20447600
14:10:20 2007 8192000000 10746628752 11129659392 1809005248 18.088 100 81 162 0 1846397520 12768640 24623632
14:10:29 2448 8192000000 10749381360 11134033920 1817791344 18.160 100 85 171 0 1853525184 11548336 24185504
14:10:39 1854 8192000000 10762270880 11146608640 1820942128 18.185 100 86 172 2 1858539888 12649408 24948352
14:10:47 1380 8192000000 10774327408 11162435584 1831667360 18.273 100 93 186 1 1870538832 12939536 25931936
14:10:55 1701 8192000000 10775290512 11163615232 1836521456 18.312 100 86 172 1 1873968592 13190288 24256848
14:11:03 1949 8192000000 10782891872 11171835904 1841421360 18.352 100 91 182 0 1881408704 14330336 25657008
14:11:12 1727 8192000000 10792104912 11176701952 1848976736 18.414 100 92 184 0 1889440256 14778176 25685344
14:11:20 1308 8192000000 10792388096 11176722432 1851609840 18.435 100 95 190 1 1891352912 12591632 27151440
14:11:28 1400 8192000000 10796406960 11179479040 1850048704 18.423 100 90 183 2 1888998576 12560544 26389328
14:11:36 3426 8192000000 10792543488 11179188224 1852378784 18.441 100 85 170 1 1889618976 13261360 23978832
14:11:45 1427 8192000000 10800115024 11193700352 1862699584 18.525 100 85 169 0 1898810128 12341872 23768672
14:11:54 1291 8192000000 10784157120 11190816768 1857689472 18.485 100 52 102 0 1883394080 10669152 15035456
14:12:02 3517 8192000000 10780625744 11188150272 1860700496 18.509 100 56 112 1 1886513024 9379488 16433040
14:12:11 6432 8192000000 10770643344 11190595584 1855906128 18.470 100 37 74 2 1874501088 8476112 10118848
14:12:25 3442 8192000000 10776089600 11191279616 1867520048 18.564 100 55 112 2 1888923120 5237216 16165856
14:12:38 52417 8192000000 10818287200 11210551296 1874507984 18.621 100 82 164 2 1905372048 6536704 24327360
14:13:37 3835 8192000000 10798732592 11215962112 1869350976 18.579 100 45 90 0 1891655296 10164368 12139952
14:13:47 7527 8192000000 10777839472 11208839168 1868269152 18.570 100 26 52 1 1883017776 7788240 6960384
14:14:01 7751 8192000000 10787054672 11212550144 1873351408 18.611 100 33 66 2 1889516048 6943488 9221152
14:14:17 8076 8192000000 10797594400 11217756160 1877309040 18.643 100 25 50 1 1890525952 6250384 6966528
14:14:33 3839 8192000000 10804501168 11227029504 1881100096 18.674 100 40 79 2 1904946144 12931968 10914080
14:14:44 4037 8192000000 10799579648 11225440256 1883222400 18.691 100 34 68 3 1900435920 7813984 9399536
14:14:58 6091 8192000000 10808725280 11233853440 1888789504 18.736 100 28 55 1 1903352896 6627200 7936192
14:15:10 6896 8192000000 10796697488 11230707712 1888599760 18.734 100 20 38 0 1899505920 5645312 5260848
14:15:26 9245 8192000000 10799298848 11233058816 1891637216 18.759 100 16 32 2 1902397776 6352256 4408304
14:15:41 11364 8192000000 10803483616 11238264832 1892506928 18.766 100 16 32 0 1903157584 5774512 4876144
14:15:58 8028 8192000000 10813834864 11238723584 1895107728 18.787 100 23 46 4 1907690832 6145840 6437264
14:16:15 9732 8192000000 10809209536 11240394752 1895428048 18.790 100 18 36 1 1906756320 5569920 5758352
14:16:38 6845 8192000000 10817601696 11248672768 1897452368 18.806 100 20 40 2 1912583808 10068144 5063296
14:16:51 17392 8192000000 10817862304 11250716672 1906861536 18.881 100 36 73 0 1924265488 5793776 11610176
14:17:15 68051 8192000000 10813442800 11255488512 1908496160 18.895 100 34 68 1 1924846384 6142048 10208176
14:18:29 6358 8192000000 10817579472 11259637760 1910529232 18.911 100 35 70 2 1928095584 7715584 9850768
14:18:43 9827 8192000000 10816952512 11259219968 1908531120 18.895 100 17 35 1 1919404528 6500640 4372768
14:18:59 5662 8192000000 10827556448 11254693888 1893759792 18.776 99 41 82 1 1912778672 6828848 12190032
14:19:12 9400 8192000000 10810694992 11254132736 1907775376 18.889 100 21 42 1 1920017728 5949120 6293232
14:19:30 5647 8192000000 10823708848 11256197120 1903553776 18.855 100 26 52 2 1917681536 6223712 7904048
14:19:43 10710 8192000000 10831936544 11261562880 1909705712 18.904 100 26 52 1 1923858560 6456320 7696528
14:20:02 6473 8192000000 10823252496 11263950848 1910048640 18.907 100 25 50 3 1923136576 6086080 7001856
14:20:15 9595 8192000000 10798242320 11228020736 1870347200 18.587 98 16 32 1 1880768112 5567472 4853440
14:20:31 8133 8192000000 10799485952 11228991488 1873434272 18.612 99 25 50 0 1886078512 5899872 6744368
14:20:48 10166 8192000000 10783151328 11213611008 1843603056 18.370 98 18 36 0 1854031200 5190464 5237680
14:21:04 9220 8192000000 10787644256 11215130624 1845658720 18.387 98 16 32 0 1855188176 5223664 4305792
14:21:20 10237 8192000000 10762916240 11185762304 1815402976 18.140 98 11 22 1 1823356608 5041440 2912192
14:21:41 6840 8192000000 10733593440 11154812928 1775954928 17.816 96 36 71 2 1791260240 5116848 10188464
14:21:55 9182 8192000000 10713394496 11125886976 1725956992 17.402 94 41 82 2 1743606656 5899696 11749968
14:22:11 70000 8192000000 10674316352 11088097280 1636446784 16.650 90 31 62 1 1650994304 5054608 9492912
14:23:29 9170 8192000000 10715234896 11123458048 1750946096 17.609 97 35 68 2 1767064320 5963456 10154768
14:23:47 5356 8192000000 10681797120 11090915328 1697407168 17.163 95 31 60 2 1713092800 6820496 8865136
14:24:00 7100 8192000000 10676638304 11090501632 1705879968 17.234 96 27 51 4 1718820160 5409728 7530464
14:24:13 8466 8192000000 10706116320 11113345024 1705442016 17.231 95 23 46 2 1716951248 5435328 6073904
14:24:29 7308 8192000000 10704984960 11120906240 1750005440 17.602 98 21 43 2 1761200432 5156144 6038848
14:24:43 4802 8192000000 10711605408 11128946688 1797579376 17.994 100 21 42 1 1809485696 5703904 6202416
14:24:58 8894 8192000000 10701683584 11118981120 1737909536 17.501 96 23 46 0 1749899712 5272720 6717456
14:25:13 6052 8192000000 10722629328 11138142208 1805254288 18.057 100 34 68 2 1819809088 5215920 9338880
14:25:25 7488 8192000000 10718240992 11136897024 1777343456 17.828 98 29 58 2 1792351104 6900848 8106800
14:25:39 5068 8192000000 10731491824 11145916416 1807440224 18.075 100 36 72 2 1824417968 6430320 10547424
14:25:51 10076 8192000000 10743772736 11164102656 1823933488 18.210 100 26 52 0 1836481984 5081280 7467216
14:26:07 8179 8192000000 10763000272 11183165440 1835395008 18.303 100 30 60 0 1853777152 9603856 8778288
14:26:27 5731 8192000000 10747846720 11171098624 1819928448 18.177 99 15 30 0 1830006464 5171840 4906176
14:26:39 10636 8192000000 10751822256 11182407680 1838676960 18.330 100 21 41 2 1854151584 9603040 5871584
14:26:58 15902 8192000000 10772334064 11187785728 1845522688 18.386 100 28 56 1 1860123120 5683760 8916672
14:27:21 52071 8192000000 10795567104 11198771200 1860243632 18.505 100 61 123 0 1889068000 10892736 17931632
14:28:21 14644 8192000000 10773811328 11198533632 1855604608 18.468 100 19 38 2 1866645424 5352208 5688608
14:28:42 8844 8192000000 10777526736 11200188416 1859552528 18.500 100 32 64 0 1874861680 6314256 8994896
14:28:57 8687 8192000000 10799474160 11212087296 1863237232 18.530 100 34 68 1 1883265712 10685472 9343008
14:29:13 7199 8192000000 10782456000 11212517376 1867089136 18.561 100 29 58 1 1881998096 5958720 8950240
14:29:31 6923 8192000000 10800525920 11219615744 1870792000 18.591 100 34 68 3 1890792624 10401760 9598864
14:29:48 11112 8192000000 10804627232 11219079168 1872164160 18.602 100 25 50 2 1885483392 6346048 6973184
14:30:05 10083 8192000000 10785764144 11219038208 1876712896 18.639 100 27 54 1 1890763744 5516768 8534080
14:30:23 13687 8192000000 10780809536 11217727488 1875289456 18.627 100 9 18 0 1882629536 5025072 2315008
14:30:43 13668 8192000000 10791180768 11225112576 1878297008 18.651 100 20 40 1 1889791376 5574080 5920288
14:31:03 9240 8192000000 10806201664 11228356608 1883099216 18.690 100 32 62 2 1897447424 5216048 9132160
14:31:20 9253 8192000000 10802547840 11227357184 1885352368 18.708 100 34 68 1 1901443296 5091936 10998992
14:31:38 9981 8192000000 10792209664 11229052928 1864957648 18.543 99 15 30 1 1875168384 5616880 4593856
14:31:57 11417 8192000000 10820127584 11242831872 1891969504 18.762 100 23 44 2 1905073040 4867984 8235552
14:32:28 42812 8192000000 10857446912 11280138240 1917029088 18.963 100 44 87 2 1936597392 5966480 13601824
14:33:28 97144 8192000000 10875337584 11308908544 1942351616 19.166 100 41 80 3 1968628336 14708416 11568304
14:35:14 26661 8192000000 10884480720 11314384896 1953760000 19.256 100 36 72 1 1978519984 14233408 10526576
14:35:48 3209 8192000000 10893873792 11318325248 1954974960 19.266 100 63 124 1 1986919008 13608240 18335808
14:36:03 6236 8192000000 10895957616 11319889920 1955338848 19.269 100 51 102 1 1983431696 13975344 14117504
14:36:17 5241 8192000000 10897063728 11326111744 1960859968 19.313 100 46 90 4 1987925520 14462352 12603200
14:36:43 30093 8192000000 10895148624 11323650048 1937513888 19.127 99 43 86 0 1969993984 20540112 11939984
14:37:20 6129 8192000000 10902581904 11333050368 1963183456 19.331 100 60 118 2 1998640048 17806528 17650064
14:37:46 8387 8192000000 10891854192 11327172608 1958610128 19.295 100 51 102 1 1990905184 17043728 15251328
14:38:05 2851 8192000000 10915018208 11334713344 1962486400 19.326 100 65 130 1 1998640448 16449168 19704880
14:38:16 3331 8192000000 10901905920 11327045632 1948118768 19.211 99 68 135 2 1985126832 17441376 19566688
14:38:30 13465 8192000000 10888320400 11311484928 1928806560 19.057 99 59 118 1 1965509888 19630416 17072912
14:38:51 7789 8192000000 10881775552 11309621248 1923837696 19.018 99 54 108 2 1960900112 21079424 15982992
14:39:17 10004 8192000000 10872579024 11307692032 1922978288 19.011 99 32 64 1 1949552736 17380784 9193664
14:39:35 14501 8192000000 10881276800 11311947776 1924382016 19.022 99 40 79 0 1948386800 12199808 11804976
14:39:59 2677 8192000000 10895798096 11323809792 1956703024 19.280 100 58 117 1 1987147712 12832000 17612688
14:40:09 2950 8192000000 10896138096 11314376704 1949799008 19.225 100 59 118 2 1978872656 12141392 16932256
14:40:19 2591 8192000000 10900604976 11321446400 1958072736 19.291 100 73 145 3 1992688752 13723696 20892320
14:40:29 4386 8192000000 10898157088 11318833152 1952583184 19.247 100 57 112 1 1983538432 14118128 16837120
14:40:42 4982 8192000000 10907290272 11329458176 1962494688 19.326 100 69 138 1 1998641696 15103168 21043840
14:40:59 8335 8192000000 10908101792 11333914624 1964558000 19.342 100 64 128 3 1998319824 15582112 18179712
14:41:16 4650 8192000000 10911058000 11332898816 1955709328 19.272 99 75 150 1 1994769808 17252672 21807808
14:41:28 13070 8192000000 10929559744 11347341312 1975223840 19.427 100 66 130 0 2012017936 18171264 18622832
14:41:48 2735 8192000000 10928908880 11351425024 1975397456 19.428 100 67 132 0 2011463648 17590528 18475664
14:41:58 2905 8192000000 10931282544 11348680704 1974648304 19.422 100 71 140 2 2015235632 20068496 20518832
14:42:11 5898 8192000000 10876945360 11298193408 1912886912 18.930 98 75 143 1 1954446832 19608800 21951120
14:42:26 4155 8192000000 10897115520 11319349248 1937476528 19.127 99 65 130 0 1978243344 21874288 18892528
14:42:38 2813 8192000000 10909927232 11317993472 1944006736 19.179 99 81 160 2 1990123296 22078736 24037824
14:42:48 5147 8192000000 10914165392 11337572352 1960529664 19.310 100 63 126 2 2003714064 24547008 18637392
14:43:01 8804 8192000000 10918803312 11342241792 1952386432 19.245 99 62 123 1 1996526368 26362624 17777312
14:43:20 2152 8192000000 10918033968 11321184256 1946199424 19.196 100 70 139 1 1993630176 26847184 20583568
14:43:29 2039 8192000000 10916326864 11325616128 1951047152 19.235 100 76 150 0 2003504960 28678544 23779264
14:43:38 1827 8192000000 10907568448 11315322880 1936954592 19.122 100 84 167 1 1991872400 29561456 25356352
14:43:46 2305 8192000000 10908198480 11312844800 1933444576 19.094 99 87 175 2 1991248992 31823264 25981152
14:43:55 2485 8192000000 10912042752 11324059648 1944829088 19.185 100 84 167 2 2002582592 33137920 24615584
14:44:05 3665 8192000000 10921283824 11334471680 1949833856 19.225 100 72 145 0 2005237072 33229056 22174160
14:44:16 3539 8192000000 10918244480 11327414272 1935661776 19.112 99 68 137 2 1988381296 32923712 19795808
14:44:28 8439 8192000000 10876396416 11283410944 1906459456 18.878 99 79 156 1 1960366336 30599280 23307600
14:44:43 4542 8192000000 10892557840 11302989824 1919074448 18.979 100 65 130 1 1974800448 36188080 19537920
14:44:56 3133 8192000000 10902924976 11317080064 1932318064 19.085 100 69 137 1 1992147216 39320720 20508432
14:45:08 9656 8192000000 10913838208 11333988352 1942876528 19.170 100 69 138 1 2001285824 37618928 20790368
14:45:26 2695 8192000000 10934506784 11342405632 1952351664 19.245 100 70 140 1 2010835792 36252224 22231904
14:45:36 2409 8192000000 10914932208 11324219392 1925944720 19.034 99 77 154 0 1986870928 37016272 23909936
14:45:46 4914 8192000000 10923463808 11337641984 1949642192 19.224 100 74 149 1 2011329472 38613552 23073728
14:45:58 1905 8192000000 10910179504 11315564544 1928363824 19.054 99 82 162 2 1993707200 40226992 25116384
14:46:08 4265 8192000000 10919053024 11331985408 1937226368 19.125 100 76 152 0 2001625872 40844352 23555152
14:46:19 2783 8192000000 10906685152 11312259072 1910150960 18.908 99 81 160 1 1976539456 40455392 25933104
14:46:28 2275 8192000000 10931874032 11336421376 1939504768 19.143 100 87 172 1 2006599520 41328240 25766512
14:46:38 3164 8192000000 10935806176 11339452416 1949900960 19.226 100 78 155 0 2016604944 42604272 24099712
14:46:48 4403 8192000000 10946083968 11353804800 1957450992 19.286 100 87 174 0 2029009312 44410640 27147680
14:47:01 4720 8192000000 10948408864 11359277056 1961037056 19.314 100 79 158 1 2029842736 43861168 24944512
14:47:13 1688 8192000000 10946374432 11356631040 1958335024 19.293 100 77 154 0 2028175376 44601472 25238880
14:47:22 3016 8192000000 10951624224 11365056512 1964087664 19.339 100 84 167 0 2037362368 46202144 27072560
14:47:32 2556 8192000000 10954760640 11361402880 1950375568 19.229 99 80 160 0 2022484768 46838112 25271088
14:47:41 2440 8192000000 10958789744 11368230912 1965131248 19.347 100 86 172 1 2042131552 49528272 27472032
14:47:50 5713 8192000000 10959361984 11372273664 1964641936 19.343 100 70 138 0 2036781856 49385152 22754768
14:48:09 2932 8192000000 10938637904 11358457856 1940294304 19.149 99 64 127 0 2008962864 47549872 21118688
14:48:20 3831 8192000000 10944447600 11361611776 1955848048 19.273 100 68 136 0 2025910400 48068928 21993424
14:48:32 3359 8192000000 10925963536 11336515584 1920836640 18.994 98 75 148 1 1991724624 48094384 22793600
14:48:43 4969 8192000000 10947672288 11363590144 1960606992 19.311 100 79 156 0 2032320032 47818240 23894800
14:48:57 2666 8192000000 10958807776 11380756480 1968716064 19.375 100 68 136 2 2040748336 49794624 22237648
14:49:08 6022 8192000000 10954425552 11386511360 1969297760 19.380 100 52 104 4 2041414528 55838224 16278544
14:49:21 8231 8192000000 10944909376 11378544640 1967665008 19.367 100 46 91 0 2030357824 48038784 14654032
14:49:45 5186 8192000000 10950913728 11366744064 1957958992 19.290 100 48 94 0 2018780128 45755600 15065536
14:49:57 6341 8192000000 10942833088 11376496640 1969851664 19.384 100 54 108 0 2035584704 48362896 17370144
14:50:16 4865 8192000000 10949097984 11379589120 1968860016 19.376 100 40 80 0 2027116768 45108816 13147936
14:50:27 8748 8192000000 10940837520 11378622464 1949786704 19.225 99 37 74 0 2009882512 46991008 13104800
14:50:46 3606 8192000000 10946731232 11366862848 1958587504 19.295 99 64 128 0 2028370592 49334144 20448944
14:50:58 2511 8192000000 10964765664 11380535296 1971199056 19.395 100 84 169 3 2048635888 50590768 26846064
14:51:07 5594 8192000000 10942974432 11379097600 1967278640 19.364 100 48 94 0 2031805184 48843520 15683024
14:51:22 1426 8192000000 10973425776 11386875904 1977489296 19.445 100 72 143 0 2053285168 52046944 23748928
14:51:30 7972 8192000000 10966778400 11400114176 1979642752 19.462 100 47 94 4 2050354208 55069024 15642432
14:51:49 6862 8192000000 10943751280 11376709632 1937241504 19.125 98 43 84 3 2006858864 54834960 14782400
14:52:07 16478 8192000000 10924629248 11364106240 1923051808 19.011 98 31 62 1 1988178240 54150928 10975504
14:52:38 15604 8192000000 10937663568 11376267264 1952610432 19.247 100 31 62 1 2013644064 50104672 10928960
14:53:02 25717 8192000000 10939789344 11378728960 1960269392 19.308 100 40 77 2 2021272288 48521616 12481280
14:53:42 11157 8192000000 10939556064 11373948928 1953129664 19.251 100 43 86 0 2019941488 52455600 14356224
14:54:03 12298 8192000000 10920659360 11379380224 1951100208 19.235 100 28 56 2 2013123072 51400256 10622608
14:54:56 29391 8192000000 10914170016 11363057664 1926226784 19.037 100 24 48 1 1993991168 58648640 9115744
14:55:32 18746 8192000000 10908105936 11363516416 1928194896 19.052 100 24 48 2 1998979360 60782160 10002304
14:55:57 21068 8192000000 10898997904 11350654976 1908794432 18.897 99 26 50 3 1972233088 54662976 8775680
14:56:27 29180 8192000000 10893684960 11355238400 1911896096 18.922 99 18 36 1 1971900976 53385824 6619056
14:57:20 58910 8192000000 10865468288 11328319488 1895029184 18.786 98 11 22 0 1921103424 22664336 3409904
14:58:28 120071 8192000000 10879416032 11346235392 1931087568 19.076 100 8 16 1 1948498688 15528544 1882576
15:00:38 52854 8192000000 10907729248 11342888960 1945318432 19.189 100 28 56 1 1961448656 8109136 8021088
15:01:38 113379 8192000000 10893575072 11342999552 1899687184 18.824 97 5 10 0 1910665440 10039440 938816
15:03:40 91288 8192000000 10928981168 11362111488 1966624736 19.359 100 31 62 0 1986503696 11261456 8617504
15:05:31 162963 8192000000 10885011232 11348647936 1898243712 18.812 96 13 26 0 1916868464 15495104 3129648
15:08:21 42379 8192000000 10892522288 11357544448 1970577216 19.390 100 23 46 0 1985933840 8876496 6480128
15:09:16 26748 8192000000 10931121168 11383300096 1984432448 19.500 100 38 74 3 2007329056 11987104 10909504
15:09:55 38953 8192000000 10910015136 11366612992 1963885728 19.337 99 44 86 1 1986988640 10132576 12970336
15:10:46 28553 8192000000 10915212704 11373158400 1982427456 19.484 100 30 60 1 2004151776 12981232 8743088
15:11:22 37003 8192000000 10898153024 11369824256 1969288976 19.380 99 24 48 1 1991785472 14812240 7684256
15:12:15 135673 8192000000 10903727088 11376304128 1960426352 19.309 99 18 36 0 1981257744 15309824 5521568
15:14:37 46292 8192000000 10926199552 11388563456 1969740064 19.383 99 16 32 1 1986982400 12693776 4548560
15:15:38 58643 8192000000 10901334592 11361951744 1944136864 19.180 98 12 25 1 1955745152 8304976 3303312
15:17:09 40746 8192000000 10908398000 11378741248 1988433360 19.531 100 31 62 2 2006333824 9888448 8012016
15:18:07 80662 8192000000 10917185840 11397922816 1973490256 19.413 99 16 32 1 1994440704 16439760 4510688
15:19:36 12933 8192000000 10937507088 11405303808 1998187360 19.608 100 34 70 2 2022424512 14305760 9931392
15:19:58 32536 8192000000 10928585200 11409956864 1994399376 19.579 100 25 50 1 2017083824 15908256 6776192
15:20:44 61663 8192000000 10907844624 11390525440 1936365616 19.118 97 15 30 0 1955693712 14772048 4556048
15:21:52 39303 8192000000 10911656336 11393142784 1970901232 19.393 99 7 14 0 1988082688 14616912 2564544
15:23:35 61494 8192000000 10883134416 11359809536 1933588000 19.096 98 20 40 3 1948755904 9090464 6077440
15:24:56 57816 8192000000 10860697648 11339845632 1874036496 18.617 95 14 28 0 1884372992 6539232 3797264
15:26:00 34483 8192000000 10866282704 11336445952 1914883728 18.946 98 14 29 0 1926232032 7361328 3986976
15:26:52 60222 8192000000 10890227664 11360423936 1913638992 18.936 98 19 39 1 1930252480 11531232 5082256
15:27:59 54468 8192000000 10866529936 11343716352 1880772704 18.671 96 20 40 0 1900409792 13648128 5988960
15:29:01 67635 8192000000 10873636784 11340271616 1874528576 18.621 96 13 26 2 1892218688 14269408 3420704
15:30:15 33516 8192000000 10889071696 11350614016 1932931360 19.090 99 28 57 0 1956085552 14697328 8456864
15:30:59 31228 8192000000 10885791664 11344154624 1911218096 18.916 98 38 76 2 1935992032 13782224 10991712
15:31:50 58223 8192000000 10876299632 11336228864 1870463408 18.588 96 19 38 2 1887590736 12456144 4671184
15:32:57 39466 8192000000 10861337200 11306881024 1838908336 18.332 95 24 46 1 1852790144 7607440 6274368
15:33:44 7191 8192000000 10888190400 11323068416 1938611776 19.136 100 68 135 0 1967889456 9081824 20195856
15:33:58 23673 8192000000 10893284928 11338522624 1944816512 19.185 100 66 131 1 1975494784 12902112 17776160
15:34:34 58931 8192000000 10872905376 11337449472 1880404560 18.668 97 21 42 1 1899081168 13075664 5600944
15:35:48 72500 8192000000 10814874784 11283587072 1720570640 17.357 89 12 24 1 1735911776 11984352 3356784
15:37:06 37946 8192000000 10852440736 11298721792 1842973968 18.365 97 28 55 1 1862054272 10333552 8746752
15:37:59 87595 8192000000 10843179216 11310604288 1875177200 18.626 98 13 26 0 1896325984 17677568 3471216
15:39:32 22136 8192000000 10874112864 11313414144 1906777120 18.881 99 25 50 1 1923131376 9497200 6857056
15:40:01 23120 8192000000 10892189760 11327574016 1940923296 19.154 100 61 122 1 1972483392 14757232 16802864
15:40:31 135364 8192000000 10853085920 11305758720 1855924368 18.470 96 38 76 1 1880821968 14121936 10775664
15:43:13 12620 8192000000 10876443008 11320082432 1928742944 19.057 100 34 69 1 1953622432 15416400 9463088
15:43:34 38792 8192000000 10837821968 11313827840 1911434656 18.918 99 28 56 1 1932485504 12696608 8354240
15:45:56 81968 8192000000 10851147776 11329863680 1914695232 18.944 99 12 24 1 1935956736 17536528 3724976
15:47:24 25793 8192000000 10869070128 11341262848 1935373168 19.110 100 17 34 1 1957332608 16275360 5684080
15:49:05 52664 8192000000 10858026640 11321675776 1889144384 18.739 98 16 31 0 1906790976 13119632 4526960
15:50:05 35148 8192000000 10888192208 11333668864 1919272928 18.981 99 28 56 1 1936886464 9524032 8089504
15:51:06 64378 8192000000 10893006944 11357356032 1948449584 19.214 100 23 47 1 1967051168 11957888 6643696
15:52:26 63648 8192000000 10905306080 11369668608 1964295520 19.340 100 16 31 2 1981634512 13219280 4119712
15:53:37 34212 8192000000 10909212160 11374227456 1964739744 19.344 100 27 54 1 1988874448 15582448 8552256
15:54:22 25585 8192000000 10909616304 11364278272 1954604656 19.263 99 37 74 1 1973668048 8738464 10324928
15:55:01 63283 8192000000 10876694784 11353694208 1923897120 19.018 98 15 30 2 1939117984 10718480 4502384
15:56:10 44791 8192000000 10907848592 11369676800 1973101984 19.410 100 33 66 0 1991233424 9336000 8795440
15:57:01 53060 8192000000 10910243184 11365220352 1966034176 19.354 100 42 84 1 1992033952 13449008 12550768
15:58:02 66203 8192000000 10889478064 11341099008 1877059008 18.641 96 18 36 0 1893494784 11290224 5145552
15:59:15 71367 8192000000 10906413888 11371589632 1960716688 19.312 100 26 52 1 1979076832 11114864 7245280
16:00:40 111467 8192000000 10893665792 11376828416 1930607312 19.072 98 12 24 1 1953827808 19477616 3742880
16:02:49 107082 8192000000 10847237248 11313123328 1824404384 18.214 93 14 28 1 1837371072 9545904 3420784
16:04:42 75037 8192000000 10854325808 11320520704 1868930960 18.576 96 25 50 1 1889046240 13427552 6687728
16:06:11 85679 8192000000 10866896992 11336196096 1919961152 18.987 99 10 19 1 1934179312 11534144 2684016
16:07:43 69013 8192000000 10849666464 11315978240 1914221200 18.941 98 13 26 0 1931488624 13494976 3772448
16:09:03 62734 8192000000 10867836800 11339804672 1911092624 18.915 98 16 32 0 1925906688 10387168 4426896
16:10:14 32145 8192000000 10870971680 11325214720 1890770288 18.752 97 21 42 3 1902620096 6124352 5725456
16:10:52 75384 8192000000 10888720144 11343519744 1909523632 18.903 98 28 56 1 1925109824 7862496 7723696
16:12:13 54860 8192000000 10881881184 11353444352 1934568640 19.103 99 23 47 0 1951067104 10027632 6470832
16:13:20 59488 8192000000 10878759408 11346243584 1916322672 18.957 98 20 40 0 1935997744 13716272 5958800
16:14:25 173649 8192000000 10873071168 11345350656 1804051152 18.047 92 22 44 1 1821538608 11624128 5863328
16:17:26 55064 8192000000 10848153984 11321716736 1843557264 18.370 95 7 14 0 1864398432 18879696 1961472
16:18:32 59997 8192000000 10887299584 11342102528 1885111264 18.706 97 25 50 0 1907538352 15186384 7240704
16:19:38 82868 8192000000 10869560480 11336269824 1869933888 18.584 96 14 28 0 1883392880 9481968 3977024
16:21:16 62769 8192000000 10865479456 11337388032 1934686640 19.104 100 21 42 1 1951695392 11510992 5497760
16:22:55 59877 8192000000 10858309504 11316146176 1844509344 18.377 95 15 30 0 1855128416 6574320 4044752
16:24:01 39599 8192000000 10859953536 11309572096 1844775632 18.380 95 42 84 3 1868190832 11835520 11579680
16:25:46 69683 8192000000 10789153088 11259535360 1817401984 18.156 96 7 14 0 1828885136 10134416 1348736
16:27:11 70434 8192000000 10821140640 11295633408 1878247088 18.651 99 12 24 1 1897850576 15735264 3868224
16:28:28 50233 8192000000 10834644304 11306721280 1891261168 18.756 99 10 20 1 1900393920 6080976 3051776
16:29:34 103045 8192000000 10841326432 11327094784 1926578304 19.040 100 14 28 2 1940109824 9706496 3825024
16:31:52 18400 8192000000 9091507152 9322770432 261205152 3.090 14 2 4 0 262993024 1660832 127040

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 11-12-2020 16:33:54 to 11-12-2020 16:34:25.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 149 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-12-2020 16:34:26 to 11-12-2020 16:34:28.

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          255406
MON$OLDEST_ACTIVE               255407
MON$OLDEST_SNAPSHOT             255407
MON$NEXT_TRANSACTION            255407
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                       2050016
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.33400 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33400 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33400 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Fri Dec 11 16:32:20 2020
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
--- end of diff output ---

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

11.12.20 16:34:29. 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-11 16:34:31 No severe PSQL-related problems occured
11.12.20 16:34:32. End of report.