Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 09.02.2021 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 16851644 kB
MemAvailable 31179968 kB
Buffers 0 kB
Cached 14817608 kB
SwapCached 4872 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-09 01:27:15
DTS_END                         2021-02-09 01:27:15.0320
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/45478
TRN_ID                          240606
ATT_ID                          719
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: 9622.43 21699 1154692
customer order: creation 174.78 339 20973
customer order: refuse 15.61 356 1873
order to supplier: creation 47.33 1390 5680
order to supplier: removal 3.73 100803 448
invoice (draft): creation 48.02 3408 5762
invoice (draft): removal 55.15 876 6618
invoice accept: apply 42.32 16446 5078
invoice accept: cancel 50.10 789 6012
customer reserve: creation 3928.89 160 471467
customer reserve: removal 4948.67 59 593840
realization accept: apply 85.87 169 10304
realization accept: cancel 88.28 110 10594
payment from customer: creation 61.28 89 7353
payment from customer: removal 6.12 90 734
payment to supplier: creation 50.88 121 6105
payment to supplier: removal 3.42 74 410
service: total inventory turnovers 4.45 1336 534
service: total monetary turnovers 6.68 30 801
service: aggregate perf. data 0.85 20591 102
service: refresh index statistics 0.03 286738 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5971
TEST_TIME 2 4476
TEST_TIME 3 4573
TEST_TIME 4 4944
TEST_TIME 5 5667
TEST_TIME 6 6203
TEST_TIME 7 6428
TEST_TIME 8 6518
TEST_TIME 9 6664
TEST_TIME 10 6473
TEST_TIME 11 6838
TEST_TIME 12 6955
TEST_TIME 13 6877
TEST_TIME 14 6987
TEST_TIME 15 7441
TEST_TIME 16 7591
TEST_TIME 17 7777
TEST_TIME 18 7713
TEST_TIME 19 7900
TEST_TIME 20 7918
TEST_TIME 21 8055
TEST_TIME 22 8437
TEST_TIME 23 8789
TEST_TIME 24 8778
TEST_TIME 25 8943
TEST_TIME 26 9429
TEST_TIME 27 9608
TEST_TIME 28 10009
TEST_TIME 29 11419
TEST_TIME 30 11166
TEST_TIME 31 11136
TEST_TIME 32 10954
TEST_TIME 33 11043
TEST_TIME 34 10968
TEST_TIME 35 10829
TEST_TIME 36 10859
TEST_TIME 37 10722
TEST_TIME 38 10540
TEST_TIME 39 10381
TEST_TIME 40 10321
TEST_TIME 41 10333
TEST_TIME 42 10197
TEST_TIME 43 10123
TEST_TIME 44 10108
TEST_TIME 45 10124
TEST_TIME 46 10152
TEST_TIME 47 10256
TEST_TIME 48 10119
TEST_TIME 49 10160
TEST_TIME 50 10114
TEST_TIME 51 10102
TEST_TIME 52 10143
TEST_TIME 53 10016
TEST_TIME 54 9936
TEST_TIME 55 9915
TEST_TIME 56 9849
TEST_TIME 57 9805
TEST_TIME 58 9673
TEST_TIME 59 9599
TEST_TIME 60 9628
TEST_TIME 61 9618
TEST_TIME 62 9631
TEST_TIME 63 9619
TEST_TIME 64 9704
TEST_TIME 65 9736
TEST_TIME 66 9715
TEST_TIME 67 9790
TEST_TIME 68 9827
TEST_TIME 69 9837
TEST_TIME 70 9953
TEST_TIME 71 10000
TEST_TIME 72 9986
TEST_TIME 73 9971
TEST_TIME 74 9957
TEST_TIME 75 9949
TEST_TIME 76 9831
TEST_TIME 77 9779
TEST_TIME 78 9804
TEST_TIME 79 9777
TEST_TIME 80 9733
TEST_TIME 81 9729
TEST_TIME 82 9705
TEST_TIME 83 9711
TEST_TIME 84 9628
TEST_TIME 85 9580
TEST_TIME 86 9569
TEST_TIME 87 9593
TEST_TIME 88 9564
TEST_TIME 89 9570
TEST_TIME 90 9562
TEST_TIME 91 9599
TEST_TIME 92 9679
TEST_TIME 93 9650
TEST_TIME 94 9719
TEST_TIME 95 9704
TEST_TIME 96 9764
TEST_TIME 97 9856
TEST_TIME 98 9792
TEST_TIME 99 9785
TEST_TIME 100 9803
TEST_TIME 101 9812
TEST_TIME 102 9755
TEST_TIME 103 9708
TEST_TIME 104 9697
TEST_TIME 105 9657
TEST_TIME 106 9657
TEST_TIME 107 9606
TEST_TIME 108 9616
TEST_TIME 109 9589
TEST_TIME 110 9525
TEST_TIME 111 9516
TEST_TIME 112 9544
TEST_TIME 113 9536
TEST_TIME 114 9574
TEST_TIME 115 9593
TEST_TIME 116 9609
TEST_TIME 117 9575
TEST_TIME 118 9642
TEST_TIME 119 9663
TEST_TIME 120 9622

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-02-2021 01:28:09 to 09-02-2021 01:28:12.

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 1591873 1591873 0 0.00 0 17874 6 0 0
doc_list_biud 1591873 1591873 0 0.00 0 50903 28 0 0
sp_add_invoice_to_stock 5215 5078 137 2.62 32 144199 16446 0 137
sp_cancel_adding_invoice 6012 6012 0 0.00 5 72646 789 0 0
sp_cancel_client_order 1873 1873 0 0.00 4 8296 356 0 0
sp_cancel_customer_reserve 593840 593840 0 0.00 1 28588 60 0 0
sp_cancel_pay_from_customer 734 734 0 0.00 3 7768 91 0 0
sp_cancel_pay_to_supplier 410 410 0 0.00 3 5052 74 0 0
sp_cancel_supplier_invoice 6625 6618 7 0.10 1 12549 877 0 7
sp_cancel_supplier_order 448 448 0 0.00 12 1049886 100803 0 0
sp_cancel_write_off 10594 10594 0 0.00 1 15485 111 0 0
sp_client_order 20973 20973 0 0.00 3 18571 340 0 0
sp_customer_reserve 471467 471467 0 0.00 0 40861 160 0 0
sp_fill_shopping_cart 32406 32406 0 0.00 1 16957 38 0 0
sp_fill_shopping_cart_clo_res 471465 471465 0 0.00 0 13865 12 0 0
sp_get_clo_for_invoice 5076 5076 0 0.00 0 31070 301 0 0
sp_kill_cost_storno 17750 17750 0 0.00 0 7878 53 0 0
sp_kill_qstorno_ret_qs2qd 1205340 1205340 0 0.00 0 28580 33 0 0
sp_kill_qty_storno 634760 634760 0 0.00 0 50902 70 0 0
sp_lock_selected_doc 21457 21457 0 0.00 0 7798 6 0 0
sp_make_cost_storno 28833 28833 0 0.00 0 17856 54 0 0
sp_multiply_rows_for_pdistr 28833 28833 0 0.00 0 5077 25 0 0
sp_multiply_rows_for_qdistr 20973 20973 0 0.00 0 18563 147 0 0
sp_pay_from_customer 7353 7353 0 0.00 4 10777 90 0 0
sp_pay_to_supplier 6105 6105 0 0.00 5 16720 121 0 0
sp_payment_common 13458 13458 0 0.00 1 10255 21 0 0
sp_qd_handle_on_cancel_clo 1873 1873 0 0.00 0 8289 330 0 0
sp_qd_handle_on_invoice_upd_sts 11083 11083 0 0.00 0 50899 339 0 0
sp_qd_handle_on_reserve_upd_sts 10304 10304 0 0.00 0 17375 54 0 0
sp_reserve_write_off 10304 10304 0 0.00 6 17404 170 0 0
sp_supplier_invoice 5762 5762 0 0.00 6 90534 3408 0 0
sp_supplier_order 5680 5680 0 0.00 5 27901 1391 0 0
srv_aggregate_perf_data 103 102 1 0.97 3277 118855 20591 0 1
srv_fill_mon_cache_memory 174 174 0 0.00 1136 130936 30131 0 0
srv_find_qd_qs_mism 1106019 1106019 0 0.00 0 11997 5 0 0
srv_make_invnt_saldo 534 534 0 0.00 42 58863 1336 0 0
srv_make_money_saldo 801 801 0 0.00 1 888 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 253213 378274 286739 0 0
t$perf-abend:sp_add_invoice_to_stock 137 137 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 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 5078 5078 0 0.00 0 11311 177 0 0
t$perf-norm:sp_cancel_adding_invoice 434 434 0 0.00 1 8842 116 0 0
t$perf-norm:sp_cancel_client_order 1873 1873 0 0.00 0 5089 18 0 0
t$perf-norm:sp_cancel_customer_reserve 684 684 0 0.00 0 4435 26 0 0
t$perf-norm:sp_cancel_pay_from_customer 734 734 0 0.00 0 2722 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 410 410 0 0.00 0 1263 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 416 416 0 0.00 0 2309 19 0 0
t$perf-norm:sp_cancel_supplier_order 448 448 0 0.00 0 26537 1618 0 0
t$perf-norm:sp_cancel_write_off 1083 1083 0 0.00 0 1142 6 0 0
t$perf-norm:sp_client_order 20973 20973 0 0.00 0 8266 18 0 0
t$perf-norm:sp_customer_reserve 1053 1053 0 0.00 0 3218 12 0 0
t$perf-norm:sp_pay_from_customer 7353 7353 0 0.00 0 4620 7 0 0
t$perf-norm:sp_pay_to_supplier 6105 6105 0 0.00 0 5288 11 0 0
t$perf-norm:sp_reserve_write_off 10304 10304 0 0.00 0 7425 11 0 0
t$perf-norm:sp_supplier_invoice 5762 5762 0 0.00 0 4473 17 0 0
t$perf-norm:sp_supplier_order 5680 5680 0 0.00 0 8871 19 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 3432 48 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 407 5 0 0
t$perf-norm:srv_make_invnt_saldo 534 534 0 0.00 0 2913 34 0 0
t$perf-norm:srv_make_money_saldo 801 801 0 0.00 0 5500 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10416 10142 274 2.63 0 5789 18 0 274
v_all_customers 38688 38688 0 0.00 0 25 1 0 0
v_all_suppliers 31718 31718 0 0.00 0 24 1 0 0
v_all_wares 41944 41944 0 0.00 0 28 1 0 0
v_cancel_adding_invoice 868 868 0 0.00 0 1299 7 0 0
v_cancel_client_order 3746 3746 0 0.00 0 3121 4 0 0
v_cancel_customer_prepayment 1468 1468 0 0.00 0 4313 9 0 0
v_cancel_customer_reserve 1368 1368 0 0.00 0 1144 4 0 0
v_cancel_payment_to_supplier 820 820 0 0.00 0 5038 9 0 0
v_cancel_supplier_invoice 846 832 14 1.65 0 274 12 0 14
v_cancel_supplier_order 896 896 0 0.00 0 5703 9 0 0
v_cancel_write_off 2166 2166 0 0.00 0 1466 12 0 0
v_max_id_clo_ord 5680 5680 0 0.00 0 140 1 0 0
v_max_id_clo_res 1053 1053 0 0.00 0 1501 10 0 0
v_max_id_ord_sup 5754 5754 0 0.00 0 3967 6 0 0
v_max_non_paid_invoice 1680 1680 0 0.00 0 765 3 0 0
v_max_non_paid_realizn 3859 3859 0 0.00 0 2177 4 0 0
v_min_id_clo_ord 5680 5680 0 0.00 0 1919 5 0 0
v_min_id_clo_res 1053 1053 0 0.00 0 1093 4 0 0
v_min_id_ord_sup 5754 5754 0 0.00 0 5309 5 0 0
v_min_non_paid_invoice 6105 6105 0 0.00 0 8446 10 0 0
v_min_non_paid_realizn 7353 7353 0 0.00 0 10245 12 0 0
v_our_firm 10244 10244 0 0.00 0 14 1 0 0
v_reserve_write_off 20608 20608 0 0.00 0 8303 6 0 0
x_lock_depdocs_on_canc_invoice 12214 12214 0 0.00 0 15502 118 0 0
x_lock_depdocs_on_canc_sup_ord 448 448 0 0.00 0 6629 305 0 0
x_make_qstorno_1000_1200 5680 5680 0 0.00 2 27890 1304 0 0
x_make_qstorno_1200_2000 5762 5762 0 0.00 3 90494 3281 0 0
x_make_qstorno_2100_3300 471467 471467 0 0.00 0 27281 146 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-02-2021 01:28:13 to 09-02-2021 01:28:17.

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:18 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:25 15619 8192000000 10212422480 10519212032 852214320 9.422 69 52 104 1 872754896 2437776 18102800
22:57:47 25608 8192000000 10312047696 10626514944 1356201440 14.203 100 86 172 0 1389304240 4440800 28662000
22:58:23 11594 8192000000 10345502752 10662731776 1405026944 14.640 100 86 172 0 1439026960 5690864 28309152
22:58:45 18741 8192000000 10366768848 10689478656 1428079376 14.844 100 87 173 2 1463656304 6591872 28985056
22:59:16 19659 8192000000 10383079440 10711248896 1446523728 15.007 100 83 166 1 1481191984 7050080 27618176
22:59:53 16950 8192000000 10429446448 10757804032 1483218400 15.330 100 87 175 0 1518648144 7382736 28047008
23:00:18 14960 8192000000 10442128272 10774900736 1496098912 15.442 100 91 182 0 1533817584 8160992 29557680
23:00:49 22623 8192000000 10474699552 10811805696 1521030032 15.659 100 89 178 0 1558406144 9236128 28139984
23:01:22 18547 8192000000 10497372576 10839105536 1549907488 15.909 100 89 178 2 1587467808 9781088 27779232
23:01:49 24111 8192000000 10514977632 10867073024 1575508960 16.130 100 79 158 1 1610247200 10192288 24545952
23:02:27 14008 8192000000 10541459312 10894643200 1599905728 16.339 100 81 162 0 1639613136 14866448 24840960
23:02:49 8552 8192000000 10557455856 10915520512 1619788672 16.508 100 78 155 1 1653469552 10514160 23166720
23:03:05 13632 8192000000 10579947264 10944155648 1638982160 16.671 100 78 156 0 1673375776 10834064 23559552
23:03:27 11636 8192000000 10593065216 10960461824 1664346752 16.886 100 77 151 1 1697073600 10444768 22282080
23:03:46 10187 8192000000 10619014256 10985984000 1681458128 17.030 100 75 149 1 1713540096 10311104 21770864
23:04:06 13728 8192000000 10634972336 11008450560 1701575520 17.198 100 68 136 1 1731710096 10582336 19552240
23:04:27 6447 8192000000 10656703936 11030814720 1722931872 17.377 100 78 156 1 1757038416 11007024 23099520
23:04:41 9937 8192000000 10676940848 11052109824 1737953952 17.502 100 76 152 1 1771543216 11956064 21633200
23:04:58 5623 8192000000 10680664704 11059765248 1748497440 17.589 100 77 154 2 1782366592 12146736 21722416
23:05:13 6944 8192000000 10696475088 11070857216 1760417424 17.688 100 75 148 2 1793617200 12657680 20542096
23:05:28 5632 8192000000 10710947728 11087781888 1770068144 17.768 100 78 156 0 1805568720 13537520 21963056
23:05:42 3676 8192000000 10718541552 11099455488 1783444288 17.878 100 82 161 3 1819334336 13199888 22690160
23:05:53 4268 8192000000 10726288192 11106807808 1788079904 17.916 100 72 144 1 1821671024 13337744 20253376
23:06:04 4961 8192000000 10741404528 11123781632 1793985296 17.965 100 72 144 0 1827083744 12957248 20141200
23:06:15 3059 8192000000 10751493952 11130085376 1805990752 18.063 100 86 171 1 1843830704 14108096 23731856
23:06:25 3875 8192000000 10756069568 11138052096 1815548368 18.141 100 85 171 1 1852622624 13375936 23698320
23:06:36 9260 8192000000 10740008496 11132002304 1811609792 18.109 100 64 128 0 1842062592 12949232 17503568
23:06:53 3369 8192000000 10775683088 11157594112 1831481424 18.271 100 81 163 0 1867047472 12875856 22690192
23:07:03 2647 8192000000 10778083488 11164684288 1837201200 18.318 100 90 178 4 1875941488 13076432 25663856
23:07:12 2882 8192000000 10788691680 11174715392 1844173712 18.375 100 89 178 0 1882619072 13102112 25343248
23:07:23 3060 8192000000 10794044240 11179216896 1847410576 18.401 100 87 172 0 1883909600 11691328 24807696
23:07:32 2144 8192000000 10790426208 11179737088 1854778128 18.461 100 91 182 1 1894601840 13992592 25831120
23:07:41 3044 8192000000 10800739104 11187986432 1859557760 18.500 100 90 180 0 1898356784 14194848 24604176
23:07:51 2110 8192000000 10801060096 11189731328 1860067632 18.504 100 90 177 3 1900122704 14834720 25220352
23:07:59 1829 8192000000 10805771392 11193204736 1862735552 18.525 100 96 191 0 1903851728 14094544 27021632
23:08:08 2057 8192000000 10807611168 11194294272 1869618336 18.581 100 91 183 0 1910043408 14148704 26276368
23:08:16 2066 8192000000 10814110336 11201691648 1868366160 18.571 100 95 192 0 1909090256 13483616 27240480
23:08:26 2080 8192000000 10808984096 11200512000 1867654128 18.565 100 89 177 4 1906251744 13584368 25013248
23:08:35 1883 8192000000 10818753120 11204599808 1870067248 18.585 100 85 171 3 1908115600 13378048 24670304
23:08:43 2472 8192000000 10825963072 11212058624 1875422112 18.628 100 93 186 1 1916643504 14649136 26572256
23:08:52 2098 8192000000 10819329104 11208060928 1875000896 18.625 100 89 179 0 1914189712 13395952 25792864
23:09:00 1211 8192000000 10825889264 11216920576 1880247072 18.667 100 96 193 1 1921352032 13741120 27363840
23:09:08 1901 8192000000 10832470832 11224264704 1883539216 18.694 100 89 178 0 1921323168 13257936 24526016
23:09:16 12614 8192000000 10795912544 11207020544 1876846320 18.640 100 61 122 2 1906882912 12790448 17246144
23:09:46 1713 8192000000 10832160160 11221733376 1885428208 18.709 100 88 177 2 1922227184 10545056 26253920
23:09:54 2956 8192000000 10799958384 11214671872 1879231488 18.659 100 54 107 0 1905262048 11556528 14474032
23:10:03 3523 8192000000 10812050000 11220942848 1880767568 18.671 100 62 124 1 1909822832 11453792 17601472
23:10:13 3872 8192000000 10810998176 11217858560 1879850272 18.664 100 50 100 0 1904216880 10466816 13899792
23:10:24 3590 8192000000 10794557232 11215724544 1878956704 18.657 100 47 92 2 1900519584 8175504 13387376
23:10:36 5696 8192000000 10785976608 11214356480 1878192928 18.651 100 34 69 1 1896458768 8323680 9942160
23:10:48 3679 8192000000 10797912304 11219865600 1884034304 18.698 100 42 84 1 1903163344 7452864 11676176
23:11:00 4726 8192000000 10802010576 11217870848 1882771360 18.687 100 41 82 2 1902360432 7418704 12170368
23:11:11 3382 8192000000 10808327120 11229081600 1885810064 18.712 100 37 75 0 1908042640 11796368 10436208
23:11:24 9155 8192000000 10793547168 11221807104 1884832656 18.704 100 20 38 1 1897075024 6932096 5310272
23:11:40 8076 8192000000 10787024112 11224158208 1888807488 18.736 100 25 50 1 1902762160 6798128 7156544
23:11:54 15986 8192000000 10804258976 11232935936 1892375760 18.765 100 35 67 2 1917658256 14933200 10349296
23:12:18 70941 8192000000 10810804768 11241603072 1891415024 18.757 100 33 66 0 1907031328 6346816 9269488
23:13:35 5710 8192000000 10812429904 11244158976 1897135040 18.803 100 25 51 1 1910691840 6479744 7077056
23:13:49 8289 8192000000 10833995440 11249528832 1901760256 18.840 100 28 54 2 1919242080 10399696 7082128
23:14:05 6337 8192000000 10813136576 11248955392 1905462896 18.870 100 35 69 4 1922880832 7061536 10356400
23:14:18 4212 8192000000 10820407248 11254951936 1905255776 18.869 100 30 60 0 1920852080 7263712 8332592
23:14:29 4890 8192000000 10821144912 11256197120 1909445504 18.902 100 32 62 3 1924315616 6000448 8869664
23:14:42 5338 8192000000 10837229984 11264225280 1914679296 18.944 100 34 67 1 1931037552 5466592 10891664
23:14:55 8224 8192000000 10811197760 11249889280 1893631104 18.775 99 16 32 1 1903705648 5073152 5001392
23:15:10 7842 8192000000 10819599072 11257233408 1909641232 18.904 100 14 28 2 1919063552 5765344 3656976
23:15:24 7824 8192000000 10827533152 11259326464 1893899840 18.777 99 28 56 3 1911514528 9625504 7989184
23:15:41 11471 8192000000 10820033536 11257503744 1913620128 18.936 100 31 62 1 1929466784 5388400 10458256
23:16:00 6262 8192000000 10825535328 11259387904 1894395008 18.781 99 19 40 0 1909668464 10074672 5198784
23:16:13 11790 8192000000 10823180800 11256987648 1907388736 18.886 100 16 32 0 1917117792 5018432 4710624
23:16:31 12246 8192000000 10828941696 11268833280 1917424288 18.966 100 16 32 1 1931902896 9916432 4562176
23:16:50 9502 8192000000 10822643392 11262947328 1915606048 18.952 100 24 49 0 1928062976 6051232 6405696
23:17:08 53387 8192000000 10814283136 11230961664 1855621648 18.468 97 43 84 1 1873715088 5924336 12169104
23:18:08 25036 8192000000 10792902032 11214049280 1767709616 17.748 93 26 52 1 1780218112 4930976 7577520
23:18:40 7526 8192000000 10793279296 11224109056 1859398304 18.498 99 20 40 0 1871265472 6564544 5302624
23:18:55 5324 8192000000 10773535536 11197440000 1840372544 18.344 98 26 52 0 1854529184 6114688 8041952
23:19:08 5460 8192000000 10779609264 11192979456 1806419744 18.067 97 39 79 1 1824104928 7224288 10460896
23:19:21 10774 8192000000 10744972480 11161571328 1776104624 17.817 96 24 48 2 1796747392 13911568 6731200
23:19:39 6482 8192000000 10718630848 11143168000 1775816512 17.815 97 28 57 1 1789595456 5875648 7903296
23:19:53 6972 8192000000 10706135072 11128418304 1767050448 17.743 98 21 40 0 1778629392 5843312 5735632
23:20:06 9393 8192000000 10689870272 11096383488 1678103840 17.001 94 18 33 1 1687191600 4721232 4366528
23:20:22 10113 8192000000 10722251664 11129991168 1782975424 17.874 99 23 43 3 1794953904 5001056 6977424
23:20:41 9675 8192000000 10692380016 11107250176 1706985504 17.244 95 24 48 0 1718702368 5014128 6702736
23:20:57 12388 8192000000 10665988720 11072864256 1643147856 16.706 93 14 28 1 1652301776 4974608 4179312
23:21:17 11961 8192000000 10682711008 11096870912 1708667952 17.258 96 12 24 1 1717158128 4973952 3516224
23:21:35 10327 8192000000 10695175392 11107635200 1743452560 17.547 97 28 54 2 1757526976 5843184 8231232
23:21:52 71744 8192000000 10706395760 11132035072 1756712512 17.657 97 27 54 1 1770899296 6024080 8162704
23:23:10 12220 8192000000 10738855808 11153960960 1792220096 17.950 99 22 44 0 1803502656 5712480 5570080
23:23:31 6431 8192000000 10741692528 11164377088 1823092272 18.203 100 38 76 2 1841372336 7889792 10390272
23:23:46 7600 8192000000 10738270464 11167100928 1828691056 18.249 100 20 40 2 1841147440 6760272 5696112
23:24:00 6667 8192000000 10743303552 11168702464 1829571616 18.256 100 23 46 0 1842412896 5658016 7183264
23:24:13 8072 8192000000 10757989408 11183161344 1840786544 18.347 100 32 64 1 1856527904 6671120 9070240
23:24:28 8219 8192000000 10757044704 11177549824 1823940992 18.210 99 28 56 1 1838124848 5612864 8570992
23:24:48 7663 8192000000 10759337200 11183247360 1842817936 18.364 100 28 56 2 1857175168 5738000 8619232
23:25:02 4863 8192000000 10770178240 11189616640 1843590048 18.370 100 16 32 0 1854232832 5907776 4735008
23:25:15 7173 8192000000 10769672976 11192389632 1851765664 18.436 100 30 60 0 1865871888 4832624 9273600
23:25:29 10199 8192000000 10775449952 11199717376 1855352624 18.466 100 31 62 2 1869925392 5129392 9443376
23:25:49 14200 8192000000 10771464496 11202748416 1855514816 18.467 100 19 38 0 1866563312 5406704 5641792
23:26:11 14860 8192000000 10782900368 11204415488 1859084912 18.496 100 12 24 0 1868169696 5277360 3807424
23:26:32 19895 8192000000 10775917072 11207995392 1861487248 18.515 100 24 48 0 1873998752 5830176 6681328
23:26:58 56930 8192000000 10796920832 11226644480 1876850304 18.640 100 31 61 3 1891149984 5362288 8937392
23:28:01 48740 8192000000 10838305392 11257499648 1906617312 18.879 100 52 103 1 1928634368 6644576 15372480
23:29:06 8028 8192000000 10848402816 11269447680 1913771568 18.937 100 55 110 1 1938939520 9185824 15982128
23:29:23 36073 8192000000 10840935808 11268083712 1916276432 18.957 100 42 84 1 1936983280 9109680 11597168
23:30:09 10733 8192000000 10842460512 11277647872 1922121680 19.004 100 29 58 0 1939116288 8007824 8986784
23:30:28 19037 8192000000 10861855712 11289530368 1935142768 19.108 100 49 98 0 1958304800 9400592 13761440
23:31:03 11069 8192000000 10872624560 11297153024 1938504896 19.135 100 45 90 1 1962526688 11323952 12697840
23:31:21 7963 8192000000 10877861568 11302469632 1944278496 19.181 100 59 118 2 1975283856 14166240 16839120
23:31:40 42377 8192000000 10857512864 11302232064 1940798816 19.153 100 42 83 0 1966878128 12937808 13141504
23:32:34 12430 8192000000 10877794656 11308802048 1944520032 19.183 100 41 82 1 1968438032 11423968 12494032
23:32:58 9771 8192000000 10887501264 11317219328 1950344432 19.229 100 47 90 2 1975367776 11365168 13658176
23:33:16 5915 8192000000 10893820368 11320725504 1955784096 19.273 100 52 104 1 1982674032 11847952 15041984
23:33:30 6572 8192000000 10915005776 11333406720 1960303264 19.308 100 55 110 0 1990136256 13915984 15917008
23:33:45 9550 8192000000 10896147952 11328466944 1963656064 19.335 100 54 108 2 1992620528 12750304 16214160
23:34:07 6885 8192000000 10890647296 11307827200 1943805872 19.177 99 61 123 0 1974609184 13322144 17481168
23:34:24 13531 8192000000 10896899040 11328303104 1960468112 19.310 100 52 103 2 1989596336 13268432 15859792
23:34:47 10547 8192000000 10909538784 11341266944 1963464176 19.334 100 43 86 1 1990812240 14331888 13016176
23:35:07 4097 8192000000 10894337088 11331854336 1945759920 19.193 99 41 78 5 1975721760 18500880 11460960
23:35:32 7869 8192000000 10900297632 11336134656 1958709632 19.296 100 46 92 0 1989979376 18284640 12985104
23:35:53 9858 8192000000 10907170992 11343532032 1970817024 19.392 100 51 100 2 2002180320 16187488 15175808
23:36:13 33967 8192000000 10924190224 11361820672 1976494592 19.437 100 40 80 1 2006784160 17891888 12397680
23:36:58 6118 8192000000 10934979824 11368980480 1982795584 19.487 100 46 92 1 2017889152 20525088 14568480
23:37:12 19120 8192000000 10935029872 11370668032 1982351280 19.483 100 53 106 1 2022470320 23511936 16607104
23:37:41 10226 8192000000 10933386032 11369025536 1971924320 19.401 99 55 109 0 2014215760 25931520 16359920
23:37:59 7417 8192000000 10949260368 11382431744 1991269744 19.554 100 53 106 1 2034897424 27646256 15981424
23:38:15 9650 8192000000 10952943392 11384852480 1996604608 19.596 100 66 132 0 2042288112 25467824 20215680
23:38:32 2735 8192000000 10941721360 11361615872 1963529632 19.334 99 74 148 0 2012776560 26415360 22831568
23:38:42 3888 8192000000 10951993008 11374927872 1989163216 19.537 100 71 142 0 2038690576 28197216 21330144
23:38:52 4304 8192000000 10936266240 11362516992 1977625072 19.446 100 78 156 1 2030084784 28691648 23768064
23:39:05 8632 8192000000 10948051312 11375144960 1984532256 19.501 100 69 138 0 2035005808 28932656 21540896
23:39:26 8546 8192000000 10941516048 11371057152 1979510464 19.461 100 64 128 0 2027550672 28906160 19134048
23:39:43 12042 8192000000 10948086000 11383357440 1988701904 19.534 100 62 124 0 2038953280 31170848 19080528
23:40:03 6814 8192000000 10948052368 11387125760 1992868896 19.566 100 45 90 1 2037751008 31017984 13864128
23:40:19 5860 8192000000 10944998176 11384799232 1975458768 19.429 99 54 109 3 2022754224 29987456 17308000
23:40:33 15292 8192000000 10964495968 11399741440 1999782176 19.621 100 57 114 1 2050250560 32381904 18086480
23:40:58 3392 8192000000 10963901248 11400085504 1987026432 19.520 99 51 101 0 2038492208 35611248 15854528
23:41:09 7753 8192000000 10964105920 11402588160 2002828848 19.645 100 55 109 3 2054132848 34065472 17238528
23:41:23 5731 8192000000 10980162272 11410817024 2005123088 19.663 100 63 124 3 2059656864 35104496 19429280
23:41:37 3051 8192000000 10973273456 11400388608 1997758368 19.605 100 71 141 1 2060288400 40932912 21597120
23:41:48 2946 8192000000 10977928192 11391143936 1984140736 19.497 99 78 156 0 2045862256 37799520 23922000
23:42:01 1491 8192000000 10966612848 11374747648 1973263440 19.411 99 96 187 3 2039894720 38875024 27756256
23:42:10 2033 8192000000 10965178000 11380985856 1995152208 19.584 100 90 179 0 2059579168 37494128 26932832
23:42:19 4283 8192000000 10949073696 11365523456 1963026976 19.330 99 84 168 0 2027038128 38546400 25464752
23:42:31 2108 8192000000 10958731264 11374538752 1977774704 19.447 100 87 175 3 2043213968 38236992 27202272
23:42:40 1855 8192000000 10955136464 11369652224 1972228336 19.403 100 85 171 2 2036126912 37962592 25935984
23:42:50 3432 8192000000 10955810064 11374919680 1979734208 19.463 100 86 171 1 2045184960 38768000 26682752
23:43:01 2235 8192000000 10953388528 11373666304 1976201664 19.435 100 73 146 0 2036911296 39365520 21344112
23:43:11 7444 8192000000 10946327632 11371753472 1970256704 19.387 100 67 134 1 2031154992 40190400 20707888
23:43:28 1968 8192000000 10964309376 11373006848 1972649072 19.406 100 89 179 2 2040773520 41040928 27083520
23:43:37 1872 8192000000 10951762960 11365003264 1965914096 19.353 100 82 161 2 2031274032 41144976 24214960
23:43:46 2190 8192000000 10958348432 11371728896 1959317360 19.301 99 85 171 1 2024443264 39829120 25296784
23:43:55 1819 8192000000 10937096624 11346313216 1953095568 19.251 99 84 168 0 2018993536 39754928 26143040
23:44:05 5177 8192000000 10922906320 11336761344 1931676832 19.080 99 74 148 0 1994588032 40437264 22473936
23:44:20 3121 8192000000 10957082000 11372974080 1970171120 19.387 100 76 151 0 2033875216 41860848 21843248
23:44:30 3609 8192000000 10967121728 11388350464 1983945440 19.496 100 71 143 3 2049983536 43575456 22462640
23:44:41 7185 8192000000 10914407696 11342323712 1921388256 18.998 97 41 82 1 1977295200 42698432 13208512
23:44:54 6443 8192000000 10921489344 11335921664 1922876800 19.010 98 58 112 1 1982843184 41897632 18068752
23:45:08 3606 8192000000 10937154352 11364147200 1953834912 19.257 100 69 137 2 2019299520 43924976 21539632
23:45:24 7825 8192000000 10939726096 11374809088 1966086448 19.354 100 50 100 0 2030021216 47444096 16490672
23:45:40 3660 8192000000 10976944384 11388346368 1985765360 19.510 100 85 167 1 2060155376 48132048 26257968
23:45:53 2208 8192000000 10947737680 11363086336 1955207392 19.268 100 77 151 1 2030499136 50668192 24623552
23:46:03 6883 8192000000 10944420512 11366264832 1952963840 19.250 100 74 148 0 2029046176 52514464 23567872
23:46:17 1675 8192000000 10960912608 11374428160 1964058160 19.338 100 86 172 1 2043063920 52095408 26910352
23:46:27 1134 8192000000 10957528928 11373903872 1948537792 19.215 99 78 157 2 2024817296 52292992 23986512
23:46:34 7500 8192000000 10935612224 11369644032 1955515008 19.270 100 50 100 3 2025570704 53461056 16594640
23:46:52 5538 8192000000 10956119984 11376181248 1961558096 19.318 100 66 130 3 2039118592 56236208 21324288
23:47:07 3826 8192000000 10969789568 11379961856 1965847280 19.352 100 78 155 2 2043318528 52320480 25150768
23:47:19 2183 8192000000 10976312064 11390038016 1976689024 19.438 100 90 178 1 2060039376 55035360 28314992
23:47:29 2140 8192000000 10979770432 11390525440 1973452528 19.413 100 88 176 0 2060223360 58822096 27948736
23:47:39 1376 8192000000 10990449776 11401121792 1986230208 19.514 100 92 184 1 2073854848 59291344 28333296
23:47:50 3374 8192000000 10970279568 11385696256 1964153312 19.339 99 75 151 1 2047362752 59164960 24044480
23:48:06 2895 8192000000 10998110112 11410792448 1991617664 19.557 100 88 176 0 2079025712 59964400 27443648
23:48:18 3770 8192000000 11000636832 11419115520 1992833008 19.566 100 82 164 0 2078735056 60508336 25393712
23:48:31 2880 8192000000 11008247696 11423186944 1997160320 19.600 100 85 169 1 2086997552 62840064 26997168
23:48:41 3068 8192000000 11012271488 11430572032 2001594624 19.635 100 88 173 3 2092825648 63313920 27917104
23:48:54 3794 8192000000 10992148208 11408154624 1984619904 19.501 100 77 154 3 2074716704 65485248 24611552
23:49:06 1325 8192000000 10990032112 11407704064 1981277392 19.475 100 79 158 1 2072786896 65712464 25797040
23:49:20 15411 8192000000 10972951296 11412287488 1979722816 19.463 100 44 88 0 2062410256 67222336 15465104
23:49:47 13840 8192000000 10973780208 11415175168 1967883808 19.369 99 45 90 0 2048270224 65104240 15282176
23:50:08 17206 8192000000 10961489808 11413520384 1965607632 19.351 99 37 74 0 2037129248 58956240 12565376
23:50:42 19656 8192000000 10958164896 11401019392 1967724528 19.367 99 36 72 2 2037416992 57504256 12188208
23:51:15 11696 8192000000 10965457152 11409891328 1976150240 19.434 100 37 74 0 2049089024 59820880 13117904
23:51:40 13159 8192000000 10966366288 11406135296 1959668592 19.303 99 37 74 2 2031518064 58970528 12878944
23:52:06 11646 8192000000 10952906192 11399356416 1964994896 19.346 100 34 68 3 2041300352 64132832 12172624
23:52:34 14644 8192000000 10967113424 11409489920 1975106752 19.426 100 36 72 2 2050638496 62542800 12988944
23:53:01 26239 8192000000 10964367184 11412705280 1966168064 19.355 100 33 66 0 2042464976 64385136 11911776
23:53:34 15949 8192000000 10956144800 11417518080 1974544576 19.421 100 30 60 2 2049947520 64442864 10960080
23:54:00 16734 8192000000 10945453424 11399127040 1946248656 19.197 99 28 56 3 2021681552 64602224 10830672
23:54:33 33004 8192000000 10928867904 11388403712 1927372992 19.046 99 21 42 0 1999907568 64576352 7958224
23:55:19 17838 8192000000 10913996560 11362848768 1915774096 18.953 99 20 41 2 1980373024 57360848 7238080
23:55:45 21874 8192000000 10922200704 11378462720 1935657184 19.112 100 21 42 2 2003550976 59588096 8305696
23:56:14 33668 8192000000 10887449248 11373912064 1940024944 19.147 100 10 19 0 1985541792 42485152 3031696
23:56:54 62532 8192000000 10875868272 11321405440 1838162128 18.326 94 27 53 0 1853758768 8306000 7290640
23:58:04 20249 8192000000 10883809504 11324207104 1938239488 19.133 99 43 81 2 1957097392 7786864 11071040
23:58:31 56866 8192000000 10888594768 11337023488 1936496832 19.119 99 25 51 1 1957397888 13905344 6995712
23:59:41 20816 8192000000 10897097072 11356352512 1961452944 19.318 100 8 16 1 1974781840 11130608 2198288
00:00:10 119555 8192000000 10902475248 11365400576 1939987248 19.147 98 13 26 1 1954529392 11670208 2871936
00:02:16 60848 8192000000 10890239712 11339964416 1918288992 18.973 97 22 44 2 1933754704 7928592 7537120
00:04:49 95362 8192000000 10899642736 11356606464 1951999216 19.242 99 29 58 1 1971090480 9830720 9260544
00:06:57 55439 8192000000 10928878320 11389349888 1962336320 19.325 99 25 50 1 1983786800 14522944 6927536
00:08:01 31685 8192000000 10937509712 11382288384 1949752736 19.225 98 52 102 2 1975150688 10676368 14721584
00:08:42 59892 8192000000 10903067008 11364843520 1917734496 18.969 97 32 64 0 1941508096 14784256 8989344
00:09:48 39070 8192000000 10892726320 11352371200 1929460160 19.063 98 18 36 0 1954909056 19658144 5790752
00:10:34 15641 8192000000 10907016928 11367596032 1965506224 19.350 100 27 54 1 1992956944 19276480 8174240
00:11:00 35618 8192000000 10905872048 11366567936 1931590432 19.080 98 16 32 1 1958590720 21906656 5093632
00:11:42 17206 8192000000 10911896512 11374485504 1966302640 19.356 100 22 45 1 1992643072 19210736 7129696
00:12:07 21435 8192000000 10915608384 11368804352 1956117952 19.275 99 38 77 1 1985783952 18544752 11121248
00:12:35 27379 8192000000 10900337712 11356950528 1931395104 19.078 98 45 90 3 1963021184 17206048 14420032
00:13:14 58509 8192000000 10922844848 11398742016 1969844096 19.384 100 30 58 0 2000155200 22131728 8179376
00:14:22 36041 8192000000 10913423856 11398635520 1980029680 19.465 100 10 20 1 1999261664 16074800 3157184
00:15:05 48585 8192000000 10912408944 11385659392 1991562784 19.556 100 26 49 0 2009868688 11041808 7264096
00:15:59 19355 8192000000 10916741680 11390873600 1989794512 19.542 100 12 24 0 2006521712 12775712 3951488
00:16:36 49237 8192000000 10905938544 11388141568 1960895152 19.313 99 8 16 0 1975506688 11916096 2695440
00:17:32 55755 8192000000 10895061776 11378548736 1964101184 19.339 99 10 20 1 1980508128 13184944 3222000
00:18:34 49484 8192000000 10901555328 11375067136 1959644016 19.303 99 15 30 0 1973735728 9331872 4759840
00:19:30 101497 8192000000 10926112128 11411619840 1959705840 19.304 99 7 14 0 1975590384 14049216 1835328
00:21:19 20589 8192000000 10906339664 11393716224 1946875968 19.202 98 10 20 0 1972634464 23059264 2699232
00:21:47 29498 8192000000 10913140096 11387617280 1978002848 19.449 100 7 14 0 2003262032 23214272 2044912
00:22:41 64605 8192000000 10906970816 11368656896 1950667040 19.232 99 11 21 2 1959803904 6434320 2702544
00:23:54 11026 8192000000 10885714080 11360694272 1967715664 19.367 100 36 70 1 1985579632 7932032 9931936
00:24:24 45012 8192000000 10864508304 11343441920 1906721184 18.880 97 18 34 1 1917863600 6818096 4324320
00:25:32 54611 8192000000 10874415904 11353399296 1921984816 19.003 98 15 30 1 1935647040 9515472 4146752
00:26:44 35777 8192000000 10879684160 11357220864 1957369456 19.285 100 11 22 0 1972833904 11824752 3639696
00:27:36 43666 8192000000 10882275936 11376414720 1958121536 19.291 100 8 16 0 1971412304 11369216 1921552
00:28:27 58858 8192000000 10895419488 11379019776 1956794992 19.281 99 13 26 3 1974944992 14382992 3767008
00:29:33 69571 8192000000 10900406048 11381448704 1937174048 19.124 98 13 26 1 1954571840 14199296 3198496
00:30:49 101560 8192000000 10868129664 11349979136 1837408144 18.320 93 18 36 1 1852098432 10503216 4187072
00:32:43 40844 8192000000 10892218944 11358494720 1935065552 19.107 99 16 32 0 1946768400 7495984 4206864
00:33:30 33897 8192000000 10859309760 11324940288 1883760112 18.695 96 21 40 1 1899742176 10165872 5816192
00:34:20 27910 8192000000 10880389024 11339235328 1925600336 19.032 99 25 49 2 1948659584 15364192 7695056
00:34:56 38664 8192000000 10877699504 11345756160 1901873776 18.841 98 24 46 0 1928000224 18749200 7377248
00:35:41 42535 8192000000 10880335312 11342372864 1908570608 18.895 98 18 36 2 1928782992 15086560 5125824
00:36:29 39320 8192000000 10892758240 11353292800 1933896704 19.098 99 33 66 0 1959798608 15671168 10230736
00:37:29 42887 8192000000 10872212656 11348799488 1914819040 18.945 98 17 34 0 1933101216 13072288 5209888
00:38:21 60450 8192000000 10893446688 11363131392 1934858080 19.106 99 11 22 0 1962325264 24837536 2629648
00:39:28 69328 8192000000 10870229584 11345948672 1842521952 18.361 94 7 14 0 1856813120 12750096 1541072
00:40:44 62019 8192000000 10843444928 11301380096 1794533088 17.969 93 20 40 1 1811266368 10718784 6014496
00:41:52 56302 8192000000 10876377968 11334512640 1908537792 18.895 99 34 68 1 1928424112 10533472 9352848
00:43:27 124045 8192000000 10856302384 11342282752 1887415104 18.725 97 25 49 0 1910339088 16129840 6794144
00:45:38 28690 8192000000 10861682288 11345002496 1936566096 19.119 100 12 24 1 1954674768 14493712 3614960
00:46:17 38975 8192000000 10859056944 11328258048 1921617712 19.000 99 20 40 0 1941647312 13846096 6183504
00:47:14 66742 8192000000 10866310160 11342979072 1921116208 18.996 99 12 24 1 1938583168 13765088 3701872
00:48:44 51036 8192000000 10862062592 11343773696 1924038784 19.019 99 12 24 1 1940133872 12506608 3588480
00:49:53 81957 8192000000 10870022048 11355660288 1943841440 19.177 100 17 34 1 1963999760 15820992 4337328
00:51:21 44022 8192000000 10859442320 11332194304 1927016720 19.043 99 11 22 1 1940893520 11041520 2835280
00:52:11 13095 8192000000 10875075856 11343257600 1949498144 19.222 100 28 56 1 1965955392 8204240 8253008
00:52:33 56767 8192000000 10863517776 11356622848 1947228400 19.204 100 10 20 1 1962330368 12101328 3000640
00:53:38 41816 8192000000 10875042192 11357540352 1949468432 19.222 100 8 15 1 1963443568 11670992 2304144
00:54:43 56016 8192000000 10861412944 11339370496 1903092048 18.851 97 18 36 2 1916577168 7925072 5560048
00:55:46 54026 8192000000 10896095776 11366035456 1960554496 19.310 100 41 80 2 1981548944 8838864 12155584
00:56:49 69813 8192000000 10896991808 11358519296 1875456576 18.628 95 17 34 1 1890310496 10163520 4690400
00:58:52 60974 8192000000 10890144976 11377541120 1930573344 19.071 98 9 18 1 1948671696 15976896 2121456
00:59:59 36399 8192000000 10904963776 11374858240 1965678672 19.351 99 20 40 2 1983498160 12530448 5289040
01:00:42 53844 8192000000 10895887248 11368067072 1913618896 18.936 97 18 36 1 1930178848 11556736 5003216
01:01:42 77331 8192000000 10907797440 11384238080 1951993824 19.242 99 19 38 1 1969273328 12146080 5133424
01:03:05 50242 8192000000 10900640480 11387809792 1933044080 19.091 98 17 31 1 1951712176 14406544 4261552
01:04:02 49421 8192000000 10907547088 11399741440 1955349712 19.269 99 10 20 1 1978086208 19882096 2854400
01:05:02 92310 8192000000 10877432912 11343089664 1851541664 18.435 94 21 42 2 1871227968 13548496 6137808
01:06:47 23430 8192000000 10895617312 11352129536 1936315216 19.117 99 42 83 3 1958351136 10318816 11717104
01:07:16 53532 8192000000 10896003776 11367329792 1930821712 19.073 99 24 48 1 1948669360 11052192 6795456
01:08:46 111753 8192000000 10880998896 11347693568 1924791344 19.025 98 26 52 1 1939897040 7670368 7435328
01:10:51 78299 8192000000 10882526896 11357757440 1913164832 18.932 97 19 38 1 1926156816 7813744 5178240
01:12:33 14896 8192000000 10880215888 11336519680 1937197040 19.124 99 39 77 0 1957440752 9489728 10753984
01:12:58 38557 8192000000 10860561504 11334963200 1908185136 18.892 98 27 54 0 1925950496 9643584 8121776
01:13:52 47420 8192000000 10861038208 11341533184 1923758800 19.017 99 7 14 0 1934215168 8483216 1973152
01:14:45 29280 8192000000 10870443328 11347869696 1942730896 19.169 100 13 26 1 1957784528 11325920 3727712
01:15:22 43272 8192000000 10852896992 11324178432 1906425792 18.878 98 21 42 0 1921488336 8491024 6571520
01:16:11 67594 8192000000 10834206848 11297935360 1866380112 18.555 96 17 34 1 1885967488 14609872 4977504
01:17:25 100849 8192000000 10831628272 11305586688 1835947344 18.308 95 19 38 1 1858502896 15974944 6580608
01:19:24 73949 8192000000 10858931760 11335512064 1893316272 18.772 98 20 40 0 1910954352 12110880 5527200
01:21:33 130935 8192000000 10863278688 11340529664 1828292336 18.245 94 13 26 0 1840288432 8339840 3656256
01:24:16 48473 8192000000 10866984608 11349401600 1937246192 19.125 100 13 26 0 1956771264 15713216 3811856
01:25:36 46009 8192000000 10894655488 11361579008 1918485744 18.975 98 36 72 1 1938512400 9461968 10564688
01:26:32 52876 8192000000 9543806944 9862246400 677654256 7.640 35 2 4 0 687509504 9473776 381472

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 09-02-2021 01:28:19 to 09-02-2021 01:28:52.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 137 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-02-2021 01:28:53 to 09-02-2021 01:28:55.

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          240605
MON$OLDEST_ACTIVE               243245
MON$OLDEST_SNAPSHOT             243245
MON$NEXT_TRANSACTION            243245
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                       2052896
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:125: 
:126: mscs-test-161.budzdorov.ru    Tue Feb  9 01:27:27 2021
:127:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:128: 
--- end of diff output ---

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

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