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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17527124 kB
MemAvailable 31400764 kB
Buffers 0 kB
Cached 14148660 kB
SwapCached 3488 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-11-15 22:27:02
DTS_END                         2020-11-15 22:27:02.5040
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/40736
TRN_ID                          232833
ATT_ID                          694
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: 8940.33 28454 1072840
customer order: creation 163.54 365 19625
customer order: refuse 14.17 377 1700
order to supplier: creation 44.10 1401 5292
order to supplier: removal 3.27 96801 392
invoice (draft): creation 43.12 3701 5174
invoice (draft): removal 51.43 795 6172
invoice accept: apply 39.43 18656 4732
invoice accept: cancel 46.64 767 5597
customer reserve: creation 3676.39 182 441167
customer reserve: removal 4576.15 53 549138
realization accept: apply 78.79 210 9455
realization accept: cancel 78.46 121 9415
payment from customer: creation 57.34 134 6881
payment from customer: removal 5.37 109 644
payment to supplier: creation 46.49 179 5579
payment to supplier: removal 3.29 90 395
service: total inventory turnovers 4.93 1022 592
service: total monetary turnovers 6.56 24 787
service: aggregate perf. data 0.83 19920 99
service: refresh index statistics 0.03 424178 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7232
TEST_TIME 2 6339
TEST_TIME 3 5720
TEST_TIME 4 5178
TEST_TIME 5 5954
TEST_TIME 6 5963
TEST_TIME 7 6272
TEST_TIME 8 6109
TEST_TIME 9 6466
TEST_TIME 10 6692
TEST_TIME 11 6454
TEST_TIME 12 6569
TEST_TIME 13 6610
TEST_TIME 14 6764
TEST_TIME 15 6792
TEST_TIME 16 7028
TEST_TIME 17 7346
TEST_TIME 18 7513
TEST_TIME 19 7789
TEST_TIME 20 8069
TEST_TIME 21 7881
TEST_TIME 22 8246
TEST_TIME 23 8802
TEST_TIME 24 9021
TEST_TIME 25 9157
TEST_TIME 26 9229
TEST_TIME 27 9609
TEST_TIME 28 10089
TEST_TIME 29 10073
TEST_TIME 30 10323
TEST_TIME 31 10109
TEST_TIME 32 10115
TEST_TIME 33 9956
TEST_TIME 34 9748
TEST_TIME 35 9593
TEST_TIME 36 9670
TEST_TIME 37 9468
TEST_TIME 38 9415
TEST_TIME 39 9270
TEST_TIME 40 9133
TEST_TIME 41 9104
TEST_TIME 42 9287
TEST_TIME 43 9165
TEST_TIME 44 9176
TEST_TIME 45 9056
TEST_TIME 46 8961
TEST_TIME 47 8937
TEST_TIME 48 8826
TEST_TIME 49 8986
TEST_TIME 50 8997
TEST_TIME 51 8941
TEST_TIME 52 8967
TEST_TIME 53 9015
TEST_TIME 54 9035
TEST_TIME 55 9143
TEST_TIME 56 9163
TEST_TIME 57 9066
TEST_TIME 58 9057
TEST_TIME 59 9141
TEST_TIME 60 9291
TEST_TIME 61 9295
TEST_TIME 62 9320
TEST_TIME 63 9235
TEST_TIME 64 9115
TEST_TIME 65 9067
TEST_TIME 66 9015
TEST_TIME 67 9019
TEST_TIME 68 8957
TEST_TIME 69 9007
TEST_TIME 70 8952
TEST_TIME 71 9021
TEST_TIME 72 9038
TEST_TIME 73 8981
TEST_TIME 74 9037
TEST_TIME 75 9122
TEST_TIME 76 9046
TEST_TIME 77 9170
TEST_TIME 78 9155
TEST_TIME 79 9224
TEST_TIME 80 9208
TEST_TIME 81 9223
TEST_TIME 82 9234
TEST_TIME 83 9132
TEST_TIME 84 9111
TEST_TIME 85 9045
TEST_TIME 86 9097
TEST_TIME 87 9065
TEST_TIME 88 9027
TEST_TIME 89 8986
TEST_TIME 90 8943
TEST_TIME 91 8892
TEST_TIME 92 8928
TEST_TIME 93 8915
TEST_TIME 94 9008
TEST_TIME 95 9013
TEST_TIME 96 9007
TEST_TIME 97 9019
TEST_TIME 98 9004
TEST_TIME 99 9133
TEST_TIME 100 9103
TEST_TIME 101 9124
TEST_TIME 102 9145
TEST_TIME 103 9170
TEST_TIME 104 9202
TEST_TIME 105 9161
TEST_TIME 106 9209
TEST_TIME 107 9143
TEST_TIME 108 9087
TEST_TIME 109 9042
TEST_TIME 110 9041
TEST_TIME 111 9031
TEST_TIME 112 8983
TEST_TIME 113 9023
TEST_TIME 114 9012
TEST_TIME 115 8991
TEST_TIME 116 8995
TEST_TIME 117 9012
TEST_TIME 118 8992
TEST_TIME 119 9017
TEST_TIME 120 8944

