Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.02.2021 01:28
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 17087728 kB
MemAvailable 31083800 kB
Buffers 0 kB
Cached 14601852 kB
SwapCached 3312 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-28 01:27:21
DTS_END                         2021-02-28 01:27:21.1280
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57848
TRN_ID                          244141
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: 9264.18 22703 1111702
customer order: creation 176.23 351 21148
customer order: refuse 14.45 339 1734
order to supplier: creation 46.96 1200 5635
order to supplier: removal 3.36 100051 403
invoice (draft): creation 46.83 3263 5619
invoice (draft): removal 53.54 827 6425
invoice accept: apply 41.93 17280 5031
invoice accept: cancel 48.65 776 5838
customer reserve: creation 3830.39 173 459647
customer reserve: removal 4703.27 55 564393
realization accept: apply 86.13 194 10336
realization accept: cancel 79.15 117 9498
payment from customer: creation 60.73 129 7287
payment from customer: removal 5.68 125 682
payment to supplier: creation 51.02 148 6122
payment to supplier: removal 3.43 103 412
service: total inventory turnovers 4.74 1022 569
service: total monetary turnovers 6.77 19 812
service: aggregate perf. data 0.89 18328 107
service: refresh index statistics 0.03 309554 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-02-2021 01:28:27 to 28-02-2021 01:28:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4903
TEST_TIME 2 4755
TEST_TIME 3 4693
TEST_TIME 4 4573
TEST_TIME 5 4406
TEST_TIME 6 4562
TEST_TIME 7 4381
TEST_TIME 8 4673
TEST_TIME 9 5884
TEST_TIME 10 6215
TEST_TIME 11 6395
TEST_TIME 12 6541
TEST_TIME 13 6383
TEST_TIME 14 6700
TEST_TIME 15 7030
TEST_TIME 16 7481
TEST_TIME 17 7843
TEST_TIME 18 7903
TEST_TIME 19 7984
TEST_TIME 20 8507
TEST_TIME 21 9362
TEST_TIME 22 9420
TEST_TIME 23 10037
TEST_TIME 24 10747
TEST_TIME 25 10605
TEST_TIME 26 10536
TEST_TIME 27 10446
TEST_TIME 28 10533
TEST_TIME 29 10546
TEST_TIME 30 10436
TEST_TIME 31 10355
TEST_TIME 32 10096
TEST_TIME 33 10005
TEST_TIME 34 9978
TEST_TIME 35 9930
TEST_TIME 36 9784
TEST_TIME 37 9908
TEST_TIME 38 9857
TEST_TIME 39 9849
TEST_TIME 40 9858
TEST_TIME 41 9761
TEST_TIME 42 9666
TEST_TIME 43 9561
TEST_TIME 44 9387
TEST_TIME 45 9703
TEST_TIME 46 9665
TEST_TIME 47 9610
TEST_TIME 48 9605
TEST_TIME 49 9550
TEST_TIME 50 9768
TEST_TIME 51 9762
TEST_TIME 52 9761
TEST_TIME 53 9770
TEST_TIME 54 9754
TEST_TIME 55 9723
TEST_TIME 56 9747
TEST_TIME 57 9804
TEST_TIME 58 9852
TEST_TIME 59 9709
TEST_TIME 60 9658
TEST_TIME 61 9573
TEST_TIME 62 9551
TEST_TIME 63 9586
TEST_TIME 64 9494
TEST_TIME 65 9506
TEST_TIME 66 9485
TEST_TIME 67 9477
TEST_TIME 68 9412
TEST_TIME 69 9396
TEST_TIME 70 9395
TEST_TIME 71 9488
TEST_TIME 72 9532
TEST_TIME 73 9508
TEST_TIME 74 9529
TEST_TIME 75 9579
TEST_TIME 76 9516
TEST_TIME 77 9629
TEST_TIME 78 9635
TEST_TIME 79 9722
TEST_TIME 80 9703
TEST_TIME 81 9602
TEST_TIME 82 9558
TEST_TIME 83 9557
TEST_TIME 84 9477
TEST_TIME 85 9486
TEST_TIME 86 9514
TEST_TIME 87 9469
TEST_TIME 88 9423
TEST_TIME 89 9426
TEST_TIME 90 9403
TEST_TIME 91 9328
TEST_TIME 92 9329
TEST_TIME 93 9375
TEST_TIME 94 9428
TEST_TIME 95 9373
TEST_TIME 96 9498
TEST_TIME 97 9531
TEST_TIME 98 9542
TEST_TIME 99 9514
TEST_TIME 100 9572
TEST_TIME 101 9561
TEST_TIME 102 9555
TEST_TIME 103 9587
TEST_TIME 104 9591
TEST_TIME 105 9517
TEST_TIME 106 9484
TEST_TIME 107 9497
TEST_TIME 108 9483
TEST_TIME 109 9493
TEST_TIME 110 9452
TEST_TIME 111 9417
TEST_TIME 112 9393
TEST_TIME 113 9337
TEST_TIME 114 9328
TEST_TIME 115 9311
TEST_TIME 116 9314
TEST_TIME 117 9277
TEST_TIME 118 9314
TEST_TIME 119 9325
TEST_TIME 120 9266

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-02-2021 01:28:31 to 28-02-2021 01:28:34.

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 1538862 1538862 0 0.00 0 17457 6 0 0
doc_list_biud 1538861 1538861 0 0.00 0 27723 26 0 0
sp_add_invoice_to_stock 5158 5031 127 2.46 45 196672 17280 0 127
sp_cancel_adding_invoice 5838 5838 0 0.00 5 64740 776 0 0
sp_cancel_client_order 1734 1734 0 0.00 4 13277 339 0 0
sp_cancel_customer_reserve 564393 564393 0 0.00 1 27724 55 0 0
sp_cancel_pay_from_customer 682 682 0 0.00 3 21221 126 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 7339 104 0 0
sp_cancel_supplier_invoice 6435 6425 10 0.15 2 19570 828 0 10
sp_cancel_supplier_order 403 403 0 0.00 5 986578 100052 0 0
sp_cancel_write_off 9498 9498 0 0.00 1 15369 117 0 0
sp_client_order 21148 21148 0 0.00 4 68483 351 0 0
sp_customer_reserve 459647 459647 0 0.00 0 152823 173 0 0
sp_fill_shopping_cart 32396 32396 0 0.00 1 13234 35 0 0
sp_fill_shopping_cart_clo_res 459640 459640 0 0.00 0 14807 14 0 0
sp_get_clo_for_invoice 5024 5024 0 0.00 0 22745 293 0 0
sp_kill_cost_storno 16430 16430 0 0.00 0 15365 55 0 0
sp_kill_qstorno_ret_qs2qd 1145112 1145112 0 0.00 0 27720 30 0 0
sp_kill_qty_storno 603651 603651 0 0.00 0 27722 66 0 0
sp_lock_selected_doc 21064 21064 0 0.00 0 8840 7 0 0
sp_make_cost_storno 28769 28769 0 0.00 0 9917 49 0 0
sp_multiply_rows_for_pdistr 28769 28769 0 0.00 0 6497 27 0 0
sp_multiply_rows_for_qdistr 21148 21148 0 0.00 0 68474 150 0 0
sp_pay_from_customer 7287 7287 0 0.00 4 20450 130 0 0
sp_pay_to_supplier 6122 6122 0 0.00 5 22702 148 0 0
sp_payment_common 13409 13409 0 0.00 1 10659 28 0 0
sp_qd_handle_on_cancel_clo 1734 1734 0 0.00 0 9875 298 0 0
sp_qd_handle_on_invoice_upd_sts 10862 10862 0 0.00 0 21775 313 0 0
sp_qd_handle_on_reserve_upd_sts 10336 10336 0 0.00 0 23790 63 0 0
sp_reserve_write_off 10336 10336 0 0.00 7 23825 195 0 0
sp_supplier_invoice 5619 5619 0 0.00 6 92793 3264 0 0
sp_supplier_order 5635 5635 0 0.00 5 24367 1200 0 0
srv_aggregate_perf_data 107 107 0 0.00 3116 180612 18328 0 0
srv_fill_mon_cache_memory 151 151 0 0.00 1783 187285 35365 0 0
srv_find_qd_qs_mism 1064009 1064009 0 0.00 0 17454 5 0 0
srv_make_invnt_saldo 569 569 0 0.00 41 66295 1023 0 0
srv_make_money_saldo 812 812 0 0.00 1 1801 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 139489 440893 309554 0 0
t$perf-abend:sp_add_invoice_to_stock 127 127 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5031 5031 0 0.00 0 11478 194 0 0
t$perf-norm:sp_cancel_adding_invoice 439 439 0 0.00 0 10795 112 0 0
t$perf-norm:sp_cancel_client_order 1734 1734 0 0.00 0 5501 18 0 0
t$perf-norm:sp_cancel_customer_reserve 643 643 0 0.00 0 2020 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 682 682 0 0.00 0 355 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 652 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 400 400 0 0.00 0 2061 16 0 0
t$perf-norm:sp_cancel_supplier_order 403 403 0 0.00 0 20657 1549 0 0
t$perf-norm:sp_cancel_write_off 993 993 0 0.00 0 7013 12 0 0
t$perf-norm:sp_client_order 21148 21148 0 0.00 0 9075 17 0 0
t$perf-norm:sp_customer_reserve 1062 1062 0 0.00 0 5380 16 0 0
t$perf-norm:sp_pay_from_customer 7287 7287 0 0.00 0 9869 10 0 0
t$perf-norm:sp_pay_to_supplier 6122 6122 0 0.00 0 8221 16 0 0
t$perf-norm:sp_reserve_write_off 10336 10336 0 0.00 0 9466 12 0 0
t$perf-norm:sp_supplier_invoice 5619 5619 0 0.00 0 5053 16 0 0
t$perf-norm:sp_supplier_order 5635 5635 0 0.00 0 5299 16 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 503 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 151 151 0 0.00 0 1256 17 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 1070 20 0 0
t$perf-norm:srv_make_money_saldo 812 812 0 0.00 0 534 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10298 10044 254 2.46 0 21032 32 0 254
v_all_customers 38582 38582 0 0.00 0 17 1 0 0
v_all_suppliers 31108 31108 0 0.00 0 16 1 0 0
v_all_wares 42296 42296 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 878 878 0 0.00 0 8682 29 0 0
v_cancel_client_order 3468 3468 0 0.00 0 13084 13 0 0
v_cancel_customer_prepayment 1364 1364 0 0.00 0 21051 33 0 0
v_cancel_customer_reserve 1286 1286 0 0.00 0 4722 23 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 2704 14 0 0
v_cancel_supplier_invoice 820 800 20 2.43 0 3501 27 0 20
v_cancel_supplier_order 806 806 0 0.00 0 1082 6 0 0
v_cancel_write_off 1986 1986 0 0.00 0 13102 30 0 0
v_max_id_clo_ord 5634 5634 0 0.00 0 1076 1 0 0
v_max_id_clo_res 1062 1062 0 0.00 0 4799 14 0 0
v_max_id_ord_sup 5614 5614 0 0.00 0 1856 2 0 0
v_max_non_paid_invoice 1816 1816 0 0.00 0 793 3 0 0
v_max_non_paid_realizn 3803 3803 0 0.00 0 1335 4 0 0
v_min_id_clo_ord 5634 5634 0 0.00 0 4738 9 0 0
v_min_id_clo_res 1062 1062 0 0.00 0 3649 12 0 0
v_min_id_ord_sup 5614 5614 0 0.00 0 6013 7 0 0
v_min_non_paid_invoice 6122 6122 0 0.00 0 6145 15 0 0
v_min_non_paid_realizn 7287 7287 0 0.00 0 8278 18 0 0
v_our_firm 10682 10682 0 0.00 0 15 1 0 0
v_reserve_write_off 20672 20672 0 0.00 0 19974 13 0 0
x_lock_depdocs_on_canc_invoice 11863 11863 0 0.00 0 29098 111 0 0
x_lock_depdocs_on_canc_sup_ord 403 403 0 0.00 0 25851 414 0 0
x_make_qstorno_1000_1200 5635 5635 0 0.00 1 24358 1125 0 0
x_make_qstorno_1200_2000 5619 5619 0 0.00 3 92728 3140 0 0
x_make_qstorno_2100_3300 459647 459647 0 0.00 0 151325 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-02-2021 01:28:35 to 28-02-2021 01:28:39.

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
22:57:24 6 8192000000 8802141808 8813576192 8233680 0.100 2 1 2 0 8353088 56848 62560
22:57:31 25710 8192000000 10265090688 10577514496 949571200 10.387 73 58 117 1 971305488 2769536 18964752
22:58:06 20363 8192000000 10336581024 10648825856 1389795136 14.504 100 95 190 0 1426258768 5148224 31315408
22:58:36 9620 8192000000 10342392944 10664189952 1405549280 14.644 100 84 168 0 1439884784 5974576 28360928
22:59:02 26503 8192000000 10397998592 10721517568 1442009696 14.967 100 86 172 0 1476951728 6524656 28417376
22:59:40 20521 8192000000 10414229056 10740695040 1468946064 15.204 100 87 174 0 1504957984 7370368 28641552
23:00:11 11627 8192000000 10430323600 10759155712 1479639968 15.298 100 82 165 1 1513551120 7809296 26101856
23:00:31 7678 8192000000 10441098480 10770550784 1496166464 15.443 100 89 178 0 1532798560 8165392 28466704
23:00:59 12251 8192000000 10460138064 10796470272 1514719264 15.604 100 86 171 1 1550107744 8747504 26640976
23:01:19 9408 8192000000 10468523360 10809565184 1532410480 15.758 100 81 162 1 1566821984 9196720 25214784
23:01:38 24840 8192000000 10503774448 10853933056 1560179648 15.998 100 82 164 2 1595494240 9778080 25536512
23:02:16 17136 8192000000 10544809728 10903023616 1609083824 16.417 100 72 144 0 1640418672 9853152 21481696
23:02:43 11844 8192000000 10575773648 10934214656 1634137040 16.630 100 82 164 0 1669279680 10977248 24165392
23:03:05 16478 8192000000 10618007504 10981810176 1666759072 16.906 100 79 158 2 1701949088 12232288 22957728
23:03:30 9518 8192000000 10638960544 11003928576 1690741776 17.108 100 88 175 1 1729400128 13056384 25601968
23:03:48 9466 8192000000 10643218096 11012943872 1703757696 17.217 100 82 164 1 1740656544 13485280 23413568
23:04:08 6865 8192000000 10655144448 11030343680 1718344736 17.338 100 82 164 1 1755427472 13465088 23617648
23:04:21 8641 8192000000 10664909392 11040292864 1729489440 17.431 100 76 152 0 1763754480 12751408 21513632
23:04:37 7786 8192000000 10681662080 11058667520 1743583536 17.548 100 85 170 0 1780479392 13041856 23854000
23:04:53 4579 8192000000 10692170592 11068141568 1754463808 17.639 100 80 162 0 1789349072 12350240 22535024
23:05:05 6020 8192000000 10699854592 11083407360 1766947072 17.742 100 74 148 2 1800003952 11753584 21303296
23:05:18 4857 8192000000 10718834064 11098624000 1774326768 17.803 100 81 162 0 1809815040 12819936 22668336
23:05:29 6754 8192000000 10718122720 11098001408 1782278672 17.868 100 85 170 0 1819686800 13374912 24033216
23:05:43 4655 8192000000 10730092944 11110428672 1789729824 17.930 100 81 161 3 1826253760 14184608 22339328
23:05:54 2548 8192000000 10741609488 11121799168 1797004208 17.989 100 92 186 0 1836882400 14590160 25288032
23:06:02 3363 8192000000 10747258400 11124482048 1801617488 18.027 100 90 180 2 1841085904 13984416 25484000
23:06:12 2031 8192000000 10750002192 11133616128 1813348400 18.123 100 93 179 2 1850846448 12872080 24625968
23:06:21 4304 8192000000 10755533808 11137462272 1809404704 18.091 100 79 158 2 1845254272 13713760 22135808
23:06:33 2208 8192000000 10758317552 11142979584 1816041680 18.145 100 83 165 0 1851614768 13423984 22149104
23:06:42 8860 8192000000 10764036656 11147628544 1821563328 18.190 100 82 162 2 1857357280 13518880 22275072
23:06:57 5137 8192000000 10761944416 11150872576 1822854400 18.201 100 78 157 0 1862125888 18007472 21264016
23:07:09 1604 8192000000 10783075840 11167866880 1841724768 18.355 100 90 179 1 1884767280 17729328 25313184
23:07:17 2243 8192000000 10779094016 11166130176 1843793632 18.372 100 92 185 1 1883801088 14031024 25976432
23:07:25 2297 8192000000 10792134416 11181187072 1848018304 18.406 100 86 172 0 1885842912 12968400 24856208
23:07:35 2377 8192000000 10792375648 11177066496 1850815760 18.429 100 93 187 0 1890973072 14003120 26154192
23:07:44 3203 8192000000 10801667936 11189297152 1854957616 18.462 100 94 186 2 1895831616 13422800 27451200
23:07:54 3321 8192000000 10800242560 11188883456 1859183680 18.497 100 88 178 1 1897999008 13394720 25420608
23:08:04 1346 8192000000 10806812096 11195371520 1861257008 18.513 100 94 189 1 1901735072 14077952 26400112
23:08:12 1420 8192000000 10810142912 11196211200 1866593776 18.557 100 94 188 0 1905438416 12508496 26336144
23:08:20 35338 8192000000 10779413472 11194486784 1858106976 18.488 100 62 124 2 1886832496 11873632 16851888
23:09:01 4245 8192000000 10768830144 11191939072 1862421360 18.523 100 43 87 3 1881419344 6302096 12695888
23:09:14 5353 8192000000 10774171296 11194159104 1859641760 18.500 100 44 86 2 1880383632 8433648 12308224
23:09:26 5934 8192000000 10794163520 11200950272 1863056224 18.528 100 42 81 1 1880209168 5890448 11262496
23:09:39 7906 8192000000 10781312064 11200868352 1865556176 18.548 100 36 72 1 1884013328 8331936 10125216
23:09:54 5723 8192000000 10789613248 11206197248 1864966048 18.544 100 28 55 2 1878902976 6218000 7718928
23:10:10 3996 8192000000 10797680112 11207077888 1869601632 18.581 100 33 66 3 1885623696 5900832 10121232
23:10:22 8148 8192000000 10767610832 11203854336 1867416384 18.563 100 13 26 1 1877213696 6392880 3404432
23:10:37 7041 8192000000 10786041520 11216146432 1875142256 18.626 100 25 50 2 1889176592 7205248 6829088
23:10:52 8379 8192000000 10787498784 11215511552 1874224000 18.618 100 16 31 0 1884885424 6255840 4405584
23:11:09 8762 8192000000 10790402032 11215155200 1876017760 18.633 100 23 47 0 1888226432 5565488 6643184
23:11:24 12016 8192000000 10792706400 11220373504 1883128192 18.690 100 24 48 3 1896145968 6348784 6668992
23:11:42 3727 8192000000 10808599536 11227951104 1886841328 18.720 100 34 69 3 1903372288 7526784 9004176
23:11:53 73114 8192000000 10797621072 11232653312 1888669600 18.735 100 24 48 2 1900921168 5034576 7216992
23:13:13 4406 8192000000 10806002608 11236495360 1887077136 18.722 100 28 54 1 1902033552 7545168 7411248
23:13:25 4912 8192000000 10796857056 11235115008 1889511424 18.742 100 19 38 2 1900469808 5292512 5665872
23:13:37 4369 8192000000 10808198048 11241381888 1893234032 18.772 100 24 48 0 1906466512 5678064 7554416
23:13:49 5194 8192000000 10821688400 11249020928 1896873360 18.801 100 36 70 0 1918731840 11316400 10542080
23:14:01 5701 8192000000 10807635328 11243687936 1896775008 18.800 100 20 40 1 1908873248 6041104 6057136
23:14:16 6488 8192000000 10826286128 11255975936 1900919648 18.834 100 35 70 2 1922409584 11941216 9548720
23:14:29 7801 8192000000 10812079072 11247681536 1900716352 18.832 100 27 54 1 1915025184 7116528 7192304
23:14:44 11938 8192000000 10812775840 11252285440 1903332016 18.853 100 19 38 2 1914795280 4990128 6473136
23:15:03 9196 8192000000 10823453792 11255836672 1905988224 18.874 100 25 50 1 1919869456 6626624 7254608
23:15:21 7167 8192000000 10806241760 11250335744 1902379888 18.845 100 19 38 0 1913895120 5890160 5625072
23:15:37 10378 8192000000 10811560896 11253407744 1902832784 18.849 100 17 35 2 1913148720 5616128 4699808
23:15:54 8341 8192000000 10811635632 11251044352 1887416448 18.725 99 21 42 0 1898915376 5816992 5681936
23:16:08 10022 8192000000 10809451488 11242692608 1865255424 18.546 98 18 37 1 1875864144 5294816 5313904
23:16:26 70125 8192000000 10794550672 11230408704 1855416448 18.466 98 38 76 3 1872282544 5235248 11630848
23:17:44 8937 8192000000 10805293056 11235315712 1885742976 18.711 100 24 48 1 1898496016 5795424 6957616
23:18:00 6141 8192000000 10808963216 11221999616 1852949344 18.446 98 33 64 2 1872769024 10901072 8918608
23:18:13 7577 8192000000 10759178512 11182526464 1744216912 17.554 93 22 44 1 1756246544 5950944 6078688
23:18:27 6556 8192000000 10768266400 11194322944 1852779968 18.445 100 24 48 1 1865410128 5814464 6815696
23:18:39 4218 8192000000 10748205408 11166244864 1790380032 17.935 96 27 54 3 1803607888 4736832 8491024
23:18:51 9308 8192000000 10745462384 11156488192 1753140032 17.628 95 35 69 3 1769187472 5885344 10162096
23:19:07 7322 8192000000 10714539648 11141951488 1806945312 18.071 100 23 46 1 1819714688 6156464 6612912
23:19:24 8947 8192000000 10730928640 11138461696 1749889024 17.601 96 15 30 0 1759223616 5052512 4282080
23:19:43 9857 8192000000 10692513424 11105742848 1743435824 17.547 98 23 46 0 1755153776 5400880 6317072
23:19:59 10950 8192000000 10636962960 11037667328 1625266512 16.555 91 22 45 0 1636626144 4723776 6635856
23:20:17 10025 8192000000 10696583296 11113558016 1746192048 17.570 98 26 52 3 1763632928 10736336 6704544
23:20:37 8822 8192000000 10691288800 11103109120 1748362144 17.588 98 31 61 2 1762042272 5081392 8598736
23:20:53 63223 8192000000 10707329088 11126951936 1762018480 17.701 98 29 58 3 1775384416 5048512 8317424
23:22:03 12034 8192000000 10699906384 11118116864 1742703920 17.541 97 17 31 1 1752668352 5229088 4735344
23:22:22 6446 8192000000 10739668656 11148587008 1812086896 18.113 100 28 56 1 1826772944 6620560 8065488
23:22:39 7144 8192000000 10747262272 11164086272 1830693024 18.265 100 25 50 1 1844193824 5822880 7677920
23:22:55 8763 8192000000 10746522848 11177189376 1835010048 18.300 100 26 52 1 1848359920 6158560 7191312
23:23:11 7010 8192000000 10756740272 11178029056 1841631936 18.354 100 28 56 1 1855055600 5294016 8129648
23:23:25 7665 8192000000 10757556848 11185594368 1847636880 18.403 100 27 55 2 1861570592 6260576 7673136
23:23:42 8743 8192000000 10761108688 11181322240 1841014768 18.349 100 20 40 0 1855545952 9040880 5490304
23:23:57 10664 8192000000 10759655680 11188776960 1845686976 18.387 100 18 36 1 1855756256 5243808 4825472
23:24:14 8853 8192000000 10766187536 11194781696 1850378016 18.425 100 17 34 0 1860493104 5640128 4474960
23:24:33 6802 8192000000 10768456240 11200446464 1858342976 18.490 100 18 36 0 1869773040 5886336 5543728
23:24:48 7096 8192000000 10783289200 11205955584 1862838096 18.526 100 20 40 0 1874340992 6195440 5307456
23:25:02 13941 8192000000 10774079328 11205632000 1863379328 18.531 100 13 26 0 1876839600 9800000 3660272
23:25:22 18403 8192000000 10770686016 11203076096 1867856144 18.567 100 29 58 2 1884008112 6034944 10117024
23:25:49 66558 8192000000 10780943088 11212779520 1873623360 18.614 100 39 78 0 1890704464 5625280 11455824
23:27:02 12077 8192000000 10803548016 11229634560 1882197008 18.683 100 25 50 1 1894012624 5103856 6711760
23:27:20 18193 8192000000 10827796544 11248488448 1899212256 18.820 100 42 83 1 1916184912 5376160 11596496
23:27:50 2744 8192000000 10843410752 11259863040 1910982096 18.915 100 61 120 2 1935697472 8013968 16701408
23:28:00 52903 8192000000 10866267680 11286843392 1927851504 19.050 100 57 114 0 1953752352 10481840 15419008
23:29:01 17900 8192000000 10858012352 11285651456 1937702848 19.128 100 48 94 1 1960190624 8466432 14021344
23:29:26 30946 8192000000 10880302272 11299635200 1943171312 19.172 100 53 104 2 1967288496 8881696 15235488
23:30:10 14134 8192000000 10881985184 11310166016 1950537280 19.231 100 46 90 3 1975584896 12215488 12832128
23:30:47 38924 8192000000 10905022400 11338637312 1965327968 19.348 100 43 86 1 1994111184 15662464 13120752
23:31:32 17164 8192000000 10906892144 11337338880 1969489600 19.381 100 39 78 1 1998657680 17691616 11476464
23:32:08 7280 8192000000 10910045872 11338801152 1967266688 19.364 100 41 80 0 1996638912 17569280 11802944
23:32:22 12726 8192000000 10914731120 11346444288 1974623168 19.422 100 40 80 1 2006987232 19817200 12546864
23:32:46 20261 8192000000 10922457952 11359506432 1978370096 19.452 100 41 81 2 2016123408 25651536 12101776
23:33:24 21183 8192000000 10926186768 11365396480 1984281344 19.499 100 37 74 0 2019117616 23290304 11545968
23:33:55 18232 8192000000 10935726880 11368071168 1987674608 19.525 100 37 74 1 2022109440 23397408 11037424
23:34:35 17325 8192000000 10941093728 11379093504 1995322912 19.586 100 49 98 0 2036931088 26523488 15084688
23:34:59 7026 8192000000 10946141952 11378782208 1991985216 19.559 100 53 106 2 2034577936 26360304 16232416
23:35:17 2257 8192000000 10954894592 11378008064 1995785136 19.589 100 68 135 0 2043411968 26219888 21406944
23:35:27 7277 8192000000 10953875760 11386331136 1998915344 19.614 100 59 118 2 2045310656 28392960 18002352
23:35:42 4514 8192000000 10961613808 11395633152 2007061072 19.678 100 65 129 1 2055492960 29724032 18707856
23:35:57 3911 8192000000 10970816992 11395305472 2007439920 19.681 100 68 133 2 2057942976 30080752 20422304
23:36:07 5820 8192000000 10970801040 11398537216 1989977536 19.544 99 68 134 0 2042679360 31820432 20881392
23:36:19 4011 8192000000 10974075168 11402821632 2009630480 19.699 100 75 150 2 2064716624 32393728 22692416
23:36:31 1964 8192000000 10987280272 11408842752 2013657744 19.730 100 82 164 2 2071614384 33231488 24725152
23:36:39 3833 8192000000 10975696288 11405344768 2011251872 19.711 100 82 165 0 2069926640 33808400 24866368
23:36:50 4178 8192000000 10976738912 11398205440 2004418464 19.658 100 81 161 2 2062332208 33733888 24179856
23:37:03 9384 8192000000 10971799536 11397271552 2002330624 19.641 100 76 151 2 2055584768 30695568 22558576
23:37:21 5007 8192000000 10962410672 11396620288 2004039904 19.655 100 63 127 1 2054959504 31316208 19603392
23:37:38 7590 8192000000 10978628816 11410456576 2015220720 19.743 100 60 120 3 2064379120 30726848 18431552
23:37:54 5944 8192000000 10975319600 11410558976 2011992816 19.717 100 52 105 1 2058759792 30847664 15919312
23:38:07 2729 8192000000 10968308848 11396550656 2001635712 19.636 99 68 136 1 2053589776 32076480 19877584
23:38:19 2231 8192000000 10981047040 11406524416 2012227408 19.719 100 82 162 2 2070443792 33671088 24545296
23:38:28 7206 8192000000 10983559152 11413278720 2016197216 19.750 100 77 154 0 2075325040 35514080 23613744
23:38:44 5252 8192000000 10986600256 11413397504 2015768864 19.747 100 66 132 0 2073742080 38136736 19836480
23:39:00 2967 8192000000 10997733840 11418259456 2020389424 19.783 100 67 129 0 2075770784 35420224 19961136
23:39:10 6830 8192000000 11000425136 11426013184 2024300832 19.814 100 71 142 2 2083408576 37421056 21686688
23:39:27 2792 8192000000 11014111136 11434868736 2031376816 19.869 100 85 166 1 2094934416 38045296 25512304
23:39:36 3194 8192000000 11001683168 11424219136 2020649152 19.785 100 83 166 0 2083562368 37607680 25305536
23:39:46 4456 8192000000 11011314512 11426099200 2021499696 19.792 100 81 162 4 2084365024 38498848 24366480
23:39:58 5773 8192000000 10983354064 11408412672 1980223856 19.466 98 77 154 3 2042184416 38381168 23579392
23:40:11 5665 8192000000 10994293920 11417468928 2011235024 19.711 100 76 152 0 2077050384 42640880 23174480
23:40:40 7448 8192000000 11000480320 11426902016 2017396560 19.760 100 70 140 5 2084500528 44649600 22454368
23:40:57 5405 8192000000 11001968416 11431628800 2019264000 19.774 100 68 134 2 2086979952 46701456 21014496
23:41:10 2308 8192000000 10971960288 11385004032 1979447168 19.460 98 88 175 2 2053753248 47390944 26915136
23:41:19 2678 8192000000 10984117152 11411881984 2000104160 19.624 100 75 148 2 2072278736 48098560 24076016
23:41:30 1783 8192000000 10977299328 11394162688 1973402240 19.412 99 80 156 3 2045445696 47648416 24395040
23:41:39 2191 8192000000 10974124176 11393142784 1980910464 19.472 100 87 174 4 2056612432 48548608 27153360
23:41:49 7302 8192000000 10965727344 11396243456 1978975696 19.457 100 72 144 0 2050817680 49412880 22429104
23:42:05 3843 8192000000 10976452032 11398250496 1983386320 19.492 100 76 150 2 2055240032 48713104 23140608
23:42:16 2705 8192000000 10976493488 11396435968 1984610512 19.501 100 79 159 2 2059254144 49691232 24952400
23:42:26 1982 8192000000 10983796736 11400966144 1984274848 19.499 100 79 157 1 2060013568 51002960 24735760
23:42:36 2278 8192000000 10981728016 11405193216 1991489344 19.556 100 79 156 0 2065560992 48361520 25710128
23:42:47 3457 8192000000 10979293344 11387944960 1979778880 19.463 100 87 172 1 2053079824 46315280 26985664
23:42:57 5047 8192000000 10971977808 11399258112 1986197136 19.514 100 73 146 1 2057914224 48504656 23212432
23:43:11 2436 8192000000 10962777232 11391561728 1985852336 19.511 100 66 132 1 2049634000 42950688 20830976
23:43:20 3418 8192000000 10959139888 11380383744 1973848992 19.416 100 74 146 1 2040224144 43245312 23129840
23:43:30 6712 8192000000 10946202160 11369267200 1952199856 19.244 99 60 119 2 2015051344 44114176 18737312
23:43:47 8238 8192000000 10952962384 11384606720 1975260752 19.427 100 51 102 1 2036246672 43379328 17606592
23:44:18 5233 8192000000 10947234768 11376640000 1972727280 19.407 100 57 111 1 2030962432 40554720 17680432
23:44:33 5036 8192000000 10950213056 11382267904 1982515376 19.485 100 65 129 2 2044190192 40072112 21602704
23:44:47 8529 8192000000 10946603840 11384688640 1978796672 19.455 100 53 106 3 2036437440 39490976 18149792
23:45:02 13711 8192000000 10938788288 11373441024 1937864880 19.130 98 40 80 0 1992967312 40833888 14268544
23:45:57 14018 8192000000 10931870208 11361652736 1939996208 19.147 99 47 94 0 2000220640 44429984 15794448
23:46:21 10363 8192000000 10939827520 11374567424 1942797408 19.169 99 49 98 3 2010050160 50847536 16405216
23:46:42 16302 8192000000 10911785824 11350835200 1923658560 19.016 98 37 74 3 1986258112 49739360 12860192
23:47:05 9325 8192000000 10922295520 11366019072 1944686736 19.184 100 41 82 0 2009938256 51206576 14044944
23:47:31 8825 8192000000 10915878592 11352297472 1909157440 18.900 99 38 76 0 1982112112 59679584 13275088
23:47:48 7874 8192000000 10898058608 11339169792 1931949904 19.082 100 41 82 1 1992522928 46522048 14050976
23:48:06 29887 8192000000 10910643360 11357560832 1940499552 19.151 100 29 58 0 1995991824 44863200 10629072
23:49:04 15746 8192000000 10892921328 11354288128 1928874816 19.058 99 20 40 1 1965614928 29790016 6950096
23:49:39 26296 8192000000 10889025840 11335622656 1880292448 18.667 97 23 46 2 1926438368 37494784 8651136
23:50:14 27875 8192000000 10879580448 11332489216 1898571760 18.815 98 24 47 1 1945083504 38326624 8185120
23:50:49 25299 8192000000 10850167792 11309076480 1876135360 18.634 97 15 30 0 1907037744 25542160 5360224
23:51:21 46183 8192000000 10851833296 11315855360 1909828896 18.905 99 11 22 2 1925480432 12171120 3480416
23:52:18 11326 8192000000 10872043456 11315187712 1936083376 19.115 100 41 83 1 1955293072 6876432 12333264
23:52:39 7140 8192000000 10892012608 11328327680 1944051168 19.179 100 36 73 1 1964448432 10064160 10333104
23:52:53 17492 8192000000 10883276688 11332575232 1949469280 19.222 100 40 76 1 1972511296 10553920 12488096
23:53:20 68761 8192000000 10833971440 11299475456 1850456336 18.426 96 24 48 2 1870813872 13961744 6395792
23:54:35 47690 8192000000 10814811600 11262881792 1823118624 18.203 95 35 70 4 1842198144 9589088 9490432
23:55:54 94891 8192000000 10833585536 11276967936 1805540720 18.059 94 18 36 3 1819370656 9101264 4728672
23:57:36 57776 8192000000 10829537008 11279003648 1838702544 18.330 96 20 40 1 1855374720 11659328 5012848
23:58:50 113459 8192000000 10869940368 11299745792 1896892288 18.801 99 29 58 0 1922426944 16314992 9219664
00:01:04 187283 8192000000 10880801632 11343339520 1907863728 18.889 98 29 59 2 1929706464 13163280 8679456
00:04:21 59440 8192000000 10868964128 11342479360 1927871088 19.050 99 10 20 1 1945950960 14707856 3372016
00:05:27 127827 8192000000 10891951792 11360280576 1912061296 18.923 98 12 24 0 1931530208 15461264 4007648
00:07:44 49078 8192000000 10892042624 11365425152 1966813632 19.360 100 12 24 0 1980574096 10029760 3730704
00:08:45 39269 8192000000 10911240320 11377561600 1978063536 19.449 100 18 36 1 1994365408 10600368 5701504
00:09:34 70187 8192000000 10924947536 11400196096 1987922272 19.527 100 21 42 1 2014554016 19930464 6701280
00:11:09 46137 8192000000 10936263456 11399405568 1991705520 19.557 100 24 48 4 2017343936 18480576 7157840
00:12:13 59156 8192000000 10914650992 11404341248 1968425248 19.373 99 13 26 0 1991389632 19238784 3725600
00:13:19 97900 8192000000 10934005920 11398578176 1976259296 19.435 99 13 26 0 1991878944 11999696 3619952
00:15:10 49430 8192000000 10942930400 11409932288 1965063040 19.346 98 31 54 1 1988223104 16005040 7155024
00:16:14 77571 8192000000 10937403664 11425292288 2004440384 19.658 100 15 30 1 2026017520 17123472 4453664
00:18:15 99738 8192000000 10931031136 11407089664 1944722192 19.184 97 11 22 1 1959106368 11445856 2938320
00:20:02 54804 8192000000 10928055280 11391475712 1960346560 19.309 98 21 42 0 1975736368 9679488 5710320
00:21:05 10934 8192000000 10933699056 11392323584 1983862944 19.495 99 34 68 3 2006819488 13539104 9417440
00:21:25 32274 8192000000 10920998320 11382034432 1955189872 19.268 98 35 70 0 1974588192 10232544 9165776
00:22:04 41516 8192000000 10915343760 11389337600 1965028336 19.346 99 25 50 1 1983308496 11279824 7000336
00:22:52 47576 8192000000 10896994704 11355156480 1923036592 19.011 97 23 46 1 1941109888 11596496 6476800
00:23:46 19606 8192000000 10921831232 11378384896 1975900768 19.432 100 29 56 2 1996722512 12623168 8198576
00:24:12 46228 8192000000 10917252480 11397533696 1982173712 19.482 100 20 40 1 2006226880 18317840 5735328
00:25:06 48507 8192000000 10926161280 11395624960 1974767888 19.423 99 9 18 0 1992125216 15009936 2347392
00:26:01 121855 8192000000 10928929328 11389300736 1955668368 19.272 98 27 54 0 1977149216 13744128 7736720
00:28:13 72050 8192000000 10890356624 11366199296 1945046048 19.187 98 20 40 3 1964251120 13277312 5927760
00:29:32 12432 8192000000 10853273296 11320258560 1885385840 18.709 96 9 18 0 1897356592 9851104 2119648
00:30:20 66003 8192000000 10884580960 11369373696 1959134176 19.299 100 12 24 0 1975148704 12725392 3289136
00:31:32 34324 8192000000 10891690992 11371159552 1951893232 19.242 99 15 30 0 1972580448 16763200 3924016
00:32:13 39636 8192000000 10875756112 11350732800 1907482928 18.886 97 12 23 1 1929107936 18591280 3033728
00:32:58 35450 8192000000 10871577680 11339497472 1934697888 19.104 99 8 17 0 1943558624 6928576 1932160
00:33:41 55145 8192000000 10863555008 11333349376 1859166592 18.497 95 14 27 2 1869737344 6449040 4121712
00:34:44 65728 8192000000 10862673120 11326210048 1841270720 18.351 94 23 45 0 1857966784 10115152 6580912
00:36:03 31013 8192000000 10870086176 11320496128 1914604896 18.944 99 30 60 1 1937764080 13908448 9250736
00:36:49 20142 8192000000 10863843152 11315478528 1907036848 18.883 98 43 87 0 1932631376 12561424 13033104
00:37:18 92087 8192000000 10835712736 11315994624 1788916640 17.923 93 9 18 1 1809057744 17361568 2779536
00:38:56 42923 8192000000 10851579024 11305558016 1889126544 18.739 98 29 58 0 1908292960 11069472 8096944
00:39:47 56405 8192000000 10839374336 11288604672 1785410336 17.894 93 21 42 1 1800622192 9362272 5849584
00:40:58 31313 8192000000 10834500080 11284606976 1851683360 18.436 97 31 62 3 1872391552 11647168 9061024
00:41:37 70482 8192000000 10873379440 11334860800 1893942592 18.778 98 33 66 0 1917812656 14788080 9081984
00:43:01 59860 8192000000 10870835632 11325816832 1853225776 18.448 96 21 41 1 1871898224 13020320 5652128
00:44:12 73575 8192000000 10859072768 11332935680 1900226944 18.828 99 14 28 1 1917669504 13515568 3926992
00:46:01 86950 8192000000 10876063008 11354288128 1860601456 18.508 96 11 22 0 1885161808 21077776 3482576
00:47:35 82735 8192000000 10881879472 11334549504 1924253680 19.021 99 35 70 1 1947418496 13096016 10068800
00:49:08 101270 8192000000 10861844624 11335774208 1883703616 18.695 97 19 38 0 1902941920 13804800 5433504
00:50:57 30542 8192000000 10881286304 11357167616 1943745840 19.177 100 15 30 0 1964793504 16498160 4549504
00:51:38 42340 8192000000 10857908928 11345809408 1928126416 19.052 99 22 44 2 1952573472 17885264 6561792
00:53:45 75932 8192000000 10888110160 11360120832 1959133520 19.299 100 12 24 0 1973097664 10679952 3284192
00:55:46 63319 8192000000 10861999008 11342733312 1934060336 19.099 99 16 30 0 1947864272 9809968 3993968
00:56:57 68116 8192000000 10883612224 11373531136 1949590896 19.223 99 24 48 2 1964942112 9319728 6031488
00:58:12 45861 8192000000 10921233472 11389906944 1981312576 19.475 100 20 38 0 1996974992 10564688 5097728
00:59:08 25688 8192000000 10916343296 11392819200 1970047104 19.386 99 26 52 2 1991755152 14557168 7150880
00:59:48 56260 8192000000 10893591760 11369029632 1908848704 18.897 96 22 44 1 1930645200 15315392 6481104
01:00:50 74091 8192000000 10920403936 11388289024 1939887312 19.146 98 13 26 0 1953889472 10409904 3592256
01:02:12 53057 8192000000 10933280592 11404521472 1991455216 19.555 100 31 60 2 2015781328 15391344 8934768
01:03:12 66502 8192000000 10925590016 11409686528 1972236688 19.403 99 15 30 0 1996458048 19842768 4378592
01:04:44 64328 8192000000 10927333840 11384836096 1929410048 19.062 97 13 27 0 1953308176 20682928 3215200
01:05:59 69146 8192000000 10918053328 11388866560 1952180080 19.244 98 23 46 0 1975393200 17063376 6149744
01:07:17 89769 8192000000 10916999632 11390410752 1953610496 19.255 98 19 39 1 1970022016 9983968 6427552
01:09:39 77956 8192000000 10933198416 11404742656 1958715488 19.296 98 24 47 2 1978315216 12934512 6665216
01:11:14 16969 8192000000 10930058928 11383029760 1967274032 19.364 99 43 86 3 1990900240 11699568 11926640
01:11:38 15071 8192000000 10926142288 11379982336 1941359776 19.158 98 37 74 0 1967624784 15789328 10475680
01:11:59 96073 8192000000 10897576976 11361234944 1941885872 19.162 98 38 76 0 1968341200 15488336 10966992
01:13:58 59678 8192000000 10880422672 11359952896 1931686080 19.080 98 14 28 1 1948067536 11995040 4386416
01:15:08 53489 8192000000 10891893568 11373539328 1954508720 19.262 99 30 61 0 1973238112 10695968 8033424
01:16:16 61715 8192000000 10879936832 11373563904 1951277248 19.237 99 3 6 0 1961953936 10017632 659056
01:17:24 15714 8192000000 10877568592 11358674944 1922615424 19.008 98 2 4 0 1933034448 9891552 527472
01:17:46 24517 8192000000 10866062480 11349139456 1937194704 19.124 99 6 12 1 1946461536 7989264 1277568
01:18:17 43126 8192000000 10876037680 11358314496 1940584032 19.151 99 13 26 0 1951378848 7480464 3314352
01:19:08 77701 8192000000 10861089392 11335335936 1890130448 18.747 96 12 24 0 1904306128 10318432 3857248
01:21:35 47502 8192000000 10882854016 11348320256 1939689824 19.144 99 33 66 0 1960104464 10590976 9823664
01:22:36 45314 8192000000 10892461472 11374686208 1964008032 19.338 100 16 32 1 1978092336 9447776 4636528
01:23:28 79864 8192000000 10876530544 11356094464 1910764256 18.913 97 12 24 1 1926193376 11661216 3767904
01:25:04 55851 8192000000 10884790224 11364208640 1952952064 19.250 100 18 36 0 1969903840 12171904 4779872
01:26:13 58558 8192000000 10841131744 11313360896 1832633648 18.281 94 12 24 0 1847327760 11127824 3566288

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 28-02-2021 01:28:41 to 28-02-2021 01:29:11.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 127 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-02-2021 01:29:12 to 28-02-2021 01:29:14.

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          243159
MON$OLDEST_ACTIVE               244283
MON$OLDEST_SNAPSHOT             244283
MON$NEXT_TRANSACTION            244283
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                       2018816
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:401: 
:402: mscs-test-161.budzdorov.ru    Sun Feb 28 01:27:22 2021
:403:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:404: 
:405: 
:406: mscs-test-161.budzdorov.ru    Sun Feb 28 01:27:23 2021
:407:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:408: 
--- end of diff output ---

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

28.02.21 01:29:15. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-02-28 01:29:18 No severe PSQL-related problems occured
28.02.21 01:29:19. End of report.