Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.06.2021 22: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 58e1ddde69c44dad93d327777e5becec
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-05-09 08:45
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 4793.92
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 17044512 kB
MemAvailable 31412460 kB
Buffers 0 kB
Cached 14596556 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-06-10 22:27:36
DTS_END                         2021-06-10 22:27:36.3290
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_MAKE_INVNT_SALDO(40:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/42446
TRN_ID                          243325
ATT_ID                          714
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: 9615.84 19625 1153901
customer order: creation 177.04 352 21245
customer order: refuse 14.92 403 1790
order to supplier: creation 45.25 1368 5430
order to supplier: removal 3.47 103852 416
invoice (draft): creation 46.30 3492 5556
invoice (draft): removal 55.93 786 6712
invoice accept: apply 42.45 17350 5094
invoice accept: cancel 51.13 829 6136
customer reserve: creation 3870.72 173 464486
customer reserve: removal 5007.27 56 600872
realization accept: apply 85.71 229 10285
realization accept: cancel 83.79 99 10055
payment from customer: creation 60.45 133 7254
payment from customer: removal 5.58 83 669
payment to supplier: creation 49.73 135 5967
payment to supplier: removal 3.43 67 412
service: total inventory turnovers 5.02 989 602
service: total monetary turnovers 6.80 24 816
service: aggregate perf. data 0.83 20824 100
service: refresh index statistics 0.03 241261 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-06-2021 22:28:08 to 10-06-2021 22:28:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6217
TEST_TIME 2 3838
TEST_TIME 3 4074
TEST_TIME 4 5277
TEST_TIME 5 4954
TEST_TIME 6 6032
TEST_TIME 7 6034
TEST_TIME 8 5726
TEST_TIME 9 5772
TEST_TIME 10 5873
TEST_TIME 11 5597
TEST_TIME 12 5994
TEST_TIME 13 5962
TEST_TIME 14 6045
TEST_TIME 15 6239
TEST_TIME 16 6602
TEST_TIME 17 6723
TEST_TIME 18 7118
TEST_TIME 19 7217
TEST_TIME 20 7308
TEST_TIME 21 7795
TEST_TIME 22 8054
TEST_TIME 23 8141
TEST_TIME 24 8729
TEST_TIME 25 8961
TEST_TIME 26 9716
TEST_TIME 27 9523
TEST_TIME 28 9630
TEST_TIME 29 10635
TEST_TIME 30 10876
TEST_TIME 31 10789
TEST_TIME 32 10609
TEST_TIME 33 10514
TEST_TIME 34 10513
TEST_TIME 35 10810
TEST_TIME 36 10856
TEST_TIME 37 10758
TEST_TIME 38 10753
TEST_TIME 39 10578
TEST_TIME 40 10458
TEST_TIME 41 10249
TEST_TIME 42 10165
TEST_TIME 43 10107
TEST_TIME 44 10137
TEST_TIME 45 10117
TEST_TIME 46 10043
TEST_TIME 47 10128
TEST_TIME 48 10117
TEST_TIME 49 10041
TEST_TIME 50 9949
TEST_TIME 51 9968
TEST_TIME 52 9950
TEST_TIME 53 9859
TEST_TIME 54 9755
TEST_TIME 55 9757
TEST_TIME 56 9730
TEST_TIME 57 9764
TEST_TIME 58 9650
TEST_TIME 59 9642
TEST_TIME 60 9595
TEST_TIME 61 9533
TEST_TIME 62 9535
TEST_TIME 63 9636
TEST_TIME 64 9561
TEST_TIME 65 9657
TEST_TIME 66 9819
TEST_TIME 67 9873
TEST_TIME 68 9879
TEST_TIME 69 9852
TEST_TIME 70 9784
TEST_TIME 71 9876
TEST_TIME 72 9905
TEST_TIME 73 9899
TEST_TIME 74 9936
TEST_TIME 75 9841
TEST_TIME 76 9807
TEST_TIME 77 9828
TEST_TIME 78 9746
TEST_TIME 79 9709
TEST_TIME 80 9663
TEST_TIME 81 9639
TEST_TIME 82 9603
TEST_TIME 83 9614
TEST_TIME 84 9630
TEST_TIME 85 9624
TEST_TIME 86 9628
TEST_TIME 87 9631
TEST_TIME 88 9652
TEST_TIME 89 9606
TEST_TIME 90 9690
TEST_TIME 91 9677
TEST_TIME 92 9667
TEST_TIME 93 9671
TEST_TIME 94 9721
TEST_TIME 95 9791
TEST_TIME 96 9781
TEST_TIME 97 9779
TEST_TIME 98 9807
TEST_TIME 99 9710
TEST_TIME 100 9735
TEST_TIME 101 9708
TEST_TIME 102 9682
TEST_TIME 103 9651
TEST_TIME 104 9637
TEST_TIME 105 9587
TEST_TIME 106 9555
TEST_TIME 107 9568
TEST_TIME 108 9544
TEST_TIME 109 9542
TEST_TIME 110 9505
TEST_TIME 111 9599
TEST_TIME 112 9566
TEST_TIME 113 9582
TEST_TIME 114 9584
TEST_TIME 115 9543
TEST_TIME 116 9643
TEST_TIME 117 9641
TEST_TIME 118 9603
TEST_TIME 119 9653
TEST_TIME 120 9619

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-06-2021 22:28:12 to 10-06-2021 22:28:15.

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 1585872 1585872 0 0.00 0 28467 6 0 0
doc_list_biud 1585869 1585869 0 0.00 0 53312 28 0 0
sp_add_invoice_to_stock 5213 5094 119 2.28 62 176377 17350 0 119
sp_cancel_adding_invoice 6136 6136 0 0.00 4 57083 829 0 0
sp_cancel_client_order 1790 1790 0 0.00 4 19340 404 0 0
sp_cancel_customer_reserve 600872 600872 0 0.00 1 53315 57 0 0
sp_cancel_pay_from_customer 669 669 0 0.00 3 6199 83 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 3086 68 0 0
sp_cancel_supplier_invoice 6720 6712 8 0.11 1 28853 787 0 8
sp_cancel_supplier_order 416 416 0 0.00 9 1281989 103853 0 0
sp_cancel_write_off 10055 10055 0 0.00 1 13159 100 0 0
sp_client_order 21245 21245 0 0.00 4 25585 352 0 0
sp_customer_reserve 464486 464486 0 0.00 0 45257 173 0 0
sp_fill_shopping_cart 32222 32222 0 0.00 1 21504 37 0 0
sp_fill_shopping_cart_clo_res 464476 464476 0 0.00 0 33468 12 0 0
sp_get_clo_for_invoice 5084 5084 0 0.00 0 30719 273 0 0
sp_kill_cost_storno 17272 17272 0 0.00 0 18456 54 0 0
sp_kill_qstorno_ret_qs2qd 1218927 1218927 0 0.00 0 53307 31 0 0
sp_kill_qty_storno 641348 641348 0 0.00 0 53311 68 0 0
sp_lock_selected_doc 21231 21231 0 0.00 0 9138 6 0 0
sp_make_cost_storno 28589 28589 0 0.00 0 19062 59 0 0
sp_multiply_rows_for_pdistr 28588 28588 0 0.00 0 12864 34 0 0
sp_multiply_rows_for_qdistr 21245 21245 0 0.00 0 22259 144 0 0
sp_pay_from_customer 7254 7254 0 0.00 4 18779 134 0 0
sp_pay_to_supplier 5967 5967 0 0.00 5 17017 136 0 0
sp_payment_common 13220 13220 0 0.00 2 11715 32 0 0
sp_qd_handle_on_cancel_clo 1790 1790 0 0.00 0 19331 373 0 0
sp_qd_handle_on_invoice_upd_sts 11218 11218 0 0.00 0 36148 333 0 0
sp_qd_handle_on_reserve_upd_sts 10285 10285 0 0.00 0 36827 95 0 0
sp_reserve_write_off 10285 10285 0 0.00 6 37172 230 0 0
sp_supplier_invoice 5556 5556 0 0.00 6 88079 3493 0 0
sp_supplier_order 5430 5430 0 0.00 5 54794 1368 0 0
srv_aggregate_perf_data 100 100 0 0.00 2421 355798 20825 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 786 120583 30750 0 0
srv_find_qd_qs_mism 1106463 1106463 0 0.00 0 16343 5 0 0
srv_make_invnt_saldo 602 602 0 0.00 19 56618 989 0 0
srv_make_money_saldo 816 816 0 0.00 1 1006 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 154253 404105 241262 0 0
t$perf-abend:sp_add_invoice_to_stock 119 119 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5094 5094 0 0.00 0 16182 162 0 0
t$perf-norm:sp_cancel_adding_invoice 446 446 0 0.00 0 2414 79 0 0
t$perf-norm:sp_cancel_client_order 1790 1790 0 0.00 0 6213 20 0 0
t$perf-norm:sp_cancel_customer_reserve 659 659 0 0.00 0 3378 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 669 669 0 0.00 0 5089 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 549 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 11180 38 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 19069 1675 0 0
t$perf-norm:sp_cancel_write_off 1071 1071 0 0.00 0 325 4 0 0
t$perf-norm:sp_client_order 21245 21245 0 0.00 0 12229 20 0 0
t$perf-norm:sp_customer_reserve 1009 1009 0 0.00 0 6255 17 0 0
t$perf-norm:sp_pay_from_customer 7254 7254 0 0.00 0 5046 10 0 0
t$perf-norm:sp_pay_to_supplier 5967 5967 0 0.00 0 6064 6 0 0
t$perf-norm:sp_reserve_write_off 10285 10285 0 0.00 0 6546 15 0 0
t$perf-norm:sp_supplier_invoice 5556 5556 0 0.00 0 8472 19 0 0
t$perf-norm:sp_supplier_order 5430 5430 0 0.00 0 4736 18 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 264 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 547 8 0 0
t$perf-norm:srv_make_invnt_saldo 602 602 0 0.00 0 1927 25 0 0
t$perf-norm:srv_make_money_saldo 816 816 0 0.00 0 3622 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 5 0 0
v_add_invoice_to_stock 10396 10158 238 2.28 0 4508 20 0 238
v_all_customers 38426 38426 0 0.00 0 49 1 0 0
v_all_suppliers 30742 30742 0 0.00 0 116 1 0 0
v_all_wares 42488 42488 0 0.00 0 115 1 0 0
v_cancel_adding_invoice 892 892 0 0.00 0 1367 7 0 0
v_cancel_client_order 3580 3580 0 0.00 0 3625 7 0 0
v_cancel_customer_prepayment 1338 1338 0 0.00 0 3033 9 0 0
v_cancel_customer_reserve 1318 1318 0 0.00 0 10500 14 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 3075 7 0 0
v_cancel_supplier_invoice 820 804 16 1.95 0 448 13 0 16
v_cancel_supplier_order 832 832 0 0.00 0 2759 13 0 0
v_cancel_write_off 2142 2142 0 0.00 0 11309 24 0 0
v_max_id_clo_ord 5430 5430 0 0.00 0 1112 2 0 0
v_max_id_clo_res 1009 1009 0 0.00 0 1873 13 0 0
v_max_id_ord_sup 5548 5548 0 0.00 0 6187 5 0 0
v_max_non_paid_invoice 1574 1574 0 0.00 0 3858 5 0 0
v_max_non_paid_realizn 3882 3882 0 0.00 0 1109 3 0 0
v_min_id_clo_ord 5430 5430 0 0.00 0 21479 16 0 0
v_min_id_clo_res 1009 1009 0 0.00 0 332 2 0 0
v_min_id_ord_sup 5548 5548 0 0.00 0 8215 8 0 0
v_min_non_paid_invoice 5967 5967 0 0.00 0 6560 19 0 0
v_min_non_paid_realizn 7253 7253 0 0.00 0 8297 21 0 0
v_our_firm 10804 10804 0 0.00 0 117 1 0 0
v_reserve_write_off 20570 20570 0 0.00 0 12606 8 0 0
x_lock_depdocs_on_canc_invoice 12446 12446 0 0.00 0 23127 111 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 6670 330 0 0
x_make_qstorno_1000_1200 5430 5430 0 0.00 2 54783 1279 0 0
x_make_qstorno_1200_2000 5556 5556 0 0.00 3 88052 3369 0 0
x_make_qstorno_2100_3300 464486 464486 0 0.00 0 45255 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-06-2021 22:28:16 to 10-06-2021 22:28:20.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:40 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:46 20090 8192000000 10249645696 10557374464 907478144 9.972 71 55 111 0 928854880 2737392 18639344
19:58:17 23576 8192000000 10329893296 10646433792 1383163728 14.445 100 88 175 2 1417344464 4794432 29386304
19:58:51 7934 8192000000 10347016544 10667409408 1408612528 14.672 100 85 170 0 1442334080 5819888 27901664
19:59:10 32664 8192000000 10403738560 10727895040 1445866480 15.001 100 92 184 0 1483481888 7066672 30548736
19:59:57 19401 8192000000 10417199216 10745843712 1473796080 15.247 100 92 184 0 1511969360 8033440 30139840
20:00:28 18542 8192000000 10441366528 10777260032 1499712944 15.474 100 86 172 0 1535669712 8572336 27384432
20:00:58 17598 8192000000 10464973904 10801057792 1516252400 15.618 100 94 188 1 1555578240 9160128 30165712
20:01:38 15508 8192000000 10475572432 10817871872 1530251056 15.739 100 85 168 1 1567132096 9811904 27069136
20:02:22 11340 8192000000 10508958720 10860277760 1570948128 16.090 100 79 158 3 1605805872 10716064 24141680
20:02:41 14998 8192000000 10548573632 10901069824 1596710416 16.311 100 77 154 0 1631194304 10933408 23550480
20:03:06 12876 8192000000 10562334784 10921205760 1616171840 16.477 100 78 155 1 1650888672 11327712 23389120
20:03:28 10571 8192000000 10585494048 10947899392 1648896768 16.755 100 81 162 3 1685429392 12610304 23922320
20:03:47 8978 8192000000 10604911280 10968088576 1663077024 16.875 100 90 180 0 1702340048 12593664 26669360
20:04:04 8384 8192000000 10608892800 10974126080 1665921968 16.899 100 75 150 1 1700491136 12911568 21657600
20:04:20 6090 8192000000 10633626336 10998927360 1685847952 17.066 100 81 162 0 1723283184 13875472 23559760
20:04:35 8909 8192000000 10638611632 11008442368 1697875264 17.167 100 80 160 0 1734500640 13132384 23492992
20:04:51 7320 8192000000 10655910208 11026849792 1712807648 17.292 100 79 155 0 1748406192 12874736 22723808
20:05:05 6094 8192000000 10668049280 11040833536 1725216016 17.396 100 74 148 0 1759945408 13191888 21537504
20:05:21 4850 8192000000 10686672128 11060170752 1745758048 17.566 100 82 162 3 1782247616 12890944 23598624
20:05:33 4692 8192000000 10694494320 11074560000 1756190080 17.653 100 77 154 3 1790446896 12268720 21988096
20:05:44 4366 8192000000 10706239872 11085979648 1771481632 17.779 100 83 165 2 1807289328 12255680 23552016
20:05:55 4383 8192000000 10707473136 11088781312 1774532592 17.804 100 76 152 3 1808182960 11783584 21866784
20:06:06 3396 8192000000 10736636368 11112640512 1790482576 17.936 100 90 179 0 1828018976 12979696 24556704
20:06:17 3102 8192000000 10734580816 11114938368 1792401488 17.952 100 83 164 2 1828703168 14086224 22215456
20:06:26 4256 8192000000 10737478800 11119763456 1797224576 17.991 100 89 177 0 1837512352 15395232 24892544
20:06:37 4049 8192000000 10746972480 11129847808 1806186352 18.065 100 87 172 3 1844226144 14299920 23739872
20:06:48 3543 8192000000 10751473168 11134205952 1808529296 18.084 100 87 169 2 1845770752 14026048 23215408
20:06:58 7817 8192000000 10748518784 11133374464 1813336672 18.123 100 82 164 0 1849963920 14327840 22299408
20:07:12 6396 8192000000 10756560656 11142127616 1815667040 18.142 100 87 173 2 1854582416 14291968 24623408
20:07:25 2695 8192000000 10774686080 11157504000 1827222256 18.237 100 89 179 1 1865542880 13656896 24663728
20:07:34 2219 8192000000 10777897312 11159007232 1834511952 18.296 100 92 185 2 1873592176 13140368 25939856
20:07:43 2062 8192000000 10783875472 11165057024 1836337824 18.311 100 85 171 0 1873339824 12937600 24064400
20:07:51 2227 8192000000 10781341824 11168747520 1839469696 18.336 100 87 173 0 1876687072 13004768 24212608
20:08:00 1757 8192000000 10791739184 11174096896 1846738352 18.396 100 94 186 1 1886358432 13681248 25938832
20:08:08 1311 8192000000 10791178928 11176300544 1848158448 18.407 100 92 183 2 1889070848 14029792 26882608
20:08:16 1598 8192000000 10802412112 11188670464 1853820192 18.453 100 88 174 1 1892579440 13284704 25474544
20:08:24 2077 8192000000 10799787184 11184689152 1857782496 18.485 100 91 181 1 1895748976 12436288 25530192
20:08:33 2040 8192000000 10808497088 11192983552 1859009952 18.495 100 93 186 2 1898471568 13233072 26228544
20:08:41 1334 8192000000 10799770640 11194175488 1859277568 18.497 100 83 166 0 1894981328 12741920 22961840
20:08:49 3974 8192000000 10797828896 11191472128 1861148832 18.513 100 81 160 1 1895666304 11802912 22714560
20:09:01 13823 8192000000 10802111088 11195015168 1864185680 18.537 100 73 146 0 1897318416 12799136 20333600
20:09:21 1443 8192000000 10810165376 11203309568 1870229824 18.586 100 86 169 2 1907090496 12501536 24359136
20:09:36 14331 8192000000 10784823472 11190382592 1861498928 18.515 100 38 76 4 1879290256 7306720 10484608
20:09:57 6243 8192000000 10779106624 11197063168 1861024640 18.512 100 27 54 2 1875747728 7232448 7490640
20:10:11 4349 8192000000 10778973504 11200339968 1868895152 18.575 100 37 73 1 1886974128 7642752 10436224
20:10:24 5079 8192000000 10788900208 11208409088 1875933456 18.632 100 32 63 2 1890820080 6436016 8450608
20:10:37 3132 8192000000 10803913184 11219841024 1881397328 18.676 100 52 104 2 1906205728 10185920 14622480
20:10:52 2278 8192000000 10793130192 11216797696 1882491808 18.685 100 41 82 1 1901986512 7843856 11650848
20:11:05 5538 8192000000 10801493184 11222618112 1883421024 18.693 100 38 77 0 1901945072 7985744 10538304
20:11:19 5573 8192000000 10792069472 11219447808 1883299312 18.692 100 21 43 0 1895775264 6692192 5783760
20:11:31 11357 8192000000 10793433840 11222855680 1884465504 18.701 100 19 38 0 1895896192 6268720 5161968
20:11:49 4497 8192000000 10797242016 11224784896 1888422176 18.733 100 28 56 2 1902913920 6843840 7647904
20:12:00 10765 8192000000 10793089344 11225493504 1888704544 18.735 100 21 42 1 1900362384 5906368 5751472
20:12:22 7132 8192000000 10795690160 11231170560 1893131824 18.771 100 22 43 1 1905221760 6146720 5943216
20:12:35 12951 8192000000 10794286848 11234422784 1893939728 18.778 100 19 38 0 1906251200 6941376 5370096
20:12:58 11845 8192000000 10804486832 11233615872 1897625344 18.807 100 20 39 2 1909491936 6771680 5094912
20:13:16 10937 8192000000 10810896224 11243102208 1900950560 18.834 100 21 41 2 1911999008 5880272 5168176
20:13:34 80877 8192000000 10808888144 11249938432 1905858880 18.873 100 48 96 2 1925045904 5610160 13576864
20:15:01 5136 8192000000 10832899120 11256532992 1904281536 18.861 100 30 60 1 1918568480 5850160 8436784
20:15:14 4198 8192000000 10823156336 11256348672 1907157856 18.884 100 36 73 2 1924244928 7060320 10026752
20:15:25 2708 8192000000 10837052944 11263213568 1907667744 18.888 100 36 72 2 1928687008 9898832 11120432
20:15:34 4791 8192000000 10837556928 11262500864 1911442544 18.918 100 48 97 5 1931216224 5691104 14082576
20:15:45 3235 8192000000 10833561616 11260452864 1909370096 18.902 100 35 68 0 1926397152 7217264 9809792
20:15:55 4154 8192000000 10830180032 11262312448 1910110864 18.908 100 37 74 1 1927750384 7049552 10589968
20:16:06 3750 8192000000 10833695040 11268206592 1914217120 18.940 100 37 72 0 1936068912 11363088 10488704
20:16:16 6076 8192000000 10817307680 11253985280 1902803968 18.849 100 17 34 0 1913628800 6224976 4599856
20:16:29 5865 8192000000 10803595680 11233660928 1877268928 18.643 99 40 80 1 1895910896 7590864 11051104
20:16:44 14578 8192000000 10792341824 11223732224 1868881984 18.575 99 14 28 0 1878307040 5852176 3572880
20:17:06 7299 8192000000 10805186160 11232550912 1859143936 18.496 98 22 45 0 1871115392 5573008 6398448
20:17:20 10468 8192000000 10779920768 11210899456 1832958064 18.283 97 14 26 1 1841779248 5075680 3745504
20:17:37 8376 8192000000 10779075760 11216646144 1844189136 18.375 98 27 54 4 1858841488 6570336 8082016
20:17:57 9336 8192000000 10759357440 11189227520 1788468080 17.919 95 12 24 0 1796943120 5101472 3373568
20:18:12 75126 8192000000 10749228176 11174805504 1716880176 17.326 92 16 32 2 1726441856 5025328 4536352
20:19:37 7692 8192000000 10784010848 11202945024 1858585232 18.492 100 43 85 1 1878661376 8026512 12049632
20:19:55 7882 8192000000 10735764144 11150069760 1731974528 17.452 94 27 55 4 1749204864 9682400 7547936
20:20:11 5112 8192000000 10726550688 11143118848 1776246352 17.819 98 33 66 2 1797643952 11305152 10092448
20:20:23 7088 8192000000 10706775952 11122733056 1712101760 17.286 94 21 42 0 1723814752 5390416 6322576
20:20:37 5786 8192000000 10701318656 11111604224 1739870928 17.518 97 41 82 0 1761866704 9200000 12795776
20:20:49 8276 8192000000 10727744896 11141349376 1763096720 17.710 98 30 60 0 1776771808 4751744 8923344
20:21:04 5743 8192000000 10724031424 11138740224 1773347328 17.795 98 33 66 0 1788761600 5765664 9648608
20:21:16 7254 8192000000 10739121792 11163779072 1810073920 18.096 99 33 66 0 1825545312 5786400 9684992
20:21:31 12151 8192000000 10716182240 11134754816 1724823216 17.392 95 18 35 1 1735272864 5385984 5063664
20:21:52 10902 8192000000 10713086272 11138236416 1755619648 17.648 97 16 32 0 1764932016 5276768 4035600
20:22:11 4873 8192000000 10726853904 11144306688 1811522144 18.108 100 29 58 2 1825147520 5519376 8106000
20:22:23 11924 8192000000 10722669216 11139833856 1755484960 17.647 97 15 30 0 1764538480 4991264 4062256
20:22:41 8648 8192000000 10730054224 11147403264 1810570528 18.101 100 19 38 0 1820707856 4914128 5223200
20:22:58 71309 8192000000 10753904224 11173969920 1815042832 18.137 99 29 58 0 1829427328 5490720 8893776
20:24:16 8908 8192000000 10746184896 11171094528 1829440256 18.255 100 16 30 3 1839386128 4932608 5013264
20:24:33 11303 8192000000 10748071136 11180654592 1838254128 18.327 100 18 36 1 1849246864 6063184 4929552
20:24:53 6450 8192000000 10776908672 11195342848 1845573440 18.386 100 29 58 1 1861539408 7295376 8670592
20:25:06 8734 8192000000 10767570128 11190554624 1851706000 18.436 100 43 85 1 1871481920 7637136 12138784
20:25:21 9432 8192000000 10767284448 11190476800 1836256768 18.310 99 32 62 4 1853035456 6294560 10484128
20:25:37 4729 8192000000 10782952704 11201363968 1854208528 18.456 100 34 68 3 1870021392 5973616 9839248
20:25:52 8863 8192000000 10774934192 11204304896 1856098448 18.472 100 18 35 1 1870193936 9264640 4830848
20:26:07 10549 8192000000 10773312752 11205140480 1860591856 18.508 100 18 36 4 1870572144 4705296 5274992
20:26:28 7733 8192000000 10776439232 11209695232 1868961712 18.576 100 28 56 3 1882780096 5793264 8025120
20:26:42 10638 8192000000 10780448320 11214946304 1872812384 18.607 100 26 50 3 1885298848 5481408 7005056
20:27:02 8072 8192000000 10801818656 11227066368 1884587712 18.702 100 30 60 2 1898630336 4934512 9108112
20:27:19 8575 8192000000 10809259904 11240390656 1893385584 18.773 100 12 22 1 1900538560 4373632 2779344
20:27:38 9054 8192000000 10825770608 11251494912 1904714176 18.864 100 30 58 3 1919027936 6028560 8285200
20:28:02 22599 8192000000 10835186528 11262447616 1918494096 18.975 100 37 70 0 1935031040 6209056 10327888
20:28:34 92987 8192000000 10844729072 11284643840 1928690960 19.056 100 43 86 4 1949898416 8847504 12359952
20:30:41 15367 8192000000 10863207856 11298684928 1935538384 19.111 100 39 77 1 1956474912 9544128 11392400
20:31:04 4653 8192000000 10868587168 11302465536 1939777152 19.145 100 40 78 1 1963249296 12607200 10864944
20:31:23 12571 8192000000 10873731472 11306676224 1945159152 19.188 100 49 96 1 1968914080 10170512 13584416
20:31:44 22496 8192000000 10879000048 11313451008 1949951152 19.226 100 44 88 0 1972795728 9973440 12871136
20:32:17 17253 8192000000 10891497888 11322933248 1950943232 19.234 100 37 71 1 1972376960 11251520 10182208
20:32:57 9689 8192000000 10894773456 11330125824 1961191296 19.316 100 50 100 2 1990860800 15435344 14234160
20:33:24 9603 8192000000 10905705024 11340693504 1970921472 19.393 100 45 90 2 1998441216 13735872 13783872
20:33:41 7296 8192000000 10899204832 11331162112 1953444736 19.254 99 55 109 0 1981326336 12052736 15828864
20:34:00 7678 8192000000 10914934816 11343843328 1970719248 19.391 100 51 100 2 1999181408 13831216 14630944
20:34:32 11899 8192000000 10915941072 11351674880 1978018656 19.449 100 45 91 0 2006315856 15192784 13104416
20:34:55 10883 8192000000 10918524912 11348045824 1959400192 19.301 99 48 94 1 1986847904 14689648 12758064
20:35:14 11172 8192000000 10921645376 11354398720 1980071200 19.465 100 57 113 2 2012290224 16160864 16058160
20:35:32 5320 8192000000 10929346032 11352432640 1967101936 19.362 99 70 139 0 2006993696 20312688 19579072
20:35:45 12940 8192000000 10943041120 11366367232 1987757872 19.526 100 74 148 2 2030555296 21811312 20986112
20:36:08 7584 8192000000 10941876608 11367522304 1990494128 19.548 100 64 128 1 2029908688 21177424 18237136
20:36:27 26281 8192000000 10935855616 11373191168 1972136368 19.402 99 45 90 0 2005654352 20094928 13423056
20:37:06 16594 8192000000 10910699600 11364134912 1969544128 19.382 99 28 56 2 1999182784 20690976 8947680
20:37:30 6918 8192000000 10928282832 11369119744 1988203264 19.530 100 44 84 0 2020835824 19511168 13121392
20:37:46 11707 8192000000 10931973680 11368022016 1983759040 19.494 100 41 82 1 2017923440 21610224 12554176
20:38:05 13451 8192000000 10946135504 11380527104 1993210480 19.569 100 46 92 2 2033135808 25608096 14317232
20:38:28 8962 8192000000 10938462272 11367141376 1959253808 19.300 98 54 106 2 2001954624 27186416 15514400
20:38:45 9764 8192000000 10951814688 11382304768 1987830032 19.527 100 53 106 1 2035710656 31975008 15905616
20:39:13 2104 8192000000 10948154960 11384774656 1995091648 19.584 100 49 98 1 2037356800 27271232 14993920
20:39:23 2732 8192000000 10969024736 11398406144 2004736080 19.660 100 57 114 0 2053186768 31507168 16943520
20:39:35 4242 8192000000 10965356656 11395276800 2005714704 19.668 100 65 129 0 2053110000 27820208 19575088
20:39:53 3835 8192000000 10969448640 11396751360 2009385664 19.697 100 62 123 1 2057045664 28655904 19004096
20:40:06 7271 8192000000 10969617472 11402969088 2011815408 19.716 100 62 124 1 2059983712 29158864 19009440
20:40:32 6461 8192000000 10972204176 11402571776 1999565360 19.619 99 59 116 2 2048557648 30668384 18323904
20:40:56 10273 8192000000 10957952016 11387154432 1979247312 19.459 99 59 118 0 2028593776 30396512 18949952
20:41:15 7621 8192000000 10969388352 11399704576 2004004112 19.654 100 58 115 0 2056642560 33990928 18647520
20:41:31 7381 8192000000 10977099600 11406315520 2011328096 19.712 100 70 136 1 2063359504 30896720 21134688
20:41:47 5596 8192000000 10970625184 11389255680 1998120848 19.608 99 69 137 3 2051840960 32507280 21212832
20:42:01 3048 8192000000 10987505104 11409391616 2014043696 19.733 100 79 156 0 2072224720 34520848 23660176
20:42:13 4026 8192000000 10977737680 11392253952 1996333488 19.594 99 74 148 0 2052444096 34218144 21892464
20:42:24 3461 8192000000 10988565808 11405156352 1994499936 19.579 99 78 156 1 2054082768 35034416 24548416
20:42:35 3368 8192000000 10965712272 11379646464 1967836224 19.368 98 77 150 1 2025853984 34535168 23482592
20:42:46 3275 8192000000 10965821616 11384946688 1980309632 19.467 99 79 155 3 2039785904 34474976 25001296
20:42:57 3383 8192000000 10956831088 11372830720 1977156976 19.442 99 83 166 0 2040021216 36887456 25976784
20:43:08 3555 8192000000 10960680352 11390885888 1991613744 19.557 100 77 149 0 2053162032 37633120 23915168
20:43:19 4357 8192000000 10973326288 11394285568 1991963824 19.559 100 78 154 1 2055096208 37588096 25544288
20:43:31 11610 8192000000 10947866400 11376308224 1977598496 19.446 100 75 150 0 2042032736 39848272 24585968
20:43:50 1672 8192000000 10960017184 11372773376 1970441472 19.389 100 78 151 1 2033300624 38253264 24605888
20:44:00 6358 8192000000 10927747200 11356319744 1929902448 19.066 98 57 114 2 1984495392 36492032 18100912
20:44:16 3275 8192000000 10921234336 11350798336 1941187696 19.156 99 60 120 0 1998666928 37584288 19894944
20:44:26 4029 8192000000 10911814352 11329757184 1910898240 18.914 98 77 150 1 1971547120 38320384 22328496
20:44:37 4772 8192000000 10910386736 11334451200 1930176880 19.068 99 66 132 1 1993333040 42855728 20300432
20:44:51 4358 8192000000 10892903712 11310342144 1897253440 18.804 98 72 144 2 1959701200 39291392 23156368
20:45:04 2534 8192000000 10901669408 11313827840 1920131456 18.988 100 68 134 1 1981936064 39405968 22398640
20:45:15 3888 8192000000 10909892816 11327660032 1931404752 19.078 100 64 127 2 1996833168 45259168 20169248
20:45:25 3950 8192000000 10905978608 11327873024 1918078000 18.971 99 68 133 1 1980438432 40831216 21529216
20:45:40 2085 8192000000 10937053968 11351875584 1954102160 19.259 100 75 151 1 2016452016 38900144 23449712
20:45:48 4234 8192000000 10939560064 11353640960 1938004128 19.131 99 77 154 2 2003164992 41045888 24114976
20:46:01 1180 8192000000 10963674496 11373056000 1977989120 19.449 100 88 176 3 2045842816 41008208 26845488
20:46:10 1892 8192000000 10957170352 11366735872 1962521264 19.326 100 89 178 0 2032793376 43636352 26635760
20:46:19 2128 8192000000 10947801840 11356758016 1947806208 19.209 99 86 173 2 2019329296 44689696 26833392
20:46:28 3245 8192000000 10938554864 11357880320 1935902992 19.114 99 72 142 0 2002170016 44021264 22245760
20:46:38 3860 8192000000 10927534544 11339096064 1938743712 19.137 99 73 144 2 2005588560 44270656 22574192
20:46:50 2002 8192000000 10950408528 11363352576 1959638016 19.303 100 70 138 0 2026905392 45426448 21840928
20:47:00 3397 8192000000 10962553600 11370647552 1969009520 19.378 100 73 146 1 2038132144 46060752 23061872
20:47:13 1675 8192000000 10960749152 11369308160 1964523712 19.342 100 90 176 1 2041404944 48274192 28607040
20:47:23 784 8192000000 10974346592 11378769920 1971360384 19.396 100 92 182 0 2050595280 49904208 29330688
20:47:30 1481 8192000000 10972655584 11383554048 1972692160 19.407 100 91 182 2 2052654288 51265312 28696816
20:47:39 1170 8192000000 10961384016 11371950080 1949325344 19.221 99 86 168 0 2029375408 52553488 27496576
20:47:53 3443 8192000000 10960456752 11373858816 1961939936 19.321 100 73 146 1 2038187888 53056000 23191952
20:48:05 1563 8192000000 10969816944 11375435776 1960007568 19.306 100 90 178 0 2044216400 55036464 29172368
20:48:14 1001 8192000000 10970319168 11378696192 1964838912 19.344 100 86 169 0 2046023856 54119536 27065408
20:48:23 3091 8192000000 10941598496 11350695936 1938168912 19.132 99 76 152 2 2018153744 55769072 24215760
20:48:34 2568 8192000000 10969322272 11377836032 1962141456 19.323 100 85 168 0 2044648544 55535104 26971984
20:48:46 4470 8192000000 10942324080 11366072320 1939022864 19.139 99 59 118 3 2012267600 53532240 19712496
20:49:02 9710 8192000000 10928953648 11372777472 1953372176 19.253 100 44 88 0 2020466272 52065600 15028496
20:49:21 10453 8192000000 10939718272 11369668608 1940557184 19.151 99 50 98 2 2004588048 48047872 15982992
20:49:42 4139 8192000000 10942649104 11367723008 1957094960 19.283 100 53 106 2 2024200496 49639328 17466208
20:49:53 10073 8192000000 10935738048 11366674432 1955521104 19.270 100 58 116 0 2026611488 52109040 18981344
20:50:15 9681 8192000000 10940237568 11378188288 1959187184 19.300 100 32 64 0 2019319728 49055776 11076768
20:50:34 16310 8192000000 10934483824 11375456256 1945207808 19.188 99 37 74 2 2010384672 52512320 12664544
20:51:05 10731 8192000000 10942787424 11375071232 1951677456 19.240 100 43 85 2 2025237024 58203376 15356192
20:51:25 8999 8192000000 10938062672 11390185472 1955837968 19.273 100 36 73 1 2021165520 51923952 13403600
20:51:42 10782 8192000000 10923752784 11359903744 1921663264 19.000 98 43 85 0 1992742992 55471520 15608208
20:51:59 7488 8192000000 10934593776 11377463296 1951586816 19.239 100 37 72 1 2015447824 51083008 12778000
20:52:13 5762 8192000000 10920267440 11366780928 1929656016 19.064 99 34 68 0 1994397776 52620064 12121696
20:52:59 16763 8192000000 10929223616 11375075328 1932944256 19.090 99 30 59 2 1998927440 55749024 10234160
20:53:23 27223 8192000000 10919723728 11371175936 1943515504 19.175 100 27 54 1 1998549104 45450048 9583552
20:54:26 10619 8192000000 10918477568 11352944640 1920547232 18.991 98 62 128 2 1977732240 36018448 21166560
20:54:44 50429 8192000000 10888786000 11350675456 1910544384 18.911 99 27 54 2 1960078672 40494192 9040096
20:55:48 23904 8192000000 10873537792 11348594688 1915802304 18.953 100 14 28 0 1970516784 48640352 6074128
20:56:43 88603 8192000000 10848937888 11312369664 1853614400 18.451 97 8 15 0 1879471696 24408672 1448624
20:58:18 71860 8192000000 10863979392 11324895232 1887080480 18.722 98 8 16 0 1902310416 13214080 2015856
20:59:37 69540 8192000000 10873838288 11324784640 1910965312 18.914 99 24 48 2 1934023248 16753104 6304832
21:00:54 20160 8192000000 10895270832 11339825152 1947527136 19.207 100 26 52 1 1968937200 13710800 7699264
21:01:25 52209 8192000000 10898778176 11361538048 1954961104 19.266 100 13 26 0 1978214560 19269552 3983904
21:02:25 71568 8192000000 10901753792 11375452160 1958153968 19.291 100 8 16 0 1985429344 24931472 2343904
21:03:48 114694 8192000000 10901481712 11363426304 1923365552 19.014 98 6 12 0 1940793856 15906000 1522304
21:05:57 58148 8192000000 10916858624 11352748032 1932006240 19.083 98 42 84 2 1954591424 10857760 11727424
21:07:02 38266 8192000000 10897675024 11360247808 1972457568 19.405 100 41 82 0 1996588688 12317760 11813360
21:08:29 49101 8192000000 10924182336 11375276032 1977634624 19.446 100 43 84 2 2002061920 12148544 12278752
21:09:30 50584 8192000000 10910022672 11376893952 1982464816 19.484 100 44 89 2 2011975072 17494416 12015840
21:10:30 27795 8192000000 10942563168 11384680448 1986988160 19.520 100 47 94 0 2014710720 13973264 13749296
21:11:10 18014 8192000000 10922784688 11380695040 1978603872 19.454 100 35 70 2 1999329760 10908288 9817600
21:11:38 33848 8192000000 10897894544 11356397568 1941472224 19.159 98 28 56 0 1957577120 7930288 8174608
21:12:19 20585 8192000000 10899888704 11364352000 1974645248 19.422 100 18 36 1 1988530960 8500928 5384784
21:12:53 50346 8192000000 10913386176 11371843584 1967416128 19.365 99 16 32 0 1980859728 8911648 4531952
21:13:57 25198 8192000000 10939923488 11381616640 1970373648 19.388 99 42 83 0 1993050656 9836416 12840592
21:14:31 55417 8192000000 10897789264 11364720640 1946506512 19.199 98 24 48 0 1965411200 11539920 7364768
21:15:35 39642 8192000000 10904139200 11384836096 1981050272 19.473 100 9 18 1 1996425984 12918128 2457584
21:16:40 25432 8192000000 10907849008 11386343424 1991175552 19.553 100 18 36 1 2006183360 10054656 4953152
21:17:20 25090 8192000000 10902984000 11380621312 1971891056 19.400 99 13 26 1 1985879024 10414000 3573968
21:17:51 19317 8192000000 10912016736 11377647616 1962133152 19.323 99 13 26 1 1978851840 12671872 4046816
21:18:18 41203 8192000000 10912036128 11388035072 1958856160 19.297 99 10 20 0 1972347520 10834688 2656672
21:19:05 110802 8192000000 10924146752 11405815808 1985045536 19.505 100 24 49 2 2007015280 15503472 6466272
21:21:03 84604 8192000000 10917316288 11400470528 1978291008 19.451 99 23 44 1 2001816144 16179936 7345200
21:23:50 19983 8192000000 10914691408 11382538240 1951097360 19.235 98 31 63 0 1974370688 14336624 8936704
21:24:20 32087 8192000000 10902197552 11385159680 1984913152 19.504 100 17 32 1 1998295680 8891280 4491248
21:25:01 41744 8192000000 10902913648 11375206400 1980102400 19.466 100 22 44 2 1992938048 6605296 6230352
21:25:54 59113 8192000000 10876727600 11363684352 1960787584 19.312 99 19 38 3 1975265488 8977168 5500736
21:27:01 59634 8192000000 10884727216 11380203520 1951108224 19.235 99 8 16 0 1961232128 8198256 1925648
21:28:12 41901 8192000000 10892028912 11369345024 1954264384 19.260 99 18 36 2 1968101680 9051264 4786032
21:29:54 37255 8192000000 10874181104 11343335424 1895149888 18.787 97 14 28 0 1915034432 15434320 4450224
21:30:42 36886 8192000000 10885771712 11353911296 1942037120 19.163 99 17 34 1 1957411424 10797552 4576752
21:31:25 84249 8192000000 10909110256 11375046656 1923996848 19.019 98 22 44 1 1952784064 21752576 7034640
21:33:02 89405 8192000000 10865345152 11350159360 1857395504 18.482 95 9 18 1 1875859024 15792736 2670784
21:34:40 74149 8192000000 10885821840 11339087872 1871797120 18.599 96 14 28 3 1886955376 11575504 3582752
21:36:03 60990 8192000000 10872279264 11336196096 1890020736 18.746 97 29 56 1 1908817440 10716704 8080000
21:37:20 25090 8192000000 10892995344 11348385792 1929240368 19.061 99 48 94 1 1959552144 16802112 13509664
21:37:53 65735 8192000000 10874261808 11351592960 1907026560 18.883 98 13 26 0 1926065872 14935856 4103456
21:39:12 66106 8192000000 10871990288 11324592128 1858427344 18.491 95 17 34 0 1876441184 13459024 4554816
21:40:26 45920 8192000000 10859973648 11322359808 1839072464 18.333 95 40 80 2 1866702576 16120496 11509616
21:41:27 37819 8192000000 10876022752 11347603456 1936554016 19.119 100 21 42 1 1956548800 14615344 5379440
21:42:11 109307 8192000000 10852540176 11319304192 1864932912 18.543 96 24 48 2 1883415888 10627328 7855648
21:44:10 80276 8192000000 10857376560 11333951488 1900309760 18.829 98 21 41 3 1915052048 9273376 5468912
21:45:36 21910 8192000000 10878045552 11348090880 1927980864 19.051 99 27 53 0 1946612256 11174464 7456928
21:46:08 16266 8192000000 10877922816 11349123072 1946756704 19.201 100 17 33 0 1965461632 13862608 4842320
21:46:33 70484 8192000000 10843179504 11318943744 1856446944 18.474 95 26 51 1 1875132800 11082112 7603744
21:47:50 73754 8192000000 10791531504 11255283712 1792538032 17.953 93 22 43 2 1809342336 10955344 5848960
21:49:10 63527 8192000000 10849823168 11305684992 1865306400 18.546 98 21 42 3 1885864752 14153536 6404816
21:50:20 67230 8192000000 10831526192 11314515968 1891565600 18.758 99 26 52 0 1919694352 19275232 8853520
21:51:34 70546 8192000000 10838475840 11334602752 1891717264 18.760 99 9 18 1 1908958400 14519184 2721952
21:52:52 89762 8192000000 10873723296 11321491456 1898338144 18.813 98 25 50 1 1915502832 9881344 7283344
21:54:28 46038 8192000000 10886035152 11339366400 1918953264 18.978 99 25 49 3 1935127984 9067168 7107552
21:55:24 31739 8192000000 10875664336 11346042880 1945514512 19.191 100 54 108 3 1974415824 12696176 16205136
21:56:03 76399 8192000000 10878282208 11361730560 1931118768 19.076 99 13 25 0 1947112528 12314000 3679760
21:58:06 120583 8192000000 10915367984 11385446400 1980329632 19.467 100 17 34 3 2002120352 17366752 4423968
22:01:27 37523 8192000000 10917573744 11402108928 1982375904 19.484 100 23 46 2 2003760112 14966736 6417472
22:02:20 32245 8192000000 10907952144 11390451712 1959386960 19.301 99 9 18 0 1976116240 14562480 2166800
22:02:58 94528 8192000000 10915890112 11385171968 1943621616 19.176 98 12 24 1 1958376096 12140592 2613888
22:04:41 68076 8192000000 10894224752 11376144384 1930221488 19.069 97 23 45 3 1946391920 9834480 6335952
22:05:57 114097 8192000000 10888932096 11378077696 1921790352 19.001 97 19 38 0 1938759552 11280048 5689152
22:08:08 31718 8192000000 10897578528 11394875392 1976303552 19.435 100 19 38 0 1998212304 16785200 5123552
22:08:46 21873 8192000000 10886119872 11383037952 1967765456 19.368 100 10 20 0 1987025664 16629168 2631040
22:09:20 49725 8192000000 10877361008 11362123776 1917710320 18.968 97 7 14 0 1927816560 8186000 1920240
22:10:23 99163 8192000000 10894654656 11385778176 1953041248 19.251 99 11 21 1 1970132752 14000816 3090688
22:12:40 81761 8192000000 10894712224 11381043200 1955018256 19.266 99 5 10 0 1968756768 12246752 1491760
22:14:26 7357 8192000000 10881778480 11373395968 1966197264 19.355 100 27 55 0 1986026496 12092512 7736720
22:14:52 41382 8192000000 10885732464 11368587264 1949681568 19.224 99 7 14 0 1958818704 7399904 1737232
22:16:10 47338 8192000000 10866044512 11349995520 1906147664 18.876 97 19 36 1 1918299216 7360608 4790944
22:17:08 43087 8192000000 10888418384 11356893184 1906179296 18.876 97 13 26 0 1920783600 10930400 3673904
22:18:03 51108 8192000000 10856214416 11346223104 1886902464 18.721 97 13 26 3 1909574368 18069600 4602304
22:19:00 66089 8192000000 10868410016 11333537792 1905071008 18.867 98 20 40 0 1922289248 11450560 5767680
22:20:24 51262 8192000000 10862751616 11329937408 1901825216 18.841 98 14 28 1 1918637008 12364544 4447248
22:21:50 62994 8192000000 10864174672 11329757184 1897365200 18.805 98 17 34 0 1913073680 10786352 4922128
22:23:01 74848 8192000000 10865487360 11336032256 1911497168 18.919 99 20 40 2 1939739888 22391184 5851536
22:24:23 68780 8192000000 10891124864 11342372864 1910739472 18.913 98 32 64 2 1930225392 10632048 8853872
22:25:46 14700 8192000000 10898523680 11352301568 1950218768 19.228 100 53 106 1 1976777440 11821376 14737296
22:26:21 71327 8192000000 10859689088 11331481600 1875146464 18.626 96 30 60 2 1895117568 11968736 8002368

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 10-06-2021 22:28:22 to 10-06-2021 22:28:54.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 119 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-06-2021 22:28:55 to 10-06-2021 22:28:57.

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          242387
MON$OLDEST_ACTIVE               243511
MON$OLDEST_SNAPSHOT             243511
MON$NEXT_TRANSACTION            243511
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                       2055072
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.33472 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33472 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33472 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33472 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 ---
:100: 
:101: mscs-test-161.budzdorov.ru    Thu Jun 10 22:27:43 2021
:102:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:103: 
--- end of diff output ---

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

10.06.21 22:28:58. 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-06-10 22:29:01 No severe PSQL-related problems occured
10.06.21 22:29:02. End of report.