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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17357972 kB
MemAvailable 31519916 kB
Buffers 0 kB
Cached 14358268 kB
SwapCached 2868 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.7
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-11-02 16:27:03
DTS_END                         2020-11-02 16:27:03.5860
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/58546
TRN_ID                          246463
ATT_ID                          656
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: 9397.08 16232 1127650
customer order: creation 187.77 313 22532
customer order: refuse 15.37 337 1844
order to supplier: creation 48.98 1224 5878
order to supplier: removal 3.38 91233 406
invoice (draft): creation 49.33 3313 5920
invoice (draft): removal 50.76 774 6091
invoice accept: apply 45.46 17447 5455
invoice accept: cancel 45.98 775 5518
customer reserve: creation 4133.83 175 496060
customer reserve: removal 4504.48 54 540537
realization accept: apply 89.03 173 10683
realization accept: cancel 85.80 100 10296
payment from customer: creation 63.11 107 7573
payment from customer: removal 6.23 69 747
payment to supplier: creation 51.97 111 6236
payment to supplier: removal 3.48 59 417
service: total inventory turnovers 4.42 1432 530
service: total monetary turnovers 6.85 27 822
service: aggregate perf. data 0.84 19030 101
service: refresh index statistics 0.03 187877 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-11-2020 16:29:25 to 02-11-2020 16:29:27.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6355
TEST_TIME 2 5408
TEST_TIME 3 4923
TEST_TIME 4 5632
TEST_TIME 5 6000
TEST_TIME 6 5912
TEST_TIME 7 6425
TEST_TIME 8 6086
TEST_TIME 9 6745
TEST_TIME 10 7357
TEST_TIME 11 7495
TEST_TIME 12 7777
TEST_TIME 13 8118
TEST_TIME 14 8465
TEST_TIME 15 8611
TEST_TIME 16 8957
TEST_TIME 17 9020
TEST_TIME 18 9449
TEST_TIME 19 9543
TEST_TIME 20 9691
TEST_TIME 21 10053
TEST_TIME 22 9966
TEST_TIME 23 10218
TEST_TIME 24 10270
TEST_TIME 25 9991
TEST_TIME 26 10167
TEST_TIME 27 10556
TEST_TIME 28 11035
TEST_TIME 29 11446
TEST_TIME 30 11447
TEST_TIME 31 11610
TEST_TIME 32 11360
TEST_TIME 33 11114
TEST_TIME 34 11015
TEST_TIME 35 10910
TEST_TIME 36 10973
TEST_TIME 37 10842
TEST_TIME 38 10721
TEST_TIME 39 10684
TEST_TIME 40 10576
TEST_TIME 41 10658
TEST_TIME 42 10729
TEST_TIME 43 10592
TEST_TIME 44 10562
TEST_TIME 45 10512
TEST_TIME 46 10424
TEST_TIME 47 10331
TEST_TIME 48 10209
TEST_TIME 49 10253
TEST_TIME 50 10309
TEST_TIME 51 10294
TEST_TIME 52 10167
TEST_TIME 53 10110
TEST_TIME 54 10070
TEST_TIME 55 10025
TEST_TIME 56 9993
TEST_TIME 57 9998
TEST_TIME 58 10040
TEST_TIME 59 10157
TEST_TIME 60 10166
TEST_TIME 61 10138
TEST_TIME 62 10146
TEST_TIME 63 10219
TEST_TIME 64 10244
TEST_TIME 65 10162
TEST_TIME 66 10236
TEST_TIME 67 10235
TEST_TIME 68 10286
TEST_TIME 69 10295
TEST_TIME 70 10300
TEST_TIME 71 10168
TEST_TIME 72 10116
TEST_TIME 73 10042
TEST_TIME 74 10028
TEST_TIME 75 9969
TEST_TIME 76 9910
TEST_TIME 77 9868
TEST_TIME 78 9779
TEST_TIME 79 9846
TEST_TIME 80 9787
TEST_TIME 81 9838
TEST_TIME 82 9853
TEST_TIME 83 9825
TEST_TIME 84 9800
TEST_TIME 85 9841
TEST_TIME 86 9863
TEST_TIME 87 9840
TEST_TIME 88 9830
TEST_TIME 89 9832
TEST_TIME 90 9912
TEST_TIME 91 9877
TEST_TIME 92 9915
TEST_TIME 93 9827
TEST_TIME 94 9791
TEST_TIME 95 9788
TEST_TIME 96 9724
TEST_TIME 97 9718
TEST_TIME 98 9666
TEST_TIME 99 9656
TEST_TIME 100 9663
TEST_TIME 101 9617
TEST_TIME 102 9631
TEST_TIME 103 9585
TEST_TIME 104 9576
TEST_TIME 105 9603
TEST_TIME 106 9625
TEST_TIME 107 9610
TEST_TIME 108 9668
TEST_TIME 109 9643
TEST_TIME 110 9653
TEST_TIME 111 9673
TEST_TIME 112 9642
TEST_TIME 113 9631
TEST_TIME 114 9676
TEST_TIME 115 9597
TEST_TIME 116 9556
TEST_TIME 117 9522
TEST_TIME 118 9516
TEST_TIME 119 9478
TEST_TIME 120 9401

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-11-2020 16:29:29 to 02-11-2020 16:29:32.

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 1585086 1585086 0 0.00 0 25627 6 0 0
doc_list_biud 1585085 1585085 0 0.00 0 32970 24 0 0
sp_add_invoice_to_stock 5568 5455 113 2.02 27 181832 17448 0 113
sp_cancel_adding_invoice 5518 5518 0 0.00 3 52020 775 0 0
sp_cancel_client_order 1844 1844 0 0.00 4 14224 337 0 0
sp_cancel_customer_reserve 540537 540537 0 0.00 1 29120 55 0 0
sp_cancel_pay_from_customer 747 747 0 0.00 3 3264 70 0 0
sp_cancel_pay_to_supplier 417 417 0 0.00 3 3793 60 0 0
sp_cancel_supplier_invoice 6102 6091 11 0.18 2 32999 774 0 11
sp_cancel_supplier_order 406 406 0 0.00 6 976372 91233 0 0
sp_cancel_write_off 10296 10296 0 0.00 1 28935 100 0 0
sp_client_order 22532 22532 0 0.00 4 17087 313 0 0
sp_customer_reserve 496060 496060 0 0.00 0 82605 176 0 0
sp_fill_shopping_cart 34323 34323 0 0.00 1 32119 40 0 0
sp_fill_shopping_cart_clo_res 496054 496054 0 0.00 0 17084 12 0 0
sp_get_clo_for_invoice 5449 5449 0 0.00 0 27223 311 0 0
sp_kill_cost_storno 16978 16978 0 0.00 0 7090 51 0 0
sp_kill_qstorno_ret_qs2qd 1097867 1097867 0 0.00 0 32957 30 0 0
sp_kill_qty_storno 580823 580823 0 0.00 0 32968 65 0 0
sp_lock_selected_doc 22229 22229 0 0.00 0 6937 5 0 0
sp_make_cost_storno 29941 29941 0 0.00 0 20004 49 0 0
sp_multiply_rows_for_pdistr 29940 29940 0 0.00 0 15070 31 0 0
sp_multiply_rows_for_qdistr 22532 22532 0 0.00 0 11871 133 0 0
sp_pay_from_customer 7573 7573 0 0.00 4 20011 108 0 0
sp_pay_to_supplier 6236 6236 0 0.00 4 11661 112 0 0
sp_payment_common 13809 13809 0 0.00 1 7877 25 0 0
sp_qd_handle_on_cancel_clo 1844 1844 0 0.00 0 14216 315 0 0
sp_qd_handle_on_invoice_upd_sts 10966 10966 0 0.00 0 23578 309 0 0
sp_qd_handle_on_reserve_upd_sts 10683 10683 0 0.00 0 14810 65 0 0
sp_reserve_write_off 10683 10683 0 0.00 6 14824 173 0 0
sp_supplier_invoice 5920 5920 0 0.00 6 74222 3314 0 0
sp_supplier_order 5878 5878 0 0.00 4 75961 1225 0 0
srv_aggregate_perf_data 101 101 0 0.00 2544 250489 19031 0 0
srv_fill_mon_cache_memory 171 171 0 0.00 1429 135385 30245 0 0
srv_find_qd_qs_mism 1075474 1075474 0 0.00 0 25622 5 0 0
srv_make_invnt_saldo 530 530 0 0.00 23 150850 1432 0 0
srv_make_money_saldo 822 822 0 0.00 1 1163 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 135725 268432 187878 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5456 5456 0 0.00 0 12551 173 0 0
t$perf-norm:sp_cancel_adding_invoice 424 424 0 0.00 0 10579 125 0 0
t$perf-norm:sp_cancel_client_order 1844 1844 0 0.00 0 10385 19 0 0
t$perf-norm:sp_cancel_customer_reserve 767 767 0 0.00 0 1787 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 747 747 0 0.00 0 2333 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 417 417 0 0.00 0 5335 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 447 447 0 0.00 0 644 10 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 24185 1549 0 0
t$perf-norm:sp_cancel_write_off 1046 1046 0 0.00 0 3642 14 0 0
t$perf-norm:sp_client_order 22532 22532 0 0.00 0 14031 20 0 0
t$perf-norm:sp_customer_reserve 1059 1059 0 0.00 0 3636 14 0 0
t$perf-norm:sp_pay_from_customer 7573 7573 0 0.00 0 7871 12 0 0
t$perf-norm:sp_pay_to_supplier 6236 6236 0 0.00 0 14078 17 0 0
t$perf-norm:sp_reserve_write_off 10683 10683 0 0.00 0 11381 15 0 0
t$perf-norm:sp_supplier_invoice 5920 5920 0 0.00 0 12395 23 0 0
t$perf-norm:sp_supplier_order 5878 5878 0 0.00 0 8711 19 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 1376 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 171 171 0 0.00 0 797 8 0 0
t$perf-norm:srv_make_invnt_saldo 530 530 0 0.00 0 1130 19 0 0
t$perf-norm:srv_make_money_saldo 822 822 0 0.00 0 3682 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 12 5 0 0
v_add_invoice_to_stock 11122 10896 226 2.03 0 8496 17 0 226
v_all_customers 40656 40656 0 0.00 0 16 1 0 0
v_all_suppliers 32456 32456 0 0.00 0 17 1 0 0
v_all_wares 45064 45064 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 848 848 0 0.00 0 1072 7 0 0
v_cancel_client_order 3688 3688 0 0.00 0 2476 4 0 0
v_cancel_customer_prepayment 1494 1494 0 0.00 0 1575 6 0 0
v_cancel_customer_reserve 1534 1534 0 0.00 0 861 3 0 0
v_cancel_payment_to_supplier 834 834 0 0.00 0 1263 5 0 0
v_cancel_supplier_invoice 916 894 22 2.40 0 948 15 0 22
v_cancel_supplier_order 812 812 0 0.00 0 523 3 0 0
v_cancel_write_off 2092 2092 0 0.00 0 2016 14 0 0
v_max_id_clo_ord 5876 5876 0 0.00 0 4138 2 0 0
v_max_id_clo_res 1059 1059 0 0.00 0 2358 14 0 0
v_max_id_ord_sup 5915 5915 0 0.00 0 6492 5 0 0
v_max_non_paid_invoice 1799 1799 0 0.00 0 332 2 0 0
v_max_non_paid_realizn 4076 4076 0 0.00 0 4133 4 0 0
v_min_id_clo_ord 5876 5876 0 0.00 0 10598 6 0 0
v_min_id_clo_res 1059 1059 0 0.00 0 3618 12 0 0
v_min_id_ord_sup 5915 5915 0 0.00 0 10513 8 0 0
v_min_non_paid_invoice 6236 6236 0 0.00 0 6513 15 0 0
v_min_non_paid_realizn 7573 7573 0 0.00 0 7159 17 0 0
v_our_firm 11402 11402 0 0.00 0 14 1 0 0
v_reserve_write_off 21366 21366 0 0.00 0 3617 4 0 0
x_lock_depdocs_on_canc_invoice 11162 11162 0 0.00 0 10078 102 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 16438 422 0 0
x_make_qstorno_1000_1200 5878 5878 0 0.00 2 75899 1142 0 0
x_make_qstorno_1200_2000 5920 5920 0 0.00 3 70023 3168 0 0
x_make_qstorno_2100_3300 496060 496060 0 0.00 0 82604 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-11-2020 16:29:33 to 02-11-2020 16:29:37.

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
13:57:06 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:13 27849 8192000000 10301466144 10610196480 973856304 10.624 73 60 120 0 996522544 2888752 19777488
13:57:48 40594 8192000000 10371577920 10690863104 1406243088 14.651 100 86 172 1 1440354496 5946352 28165056
13:58:40 24234 8192000000 10412954528 10739093504 1457361440 15.103 100 89 178 0 1493694144 7122736 29209968
13:59:14 22429 8192000000 10430553248 10759237632 1482188400 15.321 100 86 172 0 1517802832 7916928 27697504
13:59:45 14172 8192000000 10441437584 10773028864 1500570160 15.481 100 94 188 0 1538598672 8199856 29828656
14:00:13 15617 8192000000 10454468208 10785853440 1507392688 15.541 100 93 187 1 1545177120 8678224 29106208
14:00:38 18629 8192000000 10468441552 10804490240 1518937296 15.641 100 89 179 0 1555914496 9162256 27814944
14:01:15 20328 8192000000 10497425568 10840412160 1543603680 15.855 100 87 174 1 1580635968 10309680 26722608
14:01:45 18284 8192000000 10509595984 10862469120 1569448560 16.078 100 78 156 1 1603310368 10375648 23486160
14:02:13 10529 8192000000 10536926048 10889863168 1593980768 16.288 100 79 158 0 1628393472 10774640 23638064
14:02:33 13152 8192000000 10562598816 10921885696 1619324144 16.504 100 80 160 0 1654119328 11161872 23633312
14:02:57 12930 8192000000 10581378704 10944729088 1642527440 16.701 100 76 152 2 1676657392 11496832 22633120
14:03:17 9508 8192000000 10596387344 10964656128 1663751616 16.881 100 77 154 0 1697519872 11123760 22644496
14:03:34 9191 8192000000 10613120176 10984960000 1678447792 17.004 100 75 150 1 1712062160 11757616 21856752
14:03:52 8852 8192000000 10627070304 11000262656 1690870432 17.109 100 77 155 1 1725125072 11920080 22334560
14:04:12 6123 8192000000 10645819520 11019079680 1711805456 17.284 100 78 156 0 1746275792 12590832 21879504
14:04:27 5874 8192000000 10665956736 11039879168 1727236224 17.412 100 80 158 2 1762044528 12643680 22164624
14:04:40 8010 8192000000 10679387840 11055595520 1738578992 17.507 100 76 152 2 1773113904 12730768 21804144
14:04:55 6962 8192000000 10680894704 11062120448 1751489344 17.614 100 81 160 1 1786726800 13082640 22154816
14:05:09 4625 8192000000 10699799408 11079921664 1762819072 17.708 100 86 172 1 1801186608 14617984 23749552
14:05:21 12662 8192000000 10703023680 11087572992 1768136880 17.752 100 74 148 1 1802412256 14051216 20224160
14:05:41 6633 8192000000 10726426720 11110797312 1783775984 17.881 100 81 162 0 1819973696 13715600 22482112
14:05:55 4846 8192000000 10739946480 11123339264 1800215264 18.016 100 87 171 0 1838573904 14083024 24275616
14:06:06 4522 8192000000 10754127984 11135885312 1806851392 18.070 100 82 164 1 1843501168 13851664 22798112
14:06:18 3029 8192000000 10756301936 11141685248 1814806944 18.135 100 85 171 1 1853257696 14288352 24162400
14:06:27 3616 8192000000 10756911264 11145158656 1818390672 18.165 100 82 164 2 1855732304 13435744 23905888
14:06:38 3161 8192000000 10772481488 11157696512 1827064480 18.235 100 90 180 1 1865832368 14030528 24737360
14:06:47 3032 8192000000 10774831456 11161325568 1835505120 18.304 100 91 183 1 1874992768 13818752 25668896
14:06:57 2614 8192000000 10780581504 11169902592 1836232544 18.310 100 80 160 1 1873443744 14053952 23157248
14:07:08 2740 8192000000 10788930000 11172773888 1841933072 18.357 100 86 172 2 1880398176 12768928 25696176
14:07:17 2382 8192000000 10779301888 11170811904 1848499632 18.410 100 80 159 1 1883321904 12435792 22386480
14:07:26 2534 8192000000 10783402944 11176316928 1850485744 18.426 100 79 157 3 1884266832 11943648 21837440
14:07:36 2948 8192000000 10793521168 11183120384 1853952336 18.454 100 88 177 0 1889811408 11220752 24638320
14:07:45 2270 8192000000 10807707328 11193630720 1860572608 18.508 100 93 183 1 1899136896 13091600 25472688
14:07:54 1650 8192000000 10814866064 11200794624 1865460112 18.548 100 93 185 4 1906094112 14498176 26135824
14:08:02 2480 8192000000 10805149936 11194564608 1865527056 18.548 100 89 179 1 1905200064 14348672 25324336
14:08:11 2033 8192000000 10806667792 11199123456 1868126480 18.569 100 90 181 1 1907547536 14041792 25379264
14:08:19 1431 8192000000 10816650304 11206549504 1874948128 18.624 100 95 190 1 1914591744 13525456 26118160
14:08:27 1188 8192000000 10819824032 11208556544 1874718464 18.622 100 95 191 0 1915711296 14263104 26729728
14:08:34 1688 8192000000 10821212528 11213209600 1874512352 18.621 100 85 170 2 1912613040 14065248 24035440
14:08:43 21915 8192000000 10817849280 11210113024 1873917952 18.616 100 63 127 1 1901045280 9351312 17776016
14:09:12 19434 8192000000 10811229424 11209867264 1874730304 18.623 100 67 134 0 1904759520 11099072 18930144
14:09:37 1302 8192000000 10829042736 11219156992 1884854432 18.704 100 93 186 0 1924552576 12542016 27156128
14:09:45 5362 8192000000 10804290992 11218817024 1879053088 18.657 100 56 112 0 1905627744 10538016 16036640
14:09:57 1923 8192000000 10828853920 11232296960 1888958336 18.737 100 75 150 1 1921564368 11183504 21422528
14:10:06 4778 8192000000 10802078976 11221991424 1883223328 18.691 100 42 84 1 1905060272 9488576 12348368
14:10:19 3610 8192000000 10804578160 11223461888 1887179344 18.723 100 49 99 1 1909560304 7554544 14826416
14:10:34 4939 8192000000 10792115600 11222532096 1886296000 18.716 100 39 79 0 1905697088 8282768 11118320
14:10:46 5486 8192000000 10808139184 11225837568 1887891264 18.729 100 31 58 2 1900899328 5278944 7729120
14:10:58 6184 8192000000 10804891296 11232227328 1892776672 18.768 100 35 70 2 1913691088 11367536 9546880
14:11:10 5373 8192000000 10809383360 11229933568 1894919360 18.785 100 38 76 2 1913029248 7160800 10949088
14:11:22 5055 8192000000 10806396064 11235491840 1893766864 18.776 100 25 49 2 1906946432 6857856 6321712
14:11:35 4365 8192000000 10816909776 11241320448 1900354288 18.829 100 41 82 3 1920692768 8462352 11876128
14:11:46 9033 8192000000 10809193952 11239358464 1901829728 18.841 100 16 31 0 1913497472 6478208 5189536
14:12:04 6742 8192000000 10811467936 11243958272 1901214048 18.836 100 25 49 0 1914558560 5197856 8146656
14:12:18 9593 8192000000 10821344240 11248050176 1903274944 18.853 100 22 44 1 1915018608 5485168 6258496
14:12:34 3735 8192000000 10826131344 11246538752 1905354800 18.869 100 33 67 0 1921342048 6885472 9101776
14:12:45 10733 8192000000 10805772784 11243347968 1904848480 18.865 100 22 44 2 1921833280 10598352 6386448
14:13:06 39291 8192000000 10836663504 11254972416 1905193952 18.868 100 24 46 3 1917522768 5024432 7304384
14:14:01 21078 8192000000 10864538544 11266449408 1915258960 18.949 100 70 140 0 1942396608 6190672 20946976
14:14:29 4985 8192000000 10839265968 11267612672 1915540400 18.951 100 50 100 0 1940153968 11075536 13538032
14:14:41 6149 8192000000 10824777600 11255906304 1893469424 18.774 99 37 74 1 1910361392 6517904 10374064
14:14:54 7405 8192000000 10824032688 11258253312 1908601968 18.895 100 23 46 3 1922736032 7227696 6906368
14:15:11 5357 8192000000 10837013072 11263422464 1912768560 18.929 100 39 78 0 1931975312 8169312 11037440
14:15:23 8148 8192000000 10822292080 11259678720 1913924384 18.938 100 26 52 1 1927859264 7156048 6778832
14:15:38 10053 8192000000 10826435744 11262648320 1911052944 18.915 100 21 42 0 1923377440 6638368 5686128
14:15:55 3554 8192000000 10831007808 11263627264 1915711728 18.952 100 46 92 1 1936284624 7309120 13263776
14:16:06 5221 8192000000 10839452848 11270590464 1916230688 18.957 100 28 56 1 1930099568 5400752 8468128
14:16:17 17602 8192000000 10841964272 11272175616 1914023328 18.939 100 23 44 4 1925324080 5316112 5984640
14:16:41 32067 8192000000 10859874384 11276947456 1922523072 19.007 100 47 94 1 1941705008 6510032 12671904
14:17:19 12683 8192000000 10836386320 11274670080 1922534416 19.007 100 23 48 1 1935807936 6621344 6652176
14:17:39 6569 8192000000 10799215040 11229605888 1843065696 18.366 97 30 60 0 1857901280 6816192 8019392
14:17:53 7216 8192000000 10818374720 11247005696 1884344640 18.700 99 33 65 2 1900393472 6529776 9519056
14:18:06 4804 8192000000 10792903664 11224064000 1844133488 18.374 97 30 60 2 1859347712 6644800 8569424
14:18:19 5353 8192000000 10745623056 11175550976 1757289808 17.662 94 28 56 3 1771548752 6744880 7514064
14:18:33 4677 8192000000 10773611984 11194224640 1852462608 18.442 100 35 70 1 1870024944 8098576 9463760
14:18:46 9533 8192000000 10769897248 11202162688 1828724496 18.249 98 24 48 2 1841338368 5715792 6898080
14:19:05 6428 8192000000 10739696416 11155578880 1716065776 17.319 92 33 67 2 1731651440 5266240 10319424
14:19:20 5652 8192000000 10745399888 11161034752 1789770896 17.930 98 21 42 3 1801708256 5207344 6730016
14:19:35 10261 8192000000 10716993600 11134201856 1743891248 17.551 96 20 40 0 1754505920 5112240 5502432
14:19:52 8674 8192000000 10711735600 11132317696 1713197984 17.295 94 18 34 1 1723022736 4652928 5171824
14:20:08 8670 8192000000 10703667536 11118194688 1770759360 17.773 98 27 54 1 1784675616 5446912 8469344
14:20:25 13060 8192000000 10718058688 11134775296 1740054704 17.519 96 19 37 0 1754533296 9246816 5231776
14:20:46 66011 8192000000 10732000304 11157561344 1769017088 17.759 97 32 63 1 1783514016 5536464 8960464
14:22:01 14237 8192000000 10709997408 11131551744 1715564080 17.315 94 20 40 0 1726642368 5848144 5230144
14:22:24 6283 8192000000 10702951312 11124801536 1789662016 17.929 99 31 62 0 1805252720 6885504 8705200
14:22:38 8911 8192000000 10722787248 11142221824 1784696864 17.888 98 26 52 1 1798739552 5940544 8102144
14:22:55 4565 8192000000 10730844176 11146010624 1808597856 18.084 100 38 76 1 1827229552 6047984 12583712
14:23:06 7313 8192000000 10736512336 11160317952 1820742032 18.184 100 29 58 3 1834388944 5552496 8094416
14:23:20 8219 8192000000 10732597168 11163811840 1793718400 17.962 98 23 46 1 1805721600 5284528 6718672
14:23:35 6812 8192000000 10756073488 11182354432 1839594592 18.338 100 33 66 1 1854938432 5802944 9540896
14:23:49 6977 8192000000 10783343072 11189579776 1846429760 18.393 100 31 58 3 1860018288 5041728 8546800
14:24:02 4416 8192000000 10762924144 11185766400 1848843184 18.413 100 22 44 0 1861616496 5434864 7338448
14:24:13 6899 8192000000 10765185904 11190542336 1852339088 18.441 100 21 41 1 1863811728 5491552 5981088
14:24:28 11359 8192000000 10773691280 11197734912 1855236768 18.465 100 16 33 1 1864586048 4904688 4444592
14:24:49 5458 8192000000 10775904080 11203289088 1859536832 18.500 100 32 64 1 1878944992 10030432 9377728
14:25:00 8281 8192000000 10773828672 11200221184 1858917376 18.495 100 22 42 3 1870364880 5773440 5674064
14:25:16 7825 8192000000 10777298480 11202613248 1860717136 18.509 100 17 34 4 1871518352 5287120 5514096
14:25:30 14691 8192000000 10782639888 11209756672 1866133248 18.553 100 38 75 0 1882626320 5197504 11295568
14:25:51 57397 8192000000 10781075312 11208065024 1866704112 18.558 100 41 81 1 1883814224 5023744 12086368
14:26:57 26847 8192000000 10785635632 11214008320 1868581200 18.573 100 32 64 1 1884244880 6629424 9034256
14:27:33 14430 8192000000 10820078768 11238379520 1890170512 18.747 100 51 101 1 1910962800 6025312 14766976
14:27:56 23868 8192000000 10833362800 11252256768 1905430128 18.870 100 45 91 1 1925429728 7716592 12283008
14:28:27 4689 8192000000 10852794400 11264499712 1914008096 18.939 100 65 131 0 1940979520 8643696 18327728
14:28:44 20667 8192000000 10838397312 11269763072 1916505696 18.959 100 35 70 1 1934640192 8333408 9801088
14:29:11 12575 8192000000 10866508256 11288707072 1927702848 19.049 100 51 102 3 1953044400 11223664 14117888
14:29:37 14268 8192000000 10878294544 11297218560 1939554336 19.143 100 57 115 1 1969792112 13347840 16889936
14:30:02 8173 8192000000 10873433584 11294691328 1939561552 19.143 100 58 115 1 1970459712 14317680 16580480
14:30:18 27870 8192000000 10878693056 11298357248 1922612240 19.008 99 59 118 1 1955556288 16222144 16721904
14:31:01 13026 8192000000 10877454032 11300798464 1933602560 19.096 100 48 96 0 1966135696 19222560 13310576
14:31:37 30067 8192000000 10878231776 11311820800 1943505360 19.175 100 44 88 0 1971352240 14743904 13102976
14:32:17 14093 8192000000 10891594432 11315380224 1950996752 19.234 100 44 85 1 1979477520 16131504 12349264
14:32:50 4718 8192000000 10904958896 11328860160 1960937168 19.313 100 60 120 2 1994920976 16024432 17959376
14:33:05 5809 8192000000 10899207456 11324301312 1956237312 19.276 100 49 98 0 1988208064 17299728 14671024
14:33:22 17158 8192000000 10899343792 11333529600 1959970144 19.306 100 47 94 1 1995334624 20849968 14514512
14:33:47 19677 8192000000 10915227728 11345838080 1965574384 19.350 100 40 79 0 1998842784 20959440 12308960
14:34:14 6921 8192000000 10911949040 11343282176 1969508720 19.382 100 41 82 1 2003787424 21170416 13108288
14:34:30 8021 8192000000 10920418064 11350769664 1973088640 19.410 100 54 106 1 2010168368 20899264 16180464
14:34:48 31831 8192000000 10917903792 11355553792 1974487440 19.421 100 42 84 1 2009796208 21964352 13344416
14:35:29 26145 8192000000 10925229968 11367768064 1980774464 19.471 100 44 88 2 2018793552 24658928 13360160
14:36:09 19880 8192000000 10933187360 11375390720 1986295904 19.515 100 41 82 2 2018818272 19899488 12622880
14:36:38 8513 8192000000 10944133856 11375136768 1990645856 19.549 100 53 105 1 2029509600 22299104 16564640
14:36:55 5348 8192000000 10957104944 11383619584 1994670048 19.581 100 56 110 0 2033007120 22620128 15716944
14:37:08 5491 8192000000 10954510112 11379314688 1996250928 19.593 100 67 132 1 2038150544 22242240 19657376
14:37:20 3785 8192000000 10960837344 11383119872 1999645648 19.620 100 72 143 2 2043380768 23086992 20648128
14:37:31 2499 8192000000 10971694256 11391303680 2008885856 19.693 100 87 174 0 2058472016 24521824 25064336
14:37:41 2529 8192000000 10977964304 11393634304 2007630496 19.683 100 85 168 2 2057754288 24973856 25149936
14:37:50 1819 8192000000 10969680976 11388035072 2008381936 19.689 100 94 185 1 2061782512 25316272 28084304
14:37:58 5276 8192000000 10958233136 11383472128 1996807008 19.598 100 74 147 1 2043803696 24942880 22053808
14:38:10 7176 8192000000 10940252512 11363897344 1980195456 19.466 100 70 140 2 2026842608 25925408 20721744
14:38:27 2288 8192000000 10914142224 11332665344 1928656384 19.056 97 70 139 0 1975761136 26033424 21071328
14:38:38 1781 8192000000 10952260480 11371995136 1990818064 19.550 100 79 155 2 2038773920 23919008 24036848
14:38:47 3878 8192000000 10957669424 11368394752 1982750720 19.486 100 78 155 1 2031447616 24603072 24093824
14:38:58 4887 8192000000 10937421184 11356205056 1968238672 19.371 99 69 137 1 2014984688 26534608 20211408
14:39:09 3579 8192000000 10933761760 11342364672 1951037600 19.235 99 91 181 3 2004061104 26150048 26873456
14:39:20 4512 8192000000 10954330800 11363729408 1978309680 19.451 100 88 175 0 2031911104 27147264 26454160
14:39:31 1977 8192000000 10948529728 11357249536 1974588272 19.422 100 94 191 1 2029762064 27228496 27945296
14:39:40 2097 8192000000 10934109392 11349217280 1967837888 19.368 100 81 160 3 2018355600 26264592 24253120
14:39:48 3636 8192000000 10935095488 11353010176 1972906752 19.409 100 75 147 4 2021810256 27192256 21711248
14:40:00 2029 8192000000 10948202128 11360972800 1978392688 19.452 100 95 190 0 2037163200 29927136 28843376
14:40:10 7825 8192000000 10938250784 11354570752 1957744080 19.288 99 75 150 2 2010607024 30471984 22390960
14:40:24 4666 8192000000 10945440928 11359698944 1958196672 19.292 99 80 158 1 2013800592 30932832 24671088
14:40:36 1739 8192000000 10949671696 11366440960 1976227264 19.435 100 80 160 2 2031857296 30972176 24657856
14:40:45 6548 8192000000 10935566848 11360333824 1973282496 19.411 100 69 137 1 2022984800 29237920 20464384
14:40:58 5535 8192000000 10948986992 11365666816 1971569824 19.398 100 69 139 0 2023505168 30889840 21045504
14:41:11 2404 8192000000 10946332784 11368169472 1978672544 19.454 100 72 144 1 2029135360 28144704 22318112
14:41:22 13946 8192000000 10925050752 11354361856 1968741104 19.375 100 68 136 1 2017173552 27612320 20820128
14:41:44 2754 8192000000 10938771568 11349336064 1949217552 19.220 99 87 174 3 2006264560 30953696 26093312
14:41:53 1694 8192000000 10950434224 11355693056 1966500368 19.358 100 89 174 2 2025695808 32266304 26929136
14:42:01 3164 8192000000 10959527296 11365945344 1973271776 19.411 100 87 173 1 2031368176 32684976 25411424
14:42:12 1428 8192000000 10952101088 11360501760 1970113584 19.386 100 81 163 0 2027653904 32653856 24886464
14:42:23 2122 8192000000 10902143120 11312316416 1926277280 19.037 98 79 158 0 1981867488 31903824 23686384
14:42:34 1459 8192000000 10931538752 11347386368 1960509184 19.310 100 81 162 0 2018145904 32826960 24809760
14:42:42 2533 8192000000 10942377248 11351486464 1959476352 19.302 100 87 171 1 2019028464 33971344 25580768
14:42:51 2681 8192000000 10934365728 11347423232 1955292624 19.269 100 75 149 0 2012736064 34435456 23007984
14:43:01 2556 8192000000 10940211936 11352694784 1965060432 19.346 100 81 162 0 2025705120 35928672 24716016
14:43:10 3291 8192000000 10943567072 11354750976 1958588608 19.295 100 82 162 1 2019493776 36531120 24374048
14:43:20 2609 8192000000 10951014656 11362721792 1967638896 19.367 100 86 173 2 2031800656 38119696 26042064
14:43:29 3497 8192000000 10950788448 11363471360 1965891248 19.353 100 78 156 3 2029254784 39866064 23497472
14:43:41 5010 8192000000 10937500896 11367100416 1966676080 19.359 100 59 118 0 2024691568 40272592 17742896
14:43:55 7990 8192000000 10933887376 11365990400 1969643792 19.383 100 49 96 1 2019362768 35014048 14704928
14:44:14 4826 8192000000 10953791296 11378118656 1964030480 19.338 99 59 116 0 2018928672 36664288 18233904
14:44:25 11820 8192000000 10927414336 11359354880 1933592544 19.096 98 56 113 1 1997900720 46606528 17701648
14:44:46 4586 8192000000 10934965072 11350581248 1949232512 19.220 99 71 143 1 2010771248 39273616 22265120
14:44:58 2670 8192000000 10910583776 11322826752 1926948768 19.042 99 83 166 1 1988800192 36362432 25488992
14:45:08 2886 8192000000 10933063424 11350380544 1957068944 19.283 100 87 173 2 2025166160 41152576 26944640
14:45:17 6716 8192000000 10928396016 11346522112 1960012288 19.306 100 70 140 1 2014428320 33261424 21154608
14:45:32 6754 8192000000 10928041264 11357061120 1962890240 19.329 100 53 105 1 2011390432 31716928 16783264
14:46:04 12794 8192000000 10916056336 11357827072 1944824928 19.185 99 28 56 1 1986445264 32355744 9264592
14:46:27 4867 8192000000 10923339248 11341234176 1931351712 19.078 98 64 127 2 1986193776 33278064 21564000
14:46:39 3313 8192000000 10949102016 11364503552 1967728432 19.367 100 68 138 2 2020029808 30271168 22030208
14:46:51 3975 8192000000 10946679824 11372191744 1973029328 19.409 100 65 126 0 2024754240 31326944 20397968
14:47:04 2939 8192000000 10967208704 11380555776 1978428960 19.452 100 82 164 1 2036290976 32964976 24897040
14:47:13 8482 8192000000 10952114176 11379150848 1976972832 19.441 100 62 124 0 2029143920 33152544 19018544
14:47:29 8768 8192000000 10932046672 11375792128 1976123360 19.434 100 46 92 0 2024310032 33329472 14857200
14:47:47 12269 8192000000 10928081680 11371188224 1962740560 19.328 100 38 74 3 2008538640 33563168 12234912
14:48:16 2081 8192000000 10959301696 11366105088 1965616160 19.351 100 88 175 1 2031219168 38484960 27118048
14:48:25 6421 8192000000 10931493840 11362066432 1964566832 19.342 100 59 118 1 2018370544 35308016 18495696
14:48:38 8004 8192000000 10889250544 11325599744 1882422944 18.685 96 43 85 0 1930419488 33916288 14080256
14:48:53 13894 8192000000 10882872240 11327258624 1911185920 18.916 99 35 70 3 1957720144 34793936 11740288
14:49:13 22184 8192000000 10904318768 11343663104 1947050528 19.203 100 45 90 3 1991144448 29586976 14506944
14:49:45 6094 8192000000 10910007936 11344334848 1946986288 19.202 100 47 94 1 1995352064 32868832 15496944
14:50:03 9291 8192000000 10900638960 11345997824 1930621296 19.072 99 32 64 2 1972389296 31028720 10739280
14:50:23 13692 8192000000 10892178784 11331072000 1890912032 18.753 97 27 53 1 1929574304 29950784 8711488
14:50:52 24348 8192000000 10879715520 11324256256 1885357104 18.708 97 26 50 2 1924200096 30472336 8370656
14:51:30 18383 8192000000 10887171872 11330457600 1924250992 19.021 100 23 46 2 1967999280 35772960 7975328
14:52:11 15784 8192000000 10889532528 11338833920 1917981024 18.971 99 25 50 2 1964347664 38271072 8095568
14:52:33 15366 8192000000 10891802352 11332919296 1932838768 19.090 100 24 48 3 1978207392 36851504 8517120
14:53:15 23231 8192000000 10902590928 11346915328 1914805136 18.945 99 27 54 1 1969583696 44501856 10276704
14:53:57 23775 8192000000 10897975632 11342401536 1913221296 18.932 99 24 48 0 1967075808 45020736 8833776
14:54:28 24123 8192000000 10897825856 11349770240 1929956848 19.067 100 22 44 1 1987603376 49789936 7856592
14:54:59 36985 8192000000 10859785904 11313852416 1901710832 18.840 99 18 36 1 1945962352 37470032 6781488
14:56:11 35336 8192000000 10869352960 11311124480 1916148544 18.956 100 14 28 1 1942104944 21587040 4369360
14:56:54 49457 8192000000 10878314640 11344207872 1938452256 19.134 100 24 49 1 1963110640 17655408 7002976
14:57:50 98076 8192000000 10868651904 11313278976 1912199664 18.924 98 14 29 0 1942981680 26793712 3988304
15:00:42 64305 8192000000 10875187760 11322941440 1884354544 18.700 96 43 84 1 1903030800 6666752 12009504
15:01:53 67211 8192000000 10894705072 11347677184 1935100576 19.108 99 36 72 0 1958771168 14017984 9652608
15:03:11 135385 8192000000 10900335488 11341770752 1898426480 18.814 97 26 52 0 1920173072 14483872 7262720
15:05:34 20304 8192000000 10894710288 11343581184 1960239744 19.308 100 32 64 2 1980901456 11798176 8863536
15:06:11 87984 8192000000 10917014720 11367051264 1960430192 19.309 99 19 38 0 1975184448 9569840 5184416
15:07:48 58135 8192000000 10908113408 11356540928 1956640816 19.279 99 40 80 2 1978890432 9984224 12265392
15:08:56 12941 8192000000 10925359776 11366141952 1978270672 19.451 100 65 131 1 2005615840 8962624 18382544
15:09:17 25571 8192000000 10895278384 11364827136 1974531888 19.421 100 41 82 2 1995913600 10109792 11271920
15:09:57 31941 8192000000 10903161760 11368976384 1983663456 19.494 100 15 30 1 1994297056 6579344 4054256
15:10:37 90262 8192000000 10894072032 11369697280 1947771264 19.209 98 15 31 0 1962478640 10195712 4511664
15:12:14 38988 8192000000 10903077504 11373776896 1972222800 19.403 100 7 14 1 1983840448 9639168 1978480
15:12:59 33290 8192000000 10902647696 11373547520 1966904448 19.361 99 21 39 2 1984884816 12119312 5861056
15:13:42 42714 8192000000 10900479904 11375935488 1973928608 19.417 100 13 26 0 1990112624 12748704 3435312
15:14:31 52117 8192000000 10910155728 11368067072 1944592128 19.183 98 29 57 1 1971218688 17591456 9035104
15:15:35 105052 8192000000 10880519056 11371151360 1946297168 19.197 99 18 36 1 1972937312 21112848 5527296
15:17:39 3399 8192000000 10896986400 11368165376 1971439920 19.397 100 20 40 1 1988269632 10832400 5997312
15:17:49 25086 8192000000 10870690848 11350142976 1957599664 19.287 100 13 26 0 1969968912 8740032 3629216
15:18:21 58537 8192000000 10890956432 11364925440 1955250704 19.268 99 13 26 0 1967708128 9016080 3441344
15:20:15 27340 8192000000 10862550512 11346579456 1922238016 19.005 98 6 12 0 1931846272 8134944 1473312
15:20:49 81747 8192000000 10875293984 11359916032 1945496224 19.191 99 12 24 0 1957415456 8314880 3604352
15:22:17 36677 8192000000 10870451648 11340140544 1900862528 18.833 97 8 16 0 1911307504 8371056 2073920
15:23:26 45708 8192000000 10909348080 11359305728 1962077184 19.323 100 27 54 0 1982715552 12679248 7959120
15:24:22 68837 8192000000 10900102880 11387527168 1973139696 19.410 100 13 26 2 1992489616 15437840 3912080
15:25:37 42453 8192000000 10887004992 11358711808 1932097904 19.084 98 14 29 0 1949723536 13555648 4069984
15:26:27 72198 8192000000 10854205424 11314565120 1808025120 18.080 92 15 30 1 1821739328 9606160 4108048
15:27:50 74789 8192000000 10862401392 11322904576 1844206384 18.375 95 22 43 2 1858348720 8217920 5924416
15:29:20 43723 8192000000 10870564560 11335299072 1919782176 18.985 99 25 50 3 1939738992 13502928 6453888
15:30:10 71990 8192000000 10853148560 11325026304 1906952688 18.882 98 16 32 0 1926592720 15198672 4441360
15:31:29 59440 8192000000 10871123872 11339194368 1921453008 18.998 99 9 18 1 1934021568 9997728 2570832
15:32:40 24584 8192000000 10892653328 11334160384 1900735600 18.832 97 45 90 2 1922005312 8678400 12591312
15:33:14 17337 8192000000 10883365952 11330207744 1901115168 18.835 98 42 84 2 1925676448 12142480 12418800
15:33:38 109161 8192000000 10885194528 11341185024 1879253200 18.659 97 18 36 2 1895681264 11345872 5082192
15:35:37 108941 8192000000 10852656144 11309334528 1798832672 18.004 93 17 34 0 1824038736 20751328 4454736
15:37:35 133682 8192000000 10859850016 11309576192 1835654656 18.305 95 26 51 3 1853684560 10960048 7069856
15:40:02 37316 8192000000 10842682352 11300630528 1897562576 18.807 99 25 51 0 1916550720 12037264 6950880
15:40:54 24233 8192000000 10837951264 11293736960 1893906320 18.777 99 37 74 0 1914945152 10931408 10107424
15:41:28 50591 8192000000 10845411904 11304955904 1887779856 18.728 98 20 40 0 1900630176 7397808 5452512
15:42:25 103383 8192000000 10834184112 11309731840 1881605232 18.678 98 8 16 1 1895139792 11276032 2258528
15:44:15 44442 8192000000 10838929536 11317186560 1919998960 18.987 100 6 12 0 1932851680 11144832 1707888
15:45:30 57043 8192000000 10832678944 11312418816 1867947696 18.568 97 17 34 0 1886159664 13153072 5058896
15:46:39 59799 8192000000 10832708992 11304730624 1852934304 18.446 97 16 32 1 1873415984 15967488 4514192
15:48:02 63181 8192000000 10845982912 11317280768 1893603376 18.775 99 18 34 1 1910678304 11939840 5135088
15:49:53 39427 8192000000 10842108544 11313082368 1887702912 18.727 98 17 34 1 1900271440 8033008 4535520
15:50:39 34490 8192000000 10862303216 11310841856 1913040160 18.931 99 22 44 2 1927028400 7954464 6033776
15:51:22 72246 8192000000 10863682656 11346300928 1942246800 19.165 100 19 38 0 1957548336 10537040 4764496
15:52:44 49139 8192000000 10864885136 11334942720 1915874048 18.954 98 24 48 1 1934043792 11095376 7074368
15:53:42 61068 8192000000 10872244256 11337756672 1932904416 19.090 99 22 44 1 1949236048 9584176 6747456
15:54:51 27754 8192000000 10896617072 11353800704 1960358592 19.309 100 41 82 3 1980818624 9265040 11194992
15:55:25 58435 8192000000 10901027680 11365654528 1948442960 19.214 99 43 86 1 1973684624 13671664 11570000
15:56:31 41626 8192000000 10913019168 11363610624 1943376224 19.174 99 26 52 0 1965906032 15471824 7057984
15:57:57 51593 8192000000 10904316096 11360681984 1920061104 18.987 97 19 38 0 1934249136 9051888 5136144
15:59:20 123003 8192000000 10894619984 11353088000 1950472272 19.230 99 24 48 0 1966437440 8889520 7075648
16:01:51 63199 8192000000 10888861360 11364450304 1940913296 19.154 98 23 46 1 1956472720 9428544 6130880
16:03:02 35291 8192000000 10886805408 11366981632 1970728592 19.391 100 9 18 0 1981807200 8556048 2522560
16:03:57 5956 8192000000 10897925696 11356815360 1953339216 19.253 99 35 70 1 1972189200 9127584 9722400
16:04:09 24139 8192000000 10879332608 11334447104 1901470688 18.838 97 31 62 0 1922003184 11888656 8643840
16:05:01 50679 8192000000 10861285296 11336757248 1894260000 18.780 97 6 12 0 1908680048 12235696 2184352
16:06:47 67411 8192000000 10856663408 11329052672 1875484112 18.629 97 10 20 0 1891437536 13166992 2786432
16:08:17 39257 8192000000 10846415088 11323179008 1915985536 18.955 99 14 28 2 1929300752 9179296 4135920
16:09:03 50396 8192000000 10871625184 11350691840 1931096800 19.076 99 9 18 0 1946150800 12994944 2059056
16:10:00 46107 8192000000 10892447968 11350032384 1934353984 19.102 99 20 40 0 1947513440 7580816 5578640
16:10:55 33978 8192000000 10915488288 11372711936 1965637296 19.351 100 32 64 3 1985635104 10660288 9337520
16:11:38 62643 8192000000 10884473328 11359674368 1931595456 19.080 98 25 48 2 1953233968 14697376 6941136
16:13:27 37348 8192000000 10876778768 11342381056 1914352352 18.942 98 26 53 4 1932496800 10742384 7402064
16:14:14 54226 8192000000 10888929472 11345563648 1916394688 18.958 98 25 50 4 1939641632 16575504 6671440
16:15:15 99509 8192000000 10888222144 11371749376 1933113408 19.092 99 18 36 0 1953118432 14946304 5058720
16:17:30 121690 8192000000 10842301904 11305672704 1802686784 18.036 93 10 19 1 1821238432 15776528 2775120
16:19:38 13673 8192000000 10853529008 11305250816 1889211808 18.739 98 26 52 1 1903339936 6371664 7756464
16:19:59 10909 8192000000 10879033040 11310780416 1911310864 18.917 99 56 112 2 1935999328 7672720 17015744
16:20:20 13766 8192000000 10876409760 11321421824 1926498960 19.039 100 48 96 0 1954251184 14311120 13441104
16:20:40 35060 8192000000 10864084000 11321253888 1879699136 18.663 97 36 72 1 1900601056 11350624 9551296
16:21:22 117578 8192000000 10854348352 11322535936 1890894384 18.753 98 16 32 0 1908054512 13179936 3980192
16:23:37 86445 8192000000 10843253712 11321307136 1896806832 18.801 98 18 36 0 1915245232 13578720 4859680
16:25:10 7827 8192000000 10823644464 11304636416 1905115536 18.867 100 4 8 1 1920596176 14298720 1181920
16:25:54 49129 8192000000 10842442336 11310239744 1907699584 18.888 99 10 20 0 1916864400 6410112 2754704
16:26:51 21419 8192000000 9591497168 9919688704 725473200 8.135 38 1 2 0 728753824 3218496 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 02-11-2020 16:29:39 to 02-11-2020 16:30:12.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 113 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-11-2020 16:30:13 to 02-11-2020 16:30:15.

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          246858
MON$OLDEST_ACTIVE               246859
MON$OLDEST_SNAPSHOT             246859
MON$NEXT_TRANSACTION            246859
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                       2039456
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33383 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33383 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33383 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33383 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 ---
--- end of diff output ---

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

02.11.20 16:30:16. 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-11-02 16:30:18 No severe PSQL-related problems occured
02.11.20 16:30:19. End of report.