Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.11.2020 01:28
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 17565848 kB
MemAvailable 31451356 kB
Buffers 0 kB
Cached 14119348 kB
SwapCached 4280 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-18 01:27:03
DTS_END                         2020-11-18 01:27:03.8820
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/45894
TRN_ID                          234834
ATT_ID                          677
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: 9152.13 22525 1098255
customer order: creation 169.93 346 20392
customer order: refuse 14.52 328 1742
order to supplier: creation 45.11 1198 5413
order to supplier: removal 3.38 100034 406
invoice (draft): creation 45.98 3202 5517
invoice (draft): removal 53.28 800 6394
invoice accept: apply 41.63 16342 4995
invoice accept: cancel 47.68 739 5721
customer reserve: creation 3785.58 161 454269
customer reserve: removal 4645.58 57 557470
realization accept: apply 83.30 190 9996
realization accept: cancel 90.47 100 10856
payment from customer: creation 57.09 129 6851
payment from customer: removal 5.64 78 677
payment to supplier: creation 47.66 120 5719
payment to supplier: removal 3.08 54 369
service: total inventory turnovers 4.65 1369 558
service: total monetary turnovers 6.77 34 812
service: aggregate perf. data 0.78 22850 94
service: refresh index statistics 0.03 302367 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-11-2020 01:28:24 to 18-11-2020 01:28:26.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6143
TEST_TIME 2 5388
TEST_TIME 3 5495
TEST_TIME 4 5726
TEST_TIME 5 5737
TEST_TIME 6 5418
TEST_TIME 7 5697
TEST_TIME 8 5894
TEST_TIME 9 5984
TEST_TIME 10 6299
TEST_TIME 11 6672
TEST_TIME 12 6890
TEST_TIME 13 7004
TEST_TIME 14 7377
TEST_TIME 15 7896
TEST_TIME 16 8649
TEST_TIME 17 9010
TEST_TIME 18 8815
TEST_TIME 19 9492
TEST_TIME 20 9318
TEST_TIME 21 9297
TEST_TIME 22 9994
TEST_TIME 23 10069
TEST_TIME 24 10494
TEST_TIME 25 11112
TEST_TIME 26 11600
TEST_TIME 27 11298
TEST_TIME 28 11243
TEST_TIME 29 11097
TEST_TIME 30 10845
TEST_TIME 31 10781
TEST_TIME 32 10601
TEST_TIME 33 10459
TEST_TIME 34 10330
TEST_TIME 35 10278
TEST_TIME 36 10055
TEST_TIME 37 10167
TEST_TIME 38 10032
TEST_TIME 39 9846
TEST_TIME 40 9724
TEST_TIME 41 9688
TEST_TIME 42 9651
TEST_TIME 43 9656
TEST_TIME 44 9596
TEST_TIME 45 9403
TEST_TIME 46 9346
TEST_TIME 47 9307
TEST_TIME 48 9239
TEST_TIME 49 9280
TEST_TIME 50 9242
TEST_TIME 51 9333
TEST_TIME 52 9337
TEST_TIME 53 9377
TEST_TIME 54 9322
TEST_TIME 55 9359
TEST_TIME 56 9375
TEST_TIME 57 9429
TEST_TIME 58 9463
TEST_TIME 59 9513
TEST_TIME 60 9603
TEST_TIME 61 9668
TEST_TIME 62 9634
TEST_TIME 63 9488
TEST_TIME 64 9391
TEST_TIME 65 9437
TEST_TIME 66 9381
TEST_TIME 67 9325
TEST_TIME 68 9313
TEST_TIME 69 9301
TEST_TIME 70 9330
TEST_TIME 71 9379
TEST_TIME 72 9325
TEST_TIME 73 9373
TEST_TIME 74 9404
TEST_TIME 75 9402
TEST_TIME 76 9501
TEST_TIME 77 9481
TEST_TIME 78 9478
TEST_TIME 79 9491
TEST_TIME 80 9469
TEST_TIME 81 9456
TEST_TIME 82 9396
TEST_TIME 83 9354
TEST_TIME 84 9292
TEST_TIME 85 9278
TEST_TIME 86 9252
TEST_TIME 87 9225
TEST_TIME 88 9229
TEST_TIME 89 9196
TEST_TIME 90 9189
TEST_TIME 91 9249
TEST_TIME 92 9308
TEST_TIME 93 9285
TEST_TIME 94 9269
TEST_TIME 95 9288
TEST_TIME 96 9364
TEST_TIME 97 9364
TEST_TIME 98 9394
TEST_TIME 99 9388
TEST_TIME 100 9442
TEST_TIME 101 9478
TEST_TIME 102 9534
TEST_TIME 103 9507
TEST_TIME 104 9496
TEST_TIME 105 9428
TEST_TIME 106 9416
TEST_TIME 107 9355
TEST_TIME 108 9356
TEST_TIME 109 9377
TEST_TIME 110 9357
TEST_TIME 111 9319
TEST_TIME 112 9304
TEST_TIME 113 9284
TEST_TIME 114 9263
TEST_TIME 115 9246
TEST_TIME 116 9221
TEST_TIME 117 9226
TEST_TIME 118 9219
TEST_TIME 119 9232
TEST_TIME 120 9156

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-11-2020 01:28:28 to 18-11-2020 01:28:31.

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 1519699 1519699 0 0.00 0 34705 6 0 0
doc_list_biud 1519699 1519699 0 0.00 0 111095 27 0 0
sp_add_invoice_to_stock 5104 4995 109 2.13 39 182832 16342 0 109
sp_cancel_adding_invoice 5721 5721 0 0.00 5 74775 740 0 0
sp_cancel_client_order 1742 1742 0 0.00 5 13881 328 0 0
sp_cancel_customer_reserve 557470 557470 0 0.00 1 35794 57 0 0
sp_cancel_pay_from_customer 677 677 0 0.00 3 7855 78 0 0
sp_cancel_pay_to_supplier 369 369 0 0.00 2 1065 54 0 0
sp_cancel_supplier_invoice 6403 6394 9 0.14 2 111109 800 0 9
sp_cancel_supplier_order 406 406 0 0.00 5 1055174 100034 0 0
sp_cancel_write_off 10856 10856 0 0.00 1 12885 100 0 0
sp_client_order 20392 20392 0 0.00 3 62461 346 0 0
sp_customer_reserve 454269 454269 0 0.00 0 80334 162 0 0
sp_fill_shopping_cart 31322 31322 0 0.00 1 17820 40 0 0
sp_fill_shopping_cart_clo_res 454263 454263 0 0.00 0 16316 15 0 0
sp_get_clo_for_invoice 4978 4978 0 0.00 0 31680 349 0 0
sp_kill_cost_storno 17623 17623 0 0.00 0 9955 54 0 0
sp_kill_qstorno_ret_qs2qd 1132596 1132596 0 0.00 0 111089 31 0 0
sp_kill_qty_storno 597557 597557 0 0.00 0 111093 67 0 0
sp_lock_selected_doc 20636 20636 0 0.00 0 8252 6 0 0
sp_make_cost_storno 27538 27538 0 0.00 0 14983 61 0 0
sp_multiply_rows_for_pdistr 27538 27538 0 0.00 0 8263 25 0 0
sp_multiply_rows_for_qdistr 20392 20392 0 0.00 0 62451 164 0 0
sp_pay_from_customer 6851 6851 0 0.00 4 23590 130 0 0
sp_pay_to_supplier 5719 5719 0 0.00 4 18553 121 0 0
sp_payment_common 12570 12570 0 0.00 1 23586 46 0 0
sp_qd_handle_on_cancel_clo 1742 1742 0 0.00 0 13876 297 0 0
sp_qd_handle_on_invoice_upd_sts 10693 10693 0 0.00 0 27341 304 0 0
sp_qd_handle_on_reserve_upd_sts 9996 9996 0 0.00 0 23996 66 0 0
sp_reserve_write_off 9996 9996 0 0.00 6 24023 191 0 0
sp_supplier_invoice 5517 5517 0 0.00 7 102222 3203 0 0
sp_supplier_order 5413 5413 0 0.00 5 88819 1199 0 0
srv_aggregate_perf_data 95 94 1 1.05 2851 382424 22850 0 1
srv_fill_mon_cache_memory 152 152 0 0.00 1096 194518 35650 0 0
srv_find_qd_qs_mism 1051823 1051823 0 0.00 0 34704 4 0 0
srv_make_invnt_saldo 558 558 0 0.00 27 180087 1370 0 0
srv_make_money_saldo 812 812 0 0.00 1 7028 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 249294 367900 302367 0 0
t$perf-abend:sp_add_invoice_to_stock 109 109 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4995 4995 0 0.00 0 21678 161 0 0
t$perf-norm:sp_cancel_adding_invoice 426 426 0 0.00 1 5116 110 0 0
t$perf-norm:sp_cancel_client_order 1742 1742 0 0.00 0 4615 16 0 0
t$perf-norm:sp_cancel_customer_reserve 661 661 0 0.00 0 1188 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 677 677 0 0.00 0 257 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 369 369 0 0.00 0 1918 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 415 415 0 0.00 0 15281 47 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 18912 1516 0 0
t$perf-norm:sp_cancel_write_off 974 974 0 0.00 0 1718 8 0 0
t$perf-norm:sp_client_order 20392 20392 0 0.00 0 6644 15 0 0
t$perf-norm:sp_customer_reserve 994 994 0 0.00 0 4287 9 0 0
t$perf-norm:sp_pay_from_customer 6851 6851 0 0.00 0 7451 13 0 0
t$perf-norm:sp_pay_to_supplier 5719 5719 0 0.00 0 5010 13 0 0
t$perf-norm:sp_reserve_write_off 9996 9996 0 0.00 0 6276 12 0 0
t$perf-norm:sp_supplier_invoice 5517 5517 0 0.00 0 10513 16 0 0
t$perf-norm:sp_supplier_order 5413 5413 0 0.00 0 6267 13 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 90 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 905 9 0 0
t$perf-norm:srv_make_invnt_saldo 558 558 0 0.00 0 2518 29 0 0
t$perf-norm:srv_make_money_saldo 812 812 0 0.00 0 1701 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 3 0 0
v_add_invoice_to_stock 10158 9940 218 2.14 0 4747 17 0 218
v_all_customers 36946 36946 0 0.00 0 16 1 0 0
v_all_suppliers 30448 30448 0 0.00 0 24 1 0 0
v_all_wares 40784 40784 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 852 852 0 0.00 0 1192 8 0 0
v_cancel_client_order 3484 3484 0 0.00 0 1576 5 0 0
v_cancel_customer_prepayment 1354 1354 0 0.00 0 3052 7 0 0
v_cancel_customer_reserve 1322 1322 0 0.00 0 385 3 0 0
v_cancel_payment_to_supplier 738 738 0 0.00 0 316 3 0 0
v_cancel_supplier_invoice 848 830 18 2.12 0 1896 23 0 18
v_cancel_supplier_order 812 812 0 0.00 0 3214 14 0 0
v_cancel_write_off 1948 1948 0 0.00 0 1807 13 0 0
v_max_id_clo_ord 5413 5413 0 0.00 0 228 1 0 0
v_max_id_clo_res 994 994 0 0.00 0 2325 16 0 0
v_max_id_ord_sup 5517 5517 0 0.00 0 6941 5 0 0
v_max_non_paid_invoice 1425 1425 0 0.00 0 259 2 0 0
v_max_non_paid_realizn 3701 3701 0 0.00 0 5291 9 0 0
v_min_id_clo_ord 5413 5413 0 0.00 0 2289 6 0 0
v_min_id_clo_res 994 994 0 0.00 0 4411 15 0 0
v_min_id_ord_sup 5517 5517 0 0.00 0 7765 7 0 0
v_min_non_paid_invoice 5719 5719 0 0.00 0 8143 23 0 0
v_min_non_paid_realizn 6851 6851 0 0.00 0 16124 31 0 0
v_our_firm 10138 10138 0 0.00 0 13 1 0 0
v_reserve_write_off 19992 19992 0 0.00 0 4652 5 0 0
x_lock_depdocs_on_canc_invoice 11700 11700 0 0.00 0 15285 116 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 13874 333 0 0
x_make_qstorno_1000_1200 5413 5413 0 0.00 1 88775 1126 0 0
x_make_qstorno_1200_2000 5517 5517 0 0.00 3 96234 3054 0 0
x_make_qstorno_2100_3300 454269 454269 0 0.00 0 80327 145 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-11-2020 01:28:32 to 18-11-2020 01:28:36.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:07 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:13 11086 8192000000 10224272304 10525474816 892664240 9.826 71 61 122 0 915565472 2538640 20362592
22:57:34 26712 8192000000 10335692048 10650906624 1378514096 14.403 100 80 160 0 1408789776 4463072 25812608
22:58:16 19873 8192000000 10369313920 10687864832 1423260112 14.802 100 93 186 0 1460086064 6189312 30636640
22:58:45 17921 8192000000 10387033488 10711982080 1443693424 14.982 100 88 177 1 1478754704 6792032 28269248
22:59:20 22011 8192000000 10411611568 10740305920 1466727024 15.185 100 80 160 1 1499982688 7301072 25954592
22:59:50 21715 8192000000 10435418272 10764648448 1485996880 15.354 100 85 167 2 1520260592 7684192 26579520
23:00:28 14860 8192000000 10465267184 10797608960 1515659440 15.613 100 89 178 0 1552281600 8508672 28113488
23:00:54 17164 8192000000 10478193568 10818768896 1527849632 15.718 100 81 162 0 1561930048 8570176 25510240
23:01:23 17444 8192000000 10493330016 10839019520 1547172144 15.886 100 76 152 0 1579898368 9163200 23563024
23:01:49 23601 8192000000 10524454032 10881204224 1583319200 16.197 100 77 154 0 1615650080 9256688 23074192
23:02:25 15953 8192000000 10552060192 10908995584 1608522976 16.412 100 73 146 1 1640497968 9928144 22046848
23:02:52 12818 8192000000 10573306448 10933186560 1627768800 16.576 100 79 158 0 1662522784 11060736 23693248
23:03:14 11685 8192000000 10588951584 10951405568 1647381792 16.742 100 77 154 0 1680902080 10972576 22547712
23:03:35 11330 8192000000 10616992224 10981683200 1672282560 16.952 100 77 154 1 1706527376 11801200 22443616
23:03:55 9473 8192000000 10615734912 10988331008 1688733696 17.091 100 84 167 0 1725092896 12275776 24083424
23:04:15 7998 8192000000 10641941216 11013857280 1705795808 17.234 100 72 142 1 1738014512 12013136 20205568
23:04:34 6804 8192000000 10662436736 11035439104 1724198720 17.387 100 81 164 0 1760375712 13093360 23083632
23:04:50 6845 8192000000 10679619568 11055484928 1740259360 17.521 100 85 171 0 1777277312 12733984 24283968
23:05:05 5270 8192000000 10695420480 11069956096 1752948448 17.626 100 83 166 1 1789220576 13095968 23176160
23:05:18 4947 8192000000 10703766992 11081211904 1759924400 17.684 100 83 164 1 1797203872 13413920 23865552
23:05:29 4692 8192000000 10714002480 11089907712 1769707488 17.765 100 83 166 3 1807143856 13806096 23630272
23:05:40 5211 8192000000 10722457072 11104825344 1782449104 17.870 100 82 162 0 1818763840 13286848 23027888
23:05:53 3714 8192000000 10728949456 11111424000 1793079136 17.957 100 81 162 2 1829882640 13814512 22988992
23:06:03 3116 8192000000 10744361440 11128573952 1804353696 18.050 100 94 184 3 1843304960 12744192 26207072
23:06:13 3679 8192000000 10747357952 11133239296 1813005952 18.120 100 76 152 1 1846819344 11824224 21989168
23:06:25 3098 8192000000 10753122848 11139497984 1819785312 18.176 100 86 173 1 1855966304 12070464 24110528
23:06:35 5676 8192000000 10760778624 11147395072 1819055056 18.170 100 80 161 1 1854472864 12844144 22573664
23:06:48 4428 8192000000 10764898112 11153088512 1827907888 18.242 100 86 173 2 1865151024 13369584 23873552
23:06:59 2716 8192000000 10785572384 11171700736 1841392176 18.352 100 90 180 0 1879759776 13502624 24864976
23:07:08 2563 8192000000 10792281280 11176189952 1843047456 18.366 100 94 189 0 1884265984 15064624 26153904
23:07:18 2286 8192000000 10785631744 11176914944 1848730496 18.412 100 82 164 1 1886597936 15424432 22443008
23:07:26 1484 8192000000 10799485008 11188764672 1854680560 18.460 100 91 181 0 1893828704 14203168 24944976
23:07:35 2124 8192000000 10802174448 11194232832 1861867904 18.518 100 88 176 1 1901803408 14515072 25420432
23:07:43 2270 8192000000 10808441760 11202416640 1862582304 18.524 100 89 175 1 1904520304 17653056 24284944
23:07:52 1710 8192000000 10810494144 11199389696 1869897152 18.583 100 94 187 0 1909827664 14510624 25419888
23:08:00 2446 8192000000 10811520928 11202625536 1873734288 18.614 100 92 185 2 1912115744 12940416 25441040
23:08:09 2595 8192000000 10824418736 11215527936 1878711584 18.655 100 87 174 1 1917945840 13516720 25717536
23:08:19 3776 8192000000 10820227776 11212263424 1880954480 18.673 100 84 168 1 1918956704 13990704 24011520
23:08:29 2642 8192000000 10825729712 11216232448 1880036576 18.665 100 90 179 1 1919294896 13693696 25564624
23:08:37 2181 8192000000 10826720608 11218145280 1883308528 18.692 100 90 180 0 1923146608 14608000 25230080
23:08:46 993 8192000000 10828377120 11225358336 1889452800 18.741 100 93 185 0 1928590000 13256512 25880688
23:08:53 28661 8192000000 10815989472 11220180992 1881935872 18.681 100 64 128 1 1910437216 9039584 19461760
23:09:29 10580 8192000000 10819175712 11226677248 1885722624 18.711 100 61 123 5 1910191168 7180448 17288096
23:09:46 2883 8192000000 10810651056 11226198016 1887007888 18.722 100 59 118 0 1914789792 10752064 17029840
23:09:58 5782 8192000000 10812322976 11229085696 1887106304 18.722 100 35 68 0 1905310992 9159024 9045664
23:10:11 3753 8192000000 10798918640 11227549696 1886843584 18.720 100 36 73 0 1904798416 7933504 10021328
23:10:23 5293 8192000000 10797302800 11222994944 1887130448 18.723 100 35 70 1 1904579472 7362496 10086528
23:10:35 6283 8192000000 10817022288 11228725248 1893029232 18.770 100 40 80 1 1910848960 6843424 10976304
23:10:54 5047 8192000000 10815283184 11234672640 1894651920 18.783 100 35 68 3 1912744784 7891488 10201376
23:11:07 4531 8192000000 10812402976 11239010304 1894631088 18.783 100 27 54 2 1909548720 7575120 7342512
23:11:18 8409 8192000000 10810746720 11241222144 1898018368 18.810 100 25 49 2 1911638544 7105248 6514928
23:11:33 13424 8192000000 10802828672 11237208064 1899737936 18.824 100 32 60 2 1916199264 6269888 10191440
23:11:53 71355 8192000000 10813558704 11252969472 1905198048 18.868 100 38 76 1 1922576144 6079776 11298320
23:13:11 12924 8192000000 10820560944 11255173120 1906558912 18.879 100 29 58 0 1921913392 6313808 9040672
23:13:33 6601 8192000000 10826421936 11258257408 1908262272 18.893 100 31 60 2 1924493872 7650288 8581312
23:13:49 5644 8192000000 10830682864 11259408384 1909903776 18.906 100 40 78 1 1928207616 6926736 11377104
23:14:03 5230 8192000000 10815931616 11257352192 1907957776 18.890 100 30 58 2 1923032720 6302784 8772160
23:14:16 6306 8192000000 10824721712 11255226368 1907833712 18.889 100 27 54 2 1922134928 5825888 8475328
23:14:28 6299 8192000000 10824697424 11259813888 1909603664 18.903 100 19 38 1 1921353888 6177568 5572656
23:14:42 5922 8192000000 10817977328 11252719616 1889361168 18.741 99 20 39 2 1900890688 6443840 5085680
23:14:55 8831 8192000000 10822787184 11254337536 1907796864 18.889 100 25 46 2 1921265104 5693728 7774512
23:15:15 9442 8192000000 10826402992 11260502016 1910762544 18.913 100 24 48 1 1923514448 6168512 6583392
23:15:32 8856 8192000000 10806344416 11236048896 1835498096 18.304 96 18 36 1 1846133392 5218256 5417040
23:15:50 8488 8192000000 10797771632 11237265408 1894412912 18.781 100 29 58 1 1908502912 5682080 8407920
23:16:08 13066 8192000000 10816140800 11248250880 1899526736 18.822 100 14 28 1 1909710352 5722592 4461024
23:16:28 10192 8192000000 10827935408 11253252096 1905532128 18.871 100 40 79 2 1926366016 9987216 10846672
23:16:48 73105 8192000000 10796827488 11234447360 1831901632 18.275 96 17 32 3 1841489264 4665504 4922128
23:18:09 10631 8192000000 10803525120 11235889152 1867764496 18.566 99 22 44 5 1879550480 5783248 6002736
23:18:27 8526 8192000000 10794368160 11229093888 1854136544 18.456 98 32 64 1 1870342096 6996688 9208864
23:18:42 7467 8192000000 10771508400 11194662912 1814378176 18.132 97 46 90 3 1835511728 8013440 13120112
23:18:56 3308 8192000000 10792568640 11209211904 1842444816 18.361 98 52 103 1 1864834064 7398640 14990608
23:19:06 8257 8192000000 10743502192 11167412224 1761225040 17.695 94 19 38 1 1771434928 4554960 5654928
23:19:21 3351 8192000000 10671640400 11079356416 1686577600 17.073 92 35 72 3 1701371216 5038576 9755040
23:19:33 7955 8192000000 10715124720 11137888256 1746916864 17.576 96 21 42 2 1758548400 5450304 6181232
23:19:48 5882 8192000000 10696501424 11108347904 1776292496 17.819 98 26 54 2 1789303536 5474000 7537040
23:20:06 8593 8192000000 10718081440 11137826816 1778741248 17.839 98 24 47 2 1791288368 5617648 6929472
23:20:21 7329 8192000000 10690684256 11109130240 1718216192 17.337 95 20 40 0 1729659024 5592624 5850208
23:20:36 4987 8192000000 10707772400 11116584960 1757594656 17.664 98 47 91 0 1778769632 6995856 14179120
23:20:48 7752 8192000000 10703039968 11114602496 1741427488 17.530 97 31 61 2 1755144832 4803360 8913984
23:21:04 55711 8192000000 10702192992 11111981056 1681032096 17.026 93 30 60 1 1694653520 4311248 9310176
23:22:06 14679 8192000000 10710119536 11132506112 1784164192 17.884 99 32 62 1 1799937408 7369984 8403232
23:22:27 11172 8192000000 10718453280 11144757248 1784712656 17.888 99 25 50 1 1797843920 5605776 7525488
23:22:45 6142 8192000000 10741484688 11155607552 1807066800 18.072 99 32 62 3 1822534464 5979520 9488144
23:22:58 9691 8192000000 10757931280 11177517056 1834006352 18.292 100 26 52 1 1849211504 6424128 8781024
23:23:18 4033 8192000000 10769775136 11185160192 1847749968 18.404 100 41 74 4 1866439968 6427264 12262736
23:23:29 7558 8192000000 10755253392 11179704320 1828964176 18.251 99 29 55 2 1843202672 5394640 8843856
23:23:42 12289 8192000000 10767453648 11186569216 1845724416 18.387 100 19 38 1 1856575824 5284912 5566496
23:24:03 9167 8192000000 10774716160 11199766528 1854224304 18.456 100 18 36 1 1865941856 5577152 6140400
23:24:18 9693 8192000000 10764232560 11197214720 1857028912 18.479 100 15 30 0 1867006528 4950048 5027568
23:24:36 9899 8192000000 10778989920 11205709824 1859532400 18.499 100 14 27 1 1872306848 9230736 3543712
23:24:55 8755 8192000000 10767473696 11202252800 1859766704 18.501 100 11 22 0 1868371936 5500816 3104416
23:25:10 14595 8192000000 10774426464 11206553600 1846139264 18.391 99 15 30 0 1855318176 4863504 4315408
23:25:31 6580 8192000000 10781592384 11210887168 1867522752 18.564 100 22 44 1 1880070208 5780208 6767248
23:25:46 13978 8192000000 10779232512 11207806976 1868899584 18.575 100 20 41 3 1879527120 5442128 5185408
23:26:07 68514 8192000000 10818997280 11234811904 1880432944 18.669 100 37 74 1 1895978496 5352784 10192768
23:27:23 41329 8192000000 10835031904 11253059584 1897659936 18.807 100 56 108 2 1922524224 9075472 15788816
23:28:13 20844 8192000000 10858678192 11275501568 1915497520 18.951 100 57 114 0 1948398048 16981040 15919488
23:28:41 24612 8192000000 10857170304 11283734528 1925291232 19.029 100 59 118 1 1955630288 13808144 16530912
23:29:25 31555 8192000000 10872382544 11298463744 1934861008 19.106 100 40 78 1 1962138448 15497536 11779904
23:30:04 18539 8192000000 10884489200 11312046080 1944876272 19.186 100 42 83 2 1972207248 15516640 11814336
23:30:36 25659 8192000000 10901355152 11333505024 1958251456 19.292 100 48 94 2 1988817936 17314448 13252032
23:31:09 49028 8192000000 10904777360 11346997248 1964213104 19.340 100 42 84 1 1996197264 19567792 12416368
23:32:08 22814 8192000000 10902434288 11345051648 1970051696 19.386 100 32 64 2 1999705424 19832800 9820928
23:32:46 16356 8192000000 10915347088 11353878528 1975298704 19.427 100 43 86 2 2006422176 18389776 12733696
23:33:16 4261 8192000000 10926687536 11358609408 1979723776 19.463 100 49 98 1 2014385808 20455072 14206960
23:33:29 15821 8192000000 10935106560 11362672640 1982291552 19.483 100 51 102 0 2019006512 21715248 14999712
23:33:54 5578 8192000000 10937377696 11367575552 1987570656 19.525 100 61 121 2 2028045920 22716304 17758960
23:34:08 12651 8192000000 10938444736 11364245504 1983877984 19.495 100 64 128 2 2026981552 23320112 19783456
23:34:29 7879 8192000000 10933148816 11363598336 1982034624 19.481 100 52 103 0 2019969200 22616064 15318512
23:34:57 19597 8192000000 10933735472 11369680896 1986166896 19.513 100 43 85 0 2024787952 25258864 13362192
23:35:24 11838 8192000000 10922324608 11351146496 1972958720 19.409 99 41 82 0 2009388240 23910896 12518624
23:35:45 8359 8192000000 10944071456 11374546944 1992479008 19.563 100 57 114 1 2033643248 24370208 16794032
23:36:01 4399 8192000000 10942661120 11367620608 1975561744 19.430 99 58 117 1 2018122832 25388512 17172576
23:36:13 10638 8192000000 10951275232 11377709056 1996065232 19.592 100 74 147 4 2043252224 25636112 21550880
23:36:32 5166 8192000000 10962963968 11386294272 2002288752 19.641 100 65 128 2 2050502320 29057824 19155744
23:36:47 2112 8192000000 10969911424 11395661824 2005857952 19.669 100 66 131 0 2055763728 30153424 19752352
23:36:57 10481 8192000000 10974539456 11403984896 2011945776 19.717 100 67 134 1 2061587664 30253504 19388384
23:37:15 3548 8192000000 10973264880 11402186752 2012581744 19.722 100 63 126 1 2061433200 30219872 18631584
23:37:25 1944 8192000000 10990918816 11405144064 2016748064 19.755 100 86 167 2 2071596944 30345248 24503632
23:37:34 6181 8192000000 10996180208 11409174528 2019414352 19.776 100 86 171 0 2076484032 33078784 23990896
23:37:52 7677 8192000000 10988465456 11414839296 2021005984 19.788 100 77 153 3 2078594864 34775952 22812928
23:38:07 3116 8192000000 10996971408 11421106176 2024474448 19.815 100 75 150 1 2080815984 33425344 22916192
23:38:17 2909 8192000000 10986855888 11410026496 2017838016 19.763 100 77 154 1 2074142704 33665232 22639456
23:38:28 3343 8192000000 10975493216 11405094912 2009921856 19.701 100 68 137 0 2064461952 33873232 20666864
23:38:40 6310 8192000000 10971881616 11399102464 2004654784 19.659 100 63 126 0 2058319616 34002240 19662592
23:38:54 2507 8192000000 10990667792 11417567232 2021535760 19.792 100 75 150 0 2080435200 35586064 23313376
23:39:04 3487 8192000000 11007642096 11425214464 2026636272 19.832 100 78 156 0 2083637680 33954416 23046992
23:39:15 3248 8192000000 10995487456 11419279360 2012797952 19.724 99 82 164 0 2069762448 32711664 24252832
23:39:27 2801 8192000000 10984421440 11411820544 2005394880 19.665 99 74 147 0 2062953360 35652704 21905776
23:39:41 4592 8192000000 11000984480 11425771520 2021473984 19.792 100 78 156 2 2081928464 36527968 23926512
23:39:52 3248 8192000000 11003874320 11428192256 2026388768 19.830 100 86 171 0 2090046048 37036992 26620288
23:40:03 2611 8192000000 11001673408 11422986240 2018894928 19.771 100 79 156 0 2081380384 37899968 24585488
23:40:14 6954 8192000000 10991067072 11424210944 2020097760 19.781 100 59 118 1 2075540800 37341040 18102000
23:40:27 7643 8192000000 10992864240 11420155904 2004924000 19.662 99 65 129 0 2064002816 37952672 21126144
23:40:42 7067 8192000000 11000909088 11426832384 2020933920 19.787 100 84 167 4 2087513872 40957952 25622000
23:40:55 2782 8192000000 11011945120 11433865216 2027065008 19.836 100 89 177 0 2097675008 43276304 27333696
23:41:08 3507 8192000000 11022863856 11445501952 2032737808 19.880 100 84 165 1 2100372336 42200336 25434192
23:41:18 4735 8192000000 11000425760 11420725248 2014384592 19.736 99 80 159 3 2078183424 39897472 23901360
23:41:30 8897 8192000000 11012172608 11445104640 2029189584 19.852 100 71 141 1 2091147296 40017376 21940336
23:41:47 3361 8192000000 11005350128 11432488960 2026608848 19.832 100 83 165 3 2094306400 41474352 26223200
23:41:57 2861 8192000000 11019936512 11441397760 2030759808 19.865 100 79 158 0 2098467712 42844288 24863616
23:42:07 3805 8192000000 11019554160 11449294848 2036716176 19.911 100 79 158 3 2106211200 44646944 24848080
23:42:19 2524 8192000000 11024205920 11447439360 2035138624 19.899 100 76 152 3 2102507584 43413264 23955696
23:42:29 2239 8192000000 11035492640 11460071424 2044495424 19.972 100 85 165 2 2116651584 45672512 26483648
23:42:41 2569 8192000000 11037860464 11463737344 2045476592 19.980 100 81 162 0 2115581808 45200272 24904944
23:42:51 2298 8192000000 11034932560 11460374528 2044926896 19.975 100 74 148 2 2113585472 45095568 23563008
23:43:00 2256 8192000000 11008982736 11430420480 2019407824 19.775 100 80 159 0 2090586032 45545872 25632336
23:43:11 3054 8192000000 11013119888 11439579136 2021474816 19.792 100 75 149 2 2091812832 46914704 23423312
23:43:24 3991 8192000000 10993568768 11428929536 2012305616 19.720 100 72 144 2 2084366432 48948576 23112240
23:43:37 8681 8192000000 10978224064 11423473664 2006616880 19.675 100 55 109 1 2070116096 45674112 17825104
23:43:59 9612 8192000000 10961985008 11400847360 1958466912 19.294 98 48 96 3 2013305744 38845488 15993344
23:44:17 12940 8192000000 10977111024 11406430208 1996436944 19.595 100 60 119 3 2053626480 38705840 18483696
23:44:38 1095 8192000000 10975285040 11398291456 1988105632 19.529 100 72 144 2 2051382368 40028448 23248288
23:44:51 2985 8192000000 10969050528 11393347584 1995925472 19.591 100 72 142 2 2051395552 33293280 22176800
23:45:01 3739 8192000000 10957724576 11380736000 1979627552 19.462 100 62 124 4 2032686288 33699920 19358816
23:45:12 2166 8192000000 10955778048 11377778688 1963906624 19.337 99 66 133 2 2020887456 35959792 21021040
23:45:23 6926 8192000000 10970867264 11394072576 1988653904 19.533 100 68 137 0 2052109360 41521888 21933568
23:45:37 2492 8192000000 10985463632 11401908224 1999862752 19.622 100 86 170 1 2065857584 38267552 27727280
23:45:46 4991 8192000000 10992500672 11414392832 2006881344 19.677 100 78 156 1 2072744272 41303952 24558976
23:45:58 6761 8192000000 10991127248 11421200384 2007590640 19.683 100 66 132 1 2075337840 46269584 21477616
23:46:17 8742 8192000000 10974165824 11417612288 2003711472 19.652 100 40 80 2 2057396608 40484144 13200992
23:46:41 18319 8192000000 10963577616 11409711104 1984195264 19.498 99 39 76 2 2036460240 38767648 13497328
23:47:13 17260 8192000000 10967100512 11419090944 2006535200 19.674 100 37 73 3 2055035744 36577536 11923008
23:47:36 18541 8192000000 10928958208 11372085248 1921486144 18.999 96 32 63 0 1970162064 37789984 10885936
23:48:04 9350 8192000000 10932561696 11372105728 1950742048 19.232 99 37 74 2 2003563984 39573264 13248672
23:48:47 10978 8192000000 10926138816 11364810752 1948286784 19.213 99 43 86 2 2009532144 46809072 14436288
23:49:08 26889 8192000000 10894910368 11348856832 1914456224 18.942 98 29 58 3 1969680208 45003248 10220736
23:50:05 17866 8192000000 10895060160 11344338944 1929912608 19.066 99 27 54 0 1975683840 36474928 9296304
23:50:30 40405 8192000000 10886521344 11348553728 1903463488 18.854 98 18 36 0 1948917392 39270848 6183056
23:51:21 13428 8192000000 10900688544 11360759808 1936483584 19.119 100 16 32 2 1980897568 38621936 5792048
23:51:42 30455 8192000000 10893816096 11351719936 1917080256 18.963 99 18 36 1 1961037904 37829216 6128432
23:52:27 56635 8192000000 10851117696 11337216000 1872640736 18.606 97 11 22 0 1908410096 31807360 3962000
23:53:29 68164 8192000000 10852105120 11300917248 1813915824 18.128 94 11 19 1 1829486816 12843888 2727104
23:54:56 28228 8192000000 10819010272 11272327168 1858935488 18.495 98 19 38 0 1877782304 13485904 5360912
23:55:35 61201 8192000000 10842718816 11291455488 1891586496 18.759 99 17 34 2 1901870912 6127760 4156656
23:56:43 72575 8192000000 10836204288 11291209728 1854650400 18.460 97 11 22 0 1869284992 11864000 2770592
23:58:05 87689 8192000000 10826432880 11268714496 1833631104 18.289 95 23 46 0 1849693680 9590912 6471664
23:59:47 77410 8192000000 10858481728 11316514816 1921526416 18.999 100 16 32 0 1933855472 7748176 4580880
00:02:00 74177 8192000000 10856994912 11318800384 1909889552 18.906 99 19 39 2 1924111632 7901312 6320768
00:03:52 133982 8192000000 10831650064 11308363776 1861034064 18.512 96 14 28 1 1875929696 11096768 3798864
00:06:13 30531 8192000000 10865088576 11322949632 1935280752 19.109 100 31 60 3 1954132960 10698464 8153744
00:06:50 15821 8192000000 10880668928 11327135744 1948680704 19.216 100 53 107 1 1973483616 9445136 15357776
00:07:14 28323 8192000000 10873652160 11330314240 1949735872 19.224 100 32 65 2 1968617344 9923472 8958000
00:07:57 19449 8192000000 10875136624 11332644864 1931406160 19.078 99 27 53 2 1952327824 13422480 7499184
00:08:37 44801 8192000000 10871300816 11339915264 1956393104 19.277 100 23 46 2 1973934624 10635520 6906000
00:09:29 72415 8192000000 10875861264 11349450752 1958472736 19.294 100 15 30 1 1972454800 9698256 4283808
00:10:48 75773 8192000000 10887042768 11358871552 1943697760 19.176 99 11 22 1 1958925968 12178464 3049744
00:12:13 52934 8192000000 10875529152 11352047616 1942586160 19.167 99 9 18 0 1963022416 17747616 2688640
00:13:12 60136 8192000000 10852486720 11337121792 1914717296 18.944 98 11 22 0 1939703024 21611856 3373872
00:14:22 7651 8192000000 10852577360 11338772480 1941717040 19.160 100 6 12 0 1953796160 10561248 1517872
00:14:36 1601 8192000000 10857125680 11344224256 1942348608 19.165 100 5 10 0 1956325552 13012496 964448
00:14:48 18422 8192000000 10857475824 11334172672 1936842528 19.122 100 7 12 0 1947870688 9060064 1968096
00:15:23 28461 8192000000 10879474672 11342602240 1957074208 19.283 100 17 34 1 1971067136 9294784 4698144
00:16:09 94150 8192000000 10891832160 11360882688 1956316576 19.277 99 15 30 2 1974932256 13897888 4717792
00:17:49 77013 8192000000 10902216800 11373928448 1974376496 19.420 100 28 57 2 1994614752 11886032 8352224
00:19:20 55060 8192000000 10893184608 11357483008 1918976992 18.979 97 15 31 1 1935989248 13047968 3964288
00:20:23 35802 8192000000 10905334336 11378765824 1973018704 19.409 100 20 40 0 1993356480 14279824 6057952
00:21:33 69347 8192000000 10900497456 11373416448 1955477968 19.270 99 22 44 0 1977459904 15783472 6198464
00:22:48 78163 8192000000 10892092096 11372986368 1955016560 19.266 99 10 20 0 1972605600 14568704 3020336
00:24:14 51888 8192000000 10902703504 11355463680 1887256736 18.724 96 18 36 0 1905687120 13462528 4967856
00:25:18 30094 8192000000 10914591440 11376766976 1976199856 19.435 100 40 80 0 2005844784 18132272 11512656
00:25:56 136819 8192000000 10896240944 11369009152 1911665632 18.920 97 14 28 1 1930481840 15383952 3432256
00:28:20 194518 8192000000 10881772688 11336916992 1858084624 18.488 94 15 28 2 1876984992 14458416 4441952
00:31:46 52014 8192000000 10871314208 11352666112 1923862912 19.018 98 11 22 0 1940404448 13272736 3268800
00:34:26 61557 8192000000 10871235424 11340218368 1923410560 19.014 98 17 32 2 1937883088 9524480 4948048
00:35:40 68540 8192000000 10890258656 11355340800 1908020544 18.891 97 21 43 0 1924834576 10717456 6096576
00:36:55 31169 8192000000 10863019776 11326664704 1895296544 18.788 97 26 52 1 1921105040 18024368 7784128
00:37:46 103543 8192000000 10851315808 11314298880 1876184464 18.634 97 10 20 0 1891622384 12652032 2785888
00:39:37 35990 8192000000 10892428416 11342422016 1947740944 19.208 100 24 48 0 1963679344 8859152 7079248
00:40:20 50258 8192000000 10843122832 11306532864 1836928832 18.316 94 42 81 2 1861253424 11902240 12422352
00:41:21 67384 8192000000 10861009264 11327430656 1880263184 18.667 98 16 33 0 1900835280 15798016 4774080
00:42:35 87639 8192000000 10853451808 11314802688 1854457488 18.458 96 14 28 0 1875347472 16858512 4031472
00:44:10 81473 8192000000 10847179328 11306106880 1811571536 18.109 94 10 20 2 1825806544 11411936 2823072
00:45:38 37682 8192000000 10855905936 11297689600 1907421824 18.886 99 26 52 1 1927908128 13294752 7191552
00:46:23 59977 8192000000 10848141664 11304669184 1848376128 18.409 96 26 52 1 1866869184 11529088 6963968
00:47:30 51470 8192000000 10867247872 11303792640 1850014528 18.422 96 20 39 0 1868025312 12592592 5418192
00:48:27 152927 8192000000 10856827584 11314610176 1884136176 18.698 98 28 56 4 1900003536 8066512 7800848
00:51:32 21087 8192000000 10870090432 11324112896 1937168832 19.124 100 36 72 0 1959249792 11971840 10109120
00:52:53 65203 8192000000 10836271104 11309543424 1876996848 18.641 97 11 23 0 1895329424 15310464 3022112
00:54:06 39580 8192000000 10846158880 11319078912 1923607312 19.016 100 12 24 1 1937771264 10823456 3340496
00:54:52 38511 8192000000 10847569264 11319193600 1894101344 18.779 98 18 36 1 1913149936 13409136 5639456
00:55:37 85590 8192000000 10842891792 11311288320 1859726192 18.501 96 12 24 0 1874004736 10351232 3927312
00:57:26 83084 8192000000 10833949552 11308539904 1857856576 18.486 96 17 34 1 1875906208 13058400 4991232
00:58:55 47846 8192000000 10855838896 11317022720 1909244528 18.901 99 15 30 2 1929463888 15796368 4422992
00:59:49 52998 8192000000 10870538080 11334508544 1943635648 19.176 100 17 34 0 1957491184 9911824 3943712
01:00:55 78762 8192000000 10904225712 11376095232 1969610640 19.382 100 23 47 1 1989717664 14072992 6034032
01:02:20 59597 8192000000 10918230624 11388928000 1964051520 19.338 99 18 34 1 1985864640 16385088 5428032
01:03:28 60242 8192000000 10932638192 11383926784 1980661456 19.470 100 37 73 3 2002258544 10687888 10909200
01:04:40 35268 8192000000 10912129440 11379159040 1964384208 19.341 99 22 44 0 1978024848 7491728 6148912
01:05:22 56172 8192000000 10922038000 11391754240 1970064784 19.386 99 22 44 1 1991303984 14877856 6361344
01:06:25 69715 8192000000 10915582912 11380350976 1971283760 19.396 99 19 37 2 1988732240 12395872 5052608
01:07:42 28375 8192000000 10928735520 11388063744 1956564384 19.279 98 34 68 0 1977192064 11093472 9534208
01:08:18 46635 8192000000 10906834848 11393683456 1968491776 19.373 99 23 45 2 1991724848 16517712 6715360
01:09:18 130867 8192000000 10926441792 11397378048 1967842896 19.368 99 6 12 1 1982584592 13276192 1465504
01:11:54 147100 8192000000 10912119616 11371978752 1915316624 18.949 96 32 64 1 1936957824 13306384 8334816
01:14:28 39352 8192000000 10916994816 11384492032 1986601568 19.517 100 23 46 0 2007134480 14180960 6351952
01:15:14 21058 8192000000 10908475440 11386499072 1988281056 19.530 100 17 33 3 2007690096 14350800 5058240
01:15:46 33974 8192000000 10914128336 11404906496 1986767664 19.518 100 11 23 0 2006314336 15745040 3801632
01:17:50 33987 8192000000 10874971856 11348361216 1884807120 18.704 95 14 28 2 1897583504 8670976 4105408
01:19:04 75757 8192000000 10880632912 11353825280 1943057600 19.171 99 10 20 1 1955395616 9404912 2933104
01:20:37 74680 8192000000 10869377360 11348770816 1893241264 18.772 96 27 54 0 1911676768 11001344 7434160
01:21:59 62035 8192000000 10879144832 11360993280 1904752352 18.865 97 10 20 2 1915966576 8578672 2635552
01:23:14 71356 8192000000 10860216400 11331833856 1902247344 18.844 97 14 28 1 1921653264 15031616 4374304
01:24:44 47319 8192000000 10870999328 11334926336 1890780336 18.752 97 17 34 3 1913070960 17432720 4857904
01:25:37 58322 8192000000 10882914592 11353468928 1893076672 18.771 97 23 46 1 1919529536 19567360 6885504
01:26:42 32505 8192000000 9245989360 9502568448 403285392 4.691 21 8 12 3 417460000 11951840 2222768

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 18-11-2020 01:28:38 to 18-11-2020 01:29:08.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-11-2020 01:29:09 to 18-11-2020 01:29:11.

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          235114
MON$OLDEST_ACTIVE               235115
MON$OLDEST_SNAPSHOT             235115
MON$NEXT_TRANSACTION            235115
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                       2005568
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 ---
--- end of diff output ---

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

18.11.20 01:29:12. 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-18 01:29:14 No severe PSQL-related problems occured
18.11.20 01:29:15. End of report.