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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17260624 kB
MemAvailable 31489768 kB
Buffers 0 kB
Cached 14459848 kB
SwapCached 4820 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-28 01:27:06
DTS_END                         2020-12-28 01:27:06.0090
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/33540
TRN_ID                          241373
ATT_ID                          715
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: 9261.35 21553 1111362
customer order: creation 172.51 342 20701
customer order: refuse 14.57 326 1748
order to supplier: creation 46.08 1197 5530
order to supplier: removal 3.28 114794 393
invoice (draft): creation 45.98 3554 5517
invoice (draft): removal 52.63 777 6316
invoice accept: apply 41.49 17753 4979
invoice accept: cancel 47.87 739 5744
customer reserve: creation 3861.61 176 463393
customer reserve: removal 4671.18 64 560541
realization accept: apply 83.57 159 10028
realization accept: cancel 89.93 108 10791
payment from customer: creation 60.66 119 7279
payment from customer: removal 5.33 98 639
payment to supplier: creation 48.98 137 5878
payment to supplier: removal 3.58 56 429
service: total inventory turnovers 4.74 1134 569
service: total monetary turnovers 6.53 21 783
service: aggregate perf. data 0.83 21571 100
service: refresh index statistics 0.03 267940 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 28-12-2020 01:29:33 to 28-12-2020 01:29:36.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2952
TEST_TIME 2 4290
TEST_TIME 3 4513
TEST_TIME 4 5488
TEST_TIME 5 5921
TEST_TIME 6 5390
TEST_TIME 7 5281
TEST_TIME 8 5400
TEST_TIME 9 5300
TEST_TIME 10 5139
TEST_TIME 11 5660
TEST_TIME 12 5995
TEST_TIME 13 6312
TEST_TIME 14 6526
TEST_TIME 15 6510
TEST_TIME 16 7120
TEST_TIME 17 7554
TEST_TIME 18 8270
TEST_TIME 19 8422
TEST_TIME 20 8297
TEST_TIME 21 8807
TEST_TIME 22 9065
TEST_TIME 23 9137
TEST_TIME 24 9312
TEST_TIME 25 9362
TEST_TIME 26 9946
TEST_TIME 27 11087
TEST_TIME 28 11190
TEST_TIME 29 11190
TEST_TIME 30 11091
TEST_TIME 31 10790
TEST_TIME 32 10686
TEST_TIME 33 10614
TEST_TIME 34 10664
TEST_TIME 35 10588
TEST_TIME 36 10556
TEST_TIME 37 10363
TEST_TIME 38 10336
TEST_TIME 39 10250
TEST_TIME 40 10169
TEST_TIME 41 10226
TEST_TIME 42 10131
TEST_TIME 43 10105
TEST_TIME 44 10124
TEST_TIME 45 10009
TEST_TIME 46 9961
TEST_TIME 47 9851
TEST_TIME 48 9828
TEST_TIME 49 9666
TEST_TIME 50 9716
TEST_TIME 51 9714
TEST_TIME 52 9688
TEST_TIME 53 9688
TEST_TIME 54 9681
TEST_TIME 55 9733
TEST_TIME 56 9805
TEST_TIME 57 9786
TEST_TIME 58 9858
TEST_TIME 59 9786
TEST_TIME 60 9891
TEST_TIME 61 9874
TEST_TIME 62 9874
TEST_TIME 63 9956
TEST_TIME 64 9960
TEST_TIME 65 10039
TEST_TIME 66 10150
TEST_TIME 67 10014
TEST_TIME 68 9922
TEST_TIME 69 9921
TEST_TIME 70 9835
TEST_TIME 71 9844
TEST_TIME 72 9787
TEST_TIME 73 9720
TEST_TIME 74 9686
TEST_TIME 75 9730
TEST_TIME 76 9645
TEST_TIME 77 9586
TEST_TIME 78 9627
TEST_TIME 79 9579
TEST_TIME 80 9600
TEST_TIME 81 9566
TEST_TIME 82 9565
TEST_TIME 83 9636
TEST_TIME 84 9613
TEST_TIME 85 9635
TEST_TIME 86 9554
TEST_TIME 87 9609
TEST_TIME 88 9666
TEST_TIME 89 9693
TEST_TIME 90 9762
TEST_TIME 91 9735
TEST_TIME 92 9828
TEST_TIME 93 9767
TEST_TIME 94 9672
TEST_TIME 95 9615
TEST_TIME 96 9620
TEST_TIME 97 9549
TEST_TIME 98 9509
TEST_TIME 99 9495
TEST_TIME 100 9526
TEST_TIME 101 9478
TEST_TIME 102 9467
TEST_TIME 103 9510
TEST_TIME 104 9557
TEST_TIME 105 9516
TEST_TIME 106 9515
TEST_TIME 107 9489
TEST_TIME 108 9520
TEST_TIME 109 9495
TEST_TIME 110 9584
TEST_TIME 111 9551
TEST_TIME 112 9592
TEST_TIME 113 9529
TEST_TIME 114 9469
TEST_TIME 115 9439
TEST_TIME 116 9391
TEST_TIME 117 9347
TEST_TIME 118 9334
TEST_TIME 119 9332
TEST_TIME 120 9261

