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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17187668 kB
MemAvailable 31540104 kB
Buffers 0 kB
Cached 14458408 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-03-16 01:27:24
DTS_END                         2021-03-16 01:27:24.1430
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/39222
TRN_ID                          249750
ATT_ID                          725
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9418.42 17831 1130210
customer order: creation 187.70 336 22524
customer order: refuse 15.64 345 1877
order to supplier: creation 49.13 1223 5895
order to supplier: removal 3.53 95218 423
invoice (draft): creation 48.02 3090 5762
invoice (draft): removal 52.38 758 6286
invoice accept: apply 43.35 17495 5202
invoice accept: cancel 46.90 868 5628
customer reserve: creation 4006.27 172 480752
customer reserve: removal 4657.38 56 558885
realization accept: apply 88.57 189 10628
realization accept: cancel 81.11 114 9733
payment from customer: creation 63.08 130 7569
payment from customer: removal 6.40 77 768
payment to supplier: creation 52.03 138 6243
payment to supplier: removal 3.52 108 422
service: total inventory turnovers 5.11 1284 613
service: total monetary turnovers 7.41 45 889
service: aggregate perf. data 0.89 22065 107
service: refresh index statistics 0.03 212900 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4427
TEST_TIME 2 5178
TEST_TIME 3 5382
TEST_TIME 4 4755
TEST_TIME 5 4784
TEST_TIME 6 5521
TEST_TIME 7 5784
TEST_TIME 8 6402
TEST_TIME 9 6135
TEST_TIME 10 6206
TEST_TIME 11 6342
TEST_TIME 12 6396
TEST_TIME 13 6784
TEST_TIME 14 6855
TEST_TIME 15 7113
TEST_TIME 16 7312
TEST_TIME 17 7965
TEST_TIME 18 8255
TEST_TIME 19 8854
TEST_TIME 20 9008
TEST_TIME 21 8749
TEST_TIME 22 9086
TEST_TIME 23 9060
TEST_TIME 24 9474
TEST_TIME 25 9691
TEST_TIME 26 9826
TEST_TIME 27 9896
TEST_TIME 28 10009
TEST_TIME 29 10281
TEST_TIME 30 10091
TEST_TIME 31 10848
TEST_TIME 32 10986
TEST_TIME 33 10808
TEST_TIME 34 10619
TEST_TIME 35 10592
TEST_TIME 36 10409
TEST_TIME 37 10288
TEST_TIME 38 10346
TEST_TIME 39 10449
TEST_TIME 40 10369
TEST_TIME 41 10314
TEST_TIME 42 10234
TEST_TIME 43 10271
TEST_TIME 44 10271
TEST_TIME 45 10394
TEST_TIME 46 10300
TEST_TIME 47 10294
TEST_TIME 48 10204
TEST_TIME 49 10135
TEST_TIME 50 9972
TEST_TIME 51 9895
TEST_TIME 52 9959
TEST_TIME 53 9891
TEST_TIME 54 9840
TEST_TIME 55 9785
TEST_TIME 56 9845
TEST_TIME 57 9838
TEST_TIME 58 9746
TEST_TIME 59 9751
TEST_TIME 60 9731
TEST_TIME 61 9636
TEST_TIME 62 9611
TEST_TIME 63 9574
TEST_TIME 64 9561
TEST_TIME 65 9550
TEST_TIME 66 9492
TEST_TIME 67 9602
TEST_TIME 68 9644
TEST_TIME 69 9658
TEST_TIME 70 9667
TEST_TIME 71 9754
TEST_TIME 72 9755
TEST_TIME 73 9726
TEST_TIME 74 9762
TEST_TIME 75 9723
TEST_TIME 76 9787
TEST_TIME 77 9767
TEST_TIME 78 9699
TEST_TIME 79 9646
TEST_TIME 80 9579
TEST_TIME 81 9571
TEST_TIME 82 9525
TEST_TIME 83 9483
TEST_TIME 84 9470
TEST_TIME 85 9457
TEST_TIME 86 9451
TEST_TIME 87 9491
TEST_TIME 88 9521
TEST_TIME 89 9555
TEST_TIME 90 9546
TEST_TIME 91 9563
TEST_TIME 92 9543
TEST_TIME 93 9583
TEST_TIME 94 9595
TEST_TIME 95 9622
TEST_TIME 96 9592
TEST_TIME 97 9655
TEST_TIME 98 9653
TEST_TIME 99 9659
TEST_TIME 100 9672
TEST_TIME 101 9601
TEST_TIME 102 9563
TEST_TIME 103 9556
TEST_TIME 104 9526
TEST_TIME 105 9527
TEST_TIME 106 9474
TEST_TIME 107 9488
TEST_TIME 108 9465
TEST_TIME 109 9441
TEST_TIME 110 9377
TEST_TIME 111 9418
TEST_TIME 112 9392
TEST_TIME 113 9379
TEST_TIME 114 9376
TEST_TIME 115 9388
TEST_TIME 116 9433
TEST_TIME 117 9447
TEST_TIME 118 9494
TEST_TIME 119 9480
TEST_TIME 120 9424

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-03-2021 01:28:09 to 16-03-2021 01:28:12.

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 1577467 1577467 0 0.00 0 19328 6 0 0
doc_list_biud 1577454 1577454 0 0.00 0 42392 26 0 0
sp_add_invoice_to_stock 5293 5202 91 1.71 53 222089 17496 0 91
sp_cancel_adding_invoice 5628 5628 0 0.00 6 63145 868 0 0
sp_cancel_client_order 1877 1877 0 0.00 4 10785 346 0 0
sp_cancel_customer_reserve 558885 558885 0 0.00 1 19145 57 0 0
sp_cancel_pay_from_customer 768 768 0 0.00 3 7391 78 0 0
sp_cancel_pay_to_supplier 422 422 0 0.00 3 7086 108 0 0
sp_cancel_supplier_invoice 6296 6286 10 0.15 2 16606 759 0 10
sp_cancel_supplier_order 423 423 0 0.00 10 1155497 95219 0 0
sp_cancel_write_off 9733 9733 0 0.00 1 19243 114 0 0
sp_client_order 22524 22524 0 0.00 3 17749 337 0 0
sp_customer_reserve 480752 480752 0 0.00 0 77369 173 0 0
sp_fill_shopping_cart 34171 34171 0 0.00 1 23646 37 0 0
sp_fill_shopping_cart_clo_res 480745 480745 0 0.00 0 15482 13 0 0
sp_get_clo_for_invoice 5192 5192 0 0.00 0 32792 297 0 0
sp_kill_cost_storno 16551 16551 0 0.00 0 9648 55 0 0
sp_kill_qstorno_ret_qs2qd 1134212 1134212 0 0.00 0 19203 31 0 0
sp_kill_qty_storno 598649 598649 0 0.00 0 42391 67 0 0
sp_lock_selected_doc 21925 21925 0 0.00 0 9798 4 0 0
sp_make_cost_storno 29630 29630 0 0.00 0 19281 53 0 0
sp_multiply_rows_for_pdistr 29630 29630 0 0.00 0 10655 30 0 0
sp_multiply_rows_for_qdistr 22524 22524 0 0.00 0 15572 139 0 0
sp_pay_from_customer 7569 7569 0 0.00 4 25053 130 0 0
sp_pay_to_supplier 6243 6243 0 0.00 4 13863 139 0 0
sp_payment_common 13809 13809 0 0.00 2 23545 40 0 0
sp_qd_handle_on_cancel_clo 1877 1877 0 0.00 0 10748 309 0 0
sp_qd_handle_on_invoice_upd_sts 10818 10818 0 0.00 0 42389 361 0 0
sp_qd_handle_on_reserve_upd_sts 10627 10627 0 0.00 0 21039 60 0 0
sp_reserve_write_off 10628 10628 0 0.00 6 21091 190 0 0
sp_supplier_invoice 5762 5762 0 0.00 7 72141 3090 0 0
sp_supplier_order 5895 5895 0 0.00 6 24047 1224 0 0
srv_aggregate_perf_data 107 107 0 0.00 2379 627683 22065 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1064 122019 32091 0 0
srv_find_qd_qs_mism 1080559 1080559 0 0.00 0 10898 5 0 0
srv_make_invnt_saldo 613 613 0 0.00 25 198545 1284 0 0
srv_make_money_saldo 889 889 0 0.00 1 11020 45 0 0
srv_recalc_idx_stat 4 4 0 0.00 145294 340437 212900 0 0
t$perf-abend:sp_add_invoice_to_stock 91 91 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5202 5202 0 0.00 0 13169 150 0 0
t$perf-norm:sp_cancel_adding_invoice 418 418 0 0.00 0 1902 72 0 0
t$perf-norm:sp_cancel_client_order 1877 1877 0 0.00 0 969 10 0 0
t$perf-norm:sp_cancel_customer_reserve 792 792 0 0.00 0 4462 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 768 768 0 0.00 0 5080 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 422 422 0 0.00 0 1357 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 448 448 0 0.00 0 1006 15 0 0
t$perf-norm:sp_cancel_supplier_order 423 423 0 0.00 0 26148 1457 0 0
t$perf-norm:sp_cancel_write_off 962 962 0 0.00 0 1087 6 0 0
t$perf-norm:sp_client_order 22525 22525 0 0.00 0 11574 18 0 0
t$perf-norm:sp_customer_reserve 1074 1074 0 0.00 0 3463 10 0 0
t$perf-norm:sp_pay_from_customer 7569 7569 0 0.00 0 5594 9 0 0
t$perf-norm:sp_pay_to_supplier 6244 6244 0 0.00 0 10287 12 0 0
t$perf-norm:sp_reserve_write_off 10628 10628 0 0.00 0 8226 10 0 0
t$perf-norm:sp_supplier_invoice 5762 5762 0 0.00 0 7016 20 0 0
t$perf-norm:sp_supplier_order 5895 5895 0 0.00 0 8278 18 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 79 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 269 4 0 0
t$perf-norm:srv_make_invnt_saldo 613 613 0 0.00 0 2563 25 0 0
t$perf-norm:srv_make_money_saldo 889 889 0 0.00 0 4266 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10560 10378 182 1.72 0 7308 24 0 182
v_all_customers 40750 40750 0 0.00 0 22 1 0 0
v_all_suppliers 32518 32518 0 0.00 0 16 1 0 0
v_all_wares 45048 45048 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 836 836 0 0.00 0 4638 16 0 0
v_cancel_client_order 3754 3754 0 0.00 0 7649 13 0 0
v_cancel_customer_prepayment 1536 1536 0 0.00 0 2325 4 0 0
v_cancel_customer_reserve 1584 1584 0 0.00 0 3276 7 0 0
v_cancel_payment_to_supplier 844 844 0 0.00 0 7056 12 0 0
v_cancel_supplier_invoice 916 896 20 2.18 0 6564 37 0 20
v_cancel_supplier_order 846 846 0 0.00 0 8776 19 0 0
v_cancel_write_off 1924 1924 0 0.00 0 6001 17 0 0
v_max_id_clo_ord 5893 5893 0 0.00 0 2819 1 0 0
v_max_id_clo_res 1074 1074 0 0.00 0 4960 12 0 0
v_max_id_ord_sup 5754 5754 0 0.00 0 7724 6 0 0
v_max_non_paid_invoice 1630 1630 0 0.00 0 5420 8 0 0
v_max_non_paid_realizn 4189 4189 0 0.00 0 1801 4 0 0
v_min_id_clo_ord 5893 5893 0 0.00 0 3941 6 0 0
v_min_id_clo_res 1074 1074 0 0.00 0 3673 11 0 0
v_min_id_ord_sup 5754 5754 0 0.00 0 5886 5 0 0
v_min_non_paid_invoice 6242 6242 0 0.00 0 9837 22 0 0
v_min_non_paid_realizn 7567 7567 0 0.00 0 13396 28 0 0
v_our_firm 11054 11054 0 0.00 0 14 1 0 0
v_reserve_write_off 21252 21252 0 0.00 0 8734 9 0 0
x_lock_depdocs_on_canc_invoice 11466 11466 0 0.00 0 14895 116 0 0
x_lock_depdocs_on_canc_sup_ord 423 423 0 0.00 0 2974 287 0 0
x_make_qstorno_1000_1200 5895 5895 0 0.00 2 24037 1147 0 0
x_make_qstorno_1200_2000 5762 5762 0 0.00 3 71590 2955 0 0
x_make_qstorno_2100_3300 480752 480752 0 0.00 0 77367 158 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 16-03-2021 01:28:13 to 16-03-2021 01:28:18.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:27 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:34 13657 8192000000 10216895632 10521505792 921683792 10.113 73 51 103 0 941382992 2504960 17194240
22:57:57 39609 8192000000 10355305920 10677272576 1405246224 14.642 100 83 166 0 1436993920 5058816 26688880
22:58:46 26740 8192000000 10398332736 10723373056 1449457824 15.033 100 88 176 1 1484465440 6667072 28340544
22:59:28 26073 8192000000 10425225984 10755514368 1481450880 15.314 100 90 181 0 1518292736 7912400 28929456
23:00:01 14255 8192000000 10441747216 10771267584 1492116688 15.407 100 90 180 0 1529753648 8436496 29200464
23:00:27 21502 8192000000 10454865504 10789457920 1505014032 15.520 100 84 168 2 1541171488 9088912 27068544
23:01:00 14699 8192000000 10457439696 10796900352 1518231376 15.635 100 84 168 1 1555091344 9454288 27405680
23:01:35 21392 8192000000 10499792816 10841964544 1553704560 15.942 100 90 180 0 1592149520 9864672 28580288
23:02:08 13784 8192000000 10528304528 10878603264 1572094656 16.100 100 72 145 0 1604061008 10022096 21944256
23:02:34 13956 8192000000 10552783728 10908315648 1607454080 16.403 100 69 138 2 1638156960 10008288 20694592
23:02:57 15984 8192000000 10581898272 10939748352 1639420704 16.675 100 79 158 0 1673290288 10817600 23051984
23:03:21 14025 8192000000 10593590288 10954420224 1651951648 16.781 100 79 157 0 1687069088 11802384 23315056
23:03:44 13281 8192000000 10610825488 10979086336 1672232080 16.952 100 80 158 3 1707426416 12335856 22858480
23:04:04 8915 8192000000 10636479216 11002507264 1693384736 17.130 100 78 151 3 1726969392 11515856 22068800
23:04:19 7691 8192000000 10643972928 11018989568 1706810288 17.242 100 77 154 0 1740458752 11291616 22356848
23:04:36 7607 8192000000 10649138112 11028013056 1717075056 17.328 100 69 138 1 1748176144 11679824 19421264
23:04:52 7679 8192000000 10677508880 11053682688 1742069360 17.536 100 83 166 2 1778871712 12841888 23960464
23:05:07 7872 8192000000 10695302224 11069227008 1745271792 17.562 100 80 160 1 1781435328 13141680 23021856
23:05:24 5463 8192000000 10696122992 11074191360 1753507104 17.631 100 68 136 1 1785766656 12896608 19362944
23:05:38 4090 8192000000 10712530448 11089477632 1768584880 17.755 100 80 160 0 1803758512 12946128 22227504
23:05:48 4452 8192000000 10713518784 11094962176 1775637216 17.814 100 80 158 1 1810120512 12219984 22263312
23:06:01 4732 8192000000 10721421824 11107172352 1784568176 17.887 100 75 149 2 1817036912 11475344 20993392
23:06:12 2471 8192000000 10739530944 11118202880 1796792576 17.988 100 83 166 1 1832463824 12414096 23257152
23:06:21 2781 8192000000 10735060336 11121778688 1808209280 18.081 100 80 158 3 1842258480 12214848 21834352
23:06:31 3694 8192000000 10756572560 11142197248 1813454432 18.124 100 80 160 0 1848660192 13215520 21990240
23:06:47 2397 8192000000 10780235280 11160068096 1827994784 18.243 100 86 168 0 1865247040 13741088 23511168
23:06:56 2498 8192000000 10771476624 11161550848 1831881408 18.275 100 80 160 0 1868562608 13219904 23461296
23:07:05 2117 8192000000 10784572576 11172020224 1843704512 18.371 100 89 178 2 1882676720 13995136 24977072
23:07:14 1812 8192000000 10795308912 11179196416 1848761232 18.412 100 97 194 1 1891237280 14760240 27715808
23:07:22 1756 8192000000 10798859744 11184406528 1852088448 18.439 100 97 194 1 1892820864 14254304 26478112
23:07:30 2244 8192000000 10800245680 11188359168 1859019312 18.495 100 92 184 1 1898858112 14383792 25455008
23:07:38 1869 8192000000 10808557072 11194077184 1861538960 18.516 100 95 191 1 1902745344 14647552 26558832
23:07:46 1715 8192000000 10808561808 11196989440 1866833424 18.559 100 90 179 5 1904722512 13431616 24457472
23:07:55 1982 8192000000 10815130416 11202502656 1867060032 18.560 100 95 191 2 1906496432 12802608 26633792
23:08:03 1628 8192000000 10813720864 11201355776 1867924928 18.567 100 90 181 2 1908421488 14790064 25706496
23:08:11 1314 8192000000 10822933440 11208884224 1869473072 18.580 100 95 190 0 1910875504 14894048 26508384
23:08:19 1904 8192000000 10817321456 11207417856 1873333488 18.611 100 92 184 2 1914508192 14683696 26491008
23:08:27 1311 8192000000 10815091872 11204407296 1874719536 18.622 100 97 193 0 1916186880 13227136 28240208
23:08:35 43285 8192000000 10798269040 11202973696 1865115264 18.545 100 49 96 2 1887182496 8136576 13930656
23:09:24 7856 8192000000 10809389648 11211898880 1871857888 18.599 100 61 119 0 1898080064 9970688 16251488
23:09:39 4878 8192000000 10776709968 11202772992 1869500384 18.580 100 28 56 0 1885769216 8684960 7583872
23:09:50 11541 8192000000 10785674352 11214131200 1872714784 18.606 100 26 52 1 1886610480 6530560 7365136
23:10:08 7165 8192000000 10792667808 11216146432 1878797216 18.655 100 33 66 1 1896647728 8448336 9402176
23:10:23 6011 8192000000 10788161056 11217063936 1879238688 18.659 100 23 46 2 1893822160 7861792 6721680
23:10:41 7107 8192000000 10790591616 11218604032 1878716112 18.655 100 19 38 1 1890695488 5636496 6342880
23:10:56 4291 8192000000 10793175648 11219992576 1881151280 18.674 100 28 56 4 1896450304 7421232 7877792
23:11:08 6679 8192000000 10796182816 11222884352 1886586528 18.718 100 28 56 1 1901304464 6027264 8690672
23:11:21 8666 8192000000 10801580080 11229175808 1887611712 18.727 100 19 38 0 1899230336 6240560 5378064
23:11:41 6753 8192000000 10787970592 11226361856 1893067808 18.770 100 16 32 1 1903268848 5740080 4460960
23:11:57 16429 8192000000 10792051456 11231547392 1888860960 18.737 100 9 18 0 1896959408 5520448 2578000
23:12:20 9048 8192000000 10805416400 11237449728 1893929344 18.777 100 19 38 2 1905530096 6422176 5178576
23:12:37 8593 8192000000 10797504816 11239665664 1895156720 18.787 100 18 33 2 1907496704 6383536 5956448
23:12:53 9812 8192000000 10810990432 11240710144 1897420032 18.806 100 17 34 0 1907738064 5385904 4932128
23:13:11 15287 8192000000 10814098544 11246870528 1901667616 18.840 100 23 44 5 1917407120 9522816 6216688
23:13:33 13504 8192000000 10810785616 11246198784 1903563408 18.855 100 22 43 2 1915745536 5479408 6702720
23:14:40 28276 8192000000 10822080816 11256934400 1904737664 18.864 100 20 38 1 1916376288 6687216 4951408
23:15:15 7910 8192000000 10822222368 11258494976 1906840192 18.881 100 16 32 3 1917701488 6523456 4337840
23:15:30 7379 8192000000 10821304304 11262902272 1912911168 18.930 100 27 54 0 1926924432 6410896 7602368
23:15:44 6873 8192000000 10825316336 11257843712 1906476320 18.878 100 26 52 0 1921028880 7081360 7471200
23:15:58 3940 8192000000 10822853808 11258261504 1905584816 18.871 100 23 46 2 1917016912 5204192 6227904
23:16:11 8030 8192000000 10820193712 11258208256 1906874032 18.882 100 18 34 0 1916906960 5163616 4869312
23:16:29 10560 8192000000 10813597216 11252867072 1890347488 18.749 99 20 40 0 1901955472 5874352 5733632
23:16:48 9550 8192000000 10813593760 11246710784 1880772208 18.671 99 17 35 2 1890770720 5181792 4816720
23:17:05 5054 8192000000 10808558448 11246813184 1886243056 18.715 99 25 50 1 1900536544 6022368 8271120
23:17:17 11335 8192000000 10819098480 11252674560 1897799088 18.809 100 17 32 2 1908822384 5572256 5451040
23:17:34 10026 8192000000 10793693680 11224670208 1841820480 18.356 97 16 32 1 1851769824 5250496 4698848
23:17:54 10385 8192000000 10754087584 11192786944 1763661824 17.715 94 8 16 0 1770842544 5360000 1820720
23:18:12 3670 8192000000 10749206112 11177525248 1797038912 17.990 97 26 51 0 1814081264 10256128 6786224
23:18:22 37950 8192000000 10769759408 11193589760 1802570624 18.035 97 24 48 1 1814630912 4760912 7299376
23:19:08 25565 8192000000 10717414864 11142410240 1702692608 17.208 92 40 80 1 1720234224 5411408 12130208
23:19:40 9417 8192000000 10673994992 11092574208 1644717536 16.720 91 27 54 0 1665420256 14091920 6610800
23:19:57 5783 8192000000 10709551040 11123068928 1749437360 17.597 97 40 80 0 1767824592 6281184 12106048
23:20:10 5568 8192000000 10716800528 11136167936 1781572048 17.862 99 23 46 0 1794540592 6497680 6470864
23:20:23 5297 8192000000 10702095104 11116261376 1747739264 17.583 97 22 44 1 1760415504 6595840 6080400
23:20:35 7582 8192000000 10701681776 11122298880 1758858288 17.675 98 21 41 0 1770476432 5663056 5955088
23:20:49 11152 8192000000 10694514592 11109691392 1723811376 17.384 95 25 50 1 1736714352 5464592 7438384
23:21:08 9159 8192000000 10695492096 11111460864 1765056688 17.726 99 29 58 3 1779143776 5091440 8995648
23:21:24 7367 8192000000 10692248656 11109847040 1750386688 17.605 98 23 45 2 1761856240 4995824 6473728
23:21:38 6029 8192000000 10720220496 11125719040 1771206064 17.777 99 28 56 1 1789385808 10187776 7991968
23:21:54 8848 8192000000 10703948256 11117965312 1744060096 17.552 97 24 48 2 1756726336 5415568 7250672
23:22:11 7595 8192000000 10717260560 11132973056 1790286864 17.934 99 27 53 3 1803298304 5147328 7864112
23:22:27 5779 8192000000 10715368720 11140849664 1805539904 18.059 100 22 44 2 1817884880 6004288 6340688
23:22:42 10792 8192000000 10731277040 11158327296 1820272640 18.180 100 17 34 1 1830870528 5611024 4986864
23:23:00 13530 8192000000 10742676656 11174334464 1829576096 18.256 100 7 14 1 1836605200 4998960 2030144
23:23:23 47620 8192000000 10768955216 11187617792 1846679792 18.395 100 18 36 1 1857388720 5052464 5656464
23:24:29 12106 8192000000 10755181920 11192000512 1854854976 18.462 100 25 50 1 1868299760 5713488 7731296
23:24:49 8706 8192000000 10781891552 11202957312 1856508032 18.475 100 28 56 3 1871031008 5789232 8733744
23:25:08 9799 8192000000 10773993808 11203272704 1864721248 18.542 100 29 58 1 1879226848 6294032 8211568
23:25:24 10092 8192000000 10791512240 11211563008 1865280896 18.546 100 38 76 0 1882330160 6608160 10441104
23:25:42 6784 8192000000 10779567952 11205693440 1863964800 18.535 100 29 58 4 1878743456 6453088 8325568
23:25:57 6597 8192000000 10772359152 11203502080 1862257040 18.522 100 20 39 3 1874574832 5553328 6764464
23:26:10 11616 8192000000 10766014816 11204771840 1862053872 18.520 100 18 36 0 1873484752 5802272 5628608
23:26:28 8012 8192000000 10785833424 11216793600 1869724848 18.582 100 26 52 2 1883065888 6076960 7264080
23:26:42 10334 8192000000 10783925680 11214565376 1871264080 18.595 100 26 52 1 1884712272 5146384 8301808
23:26:59 16453 8192000000 10802069888 11231006720 1881312304 18.676 100 17 32 2 1890620944 4670400 4638240
23:27:23 8253 8192000000 10823179344 11244679168 1896547792 18.799 100 23 46 2 1908736096 5195280 6993024
23:27:41 2259 8192000000 10849035376 11260567552 1917648800 18.968 100 57 113 1 1940040928 6190096 16202032
23:27:54 53115 8192000000 10845106688 11273564160 1922028416 19.003 100 32 62 1 1940533008 9572016 8932576
23:28:57 37192 8192000000 10863979936 11294121984 1935042064 19.107 100 58 116 1 1962587504 10567280 16978160
23:29:46 87837 8192000000 10867937232 11305725952 1942711120 19.168 100 36 70 2 1963947344 10695600 10540624
23:31:24 22581 8192000000 10874351248 11312799744 1950859248 19.233 100 39 78 2 1972791968 10392320 11540400
23:31:55 18313 8192000000 10879368352 11317399552 1955007536 19.266 100 34 68 4 1976677696 11388672 10281488
23:32:21 15329 8192000000 10896392976 11326889984 1960146288 19.307 100 46 92 0 1985749760 12777120 12826352
23:32:50 7228 8192000000 10899560928 11330158592 1966589856 19.358 100 61 121 2 1995838720 12610912 16637952
23:33:04 5863 8192000000 10907678640 11333746688 1965390368 19.349 100 61 117 0 1996934736 14601952 16942416
23:33:18 4822 8192000000 10909005824 11336998912 1966778720 19.360 100 59 118 0 1999471104 16121568 16570816
23:33:30 4033 8192000000 10919424688 11332567040 1951643216 19.240 99 74 149 1 1988985520 16919584 20422720
23:33:43 4448 8192000000 10909988240 11331723264 1947165696 19.204 99 68 136 1 1984743296 17465440 20112160
23:33:54 14384 8192000000 10908646448 11338797056 1965044000 19.346 100 56 111 0 1995791296 15108240 15639056
23:34:22 9473 8192000000 10919239776 11345858560 1971952336 19.401 100 52 104 2 2003361408 16420880 14988192
23:34:40 4279 8192000000 10935805904 11350605824 1981387424 19.476 100 72 141 1 2017353120 15339680 20626016
23:34:52 8708 8192000000 10919670480 11349106688 1966091920 19.354 99 70 139 3 2002854304 16152224 20610160
23:35:09 20862 8192000000 10928034896 11359973376 1981316400 19.475 100 56 110 2 2013648912 15086928 17245584
23:35:42 14946 8192000000 10917950336 11351748608 1966509824 19.358 99 44 86 2 1990970480 12040320 12420336
23:36:08 4349 8192000000 10933315712 11355910144 1984638064 19.501 100 59 118 1 2016179152 13949584 17591504
23:36:22 2903 8192000000 10938729056 11355713536 1988965760 19.536 100 75 146 1 2026228448 16013216 21249472
23:36:32 7031 8192000000 10944031728 11361693696 1988637584 19.533 100 75 148 1 2027430496 17647632 21145280
23:36:46 11306 8192000000 10926672656 11353423872 1970020480 19.386 99 62 124 3 2005021856 16993728 18007648
23:37:06 16869 8192000000 10951698560 11365355520 1991522256 19.556 100 63 123 2 2027391712 18536176 17333280
23:37:34 8763 8192000000 10920874624 11349737472 1972798752 19.408 99 57 114 2 2009165856 19559664 16807440
23:37:53 6101 8192000000 10932988336 11352055808 1950936640 19.234 98 68 132 2 1989008320 18921312 19150368
23:38:11 2955 8192000000 10951875808 11362017280 1984965488 19.504 100 74 148 0 2028683456 22285648 21432320
23:38:29 5416 8192000000 10941931168 11371364352 1991503824 19.556 100 71 139 1 2035241376 22507248 21230304
23:38:42 3919 8192000000 10943273264 11370881024 1988203840 19.530 100 60 118 2 2031387568 25614288 17569440
23:38:52 6704 8192000000 10939184352 11358801920 1980979984 19.472 100 66 132 2 2022361376 21345360 20036032
23:39:07 8282 8192000000 10967589584 11377512448 1994465904 19.579 100 82 161 1 2040592224 21859904 24266416
23:39:22 2187 8192000000 10966692672 11383730176 2002722240 19.644 100 86 171 1 2052699488 23255424 26721824
23:39:31 1751 8192000000 10969243600 11385044992 2002977184 19.646 100 88 175 1 2052901120 24440560 25483376
23:39:40 2588 8192000000 10959485632 11367849984 1974134528 19.418 99 89 177 1 2026855232 26410432 26310272
23:39:49 6888 8192000000 10932788336 11357237248 1954685920 19.264 98 83 166 0 2006543056 26084624 25772512
23:40:04 2483 8192000000 10945971088 11358654464 1976476480 19.437 100 78 156 1 2027598512 27762912 23359120
23:40:14 2488 8192000000 10921644384 11333029888 1952808400 19.249 99 76 151 1 2003419488 27713376 22897712
23:40:26 2843 8192000000 10941929712 11351834624 1968876800 19.377 100 76 148 1 2018801616 26769744 23155072
23:40:37 2937 8192000000 10933557984 11350396928 1964115424 19.339 100 77 152 1 2015607712 28042336 23449952
23:40:49 9100 8192000000 10931177120 11354300416 1966337424 19.356 100 67 133 1 2014721552 27558976 20825152
23:41:17 7183 8192000000 10910099120 11338997760 1926445808 19.038 98 59 118 2 1975484272 30202464 18836000
23:41:33 3853 8192000000 10903029888 11313782784 1928039248 19.051 99 71 142 1 1981028896 30636640 22353008
23:41:45 2682 8192000000 10907813824 11321659392 1919067776 18.979 98 86 172 2 1977765168 31313872 27383520
23:41:54 7289 8192000000 10923366064 11340230656 1945166112 19.188 100 72 144 1 2002305248 34800544 22338592
23:42:10 2670 8192000000 10932745952 11351105536 1956805584 19.281 100 74 148 2 2015616800 35053872 23757344
23:42:23 3162 8192000000 10904279472 11320963072 1914455312 18.942 98 61 122 1 1967563072 33106848 20000912
23:42:33 9250 8192000000 10927968688 11345412096 1956057024 19.275 100 73 142 2 2011158368 32673072 22428272
23:42:49 1789 8192000000 10935811776 11340427264 1938566000 19.135 99 82 161 1 1997649584 33192688 25890896
23:42:58 12719 8192000000 10917001232 11332673536 1929210304 19.061 99 68 136 0 1986901840 35623648 22067888
23:43:19 3793 8192000000 10915893920 11330002944 1944037184 19.179 100 79 158 3 2003838048 33967040 25833824
23:43:31 6298 8192000000 10914190192 11327639552 1937575808 19.127 100 74 150 1 1996151296 35555616 23019872
23:43:45 4869 8192000000 10927472160 11334291456 1945950336 19.194 100 89 178 0 2009130992 35924720 27255936
23:43:58 2442 8192000000 10938084608 11348471808 1960116000 19.307 100 88 176 1 2024201888 36729888 27356000
23:44:07 4089 8192000000 10937349872 11350880256 1956025792 19.274 100 84 167 1 2019265296 37921120 25318384
23:44:19 4664 8192000000 10930187408 11345334272 1958217696 19.292 100 81 163 1 2015584128 31510288 25856144
23:44:31 4752 8192000000 10919390384 11331616768 1931359872 19.078 99 70 139 0 1985061840 31203920 22498048
23:44:43 2555 8192000000 10909944816 11322986496 1933856640 19.098 100 70 140 0 1991117984 34719984 22541360
23:44:53 5823 8192000000 10894581088 11307429888 1921256960 18.997 100 66 132 1 1974081488 31786896 21037632
23:45:16 7543 8192000000 10904769360 11316822016 1930075728 19.067 100 80 158 2 1988612288 33836432 24700128
23:45:35 1523 8192000000 10904527744 11309793280 1924316944 19.021 100 78 155 2 1983810304 35236672 24256688
23:45:46 2064 8192000000 10912140352 11311902720 1925075840 19.027 100 77 153 1 1985050448 36043440 23931168
23:45:56 3856 8192000000 10891982432 11311456256 1922091920 19.004 100 59 117 2 1974012640 33676592 18244128
23:46:11 4286 8192000000 10895554032 11320680448 1936826912 19.121 100 62 120 1 1986485712 30792240 18866560
23:46:24 7873 8192000000 10902076192 11329474560 1938157696 19.132 100 43 86 0 1980827664 29157216 13512752
23:46:42 10823 8192000000 10890285600 11320762368 1920508880 18.991 99 38 76 0 1958377552 25412032 12456640
23:47:00 11689 8192000000 10904686592 11331190784 1943316048 19.173 100 41 82 1 1983092480 26349424 13427008
23:47:18 6163 8192000000 10924732416 11348340736 1955896912 19.273 100 59 118 2 2006170624 30708656 19565056
23:47:36 8065 8192000000 10885740512 11329781760 1919986416 18.987 98 44 86 0 1968349744 34606560 13756768
23:47:52 11353 8192000000 10906615104 11339935744 1935440512 19.110 99 37 70 0 1975132688 28456672 11235504
23:48:24 4045 8192000000 10934156960 11339501568 1951540800 19.239 100 79 157 4 2005185424 29073104 24571520
23:48:35 4850 8192000000 10922437936 11348250624 1950175008 19.228 100 53 106 0 2001124096 33892288 17056800
23:48:49 5520 8192000000 10929120448 11352444928 1954558272 19.263 100 59 118 0 2009544896 35960272 19026352
23:49:02 1974 8192000000 10953574368 11374112768 1969706192 19.383 100 76 151 1 2031349680 38254448 23389040
23:49:10 4618 8192000000 10935032832 11375583232 1967135008 19.363 100 52 104 0 2025126672 41134336 16857328
23:49:37 15310 8192000000 10930574112 11372654592 1965707552 19.351 100 34 68 2 2013054624 35995904 11351168
23:50:07 12881 8192000000 10940774656 11385196544 1973455856 19.413 100 35 70 1 2026913264 40874608 12582800
23:50:41 4805 8192000000 10955226192 11382284288 1972309856 19.404 100 45 91 0 2029582880 41836960 15436064
23:50:53 1721 8192000000 10982611104 11397529600 1981836208 19.479 100 91 179 1 2053928624 43627440 28464976
23:51:01 12479 8192000000 10940697648 11387514880 1974003600 19.417 100 47 94 4 2035000864 45735184 15262080
23:51:20 20159 8192000000 10943678464 11394347008 1971348592 19.396 100 24 48 0 2022553664 42463504 8741568
23:52:02 15996 8192000000 10927294320 11372244992 1949371360 19.221 99 33 66 2 2000212848 38764880 12076608
23:52:37 21655 8192000000 10923285936 11361472512 1925471248 19.031 98 28 56 0 1971576272 36734720 9370304
23:53:06 14328 8192000000 10895263456 11346190336 1933295248 19.093 99 33 66 0 1984359472 40268800 10795424
23:53:27 18744 8192000000 10900776448 11354992640 1927630144 19.048 99 22 45 1 1977065280 41314720 8120416
23:53:52 20590 8192000000 10910669872 11361923072 1930120064 19.068 99 31 62 3 1982283024 42384608 9778352
23:54:22 12866 8192000000 10921953264 11366756352 1946949088 19.202 100 22 44 2 1999253040 45260256 7043696
23:54:49 17618 8192000000 10928037696 11378114560 1959607520 19.303 100 25 50 1 2014372464 46284896 8480048
23:55:22 20291 8192000000 10927825040 11378339840 1953718512 19.256 100 25 49 4 2011026864 48758208 8550144
23:55:49 16132 8192000000 10919109280 11368669184 1913738928 18.937 98 18 36 1 1972479424 51771504 6968992
23:56:26 94772 8192000000 10917563120 11366739968 1945279136 19.189 100 21 42 3 1987911504 35593936 7038432
23:58:10 16298 8192000000 10910718544 11380064256 1958759296 19.296 100 29 58 0 2005168288 36877664 9531328
23:59:19 42494 8192000000 10901929312 11378843648 1967966192 19.369 100 22 42 1 1991073536 17802928 5304416
00:00:08 52345 8192000000 10919337040 11380219904 1982976752 19.488 100 19 39 2 1998904672 10046224 5881696
00:01:11 90641 8192000000 10898307712 11368960000 1945198224 19.188 98 28 58 2 1963500720 10510800 7791696
00:03:27 86576 8192000000 10908489504 11367845888 1958524960 19.294 99 23 46 2 1973470944 8450800 6495184
00:05:15 113823 8192000000 10915925920 11396509696 1979162768 19.458 100 11 22 0 1999920592 17902224 2855600
00:07:15 70930 8192000000 10944373648 11387731968 1972723888 19.407 99 28 57 0 1990856032 9616416 8515728
00:08:34 69278 8192000000 10941958144 11405348864 1998734880 19.613 100 20 40 0 2013631392 9168976 5727536
00:10:01 68722 8192000000 10931554944 11415216128 1979902128 19.464 99 7 14 0 1999332704 17430128 2000448
00:11:51 102674 8192000000 10927017920 11384561664 1934017360 19.099 97 13 26 0 1952236848 14629728 3589760
00:13:39 37618 8192000000 10912953088 11377995776 1964679920 19.343 99 13 26 1 1978880368 10784512 3415936
00:14:23 99064 8192000000 10922979728 11392335872 1925129760 19.028 97 10 20 2 1947461216 19323120 3008336
00:17:30 69002 8192000000 10924432368 11379462144 1948344592 19.213 98 34 69 0 1965118944 7813424 8960928
00:18:46 92574 8192000000 10905791760 11378487296 1966528432 19.358 99 35 70 0 1995397424 18872512 9996480
00:20:35 1064 8192000000 10898639472 11369594880 1970230560 19.387 100 20 40 1 1989429552 13872512 5326480
00:20:42 10473 8192000000 10906896224 11369230336 1970701872 19.391 100 24 48 1 1985636768 7889248 7045648
00:21:00 12355 8192000000 10904824992 11367612416 1971679104 19.399 100 23 46 0 1985896992 7957664 6260224
00:21:21 34299 8192000000 10922863616 11382546432 1979426704 19.460 100 22 44 0 1993941520 8740336 5774480
00:22:03 39651 8192000000 10938356848 11399000064 1995259872 19.585 100 35 70 3 2015049264 8856256 10933136
00:22:50 79791 8192000000 10900203680 11384184832 1933707232 19.097 97 27 55 2 1959711936 17924368 8080336
00:24:20 29427 8192000000 10891902960 11371442176 1940973744 19.155 98 17 36 0 1960821520 15136256 4711520
00:25:05 32545 8192000000 10866774816 11339235328 1910474384 18.910 97 12 24 0 1925024256 10781792 3768080
00:25:44 27762 8192000000 10860412112 11322077184 1899943088 18.826 97 11 21 1 1913027200 10272992 2811120
00:26:19 61650 8192000000 10853466912 11328274432 1890602400 18.751 97 14 28 1 1905862464 10904400 4355664
00:27:27 81857 8192000000 10829406032 11297423360 1875364672 18.628 97 13 25 1 1890855312 11806928 3683712
00:28:55 49464 8192000000 10848512976 11316383744 1910841088 18.913 99 19 38 1 1925316272 8896672 5578512
00:30:04 60042 8192000000 10830002096 11303636992 1898909392 18.818 98 15 30 0 1912658496 8915440 4833664
00:31:10 73949 8192000000 10809624960 11287302144 1793749168 17.963 93 16 32 1 1806143568 7821472 4572928
00:32:51 17552 8192000000 10874076096 11324203008 1889899360 18.745 98 40 77 1 1907889424 7453376 10536688
00:33:26 81830 8192000000 10857589456 11327623168 1868999920 18.576 97 19 38 1 1892036288 17557648 5478720
00:34:55 52168 8192000000 10869759344 11325624320 1894730144 18.784 98 20 40 0 1917797040 16705744 6361152
00:35:56 42118 8192000000 10888081536 11348443136 1942735312 19.169 100 42 84 0 1966403072 11746496 11921264
00:37:05 51244 8192000000 10855405568 11327217664 1847989024 18.406 95 10 20 1 1865680432 14931360 2760048
00:38:07 122018 8192000000 10863714496 11335823360 1849033216 18.414 96 10 20 0 1870974832 19231808 2709808
00:40:22 50377 8192000000 10873055264 11327426560 1874879888 18.624 97 13 26 2 1887066096 8347200 3839008
00:42:16 31753 8192000000 10887440704 11335319552 1943739408 19.177 100 38 76 0 1964198672 9077824 11381440
00:42:58 23469 8192000000 10885041632 11341791232 1912113168 18.924 98 50 101 0 1939183232 13500048 13570016
00:43:37 32823 8192000000 10872717088 11328114688 1920928368 18.994 99 32 64 0 1940353008 10647568 8777072
00:44:23 31525 8192000000 10884554080 11325657088 1890079696 18.746 97 40 80 0 1909983104 9488320 10415088
00:45:02 50670 8192000000 10882723936 11341000704 1949435888 19.222 100 50 101 0 1973675120 10182608 14056624
00:46:19 63426 8192000000 10885836624 11351928832 1954738640 19.264 100 23 43 5 1969407152 8614432 6054080
00:47:34 56461 8192000000 10895748304 11366797312 1971353872 19.396 100 26 52 1 1988932608 10628128 6950608
00:49:03 54525 8192000000 10876732528 11365228544 1926892496 19.042 98 8 16 1 1948181632 18870080 2419056
00:50:04 50733 8192000000 10884165808 11370631168 1950742272 19.232 100 12 24 1 1977500560 22930192 3828096
00:51:01 44592 8192000000 10896189584 11370819584 1963890608 19.337 100 15 30 1 1980890496 12693440 4306448
00:51:52 59680 8192000000 10880940480 11352616960 1900815296 18.833 96 23 46 0 1920028384 12398336 6814752
00:52:59 110293 8192000000 10895449184 11393359872 1961054064 19.314 100 18 36 0 1988210304 21548624 5607616
00:55:01 40437 8192000000 10905381392 11383361536 1967072832 19.362 100 17 34 1 1990022960 17596784 5353344
00:56:07 100793 8192000000 10922370320 11385700352 1937889872 19.130 98 16 32 1 1966126112 23607120 4629120
00:57:56 24585 8192000000 10919880640 11366670336 1931195328 19.076 97 31 62 3 1947330656 7823872 8311456
00:58:49 47773 8192000000 10902689888 11370598400 1937273168 19.125 98 11 22 0 1948386144 7871120 3241856
00:59:44 56653 8192000000 10890610608 11357888512 1924399792 19.022 97 36 72 1 1946002672 11482160 10120720
01:01:15 43171 8192000000 10899561600 11372781568 1905165744 18.868 96 20 40 1 1919449264 8929216 5354304
01:02:16 86809 8192000000 10917356032 11387699200 1956305296 19.277 99 8 16 0 1968253584 10051936 1896352
01:03:53 31455 8192000000 10925826032 11389038592 1965843968 19.352 99 27 54 1 1983154864 9970784 7340112
01:04:31 70206 8192000000 10913227392 11387015168 1962660176 19.327 99 26 52 1 1985447904 15387040 7400688
01:05:48 119218 8192000000 10921284160 11401977856 1927878112 19.050 97 13 26 1 1941912704 10475312 3559280
01:07:57 84592 8192000000 10939430816 11397619712 1974017872 19.417 99 35 70 1 1996697424 12640896 10038656
01:09:31 81557 8192000000 10886524320 11363147776 1925066944 19.027 97 18 35 2 1937283424 7529440 4687040
01:11:26 28841 8192000000 10899171760 11379298304 1961937456 19.321 99 23 46 2 1980385504 11436208 7011840
01:12:02 34756 8192000000 10905461472 11380162560 1985993296 19.512 100 23 46 2 2002927088 10380688 6553104
01:12:44 104124 8192000000 10890682976 11379167232 1925116816 19.028 97 15 30 0 1945730400 16839216 3774368
01:14:34 47102 8192000000 10877161296 11354292224 1897753920 18.808 96 13 26 0 1912280624 10864704 3662000
01:15:28 65692 8192000000 10833139488 11311222784 1859158048 18.496 95 9 18 2 1871782096 9948640 2675408
01:16:42 79522 8192000000 10865692784 11341770752 1903531376 18.855 98 9 18 0 1917052048 10977744 2542928
01:18:08 76833 8192000000 10856030032 11332173824 1838607072 18.329 95 13 25 0 1854670304 12536864 3526368
01:19:37 55587 8192000000 10832868352 11300052992 1809019952 18.088 93 20 40 1 1822522960 8287840 5215168
01:20:49 41976 8192000000 10861802672 11318853632 1884268160 18.700 98 25 50 2 1902882096 11362896 7251040
01:21:41 44102 8192000000 10843291680 11317006336 1884339664 18.700 98 23 46 2 1904405504 13270976 6794864
01:22:33 93854 8192000000 10821006864 11308179456 1821946464 18.194 95 22 44 0 1846458192 18136256 6375472
01:24:28 56492 8192000000 10844767968 11317964800 1899404704 18.822 99 16 32 1 1922996656 19267232 4324720
01:26:07 80606 8192000000 9870963344 10233389056 937530768 10.269 49 6 12 0 947001456 7404672 2066016

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 16-03-2021 01:28:19 to 16-03-2021 01:28:51.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 91 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-03-2021 01:28:52 to 16-03-2021 01:28:54.

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          249749
MON$OLDEST_ACTIVE               250212
MON$OLDEST_SNAPSHOT             250212
MON$NEXT_TRANSACTION            250212
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                       2055776
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.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 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 ---
:129: 
:130: mscs-test-161.budzdorov.ru    Tue Mar 16 01:27:31 2021
:131:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:132: 
:133: 
:134: mscs-test-161.budzdorov.ru    Tue Mar 16 01:27:31 2021
:135:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:136: 
--- end of diff output ---

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

16.03.21 01:28:55. 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-03-16 01:28:57 No severe PSQL-related problems occured
16.03.21 01:28:58. End of report.