Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.03.2021 22:27
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 df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
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.26
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 17547852 kB
MemAvailable 31568888 kB
Buffers 0 kB
Cached 14111388 kB
SwapCached 0 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-03-12 22:27:22
DTS_END                         2021-03-12 22:27:22.3480
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46458
TRN_ID                          233350
ATT_ID                          616
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: 8955.19 21783 1074623
customer order: creation 166.78 352 20013
customer order: refuse 14.56 326 1747
order to supplier: creation 44.45 1315 5334
order to supplier: removal 3.54 103416 425
invoice (draft): creation 43.67 3715 5240
invoice (draft): removal 51.64 913 6197
invoice accept: apply 39.97 17928 4796
invoice accept: cancel 46.48 792 5577
customer reserve: creation 3695.97 176 443516
customer reserve: removal 4565.23 61 547828
realization accept: apply 81.09 204 9731
realization accept: cancel 76.13 129 9136
payment from customer: creation 57.66 130 6919
payment from customer: removal 5.47 90 656
payment to supplier: creation 47.50 146 5700
payment to supplier: removal 3.10 93 372
service: total inventory turnovers 4.83 1036 579
service: total monetary turnovers 6.39 33 767
service: aggregate perf. data 0.72 24493 86
service: refresh index statistics 0.03 280315 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-03-2021 22:28:16 to 12-03-2021 22:28:18.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3722
TEST_TIME 2 3863
TEST_TIME 3 4263
TEST_TIME 4 4067
TEST_TIME 5 3961
TEST_TIME 6 4103
TEST_TIME 7 4314
TEST_TIME 8 4243
TEST_TIME 9 4311
TEST_TIME 10 4547
TEST_TIME 11 4812
TEST_TIME 12 5366
TEST_TIME 13 5507
TEST_TIME 14 6255
TEST_TIME 15 6498
TEST_TIME 16 6878
TEST_TIME 17 7174
TEST_TIME 18 7507
TEST_TIME 19 7860
TEST_TIME 20 7823
TEST_TIME 21 7972
TEST_TIME 22 8474
TEST_TIME 23 9471
TEST_TIME 24 9472
TEST_TIME 25 9442
TEST_TIME 26 9510
TEST_TIME 27 10472
TEST_TIME 28 10327
TEST_TIME 29 10203
TEST_TIME 30 10517
TEST_TIME 31 10637
TEST_TIME 32 10445
TEST_TIME 33 10275
TEST_TIME 34 10354
TEST_TIME 35 10156
TEST_TIME 36 10032
TEST_TIME 37 10022
TEST_TIME 38 10105
TEST_TIME 39 10045
TEST_TIME 40 9915
TEST_TIME 41 9815
TEST_TIME 42 9682
TEST_TIME 43 9860
TEST_TIME 44 9742
TEST_TIME 45 9645
TEST_TIME 46 9504
TEST_TIME 47 9405
TEST_TIME 48 9290
TEST_TIME 49 9196
TEST_TIME 50 9135
TEST_TIME 51 9127
TEST_TIME 52 9139
TEST_TIME 53 9122
TEST_TIME 54 9045
TEST_TIME 55 8996
TEST_TIME 56 8991
TEST_TIME 57 8900
TEST_TIME 58 8891
TEST_TIME 59 8999
TEST_TIME 60 9079
TEST_TIME 61 9106
TEST_TIME 62 9077
TEST_TIME 63 9098
TEST_TIME 64 9040
TEST_TIME 65 9218
TEST_TIME 66 9177
TEST_TIME 67 9234
TEST_TIME 68 9217
TEST_TIME 69 9339
TEST_TIME 70 9327
TEST_TIME 71 9326
TEST_TIME 72 9286
TEST_TIME 73 9394
TEST_TIME 74 9362
TEST_TIME 75 9330
TEST_TIME 76 9221
TEST_TIME 77 9193
TEST_TIME 78 9191
TEST_TIME 79 9150
TEST_TIME 80 9113
TEST_TIME 81 9118
TEST_TIME 82 9077
TEST_TIME 83 9061
TEST_TIME 84 9013
TEST_TIME 85 8962
TEST_TIME 86 9000
TEST_TIME 87 8984
TEST_TIME 88 8938
TEST_TIME 89 8908
TEST_TIME 90 8936
TEST_TIME 91 8936
TEST_TIME 92 8926
TEST_TIME 93 8950
TEST_TIME 94 8984
TEST_TIME 95 8979
TEST_TIME 96 9010
TEST_TIME 97 9021
TEST_TIME 98 9074
TEST_TIME 99 9023
TEST_TIME 100 9090
TEST_TIME 101 9072
TEST_TIME 102 9057
TEST_TIME 103 9221
TEST_TIME 104 9236
TEST_TIME 105 9158
TEST_TIME 106 9113
TEST_TIME 107 9077
TEST_TIME 108 9056
TEST_TIME 109 9036
TEST_TIME 110 9009
TEST_TIME 111 8983
TEST_TIME 112 8963
TEST_TIME 113 8978
TEST_TIME 114 9011
TEST_TIME 115 9020
TEST_TIME 116 8990
TEST_TIME 117 9015
TEST_TIME 118 9018
TEST_TIME 119 9007
TEST_TIME 120 8960

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-03-2021 22:28:20 to 12-03-2021 22:28:23.

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 1485968 1485968 0 0.00 0 18212 7 0 0
doc_list_biud 1485968 1485968 0 0.00 0 63240 29 0 0
sp_add_invoice_to_stock 4950 4796 154 3.11 37 206813 17928 0 154
sp_cancel_adding_invoice 5577 5577 0 0.00 6 64783 793 0 0
sp_cancel_client_order 1747 1747 0 0.00 3 9957 326 0 0
sp_cancel_customer_reserve 547828 547828 0 0.00 1 63242 61 0 0
sp_cancel_pay_from_customer 656 656 0 0.00 3 18220 90 0 0
sp_cancel_pay_to_supplier 372 372 0 0.00 2 11006 93 0 0
sp_cancel_supplier_invoice 6208 6197 11 0.17 2 20033 913 0 11
sp_cancel_supplier_order 425 425 0 0.00 5 997072 103417 0 0
sp_cancel_write_off 9136 9136 0 0.00 1 45176 130 0 0
sp_client_order 20013 20013 0 0.00 4 30020 352 0 0
sp_customer_reserve 443516 443516 0 0.00 0 45571 177 0 0
sp_fill_shopping_cart 30587 30587 0 0.00 1 27393 45 0 0
sp_fill_shopping_cart_clo_res 443511 443511 0 0.00 0 12555 13 0 0
sp_get_clo_for_invoice 4790 4790 0 0.00 0 26876 327 0 0
sp_kill_cost_storno 15741 15741 0 0.00 0 18210 65 0 0
sp_kill_qstorno_ret_qs2qd 1111414 1111414 0 0.00 0 63238 34 0 0
sp_kill_qty_storno 585431 585431 0 0.00 0 63240 73 0 0
sp_lock_selected_doc 20169 20169 0 0.00 0 9547 5 0 0
sp_make_cost_storno 27140 27140 0 0.00 0 16776 57 0 0
sp_multiply_rows_for_pdistr 27140 27140 0 0.00 0 16736 31 0 0
sp_multiply_rows_for_qdistr 20013 20013 0 0.00 0 10333 139 0 0
sp_pay_from_customer 6919 6919 0 0.00 4 18218 131 0 0
sp_pay_to_supplier 5700 5700 0 0.00 4 28938 147 0 0
sp_payment_common 12619 12619 0 0.00 1 28839 44 0 0
sp_qd_handle_on_cancel_clo 1747 1747 0 0.00 0 9785 302 0 0
sp_qd_handle_on_invoice_upd_sts 10367 10367 0 0.00 0 25877 373 0 0
sp_qd_handle_on_reserve_upd_sts 9731 9731 0 0.00 0 17848 82 0 0
sp_reserve_write_off 9731 9731 0 0.00 5 18070 205 0 0
sp_supplier_invoice 5240 5240 0 0.00 5 90889 3715 0 0
sp_supplier_order 5334 5334 0 0.00 5 27020 1315 0 0
srv_aggregate_perf_data 86 86 0 0.00 2281 309538 24493 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1182 214784 33550 0 0
srv_find_qd_qs_mism 1028878 1028878 0 0.00 0 10761 6 0 0
srv_make_invnt_saldo 579 579 0 0.00 28 28547 1036 0 0
srv_make_money_saldo 767 767 0 0.00 0 8154 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 135087 675504 280315 0 0
t$perf-abend:sp_add_invoice_to_stock 154 154 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 4796 4796 0 0.00 0 13653 157 0 0
t$perf-norm:sp_cancel_adding_invoice 391 391 0 0.00 0 5431 112 0 0
t$perf-norm:sp_cancel_client_order 1747 1747 0 0.00 0 1238 11 0 0
t$perf-norm:sp_cancel_customer_reserve 706 706 0 0.00 0 1924 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 656 656 0 0.00 0 2577 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 372 372 0 0.00 0 797 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 398 398 0 0.00 0 969 11 0 0
t$perf-norm:sp_cancel_supplier_order 425 425 0 0.00 0 24359 1608 0 0
t$perf-norm:sp_cancel_write_off 953 953 0 0.00 0 2259 8 0 0
t$perf-norm:sp_client_order 20013 20013 0 0.00 0 12030 19 0 0
t$perf-norm:sp_customer_reserve 925 925 0 0.00 0 1001 6 0 0
t$perf-norm:sp_pay_from_customer 6919 6919 0 0.00 0 3744 8 0 0
t$perf-norm:sp_pay_to_supplier 5700 5700 0 0.00 0 3551 8 0 0
t$perf-norm:sp_reserve_write_off 9731 9731 0 0.00 0 13580 9 0 0
t$perf-norm:sp_supplier_invoice 5240 5240 0 0.00 0 5657 17 0 0
t$perf-norm:sp_supplier_order 5334 5334 0 0.00 0 6728 16 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 96 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 154 3 0 0
t$perf-norm:srv_make_invnt_saldo 579 579 0 0.00 0 792 18 0 0
t$perf-norm:srv_make_money_saldo 767 767 0 0.00 0 1284 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 4 0 0
v_add_invoice_to_stock 9888 9580 308 3.11 0 7611 16 0 308
v_all_customers 36798 36798 0 0.00 0 14 1 0 0
v_all_suppliers 29560 29560 0 0.00 0 24 1 0 0
v_all_wares 40026 40026 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 782 782 0 0.00 0 2140 10 0 0
v_cancel_client_order 3494 3494 0 0.00 0 2051 4 0 0
v_cancel_customer_prepayment 1312 1312 0 0.00 0 2125 5 0 0
v_cancel_customer_reserve 1412 1412 0 0.00 0 839 3 0 0
v_cancel_payment_to_supplier 744 744 0 0.00 0 4947 10 0 0
v_cancel_supplier_invoice 818 796 22 2.68 0 2042 16 0 22
v_cancel_supplier_order 850 850 0 0.00 0 1052 6 0 0
v_cancel_write_off 1906 1906 0 0.00 0 2699 14 0 0
v_max_id_clo_ord 5334 5334 0 0.00 0 431 1 0 0
v_max_id_clo_res 925 925 0 0.00 0 3487 13 0 0
v_max_id_ord_sup 5240 5240 0 0.00 0 6140 4 0 0
v_max_non_paid_invoice 1494 1494 0 0.00 0 13870 12 0 0
v_max_non_paid_realizn 3515 3515 0 0.00 0 6518 5 0 0
v_min_id_clo_ord 5334 5334 0 0.00 0 5317 8 0 0
v_min_id_clo_res 925 925 0 0.00 0 7161 17 0 0
v_min_id_ord_sup 5240 5240 0 0.00 0 11978 15 0 0
v_min_non_paid_invoice 5700 5700 0 0.00 0 28836 33 0 0
v_min_non_paid_realizn 6919 6919 0 0.00 0 16307 31 0 0
v_our_firm 10036 10036 0 0.00 0 13 1 0 0
v_reserve_write_off 19462 19462 0 0.00 0 3715 4 0 0
x_lock_depdocs_on_canc_invoice 11376 11376 0 0.00 0 19748 120 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 9602 396 0 0
x_make_qstorno_1000_1200 5334 5334 0 0.00 1 26856 1229 0 0
x_make_qstorno_1200_2000 5240 5240 0 0.00 3 89632 3543 0 0
x_make_qstorno_2100_3300 443516 443516 0 0.00 0 45461 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-03-2021 22:28:24 to 12-03-2021 22:28:28.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:25 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:32 28299 8192000000 10287050640 10600603648 963899696 10.527 72 51 102 0 983341680 2954768 16487216
19:58:07 47377 8192000000 10381713872 10701832192 1414290064 14.722 100 82 164 0 1446210608 5656592 26263952
19:59:03 24383 8192000000 10396734176 10720452608 1449111264 15.030 100 89 179 0 1489447104 11368368 28967472
19:59:37 31394 8192000000 10416220944 10741985280 1466983248 15.187 100 89 178 0 1503067088 7596224 28487616
20:00:19 28635 8192000000 10430932304 10761326592 1484484928 15.341 100 90 180 0 1521357296 8515168 28357200
20:00:57 18079 8192000000 10442438384 10777763840 1499353360 15.471 100 91 182 0 1537235520 9135840 28746320
20:01:30 19557 8192000000 10480115968 10817101824 1525186128 15.695 100 84 168 0 1560915696 9468832 26260736
20:02:01 12111 8192000000 10483748000 10829082624 1542846720 15.848 100 78 155 2 1576866208 9557344 24462144
20:02:23 15634 8192000000 10511405376 10857299968 1562881600 16.021 100 79 158 1 1596583440 9534896 24166944
20:02:47 12701 8192000000 10529136768 10880299008 1586142976 16.221 100 81 163 0 1621159136 10074112 24942048
20:03:10 14480 8192000000 10558377040 10914881536 1614126528 16.460 100 82 164 0 1649030432 10639888 24264016
20:03:32 10346 8192000000 10579459040 10937430016 1640345104 16.683 100 78 156 0 1674558480 11210384 23002992
20:03:49 8668 8192000000 10601594096 10964295680 1649898928 16.764 100 74 145 1 1682447456 10532160 22016368
20:04:07 9666 8192000000 10607296000 10977599488 1677901936 17.000 100 75 149 0 1710414832 10606864 21906032
20:04:23 10438 8192000000 10644207008 11011268608 1697001568 17.160 100 78 156 0 1731457216 11821120 22634528
20:04:41 7647 8192000000 10656349008 11031195648 1715097984 17.311 100 80 160 1 1750258384 11912688 23247712
20:04:57 6831 8192000000 10669781680 11045597184 1729610128 17.432 100 78 155 3 1764470176 12560480 22299568
20:05:11 8308 8192000000 10682140816 11061649408 1743468992 17.547 100 76 151 1 1777816064 12616976 21730096
20:05:26 6118 8192000000 10701329360 11077754880 1756637040 17.657 100 82 165 1 1793738800 13319296 23782464
20:05:40 5282 8192000000 10717316912 11097309184 1774202352 17.802 100 84 168 0 1812141056 13907616 24031088
20:05:52 5228 8192000000 10718240224 11099332608 1778941120 17.841 100 85 171 1 1817009456 14040192 24028144
20:06:05 3446 8192000000 10731656608 11110731776 1787293840 17.910 100 91 179 1 1827306448 15201216 24811392
20:06:15 3780 8192000000 10726974768 11106115584 1789591312 17.928 100 90 180 1 1831005024 16584880 24828832
20:06:26 4449 8192000000 10742209024 11122921472 1795037312 17.973 100 93 182 4 1835803664 14049632 26716720
20:06:38 3241 8192000000 10736794368 11124199424 1801904288 18.030 100 79 156 1 1837043536 13333136 21806112
20:06:48 1879 8192000000 10750936272 11131944960 1805759744 18.061 100 94 187 0 1846674224 13943008 26971472
20:06:57 3606 8192000000 10753004464 11137540096 1812906352 18.120 100 91 180 3 1851763088 13399232 25457504
20:07:11 6412 8192000000 10747543456 11137384448 1812768928 18.119 100 77 155 1 1847090880 12509456 21812496
20:07:23 2455 8192000000 10774489936 11158511616 1834688176 18.298 100 87 174 1 1872948880 12987168 25273536
20:07:32 2953 8192000000 10776233728 11165753344 1839296768 18.335 100 84 168 1 1875676224 12956192 23423264
20:07:42 2328 8192000000 10785089328 11170988032 1843997568 18.373 100 87 174 0 1883094304 14071360 25025376
20:07:50 2546 8192000000 10790243072 11176013824 1843708560 18.371 100 89 178 1 1883118208 14808112 24601536
20:07:59 2139 8192000000 10797507712 11183648768 1854617648 18.460 100 91 181 0 1894121984 13907712 25596624
20:08:08 2126 8192000000 10794990512 11184717824 1855482080 18.467 100 84 166 2 1892165664 12582720 24100864
20:08:16 1758 8192000000 10805925024 11191668736 1858892064 18.494 100 93 184 0 1898848832 12202512 27754256
20:08:24 1811 8192000000 10805806880 11192840192 1861351440 18.514 100 90 180 0 1898716848 12132016 25233392
20:08:32 1847 8192000000 10806252608 11196592128 1864797104 18.542 100 94 186 2 1905191344 13795200 26599040
20:08:40 1265 8192000000 10810010352 11195797504 1862925120 18.527 100 94 187 3 1901714800 12595520 26194160
20:08:48 1729 8192000000 10814745504 11203911680 1870911552 18.592 100 95 192 2 1911265344 13237264 27116528
20:08:56 1506 8192000000 10818486496 11206664192 1870291248 18.587 100 92 185 3 1911430256 15418832 25720176
20:09:04 1847 8192000000 10826470192 11216257024 1876560800 18.637 100 91 183 1 1916659376 14231088 25867488
20:09:12 41797 8192000000 10785758016 11201011712 1867205072 18.562 100 55 111 1 1892180256 8321648 16653536
20:10:04 7380 8192000000 10796126576 11210104832 1868834528 18.575 100 38 76 2 1890855584 11147728 10873328
20:10:18 8787 8192000000 10780574832 11208298496 1874296624 18.619 100 31 62 1 1889540368 6688016 8555728
20:10:38 8414 8192000000 10785290736 11216236544 1877069808 18.641 100 24 46 1 1890808240 7167216 6571216
20:10:53 9345 8192000000 10794433136 11222454272 1878795360 18.655 100 18 35 1 1889719584 6105840 4818384
20:11:09 12036 8192000000 10783993936 11222777856 1886982656 18.721 100 14 26 1 1896241360 5577360 3681344
20:11:31 12093 8192000000 10794499264 11231186944 1893833360 18.777 100 20 40 0 1905511712 5884000 5794352
20:11:50 23767 8192000000 10799515088 11234951168 1892106576 18.763 100 14 28 0 1901650976 5947584 3596816
20:12:20 12057 8192000000 10806939152 11240054784 1897808768 18.809 100 13 26 0 1907320896 6175328 3336800
20:12:42 5909 8192000000 10810986448 11243954176 1901248928 18.836 100 20 40 0 1912868656 6028656 5591072
20:12:56 12477 8192000000 10815017216 11254595584 1901038192 18.835 100 12 24 0 1917768416 13645104 3085120
20:13:15 25842 8192000000 10820319040 11247439872 1903890928 18.858 100 20 41 2 1915168000 6027952 5249120
20:13:49 65877 8192000000 10830847984 11258216448 1907090592 18.883 100 29 58 2 1921002320 5581104 8330624
20:15:01 13740 8192000000 10821707728 11259613184 1907920080 18.890 100 20 39 1 1920223280 6139008 6164192
20:15:23 6206 8192000000 10820234032 11258478592 1909671424 18.904 100 33 66 2 1925737552 6362320 9703808
20:15:35 9621 8192000000 10833269504 11257503744 1889979488 18.746 99 19 37 0 1901214544 5358336 5876720
20:15:52 5378 8192000000 10825331264 11259891712 1910626224 18.912 100 33 66 2 1926432128 6960960 8844944
20:16:03 5552 8192000000 10833002080 11262844928 1910074336 18.907 100 38 76 0 1929147024 8620000 10452688
20:16:16 5118 8192000000 10824309648 11260207104 1905040672 18.867 100 31 62 1 1924507984 10325776 9141536
20:16:29 6981 8192000000 10820786736 11254272000 1902140624 18.844 100 25 49 3 1914871504 5819024 6911856
20:16:48 6067 8192000000 10818377808 11254759424 1904677136 18.864 100 23 46 2 1917796320 6682016 6437168
20:17:01 8659 8192000000 10794910160 11234119680 1857276192 18.481 98 15 29 2 1866595904 5087136 4232576
20:17:19 8888 8192000000 10792081392 11223281664 1817949872 18.161 96 21 40 0 1830168752 6140976 6077904
20:17:35 6229 8192000000 10811543712 11234312192 1881521760 18.677 100 29 59 0 1896126688 6651584 7953344
20:17:50 13148 8192000000 10795012064 11228356608 1882852832 18.688 100 16 30 3 1892912528 5602624 4457072
20:18:11 13756 8192000000 10765056544 11206496256 1833210800 18.286 98 16 32 0 1843092480 5564384 4317296
20:18:31 8330 8192000000 10755265360 11186728960 1804468560 18.051 97 17 34 1 1814756576 5704656 4583360
20:18:45 72818 8192000000 10691408912 11113340928 1669848896 16.932 90 27 54 2 1682612432 5145728 7617808
20:20:04 8287 8192000000 10715729648 11140882432 1770634048 17.772 97 24 48 0 1782594448 4953376 7007024
20:20:21 7213 8192000000 10723970048 11137634304 1744263840 17.554 96 29 57 2 1758584016 6330592 7989584
20:20:36 5939 8192000000 10718886560 11138732032 1776528480 17.821 98 26 54 0 1789664448 5702304 7433664
20:20:52 4886 8192000000 10736415184 11150872576 1795268832 17.975 99 35 70 2 1812518560 7114896 10134832
20:21:03 6423 8192000000 10718150896 11128242176 1760913504 17.692 97 22 43 3 1772873792 5359088 6601200
20:21:16 7595 8192000000 10730225968 11148869632 1783015216 17.874 98 26 52 1 1796201552 5128752 8057584
20:21:31 8129 8192000000 10711439488 11131158528 1787598544 17.912 99 20 40 0 1799291104 6190688 5501872
20:21:47 7832 8192000000 10708743728 11114627072 1753954720 17.634 97 42 82 3 1771780240 5483776 12341744
20:22:01 10053 8192000000 10693161792 11109801984 1762054912 17.701 98 30 60 1 1776439120 5594016 8790192
20:22:19 7203 8192000000 10697219616 11113381888 1781493232 17.862 99 24 48 4 1794122960 5961824 6667904
20:22:32 6322 8192000000 10693210288 11110666240 1754010336 17.635 98 31 62 2 1768396704 5449648 8936720
20:22:45 12329 8192000000 10701606816 11118989312 1739814016 17.517 97 33 66 1 1755184480 5154096 10216368
20:23:06 10057 8192000000 10725854144 11145256960 1807663344 18.077 100 24 48 2 1820170768 5194736 7312688
20:23:27 39951 8192000000 10727760768 11158409216 1802114608 18.031 99 28 56 1 1816643472 5782912 8745952
20:24:32 27205 8192000000 10749615408 11172065280 1837684416 18.322 100 26 53 1 1851086512 5732192 7669904
20:25:11 7334 8192000000 10758771552 11183144960 1842791680 18.364 100 23 46 1 1854876144 5642704 6441760
20:25:26 10501 8192000000 10763361536 11182592000 1826450496 18.230 99 29 58 1 1844022160 9491664 8080000
20:25:43 4733 8192000000 10764305168 11186262016 1841784304 18.355 100 18 36 0 1853602368 5244240 6573824
20:25:55 5977 8192000000 10766300880 11192582144 1848974608 18.414 100 20 38 1 1860080288 5341696 5763984
20:26:09 4055 8192000000 10769768464 11199541248 1857615024 18.484 100 30 60 1 1872945568 7507760 7822784
20:26:20 6686 8192000000 10783984784 11203489792 1859779952 18.501 100 23 44 1 1871304432 5218768 6305712
20:26:34 6224 8192000000 10780071008 11212836864 1863635328 18.533 100 22 44 0 1880165712 9186448 7343936
20:26:47 14288 8192000000 10784445120 11208294400 1864247728 18.538 100 17 33 2 1874285616 5604560 4433328
20:27:09 59808 8192000000 10814705472 11236818944 1888798672 18.736 100 32 63 2 1903600176 4876320 9925184
20:28:16 9695 8192000000 10836131728 11257548800 1901819776 18.841 100 36 72 2 1920521760 8255696 10446288
20:28:34 14184 8192000000 10853635968 11268456448 1912800368 18.929 100 54 107 2 1938390032 10541824 15047840
20:29:01 13033 8192000000 10851273776 11273412608 1920117728 18.988 100 51 102 2 1946497968 11387232 14993008
20:29:33 52745 8192000000 10864868992 11298541568 1928464592 19.055 100 35 68 1 1954570336 15100416 11005328
20:31:07 71134 8192000000 10876346128 11318165504 1944601792 19.183 100 37 74 1 1968459760 13052224 10805744
20:32:25 14656 8192000000 10891744544 11325779968 1957383664 19.285 100 44 86 1 1984618640 14974144 12260832
20:32:55 7216 8192000000 10902685888 11331981312 1964175088 19.339 100 44 86 0 1992014432 15607328 12232016
20:33:10 15507 8192000000 10909942640 11339706368 1968394672 19.373 100 50 100 0 1999388752 16765680 14228400
20:33:34 20758 8192000000 10903394352 11343106048 1970120688 19.386 100 38 76 0 1997780432 16225440 11434304
20:34:04 35621 8192000000 10921196144 11360141312 1978142992 19.450 100 35 70 1 2008809504 20294704 10371808
20:34:54 26480 8192000000 10927058592 11369074688 1983915168 19.496 100 35 70 2 2013103952 18860064 10328720
20:35:28 13611 8192000000 10939761184 11377164288 1993989488 19.575 100 39 78 1 2025152544 19420800 11742256
20:35:50 4041 8192000000 10947778480 11381948416 2001980000 19.638 100 56 112 1 2038855872 20259360 16616512
20:36:08 5308 8192000000 10959209232 11387502592 2006141264 19.671 100 60 120 0 2045737200 21509264 18086672
20:36:22 7758 8192000000 10962755456 11393564672 2006739888 19.676 100 58 115 3 2046141184 22449904 16951392
20:36:42 27492 8192000000 10973038464 11406737408 2010332704 19.704 100 61 122 2 2054499376 26175888 17990784
20:37:18 11254 8192000000 10960455312 11393335296 2001777024 19.637 100 56 111 2 2048502416 29608448 17116944
20:37:48 3938 8192000000 10973418576 11399819264 2007499104 19.682 100 55 108 1 2054050848 30757872 15793872
20:38:01 5241 8192000000 10974553392 11402915840 2013283472 19.727 100 65 126 2 2060367120 27488592 19595056
20:38:13 4138 8192000000 10982984240 11410108416 2013089888 19.726 100 72 143 0 2069882672 35102800 21689984
20:38:28 4977 8192000000 10982934400 11413889024 2020532656 19.784 100 66 130 1 2074167808 33970608 19664544
20:38:40 6531 8192000000 11000246672 11419283456 2025802144 19.826 100 81 159 1 2080684688 30672272 24210272
20:38:54 5863 8192000000 10992065328 11415322624 2020849568 19.787 100 77 151 4 2075599584 31682992 23067024
20:39:09 2930 8192000000 11000528800 11417378816 2023949536 19.811 100 77 152 1 2080316080 32099808 24266736
20:39:19 4280 8192000000 10984766000 11417776128 2020062512 19.781 100 66 131 2 2074995568 33364928 21568128
20:39:30 2585 8192000000 10988675632 11407880192 2006310704 19.672 99 76 144 0 2063189392 34901680 21977008
20:39:42 5577 8192000000 10972030688 11405295616 1997081024 19.600 99 64 122 3 2056065824 39653360 19331440
20:39:55 1907 8192000000 11000294272 11416428544 2017659536 19.762 100 83 167 4 2079165504 35288880 26217088
20:40:05 8208 8192000000 10999651024 11422724096 2022664912 19.801 100 73 146 0 2079114160 34153744 22295504
20:40:21 2198 8192000000 11004461904 11424808960 2031025120 19.867 100 82 164 1 2092195984 35847888 25322976
20:40:32 2501 8192000000 11002158832 11431374848 2032123488 19.875 100 75 147 0 2091875136 38018608 21733040
20:40:42 2349 8192000000 11005896032 11429625856 2023414848 19.807 100 75 151 2 2085776800 39187408 23174544
20:40:52 2035 8192000000 11012092800 11434094592 2026947296 19.835 100 87 172 1 2093504720 40176112 26381312
20:41:02 4768 8192000000 10998461312 11421818880 1999811440 19.621 99 78 154 1 2066377344 43432560 23133344
20:41:14 3111 8192000000 10993187264 11411136512 2006374864 19.673 100 80 160 1 2070913312 38765280 25773168
20:41:26 4124 8192000000 10978190656 11407511552 1989866896 19.543 99 70 138 4 2051680736 39285552 22528288
20:41:37 2101 8192000000 10975282048 11409453056 1992444336 19.563 99 75 150 5 2058046416 40385776 25216304
20:41:48 6216 8192000000 10970334480 11409444864 2004164768 19.656 100 74 148 0 2067690928 39894656 23631504
20:42:04 1972 8192000000 10990282000 11421847552 2016334080 19.751 100 76 152 2 2077703792 37527456 23842256
20:42:13 5322 8192000000 11002505872 11428843520 2025267456 19.822 100 81 162 0 2087455392 36625072 25562864
20:42:26 2319 8192000000 10989849680 11415298048 2001537376 19.635 99 88 176 1 2066318848 37796784 26984688
20:42:35 1182 8192000000 11009371776 11427196928 2020792160 19.786 100 93 186 1 2088340096 38701280 28846656
20:42:42 4562 8192000000 11008666320 11430731776 2024291248 19.814 100 87 174 1 2090871904 39492752 27087904
20:42:55 6394 8192000000 10998341264 11414089728 2006657872 19.675 100 88 175 2 2073590432 40903584 26028976
20:43:11 3541 8192000000 10982449952 11395534848 1987045936 19.520 99 88 173 3 2048377744 35432976 25898832
20:43:25 2632 8192000000 10991424960 11411984384 2008550464 19.690 100 85 170 1 2073158304 38081024 26526816
20:43:34 4334 8192000000 10989123424 11413012480 2010468544 19.705 100 72 141 1 2068631360 37072800 21090016
20:43:46 2406 8192000000 10986956752 11411054592 2004737232 19.660 100 83 163 1 2067738480 37907536 25093712
20:43:55 2759 8192000000 10996046240 11414130688 2008562080 19.690 100 81 161 3 2072000320 38801872 24636368
20:44:05 5112 8192000000 10983373248 11414040576 2010608064 19.706 100 74 147 3 2074308704 40124432 23576208
20:44:17 10375 8192000000 10979211936 11417079808 1993352384 19.570 99 61 122 2 2052233536 39556384 19324768
20:44:47 3736 8192000000 10996237088 11417354240 1995631504 19.588 99 74 147 4 2059506112 41013328 22861280
20:44:58 1538 8192000000 10995582736 11414663168 2007236816 19.680 100 92 186 2 2078651584 42183536 29231232
20:45:06 7538 8192000000 10966078976 11407704064 1983702064 19.494 99 53 106 0 2042975008 42420144 16852800
20:45:24 11773 8192000000 10972382160 11412123648 2007698368 19.683 100 39 78 2 2056938896 36564208 12676320
20:45:44 4254 8192000000 10976331392 11409915904 2005003488 19.662 100 64 128 2 2061776320 36946176 19826656
20:45:56 2256 8192000000 10988936976 11409866752 1998432624 19.610 100 83 166 0 2064348416 40558096 25357696
20:46:06 6591 8192000000 10982137840 11414855680 2001203840 19.632 100 68 136 0 2065416176 42721296 21491040
20:46:19 5700 8192000000 10962063568 11404558336 1963229600 19.332 98 48 96 1 2022817776 43522128 16066048
20:46:35 12838 8192000000 10949784192 11396435968 1989936016 19.543 100 42 84 1 2041125296 37363600 13825680
20:46:56 7077 8192000000 10966617088 11405512704 1991225632 19.553 100 47 95 2 2046274592 40260560 14788400
20:47:15 3919 8192000000 10975540160 11405328384 1982969872 19.488 99 64 128 0 2045575120 42646112 19959136
20:47:49 5623 8192000000 10968371136 11399909376 1983210256 19.490 100 53 106 2 2048255952 47535760 17509936
20:48:03 12758 8192000000 10969481632 11400159232 1980522272 19.469 100 55 110 2 2048438880 49587200 18329408
20:48:22 13362 8192000000 10959569168 11405893632 1985377952 19.507 100 43 86 1 2049856416 48932736 15545728
20:48:42 7968 8192000000 10964442560 11408556032 1986308112 19.515 100 45 90 0 2054635184 52189792 16137280
20:48:57 12493 8192000000 10965217760 11413733376 1983532928 19.493 100 39 78 1 2056073616 58547680 13993008
20:49:27 5184 8192000000 10944564032 11378417664 1953319824 19.253 100 59 118 0 2028669968 55988912 19361232
20:49:39 7831 8192000000 10949707408 11387191296 1957402560 19.285 100 49 98 1 2027895792 53621856 16871376
20:49:57 17079 8192000000 10932286240 11390521344 1962518208 19.326 100 31 62 0 2027750448 53838672 11393568
20:50:20 14661 8192000000 10928011600 11372302336 1952931360 19.250 100 35 70 2 2003347920 38759424 11657136
20:50:50 23264 8192000000 10899386768 11351101440 1951134240 19.236 100 23 46 0 1989174368 30272176 7767952
20:51:20 24429 8192000000 10892832976 11342041088 1933075584 19.091 99 24 46 1 1968360112 27715840 7568688
20:51:59 16383 8192000000 10917829760 11360956416 1951343568 19.237 100 29 58 1 1993945232 33565312 9036352
20:52:41 12176 8192000000 10885379472 11326476288 1895269072 18.788 98 36 72 3 1943728448 36329184 12130192
20:53:04 5636 8192000000 10893160800 11315326976 1888701904 18.735 98 44 85 3 1942516800 39318624 14496272
20:53:17 1722 8192000000 10926601456 11351404544 1941047488 19.155 100 63 125 1 2006525920 45113856 20364576
20:53:25 9752 8192000000 10921853552 11365249024 1942689424 19.168 100 50 100 0 2007875504 48318208 16867872
20:53:48 7692 8192000000 10905602960 11348844544 1903072928 18.851 98 29 58 0 1961458128 47728464 10656736
20:54:11 22718 8192000000 10906682320 11370311680 1940924880 19.154 100 30 60 0 2000318176 48378880 11014416
20:54:40 18061 8192000000 10874514384 11325038592 1921716560 19.001 99 23 46 3 1956596992 26437696 8442736
20:55:26 45549 8192000000 10879785536 11328024576 1915324960 18.949 99 39 75 1 1954289536 27160592 11803984
20:56:50 37723 8192000000 10889701216 11349192704 1936241792 19.117 100 28 56 1 1978031936 33057712 8732432
20:57:41 52393 8192000000 10883883584 11347812352 1945793696 19.193 100 16 32 1 1969311584 18394256 5123632
20:59:18 62111 8192000000 10865294256 11326251008 1917580720 18.967 99 20 40 0 1942030240 18759776 5689744
21:00:42 17814 8192000000 10840680384 11296632832 1881033664 18.673 98 15 30 1 1908164992 22323536 4807792
21:01:09 59900 8192000000 10868223488 11316191232 1928696976 19.056 100 36 71 0 1947163008 8333840 10132192
21:02:15 69816 8192000000 10871355760 11323031552 1909587840 18.903 98 23 47 1 1925363520 9785584 5990096
21:03:32 104709 8192000000 10890971552 11359236096 1955088528 19.267 100 13 26 1 1978973472 20108992 3775952
21:05:26 30129 8192000000 10884280240 11358044160 1960339392 19.309 100 16 32 0 1983990480 18790160 4860928
21:06:19 92139 8192000000 10887262448 11344015360 1945383264 19.190 99 23 45 1 1963853504 12179648 6290592
21:08:06 37610 8192000000 10908853200 11355955200 1951931648 19.242 99 44 88 1 1974229472 10030176 12267648
21:08:52 99988 8192000000 10896731776 11357556736 1931692832 19.080 98 25 50 2 1950358640 12210592 6455216
21:11:22 119283 8192000000 10870854224 11350761472 1935774384 19.113 99 10 20 0 1950861840 12412320 2675136
21:13:32 39074 8192000000 10886210320 11348197376 1962358432 19.325 100 24 48 0 1976242832 7312784 6571616
21:14:27 70150 8192000000 10909563840 11369197568 1970899984 19.393 100 15 30 0 1983748592 8035168 4813440
21:15:43 81588 8192000000 10900469888 11374608384 1980399296 19.468 100 18 36 0 1995271360 9601024 5271040
21:17:43 71817 8192000000 10908220128 11371900928 1962120784 19.323 99 27 54 0 1978688592 8763008 7804800
21:19:06 44373 8192000000 10917947312 11384311808 1987500160 19.524 100 29 57 0 2005479872 9905248 8074464
21:21:07 63846 8192000000 10909799840 11373813760 1955705216 19.272 98 19 38 1 1977018848 15627616 5686016
21:22:23 38731 8192000000 10916186240 11385032704 1983914016 19.496 100 25 50 1 2009483024 17611344 7957664
21:23:09 71260 8192000000 10902514608 11377999872 1970907856 19.393 99 21 42 0 1995934224 18691376 6334992
21:24:27 51293 8192000000 10912794352 11387592704 1972601728 19.406 99 13 26 1 1993693088 17467840 3623520
21:25:29 64210 8192000000 10912577280 11405381632 1987849568 19.527 100 13 26 0 2014279216 22354080 4075568
21:27:24 139073 8192000000 10889357296 11368701952 1909463136 18.902 96 7 14 0 1928300304 17425232 1411936
21:29:55 43279 8192000000 10904160880 11376398336 1982814496 19.487 100 28 56 3 2003699856 11868928 9016432
21:30:47 54786 8192000000 10884373056 11345174528 1925448496 19.030 97 11 22 0 1940427904 11577888 3401520
21:31:58 55944 8192000000 10881039712 11358371840 1908446576 18.894 97 13 26 1 1925907088 13202864 4257648
21:33:06 81126 8192000000 10878679136 11345793024 1905478672 18.870 97 21 42 0 1922306192 10929040 5898480
21:34:40 21950 8192000000 10889050064 11351392256 1948299968 19.213 99 33 66 5 1968869584 11388864 9180752
21:35:23 69353 8192000000 10900602608 11375951872 1943963776 19.178 99 16 32 1 1968556032 20048288 4543968
21:36:40 81493 8192000000 10891374656 11355697152 1893547536 18.774 96 15 30 0 1906952432 9613696 3791200
21:38:10 53280 8192000000 10868932992 11327074304 1842257216 18.359 94 30 61 2 1860735408 10261600 8216592
21:39:10 39839 8192000000 10887744352 11347730432 1932400864 19.086 99 27 53 0 1952870560 13215792 7253904
21:39:57 140660 8192000000 10893089216 11375165440 1875668512 18.630 96 15 30 0 1905396416 26050512 3677392
21:42:28 118504 8192000000 10849075088 11311181824 1895151664 18.787 97 25 50 2 1911850016 9477488 7220864
21:44:33 58275 8192000000 10879749824 11346935808 1945456256 19.190 100 8 14 1 1959938336 12832992 1649088
21:45:40 31253 8192000000 10864223456 11341172736 1911603888 18.920 98 21 42 1 1928141424 10839408 5698128
21:46:18 43091 8192000000 10811129696 11279458304 1815206512 18.138 94 11 22 1 1827357248 8281936 3868800
21:47:07 54442 8192000000 10820554192 11288489984 1884629376 18.702 99 14 28 1 1901079136 11831056 4618704
21:48:08 69777 8192000000 10836957888 11323535360 1887812288 18.728 98 10 20 0 1900398704 9740112 2846304
21:49:24 60613 8192000000 10828936832 11303145472 1855839024 18.470 96 17 34 1 1874675392 14096912 4739456
21:50:36 35776 8192000000 10828713488 11301068800 1873879696 18.616 98 10 20 0 1887819584 10591552 3348336
21:51:42 90968 8192000000 10817698960 11295051776 1857462464 18.483 97 14 28 0 1874964768 12927440 4574864
21:53:31 57071 8192000000 10840112592 11306283008 1908757360 18.897 100 23 44 0 1923029664 8356592 5915712
21:54:46 48535 8192000000 10826006448 11302461440 1886933808 18.721 98 21 41 1 1900602000 7625040 6043152
21:55:50 79603 8192000000 10815808336 11293241344 1804251008 18.049 94 5 10 1 1812767296 7273232 1243056
21:57:21 71598 8192000000 10860137424 11324764160 1893830512 18.777 98 16 32 3 1910773888 12883680 4059696
21:58:39 31467 8192000000 10861214928 11316224000 1878449136 18.653 97 29 56 1 1892780160 6926784 7404240
21:59:23 7387 8192000000 10890596080 11338887168 1940651744 19.152 100 61 122 2 1979054608 21856368 16546496
21:59:43 6962 8192000000 10890056032 11335659520 1948869792 19.217 100 55 110 0 1975371376 11518640 14982944
21:59:57 13857 8192000000 10869265440 11316969472 1919348112 18.982 99 48 96 0 1943545648 11291664 12905872
22:00:20 6488 8192000000 10882837952 11329200128 1940528400 19.151 100 50 100 2 1966007680 11458816 14020464
22:00:34 26345 8192000000 10879322176 11337867264 1943680656 19.176 100 45 90 3 1970401440 14224288 12496496
22:01:14 42679 8192000000 10861972896 11329036288 1907636384 18.888 98 30 60 0 1927436048 11789776 8009888
22:02:04 56761 8192000000 10868314448 11315609600 1898509024 18.814 98 27 54 0 1916842688 10826848 7506816
22:03:08 46755 8192000000 10868411360 11332460544 1925364512 19.030 99 28 56 1 1944311232 11120752 7825968
22:04:07 88547 8192000000 10881175008 11364892672 1934017472 19.099 99 19 38 1 1955112816 15796096 5299248
22:05:41 65992 8192000000 10892485600 11354386432 1922383728 19.006 98 12 24 0 1936039568 10403408 3252432
22:06:59 39000 8192000000 10890605904 11361259520 1935598016 19.112 99 31 61 1 1959484080 15127632 8758432
22:08:06 74016 8192000000 10899297872 11363860480 1905996048 18.874 97 15 30 0 1924476288 14377184 4103056
22:09:27 46386 8192000000 10889794064 11363569664 1907133424 18.884 98 9 18 0 1930960640 20871904 2955312
22:10:21 214783 8192000000 10896576064 11371282432 1948306016 19.213 99 18 36 0 1974024992 20825104 4893872
22:14:02 30487 8192000000 10904650144 11375730688 1975750688 19.431 100 19 38 1 1990487968 9643360 5093920
22:14:39 49935 8192000000 10884472144 11374555136 1969847440 19.384 100 14 28 0 1985856976 11873008 4136528
22:15:35 12715 8192000000 10880231904 11377233920 1966447728 19.357 100 3 6 0 1978069776 10930096 691952
22:15:54 5058 8192000000 10880061664 11376836608 1966844304 19.360 100 3 6 0 1978415840 10867744 703792
22:16:12 65353 8192000000 10893306160 11373895680 1952261632 19.244 99 9 18 0 1962755648 8119104 2374912
22:17:24 79945 8192000000 10889312672 11367665664 1900225744 18.828 96 15 30 0 1916989968 12643360 4120864
22:18:57 52528 8192000000 10915688192 11374862336 1952311472 19.245 99 19 38 0 1971750224 13868896 5569856
22:19:59 57525 8192000000 10886293888 11362918400 1918564768 18.975 98 18 36 1 1942827888 18579248 5683872
22:21:04 78130 8192000000 10868298608 11341213696 1876955680 18.641 96 19 38 1 1890830416 8508352 5366384
22:22:33 28435 8192000000 10845369856 11303936000 1875162928 18.626 97 32 64 2 1890706000 6412560 9130512
22:23:07 22402 8192000000 10867295296 11315163136 1887167104 18.723 98 47 94 1 1913014480 12218976 13628400
22:23:40 25260 8192000000 10865403056 11318996992 1911227728 18.917 99 59 119 2 1938474688 9917104 17329856
22:24:19 65692 8192000000 10859589360 11318136832 1905772848 18.873 99 34 68 1 1932922992 18022816 9127328
22:25:32 46684 8192000000 10878408720 11338555392 1931647872 19.080 100 30 59 0 1949797504 9985472 8164160
22:26:26 65887 8192000000 9244354368 9502461952 401805408 4.675 21 5 10 0 406559808 3431792 1322608

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 12-03-2021 22:28:30 to 12-03-2021 22:29:00.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 154 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 12-03-2021 22:29:01 to 12-03-2021 22:29:03.

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

12.03.21 22:29:04. 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-03-12 22:29:07 No severe PSQL-related problems occured
12.03.21 22:29:08. End of report.