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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17093568 kB
MemAvailable 31318352 kB
Buffers 0 kB
Cached 14585416 kB
SwapCached 4864 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-01-19 01:27:10
DTS_END                         2021-01-19 01:27:10.7550
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/33082
TRN_ID                          239883
ATT_ID                          670
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: 9587.46 21577 1150495
customer order: creation 174.38 379 20925
customer order: refuse 15.25 322 1830
order to supplier: creation 46.22 1172 5546
order to supplier: removal 3.55 94817 426
invoice (draft): creation 47.12 3320 5654
invoice (draft): removal 54.08 735 6490
invoice accept: apply 43.43 16931 5212
invoice accept: cancel 49.55 729 5946
customer reserve: creation 3988.01 169 478561
customer reserve: removal 4865.97 54 583916
realization accept: apply 84.47 181 10136
realization accept: cancel 85.24 97 10229
payment from customer: creation 59.23 125 7107
payment from customer: removal 6.06 76 727
payment to supplier: creation 48.99 119 5879
payment to supplier: removal 3.39 65 407
service: total inventory turnovers 4.85 1150 582
service: total monetary turnovers 6.78 50 814
service: aggregate perf. data 0.87 17135 104
service: refresh index statistics 0.03 293919 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-01-2021 01:28:30 to 19-01-2021 01:28:32.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4480
TEST_TIME 2 5100
TEST_TIME 3 5044
TEST_TIME 4 5491
TEST_TIME 5 5585
TEST_TIME 6 5374
TEST_TIME 7 5376
TEST_TIME 8 5293
TEST_TIME 9 5522
TEST_TIME 10 5777
TEST_TIME 11 5819
TEST_TIME 12 6386
TEST_TIME 13 6806
TEST_TIME 14 7327
TEST_TIME 15 7303
TEST_TIME 16 8292
TEST_TIME 17 8249
TEST_TIME 18 8730
TEST_TIME 19 8614
TEST_TIME 20 9118
TEST_TIME 21 9153
TEST_TIME 22 9252
TEST_TIME 23 9986
TEST_TIME 24 10454
TEST_TIME 25 10622
TEST_TIME 26 11124
TEST_TIME 27 10921
TEST_TIME 28 10704
TEST_TIME 29 10677
TEST_TIME 30 10691
TEST_TIME 31 10610
TEST_TIME 32 10602
TEST_TIME 33 10634
TEST_TIME 34 10679
TEST_TIME 35 10856
TEST_TIME 36 10840
TEST_TIME 37 10725
TEST_TIME 38 10697
TEST_TIME 39 10480
TEST_TIME 40 10322
TEST_TIME 41 10476
TEST_TIME 42 10275
TEST_TIME 43 10240
TEST_TIME 44 10128
TEST_TIME 45 10060
TEST_TIME 46 10094
TEST_TIME 47 10211
TEST_TIME 48 10147
TEST_TIME 49 10079
TEST_TIME 50 10015
TEST_TIME 51 9913
TEST_TIME 52 10046
TEST_TIME 53 10002
TEST_TIME 54 9969
TEST_TIME 55 9939
TEST_TIME 56 10054
TEST_TIME 57 10195
TEST_TIME 58 10130
TEST_TIME 59 10068
TEST_TIME 60 10144
TEST_TIME 61 10179
TEST_TIME 62 10252
TEST_TIME 63 10267
TEST_TIME 64 10288
TEST_TIME 65 10455
TEST_TIME 66 10314
TEST_TIME 67 10173
TEST_TIME 68 10149
TEST_TIME 69 10105
TEST_TIME 70 10102
TEST_TIME 71 10016
TEST_TIME 72 9916
TEST_TIME 73 9886
TEST_TIME 74 9837
TEST_TIME 75 9849
TEST_TIME 76 9790
TEST_TIME 77 9757
TEST_TIME 78 9870
TEST_TIME 79 9897
TEST_TIME 80 9874
TEST_TIME 81 9906
TEST_TIME 82 9923
TEST_TIME 83 9920
TEST_TIME 84 9939
TEST_TIME 85 9962
TEST_TIME 86 9961
TEST_TIME 87 10003
TEST_TIME 88 9952
TEST_TIME 89 9897
TEST_TIME 90 9858
TEST_TIME 91 9833
TEST_TIME 92 9791
TEST_TIME 93 9724
TEST_TIME 94 9683
TEST_TIME 95 9707
TEST_TIME 96 9748
TEST_TIME 97 9743
TEST_TIME 98 9785
TEST_TIME 99 9774
TEST_TIME 100 9762
TEST_TIME 101 9717
TEST_TIME 102 9811
TEST_TIME 103 9812
TEST_TIME 104 9779
TEST_TIME 105 9831
TEST_TIME 106 9864
TEST_TIME 107 9892
TEST_TIME 108 9887
TEST_TIME 109 9852
TEST_TIME 110 9792
TEST_TIME 111 9805
TEST_TIME 112 9762
TEST_TIME 113 9727
TEST_TIME 114 9669
TEST_TIME 115 9668
TEST_TIME 116 9677
TEST_TIME 117 9628
TEST_TIME 118 9624
TEST_TIME 119 9659
TEST_TIME 120 9589

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 19-01-2021 01:28:33 to 19-01-2021 01:28:37.

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 1592756 1592756 0 0.00 0 14571 5 0 0
doc_list_biud 1592755 1592755 0 0.00 0 33129 26 0 0
sp_add_invoice_to_stock 5315 5212 103 1.93 37 183653 16931 0 103
sp_cancel_adding_invoice 5946 5946 0 0.00 5 49778 729 0 0
sp_cancel_client_order 1830 1830 0 0.00 5 8629 323 0 0
sp_cancel_customer_reserve 583916 583916 0 0.00 1 23105 55 0 0
sp_cancel_pay_from_customer 727 727 0 0.00 2 9345 76 0 0
sp_cancel_pay_to_supplier 407 407 0 0.00 3 5188 66 0 0
sp_cancel_supplier_invoice 6497 6490 7 0.10 2 33140 736 0 7
sp_cancel_supplier_order 426 426 0 0.00 5 1094638 94818 0 0
sp_cancel_write_off 10229 10229 0 0.00 1 14024 98 0 0
sp_client_order 20925 20925 0 0.00 4 28015 380 0 0
sp_customer_reserve 478561 478561 0 0.00 0 41545 169 0 0
sp_fill_shopping_cart 32120 32120 0 0.00 1 13633 33 0 0
sp_fill_shopping_cart_clo_res 478557 478557 0 0.00 0 13899 13 0 0
sp_get_clo_for_invoice 5208 5208 0 0.00 0 23374 271 0 0
sp_kill_cost_storno 17309 17309 0 0.00 0 6603 49 0 0
sp_kill_qstorno_ret_qs2qd 1184977 1184977 0 0.00 0 33111 30 0 0
sp_kill_qty_storno 624181 624181 0 0.00 0 33124 64 0 0
sp_lock_selected_doc 21316 21316 0 0.00 0 9735 6 0 0
sp_make_cost_storno 28330 28330 0 0.00 0 14492 48 0 0
sp_multiply_rows_for_pdistr 28330 28330 0 0.00 0 7987 28 0 0
sp_multiply_rows_for_qdistr 20925 20925 0 0.00 0 11179 176 0 0
sp_pay_from_customer 7107 7107 0 0.00 4 20288 125 0 0
sp_pay_to_supplier 5879 5879 0 0.00 5 15468 120 0 0
sp_payment_common 12986 12986 0 0.00 1 13295 28 0 0
sp_qd_handle_on_cancel_clo 1830 1830 0 0.00 0 8336 284 0 0
sp_qd_handle_on_invoice_upd_sts 11154 11154 0 0.00 0 20322 316 0 0
sp_qd_handle_on_reserve_upd_sts 10136 10136 0 0.00 0 21136 68 0 0
sp_reserve_write_off 10136 10136 0 0.00 6 22081 182 0 0
sp_supplier_invoice 5654 5654 0 0.00 7 98081 3320 0 0
sp_supplier_order 5546 5546 0 0.00 5 39425 1173 0 0
srv_aggregate_perf_data 104 104 0 0.00 2227 148618 17135 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1241 121662 32630 0 0
srv_find_qd_qs_mism 1101411 1101411 0 0.00 0 11040 5 0 0
srv_make_invnt_saldo 582 582 0 0.00 31 140337 1151 0 0
srv_make_money_saldo 814 814 0 0.00 1 21256 50 0 0
srv_recalc_idx_stat 4 4 0 0.00 183955 444719 293919 0 0
t$perf-abend:sp_add_invoice_to_stock 103 103 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5212 5212 0 0.00 0 14138 167 0 0
t$perf-norm:sp_cancel_adding_invoice 401 401 0 0.00 0 3480 112 0 0
t$perf-norm:sp_cancel_client_order 1830 1830 0 0.00 0 15264 31 0 0
t$perf-norm:sp_cancel_customer_reserve 723 723 0 0.00 0 3960 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 727 727 0 0.00 0 854 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 407 407 0 0.00 0 4302 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 395 395 0 0.00 0 1156 13 0 0
t$perf-norm:sp_cancel_supplier_order 426 426 0 0.00 0 25373 1518 0 0
t$perf-norm:sp_cancel_write_off 1065 1065 0 0.00 0 8425 16 0 0
t$perf-norm:sp_client_order 20925 20925 0 0.00 0 10746 18 0 0
t$perf-norm:sp_customer_reserve 1013 1013 0 0.00 0 2750 6 0 0
t$perf-norm:sp_pay_from_customer 7107 7107 0 0.00 0 4936 14 0 0
t$perf-norm:sp_pay_to_supplier 5879 5879 0 0.00 0 5406 9 0 0
t$perf-norm:sp_reserve_write_off 10136 10136 0 0.00 0 5462 9 0 0
t$perf-norm:sp_supplier_invoice 5654 5654 0 0.00 0 10639 21 0 0
t$perf-norm:sp_supplier_order 5546 5546 0 0.00 0 6749 15 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 164 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 1989 27 0 0
t$perf-norm:srv_make_invnt_saldo 582 582 0 0.00 0 2956 28 0 0
t$perf-norm:srv_make_money_saldo 814 814 0 0.00 0 4358 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10620 10414 206 1.93 0 10563 25 0 206
v_all_customers 37892 37892 0 0.00 0 14 1 0 0
v_all_suppliers 30816 30816 0 0.00 0 15 1 0 0
v_all_wares 41850 41850 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 802 802 0 0.00 0 6031 14 0 0
v_cancel_client_order 3660 3660 0 0.00 0 5980 9 0 0
v_cancel_customer_prepayment 1454 1454 0 0.00 0 3874 5 0 0
v_cancel_customer_reserve 1446 1446 0 0.00 0 5978 12 0 0
v_cancel_payment_to_supplier 814 814 0 0.00 0 279 3 0 0
v_cancel_supplier_invoice 804 790 14 1.74 0 5659 45 0 14
v_cancel_supplier_order 852 852 0 0.00 0 5829 26 0 0
v_cancel_write_off 2130 2130 0 0.00 0 1304 12 0 0
v_max_id_clo_ord 5546 5546 0 0.00 0 2263 2 0 0
v_max_id_clo_res 1013 1013 0 0.00 0 5375 16 0 0
v_max_id_ord_sup 5649 5649 0 0.00 0 7686 8 0 0
v_max_non_paid_invoice 1666 1666 0 0.00 0 401 2 0 0
v_max_non_paid_realizn 3778 3778 0 0.00 0 3341 5 0 0
v_min_id_clo_ord 5546 5546 0 0.00 0 3088 6 0 0
v_min_id_clo_res 1013 1013 0 0.00 0 6196 19 0 0
v_min_id_ord_sup 5649 5649 0 0.00 0 6148 5 0 0
v_min_non_paid_invoice 5879 5879 0 0.00 0 5080 18 0 0
v_min_non_paid_realizn 7107 7107 0 0.00 0 10967 17 0 0
v_our_firm 10616 10616 0 0.00 0 19 1 0 0
v_reserve_write_off 20270 20270 0 0.00 0 10285 9 0 0
x_lock_depdocs_on_canc_invoice 12041 12041 0 0.00 0 11529 105 0 0
x_lock_depdocs_on_canc_sup_ord 426 426 0 0.00 0 11742 353 0 0
x_make_qstorno_1000_1200 5546 5546 0 0.00 1 39419 1103 0 0
x_make_qstorno_1200_2000 5654 5654 0 0.00 3 98073 3206 0 0
x_make_qstorno_2100_3300 478561 478561 0 0.00 0 41539 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-01-2021 01:28:38 to 19-01-2021 01:28:42.

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:14 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:20 20636 8192000000 10251137136 10565562368 868914192 9.589 68 50 101 0 888459472 2387952 17157328
22:57:59 35129 8192000000 10364268496 10686238720 1413157712 14.712 100 83 166 0 1444615296 5256528 26201056
22:58:41 13494 8192000000 10394112112 10717011968 1438764192 14.939 100 83 167 0 1476313216 10875792 26673232
22:59:03 21846 8192000000 10420456000 10747473920 1467009952 15.187 100 88 176 0 1502436368 7306880 28119536
22:59:36 17732 8192000000 10428351728 10758914048 1485351952 15.348 100 90 180 1 1522673984 8138528 29183504
23:00:08 23369 8192000000 10452072992 10787520512 1505861040 15.527 100 87 174 0 1542736672 8783648 28091984
23:00:40 22264 8192000000 10467534592 10808979456 1522032288 15.668 100 80 160 0 1556203552 9081856 25089408
23:01:14 22505 8192000000 10504396032 10852548608 1555975152 15.962 100 83 166 0 1591402208 9744304 25682752
23:01:46 16838 8192000000 10535976000 10887700480 1588906896 16.244 100 86 172 0 1625031536 10015104 26109536
23:02:11 8677 8192000000 10547817776 10904252416 1610972176 16.433 100 75 150 2 1643783696 10680896 22130624
23:02:30 12952 8192000000 10573987584 10931556352 1622867360 16.534 100 75 150 0 1656507088 10670480 22969248
23:02:50 14947 8192000000 10587988464 10949615616 1645832000 16.729 100 81 162 0 1681320016 11265904 24222112
23:03:18 11045 8192000000 10602372896 10967867392 1664066432 16.883 100 77 154 2 1698916752 11906480 22943840
23:03:41 13851 8192000000 10633378160 11001651200 1691731168 17.116 100 80 158 2 1727269776 12555536 22983072
23:04:10 10971 8192000000 10657294256 11031441408 1716539568 17.323 100 85 167 2 1754246000 13392912 24313520
23:04:32 4849 8192000000 10678849776 11052494848 1732385488 17.455 100 80 156 2 1767641632 12712368 22543776
23:04:46 7404 8192000000 10676610432 11053617152 1737881104 17.501 100 77 154 2 1772784448 13196480 21706864
23:05:00 6491 8192000000 10675528800 11058548736 1744933248 17.560 100 74 148 1 1778694352 13015104 20746000
23:05:14 4599 8192000000 10695402752 11076530176 1756608736 17.656 100 73 146 0 1790256112 12824320 20823056
23:05:26 9942 8192000000 10698738544 11084173312 1765004320 17.726 100 74 148 1 1799311360 13125952 21181088
23:05:45 4701 8192000000 10713440640 11095019520 1773177472 17.793 100 79 157 2 1808108144 12646096 22284576
23:05:57 3546 8192000000 10718189024 11103531008 1784710544 17.888 100 78 155 0 1820352000 13380368 22261088
23:06:08 5052 8192000000 10728251520 11119550464 1790549280 17.936 100 76 152 2 1825556128 13567552 21439296
23:06:19 4588 8192000000 10736187232 11127140352 1799782384 18.012 100 74 149 2 1834072416 13487504 20802528
23:06:31 3321 8192000000 10745279024 11131297792 1810821344 18.103 100 82 164 0 1846515168 13191488 22502336
23:06:41 3467 8192000000 10761237616 11143475200 1813037136 18.121 100 77 154 1 1847135424 12231104 21867184
23:06:51 2511 8192000000 10757628240 11144601600 1823519168 18.206 100 84 169 0 1864593600 17051856 24022576
23:07:00 3617 8192000000 10773245040 11159306240 1830966304 18.267 100 87 174 1 1869053904 13655216 24432384
23:07:10 2434 8192000000 10772542304 11157028864 1832364608 18.279 100 90 174 2 1870762688 14065680 24332400
23:07:19 2253 8192000000 10778771264 11167756288 1838598944 18.329 100 90 181 2 1877231488 13627712 25004832
23:07:28 2390 8192000000 10786718336 11172884480 1842893136 18.364 100 84 168 1 1879981488 13777680 23310672
23:07:37 2536 8192000000 10787227840 11173195776 1848728752 18.412 100 88 174 1 1886959664 13582768 24648144
23:07:46 1437 8192000000 10788461712 11176140800 1844161664 18.375 100 82 164 0 1880029488 12670080 23197744
23:07:54 2072 8192000000 10793780320 11182235648 1850187440 18.424 100 82 164 2 1885858912 12284480 23386992
23:08:03 1627 8192000000 10794839392 11184128000 1856557824 18.475 100 86 173 0 1893417136 12113648 24745664
23:08:11 1298 8192000000 10795554768 11185197056 1853356720 18.449 100 91 182 0 1891902464 13018992 25526752
23:08:19 1960 8192000000 10800740640 11190247424 1856747952 18.477 100 86 170 2 1894209072 13909808 23551312
23:08:28 2988 8192000000 10804240752 11191382016 1857900048 18.486 100 84 170 0 1895708048 13865248 23942752
23:08:46 1274 8192000000 10808579376 11196616704 1860898912 18.511 100 90 180 1 1899893984 13568288 25426784
23:08:53 14093 8192000000 10784305392 11180879872 1853897120 18.454 100 50 101 0 1877795904 9726192 14172592
23:09:15 3475 8192000000 10775196256 11189932032 1856782576 18.477 100 48 94 2 1878902688 9334416 12785696
23:09:26 3008 8192000000 10780152336 11189137408 1856923840 18.478 100 53 105 1 1880542176 9509168 14109168
23:09:36 1657 8192000000 10791661040 11197517824 1861640736 18.517 100 61 123 1 1893831824 15417456 16773632
23:09:45 4704 8192000000 10788374832 11195584512 1860033728 18.504 100 46 92 0 1881850640 9033104 12783808
23:09:57 3531 8192000000 10775733104 11190312960 1861342384 18.514 100 33 67 4 1879069424 8459344 9267696
23:10:07 3028 8192000000 10776926240 11193946112 1862366512 18.522 100 39 76 1 1882223232 8640288 11216432
23:10:18 3866 8192000000 10782290800 11203518464 1871077856 18.593 100 44 88 2 1891494000 8430288 11985856
23:10:29 6714 8192000000 10776653728 11201667072 1871127920 18.593 100 31 62 0 1886794032 7236032 8430080
23:10:42 9653 8192000000 10786091360 11208409088 1874479088 18.621 100 18 35 1 1886745712 6120896 6145728
23:11:00 10546 8192000000 10777244672 11207176192 1872608256 18.605 100 16 32 0 1884412592 6749984 5054352
23:11:18 6628 8192000000 10796088704 11214925824 1878030672 18.649 100 33 64 1 1893745968 6215056 9500240
23:11:32 5168 8192000000 10808559328 11218685952 1884707424 18.703 100 51 103 0 1907232928 6776880 15748624
23:11:44 11361 8192000000 10782353216 11216056320 1883872624 18.696 100 29 56 6 1898902160 6300704 8728832
23:12:04 55605 8192000000 10831052448 11239739392 1885411776 18.709 100 32 66 1 1904328176 9621472 9294928
23:13:05 6001 8192000000 10813488784 11242983424 1890773824 18.752 100 43 86 0 1916275408 13800592 11700992
23:13:22 6263 8192000000 10805267888 11239366656 1890296640 18.748 100 34 67 1 1906728576 6524288 9907648
23:13:40 6506 8192000000 10813714240 11236544512 1888407648 18.733 100 22 44 0 1901014592 6175360 6431584
23:13:55 4192 8192000000 10805256768 11233611776 1890914992 18.753 100 29 58 1 1905961792 6439424 8607376
23:14:05 6417 8192000000 10816665312 11241066496 1893406032 18.773 100 27 54 1 1907716720 5682336 8628352
23:14:21 6837 8192000000 10809485936 11244843008 1899696832 18.824 100 25 49 1 1913386704 5779456 7910416
23:14:36 7391 8192000000 10808686624 11248488448 1902681712 18.848 100 26 53 1 1916144928 6467328 6995888
23:14:51 9182 8192000000 10816013472 11250298880 1900516128 18.830 100 28 56 0 1915414640 7174176 7724336
23:15:10 5487 8192000000 10820768320 11248750592 1899728272 18.824 100 23 47 2 1911633888 5274960 6630656
23:15:23 4029 8192000000 10821728720 11252736000 1907014576 18.883 100 29 58 0 1922263488 7104624 8144288
23:15:33 8748 8192000000 10800840256 11241431040 1885167424 18.707 99 20 39 0 1896346064 5367824 5810816
23:15:48 4700 8192000000 10811853696 11245670400 1903729488 18.856 100 32 64 2 1919326928 5194496 10402944
23:16:01 8089 8192000000 10813295072 11250196480 1897987872 18.810 100 22 43 2 1914293136 10704128 5601136
23:16:15 6291 8192000000 10817393904 11252396032 1904797568 18.865 100 21 42 3 1916006032 5256336 5952128
23:16:31 11853 8192000000 10819405904 11240005632 1860366784 18.506 98 11 20 0 1867818496 4530592 2921120
23:16:53 58113 8192000000 10740943152 11170066432 1801318368 18.025 95 33 66 1 1816461456 5646400 9496688
23:17:57 5818 8192000000 10795591776 11218423808 1873026288 18.609 100 30 59 4 1886758112 5213616 8518208
23:18:09 12098 8192000000 10800887408 11223855104 1858236112 18.489 99 23 44 2 1870543424 6227024 6080288
23:18:29 7509 8192000000 10779882880 11203911680 1804831264 18.054 96 17 34 0 1814983520 5120976 5031280
23:18:44 6991 8192000000 10776531296 11198779392 1843095744 18.366 99 23 46 0 1855696560 5343440 7257376
23:18:58 5488 8192000000 10723332080 11143651328 1769767472 17.765 97 26 52 1 1783256592 5774672 7714448
23:19:12 8785 8192000000 10741108752 11151413248 1769573680 17.763 97 25 49 1 1781519248 4918080 7027488
23:19:29 7612 8192000000 10703509344 11127353344 1745452592 17.564 95 22 44 1 1757314400 5585312 6276496
23:19:43 8643 8192000000 10720271056 11135447040 1718989888 17.344 94 23 46 3 1730942064 5061936 6890240
23:20:02 7902 8192000000 10700953248 11115028480 1728065024 17.419 96 18 36 0 1739088640 5395472 5628144
23:20:16 6856 8192000000 10702129840 11112693760 1740194336 17.520 97 33 67 0 1756711952 5790272 10727344
23:20:33 7963 8192000000 10702148144 11107713024 1756306032 17.654 98 29 58 1 1771367856 5908752 9153072
23:20:48 7108 8192000000 10694700480 11103301632 1729460864 17.431 96 26 52 1 1741940384 5039792 7439728
23:21:05 7177 8192000000 10689341344 11098923008 1765001568 17.726 100 33 66 1 1784852896 9622928 10228400
23:21:20 59176 8192000000 10711866048 11125305344 1763056880 17.710 98 26 51 1 1775479104 5531536 6890688
23:22:25 19230 8192000000 10721746496 11144069120 1777454304 17.829 98 18 36 1 1788420960 5912512 5054144
23:22:54 13605 8192000000 10741165872 11145568256 1750413888 17.605 96 24 48 3 1763190064 5210416 7565760
23:23:16 5161 8192000000 10736981136 11161522176 1821788800 18.192 100 26 52 2 1835866608 7054704 7023104
23:23:29 3823 8192000000 10748853344 11168272384 1831381136 18.271 100 34 68 1 1848092384 6945168 9766080
23:23:40 7995 8192000000 10757539360 11176988672 1834853952 18.299 100 29 59 0 1850088080 7054144 8179984
23:23:58 8698 8192000000 10754158736 11175890944 1836854496 18.315 100 38 76 1 1853944896 5048432 12041968
23:24:15 3984 8192000000 10772202976 11191214080 1851601040 18.435 100 42 85 1 1868946240 5446480 11898720
23:24:27 6035 8192000000 10768386688 11188555776 1833040752 18.284 99 38 74 2 1850722064 7152704 10528608
23:24:44 6491 8192000000 10778313920 11197251584 1849801392 18.421 100 35 70 1 1866257264 6602144 9853728
23:24:59 9548 8192000000 10767886128 11196837888 1855983712 18.471 100 19 38 1 1867187296 5479760 5723824
23:25:16 9241 8192000000 10782464464 11207405568 1860968032 18.511 100 17 34 1 1871200688 5143232 5089424
23:25:36 7737 8192000000 10780241168 11214036992 1866800480 18.558 100 14 28 2 1875037968 4914144 3323344
23:25:51 12283 8192000000 10779420480 11212881920 1869545344 18.581 100 17 34 2 1880155520 5362928 5247248
23:26:14 55428 8192000000 10787212384 11230216192 1879617232 18.662 100 39 78 0 1896356624 5808640 10930752
23:27:18 43666 8192000000 10824367024 11245699072 1899451504 18.822 100 34 68 3 1914740464 5245360 10043600
23:28:10 33641 8192000000 10854027904 11277819904 1920399376 18.990 100 42 84 2 1943977584 11537792 12040416
23:28:51 3685 8192000000 10868358560 11286863872 1928971184 19.059 100 60 117 2 1959257920 13886688 16400048
23:29:02 13148 8192000000 10866012736 11289419776 1931168128 19.076 100 51 97 4 1958577648 13423056 13986464
23:29:24 9963 8192000000 10874981136 11298181120 1938492032 19.135 100 59 118 0 1968181200 12659936 17029232
23:29:43 13358 8192000000 10866729968 11299311616 1941792272 19.161 100 49 96 3 1972799792 17804464 13203056
23:30:07 16760 8192000000 10899928784 11315691520 1951520256 19.239 100 56 112 0 1982326352 14905072 15901024
23:30:31 7320 8192000000 10895691488 11320836096 1958164288 19.291 100 66 132 1 1993414144 16243136 19006720
23:30:49 18297 8192000000 10907505040 11334778880 1957278064 19.284 100 51 102 0 1988325552 16683904 14363584
23:31:25 11718 8192000000 10904592048 11335868416 1967175904 19.363 100 56 112 1 2004820144 21574560 16069680
23:31:47 23307 8192000000 10911540896 11346456576 1968970928 19.377 100 49 98 0 2002258256 18700128 14587200
23:32:18 18784 8192000000 10925798480 11356114944 1977266240 19.443 100 42 84 0 2010619200 21008032 12344928
23:32:48 15731 8192000000 10918273344 11355930624 1980829664 19.471 100 48 92 1 2014548656 20690848 13028144
23:33:12 16877 8192000000 10921027712 11357782016 1982668496 19.486 100 36 72 3 2014475664 21060144 10747024
23:33:48 10736 8192000000 10932189936 11370319872 1991410272 19.555 100 40 80 1 2025710704 22054272 12246160
23:34:08 25488 8192000000 10940588768 11373522944 1989808848 19.542 100 51 100 0 2030553968 25635792 15109328
23:34:42 17498 8192000000 10942172768 11379830784 1993657328 19.573 100 46 92 2 2032240928 24838880 13744720
23:35:13 8797 8192000000 10964063984 11392110592 2006029232 19.670 100 59 118 0 2050461392 25950496 18481664
23:35:35 20265 8192000000 10973445568 11405500416 2016174544 19.750 100 53 106 1 2060699856 28304864 16220448
23:36:06 5013 8192000000 10965629152 11399462912 2012769600 19.723 100 59 117 2 2058576320 27812096 17994624
23:36:19 4474 8192000000 10979214000 11409014784 2021024336 19.788 100 67 135 1 2069505424 28271936 20209152
23:36:32 6863 8192000000 10988491984 11417468928 2025832896 19.826 100 70 138 0 2076593808 29774320 20986592
23:36:46 2839 8192000000 10992541360 11419709440 2026377744 19.830 100 71 142 1 2080266720 32146544 21742432
23:36:56 7418 8192000000 10992465344 11419246592 2027156880 19.836 100 67 131 2 2078669360 31710432 19802048
23:37:15 1469 8192000000 10990948624 11417415680 2023832528 19.810 100 81 162 0 2081470784 32349984 25288272
23:37:24 3020 8192000000 10988740832 11412213760 2021377712 19.791 100 82 163 0 2079021968 33067328 24576928
23:37:37 4986 8192000000 10990744256 11420155904 2023304816 19.806 100 72 144 0 2082759504 38077200 21377488
23:37:49 7361 8192000000 10968972336 11392532480 2003047952 19.647 99 75 150 1 2059922544 33864432 23010160
23:38:09 10904 8192000000 10975494608 11410939904 2011510432 19.713 100 63 127 1 2065891152 35052400 19328320
23:38:35 7674 8192000000 10984233232 11421466624 2017435088 19.760 100 59 118 1 2074311632 38609440 18267104
23:38:52 2656 8192000000 10996831664 11428802560 2026965232 19.835 100 73 145 1 2088937184 39101408 22870544
23:39:01 3507 8192000000 11016255808 11433635840 2028865024 19.850 100 88 176 1 2098299216 41437264 27996928
23:39:12 4940 8192000000 11002440560 11429867520 2026672896 19.833 100 74 148 3 2091674016 41677024 23324096
23:39:30 4781 8192000000 11005297104 11425923072 2019984512 19.780 100 78 156 0 2086100816 42105488 24010816
23:39:43 3543 8192000000 11003203168 11421114368 2006222880 19.672 99 83 166 2 2074176992 42300528 25653584
23:39:54 2374 8192000000 10991089856 11421343744 2015263104 19.743 100 68 136 2 2079056224 42829200 20963920
23:40:03 1366 8192000000 11012384736 11428327424 2027036672 19.835 100 82 163 0 2091373424 39730720 24606032
23:40:12 2746 8192000000 11001869184 11426050048 2025849024 19.826 100 76 152 0 2089268176 38776624 24642528
23:40:22 3276 8192000000 10995456976 11419598848 2015658416 19.746 100 83 164 2 2083091568 41369120 26064032
23:40:34 3401 8192000000 11001893296 11425099776 2015551776 19.745 100 84 169 2 2083506224 42279664 25674784
23:40:45 1647 8192000000 11012745776 11429421056 2022223168 19.798 100 90 180 1 2092880016 43374176 27282672
23:40:53 5763 8192000000 10996688880 11420930048 2010791664 19.708 100 75 150 0 2079204672 45217184 23195824
23:41:08 3718 8192000000 10980960768 11403497472 1999886032 19.622 99 88 176 2 2066270816 38838384 27546400
23:41:20 6776 8192000000 10980928048 11407699968 2006848640 19.677 100 67 134 3 2067641744 39812976 20980128
23:41:37 3258 8192000000 10988565344 11411623936 2005551104 19.666 100 70 138 1 2069122432 41496672 22074656
23:42:00 5068 8192000000 10984814176 11412459520 2004212800 19.656 100 67 134 1 2068104016 42973664 20917552
23:42:14 4848 8192000000 10990222944 11414982656 2005553248 19.667 100 77 151 3 2073178864 43337408 24288208
23:42:31 4511 8192000000 10995097840 11421683712 1993635280 19.573 99 73 147 1 2063168576 46795184 22738112
23:42:45 2374 8192000000 11014458688 11438247936 2017332096 19.759 100 88 172 0 2097441712 53711648 26397968
23:42:55 4711 8192000000 11005580720 11429519360 2012475744 19.721 100 87 171 3 2089322816 50800384 26046688
23:43:08 1239 8192000000 11021538432 11437441024 2017498016 19.760 100 91 182 1 2097541408 51428736 28614656
23:43:16 2232 8192000000 10997163312 11418071040 2002399760 19.642 100 87 173 2 2082198368 53107664 26690944
23:43:26 2338 8192000000 10994171376 11417370624 2003958832 19.654 100 80 158 1 2078002848 49514192 24529824
23:43:35 2963 8192000000 10990917008 11411931136 2001572528 19.635 100 83 166 0 2069789760 43131824 25085408
23:43:45 3741 8192000000 10968229600 11401048064 1989670576 19.541 100 68 136 1 2053802848 42961680 21170592
23:44:01 6764 8192000000 10956206992 11396075520 1976148976 19.434 99 55 110 1 2033345056 39597264 17598816
23:44:22 12530 8192000000 10959691408 11404816384 1992115552 19.561 100 45 90 0 2046388112 40236048 14036512
23:44:41 5411 8192000000 10973231472 11411513344 1999680848 19.620 100 54 108 2 2056727088 40268400 16777840
23:44:57 9107 8192000000 10981206944 11407609856 1996336752 19.594 100 64 128 0 2061767840 45123120 20307968
23:45:12 3579 8192000000 10989153104 11415588864 2000864256 19.630 100 78 156 2 2073703696 48357136 24482304
23:45:28 11698 8192000000 10964640496 11420651520 1998052096 19.607 100 36 72 2 2058425616 47990784 12382736
23:45:51 8091 8192000000 10964807360 11407921152 1995074848 19.584 100 48 96 0 2053317536 42588272 15654416
23:46:07 18248 8192000000 10950784048 11392163840 1965272416 19.348 99 31 62 0 2019558816 42816064 11470336
23:46:41 2033 8192000000 10951067776 11369353216 1947738848 19.208 99 79 155 3 2018268016 46461664 24067504
23:46:51 2813 8192000000 10968040224 11391025152 1974994288 19.425 100 79 156 1 2049574000 48884592 25695120
23:47:02 6929 8192000000 10952376240 11387883520 1971040736 19.394 100 59 117 0 2039593008 49506448 19045824
23:47:18 31229 8192000000 10931399424 11380613120 1937369184 19.126 98 28 56 0 1993195152 46540912 9285056
23:48:03 11990 8192000000 10920845760 11372027904 1942084128 19.163 99 27 54 1 1994521824 43023184 9414512
23:48:22 18272 8192000000 10903264272 11349442560 1916430896 18.958 98 23 46 0 1968805200 44966240 7408064
23:48:54 17393 8192000000 10914810256 11355619328 1929387968 19.062 99 24 48 0 1991064816 53153072 8523776
23:49:18 11655 8192000000 10933485360 11382923264 1952467120 19.246 100 43 86 1 2022132576 54151200 15514256
23:49:41 6706 8192000000 10943724320 11390373888 1950284800 19.229 99 55 110 1 2023398112 55594544 17518768
23:50:06 16551 8192000000 10934934816 11395780608 1964830432 19.344 100 26 52 1 2026181104 51871984 9478688
23:51:04 28630 8192000000 10893655888 11351953408 1897245776 18.804 97 11 22 1 1939071520 37890960 3934784
23:51:40 38903 8192000000 10904150832 11365490688 1945433376 19.190 100 22 44 0 1983104704 30106096 7565232
23:52:25 31999 8192000000 10895375312 11363098624 1946932496 19.202 100 24 48 3 1984289904 29693808 7663600
23:53:08 51249 8192000000 10855744256 11337093120 1918391840 18.974 99 10 21 1 1943073184 21873392 2807952
23:54:14 74997 8192000000 10846100304 11284332544 1774689200 17.806 92 11 22 0 1785581616 7835904 3056512
23:55:42 66140 8192000000 10834968400 11276988416 1819492944 18.174 95 24 48 1 1836651216 11127616 6030656
23:57:09 108484 8192000000 10840741552 11297792000 1810120960 18.097 94 17 34 1 1822465456 8190256 4154240
23:59:04 32482 8192000000 10841414912 11291074560 1853853712 18.453 96 12 24 2 1863972576 6714096 3404768
23:59:44 85431 8192000000 10858270848 11308744704 1828246528 18.245 95 11 22 2 1842541600 11707872 2587200
00:01:15 110502 8192000000 10863541520 11321044992 1829805744 18.258 95 10 20 1 1847921168 15086992 3028432
00:03:15 59804 8192000000 10873173168 11344941056 1939874144 19.146 100 18 36 0 1960845456 15367200 5604112
00:04:21 36010 8192000000 10906329168 11340185600 1956382432 19.277 100 37 75 2 1974182064 7010640 10788992
00:05:06 13057 8192000000 10877413088 11327471616 1947192128 19.204 100 35 70 1 1966847888 9883600 9772160
00:05:27 29117 8192000000 10894757200 11343425536 1947347936 19.205 100 17 35 1 1964691776 11981040 5362800
00:06:03 105826 8192000000 10902867696 11353546752 1938063664 19.131 99 37 73 0 1956882880 8130608 10688608
00:07:58 90971 8192000000 10883796128 11362955264 1938805904 19.137 99 31 60 1 1961553728 14229824 8518000
00:09:35 34660 8192000000 10892678096 11369910272 1956652192 19.279 100 6 12 0 1975371072 17072352 1646528
00:10:18 11039 8192000000 10903090240 11365466112 1973352128 19.412 100 47 92 2 1997012976 9955616 13705232
00:10:36 23416 8192000000 10909960048 11381649408 1979553856 19.461 100 24 48 0 1997548576 11152784 6841936
00:11:05 21163 8192000000 10939175488 11385958400 1988094144 19.529 100 36 68 5 2009338896 11159952 10084800
00:11:33 66546 8192000000 10935163584 11403075584 1996495392 19.595 100 41 81 2 2022579760 14011424 12072944
00:13:43 34222 8192000000 10927030704 11403055104 1988953856 19.536 100 20 40 0 2012736192 17369296 6413040
00:15:01 52131 8192000000 10893210064 11369369600 1956426672 19.278 98 13 26 0 1968294704 8020544 3847488
00:16:45 64758 8192000000 10919912176 11396595712 1990086128 19.544 100 16 32 1 2008280384 13419248 4775008
00:18:00 39659 8192000000 10930551040 11388923904 1975961952 19.433 99 36 72 0 2003270352 16635872 10672528
00:18:47 36388 8192000000 10911808064 11408773120 1987313328 19.523 100 14 28 1 2005205056 13925552 3966176
00:19:32 44598 8192000000 10917756960 11405168640 1987545392 19.524 100 5 10 0 2001773408 13031440 1196576
00:20:27 21612 8192000000 10922024768 11395219456 1996455904 19.595 100 29 58 1 2016140992 11431184 8253904
00:20:55 42364 8192000000 10909137600 11386646528 1954668512 19.264 98 22 43 3 1970899520 10308544 5922464
00:21:51 47983 8192000000 10925719136 11387371520 1948514864 19.215 98 30 60 2 1971003392 13858928 8629600
00:22:46 40483 8192000000 10906456064 11384205312 1947706672 19.208 98 36 71 3 1976131968 17988896 10436400
00:24:14 66479 8192000000 10873042736 11353616384 1847807664 18.404 94 12 24 0 1874003216 22485040 3710512
00:25:29 45676 8192000000 10907135824 11362672640 1931773600 19.081 99 18 35 0 1949123264 11682416 5667248
00:26:21 59490 8192000000 10872976896 11332657152 1884365072 18.700 96 21 42 0 1904711792 14525504 5821216
00:27:35 33297 8192000000 10862735040 11322826752 1884929088 18.705 97 17 32 1 1905211584 16161440 4121056
00:28:18 56584 8192000000 10856177472 11318611968 1840770528 18.347 95 21 42 0 1858329936 11471424 6087984
00:29:24 94812 8192000000 10883345712 11342499840 1875771360 18.631 97 8 16 0 1887858624 10227904 1859360
00:31:05 39219 8192000000 10889782832 11349245952 1905955456 18.874 98 19 38 0 1928596320 16192544 6448320
00:31:50 42076 8192000000 10893753792 11372158976 1937963648 19.131 100 12 24 1 1963003456 21872048 3167760
00:32:38 109083 8192000000 10888375360 11350605824 1904981552 18.866 98 7 14 0 1929674032 22489872 2202608
00:35:04 55934 8192000000 10857998752 11315355648 1837678608 18.322 95 31 62 1 1859085088 11969968 9436512
00:36:06 16348 8192000000 10847157024 11306262528 1884814352 18.704 98 41 80 0 1912367552 15422448 12130752
00:36:32 25420 8192000000 10823077584 11292897280 1853580752 18.451 97 32 64 1 1875307952 13016816 8710384
00:37:05 30837 8192000000 10812697600 11291480064 1880539568 18.669 99 9 18 0 1896799552 13556448 2703536
00:37:49 50572 8192000000 10837395632 11316715520 1914897616 18.946 100 7 14 1 1924600992 7642384 2060992
00:38:49 69209 8192000000 10839353264 11307814912 1870853424 18.591 97 12 23 0 1883954864 8696592 4404848
00:40:06 86325 8192000000 10843306000 11318902784 1900456240 18.830 99 27 54 1 1919839408 10397840 8985328
00:41:52 61110 8192000000 10855651744 11337441280 1912584400 18.927 99 21 42 1 1938733600 19425024 6724176
00:43:08 65903 8192000000 10850076464 11319185408 1874130784 18.618 97 20 40 0 1895709296 15606448 5972064
00:44:20 57756 8192000000 10855270576 11325857792 1890468720 18.750 98 25 50 1 1915971664 17549024 7953920
00:45:30 85520 8192000000 10845750016 11324436480 1887359136 18.724 98 14 28 1 1903443328 11997760 4086432
00:47:04 34129 8192000000 10859653424 11316412416 1877807984 18.647 98 29 59 0 1895307216 9380880 8118352
00:47:47 27918 8192000000 10854771952 11305627648 1882958224 18.689 98 48 96 0 1907169264 10224496 13986544
00:48:23 77056 8192000000 10847763664 11327115264 1875118160 18.626 98 24 48 0 1894389776 12697504 6574112
00:49:47 75839 8192000000 10854031232 11319693312 1872020128 18.601 97 26 51 3 1897019216 17700544 7298544
00:51:21 40871 8192000000 10879565824 11332841472 1890431552 18.749 98 31 62 2 1913556080 14275376 8849152
00:52:08 21525 8192000000 10884247776 11326812160 1923048432 19.011 100 37 74 3 1951786784 18165568 10572784
00:53:52 63577 8192000000 10869611616 11329277952 1900341248 18.829 98 25 50 3 1918154208 11283296 6529664
00:55:06 22978 8192000000 10876519264 11324739584 1916702816 18.960 99 42 83 2 1937193824 9502304 10988704
00:55:42 121662 8192000000 10859130736 11330756608 1918030400 18.971 99 35 70 2 1938573984 10342240 10201344
00:57:51 41386 8192000000 10859166816 11334815744 1939356752 19.142 100 20 40 1 1952789280 7961984 5470544
00:58:38 44018 8192000000 10860812416 11336867840 1931419984 19.078 99 9 17 0 1940722384 7176080 2126320
00:59:28 21510 8192000000 10856229424 11338952704 1942037472 19.163 100 4 8 0 1951599648 8647936 914240
00:59:58 17996 8192000000 10864317936 11344433152 1939662288 19.144 100 6 12 1 1948261888 7271568 1328032
01:00:23 14254 8192000000 10868760880 11349671936 1946558352 19.199 100 7 13 1 1957012144 9025648 1428144
01:00:49 23023 8192000000 10886581536 11367309312 1958707552 19.296 100 7 14 0 1972391456 11925952 1757952
01:01:30 28834 8192000000 10909958192 11379404800 1969696832 19.383 100 16 32 2 1988371264 14223216 4451216
01:02:05 85496 8192000000 10919118928 11412508672 1965332704 19.348 99 17 34 2 1985386992 15032992 5021296
01:03:37 38977 8192000000 10925936288 11397971968 1974677664 19.423 99 15 30 1 1986620992 7783232 4160096
01:04:22 31512 8192000000 10914708544 11390730240 1986242160 19.514 100 22 44 0 2002945984 10341968 6361856
01:05:43 75668 8192000000 10926701552 11397976064 1965541312 19.350 99 9 18 0 1980040496 11868384 2630800
01:07:16 48560 8192000000 10941844288 11406237696 1978630224 19.454 99 31 62 1 2003844560 16660144 8554192
01:08:36 85398 8192000000 10913680112 11390980096 1930723328 19.073 97 31 62 1 1958443680 18768864 8951488
01:10:07 63865 8192000000 10892393408 11362668544 1884943008 18.705 95 17 34 1 1897809536 8701536 4164992
01:11:17 40111 8192000000 10933939728 11377590272 1942690656 19.168 99 41 80 1 1963078784 9255792 11132336
01:12:05 26568 8192000000 10912224160 11365847040 1931379168 19.078 98 43 86 1 1956332640 13508784 11444688
01:12:38 75226 8192000000 10887879344 11353714688 1878080336 18.650 96 28 56 1 1903142688 17442336 7620016
01:14:05 69386 8192000000 10876627296 11345047552 1891576256 18.758 97 21 42 2 1914259152 16419264 6263632
01:15:26 27642 8192000000 10899109136 11337854976 1910694816 18.912 98 27 55 0 1927039136 8807136 7537184
01:16:00 36155 8192000000 10874787680 11340541952 1906340016 18.877 98 29 58 0 1923377056 9329056 7707984
01:17:16 64585 8192000000 10885768528 11356160000 1952698688 19.248 100 27 54 1 1966989504 7262384 7028432
01:18:35 76236 8192000000 10889231088 11377369088 1962443600 19.325 100 13 26 2 1984500320 17997584 4059136
01:19:58 3594 8192000000 10885840592 11379466240 1961518016 19.318 100 3 6 0 1977641200 15352576 770608
01:21:32 58961 8192000000 10879509536 11358466048 1953107776 19.251 100 10 20 1 1972894240 16514352 3272112
01:22:37 77332 8192000000 10895678816 11374374912 1950736864 19.232 99 24 48 0 1969810912 11710768 7363280
01:24:02 119085 8192000000 10878082224 11355467776 1897510896 18.806 97 9 18 0 1912772144 12520704 2740544
01:26:13 63605 8192000000 9346108176 9629093888 500060064 5.753 26 4 8 0 504341392 3301584 979744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 19-01-2021 01:28:44 to 19-01-2021 01:29:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 103 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-01-2021 01:29:16 to 19-01-2021 01:29:18.

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          240138
MON$OLDEST_ACTIVE               240139
MON$OLDEST_SNAPSHOT             240139
MON$NEXT_TRANSACTION            240139
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                       2041824
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:41: 
:42: mscs-test-161.budzdorov.ru    Tue Jan 19 01:27:19 2021
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:44: 
:45: 
:46: mscs-test-161.budzdorov.ru    Tue Jan 19 01:27:19 2021
:47:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:48: 
--- end of diff output ---

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

19.01.21 01:29:19. 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-01-19 01:29:22 No severe PSQL-related problems occured
19.01.21 01:29:23. End of report.