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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17057956 kB
MemAvailable 31406340 kB
Buffers 0 kB
Cached 14592240 kB
SwapCached 4820 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-30 19:27:06
DTS_END                         2020-12-30 19:27:06.7490
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(676:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47926
TRN_ID                          249169
ATT_ID                          680
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: 9706.58 21291 1164789
customer order: creation 178.72 306 21446
customer order: refuse 15.58 338 1869
order to supplier: creation 48.08 1251 5770
order to supplier: removal 3.45 98853 414
invoice (draft): creation 46.76 3196 5611
invoice (draft): removal 54.41 783 6529
invoice accept: apply 44.59 17944 5351
invoice accept: cancel 49.10 744 5892
customer reserve: creation 4108.78 178 493054
customer reserve: removal 4846.77 55 581612
realization accept: apply 87.71 180 10525
realization accept: cancel 85.92 111 10310
payment from customer: creation 62.30 124 7476
payment from customer: removal 5.83 80 699
payment to supplier: creation 52.05 129 6246
payment to supplier: removal 3.73 71 448
service: total inventory turnovers 4.95 1228 594
service: total monetary turnovers 7.12 38 854
service: aggregate perf. data 0.71 27615 85
service: refresh index statistics 0.03 272597 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 30-12-2020 19:28:09 to 30-12-2020 19:28:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10516
TEST_TIME 2 8178
TEST_TIME 3 7397
TEST_TIME 4 7022
TEST_TIME 5 6632
TEST_TIME 6 6137
TEST_TIME 7 6210
TEST_TIME 8 6448
TEST_TIME 9 6677
TEST_TIME 10 6815
TEST_TIME 11 7118
TEST_TIME 12 7155
TEST_TIME 13 7461
TEST_TIME 14 7848
TEST_TIME 15 7976
TEST_TIME 16 8151
TEST_TIME 17 8602
TEST_TIME 18 8638
TEST_TIME 19 8691
TEST_TIME 20 8919
TEST_TIME 21 9192
TEST_TIME 22 9154
TEST_TIME 23 9426
TEST_TIME 24 9777
TEST_TIME 25 9772
TEST_TIME 26 10462
TEST_TIME 27 10402
TEST_TIME 28 10852
TEST_TIME 29 11440
TEST_TIME 30 11649
TEST_TIME 31 11574
TEST_TIME 32 11370
TEST_TIME 33 11271
TEST_TIME 34 11029
TEST_TIME 35 11290
TEST_TIME 36 11435
TEST_TIME 37 11250
TEST_TIME 38 11062
TEST_TIME 39 10914
TEST_TIME 40 10670
TEST_TIME 41 10592
TEST_TIME 42 10716
TEST_TIME 43 10706
TEST_TIME 44 10549
TEST_TIME 45 10448
TEST_TIME 46 10392
TEST_TIME 47 10372
TEST_TIME 48 10247
TEST_TIME 49 10453
TEST_TIME 50 10441
TEST_TIME 51 10408
TEST_TIME 52 10372
TEST_TIME 53 10221
TEST_TIME 54 10124
TEST_TIME 55 10034
TEST_TIME 56 9980
TEST_TIME 57 10016
TEST_TIME 58 9944
TEST_TIME 59 9988
TEST_TIME 60 9938
TEST_TIME 61 9948
TEST_TIME 62 10031
TEST_TIME 63 10039
TEST_TIME 64 10002
TEST_TIME 65 10027
TEST_TIME 66 10095
TEST_TIME 67 10108
TEST_TIME 68 10149
TEST_TIME 69 10132
TEST_TIME 70 10212
TEST_TIME 71 10278
TEST_TIME 72 10238
TEST_TIME 73 10229
TEST_TIME 74 10126
TEST_TIME 75 10110
TEST_TIME 76 10106
TEST_TIME 77 10037
TEST_TIME 78 10074
TEST_TIME 79 9992
TEST_TIME 80 9988
TEST_TIME 81 9964
TEST_TIME 82 9919
TEST_TIME 83 9959
TEST_TIME 84 9905
TEST_TIME 85 9816
TEST_TIME 86 9866
TEST_TIME 87 9806
TEST_TIME 88 9777
TEST_TIME 89 9759
TEST_TIME 90 9712
TEST_TIME 91 9779
TEST_TIME 92 9783
TEST_TIME 93 9734
TEST_TIME 94 9864
TEST_TIME 95 9903
TEST_TIME 96 9894
TEST_TIME 97 9911
TEST_TIME 98 9968
TEST_TIME 99 9974
TEST_TIME 100 9986
TEST_TIME 101 9996
TEST_TIME 102 10074
TEST_TIME 103 10020
TEST_TIME 104 9978
TEST_TIME 105 9938
TEST_TIME 106 9897
TEST_TIME 107 9867
TEST_TIME 108 9888
TEST_TIME 109 9849
TEST_TIME 110 9853
TEST_TIME 111 9818
TEST_TIME 112 9773
TEST_TIME 113 9733
TEST_TIME 114 9735
TEST_TIME 115 9721
TEST_TIME 116 9732
TEST_TIME 117 9705
TEST_TIME 118 9717
TEST_TIME 119 9743
TEST_TIME 120 9709

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 30-12-2020 19:28:13 to 30-12-2020 19:28:16.

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 1619705 1619705 0 0.00 0 15246 6 0 0
doc_list_biud 1619699 1619699 0 0.00 0 31280 25 0 0
sp_add_invoice_to_stock 5453 5351 102 1.87 31 200871 17945 0 102
sp_cancel_adding_invoice 5892 5892 0 0.00 6 67444 744 0 0
sp_cancel_client_order 1869 1869 0 0.00 4 12144 338 0 0
sp_cancel_customer_reserve 581612 581612 0 0.00 1 31307 55 0 0
sp_cancel_pay_from_customer 699 699 0 0.00 3 4691 81 0 0
sp_cancel_pay_to_supplier 448 448 0 0.00 2 2913 72 0 0
sp_cancel_supplier_invoice 6538 6529 9 0.13 2 13527 784 0 9
sp_cancel_supplier_order 414 414 0 0.00 4 1038504 98854 0 0
sp_cancel_write_off 10310 10310 0 0.00 1 9443 111 0 0
sp_client_order 21446 21446 0 0.00 3 21272 306 0 0
sp_customer_reserve 493054 493054 0 0.00 0 118043 178 0 0
sp_fill_shopping_cart 32827 32827 0 0.00 1 23914 36 0 0
sp_fill_shopping_cart_clo_res 493039 493039 0 0.00 0 10842 13 0 0
sp_get_clo_for_invoice 5336 5336 0 0.00 0 26613 256 0 0
sp_kill_cost_storno 17349 17349 0 0.00 0 5214 53 0 0
sp_kill_qstorno_ret_qs2qd 1180477 1180477 0 0.00 0 31278 30 0 0
sp_kill_qty_storno 622482 622482 0 0.00 0 31279 66 0 0
sp_lock_selected_doc 21927 21927 0 0.00 0 10877 7 0 0
sp_make_cost_storno 29583 29583 0 0.00 0 15229 50 0 0
sp_multiply_rows_for_pdistr 29581 29581 0 0.00 0 13937 29 0 0
sp_multiply_rows_for_qdistr 21446 21446 0 0.00 0 10735 136 0 0
sp_pay_from_customer 7476 7476 0 0.00 4 14122 124 0 0
sp_pay_to_supplier 6246 6246 0 0.00 5 15377 130 0 0
sp_payment_common 13722 13722 0 0.00 1 8842 29 0 0
sp_qd_handle_on_cancel_clo 1869 1869 0 0.00 0 12135 301 0 0
sp_qd_handle_on_invoice_upd_sts 11224 11224 0 0.00 0 23393 320 0 0
sp_qd_handle_on_reserve_upd_sts 10524 10524 0 0.00 0 22018 58 0 0
sp_reserve_write_off 10525 10525 0 0.00 6 22067 181 0 0
sp_supplier_invoice 5611 5611 0 0.00 5 62556 3197 0 0
sp_supplier_order 5770 5770 0 0.00 5 31739 1252 0 0
srv_aggregate_perf_data 86 85 1 1.16 2879 315089 27615 0 1
srv_fill_mon_cache_memory 177 177 0 0.00 1435 145598 30163 0 0
srv_find_qd_qs_mism 1113662 1113662 0 0.00 0 8645 5 0 0
srv_make_invnt_saldo 594 594 0 0.00 19 110268 1228 0 0
srv_make_money_saldo 854 854 0 0.00 0 7575 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 87857 427735 272597 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5351 5351 0 0.00 0 15839 184 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 0 13421 177 0 0
t$perf-norm:sp_cancel_client_order 1869 1869 0 0.00 0 6553 19 0 0
t$perf-norm:sp_cancel_customer_reserve 690 690 0 0.00 0 1472 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 699 699 0 0.00 0 3790 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 448 448 0 0.00 0 2054 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 434 434 0 0.00 0 1780 15 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 26738 1695 0 0
t$perf-norm:sp_cancel_write_off 1110 1110 0 0.00 0 7861 15 0 0
t$perf-norm:sp_client_order 21446 21446 0 0.00 0 12746 20 0 0
t$perf-norm:sp_customer_reserve 1021 1021 0 0.00 0 6024 13 0 0
t$perf-norm:sp_pay_from_customer 7476 7476 0 0.00 0 10052 10 0 0
t$perf-norm:sp_pay_to_supplier 6246 6246 0 0.00 0 5614 11 0 0
t$perf-norm:sp_reserve_write_off 10525 10525 0 0.00 0 6423 14 0 0
t$perf-norm:sp_supplier_invoice 5611 5611 0 0.00 0 10626 24 0 0
t$perf-norm:sp_supplier_order 5770 5770 0 0.00 0 5681 20 0 0
t$perf-norm:srv_aggregate_perf_data 85 85 0 0.00 0 5017 65 0 0
t$perf-norm:srv_fill_mon_cache_memory 177 177 0 0.00 0 138 2 0 0
t$perf-norm:srv_make_invnt_saldo 594 594 0 0.00 0 5148 33 0 0
t$perf-norm:srv_make_money_saldo 854 854 0 0.00 0 1705 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10866 10662 204 1.87 0 8152 20 0 204
v_all_customers 39230 39230 0 0.00 0 23 1 0 0
v_all_suppliers 31606 31606 0 0.00 0 116 1 0 0
v_all_wares 42892 42892 0 0.00 0 90 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 3200 16 0 0
v_cancel_client_order 3738 3738 0 0.00 0 3828 7 0 0
v_cancel_customer_prepayment 1398 1398 0 0.00 0 1362 5 0 0
v_cancel_customer_reserve 1380 1380 0 0.00 0 3332 5 0 0
v_cancel_payment_to_supplier 896 896 0 0.00 0 2902 6 0 0
v_cancel_supplier_invoice 886 868 18 2.03 0 1884 14 0 18
v_cancel_supplier_order 828 828 0 0.00 0 2985 7 0 0
v_cancel_write_off 2220 2220 0 0.00 0 3149 14 0 0
v_max_id_clo_ord 5770 5770 0 0.00 0 340 1 0 0
v_max_id_clo_res 1021 1021 0 0.00 0 3437 20 0 0
v_max_id_ord_sup 5611 5611 0 0.00 0 2970 4 0 0
v_max_non_paid_invoice 1824 1824 0 0.00 0 2086 4 0 0
v_max_non_paid_realizn 3853 3853 0 0.00 0 5990 6 0 0
v_min_id_clo_ord 5770 5770 0 0.00 0 2852 6 0 0
v_min_id_clo_res 1021 1021 0 0.00 0 2059 6 0 0
v_min_id_ord_sup 5611 5611 0 0.00 0 4033 6 0 0
v_min_non_paid_invoice 6246 6246 0 0.00 0 8839 18 0 0
v_min_non_paid_realizn 7476 7476 0 0.00 0 7593 17 0 0
v_our_firm 10908 10908 0 0.00 0 22 1 0 0
v_reserve_write_off 21048 21048 0 0.00 0 3238 7 0 0
x_lock_depdocs_on_canc_invoice 11987 11987 0 0.00 0 22056 104 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 3908 323 0 0
x_make_qstorno_1000_1200 5770 5770 0 0.00 2 31729 1171 0 0
x_make_qstorno_1200_2000 5611 5611 0 0.00 3 62540 3068 0 0
x_make_qstorno_2100_3300 493054 493054 0 0.00 0 118021 163 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 30-12-2020 19:28:17 to 30-12-2020 19:28:22.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:10 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:17 15723 8192000000 10191854128 10499219456 841661056 9.316 68 49 98 0 861437936 2425408 17351472
16:57:43 20727 8192000000 10301036464 10614669312 1345254656 14.105 100 85 170 1 1378467408 4126928 29085824
16:58:13 27590 8192000000 10356325152 10674552832 1394045360 14.542 100 81 161 1 1426308304 5427632 26835312
16:58:54 36161 8192000000 10387779200 10711801856 1439604016 14.946 100 86 172 0 1474547088 6957808 27985264
16:59:38 17742 8192000000 10411682944 10739298304 1461929056 15.143 100 94 188 0 1500507824 7728288 30850480
17:00:06 22439 8192000000 10435244016 10766135296 1484702624 15.343 100 88 174 1 1521222368 8607152 27912592
17:00:43 15641 8192000000 10447771504 10784010240 1507017008 15.537 100 86 172 1 1543245120 8938352 27289760
17:01:10 17440 8192000000 10475175232 10818002944 1522124784 15.669 100 78 156 0 1556121504 9487504 24509216
17:01:42 14236 8192000000 10505943232 10856480768 1565330896 16.042 100 79 158 0 1599042080 9550000 24161184
17:02:05 20333 8192000000 10543331216 10896273408 1596463808 16.309 100 84 168 0 1632132912 10150928 25518176
17:02:34 16606 8192000000 10565184736 10926800896 1627112704 16.570 100 80 160 1 1661665056 10902352 23650000
17:03:00 8136 8192000000 10599036080 10957598720 1653681520 16.796 100 77 155 0 1687567008 11377408 22508080
17:03:18 14462 8192000000 10608920976 10976337920 1666974384 16.908 100 78 156 0 1702842240 12815408 23052448
17:03:44 11087 8192000000 10629216544 10998378496 1689834144 17.100 100 83 165 1 1727183360 12940096 24409120
17:04:02 9653 8192000000 10640250096 11015872512 1705759808 17.233 100 79 158 1 1741393744 12650480 22983456
17:04:19 8823 8192000000 10660861824 11032383488 1725701376 17.400 100 86 172 1 1763417232 13121808 24594048
17:04:35 4802 8192000000 10670823168 11042512896 1731935984 17.452 100 89 178 0 1771208688 13834640 25438064
17:04:47 6473 8192000000 10686457328 11059146752 1742164512 17.537 100 86 172 2 1780161904 14347008 23650384
17:05:01 5127 8192000000 10695985616 11070988288 1752187328 17.620 100 86 167 4 1789938384 14032352 23718704
17:05:14 5661 8192000000 10700580624 11078959104 1759089664 17.677 100 86 171 2 1797447808 14524512 23833632
17:05:27 3691 8192000000 10711455008 11092373504 1775006752 17.808 100 86 173 0 1812387568 13398384 23982432
17:05:37 3664 8192000000 10721719504 11102380032 1778949840 17.841 100 83 166 0 1814867888 13283152 22634896
17:05:47 2732 8192000000 10730572448 11109990400 1791291392 17.942 100 87 172 1 1828856288 13194784 24370112
17:05:56 3751 8192000000 10735176944 11119230976 1794225584 17.967 100 86 170 0 1831761744 13051840 24484320
17:06:07 2410 8192000000 10736724368 11119419392 1800323344 18.017 100 85 168 1 1837600224 13769344 23507536
17:06:16 3584 8192000000 10753094192 11134443520 1810167840 18.097 100 88 175 0 1848567024 13964336 24434848
17:06:26 3317 8192000000 10743049584 11132923904 1808728464 18.085 100 81 162 3 1845854560 15010304 22115792
17:06:35 2885 8192000000 10763716096 11146240000 1814248864 18.131 100 85 171 0 1851941664 14221168 23471632
17:06:45 1741 8192000000 10768159792 11155976192 1829237792 18.253 100 81 164 1 1865462880 13653264 22571824
17:06:53 2261 8192000000 10775195808 11160924160 1831396992 18.271 100 77 152 2 1865155696 12136928 21621776
17:07:01 2168 8192000000 10780955552 11171340288 1848889024 18.413 100 89 176 1 1885253152 12384176 23979952
17:07:10 2058 8192000000 10785049568 11169693696 1846423056 18.393 100 95 191 3 1887380480 14321984 26635440
17:07:18 1453 8192000000 10788528960 11178532864 1844964608 18.381 100 93 186 1 1885195424 13685184 26545632
17:07:26 1605 8192000000 10795295248 11183157248 1849461504 18.418 100 94 189 1 1890790288 14778528 26550256
17:07:34 1367 8192000000 10803074336 11187376128 1853897904 18.454 100 92 186 0 1894489840 14380800 26211136
17:07:42 1854 8192000000 10792571184 11186167808 1857432320 18.482 100 81 163 1 1892860768 12677008 22751440
17:07:50 23610 8192000000 10781884192 11193528320 1860532480 18.508 100 57 113 1 1888380064 12795360 15052224
17:08:23 2292 8192000000 10781271104 11196641280 1864382432 18.539 100 57 114 2 1890239456 9637232 16219792
17:08:32 3162 8192000000 10801896224 11198074880 1867778048 18.566 100 61 119 3 1893668960 9137456 16753456
17:08:41 5115 8192000000 10786422400 11203178496 1865373840 18.547 100 36 72 1 1884475440 8944960 10156640
17:08:54 4820 8192000000 10799598192 11210424320 1873360432 18.611 100 48 95 1 1895203152 8608256 13234464
17:09:06 4152 8192000000 10787784048 11208290304 1877452880 18.645 100 44 89 1 1898225152 7990544 12781728
17:09:20 6174 8192000000 10786623808 11206840320 1872470688 18.604 100 29 58 1 1891611664 11102816 8038160
17:09:32 6063 8192000000 10781728640 11210076160 1874436464 18.620 100 24 49 1 1886800608 5350656 7013488
17:09:46 10488 8192000000 10784410848 11214958592 1877795072 18.647 100 21 42 2 1890567568 6347280 6425216
17:10:03 12219 8192000000 10779885888 11214974976 1878178416 18.650 100 8 16 0 1886116544 5502368 2435760
17:10:22 11640 8192000000 10789651328 11221520384 1880677536 18.671 100 13 26 0 1889836224 5784672 3374016
17:10:45 15209 8192000000 10790428864 11222392832 1885974544 18.713 100 18 36 1 1896302304 5740832 4586928
17:11:10 15182 8192000000 10793948624 11233734656 1893446496 18.774 100 30 58 5 1907713520 5246192 9020832
17:11:37 51914 8192000000 10804526576 11239505920 1894332944 18.781 100 29 58 0 1907729296 4955376 8440976
17:12:37 7850 8192000000 10814055840 11245772800 1894764752 18.784 100 24 50 2 1908868080 6408896 7694432
17:12:52 3555 8192000000 10825897824 11252613120 1901718128 18.840 100 42 85 1 1921500976 7797312 11985536
17:13:02 4562 8192000000 10816357120 11249618944 1901116160 18.835 100 32 64 1 1917013024 6724368 9172496
17:13:13 3864 8192000000 10834616192 11255115776 1906872336 18.882 100 41 83 4 1925218640 6034720 12311584
17:13:24 7892 8192000000 10825944704 11261050880 1909931840 18.906 100 36 72 1 1927621680 6947568 10742272
17:13:38 10303 8192000000 10817621648 11257933824 1910943360 18.914 100 23 47 2 1923580144 6213856 6422928
17:13:56 3809 8192000000 10826827264 11261108224 1911011040 18.915 100 28 54 1 1925482032 6422048 8048944
17:14:10 5815 8192000000 10834297040 11264217088 1911661728 18.920 100 23 46 0 1924278720 6059360 6557632
17:14:21 7052 8192000000 10830763632 11265044480 1911745968 18.921 100 16 32 0 1922182272 5384032 5052272
17:14:36 8469 8192000000 10830867024 11258601472 1890452416 18.749 99 26 52 2 1903969920 6564496 6953008
17:14:52 4304 8192000000 10832385488 11266211840 1914123088 18.940 100 29 58 0 1929738112 7015760 8599264
17:15:06 7711 8192000000 10825662144 11263647744 1913590672 18.935 100 21 41 4 1925179824 5658304 5930848
17:15:22 4672 8192000000 10832090016 11255697408 1889819648 18.744 99 22 43 3 1901251328 5528016 5903664
17:15:33 14990 8192000000 10802917200 11233169408 1849348352 18.417 97 14 28 0 1858952816 5775760 3828704
17:15:54 62998 8192000000 10814015920 11253915648 1905095968 18.867 100 31 62 2 1919680624 5173568 9411088
17:17:04 6801 8192000000 10820789936 11260329984 1910590096 18.911 100 22 43 1 1922431520 5206656 6634768
17:17:23 4578 8192000000 10824437952 11257585664 1893156848 18.771 99 26 53 0 1907917616 6759872 8000896
17:17:33 3945 8192000000 10776799456 11209633792 1854398976 18.458 99 38 76 3 1872468240 7407152 10662112
17:17:45 7035 8192000000 10740599408 11161919488 1780599632 17.854 95 25 50 2 1793461968 6047472 6814864
17:18:00 3221 8192000000 10766673552 11187830784 1832319264 18.278 99 46 90 4 1854412704 8531392 13562048
17:18:12 10484 8192000000 10742271152 11154731008 1736499712 17.490 94 21 40 2 1748611728 5764272 6347744
17:18:31 4958 8192000000 10746976768 11169771520 1831764928 18.274 100 33 67 3 1849684496 7822800 10096768
17:18:46 6615 8192000000 10758032256 11174019072 1834553344 18.296 100 27 54 1 1848939376 7200096 7185936
17:19:04 4591 8192000000 10712098864 11127468032 1770205536 17.769 97 19 38 0 1781288992 5425920 5657536
17:19:16 10406 8192000000 10705249136 11117678592 1699740288 17.183 94 20 40 1 1710891360 5190832 5960240
17:19:35 9058 8192000000 10716471728 11127214080 1749720768 17.599 97 34 68 1 1765576720 5289040 10566912
17:19:50 9165 8192000000 10687867536 11107024896 1712841296 17.292 95 23 46 0 1726012240 5489008 7681936
17:20:05 5853 8192000000 10706497712 11124461568 1791431568 17.944 100 30 60 2 1805839344 5104400 9303376
17:20:18 51212 8192000000 10684515200 11095822336 1718381344 17.339 96 28 56 1 1732127472 5786320 7959808
17:21:19 11378 8192000000 10717870384 11135131648 1796068848 17.982 100 24 47 2 1808370480 5538224 6763408
17:21:36 11579 8192000000 10721734192 11145924608 1790544928 17.936 99 11 22 0 1798910640 5409440 2956272
17:21:54 6008 8192000000 10733834176 11147358208 1801329904 18.025 99 45 90 2 1822099344 6842256 13927184
17:22:08 6097 8192000000 10711771488 11130400768 1799267744 18.008 99 32 64 0 1815214960 6491360 9455856
17:22:23 6651 8192000000 10718423568 11124862976 1780566400 17.854 98 34 68 0 1796678016 6025264 10086352
17:22:37 5399 8192000000 10746298176 11158503424 1821037392 18.186 100 33 66 3 1840080176 9316544 9726240
17:22:48 9279 8192000000 10728855552 11157069824 1805908896 18.062 99 21 42 1 1816926192 5588288 5429008
17:23:04 5512 8192000000 10741837184 11162787840 1826057984 18.227 100 27 54 4 1839996912 5972880 7966048
17:23:18 8400 8192000000 10747526864 11168161792 1832357600 18.279 100 30 58 4 1846406816 5197264 8851952
17:23:33 6556 8192000000 10766115456 11181182976 1837835152 18.323 100 28 55 0 1851603024 6117376 7650496
17:23:48 11177 8192000000 10759699584 11185766400 1847236240 18.400 100 17 34 2 1857144048 5054688 4853120
17:24:06 5716 8192000000 10765935552 11189927936 1849570192 18.419 100 37 74 0 1867310736 6621600 11118944
17:24:19 6264 8192000000 10774300176 11192999936 1849516816 18.418 100 25 50 0 1863204560 5157328 8530416
17:24:32 19204 8192000000 10761859840 11192074240 1849235760 18.416 100 14 28 1 1858607904 5351968 4020176
17:24:57 7842 8192000000 10761667616 11189305344 1834035968 18.292 99 18 36 2 1844770624 5602816 5131840
17:25:14 63289 8192000000 10789489200 11203665920 1854915696 18.462 100 32 64 3 1869592976 5647568 9029712
17:26:36 2826 8192000000 10805774432 11206717440 1870888928 18.591 100 73 148 4 1898108352 6624336 20595088
17:26:45 4316 8192000000 10774132656 11206926336 1862508384 18.524 100 23 45 2 1875834752 7263248 6063120
17:26:56 13623 8192000000 10807456032 11219681280 1880071888 18.666 100 37 70 3 1895907440 3845552 11990000
17:27:20 26351 8192000000 10823606720 11243544576 1894050256 18.778 100 46 90 3 1913591440 7259488 12281696
17:27:53 3983 8192000000 10846528352 11256233984 1907203952 18.884 100 60 119 2 1933828048 10151664 16472432
17:28:05 5681 8192000000 10851982384 11263463424 1914805984 18.945 100 66 132 0 1943456384 10589728 18060672
17:28:18 8310 8192000000 10852440112 11263574016 1908286736 18.893 100 55 108 1 1933313984 10197184 14830064
17:28:35 3177 8192000000 10860729424 11272982528 1917797040 18.969 100 60 120 1 1946777792 11481248 17499504
17:28:48 9789 8192000000 10869419248 11283345408 1921606400 19.000 100 69 137 0 1952166544 11393440 19166704
17:29:05 15152 8192000000 10869051552 11287646208 1927477392 19.047 100 57 113 0 1957106512 13501712 16127408
17:29:39 16331 8192000000 10866712080 11290779648 1931299696 19.077 100 48 96 3 1958272176 13122912 13849568
17:30:26 6029 8192000000 10867518784 11295510528 1938335456 19.133 100 44 85 2 1962299792 11439600 12524736
17:30:41 38301 8192000000 10876265664 11312041984 1945332464 19.189 100 60 120 0 1975616800 13330896 16953440
17:31:35 23821 8192000000 10887182928 11322953728 1949248160 19.220 100 39 78 0 1977182832 16711952 11222720
17:32:11 31406 8192000000 10886565344 11331297280 1960393280 19.309 100 24 48 1 1984424048 16359664 7671104
17:32:52 13392 8192000000 10913723440 11340746752 1967948896 19.369 100 49 98 3 1998013920 14952416 15112608
17:33:13 12385 8192000000 10904872736 11339616256 1970046544 19.386 100 44 88 1 1999711904 15967984 13697376
17:33:32 4750 8192000000 10910391680 11330170880 1950768336 19.233 99 59 118 2 1984553296 17233600 16551360
17:33:46 8368 8192000000 10922991984 11340460032 1969447888 19.381 100 65 129 2 2006654080 18954800 18251392
17:34:03 3662 8192000000 10914717840 11334397952 1951398864 19.238 99 74 148 1 1992315760 19796688 21120208
17:34:15 4088 8192000000 10920428928 11341156352 1969700592 19.383 100 64 128 1 2008197392 20113888 18382912
17:34:26 15200 8192000000 10925872704 11349803008 1974998208 19.425 100 69 135 0 2014500304 20261824 19240272
17:34:50 4831 8192000000 10935653200 11356606464 1975387568 19.428 100 56 108 1 2012867168 22340912 15138688
17:35:06 4694 8192000000 10931890128 11356958720 1979461184 19.460 100 66 130 1 2020500560 22449952 18589424
17:35:19 5160 8192000000 10935852576 11358969856 1980899344 19.472 100 59 118 0 2020158240 21960016 17298880
17:35:33 12199 8192000000 10928990768 11355115520 1977371664 19.444 100 64 128 0 2018396816 21792768 19232384
17:35:53 2218 8192000000 10925978928 11356000256 1978280064 19.451 100 48 96 0 2015541504 21987504 15273936
17:36:05 3489 8192000000 10944711200 11368583168 1984946048 19.504 100 61 121 0 2027828544 25093680 17788816
17:36:17 7655 8192000000 10926152544 11356573696 1962200256 19.324 99 58 114 0 2005403568 26087056 17116256
17:36:35 1433 8192000000 10940995632 11366387712 1981085456 19.473 100 60 120 2 2026754320 26813680 18855184
17:36:44 4541 8192000000 10945935808 11369385984 1984035760 19.497 100 66 131 1 2030524608 27608240 18880608
17:36:58 12833 8192000000 10953156528 11379027968 1990267920 19.546 100 57 114 2 2034809216 27218096 17323200
17:37:19 8803 8192000000 10944693808 11366244352 1969514736 19.382 99 60 120 2 2017141760 29530800 18096224
17:37:37 3136 8192000000 10936878880 11358797824 1964104864 19.339 99 79 156 4 2017563216 30431728 23026624
17:37:47 5859 8192000000 10941368288 11359014912 1961548064 19.318 99 76 150 2 2015011712 30989376 22474272
17:38:00 16525 8192000000 10940757648 11365797888 1981008256 19.473 100 67 133 1 2033353184 33146400 19198528
17:38:24 3120 8192000000 10950913856 11359113216 1970896336 19.393 100 73 145 1 2028567760 36095632 21575792
17:38:34 5908 8192000000 10944510128 11368837120 1975683968 19.431 100 73 146 2 2034100928 36296320 22120640
17:38:48 7896 8192000000 10958208000 11379945472 1987747680 19.526 100 72 142 1 2046055056 36978528 21328848
17:39:05 4145 8192000000 10950485920 11372879872 1979011904 19.457 100 68 134 1 2032636672 33457184 20167584
17:39:21 12918 8192000000 10922698336 11352358912 1952849360 19.249 99 57 114 1 2002517472 32578512 17089600
17:39:46 10339 8192000000 10924018032 11354791936 1954058896 19.259 99 52 102 3 2003452256 34477216 14916144
17:40:04 1736 8192000000 10934832112 11341737984 1953337168 19.253 100 79 154 1 2011743568 34393056 24013344
17:40:12 2240 8192000000 10937068512 11350294528 1962508688 19.326 100 91 183 0 2027477216 36728624 28239904
17:40:24 4501 8192000000 10928062672 11334742016 1933851536 19.098 99 90 181 2 1999496384 38014096 27630752
17:40:37 3130 8192000000 10938618688 11341709312 1954959184 19.266 100 85 170 1 2017301616 36932528 25409904
17:40:47 1668 8192000000 10913134096 11319169024 1933179344 19.092 99 92 184 2 1998099920 37505824 27414752
17:40:58 9290 8192000000 10920898224 11339374592 1953931856 19.258 100 67 132 3 2006469888 32787280 19750752
17:41:16 3833 8192000000 10928548400 11347243008 1960890384 19.313 100 68 135 1 2012817792 31405072 20522336
17:41:27 2869 8192000000 10939633168 11359490048 1969340288 19.380 100 63 126 1 2022390384 33893328 19156768
17:41:39 1554 8192000000 10959661408 11366883328 1974105200 19.418 100 81 161 2 2033381104 35598736 23677168
17:41:47 5990 8192000000 10926926528 11337179136 1936840160 19.122 99 89 176 0 1998844224 35867616 26136448
17:42:04 3272 8192000000 10947207888 11359825920 1968778816 19.376 100 81 161 1 2031164944 37747056 24639072
17:42:14 10286 8192000000 10934030992 11355533312 1941233936 19.157 99 63 125 0 1999562496 38685392 19643168
17:42:31 3484 8192000000 10927643888 11357401088 1958711120 19.296 100 57 113 0 2016032096 40235840 17085136
17:42:44 2177 8192000000 10933154480 11341418496 1939503824 19.143 99 94 188 0 2009544208 40260240 29780144
17:42:54 9129 8192000000 10926371040 11347648512 1951913136 19.242 100 72 144 2 2014117040 40068320 22135584
17:43:10 2533 8192000000 10928907760 11339878400 1934383424 19.102 99 86 172 2 2001832592 40964512 26484656
17:43:21 3352 8192000000 10910844320 11317170176 1916559152 18.959 99 79 159 1 1983419280 42472688 24387440
17:43:32 2749 8192000000 10915382400 11331121152 1936307744 19.117 100 73 146 1 2002637328 43346880 22982704
17:43:43 2399 8192000000 10933009312 11345854464 1934943664 19.106 99 82 164 2 2005007248 43771424 26292160
17:43:53 2051 8192000000 10927319504 11344367616 1950367152 19.229 100 75 150 1 2015963152 41744160 23851840
17:44:07 3780 8192000000 10915054048 11325788160 1918758848 18.977 99 74 150 0 1982266048 41010352 22496848
17:44:20 4025 8192000000 10907786704 11325870080 1928712800 19.057 100 66 132 2 1989478336 39961760 20803776
17:44:31 5887 8192000000 10912525200 11328749568 1933429280 19.094 100 69 134 1 1992868464 38623328 20815856
17:44:48 2650 8192000000 10904806544 11311255552 1909133088 18.900 99 83 164 1 1973898768 39360192 25405488
17:44:59 2495 8192000000 10905992624 11316531200 1922163296 19.004 100 78 156 5 1986648800 40509136 23976368
17:45:11 5434 8192000000 10906965328 11325284352 1919090048 18.980 99 66 132 0 1978669184 39063888 20515248
17:45:27 3335 8192000000 10912149136 11320778752 1929043024 19.059 100 78 155 1 1990242848 37774528 23425296
17:45:37 4220 8192000000 10911513728 11317334016 1912326304 18.925 99 87 174 0 1979780928 40009248 27445376
17:45:48 3674 8192000000 10924043856 11329142784 1935040496 19.107 100 87 174 1 2004460064 41831440 27588128
17:46:05 2464 8192000000 10936819808 11337383936 1939707840 19.144 100 87 174 0 2009436336 43082752 26645744
17:46:14 8071 8192000000 10917675632 11337281536 1933936976 19.098 100 59 116 0 1997583232 44950464 18695792
17:46:34 8957 8192000000 10910666016 11333079040 1930799824 19.073 100 48 98 0 1989809008 43178992 15830192
17:46:56 3234 8192000000 10910740160 11335991296 1939516144 19.143 100 53 105 1 2001410480 44544176 17350160
17:47:06 1800 8192000000 10926473696 11342135296 1940472832 19.151 100 71 142 2 2007760864 45631776 21656256
17:47:15 2432 8192000000 10950245488 11354378240 1946381232 19.198 100 71 143 2 2016259888 47645648 22233008
17:47:32 1500 8192000000 10962162576 11370090496 1962948272 19.329 100 91 180 1 2037312112 47270928 27092912
17:47:41 1499 8192000000 10965636992 11373969408 1967283424 19.364 100 94 185 2 2043480160 48332608 27864128
17:47:50 1895 8192000000 10962829600 11374440448 1964189168 19.339 100 87 173 1 2041926400 51027536 26709696
17:48:02 2572 8192000000 10946768480 11370766336 1965737168 19.352 100 65 130 1 2031635216 45377920 20520128
17:48:13 6264 8192000000 10914387680 11326402560 1925762768 19.033 98 68 135 3 1987914384 40088240 22063376
17:48:26 8468 8192000000 10927116080 11349438464 1947046976 19.203 100 55 110 1 2009151920 44269696 17835248
17:48:42 10950 8192000000 10917748272 11352465408 1932878896 19.090 99 49 98 0 1995099744 46351600 15869248
17:49:02 14718 8192000000 10924292128 11359916032 1944280752 19.181 100 34 67 3 2003749632 47906176 11562704
17:49:23 8659 8192000000 10919586720 11359555584 1933753984 19.097 99 41 82 1 1994876496 47480992 13641520
17:49:39 6915 8192000000 10926079024 11357511680 1931014192 19.075 99 44 88 1 1994671824 48799984 14857648
17:49:56 9019 8192000000 10924780224 11356651520 1945857392 19.193 100 62 122 1 2017122208 50569136 20695680
17:50:11 13665 8192000000 10915579840 11357454336 1921911024 19.002 99 37 74 2 1983801264 49057424 12832816
17:50:32 16763 8192000000 10934506864 11370913792 1944827808 19.185 100 32 64 1 2004200304 48411648 10960848
17:50:55 20188 8192000000 10935393024 11380707328 1953696448 19.256 100 32 64 1 2017708624 52878000 11134176
17:51:25 13094 8192000000 10924993120 11374047232 1952309152 19.245 100 28 57 2 2015264544 53398832 9556560
17:51:50 12326 8192000000 10931549872 11373420544 1958265424 19.292 100 30 60 2 2014697120 46120496 10311200
17:52:15 14594 8192000000 10941087104 11385864192 1957960192 19.290 100 31 62 2 2015853376 47063200 10829984
17:52:39 12342 8192000000 10922095920 11367219200 1915181664 18.948 98 35 70 0 1978204864 50425296 12597904
17:52:58 26992 8192000000 10915261392 11364552704 1940908576 19.154 100 33 65 0 2011575264 58789888 11876800
17:53:40 19434 8192000000 10918376432 11367575552 1948041760 19.211 100 21 42 0 1995357952 40041008 7275184
17:54:09 24964 8192000000 10912437328 11362017280 1950566880 19.231 100 30 60 1 1996469472 35055504 10847088
17:54:51 10996 8192000000 10932646480 11378262016 1963368992 19.333 100 34 69 0 2015497632 40682080 11446560
17:55:09 9085 8192000000 10926898528 11382525952 1963666288 19.335 100 31 62 0 2017812304 42973024 11172992
17:55:36 20438 8192000000 10932443680 11389186048 1961694048 19.320 100 20 40 0 2006165168 37174848 7296272
17:56:08 46424 8192000000 10907370992 11387904000 1955235856 19.268 100 12 24 1 1992773296 33188384 4349056
17:57:04 50870 8192000000 10922547184 11372527616 1963159696 19.331 100 8 16 0 1983257760 18103520 1994544
17:58:02 101137 8192000000 10902291680 11363508224 1942410416 19.166 98 19 38 0 1960893424 13627520 4855488
17:59:50 29483 8192000000 10910285392 11372539904 1956374048 19.277 99 14 28 2 1975950704 15885744 3690912
18:00:26 83432 8192000000 10936319072 11377729536 1939579888 19.143 98 21 42 1 1962263008 15648736 7034384
18:01:56 57645 8192000000 10913724000 11385417728 1983063888 19.489 100 11 22 0 2004297200 18240144 2993168
18:03:05 88954 8192000000 10928370208 11403497472 1981847616 19.479 100 5 10 0 2001283008 18340112 1095280
18:04:40 91558 8192000000 10912388912 11365978112 1914348992 18.942 96 28 57 1 1929090560 7425616 7315952
18:06:33 51083 8192000000 10902965376 11365253120 1984078176 19.497 100 49 98 1 2006465536 8117696 14269664
18:07:52 71753 8192000000 10929488240 11383840768 1977223392 19.443 100 21 42 0 1994669648 11886272 5559984
18:09:10 75004 8192000000 10944961312 11389149184 1973901616 19.416 99 49 96 2 2005707936 17686048 14120272
18:10:39 70420 8192000000 10918708736 11386589184 1966560816 19.358 99 21 42 2 1981360432 8366880 6432736
18:11:56 49504 8192000000 10892035968 11355377664 1952245440 19.244 98 18 36 0 1968207920 9549344 6413136
18:12:52 15296 8192000000 10909284016 11374223360 1981250656 19.475 100 28 54 4 2000164576 10954032 7959888
18:13:17 9767 8192000000 10921872640 11375665152 1979401872 19.460 100 16 32 0 1995725040 11661552 4661616
18:13:37 32324 8192000000 10918888352 11391614976 1987377104 19.523 100 14 28 2 2006052848 14485824 4189920
18:14:20 45092 8192000000 10924627232 11377516544 1969065904 19.378 99 26 52 1 1999315456 22332848 7916704
18:15:11 36979 8192000000 10936694384 11374419968 1933219984 19.093 97 65 130 2 1971383968 18598080 19565904
18:15:56 49971 8192000000 10894572512 11384705024 1964656208 19.343 100 22 44 1 1999577536 28398144 6523184
18:16:55 32702 8192000000 10899328672 11394260992 1965434336 19.349 100 11 22 0 1991830336 23395680 3000320
18:17:40 145598 8192000000 10869500432 11358588928 1888626528 18.735 96 5 10 0 1904625616 14578272 1420816
18:20:15 24442 8192000000 10872344976 11358871552 1952028656 19.243 100 5 10 0 1968263552 14826096 1408800
18:20:47 60954 8192000000 10869487456 11339612160 1904905776 18.866 97 19 38 0 1916808400 6724800 5177824
18:21:55 49730 8192000000 10881167632 11351711744 1912922336 18.930 98 6 12 0 1921074736 6522928 1629472
18:22:54 65625 8192000000 10872953600 11363663872 1943368160 19.174 99 12 24 0 1961998592 14977840 3652592
18:25:10 29466 8192000000 10855063664 11336327168 1890252096 18.748 97 6 12 0 1899604704 7486896 1865712
18:25:59 55788 8192000000 10879406288 11367137280 1959368768 19.301 100 12 24 0 1973761904 10993120 3400016
18:27:03 67095 8192000000 10871751328 11337121792 1878079360 18.650 95 19 38 0 1892429024 9304656 5045008
18:29:01 73996 8192000000 10848822256 11315511296 1792870688 17.955 92 9 18 0 1801953632 7035328 2047616
18:30:24 38924 8192000000 10855815680 11322089472 1894831872 18.785 98 11 22 0 1905559792 8178352 2549568
18:31:18 25183 8192000000 10862028720 11317350400 1860561360 18.508 96 30 60 0 1882806544 14506688 7738496
18:31:50 37037 8192000000 10858650192 11326525440 1893241376 18.772 98 31 62 3 1913575040 11490800 8842864
18:32:33 58563 8192000000 10873191728 11340398592 1888477040 18.734 97 31 62 1 1911971696 14526320 8968336
18:34:46 65335 8192000000 10867930848 11323699200 1881864784 18.680 97 16 32 1 1898095632 12044368 4186480
18:35:58 72030 8192000000 10883637840 11329691648 1829142320 18.252 94 21 42 1 1847960336 13005712 5812304
18:37:16 69258 8192000000 10874521456 11344187392 1916898000 18.962 99 24 48 2 1949472096 25668480 6905616
18:38:36 81851 8192000000 10881514832 11326672896 1832784784 18.282 95 11 22 0 1857125200 20648608 3691808
18:40:06 64259 8192000000 10877818720 11348480000 1945764576 19.193 100 32 64 1 1967870528 13362448 8743504
18:41:33 71892 8192000000 10857874864 11329998848 1876723120 18.639 96 30 60 1 1893744720 7629264 9392336
18:42:58 84534 8192000000 10872430720 11347902464 1929476064 19.063 99 29 58 1 1953917936 16543216 7898656
18:44:33 47924 8192000000 10890352336 11353133056 1932762832 19.089 99 23 45 0 1959820960 20947168 6110960
18:45:45 81285 8192000000 10886329888 11363237888 1955306704 19.269 100 13 26 1 1975418016 16500016 3611296
18:47:47 105270 8192000000 10884845856 11357962240 1934305600 19.101 98 13 26 0 1955401632 17019664 4076368
18:49:41 62005 8192000000 10864347616 11350769664 1924060992 19.019 98 22 44 1 1945911296 14818432 7031872
18:51:03 46114 8192000000 10879024384 11351506944 1943195360 19.172 99 33 66 0 1960363216 7475216 9692640
18:51:55 96139 8192000000 10890662256 11373846528 1972204288 19.403 100 15 30 1 1990670368 14114112 4351968
18:53:52 43480 8192000000 10876666144 11359027200 1962407168 19.325 100 9 18 1 1975761184 11198448 2155568
18:54:42 65390 8192000000 10877081520 11360829440 1933383968 19.094 98 15 30 2 1945779376 8685312 3710096
18:55:59 21141 8192000000 10899678512 11362787328 1952840208 19.249 99 34 71 0 1971210320 8951296 9418816
18:56:28 39511 8192000000 10907704240 11377635328 1976668032 19.438 100 27 54 1 1995981264 11921824 7391408
18:57:33 45300 8192000000 10926885152 11410780160 1992688640 19.565 100 19 38 1 2021309904 23777376 4843888
18:58:28 33559 8192000000 10915162528 11386474496 1952187264 19.244 98 13 26 0 1966250032 10648752 3414016
18:59:08 87390 8192000000 10900550320 11376300032 1962470736 19.326 99 16 32 0 1980265808 13266576 4528496
19:00:49 40479 8192000000 10912238288 11392589824 1983199152 19.490 100 10 20 0 2000010560 13913008 2898400
19:01:36 25825 8192000000 10925463840 11397906432 1995667760 19.589 100 23 44 3 2009264560 7282944 6313856
19:02:08 60394 8192000000 10909523776 11379544064 1898042304 18.811 95 17 34 1 1910386592 7992112 4352176
19:03:14 37506 8192000000 10919500208 11377819648 1953097216 19.251 98 35 70 2 1974751744 11992464 9662064
19:03:58 48657 8192000000 10933946544 11399380992 1980159184 19.466 99 30 60 1 1999306160 10894480 8252496
19:04:56 41637 8192000000 10952386192 11419947008 2000107536 19.624 100 41 82 0 2029966752 18820576 11038640
19:05:50 67767 8192000000 10908412224 11386249216 1918879072 18.978 96 9 18 2 1935002816 13903808 2219936
19:07:04 63272 8192000000 10904267728 11379367936 1928586144 19.056 97 23 45 1 1945033376 10309920 6137312
19:08:14 109278 8192000000 10893109360 11379724288 1846887024 18.397 93 4 8 0 1859555200 11588528 1079648
19:10:09 102314 8192000000 10893056512 11366293504 1927612896 19.048 98 17 34 0 1943174928 10281440 5280592
19:12:00 90428 8192000000 10896380912 11386658816 1951207744 19.236 99 13 26 0 1972373024 17768432 3396848
19:13:37 45674 8192000000 10895924336 11375677440 1974104144 19.418 100 23 46 1 1992891424 11709568 7077712
19:14:29 80047 8192000000 10854984352 11344605184 1836409296 18.312 93 10 20 0 1853546320 14387312 2749712
19:15:55 62388 8192000000 10872282048 11350429696 1927212048 19.045 99 7 14 1 1940621232 11306080 2103104
19:17:04 58186 8192000000 10858508288 11342553088 1910935104 18.914 98 15 30 1 1923129616 7568608 4625904
19:18:13 62355 8192000000 10857306704 11339841536 1895276608 18.788 97 6 11 1 1905191152 8502096 1412448
19:19:21 60250 8192000000 10858899120 11336273920 1870538000 18.589 96 10 20 0 1883640608 10500800 2601808
19:20:35 29262 8192000000 10849980352 11327336448 1881658528 18.678 97 17 34 0 1897896496 11488848 4749120
19:21:13 49090 8192000000 10852624928 11338256384 1896354896 18.797 98 17 33 3 1913605136 12778688 4471552
19:22:09 47418 8192000000 10854902960 11337383936 1898498928 18.814 98 12 24 0 1916049632 14468032 3082672
19:23:03 50469 8192000000 10847753920 11302518784 1814842592 18.136 94 11 22 1 1830444384 12581680 3020112
19:24:01 36518 8192000000 10832090704 11291516928 1810196752 18.097 94 37 74 0 1830235168 9463008 10575408
19:24:44 45260 8192000000 10843134656 11312291840 1910939872 18.914 100 31 62 0 1933741296 14278016 8523408
19:25:36 26308 8192000000 10864893056 11326017536 1907518880 18.887 99 27 54 2 1930239632 15288416 7432336
19:26:13 62857 8192000000 9237270384 9756020736 240953968 2.857 13 5 10 0 245721184 3785184 982032

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 30-12-2020 19:28:23 to 30-12-2020 19:28:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 102 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 30-12-2020 19:28:57 to 30-12-2020 19:28:59.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          249493
MON$OLDEST_ACTIVE               249494
MON$OLDEST_SNAPSHOT             249494
MON$NEXT_TRANSACTION            249494
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                       2059488
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 ---
:127: 
:128: mscs-test-161.budzdorov.ru    Wed Dec 30 19:27:19 2020
:129:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:130: 
--- end of diff output ---

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

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