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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17399728 kB
MemAvailable 31360060 kB
Buffers 0 kB
Cached 14272080 kB
SwapCached 4864 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-01-08 19:27:10
DTS_END                         2021-01-08 19:27:10.6000
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47572
TRN_ID                          243038
ATT_ID                          667
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: 9291.98 20164 1115038
customer order: creation 173.28 368 20794
customer order: refuse 14.46 376 1735
order to supplier: creation 45.81 1291 5497
order to supplier: removal 3.38 97610 406
invoice (draft): creation 45.84 3376 5501
invoice (draft): removal 52.37 755 6284
invoice accept: apply 41.95 17712 5034
invoice accept: cancel 48.22 769 5786
customer reserve: creation 3800.54 179 456065
customer reserve: removal 4757.60 54 570912
realization accept: apply 84.68 182 10161
realization accept: cancel 92.76 99 11131
payment from customer: creation 60.00 110 7200
payment from customer: removal 5.90 75 708
payment to supplier: creation 49.33 151 5919
payment to supplier: removal 3.44 64 413
service: total inventory turnovers 4.95 1019 594
service: total monetary turnovers 6.54 40 785
service: aggregate perf. data 0.91 19207 109
service: refresh index statistics 0.03 259835 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-01-2021 19:28:13 to 08-01-2021 19:28:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5772
TEST_TIME 2 5157
TEST_TIME 3 4648
TEST_TIME 4 4076
TEST_TIME 5 4470
TEST_TIME 6 4888
TEST_TIME 7 5355
TEST_TIME 8 5196
TEST_TIME 9 5419
TEST_TIME 10 5650
TEST_TIME 11 5762
TEST_TIME 12 6041
TEST_TIME 13 6532
TEST_TIME 14 6827
TEST_TIME 15 6879
TEST_TIME 16 6978
TEST_TIME 17 7064
TEST_TIME 18 7506
TEST_TIME 19 7886
TEST_TIME 20 8383
TEST_TIME 21 8599
TEST_TIME 22 9477
TEST_TIME 23 10003
TEST_TIME 24 10344
TEST_TIME 25 10044
TEST_TIME 26 9967
TEST_TIME 27 9808
TEST_TIME 28 9885
TEST_TIME 29 9669
TEST_TIME 30 9561
TEST_TIME 31 9803
TEST_TIME 32 9855
TEST_TIME 33 9710
TEST_TIME 34 9544
TEST_TIME 35 9360
TEST_TIME 36 9228
TEST_TIME 37 9390
TEST_TIME 38 9368
TEST_TIME 39 9230
TEST_TIME 40 9233
TEST_TIME 41 9367
TEST_TIME 42 9443
TEST_TIME 43 9379
TEST_TIME 44 9368
TEST_TIME 45 9302
TEST_TIME 46 9420
TEST_TIME 47 9439
TEST_TIME 48 9447
TEST_TIME 49 9377
TEST_TIME 50 9632
TEST_TIME 51 9625
TEST_TIME 52 9615
TEST_TIME 53 9548
TEST_TIME 54 9597
TEST_TIME 55 9426
TEST_TIME 56 9495
TEST_TIME 57 9432
TEST_TIME 58 9382
TEST_TIME 59 9325
TEST_TIME 60 9218
TEST_TIME 61 9148
TEST_TIME 62 9245
TEST_TIME 63 9240
TEST_TIME 64 9184
TEST_TIME 65 9205
TEST_TIME 66 9206
TEST_TIME 67 9283
TEST_TIME 68 9285
TEST_TIME 69 9401
TEST_TIME 70 9345
TEST_TIME 71 9317
TEST_TIME 72 9400
TEST_TIME 73 9417
TEST_TIME 74 9384
TEST_TIME 75 9470
TEST_TIME 76 9422
TEST_TIME 77 9425
TEST_TIME 78 9507
TEST_TIME 79 9393
TEST_TIME 80 9412
TEST_TIME 81 9387
TEST_TIME 82 9372
TEST_TIME 83 9298
TEST_TIME 84 9313
TEST_TIME 85 9254
TEST_TIME 86 9289
TEST_TIME 87 9252
TEST_TIME 88 9228
TEST_TIME 89 9270
TEST_TIME 90 9301
TEST_TIME 91 9323
TEST_TIME 92 9313
TEST_TIME 93 9338
TEST_TIME 94 9318
TEST_TIME 95 9344
TEST_TIME 96 9365
TEST_TIME 97 9371
TEST_TIME 98 9420
TEST_TIME 99 9370
TEST_TIME 100 9414
TEST_TIME 101 9447
TEST_TIME 102 9357
TEST_TIME 103 9334
TEST_TIME 104 9304
TEST_TIME 105 9288
TEST_TIME 106 9255
TEST_TIME 107 9306
TEST_TIME 108 9279
TEST_TIME 109 9236
TEST_TIME 110 9191
TEST_TIME 111 9166
TEST_TIME 112 9168
TEST_TIME 113 9199
TEST_TIME 114 9241
TEST_TIME 115 9251
TEST_TIME 116 9339
TEST_TIME 117 9371
TEST_TIME 118 9355
TEST_TIME 119 9363
TEST_TIME 120 9292

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-01-2021 19:28:17 to 08-01-2021 19:28:20.

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 1537973 1537973 0 0.00 0 36660 6 0 0
doc_list_biud 1537972 1537972 0 0.00 0 69011 26 0 0
sp_add_invoice_to_stock 5134 5034 100 1.94 33 185828 17713 0 100
sp_cancel_adding_invoice 5786 5786 0 0.00 4 84244 770 0 0
sp_cancel_client_order 1735 1735 0 0.00 4 18135 377 0 0
sp_cancel_customer_reserve 570912 570912 0 0.00 1 34324 55 0 0
sp_cancel_pay_from_customer 708 708 0 0.00 3 7390 76 0 0
sp_cancel_pay_to_supplier 413 413 0 0.00 3 2361 65 0 0
sp_cancel_supplier_invoice 6292 6284 8 0.12 1 69018 756 0 8
sp_cancel_supplier_order 406 406 0 0.00 7 930296 97611 0 0
sp_cancel_write_off 11131 11131 0 0.00 1 12748 100 0 0
sp_client_order 20794 20794 0 0.00 4 34363 368 0 0
sp_customer_reserve 456065 456065 0 0.00 0 81981 180 0 0
sp_fill_shopping_cart 31775 31775 0 0.00 1 14171 38 0 0
sp_fill_shopping_cart_clo_res 456065 456065 0 0.00 0 14076 14 0 0
sp_get_clo_for_invoice 5034 5034 0 0.00 0 20002 339 0 0
sp_kill_cost_storno 18038 18038 0 0.00 0 8328 48 0 0
sp_kill_qstorno_ret_qs2qd 1159645 1159645 0 0.00 0 69008 30 0 0
sp_kill_qty_storno 611449 611449 0 0.00 0 69010 65 0 0
sp_lock_selected_doc 21061 21061 0 0.00 0 8466 4 0 0
sp_make_cost_storno 28314 28314 0 0.00 0 36655 62 0 0
sp_multiply_rows_for_pdistr 28314 28314 0 0.00 0 10022 27 0 0
sp_multiply_rows_for_qdistr 20794 20794 0 0.00 0 14237 176 0 0
sp_pay_from_customer 7200 7200 0 0.00 4 17673 110 0 0
sp_pay_to_supplier 5919 5919 0 0.00 4 36665 152 0 0
sp_payment_common 13119 13119 0 0.00 1 10817 37 0 0
sp_qd_handle_on_cancel_clo 1735 1735 0 0.00 0 18116 342 0 0
sp_qd_handle_on_invoice_upd_sts 10820 10820 0 0.00 0 41051 312 0 0
sp_qd_handle_on_reserve_upd_sts 10161 10161 0 0.00 0 23874 58 0 0
sp_reserve_write_off 10161 10161 0 0.00 6 23954 182 0 0
sp_supplier_invoice 5501 5501 0 0.00 6 116319 3377 0 0
sp_supplier_order 5497 5497 0 0.00 5 59459 1292 0 0
srv_aggregate_perf_data 109 109 0 0.00 2759 468398 19208 0 0
srv_fill_mon_cache_memory 151 151 0 0.00 1238 128723 35920 0 0
srv_find_qd_qs_mism 1067598 1067598 0 0.00 0 18443 5 0 0
srv_make_invnt_saldo 594 594 0 0.00 23 119295 1019 0 0
srv_make_money_saldo 785 785 0 0.00 1 10112 41 0 0
srv_recalc_idx_stat 4 4 0 0.00 173065 398213 259835 0 0
t$perf-abend:sp_add_invoice_to_stock 100 100 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5034 5034 0 0.00 0 12932 151 0 0
t$perf-norm:sp_cancel_adding_invoice 464 464 0 0.00 0 8866 99 0 0
t$perf-norm:sp_cancel_client_order 1735 1735 0 0.00 0 1985 7 0 0
t$perf-norm:sp_cancel_customer_reserve 683 683 0 0.00 0 12818 40 0 0
t$perf-norm:sp_cancel_pay_from_customer 708 708 0 0.00 0 2114 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 413 413 0 0.00 0 937 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 380 380 0 0.00 0 2569 19 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 31469 1382 0 0
t$perf-norm:sp_cancel_write_off 1077 1077 0 0.00 0 3450 14 0 0
t$perf-norm:sp_client_order 20794 20794 0 0.00 0 18592 17 0 0
t$perf-norm:sp_customer_reserve 1001 1001 0 0.00 0 6695 10 0 0
t$perf-norm:sp_pay_from_customer 7200 7200 0 0.00 0 7081 8 0 0
t$perf-norm:sp_pay_to_supplier 5919 5919 0 0.00 0 11165 13 0 0
t$perf-norm:sp_reserve_write_off 10161 10161 0 0.00 0 9604 10 0 0
t$perf-norm:sp_supplier_invoice 5501 5501 0 0.00 0 6532 18 0 0
t$perf-norm:sp_supplier_order 5497 5497 0 0.00 0 12302 14 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 297 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 151 151 0 0.00 0 644 11 0 0
t$perf-norm:srv_make_invnt_saldo 594 594 0 0.00 0 4081 25 0 0
t$perf-norm:srv_make_money_saldo 785 785 0 0.00 0 3540 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10268 10068 200 1.94 0 12539 17 0 200
v_all_customers 37310 37310 0 0.00 0 41 1 0 0
v_all_suppliers 30346 30346 0 0.00 0 22 1 0 0
v_all_wares 41588 41588 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 928 928 0 0.00 0 589 5 0 0
v_cancel_client_order 3470 3470 0 0.00 0 12812 11 0 0
v_cancel_customer_prepayment 1416 1416 0 0.00 0 2713 8 0 0
v_cancel_customer_reserve 1366 1366 0 0.00 0 1768 5 0 0
v_cancel_payment_to_supplier 826 826 0 0.00 0 614 4 0 0
v_cancel_supplier_invoice 776 760 16 2.06 0 11347 28 0 16
v_cancel_supplier_order 812 812 0 0.00 0 855 6 0 0
v_cancel_write_off 2154 2154 0 0.00 0 1528 13 0 0
v_max_id_clo_ord 5490 5490 0 0.00 0 439 1 0 0
v_max_id_clo_res 1001 1001 0 0.00 0 4414 19 0 0
v_max_id_ord_sup 5491 5491 0 0.00 0 5557 4 0 0
v_max_non_paid_invoice 1727 1727 0 0.00 0 1298 3 0 0
v_max_non_paid_realizn 4130 4130 0 0.00 0 6179 7 0 0
v_min_id_clo_ord 5490 5490 0 0.00 0 9518 13 0 0
v_min_id_clo_res 1001 1001 0 0.00 0 3368 9 0 0
v_min_id_ord_sup 5491 5491 0 0.00 0 6096 9 0 0
v_min_non_paid_invoice 5919 5919 0 0.00 0 9833 27 0 0
v_min_non_paid_realizn 7200 7200 0 0.00 0 10811 24 0 0
v_our_firm 10418 10418 0 0.00 0 11 1 0 0
v_reserve_write_off 20322 20322 0 0.00 0 12918 5 0 0
x_lock_depdocs_on_canc_invoice 11690 11690 0 0.00 0 33547 118 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 4979 297 0 0
x_make_qstorno_1000_1200 5497 5497 0 0.00 2 59452 1211 0 0
x_make_qstorno_1200_2000 5501 5501 0 0.00 3 102146 3240 0 0
x_make_qstorno_2100_3300 456065 456065 0 0.00 0 81979 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-01-2021 19:28:21 to 08-01-2021 19:28:25.

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
16:57:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:20 6105 8192000000 10089324832 10368335872 763033648 8.520 61 51 108 0 781580384 2019776 16526960
16:57:34 34876 8192000000 10312526512 10625916928 1351762544 14.163 100 85 170 1 1383939760 4408256 27768960
16:58:18 35737 8192000000 10372923248 10692669440 1417091920 14.747 100 83 167 0 1451079904 6247440 27740544
16:59:03 32621 8192000000 10390285888 10717716480 1442324256 14.970 100 90 180 0 1479137744 7462448 29351040
16:59:45 37264 8192000000 10428223936 10758881280 1475899120 15.265 100 89 178 1 1512785152 8145360 28740672
17:00:31 28328 8192000000 10443527744 10781114368 1497639168 15.456 100 86 170 0 1533826608 8873728 27313712
17:01:09 18694 8192000000 10474402800 10813935616 1521153184 15.660 100 83 166 1 1556422800 8766912 26502704
17:01:41 8345 8192000000 10499760528 10845544448 1557311712 15.973 100 84 168 1 1593391216 9591632 26487872
17:01:59 16171 8192000000 10534175520 10889093120 1583759184 16.200 100 75 150 1 1616383296 9163520 23460592
17:02:22 12448 8192000000 10556331584 10913689600 1614005808 16.459 100 72 144 0 1645571568 9492960 22072800
17:02:45 13989 8192000000 10576811632 10943156224 1634143328 16.630 100 73 145 2 1666491664 10393344 21954992
17:03:09 9311 8192000000 10597084576 10962554880 1658635216 16.837 100 75 149 1 1691204192 10494192 22074784
17:03:28 7603 8192000000 10616165344 10979479552 1675813168 16.982 100 77 153 0 1709747216 10894304 23039744
17:03:47 8198 8192000000 10631815968 11000246272 1690157232 17.103 100 79 158 2 1725067552 11759792 23150528
17:04:06 5185 8192000000 10657061056 11025731584 1719360528 17.347 100 85 170 1 1756748336 12543120 24844688
17:04:19 7729 8192000000 10668459632 11042525184 1727247072 17.413 100 73 146 0 1760942384 13289792 20405520
17:04:36 7731 8192000000 10676472400 11054493696 1735449728 17.481 100 73 143 3 1768050880 12664656 19936496
17:04:51 6201 8192000000 10689154464 11069292544 1753697264 17.632 100 77 154 0 1788207808 12998656 21511888
17:05:05 4572 8192000000 10696167792 11076874240 1757945088 17.667 100 76 150 1 1791234960 12689104 20600768
17:05:16 4086 8192000000 10712255696 11089682432 1775121264 17.809 100 89 178 0 1813280640 13342896 24816480
17:05:27 9589 8192000000 10710747216 11098144768 1779863056 17.848 100 73 145 0 1812770064 13036896 19870112
17:05:43 3428 8192000000 10729725408 11116695552 1785096976 17.891 100 76 152 1 1819229808 12376112 21756720
17:05:53 2725 8192000000 10751941088 11134009344 1809583616 18.092 100 87 176 1 1847921824 13375712 24962496
17:06:05 2896 8192000000 10748381616 11134566400 1815122976 18.138 100 86 172 0 1853284880 13418624 24743280
17:06:15 3209 8192000000 10766972640 11150258176 1817494512 18.157 100 78 156 1 1852350144 12395488 22460144
17:06:25 2196 8192000000 10768233184 11149070336 1827078704 18.235 100 93 186 2 1865997792 13067872 25851216
17:06:34 2254 8192000000 10770650864 11153747968 1831342144 18.270 100 88 176 0 1869954032 14183488 24428400
17:06:44 1960 8192000000 10780156352 11164872704 1835425200 18.304 100 91 182 1 1875288576 14838576 25024800
17:06:52 2718 8192000000 10777752640 11167301632 1839692128 18.338 100 90 181 0 1879609840 14509376 25408336
17:07:01 2005 8192000000 10792340784 11178020864 1849908864 18.421 100 92 182 0 1889412640 13927712 25576064
17:07:09 1937 8192000000 10795634240 11184033792 1853534160 18.451 100 89 175 2 1891598800 13567904 24496736
17:07:18 2089 8192000000 10801577344 11187761152 1854830208 18.461 100 84 168 1 1892070816 14497088 22743520
17:07:27 2051 8192000000 10805073392 11196043264 1858447808 18.491 100 90 179 0 1898375952 15370656 24557488
17:07:35 1868 8192000000 10807018288 11198582784 1864871792 18.543 100 91 180 3 1906083520 15827728 25384000
17:07:44 1740 8192000000 10817750560 11204980736 1869511136 18.580 100 95 191 3 1911798864 14549584 27738144
17:07:52 1643 8192000000 10814475456 11205439488 1872475456 18.604 100 89 178 2 1910089280 12115792 25498032
17:08:00 2025 8192000000 10808927360 11205173248 1873730128 18.614 100 88 175 2 1910262336 10920064 25612144
17:08:20 23050 8192000000 10807316976 11209670656 1871411920 18.596 100 62 122 2 1895557728 7291344 16854464
17:08:50 2564 8192000000 10801200192 11213733888 1874216640 18.618 100 62 124 1 1901816032 9752288 17847104
17:08:59 3097 8192000000 10800148896 11217145856 1877885984 18.648 100 52 104 1 1902593808 9935968 14771856
17:09:09 6237 8192000000 10787526656 11212394496 1874933344 18.624 100 29 58 2 1891176688 8475888 7767456
17:09:23 3117 8192000000 10801483680 11218833408 1881242032 18.675 100 43 86 0 1901041520 8047664 11751824
17:09:33 4370 8192000000 10795658928 11215597568 1876926400 18.640 100 32 64 1 1893197936 7855536 8416000
17:09:44 7206 8192000000 10803228512 11218399232 1878543216 18.653 100 30 60 3 1894342560 7489232 8310112
17:09:57 7482 8192000000 10788971904 11220668416 1877222768 18.643 100 22 44 1 1895089664 11360064 6506832
17:10:13 9043 8192000000 10791344416 11219656704 1876387440 18.636 100 16 33 1 1886866672 6103696 4375536
17:10:30 6901 8192000000 10778010768 11214024704 1876602352 18.638 100 13 26 1 1886362208 5912880 3846976
17:10:46 11585 8192000000 10786259344 11215974400 1878992848 18.657 100 16 32 1 1889613072 5563264 5056960
17:11:04 4329 8192000000 10785170304 11217195008 1881113328 18.674 100 27 55 3 1895375296 6406000 7855968
17:11:15 9157 8192000000 10794159840 11223080960 1881698384 18.679 100 19 36 0 1893212112 6329424 5184304
17:11:35 7767 8192000000 10795601248 11221983232 1882413312 18.685 100 17 34 1 1893104256 5692992 4997952
17:11:49 73292 8192000000 10820185328 11234181120 1889890144 18.745 100 44 88 1 1908885696 5418176 13577376
17:13:09 2977 8192000000 10816182832 11238051840 1892777472 18.768 100 66 134 0 1922555392 11086704 18691216
17:13:21 4999 8192000000 10808308896 11236524032 1890767072 18.752 100 42 83 4 1910616528 8279664 11569792
17:13:33 5314 8192000000 10809924176 11238416384 1893536736 18.774 100 42 82 3 1913321696 7802192 11982768
17:13:45 5338 8192000000 10819099488 11241656320 1895934496 18.794 100 42 84 0 1914777408 7205136 11637776
17:13:57 8586 8192000000 10802024304 11236233216 1876435616 18.636 99 25 51 2 1888653792 5926928 6291248
17:14:13 7070 8192000000 10808876320 11238813696 1893316400 18.772 100 38 71 0 1911215008 7876688 10021920
17:14:26 10408 8192000000 10798958000 11237027840 1895803488 18.793 100 24 47 3 1908834416 5979248 7051680
17:14:43 5834 8192000000 10809128608 11242786816 1899249232 18.820 100 31 62 1 1919957344 11286768 9421344
17:15:00 6787 8192000000 10814379136 11250675712 1900830048 18.833 100 18 36 1 1912196752 6274656 5092048
17:15:13 41741 8192000000 10818875936 11251138560 1903437280 18.854 100 18 36 0 1914423904 5052672 5933952
17:16:01 23216 8192000000 10824814656 11261009920 1910891808 18.914 100 22 43 2 1923358816 6338528 6128480
17:16:30 5974 8192000000 10812320208 11244912640 1887040640 18.722 99 28 56 0 1900532400 6101808 7389952
17:16:43 8245 8192000000 10802538464 11234009088 1875078336 18.625 99 25 51 1 1888653600 5614512 7960752
17:17:00 4429 8192000000 10805917312 11228168192 1865955664 18.552 99 29 58 3 1882288544 7185408 9147472
17:17:10 7396 8192000000 10803253744 11233460224 1874021968 18.617 99 26 52 3 1886517888 5323232 7172688
17:17:29 8274 8192000000 10789046208 11223076864 1855843584 18.470 99 27 54 0 1874822528 11631968 7346976
17:17:44 4105 8192000000 10791064384 11216732160 1862921072 18.527 99 32 62 0 1877904912 5770592 9213248
17:17:57 7653 8192000000 10748673696 11178524672 1778350080 17.836 95 22 44 2 1790183120 5102096 6730944
17:18:11 10504 8192000000 10752692736 11176636416 1810549408 18.100 98 25 50 4 1824921584 7137728 7234448
17:18:28 5321 8192000000 10747489424 11165057024 1808558944 18.084 98 29 57 2 1823862960 7199728 8104288
17:18:40 6562 8192000000 10737386480 11161817088 1809763088 18.094 99 16 32 1 1819917312 5497360 4656864
17:18:53 7689 8192000000 10709056592 11127771136 1755058912 17.643 96 16 31 0 1764254896 4637280 4558704
17:19:08 70091 8192000000 10664727712 11078840320 1574907904 16.124 87 19 40 0 1584930368 4293168 5729296
17:20:25 12159 8192000000 10711452464 11130335232 1780212208 17.851 99 27 54 0 1793843984 6360768 7271008
17:20:44 6605 8192000000 10690283504 11098439680 1699166320 17.178 94 34 68 0 1715262240 6523104 9572816
17:20:59 5964 8192000000 10683030464 11105058816 1750434448 17.605 98 31 62 1 1769300848 10306432 8559968
17:21:11 5066 8192000000 10713010560 11127373824 1791990768 17.948 100 31 62 3 1807443312 6799200 8653344
17:21:24 8809 8192000000 10716202256 11132604416 1800384096 18.017 100 22 44 2 1812296928 5615104 6297728
17:21:39 5449 8192000000 10703832592 11120783360 1771662880 17.781 98 27 54 0 1785444384 6438832 7342672
17:21:51 11702 8192000000 10722180112 11145306112 1787876480 17.914 99 23 45 1 1803738864 9770864 6091520
17:22:10 8766 8192000000 10729572816 11148840960 1816327296 18.148 100 20 40 0 1827700048 5184240 6188512
17:22:26 12784 8192000000 10735814560 11159597056 1823839824 18.209 100 15 30 1 1833926928 6020768 4066336
17:22:45 7256 8192000000 10740770512 11166625792 1834732544 18.298 100 29 56 0 1848604640 5502288 8369808
17:22:58 7166 8192000000 10736398544 11162157056 1814246416 18.131 99 18 36 1 1824890768 5031184 5613168
17:23:13 11438 8192000000 10751879408 11174002688 1835908352 18.307 100 13 26 0 1844781024 4994848 3877824
17:23:31 7881 8192000000 10746911840 11168964608 1833057328 18.284 100 18 36 1 1843815504 5815344 4942832
17:23:47 18299 8192000000 10764796448 11186229248 1847238784 18.400 100 21 42 0 1857987008 4679904 6068320
17:24:14 59395 8192000000 10760532416 11194703872 1853659936 18.452 100 33 66 1 1868784160 5580624 9543600
17:25:23 11501 8192000000 10760012944 11195559936 1855832672 18.469 100 24 48 0 1868386560 6137872 6416016
17:25:41 9732 8192000000 10789097216 11208515584 1867254000 18.562 100 37 74 1 1883968592 6753456 9961136
17:26:00 6956 8192000000 10782729792 11208445952 1867551776 18.564 100 32 63 1 1887360848 11191760 8617312
17:26:14 13032 8192000000 10804445120 11224449024 1870522640 18.589 100 31 62 0 1889667248 9926320 9218288
17:26:35 12272 8192000000 10784891520 11220279296 1872598928 18.605 100 15 30 1 1885809584 9272576 3938080
17:26:54 6331 8192000000 10787421088 11208826880 1856409856 18.474 99 21 42 1 1868402880 5774448 6218576
17:27:07 7943 8192000000 10809033552 11229552640 1883514784 18.693 100 22 44 0 1894540576 4501008 6524784
17:27:22 39488 8192000000 10820184752 11249299456 1906302976 18.877 100 41 82 2 1924971072 6542160 12125936
17:28:08 8584 8192000000 10837404016 11259478016 1916343824 18.958 100 42 84 2 1934423056 6424912 11654320
17:28:24 3916 8192000000 10855614608 11273359360 1922292944 19.005 100 53 106 1 1946774992 8947056 15534992
17:28:35 31020 8192000000 10853528912 11275878400 1925667664 19.032 100 56 111 0 1949937488 8382096 15887728
17:29:18 19229 8192000000 10864579104 11288309760 1938597424 19.136 100 52 104 0 1964806624 11263728 14945472
17:29:44 97175 8192000000 10867978688 11309211648 1940862112 19.154 100 35 70 2 1965648576 15134720 9651744
17:31:37 54961 8192000000 10881222624 11318788096 1948505056 19.215 100 23 44 0 1967948912 12959424 6484432
17:32:45 12094 8192000000 10906440080 11336208384 1968352512 19.372 100 53 106 3 1999042384 15544112 15145760
17:33:14 4172 8192000000 10913712304 11340419072 1970167120 19.387 100 59 117 1 2005905888 18749088 16989680
17:33:25 1238 8192000000 10927686096 11336462336 1970395344 19.389 100 79 158 1 2012070928 18303792 23371792
17:33:34 14508 8192000000 10919518704 11342774272 1970434832 19.389 100 59 118 0 2006138912 18689056 17015024
17:34:05 9085 8192000000 10924367824 11354800128 1980395776 19.468 100 50 101 0 2017020160 21733200 14891184
17:34:22 20219 8192000000 10918828448 11351461888 1962168816 19.323 99 47 91 2 1994970464 19388000 13413648
17:34:50 4793 8192000000 10934727488 11358048256 1982168048 19.482 100 62 121 1 2019576288 18525328 18882912
17:35:04 16971 8192000000 10927588176 11354673152 1966266272 19.356 99 52 104 0 2002423472 20737216 15419984
17:35:31 8994 8192000000 10929602224 11361984512 1985811024 19.511 100 52 104 5 2023102432 21923344 15368064
17:35:54 15896 8192000000 10940579808 11374399488 1992506464 19.564 100 49 97 0 2029999664 22768304 14724896
17:36:21 6902 8192000000 10955108128 11383570432 2001793952 19.637 100 57 114 2 2041087920 23105856 16188112
17:36:36 2751 8192000000 10962431568 11374804992 1995533376 19.587 100 76 152 1 2043294208 24910976 22849856
17:36:49 9999 8192000000 10956105792 11379040256 1998086688 19.608 100 67 132 1 2045851456 27710096 20054672
17:37:08 11699 8192000000 10963077504 11385196544 2001245216 19.633 100 70 139 0 2050635680 28852752 20537712
17:37:26 2448 8192000000 10960722688 11382005760 1999916320 19.622 100 79 158 1 2053592448 29697104 23979024
17:37:37 3725 8192000000 10979271232 11395969024 2006468064 19.674 100 75 149 0 2063169552 34872240 21829248
17:37:49 6244 8192000000 10971884672 11393417216 2009792928 19.700 100 70 140 1 2061468592 30867264 20808400
17:38:03 3950 8192000000 10972465504 11388493824 2003456800 19.650 100 79 159 0 2058022912 30800416 23765696
17:38:13 5627 8192000000 10946177488 11366268928 1982332448 19.483 99 77 154 2 2037560416 31937968 23290000
17:38:35 18277 8192000000 10941753504 11369103360 1959046160 19.298 98 68 136 0 2014330448 35010944 20273344
17:39:06 2739 8192000000 10952809440 11374116864 1979122272 19.458 100 64 126 1 2037435328 38498640 19814416
17:39:22 6149 8192000000 10940262736 11371720704 1975490016 19.429 100 60 120 1 2032596192 38526464 18579712
17:39:36 3849 8192000000 10956634912 11374714880 1981129344 19.474 100 63 123 1 2036934816 36333696 19471776
17:39:49 9368 8192000000 10947203344 11370496000 1970308048 19.388 99 62 124 0 2027950672 38133200 19509424
17:40:08 4045 8192000000 10955194608 11365253120 1948934304 19.218 98 69 137 1 2011776624 40438704 22403616
17:40:19 2159 8192000000 10951918704 11366584320 1962381536 19.325 99 74 146 2 2022825792 37316544 23127712
17:40:32 6413 8192000000 10958204304 11384389632 1987846608 19.527 100 69 138 2 2049114784 39161616 22106560
17:40:48 5816 8192000000 10955424224 11389681664 1987037440 19.520 100 58 116 1 2044956016 39423168 18495408
17:41:03 8280 8192000000 10954997680 11390500864 1992384240 19.563 100 49 98 0 2044226016 35747104 16094672
17:41:17 3657 8192000000 10966953264 11382337536 1989227152 19.538 100 79 158 0 2050350816 36711680 24411984
17:41:28 9184 8192000000 10956659376 11381633024 1984380992 19.499 100 73 145 0 2046617600 39502608 22734000
17:41:47 3639 8192000000 10941050352 11363446784 1968283696 19.372 99 62 122 0 2021805072 34175248 19346128
17:42:03 6696 8192000000 10953616816 11373715456 1979670752 19.462 100 66 132 0 2034729968 34279616 20779600
17:42:18 3317 8192000000 10949092256 11374661632 1981606992 19.477 100 64 129 3 2037853520 35928336 20318192
17:42:31 4596 8192000000 10961233648 11382939648 1985281024 19.506 100 57 114 0 2040655296 35932000 19442272
17:42:46 8592 8192000000 10952058448 11381444608 1986022016 19.512 100 59 118 0 2041378064 36807568 18548480
17:43:04 8394 8192000000 10951599696 11376672768 1967635456 19.367 99 64 125 1 2024165936 36542736 19987744
17:43:23 3932 8192000000 10975497648 11393736704 1994321808 19.578 100 68 136 1 2053749168 38366864 21060496
17:43:35 2509 8192000000 10990330512 11402723328 2001209312 19.632 100 80 160 1 2064613040 39169136 24234592
17:43:58 2698 8192000000 10956591968 11378020352 1964346144 19.341 98 79 158 2 2030144064 41136032 24661888
17:44:09 9017 8192000000 10985728016 11399520256 1994015056 19.576 100 82 164 0 2060347104 40286416 26045632
17:44:26 5792 8192000000 10978989104 11395502080 1977159120 19.442 99 83 166 2 2045972160 40767568 28045472
17:44:39 6968 8192000000 10970748848 11390070784 1984604624 19.501 100 77 154 1 2051663968 42541936 24517408
17:44:55 3654 8192000000 10956717488 11379200000 1963900592 19.337 99 72 142 0 2029625472 42485152 23239728
17:45:06 2362 8192000000 10946198656 11353804800 1951576480 19.239 99 76 148 1 2018210304 43512640 23121184
17:45:15 2498 8192000000 10946446864 11357069312 1947027360 19.203 99 88 176 2 2020171712 45359344 27785008
17:45:25 1466 8192000000 10968334720 11379961856 1978500352 19.453 100 88 175 2 2051331056 45972864 26857840
17:45:33 3110 8192000000 10981982224 11394109440 1987892912 19.527 100 90 179 3 2061929968 46706448 27330608
17:45:42 6700 8192000000 10946606224 11379093504 1969933280 19.385 100 52 104 0 2037504816 50352720 17218816
17:45:57 10242 8192000000 10941187312 11376926720 1967341744 19.364 100 43 86 1 2027709520 45586928 14780848
17:46:28 11118 8192000000 10908009856 11341037568 1898556544 18.815 97 43 86 0 1956018800 42556832 14905424
17:46:52 15656 8192000000 10917020064 11355271168 1946182512 19.196 100 40 80 2 2001671712 41714176 13775024
17:47:17 16180 8192000000 10887381744 11338145792 1915494688 18.951 98 34 68 1 1971056640 43462176 12099776
17:47:49 19475 8192000000 10908006608 11360620544 1930882576 19.074 99 27 54 0 1983805632 43287632 9635424
17:48:18 14822 8192000000 10881763056 11337256960 1913371152 18.934 99 18 36 1 1959702448 39780752 6550544
17:48:49 25831 8192000000 10879636256 11326025728 1890587776 18.751 98 25 50 4 1939347008 39825056 8934176
17:49:24 25429 8192000000 10861224496 11313332224 1874700384 18.622 98 15 30 0 1914173664 34003744 5469536
17:49:55 25755 8192000000 10839670656 11288748032 1849142496 18.415 97 16 32 1 1881622240 26979872 5499872
17:50:35 27646 8192000000 10811285520 11250745344 1796804624 17.988 95 13 25 0 1829014992 28208080 4002288
17:51:09 61384 8192000000 10824371600 11263549440 1831913600 18.275 97 17 31 2 1847321504 10698656 4709248
17:52:18 58405 8192000000 10858688160 11273117696 1854074000 18.455 97 45 88 1 1876388720 8551008 13763712
17:53:38 41389 8192000000 10840999840 11272564736 1833015792 18.284 96 36 73 0 1853073152 10412592 9644768
17:54:30 20076 8192000000 10845373280 11280691200 1878725856 18.655 98 45 89 0 1908675280 17882560 12066864
17:54:57 111190 8192000000 10856115696 11304927232 1913202160 18.932 100 36 73 1 1945258480 21949120 10107200
17:56:55 46969 8192000000 10892231920 11337121792 1939577216 19.143 100 25 50 1 1968434128 22151968 6704944
17:57:58 29885 8192000000 10873171792 11329875968 1931719840 19.081 99 34 68 0 1959612960 17985648 9907472
17:58:46 28497 8192000000 10858722304 11342135296 1939502464 19.143 100 8 16 0 1959115360 17594848 2018048
17:59:31 19109 8192000000 10865032912 11321171968 1947305472 19.205 100 13 27 0 1956711552 5645488 3760592
18:00:01 52334 8192000000 10884770752 11348545536 1960225600 19.308 100 23 46 2 1975018464 8363072 6429792
18:01:00 109935 8192000000 10896761984 11355480064 1935771488 19.113 98 13 27 0 1952091728 12346688 3973552
18:02:57 110488 8192000000 10880163312 11354402816 1950959760 19.234 99 22 44 1 1978121712 19478992 7682960
18:05:00 71100 8192000000 10897460768 11357880320 1957566672 19.287 99 20 40 1 1972050192 9053984 5429536
18:06:22 35371 8192000000 10909832784 11373359104 1990296800 19.546 100 35 70 0 2010172624 9594464 10281360
18:07:10 87489 8192000000 10917465264 11394424832 1991216848 19.553 100 23 46 1 2012933264 14949872 6766544
18:08:45 58266 8192000000 10921049152 11413716992 1985071344 19.505 100 8 16 0 2008377360 21147488 2158528
18:09:50 55223 8192000000 10897736208 11352190976 1909436624 18.902 96 19 36 0 1922642528 7737088 5468816
18:10:55 38343 8192000000 10922514848 11381792768 1980542192 19.469 100 26 51 1 1999391472 11578752 7270528
18:11:40 41687 8192000000 10929476592 11381755904 1972483392 19.405 99 38 76 3 1996799728 13400368 10915968
18:13:04 76730 8192000000 10911725360 11389820928 1966656528 19.359 99 10 20 0 1985955152 16110480 3188144
18:14:27 81889 8192000000 10905941664 11376226304 1928352288 19.054 97 11 22 0 1940047792 8759072 2936432
18:15:55 31362 8192000000 10929649424 11387678720 1993635920 19.573 100 30 60 1 2016627216 13658240 9333056
18:16:34 58412 8192000000 10929540736 11406286848 2005406960 19.665 100 31 62 1 2029597536 15965408 8225168
18:17:39 101147 8192000000 10921936112 11377356800 1895657952 18.791 95 4 8 0 1912840592 16326800 855840
18:19:26 53681 8192000000 10945140848 11389788160 1992931440 19.567 100 23 46 1 2008776848 9161200 6684208
18:20:26 27828 8192000000 10944457760 11390717952 1982217808 19.482 99 60 117 2 2010635408 12079392 16338208
18:21:05 50133 8192000000 10937719328 11403862016 1996443248 19.595 100 30 60 0 2027566592 22663152 8460192
18:22:55 55683 8192000000 10914931968 11371053056 1962396416 19.325 98 31 61 0 1988790816 16929280 9465120
18:23:58 46091 8192000000 10905861280 11373146112 1927436096 19.046 97 14 28 1 1939233424 7670736 4126592
18:25:02 37395 8192000000 10877287232 11353309184 1933930128 19.098 98 26 52 1 1951997248 11171744 6895376
18:25:45 15111 8192000000 10871620032 11336015872 1926630880 19.040 98 17 33 2 1938223616 7118288 4474448
18:26:09 48593 8192000000 10853150736 11324133376 1901433264 18.838 97 9 18 0 1910790080 6886368 2470448
18:27:08 46594 8192000000 10863049008 11324125184 1883899616 18.697 97 14 27 0 1893733648 6189584 3644448
18:28:00 61933 8192000000 10864485872 11332239360 1898315280 18.813 97 17 34 0 1912772368 9463152 4993936
18:29:15 61957 8192000000 10864846224 11349991424 1952764464 19.248 100 20 38 1 1970560624 12447136 5349024
18:31:24 39416 8192000000 10846111920 11304890368 1888754752 18.736 97 15 29 3 1903467392 10601600 4111040
18:32:10 51506 8192000000 10889690576 11347574784 1905223392 18.868 98 25 50 2 1925695072 13008736 7462944
18:33:11 57868 8192000000 10883024736 11345260544 1913505616 18.935 98 21 40 0 1931518784 11318160 6695008
18:34:15 54918 8192000000 10862609632 11332591616 1891848320 18.761 97 23 45 1 1915429440 16668384 6912736
18:35:16 31546 8192000000 10848059712 11306299392 1887576000 18.726 97 21 42 0 1905113184 11662800 5874384
18:36:00 75185 8192000000 10864483648 11330260992 1899367088 18.821 98 13 26 0 1915547712 12294688 3885936
18:37:23 33389 8192000000 10903713808 11352797184 1951739840 19.240 100 35 70 0 1972318608 10936448 9642320
18:38:02 27926 8192000000 10877149264 11328376832 1902465296 18.846 97 42 81 3 1925770800 12183712 11121792
18:38:36 77532 8192000000 10858121456 11328864256 1821924944 18.193 93 23 46 1 1848098336 19913152 6260240
18:40:56 12427 8192000000 10879113904 11320504320 1936763488 19.121 100 37 74 1 1953329856 6136912 10429456
18:41:15 15516 8192000000 10874691424 11309629440 1874058688 18.617 97 45 90 0 1898229760 11313648 12857424
18:41:36 20760 8192000000 10888540944 11331493888 1937684912 19.128 100 53 106 1 1968373424 15796160 14892352
18:42:06 50822 8192000000 10837785008 11311886336 1857133504 18.480 96 19 38 1 1880023120 17746128 5143488
18:43:08 36702 8192000000 10863173312 11298058240 1865281536 18.546 97 44 88 4 1889261008 11896368 12083104
18:43:58 20337 8192000000 10856469840 11296780288 1865877312 18.551 97 55 108 4 1897747584 16563088 15307184
18:44:25 62234 8192000000 10839490544 11315195904 1875471920 18.629 98 20 40 0 1900489584 18990640 6027024
18:45:43 128722 8192000000 10865095376 11324129280 1913824096 18.937 100 23 46 0 1941390928 20328480 7238352
18:47:59 62411 8192000000 10848971296 11323342848 1916259232 18.957 99 26 52 1 1937141488 13157808 7724448
18:49:22 45594 8192000000 10842136464 11316224000 1912288784 18.925 99 4 8 0 1922474576 9132528 1053264
18:50:42 49024 8192000000 10860707264 11319369728 1918801792 18.977 99 14 28 2 1936594736 13555648 4237296
18:51:41 58109 8192000000 10831602688 11305377792 1874773776 18.623 97 8 16 1 1887183568 10234464 2175328
18:52:45 71159 8192000000 10844599744 11320619008 1904464560 18.862 99 8 16 0 1922787920 15994128 2329232
18:54:14 29787 8192000000 10876276560 11336630272 1947365408 19.205 100 27 54 2 1962010288 6910208 7734672
18:55:00 33915 8192000000 10892890448 11354034176 1965457264 19.349 100 23 46 0 1980318144 8016800 6844080
18:55:45 65150 8192000000 10896075088 11370500096 1963339200 19.333 100 17 34 1 1980202496 11664784 5198512
18:56:56 86255 8192000000 10897802736 11376046080 1972647424 19.406 100 8 16 1 1983612592 8966656 1998512
18:58:29 67613 8192000000 10911050992 11378155520 1962443008 19.325 99 26 52 0 1983494384 14302576 6748800
19:00:08 45205 8192000000 10913070400 11382456320 1963192816 19.331 99 14 27 0 1980969984 13728688 4048480
19:01:15 48417 8192000000 10948775888 11387658240 1994302464 19.578 100 39 76 2 2016568448 10949984 11316000
19:02:12 87480 8192000000 10920819968 11391397888 1968587936 19.374 99 18 36 0 1985407520 12049616 4769968
19:03:46 74036 8192000000 10934144224 11398070272 1996228864 19.593 100 17 34 0 2012531168 11703200 4599104
19:05:06 95715 8192000000 10914955968 11367739392 1900194368 18.828 95 23 44 2 1917509152 10478640 6836144
19:06:50 10182 8192000000 10927898672 11377676288 1983742224 19.494 100 37 75 0 2002450816 8728464 9980128
19:07:08 59202 8192000000 10919764176 11384537088 1929444992 19.062 97 39 78 2 1958162032 17612688 11104352
19:08:18 111862 8192000000 10897113936 11353374720 1934558064 19.103 98 16 32 1 1954072224 15403280 4110880
19:10:20 61158 8192000000 10919514288 11373367296 1959303648 19.301 99 34 68 2 1976921088 8490176 9127264
19:11:27 21300 8192000000 10921946912 11378085888 1984748288 19.502 100 40 79 1 2006407200 10521376 11137536
19:12:11 45381 8192000000 10920313200 11386720256 1986165296 19.513 100 41 82 1 2012693552 14813056 11715200
19:13:13 60957 8192000000 10892940112 11372376064 1951126848 19.235 98 9 18 0 1968710688 15216432 2367408
19:14:20 41517 8192000000 10873212944 11352252416 1916193952 18.956 97 7 14 1 1929771280 11741056 1836272
19:15:13 45411 8192000000 10868154960 11341348864 1905745072 18.872 97 14 27 1 1918109776 7821632 4543072
19:16:06 74467 8192000000 10859950784 11329646592 1886295600 18.716 96 16 32 0 1901685312 10841312 4548400
19:17:39 46219 8192000000 10890282976 11357958144 1940147152 19.148 99 20 40 1 1963291744 16864992 6279600
19:18:38 65355 8192000000 10895465200 11365302272 1961477360 19.318 100 18 36 0 1985773168 18921360 5374448
19:20:11 39383 8192000000 10881310992 11351207936 1909528832 18.903 97 21 42 0 1943935200 27680800 6725568
19:20:57 96097 8192000000 10878156032 11347755008 1879151136 18.658 96 15 30 0 1906524160 22568864 4804160
19:23:39 94555 8192000000 10845603184 11305447424 1803870816 18.046 93 15 30 2 1826391856 17837504 4683536
19:25:19 80019 8192000000 10886556144 11337691136 1909040944 18.899 98 43 86 3 1936342288 14833024 12468320
19:26:52 40752 8192000000 9171456896 9402949632 327962976 3.849 17 1 2 0 333719920 5694816 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 08-01-2021 19:28:27 to 08-01-2021 19:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 100 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-01-2021 19:28:58 to 08-01-2021 19:29:00.

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          243327
MON$OLDEST_ACTIVE               243328
MON$OLDEST_SNAPSHOT             243328
MON$NEXT_TRANSACTION            243328
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                       2015616
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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'

08.01.21 19:29:01. 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-01-08 19:29:03 No severe PSQL-related problems occured
08.01.21 19:29:04. End of report.