Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 05.01.2021 16: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 17326372 kB
MemAvailable 31372900 kB
Buffers 0 kB
Cached 14339080 kB
SwapCached 4864 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-01-05 16:27:13
DTS_END                         2021-01-05 16:27:13.4640
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/55208
TRN_ID                          241015
ATT_ID                          704
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: 9271.66 23412 1112599
customer order: creation 174.32 365 20918
customer order: refuse 14.69 317 1763
order to supplier: creation 46.22 1251 5546
order to supplier: removal 3.48 107165 417
invoice (draft): creation 46.74 3264 5609
invoice (draft): removal 52.71 803 6325
invoice accept: apply 41.37 17664 4964
invoice accept: cancel 48.04 833 5765
customer reserve: creation 3826.91 174 459229
customer reserve: removal 4711.50 63 565380
realization accept: apply 84.49 173 10139
realization accept: cancel 90.21 118 10825
payment from customer: creation 59.03 114 7083
payment from customer: removal 5.75 66 690
payment to supplier: creation 49.66 133 5959
payment to supplier: removal 3.73 101 447
service: total inventory turnovers 5.02 1179 602
service: total monetary turnovers 6.83 32 820
service: aggregate perf. data 0.95 18246 114
service: refresh index statistics 0.03 316181 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-01-2021 16:28:35 to 05-01-2021 16:28:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4763
TEST_TIME 2 5506
TEST_TIME 3 5163
TEST_TIME 4 5243
TEST_TIME 5 5724
TEST_TIME 6 5334
TEST_TIME 7 5456
TEST_TIME 8 5480
TEST_TIME 9 5273
TEST_TIME 10 5458
TEST_TIME 11 5583
TEST_TIME 12 5830
TEST_TIME 13 6423
TEST_TIME 14 6500
TEST_TIME 15 6815
TEST_TIME 16 7036
TEST_TIME 17 7531
TEST_TIME 18 8049
TEST_TIME 19 8207
TEST_TIME 20 8225
TEST_TIME 21 8478
TEST_TIME 22 8769
TEST_TIME 23 8757
TEST_TIME 24 9112
TEST_TIME 25 9183
TEST_TIME 26 10012
TEST_TIME 27 10752
TEST_TIME 28 11223
TEST_TIME 29 10899
TEST_TIME 30 10821
TEST_TIME 31 10619
TEST_TIME 32 10859
TEST_TIME 33 10704
TEST_TIME 34 10543
TEST_TIME 35 10504
TEST_TIME 36 10359
TEST_TIME 37 10236
TEST_TIME 38 10138
TEST_TIME 39 10031
TEST_TIME 40 9914
TEST_TIME 41 9812
TEST_TIME 42 9819
TEST_TIME 43 9844
TEST_TIME 44 9792
TEST_TIME 45 9691
TEST_TIME 46 9604
TEST_TIME 47 9491
TEST_TIME 48 9471
TEST_TIME 49 9444
TEST_TIME 50 9659
TEST_TIME 51 9710
TEST_TIME 52 9654
TEST_TIME 53 9652
TEST_TIME 54 9629
TEST_TIME 55 9724
TEST_TIME 56 9814
TEST_TIME 57 9834
TEST_TIME 58 9839
TEST_TIME 59 9784
TEST_TIME 60 9847
TEST_TIME 61 9921
TEST_TIME 62 9911
TEST_TIME 63 9919
TEST_TIME 64 9791
TEST_TIME 65 9690
TEST_TIME 66 9672
TEST_TIME 67 9640
TEST_TIME 68 9638
TEST_TIME 69 9586
TEST_TIME 70 9529
TEST_TIME 71 9481
TEST_TIME 72 9397
TEST_TIME 73 9377
TEST_TIME 74 9382
TEST_TIME 75 9374
TEST_TIME 76 9412
TEST_TIME 77 9429
TEST_TIME 78 9490
TEST_TIME 79 9478
TEST_TIME 80 9446
TEST_TIME 81 9479
TEST_TIME 82 9470
TEST_TIME 83 9487
TEST_TIME 84 9571
TEST_TIME 85 9619
TEST_TIME 86 9606
TEST_TIME 87 9512
TEST_TIME 88 9439
TEST_TIME 89 9409
TEST_TIME 90 9417
TEST_TIME 91 9349
TEST_TIME 92 9336
TEST_TIME 93 9379
TEST_TIME 94 9412
TEST_TIME 95 9384
TEST_TIME 96 9391
TEST_TIME 97 9369
TEST_TIME 98 9396
TEST_TIME 99 9407
TEST_TIME 100 9427
TEST_TIME 101 9411
TEST_TIME 102 9448
TEST_TIME 103 9473
TEST_TIME 104 9487
TEST_TIME 105 9464
TEST_TIME 106 9487
TEST_TIME 107 9524
TEST_TIME 108 9497
TEST_TIME 109 9441
TEST_TIME 110 9400
TEST_TIME 111 9401
TEST_TIME 112 9361
TEST_TIME 113 9350
TEST_TIME 114 9349
TEST_TIME 115 9358
TEST_TIME 116 9349
TEST_TIME 117 9335
TEST_TIME 118 9322
TEST_TIME 119 9333
TEST_TIME 120 9276

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-01-2021 16:28:38 to 05-01-2021 16:28:42.

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 1538792 1538792 0 0.00 0 24172 6 0 0
doc_list_biud 1538789 1538789 0 0.00 0 47827 29 0 0
sp_add_invoice_to_stock 5102 4964 138 2.70 47 186242 17665 0 138
sp_cancel_adding_invoice 5765 5765 0 0.00 5 56230 834 0 0
sp_cancel_client_order 1763 1763 0 0.00 3 7762 318 0 0
sp_cancel_customer_reserve 565380 565380 0 0.00 1 47849 63 0 0
sp_cancel_pay_from_customer 690 690 0 0.00 2 2514 66 0 0
sp_cancel_pay_to_supplier 447 447 0 0.00 3 6103 101 0 0
sp_cancel_supplier_invoice 6334 6325 9 0.14 1 22251 804 0 9
sp_cancel_supplier_order 417 417 0 0.00 12 1120458 107165 0 0
sp_cancel_write_off 10825 10825 0 0.00 1 16205 118 0 0
sp_client_order 20918 20918 0 0.00 3 27034 366 0 0
sp_customer_reserve 459229 459229 0 0.00 0 67287 174 0 0
sp_fill_shopping_cart 32066 32066 0 0.00 1 21496 39 0 0
sp_fill_shopping_cart_clo_res 459224 459224 0 0.00 0 14214 13 0 0
sp_get_clo_for_invoice 4959 4959 0 0.00 0 26640 312 0 0
sp_kill_cost_storno 17727 17727 0 0.00 0 15770 57 0 0
sp_kill_qstorno_ret_qs2qd 1148327 1148327 0 0.00 0 47825 34 0 0
sp_kill_qty_storno 605573 605573 0 0.00 0 47827 73 0 0
sp_lock_selected_doc 21042 21042 0 0.00 0 7456 6 0 0
sp_make_cost_storno 28140 28140 0 0.00 0 24170 53 0 0
sp_multiply_rows_for_pdistr 28140 28140 0 0.00 0 6183 25 0 0
sp_multiply_rows_for_qdistr 20918 20918 0 0.00 0 13349 178 0 0
sp_pay_from_customer 7083 7083 0 0.00 4 14544 114 0 0
sp_pay_to_supplier 5959 5959 0 0.00 4 20634 133 0 0
sp_payment_common 13042 13042 0 0.00 1 20597 40 0 0
sp_qd_handle_on_cancel_clo 1763 1763 0 0.00 0 5986 285 0 0
sp_qd_handle_on_invoice_upd_sts 10724 10724 0 0.00 0 25741 322 0 0
sp_qd_handle_on_reserve_upd_sts 10139 10139 0 0.00 0 14263 55 0 0
sp_reserve_write_off 10139 10139 0 0.00 7 24181 174 0 0
sp_supplier_invoice 5609 5609 0 0.00 6 80276 3265 0 0
sp_supplier_order 5546 5546 0 0.00 5 28851 1251 0 0
srv_aggregate_perf_data 114 114 0 0.00 2583 197541 18246 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1138 145656 33123 0 0
srv_find_qd_qs_mism 1065098 1065098 0 0.00 0 20550 5 0 0
srv_make_invnt_saldo 602 602 0 0.00 31 120741 1180 0 0
srv_make_money_saldo 820 820 0 0.00 1 5644 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 186049 499897 316182 0 0
t$perf-abend:sp_add_invoice_to_stock 138 138 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 4964 4964 0 0.00 0 10898 150 0 0
t$perf-norm:sp_cancel_adding_invoice 415 415 0 0.00 0 3925 111 0 0
t$perf-norm:sp_cancel_client_order 1763 1763 0 0.00 0 10365 21 0 0
t$perf-norm:sp_cancel_customer_reserve 731 731 0 0.00 0 3062 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 690 690 0 0.00 0 1485 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 447 447 0 0.00 0 11348 36 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 1421 15 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 25290 1541 0 0
t$perf-norm:sp_cancel_write_off 1084 1084 0 0.00 0 1730 5 0 0
t$perf-norm:sp_client_order 20919 20919 0 0.00 0 8941 17 0 0
t$perf-norm:sp_customer_reserve 1070 1070 0 0.00 0 4986 14 0 0
t$perf-norm:sp_pay_from_customer 7083 7083 0 0.00 0 11324 13 0 0
t$perf-norm:sp_pay_to_supplier 5959 5959 0 0.00 0 18266 12 0 0
t$perf-norm:sp_reserve_write_off 10139 10139 0 0.00 0 11657 13 0 0
t$perf-norm:sp_supplier_invoice 5609 5609 0 0.00 0 5152 15 0 0
t$perf-norm:sp_supplier_order 5546 5546 0 0.00 0 4803 13 0 0
t$perf-norm:srv_aggregate_perf_data 114 114 0 0.00 0 824 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 5377 36 0 0
t$perf-norm:srv_make_invnt_saldo 602 602 0 0.00 0 1164 23 0 0
t$perf-norm:srv_make_money_saldo 820 820 0 0.00 0 11301 31 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 178 48 0 0
v_add_invoice_to_stock 10194 9918 276 2.70 0 7833 18 0 276
v_all_customers 38120 38120 0 0.00 0 25 1 0 0
v_all_suppliers 30924 30924 0 0.00 0 23 1 0 0
v_all_wares 41836 41836 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 830 830 0 0.00 0 456 6 0 0
v_cancel_client_order 3526 3526 0 0.00 0 7396 7 0 0
v_cancel_customer_prepayment 1380 1380 0 0.00 0 2507 6 0 0
v_cancel_customer_reserve 1462 1462 0 0.00 0 591 3 0 0
v_cancel_payment_to_supplier 894 894 0 0.00 0 5918 14 0 0
v_cancel_supplier_invoice 812 794 18 2.21 0 462 15 0 18
v_cancel_supplier_order 834 834 0 0.00 0 1759 7 0 0
v_cancel_write_off 2168 2168 0 0.00 0 2278 13 0 0
v_max_id_clo_ord 5545 5545 0 0.00 0 947 1 0 0
v_max_id_clo_res 1069 1069 0 0.00 0 3188 18 0 0
v_max_id_ord_sup 5603 5603 0 0.00 0 7018 6 0 0
v_max_non_paid_invoice 1645 1645 0 0.00 0 2806 5 0 0
v_max_non_paid_realizn 3706 3706 0 0.00 0 4049 7 0 0
v_min_id_clo_ord 5545 5545 0 0.00 0 2316 5 0 0
v_min_id_clo_res 1069 1069 0 0.00 0 2124 7 0 0
v_min_id_ord_sup 5603 5603 0 0.00 0 4285 5 0 0
v_min_non_paid_invoice 5959 5959 0 0.00 0 20594 27 0 0
v_min_non_paid_realizn 7083 7083 0 0.00 0 6436 17 0 0
v_our_firm 10470 10470 0 0.00 0 15 1 0 0
v_reserve_write_off 20278 20278 0 0.00 0 9344 5 0 0
x_lock_depdocs_on_canc_invoice 11693 11693 0 0.00 0 18007 136 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 16684 379 0 0
x_make_qstorno_1000_1200 5546 5546 0 0.00 1 28830 1176 0 0
x_make_qstorno_1200_2000 5609 5609 0 0.00 3 80264 3116 0 0
x_make_qstorno_2100_3300 459229 459229 0 0.00 0 67282 159 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-01-2021 16:28:43 to 05-01-2021 16:28:47.

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
13:57:17 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:23 22587 8192000000 10235305952 10540212224 893726912 9.836 71 55 111 1 914988768 2476832 18785024
13:57:54 33229 8192000000 10321489808 10632368128 1355787488 14.200 100 90 180 0 1394476720 9076128 29613104
13:58:38 37421 8192000000 10360040896 10683092992 1417157888 14.747 100 88 174 0 1452677776 6417280 29102608
13:59:25 31403 8192000000 10403645344 10730422272 1456300448 15.093 100 93 186 0 1493764640 7150720 30313472
14:00:07 18212 8192000000 10423325376 10748674048 1475798288 15.265 100 92 184 0 1513369632 7707184 29864160
14:00:33 21872 8192000000 10422175152 10754363392 1479618816 15.298 100 90 180 2 1517190000 8351136 29220048
14:01:03 20198 8192000000 10443720624 10778988544 1497237296 15.452 100 83 166 0 1532176800 8557728 26381776
14:01:31 12565 8192000000 10459581424 10801422336 1520147696 15.652 100 78 156 1 1553078272 8702320 24228256
14:01:54 13649 8192000000 10487100864 10837774336 1551944816 15.927 100 73 146 0 1583136896 8633200 22558880
14:02:15 15204 8192000000 10525158096 10877497344 1580433376 16.172 100 78 156 0 1613459936 9126912 23899648
14:02:43 11564 8192000000 10551657968 10907414528 1605230448 16.384 100 71 142 1 1636009344 9897824 20881072
14:03:03 14441 8192000000 10575474464 10936389632 1628116640 16.579 100 74 148 1 1659320176 9881648 21321888
14:03:25 13231 8192000000 10596100144 10958299136 1655755104 16.813 100 80 159 1 1690053312 11588800 22709408
14:03:46 10278 8192000000 10619650736 10983903232 1673112192 16.959 100 77 154 2 1706755968 11985168 21658608
14:04:05 8477 8192000000 10634285728 10996563968 1685184288 17.061 100 80 160 0 1720680128 12961120 22534720
14:04:26 9425 8192000000 10655518528 11022241792 1710394448 17.272 100 86 170 2 1747436944 13031952 24010544
14:04:43 6452 8192000000 10653157024 11029356544 1715197728 17.312 100 85 169 1 1752272832 14076960 22998144
14:04:58 9272 8192000000 10673701952 11043037184 1728245920 17.421 100 86 173 2 1765973968 13991568 23736480
14:05:14 5768 8192000000 10685519584 11054014464 1736347040 17.488 100 89 177 3 1776550496 15114304 25089152
14:05:26 5686 8192000000 10684349008 11058995200 1743911872 17.551 100 86 172 0 1782636560 14856880 23867808
14:05:40 3193 8192000000 10692691296 11070472192 1753614528 17.632 100 88 176 0 1793080192 15429104 24036560
14:05:49 4039 8192000000 10704369168 11077353472 1758563008 17.673 100 83 167 1 1796405408 15010528 22831872
14:06:01 2408 8192000000 10718187024 11090595840 1768756176 17.757 100 93 185 1 1809277344 14349968 26171200
14:06:10 2782 8192000000 10712403568 11091750912 1772261520 17.786 100 89 178 1 1811500272 14489680 24749072
14:06:20 2998 8192000000 10721289616 11099525120 1779775136 17.848 100 84 166 0 1817684320 14235504 23673680
14:06:30 9379 8192000000 10723456704 11107274752 1791524048 17.944 100 75 150 2 1825039216 12415920 21099248
14:06:46 2618 8192000000 10730586448 11114176512 1794879104 17.972 100 80 160 0 1830192640 13346032 21967504
14:06:55 2026 8192000000 10749372064 11131666432 1814638256 18.134 100 88 176 0 1853030352 12600704 25791392
14:07:04 2975 8192000000 10764716512 11147866112 1823157488 18.203 100 82 165 1 1860049024 13054832 23836704
14:07:14 2234 8192000000 10777553344 11161501696 1832670432 18.281 100 92 184 0 1873407184 14393808 26342944
14:07:23 2020 8192000000 10782829840 11167821824 1840325536 18.343 100 91 180 3 1879235024 13415104 25494384
14:07:31 2139 8192000000 10781166896 11169447936 1842786464 18.363 100 89 178 4 1882165040 14105776 25272800
14:07:40 1784 8192000000 10791660240 11177287680 1848774832 18.412 100 90 181 2 1888250576 14289280 25186464
14:07:48 2575 8192000000 10797474080 11181879296 1853264320 18.449 100 92 185 0 1891819760 12750704 25804736
14:07:57 1608 8192000000 10800715792 11185319936 1854195856 18.456 100 85 171 2 1892193024 13125664 24871504
14:08:05 1416 8192000000 10804616960 11188727808 1856230224 18.473 100 90 181 1 1895947200 14107648 25609328
14:08:12 1735 8192000000 10803410544 11189452800 1859535264 18.500 100 92 185 0 1900325296 14462768 26327264
14:08:20 1954 8192000000 10808980096 11194695680 1863048688 18.528 100 95 191 1 1903178896 13630192 26500016
14:08:28 1849 8192000000 10801375872 11197030400 1864100112 18.537 100 78 157 0 1900209600 13747472 22362016
14:08:37 24093 8192000000 10767611568 11191382016 1860141888 18.504 100 56 112 0 1887422944 11383472 15897584
14:09:21 2704 8192000000 10790257664 11201937408 1866926064 18.559 100 63 126 0 1895667072 10449120 18291888
14:09:34 6114 8192000000 10771336480 11194703872 1863305040 18.530 100 26 52 0 1878254752 6932896 8016816
14:09:50 8461 8192000000 10780258352 11202121728 1865191712 18.545 100 24 48 0 1882818000 10684368 6941920
14:10:09 5708 8192000000 10778256864 11201810432 1865696400 18.549 100 25 50 1 1880293424 7349808 7247216
14:10:24 8779 8192000000 10778806496 11209707520 1873273552 18.611 100 21 42 0 1885752496 6737776 5741168
14:10:39 10604 8192000000 10787620608 11213643776 1875328864 18.627 100 15 31 1 1884768096 5608032 3831200
14:10:57 4833 8192000000 10787254624 11215900672 1877447264 18.644 100 15 29 1 1887385152 5939648 3998240
14:11:08 9266 8192000000 10798253792 11226988544 1884585792 18.702 100 18 36 1 1900525968 10318640 5621536
14:11:23 8576 8192000000 10792147360 11221651456 1882564320 18.686 100 19 38 0 1894394288 6608800 5221168
14:11:38 6495 8192000000 10791133648 11220561920 1887269568 18.724 100 28 56 2 1901898304 6017584 8611152
14:11:51 27035 8192000000 10791506768 11231580160 1885626496 18.711 100 19 39 2 1896602320 5182544 5793280
14:12:42 19228 8192000000 10836593664 11242496000 1895747344 18.792 100 66 129 4 1920696912 4923168 20026400
14:13:07 11763 8192000000 10792841392 11234811904 1887669376 18.727 100 20 40 0 1900157152 7094624 5393152
14:13:26 6990 8192000000 10808141040 11236888576 1891143680 18.755 100 31 62 2 1906901184 6573600 9183904
14:13:40 5986 8192000000 10821766096 11246825472 1892952112 18.770 100 33 66 1 1913624016 11694784 8977120
14:13:57 7959 8192000000 10802097232 11238866944 1895207248 18.788 100 27 56 1 1908194944 5551264 7436432
14:14:11 6498 8192000000 10808284816 11241451520 1896014112 18.794 100 32 64 0 1912229360 6364160 9851088
14:14:24 5414 8192000000 10818855280 11245801472 1899298752 18.821 100 41 82 2 1918487440 7238656 11950032
14:14:37 5343 8192000000 10807961616 11241766912 1898004992 18.810 100 35 71 1 1914921520 6875840 10040688
14:14:51 9761 8192000000 10812850224 11250401280 1898345024 18.813 100 22 44 1 1910965360 6178080 6442256
14:15:07 7943 8192000000 10808975248 11243671552 1884666368 18.703 99 26 52 1 1897880608 5190128 8024112
14:15:22 6949 8192000000 10824995280 11254763520 1901559024 18.839 100 20 40 0 1912509504 5090928 5859552
14:15:35 5605 8192000000 10819672048 11257167872 1906310624 18.877 100 26 52 2 1920804768 6848512 7645632
14:15:52 5174 8192000000 10819107552 11255705600 1908130160 18.892 100 24 48 2 1920403344 5506768 6766416
14:16:10 37891 8192000000 10798027488 11229437952 1858661040 18.492 98 19 37 2 1869783024 5675168 5446816
14:17:05 20296 8192000000 10785470832 11229618176 1872039008 18.601 99 23 46 1 1884178432 5818432 6320992
14:17:31 8764 8192000000 10781831712 11215028224 1865197152 18.545 99 10 20 0 1872792272 4897680 2697440
14:17:46 5232 8192000000 10799391600 11230699520 1875410048 18.628 99 42 84 3 1893674832 6522368 11742416
14:18:00 6002 8192000000 10792155360 11223662592 1877641168 18.646 100 34 66 1 1893890176 7030448 9218560
14:18:14 6306 8192000000 10796708768 11216416768 1842039824 18.357 98 34 68 3 1859456880 8172304 9244752
14:18:27 4079 8192000000 10771969648 11192729600 1815929904 18.144 97 41 82 1 1835547104 7745744 11871456
14:18:40 9778 8192000000 10776483392 11195441152 1841151248 18.350 99 26 52 1 1853523008 4967472 7404288
14:18:56 8244 8192000000 10725027888 11151753216 1786440976 17.903 97 29 58 2 1801914544 7132368 8341200
14:19:14 7798 8192000000 10715045696 11135373312 1759313568 17.679 97 34 68 2 1775001104 6071520 9616016
14:19:29 6607 8192000000 10718373744 11141750784 1776729072 17.823 98 15 30 0 1786644000 5769904 4145024
14:19:42 6439 8192000000 10690582032 11092410368 1651981600 16.781 91 39 78 1 1669337488 5214832 12141056
14:19:56 6579 8192000000 10670839536 11074646016 1721478416 17.365 98 21 42 1 1732831936 5670352 5683168
14:20:11 5445 8192000000 10711157504 11123515392 1762448784 17.705 98 39 78 1 1780274832 6684160 11141888
14:20:26 6180 8192000000 10705065344 11114065920 1767952624 17.750 99 28 56 1 1782084384 6011712 8120048
14:20:42 12072 8192000000 10695572112 11107799040 1692295440 17.121 94 16 32 1 1702046160 5345120 4405600
14:21:02 21870 8192000000 10681482880 11089850368 1703670848 17.216 94 32 64 0 1719596656 6145744 9780064
14:21:30 55584 8192000000 10719327904 11119144960 1750885952 17.609 98 28 56 1 1764065552 4526528 8653072
14:22:31 16955 8192000000 10736997168 11154833408 1817528960 18.157 100 31 61 0 1832274416 6205440 8540016
14:22:57 5328 8192000000 10754456624 11170902016 1832455776 18.279 100 29 58 3 1847105072 6080656 8568640
14:23:09 6755 8192000000 10757642816 11177099264 1841626576 18.354 100 39 78 1 1859130928 6854752 10649600
14:23:25 6373 8192000000 10762812688 11182284800 1828626896 18.248 99 29 58 2 1843244736 5786928 8830912
14:23:38 6602 8192000000 10755785024 11176075264 1837526768 18.321 100 26 53 0 1851174800 5382608 8265424
14:23:52 8195 8192000000 10773372352 11199586304 1855458624 18.466 100 24 48 1 1869261168 6603104 7199440
14:24:08 6297 8192000000 10774710608 11205591040 1862416704 18.523 100 17 35 0 1873240816 5788992 5035120
14:24:21 6628 8192000000 10773606496 11208294400 1866770592 18.558 100 18 36 0 1878053808 5452784 5830432
14:24:34 8070 8192000000 10778812848 11208806400 1867941520 18.568 100 17 34 2 1877709232 4961568 4806144
14:24:49 10152 8192000000 10789599584 11217944576 1871455424 18.596 100 16 32 0 1881908064 5478880 4973760
14:25:09 10242 8192000000 10791649584 11221938176 1875085984 18.625 100 20 40 2 1885807168 4830368 5890816
14:25:26 6318 8192000000 10794897744 11221737472 1876633936 18.638 100 19 37 4 1887705376 5626432 5445008
14:25:40 7814 8192000000 10802414256 11232079872 1877976080 18.649 100 26 52 1 1896228224 9827280 8424864
14:25:53 14616 8192000000 10785259120 11226079232 1881605808 18.678 100 16 32 0 1891318592 5230512 4482272
14:26:19 32484 8192000000 10790471312 11232112640 1884987648 18.705 100 26 52 0 1898440384 5870976 7581760
14:27:10 85378 8192000000 10847333472 11267514368 1904822464 18.865 100 40 78 3 1924052592 8356000 10874128
14:28:43 8036 8192000000 10852574240 11281326080 1928157392 19.052 100 54 106 1 1954666192 11154576 15354224
14:29:03 28919 8192000000 10857857776 11291398144 1933101552 19.092 100 32 64 0 1952814496 10790016 8922928
14:29:40 12494 8192000000 10877502768 11308441600 1941391888 19.158 100 44 86 3 1963409008 9444928 12572192
14:30:00 7401 8192000000 10884261248 11312128000 1951733136 19.240 100 57 114 1 1980916816 13142816 16040864
14:30:18 3955 8192000000 10899435408 11320848384 1957014240 19.282 100 60 116 0 1987562736 13945408 16603088
14:30:29 9754 8192000000 10897648176 11325505536 1962692240 19.327 100 62 125 0 1996906128 15458896 18754992
14:30:46 18714 8192000000 10904924864 11334590464 1966491104 19.358 100 58 116 0 1998405536 15329648 16584784
14:31:13 17295 8192000000 10914330176 11342934016 1967813952 19.368 100 57 114 0 2000603328 16427840 16361536
14:31:40 23589 8192000000 10904992176 11346255872 1970299744 19.388 100 49 98 3 2002774832 18387584 14087504
14:32:12 28373 8192000000 10918943184 11353923584 1977106000 19.442 100 33 63 5 2005090608 18206944 9777664
14:33:03 30456 8192000000 10929474384 11368992768 1993103472 19.568 100 53 105 2 2028980912 20362528 15514912
14:33:42 12550 8192000000 10943763760 11383361536 1997775424 19.605 100 44 88 1 2034301344 22736256 13789664
14:34:17 6244 8192000000 10942637456 11375947776 1987507472 19.524 99 62 124 1 2036268048 29392256 19368320
14:34:38 14804 8192000000 10944294176 11385659392 2000983376 19.630 100 45 88 1 2038862256 24353712 13525168
14:35:06 27858 8192000000 10946301328 11390021632 2006575808 19.675 100 43 86 0 2045352992 25386592 13390592
14:35:43 7211 8192000000 10951905680 11394867200 2006774048 19.676 100 36 70 3 2042126896 23626192 11726656
14:35:58 23505 8192000000 10962394480 11401621504 1992341952 19.562 99 53 106 1 2041537088 33317616 15877520
14:36:30 9433 8192000000 10963742608 11405586432 2013185072 19.727 100 48 96 1 2059382784 31742976 14454736
14:36:46 13151 8192000000 10975684640 11414728704 2018362592 19.767 100 51 100 0 2066645616 32950928 15332096
14:37:08 4895 8192000000 10983150272 11420635136 2022805200 19.802 100 54 108 0 2078753472 38664016 17284256
14:37:21 3446 8192000000 10980689792 11420839936 2026055648 19.828 100 57 114 1 2077992048 34388992 17547408
14:37:32 2978 8192000000 10994115152 11428978688 2028525216 19.847 100 60 120 1 2082623824 35527104 18571504
14:37:42 8415 8192000000 10976251536 11408887808 1984909248 19.504 98 64 128 0 2041085712 36680896 19495568
14:38:00 3988 8192000000 10986393504 11420094464 2015900768 19.748 100 62 125 1 2074528000 39636048 18991184
14:38:13 14535 8192000000 10977194128 11414306816 2000705088 19.628 99 55 110 1 2053986736 35787680 17493968
14:38:36 3950 8192000000 10983923152 11416961024 2002808416 19.645 99 67 133 2 2059777808 36492192 20477200
14:38:47 1183 8192000000 11000114768 11419607040 2019106432 19.773 100 85 170 1 2084829216 40538352 25184432
14:38:55 2785 8192000000 11008112560 11426816000 2025218176 19.821 100 79 158 0 2092726256 42432864 25075216
14:39:04 1572 8192000000 11001284592 11419496448 2015689968 19.746 100 77 154 1 2082281264 42752208 23839088
14:39:14 9347 8192000000 10981567488 11414261760 2007477248 19.682 100 70 140 2 2071183840 42490832 21215760
14:39:33 1482 8192000000 11011557776 11429732352 2017258192 19.759 100 79 158 1 2083661056 42235920 24166944
14:39:42 2949 8192000000 10997075136 11425918976 2002763104 19.645 99 72 142 1 2068287008 43500688 22023216
14:39:52 4205 8192000000 10990518912 11422060544 2012265136 19.719 100 73 142 2 2076363040 41832000 22265904
14:40:05 9318 8192000000 10986879168 11423432704 2011077792 19.710 100 58 115 0 2075516032 46492928 17945312
14:40:22 4927 8192000000 11001419984 11433205760 2016438464 19.752 100 73 145 3 2086403072 46966080 22998528
14:40:39 17760 8192000000 11003514416 11443122176 2019683248 19.778 100 57 112 3 2085456976 48240880 17532848
14:41:09 4536 8192000000 11000011600 11442270208 2025596896 19.824 100 54 107 3 2085304704 43015072 16692736
14:41:21 3220 8192000000 11021524352 11451142144 2035284528 19.900 100 76 153 0 2101807456 44338480 22184448
14:41:33 2012 8192000000 11007741648 11428564992 1998883120 19.614 98 76 149 3 2068556224 47333392 22339712
14:41:41 2403 8192000000 11026560592 11449081856 2033248960 19.884 100 80 160 1 2107237008 49143296 24844752
14:41:51 3415 8192000000 11008957456 11435057152 2015269136 19.743 100 79 158 0 2089916592 50650640 23996816
14:42:03 1456 8192000000 11019778304 11437465600 2021238736 19.790 100 91 181 1 2102020672 53400752 27381184
14:42:11 5796 8192000000 10993139520 11420241920 1990743984 19.550 99 81 157 1 2069032704 54189456 24099264
14:42:24 4228 8192000000 11000269792 11426181120 1994983072 19.583 99 77 155 1 2073180176 54067216 24129888
14:42:39 3956 8192000000 10987399648 11413499904 1995397616 19.586 100 77 153 1 2073385696 54260672 23727408
14:42:51 3198 8192000000 10999758864 11414708224 1997842272 19.606 100 92 184 0 2079644400 53453232 28348896
14:43:02 2875 8192000000 10972824752 11392704512 1954947184 19.266 98 80 160 2 2034924688 54465472 25512032
14:43:12 3995 8192000000 10984905280 11402407936 1983534528 19.493 100 78 156 1 2062399312 54873600 23991184
14:43:23 2448 8192000000 11003057968 11417726976 1996035488 19.591 100 87 175 1 2074494592 51764400 26694704
14:43:32 2451 8192000000 11000373920 11412594688 1998209664 19.609 100 91 182 0 2079610640 53200704 28200272
14:43:42 2037 8192000000 10963701664 11374505984 1956964256 19.282 98 84 168 1 2037874160 55068512 25841392
14:43:53 3846 8192000000 10966232944 11383037952 1966089520 19.354 100 78 157 0 2046654688 55799984 24765184
14:44:05 10238 8192000000 10974917776 11397300224 1980079984 19.465 100 72 141 1 2056178608 54360896 21737728
14:44:25 1138 8192000000 10995881920 11414888448 1996724720 19.597 100 89 178 1 2081823104 57387152 27711232
14:44:33 1797 8192000000 10967185584 11387097088 1958592896 19.295 99 77 154 0 2039961344 57411280 23957168
14:44:43 4315 8192000000 10974996256 11397083136 1975041840 19.425 100 75 143 1 2055723680 58347744 22334096
14:44:55 2199 8192000000 10970364928 11386740736 1966906224 19.361 100 86 171 3 2052426208 59738608 25781376
14:45:04 2326 8192000000 10973792528 11389030400 1973330256 19.412 100 74 146 1 2052071856 55362992 23378608
14:45:15 4127 8192000000 10975613600 11390103552 1959200288 19.300 99 80 158 2 2040099536 56429328 24469920
14:45:27 1998 8192000000 10978269696 11396075520 1979880128 19.464 100 80 159 2 2062055520 56756128 25419264
14:45:36 2537 8192000000 10978242208 11389657088 1971020688 19.394 100 83 165 1 2053885744 57303584 25561472
14:45:45 4651 8192000000 10958264160 11384803328 1968893520 19.377 100 64 128 2 2044859184 54908480 21057184
14:46:11 16945 8192000000 10944232960 11381583872 1968746080 19.375 100 44 89 1 2026376304 42777584 14852640
14:46:35 3561 8192000000 10951996304 11370258432 1944031520 19.179 98 74 149 0 2011688336 44062176 23594640
14:46:46 2169 8192000000 10946683600 11369349120 1964193408 19.339 100 69 138 0 2032720496 46719296 21807792
14:46:56 7727 8192000000 10909850384 11347791872 1935404160 19.110 99 43 86 2 1995539808 46023328 14112320
14:47:15 6379 8192000000 10937271776 11361964032 1942046192 19.163 99 52 103 1 2006599600 47058480 17494928
14:47:31 4631 8192000000 10945901056 11365220352 1944565856 19.183 99 76 150 3 2017834160 49023264 24245040
14:47:42 11764 8192000000 10929682512 11356553216 1928620576 19.056 99 50 97 0 1997372400 52533488 16218336
14:48:01 16279 8192000000 10919321888 11356004352 1939813936 19.145 100 44 86 1 2005230608 51179552 14237120
14:48:27 3928 8192000000 10901623312 11319959552 1918247792 18.973 99 59 117 2 1984075696 46125008 19702896
14:48:38 3376 8192000000 10936207744 11356209152 1947344432 19.205 100 59 118 1 2015815872 48759888 19711552
14:48:51 2822 8192000000 10921933088 11343654912 1935638976 19.112 100 54 106 0 2003441312 50694240 17108096
14:49:01 4216 8192000000 10914963984 11347329024 1937174352 19.124 100 44 88 0 1999712656 47725600 14812704
14:49:14 5932 8192000000 10923404160 11351326720 1946649248 19.200 100 41 81 0 2003739136 43471632 13618256
14:49:45 16730 8192000000 10935672592 11384274944 1969250064 19.379 100 38 76 0 2031406496 49617408 12539024
14:50:16 14886 8192000000 10924275552 11361714176 1947517424 19.207 99 30 60 1 2006657008 48878400 10261184
14:50:50 20108 8192000000 10937972800 11380604928 1956640544 19.279 100 39 75 0 2023711232 54169200 12901488
14:51:28 16033 8192000000 10916782496 11363880960 1928799072 19.057 99 28 56 2 1993892080 55081936 10011072
14:51:50 17506 8192000000 10927141024 11375300608 1938346240 19.134 100 31 62 1 2006830144 57350336 11133568
14:52:30 28255 8192000000 10929460384 11379339264 1940727808 19.153 100 29 57 2 2009310416 57637872 10944736
14:53:09 16557 8192000000 10911345568 11365527552 1940009840 19.147 100 28 56 1 2004686288 54574800 10101648
14:53:54 28262 8192000000 10896347952 11359395840 1911643008 18.920 99 16 32 1 1965106624 47754912 5708704
14:54:29 27468 8192000000 10885568896 11339423744 1917229264 18.965 99 23 46 2 1962941424 38343760 7368400
14:55:03 21092 8192000000 10876364128 11334971392 1938775440 19.137 100 20 40 0 1970082288 24637488 6669360
14:55:41 56386 8192000000 10903620352 11348713472 1941960304 19.162 99 29 57 1 1963749504 14095456 7693744
14:56:53 145656 8192000000 10888395536 11329695744 1900758240 18.832 97 29 59 2 1926652288 17762272 8131776
14:59:25 50337 8192000000 10859886672 11322593280 1887250592 18.724 97 6 12 0 1900817488 12218304 1348592
15:00:23 86822 8192000000 10873628080 11336691712 1914871440 18.946 98 30 58 2 1928206736 6257072 7078224
15:01:58 60385 8192000000 10871513504 11337560064 1931014896 19.075 99 10 20 0 1945437488 11509056 2913536
15:03:23 11274 8192000000 10871672528 11339661312 1952528336 19.247 100 7 14 0 1961628848 7202752 1897760
15:03:41 33599 8192000000 10867835440 11332308992 1932657696 19.088 99 21 43 0 1945990432 7427712 5905024
15:04:21 23542 8192000000 10875021296 11333767168 1952692848 19.248 100 22 45 0 1966279744 7959904 5626992
15:04:57 31384 8192000000 10870817216 11341508608 1952953264 19.250 100 7 14 1 1961614992 6876816 1784912
15:05:39 1252 8192000000 10875356400 11343278080 1958512816 19.294 100 12 24 1 1968810576 7376160 2921600
15:05:47 14840 8192000000 10867180336 11339075584 1938782976 19.137 99 9 18 2 1949213744 7731024 2699744
15:06:09 40996 8192000000 10895911536 11362770944 1966526384 19.358 100 17 34 2 1981809072 10224480 5058208
15:07:24 124954 8192000000 10891340432 11373826048 1936185024 19.116 98 26 52 1 1956279680 11209424 8885232
15:09:38 139795 8192000000 10897346544 11368071168 1952752144 19.248 99 8 16 0 1967463760 12809744 1901872
15:12:30 54859 8192000000 10901178080 11368075264 1968161328 19.371 99 19 38 1 1985497152 11983920 5351904
15:13:35 36353 8192000000 10907619776 11375869952 1981418560 19.476 100 22 44 2 2004633376 16610912 6603904
15:14:18 46750 8192000000 10929829424 11391557632 1973135280 19.410 99 31 62 1 1999004352 16852544 9016528
15:15:14 69502 8192000000 10924429440 11399450624 1990586208 19.548 100 18 36 1 2022017408 24944064 6487136
15:16:30 77946 8192000000 10911428544 11404005376 1984957856 19.504 100 20 40 0 2016724352 24542208 7224288
15:18:11 59112 8192000000 10918456592 11373428736 1969903792 19.385 99 25 49 1 1987772656 11194496 6674368
15:19:17 42747 8192000000 10898985088 11368378368 1955651280 19.271 98 29 58 1 1973197792 9490976 8055536
15:20:13 37558 8192000000 10925234736 11387301888 1991468800 19.555 100 40 81 3 2014543728 11647552 11427376
15:20:57 24689 8192000000 10902917408 11376783360 1950730256 19.232 98 17 33 2 1966590992 11033504 4827232
15:21:36 66314 8192000000 10922036288 11393150976 1970947440 19.393 99 17 34 2 1992907024 16711968 5247616
15:22:59 42691 8192000000 10906929952 11368132608 1945481712 19.190 98 21 41 2 1971434480 19694512 6258256
15:23:52 119943 8192000000 10903578752 11381899264 1925699872 19.032 97 18 37 0 1945292352 14873296 4719184
15:26:02 51946 8192000000 10922025648 11370082304 1919067056 18.979 97 18 35 0 1934965104 10360640 5537408
15:27:10 90764 8192000000 10860630800 11338772480 1840058992 18.341 93 23 46 0 1859532256 12903936 6569328
15:28:48 138881 8192000000 10846696528 11310776320 1763761216 17.715 91 17 34 0 1784437088 15633552 5042320
15:31:13 68167 8192000000 10862988272 11305332736 1905861600 18.873 99 14 29 0 1919017488 9133488 4022400
15:32:28 52782 8192000000 10876847888 11327467520 1887601728 18.726 97 39 77 1 1905976960 8153296 10221936
15:33:29 43559 8192000000 10873817344 11328581632 1931424912 19.078 100 34 68 2 1953549840 12736544 9388384
15:34:19 47063 8192000000 10857492624 11341942784 1947931808 19.210 100 30 58 3 1971785888 14743072 9111008
15:35:20 94652 8192000000 10813854384 11283881984 1843428560 18.369 95 6 12 0 1855727616 9961136 2337920
15:37:11 32946 8192000000 10834410016 11298877440 1905527552 18.871 99 9 19 0 1917703152 9772048 2403552
15:37:52 55751 8192000000 10836185728 11307024384 1877454832 18.645 97 13 26 0 1892737088 11239088 4043168
15:39:14 61019 8192000000 10845161056 11318829056 1911760528 18.921 99 15 30 0 1926683504 10303376 4619600
15:40:24 46593 8192000000 10852252112 11329441792 1897751120 18.808 98 14 28 1 1913018000 10932832 4334048
15:41:17 65905 8192000000 10851719520 11317653504 1840799312 18.347 95 17 34 2 1855133568 9713840 4620416
15:42:29 54301 8192000000 10859571504 11329765376 1909362112 18.902 98 25 50 1 1929769792 13478432 6929248
15:43:30 79337 8192000000 10857878544 11328655360 1882508192 18.685 97 17 33 0 1898884976 11749632 4627152
15:45:13 60335 8192000000 10866249088 11347783680 1909794928 18.905 98 29 58 0 1933490336 15637376 8058032
15:46:20 38384 8192000000 10859321168 11316985856 1867803808 18.567 96 15 30 0 1879888624 8217392 3867424
15:47:06 22051 8192000000 10870324704 11315449856 1897969968 18.810 98 52 104 1 1921531152 9082528 14478656
15:47:38 21207 8192000000 10881327792 11322298368 1929233888 19.061 100 47 94 0 1957928496 15850784 12843824
15:48:11 59283 8192000000 10877082048 11323490304 1865706672 18.550 96 35 70 2 1886365744 11346752 9312320
15:49:17 22235 8192000000 10880787808 11326402560 1932609936 19.088 100 48 96 1 1961425504 15759168 13056400
15:49:59 54288 8192000000 10876079936 11334377472 1902231232 18.844 98 26 52 1 1924772704 15460736 7080736
15:51:01 129858 8192000000 10877982992 11345842176 1928381184 19.054 99 7 14 0 1947314544 17192496 1740864
15:53:19 84313 8192000000 10881235136 11336503296 1935506736 19.111 99 21 42 1 1951916512 10424416 5985360
15:55:07 64161 8192000000 10866355264 11329429504 1925286784 19.029 98 27 54 1 1940994464 8105936 7601744
15:56:23 48091 8192000000 10878119664 11355602944 1956142976 19.275 100 12 24 3 1968212272 8600848 3468448
15:57:18 44971 8192000000 10885812400 11369697280 1973226576 19.411 100 12 24 1 1987732144 11328288 3177280
15:58:09 55618 8192000000 10898118064 11370098688 1959501392 19.302 99 9 18 0 1971662272 9906048 2254832
15:59:15 100262 8192000000 10902162928 11384782848 1966646896 19.359 99 16 32 1 1980889440 9603936 4638608
16:02:37 46731 8192000000 10889925072 11358715904 1915835488 18.953 97 22 44 1 1936980912 15380880 5764544
16:03:30 51522 8192000000 10885231440 11357097984 1906266352 18.877 97 21 42 0 1921491920 9345584 5879984
16:04:44 73960 8192000000 10907720080 11376558080 1940554528 19.151 98 20 40 2 1965608224 19241504 5812192
16:06:34 17516 8192000000 10918124096 11365928960 1958207424 19.292 99 24 48 2 1971738400 6996896 6534080
16:06:58 40750 8192000000 10898047296 11361452032 1921753008 19.001 97 36 72 1 1941446992 9692352 10001632
16:07:52 61182 8192000000 10908371632 11370893312 1939968080 19.147 98 28 56 2 1960570112 12684192 7917840
16:09:03 131553 8192000000 10878282304 11340083200 1803593824 18.043 91 14 28 1 1821583968 13969856 4020288
16:11:26 48875 8192000000 10891079728 11361525760 1938874304 19.138 99 18 36 0 1958291488 14450128 4967056
16:12:24 29203 8192000000 10920035856 11370115072 1972424944 19.405 100 44 88 1 1996786848 11950064 12411840
16:13:00 26538 8192000000 10911358336 11370602496 1974242432 19.419 100 28 56 3 1990557424 8921584 7393408
16:13:32 7416 8192000000 10927803808 11380981760 1980169872 19.466 100 36 72 1 2000546976 10333200 10043904
16:13:48 96084 8192000000 10883342576 11350212608 1836306304 18.311 93 10 20 1 1849609552 10447552 2855696
16:15:35 33523 8192000000 10855830176 11303800832 1881122112 18.674 96 36 72 1 1898403008 6728400 10552496
16:16:23 122535 8192000000 10876775120 11346485248 1913797248 18.937 98 25 50 0 1936032384 15103136 7132000
16:18:43 70979 8192000000 10832446848 11297632256 1877652624 18.646 96 14 28 0 1895178288 13572272 3953392
16:20:05 79457 8192000000 10843583632 11320659968 1886083328 18.714 97 18 36 1 1905416016 13319712 6012976
16:21:36 36431 8192000000 10839482320 11314618368 1879176144 18.658 97 14 28 0 1896218368 13089104 3953120
16:22:21 61887 8192000000 10852654368 11320766464 1901463088 18.838 99 20 40 1 1920406768 12716576 6227104
16:23:29 66188 8192000000 10825145968 11297337344 1843617280 18.370 96 11 22 1 1860511056 13495568 3398208
16:24:47 53124 8192000000 10821002544 11295031296 1870564496 18.589 98 10 21 2 1883627536 9872720 3190320
16:25:46 44907 8192000000 10859199376 11319250944 1901020224 18.834 99 14 28 0 1913326016 8534832 3770960
16:26:38 39359 8192000000 9535353872 9852678144 680618240 7.670 36 1 2 0 684733872 4053504 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 05-01-2021 16:28:49 to 05-01-2021 16:29:20.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 138 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:02, from 05-01-2021 16:29:21 to 05-01-2021 16:29:23.

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

05.01.21 16:29:24. 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-01-05 16:29:27 No severe PSQL-related problems occured
05.01.21 16:29:28. End of report.