Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.12.2020 19: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 17463168 kB
MemAvailable 31500416 kB
Buffers 0 kB
Cached 14198376 kB
SwapCached 3724 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-12-14 19:27:04
DTS_END                         2020-12-14 19:27:04.6560
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47520
TRN_ID                          247760
ATT_ID                          668
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: 9708.15 20855 1164978
customer order: creation 175.83 387 21100
customer order: refuse 15.21 285 1825
order to supplier: creation 46.73 1257 5608
order to supplier: removal 3.48 89623 417
invoice (draft): creation 47.09 3225 5651
invoice (draft): removal 55.06 689 6607
invoice accept: apply 42.90 16323 5148
invoice accept: cancel 49.01 700 5881
customer reserve: creation 4019.58 158 482349
customer reserve: removal 4955.30 49 594636
realization accept: apply 85.48 213 10258
realization accept: cancel 78.97 105 9476
payment from customer: creation 60.65 151 7278
payment from customer: removal 6.13 85 736
payment to supplier: creation 50.25 169 6030
payment to supplier: removal 3.56 119 427
service: total inventory turnovers 5.02 914 602
service: total monetary turnovers 6.99 32 839
service: aggregate perf. data 0.88 19232 106
service: refresh index statistics 0.03 283377 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-12-2020 19:27:51 to 14-12-2020 19:27:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5444
TEST_TIME 2 5383
TEST_TIME 3 5654
TEST_TIME 4 6236
TEST_TIME 5 6015
TEST_TIME 6 6092
TEST_TIME 7 6388
TEST_TIME 8 6540
TEST_TIME 9 6676
TEST_TIME 10 6915
TEST_TIME 11 7265
TEST_TIME 12 7191
TEST_TIME 13 7574
TEST_TIME 14 8554
TEST_TIME 15 8598
TEST_TIME 16 8856
TEST_TIME 17 9242
TEST_TIME 18 10186
TEST_TIME 19 10607
TEST_TIME 20 10709
TEST_TIME 21 11457
TEST_TIME 22 12152
TEST_TIME 23 12276
TEST_TIME 24 11923
TEST_TIME 25 11547
TEST_TIME 26 11659
TEST_TIME 27 11476
TEST_TIME 28 11186
TEST_TIME 29 11064
TEST_TIME 30 10941
TEST_TIME 31 10804
TEST_TIME 32 10663
TEST_TIME 33 10445
TEST_TIME 34 10397
TEST_TIME 35 10287
TEST_TIME 36 10168
TEST_TIME 37 10053
TEST_TIME 38 10061
TEST_TIME 39 9908
TEST_TIME 40 9890
TEST_TIME 41 9737
TEST_TIME 42 9554
TEST_TIME 43 9758
TEST_TIME 44 9698
TEST_TIME 45 9717
TEST_TIME 46 9635
TEST_TIME 47 9674
TEST_TIME 48 9680
TEST_TIME 49 9622
TEST_TIME 50 9797
TEST_TIME 51 9747
TEST_TIME 52 9916
TEST_TIME 53 9955
TEST_TIME 54 9934
TEST_TIME 55 10066
TEST_TIME 56 10138
TEST_TIME 57 10002
TEST_TIME 58 9873
TEST_TIME 59 9863
TEST_TIME 60 9857
TEST_TIME 61 9866
TEST_TIME 62 9799
TEST_TIME 63 9684
TEST_TIME 64 9595
TEST_TIME 65 9740
TEST_TIME 66 9745
TEST_TIME 67 9739
TEST_TIME 68 9761
TEST_TIME 69 9684
TEST_TIME 70 9684
TEST_TIME 71 9683
TEST_TIME 72 9760
TEST_TIME 73 9907
TEST_TIME 74 9860
TEST_TIME 75 9969
TEST_TIME 76 10068
TEST_TIME 77 10099
TEST_TIME 78 9995
TEST_TIME 79 9939
TEST_TIME 80 9926
TEST_TIME 81 9916
TEST_TIME 82 9851
TEST_TIME 83 9802
TEST_TIME 84 9757
TEST_TIME 85 9716
TEST_TIME 86 9621
TEST_TIME 87 9622
TEST_TIME 88 9693
TEST_TIME 89 9720
TEST_TIME 90 9706
TEST_TIME 91 9708
TEST_TIME 92 9706
TEST_TIME 93 9734
TEST_TIME 94 9939
TEST_TIME 95 9906
TEST_TIME 96 9944
TEST_TIME 97 9922
TEST_TIME 98 9936
TEST_TIME 99 9964
TEST_TIME 100 9983
TEST_TIME 101 9932
TEST_TIME 102 9872
TEST_TIME 103 9816
TEST_TIME 104 9788
TEST_TIME 105 9765
TEST_TIME 106 9743
TEST_TIME 107 9701
TEST_TIME 108 9667
TEST_TIME 109 9643
TEST_TIME 110 9615
TEST_TIME 111 9614
TEST_TIME 112 9733
TEST_TIME 113 9711
TEST_TIME 114 9738
TEST_TIME 115 9711
TEST_TIME 116 9820
TEST_TIME 117 9787
TEST_TIME 118 9811
TEST_TIME 119 9786
TEST_TIME 120 9710

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 14-12-2020 19:27:54 to 14-12-2020 19:27:58.

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 1610806 1610806 0 0.00 0 45880 6 0 0
doc_list_biud 1610804 1610804 0 0.00 0 29584 23 0 0
sp_add_invoice_to_stock 5254 5148 106 2.01 64 189195 16324 0 106
sp_cancel_adding_invoice 5881 5881 0 0.00 5 61740 701 0 0
sp_cancel_client_order 1825 1825 0 0.00 4 8471 286 0 0
sp_cancel_customer_reserve 594636 594636 0 0.00 1 26487 49 0 0
sp_cancel_pay_from_customer 736 736 0 0.00 3 7034 86 0 0
sp_cancel_pay_to_supplier 427 427 0 0.00 3 25770 120 0 0
sp_cancel_supplier_invoice 6615 6607 8 0.12 2 29591 689 0 8
sp_cancel_supplier_order 417 417 0 0.00 9 920923 89624 0 0
sp_cancel_write_off 9476 9476 0 0.00 1 16592 105 0 0
sp_client_order 21100 21100 0 0.00 3 24244 387 0 0
sp_customer_reserve 482349 482349 0 0.00 0 50450 159 0 0
sp_fill_shopping_cart 32353 32353 0 0.00 1 12589 40 0 0
sp_fill_shopping_cart_clo_res 482348 482348 0 0.00 0 14172 14 0 0
sp_get_clo_for_invoice 5144 5144 0 0.00 0 33764 298 0 0
sp_kill_cost_storno 16520 16520 0 0.00 0 25715 49 0 0
sp_kill_qstorno_ret_qs2qd 1205772 1205772 0 0.00 0 29579 27 0 0
sp_kill_qty_storno 634243 634243 0 0.00 0 29582 59 0 0
sp_lock_selected_doc 21375 21375 0 0.00 0 8243 8 0 0
sp_make_cost_storno 28710 28710 0 0.00 0 45866 74 0 0
sp_multiply_rows_for_pdistr 28709 28709 0 0.00 0 26257 38 0 0
sp_multiply_rows_for_qdistr 21100 21100 0 0.00 0 18307 188 0 0
sp_pay_from_customer 7278 7278 0 0.00 4 29831 152 0 0
sp_pay_to_supplier 6030 6030 0 0.00 5 27524 170 0 0
sp_payment_common 13308 13308 0 0.00 1 26926 52 0 0
sp_qd_handle_on_cancel_clo 1825 1825 0 0.00 0 8464 249 0 0
sp_qd_handle_on_invoice_upd_sts 11024 11024 0 0.00 0 22947 299 0 0
sp_qd_handle_on_reserve_upd_sts 10258 10258 0 0.00 0 14471 55 0 0
sp_reserve_write_off 10258 10258 0 0.00 6 32027 213 0 0
sp_supplier_invoice 5651 5651 0 0.00 5 89620 3225 0 0
sp_supplier_order 5608 5608 0 0.00 5 85768 1258 0 0
srv_aggregate_perf_data 106 106 0 0.00 2512 293185 19232 0 0
srv_fill_mon_cache_memory 143 143 0 0.00 1115 136013 38628 0 0
srv_find_qd_qs_mism 1115292 1115292 0 0.00 0 16675 5 0 0
srv_make_invnt_saldo 602 602 0 0.00 24 66188 915 0 0
srv_make_money_saldo 839 839 0 0.00 0 8411 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 251858 300018 283378 0 0
t$perf-abend:sp_add_invoice_to_stock 106 106 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5149 5149 0 0.00 0 14689 162 0 0
t$perf-norm:sp_cancel_adding_invoice 372 372 0 0.00 1 7615 114 0 0
t$perf-norm:sp_cancel_client_order 1825 1825 0 0.00 0 15529 19 0 0
t$perf-norm:sp_cancel_customer_reserve 739 739 0 0.00 0 479 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 736 736 0 0.00 0 3452 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 427 427 0 0.00 0 802 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 437 437 0 0.00 0 1088 10 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 28184 1180 0 0
t$perf-norm:sp_cancel_write_off 1021 1021 0 0.00 0 3168 7 0 0
t$perf-norm:sp_client_order 21100 21100 0 0.00 0 6446 12 0 0
t$perf-norm:sp_customer_reserve 975 975 0 0.00 0 2592 7 0 0
t$perf-norm:sp_pay_from_customer 7278 7278 0 0.00 0 3921 7 0 0
t$perf-norm:sp_pay_to_supplier 6030 6030 0 0.00 0 4530 9 0 0
t$perf-norm:sp_reserve_write_off 10258 10258 0 0.00 0 7563 11 0 0
t$perf-norm:sp_supplier_invoice 5651 5651 0 0.00 0 7211 14 0 0
t$perf-norm:sp_supplier_order 5608 5608 0 0.00 0 5401 11 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 106 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 143 143 0 0.00 0 2692 21 0 0
t$perf-norm:srv_make_invnt_saldo 602 602 0 0.00 0 752 12 0 0
t$perf-norm:srv_make_money_saldo 839 839 0 0.00 0 1798 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 10498 10286 212 2.01 0 5977 21 0 212
v_all_customers 38204 38204 0 0.00 0 13 0 0 0
v_all_suppliers 31192 31192 0 0.00 0 80 1 0 0
v_all_wares 42200 42200 0 0.00 0 35 1 0 0
v_cancel_adding_invoice 744 744 0 0.00 0 2112 9 0 0
v_cancel_client_order 3650 3650 0 0.00 0 5273 10 0 0
v_cancel_customer_prepayment 1472 1472 0 0.00 0 3118 8 0 0
v_cancel_customer_reserve 1478 1478 0 0.00 0 7865 16 0 0
v_cancel_payment_to_supplier 854 854 0 0.00 0 3711 7 0 0
v_cancel_supplier_invoice 890 874 16 1.79 0 4984 33 0 16
v_cancel_supplier_order 834 834 0 0.00 0 1028 4 0 0
v_cancel_write_off 2042 2042 0 0.00 0 5956 23 0 0
v_max_id_clo_ord 5608 5608 0 0.00 0 3779 2 0 0
v_max_id_clo_res 975 975 0 0.00 0 1940 9 0 0
v_max_id_ord_sup 5645 5645 0 0.00 0 5701 7 0 0
v_max_non_paid_invoice 1687 1687 0 0.00 0 6035 10 0 0
v_max_non_paid_realizn 4057 4057 0 0.00 0 6830 6 0 0
v_min_id_clo_ord 5608 5608 0 0.00 0 7112 12 0 0
v_min_id_clo_res 975 975 0 0.00 0 1699 5 0 0
v_min_id_ord_sup 5645 5645 0 0.00 0 9714 12 0 0
v_min_non_paid_invoice 6030 6030 0 0.00 0 21278 32 0 0
v_min_non_paid_realizn 7278 7278 0 0.00 0 25545 36 0 0
v_our_firm 10438 10438 0 0.00 0 15 1 0 0
v_reserve_write_off 20516 20516 0 0.00 0 4350 9 0 0
x_lock_depdocs_on_canc_invoice 12051 12051 0 0.00 0 17869 121 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 13709 313 0 0
x_make_qstorno_1000_1200 5608 5608 0 0.00 2 85361 1184 0 0
x_make_qstorno_1200_2000 5651 5651 0 0.00 2 89602 3078 0 0
x_make_qstorno_2100_3300 482349 482349 0 0.00 0 50439 143 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-12-2020 19:27:59 to 14-12-2020 19:28:03.

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
16:57:08 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:14 17494 8192000000 10228228208 10537738240 822701136 9.126 65 54 108 1 844038096 2445344 18891616
16:57:40 32747 8192000000 10336754144 10652704768 1375898432 14.380 100 78 155 0 1406260688 5013264 25348992
16:58:22 17542 8192000000 10376679712 10696454144 1430193424 14.863 100 88 176 0 1464999920 6548960 28257536
16:58:51 11823 8192000000 10391948448 10718388224 1450242912 15.040 100 86 172 0 1485115792 7074672 27798208
16:59:13 22438 8192000000 10416894592 10743394304 1460762720 15.133 100 81 162 1 1494525456 7764800 25997936
16:59:44 16807 8192000000 10428836928 10759585792 1483233280 15.330 100 86 172 0 1519647312 8648880 27765152
17:00:21 13419 8192000000 10452984928 10789531648 1510410032 15.567 100 86 172 0 1546638256 9361136 26867088
17:00:45 23865 8192000000 10471820256 10812137472 1522864992 15.675 100 89 178 1 1561062592 9988288 28209312
17:01:17 18696 8192000000 10498475696 10842386432 1547871216 15.892 100 84 168 0 1588613696 14527696 26214784
17:01:45 9028 8192000000 10519224640 10866249728 1575932784 16.133 100 82 164 0 1610861504 10331824 24596896
17:02:08 10615 8192000000 10554593440 10907078656 1607091744 16.400 100 80 160 0 1641951760 10658624 24201392
17:02:27 12307 8192000000 10575645952 10931589120 1629650784 16.592 100 86 172 0 1666868848 11178032 26040032
17:02:51 8945 8192000000 10575405648 10936082432 1640405168 16.683 100 71 139 3 1671422176 10939168 20077840
17:03:07 10849 8192000000 10606820368 10974461952 1669157648 16.926 100 74 149 0 1702469824 12103680 21208496
17:03:25 10988 8192000000 10631387168 10998312960 1690111936 17.102 100 78 156 0 1724109696 11903744 22094016
17:03:44 7077 8192000000 10650277424 11020431360 1699399776 17.180 100 79 154 4 1733758432 12591328 21767328
17:03:58 6913 8192000000 10665009760 11033870336 1721954608 17.368 100 85 170 1 1760560480 13967168 24638704
17:04:12 4397 8192000000 10671447488 11043127296 1738618832 17.507 100 87 174 0 1777125616 14394832 24111952
17:04:23 3827 8192000000 10692203488 11061788672 1751472032 17.614 100 84 168 0 1788931584 14087600 23371952
17:04:34 7241 8192000000 10700968976 11079163904 1766636768 17.739 100 82 164 2 1803407792 13320720 23450304
17:04:50 4603 8192000000 10716243776 11096735744 1776977760 17.825 100 84 168 2 1813465680 12907776 23580144
17:05:01 4630 8192000000 10719357104 11098394624 1783294112 17.877 100 84 167 1 1820058336 13348560 23415664
17:05:14 3123 8192000000 10734294528 11114860544 1792513472 17.952 100 89 178 1 1830795600 13431168 24850960
17:05:23 3580 8192000000 10746475696 11124658176 1797997024 17.997 100 86 172 1 1835981488 13375264 24609200
17:05:34 3135 8192000000 10744641680 11128225792 1801525888 18.026 100 87 174 2 1839714320 14167232 24021200
17:05:45 6366 8192000000 10743780672 11126403072 1804933392 18.054 100 87 172 0 1842917152 14417360 23566400
17:05:58 4651 8192000000 10748572480 11134488576 1808090272 18.080 100 86 171 1 1846164992 14133664 23941056
17:06:10 2498 8192000000 10767798512 11152134144 1825064640 18.219 100 89 179 1 1863219760 13287568 24867552
17:06:20 1662 8192000000 10771367104 11156205568 1829127152 18.252 100 84 168 1 1866439664 13171296 24141216
17:06:27 2417 8192000000 10783986816 11169603584 1838191104 18.326 100 90 180 0 1876510000 13964880 24354016
17:06:37 1305 8192000000 10784288288 11169271808 1846863360 18.397 100 93 186 2 1887055376 13796480 26395536
17:06:44 1907 8192000000 10793796272 11181006848 1853700672 18.452 100 89 177 0 1891996016 12901312 25394032
17:06:53 2256 8192000000 10801839152 11188666368 1855404528 18.466 100 90 180 4 1893860464 12870224 25585712
17:07:02 1494 8192000000 10803859312 11190075392 1858913648 18.494 100 91 183 0 1897787184 14079424 24794112
17:07:09 2506 8192000000 10806719104 11192725504 1864645184 18.541 100 84 168 0 1901328496 14399056 22284256
17:07:18 1514 8192000000 10818850832 11208138752 1869664368 18.582 100 97 192 0 1910093552 13490624 26938560
17:07:26 1070 8192000000 10814703168 11203678208 1874102768 18.617 100 91 181 4 1911584816 13241088 24240960
17:07:33 1829 8192000000 10822615472 11212320768 1876330928 18.635 100 93 187 2 1917374272 15121072 25922272
17:07:41 1215 8192000000 10826148480 11217362944 1884864464 18.704 100 91 186 2 1924157248 12425072 26867712
17:07:49 1584 8192000000 10825940640 11217342464 1885539344 18.710 100 95 192 0 1924004624 11769696 26695584
17:07:57 1108 8192000000 10831735728 11225149440 1888385472 18.733 100 94 188 1 1928391904 13660704 26345728
17:08:04 36147 8192000000 10803919280 11216060416 1878573120 18.654 100 49 98 1 1900615376 8180720 13861536
17:08:48 13805 8192000000 10820973808 11215282176 1883820304 18.696 100 63 123 3 1909490672 8123136 17547232
17:09:09 1249 8192000000 10838512160 11234963456 1892412720 18.765 100 95 187 2 1931800752 12719296 26668736
17:09:22 2318 8192000000 10815254544 11227652096 1886673008 18.719 100 53 104 1 1913631952 12346960 14611984
17:09:35 8812 8192000000 10802387520 11224788992 1884202432 18.699 100 22 44 1 1896659472 6087344 6369696
17:09:53 8733 8192000000 10791900624 11226750976 1886147504 18.715 100 19 38 0 1898225264 6950992 5126768
17:10:11 9889 8192000000 10799987392 11228913664 1889430160 18.741 100 24 48 0 1902899168 6810928 6658080
17:10:34 7017 8192000000 10800548160 11235426304 1894779792 18.784 100 26 50 2 1907766384 6446096 6540496
17:10:48 6828 8192000000 10807650800 11236634624 1895346592 18.789 100 32 64 3 1910883248 6205024 9331632
17:11:02 7979 8192000000 10805242672 11237998592 1898152752 18.811 100 26 52 1 1912458336 7312816 6992768
17:11:16 7657 8192000000 10813108000 11244195840 1896016080 18.794 100 19 36 1 1907866288 6395232 5454976
17:11:31 13680 8192000000 10809740720 11246882816 1904831696 18.865 100 12 24 0 1913820224 5634880 3353648
17:11:51 14154 8192000000 10818238304 11254579200 1908016976 18.891 100 21 42 0 1923617760 10351856 5248928
17:12:12 17273 8192000000 10811394416 11251965952 1905302288 18.869 100 15 30 2 1916088848 5839520 4947040
17:12:37 17007 8192000000 10813473232 11256721408 1910464272 18.910 100 16 30 1 1924135488 9485984 4185232
17:13:00 79411 8192000000 10828365536 11266957312 1915787392 18.953 100 25 50 0 1928836240 5554800 7494048
17:14:26 4751 8192000000 10833736864 11271286784 1917295648 18.965 100 29 58 2 1931809296 6748608 7765040
17:14:41 7065 8192000000 10816249216 11252744192 1898710592 18.816 99 29 58 2 1918370560 11507968 8152000
17:14:55 3158 8192000000 10825274592 11258261504 1892998800 18.770 99 37 74 1 1910464752 7315152 10150800
17:15:05 3720 8192000000 10825938032 11261718528 1908832608 18.897 100 29 58 3 1923017264 5911872 8272784
17:15:17 8667 8192000000 10829158816 11255783424 1889697696 18.743 99 23 46 1 1903126576 6339584 7089296
17:15:32 6577 8192000000 10818354176 11256139776 1908136736 18.892 100 20 40 0 1920520976 5497216 6887024
17:15:47 7529 8192000000 10828175728 11264741376 1911152896 18.916 100 20 40 2 1923082736 6448288 5481552
17:16:01 5624 8192000000 10826417168 11257380864 1885533600 18.710 99 23 46 0 1898481744 6065072 6883072
17:16:13 8165 8192000000 10812868736 11243290624 1876095680 18.634 99 18 36 1 1886355840 5542736 4717424
17:16:29 13102 8192000000 10794623744 11232661504 1871308720 18.595 99 12 24 1 1881066304 6223648 3533936
17:16:50 9616 8192000000 10805669024 11236048896 1885526288 18.710 100 20 40 0 1896697296 5289648 5881360
17:17:08 10031 8192000000 10765803392 11197870080 1789716192 17.929 95 20 40 2 1806448240 9730144 7001904
17:17:24 14767 8192000000 10745506048 11162554368 1712488352 17.290 92 24 49 2 1725321520 4758480 8074688
17:17:49 55528 8192000000 10698046448 11123724288 1670097664 16.934 91 20 40 1 1680958560 5536000 5324896
17:18:53 11176 8192000000 10736912080 11150422016 1739669712 17.516 95 31 62 1 1758751040 10756432 8324896
17:19:12 6509 8192000000 10709243456 11120566272 1761573472 17.697 98 36 73 2 1779485728 7855216 10057040
17:19:24 7167 8192000000 10724312320 11144835072 1790983824 17.940 99 36 72 2 1809497040 8150224 10362992
17:19:38 7961 8192000000 10706686352 11132174336 1766601168 17.739 98 23 46 3 1778418048 5316208 6500672
17:19:52 6291 8192000000 10682273216 11096817664 1718616064 17.341 96 28 56 0 1732327632 5993712 7717856
17:20:05 8927 8192000000 10676392080 11098222592 1692737872 17.124 95 27 55 1 1705658208 4879520 8040816
17:20:21 9355 8192000000 10691006384 11102117888 1753729168 17.632 98 21 42 2 1764887840 5217136 5941536
17:20:37 10151 8192000000 10722244688 11145338880 1808739136 18.086 100 21 42 1 1821382368 5720240 6922992
17:20:57 7058 8192000000 10724515824 11142119424 1797024096 17.989 99 11 22 1 1805615568 5542752 3048720
17:21:10 8630 8192000000 10736743920 11147964416 1782187632 17.867 98 34 69 1 1798463120 6057824 10217664
17:21:25 10849 8192000000 10734896912 11143102464 1762396960 17.704 97 37 74 0 1779252368 4826176 12029232
17:21:43 5055 8192000000 10731560848 11152121856 1816971648 18.153 100 31 62 0 1832350096 6590832 8787616
17:22:01 15650 8192000000 10740189936 11165659136 1807963104 18.079 99 18 35 1 1818850192 5366592 5520496
17:22:24 58041 8192000000 10744925472 11173642240 1820574880 18.182 99 34 68 2 1836705712 6175216 9955616
17:23:31 8645 8192000000 10758411328 11187769344 1845539328 18.386 100 26 51 3 1858983872 6514592 6929952
17:23:49 8731 8192000000 10768187392 11194372096 1852919152 18.446 100 31 62 3 1867891376 6039616 8932608
17:24:04 6654 8192000000 10778444336 11200823296 1858502880 18.491 100 28 56 0 1872641056 5499904 8638272
17:24:20 7123 8192000000 10786653696 11208077312 1866135504 18.553 100 33 66 5 1881224192 6329920 8758768
17:24:37 8560 8192000000 10785742528 11211300864 1869350480 18.579 100 30 60 3 1883318064 5714736 8252848
17:24:56 9925 8192000000 10802950128 11218538496 1870624240 18.589 100 25 51 0 1883880880 5545680 7710960
17:25:14 9231 8192000000 10781326112 11214295040 1871873168 18.599 100 16 32 3 1881962464 5396816 4692480
17:25:32 8203 8192000000 10791183056 11219976192 1872975600 18.608 100 14 28 4 1882606608 5783520 3847488
17:25:48 8074 8192000000 10785236784 11222564864 1876583168 18.638 100 17 34 2 1886764416 5364448 4816800
17:26:03 11563 8192000000 10793134576 11225800704 1878976080 18.657 100 14 28 0 1888443344 5462768 4004496
17:26:21 9516 8192000000 10794188976 11233292288 1883539008 18.694 100 23 46 0 1899548592 10247648 5761936
17:26:37 9395 8192000000 10794581744 11232112640 1886717232 18.719 100 15 30 0 1895993776 5105680 4170864
17:26:56 14226 8192000000 10804044112 11239710720 1892884176 18.769 100 20 40 2 1904242784 5712960 5645648
17:27:34 68457 8192000000 10848681600 11274948608 1923208528 19.013 100 25 49 1 1940942576 9347760 8386288
17:28:51 13713 8192000000 10867931568 11289845760 1935764080 19.113 100 42 84 5 1957498512 9227664 12506768
17:29:14 64748 8192000000 10845908992 11289137152 1914758176 18.945 99 41 81 1 1936985504 10167360 12059968
17:30:28 23970 8192000000 10880128656 11306811392 1940447632 19.150 100 51 102 0 1964114640 9909424 13757584
17:31:17 5086 8192000000 10896023088 11328073728 1945545104 19.191 99 54 108 3 1976302128 15752048 15004976
17:31:29 7050 8192000000 10904535152 11337977856 1964827088 19.344 100 55 110 0 1999014672 18390480 15797104
17:31:44 4927 8192000000 10910599520 11339988992 1969824688 19.384 100 51 101 2 2001111264 16576416 14710160
17:31:56 12624 8192000000 10914162272 11351269376 1973797040 19.416 100 42 83 2 2002396848 16695776 11904032
17:32:16 13136 8192000000 10926208256 11361902592 1988000928 19.528 100 57 112 0 2021754912 17757408 15996576
17:32:46 2945 8192000000 10937755184 11361484800 1987666528 19.525 100 72 142 3 2029011312 19675472 21669312
17:32:57 1737 8192000000 10925938496 11346468864 1971407680 19.397 99 73 145 2 2012334656 19662368 21264608
17:33:05 5520 8192000000 10940507248 11361525760 1987999760 19.528 100 66 128 3 2026322176 19528656 18793760
17:33:17 9891 8192000000 10941469648 11365875712 1991083024 19.552 100 62 124 2 2029599408 20768912 17747472
17:33:34 3768 8192000000 10948302368 11374153728 1994913104 19.583 100 69 138 1 2038661520 23494352 20254064
17:33:46 9733 8192000000 10963062112 11385774080 2000838400 19.629 100 66 132 2 2044247440 24113232 19295808
17:34:03 3193 8192000000 10958223760 11379654656 2002249776 19.640 100 67 132 2 2044784144 23986608 18547760
17:34:12 3822 8192000000 10952971392 11374653440 1979970384 19.464 99 69 138 1 2025439504 25149424 20319696
17:34:24 4282 8192000000 10940495696 11360927744 1983179504 19.490 100 76 152 2 2032315824 26990080 22146240
17:34:36 26352 8192000000 10913227856 11350589440 1965662176 19.351 100 54 108 2 2007528576 25331760 16534640
17:35:11 2653 8192000000 10916064528 11349291008 1972401488 19.404 100 46 93 1 2009992464 23486912 14104064
17:35:24 11968 8192000000 10915018544 11342385152 1920621040 18.992 97 48 94 1 1958602624 23461168 14520416
17:35:46 4281 8192000000 10918507264 11341713408 1947411248 19.206 99 60 115 1 1991839728 27063712 17364768
17:35:58 5037 8192000000 10918524208 11341873152 1960254480 19.308 100 62 124 0 2007880288 28955024 18670784
17:36:12 8159 8192000000 10931648928 11355820032 1972480624 19.405 100 63 126 2 2022216448 30493680 19242144
17:36:28 10846 8192000000 10923640400 11358748672 1972328368 19.404 100 51 102 0 2018906048 30558112 16019568
17:36:50 3926 8192000000 10941206464 11366379520 1979040176 19.457 100 63 125 3 2028899184 29831872 20027136
17:37:02 4533 8192000000 10951621440 11373182976 1986881232 19.519 100 64 124 1 2036339408 31027376 18430800
17:37:14 6157 8192000000 10942198000 11369299968 1977490176 19.445 100 64 128 0 2030615856 33010400 20115280
17:37:26 3374 8192000000 10940409520 11370348544 1978256304 19.451 100 58 111 0 2027840992 32002208 17582480
17:37:37 5957 8192000000 10953149712 11378954240 1985322400 19.507 100 72 144 2 2042427488 33696048 23409040
17:37:53 2121 8192000000 10964852112 11381104640 1988518048 19.532 100 78 154 1 2045654928 33711376 23425504
17:38:03 8272 8192000000 10960950016 11383435264 1985994608 19.512 100 71 141 3 2043747472 36071680 21681184
17:38:20 3838 8192000000 10961158704 11382083584 1986277936 19.514 100 77 155 0 2048153536 37430720 24444880
17:38:31 11247 8192000000 10948971424 11371757568 1963060336 19.330 99 68 136 0 2019701504 36102432 20538736
17:38:49 4665 8192000000 10937257744 11370950656 1972229248 19.403 100 59 115 4 2028227168 38393264 17604656
17:39:01 10528 8192000000 10925914656 11350921216 1926298544 19.037 97 56 112 2 1980826608 37306656 17221408
17:39:21 7116 8192000000 10940225056 11367301120 1969591424 19.382 100 60 118 0 2028182384 39271168 19319792
17:39:37 8734 8192000000 10952761168 11381231616 1976931120 19.440 100 58 116 0 2036526912 40482432 19113360
17:39:52 3601 8192000000 10957459040 11380781056 1974998496 19.425 100 72 142 1 2041041376 43358688 22684192
17:40:04 5280 8192000000 10916451712 11328417792 1932200320 19.084 98 75 148 0 1998235040 42756304 23278416
17:40:15 1647 8192000000 10954816352 11369136128 1966355840 19.357 100 78 158 0 2036233824 45146352 24731632
17:40:24 2414 8192000000 10963402560 11369394176 1959544240 19.302 99 90 179 1 2034460432 47065392 27850800
17:40:34 2218 8192000000 10962707888 11379900416 1975803824 19.431 100 83 162 0 2049850160 49451456 24594880
17:40:44 1830 8192000000 10975093120 11388256256 1963757952 19.336 99 77 154 2 2036844768 48648992 24437824
17:40:53 3146 8192000000 10970522544 11388350464 1982898384 19.488 100 90 180 0 2061465216 49583824 28983008
17:41:05 2884 8192000000 10976395344 11394838528 1989812992 19.542 100 84 168 0 2059164336 43379232 25972112
17:41:15 1114 8192000000 10979689776 11385155584 1978722048 19.455 99 85 168 2 2048432096 44430848 25279200
17:41:23 1792 8192000000 10968982848 11387805696 1980352528 19.467 100 76 152 1 2049996720 45893952 23750240
17:41:33 2957 8192000000 10954141904 11389530112 1982138448 19.482 100 52 104 3 2043641376 44670384 16832544
17:41:46 1144 8192000000 10981319168 11393454080 1989039088 19.536 100 86 173 1 2056909696 40702384 27168224
17:41:54 4175 8192000000 10947572608 11384995840 1978396848 19.452 100 52 104 2 2038790208 44291024 16102336
17:42:13 7052 8192000000 10927509344 11364249600 1933492880 19.095 98 40 78 2 1990071776 43337344 13241552
17:42:27 4301 8192000000 10949283664 11369234432 1969062016 19.378 100 53 106 1 2029220048 42565568 17592464
17:42:43 1858 8192000000 10959876960 11369553920 1967646704 19.367 100 89 177 2 2041505568 45836224 28022640
17:42:52 2144 8192000000 10965134640 11378270208 1975343984 19.428 100 82 164 1 2045855184 45793440 24717760
17:43:00 11965 8192000000 10908077952 11347636224 1915660544 18.952 98 39 78 1 1975201600 46679920 12861136
17:43:19 20298 8192000000 10909853488 11353432064 1943241200 19.173 100 33 65 3 2002028224 47041888 11745136
17:43:56 21740 8192000000 10910023984 11337326592 1888956352 18.737 97 40 80 1 1952889200 50420800 13512048
17:44:35 14015 8192000000 10901374576 11340206080 1931037136 19.075 100 31 59 3 1989048592 48000208 10011248
17:44:55 12203 8192000000 10915427728 11354419200 1935888464 19.114 100 28 56 0 1997046912 51301744 9856704
17:45:14 18006 8192000000 10932467744 11375075328 1933779744 19.097 99 31 62 1 2003597920 59022400 10795776
17:45:41 36957 8192000000 10897171840 11360079872 1897685136 18.808 97 28 57 2 1958175648 50697424 9793088
17:46:24 22694 8192000000 10904579424 11361206272 1947556112 19.207 100 21 42 5 1989476928 34970832 6949984
17:46:53 24860 8192000000 10894520208 11345616896 1926367952 19.038 99 20 40 2 1971894128 38873040 6653136
17:47:49 27118 8192000000 10892048624 11346264064 1931166176 19.076 100 20 40 0 1976947696 38591536 7189984
17:48:33 56410 8192000000 10870926544 11340419072 1875175856 18.626 97 13 24 0 1920720288 39781056 5763376
17:49:36 79176 8192000000 10857335872 11311370240 1850186688 18.424 96 9 19 0 1873509536 20727504 2595344
17:51:05 119396 8192000000 10859739200 11313807360 1905730608 18.872 99 27 54 1 1923867216 9810640 8325968
17:53:12 55447 8192000000 10831611504 11304599552 1893044720 18.770 98 33 66 2 1914458240 11524592 9888928
17:54:14 73510 8192000000 10853129264 11312766976 1912116304 18.924 100 6 11 0 1921765520 7636864 2012352
17:55:34 123498 8192000000 10859570496 11324702720 1916432624 18.958 99 11 22 0 1929760880 10284384 3043872
17:58:20 60348 8192000000 10853813552 11310485504 1887281824 18.724 97 23 45 1 1901214544 7696096 6236624
17:59:29 73413 8192000000 10868727664 11330691072 1932665152 19.088 99 18 36 1 1945455632 7406976 5383504
18:00:49 85494 8192000000 10855306016 11310837760 1891886208 18.761 97 28 54 2 1905188720 5647728 7654784
18:02:23 37838 8192000000 10860658672 11324219392 1916160032 18.956 98 19 38 1 1930212192 7980752 6071408
18:03:23 48658 8192000000 10898739296 11343548416 1960223760 19.308 100 27 52 2 1975827056 7421760 8181536
18:04:18 34701 8192000000 10900423424 11363581952 1972506352 19.405 100 37 74 3 1993902864 10519120 10877392
18:05:01 51297 8192000000 10890121440 11363700736 1976838464 19.440 100 18 37 0 1992033664 10031680 5163520
18:05:59 49863 8192000000 10894307808 11367948288 1980935472 19.472 100 8 16 0 1991999936 8839504 2224960
18:07:37 58748 8192000000 10906004176 11369783296 1944021632 19.179 98 20 40 2 1960798784 10956256 5820896
18:08:42 109074 8192000000 10895598048 11379855360 1957322336 19.285 99 20 40 0 1981538128 17726240 6489552
18:10:40 48967 8192000000 10882054160 11362402304 1937363744 19.126 98 12 24 0 1949983984 9274240 3346000
18:11:36 33396 8192000000 10909169776 11363086336 1956466288 19.278 99 25 50 1 1970360720 6836704 7057728
18:12:18 80211 8192000000 10908641616 11363622912 1951049744 19.235 99 18 36 0 1965541504 9355472 5136288
18:13:47 31154 8192000000 10931226640 11376058368 1984981040 19.504 100 42 84 2 2007247904 9773584 12493280
18:14:29 76100 8192000000 10906429392 11372384256 1946014720 19.195 98 22 44 1 1968128592 15639440 6474432
18:15:51 53715 8192000000 10917107328 11376758784 1950294128 19.229 98 27 54 1 1971908160 14319184 7294848
18:16:57 115426 8192000000 10889612944 11350974464 1871626400 18.597 94 31 62 0 1896005648 15858224 8521024
18:18:59 66092 8192000000 10878508256 11351457792 1919628576 18.984 98 20 40 2 1948431696 22807952 5995168
18:20:17 84862 8192000000 10878479872 11340320768 1857479136 18.483 95 11 22 1 1869770688 9184704 3106848
18:21:48 136012 8192000000 10858672576 11328815104 1814689584 18.134 93 8 16 0 1829093520 12424656 1979280
18:24:13 96058 8192000000 10862976896 11296591872 1894550992 18.782 98 34 66 1 1915939184 12148528 9239664
18:25:55 68024 8192000000 10822745888 11275464704 1833454224 18.287 95 28 56 2 1850751136 9575952 7720960
18:27:09 36977 8192000000 10848025648 11293368320 1879959504 18.665 98 31 59 2 1905734288 16954048 8820736
18:28:00 1315 8192000000 10860299552 11297427456 1916760912 18.961 100 54 104 2 1941567312 10489296 14317104
18:28:07 21376 8192000000 10864876416 11305111552 1906732096 18.880 99 36 72 1 1928731856 12495664 9504096
18:28:38 28357 8192000000 10832717488 11294011392 1891400128 18.757 98 31 62 2 1914323216 14814656 8108432
18:29:16 77340 8192000000 10824694672 11287113728 1835985056 18.308 95 9 18 0 1848434752 10002960 2446736
18:30:39 59797 8192000000 10826919360 11291635712 1869857536 18.583 98 6 12 0 1881524640 10224816 1442288
18:32:07 75320 8192000000 10854455696 11327434752 1906960768 18.882 99 13 26 0 1935123008 23763760 4398480
18:33:29 46998 8192000000 10827587104 11291750400 1886372224 18.717 98 9 18 0 1904846064 15258720 3215120
18:34:25 11754 8192000000 10875340704 11310493696 1932962304 19.091 100 52 104 2 1954984608 7249568 14772736
18:34:48 27994 8192000000 10863149872 11299672064 1881109824 18.674 97 57 114 0 1907446320 11035440 15301056
18:35:30 23343 8192000000 10841385888 11306033152 1913608304 18.936 100 22 44 2 1929677232 10279168 5789760
18:36:28 66814 8192000000 10868364256 11324887040 1907368416 18.886 98 25 50 1 1927443296 12711776 7363104
18:37:41 47355 8192000000 10887551696 11341365248 1923599568 19.016 99 21 42 0 1944442288 14101280 6741440
18:38:48 63132 8192000000 10850459904 11321561088 1878122608 18.650 97 11 22 1 1899394976 18147264 3125104
18:39:57 61424 8192000000 10867060368 11301101568 1882924224 18.689 98 16 32 2 1906106352 18807248 4374880
18:41:10 26684 8192000000 10885731632 11325616128 1937928896 19.130 100 24 48 0 1954616352 10230720 6456736
18:41:44 43832 8192000000 10890310096 11344809984 1943483296 19.175 100 40 80 0 1970584368 15631104 11469968
18:43:47 83983 8192000000 10863655808 11327381504 1879312976 18.660 97 9 18 0 1901260144 20038272 1908896
18:45:20 119580 8192000000 10870387712 11333357568 1919489616 18.983 99 22 44 0 1936500128 10609280 6401232
18:47:27 76995 8192000000 10868591344 11343405056 1918574416 18.975 98 20 40 0 1937976448 13785216 5616816
18:49:02 51152 8192000000 10861157776 11334819840 1933680480 19.096 99 5 10 1 1941121024 6254752 1185792
18:50:00 64642 8192000000 10864410944 11335946240 1914053200 18.939 98 11 22 0 1923016528 6033168 2930160
18:51:22 55805 8192000000 10872709264 11337814016 1917688256 18.968 98 15 30 0 1936006032 14344064 3973712
18:52:24 60069 8192000000 10889162816 11359031296 1953252832 19.252 100 16 32 1 1971336784 13484080 4599872
18:53:48 58725 8192000000 10888893072 11362185216 1959797968 19.304 100 18 36 0 1978980528 13699376 5483184
18:55:06 58119 8192000000 10891943872 11367063552 1965951216 19.353 100 13 26 0 1979137888 9498800 3687872
18:56:21 64388 8192000000 10908921776 11377340416 1973111088 19.410 100 13 26 1 1984567920 7905392 3551440
18:57:39 54255 8192000000 10913514528 11383431168 1948757152 19.217 98 25 50 0 1966510640 11367696 6385792
18:58:40 43467 8192000000 10924931216 11387252736 1985329456 19.507 100 19 38 0 2003764336 13504192 4930688
18:59:34 57860 8192000000 10942137504 11413475328 2000213264 19.624 100 21 42 3 2028870416 22200288 6456864
19:00:38 92516 8192000000 10920963664 11396472832 1967148544 19.363 99 9 18 2 1997187760 27190096 2849120
19:02:18 93798 8192000000 10893739200 11360223232 1890963280 18.754 95 19 38 2 1910765568 14424704 5377584
19:04:00 24265 8192000000 10932464368 11376545792 1978662112 19.454 100 50 100 0 2001372000 9142240 13567648
19:04:31 51454 8192000000 10917558560 11368329216 1925350400 19.030 97 47 94 0 1949477040 11388592 12738048
19:05:29 62293 8192000000 10894521840 11365998592 1915730240 18.953 97 31 62 1 1936700896 12618976 8351680
19:06:39 84193 8192000000 10894963152 11378171904 1930263232 19.069 98 19 38 0 1952023936 16874480 4886224
19:08:10 48233 8192000000 10901287952 11342778368 1936594144 19.120 98 41 82 1 1962866656 13900432 12372080
19:09:38 99934 8192000000 10906336624 11366875136 1919739824 18.985 97 28 56 1 1935362112 7339664 8282624
19:11:27 26825 8192000000 10885561728 11344142336 1936338192 19.118 98 19 38 0 1949284320 8160864 4785264
19:12:03 51822 8192000000 10880611008 11347861504 1926980256 19.043 98 14 26 1 1938636784 7246336 4410192
19:13:06 64505 8192000000 10858530944 11332284416 1840841456 18.348 94 6 12 0 1852670256 9770160 2058640
19:14:17 42692 8192000000 10866468080 11338219520 1910468384 18.910 98 10 20 0 1930617616 17222080 2927152
19:15:29 73378 8192000000 10885111904 11353284608 1903073232 18.851 97 18 36 2 1921817824 13340800 5403792
19:16:57 70190 8192000000 10880471904 11352854528 1913321120 18.933 98 13 26 0 1938666560 21043296 4302144
19:18:59 46521 8192000000 10845466896 11318140928 1876428944 18.636 97 17 35 0 1901894192 20191856 5273392
19:20:13 66921 8192000000 10856807600 11323183104 1863860928 18.535 96 11 22 1 1881648384 14815472 2971984
19:21:48 65577 8192000000 10863886080 11314786304 1862612864 18.524 96 23 46 0 1886737648 17684720 6440064
19:23:04 95382 8192000000 10857462192 11335684096 1904416160 18.862 99 13 26 0 1928944496 21138592 3389744
19:25:21 105335 8192000000 10323102368 10726694912 1353701776 14.181 70 12 24 1 1366523504 9778128 3043600

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 14-12-2020 19:28:05 to 14-12-2020 19:28:34.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-12-2020 19:28:35 to 14-12-2020 19:28:37.

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          246991
MON$OLDEST_ACTIVE               248002
MON$OLDEST_SNAPSHOT             248002
MON$NEXT_TRANSACTION            248002
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                       2021312
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.33400 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33400 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33400 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 ---
:43: 
:44: mscs-test-161.budzdorov.ru    Mon Dec 14 19:27:10 2020
:45:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:46: 
--- end of diff output ---

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

14.12.20 19:28:38. 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-12-14 19:28:41 No severe PSQL-related problems occured
14.12.20 19:28:42. End of report.