Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.11.2020 22: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 17363584 kB
MemAvailable 31462096 kB
Buffers 0 kB
Cached 14312088 kB
SwapCached 2864 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.7
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-11-04 22:27:01
DTS_END                         2020-11-04 22:27:01.3000
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/37260
TRN_ID                          249557
ATT_ID                          650
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: 9509.86 21772 1141183
customer order: creation 183.01 369 21961
customer order: refuse 15.38 384 1846
order to supplier: creation 48.38 1251 5806
order to supplier: removal 3.27 113816 392
invoice (draft): creation 47.46 3384 5695
invoice (draft): removal 52.26 861 6271
invoice accept: apply 44.29 17422 5315
invoice accept: cancel 46.87 830 5624
customer reserve: creation 4128.13 171 495376
customer reserve: removal 4631.67 63 555800
realization accept: apply 85.46 176 10255
realization accept: cancel 86.83 111 10419
payment from customer: creation 63.13 116 7575
payment from customer: removal 5.76 50 691
payment to supplier: creation 51.08 145 6130
payment to supplier: removal 3.71 73 445
service: total inventory turnovers 4.99 1238 599
service: total monetary turnovers 7.16 47 859
service: aggregate perf. data 1.00 14848 120
service: refresh index statistics 0.03 280077 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-11-2020 22:28:13 to 04-11-2020 22:28:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5041
TEST_TIME 2 3917
TEST_TIME 3 4421
TEST_TIME 4 5006
TEST_TIME 5 5083
TEST_TIME 6 5795
TEST_TIME 7 5980
TEST_TIME 8 5624
TEST_TIME 9 5707
TEST_TIME 10 5632
TEST_TIME 11 5729
TEST_TIME 12 5939
TEST_TIME 13 6091
TEST_TIME 14 6280
TEST_TIME 15 6422
TEST_TIME 16 6789
TEST_TIME 17 7269
TEST_TIME 18 7860
TEST_TIME 19 7879
TEST_TIME 20 8027
TEST_TIME 21 8323
TEST_TIME 22 8403
TEST_TIME 23 8455
TEST_TIME 24 8726
TEST_TIME 25 8800
TEST_TIME 26 9946
TEST_TIME 27 10745
TEST_TIME 28 11459
TEST_TIME 29 11385
TEST_TIME 30 11535
TEST_TIME 31 11302
TEST_TIME 32 11366
TEST_TIME 33 11326
TEST_TIME 34 11143
TEST_TIME 35 10856
TEST_TIME 36 10774
TEST_TIME 37 10858
TEST_TIME 38 10829
TEST_TIME 39 10626
TEST_TIME 40 10599
TEST_TIME 41 10502
TEST_TIME 42 10429
TEST_TIME 43 10440
TEST_TIME 44 10552
TEST_TIME 45 10450
TEST_TIME 46 10365
TEST_TIME 47 10325
TEST_TIME 48 10182
TEST_TIME 49 10098
TEST_TIME 50 10029
TEST_TIME 51 9974
TEST_TIME 52 9984
TEST_TIME 53 9994
TEST_TIME 54 10052
TEST_TIME 55 10070
TEST_TIME 56 10082
TEST_TIME 57 10087
TEST_TIME 58 10035
TEST_TIME 59 10202
TEST_TIME 60 10218
TEST_TIME 61 10210
TEST_TIME 62 10263
TEST_TIME 63 10202
TEST_TIME 64 10212
TEST_TIME 65 10095
TEST_TIME 66 10058
TEST_TIME 67 9993
TEST_TIME 68 9956
TEST_TIME 69 9866
TEST_TIME 70 9775
TEST_TIME 71 9807
TEST_TIME 72 9790
TEST_TIME 73 9800
TEST_TIME 74 9861
TEST_TIME 75 9839
TEST_TIME 76 9822
TEST_TIME 77 9794
TEST_TIME 78 9825
TEST_TIME 79 9907
TEST_TIME 80 9904
TEST_TIME 81 9937
TEST_TIME 82 10032
TEST_TIME 83 9989
TEST_TIME 84 10014
TEST_TIME 85 9909
TEST_TIME 86 9894
TEST_TIME 87 9830
TEST_TIME 88 9841
TEST_TIME 89 9817
TEST_TIME 90 9765
TEST_TIME 91 9722
TEST_TIME 92 9647
TEST_TIME 93 9682
TEST_TIME 94 9675
TEST_TIME 95 9704
TEST_TIME 96 9693
TEST_TIME 97 9673
TEST_TIME 98 9702
TEST_TIME 99 9729
TEST_TIME 100 9702
TEST_TIME 101 9758
TEST_TIME 102 9746
TEST_TIME 103 9733
TEST_TIME 104 9782
TEST_TIME 105 9744
TEST_TIME 106 9812
TEST_TIME 107 9791
TEST_TIME 108 9753
TEST_TIME 109 9701
TEST_TIME 110 9702
TEST_TIME 111 9690
TEST_TIME 112 9665
TEST_TIME 113 9621
TEST_TIME 114 9595
TEST_TIME 115 9580
TEST_TIME 116 9629
TEST_TIME 117 9632
TEST_TIME 118 9611
TEST_TIME 119 9592
TEST_TIME 120 9512

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-11-2020 22:28:16 to 04-11-2020 22:28:20.

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 1597762 1597762 0 0.00 0 19042 6 0 0
doc_list_biud 1597758 1597758 0 0.00 0 59951 28 0 0
sp_add_invoice_to_stock 5439 5315 124 2.27 40 196531 17422 0 124
sp_cancel_adding_invoice 5624 5624 0 0.00 4 104429 830 0 0
sp_cancel_client_order 1846 1846 0 0.00 4 13903 385 0 0
sp_cancel_customer_reserve 555800 555800 0 0.00 1 59952 64 0 0
sp_cancel_pay_from_customer 691 691 0 0.00 3 2885 50 0 0
sp_cancel_pay_to_supplier 445 445 0 0.00 2 2816 73 0 0
sp_cancel_supplier_invoice 6283 6271 12 0.19 1 33393 861 0 12
sp_cancel_supplier_order 392 392 0 0.00 6 1201338 113817 0 0
sp_cancel_write_off 10419 10419 0 0.00 1 19893 112 0 0
sp_client_order 21961 21961 0 0.00 3 23737 369 0 0
sp_customer_reserve 495376 495376 0 0.00 0 35345 171 0 0
sp_fill_shopping_cart 33456 33456 0 0.00 1 15899 35 0 0
sp_fill_shopping_cart_clo_res 495367 495367 0 0.00 0 26023 15 0 0
sp_get_clo_for_invoice 5306 5306 0 0.00 0 31954 297 0 0
sp_kill_cost_storno 17179 17179 0 0.00 0 7803 55 0 0
sp_kill_qstorno_ret_qs2qd 1128682 1128682 0 0.00 0 59947 35 0 0
sp_kill_qty_storno 595909 595909 0 0.00 0 59950 74 0 0
sp_lock_selected_doc 21539 21539 0 0.00 0 7467 5 0 0
sp_make_cost_storno 29266 29266 0 0.00 0 17190 52 0 0
sp_multiply_rows_for_pdistr 29265 29265 0 0.00 0 14067 32 0 0
sp_multiply_rows_for_qdistr 21961 21961 0 0.00 0 14003 161 0 0
sp_pay_from_customer 7575 7575 0 0.00 4 14063 117 0 0
sp_pay_to_supplier 6130 6130 0 0.00 4 16243 146 0 0
sp_payment_common 13705 13705 0 0.00 1 12528 32 0 0
sp_qd_handle_on_cancel_clo 1846 1846 0 0.00 0 13895 348 0 0
sp_qd_handle_on_invoice_upd_sts 10926 10926 0 0.00 0 16114 321 0 0
sp_qd_handle_on_reserve_upd_sts 10255 10255 0 0.00 0 15120 63 0 0
sp_reserve_write_off 10255 10255 0 0.00 6 15238 176 0 0
sp_supplier_invoice 5695 5695 0 0.00 7 80045 3385 0 0
sp_supplier_order 5806 5806 0 0.00 5 34896 1252 0 0
srv_aggregate_perf_data 121 120 1 0.82 2198 155784 14848 0 1
srv_fill_mon_cache_memory 175 175 0 0.00 1043 122376 30773 0 0
srv_find_qd_qs_mism 1089419 1089419 0 0.00 0 19041 5 0 0
srv_make_invnt_saldo 599 599 0 0.00 52 72882 1238 0 0
srv_make_money_saldo 859 859 0 0.00 0 17267 48 0 0
srv_recalc_idx_stat 4 4 0 0.00 204865 363785 280077 0 0
t$perf-abend:sp_add_invoice_to_stock 124 124 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 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 5316 5316 0 0.00 0 18407 164 0 0
t$perf-norm:sp_cancel_adding_invoice 411 411 0 0.00 0 2310 90 0 0
t$perf-norm:sp_cancel_client_order 1846 1846 0 0.00 0 8281 27 0 0
t$perf-norm:sp_cancel_customer_reserve 726 726 0 0.00 0 3428 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 691 691 0 0.00 0 329 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 445 445 0 0.00 0 3911 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 442 442 0 0.00 0 346 5 0 0
t$perf-norm:sp_cancel_supplier_order 392 392 0 0.00 0 30497 1696 0 0
t$perf-norm:sp_cancel_write_off 1030 1030 0 0.00 0 1877 6 0 0
t$perf-norm:sp_client_order 21961 21961 0 0.00 0 8886 17 0 0
t$perf-norm:sp_customer_reserve 1113 1113 0 0.00 0 3029 7 0 0
t$perf-norm:sp_pay_from_customer 7575 7575 0 0.00 0 4274 9 0 0
t$perf-norm:sp_pay_to_supplier 6130 6130 0 0.00 0 8790 13 0 0
t$perf-norm:sp_reserve_write_off 10255 10255 0 0.00 0 6226 10 0 0
t$perf-norm:sp_supplier_invoice 5695 5695 0 0.00 0 10166 19 0 0
t$perf-norm:sp_supplier_order 5806 5806 0 0.00 0 4267 16 0 0
t$perf-norm:srv_aggregate_perf_data 120 120 0 0.00 0 491 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 175 175 0 0.00 0 1086 11 0 0
t$perf-norm:srv_make_invnt_saldo 599 599 0 0.00 0 753 19 0 0
t$perf-norm:srv_make_money_saldo 859 859 0 0.00 0 933 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 4 0 0
v_add_invoice_to_stock 10852 10604 248 2.28 0 15898 21 0 248
v_all_customers 40536 40536 0 0.00 0 58 1 0 0
v_all_suppliers 32084 32084 0 0.00 0 16 1 0 0
v_all_wares 43922 43922 0 0.00 0 31 1 0 0
v_cancel_adding_invoice 822 822 0 0.00 0 454 5 0 0
v_cancel_client_order 3692 3692 0 0.00 0 6209 11 0 0
v_cancel_customer_prepayment 1382 1382 0 0.00 0 714 3 0 0
v_cancel_customer_reserve 1452 1452 0 0.00 0 6981 10 0 0
v_cancel_payment_to_supplier 890 890 0 0.00 0 1962 8 0 0
v_cancel_supplier_invoice 908 884 24 2.64 0 2908 19 0 24
v_cancel_supplier_order 784 784 0 0.00 0 188 3 0 0
v_cancel_write_off 2060 2060 0 0.00 0 2885 18 0 0
v_max_id_clo_ord 5802 5802 0 0.00 0 2393 2 0 0
v_max_id_clo_res 1113 1113 0 0.00 0 3509 13 0 0
v_max_id_ord_sup 5693 5693 0 0.00 0 7765 8 0 0
v_max_non_paid_invoice 1583 1583 0 0.00 0 306 2 0 0
v_max_non_paid_realizn 3747 3747 0 0.00 0 6279 6 0 0
v_min_id_clo_ord 5802 5802 0 0.00 0 4866 6 0 0
v_min_id_clo_res 1113 1113 0 0.00 0 2467 7 0 0
v_min_id_ord_sup 5693 5693 0 0.00 0 4515 7 0 0
v_min_non_paid_invoice 6130 6130 0 0.00 0 12121 20 0 0
v_min_non_paid_realizn 7575 7575 0 0.00 0 6911 20 0 0
v_our_firm 11042 11042 0 0.00 0 18 1 0 0
v_reserve_write_off 20508 20508 0 0.00 0 3252 6 0 0
x_lock_depdocs_on_canc_invoice 11453 11453 0 0.00 0 27215 109 0 0
x_lock_depdocs_on_canc_sup_ord 392 392 0 0.00 0 7762 357 0 0
x_make_qstorno_1000_1200 5806 5806 0 0.00 2 34879 1180 0 0
x_make_qstorno_1200_2000 5695 5695 0 0.00 2 79980 3254 0 0
x_make_qstorno_2100_3300 495376 495376 0 0.00 0 28412 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-11-2020 22:28:21 to 04-11-2020 22:28:25.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:05 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:11 19975 8192000000 10262608896 10576609280 928304320 10.178 72 54 111 1 948050304 2472016 17273968
19:57:39 28934 8192000000 10356864816 10673180672 1393969216 14.541 100 84 168 1 1426181904 5105008 27107680
19:58:25 30640 8192000000 10395642256 10721419264 1439429856 14.945 100 92 184 1 1476508288 7125040 29953392
19:59:07 10283 8192000000 10410013040 10734624768 1463778560 15.159 100 94 188 2 1502503248 8112784 30611904
19:59:27 22213 8192000000 10425723232 10754715648 1473261904 15.242 100 89 178 0 1510340688 8458576 28620208
20:00:06 24413 8192000000 10443197248 10775961600 1496899152 15.449 100 92 185 0 1535647456 9356528 29391776
20:00:38 22490 8192000000 10461715024 10800664576 1507202320 15.539 100 84 168 0 1543746592 9863888 26680384
20:01:11 15013 8192000000 10497889744 10846593024 1535839648 15.788 100 73 146 1 1568261248 9858736 22562864
20:01:34 16961 8192000000 10543680464 10894331904 1593164752 16.281 100 88 176 1 1631305136 11117920 27022464
20:02:01 17079 8192000000 10562645024 10916462592 1612842496 16.449 100 80 160 1 1649371216 11944304 24584416
20:02:27 8793 8192000000 10568717328 10929799168 1627680912 16.575 100 76 151 3 1662473264 11992368 22799984
20:02:45 13712 8192000000 10589787888 10952572928 1649738384 16.762 100 82 162 1 1686646416 12337296 24570736
20:03:09 8372 8192000000 10612676944 10980646912 1666688832 16.905 100 80 159 0 1702554976 12462448 23403696
20:03:24 10188 8192000000 10622308496 10999140352 1689479520 17.097 100 76 152 1 1723711200 11956112 22275568
20:03:43 8758 8192000000 10647094624 11018616832 1707164528 17.245 100 72 141 1 1739498464 11584416 20749520
20:04:00 8245 8192000000 10661994192 11038265344 1726569520 17.407 100 81 161 3 1761901424 12181568 23150336
20:04:16 6660 8192000000 10673484096 11052986368 1740428272 17.522 100 78 156 1 1775012928 12355984 22228672
20:04:31 5745 8192000000 10691714624 11070160896 1751098096 17.611 100 76 154 0 1784298224 11948528 21251600
20:04:43 6056 8192000000 10695922064 11077332992 1760154256 17.686 100 76 150 2 1793300016 12110800 21034960
20:04:56 4295 8192000000 10713334496 11094241280 1772431744 17.787 100 81 161 2 1807593888 12851632 22310512
20:05:10 5665 8192000000 10729015952 11110301696 1781734416 17.864 100 76 150 1 1815354208 12979392 20640400
20:05:22 9312 8192000000 10722536160 11112095744 1790677040 17.937 100 79 157 0 1826374992 14103280 21594672
20:05:41 7488 8192000000 10732391808 11118776320 1794683472 17.970 100 82 164 3 1832088528 14300272 23104784
20:05:55 4230 8192000000 10746578864 11135705088 1807272080 18.074 100 79 158 2 1843230784 12945264 23013440
20:06:06 3538 8192000000 10757434544 11141955584 1817331232 18.156 100 82 164 2 1853553136 13075008 23146896
20:06:15 3740 8192000000 10766087648 11149529088 1828217136 18.245 100 93 186 2 1868832672 13940688 26674848
20:06:26 3038 8192000000 10766561200 11152920576 1828538400 18.247 100 90 180 3 1867868704 13750496 25579808
20:06:36 4443 8192000000 10776645152 11161784320 1832935968 18.283 100 90 180 3 1871669696 14029168 24704560
20:06:47 3019 8192000000 10781586112 11171962880 1835283520 18.302 100 81 162 1 1875844000 18250160 22310320
20:06:56 2102 8192000000 10785606480 11170205696 1841441728 18.353 100 92 183 2 1880925792 13933168 25550896
20:07:05 2389 8192000000 10787609168 11171639296 1844109824 18.374 100 90 180 2 1883854672 13699472 26045376
20:07:14 1849 8192000000 10794140288 11180527616 1845986224 18.390 100 95 187 1 1886465344 14207152 26271968
20:07:22 1820 8192000000 10796293456 11180797952 1848908768 18.413 100 89 178 2 1888341920 14780928 24652224
20:07:31 2539 8192000000 10799992288 11186995200 1854412992 18.458 100 93 186 0 1896897392 16557904 25926496
20:07:40 1365 8192000000 10807731328 11192107008 1855963504 18.471 100 92 182 0 1896262480 14456624 25842352
20:07:48 1834 8192000000 10798663616 11190984704 1859131376 18.496 100 93 184 1 1898804000 12744128 26928496
20:07:57 6119 8192000000 10802345824 11194150912 1861370352 18.514 100 86 172 3 1898742800 12795088 24577360
20:08:09 1483 8192000000 10814105072 11200913408 1865280288 18.546 100 93 186 0 1905603424 13018192 27304944
20:08:17 2135 8192000000 10807975312 11197009920 1868340880 18.571 100 97 195 0 1909206880 13315408 27550592
20:08:26 2059 8192000000 10811003536 11198062592 1868375392 18.571 100 90 181 3 1906074576 12780992 24918192
20:08:34 1716 8192000000 10820150512 11207028736 1870927008 18.592 100 98 197 2 1913026928 13149376 28950544
20:08:42 2190 8192000000 10823284400 11211612160 1877093456 18.642 100 97 192 1 1918672512 13116288 28462768
20:08:50 24617 8192000000 10798197520 11209777152 1875062784 18.625 100 69 134 2 1903096896 8930992 19103120
20:09:21 1953 8192000000 10823095104 11226398720 1890521808 18.750 100 83 166 1 1923512432 8650208 24340416
20:09:30 4024 8192000000 10811109808 11218354176 1883146960 18.691 100 53 105 1 1905184144 7731200 14305984
20:09:42 4244 8192000000 10797841904 11219791872 1881918112 18.681 100 39 78 0 1901523840 8313584 11292144
20:09:55 4142 8192000000 10810074384 11224907776 1883393376 18.693 100 42 79 5 1902306848 7900352 11013120
20:10:08 6474 8192000000 10790116880 11219550208 1884094688 18.698 100 29 58 0 1899637904 7571184 7972032
20:10:25 5577 8192000000 10798518704 11222716416 1886739872 18.719 100 34 67 1 1903736656 7700832 9295952
20:10:38 5683 8192000000 10804609600 11227525120 1889592400 18.742 100 28 54 2 1903606400 7093024 6920976
20:10:51 16600 8192000000 10812703296 11232456704 1891175664 18.755 100 21 43 1 1904045936 6566544 6303728
20:11:15 58823 8192000000 10812396544 11243552768 1899144384 18.819 100 37 75 0 1915686544 5152336 11389824
20:12:20 4080 8192000000 10820039312 11249315840 1902771488 18.849 100 40 79 2 1921371936 7669952 10930496
20:12:31 7601 8192000000 10808038320 11249913856 1902757152 18.848 100 23 46 3 1916193056 6280240 7155664
20:12:46 5711 8192000000 10828771184 11260342272 1907560992 18.887 100 38 74 1 1927625568 10105040 9959536
20:12:58 6401 8192000000 10826984928 11258249216 1910925648 18.914 100 45 90 1 1931472592 8301680 12245264
20:13:11 3218 8192000000 10830259872 11259285504 1910653440 18.912 100 37 75 2 1928226096 7624512 9948144
20:13:23 5395 8192000000 10818180480 11256819712 1911866992 18.922 100 19 38 0 1922940544 5813104 5260448
20:13:35 5810 8192000000 10830135664 11266056192 1910373808 18.910 100 22 44 2 1926468656 10016240 6078608
20:13:50 9984 8192000000 10820607184 11260665856 1912774192 18.929 100 18 36 2 1924233856 5285264 6174400
20:14:06 5425 8192000000 10826378672 11259539456 1914864064 18.946 100 18 36 1 1925957104 5675696 5417344
20:14:19 6219 8192000000 10826458048 11265085440 1913293248 18.933 100 22 45 0 1925229248 5849344 6086656
20:14:32 10992 8192000000 10831170048 11265691648 1916007680 18.955 100 21 42 1 1928648656 6720992 5919984
20:14:51 3261 8192000000 10838094352 11269693440 1917992592 18.971 100 24 48 1 1931161216 6590064 6578560
20:15:01 8597 8192000000 10833049936 11262423040 1901544464 18.839 99 25 50 1 1913728096 5032800 7150832
20:15:18 8741 8192000000 10828369344 11266965504 1912537792 18.927 100 12 22 0 1925024688 9282688 3204208
20:15:35 10562 8192000000 10822035728 11260788736 1895906512 18.793 99 17 34 1 1906068608 5339248 4822848
20:15:57 23308 8192000000 10789221264 11224350720 1809197680 18.089 95 27 54 1 1823182464 5198928 8785856
20:16:50 28936 8192000000 10855959552 11259457536 1905870624 18.873 100 73 145 0 1934332208 6493648 21967936
20:17:25 2050 8192000000 10847436656 11269885952 1913988768 18.939 100 64 126 2 1942972480 10483232 18500480
20:17:33 3235 8192000000 10822237728 11248447488 1876397024 18.636 98 53 104 3 1897895344 6701312 14797008
20:17:45 5072 8192000000 10796082080 11214237696 1840004640 18.341 97 34 66 2 1855217360 6104064 9108656
20:17:56 6613 8192000000 10813689616 11240304640 1876851680 18.640 99 36 70 0 1895033424 8280608 9901136
20:18:09 6354 8192000000 10735459952 11151683584 1777239952 17.827 95 28 56 1 1791042112 5648704 8153456
20:18:23 4465 8192000000 10720077984 11138330624 1765503120 17.730 96 31 62 3 1785632656 10966096 9163440
20:18:34 12825 8192000000 10757461824 11157987328 1816087616 18.146 99 31 61 1 1830749632 5528048 9133968
20:18:54 44230 8192000000 10731144784 11159769088 1750702464 17.607 95 18 36 0 1761587024 5508720 5375840
20:19:46 5851 8192000000 10749625680 11169615872 1813496352 18.125 99 31 62 0 1829027424 6566480 8964592
20:19:59 5620 8192000000 10718987712 11141914624 1797318704 17.992 98 28 56 3 1812371488 7285024 7767760
20:20:12 6784 8192000000 10718778896 11134402560 1751429200 17.613 96 34 68 0 1767329664 5575888 10324576
20:20:25 6311 8192000000 10727102128 11143778304 1778200400 17.835 98 30 60 1 1793325584 6981120 8144064
20:20:38 3642 8192000000 10722674960 11134889984 1791865840 17.947 99 30 60 3 1807226000 6487424 8872736
20:20:49 4927 8192000000 10732649760 11148550144 1806425152 18.067 99 32 64 0 1821205648 4981376 9799120
20:21:01 6693 8192000000 10729713808 11132043264 1777445872 17.828 98 26 52 1 1790679600 6076160 7157568
20:21:15 7874 8192000000 10702713760 11125903360 1730283872 17.438 95 29 58 4 1747991344 10022912 7684560
20:21:30 6064 8192000000 10709060768 11130441728 1744012832 17.552 96 27 52 6 1756111440 5082096 7016512
20:21:44 5229 8192000000 10713910992 11133087744 1788177296 17.917 99 29 58 3 1803130496 5947344 9005856
20:21:58 10613 8192000000 10715428400 11128008704 1758351168 17.671 97 31 61 3 1773196160 4828976 10016016
20:22:16 9439 8192000000 10721719008 11140440064 1809296672 18.090 100 19 38 0 1819662368 4729040 5636656
20:22:33 61362 8192000000 10749762992 11172798464 1816286688 18.147 99 32 63 2 1831338768 4545312 10506768
20:23:42 20082 8192000000 10753936208 11172368384 1819673888 18.175 99 20 41 0 1830836880 5241648 5921344
20:24:09 7981 8192000000 10768506672 11188793344 1843162048 18.367 100 35 70 2 1868160992 15895968 9102976
20:24:30 4913 8192000000 10770672912 11184721920 1847304896 18.400 100 23 46 1 1859608720 6009552 6294272
20:24:41 7644 8192000000 10764154080 11190575104 1854119456 18.456 100 31 62 3 1869424880 5875712 9429712
20:24:56 8180 8192000000 10769259056 11196928000 1857804960 18.485 100 26 50 2 1870726016 6040464 6880592
20:25:11 5047 8192000000 10774324640 11194937344 1855408912 18.466 100 20 40 0 1868809088 6234160 7166016
20:25:22 9326 8192000000 10772045456 11196780544 1855638272 18.468 100 16 32 1 1865973232 5213312 5121648
20:25:41 11282 8192000000 10785601296 11205074944 1862607280 18.524 100 37 72 3 1878741296 5205200 10928816
20:26:00 15157 8192000000 10765289760 11202625536 1861971520 18.519 100 17 34 1 1873135232 5261472 5902240
20:26:22 10159 8192000000 10776365680 11210473472 1871029872 18.593 100 25 48 2 1883644256 6324704 6289680
20:26:44 10111 8192000000 10798206400 11217334272 1873282912 18.611 100 17 34 0 1884421168 6109936 5028320
20:27:07 25253 8192000000 10826616528 11239665664 1887821280 18.728 100 37 75 1 1907809776 10205280 9783216
20:27:42 20723 8192000000 10854789888 11263299584 1910304480 18.909 100 58 112 5 1933858928 8450608 15103840
20:28:10 85873 8192000000 10841512496 11272232960 1915258752 18.949 100 45 90 0 1941922144 13700512 12962880
20:30:06 14121 8192000000 10854216480 11283427328 1928478032 19.055 100 26 52 1 1946696576 10807840 7410704
20:30:31 13001 8192000000 10870324416 11297165312 1939619616 19.144 100 44 88 1 1969753408 17098224 13035568
20:30:52 6131 8192000000 10900455360 11310505984 1947682736 19.208 100 72 145 1 1981832192 13403680 20745776
20:31:06 30473 8192000000 10886465152 11313909760 1949798000 19.225 100 53 106 0 1979817600 14757472 15262128
20:31:43 1513 8192000000 10913663168 11325939712 1960147088 19.307 100 77 151 2 1998615280 16165680 22302512
20:31:52 2842 8192000000 10899364896 11323973632 1960200032 19.308 100 63 120 2 1994739728 16322960 18216736
20:32:01 4498 8192000000 10900133040 11324284928 1962139728 19.323 100 59 117 1 1994896800 15930544 16826528
20:32:13 10660 8192000000 10900531008 11330785280 1966412384 19.357 100 50 100 0 2000090128 19003936 14673808
20:32:34 8711 8192000000 10891983680 11313012736 1943160528 19.172 99 52 104 1 1977544816 18466416 15917872
20:32:57 24217 8192000000 10882870592 11320127488 1921919456 19.002 98 51 100 0 1959718176 21988128 15810592
20:33:29 18122 8192000000 10882959008 11310120960 1910188864 18.908 98 44 89 0 1947490816 23207920 14094032
20:33:59 7034 8192000000 10890838496 11318194176 1934947664 19.106 99 62 122 1 1979484976 25665424 18871888
20:34:14 12860 8192000000 10902948176 11328212992 1953280256 19.253 100 56 111 1 1993467024 23297200 16889568
20:34:37 13001 8192000000 10902972832 11332272128 1959637888 19.303 100 47 92 0 1995664976 21675552 14351536
20:34:59 11145 8192000000 10906245840 11336855552 1966939456 19.361 100 50 98 2 2003806160 21952192 14914512
20:35:23 19602 8192000000 10913509584 11346792448 1968210832 19.371 100 38 76 0 2002197840 22106368 11880640
20:35:52 14502 8192000000 10926755424 11356635136 1975790224 19.431 100 47 94 0 2016271840 26292656 14188960
20:36:16 21688 8192000000 10924885040 11353329664 1958429056 19.294 99 49 98 0 2004871808 31058272 15384480
20:36:52 13579 8192000000 10929789008 11357622272 1975255888 19.427 100 55 109 0 2023435888 31699296 16480704
20:37:16 8361 8192000000 10934268992 11360145408 1975804976 19.431 100 57 112 1 2026031200 32741184 17485040
20:37:37 4828 8192000000 10932660896 11361775616 1978553328 19.453 100 51 103 0 2025929248 31781920 15594000
20:37:50 2779 8192000000 10930866336 11342290944 1948236848 19.212 98 71 140 0 2001788768 32243744 21308176
20:38:08 9077 8192000000 10943569888 11373596672 1988526544 19.532 100 73 141 1 2045991824 36126496 21338784
20:38:24 4565 8192000000 10973338912 11394015232 1979972112 19.464 99 71 140 1 2039755952 38822480 20961360
20:38:39 8365 8192000000 10939406848 11359240192 1971862960 19.400 99 69 137 2 2032651952 39854032 20934960
20:39:02 11107 8192000000 10974970784 11396210688 1995187600 19.585 100 67 135 0 2056316816 40866976 20262240
20:39:21 8295 8192000000 10967257104 11395846144 1984769856 19.502 99 60 118 1 2044653728 41905728 17978144
20:39:37 2532 8192000000 10977143312 11399708672 2000531888 19.627 100 67 130 3 2064938816 44188976 20217952
20:39:47 6518 8192000000 10966120912 11394666496 1982622192 19.485 99 58 116 0 2046625696 45807792 18195712
20:40:03 2569 8192000000 10982188576 11405017088 2005825552 19.669 100 72 144 0 2074905376 46260864 22818960
20:40:13 5999 8192000000 10995099696 11417653248 2010721344 19.707 100 79 158 2 2083014272 48122048 24170880
20:40:27 3976 8192000000 11011408016 11427586048 2012521840 19.721 100 88 176 1 2094549856 55667536 26360480
20:40:38 1041 8192000000 11019200752 11429535744 2020504128 19.784 100 90 177 1 2099896832 52273760 27118944
20:40:47 6738 8192000000 11005305920 11429965824 2020000992 19.780 100 77 154 0 2095809616 52218144 23590480
20:41:04 2713 8192000000 11001908656 11414253568 2004840544 19.661 100 84 166 1 2083901504 53569824 25491136
20:41:13 3324 8192000000 10998902992 11413159936 2003859984 19.653 100 81 159 1 2084194352 56150384 24183984
20:41:24 3595 8192000000 10981265408 11395383296 1986434608 19.516 100 77 153 2 2066671952 56290880 23946464
20:41:38 2378 8192000000 10980122128 11396530176 1981738480 19.478 99 83 165 1 2063688432 56417328 25532624
20:41:48 2941 8192000000 10992234688 11405701120 1995261760 19.585 100 84 168 0 2079562080 57154624 27145696
20:41:58 1997 8192000000 10975329488 11387633664 1972405680 19.405 99 80 160 1 2055965840 58205456 25354704
20:42:08 2625 8192000000 10981993776 11395969024 1971692576 19.399 99 75 149 0 2054889232 59542832 23653824
20:42:19 5212 8192000000 11003190416 11416629248 1999417072 19.618 100 81 162 3 2087252736 62056064 25779600
20:42:31 4967 8192000000 11000891120 11423752192 1999761888 19.621 100 80 160 1 2089677056 64002512 25912656
20:42:45 8705 8192000000 10981365968 11409879040 1983639056 19.493 100 63 125 1 2068082016 63984800 20458160
20:43:00 4396 8192000000 10978676192 11399458816 1973491680 19.413 99 74 148 2 2060122880 62249312 24381888
20:43:12 5760 8192000000 10973932400 11404783616 1979231504 19.459 100 61 122 1 2062267104 62849296 20186304
20:43:28 9208 8192000000 10977800896 11403857920 1987145232 19.521 100 56 112 0 2061687696 56322560 18219904
20:43:45 2380 8192000000 10981249120 11394957312 1975954144 19.433 100 75 145 0 2058960912 59526112 23480656
20:43:55 5181 8192000000 10977396384 11392917504 1973352768 19.412 100 78 151 1 2058794640 60833056 24608816
20:44:08 3063 8192000000 10984304336 11400245248 1984287168 19.499 100 86 171 1 2069188976 57776000 27125808
20:44:17 2006 8192000000 10985788560 11403390976 1989925968 19.543 100 85 168 2 2072937184 56873264 26137952
20:44:28 7985 8192000000 10964016768 11379023872 1960275312 19.308 99 75 150 0 2040929328 57223568 23430448
20:44:44 2933 8192000000 10993124816 11407396864 1985575456 19.509 100 86 170 0 2071946352 59895200 26475696
20:44:56 6721 8192000000 10961201648 11411566592 1990658480 19.549 100 63 126 0 2070101760 59527408 19915872
20:45:21 6370 8192000000 10975483904 11412799488 1994408400 19.579 100 51 102 0 2058981296 48956272 15616624
20:45:35 5732 8192000000 10979712208 11411222528 1993215072 19.569 100 55 110 1 2064083984 53001808 17867104
20:45:49 1625 8192000000 10994367712 11412549632 1996078192 19.592 100 86 169 2 2075868640 54286816 25503632
20:45:58 2358 8192000000 11014087424 11427270656 2004847872 19.661 100 92 185 3 2089997840 56611200 28538768
20:46:08 3200 8192000000 10975633184 11391819776 1955746000 19.272 98 81 162 1 2041541248 61054128 24741120
20:46:18 3469 8192000000 10956561792 11390242816 1961533264 19.318 99 51 102 2 2034902080 57387024 15981792
20:46:29 5908 8192000000 10952605968 11389288448 1956188336 19.276 99 40 80 0 2025457056 56117696 13151024
20:46:42 4883 8192000000 10961901200 11388743680 1955088608 19.267 99 42 84 1 2025873040 57090112 13694320
20:47:04 1378 8192000000 10986019424 11394416640 1945358416 19.189 98 90 181 0 2034857776 61515136 27984224
20:47:12 2778 8192000000 10974265488 11394342912 1968907040 19.377 100 74 147 0 2055904384 64201872 22795472
20:47:25 9698 8192000000 10952712208 11394662400 1964359808 19.341 100 42 84 0 2040598928 62103984 14135136
20:47:54 10572 8192000000 10971231360 11402764288 1974136832 19.418 100 46 90 1 2053078432 64068512 14873088
20:48:12 2858 8192000000 10983513088 11393118208 1962457472 19.326 99 89 177 1 2056075696 64880656 28737568
20:48:24 1954 8192000000 10998783536 11415539712 1985465200 19.508 100 85 171 0 2080259536 67617824 27176512
20:48:33 8394 8192000000 10971996960 11405225984 1976314112 19.436 100 60 118 1 2062663776 67726592 18623072
20:49:04 14526 8192000000 10964951584 11400855552 1959864032 19.305 99 41 82 0 2036140192 62319072 13957088
20:49:27 9127 8192000000 10958022864 11399942144 1965970288 19.353 100 47 94 1 2047656704 65953648 15732768
20:49:43 14098 8192000000 10967242592 11399667712 1955918976 19.274 99 53 105 3 2038207856 64438912 17849968
20:50:07 5026 8192000000 10981106928 11409903616 1975055216 19.426 100 53 103 2 2058306592 66733696 16517680
20:50:23 12059 8192000000 10967400544 11407290368 1941193520 19.156 98 35 70 2 2022159008 68514688 12450800
20:50:45 13992 8192000000 10939868000 11378937856 1903350944 18.853 97 34 68 3 1989694096 73318704 13024448
20:51:05 23449 8192000000 10906546224 11344769024 1882939712 18.689 97 34 68 2 1968638208 73563536 12134960
20:51:45 22067 8192000000 10944361440 11380813824 1931053376 19.075 100 35 70 0 2022084224 77553808 13477040
20:52:17 17644 8192000000 10938337360 11382140928 1919623952 18.984 99 31 62 1 2006907200 76191392 11091856
20:52:48 18237 8192000000 10961730512 11413798912 1940725824 19.153 100 32 64 2 2040409088 87938432 11744832
20:53:13 28207 8192000000 10944813968 11416068096 1948795584 19.217 100 28 56 1 2047219872 86891328 11532960
20:54:00 24298 8192000000 10905605344 11375828992 1932850576 19.090 99 18 35 3 1993452992 54592096 6010320
20:55:20 30419 8192000000 10883721472 11363934208 1933123936 19.092 100 9 18 0 1978944736 42472800 3348000
20:56:04 43136 8192000000 10876507104 11348574208 1908096160 18.891 98 15 30 0 1938297920 25868640 4333120
20:56:54 38481 8192000000 10887310080 11344732160 1940330608 19.149 100 10 20 1 1963600848 20300512 2969728
20:57:39 40601 8192000000 10900915088 11341320192 1956137760 19.275 100 27 53 2 1979515200 14051296 9326144
20:58:26 67977 8192000000 10884792064 11337715712 1926009440 19.035 98 29 56 4 1943247152 9609616 7628096
20:59:59 92450 8192000000 10880625456 11335159808 1862552208 18.524 95 10 20 0 1877973664 13040192 2381264
21:01:38 122375 8192000000 10858915168 11314823168 1853504816 18.451 95 25 50 1 1869215104 9176544 6533744
21:03:47 111352 8192000000 10903022288 11362283520 1961761280 19.320 100 18 36 1 1982419296 15029920 5628096
21:05:50 19300 8192000000 10909922224 11358113792 1969886416 19.385 100 49 99 1 1992919040 9295056 13737568
21:06:15 33661 8192000000 10914126944 11364024320 1975334832 19.428 100 44 88 0 1998513696 9886080 13292784
21:06:55 15282 8192000000 10903499728 11358183424 1956680128 19.280 99 35 68 1 1973756832 7831184 9245520
21:07:17 4822 8192000000 10928271952 11366522880 1980050128 19.465 100 46 91 1 2000566752 7089264 13427360
21:07:29 10848 8192000000 10911846752 11369439232 1979802832 19.463 100 24 48 0 1994182768 7916352 6463584
21:08:03 64531 8192000000 10912436336 11378843648 1982883232 19.488 100 15 30 0 2000519904 13247936 4388736
21:09:13 29982 8192000000 10919840144 11391549440 1984312528 19.499 100 11 22 0 2003401744 15443232 3645984
21:09:55 44027 8192000000 10929188336 11377479680 1947406048 19.206 98 39 78 4 1975433712 16490784 11536880
21:10:51 39481 8192000000 10890022464 11377004544 1949344224 19.221 99 19 38 0 1976723648 21397168 5982256
21:11:36 14395 8192000000 10897302832 11381956608 1965367408 19.349 100 9 18 1 1985205024 17541776 2295840
21:11:59 6853 8192000000 10886102944 11366666240 1966413376 19.357 100 9 18 1 1976748752 8000432 2334944
21:12:12 34899 8192000000 10902040176 11370467328 1977264272 19.443 100 24 47 2 1993527600 9176416 7086912
21:13:02 39119 8192000000 10900814544 11378024448 1979359632 19.460 100 9 18 0 1989584832 7543232 2681968
21:13:47 43505 8192000000 10889272688 11359760384 1955480336 19.270 99 9 18 1 1966435344 8361456 2593552
21:14:53 27186 8192000000 10891296832 11363532800 1954295632 19.261 99 7 14 0 1963969168 8018336 1655200
21:15:26 76972 8192000000 10894131456 11362852864 1953913344 19.258 99 25 50 0 1968563680 7671472 6978864
21:16:50 49452 8192000000 10901633168 11383234560 1961044928 19.314 99 18 36 0 1975638048 9456368 5136752
21:18:02 2296 8192000000 10905256080 11388473344 1986458256 19.516 100 20 40 0 2002440432 10553328 5428848
21:18:11 36210 8192000000 10911235824 11393339392 1982592256 19.485 100 8 16 3 1994141712 9298976 2250480
21:18:56 53313 8192000000 10923122224 11398062080 1992298416 19.562 100 17 34 4 2009598256 12474400 4825440
21:19:56 54345 8192000000 10906405296 11382083584 1935055296 19.107 97 14 28 0 1951588192 12321040 4211856
21:20:59 27511 8192000000 10901045808 11371536384 1961476832 19.318 99 16 31 0 1979682368 13505088 4700448
21:21:40 29171 8192000000 10883246928 11351003136 1900950400 18.834 96 29 58 0 1918430640 9222608 8257632
21:22:21 26289 8192000000 10901211200 11352387584 1929780640 19.065 99 42 83 2 1958511280 17279536 11451104
21:22:55 16226 8192000000 10896762512 11353350144 1951207952 19.236 100 43 87 0 1975478624 12594800 11675872
21:23:21 20731 8192000000 10881143216 11342311424 1914925104 18.946 98 37 74 0 1941898224 16810496 10162624
21:23:50 43467 8192000000 10876849680 11354169344 1949373168 19.221 100 22 44 0 1965696560 10583472 5739920
21:24:41 15718 8192000000 10900918736 11347148800 1923473008 19.015 98 39 77 1 1942332640 7685696 11173936
21:25:03 43961 8192000000 10902627408 11359334400 1928831984 19.058 98 51 102 1 1955438336 12140624 14465728
21:25:54 39937 8192000000 10890244480 11369340928 1962343456 19.325 100 25 50 1 1986472528 16966752 7162320
21:26:40 108309 8192000000 10885117808 11360591872 1884464656 18.701 96 10 20 1 1898548416 12067152 2016608
21:28:35 35575 8192000000 10908802896 11368439808 1935746432 19.113 98 23 46 0 1949993984 7991968 6255584
21:29:19 54495 8192000000 10799171872 11246338048 1734476240 17.473 89 10 20 1 1747076592 9847344 2753008
21:30:25 25486 8192000000 10857627056 11298807808 1863749104 18.534 97 40 78 0 1883090016 8394432 10946480
21:30:58 33612 8192000000 10861921568 11318583296 1907951280 18.890 99 43 86 1 1930844144 11186400 11706464
21:31:40 96611 8192000000 10864839808 11318116352 1879852208 18.664 97 43 85 3 1901035328 9232768 11950352
21:33:26 56215 8192000000 10838571120 11307761664 1888868448 18.737 98 30 60 0 1909102192 11770144 8463600
21:34:29 34675 8192000000 10837430896 11318317056 1920310688 18.989 100 13 26 0 1935918464 11970848 3636928
21:35:15 70226 8192000000 10831338640 11301715968 1861861696 18.518 97 15 30 1 1876144640 10116384 4166560
21:36:38 70437 8192000000 10828505648 11302723584 1861390976 18.515 97 11 22 0 1874336960 9458560 3487424
21:38:04 67986 8192000000 10848702112 11327205376 1901210512 18.836 99 8 16 0 1917214688 13240432 2763744
21:39:18 50572 8192000000 10868722480 11337601024 1935297904 19.109 100 23 46 1 1953019808 11005152 6716752
21:40:15 37563 8192000000 10867259328 11341197312 1921564000 18.999 99 12 24 0 1936284560 11227664 3492896
21:41:07 72506 8192000000 10842080368 11311157248 1838563712 18.329 95 22 42 0 1860614336 15503248 6547376
21:42:27 25606 8192000000 10848930640 11299196928 1882379584 18.684 98 45 90 2 1903068064 8146336 12542144
21:42:59 12644 8192000000 10870049424 11320340480 1925555088 19.031 100 47 94 1 1948811056 10133088 13122880
21:43:22 32070 8192000000 10862466992 11310428160 1890093824 18.747 98 38 76 2 1911771872 10838464 10839584
21:44:21 56965 8192000000 10872463920 11334078464 1935520304 19.111 100 23 46 1 1956072144 14191872 6359968
21:45:27 71466 8192000000 10859976400 11329675264 1902940432 18.850 98 12 24 2 1921127056 14671456 3515168
21:46:45 93511 8192000000 10889609216 11356917760 1909304656 18.901 98 29 58 1 1927420496 10120464 7995376
21:48:29 58626 8192000000 10865930448 11342229504 1873097104 18.609 96 8 16 1 1893029088 17984656 1947328
21:49:34 80643 8192000000 10874104160 11340500992 1906774608 18.881 98 22 45 0 1930777872 18187840 5815424
21:51:03 78224 8192000000 10860251216 11334500352 1932367456 19.086 99 27 54 1 1957060064 16510480 8182128
21:52:59 80082 8192000000 10881450064 11358867456 1961687008 19.319 100 19 38 0 1979077488 12416800 4973680
21:54:26 28403 8192000000 10878532912 11356540928 1942046256 19.163 99 5 10 1 1957052192 13711856 1294080
21:55:01 39842 8192000000 10880555264 11363323904 1961227680 19.316 100 12 24 0 1976339056 11958096 3153280
21:55:52 51351 8192000000 10867478144 11349344256 1941128528 19.156 99 10 21 1 1951750272 7254960 3366784
21:56:49 74717 8192000000 10880501232 11350876160 1900783648 18.833 97 15 27 2 1912340992 7542960 4014384
21:58:11 59145 8192000000 10877199376 11346169856 1917963520 18.971 98 14 28 0 1930681840 8709504 4008816
21:59:18 61790 8192000000 10885146688 11357220864 1958535280 19.294 100 21 42 1 1981010384 16801664 5673440
22:00:29 86066 8192000000 10894090208 11366404096 1936205888 19.116 98 16 32 0 1958687600 17723920 4757792
22:02:04 95702 8192000000 10899457952 11370237952 1942343776 19.165 98 15 30 0 1955896896 9514624 4038496
22:03:46 52596 8192000000 10867086240 11333025792 1855959776 18.471 94 22 44 0 1873337696 11092176 6285744
22:04:50 47756 8192000000 10883640448 11359584256 1916036128 18.955 98 17 34 0 1931854432 10850480 4967824
22:05:48 47539 8192000000 10899886000 11367374848 1945591808 19.191 99 17 34 3 1959748416 8986864 5169744
22:06:43 47946 8192000000 10897548768 11371732992 1954037936 19.259 99 19 38 0 1970617360 11052960 5526464
22:07:39 88178 8192000000 10842763664 11313987584 1806381344 18.066 92 20 40 1 1823201504 11298720 5521440
22:09:16 54091 8192000000 10893354320 11350585344 1926186992 19.036 99 25 50 0 1943005232 10253472 6564768
22:10:17 49577 8192000000 10879676432 11348520960 1879010032 18.657 96 32 63 2 1908852448 20911440 8930976
22:11:18 52978 8192000000 10864594304 11328675840 1870757040 18.590 96 26 52 1 1888657088 10478240 7421808
22:12:20 20671 8192000000 10871451776 11321982976 1897164640 18.803 98 35 71 0 1919867728 13092640 9610448
22:12:57 86648 8192000000 10869763952 11335294976 1861819952 18.518 96 25 51 1 1882807552 14137984 6849616
22:14:30 31781 8192000000 10873110256 11323817984 1882011968 18.681 97 34 68 1 1899679952 7929536 9738448
22:15:10 97100 8192000000 10862594992 11323346944 1914697792 18.944 99 33 66 1 1932555744 7910992 9946960
22:16:53 89601 8192000000 10818282768 11291512832 1846310144 18.392 95 20 40 0 1861753280 9609584 5833552
22:18:33 13913 8192000000 10852750128 11330220032 1922474912 19.007 100 10 18 2 1937015376 12078768 2461696
22:19:29 42043 8192000000 10848838672 11325042688 1927968144 19.051 100 17 34 2 1945774704 12312624 5493936
22:20:18 53868 8192000000 10844338192 11318808576 1910627408 18.912 99 8 16 0 1925939024 13265200 2046416
22:21:18 59161 8192000000 10839610656 11316719616 1868642288 18.573 97 8 16 0 1884261552 13471120 2148144
22:22:27 47061 8192000000 10864889760 11344191488 1928232656 19.053 100 21 42 2 1949279040 14865200 6181184
22:23:41 71312 8192000000 10870287152 11351482368 1940031968 19.147 100 11 22 3 1956780000 13167984 3580048
22:25:07 29952 8192000000 10901662304 11366948864 1960940304 19.314 100 25 49 2 1977717104 10022240 6754560
22:26:06 61657 8192000000 9398149728 9693835264 548932128 6.280 28 4 8 0 557791152 7726944 1132080

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 04-11-2020 22:28:27 to 04-11-2020 22:29:00.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 124 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-11-2020 22:29:01 to 04-11-2020 22:29:03.

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          249839
MON$OLDEST_ACTIVE               249840
MON$OLDEST_SNAPSHOT             249840
MON$NEXT_TRANSACTION            249840
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                       2031648
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33385 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33385 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33385 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33385 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 ---
:16: 
:17: mscs-test-161.budzdorov.ru    Wed Nov  4 22:27:22 2020
:18:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:19: 
--- end of diff output ---

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

04.11.20 22:29:04. 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-11-04 22:29:06 No severe PSQL-related problems occured
04.11.20 22:29:07. End of report.