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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17219140 kB
MemAvailable 31589284 kB
Buffers 0 kB
Cached 14448900 kB
SwapCached 1964 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-03 01:27:05
DTS_END                         2020-12-03 01:27:05.4020
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/34368
TRN_ID                          248773
ATT_ID                          689
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: 9698.26 18869 1163791
customer order: creation 181.73 314 21808
customer order: refuse 15.69 308 1883
order to supplier: creation 48.46 1314 5815
order to supplier: removal 3.71 99504 445
invoice (draft): creation 48.88 3209 5865
invoice (draft): removal 55.68 772 6681
invoice accept: apply 43.28 17302 5193
invoice accept: cancel 50.03 761 6003
customer reserve: creation 4043.51 169 485221
customer reserve: removal 4896.16 58 587539
realization accept: apply 87.96 151 10555
realization accept: cancel 86.53 111 10383
payment from customer: creation 62.73 129 7528
payment from customer: removal 6.16 69 739
payment to supplier: creation 51.11 117 6133
payment to supplier: removal 3.46 82 415
service: total inventory turnovers 5.24 1053 629
service: total monetary turnovers 7.09 46 851
service: aggregate perf. data 0.84 21960 101
service: refresh index statistics 0.03 229955 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-12-2020 01:27:49 to 03-12-2020 01:27:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5443
TEST_TIME 2 6254
TEST_TIME 3 6124
TEST_TIME 4 6445
TEST_TIME 5 6216
TEST_TIME 6 6294
TEST_TIME 7 6215
TEST_TIME 8 6337
TEST_TIME 9 6284
TEST_TIME 10 6399
TEST_TIME 11 6675
TEST_TIME 12 7016
TEST_TIME 13 7143
TEST_TIME 14 7072
TEST_TIME 15 7197
TEST_TIME 16 7289
TEST_TIME 17 7437
TEST_TIME 18 7528
TEST_TIME 19 7519
TEST_TIME 20 8382
TEST_TIME 21 8318
TEST_TIME 22 8563
TEST_TIME 23 8537
TEST_TIME 24 8970
TEST_TIME 25 9277
TEST_TIME 26 9541
TEST_TIME 27 10217
TEST_TIME 28 10612
TEST_TIME 29 11097
TEST_TIME 30 11289
TEST_TIME 31 11086
TEST_TIME 32 10985
TEST_TIME 33 10978
TEST_TIME 34 10908
TEST_TIME 35 11244
TEST_TIME 36 11164
TEST_TIME 37 11001
TEST_TIME 38 11162
TEST_TIME 39 11060
TEST_TIME 40 10881
TEST_TIME 41 10780
TEST_TIME 42 10621
TEST_TIME 43 10521
TEST_TIME 44 10578
TEST_TIME 45 10447
TEST_TIME 46 10403
TEST_TIME 47 10264
TEST_TIME 48 10151
TEST_TIME 49 10141
TEST_TIME 50 10276
TEST_TIME 51 10338
TEST_TIME 52 10239
TEST_TIME 53 10235
TEST_TIME 54 10141
TEST_TIME 55 10053
TEST_TIME 56 9988
TEST_TIME 57 9986
TEST_TIME 58 9951
TEST_TIME 59 9936
TEST_TIME 60 9953
TEST_TIME 61 9932
TEST_TIME 62 10003
TEST_TIME 63 10017
TEST_TIME 64 9978
TEST_TIME 65 10057
TEST_TIME 66 10087
TEST_TIME 67 10137
TEST_TIME 68 10071
TEST_TIME 69 10104
TEST_TIME 70 10193
TEST_TIME 71 10177
TEST_TIME 72 10151
TEST_TIME 73 10120
TEST_TIME 74 10026
TEST_TIME 75 10020
TEST_TIME 76 9971
TEST_TIME 77 9989
TEST_TIME 78 9922
TEST_TIME 79 9861
TEST_TIME 80 9839
TEST_TIME 81 9854
TEST_TIME 82 9819
TEST_TIME 83 9794
TEST_TIME 84 9781
TEST_TIME 85 9799
TEST_TIME 86 9790
TEST_TIME 87 9822
TEST_TIME 88 9858
TEST_TIME 89 9879
TEST_TIME 90 9863
TEST_TIME 91 9888
TEST_TIME 92 9962
TEST_TIME 93 9949
TEST_TIME 94 9978
TEST_TIME 95 10073
TEST_TIME 96 10007
TEST_TIME 97 10088
TEST_TIME 98 10047
TEST_TIME 99 9984
TEST_TIME 100 9941
TEST_TIME 101 9931
TEST_TIME 102 9885
TEST_TIME 103 9845
TEST_TIME 104 9844
TEST_TIME 105 9801
TEST_TIME 106 9777
TEST_TIME 107 9744
TEST_TIME 108 9735
TEST_TIME 109 9702
TEST_TIME 110 9754
TEST_TIME 111 9735
TEST_TIME 112 9727
TEST_TIME 113 9702
TEST_TIME 114 9741
TEST_TIME 115 9782
TEST_TIME 116 9738
TEST_TIME 117 9808
TEST_TIME 118 9796
TEST_TIME 119 9778
TEST_TIME 120 9706

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 03-12-2020 01:27:52 to 03-12-2020 01:27:56.

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 1612505 1612505 0 0.00 0 12805 6 0 0
doc_list_biud 1612503 1612503 0 0.00 0 29152 27 0 0
sp_add_invoice_to_stock 5312 5193 119 2.24 24 212658 17302 0 119
sp_cancel_adding_invoice 6003 6003 0 0.00 4 87434 762 0 0
sp_cancel_client_order 1883 1883 0 0.00 4 9208 309 0 0
sp_cancel_customer_reserve 587539 587539 0 0.00 1 26550 59 0 0
sp_cancel_pay_from_customer 739 739 0 0.00 3 1713 69 0 0
sp_cancel_pay_to_supplier 415 415 0 0.00 2 4177 82 0 0
sp_cancel_supplier_invoice 6693 6681 12 0.17 1 29159 772 0 12
sp_cancel_supplier_order 445 445 0 0.00 10 1163810 99504 0 0
sp_cancel_write_off 10383 10383 0 0.00 1 11156 112 0 0
sp_client_order 21808 21808 0 0.00 4 12480 315 0 0
sp_customer_reserve 485221 485221 0 0.00 0 79055 169 0 0
sp_fill_shopping_cart 33485 33485 0 0.00 1 14956 37 0 0
sp_fill_shopping_cart_clo_res 485216 485216 0 0.00 0 12969 12 0 0
sp_get_clo_for_invoice 5184 5184 0 0.00 0 22720 241 0 0
sp_kill_cost_storno 17540 17540 0 0.00 0 12092 59 0 0
sp_kill_qstorno_ret_qs2qd 1192587 1192587 0 0.00 0 29149 31 0 0
sp_kill_qty_storno 628671 628671 0 0.00 0 29151 68 0 0
sp_lock_selected_doc 21837 21837 0 0.00 0 7426 3 0 0
sp_make_cost_storno 29400 29400 0 0.00 0 12613 47 0 0
sp_multiply_rows_for_pdistr 29399 29399 0 0.00 0 12804 32 0 0
sp_multiply_rows_for_qdistr 21808 21808 0 0.00 0 12034 135 0 0
sp_pay_from_customer 7528 7528 0 0.00 4 12811 130 0 0
sp_pay_to_supplier 6133 6133 0 0.00 4 13304 117 0 0
sp_payment_common 13661 13661 0 0.00 1 10428 28 0 0
sp_qd_handle_on_cancel_clo 1883 1883 0 0.00 0 9196 284 0 0
sp_qd_handle_on_invoice_upd_sts 11187 11187 0 0.00 0 22297 348 0 0
sp_qd_handle_on_reserve_upd_sts 10553 10553 0 0.00 0 14349 47 0 0
sp_reserve_write_off 10555 10555 0 0.00 6 14362 152 0 0
sp_supplier_invoice 5865 5865 0 0.00 5 75002 3209 0 0
sp_supplier_order 5815 5815 0 0.00 5 32349 1314 0 0
srv_aggregate_perf_data 101 101 0 0.00 2694 383823 21961 0 0
srv_fill_mon_cache_memory 170 170 0 0.00 1227 177771 30182 0 0
srv_find_qd_qs_mism 1113182 1113182 0 0.00 0 10844 5 0 0
srv_make_invnt_saldo 629 629 0 0.00 32 36211 1053 0 0
srv_make_money_saldo 851 851 0 0.00 1 9234 46 0 0
srv_recalc_idx_stat 4 4 0 0.00 132493 392119 229955 0 0
t$perf-abend:sp_add_invoice_to_stock 119 119 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5195 5195 0 0.00 0 12370 158 0 0
t$perf-norm:sp_cancel_adding_invoice 423 423 0 0.00 0 4847 120 0 0
t$perf-norm:sp_cancel_client_order 1883 1883 0 0.00 0 5218 17 0 0
t$perf-norm:sp_cancel_customer_reserve 708 708 0 0.00 0 3603 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 739 739 0 0.00 0 2231 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 415 415 0 0.00 0 440 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 411 411 0 0.00 0 5152 30 0 0
t$perf-norm:sp_cancel_supplier_order 445 445 0 0.00 0 21412 1609 0 0
t$perf-norm:sp_cancel_write_off 1078 1078 0 0.00 0 9020 21 0 0
t$perf-norm:sp_client_order 21808 21808 0 0.00 0 15730 21 0 0
t$perf-norm:sp_customer_reserve 1102 1102 0 0.00 0 2404 9 0 0
t$perf-norm:sp_pay_from_customer 7528 7528 0 0.00 0 8458 12 0 0
t$perf-norm:sp_pay_to_supplier 6133 6133 0 0.00 0 5575 10 0 0
t$perf-norm:sp_reserve_write_off 10555 10555 0 0.00 0 6562 16 0 0
t$perf-norm:sp_supplier_invoice 5865 5865 0 0.00 0 6660 21 0 0
t$perf-norm:sp_supplier_order 5815 5815 0 0.00 0 8330 16 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 1242 19 0 0
t$perf-norm:srv_fill_mon_cache_memory 170 170 0 0.00 0 498 9 0 0
t$perf-norm:srv_make_invnt_saldo 629 629 0 0.00 0 810 18 0 0
t$perf-norm:srv_make_money_saldo 851 851 0 0.00 0 925 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10602 10364 238 2.24 0 11847 18 0 238
v_all_customers 39550 39550 0 0.00 0 188 1 0 0
v_all_suppliers 32402 32402 0 0.00 0 18 1 0 0
v_all_wares 43616 43616 0 0.00 0 125 1 0 0
v_cancel_adding_invoice 846 846 0 0.00 0 1737 10 0 0
v_cancel_client_order 3766 3766 0 0.00 0 2042 3 0 0
v_cancel_customer_prepayment 1478 1478 0 0.00 0 1690 7 0 0
v_cancel_customer_reserve 1416 1416 0 0.00 0 1891 8 0 0
v_cancel_payment_to_supplier 830 830 0 0.00 0 871 4 0 0
v_cancel_supplier_invoice 846 822 24 2.83 0 3044 18 0 24
v_cancel_supplier_order 890 890 0 0.00 0 143 3 0 0
v_cancel_write_off 2156 2156 0 0.00 0 11134 18 0 0
v_max_id_clo_ord 5814 5814 0 0.00 0 423 1 0 0
v_max_id_clo_res 1102 1102 0 0.00 0 1850 10 0 0
v_max_id_ord_sup 5863 5863 0 0.00 0 6317 5 0 0
v_max_non_paid_invoice 1609 1609 0 0.00 0 2395 5 0 0
v_max_non_paid_realizn 4064 4064 0 0.00 0 3469 4 0 0
v_min_id_clo_ord 5814 5814 0 0.00 0 4129 7 0 0
v_min_id_clo_res 1102 1102 0 0.00 0 1235 3 0 0
v_min_id_ord_sup 5863 5863 0 0.00 0 7637 10 0 0
v_min_non_paid_invoice 6133 6133 0 0.00 0 5570 15 0 0
v_min_non_paid_realizn 7528 7528 0 0.00 0 7809 19 0 0
v_our_firm 10994 10994 0 0.00 0 12 1 0 0
v_reserve_write_off 21104 21104 0 0.00 0 8079 6 0 0
x_lock_depdocs_on_canc_invoice 12273 12273 0 0.00 0 21518 124 0 0
x_lock_depdocs_on_canc_sup_ord 445 445 0 0.00 0 6851 344 0 0
x_make_qstorno_1000_1200 5815 5815 0 0.00 1 32336 1233 0 0
x_make_qstorno_1200_2000 5865 5865 0 0.00 3 74952 3079 0 0
x_make_qstorno_2100_3300 485221 485221 0 0.00 0 79055 154 0 0

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

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:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:15 10173 8192000000 10201702624 10503745536 851800736 9.418 67 54 112 0 871685312 2349664 17534912
22:57:34 33091 8192000000 10331041312 10647564288 1371909712 14.344 100 84 168 0 1403905008 4154832 27840464
22:58:19 9737 8192000000 10372864768 10692820992 1427701024 14.841 100 86 172 0 1461676912 5766016 28209872
22:58:43 21924 8192000000 10411803232 10736406528 1463152464 15.154 100 87 174 0 1498019376 7103200 27763712
22:59:16 16665 8192000000 10420930640 10748616704 1475358848 15.261 100 86 172 0 1511090368 7874640 27856880
22:59:41 15126 8192000000 10448579056 10781921280 1498416160 15.462 100 86 172 0 1533936832 8180896 27339776
23:00:15 15504 8192000000 10465452848 10801717248 1522666224 15.673 100 90 180 0 1559985440 8977088 28342128
23:00:40 20361 8192000000 10493023184 10836971520 1536651584 15.795 100 81 162 1 1571917920 9474768 25791568
23:01:09 16245 8192000000 10501032272 10846920704 1564738016 16.037 100 82 164 1 1600436448 10417152 25281280
23:01:38 14799 8192000000 10527486848 10882408448 1587756320 16.235 100 82 164 0 1623404384 10666416 24981648
23:02:01 13215 8192000000 10559876144 10911588352 1609750960 16.423 100 83 166 0 1645816880 11228416 24837504
23:02:24 9780 8192000000 10570298320 10928406528 1627835776 16.577 100 76 152 0 1661883696 11766016 22281904
23:02:46 10147 8192000000 10597829760 10957668352 1650950208 16.772 100 79 157 1 1686783312 12809184 23023920
23:03:03 10904 8192000000 10618728912 10982825984 1670984000 16.941 100 80 161 0 1707868080 12759360 24124720
23:03:23 7802 8192000000 10634587904 10999709696 1693869488 17.134 100 76 152 0 1727838400 12245104 21723808
23:03:37 7123 8192000000 10644349216 11014750208 1703665456 17.216 100 82 164 2 1740415712 12868688 23881568
23:03:54 7586 8192000000 10657268496 11029286912 1718507312 17.340 100 83 166 1 1756147792 13279360 24361120
23:04:09 7416 8192000000 10665557440 11045879808 1728053264 17.419 100 75 150 0 1762377952 12847280 21477408
23:04:24 5303 8192000000 10683847040 11063369728 1741065312 17.527 100 75 150 0 1774946944 12235840 21645792
23:04:37 5544 8192000000 10695975728 11073982464 1756611184 17.656 100 82 162 2 1792418624 12866672 22940768
23:04:49 5256 8192000000 10709834064 11089756160 1770220176 17.769 100 83 166 0 1807250240 12980000 24050064
23:05:01 4229 8192000000 10714969296 11096510464 1776704880 17.822 100 77 154 0 1811490944 12767952 22018112
23:05:13 3514 8192000000 10720410096 11102740480 1785769376 17.897 100 82 164 1 1822096928 13592352 22735200
23:05:23 4334 8192000000 10735731088 11116122112 1794932032 17.972 100 90 180 2 1834924128 14280736 25711360
23:05:33 10949 8192000000 10730782288 11118350336 1798247920 18.000 100 81 162 0 1834709488 14060192 22401376
23:05:51 5502 8192000000 10740661840 11124690944 1803971520 18.046 100 80 156 2 1838768320 13407920 21388880
23:06:04 2390 8192000000 10762901200 11145568256 1822415248 18.197 100 91 180 0 1862207824 15177200 24615376
23:06:13 3436 8192000000 10775234272 11161387008 1827511184 18.239 100 89 179 0 1866108896 14408160 24189552
23:06:24 2520 8192000000 10767423664 11156459520 1831592512 18.272 100 90 178 4 1879814688 23171632 25050544
23:06:33 2665 8192000000 10776487472 11164565504 1837514816 18.321 100 90 178 0 1876636832 14110736 25011280
23:06:42 2382 8192000000 10771367104 11166203904 1838198000 18.326 100 82 163 1 1873854912 12823712 22833200
23:06:51 2149 8192000000 10784235856 11172343808 1844811888 18.380 100 90 180 2 1883377728 13248800 25317040
23:06:59 2196 8192000000 10788697008 11174453248 1847655152 18.403 100 86 170 2 1883901392 12558912 23687328
23:07:07 2362 8192000000 10793030080 11181412352 1851480832 18.434 100 94 188 0 1891541312 13319840 26740640
23:07:16 2635 8192000000 10797537600 11183271936 1852854640 18.445 100 90 180 1 1894098368 15157040 26086688
23:07:25 2222 8192000000 10798888896 11190059008 1858289920 18.489 100 95 190 2 1898633008 13868768 26474320
23:07:34 2066 8192000000 10802456480 11189895168 1859745120 18.501 100 87 173 2 1896144816 12262224 24137472
23:07:42 3204 8192000000 10795713136 11187240960 1855612464 18.468 100 73 146 0 1888572944 12645696 20314784
23:07:52 2345 8192000000 10802621488 11194433536 1858453232 18.491 100 81 162 1 1893208944 12174192 22581520
23:08:01 25001 8192000000 10798123680 11192811520 1860847280 18.510 100 71 139 0 1892264448 12392352 19024816
23:08:33 1609 8192000000 10808876256 11201196032 1869615632 18.581 100 82 165 0 1905591584 11741312 24234640
23:08:41 2403 8192000000 10821786304 11214229504 1877142752 18.642 100 92 184 1 1915314752 11595872 26576128
23:08:49 2373 8192000000 10814922624 11210760192 1879864992 18.664 100 72 144 1 1912990576 12413536 20712048
23:08:58 7023 8192000000 10797860384 11214450688 1875845440 18.632 100 69 138 2 1907337328 12046640 19445248
23:09:25 12129 8192000000 10810086048 11211747328 1874982592 18.625 100 58 115 1 1898832000 7013856 16835552
23:09:44 3932 8192000000 10800674656 11212333056 1875511632 18.629 100 50 100 0 1900078416 10291456 14275328
23:09:54 6279 8192000000 10793808960 11215912960 1877608096 18.646 100 45 90 0 1899930704 9632368 12690240
23:10:07 4657 8192000000 10802359920 11215757312 1879443072 18.661 100 47 92 1 1901888480 9292816 13152592
23:10:18 4828 8192000000 10799515360 11215003648 1878186752 18.650 100 39 78 1 1897500496 8555472 10758272
23:10:30 4957 8192000000 10798321008 11219468288 1880493040 18.669 100 42 84 1 1900740720 8689168 11558512
23:10:43 5214 8192000000 10794224704 11219570688 1879215392 18.659 100 35 70 1 1896337504 7107536 10014576
23:10:56 6419 8192000000 10796862416 11220643840 1881939184 18.681 100 31 61 0 1898079936 6687952 9452800
23:11:15 7258 8192000000 10790212704 11220246528 1885144896 18.707 100 23 46 1 1898531872 6910976 6476000
23:11:28 5652 8192000000 10816946752 11235123200 1888527904 18.734 100 32 64 2 1909537264 12056208 8953152
23:11:43 5550 8192000000 10806774256 11228950528 1887932112 18.729 100 30 54 1 1906824688 10619616 8272960
23:11:55 54698 8192000000 10828487632 11238268928 1892574192 18.767 100 44 88 0 1911473056 5831904 13066960
23:12:57 5697 8192000000 10806142496 11242528768 1895458640 18.790 100 38 76 0 1915513776 9785648 10269488
23:13:10 4660 8192000000 10820482768 11249381376 1892223248 18.764 100 23 46 1 1916790448 18362608 6204592
23:13:23 4995 8192000000 10805581024 11234213888 1893024016 18.770 100 19 38 2 1903970256 5606752 5339488
23:13:37 8568 8192000000 10811777072 11240271872 1895583328 18.791 100 32 65 2 1911353728 6925024 8845376
23:13:53 5792 8192000000 10805522816 11243565056 1895547056 18.790 100 22 44 1 1916635504 14895168 6193280
23:14:06 7564 8192000000 10807977536 11242700800 1898874336 18.817 100 26 52 0 1912670992 6565840 7230816
23:14:22 9322 8192000000 10816369072 11247419392 1899737440 18.824 100 17 32 2 1909941248 5226736 4977072
23:14:41 5749 8192000000 10820161872 11246227456 1905603920 18.871 100 28 57 2 1920437568 6378288 8455360
23:14:53 6062 8192000000 10810929120 11249266688 1902401760 18.846 100 23 46 2 1915673904 6283536 6988608
23:15:07 12936 8192000000 10813646496 11250573312 1906257024 18.877 100 20 39 1 1917866704 5614720 5994960
23:15:27 13180 8192000000 10819566080 11252690944 1888911872 18.737 99 31 60 1 1904729088 6013136 9804080
23:15:48 51815 8192000000 10796730736 11235573760 1895809840 18.793 100 35 69 1 1912335040 5664416 10860784
23:16:45 14749 8192000000 10786749392 11216068608 1786888384 17.906 94 26 51 3 1800690992 6068720 7733888
23:17:09 8473 8192000000 10793521744 11226443776 1884280256 18.700 100 35 70 2 1901766864 7375360 10111248
23:17:24 7226 8192000000 10777969600 11210190848 1840917920 18.348 98 22 44 0 1852583136 5587200 6078016
23:17:38 5820 8192000000 10782497152 11196743680 1816446816 18.149 97 29 58 3 1830481056 6056592 7977648
23:17:50 4843 8192000000 10775603728 11193757696 1822847136 18.201 98 29 57 2 1837591920 7177680 7567104
23:18:02 8106 8192000000 10753147104 11181461504 1824921936 18.218 99 33 66 4 1840674656 6780976 8971744
23:18:16 4867 8192000000 10746357536 11161649152 1801940048 18.030 97 39 79 1 1818655648 5093440 11622160
23:18:30 5779 8192000000 10754155456 11179360256 1798778864 18.004 97 28 57 1 1813576960 7195728 7602368
23:18:42 7345 8192000000 10729308784 11142787072 1744343712 17.555 95 34 67 3 1759894784 5646160 9904912
23:18:56 8659 8192000000 10741871392 11163373568 1808387984 18.083 99 26 52 3 1821044768 4882464 7774320
23:19:11 9176 8192000000 10716651632 11130085376 1742228640 17.537 96 25 50 2 1755919296 6364320 7326336
23:19:27 5319 8192000000 10689315248 11107319808 1735375152 17.480 96 17 34 0 1745221152 5214512 4631488
23:19:38 18820 8192000000 10708639296 11126689792 1634695264 16.635 90 18 36 2 1645252240 5418208 5138768
23:20:04 9918 8192000000 10718335344 11128532992 1770177280 17.768 98 33 67 0 1787129776 7116336 9836160
23:20:56 27559 8192000000 10716814688 11134218240 1730694736 17.441 95 38 76 0 1751696432 9628640 11373056
23:21:30 11161 8192000000 10733391792 11154567168 1813830032 18.127 100 25 51 1 1826573104 5560992 7182080
23:21:48 5222 8192000000 10700539552 11115089920 1775699264 17.814 98 25 50 1 1789711568 6872448 7139856
23:22:00 4731 8192000000 10737080416 11154915328 1820842736 18.185 100 35 69 2 1837915296 6824480 10248080
23:22:11 7125 8192000000 10748363472 11164844032 1812003936 18.112 99 21 42 1 1823387296 5669984 5713376
23:22:25 7909 8192000000 10742745152 11165184000 1817149792 18.154 99 27 52 3 1831244144 6153408 7940944
23:22:41 5436 8192000000 10738012352 11150295040 1799140544 18.007 98 39 77 5 1814632688 4765280 10726864
23:22:53 6214 8192000000 10761701904 11175493632 1832293392 18.278 100 20 40 1 1843848512 5315120 6240000
23:23:06 5138 8192000000 10754052560 11176185856 1820534896 18.182 99 31 62 1 1835396048 4999568 9861584
23:23:17 10025 8192000000 10737845376 11163574272 1821520224 18.190 99 18 36 0 1832122896 4901392 5701280
23:23:35 10113 8192000000 10764369360 11184082944 1840659968 18.346 100 27 54 5 1853826128 5047088 8119072
23:23:52 7231 8192000000 10758236288 11188224000 1848046704 18.406 100 24 48 2 1860584272 5508928 7028640
23:24:05 14522 8192000000 10767621600 11191963648 1851112832 18.431 100 16 32 2 1861081760 5534688 4434240
23:24:26 7295 8192000000 10762380656 11198640128 1856418768 18.474 100 24 48 2 1869394224 6156128 6819328
23:24:46 69726 8192000000 10779135456 11208613888 1860174944 18.505 100 21 41 2 1871412048 5200304 6036800
23:26:08 9072 8192000000 10780971456 11211726848 1868006928 18.568 100 26 52 0 1881444304 6295456 7141920
23:26:24 5778 8192000000 10787039952 11212697600 1867189856 18.562 100 32 65 0 1883417424 7240368 8987200
23:26:38 2730 8192000000 10795123456 11217022976 1874665328 18.622 100 46 90 1 1895107136 7909632 12532176
23:26:48 6385 8192000000 10797799296 11216945152 1868567632 18.573 100 26 52 3 1881374384 4969616 7837136
23:27:02 16660 8192000000 10806835040 11224100864 1877086544 18.642 100 28 56 0 1890489792 5862320 7540928
23:27:28 8279 8192000000 10830005568 11242532864 1895855216 18.793 100 54 108 0 1918876736 7223728 15797792
23:27:46 11486 8192000000 10839214384 11247009792 1901733696 18.840 100 55 111 3 1925551248 8475424 15342128
23:28:09 5751 8192000000 10846558560 11258048512 1907727040 18.888 100 58 115 0 1933289184 9178208 16383936
23:28:22 22739 8192000000 10842291168 11266666496 1916263840 18.957 100 54 106 1 1941600288 9639408 15697040
23:28:54 26327 8192000000 10857416944 11277561856 1924674672 19.024 100 47 94 1 1947456656 9348368 13433616
23:29:40 21406 8192000000 10860116080 11286253568 1931836848 19.082 100 44 88 3 1952890640 8704192 12349600
23:30:12 28982 8192000000 10883625392 11303882752 1944623376 19.184 100 43 86 3 1966539776 9581664 12334736
23:30:57 11856 8192000000 10887827824 11315142656 1951522224 19.239 100 50 100 2 1977985056 11646016 14816816
23:31:16 25157 8192000000 10875365680 11315007488 1954239968 19.260 100 46 92 2 1979713264 12251344 13221952
23:31:49 73937 8192000000 10885362832 11329273856 1939052400 19.139 99 28 56 1 1962397136 15121952 8222784
23:33:10 36810 8192000000 10889634096 11328974848 1941700320 19.160 99 33 66 0 1964229760 13009952 9519488
23:34:03 11842 8192000000 10888831744 11328888832 1941817408 19.161 99 38 75 1 1969950752 17660160 10473184
23:34:22 17127 8192000000 10897491520 11336851456 1962810032 19.328 100 38 76 2 1992393600 18118304 11465264
23:34:49 5883 8192000000 10917362464 11342233600 1953889936 19.257 99 60 120 1 1991472976 20002000 17581040
23:35:03 7956 8192000000 10913561824 11338502144 1962415584 19.325 100 60 118 1 2001772384 22012880 17343920
23:35:26 11004 8192000000 10922695856 11348172800 1967948768 19.369 100 61 122 4 2012177392 25889600 18339024
23:35:45 13074 8192000000 10924011392 11354935296 1969719408 19.383 100 50 100 3 2009650096 25509728 14420960
23:36:05 10888 8192000000 10926069168 11355525120 1979350880 19.460 100 57 115 0 2020135056 22765024 18019152
23:36:25 5927 8192000000 10923358656 11354025984 1965720416 19.351 99 60 118 2 2005974192 22912672 17341104
23:36:44 8343 8192000000 10936595152 11368366080 1986854944 19.519 100 56 112 0 2027288448 23613936 16819568
23:37:00 3247 8192000000 10943705872 11365212160 1986065984 19.513 100 68 136 0 2030059136 23763552 20229600
23:37:13 5527 8192000000 10948312384 11368398848 1988712080 19.534 100 62 124 1 2031792688 24615760 18464848
23:37:26 2987 8192000000 10940263056 11363782656 1969460560 19.381 99 68 134 2 2015760016 26032400 20267056
23:37:36 2249 8192000000 10947026320 11374690304 1986057824 19.513 100 65 130 0 2036675728 30767504 19850400
23:37:46 9487 8192000000 10944106336 11365117952 1975026432 19.425 99 60 118 0 2024557200 32090624 17440144
23:38:02 9403 8192000000 10945358960 11377573888 1989458432 19.540 100 61 122 0 2040140128 32295216 18386480
23:38:23 4235 8192000000 10948329712 11378040832 1985745792 19.510 100 71 141 0 2039282384 32598416 20938176
23:38:38 5954 8192000000 10953993408 11377942528 1989128640 19.537 100 61 123 0 2036233072 29081936 18022496
23:38:52 14740 8192000000 10941869600 11378020352 1987736912 19.526 100 52 104 1 2032885536 29813856 15334768
23:39:14 7183 8192000000 10966842304 11400904704 2005085920 19.663 100 59 117 0 2056741920 34404128 17251872
23:39:29 2435 8192000000 10971215632 11395121152 2005047936 19.663 100 80 156 1 2060990976 32860096 23082944
23:39:39 2172 8192000000 10961209840 11382513664 1991706112 19.557 100 72 144 2 2044588800 31592320 21290368
23:39:49 2372 8192000000 10957149120 11371053056 1976088224 19.434 100 83 166 1 2033512448 32563632 24860592
23:39:59 2986 8192000000 10963763216 11380240384 1986367888 19.515 100 82 164 2 2044563744 33743328 24452528
23:40:13 2481 8192000000 10974556320 11391143936 1992867360 19.566 100 88 175 0 2054786176 34612416 27306400
23:40:24 4692 8192000000 10960672320 11378913280 1988631872 19.533 100 81 162 1 2047827088 35146592 24048624
23:40:38 2046 8192000000 10965841040 11377004544 1991676640 19.557 100 86 172 5 2051889232 34275504 25937088
23:40:47 2538 8192000000 10933325792 11349991424 1958675568 19.296 99 80 159 2 2017153456 35282352 23195536
23:40:58 5981 8192000000 10948289552 11371659264 1972937008 19.409 100 72 141 4 2031219520 37437520 20844992
23:41:18 6501 8192000000 10932285440 11344691200 1919823792 18.985 97 68 133 2 1976785008 36976672 19984544
23:41:36 8200 8192000000 10889104112 11310858240 1891530336 18.758 96 61 121 1 1949263472 39709552 18023584
23:41:52 4875 8192000000 10896231648 11324006400 1887918080 18.729 97 50 97 0 1944459232 40892256 15648896
23:42:06 2993 8192000000 10922551392 11327873024 1929757696 19.065 99 81 164 2 1996960528 42295840 24906992
23:42:23 5011 8192000000 10915037312 11331248128 1933273648 19.093 99 69 138 1 1997104224 42504272 21326304
23:42:36 2894 8192000000 10925286592 11336597504 1943074224 19.171 100 74 148 0 2010407952 45356400 21977328
23:42:46 1995 8192000000 10938967456 11345629184 1934887264 19.106 99 82 162 1 2005784816 46407072 24490480
23:42:55 2213 8192000000 10927956480 11333382144 1932982576 19.091 99 83 166 0 2006383024 47690112 25710336
23:43:04 7759 8192000000 10911237680 11330678784 1931938768 19.082 99 75 151 1 2004812272 48642080 24231424
23:43:19 2954 8192000000 10923101328 11338354688 1936179728 19.116 99 72 142 1 2006130640 47749168 22201744
23:43:30 2363 8192000000 10903681168 11313631232 1905119136 18.867 99 79 158 1 1979270624 48793840 25357648
23:43:39 3390 8192000000 10911164256 11324776448 1923438576 19.014 100 65 130 1 1993550464 49445392 20666496
23:43:51 4912 8192000000 10925022880 11336773632 1937739232 19.129 100 76 151 0 2011106848 49755968 23611648
23:44:04 7222 8192000000 10944896816 11353071616 1951993552 19.242 100 83 163 4 2024939104 47914288 25031264
23:44:18 7708 8192000000 10944343984 11352117248 1946827232 19.201 100 88 175 1 2025323760 51685408 26811120
23:44:33 2450 8192000000 10922578288 11331362816 1935953680 19.114 100 85 170 2 2014272176 52239056 26079440
23:44:43 1682 8192000000 10939057504 11344314368 1939417984 19.142 100 86 168 1 2020547120 55197776 25931360
23:44:57 10649 8192000000 10924112624 11335442432 1928287056 19.053 100 74 148 0 2008377456 57045648 23044752
23:45:16 5281 8192000000 10936433696 11343589376 1938197840 19.132 100 73 146 1 2017424848 56019792 23207216
23:45:28 2233 8192000000 10944313696 11350712320 1941989824 19.163 100 78 153 0 2021107120 55143760 23973536
23:45:38 2247 8192000000 10937342432 11338002432 1924059840 19.019 99 78 151 1 2003231968 54957120 24215008
23:45:49 1228 8192000000 10947225376 11353776128 1945557712 19.191 100 81 162 1 2026601408 55737008 25306688
23:45:57 2863 8192000000 10934534256 11338055680 1927596576 19.048 99 83 165 1 2010103904 55895568 26611760
23:46:07 2267 8192000000 10924481120 11324825600 1924060832 19.019 99 83 165 1 2007424640 57700896 25662912
23:46:16 1696 8192000000 10961304400 11360899072 1951466144 19.238 100 90 178 0 2040102816 59292208 29344464
23:46:26 2968 8192000000 10961337600 11366711296 1953634272 19.255 100 81 162 2 2037639536 59345072 24660192
23:46:37 3504 8192000000 10977153344 11378323456 1962074448 19.323 100 88 176 1 2051009328 61524768 27410112
23:46:48 2576 8192000000 10969200224 11372830720 1949210752 19.220 99 90 180 1 2039832448 62148864 28472832
23:47:00 1226 8192000000 10972423616 11380355072 1964429008 19.341 100 92 183 1 2057821216 63727360 29664848
23:47:08 3171 8192000000 10953200304 11357126656 1940184896 19.148 99 85 169 0 2028791392 62082656 26523840
23:47:20 2453 8192000000 10980127744 11383050240 1966309808 19.356 100 88 176 3 2054895328 61149984 27435536
23:47:30 4037 8192000000 10959267888 11372851200 1936958512 19.122 99 69 138 0 2026480128 67474816 22046800
23:47:41 7104 8192000000 10960682080 11366817792 1953859376 19.257 100 70 140 2 2039770160 63325232 22585552
23:47:57 17923 8192000000 10935004016 11367112704 1954023712 19.259 100 37 74 1 2017813296 51768368 12021216
23:48:31 3370 8192000000 10943987808 11373195264 1962116928 19.323 100 57 114 2 2031456416 51721936 17617552
23:48:48 12096 8192000000 10952673808 11381575680 1963348672 19.333 100 43 82 2 2031120016 53536496 14234848
23:49:13 2403 8192000000 10954056944 11373621248 1961055072 19.314 100 67 134 2 2036626464 54935824 20635568
23:49:24 6923 8192000000 10961857952 11387105280 1969614512 19.382 100 57 115 1 2045093680 57569408 17909760
23:49:43 5660 8192000000 10947566816 11365072896 1938069360 19.131 99 64 126 4 2017382000 58675584 20637056
23:49:59 15992 8192000000 10939174000 11370115072 1935889136 19.114 99 41 82 1 2008129536 57993952 14246448
23:50:22 11876 8192000000 10945514976 11377950720 1949969264 19.226 100 40 80 0 2023203744 59242800 13991680
23:50:44 3693 8192000000 10947837696 11381080064 1952355616 19.245 100 48 96 2 2033505936 64967216 16183104
23:50:55 1990 8192000000 10977566480 11387666432 1960267712 19.308 100 63 128 0 2044045328 62307536 21470080
23:51:05 7313 8192000000 10949637472 11383537664 1943314128 19.173 99 58 116 1 2025920672 63286784 19319760
23:51:21 14593 8192000000 10947619408 11383222272 1951446448 19.238 100 41 81 1 2024729888 59106336 14177104
23:51:46 7173 8192000000 10961974608 11397500928 1961119328 19.315 100 49 97 2 2044191296 66611920 16460048
23:52:02 14627 8192000000 10950094352 11387305984 1945905840 19.194 99 37 74 0 2025627264 66733584 12987840
23:52:28 15886 8192000000 10963736160 11408314368 1964293776 19.340 100 37 74 1 2052540880 74916192 13330912
23:52:58 16678 8192000000 10943260608 11388223488 1937615776 19.128 99 32 64 3 2012750240 62988624 12145840
23:53:26 24714 8192000000 10941962160 11391459328 1951432256 19.238 100 28 56 0 2016324144 54444608 10447280
23:54:02 17290 8192000000 10923246208 11377995776 1936380576 19.118 99 36 72 1 2003031920 54136464 12514880
23:54:30 18366 8192000000 10927093904 11385610240 1945353408 19.189 100 27 54 2 2010032912 55220784 9458720
23:55:00 6847 8192000000 10907330672 11371692032 1941926368 19.162 100 25 50 2 1995482368 44544400 9011600
23:55:14 8425 8192000000 10904103408 11366109184 1941036704 19.155 100 26 52 0 1991338016 41210416 9090896
23:55:30 19089 8192000000 10883347504 11354730496 1933452512 19.094 100 19 38 0 1976997424 36602528 6942384
23:55:56 19938 8192000000 10884703376 11367972864 1933861792 19.098 100 15 31 0 1966758976 27626112 5271072
23:56:22 3735 8192000000 10886984400 11365511168 1935225264 19.109 100 11 22 0 1969956288 31016256 3714768
23:56:36 27404 8192000000 10878087904 11357884416 1935662976 19.112 100 9 18 1 1959336688 21090848 2582864
23:57:10 122217 8192000000 10905620096 11365113856 1895733664 18.792 97 9 18 0 1917627248 19510128 2383456
23:59:18 76660 8192000000 10924308560 11381354496 1960389104 19.309 99 26 52 2 1984677968 17240880 7047984
00:01:48 154884 8192000000 10929518976 11407937536 1911772272 18.921 97 7 14 1 1944131808 30401840 1957696
00:04:29 177770 8192000000 10921866640 11372953600 1907449424 18.886 96 12 24 1 1929941376 19045216 3446736
00:07:46 53816 8192000000 10912205936 11368873984 1979612368 19.462 100 46 92 2 2004106896 10984448 13510080
00:08:47 138910 8192000000 10931119712 11397636096 1986994672 19.520 100 23 46 0 2006807584 13664000 6148912
00:11:13 81963 8192000000 10913598208 11389161472 1909189472 18.900 96 15 30 2 1924138784 10376768 4572544
00:12:49 46154 8192000000 10905068832 11373322240 1930530336 19.071 97 43 86 1 1951855728 8751616 12573776
00:15:23 63562 8192000000 10934797296 11400323072 1984761904 19.502 100 25 51 1 2007940688 16057808 7120976
00:16:53 16220 8192000000 10932399648 11382636544 1983267088 19.491 100 56 109 0 2016052544 16786624 15998832
00:17:29 46368 8192000000 10901480000 11390676992 1986703712 19.518 100 44 87 1 2018267216 18274448 13289056
00:18:26 41164 8192000000 10884109184 11355377664 1947855488 19.209 99 18 36 0 1960937216 8549040 4532688
00:19:14 9573 8192000000 10891030944 11364712448 1971759328 19.399 100 21 42 3 1984816352 7048304 6008720
00:19:32 96047 8192000000 10872019664 11346579456 1848943584 18.414 94 13 23 0 1859917216 7818352 3155280
00:21:18 104630 8192000000 10893467792 11368112128 1960360784 19.309 100 19 37 2 1975058080 9467184 5230112
00:23:10 73687 8192000000 10883488192 11350667264 1909666864 18.904 97 17 34 0 1924342112 9455136 5220112
00:24:33 97696 8192000000 10888525104 11364409344 1919016080 18.979 98 21 40 2 1936990752 12344432 5630240
00:26:17 38426 8192000000 10864001104 11339837440 1919384912 18.982 98 10 20 0 1931520800 9433424 2702464
00:27:02 61807 8192000000 10891295888 11363430400 1936825744 19.121 99 19 39 1 1950871392 8890400 5155248
00:28:13 100439 8192000000 10868715424 11344654336 1813901904 18.128 92 16 32 1 1830476448 12098016 4476528
00:30:02 36722 8192000000 10874812304 11340128256 1901334768 18.837 97 23 46 1 1917078608 9101440 6642400
00:30:46 55125 8192000000 10873481456 11340541952 1899641840 18.823 97 17 34 1 1926069792 21754384 4673568
00:31:55 46208 8192000000 10899309488 11372519424 1961712992 19.320 100 16 32 0 1979648752 13281888 4653872
00:32:59 66952 8192000000 10897111408 11343650816 1869496576 18.580 95 13 26 0 1881418912 8225680 3696656
00:34:12 53831 8192000000 10876375264 11344027648 1872627408 18.606 96 17 34 2 1887904048 10413840 4862800
00:35:19 28863 8192000000 10847651440 11306360832 1848342384 18.409 95 16 32 0 1865402816 12276640 4783792
00:36:02 34852 8192000000 10879441808 11340419072 1910869792 18.914 99 20 40 2 1929647104 13320752 5456560
00:36:43 56662 8192000000 10836074064 11313655808 1814334512 18.131 94 17 33 2 1835999712 16484848 5180352
00:37:46 59234 8192000000 10873180240 11318980608 1868652480 18.573 97 14 28 2 1885120992 12829104 3639408
00:38:52 27530 8192000000 10890115424 11331215360 1928569280 19.055 100 33 66 0 1945808736 7771648 9467808
00:39:29 11014 8192000000 10886866512 11331112960 1940463312 19.150 100 55 108 1 1966375328 10761424 15150592
00:39:48 12412 8192000000 10892566400 11342290944 1944682976 19.184 100 45 90 0 1968700064 11502464 12514624
00:40:07 108259 8192000000 10875799968 11339952128 1939628160 19.144 100 32 64 0 1960374432 11482720 9263552
00:42:11 57489 8192000000 10872335904 11347333120 1930377424 19.070 99 17 34 1 1951125360 16284496 4463440
00:43:15 35845 8192000000 10882070032 11356749824 1951027232 19.235 100 24 48 0 1976536192 18195024 7313936
00:43:57 10186 8192000000 10852214448 11337265152 1925622768 19.032 99 8 16 2 1944727008 16185824 2918416
00:44:38 38430 8192000000 10847210256 11321143296 1904568256 18.863 98 18 35 2 1918977600 9342512 5066832
00:46:23 72602 8192000000 10864711712 11344879616 1924906144 19.026 99 18 35 0 1942477392 12133392 5437856
00:48:01 57366 8192000000 10861447440 11356135424 1946112064 19.196 100 11 22 0 1963679824 14035552 3532208
00:49:12 30174 8192000000 10862570528 11338874880 1914459344 18.942 98 17 33 0 1926936320 6760896 5716080
00:50:02 57352 8192000000 10839887360 11313455104 1866176608 18.553 96 9 18 0 1875525840 7209040 2140192
00:51:06 23926 8192000000 10833600320 11300487168 1879905824 18.664 98 21 40 2 1891782528 6908416 4968288
00:51:39 31656 8192000000 10873556992 11326619648 1932890736 19.090 100 29 58 1 1949349408 8629200 7829472
00:52:17 10069 8192000000 10881266464 11340742656 1946974720 19.202 100 57 114 0 1972774176 9677456 16122000
00:52:33 40822 8192000000 10865877488 11333787648 1937813984 19.129 100 30 60 1 1957477008 11518176 8144848
00:53:24 24419 8192000000 10873488080 11333644288 1924837216 19.026 99 27 54 1 1941211744 9054928 7319600
00:54:00 75384 8192000000 10878485392 11346051072 1914219088 18.941 98 26 52 0 1929821696 8751712 6850896
00:55:29 67786 8192000000 10897717440 11371831296 1956384128 19.277 100 13 26 0 1973001456 12598448 4018880
00:56:45 38481 8192000000 10895315312 11359608832 1945806560 19.193 99 18 36 1 1960006272 9156112 5043600
00:57:31 24605 8192000000 10906410480 11369889792 1959862512 19.305 99 26 52 0 1974855152 8051728 6940912
00:58:02 60273 8192000000 10894134688 11362115584 1920294288 18.989 97 17 34 1 1939039552 14289504 4455760
00:59:18 96850 8192000000 10905085760 11371839488 1906374928 18.878 96 15 30 2 1924220224 13445696 4399600
01:01:39 52920 8192000000 10872657584 11340091392 1829294336 18.254 93 28 55 3 1849463936 11945040 8224560
01:02:42 61542 8192000000 10890826688 11367354368 1945924960 19.194 100 12 24 0 1965156752 15687760 3544032
01:04:19 136781 8192000000 10863325664 11341037568 1886623136 18.719 96 11 22 1 1906137184 16512288 3001760
01:07:02 29190 8192000000 10884262096 11350650880 1923613792 19.016 98 42 84 1 1944046256 8996064 11436400
01:07:37 15477 8192000000 10867109600 11319459840 1907030656 18.883 98 41 80 2 1928676800 10118592 11527552
01:09:11 75946 8192000000 10867294752 11348045824 1902019632 18.843 97 5 10 0 1918089936 14871376 1198928
01:10:33 32442 8192000000 10862104736 11339968512 1928708032 19.057 99 12 24 0 1946029504 13831232 3490240
01:12:15 69125 8192000000 10857664112 11326746624 1920957984 18.995 98 19 38 0 1941452400 15191760 5302656
01:13:32 66527 8192000000 10901973696 11360534528 1932118624 19.084 98 20 39 0 1947609040 10632192 4858224
01:14:48 1243 8192000000 10897074880 11342524416 1945162272 19.188 99 54 107 0 1971755248 11383872 15209104
01:15:01 65126 8192000000 10866063184 11347079168 1928219904 19.053 98 26 52 2 1951302736 15114176 7968656
01:16:13 61493 8192000000 10881052000 11372216320 1940361680 19.150 99 15 30 1 1959577904 14839456 4376768
01:17:21 51201 8192000000 10868918320 11329998848 1885043328 18.706 96 12 25 1 1900171632 12499520 2628784
01:18:24 66008 8192000000 10874287776 11357343744 1911476528 18.918 98 17 34 2 1930129776 13924352 4728896
01:19:36 41924 8192000000 10887420688 11345797120 1937335008 19.125 99 23 46 1 1955020704 11398064 6287632
01:20:24 40011 8192000000 10898993664 11363852288 1910295904 18.909 97 44 88 1 1939322560 15784384 13242272
01:21:11 98784 8192000000 10868346832 11346403328 1880529696 18.669 96 20 38 2 1903176592 17385488 5261408
01:23:00 95755 8192000000 10892612832 11378262016 1939802352 19.145 99 20 40 1 1960092544 14088576 6201616
01:24:42 86287 8192000000 10892979040 11356229632 1906203888 18.876 97 12 24 0 1921379120 12084656 3090576
01:26:43 20752 8192000000 10867786000 11324006400 1899586592 18.823 97 40 81 0 1920705904 10118560 11000752

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 03-12-2020 01:28:03 to 03-12-2020 01:28:35.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 119 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-12-2020 01:28:36 to 03-12-2020 01:28:38.

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          245362
MON$OLDEST_ACTIVE               248956
MON$OLDEST_SNAPSHOT             248956
MON$NEXT_TRANSACTION            248956
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                       2060768
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:275: 
:276: mscs-test-161.budzdorov.ru    Thu Dec  3 01:27:08 2020
:277:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:278: 
:279: 
:280: mscs-test-161.budzdorov.ru    Thu Dec  3 01:27:13 2020
:281:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:282: 
--- end of diff output ---

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

03.12.20 01:28:39. 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-03 01:28:41 No severe PSQL-related problems occured
03.12.20 01:28:43. End of report.