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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-25 01:27:20
DTS_END                         2021-02-25 01:27:20.5660
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/39722
TRN_ID                          244079
ATT_ID                          720
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: 9471.29 21293 1136555
customer order: creation 176.67 406 21200
customer order: refuse 15.52 338 1862
order to supplier: creation 47.56 1344 5707
order to supplier: removal 3.66 93543 439
invoice (draft): creation 45.64 3389 5477
invoice (draft): removal 53.19 788 6383
invoice accept: apply 42.58 18285 5110
invoice accept: cancel 48.03 753 5763
customer reserve: creation 4002.36 178 480283
customer reserve: removal 4730.77 56 567692
realization accept: apply 87.04 182 10445
realization accept: cancel 83.98 116 10077
payment from customer: creation 60.88 112 7305
payment from customer: removal 6.02 96 722
payment to supplier: creation 51.28 126 6153
payment to supplier: removal 3.36 73 403
service: total inventory turnovers 4.93 1192 591
service: total monetary turnovers 7.03 26 844
service: aggregate perf. data 0.79 21085 95
service: refresh index statistics 0.03 283772 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 25-02-2021 01:28:32 to 25-02-2021 01:28:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4508
TEST_TIME 2 4833
TEST_TIME 3 5731
TEST_TIME 4 5955
TEST_TIME 5 5531
TEST_TIME 6 5467
TEST_TIME 7 6110
TEST_TIME 8 6454
TEST_TIME 9 6402
TEST_TIME 10 6527
TEST_TIME 11 6494
TEST_TIME 12 6752
TEST_TIME 13 6657
TEST_TIME 14 6783
TEST_TIME 15 7101
TEST_TIME 16 7501
TEST_TIME 17 7498
TEST_TIME 18 8120
TEST_TIME 19 8477
TEST_TIME 20 8489
TEST_TIME 21 8832
TEST_TIME 22 9241
TEST_TIME 23 9527
TEST_TIME 24 10185
TEST_TIME 25 10058
TEST_TIME 26 9944
TEST_TIME 27 9984
TEST_TIME 28 11048
TEST_TIME 29 10900
TEST_TIME 30 10813
TEST_TIME 31 10633
TEST_TIME 32 10643
TEST_TIME 33 10637
TEST_TIME 34 10601
TEST_TIME 35 10556
TEST_TIME 36 10648
TEST_TIME 37 10600
TEST_TIME 38 10406
TEST_TIME 39 10238
TEST_TIME 40 10133
TEST_TIME 41 10116
TEST_TIME 42 10011
TEST_TIME 43 9970
TEST_TIME 44 9977
TEST_TIME 45 9956
TEST_TIME 46 10099
TEST_TIME 47 9955
TEST_TIME 48 9962
TEST_TIME 49 9903
TEST_TIME 50 9736
TEST_TIME 51 9682
TEST_TIME 52 9876
TEST_TIME 53 9789
TEST_TIME 54 9768
TEST_TIME 55 9788
TEST_TIME 56 9885
TEST_TIME 57 9885
TEST_TIME 58 9810
TEST_TIME 59 9829
TEST_TIME 60 9947
TEST_TIME 61 9932
TEST_TIME 62 10116
TEST_TIME 63 10108
TEST_TIME 64 10134
TEST_TIME 65 10112
TEST_TIME 66 9978
TEST_TIME 67 9976
TEST_TIME 68 9920
TEST_TIME 69 9869
TEST_TIME 70 9836
TEST_TIME 71 9775
TEST_TIME 72 9704
TEST_TIME 73 9697
TEST_TIME 74 9634
TEST_TIME 75 9608
TEST_TIME 76 9572
TEST_TIME 77 9577
TEST_TIME 78 9539
TEST_TIME 79 9585
TEST_TIME 80 9626
TEST_TIME 81 9637
TEST_TIME 82 9613
TEST_TIME 83 9606
TEST_TIME 84 9591
TEST_TIME 85 9639
TEST_TIME 86 9698
TEST_TIME 87 9704
TEST_TIME 88 9703
TEST_TIME 89 9645
TEST_TIME 90 9598
TEST_TIME 91 9534
TEST_TIME 92 9538
TEST_TIME 93 9492
TEST_TIME 94 9494
TEST_TIME 95 9469
TEST_TIME 96 9472
TEST_TIME 97 9542
TEST_TIME 98 9492
TEST_TIME 99 9472
TEST_TIME 100 9591
TEST_TIME 101 9600
TEST_TIME 102 9554
TEST_TIME 103 9595
TEST_TIME 104 9660
TEST_TIME 105 9641
TEST_TIME 106 9684
TEST_TIME 107 9678
TEST_TIME 108 9606
TEST_TIME 109 9641
TEST_TIME 110 9620
TEST_TIME 111 9578
TEST_TIME 112 9522
TEST_TIME 113 9470
TEST_TIME 114 9458
TEST_TIME 115 9506
TEST_TIME 116 9588
TEST_TIME 117 9552
TEST_TIME 118 9570
TEST_TIME 119 9528
TEST_TIME 120 9477

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-02-2021 01:28:36 to 25-02-2021 01:28:39.

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 1580026 1580026 0 0.00 0 18680 6 0 0
doc_list_biud 1580026 1580026 0 0.00 0 40647 26 0 0
sp_add_invoice_to_stock 5283 5110 173 3.27 42 191578 18286 0 173
sp_cancel_adding_invoice 5763 5763 0 0.00 6 55580 754 0 0
sp_cancel_client_order 1862 1862 0 0.00 4 10862 339 0 0
sp_cancel_customer_reserve 567692 567692 0 0.00 1 40649 57 0 0
sp_cancel_pay_from_customer 722 722 0 0.00 3 9895 97 0 0
sp_cancel_pay_to_supplier 403 403 0 0.00 3 3482 73 0 0
sp_cancel_supplier_invoice 6392 6383 9 0.14 1 14958 789 0 9
sp_cancel_supplier_order 439 439 0 0.00 10 949476 93543 0 0
sp_cancel_write_off 10077 10077 0 0.00 1 23190 116 0 0
sp_client_order 21200 21200 0 0.00 3 61761 407 0 0
sp_customer_reserve 480283 480283 0 0.00 0 41922 178 0 0
sp_fill_shopping_cart 32383 32383 0 0.00 1 11006 40 0 0
sp_fill_shopping_cart_clo_res 480282 480282 0 0.00 0 17593 15 0 0
sp_get_clo_for_invoice 5105 5105 0 0.00 0 21994 300 0 0
sp_kill_cost_storno 16965 16965 0 0.00 0 10737 56 0 0
sp_kill_qstorno_ret_qs2qd 1152283 1152283 0 0.00 0 40644 31 0 0
sp_kill_qty_storno 607766 607766 0 0.00 0 40647 67 0 0
sp_lock_selected_doc 21516 21516 0 0.00 0 6248 7 0 0
sp_make_cost_storno 29008 29008 0 0.00 0 14503 58 0 0
sp_multiply_rows_for_pdistr 29008 29008 0 0.00 0 6962 26 0 0
sp_multiply_rows_for_qdistr 21200 21200 0 0.00 0 13769 175 0 0
sp_pay_from_customer 7305 7305 0 0.00 4 17582 112 0 0
sp_pay_to_supplier 6153 6153 0 0.00 4 15520 126 0 0
sp_payment_common 13458 13458 0 0.00 1 13370 33 0 0
sp_qd_handle_on_cancel_clo 1862 1862 0 0.00 0 10853 310 0 0
sp_qd_handle_on_invoice_upd_sts 10868 10868 0 0.00 0 29811 318 0 0
sp_qd_handle_on_reserve_upd_sts 10445 10445 0 0.00 0 22972 57 0 0
sp_reserve_write_off 10445 10445 0 0.00 6 23019 183 0 0
sp_supplier_invoice 5477 5477 0 0.00 6 83636 3390 0 0
sp_supplier_order 5707 5707 0 0.00 5 30861 1345 0 0
srv_aggregate_perf_data 95 95 0 0.00 3093 255600 21086 0 0
srv_fill_mon_cache_memory 171 171 0 0.00 968 126610 29718 0 0
srv_find_qd_qs_mism 1086605 1086605 0 0.00 0 18678 6 0 0
srv_make_invnt_saldo 591 591 0 0.00 43 96293 1192 0 0
srv_make_money_saldo 844 844 0 0.00 1 1950 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 154740 352376 283772 0 0
t$perf-abend:sp_add_invoice_to_stock 173 173 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 5111 5111 0 0.00 0 12633 180 0 0
t$perf-norm:sp_cancel_adding_invoice 431 431 0 0.00 0 13225 108 0 0
t$perf-norm:sp_cancel_client_order 1862 1862 0 0.00 0 1965 12 0 0
t$perf-norm:sp_cancel_customer_reserve 698 698 0 0.00 0 1194 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 722 722 0 0.00 0 3019 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 403 403 0 0.00 0 1511 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 424 424 0 0.00 0 816 14 0 0
t$perf-norm:sp_cancel_supplier_order 439 439 0 0.00 0 25511 1510 0 0
t$perf-norm:sp_cancel_write_off 988 988 0 0.00 0 5145 14 0 0
t$perf-norm:sp_client_order 21200 21200 0 0.00 0 13010 23 0 0
t$perf-norm:sp_customer_reserve 969 969 0 0.00 0 4000 10 0 0
t$perf-norm:sp_pay_from_customer 7305 7305 0 0.00 0 9466 14 0 0
t$perf-norm:sp_pay_to_supplier 6153 6153 0 0.00 0 7523 14 0 0
t$perf-norm:sp_reserve_write_off 10445 10445 0 0.00 0 14331 15 0 0
t$perf-norm:sp_supplier_invoice 5477 5477 0 0.00 0 9080 24 0 0
t$perf-norm:sp_supplier_order 5707 5707 0 0.00 0 5402 18 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 657 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 171 171 0 0.00 0 4239 44 0 0
t$perf-norm:srv_make_invnt_saldo 591 591 0 0.00 0 7695 32 0 0
t$perf-norm:srv_make_money_saldo 844 844 0 0.00 0 5485 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10552 10206 346 3.27 0 5041 20 0 346
v_all_customers 38248 38248 0 0.00 0 47 1 0 0
v_all_suppliers 31360 31360 0 0.00 0 19 1 0 0
v_all_wares 42400 42400 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 862 862 0 0.00 0 2111 11 0 0
v_cancel_client_order 3724 3724 0 0.00 0 5463 6 0 0
v_cancel_customer_prepayment 1444 1444 0 0.00 0 4282 12 0 0
v_cancel_customer_reserve 1396 1396 0 0.00 0 833 5 0 0
v_cancel_payment_to_supplier 806 806 0 0.00 0 749 4 0 0
v_cancel_supplier_invoice 866 848 18 2.07 0 1227 16 0 18
v_cancel_supplier_order 878 878 0 0.00 0 2981 15 0 0
v_cancel_write_off 1976 1976 0 0.00 0 4614 21 0 0
v_max_id_clo_ord 5706 5706 0 0.00 0 1242 2 0 0
v_max_id_clo_res 969 969 0 0.00 0 4523 16 0 0
v_max_id_ord_sup 5477 5477 0 0.00 0 6462 6 0 0
v_max_non_paid_invoice 1656 1656 0 0.00 0 592 3 0 0
v_max_non_paid_realizn 4037 4037 0 0.00 0 4383 5 0 0
v_min_id_clo_ord 5706 5706 0 0.00 0 3968 10 0 0
v_min_id_clo_res 969 969 0 0.00 0 3738 9 0 0
v_min_id_ord_sup 5477 5477 0 0.00 0 7779 16 0 0
v_min_non_paid_invoice 6153 6153 0 0.00 0 10471 23 0 0
v_min_non_paid_realizn 7305 7305 0 0.00 0 13360 20 0 0
v_our_firm 10688 10688 0 0.00 0 22 1 0 0
v_reserve_write_off 20888 20888 0 0.00 0 11837 8 0 0
x_lock_depdocs_on_canc_invoice 11722 11722 0 0.00 0 16981 108 0 0
x_lock_depdocs_on_canc_sup_ord 439 439 0 0.00 0 19584 397 0 0
x_make_qstorno_1000_1200 5707 5707 0 0.00 1 30854 1263 0 0
x_make_qstorno_1200_2000 5477 5477 0 0.00 3 77265 3245 0 0
x_make_qstorno_2100_3300 480283 480283 0 0.00 0 35230 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-02-2021 01:28:40 to 25-02-2021 01:28:44.

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:24 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:30 20269 8192000000 10215111040 10522615808 951155520 10.402 73 59 119 0 974294384 2834336 20304528
22:58:02 19458 8192000000 10306046864 10620055552 1363868304 14.272 100 81 162 0 1395722336 4887280 26966752
22:58:29 30867 8192000000 10351827072 10668421120 1394139440 14.543 100 88 176 0 1429622736 5933376 29549920
22:59:12 23237 8192000000 10376869984 10697420800 1430562096 14.866 100 91 182 0 1467393120 7120064 29710960
22:59:46 15937 8192000000 10386084880 10710138880 1443021968 14.976 100 91 182 0 1480872320 7780336 30070016
23:00:16 15903 8192000000 10413255584 10739834880 1458496256 15.113 100 85 170 0 1493961632 8015312 27450064
23:00:41 15783 8192000000 10424104592 10754420736 1482886832 15.327 100 80 161 0 1517458336 8562096 26009408
23:01:04 7277 8192000000 10447175776 10780831744 1503548528 15.507 100 87 174 1 1543947904 13165280 27234096
23:01:32 14195 8192000000 10474432240 10812719104 1527695296 15.717 100 84 168 0 1563658560 9602544 26360720
23:01:55 16876 8192000000 10505547472 10851905536 1553306576 15.939 100 79 158 0 1587627680 10165808 24155296
23:02:19 15978 8192000000 10544178736 10895486976 1592873504 16.278 100 80 160 1 1627696608 10240240 24582864
23:02:48 12184 8192000000 10566139568 10925842432 1624253200 16.546 100 78 156 0 1658989744 11416336 23320208
23:03:12 11821 8192000000 10603356992 10963304448 1655726176 16.813 100 88 176 1 1694086528 12406560 25953792
23:03:31 9710 8192000000 10619338448 10981433344 1669969296 16.933 100 86 172 0 1708626224 13218896 25438032
23:03:50 11773 8192000000 10620209728 10984300544 1679403248 17.012 100 85 170 0 1718360144 13481760 25475136
23:04:09 10621 8192000000 10629848656 10997620736 1691994240 17.118 100 82 164 0 1729572592 13557648 24020704
23:04:30 8850 8192000000 10644063536 11017945088 1713022192 17.294 100 84 164 0 1749728672 13170256 23536224
23:04:47 6165 8192000000 10667816576 11037458432 1722278448 17.371 100 80 159 0 1758037680 13147280 22611952
23:04:59 4006 8192000000 10670117520 11046969344 1735150336 17.478 100 76 152 0 1768246432 11568784 21527312
23:05:10 5550 8192000000 10687900416 11064369152 1751235888 17.612 100 79 158 1 1785810112 12209248 22364976
23:05:23 4529 8192000000 10684791024 11064844288 1756688800 17.657 100 78 156 0 1791591808 12655552 22247456
23:05:34 4282 8192000000 10707722384 11089063936 1767722896 17.748 100 72 146 0 1799697104 11193920 20780288
23:05:46 3222 8192000000 10725560816 11101650944 1784316480 17.885 100 81 163 1 1820732720 12310112 24106128
23:05:57 4689 8192000000 10723884176 11108569088 1789744080 17.930 100 79 158 1 1824535296 12374384 22416832
23:06:08 4476 8192000000 10738550624 11121160192 1797254496 17.991 100 82 164 2 1832759920 12837440 22667984
23:06:19 3129 8192000000 10738301680 11121995776 1799572944 18.010 100 79 156 1 1833392704 12854560 20965200
23:06:28 3571 8192000000 10750920544 11129843712 1808670224 18.085 100 87 174 1 1845977184 14202592 23104368
23:06:38 5910 8192000000 10744990160 11130953728 1806900672 18.070 100 81 160 1 1843687936 15121664 21665600
23:06:51 2719 8192000000 10754656016 11139883008 1821378112 18.189 100 89 178 0 1859925248 13741760 24805376
23:07:01 1894 8192000000 10760462912 11147808768 1822148000 18.195 100 82 165 0 1858959776 12934704 23877072
23:07:09 2039 8192000000 10776273248 11156078592 1830521296 18.264 100 90 181 0 1869436848 13651232 25264320
23:07:18 1619 8192000000 10781778784 11166658560 1838874048 18.332 100 96 193 0 1880352144 13650672 27827424
23:07:26 1311 8192000000 10787760704 11172888576 1845373664 18.385 100 92 185 2 1885569904 13825488 26370752
23:07:34 2416 8192000000 10799791616 11186008064 1855136080 18.464 100 87 175 2 1892867680 13612384 24119216
23:07:42 1477 8192000000 10796612112 11185422336 1855712672 18.469 100 89 179 0 1894168736 13365584 25090480
23:07:50 1758 8192000000 10807969360 11196133376 1861247936 18.513 100 94 187 1 1901210768 13362048 26600784
23:07:58 1514 8192000000 10803428304 11193655296 1861956656 18.519 100 88 174 1 1899553968 12960256 24637056
23:08:06 1431 8192000000 10803735568 11195666432 1863006320 18.528 100 93 186 2 1903272944 13506592 26760032
23:08:14 16022 8192000000 10807948304 11197489152 1865129792 18.545 100 77 154 0 1897978608 10853744 21995072
23:08:36 2033 8192000000 10802240784 11206295552 1868964448 18.576 100 74 148 0 1901816512 11889472 20962592
23:08:44 3251 8192000000 10812795488 11209039872 1870127184 18.585 100 73 145 2 1902427440 12253872 20046384
23:08:54 2992 8192000000 10789066912 11202400256 1870010576 18.584 100 53 105 1 1895334064 10142768 15180720
23:09:03 2708 8192000000 10795931280 11206819840 1870729408 18.590 100 37 75 0 1889547856 8468592 10349856
23:09:12 4838 8192000000 10791039232 11209576448 1873674560 18.614 100 45 90 0 1896367872 10065600 12627712
23:09:26 7451 8192000000 10795419024 11212054528 1874253584 18.619 100 31 61 0 1890449472 7124912 9070976
23:09:40 10141 8192000000 10786680000 11214589952 1883267312 18.691 100 43 85 2 1902604256 7508336 11828608
23:09:57 45545 8192000000 10809853920 11227541504 1882008528 18.681 100 26 52 2 1894435408 4687584 7739296
23:10:49 24486 8192000000 10787557920 11226996736 1885392416 18.709 100 24 48 1 1898281120 6254256 6634448
23:11:22 7212 8192000000 10808076224 11237658624 1889898912 18.745 100 25 49 1 1907544240 10257072 7388256
23:11:39 7432 8192000000 10807549104 11240628224 1893644624 18.775 100 32 64 2 1910202608 7469264 9088720
23:11:54 11792 8192000000 10810223920 11237261312 1897291680 18.805 100 16 32 0 1907206576 5522080 4392816
23:12:12 7323 8192000000 10820509808 11243343872 1898073408 18.811 100 32 63 2 1913717408 6244192 9399808
23:12:27 6663 8192000000 10800322672 11237388288 1894354224 18.781 100 22 42 1 1906940800 5963904 6622672
23:12:43 5557 8192000000 10801745024 11238125568 1895668192 18.791 100 29 58 4 1909919072 5854528 8396352
23:13:01 7562 8192000000 10812478608 11243008000 1898073552 18.811 100 24 49 2 1910524720 5761168 6690000
23:13:16 5556 8192000000 10803952912 11241365504 1898047872 18.811 100 27 54 0 1912380048 6264240 8067936
23:13:30 9923 8192000000 10809168560 11243896832 1896887136 18.801 100 15 30 0 1906071360 4994560 4189664
23:13:47 8719 8192000000 10793872880 11224121344 1879895760 18.664 99 21 42 3 1892188592 6197200 6095632
23:14:04 5006 8192000000 10810636176 11242401792 1896639424 18.799 100 19 38 3 1907893712 5848528 5405760
23:14:21 13524 8192000000 10811030176 11248971776 1904569280 18.863 100 28 55 3 1919105792 6089824 8446688
23:14:41 61628 8192000000 10818447536 11232583680 1869488336 18.580 98 39 78 0 1886306176 4158272 12659568
23:15:50 21487 8192000000 10811715168 11251146752 1898113024 18.811 100 16 32 0 1908364080 5825168 4425888
23:16:19 6289 8192000000 10821914080 11258896384 1909103360 18.899 100 36 67 0 1927275088 8225264 9946464
23:16:33 8025 8192000000 10816356672 11243380736 1878976000 18.657 99 33 61 2 1894797392 6831408 8989984
23:16:51 6880 8192000000 10812453984 11233595392 1870857952 18.591 99 34 68 1 1886930416 5441600 10630864
23:17:06 7503 8192000000 10803508672 11237011456 1877725824 18.647 99 33 65 2 1894033616 6912160 9395632
23:17:20 5654 8192000000 10823039168 11255033856 1901507920 18.838 100 38 74 5 1919025696 7017136 10500640
23:17:34 7907 8192000000 10805923456 11235655680 1887739200 18.728 100 21 43 0 1899416240 5612560 6064480
23:17:50 11358 8192000000 10748178656 11178659840 1740974640 17.527 92 19 40 2 1751509792 4833984 5701168
23:18:08 6218 8192000000 10742049648 11158298624 1759663296 17.682 95 29 56 2 1772840736 5199248 7978192
23:18:26 14046 8192000000 10698965328 11121631232 1735702320 17.483 95 17 32 1 1746129056 5207680 5219056
23:18:48 7503 8192000000 10740292880 11162931200 1797998032 17.997 98 25 50 3 1810975312 6542288 6434992
23:19:04 16251 8192000000 10737332912 11152891904 1726405840 17.406 94 16 32 0 1736565696 5303200 4856656
23:19:32 47341 8192000000 10715364704 11119976448 1697502128 17.164 94 25 51 0 1709562528 5260000 6800400
23:20:36 18834 8192000000 10698592176 11120214016 1682763904 17.041 93 12 22 4 1690602240 4324832 3513504
23:21:01 4748 8192000000 10689924528 11108003840 1753169120 17.628 98 29 58 0 1768485856 6155088 9161648
23:21:12 10722 8192000000 10691651296 11114475520 1751889248 17.617 98 20 40 0 1763957440 6543248 5524944
23:21:28 5975 8192000000 10694619680 11104620544 1720640112 17.358 96 39 78 1 1737268576 5897472 10730992
23:21:42 7872 8192000000 10706581312 11118170112 1765425840 17.729 99 29 58 0 1783600656 10448480 7726336
23:21:56 8761 8192000000 10693183968 11104862208 1750259792 17.604 98 21 42 0 1762343776 5858624 6225360
23:22:15 3927 8192000000 10718864624 11131846656 1792422160 17.952 100 25 50 2 1804341312 5013648 6905504
23:22:28 8683 8192000000 10732674032 11154247680 1813796448 18.127 100 23 46 2 1826443904 5566672 7080784
23:22:43 8797 8192000000 10753760848 11171495936 1815223184 18.139 99 30 59 2 1829943088 6137392 8582512
23:23:03 8923 8192000000 10761832848 11187359744 1842092496 18.358 100 19 38 0 1853176064 5892368 5191200
23:23:19 8945 8192000000 10770844512 11192332288 1846994880 18.398 100 21 41 1 1858338496 5288928 6054688
23:23:38 11238 8192000000 10768053184 11194322944 1851089808 18.431 100 26 52 3 1864048448 5117344 7841296
23:23:55 3842 8192000000 10764835984 11189088256 1836145296 18.309 99 27 54 1 1849722560 5353936 8223328
23:24:05 6215 8192000000 10755621920 11179077632 1834206592 18.294 99 31 62 0 1849062768 6461328 8394848
23:24:20 49094 8192000000 10783972128 11204087808 1857021712 18.479 100 25 49 1 1869688736 5351584 7315440
23:25:22 27038 8192000000 10764634368 11203436544 1861198928 18.513 100 25 51 4 1875082000 6384016 7499056
23:25:56 10566 8192000000 10797640560 11214864384 1864037408 18.536 100 33 66 1 1879624608 6831872 8755328
23:26:16 8228 8192000000 10785482912 11218878464 1868424624 18.572 100 26 52 0 1886982528 10465616 8092288
23:26:31 8354 8192000000 10795917328 11214827520 1868504832 18.572 100 24 48 2 1881647168 5625104 7517232
23:26:45 6415 8192000000 10789769904 11219222528 1871663184 18.598 100 26 49 2 1884762976 5378176 7721616
23:27:00 6307 8192000000 10817322672 11236241408 1886047056 18.714 100 41 82 0 1901827920 5128336 10652528
23:27:13 9000 8192000000 10805891248 11234631680 1891142288 18.755 100 18 36 0 1901735168 5184128 5408752
23:27:34 9772 8192000000 10842090304 11256242176 1907441408 18.886 100 47 94 2 1926592128 5381552 13769168
23:27:57 22318 8192000000 10858958096 11277778944 1917546688 18.967 100 51 100 2 1943972864 12392688 14033488
23:28:37 23534 8192000000 10862038144 11288887296 1928713728 19.057 100 51 102 1 1954980528 12657808 13608992
23:29:07 3069 8192000000 10865169120 11288166400 1932969792 19.091 100 54 108 0 1959485280 11579984 14935504
23:29:24 18673 8192000000 10879733232 11302043648 1936538048 19.119 100 57 114 1 1965704640 13255104 15911488
23:29:51 19697 8192000000 10877913888 11302649856 1943226624 19.172 100 54 105 0 1973423968 14912400 15284944
23:30:53 53986 8192000000 10877415360 11322880000 1950775776 19.233 100 34 67 3 1977884688 17151856 9957056
23:32:09 17801 8192000000 10888016544 11328516096 1958896736 19.297 100 36 72 2 1984103376 14064256 11142384
23:32:34 15306 8192000000 10902213424 11336466432 1964640352 19.343 100 47 94 1 1993362816 14843536 13878928
23:32:58 11799 8192000000 10909586672 11334078464 1949352256 19.221 99 47 94 0 1977393088 15305680 12735152
23:33:19 5713 8192000000 10913385824 11338256384 1968437312 19.373 100 60 116 2 2001699120 16685248 16576560
23:33:32 2933 8192000000 10923496144 11348287488 1974798848 19.423 100 66 131 2 2011256752 17705296 18752608
23:33:42 5161 8192000000 10926009472 11348602880 1974880896 19.424 100 64 126 1 2010966240 17827872 18257472
23:33:54 12977 8192000000 10927796816 11347681280 1975594384 19.430 100 65 130 3 2014686320 20480208 18611728
23:34:22 8763 8192000000 10915468208 11348770816 1952042288 19.243 99 52 104 4 1987521120 20697600 14781232
23:34:41 6400 8192000000 10920567600 11348811776 1973742160 19.415 100 63 123 1 2012979120 21438736 17798224
23:34:55 2993 8192000000 10933332208 11364016128 1982454368 19.484 100 60 118 0 2021317120 20882352 17980400
23:35:07 15191 8192000000 10935559248 11367489536 1981295536 19.475 100 56 111 3 2019009360 22005792 15708032
23:35:32 3013 8192000000 10943248624 11368914944 1988958672 19.536 100 69 129 1 2028033728 19813360 19261696
23:35:42 3848 8192000000 10940791024 11365945344 1983768672 19.495 100 55 109 0 2020425680 20652096 16004912
23:35:53 11979 8192000000 10943622176 11373867008 1991859552 19.558 100 62 125 1 2031983296 22059312 18064432
23:36:16 13074 8192000000 10957512608 11385020416 1996378912 19.594 100 60 122 0 2038086560 24291728 17415920
23:36:42 14970 8192000000 10947525792 11384758272 1999209936 19.617 100 63 125 1 2043322752 25450096 18662720
23:37:05 5547 8192000000 10946001536 11386695680 2001564720 19.635 100 58 116 0 2044844944 25897920 17382304
23:37:21 7802 8192000000 10943463696 11379445760 1974101952 19.418 99 60 116 0 2022701632 30558544 18041136
23:37:39 4428 8192000000 10950284240 11378868224 1994799808 19.582 100 65 130 0 2040557472 25923040 19834624
23:37:53 7568 8192000000 10956300544 11388952576 1995617664 19.588 100 58 113 1 2044240192 31202800 17419728
23:38:09 3657 8192000000 10956936880 11388850176 2000147392 19.624 100 61 123 2 2046026832 27020048 18859392
23:38:22 9846 8192000000 10965389936 11394985984 2004961088 19.662 100 60 120 2 2050803712 27694208 18148416
23:38:40 15406 8192000000 10971468720 11409666048 2010505648 19.705 100 58 115 2 2058229792 29320832 18403312
23:39:03 5699 8192000000 10960954640 11396829184 2008664736 19.691 100 56 112 1 2048155520 22393408 17097376
23:39:18 17208 8192000000 10961975440 11403591680 1990793856 19.550 99 47 94 1 2035818144 29998112 15026176
23:39:42 10121 8192000000 10959925984 11399974912 2005215120 19.664 100 53 109 0 2049408096 27429952 16763024
23:40:02 3834 8192000000 10966393296 11398623232 2003991648 19.654 100 58 114 0 2050667824 28939568 17736608
23:40:16 5067 8192000000 10967953504 11399925760 2006585056 19.675 100 66 132 0 2056977840 30195760 20197024
23:40:29 7646 8192000000 10967348960 11399000064 2001307872 19.633 100 57 113 1 2050839888 31196592 18335424
23:40:44 4708 8192000000 10962743200 11390443520 1991481888 19.556 99 67 133 1 2043962768 31481264 20999616
23:41:00 3640 8192000000 10970209664 11399536640 2002879984 19.645 100 77 151 1 2058902944 32568096 23454864
23:41:12 1662 8192000000 10967220832 11394113536 1998601600 19.612 100 67 132 0 2052660992 33781568 20277824
23:41:22 965 8192000000 10969183568 11387760640 1983458752 19.492 99 83 164 0 2043438400 34661552 25318096
23:41:31 7548 8192000000 10953358736 11381592064 1984496224 19.500 100 67 134 0 2040976464 35908336 20571904
23:41:47 3391 8192000000 10979569008 11394875392 1997223296 19.601 100 85 171 1 2062774160 39418624 26132240
23:41:57 3238 8192000000 10984961744 11399782400 2003596912 19.651 100 83 165 2 2064440944 35722624 25121408
23:42:07 3192 8192000000 10979403440 11400454144 2002667216 19.644 100 78 155 1 2061440752 35007136 23766400
23:42:17 1994 8192000000 10966460112 11380424704 1987420144 19.523 99 79 157 1 2044520880 33336928 23763808
23:42:27 2087 8192000000 10977258368 11394879488 2004088144 19.655 100 87 172 0 2065383376 34865088 26430144
23:42:36 2387 8192000000 10976898656 11389509632 1990487184 19.548 99 82 161 2 2050123648 35037520 24598944
23:42:46 3423 8192000000 10979120368 11403177984 2004665984 19.660 100 67 134 0 2062227968 37133328 20428656
23:42:56 2161 8192000000 10991008640 11404951552 2007435248 19.681 100 85 171 0 2070690576 36741424 26513904
23:43:05 7210 8192000000 10978305552 11402665984 2001721088 19.636 100 72 144 2 2061325792 37052752 22551952
23:43:19 1658 8192000000 10966766832 11386564608 1990251200 19.546 100 86 172 5 2054699536 37659856 26788480
23:43:27 3082 8192000000 10963348432 11376693248 1967734416 19.367 99 88 173 3 2032159760 38734560 25690784
23:43:38 1759 8192000000 10984505936 11396947968 1995158480 19.585 100 90 180 0 2063198976 40726160 27314336
23:43:46 1860 8192000000 10987555216 11400908800 2001732544 19.636 100 88 175 1 2068815360 40015088 27067728
23:43:55 1766 8192000000 10975920544 11394535424 1997756400 19.605 100 90 179 1 2065348576 40445248 27146928
23:44:07 7665 8192000000 10972810128 11391750144 1993263328 19.570 100 71 139 3 2053495728 38888704 21343696
23:44:24 3670 8192000000 10955231328 11379003392 1956634864 19.279 98 71 141 1 2018780880 39704640 22441376
23:44:35 9376 8192000000 10943812640 11365822464 1965315984 19.348 100 72 144 0 2029423216 41216272 22890960
23:44:53 2787 8192000000 10951826032 11374649344 1970748848 19.391 100 68 135 0 2034319056 42074992 21495216
23:45:03 3090 8192000000 10975331408 11392266240 1985805712 19.511 100 82 164 2 2057064928 45638272 25620944
23:45:12 3390 8192000000 10981542912 11396157440 1987813040 19.527 100 80 160 1 2058003840 45409120 24781680
23:45:23 1671 8192000000 10985002864 11405758464 1992044016 19.560 100 85 170 0 2066883376 48740368 26098992
23:45:35 3834 8192000000 10950964080 11381948416 1971529040 19.398 99 68 132 2 2035045984 43388384 20128560
23:46:04 5309 8192000000 10952039152 11382943744 1973541696 19.414 100 63 126 1 2034844368 40967776 20334896
23:46:16 6211 8192000000 10933960272 11364745216 1942911344 19.170 98 57 113 1 1996327968 35370736 18045888
23:46:31 4788 8192000000 10945292016 11371409408 1973823168 19.416 100 60 118 3 2027581712 35834912 17923632
23:46:46 5812 8192000000 10964876448 11379830784 1978546608 19.453 100 70 137 1 2037170560 36879200 21744752
23:47:00 4089 8192000000 10940711664 11369328640 1970302528 19.388 100 54 108 0 2023441072 36401632 16736912
23:47:18 4312 8192000000 10953862128 11377704960 1969482272 19.381 100 57 112 1 2029351392 42270960 17598160
23:47:31 4799 8192000000 10962442624 11385962496 1976084608 19.434 100 67 134 0 2037969632 40380624 21504400
23:47:45 3363 8192000000 10957992608 11388665856 1964559840 19.342 99 62 124 3 2029204016 44474064 20170112
23:48:01 1825 8192000000 10948849360 11380166656 1972443968 19.405 100 59 117 0 2035195856 43499344 19252544
23:48:11 4279 8192000000 10955301264 11387076608 1972347232 19.404 100 56 112 1 2036044608 45355968 18341408
23:48:24 5502 8192000000 10938293888 11375411200 1951740384 19.240 99 47 94 1 2011296608 44474272 15081952
23:48:37 8839 8192000000 10951067760 11391803392 1975863840 19.432 100 42 84 1 2034252112 44605200 13783072
23:49:00 11607 8192000000 10941674928 11389874176 1956865872 19.281 99 35 70 1 2017053568 48475088 11712608
23:49:26 16181 8192000000 10907862144 11357294592 1919520128 18.983 98 24 48 1 1975554064 47220352 8813584
23:49:52 17784 8192000000 10912249888 11354312704 1907210416 18.884 98 31 61 1 1961503408 42827664 11465328
23:50:18 8877 8192000000 10914168240 11350126592 1941902240 19.162 100 30 60 2 1993755552 41753568 10099744
23:50:33 9228 8192000000 10908006240 11347152896 1938718272 19.137 100 40 78 1 1993024768 40617536 13688960
23:50:51 10395 8192000000 10905258320 11346575360 1922922208 19.010 99 28 55 0 1974005408 41593648 9489552
23:51:13 10902 8192000000 10921018096 11363024896 1946519472 19.199 100 42 84 0 2008291568 48188832 13583264
23:51:37 19049 8192000000 10922383840 11369377792 1948334944 19.213 100 24 48 0 1996780096 40424336 8020816
23:52:08 31573 8192000000 10878012000 11327197184 1911733744 18.921 99 14 28 0 1947632240 31209840 4688656
23:53:15 47904 8192000000 10856305264 11304996864 1852379440 18.441 96 23 46 1 1891863392 32001392 7482560
23:54:10 41082 8192000000 10864249040 11314352128 1885353104 18.708 99 15 31 1 1928293888 36732144 6208640
23:54:58 29728 8192000000 10856316800 11309117440 1890494832 18.750 100 12 24 0 1941392720 46430736 4467152
23:55:34 28691 8192000000 10844021456 11300212736 1905218528 18.868 100 9 18 2 1937035344 28925376 2891440
23:56:10 36916 8192000000 10823221888 11266117632 1833361296 18.287 96 23 46 1 1847737952 7230384 7146272
23:56:56 76405 8192000000 10861220304 11301974016 1902970224 18.850 99 26 50 3 1919201024 9735760 6495040
23:58:30 45575 8192000000 10880190272 11332710400 1948658800 19.216 100 20 40 1 1961180064 7465680 5055584
23:59:21 60882 8192000000 10876290928 11347996672 1931617328 19.080 99 17 34 1 1950060464 13437424 5005712
00:00:28 124287 8192000000 10879195888 11339726848 1851007952 18.430 95 5 10 0 1863779136 11945232 825952
00:02:42 88883 8192000000 10873412848 11334844416 1890688128 18.751 97 9 18 1 1907727680 14619312 2420240
00:04:51 112057 8192000000 10903326416 11351502848 1957335200 19.285 100 33 66 1 1977864240 10437760 10091280
00:06:58 85538 8192000000 10915900304 11378307072 1955174000 19.268 99 40 80 3 1983388176 17528576 10685600
00:08:58 42371 8192000000 10886067600 11334541312 1942674448 19.168 98 30 59 1 1959319872 8092640 8552784
00:09:49 13447 8192000000 10925892720 11370856448 1981137904 19.474 100 49 99 1 2004644928 9750448 13756576
00:10:10 22794 8192000000 10913068048 11376119808 1986608304 19.517 100 34 66 1 2005984160 9255376 10120480
00:10:39 21204 8192000000 10927191904 11388956672 1992680464 19.565 100 31 62 1 2012535424 10583600 9271360
00:11:07 33309 8192000000 10931732720 11391856640 1977706416 19.447 99 40 80 1 2003627776 13026128 12895232
00:11:48 30297 8192000000 10940415200 11390713856 1995920256 19.591 100 33 66 1 2018693824 12409040 10364528
00:12:29 54045 8192000000 10929801424 11403706368 1999184160 19.616 100 29 56 1 2023865376 15628080 9053136
00:15:05 31008 8192000000 10886347568 11357810688 1946044992 19.195 98 11 22 0 1957942416 8790544 3106880
00:15:43 39890 8192000000 10893504352 11370954752 1972244368 19.403 100 8 16 0 1988422480 13957872 2220240
00:16:30 69876 8192000000 10900441840 11373531136 1941468096 19.158 98 16 33 0 1958272816 12098736 4705984
00:18:00 45011 8192000000 10905634560 11371835392 1942749360 19.169 98 30 58 0 1967680144 16522736 8408048
00:19:00 51329 8192000000 10881889856 11388661760 1963238448 19.332 100 11 23 0 1988154800 21297328 3619024
00:20:03 21876 8192000000 10877460080 11370647552 1959230736 19.300 100 9 18 0 1973551408 11674240 2646432
00:21:11 40347 8192000000 10912741888 11367686144 1951795264 19.241 99 31 62 1 1970860464 9936592 9128608
00:22:04 35338 8192000000 10891558720 11364974592 1939186064 19.140 98 28 56 2 1957695568 10628256 7881248
00:22:54 49279 8192000000 10890139776 11361828864 1917164368 18.964 98 18 38 0 1936830384 14609872 5056144
00:24:14 37370 8192000000 10901613120 11369955328 1925670432 19.032 98 19 38 1 1945870800 14249424 5950944
00:25:42 54408 8192000000 10881609680 11344121856 1871401120 18.596 95 23 46 0 1891435920 13331232 6703568
00:26:44 71221 8192000000 10880311072 11359780864 1878985136 18.657 96 17 34 1 1898155664 14390784 4779744
00:28:28 76157 8192000000 10887374880 11370708992 1936547296 19.119 99 9 18 1 1953512288 14302672 2662320
00:29:57 86589 8192000000 10870704208 11333402624 1861113584 18.512 95 6 12 0 1873597456 10939472 1544400
00:31:30 83711 8192000000 10874665888 11344089088 1849058736 18.414 95 10 20 0 1862423216 11031760 2332720
00:33:08 122762 8192000000 10883769664 11368210432 1958142112 19.291 100 28 56 0 1978780464 12243216 8395136
00:35:22 18313 8192000000 10874643520 11360272384 1921951648 19.002 98 13 26 1 1936181984 10853376 3376960
00:35:52 9054 8192000000 10871811728 11359993856 1951551632 19.239 100 5 10 1 1963093152 10462016 1079504
00:36:10 23448 8192000000 10884789776 11351076864 1961904032 19.321 100 38 76 0 1980198592 6516384 11778176
00:36:42 39474 8192000000 10850190736 11330220032 1936130256 19.116 99 19 37 0 1949604368 8215216 5258896
00:37:37 63169 8192000000 10875782720 11363205120 1940978896 19.155 99 10 21 0 1963505008 20047168 2478944
00:38:47 24498 8192000000 10887395472 11370930176 1962371344 19.325 100 9 18 0 1981293648 16763472 2158832
00:39:17 59577 8192000000 10868276240 11347673088 1910006528 18.907 97 17 34 1 1926625840 11740496 4878816
00:40:29 48635 8192000000 10848517920 11327631360 1902628176 18.847 98 9 18 0 1915538736 10020880 2889680
00:41:25 48781 8192000000 10843582448 11316715520 1916040944 18.955 99 20 40 1 1930643088 8630176 5971968
00:42:24 66704 8192000000 10840855104 11318116352 1907240512 18.884 98 14 28 1 1920780768 9539248 4001008
00:43:41 44759 8192000000 10842241952 11314655232 1870625216 18.589 97 12 24 1 1881292560 7211392 3455952
00:44:35 68468 8192000000 10885798624 11350163456 1924460640 19.023 99 25 50 1 1941418224 9486992 7470592
00:46:06 67039 8192000000 10835407904 11318566912 1857477376 18.483 96 16 32 0 1875712720 13820432 4414912
00:47:19 70120 8192000000 10880727264 11346759680 1917761296 18.969 99 23 46 1 1935402000 10347984 7292720
00:48:38 70400 8192000000 10889077456 11347394560 1860771136 18.510 95 25 50 2 1876753616 8305184 7677296
00:49:56 31529 8192000000 10874610688 11334696960 1886968992 18.721 97 24 48 1 1903183712 9864400 6350320
00:50:38 22563 8192000000 10880627664 11332599808 1921230912 18.997 99 36 71 0 1940372560 9344752 9796896
00:51:08 22487 8192000000 10903919712 11348561920 1910313152 18.909 98 58 116 0 1938747808 12549856 15884800
00:51:37 12391 8192000000 10895709824 11343376384 1927850448 19.050 99 56 112 2 1956782800 13404624 15527728
00:51:58 11220 8192000000 10910151968 11354660864 1946071008 19.195 100 58 116 1 1974601520 12937744 15592768
00:52:15 57121 8192000000 10892734352 11350544384 1897986464 18.810 97 46 92 0 1928578144 17750624 12841056
00:53:28 77824 8192000000 10866687632 11325562880 1918637280 18.976 98 18 36 1 1937542576 13413184 5492112
00:54:53 18237 8192000000 10874477488 11340668928 1928422624 19.054 99 26 53 2 1943077584 6951712 7703248
00:55:55 38789 8192000000 10909866656 11363586048 1930335696 19.070 98 57 114 0 1953708096 7231984 16140416
00:56:40 92554 8192000000 10893213008 11372449792 1968875488 19.377 100 43 86 0 1992690896 11663328 12152080
00:58:59 42503 8192000000 10892366976 11378139136 1968497392 19.374 100 11 22 1 1982923040 11634448 2791200
00:59:52 36619 8192000000 10886602304 11375972352 1954828704 19.265 99 7 14 1 1968245056 11336960 2079392
01:00:35 29831 8192000000 10889044576 11375210496 1956787312 19.280 99 9 18 0 1968098704 9140976 2170416
01:01:11 22439 8192000000 10891321456 11380088832 1974968288 19.425 100 8 16 0 1985167360 8058288 2140784
01:01:39 36803 8192000000 10897551472 11372056576 1934711712 19.105 98 3 6 0 1941372384 6219280 441392
01:02:31 19697 8192000000 10895892096 11361099776 1925287344 19.029 97 31 62 0 1942278112 7933376 9057392
01:02:58 28922 8192000000 10898707888 11376418816 1958243872 19.292 99 25 50 3 1976449504 11175888 7029744
01:03:33 84092 8192000000 10915956032 11405471744 1965907808 19.353 99 21 42 0 1989281536 17385792 5987936
01:05:07 62037 8192000000 10889494096 11355185152 1900440080 18.830 96 14 28 2 1921652560 17325776 3886704
01:06:23 61556 8192000000 10884782624 11347701760 1881554256 18.678 96 30 59 3 1904547056 14576416 8416384
01:07:39 63790 8192000000 10869449664 11339608064 1873282416 18.611 96 11 22 0 1892439856 16246160 2911280
01:08:59 44818 8192000000 10909251136 11368710144 1947281168 19.205 99 30 60 2 1972321664 15647232 9393264
01:10:05 40943 8192000000 10906779520 11380436992 1951629152 19.239 99 58 116 2 1984663344 16311024 16723168
01:11:17 72656 8192000000 10879168528 11334828032 1879183984 18.659 96 20 40 0 1900702480 16328864 5189632
01:12:43 62258 8192000000 10882457056 11362779136 1949711728 19.224 100 21 42 0 1967676032 11902976 6061328
01:13:55 55435 8192000000 10898549456 11366563840 1938701008 19.136 99 10 20 0 1952253904 10736688 2816208
01:14:58 126610 8192000000 10883994640 11375382528 1950174592 19.228 99 30 60 2 1971514736 12554992 8785152
01:17:19 45207 8192000000 10886636704 11385069568 1959629648 19.303 100 10 20 2 1984444688 21920400 2894640
01:18:19 18319 8192000000 10892258640 11372544000 1962811744 19.328 100 7 14 0 1980280768 15313616 2155408
01:18:45 67078 8192000000 10882627616 11364188160 1920304976 18.989 97 14 29 1 1940786784 16971968 3509840
01:19:58 54238 8192000000 10890182512 11370078208 1933921616 19.098 98 15 30 0 1958916672 20529280 4465776
01:21:33 51817 8192000000 10895168528 11379388416 1931018752 19.075 98 16 32 0 1953641456 17971168 4651536
01:23:16 80099 8192000000 10895628080 11375636480 1946858448 19.201 99 8 17 0 1972542400 23195152 2488800
01:24:43 74612 8192000000 10856360624 11331227648 1846321760 18.392 94 10 20 0 1858302480 9343104 2637616
01:26:03 33484 8192000000 10900728944 11353382912 1946313392 19.197 100 50 100 2 1970190848 9379584 14497872
01:26:46 43203 8192000000 9270703776 9536258048 427095440 4.955 22 14 28 0 437007856 5867856 4044560

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 25-02-2021 01:28:46 to 25-02-2021 01:29:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 173 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 25-02-2021 01:29:19 to 25-02-2021 01:29: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          242668
MON$OLDEST_ACTIVE               244524
MON$OLDEST_SNAPSHOT             244524
MON$NEXT_TRANSACTION            244524
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                       2033440
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:269: 
:270: mscs-test-161.budzdorov.ru    Thu Feb 25 01:27:36 2021
:271:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:272: 
:273: 
:274: mscs-test-161.budzdorov.ru    Thu Feb 25 01:27:39 2021
:275:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:276: 
--- end of diff output ---

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

25.02.21 01:29: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
2021-02-25 01:29:25 No severe PSQL-related problems occured
25.02.21 01:29:26. End of report.