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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17035428 kB
MemAvailable 31151944 kB
Buffers 0 kB
Cached 14685184 kB
SwapCached 3892 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-02-22 01:27:16
DTS_END                         2021-02-22 01:27:16.0070
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49590
TRN_ID                          234734
ATT_ID                          695
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: 9048.66 24810 1085839
customer order: creation 163.27 393 19592
customer order: refuse 15.01 394 1801
order to supplier: creation 43.45 1301 5214
order to supplier: removal 3.36 110488 403
invoice (draft): creation 44.34 3658 5321
invoice (draft): removal 52.87 808 6344
invoice accept: apply 40.14 18439 4817
invoice accept: cancel 48.12 811 5774
customer reserve: creation 3661.71 184 439405
customer reserve: removal 4681.77 63 561812
realization accept: apply 79.24 189 9509
realization accept: cancel 90.94 96 10913
payment from customer: creation 57.15 126 6858
payment from customer: removal 5.73 93 688
payment to supplier: creation 46.88 151 5625
payment to supplier: removal 3.38 84 405
service: total inventory turnovers 4.15 1277 498
service: total monetary turnovers 6.23 32 748
service: aggregate perf. data 0.90 16316 108
service: refresh index statistics 0.03 341289 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-02-2021 01:28:46 to 22-02-2021 01:28:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4390
TEST_TIME 2 2455
TEST_TIME 3 3726
TEST_TIME 4 3728
TEST_TIME 5 3983
TEST_TIME 6 4341
TEST_TIME 7 4779
TEST_TIME 8 4675
TEST_TIME 9 4611
TEST_TIME 10 4922
TEST_TIME 11 5191
TEST_TIME 12 5139
TEST_TIME 13 5641
TEST_TIME 14 5922
TEST_TIME 15 6134
TEST_TIME 16 6217
TEST_TIME 17 6693
TEST_TIME 18 7205
TEST_TIME 19 7570
TEST_TIME 20 7910
TEST_TIME 21 7784
TEST_TIME 22 8069
TEST_TIME 23 8487
TEST_TIME 24 8622
TEST_TIME 25 9011
TEST_TIME 26 9193
TEST_TIME 27 10191
TEST_TIME 28 10820
TEST_TIME 29 10810
TEST_TIME 30 10739
TEST_TIME 31 10773
TEST_TIME 32 10466
TEST_TIME 33 10358
TEST_TIME 34 10307
TEST_TIME 35 10164
TEST_TIME 36 10038
TEST_TIME 37 10016
TEST_TIME 38 9911
TEST_TIME 39 9940
TEST_TIME 40 9715
TEST_TIME 41 9662
TEST_TIME 42 9582
TEST_TIME 43 9583
TEST_TIME 44 9578
TEST_TIME 45 9505
TEST_TIME 46 9374
TEST_TIME 47 9361
TEST_TIME 48 9283
TEST_TIME 49 9285
TEST_TIME 50 9254
TEST_TIME 51 9253
TEST_TIME 52 9200
TEST_TIME 53 9124
TEST_TIME 54 9228
TEST_TIME 55 9254
TEST_TIME 56 9213
TEST_TIME 57 9232
TEST_TIME 58 9472
TEST_TIME 59 9449
TEST_TIME 60 9536
TEST_TIME 61 9527
TEST_TIME 62 9503
TEST_TIME 63 9608
TEST_TIME 64 9575
TEST_TIME 65 9481
TEST_TIME 66 9474
TEST_TIME 67 9399
TEST_TIME 68 9391
TEST_TIME 69 9352
TEST_TIME 70 9335
TEST_TIME 71 9292
TEST_TIME 72 9221
TEST_TIME 73 9158
TEST_TIME 74 9102
TEST_TIME 75 9150
TEST_TIME 76 9139
TEST_TIME 77 9136
TEST_TIME 78 9184
TEST_TIME 79 9218
TEST_TIME 80 9205
TEST_TIME 81 9250
TEST_TIME 82 9234
TEST_TIME 83 9283
TEST_TIME 84 9259
TEST_TIME 85 9295
TEST_TIME 86 9276
TEST_TIME 87 9314
TEST_TIME 88 9314
TEST_TIME 89 9224
TEST_TIME 90 9161
TEST_TIME 91 9185
TEST_TIME 92 9159
TEST_TIME 93 9091
TEST_TIME 94 9032
TEST_TIME 95 9044
TEST_TIME 96 9069
TEST_TIME 97 9047
TEST_TIME 98 9088
TEST_TIME 99 9126
TEST_TIME 100 9121
TEST_TIME 101 9120
TEST_TIME 102 9116
TEST_TIME 103 9068
TEST_TIME 104 9142
TEST_TIME 105 9314
TEST_TIME 106 9327
TEST_TIME 107 9342
TEST_TIME 108 9312
TEST_TIME 109 9310
TEST_TIME 110 9240
TEST_TIME 111 9220
TEST_TIME 112 9195
TEST_TIME 113 9165
TEST_TIME 114 9121
TEST_TIME 115 9131
TEST_TIME 116 9112
TEST_TIME 117 9094
TEST_TIME 118 9073
TEST_TIME 119 9117
TEST_TIME 120 9053

