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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17533080 kB
MemAvailable 31548240 kB
Buffers 0 kB
Cached 14144104 kB
SwapCached 3704 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-09 22:27:06
DTS_END                         2020-12-09 22:27:06.4400
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57520
TRN_ID                          251435
ATT_ID                          687
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: 9558.27 20701 1146992
customer order: creation 179.28 293 21514
customer order: refuse 14.91 276 1789
order to supplier: creation 46.03 1142 5524
order to supplier: removal 3.52 76123 422
invoice (draft): creation 47.68 3014 5722
invoice (draft): removal 53.87 600 6464
invoice accept: apply 43.98 16632 5277
invoice accept: cancel 48.85 683 5862
customer reserve: creation 4046.73 167 485607
customer reserve: removal 4769.65 44 572358
realization accept: apply 87.74 171 10529
realization accept: cancel 82.28 94 9873
payment from customer: creation 61.73 114 7407
payment from customer: removal 5.62 112 674
payment to supplier: creation 50.42 113 6050
payment to supplier: removal 3.37 53 404
service: total inventory turnovers 4.71 1076 565
service: total monetary turnovers 6.98 27 838
service: aggregate perf. data 0.91 19511 109
service: refresh index statistics 0.03 293769 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6327
TEST_TIME 2 6700
TEST_TIME 3 6714
TEST_TIME 4 6269
TEST_TIME 5 6207
TEST_TIME 6 5935
TEST_TIME 7 6232
TEST_TIME 8 6152
TEST_TIME 9 6375
TEST_TIME 10 7577
TEST_TIME 11 7837
TEST_TIME 12 8188
TEST_TIME 13 8768
TEST_TIME 14 9678
TEST_TIME 15 9760
TEST_TIME 16 10155
TEST_TIME 17 9701
TEST_TIME 18 9993
TEST_TIME 19 10146
TEST_TIME 20 10175
TEST_TIME 21 10570
TEST_TIME 22 11317
TEST_TIME 23 11294
TEST_TIME 24 11461
TEST_TIME 25 11622
TEST_TIME 26 11371
TEST_TIME 27 11291
TEST_TIME 28 11099
TEST_TIME 29 10944
TEST_TIME 30 11166
TEST_TIME 31 11104
TEST_TIME 32 10932
TEST_TIME 33 10942
TEST_TIME 34 10899
TEST_TIME 35 10693
TEST_TIME 36 10565
TEST_TIME 37 10421
TEST_TIME 38 10477
TEST_TIME 39 10480
TEST_TIME 40 10698
TEST_TIME 41 10608
TEST_TIME 42 10523
TEST_TIME 43 10637
TEST_TIME 44 10636
TEST_TIME 45 10536
TEST_TIME 46 10556
TEST_TIME 47 10505
TEST_TIME 48 10506
TEST_TIME 49 10557
TEST_TIME 50 10641
TEST_TIME 51 10677
TEST_TIME 52 10647
TEST_TIME 53 10550
TEST_TIME 54 10419
TEST_TIME 55 10313
TEST_TIME 56 10256
TEST_TIME 57 10191
TEST_TIME 58 10133
TEST_TIME 59 10107
TEST_TIME 60 10025
TEST_TIME 61 10003
TEST_TIME 62 10035
TEST_TIME 63 9950
TEST_TIME 64 10030
TEST_TIME 65 10061
TEST_TIME 66 10063
TEST_TIME 67 10040
TEST_TIME 68 10035
TEST_TIME 69 10057
TEST_TIME 70 10062
TEST_TIME 71 10034
TEST_TIME 72 10028
TEST_TIME 73 10109
TEST_TIME 74 10134
TEST_TIME 75 10114
TEST_TIME 76 10182
TEST_TIME 77 10124
TEST_TIME 78 10288
TEST_TIME 79 10162
TEST_TIME 80 10130
TEST_TIME 81 10054
TEST_TIME 82 10053
TEST_TIME 83 10076
TEST_TIME 84 10022
TEST_TIME 85 9980
TEST_TIME 86 9927
TEST_TIME 87 9885
TEST_TIME 88 9856
TEST_TIME 89 9803
TEST_TIME 90 9766
TEST_TIME 91 9745
TEST_TIME 92 9758
TEST_TIME 93 9754
TEST_TIME 94 9736
TEST_TIME 95 9750
TEST_TIME 96 9780
TEST_TIME 97 9770
TEST_TIME 98 9722
TEST_TIME 99 9867
TEST_TIME 100 9856
TEST_TIME 101 9854
TEST_TIME 102 9856
TEST_TIME 103 9846
TEST_TIME 104 9876
TEST_TIME 105 9847
TEST_TIME 106 9770
TEST_TIME 107 9716
TEST_TIME 108 9743
TEST_TIME 109 9710
TEST_TIME 110 9686
TEST_TIME 111 9642
TEST_TIME 112 9593
TEST_TIME 113 9618
TEST_TIME 114 9641
TEST_TIME 115 9629
TEST_TIME 116 9638
TEST_TIME 117 9620
TEST_TIME 118 9627
TEST_TIME 119 9629
TEST_TIME 120 9561

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-12-2020 22:28:06 to 09-12-2020 22:28:09.

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 1597947 1597947 0 0.00 0 18698 6 0 0
doc_list_biud 1597947 1597947 0 0.00 0 35426 20 0 0
sp_add_invoice_to_stock 5401 5277 124 2.29 41 177114 16632 0 124
sp_cancel_adding_invoice 5862 5862 0 0.00 4 73820 684 0 0
sp_cancel_client_order 1789 1789 0 0.00 4 32148 277 0 0
sp_cancel_customer_reserve 572358 572358 0 0.00 1 35039 44 0 0
sp_cancel_pay_from_customer 674 674 0 0.00 3 16468 112 0 0
sp_cancel_pay_to_supplier 404 404 0 0.00 3 1193 54 0 0
sp_cancel_supplier_invoice 6479 6464 15 0.23 1 15642 601 0 15
sp_cancel_supplier_order 422 422 0 0.00 6 648740 76123 0 0
sp_cancel_write_off 9873 9873 0 0.00 1 20282 94 0 0
sp_client_order 21514 21514 0 0.00 3 26475 294 0 0
sp_customer_reserve 485607 485607 0 0.00 0 102679 168 0 0
sp_fill_shopping_cart 32760 32760 0 0.00 1 10479 32 0 0
sp_fill_shopping_cart_clo_res 485603 485603 0 0.00 0 14087 12 0 0
sp_get_clo_for_invoice 5273 5273 0 0.00 0 15658 261 0 0
sp_kill_cost_storno 16813 16813 0 0.00 0 18443 45 0 0
sp_kill_qstorno_ret_qs2qd 1161475 1161475 0 0.00 0 35035 24 0 0
sp_kill_qty_storno 612570 612570 0 0.00 0 35425 52 0 0
sp_lock_selected_doc 21683 21683 0 0.00 0 8224 4 0 0
sp_make_cost_storno 29259 29259 0 0.00 0 18651 48 0 0
sp_multiply_rows_for_pdistr 29259 29259 0 0.00 0 18325 27 0 0
sp_multiply_rows_for_qdistr 21514 21514 0 0.00 0 10383 136 0 0
sp_pay_from_customer 7407 7407 0 0.00 4 19224 114 0 0
sp_pay_to_supplier 6050 6050 0 0.00 4 18365 114 0 0
sp_payment_common 13457 13457 0 0.00 1 18338 42 0 0
sp_qd_handle_on_cancel_clo 1789 1789 0 0.00 0 32142 253 0 0
sp_qd_handle_on_invoice_upd_sts 11135 11135 0 0.00 0 35423 262 0 0
sp_qd_handle_on_reserve_upd_sts 10529 10529 0 0.00 0 21470 62 0 0
sp_reserve_write_off 10529 10529 0 0.00 6 21496 172 0 0
sp_supplier_invoice 5722 5722 0 0.00 6 86238 3014 0 0
sp_supplier_order 5524 5524 0 0.00 5 38129 1143 0 0
srv_aggregate_perf_data 110 109 1 0.90 2947 343093 19511 0 1
srv_fill_mon_cache_memory 137 137 0 0.00 984 230879 39217 0 0
srv_find_qd_qs_mism 1097992 1097992 0 0.00 0 11170 5 0 0
srv_make_invnt_saldo 565 565 0 0.00 19 46076 1076 0 0
srv_make_money_saldo 838 838 0 0.00 1 5510 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 234554 351092 293769 0 0
t$perf-abend:sp_add_invoice_to_stock 124 124 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 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 5277 5277 0 0.00 0 14631 128 0 0
t$perf-norm:sp_cancel_adding_invoice 451 451 0 0.00 0 3474 85 0 0
t$perf-norm:sp_cancel_client_order 1789 1789 0 0.00 0 2803 12 0 0
t$perf-norm:sp_cancel_customer_reserve 727 727 0 0.00 0 4171 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 674 674 0 0.00 0 6158 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 404 404 0 0.00 0 4600 28 0 0
t$perf-norm:sp_cancel_supplier_invoice 393 393 0 0.00 0 5110 26 0 0
t$perf-norm:sp_cancel_supplier_order 422 422 0 0.00 0 19576 1435 0 0
t$perf-norm:sp_cancel_write_off 1021 1021 0 0.00 0 2150 10 0 0
t$perf-norm:sp_client_order 21514 21514 0 0.00 0 7693 12 0 0
t$perf-norm:sp_customer_reserve 1098 1098 0 0.00 0 1202 6 0 0
t$perf-norm:sp_pay_from_customer 7407 7407 0 0.00 0 4023 9 0 0
t$perf-norm:sp_pay_to_supplier 6050 6050 0 0.00 0 5418 11 0 0
t$perf-norm:sp_reserve_write_off 10529 10529 0 0.00 0 8444 12 0 0
t$perf-norm:sp_supplier_invoice 5722 5722 0 0.00 0 2000 10 0 0
t$perf-norm:sp_supplier_order 5524 5524 0 0.00 0 3331 11 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 111 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 137 137 0 0.00 0 94 2 0 0
t$perf-norm:srv_make_invnt_saldo 565 565 0 0.00 0 6936 26 0 0
t$perf-norm:srv_make_money_saldo 838 838 0 0.00 0 1485 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 13 5 0 0
v_add_invoice_to_stock 10794 10546 248 2.29 0 6492 17 0 248
v_all_customers 39144 39144 0 0.00 0 198 0 0 0
v_all_suppliers 31108 31108 0 0.00 0 81 1 0 0
v_all_wares 43028 43028 0 0.00 0 183 1 0 0
v_cancel_adding_invoice 902 902 0 0.00 0 2208 9 0 0
v_cancel_client_order 3578 3578 0 0.00 0 2058 3 0 0
v_cancel_customer_prepayment 1348 1348 0 0.00 0 1123 4 0 0
v_cancel_customer_reserve 1454 1454 0 0.00 0 1074 3 0 0
v_cancel_payment_to_supplier 808 808 0 0.00 0 939 5 0 0
v_cancel_supplier_invoice 816 786 30 3.67 0 1245 17 0 30
v_cancel_supplier_order 844 844 0 0.00 0 285 3 0 0
v_cancel_write_off 2042 2042 0 0.00 0 7806 16 0 0
v_max_id_clo_ord 5524 5524 0 0.00 0 3496 2 0 0
v_max_id_clo_res 1098 1098 0 0.00 0 1698 15 0 0
v_max_id_ord_sup 5722 5722 0 0.00 0 5076 6 0 0
v_max_non_paid_invoice 1742 1742 0 0.00 0 2998 5 0 0
v_max_non_paid_realizn 4020 4020 0 0.00 0 4873 5 0 0
v_min_id_clo_ord 5524 5524 0 0.00 0 2767 9 0 0
v_min_id_clo_res 1098 1098 0 0.00 0 4068 12 0 0
v_min_id_ord_sup 5722 5722 0 0.00 0 3958 7 0 0
v_min_non_paid_invoice 6050 6050 0 0.00 0 17711 34 0 0
v_min_non_paid_realizn 7407 7407 0 0.00 0 17728 31 0 0
v_our_firm 10658 10658 0 0.00 0 18 1 0 0
v_reserve_write_off 21058 21058 0 0.00 0 3963 5 0 0
x_lock_depdocs_on_canc_invoice 11933 11933 0 0.00 0 15674 108 0 0
x_lock_depdocs_on_canc_sup_ord 422 422 0 0.00 0 6286 282 0 0
x_make_qstorno_1000_1200 5524 5524 0 0.00 2 38121 1075 0 0
x_make_qstorno_1200_2000 5722 5722 0 0.00 3 86227 2904 0 0
x_make_qstorno_2100_3300 485607 485607 0 0.00 0 102678 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-12-2020 22:28:10 to 09-12-2020 22:28:14.

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:10 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:16 12994 8192000000 10184106032 10490011648 839817264 9.298 67 57 115 1 861641056 2445568 19378224
19:57:42 27825 8192000000 10314489600 10624647168 1358649248 14.225 100 81 162 1 1390980960 4701504 27630208
19:58:21 11853 8192000000 10340715952 10654191616 1399947872 14.595 100 91 182 0 1436023520 5612080 30463568
19:58:41 24238 8192000000 10370308320 10690490368 1420463600 14.777 100 85 171 1 1455329136 6264864 28600672
19:59:17 18519 8192000000 10390097184 10714505216 1446510352 15.007 100 93 186 0 1484184880 7312336 30362192
19:59:44 28821 8192000000 10416959824 10744434688 1468999792 15.205 100 90 180 0 1506060576 7829616 29231168
20:00:26 22252 8192000000 10442191616 10775252992 1493426144 15.419 100 88 176 0 1530259168 8458224 28374800
20:00:57 19110 8192000000 10464469616 10806382592 1520928128 15.658 100 84 167 0 1556518128 9178768 26411232
20:01:28 15009 8192000000 10503518864 10851262464 1559044192 15.988 100 80 160 0 1593402336 9646880 24711264
20:01:57 11304 8192000000 10527905344 10879324160 1587528672 16.233 100 84 167 2 1623752624 10460496 25763456
20:02:17 11301 8192000000 10546243168 10902986752 1608295008 16.410 100 78 156 0 1643013088 10779504 23938576
20:02:37 10255 8192000000 10569193376 10930704384 1632786432 16.619 100 70 140 0 1664023280 10833552 20403296
20:02:54 11258 8192000000 10590453872 10951417856 1652029568 16.782 100 81 159 1 1686237984 11240336 22968080
20:03:13 8111 8192000000 10623458576 10988240896 1678528848 17.005 100 76 152 0 1712553760 12000224 22024688
20:03:31 8410 8192000000 10631570176 11006152704 1695516064 17.148 100 73 146 3 1728956112 12315296 21124752
20:03:47 8295 8192000000 10673198240 11043373056 1728959120 17.427 100 86 172 1 1766465328 13297376 24208832
20:04:06 5122 8192000000 10685501296 11059748864 1744749088 17.558 100 88 176 0 1783415840 13859232 24807520
20:04:18 6010 8192000000 10697693040 11071139840 1757429040 17.663 100 90 180 4 1797532784 15289664 24814080
20:04:31 4924 8192000000 10704172240 11076960256 1756668544 17.657 100 84 168 2 1795111440 15046176 23396720
20:04:43 5590 8192000000 10703232912 11079786496 1764968368 17.725 100 87 174 0 1804872000 15867456 24036176
20:04:56 3301 8192000000 10718212160 11097133056 1772792928 17.790 100 84 168 2 1811419696 15246096 23380672
20:05:06 2957 8192000000 10730498176 11108999168 1787250704 17.909 100 78 155 1 1822480928 13311616 21918608
20:05:15 3608 8192000000 10730638672 11109101568 1792127040 17.949 100 76 152 1 1826594032 13002288 21464704
20:05:25 3198 8192000000 10744053040 11123150848 1800294096 18.016 100 78 157 1 1834844592 12293952 22256544
20:05:35 2321 8192000000 10734563872 11124211712 1803938928 18.046 100 76 152 1 1838327280 12569056 21819296
20:05:44 2279 8192000000 10757360688 11143835648 1820248768 18.180 100 78 156 0 1854929808 12931808 21749232
20:05:53 2989 8192000000 10767493472 11151962112 1827361648 18.238 100 87 172 2 1865310768 13113184 24835936
20:06:02 2234 8192000000 10776290752 11159326720 1834621856 18.297 100 88 174 1 1871396192 12005488 24768848
20:06:11 2445 8192000000 10778645296 11165708288 1838349552 18.327 100 88 174 1 1875420560 12500272 24570736
20:06:20 2265 8192000000 10779443408 11165782016 1842103104 18.358 100 85 168 3 1882490592 16858768 23528720
20:06:29 1368 8192000000 10796315792 11183124480 1852452880 18.442 100 92 179 1 1891113744 13705440 24955424
20:06:37 1597 8192000000 10802761536 11187847168 1855711152 18.468 100 91 181 0 1896380816 15189264 25480400
20:06:45 1376 8192000000 10806577056 11190845440 1860044640 18.504 100 90 180 0 1899003280 13803856 25154784
20:06:53 1710 8192000000 10798182016 11187265536 1855900640 18.470 100 83 164 2 1892465376 13259136 23305600
20:07:01 1688 8192000000 10809198160 11194998784 1862673328 18.525 100 94 188 2 1902578656 14594544 25310784
20:07:09 1569 8192000000 10815884352 11200176128 1865839872 18.551 100 97 194 1 1908550160 15158272 27552016
20:07:17 1133 8192000000 10816079584 11202478080 1870214336 18.586 100 92 187 1 1911510128 14827504 26468288
20:07:25 1372 8192000000 10823469248 11207778304 1873076048 18.609 100 95 192 0 1913700480 14135296 26489136
20:07:33 2091 8192000000 10791407504 11192020992 1869867280 18.583 100 73 144 1 1902821408 12088576 20865552
20:07:41 7671 8192000000 10785850992 11200647168 1869528272 18.580 100 47 94 2 1891435312 9002880 12904160
20:07:55 43193 8192000000 10808663136 11204898816 1870383792 18.587 100 57 111 5 1893163056 5585744 17193520
20:08:45 25665 8192000000 10785970464 11207270400 1869833456 18.583 100 40 80 1 1887715424 6379600 11502368
20:09:24 7277 8192000000 10788067744 11212951552 1870743216 18.590 100 25 50 0 1892037056 15178064 6115776
20:09:38 6674 8192000000 10791853888 11216392192 1876971200 18.641 100 35 70 1 1894126688 7673760 9481728
20:09:51 7176 8192000000 10796565744 11215503360 1875049792 18.625 100 28 55 2 1889741584 6956400 7735392
20:10:05 8012 8192000000 10782186592 11217432576 1883992464 18.697 100 26 53 1 1897973168 5952624 8028080
20:10:20 3028 8192000000 10799593264 11224313856 1889914352 18.745 100 32 64 0 1905626272 6018672 9693248
20:10:31 6450 8192000000 10795854208 11228344320 1889444352 18.741 100 27 54 0 1904235552 7308944 7482256
20:10:46 14409 8192000000 10809261552 11234369536 1889085584 18.738 100 19 37 1 1899625568 5493408 5046576
20:11:09 12166 8192000000 10801768576 11232219136 1891673424 18.759 100 16 32 2 1902177152 5325536 5178192
20:11:27 8017 8192000000 10806316496 11237789696 1895595584 18.791 100 24 48 1 1912745920 10422272 6728064
20:11:42 8910 8192000000 10810433824 11240742912 1896067568 18.795 100 19 38 0 1906739120 5976288 4695264
20:12:02 18272 8192000000 10807084448 11241529344 1897806752 18.809 100 13 26 0 1906633120 6025456 2800912
20:12:27 8635 8192000000 10807895824 11247644672 1902200592 18.844 100 14 28 0 1912368144 6581504 3586048
20:12:43 52327 8192000000 10825054192 11252535296 1907763824 18.889 100 31 62 0 1922913600 5995648 9154128
20:13:44 13524 8192000000 10851138144 11264548864 1920197264 18.988 100 73 146 1 1949232672 6796992 22238416
20:14:04 22185 8192000000 10818070976 11255169024 1912210064 18.924 100 24 48 2 1924836496 6007552 6618880
20:14:33 9963 8192000000 10823279440 11260940288 1914182528 18.940 100 18 36 0 1925931024 6367872 5380624
20:14:50 3575 8192000000 10824921360 11248734208 1902795168 18.849 99 45 91 2 1923550912 7451408 13304336
20:15:03 7206 8192000000 10822827280 11252486144 1892395072 18.765 99 23 46 2 1904929328 6140208 6394048
20:15:16 7730 8192000000 10827415680 11258253312 1910169680 18.908 100 26 49 1 1922225232 5473088 6582464
20:15:31 8444 8192000000 10809768784 11242758144 1886409408 18.717 99 16 32 1 1897216496 5207408 5599680
20:15:46 7456 8192000000 10808843120 11244122112 1865376176 18.547 98 18 36 0 1880025360 9966656 4682528
20:16:00 8596 8192000000 10776232864 11210006528 1827696608 18.241 97 17 32 5 1837928560 5728560 4503392
20:16:14 6763 8192000000 10767625712 11201851392 1836565840 18.313 98 23 46 2 1849890576 6592320 6732416
20:16:29 12880 8192000000 10778747008 11214548992 1861016464 18.512 99 23 45 2 1874228416 5972160 7239792
20:16:50 11703 8192000000 10762327072 11193143296 1786484672 17.903 95 18 36 2 1796706656 5433808 4788176
20:17:09 13655 8192000000 10728021072 11153477632 1713824288 17.301 92 14 27 0 1722351040 5131424 3395328
20:17:30 45113 8192000000 10719040320 11133272064 1698625504 17.174 92 21 42 1 1710034672 4778160 6631008
20:18:27 22274 8192000000 10698018384 11122139136 1705022336 17.227 93 29 58 0 1719638432 5828496 8787600
20:18:55 10340 8192000000 10701370720 11122827264 1759384560 17.679 97 19 38 1 1770278832 5518416 5375856
20:19:15 3145 8192000000 10718972384 11127418880 1752840672 17.625 97 30 58 1 1767334848 6250800 8243376
20:19:25 6533 8192000000 10712330944 11126972416 1748634560 17.590 97 29 60 1 1762769312 5947088 8187664
20:19:38 12797 8192000000 10685944800 11103899648 1713295408 17.296 95 19 37 2 1724194112 4998864 5899840
20:19:58 9584 8192000000 10687234592 11106152448 1731587008 17.449 97 19 38 2 1742623728 5610960 5425760
20:20:13 11278 8192000000 10697949104 11120406528 1744769536 17.558 97 25 50 4 1758902240 5892784 8239920
20:20:31 8986 8192000000 10708667280 11125313536 1751004384 17.610 97 21 42 2 1762418368 5165088 6248896
20:20:48 7846 8192000000 10711840080 11127914496 1762738912 17.707 98 20 40 0 1774135920 5939664 5457344
20:21:05 8414 8192000000 10728737360 11148767232 1798103408 17.998 99 19 38 1 1808702256 5049968 5548880
20:21:23 8589 8192000000 10743813424 11165962240 1825897344 18.226 100 20 40 1 1836893040 5273344 5722352
20:21:39 9023 8192000000 10751130880 11170508800 1816983600 18.153 99 25 51 1 1833780640 9416464 7380576
20:21:56 10579 8192000000 10743113280 11172032512 1836183056 18.310 100 16 31 1 1846421600 5318000 4920544
20:22:16 12647 8192000000 10749521280 11182915584 1841658864 18.354 100 13 24 1 1850312672 5378976 3274832
20:22:38 63897 8192000000 10774045152 11192745984 1849757008 18.420 100 35 69 3 1865018080 4974528 10286544
20:23:49 11481 8192000000 10758665984 11191599104 1851609744 18.435 100 30 60 1 1866875776 6926384 8339648
20:24:06 8482 8192000000 10764876144 11197464576 1856783408 18.477 100 15 30 0 1865881984 5345952 3752624
20:24:23 8156 8192000000 10771104080 11203584000 1865484560 18.548 100 30 60 3 1880948544 7117344 8346640
20:24:39 9647 8192000000 10770574800 11202117632 1862540880 18.524 100 21 42 5 1874913456 6380096 5992480
20:24:56 6110 8192000000 10784595248 11212587008 1863475328 18.531 100 27 51 2 1880439696 10316352 6648016
20:25:08 6573 8192000000 10767620272 11205025792 1863702160 18.533 100 18 36 0 1874804112 4959328 6142624
20:25:23 12877 8192000000 10782186944 11212300288 1868503712 18.572 100 11 22 0 1877814352 5248368 4062272
20:25:43 10284 8192000000 10784572880 11217514496 1873848624 18.615 100 34 68 1 1888949136 4927904 10172608
20:26:04 11070 8192000000 10779056320 11215294464 1872486288 18.604 100 26 52 1 1885621184 4952832 8182064
20:26:25 10322 8192000000 10790151920 11220684800 1874076864 18.617 100 26 51 3 1887366432 4978896 8310672
20:26:44 10116 8192000000 10789048528 11219775488 1876291984 18.635 100 23 45 1 1888649056 5577632 6779440
20:27:01 15322 8192000000 10809006320 11233828864 1885421632 18.709 100 25 47 5 1897038304 4706080 6910592
20:27:25 23274 8192000000 10836974496 11257720832 1908068192 18.891 100 38 76 1 1924507312 6463616 9975504
20:27:57 21234 8192000000 10865231920 11279609856 1926980048 19.043 100 61 121 1 1954598512 10916464 16702000
20:28:27 64066 8192000000 10838022144 11272769536 1908273376 18.893 99 44 88 0 1931968144 10759584 12935184
20:29:48 24773 8192000000 10850581488 11285594112 1927674032 19.048 100 34 67 2 1948812544 11450480 9688032
20:30:21 30968 8192000000 10859193440 11286507520 1899373152 18.821 98 42 84 1 1927679504 16415792 11890560
20:31:01 22520 8192000000 10854897104 11288182784 1915073952 18.947 99 37 74 1 1937389360 11673712 10641696
20:31:34 36868 8192000000 10877209968 11309428736 1925806544 19.033 99 44 88 1 1951586000 12966304 12813152
20:32:20 12379 8192000000 10891334576 11314987008 1948016208 19.211 100 42 83 1 1976626976 15772064 12838704
20:32:41 35700 8192000000 10885526848 11321720832 1940743296 19.153 99 41 82 2 1967912384 14084960 13084128
20:33:28 13431 8192000000 10884592816 11320418304 1957680080 19.288 100 39 78 0 1984632080 14966160 11985840
20:33:52 8046 8192000000 10907096928 11336032256 1968676928 19.375 100 48 96 2 1997388368 14640528 14070912
20:34:17 14603 8192000000 10918797856 11348172800 1975175504 19.426 100 51 102 1 2008512672 18582832 14754336
20:34:40 6941 8192000000 10929942224 11359952896 1981763760 19.479 100 57 114 1 2021475296 23398896 16312640
20:34:56 13466 8192000000 10922345728 11346743296 1959008272 19.298 99 58 116 3 1994274736 18645824 16620640
20:35:16 3746 8192000000 10913769280 11338088448 1965370080 19.349 100 66 131 1 2004367008 19541168 19455760
20:35:28 2921 8192000000 10932205248 11351867392 1976061216 19.434 100 70 140 0 2016814624 20678400 20075008
20:35:38 3790 8192000000 10934744736 11352408064 1979510112 19.461 100 73 146 2 2023454592 21788032 22156448
20:35:49 4660 8192000000 10908115504 11322818560 1952184992 19.244 99 63 125 1 1993161840 22297856 18678992
20:36:01 6935 8192000000 10910628896 11322171392 1940056656 19.147 99 72 142 2 1984333632 23624352 20652624
20:36:19 4502 8192000000 10920445648 11334422528 1952415232 19.246 100 73 146 0 2001739440 27607440 21716768
20:36:34 4645 8192000000 10913246416 11332014080 1950716592 19.232 100 67 134 1 1999754000 28714720 20322688
20:36:46 3701 8192000000 10932385712 11349422080 1962964864 19.330 100 76 152 2 2018929904 33322608 22642432
20:37:03 1580 8192000000 10908827248 11332792320 1945883040 19.194 99 64 130 1 1992504272 27122512 19498720
20:37:12 2689 8192000000 10915881328 11336146944 1959019184 19.298 100 71 141 1 2008690416 27671712 21999520
20:37:21 2476 8192000000 10916010320 11335430144 1947361920 19.205 99 80 159 2 1993991136 23024672 23604544
20:37:31 1572 8192000000 10899332016 11319758848 1925509280 19.031 98 68 136 0 1968039648 22510304 20020064
20:37:40 8562 8192000000 10870497696 11294588928 1909445280 18.902 99 61 121 1 1951288608 23706496 18136832
20:38:02 5190 8192000000 10884221952 11300515840 1926905600 19.042 100 76 152 2 1974309008 24007824 23395584
20:38:19 2201 8192000000 10896391264 11311853568 1936962208 19.123 100 80 157 2 1984621728 23183440 24476080
20:38:28 2146 8192000000 10895828080 11304845312 1921990208 19.003 99 79 157 0 1969565488 23894592 23680688
20:38:37 1896 8192000000 10897133632 11306446848 1930389504 19.070 100 82 164 0 1979743728 25114960 24239264
20:38:45 984 8192000000 10899946528 11302154240 1927206080 19.045 100 93 186 1 1982204576 27583648 27414848
20:38:53 1612 8192000000 10892345968 11294216192 1907878720 18.890 99 76 152 0 1958375504 27373040 23123744
20:39:04 1682 8192000000 10871194128 11272978432 1900071184 18.827 99 88 176 3 1951449184 25324288 26053712
20:39:13 2330 8192000000 10882071312 11289272320 1886990656 18.722 98 81 161 3 1937211648 25318976 24902016
20:39:22 1069 8192000000 10870264304 11283251200 1892300768 18.764 99 70 140 0 1942356592 28303776 21752048
20:39:29 6552 8192000000 10830946832 11248918528 1848036800 18.406 97 45 89 1 1892398272 29471856 14889616
20:39:42 9622 8192000000 10831227840 11260981248 1878619520 18.654 100 33 66 3 1919224480 29687136 10917824
20:40:06 6853 8192000000 10857484272 11276238848 1890804528 18.752 100 56 111 3 1942502736 33400288 18297920
20:40:23 11268 8192000000 10858833680 11279142912 1866263280 18.554 98 46 91 2 1920488640 38840528 15384832
20:40:41 13986 8192000000 10838187376 11273621504 1857877440 18.486 98 35 70 0 1903801936 33729776 12194720
20:41:02 9436 8192000000 10861245872 11278864384 1893927312 18.777 100 59 116 2 1944310912 32027264 18356336
20:41:20 2376 8192000000 10836246016 11240001536 1862773840 18.526 98 57 112 1 1911724704 31653232 17297632
20:41:29 10318 8192000000 10826115856 11257303040 1853190512 18.448 98 31 62 0 1888458704 25568832 9699360
20:41:46 13451 8192000000 10838944272 11262029824 1873175328 18.610 99 35 70 0 1908038464 23675440 11187696
20:42:09 4582 8192000000 10871118256 11279560704 1906107888 18.875 100 51 101 2 1946908144 25489696 15310560
20:42:24 1502 8192000000 10891509680 11305754624 1933569728 19.095 100 76 150 0 1983930672 26973696 23387248
20:42:33 4886 8192000000 10886868000 11303948288 1909740864 18.905 99 64 127 0 1957941920 28870640 19330416
20:42:45 10251 8192000000 10889757168 11314368512 1929655328 19.064 100 61 122 0 1980253424 31047024 19551072
20:43:03 7014 8192000000 10885816112 11307741184 1909283936 18.901 99 50 100 2 1955816960 31399216 15133808
20:43:17 9180 8192000000 10856553904 11298136064 1895506400 18.790 99 32 64 0 1936853664 31233024 10114240
20:43:54 21639 8192000000 10883843680 11305373696 1908043520 18.891 99 50 101 5 1944546640 20633056 15870064
20:44:36 2820 8192000000 10882288880 11303088128 1913100336 18.932 99 56 113 0 1954043008 24219536 16723136
20:44:49 7493 8192000000 10899258864 11320217600 1938143696 19.132 100 59 117 2 1984938464 28861792 17932976
20:45:07 4400 8192000000 10898194368 11332583424 1942389536 19.166 100 50 100 2 1986649024 29016656 15242832
20:45:21 13125 8192000000 10871534096 11306823680 1910717216 18.912 99 34 68 0 1948844016 27584864 10541936
20:45:43 9258 8192000000 10867236192 11308236800 1925612400 19.032 100 23 46 1 1959480304 26944064 6923840
20:46:15 12019 8192000000 10871891552 11307872256 1906253584 18.877 99 25 50 1 1941934352 27482848 8197920
20:46:36 24017 8192000000 10874186528 11307962368 1910265904 18.909 99 28 56 1 1947665344 28478208 8921232
20:47:07 31950 8192000000 10876680832 11324010496 1928785568 19.057 100 23 46 1 1967394288 30941264 7667456
20:48:39 41863 8192000000 10873909792 11334037504 1915762192 18.953 99 21 42 1 1955539808 31999104 7778512
20:49:27 31812 8192000000 10867105056 11320393728 1928937248 19.058 100 22 44 2 1957843568 22340480 6565840
20:50:05 19254 8192000000 10875207472 11338690560 1943231088 19.173 100 16 32 1 1966638928 18187056 5220784
20:50:30 44139 8192000000 10890782192 11345887232 1950309680 19.229 100 23 46 0 1976906384 19013728 7582976
20:51:46 55059 8192000000 10870994528 11321778176 1913715152 18.936 99 19 37 2 1935065248 16166400 5183696
20:52:48 52407 8192000000 10909671744 11342659584 1941478304 19.159 100 26 51 1 1961591632 12424464 7688864
20:53:47 149505 8192000000 10893008048 11339505664 1927796704 19.049 98 41 82 1 1953347408 13985200 11565504
20:56:25 73493 8192000000 10911826736 11353034752 1937283824 19.125 99 28 56 0 1961346080 15428400 8633856
20:57:46 144377 8192000000 10908425856 11368890368 1909995840 18.907 97 35 70 0 1931916016 12179616 9740560
21:00:23 31919 8192000000 10915386224 11368673280 1988829632 19.535 100 41 81 1 2008245056 7660656 11754768
21:01:03 42824 8192000000 10926505712 11382947840 1970835824 19.392 99 15 31 0 1989767088 14321248 4610016
21:01:52 40458 8192000000 10927388720 11392905216 1995279632 19.585 100 19 38 1 2014395936 13916720 5199584
21:03:08 102333 8192000000 10938254368 11402338304 2000182672 19.624 100 20 40 1 2026247472 20220240 5844560
21:05:16 68078 8192000000 10938982864 11401998336 1998937120 19.614 100 20 40 0 2027744496 22259008 6548368
21:06:43 39590 8192000000 10930385488 11392638976 1976389552 19.436 99 24 48 0 2000932704 16993328 7549824
21:08:28 70925 8192000000 10940967312 11394486272 1981422608 19.476 99 28 51 1 2000144160 11386608 7334944
21:10:02 30896 8192000000 10928961744 11391004672 2002440032 19.642 100 30 59 3 2019345872 8293456 8612384
21:10:39 38299 8192000000 10917023344 11388215296 1994561712 19.580 100 18 36 0 2009104672 9320240 5222720
21:11:58 36886 8192000000 10931015360 11378597888 1978033296 19.449 99 43 86 0 1998347952 7972224 12342432
21:12:45 35584 8192000000 10923879088 11388334080 1977225216 19.443 99 28 56 0 1995437440 10576128 7636096
21:13:48 77298 8192000000 10906803120 11363700736 1914578368 18.943 96 16 32 0 1928620528 9729696 4312464
21:15:19 44932 8192000000 10900408000 11356172288 1952242416 19.244 99 25 50 0 1975343552 16559984 6541152
21:16:11 40954 8192000000 10910306048 11366072320 1950510768 19.231 99 30 60 2 1971140704 12307376 8322560
21:17:04 230879 8192000000 10876819392 11356839936 1756706080 17.657 89 8 16 0 1778913744 20563728 1643936
21:21:25 66663 8192000000 10879704784 11330207744 1881840464 18.680 96 29 58 0 1896653232 5975152 8837616
21:22:42 41999 8192000000 10844914080 11296268288 1858601248 18.492 95 45 87 1 1880565024 9588608 12375168
21:23:30 40259 8192000000 10864487888 11313504256 1915447392 18.950 99 33 66 1 1934191808 10199600 8544816
21:24:18 36797 8192000000 10874353312 11329892352 1912728064 18.929 98 29 59 1 1931512288 10626496 8157728
21:25:06 25271 8192000000 10825815648 11277955072 1862095664 18.520 96 25 48 2 1878094336 9210976 6787696
21:25:41 84720 8192000000 10854759728 11322052608 1870543952 18.589 97 10 20 0 1886777744 13185904 3047888
21:27:12 37714 8192000000 10823462848 11286884352 1858869104 18.494 97 12 22 3 1876235136 14009680 3356352
21:27:56 75075 8192000000 10830582352 11297927168 1878912864 18.656 98 16 32 0 1904163824 20306704 4944256
21:29:56 63905 8192000000 10857212720 11324534784 1903774256 18.857 99 12 24 0 1921530864 14428208 3328400
21:32:22 113709 8192000000 10834085344 11298611200 1751056160 17.610 90 11 22 0 1763021536 9099776 2865600
21:34:24 33825 8192000000 10884228224 11324882944 1932881584 19.090 100 35 71 1 1950567072 8221904 9463584
21:35:07 22756 8192000000 10877764896 11331461120 1927604336 19.048 99 44 85 0 1948117056 9051024 11461696
21:35:36 30181 8192000000 10873871456 11325550592 1905142496 18.868 98 43 86 3 1928426096 11345360 11938240
21:36:14 52902 8192000000 10842807696 11307405312 1892478592 18.766 98 20 40 1 1909622240 11202208 5941440
21:37:20 86055 8192000000 10855537936 11309195264 1826147872 18.228 94 23 46 1 1840826224 9112000 5566352
21:38:55 26894 8192000000 10885785280 11334397952 1943950400 19.178 100 44 88 3 1966840960 10441680 12448880
21:39:28 59413 8192000000 10869562512 11338723328 1923422720 19.014 99 33 66 0 1949013312 16152992 9437600
21:41:36 141983 8192000000 10884267760 11365822464 1924508640 19.023 99 11 22 0 1939397280 11690576 3198064
21:44:15 44181 8192000000 10911902832 11377881088 1971522400 19.398 100 17 34 2 1986464416 9699024 5242992
21:45:12 93192 8192000000 10906155472 11383447552 1960205760 19.308 100 10 20 1 1985335200 22710752 2418688
21:47:14 117907 8192000000 10921341120 11389554688 1959522624 19.302 99 20 40 0 1979556720 14306304 5727792
21:49:19 34484 8192000000 10894961968 11381063680 1957084672 19.283 99 15 29 2 1979144912 17456736 4603504
21:50:00 36742 8192000000 10891633616 11367571456 1948521856 19.215 99 10 20 2 1969325904 17974928 2829120
21:50:43 79306 8192000000 10894422656 11378946048 1969234288 19.379 100 6 12 0 1985170400 14297520 1638592
21:52:10 37574 8192000000 10891220720 11361923072 1958109920 19.291 99 17 35 0 1970070080 7147376 4812784
21:52:56 82266 8192000000 10900597104 11376037888 1965936448 19.353 99 14 28 0 1978152000 8032864 4182688
21:54:25 62072 8192000000 10902217072 11381243904 1987214272 19.522 100 15 30 1 2000253984 8967184 4072528
21:56:17 64663 8192000000 10900430848 11372294144 1964133632 19.339 99 13 25 1 1978196496 10912432 3150432
21:57:33 46101 8192000000 10909042848 11382669312 1981368656 19.476 100 18 36 2 1996749120 10616016 4764448
21:58:26 75723 8192000000 10904322432 11384967168 1960661024 19.311 99 6 12 0 1975003568 12631344 1711200
21:59:48 64279 8192000000 10904313344 11378802688 1949962800 19.226 98 13 26 1 1960401040 7364336 3073904
22:00:58 37952 8192000000 10924597616 11392110592 1989944768 19.543 100 26 53 0 2006959888 9311200 7703920
22:02:08 71388 8192000000 10902741904 11392901120 1975561552 19.430 99 18 36 1 1991329952 10613904 5154496
22:03:42 82184 8192000000 10934269232 11379757056 1920249424 18.989 96 29 58 1 1938226592 10101584 7875584
22:05:10 28762 8192000000 10925834272 11372769280 1950715376 19.232 98 48 96 1 1981323328 17247296 13360656
22:05:52 68721 8192000000 10894776512 11387793408 1946751088 19.201 98 48 96 2 1982618512 22544384 13323040
22:07:08 102472 8192000000 10894723392 11366297600 1894922832 18.785 96 8 16 1 1917484992 20734752 1827408
22:09:19 33563 8192000000 10886840704 11348844544 1911409520 18.918 97 31 62 0 1931314832 11401904 8503408
22:10:02 154467 8192000000 10847050928 11307827200 1760860752 17.692 89 29 58 0 1779963824 11053888 8049184
22:12:42 136197 8192000000 10857892352 11320750080 1894243008 18.780 98 22 44 0 1911635040 11124016 6268016
22:15:05 20827 8192000000 10856198224 11336400896 1936204512 19.116 100 17 34 2 1955051824 13706128 5141184
22:15:46 40796 8192000000 10804704432 11282583552 1836990672 18.316 95 9 18 1 1849880800 10534720 2355408
22:16:48 51429 8192000000 10820429584 11295584256 1873227744 18.610 98 9 18 1 1884265104 8324912 2712448
22:17:51 50208 8192000000 10851679712 11316350976 1889681216 18.743 98 21 41 0 1904406144 8698768 6026160
22:19:27 51297 8192000000 10830159936 11310755840 1900143760 18.827 99 16 32 0 1919772592 14926992 4701840
22:20:32 89317 8192000000 10826239040 11306631168 1817520480 18.157 95 9 18 1 1834298768 13902288 2876000
22:22:15 24436 8192000000 10839787264 11302252544 1902954160 18.850 99 30 61 0 1918127488 6771216 8402112
22:22:45 82899 8192000000 10857068864 11314057216 1845655824 18.387 96 13 26 1 1858859568 9037424 4166320
22:24:15 55076 8192000000 10862252960 11316953088 1895969584 18.794 98 36 71 2 1914843280 8845824 10027872
22:25:19 34907 8192000000 10869636928 11330654208 1937424496 19.126 100 35 70 1 1958189248 11182144 9582608
22:26:00 44903 8192000000 10873525728 11326169088 1905384416 18.870 98 38 76 0 1927536368 11605232 10546720
22:26:54 25896 8192000000 9139001984 9363734528 304015696 3.578 16 1 2 0 305770592 1692768 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 09-12-2020 22:28:16 to 09-12-2020 22:28:45.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-12-2020 22:28:46 to 09-12-2020 22:28:48.

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          251899
MON$OLDEST_ACTIVE               251900
MON$OLDEST_SNAPSHOT             251900
MON$NEXT_TRANSACTION            251900
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                       2023872
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
--- end of diff output ---

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

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