Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.03.2021 22:29
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 17321536 kB
MemAvailable 31583164 kB
Buffers 0 kB
Cached 14378020 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-17 22:27:23
DTS_END                         2021-03-17 22:27:23.8580
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(226:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/40258
TRN_ID                          235839
ATT_ID                          710
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: 9182.91 26681 1101949
customer order: creation 163.74 373 19649
customer order: refuse 14.42 350 1730
order to supplier: creation 43.83 1390 5259
order to supplier: removal 3.28 120562 393
invoice (draft): creation 43.99 4114 5279
invoice (draft): removal 54.97 925 6596
invoice accept: apply 40.15 18452 4818
invoice accept: cancel 48.88 882 5866
customer reserve: creation 3669.12 182 440294
customer reserve: removal 4810.13 63 577216
realization accept: apply 79.37 199 9524
realization accept: cancel 85.96 120 10315
payment from customer: creation 57.89 121 6947
payment from customer: removal 5.48 94 657
payment to supplier: creation 46.31 139 5557
payment to supplier: removal 3.33 78 399
service: total inventory turnovers 4.63 1335 556
service: total monetary turnovers 6.69 36 803
service: aggregate perf. data 0.73 24249 87
service: refresh index statistics 0.03 359954 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-03-2021 22:29:27 to 17-03-2021 22:29:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3064
TEST_TIME 2 3119
TEST_TIME 3 3809
TEST_TIME 4 4048
TEST_TIME 5 4158
TEST_TIME 6 4514
TEST_TIME 7 4790
TEST_TIME 8 5587
TEST_TIME 9 5726
TEST_TIME 10 5943
TEST_TIME 11 6169
TEST_TIME 12 6299
TEST_TIME 13 6725
TEST_TIME 14 7123
TEST_TIME 15 7396
TEST_TIME 16 7395
TEST_TIME 17 7766
TEST_TIME 18 8148
TEST_TIME 19 8398
TEST_TIME 20 8392
TEST_TIME 21 8590
TEST_TIME 22 8467
TEST_TIME 23 8439
TEST_TIME 24 8563
TEST_TIME 25 8565
TEST_TIME 26 8538
TEST_TIME 27 9311
TEST_TIME 28 10163
TEST_TIME 29 11083
TEST_TIME 30 10928
TEST_TIME 31 10728
TEST_TIME 32 10611
TEST_TIME 33 10430
TEST_TIME 34 10463
TEST_TIME 35 10301
TEST_TIME 36 10099
TEST_TIME 37 10018
TEST_TIME 38 10105
TEST_TIME 39 10045
TEST_TIME 40 9941
TEST_TIME 41 9891
TEST_TIME 42 9822
TEST_TIME 43 9751
TEST_TIME 44 9751
TEST_TIME 45 9740
TEST_TIME 46 9599
TEST_TIME 47 9478
TEST_TIME 48 9409
TEST_TIME 49 9453
TEST_TIME 50 9444
TEST_TIME 51 9305
TEST_TIME 52 9301
TEST_TIME 53 9311
TEST_TIME 54 9319
TEST_TIME 55 9322
TEST_TIME 56 9354
TEST_TIME 57 9321
TEST_TIME 58 9454
TEST_TIME 59 9420
TEST_TIME 60 9490
TEST_TIME 61 9441
TEST_TIME 62 9595
TEST_TIME 63 9550
TEST_TIME 64 9640
TEST_TIME 65 9672
TEST_TIME 66 9669
TEST_TIME 67 9545
TEST_TIME 68 9541
TEST_TIME 69 9519
TEST_TIME 70 9472
TEST_TIME 71 9475
TEST_TIME 72 9429
TEST_TIME 73 9374
TEST_TIME 74 9373
TEST_TIME 75 9349
TEST_TIME 76 9288
TEST_TIME 77 9210
TEST_TIME 78 9193
TEST_TIME 79 9205
TEST_TIME 80 9294
TEST_TIME 81 9270
TEST_TIME 82 9232
TEST_TIME 83 9261
TEST_TIME 84 9353
TEST_TIME 85 9347
TEST_TIME 86 9289
TEST_TIME 87 9344
TEST_TIME 88 9352
TEST_TIME 89 9357
TEST_TIME 90 9355
TEST_TIME 91 9418
TEST_TIME 92 9336
TEST_TIME 93 9280
TEST_TIME 94 9244
TEST_TIME 95 9276
TEST_TIME 96 9203
TEST_TIME 97 9193
TEST_TIME 98 9182
TEST_TIME 99 9148
TEST_TIME 100 9178
TEST_TIME 101 9190
TEST_TIME 102 9181
TEST_TIME 103 9228
TEST_TIME 104 9261
TEST_TIME 105 9359
TEST_TIME 106 9327
TEST_TIME 107 9309
TEST_TIME 108 9415
TEST_TIME 109 9403
TEST_TIME 110 9460
TEST_TIME 111 9463
TEST_TIME 112 9380
TEST_TIME 113 9332
TEST_TIME 114 9315
TEST_TIME 115 9300
TEST_TIME 116 9249
TEST_TIME 117 9270
TEST_TIME 118 9244
TEST_TIME 119 9214
TEST_TIME 120 9192

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 17-03-2021 22:29:30 to 17-03-2021 22:29:34.

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 1511180 1511180 0 0.00 0 23527 6 0 0
doc_list_biud 1511179 1511179 0 0.00 0 70102 31 0 0
sp_add_invoice_to_stock 4906 4818 88 1.79 54 166402 18452 0 88
sp_cancel_adding_invoice 5866 5866 0 0.00 4 81512 883 0 0
sp_cancel_client_order 1730 1730 0 0.00 4 7947 351 0 0
sp_cancel_customer_reserve 577216 577216 0 0.00 1 70103 64 0 0
sp_cancel_pay_from_customer 657 657 0 0.00 3 6895 94 0 0
sp_cancel_pay_to_supplier 399 399 0 0.00 3 6674 79 0 0
sp_cancel_supplier_invoice 6604 6596 8 0.12 2 18575 925 0 8
sp_cancel_supplier_order 393 393 0 0.00 6 1023623 120563 0 0
sp_cancel_write_off 10315 10315 0 0.00 1 18367 120 0 0
sp_client_order 19649 19649 0 0.00 3 26258 373 0 0
sp_customer_reserve 440294 440294 0 0.00 0 66302 183 0 0
sp_fill_shopping_cart 30170 30170 0 0.00 1 36071 52 0 0
sp_fill_shopping_cart_clo_res 440284 440284 0 0.00 0 49119 14 0 0
sp_get_clo_for_invoice 4808 4808 0 0.00 0 33581 366 0 0
sp_kill_cost_storno 17237 17237 0 0.00 0 17399 61 0 0
sp_kill_qstorno_ret_qs2qd 1171736 1171736 0 0.00 0 70099 35 0 0
sp_kill_qty_storno 616448 616448 0 0.00 0 70102 75 0 0
sp_lock_selected_doc 19943 19943 0 0.00 0 8949 4 0 0
sp_make_cost_storno 26836 26836 0 0.00 0 15055 62 0 0
sp_multiply_rows_for_pdistr 26836 26836 0 0.00 0 7593 35 0 0
sp_multiply_rows_for_qdistr 19649 19649 0 0.00 0 22228 166 0 0
sp_pay_from_customer 6947 6947 0 0.00 4 10132 122 0 0
sp_pay_to_supplier 5557 5557 0 0.00 5 19609 139 0 0
sp_payment_common 12504 12504 0 0.00 1 8662 28 0 0
sp_qd_handle_on_cancel_clo 1730 1730 0 0.00 0 7220 318 0 0
sp_qd_handle_on_invoice_upd_sts 10674 10674 0 0.00 0 21812 375 0 0
sp_qd_handle_on_reserve_upd_sts 9524 9524 0 0.00 0 11920 58 0 0
sp_reserve_write_off 9524 9524 0 0.00 6 18604 200 0 0
sp_supplier_invoice 5279 5279 0 0.00 7 108817 4114 0 0
sp_supplier_order 5259 5259 0 0.00 5 30585 1391 0 0
srv_aggregate_perf_data 88 87 1 1.13 2988 212920 24249 0 1
srv_fill_mon_cache_memory 166 166 0 0.00 886 131266 30104 0 0
srv_find_qd_qs_mism 1057041 1057041 0 0.00 0 23310 5 0 0
srv_make_invnt_saldo 556 556 0 0.00 49 73438 1336 0 0
srv_make_money_saldo 803 803 0 0.00 1 3072 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 181400 451076 359955 0 0
t$perf-abend:sp_add_invoice_to_stock 88 88 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 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 4818 4818 0 0.00 0 51929 204 0 0
t$perf-norm:sp_cancel_adding_invoice 385 385 0 0.00 0 1607 95 0 0
t$perf-norm:sp_cancel_client_order 1730 1730 0 0.00 0 5285 16 0 0
t$perf-norm:sp_cancel_customer_reserve 640 640 0 0.00 0 906 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 657 657 0 0.00 0 4623 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 399 399 0 0.00 0 2665 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 1443 18 0 0
t$perf-norm:sp_cancel_supplier_order 393 393 0 0.00 0 27637 1809 0 0
t$perf-norm:sp_cancel_write_off 994 994 0 0.00 0 4529 11 0 0
t$perf-norm:sp_client_order 19649 19649 0 0.00 0 4554 18 0 0
t$perf-norm:sp_customer_reserve 952 952 0 0.00 0 3579 9 0 0
t$perf-norm:sp_pay_from_customer 6947 6947 0 0.00 0 4635 11 0 0
t$perf-norm:sp_pay_to_supplier 5557 5557 0 0.00 0 9332 11 0 0
t$perf-norm:sp_reserve_write_off 9524 9524 0 0.00 0 6062 11 0 0
t$perf-norm:sp_supplier_invoice 5279 5279 0 0.00 0 37486 30 0 0
t$perf-norm:sp_supplier_order 5259 5259 0 0.00 0 43823 31 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 1236 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 1591 13 0 0
t$perf-norm:srv_make_invnt_saldo 556 556 0 0.00 0 855 27 0 0
t$perf-norm:srv_make_money_saldo 803 803 0 0.00 0 1045 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 5 4 0 0
v_add_invoice_to_stock 9792 9616 176 1.79 0 14683 20 0 176
v_all_customers 36174 36174 0 0.00 0 18 1 0 0
v_all_suppliers 29116 29116 0 0.00 0 34 1 0 0
v_all_wares 39298 39298 0 0.00 0 102 1 0 0
v_cancel_adding_invoice 770 770 0 0.00 0 2777 12 0 0
v_cancel_client_order 3460 3460 0 0.00 0 3024 6 0 0
v_cancel_customer_prepayment 1314 1314 0 0.00 0 4976 9 0 0
v_cancel_customer_reserve 1280 1280 0 0.00 0 1705 7 0 0
v_cancel_payment_to_supplier 798 798 0 0.00 0 6659 14 0 0
v_cancel_supplier_invoice 842 826 16 1.90 0 521 15 0 16
v_cancel_supplier_order 786 786 0 0.00 0 1833 8 0 0
v_cancel_write_off 1988 1988 0 0.00 0 6586 21 0 0
v_max_id_clo_ord 5258 5258 0 0.00 0 139 1 0 0
v_max_id_clo_res 952 952 0 0.00 0 2410 11 0 0
v_max_id_ord_sup 5263 5263 0 0.00 0 11452 8 0 0
v_max_non_paid_invoice 1520 1520 0 0.00 0 134 2 0 0
v_max_non_paid_realizn 3510 3510 0 0.00 0 3507 6 0 0
v_min_id_clo_ord 5258 5258 0 0.00 0 2085 7 0 0
v_min_id_clo_res 952 952 0 0.00 0 1434 10 0 0
v_min_id_ord_sup 5263 5263 0 0.00 0 6987 10 0 0
v_min_non_paid_invoice 5557 5557 0 0.00 0 6746 18 0 0
v_min_non_paid_realizn 6947 6947 0 0.00 0 7582 19 0 0
v_our_firm 9998 9998 0 0.00 0 20 1 0 0
v_reserve_write_off 19048 19048 0 0.00 0 6551 9 0 0
x_lock_depdocs_on_canc_invoice 12049 12049 0 0.00 0 23033 133 0 0
x_lock_depdocs_on_canc_sup_ord 393 393 0 0.00 0 17192 435 0 0
x_make_qstorno_1000_1200 5259 5259 0 0.00 2 30574 1297 0 0
x_make_qstorno_1200_2000 5279 5279 0 0.00 2 103090 3910 0 0
x_make_qstorno_2100_3300 440294 440294 0 0.00 0 66290 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-03-2021 22:29:35 to 17-03-2021 22:29:39.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:27 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:33 18816 8192000000 10260867600 10571255808 935230704 10.246 71 59 119 0 956716848 2548704 18937440
19:58:00 38406 8192000000 10368833664 10685947904 1401308528 14.607 100 88 176 0 1434140720 4585760 28246432
19:58:58 30873 8192000000 10410934160 10734698496 1459118544 15.118 100 88 176 0 1494760816 6820160 28822112
19:59:40 11288 8192000000 10419419632 10745221120 1472365488 15.234 100 88 176 0 1508811088 7734944 28710656
19:59:58 28677 8192000000 10434710832 10763767808 1483855664 15.335 100 90 180 0 1521212000 8306080 29050256
20:00:43 17157 8192000000 10460982704 10793037824 1508641824 15.551 100 92 184 0 1547460464 9239888 29578752
20:01:12 21185 8192000000 10479035744 10818637824 1528702304 15.726 100 82 164 0 1564339920 9628416 26009200
20:01:44 14369 8192000000 10503435792 10849673216 1553192672 15.938 100 79 158 0 1587938768 10122608 24623488
20:02:07 17541 8192000000 10530289248 10885210112 1590612560 16.259 100 77 153 1 1624435472 10485728 23337184
20:02:34 12769 8192000000 10549630208 10911862784 1615339712 16.470 100 78 156 1 1649670464 10547120 23783632
20:02:54 18713 8192000000 10588849952 10952761344 1642465424 16.701 100 76 151 1 1676430048 10901728 23062896
20:03:23 12782 8192000000 10608546272 10973237248 1665696240 16.897 100 86 172 0 1703458448 11927040 25835168
20:03:44 10712 8192000000 10627604272 10994573312 1685457776 17.063 100 81 162 2 1721467888 12423216 23586896
20:04:03 6439 8192000000 10634909520 11004153856 1699238640 17.179 100 77 151 0 1734476080 13153456 22083984
20:04:17 9743 8192000000 10665019008 11033112576 1713443888 17.298 100 87 174 2 1752927280 14090736 25392656
20:04:37 6193 8192000000 10669558592 11041525760 1728458048 17.423 100 87 172 1 1767703184 14643648 24601488
20:04:53 5958 8192000000 10679587504 11055386624 1744036464 17.552 100 85 170 3 1781898752 13907120 23955168
20:05:07 8038 8192000000 10685441664 11065753600 1748115312 17.586 100 85 170 0 1787705344 15050736 24539296
20:05:23 5262 8192000000 10699728336 11073716224 1758846432 17.675 100 90 180 3 1798989392 14996928 25146032
20:05:36 3606 8192000000 10709001792 11083870208 1766326624 17.737 100 84 166 1 1803391856 13822416 23242816
20:05:47 3522 8192000000 10718540384 11093176320 1774288528 17.802 100 86 172 1 1811900656 14261440 23350688
20:05:57 4147 8192000000 10714902272 11099131904 1777165696 17.826 100 80 159 1 1813204752 14269664 21769392
20:06:07 3668 8192000000 10729259888 11108810752 1786225168 17.901 100 90 177 1 1825118832 13688016 25205648
20:06:17 2405 8192000000 10732169840 11113426944 1790679216 17.937 100 84 168 1 1827032656 12777952 23575488
20:06:27 4248 8192000000 10730541376 11116961792 1795659712 17.978 100 77 154 1 1829743408 12719008 21364688
20:06:37 3326 8192000000 10749248192 11135754240 1804561760 18.051 100 78 156 1 1838773232 12700368 21511104
20:06:48 2092 8192000000 10764693520 11148652544 1824521456 18.215 100 92 183 1 1864632448 14570192 25540800
20:06:57 2398 8192000000 10765436976 11152150528 1824170688 18.212 100 84 166 2 1861377472 14054096 23152688
20:07:05 2778 8192000000 10773096272 11158626304 1829238352 18.253 100 94 188 0 1870856448 15014176 26603920
20:07:14 2471 8192000000 10779224288 11162099712 1830163888 18.261 100 91 182 1 1870961008 14894800 25902320
20:07:23 1883 8192000000 10782273488 11167150080 1838513648 18.329 100 90 182 0 1877862816 13702720 25646448
20:07:32 1922 8192000000 10789363216 11174440960 1845733072 18.387 100 93 186 1 1884708928 12936000 26039856
20:07:40 1432 8192000000 10798612208 11182845952 1849159552 18.415 100 92 182 1 1888042128 13674480 25208096
20:07:48 1748 8192000000 10804330416 11191218176 1860100960 18.504 100 91 182 1 1898999680 12223808 26674912
20:07:57 1634 8192000000 10814256512 11198824448 1864561184 18.540 100 92 185 1 1903268480 12378160 26329136
20:08:05 1385 8192000000 10815967968 11205238784 1871930304 18.600 100 93 186 0 1911869440 12651728 27287408
20:08:12 1189 8192000000 10815924976 11205292032 1876805712 18.639 100 95 191 1 1915869024 12114816 26948496
20:08:20 1620 8192000000 10817893152 11208441856 1876695920 18.638 100 90 178 2 1916134944 13726528 25712496
20:08:27 24223 8192000000 10826402560 11215081472 1877857920 18.648 100 79 155 1 1911855440 10765136 23232384
20:08:58 22198 8192000000 10780959456 11203129344 1870626576 18.589 100 32 62 2 1886364496 6055344 9682576
20:09:30 3583 8192000000 10784152736 11209146368 1877397200 18.644 100 42 84 3 1896043280 5916192 12729888
20:09:46 3995 8192000000 10792010176 11209482240 1877714896 18.647 100 39 79 0 1896320544 7882528 10723120
20:09:56 4176 8192000000 10778270832 11208753152 1874725600 18.622 100 23 46 1 1888707968 7447712 6534656
20:10:07 5560 8192000000 10787502608 11213758464 1877719728 18.647 100 23 45 3 1890597456 6828064 6049664
20:10:24 12882 8192000000 10780365120 11213324288 1880641584 18.670 100 20 35 1 1891578400 5729216 5207600
20:10:44 10458 8192000000 10785012736 11218956288 1883889664 18.697 100 21 42 2 1895585312 6100592 5595056
20:11:06 8396 8192000000 10788869424 11221553152 1883924544 18.697 100 19 38 1 1895705280 6243776 5536960
20:11:23 7160 8192000000 10789822768 11223433216 1886877344 18.721 100 18 36 1 1898311648 6054528 5379776
20:11:37 7096 8192000000 10790964144 11226775552 1887555664 18.726 100 20 40 0 1899864256 6584848 5723744
20:11:50 15822 8192000000 10799716864 11232813056 1888605072 18.735 100 13 26 1 1901547872 9400704 3542096
20:12:16 8857 8192000000 10808328128 11238531072 1892276688 18.764 100 14 28 0 1902004352 5779648 3948016
20:12:35 76374 8192000000 10814291728 11248054272 1898083440 18.811 100 24 48 1 1910638176 5662656 6892080
20:14:00 6226 8192000000 10815761952 11250233344 1902714240 18.848 100 27 53 2 1915969760 6482768 6772752
20:14:14 3928 8192000000 10818308608 11252568064 1907961824 18.890 100 29 58 1 1921819360 5543952 8313584
20:14:26 6224 8192000000 10817254960 11251904512 1904923568 18.866 100 23 45 1 1917900576 6162624 6814384
20:14:39 6155 8192000000 10813788944 11255382016 1905696112 18.872 100 28 55 2 1919738512 6386944 7655456
20:14:53 5678 8192000000 10831668960 11263942656 1909779056 18.905 100 34 64 0 1930244496 11791136 8674304
20:15:05 3888 8192000000 10826799152 11263410176 1910737632 18.913 100 28 57 0 1925229232 6127168 8364432
20:15:18 4739 8192000000 10813106128 11252625408 1904902160 18.866 100 28 54 1 1918012176 4831744 8278272
20:15:31 5639 8192000000 10817740576 11253477376 1889784752 18.744 99 25 50 2 1901969296 4769360 7415184
20:15:43 8576 8192000000 10816340784 11255005184 1906469280 18.878 100 25 49 1 1919499376 5365440 7664656
20:16:03 6597 8192000000 10805105264 11240628224 1885720576 18.711 99 15 30 2 1895624288 5209456 4694256
20:16:17 12675 8192000000 10809721152 11246153728 1865040000 18.544 98 21 42 0 1877932288 6945760 5946528
20:16:38 12498 8192000000 10782988544 11218665472 1817998064 18.161 96 17 35 2 1828787232 5440336 5348832
20:16:57 13347 8192000000 10776344192 11205586944 1807005520 18.071 96 22 43 2 1822836736 9727152 6104064
20:17:17 18453 8192000000 10762482480 11194232832 1792414000 17.952 96 13 26 1 1801567584 5621760 3531824
20:17:47 45009 8192000000 10782125920 11199307776 1816447472 18.149 97 35 69 1 1832695984 6033600 10214912
20:18:53 14881 8192000000 10755101024 11182415872 1774433328 17.804 95 24 47 1 1786755648 5037344 7284976
20:19:14 7014 8192000000 10756456720 11160535040 1789625392 17.929 98 27 55 1 1802042848 5132224 7285232
20:19:30 4710 8192000000 10742636848 11171741696 1818601648 18.166 99 33 67 2 1833817808 5135808 10080352
20:19:40 4156 8192000000 10758463824 11180662784 1840856224 18.348 100 43 86 1 1860288064 7439184 11992656
20:19:52 8551 8192000000 10732139040 11151032320 1771488880 17.779 96 27 54 2 1785207504 6062480 7656144
20:20:08 4993 8192000000 10745237744 11165970432 1785035040 17.891 97 28 54 3 1799281712 5640816 8605856
20:20:22 8010 8192000000 10709885840 11132637184 1761500848 17.697 97 22 45 1 1774100848 6297568 6302432
20:20:37 6555 8192000000 10695073248 11110068224 1738773728 17.508 96 24 48 2 1752454864 5989888 7691248
20:20:50 6555 8192000000 10709266480 11121049600 1736563376 17.490 96 29 58 2 1750614240 6184656 7866208
20:21:04 5675 8192000000 10689089504 11098308608 1711201168 17.279 95 39 76 1 1729236048 5394144 12640736
20:21:16 9317 8192000000 10677883296 11085090816 1724101568 17.386 97 16 32 1 1734129776 5328496 4699712
20:21:32 8357 8192000000 10718645136 11123126272 1778598832 17.838 99 33 66 0 1793474176 4913232 9962112
20:21:53 7029 8192000000 10746148896 11158495232 1817596240 18.158 100 29 58 2 1836720384 10182896 8941248
20:22:06 15353 8192000000 10731105104 11153788928 1790498320 17.936 98 21 42 0 1801426144 5074304 5853520
20:22:27 61892 8192000000 10743569648 11172892672 1808462064 18.083 99 14 28 0 1817892832 5643536 3787232
20:23:35 9029 8192000000 10761923776 11189018624 1848385008 18.409 100 33 66 4 1863685024 6406336 8893680
20:23:51 5326 8192000000 10777949376 11197255680 1852110608 18.439 100 47 95 3 1872816096 7941184 12764304
20:24:02 5935 8192000000 10768748912 11190403072 1831597040 18.272 99 30 59 1 1846737104 6536800 8603264
20:24:14 8781 8192000000 10782338080 11201716224 1855652896 18.468 100 25 51 0 1869557824 6551088 7353840
20:24:32 5108 8192000000 10779556320 11204009984 1860302880 18.506 100 40 80 0 1878764848 7073504 11388464
20:24:47 6020 8192000000 10778779536 11209232384 1862895872 18.527 100 23 47 1 1874848320 5527776 6424672
20:25:03 5580 8192000000 10789556432 11211685888 1866806224 18.558 100 20 40 2 1878918112 5371808 6740080
20:25:19 7839 8192000000 10772347328 11211350016 1867763360 18.566 100 23 45 1 1880277360 6276608 6237392
20:25:34 10420 8192000000 10786006704 11214987264 1869331424 18.579 100 26 52 3 1883101504 5550096 8219984
20:25:51 7497 8192000000 10794288800 11218743296 1870420944 18.588 100 18 36 0 1880794448 5422656 4950848
20:26:06 14108 8192000000 10781728272 11220205568 1875296832 18.627 100 20 40 1 1886546784 5777728 5472224
20:26:27 14565 8192000000 10793973824 11228872704 1876643680 18.638 100 16 31 3 1890464464 9810832 4009952
20:26:49 14379 8192000000 10810486768 11233452032 1885684128 18.711 100 13 26 1 1894927808 5524368 3719312
20:27:10 107059 8192000000 10859899264 11273293824 1910989232 18.915 100 43 85 2 1928720976 5409136 12322608
20:29:19 13491 8192000000 10859018336 11289681920 1936204144 19.116 100 50 99 0 1960271744 10222560 13845040
20:29:40 17485 8192000000 10876348080 11302113280 1942486320 19.167 100 51 102 1 1969012368 11175296 15350752
20:30:07 31298 8192000000 10882248928 11316502528 1949692208 19.224 100 51 102 0 1976696496 12633344 14370944
20:30:52 9822 8192000000 10896434336 11322699776 1957771296 19.288 100 47 93 1 1983074816 11868528 13434992
20:31:16 17070 8192000000 10900101920 11326623744 1960911360 19.313 100 56 112 1 1989832688 13176448 15744880
20:31:46 8388 8192000000 10904032976 11327655936 1965159408 19.347 100 62 124 2 1997231888 13784816 18287664
20:32:03 7457 8192000000 10920019872 11331960832 1950268432 19.229 99 60 120 0 1982421968 14854512 17299024
20:32:17 7534 8192000000 10918340144 11338711040 1966483776 19.358 100 57 110 0 2000950960 19124256 15342928
20:32:32 9330 8192000000 10916471968 11338858496 1971533984 19.398 100 62 123 1 2005080208 15842512 17703712
20:32:57 16215 8192000000 10896695024 11331092480 1952296368 19.245 99 53 106 0 1983337088 15913472 15127248
20:33:20 14741 8192000000 10890111616 11327373312 1959175824 19.299 100 40 80 0 1986500496 15600480 11724192
20:33:44 12185 8192000000 10892985488 11332042752 1964969232 19.346 100 46 90 1 1993719088 13869392 14880464
20:34:06 25833 8192000000 10909312864 11344052224 1967260736 19.364 100 52 104 0 2004440288 21499056 15680496
20:34:49 9482 8192000000 10934119872 11357908992 1980124288 19.466 100 57 112 1 2014944160 17470192 17349680
20:35:08 4214 8192000000 10925433984 11350536192 1979440432 19.460 100 62 123 1 2013359456 15997760 17921264
20:35:22 11544 8192000000 10944696768 11367411712 1991859792 19.558 100 65 129 0 2029653856 18656560 19137504
20:35:44 3231 8192000000 10947970816 11373522944 1998336048 19.610 100 75 148 1 2039622928 19633664 21653216
20:35:56 4484 8192000000 10950047552 11375210496 1981119520 19.474 99 76 147 1 2022441024 20200352 21121152
20:36:08 7256 8192000000 10946977536 11372736512 1990109536 19.545 100 66 130 1 2031271072 21511952 19649584
20:36:22 17839 8192000000 10930451520 11359797248 1976133056 19.434 100 65 126 0 2017382672 22343824 18905792
20:36:52 7180 8192000000 10939783616 11373584384 1985070512 19.505 100 50 100 0 2022012592 21624992 15317088
20:37:07 9966 8192000000 10934867536 11368456192 1988443952 19.531 100 49 97 0 2021720816 18760608 14516256
20:37:28 8780 8192000000 10950646272 11381272576 1998721360 19.613 100 70 137 1 2042000304 22058032 21220912
20:37:48 3419 8192000000 10950332368 11384393728 1998581296 19.612 100 60 119 1 2037817600 21644960 17591344
20:38:01 5237 8192000000 10934900896 11365371904 1960089328 19.307 98 57 111 1 1995817632 18975792 16752512
20:38:16 3843 8192000000 10928890224 11363143680 1983676576 19.494 100 61 122 0 2021454720 19296800 18481344
20:38:37 5848 8192000000 10939879952 11363762176 1984577888 19.501 100 75 149 2 2028801168 21781264 22442016
20:38:52 3664 8192000000 10940620992 11359907840 1973651888 19.414 99 76 152 1 2019471600 23432208 22387504
20:39:03 4103 8192000000 10964459744 11382894592 1992669488 19.565 100 80 160 1 2039445248 24168448 22607312
20:39:15 5317 8192000000 10937986304 11361857536 1966343264 19.356 99 73 143 1 2011919568 24710336 20865968
20:39:27 3610 8192000000 10943139680 11370901504 1984406896 19.500 100 63 125 1 2028087632 24639168 19041568
20:39:38 3018 8192000000 10961380464 11376852992 1990845072 19.550 100 87 174 3 2041895168 24782144 26267952
20:39:53 6212 8192000000 10952811664 11380514816 1994153408 19.577 100 63 123 0 2037663984 25257392 18253184
20:40:09 2121 8192000000 10954413584 11375169536 1988036032 19.528 100 68 136 3 2032353952 24166320 20151600
20:40:18 4254 8192000000 10967612528 11382140928 1994078736 19.576 100 81 162 3 2045804496 27385104 24340656
20:40:29 3588 8192000000 10963654208 11385012224 1993491088 19.571 100 75 147 2 2045511632 29952112 22068432
20:40:40 2206 8192000000 10956398784 11373809664 1970910592 19.393 99 77 155 3 2024125072 29703248 23511232
20:40:51 3093 8192000000 10946910768 11368079360 1972891536 19.408 100 76 151 1 2027057840 30216240 23950064
20:41:00 3795 8192000000 10939743872 11358212096 1955090944 19.267 99 82 163 1 2011752928 31291888 25370096
20:41:12 6623 8192000000 10919840288 11349835776 1959649264 19.303 100 68 136 0 2013226624 32492544 21084816
20:41:25 3353 8192000000 10935535760 11362258944 1966272944 19.356 100 63 126 1 2016213792 30230560 19710288
20:41:37 3617 8192000000 10937194432 11365224448 1973308992 19.412 100 77 154 0 2026998656 29425952 24263712
20:41:47 3381 8192000000 10952886752 11378638848 1983451520 19.492 100 77 150 1 2036893152 30689888 22751744
20:42:00 3286 8192000000 10950312976 11379179520 1986190848 19.514 100 66 134 0 2036883712 30147536 20545328
20:42:10 4334 8192000000 10943927104 11377291264 1980914432 19.472 100 73 147 1 2034037904 30355056 22768416
20:42:23 7003 8192000000 10961446880 11383644160 1981166288 19.474 100 79 155 2 2040330080 34730864 24432928
20:42:39 1643 8192000000 10955240320 11380686848 1979481952 19.461 100 69 138 1 2038800592 37190128 22128512
20:42:47 3910 8192000000 10946960608 11365437440 1949000368 19.219 99 77 156 4 2009701312 36759856 23941088
20:42:58 4431 8192000000 10944487296 11368148992 1952325968 19.245 99 69 138 1 2008570976 35072080 21172928
20:43:10 6152 8192000000 10915224480 11337211904 1941283152 19.157 100 81 161 1 2001955472 36096000 24576320
20:43:30 2310 8192000000 10928174752 11344326656 1949927952 19.226 100 73 143 1 2006712384 35460704 21323728
20:43:40 7300 8192000000 10928209504 11352158208 1955272688 19.268 100 83 164 1 2020859184 39688368 25898128
20:44:00 4204 8192000000 10932652160 11346825216 1933891136 19.098 99 80 157 0 1997139792 40052992 23195664
20:44:14 4555 8192000000 10917155120 11340914688 1941345616 19.157 100 61 122 0 1997969344 37505536 19118192
20:44:26 4294 8192000000 10927157008 11348996096 1951451728 19.238 100 72 139 1 2008163488 34956640 21755120
20:44:39 2617 8192000000 10944296320 11361533952 1951273184 19.237 100 77 153 1 2017047776 42265200 23509392
20:44:49 2281 8192000000 10912017840 11322978304 1919708512 18.985 99 73 144 1 1981382224 38995424 22678288
20:44:59 1699 8192000000 10918188448 11337560064 1938967184 19.139 100 64 124 0 1997607840 39001696 19638960
20:45:08 1958 8192000000 10945267968 11353186304 1954564976 19.263 100 89 177 0 2022548992 40496016 27488000
20:45:17 3031 8192000000 10927570976 11336925184 1947796192 19.209 100 83 163 1 2006314384 33923520 24594672
20:45:28 2986 8192000000 10928815776 11341434880 1955505168 19.270 100 83 164 0 2014477824 33834720 25137936
20:45:39 10841 8192000000 10932764256 11347255296 1949911120 19.226 100 70 139 0 2005520736 34150320 21459296
20:45:59 7317 8192000000 10917255552 11340013568 1931267296 19.077 99 65 128 3 1989124464 37285888 20571280
20:46:14 5463 8192000000 10934312720 11358158848 1956327872 19.277 100 67 134 0 2014241056 37165296 20747888
20:46:27 2984 8192000000 10922175648 11338682368 1914604496 18.944 98 84 168 2 1977826688 37200992 26021200
20:46:37 1867 8192000000 10922889488 11336478720 1941521792 19.159 100 85 166 2 2001056432 34758656 24775984
20:46:45 7399 8192000000 10911049104 11337879552 1943154800 19.172 100 61 122 4 1998603792 36550752 18898240
20:47:01 7730 8192000000 10906962096 11334336512 1932707744 19.089 100 38 76 1 1979874480 34623968 12542768
20:47:20 5458 8192000000 10904782336 11327823872 1933634112 19.096 100 66 130 1 1988242560 33239520 21368928
20:47:40 3567 8192000000 10940113984 11354218496 1959042976 19.298 100 84 165 0 2019935632 34929216 25963440
20:47:50 2142 8192000000 10950090432 11361341440 1964752256 19.344 100 84 168 0 2027831232 36875216 26203760
20:48:01 879 8192000000 10941555824 11348365312 1959111872 19.299 100 93 186 1 2021789888 34847184 27830832
20:48:08 8152 8192000000 10938923344 11353038848 1955535984 19.271 100 70 140 2 2013633408 35586400 22511024
20:48:25 1712 8192000000 10951578784 11358134272 1948574448 19.215 99 88 172 0 2016011952 40121136 27316368
20:48:33 3635 8192000000 10953794864 11366916096 1964265664 19.340 100 80 158 1 2029370768 40597936 24507168
20:48:44 2775 8192000000 10941615392 11359592448 1963585408 19.335 100 70 140 0 2023628320 38053952 21988960
20:48:59 4852 8192000000 10936681216 11360673792 1959568768 19.303 100 60 119 1 2016815280 38026944 19219568
20:49:20 6048 8192000000 10914747456 11326562304 1930083984 19.068 99 79 156 0 1992175712 37632464 24459264
20:49:33 1509 8192000000 10948770336 11351470080 1955151872 19.267 100 92 184 2 2022763136 39100864 28510400
20:49:44 3842 8192000000 10951515200 11362304000 1962648400 19.327 100 77 154 0 2028909776 42122672 24138704
20:49:55 1626 8192000000 10962797328 11369242624 1972118240 19.402 100 92 184 0 2044166592 44037648 28010704
20:50:04 3120 8192000000 10954509824 11375419392 1969388272 19.381 100 61 122 1 2034524384 44405424 20730688
20:50:16 5526 8192000000 10944368192 11377274880 1967487696 19.366 100 43 86 1 2025371088 43066480 14816912
20:50:43 9909 8192000000 10958312208 11390062592 1975835008 19.432 100 44 89 1 2037209664 46076096 15298560
20:51:04 6989 8192000000 10963330096 11399000064 1982535264 19.485 100 56 111 1 2047967296 46611888 18820144
20:51:18 1896 8192000000 10972278864 11401617408 1988187792 19.529 100 57 114 0 2053444144 46174608 19081744
20:51:35 14498 8192000000 10973943760 11414429696 1992189808 19.561 100 49 96 1 2059082800 49796432 17096560
20:52:01 13849 8192000000 10973453456 11415871488 1991102688 19.553 100 44 88 1 2055813792 49482912 15228192
20:52:32 12390 8192000000 10968193904 11406352384 1976294448 19.435 100 43 86 1 2047036656 54722880 16019328
20:52:50 14311 8192000000 10965077648 11408519168 1976187168 19.434 100 44 88 2 2049049424 56369248 16493008
20:53:17 13778 8192000000 10951223696 11393368064 1954439296 19.262 100 41 82 0 2033471856 62859440 16173120
20:53:43 8912 8192000000 10960956256 11403124736 1959715920 19.304 100 43 85 1 2044542320 68152496 16673904
20:54:08 8183 8192000000 10963705168 11412033536 1958573056 19.295 100 37 73 1 2044914432 71822432 14518944
20:54:39 18994 8192000000 10963509008 11414462464 1963861808 19.337 100 38 76 2 2040381008 62342960 14176240
20:55:16 7854 8192000000 10942150240 11414048768 1957275536 19.284 100 20 39 2 2025441056 60404688 7760832
20:55:37 40610 8192000000 10924713056 11390275584 1935527536 19.111 99 18 36 1 1993831040 51381744 6921760
20:56:32 74192 8192000000 10883175680 11329368064 1923656800 19.016 98 17 30 1 1950366384 22131824 4577760
20:57:53 56294 8192000000 10915307120 11360669696 1975626864 19.430 100 36 70 1 1991960240 6004464 10328912
20:58:56 16312 8192000000 10882498416 11333054464 1951516672 19.239 100 37 74 0 1971948672 10061488 10370512
20:59:22 94786 8192000000 10908171760 11367161856 1956193104 19.276 99 34 69 1 1976043600 11525568 8324928
21:01:05 71677 8192000000 10900464016 11364892672 1944662960 19.184 98 11 22 1 1958079888 10583888 2833040
21:02:23 25806 8192000000 10902407808 11373551616 1977100832 19.442 100 8 16 1 1991703280 12627424 1975024
21:03:16 54698 8192000000 10912610592 11377876992 1971945552 19.401 99 18 36 2 1993057984 15902544 5209888
21:04:17 57155 8192000000 10918101952 11390033920 1985132080 19.505 100 10 20 0 2004334240 15455040 3747120
21:05:30 57092 8192000000 10904765360 11377799168 1965360992 19.349 99 11 22 0 1984450416 15469808 3619616
21:06:34 67945 8192000000 10912374336 11381215232 1983555648 19.493 100 16 32 1 1996093120 8450416 4087056
21:07:49 56190 8192000000 10919776496 11396591616 1966430352 19.357 99 6 12 0 1983579120 15627856 1520912
21:10:11 123605 8192000000 10916522976 11401883648 1991799968 19.558 100 22 44 0 2018973824 20302368 6871488
21:12:25 91794 8192000000 10925261008 11368730624 1921439936 18.998 96 53 106 2 1945245120 8455840 15349344
21:14:04 53932 8192000000 10924356112 11380133888 1983621840 19.493 100 35 70 3 2005542320 11889168 10031312
21:15:04 67721 8192000000 10896652208 11365576704 1946370816 19.198 98 10 20 0 1959842608 10375616 3096176
21:16:24 53970 8192000000 10889622880 11374612480 1970197856 19.387 100 12 24 0 1986635952 12529024 3909072
21:17:24 42516 8192000000 10900729520 11366514688 1951158752 19.236 99 13 26 0 1962072384 6763504 4150128
21:18:51 74195 8192000000 10883254224 11370045440 1957639568 19.287 99 21 42 0 1973683328 10396688 5647072
21:20:36 69819 8192000000 10890895872 11359776768 1941888592 19.162 98 22 44 1 1959092352 11253072 5950688
21:21:57 78013 8192000000 10865804192 11336892416 1840976608 18.349 93 11 22 0 1854149600 10082288 3090704
21:23:49 40240 8192000000 10897458912 11364130816 1947656672 19.208 99 15 30 0 1964697296 12759552 4281072
21:24:45 21319 8192000000 10898506400 11345997824 1933777184 19.097 99 22 44 1 1955026048 14921120 6327744
21:25:14 80326 8192000000 10883470288 11355885568 1939045696 19.139 99 21 42 2 1958712112 13375088 6291328
21:26:51 64854 8192000000 10855075600 11324649472 1855048352 18.463 95 20 40 0 1870282544 9727136 5507056
21:28:02 54614 8192000000 10878815360 11334803456 1894395264 18.781 97 32 64 0 1916614880 13247344 8972272
21:29:38 131266 8192000000 10876756496 11346173952 1869702528 18.582 96 6 12 0 1887279344 16059552 1517264
21:31:58 79758 8192000000 10873583952 11337883648 1892657344 18.767 97 13 26 0 1909016000 13053440 3305216
21:33:24 51820 8192000000 10880524784 11343310848 1916087520 18.955 98 24 47 3 1932995840 9984144 6924176
21:34:49 60534 8192000000 10887425872 11358859264 1959221520 19.300 100 26 52 0 1979457024 12555056 7680448
21:35:55 73875 8192000000 10887406880 11322662912 1840933632 18.348 94 32 64 1 1860230912 9859840 9437440
21:37:17 39884 8192000000 10885048128 11335282688 1934601328 19.104 99 53 106 1 1961622016 12462800 14557888
21:38:06 40087 8192000000 10865601680 11330887680 1901001424 18.834 98 30 60 0 1919457856 10186576 8269856
21:38:52 26421 8192000000 10852204656 11305136128 1854528512 18.459 96 15 30 0 1866905424 8040624 4336288
21:39:34 97100 8192000000 10835764944 11308163072 1884543216 18.702 98 23 46 3 1899142144 7592352 7006576
21:41:24 57050 8192000000 10862007440 11313545216 1892907968 18.769 98 16 29 2 1904435088 7592544 3934576
21:42:33 61200 8192000000 10837240752 11321925632 1911572960 18.919 99 10 20 0 1926907344 12580352 2754032
21:43:42 30219 8192000000 10838895824 11323015168 1928412880 19.054 100 6 12 0 1938419056 8246720 1759456
21:44:18 12981 8192000000 10841262736 11323895808 1931498192 19.079 100 6 12 1 1941079728 7905248 1676288
21:44:41 33175 8192000000 10868700784 11346526208 1943696560 19.176 100 13 26 2 1955256960 8154320 3406080
21:45:52 80384 8192000000 10880783824 11361591296 1902759504 18.848 97 20 40 1 1928919680 20644464 5515712
21:48:02 60672 8192000000 10864145744 11330838528 1856173200 18.472 95 15 30 0 1875724432 15219584 4331648
21:49:17 39473 8192000000 10876659952 11337867264 1920070128 18.987 99 19 38 0 1937286800 11926208 5290464
21:50:43 58893 8192000000 10839752512 11316600832 1878149152 18.650 97 19 38 1 1897117408 13643776 5324480
21:51:58 85955 8192000000 10857784848 11317657600 1885536064 18.710 97 26 52 0 1901276320 8780480 6959776
21:53:36 39389 8192000000 10873578704 11334520832 1921497248 18.999 99 31 62 1 1940474560 10136208 8841104
21:54:26 28767 8192000000 10872182080 11343028224 1932025408 19.083 99 41 82 3 1954081456 11164592 10891456
21:55:03 68336 8192000000 10879743552 11346898944 1932772160 19.089 99 23 46 1 1948012000 9175216 6064624
21:56:27 68996 8192000000 10858541152 11325657088 1862022768 18.520 95 26 52 1 1883755008 14465104 7267136
21:57:43 66787 8192000000 10889698176 11365683200 1954563696 19.263 100 9 18 0 1970172816 13148624 2460496
22:00:13 82976 8192000000 10892743296 11369168896 1973883104 19.416 100 25 50 0 1992835616 12168016 6784496
22:01:45 56947 8192000000 10880205744 11365150720 1949962816 19.226 99 17 34 4 1965510384 10797648 4749920
22:02:52 37923 8192000000 10878394384 11375325184 1959827552 19.305 100 3 6 0 1972510176 12287472 395152
22:03:36 11771 8192000000 10892413616 11381428224 1966870128 19.361 100 9 18 0 1980688960 11343632 2475200
22:04:06 8606 8192000000 10892720896 11378540544 1970800096 19.392 100 7 14 0 1987929328 14899712 2229520
22:04:24 74097 8192000000 10917673408 11395584000 1976940176 19.440 100 14 28 0 1991853824 10987120 3926528
22:06:00 58268 8192000000 10934969424 11408244736 1981679328 19.478 99 23 44 2 2002366736 13749216 6938192
22:07:05 69993 8192000000 10925815584 11409158144 1938446224 19.134 97 19 38 1 1963546128 19591808 5508096
22:08:39 89186 8192000000 10926021504 11409125376 1952211072 19.244 98 24 48 0 1985869104 26471840 7186192
22:10:39 60626 8192000000 10914214400 11389353984 1950607600 19.231 98 21 42 1 1971392656 14946528 5838528
22:12:28 87964 8192000000 10889908288 11356184576 1878703904 18.655 95 9 18 1 1890536800 9768048 2064848
22:14:03 59377 8192000000 10930138144 11392987136 1964403808 19.341 99 26 52 1 1991132288 18822032 7906448
22:15:14 105363 8192000000 10919593504 11410935808 1918898128 18.978 97 7 14 0 1940710256 19697456 2114672
22:17:08 120625 8192000000 10873564992 11361980416 1874323536 18.619 95 5 10 0 1894614688 19339056 952096
22:19:45 79780 8192000000 10883338608 11346944000 1926016048 19.035 98 31 59 1 1941706064 7660160 8029856
22:21:12 45067 8192000000 10873181856 11340517376 1925353760 19.030 99 23 46 0 1940566256 8475648 6736848
22:22:14 57769 8192000000 10861525296 11340906496 1934571952 19.103 99 9 18 0 1950269808 12978288 2719568
22:23:18 42369 8192000000 10876355584 11356688384 1943179552 19.172 99 10 20 0 1956578128 10462992 2935584
22:25:39 47320 8192000000 10842855456 11321724928 1858700320 18.493 95 18 36 1 1874545456 10352192 5492944
22:26:39 58210 8192000000 9463087232 9780719616 610100560 6.931 32 6 9 1 616726560 5139744 1486256

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 17-03-2021 22:29:41 to 17-03-2021 22:30:13.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 88 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-03-2021 22:30:14 to 17-03-2021 22:30:16.

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          235654
MON$OLDEST_ACTIVE               236104
MON$OLDEST_SNAPSHOT             236104
MON$NEXT_TRANSACTION            236104
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                       2042976
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.33427 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33427 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33427 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33427 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 ---
:28: 
:29: mscs-test-161.budzdorov.ru    Wed Mar 17 22:27:42 2021
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:31: 
:32: 
:33: mscs-test-161.budzdorov.ru    Wed Mar 17 22:27:44 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
--- end of diff output ---

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

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