Performance per minute, chart


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

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 1493805 1493805 0 0.00 0 21561 6 0 0
doc_list_biud 1493803 1493803 0 0.00 0 48839 30 0 0
sp_add_invoice_to_stock 4897 4817 80 1.63 44 190090 18439 0 80
sp_cancel_adding_invoice 5774 5774 0 0.00 6 73520 811 0 0
sp_cancel_client_order 1801 1801 0 0.00 4 23555 394 0 0
sp_cancel_customer_reserve 561812 561812 0 0.00 1 48842 63 0 0
sp_cancel_pay_from_customer 688 688 0 0.00 2 4538 93 0 0
sp_cancel_pay_to_supplier 405 405 0 0.00 2 7469 85 0 0
sp_cancel_supplier_invoice 6351 6344 7 0.11 2 14639 809 0 7
sp_cancel_supplier_order 403 403 0 0.00 10 1056571 110488 0 0
sp_cancel_write_off 10913 10913 0 0.00 1 10661 96 0 0
sp_client_order 19592 19592 0 0.00 4 19137 394 0 0
sp_customer_reserve 439405 439405 0 0.00 0 60209 184 0 0
sp_fill_shopping_cart 30117 30117 0 0.00 1 15183 45 0 0
sp_fill_shopping_cart_clo_res 439399 439399 0 0.00 0 14547 14 0 0
sp_get_clo_for_invoice 4809 4809 0 0.00 0 32237 351 0 0
sp_kill_cost_storno 17780 17780 0 0.00 0 7791 50 0 0
sp_kill_qstorno_ret_qs2qd 1141284 1141284 0 0.00 0 48837 34 0 0
sp_kill_qty_storno 601364 601364 0 0.00 0 48839 73 0 0
sp_lock_selected_doc 20017 20017 0 0.00 0 9600 6 0 0
sp_make_cost_storno 26800 26800 0 0.00 0 20576 59 0 0
sp_multiply_rows_for_pdistr 26800 26800 0 0.00 0 8447 30 0 0
sp_multiply_rows_for_qdistr 19592 19592 0 0.00 0 15081 175 0 0
sp_pay_from_customer 6858 6858 0 0.00 4 32507 127 0 0
sp_pay_to_supplier 5625 5625 0 0.00 5 65307 152 0 0
sp_payment_common 12483 12483 0 0.00 1 65275 44 0 0
sp_qd_handle_on_cancel_clo 1801 1801 0 0.00 0 23549 353 0 0
sp_qd_handle_on_invoice_upd_sts 10582 10582 0 0.00 0 16428 334 0 0
sp_qd_handle_on_reserve_upd_sts 9509 9509 0 0.00 0 11165 62 0 0
sp_reserve_write_off 9509 9509 0 0.00 6 14498 190 0 0
sp_supplier_invoice 5321 5321 0 0.00 7 82480 3658 0 0
sp_supplier_order 5214 5214 0 0.00 5 35047 1301 0 0
srv_aggregate_perf_data 108 108 0 0.00 3173 141177 16317 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1059 196467 31967 0 0
srv_find_qd_qs_mism 1040803 1040803 0 0.00 0 8432 4 0 0
srv_make_invnt_saldo 498 498 0 0.00 42 79046 1278 0 0
srv_make_money_saldo 748 748 0 0.00 1 4152 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 216611 517178 341289 0 0
t$perf-abend:sp_add_invoice_to_stock 80 80 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 4817 4817 0 0.00 0 14919 185 0 0
t$perf-norm:sp_cancel_adding_invoice 412 412 0 0.00 0 11969 157 0 0
t$perf-norm:sp_cancel_client_order 1801 1801 0 0.00 0 7084 19 0 0
t$perf-norm:sp_cancel_customer_reserve 673 673 0 0.00 0 848 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 688 688 0 0.00 0 1915 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 405 405 0 0.00 0 2106 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 368 368 0 0.00 0 1958 28 0 0
t$perf-norm:sp_cancel_supplier_order 403 403 0 0.00 0 25958 1701 0 0
t$perf-norm:sp_cancel_write_off 952 952 0 0.00 0 7758 22 0 0
t$perf-norm:sp_client_order 19592 19592 0 0.00 0 34619 23 0 0
t$perf-norm:sp_customer_reserve 920 920 0 0.00 0 1709 6 0 0
t$perf-norm:sp_pay_from_customer 6858 6858 0 0.00 0 9097 12 0 0
t$perf-norm:sp_pay_to_supplier 5625 5625 0 0.00 0 11237 12 0 0
t$perf-norm:sp_reserve_write_off 9509 9509 0 0.00 0 8635 12 0 0
t$perf-norm:sp_supplier_invoice 5321 5321 0 0.00 0 31727 29 0 0
t$perf-norm:sp_supplier_order 5214 5214 0 0.00 0 2991 16 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 472 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 341 6 0 0
t$perf-norm:srv_make_invnt_saldo 498 498 0 0.00 0 1099 23 0 0
t$perf-norm:srv_make_money_saldo 748 748 0 0.00 0 543 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 7 5 0 0
v_add_invoice_to_stock 9772 9612 160 1.63 0 4983 24 0 160
v_all_customers 36024 36024 0 0.00 0 131 1 0 0
v_all_suppliers 29310 29310 0 0.00 0 18 1 0 0
v_all_wares 39184 39184 0 0.00 0 77 1 0 0
v_cancel_adding_invoice 824 824 0 0.00 0 2040 11 0 0
v_cancel_client_order 3602 3602 0 0.00 0 4924 9 0 0
v_cancel_customer_prepayment 1376 1376 0 0.00 0 3469 15 0 0
v_cancel_customer_reserve 1346 1346 0 0.00 0 3956 8 0 0
v_cancel_payment_to_supplier 810 810 0 0.00 0 3033 13 0 0
v_cancel_supplier_invoice 750 736 14 1.86 0 1727 14 0 14
v_cancel_supplier_order 806 806 0 0.00 0 1449 6 0 0
v_cancel_write_off 1904 1904 0 0.00 0 7292 19 0 0
v_max_id_clo_ord 5214 5214 0 0.00 0 386 1 0 0
v_max_id_clo_res 920 920 0 0.00 0 4114 19 0 0
v_max_id_ord_sup 5311 5311 0 0.00 0 6092 3 0 0
v_max_non_paid_invoice 1495 1495 0 0.00 0 4165 5 0 0
v_max_non_paid_realizn 3568 3568 0 0.00 0 5319 6 0 0
v_min_id_clo_ord 5214 5214 0 0.00 0 2453 7 0 0
v_min_id_clo_res 920 920 0 0.00 0 3577 8 0 0
v_min_id_ord_sup 5311 5311 0 0.00 0 6074 10 0 0
v_min_non_paid_invoice 5625 5625 0 0.00 0 65269 38 0 0
v_min_non_paid_realizn 6858 6858 0 0.00 0 32499 28 0 0
v_our_firm 9740 9740 0 0.00 0 16 1 0 0
v_reserve_write_off 19018 19018 0 0.00 0 4780 8 0 0
x_lock_depdocs_on_canc_invoice 11750 11750 0 0.00 0 12996 122 0 0
x_lock_depdocs_on_canc_sup_ord 403 403 0 0.00 0 9529 398 0 0
x_make_qstorno_1000_1200 5214 5214 0 0.00 2 34941 1210 0 0
x_make_qstorno_1200_2000 5321 5321 0 0.00 3 82388 3499 0 0
x_make_qstorno_2100_3300 439405 439405 0 0.00 0 60197 167 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:19 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:25 13751 8192000000 10227069392 10534711296 870791952 9.608 68 57 116 0 892592208 2543264 19256992
22:57:47 22991 8192000000 10329942432 10645106688 1376501712 14.385 100 80 160 0 1407575040 4308624 26764704
22:58:20 35291 8192000000 10385071264 10704445440 1425463344 14.821 100 86 172 0 1460349728 6146624 28739760
22:59:05 28121 8192000000 10412557984 10739548160 1464970944 15.170 100 91 181 0 1501012704 7293776 28747984
22:59:42 25377 8192000000 10434756336 10766602240 1491799008 15.405 100 89 178 0 1528203024 7931328 28472688
23:00:22 8799 8192000000 10461531712 10794381312 1513720848 15.596 100 92 184 0 1551587184 8445536 29420800
23:00:44 18763 8192000000 10470464944 10803957760 1523109120 15.677 100 89 179 0 1560368992 9016464 28243408
23:01:10 20676 8192000000 10485332192 10825498624 1537622512 15.803 100 93 186 0 1576799264 9795792 29380960
23:01:42 9408 8192000000 10500410960 10846318592 1560439760 16.000 100 83 166 1 1595994816 9947456 25607600
23:02:05 14359 8192000000 10528015360 10873995264 1580299008 16.171 100 88 176 0 1617825088 10801488 26724592
23:02:31 14527 8192000000 10542914240 10899914752 1598712832 16.328 100 77 153 0 1633383296 11267584 23402880
23:02:53 14163 8192000000 10571650928 10930634752 1631037968 16.604 100 80 160 1 1666624672 11372336 24214368
23:03:14 10385 8192000000 10578804256 10945265664 1644026720 16.714 100 86 171 3 1682730608 12506256 26197632
23:03:32 9884 8192000000 10596297088 10965209088 1663058480 16.875 100 76 152 2 1697008256 11800880 22148896
23:03:50 10504 8192000000 10625965472 10992984064 1683372160 17.046 100 79 157 1 1719144384 12518512 23253712
23:04:09 6859 8192000000 10646146384 11014127616 1701264272 17.196 100 79 159 1 1736900000 12406752 23228976
23:04:23 6446 8192000000 10650429440 11020238848 1710493856 17.273 100 86 174 1 1748530832 12804256 25232720
23:04:36 6704 8192000000 10665135728 11037282304 1726890832 17.410 100 83 166 2 1763356240 12859024 23606384
23:04:50 4654 8192000000 10671690400 11048443904 1736422608 17.489 100 85 169 0 1774411728 13542144 24446976
23:05:03 5090 8192000000 10684637520 11058298880 1747472896 17.581 100 84 168 1 1784588944 13365280 23750768
23:05:15 6206 8192000000 10698879200 11076825088 1765454576 17.729 100 82 164 2 1802150400 13420560 23275264
23:05:29 3493 8192000000 10717780912 11095654400 1778569408 17.838 100 76 150 0 1812088208 12448336 21070464
23:05:39 4841 8192000000 10726558016 11106033664 1787351184 17.910 100 79 155 1 1820604480 11916848 21336448
23:05:51 3644 8192000000 10727862928 11111391232 1793107808 17.957 100 84 168 2 1829662576 13059440 23495328
23:06:02 4045 8192000000 10738447408 11116765184 1798138240 17.999 100 85 166 0 1834383552 12669056 23576256
23:06:12 2672 8192000000 10748045040 11134160896 1811272672 18.106 100 81 162 0 1846769024 12855680 22640672
23:06:22 2565 8192000000 10759345568 11138453504 1814891216 18.136 100 83 165 1 1850085728 12311552 22882960
23:06:32 5139 8192000000 10761526256 11143270400 1820289408 18.180 100 76 152 0 1853726352 12654672 20782272
23:06:44 6606 8192000000 10774547616 11155841024 1832008928 18.276 100 92 185 2 1870707056 12903360 25794768
23:06:57 2459 8192000000 10787086384 11170381824 1841026624 18.349 100 94 188 1 1882506272 14872448 26607200
23:07:06 3043 8192000000 10783175840 11170324480 1843801792 18.372 100 89 179 1 1882993808 14256752 24935264
23:07:15 1905 8192000000 10794671680 11177455616 1846600016 18.394 100 92 186 1 1886690048 14562496 25527536
23:07:24 1923 8192000000 10795447664 11178201088 1851116832 18.431 100 95 190 1 1892032544 14041904 26873808
23:07:32 1614 8192000000 10788722608 11178659840 1855646560 18.468 100 92 184 2 1894684784 13225072 25813152
23:07:41 1681 8192000000 10802941424 11188629504 1858553120 18.492 100 90 181 1 1897067376 13614208 24900048
23:07:49 2607 8192000000 10807938704 11191926784 1857993424 18.487 100 93 184 2 1898830496 15021936 25815136
23:07:58 1493 8192000000 10804188096 11189800960 1861738848 18.517 100 93 186 0 1901521088 12892448 26889792
23:08:06 3000 8192000000 10814987360 11199737856 1869113728 18.577 100 95 185 1 1908248176 12735520 26398928
23:08:15 2681 8192000000 10818863824 11206008832 1873470896 18.612 100 98 197 1 1914550896 12738192 28341808
23:08:24 1521 8192000000 10824109872 11211800576 1875163472 18.626 100 96 192 1 1916601328 14001216 27436640
23:08:32 37369 8192000000 10806150096 11207868416 1870864656 18.591 100 54 106 2 1895910432 8904208 16141568
23:09:15 11211 8192000000 10813635808 11214659584 1878375088 18.652 100 64 128 1 1906814960 10207440 18232432
23:09:33 9700 8192000000 10797499424 11215032320 1880582608 18.670 100 64 128 0 1911807424 12794752 18430064
23:09:56 3093 8192000000 10804734016 11220451328 1882388304 18.684 100 58 117 2 1910357392 11151440 16817648
23:10:09 6720 8192000000 10796102720 11216089088 1884142624 18.699 100 20 40 1 1894672512 5207152 5322736
23:10:24 6473 8192000000 10787944432 11221168128 1885805872 18.712 100 26 52 0 1903643568 10995360 6842336
23:10:37 5211 8192000000 10813749744 11229683712 1891143296 18.755 100 41 82 1 1910817120 7904480 11769344
23:10:48 10172 8192000000 10799397248 11226570752 1890312720 18.748 100 30 60 1 1906154352 7778016 8063616
23:11:05 8718 8192000000 10801686928 11231068160 1894533584 18.782 100 25 48 3 1908539872 6383808 7622480
23:11:24 6771 8192000000 10812424608 11237281792 1899174160 18.820 100 36 70 0 1915834720 6327936 10332624
23:11:37 10208 8192000000 10795062080 11232612352 1900585792 18.831 100 26 53 0 1914603696 7082112 6935792
23:11:55 10302 8192000000 10804709744 11236868096 1898459536 18.814 100 17 34 1 1909373632 6080224 4833872
23:12:11 9468 8192000000 10811213520 11243663360 1903717536 18.856 100 19 38 1 1915034128 5941024 5375568
23:12:31 15151 8192000000 10813165712 11247153152 1905904224 18.874 100 15 30 1 1915442992 5436256 4102512
23:12:53 8939 8192000000 10817776432 11249848320 1908083776 18.891 100 11 22 1 1916590816 5633664 2873376
23:13:13 16546 8192000000 10828079296 11251720192 1911812464 18.921 100 24 48 2 1924311760 6325648 6173648
23:13:38 60094 8192000000 10867371552 11270664192 1919403664 18.982 100 58 115 0 1942969296 6096064 17469568
23:14:45 1583 8192000000 10869511968 11274850304 1922098080 19.004 100 92 186 1 1959059840 10252928 26708832
23:14:52 4741 8192000000 10841154160 11268931584 1913313696 18.933 100 36 72 1 1932005136 8801328 9890112
23:15:04 5757 8192000000 10818343584 11258761216 1912205232 18.924 100 18 36 0 1923353072 5726064 5421776
23:15:16 8134 8192000000 10837575696 11265953792 1916272400 18.957 100 28 56 2 1930771376 6396400 8102576
23:15:30 28436 8192000000 10828138080 11257352192 1901058048 18.835 99 37 74 1 1917976656 5312960 11605648
23:16:05 7513 8192000000 10819079136 11260743680 1914598320 18.944 100 25 50 1 1927591216 6253664 6739232
23:16:19 9546 8192000000 10823105632 11255140352 1876995600 18.641 98 29 58 1 1892112208 7179008 7937600
23:16:35 6452 8192000000 10806910832 11238907904 1885664896 18.711 99 27 54 1 1900072608 7216800 7190912
23:16:51 6258 8192000000 10820951680 11255250944 1906566800 18.879 100 35 70 1 1924009920 6697104 10746016
23:17:10 6934 8192000000 10799295008 11233525760 1865703984 18.549 98 23 46 1 1878391152 5428992 7258176
23:17:25 4896 8192000000 10793659504 11220647936 1839998928 18.341 97 23 46 1 1852301104 5753040 6549136
23:17:36 8856 8192000000 10789260864 11217346560 1859361696 18.498 99 13 26 1 1868500768 5602288 3536784
23:17:52 8554 8192000000 10747949488 11175489536 1816603200 18.150 97 12 24 1 1825517136 5862496 3051440
23:18:08 7158 8192000000 10776977776 11196022784 1813320704 18.123 97 23 46 2 1824943296 5523520 6099072
23:18:25 14161 8192000000 10725727520 11127046144 1749368560 17.596 94 21 42 2 1759607520 4672560 5566400
23:18:47 57828 8192000000 10723706000 11146858496 1718245504 17.338 93 25 50 1 1730240176 5142672 6852000
23:19:53 6849 8192000000 10715593040 11135217664 1752962304 17.626 96 19 38 0 1764187232 5248336 5976592
23:20:06 8637 8192000000 10733402912 11150336000 1792188608 17.950 98 32 63 0 1807554720 5861664 9504448
23:20:23 7033 8192000000 10754893744 11167621120 1805616944 18.060 99 31 62 0 1822348992 8382352 8349696
23:20:39 4611 8192000000 10733805200 11147280384 1797466496 17.993 99 31 61 0 1812317616 5857232 8993888
23:20:52 12101 8192000000 10679739648 11097706496 1652030544 16.782 91 30 60 1 1667306864 5515776 9760544
23:21:10 9163 8192000000 10718749328 11128139776 1745639648 17.565 97 28 56 4 1758704336 5883904 7180784
23:21:27 5531 8192000000 10694653536 11109109760 1726233104 17.404 96 31 61 3 1740396432 5153104 9010224
23:21:41 10556 8192000000 10701942032 11125661696 1779195552 17.843 99 24 48 2 1792333424 6062640 7075232
23:21:57 5615 8192000000 10715623312 11133128704 1798678000 18.003 100 33 67 2 1815153984 5962432 10513552
23:22:12 7491 8192000000 10716814720 11123286016 1772079344 17.784 98 33 64 1 1787568192 6158272 9330576
23:22:26 6484 8192000000 10720022480 11136610304 1805098240 18.056 100 24 49 1 1817668496 4762880 7807376
23:22:39 8669 8192000000 10714035856 11132669952 1773451376 17.795 98 21 42 1 1785363696 6069136 5843184
23:22:55 54564 8192000000 10737906256 11158462464 1804766032 18.053 99 31 63 1 1819976992 5652880 9558080
23:23:56 22726 8192000000 10734081056 11165532160 1828354736 18.246 100 25 50 0 1841484576 5315376 7814464
23:24:27 9681 8192000000 10756660288 11176804352 1834886176 18.299 100 27 54 1 1849477936 6689024 7902736
23:24:45 5446 8192000000 10761733456 11187499008 1849765392 18.420 100 47 94 5 1870158528 8184320 12208816
23:24:59 7278 8192000000 10757292176 11185795072 1846368320 18.393 100 19 38 1 1856597552 5224224 5005008
23:25:15 6524 8192000000 10763555376 11190927360 1850734736 18.428 100 23 46 2 1863256384 5607008 6914640
23:25:27 8023 8192000000 10773722544 11202879488 1856378896 18.474 100 27 55 1 1874807776 10696512 7732368
23:25:42 8454 8192000000 10770751200 11200991232 1859703360 18.501 100 25 50 1 1873319392 6157824 7458208
23:25:57 9628 8192000000 10765386464 11202539520 1858805904 18.494 100 19 38 2 1869899008 5340768 5752336
23:26:13 12909 8192000000 10768101728 11202031616 1859048160 18.496 100 14 28 0 1868237792 5159472 4030160
23:26:33 14185 8192000000 10774580144 11202719744 1859202288 18.497 100 14 27 2 1868702624 4855856 4644480
23:26:56 15864 8192000000 10788272736 11213447168 1865350240 18.547 100 21 42 1 1876516432 5312432 5853760
23:27:19 45783 8192000000 10812022896 11231457280 1886556256 18.718 100 33 66 2 1900839504 5107504 9175744
23:28:15 18300 8192000000 10834706240 11248955392 1901980064 18.842 100 67 128 1 1931038656 9637872 19420720
23:28:42 16613 8192000000 10844424704 11262111744 1907534720 18.887 100 55 108 1 1935119584 12231648 15353216
23:29:07 103123 8192000000 10843510448 11274366976 1914348096 18.942 100 47 94 3 1942904608 15749552 12806960
23:30:57 58811 8192000000 10861654944 11296014336 1926326704 19.037 100 42 85 1 1953899168 15666368 11906096
23:32:02 17489 8192000000 10867567536 11296354304 1916315136 18.957 99 42 84 0 1944751648 16290096 12146416
23:32:26 11763 8192000000 10890210432 11311288320 1939518128 19.143 100 49 98 2 1971025456 17267872 14239456
23:32:45 22354 8192000000 10892762400 11318505472 1948228416 19.212 100 55 110 0 1983666032 19304816 16132800
23:33:16 7547 8192000000 10893939712 11325747200 1952005568 19.242 100 50 98 0 1987786912 21380496 14400848
23:33:35 4957 8192000000 10919708304 11330469888 1957731168 19.288 100 50 99 0 1992413344 20489488 14192688
23:33:48 11782 8192000000 10912989536 11339296768 1961964288 19.322 100 57 115 3 2000560864 22031904 16564672
23:34:08 19315 8192000000 10906829760 11339948032 1961799744 19.320 100 47 93 1 1997186048 21912656 13473648
23:34:34 17680 8192000000 10917003984 11350597632 1965509616 19.350 100 44 88 0 2007478992 29005760 12963616
23:35:02 15183 8192000000 10911622144 11351855104 1972408656 19.405 100 43 86 1 2008819888 23230800 13180432
23:35:28 3191 8192000000 10927637984 11353935872 1971176352 19.395 100 62 123 1 2013327488 23155744 18995392
23:35:41 10805 8192000000 10920945696 11354062848 1974344368 19.420 100 55 108 2 2014505408 24260544 15900496
23:36:06 9881 8192000000 10926254176 11358617600 1962043248 19.322 99 59 118 2 2006429520 26597984 17788288
23:36:26 9884 8192000000 10945373936 11371819008 1985043808 19.505 100 56 111 3 2031177968 29087344 17046816
23:36:43 6954 8192000000 10942645424 11374166016 1989870736 19.543 100 62 123 1 2038873328 30465120 18537472
23:36:57 11656 8192000000 10948847856 11382771712 1988982864 19.536 100 58 116 2 2041067552 35162848 16921840
23:37:16 6623 8192000000 10959013952 11386257408 1998667744 19.612 100 58 116 0 2046878336 30294304 17916288
23:37:32 10262 8192000000 10951735440 11388116992 1999378112 19.618 100 64 128 1 2050660640 31386720 19895808
23:37:49 4779 8192000000 10974023408 11398774784 2004968416 19.662 100 66 132 1 2057636816 32237248 20431152
23:38:02 5165 8192000000 10975995824 11403825152 2008734560 19.692 100 68 136 1 2062155920 32856768 20564592
23:38:16 3977 8192000000 10954439280 11380948992 1990181424 19.545 99 63 125 0 2042504144 32858928 19463792
23:38:27 3973 8192000000 10962048208 11390791680 1998797792 19.613 100 66 132 0 2053712208 34006384 20908032
23:38:40 10755 8192000000 10964257120 11401220096 2004648928 19.659 100 57 114 0 2056927744 34222608 18056208
23:39:00 9264 8192000000 10936044464 11362897920 1942908672 19.170 97 61 122 0 1994936384 33071088 18956624
23:39:22 4899 8192000000 10956484496 11387314176 1990771552 19.550 100 64 129 1 2047270704 35817472 20681680
23:39:36 6734 8192000000 10962386032 11398094848 1996446192 19.595 100 48 95 1 2051853456 40108384 15298880
23:39:52 1704 8192000000 10952735056 11369316352 1969222752 19.379 99 76 151 1 2033989600 40531136 24235712
23:40:01 4287 8192000000 10975754448 11397431296 1997148464 19.600 100 80 160 1 2064592240 43158960 24284816
23:40:13 4237 8192000000 10980538224 11400110080 1984340688 19.499 99 86 173 2 2055218192 43173984 27703520
23:40:26 9869 8192000000 10966783872 11389448192 1995369920 19.586 100 73 146 2 2058645120 39052304 24222896
23:40:43 4910 8192000000 10964823248 11392499712 1995562064 19.588 100 70 136 3 2055050832 38575648 20913120
23:41:02 3724 8192000000 10993273584 11416629248 2013498368 19.729 100 78 157 3 2078397424 41901216 22997840
23:41:16 3821 8192000000 10993575504 11415134208 1995678112 19.589 99 73 146 0 2062274432 43718672 22877648
23:41:28 2738 8192000000 10964014992 11376951296 1966410832 19.357 98 79 156 1 2037425440 46513872 24500736
23:41:40 1059 8192000000 10960512864 11374034944 1957683712 19.288 98 79 155 4 2028717136 45498064 25535360
23:41:47 2430 8192000000 10976586432 11389325312 1984322816 19.499 100 86 171 3 2057641472 46699824 26618832
23:41:57 1699 8192000000 10972718384 11390623744 1982925728 19.488 100 79 156 1 2052901136 46513344 23462064
23:42:07 3499 8192000000 10979664688 11393019904 1974385936 19.420 99 90 179 0 2050978720 49287104 27305680
23:42:18 2183 8192000000 10976211664 11388215296 1983651088 19.494 100 91 182 0 2062689456 50024224 29014144
23:42:29 5234 8192000000 10983936096 11401723904 1989635552 19.541 100 82 164 0 2067032128 51589232 25807344
23:42:45 4009 8192000000 10966619008 11392053248 1970844608 19.392 99 70 140 1 2042267008 49198256 22224144
23:42:57 5546 8192000000 10962171632 11386036224 1965778128 19.352 99 67 134 1 2040828624 53647728 21402768
23:43:10 4032 8192000000 10959380512 11377045504 1949650128 19.224 98 77 150 2 2022452528 49632320 23170080
23:43:22 2515 8192000000 10970265808 11392892928 1980637136 19.470 100 83 162 1 2056953440 51190816 25125488
23:43:35 5990 8192000000 10948225232 11369611264 1939260640 19.141 98 78 155 2 2014628864 51209856 24158368
23:43:48 3274 8192000000 10973855584 11389100032 1972459184 19.405 100 87 175 4 2056241984 55084416 28698384
23:43:59 1413 8192000000 10979292752 11394945024 1979454400 19.460 100 85 169 0 2063377648 56797808 27125440
23:44:09 4911 8192000000 10967985120 11391123456 1969151824 19.379 100 70 140 3 2049812448 57746960 22913664
23:44:21 3638 8192000000 10953742624 11367616512 1931968336 19.083 98 74 143 0 2012465456 57491232 23005888
23:44:32 2849 8192000000 10966406784 11386408960 1967690864 19.367 100 87 174 0 2056342080 60439232 28211984
23:44:43 2642 8192000000 10952732016 11365679104 1950277424 19.229 99 87 174 1 2033917872 56238016 27402432
23:44:52 3391 8192000000 10943233824 11361189888 1929670032 19.064 99 85 168 1 2011803696 55435568 26698096
23:45:02 2270 8192000000 10949475008 11358818304 1927776784 19.049 99 83 166 4 2011985520 57522640 26686096
23:45:12 3198 8192000000 10932264576 11346829312 1941720624 19.160 100 79 159 1 2018957408 52112496 25124288
23:45:22 1615 8192000000 10960281728 11370201088 1959044800 19.298 100 89 177 0 2039639264 52500480 28093984
23:45:32 9214 8192000000 10955241824 11379564544 1964333824 19.340 100 68 136 1 2040777600 54885856 21557920
23:45:52 4540 8192000000 10964047472 11384152064 1966798992 19.360 100 74 148 0 2046905952 56532560 23574400
23:46:22 12767 8192000000 10927457776 11379658752 1947428656 19.206 99 35 70 1 2007628336 48898800 11300880
23:46:59 6001 8192000000 10942919344 11377938432 1953345104 19.253 99 56 112 0 2022762640 51886336 17531200
23:47:14 7702 8192000000 10933982960 11376406528 1964022352 19.338 100 41 80 3 2027051088 50175296 12853440
23:47:31 5114 8192000000 10954338880 11379023872 1960922752 19.313 99 72 143 3 2032527104 48486240 23118112
23:47:43 6271 8192000000 10939347184 11369238528 1958060144 19.291 100 56 112 1 2023854352 48054224 17739984
23:47:58 6494 8192000000 10940734304 11371528192 1961104720 19.315 100 41 82 1 2021422592 47018128 13299744
23:48:15 5341 8192000000 10950410304 11376893952 1963714704 19.336 100 53 106 0 2029474928 48140560 17619664
23:48:28 2595 8192000000 10968593056 11382468608 1972357008 19.404 100 73 146 1 2045003280 49896336 22749936
23:48:38 4140 8192000000 10973394992 11401969664 1979881584 19.464 100 67 134 1 2053010864 51954464 21174816
23:48:53 5175 8192000000 10985822512 11409698816 1992105728 19.560 100 64 129 2 2068925248 56713904 20105616
23:49:13 7565 8192000000 10964731568 11402043392 1974596480 19.422 100 43 82 1 2047542784 58970464 13975840
23:49:28 16555 8192000000 10949296320 11395694592 1961577216 19.319 99 41 83 1 2037125904 61206432 14342256
23:49:58 22306 8192000000 10947403712 11392352256 1967303456 19.364 100 39 78 2 2039589984 58299808 13986720
23:50:28 23712 8192000000 10932002752 11382218752 1960474688 19.310 100 27 54 1 2019947872 49751136 9722048
23:51:12 30832 8192000000 10919229408 11372421120 1917006736 18.963 98 24 48 0 1978689248 53124464 8558048
23:51:50 7191 8192000000 10933804288 11380199424 1946959728 19.202 100 28 56 0 2011023632 54156656 9907248
23:52:05 10332 8192000000 10929972848 11377999872 1951213248 19.236 100 29 58 1 2015791344 54121248 10456848
23:52:32 28692 8192000000 10921691040 11379822592 1922876048 19.010 98 32 64 2 1986566224 52436048 11254128
23:53:12 24899 8192000000 10916435072 11368005632 1930658672 19.072 99 31 60 1 1992809456 51666816 10483968
23:53:54 34090 8192000000 10908746320 11382464512 1922823904 19.009 99 24 48 2 1982617952 51581488 8212560
23:54:40 33890 8192000000 10887714160 11356282880 1909679376 18.904 99 8 16 0 1957844896 44450032 3715488
23:55:23 23640 8192000000 10885613504 11350769664 1901269840 18.837 98 17 34 1 1939649360 32708944 5670576
23:55:54 31796 8192000000 10858182992 11305758720 1897495056 18.806 98 15 30 1 1920069888 18029760 4545072
23:56:34 35434 8192000000 10885478528 11328413696 1947932384 19.210 100 35 70 2 1970949984 13342064 9675536
23:57:20 2800 8192000000 10907069888 11332124672 1953032656 19.251 100 68 138 2 1984201872 11173712 19995504
23:57:33 18887 8192000000 10905303536 11347439616 1961698960 19.320 100 44 89 1 1988961312 14720128 12542224
23:58:01 17003 8192000000 10898268112 11355148288 1962976112 19.330 100 30 60 0 1990342640 18773088 8593440
23:58:24 17559 8192000000 10875097136 11340525568 1942448704 19.166 99 18 35 3 1963461104 16483056 4529344
23:59:56 39960 8192000000 10861459168 11329908736 1931956496 19.083 100 17 35 0 1953713824 16683920 5073408
00:00:53 57649 8192000000 10870215024 11340705792 1936335968 19.118 100 12 26 0 1954505568 15124624 3044976
00:02:05 134303 8192000000 10910033472 11347169280 1906657136 18.880 97 36 71 0 1926253152 10000064 9595952
00:04:27 77153 8192000000 10874862928 11328651264 1897282384 18.804 97 26 52 2 1915362784 10964592 7115808
00:05:51 56480 8192000000 10892093408 11344408576 1953889344 19.257 100 17 34 0 1970275808 11836928 4549536
00:08:15 1675 8192000000 10948244848 11376680960 1994224080 19.577 100 79 164 2 2025178000 7885536 23068384
00:08:24 19756 8192000000 10909877360 11379302400 1988697296 19.533 100 46 92 0 2013221776 11313392 13211088
00:09:36 41423 8192000000 10907521776 11363659776 1966998704 19.362 99 33 66 4 1986457648 9245296 10213648
00:10:36 56041 8192000000 10904076512 11378659328 1979021872 19.457 100 10 20 0 1993748608 11713408 3013328
00:11:39 30775 8192000000 10896640800 11364446208 1941006224 19.155 98 15 31 2 1951615920 6536176 4073520
00:12:16 22201 8192000000 10891092768 11369324544 1975080768 19.426 100 12 24 1 1988328960 9719616 3528576
00:13:01 35755 8192000000 10895714720 11367800832 1957612352 19.287 99 8 16 0 1969673392 9294288 2766752
00:13:43 60227 8192000000 10909461424 11380379648 1966674032 19.359 99 23 46 0 1990985664 16894224 7417408
00:15:51 78864 8192000000 10926048736 11397550080 1981570640 19.477 100 20 40 0 2000269616 13437136 5261840
00:17:22 69698 8192000000 10911573408 11411169280 1986666640 19.517 100 9 16 2 2010823232 21805072 2351520
00:18:38 30055 8192000000 10906373344 11385892864 1987689200 19.526 100 5 10 1 2005574000 16732496 1152304
00:19:22 38599 8192000000 10924521024 11387478016 1976538976 19.437 99 31 60 0 1999506112 14274720 8692416
00:20:21 35153 8192000000 10942894320 11408752640 2001195184 19.632 100 41 83 1 2030349632 17757504 11396944
00:21:02 52689 8192000000 10922910896 11408306176 1975194720 19.427 99 17 34 0 1997085184 17075232 4815232
00:22:15 90452 8192000000 10929080144 11391496192 1972142000 19.402 99 23 46 3 1999780112 20510624 7127488
00:23:52 52038 8192000000 10917243184 11380408320 1956870832 19.281 98 19 36 1 1977810976 15538128 5402016
00:24:55 68617 8192000000 10902537520 11392016384 1930487600 19.071 97 16 32 0 1957286688 21783104 5015984
00:26:28 80627 8192000000 10912040736 11376173056 1882655248 18.687 95 12 24 2 1899146448 13332400 3158800
00:28:03 51111 8192000000 10936333248 11378065408 1925792064 19.033 97 35 70 2 1947986928 11774672 10420192
00:29:04 47259 8192000000 10912471520 11380068352 1928767952 19.057 97 36 72 0 1951936944 12942128 10226864
00:29:57 78407 8192000000 10898914720 11363094528 1898682272 18.816 96 13 26 1 1916018752 14029296 3307184
00:31:26 55300 8192000000 10878443680 11347611648 1877204464 18.643 95 22 43 0 1897912608 14499152 6208992
00:32:31 91712 8192000000 10869509472 11347697664 1937972912 19.131 99 24 48 0 1957311040 12039248 7298880
00:34:12 32180 8192000000 10892449216 11345027072 1903805648 18.857 97 31 61 0 1920237184 8125824 8305712
00:34:51 18412 8192000000 10887130368 11335094272 1935132112 19.108 99 38 76 0 1956256480 10155744 10968624
00:36:07 42347 8192000000 10858455872 11334180864 1922178912 19.004 99 19 38 0 1939057776 11658864 5220000
00:36:56 34884 8192000000 10851468016 11334828032 1917666352 18.968 99 5 10 1 1932286048 13168240 1451456
00:37:37 29544 8192000000 10837118560 11315634176 1898503296 18.814 98 9 18 0 1913399840 12597792 2298752
00:38:13 8620 8192000000 10859472944 11342360576 1939463392 19.142 100 12 24 3 1955624048 11957632 4203024
00:39:09 64219 8192000000 10856881520 11321413632 1904547520 18.863 98 8 15 1 1914036832 7187648 2301664
00:40:35 77358 8192000000 10840105936 11305152512 1879049312 18.657 97 15 29 0 1893645824 9582000 5014512
00:41:58 59898 8192000000 10848023856 11330293760 1875833968 18.631 97 16 32 2 1892044128 11193024 5017136
00:43:53 80264 8192000000 10865407744 11334389760 1900696384 18.832 99 17 33 1 1917574432 12079072 4798976
00:45:23 99459 8192000000 10867046928 11324899328 1864182768 18.537 96 16 32 1 1881382560 12682528 4517264
00:47:18 31923 8192000000 10875498880 11326021632 1918290400 18.973 99 30 60 0 1934479280 7921456 8267424
00:47:56 39329 8192000000 10870624016 11343368192 1941737072 19.161 100 23 46 1 1960011392 11435904 6838416
00:48:41 58131 8192000000 10873899312 11346829312 1906668832 18.880 98 20 40 0 1924162352 11521024 5972496
00:49:45 40861 8192000000 10891633328 11351977984 1946672336 19.200 100 26 52 0 1963380432 9830208 6877888
00:50:32 83777 8192000000 10890937008 11359256576 1943302368 19.173 99 20 40 0 1960191360 11138976 5750016
00:52:11 35006 8192000000 10891674416 11368968192 1929391984 19.062 98 19 38 2 1951910528 17189392 5329152
00:52:53 28190 8192000000 10901585760 11373461504 1964604176 19.343 100 27 54 1 1986893808 14046656 8242976
00:53:28 196466 8192000000 10912627616 11383894016 1918394928 18.974 97 19 36 1 1938319712 14538704 5386080
00:56:56 38284 8192000000 10875579056 11335499776 1857758992 18.485 94 36 72 1 1874446144 7153104 9534048
00:57:50 32295 8192000000 10877313424 11350392832 1954627536 19.263 100 29 56 3 1972757344 10692560 7437248
00:58:57 39121 8192000000 10856391472 11325865984 1927245248 19.045 98 17 33 0 1938080608 5287776 5547584
01:00:22 41707 8192000000 10874543792 11352125440 1936680592 19.120 98 6 12 0 1943900336 5865264 1354480
01:01:48 59244 8192000000 10889864336 11377782784 1964611856 19.343 99 10 20 0 1976025984 8729104 2685024
01:02:53 53889 8192000000 10898478224 11377254400 1979369568 19.460 100 10 20 1 1991844224 8908016 3566640
01:04:00 36146 8192000000 10885623488 11362426880 1964336240 19.340 99 22 44 1 1978654880 7629216 6689424
01:04:50 64135 8192000000 10901400448 11375882240 1968919040 19.377 99 24 46 3 1985404544 9817536 6667968
01:06:01 122444 8192000000 10902072944 11389878272 1927503920 19.047 97 12 24 1 1941111088 9552096 4055072
01:08:16 75037 8192000000 10909541024 11395133440 1948209184 19.212 98 15 30 1 1968989872 16200560 4580128
01:09:37 60301 8192000000 10941147280 11409252352 1978229056 19.451 99 23 46 0 2004278544 19650896 6398592
01:10:45 80175 8192000000 10925747392 11410915328 1970628320 19.390 99 18 36 0 2000204848 23901728 5674800
01:12:15 55551 8192000000 10909200336 11392884736 1943102256 19.172 98 5 10 1 1964424304 20178624 1143424
01:13:17 100136 8192000000 10913034208 11396497408 1925601360 19.032 97 16 32 1 1944760720 14666960 4492400
01:15:03 43529 8192000000 10933080656 11391553536 1969032736 19.378 99 22 44 1 1989948416 14474240 6441440
01:15:55 25157 8192000000 10901461760 11357515776 1950120096 19.227 99 29 58 0 1966929936 8955888 7853952
01:16:28 36146 8192000000 10908882448 11369783296 1940849168 19.154 98 36 72 0 1961530992 10541664 10140160
01:17:21 90597 8192000000 10898979248 11375685632 1961670704 19.319 99 36 71 1 1981377552 9275856 10430992
01:19:01 73935 8192000000 10892497904 11370442752 1942714240 19.168 98 23 44 1 1958668272 9367040 6586992
01:20:27 75816 8192000000 10887197984 11367424000 1901212448 18.836 96 21 41 3 1922486064 15320912 5952704
01:22:39 40903 8192000000 10892452672 11370102784 1956201632 19.276 100 17 31 0 1976212160 15148480 4862048
01:23:31 69888 8192000000 10876690352 11361820672 1913963344 18.938 97 10 20 0 1936571472 19148640 3459488
01:24:55 90625 8192000000 10853880384 11338440704 1849122240 18.415 95 13 26 0 1872643360 19416816 4104304
01:26:47 39805 8192000000 9286954848 9562411008 439724448 5.094 23 3 6 0 449142016 8761872 655696

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 80 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 22-02-2021 01:29:32 to 22-02-2021 01:29:34.

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          235032
MON$OLDEST_ACTIVE               235033
MON$OLDEST_SNAPSHOT             235033
MON$NEXT_TRANSACTION            235033
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                       2027232
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:129: 
:130: mscs-test-161.budzdorov.ru    Mon Feb 22 01:27:38 2021
:131:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:132: 
--- end of diff output ---

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

22.02.21 01:29:35. 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-02-22 01:29:38 No severe PSQL-related problems occured
22.02.21 01:29:39. End of report.