Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 31.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 17510028 kB
MemAvailable 31451804 kB
Buffers 0 kB
Cached 14148864 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-31 22:27:26
DTS_END                         2021-03-31 22:27:26.5720
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/58382
TRN_ID                          236334
ATT_ID                          632
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: 8964.08 21148 1075690
customer order: creation 174.49 337 20939
customer order: refuse 14.48 388 1737
order to supplier: creation 46.43 1430 5571
order to supplier: removal 3.38 90403 405
invoice (draft): creation 46.63 3603 5596
invoice (draft): removal 49.40 800 5928
invoice accept: apply 42.09 17114 5051
invoice accept: cancel 44.62 852 5354
customer reserve: creation 3869.53 169 464343
customer reserve: removal 4375.37 54 525044
realization accept: apply 85.17 197 10220
realization accept: cancel 82.02 99 9842
payment from customer: creation 59.95 122 7194
payment from customer: removal 5.77 81 692
payment to supplier: creation 48.52 140 5822
payment to supplier: removal 3.50 114 420
service: total inventory turnovers 4.98 935 598
service: total monetary turnovers 7.01 23 841
service: aggregate perf. data 0.74 26664 89
service: refresh index statistics 0.03 279443 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-03-2021 22:28:12 to 31-03-2021 22:28:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8186
TEST_TIME 2 6149
TEST_TIME 3 6066
TEST_TIME 4 6351
TEST_TIME 5 6242
TEST_TIME 6 6691
TEST_TIME 7 6463
TEST_TIME 8 6084
TEST_TIME 9 6037
TEST_TIME 10 6538
TEST_TIME 11 6458
TEST_TIME 12 6771
TEST_TIME 13 6809
TEST_TIME 14 6992
TEST_TIME 15 7241
TEST_TIME 16 7544
TEST_TIME 17 7709
TEST_TIME 18 8168
TEST_TIME 19 8428
TEST_TIME 20 8562
TEST_TIME 21 9057
TEST_TIME 22 9187
TEST_TIME 23 9293
TEST_TIME 24 9295
TEST_TIME 25 9495
TEST_TIME 26 9736
TEST_TIME 27 9995
TEST_TIME 28 10033
TEST_TIME 29 10484
TEST_TIME 30 10299
TEST_TIME 31 10114
TEST_TIME 32 10133
TEST_TIME 33 10078
TEST_TIME 34 10086
TEST_TIME 35 9992
TEST_TIME 36 9806
TEST_TIME 37 9746
TEST_TIME 38 9956
TEST_TIME 39 9931
TEST_TIME 40 9804
TEST_TIME 41 9657
TEST_TIME 42 9595
TEST_TIME 43 9639
TEST_TIME 44 9607
TEST_TIME 45 9551
TEST_TIME 46 9502
TEST_TIME 47 9359
TEST_TIME 48 9266
TEST_TIME 49 9266
TEST_TIME 50 9295
TEST_TIME 51 9208
TEST_TIME 52 9286
TEST_TIME 53 9169
TEST_TIME 54 9149
TEST_TIME 55 9015
TEST_TIME 56 9046
TEST_TIME 57 8946
TEST_TIME 58 8969
TEST_TIME 59 8954
TEST_TIME 60 8963
TEST_TIME 61 8949
TEST_TIME 62 8940
TEST_TIME 63 8965
TEST_TIME 64 8933
TEST_TIME 65 9012
TEST_TIME 66 9034
TEST_TIME 67 9069
TEST_TIME 68 9218
TEST_TIME 69 9148
TEST_TIME 70 9138
TEST_TIME 71 9153
TEST_TIME 72 9176
TEST_TIME 73 9143
TEST_TIME 74 9183
TEST_TIME 75 9086
TEST_TIME 76 9061
TEST_TIME 77 9104
TEST_TIME 78 9031
TEST_TIME 79 9031
TEST_TIME 80 9061
TEST_TIME 81 9003
TEST_TIME 82 8997
TEST_TIME 83 9017
TEST_TIME 84 8934
TEST_TIME 85 8941
TEST_TIME 86 8980
TEST_TIME 87 8941
TEST_TIME 88 8974
TEST_TIME 89 9053
TEST_TIME 90 9037
TEST_TIME 91 9056
TEST_TIME 92 9092
TEST_TIME 93 9134
TEST_TIME 94 9116
TEST_TIME 95 9178
TEST_TIME 96 9176
TEST_TIME 97 9176
TEST_TIME 98 9185
TEST_TIME 99 9237
TEST_TIME 100 9245
TEST_TIME 101 9197
TEST_TIME 102 9134
TEST_TIME 103 9149
TEST_TIME 104 9143
TEST_TIME 105 9111
TEST_TIME 106 9089
TEST_TIME 107 9074
TEST_TIME 108 9023
TEST_TIME 109 9011
TEST_TIME 110 8965
TEST_TIME 111 8928
TEST_TIME 112 8975
TEST_TIME 113 8984
TEST_TIME 114 9015
TEST_TIME 115 9008
TEST_TIME 116 9008
TEST_TIME 117 9039
TEST_TIME 118 9038
TEST_TIME 119 9021
TEST_TIME 120 8970

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 31-03-2021 22:28:15 to 31-03-2021 22:28:19.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1504617 1504617 0 0.00 0 23563 6 0 0
doc_list_biud 1504610 1504610 0 0.00 0 45076 25 0 0
sp_add_invoice_to_stock 5182 5051 131 2.52 51 175092 17114 0 131
sp_cancel_adding_invoice 5354 5354 0 0.00 5 43550 853 0 0
sp_cancel_client_order 1737 1737 0 0.00 5 10919 388 0 0
sp_cancel_customer_reserve 525044 525044 0 0.00 1 24247 55 0 0
sp_cancel_pay_from_customer 692 692 0 0.00 3 5972 81 0 0
sp_cancel_pay_to_supplier 420 420 0 0.00 3 8464 115 0 0
sp_cancel_supplier_invoice 5937 5928 9 0.15 2 45099 801 0 9
sp_cancel_supplier_order 405 405 0 0.00 7 902000 90404 0 0
sp_cancel_write_off 9842 9842 0 0.00 1 8474 100 0 0
sp_client_order 20939 20939 0 0.00 3 21767 337 0 0
sp_customer_reserve 464343 464343 0 0.00 0 47548 170 0 0
sp_fill_shopping_cart 32065 32065 0 0.00 1 15270 41 0 0
sp_fill_shopping_cart_clo_res 464316 464316 0 0.00 0 11818 12 0 0
sp_get_clo_for_invoice 5024 5024 0 0.00 0 33834 281 0 0
sp_kill_cost_storno 16308 16308 0 0.00 0 10937 56 0 0
sp_kill_qstorno_ret_qs2qd 1066263 1066263 0 0.00 0 45066 30 0 0
sp_kill_qty_storno 563548 563548 0 0.00 0 45072 66 0 0
sp_lock_selected_doc 21027 21027 0 0.00 0 10058 5 0 0
sp_make_cost_storno 28258 28258 0 0.00 0 16985 56 0 0
sp_multiply_rows_for_pdistr 28256 28256 0 0.00 0 8451 32 0 0
sp_multiply_rows_for_qdistr 20939 20939 0 0.00 0 13469 133 0 0
sp_pay_from_customer 7194 7194 0 0.00 4 20182 122 0 0
sp_pay_to_supplier 5822 5822 0 0.00 4 33545 141 0 0
sp_payment_common 13015 13015 0 0.00 1 33495 35 0 0
sp_qd_handle_on_cancel_clo 1737 1737 0 0.00 0 10911 362 0 0
sp_qd_handle_on_invoice_upd_sts 10373 10373 0 0.00 0 22030 334 0 0
sp_qd_handle_on_reserve_upd_sts 10219 10219 0 0.00 0 17972 61 0 0
sp_reserve_write_off 10220 10220 0 0.00 6 23577 197 0 0
sp_supplier_invoice 5596 5596 0 0.00 7 81659 3604 0 0
sp_supplier_order 5571 5571 0 0.00 4 63621 1430 0 0
srv_aggregate_perf_data 90 89 1 1.11 2907 262356 26665 0 1
srv_fill_mon_cache_memory 159 159 0 0.00 1188 129181 32606 0 0
srv_find_qd_qs_mism 1027044 1027044 0 0.00 0 23042 5 0 0
srv_make_invnt_saldo 598 598 0 0.00 30 19820 935 0 0
srv_make_money_saldo 841 841 0 0.00 1 1222 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 94996 598701 279443 0 0
t$perf-abend:sp_add_invoice_to_stock 131 131 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 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 5051 5051 0 0.00 0 14425 176 0 0
t$perf-norm:sp_cancel_adding_invoice 405 405 0 0.00 1 5934 116 0 0
t$perf-norm:sp_cancel_client_order 1737 1737 0 0.00 0 6685 16 0 0
t$perf-norm:sp_cancel_customer_reserve 677 677 0 0.00 0 834 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 692 692 0 0.00 0 3725 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 420 420 0 0.00 0 5785 26 0 0
t$perf-norm:sp_cancel_supplier_invoice 387 387 0 0.00 0 2383 36 0 0
t$perf-norm:sp_cancel_supplier_order 405 405 0 0.00 0 13844 1346 0 0
t$perf-norm:sp_cancel_write_off 1070 1070 0 0.00 0 6614 24 0 0
t$perf-norm:sp_client_order 20939 20939 0 0.00 0 10866 18 0 0
t$perf-norm:sp_customer_reserve 1037 1037 0 0.00 0 6887 20 0 0
t$perf-norm:sp_pay_from_customer 7194 7194 0 0.00 0 8229 10 0 0
t$perf-norm:sp_pay_to_supplier 5822 5822 0 0.00 0 7967 13 0 0
t$perf-norm:sp_reserve_write_off 10220 10220 0 0.00 0 16578 16 0 0
t$perf-norm:sp_supplier_invoice 5596 5596 0 0.00 0 8492 19 0 0
t$perf-norm:sp_supplier_order 5571 5571 0 0.00 0 10858 19 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 914 24 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 669 18 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 1105 24 0 0
t$perf-norm:srv_make_money_saldo 841 841 0 0.00 0 1348 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 22 9 0 0
v_add_invoice_to_stock 10292 10030 262 2.54 0 7855 20 0 262
v_all_customers 38382 38382 0 0.00 0 83 1 0 0
v_all_suppliers 30472 30472 0 0.00 0 23 1 0 0
v_all_wares 41874 41874 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 810 810 0 0.00 0 735 6 0 0
v_cancel_client_order 3474 3474 0 0.00 0 5435 7 0 0
v_cancel_customer_prepayment 1384 1384 0 0.00 0 4765 10 0 0
v_cancel_customer_reserve 1354 1354 0 0.00 0 2300 8 0 0
v_cancel_payment_to_supplier 840 840 0 0.00 0 500 4 0 0
v_cancel_supplier_invoice 792 774 18 2.27 0 5761 30 0 18
v_cancel_supplier_order 810 810 0 0.00 0 5666 10 0 0
v_cancel_write_off 2140 2140 0 0.00 0 1315 12 0 0
v_max_id_clo_ord 5556 5556 0 0.00 0 1326 1 0 0
v_max_id_clo_res 1037 1037 0 0.00 0 1396 13 0 0
v_max_id_ord_sup 5564 5564 0 0.00 0 2637 4 0 0
v_max_non_paid_invoice 1705 1705 0 0.00 0 790 3 0 0
v_max_non_paid_realizn 3796 3796 0 0.00 0 7991 8 0 0
v_min_id_clo_ord 5556 5556 0 0.00 0 2387 7 0 0
v_min_id_clo_res 1037 1037 0 0.00 0 3058 9 0 0
v_min_id_ord_sup 5564 5564 0 0.00 0 5692 7 0 0
v_min_non_paid_invoice 5821 5821 0 0.00 0 12301 19 0 0
v_min_non_paid_realizn 7194 7194 0 0.00 0 20169 19 0 0
v_our_firm 10288 10288 0 0.00 0 54 1 0 0
v_reserve_write_off 20434 20434 0 0.00 0 6114 8 0 0
x_lock_depdocs_on_canc_invoice 10895 10895 0 0.00 0 19776 117 0 0
x_lock_depdocs_on_canc_sup_ord 405 405 0 0.00 0 2717 312 0 0
x_make_qstorno_1000_1200 5571 5571 0 0.00 2 63539 1345 0 0
x_make_qstorno_1200_2000 5596 5596 0 0.00 4 80050 3451 0 0
x_make_qstorno_2100_3300 464343 464343 0 0.00 0 47546 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-03-2021 22:28:20 to 31-03-2021 22:28:24.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:30 8 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:36 19926 8192000000 10241134480 10545848320 820198672 9.100 65 51 107 0 839142320 2291408 16652240
19:58:04 41804 8192000000 10339101424 10656059392 1387397296 14.483 100 91 182 1 1422408080 5230624 29780160
19:58:55 39440 8192000000 10375903968 10697191424 1423112128 14.800 100 92 184 0 1459939088 6816032 30010928
19:59:54 28884 8192000000 10416648512 10744348672 1463431712 15.156 100 92 185 0 1501201904 7993440 29776752
20:00:37 30445 8192000000 10443278240 10778546176 1489229296 15.382 100 91 179 3 1527060672 8923488 28907888
20:01:19 15184 8192000000 10455130160 10793086976 1514061280 15.599 100 88 174 1 1551434784 9385968 27987536
20:01:49 22110 8192000000 10496081600 10841550848 1549639680 15.907 100 81 162 0 1583938256 9795392 24503184
20:02:21 9340 8192000000 10509418768 10860191744 1573822912 16.115 100 82 164 1 1609486352 9845408 25818032
20:02:38 12111 8192000000 10538782976 10891411456 1592616368 16.276 100 71 141 1 1624077248 10052800 21408080
20:02:59 23101 8192000000 10565438848 10927222784 1621539424 16.523 100 69 138 2 1653279520 10975360 20764736
20:03:29 11146 8192000000 10584821312 10948775936 1647752960 16.745 100 78 155 3 1681446064 10861760 22831344
20:03:49 7037 8192000000 10597729136 10964201472 1659744048 16.847 100 78 157 2 1694020336 11836096 22440192
20:04:08 5375 8192000000 10609317648 10976858112 1676417952 16.987 100 76 152 2 1711246992 12456992 22372048
20:04:25 7514 8192000000 10629305328 11001860096 1694375984 17.138 100 77 154 0 1729294128 12444832 22473312
20:04:41 8616 8192000000 10644533472 11024048128 1715186608 17.312 100 67 134 1 1745292096 11476416 18629072
20:04:58 6302 8192000000 10663315904 11038572544 1725739856 17.400 100 81 162 2 1761418320 11933712 23744752
20:05:14 8854 8192000000 10673174144 11046981632 1734408272 17.472 100 69 137 6 1766417744 12849744 19159728
20:05:31 4761 8192000000 10682369392 11060580352 1746638592 17.574 100 78 155 2 1782268016 13665360 21964064
20:05:42 5439 8192000000 10703847216 11081043968 1760895840 17.692 100 79 158 0 1796279232 13346080 22037312
20:05:55 5132 8192000000 10714896544 11093962752 1775188096 17.810 100 75 146 1 1807914144 12933552 19792496
20:06:08 4269 8192000000 10725103952 11101626368 1783317152 17.877 100 86 173 1 1820685984 13312576 24056256
20:06:20 11944 8192000000 10730867968 11111260160 1791763936 17.946 100 77 153 4 1826299344 13496208 21039200
20:06:40 3263 8192000000 10744521264 11124355072 1803300000 18.041 100 83 166 3 1839712032 13398192 23013840
20:06:50 4144 8192000000 10749987856 11130613760 1810795040 18.102 100 87 173 1 1848297008 13468784 24033184
20:07:01 3632 8192000000 10760902256 11145437184 1821328944 18.189 100 85 171 0 1859744688 13448688 24967056
20:07:11 2363 8192000000 10767400496 11154132992 1825999088 18.227 100 91 182 0 1866775840 14977488 25799264
20:07:20 2217 8192000000 10778304032 11160489984 1831870880 18.275 100 95 190 1 1874225936 15806432 26548624
20:07:29 3230 8192000000 10780372432 11162431488 1837370112 18.319 100 90 180 3 1878440208 15249952 25820144
20:07:39 2627 8192000000 10772279072 11162324992 1837819920 18.323 100 86 172 1 1876445456 13452896 25172640
20:07:48 1974 8192000000 10785473456 11173392384 1844094320 18.374 100 90 180 1 1883275520 13445600 25735600
20:07:56 1972 8192000000 10784603968 11176120320 1847884240 18.405 100 87 172 1 1886051456 13910448 24256768
20:08:05 3424 8192000000 10793626704 11178602496 1852023136 18.439 100 92 184 1 1892780784 14558624 26199024
20:08:15 1749 8192000000 10803368064 11187113984 1855159216 18.464 100 94 189 1 1894762640 13172848 26430576
20:08:23 1949 8192000000 10800436000 11186659328 1856874192 18.478 100 91 182 1 1896457040 13751312 25831536
20:08:32 2279 8192000000 10806401184 11190599680 1862386336 18.523 100 94 188 1 1902943072 13543184 27013552
20:08:41 1924 8192000000 10809671280 11194511360 1865406432 18.547 100 91 182 2 1904190736 13512496 25271808
20:08:49 2684 8192000000 10811637808 11197341696 1866802160 18.558 100 94 190 3 1904808048 11483568 26522320
20:08:59 45793 8192000000 10793297504 11196411904 1865335104 18.547 100 73 145 3 1897320144 12541776 19443264
20:09:51 1406 8192000000 10814621696 11206279168 1870502976 18.588 100 84 166 2 1906929088 11670272 24755840
20:09:58 3002 8192000000 10792069376 11204157440 1865155488 18.545 100 54 108 1 1892283696 12225616 14902592
20:10:09 4054 8192000000 10781860224 11198717952 1865977968 18.552 100 41 82 1 1886761488 9237360 11546160
20:10:20 5179 8192000000 10787366496 11195240448 1865153824 18.545 100 44 88 1 1886353984 8578992 12621168
20:10:32 5865 8192000000 10785730416 11202461696 1866021904 18.552 100 42 85 1 1884857264 7097312 11738048
20:10:46 3282 8192000000 10804706032 11209400320 1871093904 18.593 100 57 115 0 1896108704 8193776 16821024
20:10:56 4216 8192000000 10801482000 11212537856 1874360608 18.620 100 53 107 4 1899429456 10377680 14691168
20:11:06 6513 8192000000 10782029984 11210833920 1874219440 18.618 100 32 64 1 1891319536 8014480 9085616
20:11:22 3225 8192000000 10791990560 11210080256 1875446336 18.628 100 40 80 0 1894358592 7838144 11074112
20:11:31 6658 8192000000 10790913808 11213684736 1874840688 18.623 100 37 73 0 1893338896 8366464 10131744
20:11:49 3264 8192000000 10783742272 11207532544 1876276176 18.635 100 27 54 0 1890362992 6215808 7871008
20:11:58 8011 8192000000 10794298992 11218087936 1879916800 18.664 100 32 64 1 1895917808 7025456 8975552
20:12:12 9779 8192000000 10788669168 11216072704 1883316960 18.692 100 35 72 2 1905556528 9727264 12512304
20:12:28 8078 8192000000 10812135536 11222913024 1894332848 18.781 100 44 91 0 1913230144 5473504 13423792
20:12:42 59065 8192000000 10847615232 11243397120 1896244064 18.796 100 67 138 1 1922730720 6335200 20151456
20:13:48 4836 8192000000 10795524224 11233140736 1890356752 18.749 100 33 66 2 1907695776 8328144 9010880
20:13:59 7752 8192000000 10797201904 11230896128 1889637840 18.743 100 23 46 2 1902661760 6201872 6822048
20:14:14 8410 8192000000 10799052848 11234390016 1890756624 18.752 100 21 42 3 1903256160 6468000 6031536
20:14:29 6353 8192000000 10828750608 11247570944 1897366384 18.805 100 36 73 3 1913466752 6018864 10081504
20:14:46 5602 8192000000 10822518112 11251015680 1902124496 18.843 100 31 62 1 1917261536 6334144 8802896
20:14:58 9784 8192000000 10823001632 11250249728 1902126704 18.843 100 24 49 4 1914540912 5460080 6954128
20:15:16 10532 8192000000 10810075536 11250855936 1904626368 18.863 100 23 46 1 1917087360 6263488 6197504
20:15:32 11749 8192000000 10821251904 11252203520 1907022528 18.883 100 21 42 0 1919669360 6946768 5700064
20:15:51 7416 8192000000 10821103488 11253440512 1894182768 18.779 99 29 59 2 1908746016 5846592 8716656
20:16:07 6857 8192000000 10829766864 11259826176 1912393408 18.926 100 27 54 4 1926207792 5651760 8162624
20:16:22 12951 8192000000 10814843744 11252551680 1908014272 18.891 100 14 28 2 1917027664 5212592 3800800
20:16:43 52589 8192000000 10849748528 11264471040 1916289024 18.957 100 53 106 1 1937063824 5068992 15705808
20:17:42 9960 8192000000 10817650960 11257061376 1910564016 18.911 100 14 28 1 1920522240 6161040 3797184
20:18:03 6657 8192000000 10783428192 11209555968 1819140688 18.171 96 30 58 1 1833505424 6170288 8194448
20:18:16 7286 8192000000 10766707488 11193556992 1837502528 18.320 98 33 66 2 1853752816 6979296 9270992
20:18:32 5805 8192000000 10774109376 11196772352 1805426176 18.058 96 35 70 4 1822334016 6259504 10648336
20:18:45 5226 8192000000 10777337024 11204583424 1839250368 18.335 98 25 50 0 1852104304 5995696 6858240
20:18:57 6656 8192000000 10761445104 11184173056 1818030320 18.162 98 27 51 2 1830500736 5340032 7130384
20:19:11 8136 8192000000 10711753840 11122208768 1765824640 17.733 96 23 45 2 1778520768 5693632 7002496
20:19:29 8690 8192000000 10746436096 11165777920 1793841008 17.963 97 15 30 1 1803262832 5015664 4406160
20:19:44 12277 8192000000 10732309024 11153854464 1758321168 17.670 96 20 40 1 1769688896 5322896 6044832
20:20:02 8349 8192000000 10731845776 11152363520 1798809264 18.004 99 22 44 1 1815616768 10670992 6136512
20:20:18 8825 8192000000 10718117712 11136610304 1772463344 17.787 97 19 38 0 1784552384 6219104 5869936
20:20:35 5926 8192000000 10716470384 11135438848 1766609616 17.739 97 22 44 2 1778791568 5577648 6604304
20:20:47 9542 8192000000 10726342432 11144826880 1776696752 17.822 98 19 38 1 1788138736 5547072 5894912
20:21:05 6995 8192000000 10695935216 11119431680 1754720688 17.641 97 11 22 1 1762922224 4719840 3481696
20:21:18 70377 8192000000 10676696320 11103473664 1694637456 17.140 94 36 70 0 1710210976 5277568 10295952
20:22:35 20060 8192000000 10726615968 11133968384 1724243696 17.388 95 24 48 0 1737641504 5491824 7905984
20:23:02 5357 8192000000 10732995200 11132026880 1771111344 17.776 98 30 60 2 1785133520 5505664 8516512
20:23:17 6162 8192000000 10701512048 11113033728 1786699456 17.905 100 35 70 1 1803199808 6228736 10271616
20:23:33 9729 8192000000 10717881904 11138723840 1802393312 18.034 100 28 54 2 1816690384 5992640 8304432
20:23:50 9970 8192000000 10736501216 11152674816 1802480928 18.034 99 25 50 2 1815091344 5720000 6890416
20:24:09 4987 8192000000 10735385584 11151732736 1813374800 18.124 100 36 72 1 1831362208 6325024 11662384
20:24:24 5600 8192000000 10731952704 11150897152 1804181248 18.048 99 26 52 1 1817631888 5690432 7760208
20:24:38 7782 8192000000 10742046160 11164590080 1816070352 18.146 99 32 64 2 1830559696 4977056 9512288
20:24:55 7754 8192000000 10764052720 11181105152 1840041424 18.341 100 32 62 2 1855341680 5944640 9355616
20:25:12 9534 8192000000 10758443680 11186061312 1846945072 18.397 100 11 22 1 1855508304 5430864 3132368
20:25:29 11029 8192000000 10766359568 11195469824 1853534960 18.451 100 22 44 1 1865650368 5561392 6554016
20:25:50 6027 8192000000 10776526368 11202551808 1858341824 18.490 100 24 48 0 1875209584 9912992 6954768
20:26:03 9803 8192000000 10761468112 11197403136 1856373424 18.474 100 14 28 2 1865818608 5180512 4264672
20:26:24 59715 8192000000 10807829520 11219431424 1872073600 18.601 100 48 97 0 1892198016 5236672 14887744
20:27:30 4694 8192000000 10803631744 11225923584 1880334208 18.668 100 29 58 1 1895244512 6924768 7985536
20:27:43 28778 8192000000 10819684976 11242389504 1894815744 18.785 100 42 83 2 1914773040 7994784 11962512
20:28:22 13754 8192000000 10830243024 11253600256 1907004880 18.883 100 39 72 3 1923544352 6089024 10450448
20:28:43 31388 8192000000 10844388704 11265888256 1914830944 18.945 100 48 96 1 1936404208 8020416 13552848
20:29:44 25561 8192000000 10850893632 11282292736 1927036688 19.043 100 41 80 1 1947988288 9534144 11417456
20:30:20 27616 8192000000 10863202208 11294371840 1932199424 19.084 100 41 82 2 1953706896 9588448 11919024
20:30:56 14494 8192000000 10867085776 11299926016 1939347360 19.142 100 49 98 5 1964231776 10118976 14765440
20:31:31 11652 8192000000 10879236288 11308740608 1947529232 19.207 100 44 88 3 1970118976 9038528 13551216
20:31:53 25194 8192000000 10884086128 11314520064 1937690848 19.128 99 45 90 1 1961658544 11631968 12335728
20:32:28 15348 8192000000 10883718032 11319365632 1956037904 19.275 100 46 91 1 1981715056 12673552 13003600
20:32:53 25650 8192000000 10897625888 11334803456 1963851296 19.337 100 50 100 0 1994179680 15354432 14973952
20:33:28 8079 8192000000 10900142624 11333652480 1968105616 19.370 100 44 88 1 1991582800 10937856 12539328
20:33:43 33823 8192000000 10900365152 11342376960 1974482816 19.421 100 48 95 1 2004849984 14729568 15637600
20:34:27 7254 8192000000 10913854576 11349352448 1978409616 19.452 100 45 90 1 2005475936 14023840 13042480
20:34:43 20179 8192000000 10924457072 11361619968 1982385696 19.484 100 49 98 2 2017374688 20719376 14269616
20:35:14 5092 8192000000 10926216784 11359092736 1988483296 19.532 100 53 106 1 2019826176 16290592 15052288
20:35:31 12577 8192000000 10942669136 11370242048 1991732320 19.557 100 56 111 0 2024298848 16650352 15916176
20:35:52 12851 8192000000 10949925248 11377852416 1998120064 19.608 100 59 117 0 2033651936 19020896 16510976
20:36:16 7270 8192000000 10950112544 11384684544 2008552640 19.690 100 77 152 1 2052174032 20649088 22972304
20:36:35 19140 8192000000 10965344608 11396685824 2008426320 19.689 100 57 113 4 2044681872 19184176 17071376
20:37:01 4864 8192000000 10933421968 11374456832 1988131520 19.529 99 48 96 0 2024014864 20570592 15312752
20:37:15 10078 8192000000 10946880576 11375382528 1985722976 19.510 99 65 130 1 2027177152 20846544 20607632
20:37:38 5145 8192000000 10957695248 11386597376 2001841312 19.637 100 62 124 1 2042977232 21547712 19588208
20:37:53 9415 8192000000 10952940512 11389726720 2004031968 19.655 100 45 90 1 2037641168 19468608 14140592
20:38:15 8297 8192000000 10959688080 11400044544 2013707840 19.731 100 54 108 2 2053851616 23453552 16690224
20:38:36 4720 8192000000 10967392608 11404263424 2015960224 19.748 100 61 122 0 2057756032 23124688 18671120
20:38:48 5720 8192000000 10949612352 11383930880 1996753760 19.597 99 52 102 1 2036468864 23320848 16394256
20:39:01 11588 8192000000 10971560608 11404685312 2018509296 19.768 100 68 135 0 2060599488 21030976 21059216
20:39:21 5811 8192000000 10967939200 11400040448 2016004944 19.749 100 63 126 2 2055386544 19962240 19419360
20:39:35 3455 8192000000 10974131616 11399004160 2017679984 19.762 100 77 155 0 2060949248 20407296 22861968
20:39:46 9103 8192000000 10979198384 11407314944 2022797776 19.802 100 75 150 0 2067333552 22162096 22373680
20:40:02 4219 8192000000 10983777952 11408093184 2021753408 19.794 100 76 152 1 2068385216 23850576 22781232
20:40:13 4663 8192000000 10986482496 11411337216 2023035456 19.804 100 77 152 1 2070481968 24712144 22734368
20:40:25 5339 8192000000 11002920032 11419787264 2030279952 19.861 100 87 174 0 2081962272 25804976 25877344
20:40:37 6372 8192000000 10980797744 11417968640 2026994992 19.835 100 62 124 0 2072088880 26203136 18890752
20:40:55 8451 8192000000 10978871968 11422003200 2027936240 19.842 100 48 96 1 2067529312 24770480 14822592
20:41:10 5934 8192000000 10974055376 11417362432 2025937232 19.827 100 59 118 1 2067981552 24094592 17949728
20:41:24 7261 8192000000 10979027280 11420692480 2011633968 19.714 99 58 116 3 2055008256 25190528 18183760
20:41:38 2372 8192000000 10997036976 11412615168 2023085344 19.804 100 86 168 0 2075673696 26749408 25838944
20:41:48 4178 8192000000 10964547616 11386142720 1999879696 19.622 100 75 150 0 2050136480 27901504 22355280
20:42:07 1604 8192000000 10981712608 11401158656 2004741088 19.660 100 85 170 0 2062195232 30796800 26657344
20:42:15 15395 8192000000 10957013088 11386298368 1993116672 19.568 100 66 132 2 2042183872 28989040 20078160
20:42:41 1543 8192000000 10981444768 11395035136 2003724256 19.652 100 87 169 0 2057906320 28782224 25399840
20:42:50 5181 8192000000 10972291040 11400806400 2009707040 19.699 100 67 133 1 2060297712 29528832 21061840
20:43:04 2568 8192000000 10985540448 11409510400 2015476752 19.745 100 77 154 2 2069199136 30861968 22860416
20:43:15 6141 8192000000 10974186464 11403218944 2007368512 19.681 100 73 146 0 2059902448 30698576 21835360
20:43:34 1754 8192000000 11000150560 11413876736 2020616400 19.785 100 85 170 1 2077383152 31963328 24803424
20:43:43 5396 8192000000 10971589040 11402702848 2004216064 19.656 100 64 128 1 2056894592 33083312 19595216
20:43:55 2568 8192000000 10986760816 11406299136 2010734144 19.707 100 82 165 2 2067533792 31814752 24984896
20:44:10 4126 8192000000 10995331184 11414044672 2016345552 19.751 100 75 147 1 2071040400 32884736 21810112
20:44:22 1188 8192000000 10977290768 11394641920 2001479440 19.634 100 78 156 2 2059041168 32973728 24588000
20:44:29 3942 8192000000 10969039840 11396743168 1999682400 19.620 100 85 169 0 2064478576 38471616 26324560
20:44:40 8323 8192000000 10966682208 11385856000 1988615904 19.533 100 84 166 0 2050908176 37010000 25282272
20:44:55 1286 8192000000 10977007760 11392978944 1992623616 19.565 100 85 168 3 2057350768 37909760 26817392
20:45:03 3786 8192000000 10968153664 11393904640 1992290112 19.562 100 74 147 1 2050738384 35987600 22460672
20:45:15 8169 8192000000 10954436080 11386093568 1973984256 19.417 99 59 119 1 2028676272 36329904 18362112
20:45:33 8739 8192000000 10928639120 11362238464 1944394960 19.182 98 52 104 0 1996670048 36012432 16262656
20:45:48 6781 8192000000 10915512768 11345276928 1927153328 19.044 98 48 96 2 1973434592 30987952 15293312
20:46:04 12606 8192000000 10897266992 11344449536 1937556864 19.127 99 34 68 2 1982042176 33139280 11346032
20:46:25 9110 8192000000 10893255584 11329048576 1892224448 18.764 97 40 80 1 1940191280 34766896 13199936
20:46:42 3743 8192000000 10871905776 11302440960 1905959584 18.874 99 49 98 1 1957712944 35158208 16595152
20:47:05 6164 8192000000 10888637056 11304247296 1885440224 18.709 98 74 146 1 1942923792 35539984 21943584
20:47:18 4476 8192000000 10903162992 11327348736 1933971696 19.099 100 72 141 2 1993818352 37361424 22485232
20:47:30 14492 8192000000 10888000512 11332669440 1928938736 19.058 100 30 58 3 1976363088 37868368 9555984
20:47:58 6824 8192000000 10883210128 11317542912 1889953232 18.745 98 42 82 3 1945055280 41008720 14093328
20:48:11 12300 8192000000 10888272240 11309772800 1886190800 18.715 98 61 122 3 1944357152 37719056 20447296
20:48:32 4050 8192000000 10906792016 11330928640 1909114192 18.900 99 66 132 1 1974904880 44036672 21754016
20:48:44 9193 8192000000 10855820976 11293761536 1881567968 18.678 99 49 96 1 1936058480 39322448 15168064
20:48:59 13553 8192000000 10853241136 11294081024 1876989776 18.641 99 29 57 1 1920542320 34537424 9015120
20:49:22 7802 8192000000 10868995008 11306860544 1897043552 18.803 99 34 68 1 1942001856 33922640 11035664
20:49:39 5617 8192000000 10880089392 11307122688 1901598656 18.839 99 51 100 1 1945667568 28452576 15616336
20:49:53 2365 8192000000 10904592816 11323965440 1920807232 18.993 99 78 155 2 1974341904 29859488 23675184
20:50:04 3217 8192000000 10912094800 11321647104 1931549200 19.079 100 70 138 1 1981512240 28921808 21041232
20:50:15 5045 8192000000 10914844176 11338518528 1944663376 19.184 100 60 120 0 1993624896 30151200 18810320
20:50:30 5464 8192000000 10913269056 11327299584 1926391136 19.038 99 60 118 2 1973420272 28967488 18061648
20:50:44 16483 8192000000 10889970384 11332198400 1921038832 18.995 99 27 54 1 1960372352 30370416 8963104
20:51:09 18184 8192000000 10895688192 11337953280 1904670672 18.864 98 32 63 0 1945262192 30094640 10496880
20:51:36 11418 8192000000 10901036448 11341389824 1925512800 19.031 99 33 65 0 1969190016 32513904 11163312
20:51:57 19761 8192000000 10898182000 11345424384 1941320400 19.157 100 28 56 1 1984906832 34438768 9147664
20:52:33 24888 8192000000 10881790400 11338436608 1917007520 18.963 99 24 48 0 1965475984 40031904 8436560
20:53:12 23909 8192000000 10885345264 11340468224 1936461248 19.119 100 23 46 3 1982848832 38220192 8167392
20:53:49 32261 8192000000 10862418240 11313463296 1902462768 18.846 99 15 30 0 1944792240 36689632 5639840
20:54:30 24777 8192000000 10879410224 11334914048 1924697936 19.024 100 25 50 0 1976150128 42563616 8888576
20:55:23 20025 8192000000 10894028000 11330191360 1921247952 18.997 99 50 95 5 1964497952 29448848 13801152
20:55:50 3913 8192000000 10897448544 11332251648 1920561152 18.991 99 59 119 1 1967334576 27954304 18819120
20:56:01 13821 8192000000 10865744928 11327737856 1892327168 18.765 98 32 64 2 1926268800 23498160 10443472
20:56:34 5912 8192000000 10864931360 11311857664 1913411536 18.934 99 39 76 3 1941687840 16929584 11346720
20:56:47 27425 8192000000 10840898016 11296337920 1883904736 18.697 98 12 24 1 1903146144 15847136 3394272
20:57:21 31718 8192000000 10880956176 11315982336 1930403696 19.070 100 38 77 2 1958046624 17320864 10322064
20:57:59 47998 8192000000 10863151968 11318169600 1911127680 18.916 99 16 30 1 1939390496 23529984 4732832
20:58:54 90026 8192000000 10878039648 11337486336 1930678096 19.072 100 17 34 0 1957485936 22112912 4694928
21:02:20 55298 8192000000 10887060960 11329601536 1935210032 19.109 99 26 50 2 1954480064 12898496 6371536
21:03:33 129180 8192000000 10870316992 11352780800 1901879392 18.841 97 17 34 0 1930381568 23500960 5001216
21:06:29 79804 8192000000 10889287024 11354865664 1940282768 19.149 99 17 36 1 1957627936 12913616 4431552
21:08:00 40148 8192000000 10886398960 11327918080 1947867360 19.209 99 28 56 0 1968683296 12634784 8181152
21:10:32 80207 8192000000 10907378640 11362410496 1970046480 19.386 100 20 40 1 1989023680 13071744 5905456
21:12:08 51410 8192000000 10916163184 11365019648 1976726992 19.439 100 32 64 0 1994239520 8302304 9210224
21:13:23 79494 8192000000 10903329744 11360907264 1964433248 19.341 99 24 49 3 1983236912 11903104 6900560
21:14:49 30798 8192000000 10926894368 11369566208 1987471072 19.524 100 57 116 0 2015046832 10963984 16611776
21:15:29 10843 8192000000 10929763152 11379175424 1995541968 19.588 100 57 114 1 2027700528 16096784 16061776
21:15:48 38979 8192000000 10923840960 11375579136 1971635600 19.398 99 31 58 2 1995052768 15173680 8243488
21:16:34 35567 8192000000 10928888608 11386986496 1987861520 19.527 100 33 65 0 2011514720 14303168 9350032
21:17:19 37392 8192000000 10911797488 11385511936 1994460880 19.579 100 41 80 1 2019963264 13567824 11934560
21:18:10 69074 8192000000 10897317856 11374149632 1962142192 19.323 99 14 28 0 1981285792 15262608 3880992
21:19:33 64713 8192000000 10886383136 11363090432 1926300704 19.037 97 9 18 1 1940469040 11813008 2355328
21:20:44 76300 8192000000 10892119360 11366559744 1974549184 19.422 100 15 30 1 1988488192 8479584 5459424
21:22:18 96560 8192000000 10887551648 11368402944 1960679168 19.311 99 17 34 1 1972651008 7418672 4553168
21:24:06 50379 8192000000 10900236112 11385389056 1985628672 19.509 100 8 15 1 2000477152 12689792 2158688
21:25:08 13874 8192000000 10903941504 11384369152 1985367392 19.507 100 4 8 0 2000276816 13842144 1067280
21:25:30 56885 8192000000 10906839696 11386691584 1986018624 19.512 100 9 18 1 1997424096 9305152 2100320
21:26:38 80939 8192000000 10925459456 11396026368 1971108944 19.394 99 9 18 0 1982873312 9182400 2581968
21:28:05 28745 8192000000 10917204768 11381489664 1981400496 19.476 99 35 70 2 1997495744 6680448 9414800
21:28:42 71912 8192000000 10888223024 11350884352 1930600320 19.072 97 18 36 1 1942529872 7113584 4815968
21:30:04 55110 8192000000 10889694992 11362795520 1928571776 19.055 97 16 32 0 1943444672 10891472 3981424
21:31:06 29933 8192000000 10897303664 11364532224 1921742080 19.001 97 19 38 0 1938962736 11817936 5402720
21:31:45 83563 8192000000 10912760992 11365756928 1919707568 18.984 97 25 50 2 1941779248 15052080 7019600
21:33:15 79443 8192000000 10889948112 11352436736 1874511360 18.621 95 21 42 1 1894975984 14614768 5849856
21:34:52 87961 8192000000 10859048256 11337203712 1831550624 18.272 94 10 20 0 1852655248 18160800 2943824
21:37:04 62783 8192000000 10842885872 11292790784 1797842480 17.996 92 37 71 0 1818466000 10938544 9684976
21:38:16 48084 8192000000 10843889984 11317952512 1888024784 18.730 98 40 80 1 1913379824 14111536 11243504
21:39:12 69547 8192000000 10870980976 11302506496 1775048176 17.809 92 29 58 0 1791371392 8691552 7631664
21:40:32 25402 8192000000 10863582832 11313483776 1903807936 18.857 99 43 86 0 1929852816 13954400 12090480
21:41:13 54737 8192000000 10829244464 11291664384 1862384928 18.523 97 16 32 1 1877384672 10595088 4404656
21:43:15 66704 8192000000 10836872400 11308888064 1846804896 18.396 96 11 22 1 1862956432 12991840 3159696
21:44:28 69722 8192000000 10865194640 11322195968 1913097280 18.932 99 20 40 0 1926619472 8014480 5507712
21:45:57 51410 8192000000 10863433760 11326607360 1918216912 18.973 98 24 48 0 1933715120 8333936 7164272
21:48:11 48733 8192000000 10856568976 11307282432 1874967728 18.624 97 15 30 1 1887931024 8517376 4445920
21:49:08 61422 8192000000 10836509904 11304460288 1871036880 18.593 97 19 39 1 1887398272 11155824 5205568
21:50:25 32525 8192000000 10817594848 11295944704 1887242848 18.724 99 7 14 0 1900877824 11659536 1975440
21:51:17 84388 8192000000 10818240368 11286507520 1862109760 18.520 98 16 32 0 1883119088 16589968 4419360
21:52:49 75298 8192000000 10860034704 11332575232 1922884768 19.010 100 16 32 0 1945694496 18516928 4292800
21:54:13 61048 8192000000 10873101376 11339763712 1902252384 18.844 98 32 64 0 1926085872 14498976 9334512
21:55:20 42137 8192000000 10865974624 11335712768 1917979152 18.971 99 13 26 0 1939867104 18283152 3604800
21:56:13 75565 8192000000 10850402544 11316453376 1885777360 18.712 97 19 38 2 1905766720 14147680 5841680
21:57:38 20443 8192000000 10887512128 11323863040 1909220640 18.900 98 40 80 1 1927046928 5578576 12247712
21:58:06 59126 8192000000 10874760784 11339128832 1927427520 19.046 99 34 67 0 1945430992 9223152 8780320
21:59:13 57595 8192000000 10875618624 11344945152 1934004080 19.099 99 10 20 0 1947137776 10524016 2609680
22:00:17 94795 8192000000 10879690032 11345379328 1918693584 18.976 98 8 16 0 1935202592 14415232 2093776
22:01:59 41448 8192000000 10888300512 11359772672 1937712128 19.128 99 17 34 2 1954846288 12291632 4842528
22:02:49 69032 8192000000 10890420416 11361013760 1944075360 19.179 99 8 16 0 1955558640 9148528 2334752
22:04:04 26884 8192000000 10900547136 11351064576 1948313024 19.213 99 57 113 0 1973695456 9776768 15605664
22:04:43 54702 8192000000 10893945312 11360813056 1949597216 19.223 99 30 60 3 1970952624 12866256 8489152
22:05:48 101668 8192000000 10895408912 11378016256 1945018096 19.187 99 18 36 1 1965685104 15672144 4994864
22:07:36 100999 8192000000 10912306352 11378782208 1958938752 19.298 99 14 29 1 1975536080 12974080 3623248
22:09:29 70636 8192000000 10904456480 11368763392 1962606304 19.327 99 25 49 0 1978980224 9774016 6599904
22:10:50 79594 8192000000 10918964240 11396415488 1986371600 19.515 100 24 48 2 2012504496 18691824 7441072
22:12:16 59548 8192000000 10911842432 11385413632 1971339200 19.396 99 15 31 0 1988721344 13300016 4082128
22:13:25 83099 8192000000 10890511392 11377549312 1964048368 19.338 99 8 14 0 1975338144 9251648 2038128
22:15:02 60703 8192000000 10914098592 11387895808 1962660880 19.327 99 8 16 0 1979940544 15028544 2251120
22:16:17 62204 8192000000 10915718128 11389370368 1985758080 19.510 100 10 20 1 2003551872 14715344 3078448
22:17:56 65923 8192000000 10907218144 11381821440 1946349840 19.197 98 10 20 0 1966636672 17091072 3195760
22:19:31 73708 8192000000 10903851600 11385532416 1939352864 19.142 98 12 24 1 1957507568 14579808 3574896
22:20:52 79843 8192000000 10888120352 11359690752 1891183408 18.755 96 26 52 2 1910340816 10766240 8391168
22:22:19 36367 8192000000 10869832976 11339673600 1905153280 18.868 97 22 44 0 1919029376 8257440 5618656
22:23:02 38671 8192000000 10865190464 11337080832 1897027808 18.802 97 21 43 0 1910562096 7791792 5742496
22:23:50 61075 8192000000 10871249760 11347210240 1916283040 18.957 98 17 34 0 1930222416 9312992 4626384
22:25:01 50956 8192000000 10830831728 11292975104 1840666336 18.346 96 25 50 1 1856983376 9484528 6832512
22:25:58 72659 8192000000 10838589088 11286056960 1779692656 17.847 93 25 50 1 1795922848 9394640 6835552
22:27:17 14007 8192000000 9596869840 9918521344 719083744 8.069 38 35 62 5 734710832 6373472 9253616

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 31-03-2021 22:28:26 to 31-03-2021 22:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 131 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 31-03-2021 22:28:58 to 31-03-2021 22:28:59.

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          236825
MON$OLDEST_ACTIVE               236826
MON$OLDEST_SNAPSHOT             236826
MON$NEXT_TRANSACTION            236826
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                       2008960
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
:244: 
:245: mscs-test-161.budzdorov.ru    Wed Mar 31 22:27:35 2021
:246:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:247: 
--- end of diff output ---

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

31.03.21 22:29:00. 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-31 22:29:03 No severe PSQL-related problems occured
31.03.21 22:29:04. End of report.