Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 09.11.2020 19: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 17388028 kB
MemAvailable 31478816 kB
Buffers 0 kB
Cached 14328280 kB
SwapCached 2820 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.7
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-09 19:26:59
DTS_END                         2020-11-09 19:26:59.7100
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57298
TRN_ID                          238326
ATT_ID                          661
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: 9317.42 19851 1118091
customer order: creation 174.23 332 20907
customer order: refuse 14.24 392 1709
order to supplier: creation 45.05 1301 5406
order to supplier: removal 3.72 89841 446
invoice (draft): creation 46.01 3409 5521
invoice (draft): removal 54.14 716 6497
invoice accept: apply 41.68 17968 5001
invoice accept: cancel 49.03 822 5883
customer reserve: creation 3799.75 180 455970
customer reserve: removal 4791.77 54 575013
realization accept: apply 83.70 214 10044
realization accept: cancel 85.23 111 10228
payment from customer: creation 59.14 133 7097
payment from customer: removal 5.58 92 669
payment to supplier: creation 49.12 134 5894
payment to supplier: removal 3.04 68 365
service: total inventory turnovers 4.52 952 542
service: total monetary turnovers 6.48 25 777
service: aggregate perf. data 0.98 15699 118
service: refresh index statistics 0.03 264574 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-11-2020 19:28:27 to 09-11-2020 19:28:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3336
TEST_TIME 2 3613
TEST_TIME 3 3048
TEST_TIME 4 3538
TEST_TIME 5 4338
TEST_TIME 6 4733
TEST_TIME 7 4807
TEST_TIME 8 4812
TEST_TIME 9 5645
TEST_TIME 10 5820
TEST_TIME 11 5814
TEST_TIME 12 6275
TEST_TIME 13 6153
TEST_TIME 14 6318
TEST_TIME 15 6548
TEST_TIME 16 6794
TEST_TIME 17 7001
TEST_TIME 18 7206
TEST_TIME 19 7226
TEST_TIME 20 7254
TEST_TIME 21 7400
TEST_TIME 22 7766
TEST_TIME 23 8288
TEST_TIME 24 8343
TEST_TIME 25 8752
TEST_TIME 26 9024
TEST_TIME 27 9200
TEST_TIME 28 9716
TEST_TIME 29 9732
TEST_TIME 30 9620
TEST_TIME 31 9476
TEST_TIME 32 9656
TEST_TIME 33 9633
TEST_TIME 34 9735
TEST_TIME 35 9864
TEST_TIME 36 9873
TEST_TIME 37 9917
TEST_TIME 38 9806
TEST_TIME 39 9591
TEST_TIME 40 9543
TEST_TIME 41 9774
TEST_TIME 42 9617
TEST_TIME 43 9573
TEST_TIME 44 9538
TEST_TIME 45 9487
TEST_TIME 46 9527
TEST_TIME 47 9632
TEST_TIME 48 9574
TEST_TIME 49 9495
TEST_TIME 50 9396
TEST_TIME 51 9356
TEST_TIME 52 9271
TEST_TIME 53 9196
TEST_TIME 54 9278
TEST_TIME 55 9314
TEST_TIME 56 9365
TEST_TIME 57 9319
TEST_TIME 58 9365
TEST_TIME 59 9361
TEST_TIME 60 9319
TEST_TIME 61 9413
TEST_TIME 62 9357
TEST_TIME 63 9405
TEST_TIME 64 9534
TEST_TIME 65 9611
TEST_TIME 66 9627
TEST_TIME 67 9569
TEST_TIME 68 9673
TEST_TIME 69 9562
TEST_TIME 70 9490
TEST_TIME 71 9504
TEST_TIME 72 9460
TEST_TIME 73 9404
TEST_TIME 74 9379
TEST_TIME 75 9329
TEST_TIME 76 9252
TEST_TIME 77 9202
TEST_TIME 78 9260
TEST_TIME 79 9257
TEST_TIME 80 9254
TEST_TIME 81 9262
TEST_TIME 82 9256
TEST_TIME 83 9363
TEST_TIME 84 9376
TEST_TIME 85 9361
TEST_TIME 86 9346
TEST_TIME 87 9345
TEST_TIME 88 9561
TEST_TIME 89 9557
TEST_TIME 90 9624
TEST_TIME 91 9530
TEST_TIME 92 9496
TEST_TIME 93 9462
TEST_TIME 94 9473
TEST_TIME 95 9440
TEST_TIME 96 9413
TEST_TIME 97 9389
TEST_TIME 98 9387
TEST_TIME 99 9400
TEST_TIME 100 9467
TEST_TIME 101 9429
TEST_TIME 102 9503
TEST_TIME 103 9469
TEST_TIME 104 9464
TEST_TIME 105 9510
TEST_TIME 106 9525
TEST_TIME 107 9505
TEST_TIME 108 9541
TEST_TIME 109 9557
TEST_TIME 110 9573
TEST_TIME 111 9517
TEST_TIME 112 9469
TEST_TIME 113 9420
TEST_TIME 114 9384
TEST_TIME 115 9383
TEST_TIME 116 9348
TEST_TIME 117 9317
TEST_TIME 118 9273
TEST_TIME 119 9314
TEST_TIME 120 9321
TEST_TIME 121 9244

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-11-2020 19:28:31 to 09-11-2020 19:28:34.

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 1540108 1540108 0 0.00 0 21076 6 0 0
doc_list_biud 1540108 1540108 0 0.00 0 47439 26 0 0
sp_add_invoice_to_stock 5163 5001 162 3.13 38 186078 17968 0 162
sp_cancel_adding_invoice 5883 5883 0 0.00 5 70894 822 0 0
sp_cancel_client_order 1709 1709 0 0.00 4 12725 392 0 0
sp_cancel_customer_reserve 575013 575013 0 0.00 1 47440 55 0 0
sp_cancel_pay_from_customer 669 669 0 0.00 3 6524 93 0 0
sp_cancel_pay_to_supplier 365 365 0 0.00 3 1932 69 0 0
sp_cancel_supplier_invoice 6511 6497 14 0.21 1 18102 717 0 14
sp_cancel_supplier_order 446 446 0 0.00 5 757193 89841 0 0
sp_cancel_write_off 10228 10228 0 0.00 1 21650 112 0 0
sp_client_order 20907 20907 0 0.00 3 29386 333 0 0
sp_customer_reserve 455970 455970 0 0.00 0 89154 180 0 0
sp_fill_shopping_cart 31823 31823 0 0.00 1 12932 39 0 0
sp_fill_shopping_cart_clo_res 455967 455967 0 0.00 0 20827 13 0 0
sp_get_clo_for_invoice 4996 4996 0 0.00 0 19679 273 0 0
sp_kill_cost_storno 17145 17145 0 0.00 0 6311 56 0 0
sp_kill_qstorno_ret_qs2qd 1167197 1167197 0 0.00 0 47420 29 0 0
sp_kill_qty_storno 614816 614816 0 0.00 0 47438 65 0 0
sp_lock_selected_doc 20696 20696 0 0.00 0 6516 5 0 0
sp_make_cost_storno 28031 28031 0 0.00 0 20980 63 0 0
sp_multiply_rows_for_pdistr 28031 28031 0 0.00 0 10671 30 0 0
sp_multiply_rows_for_qdistr 20907 20907 0 0.00 0 11999 147 0 0
sp_pay_from_customer 7097 7097 0 0.00 4 18373 134 0 0
sp_pay_to_supplier 5894 5894 0 0.00 5 14538 134 0 0
sp_payment_common 12991 12991 0 0.00 1 14106 38 0 0
sp_qd_handle_on_cancel_clo 1709 1709 0 0.00 0 12714 356 0 0
sp_qd_handle_on_invoice_upd_sts 10879 10879 0 0.00 0 32364 347 0 0
sp_qd_handle_on_reserve_upd_sts 10044 10044 0 0.00 0 21504 75 0 0
sp_reserve_write_off 10044 10044 0 0.00 6 21771 215 0 0
sp_supplier_invoice 5521 5521 0 0.00 6 81697 3409 0 0
sp_supplier_order 5406 5406 0 0.00 5 35640 1302 0 0
srv_aggregate_perf_data 118 118 0 0.00 2754 108860 15699 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 940 159349 31060 0 0
srv_find_qd_qs_mism 1070455 1070455 0 0.00 0 20971 5 0 0
srv_make_invnt_saldo 542 542 0 0.00 22 13736 952 0 0
srv_make_money_saldo 777 777 0 0.00 1 2245 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 76388 440632 264575 0 0
t$perf-abend:sp_add_invoice_to_stock 162 162 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5001 5001 0 0.00 0 7184 155 0 0
t$perf-norm:sp_cancel_adding_invoice 427 427 0 0.00 0 6086 107 0 0
t$perf-norm:sp_cancel_client_order 1709 1709 0 0.00 0 1540 8 0 0
t$perf-norm:sp_cancel_customer_reserve 665 665 0 0.00 0 2238 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 669 669 0 0.00 0 3982 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 365 365 0 0.00 0 95 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 394 394 0 0.00 0 619 13 0 0
t$perf-norm:sp_cancel_supplier_order 446 446 0 0.00 0 19982 1575 0 0
t$perf-norm:sp_cancel_write_off 981 981 0 0.00 0 2661 8 0 0
t$perf-norm:sp_client_order 20907 20907 0 0.00 0 6271 18 0 0
t$perf-norm:sp_customer_reserve 983 983 0 0.00 0 1135 5 0 0
t$perf-norm:sp_pay_from_customer 7098 7098 0 0.00 0 4215 9 0 0
t$perf-norm:sp_pay_to_supplier 5894 5894 0 0.00 0 4114 8 0 0
t$perf-norm:sp_reserve_write_off 10044 10044 0 0.00 0 6673 12 0 0
t$perf-norm:sp_supplier_invoice 5521 5521 0 0.00 0 5436 16 0 0
t$perf-norm:sp_supplier_order 5406 5406 0 0.00 0 7464 18 0 0
t$perf-norm:srv_aggregate_perf_data 118 118 0 0.00 0 805 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 1048 13 0 0
t$perf-norm:srv_make_invnt_saldo 542 542 0 0.00 0 1090 23 0 0
t$perf-norm:srv_make_money_saldo 777 777 0 0.00 0 902 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10316 9992 324 3.14 0 3647 19 0 324
v_all_customers 37918 37918 0 0.00 0 93 1 0 0
v_all_suppliers 30278 30278 0 0.00 0 14 1 0 0
v_all_wares 41814 41814 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 854 854 0 0.00 0 1978 9 0 0
v_cancel_client_order 3418 3418 0 0.00 0 4680 4 0 0
v_cancel_customer_prepayment 1338 1338 0 0.00 0 4659 18 0 0
v_cancel_customer_reserve 1330 1330 0 0.00 0 3642 6 0 0
v_cancel_payment_to_supplier 730 730 0 0.00 0 1918 9 0 0
v_cancel_supplier_invoice 816 788 28 3.43 0 3358 27 0 28
v_cancel_supplier_order 892 892 0 0.00 0 1146 4 0 0
v_cancel_write_off 1962 1962 0 0.00 0 3419 14 0 0
v_max_id_clo_ord 5406 5406 0 0.00 0 399 1 0 0
v_max_id_clo_res 983 983 0 0.00 0 3992 15 0 0
v_max_id_ord_sup 5510 5510 0 0.00 0 3657 5 0 0
v_max_non_paid_invoice 1671 1671 0 0.00 0 2569 5 0 0
v_max_non_paid_realizn 3744 3744 0 0.00 0 2295 5 0 0
v_min_id_clo_ord 5406 5406 0 0.00 0 11697 16 0 0
v_min_id_clo_res 983 983 0 0.00 0 2811 10 0 0
v_min_id_ord_sup 5510 5510 0 0.00 0 3649 4 0 0
v_min_non_paid_invoice 5894 5894 0 0.00 0 14098 27 0 0
v_min_non_paid_realizn 7097 7097 0 0.00 0 10650 27 0 0
v_our_firm 10602 10602 0 0.00 0 16 1 0 0
v_reserve_write_off 20086 20086 0 0.00 0 9237 8 0 0
x_lock_depdocs_on_canc_invoice 11986 11986 0 0.00 0 20559 113 0 0
x_lock_depdocs_on_canc_sup_ord 446 446 0 0.00 0 15978 468 0 0
x_make_qstorno_1000_1200 5406 5406 0 0.00 2 35610 1213 0 0
x_make_qstorno_1200_2000 5521 5521 0 0.00 2 81684 3278 0 0
x_make_qstorno_2100_3300 455970 455970 0 0.00 0 89153 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-11-2020 19:28:35 to 09-11-2020 19:28:39.

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
16:57:03 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:09 8144 8192000000 10173553632 10471075840 794275664 8.838 64 52 106 1 813235680 2071728 16888288
16:57:25 28102 8192000000 10319996480 10631208960 1355578560 14.198 100 85 170 0 1387650416 4302752 27769104
16:58:00 21270 8192000000 10345984944 10659610624 1401372736 14.607 100 90 180 0 1437416976 6057040 29987200
16:58:30 16571 8192000000 10368229264 10690318336 1419654448 14.770 100 92 184 1 1457159664 6860368 30644848
16:58:55 23401 8192000000 10390866672 10716524544 1448478944 15.024 100 83 166 0 1482851232 7452784 26919504
16:59:27 29415 8192000000 10421367200 10751918080 1468192016 15.198 100 89 178 0 1505656400 8295008 29169376
17:00:06 28777 8192000000 10435869472 10770857984 1485043872 15.346 100 86 172 1 1521690592 8758544 27888176
17:00:42 20721 8192000000 10459137968 10797891584 1505891024 15.528 100 78 156 1 1539990512 9193088 24906400
17:01:14 18777 8192000000 10488206512 10831126528 1542224800 15.843 100 81 162 1 1577678464 10027184 25426480
17:01:41 18257 8192000000 10516822224 10864103424 1566521376 16.052 100 81 161 1 1602482528 10686736 25274416
17:02:11 14214 8192000000 10555235936 10907611136 1605627664 16.387 100 83 166 0 1642459440 11276368 25555408
17:02:33 9370 8192000000 10565536448 10922987520 1621566272 16.523 100 86 171 1 1659432048 11594752 26271024
17:02:54 9963 8192000000 10581883936 10942701568 1643626336 16.710 100 80 160 1 1679360048 11835744 23897968
17:03:13 11535 8192000000 10597115760 10962825216 1657011936 16.824 100 78 156 1 1691390368 11424784 22953648
17:03:35 9586 8192000000 10631774208 10997350400 1683562800 17.047 100 74 147 0 1717021728 12014880 21444048
17:03:54 7127 8192000000 10635377712 11010957312 1703743616 17.216 100 72 144 1 1737696368 12775488 21177264
17:04:11 7303 8192000000 10667196064 11040636928 1722288048 17.371 100 74 146 3 1755426320 11811872 21326400
17:04:27 6607 8192000000 10669919008 11046244352 1734370992 17.472 100 70 140 0 1766725552 12006928 20347632
17:04:40 5682 8192000000 10686198528 11064512512 1749420144 17.597 100 81 162 2 1785424736 13249968 22754624
17:04:53 5160 8192000000 10695831968 11078078464 1757475296 17.663 100 77 154 0 1792930192 13820256 21634640
17:05:05 5031 8192000000 10708527280 11087265792 1764810480 17.724 100 79 159 0 1799690624 12583200 22296944
17:05:19 4628 8192000000 10722920848 11102236672 1777454016 17.829 100 76 148 1 1810047056 12172496 20420544
17:05:30 8937 8192000000 10710450976 11096367104 1783975232 17.882 100 77 154 3 1818652688 13038016 21639440
17:05:46 3877 8192000000 10730314496 11112751104 1792924576 17.956 100 86 172 1 1831320928 14279968 24116384
17:05:57 3141 8192000000 10744918912 11131854848 1803136400 18.040 100 80 160 1 1840810800 14404944 23269456
17:06:08 3469 8192000000 10747287168 11131437056 1814603600 18.134 100 87 173 1 1853082720 13955040 24524080
17:06:18 3106 8192000000 10765550336 11150258176 1827785776 18.241 100 95 192 3 1868701632 14115600 26800256
17:06:28 4321 8192000000 10772232304 11159883776 1831399216 18.271 100 77 154 0 1866976128 13266928 22309984
17:06:40 2789 8192000000 10780265568 11169665024 1843138992 18.366 100 89 179 2 1881859072 13559184 25160896
17:06:50 2600 8192000000 10789949888 11179323392 1846213312 18.391 100 92 184 2 1886246560 13609776 26423472
17:06:59 1961 8192000000 10788974528 11175047168 1849361248 18.417 100 91 182 1 1888367568 13569824 25436496
17:07:07 2177 8192000000 10795323008 11184529408 1852474352 18.442 100 89 177 1 1891703056 14481376 24747328
17:07:16 1902 8192000000 10791458016 11178414080 1855315648 18.465 100 90 181 1 1894372576 14043232 25013696
17:07:24 2815 8192000000 10798785888 11185639424 1855032464 18.463 100 90 178 0 1894426224 15053232 24340528
17:07:34 2698 8192000000 10795463520 11187916800 1857677872 18.484 100 93 185 3 1896263616 12126032 26459712
17:07:44 1649 8192000000 10805314304 11192606720 1857872144 18.486 100 85 170 0 1895157408 13764928 23520336
17:07:52 2098 8192000000 10813435200 11198984192 1864781120 18.542 100 94 188 1 1905671616 14451600 26438896
17:08:01 1534 8192000000 10809432864 11199062016 1863916912 18.535 100 90 180 2 1902834512 14177968 24739632
17:08:09 3161 8192000000 10815872336 11202498560 1866300752 18.554 100 95 190 4 1907563728 14309728 26953248
17:08:18 1691 8192000000 10816768656 11203899392 1869494608 18.580 100 94 189 1 1909880656 13421152 26964896
17:08:26 2090 8192000000 10811388752 11203436544 1869215728 18.578 100 90 179 1 1908305984 13761360 25328896
17:08:34 30764 8192000000 10819319936 11210571776 1873314032 18.611 100 72 145 1 1904147888 10595376 20238480
17:09:12 1361 8192000000 10819394032 11208708096 1874184608 18.618 100 94 190 4 1914030496 11983952 27861936
17:09:19 2085 8192000000 10787576688 11202596864 1869134528 18.577 100 52 103 2 1894168640 10264528 14769584
17:09:29 4031 8192000000 10792107008 11209641984 1874590176 18.621 100 43 85 1 1895607824 9104000 11913648
17:09:41 3978 8192000000 10804503648 11210522624 1876137264 18.634 100 49 98 1 1899254848 9907856 13209728
17:09:51 4752 8192000000 10800136416 11214884864 1874132544 18.618 100 41 82 2 1894413168 9059104 11221520
17:10:03 53139 8192000000 10779551584 11213398016 1874408448 18.620 100 24 46 1 1886766688 5278944 7079296
17:11:03 8677 8192000000 10789218208 11219034112 1874781536 18.623 100 22 44 1 1886975504 5935216 6258752
17:11:21 5761 8192000000 10795317664 11226214400 1882168432 18.683 100 28 56 1 1900474544 10831920 7474192
17:11:34 10526 8192000000 10798898368 11223629824 1881907456 18.681 100 27 57 2 1895770288 6255472 7607360
17:11:51 6368 8192000000 10807659776 11234938880 1887234272 18.723 100 25 50 1 1900021072 6075776 6711024
17:12:04 5883 8192000000 10801986832 11234000896 1897848560 18.809 100 33 66 1 1914137136 6673344 9615232
17:12:19 7624 8192000000 10800063168 11232960512 1893011056 18.770 100 24 46 1 1905837568 5844160 6982352
17:12:34 6306 8192000000 10815077616 11244892160 1898069440 18.811 100 22 44 2 1910207680 6257216 5881024
17:12:51 4996 8192000000 10816457808 11249696768 1900348032 18.829 100 26 52 3 1918510640 11203296 6959312
17:13:05 5575 8192000000 10818535024 11249762304 1900319008 18.829 100 26 52 2 1918365552 10980896 7065648
17:13:17 15343 8192000000 10809907024 11246854144 1903657712 18.856 100 17 34 3 1914790768 6099296 5033760
17:13:38 7464 8192000000 10812553392 11254095872 1905161104 18.868 100 20 40 3 1917219024 6524640 5533280
17:13:52 9945 8192000000 10827591136 11261390848 1911641312 18.920 100 26 51 2 1924973808 6063952 7268544
17:14:10 53171 8192000000 10848915488 11276599296 1921008960 18.995 100 46 93 2 1939779808 5247568 13523280
17:15:10 8712 8192000000 10825627632 11264045056 1897343504 18.805 99 16 32 0 1908315776 5308208 5664064
17:15:27 7072 8192000000 10833538208 11269386240 1915619760 18.952 100 27 54 2 1933048016 10319040 7109216
17:15:40 5774 8192000000 10832085168 11271335936 1920762704 18.993 100 28 56 1 1935647856 7123168 7761984
17:15:55 11748 8192000000 10838558464 11271577600 1920159952 18.988 100 26 52 4 1933259840 6332768 6767120
17:16:16 5772 8192000000 10843905216 11280850944 1904956448 18.866 99 25 50 0 1918418544 7045376 6416720
17:16:28 9324 8192000000 10843234992 11278184448 1922880560 19.010 100 23 46 2 1934741232 5754976 6105696
17:16:45 5021 8192000000 10834574560 11272388608 1920320720 18.989 100 23 46 1 1936977632 9873472 6783440
17:16:58 5966 8192000000 10835094240 11265658880 1901207504 18.836 99 21 42 0 1913303712 6233216 5862992
17:17:12 7249 8192000000 10786126704 11226865664 1871045408 18.593 98 17 34 2 1885811728 10325200 4441120
17:17:27 13283 8192000000 10796657472 11230019584 1830982160 18.267 96 16 30 1 1840783632 4929168 4872304
17:17:46 10009 8192000000 10793062944 11227381760 1852563184 18.443 98 21 42 1 1863646832 4986144 6097504
17:18:03 14014 8192000000 10794228752 11220193280 1821928752 18.193 96 24 48 2 1835374512 6672592 6773168
17:18:25 11399 8192000000 10753877120 11166244864 1734996704 17.477 93 17 35 1 1744918608 4242768 5679136
17:18:46 53523 8192000000 10714329936 11141287936 1697169920 17.161 92 25 50 2 1709368496 4962752 7235824
17:19:46 9130 8192000000 10715533936 11130064896 1737694256 17.499 95 21 42 1 1748938096 5411648 5832192
17:20:04 7740 8192000000 10728180992 11145330688 1784080064 17.883 98 33 63 3 1799539072 7001552 8457456
17:20:19 5118 8192000000 10703923776 11115008000 1757900576 17.667 97 30 60 0 1772057184 6687536 7469072
17:20:32 7319 8192000000 10712404176 11126747136 1767070416 17.743 98 38 76 1 1784158128 6417648 10670064
17:20:49 6848 8192000000 10690306032 11107737600 1735335632 17.480 97 25 51 0 1749114128 5661696 8116800
17:21:03 8024 8192000000 10711776960 11123363840 1748124768 17.586 97 28 56 0 1761853280 5645840 8082672
17:21:17 8986 8192000000 10694575936 11115769856 1742145696 17.536 97 24 49 2 1754402336 5280512 6976128
17:21:32 7331 8192000000 10723060752 11143524352 1810940128 18.104 100 32 64 2 1826698544 6768704 8989712
17:21:48 11157 8192000000 10704355408 11115618304 1747423184 17.580 97 19 38 2 1758037776 5102240 5512352
17:22:05 8025 8192000000 10723715344 11139579904 1792770304 17.955 99 23 46 2 1805043968 5557344 6716320
17:22:19 8346 8192000000 10719271984 11134922752 1778888976 17.840 98 27 54 1 1791762128 4945184 7927968
17:22:35 9588 8192000000 10720768816 11147722752 1812572256 18.117 100 11 20 0 1820512224 5125888 2814080
17:22:52 10202 8192000000 10752462912 11171631104 1825100160 18.219 100 20 40 1 1841077824 10315776 5661888
17:23:08 26055 8192000000 10746590208 11175346176 1834418592 18.295 100 20 39 3 1845432832 5143808 5870432
17:24:16 21096 8192000000 10747029296 11176185856 1837825168 18.323 100 21 41 2 1848963056 5809792 5328096
17:24:46 6911 8192000000 10758989648 11184033792 1846439488 18.393 100 23 46 0 1859261056 6499984 6321584
17:25:01 10503 8192000000 10763252848 11191259136 1848615968 18.411 100 9 18 0 1856368304 5379360 2372976
17:25:22 6482 8192000000 10762789264 11185078272 1837307376 18.319 99 35 70 4 1854180512 7374624 9498512
17:25:38 7853 8192000000 10770421600 11196162048 1853469376 18.450 100 25 50 1 1865618160 4964352 7184432
17:25:56 8053 8192000000 10770736320 11197538304 1855226560 18.465 100 20 39 3 1866523008 5025776 6270672
17:26:10 10059 8192000000 10780162864 11204399104 1859958864 18.503 100 20 40 1 1872367008 6088608 6319536
17:26:26 17296 8192000000 10770844336 11203223552 1863327040 18.530 100 23 46 5 1874498944 5235232 5936672
17:26:51 11358 8192000000 10792958768 11215609856 1865448432 18.547 100 21 42 2 1878050224 6470736 6131056
17:27:11 22294 8192000000 10822784272 11234320384 1883813216 18.696 100 42 82 0 1900182848 5088320 11281312
17:27:43 8507 8192000000 10825436176 11248467968 1901020752 18.835 100 47 94 0 1921612672 7168816 13423104
17:28:01 7568 8192000000 10837075680 11254009856 1908181056 18.892 100 39 78 0 1926382592 7236464 10965072
17:28:16 52195 8192000000 10850818768 11273633792 1918807376 18.977 100 55 110 0 1944193472 9522272 15863824
17:29:18 90180 8192000000 10864301840 11291418624 1930752944 19.073 100 50 100 2 1957851456 11810800 15287712
17:31:06 6523 8192000000 10876765856 11301679104 1944086768 19.179 100 60 118 4 1973754288 12019152 17648368
17:31:20 15220 8192000000 10888328192 11312095232 1945049584 19.187 100 44 89 0 1973402768 15309296 13043888
17:32:11 26211 8192000000 10875952608 11316396032 1952087360 19.243 100 32 64 2 1975223456 13422416 9713680
17:32:51 14123 8192000000 10888853088 11322191872 1959121168 19.299 100 45 89 1 1988999072 16076032 13801872
17:33:22 15735 8192000000 10898190992 11336835072 1963572688 19.334 100 40 80 3 1996208416 21195424 11440304
17:33:49 6559 8192000000 10916901584 11336380416 1974345152 19.420 100 70 140 2 2014854768 17964864 22544752
17:34:03 5154 8192000000 10914549168 11339616256 1972749616 19.407 100 68 135 3 2008292080 15655200 19887264
17:34:16 4399 8192000000 10925166864 11343200256 1973233104 19.411 100 59 116 0 2005648288 15550656 16864528
17:34:35 7054 8192000000 10926344160 11349086208 1961658688 19.319 99 69 133 3 1999136192 17470784 20006720
17:34:54 15322 8192000000 10918981632 11355078656 1980335424 19.467 100 61 120 3 2020270496 22631664 17303408
17:35:19 4329 8192000000 10925867152 11356430336 1985332432 19.507 100 56 110 1 2017021792 15371024 16318336
17:35:32 7202 8192000000 10925796992 11357773824 1986134400 19.513 100 54 107 4 2015988800 14690048 15164352
17:35:48 10433 8192000000 10925924208 11361894400 1991351248 19.554 100 48 92 0 2019833936 14594176 13888512
17:36:06 5581 8192000000 10942521312 11370659840 1997455552 19.603 100 62 125 0 2030995184 15458800 18080832
17:36:19 3140 8192000000 10936927856 11366117376 1979904896 19.464 99 63 124 0 2013321280 15073120 18343264
17:36:30 3571 8192000000 10938219552 11369353216 1995539040 19.588 100 64 128 1 2028599744 15438480 17622224
17:36:43 9433 8192000000 10944932512 11362922496 1989419008 19.539 100 66 131 0 2025092352 15998528 19674816
17:36:59 1889 8192000000 10960107840 11372212224 2000660144 19.628 100 83 162 0 2042692992 18031104 24001744
17:37:08 5612 8192000000 10957010944 11370065920 1995322864 19.586 100 78 156 2 2037766768 20046352 22397552
17:37:25 3271 8192000000 10928528400 11348000768 1957220688 19.284 98 72 142 0 1999892496 21312912 21358896
17:37:37 11077 8192000000 10919955520 11343921152 1960293904 19.308 99 76 152 1 2003821424 21556752 21970768
17:38:07 3308 8192000000 10940087984 11359420416 1983084480 19.489 100 73 146 1 2025665104 21646624 20934000
17:38:22 6159 8192000000 10927624080 11347116032 1967474992 19.365 99 79 155 2 2006422672 16096112 22851568
17:38:35 9360 8192000000 10922610176 11350360064 1982103792 19.481 100 56 112 2 2015130352 16230368 16796192
17:38:58 20354 8192000000 10917619856 11350593536 1965798944 19.352 99 51 100 2 1997754704 16787776 15167984
17:39:34 14321 8192000000 10922153312 11359645696 1977629024 19.446 100 46 92 2 2012978976 21456944 13893008
17:39:57 5310 8192000000 10933005968 11370565632 1986527680 19.516 100 46 92 1 2023288912 22806112 13955120
17:40:16 9123 8192000000 10960723088 11375820800 1994640736 19.580 100 60 117 3 2031462480 18977856 17843888
17:40:40 2588 8192000000 10969031728 11382927360 2004118064 19.655 100 77 155 2 2044984448 17355376 23511008
17:40:51 6923 8192000000 10952116288 11371245568 1980163056 19.466 99 69 138 0 2025088032 24084032 20840944
17:41:07 7630 8192000000 10951714864 11379044352 1998256656 19.609 100 61 120 3 2038589248 21301984 19030608
17:41:23 10721 8192000000 10955971040 11388579840 2001386016 19.634 100 57 114 2 2044800064 25714240 17699808
17:41:42 3339 8192000000 10942196528 11368984576 1983130144 19.489 99 65 128 1 2024808560 21627760 20050656
17:41:53 5787 8192000000 10961093088 11385856000 2002540704 19.643 100 57 112 1 2039202432 19119088 17542640
17:42:09 7060 8192000000 10955545696 11387113472 1994220800 19.577 99 62 122 2 2034004848 20281472 19502576
17:42:26 2090 8192000000 10949463568 11378200576 1989291488 19.538 99 70 135 4 2034901200 23834000 21775712
17:42:35 4583 8192000000 10949973888 11375706112 1968343248 19.372 98 65 130 1 2011747728 22918224 20486256
17:42:48 2985 8192000000 10951242672 11379658752 1998428832 19.610 100 72 143 1 2042282832 21875120 21978880
17:42:59 3145 8192000000 10967833648 11388510208 2005194672 19.664 100 76 148 3 2052175840 24043024 22938144
17:43:10 6701 8192000000 10942797424 11376332800 1975845056 19.432 99 60 120 0 2021804976 26707584 19252336
17:43:26 7301 8192000000 10947792272 11368886272 1977411392 19.444 100 56 111 3 2022722176 27409584 17901200
17:43:42 4387 8192000000 10927959024 11357913088 1956576192 19.279 99 62 125 0 2005587152 29506544 19504416
17:43:57 2711 8192000000 10949805536 11379036160 1985658544 19.509 100 61 123 0 2032866224 26849600 20358080
17:44:09 2591 8192000000 10933380480 11363192832 1973090016 19.410 100 57 113 0 2019640576 27975120 18575440
17:44:19 3280 8192000000 10946103248 11358502912 1972130240 19.402 99 73 148 1 2022997632 27984304 22883088
17:44:31 6890 8192000000 10947096080 11366301696 1973207104 19.411 99 77 154 2 2026654384 29212592 24234688
17:44:46 4770 8192000000 10957387392 11379404800 1986425664 19.516 100 66 132 1 2037482960 30030000 21027296
17:45:01 2868 8192000000 10964209616 11383455744 1992626992 19.565 100 85 170 1 2047628768 28278464 26723312
17:45:11 2159 8192000000 10969896880 11384586240 1999318432 19.617 100 88 176 0 2053048896 26487312 27243152
17:45:21 8022 8192000000 10956705376 11380236288 1981239328 19.475 99 70 140 0 2030186080 27426288 21520464
17:45:39 1338 8192000000 10972902224 11386294272 1998772864 19.613 100 88 177 0 2054642912 28462736 27407312
17:45:48 4803 8192000000 10969722304 11388432384 1995627984 19.588 100 83 164 0 2051093936 30090304 25375648
17:46:01 2520 8192000000 10945790800 11365449728 1978092160 19.450 100 79 158 2 2033255760 29885120 25278480
17:46:14 1873 8192000000 10946803744 11355635712 1969196624 19.379 99 80 155 2 2024921728 31596864 24128240
17:46:24 3391 8192000000 10962028192 11379630080 1989399248 19.539 100 78 156 0 2046646032 32487744 24759040
17:46:34 5689 8192000000 10958190624 11374944256 1971269712 19.396 99 78 155 0 2029436944 33461168 24706064
17:46:48 3301 8192000000 10961046560 11383455744 1986074752 19.513 100 69 138 1 2043146064 34653920 22417392
17:46:59 2817 8192000000 10964359744 11381624832 1986874768 19.519 100 80 160 1 2046311456 34632000 24804688
17:47:09 3008 8192000000 10951203616 11365298176 1954427936 19.262 98 83 164 0 2014637824 34801680 25408208
17:47:20 1689 8192000000 10963764112 11378917376 1983275040 19.491 100 76 151 1 2041354672 33811168 24268464
17:47:33 1745 8192000000 10967468928 11381420032 1987204160 19.522 100 82 163 1 2047551792 35158208 25189424
17:47:43 3489 8192000000 10961936272 11375009792 1975591568 19.430 100 83 167 3 2038141744 36314912 26235264
17:47:55 1746 8192000000 10972335344 11392167936 1989928912 19.543 100 86 171 1 2055629552 38344128 27356512
17:48:07 4758 8192000000 10950242576 11383808000 1978494064 19.453 100 51 102 1 2034706656 38775904 17436688
17:48:22 6285 8192000000 10955679600 11386167296 1982589392 19.485 100 55 107 2 2038644992 37848672 18206928
17:48:39 3886 8192000000 10957667664 11383832576 1974910000 19.424 100 68 137 0 2038625232 40748896 22966336
17:48:52 9957 8192000000 10915617280 11352535040 1953812832 19.257 100 51 102 0 2012049072 40504320 17731920
17:49:16 14806 8192000000 10897710688 11333361664 1930219872 19.069 99 41 82 4 1975906640 32020880 13665888
17:49:40 9962 8192000000 10880286672 11324702720 1929723920 19.065 100 36 72 0 1972399920 30130912 12545088
17:50:18 939 8192000000 10915073456 11341623296 1948435264 19.214 100 58 117 1 1998551984 30831376 19285344
17:50:26 46895 8192000000 10894251840 11323310080 1924960016 19.027 99 53 106 0 1977944384 35210320 17774048
17:51:20 10728 8192000000 10902983168 11354054656 1945157248 19.188 100 39 78 1 1992599696 34335680 13106768
17:51:42 35722 8192000000 10874604160 11340865536 1923888560 19.018 99 24 48 1 1961984192 29903136 8192496
17:52:32 21253 8192000000 10872841424 11331219456 1911683312 18.920 99 21 42 4 1943843728 25495136 6665280
17:53:20 29687 8192000000 10869511888 11316867072 1905668464 18.872 99 22 45 0 1940406896 26929904 7808528
17:53:57 22202 8192000000 10830463824 11276308480 1883774864 18.696 98 18 35 1 1919458032 29802112 5881056
17:54:26 14420 8192000000 10864080640 11318751232 1917831568 18.969 100 18 36 2 1950774688 26964944 5978176
17:54:52 48341 8192000000 10846922384 11313061888 1881413312 18.677 98 11 22 0 1905485440 20962976 3109152
17:56:11 21694 8192000000 10842412608 11289530368 1890133440 18.747 98 48 96 1 1920157904 16244384 13780080
17:56:46 63036 8192000000 10844871136 11288662016 1851554304 18.435 97 20 38 3 1870338224 13652976 5130944
17:58:09 60121 8192000000 10870751120 11325583360 1913677776 18.936 99 27 52 5 1934706368 13290160 7738432
17:59:22 110862 8192000000 10877311200 11342319616 1910499200 18.911 98 18 36 1 1932409056 17097728 4812128
18:01:19 60154 8192000000 10874681184 11335827456 1914705648 18.944 98 7 14 0 1925763456 9524576 1533232
18:02:26 51934 8192000000 10879086736 11347640320 1932446624 19.086 99 10 20 0 1953553136 18538976 2567536
18:03:28 74315 8192000000 10906827184 11353296896 1957430640 19.286 100 31 62 2 1983728176 17559936 8737600
18:04:52 93574 8192000000 10910303136 11361460224 1930476960 19.071 98 36 73 2 1952243200 11378480 10387760
18:07:43 89500 8192000000 10892933776 11342987264 1953247184 19.252 99 43 85 1 1973687424 8340704 12099536
18:09:19 23822 8192000000 10911450912 11366035456 1975899456 19.432 100 41 82 0 1997238864 9693552 11645856
18:09:50 24394 8192000000 10906156320 11368988672 1976699120 19.439 100 20 40 0 1992198432 8985696 6513616
18:10:25 7746 8192000000 10921391168 11374878720 1983877760 19.495 100 49 98 2 2005051424 6790064 14383600
18:10:46 28857 8192000000 10924261440 11372699648 1967228944 19.363 99 44 88 1 1993114624 12566432 13319248
18:11:29 34757 8192000000 10921517664 11387547648 1981421824 19.476 100 55 110 0 2015972752 18089936 16460992
18:12:19 44252 8192000000 10893876544 11371692032 1969017088 19.378 100 12 24 0 1986764080 13632864 4114128
18:13:09 23779 8192000000 10887061904 11379892224 1964877488 19.345 100 4 8 1 1983028224 16834448 1316288
18:13:45 4207 8192000000 10888335888 11370995712 1967536064 19.366 100 12 24 2 1979317088 8895904 2885120
18:13:55 8774 8192000000 10888564048 11369127936 1968204992 19.371 100 15 30 2 1979853440 7742592 3905856
18:14:28 41618 8192000000 10899416048 11372380160 1979427408 19.460 100 15 30 2 1992120560 8169680 4523472
18:15:34 31707 8192000000 10890511712 11370450944 1975280848 19.427 100 13 27 1 1994904128 15864480 3758800
18:18:48 51074 8192000000 10893202576 11372580864 1911733664 18.921 96 11 22 0 1930925920 15927968 3264288
18:19:45 37666 8192000000 10890014976 11384823808 1974448864 19.421 100 6 12 0 1989719904 13725072 1545968
18:20:36 70983 8192000000 10907988000 11401416704 1966194672 19.355 99 11 22 0 1980469600 11111984 3162944
18:21:55 29385 8192000000 10904922816 11375902720 1969141888 19.379 99 26 52 1 1989596944 12554656 7900400
18:22:32 53908 8192000000 10900272720 11354755072 1897778944 18.808 96 27 54 1 1914090288 8416832 7894512
18:23:37 23583 8192000000 10885285248 11342848000 1937984368 19.131 99 40 80 3 1958409664 9377472 11047824
18:24:10 8252 8192000000 10893687728 11347914752 1946260192 19.197 99 38 76 0 1966019392 9065984 10693216
18:24:25 17577 8192000000 10902117472 11360067584 1966928352 19.361 100 44 87 1 1989087184 10319376 11839456
18:24:48 50152 8192000000 10896137760 11365392384 1931914624 19.082 98 27 52 1 1951394096 12231040 7248432
18:25:45 31053 8192000000 10906055568 11365785600 1956077488 19.275 99 28 56 0 1972361936 8932096 7352352
18:26:25 29933 8192000000 10920338368 11374661632 1960955872 19.314 99 50 100 1 1989939072 15351824 13631376
18:27:02 65794 8192000000 10899507568 11363282944 1903884688 18.858 96 27 55 2 1923270512 11753088 7632736
18:28:19 38655 8192000000 10898413728 11351953408 1910010528 18.907 96 42 84 2 1937231392 14953360 12267504
18:29:03 76391 8192000000 10907896912 11380191232 1963681152 19.335 100 22 44 0 1990405712 20475312 6249248
18:30:26 42777 8192000000 10914998880 11381846016 1953920272 19.258 99 16 31 1 1973057840 14417168 4720400
18:31:15 100658 8192000000 10861046288 11329134592 1787994064 17.915 91 6 12 0 1801455712 11783504 1678144
18:33:03 59189 8192000000 10875140288 11339358208 1905964256 18.874 98 9 18 0 1927865744 18999888 2901600
18:34:11 78965 8192000000 10877522928 11323457536 1930069456 19.067 100 17 34 0 1952811664 17262192 5480016
18:35:48 57165 8192000000 10876156032 11341606912 1936038688 19.115 99 25 50 0 1950176128 7602240 6535200
18:36:52 10545 8192000000 10880367184 11338817536 1934469696 19.103 99 35 70 0 1953910992 10030720 9410576
18:37:08 32172 8192000000 10841022496 11314970624 1914459072 18.942 99 25 49 2 1930777088 9272656 7045360
18:37:50 33337 8192000000 10833787056 11301224448 1898607920 18.815 99 12 24 1 1909914128 7961728 3344480
18:38:37 25367 8192000000 10824762704 11294838784 1887953936 18.729 98 7 14 1 1895852608 6085552 1813120
18:39:09 51509 8192000000 10825928896 11295821824 1863884752 18.535 97 8 16 1 1872703072 6068288 2750032
18:40:06 45334 8192000000 10818630288 11296702464 1905624976 18.872 100 7 14 0 1914253968 6948544 1680448
18:40:58 41086 8192000000 10808477216 11267006464 1844437120 18.377 97 17 33 0 1856412704 6953360 5022224
18:41:47 78970 8192000000 10844235040 11311337472 1891112128 18.755 99 21 42 1 1907099088 9905040 6081920
18:43:15 48914 8192000000 10834819024 11305545728 1896906976 18.801 99 10 20 2 1911141232 11563792 2670464
18:44:15 63742 8192000000 10835985152 11301523456 1821911216 18.193 95 16 32 1 1836420880 9843760 4665904
18:45:34 23080 8192000000 10835088912 11296137216 1881442544 18.677 98 29 56 2 1897610896 7818336 8350016
18:46:04 27735 8192000000 10861078416 11318939648 1903934864 18.858 99 31 62 2 1927337296 14032336 9370096
18:46:39 54421 8192000000 10863483280 11317379072 1871262496 18.594 97 26 52 1 1893596096 14988496 7345104
18:47:49 70255 8192000000 10854066832 11321139200 1889672672 18.743 98 21 42 2 1913163184 17233840 6256672
18:49:06 64927 8192000000 10861859136 11344891904 1933331248 19.094 100 16 32 2 1949618160 11930528 4356384
18:50:19 64381 8192000000 10881631376 11344277504 1923312816 19.013 99 16 32 1 1938057152 9994352 4749984
18:51:33 43911 8192000000 10897138960 11362791424 1940111776 19.148 99 32 64 1 1966505728 16596928 9797024
18:52:27 34107 8192000000 10908575360 11356794880 1923520720 19.015 98 40 80 1 1954671872 19599040 11552112
18:53:09 59285 8192000000 10898092720 11368083456 1939285760 19.141 99 27 54 1 1968928768 21571904 8071104
18:54:16 95158 8192000000 10876116160 11352604672 1904073584 18.859 98 9 18 0 1929344672 22387312 2883776
18:56:10 65685 8192000000 10869032912 11338280960 1911039584 18.915 98 19 39 2 1930014496 13283952 5690960
18:58:36 82518 8192000000 10891245216 11368202240 1970495408 19.389 100 23 46 0 1986833648 10152320 6185920
19:00:05 33299 8192000000 10894824640 11370582016 1974798640 19.423 100 10 20 0 1986213136 9192672 2221824
19:00:49 73525 8192000000 10884778544 11370860544 1953792736 19.257 99 11 22 1 1967380880 10707056 2881088
19:02:09 62456 8192000000 10913359824 11387932672 1975762656 19.431 100 16 32 0 1995309008 15383744 4162608
19:03:18 89082 8192000000 10907720384 11387293696 1951726448 19.240 98 20 40 1 1972314752 14633648 5954656
19:04:56 89807 8192000000 10910949344 11386216448 1959366224 19.301 99 23 46 2 1982379904 16524048 6489632
19:06:40 85100 8192000000 10916017904 11404337152 1966310592 19.356 99 8 17 0 1986439040 17821088 2307360
19:08:12 74859 8192000000 10914161264 11391897600 1950273600 19.229 98 9 18 2 1970015296 17403984 2337712
19:10:10 19614 8192000000 10932667168 11387207680 1980644704 19.470 100 52 104 1 2008597952 12608048 15345200
19:10:43 24216 8192000000 10937286256 11371114496 1962788336 19.328 99 46 87 0 1983265488 9027456 11449696
19:11:15 27808 8192000000 10919612384 11392409600 1982231936 19.482 100 33 66 1 2003405504 11616752 9556816
19:11:50 57779 8192000000 10910446064 11380883456 1923707152 19.017 97 16 30 2 1943290256 15632032 3951072
19:12:56 73948 8192000000 10928718672 11397439488 1965639920 19.351 99 22 45 0 1991112080 19654800 5817360
19:14:18 64914 8192000000 10901004272 11370811392 1888574848 18.734 95 16 32 0 1907684752 14762384 4347520
19:15:29 43474 8192000000 10888784720 11367391232 1947120512 19.204 99 17 34 2 1965246464 13242960 4882992
19:16:21 159348 8192000000 10901576096 11378204672 1939908608 19.146 98 15 30 2 1957910880 13544608 4457664
19:19:24 87343 8192000000 10886073440 11361271808 1903139104 18.852 96 17 34 0 1919545760 11570544 4836112
19:21:07 80734 8192000000 10837488736 11315720192 1884956064 18.705 96 9 17 0 1895356400 7998688 2401648
19:22:34 35385 8192000000 10866850944 11354701824 1940744784 19.153 100 7 14 0 1952579888 9832800 2002304
19:23:17 30389 8192000000 10856879824 11332661248 1925495680 19.031 99 18 36 0 1945899760 14663840 5740240
19:23:56 63252 8192000000 10874274192 11356143616 1948776960 19.217 100 9 18 0 1967446704 16179952 2489792
19:25:32 73136 8192000000 10841110976 11320635392 1875923872 18.632 96 12 24 2 1891590880 12342704 3324304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 09-11-2020 19:28:41 to 09-11-2020 19:29:13.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 162 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-11-2020 19:29:14 to 09-11-2020 19:29:16.

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          238632
MON$OLDEST_ACTIVE               238633
MON$OLDEST_SNAPSHOT             238633
MON$NEXT_TRANSACTION            238633
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                       2031584
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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'

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