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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17184128 kB
MemAvailable 31263180 kB
Buffers 0 kB
Cached 14493304 kB
SwapCached 4868 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-01-27 01:27:15
DTS_END                         2021-01-27 01:27:15.8670
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44762
TRN_ID                          240286
ATT_ID                          691
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: 9182.24 21291 1101869
customer order: creation 168.64 365 20237
customer order: refuse 14.53 345 1743
order to supplier: creation 44.75 1324 5370
order to supplier: removal 3.58 100521 430
invoice (draft): creation 44.03 3386 5283
invoice (draft): removal 52.12 783 6254
invoice accept: apply 40.83 18600 4899
invoice accept: cancel 47.61 781 5713
customer reserve: creation 3816.41 182 457969
customer reserve: removal 4654.80 61 558576
realization accept: apply 81.89 188 9827
realization accept: cancel 85.28 114 10234
payment from customer: creation 58.67 119 7040
payment from customer: removal 5.75 65 690
payment to supplier: creation 47.97 128 5756
payment to supplier: removal 3.33 58 400
service: total inventory turnovers 4.47 1230 536
service: total monetary turnovers 6.65 36 798
service: aggregate perf. data 0.92 15350 110
service: refresh index statistics 0.03 282174 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-01-2021 01:28:33 to 27-01-2021 01:28:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4084
TEST_TIME 2 4694
TEST_TIME 3 4042
TEST_TIME 4 4124
TEST_TIME 5 4375
TEST_TIME 6 5284
TEST_TIME 7 6032
TEST_TIME 8 5822
TEST_TIME 9 6012
TEST_TIME 10 6096
TEST_TIME 11 5916
TEST_TIME 12 5994
TEST_TIME 13 5961
TEST_TIME 14 6047
TEST_TIME 15 6109
TEST_TIME 16 6345
TEST_TIME 17 6911
TEST_TIME 18 6746
TEST_TIME 19 6763
TEST_TIME 20 7287
TEST_TIME 21 7768
TEST_TIME 22 8151
TEST_TIME 23 8326
TEST_TIME 24 8295
TEST_TIME 25 8518
TEST_TIME 26 9241
TEST_TIME 27 9816
TEST_TIME 28 10562
TEST_TIME 29 10322
TEST_TIME 30 10319
TEST_TIME 31 10018
TEST_TIME 32 10046
TEST_TIME 33 9981
TEST_TIME 34 9883
TEST_TIME 35 9892
TEST_TIME 36 9751
TEST_TIME 37 9681
TEST_TIME 38 9640
TEST_TIME 39 9685
TEST_TIME 40 9792
TEST_TIME 41 9756
TEST_TIME 42 9659
TEST_TIME 43 9525
TEST_TIME 44 9499
TEST_TIME 45 9488
TEST_TIME 46 9421
TEST_TIME 47 9406
TEST_TIME 48 9299
TEST_TIME 49 9335
TEST_TIME 50 9347
TEST_TIME 51 9347
TEST_TIME 52 9339
TEST_TIME 53 9283
TEST_TIME 54 9248
TEST_TIME 55 9675
TEST_TIME 56 9658
TEST_TIME 57 9617
TEST_TIME 58 9609
TEST_TIME 59 9731
TEST_TIME 60 9796
TEST_TIME 61 9861
TEST_TIME 62 9865
TEST_TIME 63 9731
TEST_TIME 64 9643
TEST_TIME 65 9594
TEST_TIME 66 9638
TEST_TIME 67 9531
TEST_TIME 68 9416
TEST_TIME 69 9453
TEST_TIME 70 9442
TEST_TIME 71 9458
TEST_TIME 72 9451
TEST_TIME 73 9428
TEST_TIME 74 9405
TEST_TIME 75 9364
TEST_TIME 76 9445
TEST_TIME 77 9413
TEST_TIME 78 9459
TEST_TIME 79 9459
TEST_TIME 80 9493
TEST_TIME 81 9507
TEST_TIME 82 9452
TEST_TIME 83 9562
TEST_TIME 84 9622
TEST_TIME 85 9653
TEST_TIME 86 9610
TEST_TIME 87 9526
TEST_TIME 88 9510
TEST_TIME 89 9447
TEST_TIME 90 9483
TEST_TIME 91 9437
TEST_TIME 92 9376
TEST_TIME 93 9364
TEST_TIME 94 9369
TEST_TIME 95 9340
TEST_TIME 96 9371
TEST_TIME 97 9440
TEST_TIME 98 9401
TEST_TIME 99 9394
TEST_TIME 100 9453
TEST_TIME 101 9424
TEST_TIME 102 9459
TEST_TIME 103 9521
TEST_TIME 104 9478
TEST_TIME 105 9536
TEST_TIME 106 9522
TEST_TIME 107 9532
TEST_TIME 108 9495
TEST_TIME 109 9433
TEST_TIME 110 9403
TEST_TIME 111 9377
TEST_TIME 112 9358
TEST_TIME 113 9303
TEST_TIME 114 9303
TEST_TIME 115 9255
TEST_TIME 116 9224
TEST_TIME 117 9195
TEST_TIME 118 9226
TEST_TIME 119 9240
TEST_TIME 120 9185

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 27-01-2021 01:28:36 to 27-01-2021 01:28:40.

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 1526898 1526898 0 0.00 0 21773 6 0 0
doc_list_biud 1526895 1526895 0 0.00 0 27919 28 0 0
sp_add_invoice_to_stock 5036 4899 137 2.72 28 158725 18601 0 137
sp_cancel_adding_invoice 5713 5713 0 0.00 3 66461 782 0 0
sp_cancel_client_order 1743 1743 0 0.00 5 11457 345 0 0
sp_cancel_customer_reserve 558576 558576 0 0.00 1 27921 62 0 0
sp_cancel_pay_from_customer 690 690 0 0.00 2 1892 66 0 0
sp_cancel_pay_to_supplier 400 400 0 0.00 3 930 59 0 0
sp_cancel_supplier_invoice 6267 6254 13 0.20 1 16840 784 0 13
sp_cancel_supplier_order 430 430 0 0.00 6 1038458 100522 0 0
sp_cancel_write_off 10234 10234 0 0.00 1 8770 114 0 0
sp_client_order 20237 20237 0 0.00 4 51886 365 0 0
sp_customer_reserve 457969 457969 0 0.00 0 74564 182 0 0
sp_fill_shopping_cart 30866 30866 0 0.00 1 12082 36 0 0
sp_fill_shopping_cart_clo_res 457965 457965 0 0.00 0 18255 13 0 0
sp_get_clo_for_invoice 4893 4893 0 0.00 0 23636 289 0 0
sp_kill_cost_storno 17037 17037 0 0.00 0 7618 58 0 0
sp_kill_qstorno_ret_qs2qd 1134070 1134070 0 0.00 0 27918 33 0 0
sp_kill_qty_storno 597670 597670 0 0.00 0 27919 71 0 0
sp_lock_selected_doc 20460 20460 0 0.00 0 9957 6 0 0
sp_make_cost_storno 27516 27516 0 0.00 0 10138 53 0 0
sp_multiply_rows_for_pdistr 27516 27516 0 0.00 0 11711 33 0 0
sp_multiply_rows_for_qdistr 20236 20236 0 0.00 0 51866 159 0 0
sp_pay_from_customer 7040 7040 0 0.00 4 11727 119 0 0
sp_pay_to_supplier 5756 5756 0 0.00 4 11739 128 0 0
sp_payment_common 12796 12796 0 0.00 1 11716 39 0 0
sp_qd_handle_on_cancel_clo 1743 1743 0 0.00 0 11450 309 0 0
sp_qd_handle_on_invoice_upd_sts 10606 10606 0 0.00 0 21965 322 0 0
sp_qd_handle_on_reserve_upd_sts 9827 9827 0 0.00 0 25876 64 0 0
sp_reserve_write_off 9827 9827 0 0.00 6 25896 188 0 0
sp_supplier_invoice 5283 5283 0 0.00 5 82366 3386 0 0
sp_supplier_order 5370 5370 0 0.00 6 35000 1325 0 0
srv_aggregate_perf_data 110 110 0 0.00 2801 163139 15350 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 1001 160811 34186 0 0
srv_find_qd_qs_mism 1055354 1055354 0 0.00 0 21772 5 0 0
srv_make_invnt_saldo 536 536 0 0.00 26 110456 1230 0 0
srv_make_money_saldo 798 798 0 0.00 1 12226 36 0 0
srv_recalc_idx_stat 4 4 0 0.00 231260 358834 282175 0 0
t$perf-abend:sp_add_invoice_to_stock 137 137 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4899 4899 0 0.00 0 19200 199 0 0
t$perf-norm:sp_cancel_adding_invoice 415 415 0 0.00 0 7537 122 0 0
t$perf-norm:sp_cancel_client_order 1743 1743 0 0.00 0 1023 8 0 0
t$perf-norm:sp_cancel_customer_reserve 686 686 0 0.00 0 890 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 690 690 0 0.00 0 10012 32 0 0
t$perf-norm:sp_cancel_pay_to_supplier 400 400 0 0.00 0 955 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 354 354 0 0.00 0 16479 56 0 0
t$perf-norm:sp_cancel_supplier_order 430 430 0 0.00 0 43561 1698 0 0
t$perf-norm:sp_cancel_write_off 1022 1022 0 0.00 0 1824 6 0 0
t$perf-norm:sp_client_order 20237 20237 0 0.00 0 19048 17 0 0
t$perf-norm:sp_customer_reserve 985 985 0 0.00 0 520 4 0 0
t$perf-norm:sp_pay_from_customer 7040 7040 0 0.00 0 6285 11 0 0
t$perf-norm:sp_pay_to_supplier 5756 5756 0 0.00 0 10411 10 0 0
t$perf-norm:sp_reserve_write_off 9827 9827 0 0.00 0 8226 9 0 0
t$perf-norm:sp_supplier_invoice 5283 5283 0 0.00 0 16754 30 0 0
t$perf-norm:sp_supplier_order 5370 5370 0 0.00 0 11607 22 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 780 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 1601 27 0 0
t$perf-norm:srv_make_invnt_saldo 536 536 0 0.00 0 2772 23 0 0
t$perf-norm:srv_make_money_saldo 798 798 0 0.00 0 11294 36 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 10060 9786 274 2.72 0 5963 17 0 274
v_all_customers 37144 37144 0 0.00 0 17 1 0 0
v_all_suppliers 29710 29710 0 0.00 0 21 1 0 0
v_all_wares 40470 40470 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 830 830 0 0.00 0 266 6 0 0
v_cancel_client_order 3486 3486 0 0.00 0 5122 6 0 0
v_cancel_customer_prepayment 1380 1380 0 0.00 0 957 5 0 0
v_cancel_customer_reserve 1372 1372 0 0.00 0 2775 6 0 0
v_cancel_payment_to_supplier 800 800 0 0.00 0 740 4 0 0
v_cancel_supplier_invoice 734 708 26 3.54 0 2223 24 0 26
v_cancel_supplier_order 860 860 0 0.00 0 2865 9 0 0
v_cancel_write_off 2044 2044 0 0.00 0 6076 14 0 0
v_max_id_clo_ord 5368 5368 0 0.00 0 3546 2 0 0
v_max_id_clo_res 985 985 0 0.00 0 2536 16 0 0
v_max_id_ord_sup 5263 5263 0 0.00 0 3986 4 0 0
v_max_non_paid_invoice 1532 1532 0 0.00 0 3690 5 0 0
v_max_non_paid_realizn 3655 3655 0 0.00 0 1937 5 0 0
v_min_id_clo_ord 5368 5368 0 0.00 0 3942 8 0 0
v_min_id_clo_res 985 985 0 0.00 0 2381 10 0 0
v_min_id_ord_sup 5263 5263 0 0.00 0 1494 3 0 0
v_min_non_paid_invoice 5756 5756 0 0.00 0 8591 26 0 0
v_min_non_paid_realizn 7040 7040 0 0.00 0 9362 28 0 0
v_our_firm 10096 10096 0 0.00 0 25 1 0 0
v_reserve_write_off 19654 19654 0 0.00 0 3783 6 0 0
x_lock_depdocs_on_canc_invoice 11613 11613 0 0.00 0 24997 132 0 0
x_lock_depdocs_on_canc_sup_ord 430 430 0 0.00 0 9440 362 0 0
x_make_qstorno_1000_1200 5370 5370 0 0.00 2 34963 1246 0 0
x_make_qstorno_1200_2000 5283 5283 0 0.00 2 82354 3261 0 0
x_make_qstorno_2100_3300 457969 457969 0 0.00 0 74561 167 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-01-2021 01:28:41 to 27-01-2021 01:28:45.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:19 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:26 21053 8192000000 10249679936 10559037440 877351008 9.673 70 47 94 0 896204496 2658768 16194720
22:57:56 33214 8192000000 10364339952 10681040896 1395120720 14.552 100 80 161 0 1425500672 4844496 25535456
22:58:36 26992 8192000000 10397425488 10721001472 1433753280 14.894 100 90 180 0 1469066464 6255520 29057664
22:59:12 2248 8192000000 10405203568 10728419328 1464221296 15.163 100 92 184 0 1501741024 7191360 30328368
22:59:22 16949 8192000000 10413585280 10740813824 1467996000 15.196 100 88 176 1 1503548096 7621408 27930688
22:59:49 16232 8192000000 10426546912 10756317184 1482322768 15.322 100 87 174 0 1518471344 8195376 27953200
23:00:22 16772 8192000000 10435467888 10766409728 1491839984 15.405 100 87 174 1 1528066320 8307024 27919312
23:00:52 12122 8192000000 10448858592 10782978048 1507178064 15.539 100 84 168 0 1542478848 8816528 26484256
23:01:13 22948 8192000000 10478063680 10817466368 1525417712 15.697 100 83 166 0 1560494560 9179488 25897360
23:01:46 17022 8192000000 10506258544 10852184064 1558307840 15.982 100 80 160 1 1593060784 10024928 24728016
23:02:14 14470 8192000000 10529986128 10882334720 1588767888 16.243 100 77 154 1 1621988080 10096112 23124080
23:02:37 5726 8192000000 10565591584 10920587264 1612617888 16.447 100 78 156 0 1647037808 10801968 23617952
23:02:53 9144 8192000000 10574101664 10932752384 1631749232 16.610 100 74 148 0 1665066320 11529872 21787216
23:03:11 7936 8192000000 10588498944 10951725056 1649350160 16.759 100 72 144 1 1682652800 11947744 21354896
23:03:25 8599 8192000000 10599784480 10964307968 1665318864 16.894 100 83 166 1 1701383840 12200624 23864352
23:03:40 8826 8192000000 10619109888 10986868736 1679159264 17.010 100 72 145 0 1711560912 11577584 20824064
23:03:55 7108 8192000000 10650204960 11018678272 1699019376 17.177 100 78 154 3 1736964368 15524096 22420896
23:04:11 6710 8192000000 10653712544 11029143552 1718550976 17.340 100 73 146 0 1750714464 11481968 20681520
23:04:25 5778 8192000000 10663269040 11040608256 1732454816 17.456 100 74 148 0 1765050944 11138304 21457824
23:04:39 7874 8192000000 10678811136 11060875264 1746083344 17.569 100 81 163 1 1781306384 11971488 23251552
23:04:54 5409 8192000000 10698585392 11080060928 1760624448 17.690 100 78 155 3 1795480464 12503936 22352080
23:05:07 4436 8192000000 10707816512 11085864960 1769779792 17.765 100 87 174 1 1809153408 13958784 25414832
23:05:18 4158 8192000000 10717919760 11098333184 1779945152 17.849 100 82 164 0 1816379792 13619168 22815472
23:05:30 3327 8192000000 10733998832 11111395328 1791577232 17.945 100 92 184 4 1830954608 14565200 24812176
23:05:40 2806 8192000000 10742310704 11119202304 1792582576 17.953 100 87 173 0 1831685360 14881248 24221536
23:05:50 5060 8192000000 10736787184 11121324032 1798424944 18.001 100 81 162 2 1836057520 15110864 22521712
23:06:02 2469 8192000000 10754380464 11138580480 1803070992 18.039 100 85 165 1 1840537744 14298816 23167936
23:06:11 2333 8192000000 10765789408 11154460672 1826206672 18.228 100 85 169 1 1863290352 12738624 24345056
23:06:20 2992 8192000000 10765625152 11158675456 1830191936 18.261 100 81 160 0 1865014416 11832560 22989920
23:06:30 2129 8192000000 10785164224 11171336192 1840390048 18.344 100 84 166 1 1875378512 11968688 23019776
23:06:39 2356 8192000000 10789309264 11177422848 1849940704 18.422 100 95 191 2 1891303040 14286816 27075520
23:06:47 1923 8192000000 10799101248 11183554560 1849270880 18.416 100 91 182 1 1889930784 15155888 25504016
23:06:56 1984 8192000000 10805386112 11189739520 1854769248 18.461 100 92 185 0 1895364128 14244384 26350496
23:07:04 2223 8192000000 10804286400 11194798080 1862159344 18.521 100 91 182 1 1902509280 14452288 25897648
23:07:13 1525 8192000000 10812250384 11201503232 1867398128 18.563 100 95 189 1 1907049904 13674352 25977424
23:07:21 1796 8192000000 10812160096 11202150400 1866059888 18.552 100 94 190 1 1905423440 12834464 26529088
23:07:29 1563 8192000000 10805900768 11197870080 1870137856 18.585 100 92 184 0 1908823616 13264384 25421376
23:07:36 2079 8192000000 10815606080 11203563520 1870240928 18.586 100 83 166 1 1906700480 12991424 23468128
23:07:46 1544 8192000000 10818024288 11206508544 1872889200 18.608 100 93 187 0 1913346352 13491728 26965424
23:07:54 1330 8192000000 10829516432 11219439616 1880645152 18.670 100 93 184 2 1920973072 14060880 26267040
23:08:02 18120 8192000000 10810239040 11208732672 1874847024 18.623 100 68 133 1 1905775504 11404864 19523616
23:08:26 2927 8192000000 10805437488 11208814592 1872553904 18.605 100 53 104 1 1898220656 11149328 14517424
23:08:38 4070 8192000000 10813793056 11214999552 1874543024 18.621 100 61 120 1 1904031712 12744224 16744464
23:08:49 3297 8192000000 10812182832 11220234240 1881193616 18.675 100 65 131 0 1914416656 15558192 17664848
23:09:02 5588 8192000000 10794706784 11210956800 1875638944 18.630 100 44 86 1 1898291552 10129888 12522720
23:09:14 6304 8192000000 10788048000 11212713984 1878208256 18.651 100 45 90 1 1899336272 8566112 12561904
23:09:28 11922 8192000000 10785610448 11208605696 1878680144 18.654 100 36 71 1 1896788048 6699776 11408128
23:09:47 44408 8192000000 10799706208 11221696512 1878881920 18.656 100 39 78 3 1896901824 6687248 11332656
23:10:44 19921 8192000000 10779941376 11217022976 1875592832 18.630 100 11 22 0 1884683312 6018784 3071696
23:11:11 6799 8192000000 10797204416 11225825280 1883518272 18.694 100 27 54 2 1898282352 7127936 7636144
23:11:26 3758 8192000000 10811196624 11230060544 1890280752 18.748 100 43 87 2 1908958832 6061792 12616288
23:11:40 5628 8192000000 10805046208 11235917824 1894570736 18.783 100 32 64 1 1910003744 6152576 9280432
23:11:52 6146 8192000000 10817823936 11244257280 1898049952 18.811 100 41 82 2 1920396912 9892208 12454752
23:12:04 9748 8192000000 10803975568 11239858176 1894665584 18.783 100 20 40 2 1906740416 6376848 5697984
23:12:21 7431 8192000000 10802713424 11241078784 1896866576 18.801 100 12 24 0 1905206736 5142768 3197392
23:12:34 7833 8192000000 10822070832 11246276608 1903160608 18.852 100 25 50 1 1917086976 6587456 7338912
23:12:50 11021 8192000000 10805497152 11240685568 1880998176 18.673 99 10 20 0 1889222848 5457056 2767616
23:13:07 8488 8192000000 10813140480 11250167808 1899987552 18.826 100 14 28 1 1908990000 4993312 4009136
23:13:24 8399 8192000000 10821291584 11254689792 1907450256 18.886 100 28 57 0 1921526960 6338784 7737920
23:13:39 12743 8192000000 10817731872 11253661696 1910640736 18.912 100 23 46 0 1923650816 6241920 6768160
23:14:01 60270 8192000000 10835621888 11266347008 1911715168 18.920 100 35 70 3 1926785056 5415136 9654752
23:15:10 6726 8192000000 10826936992 11258626048 1911433744 18.918 100 36 72 1 1928621776 6999664 10188368
23:15:25 5150 8192000000 10816833184 11256721408 1906380688 18.878 100 34 68 2 1923103536 7007792 9715056
23:15:37 8583 8192000000 10827479584 11257270272 1910630560 18.912 100 38 77 1 1928079440 6795024 10653856
23:15:54 7543 8192000000 10813725472 11252649984 1891526400 18.758 99 29 58 0 1907008272 7471136 8010736
23:16:08 5658 8192000000 10826884144 11257393152 1910845776 18.913 100 27 54 3 1924871840 5872720 8153344
23:16:20 3279 8192000000 10827976144 11258773504 1910765152 18.913 100 29 58 0 1924812896 5991936 8055808
23:16:30 4919 8192000000 10807529648 11235340288 1877530704 18.645 98 24 48 1 1890507824 6141856 6835264
23:16:42 9190 8192000000 10807780176 11241279488 1866785440 18.558 98 25 50 1 1879788864 5458912 7544512
23:16:58 5061 8192000000 10804988720 11234840576 1885935920 18.713 99 27 54 0 1899552624 5330256 8286448
23:17:11 6223 8192000000 10794249584 11229126656 1846227648 18.391 97 21 42 1 1862017328 10221344 5568336
23:17:24 8838 8192000000 10801516368 11233230848 1862956912 18.527 98 22 45 0 1874986944 5825360 6204672
23:17:40 6152 8192000000 10792094944 11221184512 1843162656 18.367 98 29 57 0 1856846816 5500976 8183184
23:17:54 11439 8192000000 10754632480 11178000384 1741935376 17.535 93 15 30 0 1751417248 4773424 4708448
23:18:12 10861 8192000000 10724976944 11144908800 1707852160 17.251 93 21 42 0 1719088192 5509248 5726784
23:18:32 67333 8192000000 10631917408 11037724672 1651821936 16.780 91 31 63 0 1665455936 4406496 9227504
23:19:46 11481 8192000000 10672681488 11085139968 1690100464 17.102 94 20 40 0 1705410800 10197568 5112768
23:20:04 6348 8192000000 10693369088 11112038400 1755937856 17.651 98 27 54 0 1769763344 5776224 8049264
23:20:17 2885 8192000000 10680948416 11084898304 1734502896 17.473 97 32 64 0 1750214256 7162752 8548608
23:20:28 5869 8192000000 10704513376 11117084672 1770216096 17.769 99 40 81 1 1788984240 6823248 11944896
23:20:39 9407 8192000000 10710608576 11125182464 1734283792 17.471 96 28 56 2 1752234784 10201008 7749984
23:20:55 10240 8192000000 10712840016 11124817920 1760993968 17.693 98 30 60 2 1776705392 6714896 8996528
23:21:13 8658 8192000000 10722924496 11142336512 1777674336 17.830 98 25 50 0 1794887920 10038912 7174672
23:21:30 9801 8192000000 10717018048 11136872448 1772820352 17.790 98 26 52 2 1785799792 5059888 7919552
23:21:48 7269 8192000000 10743859168 11164434432 1822344864 18.197 100 23 46 0 1835232304 5944832 6942608
23:22:01 14233 8192000000 10747794464 11166941184 1814586352 18.133 99 22 44 1 1826687520 5061520 7039648
23:22:22 10770 8192000000 10756166192 11176067072 1822765216 18.200 99 26 52 4 1835417296 5165360 7486720
23:22:39 13010 8192000000 10737474864 11162947584 1791194640 17.942 97 19 38 0 1801607104 4648944 5763520
23:23:01 21578 8192000000 10747778416 11168530432 1827669952 18.240 99 24 49 0 1840248688 5853840 6724896
23:23:28 53365 8192000000 10763124000 11193360384 1855443600 18.466 100 35 70 1 1871038544 5191824 10403120
23:24:28 18321 8192000000 10760123728 11194781696 1854584384 18.459 100 16 32 2 1864411952 5268000 4559568
23:24:53 7402 8192000000 10780590176 11212509184 1865213184 18.546 100 26 50 0 1883970576 10820288 7937104
23:25:06 6206 8192000000 10791870656 11210928128 1868144640 18.569 100 25 49 0 1881373104 6439488 6788976
23:25:22 6922 8192000000 10789178224 11216142336 1869530192 18.580 100 30 59 1 1888035568 10435088 8070288
23:25:37 8350 8192000000 10787833008 11219574784 1871626512 18.597 100 25 50 0 1889086848 10026240 7434096
23:25:53 7891 8192000000 10780677296 11206811648 1853048384 18.447 99 19 38 0 1864809152 6378464 5382304
23:26:09 6336 8192000000 10787638320 11218972672 1871515872 18.597 100 26 52 1 1885050032 5135696 8398464
23:26:22 7629 8192000000 10785549888 11220766720 1875039808 18.625 100 20 40 0 1886292688 5510576 5742304
23:26:38 6646 8192000000 10792585584 11223773184 1881491376 18.677 100 32 64 3 1896764272 4882768 10390128
23:26:51 8085 8192000000 10790891152 11226562560 1880488080 18.669 100 17 33 1 1890719440 5700800 4530560
23:27:05 8882 8192000000 10826607792 11244974080 1895457248 18.790 100 28 55 2 1908742448 4572832 8712368
23:27:24 7580 8192000000 10840782672 11250335744 1908669664 18.896 100 42 81 1 1925550576 4662272 12218640
23:27:45 16021 8192000000 10839540256 11265245184 1915663840 18.952 100 33 66 2 1931583472 6048464 9871168
23:28:09 14790 8192000000 10846498272 11267932160 1920401936 18.990 100 37 75 1 1938563152 7500128 10661088
23:28:35 40417 8192000000 10857006992 11285200896 1929708640 19.065 100 49 98 2 1951948096 8612112 13627344
23:29:28 113435 8192000000 10864471216 11307855872 1941933008 19.162 100 37 74 0 1962327024 9505472 10888544
23:31:33 17540 8192000000 10884022384 11311497216 1945322672 19.189 100 35 70 1 1967518864 12051696 10144496
23:32:00 22927 8192000000 10876484256 11312193536 1950935296 19.234 100 44 88 1 1976217536 12751232 12531008
23:32:32 15615 8192000000 10875561168 11310702592 1933982224 19.099 99 39 78 0 1960962928 15224800 11755904
23:32:57 13727 8192000000 10881113856 11319689216 1954570560 19.263 100 41 82 1 1977214176 10897952 11745664
23:33:18 3987 8192000000 10895278608 11321724928 1959518864 19.302 100 55 111 0 1986172832 10825792 15828176
23:33:32 19255 8192000000 10899938960 11327074304 1960517360 19.310 100 55 110 0 1989657280 12625568 16514352
23:34:00 2916 8192000000 10901536656 11330834432 1964252880 19.340 100 43 85 1 1988229776 11776096 12200800
23:34:11 3203 8192000000 10901460880 11333513216 1967452720 19.365 100 48 96 1 1993472832 12198688 13821424
23:34:21 11400 8192000000 10915918368 11340128256 1967791280 19.368 100 71 142 1 2002765008 14135296 20838432
23:34:44 20342 8192000000 10905969312 11337785344 1953851120 19.257 99 53 106 3 1981731280 11816224 16063936
23:35:12 17283 8192000000 10912044032 11346993152 1975077856 19.426 100 55 108 1 2002826736 12296320 15452560
23:35:46 21758 8192000000 10925999856 11364990976 1988880720 19.535 100 48 95 2 2015316800 12514256 13921824
23:36:17 4809 8192000000 10932881776 11364880384 1987299552 19.522 100 53 106 3 2018776400 15795856 15680992
23:36:35 13790 8192000000 10929849392 11364716544 1983834464 19.495 100 45 90 1 2012798624 15025056 13939104
23:36:57 8082 8192000000 10930427808 11365920768 1990989056 19.552 100 54 107 1 2024444096 17007008 16448032
23:37:15 11954 8192000000 10937435488 11377393664 1996626624 19.596 100 42 84 0 2027707584 18493744 12587216
23:37:34 12253 8192000000 10941148304 11379318784 1997185824 19.601 100 38 76 1 2027842016 18892784 11763408
23:38:00 4961 8192000000 10945290224 11387142144 2005862560 19.669 100 46 92 0 2037451952 17573424 14015968
23:38:14 16418 8192000000 10955405680 11396231168 2005627568 19.667 100 45 90 1 2040514128 20445280 14441280
23:38:47 16276 8192000000 10957494672 11398348800 2008177728 19.687 100 44 88 0 2045145872 23805248 13162896
23:39:22 15470 8192000000 10964788880 11404931072 2000633024 19.628 99 53 106 1 2042489552 25290752 16565776
23:39:45 6068 8192000000 10972024384 11406053376 2002728032 19.644 99 58 117 1 2048904336 27993344 18182960
23:40:00 9034 8192000000 10979651888 11409018880 2004830896 19.661 99 72 144 2 2054564656 27628608 22105152
23:40:23 6050 8192000000 10982668736 11408130048 2017846240 19.763 100 72 143 1 2068360320 29394912 21119168
23:40:39 3157 8192000000 10988497744 11408719872 2015372832 19.744 100 78 155 1 2068986336 30042912 23570592
23:40:50 1000 8192000000 10993259584 11414859776 2020315680 19.783 100 84 168 0 2076408848 31039216 25053952
23:41:04 5409 8192000000 10993260032 11421650944 2024872368 19.818 100 72 141 1 2079140064 32698176 21569520
23:41:19 5022 8192000000 10989034000 11418595328 2020668592 19.785 100 64 129 0 2075697200 34966640 20061968
23:41:37 6542 8192000000 10977051536 11408392192 2012122096 19.718 100 63 125 0 2066596192 35076032 19398064
23:41:58 7895 8192000000 10979430272 11411521536 2014465280 19.737 100 63 123 1 2067980816 34276784 19238752
23:42:19 4213 8192000000 10959584336 11390181376 1980466336 19.468 98 61 122 0 2035109040 34564208 20078496
23:42:31 5380 8192000000 10990183664 11413176320 2010654256 19.707 100 76 150 1 2066990080 33659232 22676592
23:42:46 3595 8192000000 10976879504 11404587008 2007681792 19.683 100 70 139 0 2065445408 36186736 21576880
23:42:59 3572 8192000000 10987448128 11416469504 2014118880 19.734 100 70 141 1 2074166672 38064320 21983472
23:43:10 3591 8192000000 10996744944 11422801920 2023611040 19.809 100 82 162 0 2087191200 38224320 25355840
23:43:20 2598 8192000000 10983201088 11407597568 2005503392 19.666 100 77 155 2 2069675152 40304288 23867472
23:43:34 2214 8192000000 10979644176 11403075584 1980333280 19.467 99 74 148 0 2042928208 39552288 23042640
23:43:44 1379 8192000000 10976528448 11389685760 1975533120 19.429 99 88 178 4 2043137488 40535056 27069312
23:43:52 2760 8192000000 10957409664 11372498944 1961940368 19.321 99 82 162 3 2028184944 40431120 25813456
23:44:02 2696 8192000000 10972133904 11387219968 1985573120 19.509 100 87 174 1 2054281440 41699984 27008336
23:44:12 3640 8192000000 10971940960 11384881152 1984979456 19.504 100 83 166 2 2053045024 42701824 25363744
23:44:22 3870 8192000000 10958022640 11380916224 1967743104 19.368 99 69 138 2 2031733168 42485744 21504320
23:44:33 12640 8192000000 10939681728 11382222848 1978328784 19.451 100 47 94 3 2033746528 39874080 15543664
23:45:03 15341 8192000000 10951521392 11385368576 1981039552 19.473 100 52 101 0 2034308128 36974544 16294032
23:45:27 5076 8192000000 10939437760 11368366080 1954309456 19.261 99 51 101 1 2011283632 40215104 16759072
23:45:39 3028 8192000000 10953762160 11366236160 1966645248 19.359 100 80 159 0 2033560320 42344352 24570720
23:45:53 1589 8192000000 10923181952 11331051520 1932803472 19.089 98 88 177 1 2004976880 43798048 28375360
23:46:02 1546 8192000000 10939249328 11344105472 1935851344 19.114 99 84 167 2 2009113392 46550096 26711952
23:46:11 2466 8192000000 10958224848 11364335616 1960232848 19.308 100 91 183 1 2038321824 49030880 29058096
23:46:21 4490 8192000000 10966891424 11376279552 1969265696 19.380 100 86 171 1 2046197408 49283584 27648128
23:46:36 4358 8192000000 10967346960 11379277824 1971594000 19.398 100 88 177 1 2049280304 49546640 28139664
23:46:49 2718 8192000000 10950127280 11363303424 1959065504 19.299 100 74 148 0 2034783040 51667072 24050464
23:46:59 2462 8192000000 10966025248 11373539328 1965803504 19.352 100 92 183 0 2047255664 51968832 29483328
23:47:09 1872 8192000000 10963086096 11369578496 1959537984 19.302 99 82 162 0 2039880208 53733424 26608800
23:47:18 1949 8192000000 10984733024 11393863680 1980648400 19.470 100 91 182 1 2063305456 53733760 28923296
23:47:26 7214 8192000000 10976133952 11397144576 1980783600 19.471 100 79 158 0 2061053632 54323728 25946304
23:47:41 6247 8192000000 10967166128 11381620736 1965476368 19.350 99 86 167 0 2044767872 52657952 26633552
23:47:55 3483 8192000000 10971651312 11387240448 1974097248 19.418 100 85 170 3 2057873984 56197760 27578976
23:48:05 15928 8192000000 10966240032 11390066688 1954450080 19.262 99 51 102 2 2024930432 53039312 17441040
23:48:28 10236 8192000000 10946623904 11394768896 1970925040 19.393 100 41 82 0 2040265648 54908592 14432016
23:49:02 7651 8192000000 10945941776 11389734912 1969971872 19.385 100 43 86 0 2037824944 53029440 14823632
23:49:17 14441 8192000000 10941035296 11379171328 1951939216 19.242 99 46 89 3 2013811504 47307552 14564736
23:49:40 8999 8192000000 10941450720 11384397824 1968839376 19.376 100 44 88 0 2029268576 46103888 14325312
23:50:08 35972 8192000000 10940757088 11396378624 1970473680 19.389 100 31 62 5 2028928288 47871056 10583552
23:51:19 30581 8192000000 10935703680 11383799808 1949947600 19.226 99 25 49 0 2004410816 46123584 8339632
23:51:55 25399 8192000000 10937457472 11396804608 1963088560 19.331 100 28 56 1 2025158224 52646912 9422752
23:52:45 30250 8192000000 10911813744 11374034944 1913878064 18.938 99 22 44 2 1985200832 63222224 8100544
23:53:26 23869 8192000000 10894759488 11353280512 1917936864 18.970 100 19 38 2 1981069344 55310368 7822112
23:53:58 23341 8192000000 10886184016 11343142912 1906766752 18.881 99 17 34 1 1962203232 49233392 6203088
23:54:35 37921 8192000000 10868572544 11328692224 1869486448 18.580 97 16 32 4 1914536368 40048064 5001856
23:55:20 80509 8192000000 10856243040 11302236160 1892631136 18.767 98 23 47 1 1909299360 9739760 6928464
23:56:47 71155 8192000000 10842862944 11309264896 1889051296 18.738 98 16 32 1 1909390896 15966544 4373056
23:58:04 62919 8192000000 10864026544 11309031424 1907474720 18.886 99 22 44 1 1918420208 4937680 6007808
23:59:18 75412 8192000000 10872153888 11332071424 1899486592 18.822 98 16 32 1 1915256656 11942608 3827456
00:00:39 65878 8192000000 10912566448 11345997824 1917790384 18.969 98 37 74 2 1938616672 10262992 10563296
00:01:53 24544 8192000000 10902061616 11359629312 1972137424 19.402 100 36 70 1 1995599696 13113296 10348976
00:03:02 43285 8192000000 10883163904 11334553600 1934295328 19.101 99 17 34 1 1949070688 9958208 4817152
00:03:52 41059 8192000000 10893125328 11356049408 1972120944 19.402 100 32 65 1 1990458736 9242128 9095664
00:04:45 36566 8192000000 10921739952 11367620608 1976157952 19.434 100 32 64 0 1996772544 11289296 9325296
00:05:27 49907 8192000000 10903566848 11369492480 1962868304 19.329 99 46 90 2 1992124848 15762736 13493808
00:06:31 34389 8192000000 10904784400 11376664576 1975535344 19.429 100 21 43 1 2000857984 17952528 7370112
00:08:22 47897 8192000000 10891624448 11374452736 1977658704 19.446 100 5 10 0 1986852528 7805568 1388256
00:09:17 6858 8192000000 10893544544 11372875776 1978323456 19.451 100 6 12 0 1987521120 7557840 1639824
00:09:30 20515 8192000000 10895792176 11369148416 1976618432 19.438 100 4 8 0 1986114464 8442992 1053040
00:09:57 79933 8192000000 10915962048 11381989376 1983675088 19.494 100 24 48 0 1998839888 7811456 7353344
00:11:32 63590 8192000000 10895208656 11367493632 1970014128 19.386 99 24 48 1 1986429616 9672144 6743344
00:12:53 53044 8192000000 10910002512 11364487168 1944879440 19.186 98 35 70 1 1963401056 8348560 10173056
00:13:58 54554 8192000000 10901025088 11379142656 1982915872 19.488 100 27 54 1 2004397264 13563344 7918048
00:15:00 61501 8192000000 10908053360 11385663488 1992783744 19.566 100 12 24 0 2004724736 8254240 3686752
00:16:24 60012 8192000000 10904148704 11404230656 1993179648 19.569 100 13 26 0 2008420560 11025600 4215312
00:17:30 60513 8192000000 10933884896 11408338944 2001146064 19.632 100 17 34 0 2018205872 12015488 5044320
00:18:39 48063 8192000000 10920854176 11400093696 1969806384 19.384 98 18 36 1 1987075792 11411008 5858400
00:19:59 23903 8192000000 10937491840 11406700544 1986793280 19.518 99 27 52 1 2010349264 16131184 7424800
00:20:33 41727 8192000000 10958727808 11426766848 2010542192 19.706 100 25 50 2 2039715920 21563616 7610112
00:21:26 72203 8192000000 10927968720 11409936384 1976225792 19.435 99 14 28 0 2009688448 29066576 4396080
00:22:44 81620 8192000000 10918971168 11385311232 1939371536 19.142 97 17 34 3 1962959616 18464448 5123632
00:24:13 33125 8192000000 10932946816 11389493248 1958715776 19.296 98 32 64 0 1979304784 11840864 8748144
00:24:52 55751 8192000000 10933134720 11394936832 1941834656 19.161 97 33 65 4 1970137760 18481392 9821712
00:25:57 34913 8192000000 10922353584 11389456384 1930749056 19.073 97 23 46 1 1955141216 17609088 6783072
00:26:56 100763 8192000000 10857787232 11311419392 1777667344 17.830 90 17 33 1 1796651152 14346144 4637664
00:28:52 95254 8192000000 10888494816 11360911360 1927198640 19.044 98 19 38 1 1942393440 10602384 4592416
00:30:57 65186 8192000000 10896656288 11350372352 1931795696 19.081 98 45 90 3 1959744256 15720480 12228080
00:32:09 45666 8192000000 10885018080 11347038208 1922905984 19.010 98 43 86 1 1947692736 12669680 12117072
00:33:01 90169 8192000000 10891983664 11374080000 1966680112 19.359 100 14 28 1 1988225312 16874496 4670704
00:35:25 59891 8192000000 10881948128 11358605312 1947030192 19.203 99 27 54 0 1973227584 18361120 7836272
00:37:22 46578 8192000000 10867876896 11348574208 1900724656 18.832 97 16 30 0 1920756512 15187840 4844016
00:38:52 63498 8192000000 10868458528 11327033344 1877504960 18.645 97 15 31 1 1893105328 11453840 4146528
00:40:02 59134 8192000000 10806148208 11266117632 1781634048 17.863 92 12 24 0 1791354016 6278928 3441040
00:41:08 26085 8192000000 10854159584 11296817152 1889928416 18.745 98 39 76 1 1909077680 7357552 11791712
00:41:43 36585 8192000000 10862932880 11327688704 1915229312 18.949 99 30 60 2 1933033184 9120688 8683184
00:42:37 49718 8192000000 10840698080 11314708480 1893562576 18.774 98 26 52 0 1912126672 11263504 7300592
00:43:41 56903 8192000000 10854052080 11324583936 1900770608 18.832 98 18 36 1 1914544192 9066560 4707024
00:44:44 24738 8192000000 10860238640 11313016832 1910135136 18.908 99 44 88 1 1933443152 10859232 12448784
00:45:24 58417 8192000000 10842249136 11314921472 1887677232 18.727 98 26 52 0 1905653200 11106960 6869008
00:46:51 58358 8192000000 10876316608 11331538944 1883396416 18.693 97 26 52 1 1903031824 12709328 6926080
00:48:00 72134 8192000000 10885406624 11332235264 1902511120 18.846 98 21 43 2 1919339616 10850352 5978144
00:49:24 7415 8192000000 10891977056 11335413760 1949382544 19.222 100 49 98 1 1973005904 10106576 13516784
00:49:39 9793 8192000000 10904293872 11343454208 1938106992 19.132 99 64 124 0 1967131312 12163680 16860640
00:49:58 100805 8192000000 10855875584 11328888832 1866481392 18.556 96 26 52 0 1887747856 14236992 7029472
00:52:06 160810 8192000000 10898210144 11351777280 1953356304 19.253 100 18 33 2 1971226336 11597632 6272400
00:55:01 69444 8192000000 10901662976 11353849856 1944268880 19.181 99 33 66 1 1961373200 8283472 8820848
00:56:59 33302 8192000000 10868869840 11340660736 1934162512 19.100 99 37 73 0 1954209424 10307296 9739616
00:58:02 47651 8192000000 10867108992 11346726912 1941369680 19.158 99 5 10 0 1948047888 5692384 985824
00:59:33 39804 8192000000 10885349280 11366862848 1970013008 19.386 100 7 14 0 1980026624 8440656 1572960
01:00:21 24560 8192000000 10894395888 11372314624 1972920832 19.409 100 3 6 0 1982052464 8640192 491440
01:00:52 40650 8192000000 10896479920 11381841920 1956730896 19.280 99 7 14 0 1972042416 13770592 1540928
01:01:39 63708 8192000000 10912531552 11385073664 1947724976 19.208 98 17 33 0 1959836592 7718752 4392864
01:02:49 56433 8192000000 10929043728 11401011200 1998393264 19.610 100 29 58 2 2016846240 10169392 8283584
01:04:00 67965 8192000000 10920533840 11404087296 1995156000 19.585 100 14 26 2 2010007680 10772624 4079056
01:05:14 36342 8192000000 10924816896 11393654784 1979671120 19.462 99 23 46 2 1996485104 10189936 6624048
01:06:03 41668 8192000000 10933746560 11396169728 1982436080 19.484 99 42 84 1 2006879312 12707680 11735552
01:06:55 90989 8192000000 10910999024 11380486144 1911675248 18.920 96 11 22 1 1928416400 13459296 3281856
01:08:37 77371 8192000000 10871853696 11347861504 1874020064 18.617 95 14 28 0 1893317440 14820656 4476720
01:10:51 60329 8192000000 10928696960 11366522880 1938338240 19.133 98 23 46 1 1959398576 14402944 6657392
01:12:02 83596 8192000000 10895190880 11353833472 1870116192 18.585 95 19 38 0 1889894688 14572192 5206304
01:13:32 56624 8192000000 10898090352 11344359424 1884778912 18.704 96 37 74 1 1909777728 14260864 10737952
01:14:35 61421 8192000000 10874490784 11342954496 1912494192 18.927 98 26 52 0 1935190336 15423248 7272896
01:15:42 115257 8192000000 10866216016 11326550016 1877369008 18.644 96 32 64 3 1898190624 11712320 9109296
01:17:47 52747 8192000000 10870160576 11337932800 1931479024 19.079 99 13 26 2 1943352080 7779616 4093440
01:19:09 52072 8192000000 10847457584 11327668224 1922395664 19.006 99 5 10 0 1930881168 7283440 1202064
01:20:09 24026 8192000000 10845488736 11320393728 1931654848 19.080 100 3 6 1 1939764176 7355424 753904
01:20:53 24476 8192000000 10857639152 11325034496 1919993968 18.987 99 9 18 0 1930811760 8418304 2399488
01:21:26 39813 8192000000 10850818816 11325698048 1922662880 19.008 99 15 31 0 1936873904 8738496 5472528
01:22:19 51094 8192000000 10846396256 11312058368 1907370688 18.886 98 13 26 1 1921270480 10078288 3821504
01:23:18 99690 8192000000 10835804080 11313233920 1855832848 18.469 96 14 28 1 1874348528 14715888 3799792
01:25:04 66612 8192000000 10851983312 11328471040 1909848112 18.905 99 17 34 0 1926715920 11312064 5555744
01:26:25 48153 8192000000 10858835184 11320041472 1880877312 18.672 97 19 38 1 1893725584 7838048 5010224

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 27-01-2021 01:28:47 to 27-01-2021 01:29:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 137 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-01-2021 01:29:19 to 27-01-2021 01:29:21.

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          239753
MON$OLDEST_ACTIVE               240400
MON$OLDEST_SNAPSHOT             240400
MON$NEXT_TRANSACTION            240400
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                       2025824
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 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 ---
:41: 
:42: mscs-test-161.budzdorov.ru    Wed Jan 27 01:27:16 2021
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:44: 
:45: 
:46: mscs-test-161.budzdorov.ru    Wed Jan 27 01:27:21 2021
:47:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:48: 
:49: 
:50: mscs-test-161.budzdorov.ru    Wed Jan 27 01:27:23 2021
:51:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:52: 
--- end of diff output ---

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

27.01.21 01:29:22. 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-01-27 01:29:24 No severe PSQL-related problems occured
27.01.21 01:29:25. End of report.