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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17401076 kB
MemAvailable 31425960 kB
Buffers 0 kB
Cached 14257008 kB
SwapCached 2832 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.7
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-07 19:27:02
DTS_END                         2020-11-07 19:27:02.4860
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/54088
TRN_ID                          246991
ATT_ID                          701
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: 9323.57 20511 1118828
customer order: creation 180.41 355 21649
customer order: refuse 15.43 351 1852
order to supplier: creation 46.84 1241 5621
order to supplier: removal 3.61 85408 433
invoice (draft): creation 47.98 3408 5758
invoice (draft): removal 53.00 728 6360
invoice accept: apply 42.40 16254 5088
invoice accept: cancel 46.93 779 5631
customer reserve: creation 3972.67 158 476720
customer reserve: removal 4615.63 53 553875
realization accept: apply 87.02 164 10442
realization accept: cancel 77.29 100 9275
payment from customer: creation 61.23 105 7348
payment from customer: removal 5.94 88 713
payment to supplier: creation 51.48 111 6178
payment to supplier: removal 3.47 97 416
service: total inventory turnovers 4.73 995 568
service: total monetary turnovers 6.56 28 787
service: aggregate perf. data 0.92 15966 110
service: refresh index statistics 0.03 283831 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-11-2020 19:27:58 to 07-11-2020 19:28:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1928
TEST_TIME 2 3059
TEST_TIME 3 3174
TEST_TIME 4 4100
TEST_TIME 5 4633
TEST_TIME 6 4907
TEST_TIME 7 4703
TEST_TIME 8 5207
TEST_TIME 9 5286
TEST_TIME 10 5391
TEST_TIME 11 5628
TEST_TIME 12 5916
TEST_TIME 13 6175
TEST_TIME 14 6595
TEST_TIME 15 7458
TEST_TIME 16 7772
TEST_TIME 17 8340
TEST_TIME 18 8743
TEST_TIME 19 8675
TEST_TIME 20 8550
TEST_TIME 21 9009
TEST_TIME 22 9422
TEST_TIME 23 9701
TEST_TIME 24 10330
TEST_TIME 25 10594
TEST_TIME 26 10560
TEST_TIME 27 10538
TEST_TIME 28 10545
TEST_TIME 29 10244
TEST_TIME 30 10020
TEST_TIME 31 10047
TEST_TIME 32 10192
TEST_TIME 33 10112
TEST_TIME 34 9939
TEST_TIME 35 9903
TEST_TIME 36 9889
TEST_TIME 37 9937
TEST_TIME 38 9952
TEST_TIME 39 9853
TEST_TIME 40 9782
TEST_TIME 41 9818
TEST_TIME 42 9766
TEST_TIME 43 9679
TEST_TIME 44 9858
TEST_TIME 45 9830
TEST_TIME 46 9782
TEST_TIME 47 9885
TEST_TIME 48 9895
TEST_TIME 49 9960
TEST_TIME 50 9904
TEST_TIME 51 9910
TEST_TIME 52 9942
TEST_TIME 53 9919
TEST_TIME 54 9957
TEST_TIME 55 9978
TEST_TIME 56 10091
TEST_TIME 57 10126
TEST_TIME 58 10073
TEST_TIME 59 9917
TEST_TIME 60 9889
TEST_TIME 61 9812
TEST_TIME 62 9823
TEST_TIME 63 9764
TEST_TIME 64 9690
TEST_TIME 65 9635
TEST_TIME 66 9544
TEST_TIME 67 9526
TEST_TIME 68 9465
TEST_TIME 69 9622
TEST_TIME 70 9645
TEST_TIME 71 9686
TEST_TIME 72 9624
TEST_TIME 73 9678
TEST_TIME 74 9629
TEST_TIME 75 9693
TEST_TIME 76 9683
TEST_TIME 77 9744
TEST_TIME 78 9718
TEST_TIME 79 9700
TEST_TIME 80 9707
TEST_TIME 81 9605
TEST_TIME 82 9648
TEST_TIME 83 9604
TEST_TIME 84 9558
TEST_TIME 85 9511
TEST_TIME 86 9466
TEST_TIME 87 9442
TEST_TIME 88 9447
TEST_TIME 89 9429
TEST_TIME 90 9461
TEST_TIME 91 9516
TEST_TIME 92 9484
TEST_TIME 93 9444
TEST_TIME 94 9527
TEST_TIME 95 9527
TEST_TIME 96 9527
TEST_TIME 97 9514
TEST_TIME 98 9584
TEST_TIME 99 9538
TEST_TIME 100 9605
TEST_TIME 101 9579
TEST_TIME 102 9578
TEST_TIME 103 9624
TEST_TIME 104 9589
TEST_TIME 105 9536
TEST_TIME 106 9493
TEST_TIME 107 9481
TEST_TIME 108 9513
TEST_TIME 109 9449
TEST_TIME 110 9439
TEST_TIME 111 9433
TEST_TIME 112 9387
TEST_TIME 113 9370
TEST_TIME 114 9369
TEST_TIME 115 9361
TEST_TIME 116 9339
TEST_TIME 117 9333
TEST_TIME 118 9374
TEST_TIME 119 9402
TEST_TIME 120 9325

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 07-11-2020 19:28:01 to 07-11-2020 19:28:05.

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 1560309 1560309 0 0.00 0 18262 5 0 0
doc_list_biud 1560304 1560304 0 0.00 0 55660 24 0 0
sp_add_invoice_to_stock 5194 5088 106 2.04 20 166808 16255 0 106
sp_cancel_adding_invoice 5631 5631 0 0.00 5 69663 779 0 0
sp_cancel_client_order 1852 1852 0 0.00 4 9765 352 0 0
sp_cancel_customer_reserve 553875 553875 0 0.00 1 41018 53 0 0
sp_cancel_pay_from_customer 713 713 0 0.00 2 6451 89 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 2 5048 98 0 0
sp_cancel_supplier_invoice 6371 6360 11 0.17 1 55662 729 0 11
sp_cancel_supplier_order 433 433 0 0.00 11 883374 85408 0 0
sp_cancel_write_off 9275 9275 0 0.00 1 12559 101 0 0
sp_client_order 21649 21649 0 0.00 3 36114 356 0 0
sp_customer_reserve 476720 476720 0 0.00 0 70841 159 0 0
sp_fill_shopping_cart 33012 33012 0 0.00 1 14629 34 0 0
sp_fill_shopping_cart_clo_res 476713 476713 0 0.00 0 20733 13 0 0
sp_get_clo_for_invoice 5081 5081 0 0.00 0 35750 326 0 0
sp_kill_cost_storno 16035 16035 0 0.00 0 5104 47 0 0
sp_kill_qstorno_ret_qs2qd 1123818 1123818 0 0.00 0 55660 29 0 0
sp_kill_qty_storno 592946 592946 0 0.00 0 55660 63 0 0
sp_lock_selected_doc 21504 21504 0 0.00 0 8941 8 0 0
sp_make_cost_storno 29049 29049 0 0.00 0 18248 46 0 0
sp_multiply_rows_for_pdistr 29044 29044 0 0.00 0 6570 23 0 0
sp_multiply_rows_for_qdistr 21649 21649 0 0.00 0 22022 169 0 0
sp_pay_from_customer 7348 7348 0 0.00 4 14045 106 0 0
sp_pay_to_supplier 6178 6178 0 0.00 4 16256 111 0 0
sp_payment_common 13524 13524 0 0.00 1 9505 22 0 0
sp_qd_handle_on_cancel_clo 1852 1852 0 0.00 0 9759 315 0 0
sp_qd_handle_on_invoice_upd_sts 10711 10711 0 0.00 0 52026 323 0 0
sp_qd_handle_on_reserve_upd_sts 10440 10440 0 0.00 0 33862 55 0 0
sp_reserve_write_off 10442 10442 0 0.00 6 34724 164 0 0
sp_supplier_invoice 5758 5758 0 0.00 6 91754 3408 0 0
sp_supplier_order 5621 5621 0 0.00 5 29755 1241 0 0
srv_aggregate_perf_data 110 110 0 0.00 2596 119872 15966 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1317 116477 34452 0 0
srv_find_qd_qs_mism 1069305 1069305 0 0.00 0 14069 5 0 0
srv_make_invnt_saldo 568 568 0 0.00 33 42438 996 0 0
srv_make_money_saldo 787 787 0 0.00 0 4608 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 186895 512118 283831 0 0
t$perf-abend:sp_add_invoice_to_stock 106 106 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5088 5088 0 0.00 0 21569 170 0 0
t$perf-norm:sp_cancel_adding_invoice 416 416 0 0.00 0 9149 111 0 0
t$perf-norm:sp_cancel_client_order 1852 1852 0 0.00 0 7760 16 0 0
t$perf-norm:sp_cancel_customer_reserve 697 697 0 0.00 0 6856 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 713 713 0 0.00 0 667 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 3354 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 431 431 0 0.00 0 3278 31 0 0
t$perf-norm:sp_cancel_supplier_order 433 433 0 0.00 0 21794 1454 0 0
t$perf-norm:sp_cancel_write_off 1026 1026 0 0.00 0 1297 6 0 0
t$perf-norm:sp_client_order 21649 21649 0 0.00 0 10149 17 0 0
t$perf-norm:sp_customer_reserve 1051 1051 0 0.00 0 1241 9 0 0
t$perf-norm:sp_pay_from_customer 7348 7348 0 0.00 0 9866 11 0 0
t$perf-norm:sp_pay_to_supplier 6178 6178 0 0.00 0 5829 10 0 0
t$perf-norm:sp_reserve_write_off 10442 10442 0 0.00 0 13236 8 0 0
t$perf-norm:sp_supplier_invoice 5758 5758 0 0.00 0 7890 19 0 0
t$perf-norm:sp_supplier_order 5621 5621 0 0.00 0 11803 21 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 192 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 1295 9 0 0
t$perf-norm:srv_make_invnt_saldo 568 568 0 0.00 0 2053 22 0 0
t$perf-norm:srv_make_money_saldo 787 787 0 0.00 0 1039 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10372 10160 212 2.04 0 6557 19 0 212
v_all_customers 39328 39328 0 0.00 0 15 1 0 0
v_all_suppliers 31828 31828 0 0.00 0 22 1 0 0
v_all_wares 43298 43298 0 0.00 0 108 1 0 0
v_cancel_adding_invoice 832 832 0 0.00 0 603 6 0 0
v_cancel_client_order 3704 3704 0 0.00 0 4620 10 0 0
v_cancel_customer_prepayment 1426 1426 0 0.00 0 3097 7 0 0
v_cancel_customer_reserve 1394 1394 0 0.00 0 1785 4 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 4463 8 0 0
v_cancel_supplier_invoice 884 862 22 2.48 0 3146 18 0 22
v_cancel_supplier_order 866 866 0 0.00 0 993 5 0 0
v_cancel_write_off 2052 2052 0 0.00 0 2696 14 0 0
v_max_id_clo_ord 5621 5621 0 0.00 0 3530 2 0 0
v_max_id_clo_res 1051 1051 0 0.00 0 2039 18 0 0
v_max_id_ord_sup 5742 5742 0 0.00 0 6644 6 0 0
v_max_non_paid_invoice 1626 1626 0 0.00 0 673 2 0 0
v_max_non_paid_realizn 3983 3983 0 0.00 0 849 3 0 0
v_min_id_clo_ord 5621 5621 0 0.00 0 2615 5 0 0
v_min_id_clo_res 1051 1051 0 0.00 0 4463 13 0 0
v_min_id_ord_sup 5742 5742 0 0.00 0 6675 5 0 0
v_min_non_paid_invoice 6177 6177 0 0.00 0 5482 11 0 0
v_min_non_paid_realizn 7347 7347 0 0.00 0 3081 12 0 0
v_our_firm 10698 10698 0 0.00 0 11 1 0 0
v_reserve_write_off 20880 20880 0 0.00 0 7333 9 0 0
x_lock_depdocs_on_canc_invoice 11560 11560 0 0.00 0 11916 102 0 0
x_lock_depdocs_on_canc_sup_ord 433 433 0 0.00 0 10501 330 0 0
x_make_qstorno_1000_1200 5621 5621 0 0.00 1 29736 1168 0 0
x_make_qstorno_1200_2000 5758 5758 0 0.00 3 91579 3283 0 0
x_make_qstorno_2100_3300 476720 476720 0 0.00 0 70838 143 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-11-2020 19:28:06 to 07-11-2020 19:28:10.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:06 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:12 8838 8192000000 10171948288 10470428672 871084304 9.611 70 52 108 1 891217760 2454752 17678704
16:57:28 17905 8192000000 10308676208 10620821504 1344798688 14.101 100 81 162 0 1376046672 4263488 26984496
16:57:55 18494 8192000000 10352291504 10670346240 1407275776 14.660 100 89 178 0 1446126512 9807904 29042832
16:58:26 20158 8192000000 10382153344 10703843328 1426746256 14.832 100 88 176 1 1462059008 6392304 28920448
16:58:58 20663 8192000000 10404013792 10736087040 1465446816 15.174 100 81 162 0 1498227552 6659920 26120816
16:59:33 14544 8192000000 10433899568 10765459456 1493437648 15.419 100 87 174 0 1529492032 7757552 28296832
17:00:03 15095 8192000000 10452099456 10785517568 1509135056 15.556 100 86 172 0 1545181328 8348416 27697856
17:00:34 19426 8192000000 10473016192 10814369792 1530569904 15.742 100 86 172 0 1566855520 9066112 27219504
17:01:08 16663 8192000000 10497495392 10841329664 1554859744 15.952 100 82 164 1 1589539248 9534160 25145344
17:01:36 16485 8192000000 10522656608 10868281344 1572472448 16.104 100 80 160 0 1606925152 10025168 24427536
17:02:08 21248 8192000000 10546458240 10903937024 1593687712 16.285 100 75 149 0 1626542624 10641120 22213792
17:02:39 7971 8192000000 10571680064 10928713728 1633405568 16.624 100 76 152 1 1666381136 10725552 22250016
17:02:55 13187 8192000000 10588700272 10949447680 1644005152 16.714 100 78 156 1 1678509152 11175184 23328816
17:03:16 11688 8192000000 10607603248 10968535040 1667136576 16.909 100 83 166 1 1703493952 11977184 24380192
17:03:35 10875 8192000000 10623582608 10986250240 1676876400 16.991 100 80 160 0 1712423840 12507712 23039728
17:03:52 9943 8192000000 10630836528 11002261504 1689030016 17.093 100 79 158 3 1724162800 12613232 22519552
17:04:09 6672 8192000000 10639389024 11014537216 1708116032 17.253 100 76 152 0 1741548896 12103408 21329456
17:04:29 5889 8192000000 10664269600 11036192768 1723228800 17.379 100 81 161 1 1758528032 12165760 23133472
17:04:42 8925 8192000000 10678133280 11051098112 1738857360 17.509 100 82 164 3 1774750736 13248384 22644992
17:05:00 5352 8192000000 10686302240 11066056704 1745455232 17.564 100 74 148 0 1778780800 12638720 20686848
17:05:12 4390 8192000000 10703879984 11082989568 1770966496 17.775 100 81 162 1 1806780192 13025968 22787728
17:05:23 4226 8192000000 10724773328 11101020160 1782276224 17.868 100 87 173 0 1820219888 13370448 24573216
17:05:36 4335 8192000000 10725276864 11108913152 1786802352 17.905 100 77 154 2 1821412144 12397616 22212176
17:05:47 4521 8192000000 10733643040 11114975232 1793593552 17.961 100 76 152 0 1826587904 11811488 21182864
17:05:58 4123 8192000000 10742014448 11126419456 1801413344 18.026 100 76 150 1 1834684320 12540608 20730368
17:06:08 2800 8192000000 10751918816 11131478016 1805340784 18.058 100 85 170 1 1844412544 14744784 24326976
17:06:18 6190 8192000000 10746524640 11133845504 1810220064 18.098 100 81 162 0 1847017568 14815392 21982112
17:06:31 2771 8192000000 10757350160 11143880704 1811956800 18.112 100 80 161 1 1848489104 14594288 21938016
17:06:40 3189 8192000000 10760959232 11148910592 1823296128 18.205 100 75 150 3 1858260928 13800928 21163872
17:06:50 2983 8192000000 10770844016 11161853952 1834187664 18.293 100 87 174 2 1872185200 13490432 24507104
17:07:01 2387 8192000000 10783587264 11173941248 1843844144 18.372 100 89 177 1 1881130704 13272976 24013584
17:07:10 2128 8192000000 10792611312 11181387776 1848657968 18.411 100 88 172 1 1887034272 13726672 24649632
17:07:19 1640 8192000000 10794552416 11182546944 1852314432 18.441 100 85 170 0 1889811136 13502624 23994080
17:07:27 1947 8192000000 10800438928 11188080640 1856849744 18.478 100 95 190 0 1897470224 13835088 26785392
17:07:35 2402 8192000000 10800760368 11189927936 1859391616 18.498 100 90 178 1 1896606128 12707056 24507456
17:07:44 2020 8192000000 10808705648 11197067264 1862624512 18.525 100 90 180 2 1901998272 13903408 25470352
17:07:52 1371 8192000000 10816810544 11204427776 1868868928 18.575 100 96 194 3 1910369168 14908400 26591840
17:08:00 1652 8192000000 10814021168 11202789376 1869569728 18.581 100 92 184 1 1910312128 14341040 26401360
17:08:08 1272 8192000000 10820340592 11207135232 1876530944 18.637 100 96 193 0 1916775872 13670224 26574704
17:08:15 2153 8192000000 10821118704 11208761344 1873266992 18.611 100 94 187 1 1913876544 14222352 26387200
17:08:23 1841 8192000000 10818213232 11209859072 1876543888 18.637 100 97 196 3 1918023408 13709776 27769744
17:08:31 1635 8192000000 10816368784 11207630848 1875825264 18.631 100 89 178 1 1913008112 10867744 26315104
17:08:39 28315 8192000000 10819566848 11212673024 1873330304 18.611 100 67 134 1 1903388688 11114464 18943920
17:09:14 3107 8192000000 10798949872 11212447744 1873302400 18.611 100 50 100 1 1897871792 10622720 13946672
17:09:25 7170 8192000000 10791987920 11213520896 1875017424 18.625 100 31 60 3 1891397232 8522880 7856928
17:09:39 3943 8192000000 10799962784 11215351808 1876934944 18.640 100 39 78 1 1896726720 9125904 10665872
17:09:50 4869 8192000000 10802223264 11218710528 1880390112 18.668 100 44 90 4 1901046368 8388352 12267904
17:10:03 2818 8192000000 10802493936 11223400448 1883566272 18.694 100 49 95 2 1906610336 9434928 13609136
17:10:13 9853 8192000000 10812800240 11232595968 1888282416 18.732 100 39 79 2 1911238560 12636016 10320128
17:10:30 6966 8192000000 10787716208 11223347200 1881896672 18.680 100 19 38 1 1897874976 10888592 5089712
17:10:44 8145 8192000000 10783465136 11217948672 1881951344 18.681 100 16 31 1 1892791456 5773232 5066880
17:10:58 8184 8192000000 10790269744 11223470080 1884641104 18.703 100 23 44 1 1896847536 5682416 6524016
17:11:13 10351 8192000000 10795762192 11228172288 1884304096 18.700 100 20 40 0 1895731584 6052048 5375440
17:11:30 8883 8192000000 10795513504 11229290496 1885553584 18.710 100 23 46 1 1898410368 6115984 6740800
17:11:50 11452 8192000000 10799474160 11228442624 1888667424 18.735 100 14 28 1 1898153616 5363216 4122976
17:12:10 58202 8192000000 10811609776 11242823680 1893060416 18.770 100 33 67 1 1908493856 5995456 9437984
17:13:31 15640 8192000000 10815594208 11250626560 1898153664 18.811 100 24 48 3 1911388080 6723232 6511184
17:13:54 6181 8192000000 10815842720 11252338688 1904352784 18.861 100 38 76 2 1922961600 8416064 10192752
17:14:07 3428 8192000000 10826688720 11256336384 1905923424 18.874 100 41 82 1 1925512336 7394624 12194288
17:14:18 4137 8192000000 10835634496 11263025152 1908938528 18.898 100 51 103 1 1931305760 7874000 14493232
17:14:30 3406 8192000000 10845275024 11265826816 1914068256 18.939 100 60 120 2 1939621856 8170240 17383360
17:14:41 4611 8192000000 10837144480 11262210048 1908225296 18.892 100 41 83 1 1927190368 7422288 11542784
17:14:52 4742 8192000000 10820829760 11252740096 1885240400 18.707 99 22 44 1 1897717824 5927056 6550368
17:15:08 5148 8192000000 10832220352 11259006976 1904881584 18.866 100 34 70 3 1920838448 6134704 9822160
17:15:23 8069 8192000000 10824633968 11260379136 1911185552 18.916 100 24 48 1 1923874496 5801664 6887280
17:15:41 4013 8192000000 10828472352 11261485056 1908326912 18.893 100 15 30 1 1918772240 6500992 3944336
17:15:51 5686 8192000000 10818876832 11258462208 1905641200 18.872 100 21 43 2 1917440208 6189552 5609456
17:16:05 5755 8192000000 10813938096 11255029760 1902686816 18.848 100 18 36 3 1913696016 5791696 5217504
17:16:17 12173 8192000000 10796889056 11231408128 1828946144 18.251 96 22 44 5 1840370768 4942048 6482576
17:16:36 8020 8192000000 10786297376 11217059840 1839817456 18.339 98 21 42 2 1852167104 6197728 6151920
17:16:53 59642 8192000000 10760142896 11178024960 1742311040 17.538 93 31 62 1 1756381360 4652128 9418192
17:18:00 7219 8192000000 10748063488 11179659264 1812617104 18.117 98 20 40 0 1824250704 6046784 5586816
17:18:16 7679 8192000000 10741788704 11160018944 1790943840 17.940 97 32 63 2 1805676672 6277792 8455040
17:18:29 6060 8192000000 10755226784 11174715392 1810962880 18.104 98 22 45 2 1822959072 5797840 6198352
17:18:45 5730 8192000000 10760812912 11174965248 1823107680 18.203 99 28 56 2 1835870016 5508240 7254096
17:18:57 5048 8192000000 10740469712 11165392896 1816130032 18.146 99 33 66 2 1833155216 7041568 9983616
17:19:09 4565 8192000000 10711106976 11132203008 1788784336 17.922 99 24 47 0 1802743120 6962688 6996096
17:19:20 3462 8192000000 10708455904 11123425280 1737644960 17.499 96 30 58 0 1752452032 6527824 8279248
17:19:32 6065 8192000000 10726829376 11144421376 1793259456 17.959 99 23 44 1 1805336112 5797984 6278672
17:19:44 8704 8192000000 10719341728 11133247488 1799581968 18.010 100 29 57 4 1817645136 10137312 7925856
17:20:03 7075 8192000000 10717917568 11122995200 1730312032 17.438 96 23 46 3 1742557568 5393872 6851664
17:20:20 7844 8192000000 10713369920 11136540672 1777769440 17.831 98 28 55 2 1791982032 5753904 8458688
17:20:37 4704 8192000000 10735148192 11155279872 1810703120 18.102 99 35 70 2 1827696112 5681648 11311344
17:20:48 6258 8192000000 10729701120 11147210752 1766992224 17.742 97 27 52 0 1779872608 5239888 7640496
17:21:05 8369 8192000000 10713461840 11139846144 1784056432 17.883 98 19 38 3 1795436624 5745744 5634448
17:21:22 7950 8192000000 10731512976 11150315520 1801066048 18.023 99 28 56 0 1815247792 5038784 9142960
17:21:42 65897 8192000000 10723109696 11145224192 1718955488 17.343 94 30 58 3 1732736384 5243568 8537328
17:22:56 7145 8192000000 10743600224 11168362496 1832081888 18.276 100 28 56 1 1846822768 6508368 8232512
17:23:09 7618 8192000000 10758528896 11172884480 1821438368 18.189 99 42 84 4 1840070784 6283728 12348688
17:23:23 4826 8192000000 10751619712 11177328640 1835720432 18.306 100 30 58 3 1850397680 7016080 7661168
17:23:35 4904 8192000000 10747906336 11173572608 1833902192 18.291 100 29 58 0 1849031504 7041744 8087568
17:23:46 5910 8192000000 10761071648 11182333952 1842242352 18.359 100 34 68 2 1857625840 5974224 9409264
17:23:58 5578 8192000000 10766250480 11192815616 1848682736 18.411 100 20 41 1 1860343296 6339120 5321440
17:24:13 4829 8192000000 10765750496 11193352192 1853222080 18.448 100 28 56 2 1868322576 7443904 7656592
17:24:24 8322 8192000000 10773458112 11197935616 1856452320 18.475 100 15 29 0 1866122080 4841600 4828160
17:24:40 8003 8192000000 10780407664 11209011200 1858928144 18.495 100 26 51 2 1872145008 5310048 7906816
17:24:54 9723 8192000000 10766115808 11204919296 1860955216 18.511 100 18 36 1 1871812448 5816352 5040880
17:25:14 6312 8192000000 10780268368 11206864896 1864029600 18.536 100 26 52 1 1877348848 5415792 7903456
17:25:31 11508 8192000000 10773864768 11207966720 1863543008 18.532 100 15 30 1 1873438848 5570880 4324960
17:25:52 8533 8192000000 10782221280 11215691776 1868546864 18.573 100 19 38 2 1883873008 9740880 5585264
17:26:07 5972 8192000000 10793961536 11220447232 1869674576 18.582 100 23 47 1 1886403552 10704832 6024144
17:26:19 4960 8192000000 10791531712 11217399808 1872213856 18.602 100 26 52 1 1885169584 5681024 7274704
17:26:30 8982 8192000000 10791000224 11215826944 1873888816 18.616 100 34 66 0 1894003152 10448320 9666016
17:26:45 111946 8192000000 10826428416 11248439296 1891023392 18.754 100 44 87 1 1910199152 6713344 12462416
17:29:08 25313 8192000000 10844979024 11275034624 1921118256 18.996 100 46 90 3 1942795392 8706064 12971072
17:29:45 51888 8192000000 10872128960 11296743424 1936167568 19.116 100 40 79 3 1956796064 8945968 11682528
17:30:45 37557 8192000000 10875688032 11303948288 1942310240 19.165 100 26 52 0 1960992352 10959024 7723088
17:31:43 26355 8192000000 10873732736 11313807360 1949442560 19.222 100 31 61 4 1973739312 14112480 10184272
17:32:57 13574 8192000000 10895355600 11332501504 1965673360 19.351 100 31 60 2 1985374848 10824752 8876736
17:33:18 12605 8192000000 10899458624 11334021120 1955730752 19.272 99 45 88 1 1981839680 12639088 13469840
17:33:40 7756 8192000000 10924062864 11350142976 1977177648 19.442 100 46 93 1 2008857968 18161440 13518880
17:34:01 6985 8192000000 10921413792 11356717056 1983684512 19.494 100 44 88 1 2011796400 15109056 13002832
17:34:17 7303 8192000000 10939055296 11368800256 1989971504 19.544 100 56 111 0 2026765136 20688528 16105104
17:34:51 9460 8192000000 10923345920 11353387008 1980216864 19.466 100 51 102 1 2013594960 18325856 15052240
17:35:11 14467 8192000000 10924322384 11361697792 1981835376 19.479 100 42 80 0 2012240032 18100560 12304096
17:35:35 11033 8192000000 10921350128 11362430976 1987694288 19.526 100 40 79 1 2016145200 16437264 12013648
17:35:55 10348 8192000000 10917884144 11359756288 1969798400 19.384 99 38 76 1 1998820864 17381920 11640544
17:36:22 32074 8192000000 10927315584 11364794368 1969497184 19.381 99 33 66 1 2002648112 22307552 10843376
17:37:13 7435 8192000000 10937083536 11374325760 1984127088 19.497 100 48 96 0 2027761760 28363504 15271168
17:37:30 13337 8192000000 10938711648 11378360320 1986413168 19.515 100 40 80 1 2024452816 25334656 12704992
17:37:55 7109 8192000000 10912658144 11347214336 1943946416 19.178 98 52 104 1 1985338528 24906384 16485728
17:38:10 7376 8192000000 10935816224 11364610048 1965046064 19.346 99 56 113 0 2010422912 28547344 16829504
17:38:26 2404 8192000000 10955464384 11375390720 1990772096 19.550 100 78 154 0 2040126672 25967824 23386752
17:38:37 1314 8192000000 10960440992 11378470912 1991062368 19.552 100 84 169 3 2043031040 26238336 25730336
17:38:46 2833 8192000000 10949141408 11367424000 1981229952 19.474 100 69 138 0 2029855440 27546032 21079456
17:38:57 4106 8192000000 10949466720 11374800896 1985718288 19.510 100 70 139 1 2033819840 27065312 21036240
17:39:09 1589 8192000000 10957031840 11378188288 1992842928 19.566 100 81 162 0 2045363504 27518208 25002368
17:39:18 3932 8192000000 10971716656 11390595072 2004249104 19.656 100 77 154 1 2056975072 28788208 23937760
17:39:29 1454 8192000000 10986021984 11396579328 2006166432 19.671 100 94 189 2 2064467232 29728352 28572448
17:39:36 7987 8192000000 10967262528 11388379136 1985490352 19.508 99 80 157 0 2041416544 30860144 25066048
17:39:52 1543 8192000000 10972054848 11383771136 1994093456 19.576 100 80 161 1 2050292144 31341536 24857152
17:40:03 2983 8192000000 10964361568 11386339328 1980872896 19.472 99 77 153 0 2036403936 31157936 24373104
17:40:13 6065 8192000000 10959969216 11380252672 1989262992 19.538 100 74 147 0 2043279728 31072336 22944400
17:40:26 1350 8192000000 10970251616 11385761792 1993965456 19.575 100 80 162 1 2050394016 31531456 24897104
17:40:36 7413 8192000000 10937115136 11355025408 1958346784 19.293 99 71 140 0 2010793760 31105424 21341552
17:40:57 9331 8192000000 10945537184 11371892736 1961590448 19.319 99 67 132 0 2018484752 36014880 20879424
17:41:14 2157 8192000000 10962322112 11372015616 1976240448 19.435 100 78 154 2 2035739024 34356256 25142320
17:41:25 2523 8192000000 10905611184 11323297792 1938133856 19.132 98 73 145 0 1996565408 35678768 22752784
17:41:35 4329 8192000000 10944500064 11366260736 1964493568 19.342 100 71 140 1 2025235792 37662320 23079904
17:41:46 2944 8192000000 10951101360 11362717696 1953521664 19.255 99 93 185 1 2023368304 40126656 29719984
17:41:56 2213 8192000000 10924121488 11330428928 1931488160 19.079 99 80 159 0 1995118400 38378112 25252128
17:42:06 3632 8192000000 10913405808 11331010560 1939381920 19.142 100 73 145 2 1999685120 36951360 23351840
17:42:20 1698 8192000000 10938369360 11346747392 1950437072 19.230 100 91 183 1 2015516832 36799728 28280032
17:42:27 2460 8192000000 10915260208 11338129408 1947329120 19.205 100 64 122 0 2002265344 35037504 19898720
17:42:38 5624 8192000000 10916728384 11345694720 1945931216 19.194 99 68 134 2 2000686352 33754256 21000880
17:42:52 2388 8192000000 10931583760 11355049984 1960998160 19.314 100 67 134 1 2017039104 35535088 20505856
17:43:02 8968 8192000000 10905967840 11340791808 1921549296 18.999 98 49 98 0 1968594016 31673952 15370768
17:43:18 7178 8192000000 10933265088 11350851584 1955121344 19.267 100 67 131 2 2008676720 32834048 20721328
17:43:40 4608 8192000000 10924741072 11347857408 1935549296 19.111 99 60 120 2 1988314720 34009312 18756112
17:43:51 3040 8192000000 10930094096 11346526208 1947775088 19.209 100 73 146 2 2006609200 36103568 22730544
17:44:01 3828 8192000000 10919585056 11333267456 1938351152 19.134 100 82 163 0 2000099456 36044544 25703760
17:44:14 1869 8192000000 10921325104 11338293248 1930949136 19.074 99 84 168 2 1993202576 37002512 25250928
17:44:24 6676 8192000000 10910557376 11345739776 1946235328 19.196 100 54 108 2 1998943392 35877232 16830832
17:44:39 14048 8192000000 10899026480 11352719360 1948813792 19.217 100 30 60 3 1989494768 30915776 9765200
17:45:00 9882 8192000000 10921592736 11364347904 1955861776 19.273 100 33 66 0 1999119648 32196896 11060976
17:45:16 10728 8192000000 10902424944 11337007104 1922597856 19.008 98 44 86 0 1971048320 33885536 14564928
17:45:34 7023 8192000000 10908975728 11354554368 1951893760 19.242 100 35 68 5 1996488512 33828736 10766016
17:45:56 15308 8192000000 10910820144 11362512896 1954266448 19.260 100 24 46 1 1992725520 30404848 8054224
17:46:21 18043 8192000000 10902879328 11352399872 1953246944 19.252 100 36 72 1 1994765376 29904016 11614416
17:46:45 12227 8192000000 10919799824 11354034176 1922410624 19.006 98 41 81 0 1965836448 29918288 13507536
17:47:06 2631 8192000000 10921840144 11349889024 1939125024 19.140 99 58 118 1 1990184704 31561440 19498240
17:47:15 12123 8192000000 10914896592 11353952256 1935046416 19.107 99 36 71 2 1981821216 34750928 12023872
17:47:34 8621 8192000000 10916182336 11358060544 1952864912 19.249 100 39 79 3 2003235088 37057072 13313104
17:47:49 16153 8192000000 10903900864 11340648448 1904840288 18.865 98 35 69 1 1956261856 39840336 11581232
17:48:19 13705 8192000000 10894215104 11332849664 1928647552 19.056 100 32 64 2 1976870224 37304400 10918272
17:48:51 11430 8192000000 10886103568 11337039872 1935070496 19.107 100 25 50 1 1979901296 36115520 8715280
17:49:14 9342 8192000000 10894650368 11337310208 1935009488 19.107 100 39 75 1 1977438800 29854496 12574816
17:49:30 5790 8192000000 10897124320 11340263424 1937504480 19.127 100 39 78 1 1983623424 33018704 13100240
17:49:46 9887 8192000000 10893159696 11339141120 1934832224 19.105 100 31 62 2 1972367280 27058560 10476496
17:50:02 16766 8192000000 10876680832 11329503232 1906581824 18.879 98 27 54 0 1940439536 25708160 8149552
17:50:25 37559 8192000000 10877202752 11332071424 1899925824 18.826 98 20 40 2 1939151664 32386512 6839328
17:51:09 18517 8192000000 10871141008 11325747200 1909734464 18.905 99 18 36 0 1943154288 27165904 6253920
17:51:59 23117 8192000000 10881971472 11327971328 1896028464 18.794 98 17 34 1 1929051536 27635856 5387216
17:52:35 64257 8192000000 10878037712 11318251520 1893341424 18.773 98 14 28 0 1921824496 24496320 3986752
17:53:45 35499 8192000000 10852046160 11312533504 1895936528 18.794 98 24 47 2 1913473456 11364352 6172576
17:54:34 35253 8192000000 10854348560 11309600768 1909254064 18.901 99 26 52 2 1926717312 10394944 7068304
17:55:26 33676 8192000000 10863452064 11301826560 1901606016 18.839 99 25 49 1 1915787024 7251760 6929248
17:56:07 72125 8192000000 10866813984 11293343744 1894961008 18.786 98 48 96 2 1916156720 7131264 14064448
17:57:31 20832 8192000000 10888719504 11323846656 1937018832 19.123 100 63 126 2 1966026672 11351360 17656480
17:58:04 69756 8192000000 10887905392 11352621056 1944668144 19.184 100 23 46 2 1970398240 19153328 6576768
17:59:25 105335 8192000000 10884203856 11345174528 1895731472 18.792 97 16 32 0 1916710208 16549632 4429104
18:01:29 27374 8192000000 10910705488 11363704832 1974323456 19.420 100 51 101 2 1997905152 9126512 14455184
18:02:29 21016 8192000000 10896225824 11360751616 1944537776 19.183 99 12 24 1 1957084848 8788688 3758384
18:02:59 54342 8192000000 10912471904 11355865088 1949607712 19.223 99 40 80 2 1977909168 15874720 12426736
18:04:35 47336 8192000000 10888517904 11355717632 1943045680 19.171 99 15 30 3 1957645568 10340496 4259392
18:05:31 57996 8192000000 10886585520 11355193344 1939502288 19.143 98 15 30 0 1954427296 10533616 4391392
18:06:40 41600 8192000000 10888237856 11348434944 1949843664 19.225 99 13 26 0 1965155328 11501088 3810576
18:07:28 35444 8192000000 10902403440 11370459136 1968626576 19.375 100 13 25 1 1987443056 14716368 4100112
18:08:10 25023 8192000000 10901679744 11359404032 1940528800 19.151 98 24 48 2 1962468912 14792560 7147552
18:08:41 33520 8192000000 10890202448 11362328576 1935807648 19.113 98 15 30 0 1953307936 12915680 4584608
18:09:32 42697 8192000000 10894550336 11369201664 1966360064 19.357 100 16 32 1 1983672192 13074272 4237856
18:10:20 38116 8192000000 10905071792 11381723136 1972069872 19.402 100 13 26 0 1991938256 15766000 4102384
18:11:05 72438 8192000000 10904666336 11381043200 1949314304 19.221 99 19 38 0 1973594448 17962080 6318064
18:12:24 64010 8192000000 10888028672 11364651008 1910619920 18.912 97 23 46 0 1930256800 12657168 6979712
18:13:34 82894 8192000000 10892140304 11355488256 1890666528 18.751 96 10 20 1 1904400032 10863856 2869648
18:15:04 43518 8192000000 10876812512 11341955072 1909171216 18.900 97 15 30 0 1924093936 10441216 4481504
18:15:54 53483 8192000000 10883251696 11360759808 1958116992 19.291 100 17 34 2 1975246928 12485312 4644624
18:16:53 27639 8192000000 10928299424 11371372544 1975801168 19.431 100 34 68 2 1993004848 7766960 9436720
18:17:27 29809 8192000000 10902580112 11355521024 1921159168 18.996 97 33 66 1 1940105536 9860672 9085696
18:18:03 22489 8192000000 10916544864 11364040704 1960655632 19.311 99 51 100 1 1984512768 10711952 13145184
18:18:33 29406 8192000000 10907967120 11370430464 1959368352 19.301 99 31 62 0 1981684400 13473264 8842784
18:19:09 30985 8192000000 10883377040 11340132352 1896091952 18.795 96 20 40 1 1911366912 9299536 5975424
18:19:51 27965 8192000000 10893718848 11351060480 1952679168 19.248 100 26 52 1 1968495936 8619648 7197120
18:20:25 59416 8192000000 10891438336 11359436800 1928928880 19.058 98 24 48 1 1947208080 11561056 6718144
18:21:35 37037 8192000000 10904773760 11367010304 1969153712 19.379 100 23 46 1 1986559104 10843184 6562208
18:22:26 116477 8192000000 10862375712 11321192448 1810742608 18.102 93 6 11 0 1823696240 11440704 1512928
18:24:43 112055 8192000000 10840629280 11297538048 1859560720 18.500 96 15 30 1 1874592128 11213184 3818224
18:26:42 85818 8192000000 10847953408 11302187008 1873714768 18.614 97 22 44 1 1887113872 7301488 6097616
18:28:21 41402 8192000000 10869811392 11331362816 1940673168 19.152 100 30 58 0 1959960064 11407456 7879440
18:29:10 2749 8192000000 10860668368 11325431808 1932927136 19.090 100 27 54 0 1952625712 11953152 7745424
18:29:21 18682 8192000000 10880059168 11330854912 1939151968 19.140 100 22 44 0 1956636000 10707632 6776400
18:29:58 15031 8192000000 10837119968 11293417472 1886664992 18.719 97 30 60 5 1904401376 10048464 7687920
18:30:29 26700 8192000000 10841265648 11299094528 1880028032 18.665 97 24 46 1 1892386080 6096320 6261728
18:31:02 50207 8192000000 10862034656 11320545280 1923709072 19.017 99 20 40 0 1938430992 9417264 5304656
18:31:59 59057 8192000000 10868636880 11336675328 1929389248 19.062 99 11 22 0 1944551232 11416720 3745264
18:33:05 64501 8192000000 10879101536 11351695360 1927661360 19.048 99 10 20 1 1943651360 12643936 3346064
18:34:15 30372 8192000000 10875737424 11353133056 1945768448 19.193 100 15 30 0 1968975792 17774176 5433168
18:35:03 78107 8192000000 10875547600 11346403328 1890291072 18.748 97 18 36 0 1917522016 20929600 6301344
18:36:31 60201 8192000000 10847036464 11325419520 1898318096 18.813 98 21 42 0 1918546640 13995440 6233104
18:37:38 36602 8192000000 10859154240 11325165568 1906418256 18.878 99 17 34 0 1921499728 10081632 4999840
18:38:23 67191 8192000000 10883695840 11344920576 1923839936 19.018 99 18 36 0 1941001792 12278736 4883120
18:39:36 55846 8192000000 10868294336 11335770112 1894652624 18.783 97 21 42 0 1909288848 9107872 5528352
18:40:43 59948 8192000000 10881669536 11324264448 1883384384 18.692 97 17 32 3 1899078752 10157360 5537008
18:41:50 57655 8192000000 10875874368 11349876736 1931750304 19.081 99 20 40 1 1952182720 15162672 5269744
18:42:56 80605 8192000000 10866383888 11324788736 1832606512 18.281 94 16 32 2 1849609296 12437776 4565008
18:45:00 74184 8192000000 10878370912 11335024640 1891166800 18.755 97 23 46 1 1911507568 14096064 6244704
18:46:25 60914 8192000000 10884913072 11345850368 1911600112 18.919 98 27 52 3 1932349248 13813216 6935920
18:47:33 69617 8192000000 10887455216 11344322560 1948600992 19.215 100 14 29 3 1965529040 12857776 4070272
18:49:28 36980 8192000000 10886829904 11359199232 1955660896 19.272 100 20 40 0 1977189376 15240336 6288144
18:50:39 75154 8192000000 10865978608 11345809408 1949267024 19.221 100 14 26 2 1962607344 9643504 3696816
18:52:21 55725 8192000000 10872528272 11344826368 1952090256 19.243 100 17 34 1 1965987776 9092512 4805008
18:53:23 64537 8192000000 10884995648 11362127872 1963004432 19.330 100 10 20 0 1973266464 7827808 2434224
18:54:35 50251 8192000000 10859975456 11342757888 1929739728 19.065 98 16 32 1 1946256240 12007856 4508656
18:56:07 74809 8192000000 10878892304 11353309184 1925548032 19.031 98 22 43 0 1948207120 16241344 6417744
18:57:33 78423 8192000000 10866333808 11340550144 1902110224 18.843 97 19 38 1 1916632832 9113600 5409008
18:58:58 59181 8192000000 10875583216 11346649088 1906094928 18.875 97 12 24 0 1920436096 11092176 3248992
19:00:05 61790 8192000000 10912567872 11374157824 1949270464 19.221 99 22 45 2 1972963024 17513040 6179520
19:01:18 39210 8192000000 10890353760 11351416832 1921692816 19.000 98 14 28 1 1938491728 12274672 4524240
19:02:09 68221 8192000000 10894217088 11366924288 1923874832 19.018 98 13 26 2 1941047024 13535472 3636720
19:03:29 62031 8192000000 10890412448 11342823424 1892547552 18.766 96 25 50 0 1907853664 9022976 6283136
19:04:37 28831 8192000000 10902430608 11354734592 1943113232 19.172 99 36 72 0 1964750464 11846688 9790544
19:05:24 96591 8192000000 10899119920 11353780224 1887434560 18.725 96 18 36 1 1909652672 17013264 5204848
19:07:13 56211 8192000000 10888762848 11355348992 1919002816 18.979 98 8 16 0 1930599296 9614944 1981536
19:08:16 39274 8192000000 10905384112 11361492992 1933300736 19.093 98 30 58 2 1950761856 9649632 7811488
19:09:01 25583 8192000000 10897801104 11360051200 1948317376 19.213 99 41 82 0 1971650096 11496688 11836032
19:09:33 22475 8192000000 10912719008 11359281152 1952373760 19.245 99 42 83 0 1973636224 10158016 11104448
19:10:01 42034 8192000000 10874482304 11331051520 1918971504 18.979 98 28 56 2 1937366592 10639168 7755920
19:10:52 111425 8192000000 10853944896 11324485632 1857084896 18.480 95 15 30 1 1871169024 10074448 4009680
19:12:51 92163 8192000000 10861633968 11320049664 1877050112 18.641 96 25 49 2 1892209952 8049744 7110096
19:14:30 39506 8192000000 10873374224 11344715776 1942743744 19.169 100 11 22 1 1953515712 7577920 3194048
19:15:37 63698 8192000000 10864512608 11348692992 1929609840 19.064 99 7 14 0 1945025552 13330576 2085136
19:16:48 36766 8192000000 10873861536 11350855680 1912509648 18.927 98 7 14 0 1932297920 17590288 2197984
19:17:31 43449 8192000000 10860481504 11330838528 1908552912 18.895 98 14 28 1 1925030928 12579216 3898800
19:18:21 76411 8192000000 10868380240 11340521472 1934088976 19.100 99 15 30 2 1947035600 8621440 4325184
19:19:45 85699 8192000000 10873303248 11353145344 1934708432 19.105 99 13 26 0 1947693840 9097504 3887904
19:21:48 36689 8192000000 10847572096 11310813184 1868807568 18.575 96 10 20 1 1879041488 7550000 2683920
19:22:31 76329 8192000000 10860890736 11329871872 1880570304 18.670 97 11 22 0 1892225056 8527360 3127392
19:23:58 27781 8192000000 10859748976 11320492032 1908093216 18.891 98 35 69 0 1929332368 11135856 10103296
19:24:34 41055 8192000000 10864698368 11325317120 1888817424 18.736 98 34 68 4 1915288752 17279408 9191920
19:26:00 67158 8192000000 9702386784 10041298944 836102976 9.261 43 7 14 1 845621248 7696352 1821920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 07-11-2020 19:28:11 to 07-11-2020 19:28:43.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 106 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-11-2020 19:28:44 to 07-11-2020 19:28:46.

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          247223
MON$OLDEST_ACTIVE               247224
MON$OLDEST_SNAPSHOT             247224
MON$NEXT_TRANSACTION            247224
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                       2023680
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:23: 
:24: mscs-test-161.budzdorov.ru    Sat Nov  7 19:27:10 2020
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
:27: 
:28: mscs-test-161.budzdorov.ru    Sat Nov  7 19:27:10 2020
:29:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:30: 
:31: 
:32: mscs-test-161.budzdorov.ru    Sat Nov  7 19:27:12 2020
:33:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:34: 
--- end of diff output ---

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

07.11.20 19:28:47. 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-07 19:28:49 No severe PSQL-related problems occured
07.11.20 19:28:50. End of report.