Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.03.2021 22: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 df9f488d08424df294c459d6c283e9c3
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-03-04 16:07
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.26
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 17555060 kB
MemAvailable 31524932 kB
Buffers 0 kB
Cached 14093876 kB
SwapCached 0 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-03-18 22:28:04
DTS_END                         2021-03-18 22:27:23.3260
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54294
TRN_ID                          234079
ATT_ID                          274
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: 9079.91 25323 1089589
customer order: creation 166.85 350 20022
customer order: refuse 14.18 398 1701
order to supplier: creation 44.52 1346 5342
order to supplier: removal 3.33 104653 400
invoice (draft): creation 44.26 3771 5311
invoice (draft): removal 51.77 809 6212
invoice accept: apply 40.58 19984 4869
invoice accept: cancel 46.65 842 5598
customer reserve: creation 3812.73 193 457527
customer reserve: removal 4562.70 59 547524
realization accept: apply 81.40 187 9768
realization accept: cancel 85.51 111 10261
payment from customer: creation 58.70 128 7044
payment from customer: removal 5.37 100 644
payment to supplier: creation 46.16 143 5539
payment to supplier: removal 3.39 86 407
service: total inventory turnovers 4.82 1019 578
service: total monetary turnovers 6.23 26 747
service: aggregate perf. data 0.76 23657 91
service: refresh index statistics 0.03 348594 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-03-2021 22:28:50 to 18-03-2021 22:28:52.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4859
TEST_TIME 2 4443
TEST_TIME 3 4544
TEST_TIME 4 4545
TEST_TIME 5 5103
TEST_TIME 6 5757
TEST_TIME 7 5420
TEST_TIME 8 5340
TEST_TIME 9 5671
TEST_TIME 10 5858
TEST_TIME 11 6368
TEST_TIME 12 6663
TEST_TIME 13 7050
TEST_TIME 14 7108
TEST_TIME 15 7048
TEST_TIME 16 7294
TEST_TIME 17 7379
TEST_TIME 18 7387
TEST_TIME 19 7510
TEST_TIME 20 7588
TEST_TIME 21 7977
TEST_TIME 22 7965
TEST_TIME 23 8985
TEST_TIME 24 9197
TEST_TIME 25 9128
TEST_TIME 26 9417
TEST_TIME 27 9962
TEST_TIME 28 10909
TEST_TIME 29 10673
TEST_TIME 30 10559
TEST_TIME 31 10443
TEST_TIME 32 10411
TEST_TIME 33 10387
TEST_TIME 34 10284
TEST_TIME 35 10149
TEST_TIME 36 10014
TEST_TIME 37 9845
TEST_TIME 38 9881
TEST_TIME 39 9746
TEST_TIME 40 9640
TEST_TIME 41 9620
TEST_TIME 42 9544
TEST_TIME 43 9494
TEST_TIME 44 9496
TEST_TIME 45 9323
TEST_TIME 46 9237
TEST_TIME 47 9220
TEST_TIME 48 9262
TEST_TIME 49 9313
TEST_TIME 50 9342
TEST_TIME 51 9270
TEST_TIME 52 9310
TEST_TIME 53 9422
TEST_TIME 54 9394
TEST_TIME 55 9375
TEST_TIME 56 9339
TEST_TIME 57 9567
TEST_TIME 58 9557
TEST_TIME 59 9645
TEST_TIME 60 9623
TEST_TIME 61 9551
TEST_TIME 62 9436
TEST_TIME 63 9451
TEST_TIME 64 9418
TEST_TIME 65 9431
TEST_TIME 66 9354
TEST_TIME 67 9387
TEST_TIME 68 9376
TEST_TIME 69 9407
TEST_TIME 70 9419
TEST_TIME 71 9361
TEST_TIME 72 9391
TEST_TIME 73 9366
TEST_TIME 74 9354
TEST_TIME 75 9411
TEST_TIME 76 9460
TEST_TIME 77 9451
TEST_TIME 78 9497
TEST_TIME 79 9419
TEST_TIME 80 9548
TEST_TIME 81 9499
TEST_TIME 82 9391
TEST_TIME 83 9399
TEST_TIME 84 9325
TEST_TIME 85 9329
TEST_TIME 86 9347
TEST_TIME 87 9304
TEST_TIME 88 9260
TEST_TIME 89 9190
TEST_TIME 90 9173
TEST_TIME 91 9230
TEST_TIME 92 9190
TEST_TIME 93 9277
TEST_TIME 94 9314
TEST_TIME 95 9272
TEST_TIME 96 9271
TEST_TIME 97 9365
TEST_TIME 98 9369
TEST_TIME 99 9393
TEST_TIME 100 9381
TEST_TIME 101 9390
TEST_TIME 102 9388
TEST_TIME 103 9380
TEST_TIME 104 9376
TEST_TIME 105 9453
TEST_TIME 106 9370
TEST_TIME 107 9291
TEST_TIME 108 9286
TEST_TIME 109 9256
TEST_TIME 110 9242
TEST_TIME 111 9183
TEST_TIME 112 9141
TEST_TIME 113 9152
TEST_TIME 114 9086
TEST_TIME 115 9076
TEST_TIME 116 9099
TEST_TIME 117 9118
TEST_TIME 118 9094
TEST_TIME 119 9114
TEST_TIME 120 9083

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 18-03-2021 22:28:53 to 18-03-2021 22:28:57.

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 1511805 1511805 0 0.00 0 18302 7 0 0
doc_list_biud 1511803 1511803 0 0.00 0 59909 28 0 0
sp_add_invoice_to_stock 4994 4869 125 2.50 37 207547 19984 0 125
sp_cancel_adding_invoice 5598 5598 0 0.00 6 67515 842 0 0
sp_cancel_client_order 1701 1701 0 0.00 4 20069 399 0 0
sp_cancel_customer_reserve 547524 547524 0 0.00 1 59911 60 0 0
sp_cancel_pay_from_customer 644 644 0 0.00 2 6771 101 0 0
sp_cancel_pay_to_supplier 407 407 0 0.00 3 5178 86 0 0
sp_cancel_supplier_invoice 6217 6212 5 0.08 2 17092 810 0 5
sp_cancel_supplier_order 400 400 0 0.00 6 994328 104654 0 0
sp_cancel_write_off 10261 10261 0 0.00 1 8809 111 0 0
sp_client_order 20022 20022 0 0.00 3 45594 350 0 0
sp_customer_reserve 457527 457527 0 0.00 0 71681 193 0 0
sp_fill_shopping_cart 30647 30647 0 0.00 1 11733 40 0 0
sp_fill_shopping_cart_clo_res 457514 457514 0 0.00 0 17786 13 0 0
sp_get_clo_for_invoice 4856 4856 0 0.00 0 29352 337 0 0
sp_kill_cost_storno 16910 16910 0 0.00 0 15373 55 0 0
sp_kill_qstorno_ret_qs2qd 1111921 1111921 0 0.00 0 59906 32 0 0
sp_kill_qty_storno 586320 586320 0 0.00 0 59909 70 0 0
sp_lock_selected_doc 20138 20138 0 0.00 0 8166 6 0 0
sp_make_cost_storno 27207 27207 0 0.00 0 18300 57 0 0
sp_multiply_rows_for_pdistr 27207 27207 0 0.00 0 8286 29 0 0
sp_multiply_rows_for_qdistr 20022 20022 0 0.00 0 45577 150 0 0
sp_pay_from_customer 7044 7044 0 0.00 4 11511 129 0 0
sp_pay_to_supplier 5539 5539 0 0.00 5 18305 144 0 0
sp_payment_common 12583 12583 0 0.00 1 12705 39 0 0
sp_qd_handle_on_cancel_clo 1701 1701 0 0.00 0 20061 372 0 0
sp_qd_handle_on_invoice_upd_sts 10454 10454 0 0.00 0 19564 345 0 0
sp_qd_handle_on_reserve_upd_sts 9768 9768 0 0.00 0 18057 64 0 0
sp_reserve_write_off 9768 9768 0 0.00 7 19440 187 0 0
sp_supplier_invoice 5311 5311 0 0.00 6 78282 3771 0 0
sp_supplier_order 5342 5342 0 0.00 5 59949 1347 0 0
srv_aggregate_perf_data 91 91 0 0.00 2807 249820 23658 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 1194 137792 32962 0 0
srv_find_qd_qs_mism 1042262 1042262 0 0.00 0 14930 6 0 0
srv_make_invnt_saldo 578 578 0 0.00 30 56795 1019 0 0
srv_make_money_saldo 747 747 0 0.00 1 1375 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 199172 521245 348594 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4869 4869 0 0.00 0 18096 182 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 0 7837 116 0 0
t$perf-norm:sp_cancel_client_order 1701 1701 0 0.00 0 910 10 0 0
t$perf-norm:sp_cancel_customer_reserve 635 635 0 0.00 0 488 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 644 644 0 0.00 0 5352 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 407 407 0 0.00 0 1076 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 1348 13 0 0
t$perf-norm:sp_cancel_supplier_order 400 400 0 0.00 0 21081 1482 0 0
t$perf-norm:sp_cancel_write_off 933 933 0 0.00 0 2633 13 0 0
t$perf-norm:sp_client_order 20022 20022 0 0.00 0 17307 21 0 0
t$perf-norm:sp_customer_reserve 1045 1045 0 0.00 0 5221 14 0 0
t$perf-norm:sp_pay_from_customer 7044 7044 0 0.00 0 11501 13 0 0
t$perf-norm:sp_pay_to_supplier 5539 5539 0 0.00 0 10437 15 0 0
t$perf-norm:sp_reserve_write_off 9768 9768 0 0.00 0 11512 11 0 0
t$perf-norm:sp_supplier_invoice 5311 5311 0 0.00 0 17652 33 0 0
t$perf-norm:sp_supplier_order 5342 5342 0 0.00 0 6917 18 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 311 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 1121 11 0 0
t$perf-norm:srv_make_invnt_saldo 578 578 0 0.00 0 2653 23 0 0
t$perf-norm:srv_make_money_saldo 747 747 0 0.00 0 943 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 14 5 0 0
v_add_invoice_to_stock 9962 9712 250 2.50 0 3972 19 0 250
v_all_customers 36926 36926 0 0.00 0 97 1 0 0
v_all_suppliers 29308 29308 0 0.00 0 22 1 0 0
v_all_wares 40044 40044 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 1250 11 0 0
v_cancel_client_order 3402 3402 0 0.00 0 4005 6 0 0
v_cancel_customer_prepayment 1288 1288 0 0.00 0 2374 7 0 0
v_cancel_customer_reserve 1270 1270 0 0.00 0 3765 11 0 0
v_cancel_payment_to_supplier 814 814 0 0.00 0 3274 9 0 0
v_cancel_supplier_invoice 782 772 10 1.27 0 585 12 0 10
v_cancel_supplier_order 800 800 0 0.00 0 2639 10 0 0
v_cancel_write_off 1866 1866 0 0.00 0 3426 15 0 0
v_max_id_clo_ord 5342 5342 0 0.00 0 474 1 0 0
v_max_id_clo_res 1045 1045 0 0.00 0 1571 8 0 0
v_max_id_ord_sup 5283 5283 0 0.00 0 3844 6 0 0
v_max_non_paid_invoice 1510 1510 0 0.00 0 4705 12 0 0
v_max_non_paid_realizn 3634 3634 0 0.00 0 4209 5 0 0
v_min_id_clo_ord 5342 5342 0 0.00 0 3680 12 0 0
v_min_id_clo_res 1045 1045 0 0.00 0 1944 9 0 0
v_min_id_ord_sup 5283 5283 0 0.00 0 6538 8 0 0
v_min_non_paid_invoice 5539 5539 0 0.00 0 9098 26 0 0
v_min_non_paid_realizn 7044 7044 0 0.00 0 9400 21 0 0
v_our_firm 9938 9938 0 0.00 0 23 1 0 0
v_reserve_write_off 19536 19536 0 0.00 0 4629 7 0 0
x_lock_depdocs_on_canc_invoice 11424 11424 0 0.00 0 25376 137 0 0
x_lock_depdocs_on_canc_sup_ord 400 400 0 0.00 0 14971 418 0 0
x_make_qstorno_1000_1200 5342 5342 0 0.00 2 59898 1259 0 0
x_make_qstorno_1200_2000 5311 5311 0 0.00 3 72665 3612 0 0
x_make_qstorno_2100_3300 457527 457527 0 0.00 0 71678 177 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:27 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:33 15977 8192000000 10233795824 10541834240 789784528 8.793 61 46 92 0 807358624 2250384 15323712
19:57:56 30901 8192000000 10350217280 10666475520 1385470928 14.465 100 80 161 0 1416330592 5094736 25764928
19:58:36 18346 8192000000 10384143584 10704470016 1440782480 14.957 100 94 188 1 1477884480 6527664 30574336
19:59:14 25825 8192000000 10414588608 10743410688 1470498624 15.218 100 89 178 0 1506538864 7477936 28562304
19:59:54 13205 8192000000 10441430336 10771415040 1497408464 15.454 100 90 180 0 1534609648 8168864 29032320
20:00:21 17577 8192000000 10444369760 10780364800 1498411312 15.462 100 87 174 1 1535324352 9038384 27874656
20:00:54 6042 8192000000 10464323472 10797391872 1520144400 15.651 100 92 184 0 1558498720 9546144 28808176
20:01:14 21201 8192000000 10480983680 10820231168 1536029776 15.789 100 84 168 0 1573210272 9896368 27284128
20:01:43 18823 8192000000 10513235984 10857918464 1562446848 16.017 100 81 162 0 1597460240 10151808 24861584
20:02:09 18322 8192000000 10531781184 10880139264 1587596752 16.233 100 74 148 2 1620711664 10581456 22533456
20:02:35 10864 8192000000 10557542688 10911928320 1607240592 16.401 100 83 166 1 1647848400 15547776 25060032
20:02:58 13583 8192000000 10582626048 10938953728 1638749872 16.669 100 84 168 1 1675538640 12102336 24686432
20:03:20 13505 8192000000 10609194160 10966941696 1651853904 16.780 100 88 176 1 1690912032 12818864 26239264
20:03:41 11073 8192000000 10616594560 10978156544 1667437680 16.912 100 83 166 2 1705141824 13489600 24214544
20:04:02 9013 8192000000 10628393232 10993790976 1681064896 17.026 100 81 162 3 1718416592 13469408 23882288
20:04:18 8550 8192000000 10643768752 11007700992 1699755536 17.183 100 76 152 3 1734983712 12948080 22280096
20:04:35 8018 8192000000 10651686736 11022639104 1709333152 17.263 100 88 175 1 1747574336 13228944 25012240
20:04:52 7251 8192000000 10657195232 11034185728 1723797120 17.384 100 75 147 3 1757836544 12802016 21237408
20:05:11 6736 8192000000 10689245456 11066863616 1744983424 17.560 100 73 143 2 1777417536 12014384 20419728
20:05:25 4378 8192000000 10695228224 11075981312 1763095184 17.710 100 83 165 0 1798197344 11838176 23263984
20:05:36 5413 8192000000 10703349408 11085758464 1775715552 17.814 100 76 153 0 1808574624 11044240 21814832
20:05:50 3666 8192000000 10723894672 11105214464 1782130112 17.867 100 88 177 0 1822989328 15837792 25021424
20:06:03 3145 8192000000 10721823488 11101171712 1784763200 17.889 100 81 159 1 1819016048 11581952 22670896
20:06:12 3531 8192000000 10736601216 11115061248 1788896512 17.923 100 83 164 0 1824728048 12186048 23645488
20:06:22 9782 8192000000 10726856912 11115528192 1792321376 17.951 100 76 152 0 1826979584 13107984 21550224
20:06:39 4588 8192000000 10743292832 11123109888 1804524992 18.051 100 80 160 1 1840159328 13677680 21956656
20:06:51 3438 8192000000 10758945120 11142492160 1819145632 18.171 100 86 170 0 1857533984 14368128 24020224
20:07:00 1472 8192000000 10766274736 11150934016 1828681440 18.249 100 83 166 1 1865738272 13436304 23620528
20:07:08 2799 8192000000 10771419232 11156209664 1832573376 18.280 100 93 184 1 1871700224 13819856 25306992
20:07:17 2003 8192000000 10775483520 11158364160 1837360576 18.319 100 89 179 1 1876076560 13555008 25160976
20:07:26 2227 8192000000 10780693632 11164581888 1839154464 18.334 100 91 182 0 1877496624 12694768 25647392
20:07:35 2083 8192000000 10793450496 11180806144 1846680176 18.395 100 92 184 1 1883294272 11247856 25366240
20:07:43 1949 8192000000 10798482384 11182280704 1850857344 18.429 100 95 191 1 1891596080 13897952 26840784
20:07:51 2199 8192000000 10798448560 11188711424 1855172496 18.464 100 93 186 0 1894948032 14131504 25644032
20:08:00 2371 8192000000 10805472784 11190022144 1857389968 18.482 100 91 181 1 1897235952 14491792 25354192
20:08:09 1548 8192000000 10805886432 11189481472 1855818544 18.469 100 93 186 0 1896094176 12832256 27443376
20:08:17 8194 8192000000 10786991936 11181408256 1858466016 18.491 100 72 141 0 1889875312 11318560 20090736
20:08:32 2442 8192000000 10792578736 11194105856 1867879072 18.567 100 76 152 0 1901909440 12105408 21924960
20:08:42 5321 8192000000 10811560080 11199606784 1863577440 18.532 100 83 166 1 1897985904 11167920 23240544
20:08:54 14341 8192000000 10792031328 11195842560 1862065040 18.520 100 55 108 1 1888481152 11259712 15156400
20:09:15 2659 8192000000 10770485120 11190657024 1866369184 18.555 100 42 84 1 1886358464 7932400 12056880
20:09:27 7461 8192000000 10774854928 11196006400 1869703536 18.582 100 37 77 0 1891114656 11190864 10220256
20:09:41 10856 8192000000 10773929568 11199057920 1866727440 18.558 100 25 50 0 1880401872 6871472 6802960
20:09:59 7042 8192000000 10771166176 11198754816 1869341136 18.579 100 15 29 1 1879148848 5766128 4041584
20:10:13 11073 8192000000 10781459248 11202502656 1873096704 18.609 100 20 40 1 1884739104 5956112 5686288
20:10:30 9114 8192000000 10786181616 11210108928 1874257072 18.619 100 13 24 1 1882924544 5310768 3356704
20:10:47 13307 8192000000 10776362096 11210108928 1876468368 18.637 100 23 46 2 1889766720 6404464 6893888
20:11:08 11101 8192000000 10789128640 11217645568 1878928656 18.656 100 22 44 1 1891568880 6487744 6152480
20:11:25 10491 8192000000 10791748240 11219320832 1882278800 18.684 100 16 32 2 1892865232 5935408 4651024
20:11:42 8457 8192000000 10793427568 11225530368 1887668416 18.727 100 30 60 0 1903919968 8159424 8092128
20:11:58 11815 8192000000 10791748512 11223228416 1888586240 18.734 100 33 64 2 1905156320 6462448 10107632
20:12:19 18848 8192000000 10799146480 11238227968 1892836096 18.769 100 34 68 1 1909534016 6973408 9724512
20:13:03 23508 8192000000 10851175696 11248668672 1901700016 18.840 100 65 131 1 1926927760 5622912 19604832
20:13:33 8272 8192000000 10809424544 11246505984 1897915232 18.810 100 25 50 1 1912356624 7800768 6640624
20:13:50 9134 8192000000 10824811584 11255345152 1903133488 18.851 100 30 60 1 1917870080 7157072 7579520
20:14:05 3918 8192000000 10841032832 11260624896 1908887776 18.898 100 43 86 1 1929409456 8398688 12122992
20:14:17 6203 8192000000 10836884368 11265445888 1914490496 18.943 100 34 68 0 1931869088 8146064 9232528
20:14:31 4212 8192000000 10835669584 11266990080 1915899984 18.954 100 32 64 3 1931348416 6670544 8777888
20:14:43 7940 8192000000 10844035904 11269328896 1918721920 18.977 100 28 56 1 1933403088 6872096 7809072
20:14:58 5511 8192000000 10843782352 11271344128 1917738880 18.969 100 26 53 0 1931706976 6257824 7710272
20:15:11 5638 8192000000 10846811424 11271356416 1918371072 18.974 100 22 43 3 1930776944 6121328 6284544
20:15:22 6341 8192000000 10828496256 11269218304 1919703104 18.984 100 23 46 0 1932152544 6164896 6284544
20:15:38 8038 8192000000 10838488752 11272347648 1920567232 18.991 100 28 56 1 1934095120 6040000 7487888
20:15:52 6750 8192000000 10808796832 11248648192 1901308272 18.837 99 29 58 3 1916183296 6883104 7991920
20:16:07 7832 8192000000 10823822128 11251560448 1896060320 18.795 99 26 52 0 1909193008 5630384 7502304
20:16:22 13198 8192000000 10808526304 11245436928 1872530240 18.605 98 15 30 1 1881730656 5344560 3855856
20:16:46 58775 8192000000 10800393216 11226525696 1851087552 18.431 97 28 56 1 1864482800 4853104 8542144
20:17:52 9096 8192000000 10807811072 11249299456 1900297984 18.829 100 23 46 1 1913126256 6063536 6764736
20:18:07 10420 8192000000 10800068208 11237228544 1829012880 18.251 96 12 24 1 1837583552 5269264 3301408
20:18:24 7514 8192000000 10805303392 11234217984 1856407616 18.474 98 30 59 0 1871063568 6803328 7852624
20:18:39 5300 8192000000 10775226432 11197407232 1828514384 18.247 98 30 60 1 1843512384 6154784 8843216
20:18:54 3981 8192000000 10754995360 11171205120 1804347296 18.050 98 28 56 3 1818237760 6521136 7369328
20:19:04 5293 8192000000 10725227536 11148783616 1783281648 17.877 97 20 40 1 1795426192 6546704 5597840
20:19:18 6570 8192000000 10724851504 11150393344 1778883952 17.840 97 14 28 1 1787988992 4817904 4287136
20:19:31 10521 8192000000 10734244304 11149750272 1759235632 17.678 96 26 53 3 1772586192 5437120 7913440
20:19:50 6222 8192000000 10720795904 11147759616 1784545264 17.887 98 19 38 1 1795806608 5955760 5305584
20:20:02 10076 8192000000 10699329776 11123843072 1723655472 17.383 95 15 30 2 1732772192 5108528 4008192
20:20:21 10033 8192000000 10713159088 11136606208 1770730672 17.773 98 21 40 1 1783036384 6158592 6147120
20:20:41 7124 8192000000 10707947136 11131523072 1745833440 17.567 96 28 56 0 1760063472 5464480 8765552
20:20:55 14195 8192000000 10700260960 11124494336 1714098976 17.303 95 18 36 1 1724839920 5214528 5526416
20:21:15 10220 8192000000 10706495568 11118710784 1726755504 17.408 96 15 29 3 1736564736 4800080 5009152
20:21:31 70462 8192000000 10703927520 11117588480 1731495424 17.448 96 25 50 0 1744285632 5158192 7632016
20:22:50 10954 8192000000 10733836720 11153362944 1797821040 17.996 99 26 52 1 1811538064 6461056 7255968
20:23:07 5202 8192000000 10735262688 11150475264 1815658192 18.142 100 34 69 0 1832357216 6469440 10229584
20:23:19 8486 8192000000 10729240512 11147665408 1789147856 17.925 98 20 40 1 1800530960 5505776 5877328
20:23:36 7968 8192000000 10754327968 11171508224 1831126576 18.269 100 31 60 4 1845529232 5803792 8598864
20:23:55 8490 8192000000 10747873200 11179761664 1841576240 18.354 100 28 56 0 1856342224 6960272 7805712
20:24:09 13610 8192000000 10753153232 11182743552 1826661376 18.232 99 21 42 1 1838645728 6095472 5888880
20:24:30 8037 8192000000 10764215600 11189035008 1846996224 18.398 100 19 38 1 1857980400 5490896 5493280
20:24:44 10382 8192000000 10761596928 11192668160 1853588544 18.451 100 24 47 1 1866801536 5830032 7382960
20:25:00 13600 8192000000 10767633088 11196231680 1857310352 18.481 100 19 36 1 1868167776 5943104 4914320
20:25:25 11116 8192000000 10775684624 11204149248 1861817744 18.518 100 28 56 1 1875327024 5815584 7693696
20:25:42 9310 8192000000 10794622752 11217178624 1869338624 18.579 100 25 51 0 1885892656 9815488 6738544
20:26:04 16630 8192000000 10790030224 11214487552 1870149232 18.585 100 11 22 1 1878467776 5367776 2950768
20:26:29 84082 8192000000 10818964928 11245400064 1882680192 18.687 100 41 80 3 1900140288 5351952 12108144
20:28:04 16554 8192000000 10843230128 11261976576 1913563120 18.935 100 44 88 0 1932139648 6453440 12123088
20:28:35 16099 8192000000 10865215936 11281969152 1930068912 19.067 100 63 126 2 1960543248 12244416 18229920
20:29:06 20530 8192000000 10867534512 11291709440 1933950832 19.098 100 55 111 1 1961437216 12100256 15386128
20:29:45 5483 8192000000 10879006192 11300270080 1943125936 19.172 100 59 116 1 1972230912 11592896 17512080
20:30:07 11651 8192000000 10879604000 11305914368 1946901696 19.202 100 48 95 2 1972663808 11996192 13765920
20:30:27 38086 8192000000 10885942688 11313152000 1953375168 19.253 100 50 97 5 1980377744 12427856 14574720
20:31:13 26913 8192000000 10888070880 11318468608 1953341120 19.253 100 42 84 0 1978173744 13105680 11726944
20:31:48 18527 8192000000 10887219552 11322814464 1957407424 19.285 100 45 90 0 1984375072 14196192 12771456
20:32:21 21943 8192000000 10902809568 11327721472 1960122272 19.307 100 31 62 2 1981651488 12605696 8923520
20:32:50 11021 8192000000 10905456672 11334995968 1970771104 19.392 100 52 102 1 2000882224 14867280 15243840
20:33:08 12028 8192000000 10916220544 11341307904 1971430144 19.397 100 55 111 1 2001902192 14457424 16014624
20:33:29 5101 8192000000 10922119952 11347496960 1978015696 19.449 100 64 128 0 2014130240 16990288 19124256
20:33:41 12368 8192000000 10917452432 11347918848 1977109184 19.442 100 53 106 2 2008787792 16493056 15185552
20:34:03 19781 8192000000 10921819584 11355406336 1980734224 19.471 100 55 109 0 2013258000 16687776 15836000
20:34:30 8088 8192000000 10933903104 11362033664 1986605040 19.517 100 59 115 0 2019993104 16718160 16669904
20:34:58 11213 8192000000 10930222576 11367583744 1989634304 19.541 100 46 92 0 2024545456 21438240 13472912
20:35:17 8008 8192000000 10940673280 11373416448 2000538032 19.627 100 59 116 0 2035546960 18418576 16590352
20:35:33 4792 8192000000 10934690384 11365261312 1975419744 19.428 99 57 112 3 2010532960 18377504 16735712
20:35:47 5588 8192000000 10945461936 11371913216 1991734576 19.557 100 65 130 1 2031891856 20844800 19312480
20:36:06 15392 8192000000 10940112608 11374780416 1994698560 19.581 100 65 130 0 2035588304 22058528 18831216
20:36:30 12672 8192000000 10945300688 11384016896 1997217552 19.601 100 55 109 1 2036647616 23383664 16046400
20:36:54 8098 8192000000 10953995360 11389202432 2001283424 19.633 100 56 110 0 2042895072 24293024 17318624
20:37:10 7410 8192000000 10961424832 11396468736 2005139584 19.663 100 61 122 1 2049919616 27082000 17698032
20:37:25 23543 8192000000 10952915040 11392364544 1985714800 19.510 99 63 124 1 2034321072 30483760 18122512
20:37:55 9065 8192000000 10955413216 11392950272 1995535328 19.588 100 51 101 0 2043043968 31113056 16395584
20:38:12 8238 8192000000 10952487408 11392258048 2002436944 19.642 100 61 122 1 2050565328 29294400 18833984
20:38:32 4470 8192000000 10969172896 11397951488 1985097872 19.505 99 51 103 1 2028120928 27487792 15535264
20:38:45 6252 8192000000 10966524800 11393896448 2001153072 19.632 100 67 132 2 2050973840 29166608 20654160
20:39:00 3613 8192000000 10971319728 11397349376 1988723968 19.534 99 72 142 1 2041246032 31705792 20816272
20:39:11 9879 8192000000 10986990048 11409989632 2008110912 19.687 100 75 150 1 2064769776 33921392 22737472
20:39:27 3746 8192000000 10991637088 11415302144 2014314592 19.735 100 78 157 0 2074025504 35462688 24248224
20:39:40 3878 8192000000 10980026880 11404902400 2000884448 19.630 99 77 152 0 2058228160 34378976 22964736
20:39:52 8241 8192000000 10992451232 11415240704 2015217936 19.743 100 67 132 1 2069571200 33244544 21108720
20:40:07 1270 8192000000 10997943216 11414929408 2015109760 19.742 100 91 183 2 2076398912 34621264 26667888
20:40:16 10483 8192000000 10972235104 11404320768 1993201008 19.569 99 62 124 0 2040910480 28923328 18786144
20:40:36 3696 8192000000 10975888400 11404488704 2008472000 19.689 100 75 148 0 2061002512 29800512 22730000
20:40:47 3962 8192000000 10977613664 11395223552 1992251040 19.562 99 83 165 0 2048425728 31153104 25021584
20:40:58 5953 8192000000 10977039552 11397844992 1989337744 19.539 99 87 173 2 2046646016 31618000 25690272
20:41:11 7554 8192000000 10955922400 11387105280 1990193424 19.545 100 69 136 2 2042747328 31810128 20743776
20:41:28 4619 8192000000 10953226256 11380817920 1981043072 19.473 100 71 142 2 2036217792 34018864 21155856
20:41:43 5976 8192000000 10965336544 11397496832 1998770864 19.613 100 71 142 0 2052806176 32493792 21541520
20:41:58 9155 8192000000 10981493264 11413504000 2008196304 19.687 100 64 128 0 2065517584 37545328 19775952
20:42:15 2306 8192000000 10977816768 11409235968 2005880704 19.669 100 66 130 3 2062216352 36450080 19885568
20:42:27 5561 8192000000 10977540256 11402948608 1971581344 19.398 98 76 153 0 2034244656 38486496 24176816
20:42:46 7202 8192000000 10977379280 11405651968 1984167872 19.498 99 79 158 0 2050144224 40634080 25342272
20:43:04 3029 8192000000 10966869312 11386118144 1974847200 19.424 99 73 145 1 2037680480 40637344 22195936
20:43:15 2973 8192000000 10972819680 11403354112 2000634464 19.628 100 76 150 1 2065447808 41483968 23329376
20:43:29 2937 8192000000 11003100320 11423002624 2016129424 19.750 100 83 167 1 2081103664 39986368 24987872
20:43:38 2477 8192000000 11001014272 11423424512 2014744816 19.739 100 87 174 2 2083208432 41044624 27418992
20:43:49 2870 8192000000 10987315664 11403010048 1996225776 19.593 100 79 157 1 2061001792 41236240 23539776
20:43:59 1656 8192000000 10993312368 11405418496 2001923056 19.638 100 91 178 1 2070656416 41728224 27005136
20:44:07 2566 8192000000 10972206752 11382927360 1978912128 19.456 99 87 174 1 2048220928 43409120 25899680
20:44:18 1952 8192000000 10983128512 11395923968 1993454352 19.571 100 88 175 0 2063535040 43514976 26565712
20:44:27 1485 8192000000 10977865552 11391598592 1985088528 19.505 100 90 179 0 2056794832 44138688 27567616
20:44:36 4840 8192000000 10974724320 11390128128 1984659328 19.502 100 87 173 0 2056011856 45138112 26214416
20:44:48 5456 8192000000 10974216576 11390418944 1984297392 19.499 100 81 162 1 2054274944 44838592 25138960
20:45:03 3995 8192000000 10973985712 11391168512 1983559520 19.493 100 74 148 0 2052549136 45787600 23202016
20:45:14 7769 8192000000 10979374944 11392266240 1984890320 19.503 100 80 159 2 2055347136 46354768 24102048
20:45:30 1949 8192000000 10976680848 11397992448 1985983248 19.512 100 77 153 0 2057238416 47115680 24139488
20:45:43 2703 8192000000 10995952672 11405475840 1992345776 19.562 100 86 168 1 2068669952 50584736 25739440
20:45:54 2799 8192000000 10978370528 11397009408 1967317024 19.364 99 80 160 0 2043241136 50942768 24981344
20:46:05 2767 8192000000 10980873280 11396923392 1987545408 19.524 100 78 155 0 2064570400 51822848 25202144
20:46:17 2511 8192000000 10981350320 11400413184 1978262160 19.451 99 80 160 1 2056026112 52102800 25661152
20:46:26 2546 8192000000 10955858320 11376353280 1965549840 19.350 100 73 146 0 2039390128 50406128 23434160
20:46:36 7214 8192000000 10937826240 11358679040 1942642304 19.168 99 59 118 0 2011983296 50579184 18761808
20:46:51 6586 8192000000 10972321584 11383918592 1972365392 19.404 100 77 151 0 2049242784 51886032 24991360
20:47:06 1192 8192000000 10942353824 11359518720 1947257472 19.205 99 82 163 4 2025096736 52364896 25474368
20:47:14 4148 8192000000 10966749600 11385020416 1968887712 19.377 100 76 152 0 2048832480 54821872 25122896
20:47:27 4977 8192000000 10964539168 11378671616 1962498160 19.326 100 79 156 3 2043194352 55007328 25688864
20:47:39 5661 8192000000 10957077680 11373350912 1957034624 19.282 100 73 144 1 2035689904 55957296 22697984
20:47:53 3509 8192000000 10956605456 11367759872 1944097792 19.179 99 76 150 1 2025147024 57325968 23723264
20:48:05 1575 8192000000 10966848656 11385057280 1966674096 19.359 100 71 141 0 2047105440 58128416 22302928
20:48:13 6169 8192000000 10946140528 11381723136 1960187344 19.308 100 52 103 1 2036599424 59749136 16662944
20:48:29 4400 8192000000 10942428160 11378368512 1956181120 19.276 100 37 74 1 2025476912 57142992 12152800
20:48:43 10171 8192000000 10928008976 11364499456 1935567040 19.111 99 36 72 0 2004105440 55722784 12815616
20:49:05 4982 8192000000 10962014336 11380547584 1964784176 19.344 100 64 128 1 2041735360 54947344 22003840
20:49:17 10911 8192000000 10968419984 11394908160 1970975536 19.393 100 55 110 2 2049073424 59727712 18370176
20:49:37 7933 8192000000 10972502944 11403169792 1972633648 19.406 100 53 106 1 2052372192 61807984 17930560
20:49:57 12898 8192000000 10964586752 11406995456 1973004480 19.409 100 46 92 2 2053223888 63368784 16850624
20:50:23 11021 8192000000 10949509584 11398504448 1970336608 19.388 100 45 88 1 2032536624 48119168 14080848
20:50:43 17555 8192000000 10933090224 11385384960 1955178592 19.268 99 28 54 0 2006342800 41872544 9291664
20:51:38 12708 8192000000 10913671776 11364286464 1948278720 19.213 100 22 44 2 1994508032 38646768 7582544
20:51:58 12579 8192000000 10931074576 11373408256 1955494208 19.270 100 30 59 2 2011477712 45849440 10134064
20:52:50 20611 8192000000 10912326320 11370655744 1914294416 18.941 98 23 46 2 1977368224 54647328 8426480
20:53:32 32875 8192000000 10920050096 11373813760 1940440896 19.150 100 21 42 0 1994912960 46600576 7871488
20:54:11 7365 8192000000 10910518608 11374632960 1947905184 19.210 100 19 38 2 1998927392 44038880 6983328
20:54:25 17887 8192000000 10885161056 11337019392 1903091792 18.851 98 23 46 1 1954787584 43605744 8090048
20:54:56 33316 8192000000 10874802208 11326779392 1916877472 18.962 99 20 39 1 1942257024 19732608 5646944
20:55:36 97569 8192000000 10879109408 11322355712 1929579056 19.064 99 35 68 1 1947224944 7966640 9679248
20:57:20 59819 8192000000 10881655056 11346382848 1934795488 19.105 99 43 85 1 1955833504 9796736 11241280
20:58:57 49874 8192000000 10889054720 11360022528 1961792160 19.320 100 19 38 2 1981945392 14978256 5174976
20:59:53 60753 8192000000 10851127424 11318358016 1879916896 18.664 96 17 34 1 1896514400 12191504 4406000
21:02:09 91730 8192000000 10893410016 11341721600 1916573632 18.959 99 11 23 0 1930212976 10635024 3004320
21:04:04 68586 8192000000 10852068896 11303895040 1897600864 18.807 97 27 53 1 1915891312 10087424 8203024
21:05:26 93032 8192000000 10858866736 11326427136 1922605376 19.008 99 20 40 1 1940268816 10686016 6977424
21:07:19 75217 8192000000 10869600368 11336564736 1934253840 19.101 99 21 42 2 1953058352 12670112 6134400
21:09:54 18344 8192000000 10886537792 11336273920 1950209696 19.228 100 19 38 0 1962879600 7331120 5338784
21:10:20 47408 8192000000 10883645248 11347636224 1963907792 19.337 100 32 64 0 1982053792 9210080 8935920
21:11:24 54848 8192000000 10876581776 11352653824 1962376240 19.325 100 6 12 1 1976525536 12147328 2001968
21:12:26 76866 8192000000 10879624960 11360473088 1969422112 19.381 100 25 50 0 1988124432 11492592 7209728
21:13:50 64003 8192000000 10899318800 11379433472 1961613424 19.319 99 20 40 2 1980973600 13775680 5584496
21:15:10 43418 8192000000 10892224048 11378503680 1971840352 19.400 100 15 29 1 1993545296 16843920 4861024
21:16:50 56526 8192000000 10913129536 11388403712 1987201600 19.522 100 11 22 1 1999503520 8794496 3507424
21:17:55 43939 8192000000 10919029184 11393146880 1970510032 19.389 99 11 22 1 1986841568 12804336 3527200
21:18:45 42268 8192000000 10928479232 11389599744 1992988400 19.567 100 31 62 0 2017156800 15202096 8966304
21:19:37 78332 8192000000 10892636800 11369152512 1929813344 19.065 97 18 36 0 1951760592 16888672 5058576
21:21:03 35586 8192000000 10925395216 11380269056 1987378544 19.523 100 25 51 1 2006883856 11889952 7615360
21:21:45 31569 8192000000 10937225824 11394555904 1978985520 19.457 99 31 62 1 2002409296 14776048 8647728
21:23:24 67059 8192000000 10902517456 11376025600 1944327104 19.181 98 29 58 0 1975279808 22450752 8501952
21:25:26 137792 8192000000 10898521952 11374837760 1913215712 18.932 97 11 22 1 1934710736 18289520 3205504
21:27:50 41128 8192000000 10890680976 11347746816 1910628256 18.912 97 34 69 1 1929631312 9859328 9143728
21:28:54 127561 8192000000 10883623760 11354144768 1905645712 18.872 97 18 36 0 1928470064 17748928 5075424
21:31:12 29249 8192000000 10897473696 11372105728 1947262848 19.205 99 19 38 1 1968802976 16386768 5153360
21:32:01 61503 8192000000 10874865568 11364757504 1924461072 19.023 98 17 34 0 1944416096 15101984 4853040
21:33:18 56632 8192000000 10878094752 11366109184 1942250048 19.165 99 13 26 1 1969350400 23726592 3373760
21:34:21 73858 8192000000 10874284176 11346071552 1847940496 18.405 94 10 21 0 1857833456 7123024 2769936
21:35:41 90757 8192000000 10894790176 11373932544 1962750592 19.328 100 25 50 0 1980823552 10767712 7305248
21:37:44 38679 8192000000 10871125488 11328262144 1873463904 18.612 95 27 53 0 1892965344 12139392 7362048
21:38:34 49691 8192000000 10851359264 11318902784 1872287984 18.603 96 34 68 2 1894243312 12394400 9560928
21:39:30 52460 8192000000 10862672384 11324604416 1902077664 18.843 98 23 46 2 1918307760 10049872 6180224
21:41:16 51267 8192000000 10876916896 11342798848 1895859616 18.793 97 28 56 1 1916948032 13181216 7907200
21:42:22 52818 8192000000 10877185408 11352047616 1927383680 19.046 99 17 34 0 1947537024 15141472 5011872
21:45:10 102699 8192000000 10883446112 11338051584 1908271968 18.893 98 18 36 1 1924516224 10754768 5489488
21:47:29 90324 8192000000 10861095536 11339681792 1871522416 18.597 96 15 30 2 1888112064 12245216 4344432
21:49:06 110910 8192000000 10876447296 11337863168 1910634656 18.912 98 19 38 1 1924455536 8238224 5582656
21:51:03 54188 8192000000 10894632928 11356131328 1939621888 19.144 99 29 58 1 1957588704 10152992 7813824
21:52:04 84954 8192000000 10873851232 11359465472 1907174896 18.884 97 16 32 0 1925529936 13560512 4794528
21:53:37 54723 8192000000 10870370144 11358556160 1935756288 19.113 99 9 18 1 1951018800 12357824 2904688
21:54:44 20053 8192000000 10870235104 11345240064 1924587392 19.024 99 2 4 0 1935087600 10125952 374256
21:55:14 83654 8192000000 10869671120 11340455936 1880808336 18.672 96 17 35 0 1900141088 14642816 4689936
21:56:57 87244 8192000000 10857163824 11332452352 1904593152 18.863 98 12 24 2 1922022944 13756656 3673136
21:58:33 81947 8192000000 10875245328 11339366400 1892992624 18.770 97 14 28 1 1909344992 12208416 4143952
22:00:01 79240 8192000000 10868252896 11335188480 1928468960 19.055 99 16 32 0 1955415600 21873056 5073584
22:01:29 70607 8192000000 10858009696 11317858304 1803001712 18.039 92 17 34 0 1817576608 9969696 4605200
22:02:46 51621 8192000000 10881797648 11344896000 1941093632 19.155 100 29 56 1 1964661776 15026656 8541488
22:03:50 49721 8192000000 10875029776 11351453696 1948954800 19.218 100 10 20 0 1967801200 15943296 2903104
22:04:45 52096 8192000000 10915700976 11372736512 1970775696 19.392 100 48 96 2 1994428112 10811920 12840496
22:05:46 37794 8192000000 10892250592 11374235648 1970667408 19.391 100 21 42 3 1988933888 12347184 5919296
22:06:41 37324 8192000000 10901266848 11363758080 1969280528 19.380 100 11 22 0 1981115088 9181104 2653456
22:07:38 57920 8192000000 10903341920 11374198784 1953437120 19.254 99 30 61 0 1971754352 10218432 8098800
22:08:42 34941 8192000000 10923378336 11372863488 1970004976 19.385 100 24 48 1 1986967456 10230800 6731680
22:09:24 90004 8192000000 10909476640 11374096384 1930567776 19.071 97 34 68 2 1952944608 13006288 9370544
22:11:03 41041 8192000000 10916585520 11372617728 1957228656 19.284 99 31 62 1 1977982096 12256992 8496448
22:11:53 81470 8192000000 10885444944 11368402944 1894539408 18.782 96 13 26 0 1911057136 12705920 3811808
22:13:24 103510 8192000000 10872816128 11335888896 1879224640 18.659 96 20 40 0 1895227136 10392336 5610160
22:15:17 57596 8192000000 10867295552 11340734464 1956315792 19.277 100 15 30 0 1967542944 7033312 4193840
22:16:45 82865 8192000000 10883458448 11374764032 1965790000 19.352 100 7 14 0 1979038224 11099792 2148432
22:18:49 59808 8192000000 10902884336 11375554560 1974037296 19.417 100 15 30 1 1993176896 14999904 4139696
22:19:57 82880 8192000000 10899176032 11378606080 1959705504 19.304 99 13 26 0 1978095824 14378192 4012128
22:21:26 61564 8192000000 10886900752 11358572544 1921951952 19.002 97 32 64 0 1950764944 19201968 9611024
22:22:47 35581 8192000000 10874848880 11357196288 1924539792 19.023 98 21 42 0 1945302176 14509168 6253216
22:23:52 77957 8192000000 10866751232 11342819328 1893878160 18.777 97 13 25 1 1906008688 9035408 3095120
22:25:17 18189 8192000000 10876468416 11333394432 1901463088 18.838 98 23 46 0 1916775840 8877152 6435600
22:25:50 86839 8192000000 10896201808 11378950144 1956062896 19.275 100 20 40 2 1979543440 17813504 5667040

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 18-03-2021 22:29:04 to 18-03-2021 22:29:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 125 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-03-2021 22:29:35 to 18-03-2021 22:29:37.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          248477
MON$OLDEST_ACTIVE               248478
MON$OLDEST_SNAPSHOT             248478
MON$NEXT_TRANSACTION            248478
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                       2015232
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.33427 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33427 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33427 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33427 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

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