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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 58e1ddde69c44dad93d327777e5becec
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-05-09 08:45
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 4793.92
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 17414016 kB
MemAvailable 31357956 kB
Buffers 0 kB
Cached 14250536 kB
SwapCached 2412 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-06-21 22:27:36
DTS_END                         2021-06-21 22:27:36.6820
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45736
TRN_ID                          237463
ATT_ID                          705
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: 9167.63 21546 1100115
customer order: creation 169.15 374 20298
customer order: refuse 14.35 327 1722
order to supplier: creation 44.85 1254 5382
order to supplier: removal 3.30 109463 396
invoice (draft): creation 45.23 3329 5427
invoice (draft): removal 51.62 767 6194
invoice accept: apply 41.29 16239 4955
invoice accept: cancel 47.04 744 5645
customer reserve: creation 3833.65 158 460038
customer reserve: removal 4618.73 62 554248
realization accept: apply 82.77 175 9932
realization accept: cancel 86.98 106 10438
payment from customer: creation 59.24 125 7109
payment from customer: removal 5.82 93 698
payment to supplier: creation 48.40 149 5808
payment to supplier: removal 3.46 71 415
service: total inventory turnovers 4.57 984 548
service: total monetary turnovers 6.31 42 757
service: aggregate perf. data 0.84 19160 101
service: refresh index statistics 0.03 277294 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-06-2021 22:29:11 to 21-06-2021 22:29:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6608
TEST_TIME 2 3826
TEST_TIME 3 3668
TEST_TIME 4 4325
TEST_TIME 5 4200
TEST_TIME 6 4276
TEST_TIME 7 3933
TEST_TIME 8 4008
TEST_TIME 9 4269
TEST_TIME 10 4648
TEST_TIME 11 4767
TEST_TIME 12 5079
TEST_TIME 13 5108
TEST_TIME 14 5388
TEST_TIME 15 5621
TEST_TIME 16 6173
TEST_TIME 17 6129
TEST_TIME 18 6254
TEST_TIME 19 6397
TEST_TIME 20 7063
TEST_TIME 21 7298
TEST_TIME 22 7367
TEST_TIME 23 7989
TEST_TIME 24 8339
TEST_TIME 25 8787
TEST_TIME 26 9243
TEST_TIME 27 10318
TEST_TIME 28 10403
TEST_TIME 29 10141
TEST_TIME 30 9912
TEST_TIME 31 9725
TEST_TIME 32 9650
TEST_TIME 33 9606
TEST_TIME 34 9550
TEST_TIME 35 9428
TEST_TIME 36 9347
TEST_TIME 37 9229
TEST_TIME 38 9176
TEST_TIME 39 9177
TEST_TIME 40 9142
TEST_TIME 41 9166
TEST_TIME 42 9086
TEST_TIME 43 9192
TEST_TIME 44 9272
TEST_TIME 45 9342
TEST_TIME 46 9316
TEST_TIME 47 9278
TEST_TIME 48 9303
TEST_TIME 49 9266
TEST_TIME 50 9343
TEST_TIME 51 9265
TEST_TIME 52 9275
TEST_TIME 53 9161
TEST_TIME 54 9102
TEST_TIME 55 8982
TEST_TIME 56 8964
TEST_TIME 57 8888
TEST_TIME 58 8959
TEST_TIME 59 8944
TEST_TIME 60 8844
TEST_TIME 61 8836
TEST_TIME 62 8757
TEST_TIME 63 8784
TEST_TIME 64 8864
TEST_TIME 65 8822
TEST_TIME 66 8889
TEST_TIME 67 8945
TEST_TIME 68 8966
TEST_TIME 69 8949
TEST_TIME 70 8963
TEST_TIME 71 9080
TEST_TIME 72 9064
TEST_TIME 73 9085
TEST_TIME 74 9126
TEST_TIME 75 9158
TEST_TIME 76 9188
TEST_TIME 77 9084
TEST_TIME 78 9026
TEST_TIME 79 8999
TEST_TIME 80 8963
TEST_TIME 81 8898
TEST_TIME 82 8873
TEST_TIME 83 8844
TEST_TIME 84 8855
TEST_TIME 85 8820
TEST_TIME 86 8832
TEST_TIME 87 8800
TEST_TIME 88 8885
TEST_TIME 89 8894
TEST_TIME 90 8919
TEST_TIME 91 8967
TEST_TIME 92 8970
TEST_TIME 93 9044
TEST_TIME 94 9039
TEST_TIME 95 9061
TEST_TIME 96 9224
TEST_TIME 97 9254
TEST_TIME 98 9199
TEST_TIME 99 9150
TEST_TIME 100 9127
TEST_TIME 101 9126
TEST_TIME 102 9079
TEST_TIME 103 9037
TEST_TIME 104 9015
TEST_TIME 105 8967
TEST_TIME 106 9021
TEST_TIME 107 8981
TEST_TIME 108 8987
TEST_TIME 109 9041
TEST_TIME 110 9047
TEST_TIME 111 9019
TEST_TIME 112 9011
TEST_TIME 113 9112
TEST_TIME 114 9087
TEST_TIME 115 9093
TEST_TIME 116 9191
TEST_TIME 117 9193
TEST_TIME 118 9207
TEST_TIME 119 9246
TEST_TIME 120 9173

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 21-06-2021 22:29:14 to 21-06-2021 22:29:18.

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 1524941 1524941 0 0.00 0 48023 6 0 0
doc_list_biud 1524940 1524940 0 0.00 0 46641 28 0 0
sp_add_invoice_to_stock 5069 4955 114 2.24 47 160282 16240 0 114
sp_cancel_adding_invoice 5645 5645 0 0.00 4 61432 745 0 0
sp_cancel_client_order 1722 1722 0 0.00 4 23030 328 0 0
sp_cancel_customer_reserve 554248 554248 0 0.00 1 43575 62 0 0
sp_cancel_pay_from_customer 698 698 0 0.00 3 8705 93 0 0
sp_cancel_pay_to_supplier 415 415 0 0.00 3 2773 72 0 0
sp_cancel_supplier_invoice 6201 6194 7 0.11 2 15960 768 0 7
sp_cancel_supplier_order 396 396 0 0.00 9 1221231 109464 0 0
sp_cancel_write_off 10438 10438 0 0.00 1 13260 106 0 0
sp_client_order 20298 20298 0 0.00 3 53090 374 0 0
sp_customer_reserve 460038 460038 0 0.00 0 86175 158 0 0
sp_fill_shopping_cart 31102 31102 0 0.00 1 22174 41 0 0
sp_fill_shopping_cart_clo_res 460028 460028 0 0.00 0 18312 14 0 0
sp_get_clo_for_invoice 4945 4945 0 0.00 0 29467 342 0 0
sp_kill_cost_storno 17196 17196 0 0.00 0 6802 57 0 0
sp_kill_qstorno_ret_qs2qd 1125524 1125524 0 0.00 0 36212 33 0 0
sp_kill_qty_storno 593519 593519 0 0.00 0 46640 71 0 0
sp_lock_selected_doc 20534 20534 0 0.00 0 5662 4 0 0
sp_make_cost_storno 27793 27793 0 0.00 0 20462 63 0 0
sp_multiply_rows_for_pdistr 27793 27793 0 0.00 0 6631 28 0 0
sp_multiply_rows_for_qdistr 20298 20298 0 0.00 0 49626 170 0 0
sp_pay_from_customer 7109 7109 0 0.00 4 14363 126 0 0
sp_pay_to_supplier 5808 5808 0 0.00 5 14370 149 0 0
sp_payment_common 12917 12917 0 0.00 1 10763 33 0 0
sp_qd_handle_on_cancel_clo 1722 1722 0 0.00 0 23022 299 0 0
sp_qd_handle_on_invoice_upd_sts 10589 10589 0 0.00 0 46639 321 0 0
sp_qd_handle_on_reserve_upd_sts 9932 9932 0 0.00 0 15625 52 0 0
sp_reserve_write_off 9932 9932 0 0.00 6 18230 176 0 0
sp_supplier_invoice 5427 5427 0 0.00 7 82828 3329 0 0
sp_supplier_order 5382 5382 0 0.00 5 49717 1254 0 0
srv_aggregate_perf_data 101 101 0 0.00 2815 277541 19161 0 0
srv_fill_mon_cache_memory 150 150 0 0.00 1133 147566 35652 0 0
srv_find_qd_qs_mism 1052222 1052222 0 0.00 0 48022 5 0 0
srv_make_invnt_saldo 548 548 0 0.00 45 30276 984 0 0
srv_make_money_saldo 757 757 0 0.00 1 8050 43 0 0
srv_recalc_idx_stat 4 4 0 0.00 104881 574980 277294 0 0
t$perf-abend:sp_add_invoice_to_stock 114 114 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4956 4956 0 0.00 0 34850 169 0 0
t$perf-norm:sp_cancel_adding_invoice 404 404 0 0.00 1 5076 90 0 0
t$perf-norm:sp_cancel_client_order 1722 1722 0 0.00 0 4585 11 0 0
t$perf-norm:sp_cancel_customer_reserve 638 638 0 0.00 0 2502 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 698 698 0 0.00 0 1094 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 415 415 0 0.00 0 1231 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 349 349 0 0.00 0 3847 24 0 0
t$perf-norm:sp_cancel_supplier_order 396 396 0 0.00 0 16367 1538 0 0
t$perf-norm:sp_cancel_write_off 1036 1036 0 0.00 0 7362 29 0 0
t$perf-norm:sp_client_order 20299 20299 0 0.00 0 18777 20 0 0
t$perf-norm:sp_customer_reserve 999 999 0 0.00 0 4594 11 0 0
t$perf-norm:sp_pay_from_customer 7109 7109 0 0.00 0 5663 13 0 0
t$perf-norm:sp_pay_to_supplier 5808 5808 0 0.00 0 13306 14 0 0
t$perf-norm:sp_reserve_write_off 9932 9932 0 0.00 0 21783 15 0 0
t$perf-norm:sp_supplier_invoice 5427 5427 0 0.00 0 9950 16 0 0
t$perf-norm:sp_supplier_order 5382 5382 0 0.00 0 7302 16 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 198 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 150 150 0 0.00 0 778 7 0 0
t$perf-norm:srv_make_invnt_saldo 548 548 0 0.00 0 881 24 0 0
t$perf-norm:srv_make_money_saldo 757 757 0 0.00 0 2820 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10116 9888 228 2.25 0 5855 19 0 228
v_all_customers 37176 37176 0 0.00 0 121 1 0 0
v_all_suppliers 29928 29928 0 0.00 0 14 1 0 0
v_all_wares 40596 40596 0 0.00 0 99 1 0 0
v_cancel_adding_invoice 808 808 0 0.00 0 2180 12 0 0
v_cancel_client_order 3444 3444 0 0.00 0 3253 7 0 0
v_cancel_customer_prepayment 1396 1396 0 0.00 0 2458 8 0 0
v_cancel_customer_reserve 1276 1276 0 0.00 0 5682 11 0 0
v_cancel_payment_to_supplier 830 830 0 0.00 0 374 2 0 0
v_cancel_supplier_invoice 712 698 14 1.96 0 2855 25 0 14
v_cancel_supplier_order 792 792 0 0.00 0 5858 22 0 0
v_cancel_write_off 2072 2072 0 0.00 0 2993 17 0 0
v_max_id_clo_ord 5382 5382 0 0.00 0 344 1 0 0
v_max_id_clo_res 999 999 0 0.00 0 3799 21 0 0
v_max_id_ord_sup 5422 5422 0 0.00 0 5411 4 0 0
v_max_non_paid_invoice 1648 1648 0 0.00 0 805 3 0 0
v_max_non_paid_realizn 3700 3700 0 0.00 0 4284 4 0 0
v_min_id_clo_ord 5382 5382 0 0.00 0 3048 6 0 0
v_min_id_clo_res 999 999 0 0.00 0 6975 17 0 0
v_min_id_ord_sup 5422 5422 0 0.00 0 4837 4 0 0
v_min_non_paid_invoice 5808 5808 0 0.00 0 6793 28 0 0
v_min_non_paid_realizn 7109 7109 0 0.00 0 5659 20 0 0
v_our_firm 10238 10238 0 0.00 0 18 1 0 0
v_reserve_write_off 19864 19864 0 0.00 0 8443 8 0 0
x_lock_depdocs_on_canc_invoice 11490 11490 0 0.00 0 16713 107 0 0
x_lock_depdocs_on_canc_sup_ord 396 396 0 0.00 0 10225 387 0 0
x_make_qstorno_1000_1200 5382 5382 0 0.00 1 49701 1172 0 0
x_make_qstorno_1200_2000 5427 5427 0 0.00 4 82813 3178 0 0
x_make_qstorno_2100_3300 460038 460038 0 0.00 0 84257 142 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-06-2021 22:29:19 to 21-06-2021 22:29:23.

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:39 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
19:57:46 14087 8192000000 10229673984 10535620608 881315968 9.713 67 54 109 0 901379200 2555104 17508128
19:58:10 33292 8192000000 10359313360 10677788672 1397071248 14.569 100 81 162 0 1428384736 5085568 26227920
19:58:54 23355 8192000000 10398574800 10721239040 1440170160 14.951 100 90 179 1 1476539744 6959344 29410240
19:59:29 23896 8192000000 10418452192 10747346944 1463817360 15.159 100 90 180 0 1501583008 8114048 29651600
20:00:05 17865 8192000000 10437635296 10765901824 1489074528 15.381 100 87 174 0 1526477440 8990800 28412112
20:00:32 31180 8192000000 10460908864 10796785664 1506583888 15.534 100 90 180 1 1545051872 9665840 28802144
20:01:13 18725 8192000000 10477970016 10818015232 1529039584 15.729 100 90 180 1 1567933712 10357472 28536656
20:01:44 17866 8192000000 10500759728 10844798976 1549121216 15.902 100 84 168 0 1590646768 15286608 26238944
20:02:11 15752 8192000000 10508945360 10858967040 1569832368 16.081 100 81 162 2 1606603632 11181616 25589648
20:02:37 13228 8192000000 10535214288 10889781248 1591897808 16.270 100 78 156 0 1626567152 11018976 23650368
20:02:57 12977 8192000000 10555671680 10907508736 1611189488 16.435 100 82 164 0 1647748928 11802128 24757312
20:03:20 13264 8192000000 10570513056 10928947200 1630874592 16.602 100 78 156 2 1665820128 11457920 23487616
20:03:43 9248 8192000000 10595121888 10959433728 1650398048 16.768 100 82 164 2 1687522352 12252688 24871616
20:04:01 10532 8192000000 10610425712 10977882112 1673987856 16.967 100 76 152 0 1708495520 12491632 22016032
20:04:19 10736 8192000000 10635832080 11000418304 1687051392 17.077 100 87 174 1 1725252032 12642144 25558496
20:04:37 11461 8192000000 10639687568 11006353408 1700625200 17.190 100 81 162 0 1736743024 12717408 23400416
20:04:57 8103 8192000000 10647536224 11021324288 1710930128 17.277 100 76 152 0 1744885984 12562656 21393200
20:05:13 6459 8192000000 10670504336 11044798464 1727862240 17.418 100 71 142 1 1760085296 11888672 20334384
20:05:26 6152 8192000000 10686847280 11062284288 1743356816 17.546 100 80 160 1 1778783488 12710464 22716208
20:05:40 5801 8192000000 10693517376 11071705088 1755650384 17.648 100 76 150 1 1789253616 12322816 21280416
20:05:52 4896 8192000000 10706301904 11078975488 1767961936 17.750 100 92 185 0 1806915808 13515200 25438672
20:06:04 4540 8192000000 10712142880 11088932864 1769623840 17.764 100 84 167 0 1807747872 14804128 23319904
20:06:16 4415 8192000000 10719199808 11098902528 1783274896 17.876 100 86 172 1 1821792672 14228576 24289200
20:06:26 3493 8192000000 10725465296 11109253120 1790439040 17.935 100 81 161 1 1825957712 12479248 23039424
20:06:36 2966 8192000000 10730619920 11113680896 1795262144 17.975 100 82 166 3 1831129104 12698880 23168080
20:06:47 2301 8192000000 10743752512 11122597888 1800920704 18.021 100 91 176 1 1839185328 12412912 25851712
20:06:56 3251 8192000000 10747325552 11127259136 1810308320 18.098 100 89 179 2 1848812960 13416704 25087936
20:07:06 3996 8192000000 10749257392 11132837888 1810014160 18.096 100 86 171 3 1846386944 13223312 23149472
20:07:18 4237 8192000000 10759664160 11142598656 1818074256 18.162 100 82 165 1 1854842688 14210048 22558384
20:07:29 2788 8192000000 10775578336 11159859200 1833514288 18.288 100 93 184 1 1873169808 13207584 26447936
20:07:38 2491 8192000000 10778252752 11168849920 1838414448 18.328 100 90 180 1 1878197376 14162160 25620768
20:07:47 2710 8192000000 10792806880 11176239104 1845215968 18.383 100 91 182 2 1884507968 14269168 25022832
20:07:57 2428 8192000000 10794422352 11179864064 1848062016 18.406 100 94 188 2 1888984976 14648976 26273984
20:08:05 2235 8192000000 10792922416 11182641152 1853652944 18.452 100 92 183 1 1893206160 13387168 26166048
20:08:14 2552 8192000000 10807609344 11192975360 1859479168 18.499 100 94 186 1 1898547872 12710640 26358064
20:08:23 2554 8192000000 10804299488 11191713792 1859045776 18.496 100 92 184 2 1898515632 14279456 25190400
20:08:32 2802 8192000000 10813070960 11200581632 1864615184 18.541 100 90 180 2 1903020560 13438544 24966832
20:08:41 2197 8192000000 10812410032 11199238144 1867443696 18.564 100 93 182 1 1907601072 14009648 26147728
20:08:50 2325 8192000000 10814512080 11202301952 1869288320 18.579 100 86 172 0 1906876880 12951520 24637040
20:08:59 2423 8192000000 10821699136 11209408512 1873776464 18.615 100 82 160 2 1909761264 13114352 22870448
20:09:08 2598 8192000000 10824705792 11212943360 1878436720 18.652 100 92 184 0 1917519664 12803856 26279088
20:09:17 1264 8192000000 10822271312 11211448320 1879210384 18.659 100 91 179 0 1915752288 11456576 25085328
20:09:25 2234 8192000000 10814464496 11212738560 1879677696 18.663 100 86 172 1 1917078896 13391472 24009728
20:09:33 17085 8192000000 10816383200 11213586432 1876984016 18.641 100 72 143 1 1909256832 12599280 19673536
20:10:10 1798 8192000000 10811402096 11216187392 1882225904 18.683 100 77 154 0 1914872848 10562816 22084128
20:10:18 1476 8192000000 10836098016 11229200384 1891787392 18.760 100 95 191 1 1931363248 12291408 27284448
20:10:27 4256 8192000000 10829917184 11228209152 1890482912 18.750 100 78 158 0 1924979024 12410544 22085568
20:10:37 4594 8192000000 10797455792 11219066880 1883048064 18.690 100 42 83 0 1905624080 10796640 11779376
20:10:48 5675 8192000000 10792354880 11216224256 1883431440 18.693 100 32 64 1 1900725152 7998736 9294976
20:11:00 2547 8192000000 10806718160 11219030016 1885758448 18.712 100 45 90 0 1905794032 7838896 12196688
20:11:09 6302 8192000000 10793652464 11212926976 1880509104 18.669 100 28 55 2 1894650144 6652368 7488672
20:11:22 7427 8192000000 10785310048 11215458304 1880467408 18.669 100 24 48 2 1895015456 7385920 7162128
20:11:36 5375 8192000000 10801737184 11221622784 1881776240 18.679 100 32 64 0 1898007856 6379712 9851904
20:11:51 6780 8192000000 10799734704 11220058112 1881419648 18.677 100 22 44 1 1893534512 6443792 5671072
20:12:08 1192 8192000000 10811535760 11226402816 1888152016 18.731 100 54 110 1 1911171040 7024976 15994048
20:12:16 5250 8192000000 10805580064 11225047040 1885961600 18.713 100 35 70 0 1903966096 7869584 10134912
20:12:28 3824 8192000000 10799112512 11224838144 1885008080 18.706 100 16 32 1 1895972256 5649216 5314960
20:12:38 6836 8192000000 10803707536 11227672576 1887590992 18.726 100 29 58 3 1906999312 11496672 7911648
20:12:51 5204 8192000000 10809741856 11232456704 1889083744 18.738 100 30 60 0 1908432528 10589296 8759488
20:13:09 9882 8192000000 10795846592 11225427968 1887663792 18.727 100 15 29 1 1898193104 5972384 4556928
20:13:29 7010 8192000000 10794880016 11230076928 1893013728 18.770 100 24 44 1 1905592976 6457184 6122064
20:13:42 16564 8192000000 10807531872 11235692544 1895784128 18.792 100 24 48 1 1909058864 6292048 6982688
20:14:05 64525 8192000000 10806950432 11242291200 1896624864 18.799 100 30 58 2 1910316048 5073328 8617856
20:15:17 12400 8192000000 10809254192 11245162496 1896786240 18.800 100 21 42 0 1909113328 6404992 5922096
20:15:37 5859 8192000000 10818462896 11250081792 1901075328 18.835 100 33 67 0 1918218864 7991488 9152048
20:15:49 4600 8192000000 10828895472 11252678656 1904900656 18.866 100 48 94 1 1926923232 8659904 13362672
20:16:00 4814 8192000000 10826907392 11251322880 1897080480 18.803 100 35 70 2 1914824672 7280544 10463648
20:16:14 4837 8192000000 10818449472 11250880512 1906599264 18.879 100 39 77 0 1924416464 6791024 11026176
20:16:25 3658 8192000000 10820199952 11246530560 1883160784 18.691 99 34 67 3 1899575056 6859056 9555216
20:16:35 3240 8192000000 10826371392 11251671040 1898900624 18.817 100 41 77 2 1917172912 6994784 11277504
20:16:48 5384 8192000000 10812626592 11250024448 1900474352 18.830 100 26 53 2 1914202384 6199424 7528608
20:17:00 5740 8192000000 10827740384 11256340480 1907043952 18.883 100 41 82 2 1926591632 8018000 11529680
20:17:14 11040 8192000000 10811671488 11244478464 1896958928 18.802 100 28 57 1 1912366336 6803936 8603472
20:17:32 11683 8192000000 10807067168 11239272448 1864471248 18.540 98 17 34 1 1875810368 5901712 5437408
20:17:53 6586 8192000000 10802779920 11239514112 1855479888 18.467 98 20 40 3 1870902432 10320160 5102384
20:18:05 6969 8192000000 10789003088 11217260544 1837259824 18.318 97 26 51 2 1850038976 5961984 6817168
20:18:18 8978 8192000000 10781850272 11213373440 1827833056 18.242 97 25 51 1 1840910192 5893920 7183216
20:18:37 9565 8192000000 10745828352 11166638080 1764171728 17.719 95 17 35 0 1774397280 4621296 5604256
20:18:53 58747 8192000000 10775263584 11174604800 1803723968 18.044 97 50 100 3 1825512752 6215184 15573600
20:19:58 5235 8192000000 10712796048 11133026304 1754363232 17.638 97 31 62 4 1769675664 6838384 8474048
20:20:13 7991 8192000000 10686710992 11098935296 1712713232 17.291 95 33 67 1 1728966368 6495600 9757536
20:20:29 2371 8192000000 10720879648 11135541248 1787416432 17.911 99 37 75 1 1805953488 8031664 10505392
20:20:39 7168 8192000000 10747310784 11170791424 1813038592 18.121 99 37 74 1 1830669568 6736272 10894704
20:20:53 5570 8192000000 10743268912 11161333760 1814965200 18.137 99 43 85 0 1835037872 7369392 12703280
20:21:07 7931 8192000000 10710545680 11126935552 1783385104 17.877 98 32 64 1 1799268544 6501328 9382112
20:21:21 5768 8192000000 10744967792 11157671936 1818041680 18.162 100 20 41 3 1829158528 5606352 5510496
20:21:34 6214 8192000000 10736985584 11158114304 1790953344 17.940 98 38 76 1 1808691024 6720144 11017536
20:21:50 6259 8192000000 10727344112 11139235840 1732436112 17.456 95 27 54 0 1745884768 5903024 7545632
20:22:05 6278 8192000000 10702661376 11115839488 1755340048 17.646 97 29 58 2 1769891776 5669120 8882608
20:22:23 6312 8192000000 10723727536 11139219456 1790639616 17.937 99 24 48 1 1803095792 5601008 6855168
20:22:35 5193 8192000000 10728911216 11142414336 1791490992 17.944 99 31 63 2 1805377216 5045824 8840400
20:22:48 12930 8192000000 10728532576 11152375808 1816469152 18.149 100 23 46 0 1828822720 5126832 7226736
20:23:07 5647 8192000000 10712727904 11139366912 1782595200 17.871 98 27 53 0 1797239920 7122272 7522448
20:23:19 8776 8192000000 10732536384 11152732160 1817428528 18.157 100 33 62 2 1831983392 5258080 9296784
20:23:34 74179 8192000000 10750971376 11172941824 1800672192 18.019 98 27 52 1 1813732144 4697584 8362368
20:24:58 6183 8192000000 10768689664 11180883968 1830739936 18.265 99 46 91 3 1849574592 5679472 13155184
20:25:13 9273 8192000000 10763045312 11190894592 1851480256 18.434 100 30 60 0 1866316592 6849888 7986448
20:25:30 7996 8192000000 10786130256 11203637248 1856321488 18.473 100 45 88 0 1875806688 7225552 12259648
20:25:46 4484 8192000000 10795967744 11207274496 1861909232 18.519 100 50 99 0 1883424544 6947952 14567360
20:25:57 6080 8192000000 10780711536 11201429504 1861303152 18.514 100 29 59 1 1876369024 6342336 8723536
20:26:11 8669 8192000000 10784116064 11206979584 1865788928 18.550 100 26 52 0 1878605648 5343600 7473120
20:26:26 9631 8192000000 10788809152 11210280960 1864944224 18.543 100 21 42 1 1876860560 5358832 6557504
20:26:42 9719 8192000000 10789045520 11209428992 1863974848 18.535 100 15 30 0 1873976000 5108656 4892496
20:27:00 6953 8192000000 10803425648 11226415104 1876500160 18.637 100 30 59 1 1890827104 5644240 8682704
20:27:15 7773 8192000000 10808811152 11232165888 1888438448 18.733 100 23 44 1 1899650112 4992560 6219104
20:27:31 9613 8192000000 10813568096 11240112128 1897114928 18.803 100 24 48 2 1908905424 5436992 6353504
20:27:50 11270 8192000000 10838827168 11258966016 1911863712 18.922 100 48 96 1 1933088992 6390512 14834768
20:28:08 5244 8192000000 10862303120 11269939200 1917935232 18.970 100 58 116 1 1941285040 7310448 16039360
20:28:20 116423 8192000000 10849133088 11287597056 1921103632 18.996 100 57 114 1 1946718368 8641360 16973376
20:31:20 11610 8192000000 10876648992 11315310592 1954440640 19.262 100 44 88 1 1979126128 11830416 12855072
20:31:53 19920 8192000000 10893777600 11326541824 1961731440 19.320 100 34 66 0 1985417856 13019248 10667168
20:32:22 15636 8192000000 10909553184 11339735040 1967270272 19.364 100 43 86 1 1999189216 18691056 13227888
20:32:44 16538 8192000000 10897277888 11339067392 1969837712 19.384 100 38 76 0 1997086944 15504624 11744608
20:33:19 24121 8192000000 10918706096 11353305088 1980121376 19.466 100 38 76 1 2008932768 17096160 11715232
20:33:51 32062 8192000000 10915082496 11353993216 1964478432 19.342 99 45 88 2 1994340128 16553008 13308688
20:34:42 25404 8192000000 10953218912 11373535232 1989114400 19.537 100 44 88 1 2026606848 24536800 12955648
20:35:18 11696 8192000000 10945917056 11377713152 1996568608 19.596 100 47 95 0 2036453696 25683504 14201584
20:35:38 12363 8192000000 10950998064 11386478592 2004236016 19.656 100 59 117 1 2049667360 27163952 18267392
20:35:59 8916 8192000000 10957489728 11391524864 2007521776 19.682 100 50 96 3 2049736720 27480192 14734752
20:36:15 5738 8192000000 10966580368 11394727936 1996207232 19.593 99 65 126 1 2044242704 28863840 19171632
20:36:31 14185 8192000000 10969837504 11398139904 2008399616 19.689 100 58 116 0 2055682960 28888912 18394432
20:36:56 15121 8192000000 10964254240 11401207808 2007785408 19.684 100 48 96 2 2052229024 29163344 15280272
20:37:24 18237 8192000000 10973393296 11414052864 2015736880 19.747 100 58 116 0 2065568160 32641472 17189808
20:37:51 6769 8192000000 10983158000 11415556096 2018063200 19.765 100 53 105 3 2066386144 31942368 16380576
20:38:13 12838 8192000000 10962916832 11406073856 2010412976 19.705 100 50 100 0 2058000832 31813808 15774048
20:38:34 11372 8192000000 10975998272 11411353600 2015254400 19.743 100 57 113 0 2062822336 29854256 17713680
20:38:53 13802 8192000000 10981197120 11417219072 2019094688 19.773 100 57 113 1 2068046416 31416624 17535104
20:39:18 9879 8192000000 10980170896 11419865088 2025201152 19.821 100 61 124 1 2074728016 30952576 18574288
20:39:41 7608 8192000000 10967787408 11395854336 1991427104 19.555 98 55 110 2 2039751008 31616304 16707600
20:39:55 3992 8192000000 10988928768 11417989120 2023116416 19.805 100 63 123 2 2072901792 31017664 18767712
20:40:07 10076 8192000000 10977935280 11412504576 2002544464 19.643 99 61 121 1 2053025264 31883680 18597120
20:40:24 4858 8192000000 10999349760 11425914880 2026951184 19.835 100 72 142 1 2082631264 33042800 22637280
20:40:39 2223 8192000000 11006121392 11422769152 2029182128 19.852 100 80 158 0 2087223152 33897488 24143536
20:40:48 3649 8192000000 11009589408 11432845312 2031056944 19.867 100 82 164 0 2091564784 35521840 24986000
20:41:00 1837 8192000000 11013474656 11438678016 2036740752 19.911 100 86 173 1 2099053344 36438928 25873664
20:41:08 3864 8192000000 11017432624 11439919104 2037727552 19.919 100 91 182 0 2103928176 38725584 27475040
20:41:21 4868 8192000000 11019087344 11441967104 2037730000 19.919 100 74 148 0 2098889088 39161680 21997408
20:41:34 3312 8192000000 11008198512 11423551488 2021071360 19.789 99 88 177 2 2087355472 39584752 26699360
20:41:46 9472 8192000000 11003034624 11437981696 2032404944 19.877 100 68 136 1 2093798880 40557088 20836848
20:42:06 3940 8192000000 10993087984 11424325632 2014397232 19.736 99 67 134 1 2076323360 41604976 20321152
20:42:19 2884 8192000000 10991731680 11419578368 2017520544 19.761 100 62 124 0 2076510912 38541840 20448528
20:42:30 5736 8192000000 11000606144 11430744064 2018903376 19.772 100 74 146 2 2086236784 44465440 22867968
20:42:43 5177 8192000000 10994456048 11424272384 2020572704 19.785 100 76 153 0 2086086224 41082864 24430656
20:43:00 4392 8192000000 11011355936 11438108672 2030298000 19.861 100 71 139 0 2096521280 45022048 21201232
20:43:11 3450 8192000000 11007801952 11431424000 2009778912 19.700 99 76 152 0 2079333040 45655344 23898784
20:43:23 5105 8192000000 10997058496 11425722368 2017308048 19.759 100 67 132 1 2081602848 43614192 20680608
20:43:39 4071 8192000000 10989398464 11417718784 1998786496 19.613 99 67 133 4 2063727296 44463648 20477152
20:43:49 2822 8192000000 11013532880 11430330368 2020223952 19.782 100 83 166 2 2089343280 43766480 25352848
20:43:59 1133 8192000000 11013307808 11432034304 2027276528 19.837 100 87 174 1 2096161056 40954512 27930016
20:44:07 8076 8192000000 11007451072 11430887424 2021464032 19.792 100 67 134 1 2086341968 43939184 20938752
20:44:23 4510 8192000000 11005051184 11427405824 2019384656 19.775 100 78 156 1 2087801472 44718960 23697856
20:44:35 7537 8192000000 11006810992 11431477248 2019679744 19.778 100 69 138 0 2090854928 49914832 21260352
20:44:59 4462 8192000000 11009709184 11426254848 1989590816 19.541 98 85 168 2 2067441504 51781440 26069248
20:45:15 5256 8192000000 10991880864 11411939328 1995797200 19.590 99 77 152 0 2073037920 53237376 24003344
20:45:28 1227 8192000000 11016444640 11427139584 2001517136 19.635 99 93 187 1 2086921472 56602928 28801408
20:45:35 3203 8192000000 11012680544 11428982784 1997767280 19.605 99 87 171 1 2083579840 58291600 27520960
20:45:46 3102 8192000000 11014136992 11430449152 1993297488 19.570 99 81 162 3 2079323872 60538208 25488176
20:45:56 1663 8192000000 10973105728 11382554624 1952681984 19.248 98 84 163 0 2039246336 59906384 26657968
20:46:06 3891 8192000000 10977475152 11397738496 1980208784 19.466 100 82 164 3 2067626352 61045712 26371856
20:46:23 3916 8192000000 10986581056 11397095424 1975786352 19.431 100 82 162 1 2062046576 60315696 25944528
20:46:38 2994 8192000000 10955873312 11368239104 1949669248 19.224 99 80 160 1 2034883536 59530240 25684048
20:46:52 4272 8192000000 10986699760 11400773632 1974686512 19.423 100 83 167 1 2062387488 61429120 26271856
20:47:11 3170 8192000000 11003010384 11418972160 1990754064 19.550 100 91 182 1 2084426112 64414528 29257520
20:47:21 2148 8192000000 11003338320 11416481792 1996087328 19.592 100 95 189 3 2085473904 59639792 29746784
20:47:30 3060 8192000000 10979504272 11393933312 1974162016 19.418 100 85 170 0 2061349696 60171200 27016480
20:47:44 2834 8192000000 10972295600 11398934528 1972924528 19.409 100 66 132 2 2057887824 63131248 21832048
20:47:58 12495 8192000000 10934076128 11376742400 1954597600 19.263 99 44 88 1 2027178320 57660240 14920480
20:48:21 13838 8192000000 10942461424 11373916160 1954242016 19.260 99 36 71 0 2017407456 50775088 12390352
20:48:43 14995 8192000000 10947272608 11385901056 1964321008 19.340 100 37 74 0 2032522400 55340096 12861296
20:49:12 5304 8192000000 10956561216 11392729088 1955082080 19.267 99 44 84 2 2026292560 56205696 15004784
20:49:26 12780 8192000000 10956291568 11398369280 1971008848 19.393 100 44 87 0 2044565856 58371776 15185232
20:49:50 13683 8192000000 10976552160 11414970368 1982202144 19.482 100 40 78 1 2057106640 61744144 13160352
20:50:13 10884 8192000000 10961406864 11404439552 1968373808 19.373 99 36 72 2 2032782400 52539440 11869152
20:50:32 19555 8192000000 10954020400 11405312000 1981157344 19.474 100 36 72 1 2043694432 50473616 12063472
20:50:59 21359 8192000000 10943821392 11393622016 1965497200 19.350 100 33 66 1 2031437168 54367872 11572096
20:51:30 34048 8192000000 10936107248 11392061440 1962230944 19.324 100 24 48 1 2018739392 47954992 8553456
20:52:13 31736 8192000000 10916556080 11374886912 1938816528 19.137 99 21 42 2 1994099712 47502016 7781168
20:52:52 28391 8192000000 10893634672 11353489408 1889458480 18.741 97 22 44 3 1945350800 47530528 8361792
20:53:27 25269 8192000000 10912656672 11368685568 1929268064 19.061 100 25 50 0 1989188768 50974176 8946528
20:54:07 49197 8192000000 10882125536 11359727616 1924074800 19.019 99 18 36 2 1966746688 36252560 6419328
20:55:02 54048 8192000000 10890880880 11335327744 1902469008 18.846 98 17 34 0 1921234416 14054160 4711248
20:56:06 73660 8192000000 10875753184 11326251008 1923717648 19.017 99 14 27 1 1941667296 14474112 3475536
20:57:29 42257 8192000000 10859385568 11316178944 1891663232 18.759 97 18 36 2 1906519440 9755920 5100288
20:58:22 51075 8192000000 10867005680 11319988224 1930679024 19.072 100 23 46 0 1947383248 10312320 6391904
20:59:21 45022 8192000000 10861936416 11332358144 1939778240 19.145 100 7 14 0 1954226384 12701200 1746944
21:00:12 24424 8192000000 10868578768 11338436608 1948253376 19.213 100 10 20 0 1962369008 11449024 2666608
21:00:42 18522 8192000000 10873153680 11345653760 1951464784 19.238 100 10 21 1 1966350752 12225456 2660512
21:01:37 63854 8192000000 10872642896 11332571136 1923762080 19.017 99 12 24 0 1936201232 9262432 3176720
21:02:50 42903 8192000000 10875725952 11337158656 1946242768 19.197 100 8 16 0 1958251072 9965392 2042912
21:04:24 77575 8192000000 10878474256 11333505024 1914191664 18.940 98 26 52 0 1935044256 12981968 7870624
21:05:49 32196 8192000000 10861391808 11337175040 1921417488 18.998 99 9 18 0 1933637856 9866944 2353424
21:06:38 59594 8192000000 10880203952 11329490944 1891469200 18.758 97 33 65 0 1908052848 7270608 9313040
21:08:23 38177 8192000000 10896804656 11343597568 1937693328 19.128 99 35 67 0 1954065888 6889264 9483296
21:09:08 36308 8192000000 10877553888 11341762560 1941758208 19.161 99 34 68 1 1963667168 11939760 9969200
21:09:51 71108 8192000000 10901081952 11376308224 1938188224 19.132 99 20 41 1 1955172704 11942656 5041824
21:11:08 73122 8192000000 10897793824 11376357376 1948440128 19.214 99 9 18 1 1966025152 15323008 2262016
21:12:28 99275 8192000000 10897407696 11352096768 1893326528 18.773 96 17 33 1 1910519392 12790640 4402224
21:14:15 58306 8192000000 10889103408 11356680192 1947782256 19.209 99 22 44 0 1965998000 11649280 6566464
21:15:22 97108 8192000000 10914648816 11380330496 1950271648 19.229 99 20 39 0 1968853216 13047680 5533888
21:18:07 30714 8192000000 10926467280 11359383552 1954702800 19.264 99 48 96 1 1974401392 5999328 13699264
21:18:44 71995 8192000000 10913838656 11380854784 1960736656 19.312 99 38 76 1 1984705248 13565328 10403264
21:20:08 111202 8192000000 10924388416 11382919168 1934616624 19.104 98 16 33 1 1950900128 12150528 4132976
21:22:13 54282 8192000000 10913352880 11380842496 1979447504 19.460 100 30 60 1 2003697936 15726352 8524080
21:23:16 32072 8192000000 10890144592 11366801408 1957171120 19.284 99 23 46 0 1977961008 13559632 7230256
21:24:12 44742 8192000000 10878971584 11355426816 1945428816 19.190 99 15 30 0 1969568496 19735392 4404288
21:25:16 66276 8192000000 10874115920 11351601152 1957150384 19.283 100 10 20 0 1973430080 13463904 2815792
21:26:29 66952 8192000000 10905238272 11373580288 1979954880 19.464 100 13 26 2 1990092928 6385488 3752560
21:27:42 46004 8192000000 10901087552 11381821440 1986983936 19.520 100 19 38 0 2000558624 8380032 5194656
21:28:34 70794 8192000000 10900439616 11386486784 1970706752 19.391 99 8 16 0 1981523648 8458544 2358352
21:29:51 50404 8192000000 10869091600 11344228352 1870047872 18.585 94 15 30 2 1881689888 7442864 4199152
21:30:48 33891 8192000000 10882456544 11328069632 1882126720 18.682 96 20 38 1 1894592240 6811216 5654304
21:31:30 59880 8192000000 10882053744 11341221888 1894650880 18.783 97 25 50 2 1909990640 8113472 7226288
21:32:46 58001 8192000000 10874691152 11349266432 1907191952 18.884 98 19 37 0 1923905664 11442368 5271344
21:33:50 63362 8192000000 10853734128 11317874688 1869319344 18.579 96 12 23 0 1887673712 14210464 4143904
21:35:01 61529 8192000000 10882198944 11351957504 1917818176 18.969 98 21 42 1 1937150416 13527168 5805072
21:36:15 38505 8192000000 10908673184 11373797376 1965303824 19.348 100 29 58 1 1985952208 11891936 8756448
21:37:00 64866 8192000000 10897207840 11375398912 1949695376 19.224 99 24 48 0 1970983216 14458528 6829312
21:38:11 78835 8192000000 10908413520 11369525248 1945484032 19.190 99 5 10 0 1960108400 13052576 1571792
21:39:37 16113 8192000000 10901498784 11355258880 1917297776 18.965 97 43 86 2 1938818336 8704240 12816320
21:40:05 36941 8192000000 10875612752 11336323072 1876433936 18.636 96 36 72 1 1898148848 11668528 10046384
21:41:02 45585 8192000000 10861116816 11321745408 1874028464 18.617 97 16 32 1 1889118320 10830400 4259456
21:41:55 88239 8192000000 10853249120 11331510272 1848626784 18.411 96 10 20 1 1865143920 13856784 2660352
21:43:30 147566 8192000000 10842006032 11313885184 1888252720 18.732 98 22 44 1 1910168832 15579680 6336432
21:46:04 27173 8192000000 10848784112 11321565184 1926598224 19.040 100 17 34 0 1940301872 8936064 4767584
21:47:24 61538 8192000000 10828980144 11304026112 1906615456 18.879 99 14 28 0 1916935712 6656976 3663280
21:48:37 41176 8192000000 10843864160 11329077248 1932635344 19.088 100 6 12 1 1941968528 7868928 1464256
21:49:30 101484 8192000000 10854405280 11342655488 1885024832 18.706 97 15 30 0 1902567536 13473600 4069104
21:51:35 51085 8192000000 10868708144 11338407936 1881365424 18.676 97 13 26 1 1892716224 7377840 3972960
21:52:33 80847 8192000000 10874176416 11350110208 1933215296 19.093 100 20 40 0 1949496496 11214016 5067184
21:54:08 79417 8192000000 10897647808 11376668672 1936158896 19.116 99 13 25 1 1963115312 22930928 4025488
21:55:38 78123 8192000000 10876219168 11343073280 1908756064 18.897 98 16 32 1 1932099216 18952016 4391136
21:57:09 67304 8192000000 10860474208 11319439360 1858147440 18.488 95 20 38 4 1878672256 14984352 5540464
21:58:25 25115 8192000000 10876247008 11328892928 1917821888 18.969 99 37 74 1 1939981408 12151616 10007904
21:58:59 19179 8192000000 10886032848 11337797632 1925014512 19.027 99 40 80 0 1945567136 9784880 10767744
21:59:25 17223 8192000000 10883613760 11326492672 1902652496 18.848 98 44 86 2 1924458992 10297984 11508512
21:59:49 35684 8192000000 10882267184 11347210240 1945266672 19.189 100 41 80 1 1968765040 12540112 10958256
22:00:39 79091 8192000000 10894715344 11354841088 1899899376 18.825 97 11 22 0 1915805216 12850688 3055152
22:02:04 32087 8192000000 10920902688 11361939456 1930574896 19.071 98 38 75 1 1956183696 15209280 10399520
22:02:44 52060 8192000000 10892172592 11366408192 1956343808 19.277 100 18 36 1 1981502624 19599232 5559584
22:03:50 79111 8192000000 10895917536 11381882880 1938607744 19.136 99 5 10 0 1960415712 20781168 1026800
22:05:38 101223 8192000000 10884159856 11351416832 1900879792 18.833 97 16 32 1 1915438528 10429456 4129280
22:07:30 43561 8192000000 10880509152 11351539712 1936687808 19.120 99 26 50 3 1954043232 10388896 6966528
22:08:36 43866 8192000000 10876584992 11362172928 1961827280 19.321 100 18 36 0 1974919680 7232864 5859536
22:09:30 62365 8192000000 10877995424 11360305152 1946028656 19.195 99 8 16 0 1956081104 7906992 2145456
22:10:57 55204 8192000000 10884500704 11360227328 1947473616 19.206 99 29 59 0 1970512624 13741200 9297808
22:12:21 66265 8192000000 10874622560 11358875648 1946846256 19.201 99 11 22 0 1958122096 8181808 3094032
22:13:36 91927 8192000000 10911826192 11381673984 1942559888 19.167 98 14 27 2 1957746752 10754672 4432192
22:15:17 37410 8192000000 10903273664 11370582016 1953271376 19.253 99 16 32 1 1967039616 9255232 4513008
22:16:36 48736 8192000000 10898573120 11359027200 1932470144 19.087 98 33 67 2 1949582064 8140752 8971168
22:17:34 44461 8192000000 10897385504 11360448512 1925725376 19.033 98 25 50 0 1940638544 7912912 7000256
22:18:30 46370 8192000000 10896777232 11356143616 1938509808 19.135 99 28 56 1 1961254864 14792624 7952432
22:19:31 56723 8192000000 10891390912 11367997440 1922116544 19.004 98 24 48 2 1945297632 16634176 6546912
22:20:45 111378 8192000000 10897938800 11373260800 1948759264 19.217 99 24 48 2 1974309200 18438048 7111888
22:22:46 117964 8192000000 10872245248 11360919552 1851535056 18.435 95 11 22 0 1866209728 11675728 2998944
22:25:32 113137 8192000000 10881063424 11370999808 1957709648 19.288 100 24 48 2 1980900976 16676896 6514432

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 21-06-2021 22:29:25 to 21-06-2021 22:29:55.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 114 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-06-2021 22:29:56 to 21-06-2021 22:29:58.

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          237337
MON$OLDEST_ACTIVE               237613
MON$OLDEST_SNAPSHOT             237613
MON$NEXT_TRANSACTION            237613
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                       2004160
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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 ---
:180: 
:181: mscs-test-161.budzdorov.ru    Mon Jun 21 22:28:08 2021
:182:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:183: 
--- end of diff output ---

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

21.06.21 22:29:59. 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-06-21 22:30:02 No severe PSQL-related problems occured
21.06.21 22:30:03. End of report.