Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.01.2021 01: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 17479896 kB
MemAvailable 31363812 kB
Buffers 0 kB
Cached 14189004 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-07 01:27:10
DTS_END                         2021-01-07 01:27:10.1120
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/48520
TRN_ID                          238419
ATT_ID                          655
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: 9211.10 25417 1105332
customer order: creation 169.98 350 20398
customer order: refuse 14.59 336 1751
order to supplier: creation 45.10 1291 5412
order to supplier: removal 3.37 105057 404
invoice (draft): creation 44.98 3151 5398
invoice (draft): removal 53.63 859 6435
invoice accept: apply 40.33 18683 4840
invoice accept: cancel 49.27 748 5912
customer reserve: creation 3712.69 185 445523
customer reserve: removal 4782.75 57 573930
realization accept: apply 81.27 194 9752
realization accept: cancel 85.76 115 10291
payment from customer: creation 58.57 139 7028
payment from customer: removal 5.37 71 644
payment to supplier: creation 48.18 115 5781
payment to supplier: removal 3.35 105 402
service: total inventory turnovers 4.67 953 560
service: total monetary turnovers 6.38 27 765
service: aggregate perf. data 0.85 19786 102
service: refresh index statistics 0.03 356121 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-01-2021 01:28:00 to 07-01-2021 01:28:02.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5839
TEST_TIME 2 5862
TEST_TIME 3 5472
TEST_TIME 4 5125
TEST_TIME 5 4332
TEST_TIME 6 4641
TEST_TIME 7 4800
TEST_TIME 8 5195
TEST_TIME 9 5344
TEST_TIME 10 5198
TEST_TIME 11 5660
TEST_TIME 12 5711
TEST_TIME 13 5708
TEST_TIME 14 5867
TEST_TIME 15 6152
TEST_TIME 16 6320
TEST_TIME 17 6416
TEST_TIME 18 6951
TEST_TIME 19 7294
TEST_TIME 20 8263
TEST_TIME 21 8307
TEST_TIME 22 8768
TEST_TIME 23 9228
TEST_TIME 24 10285
TEST_TIME 25 10894
TEST_TIME 26 10560
TEST_TIME 27 10258
TEST_TIME 28 10232
TEST_TIME 29 10178
TEST_TIME 30 9957
TEST_TIME 31 9920
TEST_TIME 32 10002
TEST_TIME 33 9946
TEST_TIME 34 9917
TEST_TIME 35 9858
TEST_TIME 36 9609
TEST_TIME 37 9515
TEST_TIME 38 9390
TEST_TIME 39 9314
TEST_TIME 40 9370
TEST_TIME 41 9466
TEST_TIME 42 9351
TEST_TIME 43 9287
TEST_TIME 44 9506
TEST_TIME 45 9430
TEST_TIME 46 9446
TEST_TIME 47 9412
TEST_TIME 48 9378
TEST_TIME 49 9465
TEST_TIME 50 9398
TEST_TIME 51 9425
TEST_TIME 52 9505
TEST_TIME 53 9594
TEST_TIME 54 9499
TEST_TIME 55 9474
TEST_TIME 56 9415
TEST_TIME 57 9326
TEST_TIME 58 9378
TEST_TIME 59 9360
TEST_TIME 60 9263
TEST_TIME 61 9188
TEST_TIME 62 9244
TEST_TIME 63 9142
TEST_TIME 64 9099
TEST_TIME 65 9154
TEST_TIME 66 9124
TEST_TIME 67 9221
TEST_TIME 68 9263
TEST_TIME 69 9198
TEST_TIME 70 9320
TEST_TIME 71 9297
TEST_TIME 72 9295
TEST_TIME 73 9245
TEST_TIME 74 9340
TEST_TIME 75 9321
TEST_TIME 76 9368
TEST_TIME 77 9387
TEST_TIME 78 9335
TEST_TIME 79 9438
TEST_TIME 80 9372
TEST_TIME 81 9350
TEST_TIME 82 9310
TEST_TIME 83 9291
TEST_TIME 84 9274
TEST_TIME 85 9270
TEST_TIME 86 9251
TEST_TIME 87 9222
TEST_TIME 88 9169
TEST_TIME 89 9161
TEST_TIME 90 9134
TEST_TIME 91 9110
TEST_TIME 92 9149
TEST_TIME 93 9162
TEST_TIME 94 9211
TEST_TIME 95 9187
TEST_TIME 96 9240
TEST_TIME 97 9256
TEST_TIME 98 9269
TEST_TIME 99 9293
TEST_TIME 100 9354
TEST_TIME 101 9378
TEST_TIME 102 9422
TEST_TIME 103 9443
TEST_TIME 104 9410
TEST_TIME 105 9362
TEST_TIME 106 9359
TEST_TIME 107 9339
TEST_TIME 108 9307
TEST_TIME 109 9297
TEST_TIME 110 9261
TEST_TIME 111 9216
TEST_TIME 112 9209
TEST_TIME 113 9221
TEST_TIME 114 9219
TEST_TIME 115 9255
TEST_TIME 116 9244
TEST_TIME 117 9243
TEST_TIME 118 9235
TEST_TIME 119 9276
TEST_TIME 120 9216

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-01-2021 01:28:04 to 07-01-2021 01:28:07.

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 1518743 1518743 0 0.00 0 24688 7 0 0
doc_list_biud 1518742 1518742 0 0.00 0 46706 28 0 0
sp_add_invoice_to_stock 4962 4840 122 2.45 31 202690 18683 0 122
sp_cancel_adding_invoice 5912 5912 0 0.00 5 84070 748 0 0
sp_cancel_client_order 1751 1751 0 0.00 4 13313 336 0 0
sp_cancel_customer_reserve 573930 573930 0 0.00 1 46708 57 0 0
sp_cancel_pay_from_customer 644 644 0 0.00 2 4409 72 0 0
sp_cancel_pay_to_supplier 402 402 0 0.00 3 7931 106 0 0
sp_cancel_supplier_invoice 6446 6435 11 0.17 1 23268 860 0 11
sp_cancel_supplier_order 404 404 0 0.00 5 1177309 105058 0 0
sp_cancel_write_off 10291 10291 0 0.00 1 15109 116 0 0
sp_client_order 20398 20398 0 0.00 3 53572 351 0 0
sp_customer_reserve 445523 445523 0 0.00 0 54184 186 0 0
sp_fill_shopping_cart 31191 31191 0 0.00 1 14917 36 0 0
sp_fill_shopping_cart_clo_res 445512 445512 0 0.00 0 11896 14 0 0
sp_get_clo_for_invoice 4829 4829 0 0.00 0 23008 315 0 0
sp_kill_cost_storno 17249 17249 0 0.00 0 18193 55 0 0
sp_kill_qstorno_ret_qs2qd 1164990 1164990 0 0.00 0 46702 32 0 0
sp_kill_qty_storno 613304 613304 0 0.00 0 46705 69 0 0
sp_lock_selected_doc 20283 20283 0 0.00 0 10483 8 0 0
sp_make_cost_storno 27390 27390 0 0.00 0 13488 50 0 0
sp_multiply_rows_for_pdistr 27390 27390 0 0.00 0 18016 31 0 0
sp_multiply_rows_for_qdistr 20398 20398 0 0.00 0 46737 151 0 0
sp_pay_from_customer 7028 7028 0 0.00 3 33658 140 0 0
sp_pay_to_supplier 5781 5781 0 0.00 4 12487 116 0 0
sp_payment_common 12809 12809 0 0.00 1 33651 39 0 0
sp_qd_handle_on_cancel_clo 1751 1751 0 0.00 0 13305 302 0 0
sp_qd_handle_on_invoice_upd_sts 10741 10741 0 0.00 0 37489 339 0 0
sp_qd_handle_on_reserve_upd_sts 9752 9752 0 0.00 0 16989 69 0 0
sp_reserve_write_off 9752 9752 0 0.00 6 17731 194 0 0
sp_supplier_invoice 5398 5398 0 0.00 6 100415 3151 0 0
sp_supplier_order 5412 5412 0 0.00 4 50319 1291 0 0
srv_aggregate_perf_data 102 102 0 0.00 2843 222495 19786 0 0
srv_fill_mon_cache_memory 151 151 0 0.00 1546 131354 34553 0 0
srv_find_qd_qs_mism 1059107 1059107 0 0.00 0 24686 6 0 0
srv_make_invnt_saldo 560 560 0 0.00 30 46717 953 0 0
srv_make_money_saldo 765 765 0 0.00 1 5874 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 174226 499652 356121 0 0
t$perf-abend:sp_add_invoice_to_stock 122 122 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4840 4840 0 0.00 0 32699 180 0 0
t$perf-norm:sp_cancel_adding_invoice 430 430 0 0.00 0 2891 66 0 0
t$perf-norm:sp_cancel_client_order 1751 1751 0 0.00 0 2007 9 0 0
t$perf-norm:sp_cancel_customer_reserve 704 704 0 0.00 0 2195 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 644 644 0 0.00 0 2183 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 402 402 0 0.00 0 2183 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 366 366 0 0.00 0 2193 14 0 0
t$perf-norm:sp_cancel_supplier_order 404 404 0 0.00 0 38477 1477 0 0
t$perf-norm:sp_cancel_write_off 1006 1006 0 0.00 0 4247 21 0 0
t$perf-norm:sp_client_order 20398 20398 0 0.00 0 10516 18 0 0
t$perf-norm:sp_customer_reserve 947 947 0 0.00 0 1483 6 0 0
t$perf-norm:sp_pay_from_customer 7028 7028 0 0.00 0 6445 12 0 0
t$perf-norm:sp_pay_to_supplier 5781 5781 0 0.00 0 3987 9 0 0
t$perf-norm:sp_reserve_write_off 9752 9752 0 0.00 0 8493 11 0 0
t$perf-norm:sp_supplier_invoice 5398 5398 0 0.00 0 7757 20 0 0
t$perf-norm:sp_supplier_order 5412 5412 0 0.00 0 6449 15 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 115 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 151 151 0 0.00 0 28 1 0 0
t$perf-norm:srv_make_invnt_saldo 560 560 0 0.00 0 836 16 0 0
t$perf-norm:srv_make_money_saldo 765 765 0 0.00 0 7776 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 9894 9650 244 2.46 0 14082 22 0 244
v_all_customers 37220 37220 0 0.00 0 26 1 0 0
v_all_suppliers 30018 30018 0 0.00 0 21 1 0 0
v_all_wares 40790 40790 0 0.00 0 174 1 0 0
v_cancel_adding_invoice 860 860 0 0.00 0 705 6 0 0
v_cancel_client_order 3502 3502 0 0.00 0 3942 6 0 0
v_cancel_customer_prepayment 1288 1288 0 0.00 0 1937 5 0 0
v_cancel_customer_reserve 1408 1408 0 0.00 0 2191 7 0 0
v_cancel_payment_to_supplier 804 804 0 0.00 0 4321 19 0 0
v_cancel_supplier_invoice 754 732 22 2.91 0 1495 15 0 22
v_cancel_supplier_order 808 808 0 0.00 0 1872 8 0 0
v_cancel_write_off 2012 2012 0 0.00 0 4378 14 0 0
v_max_id_clo_ord 5411 5411 0 0.00 0 1940 1 0 0
v_max_id_clo_res 947 947 0 0.00 0 2212 13 0 0
v_max_id_ord_sup 5384 5384 0 0.00 0 2747 3 0 0
v_max_non_paid_invoice 1567 1567 0 0.00 0 3466 5 0 0
v_max_non_paid_realizn 3700 3700 0 0.00 0 3432 5 0 0
v_min_id_clo_ord 5411 5411 0 0.00 0 8204 9 0 0
v_min_id_clo_res 947 947 0 0.00 0 1804 7 0 0
v_min_id_ord_sup 5384 5384 0 0.00 0 8017 7 0 0
v_min_non_paid_invoice 5781 5781 0 0.00 0 9602 24 0 0
v_min_non_paid_realizn 7028 7028 0 0.00 0 10123 29 0 0
v_our_firm 10226 10226 0 0.00 0 13 1 0 0
v_reserve_write_off 19502 19502 0 0.00 0 9383 6 0 0
x_lock_depdocs_on_canc_invoice 11981 11981 0 0.00 0 21085 106 0 0
x_lock_depdocs_on_canc_sup_ord 404 404 0 0.00 0 13170 419 0 0
x_make_qstorno_1000_1200 5412 5412 0 0.00 2 50308 1207 0 0
x_make_qstorno_1200_2000 5398 5398 0 0.00 3 100390 3028 0 0
x_make_qstorno_2100_3300 445523 445523 0 0.00 0 54182 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-01-2021 01:28:08 to 07-01-2021 01:28:12.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:13 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:20 28251 8192000000 10305040048 10618400768 945381088 10.346 70 57 114 1 967172448 2779936 19011424
22:57:59 20663 8192000000 10354219824 10675662848 1414448976 14.723 100 82 164 0 1446294176 5183440 26661760
22:58:29 34983 8192000000 10412657968 10739412992 1453193120 15.066 100 87 175 0 1488303008 6702336 28407552
22:59:15 13564 8192000000 10428929936 10757758976 1480829584 15.309 100 92 184 0 1519041776 7731168 30481024
22:59:52 29356 8192000000 10453680000 10788732928 1501631424 15.490 100 89 178 1 1538565824 8329360 28605040
23:00:34 14943 8192000000 10473082128 10813882368 1530892512 15.745 100 91 182 1 1569200336 9276352 29031472
23:00:57 22841 8192000000 10497462976 10838917120 1544963472 15.866 100 84 168 0 1581417840 9664576 26789792
23:01:30 17366 8192000000 10505435760 10855047168 1564941904 16.039 100 90 180 1 1603821008 10463184 28415920
23:01:59 17626 8192000000 10539690672 10893914112 1586602048 16.225 100 74 148 1 1619553760 10125168 22826544
23:02:31 13445 8192000000 10580521424 10939908096 1631618688 16.609 100 72 144 0 1663247984 9883392 21745904
23:02:52 8760 8192000000 10585541296 10954207232 1657425232 16.827 100 84 168 0 1694066336 11034896 25606208
23:03:07 12992 8192000000 10613001856 10979962880 1676106464 16.985 100 74 148 3 1709454192 11273392 22074336
23:03:30 10259 8192000000 10621148640 10993717248 1694366272 17.138 100 80 160 0 1729463536 11531872 23565392
23:03:51 9834 8192000000 10653041904 11021463552 1712663200 17.291 100 82 164 3 1748895200 12326752 23905248
23:04:10 9609 8192000000 10659977824 11038089216 1727463616 17.414 100 81 162 2 1762772736 12031888 23277232
23:04:29 7430 8192000000 10684334688 11059859456 1739855200 17.517 100 83 165 3 1775690144 12259584 23575360
23:04:43 6311 8192000000 10690036496 11067670528 1753760048 17.633 100 83 164 1 1788336448 11617664 22958736
23:05:01 5290 8192000000 10694395520 11076472832 1759762976 17.682 100 74 148 0 1793756272 12448160 21545136
23:05:15 4615 8192000000 10712956720 11087896576 1769196944 17.760 100 80 161 1 1804030544 12204640 22628960
23:05:26 4590 8192000000 10715692304 11097300992 1777762672 17.831 100 73 147 0 1810030256 12206064 20061520
23:05:38 3677 8192000000 10726674528 11105509376 1785730320 17.897 100 85 171 1 1822751504 13158560 23862624
23:05:48 4245 8192000000 10716134976 11105873920 1788660096 17.921 100 78 156 1 1823086176 13360768 21065312
23:06:00 3740 8192000000 10747929472 11129372672 1798336784 18.000 100 85 171 0 1834936800 12208544 24391472
23:06:11 2417 8192000000 10740038784 11128115200 1808307840 18.082 100 89 178 1 1846279008 12617984 25353184
23:06:19 6624 8192000000 10745278768 11130970112 1807216352 18.073 100 64 128 2 1836360176 11470320 17673504
23:06:33 5195 8192000000 10756596320 11150237696 1816279824 18.147 100 75 150 0 1853279456 16396528 20603104
23:06:45 5229 8192000000 10775679696 11167272960 1832136160 18.277 100 83 165 2 1867234928 12023344 23075424
23:06:57 1830 8192000000 10778103856 11168055296 1837403424 18.320 100 87 173 0 1875518384 14056128 24058832
23:07:06 2051 8192000000 10793703728 11178389504 1844034816 18.374 100 89 179 1 1882683728 14112688 24536224
23:07:14 2189 8192000000 10788612016 11178815488 1843608688 18.370 100 84 168 0 1880400928 13737120 23055120
23:07:23 3257 8192000000 10782949600 11176116224 1850815904 18.429 100 86 174 0 1889653920 14937776 23900240
23:07:33 1770 8192000000 10800088752 11193462784 1859950000 18.503 100 90 180 1 1897367232 12859808 24557424
23:07:42 1736 8192000000 10799368048 11194101760 1862431024 18.523 100 87 174 0 1899524480 12682512 24410944
23:07:50 1495 8192000000 10820721360 11209039872 1872661088 18.606 100 93 184 2 1911471696 12056304 26754304
23:07:58 2636 8192000000 10821346016 11211378688 1875448320 18.628 100 92 183 2 1913479056 11936832 26093904
23:08:07 1884 8192000000 10824065616 11214770176 1881321792 18.676 100 94 189 1 1921490800 13177248 26991760
23:08:16 2007 8192000000 10822327072 11218649088 1878408816 18.652 100 93 185 0 1918236672 14453392 25374464
23:08:25 1404 8192000000 10831776432 11224027136 1879472128 18.661 100 92 183 0 1920076288 14884720 25719440
23:08:33 1752 8192000000 10844561328 11235708928 1885650848 18.711 100 86 170 1 1929230176 19535728 24043600
23:08:41 1374 8192000000 10837123584 11228119040 1887359680 18.724 100 98 196 2 1929490368 14604512 27526176
23:08:48 2586 8192000000 10812480464 11224293376 1881393504 18.676 100 66 133 1 1915988064 17038832 17555728
23:08:57 37381 8192000000 10782412672 11214442496 1879322736 18.660 100 32 64 1 1895626416 6587472 9716208
23:09:45 4298 8192000000 10797305632 11217960960 1881350528 18.676 100 28 55 1 1895843072 6654544 7838000
23:09:55 6350 8192000000 10796771312 11224993792 1886843920 18.720 100 30 60 0 1902914960 7043904 9027136
23:10:11 4942 8192000000 10793964224 11223801856 1889994096 18.746 100 31 62 2 1905016464 6624320 8398048
23:10:25 7038 8192000000 10812576176 11235045376 1894833104 18.785 100 42 84 3 1914371728 8224608 11314016
23:10:39 4814 8192000000 10801206640 11232182272 1891576256 18.758 100 26 52 1 1905868032 7400624 6891152
23:10:50 8123 8192000000 10804468064 11232976896 1893244960 18.772 100 20 40 1 1905114752 6360032 5509760
23:11:05 9591 8192000000 10795406224 11235688448 1896870944 18.801 100 29 56 0 1911052016 6874064 7307008
23:11:24 9927 8192000000 10811946224 11242000384 1901211168 18.836 100 20 40 2 1912352128 5570240 5570720
23:11:43 7834 8192000000 10812813984 11244605440 1902584448 18.847 100 24 48 0 1915659088 6254144 6820496
23:12:01 12229 8192000000 10814523616 11248128000 1904907216 18.866 100 20 40 0 1916604144 6531904 5165024
23:12:20 75415 8192000000 10848121248 11271950336 1912299376 18.925 100 48 95 0 1934663376 8925472 13438528
23:13:42 5695 8192000000 10832641184 11263639552 1913076656 18.931 100 45 90 0 1935626064 10224960 12324448
23:13:54 2691 8192000000 10844063024 11264020480 1913603984 18.936 100 35 71 2 1930704256 6451296 10648976
23:14:03 3598 8192000000 10833180256 11265306624 1913896480 18.938 100 27 54 0 1928873168 7349296 7627392
23:14:14 3305 8192000000 10845024064 11269795840 1922392944 19.006 100 45 90 0 1942951152 7463520 13094688
23:14:27 5589 8192000000 10840430640 11273318400 1915018416 18.947 100 21 43 2 1926720112 6058944 5642752
23:14:38 3204 8192000000 10855750240 11282087936 1923301152 19.013 100 50 98 1 1948879616 11252224 14326240
23:14:48 3558 8192000000 10841481776 11271733248 1922115648 19.004 100 31 63 2 1938233440 7153744 8964048
23:14:59 11351 8192000000 10826745264 11269201920 1897939984 18.810 99 20 38 4 1908439072 5541280 4957808
23:15:19 6479 8192000000 10824755472 11268612096 1915683264 18.952 100 27 54 0 1930527664 6808096 8036304
23:15:32 10657 8192000000 10829243904 11266879488 1918121264 18.972 100 22 44 0 1930705472 5940608 6643600
23:15:49 10010 8192000000 10825581568 11262418944 1912487344 18.927 100 28 56 3 1926861088 6049408 8324336
23:16:05 51073 8192000000 10837284016 11269128192 1918884368 18.978 100 46 92 1 1939022144 5749040 14388736
23:17:03 12322 8192000000 10825364672 11267883008 1917024736 18.963 100 35 70 3 1934122992 7678112 9420144
23:17:22 5467 8192000000 10824654464 11264811008 1899456496 18.822 99 33 66 0 1915028576 5883680 9688400
23:17:34 4548 8192000000 10825023120 11256586240 1895687360 18.792 99 41 82 0 1914359856 6824192 11848304
23:17:45 4937 8192000000 10826014208 11244544000 1863503408 18.532 98 39 78 0 1882381872 7472368 11406096
23:17:59 4278 8192000000 10792694576 11215167488 1859995984 18.503 99 50 102 0 1880582416 5738656 14847776
23:18:11 6339 8192000000 10763215184 11181379584 1819696848 18.175 98 35 69 1 1836301424 6306320 10298256
23:18:24 7218 8192000000 10747648720 11167686656 1798225376 17.999 98 15 30 0 1812334992 9603808 4505808
23:18:40 5422 8192000000 10710724544 11123822592 1724165424 17.387 94 25 48 1 1736503712 4862304 7475984
23:18:53 11470 8192000000 10697457216 11113693184 1699964832 17.185 94 20 40 2 1711568672 5667456 5936384
23:19:13 10657 8192000000 10727938592 11145666560 1803944048 18.046 100 17 34 0 1814492976 5632736 4916192
23:19:33 13166 8192000000 10701602432 11117150208 1668731888 16.923 92 15 30 1 1677793104 4858800 4202416
23:19:56 12466 8192000000 10705681136 11123179520 1763098656 17.710 98 22 44 2 1774972048 5672656 6200736
23:20:15 9905 8192000000 10722263744 11135201280 1761957520 17.701 97 22 45 0 1773498416 4985056 6555840
23:20:30 69829 8192000000 10715758704 11142074368 1732023264 17.452 95 20 40 0 1743373888 5508880 5841744
23:21:50 8242 8192000000 10724927216 11134230528 1771687024 17.781 98 28 56 0 1786098192 6417120 7994048
23:22:05 5962 8192000000 10728363424 11147067392 1812066672 18.113 100 36 72 0 1834266128 11265952 10933504
23:22:20 4385 8192000000 10759088832 11166863360 1823608080 18.207 100 51 102 1 1846454720 8893808 13952832
23:22:32 6121 8192000000 10745598400 11157041152 1824198384 18.212 100 21 42 1 1836642160 6457408 5986368
23:22:45 6718 8192000000 10743586928 11159068672 1824727216 18.216 100 27 50 0 1837616000 5439312 7449472
23:23:03 14876 8192000000 10733720704 11140304896 1789356752 17.926 98 20 40 0 1800754448 5661552 5736144
23:23:26 5342 8192000000 10718606208 11149934592 1805165792 18.056 99 26 50 1 1817764672 5313856 7285024
23:23:38 4621 8192000000 10736100752 11159183360 1825386224 18.222 100 35 69 4 1841731760 6806624 9538912
23:23:49 8602 8192000000 10754001536 11174092800 1835819488 18.307 100 31 62 0 1849873312 4660432 9393392
23:24:06 11689 8192000000 10746459168 11176759296 1838747040 18.331 100 13 26 1 1847447584 5256864 3443680
23:24:26 10889 8192000000 10769656160 11189735424 1846500560 18.394 100 23 46 0 1858198336 5241728 6456048
23:24:44 11101 8192000000 10766304800 11189903360 1849721472 18.420 100 24 48 2 1862527744 5684064 7122208
23:25:01 58072 8192000000 10790435760 11201892352 1858614240 18.492 100 43 85 2 1876163904 5461312 12088352
23:26:08 11480 8192000000 10766659008 11201638400 1859361856 18.498 100 18 34 1 1869243408 5128880 4752672
23:26:28 11084 8192000000 10774652608 11207163904 1864420000 18.539 100 23 44 3 1876249008 5454384 6374624
23:26:46 6414 8192000000 10787867520 11211210752 1867063216 18.561 100 35 70 1 1883943472 6528960 10351296
23:26:59 7226 8192000000 10794869488 11219988480 1877646544 18.646 100 28 56 0 1890167056 4907040 7613472
23:27:14 32072 8192000000 10833864384 11244654592 1894006688 18.778 100 52 104 2 1919993840 10576368 15410784
23:27:55 22183 8192000000 10831836864 11252719616 1903025376 18.851 100 49 97 1 1926869552 10040688 13803488
23:28:25 18617 8192000000 10851138240 11265466368 1912353184 18.926 100 44 88 2 1934489200 10001776 12134240
23:28:56 11277 8192000000 10868260816 11285385216 1924352752 19.022 100 53 107 3 1950858864 11439504 15066608
23:29:14 39344 8192000000 10868670624 11293089792 1929950096 19.066 100 44 88 1 1956905360 14706128 12249136
23:30:00 24683 8192000000 10886313200 11309920256 1945117264 19.188 100 45 90 3 1972175056 14084608 12973184
23:30:33 16707 8192000000 10880803120 11313135616 1949516176 19.223 100 46 92 0 1978734352 14903104 14315072
23:31:09 30968 8192000000 10885981232 11320885248 1956406784 19.277 100 27 51 0 1980586848 16079600 8100464
23:31:48 77990 8192000000 10912819328 11352244224 1964721776 19.344 100 33 66 1 1997707584 23579312 9406496
23:33:19 26512 8192000000 10921289984 11363094528 1976487968 19.437 100 28 56 0 2008713824 23875376 8350480
23:33:53 20385 8192000000 10932900048 11368361984 1983692800 19.494 100 46 91 0 2021949152 25155856 13100496
23:34:21 11549 8192000000 10925120672 11356442624 1963586448 19.335 99 45 90 0 2003617168 26974400 13056320
23:34:47 30847 8192000000 10940898112 11378417664 1981795504 19.479 100 41 82 0 2023012224 29028976 12187744
23:35:28 16662 8192000000 10947564256 11382272000 1994390416 19.578 100 47 94 2 2038704608 30190864 14123328
23:35:51 5957 8192000000 10972318112 11398737920 1998069984 19.608 100 54 105 1 2053344656 39653824 15620848
23:36:11 23759 8192000000 10959284144 11402371072 2002938480 19.646 100 43 86 1 2049839184 33953008 12947696
23:36:42 8302 8192000000 10971160912 11406417920 2014071008 19.734 100 50 100 3 2060228800 30704816 15452976
23:36:57 4736 8192000000 10977802608 11410108416 2016317472 19.751 100 49 98 0 2063436352 31967488 15151392
23:37:09 3891 8192000000 10970880480 11395190784 1979507056 19.461 98 68 131 4 2031912544 32680128 19725360
23:37:24 4273 8192000000 10981564608 11412180992 2012758560 19.723 100 69 136 1 2067674432 35025376 19890496
23:37:39 5771 8192000000 10994239632 11418939392 2017076496 19.757 100 70 140 1 2080693968 42557344 21060128
23:37:56 7998 8192000000 10985485472 11414228992 2012916560 19.724 100 68 136 0 2073319936 39394512 21008864
23:38:12 3067 8192000000 10979073296 11405365248 2004892192 19.661 100 69 138 1 2065628896 39083376 21653328
23:38:22 4281 8192000000 10979323728 11407917056 2006138448 19.671 100 66 132 1 2065947728 39786560 20022720
23:38:39 5352 8192000000 10979732384 11402936320 1991772864 19.558 99 78 154 0 2051701952 37369664 22559424
23:38:53 3613 8192000000 10962967024 11386593280 1990688192 19.549 100 73 144 3 2050755472 38563072 21504208
23:39:06 11420 8192000000 10977363520 11400347648 2001307616 19.633 100 65 131 1 2061126352 39570464 20248272
23:39:26 2144 8192000000 10993185072 11411066880 2009634544 19.699 100 71 143 0 2071719616 39453760 22631312
23:39:38 9018 8192000000 10975896816 11408404480 2005964608 19.670 100 65 130 0 2066393760 40216512 20212640
23:39:55 4625 8192000000 10977745968 11411869696 2005008432 19.662 100 51 102 0 2060815264 39965280 15841552
23:40:07 9055 8192000000 10977327296 11409190912 2004972576 19.662 100 67 133 4 2067207952 41235280 21000096
23:40:24 4378 8192000000 10973510288 11399909376 1988844992 19.535 99 77 153 2 2054943920 42183568 23915360
23:40:36 3346 8192000000 10977528960 11403911168 2000659536 19.628 100 73 146 1 2066293424 43042352 22591536
23:40:54 2367 8192000000 10991412816 11408613376 2002278848 19.641 100 70 137 1 2068505664 45696992 20529824
23:41:03 2016 8192000000 10972033760 11389407232 1973867584 19.416 99 75 149 0 2043497680 46869776 22760320
23:41:12 2701 8192000000 10975580976 11390771200 1981502736 19.477 99 75 146 0 2052024544 48394368 22127440
23:41:24 3269 8192000000 10994991168 11416838144 2005583696 19.667 100 83 167 1 2080518608 49077664 25857248
23:41:34 10760 8192000000 10988525376 11414061056 2003744464 19.652 100 82 163 0 2080111984 51070544 25296976
23:41:56 3933 8192000000 10973870960 11393867776 1970134688 19.387 98 74 146 1 2041770640 48481888 23154064
23:42:07 1883 8192000000 10970538800 11384168448 1975552048 19.429 99 80 160 1 2050385680 49044080 25789552
23:42:20 4407 8192000000 10992434640 11412758528 1993637472 19.573 100 80 160 1 2071287360 52589712 25060176
23:42:34 2618 8192000000 10966970368 11375566848 1958015296 19.290 99 86 169 2 2033383440 49167808 26200336
23:42:43 2482 8192000000 10977556208 11389861888 1980922352 19.472 100 87 172 2 2057327888 49207648 27197888
23:42:52 4516 8192000000 10972629920 11383644160 1978921616 19.456 100 87 172 1 2056258720 50547376 26789728
23:43:10 1544 8192000000 10989069248 11399323648 1991181696 19.553 100 82 159 1 2067029024 51224576 24622752
23:43:18 2434 8192000000 10975821328 11389337600 1981487584 19.476 100 79 158 0 2058460304 51850976 25121744
23:43:27 2591 8192000000 10964004976 11370643456 1962692208 19.327 99 84 166 0 2042420784 53068208 26660368
23:43:37 7128 8192000000 10973991808 11388788736 1982906560 19.488 100 79 157 1 2066502656 58441200 25154896
23:43:51 6380 8192000000 10971412352 11384692736 1973809776 19.416 100 78 154 3 2051495392 53561664 24123952
23:44:05 3208 8192000000 10975607664 11390832640 1964562048 19.342 99 80 159 0 2043791952 54160576 25069328
23:44:15 3130 8192000000 10988059552 11398930432 1984760576 19.502 100 80 160 0 2065256240 55037312 25458352
23:44:25 1963 8192000000 10990074176 11403968512 1993029968 19.568 100 83 166 0 2077396768 56430080 27936720
23:44:35 3520 8192000000 10998704032 11411750912 1996778144 19.597 100 86 170 1 2082052048 57792592 27481312
23:44:46 2825 8192000000 11002513184 11419914240 1997135104 19.600 100 87 174 2 2084465920 59697056 27633760
23:44:58 1963 8192000000 10996839136 11415773184 1998573440 19.611 100 84 165 3 2083264928 58311648 26379840
23:45:09 3576 8192000000 10994492480 11418386432 2000229664 19.625 100 64 126 0 2073199568 52922240 20047664
23:45:20 5494 8192000000 10992819072 11413143552 1984939024 19.504 99 76 152 2 2064958848 55467904 24551920
23:45:33 2966 8192000000 10998112224 11411505152 1994968544 19.583 100 84 168 1 2079251968 57891712 26391712
23:45:42 3326 8192000000 10959127216 11370897408 1955166976 19.268 98 79 155 4 2038242864 57775120 25300768
23:45:54 22373 8192000000 10951956256 11389550592 1953229360 19.252 99 42 84 1 2026269568 58144672 14895536
23:46:25 9241 8192000000 10950714896 11382935552 1962065904 19.322 100 49 96 2 2037332720 58689072 16577744
23:46:42 8359 8192000000 10945790112 11375079424 1949994240 19.226 99 54 106 1 2029632256 61559824 18078192
23:46:58 10836 8192000000 10946252608 11379458048 1940704368 19.152 99 47 94 0 2018975072 61834448 16436256
23:47:15 13456 8192000000 10952724848 11394924544 1963490080 19.334 100 37 74 0 2038038224 61465392 13082752
23:47:43 9785 8192000000 10937166352 11381972992 1962285360 19.324 100 33 66 2 2025253344 51416608 11551376
23:47:59 14443 8192000000 10954495088 11401375744 1970955472 19.393 100 37 74 0 2032307936 49186752 12165712
23:48:34 24186 8192000000 10946596272 11396644864 1969623536 19.382 100 35 70 1 2032437168 49492528 13321104
23:49:15 19782 8192000000 10936806048 11384205312 1945531776 19.191 99 38 76 2 2012628496 53355360 13741360
23:49:43 23924 8192000000 10917968192 11373715456 1920750848 18.993 98 33 66 2 1983824672 51027904 12045920
23:50:47 43576 8192000000 10874182752 11354021888 1889762768 18.744 98 18 36 1 1942778240 46420368 6595104
23:51:46 23914 8192000000 10832753792 11288141824 1890427520 18.749 100 17 33 0 1928800640 32367744 6005376
23:52:16 50438 8192000000 10849453632 11300728832 1878808832 18.655 98 14 27 0 1897547344 14640656 4097856
23:53:24 101450 8192000000 10857074512 11305934848 1882023328 18.681 97 41 82 2 1908475664 14712816 11739520
23:55:24 57743 8192000000 10862156960 11311063040 1913051904 18.931 99 32 65 0 1933315376 10337280 9926192
23:56:36 24587 8192000000 10844033056 11309973504 1905021568 18.867 99 36 72 0 1927448560 11688432 10738560
23:57:25 84979 8192000000 10857530336 11321303040 1912530368 18.927 99 14 28 0 1931194768 15138528 3525872
23:59:08 82744 8192000000 10854581536 11315830784 1895361264 18.789 98 18 37 1 1915526080 15159088 5005728
00:00:37 66531 8192000000 10845227808 11315273728 1891765920 18.760 98 11 22 0 1913094368 18243824 3084624
00:01:58 41682 8192000000 10849603744 11305541632 1900937024 18.834 99 13 26 0 1921453664 17117888 3398752
00:04:35 48867 8192000000 10873528736 11334627328 1923049504 19.011 99 15 30 0 1940741984 13342432 4350048
00:06:41 42374 8192000000 10880757360 11363360768 1956264784 19.276 100 16 34 0 1979235712 18482400 4488528
00:07:34 94626 8192000000 10889368320 11354488832 1939614608 19.144 99 12 24 1 1953173296 10327120 3231568
00:10:07 57012 8192000000 10902283968 11359076352 1952805968 19.249 99 30 60 1 1973399600 11789456 8804176
00:12:06 58347 8192000000 10904119856 11358691328 1931983248 19.083 98 31 60 1 1950745680 10681536 8080896
00:13:10 74064 8192000000 10915304368 11378556928 1959085552 19.299 99 22 44 0 1974626496 9663360 5877584
00:14:36 20769 8192000000 10906430208 11370455040 1963172656 19.331 99 26 52 1 1985136192 14543184 7420352
00:15:06 52994 8192000000 10907206960 11347054592 1916981472 18.963 97 26 52 2 1937587904 13485408 7121024
00:16:06 29293 8192000000 10885311520 11344035840 1931152080 19.076 98 33 66 4 1953330432 13152736 9025616
00:16:47 36387 8192000000 10902054848 11358199808 1964621328 19.343 100 26 52 0 1983687600 12052912 7013360
00:17:36 34986 8192000000 10925538352 11376443392 1977951024 19.448 100 30 60 1 2000356432 14233200 8172208
00:18:22 45677 8192000000 10921127392 11388772352 1980292592 19.467 100 19 38 1 2004644352 18920224 5431536
00:19:22 63322 8192000000 10928965120 11404730368 1988158736 19.529 100 18 36 1 2013904160 21208336 4537088
00:20:32 58251 8192000000 10920760896 11382689792 1953641440 19.255 98 12 24 3 1972662368 15768864 3252064
00:22:43 130829 8192000000 10931732960 11387703296 1966219728 19.355 99 28 55 2 1991865648 17621648 8024272
00:25:14 46611 8192000000 10890485408 11368488960 1941040704 19.155 98 19 38 0 1964366896 17465152 5861040
00:26:07 30396 8192000000 10905440288 11367665664 1971867520 19.400 100 24 48 0 1986351888 8213040 6271328
00:26:45 37136 8192000000 10899651808 11370635264 1963349424 19.333 99 7 14 1 1974370288 9061248 1959616
00:27:29 45448 8192000000 10901021744 11373776896 1967679872 19.367 99 14 28 1 1984958880 13154160 4124848
00:28:21 43107 8192000000 10912739744 11386621952 1964637568 19.343 99 9 18 0 1981298256 14218128 2442560
00:29:20 23315 8192000000 10901938576 11392045056 1980069616 19.465 100 13 26 2 2002625008 18894560 3660832
00:29:50 44859 8192000000 10896841152 11381121024 1961767952 19.320 99 12 24 1 1980488944 15775136 2945856
00:31:28 57625 8192000000 10895945696 11371532288 1919895744 18.986 97 9 18 0 1941233712 19060688 2277280
00:32:32 57059 8192000000 10902018240 11366141952 1928853520 19.058 98 7 14 0 1943013280 12576320 1583440
00:33:38 64381 8192000000 10886126992 11346165760 1874176176 18.618 95 26 52 1 1897326432 15628032 7522224
00:34:54 67324 8192000000 10866578064 11334516736 1883937392 18.697 96 13 27 1 1900827376 13627600 3262384
00:36:12 21877 8192000000 10892768304 11347345408 1955180000 19.268 100 34 68 1 1973777584 9190096 9407488
00:36:45 77758 8192000000 10855066192 11334422528 1851484864 18.434 94 33 66 0 1871087680 10231104 9371712
00:38:16 95643 8192000000 10842742688 11303313408 1772094256 17.784 91 12 24 0 1784098224 8994416 3009552
00:39:58 47488 8192000000 10894819232 11345469440 1933456512 19.095 99 34 69 3 1953046816 10378000 9212304
00:40:56 45835 8192000000 10870574976 11332866048 1880251328 18.667 96 25 50 0 1907879520 20161600 7466592
00:41:50 115248 8192000000 10882458592 11327500288 1824349088 18.213 94 18 36 0 1839435984 10561264 4525632
00:43:53 64523 8192000000 10904679344 11355480064 1958330848 19.293 100 21 42 1 1974510832 9487632 6692352
00:45:05 51831 8192000000 10905464560 11351494656 1901025600 18.835 97 29 58 0 1922060688 13161056 7874032
00:46:05 37004 8192000000 10891705616 11357966336 1931466656 19.079 99 23 46 2 1954526640 15916512 7143472
00:47:42 96583 8192000000 10879859408 11333799936 1894611984 18.783 97 34 68 2 1912217152 7735888 9869280
00:49:25 78231 8192000000 10894508720 11356647424 1958341840 19.293 100 34 68 0 1986950688 18923520 9685328
00:50:50 28354 8192000000 10886630752 11356336128 1957734480 19.288 100 27 54 4 1980511632 15267776 7509376
00:51:29 39001 8192000000 10873814688 11341512704 1946593216 19.199 100 18 35 0 1963510880 11701312 5216352
00:52:15 66697 8192000000 10864882448 11349409792 1935517088 19.111 99 8 16 0 1948692496 10723136 2452272
00:53:28 42929 8192000000 10866727472 11327897600 1897849216 18.809 97 7 14 0 1906981584 7184928 1947440
00:54:21 56669 8192000000 10867004768 11335778304 1909386464 18.902 98 10 20 0 1921672640 9482080 2804096
00:55:23 39862 8192000000 10887959616 11345981440 1952907792 19.250 100 16 32 0 1967606416 9778720 4919904
00:56:22 74865 8192000000 10860442480 11333697536 1925336640 19.030 99 16 32 0 1939733360 10177088 4219632
00:57:47 79021 8192000000 10902619216 11364229120 1965869344 19.353 100 15 30 1 1978869120 9267104 3732672
00:59:13 33376 8192000000 10878516672 11342057472 1882628896 18.686 96 16 32 0 1895896320 9154064 4113360
00:59:58 110184 8192000000 10887705280 11361832960 1904657392 18.864 97 10 20 0 1917283776 9755456 2870928
01:02:05 43261 8192000000 10893126480 11340468224 1885655952 18.711 96 29 58 0 1905982576 11972864 8353760
01:02:55 29788 8192000000 10891011984 11345276928 1936634016 19.120 99 37 74 0 1964060208 16929968 10496224
01:03:43 43954 8192000000 10868739744 11335958528 1908706960 18.896 98 13 26 1 1929093200 16587056 3799184
01:04:56 25843 8192000000 10901776624 11350888448 1954410944 19.262 100 34 65 1 1977053216 12481776 10160496
01:05:28 28338 8192000000 10908761504 11370033152 1967248032 19.364 100 38 76 1 1997469360 19519200 10702128
01:06:47 38197 8192000000 10913017840 11375525888 1954231344 19.260 99 35 68 2 1976944992 12986896 9726752
01:07:32 41309 8192000000 10898690992 11364593664 1947864960 19.209 99 27 55 2 1969717520 13979536 7873024
01:08:20 72420 8192000000 10888407360 11360976896 1932338560 19.086 98 24 48 0 1950904352 11877904 6687888
01:09:39 70234 8192000000 10904340192 11378221056 1972315360 19.404 100 9 18 0 1986810048 11810032 2684656
01:10:59 47755 8192000000 10934117008 11383250944 1982545040 19.485 100 24 48 2 2000791632 11352400 6894192
01:11:59 131354 8192000000 10884053920 11360010240 1940417360 19.150 98 24 48 3 1957642464 9668784 7556320
01:14:17 48278 8192000000 10905389536 11380305920 1975847936 19.432 100 19 38 1 1994390864 13212224 5330704
01:15:11 12816 8192000000 10899162608 11379470336 1976172944 19.434 100 8 16 0 1989286800 11036112 2077744
01:15:30 18882 8192000000 10891117664 11364995072 1964307824 19.340 99 22 44 0 1980275584 8765072 7202688
01:16:00 43740 8192000000 10841198416 11317473280 1895297856 18.788 97 9 18 0 1905380240 7613024 2469360
01:17:05 71979 8192000000 10879742400 11351826432 1922792912 19.009 98 10 20 0 1934886656 9239936 2853808
01:18:30 63896 8192000000 10862077904 11338584064 1941573568 19.159 99 12 24 1 1956340976 11153216 3614192
01:19:54 72367 8192000000 10890536416 11372220416 1963686272 19.335 100 6 12 0 1977191072 11747952 1756848
01:21:14 65037 8192000000 10863966176 11337711616 1901964608 18.842 97 20 40 2 1917380784 9606368 5809808
01:22:27 48409 8192000000 10866746128 11340742656 1928480032 19.055 99 10 20 1 1941960096 10312688 3167376
01:23:23 72694 8192000000 10859161104 11319230464 1857889888 18.486 95 20 40 0 1870989648 7597552 5502208
01:24:46 38211 8192000000 10863878160 11314909184 1885145760 18.707 97 44 87 5 1910420912 12772768 12502384
01:25:30 25463 8192000000 10872743744 11323445248 1898803280 18.817 98 38 74 0 1918229712 9253152 10173280
01:26:05 38435 8192000000 10861620896 11318738944 1916299440 18.957 99 33 66 3 1936483888 11178864 9005584
01:26:51 24867 8192000000 9117758112 9347297280 281754816 3.325 15 1 2 0 284119504 2302560 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 07-01-2021 01:28:14 to 07-01-2021 01:28:44.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 122 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-01-2021 01:28:45 to 07-01-2021 01:28:47.

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          238724
MON$OLDEST_ACTIVE               238725
MON$OLDEST_SNAPSHOT             238725
MON$NEXT_TRANSACTION            238725
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                       2003008
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'

07.01.21 01:28:48. 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-07 01:28:51 No severe PSQL-related problems occured
07.01.21 01:28:52. End of report.