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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17138220 kB
MemAvailable 31219636 kB
Buffers 0 kB
Cached 14535552 kB
SwapCached 4876 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-01 22:27:17
DTS_END                         2021-02-01 22:27:17.6250
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47514
TRN_ID                          244829
ATT_ID                          691
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: 9639.65 21899 1156758
customer order: creation 177.59 357 21311
customer order: refuse 14.70 370 1764
order to supplier: creation 46.88 1258 5625
order to supplier: removal 3.53 100996 423
invoice (draft): creation 47.78 3221 5734
invoice (draft): removal 54.64 783 6557
invoice accept: apply 42.83 17095 5139
invoice accept: cancel 49.23 709 5908
customer reserve: creation 4048.50 165 485820
customer reserve: removal 4847.48 57 581698
realization accept: apply 87.51 165 10501
realization accept: cancel 84.77 108 10172
payment from customer: creation 61.87 147 7424
payment from customer: removal 5.73 70 688
payment to supplier: creation 50.37 137 6044
payment to supplier: removal 3.43 76 412
service: total inventory turnovers 4.98 1042 598
service: total monetary turnovers 6.97 28 836
service: aggregate perf. data 0.83 21070 100
service: refresh index statistics 0.03 290131 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-02-2021 22:27:55 to 01-02-2021 22:27:57.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2002
TEST_TIME 2 3705
TEST_TIME 3 3914
TEST_TIME 4 3947
TEST_TIME 5 4263
TEST_TIME 6 4658
TEST_TIME 7 5098
TEST_TIME 8 5035
TEST_TIME 9 5537
TEST_TIME 10 5864
TEST_TIME 11 6005
TEST_TIME 12 6359
TEST_TIME 13 6420
TEST_TIME 14 6605
TEST_TIME 15 6719
TEST_TIME 16 7330
TEST_TIME 17 7846
TEST_TIME 18 8614
TEST_TIME 19 8782
TEST_TIME 20 8580
TEST_TIME 21 8842
TEST_TIME 22 9111
TEST_TIME 23 9343
TEST_TIME 24 9318
TEST_TIME 25 9816
TEST_TIME 26 10081
TEST_TIME 27 10812
TEST_TIME 28 11574
TEST_TIME 29 11343
TEST_TIME 30 11701
TEST_TIME 31 11396
TEST_TIME 32 11318
TEST_TIME 33 11150
TEST_TIME 34 10903
TEST_TIME 35 11076
TEST_TIME 36 10993
TEST_TIME 37 10759
TEST_TIME 38 10667
TEST_TIME 39 10560
TEST_TIME 40 10529
TEST_TIME 41 10483
TEST_TIME 42 10462
TEST_TIME 43 10545
TEST_TIME 44 10473
TEST_TIME 45 10319
TEST_TIME 46 10371
TEST_TIME 47 10399
TEST_TIME 48 10345
TEST_TIME 49 10325
TEST_TIME 50 10370
TEST_TIME 51 10355
TEST_TIME 52 10359
TEST_TIME 53 10376
TEST_TIME 54 10396
TEST_TIME 55 10348
TEST_TIME 56 10351
TEST_TIME 57 10186
TEST_TIME 58 10147
TEST_TIME 59 10120
TEST_TIME 60 10049
TEST_TIME 61 10037
TEST_TIME 62 10035
TEST_TIME 63 9969
TEST_TIME 64 9918
TEST_TIME 65 9913
TEST_TIME 66 9918
TEST_TIME 67 9870
TEST_TIME 68 9888
TEST_TIME 69 9974
TEST_TIME 70 9917
TEST_TIME 71 9872
TEST_TIME 72 9921
TEST_TIME 73 10022
TEST_TIME 74 10039
TEST_TIME 75 10015
TEST_TIME 76 10071
TEST_TIME 77 10066
TEST_TIME 78 10026
TEST_TIME 79 9926
TEST_TIME 80 9924
TEST_TIME 81 9878
TEST_TIME 82 9876
TEST_TIME 83 9813
TEST_TIME 84 9803
TEST_TIME 85 9753
TEST_TIME 86 9697
TEST_TIME 87 9704
TEST_TIME 88 9685
TEST_TIME 89 9666
TEST_TIME 90 9729
TEST_TIME 91 9742
TEST_TIME 92 9735
TEST_TIME 93 9784
TEST_TIME 94 9785
TEST_TIME 95 9798
TEST_TIME 96 9806
TEST_TIME 97 9798
TEST_TIME 98 9856
TEST_TIME 99 9860
TEST_TIME 100 9850
TEST_TIME 101 9875
TEST_TIME 102 9859
TEST_TIME 103 9781
TEST_TIME 104 9779
TEST_TIME 105 9731
TEST_TIME 106 9733
TEST_TIME 107 9697
TEST_TIME 108 9678
TEST_TIME 109 9630
TEST_TIME 110 9637
TEST_TIME 111 9631
TEST_TIME 112 9604
TEST_TIME 113 9609
TEST_TIME 114 9576
TEST_TIME 115 9650
TEST_TIME 116 9668
TEST_TIME 117 9671
TEST_TIME 118 9665
TEST_TIME 119 9710
TEST_TIME 120 9640

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 01-02-2021 22:27:58 to 01-02-2021 22:28:02.

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 1603672 1603672 0 0.00 0 16402 6 0 0
doc_list_biud 1603671 1603671 0 0.00 0 78350 26 0 0
sp_add_invoice_to_stock 5209 5139 70 1.34 40 157453 17095 0 70
sp_cancel_adding_invoice 5908 5908 0 0.00 6 97848 710 0 0
sp_cancel_client_order 1764 1764 0 0.00 4 14406 371 0 0
sp_cancel_customer_reserve 581698 581698 0 0.00 1 72228 58 0 0
sp_cancel_pay_from_customer 688 688 0 0.00 3 4978 71 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 2536 77 0 0
sp_cancel_supplier_invoice 6566 6557 9 0.13 2 78358 784 0 9
sp_cancel_supplier_order 423 423 0 0.00 7 934716 100997 0 0
sp_cancel_write_off 10172 10172 0 0.00 1 9011 108 0 0
sp_client_order 21311 21311 0 0.00 3 68748 358 0 0
sp_customer_reserve 485820 485820 0 0.00 0 80195 166 0 0
sp_fill_shopping_cart 32658 32658 0 0.00 1 13903 38 0 0
sp_fill_shopping_cart_clo_res 485820 485820 0 0.00 0 23710 14 0 0
sp_get_clo_for_invoice 5139 5139 0 0.00 0 34125 334 0 0
sp_kill_cost_storno 17180 17180 0 0.00 0 10077 53 0 0
sp_kill_qstorno_ret_qs2qd 1180548 1180548 0 0.00 0 78347 31 0 0
sp_kill_qty_storno 622161 622161 0 0.00 0 78349 67 0 0
sp_lock_selected_doc 21497 21497 0 0.00 0 8815 5 0 0
sp_make_cost_storno 29108 29108 0 0.00 0 16322 52 0 0
sp_multiply_rows_for_pdistr 29107 29107 0 0.00 0 9375 29 0 0
sp_multiply_rows_for_qdistr 21311 21311 0 0.00 0 63458 165 0 0
sp_pay_from_customer 7424 7424 0 0.00 4 30152 148 0 0
sp_pay_to_supplier 6044 6044 0 0.00 4 36625 137 0 0
sp_payment_common 13468 13468 0 0.00 1 36248 43 0 0
sp_qd_handle_on_cancel_clo 1764 1764 0 0.00 0 14399 326 0 0
sp_qd_handle_on_invoice_upd_sts 11047 11047 0 0.00 0 16669 305 0 0
sp_qd_handle_on_reserve_upd_sts 10500 10500 0 0.00 0 15663 49 0 0
sp_reserve_write_off 10501 10501 0 0.00 6 15755 165 0 0
sp_supplier_invoice 5734 5734 0 0.00 7 79559 3222 0 0
sp_supplier_order 5625 5625 0 0.00 5 29319 1259 0 0
srv_aggregate_perf_data 100 100 0 0.00 2451 474438 21071 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 880 147567 32534 0 0
srv_find_qd_qs_mism 1105637 1105637 0 0.00 0 16400 5 0 0
srv_make_invnt_saldo 598 598 0 0.00 42 53495 1042 0 0
srv_make_money_saldo 836 836 0 0.00 1 6504 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 95993 516110 290131 0 0
t$perf-abend:sp_add_invoice_to_stock 70 70 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5139 5139 0 0.00 0 12609 154 0 0
t$perf-norm:sp_cancel_adding_invoice 411 411 0 0.00 0 7440 121 0 0
t$perf-norm:sp_cancel_client_order 1764 1764 0 0.00 0 3142 11 0 0
t$perf-norm:sp_cancel_customer_reserve 708 708 0 0.00 0 3931 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 688 688 0 0.00 0 375 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 7629 27 0 0
t$perf-norm:sp_cancel_supplier_invoice 428 428 0 0.00 0 2180 21 0 0
t$perf-norm:sp_cancel_supplier_order 423 423 0 0.00 0 26472 1598 0 0
t$perf-norm:sp_cancel_write_off 1024 1024 0 0.00 0 6190 10 0 0
t$perf-norm:sp_client_order 21311 21311 0 0.00 0 12952 18 0 0
t$perf-norm:sp_customer_reserve 1072 1072 0 0.00 0 1373 4 0 0
t$perf-norm:sp_pay_from_customer 7424 7424 0 0.00 0 15184 12 0 0
t$perf-norm:sp_pay_to_supplier 6044 6044 0 0.00 0 9759 12 0 0
t$perf-norm:sp_reserve_write_off 10501 10501 0 0.00 0 12139 10 0 0
t$perf-norm:sp_supplier_invoice 5734 5734 0 0.00 0 6025 16 0 0
t$perf-norm:sp_supplier_order 5625 5625 0 0.00 0 6072 13 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 967 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 700 10 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 917 19 0 0
t$perf-norm:srv_make_money_saldo 836 836 0 0.00 0 2872 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 10418 10278 140 1.34 0 4899 18 0 140
v_all_customers 38452 38452 0 0.00 0 20 1 0 0
v_all_suppliers 31840 31840 0 0.00 0 93 1 0 0
v_all_wares 42622 42622 0 0.00 0 95 1 0 0
v_cancel_adding_invoice 822 822 0 0.00 0 810 7 0 0
v_cancel_client_order 3528 3528 0 0.00 0 2947 5 0 0
v_cancel_customer_prepayment 1376 1376 0 0.00 0 3084 8 0 0
v_cancel_customer_reserve 1416 1416 0 0.00 0 4761 11 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 2504 8 0 0
v_cancel_supplier_invoice 874 856 18 2.05 0 923 16 0 18
v_cancel_supplier_order 846 846 0 0.00 0 2773 9 0 0
v_cancel_write_off 2048 2048 0 0.00 0 2472 14 0 0
v_max_id_clo_ord 5625 5625 0 0.00 0 424 1 0 0
v_max_id_clo_res 1072 1072 0 0.00 0 1834 9 0 0
v_max_id_ord_sup 5722 5722 0 0.00 0 3386 4 0 0
v_max_non_paid_invoice 1471 1471 0 0.00 0 596 4 0 0
v_max_non_paid_realizn 4054 4054 0 0.00 0 3426 6 0 0
v_min_id_clo_ord 5625 5625 0 0.00 0 2907 6 0 0
v_min_id_clo_res 1072 1072 0 0.00 0 1990 8 0 0
v_min_id_ord_sup 5722 5722 0 0.00 0 5258 5 0 0
v_min_non_paid_invoice 6044 6044 0 0.00 0 36243 27 0 0
v_min_non_paid_realizn 7424 7424 0 0.00 0 30118 28 0 0
v_our_firm 10910 10910 0 0.00 0 13 1 0 0
v_reserve_write_off 21000 21000 0 0.00 0 4905 6 0 0
x_lock_depdocs_on_canc_invoice 12037 12037 0 0.00 0 11076 99 0 0
x_lock_depdocs_on_canc_sup_ord 423 423 0 0.00 0 6562 300 0 0
x_make_qstorno_1000_1200 5625 5625 0 0.00 2 29313 1188 0 0
x_make_qstorno_1200_2000 5734 5734 0 0.00 4 79549 3076 0 0
x_make_qstorno_2100_3300 485820 485820 0 0.00 0 80194 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-02-2021 22:28:03 to 01-02-2021 22:28:07.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:21 1 8192000000 8798930416 8809578496 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:27 16246 8192000000 10234257824 10537275392 938203584 10.275 75 59 117 2 962042080 2731696 21106800
19:57:51 28700 8192000000 10336342928 10649956352 1375266528 14.374 100 85 169 1 1407521776 4594624 27660624
19:58:29 25750 8192000000 10367546928 10687041536 1421547888 14.786 100 89 178 0 1460862592 10413168 28901536
19:59:02 10173 8192000000 10380870768 10706137088 1438965584 14.941 100 87 174 0 1474743632 6747552 29030496
19:59:23 19356 8192000000 10415385008 10743885824 1467804736 15.194 100 84 167 0 1501173312 7119216 26249360
19:59:53 22619 8192000000 10443564784 10775457792 1491820464 15.405 100 91 182 0 1529485136 8196784 29467888
20:00:26 13017 8192000000 10452131424 10785468416 1509294624 15.557 100 88 177 1 1545948160 8912336 27741200
20:00:46 21273 8192000000 10468852128 10809536512 1522665840 15.673 100 80 160 0 1556608288 9097648 24844800
20:01:19 16674 8192000000 10490491776 10833498112 1544510048 15.863 100 78 156 1 1577926272 9168656 24247568
20:01:46 17235 8192000000 10512523600 10860187648 1567272560 16.059 100 81 162 1 1601807248 9973264 24561424
20:02:11 12769 8192000000 10523793376 10877652992 1582122784 16.186 100 79 158 0 1615676960 10370880 23183296
20:02:32 16007 8192000000 10544088400 10902523904 1604166640 16.375 100 73 146 0 1635993024 10570704 21255680
20:02:56 9716 8192000000 10574227536 10933362688 1632059184 16.612 100 76 152 1 1664841616 10406160 22376272
20:03:15 9976 8192000000 10589575248 10952073216 1650912272 16.772 100 82 164 3 1686230704 10973888 24344544
20:03:32 10647 8192000000 10602500208 10968293376 1666656016 16.905 100 77 154 1 1700636512 11415728 22564768
20:03:51 14061 8192000000 10619993904 10989748224 1682422288 17.038 100 76 151 2 1715783776 11543664 21817824
20:04:12 8352 8192000000 10638119168 11007221760 1697966272 17.168 100 73 145 1 1730355872 11400496 20989104
20:04:28 7544 8192000000 10655151232 11030548480 1718621312 17.341 100 76 152 3 1752240064 11561264 22057488
20:04:44 5611 8192000000 10663480928 11038912512 1726808832 17.409 100 74 148 2 1758616496 10813360 20994304
20:04:57 7223 8192000000 10673222752 11050758144 1739986144 17.519 100 78 158 2 1774662672 12387648 22288880
20:05:11 6354 8192000000 10682427264 11060596736 1751358752 17.613 100 76 151 2 1784658096 12282224 21017120
20:05:25 4792 8192000000 10698170256 11074453504 1764200864 17.719 100 80 160 0 1798828304 12545088 22082352
20:05:37 11722 8192000000 10707132816 11091329024 1775267808 17.810 100 71 142 0 1807565120 12350896 19946416
20:05:57 4903 8192000000 10722957728 11110670336 1787688320 17.913 100 71 140 1 1819223600 12137008 19398272
20:06:09 3181 8192000000 10738675984 11120377856 1801849504 18.029 100 81 160 0 1837376896 12761952 22765440
20:06:19 5517 8192000000 10736584160 11129520128 1810922176 18.103 100 80 160 0 1845518416 12263552 22332688
20:06:32 3853 8192000000 10762599984 11146985472 1820094272 18.178 100 86 172 1 1856694304 12815456 23784576
20:06:43 3233 8192000000 10764307872 11149053952 1824286816 18.213 100 85 170 1 1861650368 13484768 23878784
20:06:53 2660 8192000000 10776168368 11161939968 1830987984 18.267 100 91 181 3 1870589840 14304880 25296976
20:07:02 2379 8192000000 10778558656 11162095616 1836759024 18.314 100 90 178 2 1876581200 15174832 24647344
20:07:11 2781 8192000000 10783733152 11171045376 1838523376 18.329 100 90 180 3 1879407520 15546576 25337568
20:07:21 2773 8192000000 10784495216 11169914880 1841301328 18.351 100 89 178 0 1882037680 15151200 25585152
20:07:30 2118 8192000000 10786052000 11173654528 1846105136 18.390 100 96 187 3 1886858048 14813024 25939888
20:07:39 2590 8192000000 10788795456 11181776896 1847688304 18.403 100 91 180 0 1887634832 14366368 25580160
20:07:48 3830 8192000000 10775609472 11174367232 1846870768 18.397 100 81 161 1 1883293120 12805232 23617120
20:07:58 1931 8192000000 10797631136 11184582656 1850627952 18.427 100 93 186 2 1890629200 13462304 26538944
20:08:07 2152 8192000000 10798344320 11183308800 1854264752 18.457 100 96 192 3 1895831040 14140704 27425584
20:08:16 3356 8192000000 10803296832 11191681024 1857422960 18.482 100 94 185 0 1897410368 14279968 25707440
20:08:32 1574 8192000000 10801774160 11189321728 1856534400 18.475 100 87 175 0 1894428528 13736224 24157904
20:08:40 2437 8192000000 10806991520 11195662336 1861057712 18.512 100 91 182 1 1900336400 13384448 25894240
20:08:49 1389 8192000000 10809308720 11197431808 1862187168 18.521 100 91 180 2 1900217024 12536880 25492976
20:08:56 4658 8192000000 10784715008 11192913920 1856312784 18.473 100 47 93 3 1879369744 10500448 12556512
20:09:07 7111 8192000000 10781254800 11198967808 1865946544 18.551 100 50 100 0 1890249328 10623536 13679248
20:09:21 22687 8192000000 10789362608 11196792832 1864921872 18.543 100 54 109 4 1888612240 6159168 17531200
20:09:50 9350 8192000000 10773033968 11202199552 1867374160 18.563 100 30 60 1 1883366240 7826240 8165840
20:10:09 4882 8192000000 10793132016 11206062080 1873336864 18.611 100 45 90 2 1893012256 6586976 13088416
20:10:20 4729 8192000000 10787025104 11207610368 1872467520 18.604 100 39 78 1 1891784544 9074528 10242496
20:10:31 3769 8192000000 10786652528 11208597504 1871366736 18.595 100 26 52 0 1885537216 6366608 7803872
20:10:42 6388 8192000000 10780846976 11208355840 1876162800 18.634 100 27 54 0 1892195648 7393600 8639248
20:10:55 7360 8192000000 10782304176 11210158080 1874109808 18.618 100 24 47 2 1886614800 6140928 6364064
20:11:09 3870 8192000000 10792656288 11219083264 1883134560 18.690 100 44 88 2 1903865440 8332336 12398544
20:11:21 5887 8192000000 10790092192 11215785984 1879209392 18.659 100 23 46 1 1891911552 6752000 5950160
20:11:35 9969 8192000000 10801963568 11221848064 1883837488 18.696 100 21 42 2 1895675344 6685376 5152480
20:11:51 11380 8192000000 10793048528 11219980288 1881109744 18.674 100 16 33 0 1892081136 6014464 4956928
20:12:09 11119 8192000000 10800599520 11229908992 1889986640 18.746 100 18 36 0 1900884048 5882784 5014624
20:12:27 10077 8192000000 10795089872 11228745728 1893391792 18.773 100 29 58 3 1908262000 5576704 9293504
20:12:46 68376 8192000000 10808940336 11244949504 1901067312 18.835 100 42 85 3 1919184848 5740288 12377248
20:14:01 12444 8192000000 10827366368 11252641792 1902911776 18.850 100 36 68 2 1919495408 7068576 9515056
20:14:21 4441 8192000000 10822496032 11252465664 1904844608 18.865 100 36 71 6 1922497376 7707696 9945072
20:14:32 4120 8192000000 10824243104 11253882880 1905822704 18.873 100 34 69 0 1922654224 7039184 9792336
20:14:47 6420 8192000000 10816321968 11252563968 1906173712 18.876 100 36 72 1 1923396784 7337520 9885552
20:15:00 7504 8192000000 10820590880 11259797504 1904370656 18.861 100 21 41 1 1919691344 9946576 5374112
20:15:17 5990 8192000000 10815574048 11253387264 1906737472 18.880 100 25 50 3 1919474128 5206448 7530208
20:15:29 8640 8192000000 10817334416 11258032128 1911238352 18.917 100 21 42 1 1924065392 5960944 6866096
20:15:47 8595 8192000000 10812745408 11255508992 1907530288 18.887 100 22 45 2 1919315712 5573584 6211840
20:16:02 6289 8192000000 10807917600 11235627008 1885378976 18.709 99 24 48 0 1898849136 6780928 6689232
20:16:16 6096 8192000000 10807132496 11245080576 1889628320 18.743 99 27 54 2 1902399680 5107648 7663712
20:16:28 4232 8192000000 10802113728 11236159488 1891097712 18.755 100 35 69 2 1907824720 6547760 10179248
20:16:39 9216 8192000000 10807281072 11237642240 1890683968 18.751 100 22 44 2 1902885872 6162960 6038944
20:16:54 10320 8192000000 10819650736 11252236288 1899173728 18.820 100 15 30 1 1912314560 9466048 3674784
20:17:15 7619 8192000000 10813387184 11249672192 1898405552 18.813 100 25 50 1 1920631136 15166224 7059360
20:17:29 58920 8192000000 10838825120 11242123264 1867065744 18.561 98 65 131 2 1891758464 5650368 19042352
20:18:37 9443 8192000000 10799504848 11231932416 1876474320 18.637 99 22 44 0 1893191376 10655200 6061856
20:18:53 8596 8192000000 10785248848 11213832192 1832656688 18.281 97 23 46 2 1844689056 5524752 6507616
20:19:10 6489 8192000000 10763973952 11187609600 1822364112 18.197 97 33 66 0 1837986160 6084176 9537872
20:19:25 6792 8192000000 10750114784 11171340288 1802744528 18.036 97 31 62 3 1818135056 6386880 9003648
20:19:38 7154 8192000000 10761133952 11181998080 1815374544 18.140 98 37 73 2 1833037536 6318640 11344352
20:19:51 5067 8192000000 10714032432 11130142720 1748876976 17.592 95 29 58 1 1764698880 7181312 8640592
20:20:04 7470 8192000000 10731782096 11156299776 1775286624 17.811 97 23 46 0 1787242576 5291552 6664400
20:20:18 8177 8192000000 10693202352 11110535168 1728608448 17.424 96 27 53 0 1742228224 6583024 7036752
20:20:36 8078 8192000000 10670848704 11089600512 1749041920 17.594 99 14 27 4 1758184400 5232000 3910480
20:20:50 7954 8192000000 10670540832 11086479360 1705165136 17.228 96 25 49 1 1717657936 4939072 7553728
20:21:08 6650 8192000000 10653955552 11072675840 1708124464 17.253 97 19 38 0 1719309200 5659680 5525056
20:21:21 6012 8192000000 10694536816 11097174016 1736872352 17.493 98 32 64 0 1752259696 5136064 10251280
20:21:35 6118 8192000000 10713634352 11122257920 1793270176 17.959 100 32 65 1 1809446512 5640000 10536336
20:21:48 11094 8192000000 10698351936 11119501312 1772851424 17.791 99 18 36 1 1783835376 5539392 5444560
20:22:05 51101 8192000000 10718509216 11124678656 1763814432 17.716 98 30 58 2 1777508288 4900000 8793856
20:23:05 21045 8192000000 10725096208 11148017664 1805957984 18.063 100 19 38 0 1817135184 5565632 5611568
20:23:35 8514 8192000000 10729405840 11155632128 1822231120 18.196 100 30 59 2 1836866944 6257312 8378512
20:23:51 7272 8192000000 10752977856 11174617088 1832759744 18.282 100 47 93 0 1852742736 6979088 13003904
20:24:07 4172 8192000000 10771203488 11183034368 1842717456 18.363 100 50 100 0 1864339520 8237456 13384608
20:24:18 4733 8192000000 10763764112 11182358528 1842122496 18.358 100 36 72 0 1861207104 8836128 10248480
20:24:30 8444 8192000000 10766751984 11191402496 1845997280 18.390 100 38 72 0 1866593024 10064032 10531712
20:24:46 9922 8192000000 10764760176 11192258560 1849967328 18.422 100 26 52 0 1863625680 6140976 7517376
20:25:05 8950 8192000000 10774297728 11200499712 1859119904 18.496 100 33 66 2 1873860288 4929248 9811136
20:25:22 8799 8192000000 10769214576 11199389696 1856460240 18.475 100 17 33 3 1867065296 5710576 4894480
20:25:38 7364 8192000000 10766826480 11199913984 1857167280 18.480 100 21 41 0 1869557984 5644272 6746432
20:25:52 7567 8192000000 10775093344 11204378624 1864586880 18.540 100 33 66 1 1880850032 6865264 9397888
20:26:06 9369 8192000000 10772091120 11206737920 1863373280 18.531 100 26 52 1 1877252384 6006016 7873088
20:26:24 8142 8192000000 10774760320 11208200192 1863394320 18.531 100 17 34 0 1873391856 5362000 4635536
20:26:39 12769 8192000000 10786292336 11211149312 1867275360 18.562 100 31 63 3 1882236864 5647008 9314496
20:26:58 64808 8192000000 10799383136 11223646208 1876114096 18.634 100 24 48 0 1887834848 4753312 6967440
20:28:10 34227 8192000000 10821830608 11243986944 1874843360 18.623 99 36 72 1 1891487184 7003808 9640016
20:28:57 44508 8192000000 10847360704 11277332480 1918429424 18.974 100 50 100 0 1944527008 12070432 14027152
20:29:49 16740 8192000000 10862772928 11290005504 1927016672 19.043 100 35 70 1 1950333424 13531344 9785408
20:30:16 41539 8192000000 10865827344 11301556224 1932463136 19.087 100 34 68 1 1956140592 13415504 10261952
20:31:04 47584 8192000000 10877015232 11317239808 1940325072 19.149 100 24 48 0 1965775440 18005904 7444464
20:31:58 6486 8192000000 10891884304 11323060224 1950673824 19.232 100 40 78 1 1982171504 19662400 11835280
20:32:17 17694 8192000000 10903745536 11330101248 1956422032 19.278 100 50 100 1 1992201360 21212528 14566800
20:32:43 10200 8192000000 10904139024 11336495104 1959887888 19.305 100 54 108 1 2000988912 24194128 16906896
20:33:02 36592 8192000000 10917269280 11351629824 1960724896 19.312 100 45 90 0 1999259408 24390768 14143744
20:33:46 10331 8192000000 10921522544 11355217920 1971190608 19.395 100 45 91 2 2012096144 27117728 13787808
20:34:16 11270 8192000000 10906199728 11339223040 1945557792 19.191 99 41 82 1 1984290896 26045072 12688032
20:34:35 14816 8192000000 10897094000 11336294400 1955597472 19.271 100 39 78 3 1993669440 25702304 12369664
20:35:02 5154 8192000000 10911932048 11348967424 1950964016 19.234 99 47 94 0 1993126000 27132752 15029232
20:35:18 9071 8192000000 10925617872 11355951104 1970928656 19.393 100 57 112 0 2016995808 29194368 16872784
20:35:33 6180 8192000000 10937420256 11361456128 1976050208 19.433 100 66 132 3 2026008768 30048816 19909744
20:35:52 12727 8192000000 10929111392 11359453184 1970873360 19.392 100 60 118 1 2018643232 30693360 17076512
20:36:23 22193 8192000000 10945352032 11381858304 1980561584 19.469 100 48 96 0 2027201872 32252320 14387968
20:36:56 4685 8192000000 10950020048 11380375552 1993049584 19.568 100 54 108 2 2041147008 31839712 16257712
20:37:12 5682 8192000000 10952192368 11384610816 1993734176 19.573 100 62 122 5 2043732752 31491696 18506880
20:37:25 6154 8192000000 10966038464 11392290816 1999746864 19.621 100 63 126 2 2051180832 32047808 19386160
20:37:39 5634 8192000000 10939934944 11367206912 1974915680 19.424 99 65 127 1 2027687408 33822560 18949168
20:37:52 2581 8192000000 10951389328 11374735360 1973880016 19.416 99 74 148 1 2031818736 35877248 22061472
20:38:01 2312 8192000000 10965675168 11381927936 1991189184 19.553 100 86 170 3 2051083984 34437520 25457280
20:38:11 9684 8192000000 10965337728 11388575744 1992286496 19.562 100 77 152 2 2052109760 37184496 22638768
20:38:30 3661 8192000000 10966954704 11391651840 1993748432 19.573 100 71 141 1 2054240608 39894960 20597216
20:38:41 6334 8192000000 10968765888 11399426048 1998491680 19.611 100 69 139 1 2058212544 39141088 20579776
20:38:57 878 8192000000 10990338384 11417030656 2011273488 19.712 100 72 136 2 2075592416 43714688 20604240
20:39:06 3018 8192000000 10995882112 11419729920 2012966608 19.725 100 66 131 0 2076705968 43658144 20081216
20:39:17 2543 8192000000 11003232992 11425497088 2015780256 19.747 100 72 145 2 2082741120 45258592 21702272
20:39:26 4619 8192000000 10992731856 11419205632 2013541296 19.729 100 76 154 1 2081362368 44991952 22829120
20:39:39 2840 8192000000 10996568480 11415146496 2009683024 19.699 100 82 163 1 2077934032 44504896 23746112
20:39:49 2277 8192000000 10987641712 11411255296 2008972544 19.693 100 76 150 1 2074946096 43906416 22067136
20:39:59 7665 8192000000 10996270512 11415220224 2011049120 19.710 100 78 154 0 2078647376 44638256 22960000
20:40:19 2818 8192000000 10995715360 11415396352 2009913184 19.701 100 81 162 1 2081348128 46958496 24476448
20:40:30 1539 8192000000 10975908800 11389120512 1983762320 19.494 99 94 188 0 2060667600 48317456 28587824
20:40:38 2374 8192000000 10989452368 11410649088 2003299984 19.649 100 90 179 0 2079633040 48812224 27520832
20:40:47 2282 8192000000 10985852816 11406745600 1999529136 19.619 100 86 168 4 2074788704 49216432 26043136
20:40:59 3217 8192000000 10970293152 11379236864 1969249056 19.379 98 85 167 0 2045104912 49180288 26675568
20:41:11 4685 8192000000 10986466208 11410096128 2000252816 19.625 100 78 157 1 2076490480 52086112 24151552
20:41:22 1691 8192000000 10982829088 11399548928 1985725536 19.510 99 86 167 1 2066037840 53685360 26626944
20:41:30 2099 8192000000 11003973440 11423240192 2010817216 19.708 100 87 172 0 2090285568 53030432 26437920
20:41:39 1856 8192000000 11011412736 11423195136 1993703408 19.573 99 88 174 2 2073675728 53651600 26320720
20:41:47 1975 8192000000 11009330400 11429552128 2009380080 19.697 100 89 177 1 2094427120 57311664 27735376
20:41:56 3337 8192000000 10995744256 11415650304 1984902160 19.503 99 80 158 2 2066983216 57774048 24307008
20:42:08 5212 8192000000 10978827584 11392970752 1976228272 19.435 99 77 155 1 2059904816 58852352 24824192
20:42:22 3098 8192000000 11001043856 11420041216 1997466368 19.603 100 80 159 0 2082717360 60417040 24833952
20:42:32 2996 8192000000 10974567840 11382837248 1957836352 19.289 98 81 162 2 2044784560 61854624 25093584
20:42:42 2675 8192000000 10992893792 11407151104 1986419824 19.515 100 78 155 1 2073710144 62824432 24465888
20:42:52 3639 8192000000 10987877088 11405000704 1970545936 19.390 99 81 162 2 2059520768 63981504 24993328
20:43:03 4332 8192000000 10990219984 11401236480 1972685024 19.407 99 89 177 0 2067039888 66544992 27809872
20:43:14 7054 8192000000 10983349312 11403141120 1965855488 19.353 99 78 156 3 2057177104 66265024 25056592
20:43:29 6450 8192000000 10979894608 11400765440 1973499808 19.413 100 74 145 1 2064189296 67499760 23189728
20:43:45 1662 8192000000 10991464720 11408560128 1966972032 19.361 99 81 160 0 2059402960 66734448 25696480
20:43:56 6242 8192000000 10984826656 11412824064 1984986848 19.504 100 79 156 1 2076253808 66255376 25011584
20:44:10 4899 8192000000 10965859344 11393785856 1965490176 19.350 99 70 141 0 2041602032 53073840 23038016
20:44:21 6579 8192000000 10977871184 11404021760 1971266016 19.395 99 66 128 1 2047179920 55294768 20619136
20:44:35 3420 8192000000 10961099664 11378434048 1953922528 19.258 99 76 149 4 2033185328 56456880 22805920
20:44:45 5927 8192000000 10957182928 11385159680 1963979520 19.338 100 69 138 1 2043764512 57525616 22259376
20:44:58 6827 8192000000 10937762704 11366604800 1933490080 19.095 99 63 125 1 2010497936 57213008 19794848
20:45:14 3013 8192000000 10970312480 11390283776 1962288800 19.324 100 80 159 1 2052219136 64214144 25716192
20:45:29 25697 8192000000 10914389936 11362320384 1919550320 18.983 98 37 74 0 1984183472 52900688 11732464
20:46:02 19597 8192000000 10905786880 11351232512 1922880768 19.010 99 31 62 2 1982871184 49889760 10100656
20:46:37 24969 8192000000 10900990304 11346567168 1904825904 18.865 98 22 44 1 1963482176 50799392 7856880
20:47:12 6694 8192000000 10916948672 11353976832 1936621408 19.120 100 45 91 1 2004288016 53489184 14177424
20:47:25 10488 8192000000 10912679008 11352965120 1923662016 19.016 99 34 68 0 1991442240 56817744 10962480
20:47:45 11467 8192000000 10936293104 11372978176 1943585792 19.175 100 44 87 7 2011483232 53954128 13943312
20:48:12 22128 8192000000 10943826224 11389706240 1961955408 19.322 100 31 62 2 2028940304 56171616 10813280
20:48:41 16526 8192000000 10949206464 11394957312 1962855856 19.329 100 34 64 2 2030889760 56329184 11704720
20:49:04 10622 8192000000 10930424992 11378208768 1906452064 18.878 97 33 64 1 1971215264 53986320 10776880
20:49:48 15863 8192000000 10932280416 11375378432 1938221216 19.133 99 30 60 5 2001631456 52932160 10478080
20:50:11 8639 8192000000 10961322480 11388116992 1967311312 19.364 100 50 96 1 2038715520 56058640 15345568
20:50:26 5040 8192000000 10947442080 11374419968 1940653792 19.152 99 62 121 1 2018144224 57887440 19602992
20:50:38 7486 8192000000 10939215728 11365683200 1936325152 19.117 99 52 104 0 2009813760 56337472 17151136
20:50:53 17455 8192000000 10929374240 11368083456 1931111840 19.076 99 36 72 0 1995601488 51654832 12834816
20:51:21 33035 8192000000 10936386720 11378995200 1951297568 19.237 100 31 62 1 2015163312 52834160 11031584
20:52:03 12671 8192000000 10940568496 11400269824 1961319728 19.317 100 29 58 1 2027132848 55492000 10321120
20:52:26 17364 8192000000 10940412128 11403202560 1962588000 19.327 100 25 50 1 2024949472 53613744 8747728
20:52:52 31477 8192000000 10940616608 11404763136 1960059680 19.307 100 22 44 0 2023254112 54790592 8403840
20:53:32 4774 8192000000 10942713792 11399008256 1964539808 19.342 100 28 56 2 2029973200 55074672 10358720
20:53:43 8174 8192000000 10927299632 11378348032 1940640400 19.152 99 21 42 2 1998413600 49883008 7890192
20:53:59 19096 8192000000 10924578656 11387121664 1951438864 19.238 100 24 48 1 2013637904 52862848 9336192
20:54:43 33644 8192000000 10888631664 11355648000 1899431056 18.822 98 13 26 2 1941925552 37863968 4630528
20:55:24 51278 8192000000 10867264672 11321479168 1856824096 18.478 97 6 12 1 1879504240 21331072 1349072
20:56:29 29251 8192000000 10855465328 11312136192 1913042944 18.931 100 12 25 1 1932408528 16074800 3290784
20:57:05 43378 8192000000 10865902432 11327922176 1904357040 18.861 99 9 18 1 1924382384 17565776 2459568
20:57:56 129854 8192000000 10877734320 11335942144 1902296896 18.845 98 22 45 1 1927093936 19383872 5413168
21:00:17 147567 8192000000 10875630256 11348721664 1908032976 18.891 98 28 56 0 1937301584 20784368 8484240
21:02:51 82939 8192000000 10836252944 11304890368 1844800464 18.380 95 15 30 0 1861820384 12709040 4310880
21:04:22 15201 8192000000 10848213888 11304050688 1911893712 18.922 100 16 32 2 1932169808 16073344 4202752
21:04:45 25901 8192000000 10862976608 11311497216 1927216720 19.045 100 22 44 2 1948957472 15687232 6053520
21:05:18 136082 8192000000 10896375648 11350962176 1902979520 18.850 97 37 75 1 1927664768 14394672 10290576
21:07:53 67175 8192000000 10893212640 11366789120 1940865104 19.154 99 19 38 2 1969425984 23060704 5500176
21:09:19 119637 8192000000 10874049104 11364442112 1942212640 19.164 99 16 32 1 1963821472 16887616 4721216
21:11:24 15136 8192000000 10875439040 11343745024 1937139152 19.124 99 17 34 0 1958229280 15648256 5441872
21:11:46 33710 8192000000 10881208224 11356954624 1957283712 19.284 100 10 20 0 1974653136 14402848 2966576
21:12:26 41712 8192000000 10904799328 11370557440 1970897856 19.393 100 27 54 0 1992262352 13488992 7875504
21:13:31 55532 8192000000 10900412512 11380584448 1945991376 19.195 99 13 26 0 1967538880 17636048 3911456
21:14:48 78282 8192000000 10936530160 11384012800 1974757024 19.423 100 21 43 2 1989575424 8360480 6457920
21:16:17 86173 8192000000 10918005648 11381248000 1921840272 19.002 97 23 46 1 1948083664 19780512 6462880
21:18:12 32814 8192000000 10901789344 11376848896 1973678480 19.415 100 7 14 0 1983450848 8214736 1557632
21:19:08 64025 8192000000 10936093520 11401613312 1989622736 19.541 100 22 44 2 2011393472 16310976 5459760
21:20:21 89763 8192000000 10923518384 11396988928 1947338272 19.205 98 10 20 0 1964519488 14367680 2813536
21:22:06 50241 8192000000 10923375040 11389960192 1956121888 19.275 98 23 46 0 1974455632 11566224 6767520
21:23:13 20186 8192000000 10934232976 11400372224 1970850304 19.392 99 29 58 0 1996023280 17324928 7848048
21:23:43 84451 8192000000 10942537040 11393581056 1992798896 19.566 100 40 77 2 2015059664 10803216 11457552
21:25:14 117585 8192000000 10915163280 11400208384 1946859344 19.201 97 24 48 1 1966033264 12540352 6633568
21:27:20 9063 8192000000 10916087440 11398864896 1967546704 19.366 99 10 20 0 1987929072 17628720 2753648
21:27:35 3982 8192000000 10904558528 11395211264 1981401600 19.476 100 5 10 0 1999998768 17433344 1163824
21:27:46 9245 8192000000 10915388192 11388375040 1961742560 19.320 99 9 18 0 1981833744 17571952 2519232
21:28:02 21612 8192000000 10921551968 11380695040 1963029680 19.330 99 23 42 1 1977981856 8933520 6018656
21:28:32 70382 8192000000 10910992512 11401461760 1990131520 19.545 100 8 16 0 2001116656 9179920 1805216
21:29:52 49145 8192000000 10898074288 11389636608 1956087440 19.275 98 6 12 0 1966852528 9099264 1665824
21:31:17 49311 8192000000 10907487760 11391705088 1969550688 19.382 99 6 12 0 1977317840 6624928 1142224
21:32:13 65360 8192000000 10901235136 11374055424 1939104208 19.140 98 17 32 0 1952844272 9172272 4567792
21:33:25 30395 8192000000 10904153904 11381772288 1964326624 19.340 99 28 56 2 1982129664 9561616 8241424
21:34:05 38883 8192000000 10919565920 11391307776 1981996384 19.481 100 24 47 0 1997842304 9112112 6733808
21:34:51 41794 8192000000 10906477312 11387469824 1949077776 19.219 98 16 32 0 1966595424 12897760 4619888
21:35:45 78404 8192000000 10831025984 11308806144 1676680016 16.989 85 12 24 2 1695677216 15515664 3481536
21:37:12 14763 8192000000 10877354400 11330564096 1931883056 19.082 100 34 66 0 1948075968 5974656 10218256
21:37:40 29786 8192000000 10892844656 11347558400 1934640384 19.104 99 34 66 0 1955797792 11691360 9466048
21:38:25 32050 8192000000 10913171792 11374448640 1964482144 19.342 100 34 67 0 1986401024 12609520 9309360
21:39:09 70568 8192000000 10863351200 11329822720 1835346144 18.303 94 18 36 0 1856157840 15949184 4862512
21:40:29 96525 8192000000 10845109232 11304660992 1796264032 17.983 93 23 46 2 1815958912 13156144 6538736
21:42:12 40746 8192000000 10872554656 11318480896 1871073856 18.593 97 23 44 1 1886023920 9019136 5930928
21:43:02 16932 8192000000 10887891520 11329191936 1926493760 19.039 100 50 99 0 1950164736 10409776 13261200
21:43:25 19573 8192000000 10861809216 11317473280 1909587616 18.903 99 40 80 0 1935434608 14514128 11332864
21:43:50 75240 8192000000 10864325152 11313926144 1887725232 18.727 98 20 39 1 1903014720 10048576 5240912
21:45:14 120955 8192000000 10822736304 11290587136 1865862784 18.551 97 24 49 0 1883272016 10539696 6869536
21:47:24 56052 8192000000 10825826752 11256221696 1840129648 18.342 96 34 63 2 1855474848 5592928 9752272
21:48:27 17676 8192000000 10830105536 11285164032 1886459776 18.717 99 34 68 0 1904014960 8241184 9314000
21:48:50 21285 8192000000 10823882528 11289112576 1908716896 18.896 100 42 84 1 1929228992 8179920 12332176
21:49:21 52922 8192000000 10811650352 11286122496 1857288688 18.481 97 14 28 0 1868025216 6793680 3942848
21:50:37 52541 8192000000 10821645568 11295821824 1906564320 18.879 100 18 35 0 1918924112 6760160 5599632
21:51:42 44914 8192000000 10810292208 11281944576 1842994880 18.365 97 4 8 0 1850892704 6563328 1334496
21:52:43 111338 8192000000 10831419664 11314970624 1911136416 18.916 100 13 26 0 1925317744 10269968 3911360
21:54:48 38999 8192000000 10850457408 11306414080 1901591440 18.839 99 14 28 0 1913525104 7760064 4173600
21:55:44 42496 8192000000 10865096928 11336544256 1933125648 19.092 100 18 37 0 1950272608 11566848 5580112
21:56:36 37307 8192000000 10863325792 11330220032 1919434640 18.982 99 23 46 1 1938231104 11577536 7218928
21:57:23 62894 8192000000 10870757712 11338149888 1928692624 19.056 99 10 20 0 1937899664 6661552 2545488
21:58:32 30173 8192000000 10914969504 11359272960 1944755936 19.185 99 35 70 4 1967348240 12676528 9915776
21:59:14 34128 8192000000 10892377072 11361452032 1944472176 19.182 99 20 40 1 1958986800 8840032 5674592
22:00:02 53953 8192000000 10911639072 11370471424 1962710576 19.328 100 22 44 0 1979059408 9656368 6692464
22:01:02 74778 8192000000 10895014784 11354509312 1935804336 19.113 98 21 42 1 1951675776 10273920 5597520
22:02:39 34224 8192000000 10907878656 11374985216 1969830656 19.384 100 20 40 1 1986089632 10592720 5666256
22:03:25 28925 8192000000 10910048000 11371769856 1938206528 19.132 98 43 86 0 1964162400 13914400 12041472
22:04:02 40792 8192000000 10900997616 11372904448 1975906864 19.432 100 31 62 0 1993235360 9146480 8182016
22:04:55 14790 8192000000 10938490656 11393875968 1982840992 19.487 100 36 72 2 2002269632 9257904 10170736
22:05:24 68963 8192000000 10910937408 11392872448 1967085056 19.362 99 22 44 2 1986439088 13266704 6087328
22:06:39 54325 8192000000 10931037744 11394215936 1977146608 19.442 99 39 76 3 2005814336 16884928 11782800
22:08:02 106202 8192000000 10910237296 11373420544 1876293616 18.635 94 20 38 3 1895832160 13955632 5582912
22:10:16 85081 8192000000 10897535840 11377983488 1957784832 19.288 99 31 62 2 1974598608 8251568 8562208
22:11:51 23148 8192000000 10907919808 11385237504 1975619504 19.430 100 25 49 0 1994278608 11791312 6867792
22:12:26 5806 8192000000 10900634032 11374972928 1971555552 19.398 100 26 52 1 1990781280 11930880 7294848
22:12:39 17101 8192000000 10917263680 11380940800 1969661536 19.383 100 34 68 0 1992194224 12636336 9896352
22:13:05 75333 8192000000 10883442032 11377975296 1956289936 19.277 99 16 30 1 1970389488 9560368 4539184
22:14:26 33161 8192000000 10891851120 11372253184 1955670624 19.272 99 9 18 0 1968810944 10463504 2676816
22:15:09 56421 8192000000 10901609024 11387416576 1979175280 19.458 100 7 14 1 1992573536 11331072 2067184
22:16:18 57428 8192000000 10882999920 11373137920 1957363264 19.285 99 15 29 1 1974354720 12771088 4220368
22:17:23 110001 8192000000 10865811792 11328876544 1794537008 17.969 91 7 14 0 1806809632 10421984 1850640
22:19:20 33423 8192000000 10858261872 11329458176 1871443248 18.596 96 26 52 2 1885249168 6839232 6966688
22:20:05 62436 8192000000 10862045824 11327430656 1846122992 18.391 95 19 38 0 1863737184 12049936 5564256
22:21:19 61276 8192000000 10855621920 11326386176 1861850784 18.518 96 23 46 0 1890741472 21881664 7009024
22:22:41 77567 8192000000 10861380768 11333234688 1877453456 18.645 97 18 36 2 1900362128 17611088 5297584
22:24:06 40483 8192000000 10855847696 11326259200 1867237856 18.562 96 20 40 1 1882360624 9492208 5630560
22:24:52 42058 8192000000 10854715296 11323236352 1879800816 18.663 97 45 89 1 1903141280 10925248 12415216
22:26:59 22500 8192000000 8894407744 9055571968 5226656 0.063 1 1 2 0 5350960 62176 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 01-02-2021 22:28:09 to 01-02-2021 22:28:41.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 70 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-02-2021 22:28:42 to 01-02-2021 22:28:44.

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          245136
MON$OLDEST_ACTIVE               245137
MON$OLDEST_SNAPSHOT             245137
MON$NEXT_TRANSACTION            245137
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                       2023936
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.33411 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33411 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33411 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33411 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 ---
--- end of diff output ---

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

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