Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.06.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 58e1ddde69c44dad93d327777e5becec
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-05-09 08:45
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 4793.92
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 17139924 kB
MemAvailable 31365928 kB
Buffers 0 kB
Cached 14507672 kB
SwapCached 2436 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-06-17 22:27:42
DTS_END                         2021-06-17 22:27:42.5350
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38664
TRN_ID                          236067
ATT_ID                          666
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: 9512.35 21765 1141482
customer order: creation 170.48 346 20457
customer order: refuse 14.62 333 1754
order to supplier: creation 44.51 1281 5341
order to supplier: removal 3.50 100931 420
invoice (draft): creation 46.31 3499 5557
invoice (draft): removal 55.26 775 6631
invoice accept: apply 41.43 19095 4971
invoice accept: cancel 49.22 857 5906
customer reserve: creation 3891.50 185 466980
customer reserve: removal 4896.60 56 587592
realization accept: apply 83.37 186 10004
realization accept: cancel 87.18 122 10462
payment from customer: creation 58.25 124 6990
payment from customer: removal 5.49 71 659
payment to supplier: creation 49.35 144 5922
payment to supplier: removal 3.45 83 414
service: total inventory turnovers 4.72 1214 566
service: total monetary turnovers 6.24 47 749
service: aggregate perf. data 0.86 20010 103
service: refresh index statistics 0.03 285936 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-06-2021 22:28:28 to 17-06-2021 22:28:30.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5131
TEST_TIME 2 5944
TEST_TIME 3 5867
TEST_TIME 4 5899
TEST_TIME 5 5906
TEST_TIME 6 5448
TEST_TIME 7 6008
TEST_TIME 8 6453
TEST_TIME 9 6397
TEST_TIME 10 6387
TEST_TIME 11 6874
TEST_TIME 12 6800
TEST_TIME 13 6875
TEST_TIME 14 6876
TEST_TIME 15 6846
TEST_TIME 16 7310
TEST_TIME 17 7383
TEST_TIME 18 7433
TEST_TIME 19 7708
TEST_TIME 20 7930
TEST_TIME 21 8061
TEST_TIME 22 8408
TEST_TIME 23 8559
TEST_TIME 24 8841
TEST_TIME 25 8966
TEST_TIME 26 8893
TEST_TIME 27 9197
TEST_TIME 28 9702
TEST_TIME 29 9592
TEST_TIME 30 10051
TEST_TIME 31 10532
TEST_TIME 32 10479
TEST_TIME 33 10303
TEST_TIME 34 10541
TEST_TIME 35 10348
TEST_TIME 36 10212
TEST_TIME 37 10164
TEST_TIME 38 10011
TEST_TIME 39 10055
TEST_TIME 40 10061
TEST_TIME 41 10064
TEST_TIME 42 9913
TEST_TIME 43 9854
TEST_TIME 44 9805
TEST_TIME 45 9766
TEST_TIME 46 9841
TEST_TIME 47 9860
TEST_TIME 48 9858
TEST_TIME 49 9762
TEST_TIME 50 9686
TEST_TIME 51 9717
TEST_TIME 52 9613
TEST_TIME 53 9554
TEST_TIME 54 9532
TEST_TIME 55 9498
TEST_TIME 56 9484
TEST_TIME 57 9533
TEST_TIME 58 9452
TEST_TIME 59 9439
TEST_TIME 60 9659
TEST_TIME 61 9630
TEST_TIME 62 9657
TEST_TIME 63 9641
TEST_TIME 64 9710
TEST_TIME 65 9797
TEST_TIME 66 9932
TEST_TIME 67 9905
TEST_TIME 68 10019
TEST_TIME 69 10044
TEST_TIME 70 9965
TEST_TIME 71 9834
TEST_TIME 72 9823
TEST_TIME 73 9780
TEST_TIME 74 9799
TEST_TIME 75 9749
TEST_TIME 76 9693
TEST_TIME 77 9673
TEST_TIME 78 9614
TEST_TIME 79 9559
TEST_TIME 80 9542
TEST_TIME 81 9571
TEST_TIME 82 9658
TEST_TIME 83 9621
TEST_TIME 84 9622
TEST_TIME 85 9639
TEST_TIME 86 9713
TEST_TIME 87 9688
TEST_TIME 88 9694
TEST_TIME 89 9696
TEST_TIME 90 9721
TEST_TIME 91 9739
TEST_TIME 92 9781
TEST_TIME 93 9825
TEST_TIME 94 9814
TEST_TIME 95 9726
TEST_TIME 96 9706
TEST_TIME 97 9684
TEST_TIME 98 9713
TEST_TIME 99 9639
TEST_TIME 100 9606
TEST_TIME 101 9592
TEST_TIME 102 9607
TEST_TIME 103 9578
TEST_TIME 104 9546
TEST_TIME 105 9513
TEST_TIME 106 9484
TEST_TIME 107 9471
TEST_TIME 108 9418
TEST_TIME 109 9412
TEST_TIME 110 9410
TEST_TIME 111 9390
TEST_TIME 112 9407
TEST_TIME 113 9397
TEST_TIME 114 9408
TEST_TIME 115 9472
TEST_TIME 116 9478
TEST_TIME 117 9473
TEST_TIME 118 9475
TEST_TIME 119 9526
TEST_TIME 120 9522

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-06-2021 22:28:32 to 17-06-2021 22:28:35.

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 1572120 1572120 0 0.00 0 20304 7 0 0
doc_list_biud 1572117 1572117 0 0.00 0 67980 27 0 0
sp_add_invoice_to_stock 5057 4971 86 1.70 37 177286 19095 0 86
sp_cancel_adding_invoice 5906 5906 0 0.00 4 89583 858 0 0
sp_cancel_client_order 1754 1754 0 0.00 4 11229 334 0 0
sp_cancel_customer_reserve 587592 587592 0 0.00 1 21159 57 0 0
sp_cancel_pay_from_customer 659 659 0 0.00 2 1577 71 0 0
sp_cancel_pay_to_supplier 414 414 0 0.00 3 4409 84 0 0
sp_cancel_supplier_invoice 6637 6631 6 0.09 1 67988 775 0 6
sp_cancel_supplier_order 420 420 0 0.00 11 1046862 100932 0 0
sp_cancel_write_off 10462 10462 0 0.00 1 26708 123 0 0
sp_client_order 20457 20457 0 0.00 4 47454 347 0 0
sp_customer_reserve 466980 466980 0 0.00 0 78491 185 0 0
sp_fill_shopping_cart 31346 31346 0 0.00 1 48430 40 0 0
sp_fill_shopping_cart_clo_res 466962 466962 0 0.00 0 11536 11 0 0
sp_get_clo_for_invoice 4947 4947 0 0.00 0 14624 305 0 0
sp_kill_cost_storno 17441 17441 0 0.00 0 20291 60 0 0
sp_kill_qstorno_ret_qs2qd 1192697 1192697 0 0.00 0 67976 31 0 0
sp_kill_qty_storno 627715 627715 0 0.00 0 67978 67 0 0
sp_lock_selected_doc 20792 20792 0 0.00 0 8574 6 0 0
sp_make_cost_storno 27862 27862 0 0.00 0 15240 55 0 0
sp_multiply_rows_for_pdistr 27862 27862 0 0.00 0 7595 29 0 0
sp_multiply_rows_for_qdistr 20457 20457 0 0.00 0 47400 165 0 0
sp_pay_from_customer 6990 6990 0 0.00 4 10330 125 0 0
sp_pay_to_supplier 5922 5922 0 0.00 5 15491 144 0 0
sp_payment_common 12912 12912 0 0.00 1 15464 32 0 0
sp_qd_handle_on_cancel_clo 1754 1754 0 0.00 0 11220 303 0 0
sp_qd_handle_on_invoice_upd_sts 10852 10852 0 0.00 0 35090 340 0 0
sp_qd_handle_on_reserve_upd_sts 10004 10004 0 0.00 0 16808 60 0 0
sp_reserve_write_off 10004 10004 0 0.00 6 16968 187 0 0
sp_supplier_invoice 5557 5557 0 0.00 7 120804 3499 0 0
sp_supplier_order 5341 5341 0 0.00 5 55853 1281 0 0
srv_aggregate_perf_data 103 103 0 0.00 2196 238130 20010 0 0
srv_fill_mon_cache_memory 172 172 0 0.00 1038 154574 29931 0 0
srv_find_qd_qs_mism 1092934 1092934 0 0.00 0 10093 6 0 0
srv_make_invnt_saldo 566 566 0 0.00 44 85206 1214 0 0
srv_make_money_saldo 749 749 0 0.00 1 7834 47 0 0
srv_recalc_idx_stat 4 4 0 0.00 108091 445168 285937 0 0
t$perf-abend:sp_add_invoice_to_stock 86 86 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4972 4972 0 0.00 0 14118 195 0 0
t$perf-norm:sp_cancel_adding_invoice 428 428 0 0.00 0 5807 109 0 0
t$perf-norm:sp_cancel_client_order 1754 1754 0 0.00 0 3410 16 0 0
t$perf-norm:sp_cancel_customer_reserve 740 740 0 0.00 0 1829 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 659 659 0 0.00 0 1634 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 414 414 0 0.00 0 2754 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 426 426 0 0.00 0 1215 16 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 34261 1830 0 0
t$perf-norm:sp_cancel_write_off 1001 1001 0 0.00 0 3878 14 0 0
t$perf-norm:sp_client_order 20457 20457 0 0.00 0 16689 24 0 0
t$perf-norm:sp_customer_reserve 1045 1045 0 0.00 0 1797 5 0 0
t$perf-norm:sp_pay_from_customer 6990 6990 0 0.00 0 8355 12 0 0
t$perf-norm:sp_pay_to_supplier 5922 5922 0 0.00 0 8218 14 0 0
t$perf-norm:sp_reserve_write_off 10004 10004 0 0.00 0 6676 14 0 0
t$perf-norm:sp_supplier_invoice 5557 5557 0 0.00 0 5737 21 0 0
t$perf-norm:sp_supplier_order 5341 5341 0 0.00 0 2514 15 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 287 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 5654 42 0 0
t$perf-norm:srv_make_invnt_saldo 566 566 0 0.00 0 848 20 0 0
t$perf-norm:srv_make_money_saldo 749 749 0 0.00 0 674 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 4 0 0
v_add_invoice_to_stock 10064 9892 172 1.70 0 4702 19 0 172
v_all_customers 37062 37062 0 0.00 0 25 1 0 0
v_all_suppliers 30576 30576 0 0.00 0 169 1 0 0
v_all_wares 40914 40914 0 0.00 0 182 1 0 0
v_cancel_adding_invoice 856 856 0 0.00 0 2695 12 0 0
v_cancel_client_order 3508 3508 0 0.00 0 3312 8 0 0
v_cancel_customer_prepayment 1318 1318 0 0.00 0 1383 6 0 0
v_cancel_customer_reserve 1480 1480 0 0.00 0 2360 7 0 0
v_cancel_payment_to_supplier 828 828 0 0.00 0 2076 9 0 0
v_cancel_supplier_invoice 864 852 12 1.38 0 445 12 0 12
v_cancel_supplier_order 840 840 0 0.00 0 1400 6 0 0
v_cancel_write_off 2002 2002 0 0.00 0 3097 16 0 0
v_max_id_clo_ord 5337 5337 0 0.00 0 1295 2 0 0
v_max_id_clo_res 1045 1045 0 0.00 0 3903 22 0 0
v_max_id_ord_sup 5552 5552 0 0.00 0 3154 3 0 0
v_max_non_paid_invoice 1523 1523 0 0.00 0 476 3 0 0
v_max_non_paid_realizn 3704 3704 0 0.00 0 5948 8 0 0
v_min_id_clo_ord 5337 5337 0 0.00 0 2247 5 0 0
v_min_id_clo_res 1045 1045 0 0.00 0 2489 13 0 0
v_min_id_ord_sup 5552 5552 0 0.00 0 5547 9 0 0
v_min_non_paid_invoice 5922 5922 0 0.00 0 15458 24 0 0
v_min_non_paid_realizn 6990 6990 0 0.00 0 5160 17 0 0
v_our_firm 10424 10424 0 0.00 0 41 1 0 0
v_reserve_write_off 20008 20008 0 0.00 0 3698 6 0 0
x_lock_depdocs_on_canc_invoice 12111 12111 0 0.00 0 13912 125 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 10942 380 0 0
x_make_qstorno_1000_1200 5341 5341 0 0.00 2 55784 1202 0 0
x_make_qstorno_1200_2000 5557 5557 0 0.00 3 105871 3350 0 0
x_make_qstorno_2100_3300 466980 466980 0 0.00 0 78490 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-06-2021 22:28:36 to 17-06-2021 22:28:40.

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:46 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
19:57:52 23704 8192000000 10278988320 10587369472 989377696 10.775 76 54 109 0 1010149088 2743904 18027488
19:58:26 22777 8192000000 10351662208 10669006848 1395587040 14.556 100 85 170 0 1429376384 5102960 28686384
19:58:59 20147 8192000000 10369724240 10695352320 1429335072 14.855 100 83 167 0 1463094832 6420304 27339456
19:59:30 26664 8192000000 10412056144 10739875840 1467764208 15.194 100 83 167 1 1505786304 11503984 26518112
20:00:07 15862 8192000000 10435656704 10767052800 1484982224 15.345 100 78 156 0 1517591264 7222656 25386384
20:00:32 10363 8192000000 10454596816 10788966400 1520687904 15.656 100 89 178 0 1556557232 7923312 27946016
20:00:53 14607 8192000000 10466337264 10805686272 1532424624 15.758 100 80 160 0 1565704912 8238544 25041744
20:01:16 11746 8192000000 10490849504 10830553088 1544572352 15.863 100 80 160 0 1578752016 8750432 25429232
20:01:38 24087 8192000000 10507372400 10854019072 1568345824 16.068 100 89 178 1 1609465232 13562992 27556416
20:02:11 21223 8192000000 10538454096 10889793536 1592768256 16.278 100 82 163 3 1627630160 9561744 25300160
20:02:47 19188 8192000000 10575406576 10930282496 1626643088 16.566 100 80 160 0 1660927072 10446192 23837792
20:03:16 15779 8192000000 10591816256 10949369856 1647653136 16.745 100 81 162 0 1682772576 11350768 23768672
20:03:42 14951 8192000000 10623762528 10987999232 1673339024 16.961 100 85 170 1 1710527344 12397024 24791296
20:04:06 8913 8192000000 10628579360 10993217536 1687591232 17.081 100 81 162 1 1724417152 13363312 23462608
20:04:25 12245 8192000000 10645246752 11016663040 1704998592 17.227 100 81 162 1 1741861632 13271792 23591248
20:04:46 10272 8192000000 10654267696 11027083264 1716326144 17.322 100 79 158 1 1752081040 12850496 22904400
20:05:03 8104 8192000000 10664925856 11037700096 1718013936 17.336 100 75 149 0 1752086384 13057280 21015168
20:05:18 9851 8192000000 10676900224 11053203456 1736961072 17.493 100 80 160 1 1772324848 12803248 22560528
20:05:35 6614 8192000000 10691397760 11065217024 1753136880 17.628 100 80 159 0 1787532528 11689584 22706064
20:05:49 6794 8192000000 10690177312 11071217664 1755584000 17.648 100 71 141 1 1788214400 12063408 20566992
20:06:03 5222 8192000000 10698631808 11084132352 1768603888 17.755 100 73 146 1 1801064688 11782944 20677856
20:06:15 5227 8192000000 10717460736 11094913024 1774519696 17.804 100 79 158 0 1809298448 12767328 22011424
20:06:28 4069 8192000000 10728591312 11107565568 1781235376 17.860 100 82 163 0 1817972160 13683136 23053648
20:06:39 4304 8192000000 10733927536 11114098688 1791715360 17.946 100 85 170 2 1830297056 15107904 23473792
20:06:51 3613 8192000000 10728461344 11116679168 1795684224 17.978 100 82 162 2 1832637728 14451584 22501920
20:07:01 3125 8192000000 10734581552 11121803264 1802549888 18.035 100 81 159 0 1837559776 13098256 21911632
20:07:11 6892 8192000000 10733552336 11121831936 1804378032 18.050 100 65 130 4 1834082688 12009376 17695280
20:07:27 2574 8192000000 10757125136 11144916992 1822449600 18.198 100 92 183 0 1861436352 12647952 26338800
20:07:36 2866 8192000000 10766761088 11148689408 1823261584 18.204 100 82 164 2 1858606096 11250000 24094512
20:07:46 2497 8192000000 10766132400 11153321984 1831966352 18.275 100 79 159 0 1867007248 12309616 22731280
20:07:55 2334 8192000000 10775007328 11161346048 1837518448 18.321 100 86 173 3 1874575024 12626896 24429680
20:08:04 3044 8192000000 10781671264 11170148352 1846395072 18.393 100 86 173 0 1884106960 13745152 23966736
20:08:13 1635 8192000000 10795696432 11181084672 1852902272 18.446 100 88 179 1 1891056544 13153472 25000800
20:08:21 1821 8192000000 10796208496 11180171264 1856196560 18.472 100 95 187 2 1895448192 13065856 26185776
20:08:30 1634 8192000000 10797346160 11187216384 1853427120 18.450 100 83 166 1 1890292160 14153456 22711584
20:08:38 1718 8192000000 10810682944 11195486208 1859804640 18.502 100 95 190 0 1900497632 14576032 26116960
20:08:46 1221 8192000000 10810305920 11197808640 1863260144 18.530 100 91 182 1 1903112784 13809408 26043232
20:08:53 1247 8192000000 10812025184 11201191936 1865891488 18.551 100 96 194 0 1907848512 15039328 26917696
20:09:01 1748 8192000000 10815814320 11203956736 1870134288 18.585 100 93 189 2 1910756432 13750960 26871184
20:09:09 1246 8192000000 10813919120 11205324800 1873209728 18.610 100 86 173 2 1910143248 12884560 24048960
20:09:17 14763 8192000000 10797216272 11205337088 1874980576 18.625 100 75 150 3 1908128240 11835984 21311680
20:09:39 7737 8192000000 10809319360 11206860800 1875692992 18.630 100 80 159 1 1910584000 10772432 24118576
20:09:53 1455 8192000000 10827016288 11215732736 1882424160 18.685 100 92 184 1 1920091264 12047104 25620000
20:10:01 12162 8192000000 10817573120 11214528512 1878948816 18.657 100 75 150 0 1912696064 12421520 21325728
20:10:20 14771 8192000000 10791994176 11206905856 1874523280 18.621 100 32 64 0 1891687840 7919520 9245040
20:10:42 4403 8192000000 10793843472 11212464128 1880119008 18.666 100 47 93 1 1899664672 6463328 13082336
20:10:54 5782 8192000000 10787450272 11216224256 1880785168 18.671 100 29 58 1 1897241840 8080880 8375792
20:11:06 7583 8192000000 10788257920 11212693504 1880588016 18.670 100 29 58 3 1895821136 7264576 7968544
20:11:20 7876 8192000000 10783832960 11216175104 1882584528 18.686 100 27 54 2 1897180816 7583504 7012784
20:11:35 7298 8192000000 10785532848 11217723392 1884733584 18.703 100 30 61 1 1900307472 7048912 8524976
20:11:49 8205 8192000000 10798449872 11222974464 1887230160 18.723 100 24 48 1 1900602160 6517392 6854608
20:12:04 8170 8192000000 10812253600 11226656768 1887494976 18.726 100 27 54 1 1901616800 6313920 7807904
20:12:18 12001 8192000000 10806779072 11230584832 1889192240 18.739 100 20 38 1 1901231568 6036928 6002400
20:12:39 15803 8192000000 10797605360 11230900224 1890090080 18.747 100 12 24 3 1899367408 5461328 3816000
20:13:01 11516 8192000000 10808411520 11235794944 1896499088 18.798 100 29 58 0 1911152640 6212048 8441504
20:13:19 9801 8192000000 10802100128 11235102720 1898709680 18.816 100 27 54 1 1912476528 6703376 7063472
20:13:41 8040 8192000000 10797065648 11234676736 1899228624 18.820 100 16 32 0 1909818176 6200496 4389056
20:13:57 8440 8192000000 10793739328 11236352000 1900292816 18.829 100 25 50 0 1914288816 6905232 7090768
20:14:14 59447 8192000000 10828186416 11254607872 1903246048 18.852 100 33 66 2 1918623872 5350352 10027472
20:15:20 23068 8192000000 10843629408 11258368000 1915892272 18.954 100 78 156 4 1950715152 11370496 23452384
20:15:49 1337 8192000000 10852033952 11263631360 1913470656 18.934 100 85 175 1 1949935776 11002784 25462336
20:15:58 4000 8192000000 10820555088 11251924992 1904369312 18.861 100 40 81 0 1923152576 7331328 11451936
20:16:09 7332 8192000000 10826990720 11252666368 1903986976 18.858 100 30 58 2 1918715888 6828752 7900160
20:16:22 8368 8192000000 10823755360 11255631872 1906836816 18.881 100 36 73 0 1925233488 8282816 10113856
20:16:39 5965 8192000000 10813341536 11246923776 1900259664 18.828 100 23 46 0 1912887616 6234464 6393488
20:16:52 7417 8192000000 10805630112 11245899776 1884454192 18.701 99 19 38 2 1895437856 5762064 5221600
20:17:06 8226 8192000000 10811477840 11243954176 1892858128 18.769 100 22 44 3 1905094400 5495808 6740464
20:17:23 5863 8192000000 10804332256 11242319872 1899213504 18.820 100 30 60 0 1914060224 6258816 8587904
20:17:36 54053 8192000000 10812287040 11250503680 1905212080 18.868 100 34 65 1 1919291408 5995200 8084128
20:18:37 9327 8192000000 10821102560 11251093504 1889315632 18.740 99 31 61 2 1905655904 6661696 9678576
20:18:54 5907 8192000000 10748519440 11175522304 1815925440 18.144 96 36 69 2 1831777536 5924544 9927552
20:19:08 5306 8192000000 10781259808 11213803520 1854279424 18.457 99 37 74 2 1876016272 11533856 10202992
20:19:19 5008 8192000000 10772727744 11196227584 1853275088 18.449 100 28 56 1 1867850304 6425952 8149264
20:19:30 9198 8192000000 10721670672 11145904128 1765454592 17.729 96 22 44 0 1781227552 9463376 6309584
20:19:47 6492 8192000000 10719354832 11143782400 1782513584 17.870 97 19 38 0 1793147280 5394864 5238832
20:20:00 6426 8192000000 10742222704 11168616448 1818325232 18.164 99 17 34 2 1828601024 5571392 4704400
20:20:17 8660 8192000000 10721243536 11142574080 1727078848 17.411 94 17 34 0 1736792256 5338976 4374432
20:20:31 8492 8192000000 10704941536 11118518272 1760647200 17.690 97 18 34 1 1771100784 5032128 5421456
20:20:47 7026 8192000000 10712544560 11133812736 1759153408 17.677 97 26 51 0 1776529472 10412512 6963552
20:21:01 6992 8192000000 10694884032 11113947136 1732872032 17.459 97 20 40 1 1743364960 5701824 4791104
20:21:14 14542 8192000000 10691841840 11109773312 1719610672 17.349 96 21 41 4 1730815152 5376016 5828464
20:21:37 58955 8192000000 10682068208 11093471232 1679249360 17.011 93 30 60 0 1693740976 5392480 9099136
20:22:42 12599 8192000000 10704228336 11125911552 1747168576 17.578 97 19 38 2 1757623264 5101168 5353520
20:23:00 8647 8192000000 10699769088 11114659840 1747985840 17.585 98 28 56 1 1762090192 5978656 8125696
20:23:15 3289 8192000000 10706465616 11113017344 1787947088 17.915 100 43 86 2 1807901776 7604864 12349824
20:23:26 6085 8192000000 10720744576 11134590976 1802510656 18.035 100 32 64 0 1817159968 5577840 9071472
20:23:39 5366 8192000000 10728145072 11147653120 1812191472 18.114 100 32 63 2 1827128272 5570720 9366080
20:23:52 14076 8192000000 10719846768 11144359936 1799114976 18.007 99 20 39 1 1810126624 5039552 5972096
20:24:13 6743 8192000000 10748846432 11164909568 1827337040 18.238 100 34 69 0 1843750496 5933184 10480272
20:24:27 10079 8192000000 10749632320 11170025472 1829894384 18.258 100 30 60 1 1844454144 5955024 8604736
20:24:46 9316 8192000000 10754056752 11173232640 1834286384 18.294 100 21 42 0 1850128336 9662608 6179344
20:25:02 10678 8192000000 10747122240 11176984576 1837814576 18.323 100 15 30 0 1851647168 9323264 4509328
20:25:19 9679 8192000000 10748226976 11180896256 1848584400 18.411 100 29 58 1 1863130432 5028800 9517232
20:25:35 6736 8192000000 10765705472 11193606144 1854776048 18.461 100 23 46 3 1867163232 5728416 6658768
20:25:48 7746 8192000000 10768742464 11193217024 1853200592 18.448 100 12 24 0 1861768144 5350592 3216960
20:26:04 76259 8192000000 10785576384 11217035264 1863420960 18.531 100 27 55 1 1875766368 5258576 7086832
20:27:26 15229 8192000000 10813742000 11234766848 1886196320 18.715 100 26 50 1 1898870112 6025088 6648704
20:27:49 34097 8192000000 10835418048 11247857664 1898304176 18.813 100 51 101 1 1920057552 7236272 14517104
20:28:31 11374 8192000000 10842188528 11255590912 1908919888 18.898 100 51 103 3 1931820864 7880224 15020752
20:28:49 4943 8192000000 10850842208 11266949120 1918718976 18.977 100 66 131 2 1947758832 9531776 19508080
20:29:02 15090 8192000000 10852284960 11276664832 1921292816 18.997 100 58 114 1 1947646560 10307584 16046160
20:29:36 10959 8192000000 10862512240 11286302720 1928614400 19.056 100 58 119 1 1959976528 13990816 17371312
20:29:54 9408 8192000000 10859388896 11288207360 1930345584 19.070 100 44 88 2 1954264384 9803920 14114880
20:30:11 23243 8192000000 10861369680 11292913664 1934541056 19.103 100 43 86 1 1956590672 9051888 12997728
20:30:42 7964 8192000000 10877806368 11301773312 1943718752 19.176 100 61 122 0 1973190224 11186816 18284656
20:30:57 6339 8192000000 10882649280 11306061824 1944811616 19.185 100 57 111 2 1976671552 15213248 16646688
20:31:12 16309 8192000000 10884161328 11307225088 1945394288 19.190 100 43 84 1 1967664432 10334656 11935488
20:31:36 13536 8192000000 10885000560 11313045504 1954572976 19.263 100 52 102 1 1979928544 10787392 14568176
20:31:58 32731 8192000000 10887122080 11321729024 1955527008 19.270 100 35 70 1 1978597824 12567520 10503296
20:32:38 5313 8192000000 10892593152 11324260352 1960687600 19.312 100 50 97 2 1986652176 11676688 14287888
20:32:50 2484 8192000000 10904882496 11328024576 1965367376 19.349 100 55 109 0 1993211312 12250624 15593312
20:33:01 46179 8192000000 10906087184 11343450112 1972142976 19.402 100 43 86 0 2001494128 16281088 13070064
20:34:03 9453 8192000000 10906529680 11342921728 1973596368 19.414 100 42 82 2 1999861984 12897984 13367632
20:34:19 7519 8192000000 10915495984 11342696448 1975182000 19.427 100 53 106 2 2004929776 13971488 15776288
20:34:39 4324 8192000000 10930084960 11353731072 1984636976 19.501 100 70 140 3 2021899216 16476736 20785504
20:34:50 8538 8192000000 10919492704 11350347776 1984197568 19.498 100 59 118 0 2019102128 17984128 16920432
20:35:07 10096 8192000000 10939916640 11362078720 1985322848 19.507 100 57 114 0 2019768112 17760720 16684544
20:35:26 11119 8192000000 10919546368 11355459584 1984215040 19.498 100 56 113 1 2016727872 15866736 16646096
20:35:49 6373 8192000000 10927304208 11369013248 1990933392 19.551 100 50 100 0 2025314688 20175488 14205808
20:36:04 6448 8192000000 10919125456 11349426176 1974778752 19.423 99 55 106 1 2004834304 14554688 15500864
20:36:19 27227 8192000000 10924633760 11366264832 1986960672 19.520 100 47 94 0 2016895856 15365920 14569264
20:36:57 17050 8192000000 10939063584 11374833664 1995512064 19.587 100 55 108 0 2032147808 20648624 15987120
20:37:28 6298 8192000000 10955072272 11381497856 1999159520 19.616 100 64 126 1 2037849184 19809568 18880096
20:37:42 10343 8192000000 10965790416 11392180224 2005825440 19.669 100 75 150 1 2052674224 24795008 22053776
20:37:59 8931 8192000000 10945863648 11379339264 1998370496 19.610 100 54 108 1 2036881936 22335984 16175456
20:38:15 3870 8192000000 10944105424 11373907968 1991989984 19.560 100 59 113 3 2031779760 22102704 17687072
20:38:26 7916 8192000000 10958811024 11386286080 1999281024 19.617 100 73 142 1 2042587264 22503184 20803056
20:38:43 3268 8192000000 10962821760 11390042112 2003797136 19.653 100 64 124 2 2044619152 21867424 18954592
20:38:54 9640 8192000000 10950542048 11385917440 2004853360 19.661 100 61 122 3 2042604720 19855792 17895568
20:39:10 9619 8192000000 10949003120 11382173696 1989827904 19.542 99 54 108 1 2024789120 19279744 15681472
20:39:28 13671 8192000000 10955320992 11382308864 1987630992 19.525 99 63 122 3 2025406912 20159008 17616912
20:39:52 6140 8192000000 10945273696 11387564032 2000300800 19.625 100 55 108 0 2037416400 21555392 15560208
20:40:11 9017 8192000000 10958047472 11390820352 2004284048 19.657 100 64 129 1 2046750768 23285984 19180736
20:40:32 2388 8192000000 10987095552 11402297344 2012449520 19.721 100 73 146 3 2061199664 26187344 22562800
20:40:41 3126 8192000000 10964336896 11381846016 1994863536 19.582 99 73 146 0 2044328832 26669824 22795472
20:40:50 5271 8192000000 10975487552 11402416128 2012599760 19.722 100 79 158 0 2062704240 26321088 23783392
20:41:03 3869 8192000000 10984700976 11405856768 2017580032 19.761 100 80 159 1 2068458896 26881376 23997488
20:41:20 9110 8192000000 10980578720 11413147648 2019574128 19.777 100 65 130 0 2067768064 28770928 19423008
20:41:37 2227 8192000000 10981595648 11405033472 2008811536 19.692 99 81 163 1 2065668944 32247296 24610112
20:41:47 16527 8192000000 10962748336 11391008768 1998758160 19.613 99 71 143 0 2051386640 31399632 21228848
20:42:12 14665 8192000000 10976907808 11416616960 2018727808 19.770 100 64 127 1 2070416272 32081680 19606784
20:42:42 13365 8192000000 10984022352 11421581312 2002985392 19.646 99 53 106 2 2054757136 35388448 16383296
20:43:03 4457 8192000000 10981076832 11411836928 1998069488 19.608 99 65 127 1 2056580960 38294400 20217072
20:43:17 2154 8192000000 10994349200 11419643904 2016071888 19.749 100 90 180 1 2083754848 40000304 27682656
20:43:25 4259 8192000000 10978772224 11411140608 2011704672 19.715 100 78 156 1 2074091488 38232736 24154080
20:43:38 8587 8192000000 10990832656 11421151232 2014089456 19.734 100 65 126 2 2072084144 38780816 19213872
20:43:55 1635 8192000000 10993655936 11410534400 2002694256 19.644 99 83 167 1 2064103552 35844640 25564656
20:44:03 1878 8192000000 11009935984 11425820672 2028889504 19.850 100 90 178 3 2092015088 36506528 26619056
20:44:13 2593 8192000000 11016730192 11437535232 2033575424 19.887 100 89 178 0 2097014496 37340320 26098752
20:44:23 3017 8192000000 10998185904 11412545536 2004686512 19.660 99 89 177 1 2069346160 37914992 26744656
20:44:36 4077 8192000000 10996106720 11414503424 2014825536 19.739 100 80 158 0 2077123568 38440560 23857472
20:44:46 1869 8192000000 10997344944 11413598208 1996056752 19.592 99 88 174 2 2062866352 39233536 27576064
20:44:56 4085 8192000000 10991204224 11411943424 1993382768 19.571 99 85 167 2 2060666384 41289536 25994080
20:45:09 2443 8192000000 10971385376 11394068480 1950934752 19.234 97 71 140 1 2013415008 41592112 20888144
20:45:18 2461 8192000000 10976923792 11396878336 1990152512 19.545 100 80 158 0 2057733504 43710784 23870208
20:45:28 7206 8192000000 10962890832 11381805056 1965284944 19.348 99 71 142 0 2029870304 42939696 21645664
20:45:44 2928 8192000000 10963275328 11377954816 1972995152 19.409 100 77 153 0 2041358704 43886272 24477280
20:45:56 2776 8192000000 10952909408 11366838272 1967384048 19.365 100 80 160 1 2037129904 44783600 24962256
20:46:07 3235 8192000000 10971885552 11382263808 1976813440 19.439 100 89 178 1 2051445856 47420976 27211440
20:46:17 2677 8192000000 10961672928 11375439872 1972000608 19.401 100 88 175 2 2047150080 47957632 27191840
20:46:27 1033 8192000000 10915258080 11322347520 1909958832 18.906 98 90 180 1 1985911520 47124576 28828112
20:46:35 1992 8192000000 10948952704 11354947584 1951270176 19.237 100 88 176 1 2024678496 46914000 26494320
20:46:45 2238 8192000000 10943830304 11356872704 1951769472 19.241 100 85 168 0 2026404512 48400640 26234400
20:46:54 2760 8192000000 10954545920 11365089280 1956906768 19.281 100 80 161 2 2030660112 49013824 24739520
20:47:05 7649 8192000000 10960510080 11377283072 1965621808 19.351 100 79 153 1 2039449408 49964864 23862736
20:47:24 2139 8192000000 10956714448 11368067072 1959431728 19.302 100 77 153 1 2034259088 50705952 24121408
20:47:33 2278 8192000000 10974763472 11388690432 1975275104 19.427 100 87 174 4 2053672720 50929360 27468256
20:47:43 1489 8192000000 10944701008 11361742848 1950617728 19.231 99 87 174 1 2030496416 51692352 28186336
20:47:51 2051 8192000000 10944223168 11357564928 1938597088 19.136 99 83 164 3 2013235520 48591184 26047248
20:47:59 3249 8192000000 10942377584 11355561984 1945988944 19.195 100 77 153 1 2019186400 49003280 24194176
20:48:11 7543 8192000000 10936676704 11360165888 1948986784 19.218 100 81 162 2 2023099472 48654288 25458400
20:48:25 4736 8192000000 10938587856 11356962816 1947816416 19.209 100 76 151 1 2020792272 49781312 23194544
20:48:39 6968 8192000000 10929410000 11355897856 1946108944 19.195 100 51 102 2 2013759264 51481856 16168464
20:49:06 8539 8192000000 10913806192 11333480448 1902225088 18.844 98 48 96 0 1971501200 53792208 15483904
20:49:22 3308 8192000000 10957370096 11361574912 1949281312 19.221 100 82 159 0 2028765312 53969120 25514880
20:49:31 7391 8192000000 10924690064 11359092736 1930539664 19.071 99 57 113 1 2002497664 53931104 18026896
20:49:50 5018 8192000000 10938226544 11358470144 1952777184 19.249 100 59 116 1 2016379520 45430352 18171984
20:50:15 3977 8192000000 10941387504 11367452672 1954806848 19.265 100 66 132 1 2026643184 50515136 21321200
20:50:26 7019 8192000000 10918345760 11358953472 1931032352 19.075 99 47 92 0 1994851360 48794928 15024080
20:50:42 5099 8192000000 10938252656 11365855232 1950843536 19.233 100 53 104 1 2016568304 47996400 17728368
20:51:11 5365 8192000000 10922956400 11363733504 1947255472 19.205 100 43 86 0 2010421456 48014880 15151104
20:51:22 1922 8192000000 10912902096 11350040576 1928786416 19.057 99 43 86 0 1987176848 43961504 14428928
20:51:33 5571 8192000000 10916240000 11353096192 1944331264 19.181 100 39 77 5 2000819472 43914576 12573632
20:51:50 4966 8192000000 10942670464 11364311040 1961693504 19.319 100 71 138 0 2022540640 39031360 21815776
20:52:01 17773 8192000000 10910931280 11371933696 1955040320 19.267 100 32 64 1 2005873136 40565568 10267248
20:52:29 9124 8192000000 10915155408 11365601280 1949766752 19.225 100 24 48 0 1995882864 38155856 7960256
20:52:56 4207 8192000000 10890374656 11335942144 1921063648 18.995 99 36 72 1 1970700192 38337328 11299216
20:53:10 2377 8192000000 10909359968 11347369984 1939773472 19.145 100 39 78 2 1990628448 38703216 12151760
20:53:30 4643 8192000000 10929391600 11359191040 1953722608 19.256 100 45 89 0 2008678096 40975728 13979760
20:53:43 4937 8192000000 10923167088 11352514560 1936623632 19.120 99 54 108 1 1997502768 43672608 17206528
20:54:03 20290 8192000000 10918293792 11358846976 1927964848 19.051 99 40 80 1 1989373664 47562816 13846000
20:54:51 19140 8192000000 10914049360 11368665088 1939045776 19.139 100 26 52 0 1994370176 45876096 9448304
20:55:46 29472 8192000000 10891173072 11363237888 1924292592 19.021 99 16 32 1 1964921968 34902928 5726448
20:56:23 14400 8192000000 10896436880 11352621056 1933372656 19.094 100 14 28 2 1974109920 35730288 5006976
20:56:51 22248 8192000000 10902669408 11354210304 1935866288 19.114 100 20 41 1 1979839760 37183040 6790432
20:57:52 41454 8192000000 10880028288 11356721152 1942338112 19.165 100 12 24 0 1967648032 21761952 3547968
20:58:40 52823 8192000000 10874044032 11331100672 1919935120 18.986 98 10 20 0 1932364000 9754768 2674112
20:59:42 47473 8192000000 10892164480 11362795520 1960652256 19.311 100 7 14 0 1974530384 12140160 1737968
21:01:44 58337 8192000000 10913684800 11347976192 1933884272 19.098 98 29 55 2 1951365920 9614720 7866928
21:02:54 43233 8192000000 10911353680 11353014272 1933176352 19.092 98 36 73 0 1954554752 11256032 10122368
21:03:44 49338 8192000000 10902125952 11360321536 1953440000 19.254 99 30 60 3 1979014864 16171584 9403280
21:04:40 111632 8192000000 10898388176 11365146624 1943965200 19.178 99 18 36 1 1966683072 17180976 5536896
21:07:10 145809 8192000000 10899513920 11376676864 1906201280 18.876 97 12 24 2 1925305184 15655008 3448896
21:09:45 5177 8192000000 10906313120 11357745152 1970045600 19.386 100 32 64 0 1987484576 7902752 9536224
21:10:00 81761 8192000000 10928272016 11383738368 1986317232 19.515 100 33 66 1 2005447136 9739008 9390896
21:11:29 50494 8192000000 10923390704 11391770624 1973918592 19.417 99 31 62 0 1997334384 13601264 9814528
21:12:35 38215 8192000000 10932627088 11400953856 1995801200 19.590 100 25 50 2 2017905280 14612288 7491792
21:13:21 42076 8192000000 10929204784 11415724032 1997592432 19.604 100 8 16 0 2017047328 17320464 2134432
21:14:17 35793 8192000000 10910761568 11404873728 1978026416 19.449 99 7 14 0 1998405840 18423760 1955664
21:15:01 34280 8192000000 10919806400 11397361664 1991969888 19.559 100 13 26 0 2008519104 13124160 3425056
21:15:43 119510 8192000000 10920848704 11397214208 1960157216 19.307 98 12 24 0 1971384512 8043296 3184000
21:17:51 95277 8192000000 10913098464 11408556032 2000300800 19.625 100 11 22 0 2014369952 11179040 2890112
21:19:35 9691 8192000000 10924864032 11407015936 1999788112 19.621 100 18 34 1 2014586960 10352992 4445856
21:19:51 5758 8192000000 10922227680 11394019328 1986299296 19.515 99 54 106 0 2008547840 6419936 15828608
21:20:04 21132 8192000000 10918782400 11399647232 1996515504 19.595 100 14 28 0 2009613200 9580032 3517664
21:20:56 61056 8192000000 10907718400 11392327680 1942049648 19.163 97 13 26 0 1955889984 10204512 3635824
21:22:06 49853 8192000000 10904731136 11399290880 1987967264 19.528 100 5 10 0 2000016208 10736192 1312752
21:23:06 52930 8192000000 10915941728 11393376256 1970271376 19.388 99 2 4 0 1980100880 9474352 355152
21:24:05 61313 8192000000 10925025328 11396648960 1966183904 19.355 98 13 26 0 1978585616 8002000 4399712
21:25:20 24854 8192000000 10930419360 11391389696 1984077824 19.497 99 44 86 1 2007566640 10900400 12588416
21:25:57 58441 8192000000 10932334432 11413184512 1990078256 19.544 99 25 50 0 2011737008 14471968 7186784
21:27:03 104259 8192000000 10932272176 11401908224 1937970384 19.131 97 8 16 0 1951372496 11495248 1906864
21:29:00 67667 8192000000 10916337312 11395182592 1948393504 19.214 97 19 38 2 1966793552 13093856 5306192
21:30:17 49521 8192000000 10893630864 11357925376 1884873968 18.704 94 9 18 0 1903838096 16534352 2429776
21:31:13 71517 8192000000 10895317488 11371667456 1861486768 18.515 94 16 32 0 1884146864 17991632 4668464
21:33:05 56836 8192000000 10882491392 11351650304 1901432064 18.838 97 6 12 0 1919336560 16517568 1386928
21:34:10 72640 8192000000 10894298480 11373494272 1895109984 18.787 96 16 32 1 1913382928 13818736 4454208
21:35:29 92038 8192000000 10839491424 11310014464 1756557376 17.656 90 10 20 1 1772074400 12450976 3066048
21:37:13 154573 8192000000 10859831696 11319160832 1871987152 18.600 97 21 42 0 1890647376 12767616 5892608
21:40:00 66383 8192000000 10870712144 11340787712 1928714512 19.057 99 29 58 1 1948693728 11859696 8119520
21:41:12 9535 8192000000 10870280928 11346788352 1943375184 19.174 100 19 37 1 1960146384 11734176 5037024
21:41:50 17780 8192000000 10873651440 11336663040 1944076208 19.179 100 15 28 1 1951290176 3109008 4104960
21:42:22 64278 8192000000 10860753712 11335852032 1909278624 18.901 98 22 43 1 1924087376 8523072 6285680
21:43:32 83659 8192000000 10848929744 11328704512 1868132432 18.569 96 10 18 1 1879901232 8997712 2771088
21:45:08 82591 8192000000 10869677552 11346759680 1934915776 19.106 99 11 22 2 1952112304 13654288 3542240
21:46:38 49065 8192000000 10851893696 11330752512 1893276032 18.772 97 16 32 0 1911617376 13274800 5066544
21:47:46 57377 8192000000 10854048976 11334037504 1921413024 18.998 99 22 45 1 1942288736 13941312 6934400
21:48:50 56752 8192000000 10841032976 11337691136 1895956864 18.794 98 13 25 1 1910829056 10977920 3894272
21:49:55 69945 8192000000 10859998032 11323482112 1892555232 18.766 98 16 32 0 1906161456 8846624 4759600
21:51:13 48465 8192000000 10871991168 11337990144 1917629856 18.968 99 27 54 1 1943546480 18889504 7027120
21:52:16 50610 8192000000 10862048208 11334373376 1921651664 19.000 99 20 40 0 1936640832 9196496 5792672
21:53:18 56543 8192000000 10858630416 11327664128 1923247984 19.013 99 14 29 0 1936470608 8541776 4680848
21:54:23 45824 8192000000 10878309840 11332861952 1925839920 19.034 99 29 55 2 1942337440 8367904 8129616
21:55:19 32149 8192000000 10894987632 11353333760 1955677968 19.272 100 38 76 1 1977832528 11581904 10572656
21:55:59 30787 8192000000 10901215312 11346264064 1921519296 18.999 98 46 92 0 1945454176 11199968 12734912
21:56:43 54201 8192000000 10885617600 11347480576 1913360928 18.934 98 28 56 1 1931537440 10859232 7317280
21:57:51 76360 8192000000 10902481600 11365171200 1919030224 18.979 98 20 38 0 1936925072 12683664 5211184
21:59:13 142337 8192000000 10897352560 11372625920 1892629376 18.767 96 14 28 0 1911294208 15562592 3102240
22:01:53 81996 8192000000 10896042080 11364409344 1949668560 19.224 99 24 48 1 1968108288 10596784 7842944
22:03:35 61352 8192000000 10920355376 11386138624 1987095200 19.521 100 40 80 1 2012944992 14114912 11734880
22:04:44 8261 8192000000 10908837792 11376599040 1979112576 19.458 100 35 71 1 2002873184 13862416 9898192
22:04:59 31948 8192000000 10900406256 11376865280 1960186304 19.308 99 30 59 3 1984956672 16982672 7787696
22:07:02 60637 8192000000 10896134592 11379994624 1979121424 19.458 100 7 14 0 1992928544 11618832 2188288
22:08:16 44547 8192000000 10906284384 11383095296 1961265808 19.316 99 11 22 0 1976727968 12502544 2959616
22:09:13 80466 8192000000 10899222448 11384745984 1977466976 19.445 100 13 26 0 1993589488 11800944 4321568
22:10:43 57329 8192000000 10896669632 11368603648 1944091472 19.179 98 19 38 4 1958363616 8314736 5957408
22:13:07 52366 8192000000 10877520240 11349315584 1929464960 19.063 98 21 42 1 1943995040 8447968 6082112
22:14:05 71596 8192000000 10876581136 11360587776 1959753344 19.304 100 7 14 0 1972539232 10743344 2042544
22:15:45 93290 8192000000 10882305744 11373170688 1920948560 18.994 97 9 18 0 1938847216 15487776 2410880
22:17:24 70644 8192000000 10886126288 11372470272 1931978640 19.083 98 10 20 0 1948756608 14341584 2436384
22:18:42 43953 8192000000 10893300384 11356459008 1916623312 18.960 97 21 42 0 1930884864 8468096 5793456
22:19:32 78240 8192000000 10905540848 11379073024 1910313008 18.909 97 14 28 0 1925301344 11271536 3716800
22:21:03 57009 8192000000 10888645184 11362258944 1909393232 18.902 97 17 34 0 1927608912 13319504 4896176
22:22:18 57259 8192000000 10865969872 11328667648 1839528496 18.337 94 10 20 0 1856429488 14016800 2884192
22:23:25 32369 8192000000 10867423664 11334098944 1891612304 18.759 97 29 57 1 1910950928 11101792 8236832
22:24:25 47814 8192000000 10897530720 11354607616 1910163648 18.908 98 35 70 1 1933673472 13502000 10007824
22:25:20 15557 8192000000 10901976928 11358539776 1940657280 19.152 99 49 99 1 1967168592 12752416 13758896
22:25:46 64706 8192000000 10890351152 11362516992 1926409344 19.038 98 40 79 2 1956212400 18549280 11253776
22:27:00 52575 8192000000 9472848960 9777770496 615768352 6.991 32 8 16 0 624112960 6462752 1881856

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 17-06-2021 22:28:42 to 17-06-2021 22:29:14.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 86 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-06-2021 22:29:15 to 17-06-2021 22:29:17.

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          235177
MON$OLDEST_ACTIVE               236311
MON$OLDEST_SNAPSHOT             236311
MON$NEXT_TRANSACTION            236311
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                       2038752
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.33474 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33474 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33474 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33474 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 ---
:144: 
:145: mscs-test-161.budzdorov.ru    Thu Jun 17 22:27:58 2021
:146:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:147: 
--- end of diff output ---

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

17.06.21 22:29:18. 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-06-17 22:29:20 No severe PSQL-related problems occured
17.06.21 22:29:22. End of report.