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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-28 01:27:11
DTS_END                         2021-01-28 01:27:11.4930
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60470
TRN_ID                          229403
ATT_ID                          694
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: 9051.19 21059 1086143
customer order: creation 161.50 366 19380
customer order: refuse 14.24 322 1709
order to supplier: creation 42.43 1338 5092
order to supplier: removal 3.28 108711 394
invoice (draft): creation 42.88 3351 5145
invoice (draft): removal 53.81 744 6457
invoice accept: apply 39.74 17685 4769
invoice accept: cancel 48.88 821 5866
customer reserve: creation 3639.26 176 436711
customer reserve: removal 4714.17 60 565700
realization accept: apply 78.50 172 9420
realization accept: cancel 90.94 111 10913
payment from customer: creation 55.78 148 6693
payment from customer: removal 5.13 104 616
payment to supplier: creation 46.17 118 5540
payment to supplier: removal 3.54 83 425
service: total inventory turnovers 4.27 1246 512
service: total monetary turnovers 5.88 31 705
service: aggregate perf. data 0.77 25020 92
service: refresh index statistics 0.03 260577 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 28-01-2021 01:29:31 to 28-01-2021 01:29:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5694
TEST_TIME 2 5020
TEST_TIME 3 5311
TEST_TIME 4 5478
TEST_TIME 5 5315
TEST_TIME 6 5216
TEST_TIME 7 5037
TEST_TIME 8 4832
TEST_TIME 9 4989
TEST_TIME 10 5396
TEST_TIME 11 5672
TEST_TIME 12 5789
TEST_TIME 13 5859
TEST_TIME 14 6567
TEST_TIME 15 6859
TEST_TIME 16 6832
TEST_TIME 17 6970
TEST_TIME 18 7272
TEST_TIME 19 8283
TEST_TIME 20 8455
TEST_TIME 21 8736
TEST_TIME 22 8719
TEST_TIME 23 8604
TEST_TIME 24 9302
TEST_TIME 25 9794
TEST_TIME 26 10353
TEST_TIME 27 10873
TEST_TIME 28 10661
TEST_TIME 29 10334
TEST_TIME 30 10613
TEST_TIME 31 10793
TEST_TIME 32 10552
TEST_TIME 33 10417
TEST_TIME 34 10261
TEST_TIME 35 10093
TEST_TIME 36 9908
TEST_TIME 37 9781
TEST_TIME 38 9827
TEST_TIME 39 9789
TEST_TIME 40 9770
TEST_TIME 41 9799
TEST_TIME 42 9624
TEST_TIME 43 9542
TEST_TIME 44 9539
TEST_TIME 45 9476
TEST_TIME 46 9555
TEST_TIME 47 9433
TEST_TIME 48 9367
TEST_TIME 49 9222
TEST_TIME 50 9158
TEST_TIME 51 9171
TEST_TIME 52 9091
TEST_TIME 53 9051
TEST_TIME 54 8939
TEST_TIME 55 8956
TEST_TIME 56 8866
TEST_TIME 57 8864
TEST_TIME 58 8841
TEST_TIME 59 9048
TEST_TIME 60 9007
TEST_TIME 61 9093
TEST_TIME 62 9094
TEST_TIME 63 9206
TEST_TIME 64 9192
TEST_TIME 65 9223
TEST_TIME 66 9292
TEST_TIME 67 9358
TEST_TIME 68 9361
TEST_TIME 69 9439
TEST_TIME 70 9460
TEST_TIME 71 9357
TEST_TIME 72 9303
TEST_TIME 73 9261
TEST_TIME 74 9254
TEST_TIME 75 9206
TEST_TIME 76 9167
TEST_TIME 77 9175
TEST_TIME 78 9097
TEST_TIME 79 9101
TEST_TIME 80 9147
TEST_TIME 81 9218
TEST_TIME 82 9202
TEST_TIME 83 9190
TEST_TIME 84 9203
TEST_TIME 85 9242
TEST_TIME 86 9346
TEST_TIME 87 9316
TEST_TIME 88 9268
TEST_TIME 89 9238
TEST_TIME 90 9342
TEST_TIME 91 9323
TEST_TIME 92 9399
TEST_TIME 93 9324
TEST_TIME 94 9264
TEST_TIME 95 9238
TEST_TIME 96 9200
TEST_TIME 97 9136
TEST_TIME 98 9124
TEST_TIME 99 9076
TEST_TIME 100 9025
TEST_TIME 101 9076
TEST_TIME 102 9054
TEST_TIME 103 9073
TEST_TIME 104 9026
TEST_TIME 105 9022
TEST_TIME 106 9103
TEST_TIME 107 9110
TEST_TIME 108 9093
TEST_TIME 109 9154
TEST_TIME 110 9152
TEST_TIME 111 9129
TEST_TIME 112 9253
TEST_TIME 113 9265
TEST_TIME 114 9240
TEST_TIME 115 9221
TEST_TIME 116 9182
TEST_TIME 117 9151
TEST_TIME 118 9142
TEST_TIME 119 9125
TEST_TIME 120 9055

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-01-2021 01:29:35 to 28-01-2021 01:29:38.

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 1490339 1490339 0 0.00 0 33576 6 0 0
doc_list_biud 1490335 1490335 0 0.00 0 61765 29 0 0
sp_add_invoice_to_stock 4912 4769 143 2.91 38 204884 17685 0 143
sp_cancel_adding_invoice 5866 5866 0 0.00 5 76785 822 0 0
sp_cancel_client_order 1709 1709 0 0.00 4 8240 323 0 0
sp_cancel_customer_reserve 565700 565700 0 0.00 1 61766 61 0 0
sp_cancel_pay_from_customer 616 616 0 0.00 2 4833 104 0 0
sp_cancel_pay_to_supplier 425 425 0 0.00 3 11351 83 0 0
sp_cancel_supplier_invoice 6462 6457 5 0.07 2 16112 744 0 5
sp_cancel_supplier_order 394 394 0 0.00 7 1038270 108711 0 0
sp_cancel_write_off 10913 10913 0 0.00 1 8634 112 0 0
sp_client_order 19380 19380 0 0.00 3 21923 366 0 0
sp_customer_reserve 436711 436711 0 0.00 0 59772 176 0 0
sp_fill_shopping_cart 29607 29607 0 0.00 1 27529 42 0 0
sp_fill_shopping_cart_clo_res 436701 436701 0 0.00 0 13581 14 0 0
sp_get_clo_for_invoice 4758 4758 0 0.00 0 30007 342 0 0
sp_kill_cost_storno 17820 17820 0 0.00 0 33564 62 0 0
sp_kill_qstorno_ret_qs2qd 1149164 1149164 0 0.00 0 61762 32 0 0
sp_kill_qty_storno 605213 605213 0 0.00 0 61764 70 0 0
sp_lock_selected_doc 19731 19731 0 0.00 0 6526 5 0 0
sp_make_cost_storno 26410 26410 0 0.00 0 12607 53 0 0
sp_multiply_rows_for_pdistr 26407 26407 0 0.00 0 8454 31 0 0
sp_multiply_rows_for_qdistr 19380 19380 0 0.00 0 21915 181 0 0
sp_pay_from_customer 6693 6693 0 0.00 4 15214 149 0 0
sp_pay_to_supplier 5540 5540 0 0.00 5 11322 119 0 0
sp_payment_common 12232 12232 0 0.00 1 10898 31 0 0
sp_qd_handle_on_cancel_clo 1709 1709 0 0.00 0 8225 285 0 0
sp_qd_handle_on_invoice_upd_sts 10621 10621 0 0.00 0 31706 329 0 0
sp_qd_handle_on_reserve_upd_sts 9419 9419 0 0.00 0 18988 54 0 0
sp_reserve_write_off 9420 9420 0 0.00 7 19097 173 0 0
sp_supplier_invoice 5145 5145 0 0.00 7 73200 3352 0 0
sp_supplier_order 5092 5092 0 0.00 6 43618 1339 0 0
srv_aggregate_perf_data 92 92 0 0.00 2641 643998 25020 0 0
srv_fill_mon_cache_memory 148 148 0 0.00 1289 172600 36088 0 0
srv_find_qd_qs_mism 1041143 1041143 0 0.00 0 11117 5 0 0
srv_make_invnt_saldo 512 512 0 0.00 47 85436 1247 0 0
srv_make_money_saldo 705 705 0 0.00 1 2336 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 162182 362580 260577 0 0
t$perf-abend:sp_add_invoice_to_stock 143 143 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4769 4769 0 0.00 0 14738 199 0 0
t$perf-norm:sp_cancel_adding_invoice 393 393 0 0.00 0 5380 103 0 0
t$perf-norm:sp_cancel_client_order 1709 1709 0 0.00 0 11865 25 0 0
t$perf-norm:sp_cancel_customer_reserve 634 634 0 0.00 0 16004 44 0 0
t$perf-norm:sp_cancel_pay_from_customer 616 616 0 0.00 0 224 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 425 425 0 0.00 0 12881 35 0 0
t$perf-norm:sp_cancel_supplier_invoice 379 379 0 0.00 0 7472 39 0 0
t$perf-norm:sp_cancel_supplier_order 394 394 0 0.00 0 28214 1679 0 0
t$perf-norm:sp_cancel_write_off 1008 1008 0 0.00 0 6890 14 0 0
t$perf-norm:sp_client_order 19380 19380 0 0.00 0 15045 20 0 0
t$perf-norm:sp_customer_reserve 968 968 0 0.00 0 9933 16 0 0
t$perf-norm:sp_pay_from_customer 6693 6693 0 0.00 0 14299 16 0 0
t$perf-norm:sp_pay_to_supplier 5540 5540 0 0.00 0 4154 13 0 0
t$perf-norm:sp_reserve_write_off 9420 9420 0 0.00 0 7419 13 0 0
t$perf-norm:sp_supplier_invoice 5145 5145 0 0.00 0 11520 26 0 0
t$perf-norm:sp_supplier_order 5092 5092 0 0.00 0 4928 18 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 387 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 148 148 0 0.00 0 313 9 0 0
t$perf-norm:srv_make_invnt_saldo 512 512 0 0.00 0 1272 21 0 0
t$perf-norm:srv_make_money_saldo 705 705 0 0.00 0 4595 25 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 9794 9508 286 2.92 0 11183 19 0 286
v_all_customers 35710 35710 0 0.00 0 16 1 0 0
v_all_suppliers 28326 28326 0 0.00 0 27 1 0 0
v_all_wares 38760 38760 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 786 786 0 0.00 0 7536 28 0 0
v_cancel_client_order 3418 3418 0 0.00 0 5161 11 0 0
v_cancel_customer_prepayment 1232 1232 0 0.00 0 4826 19 0 0
v_cancel_customer_reserve 1268 1268 0 0.00 0 1909 5 0 0
v_cancel_payment_to_supplier 850 850 0 0.00 0 11184 19 0 0
v_cancel_supplier_invoice 768 758 10 1.30 0 2071 23 0 10
v_cancel_supplier_order 788 788 0 0.00 0 1919 10 0 0
v_cancel_write_off 2016 2016 0 0.00 0 3949 18 0 0
v_max_id_clo_ord 5090 5090 0 0.00 0 1073 1 0 0
v_max_id_clo_res 968 968 0 0.00 0 2131 8 0 0
v_max_id_ord_sup 5137 5137 0 0.00 0 6396 7 0 0
v_max_non_paid_invoice 1604 1604 0 0.00 0 1524 4 0 0
v_max_non_paid_realizn 3375 3375 0 0.00 0 7529 6 0 0
v_min_id_clo_ord 5090 5090 0 0.00 0 2116 5 0 0
v_min_id_clo_res 968 968 0 0.00 0 5301 17 0 0
v_min_id_ord_sup 5137 5137 0 0.00 0 7266 10 0 0
v_min_non_paid_invoice 5540 5540 0 0.00 0 7769 14 0 0
v_min_non_paid_realizn 6692 6692 0 0.00 0 7387 21 0 0
v_our_firm 9684 9684 0 0.00 0 12 1 0 0
v_reserve_write_off 18836 18836 0 0.00 0 5219 8 0 0
x_lock_depdocs_on_canc_invoice 11944 11944 0 0.00 0 17842 116 0 0
x_lock_depdocs_on_canc_sup_ord 394 394 0 0.00 0 13467 452 0 0
x_make_qstorno_1000_1200 5092 5092 0 0.00 2 43606 1269 0 0
x_make_qstorno_1200_2000 5145 5145 0 0.00 3 73179 3184 0 0
x_make_qstorno_2100_3300 436711 436711 0 0.00 0 59757 159 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-01-2021 01:29:39 to 28-01-2021 01:29:43.

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
22:57:15 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:21 17712 8192000000 10239617920 10548613120 950412816 10.395 75 54 111 0 970675488 2359648 17903024
22:57:48 35378 8192000000 10358338512 10675699712 1396176704 14.561 100 89 178 0 1429906688 4924928 28805056
22:58:31 22906 8192000000 10383313888 10705997824 1434922144 14.905 100 91 183 0 1471372400 6821392 29628864
22:59:03 28771 8192000000 10402456224 10729267200 1455689776 15.088 100 86 172 1 1491610000 7906208 28014016
22:59:42 23708 8192000000 10429461696 10758529024 1478156560 15.285 100 87 174 1 1514418208 8142000 28119648
23:00:23 17234 8192000000 10456125760 10790555648 1505656720 15.525 100 87 174 1 1542390464 8858848 27874896
23:00:56 20053 8192000000 10483179312 10825408512 1534784112 15.778 100 83 166 0 1570278688 9452496 26042080
23:01:24 16002 8192000000 10489898752 10839343104 1550735984 15.916 100 76 152 0 1583876608 9837504 23303120
23:01:49 16101 8192000000 10525592784 10875719680 1577437360 16.146 100 73 145 2 1609931840 9509808 22984672
23:02:22 16156 8192000000 10546589232 10907484160 1605222272 16.384 100 80 158 1 1639723696 10223664 24277760
23:02:46 12022 8192000000 10575430128 10928762880 1633102576 16.621 100 84 166 3 1668874864 10614208 25158080
23:03:05 17777 8192000000 10596941520 10957860864 1646752640 16.737 100 80 160 1 1682801088 11578480 24469968
23:03:31 9493 8192000000 10613050368 10978643968 1670726928 16.939 100 82 162 4 1706342128 11862976 23752224
23:03:51 11113 8192000000 10635942688 11006087168 1691665104 17.115 100 80 160 2 1727657424 12437680 23554640
23:04:10 9955 8192000000 10656103232 11030286336 1713614864 17.299 100 81 162 0 1749908944 12788576 23505504
23:04:28 8314 8192000000 10677427456 11048349696 1735615232 17.482 100 87 174 1 1774306176 13395856 25295088
23:04:43 6014 8192000000 10681637712 11057102848 1744455488 17.556 100 81 160 0 1780201712 13019792 22726432
23:04:57 4456 8192000000 10686112128 11065319424 1753642960 17.632 100 82 164 1 1790168544 12950112 23575472
23:05:10 4310 8192000000 10704329520 11082092544 1762079056 17.702 100 81 162 1 1797378384 13094160 22205168
23:05:21 4413 8192000000 10722366464 11101188096 1776235504 17.818 100 86 172 2 1814132864 13784256 24113104
23:05:33 2993 8192000000 10727679472 11103145984 1786521712 17.903 100 86 172 2 1825270064 14556016 24192336
23:05:43 2987 8192000000 10726203632 11105828864 1789060080 17.924 100 85 170 3 1827975792 14731200 24184512
23:05:53 2411 8192000000 10735960896 11116220416 1792516448 17.952 100 81 160 2 1829143600 14815616 21811536
23:06:02 5768 8192000000 10735629072 11116015616 1792305376 17.951 100 83 166 1 1830736272 15452592 22978304
23:06:15 5768 8192000000 10745093472 11127365632 1796613472 17.986 100 87 173 0 1835156688 14303616 24239600
23:06:27 2035 8192000000 10749239072 11131633664 1807621792 18.076 100 84 169 1 1845803360 14190448 23991120
23:06:36 1954 8192000000 10760278288 11143630848 1819251920 18.172 100 88 177 0 1857875776 13240352 25383504
23:06:44 2287 8192000000 10766022320 11152547840 1823949296 18.210 100 85 170 0 1860600912 12953056 23698560
23:06:53 1828 8192000000 10775303696 11159683072 1837331808 18.319 100 84 169 0 1874142800 13516480 23294512
23:07:02 2418 8192000000 10788032544 11175030784 1845131296 18.383 100 94 189 1 1884751440 12533360 27086784
23:07:10 1739 8192000000 10788933904 11176189952 1851644000 18.435 100 86 174 2 1887183424 11418016 24121408
23:07:19 1355 8192000000 10801246736 11188547584 1857267072 18.481 100 92 184 1 1901119360 17786320 26065968
23:07:26 2005 8192000000 10805237024 11191599104 1861213440 18.513 100 90 176 1 1898802736 13072656 24516640
23:07:34 1749 8192000000 10817488208 11202998272 1868626368 18.573 100 96 190 0 1908378768 13898000 25854400
23:07:42 1380 8192000000 10815350080 11203956736 1869916272 18.584 100 96 194 1 1910905312 13209968 27779072
23:07:50 1984 8192000000 10817055184 11209293824 1875824320 18.631 100 90 181 1 1914573808 12285280 26464208
23:07:58 6598 8192000000 10789981936 11203420160 1869201184 18.578 100 50 100 2 1894018912 10992576 13825152
23:08:15 23061 8192000000 10817893968 11217154048 1873468912 18.612 100 67 133 1 1900935856 8682832 18784112
23:08:44 11182 8192000000 10792681600 11209297920 1875480336 18.629 100 52 104 1 1899678832 10207968 13990528
23:09:08 9785 8192000000 10769341728 11202469888 1867721296 18.566 100 19 39 0 1879323872 6251200 5351376
23:09:24 5819 8192000000 10798888320 11214712832 1874017680 18.617 100 37 74 2 1891908208 7007072 10883456
23:09:37 5590 8192000000 10796392224 11222319104 1875749072 18.631 100 39 77 2 1903552256 17414784 10388400
23:09:49 6937 8192000000 10789654000 11216719872 1877093312 18.642 100 28 55 3 1891675376 6598272 7983792
23:10:03 6619 8192000000 10793964496 11219009536 1885259824 18.708 100 35 68 3 1901812608 6741104 9811680
23:10:16 7173 8192000000 10798756560 11222024192 1884817936 18.704 100 27 55 0 1899164800 7116144 7230720
23:10:33 16719 8192000000 10792270800 11220434944 1884349184 18.700 100 22 45 1 1897619264 6718736 6551344
23:10:56 4362 8192000000 10798707872 11224014848 1886648768 18.719 100 30 60 1 1901813216 6369440 8795008
23:11:06 6154 8192000000 10798433072 11224117248 1884945104 18.705 100 22 44 1 1896196336 5221152 6030080
23:11:22 7690 8192000000 10798210336 11227430912 1887929600 18.729 100 21 42 0 1900572992 6194560 6448832
23:11:38 10167 8192000000 10803327472 11230957568 1889296096 18.740 100 15 30 1 1903614672 10378544 3940032
23:11:56 7297 8192000000 10796207952 11231084544 1894229904 18.780 100 22 44 2 1906828000 6301056 6297040
23:12:10 10762 8192000000 10809103808 11239129088 1897709344 18.808 100 31 61 3 1913323696 7241120 8373232
23:12:31 61094 8192000000 10817778672 11248197632 1905202240 18.868 100 47 92 2 1926315184 5854160 15258784
23:14:01 1461 8192000000 10869187120 11266867200 1917209504 18.964 100 93 188 3 1953874848 9553600 27111744
23:14:09 4752 8192000000 10831979136 11254484992 1909633312 18.904 100 39 79 0 1930680016 9915296 11131408
23:14:23 8979 8192000000 10836425344 11264155648 1910547904 18.911 100 36 73 1 1931316176 10873424 9894848
23:14:39 5468 8192000000 10826041408 11257454592 1911095888 18.915 100 37 74 3 1929612464 8014768 10501808
23:14:51 2159 8192000000 10837948176 11262169088 1915854800 18.954 100 43 85 2 1935537104 6915440 12766864
23:15:03 4454 8192000000 10816124992 11252051968 1907974400 18.890 100 26 50 1 1920812896 5832304 7006192
23:15:14 4584 8192000000 10826925104 11260047360 1909301344 18.901 100 29 58 0 1924694112 7141280 8251488
23:15:25 4203 8192000000 10825284848 11258081280 1911429280 18.918 100 32 64 0 1926246736 5865296 8952160
23:15:36 6114 8192000000 10846157520 11268509696 1913125744 18.932 100 27 54 0 1932009248 10625184 8258320
23:15:48 7250 8192000000 10815797248 11253710848 1907573552 18.887 100 23 43 4 1919720656 5949376 6197728
23:16:06 5645 8192000000 10830697184 11258273792 1912209280 18.924 100 23 46 1 1929155216 10225616 6720320
23:16:22 28145 8192000000 10804924576 11246018560 1875337024 18.627 98 21 42 0 1887231376 4860160 7034192
23:17:16 13433 8192000000 10849064880 11249643520 1875407840 18.628 98 72 148 0 1902470096 5452016 21610240
23:17:37 8999 8192000000 10793977184 11234004992 1836894048 18.316 97 19 38 1 1853178480 11006864 5277568
23:17:55 6453 8192000000 10789059920 11215343616 1843681472 18.371 98 35 71 0 1860033472 6630544 9721456
23:18:10 7085 8192000000 10785988208 11207434240 1821394016 18.189 97 36 71 3 1839225232 7831008 10000208
23:18:25 4593 8192000000 10767165712 11183554560 1808622928 18.085 97 29 57 1 1824113408 7277200 8213280
23:18:36 7268 8192000000 10763761248 11186708480 1817347344 18.156 98 34 68 2 1833389424 6573248 9468832
23:18:49 6961 8192000000 10744947824 11164446720 1799944480 18.013 98 30 60 5 1814963824 6527504 8491840
23:19:02 6853 8192000000 10740884960 11162120192 1797034256 17.990 98 26 52 0 1811079408 6551824 7493328
23:19:17 7580 8192000000 10713083776 11135279104 1750497008 17.606 96 24 48 0 1763789264 6309152 6983104
23:19:31 7020 8192000000 10722066336 11135033344 1776423536 17.820 98 25 50 1 1789838032 6223200 7191296
23:19:44 5277 8192000000 10700807600 11121913856 1774218912 17.802 98 25 49 2 1787032160 5322576 7490672
23:19:58 6340 8192000000 10688927520 11103313920 1750179488 17.603 97 27 53 2 1762746368 4697392 7869488
23:20:11 5971 8192000000 10694510240 11102928896 1744647056 17.557 98 36 72 1 1761046224 5704864 10694304
23:20:28 6423 8192000000 10700336592 11104280576 1760574688 17.689 98 30 60 2 1775287472 5597248 9115536
23:20:40 13367 8192000000 10708037072 11121344512 1749915728 17.601 97 19 39 0 1760022624 4792704 5314192
23:21:02 58553 8192000000 10689404688 11110727680 1740296640 17.521 97 32 62 1 1755524944 5812864 9415440
23:22:10 9259 8192000000 10711948160 11127283712 1778398016 17.836 99 23 46 1 1791239792 6211856 6629920
23:22:26 8541 8192000000 10727546000 11145027584 1807796800 18.078 100 26 50 2 1820434448 5341760 7295888
23:22:46 4703 8192000000 10739786624 11154976768 1799626784 18.011 99 25 50 0 1817406560 10627904 7151872
23:22:59 5730 8192000000 10740601056 11154223104 1819063728 18.170 100 39 78 2 1838096272 7815728 11216816
23:23:15 6591 8192000000 10740368736 11161927680 1825899824 18.226 100 23 45 2 1838670720 6611856 6159040
23:23:31 7785 8192000000 10742178544 11169120256 1836712320 18.314 100 29 59 0 1851614784 7240480 7661984
23:23:45 8427 8192000000 10761965088 11176587264 1837591616 18.321 100 19 36 1 1848656464 5211504 5853344
23:24:01 6835 8192000000 10749713056 11176050688 1838464512 18.328 100 28 56 1 1853759952 6624272 8671168
23:24:16 10611 8192000000 10761654496 11184369664 1843573616 18.370 100 16 32 0 1854102912 5570064 4959232
23:24:33 10513 8192000000 10755545472 11186241536 1844772912 18.380 100 20 40 0 1856596208 5554384 6268912
23:24:53 5445 8192000000 10779724928 11191595008 1851458368 18.434 100 19 38 0 1862868880 6145104 5265408
23:25:06 8945 8192000000 10760044048 11193483264 1858409456 18.490 100 24 48 0 1871418288 5960016 7048816
23:25:22 16140 8192000000 10774908736 11202551808 1864152160 18.537 100 19 39 3 1875724720 5617872 5954688
23:25:44 69667 8192000000 10789161744 11213914112 1870934912 18.592 100 39 78 2 1889090560 6735072 11420576
23:27:02 6045 8192000000 10793293808 11224125440 1879474080 18.661 100 23 46 2 1891943552 5417584 7051888
23:27:18 14284 8192000000 10815751648 11244687360 1897541424 18.807 100 30 60 0 1912660480 6362544 8756512
23:27:59 39355 8192000000 10838787456 11268820992 1913021776 18.931 100 39 77 1 1931547408 7711376 10814256
23:28:53 30399 8192000000 10855864304 11282157568 1924638656 19.024 100 48 95 2 1952019584 13678096 13702832
23:29:32 18005 8192000000 10864028784 11290431488 1932203280 19.084 100 50 98 2 1959323824 13604208 13516336
23:30:07 16050 8192000000 10875614736 11301933056 1938817552 19.137 100 45 90 2 1965865248 13728672 13319024
23:30:30 19445 8192000000 10872955008 11310673920 1944729424 19.184 100 39 76 1 1969987504 13930464 11327616
23:30:58 21143 8192000000 10898689904 11331346432 1958455856 19.294 100 33 67 0 1984380272 15430896 10493520
23:31:30 14810 8192000000 10903754848 11337850880 1971793376 19.400 100 40 80 0 2000606272 17188384 11624512
23:31:52 5285 8192000000 10904289024 11341787136 1971828864 19.400 100 35 69 2 1998798432 16702432 10267136
23:32:07 27215 8192000000 10935130144 11359850496 1982974256 19.488 100 57 114 0 2023310032 23518864 16816912
23:32:49 16813 8192000000 10930475344 11362549760 1988527984 19.532 100 46 92 0 2023219648 21842192 12849472
23:33:17 15933 8192000000 10940499488 11368763392 1991841184 19.558 100 50 100 1 2029029152 22669424 14518544
23:33:46 13673 8192000000 10945159232 11378028544 1997604400 19.604 100 55 108 0 2036940720 23360112 15976208
23:34:20 23825 8192000000 10946064688 11383406592 1998529680 19.611 100 42 84 0 2034023760 23370032 12124048
23:34:59 14060 8192000000 10957836608 11387801600 2002280992 19.641 100 52 104 0 2041744272 24156368 15306912
23:35:44 8414 8192000000 10954852368 11394015232 2010084208 19.702 100 49 96 0 2050592592 25962960 14545424
23:35:59 14381 8192000000 10958780880 11394068480 2009467920 19.697 100 48 96 1 2049530272 25412976 14649376
23:36:26 12584 8192000000 10976717712 11406090240 2015335248 19.743 100 56 112 2 2060161136 27748208 17077680
23:36:46 6821 8192000000 10973844080 11403345920 2019390080 19.775 100 60 120 5 2064756256 27809744 17556432
23:37:01 4398 8192000000 10986369232 11413725184 2021184544 19.789 100 61 118 2 2069662784 30125600 18352640
23:37:14 6445 8192000000 10980985440 11415277568 2023320224 19.806 100 72 143 1 2076056336 31511600 21224512
23:37:33 11556 8192000000 10983135056 11414757376 2026019856 19.827 100 63 124 1 2073843072 28838560 18984656
23:37:52 5439 8192000000 10991974592 11423412224 2032181696 19.876 100 70 138 0 2083753552 30787600 20784256
23:38:05 2989 8192000000 10985925552 11425058816 2029505216 19.855 100 60 119 1 2079559648 31363584 18690848
23:38:20 6721 8192000000 10991358672 11426660352 2032448784 19.878 100 63 126 2 2080185472 28680880 19055808
23:38:33 3973 8192000000 11009771088 11437096960 2042116240 19.954 100 78 155 2 2095925504 30589984 23219280
23:38:47 3524 8192000000 11011556448 11438440448 2043307968 19.963 100 77 150 2 2098394512 32169056 22917488
23:38:59 7250 8192000000 10991744816 11417956352 2019163296 19.774 99 70 139 1 2071728176 31687760 20877120
23:39:16 4417 8192000000 11004605040 11432804352 2034719440 19.896 100 73 145 1 2089566880 33020240 21827200
23:39:31 10553 8192000000 11005022768 11437441024 2035582144 19.902 100 69 135 3 2089657664 33336496 20739024
23:39:54 2492 8192000000 11011544688 11443249152 2039821200 19.936 100 71 139 0 2094234816 33221840 21191776
23:40:04 1289 8192000000 10996040400 11418562560 2022468352 19.800 99 80 160 1 2080887616 34860992 23558272
23:40:12 12907 8192000000 10990029488 11419054080 2017243488 19.758 99 71 142 0 2074300368 35631168 21425712
23:40:34 5697 8192000000 11000319888 11433115648 2026538448 19.831 100 68 136 0 2087565200 39257632 21769120
23:40:49 4296 8192000000 11002900688 11432116224 2024844016 19.818 100 66 131 0 2086007264 41058400 20104848
23:41:03 4769 8192000000 11014364336 11436556288 2013988704 19.733 99 76 150 2 2078978720 41847616 23142400
23:41:15 2885 8192000000 11014936912 11442671616 2024926064 19.819 100 72 142 1 2093246096 45563552 22756480
23:41:27 6470 8192000000 11012873056 11441229824 2025888352 19.826 100 71 142 0 2094881648 46469504 22523792
23:41:41 1331 8192000000 11000401744 11418779648 2012664048 19.722 99 86 172 5 2086273920 47771504 25838368
23:41:50 2347 8192000000 11024999952 11446079488 2031417952 19.870 100 77 153 1 2101279200 46109200 23752048
23:42:00 3362 8192000000 11028008064 11450527744 2040887888 19.944 100 87 173 1 2111362080 43763456 26710736
23:42:10 3380 8192000000 11031140128 11448836096 2039374176 19.932 100 84 167 2 2109796176 44337328 26084672
23:42:20 2887 8192000000 11031392208 11454849024 2048094912 20.000 100 91 179 0 2118850992 43953136 26802944
23:42:31 2958 8192000000 11029788944 11452203008 2042484848 19.956 100 88 175 3 2112056112 44126080 25445184
23:42:40 2777 8192000000 11018719168 11440304128 2019015568 19.772 99 91 180 4 2090138192 43259456 27863168
23:42:50 7042 8192000000 11019239040 11446685696 2033985008 19.890 100 76 150 1 2100290960 42935296 23370656
23:43:04 3497 8192000000 11014249824 11438256128 2024889776 19.819 100 82 164 0 2095108768 43839264 26379728
23:43:15 10564 8192000000 11002868016 11436900352 2021064848 19.789 100 68 136 1 2089726528 47264160 21397520
23:43:35 4319 8192000000 11005905120 11434790912 2017874528 19.763 100 69 137 2 2088742496 49403680 21464288
23:43:49 4893 8192000000 10979029696 11405111296 1969950656 19.385 98 69 137 0 2042441792 50878496 21612640
23:44:02 4059 8192000000 11013017008 11434139648 2013444240 19.729 100 80 161 2 2091911904 53089552 25378112
23:44:18 7174 8192000000 11017121712 11449909248 2021032336 19.788 100 64 128 1 2100855952 59347904 20475712
23:44:33 4408 8192000000 11035656512 11458945024 2028409888 19.846 100 71 141 1 2111259072 60280912 22568272
23:44:44 2991 8192000000 11017925632 11446448128 2006740960 19.676 99 75 150 1 2092548224 62281888 23525376
23:44:57 4725 8192000000 11021840976 11446710272 2018190352 19.766 100 80 159 1 2106609600 63108112 25311136
23:45:08 3861 8192000000 11045257584 11465592832 2029202272 19.852 100 84 168 3 2121618480 65195552 27220656
23:45:20 3770 8192000000 11037908352 11458093056 2027345024 19.838 100 83 166 1 2118343296 65028784 25969488
23:45:38 2490 8192000000 11032875664 11459473408 2027761568 19.841 100 68 137 0 2117246176 67737568 21747040
23:45:47 1655 8192000000 11031978656 11451314176 2017549776 19.761 100 86 171 0 2114095792 68431312 28114704
23:45:55 2261 8192000000 11037879760 11456884736 2024945472 19.819 100 92 184 1 2118083968 64272256 28866240
23:46:06 3377 8192000000 11037529280 11448930304 2006784752 19.676 99 85 171 1 2100116496 66907168 26424576
23:46:16 1848 8192000000 11025579152 11456282624 2019716304 19.778 100 71 142 2 2111086128 68302752 23067072
23:46:26 3369 8192000000 11006206800 11437506560 1997615952 19.604 99 67 134 0 2087944400 68078720 22249728
23:46:38 7486 8192000000 11008316080 11452575744 2016179712 19.750 100 56 110 3 2107218448 72391440 18647296
23:46:59 18582 8192000000 10970208704 11417944064 1966605872 19.359 98 49 97 0 2031196160 47611632 16978656
23:47:29 4974 8192000000 10972728464 11417636864 1983444192 19.492 100 40 79 1 2054723936 57453904 13825840
23:47:47 13746 8192000000 10961854608 11417202688 1988779872 19.534 100 40 80 5 2055886640 53284304 13822464
23:48:18 14356 8192000000 10955289408 11405893632 1983179888 19.490 100 25 50 0 2031375872 40033232 8162752
23:48:50 24254 8192000000 10947896112 11397173248 1965675248 19.351 99 29 58 0 2018804608 43337136 9792224
23:49:27 23800 8192000000 10948064528 11404312576 1978724656 19.455 100 29 58 0 2034123920 45872960 9526304
23:50:15 15843 8192000000 10951004496 11398148096 1962465216 19.326 99 30 60 2 2020649264 47861424 10322624
23:50:44 3841 8192000000 10983371120 11413897216 1992733344 19.565 100 66 132 1 2066669104 52453120 21482640
23:50:54 12418 8192000000 10957332032 11409031168 1964058448 19.338 99 38 76 0 2033181024 56131472 12991104
23:51:17 15780 8192000000 10934292368 11395313664 1934126368 19.100 98 30 60 1 2007833472 61827616 11879488
23:51:51 31709 8192000000 10922297472 11388997632 1949993872 19.226 100 15 30 0 2005591536 49952080 5645584
23:52:41 31741 8192000000 10916897072 11369746432 1893357248 18.773 97 19 39 1 1959438912 59285552 6796112
23:53:23 81923 8192000000 10843018368 11300024320 1762833200 17.708 91 18 36 1 1809674208 41431056 5409952
23:54:54 16826 8192000000 10831473296 11290931200 1869814624 18.583 99 11 22 2 1904454816 31158992 3481200
23:55:49 54801 8192000000 10849157024 11283755008 1890340640 18.749 99 40 80 1 1922830960 19507504 12982816
23:56:59 86604 8192000000 10834597760 11300790272 1841695584 18.355 96 23 45 1 1865317904 16738544 6883776
23:58:33 94377 8192000000 10859564384 11318689792 1912701824 18.928 99 15 30 0 1929056800 11333744 5021232
00:01:00 93630 8192000000 10842130848 11299041280 1836690112 18.314 95 26 50 1 1850010944 6568432 6752400
00:02:40 69786 8192000000 10824252640 11272699904 1843133664 18.366 96 14 28 0 1859217104 12153776 3929664
00:03:58 172572 8192000000 10844015168 11319173120 1897699840 18.808 99 24 45 2 1923616016 19341008 6575168
00:06:57 68931 8192000000 10861298864 11310084096 1873747296 18.615 97 21 42 0 1889979232 10548128 5683808
00:08:18 85734 8192000000 10842043344 11298353152 1843576800 18.370 95 34 68 0 1868426032 14966704 9882528
00:10:09 15803 8192000000 10848216592 11294285824 1913839216 18.937 100 27 55 0 1934684128 12543056 8301856
00:10:31 23367 8192000000 10833929680 11285118976 1900864608 18.833 99 22 43 1 1920759248 13205680 6688960
00:11:08 42011 8192000000 10867166800 11317764096 1933965536 19.099 100 18 35 1 1949901072 10695808 5239728
00:12:02 49138 8192000000 10889513760 11338862592 1945681280 19.192 100 33 65 0 1966173328 11110512 9381536
00:13:00 54753 8192000000 10856354256 11335266304 1937523616 19.127 100 13 26 0 1951080016 9753504 3802896
00:14:17 34776 8192000000 10867085008 11340034048 1947943056 19.210 100 7 14 2 1960664336 10825280 1896000
00:15:01 34734 8192000000 10874358720 11348201472 1954790128 19.265 100 12 22 3 1972212960 13535856 3886976
00:15:42 66852 8192000000 10883869072 11357188096 1959339504 19.301 100 11 22 1 1974378352 11929824 3109024
00:17:20 60148 8192000000 10890025936 11363016704 1966723568 19.359 100 20 40 0 1984119792 11972496 5423728
00:18:47 53816 8192000000 10887353872 11348172800 1963918720 19.337 100 15 31 0 1974877648 6700272 4258656
00:19:50 50442 8192000000 10882328320 11354071040 1965266688 19.348 100 16 32 2 1977827952 7418544 5142720
00:22:11 69407 8192000000 10884276944 11369390080 1970478080 19.389 100 15 30 1 1982362432 7675856 4208496
00:23:32 42634 8192000000 10903421984 11370283008 1959129152 19.299 99 25 50 1 1974670896 8414912 7126832
00:24:21 87396 8192000000 10915442192 11386826752 1984210240 19.498 100 18 36 2 2002461568 12693616 5557712
00:25:54 44175 8192000000 10922793168 11396947968 1995115744 19.584 100 24 48 0 2016531744 14312304 7103696
00:26:45 72635 8192000000 10906152160 11386707968 1969894464 19.385 99 16 32 0 1989771424 15221792 4655168
00:28:08 54984 8192000000 10908913072 11391787008 1952792192 19.249 98 17 34 1 1970958272 13674432 4491648
00:29:20 64745 8192000000 10898094208 11379175424 1943098336 19.171 98 6 12 1 1961916736 17097392 1721008
00:30:31 73962 8192000000 10902080560 11375763456 1942280832 19.165 98 14 28 0 1964301136 17539792 4480512
00:31:51 54444 8192000000 10908573536 11364487168 1913166544 18.932 96 33 65 1 1933408752 10634800 9607408
00:32:58 55959 8192000000 10917198368 11372511232 1938996944 19.139 98 26 52 0 1959183456 12665440 7521072
00:34:00 70686 8192000000 10889775728 11343929344 1882867696 18.688 95 17 34 1 1900719984 12852384 4999904
00:35:17 131184 8192000000 10911191696 11382894592 1951329280 19.237 99 7 14 0 1966036432 12934592 1772560
00:37:36 90000 8192000000 10904693216 11366928384 1946541824 19.199 98 19 38 1 1960902000 8123264 6236912
00:39:22 63714 8192000000 10886982368 11346038784 1923488448 19.015 97 35 69 2 1946093392 12156128 10448816
00:40:34 25908 8192000000 10912337280 11364753408 1970815584 19.392 100 50 100 2 1995632992 10651120 14166288
00:41:33 30112 8192000000 10854259456 11336159232 1906848800 18.881 97 32 64 0 1929093472 13172304 9072368
00:42:33 68199 8192000000 10868877232 11347906560 1917813296 18.969 98 7 14 0 1933306576 13443424 2049856
00:43:51 22583 8192000000 10884538576 11356463104 1948556960 19.215 100 12 24 3 1967236208 15154880 3524368
00:44:20 33281 8192000000 10867818672 11348373504 1898627824 18.815 97 9 18 1 1915912160 14886528 2397808
00:45:00 110893 8192000000 10847659712 11322507264 1835982816 18.308 94 17 34 0 1854100544 13348512 4769216
00:47:41 55284 8192000000 10851159200 11316838400 1848336768 18.409 95 16 32 0 1862655248 9818960 4499520
00:48:49 57939 8192000000 10887443008 11327836160 1906294816 18.877 98 35 70 1 1934135920 18347744 9493360
00:49:55 13318 8192000000 10864600496 11314708480 1921463440 18.999 100 33 64 1 1939063504 8712544 8887520
00:50:15 39172 8192000000 10848078080 11299401728 1858513360 18.491 96 44 88 0 1883225392 12333392 12378640
00:51:01 55381 8192000000 10821331200 11286568960 1858194944 18.489 97 23 46 1 1878353584 13058848 7099792
00:52:02 76619 8192000000 10864918192 11328262144 1910251760 18.909 99 19 38 0 1934714160 18916336 5546064
00:53:37 113834 8192000000 10841344432 11299557376 1817410800 18.157 94 12 24 0 1833015392 12354000 3250592
00:55:37 35433 8192000000 10819816288 11263238144 1815242832 18.139 95 39 78 2 1839388560 13174224 10971504
00:56:30 41470 8192000000 10838863888 11273658368 1828010672 18.243 96 33 66 0 1852071632 15407728 8653232
00:57:18 60158 8192000000 10858569168 11289042944 1872094752 18.601 98 39 78 0 1896951824 14297392 10559680
00:58:25 55949 8192000000 10845468512 11310891008 1896788368 18.800 99 38 76 0 1916315152 9738512 9788272
00:59:30 147467 8192000000 10845581664 11303727104 1909854256 18.905 99 12 24 0 1928029744 14844400 3331088
01:02:04 35976 8192000000 10838692240 11296878592 1893404640 18.773 98 24 48 2 1906390160 6973600 6011920
01:02:52 71553 8192000000 10848671360 11314610176 1896269792 18.796 98 12 23 2 1911631680 12461072 2900816
01:04:13 32719 8192000000 10869847408 11330265088 1940174800 19.148 100 11 22 1 1956039088 12888016 2976272
01:06:06 101140 8192000000 10871550288 11339538432 1936045600 19.115 99 13 26 0 1953401728 13458816 3897312
01:07:54 80049 8192000000 10881703280 11355959296 1960617600 19.311 100 15 28 0 1978508976 13327168 4564208
01:09:20 41720 8192000000 10875057056 11334868992 1949472512 19.222 99 36 71 0 1968938208 9057712 10407984
01:10:11 75569 8192000000 10924569424 11375669248 1950627488 19.231 99 18 33 0 1966775296 11792160 4355648
01:11:35 28502 8192000000 10915499904 11378741248 1987239696 19.522 100 53 105 1 2015710080 13972992 14497392
01:12:10 94725 8192000000 10897863504 11375198208 1927068048 19.043 97 15 30 2 1943206848 11985776 4153024
01:13:56 96759 8192000000 10913786992 11389358080 1957793008 19.288 99 13 26 0 1977328864 16420544 3115312
01:15:43 81325 8192000000 10901251424 11383656448 1921624544 19.000 97 22 44 0 1940266304 12409632 6232128
01:17:11 79551 8192000000 10899819760 11374891008 1961830064 19.321 99 16 32 2 1979616208 12842176 4943968
01:18:40 48756 8192000000 10918039184 11387613184 1946322448 19.197 98 24 48 1 1967301392 13719520 7259424
01:19:35 120899 8192000000 10914090720 11389353984 1959653936 19.303 99 6 12 0 1976105456 15167216 1284304
01:21:48 62196 8192000000 10933775584 11409149952 2000226768 19.625 100 29 57 0 2023678352 15214032 8237552
01:23:30 71520 8192000000 10884388480 11361763328 1959983984 19.306 98 25 50 2 1977202880 9917888 7301008
01:24:49 60730 8192000000 10893611248 11371057152 1918653376 18.976 97 7 14 0 1928141872 7881520 1606976
01:25:56 40785 8192000000 10878169904 11359322112 1936411264 19.118 98 8 16 1 1946103328 6865968 2826096
01:26:44 31734 8192000000 9837762512 10196975616 972906000 10.615 50 4 8 0 980034160 6019408 1108752

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 28-01-2021 01:29:45 to 28-01-2021 01:30:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 143 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-01-2021 01:30:16 to 28-01-2021 01:30:18.

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

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