Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.12.2020 16: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 17326224 kB
MemAvailable 31444152 kB
Buffers 0 kB
Cached 14333532 kB
SwapCached 3700 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-24 16:27:07
DTS_END                         2020-12-24 16:27:07.4600
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/36706
TRN_ID                          256082
ATT_ID                          735
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: 9543.86 21307 1145263
customer order: creation 185.05 337 22206
customer order: refuse 16.16 286 1939
order to supplier: creation 49.69 1186 5963
order to supplier: removal 3.45 90215 414
invoice (draft): creation 48.98 3034 5877
invoice (draft): removal 52.34 754 6281
invoice accept: apply 45.29 15128 5435
invoice accept: cancel 46.99 793 5639
customer reserve: creation 4167.11 150 500053
customer reserve: removal 4622.73 53 554728
realization accept: apply 91.66 163 10999
realization accept: cancel 75.58 101 9070
payment from customer: creation 63.48 110 7618
payment from customer: removal 6.04 72 725
payment to supplier: creation 52.37 109 6284
payment to supplier: removal 3.73 77 448
service: total inventory turnovers 5.26 1008 631
service: total monetary turnovers 6.99 32 839
service: aggregate perf. data 0.92 20580 110
service: refresh index statistics 0.03 291948 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-12-2020 16:28:12 to 24-12-2020 16:28:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7722
TEST_TIME 2 6685
TEST_TIME 3 5234
TEST_TIME 4 5656
TEST_TIME 5 6145
TEST_TIME 6 6906
TEST_TIME 7 7623
TEST_TIME 8 7942
TEST_TIME 9 8347
TEST_TIME 10 8716
TEST_TIME 11 8669
TEST_TIME 12 8622
TEST_TIME 13 9157
TEST_TIME 14 9102
TEST_TIME 15 9292
TEST_TIME 16 9716
TEST_TIME 17 10574
TEST_TIME 18 10495
TEST_TIME 19 10665
TEST_TIME 20 10282
TEST_TIME 21 9963
TEST_TIME 22 10352
TEST_TIME 23 10393
TEST_TIME 24 11774
TEST_TIME 25 12059
TEST_TIME 26 11719
TEST_TIME 27 11696
TEST_TIME 28 11576
TEST_TIME 29 11690
TEST_TIME 30 11557
TEST_TIME 31 11419
TEST_TIME 32 11343
TEST_TIME 33 11313
TEST_TIME 34 11192
TEST_TIME 35 11035
TEST_TIME 36 10972
TEST_TIME 37 10837
TEST_TIME 38 10750
TEST_TIME 39 10676
TEST_TIME 40 10646
TEST_TIME 41 10688
TEST_TIME 42 10671
TEST_TIME 43 10517
TEST_TIME 44 10546
TEST_TIME 45 10420
TEST_TIME 46 10364
TEST_TIME 47 10254
TEST_TIME 48 10277
TEST_TIME 49 10337
TEST_TIME 50 10270
TEST_TIME 51 10247
TEST_TIME 52 10361
TEST_TIME 53 10288
TEST_TIME 54 10353
TEST_TIME 55 10300
TEST_TIME 56 10337
TEST_TIME 57 10312
TEST_TIME 58 10399
TEST_TIME 59 10384
TEST_TIME 60 10451
TEST_TIME 61 10390
TEST_TIME 62 10276
TEST_TIME 63 10223
TEST_TIME 64 10164
TEST_TIME 65 10176
TEST_TIME 66 10090
TEST_TIME 67 10047
TEST_TIME 68 9970
TEST_TIME 69 9895
TEST_TIME 70 9899
TEST_TIME 71 9931
TEST_TIME 72 10015
TEST_TIME 73 9969
TEST_TIME 74 9960
TEST_TIME 75 9992
TEST_TIME 76 10001
TEST_TIME 77 10056
TEST_TIME 78 10035
TEST_TIME 79 10101
TEST_TIME 80 10085
TEST_TIME 81 10116
TEST_TIME 82 10014
TEST_TIME 83 9921
TEST_TIME 84 9898
TEST_TIME 85 9895
TEST_TIME 86 9877
TEST_TIME 87 9837
TEST_TIME 88 9802
TEST_TIME 89 9783
TEST_TIME 90 9777
TEST_TIME 91 9688
TEST_TIME 92 9708
TEST_TIME 93 9690
TEST_TIME 94 9703
TEST_TIME 95 9688
TEST_TIME 96 9703
TEST_TIME 97 9750
TEST_TIME 98 9695
TEST_TIME 99 9773
TEST_TIME 100 9750
TEST_TIME 101 9745
TEST_TIME 102 9755
TEST_TIME 103 9797
TEST_TIME 104 9826
TEST_TIME 105 9873
TEST_TIME 106 9871
TEST_TIME 107 9786
TEST_TIME 108 9765
TEST_TIME 109 9746
TEST_TIME 110 9698
TEST_TIME 111 9701
TEST_TIME 112 9668
TEST_TIME 113 9642
TEST_TIME 114 9594
TEST_TIME 115 9583
TEST_TIME 116 9642
TEST_TIME 117 9628
TEST_TIME 118 9604
TEST_TIME 119 9621
TEST_TIME 120 9548

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 24-12-2020 16:28:15 to 24-12-2020 16:28:19.

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 1606335 1606335 0 0.00 0 15336 6 0 0
doc_list_biud 1606332 1606332 0 0.00 0 34884 24 0 0
sp_add_invoice_to_stock 5554 5435 119 2.14 38 163952 15129 0 119
sp_cancel_adding_invoice 5639 5639 0 0.00 4 58131 793 0 0
sp_cancel_client_order 1939 1939 0 0.00 4 11546 287 0 0
sp_cancel_customer_reserve 554728 554728 0 0.00 1 34885 54 0 0
sp_cancel_pay_from_customer 725 725 0 0.00 2 7820 72 0 0
sp_cancel_pay_to_supplier 448 448 0 0.00 3 10156 78 0 0
sp_cancel_supplier_invoice 6296 6281 15 0.23 2 21906 755 0 15
sp_cancel_supplier_order 414 414 0 0.00 8 843325 90215 0 0
sp_cancel_write_off 9070 9070 0 0.00 1 12010 101 0 0
sp_client_order 22206 22206 0 0.00 3 38491 338 0 0
sp_customer_reserve 500053 500053 0 0.00 0 45628 150 0 0
sp_fill_shopping_cart 34044 34044 0 0.00 1 15239 38 0 0
sp_fill_shopping_cart_clo_res 500046 500046 0 0.00 0 12843 12 0 0
sp_get_clo_for_invoice 5428 5428 0 0.00 0 32596 307 0 0
sp_kill_cost_storno 15882 15882 0 0.00 0 8551 47 0 0
sp_kill_qstorno_ret_qs2qd 1125221 1125221 0 0.00 0 34881 29 0 0
sp_kill_qty_storno 594495 594495 0 0.00 0 34884 63 0 0
sp_lock_selected_doc 22672 22672 0 0.00 0 10327 7 0 0
sp_make_cost_storno 30326 30326 0 0.00 0 15333 49 0 0
sp_multiply_rows_for_pdistr 30325 30325 0 0.00 0 7554 25 0 0
sp_multiply_rows_for_qdistr 22206 22206 0 0.00 0 38482 151 0 0
sp_pay_from_customer 7618 7618 0 0.00 4 12413 110 0 0
sp_pay_to_supplier 6284 6284 0 0.00 5 17256 109 0 0
sp_payment_common 13901 13901 0 0.00 1 13490 25 0 0
sp_qd_handle_on_cancel_clo 1939 1939 0 0.00 0 11527 265 0 0
sp_qd_handle_on_invoice_upd_sts 11064 11064 0 0.00 0 25630 298 0 0
sp_qd_handle_on_reserve_upd_sts 10999 10999 0 0.00 0 18313 58 0 0
sp_reserve_write_off 10999 10999 0 0.00 6 18589 163 0 0
sp_supplier_invoice 5877 5877 0 0.00 7 89385 3035 0 0
sp_supplier_order 5963 5963 0 0.00 5 29934 1187 0 0
srv_aggregate_perf_data 111 110 1 0.90 3077 257876 20580 0 1
srv_fill_mon_cache_memory 157 157 0 0.00 1312 153443 33455 0 0
srv_find_qd_qs_mism 1092879 1092879 0 0.00 0 12841 5 0 0
srv_make_invnt_saldo 631 631 0 0.00 44 41273 1008 0 0
srv_make_money_saldo 839 839 0 0.00 1 6802 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 192488 388060 291948 0 0
t$perf-abend:sp_add_invoice_to_stock 119 119 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 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 5435 5435 0 0.00 0 11493 146 0 0
t$perf-norm:sp_cancel_adding_invoice 432 432 0 0.00 0 5229 101 0 0
t$perf-norm:sp_cancel_client_order 1939 1939 0 0.00 0 7745 15 0 0
t$perf-norm:sp_cancel_customer_reserve 745 745 0 0.00 0 7784 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 725 725 0 0.00 0 5211 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 448 448 0 0.00 0 579 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 443 443 0 0.00 0 2448 14 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 15705 1392 0 0
t$perf-norm:sp_cancel_write_off 1102 1102 0 0.00 0 724 8 0 0
t$perf-norm:sp_client_order 22206 22206 0 0.00 0 7788 14 0 0
t$perf-norm:sp_customer_reserve 1059 1059 0 0.00 0 1209 4 0 0
t$perf-norm:sp_pay_from_customer 7618 7618 0 0.00 0 5376 7 0 0
t$perf-norm:sp_pay_to_supplier 6284 6284 0 0.00 0 6897 9 0 0
t$perf-norm:sp_reserve_write_off 10999 10999 0 0.00 0 5203 8 0 0
t$perf-norm:sp_supplier_invoice 5877 5877 0 0.00 0 4789 14 0 0
t$perf-norm:sp_supplier_order 5963 5963 0 0.00 0 8568 17 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 300 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 230 6 0 0
t$perf-norm:srv_make_invnt_saldo 631 631 0 0.00 0 976 17 0 0
t$perf-norm:srv_make_money_saldo 839 839 0 0.00 0 5918 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 11086 10848 238 2.14 0 6938 21 0 238
v_all_customers 40320 40320 0 0.00 0 56 1 0 0
v_all_suppliers 32534 32534 0 0.00 0 18 1 0 0
v_all_wares 44410 44410 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 864 864 0 0.00 0 1599 7 0 0
v_cancel_client_order 3878 3878 0 0.00 0 4116 6 0 0
v_cancel_customer_prepayment 1450 1450 0 0.00 0 4982 10 0 0
v_cancel_customer_reserve 1490 1490 0 0.00 0 532 4 0 0
v_cancel_payment_to_supplier 896 896 0 0.00 0 6296 11 0 0
v_cancel_supplier_invoice 916 886 30 3.27 0 5408 29 0 30
v_cancel_supplier_order 828 828 0 0.00 0 3674 7 0 0
v_cancel_write_off 2204 2204 0 0.00 0 5126 18 0 0
v_max_id_clo_ord 5963 5963 0 0.00 0 3183 2 0 0
v_max_id_clo_res 1059 1059 0 0.00 0 3603 11 0 0
v_max_id_ord_sup 5876 5876 0 0.00 0 3521 3 0 0
v_max_non_paid_invoice 1856 1856 0 0.00 0 4088 5 0 0
v_max_non_paid_realizn 4237 4237 0 0.00 0 5950 5 0 0
v_min_id_clo_ord 5963 5963 0 0.00 0 3614 7 0 0
v_min_id_clo_res 1059 1059 0 0.00 0 2619 9 0 0
v_min_id_ord_sup 5876 5876 0 0.00 0 6610 8 0 0
v_min_non_paid_invoice 6284 6284 0 0.00 0 7306 12 0 0
v_min_non_paid_realizn 7617 7617 0 0.00 0 5577 12 0 0
v_our_firm 10850 10850 0 0.00 0 15 1 0 0
v_reserve_write_off 21998 21998 0 0.00 0 6104 6 0 0
x_lock_depdocs_on_canc_invoice 11477 11477 0 0.00 0 26757 112 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 5397 319 0 0
x_make_qstorno_1000_1200 5963 5963 0 0.00 1 29928 1108 0 0
x_make_qstorno_1200_2000 5877 5877 0 0.00 3 83581 2897 0 0
x_make_qstorno_2100_3300 500053 500053 0 0.00 0 45619 136 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-12-2020 16:28:20 to 24-12-2020 16:28:24.

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:11 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:17 11487 8192000000 10184588640 10485690368 840100272 9.301 68 52 105 0 861113632 2393056 18620304
13:57:36 27385 8192000000 10322976112 10638934016 1365878752 14.290 100 79 158 0 1395435968 4262176 25295040
13:58:13 27066 8192000000 10368266048 10689404928 1430391984 14.865 100 86 172 0 1463665200 6015296 27257920
13:58:52 23951 8192000000 10413901840 10741469184 1468151680 15.198 100 89 178 2 1503767216 7256704 28358832
13:59:28 26138 8192000000 10442160416 10773610496 1494282416 15.426 100 93 184 1 1531878400 8602944 28993040
14:00:10 23109 8192000000 10463023840 10800947200 1519010848 15.642 100 92 184 0 1556923536 9751328 28161360
14:00:50 13794 8192000000 10492203008 10834096128 1551793936 15.925 100 85 170 0 1587866944 10379536 25693472
14:01:12 12400 8192000000 10514641904 10861412352 1569063312 16.074 100 81 163 1 1604257456 11035104 24159040
14:01:32 14304 8192000000 10521208912 10875224064 1582872896 16.193 100 77 154 2 1617327968 10964016 23491056
14:01:56 12898 8192000000 10546238144 10899771392 1602148336 16.358 100 85 169 1 1639079520 11584480 25346704
14:02:19 16710 8192000000 10572183360 10930843648 1626091504 16.562 100 85 170 1 1663508912 11877328 25540080
14:02:44 9873 8192000000 10587116720 10949189632 1646567808 16.735 100 73 146 0 1680272336 12148704 21555824
14:03:02 8497 8192000000 10610061696 10976882688 1664055728 16.883 100 79 158 2 1699442496 12362736 23024032
14:03:17 8624 8192000000 10625719712 10996830208 1691397376 17.113 100 82 164 1 1728758256 12411440 24949440
14:03:33 7674 8192000000 10647299536 11016859648 1706116752 17.236 100 82 163 3 1742456976 12486448 23853776
14:03:50 7556 8192000000 10652937504 11027693568 1719741744 17.350 100 79 158 2 1755014304 12793456 22479104
14:04:05 5138 8192000000 10664756816 11040534528 1729033568 17.427 100 83 165 0 1765206368 12495520 23677280
14:04:17 4825 8192000000 10674961056 11051286528 1738196064 17.504 100 77 154 3 1771845280 12205088 21444128
14:04:30 4526 8192000000 10690272832 11067990016 1756150816 17.653 100 83 166 1 1791843600 12653600 23039184
14:04:42 4127 8192000000 10696033664 11073413120 1762923728 17.709 100 85 168 1 1799800544 13555104 23321712
14:04:53 2950 8192000000 10707821232 11089371136 1769658880 17.764 100 77 152 1 1803219216 12616656 20943680
14:05:02 2311 8192000000 10722445488 11099901952 1778504752 17.837 100 80 160 0 1813730080 12598288 22627040
14:05:10 1577 8192000000 10731783744 11112079360 1790441328 17.935 100 80 161 1 1826369520 11826000 24102192
14:05:18 2783 8192000000 10740881920 11121815552 1801704464 18.028 100 86 171 0 1837820464 12384144 23731856
14:05:27 2866 8192000000 10746948720 11131490304 1810760016 18.102 100 87 174 2 1848692912 13978976 23953920
14:05:37 6314 8192000000 10755134544 11138256896 1810340848 18.099 100 82 164 0 1847070304 14154848 22574608
14:05:50 2729 8192000000 10770551904 11150536704 1816047936 18.145 100 88 175 0 1855664960 14804720 24812304
14:05:59 1556 8192000000 10773430816 11156115456 1832419760 18.279 100 88 176 1 1872088368 15088464 24580144
14:06:08 1781 8192000000 10778137984 11162783744 1833471648 18.288 100 90 178 0 1872287568 14207088 24608832
14:06:16 1189 8192000000 10788709408 11168772096 1836706384 18.314 100 91 180 1 1875328176 14064656 24557136
14:06:23 1643 8192000000 10789700448 11171799040 1843801056 18.372 100 94 189 1 1884721984 14600960 26319968
14:06:31 1551 8192000000 10793198576 11176538112 1843692064 18.371 100 95 190 0 1884552240 14204688 26655488
14:06:39 1466 8192000000 10796229536 11180470272 1849476736 18.418 100 90 181 1 1888501568 13834800 25190032
14:06:46 1171 8192000000 10800065328 11183624192 1850343200 18.425 100 94 189 1 1890426720 13006768 27076752
14:06:54 1659 8192000000 10795758272 11185131520 1853780944 18.453 100 90 180 2 1892533552 12428016 26324592
14:07:02 2257 8192000000 10777042656 11180953600 1851756384 18.436 100 70 139 1 1884238752 12836896 19645472
14:07:11 45565 8192000000 10762083840 11180068864 1845846864 18.388 100 41 82 2 1866677424 8433584 12396976
14:08:03 4677 8192000000 10757217616 11180593152 1854607152 18.460 100 37 76 1 1871746736 5246128 11893456
14:08:14 7769 8192000000 10760144800 11185180672 1853132496 18.448 100 27 54 0 1868156896 7699632 7324768
14:08:28 7934 8192000000 10770184192 11189235712 1857752592 18.485 100 24 48 1 1871160192 6568832 6838768
14:08:45 5604 8192000000 10761860512 11194449920 1860116128 18.504 100 24 48 4 1873859840 6630208 7113504
14:08:58 5243 8192000000 10781128048 11202887680 1864747152 18.542 100 32 65 2 1884571632 10597040 9227440
14:09:09 6479 8192000000 10784432672 11205529600 1868792592 18.575 100 28 56 1 1884275776 7704720 7778464
14:09:22 5452 8192000000 10786368656 11212709888 1872954272 18.608 100 30 60 1 1888048176 6671264 8422640
14:09:34 7242 8192000000 10781563424 11206225920 1872267104 18.603 100 18 36 0 1883692912 5916464 5509344
14:09:47 11557 8192000000 10782543728 11212439552 1875848112 18.632 100 20 40 1 1888451712 6085904 6517696
14:10:07 10319 8192000000 10781365344 11212419072 1876752400 18.639 100 27 54 1 1891659392 7290352 7616640
14:10:23 8147 8192000000 10793554384 11218726912 1882768512 18.687 100 20 41 1 1895299328 6714192 5816624
14:10:37 11225 8192000000 10794631104 11223834624 1884493936 18.701 100 25 50 2 1898043488 6289728 7259824
14:10:56 10385 8192000000 10793888624 11225845760 1886030688 18.714 100 15 30 2 1895929856 6059280 3839888
14:11:14 7421 8192000000 10806517312 11234471936 1891009664 18.754 100 23 47 1 1902699920 5345424 6344832
14:11:31 63038 8192000000 10843129760 11246718976 1900329008 18.829 100 53 106 2 1921764992 6318816 15117168
14:12:41 3831 8192000000 10829126688 11247943680 1900608528 18.831 100 49 98 1 1926091744 11362496 14120720
14:12:51 5360 8192000000 10809632576 11239669760 1898307568 18.813 100 28 57 0 1912205744 5919472 7978704
14:13:03 5810 8192000000 10820008576 11243008000 1901790944 18.841 100 37 75 0 1919476512 6307392 11378176
14:13:16 4382 8192000000 10827914624 11248611328 1902520480 18.847 100 44 88 1 1924036080 9352416 12163184
14:13:29 3141 8192000000 10829893664 11250184192 1903612000 18.855 100 42 84 1 1923555488 8031104 11912384
14:13:40 4383 8192000000 10818254816 11248087040 1904907952 18.866 100 36 72 0 1922942240 7558064 10476224
14:13:51 7693 8192000000 10817330128 11249991680 1904310160 18.861 100 26 52 1 1917005632 5783808 6911664
14:14:05 5607 8192000000 10818668048 11247415296 1898111552 18.811 100 20 40 0 1910414624 6338688 5964384
14:14:19 4115 8192000000 10812169792 11241533440 1898224544 18.812 100 23 46 0 1910595760 5883536 6487680
14:14:29 6935 8192000000 10807266496 11241881600 1895937344 18.794 100 28 56 3 1911430864 7734160 7759360
14:14:42 7531 8192000000 10798277440 11232489472 1876176624 18.634 99 19 38 0 1887438016 5808624 5452768
14:14:56 13776 8192000000 10808790688 11242459136 1900538112 18.831 100 33 66 2 1915291600 5127088 9626400
14:15:39 26810 8192000000 10769374992 11204513792 1817649504 18.158 96 30 60 1 1831505296 5782144 8073648
14:16:16 10639 8192000000 10796838336 11223203840 1851656144 18.436 98 26 51 1 1865259248 5908336 7694768
14:16:34 4075 8192000000 10788088560 11216584704 1859698736 18.501 99 35 68 1 1875877440 6875632 9303072
14:16:45 4384 8192000000 10794673824 11220664320 1875667824 18.630 100 28 56 0 1890550912 6836032 8047056
14:16:56 5132 8192000000 10779358880 11196239872 1856926160 18.478 100 25 50 3 1869431168 6040160 6464848
14:17:08 8180 8192000000 10757295744 11167387648 1777088432 17.825 96 28 56 2 1791576208 5881280 8606496
14:17:23 4714 8192000000 10724433584 11147907072 1789499392 17.928 97 30 58 2 1804265520 6071248 8694880
14:17:35 5447 8192000000 10736462240 11160522752 1826286640 18.229 100 31 62 1 1842377696 6803184 9287872
14:17:49 6699 8192000000 10747381952 11165286400 1812042848 18.113 99 27 54 0 1825381552 6115552 7223152
14:18:03 3662 8192000000 10732633728 11156455424 1823886288 18.209 100 34 67 2 1840089008 6670080 9532640
14:18:13 6829 8192000000 10708943152 11129167872 1783104944 17.875 99 24 49 3 1795696656 5545056 7046656
14:18:26 4099 8192000000 10720565984 11130994688 1761321952 17.695 97 22 45 0 1773187296 5903504 5961840
14:18:37 13935 8192000000 10700200336 11118960640 1729772768 17.434 95 18 36 1 1740592128 5729360 5090000
14:18:57 10080 8192000000 10687004352 11101814784 1722337168 17.372 95 23 46 1 1734121376 5188512 6595696
14:19:14 66511 8192000000 10677118416 11104026624 1640893136 16.687 91 21 41 0 1651608624 4644144 6071344
14:20:26 10901 8192000000 10703835344 11124965376 1764770560 17.724 98 24 48 2 1777114192 5532480 6811152
14:20:46 4980 8192000000 10722069248 11135062016 1800408000 18.017 100 28 56 2 1815360320 7056720 7895600
14:20:58 9462 8192000000 10738589248 11160920064 1807116288 18.072 99 34 68 0 1822838128 6509376 9212464
14:21:13 8690 8192000000 10735766864 11156807680 1807070800 18.072 99 35 68 2 1823653904 6345520 10237584
14:21:30 5097 8192000000 10737756768 11155894272 1811650560 18.109 99 39 78 3 1829616176 6515936 11449680
14:21:41 7813 8192000000 10732577952 11152195584 1791021824 17.940 98 24 48 3 1803809536 5961168 6826544
14:21:56 6197 8192000000 10759692544 11175030784 1832074704 18.276 100 31 62 0 1852456240 11240016 9141520
14:22:11 8088 8192000000 10747234864 11166556160 1817900880 18.161 99 24 48 1 1830509472 6156320 6452272
14:22:25 8068 8192000000 10753761120 11176316928 1837288608 18.319 100 25 50 0 1854583152 9752752 7541792
14:22:40 5604 8192000000 10759221600 11181191168 1844254624 18.375 100 24 49 1 1856380672 4825456 7300592
14:22:53 7745 8192000000 10763020352 11186774016 1845493552 18.385 100 25 50 0 1858348816 5500752 7354512
14:23:07 11279 8192000000 10778355392 11196710912 1853331024 18.449 100 20 41 1 1863944512 5196880 5416608
14:23:27 13816 8192000000 10755976096 11190358016 1851519696 18.434 100 21 42 1 1863115888 5789264 5806928
14:23:47 5403 8192000000 10779044736 11200991232 1860147296 18.504 100 36 72 2 1877332512 6305248 10879968
14:24:06 77869 8192000000 10776575904 11206586368 1864576000 18.540 100 26 52 3 1877865680 5604848 7684832
14:25:34 6915 8192000000 10780553168 11209842688 1867330912 18.563 100 15 30 0 1876817856 5359408 4127536
14:25:47 7559 8192000000 10781804384 11212476416 1871080528 18.593 100 28 56 3 1884710240 5306304 8323408
14:26:01 8070 8192000000 10802565632 11223056384 1875514528 18.629 100 36 71 2 1892384032 6469296 10400208
14:26:20 6716 8192000000 10798729776 11224387584 1878453232 18.653 100 26 53 0 1891223648 5469488 7300928
14:26:33 7689 8192000000 10795498608 11230261248 1882537744 18.686 100 20 42 2 1894731216 6044896 6148576
14:26:48 9026 8192000000 10800881824 11232800768 1881333392 18.676 100 25 50 1 1898439472 9874640 7231440
14:27:09 26044 8192000000 10830473984 11248812032 1903971456 18.858 100 29 59 2 1917656672 5663312 8021904
14:27:49 4926 8192000000 10842076960 11264466944 1917668592 18.968 100 40 81 0 1935354560 7031552 10654416
14:28:01 5868 8192000000 10858846256 11278495744 1929002144 19.059 100 55 111 1 1953120608 8750096 15368368
14:28:14 20421 8192000000 10869579680 11291856896 1940479344 19.151 100 56 112 3 1966662768 10596912 15586512
14:28:49 7515 8192000000 10873052144 11301785600 1946593120 19.199 100 51 98 2 1970434288 9815600 14025568
14:29:09 36420 8192000000 10880789504 11308154880 1944205840 19.180 100 44 85 1 1966095024 9864624 12024560
14:29:56 45181 8192000000 10899335952 11323613184 1957551184 19.287 100 42 84 2 1981648080 11283920 12812976
14:30:59 51795 8192000000 10869247024 11311853568 1941511984 19.159 99 37 74 0 1965860160 13296944 11051232
14:31:58 13034 8192000000 10882147792 11331260416 1954232560 19.260 100 21 42 1 1979783280 19707312 5843408
14:32:20 3830 8192000000 10886965184 11323998208 1939248960 19.141 99 39 78 1 1965901280 14993424 11658896
14:32:31 7233 8192000000 10897744048 11329544192 1956232448 19.276 100 48 96 2 1986310992 15838832 14239712
14:32:48 24046 8192000000 10919885264 11346923520 1971436208 19.397 100 52 104 2 2002484736 15581552 15466976
14:33:26 12557 8192000000 10906801184 11352170496 1973584784 19.414 100 48 96 0 2012289984 24173072 14532128
14:33:49 11489 8192000000 10914180576 11356409856 1974949056 19.425 100 38 76 2 2004523232 17935536 11638640
14:34:12 4005 8192000000 10904182896 11340423168 1951872432 19.241 99 48 94 0 1984259696 17124672 15262592
14:34:23 12304 8192000000 10914952000 11343024128 1951792544 19.241 99 57 114 3 1987770752 18680608 17297600
14:34:43 2291 8192000000 10929990656 11357995008 1979111984 19.458 100 65 129 0 2020949440 22124288 19713168
14:34:57 10032 8192000000 10915220928 11349917696 1957187712 19.284 99 55 111 1 1994771264 21027120 16556432
14:35:17 10371 8192000000 10921157472 11357089792 1985539088 19.509 100 55 109 2 2018086272 16622688 15924496
14:35:37 2644 8192000000 10932583360 11358486528 1983018016 19.489 100 70 140 2 2023657280 18127184 22512080
14:35:47 4201 8192000000 10932000880 11362459648 1985914688 19.511 100 52 104 0 2018889232 17818080 15156464
14:35:59 3194 8192000000 10938273120 11369664512 1987035328 19.520 100 55 108 1 2023762528 21025808 15701392
14:36:11 2818 8192000000 10943803408 11370323968 1976647728 19.438 99 72 145 1 2016834640 18004704 22182208
14:36:21 12583 8192000000 10933434096 11367337984 1972811056 19.408 99 55 109 0 2007318064 18364752 16142256
14:36:42 4770 8192000000 10928182336 11362291712 1975307632 19.428 99 52 102 0 2010903168 20472240 15123296
14:36:53 5599 8192000000 10930513552 11364896768 1969837376 19.384 99 50 98 5 2005023376 20439088 14746912
14:37:07 2132 8192000000 10948982768 11362115584 1986555616 19.517 100 74 147 2 2031348224 21972576 22820032
14:37:15 1311 8192000000 10932346064 11347857408 1949708496 19.224 98 88 177 1 1998234912 22320016 26206400
14:37:23 4302 8192000000 10951521056 11373080576 1988980896 19.536 100 80 161 0 2037342320 23952064 24409360
14:37:34 6203 8192000000 10951648256 11361861632 1980702384 19.470 99 85 170 1 2027478528 22691776 24084368
14:37:47 4188 8192000000 10960362672 11383402496 2000012240 19.623 100 87 171 1 2049446080 24283888 25149952
14:37:58 2478 8192000000 10944114960 11360321536 1966859920 19.361 99 81 158 2 2017806912 27666704 23280288
14:38:08 2119 8192000000 10946499552 11366084608 1983695808 19.494 100 78 156 2 2030093776 23859680 22538288
14:38:19 2991 8192000000 10949844240 11373727744 1987481888 19.524 100 74 150 1 2034526864 24580832 22464144
14:38:30 7271 8192000000 10944796432 11372003328 1987299600 19.522 100 65 130 1 2032731888 26272656 19159632
14:38:45 2365 8192000000 10962704624 11381485568 1979332880 19.459 99 79 154 2 2030985488 28886416 22766192
14:38:54 1851 8192000000 10975562688 11390910464 2003343136 19.649 100 86 168 0 2057818496 29603408 24871952
14:39:03 1589 8192000000 10955070288 11365392384 1967079360 19.362 99 82 162 2 2020591136 30221424 23290352
14:39:11 1538 8192000000 10962939232 11383394304 1989943072 19.543 100 88 176 2 2047838352 31532736 26362544
14:39:19 11555 8192000000 10946679760 11369852928 1978256096 19.451 100 78 156 2 2035140192 33104960 23779136
14:39:41 1595 8192000000 10941650048 11365548032 1955821312 19.273 99 73 146 0 2015101680 36956496 22323872
14:39:50 9054 8192000000 10936689824 11365916672 1956960672 19.282 99 69 136 1 2013609872 35501664 21147536
14:40:05 3970 8192000000 10953836304 11376943104 1981055872 19.473 100 76 150 1 2041099360 36871824 23171664
14:40:16 2919 8192000000 10968214976 11381293056 1986725632 19.518 100 82 163 2 2046649824 34958816 24965376
14:40:26 2695 8192000000 10941364272 11359248384 1953465488 19.254 98 75 150 0 2013032976 36529648 23037840
14:40:39 1957 8192000000 10940489200 11363905536 1962757184 19.328 99 74 146 3 2024482912 39237456 22488272
14:40:48 3479 8192000000 10951247824 11378708480 1979720880 19.462 100 66 132 1 2036883616 37273776 19888960
14:41:01 4722 8192000000 10932877168 11356016640 1958174144 19.292 99 66 131 1 2015444176 37304592 19965440
14:41:14 3538 8192000000 10925628528 11339280384 1934288160 19.101 98 70 141 1 1992937680 36949584 21699936
14:41:26 2104 8192000000 10906253456 11321425920 1925081808 19.028 98 85 170 0 1988804560 37737264 25985488
14:41:34 3013 8192000000 10931254464 11336110080 1941713760 19.160 99 81 162 0 2006500144 39454912 25331472
14:41:44 1385 8192000000 10928032896 11326590976 1936525488 19.119 99 94 185 1 2002851872 38337856 27988528
14:41:56 4760 8192000000 10934048304 11347189760 1956430240 19.278 100 73 146 2 2019977088 39762384 23784464
14:42:07 3020 8192000000 10941005728 11348598784 1943181264 19.172 99 83 163 2 2008988144 40608064 25198816
14:42:17 2728 8192000000 10943646576 11361505280 1959409184 19.301 100 68 136 1 2022735536 41520384 21805968
14:42:27 6147 8192000000 10937024624 11353882624 1953661360 19.256 100 71 142 0 2020087376 43467408 22958608
14:42:42 3815 8192000000 10923799760 11348840448 1935589872 19.112 99 60 118 0 1997979792 42291264 20098656
14:42:58 3567 8192000000 10934288560 11352940544 1952255600 19.244 100 64 126 1 2017157888 43270672 21631616
14:43:08 5535 8192000000 10931654688 11351703552 1953963952 19.258 100 59 119 0 2015554864 42547136 19043776
14:43:20 10255 8192000000 10898313440 11334070272 1921423632 18.998 99 50 99 1 1979932080 41950752 16557696
14:43:42 11275 8192000000 10912649504 11344482304 1940164128 19.148 100 35 70 2 1994016880 41535360 12317392
14:44:02 6252 8192000000 10916247584 11336835072 1931364016 19.078 99 60 119 2 1994288544 43792832 19131696
14:44:16 2077 8192000000 10942320288 11358334976 1957253040 19.284 100 83 164 4 2026984464 44055408 25676016
14:44:25 1808 8192000000 10961005536 11366465536 1959607120 19.303 100 92 184 2 2033883008 46102784 28173104
14:44:34 5761 8192000000 10940412384 11359629312 1956252384 19.276 100 77 154 3 2025664816 44941504 24470928
14:44:50 12902 8192000000 10920763296 11366944768 1961571984 19.319 100 46 92 2 2025806592 48986560 15248048
14:45:13 8342 8192000000 10901726464 11346272256 1935860688 19.114 99 36 72 1 1984271232 36527712 11882832
14:45:27 6866 8192000000 10919091280 11349553152 1950495664 19.230 100 28 56 0 1996594256 36692032 9406560
14:45:42 6730 8192000000 10913160256 11353722880 1941262048 19.157 99 36 72 1 1990904128 38267888 11374192
14:45:59 16035 8192000000 10902704384 11341180928 1894338528 18.781 97 30 60 0 1945074528 40433696 10302304
14:46:22 9917 8192000000 10891313264 11319390208 1893541152 18.774 98 36 72 1 1944994592 39986064 11467376
14:46:38 7557 8192000000 10891445696 11316207616 1896898416 18.801 99 41 82 2 1952925664 42741424 13285824
14:46:54 11582 8192000000 10902972528 11344355328 1936956880 19.122 100 39 76 2 1989213600 39866352 12390368
14:47:13 31558 8192000000 10925015520 11345158144 1946153232 19.196 100 46 92 1 1999010560 38064288 14793040
14:48:06 23076 8192000000 10909415984 11341627392 1919525280 18.983 99 36 72 1 1976692768 45015680 12151808
14:48:42 22499 8192000000 10911008400 11341852672 1931161264 19.076 100 49 97 2 1996810576 49747856 15901456
14:49:14 16418 8192000000 10897887152 11337781248 1915500608 18.951 99 37 74 4 1973424784 45580832 12343344
14:50:32 19420 8192000000 10893096720 11343560704 1911116128 18.916 100 24 49 0 1977205792 56684656 9405008
14:51:10 43433 8192000000 10861598400 11319681024 1909087696 18.899 100 13 26 0 1955336272 40858784 5389792
14:52:03 70048 8192000000 10863919824 11301588992 1887074672 18.722 98 12 24 0 1902479312 11562432 3842208
14:54:01 32893 8192000000 10871519600 11325616128 1918328976 18.973 99 29 58 0 1941287712 14310624 8648112
14:54:41 58364 8192000000 10863122912 11328409600 1925877248 19.034 100 12 24 0 1950367248 20456448 4033552
14:56:01 88444 8192000000 10883718880 11320434688 1895529152 18.790 98 15 29 1 1916373968 16264688 4580128
14:57:37 149837 8192000000 10886380768 11342639104 1886508256 18.718 96 22 42 2 1899079360 7198576 5372528
15:00:21 91919 8192000000 10888230832 11345932288 1909135552 18.900 97 17 34 1 1924050208 10409920 4504736
15:02:31 93565 8192000000 10906221696 11362873344 1953934736 19.258 99 29 58 1 1973602672 10647936 9020000
15:04:11 67910 8192000000 10879585168 11346956288 1912687808 18.928 97 21 42 2 1930180048 11772896 5719344
15:05:26 29456 8192000000 10902861280 11362504704 1953805616 19.257 99 27 53 1 1975904656 14516720 7582320
15:06:10 23437 8192000000 10920903216 11376328704 1965067488 19.346 99 38 76 2 1987788096 11351408 11369200
15:06:49 64244 8192000000 10910188896 11388252160 1978459344 19.452 100 14 28 2 2000491328 17728336 4303648
15:08:36 76433 8192000000 10882821056 11348094976 1923291984 19.013 97 21 43 2 1945060464 15311456 6457024
15:09:58 35812 8192000000 10896543360 11365208064 1964711904 19.343 100 9 18 0 1977114480 9829840 2572736
15:10:41 13033 8192000000 10876852736 11345387520 1926589264 19.040 98 8 16 0 1942123520 12869664 2664592
15:11:46 62056 8192000000 10870341072 11346976768 1931345888 19.078 99 11 22 0 1944057424 9399616 3311920
15:13:13 43487 8192000000 10864773168 11338461184 1937627056 19.128 99 19 35 2 1952353216 9979616 4746544
15:14:04 35497 8192000000 10870280352 11345965056 1904272592 18.861 97 8 16 1 1917745072 11254320 2218160
15:14:52 43742 8192000000 10892779888 11364671488 1942813344 19.169 99 22 44 0 1965712800 16869568 6029888
15:15:48 51845 8192000000 10887131904 11365396480 1943357024 19.174 99 17 34 0 1963493408 15202608 4933776
15:16:48 34073 8192000000 10887955440 11357847552 1949041136 19.219 99 19 36 1 1964063552 9751456 5270960
15:17:35 14584 8192000000 10899348832 11352301568 1946821536 19.201 99 42 80 1 1965364800 7698128 10845136
15:17:58 7908 8192000000 10901974832 11348078592 1957670560 19.288 100 60 120 1 1983951184 10710016 15570608
15:18:17 41346 8192000000 10879518176 11328282624 1861672992 18.517 95 42 84 1 1885025040 11599344 11752704
15:19:04 58034 8192000000 10879225328 11346755584 1911602384 18.920 98 11 22 0 1929705872 15438240 2665248
15:20:17 26987 8192000000 10895997088 11345195008 1933200480 19.092 99 22 44 0 1947058768 7968832 5889456
15:20:53 40938 8192000000 10893673344 11355901952 1940059312 19.147 99 30 58 2 1963150480 15460864 7630304
15:21:40 71888 8192000000 10885601024 11345547264 1879549088 18.661 96 19 38 0 1892893424 8330608 5013728
15:22:59 52832 8192000000 10899583600 11357388800 1953795216 19.257 100 13 26 2 1972411376 14903232 3712928
15:24:06 72171 8192000000 10868379376 11348803584 1885198032 18.707 96 15 30 0 1903700672 14166816 4335824
15:25:25 68352 8192000000 10904231072 11352195072 1897400480 18.805 97 14 28 1 1915852864 14465168 3987216
15:26:42 26032 8192000000 10875801728 11323752448 1890024832 18.746 97 33 66 1 1908058064 8974624 9058608
15:27:17 111929 8192000000 10838962464 11303653376 1822340736 18.197 94 12 24 0 1839005984 12559456 4105792
15:29:38 68269 8192000000 10855202736 11312807936 1853392928 18.450 96 21 42 1 1865615568 6540064 5682576
15:30:53 36493 8192000000 10862437632 11322920960 1934299056 19.101 100 34 68 3 1954087664 10703696 9084912
15:31:36 4172 8192000000 10877215232 11332694016 1940924208 19.154 100 38 72 0 1960733904 9447408 10362288
15:31:46 16388 8192000000 10864018400 11333947392 1930726240 19.073 99 27 54 0 1946615648 8737232 7152176
15:32:15 31368 8192000000 10841518432 11299213312 1888382416 18.733 97 21 41 2 1903334192 8999296 5952480
15:32:56 36782 8192000000 10849157840 11329081344 1934551552 19.103 100 2 4 0 1940211216 5535040 124624
15:33:39 49655 8192000000 10876309168 11342295040 1947702240 19.208 100 16 32 0 1957763168 6075568 3985360
15:34:35 53171 8192000000 10870715872 11344445440 1937262448 19.125 99 8 16 1 1948667936 9334592 2070896
15:35:35 42615 8192000000 10879825600 11361959936 1955457200 19.270 100 3 6 0 1966251472 9983328 810944
15:37:09 58219 8192000000 10868232752 11326791680 1899317696 18.821 97 13 26 1 1919563344 16289280 3956368
15:38:46 80106 8192000000 10870129392 11338457088 1897865824 18.809 97 15 30 3 1915664544 13619296 4179424
15:40:13 65029 8192000000 10881034080 11350343680 1945463840 19.190 100 17 34 0 1966173552 15406592 5303120
15:41:25 56876 8192000000 10884812032 11351863296 1933652368 19.096 99 22 44 1 1954676512 14520864 6503280
15:42:28 100930 8192000000 10882058464 11343233024 1894445392 18.782 97 26 51 1 1914578432 12825840 7307200
15:44:17 112407 8192000000 10906271776 11377217536 1937494576 19.127 99 10 20 1 1949533664 9560880 2478208
15:46:17 153442 8192000000 10894820128 11376021504 1881193968 18.675 95 9 18 1 1899149744 15480176 2475600
15:49:05 130320 8192000000 10914569664 11378323456 1942371760 19.166 98 16 31 0 1959075536 12269408 4434368
15:51:23 59595 8192000000 10901571280 11383508992 1962845648 19.329 99 6 12 0 1978426112 13787536 1792928
15:52:29 49967 8192000000 10883406576 11367931904 1939262672 19.141 98 9 18 0 1956682960 14674624 2745664
15:53:25 32012 8192000000 10878445456 11370012672 1958289744 19.292 100 5 10 0 1970690048 11289088 1111216
15:54:03 37408 8192000000 10887996288 11365769216 1932457408 19.087 98 10 20 1 1946303536 11222912 2623216
15:54:56 60909 8192000000 10898874768 11372249088 1969380944 19.381 100 11 22 1 1981162400 8653280 3128176
15:56:03 98929 8192000000 10895807984 11378880512 1946082192 19.195 98 26 52 0 1962302816 9189376 7031248
15:59:06 56312 8192000000 10890744512 11378745344 1911260448 18.917 96 14 28 1 1926187280 11031872 3894960
16:00:49 49892 8192000000 10879671920 11347316736 1883982032 18.697 95 12 24 0 1894488496 7238448 3268016
16:01:52 71325 8192000000 10893721344 11356442624 1870155792 18.586 95 14 27 1 1884948928 10809184 3983952
16:03:23 73218 8192000000 10868372928 11344519168 1859014544 18.495 95 23 46 1 1879105664 13438400 6652720
16:05:01 28132 8192000000 10908317040 11364442112 1944280720 19.181 99 43 86 0 1966613584 10754624 11578240
16:05:35 89864 8192000000 10898812096 11365941248 1922698912 19.008 98 26 52 0 1946428736 16603808 7126016
16:07:16 65269 8192000000 10901348688 11364081664 1930853136 19.074 98 30 60 0 1952618672 13881568 7883968
16:08:36 23863 8192000000 10897065680 11351588864 1925862592 19.034 98 43 86 1 1948982832 11157632 11962608
16:09:08 28559 8192000000 10892965120 11343130624 1914694080 18.944 97 49 98 2 1941225392 13055152 13476160
16:09:46 98954 8192000000 10898068384 11372613632 1921604544 19.000 98 16 33 1 1940596992 14379632 4612816
16:11:31 82322 8192000000 10884257056 11359473664 1869716960 18.582 95 20 40 0 1894610272 19515040 5378272
16:13:05 88873 8192000000 10845470112 11308425216 1847581408 18.402 95 17 35 0 1861562736 9284960 4696368
16:14:57 90777 8192000000 10849944208 11305816064 1872661392 18.606 97 15 30 0 1886434656 8431040 5342224
16:16:46 38475 8192000000 10840535824 11320549376 1877498368 18.645 97 6 12 1 1887041776 8003920 1539488
16:17:32 76214 8192000000 10833742272 11315032064 1856367424 18.474 96 13 26 0 1870386048 10088864 3929760
16:18:54 24231 8192000000 10819296544 11302277120 1875714272 18.630 98 6 12 0 1884696016 7482000 1499744
16:19:37 22776 8192000000 10835699600 11312730112 1898572832 18.815 99 15 30 1 1909838912 7044832 4221248
16:20:28 66369 8192000000 10857668432 11328684032 1919630208 18.984 99 21 42 1 1937213136 11190112 6392816
16:21:54 53002 8192000000 10852002928 11336134656 1935245344 19.109 100 13 25 2 1951695344 12523232 3926768
16:23:01 70572 8192000000 10850210736 11328958464 1894874432 18.785 98 14 28 1 1909034976 9645184 4515360
16:24:29 58502 8192000000 10872202112 11342921728 1924505824 19.023 99 17 34 1 1937595584 8659088 4430672
16:26:03 46346 8192000000 10890016560 11353141248 1952454048 19.246 100 21 43 0 1971657392 12751200 6452144
16:27:02 13450 8192000000 9122656848 9356038144 285996144 3.373 15 1 2 0 288610080 2551808 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 24-12-2020 16:28:26 to 24-12-2020 16:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 119 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-12-2020 16:28:58 to 24-12-2020 16:29:00.

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          256915
MON$OLDEST_ACTIVE               256916
MON$OLDEST_SNAPSHOT             256916
MON$NEXT_TRANSACTION            256916
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                       2034528
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:302: 
:303: mscs-test-161.budzdorov.ru    Thu Dec 24 16:27:22 2020
:304:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:305: 
:306: 
:307: mscs-test-161.budzdorov.ru    Thu Dec 24 16:27:22 2020
:308:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:309: 
--- end of diff output ---

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

24.12.20 16:29:01. 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-24 16:29:03 No severe PSQL-related problems occured
24.12.20 16:29:04. End of report.