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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17502824 kB
MemAvailable 31580572 kB
Buffers 0 kB
Cached 14180260 kB
SwapCached 1968 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 2020-12-06 01:27:05
DTS_END                         2020-12-06 01:27:05.3100
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52876
TRN_ID                          233959
ATT_ID                          653
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: 9384.90 26643 1126188
customer order: creation 163.71 362 19645
customer order: refuse 14.23 289 1708
order to supplier: creation 43.25 1275 5190
order to supplier: removal 3.40 102147 408
invoice (draft): creation 44.30 3599 5316
invoice (draft): removal 54.50 721 6540
invoice accept: apply 40.18 17418 4822
invoice accept: cancel 50.41 684 6049
customer reserve: creation 3755.37 171 450644
customer reserve: removal 4927.20 56 591264
realization accept: apply 80.32 165 9638
realization accept: cancel 84.03 108 10083
payment from customer: creation 57.25 117 6870
payment from customer: removal 5.65 80 678
payment to supplier: creation 45.87 109 5504
payment to supplier: removal 3.53 149 423
service: total inventory turnovers 4.22 1208 507
service: total monetary turnovers 6.54 23 785
service: aggregate perf. data 0.92 19710 110
service: refresh index statistics 0.03 384459 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-12-2020 01:28:13 to 06-12-2020 01:28:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2797
TEST_TIME 2 3333
TEST_TIME 3 5530
TEST_TIME 4 5095
TEST_TIME 5 4960
TEST_TIME 6 5092
TEST_TIME 7 5431
TEST_TIME 8 5681
TEST_TIME 9 5545
TEST_TIME 10 6280
TEST_TIME 11 6416
TEST_TIME 12 6890
TEST_TIME 13 6911
TEST_TIME 14 7410
TEST_TIME 15 7507
TEST_TIME 16 7690
TEST_TIME 17 7907
TEST_TIME 18 7943
TEST_TIME 19 8408
TEST_TIME 20 8617
TEST_TIME 21 9278
TEST_TIME 22 9397
TEST_TIME 23 9485
TEST_TIME 24 10942
TEST_TIME 25 11194
TEST_TIME 26 12061
TEST_TIME 27 11720
TEST_TIME 28 11503
TEST_TIME 29 11340
TEST_TIME 30 11123
TEST_TIME 31 10878
TEST_TIME 32 10625
TEST_TIME 33 10579
TEST_TIME 34 10400
TEST_TIME 35 10635
TEST_TIME 36 10473
TEST_TIME 37 10310
TEST_TIME 38 10271
TEST_TIME 39 10132
TEST_TIME 40 10061
TEST_TIME 41 10144
TEST_TIME 42 10014
TEST_TIME 43 9952
TEST_TIME 44 9906
TEST_TIME 45 9922
TEST_TIME 46 10106
TEST_TIME 47 10038
TEST_TIME 48 9955
TEST_TIME 49 9943
TEST_TIME 50 9890
TEST_TIME 51 9863
TEST_TIME 52 9820
TEST_TIME 53 10062
TEST_TIME 54 10029
TEST_TIME 55 9930
TEST_TIME 56 9792
TEST_TIME 57 9732
TEST_TIME 58 9706
TEST_TIME 59 9603
TEST_TIME 60 9559
TEST_TIME 61 9580
TEST_TIME 62 9513
TEST_TIME 63 9510
TEST_TIME 64 9468
TEST_TIME 65 9418
TEST_TIME 66 9570
TEST_TIME 67 9585
TEST_TIME 68 9567
TEST_TIME 69 9524
TEST_TIME 70 9719
TEST_TIME 71 9680
TEST_TIME 72 9671
TEST_TIME 73 9666
TEST_TIME 74 9742
TEST_TIME 75 9769
TEST_TIME 76 9752
TEST_TIME 77 9817
TEST_TIME 78 9837
TEST_TIME 79 9736
TEST_TIME 80 9645
TEST_TIME 81 9649
TEST_TIME 82 9627
TEST_TIME 83 9598
TEST_TIME 84 9558
TEST_TIME 85 9495
TEST_TIME 86 9473
TEST_TIME 87 9448
TEST_TIME 88 9457
TEST_TIME 89 9485
TEST_TIME 90 9482
TEST_TIME 91 9476
TEST_TIME 92 9500
TEST_TIME 93 9502
TEST_TIME 94 9518
TEST_TIME 95 9551
TEST_TIME 96 9578
TEST_TIME 97 9576
TEST_TIME 98 9615
TEST_TIME 99 9572
TEST_TIME 100 9632
TEST_TIME 101 9624
TEST_TIME 102 9654
TEST_TIME 103 9650
TEST_TIME 104 9640
TEST_TIME 105 9563
TEST_TIME 106 9600
TEST_TIME 107 9578
TEST_TIME 108 9532
TEST_TIME 109 9523
TEST_TIME 110 9470
TEST_TIME 111 9443
TEST_TIME 112 9472
TEST_TIME 113 9468
TEST_TIME 114 9410
TEST_TIME 115 9398
TEST_TIME 116 9383
TEST_TIME 117 9421
TEST_TIME 118 9428
TEST_TIME 119 9468
TEST_TIME 120 9389

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 06-12-2020 01:28:16 to 06-12-2020 01:28:20.

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 1543471 1543471 0 0.00 0 19003 6 0 0
doc_list_biud 1543471 1543471 0 0.00 0 50767 27 0 0
sp_add_invoice_to_stock 4916 4822 94 1.91 31 195333 17419 0 94
sp_cancel_adding_invoice 6049 6049 0 0.00 4 72146 684 0 0
sp_cancel_client_order 1708 1708 0 0.00 4 9187 290 0 0
sp_cancel_customer_reserve 591264 591264 0 0.00 1 50768 57 0 0
sp_cancel_pay_from_customer 678 678 0 0.00 3 6486 81 0 0
sp_cancel_pay_to_supplier 423 423 0 0.00 3 10467 150 0 0
sp_cancel_supplier_invoice 6544 6540 4 0.06 1 15603 721 0 4
sp_cancel_supplier_order 408 408 0 0.00 6 1023958 102147 0 0
sp_cancel_write_off 10083 10083 0 0.00 1 11200 109 0 0
sp_client_order 19645 19645 0 0.00 3 17140 363 0 0
sp_customer_reserve 450644 450644 0 0.00 0 49934 171 0 0
sp_fill_shopping_cart 30140 30140 0 0.00 1 26233 39 0 0
sp_fill_shopping_cart_clo_res 450643 450643 0 0.00 0 30254 15 0 0
sp_get_clo_for_invoice 4816 4816 0 0.00 0 28472 307 0 0
sp_kill_cost_storno 17233 17233 0 0.00 0 18104 50 0 0
sp_kill_qstorno_ret_qs2qd 1199559 1199559 0 0.00 0 50761 30 0 0
sp_kill_qty_storno 630506 630506 0 0.00 0 50766 65 0 0
sp_lock_selected_doc 20001 20001 0 0.00 0 8801 9 0 0
sp_make_cost_storno 26828 26828 0 0.00 0 12491 48 0 0
sp_multiply_rows_for_pdistr 26828 26828 0 0.00 0 8591 27 0 0
sp_multiply_rows_for_qdistr 19645 19645 0 0.00 0 13463 162 0 0
sp_pay_from_customer 6870 6870 0 0.00 4 11333 118 0 0
sp_pay_to_supplier 5504 5504 0 0.00 4 10492 109 0 0
sp_payment_common 12374 12374 0 0.00 1 8139 28 0 0
sp_qd_handle_on_cancel_clo 1708 1708 0 0.00 0 9153 273 0 0
sp_qd_handle_on_invoice_upd_sts 10865 10865 0 0.00 0 24907 285 0 0
sp_qd_handle_on_reserve_upd_sts 9638 9638 0 0.00 0 14889 50 0 0
sp_reserve_write_off 9638 9638 0 0.00 7 14929 166 0 0
sp_supplier_invoice 5316 5316 0 0.00 6 109465 3600 0 0
sp_supplier_order 5190 5190 0 0.00 4 36908 1275 0 0
srv_aggregate_perf_data 110 110 0 0.00 2494 339307 19711 0 0
srv_fill_mon_cache_memory 150 150 0 0.00 921 131688 35509 0 0
srv_find_qd_qs_mism 1080255 1080255 0 0.00 0 19001 5 0 0
srv_make_invnt_saldo 507 507 0 0.00 45 60069 1209 0 0
srv_make_money_saldo 785 785 0 0.00 0 963 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 272944 549410 384460 0 0
t$perf-abend:sp_add_invoice_to_stock 94 94 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4822 4822 0 0.00 0 12443 169 0 0
t$perf-norm:sp_cancel_adding_invoice 424 424 0 0.00 0 14858 123 0 0
t$perf-norm:sp_cancel_client_order 1708 1708 0 0.00 0 961 8 0 0
t$perf-norm:sp_cancel_customer_reserve 660 660 0 0.00 0 500 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 678 678 0 0.00 0 5042 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 423 423 0 0.00 0 2952 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 347 347 0 0.00 0 1230 9 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 26716 1561 0 0
t$perf-norm:sp_cancel_write_off 899 899 0 0.00 0 7206 15 0 0
t$perf-norm:sp_client_order 19645 19645 0 0.00 0 13673 18 0 0
t$perf-norm:sp_customer_reserve 981 981 0 0.00 0 2242 5 0 0
t$perf-norm:sp_pay_from_customer 6870 6870 0 0.00 0 7208 12 0 0
t$perf-norm:sp_pay_to_supplier 5504 5504 0 0.00 0 15241 14 0 0
t$perf-norm:sp_reserve_write_off 9638 9638 0 0.00 0 6300 11 0 0
t$perf-norm:sp_supplier_invoice 5316 5316 0 0.00 0 5990 19 0 0
t$perf-norm:sp_supplier_order 5190 5190 0 0.00 0 6591 14 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 33 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 150 150 0 0.00 0 1656 30 0 0
t$perf-norm:srv_make_invnt_saldo 507 507 0 0.00 0 1235 24 0 0
t$perf-norm:srv_make_money_saldo 785 785 0 0.00 0 445 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 9820 9632 188 1.91 0 7477 19 0 188
v_all_customers 36060 36060 0 0.00 0 17 1 0 0
v_all_suppliers 28726 28726 0 0.00 0 24 1 0 0
v_all_wares 39284 39284 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 848 848 0 0.00 0 530 6 0 0
v_cancel_client_order 3416 3416 0 0.00 0 977 3 0 0
v_cancel_customer_prepayment 1356 1356 0 0.00 0 6359 12 0 0
v_cancel_customer_reserve 1320 1320 0 0.00 0 2270 5 0 0
v_cancel_payment_to_supplier 846 846 0 0.00 0 10457 26 0 0
v_cancel_supplier_invoice 702 694 8 1.13 0 5245 27 0 8
v_cancel_supplier_order 816 816 0 0.00 0 5179 17 0 0
v_cancel_write_off 1798 1798 0 0.00 0 2447 15 0 0
v_max_id_clo_ord 5190 5190 0 0.00 0 900 1 0 0
v_max_id_clo_res 981 981 0 0.00 0 2453 12 0 0
v_max_id_ord_sup 5308 5308 0 0.00 0 4725 5 0 0
v_max_non_paid_invoice 1639 1639 0 0.00 0 661 3 0 0
v_max_non_paid_realizn 3502 3502 0 0.00 0 1470 3 0 0
v_min_id_clo_ord 5190 5190 0 0.00 0 3047 8 0 0
v_min_id_clo_res 981 981 0 0.00 0 5604 19 0 0
v_min_id_ord_sup 5308 5308 0 0.00 0 6863 6 0 0
v_min_non_paid_invoice 5504 5504 0 0.00 0 5254 14 0 0
v_min_non_paid_realizn 6870 6870 0 0.00 0 7309 22 0 0
v_our_firm 9960 9960 0 0.00 0 12 1 0 0
v_reserve_write_off 19276 19276 0 0.00 0 7374 5 0 0
x_lock_depdocs_on_canc_invoice 12242 12242 0 0.00 0 13049 108 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 21207 326 0 0
x_make_qstorno_1000_1200 5190 5190 0 0.00 2 36876 1200 0 0
x_make_qstorno_1200_2000 5316 5316 0 0.00 3 104633 3453 0 0
x_make_qstorno_2100_3300 450644 450644 0 0.00 0 49593 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-12-2020 01:28:21 to 06-12-2020 01:28:25.

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:08 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:15 14452 8192000000 10239975584 10544001024 910275392 10.000 72 62 125 0 934120864 2513200 21332272
22:57:38 31691 8192000000 10339482992 10658078720 1378472816 14.403 100 87 174 0 1412188464 5003488 28712160
22:58:19 20636 8192000000 10364947264 10687946752 1427969824 14.843 100 93 186 0 1465731600 6898880 30862896
22:58:49 24747 8192000000 10394774576 10720931840 1445577952 14.999 100 87 174 0 1481499936 7477648 28444336
22:59:25 23528 8192000000 10419985200 10751942656 1473555808 15.245 100 90 180 0 1510756016 8317984 28882224
23:00:06 27101 8192000000 10452689520 10787155968 1505455504 15.524 100 92 185 1 1544451152 9436832 29558816
23:00:42 19525 8192000000 10459158864 10797662208 1512109600 15.582 100 84 168 1 1548651104 9684080 26857424
23:01:09 16944 8192000000 10476599504 10825781248 1528656736 15.725 100 77 154 1 1562984336 9735856 24591744
23:01:35 7458 8192000000 10508264720 10855370752 1567750880 16.063 100 83 165 1 1603744400 10297744 25695776
23:01:51 16352 8192000000 10524385312 10881036288 1584151360 16.204 100 78 156 0 1618911824 10976960 23783504
23:02:16 6697 8192000000 10536620480 10894872576 1608358608 16.411 100 83 166 0 1645345168 10885488 26101072
23:02:31 22076 8192000000 10580137584 10937417728 1638610624 16.668 100 85 170 0 1675125664 11406208 25108832
23:03:03 10659 8192000000 10594014992 10962194432 1657068032 16.824 100 81 162 0 1693513376 12431920 24013424
23:03:23 11020 8192000000 10627002688 10993143808 1680417840 17.021 100 75 150 0 1714517808 12416736 21683232
23:03:42 6196 8192000000 10632167536 11002892288 1691082416 17.110 100 74 148 1 1725283600 12435616 21765568
23:03:56 7186 8192000000 10653360416 11026952192 1713542176 17.298 100 75 149 2 1746832752 12031744 21258832
23:04:13 6488 8192000000 10668710560 11044622336 1723680496 17.383 100 74 147 2 1757777280 12922016 21174768
23:04:27 5564 8192000000 10681524432 11060793344 1740995632 17.527 100 75 150 0 1773700512 11939104 20765776
23:04:40 6807 8192000000 10686784992 11071475712 1751831280 17.617 100 73 146 1 1784866288 12464944 20570064
23:04:55 4953 8192000000 10697524960 11081691136 1765537680 17.730 100 68 135 2 1795611296 11537456 18536160
23:05:07 5667 8192000000 10704863584 11094110208 1774570832 17.805 100 71 142 1 1807156640 12367344 20218464
23:05:20 7621 8192000000 10714766768 11099041792 1782307600 17.868 100 80 160 1 1817715184 12961904 22445680
23:05:35 5915 8192000000 10723888464 11110064128 1790015360 17.932 100 73 146 1 1823405824 13112960 20277504
23:05:48 5346 8192000000 10736489584 11131502592 1809589232 18.093 100 77 155 0 1843298784 12252896 21456656
23:06:00 3974 8192000000 10761003936 11147227136 1815212976 18.139 100 74 147 1 1848257344 12038400 21005968
23:06:11 3065 8192000000 10758596384 11148955648 1822317632 18.197 100 72 144 1 1854667680 12464800 19885248
23:06:20 4049 8192000000 10767423920 11156434944 1830516240 18.264 100 88 177 0 1869183744 13811616 24855888
23:06:31 2473 8192000000 10781400784 11169136640 1837097840 18.317 100 89 176 1 1875904816 14422176 24384800
23:06:41 2527 8192000000 10784428432 11169288192 1841384256 18.352 100 90 180 1 1881077872 14293264 25400352
23:06:50 2912 8192000000 10794391824 11179954176 1843102272 18.366 100 91 181 2 1882641120 13584160 25954688
23:06:59 1975 8192000000 10802994864 11188047872 1855584656 18.467 100 91 183 0 1896299792 14848816 25866320
23:07:07 2036 8192000000 10800133088 11188723712 1854298464 18.457 100 87 175 1 1892736784 13551520 24886800
23:07:16 1719 8192000000 10787727312 11178512384 1857332400 18.482 100 91 181 0 1896009008 13090224 25586384
23:07:24 2012 8192000000 10802268768 11188879360 1857797888 18.485 100 87 175 2 1895115888 12843424 24474576
23:07:33 1374 8192000000 10800894768 11189288960 1859986960 18.503 100 90 180 0 1899666704 13771408 25908336
23:07:41 1973 8192000000 10807602720 11198529536 1863939024 18.535 100 92 183 1 1905003616 14609552 26455040
23:07:50 1375 8192000000 10808973344 11199623168 1866322192 18.555 100 91 182 0 1905813808 13587744 25903872
23:07:58 1318 8192000000 10802634880 11201961984 1865574640 18.548 100 82 160 1 1901443424 12943840 22924944
23:08:06 2531 8192000000 10797123024 11199455232 1862521744 18.524 100 59 118 1 1891601200 11914800 17164656
23:08:15 2146 8192000000 10804437808 11199098880 1865953584 18.552 100 68 136 1 1895082432 9623728 19505120
23:08:23 5978 8192000000 10791560464 11198525440 1866171072 18.553 100 48 97 0 1889024432 9334560 13518800
23:08:36 37984 8192000000 10780100592 11200077824 1865369584 18.547 100 41 80 4 1888281872 10549824 12362464
23:09:20 12925 8192000000 10795678960 11204243456 1867453184 18.564 100 31 64 0 1882407632 5568656 9385792
23:09:39 8414 8192000000 10779746064 11209568256 1867255136 18.562 100 19 38 1 1879348576 7057632 5035808
23:09:54 4293 8192000000 10788365008 11210752000 1875380656 18.628 100 31 62 0 1891430160 6335264 9714240
23:10:05 13642 8192000000 10774876896 11215364096 1876568288 18.637 100 20 39 0 1888384320 6526512 5289520
23:10:26 4382 8192000000 10793056704 11219812352 1881084560 18.674 100 23 46 1 1894723424 7471552 6167312
23:10:40 11412 8192000000 10785980224 11217522688 1881889744 18.680 100 30 60 2 1897169568 7000592 8279232
23:11:01 8230 8192000000 10799008496 11223146496 1880482976 18.669 100 20 37 3 1892068576 6177904 5407696
23:11:16 9656 8192000000 10796480672 11225747456 1885763824 18.712 100 18 36 1 1896507856 5977392 4766640
23:11:32 11162 8192000000 10802020256 11233288192 1891127072 18.755 100 24 47 0 1905191472 7430096 6634304
23:11:52 9619 8192000000 10801443808 11233103872 1889762080 18.744 100 9 18 0 1897483712 5061536 2660096
23:12:10 17733 8192000000 10809447168 11235680256 1893967104 18.778 100 17 34 0 1904982864 5855552 5160208
23:12:36 78914 8192000000 10812594000 11252195328 1903206560 18.852 100 32 63 0 1917563152 5368256 8988336
23:14:04 6465 8192000000 10820704256 11255988224 1906001344 18.875 100 29 58 3 1921538528 7463504 8073680
23:14:16 7098 8192000000 10826154656 11255541760 1908036432 18.891 100 30 60 0 1923649600 7374416 8238752
23:14:30 5125 8192000000 10823347200 11254124544 1909080880 18.899 100 37 73 1 1925925616 7127312 9717424
23:14:42 6353 8192000000 10828009104 11261259776 1907816560 18.889 100 33 66 0 1928541680 11701792 9023328
23:14:55 8067 8192000000 10821830416 11259445248 1910701440 18.912 100 27 54 0 1925108096 6154704 8251952
23:15:09 6536 8192000000 10823617168 11258953728 1907698528 18.888 100 16 32 3 1918195968 5584288 4913152
23:15:27 6555 8192000000 10822861664 11259150336 1908653072 18.896 100 22 44 1 1921224784 6353936 6217776
23:15:41 9113 8192000000 10808812928 11246755840 1872469824 18.604 98 15 31 0 1881438096 4989648 3978624
23:15:58 8307 8192000000 10808903936 11243724800 1867452256 18.564 98 26 53 2 1881337568 6132048 7753264
23:16:13 8140 8192000000 10795086320 11229978624 1856952224 18.479 98 19 38 2 1868115248 5601760 5561264
23:16:36 10030 8192000000 10804661440 11243905024 1882282480 18.684 99 12 24 0 1890963344 5459280 3221584
23:16:54 8671 8192000000 10793758048 11217670144 1805417104 18.058 95 15 30 1 1814369776 4753792 4198880
23:17:09 11075 8192000000 10786099904 11222106112 1864341792 18.538 99 18 36 1 1876287968 6744096 5202080
23:17:27 64498 8192000000 10775980096 11209555968 1847133680 18.399 98 25 49 3 1858980944 5009152 6838112
23:18:40 9986 8192000000 10775516448 11199369216 1838619952 18.330 99 16 32 2 1848256400 5398000 4238448
23:19:04 3467 8192000000 10750058816 11168980992 1795346256 17.976 96 37 72 4 1811867392 6503504 10017632
23:19:18 6581 8192000000 10761667888 11181645824 1829780640 18.258 99 37 73 2 1847370592 7159376 10430576
23:19:34 8243 8192000000 10703177792 11117993984 1675560064 16.980 92 39 78 5 1693723936 5958992 12204880
23:19:49 5135 8192000000 10701163360 11113795584 1744379328 17.555 97 24 48 2 1761144576 9922544 6842704
23:20:01 5563 8192000000 10709353072 11121168384 1760038752 17.685 98 25 50 0 1773820912 6379152 7403008
23:20:13 6053 8192000000 10720023856 11120631808 1758141056 17.669 98 26 50 0 1771810864 5731392 7938416
23:20:26 7846 8192000000 10696606144 11113988096 1739472432 17.514 97 25 49 0 1751910944 5003056 7435456
23:20:40 8895 8192000000 10722019760 11132444672 1774677824 17.806 99 25 49 2 1787359168 5021312 7660032
23:20:58 5906 8192000000 10718585776 11127324672 1777725184 17.831 99 25 47 1 1790587456 5131328 7730944
23:21:10 12908 8192000000 10716775200 11125256192 1707496544 17.248 94 23 46 2 1719173344 5674016 6002784
23:21:31 6989 8192000000 10716379760 11128758272 1751090048 17.611 97 30 60 3 1765653952 5152960 9410944
23:21:45 8352 8192000000 10725635392 11143872512 1810218176 18.098 100 25 46 3 1822294736 5472080 6604480
23:22:00 70427 8192000000 10739300064 11159064576 1794915088 17.972 98 33 66 1 1810345312 5237888 10192336
23:23:20 10847 8192000000 10751109504 11166400512 1819168160 18.171 99 26 52 2 1833033280 6681888 7183232
23:23:38 7871 8192000000 10764749264 11183722496 1844285456 18.376 100 41 81 0 1863873040 8266064 11321520
23:23:53 7267 8192000000 10755054576 11171840000 1826369040 18.230 99 27 55 0 1839228752 5418752 7440960
23:24:10 4593 8192000000 10770210384 11182407680 1841137888 18.350 100 53 102 2 1862707520 5267584 16302048
23:24:23 8978 8192000000 10763557568 11187609600 1845157472 18.383 100 33 66 3 1860994480 6960336 8876672
23:24:40 6449 8192000000 10761721088 11193630720 1854134912 18.456 100 25 50 0 1866027184 5473024 6419248
23:24:52 9235 8192000000 10782365008 11209183232 1857099200 18.480 100 24 48 1 1877406064 13825040 6481824
23:25:08 7566 8192000000 10766511952 11201597440 1857411184 18.482 100 17 34 1 1867665408 5516640 4737584
23:25:23 6023 8192000000 10769227168 11206070272 1862504928 18.524 100 22 44 2 1874907472 5988544 6414000
23:25:37 12328 8192000000 10778498976 11210420224 1863194032 18.529 100 12 24 1 1871900976 5408448 3298496
23:25:56 7992 8192000000 10783043856 11211653120 1867141008 18.561 100 16 32 2 1877625712 5353056 5131648
23:26:10 5332 8192000000 10785297216 11214901248 1869852288 18.583 100 23 45 1 1881454592 5157840 6444464
23:26:22 8398 8192000000 10780011120 11220856832 1872209152 18.602 100 20 40 1 1883630544 5699904 5721488
23:26:37 19410 8192000000 10791359040 11221659648 1880925408 18.673 100 25 50 0 1895046784 5191296 8930080
23:27:45 62251 8192000000 10827046256 11251666944 1898191264 18.812 100 51 101 1 1920311152 6871152 15248736
23:28:57 37238 8192000000 10862459984 11280166912 1914012736 18.939 100 40 80 1 1935513568 10011248 11489584
23:29:47 22111 8192000000 10861717728 11290992640 1929602640 19.064 100 42 83 0 1954634256 12633568 12398048
23:30:26 30754 8192000000 10862471376 11309436928 1937293376 19.125 100 26 52 1 1960668416 15583792 7791248
23:31:13 34937 8192000000 10888088912 11324657664 1953862608 19.257 100 33 65 2 1979572320 15734688 9975024
23:31:54 10907 8192000000 10901322512 11333615616 1961704960 19.320 100 44 88 1 1995697520 20498640 13493920
23:32:17 6146 8192000000 10901552576 11335012352 1964740112 19.344 100 41 81 1 1994282624 17611808 11930704
23:32:31 6569 8192000000 10912112800 11341344768 1963702464 19.335 100 51 100 0 2000326896 21997680 14626752
23:32:49 9200 8192000000 10910003984 11341303808 1967477504 19.365 100 50 98 2 2000253984 18801232 13975248
23:33:08 4057 8192000000 10925059312 11351416832 1975654048 19.430 100 57 115 1 2012319360 19531152 17134160
23:33:21 12606 8192000000 10930059808 11355791360 1978527824 19.453 100 54 108 0 2013750944 19836304 15386816
23:33:42 12491 8192000000 10921259408 11356336128 1983531328 19.493 100 57 114 1 2020565936 20320544 16714064
23:34:03 7471 8192000000 10930525984 11362414592 1982810448 19.487 100 42 84 0 2016658704 20387712 13460544
23:34:19 17526 8192000000 10935220336 11361378304 1982816096 19.487 100 54 108 1 2021477504 21656080 17005328
23:34:43 9046 8192000000 10936195264 11370139648 1986961344 19.520 100 46 92 0 2024113712 23365392 13786976
23:35:03 5031 8192000000 10948663776 11380043776 1990794752 19.550 100 54 108 1 2032987232 25626864 16565616
23:35:16 18463 8192000000 10937303296 11374559232 1987501232 19.524 100 48 96 0 2029734464 27883072 14350160
23:35:44 5616 8192000000 10950286272 11378409472 1999186416 19.616 100 66 130 1 2041336560 22954128 19196016
23:36:04 6532 8192000000 10942221936 11373989888 1994503824 19.579 100 59 118 2 2037270640 24949760 17817056
23:36:34 19908 8192000000 10957518880 11395702784 2002267712 19.641 100 53 104 0 2049247408 31151920 15827776
23:37:09 3611 8192000000 10972900352 11397754880 2005162016 19.663 100 67 133 1 2059081904 33099040 20820848
23:37:20 3960 8192000000 10989145680 11413893120 2012990752 19.725 100 67 134 2 2068441520 34607504 20843264
23:37:30 10292 8192000000 10967971296 11397652480 2003476032 19.650 100 61 119 0 2054781072 33424144 17880896
23:37:48 3735 8192000000 10975948640 11405582336 2012985584 19.725 100 70 138 2 2067970240 33982848 21001808
23:38:01 10819 8192000000 10982519728 11414069248 2016206112 19.750 100 68 134 0 2069867920 33279616 20382192
23:38:21 6055 8192000000 10972560208 11403325440 2007843184 19.685 100 63 124 0 2060979968 34772240 18364544
23:38:36 4047 8192000000 10967422368 11397414912 1991078832 19.552 99 69 137 1 2048325984 36606128 20641024
23:38:49 2519 8192000000 10987365456 11408064512 2007833728 19.684 100 73 147 2 2066865056 36829712 22201616
23:38:59 2330 8192000000 10984891760 11401601024 1992825440 19.566 99 89 175 1 2057877616 38712496 26339680
23:39:10 2158 8192000000 10972219024 11388751872 1990026256 19.544 100 82 162 1 2051677520 37189248 24462016
23:39:22 13771 8192000000 10954524880 11390529536 1992531184 19.564 100 59 118 0 2043822304 33171360 18119760
23:39:49 1482 8192000000 10998863552 11419041792 2016454992 19.752 100 85 170 2 2082678912 40006128 26217792
23:39:58 3347 8192000000 10986081344 11413618688 2010894896 19.709 100 69 136 0 2071359568 40562560 19902112
23:40:10 3173 8192000000 11008035552 11425513472 2020711664 19.786 100 80 160 0 2085548096 41158272 23678160
23:40:20 979 8192000000 10998912016 11412332544 1998398512 19.610 99 88 173 4 2067253600 42454512 26400576
23:40:30 8067 8192000000 10994149424 11412443136 2008595408 19.690 100 72 146 1 2073540368 43564608 21380352
23:40:48 2887 8192000000 11012571648 11431878656 2020841632 19.787 100 81 160 0 2094325280 48378608 25105040
23:40:58 6053 8192000000 11016754704 11438243840 2025741568 19.825 100 83 165 0 2100223008 49404304 25077136
23:41:17 2482 8192000000 11009018864 11423801344 2011929072 19.717 100 85 168 1 2087796352 49345056 26522224
23:41:26 2984 8192000000 10991223296 11413737472 2004945424 19.662 99 80 159 1 2080090128 50574400 24570304
23:41:37 5586 8192000000 11000106592 11422322688 1995206832 19.585 99 82 164 3 2071524448 50932512 25385104
23:41:50 2887 8192000000 10966888352 11392765952 1983395120 19.492 99 65 130 0 2049244992 45844720 20005152
23:41:59 2548 8192000000 10958376944 11374010368 1959303312 19.301 98 76 148 0 2028881888 45934400 23644176
23:42:11 1250 8192000000 10960495376 11369177088 1966328640 19.356 99 85 171 3 2039462608 47060336 26073632
23:42:19 1613 8192000000 10995098192 11402661888 1997887680 19.606 100 88 171 0 2072111488 48183232 26040576
23:42:27 1254 8192000000 10993941984 11403767808 1994616576 19.580 100 89 177 1 2071942576 50074384 27251616
23:42:51 3629 8192000000 10969312208 11389288448 1983085744 19.489 100 71 136 2 2053289056 49134144 21069168
23:43:03 2942 8192000000 10980142864 11402424320 1991406848 19.555 100 67 131 1 2062991008 51093120 20491040
23:43:15 1396 8192000000 10995484288 11411529728 2002131648 19.640 100 79 158 4 2077904096 50760400 25012048
23:43:25 916 8192000000 11006160240 11414106112 2002675232 19.644 100 95 189 1 2083875152 52546336 28653584
23:43:33 2191 8192000000 10993636992 11413536768 2000637712 19.628 100 83 166 0 2081301280 54747024 25916544
23:43:43 3865 8192000000 10972602224 11406049280 1991497984 19.556 100 49 98 0 2060952576 53306096 16148496
23:43:56 15925 8192000000 10964352816 11401166848 1956639200 19.279 98 41 82 0 2023586944 53115392 13832352
23:44:28 2195 8192000000 10971557280 11391889408 1977056000 19.441 99 78 157 0 2058736224 56923456 24756768
23:44:39 13467 8192000000 10960606592 11403821056 1983782912 19.495 100 43 86 1 2055642672 57313616 14546144
23:45:03 14277 8192000000 10941929728 11377422336 1922513536 19.007 97 40 80 1 1992734432 56566208 13654688
23:45:26 9155 8192000000 10957110592 11386925056 1965632960 19.351 100 47 94 2 2040263136 58246000 16384176
23:45:42 8026 8192000000 10953662736 11386167296 1965645488 19.351 100 51 99 0 2043050912 60479008 16926416
23:46:05 4007 8192000000 10973811552 11394109440 1970991744 19.393 100 57 114 2 2051800480 61947280 18861456
23:46:16 6914 8192000000 10986110384 11413020672 1982145808 19.482 100 57 114 0 2069030000 67704080 19180112
23:46:30 8074 8192000000 10976050528 11407728640 1959560416 19.303 99 53 106 0 2047109936 69349200 18200320
23:46:45 10489 8192000000 10980230448 11416756224 1964426272 19.341 99 43 86 3 2049100816 69598208 15076336
23:47:03 11497 8192000000 10974496560 11419586560 1979692480 19.462 100 37 74 0 2061486304 68783360 13010464
23:47:29 11045 8192000000 10969522816 11416694784 1961566288 19.318 99 40 80 2 2040362624 64947584 13848752
23:47:46 10200 8192000000 10971897744 11412516864 1969525872 19.382 100 36 72 0 2057269280 74999632 12743776
23:48:05 13107 8192000000 10960464000 11401670656 1959065456 19.299 100 31 62 0 2042323056 71754624 11502976
23:48:27 23410 8192000000 10948270432 11395313664 1945324256 19.189 99 30 60 0 2025161616 69389696 10447664
23:48:58 14925 8192000000 10946042768 11398135808 1943246096 19.173 99 38 74 4 2018093632 61946432 12901104
23:49:33 33651 8192000000 10942141552 11397840896 1958393344 19.293 100 25 50 1 2027667472 59614048 9660080
23:50:13 23874 8192000000 10948742096 11403407360 1951963456 19.242 100 24 48 0 2026428112 65107888 9356768
23:51:03 22720 8192000000 10930824864 11396235264 1912697152 18.928 98 24 49 0 1991944720 69941472 9306096
23:51:39 27503 8192000000 10907549904 11387252736 1932694672 19.088 100 20 40 0 1981324192 41737616 6891904
23:52:13 48745 8192000000 10913286736 11382071296 1948436896 19.214 100 17 34 0 1990989664 36449632 6103136
23:53:15 22064 8192000000 10877556256 11358343168 1936670480 19.120 99 11 22 1 1967318976 26893568 3754928
23:53:48 113753 8192000000 10870984128 11322994688 1835748864 18.306 94 25 51 2 1859493872 16786624 6958384
23:55:49 66245 8192000000 10867220128 11337285632 1917165040 18.964 99 18 36 1 1930358304 7744096 5449168
23:57:02 17629 8192000000 10858838176 11329073152 1936519056 19.119 100 9 18 0 1949477520 10611552 2346912
23:57:26 19100 8192000000 10855689664 11317329920 1902722752 18.848 98 11 23 1 1916470944 10581744 3166448
23:59:07 76838 8192000000 10907640368 11371589632 1955530240 19.270 100 15 30 2 1976167376 16658320 3978816
00:00:38 81942 8192000000 10896979424 11365023744 1929823408 19.065 98 16 32 0 1960114624 25357984 4933232
00:02:27 103739 8192000000 10872140816 11334729728 1880998016 18.673 96 19 38 1 1898786064 12432512 5355536
00:04:37 106982 8192000000 10872045040 11340554240 1929640272 19.064 99 22 44 0 1948389680 12154480 6594928
00:06:31 54089 8192000000 10880188288 11348459520 1941250672 19.157 99 15 30 1 1954581808 8766640 4564496
00:08:26 58131 8192000000 10879660048 11349938176 1933314816 19.093 99 7 14 0 1945084752 9717168 2052768
00:09:31 48396 8192000000 10896446048 11357630464 1961221104 19.316 100 28 56 3 1981438976 11372944 8844928
00:10:37 39645 8192000000 10918443600 11381325824 1975947296 19.433 100 27 54 2 2001162784 17298448 7917040
00:11:32 77818 8192000000 10934576032 11399475200 1987814896 19.527 100 16 32 1 2011229600 18777040 4637664
00:12:56 47682 8192000000 10902234240 11382697984 1940532368 19.151 98 14 28 0 1965357728 20721408 4103952
00:13:59 38829 8192000000 10908494672 11373514752 1975416160 19.428 100 14 28 0 1986470592 7017840 4036592
00:14:49 22967 8192000000 10903087872 11366240256 1974335552 19.420 100 33 64 2 1992254944 8623536 9295856
00:15:18 47222 8192000000 10903977376 11358756864 1920657040 18.992 97 24 48 1 1935072768 7815248 6600480
00:16:27 29649 8192000000 10913617504 11371282432 1941369520 19.158 98 29 58 0 1957260512 8706032 7184960
00:17:03 18464 8192000000 10932855328 11379580928 1981146304 19.474 100 46 92 0 2005084192 11453744 12484144
00:17:29 20129 8192000000 10939417136 11383832576 1982667312 19.486 100 37 74 1 2004369248 11656656 10045280
00:18:10 50387 8192000000 10934411008 11387596800 1986338080 19.515 100 33 66 0 2011757680 16353344 9066256
00:19:06 39570 8192000000 10933340864 11384258560 1959562320 19.303 98 44 88 1 1988083552 15893840 12627392
00:19:57 78048 8192000000 10893818304 11371761664 1932690240 19.088 98 26 52 2 1963252256 22869120 7692896
00:21:25 64113 8192000000 10901596736 11361513472 1930112960 19.068 98 19 38 0 1946189536 10257728 5818848
00:22:37 48118 8192000000 10841693040 11306446848 1907765216 18.889 97 16 32 2 1920621024 8323088 4532720
00:23:57 75822 8192000000 10872524464 11334221824 1863996736 18.536 95 13 26 1 1874238848 6881936 3360176
00:25:25 69841 8192000000 10892338816 11356459008 1946271424 19.197 99 41 82 1 1969918128 11579296 12067408
00:26:42 17161 8192000000 10897514432 11363680256 1969723328 19.383 100 18 36 0 1985700768 10917024 5060416
00:27:05 32559 8192000000 10906353360 11363430400 1943108944 19.172 98 29 58 0 1962730944 10680576 8941424
00:27:50 84665 8192000000 10877648096 11359760384 1909064672 18.899 97 14 28 1 1927806640 14836384 3905584
00:29:21 83458 8192000000 10870190208 11339993088 1882954544 18.689 96 14 28 0 1900138320 13485104 3698672
00:30:51 43368 8192000000 10865290928 11343597568 1926156032 19.036 99 7 14 0 1941906560 14072624 1677904
00:31:40 76965 8192000000 10877205664 11344191488 1895023936 18.786 97 21 42 2 1923481648 22690256 5767456
00:33:04 70465 8192000000 10869317456 11336642560 1889018560 18.738 97 12 24 0 1903807312 11645280 3143472
00:34:21 60965 8192000000 10878465856 11341447168 1862933952 18.527 95 20 40 2 1877708656 9182992 5591712
00:36:20 56482 8192000000 10900596384 11364016128 1946456752 19.198 99 19 38 1 1967376544 15431360 5488432
00:37:23 108088 8192000000 10875154672 11352657920 1843999088 18.373 94 23 46 0 1874079120 23449856 6630176
00:39:22 57010 8192000000 10894259232 11352346624 1928971472 19.059 99 26 51 0 1947500144 11514352 7014320
00:40:25 59056 8192000000 10885547392 11358371840 1934966672 19.107 99 20 40 3 1955547216 15029392 5551152
00:41:33 65575 8192000000 10887679952 11346153472 1902665072 18.848 97 22 44 0 1922671552 13357392 6649088
00:42:47 48843 8192000000 10897436192 11361837056 1943003504 19.171 99 21 42 0 1958723344 9081312 6638528
00:43:48 61228 8192000000 10879634800 11353997312 1885250224 18.707 96 30 60 1 1907879312 14575488 8053600
00:45:00 118338 8192000000 10874293056 11339304960 1929936448 19.066 99 11 22 0 1943599280 10675920 2986912
00:47:44 61442 8192000000 10887360128 11354091520 1954485792 19.262 100 9 18 1 1968014272 11111856 2416624
00:49:15 41568 8192000000 10871520720 11333505024 1906599936 18.879 97 33 67 0 1925441968 9362832 9479200
00:50:04 39393 8192000000 10881728096 11355152384 1933748288 19.097 99 12 25 0 1945885584 8733232 3404064
00:50:55 56814 8192000000 10880778464 11355856896 1938853920 19.138 99 10 20 0 1953484672 11603696 3027056
00:52:02 39829 8192000000 10907299264 11357499392 1948161968 19.212 99 27 52 1 1966675600 11169248 7344384
00:52:55 62330 8192000000 10873499584 11340042240 1909718496 18.904 97 22 44 0 1929717232 13465280 6533456
00:54:04 96193 8192000000 10872262688 11354869760 1914175920 18.940 98 12 24 1 1931649376 13989616 3483840
00:55:49 44573 8192000000 10889641184 11361271808 1957779232 19.288 100 22 44 3 1979471952 14684336 7008384
00:56:57 87044 8192000000 10874499632 11347304448 1876583872 18.638 95 19 36 1 1893300240 12029408 4686960
00:58:32 79666 8192000000 10878168688 11357143040 1931836944 19.082 99 12 24 0 1948432592 13640432 2955216
00:59:58 31976 8192000000 10880649200 11339444224 1904523488 18.863 97 18 36 0 1916746992 7619984 4603520
01:00:36 29218 8192000000 10905549616 11358793728 1948220416 19.212 99 39 78 0 1969016576 10371872 10424288
01:01:11 30492 8192000000 10926426128 11379126272 1975642976 19.430 100 39 78 2 1996655168 10200160 10812032
01:01:51 38824 8192000000 10909772448 11378245632 1957233728 19.284 99 39 78 3 1985527648 16783552 11510368
01:02:37 70822 8192000000 10890908048 11368214528 1947645456 19.208 99 15 30 0 1963573648 11931536 3996656
01:03:56 56183 8192000000 10940678960 11386626048 1975876832 19.432 100 29 57 0 1994839696 10912704 8050160
01:04:59 29194 8192000000 10913226784 11374653440 1962154112 19.323 99 28 56 1 1982628464 12733136 7741216
01:05:37 76553 8192000000 10941693120 11397623808 1991583616 19.556 100 22 45 0 2011633920 13866528 6183776
01:07:04 57920 8192000000 10927383312 11400658944 1974444048 19.421 99 24 48 2 1995554880 14191472 6919360
01:08:19 70220 8192000000 10923892288 11386601472 1936582560 19.119 97 18 36 2 1951185856 9667408 4935888
01:09:42 33481 8192000000 10905581776 11384750080 1969226352 19.379 100 16 32 1 1988103536 14564064 4313120
01:10:22 75200 8192000000 10893971536 11358900224 1885601824 18.710 95 22 43 0 1905495808 14316000 5577984
01:11:43 131688 8192000000 10886962144 11357442048 1915848768 18.954 97 23 45 2 1930171264 8079328 6243168
01:14:01 96663 8192000000 10879384624 11341746176 1852882384 18.446 94 17 34 0 1872697392 15445408 4369600
01:15:45 25905 8192000000 10862200576 11329150976 1920314224 18.989 98 27 54 0 1940845712 12622768 7908720
01:17:55 79751 8192000000 10875772032 11367989248 1960639808 19.311 100 16 33 0 1981811824 16468784 4703232
01:19:22 50009 8192000000 10855666512 11321372672 1886944656 18.721 97 15 29 0 1903157232 12086608 4125968
01:20:32 73084 8192000000 10856987936 11334021120 1899046816 18.819 98 14 29 0 1913585696 10536432 4002448
01:22:00 51510 8192000000 10857718128 11338985472 1925671968 19.032 99 21 41 3 1945799680 13392352 6735360
01:23:02 66472 8192000000 10871921664 11352879104 1949699184 19.224 100 20 40 1 1968672960 13668848 5304928
01:24:15 59403 8192000000 10878832480 11348512768 1918201760 18.972 98 13 26 0 1938097392 16097072 3798560
01:25:22 84017 8192000000 10865424288 11330678784 1851557488 18.435 95 17 34 0 1867776544 10743440 5475616
01:26:53 20430 8192000000 9164758096 9398714368 326887744 3.837 18 2 4 0 329347936 2335568 124624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 06-12-2020 01:28:27 to 06-12-2020 01:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 94 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-12-2020 01:28:58 to 06-12-2020 01:29:00.

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          234264
MON$OLDEST_ACTIVE               234265
MON$OLDEST_SNAPSHOT             234265
MON$NEXT_TRANSACTION            234265
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                       2028000
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

06.12.20 01:29:01. 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
2020-12-06 01:29:03 No severe PSQL-related problems occured
06.12.20 01:29:04. End of report.