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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16949868 kB
MemAvailable 31120672 kB
Buffers 0 kB
Cached 14770136 kB
SwapCached 3312 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-27 16:27:21
DTS_END                         2021-02-27 16:27:21.0520
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51916
TRN_ID                          232916
ATT_ID                          702
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: 9348.44 19827 1121813
customer order: creation 165.12 369 19814
customer order: refuse 13.28 347 1594
order to supplier: creation 44.06 1276 5287
order to supplier: removal 3.25 122879 390
invoice (draft): creation 43.63 3294 5236
invoice (draft): removal 54.73 933 6567
invoice accept: apply 39.52 19254 4742
invoice accept: cancel 50.21 780 6025
customer reserve: creation 3687.58 189 442509
customer reserve: removal 4952.61 62 594313
realization accept: apply 80.86 175 9703
realization accept: cancel 90.59 107 10871
payment from customer: creation 56.90 105 6828
payment from customer: removal 5.47 71 656
payment to supplier: creation 45.98 128 5518
payment to supplier: removal 3.16 54 379
service: total inventory turnovers 4.74 1230 569
service: total monetary turnovers 5.99 67 719
service: aggregate perf. data 0.74 23883 89
service: refresh index statistics 0.03 221332 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-02-2021 16:29:35 to 27-02-2021 16:29:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3097
TEST_TIME 2 5357
TEST_TIME 3 5336
TEST_TIME 4 5266
TEST_TIME 5 4748
TEST_TIME 6 4782
TEST_TIME 7 5059
TEST_TIME 8 5049
TEST_TIME 9 4986
TEST_TIME 10 5174
TEST_TIME 11 5336
TEST_TIME 12 5930
TEST_TIME 13 6616
TEST_TIME 14 6786
TEST_TIME 15 7075
TEST_TIME 16 7628
TEST_TIME 17 8058
TEST_TIME 18 8204
TEST_TIME 19 9171
TEST_TIME 20 9059
TEST_TIME 21 8933
TEST_TIME 22 9065
TEST_TIME 23 8965
TEST_TIME 24 9230
TEST_TIME 25 9796
TEST_TIME 26 9837
TEST_TIME 27 9946
TEST_TIME 28 10529
TEST_TIME 29 11954
TEST_TIME 30 11909
TEST_TIME 31 11602
TEST_TIME 32 11587
TEST_TIME 33 11298
TEST_TIME 34 11105
TEST_TIME 35 10991
TEST_TIME 36 10928
TEST_TIME 37 10869
TEST_TIME 38 10683
TEST_TIME 39 10751
TEST_TIME 40 10590
TEST_TIME 41 10479
TEST_TIME 42 10542
TEST_TIME 43 10607
TEST_TIME 44 10467
TEST_TIME 45 10293
TEST_TIME 46 10185
TEST_TIME 47 10189
TEST_TIME 48 10097
TEST_TIME 49 9981
TEST_TIME 50 9968
TEST_TIME 51 9849
TEST_TIME 52 9841
TEST_TIME 53 9809
TEST_TIME 54 9875
TEST_TIME 55 9973
TEST_TIME 56 9906
TEST_TIME 57 9863
TEST_TIME 58 9938
TEST_TIME 59 9959
TEST_TIME 60 9916
TEST_TIME 61 9979
TEST_TIME 62 9977
TEST_TIME 63 10025
TEST_TIME 64 10080
TEST_TIME 65 10072
TEST_TIME 66 10067
TEST_TIME 67 10083
TEST_TIME 68 10062
TEST_TIME 69 9955
TEST_TIME 70 9882
TEST_TIME 71 9842
TEST_TIME 72 9807
TEST_TIME 73 9782
TEST_TIME 74 9735
TEST_TIME 75 9737
TEST_TIME 76 9677
TEST_TIME 77 9659
TEST_TIME 78 9662
TEST_TIME 79 9605
TEST_TIME 80 9567
TEST_TIME 81 9549
TEST_TIME 82 9663
TEST_TIME 83 9615
TEST_TIME 84 9667
TEST_TIME 85 9668
TEST_TIME 86 9660
TEST_TIME 87 9694
TEST_TIME 88 9665
TEST_TIME 89 9740
TEST_TIME 90 9772
TEST_TIME 91 9779
TEST_TIME 92 9720
TEST_TIME 93 9643
TEST_TIME 94 9633
TEST_TIME 95 9621
TEST_TIME 96 9573
TEST_TIME 97 9531
TEST_TIME 98 9496
TEST_TIME 99 9481
TEST_TIME 100 9486
TEST_TIME 101 9538
TEST_TIME 102 9553
TEST_TIME 103 9543
TEST_TIME 104 9513
TEST_TIME 105 9577
TEST_TIME 106 9590
TEST_TIME 107 9565
TEST_TIME 108 9642
TEST_TIME 109 9619
TEST_TIME 110 9679
TEST_TIME 111 9650
TEST_TIME 112 9571
TEST_TIME 113 9562
TEST_TIME 114 9549
TEST_TIME 115 9492
TEST_TIME 116 9485
TEST_TIME 117 9458
TEST_TIME 118 9457
TEST_TIME 119 9425
TEST_TIME 120 9355

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 27-02-2021 16:29:38 to 27-02-2021 16:29:42.

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 1532027 1532027 0 0.00 0 16749 7 0 0
doc_list_biud 1532026 1532026 0 0.00 0 94093 31 0 0
sp_add_invoice_to_stock 4858 4742 116 2.38 47 172674 19255 0 116
sp_cancel_adding_invoice 6025 6025 0 0.00 5 85276 780 0 0
sp_cancel_client_order 1594 1594 0 0.00 5 9634 348 0 0
sp_cancel_customer_reserve 594313 594313 0 0.00 1 60540 62 0 0
sp_cancel_pay_from_customer 656 656 0 0.00 3 3695 71 0 0
sp_cancel_pay_to_supplier 379 379 0 0.00 3 1726 55 0 0
sp_cancel_supplier_invoice 6577 6567 10 0.15 2 94101 933 0 10
sp_cancel_supplier_order 390 390 0 0.00 7 1138523 122879 0 0
sp_cancel_write_off 10871 10871 0 0.00 1 16402 108 0 0
sp_client_order 19814 19814 0 0.00 4 52398 370 0 0
sp_customer_reserve 442509 442509 0 0.00 0 42711 189 0 0
sp_fill_shopping_cart 30337 30337 0 0.00 1 22582 40 0 0
sp_fill_shopping_cart_clo_res 442493 442493 0 0.00 0 19328 14 0 0
sp_get_clo_for_invoice 4726 4726 0 0.00 0 34660 346 0 0
sp_kill_cost_storno 17931 17931 0 0.00 0 8676 56 0 0
sp_kill_qstorno_ret_qs2qd 1206454 1206454 0 0.00 0 94091 34 0 0
sp_kill_qty_storno 634189 634189 0 0.00 0 94092 73 0 0
sp_lock_selected_doc 19850 19850 0 0.00 0 10929 5 0 0
sp_make_cost_storno 26775 26775 0 0.00 0 13225 51 0 0
sp_multiply_rows_for_pdistr 26775 26775 0 0.00 0 5955 26 0 0
sp_multiply_rows_for_qdistr 19814 19814 0 0.00 0 52391 164 0 0
sp_pay_from_customer 6828 6828 0 0.00 4 21548 106 0 0
sp_pay_to_supplier 5518 5518 0 0.00 4 10103 128 0 0
sp_payment_common 12346 12346 0 0.00 2 21541 28 0 0
sp_qd_handle_on_cancel_clo 1594 1594 0 0.00 0 9593 318 0 0
sp_qd_handle_on_invoice_upd_sts 10751 10751 0 0.00 0 22969 343 0 0
sp_qd_handle_on_reserve_upd_sts 9703 9703 0 0.00 0 19060 66 0 0
sp_reserve_write_off 9703 9703 0 0.00 6 19075 176 0 0
sp_supplier_invoice 5236 5236 0 0.00 7 92923 3295 0 0
sp_supplier_order 5287 5287 0 0.00 4 47701 1276 0 0
srv_aggregate_perf_data 89 89 0 0.00 3075 377254 23884 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1372 123660 32043 0 0
srv_find_qd_qs_mism 1076419 1076419 0 0.00 0 16747 6 0 0
srv_make_invnt_saldo 569 569 0 0.00 35 66215 1231 0 0
srv_make_money_saldo 719 719 0 0.00 1 22976 67 0 0
srv_recalc_idx_stat 4 4 0 0.00 82105 464697 221333 0 0
t$perf-abend:sp_add_invoice_to_stock 116 116 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4742 4742 0 0.00 0 12243 168 0 0
t$perf-norm:sp_cancel_adding_invoice 393 393 0 0.00 0 3599 98 0 0
t$perf-norm:sp_cancel_client_order 1594 1594 0 0.00 0 4362 16 0 0
t$perf-norm:sp_cancel_customer_reserve 645 645 0 0.00 0 2049 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 656 656 0 0.00 0 784 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 379 379 0 0.00 0 510 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 375 375 0 0.00 0 3716 26 0 0
t$perf-norm:sp_cancel_supplier_order 390 390 0 0.00 0 28795 1786 0 0
t$perf-norm:sp_cancel_write_off 990 990 0 0.00 0 1731 6 0 0
t$perf-norm:sp_client_order 19814 19814 0 0.00 0 8360 18 0 0
t$perf-norm:sp_customer_reserve 993 993 0 0.00 0 4469 20 0 0
t$perf-norm:sp_pay_from_customer 6828 6828 0 0.00 0 5111 10 0 0
t$perf-norm:sp_pay_to_supplier 5518 5518 0 0.00 0 6668 11 0 0
t$perf-norm:sp_reserve_write_off 9703 9703 0 0.00 0 12347 15 0 0
t$perf-norm:sp_supplier_invoice 5236 5236 0 0.00 0 6560 19 0 0
t$perf-norm:sp_supplier_order 5287 5287 0 0.00 0 5863 14 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 1886 39 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 3355 27 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 2237 21 0 0
t$perf-norm:srv_make_money_saldo 719 719 0 0.00 0 2547 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 9682 9450 232 2.39 0 10275 21 0 232
v_all_customers 36472 36472 0 0.00 0 18 1 0 0
v_all_suppliers 29368 29368 0 0.00 0 50 1 0 0
v_all_wares 39628 39628 0 0.00 0 71 1 0 0
v_cancel_adding_invoice 786 786 0 0.00 0 1133 8 0 0
v_cancel_client_order 3188 3188 0 0.00 0 2837 5 0 0
v_cancel_customer_prepayment 1312 1312 0 0.00 0 1573 8 0 0
v_cancel_customer_reserve 1290 1290 0 0.00 0 2734 8 0 0
v_cancel_payment_to_supplier 758 758 0 0.00 0 928 5 0 0
v_cancel_supplier_invoice 770 750 20 2.59 0 965 17 0 20
v_cancel_supplier_order 780 780 0 0.00 0 738 4 0 0
v_cancel_write_off 1980 1980 0 0.00 0 2042 14 0 0
v_max_id_clo_ord 5287 5287 0 0.00 0 266 1 0 0
v_max_id_clo_res 993 993 0 0.00 0 713 4 0 0
v_max_id_ord_sup 5236 5236 0 0.00 0 4492 3 0 0
v_max_non_paid_invoice 1357 1357 0 0.00 0 425 3 0 0
v_max_non_paid_realizn 3480 3480 0 0.00 0 2382 3 0 0
v_min_id_clo_ord 5287 5287 0 0.00 0 3906 5 0 0
v_min_id_clo_res 993 993 0 0.00 0 3516 6 0 0
v_min_id_ord_sup 5236 5236 0 0.00 0 7220 8 0 0
v_min_non_paid_invoice 5518 5518 0 0.00 0 8192 12 0 0
v_min_non_paid_realizn 6828 6828 0 0.00 0 10402 17 0 0
v_our_firm 9852 9852 0 0.00 0 20 1 0 0
v_reserve_write_off 19406 19406 0 0.00 0 6032 6 0 0
x_lock_depdocs_on_canc_invoice 12217 12217 0 0.00 0 11942 131 0 0
x_lock_depdocs_on_canc_sup_ord 390 390 0 0.00 0 3982 349 0 0
x_make_qstorno_1000_1200 5287 5287 0 0.00 2 47688 1202 0 0
x_make_qstorno_1200_2000 5236 5236 0 0.00 3 88098 3147 0 0
x_make_qstorno_2100_3300 442509 442509 0 0.00 0 42277 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-02-2021 16:29:43 to 27-02-2021 16:29:47.

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
13:57:24 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:30 6813 8192000000 10058911024 10337796096 802845792 8.925 67 49 101 0 821921536 2172048 16903696
13:57:47 21213 8192000000 10304763824 10618060800 1343568912 14.090 100 79 158 0 1373698688 3851920 26277856
13:58:17 18027 8192000000 10357110816 10670702592 1411546256 14.698 100 90 180 0 1445838272 4758512 29533504
13:58:45 22175 8192000000 10394525248 10715504640 1444687312 14.991 100 86 172 0 1478431584 5922208 27822064
13:59:21 24433 8192000000 10419482288 10749100032 1472869120 15.239 100 86 172 0 1508727216 6990832 28867264
14:00:27 25529 8192000000 10477430128 10812309504 1530234064 15.739 100 86 172 0 1565640128 8322992 27083072
14:01:03 21224 8192000000 10503262528 10848915456 1560013296 15.996 100 81 162 0 1593750928 8845456 24892176
14:01:33 15557 8192000000 10524247152 10873212928 1577439568 16.146 100 77 153 0 1610382784 9607856 23335360
14:01:57 10869 8192000000 10551350144 10900160512 1605152752 16.383 100 88 174 1 1642183376 10550496 26480128
14:02:18 20988 8192000000 10586189472 10940354560 1631952064 16.611 100 84 168 1 1667814480 10784368 25078048
14:02:50 13391 8192000000 10608506256 10969382912 1659671008 16.846 100 81 162 1 1694562320 11553936 23337376
14:03:16 8743 8192000000 10628550256 10990944256 1682185280 17.036 100 87 174 1 1719691456 11651104 25855072
14:03:33 13259 8192000000 10635941840 11001925632 1697211728 17.162 100 86 172 1 1733996128 11703744 25080656
14:03:54 7682 8192000000 10645675056 11016871936 1707066576 17.244 100 83 167 1 1744629488 12906336 24656576
14:04:08 8873 8192000000 10659142112 11028090880 1718253984 17.338 100 82 162 3 1754364768 13049456 23061328
14:04:24 6921 8192000000 10669616208 11039719424 1722932192 17.377 100 87 174 2 1762327776 14597728 24797856
14:04:38 5889 8192000000 10679155248 11050622976 1734874368 17.476 100 91 182 0 1776479248 14780320 26824560
14:04:50 5922 8192000000 10684555408 11054510080 1740588560 17.524 100 82 162 3 1778729024 13951040 24189424
14:05:04 8189 8192000000 10697445792 11071885312 1751980416 17.618 100 84 168 0 1789279584 13042752 24256416
14:05:20 3814 8192000000 10700250624 11076481024 1762542432 17.705 100 73 144 1 1795364064 12278096 20543536
14:05:33 3977 8192000000 10701786720 11081875456 1777459968 17.829 100 78 154 2 1810666080 11525280 21680832
14:05:45 4602 8192000000 10717846992 11097239552 1783577712 17.879 100 82 161 1 1819234256 12670912 22985632
14:05:56 2947 8192000000 10730895584 11108114432 1789948064 17.931 100 85 170 2 1828123312 13285504 24889744
14:06:06 3135 8192000000 10732639472 11111870464 1795820208 17.980 100 80 157 1 1831021616 13219632 21981776
14:06:15 4001 8192000000 10750350336 11129503744 1802334160 18.033 100 90 180 1 1842476976 14204880 25937936
14:06:26 4183 8192000000 10754414672 11133087744 1811814320 18.111 100 85 168 5 1847692352 13091040 22786992
14:06:36 2284 8192000000 10758608464 11140841472 1816474016 18.149 100 88 173 0 1854273568 13615088 24184464
14:06:45 11289 8192000000 10761278528 11140800512 1818868608 18.168 100 78 155 1 1853584064 14144416 20571040
14:07:03 3406 8192000000 10771416416 11155681280 1827003536 18.235 100 85 169 1 1864285280 13524192 23757552
14:07:13 1696 8192000000 10781662464 11164106752 1841918064 18.356 100 93 185 2 1881776816 13903264 25955488
14:07:21 1652 8192000000 10788092976 11170799616 1841028192 18.349 100 94 186 0 1882154784 15226288 25900304
14:07:29 2297 8192000000 10790775120 11174674432 1842408592 18.360 100 95 189 1 1883238144 14652240 26177312
14:07:38 2173 8192000000 10785464784 11174289408 1847028720 18.398 100 93 187 1 1887066496 13541904 26495872
14:07:47 1715 8192000000 10794541360 11182440448 1853523184 18.451 100 92 185 1 1892298976 13225216 25550576
14:07:55 2651 8192000000 10791027136 11179757568 1854641024 18.460 100 94 189 1 1893440256 12169344 26629888
14:08:05 3640 8192000000 10811179136 11194155008 1861497824 18.515 100 93 185 3 1902248144 13996096 26754224
14:08:14 1652 8192000000 10808452720 11195461632 1863483552 18.532 100 93 184 0 1903220576 14010256 25726768
14:08:22 1488 8192000000 10810415200 11200163840 1868620672 18.573 100 97 195 1 1910632928 14200784 27811472
14:08:30 43242 8192000000 10795615264 11194212352 1861197184 18.513 100 59 116 1 1885658896 7446704 17015008
14:09:20 18300 8192000000 10792330592 11201548288 1867010288 18.560 100 58 116 0 1892594080 9226720 16357072
14:09:45 14286 8192000000 10772550848 11202285568 1868337600 18.571 100 40 80 0 1889542032 9963328 11241104
14:10:07 6375 8192000000 10784337056 11205529600 1872485120 18.604 100 43 87 0 1893223216 8402832 12335264
14:10:19 4937 8192000000 10780649984 11203776512 1872250816 18.602 100 37 75 0 1890378016 7861824 10265376
14:10:30 4217 8192000000 10794822208 11213422592 1878625744 18.654 100 38 76 1 1898027072 8919680 10481648
14:10:42 9501 8192000000 10779364304 11209814016 1875870080 18.632 100 24 46 2 1888418320 5690896 6857344
14:10:59 5494 8192000000 10790144640 11216347136 1884393840 18.701 100 35 69 3 1900815200 6960992 9460368
14:11:15 10491 8192000000 10811630240 11228864512 1885664144 18.711 100 24 47 1 1898136080 6099424 6372512
14:11:32 8041 8192000000 10807709712 11229331456 1893856880 18.777 100 24 48 0 1907131168 6330608 6943680
14:11:46 4757 8192000000 10804315360 11233832960 1897792176 18.809 100 30 60 1 1913284368 6707472 8784720
14:11:58 5208 8192000000 10798734752 11232874496 1897559856 18.807 100 29 58 1 1912058080 6201456 8296768
14:12:09 14582 8192000000 10804723600 11237130240 1897391936 18.805 100 21 42 1 1912971632 9867056 5712640
14:12:32 8652 8192000000 10813209840 11243814912 1901130800 18.835 100 16 33 0 1912122128 5671056 5320272
14:12:47 10141 8192000000 10816037040 11245363200 1901621136 18.839 100 20 41 0 1913566224 6148912 5796176
14:13:03 10744 8192000000 10816446768 11246899200 1907441040 18.886 100 15 30 0 1917317088 5450832 4425216
14:13:20 70383 8192000000 10833004960 11258585088 1913738496 18.937 100 31 63 0 1929684064 5291744 10653824
14:14:37 2925 8192000000 10839560608 11265769472 1920016928 18.987 100 63 126 0 1949260800 11477376 17766496
14:14:49 4509 8192000000 10846256576 11266068480 1920030720 18.987 100 40 79 1 1939291664 8198096 11062848
14:15:03 3263 8192000000 10847385840 11268272128 1920362288 18.990 100 36 72 1 1937903008 7443024 10097696
14:15:13 4386 8192000000 10843764080 11274203136 1922962576 19.011 100 45 91 1 1943769216 8030448 12776192
14:15:25 5840 8192000000 10826926208 11267268608 1922319440 19.005 100 35 71 2 1939664944 7310496 10035008
14:15:42 5688 8192000000 10834539632 11267584000 1922799344 19.009 100 32 64 3 1938476416 5532096 10144976
14:15:55 4485 8192000000 10804370864 11230134272 1860295376 18.506 97 30 60 2 1875633312 6628048 8709888
14:16:09 7835 8192000000 10812753856 11233734656 1869375312 18.579 98 27 53 0 1887465584 11219888 6870384
14:16:24 6544 8192000000 10814347136 11240914944 1881357392 18.676 99 29 58 0 1896132240 6383264 8391584
14:16:40 9624 8192000000 10805895664 11234607104 1871921408 18.600 99 29 57 2 1886289184 5764896 8602880
14:16:59 54982 8192000000 10811156112 11233034240 1873202592 18.610 99 31 59 3 1887834080 5864560 8766928
14:18:00 7317 8192000000 10821910624 11251302400 1898996880 18.818 100 24 48 0 1916524416 10319840 7207696
14:18:14 7099 8192000000 10763474736 11179139072 1810551952 18.100 96 31 62 1 1826414832 7074736 8788144
14:18:28 5558 8192000000 10761413232 11186417664 1809907120 18.095 97 28 54 1 1823245760 5805552 7533088
14:18:42 7301 8192000000 10773315424 11185176576 1837498240 18.320 99 42 85 0 1856388832 6568800 12321792
14:18:56 6745 8192000000 10764900048 11190317056 1840737648 18.347 99 24 47 1 1857566736 9936064 6893024
14:19:09 7533 8192000000 10725468448 11144978432 1754324544 17.637 95 24 46 0 1766296544 5901312 6070688
14:19:22 9728 8192000000 10720558960 11130929152 1740554624 17.523 95 29 58 2 1754008592 4813952 8640016
14:19:40 6038 8192000000 10740555808 11159674880 1796663936 17.987 98 28 56 1 1809783776 5167072 7952768
14:19:55 4130 8192000000 10723879472 11136147456 1801985424 18.030 100 26 50 2 1816601104 5978048 8637632
14:20:06 6356 8192000000 10725297376 11144159232 1784692944 17.888 98 32 64 2 1801421568 7274672 9453952
14:20:18 8634 8192000000 10673523360 11094245376 1734844128 17.476 97 20 38 2 1746558400 6063152 5651120
14:20:33 6283 8192000000 10660919072 11059437568 1716578224 17.324 97 21 42 0 1728006144 5215504 6212416
14:20:48 6606 8192000000 10707173376 11120865280 1788745664 17.921 100 34 68 1 1804456256 4996816 10713776
14:21:04 71050 8192000000 10708712400 11127443456 1722194592 17.370 95 30 59 4 1735174432 4634384 8345456
14:22:27 11952 8192000000 10718002416 11139276800 1774942256 17.808 98 20 40 1 1786154608 5872080 5340272
14:22:46 4442 8192000000 10731689408 11145867264 1801040704 18.022 99 40 81 0 1818872304 6502912 11328688
14:22:59 5862 8192000000 10729040528 11150573568 1802882096 18.038 99 26 52 0 1816411856 5840608 7689152
14:23:12 4705 8192000000 10737577776 11157389312 1805484784 18.059 99 24 48 1 1819596800 7068640 7043376
14:23:26 7710 8192000000 10746586768 11164323840 1776384928 17.820 97 31 62 5 1794811280 9365232 9061120
14:23:40 5075 8192000000 10736733728 11162456064 1812655744 18.118 99 37 74 1 1830451392 6956592 10839056
14:23:55 4399 8192000000 10754428464 11170816000 1832139536 18.277 100 27 54 1 1846493952 6494896 7859520
14:24:06 4773 8192000000 10751601552 11177185280 1842876416 18.364 100 42 85 0 1860870512 5511136 12482960
14:24:18 10381 8192000000 10757186432 11184996352 1846383072 18.393 100 24 48 0 1859274464 5144016 7747376
14:24:34 4710 8192000000 10761554560 11191214080 1852298096 18.441 100 22 44 1 1864244512 5476464 6469952
14:24:45 13293 8192000000 10765167600 11197444096 1855585696 18.467 100 20 40 2 1867032384 5619872 5826816
14:25:08 6647 8192000000 10786050976 11201908736 1860391104 18.506 100 26 51 1 1874842016 5745168 8705744
14:25:21 7596 8192000000 10774274384 11201748992 1859691088 18.501 100 12 24 1 1868851952 6058496 3102368
14:25:35 53659 8192000000 10792722976 11211608064 1865442032 18.547 100 39 79 1 1883766832 6251920 12072880
14:26:42 23334 8192000000 10800543216 11220512768 1873223232 18.610 100 29 60 3 1886956144 5301568 8431344
14:27:12 7675 8192000000 10800672944 11228618752 1885527072 18.710 100 28 54 1 1899056112 6276800 7252240
14:27:27 3994 8192000000 10842202576 11250094080 1905168448 18.868 100 61 118 1 1928487040 6682960 16635632
14:27:52 35104 8192000000 10847118640 11265114112 1910973456 18.914 100 64 126 2 1937631856 9211968 17446432
14:28:37 13735 8192000000 10861931712 11273510912 1919678528 18.984 100 63 125 1 1951380048 14222960 17478560
14:28:58 12410 8192000000 10871719680 11280547840 1928219632 19.053 100 67 135 1 1963986320 14818096 20948592
14:29:20 16022 8192000000 10886720624 11302023168 1934040000 19.099 100 65 130 0 1969772000 17592480 18139520
14:29:57 11544 8192000000 10891776704 11312357376 1950406096 19.230 100 73 146 1 1989333856 18512272 20415488
14:30:15 12155 8192000000 10881992352 11308613632 1948110528 19.211 100 54 105 1 1980757504 17640560 15006416
14:30:37 3694 8192000000 10895601808 11316011008 1952972960 19.250 100 56 112 2 1986708560 18187504 15548096
14:30:50 25301 8192000000 10903854224 11329155072 1954925440 19.266 100 52 104 0 1988706192 18976944 14803808
14:31:43 11550 8192000000 10894722992 11328737280 1962606304 19.327 100 42 83 1 1994997296 20185952 12205040
14:32:21 39756 8192000000 10916598624 11348013056 1972331232 19.404 100 37 74 0 2006477392 23104528 11041632
14:33:20 5694 8192000000 10920166528 11352805376 1979754112 19.463 100 46 92 0 2018064656 24204464 14106080
14:33:37 8318 8192000000 10924667488 11356086272 1981472592 19.476 100 53 105 0 2022591104 25750960 15367552
14:34:03 4915 8192000000 10939591104 11368148992 1984697424 19.502 100 55 110 0 2028272496 27215136 16359936
14:34:16 7742 8192000000 10942570800 11370508288 1990122640 19.545 100 67 134 0 2038610112 28255328 20232144
14:34:36 9417 8192000000 10935424720 11369185280 1987839840 19.527 100 53 106 0 2031122672 27175056 16107776
14:34:55 12852 8192000000 10938602048 11372679168 1995232144 19.585 100 63 122 1 2039689152 26503344 17953664
14:35:24 11110 8192000000 10948367424 11381727232 1995178592 19.585 100 58 116 1 2041730544 29490800 17061152
14:35:42 8163 8192000000 10943711360 11381514240 1995333968 19.586 100 49 98 2 2039467936 29574096 14559872
14:36:05 5660 8192000000 10954681488 11376164864 1982462480 19.484 99 73 146 1 2041720688 36965392 22292816
14:36:26 7948 8192000000 10963489792 11392540672 1995076416 19.584 100 58 114 0 2045591440 33490736 17024288
14:36:46 8450 8192000000 10962232400 11397222400 2000875440 19.630 100 46 92 0 2050529808 35835808 13818560
14:37:02 7372 8192000000 10973329024 11398860800 2000512224 19.627 100 64 128 0 2056540400 36731824 19296352
14:37:19 6585 8192000000 10982633488 11406626816 2010156368 19.703 100 68 133 1 2068765936 38923424 19686144
14:37:37 4190 8192000000 10983658448 11412180992 2015285344 19.743 100 69 138 3 2076132960 39454384 21393232
14:37:48 3442 8192000000 10985553280 11411390464 2010686416 19.707 100 75 150 0 2077279120 43348800 23243904
14:38:00 4961 8192000000 10973657216 11410972672 2007673984 19.683 100 57 114 1 2065503408 39719024 18110400
14:38:13 3417 8192000000 10986103680 11414302720 2012014064 19.717 100 58 114 2 2070710192 39857824 18838304
14:38:25 3331 8192000000 10982013520 11413811200 2009023504 19.694 100 69 136 3 2073112496 41466624 22622368
14:38:36 2260 8192000000 10989913792 11415527424 2011886848 19.716 100 75 150 3 2078127520 42385072 23855600
14:38:46 5642 8192000000 10964524928 11377651712 1977809344 19.447 99 76 152 1 2045532848 43693840 24029664
14:38:58 3144 8192000000 10981822448 11397193728 1986083408 19.513 99 82 164 2 2057309456 45412320 25813728
14:39:08 3086 8192000000 10984167920 11408752640 2005232464 19.664 100 78 156 2 2077146224 46846368 25067392
14:39:18 4224 8192000000 10978097072 11399544832 1993555040 19.572 100 74 146 1 2061349376 45474880 22319456
14:39:31 4234 8192000000 10997203664 11417747456 2009637664 19.699 100 82 164 1 2081856208 47136256 25082288
14:39:42 3241 8192000000 10999273904 11422511104 2011752336 19.715 100 83 165 1 2085178528 48443088 24983104
14:39:54 6109 8192000000 11007199392 11428384768 2014418176 19.736 100 76 151 0 2086805104 48619168 23767760
14:40:08 2508 8192000000 10986007008 11410845696 2000762432 19.629 100 83 166 0 2074761920 47080832 26918656
14:40:18 1461 8192000000 11004195360 11418841088 2012386352 19.720 100 88 173 3 2085033648 45221392 27425904
14:40:26 3901 8192000000 11003981040 11430891520 2019685632 19.778 100 76 152 1 2090114720 46404208 24024880
14:40:38 2338 8192000000 11005556496 11435556864 2018751840 19.770 100 67 134 0 2085735648 45854144 21129664
14:40:50 10338 8192000000 11001757600 11435659264 2017789744 19.763 100 66 132 2 2086924448 48331120 20803584
14:41:07 5217 8192000000 10990558896 11420192768 1995108176 19.584 99 67 134 2 2063327072 46162016 22056880
14:41:20 19431 8192000000 10983698160 11419418624 1989864000 19.543 99 54 106 2 2053141520 45880016 17397504
14:41:47 10721 8192000000 10976485840 11408175104 1978567888 19.453 99 63 126 0 2049010128 50166464 20275776
14:42:06 1960 8192000000 10977754400 11393482752 1979263856 19.459 99 71 143 3 2056277408 53982832 23030720
14:42:15 2402 8192000000 10957037888 11368873984 1941836224 19.161 98 82 161 2 2022565520 57225440 23503856
14:42:27 2439 8192000000 10986133824 11405922304 1982255824 19.483 100 75 147 0 2063899376 58259120 23384432
14:42:37 4598 8192000000 10963640896 11375300608 1961109424 19.315 99 80 158 1 2043867552 57989488 24768640
14:42:49 3830 8192000000 10995296752 11410681856 1967055936 19.362 99 83 165 1 2053491952 60101776 26334240
14:43:02 4325 8192000000 10989960080 11413516288 1985278800 19.506 100 75 147 0 2070510912 61288320 23943792
14:43:14 7411 8192000000 10984533504 11417407488 1989175152 19.537 100 69 137 1 2074122432 63007344 21939936
14:43:29 4115 8192000000 11001426912 11427217408 1998929856 19.614 100 69 138 0 2081942928 60947696 22065376
14:43:41 3673 8192000000 10950764192 11368550400 1919218208 18.981 96 66 132 2 2002989120 62070912 21700000
14:43:51 1882 8192000000 10976765696 11383435264 1965704208 19.351 100 83 168 2 2049925280 57491440 26729632
14:44:01 1952 8192000000 10961873888 11376386048 1956021712 19.274 100 73 146 0 2039012464 59603040 23387712
14:44:10 1722 8192000000 10970550864 11383156736 1964748528 19.344 100 87 174 2 2052617584 60525568 27343488
14:44:18 6187 8192000000 10949901680 11370340352 1947536384 19.207 99 67 130 0 2028456496 60342336 20577776
14:44:32 3591 8192000000 10987625408 11401113600 1977612752 19.446 100 82 163 0 2065674032 62806640 25254640
14:44:42 2203 8192000000 10990330640 11408265216 1985778352 19.510 100 89 179 2 2073346704 59579568 27988784
14:44:52 3555 8192000000 10985941216 11400048640 1981925024 19.480 100 84 168 1 2065278912 57562832 25791056
14:45:02 5510 8192000000 10976559216 11387936768 1958210352 19.292 99 89 178 1 2044550080 58766224 27573504
14:45:15 3230 8192000000 10990376896 11398049792 1978978464 19.457 100 90 180 1 2067285040 60157920 28148656
14:45:25 3519 8192000000 10997611728 11409072128 1986168704 19.514 100 94 187 0 2078904688 63456016 29279968
14:45:35 1370 8192000000 11005675920 11414347776 1989686256 19.541 100 92 183 1 2083202240 63816736 29699248
14:45:43 5245 8192000000 10973194784 11384324096 1964906320 19.345 99 82 163 1 2055125136 64788304 25430512
14:45:55 2009 8192000000 10994178176 11403669504 1980951008 19.472 100 81 159 1 2070354160 64371840 25031312
14:46:06 7757 8192000000 10987515968 11411103744 1986270560 19.514 100 66 132 1 2072143280 64114496 21758224
14:46:21 7351 8192000000 10974661392 11417174016 1989206944 19.538 100 49 98 1 2066844976 61822128 15815904
14:46:44 24615 8192000000 10968727808 11409522688 1989501168 19.540 100 44 89 3 2056473472 52068896 14903408
14:47:21 20472 8192000000 10934475440 11370921984 1950052560 19.227 99 33 66 1 2012493344 51247280 11193504
14:47:49 7661 8192000000 10949766528 11389898752 1968031408 19.370 100 32 64 0 2033295408 54305536 10958464
14:48:10 5400 8192000000 10945841536 11387592704 1962698048 19.327 100 33 66 0 2029391392 55614368 11078976
14:48:23 8095 8192000000 10931163584 11370192896 1932786112 19.089 99 38 76 1 2003380448 58017840 12576496
14:48:48 31595 8192000000 10933887168 11380830208 1928626832 19.056 99 30 60 2 1998108128 59204768 10276528
14:49:29 19557 8192000000 10934765648 11372441600 1930525712 19.071 99 32 64 1 2001358576 60545520 10287344
14:50:00 12822 8192000000 10943139440 11372662784 1948746688 19.216 100 43 86 2 2019047280 56197264 14103328
14:50:22 10671 8192000000 10950856752 11387715584 1955604272 19.271 100 40 78 2 2030419072 61371568 13443232
14:50:40 7557 8192000000 10943893920 11383750656 1942042768 19.163 99 38 76 0 2015891600 60762528 13086304
14:51:05 21048 8192000000 10949118736 11392606208 1952819520 19.249 100 37 74 1 2030699248 64698784 13180944
14:51:49 10805 8192000000 10959702576 11409809408 1964703456 19.343 100 31 61 0 2040013792 64535440 10774896
14:52:05 8871 8192000000 10970892048 11424088064 1972398944 19.404 100 34 68 0 2053137008 68320112 12417952
14:52:45 12023 8192000000 10920577952 11383918592 1941645392 19.160 100 28 56 1 2007394672 56249888 9499392
14:53:06 13743 8192000000 10923963648 11370164224 1939849152 19.146 100 24 48 0 2006189280 57514688 8825440
14:53:26 17887 8192000000 10920015984 11380809728 1943230848 19.173 100 23 46 0 2015119392 63554176 8334368
14:53:58 22485 8192000000 10919816032 11378491392 1935909920 19.114 100 25 50 0 2009673152 64369104 9394128
14:55:38 17287 8192000000 10902558560 11348455424 1841866352 18.356 96 25 51 2 1912465056 61469552 9129152
14:56:04 23509 8192000000 10877916944 11346190336 1895357344 18.789 99 18 36 0 1951132064 49621584 6153136
14:56:33 33576 8192000000 10846873760 11309146112 1884511280 18.702 98 22 44 0 1915654048 24725440 6417328
14:58:19 36855 8192000000 10876775424 11310350336 1896983632 18.802 98 46 86 1 1917902576 8437744 12481200
14:59:09 42517 8192000000 10853362464 11325431808 1924698768 19.024 100 25 50 1 1945853344 14390432 6764144
14:59:58 46844 8192000000 10865509872 11337375744 1938782320 19.137 100 13 26 3 1955877072 14174976 2919776
15:00:59 11400 8192000000 10881661888 11337842688 1957468176 19.286 100 42 85 3 1975569888 6390368 11711344
15:01:38 32223 8192000000 10905001728 11352854528 1957197008 19.284 100 30 60 1 1977004944 11193264 8614672
15:02:20 44540 8192000000 10907804304 11348688896 1948637936 19.216 99 38 75 2 1971737584 12250160 10849488
15:03:11 66140 8192000000 10895294192 11356692480 1941354688 19.158 99 28 56 3 1962044320 12949552 7740080
15:04:24 97058 8192000000 10883561920 11350511616 1945539888 19.191 99 14 27 2 1964054432 14094048 4420496
15:06:19 29019 8192000000 10885080288 11364220928 1960349120 19.309 100 11 23 1 1977096064 13103728 3643216
15:06:54 10625 8192000000 10884708112 11362959360 1962857552 19.329 100 11 22 0 1976703872 10573056 3273264
15:07:11 46432 8192000000 10901104912 11364274176 1945174384 19.188 99 12 23 0 1959593424 11061472 3357568
15:08:03 123653 8192000000 10893102400 11365150720 1935870080 19.114 98 13 26 0 1957890544 17842080 4178384
15:10:16 65599 8192000000 10902602800 11379486720 1964093216 19.339 100 15 30 4 1986909488 18016800 4799472
15:11:30 87002 8192000000 10909467296 11361026048 1951853984 19.241 99 15 30 1 1969966064 14196432 3915648
15:13:06 20796 8192000000 10896379488 11346677760 1938740496 19.137 98 38 74 4 1956662176 6447440 11474240
15:13:36 57188 8192000000 10911328192 11367043072 1954660656 19.264 99 31 62 0 1971482560 8170720 8651184
15:14:43 67636 8192000000 10903501408 11367133184 1957226400 19.284 99 19 38 0 1970460176 7908448 5325328
15:15:58 8730 8192000000 10914299936 11369635840 1980497072 19.469 100 23 45 1 1998225392 10842208 6886112
15:16:13 29449 8192000000 10931210272 11390029824 1988809856 19.534 100 22 44 3 2006658432 11386480 6462096
15:16:49 41565 8192000000 10918223808 11402162176 1994969168 19.583 100 24 48 1 2017717760 15229728 7518864
15:17:51 58160 8192000000 10928917472 11409031168 1999452080 19.618 100 14 28 0 2019077904 15817344 3808480
15:18:55 57460 8192000000 10917711568 11398426624 1962854912 19.329 98 10 20 0 1983453088 17597856 3000320
15:20:07 53256 8192000000 10917864432 11411120128 1986765872 19.518 100 12 23 2 2008670128 17828624 4075632
15:21:28 38763 8192000000 10919952048 11392790528 1975254848 19.427 99 20 40 2 1993192640 11948608 5989184
15:22:13 82684 8192000000 10905514528 11369725952 1894924144 18.785 95 14 28 1 1909718128 10462960 4331024
15:23:41 45956 8192000000 10904921360 11370696704 1940417904 19.150 98 37 74 0 1960095776 8916960 10760912
15:24:40 25806 8192000000 10915380688 11371716608 1945753216 19.193 98 34 68 0 1965385536 10340864 9291456
15:25:22 86349 8192000000 10912255088 11398451200 1960957760 19.314 99 20 39 1 1982356688 15994512 5404416
15:26:54 57758 8192000000 10899476704 11368259584 1934347360 19.102 97 17 34 0 1954273872 14896320 5030192
15:27:58 63676 8192000000 10907451600 11372634112 1927432880 19.046 97 10 20 1 1938840208 8912016 2495312
15:29:09 39206 8192000000 10937015712 11402747904 1997238192 19.601 100 35 70 1 2016471200 10097744 9135264
15:29:54 64246 8192000000 10899114656 11372806144 1857206544 18.481 93 27 54 1 1877974272 13819760 6947968
15:31:05 74654 8192000000 10919669168 11367993344 1931435024 19.078 98 19 38 1 1954641744 18029408 5177312
15:32:30 85368 8192000000 10884107632 11355607040 1888664624 18.735 96 19 38 1 1906385056 12097328 5623104
15:34:02 113158 8192000000 10874085088 11347664896 1913679104 18.936 97 21 42 4 1940137968 20335472 6123392
15:36:27 63430 8192000000 10872551664 11339190272 1903287328 18.853 97 28 54 3 1924913856 14305808 7320720
15:37:42 45788 8192000000 10898400400 11360436224 1958712448 19.296 100 27 54 1 1984234208 17805136 7716624
15:38:34 56983 8192000000 10879423584 11356176384 1921010688 18.995 98 10 20 0 1940505152 16920336 2574128
15:39:43 29064 8192000000 10851961072 11329703936 1887413824 18.725 97 6 12 0 1908818976 20215456 1189696
15:40:18 20148 8192000000 10832681440 11302948864 1908148752 18.892 99 13 26 2 1925572256 13729280 3694224
15:40:47 42672 8192000000 10826020816 11297374208 1887432528 18.725 98 10 20 1 1900777776 10244688 3100560
15:41:36 88875 8192000000 10829990560 11305431040 1858624784 18.492 96 17 34 0 1873561440 9468592 5468064
15:43:14 49596 8192000000 10832641360 11303960576 1887717520 18.727 98 14 28 1 1902441568 10434048 4290000
15:44:10 59565 8192000000 10837886160 11309039616 1899584208 18.823 99 19 38 2 1913769968 7418688 6767072
15:45:17 69635 8192000000 10846039024 11319050240 1889047888 18.738 98 10 20 0 1900750352 8960624 2741840
15:46:44 64447 8192000000 10859394592 11337375744 1929923456 19.066 100 10 20 0 1944461760 11673568 2864736
15:47:57 52802 8192000000 10850418688 11328786432 1899077264 18.819 98 21 42 1 1919449584 13833792 6538528
15:49:03 81315 8192000000 10848591152 11320180736 1877943424 18.648 97 23 46 1 1902022864 17061600 7017840
15:50:31 53958 8192000000 10861639488 11330035712 1885892800 18.713 97 33 66 1 1906253984 10975904 9385280
15:51:47 31345 8192000000 10870716112 11339030528 1935338464 19.110 100 25 50 2 1952982432 10700112 6943856
15:52:26 49957 8192000000 10893820064 11352883200 1946840448 19.201 100 31 61 1 1972673728 17143472 8689808
15:53:22 31866 8192000000 10874101184 11330371584 1916361920 18.958 98 48 96 0 1945094320 15373408 13358992
15:54:01 55991 8192000000 10865719024 11336118272 1900773376 18.833 98 30 60 0 1925689824 16118432 8798016
15:55:05 57175 8192000000 10885361808 11355271168 1903317840 18.853 98 33 66 0 1927295616 15164656 8813120
15:56:15 88023 8192000000 10891642496 11363414016 1953770032 19.256 100 14 27 0 1975402848 18321712 3311104
15:57:51 73233 8192000000 10904256016 11365445632 1911833120 18.921 97 25 51 0 1931581248 12665680 7082448
15:59:14 89175 8192000000 10905056400 11359821824 1952362064 19.245 99 50 100 2 1977766304 11330240 14074000
16:00:49 54594 8192000000 10906062288 11379056640 1972882224 19.408 100 25 50 0 1996323136 16419024 7021888
16:01:51 41897 8192000000 10884299696 11379798016 1966551536 19.358 100 15 30 1 1988512256 17904144 4056576
16:02:49 44078 8192000000 10872229952 11356823552 1943132096 19.172 99 5 10 0 1960628784 16260880 1235808
16:03:39 24272 8192000000 10869241088 11355062272 1955510400 19.270 100 5 11 0 1968617424 12048816 1058208
16:04:09 15163 8192000000 10890045952 11367927808 1966069264 19.354 100 7 14 0 1976870400 9235120 1566016
16:04:38 85025 8192000000 10902730048 11376078848 1949079312 19.219 99 17 34 1 1964216768 10140816 4996640
16:06:09 61525 8192000000 10894229536 11362168832 1917270864 18.965 97 21 42 1 1937450624 13736928 6442832
16:07:18 72386 8192000000 10895679904 11367321600 1930995888 19.075 98 16 32 2 1948895152 13278176 4621088
16:08:36 44923 8192000000 10875641248 11362058240 1924916816 19.026 98 11 22 1 1938769200 10911664 2940720
16:09:29 63304 8192000000 10889684064 11362394112 1961695152 19.320 100 17 32 2 1978248192 12189440 4363600
16:10:52 116266 8192000000 10874380304 11356356608 1857733168 18.485 94 23 46 0 1882739056 18494208 6511680
16:12:55 61787 8192000000 10905619792 11385180160 1951877936 19.241 99 30 62 0 1971875392 11947504 8049952
16:14:10 74998 8192000000 10904919296 11380473856 1941350944 19.158 98 29 58 1 1964898368 14765408 8782016
16:15:35 82073 8192000000 10890099152 11358842880 1900835344 18.833 97 9 18 0 1916320032 13224448 2260240
16:17:05 66990 8192000000 10908513504 11406794752 1950482608 19.230 99 13 26 0 1979009248 24850736 3675904
16:18:19 112101 8192000000 10886563152 11364876288 1940966384 19.154 99 25 50 1 1971002528 22052928 7983216
16:20:26 39138 8192000000 10873353280 11345977344 1924204544 19.021 98 12 22 2 1940432896 13724496 2503856
16:21:20 47618 8192000000 10866287488 11353669632 1917116192 18.964 98 7 12 0 1930039168 11393344 1529632
16:22:13 73268 8192000000 10864020192 11346518016 1897505952 18.806 97 8 16 0 1912437344 12548608 2382784
16:23:37 78962 8192000000 10872360464 11346259968 1924482208 19.023 99 21 42 0 1943754944 12674800 6597936
16:25:04 65817 8192000000 10862034016 11339816960 1913434624 18.934 98 17 34 0 1931377376 12601712 5341040
16:26:18 71816 8192000000 9858695472 10226794496 980476528 10.689 51 8 16 0 993661072 10445120 2739424

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 27-02-2021 16:29:49 to 27-02-2021 16:30:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 116 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-02-2021 16:30:22 to 27-02-2021 16:30:24.

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          229393
MON$OLDEST_ACTIVE               233128
MON$OLDEST_SNAPSHOT             233128
MON$NEXT_TRANSACTION            233128
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                       2036768
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 ---
:366: 
:367: mscs-test-161.budzdorov.ru    Sat Feb 27 16:27:33 2021
:368:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:369: 
:370: 
:371: mscs-test-161.budzdorov.ru    Sat Feb 27 16:27:37 2021
:372:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:373: 
:374: 
:375: mscs-test-161.budzdorov.ru    Sat Feb 27 16:27:37 2021
:376:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:377: 
--- end of diff output ---

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

27.02.21 16:30:25. 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-27 16:30:27 No severe PSQL-related problems occured
27.02.21 16:30:28. End of report.