Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.11.2020 22: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 17373712 kB
MemAvailable 31403296 kB
Buffers 0 kB
Cached 14285320 kB
SwapCached 2856 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-11-12 22:27:03
DTS_END                         2020-11-12 22:27:03.4710
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49756
TRN_ID                          233652
ATT_ID                          638
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: 9133.43 25940 1096012
customer order: creation 166.61 325 19993
customer order: refuse 14.23 403 1707
order to supplier: creation 44.15 1350 5298
order to supplier: removal 3.53 100695 424
invoice (draft): creation 44.26 3260 5311
invoice (draft): removal 50.98 676 6118
invoice accept: apply 40.47 18691 4856
invoice accept: cancel 46.71 769 5605
customer reserve: creation 3791.94 182 455033
customer reserve: removal 4643.86 62 557263
realization accept: apply 82.34 188 9881
realization accept: cancel 78.44 122 9413
payment from customer: creation 57.77 124 6932
payment from customer: removal 5.78 107 694
payment to supplier: creation 47.27 126 5672
payment to supplier: removal 3.44 98 413
service: total inventory turnovers 4.25 1263 510
service: total monetary turnovers 6.54 38 785
service: aggregate perf. data 0.83 20144 100
service: refresh index statistics 0.03 370179 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-11-2020 22:28:12 to 12-11-2020 22:28:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4898
TEST_TIME 2 4276
TEST_TIME 3 6225
TEST_TIME 4 6079
TEST_TIME 5 5953
TEST_TIME 6 5783
TEST_TIME 7 5862
TEST_TIME 8 6030
TEST_TIME 9 6089
TEST_TIME 10 6776
TEST_TIME 11 7042
TEST_TIME 12 7228
TEST_TIME 13 7300
TEST_TIME 14 7444
TEST_TIME 15 7426
TEST_TIME 16 8025
TEST_TIME 17 8220
TEST_TIME 18 8346
TEST_TIME 19 8660
TEST_TIME 20 8858
TEST_TIME 21 9080
TEST_TIME 22 9098
TEST_TIME 23 9298
TEST_TIME 24 9234
TEST_TIME 25 9346
TEST_TIME 26 9635
TEST_TIME 27 9788
TEST_TIME 28 10735
TEST_TIME 29 11305
TEST_TIME 30 11128
TEST_TIME 31 10868
TEST_TIME 32 10635
TEST_TIME 33 10827
TEST_TIME 34 10865
TEST_TIME 35 10673
TEST_TIME 36 10553
TEST_TIME 37 10415
TEST_TIME 38 10280
TEST_TIME 39 10261
TEST_TIME 40 10021
TEST_TIME 41 9972
TEST_TIME 42 9995
TEST_TIME 43 9863
TEST_TIME 44 9747
TEST_TIME 45 9760
TEST_TIME 46 9868
TEST_TIME 47 9864
TEST_TIME 48 9797
TEST_TIME 49 9743
TEST_TIME 50 9738
TEST_TIME 51 9752
TEST_TIME 52 9744
TEST_TIME 53 9715
TEST_TIME 54 9714
TEST_TIME 55 9727
TEST_TIME 56 9773
TEST_TIME 57 9654
TEST_TIME 58 9573
TEST_TIME 59 9670
TEST_TIME 60 9586
TEST_TIME 61 9524
TEST_TIME 62 9545
TEST_TIME 63 9506
TEST_TIME 64 9451
TEST_TIME 65 9358
TEST_TIME 66 9328
TEST_TIME 67 9240
TEST_TIME 68 9250
TEST_TIME 69 9249
TEST_TIME 70 9224
TEST_TIME 71 9212
TEST_TIME 72 9200
TEST_TIME 73 9233
TEST_TIME 74 9333
TEST_TIME 75 9266
TEST_TIME 76 9244
TEST_TIME 77 9361
TEST_TIME 78 9398
TEST_TIME 79 9376
TEST_TIME 80 9436
TEST_TIME 81 9433
TEST_TIME 82 9437
TEST_TIME 83 9354
TEST_TIME 84 9293
TEST_TIME 85 9314
TEST_TIME 86 9261
TEST_TIME 87 9235
TEST_TIME 88 9187
TEST_TIME 89 9162
TEST_TIME 90 9122
TEST_TIME 91 9185
TEST_TIME 92 9133
TEST_TIME 93 9207
TEST_TIME 94 9176
TEST_TIME 95 9155
TEST_TIME 96 9208
TEST_TIME 97 9258
TEST_TIME 98 9302
TEST_TIME 99 9271
TEST_TIME 100 9301
TEST_TIME 101 9337
TEST_TIME 102 9337
TEST_TIME 103 9352
TEST_TIME 104 9346
TEST_TIME 105 9391
TEST_TIME 106 9318
TEST_TIME 107 9280
TEST_TIME 108 9266
TEST_TIME 109 9269
TEST_TIME 110 9219
TEST_TIME 111 9172
TEST_TIME 112 9165
TEST_TIME 113 9158
TEST_TIME 114 9154
TEST_TIME 115 9123
TEST_TIME 116 9149
TEST_TIME 117 9165
TEST_TIME 118 9159
TEST_TIME 119 9207
TEST_TIME 120 9136

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-11-2020 22:28:15 to 12-11-2020 22:28:19.

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 1517469 1517469 0 0.00 0 20958 6 0 0
doc_list_biud 1517466 1517466 0 0.00 0 24249 28 0 0
sp_add_invoice_to_stock 5006 4856 150 2.99 41 162028 18692 0 150
sp_cancel_adding_invoice 5605 5605 0 0.00 4 63869 770 0 0
sp_cancel_client_order 1707 1707 0 0.00 4 15419 404 0 0
sp_cancel_customer_reserve 557263 557263 0 0.00 1 24278 63 0 0
sp_cancel_pay_from_customer 694 694 0 0.00 2 9204 107 0 0
sp_cancel_pay_to_supplier 413 413 0 0.00 3 8170 98 0 0
sp_cancel_supplier_invoice 6131 6118 13 0.21 1 13725 676 0 13
sp_cancel_supplier_order 424 424 0 0.00 8 979454 100696 0 0
sp_cancel_write_off 9413 9413 0 0.00 1 14476 122 0 0
sp_client_order 19993 19993 0 0.00 4 26496 326 0 0
sp_customer_reserve 455033 455033 0 0.00 0 108509 183 0 0
sp_fill_shopping_cart 30597 30597 0 0.00 1 11167 39 0 0
sp_fill_shopping_cart_clo_res 455031 455031 0 0.00 0 13792 12 0 0
sp_get_clo_for_invoice 4854 4854 0 0.00 0 21518 296 0 0
sp_kill_cost_storno 16125 16125 0 0.00 0 7750 57 0 0
sp_kill_qstorno_ret_qs2qd 1130481 1130481 0 0.00 0 24203 33 0 0
sp_kill_qty_storno 595264 595264 0 0.00 0 24249 71 0 0
sp_lock_selected_doc 20432 20432 0 0.00 0 7582 5 0 0
sp_make_cost_storno 27339 27339 0 0.00 0 14076 55 0 0
sp_multiply_rows_for_pdistr 27339 27339 0 0.00 0 6732 28 0 0
sp_multiply_rows_for_qdistr 19993 19993 0 0.00 0 26482 135 0 0
sp_pay_from_customer 6932 6932 0 0.00 4 12296 124 0 0
sp_pay_to_supplier 5672 5672 0 0.00 4 10873 126 0 0
sp_payment_common 12602 12602 0 0.00 1 10837 30 0 0
sp_qd_handle_on_cancel_clo 1707 1707 0 0.00 0 15411 359 0 0
sp_qd_handle_on_invoice_upd_sts 10458 10458 0 0.00 0 19625 322 0 0
sp_qd_handle_on_reserve_upd_sts 9881 9881 0 0.00 0 12915 64 0 0
sp_reserve_write_off 9881 9881 0 0.00 6 16234 188 0 0
sp_supplier_invoice 5311 5311 0 0.00 6 79097 3260 0 0
sp_supplier_order 5298 5298 0 0.00 5 48736 1351 0 0
srv_aggregate_perf_data 100 100 0 0.00 2808 474505 20145 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 944 143529 30627 0 0
srv_find_qd_qs_mism 1049514 1049514 0 0.00 0 20958 5 0 0
srv_make_invnt_saldo 510 510 0 0.00 35 81262 1264 0 0
srv_make_money_saldo 785 785 0 0.00 1 6786 38 0 0
srv_recalc_idx_stat 4 4 0 0.00 194297 677083 370179 0 0
t$perf-abend:sp_add_invoice_to_stock 150 150 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4856 4856 0 0.00 0 17198 188 0 0
t$perf-norm:sp_cancel_adding_invoice 402 402 0 0.00 0 9143 148 0 0
t$perf-norm:sp_cancel_client_order 1707 1707 0 0.00 0 6346 20 0 0
t$perf-norm:sp_cancel_customer_reserve 682 682 0 0.00 0 3235 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 694 694 0 0.00 0 11958 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 413 413 0 0.00 0 375 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 380 380 0 0.00 0 7938 33 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 19119 1680 0 0
t$perf-norm:sp_cancel_write_off 996 996 0 0.00 0 1657 9 0 0
t$perf-norm:sp_client_order 19993 19993 0 0.00 0 10247 21 0 0
t$perf-norm:sp_customer_reserve 1020 1020 0 0.00 0 5966 10 0 0
t$perf-norm:sp_pay_from_customer 6932 6932 0 0.00 0 9046 15 0 0
t$perf-norm:sp_pay_to_supplier 5672 5672 0 0.00 0 6498 14 0 0
t$perf-norm:sp_reserve_write_off 9881 9881 0 0.00 0 14330 16 0 0
t$perf-norm:sp_supplier_invoice 5311 5311 0 0.00 0 5187 17 0 0
t$perf-norm:sp_supplier_order 5298 5298 0 0.00 0 6726 14 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 625 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 442 6 0 0
t$perf-norm:srv_make_invnt_saldo 510 510 0 0.00 0 8393 43 0 0
t$perf-norm:srv_make_money_saldo 785 785 0 0.00 0 8631 42 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10006 9706 300 2.99 0 4171 21 0 300
v_all_customers 36730 36730 0 0.00 0 19 1 0 0
v_all_suppliers 29474 29474 0 0.00 0 14 1 0 0
v_all_wares 39986 39986 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 804 804 0 0.00 0 7553 26 0 0
v_cancel_client_order 3414 3414 0 0.00 0 8571 12 0 0
v_cancel_customer_prepayment 1388 1388 0 0.00 0 5215 13 0 0
v_cancel_customer_reserve 1364 1364 0 0.00 0 3737 8 0 0
v_cancel_payment_to_supplier 826 826 0 0.00 0 8164 14 0 0
v_cancel_supplier_invoice 786 760 26 3.30 0 3223 26 0 26
v_cancel_supplier_order 848 848 0 0.00 0 588 3 0 0
v_cancel_write_off 1992 1992 0 0.00 0 4166 17 0 0
v_max_id_clo_ord 5298 5298 0 0.00 0 1877 2 0 0
v_max_id_clo_res 1020 1020 0 0.00 0 4424 15 0 0
v_max_id_ord_sup 5306 5306 0 0.00 0 4880 4 0 0
v_max_non_paid_invoice 1537 1537 0 0.00 0 489 3 0 0
v_max_non_paid_realizn 3608 3608 0 0.00 0 4607 5 0 0
v_min_id_clo_ord 5298 5298 0 0.00 0 10549 10 0 0
v_min_id_clo_res 1020 1020 0 0.00 0 1136 4 0 0
v_min_id_ord_sup 5306 5306 0 0.00 0 4921 4 0 0
v_min_non_paid_invoice 5670 5670 0 0.00 0 6261 16 0 0
v_min_non_paid_realizn 6932 6932 0 0.00 0 10531 22 0 0
v_our_firm 9904 9904 0 0.00 0 18 1 0 0
v_reserve_write_off 19762 19762 0 0.00 0 6377 7 0 0
x_lock_depdocs_on_canc_invoice 11343 11343 0 0.00 0 21003 124 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 6214 333 0 0
x_make_qstorno_1000_1200 5298 5298 0 0.00 2 48703 1270 0 0
x_make_qstorno_1200_2000 5311 5311 0 0.00 3 79084 3122 0 0
x_make_qstorno_2100_3300 455033 455033 0 0.00 0 108485 168 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 12-11-2020 22:28:19 to 12-11-2020 22:28:24.

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
19:57:07 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:13 6631 8192000000 10082965456 10365485056 914172928 10.039 75 49 104 0 932541536 2259392 16109216
19:57:28 37166 8192000000 10316356848 10632105984 1345734000 14.109 100 83 167 0 1377636816 4419216 27483600
19:58:19 15887 8192000000 10361547920 10676809728 1409482800 14.679 100 88 176 0 1444379120 5985040 28911280
19:58:45 22571 8192000000 10393493968 10714886144 1434684304 14.903 100 89 178 0 1470491152 6668240 29138608
19:59:16 14633 8192000000 10395692416 10721796096 1453325728 15.067 100 90 181 0 1490230928 7768048 29137152
19:59:40 15593 8192000000 10411737376 10742169600 1463798048 15.159 100 80 160 0 1497326496 7636144 25892304
20:00:07 24941 8192000000 10449945888 10781184000 1499809600 15.475 100 86 172 1 1536152928 8737648 27605680
20:00:41 14260 8192000000 10460152608 10796109824 1517093376 15.625 100 88 176 0 1554302704 9378016 27831312
20:01:12 18654 8192000000 10487904144 10830807040 1543301600 15.852 100 81 162 0 1578855392 10144352 25409440
20:01:45 15740 8192000000 10522665504 10871914496 1576537472 16.138 100 83 164 0 1612178896 10466464 25174960
20:02:17 14610 8192000000 10557422272 10911780864 1607893440 16.407 100 80 159 2 1643605488 11502896 24209152
20:02:42 12601 8192000000 10581699184 10939170816 1633223136 16.622 100 80 160 1 1668309136 11282928 23803072
20:03:02 12449 8192000000 10600700096 10958954496 1657400608 16.827 100 85 170 0 1694822720 11753808 25668304
20:03:23 11629 8192000000 10607340208 10971402240 1661822016 16.864 100 79 158 0 1697761792 12387520 23552256
20:03:45 10571 8192000000 10630348560 10999799808 1691133680 17.111 100 80 160 0 1726839584 11866272 23839632
20:04:05 7044 8192000000 10648490256 11022143488 1709024832 17.261 100 89 173 3 1746270688 12378048 24867808
20:04:20 7632 8192000000 10657415856 11032334336 1720343088 17.355 100 74 146 3 1753122448 11472784 21306576
20:04:34 6641 8192000000 10673637040 11049304064 1735244640 17.479 100 75 151 1 1768446272 12147200 21054432
20:04:49 6563 8192000000 10687306400 11062235136 1748428848 17.589 100 85 168 2 1785325280 13559744 23336688
20:05:02 6356 8192000000 10699714848 11075792896 1755394128 17.646 100 82 165 0 1792103680 13694880 23014672
20:05:15 6156 8192000000 10706947312 11082178560 1761902896 17.700 100 79 158 1 1797487248 13680800 21903552
20:05:30 5847 8192000000 10712175808 11090165760 1770439344 17.771 100 86 172 1 1809296960 14370656 24486960
20:05:42 4830 8192000000 10720457760 11101454336 1780873824 17.857 100 82 163 1 1817251152 14047952 22329376
20:05:55 3536 8192000000 10720544624 11100803072 1786441888 17.903 100 92 184 0 1827317376 15148752 25726736
20:06:06 3871 8192000000 10735278032 11113930752 1791297536 17.942 100 86 170 1 1829596944 14477472 23821936
20:06:18 3229 8192000000 10731047120 11114971136 1793844944 17.963 100 83 166 2 1830326880 12909664 23572272
20:06:28 3208 8192000000 10755434688 11135012864 1812910400 18.120 100 87 170 0 1849790512 13310672 23569440
20:06:38 3610 8192000000 10748779024 11132850176 1814644192 18.134 100 90 178 2 1853007680 13547776 24815712
20:06:48 5336 8192000000 10749535920 11138686976 1815539152 18.141 100 79 154 1 1850717536 13282880 21895504
20:07:00 5429 8192000000 10773076464 11158638592 1823154848 18.203 100 86 172 0 1860201440 13277232 23769360
20:07:13 2264 8192000000 10780756672 11169185792 1844257712 18.375 100 84 169 1 1880722240 12478144 23986384
20:07:22 2136 8192000000 10780713792 11170287616 1844150736 18.375 100 83 165 1 1879618048 12442368 23024944
20:07:30 2016 8192000000 10795184992 11183394816 1852835936 18.445 100 95 191 0 1892266976 12343376 27087664
20:07:39 2454 8192000000 10797367504 11184152576 1854648976 18.460 100 89 178 2 1892614480 12501584 25463920
20:07:48 3534 8192000000 10798604432 11183570944 1857121424 18.480 100 91 179 1 1895341600 13257616 24962560
20:07:58 2139 8192000000 10805403808 11192930304 1860760576 18.509 100 90 180 4 1899800000 14403216 24636208
20:08:06 1486 8192000000 10808242528 11196940288 1859742576 18.501 100 91 181 1 1900005616 15623776 24639264
20:08:14 1281 8192000000 10809839488 11198869504 1864947648 18.543 100 92 185 0 1908379216 16848944 26582624
20:08:21 1450 8192000000 10810967296 11200483328 1868219456 18.570 100 91 182 0 1907712672 12782608 26710608
20:08:29 1931 8192000000 10818865168 11206070272 1870302336 18.587 100 88 176 0 1909121344 12587152 26231856
20:08:37 1463 8192000000 10819441984 11209486336 1873401920 18.612 100 92 180 2 1912393984 13315264 25676800
20:08:46 2018 8192000000 10819955024 11213672448 1875730608 18.631 100 86 173 1 1912441360 12131328 24579424
20:08:54 5030 8192000000 10803593424 11212578816 1877342672 18.644 100 79 158 1 1913126512 13540032 22243808
20:09:07 19885 8192000000 10812410336 11206901760 1874974304 18.625 100 62 123 2 1903898176 9954944 18968928
20:09:34 2049 8192000000 10837021920 11226497024 1888567488 18.734 100 92 182 1 1926154720 10502176 27085056
20:09:42 3002 8192000000 10806023808 11218776064 1881724016 18.679 100 58 114 0 1909360448 12081920 15554512
20:09:54 2994 8192000000 10799416944 11215622144 1880579648 18.670 100 45 88 3 1902161584 9300736 12281200
20:10:05 4494 8192000000 10797739280 11214311424 1878426992 18.652 100 42 84 1 1899240576 8296944 12516640
20:10:18 2793 8192000000 10803473504 11215249408 1884126240 18.698 100 60 121 0 1910169744 8493056 17550448
20:10:27 4036 8192000000 10805488480 11223552000 1882765424 18.687 100 44 88 1 1905754768 10749232 12240112
20:10:37 4475 8192000000 10806618720 11222257664 1888140672 18.731 100 44 88 3 1909860416 9174544 12545200
20:10:51 5020 8192000000 10801200528 11229290496 1889182512 18.739 100 44 88 1 1912211408 8733200 14295696
20:11:04 5400 8192000000 10823159584 11236626432 1893694160 18.776 100 51 102 1 1917337568 9166768 14476640
20:11:18 71887 8192000000 10796825904 11233579008 1890901424 18.753 100 28 56 2 1905184192 6455584 7827184
20:12:39 8292 8192000000 10814123984 11237711872 1896636656 18.799 100 34 68 0 1912800656 6601776 9562224
20:12:54 3981 8192000000 10813160288 11243814912 1897466496 18.806 100 28 56 0 1912997328 7621952 7908880
20:13:06 6897 8192000000 10808249968 11241664512 1897594352 18.807 100 31 62 1 1912731856 6427856 8709648
20:13:26 6837 8192000000 10811263312 11241152512 1898992736 18.818 100 38 79 0 1915960208 5437680 11529792
20:13:42 5099 8192000000 10812813888 11244847104 1902084144 18.843 100 45 91 1 1922609600 7463184 13062272
20:13:54 2694 8192000000 10825484432 11252670464 1910754160 18.913 100 52 101 4 1930759744 5188464 14817120
20:14:04 5948 8192000000 10824591904 11256406016 1908015728 18.891 100 31 62 2 1922601936 6158304 8427904
20:14:17 9919 8192000000 10823557360 11256569856 1912123920 18.924 100 19 37 3 1923635936 6016560 5495456
20:14:34 8487 8192000000 10816543872 11255549952 1912644592 18.928 100 22 44 3 1924723632 5852784 6226256
20:14:49 11493 8192000000 10824905200 11260268544 1911214480 18.916 100 18 36 0 1921989888 5790608 4984800
20:15:06 11012 8192000000 10810838960 11249262592 1891442112 18.757 99 18 35 1 1902878544 5631584 5804848
20:15:27 13121 8192000000 10817156816 11248906240 1887861664 18.729 99 19 38 2 1899483776 5621616 6000496
20:15:48 78134 8192000000 10823298288 11258798080 1907136016 18.884 100 30 60 0 1921570752 5222192 9212544
20:17:14 5223 8192000000 10824401056 11249405952 1890487376 18.750 99 26 51 1 1903287040 5908672 6890992
20:17:28 6574 8192000000 10808297712 11236376576 1890968800 18.754 100 39 78 1 1909855232 7269584 11616848
20:17:46 5259 8192000000 10819347056 11241578496 1893344128 18.773 100 35 69 1 1909835840 6792304 9699408
20:17:58 5336 8192000000 10789144496 11212804096 1812360432 18.115 96 34 68 2 1829228512 7101024 9767056
20:18:14 6082 8192000000 10782332640 11204263936 1850333184 18.425 99 25 50 0 1868100304 10833232 6933888
20:18:27 3978 8192000000 10776053712 11198427136 1842313696 18.360 99 34 68 2 1859480672 6566160 10600816
20:18:38 8815 8192000000 10780857888 11206602752 1829134224 18.252 98 19 38 2 1839596080 5550288 4911568
20:18:55 7664 8192000000 10754611680 11172573184 1752307392 17.621 94 23 44 2 1764218208 4950752 6960064
20:19:10 11939 8192000000 10714035376 11120660480 1710006736 17.269 93 20 40 1 1721259024 5310976 5941312
20:19:29 6560 8192000000 10743470576 11166027776 1826110368 18.228 100 25 50 2 1838936304 5897088 6928848
20:19:44 5514 8192000000 10707805680 11125301248 1756138592 17.652 97 39 78 1 1773614048 5702960 11772496
20:19:58 9513 8192000000 10697322640 11107332096 1723160816 17.379 96 23 46 1 1735095856 5174288 6760752
20:20:16 11924 8192000000 10700539360 11125907456 1781180784 17.859 99 17 34 1 1791952016 5807088 4964144
20:20:34 12915 8192000000 10716939200 11111714816 1719986736 17.352 95 36 73 0 1736847008 5053616 11806656
20:20:56 53987 8192000000 10715819824 11128012800 1741363072 17.530 96 23 46 0 1753673376 5659680 6650624
20:22:03 17891 8192000000 10723195360 11140214784 1740484800 17.523 96 18 36 1 1755139680 9646752 5008128
20:22:27 6471 8192000000 10736292656 11155771392 1802545616 18.035 99 29 58 2 1817616704 7012944 8058144
20:22:44 5862 8192000000 10743916800 11162689536 1814667712 18.134 99 48 98 2 1835654624 6836544 14150368
20:22:56 10132 8192000000 10736591152 11159339008 1810497280 18.100 99 24 47 0 1822341936 5223952 6620704
20:23:14 9327 8192000000 10735181824 11159748608 1818377248 18.164 100 19 38 2 1833931280 9831424 5722608
20:23:30 4721 8192000000 10753033536 11167703040 1831395856 18.271 100 25 50 1 1844035408 5294048 7345504
20:23:40 8933 8192000000 10747326656 11168071680 1829280528 18.253 100 17 33 2 1839261408 5405904 4574976
20:23:58 5424 8192000000 10744358512 11168075776 1818977920 18.169 99 24 46 3 1831554320 5802992 6773408
20:24:11 10439 8192000000 10769661568 11184291840 1842924288 18.365 100 30 60 2 1857610656 5263136 9423232
20:24:28 10405 8192000000 10769856112 11195633664 1856744128 18.477 100 42 84 1 1875378928 5666576 12968224
20:24:45 6259 8192000000 10771969760 11193630720 1836593424 18.313 99 23 46 1 1848529408 4457408 7478576
20:24:58 10018 8192000000 10784217840 11204579328 1860999664 18.511 100 24 48 2 1873361776 5048512 7313600
20:25:19 5666 8192000000 10776400592 11202691072 1861642224 18.517 100 24 48 1 1874820256 5517536 7660496
20:25:31 64437 8192000000 10796423968 11214848000 1865806528 18.550 100 22 44 3 1876502992 4980672 5715792
20:26:42 15387 8192000000 10778844928 11213766656 1871964176 18.600 100 20 40 2 1884678304 6728112 5986016
20:27:04 29825 8192000000 10830408816 11244826624 1890528288 18.750 100 28 55 0 1903293824 4790464 7975072
20:27:42 26746 8192000000 10837702768 11253846016 1911140464 18.916 100 56 113 1 1934245392 6257568 16847360
20:28:17 15902 8192000000 10851080784 11267096576 1918423168 18.974 100 46 91 1 1940838992 9448624 12967200
20:28:41 36618 8192000000 10863274096 11290415104 1928368992 19.054 100 50 101 1 1953987824 11122064 14496768
20:29:40 12792 8192000000 10864783824 11291193344 1934034496 19.099 100 45 90 1 1958793952 11927520 12831936
20:30:05 5741 8192000000 10875374784 11301933056 1940845248 19.154 100 53 106 1 1968903072 13343184 14714640
20:30:18 16866 8192000000 10888017696 11313426432 1947033504 19.203 100 57 110 3 1975429776 12520496 15875776
20:30:56 18914 8192000000 10889026000 11315884032 1951453584 19.238 100 37 74 1 1975287168 12879552 10954032
20:31:23 12349 8192000000 10901833712 11325411328 1959001504 19.298 100 56 109 0 1986753920 12181664 15570752
20:31:58 6125 8192000000 10905303104 11335380992 1966068880 19.354 100 49 98 1 1996108480 16439424 13600176
20:32:11 50566 8192000000 10885167728 11326541824 1952217920 19.244 99 49 98 2 1985633728 19392416 14023392
20:33:22 3857 8192000000 10906407648 11339866112 1971450880 19.397 100 47 94 2 2000386016 14435680 14499456
20:33:33 9466 8192000000 10908285536 11342065664 1974342064 19.420 100 45 88 3 2002813488 15375280 13096144
20:33:52 12437 8192000000 10915181840 11354501120 1980691264 19.470 100 50 100 1 2011600896 16460816 14448816
20:34:17 20254 8192000000 10916047296 11359051776 1981913168 19.480 100 35 69 2 2009403696 16656720 10833808
20:34:49 7926 8192000000 10929137184 11362648064 1987563696 19.525 100 44 88 1 2017655248 17423424 12668128
20:35:03 17685 8192000000 10932037056 11366178816 1966238672 19.356 99 41 82 1 2000146800 22049680 11858448
20:35:31 4667 8192000000 10950458816 11370602496 1993244144 19.569 100 56 112 0 2028661488 18778048 16639296
20:35:42 3828 8192000000 10942635680 11371827200 1991773472 19.558 100 63 124 3 2031231536 20737936 18720128
20:35:56 4257 8192000000 10929254992 11352350720 1949960384 19.226 98 67 134 1 1992292432 21435824 20896224
20:36:09 6859 8192000000 10929901952 11358482432 1980858240 19.471 100 63 126 5 2021433920 22021200 18554480
20:36:22 3044 8192000000 10946161792 11371360256 1993236576 19.569 100 75 148 0 2037814768 22678432 21899760
20:36:35 5895 8192000000 10957916272 11378356224 1993938368 19.575 100 72 142 3 2039599072 24865264 20795440
20:36:48 10168 8192000000 10941695920 11370954752 1990214752 19.545 100 68 134 2 2035863808 25346848 20302208
20:37:05 7738 8192000000 10945990592 11373871104 1990195488 19.545 100 64 126 0 2034704400 26002816 18506096
20:37:20 10768 8192000000 10936167536 11372236800 1984363696 19.499 100 62 123 0 2027830384 24850224 18616464
20:37:41 5683 8192000000 10950824096 11384877056 1991616496 19.557 100 54 108 2 2036816272 29048096 16151680
20:37:54 5671 8192000000 10956372336 11385589760 2002473760 19.642 100 69 136 2 2046081536 23122144 20485632
20:38:09 2115 8192000000 10958259296 11383611392 1984893040 19.503 99 74 140 4 2029649040 24169216 20586784
20:38:19 9795 8192000000 10974012576 11393626112 1999983248 19.623 100 74 147 1 2045428672 23370720 22074704
20:38:36 2529 8192000000 10961034784 11385851904 1988633424 19.533 99 82 164 0 2042230512 29772400 23824688
20:38:47 3445 8192000000 10962040192 11391279104 2003607568 19.651 100 70 140 2 2050170464 25644128 20918768
20:38:58 3781 8192000000 10965671680 11393290240 2004782944 19.660 100 71 141 2 2050345824 24615136 20947744
20:39:12 1835 8192000000 10958434640 11391307776 2005002304 19.662 100 66 131 0 2047554128 23961888 18589936
20:39:22 3136 8192000000 10951179392 11376971776 1982735344 19.486 99 84 166 0 2031547872 23774736 25037792
20:39:35 4138 8192000000 10957188720 11385806848 1999431888 19.618 100 70 139 1 2043330528 23734176 20164464
20:39:47 1740 8192000000 10974798496 11394387968 2007647360 19.683 100 87 174 1 2058741664 25614880 25479424
20:39:56 3002 8192000000 10977625472 11392294912 2001537536 19.635 100 75 151 3 2050964544 26543984 22883024
20:40:06 3434 8192000000 10975298672 11399032832 2011655312 19.715 100 80 161 2 2061924752 27028320 23241120
20:40:18 11743 8192000000 10979274576 11406172160 2013195632 19.727 100 79 158 2 2065866688 28765568 23905488
20:40:37 5556 8192000000 10974199056 11408281600 2013918896 19.732 100 67 132 3 2064104448 30035856 20149696
20:40:51 3374 8192000000 10966657232 11406028800 1994175584 19.577 99 66 131 2 2044627552 29955040 20496928
20:41:09 8204 8192000000 10979666096 11417620480 2015150096 19.742 100 64 128 0 2068404272 33072912 20181264
20:41:29 11562 8192000000 10980454816 11419107328 2019599344 19.777 100 59 118 1 2069805888 31747680 18458864
20:41:50 13934 8192000000 10970985168 11418361856 2014700624 19.738 100 43 86 0 2060433904 32104144 13629136
20:42:13 2863 8192000000 10963451680 11398881280 1992274816 19.562 99 70 139 1 2043220704 29072256 21873632
20:42:22 17920 8192000000 10941577424 11372208128 1928154352 19.052 96 64 128 0 1979291680 31182592 19954736
20:42:53 2729 8192000000 10961501648 11378696192 1976582640 19.438 100 81 162 0 2036765968 35593856 24589472
20:43:03 2681 8192000000 10979197520 11399061504 1998121936 19.608 100 91 182 0 2065736800 38736816 28878048
20:43:13 3201 8192000000 10994702448 11409543168 2006581696 19.675 100 93 183 0 2071858704 38270176 27006832
20:43:24 7369 8192000000 10994754160 11421650944 2011002320 19.709 100 80 160 0 2074270800 39707456 23561024
20:43:42 2660 8192000000 10984289984 11413258240 2016370864 19.752 100 78 156 0 2071144144 30216400 24556880
20:43:53 4691 8192000000 10988413424 11413778432 2013599600 19.730 100 78 156 2 2069140384 31898000 23642784
20:44:06 3272 8192000000 10999731200 11422957568 2018571216 19.769 100 80 160 1 2076366528 33585264 24210048
20:44:18 3053 8192000000 11007532208 11429285888 2026728704 19.833 100 83 166 0 2085902960 34032336 25141920
20:44:28 3767 8192000000 10996417136 11424694272 2020801504 19.786 100 79 158 2 2076744624 32711088 23232032
20:44:40 2306 8192000000 10968385584 11394830336 1976875744 19.440 98 79 158 0 2034189184 33194048 24119392
20:44:49 4861 8192000000 10959879504 11385237504 1985130144 19.505 99 79 158 0 2043785712 34621136 24034432
20:45:04 8923 8192000000 10977801360 11403186176 2000851312 19.629 100 73 146 1 2057950288 34633600 22465376
20:45:21 943 8192000000 10985096544 11403538432 2001750832 19.637 100 84 169 2 2062782176 35989104 25042240
20:45:28 3900 8192000000 10944039808 11362402304 1964682176 19.343 98 77 151 0 2024114448 36530576 22901696
20:45:41 2666 8192000000 10989478368 11416047616 2001850000 19.637 100 80 158 2 2068067392 42114224 24103168
20:45:52 3497 8192000000 10993556960 11415564288 2004660832 19.659 100 69 137 0 2063286544 37096464 21529248
20:46:03 5468 8192000000 10944079840 11374743552 1974385168 19.420 99 65 128 1 2030457232 36366880 19705184
20:46:16 4255 8192000000 10974108464 11399577600 1995225792 19.585 100 73 147 0 2053793728 36479872 22088064
20:46:28 3343 8192000000 10958878288 11384655872 1983436848 19.492 99 71 142 3 2040761968 35561792 21763328
20:46:39 1877 8192000000 10953853776 11377893376 1965454976 19.349 99 75 148 0 2026372336 37498848 23418512
20:46:51 7526 8192000000 10924604144 11367313408 1951495952 19.238 99 44 86 1 2001080496 35876544 13708000
20:47:05 3862 8192000000 10948483088 11372716032 1954858352 19.265 99 56 110 2 2008583952 36475440 17250160
20:47:16 6643 8192000000 10935527696 11371999232 1967292656 19.364 100 48 96 2 2019803072 37036416 15474000
20:47:32 11430 8192000000 10945508608 11381051392 1958854000 19.297 99 48 95 0 2014107008 39354736 15898272
20:48:05 12834 8192000000 10919750848 11362963456 1951393280 19.238 99 37 74 3 1993502864 30247296 11862288
20:48:26 2654 8192000000 10951496896 11374292992 1966582544 19.358 100 54 106 2 2017404512 33790560 17031408
20:48:37 9616 8192000000 10932581328 11362009088 1933362832 19.094 98 46 92 1 1984930416 36317936 15249648
20:48:59 15691 8192000000 10928070736 11373654016 1952803536 19.249 99 38 76 1 2002235824 36496368 12935920
20:49:36 8423 8192000000 10925059552 11366326272 1948573216 19.215 99 42 84 1 2001728064 38492464 14662384
20:49:51 8646 8192000000 10942953408 11381424128 1964857904 19.345 100 39 78 0 2018382544 40777184 12747456
20:50:08 4252 8192000000 10960434080 11390627840 1982669232 19.486 100 60 121 2 2044306400 42175920 19461248
20:50:21 4569 8192000000 10953303184 11390627840 1965537392 19.350 99 45 90 1 2024184032 43218896 15427744
20:50:34 18409 8192000000 10942134688 11382677504 1970240400 19.387 100 32 64 0 2018389056 37426512 10722144
20:51:07 10153 8192000000 10954734112 11387588608 1980467056 19.468 100 47 91 0 2032832336 37573776 14791504
20:51:31 2582 8192000000 10957685600 11389501440 1963532032 19.334 99 52 104 1 2022695888 41950864 17212992
20:51:42 4983 8192000000 10967754432 11398631424 1985726688 19.510 100 59 118 2 2050720960 45474880 19519392
20:52:05 7546 8192000000 10970396992 11414642688 1990978112 19.552 100 46 90 1 2055485648 49155456 15352080
20:52:28 16055 8192000000 10973791104 11412156416 1972873920 19.408 99 39 76 1 2032047872 46363648 12810304
20:52:53 17386 8192000000 10951592160 11397914624 1960986016 19.314 99 31 62 2 2023527616 51573344 10968256
20:53:17 12883 8192000000 10953879936 11398193152 1974282640 19.419 100 33 66 1 2035240256 49903872 11053744
20:53:36 22399 8192000000 10951961760 11408769024 1985368864 19.507 100 30 60 1 2047220240 51329424 10521952
20:54:40 29964 8192000000 10914152096 11378069504 1931883616 19.082 99 21 42 2 1992153248 52723152 7546480
20:55:53 40736 8192000000 10879645552 11338788864 1892952048 18.770 98 16 32 0 1940150560 42009472 5189040
20:56:40 44666 8192000000 10865348880 11327234048 1906615888 18.879 99 11 22 1 1936587264 25849856 4121520
20:57:51 44232 8192000000 10872964160 11316072448 1931688832 19.080 100 33 68 0 1954431584 13423328 9319424
20:58:42 25932 8192000000 10894041840 11341901824 1951108928 19.235 100 42 79 2 1977085104 14634272 11341904
21:00:28 47847 8192000000 10874896400 11360964608 1944725184 19.184 100 8 17 1 1962888656 16133264 2030208
21:01:22 18666 8192000000 10880767696 11364257792 1949467984 19.222 100 9 19 0 1970606672 18625104 2513584
21:03:22 70866 8192000000 10877762496 11343478784 1915284656 18.949 98 12 24 0 1926508656 8106304 3117696
21:04:44 39968 8192000000 10873844960 11333230592 1917149216 18.964 98 17 32 1 1930435648 8817552 4468880
21:05:33 46391 8192000000 10865037136 11336417280 1914023104 18.939 98 13 27 1 1930988000 13355440 3609456
21:06:26 10675 8192000000 10863135936 11336704000 1938089216 19.132 100 6 13 0 1955036064 15134528 1812320
21:06:43 15613 8192000000 10862484096 11339444224 1941544704 19.159 100 5 10 0 1956884768 14295504 1044560
21:07:05 53130 8192000000 10865668208 11320872960 1903865808 18.857 98 14 28 0 1919489312 11937952 3685552
21:08:09 49830 8192000000 10886208448 11351420928 1948666928 19.216 100 19 35 1 1963506416 9583776 5255712
21:09:13 58172 8192000000 10909571200 11359858688 1942639168 19.168 99 23 44 2 1961909568 12878912 6391488
21:10:17 59833 8192000000 10906481136 11368656896 1966083696 19.354 100 19 38 1 1987605232 15850192 5671344
21:11:47 82697 8192000000 10931070848 11367473152 1957986240 19.290 99 34 68 0 1982720848 14915872 9818736
21:13:29 76816 8192000000 10900697008 11377360896 1974984880 19.425 100 18 36 1 1989993216 10245376 4762960
21:14:54 95409 8192000000 10899929584 11369787392 1926761744 19.041 97 11 22 1 1946728736 16616960 3350032
21:16:36 62130 8192000000 10913164880 11374817280 1958114016 19.291 99 24 48 0 1975132368 10474432 6543920
21:17:45 61914 8192000000 10915686432 11386683392 1957309040 19.285 99 18 36 2 1976938000 14916016 4712944
21:19:08 66104 8192000000 10932588032 11378360320 1945779520 19.193 98 28 55 0 1965684544 11103424 8801600
21:20:23 74774 8192000000 10912750064 11389247488 1979639296 19.462 100 20 40 1 1996858864 11367584 5851984
21:21:52 70944 8192000000 10912113744 11382124544 1941848800 19.162 98 21 42 2 1967997584 20399888 5748896
21:23:12 123798 8192000000 10922685344 11360026624 1937176688 19.124 98 14 28 0 1953621984 12222896 4222400
21:25:26 48163 8192000000 10918955664 11391180800 1983094336 19.489 100 31 62 0 2001371008 9753360 8523312
21:26:58 74906 8192000000 10924856656 11400101888 1991057456 19.552 100 20 40 1 2010073360 13624576 5391328
21:28:20 18857 8192000000 10905544832 11380572160 1955064128 19.267 98 19 39 0 1970439472 9888032 5487312
21:28:59 48806 8192000000 10882664832 11367620608 1941635776 19.160 98 33 63 1 1958407264 7594288 9177200
21:29:54 60035 8192000000 10889764512 11378434048 1974317040 19.420 100 10 20 0 1986511904 9720848 2474016
21:31:00 33082 8192000000 10893637312 11369959424 1954763504 19.264 99 8 16 0 1969025520 12014032 2247984
21:31:39 13340 8192000000 10879641376 11365707776 1950926000 19.234 99 3 6 0 1959668816 8255088 487728
21:31:59 24942 8192000000 10879015936 11365892096 1946933648 19.202 99 5 11 0 1959721616 11467920 1320048
21:32:30 12168 8192000000 10874621040 11359170560 1946041264 19.195 99 13 26 3 1960560176 11034592 3484320
21:34:13 80514 8192000000 10876369584 11364098048 1934394848 19.102 98 10 20 1 1946312976 9005552 2912576
21:35:40 95119 8192000000 10905058480 11376373760 1945283072 19.189 98 16 32 2 1960181696 9710288 5188336
21:37:24 20537 8192000000 10885659968 11346788352 1932792592 19.089 98 41 80 3 1949853024 6279600 10780832
21:37:53 26046 8192000000 10893645344 11359563776 1953465968 19.254 99 33 65 0 1970697264 8577344 8653952
21:38:32 19127 8192000000 10877599184 11338919936 1900529584 18.831 97 34 68 1 1918650096 8782496 9338016
21:38:59 29435 8192000000 10837324944 11294408704 1825580640 18.223 95 29 58 2 1845157360 12081744 7494976
21:39:42 54773 8192000000 10866120832 11329511424 1881415280 18.677 98 18 36 0 1905467808 19295040 4757488
21:40:43 76596 8192000000 10839828224 11308064768 1851734080 18.436 96 14 28 2 1876310272 20124288 4451904
21:42:11 19007 8192000000 10826481120 11271573504 1858080304 18.488 97 32 64 1 1877278640 9846928 9351408
21:42:42 29353 8192000000 10856576112 11302080512 1871998048 18.600 97 36 72 1 1896591808 14480784 10112976
21:43:17 33982 8192000000 10866282384 11313582080 1885488416 18.709 98 54 107 1 1916842096 16448496 14905184
21:43:57 30872 8192000000 10846989296 11313119232 1896974784 18.802 99 36 72 0 1923946832 16693648 10278400
21:44:37 91042 8192000000 10835892464 11310534656 1861858640 18.518 97 14 28 1 1878601680 13052544 3690496
21:46:15 82221 8192000000 10873625120 11348160512 1936100640 19.116 100 18 36 1 1955224784 14011744 5112400
21:47:44 93160 8192000000 10875954752 11329339392 1847917968 18.405 95 17 34 1 1865845872 13495200 4432704
21:49:28 110593 8192000000 10838943936 11309215744 1867265056 18.562 97 26 52 0 1885025392 10624848 7135488
21:51:30 67570 8192000000 10843879552 11324514304 1921527392 18.999 100 12 24 1 1936477200 11558352 3391456
21:53:19 30041 8192000000 10813103680 11279994880 1886937632 18.721 99 13 24 0 1902953408 12592688 3423088
21:54:08 70816 8192000000 10833981936 11299835904 1882296624 18.684 98 15 30 1 1897705664 11018848 4390192
21:55:25 73037 8192000000 10846018128 11317743616 1906044752 18.875 99 8 16 0 1915494944 6620432 2829760
21:56:46 58909 8192000000 10866193552 11328733184 1921635232 19.000 99 16 32 1 1935609152 9396288 4577632
21:58:33 83611 8192000000 10882498704 11345022976 1900093936 18.827 97 22 44 0 1919859136 13514672 6250528
22:00:12 42713 8192000000 10873533456 11344576512 1914995664 18.947 98 14 28 0 1929332720 10584176 3752880
22:01:02 28608 8192000000 10890118080 11348520960 1941992400 19.163 99 25 50 4 1963368304 14470256 6905648
22:01:44 32596 8192000000 10892120464 11352580096 1939071376 19.139 99 29 58 2 1960210656 12952256 8187024
22:02:23 38330 8192000000 10899968800 11362963456 1960281408 19.308 100 24 48 0 1980167440 13362464 6523568
22:03:16 51518 8192000000 10902414368 11382075392 1969499184 19.381 100 19 38 0 1993465744 18307616 5658944
22:04:14 56910 8192000000 10920587360 11362459648 1918113808 18.972 97 26 51 1 1936690640 11441600 7135232
22:05:18 70142 8192000000 10902803392 11378020352 1946362880 19.197 99 22 44 1 1965738656 13146208 6229568
22:06:34 63620 8192000000 10900279664 11367972864 1936219136 19.117 98 18 36 0 1950376864 9243584 4914144
22:07:50 82661 8192000000 10915901184 11381321728 1938639584 19.136 98 9 18 0 1955746880 14889584 2217712
22:09:23 109064 8192000000 10899818656 11371855872 1878006672 18.649 95 13 25 3 1890952592 9618656 3327264
22:11:18 91210 8192000000 10914756528 11386523648 1969774656 19.384 100 21 42 1 1994936576 18762416 6399504
22:13:00 143529 8192000000 10943624688 11388915712 1988500752 19.532 100 23 46 1 2005753648 10664768 6588128
22:15:30 65002 8192000000 10904418656 11384225792 1980613632 19.470 100 28 56 1 1998050240 9816096 7620512
22:17:58 66213 8192000000 10903565328 11375841280 1944055120 19.179 98 16 32 0 1958874432 10013840 4805472
22:19:11 85164 8192000000 10885643728 11365031936 1934820144 19.105 98 19 39 2 1955878368 14660864 6397360
22:21:00 35504 8192000000 10886210432 11361685504 1948201712 19.212 99 22 44 0 1962849296 8568032 6079552
22:21:43 87522 8192000000 10902549856 11388653568 1960395696 19.309 99 24 48 1 1977803248 10330688 7076864
22:23:37 73800 8192000000 10882080816 11357908992 1914972672 18.947 97 17 34 2 1930564048 10777152 4814224
22:25:04 26425 8192000000 10884939568 11338715136 1903623168 18.855 97 28 54 0 1917323648 6604048 7096432
22:25:38 13663 8192000000 10877491392 11333582848 1914072704 18.939 98 53 106 0 1939109760 9517728 15519328
22:26:01 51732 8192000000 10854237136 11334606848 1907632944 18.888 98 31 62 1 1932692192 16209072 8850176
22:27:02 15358 8192000000 9240132816 9498189824 400424640 4.660 21 1 2 0 404105872 3619104 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 12-11-2020 22:28:25 to 12-11-2020 22:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 150 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-11-2020 22:28:58 to 12-11-2020 22:29:00.

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          233959
MON$OLDEST_ACTIVE               233960
MON$OLDEST_SNAPSHOT             233960
MON$NEXT_TRANSACTION            233960
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                       2025632
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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'

12.11.20 22:29:01. 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-11-12 22:29:03 No severe PSQL-related problems occured
12.11.20 22:29:05. End of report.