Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.02.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 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 17132620 kB
MemAvailable 31087128 kB
Buffers 0 kB
Cached 14544944 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-24 19:27:19
DTS_END                         2021-02-24 19:27:19.3420
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35648
TRN_ID                          235074
ATT_ID                          687
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: 9185.38 22148 1102245
customer order: creation 165.55 392 19866
customer order: refuse 14.08 344 1689
order to supplier: creation 43.71 1365 5245
order to supplier: removal 3.56 100344 427
invoice (draft): creation 44.08 3482 5290
invoice (draft): removal 52.35 804 6282
invoice accept: apply 40.35 19944 4842
invoice accept: cancel 47.75 787 5730
customer reserve: creation 3780.75 195 453690
customer reserve: removal 4708.18 60 564981
realization accept: apply 79.20 193 9504
realization accept: cancel 80.34 126 9641
payment from customer: creation 57.05 117 6846
payment from customer: removal 5.26 85 631
payment to supplier: creation 47.87 131 5744
payment to supplier: removal 3.23 108 387
service: total inventory turnovers 4.77 1104 572
service: total monetary turnovers 6.50 25 780
service: aggregate perf. data 0.78 24030 94
service: refresh index statistics 0.03 289326 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3296
TEST_TIME 2 3400
TEST_TIME 3 4061
TEST_TIME 4 5608
TEST_TIME 5 5933
TEST_TIME 6 6065
TEST_TIME 7 5753
TEST_TIME 8 5796
TEST_TIME 9 5997
TEST_TIME 10 6176
TEST_TIME 11 6322
TEST_TIME 12 6320
TEST_TIME 13 6945
TEST_TIME 14 7025
TEST_TIME 15 7138
TEST_TIME 16 7264
TEST_TIME 17 7409
TEST_TIME 18 7917
TEST_TIME 19 8186
TEST_TIME 20 8188
TEST_TIME 21 8117
TEST_TIME 22 8118
TEST_TIME 23 8239
TEST_TIME 24 8881
TEST_TIME 25 8944
TEST_TIME 26 9235
TEST_TIME 27 10024
TEST_TIME 28 10345
TEST_TIME 29 10292
TEST_TIME 30 10110
TEST_TIME 31 9933
TEST_TIME 32 9914
TEST_TIME 33 9922
TEST_TIME 34 9691
TEST_TIME 35 9636
TEST_TIME 36 9575
TEST_TIME 37 9533
TEST_TIME 38 9517
TEST_TIME 39 9387
TEST_TIME 40 9332
TEST_TIME 41 9294
TEST_TIME 42 9421
TEST_TIME 43 9475
TEST_TIME 44 9666
TEST_TIME 45 9609
TEST_TIME 46 9625
TEST_TIME 47 9746
TEST_TIME 48 9641
TEST_TIME 49 9675
TEST_TIME 50 9841
TEST_TIME 51 9835
TEST_TIME 52 9824
TEST_TIME 53 9905
TEST_TIME 54 9947
TEST_TIME 55 9787
TEST_TIME 56 9686
TEST_TIME 57 9664
TEST_TIME 58 9633
TEST_TIME 59 9586
TEST_TIME 60 9540
TEST_TIME 61 9458
TEST_TIME 62 9457
TEST_TIME 63 9387
TEST_TIME 64 9324
TEST_TIME 65 9403
TEST_TIME 66 9353
TEST_TIME 67 9365
TEST_TIME 68 9335
TEST_TIME 69 9453
TEST_TIME 70 9402
TEST_TIME 71 9501
TEST_TIME 72 9441
TEST_TIME 73 9437
TEST_TIME 74 9423
TEST_TIME 75 9545
TEST_TIME 76 9557
TEST_TIME 77 9590
TEST_TIME 78 9602
TEST_TIME 79 9640
TEST_TIME 80 9524
TEST_TIME 81 9494
TEST_TIME 82 9475
TEST_TIME 83 9444
TEST_TIME 84 9387
TEST_TIME 85 9469
TEST_TIME 86 9428
TEST_TIME 87 9376
TEST_TIME 88 9336
TEST_TIME 89 9326
TEST_TIME 90 9268
TEST_TIME 91 9271
TEST_TIME 92 9233
TEST_TIME 93 9216
TEST_TIME 94 9299
TEST_TIME 95 9293
TEST_TIME 96 9304
TEST_TIME 97 9303
TEST_TIME 98 9300
TEST_TIME 99 9318
TEST_TIME 100 9399
TEST_TIME 101 9387
TEST_TIME 102 9374
TEST_TIME 103 9381
TEST_TIME 104 9409
TEST_TIME 105 9454
TEST_TIME 106 9450
TEST_TIME 107 9379
TEST_TIME 108 9379
TEST_TIME 109 9331
TEST_TIME 110 9331
TEST_TIME 111 9283
TEST_TIME 112 9282
TEST_TIME 113 9261
TEST_TIME 114 9229
TEST_TIME 115 9186
TEST_TIME 116 9199
TEST_TIME 117 9219
TEST_TIME 118 9205
TEST_TIME 119 9238
TEST_TIME 120 9185

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 24-02-2021 19:28:33 to 24-02-2021 19:28:36.

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 1522553 1522553 0 0.00 0 19826 7 0 0
doc_list_biud 1522552 1522552 0 0.00 0 67348 28 0 0
sp_add_invoice_to_stock 4928 4842 86 1.74 34 183803 19944 0 86
sp_cancel_adding_invoice 5730 5730 0 0.00 5 97271 787 0 0
sp_cancel_client_order 1689 1689 0 0.00 4 13360 345 0 0
sp_cancel_customer_reserve 564981 564981 0 0.00 1 67352 60 0 0
sp_cancel_pay_from_customer 631 631 0 0.00 3 7161 85 0 0
sp_cancel_pay_to_supplier 387 387 0 0.00 3 9514 109 0 0
sp_cancel_supplier_invoice 6288 6282 6 0.09 2 24887 805 0 6
sp_cancel_supplier_order 427 427 0 0.00 10 904527 100345 0 0
sp_cancel_write_off 9641 9641 0 0.00 1 11406 126 0 0
sp_client_order 19866 19866 0 0.00 4 72051 393 0 0
sp_customer_reserve 453690 453690 0 0.00 0 71296 195 0 0
sp_fill_shopping_cart 30370 30370 0 0.00 1 13377 39 0 0
sp_fill_shopping_cart_clo_res 453690 453690 0 0.00 0 25086 16 0 0
sp_get_clo_for_invoice 4841 4841 0 0.00 0 55309 382 0 0
sp_kill_cost_storno 16389 16389 0 0.00 0 19815 62 0 0
sp_kill_qstorno_ret_qs2qd 1146312 1146312 0 0.00 0 65441 33 0 0
sp_kill_qty_storno 603095 603095 0 0.00 0 67348 70 0 0
sp_lock_selected_doc 19789 19789 0 0.00 0 7281 4 0 0
sp_make_cost_storno 26935 26935 0 0.00 0 10451 53 0 0
sp_multiply_rows_for_pdistr 26935 26935 0 0.00 0 6630 28 0 0
sp_multiply_rows_for_qdistr 19866 19866 0 0.00 0 63733 179 0 0
sp_pay_from_customer 6846 6846 0 0.00 4 19519 118 0 0
sp_pay_to_supplier 5744 5744 0 0.00 4 11612 132 0 0
sp_payment_common 12590 12590 0 0.00 1 19514 28 0 0
sp_qd_handle_on_cancel_clo 1689 1689 0 0.00 0 13344 296 0 0
sp_qd_handle_on_invoice_upd_sts 10571 10571 0 0.00 0 26333 322 0 0
sp_qd_handle_on_reserve_upd_sts 9504 9504 0 0.00 0 18280 65 0 0
sp_reserve_write_off 9504 9504 0 0.00 6 18348 193 0 0
sp_supplier_invoice 5290 5290 0 0.00 5 99167 3483 0 0
sp_supplier_order 5245 5245 0 0.00 5 41171 1365 0 0
srv_aggregate_perf_data 94 94 0 0.00 2108 510369 24030 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1178 142051 30995 0 0
srv_find_qd_qs_mism 1056035 1056035 0 0.00 0 17600 6 0 0
srv_make_invnt_saldo 572 572 0 0.00 38 39359 1104 0 0
srv_make_money_saldo 780 780 0 0.00 0 2911 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 203167 360179 289326 0 0
t$perf-abend:sp_add_invoice_to_stock 86 86 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4842 4842 0 0.00 0 17482 194 0 0
t$perf-norm:sp_cancel_adding_invoice 410 410 0 0.00 1 2469 103 0 0
t$perf-norm:sp_cancel_client_order 1689 1689 0 0.00 0 5674 24 0 0
t$perf-norm:sp_cancel_customer_reserve 663 663 0 0.00 0 10268 28 0 0
t$perf-norm:sp_cancel_pay_from_customer 631 631 0 0.00 0 2287 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 387 387 0 0.00 0 9551 30 0 0
t$perf-norm:sp_cancel_supplier_invoice 362 362 0 0.00 0 2478 15 0 0
t$perf-norm:sp_cancel_supplier_order 427 427 0 0.00 0 28703 1498 0 0
t$perf-norm:sp_cancel_write_off 875 875 0 0.00 0 1385 7 0 0
t$perf-norm:sp_client_order 19866 19866 0 0.00 0 14819 20 0 0
t$perf-norm:sp_customer_reserve 915 915 0 0.00 0 6339 11 0 0
t$perf-norm:sp_pay_from_customer 6846 6846 0 0.00 0 10908 15 0 0
t$perf-norm:sp_pay_to_supplier 5744 5744 0 0.00 0 6158 10 0 0
t$perf-norm:sp_reserve_write_off 9504 9504 0 0.00 0 11696 18 0 0
t$perf-norm:sp_supplier_invoice 5290 5290 0 0.00 0 13898 25 0 0
t$perf-norm:sp_supplier_order 5245 5245 0 0.00 0 11864 23 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 146 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 6248 71 0 0
t$perf-norm:srv_make_invnt_saldo 572 572 0 0.00 0 1016 15 0 0
t$perf-norm:srv_make_money_saldo 780 780 0 0.00 0 3045 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 44 13 0 0
v_add_invoice_to_stock 9854 9682 172 1.74 0 9557 26 0 172
v_all_customers 36228 36228 0 0.00 0 19 1 0 0
v_all_suppliers 29340 29340 0 0.00 0 110 1 0 0
v_all_wares 39732 39732 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 820 820 0 0.00 0 891 7 0 0
v_cancel_client_order 3378 3378 0 0.00 0 5924 14 0 0
v_cancel_customer_prepayment 1262 1262 0 0.00 0 2903 8 0 0
v_cancel_customer_reserve 1326 1326 0 0.00 0 1980 5 0 0
v_cancel_payment_to_supplier 774 774 0 0.00 0 9434 19 0 0
v_cancel_supplier_invoice 736 724 12 1.63 0 8360 39 0 12
v_cancel_supplier_order 854 854 0 0.00 0 1535 6 0 0
v_cancel_write_off 1750 1750 0 0.00 0 4329 20 0 0
v_max_id_clo_ord 5236 5236 0 0.00 0 184 1 0 0
v_max_id_clo_res 915 915 0 0.00 0 2458 13 0 0
v_max_id_ord_sup 5268 5268 0 0.00 0 6173 5 0 0
v_max_non_paid_invoice 1578 1578 0 0.00 0 231 2 0 0
v_max_non_paid_realizn 3635 3635 0 0.00 0 5775 10 0 0
v_min_id_clo_ord 5236 5236 0 0.00 0 7327 7 0 0
v_min_id_clo_res 915 915 0 0.00 0 4826 8 0 0
v_min_id_ord_sup 5268 5268 0 0.00 0 4857 6 0 0
v_min_non_paid_invoice 5744 5744 0 0.00 0 8281 19 0 0
v_min_non_paid_realizn 6846 6846 0 0.00 0 4605 14 0 0
v_our_firm 9926 9926 0 0.00 0 15 1 0 0
v_reserve_write_off 19008 19008 0 0.00 0 9484 12 0 0
x_lock_depdocs_on_canc_invoice 11650 11650 0 0.00 0 17696 117 0 0
x_lock_depdocs_on_canc_sup_ord 427 427 0 0.00 0 7514 323 0 0
x_make_qstorno_1000_1200 5245 5245 0 0.00 2 41135 1288 0 0
x_make_qstorno_1200_2000 5290 5290 0 0.00 2 95800 3335 0 0
x_make_qstorno_2100_3300 453690 453690 0 0.00 0 71294 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-02-2021 19:28:37 to 24-02-2021 19:28:41.

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:22 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:28 27492 8192000000 10268586848 10583326720 851114800 9.411 64 53 108 0 870443024 2453792 16874432
16:58:05 22561 8192000000 10351882288 10668404736 1406551568 14.653 100 89 177 1 1439970624 5383296 28035760
16:58:41 19848 8192000000 10400367056 10720530432 1450093472 15.039 100 94 188 0 1487238368 7267264 29877632
16:59:16 23062 8192000000 10401497952 10725109760 1456211872 15.093 100 94 188 1 1495489472 8718400 30559200
16:59:48 22494 8192000000 10412181968 10739085312 1461817376 15.142 100 87 174 0 1499563024 9285104 28460544
17:00:21 21364 8192000000 10428609312 10757042176 1480306304 15.304 100 92 184 1 1519929808 9740576 29882928
17:00:59 20752 8192000000 10432254576 10769682432 1490544656 15.394 100 85 170 0 1527717728 10003632 27169440
17:01:33 21364 8192000000 10480189888 10821812224 1527401968 15.714 100 86 171 0 1564125984 10275680 26448336
17:02:08 16256 8192000000 10510231424 10858868736 1563967520 16.030 100 81 161 0 1599361792 10955808 24438464
17:02:36 13279 8192000000 10549658912 10902355968 1604410736 16.377 100 82 164 0 1640589040 11497616 24680688
17:03:02 13416 8192000000 10567781216 10925842432 1618501408 16.497 100 75 150 0 1652770256 12227936 22040912
17:03:24 10496 8192000000 10594123200 10951032832 1646663344 16.736 100 87 173 1 1685917104 13008464 26245296
17:03:41 8029 8192000000 10617010672 10976907264 1665168176 16.892 100 87 173 3 1703913840 13288496 25457168
17:04:00 7161 8192000000 10613436336 10983411712 1680958016 17.025 100 80 160 0 1717546416 13285552 23302848
17:04:15 8127 8192000000 10644273472 11012784128 1701031024 17.194 100 84 169 0 1739969664 13376688 25561952
17:04:30 9662 8192000000 10666367008 11033374720 1715424096 17.314 100 84 166 1 1752921008 13575952 23920960
17:04:47 5527 8192000000 10665491456 11038662656 1731154864 17.445 100 86 168 4 1768933376 14156208 23622304
17:04:59 6266 8192000000 10680579424 11052032000 1744018672 17.552 100 86 172 2 1782098160 13714192 24365296
17:05:12 6435 8192000000 10694563456 11073966080 1754813712 17.641 100 78 157 0 1789129984 12200448 22115824
17:05:25 4695 8192000000 10705217824 11080282112 1765129216 17.727 100 80 156 0 1799562288 12535888 21897184
17:05:37 3513 8192000000 10708229536 11085889536 1771274240 17.778 100 86 170 3 1808200032 12964368 23961424
17:05:48 3185 8192000000 10722928624 11099791360 1782571264 17.871 100 90 180 1 1821877232 13582784 25723184
17:05:58 3929 8192000000 10724575904 11104190464 1789523024 17.928 100 90 180 1 1829131184 13723552 25884608
17:06:09 2330 8192000000 10733750784 11113361408 1797389872 17.992 100 87 171 2 1840475440 18563808 24521760
17:06:18 3509 8192000000 10744899552 11122888704 1803626448 18.044 100 85 172 1 1840684992 13316144 23742400
17:06:28 3588 8192000000 10753987744 11137695744 1811161088 18.105 100 82 164 1 1849694560 14409968 24123504
17:06:38 3703 8192000000 10760725824 11140636672 1817226544 18.155 100 88 174 1 1855725968 14699264 23800160
17:06:49 4355 8192000000 10752807264 11134832640 1817583808 18.158 100 83 166 0 1855131840 14884384 22663648
17:07:00 2129 8192000000 10774266416 11161853952 1837720800 18.322 100 91 180 0 1877442800 14598880 25123120
17:07:08 1791 8192000000 10777862016 11167416320 1843894544 18.372 100 89 179 2 1882402064 13484864 25022656
17:07:17 2441 8192000000 10791444448 11174957056 1845237472 18.383 100 86 173 2 1882601648 13269920 24094256
17:07:26 2098 8192000000 10794119136 11183374336 1854560080 18.459 100 88 174 1 1892062832 12694848 24807904
17:07:34 2894 8192000000 10810103488 11197779968 1865558144 18.548 100 90 179 3 1903993008 12542256 25892608
17:07:43 1672 8192000000 10817647072 11204620288 1871832368 18.599 100 92 186 1 1910572336 11903888 26836080
17:07:51 2072 8192000000 10819651984 11208736768 1876447808 18.636 100 95 191 3 1916079472 13707120 25924544
17:08:00 1891 8192000000 10827155904 11215912960 1876673088 18.638 100 92 180 0 1915030768 12856640 25501040
17:08:09 1598 8192000000 10824861312 11212578816 1878252096 18.651 100 95 191 1 1918518928 13345280 26921552
17:08:17 3654 8192000000 10820773872 11213381632 1881856928 18.680 100 90 183 0 1920234592 13256352 25121312
17:08:27 1492 8192000000 10829143792 11218415616 1884315744 18.700 100 96 189 1 1923622736 13298976 26008016
17:08:34 1444 8192000000 10829147680 11221098496 1884062352 18.698 100 94 188 2 1924113536 13208032 26843152
17:08:42 1573 8192000000 10829489008 11223302144 1884934528 18.705 100 95 191 1 1926099328 13699344 27465456
17:08:50 37525 8192000000 10813204304 11212169216 1878157584 18.650 100 56 112 0 1905774336 10791488 16825264
17:09:34 1734 8192000000 10812826608 11217678336 1887270208 18.724 100 72 144 2 1917929184 9058928 21600048
17:09:43 7478 8192000000 10821278928 11222286336 1888542832 18.734 100 69 136 4 1916131280 8991312 18597136
17:09:57 2942 8192000000 10806246048 11222929408 1883291424 18.692 100 53 106 0 1908761120 10517616 14952080
17:10:11 2644 8192000000 10808448656 11222552576 1883991696 18.697 100 44 88 1 1903742656 7350720 12400240
17:10:22 3193 8192000000 10813022880 11230785536 1891027296 18.754 100 54 109 2 1916396176 10050448 15318432
17:10:32 7746 8192000000 10793278592 11222663168 1892518064 18.766 100 39 78 1 1910993136 7401696 11073376
17:10:48 3188 8192000000 10825842864 11233746944 1896862960 18.801 100 65 131 3 1923567344 7392576 19311808
17:10:59 8178 8192000000 10796777040 11228127232 1890592672 18.751 100 24 49 1 1903162336 6115072 6454592
17:11:16 7425 8192000000 10799432560 11228602368 1891065616 18.754 100 21 41 3 1904406880 6812336 6528928
17:11:31 8006 8192000000 10797137472 11232075776 1892281424 18.764 100 15 29 1 1902427664 5793072 4353168
17:11:46 8761 8192000000 10803688064 11236196352 1897981200 18.810 100 24 47 2 1910864352 6223696 6659456
17:12:01 11836 8192000000 10793599552 11237113856 1898239568 18.812 100 17 34 2 1909488832 6490064 4759200
17:12:21 6719 8192000000 10822686320 11250335744 1900347680 18.829 100 22 44 1 1916241808 10020416 5873712
17:12:34 11535 8192000000 10812656000 11244642304 1900939600 18.834 100 9 18 1 1909051632 5534576 2577456
17:12:52 15389 8192000000 10812958112 11246075904 1903337136 18.853 100 14 28 0 1913119808 6031552 3751120
17:13:16 24395 8192000000 10812185456 11255406592 1907666016 18.888 100 29 58 1 1921828240 5578912 8583312
17:13:58 43886 8192000000 10857529584 11263717376 1916786912 18.961 100 70 142 3 1943415008 6013456 20614640
17:14:48 3825 8192000000 10838424848 11267489792 1916970992 18.963 100 59 118 0 1944742848 11307792 16464064
17:14:58 7317 8192000000 10835252224 11265794048 1913856864 18.938 100 30 60 2 1929681856 7340144 8484848
17:15:11 6081 8192000000 10824811616 11264765952 1919911008 18.986 100 27 53 0 1934085936 6068528 8106400
17:15:24 7459 8192000000 10835404512 11267334144 1919397168 18.982 100 35 70 1 1936076176 6860640 9818368
17:15:38 3367 8192000000 10829595584 11265507328 1917292096 18.965 100 35 70 0 1933919776 6244192 10383488
17:15:48 6591 8192000000 10811335408 11238125568 1888857744 18.737 99 23 45 2 1902096880 7408688 5830448
17:16:01 8780 8192000000 10819103696 11252645888 1891403808 18.757 99 27 54 3 1904063200 4954736 7704656
17:16:16 5649 8192000000 10819408624 11252928512 1903188864 18.852 100 37 74 0 1920974880 6501648 11284368
17:16:28 10362 8192000000 10800187552 11228987392 1876972944 18.641 99 22 43 1 1888400624 5517104 5910576
17:16:50 6092 8192000000 10802962496 11231485952 1884553824 18.702 100 25 51 0 1897768000 5992960 7221216
17:17:03 7091 8192000000 10785737040 11205656576 1790261952 17.934 95 12 24 1 1799060048 5263968 3534128
17:17:17 11908 8192000000 10786682464 11205623808 1823096640 18.203 97 35 66 2 1837717008 5156976 9463392
17:17:36 61866 8192000000 10733421760 11159781376 1662660976 16.871 89 20 40 0 1673714112 4982128 6071008
17:18:44 6716 8192000000 10732211904 11153223680 1753457232 17.630 96 28 56 3 1766485184 5429600 7598352
17:19:02 5856 8192000000 10732883152 11156303872 1805547232 18.059 99 31 62 2 1820843712 5925168 9371312
17:19:14 6218 8192000000 10744458688 11166441472 1804815136 18.053 99 29 58 0 1823266688 10199408 8252144
17:19:26 4929 8192000000 10738331040 11168206848 1816698752 18.151 99 27 55 0 1830841504 5678384 8464368
17:19:40 5523 8192000000 10740209200 11150839808 1788076288 17.916 98 28 56 1 1801957264 5482016 8398960
17:19:54 5860 8192000000 10713935456 11137003520 1804802064 18.053 100 27 55 3 1818776256 6445056 7529136
17:20:08 4389 8192000000 10715330912 11131260928 1795323056 17.976 99 30 58 1 1810404112 5967232 9113824
17:20:21 5684 8192000000 10713058416 11128492032 1753807232 17.633 97 21 42 0 1765066384 5017088 6242064
17:20:36 6226 8192000000 10699591664 11107729408 1746661296 17.574 97 25 50 2 1759014048 5008672 7344080
17:20:51 9339 8192000000 10700784160 11127685120 1765124256 17.727 98 18 36 1 1776054752 5901344 5029152
17:21:06 11132 8192000000 10720529728 11139518464 1764782864 17.724 97 23 46 1 1776747136 4841296 7122976
17:21:24 9223 8192000000 10728819568 11146436608 1796407120 17.984 99 34 68 3 1812644768 5193680 11043968
17:21:39 13406 8192000000 10705984816 11128664064 1742593104 17.540 96 18 35 1 1753309904 5142480 5574320
17:21:59 67497 8192000000 10717087040 11145883648 1775556688 17.813 98 32 63 0 1790093472 5381104 9155680
17:23:14 5945 8192000000 10753336288 11167268864 1826579696 18.231 100 22 44 1 1837963440 5534528 5849216
17:23:28 6978 8192000000 10760196528 11180007424 1838424800 18.328 100 47 93 2 1858443808 7166224 12852784
17:23:43 5154 8192000000 10768561248 11184848896 1841171200 18.350 100 23 46 0 1854075904 6588400 6316304
17:23:55 3750 8192000000 10772844256 11186257920 1850239264 18.424 100 45 91 0 1870705776 7480688 12985824
17:24:06 5796 8192000000 10767877856 11186077696 1843301024 18.368 100 29 59 2 1857913712 5920880 8691808
17:24:19 4832 8192000000 10766368816 11188359168 1847337168 18.400 100 41 82 4 1865170672 6355808 11477696
17:24:31 7084 8192000000 10757464992 11184226304 1845007584 18.382 100 35 70 6 1862261904 7098192 10156128
17:24:45 11652 8192000000 10777631616 11200339968 1853489584 18.450 100 25 51 0 1866608608 5181664 7937360
17:25:06 11822 8192000000 10778041936 11206029312 1857796896 18.485 100 16 32 2 1867443520 5021168 4625456
17:25:27 8164 8192000000 10786023216 11211517952 1868041264 18.568 100 26 50 1 1880780848 5430304 7309280
17:25:42 12064 8192000000 10794687088 11221876736 1871876656 18.599 100 20 40 1 1883186656 4709008 6600992
17:26:00 12627 8192000000 10787619600 11220279296 1872245904 18.602 100 15 30 0 1881906512 5159200 4501408
17:26:20 30129 8192000000 10789698832 11223912448 1878278544 18.651 100 21 42 0 1889268656 4808112 6182000
17:26:57 102564 8192000000 10833526928 11256520704 1898507584 18.814 100 38 76 0 1915230880 5702400 11020896
17:28:48 21605 8192000000 10853262960 11274448896 1921688768 19.000 100 45 89 0 1942822560 8582064 12551728
17:29:38 20458 8192000000 10872866080 11291545600 1933768768 19.097 100 54 107 1 1958124576 9682672 14673136
17:30:07 11224 8192000000 10882465584 11299926016 1943145008 19.172 100 59 117 2 1971279584 11727200 16407376
17:30:24 5879 8192000000 10886606320 11306672128 1950735584 19.232 100 74 148 0 1989016944 17214560 21066800
17:30:48 12399 8192000000 10885642240 11310186496 1946941440 19.202 100 60 115 0 1977135232 13767728 16426064
17:31:33 34514 8192000000 10877747104 11317260288 1954787360 19.265 100 40 80 1 1978923744 11826464 12309920
17:32:20 15491 8192000000 10875776224 11318181888 1939969296 19.147 99 37 74 1 1961398400 9647984 11781120
17:32:45 9570 8192000000 10900514688 11332018176 1966325120 19.356 100 51 103 1 1996826656 15633392 14868144
17:33:17 4785 8192000000 10908042032 11339595776 1973109856 19.410 100 57 114 0 2000939392 11362736 16466800
17:33:29 9264 8192000000 10907046464 11343196160 1976557248 19.437 100 44 87 1 2000861184 11954640 12349296
17:33:45 9116 8192000000 10907234496 11338477568 1959357888 19.301 99 48 96 1 1984188384 10638752 14191744
17:34:02 10159 8192000000 10905630608 11338682368 1974430368 19.421 100 45 88 0 1997685888 11124656 12130864
17:34:23 2332 8192000000 10926187504 11346534400 1983470976 19.492 100 69 138 0 2016324048 12594192 20258880
17:34:35 15734 8192000000 10923156784 11352743936 1981024944 19.473 100 52 104 0 2009742912 13384368 15333600
17:35:00 18109 8192000000 10923226816 11355922432 1986913648 19.519 100 58 115 3 2017457376 13646800 16896928
17:35:25 8298 8192000000 10922522032 11357278208 1972694464 19.407 99 63 124 3 2005065952 13365920 19005568
17:35:47 6222 8192000000 10938978960 11362459648 1992958880 19.567 100 65 128 0 2027536816 14906832 19671104
17:36:00 8491 8192000000 10942336464 11363643392 1992973152 19.567 100 57 114 1 2024832752 14577376 17282224
17:36:17 10102 8192000000 10934311968 11357966336 1974749664 19.423 99 52 104 0 2003265488 13222304 15293520
17:36:34 11367 8192000000 10934222992 11355770880 1989417360 19.539 100 74 146 2 2027587008 16048400 22121248
17:37:02 9253 8192000000 10922119168 11348230144 1964628352 19.343 99 57 114 3 1998743344 17267744 16847248
17:37:18 2165 8192000000 10943429712 11362754560 1983381088 19.491 100 65 130 3 2021294064 18184960 19728016
17:37:27 3464 8192000000 10943180848 11365986304 1991474720 19.555 100 68 134 1 2030603744 19493440 19635584
17:37:36 5435 8192000000 10944552304 11359494144 1976791440 19.439 99 79 160 0 2021125040 20600704 23732896
17:37:52 4044 8192000000 10929993952 11352535040 1958952208 19.298 99 64 128 0 2000444800 22333136 19159456
17:38:07 2526 8192000000 10937103680 11353481216 1973968336 19.417 100 79 158 0 2021270880 23320720 23981824
17:38:18 8393 8192000000 10934494160 11357278208 1977692080 19.446 100 68 136 0 2022294672 23542624 21059968
17:38:37 6830 8192000000 10921500752 11345977344 1956283232 19.276 99 63 123 0 1998446864 23958416 18205216
17:38:51 3276 8192000000 10927316544 11350302720 1962200848 19.324 99 77 154 0 2009413344 24237568 22974928
17:39:04 4740 8192000000 10930596224 11353784320 1977520672 19.445 100 70 138 0 2025513888 26371424 21621792
17:39:17 1943 8192000000 10903975552 11317723136 1920931424 18.994 98 72 140 3 1972757232 29035968 22789840
17:39:30 11654 8192000000 10914656336 11343896576 1955351088 19.269 100 61 121 1 2004560784 30461536 18748160
17:39:49 3155 8192000000 10919162272 11345018880 1953788192 19.257 100 51 101 1 2002249648 32187920 16273536
17:39:59 1178 8192000000 10936064576 11353350144 1960982208 19.314 100 72 144 2 2015916208 32107328 22826672
17:40:09 5673 8192000000 10920901792 11337101312 1950361824 19.229 100 76 152 0 2006162352 31679696 24120832
17:40:23 5844 8192000000 10908959120 11332014080 1946405952 19.198 100 59 118 0 1995029696 30168336 18455408
17:40:36 6766 8192000000 10908375600 11328450560 1940254944 19.149 99 68 134 2 1987351376 26955632 20140800
17:40:52 5191 8192000000 10929573248 11347013632 1958886464 19.297 100 77 154 1 2013090192 30881600 23322128
17:41:10 4243 8192000000 10930682240 11347140608 1957674336 19.288 100 78 155 1 2013622896 32613328 23335232
17:41:24 3962 8192000000 10927725728 11341729792 1952520960 19.247 100 77 152 0 2007333248 31848176 22964112
17:41:37 3010 8192000000 10922247280 11349229568 1960330848 19.309 100 62 123 4 2011801264 32692784 18777632
17:41:47 5438 8192000000 10930844304 11354595328 1964837872 19.344 100 58 116 2 2015300784 32711504 17751408
17:42:00 5195 8192000000 10942429200 11363770368 1973850816 19.416 100 68 133 0 2027567040 33044736 20671488
17:42:12 5627 8192000000 10943891344 11365957632 1963858592 19.337 99 71 140 2 2019060832 33887712 21314528
17:42:24 4260 8192000000 10938705984 11355774976 1956445776 19.278 99 76 151 3 2017549616 37841472 23262368
17:42:35 2685 8192000000 10930753920 11351150592 1957158448 19.283 99 66 132 0 2012963792 35581936 20223408
17:42:45 3635 8192000000 10959597504 11375947776 1980988832 19.473 100 78 156 2 2041119376 36330224 23800320
17:42:57 7019 8192000000 10958121216 11378106368 1978587744 19.454 100 73 146 0 2039741936 38369184 22785008
17:43:11 5860 8192000000 10948441840 11366912000 1964391232 19.341 99 74 147 3 2025819280 38612000 22816048
17:43:24 3175 8192000000 10945925824 11358388224 1940870992 19.154 98 77 154 1 2008666944 44065184 23730768
17:43:36 4534 8192000000 10947449856 11361775616 1961148464 19.315 100 73 146 1 2027937392 44172000 22616928
17:43:48 7170 8192000000 10949623088 11372322816 1965909104 19.353 100 68 132 1 2031661040 44704064 21047872
17:44:07 8101 8192000000 10962821392 11379310592 1974201840 19.419 100 67 134 1 2039786544 43963232 21621472
17:44:28 3518 8192000000 10959014992 11382587392 1979839984 19.463 100 68 137 2 2043778064 42634128 21303952
17:44:40 3206 8192000000 10954419824 11367567360 1963759040 19.336 100 74 145 1 2029378096 42759040 22860016
17:44:51 3122 8192000000 10952938464 11369996288 1968063104 19.370 100 73 147 0 2033781024 43337216 22380704
17:45:02 1823 8192000000 10978783968 11388497920 1983088944 19.489 100 93 183 3 2055444192 43972688 28382560
17:45:10 2073 8192000000 10974122768 11386257408 1978003856 19.449 100 82 162 1 2047829856 44656032 25169968
17:45:21 2446 8192000000 10965532992 11382763520 1975638112 19.430 100 79 158 3 2044645312 44773584 24233616
17:45:31 1417 8192000000 10975987328 11384999936 1980995552 19.473 100 89 178 2 2053482832 45150848 27336432
17:45:40 3015 8192000000 10950025568 11365187584 1962460672 19.326 99 89 176 1 2029089408 40115712 26513024
17:45:52 2099 8192000000 10956135360 11369029632 1961370112 19.317 99 80 159 0 2028768352 44272096 23126144
17:46:01 1487 8192000000 10951408784 11362689024 1956148688 19.275 99 87 173 3 2024420544 42047184 26224672
17:46:09 1517 8192000000 10969713872 11380203520 1977597760 19.446 100 88 177 1 2047778960 43681984 26499216
17:46:19 4451 8192000000 10949752096 11367522304 1956855136 19.281 99 75 150 2 2023710752 42979392 23876224
17:46:31 14160 8192000000 10930380512 11372490752 1961131456 19.315 100 42 84 0 2015001536 40332240 13537840
17:46:52 14382 8192000000 10913299088 11342643200 1926308960 19.037 98 45 89 2 1979996848 39087440 14600448
17:47:18 12692 8192000000 10904634608 11331735552 1911116208 18.916 98 46 92 1 1965900976 39911584 14873184
17:47:42 7301 8192000000 10903043728 11335213056 1923938768 19.018 99 54 108 1 1984291456 42945376 17407312
17:48:09 6386 8192000000 10921871024 11353567232 1948825232 19.217 100 46 92 2 2005558944 41250352 15483360
17:48:30 14387 8192000000 10913695360 11352760320 1941630448 19.160 100 36 72 3 1996410752 42739120 12041184
17:48:55 14856 8192000000 10924316064 11365531648 1952688768 19.248 100 42 83 1 2010380576 43898800 13793008
17:49:16 25346 8192000000 10924118928 11364401152 1931577952 19.079 99 35 69 2 1992048720 48137440 12333328
17:49:48 14941 8192000000 10933490912 11374436352 1954699552 19.264 100 42 83 0 2020463424 51753536 14010336
17:50:20 5762 8192000000 10955676400 11384365056 1968493040 19.373 100 62 123 2 2038582944 50102368 19987536
17:50:37 3883 8192000000 10955826320 11388108800 1969141232 19.379 100 49 96 2 2035194448 50154096 15899120
17:50:57 18725 8192000000 10942485856 11391655936 1967137024 19.363 100 38 76 1 2033982176 53979616 12865536
17:51:23 17334 8192000000 10929220896 11390332928 1964989008 19.346 100 27 54 1 2022256896 48022096 9245792
17:51:50 9864 8192000000 10925174064 11368443904 1956479536 19.278 100 33 66 2 2005635200 38405904 10749760
17:52:09 21423 8192000000 10920718576 11379953664 1960224768 19.308 100 26 51 0 2010437408 41426400 8786240
17:52:38 35233 8192000000 10932756944 11397984256 1960682272 19.311 100 24 48 2 2021712592 52347584 8682736
17:53:36 27786 8192000000 10915698800 11364102144 1890451424 18.749 97 21 42 1 1945176624 46771072 7954128
17:54:11 24316 8192000000 10873756080 11338190848 1872861296 18.607 97 13 26 1 1916619552 38827104 4931152
17:54:49 37524 8192000000 10838942512 11301142528 1838437680 18.328 96 12 24 2 1867187184 24063120 4686384
17:55:46 44369 8192000000 10859829904 11309924352 1911184736 18.916 100 40 77 0 1932302096 9428240 11689120
17:56:37 110738 8192000000 10865536720 11317178368 1915488512 18.951 99 33 66 0 1934359088 9058512 9812064
17:59:01 63335 8192000000 10860435536 11316199424 1860968496 18.511 96 19 38 0 1878659904 12097456 5593952
18:00:45 45574 8192000000 10846012272 11303718912 1914937616 18.946 99 19 38 1 1932024528 11282528 5804384
18:01:39 38890 8192000000 10888970528 11323932672 1928990112 19.059 99 50 99 1 1955175424 12948416 13236896
18:02:24 1668 8192000000 10919497040 11343716352 1954194336 19.260 100 70 132 2 1991030304 16477728 20358240
18:02:36 54039 8192000000 10907367696 11358289920 1963246560 19.332 100 37 74 0 1988680256 14467776 10965920
18:03:53 23799 8192000000 10896951184 11346862080 1941538448 19.159 99 25 50 1 1963300112 13890288 7871376
18:04:28 24787 8192000000 10905926016 11352809472 1939325728 19.141 99 40 80 1 1968011648 16542992 12142928
18:05:09 38374 8192000000 10897155504 11361554432 1961425712 19.317 100 30 60 0 1986749088 15807136 9516240
18:06:01 33341 8192000000 10897810640 11360555008 1949068640 19.219 99 16 32 1 1973645456 19865728 4711088
18:06:41 16897 8192000000 10916119184 11366416384 1969028304 19.378 100 38 77 3 2000799328 19953296 11817728
18:07:06 40977 8192000000 10905276896 11371282432 1968857232 19.376 100 17 34 0 1995386368 21312016 5217120
18:09:28 52054 8192000000 10922887936 11403042816 1974674496 19.423 100 18 36 0 2004208896 23294240 6240160
18:10:31 48850 8192000000 10895772928 11377987584 1955794272 19.273 99 9 19 1 1979770960 21424432 2552256
18:11:26 49290 8192000000 10894995104 11362144256 1931881152 19.082 98 8 16 0 1948581264 14676384 2023728
18:12:22 56892 8192000000 10908586704 11382886400 1972892288 19.408 100 22 44 0 1990918304 11972768 6053248
18:13:25 99788 8192000000 10895572944 11370934272 1920150464 18.988 97 12 24 0 1939956160 16488560 3317136
18:15:34 23297 8192000000 10924235952 11366408192 1954178944 19.260 99 52 101 2 1984981536 14795088 16007504
18:16:04 18655 8192000000 10926259152 11375054848 1973759264 19.415 100 47 95 0 2004504624 17007040 13738320
18:16:36 41511 8192000000 10909728912 11383267328 1953377424 19.253 99 17 34 1 1981544368 23625376 4541568
18:17:57 142051 8192000000 10914636800 11390033920 1956460176 19.278 99 9 18 0 1980597024 21416336 2720512
18:22:00 125057 8192000000 10914620144 11394179072 1991777376 19.558 100 19 38 1 2005427456 8748048 4902032
18:24:18 64555 8192000000 10919255104 11387969536 1957034256 19.282 98 24 48 0 1971937472 8699216 6204000
18:25:34 63855 8192000000 10912077360 11390373888 1970722320 19.391 99 27 54 2 1989372192 11089200 7560672
18:27:02 12125 8192000000 10920036064 11398832128 1991297200 19.554 100 14 28 0 2004970976 10074704 3599072
18:27:21 16990 8192000000 10908396592 11367526400 1956160688 19.276 98 19 37 3 1973550000 12272384 5116928
18:27:44 64284 8192000000 10881670800 11361021952 1926067920 19.035 97 13 26 1 1938961552 9365760 3527872
18:29:53 40669 8192000000 10889481696 11367628800 1974133040 19.418 100 7 14 0 1982522656 6725424 1664192
18:30:43 60142 8192000000 10909674048 11392512000 1983200592 19.490 100 5 10 1 1990799168 6364496 1234080
18:31:49 43176 8192000000 10908444608 11386122240 1969829312 19.384 99 17 33 0 1986860560 12007280 5023968
18:32:59 40156 8192000000 10909641184 11379806208 1925272704 19.029 97 18 36 0 1942739056 12269600 5196752
18:33:50 34326 8192000000 10869417616 11338047488 1866011472 18.552 94 36 72 2 1888083632 11305888 10766272
18:34:30 52634 8192000000 10874211424 11343118336 1898546672 18.815 97 18 35 4 1914929328 10876800 5505856
18:35:31 55469 8192000000 10867480560 11332579328 1855984704 18.471 95 16 32 2 1873535264 12378576 5171984
18:36:35 71953 8192000000 10896317808 11355140096 1887364240 18.725 97 24 48 0 1912045136 17037248 7643648
18:37:53 59617 8192000000 10884590992 11341303808 1906839760 18.881 98 24 49 2 1932968288 17756192 8372336
18:38:59 73517 8192000000 10869463040 11329691648 1864497184 18.540 95 22 44 1 1889994736 19351840 6145712
18:40:26 49513 8192000000 10889872704 11339915264 1886973168 18.721 97 36 72 0 1913210144 16418896 9818080
18:41:31 75414 8192000000 10875982096 11354394624 1895324896 18.789 97 22 44 1 1921897792 20373952 6198944
18:42:59 86299 8192000000 10894859040 11367055360 1930496384 19.071 99 16 32 1 1954420016 18988464 4935168
18:44:52 28553 8192000000 10912187920 11354185728 1916531280 18.959 98 38 76 1 1935908656 8659712 10717664
18:45:27 35586 8192000000 10889166320 11351306240 1919185840 18.980 98 36 72 0 1940567376 11569168 9812368
18:46:14 61320 8192000000 10859087440 11339423744 1895636368 18.791 97 21 42 0 1917552528 15950112 5966048
18:48:00 57330 8192000000 10862313632 11326271488 1884248672 18.699 97 33 66 3 1903533328 9984032 9300624
18:49:48 56548 8192000000 10881973760 11357769728 1945718688 19.192 100 21 42 2 1969575024 18073136 5783200
18:51:12 67562 8192000000 10904914416 11366694912 1952282224 19.245 100 25 48 4 1977656016 18050272 7323520
18:52:32 59022 8192000000 10821151840 11305209856 1802617344 18.035 93 8 15 1 1819793872 14950704 2225824
18:53:48 70238 8192000000 10856302432 11328622592 1932415936 19.086 100 10 20 0 1942517376 7353584 2747856
18:55:15 94492 8192000000 10860418960 11326885888 1884533520 18.702 97 14 28 0 1898342272 9725744 4083008
18:56:56 78394 8192000000 10854378096 11332173824 1899586688 18.823 98 19 38 0 1919827552 15338544 4902320
18:59:15 34940 8192000000 10887938352 11354439680 1951682736 19.240 100 25 50 0 1965564352 7057616 6824000
19:00:38 68708 8192000000 10877328400 11357761536 1921526464 18.999 98 9 18 0 1934406544 10304400 2575680
19:01:53 33380 8192000000 10876445936 11341942784 1928140928 19.052 98 18 36 0 1940484912 7475840 4868144
19:02:33 41025 8192000000 10884619520 11346706432 1917229504 18.965 97 27 54 1 1932660464 8380944 7050016
19:03:26 47824 8192000000 10885308832 11362459648 1947258128 19.205 99 12 24 0 1961811360 10693136 3860096
19:04:20 52407 8192000000 10903716560 11381567488 1953555168 19.255 99 18 36 1 1968876432 9632240 5689024
19:05:21 35425 8192000000 10926230512 11379404800 1961068704 19.315 99 39 76 0 1983385584 11113504 11203376
19:06:08 13079 8192000000 10924279056 11365687296 1963540480 19.334 99 63 126 0 1995758592 14371840 17846272
19:06:30 33974 8192000000 10919515968 11391213568 1961498128 19.318 99 41 82 1 1994486048 21238752 11749168
19:07:14 91488 8192000000 10909090320 11388952576 1957750976 19.288 99 19 38 1 1985720832 22544480 5425376
19:08:53 62902 8192000000 10919327408 11369631744 1942799520 19.169 98 25 50 1 1957674512 8153680 6721312
19:10:02 6928 8192000000 10927828384 11382636544 1985859760 19.511 100 48 95 2 2008515040 7982416 14672864
19:10:16 28041 8192000000 10928661296 11387990016 1967534368 19.366 99 47 93 0 1993827312 12552880 13740064
19:10:51 58934 8192000000 10950173056 11418386432 1992975984 19.567 100 35 70 0 2018822208 15782592 10063632
19:11:56 78067 8192000000 10932552096 11428122624 1979537744 19.461 99 22 44 2 2008867008 23253024 6076240
19:13:21 85462 8192000000 10897328928 11359801344 1922450720 19.006 97 15 30 0 1942002720 15014576 4537424
19:14:58 95330 8192000000 10894989440 11369926656 1956914992 19.282 99 17 34 0 1973167440 11681776 4570672
19:16:40 31207 8192000000 10906137104 11352768512 1924171696 19.020 97 44 87 3 1943464656 6541904 12751056
19:17:19 61419 8192000000 10895860096 11378806784 1968774464 19.376 100 36 72 5 1986739712 7742272 10222976
19:18:34 70847 8192000000 10913498512 11399151616 1983670064 19.494 100 9 18 2 1999016448 12342160 3004224
19:19:51 28395 8192000000 10891997712 11380236288 1965530128 19.350 99 10 21 0 1978856208 10649264 2676816
19:20:26 83781 8192000000 10889498512 11370799104 1940417952 19.150 98 19 38 0 1953520768 7216144 5886672
19:21:56 72892 8192000000 10864419344 11332956160 1917420688 18.966 97 21 42 0 1932757872 8995584 6341600
19:23:27 52231 8192000000 10871339632 11354771456 1921352496 18.998 98 12 24 1 1936899104 11641504 3905104
19:24:30 42963 8192000000 10890670816 11347218432 1908928048 18.898 97 25 50 0 1924361248 7932160 7501040
19:25:21 39816 8192000000 10884253680 11356553216 1928735456 19.057 98 29 58 0 1946389888 9392912 8261520
19:26:22 62973 8192000000 9468642304 9773072384 615267488 6.985 32 9 18 1 621558848 3647424 2643936

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 24-02-2021 19:28:43 to 24-02-2021 19:29:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 86 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-02-2021 19:29:15 to 24-02-2021 19:29:17.

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          235341
MON$OLDEST_ACTIVE               235342
MON$OLDEST_SNAPSHOT             235342
MON$NEXT_TRANSACTION            235342
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                       2011584
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 ---
:255: 
:256: mscs-test-161.budzdorov.ru    Wed Feb 24 19:27:35 2021
:257:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:258: 
--- end of diff output ---

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

24.02.21 19:29:18. 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-24 19:29:21 No severe PSQL-related problems occured
24.02.21 19:29:22. End of report.