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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17294860 kB
MemAvailable 31516552 kB
Buffers 0 kB
Cached 14416356 kB
SwapCached 2868 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.7
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-03 01:27:00
DTS_END                         2020-11-03 01:27:00.8430
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36626
TRN_ID                          247525
ATT_ID                          733
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: 9205.08 21117 1104610
customer order: creation 178.53 322 21423
customer order: refuse 15.40 368 1848
order to supplier: creation 48.04 1267 5765
order to supplier: removal 3.18 98705 381
invoice (draft): creation 47.60 3539 5712
invoice (draft): removal 50.81 737 6097
invoice accept: apply 43.23 19104 5187
invoice accept: cancel 46.15 778 5538
customer reserve: creation 3941.48 191 472978
customer reserve: removal 4532.39 53 543887
realization accept: apply 85.91 187 10309
realization accept: cancel 78.47 119 9416
payment from customer: creation 61.04 117 7325
payment from customer: removal 5.84 85 701
payment to supplier: creation 50.73 125 6088
payment to supplier: removal 3.91 83 469
service: total inventory turnovers 4.76 1112 571
service: total monetary turnovers 6.85 31 822
service: aggregate perf. data 0.74 27941 89
service: refresh index statistics 0.03 267480 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 03-11-2020 01:28:28 to 03-11-2020 01:28:31.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5526
TEST_TIME 2 5265
TEST_TIME 3 4994
TEST_TIME 4 5632
TEST_TIME 5 5583
TEST_TIME 6 5836
TEST_TIME 7 6294
TEST_TIME 8 6047
TEST_TIME 9 6240
TEST_TIME 10 6187
TEST_TIME 11 6243
TEST_TIME 12 6534
TEST_TIME 13 6548
TEST_TIME 14 6780
TEST_TIME 15 7259
TEST_TIME 16 7682
TEST_TIME 17 7809
TEST_TIME 18 8196
TEST_TIME 19 8549
TEST_TIME 20 8880
TEST_TIME 21 9135
TEST_TIME 22 9387
TEST_TIME 23 9508
TEST_TIME 24 9407
TEST_TIME 25 9737
TEST_TIME 26 10060
TEST_TIME 27 10897
TEST_TIME 28 10780
TEST_TIME 29 10801
TEST_TIME 30 10756
TEST_TIME 31 10891
TEST_TIME 32 10681
TEST_TIME 33 10521
TEST_TIME 34 10321
TEST_TIME 35 10317
TEST_TIME 36 10265
TEST_TIME 37 10222
TEST_TIME 38 10073
TEST_TIME 39 10142
TEST_TIME 40 10096
TEST_TIME 41 10035
TEST_TIME 42 10259
TEST_TIME 43 10122
TEST_TIME 44 10006
TEST_TIME 45 9994
TEST_TIME 46 9805
TEST_TIME 47 9732
TEST_TIME 48 9693
TEST_TIME 49 9733
TEST_TIME 50 9746
TEST_TIME 51 9768
TEST_TIME 52 9822
TEST_TIME 53 9747
TEST_TIME 54 9708
TEST_TIME 55 9783
TEST_TIME 56 10007
TEST_TIME 57 9955
TEST_TIME 58 9888
TEST_TIME 59 9982
TEST_TIME 60 9957
TEST_TIME 61 10035
TEST_TIME 62 9908
TEST_TIME 63 9823
TEST_TIME 64 9692
TEST_TIME 65 9770
TEST_TIME 66 9692
TEST_TIME 67 9695
TEST_TIME 68 9629
TEST_TIME 69 9613
TEST_TIME 70 9624
TEST_TIME 71 9602
TEST_TIME 72 9579
TEST_TIME 73 9535
TEST_TIME 74 9675
TEST_TIME 75 9696
TEST_TIME 76 9766
TEST_TIME 77 9746
TEST_TIME 78 9795
TEST_TIME 79 9793
TEST_TIME 80 9955
TEST_TIME 81 9969
TEST_TIME 82 9851
TEST_TIME 83 9803
TEST_TIME 84 9744
TEST_TIME 85 9750
TEST_TIME 86 9704
TEST_TIME 87 9640
TEST_TIME 88 9606
TEST_TIME 89 9570
TEST_TIME 90 9518
TEST_TIME 91 9457
TEST_TIME 92 9525
TEST_TIME 93 9514
TEST_TIME 94 9479
TEST_TIME 95 9466
TEST_TIME 96 9575
TEST_TIME 97 9553
TEST_TIME 98 9553
TEST_TIME 99 9519
TEST_TIME 100 9504
TEST_TIME 101 9562
TEST_TIME 102 9571
TEST_TIME 103 9546
TEST_TIME 104 9515
TEST_TIME 105 9625
TEST_TIME 106 9677
TEST_TIME 107 9626
TEST_TIME 108 9556
TEST_TIME 109 9499
TEST_TIME 110 9488
TEST_TIME 111 9507
TEST_TIME 112 9456
TEST_TIME 113 9436
TEST_TIME 114 9412
TEST_TIME 115 9374
TEST_TIME 116 9343
TEST_TIME 117 9311
TEST_TIME 118 9290
TEST_TIME 119 9261
TEST_TIME 120 9210

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 03-11-2020 01:28:32 to 03-11-2020 01:28:36.

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 1544382 1544382 0 0.00 0 20058 6 0 0
doc_list_biud 1544382 1544382 0 0.00 0 35888 25 0 0
sp_add_invoice_to_stock 5340 5187 153 2.86 39 196690 19105 0 153
sp_cancel_adding_invoice 5538 5538 0 0.00 5 46584 778 0 0
sp_cancel_client_order 1848 1848 0 0.00 4 22153 369 0 0
sp_cancel_customer_reserve 543887 543887 0 0.00 1 33011 54 0 0
sp_cancel_pay_from_customer 701 701 0 0.00 2 5338 86 0 0
sp_cancel_pay_to_supplier 469 469 0 0.00 3 4441 83 0 0
sp_cancel_supplier_invoice 6106 6097 9 0.14 2 16897 738 0 9
sp_cancel_supplier_order 381 381 0 0.00 14 1035579 98706 0 0
sp_cancel_write_off 9416 9416 0 0.00 1 18445 119 0 0
sp_client_order 21423 21423 0 0.00 4 28904 322 0 0
sp_customer_reserve 472978 472978 0 0.00 0 123375 192 0 0
sp_fill_shopping_cart 32895 32895 0 0.00 1 16741 38 0 0
sp_fill_shopping_cart_clo_res 472974 472974 0 0.00 0 19369 12 0 0
sp_get_clo_for_invoice 5176 5176 0 0.00 0 29512 291 0 0
sp_kill_cost_storno 16124 16124 0 0.00 0 18439 57 0 0
sp_kill_qstorno_ret_qs2qd 1103668 1103668 0 0.00 0 28456 29 0 0
sp_kill_qty_storno 582649 582649 0 0.00 0 35887 64 0 0
sp_lock_selected_doc 21455 21455 0 0.00 0 9206 7 0 0
sp_make_cost_storno 28895 28895 0 0.00 0 20038 49 0 0
sp_multiply_rows_for_pdistr 28895 28895 0 0.00 0 10764 27 0 0
sp_multiply_rows_for_qdistr 21423 21423 0 0.00 0 15331 141 0 0
sp_pay_from_customer 7325 7325 0 0.00 4 35706 118 0 0
sp_pay_to_supplier 6088 6088 0 0.00 5 12100 125 0 0
sp_payment_common 13413 13413 0 0.00 1 35697 35 0 0
sp_qd_handle_on_cancel_clo 1848 1848 0 0.00 0 22138 341 0 0
sp_qd_handle_on_invoice_upd_sts 10711 10711 0 0.00 0 35887 340 0 0
sp_qd_handle_on_reserve_upd_sts 10309 10309 0 0.00 0 22757 68 0 0
sp_reserve_write_off 10309 10309 0 0.00 6 22814 188 0 0
sp_supplier_invoice 5712 5712 0 0.00 6 85641 3540 0 0
sp_supplier_order 5765 5765 0 0.00 5 30336 1268 0 0
srv_aggregate_perf_data 90 89 1 1.11 2230 477643 27942 0 1
srv_fill_mon_cache_memory 171 171 0 0.00 1203 149173 30615 0 0
srv_find_qd_qs_mism 1056227 1056227 0 0.00 0 15263 6 0 0
srv_make_invnt_saldo 571 571 0 0.00 33 83697 1112 0 0
srv_make_money_saldo 822 822 0 0.00 1 3028 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 145814 505833 267481 0 0
t$perf-abend:sp_add_invoice_to_stock 153 153 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5187 5187 0 0.00 0 16692 192 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 0 2715 78 0 0
t$perf-norm:sp_cancel_client_order 1848 1848 0 0.00 0 2750 11 0 0
t$perf-norm:sp_cancel_customer_reserve 698 698 0 0.00 0 3570 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 701 701 0 0.00 0 408 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 469 469 0 0.00 0 4252 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 409 409 0 0.00 0 3912 33 0 0
t$perf-norm:sp_cancel_supplier_order 381 381 0 0.00 0 25070 1621 0 0
t$perf-norm:sp_cancel_write_off 1054 1054 0 0.00 0 4823 10 0 0
t$perf-norm:sp_client_order 21423 21423 0 0.00 0 11031 19 0 0
t$perf-norm:sp_customer_reserve 1021 1021 0 0.00 0 3665 8 0 0
t$perf-norm:sp_pay_from_customer 7325 7325 0 0.00 0 8618 12 0 0
t$perf-norm:sp_pay_to_supplier 6088 6088 0 0.00 0 6266 12 0 0
t$perf-norm:sp_reserve_write_off 10309 10309 0 0.00 0 9074 12 0 0
t$perf-norm:sp_supplier_invoice 5712 5712 0 0.00 0 4399 18 0 0
t$perf-norm:sp_supplier_order 5765 5765 0 0.00 0 3741 17 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 117 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 171 171 0 0.00 0 5601 41 0 0
t$perf-norm:srv_make_invnt_saldo 571 571 0 0.00 0 3190 32 0 0
t$perf-norm:srv_make_money_saldo 822 822 0 0.00 0 971 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 10652 10346 306 2.87 0 6808 21 0 306
v_all_customers 38294 38294 0 0.00 0 15 1 0 0
v_all_suppliers 31508 31508 0 0.00 0 17 1 0 0
v_all_wares 42846 42846 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 1500 9 0 0
v_cancel_client_order 3696 3696 0 0.00 0 4339 5 0 0
v_cancel_customer_prepayment 1402 1402 0 0.00 0 2929 11 0 0
v_cancel_customer_reserve 1396 1396 0 0.00 0 3531 11 0 0
v_cancel_payment_to_supplier 938 938 0 0.00 0 1464 7 0 0
v_cancel_supplier_invoice 836 818 18 2.15 0 1151 16 0 18
v_cancel_supplier_order 762 762 0 0.00 0 457 5 0 0
v_cancel_write_off 2108 2108 0 0.00 0 7996 22 0 0
v_max_id_clo_ord 5765 5765 0 0.00 0 451 1 0 0
v_max_id_clo_res 1021 1021 0 0.00 0 1572 9 0 0
v_max_id_ord_sup 5707 5707 0 0.00 0 5614 6 0 0
v_max_non_paid_invoice 1806 1806 0 0.00 0 2015 4 0 0
v_max_non_paid_realizn 4175 4175 0 0.00 0 5135 4 0 0
v_min_id_clo_ord 5765 5765 0 0.00 0 2553 6 0 0
v_min_id_clo_res 1021 1021 0 0.00 0 6742 12 0 0
v_min_id_ord_sup 5707 5707 0 0.00 0 6912 9 0 0
v_min_non_paid_invoice 6088 6088 0 0.00 0 10295 21 0 0
v_min_non_paid_realizn 7325 7325 0 0.00 0 16789 17 0 0
v_our_firm 10852 10852 0 0.00 0 16 1 0 0
v_reserve_write_off 20618 20618 0 0.00 0 6575 7 0 0
x_lock_depdocs_on_canc_invoice 11226 11226 0 0.00 0 25529 120 0 0
x_lock_depdocs_on_canc_sup_ord 381 381 0 0.00 0 21971 477 0 0
x_make_qstorno_1000_1200 5765 5765 0 0.00 1 30280 1184 0 0
x_make_qstorno_1200_2000 5712 5712 0 0.00 2 85626 3408 0 0
x_make_qstorno_2100_3300 472978 472978 0 0.00 0 123372 177 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 03-11-2020 01:28:36 to 03-11-2020 01:28:41.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:04 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:10 18597 8192000000 10219706944 10531602432 873802496 9.638 70 47 93 0 891230048 2362384 15065168
22:57:37 22641 8192000000 10326798944 10638868480 1367080240 14.301 100 85 170 0 1399511552 4500512 27930800
22:58:14 11736 8192000000 10348656736 10662473728 1401967040 14.613 100 89 176 3 1437259040 6164288 29127712
22:58:44 30066 8192000000 10392363248 10718584832 1439899536 14.949 100 86 172 0 1475098896 7287744 27911616
22:59:32 17682 8192000000 10408667584 10736549888 1463519136 15.157 100 88 176 0 1500287216 8015456 28752624
22:59:58 20166 8192000000 10423987952 10756669440 1480639808 15.307 100 83 166 1 1515849568 8256624 26953136
23:00:39 11777 8192000000 10449876944 10782990336 1506648160 15.534 100 88 176 0 1543325056 8790816 27886080
23:01:06 14123 8192000000 10472495152 10812157952 1529871520 15.736 100 89 178 0 1567651952 8928688 28851744
23:01:28 16866 8192000000 10491032368 10835443712 1545612304 15.872 100 82 164 1 1581046896 9145312 26289280
23:01:55 16740 8192000000 10518013808 10874134528 1571168864 16.092 100 71 141 0 1601775280 9106928 21499488
23:02:19 10951 8192000000 10557141744 10911985664 1619252592 16.504 100 74 149 0 1650276112 9073648 21949872
23:02:42 13774 8192000000 10583363808 10946457600 1644982080 16.722 100 81 162 1 1679742032 10784784 23975168
23:03:02 9287 8192000000 10601787648 10966687744 1659650400 16.846 100 75 150 1 1693122224 11284592 22187232
23:03:20 11200 8192000000 10610126352 10979266560 1677228960 16.994 100 71 140 2 1708167408 10671888 20266560
23:03:39 7904 8192000000 10627165600 10998067200 1691840160 17.117 100 80 160 2 1726644352 11975008 22829184
23:03:58 7716 8192000000 10664942784 11029037056 1715373568 17.314 100 82 164 2 1751310512 13178560 22758384
23:04:13 6406 8192000000 10662085056 11036925952 1724724656 17.392 100 75 151 0 1758790864 12615152 21451056
23:04:26 5440 8192000000 10662925728 11040251904 1728802208 17.426 100 74 148 1 1761877424 11254336 21820880
23:04:39 6491 8192000000 10675611184 11054800896 1741396624 17.530 100 69 138 2 1776714640 15610336 19707680
23:04:52 3756 8192000000 10692127296 11069624320 1758254688 17.670 100 75 149 2 1789655856 10387840 21013328
23:05:04 5219 8192000000 10703024624 11083067392 1766938992 17.742 100 75 150 1 1800400544 11262352 22199200
23:05:17 4732 8192000000 10723658480 11103162368 1780046112 17.850 100 74 148 2 1811765200 11824096 19894992
23:05:28 3489 8192000000 10731442272 11113656320 1791846688 17.947 100 87 173 1 1829117744 12739888 24531168
23:05:39 2867 8192000000 10745290112 11125145600 1801700768 18.028 100 90 180 1 1840443552 13941408 24801376
23:05:49 2498 8192000000 10742887840 11123785728 1801862864 18.029 100 88 177 2 1841286080 14430656 24992560
23:05:58 3500 8192000000 10754362528 11135569920 1807665648 18.077 100 83 165 0 1844188336 13842192 22680496
23:06:08 3561 8192000000 10761595888 11141861376 1814747168 18.135 100 88 173 0 1852856256 14634864 23474224
23:06:18 2628 8192000000 10767780704 11149451264 1822494880 18.198 100 96 190 0 1863668960 14894752 26279328
23:06:27 6295 8192000000 10764306192 11147603968 1820521248 18.182 100 79 157 2 1856324800 14358256 21445296
23:06:41 4465 8192000000 10756496752 11145515008 1825214080 18.220 100 77 156 0 1860303888 13733488 21356320
23:06:52 1600 8192000000 10783526992 11169607680 1840971968 18.349 100 86 171 0 1879477472 14283328 24222176
23:07:00 1258 8192000000 10792625952 11174420480 1845585328 18.386 100 93 189 2 1886736800 14918592 26232880
23:07:08 2099 8192000000 10795527872 11180294144 1845907712 18.389 100 89 178 1 1885388736 13936736 25544288
23:07:16 2379 8192000000 10791904768 11178553344 1851893088 18.438 100 92 185 2 1889198800 11956208 25349504
23:07:26 1527 8192000000 10800881744 11184926720 1854852976 18.462 100 94 187 3 1894859616 14254128 25752512
23:07:33 1928 8192000000 10801471600 11186790400 1858313296 18.490 100 92 180 1 1898654368 14926944 25414128
23:07:42 1416 8192000000 10809523968 11195203584 1860078320 18.504 100 90 180 1 1899893872 13840768 25974784
23:07:50 1966 8192000000 10795692320 11185618944 1862550560 18.524 100 89 176 1 1901666688 13709648 25406480
23:07:58 1055 8192000000 10814048352 11202023424 1867202224 18.562 100 91 183 1 1907639344 13629488 26807632
23:08:05 2144 8192000000 10812347008 11201257472 1871786000 18.599 100 99 197 3 1913379360 14217232 27376128
23:08:14 1604 8192000000 10822562528 11212935168 1875164288 18.626 100 94 186 1 1915277184 14167584 25945312
23:08:21 4767 8192000000 10790457216 11203612672 1874490240 18.621 100 73 146 3 1908382112 13172816 20719056
23:08:48 10067 8192000000 10788992720 11207053312 1866988736 18.560 100 33 66 0 1888039504 11181568 9869200
23:09:06 1175 8192000000 10807262992 11213840384 1877245136 18.643 100 49 96 0 1900318832 9015616 14058080
23:09:14 5400 8192000000 10801191648 11217260544 1873208864 18.610 100 47 93 5 1898495984 11610736 13676384
23:09:27 8221 8192000000 10794205664 11203788800 1871958752 18.600 100 33 64 0 1888753072 8148160 8646160
23:09:41 6559 8192000000 10780146688 11213475840 1876230368 18.635 100 31 62 2 1892870208 8279344 8360496
23:09:55 8389 8192000000 10784672912 11209289728 1874784064 18.623 100 24 48 1 1887530368 6386064 6360240
23:10:13 11453 8192000000 10781347376 11212713984 1875598704 18.630 100 19 38 2 1886921088 6560080 4762304
23:10:32 6326 8192000000 10790483088 11217436672 1881091520 18.674 100 35 70 4 1898951808 7452608 10407680
23:10:44 13039 8192000000 10786969184 11220713472 1879597232 18.662 100 14 28 0 1889170640 6146368 3427040
23:11:05 9576 8192000000 10794305680 11220238336 1882061488 18.682 100 18 36 2 1893011632 5787616 5162528
23:11:24 8429 8192000000 10785276448 11221041152 1884275152 18.700 100 13 26 0 1893273648 5450912 3547584
23:11:41 9395 8192000000 10792342848 11225026560 1884753376 18.703 100 17 34 1 1895772416 6364464 4654576
23:11:56 18697 8192000000 10792099472 11224498176 1888664992 18.735 100 25 50 2 1902005936 5848512 7492432
23:12:35 61661 8192000000 10800769184 11231842304 1886629008 18.719 100 19 38 2 1897330288 5419440 5281840
23:13:43 3619 8192000000 10813373888 11242004480 1894205472 18.780 100 42 85 0 1914493408 8451152 11836784
23:13:57 5171 8192000000 10812622672 11239546880 1892597824 18.767 100 36 73 3 1908848064 6615680 9634560
23:14:11 6850 8192000000 10806796992 11238965248 1892440416 18.765 100 27 54 0 1905613952 4800432 8373104
23:14:24 7115 8192000000 10806317824 11242090496 1895846320 18.793 100 29 58 0 1910759360 6524032 8389008
23:14:39 5655 8192000000 10817635072 11252957184 1899554576 18.823 100 30 58 2 1918263488 9754016 8954896
23:14:53 3867 8192000000 10817234608 11252637696 1901503088 18.838 100 25 51 3 1915443376 7008800 6931488
23:15:08 8567 8192000000 10808936672 11249156096 1899328976 18.821 100 13 26 2 1912513904 9745088 3439840
23:15:24 6453 8192000000 10803160912 11237076992 1875639504 18.630 99 19 37 1 1887314464 6339600 5335360
23:15:38 10034 8192000000 10793127712 11237892096 1889908672 18.745 100 23 46 0 1902981632 6392384 6680576
23:15:54 8263 8192000000 10800011680 11240230912 1893424864 18.773 100 33 65 4 1908787904 6026944 9336096
23:16:11 6059 8192000000 10792859040 11229659136 1883526656 18.694 100 14 28 1 1893051376 5035696 4489024
23:16:24 7554 8192000000 10784812928 11217612800 1859937760 18.503 99 22 44 2 1872120576 6085744 6097072
23:16:38 10309 8192000000 10783564832 11213983744 1842734656 18.363 98 21 42 1 1854817136 5774352 6308128
23:16:54 33694 8192000000 10758946944 11186585600 1811616592 18.109 97 28 57 1 1825167760 5355744 8195424
23:17:34 41466 8192000000 10743282208 11173548032 1750281968 17.604 94 23 46 0 1762304400 4955696 7066736
23:18:24 10539 8192000000 10757945792 11178631168 1811037840 18.104 98 26 51 3 1824051776 5593056 7420880
23:18:42 5595 8192000000 10736286176 11144806400 1781935424 17.865 98 27 55 1 1794958112 5497936 7524752
23:18:56 4425 8192000000 10720110784 11133698048 1773452816 17.796 97 33 66 2 1789710112 6798432 9458864
23:19:08 5071 8192000000 10700982864 11112103936 1769444560 17.762 98 41 82 1 1789129552 7340688 12344304
23:19:19 2482 8192000000 10697913056 11106201600 1757635184 17.665 98 38 76 0 1776000496 6773456 11591856
23:19:27 7619 8192000000 10711324128 11124490240 1746402880 17.572 97 30 61 0 1762670752 7774464 8493408
23:19:45 4099 8192000000 10707336048 11118862336 1773073392 17.792 99 36 72 1 1791024592 7435904 10515296
23:20:00 6418 8192000000 10703666400 11110772736 1755300832 17.646 98 33 67 2 1770631824 6092000 9238992
23:20:16 7081 8192000000 10710084096 11127062528 1774086672 17.801 98 24 48 4 1786390032 5241968 7061392
23:20:30 6533 8192000000 10710473888 11130667008 1794890592 17.972 99 24 50 3 1808063040 6054128 7118320
23:20:43 8127 8192000000 10713375664 11138007040 1787521664 17.911 99 27 54 4 1801388208 6022608 7843936
23:21:00 6434 8192000000 10721144720 11132432384 1784528992 17.887 99 23 46 0 1797088064 6030688 6528384
23:21:16 9632 8192000000 10728426960 11144744960 1765637664 17.731 97 26 52 2 1779434176 6141680 7654832
23:21:34 12888 8192000000 10731552736 11152629760 1788150144 17.917 98 25 50 1 1801793376 5745184 7898048
23:21:54 69991 8192000000 10732202064 11161169920 1794267840 17.967 98 34 67 0 1808547680 5374176 8905664
23:23:10 7678 8192000000 10743837664 11162898432 1828719648 18.249 100 28 53 5 1842365920 6256928 7389344
23:23:24 9633 8192000000 10750809888 11171729408 1831992176 18.276 100 23 46 1 1844440816 6061744 6386896
23:23:42 5297 8192000000 10764396016 11183493120 1845994480 18.390 100 41 82 2 1865392688 8160608 11237600
23:23:54 6632 8192000000 10763487904 11185868800 1845848096 18.388 100 31 61 0 1861154464 6214384 9091984
23:24:08 6466 8192000000 10764246816 11191476224 1852500656 18.442 100 35 70 2 1869539712 5664224 11374832
23:24:23 5205 8192000000 10762451408 11192143872 1853218208 18.448 100 33 66 4 1868524832 5761360 9545264
23:24:34 7994 8192000000 10752591344 11190042624 1854021872 18.455 100 24 47 3 1866344272 5494544 6827856
23:24:48 12221 8192000000 10758050896 11194712064 1853678592 18.452 100 12 24 1 1862011024 5271952 3060480
23:25:07 12697 8192000000 10763980800 11197005824 1857070192 18.480 100 18 36 1 1868458464 6555280 4832992
23:25:26 10393 8192000000 10765452240 11201359872 1858270800 18.489 100 16 32 1 1868030912 5129552 4630560
23:25:44 11697 8192000000 10777876944 11210432512 1859488016 18.499 100 13 26 1 1872968752 9704576 3776160
23:26:03 16668 8192000000 10782553744 11207856128 1862164240 18.521 100 12 24 2 1870583616 5463840 2955536
23:26:26 9796 8192000000 10779032640 11208314880 1863660112 18.533 100 16 32 1 1874546896 5500096 5386688
23:26:42 53773 8192000000 10791562560 11214266368 1868972912 18.576 100 21 41 3 1880267632 5530816 5763904
23:27:42 29567 8192000000 10823614432 11237888000 1874998112 18.625 99 52 104 0 1896947280 6573152 15376016
23:28:28 10462 8192000000 10821419984 11244847104 1898824832 18.817 100 55 110 2 1922502912 8577712 15100368
23:28:46 2157 8192000000 10833188944 11251556352 1906317472 18.877 100 54 106 2 1930223744 7774096 16132176
23:28:55 22296 8192000000 10841293008 11266809856 1913686480 18.936 100 54 108 1 1936679200 8684608 14308112
23:29:24 2758 8192000000 10858040896 11274838016 1926674480 19.040 100 66 132 3 1954960976 10005216 18281280
23:29:37 24805 8192000000 10863496272 11286482944 1932271776 19.085 100 58 116 1 1959473296 10685696 16515824
23:30:12 9553 8192000000 10874428944 11295162368 1934860800 19.106 100 57 114 1 1962487648 11647840 15979008
23:30:30 21198 8192000000 10879224384 11300106240 1938766080 19.137 100 52 104 3 1964366720 11215856 14384784
23:31:14 16776 8192000000 10867035152 11292889088 1924861536 19.026 99 54 107 2 1955796736 15262928 15672272
23:31:40 18781 8192000000 10870649120 11301421056 1939406880 19.142 100 46 92 1 1965633088 13214096 13012112
23:32:19 16774 8192000000 10881965424 11309666304 1951800464 19.241 100 50 100 3 1978252016 11663120 14788432
23:32:48 20871 8192000000 10877559008 11314147328 1948384080 19.214 100 45 89 2 1974490000 13249216 12856704
23:33:18 6569 8192000000 10888569344 11313561600 1938103216 19.132 99 48 96 3 1968634000 15725568 14805216
23:33:31 10873 8192000000 10906321136 11325505536 1959779648 19.304 100 67 130 3 1996232240 17235968 19216624
23:33:53 13484 8192000000 10903719408 11324223488 1953667616 19.256 100 62 122 3 1990130032 18442048 18020368
23:34:25 9316 8192000000 10905710224 11332288512 1959222448 19.300 100 46 93 2 1990698672 18328400 13147824
23:34:45 9193 8192000000 10892602224 11316498432 1946846368 19.201 99 57 110 0 1980733056 17712976 16173712
23:35:01 4101 8192000000 10922167536 11344646144 1974805296 19.424 100 73 145 2 2012781760 16809664 21166800
23:35:13 12247 8192000000 10917509520 11347419136 1974153104 19.418 100 55 110 1 2008054544 17930240 15971200
23:35:34 6748 8192000000 10929470544 11350728704 1978403744 19.452 100 62 123 1 2015462288 19539664 17518880
23:35:57 9381 8192000000 10921762480 11347185664 1963612240 19.335 99 55 110 0 2000290288 21105440 15572608
23:36:19 2468 8192000000 10924481536 11352395776 1977183328 19.442 100 53 106 3 2014221936 21373072 15665536
23:36:36 2951 8192000000 10924525408 11355045888 1981898864 19.480 100 55 110 0 2020314800 21388816 17027120
23:36:47 2901 8192000000 10930532176 11348951040 1976897920 19.440 100 76 150 3 2019688080 19846256 22943904
23:36:57 5073 8192000000 10946471504 11361398784 1983836080 19.495 100 69 138 0 2025667712 21563456 20268176
23:37:22 9294 8192000000 10933039472 11366813696 1985284336 19.507 100 47 94 0 2022464528 23352912 13827280
23:37:43 6468 8192000000 10931447216 11363123200 1981917952 19.480 100 57 114 0 2022197360 23410032 16869376
23:37:58 4555 8192000000 10926628112 11350380544 1954872672 19.265 98 64 128 2 1998085248 24198656 19013920
23:38:10 15543 8192000000 10952747120 11379322880 1990315840 19.546 100 59 118 0 2034457024 26350928 17790256
23:38:37 2318 8192000000 10948825408 11367096320 1988372384 19.531 100 82 164 0 2038713536 25198288 25142864
23:38:46 4520 8192000000 10955848960 11375943680 1997960928 19.607 100 68 135 2 2044284064 26545520 19777616
23:38:58 4455 8192000000 10934016560 11352113152 1971889936 19.400 99 77 156 0 2023025952 27620768 23515248
23:39:10 1795 8192000000 10965691424 11375742976 1994402608 19.579 100 94 188 3 2049677280 28034224 27240448
23:39:19 2936 8192000000 10963926336 11369521152 1975266928 19.427 99 82 162 1 2027244096 28174000 23803168
23:39:29 6289 8192000000 10967572576 11383914496 1993484704 19.571 100 78 156 1 2049711536 33545088 22681744
23:39:43 2641 8192000000 10937792160 11353509888 1971581056 19.398 99 81 162 0 2024732208 28900592 24250560
23:39:57 3151 8192000000 10938057104 11347296256 1967597600 19.366 100 83 164 2 2021449872 29485984 24366288
23:40:07 2062 8192000000 10960113488 11369926656 1980232832 19.467 100 90 179 1 2038974496 32481616 26260048
23:40:18 6471 8192000000 10951526576 11372425216 1986420112 19.515 100 77 152 2 2042972272 32801808 23750352
23:40:33 6592 8192000000 10921997168 11342069760 1941933984 19.162 98 70 137 5 1996785536 33290992 21560560
23:40:49 3971 8192000000 10919040528 11330113536 1946411776 19.198 99 63 126 1 2000223680 33951376 19860528
23:41:01 6108 8192000000 10939079696 11360337920 1966867072 19.361 100 71 139 3 2025156176 36571040 21718064
23:41:14 1760 8192000000 10939399856 11343159296 1958272944 19.292 100 85 168 3 2018048400 35077072 24698384
23:41:25 3141 8192000000 10932991184 11345117184 1957012576 19.282 100 79 157 2 2018508320 37280048 24215696
23:41:38 4996 8192000000 10922219104 11332976640 1943875088 19.178 100 76 147 1 2003351312 36960144 22516080
23:41:50 1660 8192000000 10930319056 11334971392 1949873952 19.225 100 82 164 1 2013995648 38959056 25162640
23:42:00 1718 8192000000 10949591664 11351953408 1961331392 19.317 100 88 176 1 2027708464 39446000 26931072
23:42:09 1997 8192000000 10918223648 11330211840 1926008880 19.035 98 82 162 1 1991114256 40587504 24517872
23:42:18 1759 8192000000 10943577312 11350188032 1955106896 19.267 100 91 182 1 2026444880 42539328 28798656
23:42:27 5235 8192000000 10937599360 11352850432 1953804416 19.257 100 84 166 0 2026013936 46046800 26162720
23:42:39 2034 8192000000 10942921232 11355635712 1955569264 19.271 100 85 163 0 2024376496 43700624 25106608
23:42:51 2799 8192000000 10948745408 11364360192 1964143920 19.339 100 72 144 0 2031365120 44783728 22437472
23:43:01 3131 8192000000 10940515040 11354165248 1943267984 19.173 99 71 141 3 2007147344 41900576 21978784
23:43:10 4859 8192000000 10926168192 11344023552 1938823680 19.137 99 72 143 0 2004441920 43765920 21852320
23:43:23 7378 8192000000 10914083008 11329773568 1936319584 19.117 99 69 138 1 1999736720 41807936 21609200
23:43:39 3683 8192000000 10929982288 11338960896 1933655024 19.096 99 78 155 2 2001873216 43016272 25201920
23:43:49 5047 8192000000 10925331616 11336765440 1943534560 19.175 100 76 148 1 2008521504 41762960 23223984
23:44:03 3173 8192000000 10936586480 11343089664 1941096464 19.156 100 87 174 2 2013717584 45710560 26910560
23:44:13 3936 8192000000 10941373312 11348926464 1949865280 19.225 100 91 182 0 2024468448 46221856 28381312
23:44:25 3607 8192000000 10933152096 11337207808 1939808304 19.145 99 88 175 1 2013573840 47204768 26560768
23:44:36 3618 8192000000 10940419616 11352797184 1952244560 19.244 100 85 170 1 2027647536 49154432 26248544
23:44:47 2909 8192000000 10947772400 11352428544 1947617264 19.207 100 83 165 3 2023550928 49958256 25975408
23:44:57 5310 8192000000 10947479504 11360980992 1954190848 19.260 100 83 166 0 2028292976 47785024 26317104
23:45:13 5059 8192000000 10924606608 11342000128 1927701104 19.048 99 70 140 0 1996996784 47138800 22156880
23:45:25 3104 8192000000 10940882208 11356401664 1950192752 19.228 100 75 148 4 2020533648 47658976 22681920
23:45:35 3268 8192000000 10953687728 11366973440 1960836736 19.313 100 84 168 0 2035373264 48274368 26262160
23:45:45 2171 8192000000 10959920448 11375661056 1964875440 19.345 100 86 170 1 2041433216 49595280 26962496
23:45:54 2659 8192000000 10957755104 11371171840 1949328272 19.221 99 87 174 3 2028335552 50919008 28088272
23:46:05 1199 8192000000 10940690912 11352473600 1955438624 19.270 100 87 176 1 2025539152 42313040 27787488
23:46:15 6253 8192000000 10938667200 11361333248 1962735040 19.328 100 73 148 1 2027615120 41975872 22904208
23:46:30 1977 8192000000 10929919152 11347124224 1942265968 19.165 99 71 138 1 2007255600 43145408 21844224
23:46:41 7126 8192000000 10928879792 11353288704 1936637632 19.120 99 56 112 1 1998417904 43098800 18681472
23:46:58 5173 8192000000 10931531424 11360813056 1940732512 19.153 99 60 120 0 2009095072 48621984 19740576
23:47:11 9410 8192000000 10928387536 11362181120 1957477328 19.286 100 44 88 0 2012377728 39579904 15320496
23:47:33 2476 8192000000 10928684128 11343958016 1947882384 19.210 100 64 124 1 2008883008 40863664 20136960
23:47:42 2449 8192000000 10946723632 11356196864 1955408960 19.270 100 84 167 0 2023494560 41540976 26544624
23:47:52 7320 8192000000 10933468880 11356102656 1954843328 19.265 100 66 132 2 2015392880 39846288 20703264
23:48:06 4131 8192000000 10942593968 11360301056 1958780576 19.296 100 71 143 2 2021769024 41275632 21712816
23:48:17 5159 8192000000 10959074368 11368042496 1967308352 19.364 100 83 162 3 2036032672 43830448 24893872
23:48:29 3452 8192000000 10961205168 11378036736 1975490256 19.429 100 76 150 3 2043445456 45068320 22886880
23:48:40 4159 8192000000 10961389504 11386212352 1975972752 19.433 100 66 132 1 2042118208 45634816 20510640
23:48:59 12320 8192000000 10941002912 11379220480 1968379840 19.373 100 34 68 1 2021513152 41868992 11264320
23:49:18 7108 8192000000 10912689680 11351961600 1927534528 19.047 98 47 94 2 1983284992 40922832 14827632
23:49:32 5811 8192000000 10905341168 11347509248 1928777248 19.057 99 33 67 2 1973886928 34496496 10613184
23:49:44 10807 8192000000 10905521184 11343224832 1943150592 19.172 100 43 85 2 1989783792 33405920 13227280
23:50:17 23132 8192000000 10919619776 11361710080 1958058608 19.291 100 29 58 0 2004484784 36880112 9546064
23:50:50 9620 8192000000 10929823232 11369279488 1962412464 19.325 100 38 74 2 2007418704 34087360 10918880
23:51:06 14844 8192000000 10925277344 11360735232 1946696176 19.200 99 31 62 0 1992158048 35377152 10084720
23:51:32 19486 8192000000 10908910240 11351396352 1916658528 18.960 98 22 44 0 1965301552 40827216 7815808
23:52:07 28996 8192000000 10899140320 11348828160 1944145728 19.180 100 15 30 0 1987860224 38426464 5288032
23:52:44 57077 8192000000 10891480704 11346132992 1918857072 18.978 99 23 46 0 1969521280 42422240 8241968
23:53:57 34765 8192000000 10869017152 11336339456 1904202288 18.860 98 19 38 0 1945655984 36052768 5400928
23:54:38 33543 8192000000 10896220688 11332644864 1905491696 18.870 98 38 75 1 1935533808 18436528 11605584
23:55:19 4168 8192000000 10898241216 11339149312 1949750848 19.224 100 48 96 0 1976753936 13117824 13885264
23:55:30 20198 8192000000 10890136208 11344699392 1930565040 19.071 99 26 52 2 1960308112 22320272 7422800
23:56:00 33426 8192000000 10877396032 11341877248 1930053584 19.067 99 12 24 1 1951330768 17369424 3907760
23:57:17 37881 8192000000 10916713472 11368681472 1965061792 19.346 100 33 63 1 1990437440 16809248 8566400
23:58:02 29294 8192000000 10903700576 11363213312 1956746848 19.280 99 15 30 1 1978300272 17436912 4116512
23:58:37 98697 8192000000 10910015632 11371200512 1965392896 19.349 99 19 38 0 1977793056 7533552 4866608
00:00:25 76461 8192000000 10902084304 11350757376 1960620944 19.311 99 26 52 1 1975490576 7108768 7760864
00:01:52 17840 8192000000 10916004240 11370172416 1985679248 19.510 100 37 73 2 2003185264 7353872 10152144
00:02:19 74331 8192000000 10923128224 11377651712 1956211600 19.276 98 36 72 0 1978249376 11834112 10203664
00:03:42 20763 8192000000 10929946160 11381293056 1980715920 19.470 99 46 90 2 2002590928 9228304 12646704
00:04:09 149173 8192000000 10886306208 11354468352 1848502352 18.410 92 42 84 0 1872096656 12018560 11575744
00:06:45 25185 8192000000 10905253072 11371020288 1972809936 19.408 100 12 24 0 1989424784 12651888 3962960
00:07:21 10914 8192000000 10920377968 11378020352 1990553872 19.548 100 29 57 3 2008756800 9172176 9030752
00:07:38 57746 8192000000 10938110176 11392602112 1985440864 19.508 99 47 94 1 2014436864 15534000 13462000
00:08:57 48523 8192000000 10907315392 11389382656 1979488752 19.461 100 19 38 2 2007138016 22126512 5522752
00:09:59 118466 8192000000 10910262880 11368030208 1901957840 18.842 95 26 51 0 1916720736 7746320 7016576
00:12:12 44916 8192000000 10898475936 11380772864 1985897072 19.511 100 5 10 0 1996419840 8907472 1615296
00:13:07 54328 8192000000 10900045920 11365564416 1954912448 19.266 98 23 47 1 1971641200 9756048 6972704
00:14:09 74238 8192000000 10899500864 11382755328 1986845376 19.519 100 10 20 0 2002462688 12946272 2671040
00:15:47 46231 8192000000 10893928352 11379294208 1920544944 18.991 97 9 18 1 1941242864 18245648 2452272
00:16:39 50194 8192000000 10894812784 11371380736 1950522320 19.231 99 12 24 0 1965773792 11949264 3302208
00:17:35 43289 8192000000 10885444352 11360194560 1936313456 19.117 98 15 30 1 1956082192 15254592 4514144
00:18:32 56863 8192000000 10878694672 11359203328 1944818480 19.185 99 14 28 2 1963555744 14359488 4377776
00:19:43 25459 8192000000 10890117824 11340812288 1914844560 18.946 97 36 68 3 1929750672 5771312 9134800
00:20:19 29055 8192000000 10885939200 11347869696 1932226640 19.085 98 43 86 0 1956225472 12105152 11893680
00:20:59 54722 8192000000 10909025632 11368820736 1934092928 19.100 98 32 64 0 1959343744 16840336 8410480
00:22:02 27551 8192000000 10906904544 11389874176 1973839392 19.416 100 18 35 0 2002329344 23189888 5300064
00:22:55 118072 8192000000 10884326896 11348287488 1866707248 18.558 95 14 28 1 1883531040 13035488 3788304
00:24:59 20155 8192000000 10888137168 11342032896 1931483760 19.079 99 31 61 1 1947575920 7788000 8304160
00:25:28 66403 8192000000 10874937040 11334533120 1890419088 18.749 97 39 79 2 1915622544 13813760 11389696
00:26:42 66326 8192000000 10875759104 11333095424 1868032544 18.568 96 28 56 0 1890873056 15707824 7132688
00:27:54 44601 8192000000 10890874720 11351302144 1931369024 19.078 99 22 44 1 1952415808 15059856 5986928
00:28:49 93926 8192000000 10891088272 11324690432 1861628496 18.516 95 30 60 0 1877650720 7752384 8269840
00:30:35 88813 8192000000 10859807648 11319996416 1890600448 18.751 97 27 54 1 1915641184 17732096 7308640
00:32:21 39644 8192000000 10857056576 11333582848 1935816336 19.113 100 12 24 0 1949751856 10986464 2949056
00:33:07 61434 8192000000 10862253392 11330781184 1922730896 19.009 99 10 20 0 1933649120 7936096 2982128
00:34:14 39546 8192000000 10836845840 11314368512 1917190304 18.964 99 4 8 0 1928977456 10507648 1279504
00:35:00 53578 8192000000 10833268288 11308412928 1847177152 18.399 96 6 11 1 1859966384 11009824 1779408
00:36:00 92639 8192000000 10850434784 11312906240 1853960256 18.454 96 17 34 0 1869698304 10957840 4780208
00:37:44 33942 8192000000 10859295232 11322322944 1935057088 19.107 100 38 76 2 1954476256 8288480 11130688
00:38:38 53361 8192000000 10888759776 11348848640 1906538592 18.879 98 26 50 0 1923519840 10010848 6970400
00:39:39 67422 8192000000 10895321808 11361325056 1956623376 19.279 100 21 42 0 1976384288 13768288 5992624
00:40:54 50359 8192000000 10890948624 11372724224 1962456448 19.326 100 16 32 1 1979558464 12515904 4586112
00:41:59 132924 8192000000 10889010224 11365654528 1870515472 18.588 95 11 22 0 1887144304 13561568 3067264
00:44:20 76230 8192000000 10899284928 11375730688 1955501392 19.270 100 12 24 1 1979834816 20978304 3355120
00:45:42 83491 8192000000 10919801488 11380510720 1933762848 19.097 98 20 39 1 1955023360 16219040 5041472
00:47:14 87874 8192000000 10906923344 11396677632 1948207680 19.212 99 8 14 2 1973225696 22868768 2149248
00:48:49 93078 8192000000 10897271488 11360870400 1946435744 19.198 99 16 32 1 1966383040 15789024 4158272
00:50:40 19987 8192000000 10911907984 11366715392 1962822080 19.328 99 61 122 2 1989490336 8434912 18233344
00:51:06 17875 8192000000 10916619760 11374141440 1976967488 19.441 100 41 82 0 1998196832 10315824 10913520
00:51:46 19046 8192000000 10911979808 11373551616 1958825904 19.297 99 34 68 1 1979076992 10920848 9330240
00:52:19 22399 8192000000 10893353120 11382644736 1981896688 19.480 100 32 64 0 2002565056 11357296 9311072
00:52:59 60991 8192000000 10887938944 11360665600 1916720656 18.961 97 11 22 0 1927482656 7421440 3340560
00:54:06 40368 8192000000 10863844160 11342127104 1926499056 19.039 98 15 29 0 1938130608 7226592 4404960
00:55:01 26598 8192000000 10867015616 11343134720 1936205488 19.116 99 14 28 1 1948911632 8452240 4253904
00:55:35 59620 8192000000 10861778640 11341742080 1913406656 18.934 98 9 18 0 1926134416 10192656 2535104
00:56:41 49561 8192000000 10890061904 11360751616 1961807024 19.320 100 18 35 0 1978326944 11729552 4790368
00:57:38 56893 8192000000 10897738320 11369291776 1959131360 19.299 99 21 42 0 1977668272 12267136 6269776
00:59:21 127558 8192000000 10888314208 11379347456 1891893904 18.761 96 22 44 2 1914991680 16453808 6643968
01:01:34 85973 8192000000 10903307472 11378540544 1934341328 19.102 98 5 10 1 1963086064 27021952 1722784
01:03:17 62946 8192000000 10900040848 11395051520 1955095184 19.267 99 7 14 1 1975371024 17704560 2571280
01:04:40 32833 8192000000 10921622240 11382562816 1981415328 19.476 100 31 62 0 1999274464 9435232 8423904
01:05:22 53825 8192000000 10909138224 11362893824 1890815280 18.752 95 23 46 0 1906755936 9615760 6324896
01:06:26 53827 8192000000 10916661984 11372756992 1943133216 19.172 98 38 76 0 1966545744 13018544 10393984
01:07:28 81537 8192000000 10893544576 11366764544 1838961152 18.332 93 22 44 0 1865480416 20435712 6083552
01:10:19 74625 8192000000 10919641888 11382050816 1933456976 19.095 98 29 58 1 1955670624 14302288 7911360
01:11:40 24540 8192000000 10924049760 11376717824 1959876480 19.305 99 38 76 2 1989376096 17769744 11729872
01:12:15 57384 8192000000 10891499120 11387944960 1941514752 19.159 99 14 28 1 1970225584 24073488 4637344
01:15:09 116409 8192000000 10883843872 11350188032 1910870704 18.914 97 25 50 1 1928210304 10012848 7326752
01:17:53 74637 8192000000 10859769680 11348287488 1903307904 18.853 97 10 20 0 1919873488 13478896 3086688
01:19:18 44363 8192000000 10839142816 11323707392 1865844832 18.551 96 5 10 0 1878343360 11242912 1255616
01:20:14 35830 8192000000 10854315664 11328032768 1912560304 18.927 99 24 48 0 1926978832 7246096 7172432
01:20:56 55211 8192000000 10819865280 11283369984 1860044864 18.504 96 21 42 0 1874368848 8239104 6084880
01:22:22 36414 8192000000 10841698400 11318185984 1894424192 18.781 98 23 47 0 1908431744 7495152 6512400
01:23:10 85597 8192000000 10840475248 11317772288 1901718560 18.840 98 14 29 1 1915054432 8776528 4559344
01:24:50 101457 8192000000 10835332784 11307581440 1783243168 17.876 92 13 26 1 1795055312 8553408 3258736
01:26:47 20796 8192000000 9250704336 9518710784 416287760 4.835 22 7 10 2 423745328 5367184 2090384

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 03-11-2020 01:28:42 to 03-11-2020 01:29:15.

Exceptions occured during test was in run

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

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

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          246830
MON$OLDEST_ACTIVE               247928
MON$OLDEST_SNAPSHOT             247928
MON$NEXT_TRANSACTION            247928
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                       2050272
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33383 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33383 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33383 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33383 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 ---
:271: 
:272: mscs-test-161.budzdorov.ru    Tue Nov  3 01:27:10 2020
:273:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:274: 
:275: 
:276: mscs-test-161.budzdorov.ru    Tue Nov  3 01:27:10 2020
:277:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:278: 
:279: 
:280: mscs-test-161.budzdorov.ru    Tue Nov  3 01:27:11 2020
:281:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:282: 
--- end of diff output ---

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

03.11.20 01:29:19. 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-03 01:29:21 No severe PSQL-related problems occured
03.11.20 01:29:22. End of report.