Performance per minute, chart


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

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 1541547 1541547 0 0.00 0 15939 6 0 0
doc_list_biud 1541547 1541547 0 0.00 0 20407 29 0 0
sp_add_invoice_to_stock 5096 4979 117 2.29 31 188244 17754 0 117
sp_cancel_adding_invoice 5744 5744 0 0.00 5 41805 739 0 0
sp_cancel_client_order 1748 1748 0 0.00 4 14625 327 0 0
sp_cancel_customer_reserve 560541 560541 0 0.00 1 20408 65 0 0
sp_cancel_pay_from_customer 639 639 0 0.00 2 8808 98 0 0
sp_cancel_pay_to_supplier 429 429 0 0.00 3 1683 56 0 0
sp_cancel_supplier_invoice 6326 6316 10 0.15 1 15842 777 0 10
sp_cancel_supplier_order 393 393 0 0.00 6 1028701 114795 0 0
sp_cancel_write_off 10791 10791 0 0.00 1 17103 109 0 0
sp_client_order 20701 20701 0 0.00 4 19864 343 0 0
sp_customer_reserve 463393 463393 0 0.00 0 40935 176 0 0
sp_fill_shopping_cart 31743 31743 0 0.00 1 13917 36 0 0
sp_fill_shopping_cart_clo_res 463392 463392 0 0.00 0 14516 13 0 0
sp_get_clo_for_invoice 4978 4978 0 0.00 0 22617 293 0 0
sp_kill_cost_storno 17603 17603 0 0.00 0 8947 54 0 0
sp_kill_qstorno_ret_qs2qd 1138582 1138582 0 0.00 0 20396 34 0 0
sp_kill_qty_storno 600539 600539 0 0.00 0 20407 73 0 0
sp_lock_selected_doc 20625 20625 0 0.00 0 5919 4 0 0
sp_make_cost_storno 28163 28163 0 0.00 0 13544 50 0 0
sp_multiply_rows_for_pdistr 28163 28163 0 0.00 0 10355 28 0 0
sp_multiply_rows_for_qdistr 20701 20701 0 0.00 0 18636 170 0 0
sp_pay_from_customer 7279 7279 0 0.00 4 11894 120 0 0
sp_pay_to_supplier 5878 5878 0 0.00 5 19531 137 0 0
sp_payment_common 13157 13157 0 0.00 1 11888 33 0 0
sp_qd_handle_on_cancel_clo 1748 1748 0 0.00 0 14618 304 0 0
sp_qd_handle_on_invoice_upd_sts 10722 10722 0 0.00 0 14435 315 0 0
sp_qd_handle_on_reserve_upd_sts 10028 10028 0 0.00 0 19695 52 0 0
sp_reserve_write_off 10028 10028 0 0.00 6 19729 160 0 0
sp_supplier_invoice 5517 5517 0 0.00 5 101135 3555 0 0
sp_supplier_order 5530 5530 0 0.00 5 29181 1197 0 0
srv_aggregate_perf_data 100 100 0 0.00 2083 197253 21572 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 907 155910 33666 0 0
srv_find_qd_qs_mism 1063933 1063933 0 0.00 0 15938 5 0 0
srv_make_invnt_saldo 569 569 0 0.00 42 94363 1134 0 0
srv_make_money_saldo 783 783 0 0.00 1 379 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 230433 350152 267941 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4979 4979 0 0.00 0 23865 172 0 0
t$perf-norm:sp_cancel_adding_invoice 407 407 0 0.00 0 2711 63 0 0
t$perf-norm:sp_cancel_client_order 1748 1748 0 0.00 0 2414 13 0 0
t$perf-norm:sp_cancel_customer_reserve 656 656 0 0.00 0 9052 28 0 0
t$perf-norm:sp_cancel_pay_from_customer 639 639 0 0.00 0 1709 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 429 429 0 0.00 0 814 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 408 408 0 0.00 0 485 11 0 0
t$perf-norm:sp_cancel_supplier_order 393 393 0 0.00 0 28470 1675 0 0
t$perf-norm:sp_cancel_write_off 939 939 0 0.00 0 1951 12 0 0
t$perf-norm:sp_client_order 20701 20701 0 0.00 0 14025 16 0 0
t$perf-norm:sp_customer_reserve 1065 1065 0 0.00 0 1078 5 0 0
t$perf-norm:sp_pay_from_customer 7279 7279 0 0.00 0 6704 11 0 0
t$perf-norm:sp_pay_to_supplier 5878 5878 0 0.00 0 10178 10 0 0
t$perf-norm:sp_reserve_write_off 10028 10028 0 0.00 0 10818 10 0 0
t$perf-norm:sp_supplier_invoice 5517 5517 0 0.00 0 9762 18 0 0
t$perf-norm:sp_supplier_order 5530 5530 0 0.00 0 2971 17 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 763 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 3694 26 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 1177 23 0 0
t$perf-norm:srv_make_money_saldo 783 783 0 0.00 0 1643 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 10 5 0 0
v_add_invoice_to_stock 10190 9956 234 2.29 0 6181 17 0 234
v_all_customers 37808 37808 0 0.00 0 14 1 0 0
v_all_suppliers 30718 30718 0 0.00 0 16 1 0 0
v_all_wares 41402 41402 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 814 814 0 0.00 0 81 5 0 0
v_cancel_client_order 3496 3496 0 0.00 0 2272 4 0 0
v_cancel_customer_prepayment 1278 1278 0 0.00 0 4814 7 0 0
v_cancel_customer_reserve 1312 1312 0 0.00 0 5725 13 0 0
v_cancel_payment_to_supplier 858 858 0 0.00 0 1544 6 0 0
v_cancel_supplier_invoice 836 816 20 2.39 0 2236 19 0 20
v_cancel_supplier_order 786 786 0 0.00 0 670 4 0 0
v_cancel_write_off 1878 1878 0 0.00 0 4185 15 0 0
v_max_id_clo_ord 5530 5530 0 0.00 0 1782 1 0 0
v_max_id_clo_res 1065 1065 0 0.00 0 3499 21 0 0
v_max_id_ord_sup 5512 5512 0 0.00 0 6271 5 0 0
v_max_non_paid_invoice 1561 1561 0 0.00 0 2579 4 0 0
v_max_non_paid_realizn 3863 3863 0 0.00 0 2578 3 0 0
v_min_id_clo_ord 5530 5530 0 0.00 0 1863 6 0 0
v_min_id_clo_res 1065 1065 0 0.00 0 4427 11 0 0
v_min_id_ord_sup 5512 5512 0 0.00 0 9101 6 0 0
v_min_non_paid_invoice 5878 5878 0 0.00 0 7717 21 0 0
v_min_non_paid_realizn 7279 7279 0 0.00 0 9935 21 0 0
v_our_firm 10426 10426 0 0.00 0 15 1 0 0
v_reserve_write_off 20056 20056 0 0.00 0 7192 6 0 0
x_lock_depdocs_on_canc_invoice 11652 11652 0 0.00 0 13114 112 0 0
x_lock_depdocs_on_canc_sup_ord 393 393 0 0.00 0 4088 335 0 0
x_make_qstorno_1000_1200 5530 5530 0 0.00 1 29170 1126 0 0
x_make_qstorno_1200_2000 5517 5517 0 0.00 2 101120 3421 0 0
x_make_qstorno_2100_3300 463393 463393 0 0.00 0 40931 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-12-2020 01:29:41 to 28-12-2020 01:29:45.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:09 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:15 12492 8192000000 10208227200 10507321344 803102464 8.928 64 52 107 0 822003744 2125312 16775968
22:57:36 35347 8192000000 10338089360 10653745152 1371972080 14.345 100 87 173 1 1405662912 4568240 29122592
22:58:22 28770 8192000000 10390544432 10714329088 1438405776 14.936 100 86 173 0 1472682240 6248000 28028464
22:59:01 13360 8192000000 10413583104 10739671040 1467231072 15.189 100 91 182 0 1504305968 7511056 29563840
22:59:26 27612 8192000000 10432862128 10766413824 1484476288 15.341 100 86 172 0 1520229408 8153072 27600048
23:00:04 22826 8192000000 10459322544 10793414656 1511163760 15.573 100 88 176 0 1548292432 9009504 28119168
23:00:37 14036 8192000000 10461254064 10800939008 1521583072 15.664 100 89 179 1 1559305136 9482848 28239216
23:01:15 13007 8192000000 10493707376 10834976768 1537605920 15.803 100 83 166 1 1573440112 9699744 26134448
23:01:37 12453 8192000000 10500617792 10850910208 1565264784 16.042 100 88 176 1 1602722736 10217872 27240080
23:02:01 13973 8192000000 10541785936 10897281024 1591262624 16.265 100 77 151 1 1624495712 10069216 23163872
23:02:24 17254 8192000000 10563736512 10920783872 1615731264 16.474 100 77 152 2 1648973280 10435360 22806656
23:02:50 7274 8192000000 10583120848 10943537152 1644184144 16.715 100 81 162 0 1679118704 10958352 23976208
23:03:09 7986 8192000000 10593925120 10956890112 1652473552 16.785 100 73 146 2 1685720960 11592960 21654448
23:03:26 11599 8192000000 10609870592 10977341440 1674805120 16.974 100 73 145 1 1707102480 11594096 20703264
23:03:45 8721 8192000000 10626465984 10999590912 1691619248 17.115 100 76 152 0 1725590368 11958080 22013040
23:04:03 10647 8192000000 10646628000 11021574144 1709342464 17.263 100 73 146 0 1742286096 11789584 21154048
23:04:22 6567 8192000000 10672931776 11048509440 1727586096 17.415 100 76 151 1 1760898592 11858448 21454048
23:04:37 5287 8192000000 10671114752 11050434560 1735857808 17.484 100 71 140 1 1767143648 11946624 19339216
23:04:50 6380 8192000000 10690136432 11071819776 1750999024 17.610 100 70 143 1 1782083360 11608960 19475376
23:05:04 5117 8192000000 10697902816 11081084928 1763243296 17.711 100 77 154 0 1797104448 12328208 21532944
23:05:17 6162 8192000000 10707384928 11089272832 1773176720 17.793 100 84 168 1 1810649744 13683888 23789136
23:05:30 5329 8192000000 10717857168 11098763264 1778829968 17.840 100 83 162 1 1814879200 13776032 22273200
23:05:42 3734 8192000000 10732331904 11110453248 1781914176 17.865 100 77 154 0 1816735216 13410800 21410240
23:05:53 6037 8192000000 10720384576 11106742272 1785785424 17.897 100 71 142 0 1818743632 13574736 19383472
23:06:10 3269 8192000000 10737392928 11129827328 1805347248 18.058 100 81 157 3 1840615312 12957552 22310512
23:06:21 2999 8192000000 10744348800 11132092416 1809032480 18.088 100 80 160 1 1845497472 13738224 22726768
23:06:30 2642 8192000000 10756704256 11143811072 1817953104 18.161 100 84 168 1 1855189840 12996368 24240368
23:06:41 3121 8192000000 10764766064 11151843328 1827545664 18.239 100 86 172 1 1865719840 14101760 24072416
23:06:51 2634 8192000000 10779813200 11169107968 1838771664 18.331 100 90 180 0 1878329984 14009776 25548544
23:07:00 2320 8192000000 10767936672 11158794240 1837223824 18.318 100 86 173 0 1874898592 13461392 24213376
23:07:09 1131 8192000000 10788575392 11176792064 1847128816 18.399 100 86 173 0 1883324800 12284368 23911616
23:07:18 1635 8192000000 10792030416 11180978176 1848038256 18.406 100 84 168 1 1886113280 13757136 24317888
23:07:26 1747 8192000000 10793446144 11181584384 1852355888 18.441 100 89 179 1 1891221744 14048080 24817776
23:07:34 2084 8192000000 10803218080 11193303040 1859257568 18.497 100 93 186 2 1899576992 14429936 25889488
23:07:44 2290 8192000000 10813108848 11201880064 1864899520 18.543 100 95 192 4 1906682016 15883328 25899168
23:07:52 1343 8192000000 10813641120 11202555904 1867455744 18.564 100 94 187 0 1909318048 14142368 27719936
23:08:00 1260 8192000000 10815711472 11205308416 1869222800 18.578 100 95 189 1 1910097600 14517440 26357360
23:08:07 2142 8192000000 10816274928 11206864896 1871865616 18.599 100 90 179 2 1912419872 14158064 26396192
23:08:15 1147 8192000000 10823844160 11212984320 1874497424 18.621 100 94 188 0 1915413728 14637984 26278320
23:08:23 1540 8192000000 10822753728 11213201408 1876781232 18.639 100 92 184 0 1916270656 14182624 25306800
23:08:31 32914 8192000000 10784281136 11202154496 1869880496 18.583 100 56 112 2 1895501152 9593648 16027008
23:09:12 8207 8192000000 10801727232 11207643136 1873323088 18.611 100 29 57 0 1886676496 5387008 7966400
23:09:27 5841 8192000000 10794160160 11218186240 1879447376 18.661 100 31 62 2 1897421520 8514752 9459392
23:09:40 12203 8192000000 10785292288 11220877312 1882005616 18.681 100 22 44 2 1895784736 7382112 6397008
23:09:58 14196 8192000000 10785789456 11220684800 1884974368 18.705 100 21 42 2 1896392688 6166912 5251408
23:10:19 7239 8192000000 10799544640 11227181056 1889060800 18.738 100 30 57 1 1904138608 6866832 8210976
23:10:32 7132 8192000000 10796558928 11224375296 1887822384 18.728 100 23 46 0 1900716368 6428752 6465232
23:10:49 7182 8192000000 10793377728 11230126080 1893561744 18.774 100 21 42 1 1905782896 6723424 5497728
23:11:03 10262 8192000000 10804757792 11234447360 1893979280 18.778 100 22 44 0 1907686016 6044656 7662080
23:11:20 8255 8192000000 10801770880 11239256064 1898892448 18.817 100 26 52 0 1913105600 6765312 7447840
23:11:37 8846 8192000000 10813000912 11247226880 1904046896 18.859 100 29 56 1 1922411328 10972288 7392144
23:11:52 8692 8192000000 10814837072 11247812608 1903625264 18.855 100 15 30 1 1913505360 5923856 3956240
23:12:07 7581 8192000000 10820682560 11252125696 1906453136 18.878 100 22 44 1 1919338368 6790912 6094320
23:12:27 64957 8192000000 10823647168 11259068416 1910921040 18.914 100 41 81 1 1928902800 5848352 12133408
23:13:42 7373 8192000000 10819464960 11258064896 1908963168 18.898 100 25 50 1 1922092512 6198016 6931328
23:13:55 9167 8192000000 10817757616 11255930880 1910160160 18.908 100 25 50 1 1922933920 6005936 6767824
23:14:13 4566 8192000000 10831742352 11263291392 1915552960 18.951 100 41 82 3 1935007648 8351280 11103408
23:14:24 6240 8192000000 10827282640 11250180096 1893490336 18.774 99 23 46 3 1905732064 6006304 6235424
23:14:37 8292 8192000000 10819784016 11258662912 1906176512 18.876 100 20 39 4 1922198416 10314320 5707584
23:14:52 4966 8192000000 10837259872 11265089536 1913140960 18.932 100 38 74 2 1930138160 5927984 11069216
23:15:04 7144 8192000000 10829904368 11261636608 1910641472 18.912 100 17 33 1 1920878544 5519792 4717280
23:15:17 5361 8192000000 10828248448 11266506752 1914329152 18.941 100 23 46 0 1927507424 6724640 6453632
23:15:29 13450 8192000000 10822422320 11253628928 1871832128 18.599 98 13 25 1 1881101296 5489104 3780064
23:15:49 9126 8192000000 10822915632 11259629568 1908406640 18.894 100 11 22 2 1917712736 5161696 4144400
23:16:04 10184 8192000000 10822690608 11259678720 1911113104 18.916 100 25 50 3 1924125200 6206880 6805216
23:16:25 10108 8192000000 10811183264 11250798592 1904063760 18.859 100 22 44 1 1916072432 5579728 6428944
23:16:43 7721 8192000000 10791691344 11216678912 1835012240 18.300 97 21 42 1 1847555664 5871184 6672240
23:16:59 55699 8192000000 10811478000 11221184512 1853759568 18.453 98 38 75 3 1872348640 5478176 13110896
23:18:04 17267 8192000000 10761198352 11193368576 1788391376 17.919 96 11 22 1 1796253984 4801104 3061504
23:18:27 7477 8192000000 10766974368 11181150208 1791966688 17.948 97 34 68 2 1807839680 6501616 9371376
23:18:44 4651 8192000000 10757236144 11177160704 1809592960 18.093 98 30 60 2 1825443168 7059152 8791056
23:18:59 6548 8192000000 10738859056 11143704576 1756930672 17.659 96 28 57 4 1770675952 5131536 8613744
23:19:13 8920 8192000000 10728522400 11142627328 1738285696 17.504 95 19 38 2 1750159024 5909520 5963808
23:19:28 6582 8192000000 10685529216 11101806592 1740500352 17.523 97 23 44 2 1756204000 9610592 6093056
23:19:42 5857 8192000000 10700005264 11119837184 1754265312 17.637 97 27 54 1 1767866544 5639520 7961712
23:19:55 6756 8192000000 10719439248 11134058496 1773164096 17.793 98 30 58 2 1787401120 5411328 8825696
23:20:08 8642 8192000000 10721898096 11143532544 1792684560 17.954 99 13 26 2 1802051664 5820272 3546832
23:20:24 11700 8192000000 10702272048 11117305856 1727729984 17.417 96 20 41 0 1739173296 6085824 5357488
23:20:42 7675 8192000000 10699524656 11113013248 1752225408 17.620 98 25 50 1 1765486320 5373392 7887520
23:20:56 8727 8192000000 10701712112 11120824320 1755733040 17.649 98 22 44 2 1771410000 9578992 6097968
23:21:11 15454 8192000000 10703495840 11127472128 1747307104 17.579 97 20 38 2 1758271104 5124224 5839776
23:21:33 50164 8192000000 10735547888 11140689920 1763335584 17.712 97 43 87 0 1786529728 10518096 12676048
23:22:35 22065 8192000000 10730715200 11159056384 1815477024 18.141 100 11 20 0 1823658512 5460768 2720720
23:23:03 8200 8192000000 10734062416 11156316160 1804850720 18.054 99 21 43 0 1815834704 5330784 5653200
23:23:20 5133 8192000000 10743023472 11168268288 1836481168 18.312 100 39 80 1 1854666752 6389168 11796416
23:23:33 7972 8192000000 10745086432 11178663936 1841181536 18.350 100 30 59 1 1856624896 6793872 8649488
23:23:49 7234 8192000000 10763748512 11187625984 1844176544 18.375 100 15 30 1 1854269280 5129392 4963344
23:24:04 7238 8192000000 10762085744 11186032640 1846835456 18.396 100 18 34 2 1856883936 5400928 4647552
23:24:20 6386 8192000000 10759198640 11190460416 1849448736 18.418 100 25 49 2 1866258656 9380176 7429744
23:24:33 10129 8192000000 10779942096 11196100608 1852946560 18.446 100 18 34 2 1863829840 5497440 5385840
23:24:53 9159 8192000000 10783844736 11208040448 1866016464 18.552 100 19 37 1 1876716560 5789232 4910864
23:25:10 10001 8192000000 10786242736 11214454784 1872606000 18.605 100 23 45 3 1883866640 5051936 6208704
23:25:28 15107 8192000000 10802176336 11219611648 1873930768 18.616 100 28 56 2 1888363664 5932272 8500624
23:25:56 6678 8192000000 10792945952 11218591744 1873530304 18.613 100 26 52 3 1886879104 5905344 7443456
23:26:11 8679 8192000000 10785253968 11217973248 1871705712 18.598 100 15 30 4 1882059616 6261600 4092304
23:26:29 28618 8192000000 10776526160 11217338368 1875703360 18.630 100 22 44 1 1887828944 5831536 6294048
23:28:04 26656 8192000000 10838294080 11254362112 1900540432 18.831 100 56 111 1 1923724240 6513168 16670640
23:28:43 21683 8192000000 10834903088 11264626688 1910430224 18.910 100 37 72 2 1929549232 8846032 10272976
23:29:14 6836 8192000000 10832715344 11259334656 1895400304 18.789 99 30 60 0 1912409968 7982512 9027152
23:29:31 27174 8192000000 10842163328 11270918144 1919315808 18.981 100 38 75 0 1937820720 7580528 10924384
23:30:05 17824 8192000000 10857811296 11290914816 1931449120 19.078 100 39 78 0 1952385776 9078128 11858528
23:30:29 7557 8192000000 10874341904 11301900288 1938969792 19.139 100 37 74 2 1960694432 11152352 10572288
23:30:45 12039 8192000000 10871529168 11293540352 1931979376 19.083 99 54 108 0 1960017328 12473888 15564064
23:31:05 4573 8192000000 10891293408 11313029120 1947411792 19.206 100 53 106 1 1976100944 13827872 14861280
23:31:18 1610 8192000000 10908780864 11313733632 1951845984 19.241 100 92 184 0 1994358240 16071648 26440608
23:31:26 5678 8192000000 10908834912 11323146240 1954082912 19.259 100 69 137 1 1990791728 16865632 19843184
23:31:41 6820 8192000000 10900336064 11326611456 1954992288 19.266 100 56 112 1 1987617856 16873360 15752208
23:32:00 7696 8192000000 10905000896 11331796992 1959917536 19.305 100 56 112 2 1993796864 17580752 16298576
23:32:28 17192 8192000000 10903880880 11335147520 1963061008 19.330 100 40 80 0 1989445584 14597840 11786736
23:33:06 8637 8192000000 10912066064 11341590528 1971181120 19.395 100 54 105 1 2002980288 15658832 16140336
23:33:24 17910 8192000000 10923918592 11350228992 1980878272 19.472 100 54 108 0 2015079008 17278976 16921760
23:33:54 16300 8192000000 10920963840 11350204416 1983205056 19.490 100 55 109 3 2018500736 18362112 16933568
23:34:27 10353 8192000000 10934304784 11361353728 1966498848 19.358 99 44 86 0 1998555904 18981936 13075120
23:34:51 20509 8192000000 10932764784 11368579072 1990541472 19.548 100 41 82 2 2022804640 19325872 12937296
23:35:25 19285 8192000000 10927843632 11372335104 1992917424 19.567 100 34 68 2 2023287616 19486688 10883504
23:35:54 8400 8192000000 10929731136 11367231488 1979066880 19.457 99 41 82 0 2010454800 18687424 12700496
23:36:10 8702 8192000000 10932875280 11360296960 1959460000 19.302 98 58 114 2 1996892608 20109872 17322736
23:36:28 7317 8192000000 10938054704 11353526272 1973661040 19.414 99 59 119 2 2013252896 21359936 18231920
23:36:47 14542 8192000000 10932312832 11362463744 1987697136 19.526 100 52 103 1 2025289408 21821408 15770864
23:37:17 12022 8192000000 10947754208 11372212224 1992239792 19.561 100 57 114 3 2034184432 24541936 17402704
23:37:40 10442 8192000000 10944957168 11376168960 1992803520 19.566 100 51 102 0 2035062560 26073248 16185792
23:38:04 8998 8192000000 10953254208 11381317632 1997364992 19.602 100 58 115 1 2043469120 28141376 17962752
23:38:22 5500 8192000000 10954370256 11371700224 1976629136 19.438 99 67 134 1 2026471072 29502032 20339904
23:38:37 6593 8192000000 10930504368 11360321536 1976227408 19.435 100 65 127 3 2024016800 28671920 19117472
23:38:56 5696 8192000000 10939260224 11370639360 1985705824 19.510 100 55 111 1 2029134592 26357712 17071056
23:39:10 7153 8192000000 10914680992 11348008960 1949298000 19.221 98 48 96 1 1990185872 25456912 15430960
23:39:26 2630 8192000000 10939399648 11360763904 1965118960 19.347 99 63 126 2 2011030752 26979952 18931840
23:39:37 2939 8192000000 10942947136 11349082112 1970144000 19.387 99 78 153 3 2019673440 25985184 23544256
23:39:49 7067 8192000000 10944743424 11361714176 1977844768 19.448 100 74 146 2 2027334256 27278528 22210960
23:40:05 6251 8192000000 10946928768 11371491328 1981730128 19.478 100 63 125 0 2028629568 28222560 18676880
23:40:19 5151 8192000000 10961881296 11378434048 1993713568 19.573 100 82 164 1 2048136512 29377328 25045616
23:40:37 6480 8192000000 10946601424 11371937792 1986243136 19.514 100 57 110 2 2032204496 28304528 17656832
23:40:50 5643 8192000000 10933482592 11353640960 1968066864 19.370 99 66 132 3 2017366976 28949728 20350384
23:41:04 1936 8192000000 10956575984 11365625856 1977099840 19.442 100 90 180 1 2038049776 33366496 27583440
23:41:13 2889 8192000000 10962988624 11374268416 1982158416 19.482 100 82 164 0 2044342736 37178880 25005440
23:41:24 2555 8192000000 10937542464 11352764416 1928039840 19.051 97 71 143 0 1986774352 36608528 22125984
23:41:37 4690 8192000000 10961474768 11374927872 1982115744 19.481 100 84 169 0 2046600544 38123536 26361264
23:41:49 2210 8192000000 10969192368 11385905152 1987329600 19.523 100 83 168 2 2053108784 40652128 25127056
23:41:59 1773 8192000000 10942208784 11356200960 1936350544 19.118 98 76 153 0 1999990288 40072144 23567600
23:42:08 4732 8192000000 10953359696 11360894976 1967598976 19.366 100 83 164 2 2036683552 42201824 26882752
23:42:22 7587 8192000000 10920545120 11337850880 1944731056 19.184 100 68 133 1 2008309680 42573792 21004832
23:42:39 6938 8192000000 10927495968 11349770240 1948876896 19.218 100 61 122 0 2012269584 43413200 19979488
23:42:55 7678 8192000000 10933382144 11352809472 1940927264 19.154 99 59 118 0 2005906928 45703648 19276016
23:43:14 8039 8192000000 10926292592 11348996096 1933648496 19.096 99 60 117 0 2006079760 52296720 20134544
23:43:32 3416 8192000000 10944813408 11351146496 1944699408 19.184 100 83 167 2 2022587536 51532144 26355984
23:43:43 5327 8192000000 10942159344 11353890816 1928887856 19.058 99 77 155 1 2009119872 53910864 26321152
23:43:56 3630 8192000000 10935012176 11356246016 1947347360 19.205 100 68 136 1 2019864080 50535648 21981072
23:44:07 2119 8192000000 10951472160 11365085184 1959560752 19.303 100 80 160 2 2034784560 49825968 25397840
23:44:18 4237 8192000000 10965302464 11383414784 1970212016 19.387 100 79 158 1 2045411248 49478208 25721024
23:44:29 906 8192000000 10958537552 11364974592 1960560608 19.310 99 87 173 2 2037383584 49568080 27254896
23:44:37 2722 8192000000 10972771376 11383758848 1979405584 19.460 100 85 167 4 2057049408 51113408 26530416
23:44:46 1531 8192000000 10978384320 11390889984 1979963904 19.464 100 81 161 1 2055811088 50090080 25757104
23:44:55 4799 8192000000 10953567920 11369603072 1940351760 19.150 98 75 147 1 2014486176 50055040 24079376
23:45:09 1816 8192000000 10979265792 11387801600 1980863808 19.472 100 83 164 0 2056703616 50039072 25800736
23:45:19 2755 8192000000 11000943248 11408683008 1993992592 19.575 100 91 182 2 2073404144 51405168 28006384
23:45:31 2846 8192000000 10991569248 11401818112 1977045552 19.441 99 85 169 2 2051127760 49032640 25049568
23:45:41 2762 8192000000 10988975968 11404976128 1997371104 19.602 100 82 163 2 2073172496 50404720 25396672
23:45:51 1412 8192000000 11005668480 11416670208 2008479648 19.690 100 94 189 0 2090190880 52144880 29566352
23:46:00 6013 8192000000 10992171408 11414413312 2003234112 19.648 100 70 140 1 2069987792 45165808 21587872
23:46:38 9953 8192000000 10943930704 11369865216 1952177104 19.244 98 43 86 1 2007693680 41363872 14152704
23:47:02 3533 8192000000 10949557680 11376861184 1960118304 19.307 99 58 117 1 2021601600 43264048 18219248
23:47:13 1266 8192000000 10946038720 11353092096 1945999792 19.195 99 85 168 2 2017612240 44847184 26765264
23:47:21 955 8192000000 10946296464 11360612352 1938177376 19.132 99 79 158 0 2013625520 50908848 24539296
23:47:31 4215 8192000000 10935908208 11352141824 1945516752 19.191 100 67 134 0 2015213968 48376224 21320992
23:47:46 1518 8192000000 10963649904 11377766400 1966750240 19.360 100 81 160 0 2044150176 52308688 25091248
23:47:55 3053 8192000000 10961567840 11386466304 1973595024 19.414 100 69 138 1 2049668880 54120112 21953744
23:48:17 17214 8192000000 10946109152 11378143232 1944021648 19.179 99 42 83 1 2017000784 58412432 14566704
23:48:42 10357 8192000000 10928797280 11373277184 1949899232 19.226 100 35 70 0 2016736992 54506448 12331312
23:49:04 18864 8192000000 10931219856 11375325184 1957448480 19.286 100 34 68 1 2017851088 48568880 11833728
23:49:40 10124 8192000000 10939245440 11383836672 1968101936 19.370 100 47 94 0 2027047056 42866096 16079024
23:50:06 12198 8192000000 10935732336 11372572672 1952014384 19.243 99 35 70 0 2006605280 43284944 11305952
23:50:31 15782 8192000000 10941171344 11386826752 1969863328 19.384 100 35 70 2 2026569968 44645440 12061200
23:51:05 18177 8192000000 10945965408 11393495040 1971536208 19.398 100 30 60 1 2030749264 48882416 10330640
23:51:33 34222 8192000000 10935361184 11392081920 1970475904 19.389 100 26 52 4 2026635504 47067072 9092528
23:52:24 18325 8192000000 10932734896 11387371520 1953186672 19.252 100 18 36 4 2013420064 53120064 7113328
23:52:53 8149 8192000000 10919094016 11369218048 1911030640 18.915 98 30 60 0 1977286608 55409008 10846960
23:53:09 18108 8192000000 10913905504 11383672832 1936493744 19.119 100 25 50 4 2005908544 59657072 9757728
23:53:38 11481 8192000000 10914145584 11378409472 1944595968 19.183 100 26 52 1 2009217888 54895840 9726080
23:54:01 31152 8192000000 10897947584 11354439680 1901327408 18.837 98 14 28 1 1953892624 47139504 5425712
23:54:55 38513 8192000000 10842180016 11287388160 1843562672 18.370 96 18 36 2 1857278912 8284912 5431328
23:55:40 80683 8192000000 10852264688 11321049088 1880132160 18.666 98 10 20 2 1900713536 17632880 2948496
23:57:07 125500 8192000000 10884708816 11325911040 1912251760 18.925 99 21 42 1 1931810016 14287408 5270848
23:59:26 83569 8192000000 10859662512 11313434624 1866650384 18.557 96 14 28 1 1877086864 7090080 3346400
00:00:56 14204 8192000000 10878646816 11323162624 1930983024 19.075 99 60 121 3 1952959376 5543824 16432528
00:01:21 66179 8192000000 10861628960 11322773504 1889240592 18.740 97 27 54 2 1912790784 15734000 7816192
00:02:39 56828 8192000000 10867198544 11319918592 1915624592 18.952 98 24 47 0 1931193584 8981760 6587232
00:03:45 32868 8192000000 10881198160 11335430144 1952030064 19.243 100 40 80 0 1974330912 10697968 11602880
00:04:49 54274 8192000000 10878763104 11343675392 1945616416 19.192 99 47 93 1 1967377776 8894768 12866592
00:05:49 43214 8192000000 10897173168 11359657984 1968137360 19.371 100 15 30 0 1985735232 13223680 4374192
00:06:40 16820 8192000000 10904635888 11349700608 1961791792 19.320 99 21 42 0 1977833632 9656768 6385072
00:07:06 22395 8192000000 10914010720 11353997312 1942705376 19.168 98 55 108 3 1971380192 12381216 16293600
00:08:01 44633 8192000000 10891209488 11363074048 1969967184 19.385 100 15 30 1 1991181472 16468160 4746128
00:09:01 44859 8192000000 10893696640 11369521152 1971770192 19.399 100 9 18 0 1987751824 13126656 2854976
00:10:51 38491 8192000000 10885338064 11360841728 1962109200 19.323 100 13 25 0 1980038704 14500720 3428784
00:11:48 84355 8192000000 10888827280 11363680256 1968589072 19.374 100 11 17 3 1978526240 7425840 2511328
00:13:28 81668 8192000000 10900990256 11357339648 1975614496 19.430 100 25 49 0 1989657216 6669712 7373008
00:14:57 74747 8192000000 10876275232 11359916032 1923348448 19.014 97 26 52 3 1940769536 9972272 7448816
00:16:18 75285 8192000000 10893119504 11371814912 1953333472 19.253 99 22 44 1 1971714800 11272464 7108864
00:17:49 61521 8192000000 10871440288 11352686592 1921887568 19.002 98 4 8 0 1931465504 8684928 893008
00:19:00 37707 8192000000 10886656736 11355492352 1929530496 19.063 98 17 34 0 1944026464 8788704 5707264
00:19:51 44395 8192000000 10891903344 11361955840 1930229184 19.069 98 13 26 0 1942438896 8283760 3925952
00:20:42 34317 8192000000 10890337712 11352612864 1951565104 19.239 99 24 48 1 1967114512 8620480 6928928
00:21:23 41827 8192000000 10897838384 11373309952 1966690784 19.359 100 27 54 1 1988449680 13762752 7996144
00:22:19 54880 8192000000 10898875584 11355697152 1907996224 18.891 97 16 32 1 1926815440 14015888 4803328
00:23:23 54928 8192000000 10890235792 11329933312 1851571136 18.435 94 36 71 0 1870100384 8784240 9745008
00:24:25 40668 8192000000 10867181920 11338014720 1912616736 18.928 98 23 46 0 1931084816 12216096 6251984
00:25:12 66715 8192000000 10869128176 11328487424 1856329696 18.474 95 7 14 0 1868608688 10156224 2122768
00:26:25 43976 8192000000 10916587968 11361431552 1951887296 19.242 100 21 42 0 1969190192 11829216 5473680
00:27:17 59726 8192000000 10875022160 11333701632 1901848384 18.841 97 27 54 0 1922887872 13753440 7286048
00:28:23 53023 8192000000 10839615136 11290288128 1807372224 18.074 93 31 61 1 1826551328 10374912 8804192
00:29:24 62786 8192000000 10853459440 11310092288 1868107024 18.569 97 15 30 0 1884391744 12303376 3981344
00:30:37 29308 8192000000 10884746496 11328335872 1898979152 18.818 98 34 67 0 1916670112 8724208 8966752
00:31:15 52489 8192000000 10897290896 11348725760 1923317504 19.013 99 28 56 0 1946643296 15687264 7638528
00:32:13 57697 8192000000 10882704112 11361509376 1927879968 19.050 99 21 42 1 1950249824 16361856 6008000
00:33:25 111135 8192000000 10880503360 11339821056 1931414752 19.078 99 12 24 1 1954310880 19827920 3068208
00:35:38 81002 8192000000 10853071280 11312750592 1880725920 18.671 96 24 47 1 1899420144 12380704 6313520
00:37:05 41832 8192000000 10862644992 11318329344 1910280896 18.909 98 30 60 2 1926492400 7794944 8416560
00:37:53 34255 8192000000 10871684400 11319185408 1917169840 18.964 99 29 58 2 1934476976 8838272 8468864
00:38:46 69738 8192000000 10818275264 11286884352 1860436224 18.507 96 15 30 1 1873509392 9050960 4022208
00:40:02 47825 8192000000 10839517232 11304042496 1892671392 18.767 98 16 33 0 1905766960 8430624 4664944
00:41:11 71624 8192000000 10861682288 11332546560 1907194416 18.884 98 18 36 1 1922428128 9929104 5304608
00:42:57 48224 8192000000 10824625600 11296583680 1889252400 18.740 98 12 24 1 1901434096 8636816 3544880
00:43:52 97435 8192000000 10839708432 11302326272 1869088416 18.577 97 17 34 1 1883972368 9629088 5254864
00:45:41 87685 8192000000 10840251552 11308355584 1872632800 18.606 97 10 20 0 1889934144 14504288 2797056
00:47:24 67079 8192000000 10865053584 11329302528 1885474288 18.709 97 18 33 0 1898100256 8011008 4614960
00:48:38 57900 8192000000 10866802944 11330564096 1929402784 19.062 99 32 64 1 1948233264 9099408 9731072
00:50:06 61389 8192000000 10864576960 11330482176 1905367856 18.869 98 8 16 0 1916186992 8482368 2336768
00:51:13 35275 8192000000 10883159376 11338039296 1949688112 19.224 100 22 44 2 1962901456 7050144 6163200
00:51:57 84060 8192000000 10880557552 11347222528 1918665584 18.976 98 19 38 2 1936632256 12538000 5428672
00:53:27 53138 8192000000 10907376592 11367464960 1948049600 19.211 99 40 80 2 1973155056 14232848 10872608
00:54:31 109754 8192000000 10882113616 11363196928 1886879120 18.721 96 8 16 1 1902520320 13662368 1978832
00:56:34 100217 8192000000 10898727680 11381207040 1924579376 19.024 98 11 22 1 1955874448 28698320 2596752
00:58:20 59189 8192000000 10919567904 11383480320 1961758896 19.320 99 31 62 1 1984888160 13877568 9251696
00:59:30 155910 8192000000 10924518592 11388436480 1989213056 19.538 100 20 40 0 2004545248 9984448 5347744
01:02:24 40963 8192000000 10926394816 11398549504 2005695472 19.668 100 38 75 2 2032554976 16322192 10537312
01:03:28 86598 8192000000 10916509440 11395043328 1946964752 19.202 97 11 22 0 1964293376 14379904 2948720
01:05:01 57517 8192000000 10936627520 11411783680 1999893040 19.622 100 12 25 1 2014443152 10922464 3627648
01:06:04 50764 8192000000 10930980352 11398533120 1971983632 19.401 98 21 42 0 1993740608 15106464 6650512
01:07:07 79495 8192000000 10931076448 11415277568 1984888336 19.503 99 12 24 2 2004170432 15773696 3508400
01:08:35 41011 8192000000 10929460256 11381858304 1950114176 19.227 97 25 50 2 1974493024 16777872 7600976
01:09:26 84335 8192000000 10912056528 11391852544 1951617664 19.239 98 24 48 1 1979355120 21022944 6714512
01:11:21 60102 8192000000 10875280288 11344732160 1850170080 18.424 94 20 40 0 1867229280 11723536 5335664
01:12:30 32793 8192000000 10918938208 11367313408 1950407120 19.230 99 33 64 1 1968219984 8963408 8849456
01:13:13 68037 8192000000 10919343216 11366096896 1916789520 18.961 97 34 68 1 1939237248 12377088 10070640
01:14:29 44999 8192000000 10905670096 11372609536 1950638352 19.232 99 29 58 0 1972631392 14179280 7813760
01:15:28 56843 8192000000 10902490928 11359920128 1949538736 19.223 99 25 50 1 1969782432 13292336 6951360
01:16:31 24348 8192000000 10932613648 11377532928 1975079760 19.426 100 36 73 3 1995624720 10638960 9906000
01:17:03 69840 8192000000 10886842256 11361779712 1902517760 18.847 96 22 44 1 1925405184 16771824 6115600
01:18:22 150110 8192000000 10840763584 11310280704 1741936080 17.535 89 11 20 0 1761257136 16397984 2923072
01:21:14 54801 8192000000 10838054992 11303747584 1900147328 18.827 99 23 44 1 1914095808 7855392 6093088
01:22:16 60578 8192000000 10847040464 11318411264 1894537728 18.782 98 18 36 0 1907804304 8545648 4720928
01:23:22 75318 8192000000 10849156976 11325255680 1907925984 18.890 99 16 32 1 1926793920 14412720 4455216
01:24:44 54580 8192000000 10862539104 11332624384 1911778736 18.921 99 12 24 1 1931159456 15457472 3923248
01:25:46 46697 8192000000 10882590768 11357204480 1945801296 19.193 100 16 32 3 1968715680 18179792 4734592
01:26:48 29415 8192000000 9315588896 9597882368 463249456 5.352 24 5 10 0 477777120 12997024 1530640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 28-12-2020 01:29:47 to 28-12-2020 01:30:18.

Exceptions occured during test was in run

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

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

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          242585
MON$OLDEST_ACTIVE               242586
MON$OLDEST_SNAPSHOT             242586
MON$NEXT_TRANSACTION            242586
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                       2045664
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
--- end of diff output ---

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

28.12.20 01:30:22. 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-28 01:30:24 No severe PSQL-related problems occured
28.12.20 01:30:26. End of report.