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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17137400 kB
MemAvailable 31303708 kB
Buffers 0 kB
Cached 14537792 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-19 22:27:10
DTS_END                         2021-01-19 22:27:10.8690
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46752
TRN_ID                          246466
ATT_ID                          700
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: 9418.06 22451 1130167
customer order: creation 174.68 336 20962
customer order: refuse 15.48 345 1858
order to supplier: creation 47.92 1207 5750
order to supplier: removal 3.66 94362 439
invoice (draft): creation 47.77 3191 5732
invoice (draft): removal 53.31 800 6397
invoice accept: apply 42.47 17581 5096
invoice accept: cancel 48.36 759 5803
customer reserve: creation 3900.78 176 468093
customer reserve: removal 4788.31 56 574597
realization accept: apply 86.18 183 10341
realization accept: cancel 74.41 98 8929
payment from customer: creation 61.54 110 7385
payment from customer: removal 6.18 84 741
payment to supplier: creation 50.78 116 6094
payment to supplier: removal 3.59 80 431
service: total inventory turnovers 4.81 1051 577
service: total monetary turnovers 7.05 21 846
service: aggregate perf. data 0.77 23907 92
service: refresh index statistics 0.03 304547 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-01-2021 22:29:02 to 19-01-2021 22:29:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3929
TEST_TIME 2 5611
TEST_TIME 3 4832
TEST_TIME 4 4686
TEST_TIME 5 5127
TEST_TIME 6 5300
TEST_TIME 7 5579
TEST_TIME 8 5696
TEST_TIME 9 5986
TEST_TIME 10 5953
TEST_TIME 11 5975
TEST_TIME 12 5884
TEST_TIME 13 5870
TEST_TIME 14 6355
TEST_TIME 15 6613
TEST_TIME 16 6785
TEST_TIME 17 6874
TEST_TIME 18 7116
TEST_TIME 19 7560
TEST_TIME 20 7788
TEST_TIME 21 8049
TEST_TIME 22 8306
TEST_TIME 23 8535
TEST_TIME 24 9046
TEST_TIME 25 9362
TEST_TIME 26 10076
TEST_TIME 27 10333
TEST_TIME 28 10509
TEST_TIME 29 10526
TEST_TIME 30 10494
TEST_TIME 31 10497
TEST_TIME 32 10492
TEST_TIME 33 10390
TEST_TIME 34 10462
TEST_TIME 35 10446
TEST_TIME 36 10344
TEST_TIME 37 10117
TEST_TIME 38 9936
TEST_TIME 39 10065
TEST_TIME 40 10014
TEST_TIME 41 9895
TEST_TIME 42 9874
TEST_TIME 43 9846
TEST_TIME 44 9916
TEST_TIME 45 9808
TEST_TIME 46 9689
TEST_TIME 47 9639
TEST_TIME 48 9594
TEST_TIME 49 9472
TEST_TIME 50 9539
TEST_TIME 51 9563
TEST_TIME 52 9405
TEST_TIME 53 9449
TEST_TIME 54 9523
TEST_TIME 55 9541
TEST_TIME 56 9557
TEST_TIME 57 9562
TEST_TIME 58 9489
TEST_TIME 59 9469
TEST_TIME 60 9587
TEST_TIME 61 9637
TEST_TIME 62 9625
TEST_TIME 63 9612
TEST_TIME 64 9760
TEST_TIME 65 9755
TEST_TIME 66 9689
TEST_TIME 67 9762
TEST_TIME 68 9855
TEST_TIME 69 9771
TEST_TIME 70 9672
TEST_TIME 71 9717
TEST_TIME 72 9688
TEST_TIME 73 9649
TEST_TIME 74 9595
TEST_TIME 75 9531
TEST_TIME 76 9474
TEST_TIME 77 9455
TEST_TIME 78 9421
TEST_TIME 79 9396
TEST_TIME 80 9355
TEST_TIME 81 9358
TEST_TIME 82 9326
TEST_TIME 83 9341
TEST_TIME 84 9287
TEST_TIME 85 9273
TEST_TIME 86 9300
TEST_TIME 87 9259
TEST_TIME 88 9323
TEST_TIME 89 9324
TEST_TIME 90 9401
TEST_TIME 91 9463
TEST_TIME 92 9529
TEST_TIME 93 9483
TEST_TIME 94 9556
TEST_TIME 95 9558
TEST_TIME 96 9563
TEST_TIME 97 9575
TEST_TIME 98 9520
TEST_TIME 99 9472
TEST_TIME 100 9435
TEST_TIME 101 9434
TEST_TIME 102 9423
TEST_TIME 103 9388
TEST_TIME 104 9406
TEST_TIME 105 9364
TEST_TIME 106 9345
TEST_TIME 107 9330
TEST_TIME 108 9344
TEST_TIME 109 9307
TEST_TIME 110 9334
TEST_TIME 111 9435
TEST_TIME 112 9416
TEST_TIME 113 9412
TEST_TIME 114 9395
TEST_TIME 115 9419
TEST_TIME 116 9407
TEST_TIME 117 9412
TEST_TIME 118 9490
TEST_TIME 119 9498
TEST_TIME 120 9421

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-01-2021 22:29:06 to 19-01-2021 22:29:09.

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 1563530 1563530 0 0.00 0 26411 6 0 0
doc_list_biud 1563527 1563527 0 0.00 0 72322 26 0 0
sp_add_invoice_to_stock 5218 5096 122 2.33 36 174751 17581 0 122
sp_cancel_adding_invoice 5803 5803 0 0.00 5 78179 760 0 0
sp_cancel_client_order 1858 1858 0 0.00 3 14890 346 0 0
sp_cancel_customer_reserve 574597 574597 0 0.00 1 53596 56 0 0
sp_cancel_pay_from_customer 741 741 0 0.00 3 8392 85 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 3 7005 80 0 0
sp_cancel_supplier_invoice 6411 6397 14 0.21 2 72330 800 0 14
sp_cancel_supplier_order 439 439 0 0.00 5 967132 94363 0 0
sp_cancel_write_off 8929 8929 0 0.00 1 10875 98 0 0
sp_client_order 20962 20962 0 0.00 3 22750 337 0 0
sp_customer_reserve 468093 468093 0 0.00 0 39020 176 0 0
sp_fill_shopping_cart 32435 32435 0 0.00 1 13482 43 0 0
sp_fill_shopping_cart_clo_res 468088 468088 0 0.00 0 15513 12 0 0
sp_get_clo_for_invoice 5091 5091 0 0.00 0 25796 304 0 0
sp_kill_cost_storno 15904 15904 0 0.00 0 10371 53 0 0
sp_kill_qstorno_ret_qs2qd 1164959 1164959 0 0.00 0 72320 31 0 0
sp_kill_qty_storno 613454 613454 0 0.00 0 72321 67 0 0
sp_lock_selected_doc 21460 21460 0 0.00 0 7390 6 0 0
sp_make_cost_storno 28910 28910 0 0.00 0 12584 54 0 0
sp_multiply_rows_for_pdistr 28910 28910 0 0.00 0 8015 27 0 0
sp_multiply_rows_for_qdistr 20962 20962 0 0.00 0 10951 156 0 0
sp_pay_from_customer 7385 7385 0 0.00 4 10087 111 0 0
sp_pay_to_supplier 6094 6094 0 0.00 5 12589 116 0 0
sp_payment_common 13476 13476 0 0.00 1 10078 28 0 0
sp_qd_handle_on_cancel_clo 1858 1858 0 0.00 0 14882 315 0 0
sp_qd_handle_on_invoice_upd_sts 10893 10893 0 0.00 0 26333 328 0 0
sp_qd_handle_on_reserve_upd_sts 10341 10341 0 0.00 0 19704 63 0 0
sp_reserve_write_off 10341 10341 0 0.00 6 19912 184 0 0
sp_supplier_invoice 5732 5732 0 0.00 6 75115 3192 0 0
sp_supplier_order 5750 5750 0 0.00 6 35459 1207 0 0
srv_aggregate_perf_data 92 92 0 0.00 2647 810940 23907 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1141 126938 32226 0 0
srv_find_qd_qs_mism 1081171 1081171 0 0.00 0 26409 6 0 0
srv_make_invnt_saldo 577 577 0 0.00 37 37760 1052 0 0
srv_make_money_saldo 846 846 0 0.00 1 530 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 170410 393214 304547 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 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5096 5096 0 0.00 0 8748 189 0 0
t$perf-norm:sp_cancel_adding_invoice 436 436 0 0.00 0 5697 82 0 0
t$perf-norm:sp_cancel_client_order 1858 1858 0 0.00 0 4635 23 0 0
t$perf-norm:sp_cancel_customer_reserve 731 731 0 0.00 0 1899 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 741 741 0 0.00 0 1820 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 1313 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 4016 22 0 0
t$perf-norm:sp_cancel_supplier_order 439 439 0 0.00 0 20480 1481 0 0
t$perf-norm:sp_cancel_write_off 980 980 0 0.00 0 3024 10 0 0
t$perf-norm:sp_client_order 20962 20962 0 0.00 0 14165 16 0 0
t$perf-norm:sp_customer_reserve 1041 1041 0 0.00 0 2762 11 0 0
t$perf-norm:sp_pay_from_customer 7385 7385 0 0.00 0 3865 9 0 0
t$perf-norm:sp_pay_to_supplier 6094 6094 0 0.00 0 4940 9 0 0
t$perf-norm:sp_reserve_write_off 10341 10341 0 0.00 0 7718 12 0 0
t$perf-norm:sp_supplier_invoice 5732 5732 0 0.00 0 7065 20 0 0
t$perf-norm:sp_supplier_order 5750 5750 0 0.00 0 7814 20 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 47 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 373 5 0 0
t$perf-norm:srv_make_invnt_saldo 577 577 0 0.00 0 1883 28 0 0
t$perf-norm:srv_make_money_saldo 846 846 0 0.00 0 1276 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 2 0 0
v_add_invoice_to_stock 10424 10180 244 2.34 0 5811 21 0 244
v_all_customers 38042 38042 0 0.00 0 84 1 0 0
v_all_suppliers 32268 32268 0 0.00 0 84 1 0 0
v_all_wares 41924 41924 0 0.00 0 82 1 0 0
v_cancel_adding_invoice 872 872 0 0.00 0 5315 14 0 0
v_cancel_client_order 3716 3716 0 0.00 0 2909 5 0 0
v_cancel_customer_prepayment 1482 1482 0 0.00 0 3278 11 0 0
v_cancel_customer_reserve 1462 1462 0 0.00 0 1447 5 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 3107 13 0 0
v_cancel_supplier_invoice 854 826 28 3.27 0 3693 21 0 28
v_cancel_supplier_order 878 878 0 0.00 0 651 3 0 0
v_cancel_write_off 1960 1960 0 0.00 0 2445 12 0 0
v_max_id_clo_ord 5749 5749 0 0.00 0 304 1 0 0
v_max_id_clo_res 1041 1041 0 0.00 0 2988 21 0 0
v_max_id_ord_sup 5723 5723 0 0.00 0 8522 7 0 0
v_max_non_paid_invoice 1429 1429 0 0.00 0 135 2 0 0
v_max_non_paid_realizn 4046 4046 0 0.00 0 2381 4 0 0
v_min_id_clo_ord 5749 5749 0 0.00 0 3638 9 0 0
v_min_id_clo_res 1041 1041 0 0.00 0 5931 15 0 0
v_min_id_ord_sup 5723 5723 0 0.00 0 10674 13 0 0
v_min_non_paid_invoice 6091 6091 0 0.00 0 7492 17 0 0
v_min_non_paid_realizn 7385 7385 0 0.00 0 7887 20 0 0
v_our_firm 10560 10560 0 0.00 0 85 1 0 0
v_reserve_write_off 20682 20682 0 0.00 0 4051 5 0 0
x_lock_depdocs_on_canc_invoice 11787 11787 0 0.00 0 18475 104 0 0
x_lock_depdocs_on_canc_sup_ord 439 439 0 0.00 0 16295 357 0 0
x_make_qstorno_1000_1200 5750 5750 0 0.00 1 35443 1110 0 0
x_make_qstorno_1200_2000 5732 5732 0 0.00 3 75096 3047 0 0
x_make_qstorno_2100_3300 468093 468093 0 0.00 0 38996 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-01-2021 22:29:10 to 19-01-2021 22:29:14.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:20 22778 8192000000 10267938496 10576687104 909950768 9.997 70 54 108 0 929745024 2428432 17365824
19:57:53 22149 8192000000 10324576768 10640547840 1372539040 14.350 100 81 162 0 1403860464 4897600 26423824
19:58:24 17705 8192000000 10358491824 10679644160 1420138128 14.774 100 90 180 0 1456542784 6501824 29902832
19:58:58 26989 8192000000 10402403888 10729533440 1453497744 15.069 100 87 174 0 1489353824 7407760 28448320
19:59:38 23494 8192000000 10428136976 10758578176 1479200880 15.294 100 85 170 1 1514701376 8105536 27394960
20:00:08 13289 8192000000 10444342256 10775437312 1492558176 15.411 100 88 176 0 1529357920 8399584 28400160
20:00:35 19913 8192000000 10455715392 10790330368 1506737392 15.535 100 85 170 1 1543058016 8775248 27545376
20:01:05 21733 8192000000 10470484832 10811355136 1533912816 15.771 100 86 172 1 1571311408 9774672 27623920
20:01:39 18479 8192000000 10496416608 10844614656 1554562656 15.949 100 76 151 0 1587795824 9898576 23334592
20:02:08 14157 8192000000 10521503664 10874339328 1579829552 16.167 100 78 153 2 1613887296 10096704 23961040
20:02:31 13372 8192000000 10547740384 10902781952 1602349888 16.359 100 79 158 0 1637328768 10624848 24354032
20:02:57 11527 8192000000 10564569984 10926960640 1627209568 16.571 100 78 156 0 1662513280 11866320 23437392
20:03:15 11299 8192000000 10602075664 10964348928 1655077072 16.807 100 83 166 1 1691507392 11696752 24733568
20:03:35 10537 8192000000 10608366208 10973085696 1669660128 16.930 100 83 166 1 1706486240 12000688 24825424
20:03:55 7183 8192000000 10624201152 10994671616 1683029264 17.043 100 76 150 2 1716581648 12021968 21530416
20:04:10 10101 8192000000 10646854144 11015491584 1703268560 17.212 100 83 165 1 1740086128 13086208 23731360
20:04:26 7279 8192000000 10651707488 11025022976 1711241584 17.279 100 80 160 0 1747312832 12832576 23238672
20:04:42 9218 8192000000 10671619776 11048439808 1740817184 17.525 100 86 172 0 1778112176 12985024 24309968
20:04:58 4730 8192000000 10686937216 11058851840 1748602384 17.590 100 87 174 0 1786321568 12970704 24748480
20:05:10 5345 8192000000 10701378144 11077513216 1760623168 17.690 100 82 165 1 1797914912 13259712 24032032
20:05:22 5675 8192000000 10715843232 11092197376 1770695040 17.773 100 80 160 0 1806562080 12552544 23314496
20:05:34 5661 8192000000 10716657296 11096891392 1776954416 17.824 100 87 174 2 1814987488 14077952 23955120
20:05:48 4610 8192000000 10720793584 11104235520 1783229216 17.876 100 83 165 1 1820216832 14147904 22839712
20:06:00 4149 8192000000 10725535392 11107708928 1789138464 17.925 100 83 166 1 1826009600 13192800 23678336
20:06:11 2737 8192000000 10733240576 11115151360 1797261952 17.991 100 86 172 2 1834526752 12441408 24823392
20:06:21 3662 8192000000 10741290032 11126734848 1805339952 18.058 100 80 152 1 1837776896 11043248 21393696
20:06:31 7662 8192000000 10744533408 11132399616 1810516640 18.100 100 79 159 2 1845302720 11812384 22973696
20:06:46 6522 8192000000 10761942208 11151138816 1815509904 18.141 100 77 154 0 1849048416 12034096 21504416
20:07:00 2622 8192000000 10775527392 11160018944 1832115744 18.277 100 89 177 0 1870534192 13437104 24981344
20:07:09 1830 8192000000 10783779808 11167940608 1843298608 18.368 100 92 184 1 1882505872 13197392 26009872
20:07:17 2010 8192000000 10790070640 11177611264 1850818720 18.429 100 94 188 0 1890632800 13346832 26467248
20:07:25 2086 8192000000 10801364288 11190968320 1857312128 18.481 100 93 183 2 1895969088 12387120 26269840
20:07:34 1597 8192000000 10800184512 11188658176 1863628752 18.533 100 86 171 0 1900160880 12534496 23997632
20:07:43 1270 8192000000 10811503696 11200122880 1866711376 18.558 100 94 190 0 1906983376 13921152 26350848
20:07:50 2649 8192000000 10816916080 11206504448 1872176016 18.602 100 95 188 2 1910827520 12525408 26126096
20:07:59 1405 8192000000 10821382176 11212951552 1875576416 18.629 100 91 180 0 1915683216 14972896 25133904
20:08:07 2318 8192000000 10822621648 11211444224 1878313088 18.651 100 93 187 5 1918041552 12523648 27204816
20:08:15 6665 8192000000 10810778544 11207659520 1874823776 18.623 100 70 141 1 1906610432 11607536 20179120
20:08:28 2079 8192000000 10809300752 11216031744 1877439776 18.644 100 73 146 0 1911186144 13431664 20314704
20:08:39 1583 8192000000 10814794448 11214929920 1878475136 18.653 100 74 148 1 1912876624 13485264 20916224
20:08:51 3896 8192000000 10804145296 11214610432 1877910160 18.648 100 58 116 0 1905177312 11143136 16124016
20:09:01 4111 8192000000 10785280976 11209175040 1876841008 18.640 100 42 84 1 1897833392 9678224 11314160
20:09:12 14717 8192000000 10781844288 11211694080 1881796096 18.680 100 34 68 0 1897918464 6190480 9931888
20:09:36 57792 8192000000 10788589696 11221430272 1880266576 18.667 100 35 70 0 1896670496 6524544 9879376
20:10:46 4377 8192000000 10788437376 11225116672 1880891168 18.672 100 21 42 0 1893279024 6884144 5503712
20:11:00 2805 8192000000 10806721104 11232231424 1888554576 18.734 100 41 83 2 1907820576 7248656 12017344
20:11:09 4291 8192000000 10802339760 11234693120 1888629712 18.735 100 37 74 2 1907231968 8387584 10214672
20:11:19 4208 8192000000 10808771936 11233067008 1891464336 18.758 100 40 80 2 1909797744 7184592 11148816
20:11:31 7454 8192000000 10814163280 11241099264 1890299520 18.748 100 26 52 1 1903816032 6288960 7227552
20:11:44 5909 8192000000 10802566048 11239141376 1895398272 18.789 100 30 61 0 1910435952 6492416 8545264
20:11:57 5686 8192000000 10818180624 11250884608 1896116656 18.795 100 34 68 1 1915525552 9922064 9486832
20:12:09 8075 8192000000 10806344032 11245404160 1895739760 18.792 100 24 49 2 1909021840 6590448 6691632
20:12:24 6459 8192000000 10805993696 11243085824 1898436512 18.814 100 26 52 1 1916971136 10814064 7720560
20:12:37 5745 8192000000 10815611232 11245182976 1897574480 18.807 100 19 38 1 1908734624 5629984 5530160
20:12:52 13814 8192000000 10815276752 11249704960 1899608288 18.823 100 23 46 0 1912113744 5539632 6965824
20:13:12 9351 8192000000 10813632848 11252232192 1903937920 18.858 100 16 32 2 1913283776 5106304 4239552
20:13:28 11853 8192000000 10820309392 11256532992 1909051152 18.899 100 18 36 0 1919866416 5681152 5134112
20:13:46 13497 8192000000 10824449392 11260129280 1908353088 18.893 100 25 50 2 1922955760 6432384 8170288
20:14:05 56475 8192000000 10831275840 11266600960 1914300432 18.941 100 41 81 2 1932602928 6837872 11464624
20:15:10 12152 8192000000 10823419680 11261591552 1910332704 18.909 100 19 38 1 1921646064 5172864 6140496
20:15:29 7694 8192000000 10821045472 11255517184 1895454848 18.790 99 31 62 0 1911868512 7071008 9342656
20:15:43 5327 8192000000 10820161280 11247960064 1902924384 18.850 100 40 80 1 1921787840 7315376 11548080
20:15:55 4673 8192000000 10821584992 11255562240 1909616320 18.904 100 40 81 2 1927704256 6406400 11681536
20:16:06 5639 8192000000 10825425680 11259379712 1910090992 18.907 100 34 65 2 1926327008 7066656 9169360
20:16:21 6989 8192000000 10813797888 11251671040 1886412144 18.717 99 22 44 1 1899575856 6374048 6789664
20:16:36 7318 8192000000 10798779056 11231342592 1865303840 18.546 98 19 38 0 1876723104 5956464 5462800
20:16:51 11587 8192000000 10777683152 11207462912 1817117952 18.154 96 16 31 3 1828671328 5240416 6312960
20:17:11 8045 8192000000 10767845040 11188174848 1802760400 18.037 97 18 36 3 1812666976 5234512 4672064
20:17:25 8560 8192000000 10744690880 11174567936 1799463264 18.010 98 11 22 0 1811773376 9301536 3008576
20:17:40 9102 8192000000 10750679280 11180617728 1823066544 18.203 99 20 40 1 1834649488 5728112 5854832
20:18:00 9517 8192000000 10759780768 11187281920 1826021264 18.227 99 21 42 1 1841534160 8920992 6591904
20:18:15 11652 8192000000 10744757760 11176898560 1786103104 17.900 96 24 47 2 1799197024 5754976 7338944
20:18:35 6863 8192000000 10715168528 11131236352 1719240272 17.346 94 15 30 4 1728413856 5292688 3880896
20:18:52 54367 8192000000 10701461056 11111387136 1695376144 17.146 93 30 58 1 1709032224 5101312 8554768
20:20:01 11823 8192000000 10697630624 11116564480 1698483648 17.172 94 25 50 0 1711452448 6372176 6596624
20:20:19 7931 8192000000 10686219472 11094548480 1687867232 17.083 94 28 58 1 1702584624 6961072 7756320
20:20:35 4375 8192000000 10680524400 11094601728 1748747200 17.591 98 28 56 4 1762953136 5563504 8642432
20:20:46 8762 8192000000 10726895376 11137564672 1768843824 17.757 98 25 50 0 1781923536 5534192 7545520
20:21:01 8000 8192000000 10703004928 11116937216 1735844080 17.484 96 36 73 3 1752783872 6325568 10614224
20:21:18 11064 8192000000 10727491664 11145490432 1796672864 17.987 99 23 46 0 1812973360 9623728 6676768
20:21:37 8119 8192000000 10700273552 11108835328 1737024320 17.494 96 24 48 1 1750807472 6526528 7256624
20:21:51 8595 8192000000 10719166624 11133628416 1768059408 17.751 98 20 40 0 1779150640 5192384 5898848
20:22:09 7669 8192000000 10736993600 11151036416 1798725424 18.003 99 30 60 4 1813015296 5461232 8828640
20:22:26 7627 8192000000 10743902400 11162079232 1821382016 18.189 100 22 44 1 1833129616 5040144 6707456
20:22:44 9011 8192000000 10738440000 11160211456 1809742432 18.094 99 23 47 2 1821569376 5504080 6322864
20:23:00 11155 8192000000 10740946528 11173924864 1821161360 18.187 99 17 33 3 1831606736 5163392 5281984
20:23:18 8043 8192000000 10764657312 11188572160 1845080304 18.382 100 26 53 1 1858969680 6473776 7415600
20:23:33 17628 8192000000 10779396704 11192066048 1848573392 18.411 100 17 34 2 1858402352 5115184 4713776
20:23:57 57291 8192000000 10775300864 11200675840 1858307728 18.490 100 44 86 1 1877460400 6687488 12465184
20:25:00 21560 8192000000 10775304944 11205910528 1859796128 18.502 100 22 44 0 1871715584 5002080 6917376
20:25:30 7601 8192000000 10794366320 11215519744 1866817440 18.559 100 30 58 1 1881860432 6396992 8646000
20:25:44 10287 8192000000 10782742288 11213828096 1869438560 18.580 100 33 65 2 1886305152 7518880 9347712
20:26:03 7788 8192000000 10781949968 11215347712 1870310512 18.587 100 29 57 3 1885580608 7200272 8069824
20:26:22 10391 8192000000 10786904224 11221950464 1874991520 18.625 100 23 45 2 1890576800 9596448 5988832
20:26:39 6803 8192000000 10788908368 11224076288 1873415728 18.612 100 15 30 0 1887668176 9817136 4435312
20:26:54 12856 8192000000 10795007232 11228688384 1877310336 18.643 100 12 24 3 1885813808 5408944 3094528
20:27:13 30684 8192000000 10828139632 11245666304 1897671792 18.808 100 25 49 0 1908628128 4451808 6504528
20:27:51 21310 8192000000 10842214544 11261853696 1913801680 18.937 100 41 82 1 1933012832 7697680 11513472
20:28:24 12286 8192000000 10855476576 11274792960 1920811520 18.993 100 47 94 1 1942382560 8651200 12919840
20:28:49 5308 8192000000 10869607328 11286286336 1932047504 19.083 100 64 128 3 1959738672 9918688 17772480
20:29:01 6840 8192000000 10869985104 11290976256 1935662176 19.112 100 60 121 0 1963784064 11212912 16908976
20:29:17 14902 8192000000 10876766048 11294253056 1938030016 19.131 100 58 114 1 1965495520 11304944 16160560
20:29:40 32199 8192000000 10870021760 11305607168 1948445584 19.214 100 53 106 0 1973899392 10941760 14512048
20:30:40 105281 8192000000 10873674960 11316953088 1951710240 19.240 100 35 70 2 1974302752 11869072 10723440
20:32:42 10951 8192000000 10900309136 11333632000 1958489168 19.294 100 32 64 2 1981762896 13929728 9344000
20:33:18 6245 8192000000 10899216208 11339452416 1971136176 19.394 100 52 104 0 1998997200 12100288 15760736
20:33:32 5801 8192000000 10926903312 11345137664 1975346640 19.428 100 60 116 1 2004427344 12206336 16874368
20:33:51 6199 8192000000 10923846512 11352150016 1984414176 19.500 100 62 124 2 2014910000 13373552 17122272
20:34:07 12937 8192000000 10937537648 11365011456 1987068864 19.521 100 59 118 0 2021278416 17370528 16839024
20:34:28 8987 8192000000 10944886784 11370479616 1995803264 19.590 100 75 147 1 2035990720 18455200 21732256
20:34:44 8077 8192000000 10948890144 11369508864 1999348080 19.618 100 71 141 4 2038194832 18259664 20587088
20:35:02 5422 8192000000 10950934064 11376791552 2001188976 19.632 100 78 156 2 2043522384 18962496 23370912
20:35:15 9135 8192000000 10949421808 11378913280 2001458880 19.634 100 59 116 2 2038336176 20092528 16784768
20:35:31 7162 8192000000 10948998464 11381530624 2004691824 19.660 100 65 130 1 2043387504 19497520 19198160
20:35:47 17590 8192000000 10951753216 11384020992 1990408112 19.547 99 60 120 2 2028044848 20018704 17618032
20:36:11 6327 8192000000 10942286672 11372908544 1997332400 19.602 100 65 130 0 2037563072 20544944 19685728
20:36:25 13762 8192000000 10940366624 11371495424 1982159616 19.482 99 57 114 2 2019141040 20775952 16205472
20:36:45 11785 8192000000 10945846192 11370176512 1990340896 19.546 100 58 116 0 2028566544 21138368 17087280
20:37:08 13270 8192000000 10939393280 11376119808 1994649888 19.581 100 59 118 3 2035739280 23759200 17330192
20:37:29 4240 8192000000 10935106624 11363061760 1956734032 19.280 98 61 122 0 1997971552 22729760 18507760
20:37:46 17935 8192000000 10949517744 11379511296 1995996224 19.591 100 57 114 1 2037091328 24301088 16794016
20:38:11 11323 8192000000 10946670928 11381084160 1979911408 19.464 99 54 108 3 2023610704 27715088 15984208
20:38:32 8708 8192000000 10948084544 11386703872 1997512960 19.603 100 46 92 3 2038437136 26501616 14422560
20:38:47 6921 8192000000 10970659104 11400515584 2007728112 19.684 100 59 118 1 2054835744 28971904 18135728
20:39:01 5200 8192000000 10966613760 11384287232 1998247968 19.609 100 63 125 1 2047101136 29817248 19035920
20:39:17 6165 8192000000 10947343408 11366199296 1970626160 19.390 99 69 138 1 2023757040 31631296 21499584
20:39:32 11032 8192000000 10959004528 11382743040 1995198192 19.585 100 56 112 0 2044548880 32171008 17179680
20:39:53 3020 8192000000 10969543856 11397025792 2003952880 19.654 100 68 134 2 2058745376 34181776 20610720
20:40:05 3501 8192000000 10994123168 11416502272 2017793072 19.763 100 67 133 2 2074129728 35571360 20765296
20:40:16 4924 8192000000 10980389520 11406671872 2010116816 19.702 100 76 152 1 2070929008 37440800 23371392
20:40:28 1735 8192000000 10990574816 11408523264 2011434352 19.713 100 79 158 1 2074815552 38963344 24417856
20:40:37 16271 8192000000 10982243616 11407597568 1992539968 19.564 99 70 138 2 2055756064 41290592 21925504
20:41:04 3478 8192000000 10989102096 11407978496 1993163408 19.569 99 77 152 0 2061064640 44009600 23891632
20:41:17 3380 8192000000 10977057296 11396833280 1993753728 19.573 99 84 168 0 2064199552 44226240 26219584
20:41:28 6484 8192000000 10996894384 11422883840 2018042432 19.765 100 76 152 0 2087223840 45722576 23458832
20:41:45 1876 8192000000 11016213680 11432329216 2022543568 19.800 100 88 174 0 2093311808 44063456 26704784
20:41:58 3251 8192000000 11003168944 11432947712 2010504320 19.705 99 74 146 2 2076083680 42659216 22920144
20:42:11 2630 8192000000 10998970928 11424145408 2002063648 19.639 99 71 139 1 2067047536 42341328 22642560
20:42:23 6353 8192000000 11001289760 11424727040 2013901216 19.732 100 79 157 1 2081212592 42696368 24615008
20:42:39 3280 8192000000 11000415488 11424976896 2006481040 19.674 99 72 144 1 2074058320 44286240 23291040
20:42:52 9681 8192000000 10973056512 11409014784 1989578080 19.540 99 59 117 0 2050632128 42626336 18427712
20:43:10 3383 8192000000 10995700224 11420221440 2011575152 19.714 100 72 143 1 2077344096 42948832 22820112
20:43:22 4145 8192000000 11000231712 11421032448 1997982880 19.607 99 77 154 0 2066326480 43436816 24906784
20:43:34 4184 8192000000 10968228944 11390996480 1980975392 19.472 99 72 142 1 2047591040 43645008 22970640
20:43:47 1670 8192000000 10982622768 11406635008 2002305632 19.641 100 76 152 2 2069898784 43285616 24307536
20:43:58 1583 8192000000 10998364880 11409149952 1993781696 19.574 99 87 173 3 2066822288 45889376 27151216
20:44:08 5216 8192000000 10993648704 11417870336 2002884272 19.645 100 71 138 3 2072816512 48029888 21902352
20:44:21 4900 8192000000 10990576176 11410206720 1998540928 19.611 100 81 162 1 2075092272 50779792 25771552
20:44:33 4887 8192000000 10988018800 11409281024 1994649888 19.581 100 77 154 2 2070621648 51252384 24719376
20:44:45 3187 8192000000 10992698128 11411226624 2003686496 19.652 100 84 170 1 2080516288 49507712 27322080
20:44:57 3539 8192000000 11002703264 11417968640 2004528080 19.658 100 81 158 0 2080432272 50897968 25006224
20:45:10 2566 8192000000 11009237680 11426611200 1992391040 19.563 99 85 169 2 2072489056 52903888 27194128
20:45:21 1134 8192000000 11012959600 11425091584 2005136160 19.663 100 91 180 1 2088160816 53920288 29104368
20:45:29 1908 8192000000 10973375760 11388989440 1968018128 19.370 98 82 164 1 2048898096 54852544 26027424
20:45:39 2052 8192000000 10974155056 11397632000 1979620864 19.462 100 84 166 1 2064221552 56972912 27627776
20:45:51 2144 8192000000 10976958544 11393228800 1971380832 19.396 99 83 166 2 2050591808 51924928 27286048
20:46:03 3747 8192000000 10983071632 11401551872 1989720176 19.542 100 84 169 1 2070234064 53530224 26983664
20:46:16 3789 8192000000 10993087232 11412254720 1995900048 19.590 100 87 174 0 2077901888 53480160 28521680
20:46:29 1697 8192000000 10976120208 11389898752 1977310608 19.443 99 82 167 0 2053647328 50815216 25521504
20:46:40 2975 8192000000 11004247536 11415285760 1998892816 19.614 100 94 188 1 2080865760 52882400 29090544
20:46:49 11906 8192000000 10956794128 11402334208 1984229024 19.498 100 44 88 2 2049641088 51091808 14320256
20:47:14 10228 8192000000 10955526736 11390681088 1966113648 19.355 99 43 86 1 2030062032 49310496 14637888
20:47:39 5044 8192000000 10964503184 11393519616 1971720416 19.399 99 46 92 1 2033105776 45971696 15413664
20:47:52 7271 8192000000 10952252496 11384037376 1949128784 19.220 98 51 102 1 2012144112 45942080 17073248
20:48:10 8111 8192000000 10922835456 11348316160 1890114624 18.747 96 47 94 1 1950086016 44207056 15764336
20:48:26 4210 8192000000 10932017376 11363082240 1955276784 19.268 100 50 99 1 2020674304 48744176 16653344
20:48:42 7312 8192000000 10931665568 11375706112 1957541136 19.286 100 41 82 0 2020003168 48746688 13715344
20:48:57 5277 8192000000 10944920416 11388637184 1967095600 19.362 100 38 76 1 2029309040 49253888 12959552
20:49:18 15806 8192000000 10915795776 11354931200 1942275520 19.165 99 36 72 0 2001500544 46292208 12932816
20:49:43 5857 8192000000 10950123008 11381571584 1966972528 19.361 100 39 78 1 2025940304 45312576 13655200
20:50:05 11878 8192000000 10921418336 11367432192 1934902112 19.106 99 35 70 2 1994906224 47553904 12450208
20:50:28 14960 8192000000 10911003728 11351973888 1925850800 19.034 99 30 60 0 1984196656 47767280 10578576
20:50:50 17881 8192000000 10916847968 11359662080 1938721600 19.137 100 38 76 0 2002014640 50101744 13191296
20:51:21 37630 8192000000 10930732688 11385094144 1946595952 19.199 100 25 49 1 2010269072 54306544 9366576
20:52:27 19902 8192000000 10904801360 11351117824 1914662528 18.944 99 32 64 0 1974067152 48313488 11091136
20:53:15 19439 8192000000 10874312672 11323035648 1899961264 18.826 99 22 44 1 1941664512 34188960 7514288
20:53:45 34167 8192000000 10849869984 11318304768 1889562048 18.742 99 17 34 2 1919030512 24228128 5240336
20:54:26 44736 8192000000 10875377600 11340451840 1922970848 19.011 100 10 20 2 1957181568 31005712 3205008
20:56:11 69220 8192000000 10864291968 11333660672 1914018096 18.939 99 20 40 1 1936642896 16787536 5837264
20:57:27 72297 8192000000 10851631248 11301347328 1866295824 18.554 96 11 23 0 1880632384 10856224 3480336
20:58:49 80383 8192000000 10863154608 11322122240 1871513632 18.597 97 8 17 0 1884835376 11393440 1928304
21:00:16 27195 8192000000 10895115184 11332571136 1946846880 19.201 100 32 65 0 1963238464 6957088 9434496
21:00:56 15162 8192000000 10907476128 11345018880 1957605392 19.287 100 43 87 1 1979657216 10553872 11497952
21:01:30 49036 8192000000 10888811584 11351183360 1953856960 19.257 100 11 22 0 1967743344 10912992 2973392
21:02:25 89865 8192000000 10903979872 11340238848 1868047216 18.568 95 19 38 0 1882454432 8672208 5735008
21:04:04 103635 8192000000 10897033408 11349778432 1944730848 19.184 99 37 74 0 1963641200 7754576 11155776
21:05:54 85419 8192000000 10890856048 11371356160 1967408656 19.365 100 23 46 0 1991649376 17513088 6727632
21:07:27 2490 8192000000 10886420096 11373535232 1958793584 19.296 100 3 6 0 1977529184 18033920 701680
21:07:54 17742 8192000000 10899882528 11364610048 1949757216 19.225 99 19 38 0 1967531856 12937008 4837632
21:08:21 14040 8192000000 10922546720 11362291712 1952076400 19.243 99 48 97 0 1975620496 9906240 13637856
21:08:52 24235 8192000000 10928466704 11372564480 1978697824 19.454 100 51 102 0 2003193552 9656208 14839520
21:09:26 38422 8192000000 10905319360 11371610112 1978538208 19.453 100 17 34 2 1993086720 9981952 4566560
21:10:11 74232 8192000000 10911683984 11383128064 1982319536 19.483 100 17 34 1 1998827328 11086496 5421296
21:11:34 73510 8192000000 10896839440 11361853440 1960604192 19.311 99 11 22 0 1972714128 8719232 3390704
21:12:54 55557 8192000000 10905585648 11382992896 1984911456 19.504 100 10 20 0 1998362176 10502960 2947760
21:14:30 41163 8192000000 10904780752 11380510720 1952914848 19.250 98 18 37 0 1970514768 11756128 5843792
21:15:19 34212 8192000000 10902304640 11375546368 1965733680 19.352 99 17 34 0 1984934496 13601648 5599168
21:16:01 63999 8192000000 10908930464 11383877632 1982721888 19.486 100 18 36 2 1999915632 12454656 4739088
21:18:23 43449 8192000000 10909991968 11394015232 1986819296 19.519 100 14 28 0 2005758416 14868400 4070720
21:19:14 43741 8192000000 10897554272 11368747008 1923685056 19.016 97 18 36 0 1948265792 19466704 5114032
21:20:11 72105 8192000000 10896210944 11385851904 1948646144 19.216 99 9 18 0 1976388768 25178752 2563872
21:21:34 43686 8192000000 10891918736 11397263360 1963549696 19.334 100 4 8 0 1988571184 23975536 1045952
21:22:24 65425 8192000000 10888941008 11368136704 1916496784 18.959 97 15 30 2 1930191696 9018192 4676720
21:23:36 55749 8192000000 10892280688 11374088192 1954893584 19.265 99 20 39 0 1976979408 16214064 5871760
21:24:53 40075 8192000000 10907092048 11354378240 1903263920 18.853 96 48 96 1 1929905744 12875184 13766640
21:25:43 26591 8192000000 10879358256 11351097344 1936556128 19.119 99 27 54 0 1955773952 11761424 7456400
21:26:16 48192 8192000000 10898828432 11370422272 1926328224 19.038 98 31 60 2 1953452160 17962384 9161552
21:27:12 77704 8192000000 10881717568 11365056512 1891193840 18.755 96 12 24 0 1911041760 17226080 2621840
21:28:42 78799 8192000000 10879980800 11338076160 1848928032 18.413 94 16 30 1 1860920544 7765056 4227456
21:30:09 46559 8192000000 10906575280 11371450368 1947622336 19.208 99 26 52 1 1973615360 19144704 6848320
21:31:03 61850 8192000000 10857826160 11322060800 1854462928 18.458 95 9 18 1 1869322448 12280272 2579248
21:32:12 38419 8192000000 10874970352 11331936256 1896708272 18.800 97 20 40 0 1910442128 8535056 5198800
21:33:19 17214 8192000000 10894366496 11326754816 1910558784 18.911 99 49 98 0 1935020000 10461056 14000160
21:33:44 15315 8192000000 10893482464 11331289088 1926791712 19.041 99 70 140 0 1960692656 14295472 19605472
21:34:09 19042 8192000000 10892113808 11346071552 1940650336 19.152 100 43 86 0 1968889616 15879504 12359776
21:34:38 126938 8192000000 10869310992 11340795904 1854143968 18.456 95 17 34 0 1877064320 18396704 4523648
21:36:58 98996 8192000000 10877628432 11348254720 1924952304 19.026 98 40 80 0 1948677552 12000528 11724720
21:39:13 37322 8192000000 10843275056 11309944832 1894245696 18.780 97 35 69 2 1915112352 11739344 9127312
21:40:03 76141 8192000000 10830833888 11305623552 1860509680 18.507 96 12 24 0 1870750864 7010976 3230208
21:41:38 36037 8192000000 10815393744 11288678400 1859292928 18.498 97 7 14 0 1866996992 6429104 1274960
21:42:20 28545 8192000000 10822323072 11292180480 1899608896 18.823 99 6 12 1 1907062864 5966000 1487968
21:42:57 41719 8192000000 10837684048 11301343232 1847016112 18.398 96 16 33 1 1860948432 9359408 4572912
21:43:46 52942 8192000000 10825852400 11290611712 1860151040 18.505 97 17 34 1 1880143136 15101520 4890576
21:45:07 69955 8192000000 10812517552 11271004160 1858440720 18.491 98 18 37 1 1876466448 12328448 5697280
21:46:25 44467 8192000000 10825802256 11302387712 1901232944 18.836 100 20 39 2 1915292320 8397392 5661984
21:47:22 52828 8192000000 10842891504 11303837696 1896985248 18.802 99 16 32 0 1911370576 9466432 4918896
21:48:21 33815 8192000000 10843203744 11314352128 1917998752 18.971 100 23 46 1 1935473520 10512000 6962768
21:50:06 115184 8192000000 10857620992 11329003520 1903680448 18.856 98 14 28 0 1919673632 11783584 4209600
21:52:11 41508 8192000000 10854843296 11312869376 1879777808 18.663 97 20 40 1 1891910224 6976048 5156368
21:53:02 31103 8192000000 10846363728 11309760512 1874456880 18.620 97 38 76 1 1895448016 10324608 10666528
21:53:46 27379 8192000000 10862440000 11318153216 1912230752 18.925 99 25 50 2 1926516240 7920560 6364928
21:54:20 24910 8192000000 10873324208 11327496192 1923469008 19.015 99 34 68 0 1943406112 9987648 9949456
21:54:52 74123 8192000000 10869962128 11349893120 1914251600 18.941 98 28 56 1 1935617312 13462016 7903696
21:56:41 92901 8192000000 10902735872 11384422400 1927048496 19.043 98 13 27 0 1949645616 19203344 3393776
21:58:20 88162 8192000000 10910760240 11396337664 1964863808 19.345 100 10 20 0 1991115136 23457392 2793936
22:00:02 88532 8192000000 10912225104 11384496128 1978697072 19.454 100 18 36 1 1999335696 16212192 4426432
22:02:29 100717 8192000000 10943935920 11393118208 1940821232 19.153 97 18 36 0 1957554096 11918752 4814112
22:04:28 30489 8192000000 10935241712 11401228288 1999071296 19.615 100 33 66 2 2018419104 9516704 9831104
22:05:06 112477 8192000000 10914725056 11386093568 1946273712 19.197 97 27 54 0 1961321072 7128736 7918624
22:07:06 59938 8192000000 10885052416 11353853952 1930400512 19.070 97 21 42 1 1946887504 10289488 6197504
22:08:12 17179 8192000000 10910544784 11368423424 1974394912 19.420 100 30 60 0 1990980912 8406672 8179328
22:08:39 50841 8192000000 10881605088 11360014336 1905696992 18.872 96 33 66 0 1923285024 8947696 8640336
22:09:36 61637 8192000000 10894695312 11377233920 1957465232 19.286 99 9 18 0 1970709424 10381152 2863040
22:10:47 43901 8192000000 10879797984 11357102080 1931423760 19.078 98 9 18 1 1943949760 9702320 2823680
22:11:48 64967 8192000000 10891671392 11370430464 1973876192 19.416 100 9 18 0 1984742832 8298752 2567888
22:13:03 58704 8192000000 10892621024 11382538240 1972926080 19.409 100 12 24 0 1986594096 10116704 3551312
22:14:45 42413 8192000000 10880175632 11356676096 1944973680 19.186 99 13 26 2 1957161936 8589088 3599168
22:15:33 73473 8192000000 10906349984 11380301824 1941779744 19.161 98 13 26 1 1954702112 9331376 3590992
22:17:07 56026 8192000000 10892761760 11363938304 1918452064 18.974 97 26 52 0 1937369920 10980928 7936928
22:18:40 96202 8192000000 10875902368 11339948032 1863768448 18.534 95 12 24 1 1879188240 11732128 3687664
22:20:23 39968 8192000000 10870737200 11333054464 1874679200 18.622 96 16 32 0 1886473088 7374928 4418960
22:21:09 10903 8192000000 10878082272 11330002944 1926234656 19.037 99 44 87 1 1946597744 7481056 12882032
22:21:29 14520 8192000000 10898559616 11345825792 1932531328 19.087 99 44 88 0 1957216784 12382656 12302800
22:21:51 38959 8192000000 10897666160 11338248192 1913074016 18.931 98 54 106 1 1944184544 15767840 15342688
22:22:38 41224 8192000000 10876028496 11331813376 1904257456 18.861 98 32 64 1 1924701408 11493600 8950352
22:23:30 58537 8192000000 10886187600 11356491776 1934776288 19.105 99 30 60 1 1956297456 12890640 8630528
22:24:34 89229 8192000000 10877403840 11338379264 1855512368 18.467 95 14 28 0 1872752448 13567344 3672736
22:26:12 94756 8192000000 10238911648 10653556736 1331562912 13.981 69 11 22 0 1347893200 13315600 3014688

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 19-01-2021 22:29:16 to 19-01-2021 22:29:48.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 122 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:02, from 19-01-2021 22:29:49 to 19-01-2021 22:29:51.

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          245044
MON$OLDEST_ACTIVE               246648
MON$OLDEST_SNAPSHOT             246648
MON$NEXT_TRANSACTION            246648
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                       2037728
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:72: 
:73: mscs-test-161.budzdorov.ru    Tue Jan 19 22:27:51 2021
:74:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:75: 
:76: 
:77: mscs-test-161.budzdorov.ru    Tue Jan 19 22:27:56 2021
:78:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:79: 
:80: 
:81: mscs-test-161.budzdorov.ru    Tue Jan 19 22:27:56 2021
:82:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:83: 
--- end of diff output ---

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

19.01.21 22:29:52. 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-19 22:29:54 No severe PSQL-related problems occured
19.01.21 22:29:55. End of report.