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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 58e1ddde69c44dad93d327777e5becec
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-05-09 08:45
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4793.92
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17251480 kB
MemAvailable 31410364 kB
Buffers 0 kB
Cached 14441140 kB
SwapCached 2436 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-06-18 01:27:37
DTS_END                         2021-06-18 01:27:37.5010
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/40466
TRN_ID                          242182
ATT_ID                          634
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: 9359.19 20626 1123103
customer order: creation 174.08 366 20890
customer order: refuse 14.56 352 1747
order to supplier: creation 45.40 1282 5448
order to supplier: removal 3.55 108302 426
invoice (draft): creation 46.36 3404 5563
invoice (draft): removal 54.18 762 6502
invoice accept: apply 41.63 18410 4996
invoice accept: cancel 49.03 779 5883
customer reserve: creation 3853.20 183 462384
customer reserve: removal 4774.93 64 572992
realization accept: apply 85.05 171 10206
realization accept: cancel 87.48 118 10497
payment from customer: creation 58.97 126 7076
payment from customer: removal 5.93 99 711
payment to supplier: creation 49.28 115 5914
payment to supplier: removal 3.55 69 426
service: total inventory turnovers 4.70 1005 564
service: total monetary turnovers 6.55 25 786
service: aggregate perf. data 0.73 24092 88
service: refresh index statistics 0.03 252802 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 18-06-2021 01:29:06 to 18-06-2021 01:29:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4659
TEST_TIME 2 3645
TEST_TIME 3 3798
TEST_TIME 4 4014
TEST_TIME 5 4283
TEST_TIME 6 4562
TEST_TIME 7 5057
TEST_TIME 8 4879
TEST_TIME 9 4911
TEST_TIME 10 5044
TEST_TIME 11 5178
TEST_TIME 12 5047
TEST_TIME 13 5196
TEST_TIME 14 5457
TEST_TIME 15 5509
TEST_TIME 16 5835
TEST_TIME 17 6135
TEST_TIME 18 6541
TEST_TIME 19 7439
TEST_TIME 20 7702
TEST_TIME 21 7635
TEST_TIME 22 7903
TEST_TIME 23 8382
TEST_TIME 24 8807
TEST_TIME 25 9197
TEST_TIME 26 9726
TEST_TIME 27 9707
TEST_TIME 28 10415
TEST_TIME 29 10824
TEST_TIME 30 10696
TEST_TIME 31 10423
TEST_TIME 32 10170
TEST_TIME 33 10240
TEST_TIME 34 10270
TEST_TIME 35 10152
TEST_TIME 36 10044
TEST_TIME 37 9994
TEST_TIME 38 9871
TEST_TIME 39 9957
TEST_TIME 40 10090
TEST_TIME 41 9982
TEST_TIME 42 9884
TEST_TIME 43 9833
TEST_TIME 44 9655
TEST_TIME 45 9691
TEST_TIME 46 9711
TEST_TIME 47 9633
TEST_TIME 48 9610
TEST_TIME 49 9674
TEST_TIME 50 9523
TEST_TIME 51 9582
TEST_TIME 52 9574
TEST_TIME 53 9560
TEST_TIME 54 9580
TEST_TIME 55 9515
TEST_TIME 56 9682
TEST_TIME 57 9700
TEST_TIME 58 9745
TEST_TIME 59 9792
TEST_TIME 60 9769
TEST_TIME 61 9757
TEST_TIME 62 9896
TEST_TIME 63 9887
TEST_TIME 64 9900
TEST_TIME 65 9955
TEST_TIME 66 9946
TEST_TIME 67 9830
TEST_TIME 68 9777
TEST_TIME 69 9671
TEST_TIME 70 9718
TEST_TIME 71 9685
TEST_TIME 72 9609
TEST_TIME 73 9594
TEST_TIME 74 9532
TEST_TIME 75 9602
TEST_TIME 76 9576
TEST_TIME 77 9586
TEST_TIME 78 9550
TEST_TIME 79 9565
TEST_TIME 80 9672
TEST_TIME 81 9679
TEST_TIME 82 9661
TEST_TIME 83 9619
TEST_TIME 84 9598
TEST_TIME 85 9711
TEST_TIME 86 9693
TEST_TIME 87 9791
TEST_TIME 88 9767
TEST_TIME 89 9708
TEST_TIME 90 9638
TEST_TIME 91 9636
TEST_TIME 92 9610
TEST_TIME 93 9553
TEST_TIME 94 9575
TEST_TIME 95 9513
TEST_TIME 96 9515
TEST_TIME 97 9574
TEST_TIME 98 9566
TEST_TIME 99 9587
TEST_TIME 100 9578
TEST_TIME 101 9572
TEST_TIME 102 9563
TEST_TIME 103 9619
TEST_TIME 104 9652
TEST_TIME 105 9671
TEST_TIME 106 9657
TEST_TIME 107 9648
TEST_TIME 108 9626
TEST_TIME 109 9634
TEST_TIME 110 9562
TEST_TIME 111 9531
TEST_TIME 112 9504
TEST_TIME 113 9501
TEST_TIME 114 9503
TEST_TIME 115 9451
TEST_TIME 116 9427
TEST_TIME 117 9404
TEST_TIME 118 9433
TEST_TIME 119 9383
TEST_TIME 120 9360

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-06-2021 01:29:10 to 18-06-2021 01:29:13.

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 1551670 1551670 0 0.00 0 23448 6 0 0
doc_list_biud 1551668 1551668 0 0.00 0 73009 29 0 0
sp_add_invoice_to_stock 5167 4996 171 3.30 26 217590 18410 0 171
sp_cancel_adding_invoice 5883 5883 0 0.00 5 85435 780 0 0
sp_cancel_client_order 1747 1747 0 0.00 4 10906 352 0 0
sp_cancel_customer_reserve 572992 572992 0 0.00 1 23291 65 0 0
sp_cancel_pay_from_customer 711 711 0 0.00 2 8069 100 0 0
sp_cancel_pay_to_supplier 426 426 0 0.00 3 2776 69 0 0
sp_cancel_supplier_invoice 6512 6502 10 0.15 1 73018 762 0 10
sp_cancel_supplier_order 426 426 0 0.00 6 1183472 108302 0 0
sp_cancel_write_off 10497 10497 0 0.00 1 9453 118 0 0
sp_client_order 20890 20890 0 0.00 3 23606 366 0 0
sp_customer_reserve 462384 462384 0 0.00 0 132183 183 0 0
sp_fill_shopping_cart 31894 31894 0 0.00 1 17343 38 0 0
sp_fill_shopping_cart_clo_res 462380 462380 0 0.00 0 19044 14 0 0
sp_get_clo_for_invoice 4989 4989 0 0.00 0 32060 295 0 0
sp_kill_cost_storno 17517 17517 0 0.00 0 4649 54 0 0
sp_kill_qstorno_ret_qs2qd 1163409 1163409 0 0.00 0 73005 35 0 0
sp_kill_qty_storno 613240 613240 0 0.00 0 73007 74 0 0
sp_lock_selected_doc 21081 21081 0 0.00 0 7134 7 0 0
sp_make_cost_storno 28185 28185 0 0.00 0 16902 50 0 0
sp_multiply_rows_for_pdistr 28184 28184 0 0.00 0 21886 28 0 0
sp_multiply_rows_for_qdistr 20890 20890 0 0.00 0 23598 157 0 0
sp_pay_from_customer 7076 7076 0 0.00 4 21896 127 0 0
sp_pay_to_supplier 5914 5914 0 0.00 5 15487 115 0 0
sp_payment_common 12990 12990 0 0.00 1 6434 23 0 0
sp_qd_handle_on_cancel_clo 1747 1747 0 0.00 0 10899 305 0 0
sp_qd_handle_on_invoice_upd_sts 10871 10871 0 0.00 0 9648 320 0 0
sp_qd_handle_on_reserve_upd_sts 10205 10205 0 0.00 0 18673 54 0 0
sp_reserve_write_off 10206 10206 0 0.00 6 18683 171 0 0
sp_supplier_invoice 5563 5563 0 0.00 7 78596 3405 0 0
sp_supplier_order 5448 5448 0 0.00 5 30105 1283 0 0
srv_aggregate_perf_data 88 88 0 0.00 2463 466487 24093 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1741 176519 31080 0 0
srv_find_qd_qs_mism 1075395 1075395 0 0.00 0 23447 6 0 0
srv_make_invnt_saldo 564 564 0 0.00 41 38468 1006 0 0
srv_make_money_saldo 786 786 0 0.00 1 1844 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 163369 329337 252802 0 0
t$perf-abend:sp_add_invoice_to_stock 171 171 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4996 4996 0 0.00 0 13913 178 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 0 7530 103 0 0
t$perf-norm:sp_cancel_client_order 1747 1747 0 0.00 0 4387 16 0 0
t$perf-norm:sp_cancel_customer_reserve 694 694 0 0.00 0 8696 33 0 0
t$perf-norm:sp_cancel_pay_from_customer 711 711 0 0.00 0 1439 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 426 426 0 0.00 0 1008 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 418 418 0 0.00 0 1530 17 0 0
t$perf-norm:sp_cancel_supplier_order 426 426 0 0.00 0 27890 1722 0 0
t$perf-norm:sp_cancel_write_off 1055 1055 0 0.00 0 2571 9 0 0
t$perf-norm:sp_client_order 20891 20891 0 0.00 0 12676 19 0 0
t$perf-norm:sp_customer_reserve 991 991 0 0.00 0 8679 13 0 0
t$perf-norm:sp_pay_from_customer 7076 7076 0 0.00 0 7957 15 0 0
t$perf-norm:sp_pay_to_supplier 5914 5914 0 0.00 0 5449 11 0 0
t$perf-norm:sp_reserve_write_off 10206 10206 0 0.00 0 21333 17 0 0
t$perf-norm:sp_supplier_invoice 5563 5563 0 0.00 0 11742 22 0 0
t$perf-norm:sp_supplier_order 5448 5448 0 0.00 0 8465 16 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 199 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 3423 36 0 0
t$perf-norm:srv_make_invnt_saldo 564 564 0 0.00 0 7211 35 0 0
t$perf-norm:srv_make_money_saldo 786 786 0 0.00 0 4169 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10314 9972 342 3.31 0 8335 21 0 342
v_all_customers 37774 37774 0 0.00 0 24 1 0 0
v_all_suppliers 30962 30962 0 0.00 0 122 1 0 0
v_all_wares 41774 41774 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 2115 17 0 0
v_cancel_client_order 3494 3494 0 0.00 0 5679 12 0 0
v_cancel_customer_prepayment 1422 1422 0 0.00 0 3460 10 0 0
v_cancel_customer_reserve 1388 1388 0 0.00 0 4971 11 0 0
v_cancel_payment_to_supplier 852 852 0 0.00 0 2767 8 0 0
v_cancel_supplier_invoice 856 836 20 2.33 0 1241 20 0 20
v_cancel_supplier_order 852 852 0 0.00 0 3238 13 0 0
v_cancel_write_off 2110 2110 0 0.00 0 6308 16 0 0
v_max_id_clo_ord 5445 5445 0 0.00 0 12053 5 0 0
v_max_id_clo_res 991 991 0 0.00 0 3526 22 0 0
v_max_id_ord_sup 5559 5559 0 0.00 0 4262 5 0 0
v_max_non_paid_invoice 1437 1437 0 0.00 0 198 2 0 0
v_max_non_paid_realizn 3788 3788 0 0.00 0 3298 4 0 0
v_min_id_clo_ord 5445 5445 0 0.00 0 8906 6 0 0
v_min_id_clo_res 991 991 0 0.00 0 7889 25 0 0
v_min_id_ord_sup 5559 5559 0 0.00 0 6262 5 0 0
v_min_non_paid_invoice 5914 5914 0 0.00 0 4346 12 0 0
v_min_non_paid_realizn 7076 7076 0 0.00 0 4396 14 0 0
v_our_firm 10576 10576 0 0.00 0 10 1 0 0
v_reserve_write_off 20408 20408 0 0.00 0 8354 7 0 0
x_lock_depdocs_on_canc_invoice 11967 11967 0 0.00 0 9967 107 0 0
x_lock_depdocs_on_canc_sup_ord 426 426 0 0.00 0 20224 349 0 0
x_make_qstorno_1000_1200 5448 5448 0 0.00 2 24398 1199 0 0
x_make_qstorno_1200_2000 5563 5563 0 0.00 3 77843 3272 0 0
x_make_qstorno_2100_3300 462384 462384 0 0.00 0 132182 167 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-06-2021 01:29:14 to 18-06-2021 01:29:18.

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:41 1 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
22:57:47 23714 8192000000 10260735824 10572660736 934297280 10.237 72 50 100 0 953921088 2470656 17153152
22:58:21 34319 8192000000 10356643984 10673876992 1400112960 14.596 100 91 182 0 1435181200 5224608 29843632
22:59:08 26254 8192000000 10385186496 10706419712 1436021680 14.915 100 90 180 0 1472851616 6970528 29859408
22:59:45 31435 8192000000 10407274208 10737717248 1457533776 15.104 100 87 174 0 1493353536 7605152 28214608
23:00:31 22342 8192000000 10438033904 10767994880 1489651632 15.386 100 90 180 0 1527235392 8363152 29220608
23:01:04 16068 8192000000 10455760960 10791178240 1510151024 15.565 100 89 176 2 1547051008 8826160 28073824
23:01:35 16839 8192000000 10483102608 10827780096 1533948560 15.771 100 83 166 0 1569879376 9472192 26458624
23:01:59 14025 8192000000 10506564144 10850492416 1555470672 15.957 100 81 162 0 1590676688 9807808 25398208
23:02:22 18102 8192000000 10529734416 10882170880 1586791488 16.226 100 82 165 1 1622087008 10343616 24951904
23:02:49 18233 8192000000 10554602416 10912509952 1614098672 16.460 100 87 174 0 1652038240 11076720 26862848
23:03:22 9344 8192000000 10582765392 10944917504 1639953216 16.679 100 76 152 1 1673583632 11182144 22448272
23:03:39 12579 8192000000 10602860544 10967932928 1666721504 16.906 100 82 164 1 1703229648 12286304 24221840
23:03:59 10955 8192000000 10634318208 10997374976 1689049264 17.093 100 87 174 2 1727134752 13125696 24959792
23:04:18 8673 8192000000 10639332000 11004915712 1696809504 17.158 100 91 182 3 1737709200 14080032 26819664
23:04:37 10762 8192000000 10645434880 11018649600 1708782912 17.259 100 76 152 2 1744505632 13950144 21772576
23:04:57 8889 8192000000 10664483696 11035308032 1719255920 17.346 100 80 159 1 1755780960 13430048 23094992
23:05:14 6764 8192000000 10677852576 11053764608 1732635104 17.457 100 73 146 1 1766694880 13161168 20898608
23:05:28 6504 8192000000 10684248240 11064471552 1743285664 17.546 100 76 152 1 1777916800 13029456 21601680
23:05:43 4552 8192000000 10692196224 11070234624 1759417088 17.680 100 75 150 0 1793456832 12939504 21100240
23:05:54 4000 8192000000 10705266992 11084869632 1764037424 17.718 100 78 157 1 1799473216 13145136 22290656
23:06:05 4227 8192000000 10704230128 11087486976 1772978640 17.792 100 73 146 0 1805124496 11759760 20386096
23:06:17 3975 8192000000 10718912944 11099611136 1781849232 17.865 100 85 170 1 1818979248 12873792 24256224
23:06:28 11773 8192000000 10717969120 11103793152 1780442544 17.853 100 66 132 1 1810808160 11883904 18481712
23:06:47 3047 8192000000 10736998480 11122282496 1802284560 18.033 100 80 159 2 1836369824 12334368 21750896
23:06:56 3449 8192000000 10743147104 11134128128 1808047600 18.080 100 77 153 2 1842561232 12640976 21872656
23:07:07 4231 8192000000 10754875280 11142959104 1815108752 18.138 100 80 155 1 1850474224 12653648 22711824
23:07:19 3313 8192000000 10762549392 11150479360 1825335728 18.221 100 76 152 0 1859591440 12881584 21374128
23:07:29 3522 8192000000 10776097328 11163947008 1833745488 18.290 100 84 169 3 1870338896 12495440 24097968
23:07:39 2112 8192000000 10771704480 11163107328 1838076544 18.325 100 79 158 1 1873188672 13442320 21669808
23:07:48 1996 8192000000 10778714688 11170697216 1843063888 18.366 100 85 170 2 1879868304 13075408 23729008
23:07:56 2333 8192000000 10793515344 11184582656 1852899792 18.446 100 84 169 2 1889863648 13238928 23724928
23:08:05 2134 8192000000 10805823120 11190992896 1859893360 18.502 100 97 195 1 1900804320 13954176 26956784
23:08:14 2063 8192000000 10809260128 11197534208 1861758064 18.518 100 90 179 2 1901416288 13731056 25927168
23:08:22 2587 8192000000 10808329456 11199258624 1870490576 18.588 100 96 191 2 1911869760 14621584 26757600
23:08:31 2840 8192000000 10811237360 11206369280 1871035696 18.593 100 77 154 2 1906478976 12668224 22775056
23:08:41 1333 8192000000 10823667104 11211767808 1875450672 18.628 100 93 188 0 1915433200 13701808 26280720
23:08:48 9757 8192000000 10810048496 11211223040 1875063744 18.625 100 69 138 0 1908269184 14000224 19205216
23:09:05 1482 8192000000 10828468128 11222704128 1884433296 18.701 100 91 180 0 1923790736 13474448 25882992
23:09:13 23189 8192000000 10793360176 11211132928 1887121744 18.723 100 76 148 1 1920527568 12762768 20643056
23:09:48 5385 8192000000 10802397632 11217928192 1883100720 18.690 100 45 90 0 1905489616 9098784 13290112
23:09:59 1644 8192000000 10808978288 11219857408 1887807536 18.728 100 68 138 1 1915120784 7838032 19475216
23:10:08 3537 8192000000 10806846848 11225546752 1885345456 18.708 100 43 86 3 1906936512 9935008 11656048
23:10:17 6118 8192000000 10801605392 11224412160 1887184112 18.723 100 34 68 1 1905652848 8057472 10411264
23:10:31 6073 8192000000 10797987248 11230928896 1888196272 18.731 100 25 50 0 1901393104 6271184 6925648
23:10:43 4038 8192000000 10806980016 11232063488 1894080896 18.779 100 38 76 1 1912124416 7435328 10608192
23:10:56 11018 8192000000 10812951552 11234496512 1891614432 18.759 100 24 49 0 1905650144 7324000 6711712
23:11:15 8365 8192000000 10802048928 11233742848 1897628304 18.807 100 22 43 1 1910583536 7039312 5915920
23:11:29 12898 8192000000 10804763024 11235971072 1896431104 18.798 100 23 46 2 1910058688 6494864 7132720
23:11:49 5615 8192000000 10820081168 11250192384 1900745200 18.832 100 31 62 1 1921205344 11812576 8647568
23:12:02 9458 8192000000 10816016144 11247415296 1900850864 18.833 100 18 36 3 1911560576 5685856 5023856
23:12:18 12187 8192000000 10805745488 11243970560 1901665648 18.840 100 13 25 1 1911078192 5530896 3881648
23:12:39 11696 8192000000 10825720160 11242708992 1904962576 18.866 100 24 49 1 1916399248 5216656 6220016
23:12:57 12135 8192000000 10826943424 11255930880 1906510992 18.879 100 23 46 1 1923170784 9943024 6716768
23:13:17 61247 8192000000 10835236496 11259338752 1911392208 18.918 100 38 77 1 1932075920 9114720 11568992
23:14:25 2477 8192000000 10853706672 11274174464 1920624272 18.992 100 72 145 1 1952046288 10745168 20676848
23:14:39 8497 8192000000 10835216128 11263717376 1914877776 18.946 100 28 57 1 1929074688 6412144 7784768
23:14:54 6916 8192000000 10824587392 11266138112 1917671056 18.968 100 37 74 4 1935097200 7538688 9887456
23:15:07 7541 8192000000 10833025344 11269570560 1918075376 18.971 100 31 62 1 1933470352 6950016 8444960
23:15:21 6091 8192000000 10846847184 11271757824 1919474544 18.983 100 31 62 0 1936086336 7653632 8958160
23:15:34 5961 8192000000 10839201312 11275497472 1919219968 18.981 100 30 61 0 1937614336 9797872 8596496
23:15:50 6395 8192000000 10840377856 11275251712 1921984080 19.003 100 30 61 2 1936485792 5424016 9077696
23:16:06 6809 8192000000 10832154512 11271245824 1921483392 18.999 100 26 52 1 1934834272 5844768 7506112
23:16:19 8092 8192000000 10833504528 11273809920 1921252368 18.997 100 19 37 1 1931475072 5402480 4820224
23:16:38 15401 8192000000 10819548848 11262226432 1884013920 18.698 98 21 41 3 1896290656 6531040 5745696
23:17:00 10786 8192000000 10826593184 11270545408 1916173792 18.956 100 13 26 2 1925578976 5847440 3557744
23:17:17 10166 8192000000 10809674752 11248357376 1889928960 18.745 99 16 32 1 1900438848 5895488 4614400
23:17:34 8983 8192000000 10796625840 11227963392 1865247408 18.546 98 13 26 0 1874225312 5513104 3464800
23:17:52 68175 8192000000 10774907376 11212550144 1788536560 17.920 94 33 63 0 1803390096 5928288 8925248
23:19:09 3644 8192000000 10772622240 11195310080 1827393232 18.238 98 28 56 1 1841289424 5840720 8055472
23:19:22 3669 8192000000 10750683904 11173765120 1807563824 18.076 98 29 58 0 1826789904 10594176 8631904
23:19:31 5257 8192000000 10733174000 11148365824 1773016704 17.792 96 33 67 0 1789812784 6686688 10109392
23:19:43 6061 8192000000 10710371552 11133018112 1759308816 17.679 96 29 58 2 1773539856 6155968 8075072
23:19:57 5540 8192000000 10723546976 11139944448 1779410848 17.845 98 35 70 2 1795933712 6148800 10374064
23:20:09 5545 8192000000 10727456320 11154087936 1800535744 18.018 99 21 42 0 1812480880 5703696 6241440
23:20:26 7447 8192000000 10695804800 11105787904 1689132992 17.094 93 23 46 1 1701159584 5675728 6350864
23:20:40 7732 8192000000 10723363264 11140694016 1796966016 17.989 100 30 60 1 1811654240 5916864 8771360
23:20:57 5255 8192000000 10707823968 11125878784 1779702064 17.847 99 23 46 3 1793735152 6192656 7840432
23:21:09 9807 8192000000 10686499488 11103756288 1737433552 17.497 97 28 56 2 1755840400 9946048 8460800
23:21:28 6659 8192000000 10689883200 11104030720 1750887792 17.609 98 23 46 2 1763593296 6009664 6695840
23:21:46 8301 8192000000 10707766544 11112374272 1719852736 17.351 96 27 54 0 1732969008 5108976 8007296
23:22:00 6599 8192000000 10699740096 11114565632 1767606432 17.747 99 28 56 2 1781996944 5804352 8586160
23:22:13 6763 8192000000 10693968048 11111485440 1753391824 17.630 98 22 44 1 1765368160 5294912 6681424
23:22:26 70827 8192000000 10728248224 11154968576 1815348800 18.140 100 42 84 0 1834385952 5975472 13061680
23:23:43 10022 8192000000 10741518480 11164213248 1824873344 18.217 100 19 37 0 1835568896 5344480 5351072
23:24:04 8063 8192000000 10743968336 11169738752 1830046656 18.260 100 27 54 0 1844516608 6442896 8027056
23:24:20 8496 8192000000 10760289152 11179532288 1841190096 18.350 100 22 44 2 1853639072 4992288 7456688
23:24:37 6242 8192000000 10755955920 11185266688 1846727088 18.396 100 30 59 2 1861743424 6847760 8168576
23:24:54 5543 8192000000 10762422720 11190628352 1848938272 18.413 100 22 42 5 1861275888 6049792 6287824
23:25:05 7018 8192000000 10762071824 11193679872 1854830384 18.461 100 23 46 1 1868712064 5697088 8184592
23:25:19 13208 8192000000 10773658816 11202580480 1857527120 18.483 100 27 53 0 1874484176 9741264 7215792
23:25:38 9201 8192000000 10783560128 11203559424 1858421296 18.490 100 16 32 2 1868524768 5365056 4738416
23:25:54 10751 8192000000 10770664896 11207614464 1863293312 18.530 100 17 34 2 1881949376 14544576 4111488
23:26:11 9187 8192000000 10778586832 11210022912 1865755568 18.550 100 17 34 2 1877040480 5806880 5478032
23:26:28 11875 8192000000 10780788784 11212570624 1868242368 18.570 100 10 20 1 1876569632 5201984 3125280
23:26:49 17917 8192000000 10799572176 11227262976 1875279792 18.627 100 16 32 0 1885756192 5576416 4899984
23:27:14 16040 8192000000 10812118064 11235590144 1894445200 18.782 100 13 26 1 1902341008 4500672 3395136
23:27:40 67974 8192000000 10842201584 11262296064 1910704496 18.912 100 48 92 1 1930563792 6059920 13799376
23:29:03 28847 8192000000 10842244656 11271032832 1917628944 18.968 100 37 72 2 1934014576 6713808 9671824
23:29:45 14837 8192000000 10856413408 11280977920 1924253440 19.021 100 45 90 1 1944904800 8099968 12551392
23:30:09 20295 8192000000 10869356000 11293929472 1931676400 19.080 100 50 100 1 1956792560 11077088 14039072
23:30:37 14838 8192000000 10874271952 11306971136 1941142576 19.156 100 54 106 3 1970166544 14198608 14825360
23:30:59 13226 8192000000 10880204832 11312390144 1948122416 19.212 100 51 101 3 1978257824 14962240 15173168
23:31:22 7771 8192000000 10888543088 11318038528 1951825680 19.241 100 41 82 2 1980875104 17082384 11967040
23:31:43 25018 8192000000 10872217536 11306868736 1938098944 19.132 99 37 74 1 1967282944 18058064 11125936
23:32:17 14892 8192000000 10904741792 11335680000 1960142592 19.307 100 46 92 1 1994145472 19716464 14286416
23:32:44 18677 8192000000 10909066352 11340718080 1963410048 19.333 100 49 96 1 1997820448 20374080 14036320
23:33:17 15457 8192000000 10916036448 11348627456 1971863136 19.400 100 50 100 2 2008623920 22208048 14552736
23:33:54 12773 8192000000 10926720960 11354537984 1979001840 19.457 100 47 92 1 2014397904 21207200 14188864
23:34:18 12340 8192000000 10926842256 11363651584 1983186208 19.490 100 53 106 0 2020395792 20616560 16593024
23:34:38 5595 8192000000 10927908992 11366637568 1985163040 19.506 100 41 82 3 2017037808 20168592 11706176
23:34:50 4509 8192000000 10953340848 11380707328 1996033840 19.591 100 63 126 2 2034824832 20866240 17924752
23:35:08 18215 8192000000 10945733216 11381792768 1999213360 19.617 100 51 102 1 2035334432 21478256 14642816
23:35:38 5572 8192000000 10959506720 11388928000 2004333344 19.657 100 60 119 0 2044917424 23880880 16703200
23:35:50 10992 8192000000 10970603072 11403345920 2015238656 19.743 100 63 125 0 2058190336 24967296 17984384
23:36:09 8225 8192000000 10971502192 11400470528 1997974016 19.607 99 66 130 2 2043565280 26565120 19026144
23:36:23 6924 8192000000 10977501312 11403481088 2014332448 19.736 100 65 130 0 2060102656 27009200 18761008
23:36:38 7058 8192000000 10975005552 11406467072 2017152208 19.758 100 61 122 2 2062837632 27708256 17977168
23:36:54 6322 8192000000 10968683088 11407540224 2018697296 19.770 100 61 120 0 2064111440 27643264 17770880
23:37:07 5253 8192000000 10984969088 11409846272 2017272224 19.759 100 62 124 0 2063961712 28123328 18566160
23:37:21 9157 8192000000 10970574272 11405987840 2002872960 19.645 99 68 136 0 2051932592 28495808 20563824
23:37:40 11032 8192000000 10965482080 11396669440 2004271120 19.656 100 61 120 1 2050019280 27451360 18296800
23:38:10 9695 8192000000 10970045808 11403083776 2012736752 19.723 100 61 122 2 2060779488 29499024 18543712
23:38:31 10392 8192000000 10970299712 11405852672 2015509024 19.745 100 55 108 4 2060198512 27748656 16940832
23:38:48 8987 8192000000 10974019792 11413106688 2017266640 19.759 100 54 107 1 2067231824 32367440 17597744
23:39:05 10412 8192000000 10961187664 11405041664 2012624656 19.722 100 41 82 0 2053206096 27127936 13453504
23:39:31 8531 8192000000 10978726176 11416596480 2020411440 19.783 100 51 102 2 2064824784 28999728 15413616
23:39:53 7038 8192000000 10983223552 11419324416 2020859200 19.787 100 57 114 0 2072315328 33088240 18367888
23:40:09 2953 8192000000 11009235856 11434823680 2032104656 19.875 100 72 145 2 2089402528 34654384 22643488
23:40:20 7186 8192000000 11007189872 11437428736 2014550880 19.737 99 71 140 1 2070504112 35077360 20875872
23:40:35 3415 8192000000 11002177776 11424940032 2013674112 19.730 99 81 160 0 2073464320 35387840 24402368
23:40:49 6448 8192000000 10989516464 11415556096 1993027568 19.568 98 72 141 0 2050952736 35634880 22290288
23:41:03 5527 8192000000 10982261168 11414970368 2010068480 19.702 100 61 121 1 2062869552 34978704 17822368
23:41:15 5967 8192000000 10991989360 11426426880 2021797360 19.794 100 62 124 1 2078401312 37257424 19346528
23:41:31 4314 8192000000 10988101792 11423813632 2020523168 19.784 100 62 123 1 2075695456 36555680 18616608
23:41:44 2560 8192000000 11013145424 11433418752 2026985936 19.835 100 90 180 0 2092645472 38326976 27332560
23:41:53 4855 8192000000 11009097392 11431747584 2014983200 19.741 99 91 180 2 2083738688 40352176 28403312
23:42:05 5764 8192000000 10981977952 11403583488 1987077024 19.521 99 78 156 1 2052640928 41600192 23963712
23:42:17 2433 8192000000 10984682048 11404988416 1997899744 19.606 100 84 167 0 2066846032 43735520 25210768
23:42:29 3135 8192000000 10975742432 11391606784 1983867712 19.495 99 80 159 0 2053990320 44680768 25441840
23:42:42 3350 8192000000 10979854944 11404480512 1998958592 19.615 100 73 147 0 2067288896 44961328 23368976
23:42:58 5324 8192000000 10956117264 11375333376 1967266000 19.364 99 75 148 2 2042241072 51683104 23291968
23:43:11 2534 8192000000 10971308400 11389952000 1973582192 19.414 99 81 160 0 2050186192 51313728 25290272
23:43:21 3950 8192000000 10978409168 11393732608 1968501968 19.374 99 79 157 1 2044713120 51330064 24881088
23:43:34 2807 8192000000 10980572384 11394732032 1971970080 19.401 99 79 157 1 2049755328 53475536 24309712
23:43:44 9123 8192000000 10986416352 11411247104 1991398752 19.555 100 76 152 3 2069146704 53416432 24331520
23:44:00 4791 8192000000 10980514608 11389714432 1966058752 19.354 98 90 177 2 2047576320 52649392 28868176
23:44:14 3713 8192000000 10956043248 11372167168 1948788560 19.217 98 77 154 1 2026207664 53297472 24121632
23:44:25 4541 8192000000 10942185344 11359903744 1929445184 19.062 97 80 161 0 2009876848 54066592 26365072
23:44:36 2093 8192000000 10970245952 11382349824 1969440512 19.381 100 77 152 0 2048261552 54470128 24350912
23:44:46 3340 8192000000 10957713904 11375079424 1950538640 19.231 99 77 154 0 2031982176 55661712 25781824
23:44:56 3287 8192000000 10951407728 11364319232 1960171648 19.307 100 73 140 2 2034348128 51817744 22358736
23:45:08 2926 8192000000 10975717584 11389681664 1974201504 19.419 100 79 157 0 2054792592 55150672 25440416
23:45:18 2447 8192000000 10990386992 11402924032 1985712064 19.510 100 84 168 1 2069248432 55816144 27720224
23:45:28 1740 8192000000 10991712160 11407962112 1990641888 19.549 100 88 177 0 2074597472 56005792 27949792
23:45:40 2919 8192000000 10978614144 11395989504 1969950032 19.385 99 77 153 0 2044581984 50049520 24582432
23:45:51 7303 8192000000 10977434528 11396685824 1966701728 19.359 99 84 167 0 2048208688 54474736 27032224
23:46:08 2072 8192000000 10975501536 11401265152 1988847424 19.535 100 77 153 0 2062909120 49456448 24605248
23:46:21 11752 8192000000 10943109152 11391172608 1946076128 19.195 98 48 96 3 2017775408 55048912 16650368
23:46:48 6346 8192000000 10951357152 11381391360 1959423872 19.301 99 72 144 2 2029888368 47077888 23386608
23:47:06 5057 8192000000 10955603568 11378393088 1955284832 19.269 99 63 125 0 2022413360 47318880 19809648
23:47:17 6268 8192000000 10935044080 11366621184 1947175808 19.204 99 56 112 1 2007779024 42950256 17652960
23:47:30 14619 8192000000 10922199472 11361890304 1940842960 19.153 99 39 78 0 1997480096 43801808 12835328
23:47:56 7644 8192000000 10949153776 11374186496 1965738016 19.352 100 56 112 0 2030105088 46512880 17854192
23:48:11 4079 8192000000 10958014928 11384389632 1969206080 19.379 100 62 124 2 2038836336 49521792 20108464
23:48:28 7132 8192000000 10968069536 11394891776 1979282448 19.459 100 55 109 0 2046780128 49597168 17900512
23:48:41 3963 8192000000 10984651120 11412041728 1994897552 19.582 100 59 117 1 2063537632 49721280 18918800
23:48:55 10354 8192000000 10993385152 11429662720 1998346912 19.610 100 58 114 0 2075850832 58357872 19146048
23:49:15 4404 8192000000 10971537968 11416821760 1978474752 19.453 99 46 92 0 2044809424 50534256 15800416
23:49:30 10897 8192000000 10971200032 11412877312 1989876688 19.543 100 44 88 0 2057245168 51556608 15811872
23:50:10 14348 8192000000 10963103888 11418882048 1990202016 19.545 100 41 82 2 2053990784 49892544 13896224
23:50:36 20387 8192000000 10960428848 11418202112 1987640992 19.525 100 40 80 0 2047984160 46642464 13700704
23:51:11 11794 8192000000 10963910688 11422183424 1984060640 19.497 100 37 75 1 2048142576 51602576 12479360
23:51:44 31876 8192000000 10938532496 11396673536 1967483072 19.365 99 26 52 1 2023297120 47043152 8770896
23:52:23 9200 8192000000 10947442400 11415773184 1971124880 19.394 100 23 46 1 2033995136 54112912 8757344
23:52:45 14211 8192000000 10922143952 11396968448 1939176256 19.140 99 18 36 1 2001281216 55230240 6874720
23:53:28 36460 8192000000 10899281248 11379060736 1936383760 19.118 99 17 34 1 1989362384 46552784 6425840
23:54:10 18675 8192000000 10896686896 11371675648 1923743616 19.017 99 14 28 1 1969512112 40744064 5024432
23:54:37 6994 8192000000 10878155872 11333996544 1895622640 18.791 98 15 29 3 1941859808 40501616 5735552
23:54:52 7401 8192000000 10907617936 11359301632 1927205760 19.045 100 26 52 0 1980605728 43810800 9589168
23:55:09 29014 8192000000 10872714096 11347189760 1910223264 18.908 99 12 25 1 1943153632 29138208 3792160
23:55:44 39436 8192000000 10854639408 11307266048 1868403312 18.571 97 10 20 1 1888294704 16872672 3018720
23:57:05 105391 8192000000 10845207136 11283984384 1831512032 18.272 95 28 54 2 1850593552 10955136 8126384
23:58:59 75334 8192000000 10861473232 11307819008 1868107136 18.569 97 40 80 0 1889605568 9303824 12194608
00:00:21 46458 8192000000 10863483744 11314987008 1896108144 18.795 98 38 77 0 1920303328 13248608 10946576
00:01:15 10367 8192000000 10873117264 11320778752 1936879600 19.122 100 47 92 1 1963112208 12969136 13263472
00:01:32 16660 8192000000 10897636656 11331960832 1944803232 19.185 100 51 97 3 1965634624 6536560 14294832
00:01:55 176519 8192000000 10879781248 11346468864 1876764448 18.639 96 25 50 0 1890825856 7566272 6495136
00:04:58 15028 8192000000 10877523504 11308425216 1918018976 18.971 98 52 103 1 1941943040 8646400 15277664
00:05:20 32552 8192000000 10867637440 11316842496 1900512576 18.830 98 45 90 1 1924598656 10551568 13534512
00:06:03 19473 8192000000 10867571952 11319066624 1929907104 19.066 100 40 80 4 1956096416 14571088 11618224
00:06:31 5695 8192000000 10888522528 11310333952 1933621488 19.096 100 75 148 1 1966631280 10665984 22343808
00:06:46 39579 8192000000 10846956320 11315286016 1916506672 18.959 99 37 74 0 1941274976 14436736 10331568
00:07:56 46334 8192000000 10855519392 11324264448 1941420128 19.158 100 12 24 0 1951495312 7104544 2970640
00:10:05 55001 8192000000 10888512464 11362643968 1962297280 19.324 100 16 32 1 1982807584 15780064 4730240
00:11:06 46581 8192000000 10901770992 11363868672 1967263040 19.364 100 15 30 2 1984751248 12593440 4894768
00:12:23 38197 8192000000 10906745664 11371802624 1972116064 19.402 100 22 44 1 1992103312 13475664 6511584
00:13:24 36657 8192000000 10894493504 11364954112 1970610800 19.390 100 15 30 0 1983163936 8550544 4002592
00:14:11 20049 8192000000 10908473376 11375816704 1981964816 19.480 100 44 87 1 2007646304 13862704 11818784
00:14:39 52289 8192000000 10911425008 11385520128 1985946480 19.512 100 24 48 1 2009772304 16651616 7174208
00:15:42 69434 8192000000 10881382400 11369689088 1964193744 19.339 99 13 27 1 1982275584 13901456 4180384
00:17:12 57669 8192000000 10910062960 11385401344 1985927744 19.512 100 33 66 0 2002929536 7775968 9225824
00:18:26 67735 8192000000 10899931408 11385049088 1966866192 19.361 99 4 8 1 1977232080 9393424 972464
00:19:40 35034 8192000000 10934083872 11383529472 1969324640 19.380 99 21 42 0 1982568656 7132720 6111296
00:20:25 49134 8192000000 10886840864 11365126144 1920882528 18.994 97 20 40 0 1935097392 8941200 5273664
00:21:22 28687 8192000000 10907737296 11376873472 1969612080 19.382 100 16 32 1 1980953744 7044928 4296736
00:21:57 28852 8192000000 10903204560 11371622400 1945784784 19.193 98 17 35 0 1962836064 12224176 4827104
00:23:04 69041 8192000000 10888416032 11375546368 1897706528 18.808 96 15 30 2 1916397952 14558688 4132736
00:24:19 33101 8192000000 10901360736 11369328640 1953507344 19.254 99 19 38 0 1967458336 8685504 5265488
00:25:01 32388 8192000000 10902810016 11375370240 1953441776 19.254 99 26 52 4 1972048496 11316752 7289968
00:25:40 40346 8192000000 10905534608 11381227520 1974125632 19.418 100 20 40 0 1994589536 14031056 6432848
00:26:31 21954 8192000000 10910560912 11377557504 1980998032 19.473 100 30 60 0 1999433440 9154368 9281040
00:27:04 41733 8192000000 10926604448 11376705536 1939770272 19.145 98 33 66 1 1961818896 13684784 8363840
00:27:54 11219 8192000000 10920269664 11371724800 1961834704 19.321 99 55 110 2 1991308544 13539296 15934544
00:28:12 41581 8192000000 10915081424 11381161984 1957164928 19.283 99 33 66 1 1988229840 22243728 8821184
00:29:00 102459 8192000000 10891775056 11367366656 1892153088 18.763 96 11 22 0 1909400512 14418912 2828512
00:30:49 46987 8192000000 10894317328 11346702336 1872308688 18.603 95 23 45 1 1887846176 9707456 5830032
00:31:48 48626 8192000000 10864812528 11322851328 1835245184 18.302 94 28 56 1 1856977200 14421632 7310384
00:32:47 64739 8192000000 10859318976 11318611968 1853249456 18.449 96 19 38 3 1872873296 13268560 6355280
00:34:22 81993 8192000000 10857691680 11313205248 1879241792 18.659 97 39 78 0 1898287600 7491792 11554016
00:35:51 74648 8192000000 10841295248 11280265216 1827032352 18.235 94 35 70 0 1854303152 16979616 10291184
00:37:18 76733 8192000000 10832278688 11317678080 1901259104 18.836 99 10 20 1 1917481152 12919360 3302688
00:38:51 44099 8192000000 10825624304 11303825408 1889882192 18.745 98 6 12 0 1901380352 9826048 1672112
00:39:42 73472 8192000000 10837771632 11315601408 1877322224 18.643 97 10 20 0 1891664336 11282608 3059504
00:41:15 49155 8192000000 10850275920 11331809280 1921534176 18.999 100 6 12 0 1936972304 13876752 1561376
00:42:12 66218 8192000000 10858408304 11329323008 1894659952 18.783 98 13 27 0 1908300928 10285568 3355408
00:43:24 39649 8192000000 10871816064 11323396096 1865584832 18.549 96 28 54 1 1881630624 7995280 8050512
00:44:16 50442 8192000000 10857934768 11323772928 1882022928 18.681 97 24 47 0 1897007728 8245808 6738992
00:45:12 40354 8192000000 10869071952 11330162688 1902660848 18.848 98 27 54 0 1922723472 11499584 8563040
00:45:59 28397 8192000000 10880829568 11342987264 1930551712 19.071 99 29 58 1 1952879344 14176064 8151568
00:46:47 95382 8192000000 10847525872 11323158528 1866258912 18.554 96 25 50 2 1888852592 15077808 7515872
00:48:32 69987 8192000000 10871750496 11331059712 1883156848 18.691 97 23 46 1 1897982832 8308624 6517360
00:49:49 59088 8192000000 10889480272 11354308608 1926593008 19.040 99 19 38 0 1939967872 8068544 5306320
00:50:54 23263 8192000000 10897333104 11354890240 1938115392 19.132 99 41 82 1 1963237392 13392480 11729520
00:51:28 49295 8192000000 10889632384 11350110208 1921304496 18.997 98 36 72 1 1946487760 15188000 9995264
00:52:29 30358 8192000000 10865847888 11347939328 1935775648 19.113 100 25 49 2 1965878416 22874208 7228560
00:53:05 47460 8192000000 10896421424 11354681344 1930204256 19.069 99 28 56 2 1950359904 12688512 7467136
00:54:04 101796 8192000000 10883356768 11354382336 1919060576 18.979 98 15 30 0 1936239248 13291136 3887536
00:55:52 138231 8192000000 10864442288 11335053312 1908464816 18.894 97 29 57 3 1929143056 12085840 8592400
00:58:18 83983 8192000000 10903161248 11383537664 1964949712 19.345 100 20 40 2 1996325696 25834672 5541312
00:59:48 42744 8192000000 10912639040 11384463360 1978129184 19.450 100 16 32 1 2005629760 22956768 4543808
01:00:43 59795 8192000000 10910128032 11398873088 1980767712 19.471 100 11 22 1 2002438336 19038800 2631824
01:01:56 21172 8192000000 10895045552 11386462208 1972879744 19.408 100 6 12 0 1991511872 16849376 1782752
01:02:24 18153 8192000000 10903970224 11391172608 1978839680 19.456 100 13 26 0 1998191392 15739680 3612032
01:02:52 25247 8192000000 10916819472 11390377984 1984591280 19.501 100 11 22 1 2009851024 22078336 3181408
01:03:26 68449 8192000000 10909838656 11401170944 1946274528 19.197 98 14 28 1 1969479568 19153392 4051648
01:04:58 119390 8192000000 10896082944 11381846016 1922237920 19.005 97 11 22 1 1939059552 13858416 2963216
01:07:05 53211 8192000000 10913209296 11377332224 1944010528 19.179 98 19 38 0 1958813184 9375504 5427152
01:08:56 43672 8192000000 10908700096 11382624256 1984588672 19.501 100 23 46 2 2002754064 10797824 7367568
01:09:48 41189 8192000000 10923815616 11396435968 1987903856 19.527 100 26 52 0 2005968352 9829248 8235248
01:10:45 78351 8192000000 10917361280 11415240704 1952056496 19.243 98 11 22 1 1970453456 15111584 3285376
01:12:31 52386 8192000000 10920006384 11384422400 1958653056 19.295 99 7 14 0 1971325648 11009024 1663568
01:13:45 37824 8192000000 10909227424 11378053120 1978272080 19.451 100 21 42 1 1994223424 10270800 5680544
01:14:32 21983 8192000000 10910126032 11370115072 1939014320 19.139 98 42 84 0 1959363744 9120640 11228784
01:15:05 53050 8192000000 10912501040 11373719552 1941507168 19.159 98 32 64 3 1962659888 12200528 8952192
01:16:05 37043 8192000000 10907229072 11377020928 1977049088 19.441 100 31 62 1 1997218768 11193440 8976240
01:16:48 79580 8192000000 10903001696 11370622976 1940682416 19.152 98 12 24 0 1951127664 7134352 3310896
01:18:21 89047 8192000000 10868669824 11339546624 1821517056 18.190 92 23 46 1 1838470752 10760960 6192736
01:20:25 17980 8192000000 10870449920 11345895424 1924752800 19.025 99 19 38 0 1943947264 13980080 5214384
01:20:53 31979 8192000000 10850129008 11320569856 1908277088 18.893 98 11 22 1 1923414928 12039040 3098800
01:21:53 68577 8192000000 10853836784 11329495040 1901506528 18.838 98 13 26 1 1917092784 12059584 3526672
01:23:23 44712 8192000000 10846473184 11317612544 1885094112 18.706 97 19 38 2 1898291296 7673120 5524064
01:24:14 75942 8192000000 10858412160 11335602176 1899893504 18.825 98 13 26 2 1912238944 7884368 4461072
01:25:46 78674 8192000000 10838395248 11312762880 1861495216 18.515 96 12 24 0 1882346704 17743712 3107776
01:27:17 31965 8192000000 9076355344 9300672512 246712528 2.923 13 4 7 0 253117360 5347360 1057472

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 18-06-2021 01:29:20 to 18-06-2021 01:29:52.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-06-2021 01:29:53 to 18-06-2021 01:29:55.

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          242477
MON$OLDEST_ACTIVE               242478
MON$OLDEST_SNAPSHOT             242478
MON$NEXT_TRANSACTION            242478
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                       2027872
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.33474 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33474 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33474 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33474 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'

18.06.21 01:29:56. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-06-18 01:29:58 No severe PSQL-related problems occured
18.06.21 01:30:00. End of report.