Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 22.02.2021 16:29
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 16852932 kB
MemAvailable 31159908 kB
Buffers 0 kB
Cached 14870172 kB
SwapCached 3892 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-22 16:27:22
DTS_END                         2021-02-22 16:27:22.5360
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58954
TRN_ID                          241076
ATT_ID                          650
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: 9471.10 21952 1136532
customer order: creation 173.32 363 20798
customer order: refuse 14.68 338 1761
order to supplier: creation 47.55 1238 5706
order to supplier: removal 3.49 94248 419
invoice (draft): creation 45.73 3661 5487
invoice (draft): removal 53.68 734 6441
invoice accept: apply 42.77 17070 5132
invoice accept: cancel 49.03 795 5884
customer reserve: creation 3928.18 170 471382
customer reserve: removal 4802.95 54 576354
realization accept: apply 85.88 168 10305
realization accept: cancel 91.40 101 10968
payment from customer: creation 59.84 113 7181
payment from customer: removal 6.14 67 737
payment to supplier: creation 50.33 117 6040
payment to supplier: removal 3.64 84 437
service: total inventory turnovers 4.86 1138 583
service: total monetary turnovers 6.66 33 799
service: aggregate perf. data 0.95 14890 114
service: refresh index statistics 0.03 303660 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-02-2021 16:29:46 to 22-02-2021 16:29:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1584
TEST_TIME 2 4065
TEST_TIME 3 5677
TEST_TIME 4 5757
TEST_TIME 5 5413
TEST_TIME 6 5494
TEST_TIME 7 5607
TEST_TIME 8 5486
TEST_TIME 9 5463
TEST_TIME 10 5680
TEST_TIME 11 5886
TEST_TIME 12 5952
TEST_TIME 13 6016
TEST_TIME 14 6127
TEST_TIME 15 6925
TEST_TIME 16 7339
TEST_TIME 17 7579
TEST_TIME 18 8034
TEST_TIME 19 8564
TEST_TIME 20 8881
TEST_TIME 21 9033
TEST_TIME 22 9203
TEST_TIME 23 9479
TEST_TIME 24 9341
TEST_TIME 25 9426
TEST_TIME 26 9911
TEST_TIME 27 9801
TEST_TIME 28 10082
TEST_TIME 29 10490
TEST_TIME 30 10704
TEST_TIME 31 10472
TEST_TIME 32 10447
TEST_TIME 33 10743
TEST_TIME 34 10643
TEST_TIME 35 10780
TEST_TIME 36 10667
TEST_TIME 37 10483
TEST_TIME 38 10399
TEST_TIME 39 10261
TEST_TIME 40 10254
TEST_TIME 41 10153
TEST_TIME 42 10052
TEST_TIME 43 10026
TEST_TIME 44 10079
TEST_TIME 45 9995
TEST_TIME 46 9911
TEST_TIME 47 10007
TEST_TIME 48 9967
TEST_TIME 49 9940
TEST_TIME 50 9925
TEST_TIME 51 9937
TEST_TIME 52 10050
TEST_TIME 53 9956
TEST_TIME 54 9896
TEST_TIME 55 9986
TEST_TIME 56 9970
TEST_TIME 57 9955
TEST_TIME 58 9967
TEST_TIME 59 9966
TEST_TIME 60 9990
TEST_TIME 61 10089
TEST_TIME 62 10138
TEST_TIME 63 10106
TEST_TIME 64 10201
TEST_TIME 65 10192
TEST_TIME 66 10104
TEST_TIME 67 10024
TEST_TIME 68 10018
TEST_TIME 69 9972
TEST_TIME 70 9924
TEST_TIME 71 9909
TEST_TIME 72 9842
TEST_TIME 73 9792
TEST_TIME 74 9733
TEST_TIME 75 9735
TEST_TIME 76 9643
TEST_TIME 77 9732
TEST_TIME 78 9694
TEST_TIME 79 9725
TEST_TIME 80 9679
TEST_TIME 81 9733
TEST_TIME 82 9751
TEST_TIME 83 9718
TEST_TIME 84 9779
TEST_TIME 85 9763
TEST_TIME 86 9756
TEST_TIME 87 9788
TEST_TIME 88 9818
TEST_TIME 89 9816
TEST_TIME 90 9866
TEST_TIME 91 9816
TEST_TIME 92 9730
TEST_TIME 93 9712
TEST_TIME 94 9681
TEST_TIME 95 9659
TEST_TIME 96 9625
TEST_TIME 97 9562
TEST_TIME 98 9538
TEST_TIME 99 9502
TEST_TIME 100 9557
TEST_TIME 101 9535
TEST_TIME 102 9495
TEST_TIME 103 9474
TEST_TIME 104 9517
TEST_TIME 105 9495
TEST_TIME 106 9523
TEST_TIME 107 9600
TEST_TIME 108 9590
TEST_TIME 109 9626
TEST_TIME 110 9628
TEST_TIME 111 9709
TEST_TIME 112 9665
TEST_TIME 113 9678
TEST_TIME 114 9703
TEST_TIME 115 9648
TEST_TIME 116 9619
TEST_TIME 117 9606
TEST_TIME 118 9589
TEST_TIME 119 9537
TEST_TIME 120 9471

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 22-02-2021 16:29:49 to 22-02-2021 16:29:53.

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 1572571 1572571 0 0.00 0 29650 6 0 0
doc_list_biud 1572567 1572567 0 0.00 0 40628 25 0 0
sp_add_invoice_to_stock 5230 5132 98 1.87 27 165712 17071 0 98
sp_cancel_adding_invoice 5884 5884 0 0.00 4 88131 795 0 0
sp_cancel_client_order 1761 1761 0 0.00 4 11132 339 0 0
sp_cancel_customer_reserve 576354 576354 0 0.00 1 40631 54 0 0
sp_cancel_pay_from_customer 737 737 0 0.00 2 5514 67 0 0
sp_cancel_pay_to_supplier 437 437 0 0.00 3 4690 85 0 0
sp_cancel_supplier_invoice 6454 6441 13 0.20 1 28879 735 0 13
sp_cancel_supplier_order 419 419 0 0.00 8 856815 94248 0 0
sp_cancel_write_off 10968 10968 0 0.00 1 16444 101 0 0
sp_client_order 20798 20798 0 0.00 4 33117 364 0 0
sp_customer_reserve 471382 471382 0 0.00 0 53345 170 0 0
sp_fill_shopping_cart 31979 31979 0 0.00 1 15611 40 0 0
sp_fill_shopping_cart_clo_res 471381 471381 0 0.00 0 15701 13 0 0
sp_get_clo_for_invoice 5128 5128 0 0.00 0 21813 297 0 0
sp_kill_cost_storno 18026 18026 0 0.00 0 11212 49 0 0
sp_kill_qstorno_ret_qs2qd 1170536 1170536 0 0.00 0 40624 30 0 0
sp_kill_qty_storno 617253 617253 0 0.00 0 40628 64 0 0
sp_lock_selected_doc 21293 21293 0 0.00 0 7514 5 0 0
sp_make_cost_storno 28651 28651 0 0.00 0 29204 56 0 0
sp_multiply_rows_for_pdistr 28647 28647 0 0.00 0 8184 27 0 0
sp_multiply_rows_for_qdistr 20798 20798 0 0.00 0 12734 173 0 0
sp_pay_from_customer 7181 7181 0 0.00 4 12838 113 0 0
sp_pay_to_supplier 6040 6040 0 0.00 5 14223 117 0 0
sp_payment_common 13221 13221 0 0.00 2 12827 30 0 0
sp_qd_handle_on_cancel_clo 1761 1761 0 0.00 0 11125 318 0 0
sp_qd_handle_on_invoice_upd_sts 11005 11005 0 0.00 0 25415 318 0 0
sp_qd_handle_on_reserve_upd_sts 10305 10305 0 0.00 0 10505 51 0 0
sp_reserve_write_off 10305 10305 0 0.00 6 11531 169 0 0
sp_supplier_invoice 5487 5487 0 0.00 7 114070 3662 0 0
sp_supplier_order 5706 5706 0 0.00 5 34895 1239 0 0
srv_aggregate_perf_data 114 114 0 0.00 2524 94468 14890 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1856 111783 31778 0 0
srv_find_qd_qs_mism 1087717 1087717 0 0.00 0 11230 5 0 0
srv_make_invnt_saldo 583 583 0 0.00 35 70057 1139 0 0
srv_make_money_saldo 799 799 0 0.00 1 5309 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 166464 376815 303661 0 0
t$perf-abend:sp_add_invoice_to_stock 98 98 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5132 5132 0 0.00 0 13688 175 0 0
t$perf-norm:sp_cancel_adding_invoice 432 432 0 0.00 0 4314 96 0 0
t$perf-norm:sp_cancel_client_order 1761 1761 0 0.00 0 5126 15 0 0
t$perf-norm:sp_cancel_customer_reserve 705 705 0 0.00 0 3162 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 737 737 0 0.00 0 3939 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 437 437 0 0.00 0 4277 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 6443 41 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 21179 1553 0 0
t$perf-norm:sp_cancel_write_off 974 974 0 0.00 0 2907 10 0 0
t$perf-norm:sp_client_order 20799 20799 0 0.00 0 12479 16 0 0
t$perf-norm:sp_customer_reserve 1035 1035 0 0.00 0 3477 7 0 0
t$perf-norm:sp_pay_from_customer 7181 7181 0 0.00 0 3711 7 0 0
t$perf-norm:sp_pay_to_supplier 6040 6040 0 0.00 0 4334 8 0 0
t$perf-norm:sp_reserve_write_off 10305 10305 0 0.00 0 5310 9 0 0
t$perf-norm:sp_supplier_invoice 5487 5487 0 0.00 0 4128 16 0 0
t$perf-norm:sp_supplier_order 5706 5706 0 0.00 0 3663 15 0 0
t$perf-norm:srv_aggregate_perf_data 114 114 0 0.00 0 477 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 262 8 0 0
t$perf-norm:srv_make_invnt_saldo 583 583 0 0.00 0 1178 17 0 0
t$perf-norm:srv_make_money_saldo 799 799 0 0.00 0 1334 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10438 10242 196 1.87 0 5158 19 0 196
v_all_customers 38350 38350 0 0.00 0 77 1 0 0
v_all_suppliers 30844 30844 0 0.00 0 18 1 0 0
v_all_wares 41590 41590 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 864 864 0 0.00 0 4863 23 0 0
v_cancel_client_order 3522 3522 0 0.00 0 2586 5 0 0
v_cancel_customer_prepayment 1474 1474 0 0.00 0 730 4 0 0
v_cancel_customer_reserve 1410 1410 0 0.00 0 1403 6 0 0
v_cancel_payment_to_supplier 874 874 0 0.00 0 1147 8 0 0
v_cancel_supplier_invoice 830 804 26 3.13 0 2692 19 0 26
v_cancel_supplier_order 838 838 0 0.00 0 1356 6 0 0
v_cancel_write_off 1948 1948 0 0.00 0 2960 17 0 0
v_max_id_clo_ord 5701 5701 0 0.00 0 1056 2 0 0
v_max_id_clo_res 1035 1035 0 0.00 0 5099 34 0 0
v_max_id_ord_sup 5481 5481 0 0.00 0 6699 5 0 0
v_max_non_paid_invoice 1800 1800 0 0.00 0 2303 4 0 0
v_max_non_paid_realizn 3692 3692 0 0.00 0 1035 3 0 0
v_min_id_clo_ord 5701 5701 0 0.00 0 1814 5 0 0
v_min_id_clo_res 1035 1035 0 0.00 0 2732 9 0 0
v_min_id_ord_sup 5481 5481 0 0.00 0 5520 8 0 0
v_min_non_paid_invoice 6040 6040 0 0.00 0 10233 22 0 0
v_min_non_paid_realizn 7181 7181 0 0.00 0 12821 18 0 0
v_our_firm 10218 10218 0 0.00 0 18 1 0 0
v_reserve_write_off 20610 20610 0 0.00 0 3662 7 0 0
x_lock_depdocs_on_canc_invoice 11923 11923 0 0.00 0 13671 104 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 15242 318 0 0
x_make_qstorno_1000_1200 5706 5706 0 0.00 2 34888 1160 0 0
x_make_qstorno_1200_2000 5487 5487 0 0.00 4 113681 3518 0 0
x_make_qstorno_2100_3300 471382 471382 0 0.00 0 53344 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-02-2021 16:29:54 to 22-02-2021 16:29:58.

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
13:57:25 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:31 16604 8192000000 10233591904 10536591360 813023136 9.028 65 55 112 0 833622640 2338560 18260944
13:57:58 27608 8192000000 10311601248 10622754816 1362007568 14.255 100 87 175 0 1395748544 4739792 29001184
13:58:38 16820 8192000000 10330447440 10645884928 1386491280 14.475 100 87 174 0 1422105952 6217008 29397664
13:59:05 22360 8192000000 10361250272 10678796288 1412841696 14.709 100 89 178 0 1449224064 6905248 29477120
13:59:38 11428 8192000000 10379420912 10700800000 1436048912 14.915 100 90 180 1 1473671984 7469440 30153632
14:00:00 24578 8192000000 10398736432 10725449728 1450274256 15.040 100 88 176 0 1487090816 8056352 28760208
14:00:44 14303 8192000000 10424492208 10752581632 1478498144 15.288 100 89 178 0 1516148640 8825744 28824752
14:01:08 16920 8192000000 10432135968 10764644352 1489971456 15.389 100 87 174 0 1527468208 9390192 28106560
14:01:44 13227 8192000000 10468038224 10808311808 1526698976 15.708 100 80 160 0 1561583808 9524960 25359872
14:02:06 13840 8192000000 10508207808 10857496576 1566306336 16.051 100 81 162 0 1601041920 9545600 25189984
14:02:39 16078 8192000000 10545357600 10901647360 1604669744 16.379 100 80 160 1 1639118960 10262752 24186464
14:03:06 12704 8192000000 10562397216 10918907904 1620675664 16.516 100 81 162 0 1656691248 11423440 24592144
14:03:29 12185 8192000000 10573473264 10935410688 1637336880 16.657 100 81 161 1 1673172960 11643680 24192400
14:03:53 8383 8192000000 10604867200 10971889664 1665986224 16.899 100 74 148 1 1698502976 11206704 21310048
14:04:10 11743 8192000000 10632720112 10997587968 1686437184 17.071 100 83 166 1 1723121072 12545056 24138832
14:04:28 8200 8192000000 10647680848 11017093120 1705789584 17.234 100 85 170 0 1743365824 13223216 24353024
14:04:43 9700 8192000000 10654052320 11029778432 1713705248 17.300 100 78 156 2 1749577600 13472560 22399792
14:05:02 5956 8192000000 10671060672 11041787904 1732477760 17.456 100 76 152 1 1767008128 12952928 21577440
14:05:15 5780 8192000000 10690246800 11062464512 1743818208 17.550 100 82 162 1 1780276192 13783248 22674736
14:05:28 5720 8192000000 10700120976 11074891776 1760720288 17.690 100 87 173 1 1798399008 12441312 25237408
14:05:40 3804 8192000000 10695973968 11076345856 1764266352 17.720 100 72 144 1 1797025680 12413104 20346224
14:05:51 3549 8192000000 10715078320 11095236608 1783963088 17.882 100 82 163 0 1818254480 11885984 22405408
14:06:01 6105 8192000000 10734039600 11112984576 1791529232 17.944 100 84 170 0 1828325552 12703360 24092960
14:06:14 3614 8192000000 10741745072 11122470912 1800842432 18.021 100 87 172 1 1839202624 14277824 24082368
14:06:24 3107 8192000000 10753346944 11135725568 1807958592 18.079 100 93 186 0 1849010704 14826320 26225792
14:06:34 2944 8192000000 10754149504 11135246336 1808362272 18.082 100 88 176 0 1847598432 15434544 23801616
14:06:43 2863 8192000000 10754705888 11139645440 1815997712 18.145 100 87 171 1 1854069264 14186384 23885168
14:06:53 7120 8192000000 10755993712 11141115904 1817610736 18.158 100 79 158 0 1853607712 13281952 22715024
14:07:07 3519 8192000000 10757344992 11148070912 1822775184 18.200 100 81 160 2 1858934880 13812784 22346912
14:07:17 1811 8192000000 10779828000 11164774400 1837913696 18.324 100 84 168 1 1874348368 12310960 24123712
14:07:26 1780 8192000000 10783684608 11170631680 1843642672 18.370 100 91 182 0 1881980528 13066224 25271632
14:07:34 2435 8192000000 10794511808 11180040192 1852481296 18.442 100 86 172 0 1889140256 12625728 24033232
14:07:43 1932 8192000000 10798358000 11184975872 1858841952 18.494 100 87 173 0 1896179136 12857488 24479696
14:07:51 1771 8192000000 10805206960 11191586816 1862305328 18.522 100 94 188 1 1902505312 14275680 25924304
14:07:59 1664 8192000000 10809696816 11196133376 1869482352 18.580 100 91 182 3 1909949792 14470544 25996896
14:08:07 1548 8192000000 10813701808 11203080192 1867846352 18.567 100 90 180 3 1906716304 13230352 25639600
14:08:16 2329 8192000000 10819364576 11206434816 1874783536 18.623 100 97 194 1 1914985824 11937840 28264448
14:08:24 2219 8192000000 10830022752 11218997248 1876476160 18.637 100 90 182 0 1914366240 12723104 25166976
14:08:33 2410 8192000000 10819818656 11215552512 1876799216 18.639 100 81 159 1 1911982640 12441552 22741872
14:08:42 41864 8192000000 10808742192 11210981376 1875355760 18.628 100 63 126 3 1902286304 8957504 17973040
14:09:30 2017 8192000000 10820019792 11224412160 1884075504 18.698 100 82 162 1 1917882240 10282416 23524320
14:09:40 3960 8192000000 10801884336 11215368192 1877055584 18.641 100 40 81 1 1897200768 8587312 11557872
14:09:53 4125 8192000000 10795533024 11218956288 1879048144 18.657 100 28 56 3 1894336336 7679120 7609072
14:10:03 5181 8192000000 10803941184 11221028864 1882324544 18.684 100 36 72 1 1900141776 7904336 9912896
14:10:15 6474 8192000000 10800134544 11223404544 1882658944 18.687 100 30 61 1 1898316864 7391216 8266704
14:10:29 9576 8192000000 10792948288 11220791296 1881775008 18.679 100 24 47 3 1894182368 6127584 6279776
14:10:48 6575 8192000000 10794562000 11219255296 1883240928 18.691 100 28 56 0 1902554848 12107952 7205968
14:11:03 8071 8192000000 10796737120 11225518080 1886684352 18.719 100 29 58 1 1902055328 7495328 7875648
14:11:22 12603 8192000000 10801367680 11232169984 1893412224 18.773 100 20 39 3 1904594240 5694736 5487280
14:11:41 11634 8192000000 10794436048 11232604160 1893994368 18.778 100 19 38 1 1905600128 5985504 5620256
14:12:01 12548 8192000000 10800906960 11238526976 1898240976 18.812 100 19 38 2 1909516720 5850432 5425312
14:12:20 12219 8192000000 10820735936 11247493120 1902209072 18.844 100 25 48 1 1914899120 5729904 6960144
14:12:39 74809 8192000000 10826882832 11256578048 1905984192 18.874 100 31 63 0 1920480816 5500816 8995808
14:14:00 12957 8192000000 10812032320 11254091776 1905907360 18.874 100 19 38 1 1917631648 5461456 6262832
14:14:21 4985 8192000000 10837995440 11264487424 1914736720 18.945 100 47 95 1 1935679456 7284800 13657936
14:14:32 8230 8192000000 10827661616 11261882368 1911343808 18.917 100 28 56 2 1926744560 7873424 7527328
14:14:50 6647 8192000000 10832257280 11258949632 1892938592 18.769 99 22 44 1 1903956944 5120496 5897856
14:15:04 5798 8192000000 10829447904 11264446464 1909922752 18.906 100 27 53 1 1924056688 6510256 7623680
14:15:16 6238 8192000000 10820883648 11262504960 1911451600 18.918 100 23 46 0 1923580448 5784928 6343920
14:15:29 7007 8192000000 10828315696 11261734912 1912518800 18.927 100 20 41 2 1923950672 5407792 6024080
14:15:42 8979 8192000000 10823352720 11263352832 1913364992 18.934 100 18 34 1 1924540128 6087328 5087808
14:15:58 5026 8192000000 10825806000 11261485056 1911147568 18.916 100 35 70 3 1928013264 6895216 9970480
14:16:11 9997 8192000000 10819062240 11262078976 1907995872 18.891 100 10 20 0 1916796464 5803648 2996944
14:16:28 8562 8192000000 10803635344 11242463232 1890490352 18.750 99 19 38 2 1901914384 5859552 5564480
14:16:43 7047 8192000000 10833738960 11264098304 1911300624 18.917 100 23 46 1 1922805920 5240224 6265072
14:17:02 12177 8192000000 10805517744 11239211008 1875320928 18.627 99 9 18 3 1882906896 5304816 2281152
14:17:31 60529 8192000000 10774435712 11204366336 1760478160 17.688 93 18 34 3 1771359056 5410800 5470096
14:18:39 11552 8192000000 10767975440 11202289664 1837166096 18.318 98 18 37 1 1848089888 5922496 5001296
14:18:56 7229 8192000000 10777535280 11207131136 1846687168 18.395 99 27 54 0 1860327856 5912896 7727792
14:19:14 7233 8192000000 10755341648 11179311104 1811542640 18.109 98 31 62 2 1826619280 5949232 9127408
14:19:30 5823 8192000000 10720848656 11143454720 1735546144 17.482 94 18 36 1 1746338464 5609456 5182864
14:19:44 7186 8192000000 10732241776 11155681280 1800888544 18.021 99 30 60 1 1816410048 6835744 8685760
14:19:59 7679 8192000000 10731753248 11141140480 1719371968 17.347 94 27 54 2 1732292544 4737856 8182720
14:20:14 7704 8192000000 10694288240 11115110400 1707772480 17.250 95 29 58 2 1722367376 5693056 8901840
14:20:31 6336 8192000000 10699683424 11110445056 1742140384 17.536 97 26 52 0 1756098256 5436128 8521744
14:20:43 10719 8192000000 10700970608 11114553344 1719045648 17.344 96 27 55 1 1732883632 5416224 8421760
14:21:00 13337 8192000000 10712023520 11137032192 1782077136 17.867 99 16 31 1 1791853536 5158432 4617968
14:21:20 8302 8192000000 10723531472 11140812800 1781770448 17.864 98 24 46 1 1795005088 6162096 7072544
14:21:39 7965 8192000000 10738685136 11159027712 1817906192 18.161 100 21 42 1 1829661184 4987056 6767936
14:21:53 10482 8192000000 10720448832 11143913472 1756948080 17.659 96 20 40 1 1767998144 4966720 6083344
14:22:14 74756 8192000000 10711944784 11134857216 1716392624 17.322 94 20 39 1 1726453808 4754928 5306256
14:23:35 12250 8192000000 10723157920 11146883072 1802015616 18.030 99 31 62 1 1817372288 6830256 8526416
14:23:53 7488 8192000000 10746961904 11162202112 1821695536 18.192 100 34 68 1 1837094880 6407488 8991856
14:24:10 9027 8192000000 10759105184 11182002176 1838414832 18.328 100 28 56 0 1851930720 6260944 7254944
14:24:25 5207 8192000000 10760206400 11182735360 1841693184 18.355 100 31 62 1 1856456880 6010112 8753584
14:24:38 6034 8192000000 10754013024 11183620096 1844127712 18.374 100 17 34 1 1854944896 5480000 5337184
14:24:50 7640 8192000000 10768514992 11195408384 1849470880 18.418 100 19 38 1 1861008016 6258048 5279088
14:25:05 8859 8192000000 10764064576 11194839040 1851260208 18.432 100 14 28 2 1860963376 6014608 3688560
14:25:21 7535 8192000000 10756978480 11188649984 1850126016 18.423 100 21 42 0 1861693008 5298448 6268544
14:25:36 7572 8192000000 10767273120 11198603264 1860622224 18.508 100 21 42 0 1872232480 5327936 6282320
14:25:49 8353 8192000000 10779701840 11202965504 1861140528 18.513 100 17 34 0 1871529232 5288368 5100336
14:26:06 11103 8192000000 10786949664 11209453568 1864906176 18.543 100 20 38 1 1875581120 5002112 5672832
14:26:29 9792 8192000000 10779767600 11208736768 1865418736 18.547 100 18 36 0 1876408096 6053520 4935840
14:26:50 14513 8192000000 10785475952 11217932288 1873074640 18.609 100 21 42 2 1884742544 5494320 6173584
14:27:11 84099 8192000000 10830183680 11250286592 1899035872 18.819 100 49 95 0 1919080000 5813088 14231040
14:28:43 18458 8192000000 10835472848 11258417152 1910527088 18.911 100 50 100 2 1932160960 7962448 13671424
14:29:09 15183 8192000000 10859277200 11283726336 1921405776 18.998 100 51 102 1 1947151392 12048512 13697104
14:29:31 16383 8192000000 10867792032 11286298624 1929749440 19.065 100 61 121 1 1959439120 12940352 16749328
14:29:55 5918 8192000000 10881914032 11297595392 1937362512 19.126 100 67 133 4 1969425152 13529168 18533472
14:30:07 8167 8192000000 10879195712 11298070528 1942044240 19.163 100 81 161 0 1980211088 15422896 22743952
14:30:25 4351 8192000000 10892708208 11307745280 1943963872 19.178 100 70 138 1 1980069840 16210912 19895056
14:30:36 18600 8192000000 10870434848 11308072960 1942276448 19.165 100 52 104 2 1971321792 14295648 14749696
14:31:06 17810 8192000000 10881656608 11309379584 1942589216 19.167 100 41 80 2 1965702384 11395376 11717792
14:31:36 32553 8192000000 10890043184 11325542400 1952963600 19.250 100 53 106 2 1984759808 15857200 15939008
14:32:27 27631 8192000000 10887972128 11327639552 1943966560 19.178 99 35 72 0 1972662960 18184096 10512304
14:33:06 11619 8192000000 10902324336 11340525568 1959945552 19.306 100 35 70 1 1989655584 18627856 11082176
14:33:25 24946 8192000000 10900886528 11343368192 1968895040 19.377 100 34 68 2 1997248256 17909728 10443488
14:33:58 17727 8192000000 10921480928 11358326784 1976002336 19.433 100 33 65 0 2004272128 18291360 9978432
14:34:24 10325 8192000000 10932351424 11362488320 1986211824 19.514 100 62 124 3 2025952336 20778496 18962016
14:34:45 13864 8192000000 10926034080 11357741056 1981722560 19.478 100 56 112 1 2019940256 21201504 17016192
14:35:08 11138 8192000000 10916633840 11356393472 1981403056 19.476 100 43 84 3 2013050624 19421232 12226336
14:35:28 11320 8192000000 10925586128 11364069376 1985589888 19.509 100 50 100 1 2019878224 19684400 14603936
14:35:54 5866 8192000000 10928708320 11360997376 1968237744 19.371 99 51 100 0 2002833552 19575968 15019840
14:36:08 1877 8192000000 10949251040 11373785088 1992524848 19.564 100 78 154 3 2036535856 21288080 22722928
14:36:19 10853 8192000000 10949884048 11379826688 1992973488 19.567 100 62 124 2 2032833408 21781136 18078784
14:36:44 6192 8192000000 10955994528 11380891648 1998283536 19.609 100 64 128 2 2040277984 22885168 19109280
14:37:01 6760 8192000000 10964130192 11387043840 2002394816 19.642 100 69 135 2 2046529984 23542544 20592624
14:37:16 3842 8192000000 10965525328 11389784064 2006927024 19.677 100 78 154 0 2055494240 25612640 22954576
14:37:26 7498 8192000000 10960619632 11390148608 2003917632 19.654 100 65 130 0 2048537296 25632208 18987456
14:37:47 4616 8192000000 10963972928 11394322432 2010482864 19.705 100 71 140 1 2056736928 25519568 20734496
14:38:09 5667 8192000000 10965444160 11393257472 2007816736 19.684 100 73 147 1 2054950384 24700560 22433088
14:38:24 5547 8192000000 10971105200 11391594496 2004750336 19.660 100 72 143 0 2052295712 25060272 22485104
14:38:40 9836 8192000000 10953273744 11387506688 1998399152 19.610 100 66 131 2 2043531504 25819936 19312416
14:38:56 2711 8192000000 10953312896 11377647616 1974590912 19.422 99 62 124 0 2019345888 25827376 18927600
14:39:06 8119 8192000000 10955156336 11385536512 1997710912 19.605 100 68 138 0 2045863200 27171344 20980944
14:39:22 7015 8192000000 10961700432 11388796928 2001676768 19.636 100 62 122 2 2045412288 25482224 18253296
14:39:38 6542 8192000000 10966495776 11387187200 1980368160 19.468 99 74 144 0 2033806816 31138528 22300128
14:39:51 12144 8192000000 10959674176 11393683456 1993395504 19.571 100 60 118 2 2039927152 28097200 18434448
14:40:10 3980 8192000000 10946717280 11383369728 1982820016 19.487 99 55 108 2 2028472672 28273904 17378752
14:40:25 17343 8192000000 10959749968 11390189568 1998917648 19.614 100 61 121 1 2047341168 29612384 18811136
14:40:52 3413 8192000000 10977871728 11405582336 2008097872 19.687 100 71 141 1 2062432384 31613776 22720736
14:41:10 2594 8192000000 10964030912 11379568640 1982709248 19.486 99 82 164 1 2041510128 34032256 24768624
14:41:22 4289 8192000000 10969937088 11383844864 1981716976 19.478 99 84 168 1 2044936640 36314816 26904848
14:41:34 4928 8192000000 10980236896 11399630848 1996333584 19.594 100 85 169 0 2061608608 38654432 26620592
14:41:46 6621 8192000000 10973066960 11396280320 1995516528 19.587 100 75 150 2 2057581152 38605040 23459584
14:42:02 4783 8192000000 10982577680 11404840960 1998138864 19.608 100 74 149 1 2059790816 38256032 23395920
14:42:14 3092 8192000000 10986612976 11403452416 1995032992 19.584 100 84 166 2 2063825696 42748608 26044096
14:42:30 5537 8192000000 10958466880 11384958976 1974971136 19.425 100 70 139 1 2041375568 44571904 21832528
14:42:43 3610 8192000000 10934732960 11352875008 1940098896 19.148 98 83 166 1 2003681872 37331008 26251968
14:42:54 3180 8192000000 10958024112 11376332800 1975684816 19.431 100 76 152 0 2036047680 35807792 24555072
14:43:04 4238 8192000000 10955268512 11385270272 1986303072 19.515 100 78 156 1 2047975552 37240528 24431952
14:43:16 1853 8192000000 10966501312 11388829696 1986805968 19.519 100 78 155 0 2045295616 34760352 23729296
14:43:30 8484 8192000000 10941412752 11368083456 1948665248 19.216 98 75 149 3 2002907184 30697328 23544608
14:43:46 2973 8192000000 10928226640 11349540864 1953081312 19.251 99 76 151 0 2008590624 32412928 23096384
14:43:56 8977 8192000000 10915258832 11338338304 1941199488 19.156 99 71 142 1 1997113600 34282320 21631792
14:44:12 8080 8192000000 10911898320 11338461184 1937444128 19.126 99 58 115 1 1991198720 35638512 18116080
14:44:30 10655 8192000000 10893383632 11327438848 1912386544 18.926 99 39 75 2 1960711376 36018288 12306544
14:44:51 10749 8192000000 10908098160 11348774912 1944024368 19.179 100 37 73 2 1996507568 40120448 12362752
14:45:09 5252 8192000000 10933120352 11361030144 1953618176 19.255 100 63 124 0 2012516560 38617696 20280688
14:45:21 2456 8192000000 10938485968 11366027264 1938616880 19.136 99 73 145 1 2002517312 41144464 22755968
14:45:31 7451 8192000000 10908063664 11336187904 1930570784 19.071 99 71 142 1 1989117168 36176528 22369856
14:45:50 11390 8192000000 10906519040 11348418560 1947155760 19.204 100 38 76 0 1995263696 34832160 13275776
14:46:08 26351 8192000000 10878144032 11323932672 1870298224 18.587 96 30 60 4 1911355632 30894880 10162528
14:46:41 18931 8192000000 10900985680 11328954368 1899371760 18.821 98 39 77 1 1937915712 26374048 12169904
14:47:18 8191 8192000000 10878379296 11322331136 1929996320 19.067 100 27 55 1 1962180560 23845952 8338288
14:47:37 20869 8192000000 10862879728 11310538752 1907806432 18.889 99 16 32 0 1934457488 21648320 5002736
14:48:05 3449 8192000000 10918500736 11337256960 1935100608 19.108 99 77 153 3 1984124704 25566032 23458064
14:48:16 4513 8192000000 10925891616 11351900160 1955270064 19.268 100 65 129 1 2004749648 30295024 19184560
14:48:32 19067 8192000000 10898444016 11350007808 1931169104 19.076 99 29 59 0 1970406400 30049040 9188256
14:49:07 11979 8192000000 10913296080 11351330816 1950391040 19.230 100 30 60 3 1987589280 27530784 9667456
14:49:26 11407 8192000000 10896505760 11342528512 1913540352 18.935 98 41 82 0 1954956464 28355760 13060352
14:49:49 8542 8192000000 10890064608 11336491008 1922038464 19.003 99 32 65 1 1961938384 29083024 10816896
14:50:05 19141 8192000000 10887181472 11332210688 1904235504 18.860 98 23 46 0 1939303056 27646864 7420688
14:50:34 21639 8192000000 10883205632 11334356992 1908112160 18.891 98 21 42 1 1941651824 26996368 6543296
14:51:04 8991 8192000000 10895725360 11341258752 1941212464 19.156 100 28 54 1 1978066992 28361600 8492928
14:51:23 11167 8192000000 10899414384 11337523200 1923635184 19.016 99 36 72 2 1968694688 32850176 12209328
14:51:44 13983 8192000000 10906091600 11352875008 1942135968 19.164 100 33 68 1 1990442944 37167872 11139104
14:52:11 25404 8192000000 10899648160 11333558272 1910198496 18.908 98 29 57 2 1963968160 44077248 9692416
14:52:43 16343 8192000000 10892097984 11326803968 1901461904 18.838 98 36 72 2 1953973936 41282016 11230016
14:53:29 10245 8192000000 10913753920 11359657984 1940286496 19.149 100 42 84 1 2002680064 48127664 14265904
14:53:46 21104 8192000000 10875306544 11339837440 1919734576 18.985 99 20 40 1 1958229872 32108512 6386784
14:54:34 11596 8192000000 10901200320 11338276864 1925922176 19.034 99 46 92 2 1961567568 22082688 13562704
14:55:19 34836 8192000000 10879770736 11348086784 1916477616 18.959 99 12 24 0 1953480064 32920480 4081968
14:56:00 43078 8192000000 10893125872 11361353728 1905587936 18.871 99 10 20 0 1950187568 40874192 3725440
14:56:51 61413 8192000000 10878161840 11352256512 1900018336 18.826 98 7 14 0 1921799792 20098256 1683200
14:57:59 69847 8192000000 10897416352 11356086272 1921224944 18.997 98 23 46 0 1944792432 17262416 6305072
14:59:23 36712 8192000000 10885062336 11343245312 1917935088 18.970 98 9 18 0 1940189728 19810272 2444368
15:00:06 80672 8192000000 10854916080 11313922048 1852439792 18.442 95 9 18 0 1871363440 16356656 2566992
15:01:34 109952 8192000000 10879607088 11337310208 1918969104 18.979 98 17 33 1 1935438464 11421456 5047904
15:03:39 32285 8192000000 10909871984 11326758912 1944995424 19.187 99 42 85 0 1963149472 6515024 11639024
15:04:19 35833 8192000000 10904670752 11355889664 1968433136 19.373 100 39 78 1 1990289616 10803792 11052688
15:05:06 17086 8192000000 10921429760 11361800192 1974850768 19.424 100 49 98 0 1999783472 10615296 14317408
15:05:38 93798 8192000000 10924297968 11359846400 1957608544 19.287 99 41 82 0 1980212432 9483760 13120128
15:07:19 55766 8192000000 10921918496 11368226816 1975570656 19.430 100 28 54 1 1992601952 9233408 7797888
15:08:21 34209 8192000000 10910714720 11372191744 1970256592 19.387 99 39 77 0 1992934832 11587776 11090464
15:09:07 85043 8192000000 10918167024 11394117632 1989467120 19.540 100 16 32 1 2007111936 12582544 5062272
15:10:39 12936 8192000000 10924874512 11385593856 1979457440 19.460 99 23 46 0 1996204176 10003424 6743312
15:10:58 2263 8192000000 10956698576 11380555776 1998742832 19.613 100 74 150 4 2030422976 9102912 22577232
15:11:07 25213 8192000000 10926653232 11386232832 1994758224 19.581 100 39 78 1 2020494784 14139088 11597472
15:11:41 32534 8192000000 10918831616 11385458688 1977365440 19.444 99 27 54 2 1998031088 12780240 7885408
15:12:21 49168 8192000000 10908077424 11368153088 1912464368 18.926 96 28 56 2 1935014528 14341616 8208544
15:13:22 32056 8192000000 10953601136 11390058496 1988796176 19.534 100 43 83 1 2020397600 17947280 13654144
15:14:02 36826 8192000000 10926718064 11399380992 1993182560 19.569 100 41 82 0 2027983712 22384896 12416256
15:14:45 54805 8192000000 10917481312 11404697600 1991682096 19.557 100 15 30 0 2015972400 19592912 4697392
15:15:50 106103 8192000000 10904387536 11385061376 1953231056 19.252 98 21 41 0 1976560672 17272464 6057152
15:17:42 31420 8192000000 10892336448 11365789696 1946776416 19.201 98 24 49 1 1973075600 17774544 8524640
15:18:29 53255 8192000000 10882052080 11367948288 1938667360 19.136 98 18 36 3 1959727344 16123488 4936496
15:19:35 28312 8192000000 10887783136 11377217536 1971119008 19.394 100 3 6 0 1984237872 12350048 768816
15:20:09 26137 8192000000 10896245312 11363000320 1948579024 19.215 99 19 39 1 1961118880 7136528 5403328
15:20:47 45616 8192000000 10902896256 11350786048 1900447072 18.830 96 38 77 0 1922766560 11544080 10775408
15:21:41 26489 8192000000 10921290688 11376848896 1972693584 19.407 100 49 98 0 1999100096 12600592 13805920
15:22:23 72730 8192000000 10872807632 11335913472 1882248416 18.683 96 7 14 0 1895264240 11177056 1838768
15:23:42 47240 8192000000 10904017328 11342172160 1932941328 19.090 99 24 48 3 1948024960 7732784 7350848
15:24:37 20001 8192000000 10908319168 11362004992 1963771312 19.336 100 30 60 2 1980474736 7913056 8790368
15:25:07 32843 8192000000 10881437264 11338498048 1924108656 19.020 98 26 52 3 1941424320 10399056 6916608
15:25:53 49283 8192000000 10872997968 11345887232 1905701904 18.872 97 20 40 0 1926971104 15681024 5588176
15:26:53 43473 8192000000 10889402096 11353538560 1905634992 18.872 97 11 20 0 1928305680 19914656 2756032
15:28:51 95931 8192000000 10871518576 11336310784 1867267056 18.562 95 17 34 0 1887650752 15930384 4453312
15:30:45 43216 8192000000 10885357728 11356467200 1928443552 19.054 98 16 32 1 1945654832 12646208 4565072
15:31:34 80410 8192000000 10878153600 11342725120 1850009824 18.422 94 6 12 2 1863211984 11816960 1385200
15:33:01 89817 8192000000 10901304640 11357655040 1918633120 18.976 98 26 53 1 1933869712 7894448 7342144
15:34:56 108294 8192000000 10855880960 11329867776 1820929856 18.185 93 23 46 1 1843842000 16151712 6760432
15:36:51 10215 8192000000 10864539904 11336765440 1932850032 19.090 100 22 46 0 1953185184 14426864 5908288
15:37:10 9248 8192000000 10839656016 11315036160 1914246304 18.941 99 15 30 0 1932798752 14420656 4131792
15:37:35 33326 8192000000 10832213120 11307950080 1855554288 18.467 96 20 40 0 1870086656 8957632 5574736
15:38:42 56129 8192000000 10814007328 11267551232 1794369552 17.968 93 21 42 0 1810033616 9710512 5953552
15:39:45 45150 8192000000 10830937808 11299635200 1903275088 18.853 100 13 26 1 1918570368 11041456 4253824
15:40:36 70315 8192000000 10817808816 11282489344 1874840064 18.623 97 21 42 1 1894191904 13335744 6016096
15:41:53 67444 8192000000 10839344736 11320565760 1917123856 18.964 100 14 29 1 1935003744 12950640 4929248
15:43:07 49672 8192000000 10851351888 11317989376 1906514784 18.879 99 13 26 1 1921654336 11454320 3685232
15:44:22 46613 8192000000 10856126400 11335290880 1930668448 19.072 100 11 22 0 1946772096 13033248 3070400
15:45:25 67884 8192000000 10849156288 11338166272 1893151040 18.771 98 7 14 0 1909762960 14370336 2241584
15:46:40 54937 8192000000 10870423744 11330809856 1919954320 18.986 99 21 42 0 1940327760 14430080 5943360
15:47:43 49843 8192000000 10867316352 11337920512 1944930464 19.186 100 17 34 0 1961139696 11151856 5057376
15:48:43 21780 8192000000 10875910464 11335110656 1930569584 19.071 99 38 75 0 1949607664 8563152 10474928
15:49:11 53889 8192000000 10886121360 11349405696 1928135824 19.052 99 21 42 1 1943806176 10008720 5661632
15:50:14 68955 8192000000 10889423184 11356778496 1925608576 19.032 98 29 57 2 1947464032 13779232 8076224
15:51:29 48330 8192000000 10888499168 11362889728 1956472720 19.278 100 7 14 0 1972160768 13834752 1853296
15:52:31 49553 8192000000 10911469440 11364507648 1937030912 19.123 98 41 82 1 1959791344 11697968 11062464
15:53:29 54191 8192000000 10900361056 11357569024 1929794224 19.065 98 40 80 0 1952518592 12084112 10640256
15:54:31 91445 8192000000 10913987728 11391528960 1960675520 19.311 100 22 44 1 1981098704 14162656 6260528
15:56:53 77100 8192000000 10913596128 11387064320 1945359440 19.190 98 14 28 1 1961266560 12359552 3547568
15:58:20 69434 8192000000 10912680080 11386490880 1981781808 19.479 100 14 27 0 1995912592 10174512 3956272
16:00:34 36497 8192000000 10927216912 11405242368 1992514096 19.564 100 23 46 1 2013184432 14557024 6113312
16:01:47 18185 8192000000 10862322832 11334848512 1912199104 18.924 96 23 47 0 1926016336 7923792 5893440
16:02:12 32828 8192000000 10848936928 11331502080 1921979088 19.003 99 5 10 0 1930463584 7353120 1131376
16:02:55 31393 8192000000 10868312192 11352981504 1944617424 19.184 100 6 12 0 1953407328 7443456 1346448
16:03:33 5318 8192000000 10866688688 11353239552 1954966848 19.266 100 4 8 1 1964175840 8364960 844032
16:03:44 19847 8192000000 10891200224 11373490176 1959434688 19.302 100 13 26 1 1969638320 6856528 3347104
16:04:16 32391 8192000000 10900496592 11375538176 1939481600 19.143 98 13 26 0 1953010576 9821888 3707088
16:05:42 67355 8192000000 10887946288 11367936000 1948895568 19.218 99 12 24 3 1965591344 12949760 3746016
16:06:56 15210 8192000000 10903020048 11376758784 1972395280 19.404 100 23 47 0 1995930096 16130656 7404160
16:07:23 36466 8192000000 10901308864 11394445312 1981615024 19.477 100 19 38 0 2000628432 13917248 5096160
16:08:05 59825 8192000000 10892312304 11366395904 1890139200 18.747 95 7 14 0 1898827936 6767344 1921392
16:09:12 38033 8192000000 10874824336 11352125440 1911933152 18.922 97 22 41 2 1927629680 9675600 6020928
16:09:56 48524 8192000000 10902649072 11376201728 1949327920 19.221 99 15 30 3 1965142512 11514400 4300192
16:10:52 51440 8192000000 10900211056 11363155968 1911789552 18.921 97 35 70 0 1936105232 13857904 10457776
16:11:52 38751 8192000000 10917264160 11387084800 1971763088 19.399 100 38 76 0 1996343360 13625792 10954480
16:12:42 111783 8192000000 10889039232 11374354432 1883313344 18.692 95 15 30 0 1904998432 17055056 4630032
16:14:43 93290 8192000000 10878833680 11359358976 1906434144 18.878 97 13 25 2 1927727872 16363232 4930496
16:16:27 76648 8192000000 10861931056 11339788288 1833261120 18.286 94 5 10 0 1849539728 14826304 1452304
16:18:24 65642 8192000000 10885435808 11322986496 1868426032 18.572 96 11 22 0 1886148960 14324048 3398880
16:19:37 25502 8192000000 10908007456 11358826496 1957331776 19.285 100 41 82 1 1978547488 10045344 11170368
16:20:12 61569 8192000000 10898788736 11373633536 1927149744 19.044 98 38 76 1 1951149232 13244784 10754704
16:21:25 89785 8192000000 10874707056 11357343744 1934832640 19.105 99 16 31 1 1955271360 16216192 4222528
16:23:11 47069 8192000000 10839588320 11312656384 1861862416 18.518 96 21 42 1 1876997456 9484752 5650288
16:24:07 40049 8192000000 10861368400 11327483904 1932408432 19.086 100 31 62 0 1950473328 8747712 9317184
16:25:11 46677 8192000000 10820203472 11305271296 1877113984 18.642 98 12 24 0 1888230512 7926000 3190528
16:26:04 47421 8192000000 10840798496 11315793920 1911002384 18.915 99 8 16 0 1922953856 9598160 2353312
16:27:18 11131 8192000000 9713938080 10061152256 855614400 9.456 45 3 5 0 861675232 5580096 480736

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 22-02-2021 16:29:59 to 22-02-2021 16:30:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 98 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-02-2021 16:30:32 to 22-02-2021 16:30:34.

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          240813
MON$OLDEST_ACTIVE               241298
MON$OLDEST_SNAPSHOT             241298
MON$NEXT_TRANSACTION            241298
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                       2050656
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:138: 
:139: mscs-test-161.budzdorov.ru    Mon Feb 22 16:27:39 2021
:140:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:141: 
--- end of diff output ---

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

22.02.21 16:30:35. 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-22 16:30:37 No severe PSQL-related problems occured
22.02.21 16:30:38. End of report.