Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.06.2021 16:33
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 58e1ddde69c44dad93d327777e5becec
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 2021-05-09 08:45
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 4793.92
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 17139356 kB
MemAvailable 31408224 kB
Buffers 0 kB
Cached 14507840 kB
SwapCached 16 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-06-12 16:32:41
DTS_END                         2021-06-12 16:32:41.2330
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41284
TRN_ID                          234644
ATT_ID                          692
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: 9169.71 24200 1100365
customer order: creation 170.16 320 20419
customer order: refuse 14.83 358 1779
order to supplier: creation 47.13 1359 5656
order to supplier: removal 3.30 106871 396
invoice (draft): creation 47.11 3675 5653
invoice (draft): removal 51.56 888 6187
invoice accept: apply 42.45 19923 5094
invoice accept: cancel 46.71 868 5605
customer reserve: creation 3933.88 196 472065
customer reserve: removal 4507.75 60 540930
realization accept: apply 84.38 189 10126
realization accept: cancel 89.88 109 10786
payment from customer: creation 59.58 118 7149
payment from customer: removal 5.61 89 673
payment to supplier: creation 49.84 136 5981
payment to supplier: removal 3.57 123 428
service: total inventory turnovers 4.60 1293 552
service: total monetary turnovers 6.61 60 793
service: aggregate perf. data 0.74 28206 89
service: refresh index statistics 0.03 319154 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-06-2021 16:33:52 to 12-06-2021 16:33:54.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3077
TEST_TIME 2 6035
TEST_TIME 3 6804
TEST_TIME 4 6281
TEST_TIME 5 6036
TEST_TIME 6 5903
TEST_TIME 7 5674
TEST_TIME 8 5545
TEST_TIME 9 5846
TEST_TIME 10 6439
TEST_TIME 11 6599
TEST_TIME 12 6716
TEST_TIME 13 6551
TEST_TIME 14 6721
TEST_TIME 15 6632
TEST_TIME 16 6787
TEST_TIME 17 6982
TEST_TIME 18 6905
TEST_TIME 19 7239
TEST_TIME 20 7367
TEST_TIME 21 7396
TEST_TIME 22 7461
TEST_TIME 23 8170
TEST_TIME 24 8270
TEST_TIME 25 8407
TEST_TIME 26 8405
TEST_TIME 27 8570
TEST_TIME 28 8749
TEST_TIME 29 8670
TEST_TIME 30 9217
TEST_TIME 31 9417
TEST_TIME 32 9731
TEST_TIME 33 10323
TEST_TIME 34 10222
TEST_TIME 35 10113
TEST_TIME 36 10122
TEST_TIME 37 9932
TEST_TIME 38 9868
TEST_TIME 39 9891
TEST_TIME 40 9809
TEST_TIME 41 9750
TEST_TIME 42 10007
TEST_TIME 43 10054
TEST_TIME 44 10105
TEST_TIME 45 10033
TEST_TIME 46 9917
TEST_TIME 47 9752
TEST_TIME 48 9668
TEST_TIME 49 9641
TEST_TIME 50 9606
TEST_TIME 51 9750
TEST_TIME 52 9654
TEST_TIME 53 9663
TEST_TIME 54 9618
TEST_TIME 55 9556
TEST_TIME 56 9536
TEST_TIME 57 9567
TEST_TIME 58 9511
TEST_TIME 59 9485
TEST_TIME 60 9526
TEST_TIME 61 9490
TEST_TIME 62 9477
TEST_TIME 63 9464
TEST_TIME 64 9439
TEST_TIME 65 9527
TEST_TIME 66 9531
TEST_TIME 67 9499
TEST_TIME 68 9517
TEST_TIME 69 9529
TEST_TIME 70 9498
TEST_TIME 71 9556
TEST_TIME 72 9599
TEST_TIME 73 9606
TEST_TIME 74 9553
TEST_TIME 75 9605
TEST_TIME 76 9657
TEST_TIME 77 9646
TEST_TIME 78 9580
TEST_TIME 79 9535
TEST_TIME 80 9545
TEST_TIME 81 9536
TEST_TIME 82 9492
TEST_TIME 83 9477
TEST_TIME 84 9395
TEST_TIME 85 9429
TEST_TIME 86 9411
TEST_TIME 87 9348
TEST_TIME 88 9309
TEST_TIME 89 9377
TEST_TIME 90 9358
TEST_TIME 91 9288
TEST_TIME 92 9270
TEST_TIME 93 9263
TEST_TIME 94 9243
TEST_TIME 95 9245
TEST_TIME 96 9256
TEST_TIME 97 9273
TEST_TIME 98 9269
TEST_TIME 99 9268
TEST_TIME 100 9350
TEST_TIME 101 9363
TEST_TIME 102 9354
TEST_TIME 103 9402
TEST_TIME 104 9398
TEST_TIME 105 9382
TEST_TIME 106 9491
TEST_TIME 107 9529
TEST_TIME 108 9457
TEST_TIME 109 9403
TEST_TIME 110 9346
TEST_TIME 111 9324
TEST_TIME 112 9306
TEST_TIME 113 9313
TEST_TIME 114 9284
TEST_TIME 115 9270
TEST_TIME 116 9209
TEST_TIME 117 9211
TEST_TIME 118 9197
TEST_TIME 119 9174
TEST_TIME 120 9172

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-06-2021 16:33:55 to 12-06-2021 16:33:59.

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 1536574 1536574 0 0.00 0 20470 7 0 0
doc_list_biud 1536571 1536571 0 0.00 0 50128 28 0 0
sp_add_invoice_to_stock 5190 5094 96 1.84 36 169145 19924 0 96
sp_cancel_adding_invoice 5605 5605 0 0.00 4 65059 869 0 0
sp_cancel_client_order 1779 1779 0 0.00 4 12183 358 0 0
sp_cancel_customer_reserve 540930 540930 0 0.00 1 42249 61 0 0
sp_cancel_pay_from_customer 673 673 0 0.00 2 9628 89 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 2 8540 124 0 0
sp_cancel_supplier_invoice 6199 6187 12 0.19 2 50135 888 0 12
sp_cancel_supplier_order 396 396 0 0.00 13 978376 106871 0 0
sp_cancel_write_off 10786 10786 0 0.00 1 8955 109 0 0
sp_client_order 20419 20419 0 0.00 3 22212 321 0 0
sp_customer_reserve 472065 472065 0 0.00 0 46635 197 0 0
sp_fill_shopping_cart 31720 31720 0 0.00 1 14862 42 0 0
sp_fill_shopping_cart_clo_res 472058 472058 0 0.00 0 17617 12 0 0
sp_get_clo_for_invoice 5086 5086 0 0.00 0 18149 282 0 0
sp_kill_cost_storno 17492 17492 0 0.00 0 8851 58 0 0
sp_kill_qstorno_ret_qs2qd 1099229 1099229 0 0.00 0 50122 33 0 0
sp_kill_qty_storno 580890 580890 0 0.00 0 50126 73 0 0
sp_lock_selected_doc 20980 20980 0 0.00 0 11610 5 0 0
sp_make_cost_storno 28339 28339 0 0.00 0 16786 57 0 0
sp_multiply_rows_for_pdistr 28338 28338 0 0.00 0 9308 31 0 0
sp_multiply_rows_for_qdistr 20419 20419 0 0.00 0 11300 143 0 0
sp_pay_from_customer 7149 7149 0 0.00 4 28631 119 0 0
sp_pay_to_supplier 5981 5981 0 0.00 5 20238 137 0 0
sp_payment_common 13130 13130 0 0.00 1 25233 32 0 0
sp_qd_handle_on_cancel_clo 1779 1779 0 0.00 0 12172 335 0 0
sp_qd_handle_on_invoice_upd_sts 10686 10686 0 0.00 0 23371 378 0 0
sp_qd_handle_on_reserve_upd_sts 10126 10126 0 0.00 0 20497 67 0 0
sp_reserve_write_off 10126 10126 0 0.00 6 20549 190 0 0
sp_supplier_invoice 5653 5653 0 0.00 8 85470 3675 0 0
sp_supplier_order 5656 5656 0 0.00 5 26791 1359 0 0
srv_aggregate_perf_data 89 89 0 0.00 2977 483001 28206 0 0
srv_fill_mon_cache_memory 176 176 0 0.00 1120 140335 28350 0 0
srv_find_qd_qs_mism 1051623 1051623 0 0.00 0 12185 6 0 0
srv_make_invnt_saldo 552 552 0 0.00 51 137547 1293 0 0
srv_make_money_saldo 793 793 0 0.00 1 18212 60 0 0
srv_recalc_idx_stat 4 4 0 0.00 118368 445366 319155 0 0
t$perf-abend:sp_add_invoice_to_stock 96 96 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5094 5094 0 0.00 0 14355 194 0 0
t$perf-norm:sp_cancel_adding_invoice 409 409 0 0.00 0 7488 139 0 0
t$perf-norm:sp_cancel_client_order 1779 1779 0 0.00 0 4074 17 0 0
t$perf-norm:sp_cancel_customer_reserve 705 705 0 0.00 0 908 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 673 673 0 0.00 0 4109 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 38 1 0 0
t$perf-norm:sp_cancel_supplier_invoice 404 404 0 0.00 0 2626 27 0 0
t$perf-norm:sp_cancel_supplier_order 396 396 0 0.00 0 17692 1588 0 0
t$perf-norm:sp_cancel_write_off 979 979 0 0.00 0 3123 10 0 0
t$perf-norm:sp_client_order 20419 20419 0 0.00 0 16587 21 0 0
t$perf-norm:sp_customer_reserve 1016 1016 0 0.00 0 4001 11 0 0
t$perf-norm:sp_pay_from_customer 7149 7149 0 0.00 0 16416 15 0 0
t$perf-norm:sp_pay_to_supplier 5981 5981 0 0.00 0 7322 12 0 0
t$perf-norm:sp_reserve_write_off 10126 10126 0 0.00 0 10077 14 0 0
t$perf-norm:sp_supplier_invoice 5653 5653 0 0.00 0 7521 23 0 0
t$perf-norm:sp_supplier_order 5656 5656 0 0.00 0 4522 17 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 89 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 176 176 0 0.00 0 3175 20 0 0
t$perf-norm:srv_make_invnt_saldo 552 552 0 0.00 0 5047 31 0 0
t$perf-norm:srv_make_money_saldo 793 793 0 0.00 0 1347 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 10354 10162 192 1.85 0 6280 21 0 192
v_all_customers 37072 37072 0 0.00 0 26 1 0 0
v_all_suppliers 31154 31154 0 0.00 0 16 1 0 0
v_all_wares 40838 40838 0 0.00 0 112 1 0 0
v_cancel_adding_invoice 818 818 0 0.00 0 3261 15 0 0
v_cancel_client_order 3558 3558 0 0.00 0 2343 5 0 0
v_cancel_customer_prepayment 1346 1346 0 0.00 0 963 5 0 0
v_cancel_customer_reserve 1410 1410 0 0.00 0 3233 6 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 2927 15 0 0
v_cancel_supplier_invoice 832 808 24 2.88 0 5860 27 0 24
v_cancel_supplier_order 792 792 0 0.00 0 2516 7 0 0
v_cancel_write_off 1958 1958 0 0.00 0 2562 13 0 0
v_max_id_clo_ord 5652 5652 0 0.00 0 3787 2 0 0
v_max_id_clo_res 1016 1016 0 0.00 0 4713 15 0 0
v_max_id_ord_sup 5648 5648 0 0.00 0 5688 6 0 0
v_max_non_paid_invoice 1704 1704 0 0.00 0 1988 5 0 0
v_max_non_paid_realizn 3918 3918 0 0.00 0 680 4 0 0
v_min_id_clo_ord 5652 5652 0 0.00 0 5725 8 0 0
v_min_id_clo_res 1016 1016 0 0.00 0 1145 5 0 0
v_min_id_ord_sup 5648 5648 0 0.00 0 3861 7 0 0
v_min_non_paid_invoice 5981 5981 0 0.00 0 19315 26 0 0
v_min_non_paid_realizn 7149 7149 0 0.00 0 9454 16 0 0
v_our_firm 10228 10228 0 0.00 0 20 1 0 0
v_reserve_write_off 20252 20252 0 0.00 0 5833 6 0 0
x_lock_depdocs_on_canc_invoice 11388 11388 0 0.00 0 13777 114 0 0
x_lock_depdocs_on_canc_sup_ord 396 396 0 0.00 0 5784 373 0 0
x_make_qstorno_1000_1200 5656 5656 0 0.00 2 26785 1269 0 0
x_make_qstorno_1200_2000 5653 5653 0 0.00 3 85463 3533 0 0
x_make_qstorno_2100_3300 472065 472065 0 0.00 0 46625 181 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-06-2021 16:34:00 to 12-06-2021 16:34:04.

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
14:02:45 1 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
14:02:51 15320 8192000000 10230818112 10534797312 855692368 9.457 68 47 95 0 873419216 2398416 15328432
14:03:14 22276 8192000000 10325974784 10645028864 1366771056 14.298 100 81 162 0 1396603088 4329568 25502464
14:03:46 26335 8192000000 10370014192 10691747840 1427378544 14.838 100 83 166 0 1460218320 6209728 26630048
14:04:24 29574 8192000000 10409598384 10736152576 1453846928 15.072 100 84 168 0 1489283296 7609920 27826448
14:05:07 23621 8192000000 10435899008 10766405632 1492303920 15.409 100 92 185 1 1530291904 8609264 29378720
14:05:45 22555 8192000000 10465579888 10798247936 1509153520 15.556 100 91 182 1 1548149456 9763392 29232544
14:06:26 17022 8192000000 10483746160 10823790592 1533100800 15.764 100 91 183 0 1572505088 10630160 28774128
14:06:52 22170 8192000000 10489897696 10836062208 1548407904 15.896 100 83 166 0 1584957376 10711936 25837536
14:07:35 16513 8192000000 10520316224 10873688064 1575346432 16.128 100 76 153 2 1609487456 10902416 23238608
14:07:59 14467 8192000000 10547993904 10900566016 1599586560 16.336 100 80 159 2 1635445824 11004976 24854288
14:08:24 13510 8192000000 10582191536 10938781696 1629337568 16.589 100 81 162 0 1665750768 11849216 24563984
14:08:49 11873 8192000000 10592897456 10952335360 1646567264 16.735 100 84 168 1 1684125520 12505008 25053248
14:09:10 12339 8192000000 10615271024 10981449728 1672399904 16.953 100 78 156 0 1708547936 13027408 23120624
14:09:30 8750 8192000000 10623188672 10991521792 1677417712 16.996 100 74 149 0 1712510080 13029152 22063216
14:09:48 7010 8192000000 10630287152 11000152064 1693892640 17.134 100 79 157 0 1730580000 13750768 22936592
14:10:05 9371 8192000000 10641018000 11018768384 1707998352 17.252 100 78 156 1 1743853264 13656032 22198880
14:10:22 7978 8192000000 10669573504 11040309248 1726887952 17.410 100 79 158 1 1763006656 12938944 23179760
14:10:37 5750 8192000000 10672098224 11050700800 1735506400 17.481 100 72 144 0 1769854832 13224000 21124432
14:10:51 5584 8192000000 10681923392 11061772288 1744495184 17.556 100 76 153 2 1778483984 12148528 21840272
14:11:05 5851 8192000000 10695779504 11076165632 1754470192 17.639 100 73 146 0 1787905312 12021168 21413952
14:11:18 4110 8192000000 10707340944 11087474688 1763411024 17.713 100 79 158 1 1798214176 12589312 22213840
14:11:30 5073 8192000000 10714247360 11098243072 1778996224 17.841 100 73 144 1 1810766784 11394320 20376240
14:11:42 3257 8192000000 10720546496 11098198016 1787518256 17.911 100 88 173 3 1823905568 12015584 24371728
14:11:52 13013 8192000000 10716396752 11109396480 1791042560 17.940 100 67 134 1 1821367120 11359872 18964688
14:12:13 5075 8192000000 10740829632 11132702720 1796391696 17.984 100 69 136 1 1826597392 10329824 19875872
14:12:25 3693 8192000000 10741923072 11139928064 1813966560 18.128 100 69 134 1 1843763136 10935344 18861232
14:12:35 2906 8192000000 10768117968 11149938688 1820390256 18.181 100 81 161 2 1855557376 11481248 23685872
14:12:45 3144 8192000000 10765776544 11153592320 1827895808 18.242 100 87 174 0 1864754288 11896320 24962160
14:12:55 2045 8192000000 10776484592 11160449024 1835190800 18.302 100 85 170 0 1871049200 11564736 24293664
14:13:05 2317 8192000000 10772325328 11160322048 1834878960 18.299 100 81 161 2 1870051792 12571168 22601664
14:13:14 3136 8192000000 10780790768 11165310976 1841404128 18.352 100 90 180 0 1879562208 12963152 25194928
14:13:24 2395 8192000000 10779972800 11167293440 1842780048 18.363 100 87 173 1 1880706240 13260240 24665952
14:13:32 2881 8192000000 10787538432 11170643968 1842856800 18.364 100 95 190 0 1883102832 12503984 27742048
14:13:42 3969 8192000000 10793623344 11179405312 1848317376 18.408 100 90 181 1 1886804608 13361232 25126000
14:13:52 2194 8192000000 10788385392 11176894464 1853310400 18.449 100 89 178 0 1892054128 13867136 24876592
14:14:01 1913 8192000000 10802428448 11191017472 1856081328 18.471 100 99 197 1 1899383216 15634640 27667248
14:14:09 2255 8192000000 10804979152 11193200640 1859478240 18.499 100 95 191 0 1901074720 15635376 25961104
14:14:18 1749 8192000000 10816610080 11202105344 1863333968 18.530 100 87 176 1 1902006528 13833872 24838688
14:14:28 1900 8192000000 10811336080 11199672320 1865862368 18.551 100 89 181 1 1903682720 12025200 25795152
14:14:36 2375 8192000000 10810211904 11200880640 1865140464 18.545 100 86 170 0 1902145888 12639216 24366208
14:14:45 11715 8192000000 10802737200 11197407232 1862802720 18.526 100 67 133 0 1895800848 15243840 17754288
14:15:03 2303 8192000000 10811094832 11201507328 1868588720 18.573 100 87 172 2 1905574496 11558256 25427520
14:15:21 1917 8192000000 10814467792 11205369856 1872017936 18.601 100 97 196 1 1911689536 11519200 28152400
14:15:30 2190 8192000000 10795817088 11196952576 1869836320 18.583 100 76 150 0 1903003040 11468336 21698384
14:15:39 1922 8192000000 10801699920 11203145728 1870942032 18.592 100 72 144 2 1902474496 11976144 19556320
14:15:49 4787 8192000000 10795632592 11201425408 1868277056 18.570 100 53 104 1 1893124000 10260832 14586112
14:16:00 2637 8192000000 10796984848 11204063232 1874161856 18.618 100 64 129 2 1901865360 9631952 18071552
14:16:09 4124 8192000000 10800605712 11207958528 1872725520 18.606 100 37 74 1 1891844448 8736640 10382288
14:16:20 3877 8192000000 10799793184 11211599872 1882807808 18.688 100 63 127 1 1909924800 8358720 18758272
14:16:30 49175 8192000000 10814514880 11222487040 1876532832 18.637 100 33 66 0 1896330304 10008320 9789152
14:17:26 6538 8192000000 10809490496 11224526848 1884946464 18.705 100 66 130 0 1913174384 10011232 18216688
14:17:40 11164 8192000000 10785004960 11220819968 1877760384 18.647 100 28 56 1 1893488416 7811744 7916288
14:17:57 4995 8192000000 10805959152 11231772672 1886154752 18.715 100 45 90 0 1910060032 11139520 12765760
14:18:09 6887 8192000000 10801151872 11226144768 1887313024 18.724 100 25 50 0 1900668112 6251728 7103360
14:18:24 5984 8192000000 10792278720 11225350144 1884698448 18.703 100 22 44 1 1896312144 5634400 5979296
14:18:38 7737 8192000000 10799210832 11229659136 1889384528 18.741 100 30 60 3 1905217792 7611488 8221776
14:18:53 4265 8192000000 10811175744 11232931840 1890710960 18.752 100 36 72 0 1908550928 8075936 9764032
14:19:03 4998 8192000000 10799643072 11229470720 1888078688 18.730 100 22 44 2 1901338192 7068048 6191456
14:19:14 10326 8192000000 10820543088 11239473152 1890775424 18.752 100 21 42 0 1901749408 5232992 5740992
14:19:31 16951 8192000000 10811015376 11240935424 1893673584 18.775 100 9 18 1 1901539536 5428624 2437328
14:19:54 8832 8192000000 10814968176 11246288896 1901108480 18.835 100 20 40 2 1912762224 5977456 5676288
14:20:13 8732 8192000000 10805545008 11244429312 1901548768 18.839 100 14 28 0 1911680352 6344960 3786624
14:20:29 11504 8192000000 10823690000 11250589696 1905141168 18.868 100 27 54 2 1919202816 6007536 8054112
14:20:48 8674 8192000000 10811454864 11248975872 1905752992 18.873 100 23 46 0 1917416320 5501008 6162320
14:21:04 13853 8192000000 10839582176 11264028672 1910765376 18.913 100 23 46 2 1923629216 6465312 6398528
14:21:25 66961 8192000000 10816905920 11258712064 1911142048 18.916 100 23 44 1 1922796064 5101440 6552576
14:22:38 6394 8192000000 10845484784 11268628480 1915379840 18.950 100 31 60 2 1929208656 5971568 7857248
14:22:52 6100 8192000000 10823905632 11252420608 1865480256 18.548 97 32 65 0 1881415328 6893296 9041776
14:23:05 5647 8192000000 10808435056 11246428160 1897652624 18.807 100 25 48 2 1909719936 4863952 7203360
14:23:19 6485 8192000000 10823049984 11260141568 1911876160 18.922 100 32 64 2 1932230144 11345472 9008512
14:23:32 7126 8192000000 10807882064 11246354432 1873176048 18.610 98 23 46 0 1885154352 5644080 6334224
14:23:45 9023 8192000000 10786593104 11223879680 1857042384 18.479 98 20 40 1 1868690544 5477984 6170176
14:24:02 4671 8192000000 10790681280 11214716928 1854257056 18.457 99 20 40 2 1865887440 6158384 5472000
14:24:13 6933 8192000000 10789249936 11221004288 1858366192 18.490 99 22 44 2 1871087680 5938432 6783056
14:24:28 5645 8192000000 10751903056 11175952384 1797128400 17.990 97 28 56 2 1811309040 6078736 8101904
14:24:41 13820 8192000000 10734827648 11156930560 1725239936 17.396 93 12 24 0 1733867232 5348304 3278992
14:25:01 9524 8192000000 10708152976 11129905152 1724644992 17.391 95 30 60 1 1739655040 5752976 9257072
14:25:17 9905 8192000000 10730993312 11146080256 1775834992 17.815 98 29 57 4 1790047552 5357552 8855008
14:25:33 14040 8192000000 10690331312 11119542272 1717232288 17.329 95 11 22 0 1725555888 5057536 3266064
14:25:54 26666 8192000000 10699211536 11121651712 1739484464 17.514 96 27 52 3 1757337472 10072240 7780768
14:26:26 45962 8192000000 10680137632 11103715328 1669007952 16.925 92 29 57 3 1682083424 4883472 8192000
14:27:18 9803 8192000000 10695445088 11115130880 1719033936 17.344 96 17 33 1 1730312384 5184304 6094144
14:27:39 6345 8192000000 10685729024 11093712896 1706258144 17.237 96 34 68 1 1722431936 6116752 10057040
14:27:53 7773 8192000000 10666675968 11074011136 1726944768 17.410 98 36 70 2 1743882304 6419024 10518512
14:28:07 7961 8192000000 10700047296 11108311040 1764072096 17.718 99 28 55 0 1777985200 5679728 8233376
14:28:22 6869 8192000000 10704617376 11117420544 1735773568 17.484 97 33 67 1 1752235984 7396048 9066368
14:28:35 9346 8192000000 10688544976 11112611840 1750349600 17.604 98 19 38 0 1762459760 6492608 5617552
14:28:51 11456 8192000000 10710190672 11135152128 1786992080 17.907 99 18 36 0 1797970208 5012048 5966080
14:29:10 3959 8192000000 10735939744 11154853888 1819707824 18.175 100 39 78 2 1838003600 6977648 11318128
14:29:20 7631 8192000000 10726693632 11145293824 1799088848 18.006 99 20 40 1 1810970384 6164544 5716992
14:29:39 9831 8192000000 10727526336 11158740992 1810067264 18.096 99 23 46 0 1822405968 5261472 7077232
14:29:55 8959 8192000000 10751757792 11168600064 1817333808 18.156 99 31 62 2 1831711888 4805792 9572288
14:30:12 9590 8192000000 10752308784 11177771008 1834780944 18.298 100 27 54 1 1848883040 5944864 8157232
14:30:29 12650 8192000000 10755431888 11183730688 1841935664 18.357 100 14 28 0 1851294256 5412896 3945696
14:30:50 7270 8192000000 10765829984 11196178432 1855289760 18.465 100 22 44 1 1867984672 6324048 6370864
14:31:04 64230 8192000000 10778896480 11204960256 1864461344 18.539 100 41 81 1 1881769456 5692288 11615824
14:32:23 20432 8192000000 10804306144 11222913024 1882403584 18.685 100 30 58 1 1895958336 5776928 7777824
14:32:52 1723 8192000000 10839456320 11245412352 1895813072 18.793 100 68 132 1 1922071216 7212048 19046096
14:33:02 25887 8192000000 10837616688 11251859456 1898427776 18.814 100 52 105 0 1921645200 8882080 14335344
14:33:44 3700 8192000000 10854112064 11265155072 1911222144 18.916 100 72 145 2 1942232784 11185568 19825072
14:34:00 12200 8192000000 10847420416 11262189568 1911238592 18.917 100 62 124 0 1940546288 12332112 16975584
14:34:19 6154 8192000000 10847906080 11265552384 1913940240 18.938 100 59 116 0 1941927168 11566064 16420864
14:34:33 7492 8192000000 10857606912 11273822208 1920139744 18.988 100 68 135 3 1949839472 11150544 18549184
14:34:49 6673 8192000000 10857863584 11278200832 1921594160 19.000 100 63 126 2 1950791488 11476800 17720528
14:35:08 4568 8192000000 10868487712 11286052864 1928583584 19.056 100 60 120 1 1957767232 11849440 17334208
14:35:22 1473 8192000000 10893335584 11301486592 1939360640 19.142 100 87 173 1 1975459424 10579824 25518960
14:35:31 31842 8192000000 10866965488 11297951744 1938718896 19.137 100 46 92 0 1961954256 10615968 12619392
14:36:14 33065 8192000000 10878171760 11305668608 1945937712 19.194 100 43 86 0 1967643056 9975264 11730080
14:36:58 6612 8192000000 10890733424 11314589696 1952172048 19.244 100 51 102 0 1977376224 10853136 14351040
14:37:14 10787 8192000000 10908304272 11328323584 1962804592 19.328 100 73 146 0 1995204912 11752832 20647488
14:37:31 6831 8192000000 10920998416 11339124736 1970645392 19.391 100 77 154 1 2010155344 17953456 21556496
14:37:46 23290 8192000000 10914441824 11336695808 1968568784 19.374 100 61 122 0 1999678912 13326576 17783552
14:38:18 7179 8192000000 10910674048 11339988992 1973053664 19.410 100 58 116 0 2003406160 13923792 16428704
14:38:32 10679 8192000000 10909810464 11340492800 1975367664 19.428 100 63 127 1 2008337392 14416576 18553152
14:38:53 39084 8192000000 10919394960 11350016000 1978430400 19.452 100 49 98 1 2005587744 13260144 13897200
14:39:44 8642 8192000000 10928039344 11352662016 1981680896 19.478 100 58 113 2 2011113536 13561104 15871536
14:40:02 8315 8192000000 10936680096 11356344320 1986990992 19.520 100 65 128 1 2020329456 15130752 18207712
14:40:21 13258 8192000000 10934551824 11357941760 1989537712 19.540 100 68 134 1 2024859264 16275072 19046480
14:40:42 13131 8192000000 10925253328 11358429184 1988620608 19.533 100 59 119 2 2021257760 15673120 16964032
14:41:02 3167 8192000000 10944175024 11368615936 1995092768 19.584 100 70 137 1 2031580144 17094304 19393072
14:41:12 3303 8192000000 10947102576 11365675008 1997052784 19.599 100 65 129 1 2032638816 17094944 18491088
14:41:21 11109 8192000000 10946248288 11370872832 1994900640 19.582 100 62 122 1 2031566208 18627536 18038032
14:41:40 6596 8192000000 10949869648 11373187072 1998401968 19.610 100 67 135 0 2038523728 20879664 19242096
14:41:53 3505 8192000000 10933358752 11351453696 1976809872 19.439 99 67 136 0 2017483504 20834464 19839168
14:42:05 7121 8192000000 10941920544 11372130304 1990569040 19.548 100 60 120 0 2028858448 20491280 17798128
14:42:21 8295 8192000000 10947100912 11380477952 1998625312 19.612 100 65 129 1 2039638960 21514528 19499120
14:42:44 5541 8192000000 10947344720 11382702080 1998548432 19.611 100 54 107 0 2032768144 18187200 16032512
14:42:56 6389 8192000000 10941526816 11379777536 2001274512 19.633 100 47 94 0 2032762960 17057184 14431264
14:43:17 14260 8192000000 10946610976 11381891072 1982567344 19.485 99 52 103 0 2018919728 21118448 15233936
14:43:41 2070 8192000000 10969160608 11390087168 2006997040 19.678 100 67 130 2 2048243280 21583840 19662400
14:43:49 6943 8192000000 10974107120 11401371648 2016916320 19.756 100 75 149 1 2060619456 21307552 22395584
14:44:14 12219 8192000000 10950884400 11393695744 2003563024 19.651 100 51 102 1 2042598240 23113072 15922144
14:44:36 20593 8192000000 10953988608 11400802304 2006453712 19.674 100 42 84 2 2045522576 25616944 13451920
14:45:15 10363 8192000000 10960375888 11399467008 2010131568 19.703 100 45 90 1 2046302128 22520400 13650160
14:45:39 17710 8192000000 10965123984 11408678912 2014598304 19.738 100 34 68 0 2049690144 24127104 10964736
14:46:04 3218 8192000000 10984155856 11417239552 2023562544 19.808 100 63 124 0 2067657120 25104512 18990064
14:46:14 8156 8192000000 10981435024 11420983296 2024505536 19.816 100 62 124 1 2070095680 25891616 19698528
14:46:37 10485 8192000000 10983817600 11424587776 2026884480 19.834 100 58 114 0 2072183488 27345744 17953264
14:46:55 4984 8192000000 10977997840 11415748608 2023340944 19.806 100 58 116 1 2066010176 25064480 17604752
14:47:08 2577 8192000000 10983397328 11414949888 2019341808 19.775 100 62 123 1 2063931408 26092128 18497472
14:47:19 2841 8192000000 10975400096 11408130048 2012738768 19.723 100 64 127 2 2057711344 25701776 19270800
14:47:28 4005 8192000000 10974368928 11407310848 2014880288 19.740 100 71 142 0 2062771872 26574080 21317504
14:47:39 6523 8192000000 10982466768 11409670144 2015893152 19.748 100 71 141 0 2064467232 27182304 21391776
14:47:59 3875 8192000000 10978193904 11413905408 2015173072 19.742 100 66 132 0 2064768528 29416208 20179248
14:48:14 5272 8192000000 10971697200 11399794688 1998590624 19.612 99 74 147 1 2048947312 28327584 22029104
14:48:33 4249 8192000000 10993493104 11424829440 2025785984 19.826 100 71 141 2 2078896848 31720000 21390864
14:48:45 7382 8192000000 10990526352 11420291072 2018797376 19.771 100 75 150 0 2074020320 32172224 23050720
14:49:06 2958 8192000000 10998704368 11426873344 2028103024 19.844 100 76 152 0 2081637152 31455792 22078336
14:49:17 4179 8192000000 10986727872 11419516928 2023842720 19.810 100 80 157 1 2081109216 33107168 24159328
14:49:28 3334 8192000000 11017870144 11437572096 2030394080 19.862 100 90 179 4 2091317936 33795632 27128224
14:49:39 9456 8192000000 10995675712 11434909696 2028552832 19.847 100 69 138 0 2084407120 34731952 21122336
14:49:59 8371 8192000000 11002192048 11440611328 2033029280 19.882 100 66 132 1 2090827136 36808016 20989840
14:50:15 4406 8192000000 10999146048 11436908544 2014295872 19.735 99 64 127 0 2074427408 40289168 19842368
14:50:30 4995 8192000000 11012024864 11442917376 2031125456 19.867 100 74 148 0 2094602608 41241600 22235552
14:50:42 4354 8192000000 11023902736 11450470400 2039083472 19.930 100 81 161 0 2104208176 40896672 24228032
14:50:53 4471 8192000000 11007147200 11439058944 2028515440 19.847 100 71 142 1 2092202064 42128528 21558096
14:51:07 3494 8192000000 11022720656 11449712640 2035443376 19.901 100 85 170 0 2106308928 44550272 26315280
14:51:22 5008 8192000000 11021582448 11442548736 2030101824 19.859 100 78 156 2 2098518960 44106400 24310736
14:51:33 2297 8192000000 11022254800 11437748224 2025651152 19.825 100 88 173 1 2094643408 42471968 26520288
14:51:45 1118 8192000000 11001450800 11421868032 2008873472 19.693 99 92 184 1 2079650400 42809440 27967488
14:51:53 4384 8192000000 11001484032 11415298048 2003164096 19.648 100 83 166 1 2070983552 42423312 25396144
14:52:05 4463 8192000000 10968820192 11385282560 1962676624 19.327 98 88 177 1 2032207120 42850496 26680000
14:52:15 5383 8192000000 10991684880 11414667264 2005988352 19.670 100 80 159 4 2076429376 45379728 25061296
14:52:28 3412 8192000000 10979767152 11403988992 1991817360 19.558 99 79 158 0 2061469760 46034848 23617552
14:52:41 2392 8192000000 10992576976 11406811136 1995837088 19.590 100 84 166 1 2068040672 46408608 25794976
14:52:50 1390 8192000000 11002797936 11414548480 2001222656 19.632 100 93 185 2 2075904464 46707136 27974672
14:52:58 2115 8192000000 11003505232 11421540352 2006697632 19.676 100 92 182 1 2081388000 47086752 27603616
14:53:08 5197 8192000000 10975017200 11397980160 1987834384 19.527 100 79 155 1 2057077920 44866912 24376624
14:53:20 5617 8192000000 10987331312 11409195008 1997500544 19.603 100 79 156 0 2067491056 45823120 24167392
14:53:34 1306 8192000000 10993554704 11407069184 1994320192 19.578 100 91 183 2 2069270176 46520176 28429808
14:53:42 3131 8192000000 10988184368 11403350016 1992366176 19.562 100 97 193 1 2070140944 47572880 30201888
14:53:52 1697 8192000000 10994515200 11408826368 1996354176 19.594 100 93 186 0 2074956944 49925088 28677680
14:54:01 2326 8192000000 10984375760 11397042176 1948854352 19.217 98 86 172 0 2027014256 51479408 26680496
14:54:11 3306 8192000000 10975604048 11392847872 1975032416 19.425 100 77 152 0 2052378736 52433280 24913040
14:54:24 2663 8192000000 10965970960 11390509056 1972981680 19.409 100 79 159 2 2050223776 52932272 24309824
14:54:35 2069 8192000000 10980173856 11394330624 1975632416 19.430 100 79 156 1 2053668240 53552368 24483456
14:54:45 4203 8192000000 10958400576 11374309376 1958857824 19.297 100 75 151 3 2037226800 54398608 23970368
14:55:00 1320 8192000000 10946606048 11367596032 1951797680 19.241 100 70 138 0 2028555792 55268736 21489376
14:55:08 2356 8192000000 10934083328 11353952256 1939211888 19.140 100 65 130 1 2013431712 53091184 21128640
14:55:20 4277 8192000000 10938323376 11363893248 1950188720 19.228 100 62 121 0 2019248288 49451008 19608560
14:55:31 4921 8192000000 10932539216 11369476096 1954723184 19.264 100 53 106 0 2022127232 49802592 17601456
14:55:43 16131 8192000000 10920078480 11358740480 1918402480 18.974 98 38 76 2 1973562864 42493584 12666800
14:56:10 4590 8192000000 10933740480 11358625792 1937747312 19.129 99 61 121 2 2003632512 46847408 19037792
14:56:23 3800 8192000000 10921043472 11350241280 1939282368 19.141 100 49 95 2 2002833680 48596448 14954864
14:56:36 7309 8192000000 10908067760 11350519808 1923029888 19.011 99 40 79 0 1985511840 49505760 12976192
14:57:02 17992 8192000000 10910982720 11361230848 1945225792 19.188 100 26 52 1 2002273952 48065216 8982944
14:57:49 5996 8192000000 10920136160 11339395072 1933505216 19.095 99 47 94 1 1991203152 42598992 15098944
14:58:02 4979 8192000000 10932534592 11370385408 1959694304 19.304 100 52 103 1 2026879136 51663952 15520880
14:58:14 14835 8192000000 10941117072 11376152576 1956230528 19.276 100 42 84 1 2016930960 46999472 13700960
14:58:44 1531 8192000000 10982469632 11402936320 1986308496 19.515 100 83 164 0 2066711104 55317488 25085120
14:58:52 3578 8192000000 10967373200 11392741376 1971383472 19.396 100 63 126 0 2045098688 53947040 19768176
14:59:05 4838 8192000000 10945384256 11381796864 1944571280 19.183 99 43 85 0 2013136736 54708272 13857184
14:59:22 4170 8192000000 10932730880 11369684992 1943347072 19.173 100 38 76 2 2011395248 55234896 12813280
14:59:33 21311 8192000000 10926350976 11358015488 1939672096 19.144 99 31 62 3 2001132864 50912352 10548416
15:00:02 30420 8192000000 10912785456 11362316288 1915190064 18.948 98 31 62 2 1983666592 57233872 11242656
15:01:03 7577 8192000000 10919865584 11352313856 1925826352 19.033 99 39 77 1 1985799520 47234496 12738672
15:01:30 9261 8192000000 10916786048 11355463680 1939712976 19.144 100 35 70 2 2001015392 49376320 11926096
15:02:02 13366 8192000000 10934986000 11374575616 1948699040 19.216 100 35 70 1 2015224192 54772528 11752624
15:02:37 11640 8192000000 10926933536 11395747840 1959538256 19.302 100 26 51 2 2020994800 52799456 8657088
15:03:00 19313 8192000000 10898498000 11389419520 1932111744 19.084 99 16 32 0 1987920544 50000304 5808496
15:03:30 39788 8192000000 10889398208 11335680000 1897545120 18.807 98 22 44 0 1940694224 35278640 7870464
15:05:01 92917 8192000000 10844694832 11304955904 1817253536 18.155 95 18 36 0 1835247184 13238848 4754800
15:06:40 78971 8192000000 10895167584 11317125120 1884513504 18.702 97 40 78 1 1905950256 11224400 10212352
15:08:09 9981 8192000000 10898758160 11322388480 1939415936 19.142 100 60 116 1 1963622288 7643088 16563264
15:08:27 48515 8192000000 10871531840 11330842624 1934360896 19.102 100 17 34 0 1947147472 8133776 4652800
15:09:27 40118 8192000000 10890093248 11334410240 1935874624 19.114 99 33 67 2 1954807584 9721312 9211648
15:10:16 98176 8192000000 10871854768 11333816320 1890446768 18.749 97 27 54 1 1909190992 11594832 7149392
15:12:04 80698 8192000000 10882148048 11329769472 1894078256 18.779 97 25 50 0 1914768400 13722208 6967936
15:13:31 77525 8192000000 10882731360 11362234368 1942756048 19.169 100 26 52 1 1976970976 25619168 8595760
15:15:00 65103 8192000000 10892439888 11369861120 1956929168 19.282 100 13 27 2 1979040080 18403088 3707824
15:17:31 72753 8192000000 10870139376 11328024576 1922848416 19.010 98 21 42 1 1937452208 8726416 5877376
15:18:51 90395 8192000000 10899378112 11354509312 1936835344 19.121 99 22 44 1 1949695168 6445056 6414768
15:20:32 44226 8192000000 10923200240 11356553216 1929679792 19.064 98 36 72 0 1951785472 11555520 10550160
15:21:26 83687 8192000000 10940220608 11389935616 1971320928 19.396 100 19 37 2 1995440704 17125200 6994576
15:23:01 35548 8192000000 10911197712 11376189440 1980260112 19.467 100 44 87 3 2004934720 11559488 13115120
15:24:01 61998 8192000000 10913358016 11365392384 1965108032 19.347 99 32 62 1 1981834512 8347600 8378880
15:25:10 74116 8192000000 10894184016 11365425152 1949274624 19.221 98 19 38 0 1961429680 7354704 4800352
15:26:31 11742 8192000000 10940524976 11383578624 1983359600 19.491 100 33 66 0 2000429024 6955600 10113824
15:26:53 28302 8192000000 10936054096 11398983680 1998024368 19.607 100 38 76 2 2021317984 11816640 11476976
15:27:33 23479 8192000000 10948502272 11401322496 1989898704 19.543 99 51 99 3 2020389952 15477424 15013824
15:28:21 68977 8192000000 10915258304 11403386880 1972944016 19.409 99 14 28 1 1998493248 21139840 4409392
15:29:46 56677 8192000000 10922471488 11409588224 1989136368 19.537 100 12 24 0 2010193792 17474304 3583120
15:30:49 27650 8192000000 10929576416 11409006592 1991575440 19.556 100 10 20 1 2011886944 17101344 3210160
15:31:26 22904 8192000000 10912416192 11394863104 1984087904 19.497 100 14 28 1 2004374992 16126448 4160640
15:31:57 69292 8192000000 10880025392 11348606976 1906325728 18.877 96 15 30 1 1923192384 12345120 4521536
15:33:58 64119 8192000000 10897161040 11372007424 1955150560 19.267 99 24 49 1 1974786544 12569840 7066144
15:35:09 42902 8192000000 10890748592 11368681472 1931448224 19.078 98 10 20 1 1941892144 8052224 2391696
15:36:07 73201 8192000000 10915660864 11406225408 1984753024 19.502 100 11 22 0 1999737872 12200576 2784272
15:37:43 63717 8192000000 10916491232 11383603200 1931834032 19.082 97 13 26 0 1948601296 13416528 3350736
15:38:52 65525 8192000000 10924639744 11390734336 1969227808 19.379 99 25 50 0 1989156112 12529520 7398784
15:40:32 53961 8192000000 10840789456 11300999168 1825687744 18.224 93 21 42 0 1841527856 10245024 5595088
15:41:36 20221 8192000000 10869327168 11314806784 1877009584 18.641 97 49 100 0 1901334384 10686592 13638208
15:42:20 50806 8192000000 10880125824 11338809344 1866620576 18.557 96 33 66 2 1890938928 15051184 9267168
15:43:34 98087 8192000000 10855272544 11340697600 1801450032 18.026 93 13 26 1 1820359632 15277424 3632176
15:45:21 70614 8192000000 10868481104 11330166784 1885748512 18.712 98 8 16 0 1902529088 14218000 2562576
15:46:39 63900 8192000000 10872849616 11340103680 1922234528 19.005 99 29 56 0 1946254176 16338048 7681600
15:48:07 76921 8192000000 10852490128 11318603776 1834759904 18.298 94 11 22 0 1855457600 17750704 2946992
15:49:47 137464 8192000000 10863131488 11335471104 1879872208 18.664 97 12 24 0 1901252784 18145536 3235040
15:52:13 84124 8192000000 10841742368 11311185920 1852326672 18.441 96 19 38 1 1869430592 11610688 5493232
15:53:44 19883 8192000000 10839225872 11315118080 1914397440 18.942 100 14 28 1 1937723424 19294640 4031344
15:54:13 15290 8192000000 10834203904 11301752832 1897210896 18.804 99 11 22 1 1912698736 13327456 2160384
15:54:38 55458 8192000000 10837340832 11307032576 1897057824 18.803 99 14 28 2 1913146208 12476800 3611584
15:57:20 83700 8192000000 10853369248 11334762496 1911410032 18.918 99 20 40 0 1927680592 10326256 5944304
15:58:50 60871 8192000000 10852267168 11327664128 1909156560 18.900 99 14 28 1 1924434400 11253584 4024256
15:59:57 58777 8192000000 10858710528 11327467520 1907064816 18.883 99 35 70 0 1929897568 12298064 10534688
16:01:02 36149 8192000000 10860946224 11325734912 1892486576 18.766 98 28 57 1 1920281648 19169664 8625408
16:01:44 51746 8192000000 10842589728 11310227456 1880224624 18.667 98 21 42 1 1893700048 7688816 5786608
16:02:47 58749 8192000000 10838262752 11307909120 1889385504 18.741 98 16 32 3 1899270848 6311904 3573440
16:04:10 76538 8192000000 10856862656 11344101376 1933327600 19.093 100 10 20 0 1949222448 13019872 2874976
16:05:33 49134 8192000000 10866534944 11332833280 1906723808 18.880 98 19 36 0 1919536032 8252912 4559312
16:06:56 26994 8192000000 10898875872 11352756224 1953858160 19.257 100 34 68 2 1973758688 10109936 9790592
16:07:32 59770 8192000000 10881211760 11361107968 1935917568 19.114 99 19 38 0 1951868160 10796512 5154080
16:08:39 39193 8192000000 10893750544 11360751616 1966134592 19.355 100 30 60 2 1986607376 11515232 8957552
16:09:32 16882 8192000000 10905920032 11370102784 1973010320 19.409 100 37 74 2 1992712592 8756208 10946064
16:09:58 33580 8192000000 10910421072 11372216320 1966404400 19.357 100 39 78 2 1990873824 13117792 11351632
16:11:00 51145 8192000000 10905303424 11384778752 1953975136 19.258 99 26 53 1 1976505328 15666496 6863696
16:11:57 47519 8192000000 10898421632 11383623680 1953089632 19.251 99 12 23 0 1975851280 19205408 3556240
16:12:59 82772 8192000000 10908630592 11374145536 1914139728 18.940 97 22 44 0 1933639520 13526320 5973472
16:14:28 32280 8192000000 10912424160 11371298816 1956265696 19.276 99 36 72 1 1977760336 11633216 9861424
16:15:41 59340 8192000000 10912040896 11389046784 1958636048 19.295 99 15 31 0 1972418912 10084208 3698656
16:16:47 86568 8192000000 10917237232 11401662464 1927626368 19.048 97 8 16 2 1946001216 15748320 2626528
16:18:29 53187 8192000000 10920018192 11391467520 1980327200 19.467 100 20 40 1 2003346128 17365792 5653136
16:19:36 140335 8192000000 10901286960 11376619520 1947161248 19.204 98 22 43 1 1962281968 8843552 6277168
16:22:04 35093 8192000000 10923287632 11381669888 1981713728 19.478 100 43 83 3 1999602576 6579728 11309120
16:22:45 57095 8192000000 10905930480 11379036160 1966733856 19.360 99 34 68 0 1986674496 10716640 9224000
16:23:48 88771 8192000000 10876657664 11367538688 1922441136 19.006 97 6 12 1 1935814128 11708096 1664896
16:25:23 12682 8192000000 10876292320 11366342656 1957085968 19.283 100 7 13 0 1972010544 13139632 1784944
16:26:03 45408 8192000000 10870328304 11357253632 1946630128 19.200 99 11 22 1 1955865952 6263360 2972464
16:26:56 46272 8192000000 10879080384 11348623360 1933179104 19.092 98 33 65 2 1949487328 7279744 9028480
16:28:03 110236 8192000000 10881569776 11357392896 1904306688 18.861 97 17 34 1 1918537136 9810432 4420016
16:31:04 31733 8192000000 10856615568 11334344704 1878537936 18.653 96 10 20 1 1888389536 5646544 4205056
16:31:44 62381 8192000000 9684657408 10040946688 793261696 8.828 41 10 20 1 800404592 4451328 2691568

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 12-06-2021 16:34:06 to 12-06-2021 16:34:38.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 96 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-06-2021 16:34:39 to 12-06-2021 16:34:41.

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          234919
MON$OLDEST_ACTIVE               234920
MON$OLDEST_SNAPSHOT             234920
MON$NEXT_TRANSACTION            234920
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                       2042784
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.33473 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33473 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33473 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33473 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Sat Jun 12 16:32:48 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Sat Jun 12 16:32:51 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
--- end of diff output ---

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

12.06.21 16:34:42. 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-06-12 16:34:45 No severe PSQL-related problems occured
12.06.21 16:34:46. End of report.