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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-11 16:32:51
DTS_END                         2021-03-11 16:32:51.7620
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_MAKE_INVNT_SALDO(40:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55550
TRN_ID                          244660
ATT_ID                          729
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: 8949.72 20762 1073966
customer order: creation 179.19 366 21503
customer order: refuse 14.56 335 1747
order to supplier: creation 48.17 1351 5780
order to supplier: removal 3.32 107909 398
invoice (draft): creation 47.79 3738 5735
invoice (draft): removal 50.25 843 6030
invoice accept: apply 42.61 19268 5113
invoice accept: cancel 44.73 845 5368
customer reserve: creation 3856.87 193 462824
customer reserve: removal 4366.93 64 524032
realization accept: apply 87.92 169 10550
realization accept: cancel 74.13 117 8895
payment from customer: creation 60.97 123 7316
payment from customer: removal 5.84 124 701
payment to supplier: creation 50.03 115 6003
payment to supplier: removal 3.54 83 425
service: total inventory turnovers 4.89 1173 587
service: total monetary turnovers 7.10 30 852
service: aggregate perf. data 0.86 20826 103
service: refresh index statistics 0.03 257571 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-03-2021 16:35:14 to 11-03-2021 16:35:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4925
TEST_TIME 2 5699
TEST_TIME 3 5119
TEST_TIME 4 6125
TEST_TIME 5 6014
TEST_TIME 6 5657
TEST_TIME 7 5437
TEST_TIME 8 5407
TEST_TIME 9 5565
TEST_TIME 10 5925
TEST_TIME 11 5974
TEST_TIME 12 6022
TEST_TIME 13 6147
TEST_TIME 14 6391
TEST_TIME 15 6386
TEST_TIME 16 6964
TEST_TIME 17 6926
TEST_TIME 18 7383
TEST_TIME 19 7457
TEST_TIME 20 7819
TEST_TIME 21 8088
TEST_TIME 22 8214
TEST_TIME 23 9018
TEST_TIME 24 9138
TEST_TIME 25 9153
TEST_TIME 26 9312
TEST_TIME 27 9463
TEST_TIME 28 9768
TEST_TIME 29 9878
TEST_TIME 30 10829
TEST_TIME 31 10581
TEST_TIME 32 10424
TEST_TIME 33 10277
TEST_TIME 34 10192
TEST_TIME 35 10146
TEST_TIME 36 10023
TEST_TIME 37 9980
TEST_TIME 38 9943
TEST_TIME 39 9905
TEST_TIME 40 9771
TEST_TIME 41 9653
TEST_TIME 42 9729
TEST_TIME 43 9657
TEST_TIME 44 9544
TEST_TIME 45 9398
TEST_TIME 46 9441
TEST_TIME 47 9376
TEST_TIME 48 9258
TEST_TIME 49 9260
TEST_TIME 50 9241
TEST_TIME 51 9166
TEST_TIME 52 9091
TEST_TIME 53 9046
TEST_TIME 54 8960
TEST_TIME 55 8918
TEST_TIME 56 8927
TEST_TIME 57 9020
TEST_TIME 58 8980
TEST_TIME 59 8959
TEST_TIME 60 9117
TEST_TIME 61 9115
TEST_TIME 62 9101
TEST_TIME 63 9122
TEST_TIME 64 9200
TEST_TIME 65 9207
TEST_TIME 66 9247
TEST_TIME 67 9274
TEST_TIME 68 9342
TEST_TIME 69 9364
TEST_TIME 70 9355
TEST_TIME 71 9332
TEST_TIME 72 9238
TEST_TIME 73 9209
TEST_TIME 74 9142
TEST_TIME 75 9090
TEST_TIME 76 9023
TEST_TIME 77 9119
TEST_TIME 78 9077
TEST_TIME 79 9044
TEST_TIME 80 9071
TEST_TIME 81 9024
TEST_TIME 82 9021
TEST_TIME 83 9063
TEST_TIME 84 9031
TEST_TIME 85 9085
TEST_TIME 86 9166
TEST_TIME 87 9207
TEST_TIME 88 9195
TEST_TIME 89 9169
TEST_TIME 90 9127
TEST_TIME 91 9235
TEST_TIME 92 9175
TEST_TIME 93 9214
TEST_TIME 94 9182
TEST_TIME 95 9142
TEST_TIME 96 9119
TEST_TIME 97 9140
TEST_TIME 98 9099
TEST_TIME 99 9046
TEST_TIME 100 8996
TEST_TIME 101 8970
TEST_TIME 102 9010
TEST_TIME 103 8994
TEST_TIME 104 9012
TEST_TIME 105 9061
TEST_TIME 106 9029
TEST_TIME 107 9082
TEST_TIME 108 9061
TEST_TIME 109 9048
TEST_TIME 110 9069
TEST_TIME 111 9067
TEST_TIME 112 9060
TEST_TIME 113 9115
TEST_TIME 114 9122
TEST_TIME 115 9083
TEST_TIME 116 9019
TEST_TIME 117 9026
TEST_TIME 118 9041
TEST_TIME 119 9004
TEST_TIME 120 8957

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-03-2021 16:35:18 to 11-03-2021 16:35:21.

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 1504680 1504680 0 0.00 0 25138 7 0 0
doc_list_biud 1504675 1504675 0 0.00 0 28506 29 0 0
sp_add_invoice_to_stock 5212 5113 99 1.89 27 190307 19268 0 99
sp_cancel_adding_invoice 5368 5368 0 0.00 4 69330 845 0 0
sp_cancel_client_order 1747 1747 0 0.00 4 9159 335 0 0
sp_cancel_customer_reserve 524032 524032 0 0.00 1 19837 65 0 0
sp_cancel_pay_from_customer 701 701 0 0.00 3 6748 124 0 0
sp_cancel_pay_to_supplier 425 425 0 0.00 3 5402 84 0 0
sp_cancel_supplier_invoice 6039 6030 9 0.14 2 19487 844 0 9
sp_cancel_supplier_order 398 398 0 0.00 8 1236543 107909 0 0
sp_cancel_write_off 8895 8895 0 0.00 1 11296 118 0 0
sp_client_order 21503 21503 0 0.00 3 25802 366 0 0
sp_customer_reserve 462824 462824 0 0.00 0 42505 194 0 0
sp_fill_shopping_cart 33016 33016 0 0.00 1 28855 42 0 0
sp_fill_shopping_cart_clo_res 462809 462809 0 0.00 0 40029 14 0 0
sp_get_clo_for_invoice 5095 5095 0 0.00 0 26931 282 0 0
sp_kill_cost_storno 15389 15389 0 0.00 0 12409 60 0 0
sp_kill_qstorno_ret_qs2qd 1063387 1063387 0 0.00 0 19829 35 0 0
sp_kill_qty_storno 562114 562114 0 0.00 0 28504 76 0 0
sp_lock_selected_doc 21557 21557 0 0.00 0 9529 6 0 0
sp_make_cost_storno 28964 28964 0 0.00 0 10453 49 0 0
sp_multiply_rows_for_pdistr 28963 28963 0 0.00 0 25105 28 0 0
sp_multiply_rows_for_qdistr 21503 21503 0 0.00 0 25791 166 0 0
sp_pay_from_customer 7316 7316 0 0.00 4 12172 124 0 0
sp_pay_to_supplier 6003 6003 0 0.00 4 25143 115 0 0
sp_payment_common 13319 13319 0 0.00 1 12150 29 0 0
sp_qd_handle_on_cancel_clo 1747 1747 0 0.00 0 9153 308 0 0
sp_qd_handle_on_invoice_upd_sts 10462 10462 0 0.00 0 28499 344 0 0
sp_qd_handle_on_reserve_upd_sts 10550 10550 0 0.00 0 14609 59 0 0
sp_reserve_write_off 10550 10550 0 0.00 6 14625 170 0 0
sp_supplier_invoice 5735 5735 0 0.00 8 94315 3738 0 0
sp_supplier_order 5780 5780 0 0.00 5 51089 1351 0 0
srv_aggregate_perf_data 103 103 0 0.00 2728 124778 20827 0 0
srv_fill_mon_cache_memory 175 175 0 0.00 943 133714 28946 0 0
srv_find_qd_qs_mism 1026180 1026180 0 0.00 0 14491 6 0 0
srv_make_invnt_saldo 587 587 0 0.00 40 126119 1174 0 0
srv_make_money_saldo 852 852 0 0.00 1 3950 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 77319 425825 257572 0 0
t$perf-abend:sp_add_invoice_to_stock 99 99 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5113 5113 0 0.00 0 11595 180 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 1 5046 117 0 0
t$perf-norm:sp_cancel_client_order 1747 1747 0 0.00 0 5551 15 0 0
t$perf-norm:sp_cancel_customer_reserve 685 685 0 0.00 0 880 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 701 701 0 0.00 0 2497 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 425 425 0 0.00 0 3805 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 445 445 0 0.00 0 4647 39 0 0
t$perf-norm:sp_cancel_supplier_order 398 398 0 0.00 0 38055 1973 0 0
t$perf-norm:sp_cancel_write_off 1112 1112 0 0.00 0 2915 11 0 0
t$perf-norm:sp_client_order 21503 21503 0 0.00 0 6238 19 0 0
t$perf-norm:sp_customer_reserve 1046 1046 0 0.00 0 3723 12 0 0
t$perf-norm:sp_pay_from_customer 7316 7316 0 0.00 0 5513 11 0 0
t$perf-norm:sp_pay_to_supplier 6003 6003 0 0.00 0 5758 14 0 0
t$perf-norm:sp_reserve_write_off 10550 10550 0 0.00 0 10313 15 0 0
t$perf-norm:sp_supplier_invoice 5735 5735 0 0.00 0 14362 31 0 0
t$perf-norm:sp_supplier_order 5780 5780 0 0.00 0 5340 16 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 265 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 175 175 0 0.00 0 650 6 0 0
t$perf-norm:srv_make_invnt_saldo 587 587 0 0.00 0 1053 24 0 0
t$perf-norm:srv_make_money_saldo 852 852 0 0.00 0 2563 26 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 435 112 0 0
v_add_invoice_to_stock 10386 10188 198 1.90 0 9537 22 0 198
v_all_customers 38480 38480 0 0.00 0 20 1 0 0
v_all_suppliers 31554 31554 0 0.00 0 22 1 0 0
v_all_wares 43006 43006 0 0.00 0 56 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 1220 8 0 0
v_cancel_client_order 3494 3494 0 0.00 0 7205 9 0 0
v_cancel_customer_prepayment 1402 1402 0 0.00 0 6737 23 0 0
v_cancel_customer_reserve 1370 1370 0 0.00 0 6038 19 0 0
v_cancel_payment_to_supplier 850 850 0 0.00 0 693 6 0 0
v_cancel_supplier_invoice 908 890 18 1.98 0 1536 15 0 18
v_cancel_supplier_order 796 796 0 0.00 0 616 5 0 0
v_cancel_write_off 2224 2224 0 0.00 0 4918 18 0 0
v_max_id_clo_ord 5779 5779 0 0.00 0 262 1 0 0
v_max_id_clo_res 1046 1046 0 0.00 0 2929 15 0 0
v_max_id_ord_sup 5733 5733 0 0.00 0 4049 3 0 0
v_max_non_paid_invoice 1738 1738 0 0.00 0 4392 8 0 0
v_max_non_paid_realizn 4146 4146 0 0.00 0 2152 4 0 0
v_min_id_clo_ord 5779 5779 0 0.00 0 5839 9 0 0
v_min_id_clo_res 1046 1046 0 0.00 0 7375 23 0 0
v_min_id_ord_sup 5733 5733 0 0.00 0 8006 10 0 0
v_min_non_paid_invoice 6003 6003 0 0.00 0 7379 15 0 0
v_min_non_paid_realizn 7316 7316 0 0.00 0 6140 22 0 0
v_our_firm 10866 10866 0 0.00 0 19 1 0 0
v_reserve_write_off 21100 21100 0 0.00 0 8510 7 0 0
x_lock_depdocs_on_canc_invoice 10953 10953 0 0.00 0 16538 118 0 0
x_lock_depdocs_on_canc_sup_ord 398 398 0 0.00 0 9979 394 0 0
x_make_qstorno_1000_1200 5780 5780 0 0.00 2 50902 1266 0 0
x_make_qstorno_1200_2000 5735 5735 0 0.00 3 85935 3584 0 0
x_make_qstorno_2100_3300 462824 462824 0 0.00 0 42503 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-03-2021 16:35:22 to 11-03-2021 16:35:26.

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
14:02:55 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:03:01 11025 8192000000 10176456896 10470092800 852271408 9.423 70 54 111 0 873288592 2485120 18532064
14:03:20 34466 8192000000 10317210096 10635501568 1371391552 14.340 100 85 170 0 1404456800 4706752 28358496
14:04:05 25438 8192000000 10377389392 10699976704 1426212704 14.828 100 84 168 0 1460467296 6216032 28038560
14:04:38 36880 8192000000 10408972544 10736259072 1466950304 15.187 100 90 180 0 1504031920 7402992 29678624
14:05:27 22926 8192000000 10433727712 10765725696 1483909040 15.336 100 88 176 0 1520259760 8123408 28227312
14:06:02 23240 8192000000 10461607248 10795401216 1512286960 15.583 100 88 176 0 1548901136 8824928 27789248
14:06:35 17099 8192000000 10470626112 10808381440 1523353600 15.679 100 95 190 1 1563498416 9761392 30383424
14:07:10 14700 8192000000 10494421472 10839048192 1536779952 15.796 100 80 160 3 1571819184 9915792 25123440
14:07:36 10885 8192000000 10512468688 10861772800 1575328144 16.128 100 85 170 1 1611949152 10479584 26141424
14:07:58 17190 8192000000 10547143584 10900533248 1600113232 16.340 100 79 158 0 1634544352 10675936 23755184
14:08:30 16688 8192000000 10585163264 10943557632 1634744704 16.635 100 78 156 2 1669477728 11471472 23261552
14:08:56 8802 8192000000 10603424768 10958950400 1652110128 16.782 100 85 170 1 1689566320 12373376 25082816
14:09:11 8539 8192000000 10604497616 10967756800 1664650304 16.888 100 76 153 0 1700022416 12636304 22735808
14:09:29 12630 8192000000 10625901968 10994561024 1682689008 17.040 100 81 161 0 1718670784 12911040 23070736
14:09:49 12363 8192000000 10651127616 11019542528 1709739424 17.267 100 90 180 2 1749236544 13916704 25580416
14:10:09 8182 8192000000 10657216560 11025272832 1715486592 17.315 100 84 169 0 1752960560 13466224 24007744
14:10:24 5874 8192000000 10659077904 11028377600 1719671648 17.349 100 80 160 3 1755928944 13144272 23113024
14:10:36 5978 8192000000 10668667360 11042095104 1732607008 17.457 100 82 164 1 1768576560 13008576 22960976
14:10:48 6801 8192000000 10678549856 11053215744 1737882992 17.501 100 84 165 1 1775232192 14150320 23198880
14:11:02 6927 8192000000 10691063616 11063758848 1746610144 17.573 100 88 176 1 1786119216 14734992 24774080
14:11:16 4903 8192000000 10690401888 11070873600 1756539600 17.656 100 85 166 1 1794022704 14006832 23476272
14:11:27 3117 8192000000 10711706992 11084640256 1764554448 17.722 100 86 171 3 1801410816 13358928 23497440
14:11:37 3572 8192000000 10715568208 11089784832 1773541104 17.796 100 93 186 0 1813473472 14005104 25927264
14:11:47 3462 8192000000 10714794048 11095920640 1779704224 17.847 100 91 180 2 1819791792 15223920 24863648
14:11:57 2727 8192000000 10726583136 11104116736 1785479984 17.895 100 92 185 1 1826284448 14819600 25984864
14:12:06 4077 8192000000 10730787120 11110916096 1789945968 17.931 100 87 174 0 1829043312 15096784 24000560
14:12:17 2174 8192000000 10742128176 11119747072 1801157376 18.023 100 85 170 2 1837586848 13039392 23390080
14:12:25 3658 8192000000 10731901712 11119771648 1799403424 18.009 100 64 128 0 1829245904 12524576 17317904
14:12:36 3769 8192000000 10757112512 11140206592 1807876976 18.078 100 79 159 1 1841751744 11453328 22421440
14:12:46 2385 8192000000 10767597632 11151880192 1832814720 18.282 100 95 191 1 1872714096 13161440 26737936
14:12:55 2216 8192000000 10778643968 11164483584 1835029760 18.300 100 88 174 1 1872089728 13471360 23588608
14:13:03 2049 8192000000 10785776640 11168296960 1839141168 18.334 100 88 177 1 1876691072 13222768 24327136
14:13:12 1602 8192000000 10785413344 11170656256 1843053856 18.366 100 91 185 1 1882519056 13068656 26396544
14:13:20 2124 8192000000 10791622544 11184353280 1848277216 18.408 100 86 170 2 1884518832 12895456 23346160
14:13:28 1705 8192000000 10803801936 11188924416 1855335296 18.465 100 96 189 3 1897664416 15149728 27179392
14:13:36 1092 8192000000 10803032528 11188121600 1859674560 18.501 100 95 191 3 1901036976 14993616 26368800
14:13:44 1433 8192000000 10804228080 11190149120 1862688080 18.525 100 96 190 0 1902204784 12273056 27243648
14:13:51 1910 8192000000 10804239136 11192123392 1864587456 18.540 100 94 186 1 1901638608 10736560 26314592
14:13:59 1240 8192000000 10808127552 11195162624 1863638256 18.533 100 92 182 3 1902175456 12386752 26150448
14:14:07 1176 8192000000 10815804944 11200593920 1866557104 18.556 100 92 185 1 1906608320 12720720 27330496
14:14:14 1354 8192000000 10810995632 11197300736 1865275840 18.546 100 97 196 1 1906613104 13541584 27795680
14:14:22 1078 8192000000 10807884112 11198586880 1865135120 18.545 100 91 185 2 1905679552 14208848 26335584
14:14:29 1515 8192000000 10818312784 11204038656 1867390592 18.563 100 96 194 1 1908482912 13908736 27183584
14:14:36 1329 8192000000 10807936160 11198476288 1866796368 18.558 100 81 162 2 1902450160 12266432 23387360
14:14:45 22779 8192000000 10759638880 11182575616 1858116816 18.488 100 41 82 0 1879849136 10168528 11563792
14:15:18 18053 8192000000 10798555008 11198287872 1867699104 18.566 100 60 123 3 1890763216 5526432 17537680
14:15:43 44125 8192000000 10761855200 11200352256 1863406368 18.531 100 36 70 2 1880163152 6467120 10289664
14:16:33 3151 8192000000 10779476144 11206897664 1874196000 18.618 100 49 98 2 1894155504 5999232 13960272
14:16:43 4028 8192000000 10779554304 11209375744 1872133280 18.602 100 28 56 0 1886290400 5994496 8162624
14:16:53 6538 8192000000 10785424528 11212468224 1873664912 18.614 100 25 50 1 1887103952 6634464 6804576
14:17:12 7597 8192000000 10793530464 11215446016 1873526176 18.613 100 24 47 1 1886711824 6605488 6580160
14:17:25 6672 8192000000 10785364528 11212627968 1873920800 18.616 100 21 42 0 1887020128 7063888 6035440
14:17:38 5317 8192000000 10788146944 11214196736 1876578128 18.637 100 34 68 2 1893589008 7322752 9688128
14:17:53 12813 8192000000 10790184208 11221577728 1879263680 18.659 100 19 39 0 1890412128 5720080 5428368
14:18:19 6262 8192000000 10804526256 11225014272 1884230576 18.699 100 29 58 1 1897934000 5442176 8261248
14:18:33 13932 8192000000 10778892896 11220586496 1881771680 18.679 100 24 48 2 1895312592 6695712 6845200
14:18:56 7854 8192000000 10795461984 11224879104 1883091760 18.690 100 20 40 0 1895429952 6182032 6156160
14:19:17 8445 8192000000 10819817792 11234881536 1883396896 18.693 100 15 30 1 1893578288 5990816 4190576
14:19:34 7580 8192000000 10802788624 11235225600 1888180864 18.731 100 20 40 1 1904703456 11079344 5443248
14:19:48 9209 8192000000 10797291104 11234320384 1895792800 18.792 100 22 44 0 1907921104 6094848 6033456
14:20:04 9377 8192000000 10816867744 11245199360 1899713392 18.824 100 28 56 1 1914776736 7211264 7852080
14:20:21 7208 8192000000 10823780624 11252428800 1903592880 18.855 100 29 58 0 1917709280 5720752 8395648
14:20:39 27334 8192000000 10820870320 11256098816 1908148816 18.892 100 33 67 0 1924249504 5699968 10400720
14:21:12 48878 8192000000 10814680304 11254681600 1896622416 18.799 99 47 94 1 1916728944 5871088 14235440
14:22:07 16622 8192000000 10823389424 11261169664 1911540480 18.919 100 22 44 1 1922884832 5802944 5541408
14:22:35 5817 8192000000 10826117168 11261468672 1909228192 18.900 100 30 60 4 1925128752 7235648 8664912
14:22:50 6794 8192000000 10802411584 11239305216 1883164800 18.691 99 25 50 2 1896608368 6272176 7171392
14:23:04 5536 8192000000 10778416000 11208646656 1825564736 18.223 97 22 44 1 1838162688 6752576 5845376
14:23:19 6263 8192000000 10784550448 11200925696 1842340528 18.360 98 37 74 0 1858794368 5897728 10556112
14:23:32 4774 8192000000 10768883520 11184369664 1834035632 18.292 99 29 58 3 1849325872 6382800 8907440
14:23:48 6998 8192000000 10749664176 11167772672 1790382384 17.935 97 20 40 4 1801372544 5359776 5630384
14:24:02 8659 8192000000 10742843712 11164614656 1773549504 17.796 96 15 30 0 1783447024 5764016 4133504
14:24:17 7568 8192000000 10730031056 11153940480 1752903712 17.626 96 17 34 2 1766920720 9458336 4558672
14:24:31 7590 8192000000 10719939168 11136745472 1729146880 17.428 95 22 44 0 1740573504 5212768 6213856
14:24:48 9506 8192000000 10713614224 11129540608 1738618880 17.507 96 18 36 1 1750053392 5750768 5683744
14:25:05 10537 8192000000 10711628368 11122569216 1728846864 17.426 96 19 37 1 1738677024 4801744 5028416
14:25:22 6439 8192000000 10715742336 11133952000 1797062016 17.990 100 34 68 1 1813933008 7098480 9772512
14:25:38 8075 8192000000 10730838048 11150307328 1806316928 18.066 100 26 52 0 1819879040 6073136 7488976
14:25:53 62632 8192000000 10711432704 11118796800 1687316496 17.079 93 43 86 1 1706017920 5017808 13683616
14:27:31 8435 8192000000 10735961632 11149885440 1811002272 18.104 100 37 73 3 1827699552 5477664 11219616
14:27:46 7063 8192000000 10727110032 11151409152 1802896112 18.038 99 36 72 0 1820078304 6996032 10186160
14:28:02 5062 8192000000 10728862304 11148943360 1799343312 18.009 99 32 64 2 1815517936 6300752 9873872
14:28:14 8071 8192000000 10742198320 11157569536 1815760288 18.143 100 26 52 2 1833362960 9913824 7688848
14:28:31 8350 8192000000 10728118976 11150270464 1789433648 17.927 98 33 66 1 1805490144 6157120 9899376
14:28:46 9305 8192000000 10753094432 11173654528 1830646640 18.265 100 35 70 0 1846969840 6507760 9815440
14:29:02 10299 8192000000 10754654240 11174383616 1835842224 18.307 100 23 46 0 1849159008 5433824 7882960
14:29:18 10348 8192000000 10758066080 11173789696 1820584608 18.182 99 28 56 1 1834352480 5430320 8337552
14:29:40 4881 8192000000 10746835408 11158790144 1799591472 18.011 98 27 54 3 1812728608 5321904 7815232
14:29:51 7975 8192000000 10740662704 11169374208 1827353440 18.238 100 14 27 1 1835957248 4735312 3868496
14:30:09 7241 8192000000 10747643088 11177295872 1837254864 18.318 100 22 44 1 1849328016 6079120 5994032
14:30:23 10943 8192000000 10758039968 11183128576 1836962800 18.316 100 24 47 1 1853722800 10496272 6263728
14:30:42 17990 8192000000 10760113056 11185156096 1847897296 18.405 100 25 50 1 1864883024 9624272 7361456
14:31:09 68268 8192000000 10781473328 11207462912 1862022832 18.520 100 31 62 1 1875600656 5150736 8427088
14:32:24 11963 8192000000 10793678144 11220635648 1877251136 18.643 100 23 46 2 1888832480 5488672 6092672
14:32:44 7016 8192000000 10806285472 11231690752 1888022912 18.730 100 32 62 1 1901521824 5559024 7939888
14:32:57 4527 8192000000 10833358320 11246870528 1900761648 18.832 100 54 107 3 1923294688 8036256 14496784
14:33:09 13028 8192000000 10844703584 11259547648 1908799600 18.897 100 60 120 0 1935645264 8979536 17866128
14:33:29 4977 8192000000 10852088160 11268300800 1916064896 18.955 100 68 135 2 1945100688 9514864 19520928
14:34:12 7522 8192000000 10864129136 11279073280 1924433152 19.022 100 59 118 1 1952888064 12197472 16257440
14:34:28 4594 8192000000 10864538400 11284094976 1926182144 19.036 100 54 108 0 1954055968 12458128 15415696
14:34:43 18570 8192000000 10863927216 11290116096 1930014032 19.067 100 53 106 0 1958245760 12806720 15425008
14:35:10 21685 8192000000 10870900656 11294830592 1933300816 19.093 100 54 108 1 1961316288 12937872 15077600
14:35:42 24851 8192000000 10882200384 11307913216 1938031712 19.131 100 50 100 1 1966275584 14706848 13537024
14:36:14 6518 8192000000 10894377136 11318546432 1949111488 19.219 100 54 107 1 1984659152 19981040 15566624
14:36:30 24472 8192000000 10879193328 11321786368 1951088464 19.235 100 45 90 2 1985598304 21204576 13305264
14:37:01 2893 8192000000 10888486048 11320557568 1952928816 19.250 100 34 68 0 1980812560 17558336 10325408
14:37:23 14877 8192000000 10901165520 11330887680 1959809504 19.305 100 47 94 2 1993098496 19524608 13764384
14:37:45 22513 8192000000 10901763664 11339116544 1960808288 19.312 100 37 73 1 1989727120 17692464 11226368
14:38:15 23992 8192000000 10921486064 11350999040 1970835152 19.392 100 55 108 1 2012308336 25748096 15725088
14:38:48 5132 8192000000 10929671600 11355828224 1977490112 19.445 100 60 120 2 2020132960 25082752 17560096
14:39:02 17015 8192000000 10921150720 11352567808 1972623952 19.406 100 52 102 0 2013876368 26262976 14989440
14:39:29 38742 8192000000 10917743024 11359088640 1976580640 19.438 100 50 101 1 2018016352 26644544 14791168
14:40:21 24453 8192000000 10915005696 11364454400 1976166368 19.434 100 34 68 1 2012591952 25678160 10747424
14:40:53 16011 8192000000 10924765776 11371130880 1981640160 19.478 100 29 57 0 2017948928 27644736 8664032
14:41:17 7816 8192000000 10940789120 11374948352 1988066224 19.529 100 43 84 1 2029345552 27881856 13397472
14:41:36 3496 8192000000 10942379408 11378077696 1988042928 19.528 100 60 119 2 2032208320 26908944 17256448
14:41:50 4281 8192000000 10958274560 11382796288 1993855584 19.574 100 75 150 1 2046289536 29247904 23186048
14:42:03 11474 8192000000 10959400768 11392372736 1997257184 19.601 100 66 132 1 2047829792 30565104 20007504
14:42:24 7282 8192000000 10953711696 11391184896 1999152592 19.616 100 54 108 0 2044690240 29439728 16097920
14:42:40 4611 8192000000 10960226592 11391139840 2004971840 19.662 100 57 112 3 2049792688 28555072 16265776
14:42:53 6061 8192000000 10948604160 11379695616 1979558960 19.461 99 63 125 1 2027045008 28725424 18760624
14:43:07 2101 8192000000 10942988048 11356762112 1970536784 19.390 99 83 160 3 2023974656 29984704 23453168
14:43:17 4011 8192000000 10950574848 11374854144 1987619200 19.525 100 75 149 3 2040213568 30950144 21644224
14:43:27 8995 8192000000 10949837072 11377889280 1988413456 19.531 100 66 132 1 2039131280 31188720 19529104
14:43:46 6909 8192000000 10952631376 11384668160 1993364064 19.570 100 59 118 3 2040183664 29424176 17395424
14:44:03 6028 8192000000 10947340960 11376578560 1970849856 19.392 99 52 104 3 2017419344 30605808 15963680
14:44:16 2042 8192000000 10964141712 11373473792 1980306880 19.467 100 83 167 0 2036033216 30553376 25172960
14:44:26 1847 8192000000 10952659856 11365765120 1977922000 19.448 100 89 176 3 2035588208 31448496 26217712
14:44:36 6431 8192000000 10931006464 11351207936 1962820592 19.328 99 74 147 2 2017264224 32380208 22063424
14:44:50 9451 8192000000 10944263120 11362746368 1968548464 19.374 99 76 150 1 2025196224 33835824 22811936
14:45:07 3543 8192000000 10969562528 11378601984 1983715376 19.494 100 83 166 0 2042773824 33883392 25175056
14:45:19 7313 8192000000 10949954416 11371683840 1966265936 19.356 99 72 144 0 2022689024 34374448 22048640
14:45:41 3832 8192000000 10939105264 11360030720 1965710240 19.351 99 69 138 1 2020589392 33813392 21065760
14:45:56 2721 8192000000 10928642016 11352035328 1955687360 19.272 100 58 116 0 2008729280 35008048 18033872
14:46:07 2546 8192000000 10961571088 11372457984 1976998688 19.441 100 86 170 0 2039734144 36429792 26305664
14:46:18 2309 8192000000 10951276688 11367006208 1959800256 19.304 99 80 158 1 2021187024 37771984 23614784
14:46:29 2636 8192000000 10940205872 11357065216 1952110432 19.243 99 89 178 2 2019557152 38771504 28675216
14:46:38 4868 8192000000 10923067136 11339542528 1935902000 19.114 99 74 147 1 1997644896 38819040 22923856
14:46:50 6708 8192000000 10903002080 11321954304 1931806544 19.081 99 75 149 1 1994030384 39282944 22940896
14:47:03 2048 8192000000 10923621856 11344588800 1949916720 19.226 100 74 148 0 2011029584 38301648 22811216
14:47:14 3996 8192000000 10932297744 11348385792 1954636704 19.263 100 81 159 1 2019658192 39265152 25756336
14:47:26 5829 8192000000 10927482608 11345285120 1948549824 19.215 100 80 160 0 2015279744 41448272 25281648
14:47:40 8046 8192000000 10941048768 11358818304 1956051024 19.275 100 64 125 1 2018005232 42752272 19201936
14:47:56 9409 8192000000 10933778672 11362570240 1958892544 19.297 100 66 132 3 2023221904 43341280 20988080
14:48:12 9186 8192000000 10935701536 11371266048 1965497408 19.350 100 65 130 2 2030657360 44308560 20851392
14:48:34 2766 8192000000 10943317360 11371225088 1969572336 19.382 100 63 124 1 2026592224 37836112 19183776
14:48:45 2122 8192000000 10924349680 11340730368 1933167664 19.092 99 70 140 1 1991189184 36593264 21428256
14:48:55 2240 8192000000 10926417968 11336851456 1947483168 19.206 100 83 167 1 2010180400 35808608 26888624
14:49:06 6503 8192000000 10916643056 11327422464 1929552256 19.063 99 72 143 1 1989436960 37326272 22558432
14:49:21 9867 8192000000 10890593760 11312291840 1907291440 18.885 99 67 134 2 1966194640 37899776 21003424
14:49:40 6438 8192000000 10900410064 11319435264 1926115888 19.036 100 73 145 0 1987972928 38445328 23411712
14:49:55 2925 8192000000 10920506016 11328942080 1934532320 19.103 100 93 185 0 2003680768 39287040 29861408
14:50:05 1157 8192000000 10912030160 11311104000 1918313568 18.973 99 86 168 3 1984822176 41356864 25151744
14:50:14 3348 8192000000 10918176480 11327127552 1933159424 19.092 100 82 162 5 2001786720 43428768 25198528
14:50:25 942 8192000000 10942892272 11348901888 1949081632 19.219 100 92 185 3 2023090112 45239904 28768576
14:50:33 6432 8192000000 10935611280 11347697664 1950146432 19.228 100 81 158 2 2013630128 38091904 25391792
14:50:48 2940 8192000000 10953185312 11363962880 1966724096 19.359 100 86 169 2 2032053392 38839440 26489856
14:50:58 3270 8192000000 10900477008 11310821376 1917536928 18.967 98 77 154 1 1980756832 38969488 24250416
14:51:16 9025 8192000000 10921769568 11348975616 1944761968 19.185 100 56 112 1 2005636816 41259776 19615072
14:51:35 6676 8192000000 10916495424 11336650752 1932251408 19.085 99 64 127 1 1991775152 39302736 20221008
14:51:49 6249 8192000000 10907846352 11322593280 1917567264 18.967 99 75 148 0 1983593648 42371952 23654432
14:52:04 4949 8192000000 10926667280 11348557824 1941927344 19.162 100 70 140 0 2009211024 44923136 22360544
14:52:17 3871 8192000000 10944509568 11359776768 1948430496 19.214 100 79 157 1 2022610320 48831616 25348208
14:52:29 4592 8192000000 10959306352 11370848256 1959413856 19.301 100 85 169 0 2036355440 50177008 26764576
14:52:40 1512 8192000000 10969441216 11376676864 1963779264 19.336 100 90 178 1 2043989568 51649072 28561232
14:52:48 2068 8192000000 10946032736 11363479552 1947580288 19.207 100 79 155 1 2022851392 50416160 24854944
14:53:01 4687 8192000000 10948494368 11363942400 1953574608 19.255 100 74 146 0 2025502304 48372448 23555248
14:53:14 3139 8192000000 10941168064 11360989184 1954090032 19.259 100 75 148 2 2022817424 45629552 23097840
14:53:29 4687 8192000000 10957251152 11374682112 1962458256 19.326 100 86 173 3 2037345120 47682208 27204656
14:53:41 1319 8192000000 10959648400 11377516544 1965923760 19.353 100 82 164 2 2042016304 49848672 26243872
14:53:51 2790 8192000000 10955139344 11376410624 1960505776 19.310 100 69 137 0 2029783984 47710272 21567936
14:54:08 3431 8192000000 10967152064 11382878208 1970645696 19.391 100 86 172 2 2045421904 48115632 26660576
14:54:20 2444 8192000000 10971990352 11389652992 1979446928 19.460 100 92 184 2 2056315776 48497120 28371728
14:54:30 4973 8192000000 10959788208 11380375552 1955236624 19.268 99 71 140 4 2026764688 48910448 22617616
14:54:41 3495 8192000000 10967903312 11389816832 1973273024 19.411 100 74 148 0 2045135200 48670400 23191776
14:54:52 4239 8192000000 10955456736 11383508992 1966036128 19.354 100 65 130 1 2037574400 50334144 21204128
14:55:02 9148 8192000000 10938867424 11370708992 1957400512 19.285 100 45 89 1 2019525312 47015104 15109696
14:55:20 6808 8192000000 10931946656 11363672064 1954388352 19.261 100 48 95 1 2012617504 42524832 15704320
14:55:34 5638 8192000000 10949599344 11378569216 1972068704 19.402 100 64 128 1 2035561280 42862304 20630272
14:55:47 8855 8192000000 10938003248 11382849536 1967397840 19.365 100 47 92 3 2025349408 42677904 15273664
14:56:13 6320 8192000000 10939396096 11375616000 1970494736 19.389 100 35 70 1 2013585120 30830288 12260096
14:56:33 5506 8192000000 10949276592 11385196544 1965562432 19.350 99 53 104 1 2013382048 31679360 16140256
14:57:02 5572 8192000000 10941408432 11378335744 1979314640 19.459 100 49 98 0 2026355312 31243312 15797360
14:57:17 17384 8192000000 10924452224 11371196416 1938733824 19.137 98 32 64 0 1984103232 34536864 10832544
14:57:45 11301 8192000000 10928054144 11376078848 1966688832 19.359 100 34 68 2 2012657024 34859552 11108640
14:58:07 13289 8192000000 10921219808 11362103296 1943346928 19.173 99 29 58 1 1988837680 35391360 10099392
14:58:36 21778 8192000000 10916439888 11364560896 1938294160 19.133 99 31 62 0 1987930736 38710432 10926144
14:59:05 16399 8192000000 10922230096 11372023808 1956399584 19.277 100 26 53 1 2005773376 40321328 9052464
14:59:43 28532 8192000000 10912572752 11358973952 1932274304 19.085 99 24 48 2 1979311632 38776624 8260704
15:00:36 37322 8192000000 10907749040 11364171776 1936963248 19.123 100 24 48 1 1989654560 43425392 9265920
15:01:21 26839 8192000000 10919598224 11381235712 1935539104 19.111 100 21 42 1 1997222480 53692224 7991152
15:02:15 29262 8192000000 10905887456 11336114176 1936011024 19.115 99 53 107 0 1960452288 9632960 14808304
15:02:50 87821 8192000000 10882918064 11333881856 1938521456 19.135 99 33 66 1 1955190688 7786384 8882848
15:04:57 31992 8192000000 10882145152 11335745536 1941240144 19.157 99 29 56 1 1956274720 6309184 8725392
15:05:36 15469 8192000000 10894451872 11355627520 1967435456 19.365 100 26 51 1 1984352496 10235008 6682032
15:05:59 15820 8192000000 10889722912 11357081600 1968086496 19.370 100 13 26 0 1981256224 9808288 3361440
15:06:23 23766 8192000000 10864404144 11316396032 1908556848 18.895 97 30 60 1 1928047024 11222640 8267536
15:06:54 45696 8192000000 10878755280 11347116032 1938565744 19.135 99 12 24 0 1954952048 13131376 3254928
15:07:46 54741 8192000000 10872499456 11340034048 1920599872 18.992 98 17 34 0 1937805328 12158352 5047104
15:08:51 28925 8192000000 10873035840 11321311232 1915447744 18.950 98 16 32 0 1935128400 14834288 4846368
15:09:30 97484 8192000000 10885951824 11347550208 1938294912 19.133 99 27 54 3 1962680640 15876656 8509072
15:11:14 58887 8192000000 10894818224 11359150080 1971248896 19.395 100 32 64 0 1990071456 10236896 8585664
15:12:19 53416 8192000000 10919781696 11371880448 1975778944 19.431 100 29 59 1 1994261632 10227984 8254704
15:13:19 72438 8192000000 10892389696 11361808384 1955521392 19.270 99 20 40 0 1973678416 12313040 5843984
15:14:38 46989 8192000000 10901244832 11360235520 1951337136 19.237 99 16 32 1 1965958864 10087776 4533952
15:15:33 47792 8192000000 10894664784 11369361408 1979921040 19.464 100 42 82 4 2000953792 8894752 12138000
15:16:28 88087 8192000000 10909395328 11366981632 1961496336 19.318 99 29 58 2 1976942560 6138400 9307824
15:18:13 74079 8192000000 10905234304 11370635264 1942263968 19.165 98 25 48 0 1957069184 8514912 6290304
15:19:33 67299 8192000000 10909921520 11373170688 1984334192 19.499 100 31 62 1 2002440256 8964944 9141120
15:20:47 15094 8192000000 10894175936 11367026688 1963398192 19.333 99 19 38 0 1978485792 9774976 5312624
15:21:09 29005 8192000000 10895150960 11367342080 1961720080 19.320 99 19 38 1 1976095264 9034176 5341008
15:21:45 23813 8192000000 10919732176 11366526976 1962876256 19.329 99 34 67 2 1979659984 7132256 9651472
15:22:20 33986 8192000000 10887320272 11359768576 1967299536 19.364 99 35 70 0 1986387456 8879760 10208160
15:23:03 77731 8192000000 10902261040 11378720768 1945651984 19.192 98 9 18 0 1955293440 6930880 2710576
15:24:30 43572 8192000000 10912745504 11382763520 1987731088 19.526 100 12 24 0 2001579536 10257600 3590848
15:25:44 62096 8192000000 10901548896 11384717312 1972211184 19.403 99 6 12 0 1985792672 11963216 1618272
15:27:06 45766 8192000000 10898588080 11380400128 1967125504 19.363 99 20 37 1 1985733792 12912704 5695584
15:28:00 28586 8192000000 10900629760 11379048448 1968539040 19.374 99 23 45 1 1986942912 12205680 6198192
15:28:35 42567 8192000000 10890054752 11370291200 1946167520 19.196 98 9 18 0 1960458752 11287856 3003376
15:29:28 67448 8192000000 10872914384 11350192128 1883495472 18.693 96 4 8 0 1895895584 11423424 976688
15:30:42 58929 8192000000 10879592368 11347480576 1905815760 18.873 97 18 36 0 1924895984 13515184 5565040
15:31:52 84130 8192000000 10868887104 11352412160 1902926192 18.850 97 18 36 0 1920439920 12603072 4910656
15:33:24 55256 8192000000 10873324496 11333595136 1859189856 18.497 95 9 18 1 1869176112 8157264 1828992
15:34:27 31232 8192000000 10887495104 11349098496 1923291872 19.013 98 25 50 0 1936562032 7538992 5731168
15:35:10 42838 8192000000 10852535392 11318743040 1863188096 18.529 95 21 42 1 1877947248 9193904 5565248
15:36:01 93899 8192000000 10864409200 11308175360 1773152016 17.793 91 12 25 1 1788289488 11384544 3752928
15:37:41 14129 8192000000 10856946544 11313041408 1914095488 18.940 99 52 105 1 1936740224 6962480 15682256
15:38:04 30026 8192000000 10865740976 11317895168 1884803360 18.704 97 29 58 0 1904968160 11991424 8173376
15:39:46 133714 8192000000 10842400288 11309625344 1788652688 17.921 92 16 32 0 1809615456 16573440 4389328
15:42:10 66712 8192000000 10863912784 11319762944 1859701136 18.501 96 23 46 0 1876066096 10284848 6080112
15:43:23 40043 8192000000 10834399616 11283644416 1881827152 18.680 98 30 60 1 1901923232 10831344 9264736
15:44:19 106007 8192000000 10833837408 11294703616 1878292336 18.651 97 29 58 0 1894288256 8078064 7917856
15:46:23 10161 8192000000 10847736752 11314483200 1926276672 19.037 100 11 22 1 1939724720 10379536 3068512
15:46:42 39769 8192000000 10850390848 11321655296 1910320144 18.909 99 24 48 1 1931192448 14378624 6493680
15:47:31 50036 8192000000 10816712720 11281575936 1891143040 18.755 98 13 26 0 1905992416 10862896 3986480
15:50:04 36698 8192000000 10842191008 11313508352 1925708880 19.033 100 38 75 2 1944238016 7983216 10545920
15:50:54 43355 8192000000 10856392960 11329425408 1937748448 19.129 100 6 12 0 1946776080 7454752 1572880
15:51:45 39211 8192000000 10845104944 11324035072 1881334688 18.676 97 9 18 0 1892064400 8204160 2525552
15:52:30 64786 8192000000 10879720640 11341213696 1939618944 19.144 100 9 18 0 1953706208 11413840 2673424
15:54:24 56881 8192000000 10887628496 11364044800 1960575520 19.311 100 21 42 1 1980557456 13201968 6779968
15:55:30 60385 8192000000 10906405472 11360419840 1950109888 19.227 99 20 40 0 1968298048 12049584 6138576
15:56:39 33882 8192000000 10880411456 11350261760 1926730912 19.041 98 17 34 0 1943575040 11668448 5175680
15:57:19 97881 8192000000 10874959232 11360444416 1891375280 18.757 96 17 34 1 1910468592 13930352 5162960
15:59:03 133518 8192000000 10886643888 11362373632 1919044240 18.979 98 16 32 0 1934859200 11520256 4294704
16:01:30 35114 8192000000 10902310752 11362160640 1947022640 19.203 99 24 47 0 1965680848 12887008 5771200
16:02:11 49716 8192000000 10923120496 11376201728 1959148080 19.299 99 28 56 0 1978288656 11384048 7756528
16:03:48 48418 8192000000 10923619680 11380224000 1960831200 19.313 99 36 68 0 1980635552 10934304 8870048
16:04:51 17194 8192000000 10929853136 11383250944 1967149776 19.363 99 51 101 1 1996158816 14358240 14650800
16:05:26 120616 8192000000 10898345072 11357323264 1939525632 19.143 98 37 74 4 1958740208 8955072 10259504
16:08:49 73982 8192000000 10869753904 11353219072 1907427232 18.886 97 15 30 1 1925332288 13239776 4665280
16:10:09 63560 8192000000 10885148368 11373527040 1944595648 19.183 99 9 18 0 1957730192 10691360 2443184
16:11:44 55990 8192000000 10909376976 11383021568 1966358512 19.357 99 21 42 1 1986381344 13883408 6139424
16:12:46 82723 8192000000 10905996192 11393593344 1966638880 19.359 99 10 19 1 1984961104 15133648 3188576
16:14:19 74232 8192000000 10903608912 11389882368 1946413600 19.198 98 12 24 1 1966169136 16244240 3511296
16:15:41 87017 8192000000 10904806560 11379175424 1925504256 19.031 97 24 48 4 1944995344 12829024 6662064
16:17:15 56381 8192000000 10873611456 11347202048 1871540720 18.597 95 13 26 1 1886737632 11140080 4056832
16:18:17 49371 8192000000 10899173712 11367686144 1949867696 19.225 99 30 60 1 1968205328 9478304 8859328
16:19:28 76803 8192000000 10881176368 11351814144 1888789904 18.736 96 25 50 1 1905103856 9628992 6684960
16:20:59 28035 8192000000 10895220960 11353870336 1940420752 19.150 99 28 56 1 1958313488 9838672 8054064
16:21:38 18843 8192000000 10890758608 11344404480 1915923760 18.954 98 32 64 0 1933707008 9128128 8655120
16:22:14 36414 8192000000 10884892784 11351171072 1926214496 19.037 99 33 66 0 1949154224 13632256 9307472
16:22:59 53867 8192000000 10867387840 11326111744 1852638352 18.444 95 17 34 1 1867123152 9901664 4583136
16:24:36 46305 8192000000 10877949584 11349446656 1910513840 18.911 98 22 44 0 1932100928 15023264 6563824
16:25:33 84106 8192000000 10882181696 11336179712 1863100064 18.528 96 11 22 2 1874458656 8429536 2929056
16:27:04 19512 8192000000 10882416080 11335516160 1919513200 18.983 99 37 73 1 1938130624 8673760 9943664
16:27:31 106444 8192000000 10863128256 11336232960 1908790400 18.897 98 41 82 2 1934708272 13819552 12098320
16:29:56 35537 8192000000 10865142656 11338108928 1930319600 19.069 100 24 48 3 1954355584 17566432 6469552
16:30:39 18838 8192000000 10844456032 11329449984 1915146416 18.948 99 6 12 0 1928946016 12254416 1545184
16:31:12 21834 8192000000 10854443952 11320537088 1901026112 18.835 98 19 38 3 1914783584 8000560 5756912
16:31:44 61368 8192000000 10812942672 11286724608 1828464000 18.247 95 9 18 1 1838164944 7401856 2299088

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-03-2021 16:35:28 to 11-03-2021 16:36:00.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 99 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-03-2021 16:36:01 to 11-03-2021 16:36:03.

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          243072
MON$OLDEST_ACTIVE               244784
MON$OLDEST_SNAPSHOT             244784
MON$NEXT_TRANSACTION            244784
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                       2024992
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.33424 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33424 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33424 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33424 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Thu Mar 11 16:33:00 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Thu Mar 11 16:33:02 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
:14: 
:15: mscs-test-161.budzdorov.ru    Thu Mar 11 16:33:02 2021
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:17: 
:18: 
:19: mscs-test-161.budzdorov.ru    Thu Mar 11 16:33:06 2021
:20:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:21: 
--- end of diff output ---

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

11.03.21 16:36:04. 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-03-11 16:36:06 No severe PSQL-related problems occured
11.03.21 16:36:08. End of report.