Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.03.2021 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 df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17512176 kB
MemAvailable 31586260 kB
Buffers 0 kB
Cached 14140612 kB
SwapCached 0 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-03-06 22:27:19
DTS_END                         2021-03-06 22:27:19.3440
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/37824
TRN_ID                          241149
ATT_ID                          676
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: 9503.68 22093 1140442
customer order: creation 176.56 375 21187
customer order: refuse 15.38 342 1845
order to supplier: creation 47.85 1208 5742
order to supplier: removal 3.65 97692 438
invoice (draft): creation 46.84 2947 5621
invoice (draft): removal 53.73 782 6448
invoice accept: apply 42.21 17277 5065
invoice accept: cancel 48.63 864 5836
customer reserve: creation 3940.17 168 472820
customer reserve: removal 4828.83 58 579460
realization accept: apply 85.22 196 10226
realization accept: cancel 83.27 122 9992
payment from customer: creation 59.28 132 7113
payment from customer: removal 5.63 99 675
payment to supplier: creation 50.30 136 6036
payment to supplier: removal 3.44 95 413
service: total inventory turnovers 4.97 1141 596
service: total monetary turnovers 6.77 40 812
service: aggregate perf. data 0.94 14151 113
service: refresh index statistics 0.03 304031 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 06-03-2021 22:28:22 to 06-03-2021 22:28:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1375
TEST_TIME 2 3275
TEST_TIME 3 3465
TEST_TIME 4 2882
TEST_TIME 5 3243
TEST_TIME 6 3431
TEST_TIME 7 3978
TEST_TIME 8 4709
TEST_TIME 9 5265
TEST_TIME 10 5431
TEST_TIME 11 5886
TEST_TIME 12 6397
TEST_TIME 13 6631
TEST_TIME 14 6991
TEST_TIME 15 7122
TEST_TIME 16 7528
TEST_TIME 17 8034
TEST_TIME 18 8688
TEST_TIME 19 8878
TEST_TIME 20 9862
TEST_TIME 21 10239
TEST_TIME 22 10253
TEST_TIME 23 10976
TEST_TIME 24 11271
TEST_TIME 25 11514
TEST_TIME 26 11226
TEST_TIME 27 11198
TEST_TIME 28 11228
TEST_TIME 29 11047
TEST_TIME 30 10797
TEST_TIME 31 10601
TEST_TIME 32 10710
TEST_TIME 33 10471
TEST_TIME 34 10458
TEST_TIME 35 10342
TEST_TIME 36 10303
TEST_TIME 37 10276
TEST_TIME 38 10330
TEST_TIME 39 10222
TEST_TIME 40 10106
TEST_TIME 41 10190
TEST_TIME 42 10006
TEST_TIME 43 9989
TEST_TIME 44 10060
TEST_TIME 45 10017
TEST_TIME 46 9946
TEST_TIME 47 9924
TEST_TIME 48 10061
TEST_TIME 49 10082
TEST_TIME 50 10107
TEST_TIME 51 10232
TEST_TIME 52 10153
TEST_TIME 53 10254
TEST_TIME 54 10169
TEST_TIME 55 10257
TEST_TIME 56 10195
TEST_TIME 57 10062
TEST_TIME 58 10064
TEST_TIME 59 9956
TEST_TIME 60 9897
TEST_TIME 61 9952
TEST_TIME 62 9840
TEST_TIME 63 9804
TEST_TIME 64 9751
TEST_TIME 65 9779
TEST_TIME 66 9783
TEST_TIME 67 9782
TEST_TIME 68 9716
TEST_TIME 69 9828
TEST_TIME 70 9880
TEST_TIME 71 9859
TEST_TIME 72 9846
TEST_TIME 73 9984
TEST_TIME 74 9919
TEST_TIME 75 9980
TEST_TIME 76 9995
TEST_TIME 77 10072
TEST_TIME 78 10000
TEST_TIME 79 9901
TEST_TIME 80 9908
TEST_TIME 81 9856
TEST_TIME 82 9914
TEST_TIME 83 9884
TEST_TIME 84 9836
TEST_TIME 85 9791
TEST_TIME 86 9718
TEST_TIME 87 9659
TEST_TIME 88 9651
TEST_TIME 89 9626
TEST_TIME 90 9638
TEST_TIME 91 9654
TEST_TIME 92 9671
TEST_TIME 93 9668
TEST_TIME 94 9697
TEST_TIME 95 9656
TEST_TIME 96 9686
TEST_TIME 97 9756
TEST_TIME 98 9735
TEST_TIME 99 9776
TEST_TIME 100 9785
TEST_TIME 101 9823
TEST_TIME 102 9818
TEST_TIME 103 9799
TEST_TIME 104 9842
TEST_TIME 105 9769
TEST_TIME 106 9737
TEST_TIME 107 9738
TEST_TIME 108 9688
TEST_TIME 109 9675
TEST_TIME 110 9637
TEST_TIME 111 9600
TEST_TIME 112 9576
TEST_TIME 113 9512
TEST_TIME 114 9513
TEST_TIME 115 9549
TEST_TIME 116 9528
TEST_TIME 117 9524
TEST_TIME 118 9541
TEST_TIME 119 9567
TEST_TIME 120 9504

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-03-2021 22:28:26 to 06-03-2021 22:28:29.

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 1579554 1579554 0 0.00 0 18648 6 0 0
doc_list_biud 1579553 1579553 0 0.00 0 58971 27 0 0
sp_add_invoice_to_stock 5144 5065 79 1.53 17 162502 17277 0 79
sp_cancel_adding_invoice 5836 5836 0 0.00 6 64015 865 0 0
sp_cancel_client_order 1845 1845 0 0.00 4 13142 342 0 0
sp_cancel_customer_reserve 579460 579460 0 0.00 1 36131 59 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 3 7739 100 0 0
sp_cancel_pay_to_supplier 413 413 0 0.00 2 5093 95 0 0
sp_cancel_supplier_invoice 6455 6448 7 0.10 2 22226 783 0 7
sp_cancel_supplier_order 438 438 0 0.00 9 1052336 97693 0 0
sp_cancel_write_off 9992 9992 0 0.00 1 15835 123 0 0
sp_client_order 21187 21187 0 0.00 3 36508 375 0 0
sp_customer_reserve 472820 472820 0 0.00 0 110655 169 0 0
sp_fill_shopping_cart 32529 32529 0 0.00 1 15097 35 0 0
sp_fill_shopping_cart_clo_res 472819 472819 0 0.00 0 35466 15 0 0
sp_get_clo_for_invoice 5064 5064 0 0.00 0 28001 303 0 0
sp_kill_cost_storno 16916 16916 0 0.00 0 18516 64 0 0
sp_kill_qstorno_ret_qs2qd 1175798 1175798 0 0.00 0 36050 32 0 0
sp_kill_qty_storno 619307 619307 0 0.00 0 58970 68 0 0
sp_lock_selected_doc 21275 21275 0 0.00 0 7769 7 0 0
sp_make_cost_storno 28438 28438 0 0.00 0 16864 50 0 0
sp_multiply_rows_for_pdistr 28438 28438 0 0.00 0 18604 36 0 0
sp_multiply_rows_for_qdistr 21187 21187 0 0.00 0 36487 174 0 0
sp_pay_from_customer 7113 7113 0 0.00 3 19419 132 0 0
sp_pay_to_supplier 6036 6036 0 0.00 5 18599 137 0 0
sp_payment_common 13149 13149 0 0.00 1 19330 46 0 0
sp_qd_handle_on_cancel_clo 1845 1845 0 0.00 0 13130 302 0 0
sp_qd_handle_on_invoice_upd_sts 10899 10899 0 0.00 0 58969 311 0 0
sp_qd_handle_on_reserve_upd_sts 10225 10225 0 0.00 0 20768 59 0 0
sp_reserve_write_off 10226 10226 0 0.00 6 20947 196 0 0
sp_supplier_invoice 5621 5621 0 0.00 8 74862 2948 0 0
sp_supplier_order 5742 5742 0 0.00 5 35163 1208 0 0
srv_aggregate_perf_data 114 113 1 0.87 2839 100275 14152 0 1
srv_fill_mon_cache_memory 155 155 0 0.00 1182 175225 34004 0 0
srv_find_qd_qs_mism 1092322 1092322 0 0.00 0 15913 5 0 0
srv_make_invnt_saldo 596 596 0 0.00 33 47159 1142 0 0
srv_make_money_saldo 812 812 0 0.00 1 7593 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 184798 426616 304032 0 0
t$perf-abend:sp_add_invoice_to_stock 79 79 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 5065 5065 0 0.00 0 17322 157 0 0
t$perf-norm:sp_cancel_adding_invoice 437 437 0 0.00 1 3636 112 0 0
t$perf-norm:sp_cancel_client_order 1845 1845 0 0.00 0 3145 15 0 0
t$perf-norm:sp_cancel_customer_reserve 741 741 0 0.00 0 2810 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 188 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 413 413 0 0.00 0 6301 24 0 0
t$perf-norm:sp_cancel_supplier_invoice 401 401 0 0.00 0 450 10 0 0
t$perf-norm:sp_cancel_supplier_order 438 438 0 0.00 0 34766 1615 0 0
t$perf-norm:sp_cancel_write_off 1037 1037 0 0.00 0 3120 9 0 0
t$perf-norm:sp_client_order 21187 21187 0 0.00 0 12766 17 0 0
t$perf-norm:sp_customer_reserve 1038 1038 0 0.00 0 1295 5 0 0
t$perf-norm:sp_pay_from_customer 7113 7113 0 0.00 0 11401 12 0 0
t$perf-norm:sp_pay_to_supplier 6036 6036 0 0.00 0 5029 8 0 0
t$perf-norm:sp_reserve_write_off 10226 10226 0 0.00 0 11395 15 0 0
t$perf-norm:sp_supplier_invoice 5621 5621 0 0.00 0 13536 17 0 0
t$perf-norm:sp_supplier_order 5742 5742 0 0.00 0 7989 15 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 710 26 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 493 8 0 0
t$perf-norm:srv_make_invnt_saldo 596 596 0 0.00 0 1458 21 0 0
t$perf-norm:srv_make_money_saldo 812 812 0 0.00 0 6284 27 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 7 4 0 0
v_add_invoice_to_stock 10283 10125 158 1.53 0 5543 20 0 158
v_all_customers 38678 38678 0 0.00 0 27 1 0 0
v_all_suppliers 31712 31712 0 0.00 0 136 1 0 0
v_all_wares 42374 42374 0 0.00 0 58 1 0 0
v_cancel_adding_invoice 874 874 0 0.00 0 202 7 0 0
v_cancel_client_order 3690 3690 0 0.00 0 10091 9 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 5848 11 0 0
v_cancel_customer_reserve 1482 1482 0 0.00 0 2633 7 0 0
v_cancel_payment_to_supplier 826 826 0 0.00 0 2457 17 0 0
v_cancel_supplier_invoice 816 802 14 1.71 0 4669 28 0 14
v_cancel_supplier_order 876 876 0 0.00 0 1239 4 0 0
v_cancel_write_off 2074 2074 0 0.00 0 2759 15 0 0
v_max_id_clo_ord 5742 5742 0 0.00 0 1415 1 0 0
v_max_id_clo_res 1038 1038 0 0.00 0 2114 16 0 0
v_max_id_ord_sup 5599 5599 0 0.00 0 7189 8 0 0
v_max_non_paid_invoice 1521 1521 0 0.00 0 1831 4 0 0
v_max_non_paid_realizn 3662 3662 0 0.00 0 540 3 0 0
v_min_id_clo_ord 5742 5742 0 0.00 0 891 4 0 0
v_min_id_clo_res 1038 1038 0 0.00 0 4040 17 0 0
v_min_id_ord_sup 5599 5599 0 0.00 0 5232 4 0 0
v_min_non_paid_invoice 6036 6036 0 0.00 0 18535 35 0 0
v_min_non_paid_realizn 7113 7113 0 0.00 0 19320 38 0 0
v_our_firm 10598 10598 0 0.00 0 21 1 0 0
v_reserve_write_off 20450 20450 0 0.00 0 10338 7 0 0
x_lock_depdocs_on_canc_invoice 11883 11883 0 0.00 0 21038 129 0 0
x_lock_depdocs_on_canc_sup_ord 438 438 0 0.00 0 6564 292 0 0
x_make_qstorno_1000_1200 5742 5742 0 0.00 2 35150 1136 0 0
x_make_qstorno_1200_2000 5621 5621 0 0.00 4 74851 2821 0 0
x_make_qstorno_2100_3300 472820 472820 0 0.00 0 110653 151 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-03-2021 22:28:30 to 06-03-2021 22:28:34.

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:22 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:29 15007 8192000000 10249054016 10554699776 991032464 10.791 76 64 128 0 1014964448 2837760 21094224
19:57:52 30662 8192000000 10352937616 10668859392 1378980512 14.407 100 85 171 0 1412110976 5173536 27956928
19:58:31 29354 8192000000 10383152016 10709786624 1438919024 14.940 100 89 178 0 1474481536 6891504 28671008
19:59:15 19324 8192000000 10406470160 10734415872 1462870672 15.151 100 90 180 0 1499413536 7481472 29061392
19:59:52 10588 8192000000 10432867568 10763603968 1488943600 15.380 100 86 172 1 1524977152 8336656 27696896
20:00:12 13179 8192000000 10446068240 10779131904 1505255088 15.522 100 92 184 0 1542918192 8817872 28845232
20:00:42 19321 8192000000 10467768672 10808098816 1524566448 15.690 100 91 182 2 1562902528 9792144 28543936
20:01:11 20113 8192000000 10501953920 10842345472 1554868896 15.952 100 87 174 0 1591581024 9919008 26793120
20:01:44 12048 8192000000 10519099808 10867724288 1576449184 16.138 100 83 166 0 1613231936 10771216 26011536
20:02:24 13182 8192000000 10543731648 10896388096 1596831632 16.312 100 84 168 1 1633832496 11438736 25562128
20:02:49 14753 8192000000 10560381696 10921263104 1621609264 16.524 100 81 162 1 1657594592 12065088 23920240
20:03:15 13135 8192000000 10587774048 10949709824 1643630032 16.710 100 83 165 1 1679875408 12199104 24046272
20:03:36 10908 8192000000 10605152768 10967367680 1655344208 16.810 100 79 155 2 1691425904 12847792 23233904
20:03:54 10751 8192000000 10620368544 10991792128 1676047536 16.984 100 70 140 1 1708906592 12288240 20570816
20:04:14 9053 8192000000 10652220720 11019431936 1703499856 17.214 100 85 170 1 1741855104 12643136 25712112
20:04:33 8000 8192000000 10657078096 11031584768 1717373552 17.330 100 74 148 0 1750995936 11553984 22068400
20:04:50 7719 8192000000 10667711088 11043143680 1727583040 17.415 100 75 151 1 1761547104 12151376 21812688
20:05:04 5929 8192000000 10678673184 11054100480 1740787232 17.525 100 82 164 2 1776999264 12142128 24069904
20:05:17 5653 8192000000 10694297264 11074756608 1757921776 17.667 100 80 162 3 1792289504 11752800 22614928
20:05:30 5574 8192000000 10711434768 11092144128 1772591744 17.788 100 71 142 1 1803953088 10878704 20482640
20:05:42 4035 8192000000 10724064320 11107229696 1788990624 17.923 100 83 163 1 1823448320 11849280 22608416
20:05:52 4857 8192000000 10728729392 11112222720 1795533872 17.977 100 82 159 4 1830666304 12510384 22622048
20:06:04 3654 8192000000 10735379376 11120848896 1797565792 17.994 100 80 161 2 1832578432 12657664 22354976
20:06:14 3444 8192000000 10748216528 11128012800 1803943872 18.046 100 83 165 2 1839586688 12115984 23526832
20:06:26 2523 8192000000 10745801216 11129647104 1809828736 18.094 100 91 178 2 1846918144 12851648 24237760
20:06:35 3969 8192000000 10764590880 11144679424 1814325616 18.131 100 92 180 3 1853811104 14330288 25155200
20:06:46 2660 8192000000 10767504016 11150237696 1821729040 18.192 100 89 178 3 1860979808 15054096 24196672
20:06:55 7349 8192000000 10758123152 11148656640 1823180336 18.204 100 85 170 0 1861598720 14985968 23432416
20:07:10 4838 8192000000 10784172144 11168702464 1827709632 18.241 100 83 166 0 1865679648 15421984 22548032
20:07:22 2896 8192000000 10769602288 11155640320 1838615376 18.330 100 85 170 1 1876217536 13805040 23797120
20:07:31 1565 8192000000 10781277904 11175632896 1846849664 18.397 100 88 175 2 1883856544 12661936 24344944
20:07:39 1729 8192000000 10790163328 11177934848 1850671904 18.428 100 88 173 3 1889071392 11860224 26539264
20:07:47 2369 8192000000 10809484288 11195244544 1856112592 18.472 100 92 182 0 1894148400 12774672 25261136
20:07:56 1621 8192000000 10797899840 11188076544 1862505712 18.524 100 97 196 3 1903091024 13194768 27390544
20:08:04 1690 8192000000 10802554144 11195146240 1860815328 18.510 100 92 184 2 1900704880 13751520 26138032
20:08:12 1603 8192000000 10809170432 11197018112 1864319680 18.538 100 87 171 4 1900952688 12375312 24257696
20:08:21 25453 8192000000 10799472224 11197222912 1864197584 18.537 100 66 132 3 1894794832 11316416 19280832
20:08:53 3835 8192000000 10788179360 11200004096 1868718848 18.574 100 69 139 3 1898327008 10123584 19484576
20:09:03 1920 8192000000 10797627072 11203940352 1871255936 18.594 100 69 137 4 1900011888 9955328 18800624
20:09:14 3004 8192000000 10798131232 11210719232 1877431808 18.644 100 67 134 0 1907503232 11477600 18593824
20:09:25 3534 8192000000 10790968976 11208441856 1872786736 18.607 100 48 96 1 1896444560 10215728 13442096
20:09:35 4827 8192000000 10791395440 11209777152 1873645312 18.614 100 36 70 2 1891777088 8254944 9876832
20:09:48 3799 8192000000 10807904992 11217502208 1883090064 18.690 100 62 123 4 1908604816 8165648 17349104
20:10:03 8265 8192000000 10788564720 11213271040 1882378176 18.684 100 40 79 3 1900277984 6094528 11805280
20:10:18 9771 8192000000 10794817824 11218272256 1882586544 18.686 100 26 51 1 1895892160 6242608 7063008
20:10:34 5092 8192000000 10807431504 11227918336 1887068368 18.722 100 37 74 2 1904386048 6933952 10383728
20:10:45 8765 8192000000 10793726736 11223379968 1885036448 18.706 100 18 36 1 1896895264 6730160 5128656
20:11:03 8662 8192000000 10801672512 11227430912 1891397952 18.757 100 33 64 2 1908087264 7177552 9511760
20:11:20 9318 8192000000 10813758592 11240472576 1891892736 18.761 100 30 60 1 1907870928 8121760 7856432
20:11:38 11741 8192000000 10800073936 11231866880 1893331536 18.773 100 18 36 1 1904637088 6523936 4781616
20:12:01 73910 8192000000 10806028848 11240910848 1893291888 18.772 100 23 46 1 1904467184 4581568 6593728
20:13:21 13821 8192000000 10816651888 11245412352 1896048448 18.794 100 23 46 0 1909202800 7006096 6148256
20:13:42 3740 8192000000 10811982880 11247235072 1898468656 18.814 100 26 52 1 1912877280 5687344 8721280
20:13:53 6379 8192000000 10829746192 11255201792 1904744720 18.864 100 38 76 1 1923567952 7426576 11396656
20:14:06 6668 8192000000 10825954416 11252842496 1904633664 18.864 100 23 46 2 1917410064 6382848 6393552
20:14:19 4553 8192000000 10831280816 11257577472 1907057104 18.883 100 35 69 0 1924180128 7229648 9893376
20:14:30 6955 8192000000 10832431104 11258286080 1907462464 18.886 100 39 79 1 1924322240 6011888 10847888
20:14:43 7468 8192000000 10810682736 11250171904 1890563088 18.750 99 30 61 1 1904479504 4927808 8988608
20:14:56 11139 8192000000 10814048352 11250335744 1883217664 18.691 99 17 34 1 1892922048 5276592 4427792
20:15:16 6339 8192000000 10811074464 11247009792 1883771168 18.696 99 23 44 4 1895726688 5558720 6396800
20:15:29 7009 8192000000 10819968656 11252146176 1904747568 18.864 100 22 44 1 1916893568 5703856 6442144
20:15:45 16355 8192000000 10816845264 11254595584 1904517328 18.863 100 10 20 0 1912793712 5590848 2685536
20:16:09 8598 8192000000 10810597712 11253792768 1903820896 18.857 100 17 32 3 1914472272 6205584 4445792
20:16:25 54011 8192000000 10818704656 11248021504 1855739408 18.469 97 37 74 1 1871550048 4687872 11122768
20:17:34 19953 8192000000 10808585744 11244601344 1868386496 18.571 98 24 48 0 1881922768 6558096 6978176
20:18:00 9346 8192000000 10796991680 11233574912 1868263184 18.570 99 17 34 2 1878532784 5824528 4445072
20:18:15 8102 8192000000 10767239808 11194941440 1782113232 17.867 95 26 52 0 1794977408 5209872 7654304
20:18:31 5013 8192000000 10782492080 11202732032 1857210720 18.481 100 30 59 2 1871704928 6017744 8476464
20:18:44 7628 8192000000 10799032352 11224817664 1854450608 18.458 99 27 54 0 1868483408 6441744 7591056
20:18:59 8871 8192000000 10747480992 11169554432 1776733184 17.823 96 15 30 1 1786932608 5399168 4800256
20:19:14 4798 8192000000 10767634368 11189948416 1844562944 18.378 100 19 38 0 1855517232 6092928 4861360
20:19:29 4782 8192000000 10729495376 11155640320 1794180672 17.966 98 30 60 0 1809791968 6031200 9580096
20:19:46 5258 8192000000 10689392400 11104305152 1731906352 17.451 95 27 54 1 1746001024 6207840 7886832
20:19:58 14101 8192000000 10741782160 11166265344 1793297696 17.959 98 17 34 2 1804512048 6179024 5035328
20:20:20 7704 8192000000 10703412464 11111878656 1742664240 17.541 96 16 32 1 1752838064 5393728 4780096
20:20:34 6212 8192000000 10675771712 11083366400 1704410800 17.222 96 18 36 1 1714938704 5122416 5405488
20:20:47 5559 8192000000 10694920688 11096842240 1723459408 17.381 97 38 76 2 1740204528 5185952 11559168
20:20:59 7521 8192000000 10675157488 11089752064 1744712768 17.558 98 17 34 1 1755192688 5497248 4982672
20:21:13 74278 8192000000 10687993408 11104870400 1701287456 17.196 95 27 54 0 1714334400 5320480 7726464
20:22:35 9191 8192000000 10718285072 11135479808 1789725456 17.930 99 29 58 0 1803971760 5091376 9154928
20:22:53 4461 8192000000 10733392256 11154198528 1820896528 18.185 100 38 76 2 1839592688 6572496 12123664
20:23:04 5398 8192000000 10743708832 11163340800 1824861856 18.217 100 27 54 1 1838755024 5959104 7934064
20:23:16 6537 8192000000 10740290000 11165253632 1827545200 18.239 100 33 66 0 1843513888 6652496 9316192
20:23:35 8160 8192000000 10742604016 11162329088 1814449856 18.132 99 31 62 1 1829508576 5806400 9252320
20:23:49 6708 8192000000 10748018496 11168788480 1831516912 18.272 100 22 44 2 1843791824 5711776 6563136
20:24:02 10463 8192000000 10763516304 11186339840 1847832016 18.405 100 31 62 0 1866677648 10674160 8171472
20:24:21 5449 8192000000 10776209392 11197452288 1854374736 18.458 100 38 74 2 1872957248 6469728 12112784
20:24:33 15499 8192000000 10774621280 11196858368 1836047920 18.309 99 19 37 1 1846791616 5422224 5321472
20:24:56 8074 8192000000 10765858608 11200782336 1857902096 18.486 100 25 50 0 1871238016 5645696 7690224
20:25:14 10550 8192000000 10770796432 11203731456 1863031056 18.528 100 25 50 2 1876538128 6421296 7085776
20:25:38 14707 8192000000 10773086160 11204268032 1860561424 18.508 100 9 18 2 1868513424 5574272 2377728
20:25:59 18553 8192000000 10780699888 11212423168 1872392608 18.604 100 22 44 3 1883569200 5170960 6005632
20:26:27 133968 8192000000 10837495808 11258007552 1885294416 18.708 100 35 70 1 1900807408 5427184 10085808
20:28:49 18233 8192000000 10848629744 11273220096 1923526864 19.015 100 40 79 0 1943410608 8009952 11873792
20:29:18 5327 8192000000 10863417200 11286671360 1934891168 19.106 100 54 104 3 1958651872 7892816 15867888
20:29:36 13191 8192000000 10887236912 11306668032 1946971440 19.202 100 59 118 2 1973594416 9186656 17436320
20:30:01 19967 8192000000 10894984816 11319394304 1956990112 19.282 100 46 91 0 1982522560 12343840 13188608
20:30:34 85329 8192000000 10904628384 11334610944 1966167824 19.355 100 41 82 1 1993874352 15205872 12500656
20:32:20 28800 8192000000 10901684176 11343687680 1971401552 19.397 100 28 56 1 1998725072 18199248 9124272
20:32:56 5103 8192000000 10917320720 11345076224 1976779472 19.439 100 42 83 1 2006891904 17835712 12276720
20:33:11 12867 8192000000 10925800032 11354316800 1985040368 19.505 100 55 110 0 2019386576 17915568 16430640
20:33:41 3927 8192000000 10955711040 11370729472 1996629728 19.596 100 72 143 3 2039130880 21976928 20524224
20:33:52 12494 8192000000 10952920320 11375316992 1996719312 19.597 100 56 112 1 2037738992 24027936 16991744
20:34:11 6257 8192000000 10950837968 11374297088 1997272448 19.601 100 64 128 1 2041682592 24028016 20382128
20:34:27 16015 8192000000 10939870096 11367469056 1981272240 19.475 99 65 130 0 2027120592 26111840 19736512
20:35:02 12243 8192000000 10941703952 11375460352 1994753392 19.581 100 53 107 0 2037667392 26297360 16616640
20:35:24 4701 8192000000 10957514592 11382374400 1998921008 19.614 100 59 117 1 2042309840 24877552 18511280
20:35:36 7802 8192000000 10961185104 11388112896 2003579408 19.651 100 68 136 2 2051396592 26762432 21054752
20:35:58 6155 8192000000 10969220000 11389276160 2004671312 19.660 100 62 121 2 2048242944 24219872 19351760
20:36:11 4664 8192000000 10965345152 11394658304 2009797312 19.700 100 70 140 2 2055496496 24448016 21251168
20:36:22 5304 8192000000 10976469280 11396100096 2009978256 19.701 100 64 125 1 2054225760 25141952 19105552
20:36:37 7130 8192000000 10970208512 11399884800 2009640352 19.699 100 63 126 1 2055760576 26707840 19412384
20:36:53 7309 8192000000 10989802048 11410210816 2018562992 19.769 100 74 146 1 2066830016 25784560 22482464
20:37:08 4491 8192000000 10983010992 11414855680 2023192544 19.805 100 61 122 1 2069760464 27184560 19383360
20:37:23 2626 8192000000 10992871280 11422580736 2029054752 19.851 100 71 140 2 2076562352 26232160 21275440
20:37:32 2959 8192000000 11005030768 11427241984 2038038624 19.922 100 85 164 2 2091393456 28337536 25017296
20:37:42 7729 8192000000 11004381728 11430035456 2034358048 19.893 100 76 152 0 2088701456 30342448 24000960
20:37:58 9421 8192000000 11006344880 11435163648 2037310704 19.916 100 69 138 2 2091727840 32396208 22020928
20:38:18 11536 8192000000 10995974512 11426504704 2002423984 19.642 98 70 140 2 2057933184 33149232 22359968
20:38:40 4022 8192000000 11004945840 11427680256 2031743616 19.872 100 77 154 1 2089278832 33181040 24354176
20:38:53 1862 8192000000 11022951760 11440189440 2037813680 19.920 100 87 168 1 2098001792 33711696 26476416
20:39:01 5215 8192000000 11013540304 11443589120 2043412208 19.964 100 79 158 0 2102661216 33905360 25343648
20:39:15 2731 8192000000 11014073728 11444899840 2044826992 19.975 100 71 142 2 2102013184 34795536 22390656
20:39:27 4683 8192000000 11017800832 11447922688 2049555216 20.012 100 76 151 1 2105995584 32677632 23762736
20:39:40 4037 8192000000 11012846992 11440963584 2039315600 19.932 100 71 142 1 2093595232 32120224 22159408
20:39:52 3563 8192000000 11016419824 11441672192 2043047952 19.961 100 73 147 2 2100209920 33728768 23433200
20:40:05 2954 8192000000 11003847152 11425947648 2026745440 19.833 99 83 167 2 2084349856 31268928 26335488
20:40:17 5046 8192000000 11022163632 11448492032 2044370096 19.971 100 80 160 1 2103050720 33951904 24728720
20:40:29 1860 8192000000 11033565728 11454332928 2051083280 20.024 100 94 188 2 2113063888 33940448 28040160
20:40:39 3949 8192000000 11003816128 11428442112 2008970736 19.693 98 83 166 1 2069779648 34298512 26510400
20:40:51 4423 8192000000 11014894512 11440816128 2036353808 19.908 100 81 162 0 2094928544 33305968 25268768
20:41:06 2897 8192000000 11009593104 11433889792 2030806736 19.865 100 83 163 2 2090615248 34050224 25758288
20:41:16 4862 8192000000 11012156352 11441074176 2024171968 19.813 99 72 144 0 2082606928 35559568 22875392
20:41:28 3411 8192000000 11019425904 11447619584 2041447200 19.948 100 84 165 1 2103182144 36024960 25709984
20:41:39 1880 8192000000 11035768608 11459874816 2047175808 19.993 100 82 164 0 2110194864 36723312 26295744
20:41:49 3481 8192000000 11037746304 11467194368 2055680384 20.059 100 82 163 1 2122487504 40537648 26269472
20:41:59 4952 8192000000 11028264160 11453808640 2032009280 19.874 99 71 139 1 2090469920 36496720 21963920
20:42:12 2743 8192000000 11013325440 11435880448 2023294592 19.806 99 84 168 4 2087751808 37668752 26788464
20:42:22 2626 8192000000 11029590224 11448516608 2040404640 19.940 100 92 184 1 2107735808 39597808 27733360
20:42:34 4659 8192000000 11019360592 11438501888 2030963760 19.866 100 77 155 0 2095607536 40472416 24171360
20:42:48 4135 8192000000 11014963104 11442237440 2033260416 19.884 100 84 165 0 2099264384 40756576 25247392
20:42:59 4137 8192000000 11019788512 11446231040 2018123664 19.765 99 80 158 2 2087225040 44372832 24728544
20:43:10 2811 8192000000 11029751568 11454238720 2039809856 19.935 100 86 172 0 2110922032 42666960 28445216
20:43:19 1925 8192000000 11020507024 11436224512 2020681568 19.786 99 85 171 1 2089734144 42154832 26897744
20:43:29 2553 8192000000 11014097280 11437998080 2027917104 19.842 100 90 179 2 2099362992 43783088 27662800
20:43:40 2834 8192000000 11021212176 11443552256 2028994976 19.851 100 83 164 1 2101371696 45995248 26381472
20:43:50 2292 8192000000 11024678176 11450998784 2031679520 19.872 100 81 160 1 2104553984 47237248 25637216
20:43:59 2626 8192000000 11010027744 11434127360 2019135568 19.773 100 76 152 1 2088127232 44946112 24045552
20:44:09 5543 8192000000 10992305824 11430432768 2015105136 19.742 100 68 136 0 2082463040 45772992 21584912
20:44:24 9515 8192000000 10970283232 11409305600 1969214192 19.379 98 54 108 4 2032276752 44377824 18684736
20:44:43 14004 8192000000 10970574112 11420897280 1999537216 19.619 100 43 86 2 2057769584 43201952 15030416
20:45:06 10782 8192000000 10977186960 11425505280 2008850528 19.692 100 45 90 1 2065954080 41574608 15528944
20:45:25 4771 8192000000 10959461872 11385167872 1947901296 19.210 97 57 115 1 2012095232 45715440 18478496
20:45:39 24280 8192000000 10918330592 11367538688 1915899136 18.954 97 39 79 1 1972840704 43412192 13529376
20:46:15 3431 8192000000 10935815952 11359158272 1938743456 19.137 99 51 100 1 1996423216 41144304 16535456
20:46:28 12362 8192000000 10927995824 11372773376 1948304656 19.213 99 39 78 0 2007663728 45470032 13889040
20:46:52 22186 8192000000 10922734256 11377348608 1915026704 18.947 97 37 74 2 1981069968 53204640 12838624
20:47:33 21544 8192000000 10875952016 11330928640 1882047136 18.682 97 21 42 0 1927290416 37697872 7545408
20:48:11 25498 8192000000 10895372176 11354935296 1941344736 19.157 100 23 46 4 1983149872 34243760 7561376
20:49:00 30041 8192000000 10911609664 11366330368 1949654768 19.224 100 26 52 1 1990743584 32896688 8192128
20:49:48 28759 8192000000 10889217296 11362119680 1923471088 19.015 99 17 33 1 1965891328 36285424 6134816
20:50:23 22409 8192000000 10886359536 11337695232 1878989696 18.657 97 12 24 0 1912271408 29141168 4140544
20:50:57 89117 8192000000 10863112896 11314548736 1822036992 18.194 94 10 20 0 1843555344 18726176 2792176
20:52:32 58616 8192000000 10872778784 11330621440 1912211776 18.924 99 18 36 0 1936782832 18934560 5636496
20:53:43 94713 8192000000 10867343664 11340865536 1883320608 18.692 97 16 33 0 1899776848 12055824 4400416
20:55:23 175225 8192000000 10844142816 11279699968 1787979136 17.915 92 24 48 4 1805009264 10230480 6799648
20:58:29 47478 8192000000 10843992192 11289669632 1854572144 18.459 96 43 85 5 1878465904 11629104 12264656
20:59:29 101655 8192000000 10823425696 11273265152 1811733856 18.110 95 18 36 2 1825731344 8913168 5084320
21:01:38 20020 8192000000 10864714176 11315765248 1930248944 19.069 100 30 60 0 1949599680 10892416 8458320
21:02:04 18889 8192000000 10897323312 11334672384 1947858224 19.209 100 54 107 0 1974710576 11230544 15621808
21:02:33 21744 8192000000 10904099616 11343167488 1956292912 19.277 100 63 124 1 1986850480 12946464 17611104
21:03:08 24047 8192000000 10889676608 11337027584 1935398000 19.110 99 45 90 1 1963123856 14767952 12957904
21:03:39 24964 8192000000 10882483600 11319300096 1911708448 18.920 98 47 93 1 1938750576 13118480 13923648
21:04:12 33099 8192000000 10859219488 11320459264 1918387216 18.974 99 17 34 1 1936077728 12449824 5240688
21:04:52 56962 8192000000 10848287312 11320786944 1894365712 18.781 98 15 29 0 1909162192 10404656 4391824
21:06:01 45063 8192000000 10874832976 11336175616 1924993888 19.027 99 14 28 0 1937884656 8561392 4329376
21:06:55 136474 8192000000 10865666512 11338301440 1926726816 19.041 99 17 34 1 1940687104 9319632 4640656
21:09:23 32961 8192000000 10876780864 11336314880 1935565760 19.111 99 18 35 1 1948525504 8029056 4930688
21:10:02 36849 8192000000 10880316912 11350274048 1952855904 19.249 100 11 22 0 1969297856 12904304 3537648
21:10:50 50465 8192000000 10888881184 11358056448 1959485840 19.302 100 12 24 0 1973174272 10372672 3315760
21:11:47 79894 8192000000 10889252448 11363180544 1965326080 19.348 100 18 36 1 1979132400 8720032 5086288
21:13:13 17944 8192000000 10919061072 11377958912 1978263968 19.451 100 23 46 0 1992276016 7531440 6480608
21:13:44 46645 8192000000 10933128528 11378311168 1965492976 19.350 99 31 62 1 1989551952 15310752 8748224
21:14:37 36373 8192000000 10916706224 11382370304 1980294240 19.467 100 32 62 1 2005953520 16632768 9026512
21:15:23 73907 8192000000 10908278064 11377283072 1966507648 19.358 99 16 32 0 1992594368 21210416 4876304
21:16:43 80573 8192000000 10914773136 11386990592 1978205696 19.450 100 14 28 0 1995777248 13810624 3760928
21:18:13 85918 8192000000 10940288480 11387138048 1922119184 19.004 97 15 30 1 1939362272 13097120 4145968
21:19:45 34591 8192000000 10906160576 11369291776 1924582576 19.024 97 26 52 1 1943359600 11684560 7092464
21:21:06 23874 8192000000 10918049584 11375607808 1977345232 19.444 100 27 54 0 1993139664 7674400 8120032
21:21:36 19946 8192000000 10946009872 11387719680 1991135968 19.553 100 47 93 1 2014093472 9928528 13028976
21:22:02 73235 8192000000 10910393648 11361587200 1950563440 19.231 98 31 62 1 1971662592 12087968 9011184
21:23:31 52113 8192000000 10919159232 11381637120 1970729776 19.391 99 38 75 3 1989076656 8293312 10053568
21:25:10 41167 8192000000 10886319840 11364933632 1918737776 18.977 97 32 64 1 1944897776 16668992 9491008
21:25:58 49846 8192000000 10901733536 11373580288 1949916048 19.226 99 22 44 1 1969957776 14099440 5942288
21:26:54 6076 8192000000 10907799520 11368497152 1975684624 19.431 100 29 58 1 1994633856 11308832 7640400
21:27:06 64147 8192000000 10874364992 11346997248 1867704864 18.566 94 28 56 1 1884438272 9227248 7506160
21:28:21 48503 8192000000 10858866592 11349463040 1930671296 19.072 99 6 12 0 1941530800 9662752 1196752
21:29:16 41819 8192000000 10885592352 11358117888 1953270624 19.253 100 11 22 0 1968324288 12115904 2937760
21:30:04 56344 8192000000 10863752544 11346526208 1913635248 18.936 98 13 26 2 1929560384 12065120 3860016
21:31:06 28313 8192000000 10867736544 11333591040 1860146480 18.504 95 13 26 0 1873635232 9324288 4164464
21:31:41 44948 8192000000 10856319488 11334656000 1889185632 18.739 97 13 24 1 1903585632 10948128 3451872
21:32:52 24426 8192000000 10897575104 11350269952 1939451568 19.142 99 47 94 0 1965020352 12196224 13372560
21:33:22 74739 8192000000 10874295856 11340464128 1877878464 18.648 96 19 38 1 1898727408 15075088 5773856
21:34:43 62751 8192000000 10894813136 11353255936 1895460048 18.790 97 23 44 2 1915468336 13821568 6186720
21:35:57 35310 8192000000 10892128576 11358498816 1939129376 19.140 99 31 62 2 1968119824 20281136 8709312
21:36:49 54945 8192000000 10856578272 11342921728 1877530944 18.645 96 6 12 0 1894737568 15411792 1794832
21:37:56 30490 8192000000 10858685648 11317350400 1880310400 18.668 97 31 62 0 1898028608 9096592 8621616
21:38:37 11529 8192000000 10863742080 11305078784 1908715152 18.896 99 50 100 0 1932213568 9972832 13525584
21:38:56 28789 8192000000 10874805168 11320700928 1887094256 18.722 98 46 92 2 1913115072 13209456 12811360
21:39:54 88652 8192000000 10849652688 11329462272 1872048848 18.601 97 17 34 0 1894724688 17982240 4693600
21:41:29 26684 8192000000 10867486928 11318796288 1876085248 18.633 97 19 38 0 1888908352 7316096 5507008
21:42:40 35075 8192000000 10873923504 11344150528 1933704144 19.096 100 20 40 1 1949698688 10601936 5392608
21:44:26 75627 8192000000 10870534768 11325177856 1850317488 18.425 95 23 46 1 1869560416 12495024 6747904
21:46:17 74580 8192000000 10854106496 11318575104 1875608384 18.630 97 20 40 0 1892819184 11331824 5878976
21:47:42 57841 8192000000 10869774896 11326148608 1924454032 19.023 99 30 60 2 1948754000 15879168 8420800
21:48:49 1181 8192000000 10880222544 11340058624 1944069104 19.179 100 35 70 1 1972267568 17879408 10319056
21:48:57 55235 8192000000 10863852672 11344416768 1922829360 19.010 99 21 42 0 1945468864 16038624 6600880
21:50:11 47991 8192000000 10865486528 11361026048 1945230960 19.188 100 9 18 0 1964446272 16219600 2995712
21:51:05 2779 8192000000 10864785856 11361157120 1945387136 19.190 100 2 4 0 1961304000 14938816 978048
21:51:22 39679 8192000000 10859120976 11336916992 1930055296 19.067 99 14 28 0 1941694864 8257568 3382000
21:52:08 61711 8192000000 10833782048 11304255488 1908194704 18.892 98 7 14 0 1918850672 8643136 2012832
21:53:30 92169 8192000000 10863364640 11337863168 1924847552 19.026 99 20 40 1 1941041584 10492528 5701504
21:55:08 51338 8192000000 10851272240 11334176768 1911008496 18.915 99 17 34 1 1927931536 12134288 4788752
21:56:06 32268 8192000000 10835047792 11323056128 1902748864 18.848 99 8 16 0 1923222720 18551376 1922480
21:57:02 62391 8192000000 10876891776 11353333760 1912373552 18.926 98 12 25 0 1924481360 9256288 2851520
21:58:11 38076 8192000000 10883927552 11359289344 1945677104 19.192 99 25 50 1 1963085264 10361184 7046976
21:59:46 63833 8192000000 10896946752 11359821824 1959120000 19.299 99 25 50 1 1977594368 10263312 8211056
22:00:58 31413 8192000000 10914738752 11382648832 1961096192 19.315 99 25 50 2 1982616416 14529472 6990752
22:01:44 54597 8192000000 10912249072 11392176128 1965472576 19.350 99 19 38 1 1988144112 17482624 5188912
22:02:45 60968 8192000000 10912898752 11395362816 1968262384 19.372 99 16 32 1 1989300464 16371392 4666688
22:03:53 93735 8192000000 10923417712 11391381504 1945227008 19.188 98 14 28 0 1966638528 17554656 3856864
22:05:37 80845 8192000000 10903583488 11385274368 1906683072 18.880 96 25 50 1 1926385904 12800224 6902608
22:07:06 47882 8192000000 10900878704 11370561536 1930178944 19.068 98 7 14 0 1945356912 13207424 1970544
22:08:02 61293 8192000000 10897644848 11388407808 1948047216 19.211 99 33 66 1 1973314560 16471856 8795488
22:09:10 133115 8192000000 10906978016 11376488448 1920634496 18.992 97 11 22 0 1935842304 11973296 3234512
22:11:30 115593 8192000000 10886738896 11366768640 1933920736 19.098 98 16 32 0 1954682928 15707776 5054416
22:15:25 7138 8192000000 10904569632 11382640640 1977371072 19.444 100 40 74 2 1996608944 7808096 11429776
22:15:44 27824 8192000000 10880939280 11354169344 1925945968 19.034 97 25 50 0 1939643536 7354016 6343552
22:16:35 58712 8192000000 10871472192 11350130688 1933993648 19.099 99 11 22 0 1943754560 6424496 3336416
22:17:54 46117 8192000000 10882653712 11359502336 1944250368 19.181 99 15 30 1 1958115344 9635232 4229744
22:18:46 69237 8192000000 10850031760 11327012864 1842411552 18.360 94 18 32 0 1860540512 13119616 5009344
22:20:43 50720 8192000000 10832802848 11319320576 1905195584 18.868 99 6 12 1 1919884064 13021216 1667264
22:22:55 62229 8192000000 10859790928 11336679424 1880436112 18.669 97 14 29 2 1896834992 12352496 4046384
22:24:12 52941 8192000000 10852038320 11335585792 1865727776 18.550 96 16 32 1 1888072480 17382240 4962464
22:25:11 43860 8192000000 10888046560 11348668416 1905203216 18.868 98 23 46 0 1924178496 12080048 6895232
22:26:06 32767 8192000000 10862701152 11322064896 1870004240 18.584 96 34 69 1 1891273328 11622400 9646688
22:26:45 44656 8192000000 9460389856 9763512320 606174704 6.889 32 5 10 0 613668720 6186752 1307264

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 06-03-2021 22:28:36 to 06-03-2021 22:29:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 79 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 06-03-2021 22:29:07 to 06-03-2021 22:29:09.

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          240799
MON$OLDEST_ACTIVE               241726
MON$OLDEST_SNAPSHOT             241726
MON$NEXT_TRANSACTION            241726
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                       2022592
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
:103: 
:104: mscs-test-161.budzdorov.ru    Sat Mar  6 22:27:32 2021
:105:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:106: 
:107: 
:108: mscs-test-161.budzdorov.ru    Sat Mar  6 22:27:32 2021
:109:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:110: 
:111: 
:112: mscs-test-161.budzdorov.ru    Sat Mar  6 22:27:33 2021
:113:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:114: 
:115: 
:116: mscs-test-161.budzdorov.ru    Sat Mar  6 22:27:35 2021
:117:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:118: 
--- end of diff output ---

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

06.03.21 22:29:10. 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-03-06 22:29:13 No severe PSQL-related problems occured
06.03.21 22:29:14. End of report.