Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.04.2021 16:32
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 df9f488d08424df294c459d6c283e9c3
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-03-04 16:07
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.26
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 17529988 kB
MemAvailable 31429336 kB
Buffers 0 kB
Cached 14106456 kB
SwapCached 0 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-04-02 16:32:13
DTS_END                         2021-04-02 16:32:13.5320
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57926
TRN_ID                          245280
ATT_ID                          706
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: 8814.65 26267 1057758
customer order: creation 172.35 323 20682
customer order: refuse 14.97 323 1796
order to supplier: creation 46.58 1204 5589
order to supplier: removal 3.22 92370 386
invoice (draft): creation 46.43 3387 5572
invoice (draft): removal 48.71 729 5845
invoice accept: apply 42.37 18586 5084
invoice accept: cancel 44.08 787 5289
customer reserve: creation 3842.80 188 461136
customer reserve: removal 4246.98 54 509637
realization accept: apply 85.64 192 10277
realization accept: cancel 88.69 106 10643
payment from customer: creation 60.63 111 7276
payment from customer: removal 5.98 68 718
payment to supplier: creation 49.05 139 5886
payment to supplier: removal 3.46 53 415
service: total inventory turnovers 5.18 861 622
service: total monetary turnovers 6.60 26 792
service: aggregate perf. data 0.91 15525 109
service: refresh index statistics 0.03 390306 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 02-04-2021 16:33:10 to 02-04-2021 16:33:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2573
TEST_TIME 2 3496
TEST_TIME 3 3926
TEST_TIME 4 4353
TEST_TIME 5 4432
TEST_TIME 6 4380
TEST_TIME 7 4628
TEST_TIME 8 4668
TEST_TIME 9 5066
TEST_TIME 10 5534
TEST_TIME 11 5832
TEST_TIME 12 6223
TEST_TIME 13 6347
TEST_TIME 14 6356
TEST_TIME 15 6619
TEST_TIME 16 6949
TEST_TIME 17 7424
TEST_TIME 18 7746
TEST_TIME 19 8248
TEST_TIME 20 8366
TEST_TIME 21 9308
TEST_TIME 22 9448
TEST_TIME 23 10211
TEST_TIME 24 10389
TEST_TIME 25 10119
TEST_TIME 26 10271
TEST_TIME 27 10119
TEST_TIME 28 9880
TEST_TIME 29 9892
TEST_TIME 30 9689
TEST_TIME 31 9484
TEST_TIME 32 9418
TEST_TIME 33 9267
TEST_TIME 34 9295
TEST_TIME 35 9096
TEST_TIME 36 9247
TEST_TIME 37 9229
TEST_TIME 38 9242
TEST_TIME 39 9526
TEST_TIME 40 9490
TEST_TIME 41 9453
TEST_TIME 42 9426
TEST_TIME 43 9337
TEST_TIME 44 9293
TEST_TIME 45 9327
TEST_TIME 46 9369
TEST_TIME 47 9321
TEST_TIME 48 9336
TEST_TIME 49 9347
TEST_TIME 50 9301
TEST_TIME 51 9221
TEST_TIME 52 9076
TEST_TIME 53 9056
TEST_TIME 54 8981
TEST_TIME 55 8909
TEST_TIME 56 8963
TEST_TIME 57 8896
TEST_TIME 58 8895
TEST_TIME 59 8858
TEST_TIME 60 8736
TEST_TIME 61 8695
TEST_TIME 62 8800
TEST_TIME 63 8815
TEST_TIME 64 8821
TEST_TIME 65 8848
TEST_TIME 66 8860
TEST_TIME 67 8867
TEST_TIME 68 8858
TEST_TIME 69 8947
TEST_TIME 70 8924
TEST_TIME 71 8997
TEST_TIME 72 9158
TEST_TIME 73 9117
TEST_TIME 74 9169
TEST_TIME 75 9196
TEST_TIME 76 9185
TEST_TIME 77 9088
TEST_TIME 78 9063
TEST_TIME 79 8969
TEST_TIME 80 8990
TEST_TIME 81 8961
TEST_TIME 82 8934
TEST_TIME 83 8892
TEST_TIME 84 8851
TEST_TIME 85 8801
TEST_TIME 86 8807
TEST_TIME 87 8797
TEST_TIME 88 8787
TEST_TIME 89 8816
TEST_TIME 90 8830
TEST_TIME 91 8848
TEST_TIME 92 8823
TEST_TIME 93 8884
TEST_TIME 94 8932
TEST_TIME 95 8900
TEST_TIME 96 8934
TEST_TIME 97 9026
TEST_TIME 98 9027
TEST_TIME 99 9070
TEST_TIME 100 9039
TEST_TIME 101 9036
TEST_TIME 102 9080
TEST_TIME 103 9052
TEST_TIME 104 8997
TEST_TIME 105 8980
TEST_TIME 106 8936
TEST_TIME 107 8927
TEST_TIME 108 8913
TEST_TIME 109 8879
TEST_TIME 110 8844
TEST_TIME 111 8854
TEST_TIME 112 8849
TEST_TIME 113 8838
TEST_TIME 114 8848
TEST_TIME 115 8842
TEST_TIME 116 8850
TEST_TIME 117 8879
TEST_TIME 118 8875
TEST_TIME 119 8844
TEST_TIME 120 8816

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-04-2021 16:33:14 to 02-04-2021 16:33:17.

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 1484476 1484476 0 0.00 0 27876 7 0 0
doc_list_biud 1484475 1484475 0 0.00 0 36006 24 0 0
sp_add_invoice_to_stock 5225 5084 141 2.69 24 199225 18587 0 141
sp_cancel_adding_invoice 5289 5289 0 0.00 5 58037 787 0 0
sp_cancel_client_order 1796 1796 0 0.00 5 10792 323 0 0
sp_cancel_customer_reserve 509637 509637 0 0.00 1 29994 55 0 0
sp_cancel_pay_from_customer 718 718 0 0.00 3 7725 68 0 0
sp_cancel_pay_to_supplier 415 415 0 0.00 3 1397 54 0 0
sp_cancel_supplier_invoice 5863 5845 18 0.30 2 18112 730 0 18
sp_cancel_supplier_order 386 386 0 0.00 8 1028042 92370 0 0
sp_cancel_write_off 10643 10643 0 0.00 1 8836 106 0 0
sp_client_order 20682 20682 0 0.00 3 21592 323 0 0
sp_customer_reserve 461136 461136 0 0.00 0 42370 188 0 0
sp_fill_shopping_cart 31837 31837 0 0.00 1 18338 40 0 0
sp_fill_shopping_cart_clo_res 461134 461134 0 0.00 0 26146 13 0 0
sp_get_clo_for_invoice 5080 5080 0 0.00 0 16572 243 0 0
sp_kill_cost_storno 17065 17065 0 0.00 0 16280 55 0 0
sp_kill_qstorno_ret_qs2qd 1036148 1036148 0 0.00 0 29853 30 0 0
sp_kill_qty_storno 548953 548953 0 0.00 0 36006 65 0 0
sp_lock_selected_doc 21297 21297 0 0.00 0 11392 6 0 0
sp_make_cost_storno 28519 28519 0 0.00 0 27872 59 0 0
sp_multiply_rows_for_pdistr 28519 28519 0 0.00 0 18441 35 0 0
sp_multiply_rows_for_qdistr 20682 20682 0 0.00 0 21580 143 0 0
sp_pay_from_customer 7276 7276 0 0.00 4 19160 112 0 0
sp_pay_to_supplier 5886 5886 0 0.00 5 16442 139 0 0
sp_payment_common 13162 13162 0 0.00 1 19153 38 0 0
sp_qd_handle_on_cancel_clo 1796 1796 0 0.00 0 10699 295 0 0
sp_qd_handle_on_invoice_upd_sts 10369 10369 0 0.00 0 36004 332 0 0
sp_qd_handle_on_reserve_upd_sts 10277 10277 0 0.00 0 18024 55 0 0
sp_reserve_write_off 10277 10277 0 0.00 6 18479 193 0 0
sp_supplier_invoice 5572 5572 0 0.00 5 82554 3388 0 0
sp_supplier_order 5589 5589 0 0.00 5 34491 1205 0 0
srv_aggregate_perf_data 109 109 0 0.00 3217 193042 15525 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1112 153395 32816 0 0
srv_find_qd_qs_mism 1009569 1009569 0 0.00 0 20421 6 0 0
srv_make_invnt_saldo 622 622 0 0.00 27 34638 862 0 0
srv_make_money_saldo 792 792 0 0.00 1 3057 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 211323 672433 390306 0 0
t$perf-abend:sp_add_invoice_to_stock 141 141 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 18 18 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5084 5084 0 0.00 0 29783 160 0 0
t$perf-norm:sp_cancel_adding_invoice 453 453 0 0.00 0 2411 70 0 0
t$perf-norm:sp_cancel_client_order 1796 1796 0 0.00 0 2870 10 0 0
t$perf-norm:sp_cancel_customer_reserve 731 731 0 0.00 0 1663 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 718 718 0 0.00 0 2966 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 415 415 0 0.00 0 1907 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 434 434 0 0.00 0 394 7 0 0
t$perf-norm:sp_cancel_supplier_order 386 386 0 0.00 0 31705 1447 0 0
t$perf-norm:sp_cancel_write_off 1007 1007 0 0.00 0 2267 11 0 0
t$perf-norm:sp_client_order 20682 20682 0 0.00 0 9044 16 0 0
t$perf-norm:sp_customer_reserve 1038 1038 0 0.00 0 3473 9 0 0
t$perf-norm:sp_pay_from_customer 7276 7276 0 0.00 0 6551 7 0 0
t$perf-norm:sp_pay_to_supplier 5886 5886 0 0.00 0 9487 11 0 0
t$perf-norm:sp_reserve_write_off 10277 10277 0 0.00 0 12452 11 0 0
t$perf-norm:sp_supplier_invoice 5572 5572 0 0.00 0 4677 16 0 0
t$perf-norm:sp_supplier_order 5589 5589 0 0.00 0 9691 16 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 515 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 133 4 0 0
t$perf-norm:srv_make_invnt_saldo 622 622 0 0.00 0 1031 16 0 0
t$perf-norm:srv_make_money_saldo 792 792 0 0.00 0 1359 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10442 10160 282 2.70 0 8082 21 0 282
v_all_customers 37750 37750 0 0.00 0 15 1 0 0
v_all_suppliers 30486 30486 0 0.00 0 26 1 0 0
v_all_wares 41364 41364 0 0.00 0 46 1 0 0
v_cancel_adding_invoice 906 906 0 0.00 0 888 6 0 0
v_cancel_client_order 3592 3592 0 0.00 0 3267 5 0 0
v_cancel_customer_prepayment 1436 1436 0 0.00 0 1632 7 0 0
v_cancel_customer_reserve 1462 1462 0 0.00 0 2311 6 0 0
v_cancel_payment_to_supplier 830 830 0 0.00 0 127 3 0 0
v_cancel_supplier_invoice 904 868 36 3.98 0 2222 18 0 36
v_cancel_supplier_order 772 772 0 0.00 0 2457 8 0 0
v_cancel_write_off 2014 2014 0 0.00 0 1846 12 0 0
v_max_id_clo_ord 5586 5586 0 0.00 0 636 1 0 0
v_max_id_clo_res 1038 1038 0 0.00 0 2651 12 0 0
v_max_id_ord_sup 5567 5567 0 0.00 0 6792 5 0 0
v_max_non_paid_invoice 1795 1795 0 0.00 0 4062 6 0 0
v_max_non_paid_realizn 3901 3901 0 0.00 0 2367 3 0 0
v_min_id_clo_ord 5586 5586 0 0.00 0 6025 8 0 0
v_min_id_clo_res 1038 1038 0 0.00 0 2215 4 0 0
v_min_id_ord_sup 5567 5567 0 0.00 0 8079 8 0 0
v_min_non_paid_invoice 5886 5886 0 0.00 0 16354 33 0 0
v_min_non_paid_realizn 7276 7276 0 0.00 0 15084 20 0 0
v_our_firm 10364 10364 0 0.00 0 16 1 0 0
v_reserve_write_off 20554 20554 0 0.00 0 7266 7 0 0
x_lock_depdocs_on_canc_invoice 10700 10700 0 0.00 0 19362 114 0 0
x_lock_depdocs_on_canc_sup_ord 386 386 0 0.00 0 7650 373 0 0
x_make_qstorno_1000_1200 5589 5589 0 0.00 1 34477 1124 0 0
x_make_qstorno_1200_2000 5572 5572 0 0.00 2 80285 3245 0 0
x_make_qstorno_2100_3300 461136 461136 0 0.00 0 42368 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-04-2021 16:33:19 to 02-04-2021 16:33:23.

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
14:02:17 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:23 12292 8192000000 10215594976 10515808256 931310720 10.208 75 50 100 0 951501232 2715024 17475488
14:02:44 28029 8192000000 10345556432 10658942976 1378096384 14.400 100 77 154 0 1407239680 4433136 24710160
14:03:20 19352 8192000000 10368642320 10689679360 1420435600 14.777 100 87 174 0 1455294176 6189184 28669392
14:03:46 23685 8192000000 10401321584 10727411712 1449774000 15.036 100 85 170 0 1484318336 6802624 27741712
14:04:24 21394 8192000000 10428711552 10761158656 1480323104 15.304 100 90 180 0 1517966416 8076944 29566368
14:04:53 19375 8192000000 10450443440 10782228480 1499370752 15.471 100 92 184 1 1537354480 8550496 29433232
14:05:29 22498 8192000000 10462575648 10800791552 1517329984 15.627 100 87 173 1 1553678240 9037696 27310560
14:06:06 15479 8192000000 10473216384 10816491520 1529714144 15.735 100 78 156 2 1563519600 9227088 24578368
14:06:36 20784 8192000000 10504907344 10852663296 1556016944 15.962 100 85 170 0 1592008144 9557856 26433344
14:07:08 15366 8192000000 10539153776 10888105984 1582208240 16.187 100 79 158 0 1616522016 9458880 24854896
14:07:34 15391 8192000000 10559750048 10917154816 1622731472 16.533 100 81 162 1 1657828464 10637856 24459136
14:07:58 7241 8192000000 10578041648 10938122240 1633055728 16.621 100 76 152 0 1666633536 11132352 22445456
14:08:13 11482 8192000000 10586881232 10951884800 1654051952 16.799 100 79 158 3 1688917472 11559056 23306464
14:08:34 11214 8192000000 10628557488 10989903872 1676411824 16.987 100 82 165 1 1712232224 11535104 24285296
14:08:53 9875 8192000000 10631189120 11000098816 1689265792 17.095 100 82 161 0 1723953552 11645840 23041920
14:09:11 8577 8192000000 10642750688 11016744960 1711563712 17.282 100 80 160 3 1746350560 12070064 22716784
14:09:29 8019 8192000000 10670153632 11040550912 1732851216 17.459 100 86 169 2 1769610848 13203552 23556080
14:09:45 6275 8192000000 10680834480 11056128000 1741309472 17.530 100 81 162 2 1777120864 13276352 22535040
14:09:58 5718 8192000000 10688633776 11065065472 1757330144 17.662 100 79 157 0 1791435936 13004176 21101616
14:10:11 3746 8192000000 10697942608 11076050944 1761170688 17.694 100 76 152 1 1795521360 12573392 21777280
14:10:22 6041 8192000000 10709132304 11086024704 1767248128 17.744 100 81 162 0 1802706640 12753008 22705504
14:10:35 4131 8192000000 10719792736 11096772608 1776150944 17.818 100 90 181 1 1815068896 13478272 25439680
14:10:46 3988 8192000000 10727127344 11102195712 1785828176 17.897 100 87 172 1 1822539248 12876928 23834144
14:10:58 3677 8192000000 10729898912 11110359040 1789495280 17.928 100 82 162 2 1825397216 13431888 22470048
14:11:08 3180 8192000000 10740515728 11120455680 1798366384 18.001 100 84 168 3 1835765840 13561056 23838400
14:11:18 4601 8192000000 10743009984 11125325824 1807957856 18.079 100 87 174 3 1846006176 14090576 23957744
14:11:30 6396 8192000000 10746183248 11129204736 1806873968 18.070 100 84 167 0 1844855312 14638688 23342656
14:11:43 6462 8192000000 10762115040 11141550080 1814666480 18.134 100 83 166 3 1851889728 14400656 22822592
14:11:57 2358 8192000000 10772271456 11153186816 1831682432 18.273 100 86 172 0 1870647760 14796160 24169168
14:12:06 1913 8192000000 10778704560 11160375296 1835607136 18.305 100 93 186 2 1876263648 14399872 26256640
14:12:15 2103 8192000000 10780888576 11165061120 1839676576 18.338 100 90 181 2 1883276656 18361344 25238736
14:12:23 2388 8192000000 10787206544 11172904960 1847921744 18.405 100 91 183 0 1887608240 14069840 25616656
14:12:32 2200 8192000000 10794815616 11182911488 1853758560 18.453 100 92 184 2 1895001600 15190048 26052992
14:12:41 2053 8192000000 10789562176 11179237376 1850910528 18.430 100 84 168 1 1888651136 13577872 24162736
14:12:49 2084 8192000000 10802037952 11189080064 1858942928 18.495 100 93 188 1 1898725888 13309664 26473296
14:12:58 1322 8192000000 10804605760 11191726080 1859868000 18.502 100 98 196 0 1900770928 12676368 28226560
14:13:05 1766 8192000000 10802402896 11193307136 1861261744 18.514 100 92 182 0 1900715824 13682944 25771136
14:13:13 1367 8192000000 10810958144 11198054400 1864395456 18.539 100 88 177 1 1903114048 13185888 25532704
14:13:21 32733 8192000000 10775201856 11192332288 1865525360 18.548 100 61 122 1 1893981616 10969952 17486304
14:14:02 11662 8192000000 10787903552 11198570496 1865229392 18.546 100 58 117 2 1888712304 7119728 16363184
14:14:20 6064 8192000000 10811482128 11207184384 1876345888 18.636 100 74 148 2 1906372352 9770064 20256400
14:14:33 11003 8192000000 10802068176 11213365248 1873347664 18.611 100 59 118 0 1903157296 13506896 16302736
14:14:52 10648 8192000000 10776635216 11203284992 1868023152 18.568 100 30 60 1 1884513888 7744928 8745808
14:15:09 5475 8192000000 10775088192 11207061504 1871011632 18.592 100 23 47 1 1888150608 10713088 6425888
14:15:21 4447 8192000000 10796904368 11218690048 1876339248 18.636 100 38 76 2 1899769264 13031520 10398496
14:15:34 4622 8192000000 10783384032 11212271616 1880598880 18.670 100 47 95 3 1901347808 7347600 13401328
14:15:48 3172 8192000000 10786207376 11214159872 1881932128 18.681 100 42 84 1 1900934496 6655488 12346880
14:15:58 12626 8192000000 10780250096 11214643200 1878439856 18.653 100 19 37 4 1889370016 5868208 5061952
14:16:19 5346 8192000000 10794486832 11221155840 1884643376 18.703 100 25 51 1 1897667856 5515200 7509280
14:16:33 10266 8192000000 10793511232 11223158784 1885029936 18.706 100 16 32 0 1896170480 6409872 4730672
14:16:50 10991 8192000000 10793281200 11227545600 1884217584 18.699 100 13 26 1 1893678784 5865456 3595744
14:17:09 10061 8192000000 10799412288 11231883264 1890423312 18.749 100 15 30 1 1900344928 5833936 4087680
14:17:27 6612 8192000000 10797588880 11230130176 1892471776 18.766 100 19 36 3 1903064032 5493824 5098432
14:17:40 10369 8192000000 10804519168 11243327488 1894591472 18.783 100 15 30 3 1909323632 10802672 3929488
14:18:00 11683 8192000000 10808829840 11236470784 1897136112 18.803 100 15 30 2 1906791696 5514096 4141488
14:18:18 62333 8192000000 10858070272 11260837888 1908763888 18.897 100 52 101 3 1929387328 5471072 15152368
14:19:26 12487 8192000000 10815981584 11256029184 1903126400 18.851 100 24 48 4 1920374048 11166944 6080704
14:19:46 8115 8192000000 10836701856 11267710976 1912646576 18.928 100 34 68 1 1932726864 10545968 9534320
14:20:00 5929 8192000000 10825997104 11264544768 1913603824 18.936 100 43 87 2 1933629872 7593792 12432256
14:20:16 5527 8192000000 10822098224 11263938560 1912831136 18.929 100 31 62 0 1927926880 6110480 8985264
14:20:28 7487 8192000000 10830069696 11268300800 1915387904 18.950 100 27 54 1 1930500832 7313760 7799168
14:20:45 5288 8192000000 10840613712 11267940352 1913912560 18.938 100 37 73 4 1930692064 6862800 9916704
14:20:57 6024 8192000000 10831750400 11267452928 1895860896 18.793 99 26 52 2 1917613888 14587584 7165408
14:21:10 4499 8192000000 10803784544 11239313408 1877472848 18.645 98 28 56 1 1892799376 7318016 8008512
14:21:24 10504 8192000000 10806099568 11244503040 1878101616 18.650 99 17 35 1 1888424320 5413984 4908720
14:21:40 11544 8192000000 10785409952 11207659520 1815307088 18.139 96 13 26 0 1824392192 4945968 4139136
14:21:58 10141 8192000000 10770017696 11200491520 1780166304 17.851 95 12 24 1 1793231120 10046912 3017904
14:22:14 11366 8192000000 10772518112 11201077248 1814632768 18.134 97 20 40 0 1825887568 5573824 5680976
14:22:34 6754 8192000000 10777645312 11206909952 1863470752 18.531 100 17 32 1 1873584352 5813392 4300208
14:22:51 29350 8192000000 10783126864 11211341824 1836698992 18.314 98 19 39 2 1847137728 5196352 5242384
14:23:50 22963 8192000000 10761994208 11186966528 1763453376 17.713 94 18 36 0 1773790128 5357312 4979440
14:24:19 8748 8192000000 10729584416 11147522048 1726814704 17.409 94 26 52 2 1740420208 6047232 7558272
14:24:35 5426 8192000000 10727233664 11149684736 1797535696 17.994 99 32 63 0 1814237936 6973376 9728864
14:24:47 6259 8192000000 10727379072 11140677632 1762213232 17.703 97 27 55 0 1775502704 5808080 7481392
14:25:00 9232 8192000000 10723396640 11133001728 1692143296 17.119 93 26 52 2 1705241744 5054592 8043856
14:25:21 7663 8192000000 10687067888 11098476544 1675409152 16.979 93 24 48 0 1688473552 5398016 7666384
14:25:37 5842 8192000000 10698804160 11098243072 1747990800 17.585 98 19 38 3 1758595888 5264816 5340272
14:25:49 6918 8192000000 10729876832 11147198464 1806462160 18.067 100 25 49 2 1818419120 5048400 6908560
14:26:02 6394 8192000000 10726410288 11150520320 1789634096 17.929 98 28 56 1 1804099376 6238480 8226800
14:26:15 7222 8192000000 10728460352 11136356352 1782210560 17.868 98 31 62 4 1798272656 6422464 9639632
14:26:31 10405 8192000000 10742563488 11162394624 1810787728 18.102 99 22 44 0 1823269168 5299888 7181552
14:26:48 8721 8192000000 10746294992 11173400576 1834019008 18.292 100 23 46 2 1846732208 5151040 7562160
14:27:05 6899 8192000000 10739234032 11163283456 1813088176 18.121 99 18 36 3 1823779152 4948736 5742240
14:27:18 15810 8192000000 10767444848 11166257152 1803448912 18.042 98 17 34 1 1818161120 9827584 4884624
14:27:41 68926 8192000000 10763226272 11184865280 1791522176 17.944 97 26 52 2 1808509808 9555520 7432112
14:28:58 13297 8192000000 10741498432 11172798464 1812241376 18.114 98 24 48 2 1824070256 4876256 6952624
14:29:18 6436 8192000000 10768913584 11188060160 1850647568 18.427 100 35 70 2 1868182256 6982624 10552064
14:29:30 5823 8192000000 10778121232 11199512576 1856620704 18.476 100 42 82 3 1879066656 11003504 11442448
14:29:48 6424 8192000000 10773041040 11202375680 1861619824 18.516 100 31 62 2 1876826624 6825504 8381296
14:30:01 9735 8192000000 10783758176 11203633152 1865007056 18.544 100 29 58 1 1880215152 5165840 10042256
14:30:20 7654 8192000000 10780244240 11210731520 1867799776 18.566 100 26 52 0 1881131648 5687168 7644704
14:30:35 8003 8192000000 10780886736 11211735040 1866650384 18.557 100 17 34 4 1877079712 5727904 4701424
14:30:49 7778 8192000000 10786299312 11215503360 1870936576 18.592 100 24 45 3 1884015152 5371104 7707472
14:31:03 11557 8192000000 10791707952 11222093824 1873268736 18.611 100 15 30 1 1886941424 9290016 4382672
14:31:21 7254 8192000000 10790481952 11218976768 1878218416 18.651 100 19 39 1 1889299488 5715584 5365488
14:31:38 14946 8192000000 10796132112 11224768512 1877333792 18.644 100 16 32 0 1891899312 9801408 4764112
14:31:59 38277 8192000000 10816564048 11243929600 1895169920 18.787 100 17 34 1 1909258592 9557712 4530960
14:33:09 8244 8192000000 10826453856 11247869952 1895572480 18.791 99 35 68 2 1913789392 8573152 9643760
14:33:37 9495 8192000000 10851118240 11275563008 1916539552 18.959 100 41 79 0 1941471744 13418896 11513296
14:33:53 22727 8192000000 10862236224 11284828160 1931218496 19.077 100 46 91 0 1955107488 10926320 12962672
14:34:26 28757 8192000000 10880985280 11304284160 1940033376 19.147 100 51 102 2 1966720192 11999040 14687776
14:35:30 38149 8192000000 10881181872 11315126272 1947904448 19.210 100 44 88 2 1974898800 14155216 12839136
14:36:18 12725 8192000000 10884052992 11323699200 1953570112 19.255 100 33 65 0 1981154640 18543360 9041168
14:36:56 21519 8192000000 10909351232 11338149888 1963660016 19.335 100 49 94 2 1996525360 19529280 13336064
14:38:12 9325 8192000000 10912336144 11346116608 1972242560 19.403 100 39 78 2 1997445840 14041936 11161344
14:38:35 10764 8192000000 10924736112 11349307392 1975767280 19.431 100 43 84 1 2007403664 19071328 12565056
14:38:53 7647 8192000000 10913326544 11351580672 1977911408 19.448 100 39 78 0 2006838816 16929984 11997424
14:39:13 18974 8192000000 10914456832 11352768512 1962928416 19.329 99 40 81 0 1990769312 15428368 12412528
14:39:39 12485 8192000000 10932026944 11361603584 1987183408 19.522 100 50 100 0 2020742880 18495440 15064032
14:40:01 5431 8192000000 10938110016 11371945984 1994578240 19.580 100 63 124 0 2033505056 20111056 18815760
14:40:15 9134 8192000000 10936862928 11369848832 1975265440 19.427 99 54 108 1 2013504080 21552688 16685952
14:40:39 9054 8192000000 10942155120 11377315840 1992314096 19.562 100 54 105 1 2032074672 22865888 16894688
14:40:56 12786 8192000000 10948061344 11378745344 1996394240 19.594 100 63 126 1 2039335248 24242112 18698896
14:41:16 10039 8192000000 10955059952 11383197696 1996232960 19.593 100 68 136 0 2040500128 24242880 20024288
14:41:38 6825 8192000000 10962585120 11390713856 2003375424 19.649 100 63 126 1 2043545568 22331360 17838784
14:42:02 10171 8192000000 10960787392 11396218880 2004769904 19.660 100 56 108 3 2044456320 23410096 16276320
14:42:19 3344 8192000000 10963880144 11400790016 2012812304 19.724 100 65 130 0 2058972384 26566464 19593616
14:42:30 5650 8192000000 10957436608 11393568768 1997622208 19.604 99 63 124 1 2040266032 24037744 18606080
14:42:44 4116 8192000000 10966254624 11395883008 2005660896 19.667 100 63 126 2 2048835712 24744352 18430464
14:42:57 3118 8192000000 10967240544 11396210688 2010358384 19.704 100 81 164 2 2059500944 25102336 24040224
14:43:07 5110 8192000000 10972398064 11394359296 2006046400 19.670 100 85 166 2 2058074688 27609632 24418656
14:43:22 1125 8192000000 10969950656 11383721984 1997459520 19.603 100 87 174 1 2049809440 26700736 25649184
14:43:30 2573 8192000000 10970601040 11386507264 2000939776 19.630 100 89 177 3 2053972080 27475472 25556832
14:43:39 3154 8192000000 10944854640 11360509952 1974830864 19.424 99 80 154 0 2025030352 28186416 22013072
14:43:51 5317 8192000000 10957257552 11382644736 1994247232 19.577 100 73 145 2 2044380816 28356640 21776944
14:44:03 3078 8192000000 10975152912 11393282048 2002278944 19.641 100 75 152 3 2053568640 28544576 22745120
14:44:15 2363 8192000000 10945904592 11362775040 1976112864 19.434 100 73 145 2 2026791888 28345472 22333552
14:44:25 2941 8192000000 10956060112 11375652864 1991027936 19.552 100 71 138 0 2040322704 28560384 20734384
14:44:36 3123 8192000000 10936250960 11362627584 1966578896 19.358 99 75 147 0 2018366064 28945232 22841936
14:44:45 5626 8192000000 10938638272 11354234880 1943668560 19.176 98 83 164 2 1999310576 29807712 25834304
14:44:59 1788 8192000000 10956247776 11368247296 1981099472 19.473 100 83 168 2 2034615712 28345008 25171232
14:45:07 4287 8192000000 10939802272 11363921920 1975301584 19.427 100 75 150 0 2027996208 29514848 23179776
14:45:25 2302 8192000000 10936795392 11346771968 1948422944 19.214 99 83 164 3 2004174480 30161792 25589744
14:45:36 4101 8192000000 10908128784 11318894592 1917843072 18.970 98 81 161 0 1973986912 32031568 24112272
14:45:49 6195 8192000000 10914905200 11341029376 1950318496 19.229 100 63 126 2 2000974928 31144096 19512336
14:46:03 2442 8192000000 10923151584 11341713408 1955592544 19.271 100 75 147 3 2012535456 32537120 24405792
14:46:14 4892 8192000000 10912258192 11337035776 1933181744 19.092 99 63 126 1 1985169952 31899904 20088304
14:46:31 8721 8192000000 10914507888 11334799360 1942363040 19.166 100 58 114 0 1991483136 31540176 17579920
14:46:49 4509 8192000000 10924467056 11344457728 1955481344 19.270 100 72 142 0 2011474480 33095072 22898064
14:47:01 1112 8192000000 10946367424 11354210304 1962929632 19.329 100 89 178 2 2024991584 35180000 26881952
14:47:10 2242 8192000000 10947938976 11362873344 1953959776 19.258 99 88 176 1 2018980464 36779760 28240928
14:47:22 4336 8192000000 10930383488 11345166336 1953452048 19.254 99 84 165 2 2017741344 38850816 25438480
14:47:34 3860 8192000000 10940835296 11349168128 1953421904 19.254 100 82 164 2 2019410272 39510656 26477712
14:47:45 2418 8192000000 10928498416 11341541376 1939932544 19.146 99 82 164 0 2003477360 36939088 26605728
14:47:55 1408 8192000000 10926307088 11335122944 1933312480 19.093 99 86 171 1 1997642144 37759680 26569984
14:48:03 4360 8192000000 10927546000 11337355264 1942042656 19.163 100 84 167 0 2006516192 39037072 25436464
14:48:17 5762 8192000000 10905343504 11310374912 1910048256 18.907 98 74 148 2 1973329232 40125216 23155760
14:48:33 4724 8192000000 10933313536 11350642688 1948971472 19.218 100 75 150 2 2014841504 42449808 23420224
14:48:48 1583 8192000000 10948718544 11362770944 1960026384 19.306 100 83 164 1 2029542832 43775408 25741040
14:48:58 3559 8192000000 10928523456 11343953920 1949326768 19.221 100 81 162 0 2011393680 36855424 25211488
14:49:10 4760 8192000000 10923537824 11346112512 1953902320 19.258 100 65 130 2 2008648944 33947136 20799488
14:49:21 1364 8192000000 10932073920 11343310848 1952626896 19.247 100 77 158 4 2009460000 34180672 22652432
14:49:29 3109 8192000000 10925398176 11345780736 1951823968 19.241 100 79 158 0 2012749696 35664736 25260992
14:49:39 4920 8192000000 10921465824 11338575872 1942044144 19.163 99 71 142 1 1999701200 36045104 21611952
14:49:54 4376 8192000000 10925520912 11339517952 1946752704 19.201 100 78 156 1 2005620928 33218416 25649808
14:50:05 6737 8192000000 10916979568 11341271040 1935990352 19.115 99 64 129 2 1989881584 33647280 20243952
14:50:24 1617 8192000000 10950643936 11358167040 1962668080 19.327 100 88 178 0 2028418080 37774192 27975808
14:50:32 3359 8192000000 10946254960 11361345536 1965740944 19.352 100 79 158 1 2028952800 38025312 25186544
14:50:42 1629 8192000000 10949384176 11362934784 1965182304 19.347 100 90 177 2 2032262400 39412800 27667296
14:50:52 2584 8192000000 10943192592 11357511680 1947042000 19.203 99 81 162 2 2008575024 36327344 25205680
14:51:01 6158 8192000000 10929614368 11359260672 1960992704 19.314 100 61 120 1 2012078544 31797056 19288784
14:51:18 16578 8192000000 10904452160 11348287488 1939397536 19.142 99 35 70 2 1980445792 29303792 11744464
14:51:48 13335 8192000000 10904221968 11335475200 1938816912 19.137 100 42 84 1 1983507264 30305744 14384608
14:52:16 5618 8192000000 10920158960 11342929920 1947470688 19.206 100 51 102 0 1998323968 34217024 16636256
14:52:28 13425 8192000000 10877751952 11318075392 1886092128 18.714 97 38 76 1 1932228416 33566480 12569808
14:52:52 2701 8192000000 10916723424 11331121152 1937184064 19.124 100 64 128 2 1991640208 34397184 20058960
14:53:03 5956 8192000000 10894585744 11330297856 1929458144 19.063 100 51 102 0 1985019408 39304080 16257184
14:53:23 27280 8192000000 10866243472 11331481600 1895674416 18.791 98 24 48 0 1941571648 37740672 8156560
14:53:58 8966 8192000000 10850423600 11297976320 1905346448 18.869 100 34 68 4 1942762256 26233584 11182224
14:54:34 12656 8192000000 10861045168 11301400576 1896796640 18.801 99 25 49 2 1941202192 34006304 10399248
14:55:04 31894 8192000000 10833657312 11284488192 1816996224 18.153 95 21 42 0 1852269648 28092816 7180608
14:55:42 19501 8192000000 10844075232 11287773184 1876902784 18.640 99 15 30 1 1901909600 20467696 4539120
14:56:22 29362 8192000000 10853004112 11272482816 1865365664 18.547 97 54 106 3 1892398048 12243552 14788832
14:57:05 67861 8192000000 10822926320 11269877760 1841893440 18.356 97 24 49 0 1865408560 16458400 7056720
14:58:28 23458 8192000000 10819397888 11270262784 1894198192 18.780 100 22 44 2 1910859008 10372768 6288048
14:59:01 51932 8192000000 10834856048 11295100928 1900952960 18.834 100 10 19 0 1918761792 15393264 2415568
14:59:59 45624 8192000000 10835079360 11287146496 1896973168 18.802 99 24 47 3 1914432528 10184976 7274384
15:00:52 66648 8192000000 10832526240 11301228544 1913858512 18.938 100 17 34 2 1931692336 12575264 5258560
15:02:05 38213 8192000000 10859047168 11324813312 1930212304 19.069 100 9 18 0 1942448256 10074112 2161840
15:02:50 27337 8192000000 10865643904 11329728512 1942134880 19.164 100 10 20 1 1956427616 11044064 3248672
15:03:23 6388 8192000000 10876873120 11342204928 1947200352 19.204 100 14 28 2 1962398400 11516080 3681968
15:03:57 26780 8192000000 10889264352 11357474816 1956022496 19.274 100 14 28 1 1978030144 17883552 4124096
15:04:32 70531 8192000000 10886489248 11348336640 1949297584 19.221 100 19 39 0 1968674640 14427056 4950000
15:05:49 96328 8192000000 10902775312 11364806656 1961908896 19.321 100 15 30 0 1986134576 20369600 3856080
15:08:17 47732 8192000000 10906733104 11363479552 1965907824 19.353 100 17 33 0 1995669840 24766752 4995264
15:09:11 23022 8192000000 10905907520 11375808512 1976392016 19.436 100 16 32 0 1998658352 18220160 4046176
15:10:05 42680 8192000000 10920126000 11381776384 1985796768 19.511 100 14 28 0 2001135152 11739584 3598800
15:11:16 112041 8192000000 10908208336 11377389568 1958363984 19.293 99 10 20 1 1979806144 18684848 2757312
15:13:14 86259 8192000000 10917950000 11374620672 1948317296 19.213 98 32 62 0 1968307216 10150592 9839328
15:14:59 30754 8192000000 10929611952 11368402944 1961099856 19.315 99 49 94 4 1984332544 9234432 13998256
15:15:38 26078 8192000000 10927074672 11375931392 1986708800 19.518 100 56 109 0 2012172064 10445904 15017360
15:16:19 18480 8192000000 10921286448 11368583168 1966386368 19.357 99 33 66 1 1984667328 9200832 9080128
15:16:55 50913 8192000000 10935027360 11385987072 1967345584 19.364 99 26 52 0 1991836864 17425408 7065872
15:17:55 33240 8192000000 10913377408 11366424576 1971273248 19.396 99 30 60 2 1989984000 10659456 8051296
15:18:42 70493 8192000000 10904702992 11347386368 1910094416 18.907 96 21 42 0 1924825328 9281776 5449136
15:20:00 83881 8192000000 10902369280 11366522880 1923221296 19.013 97 24 48 1 1942359968 12479648 6659024
15:21:32 76094 8192000000 10899003456 11359576064 1934985680 19.107 98 14 28 2 1951428400 12481840 3960880
15:23:01 89540 8192000000 10913627200 11367911424 1963419664 19.333 99 32 62 1 1982228400 8955760 9852976
15:24:51 97687 8192000000 10905205216 11370737664 1915175952 18.948 97 18 36 0 1931900672 11965136 4759584
15:26:35 36327 8192000000 10899813552 11357016064 1939376768 19.142 98 25 50 1 1956311984 9575232 7359984
15:27:18 46060 8192000000 10887857776 11365560320 1954449216 19.262 99 18 36 0 1972205856 12518368 5238272
15:28:27 52968 8192000000 10866481936 11342499840 1930877600 19.074 98 14 28 0 1947191328 12277760 4035968
15:29:26 32154 8192000000 10865152432 11335987200 1884744192 18.703 96 13 25 0 1899998864 11416288 3838384
15:30:07 41662 8192000000 10852696960 11321561088 1872471968 18.604 96 11 22 0 1890500000 14131696 3896336
15:30:55 30270 8192000000 10874437120 11338366976 1946021200 19.195 100 16 32 0 1961408960 10555696 4832064
15:32:08 66428 8192000000 10845113280 11305254912 1890459456 18.749 97 11 22 0 1904922224 11535888 2926880
15:33:21 54871 8192000000 10837104176 11296989184 1873605536 18.613 97 17 32 1 1891916048 12440880 5869632
15:34:24 47072 8192000000 10801063808 11292168192 1859362832 18.498 98 9 18 0 1875355904 13425008 2568064
15:35:25 29803 8192000000 10833083856 11276427264 1865960128 18.552 98 20 40 1 1878382240 7115520 5306592
15:36:03 32300 8192000000 10835772368 11300356096 1893276896 18.772 99 12 24 0 1907275616 10555680 3443040
15:36:45 50578 8192000000 10854147936 11296616448 1842190048 18.359 96 23 46 1 1857998880 9236768 6572064
15:37:43 23787 8192000000 10852294800 11305414656 1898041296 18.811 99 31 62 1 1914856192 8480864 8334032
15:38:16 16005 8192000000 10839635616 11288858624 1868087344 18.569 97 35 70 1 1886938800 9187136 9664320
15:38:40 30547 8192000000 10860430240 11311878144 1897101488 18.803 99 23 46 0 1913617424 10223760 6292176
15:40:04 29702 8192000000 10879378592 11319255040 1912894288 18.930 99 36 73 3 1935540320 12310400 10335632
15:40:42 40556 8192000000 10853139616 11314528256 1891521904 18.758 98 29 58 1 1915290704 15023040 8745760
15:41:33 45085 8192000000 10862751760 11306057728 1872014336 18.601 97 35 70 1 1899049984 17362704 9672944
15:42:25 27456 8192000000 10875511296 11321958400 1905355280 18.869 99 43 86 4 1939511824 21840288 12316256
15:43:05 58649 8192000000 10846656992 11326074880 1881607888 18.678 98 24 48 1 1910781552 22159936 7013728
15:44:11 94410 8192000000 10856008320 11325190144 1900151920 18.828 99 10 20 1 1920087328 17242096 2693312
15:45:52 43165 8192000000 10877681568 11337261056 1942578112 19.167 100 27 54 4 1966686688 16541072 7567504
15:46:48 153395 8192000000 10886786576 11349479424 1892528080 18.766 97 29 57 0 1915331760 14445008 8358672
15:49:57 95868 8192000000 10842054448 11298488320 1889806688 18.744 97 12 24 1 1901060608 7468864 3785056
15:51:46 37010 8192000000 10861086160 11331190784 1940713744 19.152 100 30 59 1 1962136176 12764560 8657872
15:52:34 53624 8192000000 10871344864 11351994368 1931148416 19.076 99 16 32 4 1952588432 17578704 3861312
15:53:40 75196 8192000000 10856426352 11332751360 1925508624 19.031 99 9 18 1 1937465328 9588704 2368000
15:55:06 56450 8192000000 10852133952 11318460416 1872971232 18.608 96 21 40 2 1885142816 6931168 5240416
15:56:09 78414 8192000000 10859605184 11332517888 1913504704 18.935 98 14 28 1 1925884304 8030208 4349392
15:57:42 71681 8192000000 10875969488 11348516864 1935790576 19.113 99 14 28 1 1952918352 12447344 4680432
15:59:29 102055 8192000000 10887617744 11372175360 1959751232 19.304 100 9 18 0 1977658880 14654112 3253536
16:01:17 45604 8192000000 10896751184 11366494208 1962209808 19.324 100 11 22 0 1975723872 10141936 3372128
16:02:25 37848 8192000000 10909185136 11365072896 1940593776 19.151 98 26 52 1 1958188992 9272112 8323104
16:03:09 67922 8192000000 10882927312 11358998528 1889448240 18.741 96 12 24 0 1902813536 10422592 2942704
16:04:27 61814 8192000000 10899434368 11370475520 1923555744 19.015 98 22 43 1 1943679760 13875696 6248320
16:05:40 56876 8192000000 10911239392 11388776448 1977051568 19.441 100 23 45 0 1997480672 14141424 6287680
16:06:44 38404 8192000000 10913107024 11390390272 1960553488 19.310 99 19 38 0 1978397216 12599744 5243984
16:08:05 58377 8192000000 10896929376 11366768640 1920892720 18.994 97 24 48 0 1948728464 21225168 6610576
16:09:21 126891 8192000000 10889587072 11365347328 1887530624 18.726 96 11 22 1 1903252864 12706144 3016096
16:11:35 94262 8192000000 10909079456 11374592000 1938404416 19.134 99 24 48 0 1960854224 15887632 6562176
16:13:17 58358 8192000000 10909245312 11374059520 1936147616 19.116 98 32 64 1 1955488992 11131456 8209920
16:14:26 69523 8192000000 10907382976 11366760448 1916694704 18.960 97 20 40 1 1931232352 8826512 5711136
16:15:41 152295 8192000000 10883915136 11351576576 1913536032 18.935 97 38 76 1 1932798752 8608640 10654080
16:18:20 59438 8192000000 10868417920 11336409088 1926596352 19.040 98 21 42 1 1941936544 9243536 6096656
16:19:25 39193 8192000000 10875025328 11343278080 1904835936 18.865 97 22 44 1 1918332208 6921728 6574544
16:20:11 51453 8192000000 10870800272 11345870848 1938576704 19.135 99 11 22 1 1950824816 9388352 2859760
16:21:08 53678 8192000000 10854711360 11332415488 1893193376 18.772 97 5 10 1 1904564752 9993216 1378160
16:22:09 72253 8192000000 10874368224 11347423232 1927273792 19.045 99 13 26 0 1944343584 12959328 4110464
16:23:27 32990 8192000000 10853217776 11339878400 1912216544 18.924 98 7 14 0 1925013488 10827296 1969648
16:24:09 46561 8192000000 10854175888 11331936256 1897254608 18.804 98 11 22 0 1906463616 6651520 2557488
16:25:01 45295 8192000000 10857319856 11324084224 1865564816 18.548 96 9 18 0 1875175376 6989536 2621024
16:25:54 55079 8192000000 10863940816 11336396800 1898482480 18.814 98 21 42 1 1913354176 8364944 6506752
16:26:58 63505 8192000000 10853472144 11324899328 1871192800 18.594 96 13 26 2 1884586128 9902688 3490640
16:28:09 34681 8192000000 10870726800 11316240384 1912223968 18.924 99 26 52 0 1928638560 8956608 7457984
16:28:54 47033 8192000000 10840761728 11309039616 1853831632 18.453 96 19 38 3 1867825632 9012752 4981248
16:29:48 21799 8192000000 10833398112 11292549120 1846276560 18.392 96 26 51 0 1861223728 7531216 7415952
16:30:16 15350 8192000000 10838078368 11291414528 1892175184 18.763 99 44 88 1 1913272784 8983536 12114064
16:30:39 55045 8192000000 10887060224 11340546048 1933526352 19.095 100 29 58 0 1954634464 13249424 7858688
16:31:43 35156 8192000000 9674812464 10012413952 811185744 9.009 42 16 32 1 823260000 7600448 4473808

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 02-04-2021 16:33:24 to 02-04-2021 16:33:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 141 v_add_invoice_to_stock 335544517
except 18 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-04-2021 16:33:57 to 02-04-2021 16:33:59.

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          245586
MON$OLDEST_ACTIVE               245587
MON$OLDEST_SNAPSHOT             245587
MON$NEXT_TRANSACTION            245587
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                       2004992
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.33431 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33431 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33431 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33431 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

02.04.21 16:34:00. 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-04-02 16:34:02 No severe PSQL-related problems occured
02.04.21 16:34:03. End of report.