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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17310764 kB
MemAvailable 31539644 kB
Buffers 0 kB
Cached 14418752 kB
SwapCached 4500 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 2020-11-19 22:27:04
DTS_END                         2020-11-19 22:27:03.9980
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_TO_SUPPLIER(26:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47588
TRN_ID                          246599
ATT_ID                          713
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: 9542.17 21373 1145061
customer order: creation 178.88 345 21465
customer order: refuse 15.11 358 1813
order to supplier: creation 48.39 1302 5807
order to supplier: removal 3.28 108235 393
invoice (draft): creation 48.08 3234 5770
invoice (draft): removal 54.42 871 6530
invoice accept: apply 43.09 17798 5171
invoice accept: cancel 48.86 795 5863
customer reserve: creation 3982.45 176 477894
customer reserve: removal 4799.80 56 575976
realization accept: apply 87.50 179 10500
realization accept: cancel 97.96 112 11755
payment from customer: creation 61.17 117 7340
payment from customer: removal 5.88 93 705
payment to supplier: creation 51.55 108 6186
payment to supplier: removal 3.48 65 417
service: total inventory turnovers 4.87 1269 584
service: total monetary turnovers 6.54 49 785
service: aggregate perf. data 0.86 18119 103
service: refresh index statistics 0.03 274174 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-11-2020 22:29:35 to 19-11-2020 22:29:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4966
TEST_TIME 2 4685
TEST_TIME 3 5451
TEST_TIME 4 4848
TEST_TIME 5 4845
TEST_TIME 6 4787
TEST_TIME 7 5866
TEST_TIME 8 6002
TEST_TIME 9 6150
TEST_TIME 10 6261
TEST_TIME 11 6483
TEST_TIME 12 6963
TEST_TIME 13 7316
TEST_TIME 14 7729
TEST_TIME 15 8029
TEST_TIME 16 8172
TEST_TIME 17 8194
TEST_TIME 18 8664
TEST_TIME 19 9206
TEST_TIME 20 9129
TEST_TIME 21 10022
TEST_TIME 22 9918
TEST_TIME 23 9904
TEST_TIME 24 9757
TEST_TIME 25 10073
TEST_TIME 26 10710
TEST_TIME 27 10814
TEST_TIME 28 11673
TEST_TIME 29 11513
TEST_TIME 30 11403
TEST_TIME 31 11178
TEST_TIME 32 11206
TEST_TIME 33 11052
TEST_TIME 34 11055
TEST_TIME 35 11031
TEST_TIME 36 10913
TEST_TIME 37 10826
TEST_TIME 38 10727
TEST_TIME 39 10541
TEST_TIME 40 10572
TEST_TIME 41 10579
TEST_TIME 42 10704
TEST_TIME 43 10565
TEST_TIME 44 10510
TEST_TIME 45 10436
TEST_TIME 46 10404
TEST_TIME 47 10219
TEST_TIME 48 10210
TEST_TIME 49 10118
TEST_TIME 50 10020
TEST_TIME 51 10000
TEST_TIME 52 9874
TEST_TIME 53 9939
TEST_TIME 54 9868
TEST_TIME 55 9814
TEST_TIME 56 9873
TEST_TIME 57 9993
TEST_TIME 58 10031
TEST_TIME 59 10043
TEST_TIME 60 10106
TEST_TIME 61 10094
TEST_TIME 62 10081
TEST_TIME 63 10179
TEST_TIME 64 10194
TEST_TIME 65 10200
TEST_TIME 66 10149
TEST_TIME 67 10253
TEST_TIME 68 10336
TEST_TIME 69 10194
TEST_TIME 70 10111
TEST_TIME 71 10091
TEST_TIME 72 10015
TEST_TIME 73 10017
TEST_TIME 74 9999
TEST_TIME 75 9949
TEST_TIME 76 9918
TEST_TIME 77 9881
TEST_TIME 78 9835
TEST_TIME 79 9831
TEST_TIME 80 9800
TEST_TIME 81 9778
TEST_TIME 82 9794
TEST_TIME 83 9814
TEST_TIME 84 9785
TEST_TIME 85 9810
TEST_TIME 86 9838
TEST_TIME 87 9856
TEST_TIME 88 9845
TEST_TIME 89 9870
TEST_TIME 90 9889
TEST_TIME 91 9865
TEST_TIME 92 9870
TEST_TIME 93 9912
TEST_TIME 94 9930
TEST_TIME 95 9826
TEST_TIME 96 9807
TEST_TIME 97 9769
TEST_TIME 98 9683
TEST_TIME 99 9640
TEST_TIME 100 9633
TEST_TIME 101 9650
TEST_TIME 102 9614
TEST_TIME 103 9589
TEST_TIME 104 9574
TEST_TIME 105 9583
TEST_TIME 106 9567
TEST_TIME 107 9518
TEST_TIME 108 9554
TEST_TIME 109 9643
TEST_TIME 110 9673
TEST_TIME 111 9686
TEST_TIME 112 9666
TEST_TIME 113 9658
TEST_TIME 114 9715
TEST_TIME 115 9767
TEST_TIME 116 9696
TEST_TIME 117 9671
TEST_TIME 118 9619
TEST_TIME 119 9623
TEST_TIME 120 9548

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 19-11-2020 22:29:38 to 19-11-2020 22:29:42.

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 1587838 1587838 0 0.00 0 18913 6 0 0
doc_list_biud 1587837 1587837 0 0.00 0 31667 27 0 0
sp_add_invoice_to_stock 5294 5171 123 2.32 25 177717 17799 0 123
sp_cancel_adding_invoice 5863 5863 0 0.00 5 68141 796 0 0
sp_cancel_client_order 1813 1813 0 0.00 5 21193 359 0 0
sp_cancel_customer_reserve 575976 575976 0 0.00 1 21943 57 0 0
sp_cancel_pay_from_customer 705 705 0 0.00 3 6666 94 0 0
sp_cancel_pay_to_supplier 417 417 0 0.00 3 3036 65 0 0
sp_cancel_supplier_invoice 6545 6530 15 0.22 1 31686 871 0 15
sp_cancel_supplier_order 393 393 0 0.00 14 1079355 108235 0 0
sp_cancel_write_off 11755 11755 0 0.00 1 11946 112 0 0
sp_client_order 21465 21465 0 0.00 3 21162 346 0 0
sp_customer_reserve 477894 477894 0 0.00 0 60546 176 0 0
sp_fill_shopping_cart 33040 33040 0 0.00 1 17200 43 0 0
sp_fill_shopping_cart_clo_res 477873 477873 0 0.00 0 16029 13 0 0
sp_get_clo_for_invoice 5150 5150 0 0.00 0 16415 284 0 0
sp_kill_cost_storno 18740 18740 0 0.00 0 10650 57 0 0
sp_kill_qstorno_ret_qs2qd 1170630 1170630 0 0.00 0 31658 31 0 0
sp_kill_qty_storno 617980 617980 0 0.00 0 31663 68 0 0
sp_lock_selected_doc 21600 21600 0 0.00 0 6827 5 0 0
sp_make_cost_storno 29176 29176 0 0.00 0 17947 49 0 0
sp_multiply_rows_for_pdistr 29176 29176 0 0.00 0 9578 30 0 0
sp_multiply_rows_for_qdistr 21465 21465 0 0.00 0 11136 163 0 0
sp_pay_from_customer 7340 7340 0 0.00 4 12613 117 0 0
sp_pay_to_supplier 6186 6186 0 0.00 5 9943 109 0 0
sp_payment_common 13526 13526 0 0.00 1 12575 28 0 0
sp_qd_handle_on_cancel_clo 1813 1813 0 0.00 0 21183 326 0 0
sp_qd_handle_on_invoice_upd_sts 11013 11013 0 0.00 0 30761 337 0 0
sp_qd_handle_on_reserve_upd_sts 10500 10500 0 0.00 0 16802 65 0 0
sp_reserve_write_off 10500 10500 0 0.00 6 16813 179 0 0
sp_supplier_invoice 5770 5770 0 0.00 6 92742 3234 0 0
sp_supplier_order 5807 5807 0 0.00 5 29315 1302 0 0
srv_aggregate_perf_data 103 103 0 0.00 2783 126648 18119 0 0
srv_fill_mon_cache_memory 172 172 0 0.00 972 135460 29787 0 0
srv_find_qd_qs_mism 1095592 1095592 0 0.00 0 11706 5 0 0
srv_make_invnt_saldo 584 584 0 0.00 25 110327 1269 0 0
srv_make_money_saldo 785 785 0 0.00 0 9304 50 0 0
srv_recalc_idx_stat 4 4 0 0.00 157977 391203 274174 0 0
t$perf-abend:sp_add_invoice_to_stock 123 123 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5171 5171 0 0.00 0 12000 169 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 0 4349 139 0 0
t$perf-norm:sp_cancel_client_order 1813 1813 0 0.00 0 7723 18 0 0
t$perf-norm:sp_cancel_customer_reserve 721 721 0 0.00 0 6018 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 705 705 0 0.00 0 1753 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 417 417 0 0.00 0 2216 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 415 415 0 0.00 0 554 12 0 0
t$perf-norm:sp_cancel_supplier_order 393 393 0 0.00 0 20297 1651 0 0
t$perf-norm:sp_cancel_write_off 1078 1078 0 0.00 0 7888 19 0 0
t$perf-norm:sp_client_order 21465 21465 0 0.00 0 20578 20 0 0
t$perf-norm:sp_customer_reserve 1054 1054 0 0.00 0 10811 20 0 0
t$perf-norm:sp_pay_from_customer 7340 7340 0 0.00 0 10975 13 0 0
t$perf-norm:sp_pay_to_supplier 6186 6186 0 0.00 0 22941 13 0 0
t$perf-norm:sp_reserve_write_off 10500 10500 0 0.00 0 8043 12 0 0
t$perf-norm:sp_supplier_invoice 5770 5770 0 0.00 0 8266 20 0 0
t$perf-norm:sp_supplier_order 5807 5807 0 0.00 0 7205 19 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 363 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 3368 41 0 0
t$perf-norm:srv_make_invnt_saldo 584 584 0 0.00 0 13609 49 0 0
t$perf-norm:srv_make_money_saldo 785 785 0 0.00 0 2106 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 4 0 0
v_add_invoice_to_stock 10546 10300 246 2.33 0 5714 18 0 246
v_all_customers 39354 39354 0 0.00 0 18 1 0 0
v_all_suppliers 32282 32282 0 0.00 0 22 1 0 0
v_all_wares 42930 42930 0 0.00 0 33 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 3118 11 0 0
v_cancel_client_order 3626 3626 0 0.00 0 2902 8 0 0
v_cancel_customer_prepayment 1410 1410 0 0.00 0 2128 9 0 0
v_cancel_customer_reserve 1442 1442 0 0.00 0 2798 13 0 0
v_cancel_payment_to_supplier 834 834 0 0.00 0 488 3 0 0
v_cancel_supplier_invoice 860 830 30 3.48 0 1906 16 0 30
v_cancel_supplier_order 786 786 0 0.00 0 1818 5 0 0
v_cancel_write_off 2156 2156 0 0.00 0 1150 13 0 0
v_max_id_clo_ord 5806 5806 0 0.00 0 4676 3 0 0
v_max_id_clo_res 1054 1054 0 0.00 0 2358 16 0 0
v_max_id_ord_sup 5768 5768 0 0.00 0 10419 5 0 0
v_max_non_paid_invoice 1619 1619 0 0.00 0 346 2 0 0
v_max_non_paid_realizn 3830 3830 0 0.00 0 1342 3 0 0
v_min_id_clo_ord 5806 5806 0 0.00 0 5154 12 0 0
v_min_id_clo_res 1054 1054 0 0.00 0 1908 5 0 0
v_min_id_ord_sup 5768 5768 0 0.00 0 6141 10 0 0
v_min_non_paid_invoice 6186 6186 0 0.00 0 5668 15 0 0
v_min_non_paid_realizn 7340 7340 0 0.00 0 12572 19 0 0
v_our_firm 10596 10596 0 0.00 0 22 1 0 0
v_reserve_write_off 21000 21000 0 0.00 0 3871 6 0 0
x_lock_depdocs_on_canc_invoice 11978 11978 0 0.00 0 19237 122 0 0
x_lock_depdocs_on_canc_sup_ord 393 393 0 0.00 0 16992 442 0 0
x_make_qstorno_1000_1200 5807 5807 0 0.00 2 29301 1205 0 0
x_make_qstorno_1200_2000 5770 5770 0 0.00 3 92733 3085 0 0
x_make_qstorno_2100_3300 477894 477894 0 0.00 0 60531 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-11-2020 22:29:43 to 19-11-2020 22:29:47.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:07 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:14 13915 8192000000 10227099408 10529402880 884266256 9.742 71 57 115 0 906552048 2580736 19705056
19:57:39 28841 8192000000 10326770688 10641162240 1378937616 14.407 100 88 177 1 1411928768 4542064 28449088
19:58:16 32792 8192000000 10365502240 10688872448 1419982112 14.773 100 90 180 1 1456247664 6267952 29997600
19:58:59 21089 8192000000 10383743888 10712227840 1444074864 14.986 100 84 166 2 1478561808 7090864 27396080
19:59:29 16617 8192000000 10428968064 10758877184 1466507504 15.183 100 79 158 0 1499328048 7144224 25676320
19:59:54 25451 8192000000 10455282480 10787770368 1499572288 15.472 100 90 180 0 1537515392 8035920 29907184
20:00:28 6122 8192000000 10457739952 10793930752 1516108320 15.616 100 85 170 0 1551645824 8678880 26858624
20:00:46 21429 8192000000 10490696896 10830741504 1543139776 15.851 100 80 160 0 1577330624 9204432 24986416
20:01:18 10544 8192000000 10508867024 10855145472 1564614080 16.036 100 88 176 1 1601505664 9883552 27008032
20:01:38 18519 8192000000 10542914256 10893475840 1584711328 16.209 100 83 166 1 1620710720 10572720 25426672
20:02:04 12046 8192000000 10557035184 10910924800 1611667968 16.439 100 83 166 2 1648092048 11228880 25195200
20:02:25 10845 8192000000 10575078656 10931560448 1625287584 16.555 100 83 166 1 1661825248 11507376 25030288
20:02:48 10048 8192000000 10583701520 10945146880 1642758416 16.703 100 80 160 1 1679218320 12241968 24217936
20:03:07 9925 8192000000 10591122192 10956218368 1652724256 16.787 100 73 145 1 1686548288 12326176 21497856
20:03:30 11433 8192000000 10621990704 10987196416 1677382448 16.995 100 85 168 2 1714877968 12489344 25006176
20:03:52 10264 8192000000 10643183344 11012845568 1698188880 17.170 100 83 164 1 1735742560 13402528 24151152
20:04:10 7525 8192000000 10652804400 11025248256 1709626240 17.266 100 79 156 2 1744698192 12804288 22267664
20:04:25 7954 8192000000 10653586672 11023978496 1718070320 17.336 100 78 153 2 1751860048 12838592 20951136
20:04:40 5594 8192000000 10674372768 11045961728 1731345680 17.447 100 84 168 1 1768205728 13448288 23411760
20:04:52 6026 8192000000 10690663520 11063734272 1742810816 17.542 100 82 165 1 1779945344 13999264 23135264
20:05:06 4091 8192000000 10691389856 11067588608 1756608176 17.656 100 86 171 2 1794626800 14373200 23645424
20:05:17 3863 8192000000 10708123920 11086479360 1766107920 17.735 100 83 166 1 1803569376 14044000 23417456
20:05:28 3008 8192000000 10712136288 11089514496 1774677312 17.806 100 82 162 0 1809315712 12102048 22536352
20:05:38 3135 8192000000 10720409552 11098525696 1785695184 17.896 100 85 170 1 1822954000 12900064 24358752
20:05:47 3565 8192000000 10734115440 11115573248 1793741904 17.963 100 87 174 1 1832644448 14093344 24809200
20:05:58 1955 8192000000 10742655664 11120128000 1799099280 18.007 100 90 178 0 1839559488 14655072 25805136
20:06:06 2574 8192000000 10747137536 11128082432 1805092944 18.056 100 86 174 1 1843261280 14244448 23923888
20:06:15 3132 8192000000 10754621376 11137142784 1813716512 18.126 100 83 164 0 1851333504 14610080 23006912
20:06:25 4672 8192000000 10751550640 11138826240 1811775760 18.110 100 72 143 0 1843335584 12649184 18910640
20:06:36 4930 8192000000 10762600704 11149856768 1821188112 18.187 100 83 167 4 1856597984 12814240 22595632
20:06:47 1699 8192000000 10788750720 11171545088 1846447744 18.393 100 89 177 0 1883653104 12189472 25015888
20:06:55 1821 8192000000 10791003280 11175567360 1851061120 18.431 100 90 181 1 1889134336 11837680 26235536
20:07:03 1754 8192000000 10802560656 11185459200 1853170736 18.448 100 94 186 0 1893707504 13721168 26815600
20:07:11 1381 8192000000 10802654352 11192238080 1859899616 18.502 100 87 175 2 1897976288 13457248 24619424
20:07:19 1403 8192000000 10804040432 11193974784 1865623776 18.549 100 92 184 0 1904980624 12934912 26421936
20:07:26 1864 8192000000 10809977968 11199451136 1868132048 18.569 100 87 175 0 1904774752 12215152 24427552
20:07:34 24545 8192000000 10794893568 11201097728 1863954512 18.535 100 53 105 1 1889146000 9851040 15340448
20:08:05 13132 8192000000 10803727392 11204452352 1868367760 18.571 100 67 134 2 1895239664 8168656 18703248
20:08:25 13621 8192000000 10797006208 11210293248 1868041280 18.568 100 49 98 4 1896157712 14628080 13488352
20:08:45 8410 8192000000 10790293168 11203014656 1871418368 18.596 100 41 81 2 1889484704 6631264 11435072
20:09:00 3741 8192000000 10797080064 11211563008 1876097472 18.634 100 52 103 1 1898269056 7490080 14681504
20:09:11 8028 8192000000 10789518576 11214512128 1878820768 18.656 100 36 72 1 1896762256 7686400 10255088
20:09:30 8327 8192000000 10804915888 11223658496 1881672816 18.679 100 35 70 0 1903867440 11484304 10710320
20:09:48 5382 8192000000 10799685648 11218747392 1880568544 18.670 100 23 46 3 1894334096 6567664 7197888
20:10:02 5458 8192000000 10785224352 11215925248 1881896944 18.680 100 20 40 0 1893351856 5492336 5962576
20:10:17 6978 8192000000 10792642080 11224428544 1887712240 18.727 100 42 84 1 1907817920 7658592 12447088
20:10:31 12158 8192000000 10790801392 11227185152 1886061872 18.714 100 12 23 0 1895062448 5774976 3225600
20:10:54 7030 8192000000 10805667520 11229794304 1894782496 18.784 100 17 32 2 1904760176 5551008 4426672
20:11:08 4780 8192000000 10806349232 11235168256 1896691904 18.800 100 30 58 3 1911811392 6618528 8500960
20:11:19 5919 8192000000 10811107312 11236376576 1900644048 18.831 100 23 46 0 1913847760 6493392 6710320
20:11:32 6180 8192000000 10816909536 11245678592 1900986448 18.834 100 29 58 1 1916026496 6516304 8523744
20:11:46 10186 8192000000 10828199472 11246776320 1904810880 18.865 100 28 56 1 1919169168 7182064 7176224
20:12:04 64186 8192000000 10825057232 11258880000 1909966832 18.906 100 35 69 3 1924258800 4731872 9560096
20:13:18 3867 8192000000 10826351648 11262394368 1912198240 18.924 100 30 61 1 1927182720 6831776 8152704
20:13:28 5469 8192000000 10836575472 11268694016 1916522512 18.959 100 37 74 2 1934742656 7394800 10825344
20:13:40 5241 8192000000 10831162768 11265249280 1914762560 18.945 100 29 57 2 1929825776 7267088 7796128
20:13:51 5657 8192000000 10841644864 11271806976 1917284080 18.965 100 31 62 4 1931943712 5922912 8736720
20:14:03 7772 8192000000 10844108976 11274100736 1918132416 18.972 100 19 39 4 1928765472 5727136 4905920
20:14:18 5058 8192000000 10842835376 11276156928 1923237424 19.013 100 37 74 0 1940573280 6754816 10581040
20:14:29 7382 8192000000 10828044384 11267735552 1901546960 18.839 99 27 54 3 1914896912 5976928 7373024
20:14:42 6066 8192000000 10826984592 11265556480 1915358560 18.950 100 22 44 4 1927095968 5575072 6162336
20:14:55 12389 8192000000 10829479408 11270168576 1917790848 18.969 100 23 46 1 1930437536 6342944 6303744
20:15:15 5729 8192000000 10824809936 11261075456 1914858720 18.946 100 24 48 1 1927743744 6451632 6433392
20:15:28 7600 8192000000 10831395392 11270180864 1919794496 18.985 100 20 40 3 1931866144 5724688 6346960
20:15:42 6970 8192000000 10842587536 11276279808 1921666080 19.000 100 26 52 3 1936032000 6130944 8234976
20:15:55 8475 8192000000 10805888864 11244437504 1861578944 18.516 97 18 35 2 1872598864 5688784 5331136
20:16:11 9547 8192000000 10838616736 11276455936 1913304512 18.933 100 19 38 1 1924089600 5769312 5015776
20:16:30 61625 8192000000 10823469968 11235254272 1802014816 18.030 94 38 75 2 1819550432 5349488 12186128
20:17:38 21148 8192000000 10762760960 11192938496 1752210944 17.620 93 17 34 0 1762196784 4996688 4989152
20:18:07 5218 8192000000 10770560048 11180322816 1800307216 18.016 97 29 58 1 1813389872 5861984 7220672
20:18:19 4452 8192000000 10736158128 11150364672 1804428128 18.050 98 38 76 2 1822549968 7911872 10209968
20:18:32 4304 8192000000 10752277888 11159826432 1779380960 17.844 97 43 86 1 1799999472 8088944 12529568
20:18:45 6783 8192000000 10736315072 11156267008 1801939904 18.030 99 21 42 1 1812777104 4794544 6042656
20:18:58 5148 8192000000 10723960832 11141083136 1771552688 17.780 97 38 77 2 1788710880 5897840 11260352
20:19:11 7169 8192000000 10699004144 11115405312 1716810576 17.326 95 24 46 1 1729727152 6534368 6382208
20:19:25 6598 8192000000 10689112864 11096408064 1726643424 17.408 97 33 63 2 1746025808 10388608 8993776
20:19:39 7557 8192000000 10700699392 11112566784 1757048640 17.660 98 31 62 2 1773083904 6490544 9544720
20:19:53 5651 8192000000 10706997728 11114647552 1757030048 17.660 98 24 44 2 1768580640 5112832 6437760
20:20:07 8747 8192000000 10702129952 11106910208 1718980912 17.344 96 22 43 1 1732254144 5189536 8083696
20:20:24 7241 8192000000 10717976064 11129098240 1788136720 17.916 100 30 60 0 1802567600 5036912 9393968
20:20:39 13044 8192000000 10724800400 11138498560 1741038352 17.527 96 26 52 2 1753621648 5283088 7300208
20:21:00 51295 8192000000 10714175536 11119800320 1742916000 17.543 96 37 71 1 1757554608 4998832 9639776
20:22:12 14836 8192000000 10725482592 11151343616 1806184016 18.065 99 23 46 3 1818784016 6054880 6545120
20:22:37 5674 8192000000 10729010544 11157790720 1823964288 18.210 100 30 60 1 1839075936 6302512 8809136
20:22:50 5966 8192000000 10755660272 11177439232 1840924128 18.348 100 33 66 2 1857420928 7054688 9442112
20:23:03 7089 8192000000 10762154192 11183792128 1845113072 18.382 100 37 74 3 1862938176 6610000 11215104
20:23:17 6677 8192000000 10759348976 11181838336 1843496176 18.369 100 23 46 1 1856627536 6390128 6741232
20:23:31 5605 8192000000 10770917664 11190534144 1850986784 18.430 100 29 59 2 1864983488 6010672 7986032
20:23:48 7979 8192000000 10762778128 11196411904 1856494208 18.475 100 36 70 0 1874917440 6042816 12380416
20:24:06 14616 8192000000 10775754496 11202936832 1857072496 18.480 100 17 34 1 1867752144 5176016 5503632
20:24:28 8681 8192000000 10775882576 11203993600 1863543840 18.532 100 32 64 5 1877959408 5585504 8830064
20:24:44 8023 8192000000 10787949072 11212185600 1865688112 18.549 100 27 54 2 1878789360 4915712 8185536
20:25:00 8362 8192000000 10789149440 11211550720 1868848416 18.575 100 29 58 3 1882968496 5957936 8162144
20:25:15 9278 8192000000 10779472048 11212443648 1870168400 18.586 100 18 36 2 1880301344 5271344 4861600
20:25:30 8209 8192000000 10786296080 11218841600 1874225856 18.618 100 21 41 1 1886321200 5858928 6236416
20:25:45 16730 8192000000 10796447728 11219476480 1877138752 18.642 100 22 42 4 1889263792 6054896 6070144
20:26:08 69296 8192000000 10807369808 11232083968 1884149344 18.699 100 30 60 3 1897842544 5759552 7933648
20:27:36 37296 8192000000 10843301920 11260985344 1909366464 18.902 100 48 96 2 1930525968 8151520 13007984
20:28:22 22649 8192000000 10870483392 11282141184 1926637264 19.040 100 49 98 2 1952434832 11885904 13911664
20:28:55 18737 8192000000 10863335344 11289767936 1933531392 19.095 100 44 85 0 1957231552 11908400 11791760
20:29:21 31523 8192000000 10877251488 11305955328 1940064544 19.147 100 39 77 1 1962687568 11492640 11130384
20:30:05 7630 8192000000 10884149536 11306672128 1951790896 19.241 100 52 101 2 1980077488 13301488 14985104
20:30:21 20434 8192000000 10881455872 11313692672 1954325680 19.261 100 46 92 1 1982192144 13436672 14429792
20:30:50 13422 8192000000 10896403824 11320266752 1959269216 19.300 100 51 102 1 1987463680 12914176 15280288
20:31:14 9564 8192000000 10900215088 11329409024 1968939872 19.377 100 55 110 2 1998541696 13767872 15833952
20:31:47 22426 8192000000 10908514384 11343265792 1974333280 19.420 100 37 72 4 2003030192 17396112 11300800
20:32:22 7507 8192000000 10916448192 11349164032 1981571696 19.477 100 47 94 0 2012990528 17427760 13991072
20:32:42 18922 8192000000 10931950912 11361103872 1983597920 19.493 100 46 92 0 2015925680 18169968 14157792
20:33:19 23728 8192000000 10942662400 11373678592 1991168992 19.553 100 49 98 0 2029493040 23325472 14998576
20:33:55 21394 8192000000 10941477616 11373408256 1989939952 19.543 100 53 106 1 2032922096 26279520 16702624
20:34:30 8892 8192000000 10934256960 11376185344 1988496128 19.532 100 35 70 1 2022919504 23649296 10774080
20:34:48 6936 8192000000 10945537408 11379335168 1993815568 19.574 100 50 96 2 2030832720 22552512 14464640
20:35:02 17054 8192000000 10948727808 11383123968 2002411952 19.642 100 56 112 1 2042167744 22271360 17484432
20:35:30 9945 8192000000 10956676576 11388420096 2006176816 19.671 100 50 98 0 2043631936 22833776 14621344
20:35:47 5623 8192000000 10955977088 11392200704 2008432480 19.689 100 57 113 1 2049478656 24027552 17018624
20:36:01 2927 8192000000 10966771024 11391258624 2008459456 19.689 100 73 142 1 2052894864 23843616 20591792
20:36:13 5019 8192000000 10975159488 11396333568 2016723872 19.754 100 76 150 1 2064004928 25666928 21614128
20:36:33 2593 8192000000 10971199280 11388870656 2004894624 19.661 99 76 151 3 2054807056 26839040 23073392
20:36:43 7044 8192000000 10972611200 11400441856 2014901424 19.740 100 72 143 2 2061871616 26129280 20840912
20:37:05 6502 8192000000 10981160160 11408711680 2017553824 19.761 100 73 146 0 2067521616 28556304 21411488
20:37:18 2263 8192000000 10988572896 11415179264 2027711952 19.841 100 79 156 1 2080418208 29947360 22758896
20:37:31 2739 8192000000 10987129392 11415408640 2024810544 19.818 100 78 157 2 2077674096 28611904 24251648
20:37:41 6062 8192000000 10991943760 11417403392 2025732992 19.825 100 72 142 1 2076479456 28997008 21749456
20:37:54 3067 8192000000 10997752752 11410165760 2016075952 19.749 100 85 169 3 2072823664 30727472 26020240
20:38:04 3138 8192000000 10990622624 11411329024 2018908048 19.772 100 75 149 0 2073315280 31116128 23291104
20:38:15 6354 8192000000 10978217264 11408973824 2020902112 19.787 100 65 127 0 2070325152 30440336 18982704
20:38:29 5004 8192000000 10983762032 11410989056 2016651888 19.754 100 75 150 0 2073474096 32911552 23910656
20:38:41 3542 8192000000 10990999440 11411849216 2017597024 19.761 100 82 164 5 2076292480 33663952 25031504
20:38:52 3500 8192000000 10993567856 11415134208 2019515936 19.776 100 78 152 2 2077424544 34416128 23492480
20:39:02 2080 8192000000 10991479168 11405643776 2011618976 19.714 100 90 181 3 2074900608 35767616 27514016
20:39:10 3348 8192000000 10988008912 11403075584 2007585296 19.683 100 86 171 1 2069653632 36500544 25567792
20:39:20 1615 8192000000 10978728176 11391995904 1998631328 19.612 100 86 167 1 2061241792 36073056 26537408
20:39:30 4403 8192000000 10963081520 11385081856 1993390896 19.571 100 79 153 0 2049002128 32442176 23169056
20:39:43 1755 8192000000 10965944384 11374870528 1987875216 19.527 99 89 175 0 2048886688 34600368 26411104
20:39:54 4510 8192000000 10980407456 11397554176 1989903632 19.543 99 82 164 1 2050640032 35527408 25208992
20:40:10 1942 8192000000 10954584288 11368996864 1947809184 19.209 97 77 154 0 2007444528 35816640 23818704
20:40:20 1824 8192000000 10963587248 11374362624 1981265312 19.475 100 89 180 1 2043734752 35090976 27378464
20:40:29 3131 8192000000 10931269456 11341221888 1954145008 19.259 99 78 152 4 2011433568 34434800 22853760
20:40:42 6113 8192000000 10929636448 11348643840 1928348944 19.054 98 78 156 0 1988650416 35945376 24356096
20:40:56 1505 8192000000 10944489424 11355865088 1961699904 19.320 100 91 182 2 2027104832 36751680 28653248
20:41:05 2617 8192000000 10916724960 11328737280 1921381008 18.998 98 83 165 0 1984950752 37612576 25957168
20:41:15 2796 8192000000 10926096400 11335786496 1934852304 19.106 99 82 163 3 1996292048 36698032 24741712
20:41:24 3441 8192000000 10915407600 11323314176 1929326880 19.061 99 77 153 1 1991654656 38531200 23796576
20:41:36 8520 8192000000 10934468016 11348656128 1953110000 19.251 100 80 159 1 2017975696 40424064 24441632
20:41:58 4214 8192000000 10939305712 11360923648 1964764032 19.344 100 71 142 0 2024616608 37972256 21880320
20:42:09 4539 8192000000 10936375456 11358916608 1950224576 19.228 99 75 152 1 2012674592 38313152 24136864
20:42:21 1724 8192000000 10952267648 11369590784 1974053056 19.418 100 86 163 5 2033254544 34558464 24643024
20:42:30 4166 8192000000 10955552368 11367088128 1974689936 19.423 100 87 174 0 2037235072 35196944 27348192
20:42:41 971 8192000000 10959124864 11368480768 1973826464 19.416 100 85 171 1 2036083584 36155296 26101824
20:42:49 2572 8192000000 10941932544 11352539136 1950723392 19.232 99 83 167 0 2015977008 39336112 25917504
20:42:59 2495 8192000000 10961317200 11366531072 1955497360 19.270 99 90 180 1 2024405040 41467392 27440288
20:43:08 5650 8192000000 10959050448 11370119168 1973762784 19.415 100 85 171 2 2042480080 42615440 26101856
20:43:21 1902 8192000000 10941032256 11342966784 1945586288 19.191 99 91 181 2 2016719408 42974272 28158848
20:43:30 1564 8192000000 10948465920 11354750976 1959773952 19.304 100 87 173 3 2029632032 43523568 26334512
20:43:39 2420 8192000000 10940116416 11348905984 1952390992 19.246 100 81 162 0 2020382816 42851200 25140624
20:43:54 6853 8192000000 10935893024 11353075712 1951316640 19.237 100 76 150 2 2019214224 44087024 23810560
20:44:13 3795 8192000000 10938492080 11360731136 1959320336 19.301 100 74 148 0 2029243920 45965248 23958336
20:44:31 9928 8192000000 10937482000 11364450304 1953131728 19.251 100 51 102 0 2016420208 46350464 16938016
20:44:50 5409 8192000000 10945183728 11369140224 1946181136 19.196 99 60 120 0 2013136944 47869328 19086480
20:45:05 3066 8192000000 10962570624 11376820224 1968016192 19.370 100 77 152 2 2041132944 49076224 24040528
20:45:17 3740 8192000000 10957738016 11374125056 1964178416 19.339 100 81 160 1 2039582976 50388976 25015584
20:45:29 985 8192000000 10953634512 11364728832 1950509536 19.231 99 82 162 1 2028052336 51559200 25983600
20:45:36 1561 8192000000 10967224752 11379642368 1965654032 19.351 100 87 174 3 2043144000 50726720 26763248
20:45:45 2473 8192000000 10942848752 11351285760 1943057728 19.171 99 81 161 2 2020391504 51145472 26188304
20:45:53 2334 8192000000 10947593200 11362131968 1947913248 19.210 100 83 164 2 2025442976 51484896 26044832
20:46:03 27936 8192000000 10882814704 11330605056 1904535408 18.863 98 33 66 0 1954624112 38632608 11456096
20:46:39 26203 8192000000 10901315776 11340070912 1915639312 18.952 99 40 82 3 1966507584 37387824 13480448
20:47:15 9646 8192000000 10910754560 11340730368 1914542752 18.943 99 48 96 0 1976186224 46054400 15589072
20:47:31 10890 8192000000 10913530784 11351494656 1938889920 19.138 100 43 85 2 1998845136 45661392 14293824
20:47:54 4718 8192000000 10911979648 11349979136 1932114704 19.084 100 42 84 2 1996646304 49948032 14583568
20:48:05 12661 8192000000 10909829808 11349897216 1920774544 18.993 99 37 74 2 1981363248 48252848 12335856
20:48:24 16473 8192000000 10915114352 11359776768 1944328320 19.181 100 30 60 1 1994422880 40507184 9587376
20:48:51 10240 8192000000 10917332064 11355193344 1950644112 19.232 100 33 64 1 1996797440 34812512 11340816
20:49:09 12057 8192000000 10918173632 11365810176 1961223472 19.316 100 35 70 1 2006940688 34834144 10883072
20:49:31 12916 8192000000 10924885904 11374669824 1967330176 19.364 100 39 78 0 2016843168 37333632 12179360
20:49:52 9284 8192000000 10933051632 11379793920 1965508560 19.350 100 41 82 0 2015719632 37094192 13116880
20:50:18 13234 8192000000 10933146688 11376197632 1965093936 19.347 100 34 69 1 2021988544 45720544 11174064
20:50:59 28214 8192000000 10938158928 11387457536 1946834608 19.201 99 32 64 0 2005885776 48080048 10971120
20:51:35 8866 8192000000 10940678272 11387453440 1961283536 19.316 100 26 52 0 2022582240 52306448 8992256
20:51:51 12020 8192000000 10941992192 11391021056 1964911968 19.345 100 38 76 1 2024211056 46152992 13146096
20:52:17 22332 8192000000 10928667216 11376934912 1937802032 19.129 99 28 56 1 1998087856 50332688 9953136
20:53:13 14514 8192000000 10906876864 11361234944 1915495696 18.951 98 24 48 0 1964910960 41584240 7831024
20:53:40 28316 8192000000 10886386288 11331584000 1897094000 18.803 98 17 33 1 1938987024 35974288 5918736
20:54:38 40606 8192000000 10895947328 11370381312 1935206496 19.108 100 18 32 1 1981030656 39237456 6586704
20:55:26 66106 8192000000 10867725472 11326459904 1918519712 18.975 99 8 16 0 1935782880 15446272 1816896
20:56:38 58029 8192000000 10890208448 11333521408 1927415952 19.046 99 43 84 3 1948880208 9934480 11529776
20:58:05 75565 8192000000 10890150672 11346628608 1908523424 18.895 97 32 63 0 1930942864 13930304 8489136
20:59:31 81893 8192000000 10890615216 11341287424 1938273632 19.133 99 35 70 1 1963230304 14515728 10440944
21:00:59 135460 8192000000 10905377008 11362807808 1929613328 19.064 98 16 32 0 1945736176 11768368 4354480
21:03:22 42382 8192000000 10923777472 11374440448 1986506768 19.516 100 44 88 0 2009675424 11091088 12077568
21:04:13 85928 8192000000 10886808032 11356684288 1925401056 19.030 97 52 99 4 1951051504 11518320 14132128
21:06:23 1908 8192000000 10920376880 11350982656 1971856832 19.400 100 46 93 2 1992929872 8129664 12943376
21:06:31 8011 8192000000 10944284352 11375878144 1987679600 19.525 100 73 143 2 2019932704 11454752 20798352
21:06:48 36112 8192000000 10912220000 11381174272 1989158400 19.537 100 47 93 2 2014381984 12003056 13220528
21:07:43 32671 8192000000 10933496624 11379019776 1984656976 19.502 100 35 69 1 2004796000 10072784 10066240
21:08:47 36683 8192000000 10894798016 11362013184 1943340480 19.173 98 34 68 3 1965167424 12235696 9591248
21:09:46 46281 8192000000 10886116384 11360178176 1946209136 19.196 99 11 22 0 1962333024 12673920 3449968
21:10:46 46115 8192000000 10892749168 11360317440 1958952480 19.298 99 12 24 1 1970969248 8490144 3526624
21:12:01 28973 8192000000 10902136736 11376861184 1975423344 19.428 100 10 20 0 1986686944 8412912 2850688
21:12:36 19390 8192000000 10895440432 11361587200 1941529696 19.159 98 14 28 1 1952583632 7023392 4030544
21:13:02 43858 8192000000 10891450512 11364700160 1954165088 19.260 99 15 30 1 1965761280 7610752 3985440
21:15:25 49351 8192000000 10892481792 11368177664 1976616992 19.438 100 14 28 2 1990160928 9296144 4247792
21:16:25 27456 8192000000 10894868368 11368230912 1965746688 19.352 99 16 32 1 1979395616 8983280 4665648
21:17:02 6307 8192000000 10890469648 11357356032 1971948064 19.401 100 24 48 0 1986343120 6679360 7715696
21:17:25 30493 8192000000 10895025808 11358044160 1970543728 19.390 100 27 54 2 1987344432 9023232 7777472
21:18:03 43891 8192000000 10884972800 11362213888 1951947648 19.242 99 14 28 1 1967353600 10201008 5204944
21:19:00 48193 8192000000 10888509184 11372011520 1968428064 19.373 100 13 26 1 1984266288 11996384 3841840
21:20:14 24346 8192000000 10879772288 11372994560 1951036544 19.235 99 10 20 1 1964085920 10322144 2727232
21:20:45 46085 8192000000 10899234512 11372740608 1973290256 19.412 100 18 37 2 1991725872 12442944 5992672
21:21:54 39783 8192000000 10918897584 11387760640 1965704432 19.351 99 15 30 0 1984002896 14010640 4287824
21:22:45 44728 8192000000 10919648992 11394752512 1974755840 19.423 99 21 42 1 1997494944 17040416 5698688
21:23:40 34557 8192000000 10915084016 11390889984 1971347168 19.396 99 17 34 1 1992171280 15794928 5029184
21:24:25 33193 8192000000 10903435936 11362820096 1926785056 19.041 97 19 38 0 1948279696 15629120 5865520
21:25:05 35861 8192000000 10882769600 11345309696 1912266304 18.925 97 19 36 0 1929499840 12153488 5080048
21:25:53 46961 8192000000 10884186288 11344162816 1906794288 18.881 97 21 42 0 1927810112 15150160 5865664
21:27:59 64923 8192000000 10890010272 11345432576 1902227424 18.844 97 24 46 3 1919841904 11255120 6359360
21:29:22 46993 8192000000 10882949296 11345956864 1902742528 18.848 97 19 38 1 1921074512 12664240 5667744
21:30:45 25975 8192000000 10854474096 11303845888 1887698112 18.727 98 27 55 0 1904477040 9462256 7316672
21:31:19 35805 8192000000 10847331840 11308482560 1868373440 18.571 97 21 42 0 1886824352 12511424 5939488
21:32:03 60885 8192000000 10894906144 11336843264 1911392880 18.918 98 32 64 1 1933594016 13530112 8671024
21:33:38 50918 8192000000 10863040736 11333652480 1930234736 19.069 100 15 30 1 1950488288 15900736 4352816
21:34:47 94614 8192000000 10857376976 11337039872 1900103696 18.827 98 8 16 1 1921236080 18980000 2152384
21:36:27 78610 8192000000 10842451760 11294531584 1852789408 18.445 96 21 42 0 1866919040 7235488 6894144
21:37:59 44293 8192000000 10883599296 11317489664 1885483424 18.709 97 43 86 2 1909047744 12174144 11390176
21:38:52 45021 8192000000 10871121392 11325005824 1921416320 18.998 99 41 82 0 1944684384 12050672 11217392
21:39:46 3776 8192000000 10880697872 11325923328 1942495856 19.167 100 57 114 1 1970192032 11964480 15731696
21:39:57 33360 8192000000 10858884720 11313639424 1917723952 18.969 99 36 72 0 1940119568 11805904 10589712
21:40:44 42835 8192000000 10864669136 11330031616 1939200944 19.140 100 27 54 1 1963098544 16520752 7376848
21:41:33 33398 8192000000 10839744960 11307036672 1899088096 18.819 98 11 22 1 1912087392 9951040 3048256
21:42:40 65380 8192000000 10829280736 11293028352 1817543264 18.158 94 13 26 0 1832641616 11262928 3835424
21:43:52 74501 8192000000 10821397744 11288920064 1894156224 18.779 99 19 38 1 1911641248 11890032 5594992
21:46:07 62592 8192000000 10835671600 11304337408 1880837568 18.672 98 17 34 0 1901310944 15102016 5371360
21:47:20 59713 8192000000 10859096208 11307307008 1861570272 18.516 97 18 36 0 1874491488 7727008 5194208
21:48:29 68842 8192000000 10842118496 11312275456 1893896368 18.777 99 7 14 0 1909932752 14184576 1851808
21:49:56 90402 8192000000 10848188624 11322871808 1887843136 18.728 98 14 28 3 1906699792 14580976 4275680
21:51:34 70922 8192000000 10842529584 11301097472 1852425056 18.442 96 13 26 0 1868382256 12301232 3655968
21:52:56 54652 8192000000 10846081120 11309977600 1900017152 18.826 99 12 24 0 1912617360 9354544 3245664
21:54:00 49543 8192000000 10882795888 11333419008 1937738336 19.129 100 30 60 1 1957724880 11460672 8525872
21:54:59 30739 8192000000 10880719184 11332997120 1922871552 19.010 99 37 73 0 1942065104 9697360 9496192
21:55:37 58006 8192000000 10873639840 11345678336 1944802320 19.185 100 21 42 1 1961231648 10862896 5566432
21:56:42 59009 8192000000 10893060048 11358892032 1936576848 19.119 99 26 52 1 1953186944 9653520 6956576
21:57:55 46554 8192000000 10905472560 11362598912 1933527760 19.095 98 29 57 2 1950598416 9378336 7692320
21:58:51 65401 8192000000 10888679168 11340054528 1902282624 18.845 97 20 40 2 1918129136 10713584 5132928
22:00:03 31842 8192000000 10890293888 11356114944 1956457872 19.278 100 21 42 1 1974353072 11689232 6205968
22:00:42 123196 8192000000 10876006592 11343134720 1930825760 19.073 98 15 30 0 1951472736 15836416 4810560
22:03:15 34122 8192000000 10891501952 11358064640 1941129744 19.156 99 21 42 1 1961509872 14388032 5992096
22:04:04 53998 8192000000 10882108192 11353948160 1930503536 19.071 98 22 44 1 1952033216 15473120 6056560
22:05:07 36891 8192000000 10886729024 11360395264 1966823440 19.360 100 7 14 1 1978905984 10485040 1597504
22:05:50 16218 8192000000 10887744240 11356913664 1965634320 19.351 100 7 14 0 1978497776 11130896 1732560
22:06:13 47280 8192000000 10898528208 11380002816 1967777328 19.368 100 6 12 0 1984523952 15367424 1379200
22:07:07 37789 8192000000 10903428560 11386990592 1957103856 19.283 99 6 11 0 1975230416 16648752 1477808
22:07:51 36837 8192000000 10894661232 11369811968 1953213184 19.252 99 7 14 2 1975969600 20650560 2105856
22:08:38 68017 8192000000 10887517904 11350953984 1921388240 18.998 97 12 24 0 1936000224 11648544 2963440
22:10:07 57397 8192000000 10912999216 11382296576 1964170880 19.339 99 25 50 1 1985326448 14420384 6735184
22:11:17 69551 8192000000 10918223632 11376025600 1921198768 18.996 97 13 26 0 1937567152 12643760 3724624
22:12:38 82470 8192000000 10906670688 11367968768 1917159488 18.964 97 17 32 2 1936620768 14990992 4470288
22:14:08 57733 8192000000 10891017632 11348586496 1847451232 18.401 94 15 30 0 1871099024 19340048 4307744
22:15:17 85014 8192000000 10874648064 11349438464 1920008320 18.987 99 9 18 0 1950906736 27797904 3100512
22:16:48 77291 8192000000 10855627088 11328434176 1826361072 18.230 94 7 14 0 1840125312 12116896 1647344
22:18:13 65615 8192000000 10856954304 11312431104 1864893968 18.543 97 15 30 0 1885222512 16217136 4111408
22:19:32 18950 8192000000 10869279712 11322597376 1920527456 18.991 99 32 60 1 1938094032 7785552 9781024
22:20:05 65030 8192000000 10870398464 11337469952 1926784624 19.041 99 19 38 1 1945315280 12797904 5732752
22:21:19 46396 8192000000 10882471840 11339243520 1910733648 18.913 98 21 42 0 1926319616 9790688 5795280
22:22:13 111459 8192000000 10873226592 11357753344 1910394096 18.910 98 8 16 0 1928680832 16080656 2206080
22:24:14 56244 8192000000 10859412720 11339894784 1874737856 18.623 96 12 22 1 1888481008 9887312 3855840
22:25:16 54873 8192000000 10869518928 11334668288 1924698528 19.024 99 16 32 1 1946216592 17248960 4269104
22:26:18 15169 8192000000 10859028288 11330527232 1930401168 19.070 100 13 26 1 1949046864 14862128 3783568
22:26:48 23752 8192000000 9634092656 9968365568 764573200 8.536 40 5 10 0 772440336 6443504 1423632

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 19-11-2020 22:29:49 to 19-11-2020 22:30:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 123 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-11-2020 22:30:22 to 19-11-2020 22:30:24.

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          246886
MON$OLDEST_ACTIVE               246887
MON$OLDEST_SNAPSHOT             246887
MON$NEXT_TRANSACTION            246887
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                       2045664
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.33391 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33391 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33391 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33391 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 ---
:116: 
:117: mscs-test-161.budzdorov.ru    Thu Nov 19 22:27:35 2020
:118:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:119: 
:120: 
:121: mscs-test-161.budzdorov.ru    Thu Nov 19 22:27:35 2020
:122:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:123: 
--- end of diff output ---

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

19.11.20 22:30:25. 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
2020-11-19 22:30:27 No severe PSQL-related problems occured
19.11.20 22:30:28. End of report.