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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17389704 kB
MemAvailable 31505648 kB
Buffers 0 kB
Cached 14332292 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-24 01:27:08
DTS_END                         2020-12-24 01:27:08.7550
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55166
TRN_ID                          252886
ATT_ID                          742
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: 9837.69 17733 1180523
customer order: creation 183.23 336 21988
customer order: refuse 15.56 254 1867
order to supplier: creation 49.08 1125 5890
order to supplier: removal 3.63 85146 435
invoice (draft): creation 48.83 2831 5859
invoice (draft): removal 55.91 656 6709
invoice accept: apply 44.35 15594 5322
invoice accept: cancel 50.43 618 6051
customer reserve: creation 4085.36 155 490243
customer reserve: removal 4990.45 49 598854
realization accept: apply 89.78 152 10774
realization accept: cancel 81.90 99 9828
payment from customer: creation 63.96 112 7675
payment from customer: removal 6.26 84 751
payment to supplier: creation 52.63 123 6315
payment to supplier: removal 3.58 62 430
service: total inventory turnovers 5.35 942 642
service: total monetary turnovers 6.43 29 771
service: aggregate perf. data 0.96 16196 115
service: refresh index statistics 0.03 230104 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-12-2020 01:28:59 to 24-12-2020 01:29:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9489
TEST_TIME 2 8492
TEST_TIME 3 7595
TEST_TIME 4 7060
TEST_TIME 5 6482
TEST_TIME 6 5749
TEST_TIME 7 6462
TEST_TIME 8 6515
TEST_TIME 9 6804
TEST_TIME 10 7335
TEST_TIME 11 7739
TEST_TIME 12 8097
TEST_TIME 13 8338
TEST_TIME 14 9090
TEST_TIME 15 9330
TEST_TIME 16 9394
TEST_TIME 17 10319
TEST_TIME 18 11454
TEST_TIME 19 13400
TEST_TIME 20 13170
TEST_TIME 21 13072
TEST_TIME 22 12715
TEST_TIME 23 12610
TEST_TIME 24 12622
TEST_TIME 25 12274
TEST_TIME 26 11937
TEST_TIME 27 11826
TEST_TIME 28 11688
TEST_TIME 29 11617
TEST_TIME 30 11432
TEST_TIME 31 11373
TEST_TIME 32 11243
TEST_TIME 33 11261
TEST_TIME 34 11062
TEST_TIME 35 10962
TEST_TIME 36 10919
TEST_TIME 37 10919
TEST_TIME 38 10982
TEST_TIME 39 10970
TEST_TIME 40 10936
TEST_TIME 41 10934
TEST_TIME 42 10978
TEST_TIME 43 10942
TEST_TIME 44 11003
TEST_TIME 45 10924
TEST_TIME 46 11068
TEST_TIME 47 11028
TEST_TIME 48 11059
TEST_TIME 49 10849
TEST_TIME 50 10814
TEST_TIME 51 10718
TEST_TIME 52 10652
TEST_TIME 53 10744
TEST_TIME 54 10589
TEST_TIME 55 10548
TEST_TIME 56 10590
TEST_TIME 57 10482
TEST_TIME 58 10552
TEST_TIME 59 10538
TEST_TIME 60 10493
TEST_TIME 61 10492
TEST_TIME 62 10488
TEST_TIME 63 10442
TEST_TIME 64 10502
TEST_TIME 65 10539
TEST_TIME 66 10607
TEST_TIME 67 10618
TEST_TIME 68 10670
TEST_TIME 69 10642
TEST_TIME 70 10655
TEST_TIME 71 10658
TEST_TIME 72 10776
TEST_TIME 73 10699
TEST_TIME 74 10587
TEST_TIME 75 10493
TEST_TIME 76 10475
TEST_TIME 77 10447
TEST_TIME 78 10366
TEST_TIME 79 10307
TEST_TIME 80 10254
TEST_TIME 81 10240
TEST_TIME 82 10178
TEST_TIME 83 10184
TEST_TIME 84 10174
TEST_TIME 85 10120
TEST_TIME 86 10093
TEST_TIME 87 10112
TEST_TIME 88 10144
TEST_TIME 89 10129
TEST_TIME 90 10098
TEST_TIME 91 10108
TEST_TIME 92 10225
TEST_TIME 93 10237
TEST_TIME 94 10272
TEST_TIME 95 10230
TEST_TIME 96 10284
TEST_TIME 97 10248
TEST_TIME 98 10176
TEST_TIME 99 10127
TEST_TIME 100 10127
TEST_TIME 101 10100
TEST_TIME 102 10051
TEST_TIME 103 9989
TEST_TIME 104 9994
TEST_TIME 105 9946
TEST_TIME 106 9958
TEST_TIME 107 9942
TEST_TIME 108 9925
TEST_TIME 109 9956
TEST_TIME 110 9951
TEST_TIME 111 9946
TEST_TIME 112 9934
TEST_TIME 113 9980
TEST_TIME 114 9936
TEST_TIME 115 9985
TEST_TIME 116 9995
TEST_TIME 117 9976
TEST_TIME 118 9920
TEST_TIME 119 9928
TEST_TIME 120 9847

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 24-12-2020 01:29:03 to 24-12-2020 01:29:06.

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 1636874 1636874 0 0.00 0 13572 6 0 0
doc_list_biud 1636867 1636867 0 0.00 0 21086 23 0 0
sp_add_invoice_to_stock 5542 5322 220 3.96 34 139228 15595 0 220
sp_cancel_adding_invoice 6051 6051 0 0.00 3 50648 619 0 0
sp_cancel_client_order 1867 1867 0 0.00 4 10337 255 0 0
sp_cancel_customer_reserve 598854 598854 0 0.00 1 21088 50 0 0
sp_cancel_pay_from_customer 751 751 0 0.00 2 11251 84 0 0
sp_cancel_pay_to_supplier 430 430 0 0.00 2 2949 62 0 0
sp_cancel_supplier_invoice 6728 6709 19 0.28 1 12774 656 0 19
sp_cancel_supplier_order 435 435 0 0.00 7 980582 85147 0 0
sp_cancel_write_off 9828 9828 0 0.00 1 10682 99 0 0
sp_client_order 21988 21988 0 0.00 4 18240 336 0 0
sp_customer_reserve 490243 490243 0 0.00 0 51725 155 0 0
sp_fill_shopping_cart 33730 33730 0 0.00 1 11406 35 0 0
sp_fill_shopping_cart_clo_res 490229 490229 0 0.00 0 19294 12 0 0
sp_get_clo_for_invoice 5304 5304 0 0.00 0 25261 291 0 0
sp_kill_cost_storno 17060 17060 0 0.00 0 10201 42 0 0
sp_kill_qstorno_ret_qs2qd 1214680 1214680 0 0.00 0 18360 27 0 0
sp_kill_qty_storno 639819 639819 0 0.00 0 21086 57 0 0
sp_lock_selected_doc 22157 22157 0 0.00 0 8434 7 0 0
sp_make_cost_storno 30066 30066 0 0.00 0 13561 54 0 0
sp_multiply_rows_for_pdistr 30065 30065 0 0.00 0 6301 23 0 0
sp_multiply_rows_for_qdistr 21988 21988 0 0.00 0 18232 161 0 0
sp_pay_from_customer 7675 7675 0 0.00 4 14499 113 0 0
sp_pay_to_supplier 6315 6315 0 0.00 5 11403 123 0 0
sp_payment_common 13990 13990 0 0.00 1 9309 30 0 0
sp_qd_handle_on_cancel_clo 1867 1867 0 0.00 0 9343 224 0 0
sp_qd_handle_on_invoice_upd_sts 11353 11353 0 0.00 0 16599 238 0 0
sp_qd_handle_on_reserve_upd_sts 10773 10773 0 0.00 0 16125 48 0 0
sp_reserve_write_off 10774 10774 0 0.00 5 19030 152 0 0
sp_supplier_invoice 5859 5859 0 0.00 7 79158 2831 0 0
sp_supplier_order 5890 5890 0 0.00 6 29444 1125 0 0
srv_aggregate_perf_data 115 115 0 0.00 3072 164003 16196 0 0
srv_fill_mon_cache_memory 144 144 0 0.00 809 140975 38829 0 0
srv_find_qd_qs_mism 1130766 1130766 0 0.00 0 12329 5 0 0
srv_make_invnt_saldo 642 642 0 0.00 37 60300 943 0 0
srv_make_money_saldo 771 771 0 0.00 1 10509 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 136914 322143 230104 0 0
t$perf-abend:sp_add_invoice_to_stock 220 220 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 19 19 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5322 5322 0 0.00 0 12399 143 0 0
t$perf-norm:sp_cancel_adding_invoice 427 427 0 0.00 0 4454 85 0 0
t$perf-norm:sp_cancel_client_order 1867 1867 0 0.00 0 5910 14 0 0
t$perf-norm:sp_cancel_customer_reserve 690 690 0 0.00 0 5954 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 751 751 0 0.00 0 2822 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 430 430 0 0.00 0 392 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 436 436 0 0.00 0 1868 11 0 0
t$perf-norm:sp_cancel_supplier_order 435 435 0 0.00 0 17146 1234 0 0
t$perf-norm:sp_cancel_write_off 1048 1048 0 0.00 0 5934 17 0 0
t$perf-norm:sp_client_order 21988 21988 0 0.00 0 10609 18 0 0
t$perf-norm:sp_customer_reserve 1068 1068 0 0.00 0 1134 2 0 0
t$perf-norm:sp_pay_from_customer 7675 7675 0 0.00 0 5876 10 0 0
t$perf-norm:sp_pay_to_supplier 6315 6315 0 0.00 0 11908 17 0 0
t$perf-norm:sp_reserve_write_off 10774 10774 0 0.00 0 8482 11 0 0
t$perf-norm:sp_supplier_invoice 5859 5859 0 0.00 0 10473 19 0 0
t$perf-norm:sp_supplier_order 5890 5890 0 0.00 0 8263 17 0 0
t$perf-norm:srv_aggregate_perf_data 115 115 0 0.00 0 3169 29 0 0
t$perf-norm:srv_fill_mon_cache_memory 144 144 0 0.00 0 198 3 0 0
t$perf-norm:srv_make_invnt_saldo 642 642 0 0.00 0 752 12 0 0
t$perf-norm:srv_make_money_saldo 771 771 0 0.00 0 7213 27 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 11040 10600 440 3.98 0 5610 19 0 440
v_all_customers 40032 40032 0 0.00 0 81 0 0 0
v_all_suppliers 32700 32700 0 0.00 0 176 1 0 0
v_all_wares 43976 43976 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 854 854 0 0.00 0 2860 14 0 0
v_cancel_client_order 3734 3734 0 0.00 0 7589 9 0 0
v_cancel_customer_prepayment 1502 1502 0 0.00 0 7588 12 0 0
v_cancel_customer_reserve 1380 1380 0 0.00 0 1257 5 0 0
v_cancel_payment_to_supplier 860 860 0 0.00 0 1219 7 0 0
v_cancel_supplier_invoice 910 872 38 4.17 0 1312 17 0 38
v_cancel_supplier_order 870 870 0 0.00 0 1840 7 0 0
v_cancel_write_off 2096 2096 0 0.00 0 5060 16 0 0
v_max_id_clo_ord 5889 5889 0 0.00 0 592 1 0 0
v_max_id_clo_res 1068 1068 0 0.00 0 3364 21 0 0
v_max_id_ord_sup 5852 5852 0 0.00 0 6325 5 0 0
v_max_non_paid_invoice 1706 1706 0 0.00 0 2015 3 0 0
v_max_non_paid_realizn 4043 4043 0 0.00 0 3740 5 0 0
v_min_id_clo_ord 5889 5889 0 0.00 0 4127 4 0 0
v_min_id_clo_res 1068 1068 0 0.00 0 6426 17 0 0
v_min_id_ord_sup 5852 5852 0 0.00 0 5653 7 0 0
v_min_non_paid_invoice 6315 6315 0 0.00 0 6220 19 0 0
v_min_non_paid_realizn 7675 7675 0 0.00 0 5972 21 0 0
v_our_firm 11208 11208 0 0.00 0 11 1 0 0
v_reserve_write_off 21546 21546 0 0.00 0 9964 6 0 0
x_lock_depdocs_on_canc_invoice 12324 12324 0 0.00 0 12500 87 0 0
x_lock_depdocs_on_canc_sup_ord 435 435 0 0.00 0 6085 244 0 0
x_make_qstorno_1000_1200 5890 5890 0 0.00 2 29436 1067 0 0
x_make_qstorno_1200_2000 5859 5859 0 0.00 3 79153 2700 0 0
x_make_qstorno_2100_3300 490243 490243 0 0.00 0 42753 141 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-12-2020 01:29:07 to 24-12-2020 01:29:11.

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:11 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:18 12491 8192000000 10223745328 10528002048 932846352 10.223 74 56 115 1 953765424 2496608 18422464
22:57:40 26548 8192000000 10350296560 10664886272 1377976048 14.398 100 86 172 0 1410802128 5037840 27788240
22:58:30 26001 8192000000 10392366560 10715193344 1440760048 14.956 100 85 170 0 1475247920 6917488 27570384
22:59:06 8589 8192000000 10406311152 10732896256 1465079104 15.171 100 88 176 0 1501673744 8008928 28585712
22:59:24 27185 8192000000 10431739424 10759581696 1478203184 15.286 100 91 181 2 1516008784 9056800 28748800
23:00:00 15788 8192000000 10443558176 10775740416 1499019488 15.468 100 88 176 1 1536488672 9713712 27755472
23:00:33 13865 8192000000 10455918480 10792300544 1508115072 15.547 100 83 166 0 1544692976 10052944 26524960
23:00:55 13617 8192000000 10462742240 10801205248 1521557728 15.664 100 81 162 0 1557062736 10249872 25255136
23:01:19 11035 8192000000 10480342320 10824110080 1533532112 15.768 100 77 154 0 1567331632 10259120 23540400
23:01:44 11906 8192000000 10504144800 10854670336 1564189520 16.032 100 79 159 1 1598748528 10782720 23776288
23:02:03 13451 8192000000 10538209008 10891313152 1587358480 16.231 100 76 152 0 1621587568 11197312 23031776
23:02:26 11381 8192000000 10559217312 10914594816 1616883424 16.483 100 82 164 1 1654095264 12825952 24385888
23:02:48 10178 8192000000 10568785792 10929201152 1625671920 16.558 100 78 156 0 1661130192 12187104 23271168
23:03:08 9729 8192000000 10588780928 10952265728 1649868320 16.763 100 82 164 2 1687095296 12527744 24699232
23:03:26 8583 8192000000 10605901072 10974113792 1670889984 16.941 100 74 148 1 1704665040 11966400 21808656
23:03:43 8128 8192000000 10624316896 10999107584 1688401680 17.088 100 74 147 2 1721527760 11369680 21756400
23:03:58 6146 8192000000 10647952144 11023257600 1711051984 17.278 100 70 140 1 1741127968 10392208 19683776
23:04:17 5884 8192000000 10678206496 11054706688 1743206832 17.545 100 78 156 0 1777187120 11992928 21987360
23:04:30 5727 8192000000 10685225584 11062956032 1752022160 17.618 100 84 166 0 1789366016 13324640 24019216
23:04:43 4497 8192000000 10691378256 11075682304 1754028448 17.635 100 74 147 2 1787552128 13037216 20486464
23:04:54 3975 8192000000 10697997504 11078209536 1764575104 17.722 100 84 168 4 1802054448 13787552 23691792
23:05:05 3829 8192000000 10711820400 11093004288 1773557488 17.796 100 82 164 2 1810736432 14593600 22585344
23:05:15 2783 8192000000 10714628096 11096956928 1780972336 17.857 100 89 176 2 1820193472 14555776 24665360
23:05:25 9054 8192000000 10733797408 11116425216 1794210112 17.966 100 78 156 1 1829911440 13827776 21873552
23:05:41 2921 8192000000 10749563248 11136507904 1802684528 18.036 100 75 151 0 1836407312 12806192 20916592
23:05:51 2507 8192000000 10761147616 11148836864 1817233200 18.155 100 75 150 0 1849657968 11727936 20696832
23:05:59 2402 8192000000 10756297456 11145187328 1823391872 18.205 100 70 139 2 1856120960 12596432 20132656
23:06:09 2077 8192000000 10766719120 11152879616 1828966272 18.251 100 81 162 0 1865455504 12634112 23855120
23:06:17 2196 8192000000 10779084176 11161939968 1835489104 18.304 100 82 164 0 1871327968 12940912 22897952
23:06:26 2058 8192000000 10785564544 11170914304 1842053680 18.358 100 89 178 1 1880382368 13160640 25168048
23:06:35 2203 8192000000 10791503376 11176927232 1848832944 18.413 100 81 162 1 1883263840 11593600 22837296
23:06:44 1446 8192000000 10790796160 11180802048 1852003920 18.438 100 82 163 1 1886266256 11414704 22847632
23:06:53 1572 8192000000 10795946384 11186012160 1857917632 18.486 100 84 167 2 1894605616 12293024 24394960
23:07:00 2030 8192000000 10806536016 11192717312 1861284944 18.514 100 92 185 0 1900798000 13237024 26276032
23:07:09 1046 8192000000 10809986240 11195670528 1860863376 18.510 100 93 188 0 1900282448 13463072 25956000
23:07:16 2093 8192000000 10805427792 11195891712 1864338896 18.538 100 87 175 2 1902129936 12750352 25040688
23:07:24 3444 8192000000 10802622992 11202338816 1866103904 18.553 100 82 165 1 1905964896 16713680 23147312
23:07:57 11579 8192000000 10776068816 11194187776 1859288912 18.498 100 56 112 0 1885166608 9631728 16245968
23:08:18 4362 8192000000 10780402688 11193274368 1859362144 18.498 100 40 81 2 1878070768 7383088 11325536
23:08:29 7868 8192000000 10775454864 11191193600 1858686416 18.493 100 34 68 2 1876278816 8482112 9110288
23:08:43 7180 8192000000 10780826384 11200458752 1857495856 18.483 100 26 52 0 1876305664 11846320 6963488
23:08:57 6491 8192000000 10770559392 11195883520 1862425456 18.523 100 35 71 2 1879750224 7189664 10135104
23:09:10 7738 8192000000 10781183536 11204763648 1867954960 18.568 100 25 50 1 1881821312 6481776 7384576
23:09:25 8566 8192000000 10775261456 11203457024 1869619040 18.581 100 31 62 2 1885405712 7310528 8476144
23:09:42 9166 8192000000 10777478624 11209764864 1872304384 18.603 100 23 47 0 1884966352 5888224 6773744
23:09:58 9064 8192000000 10778012416 11211165696 1874298720 18.619 100 24 48 2 1886712048 6195136 6218192
23:10:14 8622 8192000000 10782192912 11218362368 1878116480 18.650 100 26 52 0 1892982976 7384736 7481760
23:10:28 9424 8192000000 10793165072 11222433792 1882972272 18.689 100 24 48 2 1896143360 6270032 6901056
23:10:44 11737 8192000000 10792589680 11223535616 1886039552 18.714 100 14 28 3 1895180928 5559808 3581568
23:11:07 15014 8192000000 10805745056 11235446784 1892608448 18.767 100 41 81 4 1910762176 6616384 11537344
23:11:36 46560 8192000000 10831855936 11242561536 1895469952 18.790 100 58 116 1 1918896496 6187600 17238944
23:12:30 8454 8192000000 10812119968 11240112128 1890966800 18.754 100 28 56 1 1905163712 6576448 7620464
23:12:46 12195 8192000000 10809156400 11241058304 1895098512 18.787 100 24 49 0 1908271792 6705536 6467744
23:13:04 5009 8192000000 10807047632 11241656320 1895003008 18.786 100 26 52 1 1909220112 6643232 7573872
23:13:18 7998 8192000000 10804247296 11241787392 1897661152 18.807 100 33 66 1 1913783776 7429072 8693552
23:13:35 4923 8192000000 10807873104 11243319296 1895405776 18.789 100 19 38 1 1906921248 5661968 5853504
23:13:46 7100 8192000000 10807784640 11249283072 1900444800 18.830 100 34 66 1 1919770032 10038272 9286960
23:14:02 5976 8192000000 10803093840 11242090496 1896843248 18.801 100 23 47 3 1909372272 6376896 6152128
23:14:16 6813 8192000000 10808838144 11251048448 1902002752 18.842 100 30 60 3 1916912304 5375280 9534272
23:14:33 12036 8192000000 10818803824 11258691584 1905921056 18.874 100 21 40 1 1918210128 6674928 5614144
23:14:54 14237 8192000000 10817205936 11249418240 1871190944 18.594 98 18 36 0 1886404720 10233952 4979824
23:15:15 5772 8192000000 10814587808 11246669824 1884350640 18.700 99 20 40 2 1896391264 6452000 5588624
23:15:27 10570 8192000000 10807704288 11246809088 1892100240 18.763 100 24 48 2 1912921280 14408272 6412768
23:15:44 8014 8192000000 10812657760 11253956608 1905402576 18.870 100 21 42 0 1917860784 6443920 6014288
23:16:01 17026 8192000000 10801495328 11217342464 1805718208 18.061 95 30 60 1 1819351648 4299904 9333536
23:16:25 51879 8192000000 10794638400 11209232384 1809649120 18.093 96 48 95 0 1829952096 6290416 14012560
23:17:27 3758 8192000000 10793367008 11217735680 1863788080 18.534 100 38 76 2 1886836128 12101936 10946112
23:17:37 10030 8192000000 10746597536 11168808960 1788635152 17.921 96 18 36 1 1804107984 10047968 5424864
23:17:56 3924 8192000000 10766943504 11185356800 1842721808 18.363 100 29 57 1 1857446000 6289472 8434720
23:18:09 6356 8192000000 10764930960 11190841344 1808903088 18.087 97 37 74 0 1827069040 7142048 11023904
23:18:22 10324 8192000000 10737141904 11151564800 1777676528 17.830 97 25 50 1 1790398192 5015568 7706096
23:18:38 6312 8192000000 10684549904 11090640896 1693601472 17.132 93 38 74 2 1711275600 6260384 11413744
23:18:51 8078 8192000000 10683321520 11091447808 1720193680 17.354 96 28 55 1 1733737440 5460800 8082960
23:19:05 5423 8192000000 10660442688 11061710848 1687386912 17.079 95 35 71 2 1703128352 4961088 10780352
23:19:16 6570 8192000000 10662747616 11070935040 1692249632 17.120 96 25 50 0 1705764256 6212800 7301824
23:19:32 11756 8192000000 10684380400 11087970304 1725826816 17.401 98 20 39 1 1737864160 6139856 5897488
23:19:54 8920 8192000000 10693743344 11108265984 1751265616 17.612 98 29 58 0 1765568432 5804256 8498560
23:20:10 8526 8192000000 10704488368 11112255488 1746632896 17.574 97 36 71 1 1761958608 5023984 10301728
23:20:26 5462 8192000000 10695786080 11114094592 1743411056 17.547 97 26 52 0 1765231904 14328288 7492560
23:20:38 12293 8192000000 10712194800 11129966592 1784091760 17.883 99 13 26 2 1792918144 5029264 3797120
23:20:57 63122 8192000000 10732623872 11144368128 1783268720 17.876 98 24 49 2 1795277232 5524384 6484128
23:22:08 9198 8192000000 10739519536 11156127744 1804645328 18.052 99 19 38 1 1815067968 5325024 5097616
23:22:25 9300 8192000000 10743068512 11170906112 1831545232 18.272 100 15 30 0 1841520224 5788048 4186944
23:22:45 6170 8192000000 10752285328 11178840064 1840556784 18.345 100 37 74 1 1858281056 7724144 10000128
23:22:58 8996 8192000000 10755726992 11181436928 1846626256 18.395 100 31 62 1 1861564880 6089520 8849104
23:23:13 5661 8192000000 10772055568 11196874752 1847862208 18.405 100 26 52 0 1869500176 14574960 7063008
23:23:25 5359 8192000000 10766838864 11196497920 1860182720 18.505 100 37 74 3 1881770224 11413664 10173840
23:23:37 10477 8192000000 10772843920 11199172608 1858046832 18.487 100 31 61 3 1876069920 9199392 8823696
23:23:55 7959 8192000000 10772131184 11199610880 1862365056 18.522 100 32 64 0 1878780080 6153232 10261792
23:24:10 7761 8192000000 10776723952 11202772992 1862072992 18.520 100 24 48 2 1874693264 5475312 7144960
23:24:25 6597 8192000000 10777669520 11206856704 1866591456 18.557 100 33 65 0 1885351888 9249600 9510832
23:24:37 8134 8192000000 10786232416 11211415552 1868972768 18.576 100 21 42 4 1880204720 5297008 5934944
23:24:56 6297 8192000000 10791666336 11221708800 1870430544 18.588 100 20 40 0 1887038272 10720816 5886912
23:25:13 13377 8192000000 10783983072 11216187392 1872983184 18.608 100 23 46 0 1885157888 5335312 6839392
23:25:32 11907 8192000000 10778406144 11213033472 1862612896 18.524 99 30 60 1 1877747776 5576032 9558848
23:25:52 68818 8192000000 10798821680 11228389376 1881686208 18.679 100 38 76 2 1899232320 6910320 10635792
23:27:10 13613 8192000000 10829299120 11248979968 1902306464 18.845 100 32 62 1 1916382176 5461488 8614224
23:27:31 5802 8192000000 10857462000 11268943872 1922861424 19.010 100 60 120 1 1948381968 7869136 17651408
23:27:45 29424 8192000000 10867123440 11286679552 1927788096 19.049 100 51 102 0 1955908736 14299968 13820672
23:28:27 23014 8192000000 10873426400 11296763904 1937637520 19.128 100 53 106 1 1963667488 11403648 14626320
23:29:11 5544 8192000000 10880647008 11307012096 1948694656 19.216 100 52 102 2 1975868064 12527216 14646192
23:29:24 29269 8192000000 10879208464 11313209344 1959984704 19.306 100 56 112 2 1988702400 12450896 16266800
23:30:02 21688 8192000000 10888997184 11319152640 1943034704 19.171 99 49 98 2 1970598560 13865360 13698496
23:30:37 16998 8192000000 10899260960 11332349952 1950889888 19.234 99 53 102 2 1981539184 14337904 16311392
23:31:07 14417 8192000000 10902049856 11337654272 1968131344 19.371 100 49 99 0 2000974864 17896160 14947360
23:31:31 38302 8192000000 10916148992 11360399360 1975573008 19.430 100 34 67 0 2008562416 23207248 9782160
23:32:34 34830 8192000000 10934793744 11374059520 1995792656 19.590 100 45 90 2 2034493040 25187584 13512800
23:33:21 12925 8192000000 10951742832 11386982400 2001685792 19.636 100 46 90 2 2043647520 28143904 13817824
23:33:42 22297 8192000000 10966647648 11401973760 2011522992 19.714 100 53 104 1 2058567792 30986144 16058656
23:34:12 5412 8192000000 10971405456 11402493952 2012791520 19.723 100 73 143 1 2066886624 32488464 21606640
23:34:23 3833 8192000000 10988034864 11414110208 2021503184 19.792 100 76 152 1 2079502912 34762624 23237104
23:34:39 7562 8192000000 10983807168 11415212032 2028029264 19.843 100 70 141 2 2083251104 33787792 21434048
23:34:54 4334 8192000000 11007863728 11422289920 2032472416 19.878 100 74 147 0 2088971984 33366448 23133120
23:35:07 5592 8192000000 10987404624 11422670848 2029847904 19.857 100 59 117 0 2083125520 34408304 18869312
23:35:20 6524 8192000000 10995936624 11429937152 2032933664 19.882 100 65 130 0 2089104672 35850272 20320736
23:35:38 4003 8192000000 11009155600 11439271936 2042706016 19.958 100 61 120 1 2097082800 35885440 18491344
23:35:49 4115 8192000000 11021532480 11449618432 2046776816 19.990 100 72 144 2 2111638416 42773680 22087920
23:36:01 9556 8192000000 11018178208 11448803328 2046871488 19.991 100 65 130 1 2106256144 39651664 19732992
23:36:17 2609 8192000000 11005080448 11430400000 2027260912 19.837 99 75 149 3 2094018896 44150848 22607136
23:36:28 2764 8192000000 11022580832 11447934976 2045629344 19.981 100 78 156 1 2110261888 41277840 23354704
23:36:38 1696 8192000000 11025785504 11451777024 2045976128 19.984 100 85 169 0 2114073152 42258704 25838320
23:36:50 8375 8192000000 11005087520 11432140800 2019393600 19.775 99 71 142 1 2082064528 40685616 21985312
23:37:09 3517 8192000000 11027358512 11447848960 2046099584 19.985 100 81 160 0 2112086352 40836736 25150032
23:37:22 1965 8192000000 11025302464 11444539392 2039286160 19.931 100 77 155 0 2106023888 42841984 23895744
23:37:34 6306 8192000000 10985006768 11404406784 1994643280 19.580 98 74 148 0 2062599696 45103104 22853312
23:37:48 3690 8192000000 10996441712 11422724096 2006203088 19.672 99 68 136 3 2071908480 44841888 20863504
23:38:00 2374 8192000000 10991547312 11413299200 2003089056 19.647 99 85 171 2 2073085792 43407744 26588992
23:38:10 1116 8192000000 11008629152 11423076352 2018828352 19.771 100 77 152 1 2084943424 42682512 23432560
23:38:17 2493 8192000000 11007621280 11424481280 2006178128 19.671 99 89 175 1 2077017072 43977280 26861664
23:38:27 3556 8192000000 10987784736 11398447104 1982681952 19.486 99 86 172 1 2055652816 46156640 26814224
23:38:38 806 8192000000 10984889056 11404128256 2001610336 19.635 100 83 163 1 2072371760 46576784 24184640
23:38:47 5709 8192000000 10976417040 11403251712 1995108032 19.584 100 68 137 3 2063683536 46664192 21911312
23:39:00 6568 8192000000 10971029488 11397357568 1978628512 19.454 99 64 128 2 2045583504 45762896 21192096
23:39:14 2934 8192000000 10966857776 11383443456 1979587040 19.461 100 78 155 0 2049904416 45510416 24806960
23:39:26 4988 8192000000 10972068496 11394277376 1990012240 19.544 100 70 140 0 2060474864 48013280 22449344
23:39:40 3380 8192000000 10982992432 11395428352 1991546448 19.556 100 83 162 0 2064805312 47625488 25633376
23:39:52 2613 8192000000 10964358304 11384614912 1982649888 19.486 99 77 152 1 2053984560 46931712 24402960
23:40:02 1813 8192000000 10977808080 11392827392 1987452432 19.524 100 79 158 0 2059888992 47949600 24486960
23:40:10 2256 8192000000 10955863328 11381071872 1965363088 19.349 99 68 136 1 2036449488 49609328 21477072
23:40:22 4860 8192000000 10949303072 11381989376 1978176496 19.450 100 49 98 0 2040768752 45788464 16803792
23:40:36 10409 8192000000 10946187552 11376791552 1969473024 19.381 100 45 88 1 2033101232 48027920 15600288
23:40:53 5924 8192000000 10967569424 11393552384 1978915488 19.456 100 49 98 1 2046248544 51291712 16041344
23:41:16 14670 8192000000 10969846544 11418284032 1994515264 19.579 100 42 84 0 2063797920 55177104 14105552
23:41:38 19297 8192000000 10975184208 11421175808 1998273776 19.609 100 36 71 0 2062787296 52749360 11764160
23:42:22 9288 8192000000 10968258112 11411165184 1975924112 19.432 99 41 81 1 2042250752 52622048 13704592
23:42:42 16153 8192000000 10944130896 11389116416 1968589808 19.374 100 36 72 2 2034975472 53890688 12494976
23:43:12 19545 8192000000 10933543392 11372113920 1912049936 18.923 97 38 75 1 1981761936 55685056 14026944
23:43:40 15250 8192000000 10937413296 11384127488 1947778624 19.209 100 29 58 0 2023325728 64625104 10922000
23:44:07 11944 8192000000 10915924768 11381645312 1932438208 19.086 100 31 62 0 2009322864 65445296 11439360
23:44:31 34733 8192000000 10906086224 11360935936 1915156880 18.948 99 24 48 2 1990784880 66050496 9577504
23:45:33 28007 8192000000 10860048384 11321954304 1850266432 18.424 97 29 58 1 1921375712 60439200 10670080
23:46:07 38603 8192000000 10837331344 11327819776 1879284208 18.659 99 18 36 1 1940169200 54242656 6642336
23:46:57 45708 8192000000 10830008256 11271467008 1792270368 17.950 94 19 38 1 1808390480 10493280 5626832
23:47:50 78102 8192000000 10810188096 11264229376 1778859360 17.840 94 11 21 0 1792589600 11344208 2386032
23:49:23 36102 8192000000 10873451248 11299520512 1905730048 18.872 100 42 84 2 1924617840 6851712 12036080
23:50:06 42074 8192000000 10862550400 11299930112 1919595056 18.984 100 24 48 1 1936689328 10986192 6108080
23:50:55 99419 8192000000 10819320848 11280142336 1847775568 18.404 96 21 42 1 1866298384 12492800 6030016
23:53:04 61929 8192000000 10842186352 11286503424 1880979680 18.673 98 44 88 3 1902452816 8168864 13304272
23:54:13 41675 8192000000 10826143840 11279286272 1867164224 18.561 98 30 59 2 1887821312 12290784 8366304
23:55:14 39602 8192000000 10836585408 11293188096 1891322176 18.756 99 19 38 0 1905270464 8611008 5337280
23:56:00 31053 8192000000 10876557792 11316813824 1920573040 18.991 100 26 51 0 1937781296 9426928 7781328
23:56:42 43282 8192000000 10867191408 11331723264 1931866336 19.082 100 22 44 2 1948464496 10444768 6153392
23:57:32 51296 8192000000 10877164416 11334762496 1943460160 19.174 100 10 20 0 1960997504 14906976 2630368
23:58:35 18370 8192000000 10876900864 11344646144 1949647456 19.224 100 9 18 0 1965664000 13589360 2427184
23:59:00 52990 8192000000 10882788720 11349319680 1958593424 19.295 100 14 28 0 1974700800 12473696 3633680
00:00:00 15873 8192000000 10865053936 11336785920 1947046816 19.203 100 5 10 0 1956657184 8324656 1285712
00:00:23 8805 8192000000 10866836160 11338305536 1948912496 19.218 100 9 18 1 1958052352 6746656 2393200
00:00:43 34928 8192000000 10870389616 11339882496 1933858592 19.098 99 12 24 0 1943358672 6373328 3126752
00:01:34 25740 8192000000 10876048112 11347861504 1955312688 19.269 100 9 18 0 1967014976 9567856 2134432
00:02:10 23111 8192000000 10898368016 11356241920 1945388400 19.190 99 24 49 1 1963521440 11030368 7102672
00:02:55 43368 8192000000 10891685856 11366670336 1969382192 19.381 100 23 46 1 1985444448 9789712 6272544
00:03:47 47851 8192000000 10909305056 11365748736 1937002624 19.123 98 24 46 0 1953643056 10244272 6396160
00:04:47 81105 8192000000 10905434112 11371413504 1934939760 19.106 98 20 38 3 1951057584 10164864 5952960
00:06:15 80398 8192000000 10903012160 11377291264 1959934304 19.306 99 13 26 2 1974738592 11064560 3739728
00:07:45 50461 8192000000 10915808608 11390717952 1983604048 19.493 100 15 30 1 1996519728 8735408 4180272
00:08:44 71206 8192000000 10920946256 11390087168 1973741344 19.415 99 17 34 1 1992406704 13720688 4944672
00:10:01 75685 8192000000 10938856688 11390513152 1965145312 19.347 98 30 60 0 1985557136 12666352 7745472
00:11:23 67710 8192000000 10927753616 11388133376 1952448064 19.246 98 17 33 1 1969298080 12634928 4215088
00:12:49 25519 8192000000 10919988592 11371524096 1906100864 18.875 96 35 70 0 1929761280 13137712 10522704
00:13:26 45737 8192000000 10892005632 11359248384 1904702656 18.864 97 14 28 1 1923771888 14900032 4169200
00:14:18 58582 8192000000 10882392480 11347197952 1866377360 18.555 95 12 24 0 1885389872 15638928 3373584
00:15:23 116406 8192000000 10872520976 11330465792 1913184624 18.932 98 26 52 1 1936765760 16569536 7011600
00:17:39 39592 8192000000 10900820544 11353370624 1932348208 19.086 98 49 96 2 1958527920 12708032 13471680
00:18:34 56944 8192000000 10877942576 11349643264 1901285856 18.837 97 28 56 0 1926437888 17435424 7716608
00:19:42 49227 8192000000 10883561264 11349835776 1940453792 19.150 99 34 65 4 1964878048 14119552 10304704
00:20:38 48434 8192000000 10871517440 11357114368 1934341600 19.102 99 12 24 0 1952305104 14241696 3721808
00:21:33 32443 8192000000 10886273840 11358146560 1955585264 19.271 100 11 22 2 1971408112 12543888 3278960
00:22:12 27708 8192000000 10862370320 11325140992 1895334272 18.789 97 19 39 0 1912586800 12109984 5142544
00:22:51 48395 8192000000 10869330752 11341438976 1921969936 19.003 99 15 30 1 1944405344 17966992 4468416
00:23:45 64826 8192000000 10862483056 11333992448 1922569232 19.007 99 19 38 2 1939058016 10502240 5986544
00:24:56 49004 8192000000 10882285136 11365134336 1949261552 19.221 100 17 34 1 1966176080 12049088 4865440
00:26:56 39155 8192000000 10874583232 11346456576 1920045632 18.987 98 16 32 0 1943104144 19254624 3803888
00:28:02 34300 8192000000 10883134752 11339362304 1930100992 19.068 98 25 50 0 1943719760 6932704 6686064
00:28:43 16771 8192000000 10892982080 11347337216 1924708112 19.025 98 38 76 0 1941875568 7266112 9901344
00:29:07 19222 8192000000 10889398448 11342729216 1940838656 19.153 99 27 54 1 1956115744 7924928 7352160
00:29:33 42113 8192000000 10858083600 11307028480 1839326752 18.335 94 34 69 1 1859016288 10515648 9173888
00:30:21 37643 8192000000 10869474112 11326136320 1899246976 18.820 98 31 62 0 1917956384 9708832 9000576
00:31:06 78205 8192000000 10879284528 11355709440 1926528448 19.039 99 13 26 0 1945687648 15313760 3845440
00:32:36 59351 8192000000 10878523056 11348942848 1909801920 18.905 98 21 42 2 1932245024 16745952 5697152
00:33:42 47107 8192000000 10895856256 11353808896 1910992464 18.915 98 18 35 0 1931950800 15785232 5173104
00:34:40 114022 8192000000 10861967344 11316858880 1827589200 18.240 94 10 20 1 1845427632 15599840 2238592
00:36:42 11024 8192000000 10878622016 11322605568 1917596528 18.968 99 44 86 0 1938622400 8763200 12262672
00:37:00 41589 8192000000 10859258352 11291869184 1807966992 18.079 94 33 67 0 1828442064 10780720 9694352
00:37:50 107112 8192000000 10858298768 11334660096 1880509280 18.669 98 20 40 0 1909220192 23503984 5206928
00:39:52 126419 8192000000 10847243200 11311640576 1894232832 18.780 98 15 30 0 1907690480 8903360 4554288
00:42:07 47079 8192000000 10868849984 11329585152 1931720240 19.081 100 29 58 1 1946225072 6514272 7990560
00:43:10 63801 8192000000 10856875152 11324882944 1916712896 18.960 99 7 15 0 1925347584 6831776 1802912
00:44:20 58127 8192000000 10849548256 11328094208 1919768416 18.985 99 12 25 0 1932210256 8748224 3693616
00:45:38 25201 8192000000 10861652576 11325272064 1934892928 19.106 100 8 16 0 1945235824 7972048 2370848
00:46:09 43229 8192000000 10875496432 11342901248 1948932672 19.218 100 17 34 0 1961260704 7483760 4844272
00:47:11 67478 8192000000 10880430048 11334713344 1907507264 18.887 97 19 38 2 1927769936 14927456 5335216
00:48:32 97806 8192000000 10866813904 11342741504 1923314944 19.013 98 25 50 1 1938601968 8475632 6811392
00:50:17 40957 8192000000 10882095312 11343790080 1935666048 19.112 99 22 42 1 1951067728 9767664 5634016
00:51:06 88700 8192000000 10863873232 11339493376 1903602944 18.855 98 10 20 0 1915917824 9597728 2717152
00:52:48 66644 8192000000 10893630240 11371438080 1949256112 19.221 100 11 22 0 1962230640 10005696 2968832
00:54:01 67791 8192000000 10904211888 11366899712 1953338000 19.253 99 20 39 1 1974996192 15821792 5836400
00:55:17 42348 8192000000 10894517120 11365330944 1953116992 19.251 99 19 38 1 1972381696 13387904 5876800
00:56:06 109937 8192000000 10917040752 11374108672 1878644816 18.654 95 21 42 1 1901638784 17296976 5696992
00:58:06 63493 8192000000 10906367904 11377410048 1920572464 18.991 97 23 46 1 1939629376 12848080 6208832
01:00:43 77731 8192000000 10901876944 11381866496 1918966880 18.979 97 12 24 1 1939814192 17020864 3826448
01:02:06 140974 8192000000 10905664128 11376480256 1896397904 18.797 96 9 18 0 1917548416 19048352 2102160
01:04:33 117822 8192000000 10878325072 11337994240 1902983328 18.850 96 37 74 3 1924982320 11536352 10462640
01:06:49 75948 8192000000 10851728336 11324891136 1919990096 18.987 98 26 52 4 1937874096 10030528 7853472
01:08:16 57940 8192000000 10868798256 11347308544 1934923776 19.106 99 12 24 0 1948903648 10879408 3100464
01:09:27 30904 8192000000 10863625440 11343540224 1932370416 19.086 99 5 10 0 1948104880 14532800 1201664
01:10:10 42614 8192000000 10870458944 11346391040 1951831856 19.241 100 13 26 0 1966330400 10907168 3591376
01:11:05 42800 8192000000 10876665200 11357052928 1939474880 19.143 99 4 8 0 1953174096 12435408 1263808
01:11:59 84070 8192000000 10872992144 11347894272 1906368864 18.877 97 16 32 1 1920961280 10519216 4073200
01:13:32 70311 8192000000 10893884480 11361505280 1924646208 19.024 98 28 56 3 1943100096 10202400 8251488
01:14:54 53172 8192000000 10888751184 11355287552 1911132224 18.916 97 20 40 1 1927151408 9930160 6089024
01:16:02 57099 8192000000 10884489344 11336716288 1858049152 18.487 95 26 52 0 1872074832 6766128 7259552
01:17:06 53124 8192000000 10862506064 11304390656 1814432832 18.132 93 42 84 2 1834922592 8460624 12029136
01:18:05 25470 8192000000 10850420480 11304390656 1900143824 18.827 99 32 64 0 1918557424 9639920 8773680
01:18:39 61440 8192000000 10878313312 11338338304 1941625376 19.160 100 30 60 1 1961245296 11423888 8196032
01:19:47 65610 8192000000 10855986592 11329220608 1883204928 18.691 97 15 30 1 1896023232 8880720 3937584
01:21:02 25766 8192000000 10880987776 11324993536 1916316672 18.957 99 48 96 4 1942756624 12891568 13548384
01:21:36 74070 8192000000 10870261040 11349549056 1885552768 18.710 97 27 54 2 1907645440 14910768 7181904
01:22:59 106922 8192000000 10866379920 11333373952 1813881072 18.128 93 14 28 1 1828800208 11481216 3437920
01:24:58 78959 8192000000 10864661488 11329388544 1922252080 19.005 99 32 65 0 1941954144 10745552 8956512
01:26:33 41820 8192000000 9364950736 9646698496 519383056 5.962 27 6 12 0 526745696 5785360 1577280

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 24-12-2020 01:29:13 to 24-12-2020 01:29:43.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 220 v_add_invoice_to_stock 335544517
except 19 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-12-2020 01:29:44 to 24-12-2020 01:29:46.

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          251750
MON$OLDEST_ACTIVE               253140
MON$OLDEST_SNAPSHOT             253140
MON$NEXT_TRANSACTION            253140
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                       2027424
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'

24.12.20 01:29:47. 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-24 01:29:49 No severe PSQL-related problems occured
24.12.20 01:29:50. End of report.