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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-04-06 19:27:29
DTS_END                         2021-04-06 19:27:29.4860
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/37344
TRN_ID                          244185
ATT_ID                          647
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: 9172.56 21158 1100707
customer order: creation 178.70 310 21444
customer order: refuse 15.01 359 1801
order to supplier: creation 45.27 1203 5432
order to supplier: removal 3.40 88437 408
invoice (draft): creation 46.88 3333 5626
invoice (draft): removal 52.08 707 6249
invoice accept: apply 42.13 16207 5055
invoice accept: cancel 46.92 722 5630
customer reserve: creation 3867.13 160 464056
customer reserve: removal 4583.88 51 550066
realization accept: apply 86.41 193 10369
realization accept: cancel 72.63 102 8716
payment from customer: creation 59.38 144 7126
payment from customer: removal 6.18 102 741
payment to supplier: creation 50.79 201 6095
payment to supplier: removal 3.28 121 393
service: total inventory turnovers 4.89 1059 587
service: total monetary turnovers 6.70 19 804
service: aggregate perf. data 0.88 18628 105
service: refresh index statistics 0.03 291092 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-04-2021 19:28:38 to 06-04-2021 19:28:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3021
TEST_TIME 2 2669
TEST_TIME 3 3767
TEST_TIME 4 4015
TEST_TIME 5 4073
TEST_TIME 6 4334
TEST_TIME 7 4574
TEST_TIME 8 4927
TEST_TIME 9 4910
TEST_TIME 10 4856
TEST_TIME 11 5471
TEST_TIME 12 5529
TEST_TIME 13 5841
TEST_TIME 14 6173
TEST_TIME 15 6337
TEST_TIME 16 6552
TEST_TIME 17 7295
TEST_TIME 18 7306
TEST_TIME 19 7555
TEST_TIME 20 7856
TEST_TIME 21 8298
TEST_TIME 22 8848
TEST_TIME 23 9227
TEST_TIME 24 9360
TEST_TIME 25 9425
TEST_TIME 26 9546
TEST_TIME 27 10320
TEST_TIME 28 10280
TEST_TIME 29 10153
TEST_TIME 30 9914
TEST_TIME 31 10071
TEST_TIME 32 10023
TEST_TIME 33 9819
TEST_TIME 34 9753
TEST_TIME 35 9723
TEST_TIME 36 9636
TEST_TIME 37 9838
TEST_TIME 38 9809
TEST_TIME 39 9810
TEST_TIME 40 9659
TEST_TIME 41 9559
TEST_TIME 42 9529
TEST_TIME 43 9443
TEST_TIME 44 9325
TEST_TIME 45 9310
TEST_TIME 46 9244
TEST_TIME 47 9275
TEST_TIME 48 9148
TEST_TIME 49 9257
TEST_TIME 50 9305
TEST_TIME 51 9300
TEST_TIME 52 9359
TEST_TIME 53 9387
TEST_TIME 54 9466
TEST_TIME 55 9494
TEST_TIME 56 9440
TEST_TIME 57 9600
TEST_TIME 58 9608
TEST_TIME 59 9627
TEST_TIME 60 9669
TEST_TIME 61 9655
TEST_TIME 62 9686
TEST_TIME 63 9571
TEST_TIME 64 9492
TEST_TIME 65 9482
TEST_TIME 66 9466
TEST_TIME 67 9468
TEST_TIME 68 9359
TEST_TIME 69 9359
TEST_TIME 70 9340
TEST_TIME 71 9316
TEST_TIME 72 9300
TEST_TIME 73 9295
TEST_TIME 74 9345
TEST_TIME 75 9315
TEST_TIME 76 9315
TEST_TIME 77 9358
TEST_TIME 78 9336
TEST_TIME 79 9317
TEST_TIME 80 9284
TEST_TIME 81 9324
TEST_TIME 82 9435
TEST_TIME 83 9493
TEST_TIME 84 9525
TEST_TIME 85 9566
TEST_TIME 86 9507
TEST_TIME 87 9421
TEST_TIME 88 9378
TEST_TIME 89 9322
TEST_TIME 90 9390
TEST_TIME 91 9305
TEST_TIME 92 9299
TEST_TIME 93 9263
TEST_TIME 94 9243
TEST_TIME 95 9256
TEST_TIME 96 9256
TEST_TIME 97 9239
TEST_TIME 98 9245
TEST_TIME 99 9293
TEST_TIME 100 9263
TEST_TIME 101 9305
TEST_TIME 102 9317
TEST_TIME 103 9374
TEST_TIME 104 9389
TEST_TIME 105 9413
TEST_TIME 106 9430
TEST_TIME 107 9424
TEST_TIME 108 9442
TEST_TIME 109 9373
TEST_TIME 110 9340
TEST_TIME 111 9313
TEST_TIME 112 9294
TEST_TIME 113 9291
TEST_TIME 114 9251
TEST_TIME 115 9225
TEST_TIME 116 9165
TEST_TIME 117 9157
TEST_TIME 118 9182
TEST_TIME 119 9223
TEST_TIME 120 9174

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 06-04-2021 19:28:41 to 06-04-2021 19:28:45.

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 1531785 1531785 0 0.00 0 28338 6 0 0
doc_list_biud 1531785 1531785 0 0.00 0 36413 24 0 0
sp_add_invoice_to_stock 5180 5055 125 2.41 61 177522 16207 0 125
sp_cancel_adding_invoice 5630 5630 0 0.00 5 58649 722 0 0
sp_cancel_client_order 1801 1801 0 0.00 4 9104 359 0 0
sp_cancel_customer_reserve 550066 550066 0 0.00 1 23415 52 0 0
sp_cancel_pay_from_customer 741 741 0 0.00 2 7252 103 0 0
sp_cancel_pay_to_supplier 393 393 0 0.00 3 9088 121 0 0
sp_cancel_supplier_invoice 6261 6249 12 0.19 2 12846 707 0 12
sp_cancel_supplier_order 408 408 0 0.00 5 1008866 88438 0 0
sp_cancel_write_off 8716 8716 0 0.00 1 15308 103 0 0
sp_client_order 21444 21444 0 0.00 4 14755 310 0 0
sp_customer_reserve 464056 464056 0 0.00 0 56430 160 0 0
sp_fill_shopping_cart 32497 32497 0 0.00 1 16508 37 0 0
sp_fill_shopping_cart_clo_res 464055 464055 0 0.00 0 25862 14 0 0
sp_get_clo_for_invoice 5054 5054 0 0.00 0 28776 293 0 0
sp_kill_cost_storno 15480 15480 0 0.00 0 15910 56 0 0
sp_kill_qstorno_ret_qs2qd 1115505 1115505 0 0.00 0 23412 28 0 0
sp_kill_qty_storno 588293 588293 0 0.00 0 36410 61 0 0
sp_lock_selected_doc 21345 21345 0 0.00 0 10905 8 0 0
sp_make_cost_storno 28644 28644 0 0.00 0 27032 67 0 0
sp_multiply_rows_for_pdistr 28644 28644 0 0.00 0 15888 43 0 0
sp_multiply_rows_for_qdistr 21444 21444 0 0.00 0 13966 149 0 0
sp_pay_from_customer 7126 7126 0 0.00 4 22026 145 0 0
sp_pay_to_supplier 6095 6095 0 0.00 4 27535 201 0 0
sp_payment_common 13221 13221 0 0.00 1 18524 57 0 0
sp_qd_handle_on_cancel_clo 1801 1801 0 0.00 0 9092 331 0 0
sp_qd_handle_on_invoice_upd_sts 10684 10684 0 0.00 0 36400 306 0 0
sp_qd_handle_on_reserve_upd_sts 10369 10369 0 0.00 0 8797 48 0 0
sp_reserve_write_off 10369 10369 0 0.00 6 25377 194 0 0
sp_supplier_invoice 5626 5626 0 0.00 6 80216 3333 0 0
sp_supplier_order 5432 5432 0 0.00 5 30589 1203 0 0
srv_aggregate_perf_data 106 105 1 0.94 2561 155893 18629 0 1
srv_fill_mon_cache_memory 156 156 0 0.00 897 189503 33768 0 0
srv_find_qd_qs_mism 1052864 1052864 0 0.00 0 19248 5 0 0
srv_make_invnt_saldo 587 587 0 0.00 26 37189 1060 0 0
srv_make_money_saldo 804 804 0 0.00 0 370 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 164380 482417 291093 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 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 5055 5055 0 0.00 0 24528 149 0 0
t$perf-norm:sp_cancel_adding_invoice 395 395 0 0.00 0 7454 81 0 0
t$perf-norm:sp_cancel_client_order 1801 1801 0 0.00 0 6683 22 0 0
t$perf-norm:sp_cancel_customer_reserve 688 688 0 0.00 0 4360 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 741 741 0 0.00 0 2072 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 393 393 0 0.00 0 82 1 0 0
t$perf-norm:sp_cancel_supplier_invoice 441 441 0 0.00 0 540 10 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 19579 1348 0 0
t$perf-norm:sp_cancel_write_off 1055 1055 0 0.00 0 2205 5 0 0
t$perf-norm:sp_client_order 21444 21444 0 0.00 0 19047 19 0 0
t$perf-norm:sp_customer_reserve 1017 1017 0 0.00 0 1792 5 0 0
t$perf-norm:sp_pay_from_customer 7126 7126 0 0.00 0 5354 7 0 0
t$perf-norm:sp_pay_to_supplier 6095 6095 0 0.00 0 14938 10 0 0
t$perf-norm:sp_reserve_write_off 10369 10369 0 0.00 0 6263 12 0 0
t$perf-norm:sp_supplier_invoice 5626 5626 0 0.00 0 23440 26 0 0
t$perf-norm:sp_supplier_order 5432 5432 0 0.00 0 8782 16 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 362 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 58 1 0 0
t$perf-norm:srv_make_invnt_saldo 587 587 0 0.00 0 1560 20 0 0
t$perf-norm:srv_make_money_saldo 804 804 0 0.00 0 4398 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10356 10106 250 2.41 0 4670 19 0 250
v_all_customers 38086 38086 0 0.00 0 22 1 0 0
v_all_suppliers 30742 30742 0 0.00 0 15 1 0 0
v_all_wares 42888 42888 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 790 790 0 0.00 0 651 6 0 0
v_cancel_client_order 3602 3602 0 0.00 0 2230 5 0 0
v_cancel_customer_prepayment 1482 1482 0 0.00 0 7248 13 0 0
v_cancel_customer_reserve 1376 1376 0 0.00 0 3696 6 0 0
v_cancel_payment_to_supplier 786 786 0 0.00 0 6353 11 0 0
v_cancel_supplier_invoice 906 882 24 2.64 0 8389 29 0 24
v_cancel_supplier_order 816 816 0 0.00 0 2222 6 0 0
v_cancel_write_off 2110 2110 0 0.00 0 3098 13 0 0
v_max_id_clo_ord 5432 5432 0 0.00 0 273 1 0 0
v_max_id_clo_res 1017 1017 0 0.00 0 1087 8 0 0
v_max_id_ord_sup 5621 5621 0 0.00 0 4551 5 0 0
v_max_non_paid_invoice 1777 1777 0 0.00 0 2556 4 0 0
v_max_non_paid_realizn 4093 4093 0 0.00 0 1274 3 0 0
v_min_id_clo_ord 5432 5432 0 0.00 0 8693 12 0 0
v_min_id_clo_res 1017 1017 0 0.00 0 4727 10 0 0
v_min_id_ord_sup 5621 5621 0 0.00 0 4058 6 0 0
v_min_non_paid_invoice 6095 6095 0 0.00 0 18513 53 0 0
v_min_non_paid_realizn 7126 7126 0 0.00 0 17115 40 0 0
v_our_firm 10868 10868 0 0.00 0 22 1 0 0
v_reserve_write_off 20738 20738 0 0.00 0 3700 5 0 0
x_lock_depdocs_on_canc_invoice 11438 11438 0 0.00 0 14062 108 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 22461 362 0 0
x_make_qstorno_1000_1200 5432 5432 0 0.00 1 30451 1120 0 0
x_make_qstorno_1200_2000 5626 5626 0 0.00 3 69878 3200 0 0
x_make_qstorno_2100_3300 464056 464056 0 0.00 0 56421 144 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-04-2021 19:28:46 to 06-04-2021 19:28:50.

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
16:57:33 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:39 15913 8192000000 10257419872 10563756032 992846032 10.809 76 62 124 1 1016172576 2662048 20664496
16:58:04 39882 8192000000 10350752464 10666885120 1406242816 14.651 100 91 182 0 1441345296 5669744 29432736
16:58:55 34130 8192000000 10381271280 10701508608 1428267744 14.846 100 91 182 0 1465065840 7324688 29473408
16:59:39 15979 8192000000 10396263360 10720624640 1450298208 15.041 100 86 172 1 1487188880 8468480 28422192
17:00:07 3263 8192000000 10413698784 10740920320 1469106464 15.206 100 89 178 0 1506727616 9052512 28568640
17:00:26 21802 8192000000 10435999280 10766360576 1484267760 15.339 100 90 180 0 1522815648 9739440 28808448
17:00:58 18771 8192000000 10441791232 10774839296 1497212608 15.452 100 90 180 0 1536635024 10707424 28714992
17:01:34 12850 8192000000 10456736704 10794295296 1516539280 15.620 100 84 168 0 1553798288 10632928 26626080
17:02:01 16854 8192000000 10487468544 10833825792 1535557568 15.785 100 76 152 0 1569848048 10682512 23607968
17:02:26 12053 8192000000 10502170624 10851221504 1560640016 16.002 100 80 160 5 1597030768 11106464 25284288
17:02:53 13016 8192000000 10534180608 10886815744 1588230080 16.239 100 83 166 2 1624708304 10698448 25779776
17:03:19 14462 8192000000 10554701440 10911756288 1613061744 16.451 100 79 158 0 1648176768 11010384 24104640
17:03:43 9659 8192000000 10575711264 10936446976 1639979392 16.680 100 76 152 1 1673686960 10946224 22761344
17:03:59 9981 8192000000 10598429216 10963488768 1657880864 16.831 100 76 152 0 1691220480 11126064 22213552
17:04:20 10930 8192000000 10628803632 10996056064 1684784640 17.058 100 84 168 1 1722247360 13100592 24362128
17:04:38 5760 8192000000 10641096352 11007893504 1696744080 17.158 100 83 166 2 1734385904 13870560 23771264
17:04:50 5945 8192000000 10639944560 11011760128 1700947712 17.193 100 82 164 1 1738056240 13458448 23650080
17:05:04 5160 8192000000 10663019792 11033350144 1716469984 17.323 100 85 168 1 1754750096 13978848 24301264
17:05:16 5570 8192000000 10677049920 11047505920 1729700832 17.433 100 86 174 2 1768835536 14467824 24666880
17:05:29 5251 8192000000 10679984368 11054604288 1736962000 17.493 100 81 162 1 1774547696 14978928 22606768
17:05:42 4627 8192000000 10698511776 11072651264 1750703968 17.607 100 86 172 1 1788426704 12898336 24824400
17:05:53 6159 8192000000 10696794032 11078664192 1760176688 17.686 100 86 171 3 1797733888 13247024 24310176
17:06:07 3640 8192000000 10708040480 11086499840 1770488128 17.771 100 84 167 2 1806898576 13051712 23358736
17:06:17 3250 8192000000 10721190864 11101704192 1783378432 17.877 100 83 166 1 1819710592 13034224 23297936
17:06:27 2390 8192000000 10731109344 11111809024 1797345856 17.992 100 89 176 0 1835690208 13551200 24793152
17:06:41 2003 8192000000 10735622608 11114975232 1796236400 17.983 100 78 155 0 1831338800 13898896 21203504
17:06:49 3283 8192000000 10749863472 11132690432 1803419648 18.042 100 90 181 0 1842217616 13041120 25756848
17:06:59 2435 8192000000 10764479456 11147898880 1825024176 18.219 100 90 179 4 1863697296 13261488 25411632
17:07:08 2478 8192000000 10772655392 11156156416 1827930384 18.242 100 92 183 2 1866801024 13225712 25644928
17:07:17 1946 8192000000 10780480448 11164864512 1841150880 18.350 100 91 182 0 1880447136 14040544 25255712
17:07:26 1844 8192000000 10789344320 11175485440 1843794576 18.372 100 83 167 1 1882674432 14769456 24110400
17:07:34 2429 8192000000 10784100320 11175067648 1851712288 18.436 100 91 182 1 1888965840 12223568 25029984
17:07:43 1394 8192000000 10791158128 11177897984 1853801056 18.453 100 95 188 1 1893726272 12413408 27511808
17:07:50 1558 8192000000 10800970832 11187961856 1858983616 18.495 100 91 182 2 1897461248 13162480 25315152
17:07:58 1660 8192000000 10807992640 11194269696 1861332624 18.514 100 96 193 0 1903820720 15796768 26691328
17:08:06 1207 8192000000 10808152176 11193991168 1865265536 18.546 100 98 197 2 1908397680 15768448 27363696
17:08:14 1264 8192000000 10814896688 11201474560 1865210992 18.546 100 94 187 1 1906126144 14558064 26357088
17:08:22 1423 8192000000 10819254320 11205345280 1871616448 18.597 100 95 190 0 1912478496 13397456 27464592
17:08:29 947 8192000000 10820050112 11206766592 1877647552 18.646 100 89 179 0 1916774336 13317488 25809296
17:08:36 53850 8192000000 10804299488 11204775936 1872816800 18.607 100 63 126 3 1899627344 8076592 18733952
17:09:37 22977 8192000000 10790627504 11211333632 1873205104 18.610 100 30 60 2 1889199392 6969440 9024848
17:10:07 8023 8192000000 10792509632 11213488128 1879150816 18.658 100 27 54 2 1893231104 7114704 6965584
17:10:22 8308 8192000000 10804623456 11221880832 1881976064 18.681 100 37 74 2 1898725280 6927936 9821280
17:10:40 6217 8192000000 10794117872 11218833408 1881705904 18.679 100 25 50 1 1896263472 7821248 6736320
17:10:55 5620 8192000000 10805611616 11226861568 1884959648 18.705 100 27 54 0 1899725088 6939264 7826176
17:11:10 11126 8192000000 10787646160 11225214976 1884007664 18.697 100 18 37 1 1895028416 6056720 4964032
17:11:28 7190 8192000000 10797352256 11226718208 1887004880 18.722 100 33 66 0 1903348096 6944576 9398640
17:11:45 11845 8192000000 10797860416 11227869184 1894252176 18.780 100 31 62 1 1908308656 5452512 8603968
17:12:07 13018 8192000000 10802514560 11236007936 1892862336 18.769 100 21 42 2 1908685264 10013296 5809632
17:12:27 12457 8192000000 10804923680 11238834176 1897103696 18.803 100 22 44 2 1908868736 5851200 5913840
17:12:46 11017 8192000000 10810822784 11239608320 1897858928 18.809 100 20 40 1 1910556448 5965040 6732480
17:13:05 7588 8192000000 10811410368 11242274816 1899340944 18.821 100 22 44 4 1911835376 6047648 6446784
17:13:19 5859 8192000000 10814694544 11242364928 1900279136 18.829 100 21 40 0 1911721072 6021072 5420864
17:13:32 7112 8192000000 10819996624 11250495488 1906529536 18.879 100 21 42 0 1918315984 6119744 5666704
17:13:48 18760 8192000000 10817262176 11252895744 1909084128 18.899 100 29 57 1 1923402176 5795024 8523024
17:14:13 71062 8192000000 10820161088 11260780544 1908643872 18.896 100 21 43 1 1920456896 5752976 6060048
17:15:32 6749 8192000000 10835331952 11265953792 1912418048 18.926 100 19 39 2 1923672320 5503040 5751232
17:15:46 12035 8192000000 10822503888 11259695104 1910900016 18.914 100 19 38 0 1922760288 6399392 5460880
17:16:04 4855 8192000000 10836453280 11267821568 1918469584 18.975 100 32 64 1 1933805808 6909936 8426288
17:16:17 4413 8192000000 10823236784 11254116352 1906791488 18.881 100 30 60 2 1921957248 6521424 8644336
17:16:28 7423 8192000000 10823930256 11256569856 1907368592 18.886 100 25 50 1 1919971152 5709168 6893392
17:16:41 4288 8192000000 10817378736 11249385472 1891562928 18.758 99 34 68 2 1907965888 6478608 9924352
17:16:53 6376 8192000000 10803099904 11232649216 1885989616 18.713 100 20 40 1 1897711312 6002832 5718864
17:17:06 4230 8192000000 10814728464 11236188160 1860723632 18.509 98 33 67 1 1876378480 6867632 8787216
17:17:19 6703 8192000000 10793201280 11229741056 1869671440 18.582 99 21 42 2 1881499344 5628592 6199312
17:17:32 6683 8192000000 10781476640 11217207296 1872179920 18.602 99 16 30 2 1882504160 5718960 4605280
17:17:45 10331 8192000000 10776930016 11202658304 1791688464 17.946 95 21 43 3 1802843504 5255808 5899232
17:18:01 8251 8192000000 10774578608 11201404928 1832912704 18.283 99 17 34 1 1843869888 5962720 4994464
17:18:17 10135 8192000000 10733042416 11161694208 1760299504 17.687 95 11 22 0 1768442000 4997520 3144976
17:18:36 8253 8192000000 10749770320 11172548608 1784719264 17.888 97 14 28 1 1793844896 4984864 4140768
17:18:51 65983 8192000000 10749273440 11139305472 1667776288 16.914 90 49 99 0 1687842464 4640768 15425408
17:20:03 8054 8192000000 10716578800 11147264000 1799290992 18.008 99 31 62 1 1816698800 8228016 9179792
17:20:18 6665 8192000000 10712068192 11134488576 1769878576 17.766 98 14 28 0 1779390912 5443712 4068624
17:20:34 6708 8192000000 10704536656 11115061248 1735559200 17.482 96 35 68 1 1752218752 7040304 9619248
17:20:48 8364 8192000000 10708661728 11123679232 1763153920 17.710 98 23 46 1 1775321456 5421088 6746448
17:21:04 5381 8192000000 10714883648 11129982976 1784492688 17.886 99 28 56 0 1799760960 7340336 7927936
17:21:16 4653 8192000000 10707347952 11121049600 1753204624 17.628 97 34 69 0 1769524576 6493648 9826304
17:21:28 4996 8192000000 10731241536 11140771840 1791889968 17.947 99 41 82 3 1810654672 6724272 12040432
17:21:42 7456 8192000000 10702623632 11106578432 1761184416 17.694 98 32 64 2 1775292128 6101264 8006448
17:21:56 10070 8192000000 10713441152 11130646528 1782214672 17.868 99 18 36 1 1792438528 5230736 4993120
17:22:13 8713 8192000000 10741355856 11153059840 1812772576 18.119 100 33 66 0 1828222288 5930272 9519440
17:22:30 7339 8192000000 10703158304 11119636480 1736334208 17.488 96 22 44 1 1747528112 4618752 6575152
17:22:45 7975 8192000000 10724592656 11146149888 1804647440 18.052 100 25 51 0 1817798400 5370080 7780880
17:23:01 9779 8192000000 10740164336 11159269376 1804777392 18.053 99 13 26 0 1813066432 5058912 3230128
17:23:18 66424 8192000000 10743295632 11173670912 1833065616 18.284 100 29 59 0 1846950096 5679200 8205280
17:24:32 7149 8192000000 10745187168 11174674432 1834637344 18.297 100 30 56 1 1848446176 6278944 7529888
17:24:47 8010 8192000000 10759165392 11183046656 1842699488 18.363 100 35 70 1 1863037008 10481568 9855952
17:25:02 6145 8192000000 10770461008 11188301824 1846103664 18.390 100 43 84 2 1864482592 6864064 11514864
17:25:16 6026 8192000000 10766605120 11183865856 1845783648 18.388 100 25 51 0 1858601344 5684672 7133024
17:25:32 9454 8192000000 10760935504 11188912128 1852601984 18.443 100 26 52 0 1866195472 6333504 7259984
17:25:51 7446 8192000000 10773088688 11196776448 1855334016 18.465 100 18 36 2 1866000912 5676176 4990720
17:26:09 14161 8192000000 10776870624 11200942080 1858146576 18.488 100 21 42 1 1869692000 5135552 6409872
17:26:30 10536 8192000000 10770925616 11205459968 1864597584 18.541 100 24 48 2 1877985072 6256288 7131200
17:26:47 9099 8192000000 10773148992 11205435392 1864737984 18.542 100 18 36 1 1874821136 5038576 5044576
17:27:03 11347 8192000000 10791462624 11223285760 1877569072 18.645 100 15 30 0 1886538976 4852800 4117104
17:27:20 16877 8192000000 10795935328 11230269440 1889097360 18.739 100 17 33 3 1898552256 4575216 4879680
17:27:58 18520 8192000000 10837383360 11251650560 1905368912 18.869 100 46 92 0 1924488912 6559776 12560224
17:28:29 45823 8192000000 10849074784 11271585792 1912910736 18.930 100 46 91 0 1934824128 9025040 12888352
17:29:22 76929 8192000000 10848848320 11278987264 1919890368 18.986 100 35 70 1 1942525872 12633616 10001888
17:30:49 76493 8192000000 10849100624 11292946432 1922847984 19.010 100 21 42 3 1942440192 13799088 5793120
17:32:13 17974 8192000000 10864238000 11297644544 1934048624 19.099 100 29 58 0 1957952048 15493888 8409536
17:32:37 6307 8192000000 10881079616 11307479040 1942133776 19.164 100 54 106 5 1970982832 12731376 16117680
17:32:51 7577 8192000000 10879431600 11308040192 1944569456 19.183 100 49 97 3 1972272384 13544944 14157984
17:33:09 27478 8192000000 10874155296 11308494848 1941597104 19.159 100 42 84 0 1969610240 15530416 12482720
17:33:53 15214 8192000000 10888548032 11325587456 1946442208 19.198 100 43 84 2 1980817568 22178368 12196992
17:34:16 15722 8192000000 10895512240 11329650688 1952751584 19.248 100 43 86 0 1981812528 16237984 12822960
17:34:46 15902 8192000000 10920127440 11351621632 1968946208 19.377 100 43 82 2 2005181456 23602944 12632304
17:35:12 8630 8192000000 10912001072 11350163456 1973563696 19.414 100 43 86 2 2007683872 21124496 12995680
17:35:38 7725 8192000000 10921898864 11351207936 1974965392 19.425 100 50 100 1 2008023600 18175888 14882320
17:35:53 9689 8192000000 10920137584 11352113152 1977059712 19.441 100 48 96 0 2010331840 18809856 14462272
17:36:12 8845 8192000000 10910533904 11347263488 1961077712 19.315 99 47 94 0 1992820480 17853152 13889616
17:36:29 15994 8192000000 10914534256 11345694720 1953396352 19.254 99 44 88 0 1985760880 18767952 13596576
17:36:52 5015 8192000000 10913373056 11343200256 1967374688 19.365 99 70 139 5 2007874224 19866976 20632560
17:37:09 7240 8192000000 10947764176 11367968768 1988042800 19.528 100 74 147 1 2032264560 22388352 21833408
17:37:24 12275 8192000000 10946577936 11373277184 1988986288 19.536 100 58 116 2 2029903712 23322240 17595184
17:37:47 10721 8192000000 10960811680 11380129792 1997919664 19.606 100 70 138 0 2045774016 27083184 20771168
17:38:05 6771 8192000000 10949161520 11376369664 1977613968 19.446 99 55 108 1 2021405472 27609168 16182336
17:38:19 8043 8192000000 10954834960 11382415360 1998105696 19.608 100 69 136 1 2045768016 27020560 20641760
17:38:34 5187 8192000000 10952886080 11365380096 1979104704 19.458 99 75 144 0 2026769200 25730048 21934448
17:38:47 8209 8192000000 10950418304 11381104640 1991909872 19.559 100 59 118 0 2035065440 25573136 17582432
17:39:02 8165 8192000000 10961128000 11391078400 2004213280 19.656 100 73 146 1 2052350192 26422656 21714256
17:39:19 2241 8192000000 10971191152 11392835584 2006124176 19.671 100 72 142 2 2054572512 27478640 20969696
17:39:30 9344 8192000000 10966383776 11389915136 2002783696 19.645 100 70 139 0 2052616528 29095904 20736928
17:39:47 7171 8192000000 10956087248 11384217600 1989445552 19.539 100 60 120 0 2040607904 32495136 18667216
17:40:03 8366 8192000000 10966143728 11389145088 2001006208 19.631 100 71 140 1 2056469104 34860464 20602432
17:40:21 2933 8192000000 10990548608 11408117760 2010297360 19.704 100 78 155 1 2069205376 35494784 23413232
17:40:33 7859 8192000000 10983304816 11409530880 2010557168 19.706 100 71 140 0 2067444208 35517008 21370032
17:40:49 4533 8192000000 10987469520 11410464768 2015157424 19.742 100 73 144 2 2074255088 37144496 21953168
17:41:02 2535 8192000000 10946929424 11364311040 1968143248 19.371 98 83 166 1 2025579888 32323040 25113600
17:41:12 3292 8192000000 10971756736 11396878336 1996227744 19.593 100 73 145 0 2051749488 33410848 22110896
17:41:23 6072 8192000000 10971336528 11392335872 1996866176 19.598 100 73 146 1 2051101600 31602960 22632464
17:41:40 5653 8192000000 10971353392 11399499776 2004298704 19.657 100 69 138 2 2058054816 32811264 20944848
17:41:55 2754 8192000000 10963287440 11385552896 1978538720 19.453 99 76 150 0 2032900736 31492448 22869568
17:42:07 7823 8192000000 10967539984 11383685120 1990824656 19.550 100 83 165 1 2048181072 32130944 25225472
17:42:23 1884 8192000000 10961749616 11378139136 1988963664 19.536 100 79 158 0 2046899024 33575600 24359760
17:42:34 3848 8192000000 10951606816 11367383040 1960206768 19.308 99 82 163 2 2022596048 37298976 25090304
17:42:53 1468 8192000000 10937982432 11354570752 1953964416 19.258 99 72 141 2 2012723664 36060688 22698560
17:43:04 3832 8192000000 10955885888 11374579712 1975211728 19.427 100 69 137 1 2033075104 36275216 21588160
17:43:16 5537 8192000000 10952401920 11373023232 1976590448 19.438 100 79 158 2 2038300208 36814288 24895472
17:43:30 1377 8192000000 10956287504 11378446336 1977303376 19.443 100 78 153 1 2038482672 36963712 24215584
17:43:38 3424 8192000000 10959917424 11381796864 1983374912 19.491 100 81 161 2 2048371104 39376592 25619600
17:43:48 1514 8192000000 10955619440 11365310464 1970804352 19.392 100 92 183 3 2038389680 38189280 29396048
17:43:58 2445 8192000000 10931460096 11346235392 1939974032 19.147 99 93 187 1 2008508304 38996288 29537984
17:44:09 4126 8192000000 10928575136 11342962688 1931687520 19.080 99 79 155 1 1994359520 39421328 23250672
17:44:20 4144 8192000000 10925691024 11349626880 1936091392 19.116 99 59 119 0 1992739072 38403024 18244656
17:44:37 10792 8192000000 10916213744 11349012480 1948839104 19.217 100 53 104 0 2001636272 36423168 16374000
17:44:55 7095 8192000000 10912523216 11350380544 1940306064 19.149 99 40 79 1 1985033648 32526816 12200768
17:45:09 7954 8192000000 10911795600 11351646208 1951055456 19.235 100 35 69 1 1995058704 33074864 10928384
17:45:24 4647 8192000000 10876039536 11310956544 1918961392 18.979 98 50 99 0 1970337280 36112592 15263296
17:45:35 6246 8192000000 10909594448 11339853824 1945348576 19.189 100 56 111 2 1999796320 37090704 17357040
17:45:49 3288 8192000000 10921720848 11336060928 1942142000 19.164 100 72 142 1 2000144384 36331536 21670848
17:46:00 2046 8192000000 10914092416 11337842688 1940060080 19.147 100 65 128 2 1998935552 39175744 19699728
17:46:11 2222 8192000000 10922903408 11339300864 1942082832 19.163 100 81 162 2 2008121808 40848496 25190480
17:46:20 9081 8192000000 10898062768 11307327488 1906557504 18.879 98 76 150 1 1970838544 41499664 22781376
17:46:36 1127 8192000000 10907216688 11319631872 1908251376 18.893 99 78 155 1 1974945296 42998112 23695808
17:46:45 5053 8192000000 10890223456 11312852992 1902648528 18.848 99 55 110 1 1963179392 43340720 17190144
17:46:56 20794 8192000000 10861138352 11300761600 1894480448 18.782 99 40 79 2 1949433472 41702432 13250592
17:47:32 16339 8192000000 10877734240 11313553408 1911904960 18.922 100 33 66 4 1960710016 37644752 11160304
17:47:57 14304 8192000000 10887167392 11315802112 1882248416 18.683 98 46 92 3 1938329728 40619888 15461424
17:48:21 4829 8192000000 10897027312 11320463360 1903927904 18.858 99 58 114 1 1968741888 46415568 18398416
17:48:32 2440 8192000000 10926726480 11346239488 1936358832 19.118 100 80 158 1 2009338160 47500224 25479104
17:48:43 6766 8192000000 10908048944 11348791296 1938348992 19.134 100 42 84 2 1996264128 44209216 13705920
17:48:59 12147 8192000000 10898337888 11339341824 1923378736 19.014 99 38 75 2 1975742752 40443216 11920800
17:49:19 9303 8192000000 10885123504 11328192512 1899568080 18.823 98 32 64 1 1948467408 38552208 10347120
17:49:36 10317 8192000000 10882900400 11330793472 1923251616 19.013 100 41 80 1 1976212400 40011072 12949712
17:49:57 12830 8192000000 10871426096 11314642944 1900719584 18.832 99 21 43 0 1940320480 32505168 7095728
17:50:21 6533 8192000000 10868475936 11286814720 1883203600 18.691 98 31 61 0 1918832016 26071216 9557200
17:50:34 16673 8192000000 10858419456 11301814272 1876733344 18.639 98 31 61 1 1915629888 28798944 10097600
17:50:57 10949 8192000000 10863845712 11313508352 1914559008 18.943 100 26 52 1 1949284224 26680240 8044976
17:51:20 16524 8192000000 10875213888 11320455168 1930389728 19.070 100 21 42 2 1963285520 26551712 6344080
17:52:08 31553 8192000000 10878035040 11335856128 1911583536 18.919 99 20 40 1 1949815456 31787456 6444464
17:52:46 16314 8192000000 10885546464 11330887680 1926585088 19.040 100 19 38 2 1960144512 27057680 6501744
17:53:12 18371 8192000000 10870682544 11322421248 1894202656 18.780 98 20 40 1 1931603024 30520112 6880256
17:53:37 13414 8192000000 10874320144 11321798656 1920161920 18.988 100 17 34 1 1954239440 28743040 5334480
17:53:57 14795 8192000000 10888012256 11334717440 1929202832 19.061 100 19 37 1 1966983088 31794176 5986080
17:54:32 52327 8192000000 10848237344 11287982080 1849850064 18.421 96 18 36 1 1866176752 10788912 5537776
17:55:33 33980 8192000000 10848089296 11288727552 1886555232 18.718 98 41 81 0 1912030176 12570464 12904480
17:56:20 76563 8192000000 10872293744 11316330496 1926551040 19.039 100 20 40 1 1946546848 14239728 5756080
17:57:52 67239 8192000000 10861529872 11327979520 1880798272 18.672 97 21 38 4 1902029808 15638128 5593408
17:59:13 41778 8192000000 10878361472 11333206016 1944679568 19.184 100 26 52 2 1970156448 17722624 7754256
18:00:01 41290 8192000000 10920115280 11357761536 1956458144 19.278 100 36 66 2 1982216080 17375808 8382128
18:00:50 56996 8192000000 10913278864 11353976832 1947594960 19.207 99 49 96 2 1982495200 21459280 13440960
18:01:53 897 8192000000 10945173104 11367059456 1975674464 19.430 100 93 183 4 2024796976 22448608 26673904
18:02:00 24257 8192000000 10906455424 11365945344 1969738496 19.383 100 60 120 0 2012490464 25945472 16806496
18:03:15 51107 8192000000 10906130432 11375144960 1966625648 19.359 100 21 41 0 1998687648 25779856 6282144
18:04:23 26566 8192000000 10907411952 11375194112 1966955184 19.361 100 17 34 0 1994593040 22789312 4848544
18:04:57 52399 8192000000 10876938560 11340496896 1932780528 19.089 98 14 28 0 1951582432 14658016 4143888
18:06:36 24863 8192000000 10884273264 11357143040 1961885056 19.321 100 12 23 0 1979098912 13640048 3573808
18:07:07 28498 8192000000 10894884960 11358064640 1967651552 19.367 100 14 28 0 1980469792 8924016 3894224
18:08:00 91818 8192000000 10908002032 11379580928 1975835456 19.432 100 21 42 1 1996186640 14565792 5785392
18:09:42 77005 8192000000 10911079984 11375357952 1962987376 19.330 99 15 30 0 1979685056 12530224 4167456
18:11:09 24680 8192000000 10938527936 11376005120 1977036384 19.441 99 56 110 2 2002998400 10267792 15694224
18:11:40 65834 8192000000 10889805360 11362734080 1925771856 19.033 97 21 42 1 1942432112 10507568 6152688
18:12:58 31922 8192000000 10900824208 11371237376 1973808208 19.416 100 13 26 1 1992553664 15003424 3742032
18:13:37 79754 8192000000 10894188320 11371675648 1942290096 19.165 98 13 26 2 1959426192 13295872 3840224
18:15:03 32602 8192000000 10896278896 11374489600 1974272480 19.419 100 10 20 1 1991423904 14018000 3133424
18:16:16 46637 8192000000 10905573680 11380879360 1945622976 19.192 98 14 27 2 1959423168 10033792 3766400
18:17:12 80652 8192000000 10918708464 11377254400 1938898512 19.138 98 12 24 1 1954952000 12871712 3181776
18:18:39 36535 8192000000 10932669648 11378696192 1966447984 19.357 99 32 65 0 1983694640 7839232 9407424
18:19:25 65576 8192000000 10895242624 11364974592 1921293616 18.997 97 22 44 0 1938150816 10525376 6331824
18:20:38 37702 8192000000 10908466128 11378028544 1974665472 19.422 100 24 48 0 1994589760 12809472 7114816
18:21:22 88608 8192000000 10905040432 11365687296 1924791520 19.025 97 25 50 2 1943726192 12086992 6847680
18:23:00 52193 8192000000 10888430192 11341905920 1891003120 18.754 96 22 45 1 1909762464 12670992 6088352
18:24:01 81099 8192000000 10877564016 11349676032 1872952928 18.608 96 17 34 1 1892073824 14745632 4375264
18:25:47 53521 8192000000 10905907392 11362230272 1924281264 19.021 98 23 46 0 1946855280 15821888 6752128
18:26:49 109076 8192000000 10870840432 11320528896 1813985152 18.129 93 18 36 1 1832144160 13231344 4927664
18:28:44 59542 8192000000 10847933392 11311493120 1861624000 18.516 96 11 22 1 1875817440 11166160 3027280
18:29:50 67653 8192000000 10867867008 11321847808 1921065936 18.995 99 20 40 0 1933344912 5763936 6515040
18:31:14 68687 8192000000 10853378384 11311726592 1810559344 18.100 93 27 54 0 1829140528 11705392 6875792
18:32:32 72181 8192000000 10858059712 11327938560 1928427968 19.054 100 16 32 0 1951710288 19465520 3816800
18:33:50 11840 8192000000 10851720512 11331149824 1927005968 19.043 100 4 8 1 1949244848 21030416 1208464
18:34:24 80354 8192000000 10838294720 11305332736 1896489376 18.798 99 13 26 0 1913628480 13478944 3660160
18:35:50 67733 8192000000 10843932848 11316203520 1892904464 18.769 98 18 35 0 1910305760 12156464 5244832
18:38:10 65252 8192000000 10823230576 11309932544 1885860480 18.712 98 16 32 1 1902874592 12650448 4363664
18:39:24 25489 8192000000 10827878144 11314466816 1910806528 18.913 100 2 4 0 1922626128 11475568 344032
18:39:56 77947 8192000000 10843524816 11325394944 1850520928 18.426 96 10 20 0 1867466384 14216400 2729056
18:42:18 28206 8192000000 10870903952 11328061440 1925761792 19.033 99 36 73 0 1943965264 6819920 11383552
18:42:55 22204 8192000000 10870632752 11334848512 1944728720 19.184 100 37 74 2 1963752112 8359392 10664000
18:43:24 32686 8192000000 10876199824 11339550720 1934598352 19.104 99 30 53 2 1950750112 8214000 7937760
18:44:06 80151 8192000000 10859238144 11331014656 1887747728 18.728 97 17 34 0 1902046096 9673872 4624496
18:45:36 31031 8192000000 10864038544 11324297216 1905821792 18.873 98 22 44 1 1919997696 7949440 6226464
18:46:13 30282 8192000000 10882696544 11340480512 1907085024 18.883 98 35 70 0 1927293728 10535856 9672848
18:47:07 33537 8192000000 10897731760 11358400512 1947643088 19.208 100 36 72 1 1971012432 13456400 9912944
18:48:19 62847 8192000000 10876186592 11360747520 1928150576 19.052 99 13 26 1 1957881504 25534096 4196832
18:49:28 140276 8192000000 10858443792 11344953344 1857504592 18.483 95 6 12 2 1878965792 20010816 1450384
18:51:55 149573 8192000000 10856051760 11329138688 1868747056 18.574 96 17 34 2 1887631552 13959296 4925200
18:54:30 74910 8192000000 10862318432 11330199552 1906316128 18.877 98 32 62 1 1924740480 9424624 8999728
18:55:52 40127 8192000000 10876822864 11343237120 1945384560 19.190 100 19 38 0 1960404160 9919264 5100336
18:57:15 57126 8192000000 10867380592 11363807232 1952572160 19.247 100 7 14 1 1965475296 11162032 1741104
18:59:42 71002 8192000000 10870130544 11359387648 1945031696 19.187 99 9 18 0 1953896816 6948144 1916976
19:01:37 41182 8192000000 10879589952 11356311552 1897286288 18.804 96 18 36 0 1909306016 7062928 4956800
19:02:48 67500 8192000000 10884219328 11364302848 1960088768 19.307 100 7 14 1 1970264304 8350544 1824992
19:04:02 17745 8192000000 10926507088 11372990464 1975785888 19.431 100 48 95 3 1999377184 9132256 14459040
19:04:29 72725 8192000000 10911212816 11384635392 1981541568 19.477 100 30 60 0 2002385344 12400064 8443712
19:05:50 55103 8192000000 10886799920 11363704832 1919119536 18.980 97 18 36 0 1934740288 9922800 5697952
19:06:51 27129 8192000000 10915486752 11378823168 1962083424 19.323 99 35 70 2 1981869968 9582256 10204288
19:07:25 45000 8192000000 10904794592 11370979328 1944928784 19.186 98 27 54 3 1964481840 12250400 7302656
19:08:16 52035 8192000000 10910493232 11384684544 1951645872 19.240 99 17 32 1 1970896144 13944512 5305760
19:09:34 76059 8192000000 10893212528 11370106880 1955053168 19.267 99 12 24 1 1972119360 13601648 3464544
19:11:01 189503 8192000000 10896569824 11369693184 1837973040 18.324 93 5 10 0 1858368688 19344512 1051136
19:14:20 51914 8192000000 10868680512 11330297856 1825630832 18.224 93 26 52 1 1843623776 11145040 6847904
19:15:18 109176 8192000000 10824412032 11294441472 1782288512 17.868 92 23 46 0 1802085856 13113776 6683568
19:17:13 95444 8192000000 10847403232 11315769344 1880789616 18.671 98 19 36 0 1896126928 9668592 5668720
19:19:03 27356 8192000000 10856395920 11337334784 1938289152 19.133 100 21 42 0 1955561008 11480768 5791088
19:19:46 53411 8192000000 10841151904 11315204096 1881937328 18.681 97 16 31 1 1896051776 9602096 4512352
19:20:45 64931 8192000000 10858169616 11336564736 1916866736 18.962 99 4 8 0 1927273888 9188240 1218912
19:22:38 69888 8192000000 10868278592 11349188608 1919230688 18.981 98 14 28 1 1934223392 10982608 4010096
19:24:02 58609 8192000000 10864992352 11346104320 1915164192 18.948 98 13 26 2 1932035328 12788224 4082912
19:25:08 55955 8192000000 10848824656 11334860800 1842454704 18.361 95 10 20 0 1863198736 17822656 2921376
19:26:11 63648 8192000000 10849779952 11319218176 1858284560 18.489 96 16 32 0 1870861776 8701184 3876032
19:27:28 6422 8192000000 9026529616 9227698176 198157168 2.361 11 2 3 0 199873536 1299168 417200

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 06-04-2021 19:28:52 to 06-04-2021 19:29:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 125 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-04-2021 19:29:23 to 06-04-2021 19:29:25.

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          244488
MON$OLDEST_ACTIVE               244489
MON$OLDEST_SNAPSHOT             244489
MON$NEXT_TRANSACTION            244489
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                       2034528
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.33441 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33441 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33441 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33441 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 ---
:15: 
:16: mscs-test-161.budzdorov.ru    Tue Apr  6 19:27:39 2021
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
--- end of diff output ---

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

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