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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-13 01:27:21
DTS_END                         2021-03-13 01:27:21.3780
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_MAKE_MONEY_SALDO(33:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/48930
TRN_ID                          249065
ATT_ID                          741
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: 9441.07 21530 1132928
customer order: creation 185.57 340 22268
customer order: refuse 15.54 338 1865
order to supplier: creation 48.84 1204 5861
order to supplier: removal 3.49 100226 419
invoice (draft): creation 48.83 3131 5860
invoice (draft): removal 53.78 728 6453
invoice accept: apply 43.33 16842 5199
invoice accept: cancel 48.13 792 5776
customer reserve: creation 4025.18 164 483021
customer reserve: removal 4663.54 59 559625
realization accept: apply 90.05 177 10806
realization accept: cancel 75.78 112 9094
payment from customer: creation 63.03 105 7564
payment from customer: removal 6.08 100 729
payment to supplier: creation 53.38 118 6405
payment to supplier: removal 3.40 78 408
service: total inventory turnovers 5.08 1030 610
service: total monetary turnovers 7.04 27 845
service: aggregate perf. data 0.97 13296 116
service: refresh index statistics 0.03 291742 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-03-2021 01:28:40 to 13-03-2021 01:28:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4390
TEST_TIME 2 4303
TEST_TIME 3 4568
TEST_TIME 4 4254
TEST_TIME 5 4726
TEST_TIME 6 5106
TEST_TIME 7 5270
TEST_TIME 8 5445
TEST_TIME 9 6042
TEST_TIME 10 6178
TEST_TIME 11 6300
TEST_TIME 12 6462
TEST_TIME 13 6875
TEST_TIME 14 7009
TEST_TIME 15 7214
TEST_TIME 16 7215
TEST_TIME 17 7551
TEST_TIME 18 7921
TEST_TIME 19 8387
TEST_TIME 20 8879
TEST_TIME 21 8888
TEST_TIME 22 8715
TEST_TIME 23 8879
TEST_TIME 24 9049
TEST_TIME 25 9171
TEST_TIME 26 10034
TEST_TIME 27 9918
TEST_TIME 28 10430
TEST_TIME 29 11036
TEST_TIME 30 10936
TEST_TIME 31 10739
TEST_TIME 32 10657
TEST_TIME 33 10532
TEST_TIME 34 10610
TEST_TIME 35 10685
TEST_TIME 36 10657
TEST_TIME 37 10637
TEST_TIME 38 10721
TEST_TIME 39 10560
TEST_TIME 40 10481
TEST_TIME 41 10445
TEST_TIME 42 10220
TEST_TIME 43 10097
TEST_TIME 44 10182
TEST_TIME 45 10038
TEST_TIME 46 9977
TEST_TIME 47 9981
TEST_TIME 48 9951
TEST_TIME 49 10041
TEST_TIME 50 9948
TEST_TIME 51 9847
TEST_TIME 52 9820
TEST_TIME 53 9714
TEST_TIME 54 9714
TEST_TIME 55 9663
TEST_TIME 56 9706
TEST_TIME 57 9737
TEST_TIME 58 9659
TEST_TIME 59 9853
TEST_TIME 60 9851
TEST_TIME 61 9833
TEST_TIME 62 9868
TEST_TIME 63 9980
TEST_TIME 64 9940
TEST_TIME 65 9984
TEST_TIME 66 10059
TEST_TIME 67 10044
TEST_TIME 68 10032
TEST_TIME 69 9990
TEST_TIME 70 9917
TEST_TIME 71 9934
TEST_TIME 72 9833
TEST_TIME 73 9821
TEST_TIME 74 9809
TEST_TIME 75 9737
TEST_TIME 76 9667
TEST_TIME 77 9658
TEST_TIME 78 9598
TEST_TIME 79 9594
TEST_TIME 80 9595
TEST_TIME 81 9613
TEST_TIME 82 9638
TEST_TIME 83 9601
TEST_TIME 84 9654
TEST_TIME 85 9631
TEST_TIME 86 9632
TEST_TIME 87 9696
TEST_TIME 88 9676
TEST_TIME 89 9812
TEST_TIME 90 9842
TEST_TIME 91 9808
TEST_TIME 92 9819
TEST_TIME 93 9740
TEST_TIME 94 9698
TEST_TIME 95 9656
TEST_TIME 96 9651
TEST_TIME 97 9679
TEST_TIME 98 9633
TEST_TIME 99 9627
TEST_TIME 100 9658
TEST_TIME 101 9627
TEST_TIME 102 9599
TEST_TIME 103 9626
TEST_TIME 104 9720
TEST_TIME 105 9695
TEST_TIME 106 9729
TEST_TIME 107 9736
TEST_TIME 108 9703
TEST_TIME 109 9707
TEST_TIME 110 9658
TEST_TIME 111 9613
TEST_TIME 112 9598
TEST_TIME 113 9574
TEST_TIME 114 9546
TEST_TIME 115 9503
TEST_TIME 116 9480
TEST_TIME 117 9515
TEST_TIME 118 9490
TEST_TIME 119 9480
TEST_TIME 120 9443

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-03-2021 01:28:44 to 13-03-2021 01:28:47.

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 1580050 1580050 0 0.00 0 22870 6 0 0
doc_list_biud 1580048 1580048 0 0.00 0 23119 26 0 0
sp_add_invoice_to_stock 5329 5199 130 2.43 37 175290 16842 0 130
sp_cancel_adding_invoice 5776 5776 0 0.00 5 58356 793 0 0
sp_cancel_client_order 1865 1865 0 0.00 4 9932 338 0 0
sp_cancel_customer_reserve 559625 559625 0 0.00 1 23122 59 0 0
sp_cancel_pay_from_customer 729 729 0 0.00 3 9866 100 0 0
sp_cancel_pay_to_supplier 408 408 0 0.00 3 6587 79 0 0
sp_cancel_supplier_invoice 6459 6453 6 0.09 2 19055 729 0 6
sp_cancel_supplier_order 419 419 0 0.00 12 968428 100226 0 0
sp_cancel_write_off 9094 9094 0 0.00 1 9091 113 0 0
sp_client_order 22268 22268 0 0.00 3 12925 340 0 0
sp_customer_reserve 483021 483021 0 0.00 0 134588 164 0 0
sp_fill_shopping_cart 33977 33977 0 0.00 1 14317 34 0 0
sp_fill_shopping_cart_clo_res 483013 483013 0 0.00 0 20805 12 0 0
sp_get_clo_for_invoice 5190 5190 0 0.00 0 31306 320 0 0
sp_kill_cost_storno 16007 16007 0 0.00 0 8295 59 0 0
sp_kill_qstorno_ret_qs2qd 1135216 1135216 0 0.00 0 23117 32 0 0
sp_kill_qty_storno 599227 599227 0 0.00 0 23118 69 0 0
sp_lock_selected_doc 22079 22079 0 0.00 0 9847 6 0 0
sp_make_cost_storno 29964 29964 0 0.00 0 11771 49 0 0
sp_multiply_rows_for_pdistr 29964 29964 0 0.00 0 7898 26 0 0
sp_multiply_rows_for_qdistr 22268 22268 0 0.00 0 12916 148 0 0
sp_pay_from_customer 7564 7564 0 0.00 4 11675 105 0 0
sp_pay_to_supplier 6405 6405 0 0.00 4 29347 118 0 0
sp_payment_common 13969 13969 0 0.00 1 29317 33 0 0
sp_qd_handle_on_cancel_clo 1865 1865 0 0.00 0 9457 303 0 0
sp_qd_handle_on_invoice_upd_sts 10965 10965 0 0.00 0 16930 325 0 0
sp_qd_handle_on_reserve_upd_sts 10806 10806 0 0.00 0 14702 58 0 0
sp_reserve_write_off 10806 10806 0 0.00 6 14733 178 0 0
sp_supplier_invoice 5860 5860 0 0.00 6 83591 3132 0 0
sp_supplier_order 5861 5861 0 0.00 5 27920 1205 0 0
srv_aggregate_perf_data 116 116 0 0.00 2121 110023 13296 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1063 123961 31946 0 0
srv_find_qd_qs_mism 1082094 1082094 0 0.00 0 22868 5 0 0
srv_make_invnt_saldo 610 610 0 0.00 38 38807 1030 0 0
srv_make_money_saldo 845 845 0 0.00 0 2527 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 209190 381222 291743 0 0
t$perf-abend:sp_add_invoice_to_stock 130 130 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5199 5199 0 0.00 0 16295 151 0 0
t$perf-norm:sp_cancel_adding_invoice 431 431 0 0.00 1 5319 94 0 0
t$perf-norm:sp_cancel_client_order 1865 1865 0 0.00 0 6666 13 0 0
t$perf-norm:sp_cancel_customer_reserve 721 721 0 0.00 0 4643 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 729 729 0 0.00 0 9553 41 0 0
t$perf-norm:sp_cancel_pay_to_supplier 408 408 0 0.00 0 1120 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 445 445 0 0.00 0 1189 17 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 18835 1629 0 0
t$perf-norm:sp_cancel_write_off 1066 1066 0 0.00 0 5336 14 0 0
t$perf-norm:sp_client_order 22268 22268 0 0.00 0 8923 20 0 0
t$perf-norm:sp_customer_reserve 1116 1116 0 0.00 0 2435 10 0 0
t$perf-norm:sp_pay_from_customer 7564 7564 0 0.00 0 10348 11 0 0
t$perf-norm:sp_pay_to_supplier 6405 6405 0 0.00 0 12057 15 0 0
t$perf-norm:sp_reserve_write_off 10806 10806 0 0.00 0 7325 12 0 0
t$perf-norm:sp_supplier_invoice 5860 5860 0 0.00 0 8740 17 0 0
t$perf-norm:sp_supplier_order 5861 5861 0 0.00 0 9403 21 0 0
t$perf-norm:srv_aggregate_perf_data 116 116 0 0.00 0 201 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 161 2 0 0
t$perf-norm:srv_make_invnt_saldo 610 610 0 0.00 0 1509 22 0 0
t$perf-norm:srv_make_money_saldo 845 845 0 0.00 0 3658 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10638 10378 260 2.44 0 9507 18 0 260
v_all_customers 40506 40506 0 0.00 0 20 1 0 0
v_all_suppliers 33166 33166 0 0.00 0 83 1 0 0
v_all_wares 44536 44536 0 0.00 0 164 1 0 0
v_cancel_adding_invoice 862 862 0 0.00 0 4704 13 0 0
v_cancel_client_order 3730 3730 0 0.00 0 955 3 0 0
v_cancel_customer_prepayment 1458 1458 0 0.00 0 3874 10 0 0
v_cancel_customer_reserve 1442 1442 0 0.00 0 6310 10 0 0
v_cancel_payment_to_supplier 816 816 0 0.00 0 733 4 0 0
v_cancel_supplier_invoice 902 890 12 1.33 0 3482 21 0 12
v_cancel_supplier_order 838 838 0 0.00 0 2231 5 0 0
v_cancel_write_off 2132 2132 0 0.00 0 7775 15 0 0
v_max_id_clo_ord 5861 5861 0 0.00 0 552 1 0 0
v_max_id_clo_res 1116 1116 0 0.00 0 7134 21 0 0
v_max_id_ord_sup 5847 5847 0 0.00 0 4348 4 0 0
v_max_non_paid_invoice 1530 1530 0 0.00 0 227 2 0 0
v_max_non_paid_realizn 3937 3937 0 0.00 0 1998 4 0 0
v_min_id_clo_ord 5861 5861 0 0.00 0 3189 6 0 0
v_min_id_clo_res 1116 1116 0 0.00 0 2615 6 0 0
v_min_id_ord_sup 5847 5847 0 0.00 0 8460 5 0 0
v_min_non_paid_invoice 6405 6405 0 0.00 0 29313 26 0 0
v_min_non_paid_realizn 7564 7564 0 0.00 0 8707 18 0 0
v_our_firm 11284 11284 0 0.00 0 15 1 0 0
v_reserve_write_off 21612 21612 0 0.00 0 9398 7 0 0
x_lock_depdocs_on_canc_invoice 11784 11784 0 0.00 0 27128 123 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 12194 312 0 0
x_make_qstorno_1000_1200 5861 5861 0 0.00 1 27886 1128 0 0
x_make_qstorno_1200_2000 5860 5860 0 0.00 2 83512 3007 0 0
x_make_qstorno_2100_3300 483021 483021 0 0.00 0 134575 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-03-2021 01:28:48 to 13-03-2021 01:28:52.

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:25 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:31 20882 8192000000 10255362832 10563915776 904679008 9.945 72 47 98 0 922988480 2525696 15783776
22:58:03 25909 8192000000 10332524768 10646536192 1383424288 14.447 100 84 169 0 1415160640 4632080 27104272
22:58:42 22335 8192000000 10372702512 10695778304 1427943376 14.843 100 86 172 0 1461802784 6037808 27821600
22:59:15 29489 8192000000 10406814944 10730668032 1459099536 15.118 100 89 178 0 1495028288 7004352 28924400
22:59:55 12882 8192000000 10418205312 10745663488 1477404672 15.279 100 94 188 0 1516301328 7759904 31136752
23:00:20 15047 8192000000 10430566160 10762870784 1480565536 15.306 100 87 174 0 1516775840 7886736 28323568
23:00:46 20936 8192000000 10449695920 10781335552 1499854640 15.475 100 87 174 0 1536500208 8389824 28255744
23:01:16 11385 8192000000 10460102800 10795429888 1517308640 15.627 100 89 178 0 1555207728 9263488 28635600
23:01:35 18126 8192000000 10475039984 10816917504 1528662688 15.725 100 88 176 0 1566733936 9423040 28648208
23:02:06 12114 8192000000 10484371552 10836398080 1556023552 15.962 100 68 136 1 1586295472 9358368 20913552
23:02:28 16752 8192000000 10529843072 10881638400 1589168720 16.247 100 80 158 2 1622772160 9368224 24235216
23:02:51 11659 8192000000 10545691312 10908098560 1609383616 16.419 100 72 145 0 1640576896 9831472 21361808
23:03:12 8035 8192000000 10588464720 10947158016 1642638416 16.702 100 80 160 2 1677154896 10734800 23781680
23:03:27 11952 8192000000 10596590688 10960822272 1663419392 16.878 100 81 162 1 1698712224 11561744 23731088
23:03:49 13346 8192000000 10620799328 10989912064 1678198448 17.002 100 73 146 1 1711113712 12017440 20897824
23:04:11 7981 8192000000 10633947872 11004551168 1697954624 17.168 100 79 158 2 1732108848 11771728 22382496
23:04:28 8026 8192000000 10647190608 11021848576 1710980384 17.277 100 68 136 0 1741680704 10506960 20193360
23:04:49 8844 8192000000 10661724160 11036839936 1724039936 17.386 100 73 146 0 1755819904 11277568 20502400
23:05:05 6375 8192000000 10668445024 11046375424 1734006768 17.469 100 81 162 0 1769331296 12525456 22799072
23:05:19 5240 8192000000 10684620144 11059716096 1747333360 17.579 100 82 165 2 1785026720 14132784 23560576
23:05:30 4644 8192000000 10697384144 11072720896 1756864320 17.658 100 85 168 2 1794601360 13898992 23838048
23:05:43 5533 8192000000 10687984352 11073499136 1764459600 17.721 100 83 166 1 1801807152 13311744 24035808
23:05:55 6290 8192000000 10696427904 11085275136 1768327696 17.753 100 69 137 1 1799880240 11696272 19856272
23:06:10 4511 8192000000 10718664608 11099070464 1780747216 17.856 100 82 163 2 1815398912 12540144 22111552
23:06:21 4035 8192000000 10732328480 11114475520 1785189248 17.892 100 86 170 1 1821631520 12961344 23480928
23:06:33 4916 8192000000 10725545904 11113476096 1788558608 17.920 100 72 145 3 1822021536 13354592 20108336
23:06:45 4451 8192000000 10748580560 11133779968 1804002608 18.047 100 80 160 1 1840409504 13642800 22764096
23:06:56 3253 8192000000 10759630464 11146330112 1815030752 18.137 100 82 161 0 1850991568 13394976 22565840
23:07:07 2757 8192000000 10776892704 11159138304 1825175968 18.220 100 85 170 1 1862843904 12504560 25163376
23:07:17 3144 8192000000 10777360768 11160850432 1831604608 18.272 100 90 182 2 1870399664 13318064 25476992
23:07:27 2147 8192000000 10778375696 11165863936 1837236496 18.318 100 89 179 0 1875753136 14479056 24037584
23:07:36 3070 8192000000 10782676352 11168411648 1843427792 18.369 100 92 184 1 1883926816 14204800 26294224
23:07:45 2518 8192000000 10793751616 11181617152 1851406240 18.434 100 94 188 1 1892812944 15040352 26366352
23:07:55 1634 8192000000 10800215200 11189772288 1852171472 18.440 100 84 167 1 1889714816 14459792 23083552
23:08:03 2868 8192000000 10790550496 11182718976 1852215648 18.440 100 89 179 2 1890415952 13441920 24758384
23:08:13 1647 8192000000 10795320560 11188150272 1855125280 18.464 100 88 176 2 1893983104 13514992 25342832
23:08:21 2138 8192000000 10798094096 11189940224 1862166144 18.521 100 91 180 2 1900028928 13034736 24828048
23:08:29 2065 8192000000 10809838976 11196260352 1864664784 18.541 100 85 167 2 1900938944 13127552 23146608
23:08:38 2107 8192000000 10809510400 11198300160 1865316752 18.546 100 92 183 2 1903501136 12496224 25688160
23:08:47 11786 8192000000 10804138608 11196538880 1863903552 18.535 100 78 156 1 1898344096 12497536 21943008
23:09:05 2387 8192000000 10810488560 11202478080 1869300912 18.579 100 89 176 2 1906927696 12627136 24999648
23:09:15 3220 8192000000 10816092656 11208364032 1870276000 18.587 100 88 177 0 1909046448 13128432 25642016
23:09:24 1463 8192000000 10819858256 11213496320 1876817008 18.639 100 95 189 0 1917368320 14294832 26256480
23:09:33 1669 8192000000 10815201216 11210084352 1873390448 18.612 100 81 163 1 1910828080 13582560 23855072
23:09:41 1440 8192000000 10813797520 11210936320 1878183328 18.650 100 79 156 2 1912405856 11893344 22329184
23:09:49 1630 8192000000 10811273392 11211464704 1875489120 18.629 100 76 150 0 1907645584 10467280 21689184
23:09:58 2120 8192000000 10819518496 11217252352 1878356064 18.652 100 73 144 4 1910167952 11754176 20057712
23:10:06 1978 8192000000 10822792000 11218505728 1882087696 18.682 100 66 131 1 1913004768 12103712 18813360
23:10:15 3608 8192000000 10796834000 11214401536 1879626064 18.662 100 55 109 2 1903752352 9021152 15105136
23:10:27 1853 8192000000 10803322608 11214311424 1884013072 18.698 100 52 107 0 1907344608 8669520 14662016
23:10:38 7517 8192000000 10788995888 11215626240 1886303872 18.716 100 42 87 0 1905249008 6520960 12424176
23:10:52 61726 8192000000 10811274768 11229360128 1888085456 18.730 100 47 94 0 1907659744 5677632 13896656
23:12:00 1393 8192000000 10846997632 11241902080 1900739792 18.832 100 91 186 1 1936473952 8894624 26839536
23:12:07 8421 8192000000 10808588000 11236741120 1892768208 18.768 100 47 94 2 1915245008 9687232 12789568
23:12:25 9067 8192000000 10802875888 11234394112 1888924608 18.737 100 28 56 2 1903661344 6094224 8642512
23:12:43 6499 8192000000 10808428768 11238064128 1894538416 18.782 100 34 66 0 1910582048 6488352 9555280
23:12:57 6933 8192000000 10822231168 11240419328 1897558880 18.807 100 35 72 1 1914467344 5504304 11404160
23:13:11 5584 8192000000 10817908576 11248971776 1899484784 18.822 100 42 84 2 1924391680 12672816 12234080
23:13:27 5945 8192000000 10830758928 11254771712 1900008336 18.826 100 25 50 2 1921177840 14403568 6765936
23:13:41 7308 8192000000 10816185280 11248459776 1904665600 18.864 100 24 48 2 1917839584 7102544 6071440
23:13:55 4851 8192000000 10829916976 11253448704 1906492496 18.878 100 36 72 1 1924538176 7796768 10248912
23:14:09 6276 8192000000 10817688144 11252973568 1904182336 18.860 100 17 34 0 1915767936 6594448 4991152
23:14:21 6544 8192000000 10830619824 11254673408 1909939776 18.906 100 37 74 1 1927787712 6674880 11173056
23:14:34 7177 8192000000 10821928080 11253465088 1907328736 18.885 100 29 56 1 1921439184 6143504 7966944
23:14:47 10649 8192000000 10812370496 11249831936 1889333072 18.740 99 22 42 1 1901561312 6119104 6109136
23:15:04 4123 8192000000 10829482720 11255861248 1906729632 18.880 100 30 62 1 1921123744 5668464 8725648
23:15:16 7090 8192000000 10803924960 11237003264 1866835568 18.559 98 13 26 1 1875759552 5350256 3573728
23:15:31 72823 8192000000 10830602992 11252539392 1899952016 18.826 100 20 41 1 1911451200 5046352 6452832
23:16:50 5537 8192000000 10816975936 11246055424 1900497776 18.830 100 48 96 0 1923414192 9654064 13262352
23:17:02 5014 8192000000 10823928304 11248717824 1900671168 18.832 100 44 89 0 1920099088 7192496 12235424
23:17:13 8656 8192000000 10830215744 11256950784 1902137008 18.843 100 26 51 0 1915261392 5605552 7518832
23:17:28 7550 8192000000 10786904720 11220066304 1876801648 18.639 99 24 48 1 1891015056 7434016 6779392
23:17:42 4672 8192000000 10824720016 11252666368 1897090928 18.803 100 34 68 0 1917772816 11147776 9534112
23:17:55 7825 8192000000 10790739344 11222593536 1857814816 18.486 98 30 60 2 1872748080 5549136 9384128
23:18:15 13280 8192000000 10775672832 11206205440 1839094656 18.333 98 27 53 3 1852393200 5131776 8166768
23:18:34 39821 8192000000 10737970016 11166306304 1714128528 17.303 91 22 44 3 1725562016 5328064 6105424
23:19:20 8565 8192000000 10728217600 11155697664 1788568384 17.920 97 32 64 0 1804687008 5967664 10150960
23:19:35 7487 8192000000 10742854592 11163635712 1794434832 17.968 98 18 36 2 1804995312 5497696 5062784
23:19:49 6902 8192000000 10724365648 11139375104 1780403296 17.853 97 25 49 1 1793472288 6001744 7067248
23:20:04 5749 8192000000 10720882416 11144032256 1799381616 18.009 98 21 40 1 1810573152 5200688 5990848
23:20:17 7417 8192000000 10705870848 11119960064 1706757472 17.242 94 24 49 1 1718741936 4848800 7135664
23:20:32 10034 8192000000 10716235520 11132780544 1767279232 17.745 97 30 60 1 1781977392 5822976 8875184
23:20:50 11788 8192000000 10708864032 11121524736 1723737168 17.383 95 36 71 3 1739888944 5370896 10780880
23:21:08 7088 8192000000 10696229120 11114102784 1742169984 17.537 97 19 38 1 1753461360 5500240 5791136
23:21:22 6676 8192000000 10710396032 11128414208 1780523040 17.854 99 35 70 0 1796811392 6262064 10026288
23:21:35 9070 8192000000 10690536992 11101368320 1694294912 17.137 95 34 68 2 1713757488 9369552 10093024
23:21:53 10772 8192000000 10702317104 11125145600 1780189280 17.851 99 27 54 1 1794822176 6180416 8452480
23:22:11 67185 8192000000 10734367216 11155038208 1784479008 17.886 98 40 78 2 1805544704 9821408 11244288
23:23:26 11585 8192000000 10732225312 11163979776 1827958208 18.243 100 21 42 2 1839315184 5240208 6116768
23:23:46 5913 8192000000 10754135296 11173969920 1838058416 18.325 100 38 76 2 1856493136 7342496 11092224
23:24:00 10967 8192000000 10746403024 11170660352 1809083808 18.088 98 25 50 0 1822432640 5691440 7657392
23:24:21 6801 8192000000 10759110544 11180871680 1827157024 18.236 99 29 58 1 1841973136 6420160 8395952
23:24:35 6878 8192000000 10766303856 11185254400 1846062576 18.390 100 30 61 1 1860930912 6189216 8679120
23:24:48 5639 8192000000 10770990096 11195498496 1852617584 18.443 100 27 54 1 1866670832 6387536 7665712
23:25:01 7638 8192000000 10786596464 11198021632 1855916144 18.470 100 36 69 1 1872549760 7098800 9534816
23:25:16 9687 8192000000 10780221008 11203125248 1857610480 18.484 100 17 34 0 1868456608 5620432 5225696
23:25:33 6586 8192000000 10778220368 11201896448 1859466960 18.499 100 21 40 1 1870629792 4797856 6364976
23:25:47 12189 8192000000 10771639712 11205685248 1862839376 18.526 100 23 46 1 1875309760 5422352 7048032
23:26:08 7871 8192000000 10775094032 11207000064 1868328416 18.571 100 23 46 1 1880576640 5562864 6685360
23:26:24 9507 8192000000 10778976832 11211390976 1865505216 18.548 100 11 22 0 1874407248 5280304 3621728
23:26:43 8699 8192000000 10781210608 11215003648 1870022000 18.584 100 12 24 0 1878996624 5181488 3793136
23:26:58 84748 8192000000 10823909776 11244974080 1884063760 18.698 100 32 64 2 1899710240 4919200 10727280
23:28:31 2376 8192000000 10847928400 11261247488 1910228576 18.908 100 59 118 0 1936117856 8012096 17877184
23:28:47 8304 8192000000 10834779328 11266011136 1914203744 18.940 100 40 80 0 1934233824 8615088 11414992
23:29:25 16163 8192000000 10853961152 11282153472 1928898816 19.058 100 48 94 2 1951336176 9216128 13221232
23:29:50 19929 8192000000 10861634128 11291459584 1935034112 19.107 100 42 82 2 1956029120 8101456 12893552
23:30:21 26244 8192000000 10874736208 11303612416 1941274416 19.157 100 40 80 1 1961734832 8700208 11760208
23:30:54 36781 8192000000 10882517136 11312717824 1948842224 19.217 100 49 99 1 1973707952 11026432 13839296
23:31:39 29516 8192000000 10888271392 11321913344 1956791344 19.281 100 44 88 0 1981668608 11660384 13216880
23:32:23 19401 8192000000 10882361888 11319242752 1941712704 19.160 99 51 101 1 1970806304 14026960 15066640
23:33:37 10521 8192000000 10896396096 11332980736 1962959472 19.330 100 43 86 0 1990215920 14810752 12445696
23:34:00 5120 8192000000 10886761328 11324919808 1957504192 19.286 100 37 74 1 1984000528 15097216 11399120
23:34:13 18371 8192000000 10897481504 11339583488 1962882672 19.329 100 43 85 0 1997472448 21747104 12842672
23:34:40 7089 8192000000 10908152864 11342557184 1968491456 19.373 100 43 86 1 2001361536 19542960 13327120
23:35:01 13661 8192000000 10912904176 11348840448 1972621328 19.406 100 46 92 2 2004424656 17567376 14235952
23:35:33 18865 8192000000 10920309392 11353157632 1961994944 19.322 99 51 102 0 1996104304 18365600 15743760
23:36:16 6375 8192000000 10928204560 11359596544 1983165072 19.490 100 54 107 1 2018260064 19077472 16017520
23:36:29 6801 8192000000 10943018480 11372322816 1987224240 19.522 100 62 124 0 2024923488 19160432 18538816
23:36:45 3041 8192000000 10945044064 11373404160 1998089264 19.608 100 66 130 0 2036421072 17711264 20620544
23:37:01 9558 8192000000 10950166656 11385409536 2000058800 19.623 100 57 113 0 2037242368 20159296 17024272
23:37:18 8665 8192000000 10954069520 11388579840 2003218048 19.648 100 56 112 0 2043947872 24111552 16618272
23:37:35 4630 8192000000 10952284448 11378061312 1984710912 19.502 99 62 124 2 2028875680 25150832 19013936
23:37:48 6548 8192000000 10951048016 11385446400 1995930880 19.591 100 64 126 0 2042497760 26549648 20017232
23:38:03 13133 8192000000 10947560080 11381379072 1994148768 19.577 100 46 92 1 2031084368 22991904 13943696
23:38:40 11466 8192000000 10955046496 11399204864 2004505936 19.658 100 51 102 3 2046911632 26799392 15606304
23:38:58 8978 8192000000 10972022800 11405983744 2006995088 19.678 100 58 116 2 2053081136 27858112 18227936
23:39:18 5030 8192000000 10964119808 11400892416 2006626560 19.675 100 50 97 1 2050242352 28965712 14650080
23:39:32 3030 8192000000 10978661936 11408125952 2015065408 19.741 100 73 146 1 2065585808 27670544 22849856
23:39:43 8265 8192000000 10953577440 11387936768 1991092944 19.552 99 75 148 2 2041794416 28764384 21937088
23:40:03 8154 8192000000 10968627120 11407474688 2006527712 19.674 100 59 118 1 2051310400 26509008 18273680
23:40:19 4309 8192000000 10960730240 11399528448 1992118464 19.561 99 59 117 1 2038571312 28993520 17459328
23:40:31 5815 8192000000 10969612784 11405705216 2008614800 19.691 100 57 114 1 2054792048 28289632 17887616
23:40:45 6591 8192000000 10967538816 11407556608 2011457920 19.713 100 53 105 2 2057574288 29571376 16544992
23:41:01 4032 8192000000 10986611392 11415601152 2017127856 19.758 100 74 145 3 2069430688 30420016 21882816
23:41:12 1367 8192000000 10994034960 11412881408 2015878080 19.748 100 86 171 2 2073677744 31824992 25974672
23:41:20 4653 8192000000 10959562544 11373273088 1981859168 19.479 98 82 164 1 2037825488 32170496 23795824
23:41:31 3421 8192000000 10960208416 11379482624 1983832688 19.495 99 86 172 2 2043979024 33861136 26285200
23:41:44 3037 8192000000 10971663088 11388829696 1994293600 19.578 100 76 150 3 2050195744 33383184 22518960
23:41:56 4655 8192000000 10981405200 11401646080 2005315984 19.665 100 78 154 3 2062560496 33880656 23363856
23:42:09 1460 8192000000 10981177952 11400699904 1990998848 19.552 99 84 167 1 2051293696 34588672 25706176
23:42:17 2050 8192000000 10983416080 11402719232 2003022464 19.647 100 90 180 1 2065188224 34324848 27840912
23:42:27 2350 8192000000 10969122368 11383554048 1981100928 19.473 99 91 182 0 2042286704 33097504 28088272
23:42:37 2527 8192000000 10963287472 11381268480 1988851872 19.535 100 80 161 2 2045008864 32189136 23967856
23:42:48 15415 8192000000 10966893904 11390341120 1987583264 19.525 100 71 142 2 2044107936 34988288 21536384
23:43:12 8020 8192000000 10955794512 11378167808 1988564336 19.532 100 70 140 1 2046761632 36334864 21862432
23:43:31 3965 8192000000 10971743344 11396943872 1993486880 19.571 100 66 132 0 2054985520 40442016 21056624
23:43:41 1370 8192000000 10960929296 11376750592 1977460864 19.445 99 78 157 4 2042297728 40418656 24418208
23:43:50 3662 8192000000 10967090992 11390132224 1975644640 19.430 99 69 138 0 2038889216 41365856 21878720
23:44:02 1186 8192000000 10976501504 11390672896 1974485360 19.421 99 86 172 1 2043195568 41494848 27215360
23:44:10 2770 8192000000 10964448832 11378782208 1974224864 19.419 100 84 164 2 2042862016 43142416 25494736
23:44:21 1315 8192000000 10969789840 11383492608 1976622976 19.438 100 86 174 0 2047733264 44543824 26566464
23:44:29 2086 8192000000 10959930368 11373006848 1971109664 19.394 100 85 168 2 2040855776 43921440 25824672
23:44:38 4331 8192000000 10975345872 11386970112 1982641088 19.486 100 82 163 2 2052229680 44475920 25112672
23:44:51 2406 8192000000 10959056768 11375112192 1968192832 19.371 99 81 162 1 2036717008 43163744 25360432
23:45:03 2105 8192000000 10973106688 11388284928 1986843616 19.519 100 80 159 1 2056494560 44437840 25213104
23:45:11 2566 8192000000 10962430752 11372544000 1969835824 19.384 100 90 180 0 2041015280 43001968 28177488
23:45:22 1979 8192000000 10970612336 11385282560 1978313360 19.451 100 77 155 1 2046792912 43928656 24550896
23:45:31 2278 8192000000 10974066176 11391242240 1984205920 19.498 100 92 184 0 2058024016 45332064 28486032
23:45:41 4434 8192000000 10969293904 11388678144 1980785008 19.471 100 76 150 0 2050345280 45881104 23679168
23:45:53 1973 8192000000 10987424160 11404992512 1988946592 19.535 100 83 167 0 2061153216 45701680 26504944
23:46:01 2942 8192000000 10970409984 11385737216 1975237728 19.427 99 83 166 0 2046322048 45752032 25332288
23:46:12 4842 8192000000 10976121760 11390783488 1980589040 19.469 100 75 150 0 2050982832 46813344 23580448
23:46:24 1062 8192000000 10973220208 11382099968 1966579504 19.358 99 94 188 2 2043145216 47180992 29384720
23:46:33 4207 8192000000 10975363136 11395055616 1979996016 19.465 100 75 149 0 2050728096 46728720 24003360
23:46:44 6460 8192000000 10947320320 11385864192 1976525504 19.437 100 49 97 0 2033723008 41725104 15472400
23:46:58 9135 8192000000 10948358720 11384573952 1972896528 19.408 100 42 81 3 2028905616 42376624 13632464
23:47:14 10368 8192000000 10935035056 11384725504 1956435952 19.278 99 40 80 0 2011268160 41659392 13172816
23:47:32 10208 8192000000 10931445760 11376713728 1954529664 19.263 99 37 74 0 2009126784 42625280 11971840
23:47:52 5166 8192000000 10922858512 11373064192 1942384128 19.166 99 39 78 0 1995430800 40247760 12798912
23:48:04 11690 8192000000 10929350864 11372240896 1966403792 19.357 100 38 75 2 2016191520 37243264 12544464
23:48:24 4016 8192000000 10948412224 11367370752 1954627232 19.263 99 66 126 2 2012771648 37360176 20784240
23:48:38 1539 8192000000 10967409344 11373383680 1946339312 19.197 98 89 175 2 2014245136 40832880 27072944
23:48:46 19293 8192000000 10923370400 11364122624 1934006992 19.099 98 37 75 0 1987147136 41089088 12051056
23:49:30 8583 8192000000 10924342480 11356958720 1932220512 19.085 99 44 84 1 1990680704 44844256 13615936
23:49:45 6465 8192000000 10927081008 11355082752 1943448176 19.174 100 52 103 0 2008952336 48749328 16754832
23:50:13 5869 8192000000 10924775728 11356565504 1932048736 19.083 99 48 97 0 1997205600 48420448 16736416
23:50:30 9766 8192000000 10925158432 11366273024 1952328032 19.245 100 34 68 2 2015188224 50696720 12163472
23:50:53 10152 8192000000 10947084976 11378827264 1963482416 19.334 100 62 124 1 2036367792 53161840 19723536
23:51:16 15943 8192000000 10936194944 11376578560 1952385264 19.245 100 35 70 0 2020244032 54933200 12925568
23:51:39 15445 8192000000 10946958384 11395649536 1959561024 19.303 100 37 74 1 2028036800 55641136 12834640
23:52:14 24719 8192000000 10935611824 11369713664 1936839456 19.122 99 40 81 4 2006636816 55647936 14149424
23:52:55 31839 8192000000 10919167232 11387727872 1937167984 19.124 99 31 62 1 2005476864 56859392 11449488
23:53:47 22680 8192000000 10900606976 11364265984 1929126528 19.060 99 21 42 0 1971226992 35059968 7040496
23:54:32 26189 8192000000 10910388608 11359682560 1947788032 19.209 100 32 64 0 1998249312 39575200 10886080
23:55:10 12810 8192000000 10901438864 11361345536 1925255664 19.029 99 22 44 1 1975903776 42656256 7991856
23:55:30 12364 8192000000 10894508176 11371839488 1936752496 19.121 100 17 34 2 1981089952 38645184 5692272
23:56:02 14355 8192000000 10870976432 11334373376 1919471120 18.983 100 12 22 2 1957887840 34490544 3926176
23:56:23 59358 8192000000 10850043168 11314999296 1877543296 18.645 98 5 10 0 1893273376 14658944 1071136
23:57:29 59902 8192000000 10863843696 11319816192 1886970704 18.721 98 4 8 0 1896564160 8744112 849344
23:58:38 68443 8192000000 10868059216 11317288960 1915865136 18.954 99 30 59 1 1943774896 19594784 8314976
00:00:16 64104 8192000000 10875378096 11332968448 1940813584 19.153 100 17 34 0 1965784816 20508992 4462240
00:01:30 56702 8192000000 10883143408 11359293440 1941776992 19.161 100 7 14 1 1969612784 26039312 1796480
00:02:33 77076 8192000000 10870818832 11329921024 1860758688 18.509 95 14 28 1 1876618304 11782576 4077040
00:03:57 86803 8192000000 10875491088 11348807680 1931372272 19.078 99 11 22 1 1954266352 19510288 3383792
00:05:30 75261 8192000000 10922094992 11354234880 1961866496 19.321 100 24 48 1 1982986496 14476688 6643312
00:06:55 8639 8192000000 10929647232 11354521600 1958185808 19.292 99 74 144 2 1987359216 6866000 22307408
00:07:23 12024 8192000000 10910634848 11357274112 1969602912 19.382 100 41 82 3 1991258208 9671328 11983968
00:07:51 45816 8192000000 10892735424 11355090944 1948665472 19.216 99 24 48 1 1965448288 9186320 7596496
00:08:55 108560 8192000000 10923102160 11370090496 1942415728 19.166 99 16 32 0 1953863072 7215312 4232032
00:10:50 50155 8192000000 10928491904 11383742464 1979516752 19.461 100 39 76 4 2001736176 11819952 10399472
00:11:49 85459 8192000000 10902116688 11371204608 1960326224 19.309 99 15 30 1 1972444480 8187296 3930960
00:13:21 1350 8192000000 10911740864 11376623616 1980594688 19.469 100 20 39 1 1996931360 11198976 5137696
00:13:30 20817 8192000000 10911675232 11384864768 1988658288 19.533 100 33 66 0 2007870768 10226240 8986240
00:14:00 20275 8192000000 10914935008 11380805632 1972078896 19.402 99 23 46 2 1989308960 10647808 6582256
00:14:39 20903 8192000000 10933938416 11391119360 1994726352 19.581 100 44 88 2 2018215680 10784960 12704368
00:15:08 15493 8192000000 10955916048 11398258688 2001453504 19.634 100 53 106 1 2029338592 13258304 14626784
00:15:31 66711 8192000000 10914716912 11400388608 1993145568 19.569 100 38 72 2 2017078496 12925648 11007280
00:16:46 31779 8192000000 10909128496 11393286144 1973482960 19.413 99 8 16 0 1986100384 10352640 2264784
00:17:31 16965 8192000000 10900366272 11380588544 1982650640 19.486 100 14 28 0 1995258848 9150064 3458144
00:17:54 40367 8192000000 10911899168 11389513728 1990260112 19.546 100 7 14 0 2000913904 8681968 1971824
00:19:27 115427 8192000000 10903726208 11382145024 1935440288 19.110 97 17 33 1 1950064032 10216288 4407456
00:21:31 84087 8192000000 10910425056 11385769984 1951239616 19.236 98 11 20 1 1970515760 16371744 2904400
00:23:47 80924 8192000000 10916487568 11395936256 1951780208 19.241 98 19 38 3 1976204736 19150560 5273968
00:25:17 64444 8192000000 10904213168 11384774656 1923151680 19.012 97 14 28 0 1950779264 23343968 4283616
00:26:32 91100 8192000000 10891566944 11356348416 1859888352 18.502 94 11 22 0 1871316320 8631456 2796512
00:28:12 61535 8192000000 10910849440 11383480320 1955520000 19.270 99 24 48 1 1979587232 16703936 7363296
00:29:51 64144 8192000000 10883197776 11347718144 1849305952 18.416 94 15 30 1 1872091856 18666080 4119824
00:31:02 40666 8192000000 10885709488 11348172800 1911851424 18.922 98 10 20 0 1925589936 10566048 3172464
00:31:53 45302 8192000000 10874173952 11336458240 1853768624 18.453 95 34 67 1 1879908176 16779072 9360480
00:32:48 82293 8192000000 10874774320 11323936768 1843759456 18.371 95 25 51 1 1865693280 14925504 7008320
00:34:19 20815 8192000000 10872786032 11319328768 1879064944 18.658 97 33 66 0 1897683456 9509312 9109200
00:34:47 63337 8192000000 10849669952 11298615296 1828664928 18.248 95 33 66 0 1852023152 13767648 9590576
00:36:09 99730 8192000000 10845588688 11305963520 1862362928 18.522 97 34 68 3 1883851488 11551024 9937536
00:38:00 108572 8192000000 10829317424 11298893824 1786110304 17.900 93 19 38 0 1800681776 9287136 5284336
00:40:06 17127 8192000000 10812105664 11279663104 1843728464 18.371 97 10 20 0 1857801552 11416640 2656448
00:40:38 49903 8192000000 10824544608 11282874368 1860641760 18.508 98 22 44 1 1877632960 11140720 5850480
00:41:37 54397 8192000000 10814592112 11273158656 1837302992 18.319 97 10 20 0 1847197680 7242928 2651760
00:43:01 68179 8192000000 10845535600 11320217600 1910255520 18.909 100 14 28 1 1930072480 15501424 4315536
00:44:27 72360 8192000000 10843351824 11322085376 1921631968 19.000 100 14 26 0 1934011376 8532272 3847136
00:46:00 55814 8192000000 10860464720 11339046912 1931168400 19.076 100 16 32 1 1944219488 8359488 4691600
00:47:04 76131 8192000000 10868063968 11336474624 1899602000 18.823 98 10 20 2 1912798288 10270480 2925808
00:48:40 15459 8192000000 10860480640 11325014016 1913071088 18.931 98 20 39 3 1924134912 6192336 4871488
00:49:04 35910 8192000000 10867742384 11338166272 1901493808 18.838 98 13 26 0 1914232400 8687472 4051120
00:49:51 19159 8192000000 10875732672 11334000640 1927253264 19.045 99 34 65 0 1941868144 5428208 9186672
00:50:18 15174 8192000000 10888751536 11348783104 1955708848 19.272 100 52 101 1 1977372752 7228688 14435216
00:51:05 59544 8192000000 10879397792 11351474176 1948685824 19.216 100 25 50 1 1965959200 9788432 7484944
00:52:19 27225 8192000000 10891536528 11357323264 1956930336 19.282 100 28 55 2 1973465248 8380080 8154832
00:52:55 50304 8192000000 10887395984 11362562048 1939214656 19.140 99 21 42 0 1955038432 10495760 5328016
00:53:52 58585 8192000000 10884838592 11367780352 1939323040 19.141 99 13 26 1 1959335408 16270256 3742112
00:55:28 74951 8192000000 10896553808 11384975360 1974184016 19.419 100 28 56 1 1999156720 17561280 7411424
00:57:18 75973 8192000000 10917209648 11385831424 1961113312 19.315 99 22 43 0 1976783600 10078528 5591760
01:00:06 73175 8192000000 10942926288 11406204928 2002335760 19.641 100 34 68 3 2024336720 12004064 9996896
01:01:26 70539 8192000000 10914129280 11401187328 1979228032 19.459 99 14 28 0 1994654048 11391728 4034288
01:02:42 60876 8192000000 10910426800 11392876544 1980673648 19.470 99 5 10 0 1994992880 12722432 1596800
01:03:56 83157 8192000000 10914213424 11396362240 1947368608 19.206 98 12 23 1 1962738096 12184640 3184848
01:05:26 60099 8192000000 10890812816 11376398336 1908482064 18.894 96 15 30 1 1923199456 10416160 4301232
01:06:37 53687 8192000000 10891111168 11369721856 1921823232 19.001 97 33 66 0 1939797600 8225872 9748496
01:07:41 43900 8192000000 10918720096 11379671040 1936959312 19.122 98 18 36 1 1950152224 7945920 5246992
01:08:31 29696 8192000000 10916480592 11388633088 1969037776 19.378 99 40 78 1 1989505152 9671040 10796336
01:09:07 63585 8192000000 10920329776 11407171584 1971212368 19.395 99 21 43 0 1994519664 17095472 6211824
01:10:30 95296 8192000000 10898380608 11365580800 1876706832 18.639 95 15 30 1 1897613504 16778464 4128208
01:12:14 85867 8192000000 10891752736 11361251328 1851217360 18.432 94 16 32 0 1866913520 11827456 3868704
01:13:46 89562 8192000000 10861421552 11339395072 1852864512 18.445 95 17 32 1 1866613888 9412416 4336960
01:15:23 35197 8192000000 10881122016 11325919232 1869991168 18.584 96 54 108 0 1894312080 8092768 16228144
01:16:06 12829 8192000000 10866407328 11320025088 1905663104 18.872 99 49 98 1 1932453328 12731728 14058496
01:16:27 77481 8192000000 10840025936 11305369600 1849175632 18.415 96 22 45 0 1865175968 9951040 6049296
01:18:01 84077 8192000000 10833116480 11304460288 1866114128 18.553 97 22 44 0 1882225040 9763312 6347600
01:19:40 20630 8192000000 10844100368 11324915712 1916723056 18.961 100 15 28 0 1928844192 8327936 3793200
01:20:07 26400 8192000000 10793440752 11256737792 1830267376 18.262 95 12 24 1 1840430256 7007648 3155232
01:20:49 62506 8192000000 10804642896 11284713472 1852988992 18.446 97 9 18 0 1868195984 12476512 2730480
01:22:02 43341 8192000000 10844221456 11323527168 1901385472 18.837 99 15 30 1 1916930656 11321152 4224032
01:22:55 76531 8192000000 10830913520 11306348544 1869233504 18.578 97 11 22 1 1883970432 11286576 3450352
01:24:18 123961 8192000000 10822994912 11304828928 1758865712 17.675 92 12 24 0 1779975680 17913504 3196464
01:26:28 56175 8192000000 10210927520 10620833792 1281277008 13.525 68 6 12 0 1294773264 11924336 1571920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 13-03-2021 01:28:54 to 13-03-2021 01:29:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 130 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-03-2021 01:29:27 to 13-03-2021 01:29:29.

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          247520
MON$OLDEST_ACTIVE               249273
MON$OLDEST_SNAPSHOT             249273
MON$NEXT_TRANSACTION            249273
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                       2035296
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.33425 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33425 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33425 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33425 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 ---
:21: 
:22: mscs-test-161.budzdorov.ru    Sat Mar 13 01:27:29 2021
:23:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:24: 
:25: 
:26: mscs-test-161.budzdorov.ru    Sat Mar 13 01:27:29 2021
:27:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:28: 
--- end of diff output ---

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

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