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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17716488 kB
MemAvailable 31616508 kB
Buffers 0 kB
Cached 14024912 kB
SwapCached 1988 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 2020-12-08 19:27:04
DTS_END                         2020-12-08 19:27:04.1690
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/40446
TRN_ID                          246659
ATT_ID                          731
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: 9389.82 16710 1126778
customer order: creation 180.38 369 21645
customer order: refuse 15.32 283 1838
order to supplier: creation 48.08 1167 5769
order to supplier: removal 3.52 77793 422
invoice (draft): creation 48.23 3104 5787
invoice (draft): removal 52.07 731 6248
invoice accept: apply 44.06 17608 5287
invoice accept: cancel 46.67 586 5600
customer reserve: creation 4060.73 176 487288
customer reserve: removal 4593.42 45 551210
realization accept: apply 86.55 166 10386
realization accept: cancel 75.23 95 9028
payment from customer: creation 62.32 108 7478
payment from customer: removal 5.63 76 675
payment to supplier: creation 51.38 120 6165
payment to supplier: removal 3.39 61 407
service: total inventory turnovers 5.08 881 610
service: total monetary turnovers 6.94 33 833
service: aggregate perf. data 0.82 19209 98
service: refresh index statistics 0.03 211580 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-12-2020 19:28:51 to 08-12-2020 19:28:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8519
TEST_TIME 2 7468
TEST_TIME 3 6819
TEST_TIME 4 6463
TEST_TIME 5 6683
TEST_TIME 6 6892
TEST_TIME 7 6944
TEST_TIME 8 7314
TEST_TIME 9 7524
TEST_TIME 10 8080
TEST_TIME 11 8345
TEST_TIME 12 8372
TEST_TIME 13 9018
TEST_TIME 14 9297
TEST_TIME 15 9477
TEST_TIME 16 9375
TEST_TIME 17 9983
TEST_TIME 18 11155
TEST_TIME 19 11932
TEST_TIME 20 12115
TEST_TIME 21 12223
TEST_TIME 22 11720
TEST_TIME 23 11535
TEST_TIME 24 11340
TEST_TIME 25 11375
TEST_TIME 26 11595
TEST_TIME 27 11281
TEST_TIME 28 11113
TEST_TIME 29 11086
TEST_TIME 30 10887
TEST_TIME 31 11058
TEST_TIME 32 10969
TEST_TIME 33 10669
TEST_TIME 34 10607
TEST_TIME 35 10680
TEST_TIME 36 10560
TEST_TIME 37 10499
TEST_TIME 38 10304
TEST_TIME 39 10196
TEST_TIME 40 10113
TEST_TIME 41 10226
TEST_TIME 42 10250
TEST_TIME 43 10197
TEST_TIME 44 10153
TEST_TIME 45 10027
TEST_TIME 46 10357
TEST_TIME 47 10473
TEST_TIME 48 10381
TEST_TIME 49 10309
TEST_TIME 50 10292
TEST_TIME 51 10300
TEST_TIME 52 10419
TEST_TIME 53 10458
TEST_TIME 54 10311
TEST_TIME 55 10242
TEST_TIME 56 10238
TEST_TIME 57 10137
TEST_TIME 58 10087
TEST_TIME 59 10023
TEST_TIME 60 9943
TEST_TIME 61 9891
TEST_TIME 62 9813
TEST_TIME 63 9783
TEST_TIME 64 9841
TEST_TIME 65 9821
TEST_TIME 66 9858
TEST_TIME 67 9839
TEST_TIME 68 9881
TEST_TIME 69 9840
TEST_TIME 70 9815
TEST_TIME 71 9875
TEST_TIME 72 9824
TEST_TIME 73 9863
TEST_TIME 74 9899
TEST_TIME 75 9899
TEST_TIME 76 9867
TEST_TIME 77 9841
TEST_TIME 78 9752
TEST_TIME 79 9711
TEST_TIME 80 9693
TEST_TIME 81 9671
TEST_TIME 82 9620
TEST_TIME 83 9626
TEST_TIME 84 9591
TEST_TIME 85 9643
TEST_TIME 86 9603
TEST_TIME 87 9569
TEST_TIME 88 9667
TEST_TIME 89 9634
TEST_TIME 90 9659
TEST_TIME 91 9658
TEST_TIME 92 9625
TEST_TIME 93 9706
TEST_TIME 94 9690
TEST_TIME 95 9680
TEST_TIME 96 9690
TEST_TIME 97 9668
TEST_TIME 98 9602
TEST_TIME 99 9551
TEST_TIME 100 9554
TEST_TIME 101 9495
TEST_TIME 102 9442
TEST_TIME 103 9432
TEST_TIME 104 9397
TEST_TIME 105 9379
TEST_TIME 106 9424
TEST_TIME 107 9432
TEST_TIME 108 9459
TEST_TIME 109 9479
TEST_TIME 110 9492
TEST_TIME 111 9484
TEST_TIME 112 9508
TEST_TIME 113 9518
TEST_TIME 114 9569
TEST_TIME 115 9556
TEST_TIME 116 9557
TEST_TIME 117 9497
TEST_TIME 118 9483
TEST_TIME 119 9450
TEST_TIME 120 9393

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 08-12-2020 19:28:54 to 08-12-2020 19:28:58.

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 1575982 1575982 0 0.00 0 41318 6 0 0
doc_list_biud 1575982 1575982 0 0.00 0 23555 21 0 0
sp_add_invoice_to_stock 5406 5287 119 2.20 22 190560 17609 0 119
sp_cancel_adding_invoice 5600 5600 0 0.00 6 42917 586 0 0
sp_cancel_client_order 1838 1838 0 0.00 4 15947 283 0 0
sp_cancel_customer_reserve 551210 551210 0 0.00 1 21002 46 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 2 6113 77 0 0
sp_cancel_pay_to_supplier 407 407 0 0.00 3 2613 61 0 0
sp_cancel_supplier_invoice 6254 6248 6 0.09 2 23561 731 0 6
sp_cancel_supplier_order 422 422 0 0.00 7 897702 77794 0 0
sp_cancel_write_off 9028 9028 0 0.00 1 10781 96 0 0
sp_client_order 21645 21645 0 0.00 3 25786 369 0 0
sp_customer_reserve 487288 487288 0 0.00 0 70290 176 0 0
sp_fill_shopping_cart 33201 33201 0 0.00 1 26939 39 0 0
sp_fill_shopping_cart_clo_res 487269 487269 0 0.00 0 20974 13 0 0
sp_get_clo_for_invoice 5268 5268 0 0.00 0 26899 310 0 0
sp_kill_cost_storno 15710 15710 0 0.00 0 7955 43 0 0
sp_kill_qstorno_ret_qs2qd 1118118 1118118 0 0.00 0 23551 25 0 0
sp_kill_qty_storno 590000 590000 0 0.00 0 23553 55 0 0
sp_lock_selected_doc 21381 21381 0 0.00 0 9630 7 0 0
sp_make_cost_storno 29297 29297 0 0.00 0 41311 49 0 0
sp_multiply_rows_for_pdistr 29297 29297 0 0.00 0 18580 27 0 0
sp_multiply_rows_for_qdistr 21645 21645 0 0.00 0 22160 172 0 0
sp_pay_from_customer 7478 7478 0 0.00 4 19847 108 0 0
sp_pay_to_supplier 6165 6165 0 0.00 4 18650 120 0 0
sp_payment_common 13643 13643 0 0.00 1 7040 20 0 0
sp_qd_handle_on_cancel_clo 1838 1838 0 0.00 0 15940 253 0 0
sp_qd_handle_on_invoice_upd_sts 10868 10868 0 0.00 0 12178 261 0 0
sp_qd_handle_on_reserve_upd_sts 10386 10386 0 0.00 0 18968 60 0 0
sp_reserve_write_off 10386 10386 0 0.00 6 25280 167 0 0
sp_supplier_invoice 5787 5787 0 0.00 7 90322 3104 0 0
sp_supplier_order 5769 5769 0 0.00 5 30705 1168 0 0
srv_aggregate_perf_data 98 98 0 0.00 2179 449870 19210 0 0
srv_fill_mon_cache_memory 150 150 0 0.00 884 155143 36990 0 0
srv_find_qd_qs_mism 1075631 1075631 0 0.00 0 20524 6 0 0
srv_make_invnt_saldo 610 610 0 0.00 41 34689 881 0 0
srv_make_money_saldo 833 833 0 0.00 1 12838 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 135851 286206 211580 0 0
t$perf-abend:sp_add_invoice_to_stock 119 119 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 5287 5287 0 0.00 0 23274 184 0 0
t$perf-norm:sp_cancel_adding_invoice 376 376 0 0.00 0 4259 87 0 0
t$perf-norm:sp_cancel_client_order 1838 1838 0 0.00 0 3657 12 0 0
t$perf-norm:sp_cancel_customer_reserve 656 656 0 0.00 0 3489 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 1229 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 407 407 0 0.00 0 7934 21 0 0
t$perf-norm:sp_cancel_supplier_invoice 442 442 0 0.00 0 6369 28 0 0
t$perf-norm:sp_cancel_supplier_order 422 422 0 0.00 0 15096 1257 0 0
t$perf-norm:sp_cancel_write_off 918 918 0 0.00 0 2144 8 0 0
t$perf-norm:sp_client_order 21645 21645 0 0.00 0 10597 17 0 0
t$perf-norm:sp_customer_reserve 1008 1008 0 0.00 0 6165 17 0 0
t$perf-norm:sp_pay_from_customer 7478 7478 0 0.00 0 21963 17 0 0
t$perf-norm:sp_pay_to_supplier 6165 6165 0 0.00 0 7430 9 0 0
t$perf-norm:sp_reserve_write_off 10386 10386 0 0.00 0 13803 12 0 0
t$perf-norm:sp_supplier_invoice 5787 5787 0 0.00 0 7367 17 0 0
t$perf-norm:sp_supplier_order 5769 5769 0 0.00 0 7451 16 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 81 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 150 150 0 0.00 0 797 11 0 0
t$perf-norm:srv_make_invnt_saldo 610 610 0 0.00 0 743 11 0 0
t$perf-norm:srv_make_money_saldo 833 833 0 0.00 0 4751 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 456 115 0 0
v_add_invoice_to_stock 10762 10524 238 2.21 0 5483 21 0 238
v_all_customers 39520 39520 0 0.00 0 18 0 0 0
v_all_suppliers 32004 32004 0 0.00 0 19 1 0 0
v_all_wares 43290 43290 0 0.00 0 104 1 0 0
v_cancel_adding_invoice 752 752 0 0.00 0 2329 10 0 0
v_cancel_client_order 3676 3676 0 0.00 0 3047 7 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 5679 12 0 0
v_cancel_customer_reserve 1312 1312 0 0.00 0 1554 5 0 0
v_cancel_payment_to_supplier 814 814 0 0.00 0 451 3 0 0
v_cancel_supplier_invoice 896 884 12 1.33 0 1407 17 0 12
v_cancel_supplier_order 844 844 0 0.00 0 2567 7 0 0
v_cancel_write_off 1836 1836 0 0.00 0 6925 25 0 0
v_max_id_clo_ord 5769 5769 0 0.00 0 679 1 0 0
v_max_id_clo_res 1008 1008 0 0.00 0 1675 8 0 0
v_max_id_ord_sup 5787 5787 0 0.00 0 6618 7 0 0
v_max_non_paid_invoice 1719 1719 0 0.00 0 1167 2 0 0
v_max_non_paid_realizn 3970 3970 0 0.00 0 5692 4 0 0
v_min_id_clo_ord 5769 5769 0 0.00 0 2713 6 0 0
v_min_id_clo_res 1008 1008 0 0.00 0 2404 8 0 0
v_min_id_ord_sup 5787 5787 0 0.00 0 7166 7 0 0
v_min_non_paid_invoice 6165 6165 0 0.00 0 7036 14 0 0
v_min_non_paid_realizn 7478 7478 0 0.00 0 6183 11 0 0
v_our_firm 10786 10786 0 0.00 0 246 1 0 0
v_reserve_write_off 20770 20770 0 0.00 0 6093 7 0 0
x_lock_depdocs_on_canc_invoice 11406 11406 0 0.00 0 13405 91 0 0
x_lock_depdocs_on_canc_sup_ord 422 422 0 0.00 0 8895 262 0 0
x_make_qstorno_1000_1200 5769 5769 0 0.00 2 30692 1101 0 0
x_make_qstorno_1200_2000 5787 5787 0 0.00 3 87975 2950 0 0
x_make_qstorno_2100_3300 487288 487288 0 0.00 0 70252 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-12-2020 19:28:59 to 08-12-2020 19:29:03.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:07 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:13 18988 8192000000 10262614832 10568175616 885565664 9.755 70 59 122 0 907904128 2374816 19963648
16:57:40 30087 8192000000 10354632752 10673278976 1388831664 14.495 100 87 173 0 1421932496 4909040 28191792
16:58:18 31808 8192000000 10402637040 10726129664 1447368736 15.015 100 93 186 0 1484967840 6905904 30693200
16:59:07 23251 8192000000 10436083328 10766725120 1479707952 15.299 100 87 175 2 1515918224 7978544 28231728
16:59:37 18295 8192000000 10450697248 10785083392 1503353408 15.505 100 91 182 0 1541524672 8875008 29296256
17:00:03 22582 8192000000 10458341648 10799525888 1512769552 15.587 100 86 172 0 1549333184 9255552 27308080
17:00:34 27560 8192000000 10489400480 10831773696 1542844704 15.848 100 90 180 0 1580975232 9869952 28260576
17:01:09 15977 8192000000 10515666176 10860969984 1562356704 16.017 100 80 160 1 1597195872 9942896 24896272
17:01:34 11893 8192000000 10517244192 10871533568 1586776592 16.226 100 83 166 0 1622568592 10618064 25173936
17:01:55 20562 8192000000 10560484816 10917564416 1610800320 16.432 100 73 143 2 1642564240 10338416 21425504
17:02:24 11650 8192000000 10582194032 10940936192 1635403472 16.641 100 83 166 2 1671639232 11333872 24901888
17:02:44 10541 8192000000 10587174624 10949365760 1646615328 16.736 100 80 160 2 1682347760 11838320 23894112
17:03:03 11912 8192000000 10607811760 10974531584 1665301232 16.894 100 76 152 0 1699278736 11865200 22112304
17:03:25 8823 8192000000 10629198928 10996510720 1689946320 17.101 100 84 168 3 1726860000 12945040 23968640
17:03:41 8650 8192000000 10646163472 11014799360 1705950128 17.235 100 79 158 2 1741148592 12658688 22539776
17:03:58 5703 8192000000 10658840528 11029970944 1719152048 17.345 100 79 158 1 1755173456 13195184 22826224
17:04:12 5627 8192000000 10670766192 11043356672 1730534224 17.440 100 82 164 0 1767437168 13648352 23254592
17:04:26 5951 8192000000 10663829472 11046649856 1733952784 17.468 100 68 136 0 1766671744 13726544 18992416
17:04:40 3452 8192000000 10694026896 11071946752 1751925632 17.618 100 84 169 1 1792713184 17092496 23695056
17:04:50 4627 8192000000 10700419408 11077967872 1757149888 17.661 100 72 145 1 1790317184 13579216 19588080
17:05:06 6974 8192000000 10694702528 11080986624 1762319760 17.704 100 73 146 0 1795468288 12687072 20461456
17:05:20 3623 8192000000 10725161872 11103408128 1777946160 17.833 100 84 165 1 1814217440 13229680 23041600
17:05:30 3436 8192000000 10721392128 11107618816 1784866592 17.890 100 77 155 2 1819840192 13275104 21698496
17:05:40 3384 8192000000 10738155440 11119890432 1798655920 18.003 100 83 164 2 1834426448 12899424 22871104
17:05:51 2700 8192000000 10742658288 11129397248 1806105856 18.064 100 83 166 0 1843535984 13720144 23709984
17:06:00 2467 8192000000 10755943344 11137249280 1818546032 18.166 100 88 177 1 1856066656 13313056 24207568
17:06:09 2469 8192000000 10763021264 11148201984 1819298336 18.172 100 84 169 0 1856783568 13610720 23874512
17:06:18 2432 8192000000 10775484128 11157901312 1828864848 18.250 100 95 191 1 1870815648 14918720 27032080
17:06:27 2288 8192000000 10769388992 11157090304 1832002112 18.276 100 86 170 0 1870085984 13959856 24124016
17:06:36 1972 8192000000 10782857472 11166937088 1842510496 18.361 100 91 183 3 1880782752 12335936 25936320
17:06:44 1730 8192000000 10786800352 11171643392 1846332704 18.392 100 89 176 1 1883806448 13011696 24462048
17:06:53 2011 8192000000 10796828048 11181142016 1851480848 18.434 100 94 188 1 1892634384 14320672 26832864
17:07:01 1617 8192000000 10799311696 11182690304 1850370496 18.425 100 93 186 1 1889064368 13520640 25173232
17:07:10 1866 8192000000 10801861776 11187769344 1854677792 18.460 100 93 186 0 1895860016 15165520 26016704
17:07:18 1261 8192000000 10803548608 11189276672 1859626288 18.500 100 89 176 4 1896560144 13231664 23702192
17:07:25 1550 8192000000 10811681568 11198287872 1864504224 18.540 100 87 174 4 1902243600 13108064 24631312
17:07:33 2355 8192000000 10814167296 11198451712 1866364512 18.555 100 94 188 1 1906841072 13446176 27030384
17:07:42 2259 8192000000 10797519504 11196854272 1862035968 18.520 100 68 136 1 1894539712 13024912 19478832
17:07:51 3396 8192000000 10784381024 11192111104 1860240176 18.505 100 52 104 0 1888250368 13261664 14748528
17:08:01 7601 8192000000 10769162864 11193413632 1864149840 18.537 100 41 82 1 1884943712 9145872 11648000
17:08:16 5301 8192000000 10787393296 11197972480 1870079424 18.585 100 37 72 2 1886767392 6612656 10075312
17:08:28 11887 8192000000 10794673440 11206811648 1874499136 18.621 100 31 61 4 1889106464 5591920 9015408
17:08:48 58878 8192000000 10801357632 11221958656 1881494448 18.677 100 43 86 4 1899650416 5224384 12931584
17:09:53 8904 8192000000 10804175824 11224625152 1880448944 18.669 100 22 44 1 1891872672 4898272 6525456
17:10:08 6803 8192000000 10785520352 11218149376 1880293264 18.667 100 20 40 1 1891857248 6186464 5377520
17:10:22 5939 8192000000 10801668288 11227578368 1883983232 18.697 100 32 64 3 1899659872 7278976 8397664
17:10:36 9082 8192000000 10792817824 11227123712 1884328816 18.700 100 25 49 2 1898296272 7246464 6720992
17:10:53 4826 8192000000 10794732752 11222929408 1883778688 18.696 100 23 46 1 1899615904 9145424 6691792
17:11:05 6507 8192000000 10792232832 11225772032 1883490832 18.693 100 21 40 3 1895642112 6081472 6069808
17:11:17 7073 8192000000 10797319008 11227811840 1884619456 18.702 100 20 40 3 1895912512 5304304 5988752
17:11:32 5452 8192000000 10804188496 11232346112 1887278384 18.724 100 27 54 1 1901097728 5626384 8192960
17:11:44 8626 8192000000 10798521440 11234312192 1887897136 18.729 100 21 43 0 1900462800 6082448 6483216
17:12:03 9461 8192000000 10796387040 11233046528 1888385152 18.733 100 15 30 0 1898197008 5470944 4340912
17:12:19 8192 8192000000 10795650608 11232710656 1889185056 18.739 100 19 38 1 1900693904 6162352 5346496
17:12:35 8995 8192000000 10798707968 11232436224 1889246304 18.740 100 12 25 0 1897751472 5503984 3001184
17:12:53 13932 8192000000 10803650304 11237236736 1897734672 18.808 100 23 46 1 1910709488 6615648 6359168
17:13:15 9028 8192000000 10812986736 11244695552 1898297936 18.813 100 17 33 2 1908329824 5468656 4563232
17:13:30 25771 8192000000 10810901856 11245932544 1900194944 18.828 100 23 46 1 1914035968 5214960 8626064
17:14:22 19953 8192000000 10862169552 11259846656 1913419664 18.934 100 82 168 5 1944675744 7145328 24110752
17:14:48 4973 8192000000 10820123568 11254763520 1905282512 18.869 100 36 72 3 1923940000 9198800 9458688
17:15:01 7671 8192000000 10816346672 11247906816 1902828944 18.849 100 24 48 3 1915785360 5790720 7165696
17:15:16 4234 8192000000 10835963968 11259490304 1904643696 18.864 100 34 68 3 1919897440 6208384 9045360
17:15:30 5426 8192000000 10810431152 11237965824 1876701504 18.638 99 29 58 1 1891666272 7217648 7747120
17:15:42 5968 8192000000 10805983024 11236380672 1871460640 18.596 99 36 72 1 1892873792 11734736 9678416
17:15:54 5184 8192000000 10819930624 11251163136 1899541664 18.823 100 39 78 0 1922170928 11342032 11287232
17:16:06 5526 8192000000 10817608448 11238043648 1859947232 18.503 98 31 61 0 1874635616 5712736 8975648
17:16:19 8277 8192000000 10794969168 11221422080 1835529744 18.304 97 27 55 2 1849273584 6128752 7615088
17:16:34 6456 8192000000 10778601008 11217719296 1861766752 18.518 99 25 50 0 1875788160 5583648 8437760
17:16:47 8844 8192000000 10766138448 11193810944 1806143376 18.064 96 24 48 3 1818234400 5495536 6595488
17:17:05 56973 8192000000 10738275840 11141283840 1715145408 17.312 92 30 59 1 1728245360 5220128 7879824
17:18:08 4984 8192000000 10731679664 11152060416 1803659792 18.044 99 45 90 1 1829652480 13786480 12206208
17:18:23 7930 8192000000 10740811584 11153022976 1740043728 17.519 95 39 76 4 1756629440 5449728 11135984
17:18:39 6855 8192000000 10697959664 11103272960 1726884912 17.410 95 29 56 3 1739996560 5445024 7666624
17:18:52 11282 8192000000 10720783904 11121786880 1753262112 17.629 97 37 74 3 1769505776 5780368 10463296
17:19:11 9499 8192000000 10692671136 11114684416 1751248512 17.612 97 24 48 3 1764756064 6239680 7267872
17:19:27 6557 8192000000 10717894848 11129884672 1756213008 17.653 97 25 50 1 1769151824 5637568 7301248
17:19:46 6734 8192000000 10708914416 11128107008 1771383136 17.778 98 23 46 3 1783507328 5984160 6140032
17:19:59 7518 8192000000 10701552928 11111731200 1718796256 17.342 96 19 38 1 1737782544 14102592 4883696
17:20:13 8313 8192000000 10667928608 11079634944 1700714064 17.191 95 27 54 1 1714483504 5712560 8056880
17:20:28 5762 8192000000 10702745376 11116888064 1789588960 17.928 100 31 61 0 1805577648 6349056 9639632
17:20:44 15752 8192000000 10725058416 11138764800 1791183664 17.942 99 31 63 2 1807356208 5842816 10329728
17:21:06 57718 8192000000 10724892256 11134644224 1788438736 17.919 98 42 80 2 1804082592 4145424 11498432
17:22:10 10979 8192000000 10713949184 11132329984 1778621360 17.838 98 32 64 0 1795229168 7101936 9505872
17:22:27 7711 8192000000 10753329568 11157975040 1820695280 18.183 100 30 59 2 1835189248 5945888 8548080
17:22:44 8246 8192000000 10747303040 11166310400 1829043376 18.252 100 32 64 3 1844705456 5968096 9693984
17:22:59 6808 8192000000 10750550608 11172700160 1835640464 18.305 100 34 68 1 1851954960 6048048 10266448
17:23:12 6543 8192000000 10766762976 11185065984 1840498256 18.345 100 22 44 1 1857019376 10321712 6199408
17:23:25 4520 8192000000 10759950320 11181584384 1844646544 18.379 100 35 71 1 1862061328 7564096 9850688
17:23:39 7246 8192000000 10772782960 11191459840 1846157728 18.391 100 12 24 1 1854751808 4984272 3609808
17:23:52 10155 8192000000 10769824144 11195432960 1853707248 18.452 100 15 30 0 1863371904 5816128 3848528
17:24:13 6795 8192000000 10773713872 11200237568 1861857776 18.518 100 24 48 2 1873651392 5420656 6372960
17:24:25 12236 8192000000 10775798624 11203104768 1861536176 18.516 100 17 34 4 1871721760 5356160 4829424
17:24:50 11988 8192000000 10778019904 11210194944 1866084224 18.553 100 16 32 1 1876361264 5791920 4485120
17:25:13 12438 8192000000 10773212848 11210956800 1869790816 18.583 100 18 35 1 1880198416 5018128 5389472
17:25:32 60631 8192000000 10790203328 11219214336 1876464336 18.637 100 31 59 1 1890958592 4003520 10490736
17:26:39 23400 8192000000 10796529920 11226816512 1872436240 18.604 100 14 28 0 1882079040 5921168 3721632
17:27:11 33042 8192000000 10834475792 11255537664 1903954752 18.858 100 50 100 1 1926212880 8301888 13956240
17:27:52 9810 8192000000 10852634928 11269439488 1919800144 18.985 100 53 104 1 1943731824 10072336 13859344
17:28:14 14383 8192000000 10865091056 11282251776 1927599184 19.048 100 60 120 1 1955852384 11246224 17006976
17:28:40 11091 8192000000 10871468976 11292700672 1937065776 19.123 100 56 112 6 1964888448 11259520 16563152
17:28:59 2043 8192000000 10871884768 11297239040 1941956672 19.162 100 48 96 0 1967160656 11531440 13672544
17:29:09 15888 8192000000 10881470768 11305771008 1947872448 19.210 100 48 97 1 1972492912 11328320 13292144
17:29:33 57532 8192000000 10888911712 11326201856 1949074272 19.219 100 35 69 2 1971737808 12889808 9773728
17:30:42 26517 8192000000 10895829280 11332841472 1961418352 19.317 100 35 69 2 1985718048 14907952 9391744
17:31:20 24275 8192000000 10917774480 11347148800 1970034352 19.386 100 45 89 1 2000444832 17502480 12908000
17:31:52 4429 8192000000 10922922112 11344461824 1972625264 19.406 100 55 106 2 2008641744 21114656 14901824
17:32:04 8317 8192000000 10922981456 11351121920 1976585824 19.438 100 55 110 1 2016527472 24025856 15915792
17:32:26 11411 8192000000 10922014448 11352297472 1979705936 19.462 100 58 116 0 2019700320 23533152 16461232
17:32:50 13170 8192000000 10917860048 11357978624 1981947072 19.480 100 42 85 0 2017091600 22603376 12541152
17:33:11 17094 8192000000 10938212816 11368763392 1985763824 19.510 100 45 89 2 2020351680 21249200 13338656
17:33:35 4081 8192000000 10941962240 11374903296 1996411040 19.594 100 52 104 0 2035019424 23637872 14970512
17:33:48 2413 8192000000 10966827424 11381719040 2002580304 19.643 100 73 144 3 2049284656 24479040 22225312
17:33:57 4147 8192000000 10955488656 11378864128 1997531792 19.603 100 70 138 3 2043584960 25340160 20713008
17:34:11 11170 8192000000 10960882432 11390337024 1998344272 19.610 100 56 112 0 2044992128 30240208 16407648
17:34:32 8772 8192000000 10955739776 11390685184 2001677728 19.636 100 60 120 1 2049146720 29392224 18076768
17:34:57 7371 8192000000 10962769680 11395067904 2008604960 19.691 100 54 106 1 2053702880 28652224 16445696
17:35:16 9831 8192000000 10974720256 11406696448 2018897456 19.771 100 51 102 0 2065399856 30919584 15582816
17:35:34 6331 8192000000 10988796752 11418378240 2022853696 19.803 100 53 106 0 2071058592 31518336 16686560
17:35:48 5995 8192000000 10963398672 11400003584 1984293216 19.499 98 54 108 2 2033193360 32229616 16670528
17:36:00 2819 8192000000 10982591536 11410374656 2020947472 19.788 100 73 146 1 2073708192 30747184 22013536
17:36:16 2374 8192000000 10978143536 11407540224 2019792880 19.779 100 65 131 2 2071724960 31487808 20444272
17:36:28 5467 8192000000 10984244704 11407396864 2004098016 19.655 99 69 136 3 2057281296 31903056 21280224
17:36:40 3582 8192000000 10981564080 11398332416 2003967520 19.654 100 64 128 2 2057454592 33174816 20312256
17:36:52 2588 8192000000 10979464800 11395997696 2003312560 19.649 100 78 154 1 2060077568 34202016 22562992
17:37:01 4657 8192000000 10981482688 11403558912 2007476400 19.682 100 74 148 5 2069590960 39133680 22980880
17:37:13 1390 8192000000 10980354608 11393667072 2001781456 19.637 100 85 169 1 2060823152 34189312 24852384
17:37:21 2441 8192000000 10981419872 11393720320 1987696864 19.526 99 88 176 0 2050840992 36522784 26621344
17:37:32 2204 8192000000 10963385872 11375398912 1967356928 19.364 98 90 178 1 2031091664 37198016 26536720
17:37:43 1722 8192000000 10963793696 11377762304 1981313600 19.475 99 87 174 3 2044495776 37426592 25755584
17:37:55 2398 8192000000 10971440096 11390582784 1996031504 19.591 100 82 163 2 2058302256 38073408 24197344
17:38:05 3293 8192000000 10957400752 11373539328 1974805008 19.424 100 87 172 0 2040556432 39348688 26402736
17:38:15 1374 8192000000 10953373360 11367206912 1972356400 19.404 100 90 180 1 2039674288 39969472 27348416
17:38:24 8722 8192000000 10959281264 11380748288 1980287760 19.467 100 71 143 1 2043146016 41449296 21408960
17:38:41 2976 8192000000 10961615824 11376914432 1967937360 19.369 99 84 165 1 2030023600 38057504 24028736
17:38:54 13945 8192000000 10958330400 11386236928 1986982304 19.520 100 64 126 3 2045425904 39197936 19245664
17:39:21 2419 8192000000 10962896256 11391533056 1989192720 19.537 100 63 126 0 2049640128 41273248 19174160
17:39:33 2053 8192000000 10986009824 11405729792 1999286416 19.617 100 82 165 2 2070102752 44514080 26302256
17:39:41 3855 8192000000 10980049440 11399245824 1992543936 19.564 100 73 145 3 2060744240 45207536 22992768
17:39:52 8104 8192000000 10963753120 11394752512 1987369152 19.523 100 61 119 0 2053309552 46514736 19425664
17:40:07 3013 8192000000 10963663664 11388694528 1977864816 19.448 100 67 133 0 2046612768 46588608 22159344
17:40:17 2476 8192000000 10936408448 11356372992 1930157344 19.068 98 70 139 5 2004526768 52553248 21816176
17:40:27 1714 8192000000 10917593520 11324612608 1910205664 18.908 99 83 165 1 1984471648 48413216 25852768
17:40:36 2748 8192000000 10940832016 11348066304 1944203168 19.180 100 82 164 2 2015905536 47326096 24376272
17:40:45 6316 8192000000 10927411744 11347578880 1946738016 19.200 100 73 146 1 2018012224 49205840 22068368
17:40:58 881 8192000000 10920334416 11320238080 1931329056 19.078 99 93 187 3 2004145440 43620880 29195504
17:41:06 13694 8192000000 10882038512 11308769280 1862603392 18.524 96 44 89 0 1916699552 40507168 13588992
17:41:27 6800 8192000000 10889827008 11318362112 1918445088 18.974 100 47 94 1 1975120848 41167584 15508176
17:41:42 10393 8192000000 10901543296 11327774720 1929397008 19.062 100 47 94 1 1984303360 39707136 15199216
17:41:59 11860 8192000000 10895514704 11326185472 1911902016 18.922 99 47 92 3 1970244160 43241584 15100560
17:42:19 8854 8192000000 10890154640 11324968960 1918334272 18.973 100 38 74 1 1976562368 45553248 12674848
17:42:41 10460 8192000000 10890713088 11333160960 1915190576 18.948 99 37 74 0 1973712272 45808304 12713392
17:43:04 11957 8192000000 10915778768 11345342464 1932152528 19.084 100 37 74 4 1991052656 45277424 13622704
17:43:26 16999 8192000000 10889616192 11321319424 1872461648 18.604 97 34 68 1 1934680096 49826000 12392448
17:43:50 14771 8192000000 10897391136 11337682944 1918927808 18.978 100 35 70 1 1983391776 52032336 12431632
17:44:12 27134 8192000000 10880651824 11325886464 1878625856 18.654 98 23 46 1 1940775232 53054480 9094896
17:44:45 18294 8192000000 10874256672 11321389056 1878902352 18.656 98 38 77 2 1940038704 48314704 12821648
17:45:10 13552 8192000000 10877702928 11320455168 1905303632 18.869 100 33 66 1 1964626464 48020976 11301856
17:45:29 28601 8192000000 10874423296 11331723264 1880828944 18.672 98 19 38 1 1931252848 43586944 6836960
17:46:04 17038 8192000000 10876330832 11315785728 1882307584 18.684 98 24 48 1 1926774800 36543568 7923648
17:46:30 31660 8192000000 10857392784 11310686208 1897239616 18.804 99 21 43 1 1936339168 32415488 6684064
17:47:08 40612 8192000000 10833109232 11290550272 1859014576 18.495 97 14 28 3 1879298576 16043136 4240864
17:47:55 30295 8192000000 10835779744 11282411520 1825635840 18.224 96 13 26 1 1849023296 19241968 4145488
17:48:32 60890 8192000000 10843951280 11281948672 1880987088 18.673 98 33 66 2 1904449712 14022016 9440608
17:50:22 52756 8192000000 10809755136 11247607808 1830819504 18.266 96 27 54 0 1856731040 18097136 7814400
17:51:40 38578 8192000000 10833288288 11286466560 1897253408 18.804 100 18 36 1 1926000192 23500768 5246016
17:52:25 21183 8192000000 10836187744 11297058816 1899041552 18.819 100 7 14 0 1926676320 24624864 3009904
17:52:53 21897 8192000000 10837401552 11300200448 1902944960 18.850 100 16 31 1 1933640912 25381984 5313968
17:53:21 11774 8192000000 10842424704 11303952384 1904848416 18.865 100 8 16 0 1935435152 27884176 2702560
17:54:28 49965 8192000000 10827359424 11272163328 1883394784 18.693 99 32 66 3 1906142976 12906528 9841664
17:55:24 65575 8192000000 10845062640 11291029504 1884346496 18.700 99 16 32 0 1901709296 12988064 4374736
17:56:37 36191 8192000000 10825992128 11283443712 1884778096 18.704 99 14 28 1 1902787808 14370864 3638848
17:57:19 35311 8192000000 10856191616 11302014976 1914792032 18.945 100 16 32 0 1934689776 15546160 4351584
17:58:02 73977 8192000000 10844345168 11297771520 1865290736 18.546 97 18 36 0 1880536112 10402608 4842768
17:59:27 104248 8192000000 10863542080 11310166016 1926449904 19.038 100 29 56 1 1940224560 5913088 7861568
18:01:18 46068 8192000000 10887603488 11327242240 1940411840 19.150 100 43 86 3 1962310288 9912288 11986160
18:02:14 62746 8192000000 10856593200 11318104064 1910151680 18.908 98 21 42 1 1928322096 12202832 5967584
18:03:23 20205 8192000000 10860232496 11325722624 1939652160 19.144 100 7 14 0 1954546736 12536272 2358304
18:03:52 104723 8192000000 10869998160 11336081408 1935738272 19.113 99 8 16 1 1948594016 10609120 2246624
18:05:56 60310 8192000000 10882428576 11348238336 1957748768 19.288 100 19 36 2 1972366048 9499840 5117440
18:07:22 46076 8192000000 10882553408 11344580608 1949120528 19.219 99 38 76 0 1970608288 10185328 11302432
18:08:35 77887 8192000000 10895187248 11382910976 1970873008 19.392 100 11 22 0 1991554112 17218368 3462736
18:10:00 65804 8192000000 10910339360 11368275968 1955798176 19.273 99 16 32 1 1968095376 8416192 3881008
18:11:36 28763 8192000000 10923615824 11378905088 1972103344 19.402 99 21 42 1 1992496384 13974848 6418192
18:12:28 75544 8192000000 10917241472 11389296640 1972209536 19.403 99 23 46 0 1998869424 19998432 6661456
18:13:50 40282 8192000000 10913914992 11389120512 1966997312 19.362 99 13 27 0 1990893120 19990848 3904960
18:14:41 90954 8192000000 10927052592 11382771712 1990293680 19.546 100 29 57 1 2009905632 10504848 9107104
18:16:18 15420 8192000000 10930518880 11367616512 1958336864 19.293 98 53 107 2 1982493968 9430112 14726992
18:16:41 12320 8192000000 10938542080 11380359168 1991575264 19.556 100 54 108 0 2017197136 10845632 14776240
18:17:01 20041 8192000000 10941356720 11392430080 1993093040 19.568 100 47 94 1 2018269840 12455040 12721760
18:17:28 13977 8192000000 10936978592 11385290752 1977411200 19.444 99 38 76 0 1998307216 10595296 10300720
18:17:52 22766 8192000000 10932135584 11375628288 1951206896 19.236 98 43 86 0 1974845520 11674624 11964000
18:18:23 41872 8192000000 10928909520 11384762368 1966435920 19.357 99 34 68 1 1991989808 16485568 9068320
18:19:17 44191 8192000000 10915462752 11395493888 1976368336 19.436 100 21 42 2 2000568272 18485376 5714560
18:20:09 75799 8192000000 10911968528 11340447744 1852151328 18.440 93 28 54 1 1871803232 11800896 7851008
18:21:34 104769 8192000000 10880983504 11356336128 1949623968 19.223 99 31 62 1 1967945424 9592832 8728624
18:23:33 37615 8192000000 10863880576 11341078528 1909884000 18.906 97 12 24 1 1923910656 10196528 3830128
18:24:56 60634 8192000000 10832867952 11305914368 1866290544 18.554 96 13 26 2 1885271088 15192496 3788048
18:26:54 121763 8192000000 10840149056 11310612480 1901769936 18.841 99 15 30 1 1914485984 8706672 4009376
18:29:17 30763 8192000000 10866945040 11325640704 1921507904 18.999 99 21 42 1 1932474864 5376208 5590752
18:30:08 85232 8192000000 10884371648 11363340288 1928583328 19.056 98 10 20 0 1943949872 13033520 2333024
18:31:42 94211 8192000000 10860535056 11330408448 1832380768 18.279 93 16 32 0 1849350320 12461296 4508256
18:33:31 55592 8192000000 10886889776 11334275072 1909102256 18.899 98 25 47 2 1926825536 11150912 6572368
18:34:35 118873 8192000000 10839831200 11305209856 1754866096 17.642 90 16 32 2 1772494864 13315904 4312864
18:36:41 53012 8192000000 10863010768 11306979328 1848503888 18.410 95 41 82 0 1872722336 12847856 11370592
18:37:41 46025 8192000000 10850191488 11307126784 1869874816 18.583 97 32 64 1 1892962560 14267136 8820608
18:38:37 71245 8192000000 10871844368 11313512448 1889907216 18.745 98 26 52 2 1907134848 10046832 7180800
18:39:55 22792 8192000000 10873549904 11313008640 1896605792 18.799 98 51 102 4 1922119168 11311152 14202224
18:40:33 155123 8192000000 10855726416 11318452224 1845834560 18.388 96 22 42 0 1863454320 12195216 5424544
18:43:14 32868 8192000000 10875855104 11327242240 1921964496 19.003 99 21 42 1 1937311200 9116512 6230192
18:43:53 50059 8192000000 10877797856 11339030528 1941824496 19.161 100 31 63 0 1964094560 13723936 8546128
18:45:01 82534 8192000000 10827727376 11292667904 1866820240 18.559 96 19 38 0 1878400048 6072768 5507040
18:46:32 28036 8192000000 10842504384 11297632256 1876158752 18.634 97 25 50 0 1893264240 9755568 7349920
18:47:06 32585 8192000000 10853710800 11324895232 1922797808 19.009 100 13 26 0 1940267232 13964656 3504768
18:47:51 84942 8192000000 10868039472 11345457152 1941883584 19.162 100 16 32 0 1962060624 15623376 4553664
18:49:22 52661 8192000000 10865628960 11356954624 1948021440 19.211 100 8 16 1 1964113616 13817776 2274400
18:50:23 45418 8192000000 10859203488 11335593984 1909648160 18.904 98 8 16 1 1924878448 12963088 2267200
18:51:15 56738 8192000000 10871634208 11345420288 1934690832 19.104 99 16 32 1 1948122960 9203760 4228368
18:52:22 47699 8192000000 10920007856 11355684864 1937658752 19.128 99 11 22 0 1948618896 7833824 3126320
18:53:16 19929 8192000000 10895611808 11357569024 1947881328 19.210 99 27 54 1 1965882704 10087600 7913776
18:53:44 57551 8192000000 10896184672 11366944768 1951045072 19.235 99 12 25 0 1966082656 11599520 3438064
18:54:51 80884 8192000000 10895658832 11377209344 1951006864 19.234 99 9 19 0 1966565088 13007696 2550528
18:56:18 39947 8192000000 10912182480 11370262528 1978081536 19.450 100 17 33 1 1994571984 11928528 4561920
18:57:08 22931 8192000000 10938527024 11380674560 1989401088 19.539 100 54 109 2 2013646512 9922960 14322464
18:57:37 25948 8192000000 10921814928 11378626560 1989891904 19.543 100 42 84 0 2013624640 12150000 11582736
18:58:13 36187 8192000000 10917729648 11381637120 1972938448 19.409 99 33 65 0 1992347712 10859104 8550160
18:59:44 46139 8192000000 10917645184 11381948416 1967144688 19.363 99 33 66 1 1991374592 14937568 9292336
19:00:42 85381 8192000000 10906465568 11372773376 1930014544 19.067 97 7 14 0 1940873568 9001040 1857984
19:02:14 13475 8192000000 10922041808 11373563904 1974437920 19.421 99 49 98 1 1998382000 8907616 15036464
19:02:37 48815 8192000000 10917324048 11377373184 1961593440 19.319 99 25 50 0 1981293184 12588160 7111584
19:03:36 119578 8192000000 10923834368 11367837696 1962605536 19.327 99 39 77 2 1985540576 11649248 11285792
19:05:42 58846 8192000000 10869438240 11318546432 1878075184 18.650 95 30 60 2 1893259760 6336560 8848016
19:06:54 24185 8192000000 10878728352 11336708096 1935640496 19.112 99 31 62 0 1953634528 8794288 9199744
19:07:25 54820 8192000000 10863047520 11338780672 1930888080 19.074 99 11 22 0 1942949760 8745264 3316416
19:08:26 56707 8192000000 10860948576 11336118272 1944881040 19.186 100 10 20 1 1954453872 7333664 2239168
19:09:29 69789 8192000000 10858460736 11336163328 1925116944 19.028 99 9 18 0 1936672864 8908272 2647648
19:10:57 51654 8192000000 10878082800 11345801216 1919575744 18.983 98 12 24 3 1934616416 11008400 4032272
19:12:25 94711 8192000000 10865272512 11342544896 1875790416 18.631 96 19 38 2 1900158880 18813056 5555408
19:14:08 81524 8192000000 10866815840 11339747328 1914275136 18.941 98 24 47 0 1933937840 13010976 6651728
19:15:36 91603 8192000000 10870332288 11335696384 1871951856 18.600 96 18 36 2 1888072080 10752192 5368032
19:17:15 52133 8192000000 10871706800 11321307136 1878714224 18.655 97 15 30 1 1890911232 8035504 4161504
19:18:16 94536 8192000000 10861766416 11338485760 1876119248 18.634 97 17 34 0 1898172272 17337520 4715504
19:20:03 64280 8192000000 10865689680 11313565696 1814874448 18.136 94 38 73 2 1834391472 9988704 9528320
19:21:13 149007 8192000000 10828387040 11293306880 1763307440 17.712 92 15 30 1 1787557360 19681968 4567952
19:23:56 105572 8192000000 10835691456 11293929472 1853940080 18.454 97 16 32 1 1866264032 8216464 4107488
19:25:50 59002 8192000000 10829752304 11299753984 1842622992 18.362 96 12 24 1 1857960192 11900944 3436256
19:26:55 16362 8192000000 10138060288 10538164224 1251900176 13.256 66 2 4 0 1262059296 10031008 128112

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 08-12-2020 19:29:05 to 08-12-2020 19:29:35.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 119 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 08-12-2020 19:29:36 to 08-12-2020 19:29:38.

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          246660
MON$OLDEST_ACTIVE               246847
MON$OLDEST_SNAPSHOT             246847
MON$NEXT_TRANSACTION            246847
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                       2006400
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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 ---
:199: 
:200: mscs-test-161.budzdorov.ru    Tue Dec  8 19:27:17 2020
:201:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:202: 
:203: 
:204: mscs-test-161.budzdorov.ru    Tue Dec  8 19:27:23 2020
:205:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:206: 
--- end of diff output ---

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

08.12.20 19:29:39. 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
2020-12-08 19:29:41 No severe PSQL-related problems occured
08.12.20 19:29:42. End of report.