Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.01.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 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 17514600 kB
MemAvailable 31397624 kB
Buffers 0 kB
Cached 14165208 kB
SwapCached 4864 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-02 22:27:10
DTS_END                         2021-01-02 22:27:10.8600
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_MAKE_INVNT_SALDO(40:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/40204
TRN_ID                          247692
ATT_ID                          667
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: 9003.31 18583 1080397
customer order: creation 183.08 366 21970
customer order: refuse 15.32 317 1838
order to supplier: creation 48.08 1325 5770
order to supplier: removal 3.37 87581 404
invoice (draft): creation 48.95 3334 5874
invoice (draft): removal 49.57 692 5948
invoice accept: apply 43.90 19614 5268
invoice accept: cancel 43.91 916 5269
customer reserve: creation 3977.91 200 477349
customer reserve: removal 4285.52 55 514263
realization accept: apply 90.31 173 10837
realization accept: cancel 76.00 111 9120
payment from customer: creation 62.76 125 7531
payment from customer: removal 5.90 95 708
payment to supplier: creation 51.61 136 6193
payment to supplier: removal 3.65 76 438
service: total inventory turnovers 5.70 939 684
service: total monetary turnovers 6.73 24 807
service: aggregate perf. data 1.02 14653 122
service: refresh index statistics 0.03 240937 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 02-01-2021 22:28:08 to 02-01-2021 22:28:11.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10683
TEST_TIME 2 7028
TEST_TIME 3 6112
TEST_TIME 4 6842
TEST_TIME 5 6238
TEST_TIME 6 5853
TEST_TIME 7 5930
TEST_TIME 8 6199
TEST_TIME 9 6461
TEST_TIME 10 6468
TEST_TIME 11 6584
TEST_TIME 12 6755
TEST_TIME 13 7205
TEST_TIME 14 7314
TEST_TIME 15 7594
TEST_TIME 16 8123
TEST_TIME 17 8717
TEST_TIME 18 9143
TEST_TIME 19 9176
TEST_TIME 20 9326
TEST_TIME 21 9425
TEST_TIME 22 9677
TEST_TIME 23 10025
TEST_TIME 24 10183
TEST_TIME 25 10791
TEST_TIME 26 10549
TEST_TIME 27 10345
TEST_TIME 28 10111
TEST_TIME 29 10045
TEST_TIME 30 10142
TEST_TIME 31 10099
TEST_TIME 32 10009
TEST_TIME 33 9840
TEST_TIME 34 9719
TEST_TIME 35 9652
TEST_TIME 36 9519
TEST_TIME 37 9517
TEST_TIME 38 9413
TEST_TIME 39 9436
TEST_TIME 40 9314
TEST_TIME 41 9285
TEST_TIME 42 9191
TEST_TIME 43 9052
TEST_TIME 44 9130
TEST_TIME 45 9079
TEST_TIME 46 9127
TEST_TIME 47 9123
TEST_TIME 48 9119
TEST_TIME 49 9129
TEST_TIME 50 9124
TEST_TIME 51 9217
TEST_TIME 52 9267
TEST_TIME 53 9176
TEST_TIME 54 9284
TEST_TIME 55 9260
TEST_TIME 56 9320
TEST_TIME 57 9329
TEST_TIME 58 9238
TEST_TIME 59 9277
TEST_TIME 60 9208
TEST_TIME 61 9169
TEST_TIME 62 9122
TEST_TIME 63 9129
TEST_TIME 64 9161
TEST_TIME 65 9124
TEST_TIME 66 9120
TEST_TIME 67 9213
TEST_TIME 68 9177
TEST_TIME 69 9129
TEST_TIME 70 9124
TEST_TIME 71 9279
TEST_TIME 72 9262
TEST_TIME 73 9270
TEST_TIME 74 9316
TEST_TIME 75 9358
TEST_TIME 76 9343
TEST_TIME 77 9375
TEST_TIME 78 9364
TEST_TIME 79 9376
TEST_TIME 80 9265
TEST_TIME 81 9287
TEST_TIME 82 9228
TEST_TIME 83 9185
TEST_TIME 84 9179
TEST_TIME 85 9122
TEST_TIME 86 9071
TEST_TIME 87 9055
TEST_TIME 88 9063
TEST_TIME 89 9083
TEST_TIME 90 9126
TEST_TIME 91 9114
TEST_TIME 92 9102
TEST_TIME 93 9153
TEST_TIME 94 9141
TEST_TIME 95 9188
TEST_TIME 96 9155
TEST_TIME 97 9212
TEST_TIME 98 9239
TEST_TIME 99 9236
TEST_TIME 100 9237
TEST_TIME 101 9319
TEST_TIME 102 9286
TEST_TIME 103 9293
TEST_TIME 104 9231
TEST_TIME 105 9212
TEST_TIME 106 9159
TEST_TIME 107 9139
TEST_TIME 108 9143
TEST_TIME 109 9093
TEST_TIME 110 9055
TEST_TIME 111 9021
TEST_TIME 112 8981
TEST_TIME 113 8989
TEST_TIME 114 9040
TEST_TIME 115 9057
TEST_TIME 116 9058
TEST_TIME 117 9009
TEST_TIME 118 9073
TEST_TIME 119 9062
TEST_TIME 120 9007

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-01-2021 22:28:12 to 02-01-2021 22:28:15.

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 1523053 1523053 0 0.00 0 22933 7 0 0
doc_list_biud 1523052 1523052 0 0.00 0 26475 24 0 0
sp_add_invoice_to_stock 5406 5268 138 2.55 23 216586 19615 0 138
sp_cancel_adding_invoice 5269 5269 0 0.00 4 94994 916 0 0
sp_cancel_client_order 1838 1838 0 0.00 4 9042 317 0 0
sp_cancel_customer_reserve 514263 514263 0 0.00 1 24674 55 0 0
sp_cancel_pay_from_customer 708 708 0 0.00 3 10829 96 0 0
sp_cancel_pay_to_supplier 438 438 0 0.00 3 5422 76 0 0
sp_cancel_supplier_invoice 5961 5948 13 0.21 2 19486 692 0 13
sp_cancel_supplier_order 404 404 0 0.00 6 963402 87581 0 0
sp_cancel_write_off 9120 9120 0 0.00 1 20969 112 0 0
sp_client_order 21970 21970 0 0.00 3 19441 366 0 0
sp_customer_reserve 477349 477349 0 0.00 0 117399 201 0 0
sp_fill_shopping_cart 33603 33603 0 0.00 1 27395 39 0 0
sp_fill_shopping_cart_clo_res 477340 477340 0 0.00 0 16413 14 0 0
sp_get_clo_for_invoice 5258 5258 0 0.00 0 28408 270 0 0
sp_kill_cost_storno 15535 15535 0 0.00 0 14191 53 0 0
sp_kill_qstorno_ret_qs2qd 1043998 1043998 0 0.00 0 26473 30 0 0
sp_kill_qty_storno 552936 552936 0 0.00 0 26474 65 0 0
sp_lock_selected_doc 22117 22117 0 0.00 0 7847 4 0 0
sp_make_cost_storno 29818 29818 0 0.00 0 21538 55 0 0
sp_multiply_rows_for_pdistr 29818 29818 0 0.00 0 15248 28 0 0
sp_multiply_rows_for_qdistr 21970 21970 0 0.00 0 17934 165 0 0
sp_pay_from_customer 7531 7531 0 0.00 4 14093 126 0 0
sp_pay_to_supplier 6193 6193 0 0.00 5 21541 137 0 0
sp_payment_common 13724 13724 0 0.00 1 11056 31 0 0
sp_qd_handle_on_cancel_clo 1838 1838 0 0.00 0 9035 289 0 0
sp_qd_handle_on_invoice_upd_sts 10526 10526 0 0.00 0 22941 318 0 0
sp_qd_handle_on_reserve_upd_sts 10837 10837 0 0.00 0 14647 60 0 0
sp_reserve_write_off 10837 10837 0 0.00 6 22126 174 0 0
sp_supplier_invoice 5874 5874 0 0.00 6 92439 3334 0 0
sp_supplier_order 5770 5770 0 0.00 5 68185 1325 0 0
srv_aggregate_perf_data 122 122 0 0.00 2874 163416 14653 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1228 217182 33516 0 0
srv_find_qd_qs_mism 1030568 1030568 0 0.00 0 20937 7 0 0
srv_make_invnt_saldo 684 684 0 0.00 34 66690 939 0 0
srv_make_money_saldo 807 807 0 0.00 1 775 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 146509 402181 240938 0 0
t$perf-abend:sp_add_invoice_to_stock 138 138 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5268 5268 0 0.00 0 25248 187 0 0
t$perf-norm:sp_cancel_adding_invoice 431 431 0 0.00 0 4060 113 0 0
t$perf-norm:sp_cancel_client_order 1838 1838 0 0.00 0 4744 12 0 0
t$perf-norm:sp_cancel_customer_reserve 720 720 0 0.00 0 5068 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 708 708 0 0.00 0 925 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 438 438 0 0.00 0 614 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 450 450 0 0.00 0 1374 22 0 0
t$perf-norm:sp_cancel_supplier_order 404 404 0 0.00 0 29498 1757 0 0
t$perf-norm:sp_cancel_write_off 1034 1034 0 0.00 0 2263 7 0 0
t$perf-norm:sp_client_order 21970 21970 0 0.00 0 11882 18 0 0
t$perf-norm:sp_customer_reserve 1091 1091 0 0.00 0 10999 19 0 0
t$perf-norm:sp_pay_from_customer 7531 7531 0 0.00 0 6614 11 0 0
t$perf-norm:sp_pay_to_supplier 6193 6193 0 0.00 0 11226 14 0 0
t$perf-norm:sp_reserve_write_off 10837 10837 0 0.00 0 19269 17 0 0
t$perf-norm:sp_supplier_invoice 5874 5874 0 0.00 0 8335 22 0 0
t$perf-norm:sp_supplier_order 5770 5770 0 0.00 0 6129 20 0 0
t$perf-norm:srv_aggregate_perf_data 122 122 0 0.00 0 2967 38 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 345 4 0 0
t$perf-norm:srv_make_invnt_saldo 684 684 0 0.00 0 4437 34 0 0
t$perf-norm:srv_make_money_saldo 807 807 0 0.00 0 618 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 10790 10514 276 2.55 0 7806 18 0 276
v_all_customers 39834 39834 0 0.00 0 19 1 0 0
v_all_suppliers 31920 31920 0 0.00 0 17 1 0 0
v_all_wares 43938 43938 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 862 862 0 0.00 0 1607 8 0 0
v_cancel_client_order 3676 3676 0 0.00 0 2257 5 0 0
v_cancel_customer_prepayment 1416 1416 0 0.00 0 4204 10 0 0
v_cancel_customer_reserve 1440 1440 0 0.00 0 1824 6 0 0
v_cancel_payment_to_supplier 876 876 0 0.00 0 5378 14 0 0
v_cancel_supplier_invoice 926 900 26 2.80 0 2505 18 0 26
v_cancel_supplier_order 808 808 0 0.00 0 921 4 0 0
v_cancel_write_off 2068 2068 0 0.00 0 5346 14 0 0
v_max_id_clo_ord 5768 5768 0 0.00 0 2840 2 0 0
v_max_id_clo_res 1091 1091 0 0.00 0 2474 14 0 0
v_max_id_ord_sup 5866 5866 0 0.00 0 4194 4 0 0
v_max_non_paid_invoice 1867 1867 0 0.00 0 393 2 0 0
v_max_non_paid_realizn 4150 4150 0 0.00 0 4081 4 0 0
v_min_id_clo_ord 5768 5768 0 0.00 0 7689 8 0 0
v_min_id_clo_res 1091 1091 0 0.00 0 5076 10 0 0
v_min_id_ord_sup 5866 5866 0 0.00 0 3742 5 0 0
v_min_non_paid_invoice 6193 6193 0 0.00 0 7276 22 0 0
v_min_non_paid_realizn 7531 7531 0 0.00 0 11043 20 0 0
v_our_firm 10866 10866 0 0.00 0 28 1 0 0
v_reserve_write_off 21674 21674 0 0.00 0 4980 6 0 0
x_lock_depdocs_on_canc_invoice 10767 10767 0 0.00 0 25983 137 0 0
x_lock_depdocs_on_canc_sup_ord 404 404 0 0.00 0 9292 318 0 0
x_make_qstorno_1000_1200 5770 5770 0 0.00 1 68176 1245 0 0
x_make_qstorno_1200_2000 5874 5874 0 0.00 3 90967 3195 0 0
x_make_qstorno_2100_3300 477349 477349 0 0.00 0 117396 185 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-01-2021 22:28:16 to 02-01-2021 22:28:20.

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:14 3 8192000000 8802138672 8813641728 8233680 0.100 2 1 2 0 8353088 56848 62560
19:57:21 18575 8192000000 10248735472 10556514304 924150128 10.137 72 52 103 0 944639744 2677072 17812544
19:57:49 32961 8192000000 10368317472 10688102400 1402950000 14.621 100 88 176 0 1436212896 4934416 28328480
19:58:32 23556 8192000000 10398456336 10729803776 1454346976 15.076 100 84 168 0 1487865072 6465776 27052320
19:59:06 22097 8192000000 10445464832 10778529792 1491690448 15.404 100 85 170 0 1525793936 7258352 26845136
19:59:37 16619 8192000000 10460096112 10794737664 1512171056 15.582 100 93 186 0 1549938144 8139392 29627696
20:00:15 19898 8192000000 10463774928 10807386112 1521059584 15.659 100 88 175 0 1557638208 9209280 27369344
20:00:49 15741 8192000000 10487494544 10828988416 1543690288 15.855 100 90 180 0 1581403872 9604960 28108624
20:01:24 21167 8192000000 10509952880 10858446848 1561389328 16.008 100 80 160 0 1596567264 10641952 24535984
20:01:54 19976 8192000000 10534528528 10889773056 1591629600 16.268 100 84 168 0 1628351008 10930432 25790976
20:02:28 17701 8192000000 10562793376 10921385984 1620349440 16.513 100 81 162 0 1656100896 11631136 24120320
20:02:58 16399 8192000000 10584615712 10949054464 1647974368 16.747 100 82 164 0 1684375568 12629488 23771712
20:03:22 14316 8192000000 10614918112 10980397056 1664538128 16.887 100 83 167 1 1702882736 13828896 24515712
20:03:48 10258 8192000000 10619741904 10991403008 1679358944 17.012 100 83 166 1 1717769072 14033792 24376336
20:04:08 5569 8192000000 10643820336 11014504448 1697425552 17.164 100 77 150 2 1731728336 12915168 21387616
20:04:21 7191 8192000000 10660965584 11033829376 1717554832 17.332 100 75 149 2 1751116688 12708736 20853120
20:04:37 5115 8192000000 10671258512 11046707200 1730846160 17.443 100 76 153 0 1765391584 12616800 21928624
20:04:50 8238 8192000000 10671247184 11048792064 1738992160 17.510 100 72 144 2 1772060224 12849040 20219024
20:05:05 4758 8192000000 10689727680 11073753088 1758341552 17.671 100 79 157 1 1793228512 12194672 22692288
20:05:22 6764 8192000000 10704324976 11091939328 1768101504 17.751 100 68 134 1 1798722912 11830096 18791312
20:05:35 4062 8192000000 10717492880 11100270592 1783238416 17.876 100 79 157 0 1817606208 12326528 22041264
20:05:48 3813 8192000000 10724630784 11107160064 1788107440 17.916 100 79 153 0 1822084624 12682624 21294560
20:05:59 5155 8192000000 10724337472 11117629440 1793955200 17.964 100 75 150 1 1828019984 13145008 20919776
20:06:11 4174 8192000000 10744429888 11132682240 1809984912 18.096 100 79 157 1 1845638288 13046992 22606384
20:06:24 2447 8192000000 10753529440 11143274496 1819159936 18.171 100 83 166 4 1854842128 12021072 23661120
20:06:35 3528 8192000000 10760765408 11146489856 1821313648 18.188 100 82 165 0 1857418224 12192016 23912560
20:06:45 2388 8192000000 10775783776 11162071040 1836636304 18.313 100 83 166 1 1872101920 12242464 23223152
20:06:54 2829 8192000000 10776807632 11164086272 1833220032 18.286 100 85 170 1 1871254848 13722608 24312208
20:07:04 2343 8192000000 10775979296 11163021312 1836297248 18.311 100 90 178 2 1876375520 14532112 25546160
20:07:13 2412 8192000000 10777265968 11166658560 1841597936 18.354 100 85 171 2 1878983824 13178640 24207248
20:07:23 1473 8192000000 10791064976 11177095168 1844468144 18.377 100 92 183 1 1883463152 14036896 24958112
20:07:31 2436 8192000000 10795114832 11182956544 1851405888 18.434 100 84 168 4 1889086800 13781328 23899584
20:07:40 2370 8192000000 10799790784 11190886400 1857526432 18.483 100 95 190 0 1897307040 13488032 26292576
20:07:48 2456 8192000000 10804029664 11193430016 1859902032 18.502 100 85 170 0 1897193904 13432736 23859136
20:07:57 1159 8192000000 10809283728 11196588032 1863097488 18.528 100 91 182 3 1901728320 12365856 26264976
20:08:05 1502 8192000000 10804387760 11196497920 1864476720 18.540 100 92 182 0 1903022416 12697680 25848016
20:08:13 1350 8192000000 10811306080 11200180224 1867786880 18.566 100 92 184 2 1907719952 13718960 26214112
20:08:21 15450 8192000000 10815021184 11207565312 1868583216 18.573 100 75 144 2 1900496176 12104016 19808944
20:08:43 2156 8192000000 10812864736 11214462976 1878237136 18.651 100 78 155 2 1912384528 12002704 22144688
20:08:51 2643 8192000000 10810594800 11215912960 1876980048 18.641 100 65 128 0 1908139824 11832208 19327568
20:09:00 2856 8192000000 10808680160 11218071552 1883808464 18.696 100 70 139 0 1915020288 10170752 21041072
20:09:10 6577 8192000000 10784064880 11209592832 1876335408 18.636 100 35 70 1 1894400304 8462720 9602176
20:09:23 5776 8192000000 10783162176 11206868992 1875138224 18.626 100 27 53 0 1889171344 6271552 7761568
20:09:38 5034 8192000000 10781747952 11211694080 1879676976 18.662 100 29 58 0 1894300080 6233072 8390032
20:09:50 18206 8192000000 10785483728 11214352384 1879754368 18.663 100 19 38 1 1891672112 5388784 6528960
20:10:14 41757 8192000000 10815248624 11240345600 1889115472 18.739 100 30 60 3 1903301136 5754064 8431600
20:11:11 17552 8192000000 10820264976 11246813184 1892281072 18.764 100 36 72 2 1913693440 11848512 9563856
20:11:35 10317 8192000000 10815847600 11251326976 1892903504 18.769 100 24 48 4 1915284912 15166512 7214896
20:11:54 6151 8192000000 10810700352 11242876928 1897206096 18.804 100 32 65 2 1913101248 6507120 9388032
20:12:07 5901 8192000000 10811932688 11242876928 1898368368 18.813 100 20 40 0 1909319952 5482528 5469056
20:12:21 7788 8192000000 10821273104 11253055488 1901058768 18.835 100 37 73 1 1922852560 10683760 11110032
20:12:37 5831 8192000000 10805828128 11244412928 1899378832 18.821 100 27 55 1 1913455712 6358288 7718592
20:12:50 6442 8192000000 10810978528 11247833088 1900486912 18.830 100 25 51 0 1913580400 6108288 6985200
20:13:03 7582 8192000000 10804243184 11248058368 1900183424 18.828 100 23 46 3 1912535312 5784784 6567104
20:13:19 9442 8192000000 10825905584 11254394880 1900182736 18.828 100 21 43 2 1916785168 10634448 5967984
20:13:35 6739 8192000000 10814806048 11249709056 1903533904 18.855 100 30 59 2 1917662400 5577552 8550944
20:13:50 8718 8192000000 10817166160 11251798016 1900113120 18.827 100 13 26 1 1910386000 6002768 4270112
20:14:08 16185 8192000000 10817525232 11254956032 1905515824 18.871 100 21 40 4 1921280112 9873328 5890960
20:14:35 33843 8192000000 10814874784 11257573376 1907869264 18.890 100 27 54 1 1921420032 5451648 8099120
20:15:37 38893 8192000000 10823052928 11260919808 1909840256 18.905 100 15 30 0 1919221792 5268992 4112544
20:16:22 8137 8192000000 10823706048 11258880000 1893660288 18.775 99 25 50 0 1911156672 10169296 7327088
20:16:36 3895 8192000000 10836079392 11267854336 1914065840 18.939 100 33 66 1 1931081552 7798240 9217472
20:16:47 6688 8192000000 10844550176 11263533056 1909867616 18.906 100 25 51 1 1927668720 10462768 7338336
20:17:00 4816 8192000000 10823448384 11250040832 1872876128 18.608 98 29 58 1 1888402176 6827888 8698160
20:17:15 6241 8192000000 10782966672 11221872640 1836038320 18.309 97 24 48 1 1849606048 7182960 6384768
20:17:28 5775 8192000000 10764563520 11196432384 1847049392 18.398 99 22 44 2 1859295664 5959856 6286416
20:17:41 8546 8192000000 10759403248 11188416512 1811498064 18.108 97 22 44 1 1823798160 5638112 6661984
20:17:59 10600 8192000000 10738580128 11161382912 1733862896 17.468 93 17 34 2 1744299440 5475120 4961424
20:18:18 9778 8192000000 10747483344 11174051840 1818281760 18.164 99 21 40 2 1829455200 5131344 6042096
20:18:34 7101 8192000000 10727612128 11151949824 1771345152 17.778 97 28 55 1 1785759568 5525760 8888656
20:18:52 16326 8192000000 10722872448 11149762560 1747247856 17.579 95 11 20 1 1755151616 5113872 2789888
20:19:16 70480 8192000000 10680669952 11091410944 1596346528 16.308 88 24 48 0 1608206768 4711248 7148992
20:20:38 8080 8192000000 10670838112 11078168576 1656674864 16.821 93 20 40 0 1672104320 9510128 5919328
20:20:54 7571 8192000000 10709852352 11117477888 1754797456 17.641 98 34 66 0 1770703472 5949120 9956896
20:21:12 5181 8192000000 10719418944 11130433536 1779241120 17.843 99 32 63 2 1793833280 5911456 8680704
20:21:24 8829 8192000000 10687671008 11106689024 1737845088 17.501 97 28 54 2 1752034176 5310048 8879040
20:21:39 6532 8192000000 10673230496 11078197248 1713172624 17.295 96 30 58 2 1727939616 5742528 9024464
20:21:54 8256 8192000000 10705436784 11118247936 1768561792 17.755 99 25 50 1 1781836048 5975136 7299120
20:22:09 4173 8192000000 10731608528 11143696384 1805940096 18.063 100 33 66 0 1823665264 8014880 9710288
20:22:22 8683 8192000000 10728671856 11147120640 1798244576 18.000 99 28 56 0 1812473168 5423232 8805360
20:22:37 9303 8192000000 10734728592 11157917696 1821204640 18.188 100 29 58 1 1835131984 5574432 8352912
20:22:57 7279 8192000000 10747999664 11170197504 1828388288 18.246 100 23 46 3 1845560896 10379648 6792960
20:23:11 12573 8192000000 10746270128 11174051840 1816026960 18.145 99 15 30 3 1826653632 5528288 5098384
20:23:30 6134 8192000000 10752024288 11172872192 1818436640 18.165 99 24 47 1 1830152032 5031024 6684368
20:23:45 9242 8192000000 10756075072 11182587904 1839606240 18.338 100 20 40 2 1851976896 6004896 6365760
20:24:03 48968 8192000000 10757874256 11183845376 1846601712 18.395 100 23 46 3 1859192704 5868112 6722880
20:25:06 15764 8192000000 10807829888 11199336448 1864494432 18.540 100 75 152 1 1891895904 4236640 23164832
20:25:28 9592 8192000000 10768351520 11191795712 1851142544 18.431 100 18 35 1 1861322128 4964336 5215248
20:25:46 11491 8192000000 10763597104 11195494400 1853680752 18.452 100 22 42 0 1865089440 5564816 5843872
20:26:06 11570 8192000000 10788687696 11209322496 1860881776 18.510 100 30 58 1 1879811600 11417056 7512768
20:26:26 11839 8192000000 10775392496 11203493888 1867072816 18.561 100 30 60 3 1881613632 5784848 8755968
20:26:45 8692 8192000000 10791165232 11216273408 1865585104 18.549 100 22 44 1 1882606608 10616640 6404864
20:27:02 10046 8192000000 10794256064 11217477632 1875524064 18.629 100 24 48 1 1887458896 5213216 6721616
20:27:20 6340 8192000000 10812382352 11231948800 1892180208 18.763 100 33 63 2 1906125584 5114640 8830736
20:27:35 4716 8192000000 10835750656 11251417088 1906435648 18.878 100 50 100 0 1928303104 8069504 13797952
20:27:47 6711 8192000000 10846442256 11262263296 1913480976 18.935 100 60 121 0 1940259568 9819872 16958720
20:28:01 10774 8192000000 10862181568 11272761344 1919442384 18.982 100 60 121 1 1948142960 11172768 17527808
20:28:18 36501 8192000000 10851449440 11275280384 1921928592 19.002 100 42 84 0 1941643504 8404688 11310224
20:29:07 55958 8192000000 10865907808 11298033664 1933867568 19.098 100 51 100 1 1959034368 10683072 14483728
20:30:11 13306 8192000000 10874488592 11302862848 1943617072 19.176 100 49 97 2 1971491568 13285488 14589008
20:30:34 9356 8192000000 10874885904 11309826048 1947452336 19.206 100 48 96 1 1975843744 13986416 14404992
20:30:52 10834 8192000000 10891459008 11316752384 1954209440 19.260 100 57 114 0 1985859936 14704400 16946096
20:31:09 10078 8192000000 10889582480 11321327616 1957130416 19.283 100 46 92 1 1986195024 14953360 14111248
20:31:27 15056 8192000000 10897889744 11327983616 1960457264 19.310 100 45 90 0 1989124480 15387472 13279744
20:31:53 19600 8192000000 10903969376 11335516160 1962973152 19.330 100 38 77 2 1988626528 14463072 11190304
20:32:21 21308 8192000000 10914895024 11345920000 1972634016 19.406 100 52 104 1 2003289536 15819536 14835984
20:32:54 15092 8192000000 10923861792 11354447872 1983107920 19.489 100 49 98 1 2013353584 15824064 14421600
20:33:17 6515 8192000000 10934739392 11359731712 1988184512 19.529 100 68 136 3 2027028288 18324528 20519248
20:33:35 11369 8192000000 10935244992 11363098624 1993091520 19.568 100 58 117 0 2030964720 20826560 17046640
20:33:58 20174 8192000000 10943904992 11375124480 1992364560 19.562 100 56 112 0 2032005792 22855824 16785408
20:34:29 13121 8192000000 10941256064 11374010368 1975548160 19.429 99 52 104 0 2021515376 30101232 15865984
20:34:52 16512 8192000000 10931481568 11373375488 1994417504 19.579 100 52 105 3 2034813520 24301008 16095008
20:35:18 7806 8192000000 10934479488 11371147264 1973025248 19.409 99 46 92 1 2008464576 21336384 14102944
20:35:34 4496 8192000000 10923213840 11350794240 1969756816 19.384 99 48 96 1 2006881184 22833552 14290816
20:35:47 10714 8192000000 10937761920 11364655104 1981404032 19.476 100 59 118 0 2028834416 29772304 17658080
20:36:05 13602 8192000000 10955239376 11374190592 1993676640 19.573 100 68 136 1 2042366176 27721200 20968336
20:36:26 10271 8192000000 10952221472 11376939008 1995753344 19.589 100 57 112 0 2037522128 25328480 16440304
20:36:53 14933 8192000000 10960221792 11388411904 2005381184 19.665 100 65 129 1 2051051008 25635648 20034176
20:37:19 8216 8192000000 10965247328 11392921600 2006969136 19.678 100 63 125 0 2052185760 26535664 18680960
20:37:36 7113 8192000000 10963902336 11394019328 2004681712 19.660 100 55 110 1 2047727136 26552096 16493328
20:37:52 5198 8192000000 10969160688 11391844352 2010784864 19.708 100 80 157 2 2065052320 29883472 24383984
20:38:05 4049 8192000000 10973038912 11397672960 2008377680 19.689 100 71 142 0 2061142544 30864992 21899872
20:38:20 5203 8192000000 10962077536 11389587456 2001943536 19.638 100 68 136 2 2052632592 29847744 20841312
20:38:34 5549 8192000000 10961126176 11385872384 1984163360 19.498 99 70 138 0 2036235264 31237184 20834720
20:38:49 3097 8192000000 10962058640 11387809792 1982079568 19.481 99 68 136 0 2034620960 31750752 20790640
20:39:02 4823 8192000000 10983963312 11398389760 2007488160 19.682 100 83 164 0 2064435648 32034640 24912848
20:39:13 2518 8192000000 10980438640 11391275008 2009423440 19.697 100 85 169 0 2066696720 31724816 25548464
20:39:24 3918 8192000000 10971486352 11395891200 2004140592 19.655 100 69 135 4 2057797872 32819312 20837968
20:39:34 1756 8192000000 10976601440 11393613824 2002897632 19.646 100 86 173 1 2062530224 33776144 25856448
20:39:43 5049 8192000000 10980989936 11404722176 2005027296 19.662 100 76 150 0 2063077808 35277264 22773248
20:39:57 3217 8192000000 10977968688 11396542464 2007631840 19.683 100 80 160 1 2067604960 35366304 24606816
20:40:12 11128 8192000000 10964079392 11390517248 1995085680 19.584 100 69 138 1 2052546368 36580944 20879744
20:40:35 2821 8192000000 10970487760 11388141568 1993733536 19.573 100 76 151 4 2052068416 36083088 22251792
20:40:46 4588 8192000000 10966696848 11396108288 1997460432 19.603 100 70 140 2 2055839968 36390976 21988560
20:40:58 3796 8192000000 10964035520 11396161536 2004321072 19.657 100 75 148 1 2058405264 31061232 23022960
20:41:09 3530 8192000000 10971890400 11396112384 2001530496 19.635 100 81 163 0 2058156464 32020448 24605520
20:41:20 2785 8192000000 10981240624 11397472256 2001361952 19.633 100 91 182 2 2060667376 31939296 27366128
20:41:29 1981 8192000000 10961137408 11371786240 1969932672 19.385 99 80 161 1 2027288960 32297168 25059120
20:41:39 2633 8192000000 10962065408 11381305344 1975640464 19.430 100 77 154 2 2033385968 34135856 23609648
20:41:49 4597 8192000000 10953544592 11371474944 1982000992 19.481 100 87 169 2 2041583600 34696368 24886240
20:42:01 7127 8192000000 10952033696 11375828992 1975950592 19.433 100 66 131 0 2032988656 36570096 20467968
20:42:16 1864 8192000000 10959554256 11369275392 1969500912 19.381 99 85 170 1 2033529888 36930576 27098400
20:42:24 8102 8192000000 10939756576 11370926080 1972585040 19.406 100 62 124 0 2030734432 39011232 19138160
20:42:39 4378 8192000000 10963381648 11381391360 1980036352 19.465 100 83 166 1 2042266000 36723968 25505680
20:42:50 3149 8192000000 10954964864 11374006272 1961666304 19.319 99 85 170 1 2025839984 38039296 26134384
20:43:01 1848 8192000000 10929802960 11352186880 1942591776 19.167 99 74 149 0 2003397312 38601760 22203776
20:43:09 3503 8192000000 10949685504 11361189888 1964115104 19.339 100 87 172 1 2029345648 38210880 27019664
20:43:20 2622 8192000000 10936466512 11349450752 1950686032 19.232 100 82 162 1 2015242832 39086624 25470176
20:43:30 2598 8192000000 10941901040 11348975616 1957801168 19.289 100 86 171 3 2021830800 37841184 26188448
20:43:42 2271 8192000000 10922217344 11346788352 1934330272 19.101 99 68 136 1 1992342624 36491056 21521296
20:43:52 2696 8192000000 10936856144 11349966848 1953376544 19.253 100 83 164 0 2016256496 37864800 25015152
20:44:04 2514 8192000000 10926155952 11337912320 1942244800 19.165 100 77 152 0 2006350096 39080560 25024736
20:44:14 2700 8192000000 10928542656 11337379840 1949001264 19.219 100 88 177 1 2010894272 34634736 27258272
20:44:25 5485 8192000000 10907199792 11334205440 1941061104 19.155 100 56 111 1 1993627728 35053504 17513120
20:44:44 11716 8192000000 10918717440 11349110784 1942323664 19.165 100 57 112 0 1998460112 38100432 18036016
20:45:03 14811 8192000000 10877644480 11316023296 1920298624 18.989 99 48 96 0 1968094704 32461392 15334688
20:45:31 15262 8192000000 10866088400 11317727232 1913995456 18.939 99 27 54 0 1949305088 26648032 8661600
20:45:54 16499 8192000000 10864957760 11300585472 1856590352 18.476 96 31 61 1 1889506848 23457152 9459344
20:46:18 1226 8192000000 10894512784 11301146624 1906905072 18.882 99 82 165 2 1954075248 22771568 24398608
20:46:27 1239 8192000000 10898038720 11310071808 1924942592 19.026 100 83 164 2 1975673616 25545440 25185584
20:46:38 4552 8192000000 10905595984 11325059072 1937456832 19.126 100 67 133 1 1984308864 27291520 19560512
20:46:49 2174 8192000000 10898734256 11314511872 1926881920 19.042 99 75 148 1 1977656288 28601200 22173168
20:47:04 7883 8192000000 10887090880 11322871808 1915886704 18.954 99 40 79 0 1957529360 29940256 11702400
20:47:24 23516 8192000000 10872881904 11319468032 1905742656 18.872 98 23 46 1 1944906528 31612960 7550912
20:48:00 15995 8192000000 10906034464 11335774208 1908107184 18.891 98 41 82 0 1949739056 28810448 12821424
20:48:22 4526 8192000000 10900058080 11335573504 1941718256 19.160 100 37 72 1 1982327488 29681312 10927920
20:48:44 9756 8192000000 10901534208 11339874304 1951375584 19.237 100 41 81 4 1994330944 30053488 12901872
20:49:10 17847 8192000000 10870283184 11306332160 1897223248 18.804 98 44 88 0 1932954256 21546832 14184176
20:49:43 13311 8192000000 10863136112 11308744704 1903947120 18.858 99 28 56 1 1936726672 23171664 9607888
20:50:08 29980 8192000000 10873430384 11319656448 1918281648 18.973 99 30 60 0 1954181648 26241120 9658880
20:50:46 14696 8192000000 10873919424 11327139840 1934086112 19.100 100 19 38 3 1962630288 22194032 6350144
20:51:13 21624 8192000000 10857624272 11316883456 1890575520 18.750 98 21 42 2 1919234864 21902192 6757152
20:51:48 38056 8192000000 10833887264 11286089728 1869102480 18.577 98 12 24 1 1896175904 22893408 4180016
20:52:32 25274 8192000000 10819575968 11282014208 1881296336 18.676 99 19 38 0 1899964192 12537952 6129904
20:53:03 45127 8192000000 10836281248 11283345408 1887932320 18.729 99 25 48 1 1905690128 10758608 6999200
20:53:59 37811 8192000000 10832355664 11275010048 1869526768 18.580 98 25 50 0 1884549680 7799680 7223232
20:54:44 65413 8192000000 10850964176 11284250624 1865104672 18.545 98 34 68 2 1887169280 12580096 9484512
20:55:56 57960 8192000000 10849496608 11296464896 1887931360 18.729 99 39 78 1 1918186864 17941616 12313888
20:57:00 5973 8192000000 10854538704 11288686592 1896184720 18.796 99 54 108 0 1927505632 15986176 15334736
20:57:16 45996 8192000000 10859117632 11317833728 1926259856 19.037 100 38 77 1 1955469712 18154352 11055504
20:58:09 88544 8192000000 10868501568 11333771264 1943473552 19.174 100 3 6 0 1953254240 8492400 1288288
20:59:44 217178 8192000000 10884895904 11354345472 1916011520 18.955 97 22 44 0 1933809424 10762992 7034912
21:03:29 102239 8192000000 10879464400 11338145792 1923245296 19.013 98 24 48 0 1938683584 8259792 7178496
21:05:25 43439 8192000000 10883756240 11346894848 1965328976 19.348 100 31 62 2 1985626816 11786880 8510960
21:06:31 43292 8192000000 10890974976 11360976896 1974520272 19.421 100 19 37 0 1987114096 7601744 4992080
21:07:23 1754 8192000000 10904048048 11365875712 1982175664 19.482 100 27 54 0 1996940656 7015488 7749504
21:07:31 31574 8192000000 10917955728 11374211072 1987297120 19.522 100 37 73 4 2005599664 7582320 10720224
21:08:19 22908 8192000000 10902876000 11373862912 1970464272 19.389 99 18 36 1 1987652896 11409904 5778720
21:08:48 55442 8192000000 10892576864 11364139008 1977949264 19.448 100 15 30 1 1991532368 8804624 4778480
21:10:28 77008 8192000000 10901420096 11386990592 1987724720 19.526 100 20 40 0 2009097328 15773264 5599344
21:11:51 59207 8192000000 10892591360 11354304512 1930620784 19.072 97 8 16 1 1941465680 8757424 2087472
21:12:58 29230 8192000000 10881138304 11348398080 1905821728 18.873 96 29 58 2 1922324480 8344896 8157856
21:13:34 40981 8192000000 10885323456 11363180544 1968812304 19.376 100 15 30 0 1981787120 8766656 4208160
21:14:36 22329 8192000000 10896319728 11357298688 1963398688 19.333 100 33 66 2 1985086304 11921472 9766144
21:15:05 22055 8192000000 10902368656 11358052352 1956969280 19.282 99 42 82 0 1977182896 9441392 10772224
21:15:36 56823 8192000000 10875924528 11351224320 1939423328 19.142 98 27 53 1 1957250592 10411872 7415392
21:16:43 24311 8192000000 10896017632 11350720512 1960620336 19.311 100 29 58 0 1976705584 7728848 8356400
21:17:16 20911 8192000000 10888896016 11341197312 1893227792 18.772 96 40 80 2 1913705744 9926784 10551168
21:17:48 21296 8192000000 10893343664 11349413888 1957358720 19.285 100 43 86 1 1981780288 12588560 11833008
21:18:16 44783 8192000000 10870749072 11327307776 1906833312 18.881 97 29 58 1 1925792736 10752720 8206704
21:19:09 77064 8192000000 10903749616 11353509888 1900759344 18.832 97 15 30 2 1913511136 8988544 3763248
21:20:33 51713 8192000000 10889901232 11344216064 1912093792 18.923 97 40 79 1 1939093344 16652304 10347248
21:21:31 50168 8192000000 10882335984 11343491072 1927288912 19.045 99 20 40 1 1947307696 14714016 5304768
21:22:39 69152 8192000000 10875340704 11340697600 1885366400 18.708 96 21 42 1 1905387440 14135328 5885712
21:23:59 57552 8192000000 10880285232 11329503232 1876766832 18.639 96 20 38 2 1897354048 15157104 5430112
21:25:05 120170 8192000000 10806519968 11272986624 1828166592 18.244 94 25 50 1 1851290928 15538688 7585648
21:27:13 54842 8192000000 10856350976 11307945984 1883458240 18.693 97 30 60 1 1907047888 14902512 8687136
21:28:14 25630 8192000000 10866387456 11325165568 1935714288 19.113 100 32 63 0 1961608432 17380096 8514048
21:28:56 78876 8192000000 10873863248 11345530880 1912730432 18.929 98 21 42 0 1939188336 20068480 6389424
21:30:35 33158 8192000000 10866886048 11355353088 1939128048 19.140 100 4 8 0 1957735680 17664400 943232
21:31:17 12475 8192000000 10867769168 11356213248 1942516448 19.167 100 3 6 0 1958342992 15348928 477616
21:31:47 54274 8192000000 10854614672 11311218688 1811076400 18.105 93 14 28 0 1820876928 6114560 3685968
21:32:48 54065 8192000000 10813296848 11268550656 1804233760 18.049 94 20 40 1 1818464320 8962272 5268288
21:33:55 41717 8192000000 10853109456 11314888704 1924385024 19.022 100 30 60 1 1943788272 10727232 8676016
21:34:46 56625 8192000000 10845337744 11303297024 1879713584 18.663 97 25 48 1 1894718240 8333200 6671456
21:35:51 28050 8192000000 10880358208 11310903296 1889548384 18.742 98 46 90 0 1911677008 8683648 13444976
21:36:56 80031 8192000000 10865737280 11333242880 1895947712 18.794 98 29 58 2 1922456912 18696144 7813056
21:38:22 79783 8192000000 10863716640 11319607296 1893050960 18.770 98 12 24 2 1911284752 14984192 3249600
21:39:48 47002 8192000000 10885385120 11342520320 1938862128 19.138 100 33 66 0 1962255696 13249264 10144304
21:40:47 122502 8192000000 10881581872 11356479488 1891998384 18.762 97 16 32 0 1912623264 16168784 4456096
21:43:03 112395 8192000000 10878131296 11353866240 1930650304 19.072 99 10 20 0 1949810144 16153248 3006592
21:45:02 44167 8192000000 10912508144 11364433920 1942098528 19.163 99 29 58 0 1959650544 9448240 8103776
21:45:58 54512 8192000000 10872954208 11344306176 1901214400 18.836 97 17 34 2 1921126768 15359152 4553216
21:48:10 36805 8192000000 10888461888 11333894144 1934670864 19.104 99 27 54 1 1955391104 11201984 9518256
21:49:10 50508 8192000000 10900297664 11352317952 1965471856 19.350 100 40 80 1 1987614176 10781376 11360944
21:50:23 77483 8192000000 10902846848 11373101056 1960855392 19.313 99 40 80 0 1981794912 9805904 11133616
21:53:18 43922 8192000000 10919162816 11377553408 1966938384 19.361 99 27 52 1 1987474608 12953104 7583120
21:54:08 90033 8192000000 10901430880 11373445120 1943069184 19.171 98 21 42 0 1967201712 17010304 7122224
21:55:55 72557 8192000000 10900883968 11376832512 1952822736 19.249 99 13 26 0 1976015520 19355536 3837248
21:57:16 54917 8192000000 10895673344 11355725824 1917605792 18.968 97 14 28 1 1929233776 7949312 3678672
21:58:19 43975 8192000000 10909719808 11372212224 1952255552 19.244 99 20 40 1 1970393568 12610400 5527616
21:59:15 73337 8192000000 10903848464 11375046656 1925306064 19.029 97 18 34 1 1944907568 14501120 5100384
22:00:39 71185 8192000000 10916771488 11376558080 1934773872 19.105 98 22 44 0 1953891136 12628000 6489264
22:01:58 18209 8192000000 10923609456 11367317504 1962634016 19.327 99 26 52 1 1983819264 13804080 7381168
22:02:24 43506 8192000000 10917532064 11382374400 1966004848 19.354 99 30 60 1 1983975248 9672144 8298256
22:03:16 27247 8192000000 10924999344 11376103424 1964321056 19.340 99 41 82 0 1986370128 10406864 11642208
22:04:01 45322 8192000000 10936524496 11399471104 1995976128 19.591 100 26 52 1 2015835440 12264928 7594384
22:04:54 83838 8192000000 10931764624 11406598144 1970360848 19.388 99 17 34 0 1991048912 15591808 5096256
22:06:29 133736 8192000000 10913621968 11399753728 1877826752 18.648 94 12 24 2 1903069872 21647584 3595536
22:08:49 79239 8192000000 10874912096 11324416000 1809909392 18.095 92 20 40 1 1829117744 13890288 5318064
22:10:21 52110 8192000000 10894304304 11350212608 1896661616 18.799 97 33 66 0 1926508640 20862560 8984464
22:11:27 111398 8192000000 10897750224 11350339584 1931038272 19.075 99 27 54 1 1951984912 13147792 7798848
22:13:30 64436 8192000000 10857818512 11308630016 1867358128 18.563 95 37 74 0 1887215728 8741504 11116096
22:14:41 42354 8192000000 10865926384 11331862528 1892927888 18.769 97 28 56 1 1909850336 9319472 7602976
22:16:08 44935 8192000000 10825207536 11291197440 1880357920 18.668 97 13 26 0 1898300704 14277232 3665552
22:17:02 49058 8192000000 10871848000 11334340608 1935727344 19.113 100 13 26 0 1952897904 13191008 3979552
22:18:01 64323 8192000000 10879056272 11339845632 1928773072 19.057 99 19 38 1 1948729408 14224384 5731952
22:19:19 91410 8192000000 10881521008 11355537408 1950446048 19.230 100 11 24 1 1972195024 18218112 3530864
22:21:05 65382 8192000000 10887654544 11355971584 1928807936 19.057 99 8 16 0 1941725104 10675344 2241824
22:22:22 92321 8192000000 10876683264 11344941056 1860881040 18.510 95 19 38 0 1877531888 10310576 6340272
22:24:01 35295 8192000000 10885483936 11328544768 1890256960 18.748 97 32 64 2 1909573696 10550768 8765968
22:24:54 58666 8192000000 10852129200 11313123328 1858835136 18.494 96 37 74 2 1881882064 12667136 10379792
22:26:01 75367 8192000000 9359887840 9641357312 491743968 5.662 26 3 6 0 497579440 5219984 615488

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 02-01-2021 22:28:22 to 02-01-2021 22:28:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 138 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-01-2021 22:28:54 to 02-01-2021 22:28:56.

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          247509
MON$OLDEST_ACTIVE               247947
MON$OLDEST_SNAPSHOT             247947
MON$NEXT_TRANSACTION            247947
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                       2007424
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:248: 
:249: mscs-test-161.budzdorov.ru    Sat Jan  2 22:27:21 2021
:250:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:251: 
--- end of diff output ---

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

02.01.21 22:28:57. 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-02 22:28:59 No severe PSQL-related problems occured
02.01.21 22:29:00. End of report.