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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17361856 kB
MemAvailable 31565048 kB
Buffers 0 kB
Cached 14318336 kB
SwapCached 1988 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-09 01:27:03
DTS_END                         2020-12-09 01:27:03.4390
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/44328
TRN_ID                          248734
ATT_ID                          667
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: 9580.78 19337 1149694
customer order: creation 172.47 387 20696
customer order: refuse 14.52 283 1742
order to supplier: creation 45.38 1235 5445
order to supplier: removal 3.68 81620 441
invoice (draft): creation 45.47 3081 5456
invoice (draft): removal 56.15 666 6738
invoice accept: apply 41.76 15579 5011
invoice accept: cancel 51.08 663 6129
customer reserve: creation 3915.38 152 469846
customer reserve: removal 4935.69 47 592283
realization accept: apply 83.84 151 10061
realization accept: cancel 85.78 91 10294
payment from customer: creation 59.15 94 7098
payment from customer: removal 5.57 79 668
payment to supplier: creation 49.30 108 5916
payment to supplier: removal 3.67 76 440
service: total inventory turnovers 4.87 933 584
service: total monetary turnovers 6.18 27 741
service: aggregate perf. data 0.84 18205 101
service: refresh index statistics 0.03 263262 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-12-2020 01:28:07 to 09-12-2020 01:28:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2624
TEST_TIME 2 4206
TEST_TIME 3 5786
TEST_TIME 4 5558
TEST_TIME 5 6159
TEST_TIME 6 5872
TEST_TIME 7 5861
TEST_TIME 8 6244
TEST_TIME 9 6411
TEST_TIME 10 7145
TEST_TIME 11 7602
TEST_TIME 12 7964
TEST_TIME 13 8500
TEST_TIME 14 8651
TEST_TIME 15 9421
TEST_TIME 16 9670
TEST_TIME 17 9617
TEST_TIME 18 10045
TEST_TIME 19 11099
TEST_TIME 20 11048
TEST_TIME 21 10844
TEST_TIME 22 11444
TEST_TIME 23 11332
TEST_TIME 24 11250
TEST_TIME 25 11025
TEST_TIME 26 11033
TEST_TIME 27 11361
TEST_TIME 28 11327
TEST_TIME 29 11174
TEST_TIME 30 11147
TEST_TIME 31 11125
TEST_TIME 32 11260
TEST_TIME 33 11078
TEST_TIME 34 10765
TEST_TIME 35 10669
TEST_TIME 36 10701
TEST_TIME 37 10589
TEST_TIME 38 10559
TEST_TIME 39 10595
TEST_TIME 40 10536
TEST_TIME 41 10392
TEST_TIME 42 10259
TEST_TIME 43 10383
TEST_TIME 44 10293
TEST_TIME 45 10403
TEST_TIME 46 10249
TEST_TIME 47 10137
TEST_TIME 48 10106
TEST_TIME 49 10044
TEST_TIME 50 10184
TEST_TIME 51 10140
TEST_TIME 52 10179
TEST_TIME 53 10179
TEST_TIME 54 10126
TEST_TIME 55 10125
TEST_TIME 56 10314
TEST_TIME 57 10299
TEST_TIME 58 10316
TEST_TIME 59 10314
TEST_TIME 60 10266
TEST_TIME 61 10316
TEST_TIME 62 10255
TEST_TIME 63 10136
TEST_TIME 64 10106
TEST_TIME 65 10104
TEST_TIME 66 10028
TEST_TIME 67 9936
TEST_TIME 68 9840
TEST_TIME 69 9897
TEST_TIME 70 9859
TEST_TIME 71 9832
TEST_TIME 72 9771
TEST_TIME 73 9757
TEST_TIME 74 9874
TEST_TIME 75 10012
TEST_TIME 76 10000
TEST_TIME 77 9927
TEST_TIME 78 10023
TEST_TIME 79 10012
TEST_TIME 80 9990
TEST_TIME 81 10114
TEST_TIME 82 10018
TEST_TIME 83 9927
TEST_TIME 84 9905
TEST_TIME 85 9852
TEST_TIME 86 9794
TEST_TIME 87 9774
TEST_TIME 88 9713
TEST_TIME 89 9735
TEST_TIME 90 9753
TEST_TIME 91 9775
TEST_TIME 92 9812
TEST_TIME 93 9797
TEST_TIME 94 9746
TEST_TIME 95 9823
TEST_TIME 96 9788
TEST_TIME 97 9797
TEST_TIME 98 9815
TEST_TIME 99 9820
TEST_TIME 100 9811
TEST_TIME 101 9835
TEST_TIME 102 9853
TEST_TIME 103 9828
TEST_TIME 104 9871
TEST_TIME 105 9808
TEST_TIME 106 9756
TEST_TIME 107 9766
TEST_TIME 108 9736
TEST_TIME 109 9712
TEST_TIME 110 9685
TEST_TIME 111 9645
TEST_TIME 112 9625
TEST_TIME 113 9610
TEST_TIME 114 9583
TEST_TIME 115 9614
TEST_TIME 116 9583
TEST_TIME 117 9585
TEST_TIME 118 9671
TEST_TIME 119 9661
TEST_TIME 120 9582

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-12-2020 01:28:11 to 09-12-2020 01:28:14.

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 1582952 1582952 0 0.00 0 12389 5 0 0
doc_list_biud 1582951 1582951 0 0.00 0 51014 23 0 0
sp_add_invoice_to_stock 5132 5011 121 2.35 33 160557 15579 0 121
sp_cancel_adding_invoice 6129 6129 0 0.00 4 68923 664 0 0
sp_cancel_client_order 1742 1742 0 0.00 4 13316 283 0 0
sp_cancel_customer_reserve 592283 592283 0 0.00 1 42399 48 0 0
sp_cancel_pay_from_customer 668 668 0 0.00 3 5273 80 0 0
sp_cancel_pay_to_supplier 440 440 0 0.00 2 3195 77 0 0
sp_cancel_supplier_invoice 6743 6738 5 0.07 1 51019 666 0 5
sp_cancel_supplier_order 441 441 0 0.00 10 731519 81620 0 0
sp_cancel_write_off 10294 10294 0 0.00 1 19396 91 0 0
sp_client_order 20696 20696 0 0.00 4 44417 388 0 0
sp_customer_reserve 469846 469846 0 0.00 0 61249 153 0 0
sp_fill_shopping_cart 31586 31586 0 0.00 1 18865 34 0 0
sp_fill_shopping_cart_clo_res 469840 469840 0 0.00 0 13837 12 0 0
sp_get_clo_for_invoice 5004 5004 0 0.00 0 12743 284 0 0
sp_kill_cost_storno 17531 17531 0 0.00 0 6505 46 0 0
sp_kill_qstorno_ret_qs2qd 1202039 1202039 0 0.00 0 51010 26 0 0
sp_kill_qty_storno 632690 632690 0 0.00 0 51013 56 0 0
sp_lock_selected_doc 20892 20892 0 0.00 0 7705 5 0 0
sp_make_cost_storno 28078 28078 0 0.00 0 12295 43 0 0
sp_multiply_rows_for_pdistr 28077 28077 0 0.00 0 7132 24 0 0
sp_multiply_rows_for_qdistr 20696 20696 0 0.00 0 12437 186 0 0
sp_pay_from_customer 7098 7098 0 0.00 4 11553 95 0 0
sp_pay_to_supplier 5916 5916 0 0.00 5 14600 109 0 0
sp_payment_common 13014 13014 0 0.00 1 6684 24 0 0
sp_qd_handle_on_cancel_clo 1742 1742 0 0.00 0 13309 252 0 0
sp_qd_handle_on_invoice_upd_sts 11132 11132 0 0.00 0 43759 272 0 0
sp_qd_handle_on_reserve_upd_sts 10060 10060 0 0.00 0 38660 53 0 0
sp_reserve_write_off 10061 10061 0 0.00 6 38761 152 0 0
sp_supplier_invoice 5456 5456 0 0.00 8 99164 3082 0 0
sp_supplier_order 5445 5445 0 0.00 6 44501 1236 0 0
srv_aggregate_perf_data 102 101 1 0.98 2891 118090 18206 0 1
srv_fill_mon_cache_memory 149 149 0 0.00 1289 121699 35955 0 0
srv_find_qd_qs_mism 1100765 1100765 0 0.00 0 12049 4 0 0
srv_make_invnt_saldo 584 584 0 0.00 37 24876 934 0 0
srv_make_money_saldo 741 741 0 0.00 1 3192 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 209055 307875 263263 0 0
t$perf-abend:sp_add_invoice_to_stock 121 121 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 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 5011 5011 0 0.00 0 26229 132 0 0
t$perf-norm:sp_cancel_adding_invoice 416 416 0 0.00 0 2561 73 0 0
t$perf-norm:sp_cancel_client_order 1742 1742 0 0.00 0 491 6 0 0
t$perf-norm:sp_cancel_customer_reserve 691 691 0 0.00 0 1182 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 668 668 0 0.00 0 281 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 440 440 0 0.00 0 4803 23 0 0
t$perf-norm:sp_cancel_supplier_invoice 372 372 0 0.00 0 1824 15 0 0
t$perf-norm:sp_cancel_supplier_order 441 441 0 0.00 0 15655 1280 0 0
t$perf-norm:sp_cancel_write_off 1059 1059 0 0.00 0 8652 18 0 0
t$perf-norm:sp_client_order 20696 20696 0 0.00 0 10507 14 0 0
t$perf-norm:sp_customer_reserve 985 985 0 0.00 0 9568 14 0 0
t$perf-norm:sp_pay_from_customer 7098 7098 0 0.00 0 11696 11 0 0
t$perf-norm:sp_pay_to_supplier 5916 5916 0 0.00 0 8830 11 0 0
t$perf-norm:sp_reserve_write_off 10061 10061 0 0.00 0 7523 8 0 0
t$perf-norm:sp_supplier_invoice 5456 5456 0 0.00 0 11399 19 0 0
t$perf-norm:sp_supplier_order 5445 5445 0 0.00 0 6824 14 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 620 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 149 149 0 0.00 0 172 3 0 0
t$perf-norm:srv_make_invnt_saldo 584 584 0 0.00 0 1311 15 0 0
t$perf-norm:srv_make_money_saldo 741 741 0 0.00 0 439 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 14 5 0 0
v_add_invoice_to_stock 10248 10006 242 2.36 0 24286 21 0 242
v_all_customers 37774 37774 0 0.00 0 19 1 0 0
v_all_suppliers 30160 30160 0 0.00 0 149 1 0 0
v_all_wares 41390 41390 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 832 832 0 0.00 0 3926 15 0 0
v_cancel_client_order 3484 3484 0 0.00 0 2278 5 0 0
v_cancel_customer_prepayment 1336 1336 0 0.00 0 1753 6 0 0
v_cancel_customer_reserve 1382 1382 0 0.00 0 24296 23 0 0
v_cancel_payment_to_supplier 880 880 0 0.00 0 3168 12 0 0
v_cancel_supplier_invoice 754 744 10 1.32 0 1322 21 0 10
v_cancel_supplier_order 882 882 0 0.00 0 670 5 0 0
v_cancel_write_off 2118 2118 0 0.00 0 7040 19 0 0
v_max_id_clo_ord 5442 5442 0 0.00 0 229 1 0 0
v_max_id_clo_res 985 985 0 0.00 0 1217 11 0 0
v_max_id_ord_sup 5449 5449 0 0.00 0 14036 7 0 0
v_max_non_paid_invoice 1727 1727 0 0.00 0 384 2 0 0
v_max_non_paid_realizn 3788 3788 0 0.00 0 2237 4 0 0
v_min_id_clo_ord 5442 5442 0 0.00 0 4680 6 0 0
v_min_id_clo_res 985 985 0 0.00 0 7036 18 0 0
v_min_id_ord_sup 5449 5449 0 0.00 0 3978 4 0 0
v_min_non_paid_invoice 5916 5916 0 0.00 0 6682 16 0 0
v_min_non_paid_realizn 7098 7098 0 0.00 0 5399 15 0 0
v_our_firm 10236 10236 0 0.00 0 11 1 0 0
v_reserve_write_off 20120 20120 0 0.00 0 10262 6 0 0
x_lock_depdocs_on_canc_invoice 12495 12495 0 0.00 0 12322 100 0 0
x_lock_depdocs_on_canc_sup_ord 441 441 0 0.00 0 15380 341 0 0
x_make_qstorno_1000_1200 5445 5445 0 0.00 2 44484 1168 0 0
x_make_qstorno_1200_2000 5456 5456 0 0.00 3 94258 2957 0 0
x_make_qstorno_2100_3300 469846 469846 0 0.00 0 61248 139 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-12-2020 01:28:15 to 09-12-2020 01:28:19.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:07 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:13 16674 8192000000 10206180272 10509860864 829837904 9.198 67 45 90 0 847080880 2372768 14870208
22:57:41 26389 8192000000 10331883152 10643415040 1367230144 14.302 100 85 169 1 1400042512 4721808 28090560
22:58:15 28519 8192000000 10369599552 10690093056 1414717456 14.726 100 88 174 0 1449012576 6261936 28033184
22:58:52 22839 8192000000 10399855792 10726838272 1452455344 15.060 100 86 172 0 1487663248 7366320 27841584
22:59:25 23462 8192000000 10428619712 10756689920 1479622640 15.298 100 86 172 1 1515460160 8364576 27472944
23:00:04 5334 8192000000 10435247616 10766225408 1492594768 15.412 100 88 176 0 1529972128 9192448 28184912
23:00:20 19426 8192000000 10462412416 10797850624 1519973232 15.650 100 88 176 1 1557382256 9642176 27766848
23:00:51 25101 8192000000 10486444304 10832637952 1542692912 15.847 100 85 170 0 1578286928 9803440 25790576
23:01:27 6675 8192000000 10501928064 10846871552 1564057008 16.031 100 80 160 1 1599114720 10553408 24504304
23:01:42 14579 8192000000 10537869552 10886299648 1584771584 16.209 100 84 168 0 1621529488 10949344 25808560
23:02:06 17210 8192000000 10560205248 10914652160 1617087440 16.485 100 87 174 1 1655549520 11882128 26579952
23:02:31 12049 8192000000 10572667712 10930950144 1629976528 16.595 100 71 141 0 1662600240 11078416 21545296
23:02:51 12668 8192000000 10593103184 10956722176 1660308208 16.851 100 83 165 0 1696582880 11621504 24653168
23:03:14 9297 8192000000 10623071808 10988568576 1675663648 16.981 100 77 153 0 1709822976 12291296 21868032
23:03:32 7208 8192000000 10633361312 10996846592 1693333792 17.129 100 83 166 2 1730745568 13032432 24379344
23:03:46 6849 8192000000 10647342368 11017322496 1703228128 17.212 100 75 149 0 1737321184 13105776 20987280
23:04:04 5593 8192000000 10671024768 11041189888 1728203920 17.421 100 81 162 0 1763647600 12361712 23081968
23:04:16 6169 8192000000 10675123776 11049439232 1740193376 17.520 100 76 152 0 1773779072 12006160 21579536
23:04:29 5032 8192000000 10686697696 11064692736 1749703952 17.599 100 70 137 1 1780702320 11728528 19269840
23:04:42 5501 8192000000 10707081712 11088396288 1773175488 17.793 100 80 160 1 1807869248 11349920 23343840
23:04:55 4671 8192000000 10709241296 11091984384 1779849216 17.848 100 77 153 0 1812775584 11941600 20984768
23:05:08 4019 8192000000 10736116224 11113037824 1791895280 17.947 100 83 166 0 1827667936 12883984 22888672
23:05:19 2802 8192000000 10742281408 11122176000 1802318496 18.033 100 92 184 1 1842453824 14495872 25639456
23:05:28 3541 8192000000 10751316896 11130638336 1807747616 18.077 100 89 178 1 1847714528 15210624 24756288
23:05:38 2192 8192000000 10755706544 11133923328 1812444928 18.116 100 88 174 0 1851118096 14124336 24548832
23:05:46 7940 8192000000 10752302544 11140177920 1811158208 18.105 100 78 156 2 1847034224 13992368 21883648
23:06:01 5566 8192000000 10753607504 11142283264 1816026096 18.145 100 77 153 0 1851145440 13709952 21409392
23:06:12 2281 8192000000 10778673568 11166576640 1840488704 18.345 100 75 147 0 1872297888 11511616 20297568
23:06:21 2626 8192000000 10785909840 11171659776 1842859088 18.364 100 77 152 0 1877835520 13208448 21767984
23:06:31 2089 8192000000 10789481856 11175768064 1849494864 18.418 100 93 186 3 1889880096 13259584 27125648
23:06:40 2299 8192000000 10793472992 11182399488 1854561072 18.459 100 88 176 1 1892668272 13050736 25056464
23:06:48 2437 8192000000 10805096624 11193958400 1859045232 18.496 100 94 190 2 1897596864 12791104 25760528
23:06:57 2052 8192000000 10804771680 11194658816 1862779856 18.526 100 91 182 0 1901519280 13508224 25231200
23:07:05 1585 8192000000 10802151072 11188989952 1865417184 18.547 100 92 183 1 1902660032 12057120 25185728
23:07:13 1732 8192000000 10811282944 11198939136 1865929696 18.551 100 92 186 1 1905698592 14083536 25685360
23:07:21 2096 8192000000 10815965904 11207827456 1869459792 18.580 100 87 174 2 1906202960 12400144 24343024
23:07:29 1936 8192000000 10822367952 11211235328 1877944112 18.649 100 93 186 2 1919020592 14860448 26216032
23:07:38 1309 8192000000 10831018288 11217850368 1878894304 18.656 100 94 191 2 1919561840 14518848 26148688
23:07:45 1542 8192000000 10827764080 11217219584 1881648272 18.678 100 96 194 4 1921744912 13386912 26709728
23:07:53 1311 8192000000 10827971696 11219066880 1882368528 18.684 100 96 192 0 1922408944 13102784 26937632
23:08:01 2573 8192000000 10827109440 11222564864 1884611344 18.702 100 86 172 0 1923303232 14212880 24479008
23:08:10 31565 8192000000 10813772752 11223465984 1884946992 18.705 100 59 116 1 1909487424 7754288 16786144
23:08:51 5231 8192000000 10785659104 11216117760 1880120544 18.666 100 41 81 2 1900268928 9153328 10995056
23:09:07 5894 8192000000 10793706400 11221475328 1882312976 18.684 100 35 70 0 1900294720 7479872 10501872
23:09:21 2977 8192000000 10810349488 11223379968 1887210688 18.723 100 40 81 2 1906289376 7020880 12057808
23:09:30 8675 8192000000 10792412768 11221569536 1887586048 18.726 100 17 34 0 1898195984 6161904 4448032
23:09:46 5621 8192000000 10802410160 11232694272 1889053696 18.738 100 34 69 2 1911213664 11870880 10289088
23:09:59 8700 8192000000 10792519408 11228237824 1886826080 18.720 100 17 35 2 1897141680 5628640 4686960
23:10:16 8582 8192000000 10802260912 11231580160 1891175056 18.755 100 25 49 3 1904451632 5651952 7624624
23:10:31 13942 8192000000 10792350368 11231858688 1893276720 18.772 100 18 36 1 1907729472 9755360 4697392
23:10:53 4524 8192000000 10812295024 11240599552 1895531216 18.790 100 24 48 2 1917432944 14619936 7281792
23:11:04 15628 8192000000 10805024672 11240566784 1892931008 18.769 100 11 22 0 1906414448 10750352 2733088
23:11:26 10827 8192000000 10799747984 11242098688 1894242512 18.780 100 17 33 1 1905273200 6418896 4611792
23:11:43 5161 8192000000 10802759712 11241291776 1899740624 18.824 100 20 39 2 1910965504 5325008 5899872
23:11:54 56721 8192000000 10838730048 11256991744 1903308976 18.853 100 19 38 0 1913599440 4884720 5405744
23:13:04 16510 8192000000 10823408000 11257495552 1908290656 18.893 100 39 79 4 1924796992 5916432 10589904
23:13:27 10152 8192000000 10821830304 11258933248 1906837392 18.881 100 22 44 2 1919382496 6064448 6480656
23:13:44 6705 8192000000 10821778320 11251625984 1904120896 18.859 100 22 43 2 1915962480 4776112 7065472
23:13:58 8656 8192000000 10823363872 11255635968 1907166128 18.884 100 24 47 1 1919835968 5852976 6816864
23:14:13 4952 8192000000 10814429168 11255730176 1889018272 18.738 99 26 52 0 1902790688 6048480 7723936
23:14:27 8272 8192000000 10810142320 11251310592 1906567648 18.879 100 24 49 3 1919872464 6253664 7051152
23:14:42 10116 8192000000 10806524880 11248140288 1898478960 18.814 100 21 42 0 1910191376 5503664 6208752
23:15:00 7271 8192000000 10829340656 11252981760 1902557248 18.847 100 26 52 0 1915104240 4756752 7790240
23:15:14 13658 8192000000 10804902000 11234500608 1841834448 18.356 97 23 45 3 1854414880 5774704 6805728
23:15:35 11552 8192000000 10784619440 11226820608 1869044640 18.577 99 20 40 1 1879587888 5686448 4856800
23:15:54 11034 8192000000 10795783856 11229478912 1869018704 18.576 99 15 30 2 1878576640 5801744 3756192
23:16:13 9450 8192000000 10742795024 11166167040 1789200016 17.925 96 18 36 3 1800260160 6148656 4911488
23:16:29 8412 8192000000 10738497376 11152588800 1729244704 17.429 93 28 56 2 1742531568 5536224 7750640
23:16:45 50375 8192000000 10715249872 11107131392 1652368544 16.784 90 40 80 4 1669942576 5615776 11958256
23:17:42 22787 8192000000 10704901312 11123609600 1692617056 17.123 93 40 78 2 1710537728 7156400 10764272
23:18:12 10038 8192000000 10701698336 11122225152 1702442064 17.206 94 24 48 1 1714735040 5449792 6843184
23:18:30 7145 8192000000 10679830288 11095851008 1727176400 17.412 97 27 54 1 1741416928 6319536 7920992
23:18:45 5890 8192000000 10677917248 11088523264 1731938560 17.452 98 19 38 1 1743835024 5856880 6039584
23:19:00 6252 8192000000 10684373776 11095314432 1727501952 17.415 97 30 60 0 1744385200 7654928 9228320
23:19:13 7730 8192000000 10684845552 11107971072 1769825744 17.766 99 38 76 2 1787614224 6583840 11204640
23:19:30 6285 8192000000 10698320848 11115855872 1780241936 17.851 100 41 78 4 1802217872 10528800 11447136
23:19:43 9453 8192000000 10716548032 11122262016 1741239232 17.529 97 30 60 2 1755772464 5067312 9465920
23:19:58 7239 8192000000 10710917792 11128201216 1781736176 17.864 99 14 27 2 1791035664 5707600 3591888
23:20:12 6495 8192000000 10726962176 11149754368 1798039296 17.998 99 21 42 1 1810506016 6133472 6333248
23:20:25 6457 8192000000 10734700560 11159007232 1818886368 18.169 100 15 29 5 1828455120 5051744 4517008
23:20:38 10977 8192000000 10738788736 11159089152 1795369952 17.976 98 24 48 1 1807537776 4857600 7310224
23:20:55 10206 8192000000 10752205472 11171917824 1834196400 18.294 100 23 45 4 1845729680 4945584 6587696
23:21:13 10983 8192000000 10751466640 11182895104 1841919632 18.356 100 26 50 2 1858643248 9727248 6996368
23:21:30 13644 8192000000 10768988096 11189911552 1847070912 18.398 100 22 45 2 1858522192 5232320 6218960
23:21:53 42526 8192000000 10781595936 11198627840 1856384640 18.474 100 25 50 3 1869677056 6105216 7187200
23:22:50 26422 8192000000 10765881824 11202306048 1860167792 18.505 100 21 42 2 1872664784 6154480 6342512
23:23:28 6620 8192000000 10775922352 11211436032 1869172272 18.578 100 34 68 2 1885843696 6582704 10088720
23:23:44 5508 8192000000 10779029360 11211235328 1866803104 18.558 100 33 66 2 1883373600 7626592 8943904
23:23:56 8537 8192000000 10787786688 11214635008 1868417056 18.571 100 25 48 0 1885598320 10392640 6788624
23:24:11 9017 8192000000 10785025312 11213164544 1871439136 18.596 100 23 46 1 1884256768 5991760 6825872
23:24:26 9483 8192000000 10785359936 11216326656 1871771808 18.599 100 21 42 0 1883137456 5728624 5637024
23:24:44 8903 8192000000 10807468432 11226615808 1878056064 18.649 100 24 48 1 1889967456 4662608 7248784
23:24:59 6025 8192000000 10796252816 11226939392 1882988768 18.689 100 33 66 2 1898800256 5624304 10187184
23:25:12 6320 8192000000 10801340624 11230650368 1884753936 18.703 100 25 49 0 1898029616 5763744 7511936
23:25:24 12200 8192000000 10806353296 11231272960 1884587568 18.702 100 29 56 3 1897844304 5058960 8197776
23:25:43 8873 8192000000 10799963568 11229253632 1865985408 18.552 99 24 48 0 1882716928 10282672 6448848
23:25:58 12072 8192000000 10804837376 11231293440 1881672992 18.679 100 23 45 0 1893308992 5310688 6325312
23:26:19 12734 8192000000 10788674192 11228143616 1885023632 18.706 100 17 34 2 1895383104 5127728 5231744
23:26:44 95523 8192000000 10830115216 11253760000 1879356624 18.660 99 39 75 1 1895574736 4971520 11246592
23:28:28 35097 8192000000 10843699728 11272527872 1913598464 18.936 100 38 74 1 1932081728 8276272 10206992
23:29:11 23607 8192000000 10863522912 11288051712 1932843632 19.090 100 43 86 1 1953699520 8467728 12388160
23:29:49 20484 8192000000 10869669408 11301072896 1942701696 19.168 100 39 79 2 1963910864 9107152 12102016
23:30:16 11754 8192000000 10866590656 11299770368 1925891376 19.034 99 34 68 1 1946180784 10221632 10067776
23:30:35 15231 8192000000 10877304080 11310874624 1948602704 19.215 100 40 80 1 1968998208 8837168 11558336
23:30:58 10378 8192000000 10894036736 11320475648 1959285520 19.300 100 54 107 1 1984852272 10291920 15274832
23:31:16 6556 8192000000 10890723200 11317829632 1944605184 19.183 99 53 102 0 1969516016 10232128 14678704
23:31:40 14498 8192000000 10887488576 11319570432 1956279344 19.276 100 62 124 1 1986376224 12013424 18083456
23:32:07 5433 8192000000 10916081936 11337265152 1966643360 19.359 100 54 109 2 1995592384 12128256 16820768
23:32:20 22775 8192000000 10899406624 11327840256 1957643024 19.287 99 54 108 0 1989151664 15302704 16205936
23:32:51 24864 8192000000 10906991792 11341434880 1954745440 19.264 99 35 70 0 1977276080 12042496 10488144
23:33:23 10073 8192000000 10908509744 11337273344 1970538736 19.390 100 43 86 0 1997506048 13280880 13686432
23:33:43 6762 8192000000 10905014224 11325120512 1950713312 19.232 99 54 108 0 1981156304 13880880 16562112
23:34:02 3150 8192000000 10914718640 11339726848 1971403744 19.397 100 64 128 0 2006657136 16139616 19113776
23:34:12 8623 8192000000 10918328000 11344654336 1975207408 19.427 100 52 104 1 2007474912 16445376 15822128
23:34:31 14534 8192000000 10908827328 11335659520 1941338144 19.157 98 52 104 3 1980744080 23253744 16152192
23:34:54 6401 8192000000 10911003280 11340648448 1954732000 19.264 99 47 94 3 1989539360 19356768 15450592
23:35:07 11781 8192000000 10920981056 11350351872 1977570976 19.445 100 55 110 3 2015474048 19919536 17983536
23:35:26 18947 8192000000 10928281808 11358535680 1979275200 19.459 100 42 83 1 2011936512 19415344 13245968
23:35:54 15764 8192000000 10923963056 11353214976 1959614320 19.303 99 60 120 0 2000388912 22446112 18328480
23:36:30 12141 8192000000 10915226528 11346923520 1968264992 19.372 100 59 117 0 2013016416 26282384 18469040
23:36:57 5001 8192000000 10921045632 11346792448 1949390464 19.222 99 44 85 0 1989013440 25640128 13982848
23:37:10 2208 8192000000 10903485920 11306467328 1923236816 19.013 97 83 164 2 1973753024 25732976 24783232
23:37:20 3352 8192000000 10921079088 11333017600 1941613648 19.160 99 77 153 1 1989588992 24735536 23239808
23:37:31 2500 8192000000 10928397872 11336269824 1957430320 19.286 100 80 162 1 2008539456 27422960 23686176
23:37:41 6581 8192000000 10934320464 11341131776 1960498864 19.310 100 83 163 1 2011061744 27017488 23545392
23:38:05 1794 8192000000 10917971200 11339096064 1948736368 19.216 99 66 131 0 1995542528 27360992 19445168
23:38:14 2136 8192000000 10894119008 11312205824 1933611040 19.096 100 81 161 2 1984093680 27110720 23371920
23:38:24 2258 8192000000 10894312240 11304734720 1928473248 19.055 100 76 151 0 1980456992 29199904 22783840
23:38:36 3009 8192000000 10884474400 11289296896 1898701376 18.816 98 78 154 2 1952106752 30562368 22843008
23:38:47 4621 8192000000 10908400400 11313946624 1934889264 19.106 100 76 152 1 1990381136 32270336 23221536
23:38:59 2084 8192000000 10914927264 11320451072 1939906272 19.146 100 85 170 2 1997026880 30982496 26138112
23:39:07 5246 8192000000 10908164368 11317141504 1940015392 19.147 100 78 156 0 1996162736 31693472 24453872
23:39:21 1542 8192000000 10925687840 11326369792 1948650048 19.216 100 89 174 3 2006073264 31079856 26343360
23:39:29 3562 8192000000 10909539888 11314540544 1930916384 19.074 99 74 147 0 1986049312 31778592 23354336
23:39:41 2518 8192000000 10912871232 11319541760 1921159024 18.996 99 78 157 1 1978897824 33234368 24504432
23:39:51 6511 8192000000 10924010176 11333066752 1949088992 19.219 100 77 153 2 2006843472 33754432 24000048
23:40:04 4843 8192000000 10897923376 11304173568 1921862320 19.002 99 80 160 2 1981465008 34036304 25566384
23:40:16 1373 8192000000 10930203168 11331723264 1947946944 19.210 100 90 180 0 2011019024 34758336 28313744
23:40:25 3745 8192000000 10924512304 11335032832 1942514384 19.167 100 79 158 0 2004123696 37085952 24523360
23:40:37 1286 8192000000 10927561712 11340759040 1947417648 19.206 100 80 159 1 2009126784 37166128 24543008
23:40:45 1662 8192000000 10936111600 11344465920 1951706288 19.240 100 93 186 2 2019386528 37300576 30379664
23:40:54 4191 8192000000 10905538224 11323809792 1927836112 19.050 99 72 143 1 1982802272 33034256 21931904
23:41:14 15962 8192000000 10890371632 11322662912 1923674016 19.016 99 40 80 2 1968089056 31423728 12991312
23:41:38 4768 8192000000 10905595696 11325571072 1923655088 19.016 99 64 126 0 1980935600 38025504 19255008
23:41:52 1773 8192000000 10912706992 11310735360 1922223984 19.005 99 88 176 2 1986096944 36107872 27765088
23:42:00 5095 8192000000 10908492528 11327799296 1932459344 19.087 100 56 111 3 1987810640 38107936 17243360
23:42:16 12827 8192000000 10887093728 11321778176 1917614592 18.968 99 31 62 2 1964745456 35892624 11238240
23:42:37 2704 8192000000 10900652896 11331170304 1938565440 19.135 100 55 108 1 1990146544 33337376 18243728
23:42:50 13768 8192000000 10846702864 11281948672 1870144784 18.585 97 32 64 1 1912923152 32062912 10715456
23:43:14 11079 8192000000 10850913440 11281842176 1871046080 18.593 98 33 64 1 1910127472 28712656 10368736
23:43:49 21812 8192000000 10857946240 11299934208 1909374688 18.902 100 22 44 2 1949083808 32288752 7420368
23:44:22 7944 8192000000 10870136704 11302670336 1910512176 18.911 100 37 74 1 1955217536 31964560 12740800
23:44:36 10593 8192000000 10881423136 11309916160 1913695728 18.936 100 28 56 0 1958477056 35138160 9643168
23:44:53 2365 8192000000 10869637744 11292528640 1901140784 18.835 99 50 102 1 1955953248 38736480 16075984
23:45:02 6620 8192000000 10875763328 11309625344 1908045936 18.891 100 40 80 0 1961278384 40043392 13189056
23:45:15 12862 8192000000 10865813488 11293380608 1876889312 18.640 98 32 63 3 1925890208 38086928 10913968
23:45:51 12216 8192000000 10883736848 11304919040 1880479744 18.669 98 51 102 0 1935296080 38070480 16745856
23:46:10 19119 8192000000 10856117744 11306991616 1910924576 18.914 100 38 76 0 1958802928 35486992 12391360
23:46:38 18125 8192000000 10845419824 11281862656 1894808320 18.785 99 34 66 1 1924593488 19652528 10132640
23:47:04 43408 8192000000 10855788816 11301302272 1914419312 18.942 100 21 42 1 1939150128 18136416 6594400
23:47:55 30141 8192000000 10865482944 11315679232 1924455888 19.023 100 29 55 2 1953874208 21084944 8333376
23:48:33 19612 8192000000 10846305056 11294302208 1902663120 18.848 99 22 44 0 1933832544 23944368 7225056
23:49:00 28801 8192000000 10864633760 11321774080 1918924480 18.978 100 13 26 0 1948062880 24716736 4421664
23:49:39 20093 8192000000 10862278944 11330207744 1906729872 18.880 99 14 28 0 1939493072 28513264 4249936
23:50:09 23356 8192000000 10880218928 11318878208 1928579168 19.056 100 23 46 0 1952691216 17316496 6795552
23:50:43 54081 8192000000 10888816160 11314384896 1896445840 18.798 98 30 59 1 1914880784 10058128 8376816
23:51:49 46601 8192000000 10880307968 11323842560 1921927568 19.002 99 20 39 2 1941757264 14098512 5731184
23:52:47 42734 8192000000 10881618272 11334234112 1947526416 19.207 100 37 72 2 1968165856 10649712 9989728
23:53:37 63899 8192000000 10876674976 11353649152 1925940432 19.034 99 12 24 0 1943534432 13917328 3676672
23:55:01 74707 8192000000 10898659072 11349954560 1938630384 19.136 99 24 46 0 1962734960 18022992 6081584
23:56:29 14602 8192000000 10896370016 11348520960 1961531536 19.318 100 29 56 1 1977609600 7990112 8087952
23:56:55 35229 8192000000 10895558224 11361718272 1968019440 19.370 100 18 36 0 1982619200 9717744 4882016
23:57:59 51149 8192000000 10901623888 11350061056 1958873008 19.297 100 10 20 0 1970140928 9034176 2233744
23:59:20 93155 8192000000 10909598304 11379478528 1967937424 19.369 99 14 28 1 1988779392 17016144 3825824
00:02:12 30109 8192000000 10930149632 11384008704 1991210704 19.553 100 48 95 0 2019246880 15132480 12903696
00:02:53 15788 8192000000 10913321808 11387691008 1989327264 19.538 100 19 38 1 2008865024 14440928 5096832
00:03:16 26147 8192000000 10929149664 11389124608 1997388640 19.602 100 22 44 0 2014418128 10661552 6367936
00:03:49 39457 8192000000 10930493184 11388243968 1991915344 19.559 100 16 32 0 2008214528 10936000 5363184
00:04:42 51279 8192000000 10944283424 11406462976 2005639024 19.667 100 39 78 1 2031146080 14369936 11137120
00:05:47 46806 8192000000 10932763024 11406737408 2006830672 19.677 100 25 50 1 2034050304 19330368 7889264
00:06:41 56626 8192000000 10949160880 11418828800 2009133696 19.695 100 8 16 0 2027708656 15328096 3246864
00:08:29 74707 8192000000 10875414160 11340218368 1929790480 19.065 96 15 30 0 1949256464 15079120 4386864
00:10:19 46393 8192000000 10938901936 11409084416 1998695904 19.612 100 12 24 1 2028118512 25365456 4057152
00:11:39 75663 8192000000 10899281632 11391344640 1941709072 19.160 97 13 25 0 1960102400 14484928 3908400
00:13:05 42157 8192000000 10912399904 11381035008 1986329104 19.515 100 13 26 1 2000681600 10438016 3914480
00:14:10 56373 8192000000 10906560384 11385475072 1985776448 19.510 100 10 20 1 1998662320 10208640 2677232
00:15:51 40872 8192000000 10924183104 11399380992 1950111120 19.227 97 17 34 0 1970883680 16008880 4763680
00:16:40 41455 8192000000 10928896032 11390984192 1964231792 19.340 98 29 58 1 1986645728 13926992 8486944
00:17:37 101746 8192000000 10899773056 11385380864 1810529488 18.100 91 13 26 0 1835160416 20795616 3835312
00:19:28 44017 8192000000 10883958000 11347537920 1910346368 18.909 97 32 64 1 1928000800 8970592 8683840
00:20:25 72073 8192000000 10867320736 11329261568 1830972784 18.267 93 11 22 0 1846530240 12320608 3236848
00:21:56 55299 8192000000 10871280048 11331510272 1894929872 18.785 97 30 60 1 1918864192 14858208 9076112
00:23:28 59752 8192000000 10843847680 11323322368 1835317872 18.303 95 9 18 0 1850859440 13266944 2274624
00:24:50 48922 8192000000 10864983008 11318202368 1884424656 18.701 98 23 46 1 1906487760 15409696 6653408
00:25:45 33835 8192000000 10864195696 11311689728 1889333216 18.740 98 42 85 1 1913489088 12954992 11200880
00:26:27 47098 8192000000 10856329968 11309019136 1853186288 18.448 96 29 58 0 1872344368 11053408 8104672
00:27:21 40446 8192000000 10895693136 11340132352 1924303312 19.021 99 24 48 2 1941825760 11063376 6459072
00:28:10 121698 8192000000 10874280560 11319332864 1888618048 18.735 97 29 58 0 1911937520 15096752 8222720
00:30:20 47551 8192000000 10882028976 11342401536 1949707360 19.224 100 25 50 2 1967410672 10267520 7435792
00:31:15 62325 8192000000 10825478032 11304181760 1825877344 18.226 94 20 40 2 1844888448 13228416 5782688
00:32:24 44883 8192000000 10829383984 11308019712 1900803888 18.833 99 5 10 0 1911425392 9447744 1173760
00:33:18 25311 8192000000 10803461792 11269570560 1842717280 18.363 96 9 18 1 1853810160 8554896 2537984
00:34:03 46008 8192000000 10826619200 11296534528 1894324000 18.781 99 12 22 0 1904554112 7420144 2809968
00:35:45 67679 8192000000 10835883808 11316809728 1903205648 18.852 99 16 32 0 1920006720 11353024 5448048
00:37:25 42316 8192000000 10852474032 11315757056 1911271584 18.917 99 9 18 0 1924795648 10743664 2780400
00:38:24 42361 8192000000 10874529712 11334864896 1922839840 19.010 99 21 42 0 1943429184 14683056 5906288
00:39:18 58418 8192000000 10889997888 11357155328 1922479888 19.007 98 38 76 0 1956990928 23228240 11282800
00:40:30 73645 8192000000 10892937632 11378081792 1934862848 19.106 99 16 32 0 1967793648 27584672 5346128
00:42:08 60542 8192000000 10881727440 11348606976 1946545152 19.199 100 13 26 0 1966548592 16589424 3414016
00:43:15 49613 8192000000 10887236480 11355828224 1958026592 19.290 100 19 37 3 1973274704 9858608 5389504
00:44:11 79150 8192000000 10890835600 11358900224 1903819488 18.857 97 31 62 0 1923851344 11582512 8449344
00:45:38 86400 8192000000 10875062400 11348717568 1913146896 18.932 98 11 22 0 1935419024 19225024 3047104
00:47:41 11607 8192000000 10930153584 11375190016 1956240288 19.276 99 50 100 0 1986849744 17164464 13444992
00:48:00 45064 8192000000 10907326656 11386126336 1953869840 19.257 99 39 78 1 1985567136 21011376 10685920
00:48:57 111514 8192000000 10896393280 11369758720 1968087456 19.370 100 18 35 1 1988022272 15301040 4633776
00:51:14 64027 8192000000 10881470800 11362443264 1953945328 19.258 99 24 48 1 1968399488 7437072 7017088
00:52:38 59119 8192000000 10884094304 11367530496 1950806112 19.233 99 10 20 2 1967303312 13599488 2897712
00:53:50 95837 8192000000 10895238032 11370106880 1945042272 19.187 99 11 22 0 1961330976 13254192 3034512
00:55:32 71611 8192000000 10877204976 11362353152 1914633456 18.944 97 14 28 0 1937794992 18313248 4848288
00:56:50 66105 8192000000 10899686624 11383812096 1964053792 19.338 100 10 20 0 1982232304 15461792 2716720
00:58:03 109137 8192000000 10903190576 11395219456 1982758928 19.487 100 15 30 1 2002023984 15640832 3624224
00:59:58 22780 8192000000 10914359696 11385577472 1988216464 19.530 100 15 30 1 1998266928 6482896 3567568
01:00:27 38637 8192000000 10935900032 11404353536 1997388976 19.602 100 25 48 1 2010701856 6874000 6438880
01:01:12 33462 8192000000 10917985248 11378647040 1953717856 19.256 98 27 54 1 1970773216 9328080 7727280
01:01:57 78810 8192000000 10908840816 11364331520 1927871472 19.050 97 18 36 0 1942436880 9148240 5417168
01:03:23 38975 8192000000 10899155632 11353640960 1899166816 18.820 96 30 60 0 1916342912 8899488 8276608
01:04:14 16957 8192000000 10929867440 11376799744 1977999504 19.449 100 63 127 0 2007498880 11007872 18491504
01:04:40 35563 8192000000 10906108816 11376582656 1957399680 19.285 99 30 60 0 1977438016 11778480 8259856
01:05:24 50767 8192000000 10877812656 11354546176 1855642720 18.468 94 22 44 1 1872330528 10913328 5774480
01:06:26 56178 8192000000 10873931648 11355840512 1905943696 18.874 97 14 28 1 1928493552 18615008 3934848
01:07:33 66689 8192000000 10878283344 11358027776 1935052672 19.107 99 12 24 0 1950491056 12100528 3337856
01:08:51 54332 8192000000 10865074192 11337428992 1880544144 18.670 96 26 50 1 1896145408 8411344 7189920
01:09:55 35540 8192000000 10880292912 11336536064 1924888896 19.026 99 18 36 0 1937743040 8014496 4839648
01:10:38 30316 8192000000 10903988560 11360018432 1945066368 19.187 99 42 84 2 1966958160 9630544 12261248
01:11:20 63347 8192000000 10887162880 11358318592 1906887184 18.882 97 14 28 0 1924594256 13809280 3897792
01:12:36 114268 8192000000 10860625808 11332345856 1863203264 18.529 95 22 44 0 1877395376 7635664 6556448
01:14:37 61680 8192000000 10850602128 11325575168 1862969984 18.527 96 18 37 1 1880314896 11777248 5567664
01:16:18 96656 8192000000 10851879488 11329990656 1889118304 18.739 97 12 24 0 1904657856 12029648 3509904
01:18:01 49614 8192000000 10859300448 11337089024 1919251200 18.981 99 15 28 0 1937940432 13792992 4896240
01:18:57 44094 8192000000 10872985664 11338010624 1912439680 18.926 98 18 36 1 1927132192 9116416 5576096
01:19:52 89343 8192000000 10859562208 11334262784 1892360240 18.765 97 14 28 0 1907288704 10582048 4346416
01:21:35 51414 8192000000 10825607136 11308777472 1858456960 18.491 96 7 14 2 1872826176 12344464 2024752
01:22:32 79980 8192000000 10832830208 11296243712 1823564864 18.207 94 21 42 0 1842142256 12765312 5812080
01:24:10 39907 8192000000 10840451424 11307270144 1899882112 18.825 99 22 44 0 1918865376 12663888 6319376
01:24:57 73843 8192000000 10842759840 11316658176 1882240064 18.683 98 16 32 1 1899173200 12432688 4500448
01:26:18 28048 8192000000 10869570272 11327479808 1919395584 18.982 99 43 86 0 1939978672 8192784 12390304
01:26:52 29390 8192000000 9156141696 9438437376 276038864 3.259 15 6 12 0 283861616 6614304 1208448

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 09-12-2020 01:28:21 to 09-12-2020 01:28:51.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 121 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-12-2020 01:28:52 to 09-12-2020 01:28:54.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          249058
MON$OLDEST_ACTIVE               249059
MON$OLDEST_SNAPSHOT             249059
MON$NEXT_TRANSACTION            249059
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                       2043680
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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 ---
:217: 
:218: mscs-test-161.budzdorov.ru    Wed Dec  9 01:27:23 2020
:219:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:220: 
--- end of diff output ---

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

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