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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17485348 kB
MemAvailable 31495904 kB
Buffers 0 kB
Cached 14235324 kB
SwapCached 2824 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-06 16:27:02
DTS_END                         2020-11-06 16:27:02.7470
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36430
TRN_ID                          243925
ATT_ID                          724
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: 9225.77 20872 1107092
customer order: creation 180.51 327 21661
customer order: refuse 15.40 344 1848
order to supplier: creation 48.17 1250 5780
order to supplier: removal 3.44 96939 413
invoice (draft): creation 48.13 3334 5776
invoice (draft): removal 50.44 842 6053
invoice accept: apply 42.96 18023 5155
invoice accept: cancel 45.41 782 5449
customer reserve: creation 4029.86 176 483583
customer reserve: removal 4460.39 57 535247
realization accept: apply 87.03 181 10444
realization accept: cancel 78.41 127 9409
payment from customer: creation 62.18 113 7462
payment from customer: removal 6.33 84 759
payment to supplier: creation 50.79 145 6095
payment to supplier: removal 3.60 69 432
service: total inventory turnovers 5.14 1167 617
service: total monetary turnovers 6.68 28 802
service: aggregate perf. data 0.86 16712 103
service: refresh index statistics 0.03 276739 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-11-2020 16:29:02 to 06-11-2020 16:29:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7026
TEST_TIME 2 5365
TEST_TIME 3 5124
TEST_TIME 4 5493
TEST_TIME 5 5474
TEST_TIME 6 5372
TEST_TIME 7 5460
TEST_TIME 8 5786
TEST_TIME 9 6708
TEST_TIME 10 6665
TEST_TIME 11 6972
TEST_TIME 12 6890
TEST_TIME 13 6969
TEST_TIME 14 6872
TEST_TIME 15 6932
TEST_TIME 16 7385
TEST_TIME 17 7816
TEST_TIME 18 7837
TEST_TIME 19 8149
TEST_TIME 20 8485
TEST_TIME 21 8376
TEST_TIME 22 8522
TEST_TIME 23 8841
TEST_TIME 24 9301
TEST_TIME 25 9647
TEST_TIME 26 9645
TEST_TIME 27 9778
TEST_TIME 28 10870
TEST_TIME 29 10847
TEST_TIME 30 10659
TEST_TIME 31 10536
TEST_TIME 32 10609
TEST_TIME 33 10506
TEST_TIME 34 10683
TEST_TIME 35 10670
TEST_TIME 36 10539
TEST_TIME 37 10295
TEST_TIME 38 10257
TEST_TIME 39 10261
TEST_TIME 40 10125
TEST_TIME 41 10013
TEST_TIME 42 9999
TEST_TIME 43 10056
TEST_TIME 44 10022
TEST_TIME 45 10064
TEST_TIME 46 10064
TEST_TIME 47 9973
TEST_TIME 48 9866
TEST_TIME 49 9787
TEST_TIME 50 9704
TEST_TIME 51 9712
TEST_TIME 52 9594
TEST_TIME 53 9619
TEST_TIME 54 9643
TEST_TIME 55 9612
TEST_TIME 56 9593
TEST_TIME 57 9539
TEST_TIME 58 9640
TEST_TIME 59 9584
TEST_TIME 60 9610
TEST_TIME 61 9665
TEST_TIME 62 9686
TEST_TIME 63 9722
TEST_TIME 64 9708
TEST_TIME 65 9709
TEST_TIME 66 9730
TEST_TIME 67 9820
TEST_TIME 68 9894
TEST_TIME 69 9851
TEST_TIME 70 9741
TEST_TIME 71 9706
TEST_TIME 72 9660
TEST_TIME 73 9600
TEST_TIME 74 9589
TEST_TIME 75 9567
TEST_TIME 76 9520
TEST_TIME 77 9576
TEST_TIME 78 9498
TEST_TIME 79 9478
TEST_TIME 80 9479
TEST_TIME 81 9462
TEST_TIME 82 9438
TEST_TIME 83 9456
TEST_TIME 84 9498
TEST_TIME 85 9514
TEST_TIME 86 9502
TEST_TIME 87 9476
TEST_TIME 88 9531
TEST_TIME 89 9511
TEST_TIME 90 9517
TEST_TIME 91 9495
TEST_TIME 92 9575
TEST_TIME 93 9688
TEST_TIME 94 9595
TEST_TIME 95 9521
TEST_TIME 96 9496
TEST_TIME 97 9471
TEST_TIME 98 9446
TEST_TIME 99 9391
TEST_TIME 100 9360
TEST_TIME 101 9299
TEST_TIME 102 9255
TEST_TIME 103 9242
TEST_TIME 104 9200
TEST_TIME 105 9208
TEST_TIME 106 9214
TEST_TIME 107 9246
TEST_TIME 108 9242
TEST_TIME 109 9267
TEST_TIME 110 9247
TEST_TIME 111 9254
TEST_TIME 112 9258
TEST_TIME 113 9295
TEST_TIME 114 9316
TEST_TIME 115 9317
TEST_TIME 116 9361
TEST_TIME 117 9352
TEST_TIME 118 9370
TEST_TIME 119 9304
TEST_TIME 120 9227

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-11-2020 16:29:06 to 06-11-2020 16:29:09.

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 1553169 1553169 0 0.00 0 23814 6 0 0
doc_list_biud 1553167 1553167 0 0.00 0 42234 26 0 0
sp_add_invoice_to_stock 5251 5155 96 1.82 32 201708 18023 0 96
sp_cancel_adding_invoice 5449 5449 0 0.00 5 53454 783 0 0
sp_cancel_client_order 1848 1848 0 0.00 4 9018 344 0 0
sp_cancel_customer_reserve 535247 535247 0 0.00 1 42251 58 0 0
sp_cancel_pay_from_customer 759 759 0 0.00 3 4415 84 0 0
sp_cancel_pay_to_supplier 432 432 0 0.00 3 3997 69 0 0
sp_cancel_supplier_invoice 6064 6053 11 0.18 1 19447 843 0 11
sp_cancel_supplier_order 413 413 0 0.00 6 1140424 96939 0 0
sp_cancel_write_off 9409 9409 0 0.00 1 16395 127 0 0
sp_client_order 21661 21661 0 0.00 3 15444 328 0 0
sp_customer_reserve 483583 483583 0 0.00 0 104535 177 0 0
sp_fill_shopping_cart 33194 33194 0 0.00 1 15190 40 0 0
sp_fill_shopping_cart_clo_res 483579 483579 0 0.00 0 13329 12 0 0
sp_get_clo_for_invoice 5151 5151 0 0.00 0 20567 269 0 0
sp_kill_cost_storno 16049 16049 0 0.00 0 8242 59 0 0
sp_kill_qstorno_ret_qs2qd 1086369 1086369 0 0.00 0 42189 32 0 0
sp_kill_qty_storno 574014 574014 0 0.00 0 42233 69 0 0
sp_lock_selected_doc 21659 21659 0 0.00 0 6185 5 0 0
sp_make_cost_storno 29152 29152 0 0.00 0 23802 62 0 0
sp_multiply_rows_for_pdistr 29152 29152 0 0.00 0 7533 28 0 0
sp_multiply_rows_for_qdistr 21661 21661 0 0.00 0 14900 144 0 0
sp_pay_from_customer 7462 7462 0 0.00 4 30070 113 0 0
sp_pay_to_supplier 6095 6095 0 0.00 5 18545 145 0 0
sp_payment_common 13557 13557 0 0.00 2 30058 34 0 0
sp_qd_handle_on_cancel_clo 1848 1848 0 0.00 0 9011 324 0 0
sp_qd_handle_on_invoice_upd_sts 10600 10600 0 0.00 0 16988 330 0 0
sp_qd_handle_on_reserve_upd_sts 10444 10444 0 0.00 0 18267 53 0 0
sp_reserve_write_off 10444 10444 0 0.00 6 18289 181 0 0
sp_supplier_invoice 5776 5776 0 0.00 6 78627 3335 0 0
sp_supplier_order 5780 5780 0 0.00 5 56122 1250 0 0
srv_aggregate_perf_data 103 103 0 0.00 2708 91479 16712 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 1178 173193 32109 0 0
srv_find_qd_qs_mism 1056228 1056228 0 0.00 0 9619 6 0 0
srv_make_invnt_saldo 617 617 0 0.00 32 114320 1168 0 0
srv_make_money_saldo 802 802 0 0.00 0 5314 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 201936 342494 276740 0 0
t$perf-abend:sp_add_invoice_to_stock 96 96 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5155 5155 0 0.00 0 9118 154 0 0
t$perf-norm:sp_cancel_adding_invoice 409 409 0 0.00 0 3985 87 0 0
t$perf-norm:sp_cancel_client_order 1848 1848 0 0.00 0 3266 15 0 0
t$perf-norm:sp_cancel_customer_reserve 708 708 0 0.00 0 2357 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 759 759 0 0.00 0 1734 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 432 432 0 0.00 0 3889 20 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 3804 23 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 29575 1656 0 0
t$perf-norm:sp_cancel_write_off 1083 1083 0 0.00 0 3679 9 0 0
t$perf-norm:sp_client_order 21661 21661 0 0.00 0 17634 20 0 0
t$perf-norm:sp_customer_reserve 1125 1125 0 0.00 0 5103 9 0 0
t$perf-norm:sp_pay_from_customer 7462 7462 0 0.00 0 4986 11 0 0
t$perf-norm:sp_pay_to_supplier 6095 6095 0 0.00 0 3536 9 0 0
t$perf-norm:sp_reserve_write_off 10444 10444 0 0.00 0 7583 12 0 0
t$perf-norm:sp_supplier_invoice 5776 5776 0 0.00 0 13927 23 0 0
t$perf-norm:sp_supplier_order 5780 5780 0 0.00 0 7397 14 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 281 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 580 13 0 0
t$perf-norm:srv_make_invnt_saldo 617 617 0 0.00 0 14540 46 0 0
t$perf-norm:srv_make_money_saldo 802 802 0 0.00 0 2266 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10492 10300 192 1.82 0 6792 20 0 192
v_all_customers 39468 39468 0 0.00 0 12 1 0 0
v_all_suppliers 31978 31978 0 0.00 0 18 1 0 0
v_all_wares 43322 43322 0 0.00 0 26 1 0 0
v_cancel_adding_invoice 818 818 0 0.00 0 715 6 0 0
v_cancel_client_order 3696 3696 0 0.00 0 4363 5 0 0
v_cancel_customer_prepayment 1518 1518 0 0.00 0 2686 10 0 0
v_cancel_customer_reserve 1416 1416 0 0.00 0 1401 4 0 0
v_cancel_payment_to_supplier 864 864 0 0.00 0 2404 7 0 0
v_cancel_supplier_invoice 848 826 22 2.59 0 1271 18 0 22
v_cancel_supplier_order 826 826 0 0.00 0 830 5 0 0
v_cancel_write_off 2166 2166 0 0.00 0 6063 18 0 0
v_max_id_clo_ord 5772 5772 0 0.00 0 1072 1 0 0
v_max_id_clo_res 1125 1125 0 0.00 0 1639 8 0 0
v_max_id_ord_sup 5759 5759 0 0.00 0 3161 3 0 0
v_max_non_paid_invoice 1637 1637 0 0.00 0 4460 5 0 0
v_max_non_paid_realizn 3934 3934 0 0.00 0 7353 5 0 0
v_min_id_clo_ord 5772 5772 0 0.00 0 5964 8 0 0
v_min_id_clo_res 1125 1125 0 0.00 0 7741 12 0 0
v_min_id_ord_sup 5759 5759 0 0.00 0 8955 14 0 0
v_min_non_paid_invoice 6095 6095 0 0.00 0 7797 23 0 0
v_min_non_paid_realizn 7462 7462 0 0.00 0 30053 26 0 0
v_our_firm 10910 10910 0 0.00 0 57 1 0 0
v_reserve_write_off 20886 20886 0 0.00 0 5763 6 0 0
x_lock_depdocs_on_canc_invoice 11089 11089 0 0.00 0 23202 102 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 6804 292 0 0
x_make_qstorno_1000_1200 5780 5780 0 0.00 1 56104 1168 0 0
x_make_qstorno_1200_2000 5776 5776 0 0.00 3 78614 3187 0 0
x_make_qstorno_2100_3300 483583 483583 0 0.00 0 104533 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-11-2020 16:29:10 to 06-11-2020 16:29:14.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:06 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:12 14209 8192000000 10213001008 10516942848 944710592 10.339 76 61 125 0 967190320 2494944 19984784
13:57:34 12775 8192000000 10285831440 10595573760 1345439248 14.106 100 84 168 0 1378335360 4195088 28701024
13:57:55 40458 8192000000 10341683712 10659160064 1383944368 14.452 100 90 180 0 1419831472 5422000 30465104
13:58:53 43262 8192000000 10411485936 10738311168 1442759344 14.974 100 88 176 1 1478051184 6218288 29073552
13:59:44 23787 8192000000 10437012192 10769711104 1486496432 15.358 100 90 180 0 1523305808 7539136 29270240
14:00:16 13573 8192000000 10450777552 10786713600 1505499392 15.524 100 85 170 1 1540922064 8222336 27200336
14:00:45 10489 8192000000 10470548096 10808393728 1526834736 15.710 100 86 172 0 1563160240 8885648 27439856
14:01:16 17963 8192000000 10488538640 10835558400 1551302992 15.921 100 82 164 1 1586155984 9139264 25713728
14:01:51 14838 8192000000 10527176576 10879152128 1575202160 16.127 100 76 152 0 1608081568 9399568 23479840
14:02:14 13957 8192000000 10553854640 10909212672 1608190464 16.409 100 79 158 1 1642578800 10643408 23744928
14:02:41 15256 8192000000 10587804560 10949812224 1646690160 16.736 100 82 164 0 1682005600 11090112 24225328
14:03:11 14464 8192000000 10607327072 10974470144 1664745840 16.889 100 75 148 2 1697705888 11306512 21653536
14:03:34 14569 8192000000 10630432704 10999369728 1688309712 17.087 100 79 156 1 1721442416 10718656 22414048
14:03:57 13254 8192000000 10650533648 11020439552 1710161504 17.270 100 76 152 0 1743384304 11381568 21841232
14:04:18 6701 8192000000 10669433584 11041181696 1727053744 17.411 100 80 160 0 1761176384 11435936 22686704
14:04:34 8504 8192000000 10661402864 11037589504 1728976784 17.427 100 80 160 0 1764660192 12989888 22693520
14:04:50 8658 8192000000 10685265248 11057467392 1744273232 17.554 100 91 182 1 1784480352 14175968 26031152
14:05:07 6830 8192000000 10687255568 11065679872 1749793616 17.600 100 84 169 0 1786563600 13036608 23733376
14:05:22 9937 8192000000 10694062592 11074629632 1757358704 17.663 100 74 147 0 1791580016 13391920 20829392
14:05:39 5252 8192000000 10696309216 11078610944 1765630384 17.731 100 76 153 2 1800052752 12636608 21785760
14:05:53 6487 8192000000 10722377824 11099525120 1777969360 17.833 100 88 171 2 1815075008 12915552 24190096
14:06:05 3177 8192000000 10721139824 11103223808 1783842304 17.881 100 78 152 2 1817848976 12665776 21340896
14:06:15 4619 8192000000 10738296112 11117535232 1792896720 17.956 100 85 167 2 1830049744 12718880 24434144
14:06:27 4325 8192000000 10744092928 11128012800 1801635248 18.027 100 77 153 0 1834916224 12050800 21230176
14:06:38 7426 8192000000 10745043872 11134603264 1808050880 18.080 100 81 159 1 1843155904 11830224 23274800
14:06:55 2342 8192000000 10743587024 11129184256 1809921744 18.095 100 82 163 1 1845237024 12501040 22814240
14:07:05 3992 8192000000 10765073280 11149279232 1820353504 18.181 100 87 169 3 1857011856 12901440 23756912
14:07:16 4017 8192000000 10768672224 11153862656 1828083712 18.244 100 89 178 2 1866871376 13851344 24936320
14:07:27 2938 8192000000 10783236704 11166580736 1834714432 18.298 100 86 169 1 1873253408 14149664 24389312
14:07:37 3224 8192000000 10774610480 11161858048 1842609328 18.362 100 88 178 1 1880661456 13523008 24529120
14:07:47 2623 8192000000 10780046288 11170648064 1842303584 18.360 100 87 172 0 1881812384 15304064 24204736
14:07:57 3164 8192000000 10786147120 11178008576 1844465104 18.377 100 89 178 2 1885951904 16099200 25387600
14:08:07 2101 8192000000 10787240416 11175710720 1847011232 18.398 100 90 179 1 1886370960 13940368 25419360
14:08:16 1768 8192000000 10790943856 11180269568 1847365360 18.401 100 83 166 4 1883154048 12558736 23229952
14:08:24 2780 8192000000 10801683120 11193536512 1857674816 18.484 100 88 173 2 1893467936 12234368 23558752
14:08:34 3885 8192000000 10799645728 11190095872 1862778720 18.526 100 93 183 1 1902565824 13508192 26278912
14:08:44 2166 8192000000 10806941024 11194089472 1864942608 18.543 100 91 183 1 1904821632 14081952 25797072
14:08:53 1346 8192000000 10812630896 11198476288 1865186048 18.545 100 94 188 1 1904001280 13089856 25725376
14:09:00 1991 8192000000 10808159680 11198062592 1868089616 18.569 100 90 179 3 1906349264 12211568 26048080
14:09:08 39624 8192000000 10780409152 11197173760 1866525392 18.556 100 68 136 0 1896756640 10711456 19519792
14:09:57 1435 8192000000 10812127568 11208048640 1874631360 18.622 100 83 166 0 1907207168 8474464 24101344
14:10:05 3324 8192000000 10791234160 11206742016 1870477296 18.588 100 58 115 1 1897262400 10851856 15933248
14:10:20 8238 8192000000 10783731168 11206221824 1872340496 18.603 100 39 77 0 1891448704 8826304 10281904
14:10:36 8341 8192000000 10790289808 11213766656 1875932864 18.632 100 37 74 1 1891940288 6420544 9586880
14:10:51 4429 8192000000 10788963680 11213844480 1876719952 18.639 100 31 63 5 1892199968 6911120 8568896
14:11:02 3548 8192000000 10793955376 11218599936 1878892832 18.656 100 33 64 0 1894810832 7109248 8808752
14:11:12 5507 8192000000 10786749344 11220217856 1883848224 18.696 100 37 74 2 1901706192 7667152 10190816
14:11:28 4233 8192000000 10795836384 11219230720 1882499088 18.685 100 34 67 2 1899414384 6926928 9988368
14:11:39 7521 8192000000 10793972144 11222597632 1882135408 18.682 100 25 50 2 1895143040 6003040 7004592
14:11:56 15555 8192000000 10795681488 11229749248 1885662384 18.711 100 9 18 0 1897639888 9777744 2199760
14:12:17 7801 8192000000 10810056928 11236958208 1890890880 18.753 100 23 46 1 1908807008 11216096 6700032
14:12:33 11803 8192000000 10806068336 11234168832 1891077600 18.754 100 16 32 1 1905484816 9716784 4690432
14:12:53 13478 8192000000 10796889648 11237036032 1894588848 18.783 100 10 20 2 1902857280 5382096 2886336
14:13:13 16301 8192000000 10816777712 11244769280 1895343328 18.789 100 20 40 2 1906776448 5407808 6025312
14:13:36 62953 8192000000 10850748256 11258294272 1905051104 18.867 100 49 96 0 1925318176 6187184 14079888
14:14:45 7289 8192000000 10806962944 11250188288 1900554432 18.831 100 16 32 0 1911317216 6670336 4092448
14:15:02 5871 8192000000 10820326528 11250917376 1903243136 18.852 100 29 59 0 1918576048 7052080 8280832
14:15:14 3810 8192000000 10823432128 11250974720 1904570272 18.863 100 36 72 0 1926745152 12565952 9608928
14:15:25 3048 8192000000 10830648656 11255291904 1908306432 18.893 100 43 86 2 1928370848 8274944 11789472
14:15:36 2686 8192000000 10838905616 11264638976 1907294000 18.885 100 42 84 0 1926903408 8137008 11472400
14:15:47 7718 8192000000 10823697312 11246010368 1887384768 18.725 99 19 40 0 1898390560 5815824 5189968
14:16:00 6828 8192000000 10835211568 11255463936 1904604528 18.863 100 33 66 2 1921080400 7215760 9260112
14:16:14 6230 8192000000 10800082880 11233935360 1891968496 18.762 100 39 79 4 1910582096 6778880 11834720
14:16:26 11591 8192000000 10793438368 11240157184 1863362720 18.531 98 27 54 1 1876954880 4951472 8640688
14:16:44 8658 8192000000 10810746896 11246084096 1881790432 18.680 99 17 34 0 1892889152 6204944 4893776
14:17:00 8486 8192000000 10799432112 11243565056 1883079872 18.690 99 29 58 1 1897010832 5836992 8093968
14:17:16 6996 8192000000 10802069360 11240456192 1894849792 18.785 100 26 52 2 1908618624 5982784 7786048
14:17:34 8990 8192000000 10795502112 11230269440 1851981760 18.438 98 16 30 0 1861351136 5117424 4251952
14:17:49 10228 8192000000 10776898048 11207278592 1813525808 18.125 96 20 41 1 1824145008 5137520 5481680
14:18:07 13059 8192000000 10801772976 11222208512 1871298560 18.595 99 28 56 3 1884785296 5766544 7720192
14:19:07 21739 8192000000 10772016192 11200888832 1802316944 18.033 96 26 52 2 1815322080 5044624 7960512
14:19:36 11567 8192000000 10767422400 11194699776 1820788544 18.184 98 22 44 0 1832882272 6047360 6046368
14:19:55 5841 8192000000 10752461344 11168468992 1776247584 17.819 96 39 78 2 1794124032 6886848 10989600
14:20:10 4858 8192000000 10689415792 11100393472 1735329440 17.480 95 33 64 0 1750133856 4959840 9844576
14:20:21 7181 8192000000 10751727216 11172073472 1828031168 18.243 100 28 55 1 1842790112 6305680 8453264
14:20:34 8868 8192000000 10727252352 11140505600 1757314224 17.662 96 23 46 1 1769584832 5605504 6665104
14:20:51 6286 8192000000 10724783328 11137503232 1786506496 17.903 98 26 50 1 1799893104 6131008 7255600
14:21:06 8450 8192000000 10684955904 11097137152 1728129216 17.420 96 30 60 0 1742720528 6359968 8231344
14:21:23 12920 8192000000 10683536560 11088355328 1697884624 17.167 94 29 58 2 1711980768 6327344 7768800
14:21:43 8724 8192000000 10721806912 11133464576 1749602288 17.598 97 30 60 0 1763955920 5142272 9211360
14:22:03 5966 8192000000 10720776048 11131752448 1772977328 17.792 98 35 70 1 1789605216 5693664 10934224
14:22:15 10296 8192000000 10729517088 11150716928 1809236112 18.090 100 21 42 1 1824814352 9575600 6002640
14:22:32 10577 8192000000 10726269808 11142307840 1780217408 17.851 98 25 50 0 1793337200 5932368 7187424
14:22:54 12463 8192000000 10738619088 11155955712 1817744064 18.159 100 19 38 1 1829037472 5600064 5693344
14:23:14 76490 8192000000 10737258416 11160715264 1793911072 17.964 98 24 48 1 1806702448 5233760 7557616
14:24:36 9121 8192000000 10743578192 11168825344 1815066800 18.137 99 23 46 1 1828018016 6522256 6428960
14:24:54 7479 8192000000 10755606720 11182206976 1838581984 18.329 100 35 70 0 1859116400 10702624 9831792
14:25:11 7543 8192000000 10768271376 11189252096 1849036656 18.414 100 30 57 4 1867832560 10376512 8419392
14:25:26 7875 8192000000 10764543440 11189207040 1849156784 18.415 100 21 43 2 1861689024 6262720 6269520
14:25:42 7317 8192000000 10774192528 11199242240 1849998176 18.422 100 22 44 2 1866778496 10535664 6244656
14:25:56 6872 8192000000 10781934720 11195490304 1854405968 18.458 100 37 74 1 1871202720 5301088 11495664
14:26:11 3898 8192000000 10766545856 11195740160 1852338544 18.441 100 25 50 1 1865930624 6465696 7126384
14:26:23 4681 8192000000 10765814304 11194372096 1853184496 18.448 100 22 44 0 1869474144 10293712 5995936
14:26:35 9957 8192000000 10782031968 11210047488 1854843872 18.461 100 15 30 0 1868909888 9562272 4503744
14:26:54 13423 8192000000 10794601520 11213570048 1869041952 18.577 100 28 56 0 1882212768 4966496 8204320
14:27:16 28390 8192000000 10820605744 11237462016 1894236384 18.780 100 49 95 3 1914780736 6782240 13762112
14:27:56 8440 8192000000 10830210560 11246620672 1901879264 18.841 100 53 103 1 1928460416 12330448 14250704
14:28:13 23928 8192000000 10837661888 11253440512 1911463056 18.918 100 58 115 1 1938932608 10167472 17302080
14:28:45 30510 8192000000 10857232352 11271172096 1915671456 18.952 100 45 90 0 1937943008 9749808 12521744
14:29:32 76702 8192000000 10853664736 11288899584 1922019632 19.003 100 29 58 1 1941481456 11256112 8205712
14:31:10 15300 8192000000 10867282768 11296604160 1937267984 19.125 100 41 80 1 1966606256 16296672 13041600
14:31:40 45412 8192000000 10875896976 11317526528 1941225136 19.157 100 38 75 1 1969331184 16668560 11437488
14:32:37 15243 8192000000 10888004064 11318022144 1952893152 19.250 100 44 85 0 1985598896 20669216 12036528
14:33:03 2694 8192000000 10904596704 11324461056 1956663440 19.280 100 62 124 0 1992675728 17818144 18194144
14:33:12 6330 8192000000 10900192560 11322556416 1939555856 19.143 99 57 112 2 1975157520 18934784 16666880
14:33:37 14728 8192000000 10910525760 11330560000 1957033424 19.282 100 54 105 0 1992569376 20829856 14706096
14:33:59 8152 8192000000 10905583008 11328225280 1942189936 19.164 99 50 100 3 1978538912 20963680 15385296
14:34:20 16599 8192000000 10904027184 11340587008 1956327120 19.277 100 41 81 2 1989864960 21631152 11906688
14:34:44 12594 8192000000 10912397488 11343097856 1959977600 19.306 100 44 88 0 1996051200 22257360 13816240
14:35:21 6120 8192000000 10915486480 11351879680 1970852032 19.392 100 47 93 0 2007671808 23628864 13190912
14:35:38 3077 8192000000 10933159264 11357032448 1975467680 19.429 100 67 132 0 2018963808 23817296 19678832
14:35:50 3193 8192000000 10939443072 11365302272 1981991856 19.480 100 67 131 0 2027110704 25456064 19662784
14:35:59 5347 8192000000 10937686576 11369586688 1984279088 19.499 100 63 126 1 2030514768 27315936 18919744
14:36:18 6746 8192000000 10929312208 11364724736 1987345392 19.523 100 63 126 0 2029724176 22787920 19590864
14:36:38 8501 8192000000 10933400256 11355918336 1977006464 19.441 100 62 124 2 2017666640 22356880 18303296
14:36:54 6439 8192000000 10941085792 11365900288 1985924016 19.512 100 68 133 0 2030161216 24326688 19910512
14:37:10 2430 8192000000 10957058608 11374555136 1993550336 19.572 100 81 162 0 2041190176 22259760 25380080
14:37:26 6267 8192000000 10948420064 11378585600 1996292528 19.593 100 63 120 1 2036749344 22988240 17468576
14:37:44 6591 8192000000 10957117264 11383951360 2001002208 19.631 100 66 133 4 2043915008 22581824 20330976
14:37:59 9163 8192000000 10969109680 11392225280 2008897136 19.693 100 73 147 1 2056668128 25269280 22501712
14:38:17 3507 8192000000 10972221824 11399233536 2009919040 19.701 100 70 140 0 2056685152 25309536 21456576
14:38:28 4823 8192000000 10959177024 11397259264 2007228528 19.680 100 50 100 0 2046911152 24349248 15333376
14:38:40 6757 8192000000 10967560256 11399000064 2015424624 19.744 100 62 121 2 2056227728 22701088 18102016
14:38:54 3918 8192000000 10971409968 11398021120 2011178080 19.711 100 69 139 2 2056154192 23565968 21410144
14:39:09 8874 8192000000 10980116416 11406589952 2019908448 19.779 100 76 152 1 2068291984 25932112 22451424
14:39:28 3998 8192000000 10983389648 11413581824 2021586992 19.793 100 68 135 1 2069033008 27247856 20198160
14:39:40 6316 8192000000 10962301552 11381370880 1995578992 19.588 99 74 147 0 2046069008 28496992 21993024
14:39:53 4926 8192000000 10961466704 11382583296 1997551360 19.603 100 76 150 0 2049596000 28938976 23105664
14:40:07 7483 8192000000 10965895248 11386232832 1994822752 19.582 100 76 152 1 2048274464 30170896 23280816
14:40:23 4379 8192000000 10956481552 11387424768 1995874048 19.590 100 64 128 3 2045728912 30218240 19636624
14:40:46 3396 8192000000 10969138112 11396534272 2003082896 19.647 100 69 138 1 2055944112 31241280 21619936
14:40:59 3419 8192000000 10958661520 11391852544 1986893344 19.519 99 62 123 1 2038480176 31882240 19704592
14:41:11 5671 8192000000 10981632304 11405709312 2007530352 19.682 100 69 135 1 2059695168 31153664 21011152
14:41:24 4153 8192000000 10969933584 11388706816 1987627200 19.525 99 80 161 1 2046920496 33586848 25706448
14:41:37 4649 8192000000 10958308128 11380871168 1971895760 19.400 99 78 156 4 2030342688 34805536 23641392
14:41:49 4331 8192000000 10961047808 11386228736 1988757232 19.534 100 66 130 3 2045255776 35918880 20579664
14:42:00 5999 8192000000 10975289104 11400404992 1999204336 19.616 100 78 154 2 2060352112 36447696 24700080
14:42:17 9804 8192000000 10968890192 11401867264 2003259808 19.648 100 63 126 1 2061677392 38366496 20051088
14:42:35 5712 8192000000 10968226512 11391819776 1992375792 19.563 100 67 135 1 2052709520 38686816 21646912
14:42:48 3377 8192000000 10957032320 11384193024 1979519584 19.461 100 62 121 0 2039801104 40099344 20182176
14:43:00 4080 8192000000 10952809888 11379281920 1969662736 19.383 99 64 124 1 2030344864 40540320 20141808
14:43:12 1698 8192000000 10970424240 11382403072 1986160976 19.513 100 82 163 0 2047299216 35305072 25833168
14:43:23 9576 8192000000 10960938528 11395018752 1995179600 19.585 100 58 116 0 2048594800 35117776 18297424
14:43:40 3086 8192000000 10980291152 11399172096 1986272208 19.514 99 77 153 0 2046952512 35714560 24965744
14:43:54 9885 8192000000 10978037040 11406671872 1999546080 19.619 100 74 144 3 2060117536 37743552 22827904
14:44:20 6568 8192000000 10972593888 11402346496 1989341392 19.539 99 65 130 0 2047131504 37047952 20742160
14:44:33 4401 8192000000 10978315392 11407876096 2004410592 19.658 100 64 127 1 2059922448 35402016 20109840
14:44:45 2061 8192000000 10969866496 11385618432 1986396240 19.515 100 88 176 0 2048019584 33906496 27716848
14:44:55 6007 8192000000 10961891472 11384807424 1987729296 19.526 100 71 142 2 2043780048 34559456 21491296
14:45:11 4064 8192000000 10961262256 11379384320 1978957040 19.456 100 76 150 0 2036267808 34503248 22807520
14:45:24 5669 8192000000 10958008784 11382431744 1979072608 19.457 100 67 133 2 2036553440 37033984 20446848
14:45:50 6081 8192000000 10953430832 11379920896 1974880496 19.424 100 64 128 2 2031811872 36506960 20424416
14:46:04 1785 8192000000 10931185248 11352035328 1955826224 19.273 99 74 148 3 2017612016 37932656 23853136
14:46:14 2748 8192000000 10964172272 11378561024 1980896400 19.472 100 80 161 3 2042830800 36981952 24952448
14:46:25 1176 8192000000 10981684608 11390959616 1992271552 19.562 100 88 174 2 2054803856 35829072 26703232
14:46:33 2721 8192000000 10958564784 11370770432 1974190144 19.419 99 84 167 0 2036518928 36314720 26014064
14:46:43 1937 8192000000 10975140480 11389018112 1975884064 19.432 99 86 170 1 2038863904 36326384 26653456
14:46:56 2918 8192000000 10970284640 11387518976 1990208848 19.545 100 84 168 2 2051931792 36178288 25544656
14:47:08 1848 8192000000 10962206464 11365695488 1957451264 19.286 98 92 184 3 2022889472 37663376 27774832
14:47:17 1879 8192000000 10976124816 11383037952 1988936448 19.535 100 90 180 2 2055281280 38816240 27528592
14:47:28 12237 8192000000 10938637328 11381379072 1967782720 19.368 99 47 94 0 2020514464 37771904 14959840
14:47:48 12430 8192000000 10950439920 11393536000 1986943472 19.520 100 43 86 2 2039075328 38464432 13667424
14:48:12 16121 8192000000 10930730896 11373260800 1946065616 19.195 98 33 66 2 1993431488 36295840 11070032
14:48:35 16274 8192000000 10940292720 11373977600 1954888592 19.265 99 38 76 0 2005320848 37362848 13069408
14:49:02 4508 8192000000 10943873136 11371741184 1936399952 19.118 98 56 112 0 2004246368 49614560 18231856
14:49:15 13016 8192000000 10938456512 11379748864 1965739360 19.352 100 41 82 1 2028133824 48559312 13835152
14:49:41 6578 8192000000 10946121056 11384987648 1969408704 19.381 100 44 88 2 2033202512 48564128 15229680
14:49:54 13992 8192000000 10951662656 11388485632 1961416976 19.317 99 51 102 0 2024175904 46105328 16653600
14:50:20 7547 8192000000 10945661440 11385323520 1953896000 19.257 99 40 80 2 2019729904 52279424 13554480
14:50:35 18168 8192000000 10925253984 11365302272 1911079024 18.915 97 42 84 0 1969560768 44261840 14219904
14:51:02 9873 8192000000 10933483168 11373555712 1954164480 19.260 100 47 90 1 2015911200 46532864 15213856
14:51:25 19623 8192000000 10899257328 11350962176 1919008480 18.979 99 34 68 1 1971834144 40846928 11978736
14:52:12 20239 8192000000 10902234928 11352006656 1946928640 19.202 100 32 64 1 1992359184 34206256 11224288
14:52:41 16864 8192000000 10885322224 11339673600 1912685056 18.928 98 25 50 0 1951880496 30497152 8698288
14:53:04 30351 8192000000 10874804496 11333505024 1901155312 18.836 98 23 46 2 1938932080 29940112 7836656
14:53:42 13592 8192000000 10866780672 11311697920 1881442656 18.677 98 16 32 2 1918826640 31448720 5935264
14:54:05 9585 8192000000 10862988768 11319119872 1907025840 18.883 100 14 28 0 1946544816 34171888 5347088
14:54:21 22218 8192000000 10859288016 11314995200 1899656848 18.824 100 18 36 3 1942932336 36235744 7039744
14:54:51 24131 8192000000 10879040864 11336634368 1898384720 18.813 99 19 38 1 1948381728 43106000 6891008
14:55:31 41314 8192000000 10840805936 11309793280 1872244560 18.602 98 9 18 0 1896095456 20365744 3485152
14:56:19 31050 8192000000 10819142992 11280977920 1881023440 18.673 99 7 14 1 1898247136 15024192 2199504
14:56:56 69536 8192000000 10877370688 11300700160 1872533984 18.605 97 44 86 3 1891598544 6867888 12196672
14:58:14 54977 8192000000 10867562864 11319996416 1919545680 18.983 99 20 40 1 1937268624 12303808 5419136
15:00:11 70254 8192000000 10872523216 11344805888 1926424384 19.038 99 16 32 1 1945980208 15042880 4512944
15:01:28 158781 8192000000 10864464064 11326636032 1888383808 18.733 97 14 28 2 1906649024 14907536 3357680
15:05:36 33548 8192000000 10881569840 11316264960 1934603920 19.104 99 54 109 4 1968318320 17239232 16475168
15:06:22 132583 8192000000 10901014576 11347914752 1918146304 18.972 98 36 72 0 1940193024 11980960 10065760
15:08:50 46600 8192000000 10900434144 11356192768 1958525744 19.294 100 43 86 0 1989278528 18061552 12691232
15:09:43 34857 8192000000 10911237424 11365179392 1967560912 19.366 100 28 56 0 1993135520 16890624 8683984
15:10:27 47784 8192000000 10902147520 11372793856 1972841008 19.408 100 37 74 0 2005592128 20623536 12127584
15:11:21 80414 8192000000 10896857440 11375828992 1974481456 19.421 100 11 22 0 1994805056 17101456 3222144
15:12:53 16816 8192000000 10903492688 11384487936 1977523280 19.445 100 10 20 0 1996361568 16172080 2666208
15:13:39 32571 8192000000 10898233504 11377049600 1961840704 19.321 99 14 29 0 1977949280 11989760 4118816
15:14:18 16044 8192000000 10887076272 11368833024 1967114624 19.363 100 3 6 0 1980265712 12383440 767648
15:14:40 22668 8192000000 10889493104 11367428096 1974261824 19.419 100 11 21 0 1988170640 10626576 3282240
15:15:13 45218 8192000000 10894876128 11370819584 1963414336 19.333 99 18 37 1 1980900864 12130464 5356064
15:16:07 48141 8192000000 10905975328 11379122176 1980262624 19.467 100 15 30 0 1994898144 10287792 4347728
15:18:58 44277 8192000000 10901485776 11377213440 1961811856 19.320 99 15 30 0 1979844528 13474800 4557872
15:19:48 79897 8192000000 10901348480 11381047296 1961683888 19.319 99 19 39 0 1977335856 10045744 5606224
15:21:16 92667 8192000000 10886841664 11366305792 1912415456 18.926 97 8 16 1 1927943504 13752736 1775312
15:22:55 75439 8192000000 10911280352 11368607744 1933543680 19.095 98 14 27 0 1949434992 11801840 4089472
15:24:16 39991 8192000000 10923490672 11383083008 1986615584 19.517 100 25 50 0 2003757888 10169776 6972528
15:25:05 49065 8192000000 10904760016 11383259136 1962403040 19.325 99 26 52 0 1983030720 12673792 7953888
15:26:00 55589 8192000000 10934717056 11401654272 1992880496 19.567 100 16 32 0 2011181424 14153872 4147056
15:27:04 72264 8192000000 10880117344 11341799424 1827512496 18.239 92 18 37 2 1847410096 15270704 4626896
15:28:23 26790 8192000000 10903741808 11350335488 1935820064 19.113 99 30 60 0 1952182928 8397776 7965088
15:28:58 14338 8192000000 10873524128 11324678144 1899173424 18.820 97 39 78 2 1920011920 10296320 10542176
15:29:21 30131 8192000000 10867453936 11335507968 1916325824 18.957 98 38 76 1 1937712896 11188592 10198480
15:30:03 58284 8192000000 10869605888 11339649024 1877828736 18.648 96 26 52 3 1898666032 13712192 7125104
15:31:07 50769 8192000000 10876961424 11338252288 1894631648 18.783 97 21 42 0 1911349616 10737856 5980112
15:32:13 36549 8192000000 10898874096 11354095616 1943070976 19.171 99 41 81 2 1965886448 11212848 11602624
15:32:56 73483 8192000000 10900690336 11373174784 1925216144 19.029 98 21 42 1 1947306544 15984048 6106352
15:34:16 66843 8192000000 10896539936 11372322816 1899122000 18.819 97 16 32 1 1921066736 17703664 4241072
15:35:35 130926 8192000000 10844154000 11308294144 1800780864 18.020 92 19 37 2 1821513344 15477344 5255136
15:38:24 68586 8192000000 10859472800 11315408896 1897922608 18.810 98 28 56 3 1913521120 7932112 7666400
15:39:41 26813 8192000000 10886690240 11335335936 1927546640 19.047 99 55 110 1 1953918048 10755280 15616128
15:41:01 41354 8192000000 10908054384 11351220224 1936579136 19.119 99 33 66 0 1955938912 9964160 9395616
15:41:52 46959 8192000000 10876871792 11340214272 1918771712 18.977 98 26 52 1 1937007200 10813280 7422208
15:42:45 74504 8192000000 10850500880 11320909824 1873534896 18.613 96 7 14 0 1884728688 9189312 2004480
15:44:09 45287 8192000000 10849610608 11334213632 1918658992 18.976 99 13 26 0 1936787536 14151760 3976784
15:45:06 76231 8192000000 10850056640 11329118208 1905016192 18.867 98 10 20 1 1916874784 8905968 2952624
15:47:11 47697 8192000000 10870543392 11328499712 1915737696 18.953 99 21 42 0 1930779504 9042000 5999808
15:48:16 55386 8192000000 10815919216 11275124736 1872779104 18.607 97 20 40 1 1890825776 12385920 5660752
15:50:01 56052 8192000000 10871840000 11332104192 1927065360 19.043 99 23 46 2 1950919712 16851184 7003168
15:51:04 75796 8192000000 10866383408 11348414464 1931620704 19.080 99 15 30 0 1949922176 13527120 4774352
15:52:35 37982 8192000000 10856871808 11319865344 1868632064 18.573 96 17 34 0 1881871776 8385456 4854256
15:53:27 20632 8192000000 10889605056 11339653120 1948780704 19.217 100 42 84 1 1969600848 8601792 12218352
15:53:54 26623 8192000000 10882057856 11334230016 1915520320 18.951 98 35 70 4 1935001792 10113680 9367792
15:54:33 31933 8192000000 10892471760 11345235968 1946121888 19.196 100 33 66 0 1967486832 12155216 9209728
15:56:15 74785 8192000000 10905017072 11370954752 1948982800 19.218 99 20 40 1 1963787440 9482752 5321888
15:57:36 64985 8192000000 10913196832 11362578432 1903669888 18.856 96 26 52 2 1922329488 12100304 6559296
15:58:49 87695 8192000000 10922809984 11398328320 1979245328 19.459 100 13 27 0 1998668816 15730304 3693184
16:00:39 75785 8192000000 10904619552 11387285504 1959567984 19.303 99 11 21 0 1983745024 21433760 2743280
16:02:31 48332 8192000000 10921230304 11382603776 1987233504 19.522 100 31 60 1 2003138944 7218656 8686784
16:03:37 28288 8192000000 10861531392 11338227712 1920479312 18.991 97 13 26 0 1932095344 8121248 3494784
16:04:11 62487 8192000000 10870671792 11352952832 1943897120 19.178 99 13 25 1 1954785936 7316736 3572080
16:05:28 39848 8192000000 10869278352 11352756224 1928601280 19.056 98 5 10 0 1936325296 6760576 963440
16:06:34 55694 8192000000 10876164272 11349848064 1909556496 18.903 97 17 34 2 1920361296 5889856 4914944
16:07:36 57474 8192000000 10859674144 11326230528 1885375632 18.708 96 9 18 0 1893615392 5334320 2905440
16:08:55 55036 8192000000 10867680880 11333730304 1928980368 19.059 99 26 51 0 1943375472 7700016 6695088
16:09:56 45811 8192000000 10861303408 11332005888 1914774608 18.945 98 19 38 1 1929350272 8424800 6150864
16:10:48 23491 8192000000 10867618320 11339296768 1931372464 19.078 99 25 49 0 1948683200 10026688 7284048
16:12:47 64218 8192000000 10899797344 11382857728 1948773136 19.217 99 11 21 1 1967726416 15801664 3151616
16:13:59 63516 8192000000 10850876864 11336433664 1851430784 18.434 94 15 30 0 1867166288 11307488 4428016
16:15:14 47139 8192000000 10882286960 11350278144 1953903344 19.258 100 22 44 4 1969516768 9289760 6323664
16:16:14 62467 8192000000 10856350256 11322556416 1864290448 18.538 95 16 32 2 1876616320 8177088 4148784
16:17:27 38230 8192000000 10871901072 11334426624 1923941296 19.018 99 41 82 1 1942905280 7981264 10982720
16:18:16 44380 8192000000 10856112912 11317166080 1849275344 18.416 95 36 72 1 1872588368 12973616 10339408
16:19:07 87601 8192000000 10858080032 11325878272 1855562512 18.467 96 24 48 1 1877967200 15278032 7126656
16:20:43 116834 8192000000 10873020752 11340177408 1885797840 18.712 97 14 28 1 1902260720 12033424 4429456
16:22:56 173193 8192000000 10852624800 11320926208 1749015760 17.593 90 8 16 0 1767206752 16034480 2156512
16:26:00 88077 8192000000 9938822256 10308603904 1072336384 11.574 56 13 24 1 1081000016 5021328 3642304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 06-11-2020 16:29:16 to 06-11-2020 16:29:47.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-11-2020 16:29:47 to 06-11-2020 16:29:49.

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

06.11.20 16:29:50. 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-06 16:29:53 No severe PSQL-related problems occured
06.11.20 16:29:54. End of report.