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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17080068 kB
MemAvailable 31350548 kB
Buffers 0 kB
Cached 14612992 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-15 19:27:09
DTS_END                         2021-01-15 19:27:09.8530
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38396
TRN_ID                          242426
ATT_ID                          637
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: 9545.90 20159 1145508
customer order: creation 176.38 377 21166
customer order: refuse 15.28 346 1834
order to supplier: creation 46.98 1298 5638
order to supplier: removal 3.29 105345 395
invoice (draft): creation 46.28 3318 5554
invoice (draft): removal 54.68 683 6561
invoice accept: apply 42.28 17829 5073
invoice accept: cancel 50.00 835 6000
customer reserve: creation 3907.28 177 468873
customer reserve: removal 4894.26 57 587311
realization accept: apply 84.22 200 10106
realization accept: cancel 94.58 108 11349
payment from customer: creation 60.07 148 7208
payment from customer: removal 5.63 72 675
payment to supplier: creation 48.93 168 5871
payment to supplier: removal 3.47 77 416
service: total inventory turnovers 4.52 1109 542
service: total monetary turnovers 6.86 37 823
service: aggregate perf. data 0.91 16552 109
service: refresh index statistics 0.03 254434 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5648
TEST_TIME 2 3619
TEST_TIME 3 4045
TEST_TIME 4 4303
TEST_TIME 5 4804
TEST_TIME 6 4598
TEST_TIME 7 4563
TEST_TIME 8 4726
TEST_TIME 9 5044
TEST_TIME 10 5658
TEST_TIME 11 6054
TEST_TIME 12 6044
TEST_TIME 13 6106
TEST_TIME 14 6311
TEST_TIME 15 6627
TEST_TIME 16 7061
TEST_TIME 17 7242
TEST_TIME 18 7657
TEST_TIME 19 7880
TEST_TIME 20 8011
TEST_TIME 21 8379
TEST_TIME 22 8186
TEST_TIME 23 9150
TEST_TIME 24 9776
TEST_TIME 25 9855
TEST_TIME 26 10002
TEST_TIME 27 10887
TEST_TIME 28 10850
TEST_TIME 29 10587
TEST_TIME 30 10650
TEST_TIME 31 10559
TEST_TIME 32 10753
TEST_TIME 33 10688
TEST_TIME 34 10762
TEST_TIME 35 10637
TEST_TIME 36 10409
TEST_TIME 37 10276
TEST_TIME 38 10075
TEST_TIME 39 9973
TEST_TIME 40 10018
TEST_TIME 41 10053
TEST_TIME 42 10015
TEST_TIME 43 9970
TEST_TIME 44 9841
TEST_TIME 45 9774
TEST_TIME 46 9919
TEST_TIME 47 9819
TEST_TIME 48 9724
TEST_TIME 49 9609
TEST_TIME 50 9583
TEST_TIME 51 9477
TEST_TIME 52 9514
TEST_TIME 53 9528
TEST_TIME 54 9612
TEST_TIME 55 9605
TEST_TIME 56 9575
TEST_TIME 57 9625
TEST_TIME 58 9619
TEST_TIME 59 9725
TEST_TIME 60 9811
TEST_TIME 61 9745
TEST_TIME 62 9811
TEST_TIME 63 9870
TEST_TIME 64 9814
TEST_TIME 65 9945
TEST_TIME 66 9801
TEST_TIME 67 9745
TEST_TIME 68 9702
TEST_TIME 69 9667
TEST_TIME 70 9679
TEST_TIME 71 9670
TEST_TIME 72 9622
TEST_TIME 73 9648
TEST_TIME 74 9589
TEST_TIME 75 9509
TEST_TIME 76 9751
TEST_TIME 77 9746
TEST_TIME 78 9722
TEST_TIME 79 9687
TEST_TIME 80 9857
TEST_TIME 81 9822
TEST_TIME 82 9784
TEST_TIME 83 9857
TEST_TIME 84 9812
TEST_TIME 85 9887
TEST_TIME 86 9919
TEST_TIME 87 9876
TEST_TIME 88 9794
TEST_TIME 89 9781
TEST_TIME 90 9728
TEST_TIME 91 9726
TEST_TIME 92 9652
TEST_TIME 93 9649
TEST_TIME 94 9698
TEST_TIME 95 9662
TEST_TIME 96 9652
TEST_TIME 97 9636
TEST_TIME 98 9730
TEST_TIME 99 9717
TEST_TIME 100 9718
TEST_TIME 101 9771
TEST_TIME 102 9784
TEST_TIME 103 9794
TEST_TIME 104 9792
TEST_TIME 105 9856
TEST_TIME 106 9876
TEST_TIME 107 9871
TEST_TIME 108 9878
TEST_TIME 109 9825
TEST_TIME 110 9756
TEST_TIME 111 9739
TEST_TIME 112 9684
TEST_TIME 113 9685
TEST_TIME 114 9657
TEST_TIME 115 9640
TEST_TIME 116 9618
TEST_TIME 117 9594
TEST_TIME 118 9576
TEST_TIME 119 9624
TEST_TIME 120 9549

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-01-2021 19:28:42 to 15-01-2021 19:28:45.

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 1580176 1580176 0 0.00 0 38145 7 0 0
doc_list_biud 1580176 1580176 0 0.00 0 32767 27 0 0
sp_add_invoice_to_stock 5191 5073 118 2.27 45 186657 17830 0 118
sp_cancel_adding_invoice 6000 6000 0 0.00 5 59825 835 0 0
sp_cancel_client_order 1834 1834 0 0.00 4 11385 347 0 0
sp_cancel_customer_reserve 587311 587311 0 0.00 1 28938 57 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 3 4480 72 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 3 3806 78 0 0
sp_cancel_supplier_invoice 6575 6561 14 0.21 2 12656 683 0 14
sp_cancel_supplier_order 395 395 0 0.00 9 1030325 105346 0 0
sp_cancel_write_off 11349 11349 0 0.00 1 20648 109 0 0
sp_client_order 21166 21166 0 0.00 3 44211 377 0 0
sp_customer_reserve 468873 468873 0 0.00 0 60570 177 0 0
sp_fill_shopping_cart 32354 32354 0 0.00 1 10607 37 0 0
sp_fill_shopping_cart_clo_res 468869 468869 0 0.00 0 41978 14 0 0
sp_get_clo_for_invoice 5069 5069 0 0.00 0 44034 280 0 0
sp_kill_cost_storno 18440 18440 0 0.00 0 7256 53 0 0
sp_kill_qstorno_ret_qs2qd 1192927 1192927 0 0.00 0 28911 30 0 0
sp_kill_qty_storno 628625 628625 0 0.00 0 32767 66 0 0
sp_lock_selected_doc 20926 20926 0 0.00 0 6926 6 0 0
sp_make_cost_storno 28254 28254 0 0.00 0 37085 63 0 0
sp_multiply_rows_for_pdistr 28254 28254 0 0.00 0 15416 36 0 0
sp_multiply_rows_for_qdistr 21166 21166 0 0.00 0 44204 172 0 0
sp_pay_from_customer 7208 7208 0 0.00 4 24203 149 0 0
sp_pay_to_supplier 5871 5871 0 0.00 5 25433 169 0 0
sp_payment_common 13079 13079 0 0.00 1 24184 40 0 0
sp_qd_handle_on_cancel_clo 1834 1834 0 0.00 0 11380 319 0 0
sp_qd_handle_on_invoice_upd_sts 11069 11069 0 0.00 0 32767 310 0 0
sp_qd_handle_on_reserve_upd_sts 10106 10106 0 0.00 0 12714 66 0 0
sp_reserve_write_off 10106 10106 0 0.00 6 15284 201 0 0
sp_supplier_invoice 5554 5554 0 0.00 6 92833 3318 0 0
sp_supplier_order 5638 5638 0 0.00 5 47402 1299 0 0
srv_aggregate_perf_data 109 109 0 0.00 3053 117355 16552 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1375 139880 34045 0 0
srv_find_qd_qs_mism 1097318 1097318 0 0.00 0 15949 6 0 0
srv_make_invnt_saldo 542 542 0 0.00 48 82931 1110 0 0
srv_make_money_saldo 823 823 0 0.00 1 9053 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 153738 338450 254434 0 0
t$perf-abend:sp_add_invoice_to_stock 118 118 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5073 5073 0 0.00 0 18334 158 0 0
t$perf-norm:sp_cancel_adding_invoice 435 435 0 0.00 0 7730 133 0 0
t$perf-norm:sp_cancel_client_order 1834 1834 0 0.00 0 4505 18 0 0
t$perf-norm:sp_cancel_customer_reserve 667 667 0 0.00 0 3509 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 1797 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 1944 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 364 364 0 0.00 0 414 14 0 0
t$perf-norm:sp_cancel_supplier_order 395 395 0 0.00 0 26069 1598 0 0
t$perf-norm:sp_cancel_write_off 965 965 0 0.00 0 3303 13 0 0
t$perf-norm:sp_client_order 21166 21166 0 0.00 0 15644 20 0 0
t$perf-norm:sp_customer_reserve 1061 1061 0 0.00 0 3560 10 0 0
t$perf-norm:sp_pay_from_customer 7208 7208 0 0.00 0 12997 13 0 0
t$perf-norm:sp_pay_to_supplier 5871 5871 0 0.00 0 15562 16 0 0
t$perf-norm:sp_reserve_write_off 10106 10106 0 0.00 0 15250 16 0 0
t$perf-norm:sp_supplier_invoice 5554 5554 0 0.00 0 17734 21 0 0
t$perf-norm:sp_supplier_order 5638 5638 0 0.00 0 4032 16 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 478 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 23027 158 0 0
t$perf-norm:srv_make_invnt_saldo 542 542 0 0.00 0 916 24 0 0
t$perf-norm:srv_make_money_saldo 823 823 0 0.00 0 4319 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10374 10138 236 2.27 0 4491 19 0 236
v_all_customers 38536 38536 0 0.00 0 84 1 0 0
v_all_suppliers 30846 30846 0 0.00 0 83 1 0 0
v_all_wares 42332 42332 0 0.00 0 94 1 0 0
v_cancel_adding_invoice 870 870 0 0.00 0 491 7 0 0
v_cancel_client_order 3668 3668 0 0.00 0 8621 8 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 2337 8 0 0
v_cancel_customer_reserve 1334 1334 0 0.00 0 1387 5 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 1346 8 0 0
v_cancel_supplier_invoice 756 728 28 3.70 0 465 13 0 28
v_cancel_supplier_order 790 790 0 0.00 0 481 5 0 0
v_cancel_write_off 1930 1930 0 0.00 0 2875 13 0 0
v_max_id_clo_ord 5638 5638 0 0.00 0 511 1 0 0
v_max_id_clo_res 1061 1061 0 0.00 0 2485 18 0 0
v_max_id_ord_sup 5550 5550 0 0.00 0 6359 6 0 0
v_max_non_paid_invoice 1636 1636 0 0.00 0 5344 8 0 0
v_max_non_paid_realizn 3768 3768 0 0.00 0 1664 4 0 0
v_min_id_clo_ord 5638 5638 0 0.00 0 6796 11 0 0
v_min_id_clo_res 1061 1061 0 0.00 0 5281 17 0 0
v_min_id_ord_sup 5550 5550 0 0.00 0 5943 7 0 0
v_min_non_paid_invoice 5871 5871 0 0.00 0 12591 31 0 0
v_min_non_paid_realizn 7208 7208 0 0.00 0 8992 24 0 0
v_our_firm 10676 10676 0 0.00 0 16 1 0 0
v_reserve_write_off 20212 20212 0 0.00 0 6582 8 0 0
x_lock_depdocs_on_canc_invoice 12197 12197 0 0.00 0 20404 112 0 0
x_lock_depdocs_on_canc_sup_ord 395 395 0 0.00 0 3148 303 0 0
x_make_qstorno_1000_1200 5638 5638 0 0.00 2 46916 1221 0 0
x_make_qstorno_1200_2000 5554 5554 0 0.00 3 92816 3188 0 0
x_make_qstorno_2100_3300 468873 468873 0 0.00 0 60566 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-01-2021 19:28:46 to 15-01-2021 19:28:50.

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:13 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:20 18544 8192000000 10266664592 10573570048 942295776 10.316 72 53 106 0 962080944 2693456 17091712
16:57:47 33614 8192000000 10345287264 10662785024 1390233744 14.508 100 91 182 0 1424289168 4814224 29241200
16:58:29 19514 8192000000 10371214368 10699702272 1429797232 14.859 100 77 152 1 1460698304 6441280 24459792
16:58:58 17395 8192000000 10410056096 10742210560 1454981088 15.082 100 67 134 0 1483090992 6820992 21288912
16:59:27 11170 8192000000 10434581360 10769375232 1494238528 15.426 100 83 166 2 1528245600 7896608 26110464
16:59:49 22974 8192000000 10469749520 10806210560 1518589056 15.638 100 84 168 0 1553911040 8522400 26799584
17:00:19 18298 8192000000 10477576384 10816692224 1535112480 15.781 100 87 174 1 1571646944 8995520 27538944
17:00:47 17582 8192000000 10493184496 10837876736 1550390864 15.913 100 85 170 1 1586421120 9444144 26586112
17:01:15 8354 8192000000 10500667024 10847072256 1559565136 15.992 100 76 152 1 1592395216 9640032 23190048
17:01:31 14886 8192000000 10521839360 10874884096 1581094464 16.178 100 75 150 0 1613354400 9566688 22693248
17:01:56 17132 8192000000 10552212096 10906849280 1609827328 16.423 100 77 154 3 1643597824 10761920 23008576
17:02:20 14797 8192000000 10579207632 10936709120 1634329776 16.632 100 85 170 0 1670596336 11366416 24900144
17:02:47 15522 8192000000 10604080432 10967949312 1658157408 16.833 100 84 166 2 1694448400 12012640 24278352
17:03:15 12950 8192000000 10630647488 10997690368 1687336240 17.079 100 85 169 2 1724549936 12733696 24480000
17:03:39 11867 8192000000 10642628576 11008176128 1699406960 17.180 100 86 172 3 1738204096 13587536 25209600
17:04:01 9701 8192000000 10651364592 11022098432 1711464608 17.281 100 78 156 2 1747321152 13358400 22498144
17:04:19 8062 8192000000 10664177456 11037581312 1719518064 17.348 100 83 166 0 1757010848 13598912 23893872
17:04:41 8509 8192000000 10677807280 11052072960 1735361856 17.480 100 84 166 2 1774050848 14400176 24288816
17:04:57 5430 8192000000 10689159040 11066474496 1751259360 17.612 100 79 156 1 1787563312 13945008 22358944
17:05:10 5304 8192000000 10705482016 11082084352 1762285376 17.703 100 80 160 1 1798294112 13538656 22470080
17:05:23 5873 8192000000 10713747440 11092836352 1773769856 17.798 100 82 165 2 1811558960 14009856 23779248
17:05:36 3881 8192000000 10716315296 11098046464 1782375312 17.869 100 79 158 1 1817236464 13094176 21766976
17:05:47 3753 8192000000 10723481104 11109056512 1788128528 17.916 100 82 163 1 1824341808 12640176 23573104
17:05:57 3242 8192000000 10739392880 11122286592 1797211984 17.991 100 85 170 1 1834950064 13391744 24346336
17:06:08 1995 8192000000 10749252320 11129253888 1806832880 18.070 100 89 172 4 1844241280 13012016 24396384
17:06:16 3145 8192000000 10753507120 11135229952 1813387456 18.124 100 85 169 2 1849158064 11897360 23873248
17:06:25 9082 8192000000 10755470448 11137855488 1816126192 18.146 100 81 160 3 1851903424 12565328 23211904
17:06:42 5212 8192000000 10772462272 11154817024 1824333840 18.213 100 91 182 3 1862422896 13709568 24379488
17:06:55 2436 8192000000 10775320768 11161747456 1834605040 18.297 100 92 185 0 1874331952 14175184 25551728
17:07:03 2635 8192000000 10776775552 11160899584 1837994960 18.324 100 86 173 1 1875836336 13993232 23848144
17:07:12 2488 8192000000 10787549696 11172855808 1844153280 18.375 100 92 182 0 1885843296 15013552 26676464
17:07:21 1728 8192000000 10796212128 11181559808 1849157984 18.415 100 89 178 0 1889187040 14489568 25539488
17:07:30 2066 8192000000 10795824944 11179872256 1854364608 18.458 100 93 188 1 1895792880 14679184 26749088
17:07:38 3013 8192000000 10807142032 11197378560 1862693040 18.525 100 90 180 1 1900304720 11916736 25694944
17:07:48 1756 8192000000 10810204064 11198373888 1869128880 18.577 100 90 181 3 1906244976 12261184 24854912
17:07:56 2284 8192000000 10820205760 11211423744 1872303840 18.603 100 89 179 2 1910013664 12539808 25170016
17:08:04 1319 8192000000 10823315952 11213029376 1874991120 18.625 100 93 186 0 1916200608 14170016 27039472
17:08:12 2066 8192000000 10829167552 11217936384 1880270400 18.667 100 91 183 0 1919683584 13342512 26070672
17:08:21 1838 8192000000 10823708112 11217068032 1882827424 18.688 100 93 186 3 1921656208 12982752 25846032
17:08:29 1157 8192000000 10829778160 11223097344 1883065936 18.690 100 85 171 1 1920795040 13235088 24494016
17:08:36 36618 8192000000 10812961600 11214954496 1881131616 18.674 100 58 115 1 1906991648 9217904 16642128
17:09:19 1385 8192000000 10823675504 11218497536 1883800944 18.696 100 74 148 2 1916258640 11514864 20942832
17:09:27 15964 8192000000 10806916208 11225739264 1884196864 18.699 100 55 110 0 1911235200 10317632 16720704
17:09:51 10476 8192000000 10792011872 11214798848 1879849600 18.664 100 28 56 1 1895191136 7236384 8105152
17:10:14 5780 8192000000 10791567904 11218063360 1881741696 18.679 100 30 60 2 1896885696 6170208 8973792
17:10:26 1997 8192000000 10795803760 11220647936 1884339424 18.700 100 44 87 1 1904160912 7620016 12201472
17:10:39 10168 8192000000 10786609808 11217289216 1882838784 18.688 100 25 50 3 1895982816 6229840 6914192
17:10:59 3947 8192000000 10794227776 11224993792 1883948016 18.697 100 29 58 1 1898902688 7128096 7826576
17:11:09 6989 8192000000 10784705024 11223904256 1885710240 18.711 100 15 28 4 1896586384 5678944 5197200
17:11:23 5953 8192000000 10792963392 11228229632 1887397200 18.725 100 18 35 1 1898787264 6585424 4804640
17:11:35 8687 8192000000 10789693680 11226959872 1888248720 18.732 100 21 43 0 1900143488 5606384 6288384
17:11:52 11514 8192000000 10790205488 11228430336 1888652128 18.735 100 9 18 1 1896588640 5286704 2649808
17:12:10 15206 8192000000 10803079792 11234217984 1894053088 18.778 100 16 32 2 1904976928 6210432 4713408
17:12:33 4037 8192000000 10805378560 11236691968 1897848368 18.809 100 25 47 2 1911526544 6981024 6697152
17:12:43 11553 8192000000 10798464192 11238649856 1896076768 18.795 100 16 32 1 1907190720 6420144 4693808
17:13:01 6104 8192000000 10807126768 11241402368 1899692320 18.824 100 22 44 1 1911656656 5908496 6055840
17:13:17 65994 8192000000 10813069600 11250724864 1904413552 18.862 100 38 76 1 1921543152 6096480 11033120
17:14:34 20607 8192000000 10821961744 11262078976 1908152864 18.892 100 28 56 0 1922153920 6382576 7618480
17:15:01 6867 8192000000 10832004736 11264765952 1914107792 18.940 100 23 46 1 1926700800 6547808 6045200
17:15:14 7824 8192000000 10817572480 11258830848 1895730528 18.792 99 23 46 0 1907972240 6184720 6056992
17:15:30 7737 8192000000 10834053552 11266142208 1912941648 18.930 100 22 44 1 1928452752 9584816 5926288
17:15:44 8037 8192000000 10824164432 11268018176 1916559664 18.959 100 32 64 1 1932279424 6792912 8926848
17:15:59 8747 8192000000 10843014672 11272888320 1916000576 18.955 100 29 58 2 1930359600 5669632 8689392
17:16:14 8171 8192000000 10818573184 11261861888 1896471584 18.798 99 22 44 3 1908635120 6262576 5900960
17:16:28 8935 8192000000 10822254096 11267346432 1917092704 18.964 100 25 50 1 1930277008 6353280 6831024
17:16:43 8874 8192000000 10808375424 11250548736 1890337840 18.749 99 28 56 0 1903532256 4713280 8481136
17:16:58 15898 8192000000 10804139216 11243937792 1868823456 18.575 98 16 32 0 1879122192 6008080 4290656
17:17:24 17771 8192000000 10783686176 11212955648 1782170384 17.867 94 19 38 1 1792451920 4827184 5454352
17:17:52 22094 8192000000 10709443984 11126116352 1661007040 16.857 89 26 52 0 1673667072 5461440 7198592
17:18:21 45172 8192000000 10740978128 11159203840 1794058320 17.965 98 56 111 0 1817370288 6879456 16432512
17:19:16 11318 8192000000 10718735152 11151659008 1767287808 17.745 97 16 32 1 1776933856 5031888 4614160
17:19:33 7901 8192000000 10717718048 11136090112 1764692336 17.723 97 33 67 2 1780343712 6763264 8888112
17:19:51 4248 8192000000 10717291536 11123593216 1747389296 17.580 97 36 72 0 1764093744 6890112 9814336
17:20:05 3753 8192000000 10701913024 11109634048 1756539680 17.656 98 30 60 1 1771704688 6145776 9019232
17:20:17 8444 8192000000 10684917696 11093180416 1694855168 17.142 95 36 72 1 1712302624 6501328 10946128
17:20:34 5131 8192000000 10700858560 11103031296 1765850528 17.733 99 37 75 0 1783457072 6581952 11024592
17:20:48 5361 8192000000 10701191232 11114405888 1753196560 17.628 98 27 54 0 1767576672 7002240 7377872
17:21:03 8467 8192000000 10689012384 11102449664 1723127744 17.378 96 27 54 0 1736903696 6000656 7775296
17:21:17 6823 8192000000 10689211216 11102126080 1746657136 17.574 98 27 52 3 1760223584 6184048 7382400
17:21:31 5050 8192000000 10691330112 11104694272 1764442656 17.721 99 21 42 1 1776614000 5932224 6239120
17:21:43 6862 8192000000 10718465536 11131600896 1799443696 18.009 100 32 64 1 1814492720 5487312 9561712
17:21:57 12071 8192000000 10692377904 11095707648 1729773088 17.434 96 27 54 0 1743604992 5254976 8576928
17:22:16 10816 8192000000 10700103264 11114008576 1786125056 17.900 100 38 77 1 1803765776 6370032 11270688
17:22:35 8679 8192000000 10725357440 11135520768 1802409216 18.034 100 25 50 1 1815326880 5756192 7161472
17:22:50 64498 8192000000 10739326128 11155374080 1814298944 18.131 100 35 69 2 1834013408 9313520 10400944
17:24:04 6959 8192000000 10737445024 11162095616 1832609312 18.281 100 30 60 2 1847944288 5901088 9433888
17:24:21 9460 8192000000 10760983760 11176607744 1837061168 18.317 100 33 66 1 1853523264 6953584 9508512
17:24:38 8872 8192000000 10753268624 11177951232 1839820048 18.339 100 26 52 1 1852699936 5624416 7255472
17:24:54 5809 8192000000 10756834016 11183288320 1845560480 18.386 100 38 76 1 1863437600 6723616 11153504
17:25:08 5771 8192000000 10759260096 11183706112 1843506592 18.369 100 24 47 1 1860687216 9500176 7680448
17:25:21 14296 8192000000 10759623440 11186991104 1848609984 18.411 100 20 40 0 1860389696 5733600 6046112
17:25:42 5542 8192000000 10771111456 11195879424 1852991008 18.446 100 28 56 0 1867944448 7302896 7650544
17:25:54 10592 8192000000 10765100352 11195604992 1857424656 18.482 100 26 52 2 1870854672 5863440 7566576
17:26:12 12103 8192000000 10772433872 11203985408 1855992336 18.471 100 14 28 1 1865489456 5944320 3552800
17:26:33 7942 8192000000 10779324736 11208323072 1864508880 18.540 100 18 36 2 1874747408 5256704 4981824
17:26:47 8792 8192000000 10783286544 11213045760 1865122576 18.545 100 18 36 1 1876132224 5887232 5122416
17:27:04 16154 8192000000 10816000416 11229708288 1881259520 18.675 100 19 38 1 1890977968 4640128 5078320
17:27:42 21382 8192000000 10837697696 11250708480 1904683552 18.864 100 48 95 0 1926379024 8587792 13107680
17:28:28 19879 8192000000 10853836480 11268644864 1914464864 18.942 100 57 113 2 1942287056 11998544 15823648
17:29:00 101117 8192000000 10862738592 11290251264 1917773536 18.969 100 40 78 1 1946176864 17245872 11157456
17:30:52 19598 8192000000 10868610528 11295981568 1933122976 19.092 100 50 100 3 1964729792 17497408 14109408
17:31:20 23844 8192000000 10877119328 11308507136 1938322512 19.133 100 38 76 1 1965964336 16803840 10837984
17:31:54 5242 8192000000 10889754208 11311071232 1947927904 19.210 100 53 106 3 1982161600 18658752 15574944
17:32:08 12776 8192000000 10884594352 11320135680 1949927648 19.226 100 46 90 0 1987681232 24644912 13108672
17:32:30 14441 8192000000 10884491328 11320287232 1952680704 19.248 100 44 87 2 1986750784 20184240 13885840
17:32:56 6644 8192000000 10893757232 11325288448 1961506416 19.318 100 45 90 1 1992735536 18808912 12420208
17:33:16 29220 8192000000 10913928752 11343982592 1964248048 19.340 100 42 84 0 1996837632 20163776 12425808
17:33:53 5643 8192000000 10929252224 11354865664 1975466976 19.429 100 64 125 2 2022217936 27648048 19102912
17:34:10 9729 8192000000 10932563008 11353837568 1976529824 19.437 100 55 110 0 2015620560 23744608 15346128
17:34:27 7127 8192000000 10943221024 11361943552 1982310192 19.483 100 72 144 2 2029787232 25759568 21717472
17:34:44 19392 8192000000 10950517504 11370373120 1990064048 19.544 100 65 128 1 2036023152 27778656 18180448
17:35:12 22013 8192000000 10945374272 11372257280 1988742816 19.534 100 57 114 0 2035126704 29316592 17067296
17:35:41 27503 8192000000 10947282512 11379703808 1990036496 19.544 100 55 109 0 2034513808 28772256 15705056
17:36:23 10771 8192000000 10939037568 11380047872 1992493808 19.563 100 35 68 0 2030816448 28037776 10284864
17:36:41 6009 8192000000 10946014720 11382550528 1999274176 19.617 100 52 104 0 2044924752 29071600 16578976
17:36:54 4332 8192000000 10969371920 11392368640 2004294880 19.657 100 66 130 4 2054350112 29784496 20270736
17:37:06 3871 8192000000 10949628912 11368210432 1982995600 19.488 99 73 146 0 2036858880 32439472 21423808
17:37:18 8291 8192000000 10974406288 11393687552 2000488704 19.627 100 80 157 1 2054597312 30632400 23476208
17:37:33 5181 8192000000 10973810560 11390271488 2004995664 19.662 100 80 158 1 2059238704 30554800 23688240
17:37:50 9045 8192000000 10953199712 11380129792 1982471024 19.484 99 65 130 0 2031450048 29262864 19716160
17:38:11 11612 8192000000 10967916768 11396845568 1997702192 19.605 100 59 115 0 2047767968 33439712 16626064
17:38:35 3752 8192000000 10956482496 11382546432 1979077776 19.457 99 66 130 0 2030676560 32063952 19534832
17:38:47 3981 8192000000 10972814288 11393421312 1998807840 19.613 100 75 149 0 2054312240 33117920 22386480
17:39:00 7302 8192000000 10978286288 11401785344 2007791280 19.684 100 70 138 1 2060691152 31879808 21020064
17:39:15 4279 8192000000 10969502608 11397869568 1996304480 19.594 99 80 160 2 2052996176 32330592 24361104
17:39:28 5334 8192000000 10976362128 11403997184 2011042528 19.710 100 81 161 0 2069344544 33903840 24398176
17:39:40 3742 8192000000 10974942176 11399155712 2005678912 19.667 100 71 142 0 2061162160 34717632 20765616
17:39:51 5710 8192000000 10981969792 11401306112 2004311280 19.657 100 76 153 0 2062164736 34552512 23300944
17:40:04 7454 8192000000 10972333248 11395788800 1997551920 19.603 100 76 149 1 2056453440 35637584 23263936
17:40:20 8002 8192000000 10956449392 11380969472 1988515072 19.532 100 67 132 1 2044611712 35842208 20254432
17:40:35 4855 8192000000 10965293744 11388379136 1992284960 19.562 100 74 148 0 2052123744 36262256 23576528
17:40:47 2277 8192000000 10943535808 11362369536 1941409552 19.158 98 68 134 1 1998846016 36769072 20667392
17:40:58 3280 8192000000 10945870848 11363708928 1956102416 19.275 99 76 150 4 2015889392 37122704 22664272
17:41:09 7300 8192000000 10953113520 11373219840 1974492224 19.421 100 76 150 0 2036836864 38898960 23445680
17:41:23 5551 8192000000 10924279872 11342168064 1939997248 19.147 99 73 146 1 2002933088 40259104 22676736
17:41:41 3700 8192000000 10948421440 11374088192 1973926912 19.417 100 76 150 0 2039438400 40243360 25268128
17:41:52 3600 8192000000 10940156640 11361697792 1960317200 19.309 99 71 141 2 2023482496 40751328 22413968
17:42:03 3350 8192000000 10966727600 11389820928 1990856800 19.551 100 83 165 3 2054650816 38811888 24982128
17:42:13 5674 8192000000 10952714464 11379060736 1979936736 19.464 100 71 142 3 2041028896 38806400 22285760
17:42:27 12346 8192000000 10931417152 11353903104 1959522064 19.302 100 60 120 2 2012347728 34480544 18345120
17:42:48 4879 8192000000 10946174480 11371573248 1970195744 19.387 100 59 117 0 2027186576 38348400 18642432
17:43:02 2335 8192000000 10955025776 11366289408 1968283232 19.372 100 90 179 2 2035533984 39500240 27750512
17:43:12 4906 8192000000 10929648720 11347517440 1951874864 19.241 99 70 137 1 2012758256 39228560 21654832
17:43:25 8757 8192000000 10938251552 11362439168 1965606336 19.351 100 70 136 4 2024661792 38111696 20943760
17:43:42 3175 8192000000 10943716400 11358588928 1964529296 19.342 100 73 146 3 2026094528 38512848 23052384
17:43:54 3685 8192000000 10951230832 11369402368 1972758400 19.407 100 77 153 0 2038268800 41298032 24212368
17:44:06 4244 8192000000 10953504368 11377741824 1978083392 19.450 100 69 136 1 2038837904 39184464 21570048
17:44:23 3130 8192000000 10955879952 11383742464 1983004496 19.488 100 67 131 0 2041938224 38439408 20494320
17:44:41 5275 8192000000 10950910032 11372216320 1972131088 19.402 100 68 136 2 2033833360 39895408 21806864
17:44:53 2882 8192000000 10934350720 11356835840 1948296080 19.213 99 76 152 3 2011149024 38947504 23905440
17:45:06 2619 8192000000 10959491376 11370242048 1972720400 19.407 100 75 149 1 2036376528 40250864 23405264
17:45:16 1864 8192000000 10953369552 11366760448 1941160816 19.156 98 78 156 0 2007760176 41964208 24635152
17:45:26 4561 8192000000 10951592512 11374374912 1970831728 19.392 100 73 144 0 2036209776 42305616 23072432
17:45:39 4069 8192000000 10932471664 11343921152 1940813264 19.153 99 71 138 1 2005763600 42160384 22789952
17:45:57 4420 8192000000 10914071920 11344646144 1948613456 19.215 100 48 95 1 2001555408 36937200 16004752
17:46:09 17383 8192000000 10906053824 11346034688 1937506096 19.127 99 38 75 1 1985520128 35571888 12442144
17:46:36 7777 8192000000 10910404336 11336372224 1924826096 19.025 98 49 99 1 1977088528 36016128 16246304
17:46:54 8948 8192000000 10926567312 11345108992 1935490560 19.111 99 68 134 5 1993377200 36712256 21174384
17:47:10 2497 8192000000 10932103584 11349069824 1947393008 19.206 99 78 155 0 2011414272 40244208 23777056
17:47:19 4522 8192000000 10934747584 11352121344 1935989472 19.115 99 76 150 0 2003521952 44398912 23133568
17:47:31 8416 8192000000 10933869120 11354509312 1938863072 19.138 99 62 124 1 2004400432 45654416 19882944
17:47:49 9727 8192000000 10917184960 11349491712 1942834304 19.169 100 41 80 0 2002228592 45594496 13799792
17:48:08 27832 8192000000 10909909424 11350228992 1911108448 18.916 98 41 80 3 1970200768 45000672 14091648
17:48:47 14356 8192000000 10918495520 11354222592 1944296416 19.181 100 42 83 0 2004698224 45953424 14448384
17:49:14 23068 8192000000 10931062464 11364925440 1950856368 19.233 100 40 79 1 2015047824 49946880 14244576
17:49:45 6648 8192000000 10959686432 11382640640 1962572560 19.326 100 68 137 1 2039380992 53684368 23124064
17:50:00 1371 8192000000 10977987680 11384295424 1956766704 19.280 99 93 175 3 2042982368 56933920 29281744
17:50:09 6593 8192000000 10956520400 11389272064 1971340832 19.396 100 62 124 1 2043823440 52426336 20056272
17:50:23 16621 8192000000 10924609632 11377958912 1959312112 19.301 100 33 66 1 2022578656 51294528 11972016
17:50:46 22811 8192000000 10917550992 11371057152 1954723424 19.264 100 32 64 1 2009977904 43839360 11415120
17:51:26 19428 8192000000 10910774592 11366416384 1962746304 19.328 100 25 50 1 2003591344 32574240 8270800
17:51:52 29916 8192000000 10894443680 11349803008 1942695824 19.168 99 26 53 1 1981469024 30057216 8715984
17:52:32 10455 8192000000 10903330272 11366313984 1953436672 19.254 100 17 34 0 1992899664 33771408 5691584
17:53:05 64146 8192000000 10889991328 11355340800 1907834736 18.889 98 13 26 1 1956021728 43346768 4840224
17:54:21 48170 8192000000 10862262992 11311476736 1876186288 18.634 97 9 18 0 1897136832 18565152 2385392
17:55:21 11384 8192000000 10857826576 11302735872 1901770416 18.841 99 42 84 2 1922962368 9117424 12074528
17:55:42 28729 8192000000 10853438432 11314716672 1902928816 18.850 99 8 16 2 1917935760 12822720 2184224
17:56:23 53086 8192000000 10870310848 11307802624 1890385200 18.749 98 34 69 2 1916345136 16596192 9363744
17:57:28 23323 8192000000 10859148816 11300454400 1913169104 18.932 99 47 94 1 1935523584 8891712 13462768
17:57:59 24453 8192000000 10867191728 11322306560 1928789936 19.057 100 12 24 2 1939674272 8118496 2765840
17:58:37 94500 8192000000 10881999984 11349397504 1925339744 19.030 99 15 29 1 1946621360 17639184 3642432
18:00:20 68796 8192000000 10871044992 11322855424 1891731472 18.760 97 13 26 1 1903081904 8204032 3146400
18:01:36 139879 8192000000 10899452656 11346665472 1908363920 18.894 98 13 26 2 1922769856 10773328 3632608
18:04:16 112898 8192000000 10901624048 11348463616 1950592864 19.231 99 29 58 1 1965811568 7337264 7881440
18:06:40 47316 8192000000 10911691216 11370647552 1978151056 19.450 100 24 48 0 1994304944 9449456 6704432
18:07:35 49652 8192000000 10894399856 11380637696 1978190672 19.450 100 19 38 0 1991861216 7976704 5693840
18:08:34 27550 8192000000 10907484576 11383164928 1981672016 19.478 100 13 26 1 1992489200 7846976 2970208
18:09:13 46837 8192000000 10897564560 11363373056 1962065920 19.322 99 18 34 1 1973703712 7162352 4475440
18:10:07 48001 8192000000 10909958688 11382149120 1980260128 19.467 100 14 30 0 1995616672 11221168 4135376
18:11:01 46685 8192000000 10927450160 11391778816 1994504464 19.579 100 24 48 1 2013960320 12382064 7073792
18:11:54 52970 8192000000 10930461632 11400527872 1998995888 19.615 100 15 31 0 2018363904 14736448 4631568
18:12:54 24805 8192000000 10923866976 11406499840 1999475248 19.619 100 14 27 1 2021099856 17149216 4475392
18:13:27 37477 8192000000 10910859872 11383300096 1976892240 19.440 99 15 30 1 1990014480 8421184 4701056
18:14:11 41239 8192000000 10923854608 11391754240 1999295840 19.617 100 17 34 2 2011211376 7051808 4863728
18:15:54 59997 8192000000 10919525856 11401216000 1998445952 19.610 100 13 26 0 2010744880 8810064 3488864
18:17:02 21040 8192000000 10906489152 11397246976 1980950208 19.472 99 4 8 0 1991536000 9425280 1160512
18:17:30 28452 8192000000 10911673856 11391623168 1981415632 19.476 99 5 10 0 1992258144 9659440 1183072
18:18:29 72976 8192000000 10909555408 11394756608 1934763968 19.105 97 16 32 1 1956217072 16408528 5044576
18:19:50 57041 8192000000 10902443648 11374878720 1925331264 19.030 97 10 20 1 1944744736 16305104 3108368
18:20:56 61423 8192000000 10871308896 11344826368 1864078528 18.536 94 14 28 1 1878232432 9955456 4198448
18:22:04 38295 8192000000 10867103472 11329134592 1848743728 18.412 95 21 42 0 1862800528 7779696 6277104
18:22:49 22158 8192000000 10876259760 11328974848 1907764016 18.889 98 35 70 0 1925835776 8733152 9338608
18:23:21 11900 8192000000 10905484528 11352715264 1949755584 19.225 100 55 110 2 1975929536 10806240 15367712
18:23:43 20415 8192000000 10889267296 11340017664 1931435552 19.078 99 38 76 3 1955917520 13690352 10791616
18:24:11 13878 8192000000 10852033104 11307556864 1910024160 18.907 98 32 62 0 1931206608 12768896 8413552
18:24:31 34843 8192000000 10880994128 11343364096 1931854976 19.082 99 26 51 1 1952263456 12938368 7470112
18:25:12 33622 8192000000 10870933296 11333681152 1920991680 18.995 98 42 84 1 1946645872 12717264 12936928
18:25:56 61907 8192000000 10876654640 11357282304 1916522560 18.959 98 20 41 1 1944290192 22120384 5647248
18:27:04 68557 8192000000 10883355056 11346718720 1915215104 18.948 98 13 26 0 1932686960 13949600 3522256
18:28:19 34281 8192000000 10874781600 11320262656 1900398496 18.829 97 42 84 0 1921258176 9606672 11253008
18:29:04 85090 8192000000 10879077008 11341246464 1891414416 18.757 97 31 62 0 1914490704 14613248 8463040
18:30:47 17308 8192000000 10845892432 11291922432 1832872816 18.283 95 27 53 0 1848451520 8626928 6951776
18:31:13 29980 8192000000 10900878752 11323944960 1890736768 18.752 98 42 85 1 1917595824 14950272 11908784
18:31:57 85771 8192000000 10824023616 11300622336 1855213024 18.464 97 19 38 1 1883904272 23551856 5139392
18:33:58 85921 8192000000 10857211744 11300265984 1861524672 18.516 96 38 77 3 1882592528 10702256 10365600
18:35:43 33231 8192000000 10873868464 11318403072 1927578128 19.048 100 31 63 1 1954140912 17111824 9450960
18:36:46 41855 8192000000 10868563168 11343122432 1925867456 19.034 99 19 38 1 1950434640 19136208 5430976
18:37:40 59171 8192000000 10868959424 11351990272 1928676160 19.056 99 15 29 0 1952027136 18749424 4601552
18:38:45 57746 8192000000 10879914560 11339939840 1912963296 18.930 98 17 34 1 1935288928 17255632 5070000
18:39:49 78521 8192000000 10887260384 11348754432 1925297328 19.029 99 18 35 0 1948870224 18108784 5464112
18:41:25 80733 8192000000 10889669824 11357396992 1947352640 19.205 100 12 24 1 1971753920 21067920 3333360
18:42:55 57984 8192000000 10869476176 11354636288 1935670016 19.112 99 12 24 2 1965159200 25748544 3740640
18:44:06 44797 8192000000 10883221856 11349917696 1934107424 19.100 99 27 55 2 1956378384 14793072 7477888
18:45:01 65912 8192000000 10901140224 11346640896 1899573952 18.823 97 17 34 0 1915641200 11528144 4539104
18:46:13 25190 8192000000 10879166320 11329269760 1915287504 18.949 98 49 98 0 1943389632 13749552 14352576
18:46:47 57276 8192000000 10861588512 11343196160 1889975680 18.746 97 14 28 0 1909883200 15646688 4260832
18:47:51 60303 8192000000 10869364896 11333853184 1876432048 18.636 97 16 32 3 1893646400 11857472 5356880
18:49:04 55091 8192000000 10887617072 11354710016 1912349872 18.926 98 23 46 3 1931628464 13132064 6146528
18:50:05 90445 8192000000 10895229584 11354021888 1934879184 19.106 99 19 38 1 1955203856 15378832 4945840
18:51:43 72555 8192000000 10884944048 11367067648 1916256832 18.957 98 25 50 2 1937313232 14363120 6693280
18:53:04 51273 8192000000 10888584720 11366715392 1953094656 19.251 100 18 36 0 1976636256 17043792 6497808
18:54:01 33464 8192000000 10914611648 11365654528 1973275104 19.411 100 52 103 1 1995004656 6882576 14846976
18:54:43 111797 8192000000 10889232448 11364012032 1965482768 19.350 100 33 66 0 1984301296 9180496 9638032
18:56:41 43383 8192000000 10895230048 11371802624 1972049984 19.402 100 18 36 0 1991519968 14188000 5281984
18:58:21 102217 8192000000 10902525952 11378475008 1974155744 19.418 99 9 18 1 1990146288 13646992 2343552
19:00:10 64141 8192000000 10912681376 11394891776 1970617008 19.390 99 12 24 0 1986075808 12178736 3280064
19:01:22 48518 8192000000 10912655936 11403210752 1986949072 19.520 100 15 30 0 2002968784 11853088 4166624
19:02:16 56687 8192000000 10930903056 11398148096 1994606944 19.580 100 16 32 0 2008765520 9746176 4412400
19:03:28 35110 8192000000 10922491520 11396141056 1986623984 19.517 99 32 62 1 2002919232 6610272 9684976
19:04:09 48361 8192000000 10932117824 11407843328 1975253488 19.427 98 21 42 1 1992846048 12114608 5477952
19:05:05 73469 8192000000 10913012064 11404992512 1953366336 19.253 98 9 18 3 1968715840 12939904 2409600
19:06:25 66770 8192000000 10914086736 11393617920 1943602432 19.175 98 9 18 0 1961963168 15989232 2371504
19:07:45 87441 8192000000 10875292608 11362324480 1824132912 18.211 92 19 38 1 1842788528 12801008 5854608
19:09:19 71669 8192000000 10880758080 11353939968 1899199184 18.820 97 16 32 2 1920815936 17163984 4452768
19:10:37 48858 8192000000 10865693840 11330465792 1856152960 18.472 95 19 37 1 1878343632 16032784 6157888
19:11:39 109851 8192000000 10885276864 11367882752 1920858416 18.994 99 18 35 1 1939068432 13566032 4643984
19:13:35 77017 8192000000 10877694432 11352616960 1875125488 18.626 96 11 22 0 1889592464 11907856 2559120
19:15:04 50921 8192000000 10887064544 11362193408 1935320448 19.109 99 15 30 1 1951116464 11694816 4101200
19:16:03 86133 8192000000 10841633152 11308531712 1837974128 18.324 94 37 74 2 1862976848 14859104 10143616
19:17:40 62082 8192000000 10841330592 11300003840 1852120560 18.439 96 23 46 2 1865446640 6820160 6505920
19:19:06 43389 8192000000 10870010416 11323904000 1917352544 18.966 99 41 82 1 1939530416 10924784 11253088
19:19:56 31404 8192000000 10879541072 11343220736 1942555168 19.167 100 46 88 0 1967187008 12051632 12580208
19:20:43 66683 8192000000 10843999904 11322298368 1894472512 18.782 97 14 28 1 1912152848 13688864 3991472
19:21:57 71271 8192000000 10861572944 11335479296 1918249120 18.973 99 12 24 1 1936346240 14223200 3873920
19:23:16 71557 8192000000 10871912544 11344064512 1927611312 19.048 99 13 25 1 1943319936 12158544 3550080
19:24:39 70094 8192000000 10873389232 11352711168 1934467824 19.103 99 19 38 1 1957409360 17094368 5847168
19:26:18 58329 8192000000 10007323792 10392875008 1125064080 12.075 58 6 11 0 1139518464 13291200 1163184

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 15-01-2021 19:28:52 to 15-01-2021 19:29:24.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 118 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 15-01-2021 19:29:25 to 15-01-2021 19:29:26.

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          242731
MON$OLDEST_ACTIVE               242732
MON$OLDEST_SNAPSHOT             242732
MON$NEXT_TRANSACTION            242732
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                       2044768
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'

15.01.21 19:29:27. 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-15 19:29:30 No severe PSQL-related problems occured
15.01.21 19:29:31. End of report.