Performance per minute, chart


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

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 1480495 1480495 0 0.00 0 40071 6 0 0
doc_list_biud 1480494 1480494 0 0.00 0 50827 26 0 0
sp_add_invoice_to_stock 4847 4732 115 2.37 32 239657 18656 0 115
sp_cancel_adding_invoice 5597 5597 0 0.00 5 54069 768 0 0
sp_cancel_client_order 1700 1700 0 0.00 4 11236 377 0 0
sp_cancel_customer_reserve 549138 549138 0 0.00 1 18555 53 0 0
sp_cancel_pay_from_customer 644 644 0 0.00 3 12652 110 0 0
sp_cancel_pay_to_supplier 395 395 0 0.00 3 8398 91 0 0
sp_cancel_supplier_invoice 6182 6172 10 0.16 2 21458 796 0 10
sp_cancel_supplier_order 392 392 0 0.00 6 880645 96801 0 0
sp_cancel_write_off 9415 9415 0 0.00 1 11510 121 0 0
sp_client_order 19625 19625 0 0.00 4 28263 365 0 0
sp_customer_reserve 441167 441167 0 0.00 0 70588 182 0 0
sp_fill_shopping_cart 30072 30072 0 0.00 1 23143 43 0 0
sp_fill_shopping_cart_clo_res 441159 441159 0 0.00 0 22099 15 0 0
sp_get_clo_for_invoice 4724 4724 0 0.00 0 42653 364 0 0
sp_kill_cost_storno 16051 16051 0 0.00 0 12646 62 0 0
sp_kill_qstorno_ret_qs2qd 1114255 1114255 0 0.00 0 20914 29 0 0
sp_kill_qty_storno 586591 586591 0 0.00 0 50827 64 0 0
sp_lock_selected_doc 19735 19735 0 0.00 0 7784 4 0 0
sp_make_cost_storno 26638 26638 0 0.00 0 33714 76 0 0
sp_multiply_rows_for_pdistr 26638 26638 0 0.00 0 18695 36 0 0
sp_multiply_rows_for_qdistr 19625 19625 0 0.00 0 24329 166 0 0
sp_pay_from_customer 6881 6881 0 0.00 4 20650 135 0 0
sp_pay_to_supplier 5579 5579 0 0.00 5 23891 179 0 0
sp_payment_common 12460 12460 0 0.00 1 21092 46 0 0
sp_qd_handle_on_cancel_clo 1700 1700 0 0.00 0 11226 353 0 0
sp_qd_handle_on_invoice_upd_sts 10319 10319 0 0.00 0 16973 332 0 0
sp_qd_handle_on_reserve_upd_sts 9455 9455 0 0.00 0 50826 68 0 0
sp_reserve_write_off 9455 9455 0 0.00 7 50859 211 0 0
sp_supplier_invoice 5174 5174 0 0.00 8 86309 3701 0 0
sp_supplier_order 5292 5292 0 0.00 6 62878 1402 0 0
srv_aggregate_perf_data 100 99 1 1.00 2695 257453 19920 0 1
srv_fill_mon_cache_memory 152 152 0 0.00 956 150622 34640 0 0
srv_find_qd_qs_mism 1026806 1026806 0 0.00 0 20724 5 0 0
srv_make_invnt_saldo 592 592 0 0.00 20 40245 1022 0 0
srv_make_money_saldo 787 787 0 0.00 1 774 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 208348 520207 424179 0 0
t$perf-abend:sp_add_invoice_to_stock 115 115 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 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 4732 4732 0 0.00 0 11030 173 0 0
t$perf-norm:sp_cancel_adding_invoice 374 374 0 0.00 1 1393 83 0 0
t$perf-norm:sp_cancel_client_order 1700 1700 0 0.00 0 4869 22 0 0
t$perf-norm:sp_cancel_customer_reserve 642 642 0 0.00 0 2999 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 644 644 0 0.00 0 3346 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 395 395 0 0.00 0 1740 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 396 396 0 0.00 0 524 9 0 0
t$perf-norm:sp_cancel_supplier_order 392 392 0 0.00 0 18876 1807 0 0
t$perf-norm:sp_cancel_write_off 1015 1015 0 0.00 0 5245 21 0 0
t$perf-norm:sp_client_order 19625 19625 0 0.00 0 6882 18 0 0
t$perf-norm:sp_customer_reserve 942 942 0 0.00 0 1856 8 0 0
t$perf-norm:sp_pay_from_customer 6881 6881 0 0.00 0 8753 12 0 0
t$perf-norm:sp_pay_to_supplier 5579 5579 0 0.00 0 4677 12 0 0
t$perf-norm:sp_reserve_write_off 9455 9455 0 0.00 0 5895 12 0 0
t$perf-norm:sp_supplier_invoice 5174 5174 0 0.00 0 6509 17 0 0
t$perf-norm:sp_supplier_order 5292 5292 0 0.00 0 7203 21 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 956 21 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 595 9 0 0
t$perf-norm:srv_make_invnt_saldo 592 592 0 0.00 0 1076 17 0 0
t$perf-norm:srv_make_money_saldo 787 787 0 0.00 0 2452 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 9674 9444 230 2.37 0 3519 18 0 230
v_all_customers 36260 36260 0 0.00 0 20 1 0 0
v_all_suppliers 28834 28834 0 0.00 0 76 1 0 0
v_all_wares 39248 39248 0 0.00 0 123 1 0 0
v_cancel_adding_invoice 748 748 0 0.00 0 2230 11 0 0
v_cancel_client_order 3400 3400 0 0.00 0 1926 5 0 0
v_cancel_customer_prepayment 1288 1288 0 0.00 0 2223 9 0 0
v_cancel_customer_reserve 1284 1284 0 0.00 0 2227 7 0 0
v_cancel_payment_to_supplier 790 790 0 0.00 0 842 4 0 0
v_cancel_supplier_invoice 812 792 20 2.46 0 2718 18 0 20
v_cancel_supplier_order 784 784 0 0.00 0 978 6 0 0
v_cancel_write_off 2030 2030 0 0.00 0 4332 20 0 0
v_max_id_clo_ord 5292 5292 0 0.00 0 461 1 0 0
v_max_id_clo_res 942 942 0 0.00 0 6854 22 0 0
v_max_id_ord_sup 5156 5156 0 0.00 0 2993 3 0 0
v_max_non_paid_invoice 1610 1610 0 0.00 0 1610 3 0 0
v_max_non_paid_realizn 3503 3503 0 0.00 0 3902 7 0 0
v_min_id_clo_ord 5292 5292 0 0.00 0 3676 8 0 0
v_min_id_clo_res 942 942 0 0.00 0 6442 17 0 0
v_min_id_ord_sup 5156 5156 0 0.00 0 5322 8 0 0
v_min_non_paid_invoice 5579 5579 0 0.00 0 21011 42 0 0
v_min_non_paid_realizn 6881 6881 0 0.00 0 20615 30 0 0
v_our_firm 9744 9744 0 0.00 0 15 1 0 0
v_reserve_write_off 18910 18910 0 0.00 0 3747 6 0 0
x_lock_depdocs_on_canc_invoice 11373 11373 0 0.00 0 15497 120 0 0
x_lock_depdocs_on_canc_sup_ord 392 392 0 0.00 0 5871 373 0 0
x_make_qstorno_1000_1200 5292 5292 0 0.00 1 62869 1315 0 0
x_make_qstorno_1200_2000 5174 5174 0 0.00 4 82820 3545 0 0
x_make_qstorno_2100_3300 441167 441167 0 0.00 0 70588 164 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 15-11-2020 22:28:16 to 15-11-2020 22:28:21.

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:06 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:12 18105 8192000000 10264843712 10577846272 888164336 9.781 68 49 98 0 907530976 2400288 16966352
19:57:39 29510 8192000000 10359523520 10677985280 1408399488 14.670 100 89 178 1 1442600896 4849760 29351648
19:58:18 36095 8192000000 10400023472 10727596032 1456842560 15.098 100 90 180 0 1492075424 6451024 28781840
19:59:06 25402 8192000000 10434686720 10765279232 1484788736 15.343 100 89 178 1 1521282032 7696464 28796832
19:59:46 28990 8192000000 10455932304 10791104512 1507215088 15.539 100 91 182 0 1545284576 8424032 29645456
20:00:27 30861 8192000000 10474696624 10818834432 1528361776 15.723 100 84 169 0 1564327424 9038544 26927104
20:01:14 18124 8192000000 10513912240 10859094016 1569453664 16.078 100 86 172 0 1605485248 9844240 26187344
20:01:44 10666 8192000000 10535274256 10885283840 1589125088 16.246 100 83 166 2 1625098832 10758976 25214768
20:02:04 16478 8192000000 10552397664 10905583616 1604401488 16.377 100 75 150 0 1638101024 11103632 22595904
20:02:30 10588 8192000000 10561626544 10922987520 1625327296 16.555 100 75 150 1 1659121312 11399904 22394112
20:02:55 10764 8192000000 10585302400 10951630848 1647001056 16.739 100 69 138 0 1678441600 10936352 20504192
20:03:13 10756 8192000000 10616578864 10980339712 1667499248 16.912 100 84 167 0 1704246976 11782048 24965680
20:03:35 10911 8192000000 10629084480 11000582144 1695788896 17.150 100 74 148 1 1728445840 11411216 21245728
20:03:54 7576 8192000000 10655041328 11027775488 1716297264 17.321 100 78 156 1 1750199216 11752512 22149440
20:04:09 9695 8192000000 10670338128 11044634624 1728096784 17.420 100 86 170 2 1765896128 12681376 25117968
20:04:25 7767 8192000000 10677582224 11051995136 1737015936 17.494 100 78 156 1 1772383296 13231360 22136000
20:04:41 5716 8192000000 10683519024 11066773504 1748436928 17.589 100 74 148 0 1781504704 12552640 20515136
20:04:54 5514 8192000000 10695107792 11073454080 1762277920 17.703 100 80 160 2 1797152736 12378400 22496416
20:05:06 5433 8192000000 10690707456 11079999488 1761492672 17.697 100 75 148 0 1796069232 13013072 21563488
20:05:20 11128 8192000000 10692173264 11084038144 1766828464 17.741 100 68 135 1 1797791168 12611568 18351136
20:05:38 3578 8192000000 10723796096 11106619392 1782525392 17.870 100 75 148 1 1815800032 12343664 20930976
20:05:49 3035 8192000000 10734822624 11118895104 1793591408 17.961 100 67 136 1 1823836128 11497392 18747328
20:05:59 4205 8192000000 10734095168 11127488512 1802662640 18.036 100 65 129 2 1832657152 11561088 18433424
20:06:10 3415 8192000000 10759314112 11143921664 1813711280 18.126 100 74 148 2 1847311392 12712656 20887456
20:06:21 4228 8192000000 10765737376 11153895424 1822395600 18.197 100 77 154 1 1857176736 13419440 21361696
20:06:32 2980 8192000000 10774998848 11158712320 1831582480 18.272 100 87 174 0 1870325648 14260480 24482688
20:06:42 2477 8192000000 10776435840 11161886720 1835933856 18.308 100 87 172 1 1875120864 15248992 23938016
20:06:51 2971 8192000000 10791007216 11174600704 1841607696 18.354 100 93 187 3 1882537840 15658288 25271856
20:07:01 2731 8192000000 10787356848 11172065280 1840215984 18.343 100 91 181 2 1880544704 14963728 25364992
20:07:10 3523 8192000000 10785449184 11170770944 1841559520 18.354 100 88 177 1 1881424752 15613888 24251344
20:07:20 1911 8192000000 10794103520 11178315776 1847930528 18.405 100 92 185 1 1886870176 13841504 25098144
20:07:29 2714 8192000000 10795516576 11182407680 1850583456 18.427 100 91 182 0 1890542048 13646992 26311600
20:07:38 2771 8192000000 10796119360 11188629504 1856828992 18.478 100 80 157 0 1890657472 11299376 22529104
20:07:47 2565 8192000000 10809143568 11193815040 1862437424 18.523 100 90 180 0 1900847776 13223328 25187024
20:07:57 3614 8192000000 10815416768 11203543040 1868725248 18.574 100 88 176 0 1907269888 13759344 24785296
20:08:07 1737 8192000000 10816385376 11203670016 1871090224 18.593 100 91 183 1 1909641232 12673296 25877712
20:08:15 2440 8192000000 10812262432 11198808064 1871527872 18.597 100 93 184 0 1911349792 13692016 26129904
20:08:23 1828 8192000000 10819734032 11206889472 1875519408 18.629 100 92 185 2 1914710720 13577904 25613408
20:08:32 2146 8192000000 10818317696 11209633792 1874252240 18.619 100 94 187 2 1913236176 12906976 26076960
20:08:40 1605 8192000000 10817395344 11210391552 1876706496 18.639 100 88 175 2 1914409456 13512160 24190800
20:08:48 33406 8192000000 10817053120 11214626816 1878800416 18.655 100 71 143 3 1910804080 11054304 20949360
20:09:28 1182 8192000000 10822481536 11218235392 1882081424 18.682 100 87 175 1 1917876816 10777936 25017456
20:09:35 2421 8192000000 10817442000 11215446016 1883927344 18.697 100 83 166 0 1918805472 10947056 23931072
20:09:49 14751 8192000000 10800073040 11219439616 1881169680 18.675 100 45 90 0 1904233136 10506848 12556608
20:10:11 4125 8192000000 10803487760 11226402816 1883865632 18.696 100 30 58 0 1899388528 7422208 8100688
20:10:23 4673 8192000000 10805285568 11224600576 1886094624 18.714 100 39 78 1 1905187568 8044624 11048320
20:10:36 4498 8192000000 10810658976 11228594176 1887967760 18.729 100 38 76 4 1907613776 9348368 10297648
20:10:47 8055 8192000000 10801494080 11227021312 1890962688 18.754 100 39 78 0 1910038688 8843888 10232112
20:11:01 4704 8192000000 10819849568 11236888576 1891156192 18.755 100 31 62 1 1911548496 11647872 8744432
20:11:13 11064 8192000000 10787047056 11226714112 1889975472 18.746 100 19 37 1 1901097376 5875344 5246560
20:11:31 5403 8192000000 10808516992 11232444416 1894105392 18.779 100 32 64 1 1909613456 6709248 8798816
20:11:43 7765 8192000000 10809702704 11236847616 1899619200 18.823 100 28 55 1 1914954704 7819232 7516272
20:11:57 8528 8192000000 10801498464 11237511168 1901537840 18.839 100 20 40 2 1913001792 5635296 5828656
20:12:15 13093 8192000000 10798274944 11239821312 1902541888 18.847 100 23 44 1 1915087168 5544656 7000624
20:12:36 15768 8192000000 10809011776 11245625344 1903114624 18.851 100 10 20 0 1911516192 5640112 2761456
20:12:57 9562 8192000000 10825335472 11252031488 1908940672 18.898 100 22 44 2 1920955552 5694992 6319888
20:13:13 8162 8192000000 10808024256 11248951296 1908684256 18.896 100 24 48 2 1921699904 6356336 6659312
20:13:29 16358 8192000000 10817661136 11253878784 1911138064 18.916 100 23 46 1 1922576272 5434896 6003312
20:13:52 61453 8192000000 10860234608 11267100672 1919862592 18.986 100 55 111 3 1941608448 5217968 16527888
20:15:00 7733 8192000000 10836180704 11267817472 1915550656 18.951 100 29 58 3 1931515824 8112368 7852800
20:15:15 8808 8192000000 10835365280 11270508544 1915093008 18.948 100 27 54 0 1928914128 6528448 7292672
20:15:29 5863 8192000000 10838476144 11272585216 1920044224 18.987 100 31 61 2 1935635424 7359904 8231296
20:15:44 6685 8192000000 10843738464 11275304960 1921534464 18.999 100 29 59 0 1936788656 6508048 8746144
20:15:59 6131 8192000000 10844042832 11277484032 1927221008 19.045 100 45 88 4 1946100352 6300560 12578784
20:16:13 8416 8192000000 10839241456 11275374592 1923606224 19.016 100 27 54 2 1937614416 6445680 7562512
20:16:28 4593 8192000000 10826144288 11255476224 1901848624 18.841 99 30 60 2 1917079792 6994560 8236608
20:16:39 6286 8192000000 10824918528 11263389696 1900251216 18.828 99 23 46 1 1912331152 5676768 6403168
20:16:53 7413 8192000000 10823903936 11256770560 1894624416 18.783 99 26 52 0 1912601808 10715568 7261824
20:17:09 5581 8192000000 10816192560 11249586176 1889155264 18.739 99 29 58 4 1903162544 5654752 8352528
20:17:21 7203 8192000000 10788887712 11214368768 1842625984 18.362 97 25 50 0 1856107904 6493712 6988208
20:17:38 11872 8192000000 10797309680 11224686592 1832644768 18.281 97 17 34 0 1842767328 5197232 4925328
20:17:56 13613 8192000000 10769177456 11200946176 1767835424 17.749 94 19 38 1 1778842912 5834384 5173104
20:18:19 16366 8192000000 10727898384 11151540224 1718361792 17.339 93 13 26 2 1727491312 5308832 3820688
20:18:42 10717 8192000000 10725142656 11144441856 1767857792 17.749 97 28 56 0 1782286432 6662112 7766528
20:18:59 65351 8192000000 10701254336 11118653440 1654097760 16.799 91 23 46 0 1669701360 8853680 6749920
20:20:11 8268 8192000000 10706862608 11112271872 1721683216 17.366 96 31 60 1 1736394224 5609152 9101856
20:20:28 8121 8192000000 10700839552 11104948224 1724542624 17.390 96 37 75 0 1742132944 7103872 10486448
20:20:42 6272 8192000000 10704401568 11115171840 1777920208 17.832 99 28 56 0 1792696912 6321200 8455504
20:20:55 7456 8192000000 10704253904 11116408832 1747377296 17.580 97 27 55 1 1761555600 5340336 8837968
20:21:11 7999 8192000000 10703952032 11116359680 1771200528 17.777 99 19 38 1 1782144064 5355728 5587808
20:21:28 7904 8192000000 10698813456 11117977600 1762812656 17.708 98 19 38 0 1773540048 4622608 6104784
20:21:43 13224 8192000000 10688750256 11104772096 1750457648 17.605 97 16 30 4 1759586528 5056768 4072112
20:22:02 12965 8192000000 10704840896 11117694976 1742041728 17.536 97 21 42 2 1753988240 5484112 6462400
20:22:21 8078 8192000000 10734473008 11141787648 1805238048 18.057 100 35 70 2 1821280448 5740624 10301776
20:22:36 10771 8192000000 10731036336 11146489856 1806442384 18.067 100 18 36 0 1821380528 9862224 5075920
20:22:53 9549 8192000000 10735447952 11145019392 1794827696 17.971 99 19 38 2 1805633920 5045248 5760976
20:23:09 9234 8192000000 10725272864 11142987776 1783712688 17.880 98 28 55 1 1797323200 4741728 8868784
20:23:25 10596 8192000000 10750913776 11169275904 1829245840 18.253 100 23 45 1 1840842640 4818288 6778512
20:23:46 69262 8192000000 10755038496 11180457984 1838449248 18.328 100 26 52 0 1850505776 4739008 7317520
20:25:02 14075 8192000000 10760561760 11180285952 1829208720 18.253 99 23 46 1 1841368704 5744432 6415552
20:25:25 6825 8192000000 10774904848 11190865920 1850716736 18.428 100 39 78 3 1868231408 7178368 10336304
20:25:40 7285 8192000000 10765835008 11191123968 1851552656 18.435 100 30 61 1 1866491376 6596416 8342304
20:25:56 9050 8192000000 10764208000 11193618432 1858128576 18.488 100 36 72 3 1874264464 5572960 10562928
20:26:13 7558 8192000000 10768893872 11200266240 1860204288 18.505 100 28 56 1 1873870992 5886848 7779856
20:26:28 9509 8192000000 10768930560 11198902272 1860063696 18.504 100 17 34 0 1870174048 5180672 4929680
20:26:45 4995 8192000000 10780862288 11208192000 1868682704 18.574 100 19 38 1 1880396384 4885248 6828432
20:26:59 6392 8192000000 10788192048 11216478208 1874264656 18.619 100 28 56 0 1887684928 5200848 8219424
20:27:13 12615 8192000000 10827232352 11244716032 1898324528 18.813 100 53 107 2 1920563168 6884704 15353936
20:27:34 15877 8192000000 10837081136 11255832576 1905575344 18.871 100 50 97 3 1927021760 7898016 13548400
20:27:58 64449 8192000000 10846736432 11270758400 1917173760 18.964 100 47 95 4 1940178832 9554768 13450304
20:29:09 78666 8192000000 10859356608 11296071680 1929130000 19.060 100 32 64 3 1947818144 8855296 9832848
20:30:39 86332 8192000000 10868271888 11309965312 1944990912 19.187 100 38 76 3 1967037040 10075120 11971008
20:32:17 27369 8192000000 10883380624 11323162624 1949524464 19.223 100 25 51 0 1970762128 13339008 7898656
20:32:52 65003 8192000000 10882623296 11334320128 1957177600 19.284 100 26 51 1 1977953680 13566528 7209552
20:34:06 15991 8192000000 10898684064 11334705152 1967358688 19.364 100 48 95 0 1990044096 9789728 12895680
20:34:31 6277 8192000000 10912300976 11344773120 1976986032 19.441 100 58 117 3 2006966800 13284736 16696032
20:34:43 14947 8192000000 10916264688 11351384064 1978220032 19.451 100 48 96 0 2006492128 14016240 14255856
20:35:05 5250 8192000000 10928925264 11355590656 1983881504 19.495 100 62 125 2 2012559088 10794560 17883024
20:35:21 8441 8192000000 10932824576 11361173504 1990688000 19.549 100 74 149 0 2023182912 11195632 21299280
20:35:40 11315 8192000000 10940128784 11371630592 1993570400 19.572 100 57 114 0 2024176928 14500096 16106432
20:36:00 6779 8192000000 10946758208 11375476736 1999114816 19.616 100 61 120 1 2031963328 15122928 17725584
20:36:15 5431 8192000000 10961295840 11384680448 2009569264 19.698 100 71 142 3 2048104288 17357392 21177632
20:36:28 7968 8192000000 10957327200 11392966656 2006682688 19.675 100 64 128 0 2045488432 20168624 18637120
20:36:44 4342 8192000000 10952677680 11378442240 1973847328 19.416 98 79 157 4 2017252688 20405504 22999856
20:37:00 9308 8192000000 10952983280 11389296640 2005772208 19.668 100 56 112 0 2044576384 22168768 16635408
20:37:23 5102 8192000000 10949470000 11391524864 2009750480 19.700 100 54 108 0 2044050528 18368288 15931760
20:37:36 21423 8192000000 10959220400 11398414336 2013762944 19.731 100 47 92 3 2045071424 18453472 12855008
20:38:06 9931 8192000000 10974656848 11409051648 2022975792 19.804 100 62 124 2 2061321088 20433264 17912032
20:38:27 12004 8192000000 10968102688 11402706944 2015182304 19.742 100 55 110 0 2052777232 21717728 15877200
20:38:51 12029 8192000000 10961307712 11398402048 1998019744 19.607 99 50 100 1 2032515648 19439024 15056880
20:39:13 11506 8192000000 10958914336 11405291520 2016937712 19.756 100 47 94 0 2055263296 23350288 14975296
20:39:35 7907 8192000000 10958308512 11410038784 2022365456 19.799 100 47 94 2 2058015936 21368576 14281904
20:39:55 2522 8192000000 10969899424 11406458880 2018561344 19.769 100 54 108 0 2054402720 19310736 16530640
20:40:06 4713 8192000000 10972302464 11401793536 2018565104 19.769 100 64 127 0 2058556160 20347312 19643744
20:40:17 4633 8192000000 10967961472 11393503232 2004310416 19.657 99 68 135 1 2046059552 21420800 20328336
20:40:30 3609 8192000000 10985708128 11415162880 2024596656 19.816 100 69 136 5 2068858672 23770176 20491840
20:40:41 4363 8192000000 10987711104 11419111424 2029305344 19.853 100 69 138 1 2073386688 22735920 21345424
20:40:56 4400 8192000000 10999122480 11427778560 2036319376 19.908 100 78 154 1 2083344112 23973968 23050768
20:41:09 1783 8192000000 11001309488 11433078784 2038004416 19.921 100 65 130 1 2082730608 24799600 19926592
20:41:19 3096 8192000000 11010820912 11441860608 2045914496 19.983 100 83 165 1 2097319840 26176960 25228384
20:41:32 4986 8192000000 10971576656 11407523840 1980218144 19.466 97 64 127 0 2024203680 24825920 19159616
20:41:44 3197 8192000000 10995073920 11420147712 2026136752 19.828 100 73 147 0 2074390832 25807264 22446816
20:41:54 5456 8192000000 10986936352 11415990272 2023406976 19.807 100 78 156 2 2075008448 27089792 24511680
20:42:10 4767 8192000000 10957059008 11393830912 1990278016 19.546 99 58 116 0 2035830560 27351552 18200992
20:42:22 3527 8192000000 10984362800 11409682432 2014055776 19.733 100 74 149 0 2063842992 27168400 22618816
20:42:33 7186 8192000000 10960709728 11388256256 1979524320 19.461 98 73 147 0 2031362848 28897552 22940976
20:42:48 6330 8192000000 10971949856 11406307328 2007346496 19.681 100 65 130 3 2056746528 29364176 20035856
20:43:04 3403 8192000000 10991396416 11411206144 2011175024 19.711 100 88 175 3 2071142128 33186704 26780400
20:43:14 955 8192000000 10985116928 11403509760 1997675152 19.604 99 92 185 4 2057559632 32149840 27734640
20:43:22 2963 8192000000 10960159248 11379773440 1969155856 19.379 99 86 172 2 2027952176 32955408 25840912
20:43:31 3288 8192000000 10952367200 11375894528 1972292976 19.404 99 73 146 3 2026785840 31832992 22659872
20:43:52 4072 8192000000 10962308144 11388604416 1976225328 19.435 99 71 142 1 2033747696 35568688 21953680
20:44:02 6117 8192000000 10968366832 11391823872 1988298848 19.530 100 75 148 0 2046607488 35367872 22940768
20:44:18 4496 8192000000 10950935408 11382050816 1981224720 19.474 100 63 126 1 2037477968 36473936 19779312
20:44:40 3071 8192000000 10946938640 11380310016 1984275088 19.499 100 54 108 3 2032940592 31665008 17000496
20:44:51 4683 8192000000 10947874976 11372204032 1944610048 19.184 98 67 132 3 1998316912 31969632 21737232
20:45:03 2402 8192000000 10932488256 11347714048 1954207248 19.260 99 69 135 1 2009136192 33758512 21170432
20:45:14 6851 8192000000 10939002992 11361509376 1935202256 19.108 98 75 150 0 1992298352 34112432 22983664
20:45:29 2501 8192000000 10933985184 11340468224 1947515520 19.207 99 87 171 1 2009387776 35448016 26424240
20:45:40 3043 8192000000 10938048640 11366572032 1966013184 19.354 100 75 150 2 2026349872 36742656 23594032
20:45:50 2858 8192000000 10921879472 11349020672 1945631296 19.192 99 68 135 1 2003023136 36403520 20988320
20:46:04 3486 8192000000 10937422576 11352592384 1931688832 19.080 98 80 156 1 1990379472 35389296 23301344
20:46:14 1191 8192000000 10943434592 11359612928 1954177712 19.260 100 82 164 0 2021547296 42620672 24748912
20:46:24 1940 8192000000 10932773648 11350061056 1952864048 19.249 100 68 135 0 2011525216 37764096 20897072
20:46:32 17040 8192000000 10926422880 11360395264 1958620896 19.295 100 59 118 2 2017456064 40941920 17893248
20:46:56 4069 8192000000 10916932848 11347169280 1937967776 19.131 99 52 104 0 1990293040 36227056 16098208
20:47:07 8442 8192000000 10930373472 11361529856 1954755536 19.264 100 45 88 0 2011040960 42107664 14177760
20:47:22 6263 8192000000 10904309824 11335475200 1928187008 19.052 99 41 81 0 1974394752 33786736 12421008
20:47:36 3880 8192000000 10917141504 11347054592 1935489856 19.111 99 51 102 0 1986975024 35732304 15752864
20:47:47 6238 8192000000 10904303344 11336966144 1935401104 19.110 99 44 87 3 1986088672 36742176 13945392
20:47:59 9685 8192000000 10904033936 11333844992 1907749792 18.889 98 44 88 0 1959414288 37205360 14459136
20:48:28 12257 8192000000 10915411264 11352535040 1948279760 19.213 100 38 76 2 2002857520 41275168 13302592
20:49:01 3433 8192000000 10936690960 11365199872 1954705216 19.264 100 64 125 0 2020751328 45114240 20931872
20:49:15 5141 8192000000 10943699136 11372732416 1958985648 19.298 100 48 94 1 2018263312 42987680 16289984
20:49:28 3307 8192000000 10949788416 11363147776 1955789168 19.273 100 67 132 1 2021939024 44655392 21494464
20:49:37 10380 8192000000 10923336624 11363635200 1953220160 19.252 100 60 120 1 2020618144 47993824 19404160
20:50:09 18967 8192000000 10912547168 11363360768 1952011776 19.242 100 31 61 1 1999583440 36621104 10950560
20:50:34 15068 8192000000 10900024256 11344216064 1912707536 18.928 98 24 49 2 1957176208 36436912 8031760
20:50:56 12246 8192000000 10879660608 11337068544 1924268336 19.021 99 19 38 3 1965946496 35157424 6520736
20:51:15 19600 8192000000 10905292336 11339640832 1932083584 19.084 99 37 73 1 1969652512 26302384 11266544
20:51:46 8470 8192000000 10904739520 11346419712 1951970608 19.242 100 51 100 2 1998966176 31826048 15169520
20:52:10 14257 8192000000 10877493680 11318931456 1893448928 18.774 98 26 53 0 1937890144 36075920 8365296
20:53:00 30532 8192000000 10879826720 11330945024 1908141408 18.892 99 25 50 2 1949555856 32249696 9164752
20:53:38 18681 8192000000 10866134352 11315326976 1896674208 18.800 99 20 40 3 1938742128 34806112 7261808
20:54:07 18236 8192000000 10850067760 11301412864 1868312544 18.571 98 23 46 2 1917180800 40850480 8017776
20:54:41 50240 8192000000 10808492176 11262074880 1802046336 18.031 95 11 22 1 1838425232 31628800 4750096
20:55:45 59150 8192000000 10855149312 11289468928 1899189920 18.820 100 26 52 0 1928248416 20734736 8323760
20:57:09 105173 8192000000 10857724080 11305930752 1892355344 18.765 98 36 72 1 1916270624 13815680 10099600
20:59:12 16313 8192000000 10849985824 11302146048 1924066528 19.019 100 27 54 1 1945716432 14118640 7531264
20:59:35 20080 8192000000 10848799120 11309617152 1927932784 19.050 100 9 18 0 1937613280 7357376 2323120
21:00:12 108183 8192000000 10854321696 11309977600 1891633104 18.759 98 14 28 2 1905121632 10122144 3366384
21:02:11 47574 8192000000 10852915888 11305238528 1927314096 19.045 100 19 38 0 1948841968 15800688 5727184
21:03:21 83714 8192000000 10902807056 11326738432 1925643152 19.032 99 34 68 0 1944055456 8808016 9604288
21:04:54 45457 8192000000 10869677664 11330732032 1946441216 19.198 100 23 47 0 1959860560 7467424 5951920
21:05:47 53157 8192000000 10902230000 11352440832 1966412240 19.357 100 33 64 0 1989990704 14468144 9110320
21:06:47 20109 8192000000 10894427600 11348398080 1962962624 19.330 100 35 70 1 1993913376 21243184 9707568
21:07:15 29085 8192000000 10912815648 11356540928 1966579344 19.358 100 36 69 1 1994150160 16962688 10608128
21:07:53 49854 8192000000 10889139984 11351638016 1928286304 19.053 98 27 54 0 1955642208 19685696 7670208
21:08:50 29435 8192000000 10895832240 11366207488 1961560976 19.318 100 10 20 0 1990131920 25087104 3483840
21:10:47 48482 8192000000 10895444624 11358535680 1969843136 19.384 100 26 51 0 1988818368 11588208 7387024
21:11:49 68055 8192000000 10923697216 11376390144 1975689440 19.431 100 12 23 0 1992004384 12950352 3364592
21:13:08 91793 8192000000 10912439808 11393171456 1992125584 19.561 100 22 44 1 2017928032 19396544 6405904
21:14:46 87272 8192000000 10920682624 11395678208 1983573808 19.493 100 21 42 0 2008985744 19160992 6250944
21:16:47 80229 8192000000 10912916624 11393970176 1992675712 19.565 100 10 20 3 2013736288 18071552 2989024
21:18:15 66927 8192000000 10931612176 11394293760 1976466864 19.437 99 23 46 0 1996083184 12742352 6873968
21:19:30 87591 8192000000 10941410176 11408330752 1995531936 19.587 100 14 28 0 2012745792 13230576 3983280
21:21:11 101776 8192000000 10923080736 11396149248 1970614688 19.390 98 21 42 1 1989235968 12936048 5685232
21:22:59 82269 8192000000 10904835600 11375697920 1935368880 19.110 97 13 26 1 1951179248 12431568 3378800
21:24:28 34205 8192000000 10961716368 11401969664 2006358368 19.673 100 49 95 1 2032567952 12692832 13516752
21:25:11 39030 8192000000 10938687296 11395129344 1963866208 19.337 98 41 82 1 1991138736 15834432 11438096
21:26:42 137358 8192000000 10886164240 11349827584 1850024224 18.422 93 13 24 1 1866514176 13619552 2870400
21:29:10 150622 8192000000 10831648496 11284385792 1789203136 17.925 91 14 28 0 1802934576 10241952 3489488
21:31:48 75873 8192000000 10864468560 11337695232 1894070448 18.779 97 25 50 1 1908914448 8083216 6760784
21:33:11 100646 8192000000 10847177392 11332440064 1854122656 18.456 95 10 20 0 1870491952 13558768 2810528
21:34:57 10985 8192000000 10842426352 11326275584 1907268576 18.885 99 6 12 0 1920918576 11520512 2129488
21:35:15 52553 8192000000 10883302800 11345612800 1929720272 19.065 99 27 54 0 1947928144 10339056 7868816
21:36:13 58352 8192000000 10879205680 11347976192 1914890624 18.946 98 14 28 1 1931158256 11490288 4777344
21:37:27 24020 8192000000 10902615312 11344191488 1903200240 18.852 97 53 104 0 1934693040 16111648 15381152
21:38:45 67970 8192000000 10863401920 11336839168 1866601328 18.557 96 11 22 0 1882966064 13257264 3107472
21:40:02 46240 8192000000 10860521136 11317760000 1861671200 18.517 96 19 38 0 1876742736 9687504 5384032
21:40:56 86519 8192000000 10851279056 11322187776 1858314640 18.490 96 29 57 1 1883291696 16132928 8844128
21:42:30 72635 8192000000 10868180368 11330785280 1887528320 18.726 98 7 14 2 1905397360 15956784 1912256
21:44:54 24368 8192000000 10882458672 11309359104 1876177168 18.634 97 22 44 1 1889541984 7072624 6292192
21:45:26 17314 8192000000 10872197040 11320512512 1908845520 18.897 99 37 74 1 1929542160 10202816 10493824
21:45:52 28832 8192000000 10871510304 11332431872 1905275600 18.869 99 26 52 1 1930522304 17898224 7348480
21:47:23 76834 8192000000 10842144880 11301056512 1830071888 18.260 95 23 46 1 1850260416 14052288 6136240
21:48:47 127210 8192000000 10831432240 11284144128 1858774592 18.493 97 20 40 0 1880162464 15684080 5703792
21:51:09 76969 8192000000 10844902000 11308892160 1909864880 18.906 99 14 28 1 1921782304 8237712 3679712
21:52:32 32146 8192000000 10876236400 11317075968 1931083984 19.076 100 41 81 1 1951353104 8522752 11746368
21:53:34 56342 8192000000 10826737424 11291709440 1847105872 18.399 96 15 30 1 1859307152 7684896 4516384
21:54:37 36718 8192000000 10820997184 11294818304 1909549360 18.903 100 8 16 0 1920442384 8500736 2392288
21:55:20 6361 8192000000 10822065648 11294756864 1907780512 18.889 100 6 11 1 1918200800 8772208 1648080
21:56:22 51547 8192000000 10834283488 11302363136 1899103696 18.819 99 19 38 1 1915146576 10628672 5414208
21:57:24 72224 8192000000 10851539728 11316801536 1905742320 18.872 99 17 34 0 1921315664 10484608 5088736
21:58:42 70974 8192000000 10848402128 11323527168 1918322704 18.973 99 20 38 1 1936798576 13350992 5124880
22:00:00 72444 8192000000 10857729920 11344748544 1919651056 18.984 99 11 22 0 1945115136 22259888 3204192
22:01:19 59396 8192000000 10876598704 11344965632 1943579232 19.175 100 12 25 0 1961815312 14843280 3392800
22:02:25 36465 8192000000 10876144720 11343560704 1935853040 19.114 99 17 35 0 1953065488 12491952 4720496
22:03:12 62181 8192000000 10893184912 11368058880 1961762416 19.320 100 19 38 0 1982588768 15763776 5062576
22:04:21 45598 8192000000 10918867696 11373166592 1973852448 19.416 100 19 38 1 1995422528 16338960 5231120
22:05:19 55633 8192000000 10913649504 11390799872 1979296304 19.459 100 15 30 0 2002959040 18950512 4712224
22:06:28 59123 8192000000 10925028256 11384942592 1960877408 19.313 99 16 29 1 1979066320 13840464 4348448
22:07:35 37830 8192000000 10934124080 11392802816 1993532624 19.572 100 41 82 1 2018191680 12190352 12468704
22:08:28 40903 8192000000 10923584944 11389726720 1974869824 19.424 99 36 72 0 1998989328 13929296 10190208
22:09:20 123633 8192000000 10913941856 11398422528 1896301072 18.797 95 14 28 0 1915755840 15735552 3719216
22:11:31 75541 8192000000 10920259200 11381252096 1957819024 19.289 98 26 52 2 1977138752 11997840 7321888
22:13:08 97410 8192000000 10919264816 11397881856 1977290560 19.443 99 27 54 2 1998941040 14512352 7138128
22:15:19 72844 8192000000 10936116144 11397251072 1981514528 19.477 99 34 67 0 1998730464 7977520 9238416
22:16:38 25122 8192000000 10936068208 11385311232 1990806016 19.550 100 53 106 0 2021661600 15253440 15602144
22:18:22 45590 8192000000 10892704960 11377684480 1951024288 19.235 98 11 21 0 1969641984 15189440 3428256
22:19:14 49931 8192000000 10901621696 11381518336 1961139632 19.315 99 10 20 1 1978273280 14351472 2782176
22:20:10 89601 8192000000 10905890480 11382050816 1965496640 19.350 99 9 18 0 1979939488 11764960 2677888
22:21:47 59415 8192000000 10917516384 11395239936 1995668800 19.589 100 24 48 1 2010722112 7993232 7060080
22:23:23 50296 8192000000 10910813952 11391631360 1979590464 19.461 100 8 16 0 1992956896 10930592 2435840
22:24:30 47373 8192000000 10915761760 11377836032 1950573536 19.231 98 11 22 2 1965579536 11869136 3136864
22:25:24 48337 8192000000 10891748064 11356958720 1866059536 18.552 94 21 42 1 1888004208 16260144 5684528
22:26:19 25585 8192000000 10868674144 11330920448 1848951952 18.414 94 23 46 0 1865041264 9667392 6421920
22:26:53 17340 8192000000 8994396208 9187356672 167971680 2.009 9 4 8 0 170822144 1832752 1017712

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 15-11-2020 22:28:22 to 15-11-2020 22:28:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 115 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-11-2020 22:28:54 to 15-11-2020 22:28:56.

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          233601
MON$OLDEST_ACTIVE               233602
MON$OLDEST_SNAPSHOT             233602
MON$NEXT_TRANSACTION            233602
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                       2008128
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
:136: 
:137: mscs-test-161.budzdorov.ru    Sun Nov 15 22:27:14 2020
:138:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:139: 
:140: 
:141: mscs-test-161.budzdorov.ru    Sun Nov 15 22:27:14 2020
:142:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:143: 
--- end of diff output ---

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

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