Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.06.2021 16:33
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 58e1ddde69c44dad93d327777e5becec
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 2021-05-09 08:45
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 4793.92
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 16996744 kB
MemAvailable 31360036 kB
Buffers 0 kB
Cached 14640088 kB
SwapCached 2440 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-06-18 16:33:11
DTS_END                         2021-06-18 16:33:11.7170
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_MAKE_MONEY_SALDO(33:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50576
TRN_ID                          258796
ATT_ID                          711
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: 9478.54 21657 1137425
customer order: creation 190.64 324 22877
customer order: refuse 16.54 345 1985
order to supplier: creation 51.95 1265 6234
order to supplier: removal 3.70 85539 444
invoice (draft): creation 49.93 3295 5992
invoice (draft): removal 52.58 775 6310
invoice accept: apply 45.27 16669 5432
invoice accept: cancel 47.31 825 5677
customer reserve: creation 4087.90 168 490548
customer reserve: removal 4612.65 53 553518
realization accept: apply 91.93 174 11032
realization accept: cancel 81.95 104 9834
payment from customer: creation 67.28 102 8074
payment from customer: removal 6.68 72 801
payment to supplier: creation 54.33 117 6520
payment to supplier: removal 3.82 45 458
service: total inventory turnovers 5.47 1025 656
service: total monetary turnovers 7.78 44 934
service: aggregate perf. data 0.79 25840 95
service: refresh index statistics 0.03 296352 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 18-06-2021 16:33:52 to 18-06-2021 16:33:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4919
TEST_TIME 2 3776
TEST_TIME 3 4215
TEST_TIME 4 4386
TEST_TIME 5 4739
TEST_TIME 6 4965
TEST_TIME 7 5470
TEST_TIME 8 5907
TEST_TIME 9 5822
TEST_TIME 10 6276
TEST_TIME 11 6255
TEST_TIME 12 6400
TEST_TIME 13 6552
TEST_TIME 14 6786
TEST_TIME 15 7010
TEST_TIME 16 7104
TEST_TIME 17 7527
TEST_TIME 18 7666
TEST_TIME 19 7726
TEST_TIME 20 8259
TEST_TIME 21 8178
TEST_TIME 22 8815
TEST_TIME 23 9489
TEST_TIME 24 10267
TEST_TIME 25 10137
TEST_TIME 26 10311
TEST_TIME 27 10641
TEST_TIME 28 10498
TEST_TIME 29 10345
TEST_TIME 30 10410
TEST_TIME 31 10333
TEST_TIME 32 10380
TEST_TIME 33 10338
TEST_TIME 34 10242
TEST_TIME 35 10233
TEST_TIME 36 10255
TEST_TIME 37 10328
TEST_TIME 38 10331
TEST_TIME 39 10340
TEST_TIME 40 10093
TEST_TIME 41 9892
TEST_TIME 42 9954
TEST_TIME 43 10136
TEST_TIME 44 9976
TEST_TIME 45 9925
TEST_TIME 46 9947
TEST_TIME 47 9907
TEST_TIME 48 9959
TEST_TIME 49 10043
TEST_TIME 50 9966
TEST_TIME 51 9896
TEST_TIME 52 9812
TEST_TIME 53 9731
TEST_TIME 54 9701
TEST_TIME 55 9650
TEST_TIME 56 9606
TEST_TIME 57 9610
TEST_TIME 58 9634
TEST_TIME 59 9538
TEST_TIME 60 9496
TEST_TIME 61 9468
TEST_TIME 62 9505
TEST_TIME 63 9541
TEST_TIME 64 9570
TEST_TIME 65 9539
TEST_TIME 66 9709
TEST_TIME 67 9645
TEST_TIME 68 9736
TEST_TIME 69 9674
TEST_TIME 70 9721
TEST_TIME 71 9750
TEST_TIME 72 9743
TEST_TIME 73 9801
TEST_TIME 74 9918
TEST_TIME 75 9832
TEST_TIME 76 9767
TEST_TIME 77 9784
TEST_TIME 78 9703
TEST_TIME 79 9744
TEST_TIME 80 9683
TEST_TIME 81 9649
TEST_TIME 82 9606
TEST_TIME 83 9554
TEST_TIME 84 9536
TEST_TIME 85 9485
TEST_TIME 86 9528
TEST_TIME 87 9488
TEST_TIME 88 9505
TEST_TIME 89 9464
TEST_TIME 90 9560
TEST_TIME 91 9557
TEST_TIME 92 9544
TEST_TIME 93 9545
TEST_TIME 94 9529
TEST_TIME 95 9587
TEST_TIME 96 9584
TEST_TIME 97 9610
TEST_TIME 98 9621
TEST_TIME 99 9660
TEST_TIME 100 9649
TEST_TIME 101 9607
TEST_TIME 102 9569
TEST_TIME 103 9569
TEST_TIME 104 9547
TEST_TIME 105 9517
TEST_TIME 106 9491
TEST_TIME 107 9432
TEST_TIME 108 9395
TEST_TIME 109 9401
TEST_TIME 110 9394
TEST_TIME 111 9422
TEST_TIME 112 9433
TEST_TIME 113 9449
TEST_TIME 114 9455
TEST_TIME 115 9542
TEST_TIME 116 9555
TEST_TIME 117 9551
TEST_TIME 118 9578
TEST_TIME 119 9559
TEST_TIME 120 9482

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-06-2021 16:33:56 to 18-06-2021 16:33:59.

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 1591316 1591316 0 0.00 0 22598 6 0 0
doc_list_biud 1591312 1591312 0 0.00 0 73182 24 0 0
sp_add_invoice_to_stock 5587 5432 155 2.77 24 168904 16669 0 155
sp_cancel_adding_invoice 5677 5677 0 0.00 5 81541 825 0 0
sp_cancel_client_order 1985 1985 0 0.00 5 12416 345 0 0
sp_cancel_customer_reserve 553518 553518 0 0.00 1 73183 53 0 0
sp_cancel_pay_from_customer 801 801 0 0.00 2 7265 73 0 0
sp_cancel_pay_to_supplier 458 458 0 0.00 3 926 46 0 0
sp_cancel_supplier_invoice 6321 6310 11 0.17 1 14108 775 0 11
sp_cancel_supplier_order 444 444 0 0.00 8 1175145 85539 0 0
sp_cancel_write_off 9834 9834 0 0.00 1 15006 105 0 0
sp_client_order 22877 22877 0 0.00 3 14465 324 0 0
sp_customer_reserve 490548 490548 0 0.00 0 40208 168 0 0
sp_fill_shopping_cart 35098 35098 0 0.00 1 13860 38 0 0
sp_fill_shopping_cart_clo_res 490537 490537 0 0.00 0 15764 11 0 0
sp_get_clo_for_invoice 5421 5421 0 0.00 0 26215 249 0 0
sp_kill_cost_storno 16770 16770 0 0.00 0 9715 52 0 0
sp_kill_qstorno_ret_qs2qd 1123624 1123624 0 0.00 0 73179 29 0 0
sp_kill_qty_storno 594220 594220 0 0.00 0 73182 64 0 0
sp_lock_selected_doc 22845 22845 0 0.00 0 8484 4 0 0
sp_make_cost_storno 31046 31046 0 0.00 0 19077 54 0 0
sp_multiply_rows_for_pdistr 31046 31046 0 0.00 0 11526 27 0 0
sp_multiply_rows_for_qdistr 22877 22877 0 0.00 0 14456 145 0 0
sp_pay_from_customer 8074 8074 0 0.00 3 14084 103 0 0
sp_pay_to_supplier 6520 6520 0 0.00 4 13115 117 0 0
sp_payment_common 14594 14594 0 0.00 1 9567 27 0 0
sp_qd_handle_on_cancel_clo 1985 1985 0 0.00 0 12408 321 0 0
sp_qd_handle_on_invoice_upd_sts 11097 11097 0 0.00 0 23910 336 0 0
sp_qd_handle_on_reserve_upd_sts 11032 11032 0 0.00 0 18346 62 0 0
sp_reserve_write_off 11032 11032 0 0.00 6 19662 175 0 0
sp_supplier_invoice 5992 5992 0 0.00 7 92872 3296 0 0
sp_supplier_order 6234 6234 0 0.00 4 27409 1265 0 0
srv_aggregate_perf_data 95 95 0 0.00 3056 224152 25841 0 0
srv_fill_mon_cache_memory 170 170 0 0.00 1991 143286 31617 0 0
srv_find_qd_qs_mism 1084847 1084847 0 0.00 0 22592 5 0 0
srv_make_invnt_saldo 656 656 0 0.00 32 74738 1026 0 0
srv_make_money_saldo 934 934 0 0.00 1 10925 45 0 0
srv_recalc_idx_stat 4 4 0 0.00 191340 489520 296353 0 0
t$perf-abend:sp_add_invoice_to_stock 155 155 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5432 5432 0 0.00 0 10012 156 0 0
t$perf-norm:sp_cancel_adding_invoice 440 440 0 0.00 0 10390 127 0 0
t$perf-norm:sp_cancel_client_order 1985 1985 0 0.00 0 5394 14 0 0
t$perf-norm:sp_cancel_customer_reserve 709 709 0 0.00 0 2306 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 801 801 0 0.00 0 5592 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 458 458 0 0.00 0 1506 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 446 446 0 0.00 0 6049 26 0 0
t$perf-norm:sp_cancel_supplier_order 444 444 0 0.00 0 19786 1504 0 0
t$perf-norm:sp_cancel_write_off 1110 1110 0 0.00 0 2534 10 0 0
t$perf-norm:sp_client_order 22877 22877 0 0.00 0 15611 16 0 0
t$perf-norm:sp_customer_reserve 1155 1155 0 0.00 0 3763 8 0 0
t$perf-norm:sp_pay_from_customer 8074 8074 0 0.00 0 5194 9 0 0
t$perf-norm:sp_pay_to_supplier 6520 6520 0 0.00 0 9091 9 0 0
t$perf-norm:sp_reserve_write_off 11032 11032 0 0.00 0 10764 13 0 0
t$perf-norm:sp_supplier_invoice 5992 5992 0 0.00 0 5606 17 0 0
t$perf-norm:sp_supplier_order 6234 6234 0 0.00 0 8167 17 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 264 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 170 170 0 0.00 0 1092 16 0 0
t$perf-norm:srv_make_invnt_saldo 656 656 0 0.00 0 976 22 0 0
t$perf-norm:srv_make_money_saldo 934 934 0 0.00 0 4564 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 11148 10838 310 2.78 0 5191 18 0 310
v_all_customers 41910 41910 0 0.00 0 107 1 0 0
v_all_suppliers 33434 33434 0 0.00 0 124 1 0 0
v_all_wares 45754 45754 0 0.00 0 115 1 0 0
v_cancel_adding_invoice 880 880 0 0.00 0 597 7 0 0
v_cancel_client_order 3970 3970 0 0.00 0 1442 3 0 0
v_cancel_customer_prepayment 1602 1602 0 0.00 0 1775 4 0 0
v_cancel_customer_reserve 1418 1418 0 0.00 0 602 3 0 0
v_cancel_payment_to_supplier 916 916 0 0.00 0 812 3 0 0
v_cancel_supplier_invoice 914 892 22 2.40 0 1748 19 0 22
v_cancel_supplier_order 888 888 0 0.00 0 5190 9 0 0
v_cancel_write_off 2220 2220 0 0.00 0 5267 13 0 0
v_max_id_clo_ord 6234 6234 0 0.00 0 563 1 0 0
v_max_id_clo_res 1155 1155 0 0.00 0 1610 6 0 0
v_max_id_ord_sup 5987 5987 0 0.00 0 6391 6 0 0
v_max_non_paid_invoice 2024 2024 0 0.00 0 1994 4 0 0
v_max_non_paid_realizn 4239 4239 0 0.00 0 1369 3 0 0
v_min_id_clo_ord 6234 6234 0 0.00 0 5436 13 0 0
v_min_id_clo_res 1155 1155 0 0.00 0 3176 10 0 0
v_min_id_ord_sup 5987 5987 0 0.00 0 4756 5 0 0
v_min_non_paid_invoice 6520 6520 0 0.00 0 5979 14 0 0
v_min_non_paid_realizn 8074 8074 0 0.00 0 9565 18 0 0
v_our_firm 11514 11514 0 0.00 0 13 1 0 0
v_reserve_write_off 22064 22064 0 0.00 0 5204 5 0 0
x_lock_depdocs_on_canc_invoice 11541 11541 0 0.00 0 19615 111 0 0
x_lock_depdocs_on_canc_sup_ord 444 444 0 0.00 0 11391 300 0 0
x_make_qstorno_1000_1200 6234 6234 0 0.00 2 27385 1176 0 0
x_make_qstorno_1200_2000 5992 5992 0 0.00 3 92864 3165 0 0
x_make_qstorno_2100_3300 490548 490548 0 0.00 0 38078 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-06-2021 16:34:00 to 18-06-2021 16:34:04.

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
14:03:15 1 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
14:03:22 19065 8192000000 10238622400 10544832512 768443808 8.575 61 44 90 2 785026720 2124992 14457920
14:03:49 29730 8192000000 10332230128 10643251200 1367291296 14.303 100 88 175 0 1400488208 4615504 28581408
14:04:26 33143 8192000000 10373808064 10694213632 1414900576 14.727 100 84 168 0 1449042272 6376048 27765648
14:05:11 16832 8192000000 10386466192 10707791872 1438098704 14.933 100 93 186 0 1476260448 7633456 30528288
14:05:41 19602 8192000000 10405652736 10731032576 1459591024 15.122 100 90 180 2 1497057680 8334464 29132192
14:06:16 17560 8192000000 10421189056 10751098880 1473877328 15.248 100 86 173 0 1510552816 8692144 27983344
14:06:47 16265 8192000000 10438280304 10769817600 1493672544 15.421 100 90 180 0 1532434928 9729008 29033376
14:07:14 11634 8192000000 10440224256 10780307456 1500265504 15.478 100 88 176 1 1538141504 9585888 28290112
14:07:37 13351 8192000000 10477695648 10823299072 1525192064 15.695 100 69 139 2 1556242208 9565472 21484672
14:08:00 13710 8192000000 10518200128 10870697984 1573923024 16.116 100 72 144 0 1605393360 9498816 21971520
14:08:26 12978 8192000000 10559325616 10917502976 1617218128 16.486 100 83 166 2 1652561568 10135040 25208400
14:08:50 8953 8192000000 10588178368 10949931008 1648285456 16.750 100 81 162 1 1683924160 11606864 24031840
14:09:09 12744 8192000000 10611541232 10976718848 1669854848 16.932 100 84 169 0 1707085920 13158496 24072576
14:09:29 9373 8192000000 10623951776 10993090560 1685833424 17.066 100 83 166 1 1722816080 13020880 23961776
14:09:46 10468 8192000000 10648080688 11019792384 1706175856 17.237 100 84 168 1 1743574560 13363728 24034976
14:10:05 6378 8192000000 10672148896 11043291136 1725428576 17.397 100 84 165 1 1761233376 12610528 23194272
14:10:18 6250 8192000000 10672589264 11044155392 1737279808 17.496 100 78 156 1 1773357200 14013888 22063504
14:10:31 6771 8192000000 10691229616 11064573952 1747169344 17.578 100 90 181 1 1787514544 14683824 25661376
14:10:46 4629 8192000000 10698656912 11076411392 1754795568 17.641 100 86 169 1 1793250688 14347872 24107248
14:10:57 5366 8192000000 10709079808 11089207296 1766255984 17.736 100 86 173 1 1805450272 14098080 25096208
14:11:09 3229 8192000000 10712024720 11091378176 1771498176 17.779 100 84 168 0 1808905488 13794736 23612576
14:11:20 3574 8192000000 10717636000 11096498176 1780513728 17.854 100 80 159 0 1817049392 13245136 23290528
14:11:30 4097 8192000000 10723626928 11108139008 1784325552 17.885 100 83 166 1 1822544016 14612240 23606224
14:11:41 2175 8192000000 10733366144 11115790336 1794810000 17.971 100 87 174 0 1833699424 14225712 24663712
14:11:50 4092 8192000000 10735064544 11119906816 1801970896 18.030 100 88 177 0 1841119840 14564784 24584160
14:12:01 1793 8192000000 10756111424 11137703936 1811982016 18.112 100 95 184 3 1852631408 14319632 26329760
14:12:10 2879 8192000000 10756894528 11140423680 1817436208 18.157 100 92 183 1 1856642304 13278272 25927824
14:12:19 2798 8192000000 10765125504 11147907072 1826263280 18.229 100 91 182 4 1864294400 12403648 25627472
14:12:28 1955 8192000000 10765471056 11156877312 1832768528 18.282 100 81 162 1 1866844672 11930384 22145760
14:12:37 4010 8192000000 10767438112 11160035328 1836627936 18.313 100 81 162 0 1872181344 12276640 23276768
14:12:47 2898 8192000000 10788869936 11175587840 1841347008 18.352 100 84 166 1 1876516928 12475024 22694896
14:12:56 2471 8192000000 10800886400 11188613120 1853570064 18.451 100 92 184 1 1893917584 14732528 25614992
14:13:05 1831 8192000000 10802829968 11192668160 1856088304 18.472 100 85 169 3 1894228928 15053296 23087328
14:13:14 1873 8192000000 10807718128 11194777600 1861902848 18.519 100 90 180 0 1901941616 14405184 25633584
14:13:22 2463 8192000000 10814184624 11202007040 1866669840 18.557 100 97 193 0 1907017600 12974208 27373552
14:13:31 1471 8192000000 10820579312 11208937472 1872199872 18.602 100 95 190 1 1912821184 13232272 27389040
14:13:38 1369 8192000000 10821337760 11211665408 1877780112 18.647 100 93 188 0 1916239264 12263088 26196064
14:13:46 1122 8192000000 10823622000 11211448320 1878661536 18.654 100 94 188 1 1918905360 13468544 26775280
14:13:53 1342 8192000000 10826546016 11216601088 1884567104 18.702 100 95 189 0 1923946448 13743952 25635392
14:14:01 1350 8192000000 10827489472 11222065152 1883230896 18.691 100 93 186 0 1923098272 14137936 25729440
14:14:09 48518 8192000000 10806790768 11212808192 1875587408 18.629 100 47 94 0 1896728848 8271856 12869584
14:15:03 35248 8192000000 10804471120 11217903616 1879739552 18.663 100 46 92 1 1900381344 7054800 13586992
14:15:46 4149 8192000000 10802767168 11220549632 1883286736 18.692 100 54 109 2 1910423024 11836848 15299440
14:15:57 9869 8192000000 10788020480 11216367616 1879771744 18.663 100 30 58 1 1895246720 7256912 8218064
14:16:13 7736 8192000000 10784536096 11216805888 1879265824 18.659 100 19 36 2 1891206960 5912912 6028224
14:16:28 7057 8192000000 10795970080 11225108480 1889189232 18.739 100 31 63 0 1903952976 6033584 8730160
14:16:42 5784 8192000000 10803468896 11231584256 1886916992 18.721 100 21 42 0 1899856736 7078128 5861616
14:16:54 7680 8192000000 10808127008 11231170560 1892254512 18.764 100 31 62 2 1907346672 5951936 9140224
14:17:11 11337 8192000000 10786915808 11229147136 1887297568 18.724 100 16 32 1 1897525168 5740032 4487568
14:17:29 8942 8192000000 10795073648 11234557952 1892582432 18.767 100 16 30 2 1902253984 5669312 4002240
14:17:44 8912 8192000000 10796169152 11234287616 1893246944 18.772 100 18 36 1 1903683312 5477520 4958848
14:18:00 8848 8192000000 10814621408 11243773952 1900709376 18.832 100 30 62 3 1919291696 10363440 8218880
14:18:16 7459 8192000000 10797875264 11238268928 1897208320 18.804 100 20 40 0 1909516096 7186768 5121008
14:18:30 11682 8192000000 10815170416 11244851200 1902495824 18.846 100 23 46 1 1914581536 5936992 6148720
14:18:54 9894 8192000000 10819875136 11250003968 1903977712 18.858 100 31 62 3 1919341328 6760576 8603040
14:19:10 6275 8192000000 10821331024 11248562176 1904045744 18.859 100 25 49 1 1917387264 6190720 7150800
14:19:23 12290 8192000000 10823771360 11255336960 1905627776 18.872 100 27 54 2 1923194032 10433360 7132896
14:19:41 55831 8192000000 10862483648 11272466432 1912526320 18.927 100 56 114 2 1935271216 5493920 17250976
14:20:43 12668 8192000000 10820394816 11260153856 1912627520 18.928 100 22 45 0 1925449408 7008400 5813488
14:21:02 10863 8192000000 10818058528 11262033920 1911505664 18.919 100 20 40 2 1922583472 5638432 5439376
14:21:19 6996 8192000000 10827748064 11255308288 1891671840 18.759 99 35 70 3 1909168160 8084896 9411424
14:21:33 5952 8192000000 10816550864 11252396032 1902641664 18.848 100 32 64 1 1918433904 6994880 8797360
14:21:46 7126 8192000000 10826432144 11260944384 1907622720 18.888 100 27 56 0 1921269264 5336928 8309616
14:22:02 5367 8192000000 10811278976 11241705472 1892669088 18.767 99 38 76 0 1910096880 6184304 11243488
14:22:15 12460 8192000000 10804379456 11244486656 1896572848 18.799 100 14 27 0 1906634464 5273808 4787808
14:22:34 9205 8192000000 10820681040 11251261440 1884297680 18.700 99 25 46 2 1900844016 9879264 6667072
14:22:51 5950 8192000000 10807891984 11244523520 1884601776 18.702 99 32 64 0 1900266816 6425872 9239168
14:23:06 8014 8192000000 10804660240 11240443904 1889160688 18.739 100 25 49 1 1901196864 5306432 6729744
14:23:23 6421 8192000000 10773502256 11205464064 1835043744 18.300 98 26 52 2 1848839968 5663504 8132720
14:23:37 7760 8192000000 10782781520 11208249344 1834117712 18.293 98 17 34 1 1845085504 6050016 4917776
14:23:52 7777 8192000000 10768777856 11205271552 1833439248 18.287 98 23 46 2 1846508272 6195472 6873552
14:24:06 20301 8192000000 10768464384 11191271424 1808433360 18.083 97 17 34 0 1819051552 5131360 5486832
14:24:58 35222 8192000000 10741751872 11169697792 1722409072 17.372 93 21 40 1 1732620400 4594720 5616608
14:25:44 6822 8192000000 10748813520 11164372992 1825850448 18.225 100 33 66 2 1842165408 6759424 9555536
14:25:57 7061 8192000000 10697099040 11114950656 1708468848 17.256 94 35 70 1 1724674176 7167456 9037872
14:26:13 4720 8192000000 10682531472 11100127232 1738357024 17.505 97 37 74 1 1754553840 5590160 10606656
14:26:24 5383 8192000000 10675700528 11086499840 1761393344 17.696 99 36 72 5 1777391328 6126720 9871264
14:26:36 6058 8192000000 10673461536 11077816320 1702656816 17.207 96 29 58 1 1717322192 6200064 8465312
14:26:52 7723 8192000000 10725305408 11131301888 1779542656 17.846 99 31 62 0 1793565024 5445568 8576800
14:27:11 12006 8192000000 10703282960 11114840064 1722751856 17.375 96 28 56 2 1736986288 6158560 8075872
14:27:30 8168 8192000000 10695006304 11117723648 1773889504 17.799 99 26 51 5 1788079632 5953952 8236176
14:27:45 9775 8192000000 10707821248 11120545792 1777820016 17.832 99 26 52 4 1790999376 5430976 7748384
14:28:07 7677 8192000000 10700585248 11123138560 1793457280 17.960 100 31 62 0 1808293280 5597856 9238144
14:28:23 8948 8192000000 10737326896 11148206080 1816426640 18.148 100 28 56 1 1829981424 5334768 8220016
14:28:42 13224 8192000000 10742071760 11163701248 1824124944 18.211 100 21 42 2 1836062192 5991872 5945376
14:29:03 40419 8192000000 10751690768 11180109824 1837197104 18.318 100 19 37 0 1847893040 5185280 5510656
14:30:06 31440 8192000000 10757581616 11182424064 1828320864 18.246 99 22 44 1 1839822160 5368528 6132768
14:30:48 9389 8192000000 10758099520 11191025664 1851977264 18.438 100 24 49 2 1865573808 7183456 6413088
14:31:04 7192 8192000000 10771714528 11195318272 1856247296 18.473 100 43 86 0 1875334736 6644400 12443040
14:31:21 6166 8192000000 10776383792 11201134592 1859560864 18.500 100 30 60 0 1874300064 6015120 8724080
14:31:36 9651 8192000000 10780361712 11204612096 1864489264 18.540 100 30 60 0 1879670512 5988208 9193040
14:31:52 7969 8192000000 10788297408 11215441920 1870714800 18.590 100 29 57 0 1888940544 10249952 7975792
14:32:08 7551 8192000000 10789118800 11218501632 1872267744 18.603 100 30 57 4 1891072928 10487712 8317472
14:32:22 9658 8192000000 10784245472 11217248256 1875189552 18.626 100 22 44 2 1887499280 6218256 6091472
14:32:38 9300 8192000000 10784586080 11216642048 1873192320 18.610 100 10 20 1 1882783488 5741888 3849280
14:32:53 9498 8192000000 10790966400 11221405696 1874944688 18.624 100 16 32 2 1884229280 5031536 4253056
14:33:10 31066 8192000000 10820071424 11241500672 1893718160 18.776 100 21 42 1 1904933776 5061216 6154400
14:33:50 35008 8192000000 10846615360 11262160896 1914027808 18.939 100 37 74 0 1933031696 8078960 10924928
14:34:40 18451 8192000000 10857038656 11276636160 1923856784 19.018 100 44 88 0 1945358768 8646960 12855024
14:35:05 63946 8192000000 10865097568 11286765568 1932478704 19.087 100 54 106 0 1957601664 10197776 14925184
14:36:19 50132 8192000000 10857587616 11295477760 1938517136 19.135 100 40 80 1 1959717840 8977088 12223616
14:37:18 20957 8192000000 10872648112 11303010304 1943396304 19.174 100 47 92 2 1967358896 10489872 13472720
14:37:46 22673 8192000000 10885661504 11311362048 1946901536 19.202 100 43 86 3 1971869696 12690576 12277584
14:38:16 38583 8192000000 10887069264 11324616704 1959104544 19.299 100 43 86 0 1983903328 12563600 12235184
14:39:04 18997 8192000000 10907150304 11341312000 1968132432 19.371 100 45 90 0 1997240544 16100560 13007552
14:39:31 5512 8192000000 10905466160 11339026432 1973943440 19.417 100 53 106 2 2004672656 15517120 15212096
14:39:45 12477 8192000000 10902545344 11334709248 1957753872 19.288 99 53 106 2 1990843552 17747280 15342400
14:40:07 15808 8192000000 10917062176 11344297984 1973773904 19.415 100 58 114 1 2009832592 19423792 16634896
14:40:31 7878 8192000000 10915309664 11347181568 1975107232 19.426 100 53 104 2 2008386544 17979616 15299696
14:40:48 4167 8192000000 10914224320 11340263424 1971111152 19.394 100 59 114 1 2005308576 18138048 16059376
14:40:58 7272 8192000000 10931683200 11349925888 1973944544 19.417 100 70 138 1 2013827040 19696480 20186016
14:41:13 6740 8192000000 10919196960 11340873728 1952322864 19.245 99 72 144 0 1993738912 20098160 21317888
14:41:27 4388 8192000000 10909405456 11338321920 1968376832 19.373 100 60 120 0 2006003616 20070224 17556560
14:41:38 4448 8192000000 10924774352 11347038208 1973666592 19.415 100 54 108 0 2009917152 19847536 16403024
14:41:50 11057 8192000000 10931074064 11357069312 1980592064 19.469 100 60 119 0 2018890688 20954768 17343856
14:42:09 10563 8192000000 10930040224 11363086336 1987210272 19.522 100 57 114 1 2026037968 21915920 16911776
14:42:31 13242 8192000000 10944176304 11370180608 1973996224 19.417 99 54 107 0 2009650416 19675680 15978512
14:42:52 4925 8192000000 10946371680 11373809664 1996687792 19.597 100 65 129 0 2040276064 24953152 18635120
14:43:04 6866 8192000000 10947767728 11386298368 1998582864 19.612 100 59 118 1 2041895808 25990736 17322208
14:43:19 3329 8192000000 10921346672 11341885440 1946286320 19.197 97 73 144 0 1986730112 18885152 21558640
14:43:29 10099 8192000000 10922134416 11348156416 1975294368 19.427 100 65 130 1 2015217808 20094352 19829088
14:43:48 5655 8192000000 10935783168 11363041280 1988535600 19.532 100 63 127 2 2027846096 20635472 18675024
14:44:01 3458 8192000000 10929357232 11359162368 1975149696 19.426 99 63 124 1 2012798576 18846992 18801888
14:44:11 6776 8192000000 10949511296 11368873984 1990247040 19.546 100 63 126 1 2029604432 19350064 20007328
14:44:27 12795 8192000000 10946317184 11375157248 1996914576 19.598 100 60 121 0 2036221008 20849776 18456656
14:44:48 4655 8192000000 10940442416 11364757504 1959507936 19.302 98 66 131 1 2001026304 21583760 19934608
14:45:01 7829 8192000000 10924889344 11355025408 1946623600 19.200 98 55 108 1 1984440448 21630736 16186112
14:45:20 11404 8192000000 10949218368 11370098688 1986498336 19.516 100 65 130 1 2029683600 23551856 19633408
14:45:39 4961 8192000000 10948158464 11375452160 1992846048 19.566 100 71 142 2 2036559968 22415456 21298464
14:45:54 2973 8192000000 10951160144 11376386048 1981787776 19.479 99 66 130 0 2023374224 22687120 18899328
14:46:04 5766 8192000000 10949484912 11382431744 1996361920 19.594 100 58 117 0 2037734528 23231632 18140976
14:46:16 4512 8192000000 10961556544 11389554688 2002123904 19.639 100 66 132 4 2045208144 23219168 19865072
14:46:28 2408 8192000000 10959569264 11379892224 1997437072 19.603 100 72 142 0 2043748976 24339680 21972224
14:46:38 2228 8192000000 10967327312 11381252096 2000533232 19.627 100 83 165 4 2050043024 23865936 25643856
14:46:47 9190 8192000000 10961156512 11383406592 1999586608 19.619 100 75 150 0 2047160848 25567088 22007152
14:47:04 7100 8192000000 10965752928 11391496192 2004858640 19.661 100 72 143 1 2052944368 26618112 21467616
14:47:28 4023 8192000000 10931471072 11354722304 1954019872 19.258 98 63 126 2 2000926560 27344640 19562048
14:47:40 3649 8192000000 10952056224 11370729472 1970823168 19.392 99 61 122 1 2016557360 26990080 18744112
14:47:50 3429 8192000000 10959030672 11378253824 1988557216 19.532 100 83 166 3 2043364448 28897456 25909776
14:48:01 8324 8192000000 10953588880 11370655744 1985275216 19.506 100 82 164 0 2039068720 28822368 24971136
14:48:19 2935 8192000000 10964414672 11378913280 1986380272 19.515 100 82 161 2 2042503136 30714720 25408144
14:48:30 4910 8192000000 10958636192 11376459776 1986125568 19.513 100 85 166 5 2042835568 31095008 25614992
14:48:44 4285 8192000000 10958315040 11376799744 1972831280 19.408 99 80 160 0 2028988960 31295200 24862480
14:48:58 4767 8192000000 10958314688 11383136256 1992387248 19.563 100 78 156 1 2046345200 29550080 24407872
14:49:10 4109 8192000000 10938308576 11355860992 1952289568 19.245 98 69 138 2 2002722992 29506096 20927328
14:49:23 3535 8192000000 10950432784 11371388928 1981334528 19.475 100 72 144 1 2034156016 30446880 22374608
14:49:36 5195 8192000000 10963405248 11388059648 1995029136 19.584 100 64 128 0 2046578000 31501856 20047008
14:49:49 2327 8192000000 10978965008 11395411968 2002873216 19.645 100 84 167 2 2061326944 31801712 26652016
14:49:58 2934 8192000000 10948379984 11357585408 1959066384 19.299 99 88 175 0 2018339936 33172176 26101376
14:50:09 2247 8192000000 10960883328 11375341568 1978394480 19.452 100 86 169 1 2037685728 33735936 25555312
14:50:19 2606 8192000000 10952343664 11370651648 1977477472 19.445 100 81 160 2 2037495104 35026688 24990944
14:50:30 2292 8192000000 10954029584 11368480768 1978948944 19.456 100 82 165 1 2034314256 30144640 25220672
14:50:39 4206 8192000000 10946984544 11358330880 1959941328 19.306 99 83 166 2 2013877920 28277488 25659104
14:50:51 2553 8192000000 10949153072 11360346112 1974188352 19.419 100 85 170 1 2030594960 30295776 26110832
14:51:01 2858 8192000000 10936651568 11349893120 1969295312 19.380 100 90 178 2 2026814704 29810032 27709360
14:51:12 2132 8192000000 10929975904 11337547776 1954811072 19.265 100 82 164 0 2007957824 27919664 25227088
14:51:21 7992 8192000000 10928373920 11341369344 1958887936 19.297 100 84 168 0 2013988544 29270352 25830256
14:51:36 6940 8192000000 10916906784 11326791680 1928773648 19.057 99 81 161 3 1983725872 29633104 25319120
14:51:50 2656 8192000000 10948221264 11350814720 1962318880 19.324 100 91 180 2 2023015360 32619984 28076496
14:51:59 2347 8192000000 10956553504 11361280000 1971911984 19.401 100 94 189 0 2038259328 36595664 29751680
14:52:07 2942 8192000000 10924593344 11347787776 1958707856 19.296 100 72 144 0 2017251392 36409808 22133728
14:52:18 3600 8192000000 10930805360 11345141760 1953189808 19.252 100 66 131 1 2010230624 36255584 20785232
14:52:29 3420 8192000000 10939791408 11358920704 1967821056 19.368 100 75 149 1 2029650160 37341200 24487904
14:52:40 6898 8192000000 10946636464 11360755712 1954643200 19.263 99 74 147 0 2017185072 39171472 23370400
14:52:54 2916 8192000000 10950523712 11365838848 1967826064 19.368 100 80 159 1 2034044128 40846672 25371392
14:53:03 1990 8192000000 10966193408 11375251456 1972172240 19.403 100 85 164 4 2040002224 41309504 26520480
14:53:13 2276 8192000000 10954490864 11374452736 1970883088 19.392 100 75 146 3 2036310592 40734032 24693472
14:53:22 9151 8192000000 10923680496 11367792640 1963964000 19.338 100 47 94 2 2019472656 39584816 15923840
14:53:43 9242 8192000000 10893554336 11332493312 1925753920 19.033 99 42 84 1 1975270368 35444928 14071520
14:54:00 7204 8192000000 10908032880 11331682304 1922773984 19.009 99 45 89 0 1973895072 35735536 15385552
14:54:14 13881 8192000000 10896208848 11339874304 1925828128 19.034 99 37 74 2 1979602416 40834640 12939648
14:54:40 5417 8192000000 10930904688 11352121344 1950555520 19.231 100 56 113 0 2010815824 40966224 19294080
14:54:53 2170 8192000000 10959251392 11366928384 1946214816 19.196 99 88 176 3 2022478704 47695312 28568576
14:55:02 8309 8192000000 10929383040 11363938304 1952252272 19.244 100 59 117 0 2014348896 43259184 18837440
14:55:21 4546 8192000000 10961158048 11377192960 1967842400 19.368 100 83 168 2 2037154768 43011616 26300752
14:55:32 6742 8192000000 10920270064 11356323840 1954375392 19.261 100 61 122 2 2014260528 39606848 20278288
14:55:52 4622 8192000000 10927294176 11349897216 1938309408 19.133 99 69 138 2 1997531024 36314640 22906976
14:56:03 10216 8192000000 10914284896 11361304576 1952952352 19.250 100 39 78 0 2006049664 38831072 14266240
14:56:28 11417 8192000000 10933646080 11364196352 1958870960 19.297 100 47 94 1 2013114832 37783792 16460080
14:56:46 9046 8192000000 10918013168 11351588864 1938300496 19.133 99 40 79 0 1986595072 34670336 13624240
14:57:02 17498 8192000000 10910078112 11362172928 1953043712 19.251 100 32 63 1 1996966128 32389392 11533024
14:57:39 31608 8192000000 10888353232 11334549504 1928228608 19.053 99 16 32 0 1964728992 30806544 5693840
14:58:21 36550 8192000000 10888673440 11337170944 1942109072 19.164 100 23 46 2 1967219568 17116848 7993648
14:59:08 40775 8192000000 10866123392 11331710976 1907172528 18.884 98 16 32 0 1934140256 21454640 5513088
15:00:22 46846 8192000000 10853395968 11307089920 1878864048 18.656 97 7 14 2 1890824688 9670576 2290064
15:01:21 64483 8192000000 10855948048 11305185280 1895788480 18.792 98 23 48 1 1912641680 9834080 7019120
15:02:43 60160 8192000000 10872393472 11332644864 1914783472 18.945 99 22 44 1 1933849456 12762976 6303008
15:03:52 129603 8192000000 10901009312 11367800832 1955641024 19.271 100 12 24 0 1972965360 14017328 3307008
15:06:33 143286 8192000000 10869616720 11329908736 1808992960 18.088 92 8 16 1 1823416256 12534864 1888432
15:09:03 143029 8192000000 10899861808 11372912640 1950379600 19.230 99 8 16 2 1964972592 12417312 2175680
15:11:33 84099 8192000000 10903984560 11375075328 1961737040 19.320 99 18 35 2 1981380560 14038096 5605424
15:13:08 109712 8192000000 10945691024 11390869504 1987756736 19.526 100 38 76 2 2012542848 13100880 11685232
15:15:07 26903 8192000000 10935216912 11393839104 1969822224 19.384 99 50 99 1 2005212416 20265136 15125056
15:15:44 17576 8192000000 10923561360 11377410048 1963679424 19.335 99 38 76 1 1989587840 15064624 10843792
15:16:13 90556 8192000000 10891638464 11366367232 1957368128 19.285 99 24 48 2 1984286640 19355696 7562816
15:17:50 5440 8192000000 10914637440 11380080640 1976334848 19.436 100 15 30 0 1999328080 19048336 3944896
15:18:09 56155 8192000000 10908668288 11376619520 1952026912 19.243 98 37 74 0 1977668416 14899936 10741568
15:19:13 28974 8192000000 10929487072 11388260352 1967726880 19.367 99 23 46 1 1990892912 15720336 7445696
15:19:52 39080 8192000000 10918896576 11364466688 1906929568 18.882 96 35 68 3 1932635440 15796512 9909360
15:20:44 51341 8192000000 10933630944 11387154432 1972691376 19.407 100 58 116 2 2016319920 27112624 16515920
15:21:50 33855 8192000000 10907122832 11395457024 1947956240 19.210 99 5 10 0 1978402240 28979040 1466960
15:22:35 7639 8192000000 10897711248 11397480448 1965994640 19.354 100 2 4 0 1988000592 21799200 206752
15:22:52 15029 8192000000 10909098256 11388653568 1973272672 19.411 100 16 32 2 1992611248 15307328 4031248
15:23:13 12907 8192000000 10903637072 11386683392 1973829232 19.416 100 8 17 1 1990194928 14617904 1747792
15:23:32 9258 8192000000 10902877072 11387908096 1976085936 19.434 100 8 16 1 1992657856 14568400 2003520
15:24:37 60850 8192000000 10885267968 11359797248 1925493504 19.031 98 12 24 0 1935813056 6371920 3947632
15:25:48 28091 8192000000 10901449456 11373293568 1973731216 19.415 100 13 26 0 1989696752 12412928 3552608
15:26:22 44579 8192000000 10898323264 11373547520 1971510912 19.397 100 8 17 0 1982908768 8594448 2803408
15:27:27 73901 8192000000 10872190912 11344048128 1856574576 18.475 94 18 37 2 1871439216 9515120 5349520
15:28:51 59718 8192000000 10870201968 11346546688 1945311760 19.189 100 13 26 3 1962174944 13214624 3648560
15:30:47 21995 8192000000 10894319856 11354701824 1941080544 19.155 99 27 54 0 1957377040 8910528 7385968
15:31:24 30069 8192000000 10855689952 11334635520 1899126976 18.819 97 16 31 1 1911686912 8481696 4078240
15:32:00 67117 8192000000 10816509248 11293106176 1821155488 18.187 94 15 30 0 1831846304 6552496 4138320
15:33:14 43053 8192000000 10827219792 11299336192 1819065600 18.170 95 12 24 1 1827884016 5779536 3038880
15:34:20 51995 8192000000 10837265776 11311276032 1861642688 18.517 97 10 20 1 1870510928 6303504 2564736
15:35:22 48126 8192000000 10850301296 11324014592 1893100240 18.771 98 13 26 3 1905458784 8561952 3796592
15:36:16 40408 8192000000 10840687920 11315871744 1854741184 18.461 96 22 44 0 1870305728 9256880 6307664
15:37:03 53632 8192000000 10859911072 11322155008 1874104816 18.617 97 15 30 2 1891885888 13187632 4593440
15:38:02 51306 8192000000 10849976336 11314810880 1874471232 18.620 97 21 42 3 1894183600 13845872 5866496
15:39:00 45001 8192000000 10855484688 11316342784 1874466288 18.620 97 17 34 1 1890161104 10841632 4853184
15:40:34 26232 8192000000 10862057504 11312574464 1890696128 18.751 98 46 92 2 1913676448 10223984 12756336
15:41:10 52552 8192000000 10847242592 11313459200 1862771904 18.526 97 16 30 2 1879346080 11004944 5569232
15:42:10 33832 8192000000 10860225104 11312336896 1876082208 18.633 97 25 50 2 1890927232 8301824 6543200
15:42:50 36228 8192000000 10863532192 11311243264 1899574992 18.823 99 28 55 0 1917604848 10108160 7921696
15:43:58 105449 8192000000 10883641520 11347324928 1903204912 18.852 98 14 28 2 1917711712 10667824 3838976
15:45:56 101473 8192000000 10876168016 11356479488 1892990880 18.770 97 10 20 1 1918495664 22929120 2575664
15:47:44 118165 8192000000 10863983248 11332272128 1924281104 19.021 99 20 39 2 1942351680 12039008 6031568
15:50:33 80669 8192000000 10875626032 11362668544 1932702416 19.088 99 15 30 1 1951945328 15129008 4113904
15:52:00 3192 8192000000 10891063472 11362476032 1961055936 19.314 100 44 84 2 1984189168 10747152 12386080
15:52:11 27848 8192000000 10871265584 11339563008 1905547424 18.871 97 39 78 0 1927326640 11016992 10762224
15:52:58 46140 8192000000 10861566320 11345018880 1926779520 19.041 99 10 20 1 1941764928 12135936 2849472
15:53:51 27142 8192000000 10861701696 11347095552 1946953504 19.202 100 6 12 0 1956310464 7870848 1486112
15:54:24 41007 8192000000 10869850176 11349901312 1945132496 19.188 100 12 21 1 1955407776 6249408 4025872
15:55:11 73644 8192000000 10872466688 11352453120 1935424496 19.110 99 16 32 2 1948236096 7451312 5360288
15:56:31 103319 8192000000 10859002128 11342716928 1899041136 18.819 97 11 23 0 1910299104 7679984 3577984
15:58:25 75805 8192000000 10866724528 11346636800 1932126736 19.084 99 19 37 0 1947705824 10324448 5254640
15:59:47 50143 8192000000 10885301264 11361009664 1954803664 19.265 100 17 34 0 1971859520 12358928 4696928
16:00:48 72019 8192000000 10911098256 11374686208 1964014384 19.338 100 18 36 2 1982097328 12181008 5901936
16:02:14 38596 8192000000 10900469376 11373363200 1962705568 19.328 100 32 64 0 1986142000 14338176 9098256
16:02:59 79252 8192000000 10888740816 11359244288 1913840032 18.937 97 8 16 0 1925496848 10023552 1633264
16:04:24 32231 8192000000 10896749072 11359453184 1910688080 18.912 97 18 36 1 1922528672 7242896 4597696
16:05:07 21381 8192000000 10900612880 11361013760 1944716752 19.184 99 30 60 2 1960256752 8136848 7403152
16:05:35 37601 8192000000 10883453872 11353063424 1945968096 19.194 99 29 58 1 1962714880 8460416 8286368
16:06:26 25223 8192000000 10901619808 11355631616 1928962704 19.059 98 25 45 4 1942356416 7230496 6163216
16:07:04 10865 8192000000 10926129696 11365834752 1967427056 19.365 100 69 140 0 1995641264 8697328 19516880
16:07:22 26768 8192000000 10923096384 11380502528 1972520528 19.405 100 46 92 2 1997130768 11920384 12689856
16:08:03 56168 8192000000 10917715264 11397496832 1970135920 19.387 100 44 88 0 2001700656 19251456 12313280
16:09:05 61044 8192000000 10904796800 11371208704 1913558576 18.935 97 14 26 1 1932027664 14684800 3784288
16:10:12 14726 8192000000 10926560528 11386830848 1975975712 19.433 100 37 75 2 1994938016 8789456 10172848
16:10:34 56990 8192000000 10893503280 11371270144 1954081488 19.259 99 19 38 1 1970845552 11700224 5063840
16:11:38 64262 8192000000 10905071248 11379372032 1916015840 18.955 97 13 26 1 1933944208 14394752 3533616
16:13:03 42417 8192000000 10853006768 11311091712 1826079792 18.227 93 27 54 0 1845213280 11920208 7213280
16:13:52 88208 8192000000 10876483392 11345334272 1939677056 19.144 100 26 52 2 1960147680 13554176 6916448
16:15:42 83475 8192000000 10855011088 11327025152 1857312528 18.481 95 28 56 1 1874516384 9453264 7750592
16:17:27 43062 8192000000 10844809056 11321245696 1911214480 18.916 99 17 34 1 1923683888 7651136 4818272
16:18:21 64296 8192000000 10845803104 11326898176 1899612864 18.823 98 11 22 0 1912881088 10036624 3231600
16:19:37 63903 8192000000 10858646880 11340771328 1903818480 18.857 98 9 17 0 1916200576 10213328 2168768
16:21:06 54805 8192000000 10855766752 11331309568 1884781376 18.704 97 21 40 2 1902475584 11446976 6247232
16:22:08 75599 8192000000 10839640096 11325345792 1855448080 18.466 96 14 28 1 1876421552 16760864 4212608
16:23:34 62043 8192000000 10839649856 11322130432 1863613680 18.533 97 21 43 0 1885099136 15331552 6153904
16:24:43 52692 8192000000 10858577232 11330174976 1904942768 18.866 99 27 54 1 1925919888 11857120 9120000
16:25:42 42214 8192000000 10860041584 11331301376 1898952064 18.818 98 22 44 0 1918553232 13084960 6516208
16:26:34 75254 8192000000 10862184704 11322081280 1832239616 18.278 95 20 40 0 1852368000 14043200 6085184
16:28:18 132214 8192000000 10873698608 11362828288 1899400736 18.821 98 13 26 2 1914121712 11146432 3574544
16:30:46 60004 8192000000 10888368944 11358904320 1925611840 19.032 99 17 34 0 1944023328 14113856 4297632
16:31:57 72845 8192000000 10906288736 11362164736 1936424592 19.118 99 17 34 1 1955123664 14125760 4573312

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 18-06-2021 16:34:06 to 18-06-2021 16:34:38.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 155 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-06-2021 16:34:39 to 18-06-2021 16:34:41.

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          257604
MON$OLDEST_ACTIVE               258903
MON$OLDEST_SNAPSHOT             258903
MON$NEXT_TRANSACTION            258903
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                       2052000
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Fri Jun 18 16:33:16 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Fri Jun 18 16:33:16 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
--- end of diff output ---

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

18.06.21 16:34:42. 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-06-18 16:34:45 No severe PSQL-related problems occured
18.06.21 16:34:46. End of report.