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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17056804 kB
MemAvailable 31379256 kB
Buffers 0 kB
Cached 14657416 kB
SwapCached 4864 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-14 22:27:12
DTS_END                         2021-01-14 22:27:12.6050
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53338
TRN_ID                          247811
ATT_ID                          726
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: 9510.29 24682 1141235
customer order: creation 177.38 341 21286
customer order: refuse 15.18 315 1821
order to supplier: creation 47.00 1268 5640
order to supplier: removal 3.58 95018 430
invoice (draft): creation 47.12 3329 5654
invoice (draft): removal 54.31 724 6517
invoice accept: apply 44.00 17335 5280
invoice accept: cancel 48.83 748 5859
customer reserve: creation 3978.09 175 477371
customer reserve: removal 4787.68 55 574521
realization accept: apply 86.52 169 10382
realization accept: cancel 85.98 105 10317
payment from customer: creation 61.60 113 7392
payment from customer: removal 5.61 69 673
payment to supplier: creation 50.87 125 6104
payment to supplier: removal 3.62 60 434
service: total inventory turnovers 4.87 1057 584
service: total monetary turnovers 7.12 24 854
service: aggregate perf. data 0.93 19909 112
service: refresh index statistics 0.03 352709 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-01-2021 22:29:21 to 14-01-2021 22:29:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3452
TEST_TIME 2 3221
TEST_TIME 3 4387
TEST_TIME 4 4953
TEST_TIME 5 5456
TEST_TIME 6 5968
TEST_TIME 7 6359
TEST_TIME 8 6229
TEST_TIME 9 6174
TEST_TIME 10 6154
TEST_TIME 11 6425
TEST_TIME 12 6706
TEST_TIME 13 6706
TEST_TIME 14 6923
TEST_TIME 15 7128
TEST_TIME 16 7233
TEST_TIME 17 7535
TEST_TIME 18 7808
TEST_TIME 19 8067
TEST_TIME 20 8458
TEST_TIME 21 8509
TEST_TIME 22 8729
TEST_TIME 23 8846
TEST_TIME 24 9637
TEST_TIME 25 9488
TEST_TIME 26 9539
TEST_TIME 27 10278
TEST_TIME 28 10868
TEST_TIME 29 10805
TEST_TIME 30 10942
TEST_TIME 31 10953
TEST_TIME 32 10735
TEST_TIME 33 10602
TEST_TIME 34 10690
TEST_TIME 35 10743
TEST_TIME 36 10676
TEST_TIME 37 10622
TEST_TIME 38 10362
TEST_TIME 39 10175
TEST_TIME 40 10225
TEST_TIME 41 10210
TEST_TIME 42 10100
TEST_TIME 43 10092
TEST_TIME 44 10055
TEST_TIME 45 9977
TEST_TIME 46 10132
TEST_TIME 47 9998
TEST_TIME 48 9927
TEST_TIME 49 9840
TEST_TIME 50 9857
TEST_TIME 51 9706
TEST_TIME 52 9640
TEST_TIME 53 9664
TEST_TIME 54 9551
TEST_TIME 55 9581
TEST_TIME 56 9560
TEST_TIME 57 9541
TEST_TIME 58 9561
TEST_TIME 59 9515
TEST_TIME 60 9570
TEST_TIME 61 9692
TEST_TIME 62 9726
TEST_TIME 63 9800
TEST_TIME 64 9803
TEST_TIME 65 9879
TEST_TIME 66 9839
TEST_TIME 67 9912
TEST_TIME 68 9980
TEST_TIME 69 10025
TEST_TIME 70 9993
TEST_TIME 71 9869
TEST_TIME 72 9820
TEST_TIME 73 9788
TEST_TIME 74 9790
TEST_TIME 75 9813
TEST_TIME 76 9774
TEST_TIME 77 9739
TEST_TIME 78 9740
TEST_TIME 79 9668
TEST_TIME 80 9657
TEST_TIME 81 9623
TEST_TIME 82 9557
TEST_TIME 83 9622
TEST_TIME 84 9621
TEST_TIME 85 9603
TEST_TIME 86 9667
TEST_TIME 87 9632
TEST_TIME 88 9618
TEST_TIME 89 9645
TEST_TIME 90 9694
TEST_TIME 91 9674
TEST_TIME 92 9814
TEST_TIME 93 9811
TEST_TIME 94 9934
TEST_TIME 95 9854
TEST_TIME 96 9770
TEST_TIME 97 9762
TEST_TIME 98 9730
TEST_TIME 99 9723
TEST_TIME 100 9703
TEST_TIME 101 9676
TEST_TIME 102 9652
TEST_TIME 103 9653
TEST_TIME 104 9646
TEST_TIME 105 9728
TEST_TIME 106 9687
TEST_TIME 107 9659
TEST_TIME 108 9710
TEST_TIME 109 9762
TEST_TIME 110 9754
TEST_TIME 111 9758
TEST_TIME 112 9761
TEST_TIME 113 9691
TEST_TIME 114 9689
TEST_TIME 115 9632
TEST_TIME 116 9649
TEST_TIME 117 9635
TEST_TIME 118 9618
TEST_TIME 119 9578
TEST_TIME 120 9514

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-01-2021 22:29:25 to 14-01-2021 22:29:28.

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 1584837 1584837 0 0.00 0 23840 6 0 0
doc_list_biud 1584833 1584833 0 0.00 0 30948 26 0 0
sp_add_invoice_to_stock 5357 5280 77 1.43 38 198122 17335 0 77
sp_cancel_adding_invoice 5859 5859 0 0.00 4 88230 748 0 0
sp_cancel_client_order 1821 1821 0 0.00 4 7518 315 0 0
sp_cancel_customer_reserve 574521 574521 0 0.00 1 30980 56 0 0
sp_cancel_pay_from_customer 673 673 0 0.00 2 5489 69 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 3 1712 60 0 0
sp_cancel_supplier_invoice 6523 6517 6 0.09 1 21523 725 0 6
sp_cancel_supplier_order 430 430 0 0.00 7 939794 95018 0 0
sp_cancel_write_off 10317 10317 0 0.00 1 17359 105 0 0
sp_client_order 21286 21286 0 0.00 3 25445 342 0 0
sp_customer_reserve 477371 477371 0 0.00 0 51469 175 0 0
sp_fill_shopping_cart 32572 32572 0 0.00 1 16613 39 0 0
sp_fill_shopping_cart_clo_res 477363 477363 0 0.00 0 15969 13 0 0
sp_get_clo_for_invoice 5272 5272 0 0.00 0 19648 262 0 0
sp_kill_cost_storno 17283 17283 0 0.00 0 23505 56 0 0
sp_kill_qstorno_ret_qs2qd 1166306 1166306 0 0.00 0 30928 30 0 0
sp_kill_qty_storno 615114 615114 0 0.00 0 30946 65 0 0
sp_lock_selected_doc 21520 21520 0 0.00 0 7289 4 0 0
sp_make_cost_storno 29148 29148 0 0.00 0 23830 57 0 0
sp_multiply_rows_for_pdistr 29146 29146 0 0.00 0 10350 27 0 0
sp_multiply_rows_for_qdistr 21286 21286 0 0.00 0 10115 137 0 0
sp_pay_from_customer 7392 7392 0 0.00 4 18466 113 0 0
sp_pay_to_supplier 6104 6104 0 0.00 5 24930 126 0 0
sp_payment_common 13496 13496 0 0.00 1 16995 30 0 0
sp_qd_handle_on_cancel_clo 1821 1821 0 0.00 0 7511 296 0 0
sp_qd_handle_on_invoice_upd_sts 11127 11127 0 0.00 0 23331 328 0 0
sp_qd_handle_on_reserve_upd_sts 10381 10381 0 0.00 0 22665 59 0 0
sp_reserve_write_off 10382 10382 0 0.00 6 22689 169 0 0
sp_supplier_invoice 5654 5654 0 0.00 6 71778 3330 0 0
sp_supplier_order 5640 5640 0 0.00 5 25173 1269 0 0
srv_aggregate_perf_data 112 112 0 0.00 1921 355243 19909 0 0
srv_fill_mon_cache_memory 171 171 0 0.00 1407 136953 31107 0 0
srv_find_qd_qs_mism 1092679 1092679 0 0.00 0 19570 5 0 0
srv_make_invnt_saldo 584 584 0 0.00 40 49102 1058 0 0
srv_make_money_saldo 854 854 0 0.00 1 784 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 242275 462939 352710 0 0
t$perf-abend:sp_add_invoice_to_stock 77 77 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5280 5280 0 0.00 0 15958 153 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 0 1924 66 0 0
t$perf-norm:sp_cancel_client_order 1821 1821 0 0.00 0 4879 17 0 0
t$perf-norm:sp_cancel_customer_reserve 682 682 0 0.00 0 6198 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 673 673 0 0.00 0 1915 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 273 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 425 425 0 0.00 0 2397 28 0 0
t$perf-norm:sp_cancel_supplier_order 430 430 0 0.00 0 24071 1576 0 0
t$perf-norm:sp_cancel_write_off 998 998 0 0.00 0 1876 8 0 0
t$perf-norm:sp_client_order 21286 21286 0 0.00 0 11898 18 0 0
t$perf-norm:sp_customer_reserve 1057 1057 0 0.00 0 1973 8 0 0
t$perf-norm:sp_pay_from_customer 7392 7392 0 0.00 0 3938 8 0 0
t$perf-norm:sp_pay_to_supplier 6104 6104 0 0.00 0 4613 11 0 0
t$perf-norm:sp_reserve_write_off 10382 10382 0 0.00 0 3611 10 0 0
t$perf-norm:sp_supplier_invoice 5654 5654 0 0.00 0 8439 19 0 0
t$perf-norm:sp_supplier_order 5640 5640 0 0.00 0 7219 20 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 452 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 171 171 0 0.00 0 3389 29 0 0
t$perf-norm:srv_make_invnt_saldo 584 584 0 0.00 0 765 21 0 0
t$perf-norm:srv_make_money_saldo 854 854 0 0.00 0 2845 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 2 1 0 0
v_add_invoice_to_stock 10690 10536 154 1.44 0 10695 15 0 154
v_all_customers 38426 38426 0 0.00 0 18 1 0 0
v_all_suppliers 31650 31650 0 0.00 0 33 1 0 0
v_all_wares 42572 42572 0 0.00 0 41 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 276 6 0 0
v_cancel_client_order 3642 3642 0 0.00 0 1659 3 0 0
v_cancel_customer_prepayment 1346 1346 0 0.00 0 1923 4 0 0
v_cancel_customer_reserve 1364 1364 0 0.00 0 502 3 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 1120 4 0 0
v_cancel_supplier_invoice 862 850 12 1.39 0 765 16 0 12
v_cancel_supplier_order 860 860 0 0.00 0 372 4 0 0
v_cancel_write_off 1996 1996 0 0.00 0 961 12 0 0
v_max_id_clo_ord 5637 5637 0 0.00 0 1724 2 0 0
v_max_id_clo_res 1057 1057 0 0.00 0 1424 8 0 0
v_max_id_ord_sup 5646 5646 0 0.00 0 5493 5 0 0
v_max_non_paid_invoice 1562 1562 0 0.00 0 1277 4 0 0
v_max_non_paid_realizn 4029 4029 0 0.00 0 787 3 0 0
v_min_id_clo_ord 5637 5637 0 0.00 0 4716 8 0 0
v_min_id_clo_res 1057 1057 0 0.00 0 3669 13 0 0
v_min_id_ord_sup 5646 5646 0 0.00 0 3240 8 0 0
v_min_non_paid_invoice 6104 6104 0 0.00 0 16977 23 0 0
v_min_non_paid_realizn 7392 7392 0 0.00 0 6535 21 0 0
v_our_firm 10872 10872 0 0.00 0 21 1 0 0
v_reserve_write_off 20762 20762 0 0.00 0 2356 4 0 0
x_lock_depdocs_on_canc_invoice 11951 11951 0 0.00 0 14925 112 0 0
x_lock_depdocs_on_canc_sup_ord 430 430 0 0.00 0 30819 391 0 0
x_make_qstorno_1000_1200 5640 5640 0 0.00 2 25166 1190 0 0
x_make_qstorno_1200_2000 5654 5654 0 0.00 3 71768 3191 0 0
x_make_qstorno_2100_3300 477371 477371 0 0.00 0 45235 159 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:22 11632 8192000000 10253915920 10568589312 920709920 10.103 71 55 110 0 940913152 2458288 17744944
19:57:41 34617 8192000000 10358832464 10679681024 1399721280 14.593 100 86 172 0 1432938512 4899888 28317344
19:58:24 28657 8192000000 10396995728 10726789120 1448578272 15.025 100 86 172 0 1484168240 6949248 28640720
19:59:01 25546 8192000000 10407960864 10741112832 1469682768 15.211 100 91 182 0 1507480608 7864032 29933808
19:59:38 7811 8192000000 10436191936 10768760832 1494142256 15.425 100 90 180 0 1531180544 8120224 28918064
20:00:00 22556 8192000000 10455931344 10790481920 1505694592 15.526 100 90 180 0 1543903904 8993856 29215456
20:00:36 24471 8192000000 10467190560 10807455744 1518753792 15.639 100 90 180 0 1557650912 9556464 29340656
20:01:12 8472 8192000000 10484245920 10824433664 1534647184 15.777 100 84 167 0 1570832832 9603408 26582240
20:01:32 13215 8192000000 10497063968 10846724096 1558432560 15.983 100 84 168 0 1594586368 9912960 26240848
20:01:55 20118 8192000000 10530322176 10883350528 1587338784 16.231 100 82 164 0 1622920656 10040704 25541168
20:02:24 12857 8192000000 10550123984 10911219712 1611268928 16.436 100 74 148 1 1644178992 10497552 22412512
20:02:46 13236 8192000000 10567277168 10934059008 1638739280 16.669 100 75 148 1 1671951568 10173328 23038960
20:03:08 11133 8192000000 10597592096 10962370560 1660676112 16.855 100 73 146 0 1692494656 10478720 21339824
20:03:27 14528 8192000000 10617821968 10988560384 1673511552 16.963 100 71 142 0 1706036656 10949776 21575328
20:03:49 10522 8192000000 10622335936 11000156160 1693995120 17.135 100 68 136 2 1725456672 10949552 20512000
20:04:10 12041 8192000000 10655624032 11031506944 1716217856 17.321 100 67 134 2 1746819568 11297696 19304016
20:04:29 5828 8192000000 10673222208 11053727744 1740279104 17.521 100 78 156 1 1775105264 12438624 22387536
20:04:43 6425 8192000000 10686687536 11065102336 1749366208 17.596 100 81 163 1 1785293456 12414080 23513168
20:04:58 5302 8192000000 10687357888 11073437696 1758050848 17.668 100 74 146 1 1791842064 12557872 21233344
20:05:12 5266 8192000000 10702715040 11082543104 1772692400 17.789 100 74 147 2 1806153984 12722896 20738688
20:05:24 5960 8192000000 10715710944 11100758016 1779463840 17.845 100 71 142 0 1812143456 12624336 20055280
20:05:36 2945 8192000000 10721584624 11106152448 1789724912 17.930 100 82 163 1 1825677936 12246496 23706528
20:05:47 13574 8192000000 10730772048 11119448064 1791776224 17.946 100 71 142 1 1824369360 12929424 19663712
20:06:07 2963 8192000000 10749643488 11136819200 1814713744 18.134 100 88 177 1 1852584816 12984912 24886160
20:06:18 4986 8192000000 10760314736 11147411456 1817273376 18.155 100 81 162 2 1853334384 13730512 22330496
20:06:30 3623 8192000000 10769910096 11158036480 1828095712 18.244 100 84 168 2 1865525024 13146320 24282992
20:06:40 2440 8192000000 10766344176 11164868608 1835522912 18.304 100 81 162 1 1871629616 13331984 22774720
20:06:50 2841 8192000000 10776510736 11163394048 1840002464 18.341 100 83 168 3 1875813376 12121024 23689888
20:06:59 3873 8192000000 10780184624 11170893824 1842239008 18.359 100 81 161 1 1876829712 12273472 22317232
20:07:09 3008 8192000000 10784816432 11175727104 1853271344 18.449 100 89 178 0 1890701328 11856640 25573344
20:07:18 2836 8192000000 10799137040 11186216960 1855928496 18.470 100 94 188 0 1895227072 12070240 27228336
20:07:28 2259 8192000000 10801145008 11194302464 1862510608 18.524 100 86 170 1 1899335920 12449552 24375760
20:07:37 2113 8192000000 10806430032 11195588608 1863483552 18.532 100 91 182 2 1901858496 13133152 25241792
20:07:45 2288 8192000000 10811385456 11196973056 1862449088 18.523 100 92 184 1 1902858816 14543248 25866480
20:07:54 4258 8192000000 10803876576 11194052608 1867906016 18.567 100 96 190 0 1908700128 14048592 26745520
20:08:04 4306 8192000000 10800807424 11194978304 1861982912 18.519 100 83 163 0 1898808608 12851456 23974240
20:08:16 1807 8192000000 10812560016 11203981312 1867015664 18.560 100 91 184 2 1906372448 13446224 25910560
20:08:24 3381 8192000000 10812542816 11199549440 1865523824 18.548 100 79 158 0 1900863760 12998928 22341008
20:08:40 2204 8192000000 10814660592 11206098944 1871217056 18.594 100 95 189 3 1911163248 13165088 26781104
20:08:49 1704 8192000000 10813784096 11209138176 1870152560 18.586 100 85 170 0 1908682640 14518992 24011088
20:08:58 2254 8192000000 10797655440 11202252800 1871267088 18.595 100 74 147 1 1903582176 11732992 20582096
20:09:07 11751 8192000000 10810475664 11209359360 1871869584 18.599 100 74 144 2 1902318768 9926096 20523088
20:09:26 16871 8192000000 10784461872 11199000576 1868819872 18.575 100 34 68 1 1886038832 6377008 10841952
20:09:49 9829 8192000000 10788713984 11208343552 1871078736 18.593 100 32 62 2 1887557376 7714768 8763872
20:10:06 6258 8192000000 10771513184 11206348800 1874603760 18.622 100 24 48 1 1888280000 6301712 7374528
20:10:21 6324 8192000000 10777649392 11210932224 1877609648 18.646 100 26 52 1 1892029040 6956448 7462944
20:10:38 5533 8192000000 10802399744 11220615168 1882536784 18.686 100 34 67 1 1898515888 5502960 10476144
20:10:51 4282 8192000000 10799548608 11221602304 1886282960 18.716 100 29 57 2 1900696608 5707376 8706272
20:11:03 5499 8192000000 10795831520 11221565440 1884478416 18.701 100 28 56 4 1899329744 6294336 8556992
20:11:15 8117 8192000000 10794974368 11224494080 1886471280 18.717 100 28 56 1 1900301232 5500688 8329264
20:11:29 7599 8192000000 10806512784 11235389440 1891087744 18.755 100 24 48 0 1908631968 11135824 6408400
20:11:46 10827 8192000000 10800668768 11232034816 1896636480 18.799 100 15 30 0 1906710832 5588496 4485856
20:12:03 4950 8192000000 10809042832 11241934848 1897158896 18.803 100 22 44 1 1914172672 11126352 5887424
20:12:15 8290 8192000000 10812399232 11243487232 1901005008 18.834 100 23 46 1 1913434912 5892128 6537776
20:12:31 4212 8192000000 10804016032 11241697280 1900176160 18.828 100 30 58 3 1914858688 6604208 8078320
20:12:43 8748 8192000000 10805286848 11241902080 1899983808 18.826 100 22 44 0 1912618688 6621760 6013120
20:13:00 15069 8192000000 10819556288 11245154304 1902254320 18.844 100 27 54 2 1915339360 5992352 7092688
20:13:21 65556 8192000000 10825113696 11255623680 1902504608 18.846 100 28 55 1 1916488848 5961808 8022432
20:14:36 6691 8192000000 10831174192 11264196608 1905528896 18.871 100 21 41 1 1921783680 10763040 5491744
20:14:49 4617 8192000000 10829646576 11263160320 1908750224 18.897 100 22 44 2 1921313568 5802608 6760736
20:15:00 5477 8192000000 10833088688 11270455296 1911515408 18.919 100 37 74 2 1934556560 13046992 9994160
20:15:14 6434 8192000000 10832176672 11263209472 1908682304 18.896 100 21 42 0 1921261008 6725088 5853616
20:15:30 4283 8192000000 10835149056 11265925120 1911661968 18.920 100 38 76 2 1929366624 7298384 10406272
20:15:43 5149 8192000000 10854033584 11276787712 1913182944 18.932 100 35 72 1 1928714656 5538336 9993376
20:15:58 4926 8192000000 10803533072 11237326848 1889250368 18.740 99 35 72 3 1905601904 4996912 11354624
20:16:13 10783 8192000000 10816440336 11250380800 1885752544 18.712 99 22 44 2 1898697488 5264992 7679952
20:16:35 6709 8192000000 10807591216 11242934272 1889022688 18.738 100 18 36 1 1900504976 5977856 5504432
20:16:52 10983 8192000000 10786452272 11216019456 1817101168 18.154 96 23 44 2 1829731584 5539184 7091232
20:17:11 9614 8192000000 10790604768 11225841664 1859369200 18.498 99 18 36 1 1870320032 5573888 5376944
20:17:26 8791 8192000000 10776751648 11213520896 1854690192 18.460 99 19 38 0 1865290400 5339328 5260880
20:17:41 10418 8192000000 10770133456 11201064960 1829893664 18.258 98 19 38 0 1840830944 5509312 5427968
20:17:58 16293 8192000000 10718104624 11134517248 1652199600 16.783 89 18 35 1 1662493632 5421456 4872576
20:18:21 63052 8192000000 10680529584 11062689792 1638805120 16.670 90 52 105 2 1659039872 4728992 15505760
20:19:30 8775 8192000000 10704069920 11127549952 1764743856 17.724 98 19 38 2 1775530080 5997856 4788368
20:19:47 10184 8192000000 10658691904 11061055488 1653044016 16.790 93 22 42 1 1665581280 5471008 7066256
20:20:04 6348 8192000000 10679405696 11084357632 1708804736 17.259 97 26 53 0 1722460432 5433632 8222064
20:20:18 5656 8192000000 10693546624 11107840000 1763475504 17.713 99 32 64 1 1783939392 11917552 8546336
20:20:30 6971 8192000000 10715068928 11129434112 1785653232 17.896 99 38 75 2 1803730304 6972336 11104736
20:20:47 9020 8192000000 10710649120 11121360896 1751608992 17.615 97 30 59 4 1766169120 5191744 9368384
20:21:03 8015 8192000000 10738334032 11152400384 1807913440 18.079 100 28 56 3 1821508768 5574688 8020640
20:21:18 6021 8192000000 10682107904 11095224320 1707288848 17.246 94 26 52 2 1721042720 6501920 7251952
20:21:33 11435 8192000000 10724961680 11136589824 1794201616 17.966 100 22 44 1 1806110752 5588608 6320528
20:21:50 12951 8192000000 10712304112 11134066688 1759008848 17.676 97 21 42 0 1770052576 5487104 5556624
20:22:11 16159 8192000000 10742520160 11156779008 1806435232 18.067 99 38 76 1 1824198112 5675232 12087648
20:22:35 14089 8192000000 10753982464 11172204544 1829805776 18.258 100 21 40 0 1841525696 5395920 6324000
20:22:58 61648 8192000000 10782795520 11192127488 1849504944 18.418 100 45 91 0 1868250400 4922352 13823104
20:24:05 12439 8192000000 10773360336 11199217664 1852602640 18.443 100 22 43 1 1865359968 6244064 6513264
20:24:27 7538 8192000000 10770216160 11204911104 1860731664 18.509 100 31 63 2 1875933456 5503200 9698592
20:24:43 6690 8192000000 10798761872 11213377536 1869235536 18.578 100 33 66 1 1884460592 6379136 8845920
20:24:58 6933 8192000000 10785132304 11212951552 1871373680 18.595 100 31 61 3 1886748816 5815328 9559808
20:25:14 9501 8192000000 10787669872 11217154048 1872270224 18.603 100 27 54 3 1890599744 10246720 8082800
20:25:32 9380 8192000000 10793548816 11224444928 1875007728 18.625 100 25 50 1 1888107280 5634224 7465328
20:25:51 9893 8192000000 10801704112 11229720576 1877984928 18.649 100 15 27 2 1888207312 4916864 5305520
20:26:07 12881 8192000000 10793702992 11229667328 1882903280 18.689 100 19 38 0 1893957488 5467504 5586704
20:26:28 11588 8192000000 10795861536 11235479552 1890136432 18.747 100 15 30 0 1900961632 5702560 5122640
20:26:46 12034 8192000000 10804969072 11239137280 1892983632 18.770 100 21 41 2 1904616176 5776944 5855600
20:27:05 43235 8192000000 10823146624 11255386112 1903976720 18.858 100 14 28 1 1912309904 4734192 3598992
20:28:02 16126 8192000000 10850607408 11276234752 1924206656 19.021 100 43 85 1 1948582656 12372656 12003344
20:28:26 6828 8192000000 10872230528 11288096768 1935401520 19.110 100 53 103 1 1959570976 9281952 14887504
20:28:41 20586 8192000000 10872408336 11297251328 1939670640 19.144 100 50 100 1 1964949328 11190592 14088096
20:29:09 81415 8192000000 10861797056 11307376640 1947661808 19.208 100 51 102 0 1975262304 12673072 14927424
20:30:42 31422 8192000000 10882015424 11319705600 1951104288 19.235 100 37 74 0 1974373712 12636496 10632928
20:31:22 13003 8192000000 10895683024 11321479168 1955281296 19.269 100 45 90 1 1983891648 15278848 13331504
20:31:43 16310 8192000000 10893710672 11327860736 1959119856 19.299 100 51 102 1 1989012320 15084624 14807840
20:32:21 6693 8192000000 10911612512 11338846208 1967801216 19.368 100 57 112 3 1998485520 14376816 16307488
20:32:38 6680 8192000000 10911755904 11344154624 1973267488 19.411 100 56 112 1 2005113744 15576368 16269888
20:32:51 6912 8192000000 10931440400 11347492864 1978649616 19.454 100 63 127 1 2011251872 15028416 17573840
20:33:05 11563 8192000000 10934030176 11361226752 1984572832 19.501 100 67 132 1 2021384320 17746304 19065184
20:33:24 8743 8192000000 10928403920 11361640448 1987537392 19.524 100 67 132 0 2023665520 17259712 18868416
20:33:57 10956 8192000000 10925746768 11357806592 1952005200 19.242 98 56 112 3 1985912496 17809856 16097440
20:34:17 13674 8192000000 10936521136 11368116224 1987952976 19.528 100 56 112 0 2023838368 19791648 16093744
20:34:38 8189 8192000000 10935924848 11369975808 1978303760 19.451 99 56 110 1 2014064576 19623728 16137088
20:34:56 4130 8192000000 10941841120 11377651712 1997745824 19.605 100 64 128 1 2036201392 18772000 19683568
20:35:07 6199 8192000000 10944045904 11371601920 1992846960 19.566 100 61 122 0 2029325824 18614080 17864784
20:35:22 27961 8192000000 10947660624 11386642432 2003269888 19.649 100 51 102 0 2038718528 20639536 14809104
20:36:01 5224 8192000000 10953941808 11393871872 2009306176 19.696 100 55 110 1 2048128448 22732384 16089888
20:36:18 7040 8192000000 10959068512 11397038080 2012284928 19.719 100 51 102 4 2048373216 21358928 14729360
20:36:42 16936 8192000000 10964679760 11395977216 2006331872 19.673 100 49 97 1 2045462080 24831776 14298432
20:37:10 7523 8192000000 10961378656 11404259328 2010423472 19.705 100 51 101 0 2055791808 30588784 14779552
20:37:28 9226 8192000000 10976893328 11409842176 2013917920 19.732 100 54 107 1 2056617472 27021104 15678448
20:37:45 7958 8192000000 10979607296 11413524480 2020780496 19.786 100 67 134 1 2067784496 27557120 19446880
20:38:05 4731 8192000000 10987159472 11414745088 2022836976 19.802 100 63 125 1 2069397984 28163088 18397920
20:38:17 3677 8192000000 10997670592 11416686592 2025208304 19.821 100 77 155 3 2077389840 29024128 23157408
20:38:29 7025 8192000000 10969222480 11401428992 2004282224 19.656 99 65 129 0 2054603824 30784720 19536880
20:38:51 16922 8192000000 10949061792 11387473920 1964168464 19.339 97 52 104 1 2007632048 27843248 15620336
20:39:16 3758 8192000000 10962927536 11401244672 2008089888 19.686 100 47 92 1 2047239936 25020032 14130016
20:39:29 4209 8192000000 10971799104 11407175680 2014790784 19.739 100 61 121 1 2059466928 26179600 18496544
20:39:41 1407 8192000000 10975374816 11403223040 2011254848 19.711 100 64 126 3 2058410288 27749776 19405664
20:39:50 4617 8192000000 10967589008 11394527232 2003606960 19.651 100 68 134 2 2053422656 29492880 20322816
20:40:04 3765 8192000000 10979031088 11406073856 1996457632 19.595 99 76 152 1 2047930544 28497456 22975456
20:40:14 3418 8192000000 10975523504 11401756672 2009389536 19.697 100 73 146 3 2060594640 28487520 22717584
20:40:26 6834 8192000000 10966083392 11394494464 2000153856 19.624 100 76 148 3 2051852640 29452368 22246416
20:40:41 7098 8192000000 10954443280 11378757632 1972667872 19.407 99 75 149 1 2027467472 32155616 22643984
20:40:56 2681 8192000000 10969716768 11385257984 1990264624 19.546 100 85 169 1 2050455152 34395920 25794608
20:41:06 2122 8192000000 10917009776 11332820992 1922009552 19.003 97 74 145 2 1978347888 34188064 22150272
20:41:16 3933 8192000000 10946422608 11363622912 1966823472 19.360 100 69 137 2 2022965120 34758384 21383264
20:41:30 2009 8192000000 10934732432 11349073920 1962918224 19.329 99 85 170 2 2023974160 35256096 25799840
20:41:39 4223 8192000000 10949392048 11365445632 1966592752 19.358 99 74 148 1 2026394016 38017104 21784160
20:41:51 2407 8192000000 10947991072 11365011456 1962430048 19.325 99 77 153 1 2022290640 36601584 23259008
20:42:00 3886 8192000000 10947208896 11364249600 1952177440 19.244 99 73 145 0 2011683600 37059648 22446512
20:42:12 4966 8192000000 10944895104 11366141952 1967156512 19.363 100 76 152 0 2030222288 39125888 23939888
20:42:27 2115 8192000000 10960717280 11372756992 1976872784 19.440 100 79 158 1 2037460608 36691248 23896576
20:42:36 4253 8192000000 10956199328 11370520576 1974634192 19.422 100 71 140 1 2034414288 37967184 21812912
20:42:48 2985 8192000000 10933830720 11346886656 1951108848 19.235 99 75 151 0 2014700096 39122000 24469248
20:43:01 4950 8192000000 10940218064 11344723968 1932496048 19.087 98 86 172 2 2000887328 41615568 26775712
20:43:14 3205 8192000000 10941624176 11355803648 1959154816 19.299 100 80 160 1 2028138512 43038144 25945552
20:43:24 5679 8192000000 10939871152 11351121920 1956398032 19.277 100 94 186 0 2028227424 43503664 28325728
20:43:38 3811 8192000000 10936742208 11348193280 1942794704 19.169 99 79 158 1 2011751344 44159888 24796752
20:43:49 5171 8192000000 10936843520 11355009024 1954574288 19.263 100 76 152 2 2022993568 45045344 23373936
20:44:03 1976 8192000000 10952319600 11365937152 1962219696 19.324 100 75 145 0 2032060512 46624912 23215904
20:44:16 2674 8192000000 10959952336 11380748288 1971137248 19.394 100 66 132 1 2038158272 46598016 20423008
20:44:28 6668 8192000000 10972675040 11389829120 1982705968 19.486 100 83 167 0 2055826800 47244736 25876096
20:44:44 1729 8192000000 10971464176 11391959040 1973133040 19.410 99 88 173 4 2048479888 47381712 27965136
20:44:54 3993 8192000000 10958722112 11377045504 1961324384 19.317 99 71 142 1 2029033616 46330032 21379200
20:45:06 2867 8192000000 10970319104 11383062528 1980092560 19.465 100 76 148 0 2043947600 41394592 22460448
20:45:16 3460 8192000000 10972850656 11382108160 1977180032 19.442 100 89 178 1 2047466384 43051264 27235088
20:45:26 1454 8192000000 10940317616 11351343104 1953043776 19.251 100 89 175 2 2023346112 43433888 26868448
20:45:36 2157 8192000000 10947225968 11358126080 1957130192 19.283 100 87 174 0 2029808032 45205232 27472608
20:45:46 2822 8192000000 10955298736 11367714816 1962830880 19.329 100 82 164 1 2034563264 46269024 25463360
20:45:57 2075 8192000000 10950750592 11363409920 1958411600 19.293 100 81 161 0 2029608144 45391616 25804928
20:46:10 2523 8192000000 10941177680 11346776064 1949735712 19.224 100 91 180 2 2026205728 47090784 29379232
20:46:20 1951 8192000000 10940710592 11357982720 1955097600 19.267 100 80 160 1 2031685680 51429824 25158256
20:46:30 1798 8192000000 10961324960 11370385408 1967247792 19.364 100 90 180 2 2042749168 46419808 29081568
20:46:39 2570 8192000000 10945713760 11358019584 1940073680 19.147 99 79 158 1 2013020336 47605424 25341232
20:46:49 2331 8192000000 10960100736 11366391808 1965160832 19.347 100 91 180 2 2042002592 47695488 29146272
20:46:59 2147 8192000000 10945373696 11348992000 1945064736 19.187 99 89 175 2 2017754480 45723472 26966272
20:47:09 5386 8192000000 10969956496 11377733632 1970820800 19.392 100 79 158 0 2042446368 47410528 24215040
20:47:23 3188 8192000000 10968151168 11374145536 1966254304 19.356 100 80 158 0 2040683328 49660400 24768624
20:47:41 8534 8192000000 10929456592 11369496576 1956280800 19.276 100 41 82 0 2017808432 47569008 13958624
20:48:01 10073 8192000000 10937708688 11373654016 1965005120 19.346 100 40 80 1 2023094864 44951904 13137840
20:48:23 6184 8192000000 10952089264 11384692736 1972877360 19.408 100 54 108 2 2037872560 47175056 17820144
20:48:36 8543 8192000000 10947042560 11386302464 1971749920 19.399 100 40 78 4 2032815776 48125376 12940480
20:49:06 4156 8192000000 10949078176 11374297088 1944802944 19.185 98 56 112 1 2008787088 45724304 18259840
20:49:17 8477 8192000000 10939170384 11380154368 1968695664 19.375 100 47 94 0 2032586288 48054496 15836128
20:49:32 22929 8192000000 10935068080 11377922048 1956966544 19.282 100 29 58 0 2014819200 47208032 10644624
20:50:04 13578 8192000000 10926434976 11368951808 1947808256 19.209 100 41 80 2 2010503984 47975280 14720448
20:50:26 6965 8192000000 10950289216 11382910976 1960641120 19.311 100 55 110 0 2029370016 50812944 17915952
20:50:41 16086 8192000000 10943410944 11390623744 1964143840 19.339 100 32 64 1 2026013024 50451520 11417664
20:51:09 15034 8192000000 10945175744 11397271552 1967759360 19.368 100 37 74 1 2032858176 52113024 12985792
20:51:35 15226 8192000000 10917968704 11368726528 1963051392 19.330 100 22 43 2 2001909216 31292384 7565440
20:51:58 8972 8192000000 10926149040 11364581376 1958691232 19.296 100 38 76 1 2003379488 32929264 11758992
20:52:49 14899 8192000000 10926339040 11366027264 1944826960 19.185 99 45 88 1 1992828288 33720288 14281040
20:53:16 9106 8192000000 10900720384 11342360576 1929483264 19.063 99 27 54 0 1974009600 35469888 9056448
20:53:43 14461 8192000000 10872730512 11328835584 1907520816 18.887 99 20 41 0 1953402816 38771408 7110592
20:54:41 37548 8192000000 10884002288 11339780096 1905847328 18.873 99 15 30 1 1946666256 36108160 4710768
20:56:36 41300 8192000000 10854857360 11316244480 1920514864 18.991 100 33 66 1 1948082832 17363248 10204720
20:57:29 81240 8192000000 10879303568 11352203264 1922556832 19.007 99 8 16 0 1936839664 12391232 1891600
20:58:56 82367 8192000000 10906946656 11340034048 1922316064 19.005 98 27 53 0 1941497712 11912704 7268944
21:00:26 53750 8192000000 10873853168 11324145664 1912063872 18.923 98 25 50 0 1928018512 9130112 6824528
21:01:30 62659 8192000000 10895269744 11356704768 1948190240 19.212 100 5 10 1 1965807872 16675168 942464
21:02:47 136953 8192000000 10909182304 11360653312 1912036960 18.923 97 1 2 0 1927302688 15203600 62128
21:05:13 71914 8192000000 10926711120 11365216256 1974460368 19.421 100 43 79 2 1993784016 8345712 10977936
21:06:35 37656 8192000000 10912575088 11377139712 1982521968 19.485 100 40 80 1 2003400048 9845600 11032480
21:07:26 70223 8192000000 10922552384 11369553920 1957957712 19.290 99 32 64 0 1976804208 10083648 8762848
21:08:46 71617 8192000000 10898517280 11367575552 1958047712 19.291 99 20 40 1 1973831152 9872944 5910496
21:10:08 2232 8192000000 10904678976 11372851200 1979613792 19.462 100 15 31 0 1993756288 9924480 4218016
21:10:17 9318 8192000000 10905776080 11372261376 1978341520 19.452 100 15 31 0 1993037264 9690880 5004864
21:10:38 5766 8192000000 10913771744 11376799744 1983770896 19.495 100 25 50 2 1999994992 8854944 7369152
21:10:56 13477 8192000000 10913948496 11381866496 1993795968 19.574 100 35 66 1 2010767776 7475856 9495952
21:11:21 22051 8192000000 10907908352 11377274880 1971031776 19.394 99 11 22 0 1980814464 6350000 3432688
21:11:58 15656 8192000000 10926727504 11376033792 1956198112 19.276 98 54 105 0 1979220288 7953296 15068880
21:12:22 51002 8192000000 10925112816 11390046208 1988734672 19.534 100 34 69 0 2009239200 10383808 10120720
21:13:23 24254 8192000000 10910494816 11388547072 1971853328 19.400 99 18 36 1 1987733040 9563376 6316336
21:13:58 28020 8192000000 10894445648 11372548096 1941505216 19.159 98 2 4 0 1951880000 9597104 777680
21:14:32 21678 8192000000 10899616320 11377967104 1977271440 19.443 100 14 28 1 1992979920 11997600 3710880
21:15:01 58039 8192000000 10906024576 11385454592 1985894576 19.511 100 15 31 1 2001919360 11693120 4331664
21:16:06 19585 8192000000 10912968384 11388682240 1989616800 19.541 100 8 16 1 2002756288 10990064 2149424
21:16:32 15493 8192000000 10910287552 11393458176 1991779296 19.558 100 12 23 0 2006290416 11234208 3276912
21:16:53 20403 8192000000 10906351536 11382210560 1968478096 19.373 99 8 16 0 1983140016 12299952 2361968
21:17:20 32225 8192000000 10891553248 11381792768 1962547344 19.326 99 10 20 1 1976326704 11228784 2550576
21:17:59 14710 8192000000 10876818208 11362668544 1957854032 19.289 99 3 6 0 1967371296 8945856 571408
21:18:21 59880 8192000000 10917754688 11395833856 1986606976 19.517 100 24 48 1 1999857184 6504896 6745312
21:19:31 43576 8192000000 10915650784 11394658304 1990738848 19.550 100 15 30 1 2009704864 14413584 4552432
21:20:21 37579 8192000000 10880379584 11361497088 1902232864 18.844 96 15 30 0 1920453680 13943072 4277744
21:21:05 45164 8192000000 10903885984 11377844224 1964477696 19.342 99 23 45 0 1983505984 12877088 6151200
21:22:20 66350 8192000000 10887825856 11386621952 1938972448 19.139 98 9 18 1 1955282912 13966064 2344400
21:23:33 53070 8192000000 10886180288 11360178176 1918535600 18.975 97 13 25 3 1930731984 8452272 3744112
21:24:33 44385 8192000000 10856964416 11329675264 1829982464 18.259 93 14 28 0 1846745280 12183632 4579184
21:25:35 38178 8192000000 10864632272 11331678208 1917512032 18.967 98 21 40 2 1933873648 10479616 5882000
21:26:19 65725 8192000000 10880500272 11354320896 1901580128 18.839 97 23 46 0 1924363088 15874064 6908896
21:27:37 40010 8192000000 10889992688 11354656768 1904773568 18.865 97 35 69 0 1929812928 14442800 10596560
21:28:23 65990 8192000000 10848435200 11315576832 1830406752 18.263 94 16 32 1 1843581328 8886976 4287600
21:29:43 88478 8192000000 10892053872 11374080000 1862047840 18.520 95 9 18 1 1884042624 19460928 2533856
21:31:18 54405 8192000000 10885414016 11366514688 1918130064 18.972 98 12 24 0 1938761712 16880976 3750672
21:32:45 39719 8192000000 10884005520 11338723328 1885529616 18.710 96 34 68 1 1907111760 12004544 9577600
21:33:32 56430 8192000000 10877475568 11340509184 1888668160 18.735 97 33 66 0 1909804448 11685456 9450832
21:35:06 94705 8192000000 10877076624 11356913664 1892554736 18.766 97 24 48 0 1912691328 13589424 6547168
21:36:58 120032 8192000000 10873533232 11316953088 1882437088 18.685 97 38 76 2 1904034720 11119328 10478304
21:39:08 45186 8192000000 10856967504 11312013312 1895980704 18.794 98 28 56 1 1911540176 8088432 7471040
21:40:02 55887 8192000000 10868859008 11329462272 1905117632 18.867 98 37 74 1 1930859856 14895792 10846432
21:41:07 34392 8192000000 10856105680 11342135296 1915726000 18.953 99 10 20 1 1931863952 13124064 3013888
21:41:49 51791 8192000000 10869119760 11343880192 1930207568 19.069 99 24 46 1 1946441792 10067664 6166560
21:43:03 67503 8192000000 10856165696 11343474688 1912255056 18.925 98 5 10 1 1923893344 10274880 1363408
21:44:17 75142 8192000000 10863583824 11348996096 1951208912 19.236 100 12 24 2 1963795600 9078992 3507696
21:45:59 74249 8192000000 10891567424 11351244800 1927204000 19.045 98 20 39 0 1939365376 6745136 5416240
21:47:44 53208 8192000000 10878551840 11359543296 1932444528 19.086 98 11 22 1 1944799264 9309392 3045344
21:48:44 80729 8192000000 10903561824 11380211712 1961633392 19.319 100 16 32 1 1979564592 12820000 5111200
21:50:15 57715 8192000000 10885466592 11371216896 1951714512 19.240 99 17 34 1 1965539840 9137216 4688112
21:51:19 62785 8192000000 10898712896 11369005056 1913356608 18.934 97 18 36 1 1927474304 9358208 4759488
21:52:36 56691 8192000000 10859634960 11334148096 1902998480 18.850 97 17 34 0 1921091536 13220240 4872816
21:53:39 49695 8192000000 10895819456 11351568384 1940945232 19.154 99 36 73 3 1960106432 8671072 10490128
21:54:36 33196 8192000000 10893076880 11360567296 1959097504 19.299 100 34 68 1 1977902400 9137792 9667104
21:55:30 100484 8192000000 10907950624 11384336384 1969751872 19.383 100 16 32 0 1990242400 15563104 4927424
21:57:17 53369 8192000000 10914616880 11373195264 1945858416 19.193 98 23 46 0 1961014112 8975552 6180144
21:58:18 70507 8192000000 10912240992 11397472256 1943390720 19.174 98 23 46 0 1971433488 21389344 6653424
21:59:35 116530 8192000000 10913287856 11411636224 1942555936 19.167 98 7 14 0 1967962880 23860800 1546144
22:01:54 111579 8192000000 10886497536 11352965120 1936316704 19.117 98 17 34 1 1950690496 9433744 4940048
22:03:52 68149 8192000000 10896617632 11383615488 1977656720 19.446 100 18 34 1 1989818176 7512736 4648720
22:05:10 64397 8192000000 10890331856 11372486656 1887676384 18.727 95 12 24 0 1898570400 7675808 3218208
22:06:20 58612 8192000000 10902703440 11362078720 1915753536 18.953 97 20 40 1 1935665728 13390976 6521216
22:07:26 67027 8192000000 10895347232 11361239040 1938843600 19.138 98 26 52 1 1959888816 12949776 8095440
22:08:40 21915 8192000000 10890850416 11357835264 1926916864 19.042 98 18 36 0 1942621072 10606768 5097440
22:09:13 46083 8192000000 10914312576 11392827392 1981413424 19.476 100 39 78 0 2005988352 12993584 11581344
22:10:47 79803 8192000000 10895411872 11372163072 1942545584 19.167 98 20 40 1 1961266592 12934512 5786496
22:12:15 74826 8192000000 10893512032 11360133120 1923171680 19.012 98 11 22 0 1938701264 12291344 3238240
22:13:36 56661 8192000000 10899919248 11371368448 1914893152 18.946 97 20 40 0 1936914480 16006192 6015136
22:14:41 89070 8192000000 10870821888 11359404032 1877032624 18.641 96 18 36 1 1902259280 19434912 5791744
22:16:21 94079 8192000000 10863423488 11333881856 1791000032 17.940 92 6 12 0 1801223568 8825552 1397984
22:18:01 60381 8192000000 10851097424 11303297024 1846279824 18.392 95 17 34 0 1859904768 8524688 5100256
22:19:08 24415 8192000000 10886181952 11328679936 1929767808 19.065 100 57 115 1 1956769168 10492496 16508864
22:19:44 58207 8192000000 10848790096 11309522944 1914510368 18.943 99 40 80 0 1938570896 12326752 11733776
22:21:04 110117 8192000000 10828294816 11294183424 1841040592 18.349 95 22 44 1 1861138896 13707648 6390656
22:23:08 35742 8192000000 10836905408 11314417664 1906801728 18.881 100 24 48 2 1930724720 17347152 6575840
22:23:53 66480 8192000000 10848068544 11326169088 1927440144 19.046 100 17 35 1 1939903520 7862896 4600480
22:25:07 52815 8192000000 10853828656 11340120064 1937284736 19.125 100 10 20 1 1949746976 9578640 2883600
22:26:06 43494 8192000000 10850128048 11322298368 1883534720 18.694 97 15 30 0 1895683856 8339040 3810096
22:27:01 24023 8192000000 9675176528 10024992768 637656752 7.221 33 1 2 0 642944064 5225184 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 14-01-2021 22:29:35 to 14-01-2021 22:30:07.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-01-2021 22:30:08 to 14-01-2021 22:30:10.

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          248093
MON$OLDEST_ACTIVE               248094
MON$OLDEST_SNAPSHOT             248094
MON$NEXT_TRANSACTION            248094
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                       2056032
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:932: 
:933: mscs-test-161.budzdorov.ru    Thu Jan 14 22:27:30 2021
:934:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:935: 
--- end of diff output ---

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

14.01.21 22:30:11. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-01-14 22:30:13 No severe PSQL-related problems occured
14.01.21 22:30:15. End of report.