Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.02.2021 16: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 17129144 kB
MemAvailable 31199368 kB
Buffers 0 kB
Cached 14581664 kB
SwapCached 4772 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-02-11 16:27:17
DTS_END                         2021-02-11 16:27:17.8920
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57864
TRN_ID                          240026
ATT_ID                          690
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: 9209.02 24300 1105082
customer order: creation 169.47 338 20336
customer order: refuse 15.03 377 1803
order to supplier: creation 45.97 1266 5516
order to supplier: removal 3.48 93573 417
invoice (draft): creation 45.70 3483 5484
invoice (draft): removal 52.15 684 6258
invoice accept: apply 42.19 19225 5063
invoice accept: cancel 47.35 787 5682
customer reserve: creation 3857.37 193 462884
customer reserve: removal 4634.24 55 556109
realization accept: apply 83.28 172 9994
realization accept: cancel 81.18 118 9741
payment from customer: creation 60.01 113 7201
payment from customer: removal 5.81 97 697
payment to supplier: creation 49.80 133 5976
payment to supplier: removal 3.46 85 415
service: total inventory turnovers 4.78 1000 574
service: total monetary turnovers 6.87 26 824
service: aggregate perf. data 0.87 19402 104
service: refresh index statistics 0.03 344866 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-02-2021 16:28:46 to 11-02-2021 16:28:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3361
TEST_TIME 2 3190
TEST_TIME 3 3909
TEST_TIME 4 4343
TEST_TIME 5 5212
TEST_TIME 6 5340
TEST_TIME 7 5586
TEST_TIME 8 5969
TEST_TIME 9 6039
TEST_TIME 10 6190
TEST_TIME 11 6245
TEST_TIME 12 6590
TEST_TIME 13 6719
TEST_TIME 14 6966
TEST_TIME 15 7311
TEST_TIME 16 7425
TEST_TIME 17 7645
TEST_TIME 18 7755
TEST_TIME 19 7762
TEST_TIME 20 7864
TEST_TIME 21 8565
TEST_TIME 22 8748
TEST_TIME 23 8648
TEST_TIME 24 8753
TEST_TIME 25 9138
TEST_TIME 26 9244
TEST_TIME 27 9748
TEST_TIME 28 10197
TEST_TIME 29 10423
TEST_TIME 30 10675
TEST_TIME 31 10499
TEST_TIME 32 10556
TEST_TIME 33 10382
TEST_TIME 34 10159
TEST_TIME 35 9954
TEST_TIME 36 9961
TEST_TIME 37 9834
TEST_TIME 38 9763
TEST_TIME 39 9673
TEST_TIME 40 9595
TEST_TIME 41 9736
TEST_TIME 42 9696
TEST_TIME 43 9584
TEST_TIME 44 9563
TEST_TIME 45 9502
TEST_TIME 46 9503
TEST_TIME 47 9556
TEST_TIME 48 9508
TEST_TIME 49 9463
TEST_TIME 50 9537
TEST_TIME 51 9512
TEST_TIME 52 9651
TEST_TIME 53 9679
TEST_TIME 54 9678
TEST_TIME 55 9627
TEST_TIME 56 9674
TEST_TIME 57 9639
TEST_TIME 58 9717
TEST_TIME 59 9717
TEST_TIME 60 9812
TEST_TIME 61 9674
TEST_TIME 62 9600
TEST_TIME 63 9530
TEST_TIME 64 9476
TEST_TIME 65 9434
TEST_TIME 66 9413
TEST_TIME 67 9406
TEST_TIME 68 9384
TEST_TIME 69 9419
TEST_TIME 70 9398
TEST_TIME 71 9408
TEST_TIME 72 9406
TEST_TIME 73 9389
TEST_TIME 74 9440
TEST_TIME 75 9465
TEST_TIME 76 9454
TEST_TIME 77 9470
TEST_TIME 78 9467
TEST_TIME 79 9604
TEST_TIME 80 9607
TEST_TIME 81 9721
TEST_TIME 82 9684
TEST_TIME 83 9571
TEST_TIME 84 9556
TEST_TIME 85 9496
TEST_TIME 86 9535
TEST_TIME 87 9449
TEST_TIME 88 9395
TEST_TIME 89 9403
TEST_TIME 90 9326
TEST_TIME 91 9405
TEST_TIME 92 9369
TEST_TIME 93 9394
TEST_TIME 94 9381
TEST_TIME 95 9383
TEST_TIME 96 9396
TEST_TIME 97 9406
TEST_TIME 98 9410
TEST_TIME 99 9402
TEST_TIME 100 9434
TEST_TIME 101 9423
TEST_TIME 102 9471
TEST_TIME 103 9482
TEST_TIME 104 9448
TEST_TIME 105 9446
TEST_TIME 106 9499
TEST_TIME 107 9460
TEST_TIME 108 9397
TEST_TIME 109 9382
TEST_TIME 110 9332
TEST_TIME 111 9363
TEST_TIME 112 9364
TEST_TIME 113 9334
TEST_TIME 114 9286
TEST_TIME 115 9269
TEST_TIME 116 9238
TEST_TIME 117 9264
TEST_TIME 118 9275
TEST_TIME 119 9273
TEST_TIME 120 9212

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 11-02-2021 16:28:49 to 11-02-2021 16:28:53.

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 1533218 1533218 0 0.00 0 19034 7 0 0
doc_list_biud 1533218 1533218 0 0.00 0 24876 26 0 0
sp_add_invoice_to_stock 5183 5063 120 2.31 13 246863 19225 0 120
sp_cancel_adding_invoice 5682 5682 0 0.00 5 54336 788 0 0
sp_cancel_client_order 1803 1803 0 0.00 4 15662 378 0 0
sp_cancel_customer_reserve 556109 556109 0 0.00 1 22636 56 0 0
sp_cancel_pay_from_customer 697 697 0 0.00 3 11142 98 0 0
sp_cancel_pay_to_supplier 415 415 0 0.00 3 4983 86 0 0
sp_cancel_supplier_invoice 6269 6258 11 0.17 1 13103 684 0 11
sp_cancel_supplier_order 417 417 0 0.00 9 915604 93573 0 0
sp_cancel_write_off 9741 9741 0 0.00 1 19825 119 0 0
sp_client_order 20336 20336 0 0.00 4 49901 338 0 0
sp_customer_reserve 462884 462884 0 0.00 0 133919 193 0 0
sp_fill_shopping_cart 31334 31334 0 0.00 1 13444 40 0 0
sp_fill_shopping_cart_clo_res 462879 462879 0 0.00 0 28610 15 0 0
sp_get_clo_for_invoice 5058 5058 0 0.00 0 27992 319 0 0
sp_kill_cost_storno 16535 16535 0 0.00 0 7870 56 0 0
sp_kill_qstorno_ret_qs2qd 1128634 1128634 0 0.00 0 22628 30 0 0
sp_kill_qty_storno 595061 595061 0 0.00 0 24875 65 0 0
sp_lock_selected_doc 20879 20879 0 0.00 0 11133 7 0 0
sp_make_cost_storno 28228 28228 0 0.00 0 18902 63 0 0
sp_multiply_rows_for_pdistr 28228 28228 0 0.00 0 15026 29 0 0
sp_multiply_rows_for_qdistr 20336 20336 0 0.00 0 49877 160 0 0
sp_pay_from_customer 7201 7201 0 0.00 4 27320 114 0 0
sp_pay_to_supplier 5976 5976 0 0.00 5 15052 133 0 0
sp_payment_common 13177 13177 0 0.00 1 27315 30 0 0
sp_qd_handle_on_cancel_clo 1803 1803 0 0.00 0 15657 344 0 0
sp_qd_handle_on_invoice_upd_sts 10739 10739 0 0.00 0 24874 321 0 0
sp_qd_handle_on_reserve_upd_sts 9994 9994 0 0.00 0 12453 54 0 0
sp_reserve_write_off 9994 9994 0 0.00 6 15411 173 0 0
sp_supplier_invoice 5484 5484 0 0.00 5 97729 3484 0 0
sp_supplier_order 5516 5516 0 0.00 6 30328 1266 0 0
srv_aggregate_perf_data 104 104 0 0.00 2472 252818 19402 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 678 162075 32413 0 0
srv_find_qd_qs_mism 1056998 1056998 0 0.00 0 19031 6 0 0
srv_make_invnt_saldo 574 574 0 0.00 29 32492 1000 0 0
srv_make_money_saldo 824 824 0 0.00 0 964 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 224293 443879 344867 0 0
t$perf-abend:sp_add_invoice_to_stock 120 120 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5063 5063 0 0.00 0 27103 181 0 0
t$perf-norm:sp_cancel_adding_invoice 405 405 0 0.00 0 5538 87 0 0
t$perf-norm:sp_cancel_client_order 1803 1803 0 0.00 0 8836 14 0 0
t$perf-norm:sp_cancel_customer_reserve 702 702 0 0.00 0 866 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 697 697 0 0.00 0 3570 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 415 415 0 0.00 0 1414 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 2493 24 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 19375 1468 0 0
t$perf-norm:sp_cancel_write_off 987 987 0 0.00 0 2096 8 0 0
t$perf-norm:sp_client_order 20336 20336 0 0.00 0 10356 18 0 0
t$perf-norm:sp_customer_reserve 967 967 0 0.00 0 3928 12 0 0
t$perf-norm:sp_pay_from_customer 7201 7201 0 0.00 0 13539 12 0 0
t$perf-norm:sp_pay_to_supplier 5976 5976 0 0.00 0 11902 13 0 0
t$perf-norm:sp_reserve_write_off 9994 9994 0 0.00 0 7917 14 0 0
t$perf-norm:sp_supplier_invoice 5484 5484 0 0.00 0 9145 22 0 0
t$perf-norm:sp_supplier_order 5516 5516 0 0.00 0 11375 20 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 603 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 651 12 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 13367 53 0 0
t$perf-norm:srv_make_money_saldo 824 824 0 0.00 0 3853 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 10 4 0 0
v_add_invoice_to_stock 10354 10114 240 2.31 0 9081 20 0 240
v_all_customers 37178 37178 0 0.00 0 16 1 0 0
v_all_suppliers 30516 30516 0 0.00 0 85 1 0 0
v_all_wares 40672 40672 0 0.00 0 26 1 0 0
v_cancel_adding_invoice 810 810 0 0.00 0 1971 8 0 0
v_cancel_client_order 3606 3606 0 0.00 0 1987 4 0 0
v_cancel_customer_prepayment 1394 1394 0 0.00 0 1848 5 0 0
v_cancel_customer_reserve 1404 1404 0 0.00 0 503 3 0 0
v_cancel_payment_to_supplier 830 830 0 0.00 0 2986 9 0 0
v_cancel_supplier_invoice 826 804 22 2.66 0 435 17 0 22
v_cancel_supplier_order 834 834 0 0.00 0 596 4 0 0
v_cancel_write_off 1974 1974 0 0.00 0 415 13 0 0
v_max_id_clo_ord 5514 5514 0 0.00 0 745 1 0 0
v_max_id_clo_res 967 967 0 0.00 0 8757 22 0 0
v_max_id_ord_sup 5483 5483 0 0.00 0 2747 4 0 0
v_max_non_paid_invoice 1715 1715 0 0.00 0 76 2 0 0
v_max_non_paid_realizn 3835 3835 0 0.00 0 3205 6 0 0
v_min_id_clo_ord 5514 5514 0 0.00 0 933 5 0 0
v_min_id_clo_res 967 967 0 0.00 0 3904 7 0 0
v_min_id_ord_sup 5483 5483 0 0.00 0 7574 9 0 0
v_min_non_paid_invoice 5976 5976 0 0.00 0 6833 18 0 0
v_min_non_paid_realizn 7201 7201 0 0.00 0 27310 20 0 0
v_our_firm 10224 10224 0 0.00 0 246 1 0 0
v_reserve_write_off 19986 19986 0 0.00 0 3964 4 0 0
x_lock_depdocs_on_canc_invoice 11538 11538 0 0.00 0 21598 125 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 2986 303 0 0
x_make_qstorno_1000_1200 5516 5516 0 0.00 2 30321 1175 0 0
x_make_qstorno_1200_2000 5484 5484 0 0.00 3 86666 3354 0 0
x_make_qstorno_2100_3300 462884 462884 0 0.00 0 133917 176 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-02-2021 16:28:54 to 11-02-2021 16:28:58.

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
13:57:21 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:27 18102 8192000000 10221783744 10526404608 823858144 9.137 66 55 114 0 849115168 6453840 18803184
13:57:53 24043 8192000000 10321687744 10636107776 1366007824 14.291 100 89 178 0 1400772176 4857728 29906624
13:58:25 26862 8192000000 10363845520 10681147392 1414274560 14.722 100 87 174 1 1449852192 6225984 29351648
13:59:01 30645 8192000000 10405097008 10730418176 1452545728 15.060 100 90 179 1 1488741376 7100992 29094656
13:59:41 26012 8192000000 10438112576 10766970880 1489883152 15.388 100 89 178 0 1525866928 7501232 28482544
14:00:19 19267 8192000000 10455374208 10789330944 1502244720 15.496 100 88 176 0 1538541872 8064128 28233024
14:00:49 21770 8192000000 10480144416 10817191936 1532271728 15.757 100 86 173 3 1567976592 8502288 27202576
14:01:24 18705 8192000000 10494698800 10837028864 1549865040 15.909 100 89 178 1 1586964528 9369216 27730272
14:01:50 16015 8192000000 10510643600 10860478464 1566454752 16.052 100 83 166 1 1601544640 9845008 25244880
14:02:13 11574 8192000000 10537165808 10889064448 1597214976 16.316 100 80 160 1 1630938176 10154096 23569104
14:02:32 15345 8192000000 10550094144 10904150016 1612643376 16.447 100 82 164 2 1648438608 11290784 24504448
14:02:55 18975 8192000000 10576201408 10934489088 1628134896 16.579 100 80 158 2 1662517424 11613168 22769360
14:03:25 14422 8192000000 10605363456 10967281664 1658597168 16.837 100 88 174 2 1696578976 12815840 25165968
14:03:47 11520 8192000000 10622781024 10986586112 1669433952 16.928 100 84 166 0 1707248384 13227856 24586576
14:04:08 11170 8192000000 10624745584 10995748864 1686819776 17.075 100 75 150 0 1721279200 13029760 21429664
14:04:32 6965 8192000000 10648877328 11022843904 1713967632 17.302 100 74 147 3 1747505776 12424704 21113440
14:04:46 6260 8192000000 10657563296 11037048832 1726320096 17.405 100 73 146 1 1758942784 11846896 20775792
14:05:00 6174 8192000000 10668018512 11045756928 1735126816 17.478 100 82 161 1 1770317808 12358000 22832992
14:05:14 6576 8192000000 10680854160 11056922624 1745994128 17.568 100 82 164 1 1781938208 12893504 23050576
14:05:27 6173 8192000000 10682195872 11065901056 1754234768 17.637 100 73 146 1 1787659648 12799632 20625248
14:05:40 12549 8192000000 10691234944 11077943296 1762609616 17.706 100 72 144 2 1794709792 12729472 19370704
14:06:00 4577 8192000000 10712798576 11098968064 1772853280 17.791 100 73 146 4 1806112176 12373440 20885456
14:06:11 3408 8192000000 10724823744 11107885056 1789476352 17.927 100 78 156 1 1822902832 12111472 21315008
14:06:21 4236 8192000000 10736844064 11119747072 1797858960 17.996 100 83 166 1 1834267504 13708320 22700224
14:06:32 4134 8192000000 10746459280 11129266176 1800949120 18.022 100 85 170 2 1840525136 14501680 25074336
14:06:43 4007 8192000000 10743701136 11126378496 1808300240 18.082 100 86 172 2 1845731936 13824320 23607376
14:06:54 3569 8192000000 10759025088 11141910528 1812872208 18.119 100 91 180 0 1852389456 14393824 25123424
14:07:04 5013 8192000000 10760533904 11144577024 1820930560 18.185 100 87 174 1 1858965872 14104784 23930528
14:07:16 3457 8192000000 10761920784 11152625664 1823365664 18.205 100 81 162 0 1859661360 13575040 22720656
14:07:26 1974 8192000000 10772398640 11154333696 1827785760 18.241 100 87 172 2 1865300080 12839920 24674400
14:07:35 2669 8192000000 10784040112 11164979200 1834366112 18.295 100 84 168 0 1870877168 12471120 24039936
14:07:44 2925 8192000000 10772518176 11166752768 1837075792 18.317 100 82 163 1 1871362048 11877568 22408688
14:07:53 2516 8192000000 10781200096 11172040704 1844535872 18.378 100 82 164 0 1879420304 12262560 22621872
14:08:02 2867 8192000000 10793017920 11177324544 1847467472 18.402 100 86 172 2 1883933632 12626720 23839440
14:08:12 1899 8192000000 10788012560 11178377216 1849985184 18.422 100 89 178 0 1888256944 12720080 25551680
14:08:21 3388 8192000000 10796907056 11184488448 1853550080 18.451 100 96 191 0 1895043984 14529184 26964720
14:08:31 2392 8192000000 10801719552 11187441664 1853943792 18.454 100 95 190 2 1896580864 15878080 26758992
14:08:40 2372 8192000000 10801736672 11188342784 1857551984 18.483 100 92 184 1 1898060000 13974448 26533568
14:08:50 1862 8192000000 10811809904 11194576896 1860479824 18.507 100 96 192 4 1900348064 13759792 26108448
14:08:59 1446 8192000000 10807649712 11194806272 1864880016 18.543 100 90 180 1 1903119120 13171584 25067520
14:09:06 2137 8192000000 10804543744 11198066688 1866616384 18.557 100 84 167 0 1902976240 13013280 23346576
14:09:15 23491 8192000000 10782356752 11186487296 1863872720 18.535 100 65 128 1 1892975808 11701424 17401664
14:09:45 10115 8192000000 10805205584 11198144512 1868558160 18.573 100 77 156 1 1901447440 10519312 22369968
14:10:02 2358 8192000000 10816663472 11209048064 1872896400 18.608 100 94 188 1 1912901392 12846096 27158896
14:10:11 1563 8192000000 10820395600 11209801728 1876094288 18.634 100 94 188 1 1915544528 13086624 26363616
14:10:19 1460 8192000000 10808081456 11209584640 1874325344 18.619 100 73 146 0 1907150720 12024048 20801328
14:10:28 3830 8192000000 10799775968 11212435456 1877493744 18.645 100 64 128 1 1907130528 11558736 18078048
14:10:55 9621 8192000000 10790907888 11209826304 1873341376 18.611 100 36 72 3 1890776944 7021600 10413968
14:11:11 4913 8192000000 10801491040 11210350592 1878776624 18.655 100 45 89 3 1897466848 4632784 14057440
14:11:23 4888 8192000000 10792840032 11212206080 1876622032 18.638 100 35 70 1 1894089792 8118448 9349312
14:11:38 4640 8192000000 10794622240 11214422016 1879861968 18.664 100 42 85 1 1898808288 6806304 12140016
14:11:51 6100 8192000000 10788002032 11215167488 1878349232 18.652 100 36 72 2 1896916320 8464016 10103072
14:12:05 7001 8192000000 10793432608 11219034112 1881129792 18.674 100 32 64 0 1901929840 11553248 9246800
14:12:20 4849 8192000000 10792502656 11219787776 1884924752 18.705 100 34 67 0 1905224336 10683328 9616256
14:12:31 9613 8192000000 10785707568 11221032960 1885476592 18.709 100 17 34 2 1897508032 6543248 5488192
14:12:52 8589 8192000000 10802855616 11227103232 1890884560 18.753 100 31 63 0 1906037216 6742752 8409904
14:13:11 7182 8192000000 10791528592 11227582464 1893288224 18.772 100 35 70 2 1911308336 7488608 10531504
14:13:26 65381 8192000000 10816376720 11241168896 1894865952 18.785 100 31 61 0 1909261488 6176432 8219104
14:14:40 6155 8192000000 10817323824 11245813760 1899761536 18.824 100 49 98 0 1922121792 8415936 13944320
14:14:54 4841 8192000000 10819181120 11246047232 1897920880 18.810 100 32 64 0 1913196064 6181424 9093760
14:15:05 5962 8192000000 10812200256 11247493120 1901273840 18.837 100 27 54 1 1915794144 6325712 8194592
14:15:19 5317 8192000000 10827052176 11251130368 1902978432 18.850 100 30 59 2 1917459936 6756688 7724816
14:15:31 5599 8192000000 10830842240 11257864192 1908095088 18.891 100 42 83 1 1930477360 9862912 12519360
14:15:43 7818 8192000000 10811618832 11248750592 1904267408 18.861 100 20 40 1 1915352944 5221968 5863568
14:16:00 2286 8192000000 10824666608 11251343360 1907497856 18.887 100 26 53 0 1924829568 8815248 8516464
14:16:08 6154 8192000000 10826852848 11255685120 1904490416 18.862 100 30 60 2 1923914256 10300704 9123136
14:16:22 5518 8192000000 10817249120 11249360896 1903907808 18.858 100 25 50 6 1916364096 5820768 6635520
14:16:37 4234 8192000000 10825857088 11251834880 1905346576 18.869 100 32 64 0 1920709024 6169984 9192464
14:16:49 10087 8192000000 10813812400 11240525824 1867670336 18.565 98 25 51 2 1880143280 5277312 7195632
14:17:07 13509 8192000000 10815441776 11239350272 1842348048 18.360 97 21 41 1 1858552128 10519072 5685008
14:17:31 13770 8192000000 10778093328 11206828032 1794249280 17.967 95 16 33 1 1803548576 4820608 4478688
14:17:51 12643 8192000000 10782982288 11205541888 1853532704 18.451 99 26 52 1 1866149808 5394976 7222128
14:18:10 49993 8192000000 10800800672 11203891200 1828586112 18.248 97 54 110 2 1850055712 4458704 17010896
14:19:07 6484 8192000000 10789373936 11207004160 1851518416 18.434 99 38 76 2 1869077568 7070128 10489024
14:19:25 9384 8192000000 10762016528 11189129216 1789433488 17.927 96 30 60 0 1808059824 10419168 8207168
14:19:42 4669 8192000000 10759239936 11178086400 1812866320 18.119 98 30 60 1 1827150336 5459728 8824288
14:19:53 5899 8192000000 10754883856 11177246720 1825820112 18.225 99 29 57 2 1840350192 6681552 7848528
14:20:06 5436 8192000000 10747353904 11170148352 1820310976 18.180 99 29 58 1 1835324112 7043840 7969296
14:20:17 4828 8192000000 10692800320 11114807296 1744142640 17.553 96 24 48 0 1756651840 5353696 7155504
14:20:30 4496 8192000000 10723780432 11140169728 1783099888 17.875 99 28 56 3 1801339088 10565024 7674176
14:20:42 8420 8192000000 10700823120 11116474368 1758692832 17.674 97 24 48 1 1771753920 5294624 7766464
14:20:58 6459 8192000000 10721905056 11131564032 1771188880 17.777 98 25 50 1 1785539088 6742880 7607328
14:21:11 6837 8192000000 10695468656 11113431040 1720072432 17.353 95 37 73 3 1736455472 6127200 10255840
14:21:27 6356 8192000000 10709221312 11119759360 1765274192 17.728 98 25 50 0 1782061424 9782176 7005056
14:21:42 8866 8192000000 10694640656 11105378304 1730739488 17.442 96 16 32 1 1740310816 4959552 4611776
14:21:59 21223 8192000000 10714207488 11131518976 1738035616 17.502 96 21 42 0 1749096912 5112096 5949200
14:22:30 10004 8192000000 10706024752 11127369728 1767353424 17.745 98 20 40 1 1778837456 5191584 6292448
14:22:47 66580 8192000000 10738018560 11136872448 1758928128 17.676 97 28 55 3 1771991328 4865056 8198144
14:23:59 7963 8192000000 10717616624 11137150976 1791206912 17.942 99 22 44 2 1804182480 6452192 6523376
14:24:14 7430 8192000000 10730719904 11154579456 1819207280 18.171 100 27 54 0 1832678448 5867840 7603328
14:24:32 6246 8192000000 10755645200 11171164160 1828518256 18.247 100 34 68 0 1849286944 11350560 9418128
14:24:45 11271 8192000000 10753120928 11176079360 1837292432 18.319 100 30 60 2 1851788592 5356352 9139808
14:25:03 5447 8192000000 10749354176 11179966464 1840270896 18.343 100 29 59 0 1855555104 7302480 7981728
14:25:19 4486 8192000000 10765716576 11185549312 1849180976 18.415 100 43 86 3 1868796048 7757664 11857408
14:25:34 10082 8192000000 10769662624 11195117568 1855036704 18.463 100 26 51 3 1872901616 9559808 8305104
14:25:50 9979 8192000000 10779908032 11207159808 1861471408 18.515 100 27 54 0 1875091936 5674176 7946352
14:26:11 10139 8192000000 10774216864 11205402624 1863483632 18.532 100 16 32 1 1873094144 5278320 4332192
14:26:27 11707 8192000000 10798935600 11223703552 1875545984 18.629 100 37 73 2 1892137424 5031904 11559536
14:26:47 7431 8192000000 10786485248 11221688320 1879127616 18.658 100 25 50 3 1892573872 6006528 7439728
14:27:00 8948 8192000000 10802105056 11229773824 1885903760 18.713 100 30 61 1 1899964352 5242096 8818496
14:27:16 17280 8192000000 10846352800 11262054400 1909248800 18.901 100 39 78 2 1925862720 5042928 11570992
14:27:55 14458 8192000000 10852614480 11273838592 1924111200 19.020 100 45 88 1 1945456064 7451760 13893104
14:28:17 99749 8192000000 10864678224 11298680832 1935135504 19.108 100 39 79 0 1955595328 9293552 11166272
14:30:29 75893 8192000000 10869858720 11310714880 1938980416 19.139 100 22 44 0 1959446768 14484432 5981920
14:31:53 19566 8192000000 10885651968 11327438848 1956399616 19.277 100 43 86 0 1982117824 12801424 12916784
14:32:19 16893 8192000000 10889106688 11326775296 1957236544 19.284 100 33 66 1 1977379392 9506336 10636512
14:32:44 9287 8192000000 10895739760 11327840256 1963489376 19.334 100 41 79 0 1984825824 9685712 11650736
14:33:02 17125 8192000000 10917817792 11347578880 1975107856 19.426 100 59 116 3 2007394512 14355888 17930768
14:33:25 9407 8192000000 10903662944 11331026944 1958287664 19.292 99 62 122 3 1988731344 12997728 17445952
14:33:42 2428 8192000000 10913715104 11334250496 1953332880 19.253 99 69 134 2 1986125840 13732720 19060240
14:33:52 13694 8192000000 10920574864 11347931136 1975505936 19.429 100 72 140 2 2009886128 14675840 19704352
14:34:38 7040 8192000000 10920358144 11343814656 1962983648 19.330 99 65 130 4 2002663392 20736384 18943360
14:34:53 11954 8192000000 10920259456 11351347200 1975422272 19.428 100 54 108 3 2011119504 19969664 15727568
14:35:18 7627 8192000000 10923534576 11363139584 1980090656 19.465 100 51 102 1 2014776032 19522496 15162880
14:35:35 5350 8192000000 10927129152 11365113856 1981652000 19.478 100 48 96 1 2016917504 20691232 14574272
14:35:49 11834 8192000000 10937707072 11372584960 1988674112 19.533 100 55 110 4 2029706576 24363104 16669360
14:36:13 6821 8192000000 10937918208 11372494848 1991694032 19.557 100 47 92 0 2022545392 17936688 12914672
14:36:35 8286 8192000000 10942816400 11379990528 1995972640 19.591 100 50 100 2 2030206640 19844624 14389376
14:36:50 4306 8192000000 10945226032 11375763456 1986008768 19.512 99 63 125 1 2022964208 19416928 17538512
14:37:01 3901 8192000000 10956391440 11380736000 2000266864 19.625 100 76 151 3 2042170112 20421392 21481856
14:37:13 5270 8192000000 10957322688 11389186048 2004267904 19.656 100 66 132 0 2044622368 21264400 19090064
14:37:26 8623 8192000000 10958802880 11390013440 2007435008 19.681 100 63 126 3 2047196272 21747632 18013632
14:37:42 4796 8192000000 10966170896 11394019328 2008283776 19.688 100 73 143 6 2051856896 22865824 20707296
14:37:54 5271 8192000000 10953150192 11392831488 2009805232 19.700 100 64 125 1 2049694768 21651680 18237856
14:38:07 4345 8192000000 10952266160 11383209984 1996147648 19.592 100 71 142 3 2040740224 23499152 21093424
14:38:18 4153 8192000000 10961389296 11386085376 1999496976 19.619 100 68 134 2 2043726944 24845232 19384736
14:38:32 5863 8192000000 10955873600 11388891136 2003108560 19.647 100 58 114 0 2042473488 23530416 15834512
14:38:45 6471 8192000000 10955277104 11376730112 1997533920 19.603 100 81 162 1 2046372944 24734032 24104992
14:39:02 4709 8192000000 10944397904 11368321024 1979596848 19.462 100 76 152 0 2028111984 26370256 22144880
14:39:14 7038 8192000000 10952356672 11377688576 1990191504 19.545 100 74 148 1 2038017344 26393744 21432096
14:39:28 4902 8192000000 10951755536 11377442816 1988571520 19.533 100 79 158 0 2036803888 25444048 22788320
14:39:41 10079 8192000000 10948091248 11378778112 1986740784 19.518 100 65 130 4 2031633776 25115904 19777088
14:40:00 2641 8192000000 10940466160 11372322816 1972684368 19.407 99 59 119 1 2016669376 26317888 17667120
14:40:10 2667 8192000000 10954699504 11377606656 1990469584 19.548 100 85 169 1 2042560496 27328752 24762160
14:40:20 2033 8192000000 10966197616 11380830208 1991022464 19.552 100 79 155 1 2042682896 28152880 23507552
14:40:31 4265 8192000000 10959333040 11374981120 1972257792 19.403 99 83 164 3 2026424336 29559056 24607488
14:40:42 3918 8192000000 10951596912 11369209856 1967311008 19.364 99 88 173 0 2024629440 31047680 26270752
14:40:53 2659 8192000000 10959417568 11374133248 1980881872 19.472 100 88 176 3 2040935952 32725920 27328160
14:41:03 7828 8192000000 10947385152 11371778048 1982496352 19.484 100 77 154 1 2039659136 32933776 24229008
14:41:20 21862 8192000000 10906945008 11332468736 1912943936 18.930 97 60 121 3 1961896528 30974160 17978432
14:41:49 1232 8192000000 10928081824 11350790144 1964775696 19.344 100 73 146 0 2018427072 31614336 22037040
14:41:58 7024 8192000000 10918588192 11345518592 1930746784 19.073 98 66 129 1 1982462496 31486880 20228832
14:42:15 4439 8192000000 10915079936 11346796544 1929246784 19.061 98 63 125 0 1977947152 28942224 19758144
14:42:26 4799 8192000000 10954081600 11365359616 1970237840 19.387 100 76 153 0 2027968256 34721520 23008896
14:42:38 5582 8192000000 10944589488 11370536960 1972454192 19.405 100 65 130 1 2028131696 36018272 19659232
14:42:50 2072 8192000000 10951254608 11372511232 1961899088 19.321 99 82 163 3 2018665200 32160384 24605728
14:42:58 5701 8192000000 10924164800 11340763136 1936740992 19.121 99 84 170 1 1993444016 30672640 26030384
14:43:12 3705 8192000000 10911351536 11320537088 1935266400 19.109 99 84 166 2 1991956848 31316480 25373968
14:43:23 3583 8192000000 10924977024 11333926912 1933994112 19.099 99 80 157 1 1990094496 31957952 24142432
14:43:33 2214 8192000000 10935549408 11346468864 1957692512 19.288 100 87 175 1 2015219872 30794592 26732768
14:43:43 3938 8192000000 10923200000 11335905280 1950955376 19.234 100 83 165 1 2008066752 32682080 24429296
14:43:54 5483 8192000000 10936826016 11351683072 1959923168 19.305 100 81 159 0 2018110976 34572576 23615232
14:44:07 3230 8192000000 10939261632 11354046464 1961505232 19.318 100 81 163 0 2021362464 34220320 25636912
14:44:20 4517 8192000000 10952534496 11362263040 1967280576 19.364 100 91 182 1 2031980880 36614480 28085824
14:44:31 3084 8192000000 10951950608 11367579648 1969351120 19.380 100 78 157 1 2028005856 34451984 24202752
14:44:49 4626 8192000000 10952715248 11380121600 1978275344 19.451 100 69 139 2 2037582704 38073472 21233888
14:45:03 4251 8192000000 10954617360 11374170112 1956330624 19.277 99 66 130 1 2013168992 36397424 20440944
14:45:18 4104 8192000000 10946539328 11370987520 1981802608 19.479 100 72 144 1 2039239552 34753216 22683728
14:45:29 6499 8192000000 10955066576 11375489024 1973211024 19.411 100 68 135 0 2030806224 36400048 21195152
14:45:43 1311 8192000000 10971574944 11387473920 1981294928 19.475 100 85 171 0 2050318784 41792864 27230992
14:45:50 2559 8192000000 10966240640 11379126272 1978607296 19.454 100 92 183 1 2044843104 38112944 28122864
14:46:00 3701 8192000000 10963094416 11381477376 1978913456 19.456 100 81 160 1 2043191280 39871680 24406144
14:46:11 3721 8192000000 10975204288 11387498496 1985299312 19.507 100 90 180 0 2054233680 41794096 27140272
14:46:23 5487 8192000000 10949229136 11358363648 1958509872 19.294 99 79 156 4 2023611504 41665152 23436480
14:46:36 13377 8192000000 10950945904 11372752896 1968919440 19.377 100 67 133 1 2035740080 46007024 20813616
14:46:57 2386 8192000000 10959951760 11375837184 1968234192 19.371 100 75 150 1 2038383120 46841040 23307888
14:47:10 6243 8192000000 10968636160 11388055552 1977680576 19.446 100 77 153 2 2049170784 47737200 23753008
14:47:24 5598 8192000000 10960167920 11389480960 1979133040 19.458 100 62 124 1 2044541344 45762704 19645600
14:47:40 1050 8192000000 10987116352 11398397952 1985590096 19.509 100 86 171 3 2061125920 48546208 26989616
14:47:47 1557 8192000000 10988026976 11399811072 1987041136 19.520 100 89 176 0 2065638880 50279312 28318432
14:47:56 3186 8192000000 10955613632 11370397696 1946265504 19.197 99 81 161 2 2024123632 52478768 25379360
14:48:06 2575 8192000000 10975881296 11392888832 1977056224 19.441 100 88 177 0 2059181328 53706752 28418352
14:48:16 6666 8192000000 10955965168 11397230592 1975708592 19.431 100 56 112 1 2046247152 52266272 18272288
14:48:36 14313 8192000000 10943061264 11388329984 1968039072 19.370 100 31 62 1 2024057216 45437328 10580816
14:49:20 8332 8192000000 10946161152 11378733056 1974914656 19.424 100 40 79 0 2031179760 41896304 14368800
14:49:36 12343 8192000000 10941990352 11388542976 1977980720 19.449 100 40 76 2 2028632256 37830800 12820736
14:49:55 28071 8192000000 10906778224 11352502272 1926080560 19.036 97 59 117 1 1978577264 33958432 18538272
14:50:36 16320 8192000000 10927231440 11366281216 1939484464 19.143 99 40 80 3 1995227696 42750336 12992896
14:51:16 10823 8192000000 10908498112 11364331520 1944712688 19.184 100 33 67 2 1998744800 42793728 11238384
14:51:39 9602 8192000000 10916550000 11364196352 1950373680 19.229 100 28 56 1 2003399760 43099856 9926224
14:51:55 12477 8192000000 10933378240 11376259072 1956005248 19.274 100 35 70 2 2014154656 46194496 11954912
14:52:21 13865 8192000000 10903515040 11356434432 1926693616 19.040 99 30 60 1 1978294096 41403904 10196576
14:52:41 26773 8192000000 10905231840 11357196288 1941706304 19.160 100 31 62 0 1989066752 36691984 10668464
14:53:15 30272 8192000000 10901227312 11355688960 1924029104 19.019 99 22 44 1 1971305952 39569040 7707808
14:54:22 27180 8192000000 10907273120 11366035456 1931397632 19.078 100 22 44 3 1984854208 45750512 7706064
14:55:04 29270 8192000000 10898816448 11367821312 1941848944 19.162 100 24 49 1 1988389360 38886592 7653824
14:55:45 49782 8192000000 10882977600 11357089792 1934974688 19.107 100 14 28 0 1967757472 28209280 4573504
14:56:56 87723 8192000000 10894396032 11332739072 1876458960 18.637 96 15 30 0 1895293120 14315328 4518832
14:58:32 20274 8192000000 10882040288 11333967872 1945555312 19.191 100 36 71 2 1962929696 7426288 9948096
14:59:10 75123 8192000000 10863712784 11320819712 1877935056 18.648 96 20 37 3 1894710336 11269488 5505792
15:00:32 34844 8192000000 10892910928 11335942144 1947401184 19.206 100 31 59 2 1966592544 9539184 9652176
15:01:20 120703 8192000000 10891671360 11352158208 1919432416 18.982 98 21 42 2 1935652992 10244256 5976320
15:03:28 61264 8192000000 10887626960 11344486400 1922739472 19.009 98 29 55 3 1946983872 16930624 7313776
15:04:48 39195 8192000000 10904176928 11345424384 1939948240 19.146 99 55 105 1 1967609472 12450080 15211152
15:05:34 677 8192000000 10894576608 11322761216 1936561888 19.119 99 60 120 2 1964630848 10210688 17858272
15:05:41 36421 8192000000 10883271440 11343134720 1955941072 19.274 100 28 56 0 1972679184 8219952 8518160
15:06:24 42083 8192000000 10905781232 11358543872 1961344224 19.317 100 33 65 4 1982039568 10440640 10254704
15:07:17 44045 8192000000 10893478816 11349143552 1906690912 18.880 97 33 65 0 1930443392 14094224 9658256
15:08:11 56178 8192000000 10875311424 11335639040 1891940672 18.761 97 11 22 0 1901757696 6797776 3019248
15:09:14 162075 8192000000 10883035392 11354312704 1921281056 18.997 98 17 34 1 1939134176 12620080 5233040
15:12:04 78405 8192000000 10887741504 11359690752 1937513904 19.127 99 17 31 1 1963408240 19430016 6464320
15:13:29 94829 8192000000 10888197712 11373178880 1956373712 19.277 100 13 26 0 1979782528 19785296 3623520
15:15:24 71585 8192000000 10875830512 11346817024 1900569504 18.831 97 10 20 0 1915613968 12295696 2748768
15:16:42 41942 8192000000 10885079488 11355140096 1935502304 19.111 99 22 44 1 1954083728 11809536 6771888
15:17:34 71834 8192000000 10911181136 11392557056 1970105072 19.386 100 23 45 2 1993118336 16049776 6963488
15:19:25 69516 8192000000 10894834624 11376197632 1952154944 19.244 99 11 22 0 1974438416 18945056 3338416
15:20:40 37864 8192000000 10909367248 11376930816 1955409872 19.270 99 18 37 0 1969391024 8936928 5044224
15:21:25 35138 8192000000 10898120608 11365040128 1926616736 19.040 97 25 49 1 1941735648 8774160 6344752
15:22:06 29081 8192000000 10921523216 11377901568 1959212736 19.300 99 37 74 0 1979905360 9682624 11010000
15:22:41 28629 8192000000 10902421792 11367059456 1939983584 19.147 98 24 48 1 1957968032 11338368 6646080
15:23:17 31178 8192000000 10911052784 11376992256 1951571488 19.239 99 27 54 1 1972323088 13408816 7342784
15:23:55 34235 8192000000 10905989312 11369291776 1968297232 19.372 100 21 42 0 1986714784 12027872 6389680
15:24:35 43240 8192000000 10909092096 11369668608 1936337584 19.118 98 30 58 3 1956276688 11106208 8832896
15:25:27 47395 8192000000 10900064880 11369050112 1917678912 18.968 97 22 44 1 1936116496 12305632 6131952
15:26:23 107539 8192000000 10891104720 11367632896 1886164048 18.715 96 16 30 1 1908242752 18246608 3832096
15:28:17 111995 8192000000 10882178992 11346481152 1858225488 18.489 94 35 70 0 1874885696 7139632 9520576
15:30:17 38159 8192000000 10895877568 11362652160 1961856288 19.321 100 21 42 2 1977330464 10031968 5442208
15:31:10 39204 8192000000 10883689392 11350581248 1935898528 19.114 98 21 42 1 1952872688 11098416 5875744
15:31:58 68134 8192000000 10872051664 11353493504 1912615568 18.928 97 10 20 1 1926262144 11086944 2559632
15:33:14 43162 8192000000 10870644400 11351478272 1882899376 18.689 96 16 32 1 1900412896 13297136 4216384
15:34:08 42456 8192000000 10870953952 11346960384 1898731648 18.816 97 14 28 1 1917851952 14894608 4225696
15:35:04 19654 8192000000 10857925552 11334676480 1906107536 18.875 98 16 31 0 1925142000 14408176 4626288
15:35:31 58757 8192000000 10864519536 11332427776 1866303728 18.554 96 13 26 0 1886052768 15721152 4027888
15:36:50 40231 8192000000 10898356336 11360845824 1955710224 19.272 100 21 41 1 1973596896 11875952 6010720
15:37:42 40256 8192000000 10900419024 11351932928 1930260432 19.069 98 42 84 2 1951911936 9893744 11757760
15:38:29 43985 8192000000 10893653472 11359125504 1940378816 19.150 99 34 68 4 1959427280 9705312 9343152
15:39:27 35706 8192000000 10878629856 11334430720 1900830400 18.833 98 33 66 0 1920884976 10516560 9538016
15:40:19 48443 8192000000 10876146496 11338092544 1892801776 18.768 97 34 68 0 1914372288 11859008 9711504
15:42:00 114564 8192000000 10887082512 11357016064 1855275120 18.465 95 29 59 0 1877706352 14369648 8061584
15:44:00 63090 8192000000 10864074672 11329081344 1866927344 18.559 96 12 23 3 1886861488 16667280 3266864
15:45:10 30419 8192000000 10900862656 11364147200 1946637680 19.200 100 23 46 3 1969918720 16946384 6334656
15:45:49 41983 8192000000 10897747872 11374120960 1952740992 19.248 100 28 56 0 1979145312 18487216 7917104
15:46:53 88222 8192000000 10912774176 11395842048 1923626448 19.016 98 14 28 1 1952521472 24708528 4186496
15:48:27 77446 8192000000 10902351056 11406487552 1942076160 19.163 99 6 12 1 1974100432 30439904 1584368
15:49:55 81902 8192000000 10887640768 11363655680 1923006384 19.011 98 20 40 0 1945674976 17364496 5304096
15:51:28 51479 8192000000 10889519552 11374960640 1964039952 19.338 100 16 32 2 1982571424 14394448 4137024
15:52:25 10817 8192000000 10885266928 11375865856 1961898592 19.321 100 5 10 0 1976620864 13726992 995280
15:52:46 45838 8192000000 10885232944 11374559232 1953408384 19.254 99 20 40 0 1971780032 12581440 5790208
15:54:48 64187 8192000000 10887344992 11364585472 1928943360 19.058 98 17 34 3 1949243952 15242304 5058288
15:56:03 70843 8192000000 10857235200 11346485248 1898122688 18.811 97 14 28 1 1919972048 17662448 4186912
15:57:22 65978 8192000000 10870682096 11351580672 1939006416 19.139 100 18 35 0 1960838128 17003488 4828224
15:58:34 25999 8192000000 10880455264 11351736320 1944260128 19.181 99 24 48 3 1957393728 6266032 6867568
15:59:07 34358 8192000000 10899015392 11369689088 1951260464 19.237 99 18 36 0 1963833536 7383984 5189088
15:59:51 72172 8192000000 10877106608 11370844160 1935629504 19.112 98 13 25 2 1948574320 8788720 4156096
16:01:12 58356 8192000000 10882210816 11358912512 1907388480 18.886 97 10 20 1 1916285888 6790240 2107168
16:02:16 54578 8192000000 10898630240 11372740608 1963804368 19.336 100 16 32 0 1976851888 8965152 4082368
16:03:17 47728 8192000000 10891563760 11369803776 1953270832 19.253 99 15 30 1 1966172944 8268384 4633728
16:04:12 55564 8192000000 10895091792 11366256640 1896816752 18.801 96 14 28 2 1912663728 11830640 4016336
16:05:15 34403 8192000000 10916304480 11370561536 1932259952 19.085 98 47 94 2 1961815664 15610768 13944944
16:06:00 19317 8192000000 10894733232 11357011968 1938557936 19.135 99 33 67 1 1956011712 7933968 9519808
16:06:28 71346 8192000000 10893278960 11378188288 1948395696 19.214 99 31 62 0 1970476272 13120000 8960576
16:07:46 50342 8192000000 10905875632 11375591424 1951447104 19.238 99 18 36 0 1966470528 10175056 4848368
16:08:44 58519 8192000000 10914505808 11399098368 1979195360 19.458 100 30 60 0 1999147952 11492800 8459792
16:09:56 151466 8192000000 10877985808 11362131968 1838049712 18.325 93 12 24 0 1853393776 12208656 3135408
16:12:37 78845 8192000000 10882647792 11354943488 1885019088 18.706 96 21 42 2 1907365008 16839008 5506912
16:14:36 84970 8192000000 10909211808 11373961216 1970753888 19.391 100 50 98 4 1993623408 9218768 13650752
16:16:25 74735 8192000000 10899256144 11376435200 1952909264 19.250 99 23 46 0 1969125568 9893728 6322576
16:18:51 7884 8192000000 10899560272 11375378432 1971584416 19.398 100 35 69 1 1987221008 5837072 9799520
16:19:05 64398 8192000000 10864476160 11349110784 1905486848 18.870 97 26 52 3 1927678800 15009584 7182368
16:20:42 69213 8192000000 10870499888 11344633856 1926874224 19.042 99 9 17 1 1939317824 10145008 2298592
16:21:58 93201 8192000000 10861585120 11343261696 1859578464 18.500 95 19 38 1 1878883680 12996048 6309168
16:23:38 48170 8192000000 10849671040 11334025216 1908288352 18.893 99 12 24 0 1927106640 14985952 3832336
16:24:36 70852 8192000000 10850009600 11340414976 1893061696 18.770 98 9 18 1 1909424592 13658688 2704208
16:25:58 58848 8192000000 10866304576 11341443072 1902581568 18.847 98 26 52 2 1923626688 13100736 7944384
16:27:15 11496 8192000000 9267920464 9539637248 424786336 4.929 22 7 14 0 432826432 6052800 1987296

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 11-02-2021 16:29:00 to 11-02-2021 16:29:32.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 120 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-02-2021 16:29:33 to 11-02-2021 16:29:35.

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          240192
MON$OLDEST_ACTIVE               240878
MON$OLDEST_SNAPSHOT             240878
MON$NEXT_TRANSACTION            240878
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                       2024512
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:210: 
:211: mscs-test-161.budzdorov.ru    Thu Feb 11 16:27:29 2021
:212:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:213: 
:214: 
:215: mscs-test-161.budzdorov.ru    Thu Feb 11 16:27:44 2021
:216:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:217: 
--- end of diff output ---

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

11.02.21 16:29:36. 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-02-11 16:29:38 No severe PSQL-related problems occured
11.02.21 16:29:39. End of report.