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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-06-19 19:27:40
DTS_END                         2021-06-19 19:27:40.3490
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39842
TRN_ID                          237053
ATT_ID                          650
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: 9650.61 17499 1158073
customer order: creation 170.22 349 20426
customer order: refuse 14.92 357 1790
order to supplier: creation 43.88 1361 5266
order to supplier: removal 3.58 104764 429
invoice (draft): creation 45.81 3240 5497
invoice (draft): removal 56.58 731 6789
invoice accept: apply 41.94 17634 5033
invoice accept: cancel 50.67 715 6080
customer reserve: creation 3895.63 175 467475
customer reserve: removal 5033.50 59 604020
realization accept: apply 82.39 170 9887
realization accept: cancel 84.82 113 10178
payment from customer: creation 58.03 121 6964
payment from customer: removal 5.95 65 714
payment to supplier: creation 47.03 124 5644
payment to supplier: removal 3.23 77 388
service: total inventory turnovers 5.09 1141 611
service: total monetary turnovers 6.55 23 786
service: aggregate perf. data 0.77 26390 92
service: refresh index statistics 0.03 192372 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-06-2021 19:28:27 to 19-06-2021 19:28:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3470
TEST_TIME 2 4614
TEST_TIME 3 4677
TEST_TIME 4 4506
TEST_TIME 5 4701
TEST_TIME 6 5360
TEST_TIME 7 4963
TEST_TIME 8 5351
TEST_TIME 9 5406
TEST_TIME 10 5345
TEST_TIME 11 5589
TEST_TIME 12 5922
TEST_TIME 13 6225
TEST_TIME 14 6227
TEST_TIME 15 6532
TEST_TIME 16 6850
TEST_TIME 17 6924
TEST_TIME 18 7388
TEST_TIME 19 7441
TEST_TIME 20 8022
TEST_TIME 21 8175
TEST_TIME 22 8394
TEST_TIME 23 8568
TEST_TIME 24 8653
TEST_TIME 25 9232
TEST_TIME 26 9808
TEST_TIME 27 9761
TEST_TIME 28 10529
TEST_TIME 29 10837
TEST_TIME 30 10653
TEST_TIME 31 10687
TEST_TIME 32 10513
TEST_TIME 33 10464
TEST_TIME 34 10462
TEST_TIME 35 10444
TEST_TIME 36 10437
TEST_TIME 37 10516
TEST_TIME 38 10511
TEST_TIME 39 10448
TEST_TIME 40 10405
TEST_TIME 41 10178
TEST_TIME 42 10157
TEST_TIME 43 10089
TEST_TIME 44 10088
TEST_TIME 45 9977
TEST_TIME 46 9944
TEST_TIME 47 9906
TEST_TIME 48 9917
TEST_TIME 49 9972
TEST_TIME 50 9997
TEST_TIME 51 9939
TEST_TIME 52 9889
TEST_TIME 53 9823
TEST_TIME 54 9729
TEST_TIME 55 9700
TEST_TIME 56 9757
TEST_TIME 57 9686
TEST_TIME 58 9653
TEST_TIME 59 9553
TEST_TIME 60 9595
TEST_TIME 61 9561
TEST_TIME 62 9584
TEST_TIME 63 9702
TEST_TIME 64 9697
TEST_TIME 65 9767
TEST_TIME 66 9818
TEST_TIME 67 9793
TEST_TIME 68 9797
TEST_TIME 69 9824
TEST_TIME 70 9915
TEST_TIME 71 9901
TEST_TIME 72 9905
TEST_TIME 73 9924
TEST_TIME 74 10026
TEST_TIME 75 9915
TEST_TIME 76 9895
TEST_TIME 77 9814
TEST_TIME 78 9789
TEST_TIME 79 9750
TEST_TIME 80 9690
TEST_TIME 81 9650
TEST_TIME 82 9598
TEST_TIME 83 9556
TEST_TIME 84 9532
TEST_TIME 85 9644
TEST_TIME 86 9608
TEST_TIME 87 9596
TEST_TIME 88 9565
TEST_TIME 89 9661
TEST_TIME 90 9670
TEST_TIME 91 9674
TEST_TIME 92 9689
TEST_TIME 93 9704
TEST_TIME 94 9694
TEST_TIME 95 9747
TEST_TIME 96 9867
TEST_TIME 97 9868
TEST_TIME 98 9880
TEST_TIME 99 9821
TEST_TIME 100 9734
TEST_TIME 101 9768
TEST_TIME 102 9728
TEST_TIME 103 9700
TEST_TIME 104 9729
TEST_TIME 105 9684
TEST_TIME 106 9675
TEST_TIME 107 9649
TEST_TIME 108 9620
TEST_TIME 109 9615
TEST_TIME 110 9595
TEST_TIME 111 9570
TEST_TIME 112 9612
TEST_TIME 113 9602
TEST_TIME 114 9606
TEST_TIME 115 9638
TEST_TIME 116 9612
TEST_TIME 117 9625
TEST_TIME 118 9612
TEST_TIME 119 9665
TEST_TIME 120 9651

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-06-2021 19:28:31 to 19-06-2021 19:28:34.

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 1591881 1591881 0 0.00 0 20055 5 0 0
doc_list_biud 1591878 1591878 0 0.00 0 40536 28 0 0
sp_add_invoice_to_stock 5134 5033 101 1.96 34 164891 17634 0 101
sp_cancel_adding_invoice 6080 6080 0 0.00 5 80296 715 0 0
sp_cancel_client_order 1790 1790 0 0.00 5 26758 357 0 0
sp_cancel_customer_reserve 604020 604020 0 0.00 1 40539 59 0 0
sp_cancel_pay_from_customer 714 714 0 0.00 3 2770 66 0 0
sp_cancel_pay_to_supplier 388 388 0 0.00 3 2982 77 0 0
sp_cancel_supplier_invoice 6798 6789 9 0.13 2 28879 732 0 9
sp_cancel_supplier_order 429 429 0 0.00 5 1103824 104764 0 0
sp_cancel_write_off 10178 10178 0 0.00 1 20534 113 0 0
sp_client_order 20426 20426 0 0.00 3 36048 349 0 0
sp_customer_reserve 467475 467475 0 0.00 0 50890 175 0 0
sp_fill_shopping_cart 31175 31175 0 0.00 1 12950 35 0 0
sp_fill_shopping_cart_clo_res 467474 467474 0 0.00 0 18747 14 0 0
sp_get_clo_for_invoice 5032 5032 0 0.00 0 19025 274 0 0
sp_kill_cost_storno 17360 17360 0 0.00 0 15896 59 0 0
sp_kill_qstorno_ret_qs2qd 1225436 1225436 0 0.00 0 40527 32 0 0
sp_kill_qty_storno 644204 644204 0 0.00 0 40535 68 0 0
sp_lock_selected_doc 20691 20691 0 0.00 0 9935 6 0 0
sp_make_cost_storno 27527 27527 0 0.00 0 9888 47 0 0
sp_multiply_rows_for_pdistr 27526 27526 0 0.00 0 20038 29 0 0
sp_multiply_rows_for_qdistr 20426 20426 0 0.00 0 14431 161 0 0
sp_pay_from_customer 6964 6964 0 0.00 4 20060 121 0 0
sp_pay_to_supplier 5644 5644 0 0.00 5 11992 125 0 0
sp_payment_common 12607 12607 0 0.00 1 12120 30 0 0
sp_qd_handle_on_cancel_clo 1790 1790 0 0.00 0 26752 327 0 0
sp_qd_handle_on_invoice_upd_sts 11112 11112 0 0.00 0 26446 326 0 0
sp_qd_handle_on_reserve_upd_sts 9886 9886 0 0.00 0 25491 60 0 0
sp_reserve_write_off 9887 9887 0 0.00 6 25621 171 0 0
sp_supplier_invoice 5497 5497 0 0.00 7 75764 3240 0 0
sp_supplier_order 5266 5266 0 0.00 5 58968 1361 0 0
srv_aggregate_perf_data 92 92 0 0.00 2609 596498 26391 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1471 138528 31669 0 0
srv_find_qd_qs_mism 1111192 1111192 0 0.00 0 15881 4 0 0
srv_make_invnt_saldo 611 611 0 0.00 50 177638 1142 0 0
srv_make_money_saldo 786 786 0 0.00 1 592 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 77945 285749 192372 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5033 5033 0 0.00 0 27871 232 0 0
t$perf-norm:sp_cancel_adding_invoice 362 362 0 0.00 0 6400 125 0 0
t$perf-norm:sp_cancel_client_order 1790 1790 0 0.00 0 3473 11 0 0
t$perf-norm:sp_cancel_customer_reserve 702 702 0 0.00 0 1880 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 714 714 0 0.00 0 5685 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 388 388 0 0.00 0 1467 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 404 404 0 0.00 0 1556 14 0 0
t$perf-norm:sp_cancel_supplier_order 429 429 0 0.00 0 40520 1733 0 0
t$perf-norm:sp_cancel_write_off 985 985 0 0.00 0 6824 12 0 0
t$perf-norm:sp_client_order 20428 20428 0 0.00 0 7510 19 0 0
t$perf-norm:sp_customer_reserve 1056 1056 0 0.00 0 3161 11 0 0
t$perf-norm:sp_pay_from_customer 6964 6964 0 0.00 0 9628 13 0 0
t$perf-norm:sp_pay_to_supplier 5644 5644 0 0.00 0 5885 10 0 0
t$perf-norm:sp_reserve_write_off 9887 9887 0 0.00 0 9368 15 0 0
t$perf-norm:sp_supplier_invoice 5497 5497 0 0.00 0 3228 19 0 0
t$perf-norm:sp_supplier_order 5266 5266 0 0.00 0 6337 19 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 203 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 9938 123 0 0
t$perf-norm:srv_make_invnt_saldo 611 611 0 0.00 0 4661 24 0 0
t$perf-norm:srv_make_money_saldo 786 786 0 0.00 0 797 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10260 10058 202 1.96 0 6692 16 0 202
v_all_customers 37318 37318 0 0.00 0 20 1 0 0
v_all_suppliers 29370 29370 0 0.00 0 16 1 0 0
v_all_wares 40851 40851 0 0.00 0 141 1 0 0
v_cancel_adding_invoice 724 724 0 0.00 0 182 5 0 0
v_cancel_client_order 3580 3580 0 0.00 0 2837 6 0 0
v_cancel_customer_prepayment 1428 1428 0 0.00 0 1235 4 0 0
v_cancel_customer_reserve 1404 1404 0 0.00 0 2081 12 0 0
v_cancel_payment_to_supplier 776 776 0 0.00 0 2867 12 0 0
v_cancel_supplier_invoice 826 808 18 2.17 0 2991 21 0 18
v_cancel_supplier_order 858 858 0 0.00 0 880 4 0 0
v_cancel_write_off 1970 1970 0 0.00 0 2163 13 0 0
v_max_id_clo_ord 5264 5264 0 0.00 0 285 1 0 0
v_max_id_clo_res 1056 1056 0 0.00 0 4812 22 0 0
v_max_id_ord_sup 5484 5484 0 0.00 0 4464 3 0 0
v_max_non_paid_invoice 1707 1707 0 0.00 0 640 2 0 0
v_max_non_paid_realizn 3627 3627 0 0.00 0 4362 6 0 0
v_min_id_clo_ord 5264 5264 0 0.00 0 6214 8 0 0
v_min_id_clo_res 1056 1056 0 0.00 0 5864 13 0 0
v_min_id_ord_sup 5484 5484 0 0.00 0 5105 6 0 0
v_min_non_paid_invoice 5644 5644 0 0.00 0 9734 16 0 0
v_min_non_paid_realizn 6962 6962 0 0.00 0 9729 20 0 0
v_our_firm 10201 10201 0 0.00 0 12 1 0 0
v_reserve_write_off 19770 19770 0 0.00 0 4720 6 0 0
x_lock_depdocs_on_canc_invoice 12465 12465 0 0.00 0 12501 99 0 0
x_lock_depdocs_on_canc_sup_ord 429 429 0 0.00 0 5743 307 0 0
x_make_qstorno_1000_1200 5266 5266 0 0.00 2 58652 1282 0 0
x_make_qstorno_1200_2000 5497 5497 0 0.00 3 75696 3122 0 0
x_make_qstorno_2100_3300 467475 467475 0 0.00 0 47432 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-06-2021 19:28:35 to 19-06-2021 19:28:39.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:43 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
16:57:50 9601 8192000000 10178089680 10478321664 948230688 10.374 75 50 100 0 967811472 2386176 17194608
16:58:08 32767 8192000000 10327965040 10643812352 1366087344 14.292 100 85 170 0 1397289312 4063968 27138000
16:58:49 27877 8192000000 10392532800 10711834624 1426277920 14.828 100 87 174 0 1460233152 5346592 28608640
16:59:30 24084 8192000000 10405820288 10730209280 1463921552 15.160 100 90 180 0 1499716432 6684176 29110704
17:00:11 20677 8192000000 10424899488 10756415488 1485446960 15.349 100 84 168 0 1519701152 7377584 26876608
17:00:41 16257 8192000000 10434100880 10767532032 1496907344 15.449 100 85 170 0 1531902784 7729184 27266256
17:01:07 19428 8192000000 10461111328 10794942464 1513672144 15.595 100 89 178 0 1550159696 7995904 28491648
17:01:35 15263 8192000000 10477976832 10819211264 1536769840 15.796 100 87 174 0 1572433920 8374848 27289232
17:02:07 17748 8192000000 10511165392 10857725952 1571510736 16.095 100 74 148 1 1603484912 8790032 23184144
17:02:34 12771 8192000000 10532724640 10888495104 1595038448 16.297 100 78 155 2 1627314384 9209888 23066048
17:02:55 18508 8192000000 10566641488 10930335744 1627740080 16.576 100 78 155 1 1660264336 9752672 22771584
17:03:22 18387 8192000000 10595210048 10957328384 1652042272 16.782 100 74 148 0 1683600608 10050608 21507728
17:03:49 14012 8192000000 10603247936 10969878528 1669848304 16.932 100 76 152 0 1703338080 11006912 22482864
17:04:14 12240 8192000000 10633741808 11002191872 1689952736 17.101 100 80 158 0 1728713040 15731328 23028976
17:04:36 7685 8192000000 10648689648 11019575296 1705159712 17.228 100 79 158 1 1739859280 11652192 23047376
17:04:51 8028 8192000000 10669766032 11040067584 1721676736 17.366 100 84 168 2 1758309056 12460848 24171472
17:05:07 9669 8192000000 10669450128 11044380672 1736683968 17.491 100 74 148 2 1770186960 12458976 21044016
17:05:24 8285 8192000000 10688409088 11059884032 1746176512 17.570 100 85 169 1 1783149488 13351728 23621248
17:05:39 5885 8192000000 10688447760 11065987072 1752786384 17.625 100 77 152 2 1788159392 14081680 21291328
17:05:53 5850 8192000000 10696696080 11072942080 1757927584 17.667 100 84 168 0 1796925264 14910496 24087184
17:06:06 6444 8192000000 10705116736 11080294400 1762898640 17.708 100 87 177 1 1801134944 14066048 24170256
17:06:21 4884 8192000000 10716959088 11094507520 1772163472 17.785 100 82 164 2 1808877072 14124928 22588672
17:06:35 3994 8192000000 10725847952 11102121984 1778309200 17.836 100 77 154 0 1814159376 13341888 22508288
17:06:45 5894 8192000000 10715329040 11100844032 1782393552 17.869 100 76 152 0 1817608112 14016656 21197904
17:06:57 4162 8192000000 10730712224 11115888640 1787029024 17.907 100 73 146 0 1819352048 12011776 20311248
17:07:09 3656 8192000000 10748008960 11131707392 1805908112 18.062 100 76 152 2 1838918592 12253824 20756656
17:07:19 3894 8192000000 10759329728 11139031040 1814329376 18.131 100 74 149 0 1848178912 12669248 21180288
17:07:29 2874 8192000000 10752357536 11141193728 1821040512 18.186 100 89 176 2 1858735536 13137776 24557248
17:07:40 2441 8192000000 10775262032 11157479424 1830352656 18.262 100 90 178 2 1870184816 14373312 25458848
17:07:49 2169 8192000000 10783475280 11165990912 1838024080 18.325 100 92 184 0 1877895712 13629264 26242368
17:07:57 2019 8192000000 10781832976 11166162944 1840745280 18.347 100 86 172 1 1879071840 13833344 24493216
17:08:06 2301 8192000000 10790114560 11175079936 1843688272 18.371 100 87 173 2 1881646992 13581168 24377552
17:08:15 1448 8192000000 10796048784 11182567424 1852874160 18.445 100 92 185 2 1892551760 13107392 26570208
17:08:23 2425 8192000000 10791984848 11182747648 1854589632 18.459 100 87 176 0 1892701232 13680016 24431584
17:08:31 1943 8192000000 10810016544 11195338752 1863124064 18.529 100 95 192 1 1902947392 12720848 27102480
17:08:39 1743 8192000000 10812002176 11198099456 1865555024 18.548 100 97 195 2 1906041392 13190528 27295840
17:08:47 1710 8192000000 10810121712 11197612032 1864708208 18.541 100 96 193 0 1906109152 14730448 26670496
17:08:55 1311 8192000000 10818322864 11203653632 1866523136 18.556 100 98 197 1 1907933120 14109216 27300768
17:09:03 1304 8192000000 10811622784 11196981248 1865745952 18.550 100 88 178 3 1904718976 14004896 24968128
17:09:10 3025 8192000000 10801000240 11200966656 1865865952 18.551 100 75 150 1 1900128720 13246528 21016240
17:09:20 22131 8192000000 10764963792 11189600256 1857992016 18.487 100 34 67 0 1874991472 7990672 9008784
17:09:49 7778 8192000000 10762814304 11191984128 1859983392 18.503 100 17 34 1 1871109056 6441568 4684096
17:10:05 7702 8192000000 10782241648 11201212416 1868338016 18.571 100 38 76 2 1886600944 7682192 10580736
17:10:20 7006 8192000000 10789865360 11203670016 1866615552 18.557 100 22 44 0 1879571232 6866128 6089552
17:10:33 8206 8192000000 10769163872 11200630784 1869120000 18.577 100 23 46 0 1881869152 6641328 6107824
17:10:48 6223 8192000000 10783923072 11207094272 1871755840 18.598 100 21 42 2 1883279536 5650016 5873680
17:11:02 8954 8192000000 10780991648 11204628480 1871724112 18.598 100 29 55 1 1886606224 6036880 8845232
17:11:18 13140 8192000000 10777644960 11205742592 1871984016 18.600 100 19 36 3 1883831696 5803216 6044464
17:11:37 9093 8192000000 10786611648 11212668928 1875718336 18.631 100 20 40 1 1891125936 9940304 5467296
17:11:52 13316 8192000000 10785120800 11214082048 1877532128 18.645 100 19 38 1 1888727984 6097680 5098176
17:12:14 23768 8192000000 10793938176 11217899520 1881476192 18.677 100 15 30 1 1891567536 5843456 4247888
17:12:44 30730 8192000000 10804892480 11232460800 1884864512 18.704 100 27 54 0 1898270352 5499968 7905872
17:13:39 26035 8192000000 10830053536 11241414656 1892438912 18.765 100 54 104 1 1913986672 5764208 15783552
17:14:11 1299 8192000000 10832890240 11247677440 1898631344 18.815 100 67 132 1 1928228432 10940624 18656464
17:14:20 5489 8192000000 10825873440 11243036672 1895284640 18.788 100 42 83 0 1915882576 9147344 11450592
17:14:32 5226 8192000000 10814867904 11243712512 1895263808 18.788 100 41 82 0 1915563312 9072672 11226832
17:14:45 9035 8192000000 10817810672 11242700800 1892531312 18.766 100 27 54 2 1907573248 7539872 7502064
17:15:00 5095 8192000000 10825182512 11247804416 1901130000 18.835 100 43 87 1 1922180544 9124576 11925968
17:15:16 5202 8192000000 10820238960 11242430464 1895900720 18.793 100 33 66 1 1911775984 6661552 9213712
17:15:28 5697 8192000000 10806707408 11240194048 1894605568 18.783 100 22 44 2 1907305952 6147936 6552448
17:15:40 6675 8192000000 10807499344 11241529344 1897045552 18.803 100 28 57 1 1911466576 6718448 7702576
17:15:54 48986 8192000000 10800289984 11241033728 1883357712 18.692 99 32 64 0 1898508560 6077840 9073008
17:16:51 5472 8192000000 10828493120 11249860608 1903657488 18.856 100 31 62 2 1918308464 6188416 8462560
17:17:03 7702 8192000000 10819399648 11249446912 1884577136 18.702 99 33 66 1 1900680496 6894848 9208512
17:17:20 4598 8192000000 10829790768 11257868288 1905490096 18.870 100 24 48 0 1922394368 10305712 6598560
17:17:31 3919 8192000000 10802069104 11226664960 1869660864 18.582 98 40 80 2 1887800432 7269456 10870112
17:17:44 5205 8192000000 10824325952 11239862272 1886088944 18.714 100 25 50 2 1903807456 10706592 7011920
17:17:56 5840 8192000000 10795932768 11220168704 1848827968 18.413 98 30 61 5 1863530560 6309904 8392688
17:18:08 5144 8192000000 10786862272 11208441856 1827380368 18.238 97 33 66 3 1842509536 5708592 9420576
17:18:20 5218 8192000000 10787852048 11208060928 1853858560 18.453 99 39 78 0 1872306896 6585632 11862704
17:18:35 7800 8192000000 10777062112 11204730880 1804305088 18.049 96 17 34 1 1814759376 5436960 5017328
17:18:49 3753 8192000000 10747879248 11166003200 1810833248 18.103 98 27 53 1 1825078368 6764640 7480480
17:19:00 8232 8192000000 10771355472 11197906944 1854298816 18.457 100 22 44 2 1866505520 5342944 6863760
17:19:17 7094 8192000000 10720752928 11139620864 1764012336 17.718 96 16 32 0 1774281216 5336672 4932208
17:19:32 8350 8192000000 10739429184 11160408064 1799917488 18.013 98 27 54 3 1818671360 10754544 7999328
17:19:50 8971 8192000000 10724502432 11121422336 1734966384 17.477 95 28 56 2 1747705072 4243232 8495456
17:20:10 55447 8192000000 10692062368 11111923712 1694694832 17.141 94 23 45 1 1712153536 10176704 7282000
17:21:14 9167 8192000000 10691716000 11103784960 1729758208 17.433 97 25 49 1 1743117296 6063568 7295520
17:21:31 8104 8192000000 10703878208 11120779264 1750963648 17.610 97 37 74 0 1769267088 7125296 11178144
17:21:45 4272 8192000000 10721359744 11129982976 1781809824 17.864 99 40 80 0 1799733904 6565232 11358848
17:21:57 5039 8192000000 10729337424 11140513792 1802718752 18.036 100 36 72 3 1819077712 6030528 10328432
17:22:12 8086 8192000000 10747928736 11159207936 1817802304 18.160 100 22 45 1 1829673984 5382800 6488880
17:22:29 7512 8192000000 10742834800 11163611136 1812130096 18.113 99 33 66 1 1827685504 6169344 9386064
17:22:46 7546 8192000000 10751346480 11164909568 1810588928 18.101 99 29 58 1 1825513184 6556096 8368160
17:23:00 11004 8192000000 10717347712 11131678720 1725050816 17.394 95 21 42 2 1736119408 5310608 5757984
17:23:18 6887 8192000000 10735682624 11153199104 1802818080 18.037 99 39 78 1 1820132544 5442336 11872128
17:23:31 4790 8192000000 10736729984 11153149952 1804639232 18.052 99 27 54 3 1818903904 6283360 7981312
17:23:45 8390 8192000000 10754754432 11173199872 1829428448 18.255 100 30 60 2 1843426528 4695008 9303072
17:24:00 7637 8192000000 10767815360 11189366784 1844406064 18.377 100 33 66 1 1860159936 6447152 9306720
17:24:16 5121 8192000000 10773590624 11189465088 1852010048 18.438 100 41 81 0 1869981504 5837664 12133792
17:24:29 15482 8192000000 10758177408 11176513536 1833021712 18.284 99 27 54 0 1846871328 5396752 8452864
17:24:51 69151 8192000000 10777670960 11206160384 1865191296 18.545 100 43 84 6 1883431680 6475424 11764960
17:26:07 8925 8192000000 10775450656 11203350528 1863523872 18.532 100 22 44 1 1880430000 10496896 6409232
17:26:22 7823 8192000000 10802268480 11216994304 1868660784 18.573 100 18 36 0 1878866304 4516320 5689200
17:26:37 6943 8192000000 10803307680 11228483584 1877360752 18.644 100 33 66 0 1894008864 7401744 9246368
17:26:51 6729 8192000000 10793708320 11223359488 1880312624 18.668 100 34 68 1 1896781776 6458528 10010624
17:27:03 6980 8192000000 10812001072 11237199872 1889634480 18.743 100 25 49 5 1902267744 6320336 6312928
17:27:18 6800 8192000000 10825965328 11251638272 1904946224 18.866 100 33 66 1 1920269648 5247840 10075584
17:27:31 7531 8192000000 10814423648 11245846528 1899072048 18.819 100 23 47 0 1910097840 4193632 6832160
17:27:48 23183 8192000000 10843545328 11261759488 1910687552 18.912 100 49 96 2 1934912128 9804832 14419744
17:28:24 20225 8192000000 10855838000 11277930496 1923984848 19.019 100 57 115 1 1950455760 9771408 16699504
17:28:51 8041 8192000000 10875253296 11293179904 1933464880 19.095 100 58 116 1 1961058640 11326432 16267328
17:29:07 10833 8192000000 10883539584 11299893248 1941865616 19.162 100 60 119 0 1970018768 12050384 16102768
17:29:26 7138 8192000000 10882726112 11303292928 1947422464 19.206 100 68 136 0 1980705376 14209760 19073152
17:29:39 3035 8192000000 10898081040 11310723072 1950903312 19.234 100 71 142 1 1985600864 14140400 20557152
17:29:53 12313 8192000000 10890340960 11313688576 1952020320 19.243 100 64 127 0 1984134944 13872208 18242416
17:30:13 34032 8192000000 10874383264 11309699072 1947688928 19.208 100 50 100 1 1977129360 15128240 14312192
17:31:21 20133 8192000000 10880240720 11316547584 1949323376 19.221 100 38 77 0 1976096704 15422304 11351024
17:31:52 13951 8192000000 10886602176 11323232256 1955199376 19.268 100 52 104 3 1986882592 16388960 15294256
17:32:15 18681 8192000000 10906614912 11333627904 1965124880 19.347 100 52 104 0 1996026416 16021888 14879648
17:32:48 25579 8192000000 10911278528 11350048768 1978491024 19.453 100 52 104 0 2012604928 18705792 15408112
17:33:25 15511 8192000000 10906927536 11350872064 1974920544 19.424 100 32 62 1 1999513600 15612432 8980624
17:33:56 6713 8192000000 10918666688 11353399296 1979038800 19.457 100 43 85 0 2006758800 15028144 12691856
17:34:14 12342 8192000000 10924916880 11360292864 1986930960 19.520 100 52 102 0 2018755216 17052336 14771920
17:34:34 14833 8192000000 10945887712 11367391232 1990006608 19.544 100 56 110 1 2024521616 18645808 15869200
17:34:58 19895 8192000000 10939305888 11373854720 1995252432 19.585 100 51 102 1 2030317440 19717184 15347824
17:35:41 18126 8192000000 10952004848 11387822080 2004078048 19.655 100 46 91 1 2039279760 21454336 13747376
17:36:07 8400 8192000000 10962279200 11396505600 2008052928 19.686 100 56 108 2 2048011920 23984416 15974576
17:36:25 10302 8192000000 10948405696 11378524160 1988269600 19.530 99 46 90 2 2021672304 20138592 13264112
17:36:46 12513 8192000000 10947514448 11381911552 1991347136 19.554 99 66 131 3 2033790544 22689312 19754096
17:37:08 4709 8192000000 10935917280 11369398272 1964532464 19.342 98 53 106 1 2003528688 23000736 15995488
17:37:22 12268 8192000000 10953502464 11387281408 1999325264 19.617 100 54 107 4 2039291808 24287728 15678816
17:37:41 6226 8192000000 10962433344 11392450560 2006719408 19.676 100 59 117 0 2051850256 27298816 17832032
17:37:56 3954 8192000000 10982283280 11395788800 2007923504 19.685 100 79 158 0 2060043360 28399136 23720720
17:38:09 2874 8192000000 10969594048 11390349312 2002960240 19.646 100 82 163 0 2057088752 29319696 24808816
17:38:19 3622 8192000000 10965648144 11387547648 1999886352 19.622 100 75 150 0 2052605632 29197152 23522128
17:38:33 9382 8192000000 10965175392 11393748992 2002429776 19.642 100 69 138 1 2054015648 30921744 20664128
17:38:58 9016 8192000000 10963699920 11394654208 1989494256 19.540 99 62 124 1 2042034848 33291792 19248800
17:39:21 8092 8192000000 10980652144 11409375232 2011027856 19.710 100 68 136 1 2067277840 35006864 21243120
17:39:36 5867 8192000000 10986186752 11415945216 2013773920 19.731 100 61 121 0 2069876288 36900048 19202320
17:39:50 4837 8192000000 10972147680 11413864448 2012793008 19.723 100 47 94 2 2062211504 34046160 15372336
17:40:02 4839 8192000000 10989871712 11419406336 2015934784 19.748 100 51 102 1 2066311216 34027056 16349376
17:40:14 8150 8192000000 10991342688 11428163584 2028011040 19.843 100 68 136 0 2083323248 34261712 21050496
17:40:34 2175 8192000000 10992501056 11423113216 2025189072 19.821 100 62 124 3 2076141168 32083792 18868304
17:40:45 3271 8192000000 10983740544 11413286912 2014129648 19.734 100 68 136 1 2069326080 34855568 20340864
17:40:55 3493 8192000000 10987303136 11414224896 2016467504 19.752 100 71 142 0 2074258016 35564304 22226208
17:41:07 2358 8192000000 10972418656 11384827904 1977204496 19.443 98 86 169 3 2038742832 35959888 25578448
17:41:17 7379 8192000000 10972443824 11403292672 2006265360 19.672 100 71 139 4 2064922224 37427904 21228960
17:41:33 3329 8192000000 10978659792 11415478272 2009278048 19.696 100 58 116 1 2064640928 37895584 17467296
17:41:47 3197 8192000000 10981902128 11408850944 2004448736 19.658 100 66 130 0 2063326944 38704880 20173328
17:41:58 5570 8192000000 10985663504 11416588288 2005631024 19.667 100 68 136 0 2068486624 41509856 21345744
17:42:17 7415 8192000000 10990268128 11422420992 2013384848 19.728 100 59 117 2 2072510880 40459040 18666992
17:42:53 8869 8192000000 10976262720 11418812416 1990794080 19.550 99 42 84 2 2049150080 44506656 13849344
17:43:09 5939 8192000000 10990325472 11426979840 2008312704 19.688 100 57 114 2 2072405056 45402080 18690272
17:43:23 6560 8192000000 11000285840 11432439808 2015409680 19.744 100 72 143 1 2083816272 45485584 22921008
17:43:45 5796 8192000000 11001579568 11433328640 2020212560 19.782 100 61 122 1 2085257552 45071328 19973664
17:44:00 8688 8192000000 10994172912 11433095168 2017681472 19.762 100 54 108 1 2075521584 40566080 17274032
17:44:16 4419 8192000000 10996882976 11431051264 2019657200 19.777 100 62 124 0 2085944880 46852160 19435520
17:44:30 4847 8192000000 11001075680 11429695488 2019628224 19.777 100 71 141 0 2085324448 43472848 22223376
17:44:45 4144 8192000000 11011442000 11435790336 2016309792 19.751 100 77 154 1 2090414096 49113104 24991200
17:44:57 4267 8192000000 10991039216 11421069312 1998385328 19.610 99 76 152 0 2066777136 44021248 24370560
17:45:08 2930 8192000000 11013454688 11437281280 2021079600 19.789 100 81 163 1 2093593744 47321776 25192368
17:45:18 8363 8192000000 11007807296 11439505408 2022609776 19.801 100 79 158 0 2093439760 46545360 24284624
17:45:34 2092 8192000000 11004494352 11425423360 2012494800 19.721 100 82 164 0 2084355984 46374192 25486992
17:45:46 2464 8192000000 11005122944 11425792000 2013693808 19.731 100 80 160 2 2083111088 44629120 24788160
17:45:57 1470 8192000000 11012596368 11436392448 2021306848 19.790 100 84 170 1 2094989504 47252656 26430000
17:46:05 3561 8192000000 11008422032 11433799680 2016259888 19.751 100 80 158 0 2089241824 48006832 24975104
17:46:16 6673 8192000000 10988447472 11427217408 2010527392 19.706 100 57 114 1 2078438432 49403856 18507184
17:46:37 3262 8192000000 11000961408 11421462528 1991446736 19.555 99 78 156 1 2062872384 45921200 25504448
17:46:47 2860 8192000000 10995688976 11413733376 1997057104 19.600 100 84 168 2 2071987504 48059456 26870944
17:46:57 4667 8192000000 10987956128 11413876736 1992123168 19.561 100 74 149 1 2066738992 49736880 24878944
17:47:14 4691 8192000000 10974301280 11401543680 1975732496 19.431 100 60 120 1 2051833248 56026096 20074656
17:47:27 7652 8192000000 10926753280 11372789760 1938951904 19.138 98 60 120 1 2006669056 48087184 19629968
17:47:45 12220 8192000000 10916164192 11346198528 1929400640 19.062 98 43 85 3 1984390288 41116320 13873328
17:48:06 7437 8192000000 10908504320 11342626816 1907567952 18.887 98 45 91 0 1967238944 44496752 15174240
17:48:24 4341 8192000000 10906219056 11338870784 1926705424 19.041 99 48 95 0 1987297104 44644576 15947104
17:48:35 6198 8192000000 10922120192 11356459008 1927450448 19.046 99 46 92 0 1989746672 46864128 15432096
17:48:57 17017 8192000000 10923000816 11373764608 1949162768 19.220 100 34 68 2 2010079520 49215856 11700896
17:49:23 8016 8192000000 10933529536 11383148544 1961271568 19.316 100 31 62 1 2019518768 47715248 10531952
17:49:41 14603 8192000000 10943768336 11389026304 1950423664 19.230 99 40 80 1 2018443456 54899136 13120656
17:50:05 5983 8192000000 10926629552 11359719424 1933377088 19.094 99 54 108 2 2002026704 51305920 17343696
17:50:19 10205 8192000000 10920222528 11360063488 1923933200 19.018 99 37 73 2 1990857520 54001152 12923168
17:50:37 12886 8192000000 10913443168 11354787840 1936133248 19.116 100 41 82 2 2004237008 53458224 14645536
17:51:07 19954 8192000000 10913522688 11356520448 1917037696 18.963 99 26 52 0 1979291408 52511136 9742576
17:51:38 18724 8192000000 10911449600 11350597632 1915531936 18.951 99 36 72 0 1984046160 55995568 12518656
17:52:26 15446 8192000000 10922602912 11381379072 1940242432 19.149 100 33 66 0 2009038944 57512352 11284160
17:52:47 29543 8192000000 10928603792 11388055552 1948238912 19.212 100 27 54 0 2009681488 53060736 8381840
17:53:29 31733 8192000000 10890280576 11357679616 1937872304 19.130 100 15 30 0 1981262576 38403680 4986592
17:54:17 24455 8192000000 10902747376 11364200448 1931995392 19.083 100 21 42 0 1982345968 42284576 8066000
17:55:21 33862 8192000000 10899908288 11366174720 1938405216 19.134 100 18 36 2 1991685984 47216896 6063872
17:56:01 54673 8192000000 10843039392 11305340928 1895980096 18.794 98 16 32 1 1910130672 9188016 4962560
17:57:02 59304 8192000000 10876130336 11326926848 1902365952 18.845 98 15 30 0 1915090240 8371440 4352848
17:58:13 102212 8192000000 10869023712 11320102912 1873009264 18.609 96 17 34 2 1889610336 12420208 4180864
18:00:07 41507 8192000000 10884036992 11343872000 1944446496 19.182 100 20 40 1 1964686800 14429872 5810432
18:00:58 75859 8192000000 10880205024 11342155776 1910655440 18.912 98 11 22 1 1923413616 9752640 3005536
18:02:20 92008 8192000000 10915447568 11360358400 1907667056 18.888 97 18 36 2 1923196848 10811392 4718400
18:04:01 17340 8192000000 10889453728 11346067456 1952923008 19.250 99 62 122 3 1979811088 8815904 18072176
18:04:26 14765 8192000000 10890651248 11354353664 1960564304 19.311 100 12 24 0 1975366144 11299696 3502144
18:05:02 61429 8192000000 10881067888 11328716800 1884247728 18.699 96 13 24 0 1897808336 10213712 3346896
18:06:14 38093 8192000000 10876979136 11337244672 1910928144 18.914 98 10 20 1 1925214688 11640928 2645616
18:06:59 138523 8192000000 10896073920 11339689984 1919639520 18.984 98 37 74 1 1939871584 9544528 10687536
18:09:31 62663 8192000000 10890810032 11352838144 1923171568 19.012 98 24 48 1 1942859856 12058432 7629856
18:10:51 72665 8192000000 10889387248 11361026048 1947745600 19.209 99 25 50 2 1968981712 14030496 7205616
18:12:10 12225 8192000000 10869058640 11332460544 1922949744 19.010 98 11 22 0 1934274544 8437984 2886816
18:12:36 2514 8192000000 10936548016 11364757504 1972171920 19.403 100 80 158 2 2003687280 8035696 23479664
18:12:45 14359 8192000000 10923123360 11373002752 1977514048 19.445 100 50 100 0 2004195504 11752352 14929104
18:13:05 38925 8192000000 10890089744 11358408704 1957556128 19.287 99 24 48 1 1978312272 13386736 7369408
18:13:56 37883 8192000000 10912593024 11386269696 1982505024 19.485 100 22 44 1 2003741248 14007056 7229168
18:14:46 17330 8192000000 10922135200 11391262720 1987866624 19.527 100 28 56 0 2008954096 13177264 7910208
18:15:13 32176 8192000000 10956831648 11398414336 1995429792 19.587 100 47 94 1 2023373312 13959488 13984032
18:16:05 36867 8192000000 10922918816 11391590400 1974639632 19.422 99 23 46 0 1999160992 16614896 7906464
18:16:52 30406 8192000000 10921313264 11403276288 1989444368 19.539 100 11 22 0 2005877248 13375056 3057824
18:17:33 29333 8192000000 10909784544 11375128576 1977164528 19.442 99 22 42 2 1993072576 10198784 5709264
18:18:09 60906 8192000000 10915743952 11395420160 1994744864 19.581 100 14 28 1 2008649120 10078416 3825840
18:19:37 46821 8192000000 10950648704 11409965056 2007828416 19.684 100 30 61 1 2024390192 8321936 8239840
18:20:34 74633 8192000000 10919030256 11405524992 2004458832 19.658 100 16 33 0 2019252752 10361648 4432272
18:22:26 80745 8192000000 10918215088 11400552448 1924162976 19.020 96 20 40 0 1943999120 13965376 5870768
18:23:55 58692 8192000000 10922955152 11406344192 1994651024 19.581 100 15 30 0 2012422224 13658736 4112464
18:25:00 36450 8192000000 10917572496 11395751936 1978078864 19.449 99 20 40 0 1990721600 7486064 5156672
18:25:43 78331 8192000000 10927508704 11408424960 1997442080 19.603 100 12 24 0 2010809104 10301200 3065824
18:27:29 41045 8192000000 10907114544 11388002304 1971644592 19.398 99 6 12 1 1982962352 10421488 896272
18:28:18 33915 8192000000 10931353712 11397345280 1961563296 19.318 98 20 40 1 1973421648 6534928 5323424
18:28:58 80494 8192000000 10896336096 11361812480 1926202880 19.037 96 17 34 0 1941509984 10652736 4654368
18:30:47 73099 8192000000 10903577376 11377410048 1911344784 18.917 96 16 32 0 1928697360 13364864 3987712
18:32:14 47181 8192000000 10899847424 11373625344 1954651792 19.264 99 13 26 2 1970364304 12129104 3583408
18:33:12 66309 8192000000 10872012256 11335598080 1851310608 18.433 95 14 28 0 1871300928 15848512 4141808
18:34:25 47967 8192000000 10888258736 11355045888 1912735536 18.929 98 24 48 1 1929595632 10235408 6624688
18:35:19 38692 8192000000 10882847744 11339849728 1896455792 18.798 97 42 84 3 1922060112 13746448 11857872
18:36:12 51720 8192000000 10861294192 11326537728 1860041056 18.504 96 23 46 1 1882644560 16228224 6375280
18:37:16 63070 8192000000 10821561200 11297153024 1767619536 17.747 92 11 22 1 1781046544 10478768 2948240
18:38:45 11668 8192000000 10861183152 11290685440 1874615968 18.622 98 61 122 1 1900155360 8471888 17067504
18:39:06 8152 8192000000 10866140096 11309248512 1910604000 18.911 100 44 89 0 1933662336 10904688 12153648
18:39:20 11229 8192000000 10869718896 11304292352 1883790352 18.696 98 47 94 1 1908841568 12253584 12797632
18:39:41 18725 8192000000 10883799744 11331989504 1925766656 19.033 100 53 106 0 1954477904 14002480 14708768
18:40:08 32148 8192000000 10865870208 11330834432 1907901008 18.890 99 29 58 0 1932761008 16151984 8708016
18:40:55 33336 8192000000 10874814320 11327787008 1907889536 18.890 99 30 60 0 1935643728 18903712 8850480
18:41:36 93082 8192000000 10846059584 11307347968 1898316336 18.813 99 33 66 0 1925799920 17793552 9690032
18:43:50 55514 8192000000 10850919168 11312898048 1881766960 18.679 98 19 38 0 1896034800 8905648 5362192
18:44:56 41612 8192000000 10819062144 11301900288 1891067104 18.754 99 9 18 0 1907450688 14160528 2223056
18:45:44 47626 8192000000 10843494464 11318972416 1921202064 18.996 100 11 22 1 1934663344 10676784 2784496
18:46:40 71931 8192000000 10833877200 11300470784 1875703024 18.630 97 9 18 1 1886179136 7824608 2651504
18:48:05 81019 8192000000 10851220848 11321528320 1893901056 18.777 98 12 24 1 1910372368 12783504 3687808
18:50:19 46573 8192000000 10866632496 11339399168 1938435744 19.134 100 25 50 0 1961812992 15743360 7633888
18:51:39 51572 8192000000 10867427248 11347435520 1925014496 19.027 99 15 29 3 1942931920 13132688 4784736
18:53:18 61640 8192000000 10889059584 11351076864 1899907312 18.826 97 16 32 1 1915204288 10673440 4623536
18:54:29 38864 8192000000 10880366576 11341807616 1910866208 18.914 98 31 61 1 1932635552 13275696 8493648
18:55:33 58911 8192000000 10870188912 11355623424 1914628016 18.944 98 24 48 1 1936072688 14105456 7339216
18:56:38 84712 8192000000 10895478000 11353952256 1892650624 18.767 97 13 26 0 1905972752 9737616 3584512
18:58:09 14825 8192000000 10913463568 11357151232 1941247104 19.157 99 36 72 2 1958033504 7377376 9409024
18:58:31 15743 8192000000 10902891312 11358007296 1954717872 19.264 100 38 75 1 1976319184 11454496 10146816
18:58:54 66483 8192000000 10906585136 11367739392 1900810880 18.833 97 32 64 2 1920636912 11247504 8578528
19:00:18 58900 8192000000 10887132384 11364712448 1923137552 19.012 98 24 48 1 1942302384 12268496 6896336
19:01:42 55287 8192000000 10934659040 11401883648 1978853312 19.456 100 23 46 0 2007445472 21367104 7225056
19:03:01 102748 8192000000 10917943504 11414806528 1943267168 19.173 98 7 14 0 1966696880 21744752 1684960
19:04:50 84743 8192000000 10929487616 11380129792 1924596160 19.024 97 11 22 1 1939774640 12001056 3177424
19:06:22 17492 8192000000 10929166208 11396091904 1985658912 19.509 100 25 50 1 2004890352 12501776 6729664
19:06:48 135825 8192000000 10913769408 11398385664 1984203440 19.498 100 24 48 2 2006560880 15286336 7071104
19:09:10 69628 8192000000 10914334768 11390152704 1982979648 19.488 100 36 71 1 2003835264 11138448 9717168
19:10:29 36736 8192000000 10912774800 11377999872 1963025008 19.330 99 20 40 0 1975370336 7271520 5073808
19:11:17 56638 8192000000 10888857264 11379638272 1943835920 19.177 98 15 30 1 1958232496 10135024 4261552
19:13:04 85970 8192000000 10925119792 11402911744 1996979280 19.599 100 21 41 0 2011650368 8702208 5968880
19:14:46 58182 8192000000 10921440896 11416461312 2001339248 19.633 100 11 22 0 2015577856 10802480 3436128
19:15:50 31967 8192000000 10926052544 11416748032 1982676800 19.486 99 13 25 0 2002578304 16391600 3509904
19:16:28 69920 8192000000 10934620080 11415531520 1986240112 19.514 99 16 32 3 2007103472 16077856 4785504
19:17:44 66039 8192000000 10923487408 11422543872 1996666240 19.596 100 10 20 0 2019113024 19142832 3303952
19:19:14 45680 8192000000 10936670016 11430350848 2014282752 19.735 100 34 68 1 2036837072 12933008 9621312
19:20:16 80228 8192000000 10908608608 11411898368 1926918304 19.042 96 7 14 0 1943112608 14383248 1811056
19:22:17 74963 8192000000 10929204864 11400048640 1968462848 19.373 99 13 26 0 1981898576 9912496 3523232
19:23:42 62176 8192000000 10932493040 11423174656 2000868960 19.630 100 27 54 0 2023118288 14704832 7544496
19:24:55 60324 8192000000 10919490272 11392905216 1960043440 19.306 98 21 41 1 1980742032 14731328 5967264
19:26:02 67190 8192000000 10894850352 11375017984 1917734048 18.969 96 15 30 0 1936170000 13921472 4514480
19:27:30 18072 8192000000 9026970928 9382187008 86181408 1.041 5 2 4 0 89562448 3015456 365584

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 19-06-2021 19:28:41 to 19-06-2021 19:29:13.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-06-2021 19:29:13 to 19-06-2021 19:29: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          237052
MON$OLDEST_ACTIVE               237409
MON$OLDEST_SNAPSHOT             237409
MON$NEXT_TRANSACTION            237409
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                       2054880
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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 ---
:75: 
:76: mscs-test-161.budzdorov.ru    Sat Jun 19 19:27:50 2021
:77:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:78: 
--- end of diff output ---

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

19.06.21 19:29: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
2021-06-19 19:29:19 No severe PSQL-related problems occured
19.06.21 19:29:20. End of report.