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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17152080 kB
MemAvailable 31220812 kB
Buffers 0 kB
Cached 14573280 kB
SwapCached 4772 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-11 01:27:18
DTS_END                         2021-02-11 01:27:18.3540
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/48182
TRN_ID                          234027
ATT_ID                          643
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: 9217.05 27663 1106046
customer order: creation 164.90 353 19788
customer order: refuse 14.44 359 1733
order to supplier: creation 44.48 1306 5338
order to supplier: removal 3.28 102373 393
invoice (draft): creation 44.81 3508 5377
invoice (draft): removal 53.28 755 6393
invoice accept: apply 40.97 16783 4916
invoice accept: cancel 47.81 690 5737
customer reserve: creation 3845.21 160 461425
customer reserve: removal 4664.26 55 559711
realization accept: apply 81.20 178 9744
realization accept: cancel 87.32 89 10478
payment from customer: creation 57.10 117 6852
payment from customer: removal 6.01 108 721
payment to supplier: creation 47.18 129 5661
payment to supplier: removal 3.25 74 390
service: total inventory turnovers 4.20 1578 504
service: total monetary turnovers 6.57 33 788
service: aggregate perf. data 0.78 24266 93
service: refresh index statistics 0.03 400343 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 11-02-2021 01:28:55 to 11-02-2021 01:28:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2445
TEST_TIME 2 4447
TEST_TIME 3 4446
TEST_TIME 4 4374
TEST_TIME 5 5083
TEST_TIME 6 5474
TEST_TIME 7 5369
TEST_TIME 8 6183
TEST_TIME 9 6532
TEST_TIME 10 6412
TEST_TIME 11 6623
TEST_TIME 12 7167
TEST_TIME 13 7109
TEST_TIME 14 7355
TEST_TIME 15 8072
TEST_TIME 16 8397
TEST_TIME 17 8526
TEST_TIME 18 8818
TEST_TIME 19 8819
TEST_TIME 20 9124
TEST_TIME 21 9759
TEST_TIME 22 9927
TEST_TIME 23 9754
TEST_TIME 24 9815
TEST_TIME 25 10575
TEST_TIME 26 11568
TEST_TIME 27 11347
TEST_TIME 28 11415
TEST_TIME 29 11207
TEST_TIME 30 11046
TEST_TIME 31 10930
TEST_TIME 32 11016
TEST_TIME 33 10935
TEST_TIME 34 10728
TEST_TIME 35 10554
TEST_TIME 36 10452
TEST_TIME 37 10241
TEST_TIME 38 10264
TEST_TIME 39 10202
TEST_TIME 40 10233
TEST_TIME 41 10137
TEST_TIME 42 9993
TEST_TIME 43 9924
TEST_TIME 44 9824
TEST_TIME 45 9736
TEST_TIME 46 9902
TEST_TIME 47 9758
TEST_TIME 48 9652
TEST_TIME 49 9549
TEST_TIME 50 9535
TEST_TIME 51 9378
TEST_TIME 52 9329
TEST_TIME 53 9340
TEST_TIME 54 9341
TEST_TIME 55 9296
TEST_TIME 56 9330
TEST_TIME 57 9276
TEST_TIME 58 9313
TEST_TIME 59 9325
TEST_TIME 60 9418
TEST_TIME 61 9464
TEST_TIME 62 9578
TEST_TIME 63 9555
TEST_TIME 64 9582
TEST_TIME 65 9694
TEST_TIME 66 9710
TEST_TIME 67 9777
TEST_TIME 68 9660
TEST_TIME 69 9631
TEST_TIME 70 9558
TEST_TIME 71 9569
TEST_TIME 72 9542
TEST_TIME 73 9462
TEST_TIME 74 9424
TEST_TIME 75 9448
TEST_TIME 76 9496
TEST_TIME 77 9456
TEST_TIME 78 9470
TEST_TIME 79 9461
TEST_TIME 80 9414
TEST_TIME 81 9451
TEST_TIME 82 9469
TEST_TIME 83 9543
TEST_TIME 84 9572
TEST_TIME 85 9612
TEST_TIME 86 9595
TEST_TIME 87 9559
TEST_TIME 88 9469
TEST_TIME 89 9464
TEST_TIME 90 9426
TEST_TIME 91 9425
TEST_TIME 92 9439
TEST_TIME 93 9375
TEST_TIME 94 9316
TEST_TIME 95 9289
TEST_TIME 96 9301
TEST_TIME 97 9284
TEST_TIME 98 9318
TEST_TIME 99 9357
TEST_TIME 100 9361
TEST_TIME 101 9387
TEST_TIME 102 9339
TEST_TIME 103 9367
TEST_TIME 104 9377
TEST_TIME 105 9352
TEST_TIME 106 9464
TEST_TIME 107 9436
TEST_TIME 108 9495
TEST_TIME 109 9525
TEST_TIME 110 9488
TEST_TIME 111 9407
TEST_TIME 112 9382
TEST_TIME 113 9345
TEST_TIME 114 9371
TEST_TIME 115 9312
TEST_TIME 116 9297
TEST_TIME 117 9282
TEST_TIME 118 9264
TEST_TIME 119 9283
TEST_TIME 120 9220

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-02-2021 01:28:59 to 11-02-2021 01:29:02.

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 1531560 1531560 0 0.00 0 15956 6 0 0
doc_list_biud 1531560 1531560 0 0.00 0 42686 26 0 0
sp_add_invoice_to_stock 5010 4916 94 1.87 38 160934 16783 0 94
sp_cancel_adding_invoice 5737 5737 0 0.00 4 48800 691 0 0
sp_cancel_client_order 1733 1733 0 0.00 5 15169 359 0 0
sp_cancel_customer_reserve 559711 559711 0 0.00 1 21196 56 0 0
sp_cancel_pay_from_customer 721 721 0 0.00 3 9185 109 0 0
sp_cancel_pay_to_supplier 390 390 0 0.00 3 5488 75 0 0
sp_cancel_supplier_invoice 6402 6393 9 0.14 2 15614 755 0 9
sp_cancel_supplier_order 393 393 0 0.00 8 1033393 102374 0 0
sp_cancel_write_off 10478 10478 0 0.00 1 10686 90 0 0
sp_client_order 19788 19788 0 0.00 4 35623 353 0 0
sp_customer_reserve 461425 461425 0 0.00 0 57155 161 0 0
sp_fill_shopping_cart 30503 30503 0 0.00 1 20801 43 0 0
sp_fill_shopping_cart_clo_res 461422 461422 0 0.00 0 25119 13 0 0
sp_get_clo_for_invoice 4907 4907 0 0.00 0 43864 375 0 0
sp_kill_cost_storno 17326 17326 0 0.00 0 9178 51 0 0
sp_kill_qstorno_ret_qs2qd 1136686 1136686 0 0.00 0 21079 30 0 0
sp_kill_qty_storno 599091 599091 0 0.00 0 42686 65 0 0
sp_lock_selected_doc 20332 20332 0 0.00 0 10383 8 0 0
sp_make_cost_storno 27159 27159 0 0.00 0 10781 55 0 0
sp_multiply_rows_for_pdistr 27159 27159 0 0.00 0 9418 28 0 0
sp_multiply_rows_for_qdistr 19788 19788 0 0.00 0 34431 144 0 0
sp_pay_from_customer 6852 6852 0 0.00 4 15710 117 0 0
sp_pay_to_supplier 5661 5661 0 0.00 4 12465 129 0 0
sp_payment_common 12513 12513 0 0.00 1 14838 29 0 0
sp_qd_handle_on_cancel_clo 1733 1733 0 0.00 0 15151 326 0 0
sp_qd_handle_on_invoice_upd_sts 10639 10639 0 0.00 0 42685 324 0 0
sp_qd_handle_on_reserve_upd_sts 9744 9744 0 0.00 0 10428 56 0 0
sp_reserve_write_off 9744 9744 0 0.00 6 12692 178 0 0
sp_supplier_invoice 5377 5377 0 0.00 6 86119 3509 0 0
sp_supplier_order 5338 5338 0 0.00 6 26294 1306 0 0
srv_aggregate_perf_data 93 93 0 0.00 3389 441922 24267 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1195 174096 33382 0 0
srv_find_qd_qs_mism 1058515 1058515 0 0.00 0 12657 4 0 0
srv_make_invnt_saldo 504 504 0 0.00 49 123380 1579 0 0
srv_make_money_saldo 788 788 0 0.00 1 3508 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 274289 548232 400343 0 0
t$perf-abend:sp_add_invoice_to_stock 94 94 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4916 4916 0 0.00 0 18096 177 0 0
t$perf-norm:sp_cancel_adding_invoice 366 366 0 0.00 0 3916 98 0 0
t$perf-norm:sp_cancel_client_order 1733 1733 0 0.00 0 6347 18 0 0
t$perf-norm:sp_cancel_customer_reserve 685 685 0 0.00 0 1658 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 721 721 0 0.00 0 310 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 390 390 0 0.00 0 114 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 1887 15 0 0
t$perf-norm:sp_cancel_supplier_order 393 393 0 0.00 0 29585 1716 0 0
t$perf-norm:sp_cancel_write_off 985 985 0 0.00 0 7331 16 0 0
t$perf-norm:sp_client_order 19788 19788 0 0.00 0 10133 19 0 0
t$perf-norm:sp_customer_reserve 962 962 0 0.00 0 1444 6 0 0
t$perf-norm:sp_pay_from_customer 6852 6852 0 0.00 0 10690 11 0 0
t$perf-norm:sp_pay_to_supplier 5661 5661 0 0.00 0 5932 12 0 0
t$perf-norm:sp_reserve_write_off 9744 9744 0 0.00 0 11763 14 0 0
t$perf-norm:sp_supplier_invoice 5377 5377 0 0.00 0 9774 17 0 0
t$perf-norm:sp_supplier_order 5338 5338 0 0.00 0 8670 20 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 97 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 688 11 0 0
t$perf-norm:srv_make_invnt_saldo 504 504 0 0.00 0 1285 20 0 0
t$perf-norm:srv_make_money_saldo 788 788 0 0.00 0 2722 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 9992 9804 188 1.88 0 5396 21 0 188
v_all_customers 36192 36192 0 0.00 0 21 1 0 0
v_all_suppliers 29784 29784 0 0.00 0 141 1 0 0
v_all_wares 39576 39576 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 732 732 0 0.00 0 1003 8 0 0
v_cancel_client_order 3466 3466 0 0.00 0 3828 7 0 0
v_cancel_customer_prepayment 1442 1442 0 0.00 0 5307 10 0 0
v_cancel_customer_reserve 1370 1370 0 0.00 0 3244 9 0 0
v_cancel_payment_to_supplier 780 780 0 0.00 0 428 3 0 0
v_cancel_supplier_invoice 844 826 18 2.13 0 2220 17 0 18
v_cancel_supplier_order 786 786 0 0.00 0 2662 8 0 0
v_cancel_write_off 1970 1970 0 0.00 0 3553 17 0 0
v_max_id_clo_ord 5338 5338 0 0.00 0 2340 2 0 0
v_max_id_clo_res 962 962 0 0.00 0 914 7 0 0
v_max_id_ord_sup 5377 5377 0 0.00 0 2757 3 0 0
v_max_non_paid_invoice 1484 1484 0 0.00 0 531 3 0 0
v_max_non_paid_realizn 3617 3617 0 0.00 0 5078 6 0 0
v_min_id_clo_ord 5338 5338 0 0.00 0 2409 6 0 0
v_min_id_clo_res 962 962 0 0.00 0 4937 22 0 0
v_min_id_ord_sup 5377 5377 0 0.00 0 6907 9 0 0
v_min_non_paid_invoice 5661 5661 0 0.00 0 7851 19 0 0
v_min_non_paid_realizn 6852 6852 0 0.00 0 14833 17 0 0
v_our_firm 9854 9854 0 0.00 0 12 1 0 0
v_reserve_write_off 19488 19488 0 0.00 0 7723 8 0 0
x_lock_depdocs_on_canc_invoice 11717 11717 0 0.00 0 12742 113 0 0
x_lock_depdocs_on_canc_sup_ord 393 393 0 0.00 0 12755 386 0 0
x_make_qstorno_1000_1200 5338 5338 0 0.00 2 26282 1217 0 0
x_make_qstorno_1200_2000 5377 5377 0 0.00 4 85252 3357 0 0
x_make_qstorno_2100_3300 461425 461425 0 0.00 0 57153 145 0 0

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

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:22 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:28 7292 8192000000 10107008624 10396483584 859502192 9.495 71 59 117 0 882209408 2363776 20343440
22:57:44 12033 8192000000 10287041616 10595926016 1351631920 14.162 100 91 182 0 1384892288 3963312 29297056
22:58:06 35264 8192000000 10372398736 10689101824 1405380304 14.643 100 87 174 1 1438409216 5311856 27717056
22:58:53 20201 8192000000 10393197472 10714697728 1445279136 14.996 100 95 190 0 1486752848 11077008 30396704
22:59:23 25884 8192000000 10421222352 10746036224 1472821872 15.238 100 91 182 0 1509978352 7733712 29422768
22:59:57 23046 8192000000 10429348288 10757746688 1485081088 15.346 100 91 182 0 1523223856 8674400 29468368
23:00:29 24665 8192000000 10457637344 10789142528 1506882272 15.536 100 89 178 1 1544699648 9499136 28318240
23:01:05 17139 8192000000 10474395856 10809581568 1519152016 15.643 100 89 179 1 1557433264 10232672 28048576
23:01:32 15213 8192000000 10490611104 10836500480 1546890160 15.883 100 84 168 1 1583332144 10563104 25878880
23:01:56 13063 8192000000 10511688400 10859614208 1566264080 16.050 100 81 162 2 1602518800 11287440 24967280
23:02:23 17597 8192000000 10546601568 10901123072 1602116448 16.357 100 79 158 1 1637687248 11750560 23820240
23:02:50 9646 8192000000 10563721168 10917900288 1619249328 16.504 100 79 156 0 1654985216 12205808 23530080
23:03:08 12951 8192000000 10577053488 10937614336 1637591504 16.659 100 80 160 0 1674132576 12900304 23640768
23:03:28 10197 8192000000 10598633472 10963374080 1659915280 16.848 100 79 158 1 1696513392 12988128 23609984
23:03:47 12236 8192000000 10619802752 10987589632 1676935344 16.992 100 84 167 2 1714981872 13346640 24699888
23:04:08 8645 8192000000 10642880160 11011530752 1703182448 17.212 100 82 164 3 1740757728 13821792 23753488
23:04:24 9082 8192000000 10656614320 11027099648 1714106064 17.303 100 81 162 1 1751301744 13916848 23278832
23:04:42 6077 8192000000 10664696816 11037970432 1722987808 17.377 100 78 156 0 1758835808 13105024 22742976
23:04:55 7001 8192000000 10671819888 11044708352 1733872656 17.468 100 79 155 3 1768994336 12203168 22918512
23:05:08 5436 8192000000 10689088240 11062943744 1748810880 17.592 100 81 162 0 1785455840 13836160 22808800
23:05:20 4041 8192000000 10692534400 11070763008 1762215488 17.703 100 85 169 1 1799390864 13876352 23299024
23:05:32 4369 8192000000 10707988496 11088019456 1770324912 17.770 100 81 162 0 1806575280 13245056 23005312
23:05:43 3443 8192000000 10722520624 11100991488 1786472048 17.903 100 88 174 0 1823403776 12325840 24605888
23:05:53 3345 8192000000 10734274080 11111522304 1792580800 17.953 100 87 173 0 1830310512 13726528 24003184
23:06:04 3161 8192000000 10738775088 11119022080 1799210640 18.007 100 95 190 2 1839679600 14341472 26127488
23:06:14 3368 8192000000 10742000800 11122831360 1802318288 18.033 100 82 158 2 1837400192 12700448 22381456
23:06:23 3904 8192000000 10747448752 11129192448 1808336256 18.082 100 92 184 0 1847138928 13739392 25063280
23:06:41 5087 8192000000 10744487360 11128492032 1808376032 18.083 100 90 179 0 1848352960 14781616 25195312
23:06:53 2340 8192000000 10763843616 11149606912 1820213888 18.179 100 92 184 0 1861345280 15860368 25271024
23:07:02 1833 8192000000 10771442480 11156373504 1831039280 18.268 100 92 180 0 1872168448 15194128 25935040
23:07:10 2069 8192000000 10783433168 11166416896 1835853664 18.307 100 87 174 0 1878143936 18086592 24203680
23:07:19 1740 8192000000 10782956240 11172380672 1840739888 18.347 100 93 188 0 1881622832 13820240 27062704
23:07:27 2237 8192000000 10787652336 11172884480 1847150144 18.399 100 93 185 0 1885837568 11588736 27098688
23:07:36 2594 8192000000 10791592032 11177140224 1851249440 18.432 100 93 187 0 1889481184 11726432 26505312
23:07:46 2448 8192000000 10800141216 11185623040 1855301536 18.465 100 91 182 0 1894311456 13379232 25630688
23:07:55 1694 8192000000 10799653456 11187048448 1856471248 18.475 100 86 170 0 1893733008 13440000 23821760
23:08:03 2682 8192000000 10808769568 11195031552 1860693840 18.509 100 93 184 1 1900739616 13338208 26707568
23:08:12 2047 8192000000 10812064640 11198009344 1867815056 18.567 100 93 185 2 1908116352 13504624 26796672
23:08:20 1279 8192000000 10808747424 11197534208 1872086192 18.601 100 95 189 4 1911281488 13111792 26083504
23:08:28 2191 8192000000 10816139328 11208151040 1871987920 18.600 100 87 175 0 1910680688 13341536 25351232
23:08:36 1286 8192000000 10822172304 11209392128 1874846464 18.623 100 95 190 1 1916658672 14460912 27351296
23:08:44 20030 8192000000 10796882144 11205349376 1868225056 18.570 100 62 124 0 1898414432 13062208 17127168
23:09:29 1323 8192000000 10824200432 11213660160 1875189408 18.626 100 83 164 1 1908256768 9412016 23655344
23:09:37 5066 8192000000 10801703184 11216138240 1881107520 18.674 100 62 125 2 1908687968 10003072 17577376
23:09:50 6163 8192000000 10785783696 11211763712 1874762192 18.623 100 34 68 0 1892980016 8880544 9337280
23:10:06 5176 8192000000 10796818048 11217764352 1879077600 18.658 100 38 76 2 1897372736 8007664 10287472
23:10:18 3919 8192000000 10814338192 11222216704 1883482320 18.693 100 43 86 1 1904555264 8850208 12222736
23:10:28 5381 8192000000 10802862496 11226075136 1884347536 18.700 100 37 75 1 1903013072 8289328 10376208
23:10:41 7027 8192000000 10797675824 11220717568 1883721984 18.695 100 22 44 2 1896083456 6512592 5848880
23:10:54 6513 8192000000 10809301456 11227463680 1884571408 18.702 100 29 59 2 1899309024 6549392 8188224
23:11:07 5187 8192000000 10794182048 11223269376 1885030800 18.706 100 30 60 1 1900701312 7236592 8433920
23:11:22 16001 8192000000 10805175952 11223576576 1889486432 18.742 100 33 66 0 1904681264 6246096 8948736
23:11:44 48505 8192000000 10795014592 11235901440 1890853376 18.753 100 35 70 0 1910226720 9669232 9704112
23:12:42 8823 8192000000 10807837680 11239378944 1888254672 18.732 100 20 40 1 1903295376 9502480 5538224
23:12:59 6093 8192000000 10806809584 11236671488 1893673232 18.775 100 32 64 0 1909968240 7547664 8747344
23:13:11 6631 8192000000 10805909600 11237597184 1895779040 18.792 100 35 70 1 1913583648 7974624 9829984
23:13:24 10353 8192000000 10814831904 11244838912 1900194496 18.828 100 32 64 1 1919705040 10725136 8785408
23:13:41 6688 8192000000 10805320112 11239895040 1898238208 18.812 100 33 66 0 1914026144 6377184 9410752
23:13:54 7019 8192000000 10804253664 11243184128 1899967552 18.826 100 33 66 2 1916860288 7188224 9704512
23:14:10 5271 8192000000 10807858624 11241549824 1898831984 18.817 100 29 58 3 1912037712 5441824 7763904
23:14:23 5781 8192000000 10813800096 11246006272 1900871616 18.833 100 22 44 0 1913942464 6550112 6520736
23:14:37 7459 8192000000 10808059280 11243581440 1898357728 18.813 100 13 26 1 1907506160 5362992 3785440
23:15:02 6314 8192000000 10816170304 11250950144 1907702384 18.888 100 31 62 0 1923329584 6714864 8912336
23:15:19 9270 8192000000 10818285360 11253096448 1910295008 18.909 100 22 43 2 1921085248 5380304 5409936
23:15:36 10901 8192000000 10820529520 11254784000 1907818640 18.889 100 23 46 0 1919979600 5768752 6392208
23:15:57 16396 8192000000 10805069472 11237138432 1885165424 18.707 99 28 56 1 1897952128 5346016 7440688
23:16:21 57114 8192000000 10784751216 11219259392 1840212016 18.343 97 34 68 0 1856252032 6104848 9935168
23:17:31 10648 8192000000 10794066960 11217637376 1857882112 18.486 99 23 46 3 1874052784 9956528 6214144
23:17:49 7286 8192000000 10792097776 11211309056 1844827776 18.380 98 30 58 1 1859241312 6477600 7935936
23:18:04 3547 8192000000 10793135440 11217649664 1863608720 18.533 99 46 92 1 1884729104 7968048 13152336
23:18:18 5961 8192000000 10766015840 11191590912 1819744912 18.176 97 21 43 3 1831647888 6320272 5582704
23:18:31 6858 8192000000 10773236480 11200335872 1845747488 18.388 99 30 60 1 1859996688 5666448 8582752
23:18:45 12004 8192000000 10720597888 11137970176 1690986768 17.110 91 23 44 2 1703065776 5475264 6603744
23:19:03 5393 8192000000 10733280880 11149893632 1775717360 17.814 97 27 54 0 1789757936 6394960 7645616
23:19:15 10021 8192000000 10733195600 11155828736 1755201760 17.645 96 16 32 2 1764835264 4655280 4978224
23:19:32 12693 8192000000 10704551344 11124793344 1735298560 17.480 95 16 32 1 1746337248 5610608 5428080
23:19:51 8589 8192000000 10707448688 11123798016 1743846800 17.551 96 25 50 0 1756738176 5874064 7017312
23:20:07 13332 8192000000 10711722432 11122716672 1719963408 17.352 95 15 30 0 1729097360 5529472 3604480
23:20:27 9362 8192000000 10699386112 11114762240 1760368160 17.687 98 12 25 0 1768764096 4571824 3824112
23:20:42 9087 8192000000 10729445088 11130978304 1771720784 17.781 98 39 76 0 1788461312 5896800 10843728
23:21:00 61082 8192000000 10708564928 11119656960 1719010192 17.344 95 33 66 0 1734473616 5924416 9539008
23:22:10 6491 8192000000 10689329584 11113644032 1786708432 17.905 100 19 38 2 1802007808 9983728 5315648
23:22:26 3408 8192000000 10710673152 11122864128 1781049088 17.858 99 37 75 3 1798687008 6387536 11250384
23:22:36 7577 8192000000 10714212160 11126378496 1771154992 17.777 98 31 61 0 1786430864 6384096 8891776
23:22:52 8844 8192000000 10709133392 11126624256 1795930880 17.981 100 27 54 0 1810166160 6735264 7500016
23:23:08 8529 8192000000 10725787920 11147644928 1811827280 18.111 100 29 57 4 1826121856 6659712 7634864
23:23:25 4990 8192000000 10736551280 11153268736 1819070256 18.170 100 18 34 2 1829541984 5802320 4669408
23:23:37 4161 8192000000 10745327424 11160748032 1826549488 18.231 100 29 58 2 1841305280 6474688 8281104
23:23:49 10354 8192000000 10734490960 11158757376 1814434832 18.132 99 24 48 1 1826853808 5385312 7033664
23:24:08 7167 8192000000 10742486512 11170385920 1833054992 18.284 100 13 26 0 1842577232 5913248 3608992
23:24:21 10714 8192000000 10754543472 11181555712 1842969120 18.365 100 18 34 3 1852903232 5318544 4615568
23:24:39 13611 8192000000 10769287600 11190247424 1848106320 18.407 100 24 48 1 1865379968 9962544 7311104
23:25:01 11934 8192000000 10770421152 11193679872 1854082544 18.455 100 28 56 0 1868102896 5554352 8466000
23:25:21 12978 8192000000 10774334784 11195744256 1853606608 18.451 100 17 34 2 1863705344 5417008 4681728
23:25:44 12602 8192000000 10785870160 11202686976 1857992272 18.487 100 27 54 0 1870191424 4928320 7270832
23:26:03 45488 8192000000 10785357408 11201961984 1845304096 18.384 99 25 50 1 1858009024 5640608 7064320
23:27:07 70062 8192000000 10819369328 11240214528 1888667696 18.735 100 37 68 2 1910646288 12830080 9148512
23:28:33 32095 8192000000 10868518304 11278667776 1918869504 18.978 100 56 111 1 1948625040 13890240 15865296
23:29:11 20000 8192000000 10864515520 11284799488 1932183552 19.084 100 58 116 2 1964552288 15653104 16715632
23:29:42 9046 8192000000 10851387856 11276431360 1913599248 18.936 99 46 92 0 1941596736 15006192 12991296
23:30:07 21184 8192000000 10869648992 11295555584 1932753152 19.089 100 49 96 1 1961872752 15275472 13844128
23:30:39 42554 8192000000 10883685744 11313127424 1943830128 19.177 100 36 72 1 1971238448 17195776 10212544
23:31:28 12320 8192000000 10896805776 11322818560 1954210736 19.260 100 46 92 1 1987268752 19645056 13412960
23:31:55 22957 8192000000 10895523504 11322642432 1947910208 19.210 100 53 105 2 1986575568 22983648 15681712
23:32:29 11855 8192000000 10906913776 11328479232 1953388448 19.253 100 50 99 0 1995102224 26510608 15203168
23:32:48 8757 8192000000 10907861424 11330056192 1957911904 19.289 100 51 100 2 1999027664 26562832 14552928
23:33:06 5170 8192000000 10918320768 11342159872 1965308688 19.348 100 55 108 1 2008206960 26243216 16655056
23:33:19 4406 8192000000 10924267600 11347464192 1969500544 19.381 100 61 122 0 2015293120 27658208 18134368
23:33:32 5633 8192000000 10926131440 11348148224 1971248128 19.395 100 58 116 0 2014333440 26019648 17065664
23:33:46 12205 8192000000 10928579136 11350605824 1974515440 19.421 100 56 112 1 2017310464 26417792 16377232
23:34:08 5305 8192000000 10929847664 11354132480 1976296208 19.435 100 66 129 3 2022533936 27116576 19121152
23:34:34 10071 8192000000 10930259824 11358638080 1979358576 19.460 100 65 129 1 2026423696 28349616 18715504
23:34:54 12974 8192000000 10932357936 11355848704 1972408624 19.405 100 61 118 2 2019542784 29468176 17665984
23:35:18 7699 8192000000 10930531280 11359846400 1974186064 19.419 100 55 108 0 2021363936 30316848 16861024
23:35:33 2418 8192000000 10943351312 11364798464 1983800640 19.495 100 77 152 2 2035033552 28847536 22385376
23:35:42 5709 8192000000 10945709232 11366621184 1985050608 19.505 100 63 126 0 2033514448 29856992 18606848
23:35:54 3279 8192000000 10945539600 11364294656 1980605376 19.469 100 70 136 2 2032253808 31054448 20593984
23:36:06 1849 8192000000 10946949600 11368980480 1983352960 19.491 100 69 137 2 2033615584 29735552 20527072
23:36:16 2909 8192000000 10952932640 11376336896 1989211456 19.538 100 72 142 0 2038064592 28659088 20194048
23:36:28 17970 8192000000 10937133072 11366236160 1971966496 19.401 99 59 118 3 2017978416 28545456 17466464
23:37:11 17345 8192000000 10929297184 11365810176 1959166672 19.299 99 49 98 1 2005927504 31498928 15261904
23:37:38 7385 8192000000 10949490608 11372670976 1981749888 19.479 100 53 106 2 2029932944 31373136 16809920
23:38:02 6720 8192000000 10949058096 11389669376 1989410544 19.539 100 48 96 0 2043026384 37749728 15866112
23:38:16 6441 8192000000 10959526928 11389067264 1990257328 19.546 100 53 106 1 2042753760 35636016 16860416
23:38:32 4845 8192000000 10970245648 11398385664 1996400592 19.594 100 67 132 3 2056799632 39949168 20449872
23:38:45 1574 8192000000 10991377424 11410870272 2007472864 19.682 100 80 161 0 2073917088 42052192 24392032
23:38:54 4590 8192000000 10983296624 11405672448 2000826768 19.629 100 70 140 0 2064759328 42448304 21484256
23:39:06 5585 8192000000 10985914176 11402870784 1996187488 19.593 100 84 168 1 2065876960 43941616 25747856
23:39:19 2158 8192000000 10987576976 11407560704 1985415472 19.508 99 86 172 0 2055588576 43895504 26277600
23:39:28 3090 8192000000 10984583968 11405328384 1998158288 19.608 100 75 147 1 2062478256 41761104 22558864
23:39:38 1695 8192000000 10994170784 11411906560 2003775536 19.652 100 88 174 2 2073061632 42989472 26296624
23:39:46 3765 8192000000 10982852784 11404087296 2000684848 19.628 100 87 175 2 2068985840 42010768 26290224
23:39:58 6205 8192000000 10977942176 11406442496 1981716800 19.478 99 70 140 2 2044580960 41848096 21016064
23:40:13 2744 8192000000 10987356720 11406716928 2002176944 19.640 100 89 177 2 2070164896 42116736 25871216
23:40:23 2291 8192000000 10988874368 11411308544 2000661440 19.628 100 70 140 1 2066931664 45403600 20866624
23:40:34 1292 8192000000 10998157552 11417141248 2007968048 19.686 100 79 156 1 2080276608 48540704 23767856
23:40:42 3507 8192000000 11010535312 11429761024 2012121280 19.718 100 82 163 1 2087476464 50290320 25064864
23:40:53 1882 8192000000 11009682352 11429437440 2016710160 19.754 100 80 158 2 2091158096 50481280 23966656
23:41:01 3290 8192000000 10999807664 11421298688 1995190384 19.585 99 82 164 0 2070394752 50356016 24848352
23:41:12 6045 8192000000 11005764400 11430432768 2008583984 19.690 100 77 154 0 2088984608 55913536 24487088
23:41:25 1417 8192000000 11004716320 11421233152 2003113648 19.647 100 89 174 1 2082403232 51927136 27362448
23:41:34 1192 8192000000 11000031728 11422134272 2001268016 19.633 100 90 181 1 2082638224 53430512 27939696
23:41:43 2463 8192000000 10999789440 11414732800 1998649696 19.612 100 86 172 1 2080877968 55499312 26728960
23:41:53 2402 8192000000 11003832160 11419504640 1989104080 19.537 99 94 188 3 2073796928 56202624 28490224
23:42:04 2227 8192000000 11013249088 11432034304 2009378080 19.697 100 86 170 1 2091775376 54957152 27440144
23:42:13 2142 8192000000 10957063888 11373400064 1961357008 19.317 99 83 166 2 2038460144 51042400 26060736
23:42:26 4213 8192000000 10978957392 11400810496 1985730672 19.510 100 74 144 2 2058654240 50869840 22053728
23:42:38 6692 8192000000 10960423216 11390140416 1976565632 19.437 100 60 118 0 2045319936 49617488 19136816
23:42:52 3769 8192000000 10974345200 11400597504 1982781248 19.487 100 59 117 0 2050151088 48642064 18727776
23:43:02 5789 8192000000 10933537584 11361595392 1930973440 19.075 97 61 120 1 1999937488 49950032 19014016
23:43:18 6522 8192000000 10964229088 11397648384 1960737648 19.312 99 65 130 4 2031109712 49309840 21062224
23:43:32 6790 8192000000 10955518304 11393556480 1979415872 19.460 100 48 96 0 2039766976 44108592 16242512
23:43:50 11522 8192000000 10974730288 11409014784 1987834928 19.527 100 57 114 1 2055463760 48960144 18668688
23:44:11 11006 8192000000 10962169744 11403055104 1968424448 19.373 99 46 92 1 2027354816 43631120 15299248
23:44:29 3469 8192000000 10980065984 11409727488 1998075824 19.608 100 71 140 1 2068077424 46979312 23022288
23:44:40 3086 8192000000 10962216992 11380129792 1955421952 19.270 99 80 158 0 2028797552 47561984 25813616
23:44:50 3356 8192000000 10962218928 11374809088 1960346032 19.309 100 83 166 2 2036727792 49949904 26431856
23:45:02 4820 8192000000 10959320624 11381473280 1965647824 19.351 100 74 149 2 2041354240 52016848 23689568
23:45:15 6296 8192000000 10967464928 11394465792 1972118864 19.402 100 63 126 0 2048663232 56544400 19999968
23:45:30 1836 8192000000 10964095760 11379204096 1960309728 19.309 99 76 153 0 2041583200 56625120 24648352
23:45:38 4332 8192000000 10948318368 11382878208 1946084016 19.195 99 59 117 0 2022658016 57744608 18829392
23:45:51 8366 8192000000 10935243184 11365449728 1929224416 19.061 98 49 98 0 1997972176 52664160 16083600
23:46:09 3439 8192000000 10940960848 11371663360 1954316416 19.261 100 51 100 1 2022429696 51375888 16737392
23:46:21 4366 8192000000 10949410144 11375169536 1960635920 19.311 100 60 119 3 2030127600 50143120 19348560
23:46:36 4669 8192000000 10965069088 11384373248 1966998320 19.362 100 62 124 3 2039020960 52173008 19849632
23:46:48 3323 8192000000 10985140640 11392856064 1973756592 19.415 100 87 175 2 2055647072 53343264 28547216
23:47:01 2964 8192000000 10952043280 11379945472 1957066320 19.283 100 62 124 1 2034134400 57033376 20034704
23:47:19 7685 8192000000 10909723440 11340009472 1925129808 19.028 100 41 78 1 1987298240 48835408 13333024
23:47:39 2422 8192000000 10919181744 11335929856 1921982352 19.003 99 65 128 2 1994333392 51320704 21030336
23:47:51 7988 8192000000 10910881808 11345723392 1921801232 19.001 99 53 106 1 1990633632 51903184 16929216
23:48:07 9713 8192000000 10908145024 11352088576 1940081008 19.147 100 36 71 0 1996222864 43755936 12385920
23:48:26 9921 8192000000 10914031792 11354583040 1947868688 19.209 100 28 56 0 1997695664 40657680 9169296
23:48:53 21775 8192000000 10895979632 11337142272 1890416944 18.749 97 28 56 0 1940694112 40992672 9284496
23:49:31 17531 8192000000 10898624880 11356446720 1936317376 19.117 100 22 44 0 1987590384 43718752 7554256
23:50:04 8966 8192000000 10903531920 11356770304 1938693008 19.136 100 21 42 0 1987731840 41656256 7382576
23:50:27 22456 8192000000 10906345168 11356831744 1910009344 18.907 98 28 56 1 1965503920 45248144 10246432
23:51:07 13867 8192000000 10894835824 11336372224 1890281744 18.748 98 23 46 1 1950603648 51773680 8548224
23:51:27 17259 8192000000 10893451216 11334172672 1901135136 18.835 99 24 48 1 1961947696 52008576 8803984
23:51:51 30001 8192000000 10902938880 11350224896 1893239632 18.772 98 42 83 3 1964257552 56944880 14073040
23:52:33 23148 8192000000 10876382480 11332599808 1901403680 18.838 99 26 52 1 1950244720 40204416 8636624
23:53:02 12440 8192000000 10882216160 11330035712 1917207392 18.964 100 19 38 0 1968984528 45584704 6192432
23:53:25 29125 8192000000 10871847600 11339157504 1913192048 18.932 99 16 32 1 1948563248 30540576 4830624
23:54:01 24051 8192000000 10865705504 11316473856 1911690464 18.920 99 23 46 2 1936168288 17968608 6509216
23:54:43 46972 8192000000 10847608480 11321462784 1908200544 18.892 99 11 22 1 1926287456 15039648 3047264
23:55:48 52177 8192000000 10871981360 11305345024 1895783104 18.792 98 46 89 1 1925216912 16673472 12760336
23:56:54 46838 8192000000 10853589040 11302981632 1911782000 18.921 100 26 48 3 1932627776 13621536 7224240
23:57:48 65953 8192000000 10857423920 11316850688 1915493360 18.951 99 9 18 0 1936684448 18931648 2259440
23:59:18 48729 8192000000 10871620736 11328663552 1939799872 19.145 100 12 22 1 1956417328 13495904 3121552
00:00:19 111919 8192000000 10872331104 11324063744 1853613808 18.451 95 18 38 1 1867179872 9268944 4297120
00:02:20 54529 8192000000 10873342640 11331997696 1945131792 19.188 100 14 28 1 1964842368 15806016 3904560
00:03:24 126421 8192000000 10895202512 11354714112 1956927216 19.282 100 25 50 2 1977987200 13157776 7902208
00:05:40 42327 8192000000 10899868224 11362832384 1953440704 19.254 99 36 70 1 1973150992 9416640 10293648
00:06:29 93359 8192000000 10918886704 11388190720 1976414880 19.436 100 15 30 1 1998828704 17201648 5212176
00:08:10 62989 8192000000 10915784992 11401187328 1990532912 19.548 100 8 16 1 2012395584 19552688 2309984
00:09:55 31712 8192000000 10913645056 11379470336 1987158752 19.521 100 24 46 2 2004806144 10221040 7426352
00:10:33 35765 8192000000 10920242288 11391250432 1992439504 19.563 100 19 38 0 2013366352 15490352 5436496
00:11:18 30534 8192000000 10954641472 11396464640 1999543824 19.619 100 39 79 0 2024314784 11711728 13059232
00:12:01 41702 8192000000 10931716512 11400052736 2001454448 19.634 100 33 66 3 2024980688 14264768 9261472
00:12:51 37503 8192000000 10909238640 11387535360 1987754800 19.526 100 14 28 0 2007552976 15590656 4207520
00:14:04 82819 8192000000 10901750960 11380359168 1972631392 19.406 99 17 34 1 1985970624 7779328 5559904
00:16:01 62891 8192000000 10903399472 11378057216 1952366992 19.245 98 18 37 0 1969607216 11952592 5287632
00:17:14 56799 8192000000 10900913872 11385184256 1989250528 19.538 100 14 28 0 2001395856 8658048 3487280
00:18:51 71367 8192000000 10907920880 11389276160 1971593328 19.398 99 8 17 0 1985337328 11455296 2288704
00:20:08 63216 8192000000 10916454144 11394387968 1992884816 19.567 100 23 46 0 2009096864 9496736 6715312
00:21:18 61678 8192000000 10939627072 11399712768 1981066416 19.473 99 12 24 1 1992285152 7621904 3596832
00:22:27 22284 8192000000 10906226848 11382480896 1961799696 19.320 98 17 34 1 1975291456 7802064 5689696
00:22:57 18655 8192000000 10907021376 11381383168 1953544016 19.255 98 28 56 1 1974287024 12848640 7894368
00:23:26 94426 8192000000 10900437456 11374153728 1882757600 18.687 95 11 22 1 1901877552 16073440 3046512
00:25:11 68686 8192000000 10907503056 11374620672 1947804208 19.209 98 22 44 0 1973073968 19061296 6208464
00:26:31 67443 8192000000 10899323456 11378487296 1941567824 19.159 98 17 34 2 1972481360 25264976 5648560
00:27:45 63032 8192000000 10919602384 11395637248 1963761968 19.336 99 20 40 0 1988907744 19261264 5884512
00:29:02 86451 8192000000 10900383392 11380183040 1939340896 19.141 98 10 20 0 1963999936 21772224 2886816
00:30:41 61437 8192000000 10898483728 11364270080 1889896320 18.745 95 24 48 1 1908781312 12361936 6523056
00:31:58 80598 8192000000 10894709008 11373248512 1939544016 19.143 98 17 34 2 1961868224 17671216 4652992
00:33:27 56444 8192000000 10860097440 11318894592 1805034784 18.055 92 10 20 1 1817474544 10239984 2199776
00:34:30 81319 8192000000 10834168432 11262226432 1861600480 18.516 96 34 65 3 1880175088 9918096 8656512
00:35:57 26364 8192000000 10862301792 11316199424 1914251808 18.941 99 40 79 4 1935212432 10015888 10944736
00:36:40 58468 8192000000 10825971872 11296710656 1873037024 18.609 97 13 26 0 1885741280 9276608 3427648
00:37:56 61701 8192000000 10834332000 11314073600 1863925280 18.535 97 12 24 0 1875947456 8749552 3272624
00:39:05 57605 8192000000 10842710000 11319054336 1899800160 18.825 99 2 4 0 1911971104 11826912 344032
00:40:08 22857 8192000000 10880818384 11321647104 1917012720 18.963 99 41 82 1 1934923888 5886784 12024384
00:40:42 35093 8192000000 10861905504 11324846080 1924161696 19.020 99 38 76 0 1944458352 9948544 10348112
00:41:30 72368 8192000000 10843322896 11297435648 1853192000 18.448 96 28 56 0 1874173632 12477184 8504448
00:42:53 83191 8192000000 10853114368 11328385024 1907048528 18.883 99 14 27 0 1924819808 13853344 3917936
00:44:23 78563 8192000000 10850943856 11295817728 1815868912 18.144 94 21 40 0 1832165504 11085280 5211312
00:45:53 79854 8192000000 10857837488 11304173568 1836565632 18.313 95 29 55 1 1854104960 8998304 8541024
00:47:19 61358 8192000000 10854730448 11320774656 1902098304 18.843 99 27 53 0 1920013168 10337824 7577040
00:48:31 62749 8192000000 10870451728 11315507200 1867844400 18.567 97 20 40 0 1883656528 9881216 5930912
00:49:45 25467 8192000000 10860609088 11326742528 1908747248 18.897 99 30 60 3 1932384544 14892272 8745024
00:50:26 63721 8192000000 10859514304 11335733248 1891902896 18.761 98 16 32 2 1909912704 13917632 4092176
00:51:40 174095 8192000000 10859581296 11323125760 1832621808 18.281 95 3 6 0 1847750656 14378720 750128
00:54:41 87883 8192000000 10883339392 11324416000 1922295872 19.005 99 24 48 2 1941510080 12185072 7029136
00:56:28 73579 8192000000 10879100224 11333812224 1910299280 18.909 98 29 57 1 1932256368 12870848 9086240
00:57:59 31315 8192000000 10882729296 11336744960 1913787408 18.937 98 39 78 0 1937777616 13980768 10009440
00:58:38 22307 8192000000 10873112128 11340275712 1944467920 19.182 100 34 68 0 1969864192 15905200 9491072
00:59:06 51372 8192000000 10866709808 11344207872 1925323728 19.029 99 9 18 0 1941193360 13794768 2074864
01:00:08 41745 8192000000 10859410800 11339505664 1927279760 19.045 99 3 6 0 1939197168 11437936 479472
01:01:05 19590 8192000000 10857592208 11333054464 1926982128 19.043 99 7 14 0 1940056432 11264400 1809904
01:01:31 19365 8192000000 10867591264 11335294976 1945595984 19.191 100 8 16 0 1959269664 11806112 1867568
01:01:58 64466 8192000000 10867497840 11339108352 1914261824 18.941 98 13 26 0 1929000528 10980528 3758176
01:03:22 43307 8192000000 10876456752 11343273984 1913373824 18.934 98 9 18 0 1927553888 11824672 2355392
01:04:17 64958 8192000000 10895535472 11373608960 1961230784 19.316 100 18 36 1 1978759856 12008352 5520720
01:05:38 44552 8192000000 10892615904 11366920192 1948402208 19.214 99 19 38 0 1966649312 12568464 5678640
01:07:00 50894 8192000000 10870768592 11328442368 1896384688 18.797 96 27 55 1 1915027440 10772560 7870192
01:08:25 53253 8192000000 10894524416 11363823616 1965510144 19.350 100 26 51 2 1984946000 11825008 7610848
01:09:29 56333 8192000000 10891687136 11359539200 1937513936 19.127 98 29 58 0 1956599472 11178800 7906736
01:11:57 93290 8192000000 10911664640 11395497984 1964759072 19.344 99 6 12 1 1985535696 18918800 1857824
01:13:41 124726 8192000000 10906851024 11387764736 1908613520 18.896 96 5 10 0 1922874944 13356960 904464
01:15:52 112714 8192000000 10906917712 11386355712 1926660480 19.040 97 9 18 0 1941871360 12745872 2465008
01:17:51 110782 8192000000 10900158592 11376979968 1945226176 19.188 98 22 44 0 1958406400 6803024 6377200
01:19:57 55884 8192000000 10919599632 11391049728 1969646720 19.383 99 27 53 1 1990941936 13213728 8081488
01:21:02 52617 8192000000 10894095152 11374673920 1949291920 19.221 99 10 20 1 1964651440 12472352 2887168
01:22:22 35290 8192000000 10833618096 11303567360 1886107040 18.714 96 15 30 0 1904762832 14260768 4395024
01:23:18 51432 8192000000 10859977552 11330613248 1895888944 18.793 97 25 50 0 1914938976 11624560 7425472
01:24:23 97235 8192000000 10885872240 11358203904 1923887744 19.018 98 20 40 2 1944377120 14415840 6073536
01:26:06 67840 8192000000 10881754784 11370278912 1938187616 19.132 99 10 19 1 1957314800 16258112 2869072

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 11-02-2021 01:29:09 to 11-02-2021 01:29:41.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 94 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          231212
MON$OLDEST_ACTIVE               234160
MON$OLDEST_SNAPSHOT             234160
MON$NEXT_TRANSACTION            234160
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                       2025760
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:201: 
:202: mscs-test-161.budzdorov.ru    Thu Feb 11 01:27:34 2021
:203:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:204: 
--- end of diff output ---

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

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