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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-25 01:27:05
DTS_END                         2020-12-25 01:27:05.1850
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/42576
TRN_ID                          260940
ATT_ID                          667
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: 9769.14 19344 1172297
customer order: creation 190.98 326 22917
customer order: refuse 15.83 293 1899
order to supplier: creation 49.70 1123 5964
order to supplier: removal 3.58 75941 430
invoice (draft): creation 51.01 2833 6121
invoice (draft): removal 55.07 665 6608
invoice accept: apply 45.03 15509 5403
invoice accept: cancel 49.18 662 5902
customer reserve: creation 4122.31 156 494677
customer reserve: removal 4874.38 43 584925
realization accept: apply 91.48 141 10977
realization accept: cancel 77.22 88 9266
payment from customer: creation 66.32 107 7958
payment from customer: removal 6.13 72 736
payment to supplier: creation 53.84 111 6461
payment to supplier: removal 3.75 45 450
service: total inventory turnovers 5.26 862 631
service: total monetary turnovers 7.17 31 860
service: aggregate perf. data 0.90 16359 108
service: refresh index statistics 0.03 271514 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-12-2020 01:27:50 to 25-12-2020 01:27:52.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2056
TEST_TIME 2 3258
TEST_TIME 3 3624
TEST_TIME 4 3756
TEST_TIME 5 4535
TEST_TIME 6 4828
TEST_TIME 7 6058
TEST_TIME 8 6376
TEST_TIME 9 7721
TEST_TIME 10 8315
TEST_TIME 11 8137
TEST_TIME 12 8209
TEST_TIME 13 8676
TEST_TIME 14 8818
TEST_TIME 15 9274
TEST_TIME 16 9376
TEST_TIME 17 9787
TEST_TIME 18 10103
TEST_TIME 19 10186
TEST_TIME 20 10879
TEST_TIME 21 11054
TEST_TIME 22 11171
TEST_TIME 23 10998
TEST_TIME 24 10825
TEST_TIME 25 11006
TEST_TIME 26 11085
TEST_TIME 27 11190
TEST_TIME 28 11132
TEST_TIME 29 11211
TEST_TIME 30 10975
TEST_TIME 31 10759
TEST_TIME 32 10656
TEST_TIME 33 10614
TEST_TIME 34 10627
TEST_TIME 35 10524
TEST_TIME 36 10333
TEST_TIME 37 10302
TEST_TIME 38 10313
TEST_TIME 39 10205
TEST_TIME 40 10279
TEST_TIME 41 10397
TEST_TIME 42 10344
TEST_TIME 43 10421
TEST_TIME 44 10369
TEST_TIME 45 10254
TEST_TIME 46 10421
TEST_TIME 47 10315
TEST_TIME 48 10454
TEST_TIME 49 10501
TEST_TIME 50 10473
TEST_TIME 51 10428
TEST_TIME 52 10476
TEST_TIME 53 10464
TEST_TIME 54 10332
TEST_TIME 55 10182
TEST_TIME 56 10174
TEST_TIME 57 10205
TEST_TIME 58 10096
TEST_TIME 59 10004
TEST_TIME 60 9975
TEST_TIME 61 9913
TEST_TIME 62 9831
TEST_TIME 63 9844
TEST_TIME 64 9847
TEST_TIME 65 9922
TEST_TIME 66 9931
TEST_TIME 67 9968
TEST_TIME 68 9905
TEST_TIME 69 9948
TEST_TIME 70 9962
TEST_TIME 71 9943
TEST_TIME 72 9955
TEST_TIME 73 9977
TEST_TIME 74 9996
TEST_TIME 75 10009
TEST_TIME 76 10084
TEST_TIME 77 10094
TEST_TIME 78 10008
TEST_TIME 79 9939
TEST_TIME 80 9867
TEST_TIME 81 9856
TEST_TIME 82 9810
TEST_TIME 83 9741
TEST_TIME 84 9828
TEST_TIME 85 9835
TEST_TIME 86 9815
TEST_TIME 87 9800
TEST_TIME 88 9810
TEST_TIME 89 9769
TEST_TIME 90 9800
TEST_TIME 91 9854
TEST_TIME 92 9828
TEST_TIME 93 9870
TEST_TIME 94 9838
TEST_TIME 95 9838
TEST_TIME 96 9855
TEST_TIME 97 9882
TEST_TIME 98 9940
TEST_TIME 99 9941
TEST_TIME 100 9896
TEST_TIME 101 9868
TEST_TIME 102 9844
TEST_TIME 103 9815
TEST_TIME 104 9772
TEST_TIME 105 9697
TEST_TIME 106 9722
TEST_TIME 107 9765
TEST_TIME 108 9694
TEST_TIME 109 9706
TEST_TIME 110 9702
TEST_TIME 111 9672
TEST_TIME 112 9647
TEST_TIME 113 9709
TEST_TIME 114 9719
TEST_TIME 115 9826
TEST_TIME 116 9799
TEST_TIME 117 9792
TEST_TIME 118 9784
TEST_TIME 119 9849
TEST_TIME 120 9772

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 25-12-2020 01:27:53 to 25-12-2020 01:27:57.

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 1630223 1630223 0 0.00 0 43123 6 0 0
doc_list_biud 1630204 1630204 0 0.00 0 25843 20 0 0
sp_add_invoice_to_stock 5541 5403 138 2.49 22 223057 15509 0 138
sp_cancel_adding_invoice 5902 5902 0 0.00 5 51521 662 0 0
sp_cancel_client_order 1899 1899 0 0.00 4 10660 294 0 0
sp_cancel_customer_reserve 584925 584925 0 0.00 1 17397 44 0 0
sp_cancel_pay_from_customer 736 736 0 0.00 2 5393 73 0 0
sp_cancel_pay_to_supplier 450 450 0 0.00 2 1707 46 0 0
sp_cancel_supplier_invoice 6615 6608 7 0.10 1 25913 666 0 7
sp_cancel_supplier_order 430 430 0 0.00 9 608430 75941 0 0
sp_cancel_write_off 9266 9266 0 0.00 1 11176 88 0 0
sp_client_order 22917 22917 0 0.00 3 22738 326 0 0
sp_customer_reserve 494677 494677 0 0.00 0 65102 156 0 0
sp_fill_shopping_cart 34996 34996 0 0.00 1 22623 34 0 0
sp_fill_shopping_cart_clo_res 494671 494671 0 0.00 0 13953 12 0 0
sp_get_clo_for_invoice 5397 5397 0 0.00 0 28507 276 0 0
sp_kill_cost_storno 16354 16354 0 0.00 0 7191 43 0 0
sp_kill_qstorno_ret_qs2qd 1186154 1186154 0 0.00 0 25842 24 0 0
sp_kill_qty_storno 625404 625404 0 0.00 0 25843 52 0 0
sp_lock_selected_doc 22624 22624 0 0.00 0 10211 6 0 0
sp_make_cost_storno 30793 30793 0 0.00 0 43112 50 0 0
sp_multiply_rows_for_pdistr 30793 30793 0 0.00 0 10018 23 0 0
sp_multiply_rows_for_qdistr 22917 22917 0 0.00 0 21941 149 0 0
sp_pay_from_customer 7958 7958 0 0.00 4 35477 108 0 0
sp_pay_to_supplier 6461 6461 0 0.00 5 35478 111 0 0
sp_payment_common 14412 14412 0 0.00 1 24972 26 0 0
sp_qd_handle_on_cancel_clo 1899 1899 0 0.00 0 10653 259 0 0
sp_qd_handle_on_invoice_upd_sts 11299 11299 0 0.00 0 17020 255 0 0
sp_qd_handle_on_reserve_upd_sts 10977 10977 0 0.00 0 13703 46 0 0
sp_reserve_write_off 10977 10977 0 0.00 5 40660 142 0 0
sp_supplier_invoice 6121 6121 0 0.00 6 114265 2833 0 0
sp_supplier_order 5964 5964 0 0.00 5 56544 1123 0 0
srv_aggregate_perf_data 108 108 0 0.00 3171 153915 16359 0 0
srv_fill_mon_cache_memory 145 145 0 0.00 1339 142923 38754 0 0
srv_find_qd_qs_mism 1120011 1120011 0 0.00 0 17718 5 0 0
srv_make_invnt_saldo 631 631 0 0.00 43 51327 863 0 0
srv_make_money_saldo 860 860 0 0.00 0 7188 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 161084 370596 271515 0 0
t$perf-abend:sp_add_invoice_to_stock 138 138 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5403 5403 0 0.00 0 17257 128 0 0
t$perf-norm:sp_cancel_adding_invoice 447 447 0 0.00 0 1251 54 0 0
t$perf-norm:sp_cancel_client_order 1899 1899 0 0.00 0 3217 9 0 0
t$perf-norm:sp_cancel_customer_reserve 779 779 0 0.00 0 504 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 736 736 0 0.00 0 3117 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 450 450 0 0.00 0 1555 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 446 446 0 0.00 0 13895 38 0 0
t$perf-norm:sp_cancel_supplier_order 430 430 0 0.00 0 15943 1249 0 0
t$perf-norm:sp_cancel_write_off 1063 1063 0 0.00 0 487 2 0 0
t$perf-norm:sp_client_order 22917 22917 0 0.00 0 4901 12 0 0
t$perf-norm:sp_customer_reserve 1158 1158 0 0.00 0 2733 10 0 0
t$perf-norm:sp_pay_from_customer 7958 7958 0 0.00 0 7461 12 0 0
t$perf-norm:sp_pay_to_supplier 6461 6461 0 0.00 0 33684 18 0 0
t$perf-norm:sp_reserve_write_off 10977 10977 0 0.00 0 15237 10 0 0
t$perf-norm:sp_supplier_invoice 6121 6121 0 0.00 0 3933 13 0 0
t$perf-norm:sp_supplier_order 5964 5964 0 0.00 0 12576 16 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 200 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 145 145 0 0.00 0 297 4 0 0
t$perf-norm:srv_make_invnt_saldo 631 631 0 0.00 0 675 12 0 0
t$perf-norm:srv_make_money_saldo 860 860 0 0.00 0 4665 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 11070 10794 276 2.49 0 4488 17 0 276
v_all_customers 41140 41140 0 0.00 0 31 0 0 0
v_all_suppliers 33268 33268 0 0.00 0 19 1 0 0
v_all_wares 45826 45826 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 894 894 0 0.00 0 600 6 0 0
v_cancel_client_order 3798 3798 0 0.00 0 5964 9 0 0
v_cancel_customer_prepayment 1472 1472 0 0.00 0 4443 9 0 0
v_cancel_customer_reserve 1558 1558 0 0.00 0 2193 6 0 0
v_cancel_payment_to_supplier 900 900 0 0.00 0 1698 5 0 0
v_cancel_supplier_invoice 906 892 14 1.54 0 2919 22 0 14
v_cancel_supplier_order 860 860 0 0.00 0 2394 8 0 0
v_cancel_write_off 2126 2126 0 0.00 0 6219 17 0 0
v_max_id_clo_ord 5963 5963 0 0.00 0 362 1 0 0
v_max_id_clo_res 1158 1158 0 0.00 0 2828 19 0 0
v_max_id_ord_sup 6120 6120 0 0.00 0 3493 3 0 0
v_max_non_paid_invoice 1907 1907 0 0.00 0 494 2 0 0
v_max_non_paid_realizn 4476 4476 0 0.00 0 3785 4 0 0
v_min_id_clo_ord 5963 5963 0 0.00 0 1353 4 0 0
v_min_id_clo_res 1158 1158 0 0.00 0 590 2 0 0
v_min_id_ord_sup 6120 6120 0 0.00 0 5890 7 0 0
v_min_non_paid_invoice 6458 6458 0 0.00 0 4597 13 0 0
v_min_non_paid_realizn 7952 7952 0 0.00 0 4780 12 0 0
v_our_firm 11638 11638 0 0.00 0 87 1 0 0
v_reserve_write_off 21954 21954 0 0.00 0 3220 6 0 0
x_lock_depdocs_on_canc_invoice 12064 12064 0 0.00 0 22396 104 0 0
x_lock_depdocs_on_canc_sup_ord 430 430 0 0.00 0 19538 317 0 0
x_make_qstorno_1000_1200 5964 5964 0 0.00 1 56537 1057 0 0
x_make_qstorno_1200_2000 6121 6121 0 0.00 2 114188 2713 0 0
x_make_qstorno_2100_3300 494677 494677 0 0.00 0 65101 142 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-12-2020 01:27:58 to 25-12-2020 01:28:02.

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:08 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:15 14936 8192000000 10225717632 10527039488 942308704 10.316 75 53 107 1 961593504 2505088 16779712
22:57:38 19285 8192000000 10323580448 10633592832 1375671680 14.378 100 85 170 0 1407978416 4712000 27594736
22:58:10 20585 8192000000 10345806640 10659799040 1396227696 14.561 100 89 178 0 1431842112 6196256 29418160
22:58:39 21866 8192000000 10376420592 10700763136 1434273488 14.899 100 88 175 1 1470355152 7076736 29004928
22:59:15 16110 8192000000 10411267536 10738974720 1461120736 15.136 100 83 166 0 1495931264 7833216 26977312
22:59:42 24779 8192000000 10440962176 10771390464 1492450496 15.410 100 91 182 0 1530787824 8909424 29427904
23:00:22 20112 8192000000 10454773504 10791432192 1510583456 15.568 100 85 170 0 1547378464 9624448 27170560
23:00:53 5072 8192000000 10463809440 10802036736 1524607088 15.690 100 88 174 0 1562193344 9997872 27588384
23:01:08 15650 8192000000 10486206848 10829045760 1536915376 15.797 100 82 164 1 1573494144 10492784 26085984
23:01:30 15327 8192000000 10506326000 10851561472 1560666864 16.002 100 85 170 0 1597885104 10786576 26431664
23:01:56 14333 8192000000 10531240560 10884407296 1581993280 16.185 100 80 161 1 1617385168 11078288 24313600
23:02:18 9027 8192000000 10550364224 10910384128 1610977488 16.433 100 80 160 0 1646385072 11351680 24055904
23:02:35 10991 8192000000 10589241792 10946318336 1640551952 16.684 100 84 166 3 1676167296 11784496 23830848
23:02:55 11309 8192000000 10597700368 10963070976 1654180160 16.800 100 85 170 1 1692223120 12716832 25326128
23:03:16 8061 8192000000 10618554048 10985070592 1672398048 16.953 100 79 158 1 1708159616 12801600 22959968
23:03:36 5759 8192000000 10623796432 10997014528 1690811728 17.108 100 75 150 1 1725256720 12794656 21650336
23:03:49 6604 8192000000 10640614160 11011010560 1695804272 17.150 100 75 149 1 1730085088 13201152 21079664
23:04:04 5326 8192000000 10660338656 11034406912 1715138672 17.312 100 74 148 0 1750090848 13537200 21414976
23:04:17 5692 8192000000 10684251040 11057274880 1739139744 17.511 100 81 161 0 1775367088 12897824 23329520
23:04:29 6388 8192000000 10686219600 11062681600 1747771408 17.583 100 82 158 0 1782782080 12918352 22092320
23:04:43 5247 8192000000 10702395168 11080470528 1761367520 17.696 100 78 156 0 1796112544 12418544 22326480
23:04:54 4520 8192000000 10704009728 11084414976 1773057184 17.792 100 83 165 2 1807573488 11665152 22851152
23:05:08 4774 8192000000 10726005680 11106426880 1779563088 17.846 100 82 165 0 1814534960 12638272 22333600
23:05:19 2126 8192000000 10730356160 11106971648 1785718192 17.897 100 89 178 3 1824172336 13503424 24950720
23:05:28 2466 8192000000 10733588832 11112890368 1791677184 17.946 100 84 168 0 1828513824 14052960 22783680
23:05:37 2517 8192000000 10741079696 11119558656 1795070144 17.973 100 88 172 1 1833692560 14670144 23952272
23:05:46 2413 8192000000 10750192720 11126808576 1807942640 18.079 100 90 180 1 1847367872 14641440 24783792
23:05:55 2467 8192000000 10759065312 11140157440 1811397136 18.107 100 90 178 2 1849413088 13489536 24526416
23:06:04 2490 8192000000 10757219072 11138678784 1815989248 18.145 100 87 175 0 1853394112 13470064 23934800
23:06:14 5800 8192000000 10760601728 11144679424 1818654144 18.167 100 84 166 2 1856186768 14595632 22936992
23:06:26 3022 8192000000 10770842464 11155841024 1826716880 18.233 100 89 173 2 1864720320 14376752 23626688
23:06:35 1646 8192000000 10792099056 11176009728 1842699232 18.363 100 94 189 2 1884736544 15749584 26287728
23:06:44 2349 8192000000 10788829056 11176017920 1848717632 18.412 100 94 188 0 1889708336 14263968 26726736
23:06:52 2350 8192000000 10787121360 11177738240 1851403584 18.434 100 89 175 1 1889189824 13034240 24752000
23:07:01 1791 8192000000 10804392784 11191320576 1858521088 18.491 100 89 179 5 1895831808 12730000 24580720
23:07:09 1315 8192000000 10812828416 11198345216 1865421408 18.547 100 94 187 1 1904561744 13309984 25830352
23:07:16 2154 8192000000 10813053120 11202146304 1866144464 18.553 100 90 179 2 1905541984 13782272 25615248
23:07:25 1429 8192000000 10816952768 11204501504 1867527840 18.564 100 91 181 1 1906788192 13741568 25518784
23:07:33 1689 8192000000 10811687888 11201634304 1869287760 18.579 100 86 174 0 1905923808 12381360 24254688
23:07:41 1383 8192000000 10821331168 11209568256 1875347904 18.628 100 94 187 3 1913695136 11345872 27001360
23:07:48 33804 8192000000 10813845744 11211890688 1872329328 18.603 100 63 125 1 1899625392 9374624 17921440
23:08:28 13647 8192000000 10812195584 11219652608 1880375712 18.668 100 72 143 1 1911639328 11608576 19655040
23:08:50 2418 8192000000 10798997376 11216535552 1876713136 18.639 100 44 88 0 1899580976 10337936 12529904
23:08:59 5018 8192000000 10784755824 11210592256 1876986928 18.641 100 40 80 3 1895745376 7151584 11606864
23:09:10 3452 8192000000 10802997632 11219722240 1882702640 18.687 100 41 82 1 1901782208 6104368 12975200
23:09:20 13209 8192000000 10791322880 11215687680 1879359872 18.660 100 22 44 1 1891224384 5508000 6356512
23:09:44 4606 8192000000 10794828272 11220733952 1883640912 18.694 100 36 71 1 1900150224 6152128 10357184
23:09:55 7509 8192000000 10799121472 11225673728 1884973088 18.705 100 32 64 1 1902240464 8092752 9174624
23:10:09 7778 8192000000 10799102432 11224076288 1884804688 18.704 100 29 59 0 1901167360 7433392 8929280
23:10:24 7864 8192000000 10783884208 11223494656 1883726256 18.695 100 15 30 1 1894070368 6173104 4171008
23:10:42 12198 8192000000 10805758640 11233894400 1888205728 18.731 100 29 60 0 1906357472 10408032 7743712
23:11:02 6793 8192000000 10789383360 11225788416 1886724320 18.719 100 21 42 3 1899522000 6847440 5950240
23:11:19 7278 8192000000 10795648624 11229528064 1887217264 18.723 100 17 32 1 1898565568 6181712 5166592
23:11:32 14642 8192000000 10801351280 11231625216 1888595744 18.734 100 17 34 1 1900032224 6377616 5058864
23:11:53 7816 8192000000 10799907520 11231551488 1888212800 18.731 100 15 30 0 1898192800 5635360 4344640
23:12:10 6354 8192000000 10799905168 11234037760 1891959760 18.762 100 18 36 1 1903247632 6530816 4757056
23:12:23 57925 8192000000 10822893648 11244298240 1894206112 18.780 100 29 56 2 1906778144 4642368 7929664
23:13:27 15933 8192000000 10810060784 11243937792 1896898672 18.801 100 22 44 3 1909422640 6425360 6098608
23:13:49 6248 8192000000 10824812160 11255177216 1905848080 18.873 100 47 94 1 1927005872 8407424 12750368
23:14:03 5887 8192000000 10826652640 11254849536 1904351792 18.861 100 34 68 0 1919373872 5914368 9107712
23:14:15 3997 8192000000 10823723952 11257479168 1907397648 18.886 100 36 70 2 1923773680 6498000 9878032
23:14:26 7725 8192000000 10822650624 11257749504 1909151680 18.900 100 35 70 1 1926531328 6585120 10794528
23:14:40 8102 8192000000 10805172448 11250155520 1886918576 18.721 99 16 32 0 1897107376 5945120 4243680
23:14:56 7340 8192000000 10806006688 11244007424 1864769040 18.542 98 23 46 1 1876608464 5239600 6599824
23:15:13 4967 8192000000 10818880432 11251625984 1903904768 18.858 100 25 50 1 1916399744 5493696 7001280
23:15:26 7121 8192000000 10818940944 11252838400 1902810832 18.849 100 14 28 0 1912694400 5525024 4358544
23:15:41 7776 8192000000 10815691168 11254927360 1906187408 18.876 100 18 37 1 1916013072 4850192 4975472
23:15:57 5858 8192000000 10771424320 11209170944 1839969616 18.341 97 23 46 0 1852713376 5747760 6996000
23:16:09 8693 8192000000 10770569680 11205287936 1846976528 18.398 99 20 40 0 1858901936 5761616 6163792
23:16:32 7510 8192000000 10771607600 11198173184 1829315408 18.254 98 15 30 3 1839318992 5789856 4213728
23:16:47 39188 8192000000 10739594560 11166773248 1741216016 17.529 93 18 34 0 1751189120 5092720 4880384
23:17:49 29301 8192000000 10718273728 11145912320 1649534912 16.760 89 21 41 2 1660695264 5376320 5784032
23:18:25 9327 8192000000 10709432832 11127635968 1748849632 17.592 96 21 42 1 1764712960 9916704 5946624
23:18:41 3837 8192000000 10709707472 11130408960 1781358400 17.861 99 31 62 1 1801980960 11293776 9328784
23:18:55 7027 8192000000 10679766240 11089457152 1721455088 17.364 96 29 59 3 1735396224 5467488 8473648
23:19:11 6405 8192000000 10710264960 11124535296 1764164272 17.719 98 31 62 1 1778676992 4824528 9688192
23:19:27 5176 8192000000 10707335936 11115851776 1742798848 17.542 97 40 80 1 1760780288 6652256 11329184
23:19:41 6637 8192000000 10681035488 11093655552 1742212992 17.537 98 26 52 2 1755534016 5641584 7679440
23:19:54 6605 8192000000 10687544592 11097075712 1751054784 17.610 98 26 52 3 1765013568 6474912 7483872
23:20:08 6393 8192000000 10677814064 11093008384 1729915136 17.435 97 29 56 2 1744185184 5733888 8536160
23:20:23 9546 8192000000 10713627920 11130748928 1795601296 17.978 100 22 44 1 1808233152 5973136 6658720
23:20:41 10209 8192000000 10725091168 11146002432 1811295456 18.106 100 27 55 1 1828645744 9281504 8068784
23:20:59 9349 8192000000 10742008672 11164868608 1824663408 18.216 100 23 46 1 1836991664 5034768 7293488
23:21:23 6680 8192000000 10752968528 11170496512 1820680048 18.183 99 29 58 2 1838934944 9753536 8501360
23:21:36 16125 8192000000 10745940112 11160576000 1799540096 18.010 98 22 44 2 1811400928 5448512 6412320
23:21:58 57529 8192000000 10758578160 11174219776 1820841936 18.185 99 48 92 0 1839903200 5263120 13798144
23:23:02 11262 8192000000 10766040176 11180113920 1843063344 18.366 100 27 54 3 1858228128 6042880 9121904
23:23:22 7831 8192000000 10758117200 11186282496 1844437184 18.377 100 33 66 2 1860900832 7129216 9334432
23:23:39 4695 8192000000 10772249104 11194736640 1855591392 18.468 100 38 74 1 1872856544 6870192 10394960
23:23:52 6658 8192000000 10782831232 11200262144 1857805328 18.485 100 25 50 3 1870665344 5227152 7632864
23:24:05 9377 8192000000 10773912560 11204009984 1862834096 18.526 100 24 46 2 1875634800 5767760 7032944
23:24:25 11117 8192000000 10787105200 11211677696 1866427168 18.555 100 21 42 1 1878418304 5953904 6037232
23:24:44 8681 8192000000 10775864336 11212013568 1868030416 18.568 100 23 46 0 1884594080 10350912 6212752
23:25:00 16717 8192000000 10778984448 11217510400 1872558960 18.605 100 22 44 0 1884511440 5721744 6230736
23:25:26 9140 8192000000 10802278416 11227873280 1877636592 18.646 100 35 70 2 1897435984 9408432 10390960
23:25:43 9710 8192000000 10780908752 11217453056 1878011984 18.649 100 36 72 0 1894120144 4985408 11122752
23:26:02 10182 8192000000 10787256256 11220180992 1876011824 18.633 100 22 44 1 1888742176 5885072 6845280
23:26:19 16593 8192000000 10785284400 11221893120 1874672304 18.622 100 10 20 2 1882602560 5172256 2758000
23:26:43 15465 8192000000 10799346048 11229921280 1881706016 18.679 100 16 32 1 1892254160 6075584 4472560
23:27:05 130926 8192000000 10825803408 11249782784 1870780256 18.591 98 35 69 3 1886397568 6084064 9533248
23:29:29 12289 8192000000 10856687104 11279511552 1923423760 19.014 100 55 109 1 1949838304 10533200 15881344
23:29:50 19677 8192000000 10854502864 11280285696 1929654704 19.064 100 48 96 3 1952625792 9146656 13824432
23:30:16 18236 8192000000 10867186464 11299209216 1939171904 19.140 100 49 98 3 1962145120 9392128 13581088
23:30:57 9462 8192000000 10899153216 11319549952 1953324720 19.253 100 53 105 1 1978661072 10697840 14638512
23:31:13 15472 8192000000 10902540752 11326308352 1963904352 19.337 100 58 115 2 1992910768 12656176 16350240
23:31:35 21639 8192000000 10914543776 11338997760 1966440096 19.357 100 53 106 0 2000002640 17964512 15598032
23:32:08 17691 8192000000 10908930432 11334643712 1968072976 19.370 100 48 96 1 1995341856 13572496 13696384
23:32:33 16555 8192000000 10898353984 11336429568 1969719344 19.383 100 42 84 1 1995376528 13405968 12251216
23:32:59 12445 8192000000 10908563840 11342880768 1975943568 19.433 100 47 94 0 2004541152 14109776 14487808
23:33:19 29509 8192000000 10880307776 11316891648 1916805168 18.961 97 49 100 1 1946027104 13528000 15693936
23:33:59 9386 8192000000 10893909744 11319046144 1945262912 19.189 99 42 84 0 1977479504 19191200 13025392
23:34:17 7059 8192000000 10919784544 11347615744 1972484144 19.405 100 56 110 1 2008347856 18419712 17444000
23:34:35 6975 8192000000 10909377856 11342012416 1968898768 19.377 100 59 118 2 2006601392 19769088 17933536
23:34:53 3409 8192000000 10937559392 11352436736 1978846144 19.456 100 75 146 1 2018509200 17813312 21849744
23:35:05 1341 8192000000 10945547024 11357188096 1985086784 19.505 100 82 159 1 2026692672 17859856 23746032
23:35:13 1457 8192000000 10933353456 11346644992 1966855968 19.360 99 92 178 2 2012721856 18922688 26943200
23:35:21 6579 8192000000 10888661696 11306647552 1924508736 19.023 98 55 110 2 1960870400 19696560 16665104
23:35:36 2649 8192000000 10912476608 11330109440 1955496208 19.270 100 58 116 1 1994752272 21445584 17810480
23:35:47 13583 8192000000 10917197616 11330998272 1941460144 19.158 99 70 137 1 1986860480 24048432 21351904
23:36:07 7885 8192000000 10896285776 11314720768 1935448240 19.110 99 70 140 2 1982564272 25816128 21299904
23:36:23 17640 8192000000 10907021008 11339091968 1955156656 19.268 100 50 100 3 1990819232 20099568 15563008
23:36:48 8154 8192000000 10910087680 11340337152 1957880096 19.289 100 50 100 0 1994577760 21741136 14956528
23:37:02 1847 8192000000 10915836784 11329531904 1943334880 19.173 99 80 159 1 1985337488 17903984 24098624
23:37:11 3104 8192000000 10919938944 11334111232 1964164400 19.339 100 80 160 1 2007184752 19876272 23144080
23:37:20 2391 8192000000 10870874896 11290370048 1905863952 18.873 98 66 130 0 1945955472 20656096 19435424
23:37:31 6205 8192000000 10857625552 11297038336 1924661328 19.024 100 29 58 1 1949599264 15866224 9071712
23:37:44 25579 8192000000 10891071840 11313147904 1925294880 19.029 99 43 85 2 1955661968 16928752 13438336
23:38:17 4465 8192000000 10897584848 11318898688 1941281024 19.157 100 61 122 1 1980982144 20340256 19360864
23:38:31 18128 8192000000 10880080000 11311198208 1906931328 18.882 98 47 92 2 1942953344 21201360 14820656
23:38:58 3454 8192000000 10895177072 11315777536 1939439952 19.142 100 65 131 0 1981829456 22000688 20388816
23:39:10 6484 8192000000 10895332736 11319709696 1928401088 19.054 99 64 128 0 1971936800 23536432 19999280
23:39:27 5229 8192000000 10907638256 11335258112 1949390928 19.222 100 52 103 2 1990635952 25341408 15903616
23:39:40 2401 8192000000 10931642576 11345428480 1959352896 19.301 100 77 154 0 2010288480 26845520 24090064
23:39:50 5595 8192000000 10899698016 11313803264 1904370880 18.861 97 70 141 0 1952279536 26589792 21318864
23:40:03 3540 8192000000 10902947504 11323244544 1927866016 19.050 99 66 132 1 1972716624 25198400 19652208
23:40:14 6095 8192000000 10908181456 11325800448 1935504880 19.111 99 74 148 1 1981189888 23527632 22157376
23:40:27 4583 8192000000 10914727024 11334545408 1954245024 19.260 100 69 137 1 1997178896 22825072 20108800
23:40:41 3438 8192000000 10918757712 11330428928 1948256080 19.213 100 85 168 2 1999749776 26457456 25036240
23:40:54 3506 8192000000 10922938352 11339059200 1956806352 19.281 100 79 158 0 2007514640 27476112 23232176
23:41:05 4392 8192000000 10914656832 11322580992 1940859008 19.154 100 86 172 0 1994692976 27981696 25852272
23:41:17 3138 8192000000 10907552784 11311210496 1927730560 19.049 99 87 172 2 1979033216 25137600 26165056
23:41:27 3238 8192000000 10921649504 11327455232 1947141040 19.204 100 84 164 0 1999156848 27946512 24069296
23:41:37 1338 8192000000 10921814480 11322032128 1945161024 19.188 100 94 185 0 2001453904 28329856 27963024
23:41:46 4847 8192000000 10907720432 11328241664 1945661312 19.192 100 62 124 2 1995218656 30181984 19375360
23:41:58 4322 8192000000 10938721408 11345006592 1959496576 19.302 100 82 162 0 2016879744 31592688 25790480
23:42:09 4547 8192000000 10925234608 11341479936 1954204352 19.260 100 68 136 1 2007956832 32303152 21449328
23:42:21 7238 8192000000 10912423760 11343192064 1952905680 19.250 100 43 86 3 2000657696 33431008 14321008
23:42:38 10516 8192000000 10906367152 11334983680 1928607792 19.056 99 38 76 4 1972656640 31182064 12866784
23:42:58 8991 8192000000 10872682160 11300524032 1909775296 18.905 99 32 64 1 1948961936 28185664 11000976
23:43:19 15922 8192000000 10887005136 11319926784 1920686736 18.992 99 30 59 1 1957267136 26950928 9629472
23:43:41 11692 8192000000 10878360800 11316887552 1915629232 18.952 99 36 71 1 1958145088 30238128 12277728
23:43:59 7882 8192000000 10889113744 11319201792 1930791888 19.073 100 40 80 0 1974814176 31043552 12978736
23:44:23 23763 8192000000 10890840128 11331366912 1941220544 19.156 100 37 74 1 1984860032 30432112 13207376
23:44:56 22161 8192000000 10859013696 11289931776 1878310112 18.651 98 31 62 3 1920580016 31914752 10355152
23:45:28 10084 8192000000 10853494992 11289632768 1885893104 18.713 99 32 64 2 1923349904 26812304 10644496
23:45:48 8679 8192000000 10852673088 11290984448 1897786112 18.808 100 23 46 2 1928421200 23237792 7397296
23:46:08 17859 8192000000 10855807504 11281203200 1893170416 18.771 100 35 71 0 1930078272 25908016 10999840
23:46:36 16978 8192000000 10853104192 11288891392 1901506032 18.838 100 35 70 1 1939961136 26955200 11499904
23:47:04 14787 8192000000 10867267360 11308355584 1911230720 18.917 100 23 46 2 1947864944 28501360 8132864
23:47:25 20722 8192000000 10842980832 11286671360 1895550144 18.790 99 20 40 1 1926723280 24018944 7154192
23:47:59 34785 8192000000 10827487184 11284815872 1863491696 18.532 98 13 26 1 1889787120 21682752 4612672
23:48:44 48032 8192000000 10846176512 11290599424 1882597440 18.686 98 16 32 0 1894645952 7724384 4324128
23:49:42 27684 8192000000 10824734544 11264122880 1823994672 18.210 95 38 78 0 1844392320 8562208 11835440
23:50:17 22328 8192000000 10860324912 11291992064 1910640352 18.912 100 50 100 1 1936943632 11544064 14759216
23:50:53 54701 8192000000 10852621104 11298902016 1898342192 18.813 99 22 44 0 1917894592 13105392 6447008
23:51:55 25350 8192000000 10852047520 11297890304 1906280672 18.877 99 38 76 1 1931734656 13790704 11663280
23:52:37 53840 8192000000 10868100000 11328471040 1924414080 19.022 100 15 29 3 1944967264 16603008 3950176
23:54:14 91566 8192000000 10857180672 11319345152 1895017328 18.786 98 6 12 0 1911099952 14457120 1625504
23:56:32 130634 8192000000 10893715456 11342471168 1948732224 19.216 100 24 48 3 1965480352 9064368 7683760
23:58:52 62561 8192000000 10905950640 11356426240 1943887296 19.178 98 36 72 1 1964091520 9999216 10205008
00:00:10 90710 8192000000 10901282864 11350081536 1927887088 19.050 98 23 42 2 1948147680 14617216 5643376
00:01:47 18915 8192000000 10908961392 11365642240 1980865152 19.472 100 25 50 0 1994544848 6472064 7207632
00:02:12 16065 8192000000 10912436944 11371700224 1981190640 19.474 100 18 36 1 1992355232 6743936 4420656
00:02:36 46895 8192000000 10950477200 11398266880 1998669792 19.612 100 37 74 0 2023525296 13824672 11030832
00:03:35 80064 8192000000 10925950512 11393957888 1965900720 19.353 98 35 70 1 2001019216 23806752 11311744
00:05:01 43217 8192000000 10923435120 11399458816 1992582032 19.564 100 16 32 2 2022988752 25277088 5129632
00:05:54 78466 8192000000 10926858288 11400781824 1987413840 19.523 100 12 24 2 2013019280 21661344 3944096
00:07:18 54547 8192000000 10904117552 11395108864 1987988352 19.528 100 20 38 2 2015314752 20956800 6369600
00:08:19 31405 8192000000 10916969664 11387846656 1989634640 19.541 100 17 34 1 2001706592 7196208 4875744
00:09:01 30012 8192000000 10908545216 11367112704 1944777568 19.185 98 12 24 1 1955438016 7318000 3342448
00:09:39 34535 8192000000 10927808864 11382398976 1988296624 19.530 100 45 89 1 2010625264 9207616 13121024
00:10:42 75198 8192000000 10914355904 11384881152 1956554032 19.279 98 17 32 1 1970888224 9664400 4669792
00:12:04 24294 8192000000 10919960496 11357052928 1938918544 19.138 98 43 83 1 1959600016 8052160 12629312
00:12:34 56813 8192000000 10889447856 11364913152 1916430464 18.958 97 21 42 1 1937205136 14830592 5944080
00:13:58 142923 8192000000 10870634400 11334856704 1772441488 17.787 90 10 20 0 1784912720 10219712 2251520
00:16:51 44692 8192000000 10880992928 11327737856 1906990928 18.882 97 25 50 0 1922777440 9147760 6638752
00:17:43 36193 8192000000 10881353232 11328761856 1871192032 18.594 96 25 50 1 1891884752 14096608 6596112
00:18:26 41040 8192000000 10893501152 11346628608 1915526400 18.951 98 26 52 1 1936085536 13486224 7072912
00:19:16 23552 8192000000 10887922768 11341561856 1929168784 19.060 99 32 64 1 1955106416 16761168 9176464
00:19:50 61296 8192000000 10875704496 11344736256 1926344624 19.038 99 23 46 0 1946698832 14470464 5883744
00:20:58 117704 8192000000 10857560096 11319664640 1872490928 18.604 96 25 50 1 1890655504 11390992 6773584
00:23:22 38561 8192000000 10848824384 11302219776 1855618496 18.468 96 27 55 0 1876024112 12032784 8372832
00:24:20 77864 8192000000 10819164096 11299540992 1821426880 18.189 95 8 16 0 1831368816 8021680 1920256
00:25:44 36086 8192000000 10834364272 11312422912 1915239808 18.949 100 6 12 0 1926266080 9373856 1652416
00:26:26 34243 8192000000 10842515520 11305447424 1885968208 18.713 98 9 17 0 1896660432 8589776 2102448
00:27:09 45576 8192000000 10837601216 11300286464 1852137488 18.439 96 16 31 1 1863676544 7049984 4489072
00:28:01 60140 8192000000 10830411136 11301302272 1887084256 18.722 98 19 37 1 1901944128 9786704 5073168
00:29:32 110560 8192000000 10857921856 11343056896 1897082208 18.803 98 16 32 0 1924140800 22512656 4545936
00:31:59 51915 8192000000 10868263008 11326935040 1898669408 18.816 98 25 50 1 1919654608 13856320 7128880
00:33:02 38089 8192000000 10856540736 11321307136 1895529232 18.790 98 26 52 1 1911003024 8320640 7153152
00:33:56 50062 8192000000 10859846208 11335471104 1917603776 18.968 99 26 52 3 1936844800 12348768 6892256
00:34:53 40617 8192000000 10885783904 11330813952 1910540800 18.911 98 32 61 1 1931672400 12642672 8488928
00:35:42 80127 8192000000 10876517808 11353354240 1907626528 18.888 98 16 32 0 1924539792 12499136 4414128
00:37:12 88367 8192000000 10884516656 11347734528 1916252112 18.957 98 14 28 0 1934665808 14674832 3738864
00:38:49 54185 8192000000 10909950864 11362963456 1948916976 19.218 99 39 78 0 1971132336 11557072 10658288
00:39:52 17904 8192000000 10910255024 11374616576 1975582320 19.430 100 44 88 0 2002644368 14787712 12274336
00:40:16 39805 8192000000 10911801456 11374649344 1960679056 19.311 99 35 69 1 1982481168 12187216 9614896
00:41:08 38332 8192000000 10900887792 11371393024 1953206592 19.252 99 27 53 1 1972694512 12354672 7133248
00:41:55 112132 8192000000 10903289040 11371626496 1897974720 18.810 96 14 28 1 1921694240 19529440 4190080
00:44:03 127773 8192000000 10885377712 11363876864 1931225024 19.077 98 21 42 0 1951308560 14132800 5950736
00:46:25 66501 8192000000 10880912016 11345215488 1929955616 19.067 98 31 62 2 1952607888 13717712 8934560
00:47:44 6985 8192000000 10908190928 11361148928 1966801008 19.360 100 49 96 1 1995836304 14375632 14659664
00:48:03 58812 8192000000 10903434224 11383439360 1967752672 19.368 100 23 46 1 1989145136 15217648 6174816
00:49:08 74110 8192000000 10901727376 11387932672 1973566176 19.414 100 9 18 1 1997281552 20822576 2892800
00:50:46 40949 8192000000 10908426448 11388399616 1976512784 19.437 100 16 32 0 1996962816 15612624 4837408
00:51:36 54030 8192000000 10908027632 11384958976 1986908768 19.519 100 17 32 4 2003155536 10616368 5630400
00:52:59 57927 8192000000 10914378464 11402272768 1987685136 19.525 100 4 8 0 2000175952 11553088 937728
00:54:07 31333 8192000000 10925735440 11391569920 1993917568 19.575 100 35 70 0 2010119552 6703392 9498592
00:54:50 43254 8192000000 10915694272 11388788736 1976678096 19.438 99 23 44 3 1990616944 7722912 6215936
00:55:44 43982 8192000000 10908513360 11371593728 1911581072 18.919 96 18 36 3 1924351104 7972400 4797632
00:56:34 26440 8192000000 10894623040 11355181056 1918735952 18.977 97 32 62 3 1936702960 8804192 9162816
00:57:29 121025 8192000000 10868654864 11332493312 1840496112 18.345 94 18 36 1 1858951264 13308496 5146656
00:59:41 31230 8192000000 10900643056 11347324928 1883914656 18.697 96 37 73 1 1903364624 9281392 10168576
01:00:21 55626 8192000000 10879287776 11343863808 1913555008 18.935 98 27 54 2 1930100944 9331264 7214672
01:01:25 41090 8192000000 10888299792 11337068544 1901379456 18.837 97 28 56 0 1917041344 8069280 7592608
01:02:17 21324 8192000000 10907738096 11342422016 1940123520 19.148 99 47 94 1 1963548384 10769584 12655280
01:02:50 40327 8192000000 10878102560 11336478720 1901127424 18.835 97 39 78 0 1924925056 13098928 10698704
01:03:41 73561 8192000000 10891598528 11359645696 1877035824 18.641 96 32 64 2 1912091744 26645696 8410224
01:05:01 105838 8192000000 10855636944 11326341120 1811946208 18.112 93 11 22 1 1826252016 11650032 2655776
01:06:57 119477 8192000000 10863766112 11338268672 1927330272 19.046 99 24 48 0 1945837408 11230368 7276768
01:09:08 67038 8192000000 10860223392 11333410816 1913600448 18.936 98 11 22 1 1926414752 9344544 3469760
01:10:32 24813 8192000000 10834413888 11309723648 1908815504 18.897 99 17 34 1 1921379088 7675024 4888560
01:11:06 65483 8192000000 10873623856 11343097856 1945109984 19.188 100 18 36 1 1963978432 13530416 5338032
01:12:18 47759 8192000000 10890402128 11356876800 1958640672 19.295 100 13 26 0 1977220496 14557360 4022464
01:13:12 64233 8192000000 10850633008 11322306560 1896547792 18.799 97 19 37 0 1916556512 14255776 5752944
01:14:23 102624 8192000000 10874960288 11346845696 1943311776 19.173 100 11 23 1 1959834544 13157232 3365536
01:16:17 96229 8192000000 10863452704 11339862016 1874558784 18.621 96 6 12 0 1886125824 9589584 1977456
01:18:06 72347 8192000000 10886545200 11345436672 1882782368 18.688 96 21 40 2 1900316832 11869936 5664528
01:19:37 60873 8192000000 10863740528 11340390400 1880163840 18.666 97 22 44 1 1901502800 14934224 6404736
01:20:52 83700 8192000000 10878891088 11347709952 1911539952 18.919 98 29 59 2 1941894560 21254240 9100368
01:22:22 67466 8192000000 10870923968 11358273536 1892885760 18.769 97 12 24 0 1919442528 22606640 3950128
01:23:43 98788 8192000000 10869758608 11341545472 1902346832 18.845 98 20 40 1 1919864336 12176704 5340800
01:25:32 60039 8192000000 10909081248 11351150592 1910689680 18.912 98 32 63 2 1936416640 17011152 8715808
01:26:40 32334 8192000000 9325162368 9604009984 473566416 5.464 25 4 8 0 477778176 3432624 779136

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 25-12-2020 01:28:04 to 25-12-2020 01:28:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 138 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-12-2020 01:28:35 to 25-12-2020 01:28:37.

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          261201
MON$OLDEST_ACTIVE               261202
MON$OLDEST_SNAPSHOT             261202
MON$NEXT_TRANSACTION            261202
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                       2040416
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

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

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

25.12.20 01:28:38. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2020-12-25 01:28:40 No severe PSQL-related problems occured
25.12.20 01:28:41. End of report.