Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.11.2020 22:29
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 17425652 kB
MemAvailable 31544060 kB
Buffers 0 kB
Cached 14298472 kB
SwapCached 6104 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-18 22:27:06
DTS_END                         2020-11-18 22:27:06.1720
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/59726
TRN_ID                          233291
ATT_ID                          650
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: 9215.72 23851 1105886
customer order: creation 164.40 396 19728
customer order: refuse 13.90 377 1668
order to supplier: creation 43.36 1349 5203
order to supplier: removal 3.27 101176 392
invoice (draft): creation 44.64 3291 5357
invoice (draft): removal 53.17 782 6380
invoice accept: apply 40.23 18437 4827
invoice accept: cancel 48.59 792 5831
customer reserve: creation 3755.48 180 450657
customer reserve: removal 4757.37 55 570884
realization accept: apply 82.14 180 9857
realization accept: cancel 85.48 102 10258
payment from customer: creation 56.18 137 6742
payment from customer: removal 5.85 82 702
payment to supplier: creation 47.10 134 5652
payment to supplier: removal 3.13 82 375
service: total inventory turnovers 4.33 1456 519
service: total monetary turnovers 6.18 32 741
service: aggregate perf. data 0.91 19873 109
service: refresh index statistics 0.03 328109 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-11-2020 22:29:35 to 18-11-2020 22:29:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1696
TEST_TIME 2 2731
TEST_TIME 3 3450
TEST_TIME 4 3946
TEST_TIME 5 4064
TEST_TIME 6 4367
TEST_TIME 7 4886
TEST_TIME 8 4858
TEST_TIME 9 5802
TEST_TIME 10 6376
TEST_TIME 11 6347
TEST_TIME 12 6358
TEST_TIME 13 6581
TEST_TIME 14 6677
TEST_TIME 15 6817
TEST_TIME 16 6936
TEST_TIME 17 7381
TEST_TIME 18 7903
TEST_TIME 19 8176
TEST_TIME 20 8629
TEST_TIME 21 8847
TEST_TIME 22 9214
TEST_TIME 23 9243
TEST_TIME 24 9411
TEST_TIME 25 9949
TEST_TIME 26 10176
TEST_TIME 27 10840
TEST_TIME 28 10905
TEST_TIME 29 10737
TEST_TIME 30 10568
TEST_TIME 31 10343
TEST_TIME 32 10426
TEST_TIME 33 10373
TEST_TIME 34 10384
TEST_TIME 35 10260
TEST_TIME 36 10132
TEST_TIME 37 9939
TEST_TIME 38 10078
TEST_TIME 39 9995
TEST_TIME 40 10003
TEST_TIME 41 9955
TEST_TIME 42 9785
TEST_TIME 43 9753
TEST_TIME 44 9764
TEST_TIME 45 9709
TEST_TIME 46 9577
TEST_TIME 47 9596
TEST_TIME 48 9600
TEST_TIME 49 9482
TEST_TIME 50 9398
TEST_TIME 51 9283
TEST_TIME 52 9214
TEST_TIME 53 9232
TEST_TIME 54 9329
TEST_TIME 55 9360
TEST_TIME 56 9437
TEST_TIME 57 9407
TEST_TIME 58 9366
TEST_TIME 59 9449
TEST_TIME 60 9409
TEST_TIME 61 9482
TEST_TIME 62 9631
TEST_TIME 63 9638
TEST_TIME 64 9714
TEST_TIME 65 9741
TEST_TIME 66 9802
TEST_TIME 67 9719
TEST_TIME 68 9595
TEST_TIME 69 9595
TEST_TIME 70 9541
TEST_TIME 71 9555
TEST_TIME 72 9508
TEST_TIME 73 9526
TEST_TIME 74 9462
TEST_TIME 75 9437
TEST_TIME 76 9440
TEST_TIME 77 9447
TEST_TIME 78 9432
TEST_TIME 79 9463
TEST_TIME 80 9444
TEST_TIME 81 9452
TEST_TIME 82 9467
TEST_TIME 83 9519
TEST_TIME 84 9483
TEST_TIME 85 9495
TEST_TIME 86 9542
TEST_TIME 87 9585
TEST_TIME 88 9685
TEST_TIME 89 9686
TEST_TIME 90 9598
TEST_TIME 91 9552
TEST_TIME 92 9521
TEST_TIME 93 9515
TEST_TIME 94 9462
TEST_TIME 95 9386
TEST_TIME 96 9414
TEST_TIME 97 9414
TEST_TIME 98 9430
TEST_TIME 99 9435
TEST_TIME 100 9423
TEST_TIME 101 9436
TEST_TIME 102 9427
TEST_TIME 103 9474
TEST_TIME 104 9550
TEST_TIME 105 9501
TEST_TIME 106 9610
TEST_TIME 107 9560
TEST_TIME 108 9640
TEST_TIME 109 9637
TEST_TIME 110 9568
TEST_TIME 111 9517
TEST_TIME 112 9510
TEST_TIME 113 9473
TEST_TIME 114 9472
TEST_TIME 115 9455
TEST_TIME 116 9422
TEST_TIME 117 9384
TEST_TIME 118 9347
TEST_TIME 119 9293
TEST_TIME 120 9216

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-11-2020 22:29:39 to 18-11-2020 22:29:42.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1524080 1524080 0 0.00 0 19370 6 0 0
doc_list_biud 1524080 1524080 0 0.00 0 53405 26 0 0
sp_add_invoice_to_stock 4943 4827 116 2.34 22 232569 18438 0 116
sp_cancel_adding_invoice 5831 5831 0 0.00 3 72882 793 0 0
sp_cancel_client_order 1668 1668 0 0.00 4 21806 377 0 0
sp_cancel_customer_reserve 570884 570884 0 0.00 1 53408 55 0 0
sp_cancel_pay_from_customer 702 702 0 0.00 3 8167 83 0 0
sp_cancel_pay_to_supplier 375 375 0 0.00 3 5646 82 0 0
sp_cancel_supplier_invoice 6386 6380 6 0.09 1 22120 783 0 6
sp_cancel_supplier_order 392 392 0 0.00 8 1139760 101176 0 0
sp_cancel_write_off 10258 10258 0 0.00 1 8382 102 0 0
sp_client_order 19728 19728 0 0.00 4 22491 397 0 0
sp_customer_reserve 450657 450657 0 0.00 0 69856 181 0 0
sp_fill_shopping_cart 30280 30280 0 0.00 1 15416 40 0 0
sp_fill_shopping_cart_clo_res 450656 450656 0 0.00 0 14534 14 0 0
sp_get_clo_for_invoice 4826 4826 0 0.00 0 22480 331 0 0
sp_kill_cost_storno 17166 17166 0 0.00 0 17205 52 0 0
sp_kill_qstorno_ret_qs2qd 1158798 1158798 0 0.00 0 53402 30 0 0
sp_kill_qty_storno 610096 610096 0 0.00 0 53404 65 0 0
sp_lock_selected_doc 20182 20182 0 0.00 0 8023 6 0 0
sp_make_cost_storno 27077 27077 0 0.00 0 19367 55 0 0
sp_multiply_rows_for_pdistr 27077 27077 0 0.00 0 9943 30 0 0
sp_multiply_rows_for_qdistr 19728 19728 0 0.00 0 22483 171 0 0
sp_pay_from_customer 6742 6742 0 0.00 4 45369 137 0 0
sp_pay_to_supplier 5652 5652 0 0.00 5 12124 135 0 0
sp_payment_common 12394 12394 0 0.00 1 45361 38 0 0
sp_qd_handle_on_cancel_clo 1668 1668 0 0.00 0 21799 346 0 0
sp_qd_handle_on_invoice_upd_sts 10657 10657 0 0.00 0 27321 312 0 0
sp_qd_handle_on_reserve_upd_sts 9857 9857 0 0.00 0 14213 57 0 0
sp_reserve_write_off 9857 9857 0 0.00 6 16085 180 0 0
sp_supplier_invoice 5357 5357 0 0.00 6 66514 3291 0 0
sp_supplier_order 5203 5203 0 0.00 6 68323 1349 0 0
srv_aggregate_perf_data 109 109 0 0.00 2977 206497 19873 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1593 154214 32564 0 0
srv_find_qd_qs_mism 1060356 1060356 0 0.00 0 12256 5 0 0
srv_make_invnt_saldo 519 519 0 0.00 41 191281 1456 0 0
srv_make_money_saldo 741 741 0 0.00 1 4645 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 213378 459237 328109 0 0
t$perf-abend:sp_add_invoice_to_stock 116 116 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4827 4827 0 0.00 0 21527 228 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 0 11358 164 0 0
t$perf-norm:sp_cancel_client_order 1668 1668 0 0.00 0 7088 21 0 0
t$perf-norm:sp_cancel_customer_reserve 625 625 0 0.00 0 2199 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 702 702 0 0.00 0 1344 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 375 375 0 0.00 0 4319 20 0 0
t$perf-norm:sp_cancel_supplier_invoice 351 351 0 0.00 0 2024 20 0 0
t$perf-norm:sp_cancel_supplier_order 392 392 0 0.00 0 18383 1747 0 0
t$perf-norm:sp_cancel_write_off 973 973 0 0.00 0 2381 6 0 0
t$perf-norm:sp_client_order 19728 19728 0 0.00 0 10383 21 0 0
t$perf-norm:sp_customer_reserve 986 986 0 0.00 0 2259 12 0 0
t$perf-norm:sp_pay_from_customer 6742 6742 0 0.00 0 8329 11 0 0
t$perf-norm:sp_pay_to_supplier 5652 5652 0 0.00 0 6979 10 0 0
t$perf-norm:sp_reserve_write_off 9857 9857 0 0.00 0 11824 15 0 0
t$perf-norm:sp_supplier_invoice 5357 5357 0 0.00 0 12097 23 0 0
t$perf-norm:sp_supplier_order 5203 5203 0 0.00 0 7908 15 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 1520 28 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 277 6 0 0
t$perf-norm:srv_make_invnt_saldo 519 519 0 0.00 0 826 22 0 0
t$perf-norm:srv_make_money_saldo 741 741 0 0.00 0 2947 25 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 67 18 0 0
v_add_invoice_to_stock 9884 9652 232 2.34 0 11762 31 0 232
v_all_customers 35764 35764 0 0.00 0 17 1 0 0
v_all_suppliers 29324 29324 0 0.00 0 17 1 0 0
v_all_wares 39454 39454 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 11361 21 0 0
v_cancel_client_order 3336 3336 0 0.00 0 7116 7 0 0
v_cancel_customer_prepayment 1404 1404 0 0.00 0 8150 10 0 0
v_cancel_customer_reserve 1250 1250 0 0.00 0 3231 11 0 0
v_cancel_payment_to_supplier 750 750 0 0.00 0 3212 7 0 0
v_cancel_supplier_invoice 714 702 12 1.68 0 407 14 0 12
v_cancel_supplier_order 784 784 0 0.00 0 3087 18 0 0
v_cancel_write_off 1946 1946 0 0.00 0 3898 14 0 0
v_max_id_clo_ord 5203 5203 0 0.00 0 4027 2 0 0
v_max_id_clo_res 986 986 0 0.00 0 6176 18 0 0
v_max_id_ord_sup 5350 5350 0 0.00 0 5066 6 0 0
v_max_non_paid_invoice 1543 1543 0 0.00 0 1005 3 0 0
v_max_non_paid_realizn 3690 3690 0 0.00 0 2903 5 0 0
v_min_id_clo_ord 5203 5203 0 0.00 0 4434 7 0 0
v_min_id_clo_res 986 986 0 0.00 0 2999 9 0 0
v_min_id_ord_sup 5350 5350 0 0.00 0 6208 10 0 0
v_min_non_paid_invoice 5652 5652 0 0.00 0 12088 18 0 0
v_min_non_paid_realizn 6742 6742 0 0.00 0 20607 29 0 0
v_our_firm 9794 9794 0 0.00 0 19 1 0 0
v_reserve_write_off 19714 19714 0 0.00 0 6697 7 0 0
x_lock_depdocs_on_canc_invoice 11860 11860 0 0.00 0 12578 111 0 0
x_lock_depdocs_on_canc_sup_ord 392 392 0 0.00 0 7664 317 0 0
x_make_qstorno_1000_1200 5203 5203 0 0.00 1 68303 1278 0 0
x_make_qstorno_1200_2000 5357 5357 0 0.00 2 64228 3140 0 0
x_make_qstorno_2100_3300 450657 450657 0 0.00 0 69839 165 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-11-2020 22:29:43 to 18-11-2020 22:29:47.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:16 29178 8192000000 10310545312 10623954944 1132033056 12.141 86 60 119 0 1154803872 2961040 19809776
19:57:54 25120 8192000000 10365938432 10686210048 1410153856 14.685 100 83 164 1 1441848688 5304336 26390496
19:58:29 31965 8192000000 10391726864 10717446144 1448098336 15.021 100 87 174 0 1483327600 6935856 28293408
19:59:11 17850 8192000000 10417244720 10744123392 1468358192 15.199 100 91 180 2 1505399152 8073232 28967728
19:59:39 27374 8192000000 10431919440 10762903552 1485798448 15.352 100 93 185 1 1523922752 8350944 29773360
20:00:23 22501 8192000000 10456164416 10788560896 1509841840 15.562 100 88 176 1 1546746656 8995424 27909392
20:01:07 12919 8192000000 10486819280 10830094336 1546278256 15.878 100 87 174 1 1582947984 9584208 27085520
20:01:31 15450 8192000000 10514670992 10860867584 1563032128 16.022 100 81 162 2 1597983136 10331344 24619664
20:01:57 18685 8192000000 10544842448 10891223040 1585440176 16.215 100 85 171 1 1622098128 10780816 25877136
20:02:25 11773 8192000000 10547320528 10901045248 1603008096 16.365 100 79 159 0 1637558560 10981984 23568480
20:02:47 10704 8192000000 10546546544 10907385856 1618977024 16.501 100 83 166 0 1655294352 11599312 24718016
20:03:08 12248 8192000000 10587803760 10945855488 1638396096 16.666 100 84 167 0 1675152864 12088384 24668384
20:03:28 8093 8192000000 10593014400 10955288576 1656526944 16.820 100 74 148 0 1689549168 11508032 21514192
20:03:44 8067 8192000000 10623985664 10990071808 1677848368 16.999 100 80 159 2 1713233296 12037536 23347392
20:04:03 9107 8192000000 10635886672 11002015744 1693956496 17.134 100 85 165 1 1730754400 13068912 23728992
20:04:19 9305 8192000000 10664239440 11034849280 1711657792 17.283 100 82 161 0 1747163008 12632736 22872480
20:04:37 6612 8192000000 10658405584 11032600576 1726842272 17.409 100 78 156 0 1761699264 12956432 21900560
20:04:51 4870 8192000000 10680545920 11055349760 1742719088 17.541 100 83 165 1 1778683920 12919008 23045824
20:05:06 4929 8192000000 10692849968 11067514880 1756057216 17.652 100 84 166 4 1792242880 12576592 23609072
20:05:18 4721 8192000000 10698877056 11080937472 1761672336 17.698 100 76 149 0 1795006352 12125584 21208432
20:05:29 3625 8192000000 10715424128 11092807680 1775316320 17.811 100 87 174 0 1811487472 11854576 24316576
20:05:39 3168 8192000000 10710240736 11095351296 1776929632 17.824 100 84 164 1 1812391216 12592336 22869248
20:05:49 3431 8192000000 10726312000 11105439744 1784616256 17.887 100 81 162 0 1820648064 13790320 22241488
20:06:00 4413 8192000000 10737635584 11119484928 1793192704 17.958 100 84 165 1 1829540224 12948752 23398768
20:06:11 3290 8192000000 10748383552 11130499072 1799281904 18.008 100 92 184 1 1843871712 19297136 25292672
20:06:22 3214 8192000000 10746384368 11129065472 1805237824 18.057 100 88 173 0 1844894768 15503888 24153056
20:06:32 3519 8192000000 10756778752 11140050944 1812619968 18.117 100 87 174 1 1850025296 13381488 24023840
20:06:42 3423 8192000000 10749516224 11136933888 1810492240 18.100 100 84 168 1 1847465008 13440864 23531904
20:06:52 5621 8192000000 10745861200 11134742528 1814464592 18.132 100 74 143 2 1847566960 12646512 20455856
20:07:04 2941 8192000000 10774551696 11160817664 1831175536 18.269 100 90 180 1 1870170896 13306336 25689024
20:07:14 2831 8192000000 10788504144 11173814272 1840694960 18.346 100 93 185 0 1880448960 13940848 25813152
20:07:23 2429 8192000000 10788205904 11176468480 1847714016 18.404 100 85 168 0 1884070864 12881904 23474944
20:07:32 2421 8192000000 10784607856 11178131456 1853446128 18.450 100 82 161 2 1888935712 11916544 23573040
20:07:40 1868 8192000000 10795774608 11184205824 1852845056 18.445 100 89 175 0 1889298688 11658896 24794736
20:07:49 2672 8192000000 10798811200 11188797440 1856106368 18.472 100 90 180 0 1894310208 12561152 25642688
20:07:58 1246 8192000000 10800534384 11191152640 1860160832 18.505 100 87 174 0 1897657840 12576640 24920368
20:08:06 1085 8192000000 10810453808 11198492672 1865657456 18.549 100 93 188 1 1905724016 13521072 26545488
20:08:13 17395 8192000000 10798358960 11188989952 1859765488 18.501 100 71 141 3 1891418784 12392480 19260816
20:08:37 1248 8192000000 10814241904 11201437696 1873005632 18.609 100 99 197 0 1914547904 13771200 27771072
20:08:44 1253 8192000000 10810955760 11205083136 1871376576 18.595 100 89 181 3 1908600160 13007584 24216000
20:08:52 2377 8192000000 10801850256 11199574016 1866569344 18.557 100 61 120 1 1898906192 15603056 16733792
20:09:01 3166 8192000000 10778289328 11194515456 1864192880 18.537 100 52 104 0 1889340464 10204736 14942848
20:09:10 6653 8192000000 10797305744 11199844352 1869401648 18.579 100 59 119 2 1893775472 8486880 15886944
20:09:24 36931 8192000000 10809911280 11213135872 1877512736 18.645 100 60 118 1 1902654880 8368384 16773760
20:10:07 3775 8192000000 10799235056 11216543744 1876673216 18.638 100 40 80 1 1896374448 8601904 11099328
20:10:18 7098 8192000000 10784241152 11215859712 1879764448 18.663 100 34 66 0 1897199184 7627840 9806896
20:10:40 4906 8192000000 10790716784 11221266432 1880857856 18.672 100 21 42 0 1892652032 6133440 5660736
20:10:53 8301 8192000000 10792630592 11218767872 1878246672 18.651 100 17 33 2 1888234880 5785920 4202288
20:11:09 7313 8192000000 10792140128 11220250624 1880401216 18.668 100 20 39 0 1891064672 5820880 4842576
20:11:23 6465 8192000000 10796460192 11223724032 1881649552 18.678 100 22 44 1 1894909040 6130800 7128688
20:11:36 9174 8192000000 10789654544 11221487616 1881243152 18.675 100 20 40 0 1893251360 6208656 5799552
20:11:51 9549 8192000000 10794735792 11224477696 1883239968 18.691 100 21 41 0 1895993936 6531792 6222176
20:12:12 7910 8192000000 10794773280 11226107904 1883815152 18.696 100 23 47 0 1895609824 5812704 5981968
20:12:28 10422 8192000000 10799703296 11229478912 1889038176 18.738 100 28 57 0 1904257424 6527568 8691680
20:12:47 25500 8192000000 10801561056 11239026688 1890989680 18.754 100 26 51 2 1904606928 5721872 7895376
20:13:51 10459 8192000000 10816426864 11249336320 1893925520 18.777 100 31 63 0 1914757776 12045360 8786896
20:14:12 8451 8192000000 10803585984 11237564416 1892013424 18.762 100 24 47 3 1903878128 5740032 6124672
20:14:29 4422 8192000000 10828518784 11251499008 1899994256 18.826 100 29 58 1 1914842160 6875040 7972864
20:14:39 6998 8192000000 10812340816 11248394240 1901528784 18.839 100 24 46 1 1914537296 6338160 6670352
20:14:54 12806 8192000000 10823481056 11247345664 1883452016 18.693 99 25 48 0 1895980912 5568608 6960288
20:15:17 7247 8192000000 10814006160 11247087616 1899874912 18.825 100 25 50 2 1913261776 6189120 7197744
20:15:31 10463 8192000000 10813868848 11246649344 1897779856 18.808 100 20 41 2 1908720704 5186528 5754320
20:15:49 6729 8192000000 10822211696 11254296576 1904415472 18.862 100 27 55 1 1917879392 5267984 8195936
20:16:05 14137 8192000000 10813236144 11245416448 1885958016 18.713 99 20 42 2 1896834128 5315408 5560704
20:16:30 6285 8192000000 10818094192 11256020992 1906018576 18.875 100 30 60 2 1921571808 7015744 8537488
20:16:48 8595 8192000000 10784507984 11224514560 1855945040 18.470 98 24 46 1 1868470480 5285328 7240112
20:17:07 13043 8192000000 10796143008 11227848704 1859661808 18.501 98 19 38 2 1871011600 5841952 5507840
20:17:26 62697 8192000000 10754141280 11185774592 1718132688 17.337 91 31 61 2 1733267296 6223664 8910944
20:18:38 10947 8192000000 10756095872 11179073536 1770120176 17.768 95 20 40 0 1782054032 5967104 5966752
20:18:55 4138 8192000000 10744233968 11164278784 1815705840 18.143 99 33 64 4 1831312720 6930256 8676624
20:19:07 7186 8192000000 10745392912 11164856320 1811439200 18.108 99 30 60 4 1827067248 6561136 9066912
20:19:23 6828 8192000000 10757093968 11172999168 1801262704 18.024 98 25 50 1 1814685616 6330464 7092448
20:19:36 5732 8192000000 10726706752 11154767872 1800959792 18.022 98 31 62 0 1816935120 6757520 9217808
20:19:48 6723 8192000000 10716791472 11135131648 1758044096 17.668 96 47 90 1 1777072064 6095088 12932880
20:20:04 5751 8192000000 10716214160 11136675840 1797590880 17.994 99 21 42 1 1808794800 5624000 5579920
20:20:17 4891 8192000000 10686046368 11101806592 1746529472 17.573 97 31 62 1 1762074944 6202784 9342688
20:20:29 10222 8192000000 10727031712 11141394432 1757096192 17.660 97 25 48 1 1769504176 5624480 6783504
20:20:46 20027 8192000000 10691555136 11110973440 1693704032 17.132 94 10 20 1 1701573120 5292112 2576976
20:21:16 15576 8192000000 10695649488 11107606528 1729393792 17.430 96 16 32 2 1739034464 5121104 4519568
20:21:40 9345 8192000000 10661361840 11077656576 1682062112 17.035 94 27 55 3 1695578864 5860816 7655936
20:21:58 69476 8192000000 10717060432 11138777088 1783480352 17.878 99 39 78 3 1799803408 5318016 11005040
20:23:14 8471 8192000000 10729531920 11152166912 1804416576 18.050 99 21 42 1 1819469776 9598448 5454752
20:23:31 8913 8192000000 10735213136 11154067456 1806676240 18.069 99 25 50 0 1819742288 5874592 7191456
20:23:46 5375 8192000000 10754701120 11163791360 1813089024 18.121 99 45 90 1 1832771856 6611552 13071280
20:23:58 8938 8192000000 10755534592 11177578496 1838996432 18.333 100 29 59 0 1853681744 6857152 7828160
20:24:14 6769 8192000000 10758001488 11179352064 1842758640 18.363 100 26 52 2 1856993232 6417920 7816672
20:24:27 10348 8192000000 10763799920 11186630656 1848522640 18.410 100 30 61 1 1863522944 6163296 8837008
20:24:44 7282 8192000000 10763478368 11188314112 1852109856 18.439 100 32 65 2 1867342512 5032128 10200528
20:24:58 7540 8192000000 10780701376 11200761856 1855387184 18.466 100 29 58 1 1870021472 5771792 8862496
20:25:15 7017 8192000000 10773342704 11196612608 1859831760 18.502 100 18 36 3 1870293984 5028208 5434016
20:25:28 6765 8192000000 10776011392 11205242880 1863424144 18.531 100 22 44 1 1879370176 9541072 6404960
20:25:43 5070 8192000000 10775553664 11203411968 1866181024 18.553 100 26 53 1 1879462192 5186176 8094992
20:25:54 11503 8192000000 10787433216 11207348224 1867104000 18.561 100 24 48 0 1879876464 5071824 7700640
20:26:14 10869 8192000000 10784496656 11211227136 1868771456 18.574 100 32 65 0 1884600048 6143952 9684640
20:26:35 27404 8192000000 10775039216 11213926400 1874350368 18.619 100 30 60 5 1889639328 5684464 9604496
20:27:40 74173 8192000000 10828552720 11253358592 1898338496 18.813 100 42 84 1 1916826560 6042128 12445936
20:29:03 25249 8192000000 10856262720 11276484608 1916920400 18.962 100 58 114 3 1940899264 7904688 16074176
20:29:35 13905 8192000000 10864718480 11283742720 1911413408 18.918 99 52 104 0 1938216064 11718880 15083776
20:29:57 9489 8192000000 10876107104 11293184000 1939327872 19.141 100 62 125 0 1970177424 13128896 17720656
20:30:27 21283 8192000000 10880626400 11303714816 1939083632 19.139 100 54 108 1 1968236352 13839744 15312976
20:30:55 13208 8192000000 10882676848 11308642304 1949576576 19.223 100 39 76 1 1973828720 13357456 10894688
20:31:17 19045 8192000000 10887685312 11311280128 1953520048 19.255 100 47 94 1 1980585072 13657008 13408016
20:31:48 14073 8192000000 10896815232 11321495552 1958425296 19.294 100 50 100 2 1987287648 13685456 15176896
20:32:16 30293 8192000000 10909694224 11333660672 1967146976 19.363 100 54 109 1 1998409008 16050832 15211200
20:33:08 23002 8192000000 10904895712 11342544896 1968890912 19.377 100 38 75 0 1996590336 15956704 11742720
20:33:38 6539 8192000000 10922867360 11344621568 1973180656 19.411 100 53 106 0 2005145232 16226752 15737824
20:33:57 15110 8192000000 10916342032 11350958080 1977839296 19.448 100 52 104 1 2010779232 17585968 15353968
20:34:19 6191 8192000000 10928039232 11355975680 1984653920 19.502 100 45 90 0 2013637952 15510336 13473696
20:34:35 12582 8192000000 10936895008 11364294656 1989930384 19.543 100 51 100 2 2025484640 20098368 15455888
20:34:56 8266 8192000000 10939455568 11369119744 1991318032 19.554 100 49 98 0 2026957104 20448992 15190080
20:35:11 22742 8192000000 10929955520 11362332672 1986587424 19.517 100 56 110 0 2025498720 22128960 16782336
20:35:42 6197 8192000000 10942983584 11368714240 1988117696 19.529 100 61 122 3 2031261904 24741712 18402496
20:35:56 10222 8192000000 10941913008 11373146112 1990573072 19.548 100 58 116 2 2034610752 25846448 18191232
20:36:18 7886 8192000000 10920460368 11356114944 1972124800 19.402 99 47 90 1 2008907168 22077888 14704480
20:36:36 12033 8192000000 10928699408 11367784448 1972051008 19.402 99 47 94 1 2007169600 20459552 14659040
20:36:57 8447 8192000000 10941594224 11374948352 1991559056 19.556 100 53 105 2 2031479984 23626496 16294432
20:37:13 3859 8192000000 10963480016 11378765824 1997550704 19.603 100 73 146 1 2042805200 23815888 21438608
20:37:24 4296 8192000000 10954880704 11378794496 1998794784 19.613 100 62 123 0 2037857392 21085168 17977440
20:37:35 2617 8192000000 10956556208 11377164288 1999399344 19.618 100 76 152 0 2044908640 22629312 22879984
20:37:45 7095 8192000000 10953861456 11381170176 2001622368 19.636 100 69 138 1 2044253536 22517856 20113312
20:37:59 3299 8192000000 10954645952 11382648832 2002468560 19.642 100 77 152 1 2047342160 22778976 22094624
20:38:16 3058 8192000000 10959807664 11388981248 1987236880 19.522 99 68 135 0 2029253296 22285920 19730496
20:38:29 11194 8192000000 10953690720 11387670528 2006176976 19.671 100 54 108 3 2044207104 21959520 16070608
20:38:49 5064 8192000000 10972974656 11400200192 2017389488 19.760 100 72 143 1 2063796048 25304848 21101712
20:39:01 7169 8192000000 10966798384 11398131712 2002271280 19.641 99 65 128 0 2047644976 27027968 18345728
20:39:18 8288 8192000000 10978722032 11409788928 2022638576 19.801 100 69 137 2 2071344896 27500096 21206224
20:39:35 5738 8192000000 10984099648 11412774912 2023870912 19.811 100 68 135 0 2071763776 27348928 20543936
20:39:52 9344 8192000000 10995837296 11423760384 2029908016 19.858 100 70 137 2 2078141824 28115968 20117840
20:40:09 3569 8192000000 11008921040 11425247232 2031201632 19.868 100 82 162 2 2085976352 29800112 24974608
20:40:20 3403 8192000000 10999911920 11427577856 2031350960 19.869 100 79 157 1 2086374528 31101616 23921952
20:40:30 4740 8192000000 11000504992 11428569088 2032920656 19.882 100 75 149 1 2088873584 33327280 22625648
20:40:42 4596 8192000000 10999438576 11425083392 2027455920 19.839 100 66 133 3 2077916384 30444160 20016304
20:40:54 7088 8192000000 10993485872 11422773248 2025642624 19.824 100 75 150 2 2080876032 32551488 22681920
20:41:09 4304 8192000000 10983097648 11411918848 2020959056 19.788 100 67 134 1 2074163824 31852816 21351952
20:41:20 3722 8192000000 10998781824 11425865728 2024359504 19.814 100 74 147 0 2081524048 33967808 23196736
20:41:33 2618 8192000000 10973591648 11396706304 1984893232 19.503 98 71 139 1 2040442944 33712048 21837664
20:41:42 3576 8192000000 10979410448 11399798784 1998140208 19.608 99 79 158 2 2059109088 36566096 24402784
20:41:53 1591 8192000000 10986850624 11407343616 2006981504 19.678 100 89 178 1 2072272672 37307520 27983648
20:42:02 1981 8192000000 10989951184 11404533760 2003469536 19.650 100 85 169 1 2067360912 38489856 25401520
20:42:12 2391 8192000000 10979866352 11401080832 1988146608 19.529 99 79 158 1 2052560752 39894736 24519408
20:42:22 5325 8192000000 10987768592 11409301504 2006221136 19.672 100 75 147 0 2069688160 39798096 23668928
20:42:42 3308 8192000000 11004821632 11419824128 2012171056 19.719 100 84 164 1 2079284656 41602592 25511008
20:42:52 4124 8192000000 11003846752 11425284096 2017454320 19.760 100 82 164 0 2085880752 42810208 25616224
20:43:05 2049 8192000000 11005167152 11427831808 2017520208 19.761 100 81 159 1 2085251504 42658944 25072352
20:43:16 4392 8192000000 10987347680 11409534976 1999045776 19.615 99 70 140 1 2064323056 43396672 21880608
20:43:28 2157 8192000000 11003343712 11419889664 2001802784 19.637 99 86 169 1 2074058112 47416432 24838896
20:43:37 1758 8192000000 10995080224 11412832256 2001609616 19.635 100 79 158 1 2076203984 50189120 24405248
20:43:46 4261 8192000000 10990061824 11404091392 1992161344 19.561 100 86 172 1 2070731184 51436000 27133840
20:43:59 2096 8192000000 10976325184 11387224064 1974302560 19.420 99 83 165 2 2052680720 52250704 26127456
20:44:08 2049 8192000000 10990079296 11404275712 1988904496 19.535 100 85 169 1 2070166352 54523408 26738448
20:44:17 6324 8192000000 10965174688 11381891072 1943527840 19.175 98 80 160 1 2022991616 54174848 25288928
20:44:32 4093 8192000000 10959750128 11383734272 1970224896 19.387 100 66 132 0 2046994864 55052880 21717088
20:44:45 2916 8192000000 10975102896 11392557056 1981137536 19.474 100 81 161 1 2060236416 52597600 26501280
20:44:55 4099 8192000000 10982923552 11394871296 1979970736 19.464 100 90 177 2 2060360592 52851536 27538320
20:45:07 3178 8192000000 10978524688 11393990656 1970422064 19.389 99 84 168 2 2051950784 54670112 26858608
20:45:17 3518 8192000000 10967348592 11389792256 1964820192 19.344 99 76 152 1 2039412288 50932048 23660048
20:45:31 5020 8192000000 10950186512 11376984064 1955274896 19.268 99 58 116 0 2023116576 49376048 18465632
20:45:42 6167 8192000000 10939051696 11368747008 1956232656 19.276 100 58 111 0 2023797248 49637152 17927440
20:45:59 7180 8192000000 10954348864 11387715584 1970032464 19.386 100 54 108 1 2037200832 49839856 17328512
20:46:19 17002 8192000000 10944895040 11388067840 1971171376 19.395 100 37 74 0 2032585696 48718912 12695408
20:46:51 9079 8192000000 10957109856 11394433024 1976975680 19.441 100 52 101 2 2044200560 50148256 17076624
20:47:07 8453 8192000000 10958113008 11405017088 1983283136 19.491 100 44 88 2 2046223456 48344048 14596272
20:47:26 1724 8192000000 10965940784 11386486784 1974149536 19.418 100 65 130 0 2043883312 48742656 20991120
20:47:36 11874 8192000000 10932334000 11383472128 1965706000 19.351 100 38 75 0 2027960672 50171072 12083600
20:47:58 12124 8192000000 10906902016 11344830464 1912816624 18.929 98 43 85 2 1967217264 40376176 14024464
20:48:27 27883 8192000000 10913656208 11363856384 1950315072 19.229 100 30 60 3 2002923312 42777584 9830656
20:49:05 25354 8192000000 10869076048 11315806208 1847287360 18.400 95 22 44 0 1894954864 40261600 7405904
20:49:55 14389 8192000000 10900706464 11336663040 1919632512 18.984 100 38 75 3 1975218864 43202928 12383424
20:50:17 20406 8192000000 10889558496 11334090752 1908148608 18.892 99 26 50 0 1961294352 43908672 9237072
20:50:48 26201 8192000000 10908584496 11353505792 1932684128 19.088 100 26 51 2 1986870608 44794064 9392416
20:51:21 19018 8192000000 10917452688 11364462592 1939593168 19.144 100 34 65 2 1995159136 44771376 10794592
20:52:06 39944 8192000000 10867281360 11315105792 1865900016 18.551 97 19 39 1 1908644480 36006096 6738368
20:53:44 20138 8192000000 10859891712 11319308288 1907887856 18.890 100 22 44 1 1949989200 34309664 7791680
20:54:12 28883 8192000000 10843348448 11316453376 1900064656 18.827 99 8 16 0 1920150048 17263616 2821776
20:55:17 35341 8192000000 10879900368 11316269056 1907454256 18.886 99 40 79 1 1933918576 14977904 11486416
20:56:01 39710 8192000000 10854654592 11328032768 1928111808 19.052 100 10 20 0 1943037776 11913824 3012144
20:56:46 100651 8192000000 10863190064 11311714304 1879690592 18.663 97 20 40 1 1899268976 14013232 5565152
20:58:35 104789 8192000000 10857258608 11316584448 1852497456 18.442 95 17 34 0 1866090992 9348592 4244944
21:00:32 56658 8192000000 10842320528 11305717760 1848642304 18.411 96 27 54 1 1870745152 14858800 7244048
21:02:01 29768 8192000000 10847983408 11312041984 1916264592 18.957 100 10 20 1 1939013616 20288464 2460560
21:02:38 56914 8192000000 10843737728 11305594880 1890619520 18.751 98 17 34 0 1907194416 11996432 4578464
21:03:41 12598 8192000000 10863521792 11307700224 1925897232 19.034 100 20 37 3 1943697344 11708624 6091488
21:04:01 39533 8192000000 10906425264 11337265152 1936010992 19.115 100 32 63 2 1963987200 17910528 10065680
21:05:00 52395 8192000000 10869358080 11336744960 1904156016 18.860 98 20 40 0 1928851936 18722128 5973792
21:05:59 70393 8192000000 10857393264 11336228864 1901604432 18.839 98 9 18 0 1928708464 24290080 2813952
21:08:20 32911 8192000000 10871298240 11342430208 1936539104 19.119 100 12 24 0 1955004784 15102992 3362688
21:08:59 88656 8192000000 10881195584 11349274624 1932945088 19.090 99 13 26 0 1952705248 16242160 3518000
21:10:45 107694 8192000000 10873187056 11345260544 1914685648 18.944 98 17 35 0 1933359904 13746144 4928112
21:12:47 27400 8192000000 10877519552 11343155200 1955202512 19.268 100 19 38 1 1969714432 9647392 4864528
21:13:21 9341 8192000000 10900899504 11344912384 1943254016 19.173 99 45 90 4 1969952160 13773904 12924240
21:13:40 12852 8192000000 10896591056 11352129536 1965034656 19.346 100 53 105 0 1991421696 11269680 15117360
21:14:17 39251 8192000000 10885494160 11360104448 1969142752 19.379 100 29 59 1 1989683472 12001024 8539696
21:15:03 46090 8192000000 10873558272 11348684800 1941088272 19.155 99 8 16 0 1951886080 8483824 2313984
21:15:56 45852 8192000000 10892654720 11363250176 1967637888 19.367 100 9 18 0 1976532096 6692384 2201824
21:16:49 39497 8192000000 10903845552 11370254336 1977251472 19.443 100 34 68 0 1994416096 7852736 9311888
21:17:42 79469 8192000000 10905674176 11371819008 1958233936 19.292 99 21 39 2 1969980144 6484608 5261600
21:19:17 98119 8192000000 10917077840 11405623296 1989872592 19.543 100 11 22 0 2013006848 19532800 3601456
21:21:03 47796 8192000000 10904744576 11408060416 1988327440 19.531 100 8 16 0 2006035296 15422240 2285616
21:21:57 29759 8192000000 10939630448 11399323648 1996847936 19.598 100 23 46 1 2013273488 9797456 6628096
21:22:33 40772 8192000000 10920144432 11406884864 1996877648 19.598 100 14 28 0 2013887504 12763200 4246656
21:23:24 48579 8192000000 10936194080 11420364800 1976024688 19.433 99 10 20 0 1996061184 17558288 2478208
21:24:26 46923 8192000000 10928525664 11402301440 1964461904 19.341 98 18 36 0 1981177152 11792256 4922992
21:25:20 37846 8192000000 10925691376 11391995904 1976631552 19.438 99 35 70 0 2001139248 14158080 10349616
21:26:06 101519 8192000000 10933834352 11388923904 1954622560 19.263 98 18 37 2 1970382384 10621408 5138416
21:27:58 46955 8192000000 10914754592 11389530112 1939869952 19.146 97 21 42 1 1962194016 16693520 5630544
21:28:52 77004 8192000000 10905008896 11392925696 1905532416 18.871 96 10 20 0 1927045568 18807952 2705200
21:30:15 55985 8192000000 10897596048 11372597248 1908754640 18.897 96 19 38 0 1927629616 12666048 6208928
21:31:17 70906 8192000000 10924586784 11414978560 1960892672 19.313 99 11 22 1 1986614368 22611472 3110224
21:32:47 43702 8192000000 10893940336 11376226304 1916858384 18.962 97 18 36 0 1938156720 16256240 5042096
21:33:37 60435 8192000000 10897408960 11344375808 1898518496 18.814 96 31 62 0 1916407968 8892992 8996480
21:36:09 46952 8192000000 10882687120 11331207168 1867737744 18.566 95 34 68 0 1888993648 11621744 9634160
21:37:03 52370 8192000000 10906588096 11354517504 1943698784 19.176 100 49 98 0 1973684688 15804704 14181200
21:38:02 93652 8192000000 10864767760 11344494592 1912460864 18.926 98 19 38 0 1930716480 12862528 5393088
21:39:43 38165 8192000000 10875443104 11342376960 1939763504 19.145 100 5 10 0 1954778624 13091056 1924064
21:40:33 56907 8192000000 10868352224 11336519680 1936535664 19.119 99 16 32 1 1954432368 13177728 4718976
21:41:36 55515 8192000000 10863338112 11328765952 1897582000 18.807 97 7 14 0 1914684128 14940896 2161232
21:42:38 41189 8192000000 10879853680 11352449024 1952155808 19.244 100 17 35 1 1975274144 18324336 4794000
21:43:31 41991 8192000000 10872219680 11355701248 1934434464 19.102 99 14 28 1 1951742880 13778512 3529904
21:44:58 107444 8192000000 10842185152 11319832576 1794047984 17.965 92 7 14 1 1806948416 11044176 1856256
21:46:52 33269 8192000000 10864047392 11317051392 1896654864 18.799 98 26 52 1 1911618512 7626640 7337008
21:47:40 51211 8192000000 10864963344 11312783360 1919274592 18.981 99 34 68 0 1939712224 10621552 9816080
21:48:56 28937 8192000000 10859796048 11329249280 1900469888 18.830 98 24 48 1 1920734592 13576688 6688016
21:49:35 63377 8192000000 10881482528 11359342592 1932543984 19.087 99 14 28 1 1952287024 15689968 4053072
21:50:47 40299 8192000000 10885490528 11331194880 1882352672 18.684 96 28 55 2 1899814640 9535168 7926800
21:51:34 19162 8192000000 10868321648 11317714944 1889584512 18.742 97 48 96 0 1912718992 9397536 13736944
21:52:05 45741 8192000000 10874247088 11329609728 1898404768 18.813 98 37 74 4 1923396816 14790208 10201840
21:52:58 39780 8192000000 10869728864 11336470528 1932547328 19.087 100 27 54 1 1958774304 18752064 7474912
21:53:46 65445 8192000000 10881888000 11349446656 1934069392 19.099 100 12 24 0 1951824768 14280112 3475264
21:55:05 52364 8192000000 10879714528 11365220352 1925397248 19.030 99 4 8 0 1945441552 18925552 1118752
21:56:03 99658 8192000000 10866237856 11342024704 1873726704 18.614 96 22 44 0 1894829808 14922912 6180192
21:58:02 87482 8192000000 10868628928 11327016960 1919939872 18.986 98 30 58 1 1939177648 11336448 7901328
21:59:41 33742 8192000000 10880202368 11347681280 1940415520 19.150 99 29 58 1 1959516096 11099776 8000800
22:00:37 30713 8192000000 10873508880 11354984448 1957983520 19.290 100 8 16 0 1971164032 11294832 1885680
22:01:13 44430 8192000000 10879827360 11361312768 1946948928 19.202 99 12 24 0 1961382096 11150560 3282608
22:02:06 48706 8192000000 10905449360 11378991104 1970162704 19.387 100 9 18 0 1986786128 14341792 2281632
22:03:08 57517 8192000000 10914138496 11399000064 1983541472 19.493 100 12 24 0 2003151248 15999296 3610480
22:04:36 55092 8192000000 10905645360 11391557632 1986911248 19.519 100 12 24 0 2004031472 13983008 3137216
22:05:40 41144 8192000000 10904644960 11375906816 1955161344 19.268 98 25 50 0 1969914240 8152000 6600896
22:06:31 36331 8192000000 10899522176 11361660928 1968580704 19.374 99 40 77 2 1986444640 6824592 11039344
22:07:23 21394 8192000000 10922418000 11377152000 1966544896 19.358 99 40 80 0 1985631488 8000656 11085936
22:07:55 38687 8192000000 10935548592 11396624384 1990694416 19.549 100 37 72 2 2012408992 11861664 9852912
22:09:28 82071 8192000000 10924549424 11404804096 1958309232 19.293 98 21 42 0 1983464832 18834080 6321520
22:11:55 69017 8192000000 10943361056 11393572864 1984897760 19.503 100 26 52 1 2008630960 15667104 8066096
22:13:15 33760 8192000000 10919297296 11385151488 1971541056 19.398 99 26 50 2 1991700160 13134288 7024816
22:13:55 42103 8192000000 10925919024 11369779200 1925951680 19.034 97 22 44 2 1945539776 14230480 5357616
22:14:48 35576 8192000000 10886513264 11347738624 1901617072 18.839 97 31 61 1 1924723424 14215504 8890848
22:15:36 81488 8192000000 10884018128 11352788992 1871686096 18.598 96 10 20 1 1889214528 15346992 2181440
22:17:04 154214 8192000000 10896181216 11357974528 1934916512 19.106 98 25 49 1 1949446624 7555328 6974784
22:20:42 85524 8192000000 10892348544 11373842432 1959280016 19.300 99 21 42 0 1978562064 13188560 6093488
22:22:14 51114 8192000000 10884987632 11358728192 1916795408 18.961 97 14 26 0 1932550096 11973408 3781280
22:23:11 34382 8192000000 10880649952 11347509248 1954590320 19.263 99 26 52 3 1971601440 9974080 7037040
22:23:52 64576 8192000000 10897714544 11369697280 1953323232 19.253 99 16 32 0 1968123168 10124112 4675824
22:25:17 50389 8192000000 10899158624 11366846464 1973146432 19.410 100 16 32 2 1990815760 11981776 5687552
22:26:13 59434 8192000000 10501373136 10941538304 1587947952 16.236 81 6 12 1 1603808832 13752288 2108592

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 18-11-2020 22:29:49 to 18-11-2020 22:30:20.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 116 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-11-2020 22:30:21 to 18-11-2020 22:30:23.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          228797
MON$OLDEST_ACTIVE               233451
MON$OLDEST_SNAPSHOT             233451
MON$NEXT_TRANSACTION            233451
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                       2036384
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.33391 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33391 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33391 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33391 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 ---
:44: 
:45: mscs-test-161.budzdorov.ru    Wed Nov 18 22:27:36 2020
:46:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:47: 
--- end of diff output ---

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

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