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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17104596 kB
MemAvailable 31387484 kB
Buffers 0 kB
Cached 14545736 kB
SwapCached 3828 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 2020-11-17 01:26:59
DTS_END                         2020-11-17 01:26:59.9900
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_MAKE_INVNT_SALDO(40:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58342
TRN_ID                          253475
ATT_ID                          715
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: 9559.86 18502 1147183
customer order: creation 185.33 343 22239
customer order: refuse 15.57 333 1868
order to supplier: creation 47.68 1323 5721
order to supplier: removal 3.51 92632 421
invoice (draft): creation 49.24 3264 5909
invoice (draft): removal 52.86 759 6343
invoice accept: apply 44.38 15699 5326
invoice accept: cancel 48.19 855 5783
customer reserve: creation 4046.33 157 485560
customer reserve: removal 4755.31 54 570637
realization accept: apply 89.33 161 10720
realization accept: cancel 84.20 104 10104
payment from customer: creation 63.73 109 7647
payment from customer: removal 6.13 66 735
payment to supplier: creation 51.85 118 6222
payment to supplier: removal 3.71 47 445
service: total inventory turnovers 4.68 956 561
service: total monetary turnovers 7.04 38 845
service: aggregate perf. data 0.78 23589 93
service: refresh index statistics 0.03 229425 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 17-11-2020 01:27:49 to 17-11-2020 01:27:52.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 831
TEST_TIME 2 1412
TEST_TIME 3 2989
TEST_TIME 4 3117
TEST_TIME 5 4407
TEST_TIME 6 5026
TEST_TIME 7 5012
TEST_TIME 8 5035
TEST_TIME 9 5629
TEST_TIME 10 5589
TEST_TIME 11 5568
TEST_TIME 12 5794
TEST_TIME 13 5834
TEST_TIME 14 5908
TEST_TIME 15 6257
TEST_TIME 16 6530
TEST_TIME 17 7059
TEST_TIME 18 7677
TEST_TIME 19 7534
TEST_TIME 20 7754
TEST_TIME 21 8046
TEST_TIME 22 8144
TEST_TIME 23 8342
TEST_TIME 24 8674
TEST_TIME 25 9167
TEST_TIME 26 9486
TEST_TIME 27 9469
TEST_TIME 28 9625
TEST_TIME 29 9909
TEST_TIME 30 9879
TEST_TIME 31 10225
TEST_TIME 32 10164
TEST_TIME 33 10015
TEST_TIME 34 10088
TEST_TIME 35 9987
TEST_TIME 36 9969
TEST_TIME 37 9920
TEST_TIME 38 9789
TEST_TIME 39 9892
TEST_TIME 40 9995
TEST_TIME 41 9998
TEST_TIME 42 9988
TEST_TIME 43 9916
TEST_TIME 44 9742
TEST_TIME 45 9645
TEST_TIME 46 9774
TEST_TIME 47 9627
TEST_TIME 48 9588
TEST_TIME 49 9477
TEST_TIME 50 9434
TEST_TIME 51 9471
TEST_TIME 52 9597
TEST_TIME 53 9518
TEST_TIME 54 9472
TEST_TIME 55 9440
TEST_TIME 56 9498
TEST_TIME 57 9434
TEST_TIME 58 9473
TEST_TIME 59 9522
TEST_TIME 60 9471
TEST_TIME 61 9546
TEST_TIME 62 9529
TEST_TIME 63 9592
TEST_TIME 64 9672
TEST_TIME 65 9663
TEST_TIME 66 9691
TEST_TIME 67 9669
TEST_TIME 68 9712
TEST_TIME 69 9700
TEST_TIME 70 9843
TEST_TIME 71 9802
TEST_TIME 72 9678
TEST_TIME 73 9658
TEST_TIME 74 9630
TEST_TIME 75 9653
TEST_TIME 76 9612
TEST_TIME 77 9607
TEST_TIME 78 9579
TEST_TIME 79 9589
TEST_TIME 80 9532
TEST_TIME 81 9516
TEST_TIME 82 9438
TEST_TIME 83 9485
TEST_TIME 84 9488
TEST_TIME 85 9477
TEST_TIME 86 9473
TEST_TIME 87 9436
TEST_TIME 88 9480
TEST_TIME 89 9520
TEST_TIME 90 9524
TEST_TIME 91 9580
TEST_TIME 92 9555
TEST_TIME 93 9541
TEST_TIME 94 9577
TEST_TIME 95 9619
TEST_TIME 96 9573
TEST_TIME 97 9670
TEST_TIME 98 9671
TEST_TIME 99 9693
TEST_TIME 100 9711
TEST_TIME 101 9639
TEST_TIME 102 9597
TEST_TIME 103 9589
TEST_TIME 104 9569
TEST_TIME 105 9548
TEST_TIME 106 9561
TEST_TIME 107 9518
TEST_TIME 108 9476
TEST_TIME 109 9459
TEST_TIME 110 9503
TEST_TIME 111 9469
TEST_TIME 112 9462
TEST_TIME 113 9452
TEST_TIME 114 9521
TEST_TIME 115 9532
TEST_TIME 116 9512
TEST_TIME 117 9494
TEST_TIME 118 9572
TEST_TIME 119 9578
TEST_TIME 120 9560

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-11-2020 01:27:53 to 17-11-2020 01:27:56.

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 1597612 1597612 0 0.00 0 21586 6 0 0
doc_list_biud 1597612 1597612 0 0.00 0 63324 25 0 0
sp_add_invoice_to_stock 5419 5326 93 1.71 35 157964 15699 0 93
sp_cancel_adding_invoice 5783 5783 0 0.00 6 92338 856 0 0
sp_cancel_client_order 1868 1868 0 0.00 4 10949 334 0 0
sp_cancel_customer_reserve 570637 570637 0 0.00 1 63325 55 0 0
sp_cancel_pay_from_customer 735 735 0 0.00 3 6090 66 0 0
sp_cancel_pay_to_supplier 445 445 0 0.00 2 1569 48 0 0
sp_cancel_supplier_invoice 6350 6343 7 0.11 1 22407 760 0 7
sp_cancel_supplier_order 421 421 0 0.00 5 908763 92632 0 0
sp_cancel_write_off 10104 10104 0 0.00 1 13468 105 0 0
sp_client_order 22239 22239 0 0.00 3 25291 344 0 0
sp_customer_reserve 485560 485560 0 0.00 0 101605 158 0 0
sp_fill_shopping_cart 33862 33862 0 0.00 1 10592 35 0 0
sp_fill_shopping_cart_clo_res 485556 485556 0 0.00 0 10077 12 0 0
sp_get_clo_for_invoice 5322 5322 0 0.00 0 24878 243 0 0
sp_kill_cost_storno 17067 17067 0 0.00 0 21575 50 0 0
sp_kill_qstorno_ret_qs2qd 1158142 1158142 0 0.00 0 63321 30 0 0
sp_kill_qty_storno 611198 611198 0 0.00 0 63323 65 0 0
sp_lock_selected_doc 22217 22217 0 0.00 0 6558 5 0 0
sp_make_cost_storno 29911 29911 0 0.00 0 17157 47 0 0
sp_multiply_rows_for_pdistr 29911 29911 0 0.00 0 9500 25 0 0
sp_multiply_rows_for_qdistr 22239 22239 0 0.00 0 20071 143 0 0
sp_pay_from_customer 7647 7647 0 0.00 4 20601 110 0 0
sp_pay_to_supplier 6222 6222 0 0.00 5 20761 118 0 0
sp_payment_common 13869 13869 0 0.00 1 17747 21 0 0
sp_qd_handle_on_cancel_clo 1868 1868 0 0.00 0 10941 303 0 0
sp_qd_handle_on_invoice_upd_sts 11105 11105 0 0.00 0 27956 319 0 0
sp_qd_handle_on_reserve_upd_sts 10720 10720 0 0.00 0 17580 59 0 0
sp_reserve_write_off 10720 10720 0 0.00 5 17607 161 0 0
sp_supplier_invoice 5909 5909 0 0.00 6 70262 3264 0 0
sp_supplier_order 5721 5721 0 0.00 5 35711 1323 0 0
srv_aggregate_perf_data 93 93 0 0.00 3337 263781 23590 0 0
srv_fill_mon_cache_memory 153 153 0 0.00 1013 161960 33967 0 0
srv_find_qd_qs_mism 1096886 1096886 0 0.00 0 20991 5 0 0
srv_make_invnt_saldo 561 561 0 0.00 28 58223 956 0 0
srv_make_money_saldo 845 845 0 0.00 0 3304 38 0 0
srv_recalc_idx_stat 4 4 0 0.00 109987 317201 229425 0 0
t$perf-abend:sp_add_invoice_to_stock 93 93 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 5326 5326 0 0.00 0 11951 140 0 0
t$perf-norm:sp_cancel_adding_invoice 462 462 0 0.00 1 3613 95 0 0
t$perf-norm:sp_cancel_client_order 1868 1868 0 0.00 0 3216 15 0 0
t$perf-norm:sp_cancel_customer_reserve 730 730 0 0.00 0 2448 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 735 735 0 0.00 0 2891 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 445 445 0 0.00 0 137 1 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 1152 16 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 26027 1748 0 0
t$perf-norm:sp_cancel_write_off 1115 1115 0 0.00 0 2267 7 0 0
t$perf-norm:sp_client_order 22239 22239 0 0.00 0 10127 16 0 0
t$perf-norm:sp_customer_reserve 1081 1081 0 0.00 0 3069 10 0 0
t$perf-norm:sp_pay_from_customer 7647 7647 0 0.00 0 3924 8 0 0
t$perf-norm:sp_pay_to_supplier 6222 6222 0 0.00 0 3692 8 0 0
t$perf-norm:sp_reserve_write_off 10720 10720 0 0.00 0 6075 10 0 0
t$perf-norm:sp_supplier_invoice 5909 5909 0 0.00 0 6626 22 0 0
t$perf-norm:sp_supplier_order 5721 5721 0 0.00 0 10710 20 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 296 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 241 6 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 5482 33 0 0
t$perf-norm:srv_make_money_saldo 845 845 0 0.00 0 892 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 9 4 0 0
v_add_invoice_to_stock 10830 10644 186 1.71 0 4909 18 0 186
v_all_customers 40740 40740 0 0.00 0 319 1 0 0
v_all_suppliers 32228 32228 0 0.00 0 18 1 0 0
v_all_wares 44478 44478 0 0.00 0 66 1 0 0
v_cancel_adding_invoice 924 924 0 0.00 0 1525 9 0 0
v_cancel_client_order 3736 3736 0 0.00 0 4428 5 0 0
v_cancel_customer_prepayment 1470 1470 0 0.00 0 481 2 0 0
v_cancel_customer_reserve 1460 1460 0 0.00 0 4095 6 0 0
v_cancel_payment_to_supplier 890 890 0 0.00 0 852 4 0 0
v_cancel_supplier_invoice 812 798 14 1.72 0 677 12 0 14
v_cancel_supplier_order 842 842 0 0.00 0 1366 6 0 0
v_cancel_write_off 2230 2230 0 0.00 0 8753 20 0 0
v_max_id_clo_ord 5718 5718 0 0.00 0 640 1 0 0
v_max_id_clo_res 1081 1081 0 0.00 0 5289 21 0 0
v_max_id_ord_sup 5905 5905 0 0.00 0 4893 6 0 0
v_max_non_paid_invoice 1731 1731 0 0.00 0 264 3 0 0
v_max_non_paid_realizn 4067 4067 0 0.00 0 565 3 0 0
v_min_id_clo_ord 5718 5718 0 0.00 0 5814 9 0 0
v_min_id_clo_res 1081 1081 0 0.00 0 6069 21 0 0
v_min_id_ord_sup 5905 5905 0 0.00 0 4915 5 0 0
v_min_non_paid_invoice 6222 6222 0 0.00 0 17743 16 0 0
v_min_non_paid_realizn 7647 7647 0 0.00 0 4054 11 0 0
v_our_firm 10898 10898 0 0.00 0 13 1 0 0
v_reserve_write_off 21440 21440 0 0.00 0 5082 5 0 0
x_lock_depdocs_on_canc_invoice 11727 11727 0 0.00 0 13601 104 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 10242 310 0 0
x_make_qstorno_1000_1200 5721 5721 0 0.00 2 35670 1249 0 0
x_make_qstorno_1200_2000 5909 5909 0 0.00 3 70254 3133 0 0
x_make_qstorno_2100_3300 485560 485560 0 0.00 0 101602 144 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-11-2020 01:27:57 to 17-11-2020 01:28:01.

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:03 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:09 7812 8192000000 10161886096 10458562560 877462560 9.674 70 56 112 0 898677296 2349344 18865392
22:57:27 33919 8192000000 10348121008 10663989248 1383523104 14.448 100 82 165 0 1414255680 4563024 26169552
22:58:10 37775 8192000000 10377554944 10701979648 1420521168 14.777 100 89 178 0 1456596528 6698496 29376864
22:58:59 16854 8192000000 10397228816 10723901440 1449952688 15.037 100 91 182 0 1487622992 7606896 30063408
22:59:30 14404 8192000000 10422910496 10754121728 1479563072 15.298 100 89 178 0 1516758320 8396224 28799024
22:59:54 21391 8192000000 10450022480 10783535104 1500762224 15.483 100 92 184 1 1539200448 9218896 29219328
23:00:25 20867 8192000000 10456353888 10796011520 1511830688 15.579 100 87 174 2 1548835104 9546896 27457520
23:00:54 17413 8192000000 10470851168 10815041536 1527667408 15.717 100 78 157 0 1561581328 9028576 24885344
23:01:22 18460 8192000000 10489422304 10839535616 1552171808 15.929 100 78 154 1 1585877664 9473104 24232752
23:01:49 21377 8192000000 10527895344 10880577536 1571844816 16.098 100 77 154 0 1604553264 9146016 23562432
23:02:18 10451 8192000000 10541356336 10899697664 1606434128 16.394 100 81 162 2 1640593648 9858736 24300784
23:02:36 11544 8192000000 10556076816 10916155392 1616127984 16.477 100 71 142 1 1647081488 9871536 21081968
23:02:56 11393 8192000000 10568497824 10928893952 1634114592 16.630 100 83 166 0 1669635200 10976432 24544176
23:03:17 12337 8192000000 10594353344 10956464128 1654971072 16.806 100 83 165 3 1691272208 11528112 24773024
23:03:36 7650 8192000000 10603288672 10971111424 1668462848 16.920 100 76 152 1 1702164928 11402272 22299808
23:03:54 7826 8192000000 10631099392 10998300672 1694749104 17.141 100 81 161 2 1729822240 11917440 23155696
23:04:10 7874 8192000000 10640484560 11008704512 1703417488 17.214 100 78 156 0 1737775152 12014864 22342800
23:04:25 7423 8192000000 10671731504 11044610048 1725311392 17.396 100 83 166 0 1762114560 12639568 24163600
23:04:40 8451 8192000000 10664224576 11047235584 1738720064 17.508 100 76 152 0 1773384128 13057744 21606320
23:04:55 5300 8192000000 10689365120 11065769984 1755276224 17.645 100 79 158 1 1789408432 11955776 22176432
23:05:09 5198 8192000000 10694242688 11076911104 1765438576 17.729 100 77 154 1 1798721936 11850480 21432880
23:05:21 2867 8192000000 10715372992 11093164032 1777159792 17.826 100 78 155 1 1810373168 12182048 21031328
23:05:31 3517 8192000000 10725305248 11102806016 1784329712 17.885 100 83 160 1 1820057920 13105088 22623120
23:05:41 2486 8192000000 10733808512 11112738816 1792095808 17.949 100 88 176 1 1830543056 14039136 24408112
23:05:50 1956 8192000000 10738371456 11117252608 1795825088 17.980 100 89 179 0 1833911712 13301232 24785392
23:06:00 2937 8192000000 10745286960 11128561664 1801137888 18.023 100 90 179 4 1839449680 13243872 25067920
23:06:09 6098 8192000000 10748384512 11130281984 1807432608 18.075 100 83 167 1 1844283616 13953664 22897344
23:06:23 5945 8192000000 10756953264 11145449472 1815823088 18.144 100 83 164 2 1852239680 14002976 22413616
23:06:35 2325 8192000000 10769806848 11156979712 1832843568 18.283 100 88 177 1 1872320000 14697264 24779168
23:06:44 2044 8192000000 10777415760 11163144192 1837114064 18.317 100 96 196 0 1878608912 15021680 26473168
23:06:52 1697 8192000000 10792407648 11175960576 1840138192 18.342 100 87 176 0 1880136336 14447664 25550480
23:07:00 1308 8192000000 10788639568 11176914944 1853956112 18.454 100 86 171 0 1890119088 12359056 23803920
23:07:08 2214 8192000000 10801413408 11188432896 1857466320 18.483 100 87 175 0 1894129888 12570160 24093408
23:07:16 1217 8192000000 10805740896 11190235136 1858828432 18.494 100 90 180 0 1897729552 13910432 24990688
23:07:24 1480 8192000000 10805596864 11191664640 1861596384 18.516 100 93 190 2 1901556784 13842992 26117408
23:07:32 3270 8192000000 10807601872 11196121088 1860529680 18.508 100 87 174 2 1899920576 14121072 25269824
23:07:41 2097 8192000000 10803522272 11194032128 1861374576 18.514 100 79 158 1 1896675248 12625072 22675600
23:07:49 2547 8192000000 10814212448 11203072000 1870585584 18.589 100 83 166 3 1906297616 11306176 24405856
23:07:58 2628 8192000000 10794193936 11201368064 1866508656 18.556 100 63 127 2 1896325232 11522128 18294448
23:08:08 38968 8192000000 10802553408 11206987776 1868482080 18.572 100 59 117 2 1892300864 7027104 16791680
23:08:57 3135 8192000000 10807804976 11209662464 1878689472 18.655 100 81 162 3 1909654016 7461136 23503408
23:09:11 14239 8192000000 10778502960 11204456448 1872103120 18.601 100 23 47 0 1884592768 6042736 6446912
23:09:32 6456 8192000000 10797885488 11212570624 1871282448 18.595 100 33 66 0 1888172736 7249680 9640608
23:09:44 2994 8192000000 10783658304 11212328960 1872538352 18.605 100 32 66 2 1890023008 8503648 8981008
23:09:53 3353 8192000000 10797600624 11215200256 1877738592 18.647 100 40 82 0 1896494352 6867664 11888096
23:10:03 6850 8192000000 10801427104 11219447808 1878047856 18.649 100 33 64 1 1893379424 6555216 8776352
23:10:19 8565 8192000000 10793886224 11221237760 1880034880 18.665 100 26 52 1 1893624736 6818960 6770896
23:10:41 10150 8192000000 10785463488 11223375872 1886687680 18.719 100 32 63 3 1902517552 6711616 9118256
23:10:58 10684 8192000000 10795625616 11227709440 1891579456 18.759 100 29 58 3 1906542848 6710800 8252592
23:11:18 5253 8192000000 10802481328 11231305728 1892113920 18.763 100 29 58 1 1907404240 7374400 7915920
23:11:31 11999 8192000000 10796314720 11232292864 1890713792 18.752 100 15 30 2 1900300448 5740800 3845856
23:11:50 12364 8192000000 10795456816 11231633408 1892386160 18.765 100 21 42 3 1904636544 5533424 6716960
23:12:10 9998 8192000000 10803364752 11235278848 1893425888 18.773 100 17 33 1 1904838816 6528816 4884112
23:12:27 13078 8192000000 10806307184 11239018496 1896460528 18.798 100 16 32 2 1906548848 5440560 4647760
23:12:48 52010 8192000000 10830264784 11253940224 1906860688 18.881 100 30 60 1 1922212736 4873536 10478512
23:14:07 3186 8192000000 10825228752 11260035072 1905797040 18.873 100 38 76 2 1925269696 9229520 10243136
23:14:16 5749 8192000000 10828455152 11258916864 1905897568 18.874 100 31 62 0 1921786800 6922512 8966720
23:14:28 5979 8192000000 10832870672 11258744832 1910605616 18.912 100 32 64 1 1928027584 6808720 10613248
23:14:43 4526 8192000000 10837261360 11260395520 1909198272 18.900 100 48 96 1 1931446368 9010176 13237920
23:14:56 5724 8192000000 10831415152 11259719680 1909120992 18.900 100 40 80 1 1928545872 7392032 12032848
23:15:08 8169 8192000000 10825680896 11260456960 1908757584 18.897 100 33 67 2 1924466576 6683872 9025120
23:15:22 3478 8192000000 10815395792 11247362048 1886042576 18.714 99 36 72 1 1903870336 7327328 10500432
23:15:32 4009 8192000000 10806260896 11238363136 1864003104 18.536 98 41 82 0 1883987376 8538464 11445808
23:15:44 4766 8192000000 10794760176 11224264704 1878289664 18.651 99 28 54 2 1892685120 7084128 7311328
23:15:55 3646 8192000000 10794025328 11222654976 1877755888 18.647 100 39 77 2 1895755168 6796352 11202928
23:16:06 5629 8192000000 10778230304 11204988928 1845652208 18.387 98 32 63 1 1861856688 6738048 9466432
23:16:20 3529 8192000000 10800792464 11220643840 1874841712 18.623 100 30 58 4 1888219600 5566032 7811856
23:16:30 7761 8192000000 10792093824 11219865600 1877299568 18.643 100 30 61 3 1893049264 6083040 9666656
23:16:45 44441 8192000000 10780433312 11202695168 1822958912 18.202 97 34 67 0 1842470512 9719648 9791952
23:17:48 14541 8192000000 10746916432 11174567936 1758418368 17.671 94 18 36 0 1769153040 4833808 5900864
23:18:11 9057 8192000000 10753908528 11185192960 1825990832 18.227 99 18 36 0 1837088128 5793040 5304256
23:18:27 4683 8192000000 10744946224 11164094464 1802754960 18.037 98 44 88 2 1822181504 6640752 12785792
23:18:38 7347 8192000000 10744791808 11167449088 1798447200 18.001 98 31 62 1 1817756720 10545536 8763984
23:18:53 4589 8192000000 10708367984 11117608960 1719245232 17.346 95 26 52 0 1732546640 6045904 7255504
23:19:07 8546 8192000000 10692113120 11093098496 1668624112 16.922 93 38 76 0 1686457216 5477728 12355376
23:19:24 6316 8192000000 10688005760 11095240704 1718170304 17.337 96 35 71 2 1735926256 6922352 10833600
23:19:40 6930 8192000000 10694904144 11110006784 1762858176 17.708 99 25 50 4 1775746016 5528928 7358912
23:19:54 6102 8192000000 10689119696 11106013184 1750740080 17.608 98 20 40 2 1761953792 5087248 6126464
23:20:08 7836 8192000000 10699831632 11105808384 1731092896 17.445 97 21 43 3 1742947760 5988704 5866160
23:20:22 5459 8192000000 10701023456 11110658048 1752231616 17.620 98 29 59 2 1766553376 6230624 8091136
23:20:39 10736 8192000000 10713425312 11117187072 1751379232 17.613 98 25 50 1 1763900624 5728800 6792592
23:20:56 7916 8192000000 10707014688 11126038528 1791350416 17.943 100 14 27 1 1800602304 5458080 3793808
23:21:10 22527 8192000000 10749261936 11161079808 1802293216 18.033 99 31 62 4 1815749424 4971984 8484224
23:21:40 68114 8192000000 10747616768 11175612416 1816409408 18.148 99 36 71 0 1837179024 9350112 11419504
23:22:57 5935 8192000000 10748266944 11170668544 1835421408 18.304 100 29 58 1 1853553936 9674976 8457552
23:23:10 9016 8192000000 10747360944 11177648128 1836668336 18.314 100 18 36 2 1847192848 5265072 5259440
23:23:25 6012 8192000000 10758605296 11185016832 1846861152 18.397 100 31 62 2 1866354752 11073008 8420592
23:23:39 6021 8192000000 10774186096 11194335232 1850396912 18.425 100 34 67 0 1865740384 5938048 9405424
23:23:52 4980 8192000000 10775206768 11194585088 1853062800 18.447 100 31 58 3 1867257136 5589072 8605264
23:24:03 6169 8192000000 10768192976 11195191296 1856453232 18.475 100 28 56 1 1872047600 6973168 8621200
23:24:16 13005 8192000000 10777596672 11198418944 1855011392 18.463 100 19 37 3 1867257600 5881424 6364784
23:24:36 8791 8192000000 10782359632 11202924544 1858910368 18.494 100 24 49 1 1875579392 9731888 6937136
23:24:51 10131 8192000000 10773760176 11202404352 1858505856 18.491 100 19 38 1 1869367504 5504992 5356656
23:25:11 7892 8192000000 10786508688 11206987776 1862416784 18.523 100 32 62 0 1877468176 5336448 9714944
23:25:35 12321 8192000000 10787006304 11213570048 1862987024 18.527 100 26 52 2 1876332848 5409248 7936576
23:25:53 12150 8192000000 10785248976 11210383360 1864789152 18.542 100 14 28 0 1874202656 5273264 4140240
23:26:14 16181 8192000000 10786603120 11216883712 1872279952 18.603 100 33 67 2 1888479632 4983200 11216480
23:26:37 99885 8192000000 10813721664 11242151936 1867414432 18.563 99 33 66 1 1881646928 4832736 9399760
23:28:25 58820 8192000000 10852849776 11274534912 1910463776 18.910 100 39 78 2 1929844592 7963248 11417568
23:29:47 30788 8192000000 10858887168 11280281600 1927426128 19.046 100 36 70 2 1948291248 10712032 10153088
23:30:24 17707 8192000000 10867615712 11297550336 1938990992 19.139 100 41 82 2 1962610672 12356704 11262976
23:30:52 36701 8192000000 10867582224 11308892160 1943540080 19.175 100 34 67 2 1965966704 12459728 9966896
23:31:42 12577 8192000000 10874539808 11312250880 1944596768 19.183 100 26 51 1 1963544112 11576960 7370384
23:32:03 3838 8192000000 10893662176 11306156032 1947969408 19.210 100 39 78 2 1970739840 11181936 11588496
23:32:15 3474 8192000000 10892360128 11319017472 1957453456 19.286 100 65 127 0 1987038544 11811072 17774016
23:32:25 10384 8192000000 10894535824 11313446912 1950228624 19.228 100 59 117 1 1980015424 13071616 16715184
23:32:44 3641 8192000000 10899719456 11324555264 1958601136 19.295 100 63 125 0 1994663408 19113296 16948976
23:32:57 8415 8192000000 10883283344 11306127360 1947860960 19.209 100 64 128 1 1980708656 14128064 18719632
23:33:20 13987 8192000000 10898052528 11317575680 1955926624 19.274 100 59 117 2 1988280992 14692816 17661552
23:33:46 18907 8192000000 10893197152 11325710336 1954748112 19.264 100 46 92 2 1981906960 14275488 12883360
23:34:13 14186 8192000000 10902264416 11329003520 1943505824 19.175 99 42 84 1 1974201568 18229616 12466128
23:34:36 29759 8192000000 10909679088 11342917632 1967480880 19.365 100 51 102 1 2002309504 19523056 15305568
23:35:20 23760 8192000000 10905259520 11334725632 1959131600 19.299 99 47 95 2 1994043696 20483088 14429008
23:35:53 9794 8192000000 10918222976 11355656192 1965044672 19.346 99 58 116 0 2000025616 17135264 17845680
23:36:10 3484 8192000000 10918531904 11342049280 1970279632 19.388 100 52 103 1 2003397040 17736384 15381024
23:36:28 10952 8192000000 10913438832 11338039296 1949664640 19.224 99 57 114 1 1987453856 20770608 17018608
23:36:51 22958 8192000000 10923211760 11352317952 1960397344 19.309 99 51 102 2 1998609152 22159744 16052064
23:37:21 11298 8192000000 10928402656 11361329152 1980141552 19.466 100 54 106 2 2020635568 24511056 15982960
23:37:46 3385 8192000000 10945397328 11373473792 1993362688 19.570 100 65 130 0 2035094240 21211248 20520304
23:38:17 12693 8192000000 10950014160 11377569792 1994331104 19.578 100 65 128 1 2039157072 25520944 19305024
23:38:38 5971 8192000000 10943681024 11373285376 1978527184 19.453 99 68 135 1 2025785904 25877600 21381120
23:38:53 6694 8192000000 10941250416 11370872832 1985616512 19.509 100 58 114 1 2030516496 26607456 18292528
23:39:07 8044 8192000000 10938206048 11365072896 1968909648 19.377 99 65 127 2 2014331056 25523248 19898160
23:39:27 10581 8192000000 10936934864 11369172992 1985305184 19.507 100 58 116 0 2030649296 26906512 18437600
23:39:53 9437 8192000000 10937825264 11361538048 1976568272 19.438 100 60 114 4 2020269632 25642624 18058736
23:40:12 5959 8192000000 10942170752 11367710720 1966522272 19.358 99 61 122 1 2012986656 27573280 18891104
23:40:27 3903 8192000000 10858071728 11274391552 1865697216 18.549 95 57 114 1 1912129536 27932432 18499888
23:40:39 11962 8192000000 10899581264 11327819776 1947404752 19.206 100 62 120 3 1993027264 27129216 18493296
23:40:58 4884 8192000000 10912049968 11328659456 1919784176 18.985 98 77 152 3 1972107568 29354464 22968928
23:41:14 3364 8192000000 10917920736 11332018176 1952110000 19.243 100 63 126 2 2002963488 31544816 19308672
23:41:24 3932 8192000000 10935003632 11341938688 1944816400 19.185 99 77 151 2 2001356544 33144384 23395760
23:41:36 5754 8192000000 10912360448 11319844864 1927135184 19.044 98 80 158 2 1985729600 33903968 24690448
23:41:48 1012 8192000000 10933051776 11349970944 1962019456 19.322 100 77 153 0 2014496976 28799168 23678352
23:41:56 1681 8192000000 10905879072 11307151360 1923572816 19.015 98 93 188 1 1983066704 30600944 28892944
23:42:05 2340 8192000000 10918588304 11325730816 1931892000 19.082 99 83 164 2 1989672896 31908272 25872624
23:42:14 4134 8192000000 10887637744 11295993856 1898044672 18.811 98 80 160 2 1954696688 32445136 24206880
23:42:29 2344 8192000000 10891447120 11292192768 1914974720 18.947 100 78 157 0 1972777184 33485056 24317408
23:42:41 4497 8192000000 10905863440 11314728960 1928633776 19.056 100 87 173 1 1991058080 35395904 27028400
23:42:54 2643 8192000000 10912345600 11327746048 1940168224 19.148 100 82 164 2 2003365552 36365680 26831648
23:43:04 7509 8192000000 10897702192 11303165952 1919527296 18.983 99 81 162 0 1981106608 36252672 25326640
23:43:30 5342 8192000000 10902353872 11319128064 1932467440 19.087 100 68 135 2 1988570544 34643856 21459248
23:43:44 2491 8192000000 10917826176 11326910464 1940438496 19.150 100 78 156 1 1999602480 34418272 24745712
23:43:55 2513 8192000000 10910550864 11312111616 1929958672 19.067 100 85 165 1 1990114784 34138736 26017376
23:44:05 1553 8192000000 10888546912 11283431424 1904396544 18.862 99 86 166 3 1962080160 32237792 25445824
23:44:12 3546 8192000000 10908133488 11311652864 1926471728 19.039 100 85 169 1 1986568592 34545280 25551584
23:44:26 3791 8192000000 10900104272 11311882240 1927795200 19.049 100 73 144 1 1980858144 31079232 21983712
23:44:39 5629 8192000000 10888608000 11307352064 1929067120 19.059 100 52 104 1 1973186816 28390560 15729136
23:44:56 7784 8192000000 10888093472 11317489664 1938843792 19.138 100 45 90 2 1977910336 25481936 13584608
23:45:10 3805 8192000000 10899138528 11316887552 1935981984 19.115 100 61 119 1 1979683536 25465264 18236288
23:45:27 3734 8192000000 10896491760 11316256768 1936957568 19.122 100 61 121 1 1982032448 26466176 18608704
23:45:38 2394 8192000000 10930109280 11333791744 1953361728 19.253 100 77 153 2 2006032848 28407360 24263760
23:45:50 1348 8192000000 10916067936 11318493184 1941193728 19.156 99 90 181 4 1999446400 31065264 27187408
23:45:58 2074 8192000000 10935430736 11341029376 1954662656 19.264 100 82 164 1 2012058656 32664304 24731696
23:46:07 4810 8192000000 10916753488 11341557760 1953765264 19.256 100 60 120 0 2005506064 33340992 18399808
23:46:30 8563 8192000000 10905747664 11333480448 1945616832 19.192 100 45 90 1 1989823728 29663152 14543744
23:46:45 5501 8192000000 10907525360 11319791616 1934282704 19.101 99 70 138 1 1985352464 30179312 20890448
23:46:57 2084 8192000000 10930248576 11339055104 1952792592 19.249 100 81 162 1 2009613248 31295248 25525408
23:47:06 5432 8192000000 10931909056 11353792512 1962329040 19.325 100 69 138 0 2016492896 33717904 20445952
23:47:19 8216 8192000000 10905887968 11338289152 1930560928 19.071 99 46 92 2 1976438720 31438576 14439216
23:47:37 2859 8192000000 10887647056 11318091776 1922323200 19.005 99 50 100 0 1973316112 35769632 15223280
23:47:57 7427 8192000000 10894530272 11326812160 1931342192 19.078 100 32 62 3 1976687680 34657728 10687760
23:48:14 9305 8192000000 10881443664 11315523584 1918297344 18.973 99 39 78 0 1966866096 36002928 12565824
23:48:30 2503 8192000000 10923056448 11332423680 1939873296 19.146 100 82 166 1 1997584656 31023104 26688256
23:48:39 12757 8192000000 10887574848 11323129856 1918143680 18.972 99 37 75 2 1964175184 33862480 12169024
23:49:19 14196 8192000000 10879844512 11326918656 1923194480 19.012 100 28 56 2 1968305568 34816752 10294336
23:49:55 6250 8192000000 10894540656 11325575168 1926332480 19.038 100 47 94 0 1973605696 32491664 14781552
23:50:13 22349 8192000000 10889795664 11336720384 1930229872 19.069 100 26 52 0 1975624528 35906368 9488288
23:50:42 13147 8192000000 10900049216 11341828096 1931736224 19.081 100 28 56 0 1978780800 36930784 10113792
23:51:04 6293 8192000000 10910608656 11343470592 1941700688 19.160 100 38 74 1 1991612208 37302384 12609136
23:51:20 15919 8192000000 10909976448 11355357184 1950145392 19.228 100 39 78 2 2001682240 38269456 13267392
23:51:51 24932 8192000000 10901489632 11360813056 1955476704 19.270 100 26 51 3 1995208592 30914112 8817776
23:52:22 18624 8192000000 10901996032 11354845184 1936937488 19.122 99 24 47 4 1972806080 27822816 8045776
23:52:51 63206 8192000000 10903589328 11343708160 1936958480 19.122 99 26 52 1 1967350016 22062448 8329088
23:54:01 17600 8192000000 10897903616 11346165760 1952186592 19.244 100 25 50 0 1987086800 26880656 8019552
23:55:12 34949 8192000000 10885663440 11354226688 1948090960 19.211 100 13 26 2 1976898720 24535520 4272240
23:55:57 43390 8192000000 10901098880 11360514048 1953140128 19.251 100 29 57 1 1985322544 22602192 9580224
23:56:58 81223 8192000000 10897720896 11364806656 1959862880 19.305 100 11 23 0 1980116816 17197872 3056064
23:58:36 75125 8192000000 10886313264 11332894720 1914161104 18.940 97 18 36 0 1930323680 11176448 4986128
00:00:04 87232 8192000000 10911749984 11369467904 1967752784 19.368 100 8 16 1 1981327728 11300640 2274304
00:01:38 96488 8192000000 10888980544 11348221952 1915337280 18.949 97 12 24 1 1928519088 9248928 3932880
00:03:20 59249 8192000000 10923609584 11366850560 1971069680 19.394 100 26 52 0 1986845008 8613808 7161520
00:04:28 20223 8192000000 10919019344 11365265408 1968677520 19.375 99 29 59 1 1987320400 9588800 9054080
00:04:58 10501 8192000000 10931526992 11377471488 1990564736 19.548 100 50 100 1 2016115776 9801840 15749200
00:05:22 16597 8192000000 10914033504 11381309440 1987501312 19.524 100 11 22 2 2000847712 10616064 2730336
00:05:46 161956 8192000000 10902700208 11367514112 1950278224 19.229 98 10 20 2 1964289696 11545968 2465504
00:08:39 66105 8192000000 10914496480 11375415296 1966213952 19.355 99 21 42 2 1985984192 14315792 5454448
00:10:36 44656 8192000000 10933044880 11386286080 1991092224 19.552 100 47 93 2 2010741376 6717200 12931952
00:11:47 36125 8192000000 10939890656 11389784064 1978075600 19.449 99 42 84 1 2001652560 10758256 12818704
00:12:30 115320 8192000000 10876118272 11335454720 1814810752 18.135 91 36 72 0 1834490928 8955504 10724672
00:14:31 50750 8192000000 10914711424 11369340928 1971402944 19.397 100 20 40 3 1990292656 12723008 6166704
00:15:30 56627 8192000000 10928929824 11380097024 1929433808 19.062 97 41 82 1 1957892640 15752784 12706048
00:16:40 47599 8192000000 10908412992 11382829056 1958765696 19.296 99 25 50 1 1984008096 17347600 7894800
00:18:06 63354 8192000000 10857110432 11341852672 1910308512 18.909 97 11 22 1 1935966048 21971584 3685952
00:19:16 27068 8192000000 10879054704 11353817088 1938496832 19.135 99 11 23 0 1952465936 10737168 3231936
00:19:50 23692 8192000000 10897376176 11364712448 1955663312 19.272 100 10 20 1 1974766992 16041856 3061824
00:20:20 38410 8192000000 10862387936 11328077824 1927497984 19.047 98 13 26 1 1945238272 13750800 3989488
00:21:05 90056 8192000000 10847409632 11329122304 1852735840 18.444 95 9 18 0 1867586096 12261536 2588720
00:22:45 36608 8192000000 10850792752 11323744256 1900324352 18.829 98 15 30 1 1913067760 8540736 4202672
00:23:31 20357 8192000000 10903992400 11341541376 1923777440 19.017 99 51 101 1 1945964496 7707136 14479920
00:24:13 48547 8192000000 10866745936 11340107776 1908731456 18.896 98 28 56 3 1929818464 12898672 8188336
00:25:14 18572 8192000000 10843042544 11297746944 1866093568 18.553 96 16 32 0 1877161184 7130096 3937520
00:25:45 32804 8192000000 10831669440 11286122496 1828982896 18.251 95 27 53 1 1845551072 8967392 7600784
00:26:24 39716 8192000000 10863148480 11306344448 1885518000 18.710 99 23 46 2 1902110304 10176976 6415328
00:27:16 59816 8192000000 10860961792 11320446976 1872557248 18.605 97 18 36 1 1884777936 7593920 4626768
00:28:22 47977 8192000000 10855362592 11324321792 1887175920 18.723 97 16 32 0 1902479344 10365088 4938336
00:29:24 57329 8192000000 10849442288 11307937792 1816769824 18.151 94 27 54 0 1833506016 9156688 7579504
00:31:07 63038 8192000000 10864949968 11313094656 1857799152 18.485 96 26 52 2 1876067664 10887936 7380576
00:32:16 73134 8192000000 10853878880 11317239808 1852045664 18.439 96 18 36 2 1870622128 13537040 5039424
00:34:06 59567 8192000000 10863210640 11316420608 1888699248 18.735 98 21 42 2 1908948000 14125792 6122960
00:35:14 31935 8192000000 10872509680 11324772352 1893412336 18.773 98 31 60 1 1916182608 14392048 8378224
00:35:52 75884 8192000000 10855261792 11318943744 1869267696 18.578 97 19 38 0 1895352224 20761600 5322928
00:37:17 85377 8192000000 10842412816 11295830016 1892298976 18.764 98 7 14 1 1911992000 17458352 2234672
00:39:24 61521 8192000000 10869319600 11327008768 1897064912 18.803 98 27 54 0 1913767696 9362288 7340496
00:40:56 32702 8192000000 10859324384 11326828544 1930161360 19.068 100 28 56 0 1952452768 13859184 8432224
00:41:35 29556 8192000000 10870033584 11323580416 1915227280 18.949 99 31 62 0 1934528576 10118816 9182480
00:42:11 27735 8192000000 10899856064 11334008832 1944016352 19.179 100 45 90 2 1969035440 12307616 12711472
00:42:48 52735 8192000000 10874675392 11351785472 1953110704 19.251 100 19 38 0 1970065808 11389168 5565936
00:43:47 38309 8192000000 10880278768 11337560064 1941392896 19.158 99 13 26 0 1954683600 9472624 3818080
00:44:37 80175 8192000000 10888841248 11360038912 1946133040 19.196 99 15 30 2 1960770544 10195264 4442240
00:47:03 54458 8192000000 10881562560 11356364800 1953170384 19.252 100 7 13 2 1965645392 10555744 1919264
00:48:03 77561 8192000000 10906753280 11377037312 1964966320 19.345 100 15 29 0 1986460064 16519616 4974128
00:49:54 84331 8192000000 10884122320 11361382400 1959376272 19.301 100 9 18 0 1974763584 12783952 2603360
00:51:24 36706 8192000000 10903383472 11369402368 1972477920 19.405 100 16 30 3 1984084000 6573424 5032656
00:52:14 32320 8192000000 10905609456 11368230912 1957830080 19.289 99 21 42 1 1973641008 9264096 6546832
00:52:55 16601 8192000000 10921758976 11378032640 1977667376 19.446 100 33 66 2 1994656400 7178336 9810688
00:53:19 58875 8192000000 10908722688 11392954368 1984036096 19.497 100 23 46 1 2000000960 9637728 6327136
00:54:24 69538 8192000000 10903645440 11386146816 1965271024 19.348 99 20 40 0 1985717408 15027184 5419200
00:55:53 73446 8192000000 10912226368 11387502592 1930168192 19.068 97 11 21 0 1942644000 9300656 3175152
00:58:22 102807 8192000000 10916335696 11380965376 1825401120 18.222 91 12 25 0 1837460864 9308096 2751648
01:00:12 54996 8192000000 10891855824 11356504064 1874456160 18.620 95 29 58 1 1894697568 11658944 8582464
01:01:14 72086 8192000000 10875535152 11322683392 1844479952 18.377 94 21 42 0 1860270240 9958352 5831936
01:02:35 32602 8192000000 10898074656 11353661440 1953393536 19.253 100 31 62 6 1975195840 12781808 9020496
01:03:50 112266 8192000000 10908149856 11383742464 1895120512 18.787 96 10 19 0 1908380992 11211520 2048960
01:05:48 74371 8192000000 10880463424 11347369984 1888509280 18.734 96 7 14 0 1907615360 16830624 2275456
01:07:14 102466 8192000000 10867870880 11336003584 1886739552 18.719 96 15 30 0 1900423680 9447632 4236496
01:09:10 76951 8192000000 10871679568 11344240640 1914466000 18.942 98 14 28 0 1932002672 13712656 3824016
01:10:44 25663 8192000000 10872658320 11325771776 1916656080 18.960 98 41 82 0 1944377120 16377776 11343264
01:11:15 46153 8192000000 10879762896 11351822336 1943426064 19.174 100 15 30 0 1965066384 16752944 4887376
01:12:12 69834 8192000000 10862851264 11348336640 1891524768 18.758 97 9 18 1 1907109600 13127936 2456896
01:13:30 54736 8192000000 10837634096 11298369536 1826700096 18.232 94 22 44 1 1846871776 14131344 6040336
01:15:19 73821 8192000000 10851813184 11337830400 1926911776 19.042 100 14 28 0 1948915424 17174864 4828784
01:17:02 81683 8192000000 10843741024 11322089472 1844803568 18.380 95 19 38 2 1868006048 17962864 5239616
01:18:32 34056 8192000000 10867173904 11328045056 1859206480 18.497 96 26 52 0 1880142128 13641600 7294048
01:19:21 63375 8192000000 10829612272 11304853504 1835918272 18.308 95 18 36 2 1856920144 16042416 4959456
01:20:31 74454 8192000000 10838355888 11325304832 1891643120 18.759 99 14 28 0 1916973552 21265168 4065264
01:21:55 28455 8192000000 10877405408 11329617920 1918355040 18.974 99 32 64 0 1938826160 11496960 8974160
01:22:32 69284 8192000000 10863188736 11320459264 1861081152 18.512 96 23 46 0 1887187232 19542784 6563296
01:24:14 89383 8192000000 10869911424 11314335744 1880809408 18.672 98 16 32 0 1900195040 15172720 4212912
01:25:50 29773 8192000000 10863651744 11319353344 1884802144 18.704 98 34 68 2 1908532912 13914080 9816688
01:26:58 17578 8192000000 9226992944 9479487488 378443056 4.415 20 2 3 0 384046880 5259600 344224

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 17-11-2020 01:28:03 to 17-11-2020 01:28:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 93 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:01, from 17-11-2020 01:28:35 to 17-11-2020 01:28:36.

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          253743
MON$OLDEST_ACTIVE               253744
MON$OLDEST_SNAPSHOT             253744
MON$NEXT_TRANSACTION            253744
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                       2052384
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
:217: 
:218: mscs-test-161.budzdorov.ru    Tue Nov 17 01:27:19 2020
:219:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:220: 
:221: 
:222: mscs-test-161.budzdorov.ru    Tue Nov 17 01:27:22 2020
:223:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:224: 
--- end of diff output ---

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

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