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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17056180 kB
MemAvailable 31330372 kB
Buffers 0 kB
Cached 14592700 kB
SwapCached 4864 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-11 19:27:07
DTS_END                         2021-01-11 19:27:07.8260
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_FROM_CUSTOMER(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/37612
TRN_ID                          245757
ATT_ID                          662
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: 9749.99 21913 1169999
customer order: creation 178.07 334 21368
customer order: refuse 15.78 321 1893
order to supplier: creation 48.23 1304 5787
order to supplier: removal 3.53 97206 424
invoice (draft): creation 48.56 3259 5827
invoice (draft): removal 55.26 808 6631
invoice accept: apply 44.17 17025 5300
invoice accept: cancel 50.15 693 6018
customer reserve: creation 4069.47 169 488336
customer reserve: removal 4919.17 53 590300
realization accept: apply 88.11 165 10573
realization accept: cancel 92.97 99 11156
payment from customer: creation 62.18 107 7462
payment from customer: removal 5.97 102 716
payment to supplier: creation 52.12 126 6254
payment to supplier: removal 3.78 72 454
service: total inventory turnovers 4.97 995 596
service: total monetary turnovers 6.58 21 790
service: aggregate perf. data 0.92 16999 110
service: refresh index statistics 0.03 298397 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-01-2021 19:27:48 to 11-01-2021 19:27:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3801
TEST_TIME 2 5266
TEST_TIME 3 5392
TEST_TIME 4 5560
TEST_TIME 5 5159
TEST_TIME 6 5583
TEST_TIME 7 5735
TEST_TIME 8 5686
TEST_TIME 9 6158
TEST_TIME 10 6070
TEST_TIME 11 6332
TEST_TIME 12 6346
TEST_TIME 13 6930
TEST_TIME 14 7154
TEST_TIME 15 7457
TEST_TIME 16 7705
TEST_TIME 17 7837
TEST_TIME 18 8438
TEST_TIME 19 8321
TEST_TIME 20 8590
TEST_TIME 21 8593
TEST_TIME 22 8541
TEST_TIME 23 8495
TEST_TIME 24 8832
TEST_TIME 25 9882
TEST_TIME 26 9977
TEST_TIME 27 10212
TEST_TIME 28 10444
TEST_TIME 29 10516
TEST_TIME 30 10956
TEST_TIME 31 10821
TEST_TIME 32 10777
TEST_TIME 33 10670
TEST_TIME 34 10581
TEST_TIME 35 10479
TEST_TIME 36 10562
TEST_TIME 37 10511
TEST_TIME 38 10495
TEST_TIME 39 10611
TEST_TIME 40 10733
TEST_TIME 41 10816
TEST_TIME 42 10676
TEST_TIME 43 10452
TEST_TIME 44 10268
TEST_TIME 45 10396
TEST_TIME 46 10417
TEST_TIME 47 10344
TEST_TIME 48 10514
TEST_TIME 49 10356
TEST_TIME 50 10285
TEST_TIME 51 10215
TEST_TIME 52 10284
TEST_TIME 53 10291
TEST_TIME 54 10297
TEST_TIME 55 10194
TEST_TIME 56 10207
TEST_TIME 57 10072
TEST_TIME 58 9927
TEST_TIME 59 9986
TEST_TIME 60 9928
TEST_TIME 61 9903
TEST_TIME 62 9833
TEST_TIME 63 9808
TEST_TIME 64 9747
TEST_TIME 65 9920
TEST_TIME 66 9911
TEST_TIME 67 9893
TEST_TIME 68 9922
TEST_TIME 69 9929
TEST_TIME 70 9959
TEST_TIME 71 10066
TEST_TIME 72 10011
TEST_TIME 73 9989
TEST_TIME 74 10085
TEST_TIME 75 10119
TEST_TIME 76 10142
TEST_TIME 77 10071
TEST_TIME 78 9968
TEST_TIME 79 9919
TEST_TIME 80 9958
TEST_TIME 81 9929
TEST_TIME 82 9860
TEST_TIME 83 9854
TEST_TIME 84 9816
TEST_TIME 85 9825
TEST_TIME 86 9773
TEST_TIME 87 9756
TEST_TIME 88 9789
TEST_TIME 89 9787
TEST_TIME 90 9792
TEST_TIME 91 9911
TEST_TIME 92 9888
TEST_TIME 93 9858
TEST_TIME 94 9868
TEST_TIME 95 9931
TEST_TIME 96 9962
TEST_TIME 97 9916
TEST_TIME 98 10015
TEST_TIME 99 9976
TEST_TIME 100 9995
TEST_TIME 101 9911
TEST_TIME 102 9885
TEST_TIME 103 9854
TEST_TIME 104 9866
TEST_TIME 105 9833
TEST_TIME 106 9808
TEST_TIME 107 9802
TEST_TIME 108 9772
TEST_TIME 109 9691
TEST_TIME 110 9675
TEST_TIME 111 9702
TEST_TIME 112 9710
TEST_TIME 113 9697
TEST_TIME 114 9668
TEST_TIME 115 9760
TEST_TIME 116 9821
TEST_TIME 117 9797
TEST_TIME 118 9758
TEST_TIME 119 9831
TEST_TIME 120 9755

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 11-01-2021 19:27:51 to 11-01-2021 19:27: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 1622024 1622024 0 0.00 0 23860 6 0 0
doc_list_biud 1622021 1622021 0 0.00 0 21863 25 0 0
sp_add_invoice_to_stock 5378 5300 78 1.45 28 142248 17026 0 78
sp_cancel_adding_invoice 6018 6018 0 0.00 5 50835 694 0 0
sp_cancel_client_order 1893 1893 0 0.00 4 10994 322 0 0
sp_cancel_customer_reserve 590300 590300 0 0.00 1 20788 54 0 0
sp_cancel_pay_from_customer 716 716 0 0.00 2 8064 102 0 0
sp_cancel_pay_to_supplier 454 454 0 0.00 3 4342 73 0 0
sp_cancel_supplier_invoice 6636 6631 5 0.07 1 16549 809 0 5
sp_cancel_supplier_order 424 424 0 0.00 5 1143356 97207 0 0
sp_cancel_write_off 11156 11156 0 0.00 1 10915 100 0 0
sp_client_order 21368 21368 0 0.00 4 13198 335 0 0
sp_customer_reserve 488336 488336 0 0.00 0 33700 169 0 0
sp_fill_shopping_cart 32976 32976 0 0.00 1 12317 38 0 0
sp_fill_shopping_cart_clo_res 488325 488325 0 0.00 0 16695 14 0 0
sp_get_clo_for_invoice 5288 5288 0 0.00 0 33058 307 0 0
sp_kill_cost_storno 18344 18344 0 0.00 0 6980 51 0 0
sp_kill_qstorno_ret_qs2qd 1198811 1198811 0 0.00 0 20785 30 0 0
sp_kill_qty_storno 632283 632283 0 0.00 0 21860 64 0 0
sp_lock_selected_doc 21909 21909 0 0.00 0 8503 6 0 0
sp_make_cost_storno 29577 29577 0 0.00 0 23852 48 0 0
sp_multiply_rows_for_pdistr 29576 29576 0 0.00 0 7488 29 0 0
sp_multiply_rows_for_qdistr 21368 21368 0 0.00 0 10443 160 0 0
sp_pay_from_customer 7462 7462 0 0.00 4 29684 108 0 0
sp_pay_to_supplier 6254 6254 0 0.00 5 23919 127 0 0
sp_payment_common 13715 13715 0 0.00 1 29665 29 0 0
sp_qd_handle_on_cancel_clo 1893 1893 0 0.00 0 10983 291 0 0
sp_qd_handle_on_invoice_upd_sts 11306 11306 0 0.00 0 21858 309 0 0
sp_qd_handle_on_reserve_upd_sts 10573 10573 0 0.00 0 16892 47 0 0
sp_reserve_write_off 10573 10573 0 0.00 6 16918 166 0 0
sp_supplier_invoice 5827 5827 0 0.00 6 95079 3259 0 0
sp_supplier_order 5787 5787 0 0.00 5 22272 1304 0 0
srv_aggregate_perf_data 110 110 0 0.00 2581 189339 17000 0 0
srv_fill_mon_cache_memory 173 173 0 0.00 1320 125293 30685 0 0
srv_find_qd_qs_mism 1119716 1119716 0 0.00 0 10426 5 0 0
srv_make_invnt_saldo 596 596 0 0.00 34 32281 996 0 0
srv_make_money_saldo 790 790 0 0.00 1 476 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 193126 463105 298398 0 0
t$perf-abend:sp_add_invoice_to_stock 78 78 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5300 5300 0 0.00 0 17251 152 0 0
t$perf-norm:sp_cancel_adding_invoice 406 406 0 0.00 0 7290 100 0 0
t$perf-norm:sp_cancel_client_order 1893 1893 0 0.00 0 5007 14 0 0
t$perf-norm:sp_cancel_customer_reserve 701 701 0 0.00 0 2644 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 716 716 0 0.00 0 3017 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 454 454 0 0.00 0 312 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 395 395 0 0.00 0 1230 18 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 21211 1551 0 0
t$perf-norm:sp_cancel_write_off 1060 1060 0 0.00 0 1234 6 0 0
t$perf-norm:sp_client_order 21368 21368 0 0.00 0 8729 18 0 0
t$perf-norm:sp_customer_reserve 1109 1109 0 0.00 0 5130 11 0 0
t$perf-norm:sp_pay_from_customer 7462 7462 0 0.00 0 5682 7 0 0
t$perf-norm:sp_pay_to_supplier 6254 6254 0 0.00 0 8872 12 0 0
t$perf-norm:sp_reserve_write_off 10573 10573 0 0.00 0 3954 9 0 0
t$perf-norm:sp_supplier_invoice 5827 5827 0 0.00 0 5532 18 0 0
t$perf-norm:sp_supplier_order 5787 5787 0 0.00 0 8809 15 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 155 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 696 12 0 0
t$perf-norm:srv_make_invnt_saldo 596 596 0 0.00 0 1320 20 0 0
t$perf-norm:srv_make_money_saldo 790 790 0 0.00 0 4134 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10730 10574 156 1.45 0 7691 22 0 156
v_all_customers 39134 39134 0 0.00 0 15 1 0 0
v_all_suppliers 32314 32314 0 0.00 0 17 1 0 0
v_all_wares 42736 42736 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 812 812 0 0.00 0 636 6 0 0
v_cancel_client_order 3786 3786 0 0.00 0 7688 8 0 0
v_cancel_customer_prepayment 1432 1432 0 0.00 0 4078 12 0 0
v_cancel_customer_reserve 1402 1402 0 0.00 0 2073 6 0 0
v_cancel_payment_to_supplier 908 908 0 0.00 0 1350 5 0 0
v_cancel_supplier_invoice 800 790 10 1.25 0 4291 30 0 10
v_cancel_supplier_order 848 848 0 0.00 0 2734 6 0 0
v_cancel_write_off 2120 2120 0 0.00 0 5651 15 0 0
v_max_id_clo_ord 5786 5786 0 0.00 0 234 1 0 0
v_max_id_clo_res 1109 1109 0 0.00 0 6550 23 0 0
v_max_id_ord_sup 5822 5822 0 0.00 0 3878 3 0 0
v_max_non_paid_invoice 1704 1704 0 0.00 0 127 2 0 0
v_max_non_paid_realizn 3914 3914 0 0.00 0 1119 3 0 0
v_min_id_clo_ord 5786 5786 0 0.00 0 5683 8 0 0
v_min_id_clo_res 1109 1109 0 0.00 0 9936 15 0 0
v_min_id_ord_sup 5822 5822 0 0.00 0 6928 8 0 0
v_min_non_paid_invoice 6253 6253 0 0.00 0 8408 21 0 0
v_min_non_paid_realizn 7462 7462 0 0.00 0 29662 22 0 0
v_our_firm 10698 10698 0 0.00 0 22 1 0 0
v_reserve_write_off 21146 21146 0 0.00 0 7158 7 0 0
x_lock_depdocs_on_canc_invoice 12254 12254 0 0.00 0 16034 100 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 3283 324 0 0
x_make_qstorno_1000_1200 5787 5787 0 0.00 1 22262 1227 0 0
x_make_qstorno_1200_2000 5827 5827 0 0.00 2 94507 3124 0 0
x_make_qstorno_2100_3300 488336 488336 0 0.00 0 28678 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-01-2021 19:27:56 to 11-01-2021 19:28: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
16:57:11 1 8192000000 8799327424 8810168320 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:17 19269 8192000000 10259645008 10566901760 958297824 10.472 75 66 131 2 982653312 2563600 21791888
16:57:47 28999 8192000000 10345281696 10659299328 1384810192 14.460 100 92 184 1 1419823472 4632208 30381072
16:58:29 28534 8192000000 10385661968 10708824064 1425834640 14.824 100 86 172 1 1460479632 6354000 28290992
16:59:04 13978 8192000000 10402054688 10727997440 1458667104 15.114 100 92 184 0 1495600880 7128704 29805072
16:59:29 15354 8192000000 10415983808 10746003456 1477425856 15.279 100 88 174 1 1513294320 7976576 27891888
16:59:55 23462 8192000000 10433794000 10766876672 1489797888 15.387 100 87 174 0 1526116224 8110832 28207504
17:00:30 21071 8192000000 10453575904 10789949440 1513231856 15.591 100 89 178 1 1550392704 8703568 28457280
17:01:01 25337 8192000000 10466362976 10814095360 1522276288 15.670 100 75 148 2 1554600656 9054640 23269728
17:01:36 12296 8192000000 10494819696 10847440896 1561981088 16.013 100 78 156 1 1595397472 9421392 23994992
17:01:59 13509 8192000000 10534301392 10886303744 1580225680 16.170 100 77 153 1 1612941056 9761456 22953920
17:02:24 10808 8192000000 10559817616 10918998016 1615260864 16.470 100 77 154 0 1648923120 10400912 23261344
17:02:44 14144 8192000000 10576482080 10937135104 1638961616 16.671 100 82 164 1 1673923360 10872304 24089440
17:03:08 11386 8192000000 10585609152 10949677056 1650359184 16.767 100 84 169 0 1686791760 11581040 24851536
17:03:26 6745 8192000000 10607569904 10972286976 1663650944 16.880 100 78 154 2 1698323536 11864816 22807776
17:03:44 7280 8192000000 10630250176 10998456320 1684809808 17.058 100 76 152 0 1719338480 12431472 22097200
17:04:01 10910 8192000000 10642523920 11021709312 1712558608 17.290 100 78 156 1 1747974240 12598896 22816736
17:04:20 8522 8192000000 10669730368 11042189312 1726253520 17.404 100 83 165 4 1763386880 13454064 23679296
17:04:40 4977 8192000000 10674331584 11056369664 1744736320 17.558 100 77 155 2 1778998624 12363824 21898480
17:04:52 3952 8192000000 10696572832 11073966080 1758583968 17.673 100 77 152 1 1792639728 12441952 21613808
17:05:02 4758 8192000000 10707914048 11086401536 1768577536 17.755 100 75 149 2 1801997504 12633216 20786752
17:05:14 4809 8192000000 10711844352 11093516288 1776514032 17.821 100 82 160 2 1812973760 13272528 23187200
17:05:27 4782 8192000000 10717069008 11104710656 1785253072 17.893 100 84 167 1 1820700416 12587696 22859648
17:05:38 2926 8192000000 10731996864 11114934272 1790929728 17.939 100 84 168 1 1827941648 13588448 23423472
17:05:48 3504 8192000000 10734817488 11114958848 1794328672 17.967 100 79 155 1 1829325776 13754800 21242304
17:05:58 1915 8192000000 10743226400 11128098816 1802711312 18.036 100 80 159 0 1838614960 14456560 21447088
17:06:07 2304 8192000000 10749877920 11134193664 1808519392 18.084 100 85 170 1 1847142448 14346976 24276080
17:06:16 2140 8192000000 10746829184 11132690432 1810861328 18.103 100 84 166 5 1848116000 13400880 23853792
17:06:25 8482 8192000000 10743764448 11133771776 1817169136 18.155 100 77 154 0 1851646000 12610144 21866720
17:06:40 4360 8192000000 10762153520 11152404480 1819701696 18.175 100 77 154 1 1853443440 12337760 21403984
17:06:51 1521 8192000000 10771709024 11160027136 1831255072 18.270 100 83 166 1 1866460736 12238832 22966832
17:06:59 2166 8192000000 10773331008 11164667904 1838236400 18.326 100 81 160 2 1872941728 12132208 22573120
17:07:08 2439 8192000000 10786634016 11173863424 1844074848 18.374 100 90 180 1 1884165120 14087680 26002592
17:07:17 1441 8192000000 10795835680 11182637056 1849997936 18.422 100 87 173 4 1888597920 13374512 25225472
17:07:24 1668 8192000000 10802031712 11191005184 1856630480 18.476 100 95 188 0 1896704640 13737536 26336624
17:07:32 1647 8192000000 10803034960 11190878208 1856906048 18.478 100 88 178 0 1895452592 12690704 25855840
17:07:41 1613 8192000000 10804581072 11189411840 1862088256 18.520 100 91 182 4 1898062272 11221472 24752544
17:07:48 1274 8192000000 10813841968 11203219456 1870021824 18.584 100 98 198 1 1911319840 13202176 28095840
17:07:56 1780 8192000000 10813440080 11204870144 1874501776 18.621 100 86 172 1 1911621904 13475792 23644336
17:08:04 1431 8192000000 10820237296 11213316096 1878389008 18.652 100 91 181 1 1916759680 13596160 24774512
17:08:12 21629 8192000000 10801434736 11208667136 1872687056 18.606 100 65 130 1 1904317488 13300288 18330144
17:08:58 1731 8192000000 10823451680 11219701760 1881616048 18.678 100 88 175 1 1917148704 10055616 25477040
17:09:08 7357 8192000000 10799327344 11215499264 1878037488 18.649 100 48 97 0 1901522224 9756240 13728496
17:09:22 6118 8192000000 10788685840 11215597568 1877831616 18.648 100 32 65 0 1894429712 7380544 9217552
17:09:35 5299 8192000000 10792508656 11217547264 1883915536 18.697 100 42 83 2 1901250320 5984368 11350416
17:09:48 6405 8192000000 10794731168 11226103808 1882078656 18.682 100 27 52 1 1900397504 11092832 7226016
17:10:01 4699 8192000000 10802168960 11226173440 1889210576 18.739 100 39 78 1 1908151008 7468720 11471712
17:10:14 5947 8192000000 10801882896 11228209152 1886545360 18.718 100 23 46 0 1899404800 6454784 6404656
17:10:29 9452 8192000000 10788576208 11227152384 1889212864 18.739 100 30 60 1 1904666432 6992096 8461472
17:10:44 12501 8192000000 10793049616 11227832320 1888248048 18.732 100 22 44 0 1901016272 6476096 6292128
17:11:05 10076 8192000000 10802609584 11230236672 1893284672 18.772 100 23 46 0 1906445696 6818912 6342112
17:11:21 67673 8192000000 10806066464 11240169472 1894215632 18.780 100 30 60 0 1909545008 6920432 8408944
17:12:37 7683 8192000000 10811200704 11242004480 1896573664 18.799 100 20 40 1 1909533088 6640624 6318800
17:12:51 6541 8192000000 10818827072 11247661056 1899975200 18.826 100 31 63 0 1915819520 7461952 8382368
17:13:03 5525 8192000000 10831552928 11257278464 1901740992 18.840 100 33 67 0 1917609312 7241456 8626864
17:13:17 6826 8192000000 10822161296 11256377344 1906341632 18.877 100 36 73 0 1924698400 8694176 9662592
17:13:30 6451 8192000000 10837028672 11252727808 1905669552 18.872 100 32 64 0 1922350896 7725536 8955808
17:13:43 5393 8192000000 10824428224 11259891712 1906120128 18.875 100 27 56 0 1924743264 10801008 7822128
17:13:59 5896 8192000000 10818721552 11256893440 1907586928 18.887 100 27 54 1 1922531888 6941712 8003248
17:14:11 7712 8192000000 10819562368 11257204736 1907995520 18.891 100 23 46 2 1920617376 6059968 6561888
17:14:27 6654 8192000000 10835030960 11261812736 1912098528 18.923 100 24 47 2 1924409568 6254512 6056528
17:14:43 6258 8192000000 10832765008 11262480384 1918789200 18.977 100 27 54 2 1932698816 5005456 8904160
17:14:56 11487 8192000000 10829012416 11268747264 1919652192 18.984 100 25 50 1 1932501760 5778032 7071536
17:15:17 11933 8192000000 10823018832 11266514944 1916421840 18.958 100 18 35 1 1927368320 6012752 4933728
17:15:36 12102 8192000000 10815957584 11253047296 1873120432 18.610 98 18 37 0 1887668416 9482384 5065600
17:15:58 67558 8192000000 10845108704 11258548224 1893463088 18.774 99 29 58 0 1907629952 5540688 8626176
17:17:11 7341 8192000000 10811179264 11241439232 1892161808 18.763 100 25 50 1 1906198208 7100304 6936096
17:17:28 9422 8192000000 10792802336 11222880256 1840703472 18.347 97 28 55 1 1855409184 6723520 7982192
17:17:45 8132 8192000000 10801495152 11232829440 1876534512 18.637 99 29 58 0 1890856176 5979952 8341712
17:17:59 5403 8192000000 10797539168 11230433280 1886179776 18.715 100 30 60 1 1901140640 6127488 8833376
17:18:11 6547 8192000000 10761804816 11195260928 1843125712 18.366 99 24 47 2 1855726768 6120000 6481056
17:18:25 8559 8192000000 10778309552 11215781888 1867821152 18.567 100 19 38 1 1879073136 6100528 5151456
17:18:42 4983 8192000000 10756882736 11176620032 1815908384 18.144 98 30 60 3 1830591248 6228944 8453920
17:18:55 8200 8192000000 10751106784 11177009152 1825820176 18.225 99 20 40 1 1836922192 5760240 5341776
17:19:10 7510 8192000000 10745348688 11165167616 1793456432 17.960 98 12 25 2 1802338032 5453024 3428576
17:19:24 7955 8192000000 10727013360 11150643200 1790661648 17.937 98 18 36 1 1802185136 6045600 5477888
17:19:38 8897 8192000000 10706754688 11127271424 1771929312 17.783 97 24 49 3 1785113808 5621776 7562720
17:19:54 7397 8192000000 10709231520 11125788672 1782828496 17.873 99 20 39 0 1793995424 5135424 6031504
17:20:14 8192 8192000000 10712030128 11130126336 1739101264 17.511 96 18 35 2 1749586096 5620720 4864112
17:20:29 74886 8192000000 10699975488 11124047872 1684738528 17.057 93 21 42 3 1695553296 4847968 5966800
17:21:50 10782 8192000000 10703894304 11130605568 1781608128 17.863 99 26 51 1 1794499008 5629120 7261760
17:22:07 7893 8192000000 10691930768 11108261888 1745050656 17.561 97 17 34 2 1754772800 4736848 4985296
17:22:21 5836 8192000000 10720640480 11136671744 1791627872 17.945 99 35 69 4 1809323136 8340688 9354576
17:22:33 6738 8192000000 10720924144 11132612608 1770003376 17.767 98 34 66 2 1785905488 5951552 9950560
17:22:48 7361 8192000000 10721249248 11141275648 1805506336 18.059 100 22 42 1 1817570928 5692592 6372000
17:23:03 6931 8192000000 10728271840 11149266944 1815527584 18.141 100 21 42 2 1827431552 5693536 6210432
17:23:19 5085 8192000000 10735356432 11155738624 1813095984 18.121 100 29 57 1 1827266624 6775312 7395328
17:23:30 10034 8192000000 10730034624 11153915904 1820607248 18.183 100 26 50 1 1834014960 5831312 7576400
17:23:48 8566 8192000000 10736014672 11155410944 1805662928 18.060 99 24 48 1 1818341776 5405296 7273552
17:24:05 9865 8192000000 10747640224 11162017792 1825881456 18.226 100 20 40 1 1837880704 5151808 6847440
17:24:27 11232 8192000000 10750069088 11174424576 1833355216 18.287 100 22 44 4 1845324560 5321888 6647456
17:24:44 7762 8192000000 10752095008 11175890944 1837754144 18.323 100 22 44 2 1850593776 6429744 6409888
17:25:00 9180 8192000000 10761216656 11186020352 1841301648 18.351 100 12 24 1 1850187504 5639408 3246448
17:25:15 47141 8192000000 10786679376 11192422400 1854056544 18.455 100 41 82 0 1872485232 5180928 13247760
17:26:16 33677 8192000000 10778414288 11203166208 1859414048 18.499 100 28 56 0 1872586176 5928640 7243488
17:26:57 9999 8192000000 10785850144 11211018240 1865352992 18.547 100 23 46 1 1878371872 6793536 6225344
17:27:26 4533 8192000000 10831324432 11244212224 1898474064 18.814 100 60 119 2 1923797408 6859360 18463984
17:27:42 44593 8192000000 10832024112 11253424128 1905321120 18.869 100 52 103 2 1928455840 8457200 14677520
17:28:35 29199 8192000000 10842990352 11262484480 1911316848 18.917 100 48 96 1 1936132544 11508336 13307360
17:29:18 15039 8192000000 10848265120 11269562368 1916168720 18.956 100 40 80 3 1938079344 10937936 10972688
17:29:41 12789 8192000000 10866842640 11293925376 1932651008 19.088 100 42 84 1 1959969904 15098208 12220688
17:30:02 29338 8192000000 10867473120 11299545088 1937198896 19.124 100 40 80 1 1962012512 13231712 11581904
17:30:42 17957 8192000000 10879074448 11308068864 1943666512 19.176 100 42 84 0 1970279664 14579712 12033440
17:31:10 13873 8192000000 10884178208 11310919680 1948610832 19.215 100 49 97 1 1978513456 16244752 13657872
17:31:33 7379 8192000000 10894733424 11320934400 1954322992 19.261 100 52 102 1 1985454336 16092928 15038416
17:31:50 4726 8192000000 10906548320 11330117632 1958961680 19.298 100 59 118 1 1993720496 17159600 17599216
17:32:04 22000 8192000000 10911912320 11332001792 1960571072 19.311 100 61 119 2 1994446160 17092032 16783056
17:32:34 7750 8192000000 10901093712 11328000000 1946983968 19.202 99 67 132 0 1985806368 19984112 18838288
17:32:54 30667 8192000000 10905462496 11342237696 1960621568 19.311 100 52 104 2 2000114336 23944576 15548192
17:33:44 23130 8192000000 10894406896 11327397888 1942287632 19.165 99 43 86 2 1976044544 20320432 13436480
17:34:19 5344 8192000000 10903304784 11333632000 1958744704 19.296 100 49 96 0 1995366704 22137392 14484608
17:34:33 2707 8192000000 10918058272 11342495744 1963928624 19.337 100 56 112 1 2005279504 25160528 16190352
17:34:45 15267 8192000000 10932827184 11346145280 1972200336 19.403 100 62 124 3 2013698432 22795936 18702160
17:35:08 3128 8192000000 10929947152 11345989632 1967605664 19.366 100 65 130 2 2010771040 23633728 19531648
17:35:21 11509 8192000000 10918496784 11346767872 1967770704 19.368 100 49 98 1 2007481248 24755280 14955264
17:35:39 7639 8192000000 10934275488 11354611712 1977079632 19.442 100 75 150 2 2024551760 25034032 22438096
17:35:59 18193 8192000000 10939465328 11363876864 1979734096 19.463 100 64 129 3 2022940912 24698912 18507904
17:36:32 3610 8192000000 10928859280 11345203200 1961465584 19.318 99 57 112 1 2001776272 24059120 16251568
17:36:43 2415 8192000000 10940183200 11350114304 1978069440 19.449 100 70 139 1 2023310560 24827408 20413712
17:36:52 3197 8192000000 10935990528 11363426304 1980618096 19.470 100 66 132 0 2025840512 25842096 19380320
17:37:02 8925 8192000000 10937973552 11367895040 1982841312 19.487 100 62 124 0 2031925088 30995872 18087904
17:37:18 6867 8192000000 10942863968 11363713024 1982713904 19.486 100 69 138 0 2029497120 26323264 20459952
17:37:33 4766 8192000000 10942671664 11368456192 1985009936 19.504 100 57 114 0 2029819040 26531984 18277120
17:37:47 20468 8192000000 10929700560 11368706048 1970587232 19.390 99 59 118 1 2016067472 27188688 18291552
17:38:37 13294 8192000000 10917846528 11347120128 1948951280 19.218 98 57 114 1 1993909680 27311456 17646944
17:39:06 4930 8192000000 10932675968 11361820672 1962357024 19.325 99 53 104 1 2007467696 29551296 15559376
17:39:20 3479 8192000000 10956805184 11374120960 1984345664 19.499 100 76 151 0 2039341632 31586368 23409600
17:39:35 6678 8192000000 10960381808 11381981184 1990735008 19.550 100 74 146 2 2047293088 34417968 22140112
17:39:50 3249 8192000000 10973860592 11389898752 1994800816 19.582 100 73 146 1 2052280032 35112896 22366320
17:40:03 1319 8192000000 10978845520 11394908160 1995981232 19.591 100 83 166 2 2058037680 36285424 25771024
17:40:11 1850 8192000000 10974083504 11385319424 1982787024 19.487 99 88 177 0 2043654688 34349664 26518000
17:40:20 3252 8192000000 10951073696 11370008576 1975193392 19.427 99 73 146 1 2030499472 33313296 21992784
17:40:31 2501 8192000000 10976514480 11389829120 1994697008 19.581 100 82 162 2 2051667440 33458816 23511616
17:40:42 3056 8192000000 10960111968 11373441024 1981499536 19.477 99 79 156 0 2038098464 33825712 22773216
17:40:52 3755 8192000000 10979757952 11391385600 1994056720 19.576 100 83 164 0 2054647136 35775376 24815040
17:41:04 3142 8192000000 10972934384 11389517824 1991701616 19.557 100 87 174 1 2054582688 36284096 26596976
17:41:13 2678 8192000000 10964642720 11380342784 1987648928 19.525 100 84 167 3 2049291136 36610896 25031312
17:41:23 4788 8192000000 10965443120 11383488512 1986907696 19.519 100 86 172 0 2049446208 35904544 26633968
17:41:35 3057 8192000000 10971706144 11388289024 1990133552 19.545 100 82 163 1 2052194976 37389200 24672224
17:41:46 4688 8192000000 10975758480 11397902336 1998953264 19.614 100 76 153 0 2060268592 37906544 23408784
17:41:58 5458 8192000000 10974500176 11404066816 2003684704 19.652 100 67 134 1 2063372128 38548160 21139264
17:42:21 3791 8192000000 10972996528 11401854976 1987823504 19.527 99 58 116 1 2046231376 39504976 18902896
17:42:33 3902 8192000000 10980838800 11404599296 1998578928 19.612 100 71 143 1 2061376864 39903424 22894512
17:42:44 3226 8192000000 10981487424 11404263424 1988008832 19.528 99 83 166 0 2055161856 41112112 26040912
17:43:01 1923 8192000000 10985363136 11409924096 2010427904 19.705 100 86 171 2 2074460688 37338048 26694736
17:43:10 4376 8192000000 10991070400 11408433152 2005865136 19.669 100 76 148 0 2066908832 37584576 23459120
17:43:27 4113 8192000000 10988903760 11418517504 2012127680 19.718 100 66 132 1 2070921520 37586784 21207056
17:43:43 5454 8192000000 10989316256 11413200896 2012665616 19.722 100 70 140 3 2070054464 35664032 21724816
17:43:55 2831 8192000000 10974183280 11394494464 1991314064 19.554 100 77 154 1 2053917232 38480960 24122208
17:44:05 4284 8192000000 10974622880 11396714496 1991942032 19.559 100 79 157 1 2057118816 40043360 25133424
17:44:16 3601 8192000000 10978827392 11392671744 1991776208 19.558 100 83 165 0 2057334144 39650128 25907808
17:44:26 3635 8192000000 10976063936 11396243456 1994979648 19.583 100 79 158 2 2059276368 39331136 24965584
17:44:37 3413 8192000000 10975208096 11395424256 1994690928 19.581 100 83 167 1 2061379632 39376880 27311824
17:44:49 2410 8192000000 10994760208 11405418496 2000846448 19.629 100 92 182 2 2070837872 41330016 28661408
17:44:58 2786 8192000000 10995903856 11406831616 1992699184 19.565 99 88 174 2 2060895904 42375968 25820752
17:45:07 2022 8192000000 10969797872 11391033344 1974939344 19.425 99 82 162 1 2042076400 42050832 25086224
17:45:19 15386 8192000000 10942286128 11380314112 1980753504 19.471 100 45 89 2 2032260720 36628848 14878368
17:45:42 8738 8192000000 10942568256 11382710272 1985591232 19.509 100 42 84 1 2030697744 31547264 13559248
17:46:00 16897 8192000000 10932281056 11368964096 1959292928 19.300 99 45 90 1 2006758336 32937904 14527504
17:46:24 10185 8192000000 10937397168 11371982848 1958583248 19.295 99 41 84 0 2005412688 33131360 13698080
17:46:55 8284 8192000000 10938767312 11371880448 1970936928 19.393 100 41 81 2 2020120048 35654720 13528400
17:47:12 4978 8192000000 10936903456 11366305792 1951376448 19.237 99 58 118 2 2005381936 35714144 18291344
17:47:25 3029 8192000000 10933940480 11356893184 1958800256 19.297 100 69 139 1 2018953184 38433808 21719120
17:47:38 13371 8192000000 10921521872 11357376512 1948689584 19.216 100 45 90 1 2001640096 38329008 14621504
17:48:11 6445 8192000000 10932500192 11367194624 1960607648 19.311 100 42 84 1 2014554304 39895968 14050688
17:48:33 8217 8192000000 10913351328 11351166976 1945816096 19.193 99 42 84 4 1999257616 39275440 14166080
17:48:50 18226 8192000000 10927658736 11359916032 1944353488 19.181 99 43 84 2 2003848912 45690288 13805136
17:49:16 12344 8192000000 10918381008 11361964032 1942176560 19.164 99 37 74 1 1998810464 43318688 13315216
17:49:50 12587 8192000000 10914877504 11347300352 1924792672 19.025 99 39 78 3 1985054736 46179872 14082192
17:50:11 12539 8192000000 10921344496 11360485376 1944498416 19.183 100 38 76 2 2007685488 49230528 13956544
17:50:37 8839 8192000000 10937814640 11367866368 1947372848 19.206 100 38 76 2 2013337760 51301792 14663120
17:50:54 7044 8192000000 10937713168 11373813760 1950416336 19.230 100 50 97 2 2022006784 55029936 16560512
17:51:21 7769 8192000000 10919926128 11360292864 1932296608 19.085 100 38 76 0 1998976768 53298000 13382160
17:51:36 9504 8192000000 10925548864 11366707200 1936545872 19.119 100 39 77 1 2006759296 55678256 14535168
17:51:53 4952 8192000000 10922521584 11356827648 1928771904 19.057 100 33 64 0 1995750720 55763824 11214992
17:52:07 4517 8192000000 10924760944 11354841088 1943222864 19.172 100 50 100 0 2004084720 44149520 16712336
17:52:19 5744 8192000000 10882108624 11307720704 1868194240 18.570 96 48 96 1 1928792160 44557552 16040368
17:52:31 14053 8192000000 10904605824 11345612800 1935664368 19.112 100 43 86 2 2001736192 51370384 14701440
17:53:08 29017 8192000000 10875147728 11327557632 1917690640 18.968 99 25 50 3 1961514352 35600912 8222800
17:53:43 23774 8192000000 10876671008 11317747712 1896556160 18.799 99 18 36 1 1936755248 33376096 6822992
17:54:19 29077 8192000000 10890531952 11326709760 1918892800 18.978 100 36 72 0 1966951968 36828656 11230512
17:54:55 28798 8192000000 10866333216 11327213568 1902887664 18.850 99 18 36 1 1938863136 30532944 5442528
17:55:30 18445 8192000000 10858275696 11309088768 1896691728 18.800 99 14 28 1 1930613088 29328896 4592464
17:56:00 16827 8192000000 10853859488 11302195200 1893786896 18.776 99 28 57 0 1928691632 26249104 8655632
17:56:26 20344 8192000000 10837974816 11300106240 1900334448 18.829 100 11 22 1 1929257616 25411168 3512000
17:56:59 44034 8192000000 10846966976 11326746624 1886691824 18.719 99 6 12 0 1916570992 27694784 2184384
17:57:53 105485 8192000000 10869735952 11318435840 1907434288 18.886 99 14 28 1 1926078928 14516576 4128064
17:59:52 125293 8192000000 10868084080 11323195392 1863529280 18.532 96 11 22 0 1882522192 16451120 2541792
18:02:04 51509 8192000000 10882851584 11342450688 1940927184 19.154 100 8 15 2 1957259328 14377744 1954400
18:03:01 66826 8192000000 10875943872 11338706944 1888436176 18.733 97 6 10 1 1905999168 16004560 1558432
18:04:19 99669 8192000000 10894053952 11354955776 1920207024 18.989 98 12 24 1 1940570720 17004768 3358928
18:06:17 78761 8192000000 10907020992 11376836608 1923417040 19.014 98 11 22 1 1954507328 27641168 3449120
18:08:15 95194 8192000000 10893898272 11354165248 1942038800 19.163 99 15 30 2 1965493968 19606080 3849088
18:09:56 85192 8192000000 10930125888 11375849472 1978920064 19.456 100 37 74 0 1998521216 9210176 10390976
18:11:32 78430 8192000000 10915499360 11382091776 1959277920 19.300 99 31 61 5 1980298320 11889088 9131312
18:12:59 69974 8192000000 10913391072 11367223296 1957731952 19.288 99 13 26 0 1969382624 8160096 3490576
18:14:15 32708 8192000000 10925329392 11382489088 1988164736 19.529 100 51 103 3 2013603936 10374176 15065024
18:14:59 48491 8192000000 10925291696 11383726080 1972899216 19.408 99 44 88 1 1999252704 13164752 13188736
18:15:59 77476 8192000000 10895481792 11366338560 1944728880 19.184 98 14 28 0 1958177408 8921552 4526976
18:17:23 9638 8192000000 10901945104 11364397056 1957837136 19.289 99 23 45 1 1973266048 9172048 6256864
18:17:39 48150 8192000000 10894234192 11359961088 1919109088 18.980 97 20 40 0 1932267664 7483712 5674864
18:18:35 50894 8192000000 10905555216 11379916800 1974341456 19.420 100 21 42 3 1992405648 10693136 7371056
18:19:35 8631 8192000000 10920531408 11370110976 1970355792 19.388 100 43 83 3 1994005408 11776032 11873584
18:19:50 11275 8192000000 10925646640 11359944704 1970186352 19.387 100 62 120 5 1995537584 8526768 16824464
18:20:11 30574 8192000000 10912072064 11370754048 1958818080 19.297 99 45 90 1 1983523952 11651088 13054784
18:20:49 60907 8192000000 10875123600 11363139584 1949773904 19.225 99 15 30 0 1971221600 16983616 4464080
18:21:56 19547 8192000000 10881588896 11356311552 1953935568 19.258 99 15 30 2 1970578832 11849040 4794224
18:22:29 19394 8192000000 10902027776 11373969408 1971945008 19.401 100 20 41 0 1989188944 11890176 5353760
18:22:54 18554 8192000000 10891948864 11363106816 1950976576 19.234 99 12 24 1 1965583072 11395936 3210560
18:23:25 44014 8192000000 10882305040 11365281792 1951180416 19.236 99 8 14 1 1963457584 10212144 2065024
18:24:20 20803 8192000000 10883145776 11371782144 1967660912 19.367 100 7 14 0 1977774768 8067712 2046144
18:24:52 73610 8192000000 10907281168 11376267264 1964182560 19.339 99 37 74 1 1983407568 8514256 10710752
18:26:32 53799 8192000000 10896984144 11354349568 1967298560 19.364 99 27 54 3 1981184320 6844176 7041584
18:27:32 26569 8192000000 10889940880 11367710720 1960888672 19.313 99 32 64 3 1977724112 7820336 9015104
18:28:12 44846 8192000000 10893264752 11373608960 1967980000 19.369 99 14 28 3 1979172720 7007040 4185680
18:29:04 77510 8192000000 10895467280 11377152000 1952128896 19.243 98 18 36 0 1965040256 7870112 5041248
18:30:30 59826 8192000000 10906447024 11389345792 1970301840 19.388 99 9 18 0 1986432992 13754032 2377120
18:31:36 42032 8192000000 10898211168 11374911488 1945555136 19.191 98 17 34 3 1968012336 17088224 5368976
18:32:27 44436 8192000000 10892397680 11373903872 1922129216 19.004 97 8 16 0 1935743024 11679904 1933904
18:33:26 30410 8192000000 10904588704 11364364288 1936555184 19.119 98 31 61 2 1957067216 10557664 9954368
18:34:08 64166 8192000000 10903601680 11370328064 1945514192 19.191 98 24 48 0 1961180960 9057312 6609456
18:35:20 25515 8192000000 10885543360 11355656192 1933998368 19.099 98 27 53 2 1950508432 9334688 7175376
18:35:54 20610 8192000000 10878656528 11322769408 1902338912 18.845 97 39 76 3 1921330304 7959792 11031600
18:36:23 24557 8192000000 10891963568 11357552640 1956747232 19.280 100 32 64 0 1979169728 13208608 9213888
18:36:55 59406 8192000000 10864936144 11341836288 1861605584 18.516 95 13 26 0 1880324880 14890176 3829120
18:38:01 46767 8192000000 10871145680 11334619136 1889687200 18.743 97 20 41 0 1915397200 19973216 5736784
18:39:00 60315 8192000000 10857680512 11317878784 1838212256 18.326 94 11 22 1 1851650608 10345472 3092880
18:40:06 38652 8192000000 10864485792 11312967680 1889097376 18.739 97 34 68 0 1909944832 11332336 9515120
18:40:53 75539 8192000000 10846200720 11305906176 1816757536 18.151 94 8 16 1 1831747216 12419152 2570528
18:42:17 49131 8192000000 10850500720 11309031424 1858489120 18.491 97 26 52 0 1882411328 16352704 7569504
18:43:22 39058 8192000000 10840039008 11289350144 1813280656 18.123 94 17 34 1 1826894288 8852768 4760864
18:45:10 120719 8192000000 10845433488 11315986432 1877948688 18.649 98 24 48 0 1901526176 16708800 6868688
18:47:24 62215 8192000000 10848863968 11323113472 1911633520 18.920 99 21 42 1 1929157936 10931392 6593024
18:48:33 67014 8192000000 10846533872 11325407232 1914307248 18.941 99 9 18 1 1929339344 12500800 2531296
18:49:46 42453 8192000000 10849592416 11325808640 1915322000 18.949 99 12 21 3 1927446080 9297664 2826416
18:50:43 31093 8192000000 10871624800 11334684672 1929229040 19.061 99 22 44 1 1943959056 7812496 6917520
18:51:25 54130 8192000000 10843084928 11325255680 1909529840 18.903 98 11 22 0 1921225504 8413328 3282336
18:52:25 101403 8192000000 10864369840 11352342528 1918962000 18.979 99 8 16 1 1933575344 12251024 2362320
18:54:16 85777 8192000000 10885971856 11365892096 1947567488 19.207 100 10 20 0 1961934208 11431872 2934848
18:56:04 72899 8192000000 10909098304 11380723712 1954937424 19.266 99 19 38 1 1979951216 19282608 5731184
18:57:34 73611 8192000000 10884972384 11361304576 1911618288 18.920 97 16 32 0 1930143168 14086048 4438832
18:59:04 76270 8192000000 10906707760 11364552704 1916623536 18.960 97 21 40 0 1929032992 6642576 5766880
19:00:27 38464 8192000000 10908058080 11363250176 1953063520 19.251 99 31 62 1 1971587696 10213616 8310560
19:01:13 39811 8192000000 10908379312 11366887424 1958823040 19.297 99 30 58 2 1975694928 8580176 8291712
19:02:01 45673 8192000000 10913233792 11390111744 1962921808 19.329 99 20 40 1 1982638416 14135344 5581264
19:02:55 68705 8192000000 10922614688 11364241408 1917245712 18.965 97 13 26 0 1935392384 14298576 3848096
19:04:14 23467 8192000000 10911102816 11368652800 1955448000 19.270 99 34 68 2 1975764672 11151824 9164848
19:04:50 86250 8192000000 10884157840 11363426304 1903354336 18.853 97 13 25 0 1920665920 14033872 3277712
19:06:23 23718 8192000000 10899938128 11359408128 1962732416 19.328 100 15 28 1 1975848480 9356080 3759984
19:06:57 17790 8192000000 10915499568 11361435648 1953652960 19.256 99 53 105 0 1978374208 10665040 14056208
19:07:24 53152 8192000000 10875590448 11346251776 1952074864 19.243 99 32 64 0 1972235248 11517520 8642864
19:08:37 95771 8192000000 10913403088 11371524096 1937418976 19.126 98 25 50 2 1952104032 7885104 6799952
19:10:46 34120 8192000000 10884708992 11360624640 1951086080 19.235 99 20 40 0 1968473936 12027088 5360768
19:11:26 29410 8192000000 10900857824 11376734208 1971720256 19.399 100 26 52 0 1992747120 14145104 6881760
19:12:19 53096 8192000000 10885603376 11363676160 1935658176 19.112 98 9 18 0 1945909472 7357104 2894192
19:13:19 54185 8192000000 10858978112 11336265728 1915749120 18.953 98 9 19 1 1925506288 7279088 2478080
19:14:22 35230 8192000000 10857514864 11328024576 1894316880 18.781 97 12 24 0 1905434896 7425616 3692400
19:15:19 73331 8192000000 10883052288 11355111424 1942113616 19.164 99 13 26 0 1955226096 9272752 3839728
19:17:05 67796 8192000000 10866608272 11348545536 1931056800 19.075 99 8 16 0 1946026624 12500544 2469280
19:18:19 57060 8192000000 10856513824 11338055680 1900479232 18.830 98 13 26 0 1915114096 11163888 3470976
19:19:22 28278 8192000000 10868747424 11323138048 1879792080 18.663 97 16 32 0 1889726000 5767504 4166416
19:20:01 51017 8192000000 10879980864 11345768448 1917290848 18.965 98 23 46 1 1937559024 13730240 6537936
19:21:00 36438 8192000000 10880943920 11345432576 1902647632 18.848 97 26 52 3 1927550000 17811440 7090928
19:21:44 33378 8192000000 10882754288 11356540928 1919468704 18.983 98 27 53 3 1948226208 20679344 8078160
19:22:24 64485 8192000000 10878808704 11363758080 1906891152 18.882 98 10 20 3 1932488864 22341200 3256512
19:23:46 50928 8192000000 10869228800 11330039808 1904729808 18.864 98 12 24 0 1918263824 9825920 3708096
19:24:43 47586 8192000000 10862968928 11317690368 1856279552 18.473 95 30 60 2 1876045696 11346768 8419376
19:25:42 29658 8192000000 10870405088 11307999232 1886185760 18.715 98 48 96 1 1913662208 13050384 14426064
19:26:22 43789 8192000000 10834188592 11309154304 1892370768 18.765 99 23 46 0 1913717120 14207696 7138656

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 11-01-2021 19:28:02 to 11-01-2021 19:28:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 78 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-01-2021 19:28:35 to 11-01-2021 19:28:37.

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          245436
MON$OLDEST_ACTIVE               245925
MON$OLDEST_SNAPSHOT             245925
MON$NEXT_TRANSACTION            245925
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                       2048032
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:695: 
:696: mscs-test-161.budzdorov.ru    Mon Jan 11 19:27:14 2021
:697:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:698: 
:699: 
:700: mscs-test-161.budzdorov.ru    Mon Jan 11 19:27:15 2021
:701:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:702: 
:703: 
:704: mscs-test-161.budzdorov.ru    Mon Jan 11 19:27:15 2021
:705:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:706: 
:707: 
:708: mscs-test-161.budzdorov.ru    Mon Jan 11 19:27:15 2021
:709:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:710: 
:711: 
:712: mscs-test-161.budzdorov.ru    Mon Jan 11 19:27:15 2021
:713:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:714: 
:715: 
:716: mscs-test-161.budzdorov.ru    Mon Jan 11 19:27:15 2021
:717:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:718: 
:719: 
:720: mscs-test-161.budzdorov.ru    Mon Jan 11 19:27:15 2021
:721:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:722: 
:723: 
:724: mscs-test-161.budzdorov.ru    Mon Jan 11 19:27:15 2021
:725:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:726: 
:727: 
:728: mscs-test-161.budzdorov.ru    Mon Jan 11 19:27:15 2021
:729:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:730: 
--- end of diff output ---

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

11.01.21 19:28:38. 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-11 19:28:40 No severe PSQL-related problems occured
11.01.21 19:28:41. End of report.