Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.11.2020 01:28
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 17514276 kB
MemAvailable 31500392 kB
Buffers 0 kB
Cached 14210732 kB
SwapCached 2828 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.7
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-06 01:27:02
DTS_END                         2020-11-06 01:27:02.0050
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55016
TRN_ID                          237116
ATT_ID                          669
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: 9088.78 24898 1090654
customer order: creation 168.43 352 20212
customer order: refuse 14.82 341 1778
order to supplier: creation 45.14 1309 5417
order to supplier: removal 3.36 102105 403
invoice (draft): creation 43.05 3581 5166
invoice (draft): removal 52.50 756 6300
invoice accept: apply 40.07 18373 4808
invoice accept: cancel 47.57 706 5708
customer reserve: creation 3725.13 181 447016
customer reserve: removal 4659.82 58 559178
realization accept: apply 81.65 172 9798
realization accept: cancel 82.62 104 9914
payment from customer: creation 56.78 108 6814
payment from customer: removal 5.78 103 694
payment to supplier: creation 46.45 121 5574
payment to supplier: removal 3.18 110 382
service: total inventory turnovers 4.88 1057 585
service: total monetary turnovers 6.77 19 812
service: aggregate perf. data 0.76 22575 91
service: refresh index statistics 0.03 345829 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-11-2020 01:28:43 to 06-11-2020 01:28:45.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3446
TEST_TIME 2 4812
TEST_TIME 3 4976
TEST_TIME 4 5105
TEST_TIME 5 5004
TEST_TIME 6 4954
TEST_TIME 7 5214
TEST_TIME 8 5182
TEST_TIME 9 5424
TEST_TIME 10 5450
TEST_TIME 11 5495
TEST_TIME 12 5908
TEST_TIME 13 6247
TEST_TIME 14 6277
TEST_TIME 15 6682
TEST_TIME 16 6767
TEST_TIME 17 6985
TEST_TIME 18 7289
TEST_TIME 19 8082
TEST_TIME 20 8470
TEST_TIME 21 8882
TEST_TIME 22 9205
TEST_TIME 23 9425
TEST_TIME 24 10547
TEST_TIME 25 10804
TEST_TIME 26 10934
TEST_TIME 27 10732
TEST_TIME 28 10711
TEST_TIME 29 10674
TEST_TIME 30 10539
TEST_TIME 31 10365
TEST_TIME 32 10383
TEST_TIME 33 10337
TEST_TIME 34 10374
TEST_TIME 35 10109
TEST_TIME 36 9995
TEST_TIME 37 9952
TEST_TIME 38 9982
TEST_TIME 39 9863
TEST_TIME 40 9741
TEST_TIME 41 9627
TEST_TIME 42 9694
TEST_TIME 43 9632
TEST_TIME 44 9570
TEST_TIME 45 9500
TEST_TIME 46 9371
TEST_TIME 47 9351
TEST_TIME 48 9410
TEST_TIME 49 9329
TEST_TIME 50 9423
TEST_TIME 51 9369
TEST_TIME 52 9370
TEST_TIME 53 9340
TEST_TIME 54 9469
TEST_TIME 55 9447
TEST_TIME 56 9435
TEST_TIME 57 9447
TEST_TIME 58 9477
TEST_TIME 59 9562
TEST_TIME 60 9608
TEST_TIME 61 9706
TEST_TIME 62 9764
TEST_TIME 63 9623
TEST_TIME 64 9542
TEST_TIME 65 9525
TEST_TIME 66 9530
TEST_TIME 67 9453
TEST_TIME 68 9406
TEST_TIME 69 9433
TEST_TIME 70 9340
TEST_TIME 71 9293
TEST_TIME 72 9317
TEST_TIME 73 9253
TEST_TIME 74 9281
TEST_TIME 75 9207
TEST_TIME 76 9213
TEST_TIME 77 9183
TEST_TIME 78 9201
TEST_TIME 79 9235
TEST_TIME 80 9184
TEST_TIME 81 9179
TEST_TIME 82 9317
TEST_TIME 83 9364
TEST_TIME 84 9440
TEST_TIME 85 9382
TEST_TIME 86 9440
TEST_TIME 87 9450
TEST_TIME 88 9402
TEST_TIME 89 9441
TEST_TIME 90 9374
TEST_TIME 91 9336
TEST_TIME 92 9368
TEST_TIME 93 9310
TEST_TIME 94 9287
TEST_TIME 95 9226
TEST_TIME 96 9238
TEST_TIME 97 9236
TEST_TIME 98 9249
TEST_TIME 99 9302
TEST_TIME 100 9280
TEST_TIME 101 9263
TEST_TIME 102 9292
TEST_TIME 103 9255
TEST_TIME 104 9309
TEST_TIME 105 9353
TEST_TIME 106 9341
TEST_TIME 107 9402
TEST_TIME 108 9373
TEST_TIME 109 9404
TEST_TIME 110 9428
TEST_TIME 111 9353
TEST_TIME 112 9299
TEST_TIME 113 9286
TEST_TIME 114 9269
TEST_TIME 115 9243
TEST_TIME 116 9233
TEST_TIME 117 9211
TEST_TIME 118 9181
TEST_TIME 119 9165

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-11-2020 01:28:47 to 06-11-2020 01:28:50.

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 1506100 1506100 0 0.00 0 17661 6 0 0
doc_list_biud 1506100 1506100 0 0.00 0 25039 27 0 0
sp_add_invoice_to_stock 4952 4808 144 2.90 32 170724 18373 0 144
sp_cancel_adding_invoice 5708 5708 0 0.00 5 75511 706 0 0
sp_cancel_client_order 1778 1778 0 0.00 4 9634 342 0 0
sp_cancel_customer_reserve 559178 559178 0 0.00 1 18372 58 0 0
sp_cancel_pay_from_customer 694 694 0 0.00 3 9064 103 0 0
sp_cancel_pay_to_supplier 382 382 0 0.00 2 7848 111 0 0
sp_cancel_supplier_invoice 6313 6300 13 0.20 2 11723 757 0 13
sp_cancel_supplier_order 403 403 0 0.00 10 1178533 102106 0 0
sp_cancel_write_off 9914 9914 0 0.00 1 12505 104 0 0
sp_client_order 20212 20212 0 0.00 3 22036 352 0 0
sp_customer_reserve 447016 447016 0 0.00 0 36627 181 0 0
sp_fill_shopping_cart 30777 30777 0 0.00 1 10584 37 0 0
sp_fill_shopping_cart_clo_res 447013 447013 0 0.00 0 17918 13 0 0
sp_get_clo_for_invoice 4805 4805 0 0.00 0 29177 339 0 0
sp_kill_cost_storno 16698 16698 0 0.00 0 4720 49 0 0
sp_kill_qstorno_ret_qs2qd 1134973 1134973 0 0.00 0 18363 31 0 0
sp_kill_qty_storno 597883 597883 0 0.00 0 25038 68 0 0
sp_lock_selected_doc 20237 20237 0 0.00 0 7823 5 0 0
sp_make_cost_storno 26990 26990 0 0.00 0 17657 49 0 0
sp_multiply_rows_for_pdistr 26990 26990 0 0.00 0 8555 28 0 0
sp_multiply_rows_for_qdistr 20212 20212 0 0.00 0 9616 147 0 0
sp_pay_from_customer 6814 6814 0 0.00 4 10376 108 0 0
sp_pay_to_supplier 5574 5574 0 0.00 5 10912 122 0 0
sp_payment_common 12388 12388 0 0.00 1 10266 28 0 0
sp_qd_handle_on_cancel_clo 1778 1778 0 0.00 0 9627 304 0 0
sp_qd_handle_on_invoice_upd_sts 10512 10512 0 0.00 0 25037 310 0 0
sp_qd_handle_on_reserve_upd_sts 9798 9798 0 0.00 0 10520 58 0 0
sp_reserve_write_off 9798 9798 0 0.00 6 17668 173 0 0
sp_supplier_invoice 5166 5166 0 0.00 6 111610 3581 0 0
sp_supplier_order 5417 5417 0 0.00 6 35313 1310 0 0
srv_aggregate_perf_data 91 91 0 0.00 2461 606395 22576 0 0
srv_fill_mon_cache_memory 154 154 0 0.00 1056 134813 34443 0 0
srv_find_qd_qs_mism 1045269 1045269 0 0.00 0 11391 5 0 0
srv_make_invnt_saldo 585 585 0 0.00 31 48849 1058 0 0
srv_make_money_saldo 812 812 0 0.00 0 1059 19 0 0
srv_recalc_idx_stat 4 4 0 0.00 227100 519178 345829 0 0
t$perf-abend:sp_add_invoice_to_stock 144 144 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 4808 4808 0 0.00 0 19688 153 0 0
t$perf-norm:sp_cancel_adding_invoice 370 370 0 0.00 0 4051 103 0 0
t$perf-norm:sp_cancel_client_order 1778 1778 0 0.00 0 4416 15 0 0
t$perf-norm:sp_cancel_customer_reserve 698 698 0 0.00 0 20243 39 0 0
t$perf-norm:sp_cancel_pay_from_customer 694 694 0 0.00 0 2530 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 382 382 0 0.00 0 1456 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 377 377 0 0.00 0 4103 23 0 0
t$perf-norm:sp_cancel_supplier_order 403 403 0 0.00 0 30174 1772 0 0
t$perf-norm:sp_cancel_write_off 934 934 0 0.00 0 3265 18 0 0
t$perf-norm:sp_client_order 20212 20212 0 0.00 0 18569 20 0 0
t$perf-norm:sp_customer_reserve 955 955 0 0.00 0 3356 7 0 0
t$perf-norm:sp_pay_from_customer 6814 6814 0 0.00 0 3880 9 0 0
t$perf-norm:sp_pay_to_supplier 5574 5574 0 0.00 0 3859 10 0 0
t$perf-norm:sp_reserve_write_off 9798 9798 0 0.00 0 25932 15 0 0
t$perf-norm:sp_supplier_invoice 5166 5166 0 0.00 0 9451 18 0 0
t$perf-norm:sp_supplier_order 5417 5417 0 0.00 0 8312 20 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 101 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 167 3 0 0
t$perf-norm:srv_make_invnt_saldo 585 585 0 0.00 0 3449 26 0 0
t$perf-norm:srv_make_money_saldo 812 812 0 0.00 0 822 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 9896 9608 288 2.91 0 5182 19 0 288
v_all_customers 36544 36544 0 0.00 0 48 1 0 0
v_all_suppliers 29236 29236 0 0.00 0 48 1 0 0
v_all_wares 40422 40422 0 0.00 0 38 1 0 0
v_cancel_adding_invoice 740 740 0 0.00 0 5284 14 0 0
v_cancel_client_order 3556 3556 0 0.00 0 4060 10 0 0
v_cancel_customer_prepayment 1388 1388 0 0.00 0 4796 18 0 0
v_cancel_customer_reserve 1396 1396 0 0.00 0 1951 8 0 0
v_cancel_payment_to_supplier 764 764 0 0.00 0 5848 15 0 0
v_cancel_supplier_invoice 780 754 26 3.33 0 1347 15 0 26
v_cancel_supplier_order 806 806 0 0.00 0 2895 7 0 0
v_cancel_write_off 1868 1868 0 0.00 0 3992 22 0 0
v_max_id_clo_ord 5415 5415 0 0.00 0 5320 2 0 0
v_max_id_clo_res 955 955 0 0.00 0 2459 16 0 0
v_max_id_ord_sup 5151 5151 0 0.00 0 3352 4 0 0
v_max_non_paid_invoice 1522 1522 0 0.00 0 3115 5 0 0
v_max_non_paid_realizn 3670 3670 0 0.00 0 4276 5 0 0
v_min_id_clo_ord 5415 5415 0 0.00 0 2187 5 0 0
v_min_id_clo_res 955 955 0 0.00 0 6075 16 0 0
v_min_id_ord_sup 5151 5151 0 0.00 0 4709 5 0 0
v_min_non_paid_invoice 5574 5574 0 0.00 0 7144 20 0 0
v_min_non_paid_realizn 6814 6814 0 0.00 0 10257 18 0 0
v_our_firm 10166 10166 0 0.00 0 15 1 0 0
v_reserve_write_off 19594 19594 0 0.00 0 8237 8 0 0
x_lock_depdocs_on_canc_invoice 11631 11631 0 0.00 0 19186 110 0 0
x_lock_depdocs_on_canc_sup_ord 403 403 0 0.00 0 4932 293 0 0
x_make_qstorno_1000_1200 5417 5417 0 0.00 2 35276 1239 0 0
x_make_qstorno_1200_2000 5166 5166 0 0.00 2 103622 3434 0 0
x_make_qstorno_2100_3300 447016 447016 0 0.00 0 36112 165 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-11-2020 01:28:51 to 06-11-2020 01:28:55.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:05 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:11 8441 8192000000 10170958720 10468847616 843623232 9.336 69 46 97 0 861589920 2226032 15740656
22:57:28 33075 8192000000 10344801024 10661670912 1366013760 14.291 100 76 152 0 1394013456 3884992 24114704
22:58:12 37282 8192000000 10387817760 10711150592 1440648112 14.955 100 90 180 0 1476598784 6629616 29321056
22:58:58 15806 8192000000 10396986128 10726850560 1455502608 15.086 100 87 174 0 1491433936 7743968 28187360
22:59:22 20757 8192000000 10419140608 10749419520 1475682304 15.264 100 92 184 0 1513550944 8189152 29679488
22:59:56 21479 8192000000 10432583808 10767212544 1487336416 15.366 100 84 166 1 1522490560 8529488 26624656
23:00:26 22114 8192000000 10447738368 10785570816 1503191344 15.504 100 86 171 1 1539721888 9423200 27107344
23:00:56 15254 8192000000 10466609536 10808320000 1522070144 15.668 100 80 160 1 1557195856 9701792 25423920
23:01:21 14853 8192000000 10488515168 10834227200 1546896816 15.883 100 88 176 0 1584526608 10532736 27097056
23:01:48 18707 8192000000 10522357648 10874507264 1573748688 16.114 100 84 169 0 1614809808 15521792 25539328
23:02:15 15422 8192000000 10542282704 10895237120 1599606720 16.336 100 81 162 1 1635593920 11296256 24690944
23:02:45 10926 8192000000 10561324080 10920476672 1620802480 16.517 100 73 146 0 1654567152 11854864 21909808
23:03:04 10008 8192000000 10575359728 10934083584 1636216320 16.648 100 79 158 2 1672005872 12445632 23343920
23:03:25 12845 8192000000 10604384944 10967842816 1653903232 16.797 100 79 158 1 1690396064 12766400 23726432
23:03:46 9136 8192000000 10607519392 10977095680 1670023488 16.933 100 73 146 1 1703952512 12385904 21543120
23:04:04 5499 8192000000 10627250592 10998689792 1693617136 17.132 100 75 150 1 1728137552 12604224 21916192
23:04:19 8740 8192000000 10635151920 11015131136 1707714768 17.250 100 67 132 3 1738968544 12096208 19157568
23:04:39 4988 8192000000 10653104768 11030773760 1726962304 17.410 100 65 129 0 1757890976 11662800 19265872
23:04:51 2902 8192000000 10669818080 11050459136 1736110016 17.486 100 66 132 1 1766296384 11280368 18906000
23:05:00 6213 8192000000 10685797440 11069153280 1754880928 17.642 100 67 134 0 1785943072 12003216 19058928
23:05:16 4337 8192000000 10706466288 11084328960 1762265488 17.703 100 77 151 3 1795486544 12247344 20973712
23:05:29 6432 8192000000 10707743952 11092901888 1771372304 17.778 100 74 147 1 1803991856 11786032 20833520
23:05:43 3181 8192000000 10721010464 11109056512 1781847280 17.865 100 82 160 2 1816794064 11936816 23009968
23:05:53 3615 8192000000 10732832304 11121205248 1799495536 18.010 100 74 149 2 1832467536 12183568 20788432
23:06:04 2551 8192000000 10752855760 11142389760 1817015392 18.153 100 82 161 1 1851858064 12359632 22483040
23:06:13 3859 8192000000 10758348112 11147059200 1822578416 18.199 100 77 155 4 1857684224 12636752 22469056
23:06:24 3835 8192000000 10778763376 11160948736 1832097280 18.276 100 89 179 1 1869539616 13073040 24369296
23:06:34 2471 8192000000 10762319824 11152429056 1830691888 18.265 100 86 172 1 1869067616 14390032 23985696
23:06:43 2540 8192000000 10766715856 11157053440 1836134496 18.309 100 87 174 1 1874309376 13737008 24437872
23:06:52 2145 8192000000 10784386592 11167494144 1841470496 18.353 100 86 170 1 1878290192 12787168 24032528
23:07:02 3132 8192000000 10786046112 11175759872 1846807696 18.396 100 88 176 2 1884757648 13384032 24565920
23:07:11 2028 8192000000 10788196928 11178467328 1850717264 18.428 100 86 173 1 1887107664 12465744 23924656
23:07:20 1871 8192000000 10800029392 11187765248 1857487440 18.483 100 88 177 0 1895897216 13416960 24992816
23:07:28 3073 8192000000 10795573296 11190247424 1856595168 18.476 100 83 166 1 1893585056 13983856 23006032
23:07:38 3563 8192000000 10806085552 11196780544 1864483280 18.540 100 90 180 2 1903861504 14167632 25210592
23:07:48 1791 8192000000 10808358656 11199635456 1868859712 18.575 100 91 184 1 1907803600 13512032 25431856
23:07:57 1874 8192000000 10810246464 11199905792 1874158400 18.618 100 84 165 3 1909464880 11635520 23670960
23:08:06 2964 8192000000 10813953872 11203850240 1869615824 18.581 100 85 171 3 1906647392 12936640 24094928
23:08:15 2036 8192000000 10814172960 11209142272 1873871248 18.616 100 88 176 1 1912211376 14246304 24093824
23:08:24 2277 8192000000 10825638064 11213414400 1876435568 18.636 100 89 178 2 1915593408 14224528 24933312
23:08:33 12592 8192000000 10815940896 11210268672 1876010976 18.633 100 79 158 1 1912291408 14657760 21622672
23:08:52 1389 8192000000 10828679712 11220471808 1880653920 18.670 100 88 177 1 1918859808 13143936 25061952
23:08:59 13894 8192000000 10800745968 11208646656 1873318608 18.611 100 48 96 1 1897480272 9798944 14362720
23:09:21 4198 8192000000 10783135952 11205844992 1878077808 18.650 100 44 88 2 1898193904 7598064 12518032
23:09:31 6119 8192000000 10798821136 11208572928 1875797648 18.631 100 41 84 0 1894839184 7725168 11316368
23:09:45 5653 8192000000 10799243168 11217403904 1881027904 18.673 100 40 81 2 1900563920 8338576 11197440
23:09:57 5758 8192000000 10789878832 11216310272 1881099344 18.674 100 26 52 1 1895798016 7724016 6974656
23:10:13 2857 8192000000 10808186256 11224977408 1888583744 18.734 100 45 89 0 1907574256 6285008 12705504
23:10:24 6658 8192000000 10801552256 11226648576 1893136928 18.771 100 38 76 1 1910615216 7244512 10233776
23:10:37 7282 8192000000 10809242960 11230289920 1890633520 18.751 100 28 56 1 1905466848 6753072 8080256
23:10:54 7588 8192000000 10798624080 11230625792 1890583792 18.750 100 26 52 1 1906025840 8233232 7208816
23:11:10 11218 8192000000 10798272000 11231694848 1892745888 18.768 100 19 38 0 1904933744 5853344 6334512
23:11:27 12287 8192000000 10804243760 11235319808 1896381776 18.797 100 19 38 0 1908093680 5858464 5853440
23:11:46 7272 8192000000 10806519264 11239170048 1898754624 18.816 100 27 54 2 1912434512 6858000 6821888
23:12:03 15825 8192000000 10813721792 11242811392 1901317296 18.837 100 28 56 1 1915694896 6412304 7965296
23:13:09 30148 8192000000 10830380896 11259838464 1904812368 18.865 100 21 42 3 1916642240 5302544 6527328
23:13:45 6779 8192000000 10825200880 11257667584 1908573536 18.895 100 22 44 2 1920793568 6266512 5953520
23:14:02 8238 8192000000 10828061248 11262672896 1910105280 18.907 100 28 56 1 1923978544 6004608 7868656
23:14:17 5673 8192000000 10829215392 11262091264 1910097504 18.907 100 20 40 2 1922128912 6404512 5626896
23:14:31 8247 8192000000 10825290208 11265175552 1914837568 18.945 100 23 45 3 1928061072 6446240 6777264
23:14:47 4884 8192000000 10832460032 11266957312 1919818656 18.985 100 32 64 2 1935483728 7040656 8624416
23:15:00 5067 8192000000 10832528080 11271340032 1917734016 18.969 100 25 51 1 1930084976 5328176 7022784
23:15:11 4844 8192000000 10833499184 11265167360 1915834352 18.953 100 31 62 0 1930771472 5216736 9720384
23:15:23 7966 8192000000 10829652896 11261841408 1896143808 18.795 99 29 58 2 1914672944 10176176 8352960
23:15:39 10981 8192000000 10827812768 11264000000 1911283824 18.917 100 17 33 3 1921569824 5225664 5060336
23:15:56 10083 8192000000 10822037168 11253977088 1874520048 18.621 98 23 46 1 1887106944 6308768 6278128
23:16:19 5272 8192000000 10799042080 11233771520 1869347248 18.579 98 18 36 0 1880205840 5779936 5078656
23:16:31 14549 8192000000 10806188464 11246968832 1892623024 18.767 100 6 12 1 1899339024 5438096 1277904
23:16:54 64074 8192000000 10757308304 11191824384 1771641760 17.781 94 21 42 2 1783584496 5389360 6553376
23:18:11 10586 8192000000 10735367664 11158925312 1778250144 17.835 96 18 36 1 1789378464 6234544 4893776
23:18:30 8377 8192000000 10749532976 11172438016 1788492624 17.919 97 25 50 1 1800619344 5096304 7030416
23:18:47 3550 8192000000 10771944608 11193536512 1833655488 18.289 99 43 86 2 1853669744 7200256 12814000
23:18:59 5952 8192000000 10759299456 11173990400 1812753648 18.118 99 28 54 2 1826229824 5224816 8251360
23:19:13 5092 8192000000 10743933568 11162865664 1786518016 17.903 97 37 74 0 1803006432 6057008 10431408
23:19:25 5851 8192000000 10737581648 11145310208 1754718032 17.641 96 25 50 0 1768102640 6495920 6888688
23:19:37 8679 8192000000 10704632656 11123744768 1710601840 17.274 94 23 46 3 1722691216 5164128 6925248
23:19:55 5516 8192000000 10707537296 11120164864 1771378368 17.778 98 27 53 1 1785116304 5637952 8099984
23:20:07 4358 8192000000 10722844992 11136229376 1800507440 18.018 99 38 75 3 1817003296 6364000 10131856
23:20:20 9629 8192000000 10700854688 11109027840 1715538288 17.315 95 32 64 4 1734201712 9718160 8945264
23:20:36 9414 8192000000 10696298640 11109122048 1717047712 17.328 96 36 73 1 1734206320 6210752 10947856
23:20:53 9932 8192000000 10708149280 11124051968 1765607312 17.731 98 27 54 2 1779091792 4952256 8532224
23:21:10 9211 8192000000 10728240656 11138539520 1776549568 17.821 98 28 56 1 1790157680 5416560 8191552
23:21:26 69086 8192000000 10728592576 11155210240 1812888128 18.120 99 41 82 1 1831326880 5537936 12900816
23:22:43 9743 8192000000 10747642480 11169853440 1829931248 18.259 100 29 58 1 1848125424 9807792 8386384
23:22:59 6763 8192000000 10742828576 11171389440 1834526960 18.296 100 28 57 1 1849334976 6365632 8442384
23:23:14 8950 8192000000 10765566640 11188805632 1848163488 18.407 100 28 57 1 1862321872 5842208 8316176
23:23:30 8005 8192000000 10777755472 11201372160 1857841456 18.486 100 25 50 0 1871747536 7221280 6684800
23:23:45 10951 8192000000 10772714160 11199115264 1860802368 18.510 100 29 58 4 1875899424 6597936 8499120
23:24:04 5599 8192000000 10785655552 11207180288 1863174768 18.529 100 29 55 0 1877808288 5801280 8832240
23:24:15 10973 8192000000 10776315920 11205591040 1864689472 18.541 100 27 54 1 1878708112 6537792 7480848
23:24:32 9827 8192000000 10770067984 11207364608 1864426624 18.539 100 20 36 3 1875426768 5251616 5748528
23:24:50 9655 8192000000 10781721824 11213824000 1868800704 18.575 100 26 52 3 1881495296 5204800 7489792
23:25:06 9307 8192000000 10790508528 11216977920 1871380928 18.595 100 22 42 2 1883193952 5086048 6726976
23:25:22 8041 8192000000 10778531600 11215175680 1871999312 18.600 100 27 54 2 1885806784 6235232 7572240
23:25:36 8469 8192000000 10787254112 11215015936 1871403472 18.596 100 22 44 1 1883303584 5239904 6660208
23:25:54 7440 8192000000 10788159984 11221577728 1872759344 18.607 100 14 28 1 1882258848 5234896 4264608
23:26:09 18581 8192000000 10795117056 11220418560 1877177568 18.642 100 24 49 2 1889614864 5432144 7005152
23:26:34 134813 8192000000 10835874608 11265081344 1896625456 18.799 100 36 72 0 1914660160 7779168 10255536
23:28:57 7272 8192000000 10866826512 11281793024 1926442192 19.038 100 58 116 0 1954757520 11846416 16468912
23:29:12 13791 8192000000 10847214464 11272658944 1920630064 18.992 100 48 95 1 1946577680 12216352 13731264
23:29:34 3326 8192000000 10854893776 11281268736 1929652160 19.064 100 52 104 3 1956900288 12143648 15104480
23:29:52 20973 8192000000 10864409984 11293315072 1936547520 19.119 100 44 87 2 1960922336 11794544 12580272
23:30:29 31427 8192000000 10880162752 11311656960 1950100224 19.227 100 41 80 3 1975532832 14198688 11233920
23:31:11 10362 8192000000 10889434800 11319001088 1954880832 19.265 100 40 81 1 1980625360 13988608 11755920
23:31:30 7021 8192000000 10910061568 11326578688 1961205456 19.316 100 59 117 2 1993522496 16008768 16308272
23:31:46 10993 8192000000 10907020208 11328933888 1963989712 19.338 100 56 112 0 1996390720 16460176 15940832
23:32:08 23918 8192000000 10904202944 11334279168 1963404400 19.333 100 47 94 2 1994462816 17408592 13649824
23:32:49 16348 8192000000 10907764912 11341869056 1971650560 19.399 100 44 88 0 2001573280 17119872 12802848
23:33:14 4515 8192000000 10916113744 11335577600 1956283952 19.276 99 52 104 1 1988080720 16461824 15334944
23:33:31 8577 8192000000 10912577824 11338059776 1968958672 19.377 100 41 80 1 1998013600 17106624 11948304
23:33:46 19847 8192000000 10918302976 11348709376 1973575040 19.414 100 52 101 2 2007044160 18189952 15279168
23:34:13 22055 8192000000 10924756224 11358527488 1983168864 19.490 100 47 94 0 2016955776 19484912 14302000
23:34:45 6057 8192000000 10928577680 11360423936 1987533440 19.524 100 49 98 2 2019546016 17572992 14439584
23:35:03 1056 8192000000 10959974944 11373621248 2001737744 19.636 100 90 172 2 2046409744 19242624 25429376
23:35:11 15744 8192000000 10939864512 11369152512 1992204400 19.561 100 62 124 0 2030028512 19747648 18076464
23:35:34 8578 8192000000 10948218880 11375611904 1995351152 19.586 100 62 122 0 2035015296 22293984 17370160
23:35:53 3315 8192000000 10956886800 11381207040 1999043360 19.615 100 64 126 3 2042479440 23487520 19948560
23:36:05 11484 8192000000 10946514192 11375042560 1981324848 19.475 99 59 117 2 2022939936 23992368 17622720
23:36:27 3989 8192000000 10955091376 11378167808 1993768032 19.574 100 60 121 2 2035213344 23434784 18010528
23:36:39 5609 8192000000 10954307136 11380379648 2001470624 19.634 100 65 130 1 2043511968 23274016 18767328
23:36:53 9184 8192000000 10963730800 11378511872 1983522896 19.493 99 65 130 1 2027231840 24432048 19276896
23:37:11 5445 8192000000 10941026320 11369975808 1991292416 19.554 100 66 132 1 2036613024 25958640 19361968
23:37:26 5675 8192000000 10956955472 11387457536 2007843280 19.685 100 66 130 1 2054791792 27589696 19358816
23:37:41 13493 8192000000 10969310736 11398365184 2003178928 19.648 100 64 129 2 2054988704 32947696 18862080
23:38:02 2672 8192000000 10972051232 11401633792 2017121616 19.758 100 72 144 2 2067864208 29036848 21705744
23:38:15 13546 8192000000 10983036512 11410272256 2020301648 19.783 100 68 135 1 2071007088 30706160 19999280
23:38:47 9043 8192000000 10963456864 11399196672 1995028032 19.584 99 52 101 3 2043209072 32282192 15898848
23:39:03 7671 8192000000 10980871232 11414188032 2017394704 19.760 100 60 120 0 2069015168 32625840 18994624
23:39:20 3486 8192000000 10981098032 11402936320 2011728496 19.715 100 74 145 2 2066531296 32859072 21943728
23:39:30 14419 8192000000 10972651328 11394437120 1973770928 19.415 98 66 131 5 2027676080 33879552 20025600
23:39:52 3210 8192000000 10957032144 11377520640 1979887920 19.464 99 70 140 1 2037892928 36226544 21778464
23:40:03 2558 8192000000 10975004656 11397648384 2004464496 19.658 100 85 169 0 2066606592 36312880 25829216
23:40:17 9527 8192000000 10963986128 11393150976 1994770384 19.581 100 62 124 0 2050968896 36855808 19342704
23:40:38 13635 8192000000 10951439888 11394207744 1995787328 19.589 100 53 106 2 2048272800 35484784 17000688
23:41:03 13372 8192000000 10953097440 11384369152 1961138608 19.315 98 54 108 0 2016686720 38374832 17173280
23:41:23 6867 8192000000 10976529424 11396685824 1981011136 19.473 99 72 145 0 2043560832 39440112 23109584
23:41:43 3719 8192000000 10918200800 11339452416 1930357536 19.070 98 72 142 3 1994316128 41201376 22757216
23:41:56 2945 8192000000 10950962864 11365642240 1962434544 19.325 100 87 174 0 2032238816 42277776 27526496
23:42:07 4277 8192000000 10959085472 11367436288 1966839472 19.360 100 81 161 1 2035878768 44379552 24659744
23:42:19 4158 8192000000 10964354304 11382751232 1985552048 19.509 100 88 176 0 2057172144 44544752 27075344
23:42:32 4792 8192000000 10965183344 11381481472 1980756112 19.471 100 80 160 1 2052229376 46041664 25431600
23:42:49 9629 8192000000 10946717216 11372503040 1954040128 19.259 99 63 125 2 2020469664 44899456 21530080
23:43:10 4423 8192000000 10950430000 11373723648 1969088224 19.378 100 56 112 0 2035219584 47041984 19089376
23:43:29 4209 8192000000 10954185616 11376295936 1944626176 19.184 98 67 134 1 2016672048 49539104 22506768
23:43:43 2974 8192000000 10969857616 11385741312 1972218784 19.403 100 78 153 1 2051592560 54134720 25239056
23:43:59 3211 8192000000 10971917456 11391602688 1977050096 19.441 100 74 146 1 2057148560 55835568 24262896
23:44:14 2431 8192000000 10969650928 11391909888 1976522704 19.437 100 68 136 2 2054957264 56369584 22064976
23:44:26 1997 8192000000 10982369680 11402031104 1978936848 19.456 100 66 131 1 2062161280 61590592 21633840
23:44:36 3363 8192000000 10970535056 11385847808 1972496640 19.405 99 75 150 1 2055499872 58379680 24623552
23:44:46 2372 8192000000 10967811168 11381911552 1965230656 19.348 100 78 155 2 2047325376 56597744 25496976
23:44:55 2504 8192000000 10965558880 11375878144 1948927024 19.218 99 87 172 2 2034558048 57969696 27661328
23:45:05 3168 8192000000 10973617712 11385565184 1967538880 19.366 100 82 163 1 2052966528 59280880 26146768
23:45:15 2839 8192000000 10981258176 11390763008 1974197088 19.419 100 88 176 2 2061998272 59408912 28392272
23:45:26 2399 8192000000 10940856384 11351891968 1938055392 19.131 99 85 169 1 2024703136 59287280 27360464
23:45:36 3251 8192000000 10958308512 11370082304 1951987776 19.242 100 81 164 1 2039285952 60727584 26570592
23:45:48 2581 8192000000 10965718080 11376832512 1963710176 19.336 100 83 166 1 2048967872 58897344 26360352
23:45:59 2267 8192000000 10966802176 11376861184 1959190784 19.300 100 78 154 0 2041767424 57623264 24953376
23:46:07 4413 8192000000 10952825008 11363168256 1956972128 19.282 100 78 156 1 2040947568 58107040 25868400
23:46:20 18774 8192000000 10931917296 11366989824 1949762432 19.225 100 49 98 1 2022761440 56240992 16758016
23:46:54 7085 8192000000 10928066816 11368042496 1949803920 19.225 100 37 74 0 2014557712 51817296 12936496
23:47:16 7053 8192000000 10934688112 11363397632 1939938480 19.146 99 51 102 1 2007374064 50013248 17422336
23:47:37 7016 8192000000 10935564640 11371905024 1946692912 19.200 100 49 98 0 2019184720 55837488 16654320
23:47:54 23242 8192000000 10925630816 11368595456 1949798144 19.225 100 30 60 0 2011218768 51058944 10361680
23:48:34 17196 8192000000 10904277120 11352129536 1932328272 19.085 100 35 70 0 1997071248 51424704 13318272
23:48:58 12646 8192000000 10900234192 11357495296 1934212592 19.101 100 26 50 2 1993310096 50365456 8732048
23:49:18 28554 8192000000 10893770304 11335999488 1882041920 18.682 97 25 50 1 1938471824 47549456 8880448
23:49:54 35625 8192000000 10876089424 11328352256 1883954192 18.697 98 20 40 0 1940257056 49166096 7136768
23:50:37 14833 8192000000 10878187728 11334639616 1891494544 18.758 99 17 34 1 1947879568 50338048 6046976
23:51:09 35329 8192000000 10878288608 11338448896 1898018752 18.810 99 22 44 3 1952054704 47036976 6998976
23:51:51 63366 8192000000 10839168272 11294748672 1803417952 18.042 94 9 18 0 1836163680 29968048 2777680
23:53:02 10797 8192000000 10848950592 11297136640 1884266416 18.700 99 25 47 2 1914605040 22892384 7446240
23:53:33 41109 8192000000 10856066112 11304525824 1911461040 18.918 100 25 50 1 1937404336 18380384 7562912
23:54:42 13623 8192000000 10871756752 11318853632 1932568992 19.087 100 37 75 2 1960109952 17052272 10488688
23:55:03 25666 8192000000 10870348816 11324235776 1925863584 19.034 100 22 44 0 1950968432 18371568 6733280
23:56:55 72452 8192000000 10874185744 11344666624 1939657776 19.144 100 14 28 0 1962306128 18612464 4035888
23:58:24 16459 8192000000 10877073888 11345842176 1945863600 19.194 100 9 18 2 1966037520 17878256 2295664
23:59:01 63236 8192000000 10846548640 11300114432 1890522400 18.750 97 24 48 0 1910349776 12483136 7344240
00:00:15 70434 8192000000 10869131904 11334250496 1927216032 19.045 99 6 12 0 1939366784 10950912 1199840
00:01:33 87937 8192000000 10910055792 11345530880 1957777760 19.288 100 27 55 0 1975619968 9415152 8427056
00:03:14 47542 8192000000 10909102992 11351711744 1950940448 19.234 99 38 75 1 1969678256 8609120 10128688
00:04:14 55860 8192000000 10879256368 11325911040 1898725904 18.816 97 37 73 1 1919676208 10295248 10655056
00:05:16 58902 8192000000 10871994320 11337482240 1935439744 19.110 99 16 32 2 1947899024 8136112 4323168
00:06:21 38229 8192000000 10868568464 11333275648 1936695184 19.120 99 7 14 0 1945967440 7511136 1761120
00:07:06 5277 8192000000 10878361472 11338412032 1954799296 19.265 100 18 36 2 1968018016 7961920 5256800
00:07:17 23370 8192000000 10884120752 11349544960 1965901584 19.353 100 25 50 0 1982846576 9821024 7123968
00:07:50 24669 8192000000 10905678080 11340795904 1930055040 19.067 98 28 57 3 1947230368 8851632 8323696
00:08:26 40114 8192000000 10889772992 11346857984 1960054688 19.306 100 37 73 0 1982147568 10817936 11274944
00:09:12 40647 8192000000 10888262128 11348480000 1941996064 19.163 99 32 65 0 1962064608 10731376 9337168
00:10:04 17320 8192000000 10904530704 11353845760 1965047872 19.346 100 53 107 4 1989515568 9402224 15065472
00:10:27 32126 8192000000 10892199392 11350425600 1955207920 19.268 99 44 86 5 1978740480 10418432 13114128
00:11:06 37675 8192000000 10904370400 11367858176 1970489008 19.389 100 26 52 2 1990038368 11939088 7610272
00:12:01 54537 8192000000 10903906592 11378884608 1979927760 19.464 100 19 38 1 1999684544 14225360 5531424
00:14:13 52344 8192000000 10915099904 11392327680 1984093296 19.497 100 19 36 2 2005702736 16586096 5023344
00:15:23 47220 8192000000 10903580752 11389493248 1966173344 19.355 99 10 20 1 1985699264 16545872 2980048
00:17:01 88226 8192000000 10926794832 11391881216 1990606992 19.549 100 23 45 1 2014098112 17148384 6342736
00:18:38 35683 8192000000 10911174560 11376283648 1939439120 19.142 97 17 33 3 1951539952 7491568 4609264
00:19:46 37658 8192000000 10920970960 11384406016 1952407760 19.246 98 26 52 1 1970070416 10136272 7526384
00:20:43 84382 8192000000 10913959280 11384967168 1970362144 19.388 99 18 36 1 1988609776 13091024 5156608
00:22:13 27885 8192000000 10937585696 11400097792 2001994752 19.638 100 49 96 2 2025322736 9361424 13966560
00:22:47 73121 8192000000 10925442192 11383803904 1916066848 18.955 96 30 60 0 1939099008 15053152 7979008
00:24:07 64552 8192000000 10906404064 11366977536 1926129520 19.036 97 24 48 1 1949075488 15806192 7139776
00:25:24 82628 8192000000 10900758768 11382067200 1939951600 19.146 98 19 38 0 1969037056 23028624 6056832
00:26:57 92809 8192000000 10901982640 11384496128 1920682544 18.992 97 12 24 2 1940268928 15930624 3655760
00:28:38 132658 8192000000 10897472976 11359035392 1881535664 18.678 95 12 24 0 1897284416 12813872 2934880
00:30:57 98432 8192000000 10854529536 11321954304 1859011392 18.495 94 29 57 1 1879004256 11883728 8109136
00:32:42 62226 8192000000 10856362256 11342311424 1923783024 19.017 99 13 26 0 1940006784 12947184 3276576
00:34:02 62046 8192000000 10848209680 11319787520 1853688752 18.452 95 10 20 1 1863957424 7541792 2726880
00:35:11 55398 8192000000 10850428032 11328765952 1910532224 18.911 99 11 21 1 1926951968 13161664 3258080
00:36:15 84605 8192000000 10838733600 11309056000 1881187952 18.675 97 9 18 1 1899295328 15975088 2132288
00:37:46 25421 8192000000 10859039472 11314167808 1904624512 18.863 98 42 83 2 1925578816 9786144 11168160
00:38:17 90249 8192000000 10847775904 11331051520 1897030176 18.802 98 17 34 1 1915991936 14221600 4740160
00:40:01 53095 8192000000 10845510832 11314458624 1883570800 18.694 97 18 36 0 1900717104 11257616 5888688
00:41:06 47102 8192000000 10852901008 11331211264 1930263456 19.069 100 10 20 0 1946464688 13471696 2729536
00:42:00 43282 8192000000 10834139760 11313422336 1883125696 18.690 98 13 26 1 1900015616 12904992 3984928
00:42:49 36804 8192000000 10842350480 11302981632 1846744816 18.396 96 21 41 4 1863057168 10298736 6013616
00:44:00 17420 8192000000 10861197792 11323170816 1931746864 19.081 100 38 75 1 1950100160 7867920 10485376
00:44:24 38128 8192000000 10847942464 11306504192 1848772288 18.412 96 27 54 0 1865502784 9607152 7123344
00:45:15 77169 8192000000 10829801008 11309039616 1845320192 18.384 96 19 38 2 1866207248 15848528 5038528
00:46:41 71517 8192000000 10864289280 11318595584 1855505136 18.467 96 18 36 2 1876172432 15388576 5278720
00:48:06 67348 8192000000 10846555904 11319857152 1900172112 18.828 99 14 28 1 1921056304 16843936 4040256
00:49:32 119135 8192000000 10866887312 11346853888 1919403776 18.982 99 21 42 1 1938843344 13294960 6144608
00:51:38 73091 8192000000 10867728240 11316486144 1873221376 18.610 97 11 22 0 1889591904 13540944 2829584
00:52:58 36821 8192000000 10883880096 11345039360 1934841712 19.106 100 34 68 2 1958525040 13787248 9896080
00:54:20 94504 8192000000 10873384576 11319177216 1799385600 18.009 93 19 38 0 1821979056 17840352 4753104
00:56:00 19249 8192000000 10878698960 11324452864 1925796864 19.033 100 41 83 1 1948646704 11421984 11427856
00:56:31 115060 8192000000 10862197344 11319279616 1897288512 18.804 98 39 78 1 1918972912 10176464 11507936
00:58:59 63743 8192000000 10867784448 11342553088 1940450368 19.150 99 22 44 0 1962498544 16456496 5591680
01:00:11 29190 8192000000 10871828848 11350417408 1953702896 19.256 100 8 16 0 1965421840 9753616 1965328
01:00:56 65800 8192000000 10879766192 11358371840 1963809776 19.336 100 16 32 1 1978055504 9057904 5187824
01:03:35 60457 8192000000 10885580768 11368206336 1923345552 19.014 98 7 14 0 1937843664 12921600 1576512
01:04:42 36334 8192000000 10887014992 11360886784 1947306064 19.205 99 18 36 1 1960419808 8187328 4926416
01:05:30 54012 8192000000 10896581520 11370418176 1957937168 19.290 99 16 32 0 1972385776 9599136 4849472
01:06:39 51376 8192000000 10896379696 11375042560 1957466144 19.286 99 11 22 0 1971931616 10677024 3788448
01:07:37 53611 8192000000 10930710832 11387842560 1960456624 19.310 99 29 57 0 1977797488 8881760 8459104
01:08:41 46522 8192000000 10917979216 11384455168 1971218128 19.395 99 41 83 0 1997612032 15001392 11392512
01:09:34 107255 8192000000 10930266384 11406692352 1975742736 19.431 99 18 36 1 1998407824 17759488 4905600
01:11:35 74175 8192000000 10901169872 11366653952 1920261296 18.989 97 19 38 0 1944064224 18375648 5427280
01:12:57 24893 8192000000 10905301920 11360051200 1942008096 19.163 98 43 86 1 1965218576 10534528 12675952
01:13:28 20828 8192000000 10893423712 11346878464 1929668400 19.064 98 42 83 0 1952774480 11437184 11668896
01:13:55 26229 8192000000 10911691328 11369709568 1960805376 19.312 100 37 74 1 1985616272 14427360 10383536
01:14:32 74978 8192000000 10893758880 11338702848 1912188928 18.924 97 22 44 0 1932713808 13801536 6723344
01:15:57 32950 8192000000 10910195360 11365568512 1944627936 19.184 99 31 62 2 1965628960 12803712 8197312
01:16:36 75901 8192000000 10901700288 11374645248 1950455136 19.230 99 22 44 0 1974178464 17883200 5840128
01:17:59 100493 8192000000 10892938528 11365126144 1949220720 19.220 99 23 44 1 1966889424 10842064 6826640
01:19:46 55796 8192000000 10905345264 11355234304 1938239104 19.133 98 33 66 0 1956419440 8603360 9576976
01:20:53 52417 8192000000 10874293616 11356184576 1889304368 18.740 96 20 39 2 1902514192 8104480 5105344
01:21:56 64710 8192000000 10867951728 11354865664 1941280352 19.157 99 15 30 2 1957197264 11503200 4413712
01:23:07 23189 8192000000 10865981760 11351851008 1934093616 19.100 99 5 10 0 1945083184 9499648 1489920
01:23:40 33444 8192000000 10862655872 11337568256 1893673696 18.775 97 6 12 0 1902008016 6821728 1512592
01:24:22 53053 8192000000 10876420848 11352207360 1937112832 19.124 99 14 28 0 1950337392 9363200 3861360
01:26:00 63907 8192000000 9393599312 9719255040 540187808 6.186 28 8 16 1 547375152 5214736 1972608

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 06-11-2020 01:28:57 to 06-11-2020 01:29:27.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 144 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 06-11-2020 01:29:28 to 06-11-2020 01:29:30.

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          237120
MON$OLDEST_ACTIVE               237415
MON$OLDEST_SNAPSHOT             237415
MON$NEXT_TRANSACTION            237415
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                       2016640
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33387 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33387 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33387 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33387 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 ---
:89: 
:90: mscs-test-161.budzdorov.ru    Fri Nov  6 01:27:08 2020
:91:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:92: 
:93: 
:94: mscs-test-161.budzdorov.ru    Fri Nov  6 01:27:09 2020
:95:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:96: 
--- end of diff output ---

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

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