Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.04.2021 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 df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
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.26
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 17493108 kB
MemAvailable 31441008 kB
Buffers 0 kB
Cached 14154528 kB
SwapCached 0 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-04-02 01:27:25
DTS_END                         2021-04-02 01:27:25.8020
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_FROM_CUSTOMER(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/48098
TRN_ID                          241336
ATT_ID                          694
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: 9400.15 23619 1128018
customer order: creation 172.35 349 20682
customer order: refuse 14.48 343 1738
order to supplier: creation 47.03 1292 5643
order to supplier: removal 3.54 99064 425
invoice (draft): creation 46.84 3451 5621
invoice (draft): removal 53.10 753 6372
invoice accept: apply 42.25 18078 5070
invoice accept: cancel 48.19 833 5783
customer reserve: creation 3939.82 178 472778
customer reserve: removal 4733.23 59 567987
realization accept: apply 84.36 171 10123
realization accept: cancel 84.90 104 10188
payment from customer: creation 59.66 119 7159
payment from customer: removal 5.97 78 716
payment to supplier: creation 48.43 138 5811
payment to supplier: removal 3.53 81 424
service: total inventory turnovers 4.86 987 583
service: total monetary turnovers 6.77 32 812
service: aggregate perf. data 0.83 19205 99
service: refresh index statistics 0.03 327067 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-04-2021 01:28:17 to 02-04-2021 01:28:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6047
TEST_TIME 2 7738
TEST_TIME 3 6644
TEST_TIME 4 6601
TEST_TIME 5 6394
TEST_TIME 6 6031
TEST_TIME 7 6077
TEST_TIME 8 5806
TEST_TIME 9 5851
TEST_TIME 10 6147
TEST_TIME 11 6387
TEST_TIME 12 6547
TEST_TIME 13 6485
TEST_TIME 14 6489
TEST_TIME 15 6719
TEST_TIME 16 7125
TEST_TIME 17 7179
TEST_TIME 18 7280
TEST_TIME 19 8184
TEST_TIME 20 8776
TEST_TIME 21 8904
TEST_TIME 22 9297
TEST_TIME 23 9709
TEST_TIME 24 9907
TEST_TIME 25 10190
TEST_TIME 26 11199
TEST_TIME 27 11066
TEST_TIME 28 10707
TEST_TIME 29 10459
TEST_TIME 30 10285
TEST_TIME 31 10122
TEST_TIME 32 10302
TEST_TIME 33 10128
TEST_TIME 34 9934
TEST_TIME 35 9798
TEST_TIME 36 9663
TEST_TIME 37 9593
TEST_TIME 38 9501
TEST_TIME 39 9803
TEST_TIME 40 9754
TEST_TIME 41 9693
TEST_TIME 42 9663
TEST_TIME 43 9614
TEST_TIME 44 9724
TEST_TIME 45 9690
TEST_TIME 46 9599
TEST_TIME 47 9574
TEST_TIME 48 9641
TEST_TIME 49 9710
TEST_TIME 50 9728
TEST_TIME 51 9646
TEST_TIME 52 9856
TEST_TIME 53 9823
TEST_TIME 54 9723
TEST_TIME 55 9622
TEST_TIME 56 9655
TEST_TIME 57 9547
TEST_TIME 58 9543
TEST_TIME 59 9588
TEST_TIME 60 9590
TEST_TIME 61 9560
TEST_TIME 62 9488
TEST_TIME 63 9458
TEST_TIME 64 9421
TEST_TIME 65 9500
TEST_TIME 66 9444
TEST_TIME 67 9446
TEST_TIME 68 9490
TEST_TIME 69 9480
TEST_TIME 70 9585
TEST_TIME 71 9529
TEST_TIME 72 9574
TEST_TIME 73 9539
TEST_TIME 74 9569
TEST_TIME 75 9627
TEST_TIME 76 9626
TEST_TIME 77 9750
TEST_TIME 78 9702
TEST_TIME 79 9669
TEST_TIME 80 9633
TEST_TIME 81 9606
TEST_TIME 82 9569
TEST_TIME 83 9557
TEST_TIME 84 9499
TEST_TIME 85 9492
TEST_TIME 86 9471
TEST_TIME 87 9412
TEST_TIME 88 9375
TEST_TIME 89 9359
TEST_TIME 90 9444
TEST_TIME 91 9403
TEST_TIME 92 9480
TEST_TIME 93 9509
TEST_TIME 94 9521
TEST_TIME 95 9506
TEST_TIME 96 9516
TEST_TIME 97 9512
TEST_TIME 98 9573
TEST_TIME 99 9553
TEST_TIME 100 9530
TEST_TIME 101 9613
TEST_TIME 102 9583
TEST_TIME 103 9638
TEST_TIME 104 9642
TEST_TIME 105 9555
TEST_TIME 106 9501
TEST_TIME 107 9504
TEST_TIME 108 9467
TEST_TIME 109 9456
TEST_TIME 110 9452
TEST_TIME 111 9405
TEST_TIME 112 9404
TEST_TIME 113 9351
TEST_TIME 114 9389
TEST_TIME 115 9401
TEST_TIME 116 9421
TEST_TIME 117 9401
TEST_TIME 118 9418
TEST_TIME 119 9435
TEST_TIME 120 9404

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-04-2021 01:28:21 to 02-04-2021 01:28:24.

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 1566077 1566077 0 0.00 0 22497 6 0 0
doc_list_biud 1566075 1566075 0 0.00 0 39527 27 0 0
sp_add_invoice_to_stock 5189 5070 119 2.29 46 230887 18079 0 119
sp_cancel_adding_invoice 5783 5783 0 0.00 6 67635 834 0 0
sp_cancel_client_order 1738 1738 0 0.00 3 14777 344 0 0
sp_cancel_customer_reserve 567987 567987 0 0.00 1 39529 59 0 0
sp_cancel_pay_from_customer 716 716 0 0.00 3 9298 78 0 0
sp_cancel_pay_to_supplier 424 424 0 0.00 3 6076 81 0 0
sp_cancel_supplier_invoice 6379 6372 7 0.10 1 21914 753 0 7
sp_cancel_supplier_order 425 425 0 0.00 7 1096793 99064 0 0
sp_cancel_write_off 10188 10188 0 0.00 1 9859 105 0 0
sp_client_order 20682 20682 0 0.00 3 20179 349 0 0
sp_customer_reserve 472778 472778 0 0.00 0 92971 178 0 0
sp_fill_shopping_cart 31930 31930 0 0.00 1 14562 38 0 0
sp_fill_shopping_cart_clo_res 472773 472773 0 0.00 0 11458 13 0 0
sp_get_clo_for_invoice 5063 5063 0 0.00 0 32811 269 0 0
sp_kill_cost_storno 17111 17111 0 0.00 0 11275 55 0 0
sp_kill_qstorno_ret_qs2qd 1152959 1152959 0 0.00 0 39522 32 0 0
sp_kill_qty_storno 607679 607679 0 0.00 0 39527 69 0 0
sp_lock_selected_doc 21031 21031 0 0.00 0 8725 5 0 0
sp_make_cost_storno 28156 28156 0 0.00 0 22494 50 0 0
sp_multiply_rows_for_pdistr 28156 28156 0 0.00 0 13258 29 0 0
sp_multiply_rows_for_qdistr 20682 20682 0 0.00 0 14449 147 0 0
sp_pay_from_customer 7159 7159 0 0.00 4 13267 119 0 0
sp_pay_to_supplier 5811 5811 0 0.00 4 22503 139 0 0
sp_payment_common 12970 12970 0 0.00 1 15898 31 0 0
sp_qd_handle_on_cancel_clo 1738 1738 0 0.00 0 14770 323 0 0
sp_qd_handle_on_invoice_upd_sts 10846 10846 0 0.00 0 21498 304 0 0
sp_qd_handle_on_reserve_upd_sts 10123 10123 0 0.00 0 22336 65 0 0
sp_reserve_write_off 10123 10123 0 0.00 7 22358 172 0 0
sp_supplier_invoice 5621 5621 0 0.00 6 77305 3451 0 0
sp_supplier_order 5643 5643 0 0.00 5 48999 1292 0 0
srv_aggregate_perf_data 99 99 0 0.00 2937 421764 19206 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 977 149553 33422 0 0
srv_find_qd_qs_mism 1079833 1079833 0 0.00 0 17967 6 0 0
srv_make_invnt_saldo 583 583 0 0.00 38 32654 988 0 0
srv_make_money_saldo 812 812 0 0.00 1 10660 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 133548 670798 327067 0 0
t$perf-abend:sp_add_invoice_to_stock 119 119 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5070 5070 0 0.00 0 12161 167 0 0
t$perf-norm:sp_cancel_adding_invoice 451 451 0 0.00 0 5965 131 0 0
t$perf-norm:sp_cancel_client_order 1738 1738 0 0.00 0 4710 15 0 0
t$perf-norm:sp_cancel_customer_reserve 696 696 0 0.00 0 2408 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 716 716 0 0.00 0 2794 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 424 424 0 0.00 0 585 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 970 13 0 0
t$perf-norm:sp_cancel_supplier_order 425 425 0 0.00 0 27271 1507 0 0
t$perf-norm:sp_cancel_write_off 1004 1004 0 0.00 0 5940 11 0 0
t$perf-norm:sp_client_order 20682 20682 0 0.00 0 5084 16 0 0
t$perf-norm:sp_customer_reserve 939 939 0 0.00 0 7269 16 0 0
t$perf-norm:sp_pay_from_customer 7159 7159 0 0.00 0 7606 8 0 0
t$perf-norm:sp_pay_to_supplier 5811 5811 0 0.00 0 6447 12 0 0
t$perf-norm:sp_reserve_write_off 10123 10123 0 0.00 0 13190 12 0 0
t$perf-norm:sp_supplier_invoice 5621 5621 0 0.00 0 11611 26 0 0
t$perf-norm:sp_supplier_order 5643 5643 0 0.00 0 7247 14 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 475 21 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 4280 30 0 0
t$perf-norm:srv_make_invnt_saldo 583 583 0 0.00 0 585 14 0 0
t$perf-norm:srv_make_money_saldo 812 812 0 0.00 0 1674 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 10 5 0 0
v_add_invoice_to_stock 10364 10126 238 2.29 0 8494 22 0 238
v_all_customers 38076 38076 0 0.00 0 106 1 0 0
v_all_suppliers 31154 31154 0 0.00 0 71 1 0 0
v_all_wares 41364 41364 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 902 902 0 0.00 0 954 8 0 0
v_cancel_client_order 3476 3476 0 0.00 0 2976 4 0 0
v_cancel_customer_prepayment 1432 1432 0 0.00 0 2732 7 0 0
v_cancel_customer_reserve 1392 1392 0 0.00 0 2658 6 0 0
v_cancel_payment_to_supplier 848 848 0 0.00 0 6045 12 0 0
v_cancel_supplier_invoice 796 782 14 1.75 0 8764 25 0 14
v_cancel_supplier_order 850 850 0 0.00 0 1145 4 0 0
v_cancel_write_off 2008 2008 0 0.00 0 2375 12 0 0
v_max_id_clo_ord 5643 5643 0 0.00 0 915 2 0 0
v_max_id_clo_res 939 939 0 0.00 0 5354 21 0 0
v_max_id_ord_sup 5604 5604 0 0.00 0 4120 4 0 0
v_max_non_paid_invoice 1481 1481 0 0.00 0 6930 7 0 0
v_max_non_paid_realizn 3655 3655 0 0.00 0 994 3 0 0
v_min_id_clo_ord 5643 5643 0 0.00 0 3614 5 0 0
v_min_id_clo_res 939 939 0 0.00 0 1401 7 0 0
v_min_id_ord_sup 5604 5604 0 0.00 0 5205 5 0 0
v_min_non_paid_invoice 5811 5811 0 0.00 0 15894 24 0 0
v_min_non_paid_realizn 7159 7159 0 0.00 0 7207 21 0 0
v_our_firm 10296 10296 0 0.00 0 15 1 0 0
v_reserve_write_off 20246 20246 0 0.00 0 6042 7 0 0
x_lock_depdocs_on_canc_invoice 11764 11764 0 0.00 0 16210 130 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 3137 297 0 0
x_make_qstorno_1000_1200 5643 5643 0 0.00 1 48984 1219 0 0
x_make_qstorno_1200_2000 5621 5621 0 0.00 3 77296 3309 0 0
x_make_qstorno_2100_3300 472778 472778 0 0.00 0 92970 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-04-2021 01:28:25 to 02-04-2021 01:28:29.

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:29 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:35 19348 8192000000 10250690496 10560397312 838742736 9.287 65 49 101 1 857802432 2398000 16661696
22:58:03 20016 8192000000 10329380000 10649616384 1387910944 14.487 100 78 156 0 1417685200 4376832 25397424
22:58:35 33701 8192000000 10391911424 10711732224 1436714624 14.921 100 91 181 2 1472084656 6183888 29186144
22:59:21 24004 8192000000 10418037344 10746552320 1474657360 15.255 100 92 184 0 1515514272 11713104 29143808
22:59:53 16754 8192000000 10426185968 10754592768 1482023536 15.319 100 88 175 1 1519085728 8503328 28558864
23:00:30 24993 8192000000 10449784080 10782392320 1505561616 15.525 100 92 184 0 1544652032 9493088 29597328
23:01:08 18948 8192000000 10454669936 10791399424 1516707680 15.622 100 83 166 0 1552822864 9942816 26172368
23:01:39 17177 8192000000 10476665776 10822045696 1532788768 15.761 100 76 152 0 1566238880 9707552 23742560
23:02:04 18526 8192000000 10525921152 10875138048 1578847648 16.158 100 80 160 1 1613733088 10514144 24371296
23:02:32 11817 8192000000 10558197264 10913210368 1613218704 16.452 100 80 160 1 1648477616 11369024 23889888
23:02:51 11721 8192000000 10585590736 10943135744 1632150928 16.613 100 74 146 1 1664986224 11130064 21705232
23:03:11 11947 8192000000 10606381072 10968666112 1660572160 16.854 100 80 160 0 1697083600 12410832 24100608
23:03:33 10557 8192000000 10625829520 10990817280 1675897376 16.983 100 77 154 1 1711733136 12681168 23154592
23:03:53 6914 8192000000 10631975104 11001438208 1697211040 17.162 100 83 166 1 1734484080 12734048 24538992
23:04:13 10314 8192000000 10647104112 11023335424 1711463456 17.281 100 71 142 0 1744823968 12173024 21187488
23:04:33 5886 8192000000 10668735888 11043737600 1727552800 17.415 100 77 152 3 1761988864 12806624 21629440
23:04:47 5922 8192000000 10664994704 11044716544 1730744112 17.442 100 76 152 1 1766194320 13370496 22079712
23:05:00 5888 8192000000 10690008288 11067535360 1747143792 17.578 100 77 154 0 1782261824 12016544 23101488
23:05:13 6648 8192000000 10687764560 11070496768 1751257488 17.612 100 74 147 1 1784481184 11783360 21440336
23:05:29 4283 8192000000 10700813088 11082428416 1764440032 17.721 100 67 134 1 1794949856 11598768 18911056
23:05:41 4347 8192000000 10718458464 11099729920 1779434720 17.845 100 77 154 1 1812931328 12013936 21482672
23:05:52 3949 8192000000 10724482384 11105189888 1784099472 17.883 100 89 178 0 1822276448 12947840 25229136
23:06:03 3623 8192000000 10733493200 11116015616 1791769200 17.946 100 83 168 0 1829057392 13828128 23460064
23:06:14 2708 8192000000 10737349984 11117752320 1799614352 18.011 100 85 170 0 1836225168 13371168 23239648
23:06:23 2745 8192000000 10747133936 11125956608 1801438192 18.026 100 89 176 0 1839854640 14136912 24279536
23:06:33 2901 8192000000 10744451920 11129528320 1802671808 18.036 100 90 177 1 1841943280 15125632 24145840
23:06:43 3994 8192000000 10740006832 11130703872 1802799824 18.037 100 76 152 2 1837903408 13823712 21279872
23:06:53 3419 8192000000 10761138576 11145424896 1816163424 18.146 100 85 167 1 1852454080 12409520 23881136
23:07:04 2080 8192000000 10764857216 11149889536 1824862704 18.217 100 78 157 1 1859091728 11860912 22368112
23:07:12 2574 8192000000 10773114176 11159334912 1833996656 18.292 100 88 177 0 1871896896 13555104 24345136
23:07:21 2326 8192000000 10782133616 11163820032 1835850992 18.307 100 91 183 1 1874747616 13643440 25253184
23:07:30 1887 8192000000 10783553392 11169210368 1840228288 18.343 100 86 174 2 1877799088 13414848 24155952
23:07:39 2289 8192000000 10783944864 11172634624 1846274800 18.392 100 88 175 1 1885166864 14639840 24252224
23:07:47 1673 8192000000 10785462144 11178340352 1849690976 18.420 100 91 181 2 1889198416 14312944 25194496
23:07:56 2243 8192000000 10796122160 11181453312 1853064192 18.447 100 92 185 2 1892410864 12357392 26989280
23:08:04 1608 8192000000 10797916272 11185184768 1855477104 18.467 100 87 175 2 1891951360 11781408 24692848
23:08:13 2427 8192000000 10805906192 11190956032 1859898928 18.502 100 93 185 1 1898011872 11693312 26419632
23:08:22 1505 8192000000 10801584320 11192598528 1861342640 18.514 100 85 171 1 1897085904 12366112 23377152
23:08:30 40653 8192000000 10770633840 11199807488 1863811680 18.534 100 36 72 1 1882422336 7942880 10667776
23:09:19 4986 8192000000 10788295744 11207204864 1868195008 18.570 100 28 56 1 1887615648 11095408 8325232
23:09:31 6353 8192000000 10781843936 11208273920 1870424064 18.588 100 29 59 1 1890191760 11618128 8149568
23:09:46 6443 8192000000 10788026304 11213582336 1875909088 18.632 100 33 66 0 1893315296 7889712 9516496
23:09:59 7159 8192000000 10793205776 11214598144 1877184896 18.642 100 31 60 1 1893135456 7977568 7972992
23:10:13 12084 8192000000 10777406128 11213475840 1877722544 18.647 100 16 32 2 1888300960 6549024 4029392
23:10:33 6686 8192000000 10786988208 11215253504 1879550592 18.661 100 23 46 3 1892413008 6347616 6514800
23:10:47 11937 8192000000 10778405888 11213758464 1877001760 18.641 100 9 18 3 1884702960 5430656 2270544
23:11:05 12670 8192000000 10784643520 11217457152 1880389088 18.668 100 19 38 1 1892127344 6195664 5542592
23:11:25 9245 8192000000 10791648048 11223494656 1884694880 18.703 100 17 36 0 1894481136 5255792 4530464
23:11:42 8593 8192000000 10792205120 11224465408 1885692144 18.711 100 16 32 0 1896121040 5964080 4464816
23:11:57 15081 8192000000 10813728208 11227656192 1887534224 18.726 100 24 47 0 1900469264 6088208 6846832
23:12:21 14519 8192000000 10802949312 11232673792 1892754832 18.768 100 28 55 0 1907240224 5924720 8560672
23:12:59 54732 8192000000 10813837312 11251163136 1902106848 18.843 100 28 54 2 1916387728 5664784 8616096
23:14:01 13133 8192000000 10814045536 11250003968 1902286144 18.845 100 22 43 2 1914811776 5539024 6986608
23:14:21 10713 8192000000 10819349248 11253112832 1905782256 18.873 100 34 66 4 1922602288 7351856 9468176
23:14:39 5955 8192000000 10830067984 11261177856 1907109696 18.883 100 32 65 1 1927082896 10729648 9243552
23:14:52 5334 8192000000 10816153456 11252412416 1907497280 18.887 100 25 50 0 1919896880 5345808 7053792
23:15:05 3724 8192000000 10832847104 11256815616 1909944048 18.906 100 39 78 0 1928909696 7810704 11154944
23:15:16 5852 8192000000 10820037680 11253850112 1907626720 18.888 100 31 59 0 1921333856 5299024 8408112
23:15:29 8632 8192000000 10806414016 11242725376 1885127504 18.706 99 20 39 0 1896633328 5481520 6024304
23:15:46 5297 8192000000 10818315136 11251007488 1901666864 18.840 100 28 55 3 1915850544 6611072 7572608
23:15:58 7345 8192000000 10819664304 11247972352 1884791888 18.704 99 16 31 1 1894808224 5595040 4421296
23:16:13 9926 8192000000 10814286160 11246088192 1899833920 18.825 100 15 30 0 1910007328 5745616 4427792
23:16:29 7235 8192000000 10824954848 11248971776 1896783856 18.800 100 27 54 0 1914850592 9877648 8189088
23:16:49 12867 8192000000 10797732976 11224100864 1834988656 18.300 97 18 35 0 1845982944 5581504 5412784
23:17:08 8613 8192000000 10785008064 11211898880 1823434720 18.206 97 22 44 0 1836033856 6029760 6569376
23:17:25 13663 8192000000 10742894336 11166908416 1742972016 17.543 93 27 52 2 1755768384 5006304 7790064
23:17:48 64895 8192000000 10732504384 11158351872 1725431856 17.397 93 22 44 0 1736876784 5466720 5978208
23:18:59 12938 8192000000 10696015344 11106742272 1656987696 16.823 90 30 61 0 1671387952 5792608 8607648
23:19:19 5178 8192000000 10719447504 11130904576 1769974480 17.767 98 42 83 3 1789562544 7808416 11779648
23:19:31 5151 8192000000 10719448896 11138355200 1781151632 17.859 98 38 76 2 1798193536 6217392 10824512
23:19:43 4440 8192000000 10729080336 11130789888 1754662672 17.640 97 39 75 2 1773793456 8391504 10739280
23:19:53 2898 8192000000 10690295744 11094052864 1742205760 17.537 97 37 72 0 1760550016 7707008 10637248
23:20:03 6464 8192000000 10696106368 11101888512 1747205072 17.578 98 28 54 3 1761429632 6859200 7365360
23:20:16 6705 8192000000 10716052336 11133550592 1784530336 17.887 99 29 58 2 1799070832 6196720 8343776
23:20:32 9114 8192000000 10721673264 11141505024 1762189360 17.702 97 36 72 0 1778243824 5593664 10460800
23:20:50 7172 8192000000 10726905968 11148894208 1796926080 17.989 99 23 45 4 1808824368 5251024 6647264
23:21:03 6734 8192000000 10712299680 11130785792 1770343200 17.770 98 27 53 1 1784232464 5695680 8193584
23:21:16 8620 8192000000 10700091504 11113193472 1773865568 17.799 98 18 36 0 1784846384 5393632 5587184
23:21:31 10353 8192000000 10726639056 11144110080 1777608192 17.830 98 33 67 0 1796775616 9171168 9996256
23:21:47 10445 8192000000 10728780544 11151568896 1804287312 18.049 99 30 60 3 1818921536 5435904 9198320
23:22:05 55987 8192000000 10775022208 11170320384 1829572016 18.256 100 57 115 2 1856144976 9754208 16818752
23:23:07 4043 8192000000 10741018192 11169767424 1830937184 18.267 100 33 66 4 1848309600 8267920 9104496
23:23:19 6237 8192000000 10756252464 11181838336 1835634512 18.305 100 27 54 0 1853539856 10102720 7802624
23:23:34 3291 8192000000 10765425456 11188854784 1845054320 18.382 100 39 79 1 1863601792 7489088 11058384
23:23:44 6160 8192000000 10778236768 11194200064 1838151104 18.326 99 39 74 2 1856100560 6842336 11107120
23:23:57 6184 8192000000 10770582912 11194884096 1851585360 18.435 100 26 52 1 1866083680 6709072 7789248
23:24:09 6100 8192000000 10759251792 11188133888 1849354096 18.417 100 38 76 1 1870861392 10990800 10516496
23:24:21 8452 8192000000 10769783952 11192352768 1852812000 18.445 100 32 64 1 1868381472 5793168 9776304
23:24:38 4968 8192000000 10780253680 11201998848 1857431344 18.482 100 44 88 2 1881291776 11383008 12477424
23:24:52 8968 8192000000 10778213104 11200299008 1857383312 18.482 100 28 56 1 1871696336 5838832 8474192
23:25:09 8959 8192000000 10769473856 11200258048 1860292624 18.506 100 26 52 0 1875103008 6503920 8306464
23:25:24 6235 8192000000 10783994016 11214442496 1865994112 18.552 100 41 82 0 1890311824 11823264 12494448
23:25:45 5972 8192000000 10777835760 11208675328 1866648640 18.557 100 33 67 1 1881821728 5262064 9911024
23:25:58 10197 8192000000 10780194752 11211853824 1866307424 18.554 100 22 44 0 1878294736 5684608 6302704
23:26:16 16245 8192000000 10790009760 11220705280 1870004480 18.584 100 18 35 1 1880558432 5594640 4959312
23:26:38 71799 8192000000 10808659200 11236286464 1881559552 18.678 100 30 60 0 1895430512 4814368 9056592
23:28:02 9298 8192000000 10838080656 11255205888 1908055984 18.891 100 42 84 2 1929998000 8794912 13147104
23:28:19 15194 8192000000 10846550336 11266068480 1912472240 18.926 100 45 90 0 1935167728 10076240 12619248
23:28:42 5085 8192000000 10853612528 11275309056 1922229984 19.005 100 48 95 0 1947387888 11610064 13547840
23:28:53 19882 8192000000 10859280576 11280572416 1922929776 19.010 100 51 100 4 1948229600 10977696 14322128
23:29:21 12355 8192000000 10866933680 11290828800 1931564144 19.079 100 47 92 3 1958997152 13890832 13542176
23:29:41 10914 8192000000 10876909584 11298476032 1939034640 19.139 100 56 113 4 1970422272 14854912 16532720
23:30:01 11648 8192000000 10879923280 11305037824 1941902032 19.162 100 57 114 2 1976473232 17966128 16605072
23:30:21 21551 8192000000 10873181792 11304157184 1943066656 19.171 100 52 104 2 1972529008 13723728 15738624
23:30:52 27815 8192000000 10878478256 11312320512 1948521504 19.215 100 49 97 0 1977264640 14555472 14187664
23:31:28 21289 8192000000 10882646016 11320324096 1953196688 19.252 100 39 77 0 1978585168 13591616 11796864
23:31:57 15350 8192000000 10901003152 11329302528 1958296512 19.292 100 52 104 1 1991519520 18155264 15067744
23:32:20 31588 8192000000 10914019824 11337629696 1967462640 19.365 100 66 130 1 2003074000 16504144 19107216
23:32:59 9676 8192000000 10916461696 11338932224 1972748592 19.407 100 60 121 0 2005586768 14298480 18539696
23:33:16 10480 8192000000 10912780160 11334819840 1969314496 19.380 100 62 124 2 2002446560 14698112 18433952
23:33:36 6581 8192000000 10913837424 11343699968 1974363904 19.420 100 57 114 3 2006719840 15747120 16608816
23:33:53 25940 8192000000 10925084896 11357626368 1977227920 19.443 100 56 112 3 2013234560 20278800 15727840
23:34:26 7959 8192000000 10925679424 11355308032 1978039648 19.449 100 49 98 0 2012611664 20700096 13871920
23:34:41 6622 8192000000 10922040256 11354038272 1978126896 19.450 100 48 96 0 2012057520 19890432 14040192
23:35:07 14542 8192000000 10923741248 11362668544 1983013968 19.489 100 45 90 1 2015506016 19010368 13481680
23:35:29 10513 8192000000 10930792400 11362398208 1984028528 19.497 100 54 106 1 2019343664 20026048 15289088
23:35:51 8531 8192000000 10938823648 11366989824 1985920000 19.512 100 58 113 1 2024028288 21530512 16577776
23:36:06 3736 8192000000 10949616240 11371282432 1991065760 19.552 100 63 125 1 2030967008 22255008 17646240
23:36:16 9551 8192000000 10955009232 11378421760 1998208192 19.609 100 68 136 0 2042072896 23945360 19919344
23:36:36 7157 8192000000 10954677328 11382587392 1997134960 19.600 100 68 136 1 2044145744 26839856 20170928
23:36:51 7137 8192000000 10961221200 11389464576 2002620048 19.643 100 76 152 2 2053511312 27843520 23047744
23:37:10 2857 8192000000 10968048016 11393773568 2004244912 19.656 100 65 129 0 2052116736 28352896 19518928
23:37:22 9519 8192000000 10946159168 11369590784 1963405744 19.333 98 66 130 2 2017963168 34777184 19780240
23:37:43 5202 8192000000 10942380976 11372154880 1984582672 19.501 100 65 129 2 2033200176 29098704 19518800
23:38:01 4453 8192000000 10961851904 11381358592 1995653056 19.588 100 70 139 1 2044683520 28716176 20314288
23:38:12 1851 8192000000 10971274672 11382263808 1993806560 19.574 100 86 171 3 2048308320 29910144 24591616
23:38:20 4714 8192000000 10959020688 11372810240 1985240912 19.506 100 82 164 0 2041111024 31402304 24467808
23:38:33 1581 8192000000 10958346688 11373875200 1978588880 19.454 99 84 168 2 2035797536 31617920 25590736
23:38:42 3355 8192000000 10950090160 11366391808 1964861504 19.345 99 74 147 1 2021524832 34589872 22073456
23:38:52 3578 8192000000 10946550272 11363262464 1975704848 19.431 100 77 151 1 2034067600 35472176 22890576
23:39:03 2275 8192000000 10950512352 11372367872 1983523456 19.493 100 86 170 1 2042912864 34118720 25270688
23:39:13 2937 8192000000 10958870432 11377098752 1988564720 19.532 100 81 162 1 2047160560 34432256 24163584
23:39:24 6555 8192000000 10937355408 11360186368 1961526560 19.318 99 72 143 0 2017160272 34348240 21285472
23:39:37 4359 8192000000 10952569024 11372826624 1982814992 19.487 100 73 145 2 2036030496 30974096 22241408
23:39:50 6273 8192000000 10934556592 11348963328 1945436784 19.190 98 79 158 0 2001202912 32523232 23242896
23:40:03 2360 8192000000 10940591264 11350642688 1960610224 19.311 99 89 178 3 2020606048 33417584 26578240
23:40:13 8256 8192000000 10956699264 11365064704 1975421520 19.428 100 67 133 0 2032266448 35803440 21041488
23:40:31 5036 8192000000 10957052128 11379838976 1984562912 19.501 100 75 150 0 2048543616 40909776 23070928
23:40:44 4624 8192000000 10960946800 11383529472 1987689008 19.526 100 65 130 1 2045460624 37415776 20355840
23:41:01 7124 8192000000 10963091456 11389657088 1986760672 19.518 100 59 118 3 2044935872 39243872 18931328
23:41:16 4611 8192000000 10974761504 11396358144 1995656688 19.588 100 71 142 0 2058693824 40662320 22374816
23:41:28 2431 8192000000 10990307072 11404324864 2001371760 19.634 100 86 172 1 2070237600 42553056 26312784
23:41:40 3143 8192000000 10977137136 11395870720 1992112320 19.560 100 80 160 1 2062176048 44567744 25495984
23:41:51 2757 8192000000 10982044064 11402719232 1997524944 19.603 100 79 159 1 2066822688 43616624 25681120
23:42:01 6543 8192000000 10976389040 11397853184 1981066496 19.473 99 73 146 0 2049341312 43997424 24277392
23:42:17 5572 8192000000 10959290144 11381911552 1974575824 19.422 99 60 119 0 2036043968 41918624 19549520
23:42:30 4789 8192000000 10971914544 11399073792 1996218400 19.593 100 66 132 1 2059013952 40699824 22095728
23:42:42 9162 8192000000 10974335472 11395694592 1988572944 19.533 100 72 144 3 2059804528 48001168 23230416
23:42:59 1853 8192000000 10991045264 11401986048 1995711728 19.589 100 85 167 3 2067518032 44634320 27171984
23:43:08 3508 8192000000 10970123840 11378716672 1968784320 19.376 99 81 161 2 2041305696 47125264 25396112
23:43:18 2872 8192000000 10976296976 11380723712 1974801616 19.424 100 87 172 2 2051911104 48895120 28214368
23:43:28 3559 8192000000 10963849488 11378249728 1962741424 19.328 99 87 171 1 2037674496 48513248 26419824
23:43:41 4292 8192000000 10963822544 11379380224 1962105856 19.323 99 83 165 1 2036989728 48825936 26057936
23:43:52 2975 8192000000 10974039120 11388628992 1982065376 19.481 100 78 155 0 2053117248 46378432 24673440
23:44:04 3748 8192000000 10965922736 11374632960 1956414288 19.278 99 82 161 1 2029994768 47625216 25955264
23:44:16 2832 8192000000 10956434960 11368501248 1961821792 19.321 100 81 161 1 2036301456 48932608 25547056
23:44:27 2108 8192000000 10963659296 11372269568 1966665984 19.359 100 83 164 3 2042232464 49451408 26115072
23:44:36 3600 8192000000 10964454608 11371024384 1958232576 19.292 100 83 163 2 2034185888 50124608 25828704
23:44:48 6368 8192000000 10960645616 11373903872 1966210560 19.355 100 69 134 1 2039153120 51906992 21035568
23:45:01 1586 8192000000 10985535632 11395362816 1982312304 19.483 100 83 166 1 2062353824 53480416 26561104
23:45:09 4908 8192000000 10985941424 11398828032 1983094352 19.489 100 84 168 3 2068708048 58695680 26918016
23:45:26 6221 8192000000 10979361136 11391660032 1978225552 19.451 100 87 173 2 2059336240 54012352 27098336
23:45:39 975 8192000000 10985231024 11388436480 1970903248 19.393 100 86 170 2 2056060352 58011056 27146048
23:45:46 4807 8192000000 10984621216 11403464704 1983069952 19.489 100 84 168 1 2069242944 58846144 27326848
23:45:59 4326 8192000000 10981025440 11404251136 1984318288 19.499 100 78 156 2 2065423520 55727200 25378032
23:46:10 3013 8192000000 10964314016 11383398400 1971756592 19.399 100 65 130 3 2042835328 49926656 21152080
23:46:29 6111 8192000000 10948735104 11385880576 1967964048 19.369 100 56 109 4 2038173952 52114112 18095792
23:46:56 4332 8192000000 10966978480 11393474560 1982748432 19.486 100 63 125 2 2051382288 47426752 21207104
23:47:08 4037 8192000000 10944754544 11367755776 1949403792 19.222 99 59 118 2 2019570528 50970928 19195808
23:47:18 3372 8192000000 10959940112 11385094144 1968035600 19.370 100 68 131 3 2042989792 53509072 21445120
23:47:28 8929 8192000000 10922408528 11358273536 1934313552 19.101 98 55 110 1 2010980832 57041280 19626000
23:47:49 15178 8192000000 10934084640 11377811456 1954560544 19.263 100 38 76 2 2014217840 46559888 13097408
23:48:17 16893 8192000000 10916158928 11355258880 1932745296 19.089 99 37 73 1 1987339408 42521712 12072400
23:48:43 9987 8192000000 10927898672 11361738752 1932009840 19.083 99 34 67 1 1994038080 50139072 11889168
23:49:01 21341 8192000000 10917451584 11360964608 1940555792 19.151 99 36 72 1 1993882368 41025088 12301488
23:49:36 18936 8192000000 10920093056 11363840000 1938621488 19.136 99 32 64 3 1992722512 43178592 10922432
23:50:11 17035 8192000000 10920005840 11366350848 1949818752 19.225 100 31 62 1 2004294944 43563536 10912656
23:50:53 25970 8192000000 10894553984 11356819456 1933724480 19.097 99 23 44 4 1975224032 33898352 7601200
23:51:49 36429 8192000000 10892686432 11350274048 1913283392 18.933 99 17 34 1 1960734816 40788112 6663312
23:52:32 78961 8192000000 10800240080 11266248704 1768436528 17.754 92 12 24 0 1809957520 37518128 4002864
23:54:15 116923 8192000000 10835584624 11281563648 1860682320 18.509 98 20 40 0 1875312032 8852816 5776896
23:56:40 95270 8192000000 10864291344 11313799168 1866700400 18.558 97 50 97 1 1892758944 11170496 14888048
23:58:39 52966 8192000000 10862596880 11339866112 1938430816 19.134 100 23 46 1 1962749968 17064160 7254992
23:59:51 43831 8192000000 10853647424 11314987008 1931279104 19.077 99 16 30 0 1945774000 10795840 3699056
00:00:45 60006 8192000000 10876032528 11341467648 1928761024 19.057 99 9 17 1 1940639296 9237200 2641072
00:01:51 13455 8192000000 10866304608 11328819200 1930307152 19.069 99 11 22 0 1951205984 17614688 3284144
00:02:12 60333 8192000000 10886018256 11346968576 1944127072 19.180 100 14 28 0 1967501376 19042656 4331648
00:03:18 19382 8192000000 10904929360 11358216192 1960912864 19.313 100 32 65 2 1992574816 21301424 10360528
00:04:00 149552 8192000000 10898537824 11367251968 1944652752 19.184 99 11 22 1 1971128944 23002192 3474000
00:06:36 58186 8192000000 10889125552 11372900352 1921446160 18.998 98 12 24 1 1942033648 17320336 3267152
00:07:45 100545 8192000000 10911311840 11371716608 1958665424 19.295 99 12 25 1 1971922608 9704800 3552384
00:09:33 49208 8192000000 10923205184 11368947712 1947300736 19.205 98 39 77 0 1968990192 10402752 11286704
00:10:35 18322 8192000000 10919444736 11379036160 1990757312 19.550 100 54 105 1 2019129408 12577552 15794544
00:11:08 125584 8192000000 10934299632 11379564544 1970203376 19.387 99 24 48 0 1990677504 13785264 6688864
00:13:26 8671 8192000000 10932258448 11386867712 1995867296 19.590 100 36 70 1 2013293376 7940240 9485840
00:13:42 25246 8192000000 10938251872 11391942656 1998263760 19.609 100 33 66 2 2018389088 10437776 9687552
00:14:20 30835 8192000000 10941391152 11393523712 1982941872 19.488 99 32 64 2 2002740192 10771120 9027200
00:14:59 115917 8192000000 10911280848 11397603328 1935876128 19.114 97 11 22 2 1960907344 21907376 3123840
00:17:01 63724 8192000000 10933468272 11394588672 1961383680 19.317 99 17 34 1 1981939888 15990464 4565744
00:18:12 26825 8192000000 10934322400 11389800448 1972324592 19.404 99 30 59 0 1998842288 18308448 8209248
00:18:45 112716 8192000000 10909904560 11387637760 1924967664 19.027 97 17 34 1 1949574080 19691904 4914512
00:20:47 124480 8192000000 10907949552 11376971776 1968200352 19.371 99 15 30 0 1986099792 13623808 4275632
00:23:25 81483 8192000000 10911222976 11380826112 1943065200 19.171 98 20 40 0 1964653376 16099248 5488928
00:24:56 39269 8192000000 10922848704 11383033856 1981818832 19.479 100 28 56 1 2007191648 16768928 8603888
00:25:45 68129 8192000000 10898825200 11385257984 1940293504 19.149 98 24 48 0 1965736032 17778032 7664496
00:27:52 46123 8192000000 10886524304 11354255360 1921478064 18.999 97 15 30 0 1935841696 10099424 4264208
00:28:46 58530 8192000000 10855929152 11332239360 1903227152 18.852 97 12 23 2 1913482848 6877664 3378032
00:30:01 22167 8192000000 10859218704 11339599872 1945920176 19.194 100 8 16 0 1957414544 9639504 1854864
00:30:35 50997 8192000000 10852964464 11327262720 1876898656 18.640 96 6 12 0 1890585024 12083872 1602496
00:31:32 49047 8192000000 10862047296 11343826944 1900283456 18.829 98 9 17 1 1918420176 15474272 2662448
00:32:29 50310 8192000000 10858552672 11325726720 1844133648 18.374 95 24 46 1 1858075088 7280832 6660608
00:33:30 54339 8192000000 10883983248 11347922944 1932873920 19.090 99 26 52 0 1949298416 8719152 7705344
00:34:31 28690 8192000000 10892794656 11352551424 1947573680 19.207 99 41 79 3 1969500688 10412352 11514656
00:35:06 49554 8192000000 10884335296 11353399296 1901318864 18.837 97 19 38 0 1920874912 14160992 5395056
00:36:09 67837 8192000000 10876135776 11350867968 1907837712 18.889 98 15 30 1 1930547712 17734448 4975552
00:37:24 47213 8192000000 10870481872 11328663552 1892988944 18.770 97 20 40 1 1907056880 8726336 5341600
00:38:21 40090 8192000000 10868616400 11315576832 1886832496 18.720 97 39 78 3 1907808064 9625296 11350272
00:39:12 91301 8192000000 10863019424 11328954368 1844307872 18.376 95 22 44 2 1859611216 9318288 5985056
00:40:54 53222 8192000000 10870131648 11332698112 1886335088 18.716 97 28 56 1 1908042576 13606192 8101296
00:41:53 80012 8192000000 10859272048 11333709824 1821135408 18.187 94 12 24 0 1838494096 13966432 3392256
00:43:20 78787 8192000000 10847365664 11323576320 1847641760 18.403 96 21 42 0 1880338848 26482704 6214384
00:44:45 26485 8192000000 10841159056 11282661376 1846582960 18.394 97 15 29 0 1862462624 12485184 3394480
00:45:22 44215 8192000000 10829925680 11288870912 1874905776 18.624 98 36 72 1 1897748064 11968048 10874240
00:46:13 96957 8192000000 10843961920 11294572544 1864899616 18.543 98 26 52 1 1880485072 8488688 7096768
00:47:59 35570 8192000000 10830554336 11292745728 1879468224 18.661 98 20 40 1 1891978768 6559408 5951136
00:48:42 37702 8192000000 10842749376 11299590144 1911100304 18.915 100 24 48 1 1925269808 7468672 6700832
00:49:28 23440 8192000000 10837172896 11305164800 1916818896 18.961 100 11 22 0 1927745696 8086752 2840048
00:50:01 12419 8192000000 10839873776 11314077696 1919603344 18.984 100 10 20 0 1932066912 9419152 3044416
00:50:19 30879 8192000000 10856377264 11328819200 1928672000 19.056 100 12 23 1 1941463456 9631456 3160000
00:51:02 65539 8192000000 10858256880 11329835008 1938285264 19.133 100 9 18 1 1949158864 8593424 2280176
00:52:22 46910 8192000000 10871493744 11340337152 1928548960 19.055 99 18 36 2 1945896080 12300032 5047088
00:53:22 82752 8192000000 10875784464 11342983168 1935934464 19.114 99 14 28 0 1951303024 11059488 4309072
00:54:53 72136 8192000000 10876851344 11356143616 1909944336 18.906 98 17 32 0 1929183568 15130400 4108832
00:56:19 67754 8192000000 10879003152 11349827584 1938535568 19.135 99 14 28 2 1955507536 13131760 3840208
00:57:39 65081 8192000000 10901253072 11360247808 1932175744 19.084 98 30 60 2 1950232752 10204192 7852816
00:58:56 74011 8192000000 10897485888 11378597888 1955825760 19.273 99 16 32 0 1975389888 15310496 4253632
01:00:17 54326 8192000000 10912507200 11397853184 1983554368 19.493 100 13 26 2 2008157872 21033760 3569744
01:01:24 44187 8192000000 10924529536 11385679872 1972470560 19.405 99 22 44 0 1986605776 8433152 5702064
01:02:20 16536 8192000000 10936384688 11389059072 1976900480 19.440 99 60 114 0 2003155488 10298064 15956944
01:02:45 47649 8192000000 10916332992 11387015168 1972665824 19.407 99 37 74 0 1998246496 15271456 10309216
01:03:43 28651 8192000000 10909095440 11372052480 1946105520 19.195 98 26 53 0 1965683856 12014416 7563920
01:04:18 70854 8192000000 10913980688 11380109312 1942724256 19.168 98 17 34 0 1960188976 12821344 4643376
01:05:38 86853 8192000000 10917956944 11375783936 1934058928 19.099 97 38 75 1 1958642704 14530208 10053568
01:07:33 54715 8192000000 10912521552 11396739072 1961028000 19.314 99 18 36 1 1980225712 14049664 5148048
01:08:42 41538 8192000000 10925936272 11374678016 1960579312 19.311 99 28 56 2 1977762240 9323200 7859728
01:09:34 97049 8192000000 10908804736 11387883520 1928681552 19.056 97 18 36 0 1946376928 12642800 5052576
01:12:08 115309 8192000000 10866768432 11328294912 1900738880 18.832 97 12 24 0 1912728816 8685984 3303952
01:14:09 67131 8192000000 10868950128 11351285760 1922040112 19.003 98 14 28 1 1937653184 11943376 3669696
01:15:23 57935 8192000000 10878511840 11359600640 1936299264 19.117 99 7 14 0 1950070688 11834816 1936608
01:16:27 29780 8192000000 10875551568 11352264704 1949306960 19.221 99 9 18 0 1962720960 10795232 2618768
01:17:05 35827 8192000000 10859925872 11343323136 1924625344 19.024 98 12 24 0 1939975680 11817792 3532544
01:17:47 54496 8192000000 10865157152 11334799360 1896036400 18.794 97 17 32 1 1908766224 8051248 4678576
01:18:53 104395 8192000000 10890588512 11366457344 1955373008 19.269 100 15 29 2 1972772768 13176512 4223248
01:20:44 71212 8192000000 10860931104 11342594048 1883709424 18.695 96 14 28 1 1901001456 13311600 3980432
01:22:03 57186 8192000000 10874559424 11335290880 1889725808 18.744 97 26 52 4 1906365376 9129520 7510048
01:23:28 51673 8192000000 10850532160 11322343424 1844164704 18.375 95 23 46 0 1861034384 10250992 6618688
01:24:47 11263 8192000000 10885769968 11331485696 1941713264 19.160 100 54 108 1 1966888080 8817168 16357648
01:25:07 38625 8192000000 10830906592 11306266624 1838894160 18.332 95 19 38 0 1856720880 12352496 5474224
01:26:05 73575 8192000000 10853604992 11329269760 1888775280 18.736 98 20 40 1 1905408496 10612816 6020400

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-04-2021 01:29:03 to 02-04-2021 01:29:05.

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          240425
MON$OLDEST_ACTIVE               241463
MON$OLDEST_SNAPSHOT             241463
MON$NEXT_TRANSACTION            241463
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                       2011776
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.33430 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33430 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33430 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33430 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 ---
:49: 
:50: mscs-test-161.budzdorov.ru    Fri Apr  2 01:27:28 2021
:51:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:52: 
:53: 
:54: mscs-test-161.budzdorov.ru    Fri Apr  2 01:27:28 2021
:55:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:56: 
:57: 
:58: mscs-test-161.budzdorov.ru    Fri Apr  2 01:27:29 2021
:59:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:60: 
--- end of diff output ---

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

02.04.21 01:29:06. 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-04-02 01:29:09 No severe PSQL-related problems occured
02.04.21 01:29:10. End of report.