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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
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.26
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 17280408 kB
MemAvailable 31640900 kB
Buffers 0 kB
Cached 14410708 kB
SwapCached 0 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-03-06 01:27:23
DTS_END                         2021-03-06 01:27:23.7550
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_MAKE_MONEY_SALDO(33:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52402
TRN_ID                          252201
ATT_ID                          707
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: 9584.51 17998 1150141
customer order: creation 189.08 329 22689
customer order: refuse 16.40 321 1968
order to supplier: creation 50.48 1250 6058
order to supplier: removal 3.71 92619 445
invoice (draft): creation 49.92 3222 5990
invoice (draft): removal 53.33 732 6400
invoice accept: apply 44.53 17601 5344
invoice accept: cancel 49.10 811 5892
customer reserve: creation 4068.93 177 488271
customer reserve: removal 4741.53 57 568984
realization accept: apply 90.53 157 10863
realization accept: cancel 87.03 101 10444
payment from customer: creation 63.73 89 7647
payment from customer: removal 6.28 53 753
payment to supplier: creation 52.61 115 6313
payment to supplier: removal 3.67 63 440
service: total inventory turnovers 5.12 952 614
service: total monetary turnovers 7.53 41 904
service: aggregate perf. data 0.98 19128 118
service: refresh index statistics 0.03 222145 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-03-2021 01:28:54 to 06-03-2021 01:28:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6438
TEST_TIME 2 5390
TEST_TIME 3 5855
TEST_TIME 4 5789
TEST_TIME 5 5642
TEST_TIME 6 5575
TEST_TIME 7 5615
TEST_TIME 8 5413
TEST_TIME 9 5691
TEST_TIME 10 6021
TEST_TIME 11 6138
TEST_TIME 12 6456
TEST_TIME 13 6772
TEST_TIME 14 7132
TEST_TIME 15 7248
TEST_TIME 16 7274
TEST_TIME 17 7542
TEST_TIME 18 7666
TEST_TIME 19 7891
TEST_TIME 20 8143
TEST_TIME 21 8481
TEST_TIME 22 9169
TEST_TIME 23 9178
TEST_TIME 24 9458
TEST_TIME 25 9818
TEST_TIME 26 10351
TEST_TIME 27 10929
TEST_TIME 28 11266
TEST_TIME 29 11264
TEST_TIME 30 11340
TEST_TIME 31 11181
TEST_TIME 32 11061
TEST_TIME 33 10910
TEST_TIME 34 10990
TEST_TIME 35 11012
TEST_TIME 36 11084
TEST_TIME 37 10969
TEST_TIME 38 10732
TEST_TIME 39 10593
TEST_TIME 40 10501
TEST_TIME 41 10564
TEST_TIME 42 10374
TEST_TIME 43 10350
TEST_TIME 44 10253
TEST_TIME 45 10198
TEST_TIME 46 10153
TEST_TIME 47 10285
TEST_TIME 48 10261
TEST_TIME 49 10194
TEST_TIME 50 10068
TEST_TIME 51 10060
TEST_TIME 52 9959
TEST_TIME 53 10032
TEST_TIME 54 9926
TEST_TIME 55 9818
TEST_TIME 56 9778
TEST_TIME 57 9719
TEST_TIME 58 9696
TEST_TIME 59 9730
TEST_TIME 60 9682
TEST_TIME 61 9673
TEST_TIME 62 9724
TEST_TIME 63 9857
TEST_TIME 64 9824
TEST_TIME 65 9852
TEST_TIME 66 9846
TEST_TIME 67 9906
TEST_TIME 68 9893
TEST_TIME 69 9870
TEST_TIME 70 9840
TEST_TIME 71 10043
TEST_TIME 72 10058
TEST_TIME 73 9971
TEST_TIME 74 9886
TEST_TIME 75 9839
TEST_TIME 76 9770
TEST_TIME 77 9804
TEST_TIME 78 9784
TEST_TIME 79 9725
TEST_TIME 80 9686
TEST_TIME 81 9650
TEST_TIME 82 9670
TEST_TIME 83 9637
TEST_TIME 84 9678
TEST_TIME 85 9654
TEST_TIME 86 9694
TEST_TIME 87 9708
TEST_TIME 88 9725
TEST_TIME 89 9741
TEST_TIME 90 9745
TEST_TIME 91 9761
TEST_TIME 92 9817
TEST_TIME 93 9882
TEST_TIME 94 9903
TEST_TIME 95 9880
TEST_TIME 96 9860
TEST_TIME 97 9798
TEST_TIME 98 9769
TEST_TIME 99 9760
TEST_TIME 100 9762
TEST_TIME 101 9712
TEST_TIME 102 9703
TEST_TIME 103 9677
TEST_TIME 104 9614
TEST_TIME 105 9580
TEST_TIME 106 9588
TEST_TIME 107 9575
TEST_TIME 108 9567
TEST_TIME 109 9584
TEST_TIME 110 9633
TEST_TIME 111 9630
TEST_TIME 112 9621
TEST_TIME 113 9641
TEST_TIME 114 9630
TEST_TIME 115 9627
TEST_TIME 116 9588
TEST_TIME 117 9685
TEST_TIME 118 9657
TEST_TIME 119 9665
TEST_TIME 120 9586

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 06-03-2021 01:28:57 to 06-03-2021 01:29:01.

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 1603059 1603059 0 0.00 0 11721 6 0 0
doc_list_biud 1603059 1603059 0 0.00 0 41740 26 0 0
sp_add_invoice_to_stock 5455 5344 111 2.03 27 182220 17601 0 111
sp_cancel_adding_invoice 5892 5892 0 0.00 6 87130 812 0 0
sp_cancel_client_order 1968 1968 0 0.00 5 14170 321 0 0
sp_cancel_customer_reserve 568984 568984 0 0.00 1 41741 58 0 0
sp_cancel_pay_from_customer 753 753 0 0.00 2 1550 53 0 0
sp_cancel_pay_to_supplier 440 440 0 0.00 3 3480 64 0 0
sp_cancel_supplier_invoice 6415 6400 15 0.23 2 22511 733 0 15
sp_cancel_supplier_order 445 445 0 0.00 7 1132248 92620 0 0
sp_cancel_write_off 10444 10444 0 0.00 1 11048 102 0 0
sp_client_order 22689 22689 0 0.00 4 24167 330 0 0
sp_customer_reserve 488271 488271 0 0.00 0 142257 177 0 0
sp_fill_shopping_cart 34723 34723 0 0.00 1 18979 37 0 0
sp_fill_shopping_cart_clo_res 488265 488265 0 0.00 0 12967 12 0 0
sp_get_clo_for_invoice 5336 5336 0 0.00 0 22277 232 0 0
sp_kill_cost_storno 17529 17529 0 0.00 0 8780 50 0 0
sp_kill_qstorno_ret_qs2qd 1155257 1155257 0 0.00 0 41738 31 0 0
sp_kill_qty_storno 610332 610332 0 0.00 0 41740 67 0 0
sp_lock_selected_doc 22553 22553 0 0.00 0 7546 5 0 0
sp_make_cost_storno 30159 30159 0 0.00 0 10277 45 0 0
sp_multiply_rows_for_pdistr 30159 30159 0 0.00 0 9246 26 0 0
sp_multiply_rows_for_qdistr 22689 22689 0 0.00 0 14479 146 0 0
sp_pay_from_customer 7647 7647 0 0.00 4 12845 90 0 0
sp_pay_to_supplier 6313 6313 0 0.00 5 14994 116 0 0
sp_payment_common 13960 13960 0 0.00 1 12923 29 0 0
sp_qd_handle_on_cancel_clo 1968 1968 0 0.00 0 14163 291 0 0
sp_qd_handle_on_invoice_upd_sts 11228 11228 0 0.00 0 25096 326 0 0
sp_qd_handle_on_reserve_upd_sts 10863 10863 0 0.00 0 22824 54 0 0
sp_reserve_write_off 10863 10863 0 0.00 7 22851 157 0 0
sp_supplier_invoice 5990 5990 0 0.00 6 86200 3222 0 0
sp_supplier_order 6058 6058 0 0.00 6 30945 1250 0 0
srv_aggregate_perf_data 118 118 0 0.00 2090 324033 19128 0 0
srv_fill_mon_cache_memory 174 174 0 0.00 1047 157177 29133 0 0
srv_find_qd_qs_mism 1099129 1099129 0 0.00 0 11077 5 0 0
srv_make_invnt_saldo 614 614 0 0.00 21 33408 953 0 0
srv_make_money_saldo 904 904 0 0.00 1 15157 41 0 0
srv_recalc_idx_stat 4 4 0 0.00 114026 302803 222145 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5344 5344 0 0.00 0 21940 207 0 0
t$perf-norm:sp_cancel_adding_invoice 458 458 0 0.00 0 7953 90 0 0
t$perf-norm:sp_cancel_client_order 1968 1968 0 0.00 0 7376 18 0 0
t$perf-norm:sp_cancel_customer_reserve 732 732 0 0.00 0 1629 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 753 753 0 0.00 0 5551 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 440 440 0 0.00 0 606 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 468 468 0 0.00 0 2585 18 0 0
t$perf-norm:sp_cancel_supplier_order 445 445 0 0.00 0 18534 1379 0 0
t$perf-norm:sp_cancel_write_off 1090 1090 0 0.00 0 3320 7 0 0
t$perf-norm:sp_client_order 22689 22689 0 0.00 0 12481 20 0 0
t$perf-norm:sp_customer_reserve 1060 1060 0 0.00 0 7329 17 0 0
t$perf-norm:sp_pay_from_customer 7647 7647 0 0.00 0 5660 9 0 0
t$perf-norm:sp_pay_to_supplier 6313 6313 0 0.00 0 17986 16 0 0
t$perf-norm:sp_reserve_write_off 10863 10863 0 0.00 0 9697 13 0 0
t$perf-norm:sp_supplier_invoice 5990 5990 0 0.00 0 9952 21 0 0
t$perf-norm:sp_supplier_order 6058 6058 0 0.00 0 8230 19 0 0
t$perf-norm:srv_aggregate_perf_data 118 118 0 0.00 0 424 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 21050 148 0 0
t$perf-norm:srv_make_invnt_saldo 614 614 0 0.00 0 3271 22 0 0
t$perf-norm:srv_make_money_saldo 904 904 0 0.00 0 1953 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 2 0 0
v_add_invoice_to_stock 10894 10672 222 2.03 0 5998 17 0 222
v_all_customers 41410 41410 0 0.00 0 46 1 0 0
v_all_suppliers 32946 32946 0 0.00 0 16 1 0 0
v_all_wares 45368 45368 0 0.00 0 110 1 0 0
v_cancel_adding_invoice 916 916 0 0.00 0 225 5 0 0
v_cancel_client_order 3936 3936 0 0.00 0 3296 6 0 0
v_cancel_customer_prepayment 1506 1506 0 0.00 0 297 2 0 0
v_cancel_customer_reserve 1464 1464 0 0.00 0 970 4 0 0
v_cancel_payment_to_supplier 880 880 0 0.00 0 3475 7 0 0
v_cancel_supplier_invoice 966 936 30 3.10 0 5493 21 0 30
v_cancel_supplier_order 890 890 0 0.00 0 2743 7 0 0
v_cancel_write_off 2180 2180 0 0.00 0 1532 12 0 0
v_max_id_clo_ord 6056 6056 0 0.00 0 1712 2 0 0
v_max_id_clo_res 1060 1060 0 0.00 0 2148 16 0 0
v_max_id_ord_sup 5983 5983 0 0.00 0 3872 5 0 0
v_max_non_paid_invoice 1879 1879 0 0.00 0 4059 8 0 0
v_max_non_paid_realizn 4100 4100 0 0.00 0 4662 5 0 0
v_min_id_clo_ord 6056 6056 0 0.00 0 3501 8 0 0
v_min_id_clo_res 1060 1060 0 0.00 0 6870 16 0 0
v_min_id_ord_sup 5983 5983 0 0.00 0 8338 11 0 0
v_min_non_paid_invoice 6313 6313 0 0.00 0 12920 21 0 0
v_min_non_paid_realizn 7647 7647 0 0.00 0 6270 16 0 0
v_our_firm 11052 11052 0 0.00 0 128 1 0 0
v_reserve_write_off 21726 21726 0 0.00 0 2748 4 0 0
x_lock_depdocs_on_canc_invoice 11824 11824 0 0.00 0 20261 115 0 0
x_lock_depdocs_on_canc_sup_ord 445 445 0 0.00 0 10910 365 0 0
x_make_qstorno_1000_1200 6058 6058 0 0.00 2 30917 1164 0 0
x_make_qstorno_1200_2000 5990 5990 0 0.00 3 86151 3097 0 0
x_make_qstorno_2100_3300 488271 488271 0 0.00 0 142257 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-03-2021 01:29:02 to 06-03-2021 01:29:06.

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:26 3 8192000000 8800689632 8811872256 6822176 0.083 2 1 2 0 6941552 56816 62560
22:57:33 20698 8192000000 10287028992 10599231488 1077161760 11.620 81 69 137 1 1102564992 3024752 22378480
22:58:03 26667 8192000000 10373799984 10692100096 1426184000 14.827 100 92 185 0 1460424656 5307664 28932992
22:58:41 16042 8192000000 10388517648 10713313280 1451938576 15.055 100 91 183 0 1488664528 7121152 29604800
22:59:07 21799 8192000000 10424946432 10753327104 1471311728 15.225 100 83 166 0 1510566736 12395856 26859152
22:59:49 9384 8192000000 10451823280 10784174080 1502430880 15.497 100 86 172 0 1538764096 8898432 27434784
23:00:09 24864 8192000000 10475311216 10811990016 1526665808 15.708 100 92 184 3 1565571744 9694928 29211008
23:00:45 14162 8192000000 10485385552 10825355264 1541565344 15.837 100 91 182 0 1580397328 10179216 28652768
23:01:06 25729 8192000000 10506699152 10854273024 1560672576 16.002 100 86 173 0 1598133424 10724592 26736256
23:01:44 24054 8192000000 10536963600 10887983104 1587850400 16.235 100 87 175 2 1625593376 11131392 26611584
23:02:18 16567 8192000000 10550841632 10905096192 1604744224 16.380 100 77 154 0 1639381840 11398464 23239152
23:02:43 8628 8192000000 10568313840 10924756992 1623134928 16.537 100 78 156 1 1658459152 11950448 23373776
23:03:01 10788 8192000000 10587943488 10946158592 1643177120 16.707 100 82 164 1 1679222192 11863008 24182064
23:03:19 13595 8192000000 10600850416 10962759680 1650709920 16.770 100 84 168 2 1688655856 13363488 24582448
23:03:40 10019 8192000000 10615085424 10979340288 1669542768 16.929 100 85 166 1 1707364672 13058960 24762944
23:03:57 11703 8192000000 10627125648 10992201728 1684040720 17.051 100 87 174 1 1723114464 13933808 25139936
23:04:15 6698 8192000000 10640325888 11006377984 1698654400 17.174 100 92 184 1 1739861264 14252208 26954656
23:04:33 5561 8192000000 10645919200 11020242944 1706060208 17.236 100 79 158 1 1742990224 14024912 22905104
23:04:46 6453 8192000000 10666109952 11037179904 1719381376 17.347 100 85 168 1 1757373456 13819712 24172368
23:04:59 4744 8192000000 10665226976 11042394112 1727464192 17.414 100 81 162 3 1762935040 13035376 22435472
23:05:10 9088 8192000000 10672079872 11050528768 1742127536 17.536 100 81 162 1 1778014992 12759056 23128400
23:05:27 3901 8192000000 10702364528 11073253376 1758671472 17.673 100 78 156 0 1794451792 13300752 22479568
23:05:38 4968 8192000000 10709292192 11086966784 1770962064 17.775 100 85 170 1 1809311584 14274768 24074752
23:05:49 4572 8192000000 10713644320 11095248896 1777318944 17.827 100 87 172 2 1815736240 14349520 24067776
23:06:00 5139 8192000000 10724579824 11106705408 1786357536 17.902 100 74 149 1 1820238416 13389200 20491680
23:06:13 3998 8192000000 10738399392 11120418816 1797212576 17.991 100 79 158 1 1833530080 14053296 22264208
23:06:24 8564 8192000000 10740830560 11123806208 1806591184 18.068 100 83 166 0 1844174992 14070544 23513264
23:06:39 2136 8192000000 10756771552 11137527808 1820074192 18.178 100 84 169 0 1854969552 11738144 23157216
23:06:49 2135 8192000000 10783522752 11164688384 1833118400 18.285 100 91 182 0 1872014048 12716064 26179584
23:06:58 2357 8192000000 10787264784 11171393536 1841739344 18.355 100 88 176 1 1878826480 13788944 23298192
23:07:07 1621 8192000000 10794166256 11179012096 1847228736 18.400 100 86 173 1 1885783728 14236048 24318944
23:07:16 1638 8192000000 10785176128 11170639872 1848840448 18.413 100 86 172 1 1885474704 13217552 23416704
23:07:24 1853 8192000000 10806178544 11191746560 1860808272 18.510 100 92 184 2 1904713536 17778896 26126368
23:07:32 1130 8192000000 10805316704 11190657024 1863727440 18.533 100 91 182 1 1902146336 13454928 24963968
23:07:39 1464 8192000000 10805414240 11199864832 1867287568 18.562 100 86 172 1 1904396560 13825632 23283360
23:07:48 1999 8192000000 10811690064 11199873024 1869495008 18.580 100 90 179 1 1909283184 14823504 24964672
23:07:57 1261 8192000000 10808711680 11198709760 1866714688 18.558 100 90 180 1 1906371248 13730752 25925808
23:08:04 1208 8192000000 10820589184 11208761344 1873839008 18.615 100 89 180 1 1912175856 11972048 26364800
23:08:11 1418 8192000000 10810102352 11204915200 1872928080 18.608 100 77 155 1 1907253216 12469104 21856032
23:08:20 3452 8192000000 10819637952 11213893632 1874959376 18.624 100 81 162 1 1910909744 13722144 22228224
23:08:31 8354 8192000000 10807763808 11205341184 1871032144 18.593 100 70 140 4 1902150752 11704736 19413872
23:08:46 1439 8192000000 10809266144 11211239424 1879162976 18.658 100 82 168 1 1917806080 15692496 22950608
23:08:55 41478 8192000000 10789693936 11205701632 1871297088 18.595 100 40 80 1 1890137264 6564256 12275920
23:09:44 6102 8192000000 10772451456 11205251072 1868678768 18.574 100 21 42 0 1881875792 7017456 6179568
23:09:58 6858 8192000000 10781847216 11209035776 1872765904 18.607 100 25 50 0 1886988192 6483984 7738304
23:10:11 7431 8192000000 10789930320 11216240640 1879566144 18.662 100 34 68 3 1900431344 11366640 9498560
23:10:25 8051 8192000000 10790794912 11222880256 1885094128 18.706 100 28 56 3 1899447456 6855072 7498256
23:10:43 7857 8192000000 10789638048 11225530368 1890028432 18.746 100 24 47 1 1902831104 5556832 7245840
23:10:57 4988 8192000000 10801313984 11230027776 1892087968 18.763 100 21 42 1 1905228560 6707824 6432768
23:11:11 11284 8192000000 10805888624 11235110912 1893249504 18.772 100 25 50 4 1906631456 6381632 7000320
23:11:33 7450 8192000000 10807088720 11242008576 1897223232 18.804 100 22 44 3 1914985376 10415968 7346176
23:11:47 12517 8192000000 10806314128 11238821888 1897369408 18.805 100 23 46 0 1910200128 5969408 6861312
23:12:12 13163 8192000000 10805668992 11243028480 1899725888 18.824 100 15 30 3 1909661808 5866944 4068976
23:12:32 9151 8192000000 10812105648 11249577984 1904740896 18.864 100 22 44 2 1920156320 9500448 5914976
23:12:47 7755 8192000000 10815759552 11249090560 1908514912 18.895 100 25 50 2 1922324608 7287408 6522288
23:13:01 12725 8192000000 10816831104 11253006336 1911763552 18.921 100 23 46 1 1925099104 6514096 6821456
23:13:21 61506 8192000000 10845102864 11266113536 1912329808 18.925 100 31 62 0 1926548656 4771648 9447200
23:14:28 3786 8192000000 10834543536 11268022272 1918947200 18.978 100 50 100 1 1942471104 9467216 14056688
23:14:38 10575 8192000000 10839822624 11272912896 1918832160 18.977 100 40 78 0 1937905184 8243424 10829600
23:15:01 5692 8192000000 10830713536 11267301376 1913442208 18.934 100 32 65 3 1929422272 6892048 9088016
23:15:18 3959 8192000000 10847356912 11275931648 1922690688 19.008 100 50 97 2 1943229040 7486976 13051376
23:15:31 5498 8192000000 10850513808 11268415488 1918043120 18.971 100 38 76 4 1935734320 6093280 11597920
23:15:42 8601 8192000000 10828456048 11258798080 1910301008 18.909 100 25 51 4 1923554416 5724080 7529328
23:15:57 3284 8192000000 10835033120 11266097152 1914011168 18.939 100 37 75 2 1931676816 6624464 11041184
23:16:07 7752 8192000000 10821155680 11258662912 1899361680 18.821 99 30 60 1 1914473664 5959792 9152192
23:16:21 7759 8192000000 10805931760 11246030848 1898720096 18.816 99 34 68 1 1915241104 6277488 10243520
23:16:35 8773 8192000000 10813039424 11243794432 1879404896 18.660 99 20 40 2 1891902544 5398720 7098928
23:16:55 6919 8192000000 10811408560 11245899776 1871373712 18.595 98 26 51 2 1884578992 6145120 7060160
23:17:09 59050 8192000000 10777891952 11212738560 1820773424 18.184 96 33 66 0 1835167456 4982288 9411744
23:18:16 6848 8192000000 10781657408 11217006592 1862524720 18.524 99 22 44 0 1874923440 5836560 6562160
23:18:35 5814 8192000000 10763694816 11185340416 1782061824 17.866 95 31 60 3 1796721392 6537984 8121584
23:18:50 5920 8192000000 10759285088 11186221056 1814443616 18.132 98 20 40 1 1826032352 5518736 6070000
23:19:03 7986 8192000000 10766689472 11184934912 1813377008 18.124 98 34 68 1 1830087376 6990064 9720304
23:19:18 7297 8192000000 10749885776 11176288256 1823663168 18.208 99 33 66 1 1839790656 6033248 10094240
23:19:32 5076 8192000000 10725611008 11139760128 1778859488 17.840 97 26 52 0 1790833264 4696848 7276928
23:19:45 7989 8192000000 10696624352 11104169984 1696368128 17.155 94 26 52 1 1714117904 9580848 8168928
23:20:02 8796 8192000000 10671464288 11088052224 1669333536 16.928 93 18 36 0 1679852224 5961248 4557440
23:20:18 5706 8192000000 10648535856 11059900416 1709401152 17.264 97 25 50 2 1722534336 5724864 7408320
23:20:30 5384 8192000000 10645222464 11059777536 1705061760 17.227 97 26 52 5 1719102672 6435312 7605600
23:20:41 8780 8192000000 10674064768 11091722240 1722557392 17.374 97 17 34 1 1732951648 5695520 4698736
23:20:57 11242 8192000000 10699597344 11120967680 1788499584 17.919 100 27 54 2 1802239280 5352256 8387440
23:21:18 12939 8192000000 10708530576 11104092160 1742882272 17.543 97 23 46 1 1754157472 5005280 6269920
23:21:37 64337 8192000000 10727138688 11145859072 1794569936 17.969 99 23 46 1 1806721696 5805872 6345888
23:22:48 11274 8192000000 10734630928 11154059264 1817438688 18.157 99 26 49 1 1836905904 9711920 9755296
23:23:09 6521 8192000000 10745617392 11160727552 1807191536 18.073 99 28 56 1 1822422512 7433728 7797248
23:23:21 8869 8192000000 10747502416 11169251328 1828823728 18.250 100 22 44 0 1841433904 6266256 6343920
23:23:38 7943 8192000000 10755705728 11172028416 1835422976 18.304 100 34 67 1 1850398320 5043760 9931584
23:23:55 7845 8192000000 10756402048 11172626432 1820739152 18.184 99 25 50 1 1833857648 5958464 7160032
23:24:11 4899 8192000000 10758065360 11182280704 1842723616 18.363 100 25 47 1 1855192384 6385136 6083632
23:24:23 8325 8192000000 10755273632 11189370880 1851112480 18.431 100 27 54 1 1864904032 6196896 7594656
23:24:37 8560 8192000000 10770150192 11197689856 1856130192 18.472 100 26 52 0 1870142464 6726720 7285552
23:24:53 13916 8192000000 10770436128 11197186048 1858612656 18.492 100 21 42 0 1870582384 6130544 5839184
23:25:14 13867 8192000000 10769071424 11200159744 1861859184 18.518 100 16 32 1 1872085504 5131424 5094896
23:25:34 7077 8192000000 10784666016 11213463552 1869062672 18.577 100 23 44 1 1880796176 5261328 6472176
23:25:50 7272 8192000000 10786248672 11215319040 1874712608 18.622 100 32 62 4 1889353728 5365952 9275168
23:26:03 21243 8192000000 10785300256 11215319040 1872559600 18.605 100 18 36 1 1883914256 5793232 5561424
23:26:31 76623 8192000000 10818484112 11237666816 1888254752 18.732 100 36 72 0 1903850384 4887184 10708448
23:28:02 2282 8192000000 10845886272 11257483264 1915648544 18.952 100 62 124 2 1942667984 8616720 18402720
23:28:10 1271 8192000000 10873427136 11279200256 1925050080 19.027 100 78 152 1 1957008896 10243312 21715504
23:28:20 28474 8192000000 10848059040 11267076096 1905386144 18.870 99 60 119 2 1931574880 9562032 16626704
23:28:55 12062 8192000000 10862753872 11283476480 1927455360 19.047 100 56 111 1 1953523712 10374048 15694304
23:29:17 27755 8192000000 10864926608 11292672000 1934181696 19.100 100 53 106 1 1960204512 11327568 14695248
23:29:55 4015 8192000000 10879174272 11300827136 1940151632 19.148 100 54 106 4 1967804272 12497696 15154944
23:30:06 11976 8192000000 10883335568 11301552128 1924893952 19.026 99 56 112 1 1958149904 17029600 16226352
23:30:34 4395 8192000000 10885340224 11307593728 1944802352 19.185 100 62 124 1 1975741424 12833840 18105232
23:30:45 13015 8192000000 10887298592 11314405376 1952838640 19.249 100 60 116 1 1982140304 12587376 16714288
23:31:07 5554 8192000000 10891147872 11318882304 1956023072 19.274 100 52 103 2 1984500096 12900912 15576112
23:31:20 9423 8192000000 10902607072 11325214720 1962515440 19.326 100 52 104 0 1990511072 13423760 14571872
23:31:36 12230 8192000000 10892733552 11322662912 1957649648 19.287 100 51 102 1 1986249696 13563344 15036704
23:31:57 15149 8192000000 10900332608 11322466304 1956448736 19.278 100 52 104 3 1986005856 14708288 14848832
23:32:24 10822 8192000000 10900855552 11329495040 1959584480 19.303 100 51 102 0 1989217856 14588416 15044960
23:32:55 32285 8192000000 10899255968 11336597504 1969698928 19.383 100 38 76 1 1997194960 16290976 11205056
23:33:36 4913 8192000000 10917664544 11352158208 1978314752 19.451 100 45 90 2 2007611920 15840256 13456912
23:33:47 2962 8192000000 10925487536 11355496448 1982682144 19.486 100 51 102 2 2013519280 16133952 14703184
23:34:09 29263 8192000000 10934394080 11367923712 1991329392 19.554 100 58 116 0 2030216400 21369968 17517040
23:34:51 14621 8192000000 10948458352 11380543488 1999405040 19.618 100 43 86 1 2033323824 20950944 12967840
23:35:19 13595 8192000000 10931374448 11366764544 1983958464 19.496 100 47 94 0 2021083056 23323696 13800896
23:35:50 13222 8192000000 10945590544 11383173120 1997131056 19.600 100 50 98 0 2039922640 27662416 15129168
23:36:15 14434 8192000000 10951622608 11379916800 1992065920 19.560 100 50 99 1 2035361008 27684336 15610752
23:36:37 13168 8192000000 10944049376 11376193536 1971837152 19.400 99 49 97 0 2017193824 30028720 15327952
23:36:58 11467 8192000000 10944929552 11385991168 1993042768 19.568 100 39 78 1 2037348528 30992976 13312784
23:37:18 6689 8192000000 10952631728 11388014592 1998041488 19.607 100 50 100 2 2045630336 31222320 16366528
23:37:34 7958 8192000000 10951752256 11392512000 2002692928 19.644 100 46 92 2 2047436032 30822688 13920416
23:37:54 6341 8192000000 10949162320 11391488000 1999893440 19.622 100 56 112 2 2048223680 30147008 18183232
23:38:07 4012 8192000000 10959569536 11388465152 1996002176 19.591 100 57 114 0 2044596400 30834288 17759936
23:38:19 6144 8192000000 10962137216 11394813952 2007117376 19.679 100 75 150 1 2061511936 31309440 23085120
23:38:33 8567 8192000000 10968452464 11399892992 2004272848 19.656 100 61 121 2 2053446832 30671280 18502704
23:39:00 9785 8192000000 10963032656 11398926336 2003730768 19.652 100 61 122 0 2057618944 35340752 18547424
23:39:16 4643 8192000000 10967009840 11397586944 1987109920 19.521 99 59 117 0 2039437168 34186800 18140448
23:39:29 6706 8192000000 10966149264 11392503808 1984786384 19.503 99 57 114 3 2035907216 34283136 16837696
23:39:43 3589 8192000000 10979101712 11395362816 1997966736 19.607 100 84 166 0 2058197888 35705408 24525744
23:39:54 4899 8192000000 10975282416 11391500288 1999490224 19.619 100 79 156 0 2058606688 34862496 24253968
23:40:08 3976 8192000000 10985688816 11402670080 2001814176 19.637 100 85 169 1 2064479664 37063744 25601744
23:40:22 2657 8192000000 10945766160 11356262400 1947112624 19.203 97 76 150 2 2007751648 38533536 22105488
23:40:31 3051 8192000000 10972331312 11386802176 1989644784 19.541 100 88 171 4 2054963680 38267440 27051456
23:40:41 1678 8192000000 10984797568 11398873088 1998061920 19.607 100 93 187 2 2063808240 38841696 26904624
23:40:50 1439 8192000000 10979705584 11391500288 1994365488 19.578 100 95 187 1 2062532480 40204416 27962576
23:40:58 2273 8192000000 10974813952 11388850176 1980319424 19.467 99 86 170 0 2046694336 40324384 26050528
23:41:07 4078 8192000000 10980928512 11394183168 1990945664 19.551 100 81 156 0 2053355056 39310272 23099120
23:41:19 4049 8192000000 10970252624 11389190144 1985860256 19.511 100 84 168 0 2049591680 39321760 24409664
23:41:29 3564 8192000000 10948972656 11367706624 1958373200 19.293 99 70 139 3 2018883888 39110192 21400496
23:41:39 3557 8192000000 10974420832 11393933312 1993903296 19.575 100 84 168 1 2058314992 39143008 25268688
23:41:51 2221 8192000000 10968265408 11383517184 1982774736 19.487 100 91 176 1 2049259968 39800448 26684784
23:41:59 4270 8192000000 10957206352 11379933184 1980112576 19.466 100 77 154 1 2044246176 40645120 23488480
23:42:13 6896 8192000000 10936207360 11360673792 1920120240 18.988 97 54 107 0 1975709632 39266848 16322544
23:42:27 7940 8192000000 10947163712 11377111040 1972071568 19.402 100 61 120 3 2031143152 39727120 19344464
23:42:43 3532 8192000000 10950427392 11382194176 1966764752 19.360 99 65 126 0 2026037632 39135008 20137872
23:42:53 2211 8192000000 10969021776 11387920384 1983267776 19.491 100 80 160 4 2050195264 41728720 25198768
23:43:03 5303 8192000000 10971234496 11387817984 1972221728 19.403 99 88 176 1 2043625392 43675728 27727936
23:43:18 6278 8192000000 10975962336 11398426624 1993440416 19.571 100 75 150 2 2059703680 43569056 22694208
23:43:31 2647 8192000000 10983815216 11394875392 1961968784 19.322 98 90 179 2 2035891968 46462112 27461072
23:43:41 4851 8192000000 10977650768 11400581120 1992657712 19.565 100 79 156 0 2064030352 47178032 24194608
23:43:58 2244 8192000000 10978390384 11404492800 1995284864 19.586 100 75 150 3 2067043904 47629840 24129200
23:44:12 4884 8192000000 10993914272 11417956352 2006676912 19.675 100 77 153 2 2079626000 48267824 24681264
23:44:27 5690 8192000000 10976977712 11402178560 1987434288 19.524 100 57 114 0 2054379344 49127264 17817792
23:44:41 2479 8192000000 10984562000 11400953856 1984721760 19.502 100 86 171 1 2060267632 48706640 26839232
23:44:51 2416 8192000000 10983824336 11400093696 1993658016 19.573 100 84 163 1 2061373488 43124368 24591104
23:45:00 4046 8192000000 10958032064 11373035520 1960279328 19.308 98 88 174 3 2032187728 45366512 26541888
23:45:11 2949 8192000000 10990973344 11403227136 1992063680 19.560 100 84 169 1 2063896272 46326016 25506576
23:45:21 4677 8192000000 10984332992 11398279168 1982623744 19.485 100 83 165 0 2058446720 49858608 25964368
23:45:35 2235 8192000000 10972349696 11392045056 1979860256 19.464 100 95 190 1 2060142256 50503984 29778016
23:45:44 2379 8192000000 10981829552 11397857280 1981529296 19.477 100 82 164 3 2057138272 50315616 25293360
23:45:54 2703 8192000000 10988827120 11400417280 1984637296 19.501 100 85 171 0 2061975648 51512032 25826320
23:46:05 3094 8192000000 10988568000 11406012416 1992139216 19.561 100 94 188 0 2073090848 51488224 29463408
23:46:15 1558 8192000000 10990803408 11404247040 1985654752 19.509 100 85 172 0 2064094912 51782320 26657840
23:46:23 1513 8192000000 10993065168 11407777792 1994873600 19.582 100 93 186 1 2074878864 51185232 28820032
23:46:34 2371 8192000000 10988604272 11406434304 1990184288 19.545 100 87 172 0 2068179376 51314160 26680928
23:46:45 3598 8192000000 10986687376 11403558912 1986950512 19.520 100 81 162 0 2065061296 52355168 25755616
23:46:55 3365 8192000000 10985160496 11398299648 1975839040 19.432 99 87 174 1 2056521088 53330592 27351456
23:47:05 4006 8192000000 10975669984 11395084288 1970453136 19.389 99 81 162 2 2048472272 52259328 25759808
23:47:16 2315 8192000000 10988885296 11405959168 1986438880 19.516 100 81 162 1 2064412496 52839760 25133856
23:47:25 3518 8192000000 10985404528 11404570624 1983986208 19.496 100 82 163 1 2064589040 53919472 26683360
23:47:40 9527 8192000000 10963741696 11409674240 1983100624 19.489 100 44 89 2 2051406576 54022944 14283008
23:47:57 14313 8192000000 10957435392 11406229504 1981997600 19.481 100 42 84 2 2050859920 55434608 13427712
23:48:35 4759 8192000000 10974780288 11411124224 1988513408 19.532 100 59 117 0 2057249968 50338320 18398240
23:48:50 7790 8192000000 10971479040 11411464192 1988932864 19.535 100 46 90 2 2053716960 49773744 15010352
23:49:06 6504 8192000000 10975270592 11407425536 1984353040 19.499 100 55 110 4 2052942528 50868096 17721392
23:49:20 1043 8192000000 10992973616 11421360128 2000954320 19.630 100 83 166 0 2078145936 50312048 26879568
23:49:30 1933 8192000000 10965111808 11383263232 1971950736 19.401 99 72 139 1 2041204304 46665424 22588144
23:49:38 13081 8192000000 10952279760 11407314944 1983772576 19.495 100 44 88 0 2046714128 47940416 15001136
23:50:08 8517 8192000000 10965481536 11410153472 1989121568 19.537 100 46 93 1 2046204944 42326176 14757200
23:50:24 8636 8192000000 10964837488 11415498752 1990946032 19.551 100 37 73 0 2050209440 46769280 12494128
23:50:58 8369 8192000000 10970864272 11417690112 1989739056 19.542 100 34 66 1 2049642096 48783808 11119232
23:51:16 16682 8192000000 10984525776 11425193984 1988910832 19.535 100 37 74 2 2058432160 57002160 12519168
23:51:44 15111 8192000000 10955060208 11413426176 1972060144 19.402 99 30 60 0 2036060384 53544624 10455616
23:52:14 11148 8192000000 10963961536 11417882624 1966365024 19.357 99 25 50 1 2031504496 55419152 9720320
23:52:34 14811 8192000000 10946793536 11413032960 1977836048 19.448 100 19 38 0 2033807632 49209600 6761984
23:53:02 32104 8192000000 10923868624 11393687552 1951472112 19.238 100 22 44 1 2007825040 48311760 8041168
23:53:41 18426 8192000000 10916469376 11388030976 1912422880 18.926 98 17 34 0 1970997728 52040368 6534480
23:54:08 24948 8192000000 10887196496 11349323776 1906270592 18.877 98 17 33 1 1952180160 40998992 4910576
23:54:40 27371 8192000000 10885771952 11355873280 1905329104 18.869 98 23 46 2 1938063200 26055088 6679008
23:55:16 32152 8192000000 10879487936 11348303872 1936728496 19.121 100 7 14 1 1957347456 18688624 1930336
23:56:00 64820 8192000000 10877425504 11349323776 1900470400 18.830 98 13 26 3 1926580112 22250496 3859216
23:57:11 85245 8192000000 10863771056 11326459904 1857596976 18.484 95 9 18 1 1881257008 21224512 2435520
23:58:49 57519 8192000000 10924937072 11365920768 1959852784 19.305 100 25 53 1 1976691168 9555312 7283072
00:00:21 64226 8192000000 10918888960 11369549824 1949990752 19.226 99 16 32 1 1971247168 16974672 4281744
00:01:37 41967 8192000000 10910817872 11374178304 1975893536 19.432 100 13 26 2 1990342288 10929184 3519568
00:02:26 79768 8192000000 10910599152 11392876544 1937422336 19.126 98 8 16 1 1958441968 19046336 1973296
00:04:01 94717 8192000000 10883747248 11348852736 1894703008 18.784 96 16 32 0 1913623408 14388832 4531568
00:06:23 65335 8192000000 10887148208 11328798720 1910491744 18.911 97 32 64 1 1929190768 8969824 9729200
00:07:37 16556 8192000000 10919818816 11357519872 1963531568 19.334 100 51 103 3 1986080480 8588480 13960432
00:08:01 45374 8192000000 10891051232 11368534016 1969767808 19.384 100 34 68 1 1989459600 10279616 9412176
00:08:59 60210 8192000000 10912028320 11382841344 1975055552 19.426 100 15 30 0 1990715840 11191248 4469040
00:10:08 7588 8192000000 10904649952 11359338496 1953625152 19.255 99 38 74 0 1975854848 10653776 11575920
00:11:32 65715 8192000000 10915475728 11383586816 1940789056 19.153 98 18 37 0 1960683776 14528848 5365872
00:12:50 31568 8192000000 10944678448 11390271488 1991465040 19.555 100 48 96 2 2021155264 15484800 14205424
00:13:41 71436 8192000000 10913449760 11389984768 1965609488 19.351 99 18 36 1 1992643664 21079104 5955072
00:15:18 90958 8192000000 10914877344 11397308416 1960922304 19.313 99 9 18 1 1972692480 9288400 2481776
00:16:55 7418 8192000000 10913182912 11393232896 1985923376 19.512 100 9 18 1 2002427104 14146240 2357488
00:17:09 3431 8192000000 10910359360 11393622016 1985678160 19.510 100 7 14 0 2001994928 14242208 2074560
00:17:18 34952 8192000000 10916887936 11393667072 1983814512 19.495 100 19 38 0 2004577648 15119328 5643808
00:19:32 23801 8192000000 10902081680 11371888640 1972071936 19.402 100 27 54 1 1993439648 13483248 7884464
00:20:05 48187 8192000000 10869610832 11349917696 1913736384 18.937 97 12 24 3 1923215584 6898064 2581136
00:21:37 95820 8192000000 10893326288 11376553984 1958254688 19.292 99 22 44 0 1972249152 7501632 6492832
00:23:28 112695 8192000000 10874175888 11363770368 1883328464 18.692 95 11 22 1 1896305248 10522512 2454272
00:25:48 41330 8192000000 10892078672 11371585536 1969525600 19.382 100 18 36 1 1982936928 8600752 4810576
00:26:42 44716 8192000000 10896448656 11363004416 1934984352 19.107 98 11 22 1 1944700448 6727184 2988912
00:27:34 6146 8192000000 10897470688 11355652096 1948284512 19.213 99 44 83 1 1966370608 6530528 11555568
00:27:46 37781 8192000000 10897560400 11366174720 1944782368 19.185 99 27 54 0 1965140464 12639856 7718240
00:28:30 54232 8192000000 10887163824 11365519360 1935529376 19.111 98 12 24 1 1950898976 12530336 2839264
00:29:30 30146 8192000000 10869795424 11333922816 1883897584 18.697 96 20 40 4 1901372496 12128128 5346784
00:30:10 44425 8192000000 10870077584 11333795840 1873870704 18.616 96 14 26 1 1896103872 18613968 3619200
00:31:06 40704 8192000000 10896800624 11342954496 1898029008 18.810 97 29 54 3 1914270672 7000896 9240768
00:31:56 14193 8192000000 10914994832 11361501184 1963906752 19.337 100 50 100 0 1987035760 9092720 14036288
00:32:24 21770 8192000000 10879743264 11338141696 1912815632 18.929 98 41 82 2 1935145952 11363792 10966528
00:32:58 47122 8192000000 10885495888 11342577664 1919042768 18.979 98 27 54 2 1937472272 11076224 7353280
00:33:51 41731 8192000000 10876574960 11356327936 1928174592 19.052 99 13 26 1 1940940512 9141168 3624752
00:34:42 39129 8192000000 10871209728 11340967936 1879767536 18.663 96 21 42 2 1894800720 9475984 5557200
00:35:31 52388 8192000000 10864826400 11326660608 1873488000 18.612 96 15 30 1 1886461776 8910192 4063584
00:36:32 13891 8192000000 10897570080 11351715840 1949908304 19.226 100 35 70 2 1970724864 11423968 9392592
00:36:57 31440 8192000000 10916631536 11371540480 1964970848 19.346 100 46 92 0 1994168624 15933792 13263984
00:38:15 55397 8192000000 10861327424 11322621952 1879660800 18.662 97 12 24 0 1912520752 28235248 4624704
00:39:17 100284 8192000000 10868531328 11344179200 1924779968 19.025 99 19 38 2 1940684880 10337296 5567616
00:41:57 86697 8192000000 10883186080 11341537280 1898915168 18.818 97 34 66 0 1917027264 7578912 10533184
00:43:30 9965 8192000000 10876222864 11327950848 1934889504 19.106 100 36 72 1 1953379568 7889696 10600368
00:43:47 4728 8192000000 10889137024 11345395712 1949482640 19.222 100 56 112 0 1975423424 9885504 16055280
00:43:57 59237 8192000000 10857274560 11337052160 1936192752 19.116 99 39 78 0 1958659632 11724176 10742704
00:45:03 67956 8192000000 10866849168 11359477760 1947766128 19.209 100 11 22 0 1963659888 12875888 3017872
00:46:17 48971 8192000000 10875286800 11355041792 1920059616 18.987 98 22 44 1 1936179888 10101424 6018848
00:47:19 40234 8192000000 10899646320 11372621824 1956592848 19.279 100 12 23 0 1970413856 10940112 2880896
00:48:20 59470 8192000000 10846468976 11341324288 1865112672 18.545 95 10 20 0 1879165904 10872864 3180368
00:49:37 108952 8192000000 10868787984 11354689536 1886247808 18.716 97 9 18 2 1897517648 8509856 2759984
00:51:32 45264 8192000000 10886170016 11359870976 1917357952 18.966 98 19 38 0 1935272496 12520064 5394480
00:52:25 58783 8192000000 10868213552 11331739648 1881128240 18.674 96 23 46 0 1907360032 19289632 6942160
00:54:14 76906 8192000000 10884221152 11354263552 1913293616 18.933 98 14 27 1 1930216832 13202944 3720272
00:55:44 72193 8192000000 10900683440 11360579584 1940012560 19.147 99 11 22 0 1953174928 10293296 2869072
00:57:11 55747 8192000000 10911788752 11390709760 1957427376 19.286 99 12 24 0 1971499824 11128144 2944304
00:58:12 105794 8192000000 10905765632 11384541184 1904314896 18.861 96 7 14 0 1924011776 17500272 2196608
01:00:16 157177 8192000000 10900834496 11373801472 1841251744 18.351 93 5 10 0 1852675104 10589920 833440
01:02:59 93622 8192000000 10919264592 11389534208 1975577648 19.430 100 35 70 2 2001612256 15456256 10578352
01:04:43 111267 8192000000 10906914928 11397091328 1985028016 19.504 100 14 28 1 2000645968 11165952 4452000
01:06:41 13127 8192000000 10916126624 11406462976 1990218176 19.546 100 9 16 0 2003605728 11155760 2231792
01:07:04 56922 8192000000 10891724608 11378900992 1928534752 19.055 97 20 40 1 1942151536 7971600 5645184
01:08:07 47134 8192000000 10874264816 11352195072 1913377088 18.934 97 15 30 0 1926754832 9109280 4268464
01:09:36 65556 8192000000 10878038368 11354742784 1911779312 18.921 97 12 23 1 1922696352 7893840 3023200
01:10:48 70617 8192000000 10898102896 11382947840 1973566512 19.414 100 11 22 0 1987537280 10599856 3370912
01:13:18 47867 8192000000 10902820800 11376746496 1950025184 19.227 99 19 38 0 1972998464 17117072 5856208
01:14:12 74683 8192000000 10896895344 11375984640 1917538624 18.967 97 21 42 0 1936114288 11722160 6853504
01:15:34 85719 8192000000 10903515248 11382353920 1937110288 19.124 98 23 46 3 1961010880 17211120 6689472
01:17:46 26100 8192000000 10904944880 11378147328 1970963520 19.393 100 35 70 1 1989470416 8318928 10187968
01:18:18 41708 8192000000 10902409600 11362029568 1916756320 18.961 97 31 62 0 1933896672 8851760 8288592
01:19:08 11103 8192000000 10904109504 11358859264 1931166048 19.076 98 46 92 0 1953853600 10425744 12261808
01:19:31 29843 8192000000 10914310064 11364585472 1905700096 18.872 97 49 96 1 1929744480 10816400 13227984
01:20:07 25501 8192000000 10899971840 11365203968 1959418352 19.301 100 36 72 2 1982008688 12554384 10035952
01:20:39 58705 8192000000 10906420704 11382452224 1967997920 19.370 100 32 64 0 1990040224 13295472 8746832
01:21:44 46112 8192000000 10871324688 11344535552 1872276864 18.603 95 22 44 0 1891755520 13065248 6413408
01:22:37 16098 8192000000 10877861936 11331665920 1890625248 18.751 97 51 102 2 1912372448 7043616 14703584
01:23:01 60120 8192000000 10903375952 11362045952 1921270368 18.997 99 30 61 1 1944671104 15086240 8314496
01:24:15 106098 8192000000 10888890192 11367870464 1913832160 18.937 98 11 22 0 1939489760 22958064 2699536
01:26:30 66740 8192000000 9477420416 9828777984 599825024 6.822 31 5 10 0 604444352 3643168 976160

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 06-03-2021 01:29:08 to 06-03-2021 01:29:40.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 111 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-03-2021 01:29:41 to 06-03-2021 01:29:43.

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          251849
MON$OLDEST_ACTIVE               252457
MON$OLDEST_SNAPSHOT             252457
MON$NEXT_TRANSACTION            252457
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                       2053920
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
:84: 
:85: mscs-test-161.budzdorov.ru    Sat Mar  6 01:27:39 2021
:86:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:87: 
--- end of diff output ---

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

06.03.21 01:29:44. 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-03-06 01:29:46 No severe PSQL-related problems occured
06.03.21 01:29:48. End of report.