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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-30 19:27:02
DTS_END                         2020-11-30 19:27:02.5090
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/55898
TRN_ID                          239709
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: 9093.09 20116 1091171
customer order: creation 170.68 376 20481
customer order: refuse 14.57 348 1748
order to supplier: creation 44.58 1446 5349
order to supplier: removal 3.46 103577 415
invoice (draft): creation 44.68 3814 5361
invoice (draft): removal 52.09 848 6251
invoice accept: apply 40.92 18824 4910
invoice accept: cancel 47.57 864 5708
customer reserve: creation 3724.76 187 446971
customer reserve: removal 4655.43 60 558652
realization accept: apply 82.50 214 9900
realization accept: cancel 82.15 108 9858
payment from customer: creation 58.98 128 7077
payment from customer: removal 5.78 91 693
payment to supplier: creation 48.66 167 5839
payment to supplier: removal 3.60 69 432
service: total inventory turnovers 4.81 1288 577
service: total monetary turnovers 7.00 43 840
service: aggregate perf. data 0.88 16503 105
service: refresh index statistics 0.03 253374 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-11-2020 19:28:21 to 30-11-2020 19:28:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6651
TEST_TIME 2 4470
TEST_TIME 3 4133
TEST_TIME 4 4368
TEST_TIME 5 4198
TEST_TIME 6 5446
TEST_TIME 7 5200
TEST_TIME 8 5677
TEST_TIME 9 5537
TEST_TIME 10 5894
TEST_TIME 11 6167
TEST_TIME 12 6455
TEST_TIME 13 6638
TEST_TIME 14 6787
TEST_TIME 15 7086
TEST_TIME 16 7848
TEST_TIME 17 8405
TEST_TIME 18 8598
TEST_TIME 19 8621
TEST_TIME 20 8753
TEST_TIME 21 8649
TEST_TIME 22 9074
TEST_TIME 23 9214
TEST_TIME 24 9425
TEST_TIME 25 9532
TEST_TIME 26 9501
TEST_TIME 27 9756
TEST_TIME 28 9895
TEST_TIME 29 10597
TEST_TIME 30 11048
TEST_TIME 31 10949
TEST_TIME 32 10848
TEST_TIME 33 10846
TEST_TIME 34 10534
TEST_TIME 35 10389
TEST_TIME 36 10319
TEST_TIME 37 10163
TEST_TIME 38 10141
TEST_TIME 39 9965
TEST_TIME 40 9847
TEST_TIME 41 9817
TEST_TIME 42 9823
TEST_TIME 43 9734
TEST_TIME 44 9790
TEST_TIME 45 9603
TEST_TIME 46 9513
TEST_TIME 47 9515
TEST_TIME 48 9424
TEST_TIME 49 9382
TEST_TIME 50 9331
TEST_TIME 51 9396
TEST_TIME 52 9335
TEST_TIME 53 9289
TEST_TIME 54 9342
TEST_TIME 55 9303
TEST_TIME 56 9467
TEST_TIME 57 9467
TEST_TIME 58 9447
TEST_TIME 59 9494
TEST_TIME 60 9464
TEST_TIME 61 9464
TEST_TIME 62 9538
TEST_TIME 63 9524
TEST_TIME 64 9519
TEST_TIME 65 9404
TEST_TIME 66 9347
TEST_TIME 67 9336
TEST_TIME 68 9310
TEST_TIME 69 9260
TEST_TIME 70 9233
TEST_TIME 71 9187
TEST_TIME 72 9211
TEST_TIME 73 9202
TEST_TIME 74 9216
TEST_TIME 75 9211
TEST_TIME 76 9180
TEST_TIME 77 9292
TEST_TIME 78 9307
TEST_TIME 79 9369
TEST_TIME 80 9455
TEST_TIME 81 9458
TEST_TIME 82 9401
TEST_TIME 83 9450
TEST_TIME 84 9503
TEST_TIME 85 9452
TEST_TIME 86 9358
TEST_TIME 87 9371
TEST_TIME 88 9304
TEST_TIME 89 9290
TEST_TIME 90 9250
TEST_TIME 91 9202
TEST_TIME 92 9186
TEST_TIME 93 9183
TEST_TIME 94 9215
TEST_TIME 95 9189
TEST_TIME 96 9208
TEST_TIME 97 9209
TEST_TIME 98 9215
TEST_TIME 99 9245
TEST_TIME 100 9261
TEST_TIME 101 9245
TEST_TIME 102 9342
TEST_TIME 103 9377
TEST_TIME 104 9356
TEST_TIME 105 9395
TEST_TIME 106 9411
TEST_TIME 107 9452
TEST_TIME 108 9475
TEST_TIME 109 9398
TEST_TIME 110 9333
TEST_TIME 111 9308
TEST_TIME 112 9258
TEST_TIME 113 9266
TEST_TIME 114 9244
TEST_TIME 115 9221
TEST_TIME 116 9258
TEST_TIME 117 9205
TEST_TIME 118 9194
TEST_TIME 119 9171
TEST_TIME 120 9094

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 30-11-2020 19:28:24 to 30-11-2020 19:28:28.

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 1506992 1506992 0 0.00 0 24523 7 0 0
doc_list_biud 1506992 1506992 0 0.00 0 62946 29 0 0
sp_add_invoice_to_stock 5038 4910 128 2.54 57 235750 18824 0 128
sp_cancel_adding_invoice 5708 5708 0 0.00 5 71950 864 0 0
sp_cancel_client_order 1748 1748 0 0.00 4 12600 348 0 0
sp_cancel_customer_reserve 558652 558652 0 0.00 1 62954 61 0 0
sp_cancel_pay_from_customer 693 693 0 0.00 2 8433 91 0 0
sp_cancel_pay_to_supplier 432 432 0 0.00 3 1258 69 0 0
sp_cancel_supplier_invoice 6267 6251 16 0.25 2 18492 849 0 16
sp_cancel_supplier_order 415 415 0 0.00 6 866223 103577 0 0
sp_cancel_write_off 9858 9858 0 0.00 1 10520 109 0 0
sp_client_order 20481 20481 0 0.00 3 20114 376 0 0
sp_customer_reserve 446971 446971 0 0.00 0 132214 188 0 0
sp_fill_shopping_cart 31185 31185 0 0.00 1 14392 42 0 0
sp_fill_shopping_cart_clo_res 446970 446970 0 0.00 0 13795 12 0 0
sp_get_clo_for_invoice 4909 4909 0 0.00 0 27616 289 0 0
sp_kill_cost_storno 16691 16691 0 0.00 0 17572 55 0 0
sp_kill_qstorno_ret_qs2qd 1133828 1133828 0 0.00 0 62936 33 0 0
sp_kill_qty_storno 597441 597441 0 0.00 0 62945 71 0 0
sp_lock_selected_doc 20625 20625 0 0.00 0 11488 7 0 0
sp_make_cost_storno 27725 27725 0 0.00 0 24514 70 0 0
sp_multiply_rows_for_pdistr 27725 27725 0 0.00 0 9750 34 0 0
sp_multiply_rows_for_qdistr 20481 20481 0 0.00 0 17146 165 0 0
sp_pay_from_customer 7077 7077 0 0.00 4 11426 128 0 0
sp_pay_to_supplier 5839 5839 0 0.00 5 15426 167 0 0
sp_payment_common 12916 12916 0 0.00 1 11250 35 0 0
sp_qd_handle_on_cancel_clo 1748 1748 0 0.00 0 12594 324 0 0
sp_qd_handle_on_invoice_upd_sts 10617 10617 0 0.00 0 44913 352 0 0
sp_qd_handle_on_reserve_upd_sts 9900 9900 0 0.00 0 16230 69 0 0
sp_reserve_write_off 9900 9900 0 0.00 6 21486 214 0 0
sp_supplier_invoice 5361 5361 0 0.00 6 101463 3815 0 0
sp_supplier_order 5349 5349 0 0.00 5 73616 1447 0 0
srv_aggregate_perf_data 106 105 1 0.94 1960 177641 16503 0 1
srv_fill_mon_cache_memory 163 163 0 0.00 1448 272118 32094 0 0
srv_find_qd_qs_mism 1045199 1045199 0 0.00 0 11068 5 0 0
srv_make_invnt_saldo 577 577 0 0.00 45 80751 1289 0 0
srv_make_money_saldo 840 840 0 0.00 1 10347 44 0 0
srv_recalc_idx_stat 4 4 0 0.00 120302 389453 253375 0 0
t$perf-abend:sp_add_invoice_to_stock 128 128 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 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 4912 4912 0 0.00 0 17492 193 0 0
t$perf-norm:sp_cancel_adding_invoice 415 415 0 0.00 0 5481 145 0 0
t$perf-norm:sp_cancel_client_order 1748 1748 0 0.00 0 3371 17 0 0
t$perf-norm:sp_cancel_customer_reserve 725 725 0 0.00 0 1412 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 693 693 0 0.00 0 8208 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 432 432 0 0.00 0 271 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 376 376 0 0.00 0 7467 32 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 19269 1712 0 0
t$perf-norm:sp_cancel_write_off 1012 1012 0 0.00 0 2644 9 0 0
t$perf-norm:sp_client_order 20481 20481 0 0.00 0 14876 21 0 0
t$perf-norm:sp_customer_reserve 1019 1019 0 0.00 0 4621 13 0 0
t$perf-norm:sp_pay_from_customer 7077 7077 0 0.00 0 4923 7 0 0
t$perf-norm:sp_pay_to_supplier 5840 5840 0 0.00 0 5654 11 0 0
t$perf-norm:sp_reserve_write_off 9900 9900 0 0.00 0 8269 14 0 0
t$perf-norm:sp_supplier_invoice 5361 5361 0 0.00 0 9827 26 0 0
t$perf-norm:sp_supplier_order 5349 5349 0 0.00 0 7324 17 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 481 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 277 3 0 0
t$perf-norm:srv_make_invnt_saldo 577 577 0 0.00 0 3046 24 0 0
t$perf-norm:srv_make_money_saldo 840 840 0 0.00 0 1778 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 16 6 0 0
v_add_invoice_to_stock 10074 9818 256 2.54 0 7917 21 0 256
v_all_customers 37226 37226 0 0.00 0 19 1 0 0
v_all_suppliers 29512 29512 0 0.00 0 18 1 0 0
v_all_wares 40962 40962 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 830 830 0 0.00 0 586 8 0 0
v_cancel_client_order 3496 3496 0 0.00 0 3940 5 0 0
v_cancel_customer_prepayment 1386 1386 0 0.00 0 1510 5 0 0
v_cancel_customer_reserve 1450 1450 0 0.00 0 6136 18 0 0
v_cancel_payment_to_supplier 864 864 0 0.00 0 918 5 0 0
v_cancel_supplier_invoice 784 752 32 4.08 0 3594 26 0 32
v_cancel_supplier_order 830 830 0 0.00 0 1953 7 0 0
v_cancel_write_off 2024 2024 0 0.00 0 1601 14 0 0
v_max_id_clo_ord 5346 5346 0 0.00 0 5098 3 0 0
v_max_id_clo_res 1019 1019 0 0.00 0 1990 15 0 0
v_max_id_ord_sup 5357 5357 0 0.00 0 3422 4 0 0
v_max_non_paid_invoice 1786 1786 0 0.00 0 598 3 0 0
v_max_non_paid_realizn 3800 3800 0 0.00 0 1979 4 0 0
v_min_id_clo_ord 5346 5346 0 0.00 0 5236 12 0 0
v_min_id_clo_res 1019 1019 0 0.00 0 5464 13 0 0
v_min_id_ord_sup 5357 5357 0 0.00 0 8510 8 0 0
v_min_non_paid_invoice 5839 5839 0 0.00 0 9312 29 0 0
v_min_non_paid_realizn 7077 7077 0 0.00 0 8508 18 0 0
v_our_firm 10290 10290 0 0.00 0 22 1 0 0
v_reserve_write_off 19800 19800 0 0.00 0 6136 8 0 0
x_lock_depdocs_on_canc_invoice 11583 11583 0 0.00 0 71579 147 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 11659 404 0 0
x_make_qstorno_1000_1200 5349 5349 0 0.00 1 73608 1354 0 0
x_make_qstorno_1200_2000 5361 5361 0 0.00 3 95116 3669 0 0
x_make_qstorno_2100_3300 446971 446971 0 0.00 0 132213 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-11-2020 19:28:29 to 30-11-2020 19:28:33.

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:06 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:12 27742 8192000000 10278764112 10594996224 1171367680 12.510 90 72 145 0 1197959344 3194704 23396960
16:57:48 33409 8192000000 10349639552 10666336256 1407632896 14.663 100 91 182 0 1442253120 5721504 28898720
16:58:30 9167 8192000000 10366657216 10686803968 1428492080 14.848 100 90 181 0 1464063424 6790912 28780432
16:58:49 9502 8192000000 10378287440 10700500992 1440035952 14.950 100 85 168 1 1474883664 7244464 27603248
16:59:07 4281 8192000000 10381818720 10708013056 1448084320 15.021 100 86 172 0 1483411296 7661728 27665248
16:59:18 31212 8192000000 10417235536 10748674048 1470832320 15.221 100 82 164 0 1505254688 8262944 26159424
16:59:58 10072 8192000000 10432160784 10766209024 1492679472 15.412 100 88 176 1 1529873952 8907024 28287456
17:00:19 10104 8192000000 10455977984 10790264832 1515082608 15.608 100 87 173 0 1551617344 9221744 27312992
17:00:40 23605 8192000000 10490996480 10829242368 1541030688 15.832 100 89 179 0 1578780016 9942080 27807248
17:01:13 13657 8192000000 10505511648 10850852864 1559294752 15.990 100 87 174 1 1597348144 10909424 27143968
17:01:41 13265 8192000000 10528640672 10875527168 1578415120 16.155 100 83 165 2 1614819168 11253664 25150384
17:02:05 13055 8192000000 10548056032 10904387584 1607309120 16.402 100 82 162 1 1643870576 11663088 24898368
17:02:26 10535 8192000000 10572330944 10931290112 1631287136 16.606 100 74 148 0 1664272528 11494096 21491296
17:02:45 9858 8192000000 10593196816 10957086720 1653003568 16.790 100 80 161 0 1688642080 11428848 24209664
17:03:05 12019 8192000000 10612003680 10975444992 1670828896 16.940 100 84 168 0 1708561968 12838656 24894416
17:03:28 10154 8192000000 10623631664 10989174784 1682320128 17.037 100 85 168 2 1720602496 13323856 24958512
17:03:46 7928 8192000000 10636145552 11005677568 1698854496 17.176 100 81 163 2 1735057520 12839696 23363328
17:04:05 7255 8192000000 10658599088 11032903680 1716639392 17.324 100 83 166 1 1753220096 12774672 23806032
17:04:21 8849 8192000000 10679097120 11053703168 1733440272 17.464 100 79 158 1 1769313952 12643120 23230560
17:04:37 5347 8192000000 10681230832 11059445760 1743713360 17.549 100 80 158 0 1779674400 12985840 22975200
17:04:50 6884 8192000000 10695406144 11071156224 1753501776 17.631 100 89 179 2 1792002160 12979136 25521248
17:05:04 5457 8192000000 10699226208 11079172096 1761070960 17.693 100 79 158 0 1797343856 13954448 22318448
17:05:17 3053 8192000000 10706923920 11083784192 1769886176 17.766 100 85 170 1 1806020336 12507344 23626816
17:05:26 4656 8192000000 10711750784 11091275776 1777304912 17.827 100 88 177 1 1815080336 12983072 24792352
17:05:37 3228 8192000000 10723787888 11104362496 1785067248 17.891 100 81 162 2 1821496336 13369440 23059648
17:05:48 3500 8192000000 10735829664 11121090560 1799711072 18.012 100 78 157 0 1833636288 12622192 21303024
17:05:58 2317 8192000000 10744335296 11127144448 1806015248 18.063 100 88 177 2 1843702960 13253040 24434672
17:06:07 3219 8192000000 10749517344 11135926272 1810719824 18.102 100 85 168 2 1847767856 13932400 23115632
17:06:17 1924 8192000000 10761513536 11140657152 1813893872 18.128 100 93 184 2 1853355968 14086800 25375296
17:06:25 2748 8192000000 10764192672 11149582336 1820077552 18.178 100 90 180 0 1859703888 14640976 24985360
17:06:34 1988 8192000000 10760499264 11148816384 1821769584 18.192 100 82 162 0 1856645824 12662976 22213264
17:06:43 8045 8192000000 10768832608 11151155200 1826662544 18.232 100 77 154 0 1860532048 12166352 21703152
17:06:59 5106 8192000000 10766306176 11156430848 1829237888 18.253 100 80 160 1 1865644368 14226256 22180224
17:07:11 1888 8192000000 10784606928 11172966400 1846524944 18.394 100 93 186 0 1887158784 15345776 25288064
17:07:19 1917 8192000000 10797143520 11186982912 1851587872 18.435 100 83 164 2 1888067504 14053760 22425872
17:07:27 1592 8192000000 10794416224 11185999872 1855212704 18.464 100 91 183 1 1896074992 14230720 26631568
17:07:35 2606 8192000000 10806862272 11192504320 1856811920 18.477 100 89 177 0 1893975744 13151360 24012464
17:07:44 1748 8192000000 10812207520 11198939136 1868247824 18.570 100 88 177 0 1906104096 13319744 24536528
17:07:52 1383 8192000000 10809771456 11201204224 1866487008 18.556 100 93 186 2 1906200368 13660896 26052464
17:08:00 1749 8192000000 10815467888 11203141632 1869366448 18.579 100 94 186 0 1909615648 13359968 26889232
17:08:08 1957 8192000000 10815286992 11206643712 1871246576 18.594 100 90 176 1 1909120688 13503744 24370368
17:08:17 1850 8192000000 10816664992 11210014720 1876440192 18.636 100 90 182 2 1915443840 13543840 25459808
17:08:26 7312 8192000000 10815305136 11210719232 1872797584 18.607 100 70 138 0 1905672944 13211840 19663520
17:08:39 1409 8192000000 10820622224 11216674816 1879321072 18.660 100 82 165 1 1916836384 13355568 24159744
17:08:47 30983 8192000000 10792352800 11213312000 1874095040 18.617 100 34 66 0 1891041344 6897248 10049056
17:09:25 8805 8192000000 10800063424 11217432576 1877258752 18.643 100 28 56 0 1891471168 6733840 7478576
17:09:43 8318 8192000000 10783352256 11216728064 1879445024 18.661 100 34 68 1 1896894016 8004944 9444048
17:10:00 3147 8192000000 10807460928 11221106688 1881851392 18.680 100 37 74 0 1900022400 8022256 10148752
17:10:10 5826 8192000000 10788547856 11222511616 1880835824 18.672 100 26 52 1 1899339712 11354576 7149312
17:10:22 5613 8192000000 10797666048 11224891392 1881997248 18.681 100 31 60 1 1902357392 12013632 8346512
17:10:33 6068 8192000000 10789230224 11222650880 1883131040 18.690 100 23 46 2 1895572592 6162960 6278592
17:10:48 5528 8192000000 10791958368 11223470080 1885055856 18.706 100 26 51 0 1898604256 6777264 6771136
17:11:06 8298 8192000000 10795437248 11229466624 1888668640 18.735 100 24 48 2 1902019664 6601360 6749664
17:11:24 11390 8192000000 10810760400 11242475520 1895013712 18.786 100 21 41 3 1905925056 5224752 5686592
17:11:49 10986 8192000000 10796742208 11237720064 1894926864 18.785 100 12 24 0 1903710064 5294624 3488576
17:12:09 10515 8192000000 10804527584 11243536384 1898539168 18.815 100 13 26 0 1908104080 5834176 3730736
17:12:26 11366 8192000000 10803396944 11243950080 1899561376 18.823 100 12 24 2 1908388656 5502928 3324352
17:12:45 14731 8192000000 10810224288 11249664000 1903933776 18.858 100 27 54 2 1917558496 6228976 7395744
17:13:06 61557 8192000000 10828962560 11266150400 1909185952 18.900 100 27 52 2 1925901648 8941488 7774208
17:14:18 17139 8192000000 10826382160 11268960256 1910137440 18.908 100 16 32 1 1921011648 5935504 4938704
17:14:42 4290 8192000000 10829988608 11267416064 1917180144 18.964 100 34 69 0 1932162896 4955072 10027680
17:14:54 6246 8192000000 10834253136 11272183808 1920400880 18.990 100 29 58 1 1934197824 5736976 8059968
17:15:10 7164 8192000000 10827283232 11263946752 1892044112 18.762 99 27 54 0 1914023344 14604624 7374608
17:15:25 7841 8192000000 10825833920 11261124608 1873284368 18.611 98 18 36 0 1888541280 10217008 5039904
17:15:42 7462 8192000000 10821764768 11261755392 1888402656 18.733 99 26 52 1 1906027952 10262176 7363120
17:15:56 7575 8192000000 10814294048 11245629440 1871012960 18.592 98 19 38 1 1881530912 5184320 5333632
17:16:16 5235 8192000000 10799684880 11236720640 1887692096 18.727 100 27 53 6 1901453664 6305136 7456432
17:16:30 6294 8192000000 10787383040 11218399232 1846236400 18.392 98 21 42 3 1857542880 4817360 6489120
17:16:44 9779 8192000000 10763903920 11199041536 1800340800 18.017 96 25 50 1 1814019952 6025776 7653376
17:17:01 9856 8192000000 10769481744 11202248704 1841530256 18.353 99 18 36 1 1852213152 5728816 4954080
17:17:17 11591 8192000000 10784631744 11214942208 1835053744 18.301 98 22 44 1 1851058528 10480144 5524640
17:17:37 8541 8192000000 10769589088 11199029248 1853076176 18.447 100 24 48 1 1865829872 5335424 7418272
17:17:54 26882 8192000000 10753677520 11188862976 1805917840 18.062 97 16 32 1 1816316512 5394400 5004272
17:18:56 25983 8192000000 10739000144 11163762688 1732154000 17.453 93 22 44 0 1743917136 5602112 6161024
17:19:29 9311 8192000000 10733211680 11156140032 1725185952 17.395 94 28 57 3 1743328800 9366720 8776128
17:19:48 4058 8192000000 10731099680 11142754304 1811639344 18.109 100 38 76 0 1828535360 6484672 10411344
17:19:59 4501 8192000000 10712726224 11129733120 1785678352 17.896 99 36 71 2 1802998208 6987024 10332832
17:20:10 5680 8192000000 10682696784 11101315072 1715029456 17.311 96 26 52 0 1729168096 6672096 7466544
17:20:24 7452 8192000000 10668640880 11078115328 1704058832 17.219 96 26 51 3 1716896400 5552352 7285216
17:20:38 5726 8192000000 10698012032 11104849920 1744913408 17.559 98 44 88 1 1767570224 10605072 12051744
17:20:51 7162 8192000000 10681322656 11087527936 1716930880 17.327 96 26 52 0 1730459792 5112528 8416384
17:21:04 7382 8192000000 10703480128 11120713728 1786634384 17.904 100 28 56 2 1801419840 6705008 8080448
17:21:21 10905 8192000000 10735140464 11147411456 1796269664 17.983 99 21 42 0 1809030656 5338576 7422416
17:21:40 8617 8192000000 10739531904 11156979712 1817492240 18.157 100 17 34 0 1827377056 5134656 4750160
17:21:57 8928 8192000000 10751149808 11165712384 1811156720 18.105 99 23 46 1 1823693584 5924480 6612384
17:22:12 8430 8192000000 10754256208 11171209216 1823137616 18.203 99 28 53 1 1835961056 4764000 8059440
17:22:33 6230 8192000000 10745326544 11171647488 1833601712 18.289 100 32 64 2 1848838768 5744880 9492176
17:22:47 59027 8192000000 10753244320 11181522944 1844288256 18.376 100 38 76 0 1860638496 5293936 11056304
17:23:53 8849 8192000000 10771046480 11198394368 1853997904 18.455 100 24 46 1 1867170032 6117904 7054224
17:24:10 10662 8192000000 10771218880 11197153280 1853979168 18.454 100 13 27 0 1863659248 5337728 4342352
17:24:27 7345 8192000000 10773719968 11202732032 1860057440 18.504 100 28 55 3 1874576464 6739776 7779248
17:24:43 5075 8192000000 10785416848 11206242304 1863274576 18.530 100 32 65 0 1879124160 6504448 9345136
17:24:55 8983 8192000000 10802379152 11224129536 1868879248 18.575 100 30 60 1 1887258480 10093968 8285264
17:25:10 6831 8192000000 10802345072 11218546688 1871854960 18.599 100 23 46 1 1884978096 6259872 6863264
17:25:23 7968 8192000000 10793734528 11214700544 1872864960 18.607 100 20 42 1 1883697328 4618528 6213840
17:25:39 8832 8192000000 10783452128 11215351808 1873596912 18.613 100 22 45 0 1885437024 5339776 6500336
17:25:54 8992 8192000000 10781215232 11222466560 1875974464 18.633 100 12 24 1 1884934704 5760128 3200112
17:26:10 10553 8192000000 10793235840 11225706496 1878418240 18.652 100 17 34 1 1888967856 5610160 4939456
17:26:27 7784 8192000000 10802571936 11230461952 1883689008 18.695 100 32 63 1 1898063312 5813072 8561232
17:26:44 12224 8192000000 10792858144 11226693632 1881669488 18.679 100 19 39 1 1892207200 5208320 5329392
17:27:04 27002 8192000000 10826245648 11246292992 1900224096 18.828 100 41 82 1 1917439920 4351488 12864336
17:27:44 22215 8192000000 10841507872 11265949696 1914988320 18.947 100 49 98 1 1936029024 6873200 14167504
17:28:16 12421 8192000000 10847839936 11271032832 1921192896 18.996 100 37 74 1 1938244928 6202560 10849472
17:28:42 15491 8192000000 10871594304 11286396928 1934379408 19.102 100 50 97 3 1956191408 7077312 14734688
17:29:05 109944 8192000000 10867307024 11306160128 1943748416 19.177 100 39 78 3 1965953808 10783216 11422176
17:31:06 14872 8192000000 10885904336 11314540544 1947721152 19.208 100 35 71 0 1967792384 9469472 10601760
17:31:44 15996 8192000000 10893492144 11317358592 1956482864 19.278 100 38 75 3 1978084400 10757312 10844224
17:32:11 27603 8192000000 10903357776 11337887744 1965119424 19.347 100 49 98 0 1992124496 12795552 14209520
17:32:51 22651 8192000000 10905969504 11340759040 1971146448 19.395 100 35 70 1 1995153024 13606528 10400048
17:33:21 19840 8192000000 10906222080 11350429696 1975786016 19.431 100 45 89 1 2003536864 14175456 13575392
17:33:51 6515 8192000000 10893942736 11335127040 1967534912 19.366 100 43 81 3 1991682400 11753888 12393600
17:34:09 19252 8192000000 10910243344 11344998400 1976376000 19.436 100 52 103 1 2003836816 12437680 15023136
17:34:37 6177 8192000000 10941275808 11362717696 1987756416 19.526 100 66 128 2 2022633600 15489584 19387600
17:34:50 5273 8192000000 10934045024 11363651584 1987395248 19.523 100 56 112 0 2021398400 17227216 16775936
17:35:02 14778 8192000000 10909116848 11345281024 1956892496 19.281 99 54 108 1 1993443856 20420256 16131104
17:35:25 3522 8192000000 10919890992 11347120128 1972343232 19.404 100 61 122 1 2009818272 19340080 18134960
17:35:36 6688 8192000000 10932400544 11359105024 1977084560 19.442 100 64 127 0 2017041376 20689248 19267568
17:36:02 9161 8192000000 10926877840 11357229056 1983314864 19.491 100 58 116 0 2021031008 20254960 17461184
17:36:26 11564 8192000000 10931324704 11361095680 1976734544 19.439 100 55 110 1 2014039888 21102880 16202464
17:36:46 4131 8192000000 10925683824 11351678976 1960332112 19.309 99 57 112 1 1998784896 21454256 16998528
17:36:57 7556 8192000000 10937716944 11359465472 1981950208 19.480 100 66 131 0 2025434880 23926736 19557936
17:37:14 8927 8192000000 10949243904 11359379456 1983073104 19.489 100 75 146 2 2030171984 25364992 21733888
17:37:34 7455 8192000000 10943992000 11367211008 1985922096 19.512 100 68 136 1 2030333584 23883888 20527600
17:37:54 7368 8192000000 10945592176 11370344448 1985390992 19.507 100 55 108 0 2025042720 22837120 16814608
17:38:09 9160 8192000000 10935781168 11362107392 1971624640 19.398 99 70 138 2 2015324704 22673504 21026560
17:38:25 5356 8192000000 10945986784 11372052480 1989001648 19.536 100 64 128 0 2031299728 22614176 19683904
17:38:40 2739 8192000000 10951284528 11369443328 1993856416 19.574 100 79 156 1 2038845296 21409504 23579376
17:38:49 2839 8192000000 10932738528 11356471296 1966783600 19.360 99 77 151 2 2011108752 22700928 21624224
17:39:01 1804 8192000000 10955010352 11363725312 1985974912 19.512 100 90 179 2 2036027920 24566928 25486080
17:39:11 4502 8192000000 10937336144 11347066880 1962737568 19.328 99 79 156 3 2007802528 23658208 21406752
17:39:23 4135 8192000000 10948722064 11357753344 1977308304 19.443 100 87 172 1 2027562592 24782256 25472032
17:39:34 1706 8192000000 10951036160 11362390016 1981801904 19.479 100 90 180 0 2034191488 25779200 26610384
17:39:45 5500 8192000000 10937631296 11354632192 1979211856 19.458 100 75 148 2 2025771184 24256832 22302496
17:39:57 4200 8192000000 10939119008 11356463104 1976582816 19.438 100 70 140 2 2022008496 24126880 21298800
17:40:09 5429 8192000000 10936768096 11356168192 1973654224 19.414 100 71 143 0 2019663888 25083344 20926320
17:40:24 1742 8192000000 10947943440 11358130176 1964837664 19.344 99 89 180 1 2018031888 26299920 26894304
17:40:32 2718 8192000000 10945192224 11356631040 1962176160 19.323 99 77 154 1 2013123072 27098912 23848000
17:40:42 3672 8192000000 10946535984 11358826496 1974006992 19.417 100 80 161 1 2027201248 27358576 25835680
17:40:53 3829 8192000000 10887571856 11289329664 1914807056 18.945 98 81 161 1 1966628736 26533984 25287696
17:41:09 8849 8192000000 10901506560 11324194816 1938099952 19.132 100 61 122 1 1985829264 28286672 19442640
17:41:26 5307 8192000000 10914646880 11341893632 1945123696 19.188 100 60 120 0 1998575920 34094224 19358000
17:41:42 5188 8192000000 10928931152 11352842240 1955488240 19.270 100 63 126 0 2011369728 35129568 20751920
17:41:57 9907 8192000000 10929560512 11352416256 1954399680 19.262 100 72 144 0 2012872880 35641840 22831360
17:42:14 12884 8192000000 10931832512 11365023744 1967894480 19.369 100 63 125 1 2024238128 36474288 19869360
17:42:35 4829 8192000000 10945596128 11363246080 1956931936 19.282 99 81 158 4 2015832224 34594704 24305584
17:42:50 1697 8192000000 10946097872 11354910720 1949641936 19.224 99 88 176 0 2013490896 36124608 27724352
17:42:59 4265 8192000000 10945784992 11362410496 1965417328 19.349 100 75 150 1 2027718144 38035968 24264848
17:43:11 2997 8192000000 10923629168 11343486976 1927714896 19.049 98 84 164 1 1991872528 39039792 25117840
17:43:21 3750 8192000000 10941528432 11351195648 1942381520 19.166 99 79 157 2 2006794048 40129696 24282832
17:43:32 4051 8192000000 10933881760 11354681344 1957202992 19.284 100 72 142 1 2016665200 37964112 21498096
17:43:46 3432 8192000000 10947408448 11356639232 1966688160 19.359 100 91 183 2 2029579552 36054912 26836480
17:43:56 1446 8192000000 10943786448 11349536768 1962892976 19.329 100 92 183 2 2026396048 35796480 27706592
17:44:05 2800 8192000000 10932663664 11334946816 1944083168 19.179 99 88 175 1 2006257264 35410848 26763248
17:44:15 2305 8192000000 10956236656 11366293504 1967095616 19.362 100 89 178 0 2030520256 36411008 27013632
17:44:24 2665 8192000000 10947957088 11361964032 1945401376 19.190 99 87 175 0 2011783808 40735648 25646784
17:44:34 3015 8192000000 10916089120 11328163840 1933175328 19.092 99 84 166 1 1996892288 37765840 25951120
17:44:46 2110 8192000000 10917289664 11323781120 1929971312 19.067 100 86 170 0 1991037376 35107424 25958640
17:44:55 1690 8192000000 10925108704 11329343488 1924779344 19.025 99 84 169 1 1985333344 35671120 24882880
17:45:03 2037 8192000000 10933520112 11341287424 1948278960 19.213 100 86 170 4 2008783696 35225744 25278992
17:45:13 6767 8192000000 10894831456 11324682240 1922106416 19.004 99 56 111 0 1974577296 35444960 17025920
17:45:29 7028 8192000000 10911411808 11334238208 1943333936 19.173 100 57 114 2 1992968384 31392704 18241744
17:45:44 4585 8192000000 10896439024 11333496832 1939217328 19.141 100 41 82 1 1983205344 30701040 13286976
17:45:59 1652 8192000000 10904001328 11333836800 1938143760 19.132 100 46 92 0 1985977952 32896016 14938176
17:46:08 10336 8192000000 10905611424 11327664128 1938601808 19.136 100 53 106 1 1989740048 34134512 17003728
17:46:26 9172 8192000000 10918226240 11335036928 1949348000 19.221 100 57 114 2 1996741152 29007056 18386096
17:46:42 1881 8192000000 10907891520 11319689216 1888444528 18.733 97 82 160 2 1943297056 30722224 24130304
17:46:52 5413 8192000000 10910332448 11322732544 1924472480 19.023 99 85 170 2 1984781376 33842128 26466768
17:47:04 2888 8192000000 10924684528 11331928064 1941574704 19.159 100 83 166 2 2001998512 34043696 26380112
17:47:16 3497 8192000000 10905388256 11312291840 1920223616 18.989 99 76 149 0 1978029984 34066784 23739584
17:47:27 5944 8192000000 10909975232 11330101248 1934013504 19.099 100 56 112 0 1987372976 35297056 18062416
17:47:44 5318 8192000000 10900575936 11313938432 1911393072 18.918 99 58 116 2 1963243600 32938016 18912512
17:47:56 6835 8192000000 10905878080 11329142784 1933628848 19.096 100 56 111 0 1990254176 38201808 18423520
17:48:16 3828 8192000000 10921540400 11338113024 1948318944 19.213 100 64 129 1 2004149776 34816144 21014688
17:48:27 1547 8192000000 10950819488 11356131328 1959350640 19.301 100 88 173 3 2026878544 38322560 29205344
17:48:37 4818 8192000000 10957471552 11368140800 1966163568 19.355 100 77 154 2 2031742880 41357888 24221424
17:48:49 2692 8192000000 10957984128 11373248512 1972123568 19.402 100 79 158 1 2040546512 43008896 25414048
17:49:00 8778 8192000000 10942971424 11382890496 1971664160 19.399 100 52 104 1 2031881648 43113632 17103856
17:49:31 11873 8192000000 10934932224 11372384256 1971652400 19.399 100 48 96 0 2025113888 37282368 16179120
17:49:51 20728 8192000000 10930129744 11375620096 1964487728 19.342 100 44 88 0 2015733392 36423520 14822144
17:50:19 14948 8192000000 10934688096 11377704960 1966885216 19.361 100 37 74 2 2013664480 33995104 12784160
17:50:41 7043 8192000000 10927101792 11367448576 1963002352 19.330 100 36 72 1 2010833392 35436080 12394960
17:50:57 7467 8192000000 10933613136 11373731840 1967831952 19.368 100 44 88 3 2016453584 34628592 13993040
17:51:17 13444 8192000000 10931626960 11378180096 1972714288 19.407 100 45 88 1 2018726592 31780320 14231984
17:51:39 8041 8192000000 10932318304 11377549312 1971245520 19.395 100 32 63 0 2015407680 33512064 10650096
17:52:13 13612 8192000000 10936087264 11384995840 1971595648 19.398 100 29 59 1 2016776256 35399936 9780672
17:52:35 8989 8192000000 10926008720 11372240896 1961751200 19.320 100 31 62 2 2011855952 39419232 10685520
17:52:55 18184 8192000000 10912294896 11359150080 1947588944 19.207 99 26 51 0 1993690832 37975600 8126288
17:53:24 4227 8192000000 10937088384 11381882880 1965928448 19.353 100 34 68 0 2019501216 42785712 10787056
17:53:34 14835 8192000000 10931740080 11379085312 1942428848 19.166 99 27 54 4 1997598336 45489376 9680112
17:53:55 32123 8192000000 10925051040 11376631808 1933109808 19.092 99 22 44 2 1998316624 57014096 8192720
17:54:43 25675 8192000000 10930237728 11379195904 1953021456 19.251 100 23 45 2 2009014784 47892672 8100656
17:55:18 48006 8192000000 10932734848 11397267456 1945477984 19.190 100 19 38 0 2003023888 50336848 7209056
17:56:13 30920 8192000000 10914470784 11385212928 1951893312 19.242 100 13 26 0 2004546656 48008096 4645248
17:56:51 30229 8192000000 10889467328 11357368320 1935596736 19.112 99 21 42 2 1964286400 23193664 5496000
17:57:27 57742 8192000000 10876213264 11338821632 1938274128 19.133 99 11 23 0 1956723024 15735792 2713104
17:58:31 37129 8192000000 10884700816 11325800448 1888442816 18.733 96 38 74 3 1903606640 6612320 8551504
17:59:18 74373 8192000000 10887231200 11348393984 1933289312 19.093 99 31 62 0 1954348320 13118704 7940304
18:00:39 83547 8192000000 10903787840 11349692416 1961952832 19.322 100 26 52 1 1977771824 7989856 7829136
18:02:29 104912 8192000000 10913968912 11365621760 1973988800 19.417 100 29 59 0 1990510880 8665792 7856288
18:04:23 53099 8192000000 10892160576 11364319232 1969667248 19.383 99 54 106 1 1993589904 8679664 15242992
18:05:39 66561 8192000000 10899784208 11351814144 1921504576 18.999 97 26 52 2 1938788736 10056192 7227968
18:06:58 272118 8192000000 10907769184 11378950144 1939993888 19.147 98 18 36 0 1961646224 16270416 5381920
18:12:26 104282 8192000000 10893978960 11370700800 1944703440 19.184 98 29 58 1 1963813856 10507120 8603296
18:14:21 32494 8192000000 10891664416 11377651712 1976285952 19.435 100 8 15 0 1987641280 9419408 1935920
18:15:04 30604 8192000000 10895080640 11365879808 1943546992 19.175 98 19 37 4 1962707200 13517456 5642752
18:15:45 43330 8192000000 10896181856 11361529856 1917209280 18.964 97 15 30 2 1933629232 12379920 4040032
18:16:43 41906 8192000000 10878859568 11362041856 1953765936 19.256 100 8 16 0 1976899632 20676688 2457008
18:17:46 23916 8192000000 10883542240 11375423488 1956043456 19.275 100 4 8 0 1976153392 18959408 1150528
18:18:19 67370 8192000000 10891301056 11369951232 1957537152 19.286 99 19 39 0 1974181648 11649920 4994576
18:19:35 30451 8192000000 10901998080 11363946496 1969338208 19.380 100 43 86 1 1994604000 12087888 13177904
18:20:12 15542 8192000000 10918396352 11376852992 1959120496 19.299 99 37 71 1 1983529008 14354304 10054208
18:20:41 56495 8192000000 10907057296 11385921536 1964236016 19.340 99 17 34 0 1985771424 16638560 4896848
18:22:01 62941 8192000000 10891918256 11358793728 1913917584 18.938 97 14 28 0 1935704928 17349168 4438176
18:23:15 48201 8192000000 10889777936 11344277504 1940774544 19.153 99 7 14 0 1955589872 12779856 2035472
18:24:25 44900 8192000000 10895409776 11346464768 1910067040 18.907 97 34 68 2 1931349056 11681360 9600656
18:25:25 42778 8192000000 10899619744 11355357184 1943231232 19.173 99 33 66 2 1965634288 14155664 8247392
18:26:21 91208 8192000000 10898261664 11363627008 1906640816 18.880 96 26 50 1 1923477312 9678272 7158224
18:28:04 55349 8192000000 10892232000 11346456576 1877496848 18.645 95 33 66 0 1905845792 19209424 9139520
18:29:06 60864 8192000000 10855750064 11307913216 1839678912 18.338 94 16 32 0 1854691152 10810000 4202240
18:30:13 37606 8192000000 10877809728 11314503680 1899536752 18.823 98 37 74 0 1918556944 8494000 10526192
18:30:56 8074 8192000000 10860311168 11300593664 1911568864 18.919 99 43 86 1 1932617792 8528640 12520288
18:31:12 98703 8192000000 10833895616 11278405632 1795277888 17.975 93 39 78 0 1815828080 10098352 10451840
18:33:30 62785 8192000000 10839675600 11300794368 1879653728 18.662 98 21 39 1 1893325824 8389008 5283088
18:35:09 40305 8192000000 10861774944 11326885888 1929630928 19.064 100 18 36 1 1946451920 10947936 5873056
18:35:56 72759 8192000000 10817792176 11286204416 1866652544 18.557 96 9 18 0 1879745712 10698352 2394816
18:37:15 38502 8192000000 10847890112 11314921472 1910496000 18.911 99 18 36 2 1925419104 9636544 5286560
18:38:04 63620 8192000000 10858228384 11325591552 1901008976 18.834 98 13 26 1 1916399392 11806544 3583872
18:39:26 80526 8192000000 10873990080 11337314304 1899633552 18.823 98 15 30 0 1913780016 9957648 4188816
18:40:52 70435 8192000000 10887129200 11353661440 1927349600 19.046 99 21 42 1 1951717520 18412000 5955920
18:42:09 40410 8192000000 10853869568 11316256768 1897305568 18.805 97 20 40 4 1915244800 12150576 5788656
18:42:55 48292 8192000000 10876947104 11338190848 1927234656 19.045 99 15 29 0 1949311840 18047408 4029776
18:43:50 79192 8192000000 10896064064 11351224320 1907701792 18.888 98 14 28 2 1934470016 22568544 4199680
18:45:18 73066 8192000000 10884447872 11346509824 1933380480 19.094 99 24 48 0 1955314528 14766784 7167264
18:47:11 139335 8192000000 10878088560 11336962048 1854091488 18.455 95 11 22 1 1872141104 15592080 2457536
18:49:38 34639 8192000000 10907397888 11352621056 1949993424 19.226 100 37 74 0 1971666128 11116000 10556704
18:50:25 42238 8192000000 10899760160 11358687232 1939818256 19.145 99 38 75 0 1964407856 14258080 10331520
18:51:14 35343 8192000000 10890936064 11357044736 1936015312 19.115 99 33 66 2 1959708432 14588928 9104192
18:51:56 98735 8192000000 10900264736 11348791296 1935455520 19.110 99 22 44 0 1952922928 11062336 6405072
18:53:41 70172 8192000000 10889368496 11364651008 1964117584 19.339 100 37 74 0 1984680112 9575104 10987424
18:55:03 36443 8192000000 10895370432 11363721216 1967740832 19.368 100 22 45 1 1982941904 8819488 6381584
18:56:21 53012 8192000000 10872895328 11361091584 1948634992 19.216 99 13 26 1 1960685552 8253536 3797024
18:57:22 31141 8192000000 10872699968 11351490560 1925874768 19.034 98 9 19 0 1934949712 6753632 2321312
18:57:59 75572 8192000000 10905064480 11375845376 1973691360 19.415 100 13 26 1 1986956016 9537904 3726752
18:59:21 66473 8192000000 10890582256 11380273152 1975435072 19.429 100 16 32 0 1993978720 13560512 4983136
19:01:11 65537 8192000000 10889577712 11362488320 1949678480 19.224 99 6 12 0 1957969792 7065648 1225664
19:02:23 62794 8192000000 10906759104 11384049664 1966469856 19.357 99 25 50 1 1987460224 13724288 7266080
19:03:55 56008 8192000000 10906696784 11382095872 1952790016 19.249 99 13 26 0 1972530752 16321904 3418832
19:04:58 63372 8192000000 10899491952 11360325632 1919826624 18.985 97 18 36 1 1944781344 19686896 5267824
19:06:07 62429 8192000000 10877787056 11337547776 1881312656 18.676 96 16 32 0 1903770480 16986976 5470848
19:07:30 25008 8192000000 10885669200 11337035776 1916200896 18.956 98 29 58 1 1933512496 9262176 8049424
19:08:06 31213 8192000000 10902641632 11356745728 1923907872 19.018 98 36 72 1 1948002960 13988112 10106976
19:09:33 98215 8192000000 10888317968 11371094016 1926016224 19.035 98 14 28 0 1945908784 16236304 3656256
19:12:04 56831 8192000000 10909256688 11390267392 1948941120 19.218 98 32 64 4 1972961440 14664944 9355376
19:13:15 50470 8192000000 10934565456 11400200192 1957537600 19.286 99 21 42 0 1980762768 17450448 5774720
19:14:28 52191 8192000000 10902150816 11392245760 1975067712 19.426 100 11 22 0 1997287760 18660480 3559568
19:15:27 96189 8192000000 10918816640 11383087104 1959663072 19.303 99 15 29 2 1983959152 20385088 3910992
19:17:10 75665 8192000000 10873089264 11349151744 1920934400 18.994 97 13 27 0 1931638864 7372720 3331744
19:18:43 42780 8192000000 10893089440 11372847104 1954344288 19.261 99 14 28 0 1971991744 13505584 4141872
19:19:46 69159 8192000000 10865539136 11352363008 1928777136 19.057 98 12 23 0 1945045584 12889152 3379296
19:21:02 70415 8192000000 10884081376 11360940032 1925425952 19.030 98 12 24 1 1941285824 12736160 3123712
19:22:37 92104 8192000000 10863773680 11352252416 1928359456 19.054 98 13 26 0 1942771184 10698640 3713088
19:25:13 75980 8192000000 10859875088 11341234176 1889403600 18.741 97 14 28 1 1900240400 7438176 3398624
19:26:35 30933 8192000000 9400666000 9689800704 535990336 6.141 28 9 18 0 541368704 3221328 2157040

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 30-11-2020 19:28:35 to 30-11-2020 19:29:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 128 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

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

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          239348
MON$OLDEST_ACTIVE               240679
MON$OLDEST_SNAPSHOT             240679
MON$NEXT_TRANSACTION            240679
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                       2038048
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:149: 
:150: mscs-test-161.budzdorov.ru    Mon Nov 30 19:27:09 2020
:151:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:152: 
:153: 
:154: mscs-test-161.budzdorov.ru    Mon Nov 30 19:27:09 2020
:155:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:156: 
--- end of diff output ---

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

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