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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17470508 kB
MemAvailable 31317316 kB
Buffers 0 kB
Cached 14263100 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-25 22:27:11
DTS_END                         2021-01-25 22:27:11.6010
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/55370
TRN_ID                          241971
ATT_ID                          649
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: 8559.15 19626 1027098
customer order: creation 174.83 336 20980
customer order: refuse 15.28 368 1834
order to supplier: creation 46.28 1394 5554
order to supplier: removal 3.40 92976 408
invoice (draft): creation 47.58 3528 5710
invoice (draft): removal 46.95 840 5634
invoice accept: apply 42.33 19201 5079
invoice accept: cancel 41.73 892 5007
customer reserve: creation 3782.13 196 453856
customer reserve: removal 4073.66 59 488839
realization accept: apply 85.99 196 10319
realization accept: cancel 66.65 106 7998
payment from customer: creation 60.06 116 7207
payment from customer: removal 6.04 89 725
payment to supplier: creation 49.73 121 5968
payment to supplier: removal 3.39 101 407
service: total inventory turnovers 5.18 968 622
service: total monetary turnovers 6.92 25 830
service: aggregate perf. data 0.98 15284 117
service: refresh index statistics 0.03 255726 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 25-01-2021 22:29:47 to 25-01-2021 22:29:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5001
TEST_TIME 2 5239
TEST_TIME 3 3728
TEST_TIME 4 5047
TEST_TIME 5 5361
TEST_TIME 6 5249
TEST_TIME 7 5254
TEST_TIME 8 5161
TEST_TIME 9 5346
TEST_TIME 10 5934
TEST_TIME 11 6325
TEST_TIME 12 7052
TEST_TIME 13 7103
TEST_TIME 14 7209
TEST_TIME 15 7349
TEST_TIME 16 7562
TEST_TIME 17 7570
TEST_TIME 18 8095
TEST_TIME 19 8250
TEST_TIME 20 8516
TEST_TIME 21 8599
TEST_TIME 22 8852
TEST_TIME 23 9046
TEST_TIME 24 9194
TEST_TIME 25 9029
TEST_TIME 26 9405
TEST_TIME 27 9692
TEST_TIME 28 10089
TEST_TIME 29 10201
TEST_TIME 30 9946
TEST_TIME 31 9825
TEST_TIME 32 9896
TEST_TIME 33 9750
TEST_TIME 34 9600
TEST_TIME 35 9583
TEST_TIME 36 9543
TEST_TIME 37 9421
TEST_TIME 38 9256
TEST_TIME 39 9232
TEST_TIME 40 9084
TEST_TIME 41 9043
TEST_TIME 42 8984
TEST_TIME 43 9052
TEST_TIME 44 8955
TEST_TIME 45 8959
TEST_TIME 46 8937
TEST_TIME 47 8809
TEST_TIME 48 8755
TEST_TIME 49 8757
TEST_TIME 50 8855
TEST_TIME 51 8772
TEST_TIME 52 8689
TEST_TIME 53 8607
TEST_TIME 54 8660
TEST_TIME 55 8708
TEST_TIME 56 8757
TEST_TIME 57 8724
TEST_TIME 58 8755
TEST_TIME 59 8762
TEST_TIME 60 8803
TEST_TIME 61 8800
TEST_TIME 62 8892
TEST_TIME 63 8891
TEST_TIME 64 8871
TEST_TIME 65 8980
TEST_TIME 66 8979
TEST_TIME 67 8967
TEST_TIME 68 8958
TEST_TIME 69 9081
TEST_TIME 70 8955
TEST_TIME 71 8884
TEST_TIME 72 8803
TEST_TIME 73 8814
TEST_TIME 74 8795
TEST_TIME 75 8766
TEST_TIME 76 8691
TEST_TIME 77 8650
TEST_TIME 78 8658
TEST_TIME 79 8643
TEST_TIME 80 8666
TEST_TIME 81 8662
TEST_TIME 82 8653
TEST_TIME 83 8654
TEST_TIME 84 8691
TEST_TIME 85 8715
TEST_TIME 86 8708
TEST_TIME 87 8787
TEST_TIME 88 8746
TEST_TIME 89 8725
TEST_TIME 90 8775
TEST_TIME 91 8745
TEST_TIME 92 8841
TEST_TIME 93 8823
TEST_TIME 94 8747
TEST_TIME 95 8719
TEST_TIME 96 8699
TEST_TIME 97 8644
TEST_TIME 98 8605
TEST_TIME 99 8625
TEST_TIME 100 8593
TEST_TIME 101 8694
TEST_TIME 102 8698
TEST_TIME 103 8703
TEST_TIME 104 8671
TEST_TIME 105 8681
TEST_TIME 106 8674
TEST_TIME 107 8702
TEST_TIME 108 8682
TEST_TIME 109 8774
TEST_TIME 110 8802
TEST_TIME 111 8817
TEST_TIME 112 8791
TEST_TIME 113 8741
TEST_TIME 114 8690
TEST_TIME 115 8730
TEST_TIME 116 8715
TEST_TIME 117 8660
TEST_TIME 118 8643
TEST_TIME 119 8627
TEST_TIME 120 8561

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 25-01-2021 22:29:51 to 25-01-2021 22:29:55.

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 1447382 1447382 0 0.00 0 18097 7 0 0
doc_list_biud 1447381 1447381 0 0.00 0 32065 26 0 0
sp_add_invoice_to_stock 5182 5079 103 1.98 25 168787 19202 0 103
sp_cancel_adding_invoice 5007 5007 0 0.00 4 81402 892 0 0
sp_cancel_client_order 1834 1834 0 0.00 4 10170 369 0 0
sp_cancel_customer_reserve 488839 488839 0 0.00 1 32068 60 0 0
sp_cancel_pay_from_customer 725 725 0 0.00 3 9596 90 0 0
sp_cancel_pay_to_supplier 407 407 0 0.00 3 4386 102 0 0
sp_cancel_supplier_invoice 5640 5634 6 0.10 1 24602 841 0 6
sp_cancel_supplier_order 408 408 0 0.00 14 810330 92977 0 0
sp_cancel_write_off 7998 7998 0 0.00 1 5651 106 0 0
sp_client_order 20980 20980 0 0.00 3 59829 337 0 0
sp_customer_reserve 453856 453856 0 0.00 0 34000 197 0 0
sp_fill_shopping_cart 32229 32229 0 0.00 1 20761 43 0 0
sp_fill_shopping_cart_clo_res 453850 453850 0 0.00 0 29398 15 0 0
sp_get_clo_for_invoice 5073 5073 0 0.00 0 43061 338 0 0
sp_kill_cost_storno 14137 14137 0 0.00 0 18087 62 0 0
sp_kill_qstorno_ret_qs2qd 991718 991718 0 0.00 0 32059 33 0 0
sp_kill_qty_storno 525112 525112 0 0.00 0 32064 72 0 0
sp_lock_selected_doc 21387 21387 0 0.00 0 7022 4 0 0
sp_make_cost_storno 28567 28567 0 0.00 0 15404 59 0 0
sp_multiply_rows_for_pdistr 28567 28567 0 0.00 0 11927 31 0 0
sp_multiply_rows_for_qdistr 20980 20980 0 0.00 0 59492 139 0 0
sp_pay_from_customer 7207 7207 0 0.00 4 10316 117 0 0
sp_pay_to_supplier 5968 5968 0 0.00 5 11778 121 0 0
sp_payment_common 13175 13175 0 0.00 1 10166 30 0 0
sp_qd_handle_on_cancel_clo 1834 1834 0 0.00 0 10164 330 0 0
sp_qd_handle_on_invoice_upd_sts 10080 10080 0 0.00 0 21938 365 0 0
sp_qd_handle_on_reserve_upd_sts 10319 10319 0 0.00 0 22173 63 0 0
sp_reserve_write_off 10319 10319 0 0.00 6 22227 196 0 0
sp_supplier_invoice 5710 5710 0 0.00 6 88656 3528 0 0
sp_supplier_order 5554 5554 0 0.00 5 36884 1394 0 0
srv_aggregate_perf_data 117 117 0 0.00 2722 317740 15284 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1061 176214 32632 0 0
srv_find_qd_qs_mism 979100 979100 0 0.00 0 13934 6 0 0
srv_make_invnt_saldo 622 622 0 0.00 30 38086 968 0 0
srv_make_money_saldo 830 830 0 0.00 1 458 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 152530 375949 255727 0 0
t$perf-abend:sp_add_invoice_to_stock 103 103 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5079 5079 0 0.00 0 13655 174 0 0
t$perf-norm:sp_cancel_adding_invoice 451 451 0 0.00 1 7557 93 0 0
t$perf-norm:sp_cancel_client_order 1834 1834 0 0.00 0 3221 14 0 0
t$perf-norm:sp_cancel_customer_reserve 732 732 0 0.00 0 1634 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 725 725 0 0.00 0 741 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 407 407 0 0.00 0 671 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 409 409 0 0.00 0 2856 21 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 22712 1543 0 0
t$perf-norm:sp_cancel_write_off 1029 1029 0 0.00 0 5285 14 0 0
t$perf-norm:sp_client_order 20980 20980 0 0.00 0 15267 20 0 0
t$perf-norm:sp_customer_reserve 1020 1020 0 0.00 0 1656 10 0 0
t$perf-norm:sp_pay_from_customer 7207 7207 0 0.00 0 11746 13 0 0
t$perf-norm:sp_pay_to_supplier 5968 5968 0 0.00 0 8950 12 0 0
t$perf-norm:sp_reserve_write_off 10319 10319 0 0.00 0 15189 12 0 0
t$perf-norm:sp_supplier_invoice 5710 5710 0 0.00 0 6969 21 0 0
t$perf-norm:sp_supplier_order 5554 5554 0 0.00 0 6896 20 0 0
t$perf-norm:srv_aggregate_perf_data 117 117 0 0.00 0 706 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 120 3 0 0
t$perf-norm:srv_make_invnt_saldo 622 622 0 0.00 0 866 21 0 0
t$perf-norm:srv_make_money_saldo 830 830 0 0.00 0 2440 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 10352 10146 206 1.98 0 8293 21 0 206
v_all_customers 37680 37680 0 0.00 0 107 1 0 0
v_all_suppliers 30840 30840 0 0.00 0 108 1 0 0
v_all_wares 41960 41960 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 902 902 0 0.00 0 807 8 0 0
v_cancel_client_order 3668 3668 0 0.00 0 5368 10 0 0
v_cancel_customer_prepayment 1450 1450 0 0.00 0 9581 15 0 0
v_cancel_customer_reserve 1464 1464 0 0.00 0 5033 9 0 0
v_cancel_payment_to_supplier 814 814 0 0.00 0 4341 13 0 0
v_cancel_supplier_invoice 830 818 12 1.44 0 4473 24 0 12
v_cancel_supplier_order 816 816 0 0.00 0 5857 16 0 0
v_cancel_write_off 2058 2058 0 0.00 0 1470 12 0 0
v_max_id_clo_ord 5548 5548 0 0.00 0 460 1 0 0
v_max_id_clo_res 1020 1020 0 0.00 0 2337 12 0 0
v_max_id_ord_sup 5700 5700 0 0.00 0 6650 6 0 0
v_max_non_paid_invoice 1796 1796 0 0.00 0 773 3 0 0
v_max_non_paid_realizn 4112 4112 0 0.00 0 5867 6 0 0
v_min_id_clo_ord 5548 5548 0 0.00 0 4528 7 0 0
v_min_id_clo_res 1020 1020 0 0.00 0 910 3 0 0
v_min_id_ord_sup 5700 5700 0 0.00 0 6173 6 0 0
v_min_non_paid_invoice 5968 5968 0 0.00 0 8650 19 0 0
v_min_non_paid_realizn 7207 7207 0 0.00 0 6590 19 0 0
v_our_firm 10470 10470 0 0.00 0 18 1 0 0
v_reserve_write_off 20638 20638 0 0.00 0 6842 9 0 0
x_lock_depdocs_on_canc_invoice 10232 10232 0 0.00 0 16145 136 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 14091 447 0 0
x_make_qstorno_1000_1200 5554 5554 0 0.00 2 36873 1303 0 0
x_make_qstorno_1200_2000 5710 5710 0 0.00 3 88646 3375 0 0
x_make_qstorno_2100_3300 453856 453856 0 0.00 0 33997 179 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 25-01-2021 22:29:55 to 25-01-2021 22:30:00.

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
19:57:15 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:21 17119 8192000000 10240190912 10547257344 938091840 10.274 73 51 102 0 957737440 2550256 17095344
19:57:50 31481 8192000000 10365172528 10686504960 1409761616 14.682 100 86 172 0 1442395072 4814784 27818672
19:58:31 19250 8192000000 10387870736 10710937600 1443171216 14.978 100 84 168 0 1476123376 6251552 26700608
19:58:59 14168 8192000000 10412288192 10740916224 1470465632 15.218 100 90 180 0 1505990960 7047616 28477712
19:59:27 12280 8192000000 10441230576 10773975040 1491513024 15.402 100 83 165 0 1525543392 7767728 26262640
19:59:51 15756 8192000000 10462127024 10796990464 1513455648 15.593 100 86 172 1 1549022736 8389728 27177360
20:00:18 21093 8192000000 10480534672 10819596288 1533235792 15.765 100 89 178 0 1570173328 9009968 27927568
20:00:49 16139 8192000000 10486836064 10830667776 1546956272 15.884 100 85 169 1 1582878272 9002112 26919888
20:01:15 22004 8192000000 10494081152 10843758592 1556674736 15.968 100 80 160 1 1591209472 9384512 25150224
20:01:44 13421 8192000000 10529527936 10877034496 1583106272 16.195 100 83 166 0 1617622064 9852464 24663328
20:02:05 19407 8192000000 10550244336 10903212032 1599445664 16.335 100 80 160 0 1634238784 10772720 24020400
20:02:40 11770 8192000000 10575138112 10933862400 1636155664 16.647 100 77 154 1 1669970624 11330704 22484256
20:02:59 16320 8192000000 10597083632 10958139392 1652412944 16.785 100 78 156 0 1686749936 11356192 22980800
20:03:24 15967 8192000000 10612409936 10975756288 1668698528 16.922 100 82 164 4 1704683728 11843856 24141344
20:03:47 9894 8192000000 10623214560 10989916160 1681871504 17.033 100 82 164 2 1718420672 12759648 23789520
20:04:06 10571 8192000000 10631764624 11004116992 1692394768 17.121 100 81 161 1 1729036448 13023616 23618064
20:04:28 6486 8192000000 10644991520 11018043392 1710135424 17.270 100 73 146 0 1743405792 12543376 20726992
20:04:41 8390 8192000000 10671335280 11044696064 1728009280 17.419 100 80 160 0 1763783072 12760528 23013264
20:05:01 5862 8192000000 10683506944 11057119232 1740289392 17.521 100 75 149 1 1773689968 12566928 20833648
20:05:14 6134 8192000000 10686124752 11070578688 1756427184 17.655 100 74 146 1 1789364528 12024704 20912640
20:05:28 5219 8192000000 10695569184 11083350016 1768112096 17.751 100 71 140 2 1799685648 11720400 19853152
20:05:40 5998 8192000000 10711572448 11095584768 1778557904 17.838 100 76 152 1 1812129952 11709600 21862448
20:05:54 5194 8192000000 10723833696 11110625280 1788249824 17.917 100 69 138 0 1819237824 11530928 19457072
20:06:06 12464 8192000000 10738505248 11126321152 1801996288 18.030 100 82 164 0 1838151568 12699056 23456224
20:06:27 3639 8192000000 10745366848 11128827904 1803277216 18.041 100 75 148 1 1837080400 13385200 20417984
20:06:38 3992 8192000000 10755699136 11147771904 1821257408 18.188 100 73 146 0 1854135872 12702560 20175904
20:06:49 2905 8192000000 10762417504 11149987840 1824206832 18.212 100 79 158 1 1860069824 13392064 22470928
20:06:59 4611 8192000000 10767858144 11158163456 1834974208 18.300 100 73 147 1 1867440032 12033072 20432752
20:07:10 2091 8192000000 10774521312 11165736960 1843343472 18.368 100 85 169 1 1879294192 12286784 23663936
20:07:19 3096 8192000000 10785348912 11171500032 1842716912 18.363 100 80 160 2 1878467808 13865712 21885184
20:07:28 2077 8192000000 10786127952 11175608320 1849052464 18.414 100 88 173 0 1886762912 13348016 24362432
20:07:37 2158 8192000000 10794418992 11181592576 1851853696 18.437 100 87 174 1 1890437280 13697696 24885888
20:07:46 1805 8192000000 10799636080 11186278400 1851996032 18.438 100 90 180 0 1892139312 14486272 25657008
20:07:54 2042 8192000000 10795724368 11189116928 1858876832 18.494 100 87 173 1 1897392416 14046512 24469072
20:08:03 1940 8192000000 10796655200 11186208768 1856723520 18.477 100 78 157 2 1892007440 13581536 21702384
20:08:11 1744 8192000000 10800953936 11191701504 1862434832 18.523 100 85 170 1 1899112144 12687392 23989920
20:08:19 2251 8192000000 10802695632 11194163200 1864623904 18.541 100 87 176 2 1901265056 12187472 24453680
20:08:29 1480 8192000000 10811378416 11201339392 1867601040 18.565 100 90 177 2 1905366048 13184192 24580816
20:08:37 2031 8192000000 10820800512 11208441856 1873741840 18.615 100 92 183 0 1912581312 13047536 25791936
20:08:45 4133 8192000000 10820600896 11210170368 1874768560 18.623 100 88 174 0 1913130384 13877552 24484272
20:08:55 1377 8192000000 10820962880 11209506816 1878784480 18.655 100 89 180 2 1916416320 13074064 24557776
20:09:03 3305 8192000000 10823498256 11215450112 1879170016 18.658 100 80 159 1 1913553648 12604128 21779504
20:09:13 7676 8192000000 10825863312 11216211968 1880595984 18.670 100 85 172 1 1918328048 13091696 24640368
20:09:27 35069 8192000000 10783651808 11201810432 1873194672 18.610 100 38 74 2 1892224640 8015744 11014224
20:10:10 8545 8192000000 10793958320 11211272192 1876184288 18.634 100 29 59 3 1891068048 6533120 8350640
20:10:26 7577 8192000000 10786599840 11216846848 1881918912 18.681 100 39 78 2 1902084528 8898688 11266928
20:10:42 4960 8192000000 10781789376 11213946880 1878828992 18.656 100 25 49 1 1893648288 7781040 7038256
20:10:57 7167 8192000000 10794767328 11218939904 1879116064 18.658 100 26 54 1 1893066448 6634624 7315760
20:11:11 6687 8192000000 10796035648 11218534400 1880326096 18.668 100 32 63 2 1896878432 7483536 9068800
20:11:25 5667 8192000000 10794710192 11221942272 1881942976 18.681 100 32 64 1 1897877408 7521984 8412448
20:11:37 9155 8192000000 10796261584 11221733376 1881663088 18.679 100 22 44 1 1894481984 6391888 6427008
20:11:54 6461 8192000000 10789209120 11218812928 1884266736 18.700 100 22 44 1 1896085952 5537520 6281696
20:12:08 10261 8192000000 10784366848 11218956288 1883109968 18.690 100 19 38 1 1893450800 5043888 5296944
20:12:25 10034 8192000000 10795595424 11224764416 1883518064 18.694 100 13 26 1 1892815712 5639744 3657904
20:12:44 9558 8192000000 10797955872 11227574272 1889555424 18.742 100 30 58 1 1904089072 6204080 8329568
20:13:06 12067 8192000000 10806144864 11231596544 1892383744 18.765 100 30 60 2 1907403056 6523536 8495776
20:13:25 18771 8192000000 10819054032 11231715328 1891485840 18.758 100 18 37 1 1903063904 6405440 5172624
20:13:49 15228 8192000000 10809623264 11238780928 1895771152 18.792 100 24 46 1 1909163936 6000608 7392176
20:14:11 59521 8192000000 10841643344 11251412992 1902045936 18.843 100 59 114 2 1925688416 6293056 17349424
20:15:17 4263 8192000000 10826895424 11252043776 1904871328 18.865 100 51 102 0 1929232432 9944672 14416432
20:15:30 7128 8192000000 10816307888 11249356800 1898412720 18.814 100 23 49 1 1911003728 5935456 6655552
20:15:44 10843 8192000000 10817699808 11252822016 1902045488 18.843 100 22 44 1 1913996304 6144800 5806016
20:16:04 4843 8192000000 10813223136 11253055488 1904862544 18.865 100 27 54 1 1919950640 7666400 7421696
20:16:18 9836 8192000000 10821834048 11259060224 1906588896 18.879 100 24 46 1 1918948416 5303200 7056320
20:16:36 6806 8192000000 10824957984 11260637184 1912031536 18.923 100 30 58 1 1926527440 5819104 8676800
20:16:49 5460 8192000000 10826616160 11256365056 1906484272 18.878 100 27 54 1 1920249776 5936784 7828720
20:17:07 6443 8192000000 10793869296 11224428544 1841916048 18.356 97 23 44 3 1853879472 5272560 6690864
20:17:20 5032 8192000000 10790964560 11219156992 1830928448 18.267 97 23 47 2 1843912576 5825808 7158320
20:17:32 9285 8192000000 10736898272 11160772608 1736251008 17.487 93 15 30 2 1745531152 5000416 4279728
20:17:47 12931 8192000000 10744562032 11172610048 1793576832 17.961 97 8 16 0 1801139248 5122768 2439648
20:18:07 17964 8192000000 10760448512 11185209344 1779406352 17.845 96 21 42 0 1791968976 5010912 7551712
20:18:34 57482 8192000000 10737313120 11165073408 1775810544 17.815 96 17 34 0 1785751968 5019632 4921792
20:19:42 10655 8192000000 10724816592 11139153920 1730963728 17.444 95 22 44 2 1742722128 5730320 6028080
20:20:00 5067 8192000000 10713963984 11130826752 1787897856 17.914 99 37 75 0 1806174416 7979472 10297088
20:20:12 9514 8192000000 10723337088 11138347008 1764183488 17.719 97 28 56 2 1778344704 6315856 7845360
20:20:28 4290 8192000000 10743219776 11152404480 1804760624 18.053 99 33 67 0 1820910576 6760464 9389488
20:20:42 7908 8192000000 10751441840 11169714176 1814627472 18.134 99 20 40 0 1825709792 5425616 5656704
20:20:56 8644 8192000000 10719351840 11137544192 1740353920 17.522 95 30 60 1 1753737504 5392112 7991472
20:21:11 8123 8192000000 10697126224 11105460224 1701512432 17.198 94 29 59 1 1714937152 5698912 7725808
20:21:28 3443 8192000000 10690334112 11086241792 1717655968 17.333 96 38 77 1 1733442528 5510416 10276144
20:21:42 10042 8192000000 10714707968 11122757632 1762046336 17.701 98 28 56 0 1775801920 4977712 8777872
20:22:05 8602 8192000000 10703476816 11120848896 1791196320 17.942 100 30 60 2 1806464912 5886384 9382208
20:22:25 12143 8192000000 10701629216 11118198784 1746820896 17.575 97 19 38 1 1757639248 5261312 5557040
20:22:48 12678 8192000000 10739170640 11150331904 1814178864 18.130 100 49 99 1 1835186896 5820192 15187840
20:23:06 78785 8192000000 10745707936 11171057664 1832646512 18.281 100 22 44 2 1844341296 5154896 6539888
20:24:33 13865 8192000000 10754363040 11180769280 1843125776 18.366 100 27 54 3 1857183248 6575280 7482192
20:24:55 5397 8192000000 10767541664 11187814400 1846691024 18.395 100 41 81 3 1865641168 7942192 11007952
20:25:08 9268 8192000000 10783021904 11195904000 1848860576 18.413 100 33 66 2 1864676416 6631040 9184800
20:25:23 7562 8192000000 10775880256 11192057856 1851643056 18.435 100 47 92 5 1871468304 6261936 13563312
20:25:38 9472 8192000000 10753748368 11183480832 1834060656 18.292 99 35 70 1 1849828736 5872320 9895760
20:25:54 6041 8192000000 10771934176 11193925632 1850606832 18.427 100 26 50 3 1863862128 6226304 7028992
20:26:06 9786 8192000000 10773279504 11194773504 1853347488 18.449 100 18 34 2 1863501344 5249936 4903920
20:26:27 9334 8192000000 10766371776 11197227008 1857815360 18.486 100 25 50 0 1871103360 5279616 8008384
20:26:42 7180 8192000000 10767789024 11200647168 1858273984 18.489 100 19 38 1 1869354288 5472928 5607376
20:26:56 12202 8192000000 10781839488 11209207808 1864881520 18.543 100 20 39 3 1876072448 4870720 6320208
20:27:16 18773 8192000000 10811641664 11229650944 1884521664 18.702 100 35 69 1 1899611904 4417040 10673200
20:27:44 37856 8192000000 10842793440 11258523648 1907415824 18.886 100 56 110 1 1931129728 7965328 15748576
20:28:30 12239 8192000000 10848948896 11267145728 1917098368 18.964 100 50 95 2 1941647536 11691264 12857904
20:28:49 31952 8192000000 10855624192 11268329472 1915893264 18.954 100 49 98 0 1941619648 12366592 13359792
20:29:39 43104 8192000000 10858264752 11280252928 1923449920 19.014 100 42 84 0 1948461488 13014864 11996704
20:30:30 65006 8192000000 10858689328 11292053504 1930373296 19.070 100 50 99 1 1959247840 14009648 14864896
20:31:43 17115 8192000000 10859630896 11292041216 1933649856 19.096 100 42 84 0 1958484880 12250896 12584128
20:32:18 4954 8192000000 10876949872 11298271232 1941235088 19.157 100 56 112 2 1971715616 13360736 17119792
20:32:30 18014 8192000000 10884639424 11311939584 1946700048 19.200 100 55 110 0 1979168000 16079680 16388272
20:33:05 23581 8192000000 10888082608 11319787520 1952539600 19.247 100 49 99 2 1981867760 13799984 15528176
20:33:38 24673 8192000000 10900881552 11330387968 1957805760 19.289 100 40 80 1 1984286224 14675312 11805152
20:34:13 17847 8192000000 10901623264 11332087808 1963212240 19.332 100 39 78 4 1988727424 14389200 11125984
20:34:39 26616 8192000000 10907887200 11340210176 1968766224 19.376 100 48 96 1 1999521408 16297584 14457600
20:35:16 29450 8192000000 10911941584 11346808832 1972955680 19.409 100 40 80 1 2003795456 18443008 12396768
20:35:53 12428 8192000000 10909120928 11348078592 1975831664 19.432 100 42 84 0 2008815584 19725072 13258848
20:36:15 9043 8192000000 10908934528 11349262336 1974114624 19.418 100 37 74 1 2005329648 19815216 11399808
20:36:32 5532 8192000000 10923829072 11355189248 1977697488 19.446 100 49 99 0 2010715600 18299376 14718736
20:36:47 3532 8192000000 10922774640 11338584064 1962428464 19.325 99 69 137 2 2001911856 19285792 20197600
20:36:58 6176 8192000000 10915470752 11328102400 1955182960 19.268 99 67 132 1 1995748256 21243936 19321360
20:37:12 4530 8192000000 10917704432 11327004672 1952771888 19.249 99 66 132 1 1997771248 25125616 19873744
20:37:24 8632 8192000000 10925597952 11348910080 1971215056 19.395 100 62 122 3 2014407968 25102544 18090368
20:37:41 4186 8192000000 10909628944 11337469952 1957505968 19.286 99 64 125 1 2004829232 27819216 19504048
20:37:52 3478 8192000000 10942013840 11358654464 1978979360 19.457 100 65 129 0 2026262400 28734864 18548176
20:38:03 8279 8192000000 10906711392 11331596288 1931417568 19.078 98 63 126 1 1972121328 22421680 18282080
20:38:19 3580 8192000000 10918294096 11332341760 1942101456 19.164 99 83 164 2 1992647184 25648368 24897360
20:38:30 2438 8192000000 10940857216 11354120192 1972025536 19.402 100 91 183 1 2024325504 25465088 26834880
20:38:39 5077 8192000000 10944897424 11361865728 1973989008 19.417 100 75 150 1 2025027424 28919600 22118816
20:38:50 9705 8192000000 10925137824 11337052160 1953601216 19.255 99 75 149 1 2003702896 28240400 21861280
20:39:07 5587 8192000000 10932391712 11347222528 1952702784 19.248 99 80 158 2 2003629024 26573312 24352928
20:39:19 4114 8192000000 10932680320 11349749760 1974785760 19.423 100 80 155 3 2023307600 25655744 22866096
20:39:31 4100 8192000000 10932083808 11349671936 1965748432 19.352 100 69 138 0 2013374560 25475376 22150752
20:39:44 1409 8192000000 10950991792 11361259520 1979261792 19.459 100 82 164 3 2027205280 22347568 25595920
20:39:52 9318 8192000000 10928881904 11365535744 1979938528 19.464 100 59 118 0 2022134480 24279056 17916896
20:40:11 13529 8192000000 10924354800 11356467200 1971835344 19.400 100 49 98 1 2010427088 23384256 15207488
20:40:33 8765 8192000000 10925189472 11362467840 1974131328 19.418 100 41 82 0 2008708080 21626928 12949824
20:40:52 6205 8192000000 10947246960 11375493120 1985057792 19.505 100 52 104 0 2024482032 23210224 16214016
20:41:13 5331 8192000000 10932682768 11361255424 1961624304 19.319 99 54 108 1 2003122080 25132864 16364912
20:41:26 6536 8192000000 10937296304 11355557888 1968463312 19.373 100 70 140 0 2016058784 26726992 20868480
20:41:40 7590 8192000000 10947518448 11369025536 1984096464 19.497 100 73 146 0 2030628080 24973296 21558320
20:42:00 1671 8192000000 10956601696 11374198784 1989496560 19.540 100 77 154 2 2038129872 25777056 22856256
20:42:08 4293 8192000000 10933904928 11360145408 1976843680 19.440 100 70 140 1 2023048544 25104112 21100752
20:42:21 4220 8192000000 10935848656 11360600064 1959415824 19.301 99 66 131 0 2004136144 24777440 19942880
20:42:33 4181 8192000000 10936757280 11360645120 1975315248 19.428 100 62 122 1 2019520208 25704912 18500048
20:42:44 2164 8192000000 10943568528 11356983296 1971208544 19.395 100 76 152 0 2019439200 25819088 22411568
20:42:54 1054 8192000000 10938808368 11354320896 1951735616 19.240 99 80 158 2 2005190368 28464176 24990576
20:43:02 5167 8192000000 10944336112 11366629376 1975242416 19.427 100 73 144 3 2026457536 29391024 21824096
20:43:15 2329 8192000000 10936744496 11359215616 1964673568 19.343 100 65 130 1 2018306592 33941760 19691264
20:43:24 3592 8192000000 10902444896 11330555904 1935445568 19.110 99 63 126 1 1985440288 30891520 19103200
20:43:36 12897 8192000000 10885603248 11328180224 1933085952 19.092 100 36 72 0 1975643328 30345504 12211872
20:43:56 21162 8192000000 10904948816 11339448320 1911604304 18.920 98 35 69 0 1954237488 31446432 11186752
20:44:29 4564 8192000000 10904081664 11332239360 1928713536 19.057 99 55 105 1 1981237792 35335184 17189072
20:44:40 3744 8192000000 10943440848 11359887360 1961210736 19.316 100 75 147 1 2021475920 36419856 23845328
20:44:51 1322 8192000000 10944476608 11363631104 1968436928 19.373 100 75 150 2 2029580160 37547680 23595552
20:44:59 3853 8192000000 10954667120 11375349760 1958130080 19.291 99 78 153 2 2020710048 39015520 23564448
20:45:10 4062 8192000000 10952534800 11360165888 1947424608 19.206 99 86 168 1 2012810048 40313584 25071856
20:45:21 1500 8192000000 10968539984 11378892800 1977830480 19.448 100 84 166 0 2045810720 42272048 25708192
20:45:29 4539 8192000000 10962088464 11373494272 1969755408 19.384 100 82 164 2 2037969056 42547552 25666096
20:45:42 2292 8192000000 10955821360 11370762240 1969595136 19.382 100 80 159 1 2035335104 40684848 25055120
20:45:51 7231 8192000000 10944063104 11367137280 1954540240 19.263 99 72 144 0 2016038704 38814160 22684304
20:46:06 2270 8192000000 10971108640 11377405952 1977973376 19.449 100 94 188 2 2044618432 37754752 28890304
20:46:15 3205 8192000000 10935983040 11361599488 1958510864 19.294 99 71 142 0 2018941056 38817136 21613056
20:46:31 3881 8192000000 10932804448 11356954624 1932323296 19.085 98 59 113 1 1986031216 36061376 17646544
20:46:51 4861 8192000000 10953459456 11374886912 1971415120 19.397 100 72 143 1 2032659280 38927600 22316560
20:47:03 3993 8192000000 10917711296 11324690432 1920078320 18.987 99 74 144 3 1978874256 36900112 21895824
20:47:14 2281 8192000000 10957102464 11361718272 1960476480 19.310 100 94 189 0 2028729360 38546688 29706192
20:47:25 2971 8192000000 10933648064 11358203904 1961188960 19.315 100 74 148 2 2022537008 38612480 22735568
20:47:40 5507 8192000000 10941045728 11349938176 1941821792 19.161 99 80 160 0 2005274336 39364032 24088512
20:47:53 3361 8192000000 10918194768 11339137024 1938964880 19.138 99 55 110 0 1995540928 38484896 18091152
20:48:07 4082 8192000000 10907346768 11328413696 1906789776 18.881 98 59 115 1 1962001104 37570720 17640608
20:48:18 1981 8192000000 10950017040 11353878528 1952782928 19.249 100 83 164 1 2017465696 38698384 25984384
20:48:27 3385 8192000000 10951687664 11363397632 1963534192 19.334 100 73 144 0 2026749888 41300400 21915296
20:48:37 1923 8192000000 10958390864 11362201600 1957084992 19.283 100 95 186 0 2031948144 44459824 30403328
20:48:45 1832 8192000000 10959533088 11370528768 1940851552 19.154 99 85 170 0 2012937664 46307536 25778576
20:48:54 2892 8192000000 10954444832 11365990400 1963733408 19.336 100 84 166 0 2031392784 41480544 26178832
20:49:07 4093 8192000000 10939178112 11369234432 1966659952 19.359 100 65 130 1 2027890528 40720080 20510496
20:49:23 10774 8192000000 10937092208 11372318720 1970419312 19.389 100 51 100 1 2021285824 34649712 16216800
20:49:41 6308 8192000000 10948416832 11379752960 1975425440 19.428 100 50 100 0 2027838720 36465696 15947584
20:49:55 6391 8192000000 10944661728 11383758848 1977938192 19.448 100 38 76 1 2026118528 35880112 12300224
20:50:14 12400 8192000000 10923841120 11362369536 1947232544 19.204 99 38 76 0 1994222896 34954288 12036064
20:50:38 12722 8192000000 10907448304 11348619264 1938287312 19.133 99 28 56 1 1983994736 36491472 9215952
20:50:58 10301 8192000000 10905899648 11355680768 1935196688 19.108 99 28 56 1 1979953440 35350496 9406256
20:51:38 14634 8192000000 10893232816 11335585792 1931824336 19.081 99 26 52 1 1970210288 29960256 8425696
20:52:15 16863 8192000000 10900603072 11333550080 1937748000 19.129 100 48 97 1 1982619744 30057920 14813824
20:52:39 19594 8192000000 10869903088 11306557440 1883662592 18.695 97 30 60 0 1928618464 34708640 10247232
20:53:13 14502 8192000000 10890063840 11331919872 1921205616 18.996 100 28 56 0 1973235552 41876000 10153936
20:53:40 24545 8192000000 10871085344 11322159104 1903766672 18.857 99 28 56 2 1956679392 42327424 10585296
20:54:14 39433 8192000000 10868994640 11326959616 1911566480 18.919 100 16 32 0 1956812000 38934800 6310720
20:55:07 8287 8192000000 10879833040 11323625472 1917265584 18.965 100 21 40 2 1958147920 34048816 6833520
20:55:24 9097 8192000000 10873022304 11327275008 1923037072 19.011 100 34 68 3 1967085568 32588784 11459712
20:55:40 14172 8192000000 10849063424 11304194048 1905168016 18.868 99 22 44 0 1935278368 22816512 7293840
20:56:05 17118 8192000000 10852994384 11309006848 1908520016 18.895 99 18 37 0 1925464896 11845680 5099200
20:56:32 49569 8192000000 10865200464 11316805632 1930361888 19.070 100 28 56 2 1952704160 14071904 8270368
20:57:32 97462 8192000000 10883527360 11331543040 1928087744 19.052 99 43 86 1 1957132176 15252160 13792272
20:59:27 42139 8192000000 10858688816 11323977728 1921596672 19.000 99 13 26 0 1932662672 7510688 3555312
21:00:16 73045 8192000000 10851841040 11297505280 1851089440 18.431 95 28 54 3 1866351296 7468240 7793616
21:01:37 31133 8192000000 10881962384 11312877568 1923056032 19.011 99 43 85 3 1943249648 7956848 12236768
21:02:19 74823 8192000000 10881767984 11330048000 1943551168 19.175 100 38 76 0 1966766624 11953136 11262320
21:03:42 58310 8192000000 10867244336 11336028160 1931451888 19.078 99 5 9 0 1942656688 9659008 1545792
21:04:46 31850 8192000000 10897677088 11339112448 1940655344 19.152 99 19 37 1 1952306592 6878336 4772912
21:05:25 23305 8192000000 10900150000 11346911232 1967901136 19.369 100 41 78 1 1988067744 9219104 10947504
21:05:56 91063 8192000000 10886613536 11353370624 1948900752 19.218 99 12 24 0 1964520752 12011312 3608688
21:07:33 90268 8192000000 10883601120 11346911232 1952798752 19.249 99 24 48 1 1969328416 9671040 6858624
21:10:10 71261 8192000000 10902004544 11362689024 1972341824 19.404 100 20 40 0 1990783312 12251232 6190256
21:11:35 94089 8192000000 10896184704 11365863424 1945673728 19.192 98 24 48 0 1964254640 11405696 7175216
21:13:37 56022 8192000000 10887008000 11359748096 1961382080 19.317 99 13 26 0 1974904000 8745936 4775984
21:15:02 16927 8192000000 10913107840 11372281856 1984880192 19.503 100 46 90 2 2006093360 8115936 13097232
21:15:29 33368 8192000000 10934758496 11377168384 1976254512 19.435 99 27 52 1 1993490064 9361312 7874240
21:16:10 93681 8192000000 10904919168 11392196608 1984988176 19.504 100 20 41 0 2007031456 15999888 6043392
21:18:22 49592 8192000000 10912190368 11385954304 1992741824 19.565 100 13 26 0 2003782560 7505008 3535728
21:21:22 66528 8192000000 10881400272 11351756800 1911973488 18.922 96 15 28 1 1929828288 13792240 4062560
21:22:35 31930 8192000000 10873957440 11340881920 1929527952 19.063 98 17 35 0 1944408448 9925776 4954720
21:23:18 55756 8192000000 10886028080 11358109696 1939238784 19.141 99 18 34 0 1953251424 7116208 6896432
21:24:24 70746 8192000000 10904517488 11372785664 1960605072 19.311 99 15 30 1 1974450672 9982464 3863136
21:25:40 51067 8192000000 10899685968 11364679680 1928598800 19.056 98 16 32 0 1941966304 9351488 4016016
21:26:38 97591 8192000000 10867096496 11327262720 1773924464 17.799 90 24 46 2 1789990848 10066736 5999648
21:28:26 72311 8192000000 10888271616 11348889600 1902259680 18.844 97 25 50 0 1924785472 15625520 6900272
21:29:51 75589 8192000000 10901396096 11357941760 1909021520 18.899 97 10 20 0 1920419184 8731312 2666352
21:31:13 29757 8192000000 10901790960 11343933440 1891799888 18.760 96 37 74 0 1912795776 10372432 10623456
21:31:55 34176 8192000000 10876913120 11340906496 1915797920 18.953 98 39 78 0 1940262624 13481504 10983200
21:33:22 41108 8192000000 10898023120 11332923392 1908782016 18.897 98 31 62 1 1927150032 9593088 8774928
21:34:10 16226 8192000000 10873101232 11316228096 1870869936 18.591 96 43 86 5 1894816320 12203680 11742704
21:34:34 27906 8192000000 10871695840 11321417728 1915334832 18.949 99 29 58 0 1934147104 10743520 8068752
21:35:08 35214 8192000000 10874363424 11321393152 1887460320 18.725 97 40 80 1 1909474736 10856704 11157712
21:35:50 66355 8192000000 10856067776 11332345856 1905511408 18.871 98 20 40 0 1925203952 14173936 5518608
21:37:06 119312 8192000000 10850635216 11300073472 1839961888 18.340 95 22 45 1 1862797792 16850784 5985120
21:39:12 39566 8192000000 10841122096 11286765568 1886732384 18.719 98 43 86 0 1910391936 11970192 11689360
21:40:02 8212 8192000000 10855147728 11289878528 1918911376 18.978 100 61 122 1 1945162720 9612384 16638960
21:40:17 69471 8192000000 10850509856 11319730176 1897137968 18.803 98 41 80 4 1919909040 11304192 11466880
21:42:57 67591 8192000000 10847337616 11306381312 1882363472 18.684 97 13 26 2 1896950480 10652672 3934336
21:44:19 64640 8192000000 10844569632 11313602560 1913860160 18.938 99 22 44 1 1931328944 10318720 7150064
21:45:31 76038 8192000000 10838616800 11310526464 1891491232 18.758 98 19 36 1 1905642800 8462880 5688688
21:47:01 59853 8192000000 10808558016 11279970304 1826128112 18.228 95 17 34 3 1843060752 11738256 5194384
21:48:07 59287 8192000000 10846029456 11303854080 1876833120 18.640 98 11 22 1 1886833744 7418608 2582016
21:49:15 18575 8192000000 10883843648 11320627200 1936705232 19.120 100 41 81 3 1956962016 7735664 12521120
21:49:40 46585 8192000000 10868508560 11326406656 1921333568 18.998 99 28 56 0 1938952192 9877904 7740720
21:51:02 66508 8192000000 10866477552 11331481600 1919737232 18.985 99 22 44 0 1936061792 10527920 5796640
21:52:15 61116 8192000000 10863994496 11327873024 1906787216 18.881 98 18 36 0 1921749632 9766208 5196208
21:53:26 87643 8192000000 10842854704 11323523072 1887706688 18.727 97 23 46 0 1904639808 9648864 7284256
21:54:59 44706 8192000000 10863179280 11320025088 1917162720 18.964 99 14 28 1 1929410160 8142432 4105008
21:55:52 31991 8192000000 10887075888 11339739136 1951028400 19.235 100 41 81 1 1973914944 10638736 12247808
21:56:34 40950 8192000000 10885647552 11340029952 1933848176 19.098 99 34 68 1 1956257072 12663344 9745552
21:57:21 65053 8192000000 10897810736 11336114176 1902671216 18.848 97 29 58 1 1922757424 12858128 7228080
21:58:33 108222 8192000000 10864294848 11340472320 1880602960 18.670 96 11 22 0 1898905904 15036592 3266352
22:00:28 97312 8192000000 10864375584 11316154368 1901914528 18.842 97 19 39 0 1918006912 11048496 5043888
22:02:35 27571 8192000000 10874911376 11338887168 1949501200 19.223 100 36 71 3 1969542480 9928352 10112928
22:03:16 63002 8192000000 10881709504 11352363008 1958233888 19.292 100 9 18 0 1970536656 10071456 2231312
22:04:25 26520 8192000000 10888796528 11362930688 1964610800 19.343 100 6 12 0 1976762864 10519904 1632160
22:04:58 29924 8192000000 10893349488 11353456640 1949438032 19.222 99 6 12 0 1963425968 12163920 1824016
22:05:36 56026 8192000000 10885466928 11365126144 1963617504 19.335 100 7 15 0 1975252656 10013408 1621744
22:06:57 58244 8192000000 10873770640 11336839168 1869128256 18.577 95 19 37 1 1883810976 9211232 5471488
22:08:02 96895 8192000000 10881172352 11366391808 1932894000 19.090 99 12 24 0 1950070800 13479056 3697744
22:09:49 101625 8192000000 10904695360 11376246784 1950685360 19.232 99 18 36 2 1968109696 12721728 4702608
22:11:45 41590 8192000000 10915435344 11364966400 1967787536 19.368 100 29 58 0 1984051456 7941264 8322656
22:12:34 71092 8192000000 10893391472 11354189824 1922510320 19.007 97 27 54 2 1942963248 12655952 7796976
22:13:57 36698 8192000000 10889107056 11347288064 1913632048 18.936 97 37 73 0 1935829504 11113296 11084160
22:15:00 78797 8192000000 10909549984 11376422912 1962631344 19.327 100 21 42 1 1986009520 17209920 6168256
22:16:28 157429 8192000000 10887999984 11367485440 1806359120 18.066 92 15 29 4 1831834688 21536256 3939312
22:19:12 176214 8192000000 10896565424 11362037760 1920336336 18.990 98 22 44 0 1943671808 17755920 5579552
22:22:15 65584 8192000000 10853344224 11332186112 1898009504 18.810 97 12 24 1 1916781808 15008784 3763520
22:23:28 61431 8192000000 10852671872 11329134592 1914182352 18.940 99 8 16 1 1931282256 14314560 2785344
22:24:35 72575 8192000000 10863668432 11339235328 1945269600 19.189 100 12 25 0 1958854832 9627120 3958112
22:25:54 51317 8192000000 10857106064 11332820992 1899736224 18.824 97 16 32 0 1912781216 8064576 4980416
22:26:52 47662 8192000000 9600242928 9927286784 753929712 8.427 39 5 10 0 759968928 4411584 1627632

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 25-01-2021 22:30:01 to 25-01-2021 22:30:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 103 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-01-2021 22:30:34 to 25-01-2021 22:30:36.

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          242214
MON$OLDEST_ACTIVE               242215
MON$OLDEST_SNAPSHOT             242215
MON$NEXT_TRANSACTION            242215
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                       2002432
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:428: 
:429: mscs-test-161.budzdorov.ru    Mon Jan 25 22:27:44 2021
:430:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:431: 
--- end of diff output ---

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

25.01.21 22:30:37. 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-25 22:30:39 No severe PSQL-related problems occured
25.01.21 22:30:41. End of report.