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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-13 01:27:19
DTS_END                         2021-02-13 01:27:19.0750
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/50902
TRN_ID                          236783
ATT_ID                          647
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9507.24 17114 1140869
customer order: creation 173.83 339 20860
customer order: refuse 14.42 318 1730
order to supplier: creation 45.99 1130 5519
order to supplier: removal 3.43 110163 411
invoice (draft): creation 45.38 3145 5445
invoice (draft): removal 54.66 729 6559
invoice accept: apply 41.50 17326 4980
invoice accept: cancel 49.88 737 5986
customer reserve: creation 3863.47 169 463616
customer reserve: removal 4903.63 61 588435
realization accept: apply 83.57 191 10028
realization accept: cancel 98.26 105 11791
payment from customer: creation 58.12 114 6974
payment from customer: removal 5.63 79 675
payment to supplier: creation 49.53 125 5944
payment to supplier: removal 3.46 69 415
service: total inventory turnovers 4.88 1055 586
service: total monetary turnovers 6.77 26 812
service: aggregate perf. data 0.83 17005 99
service: refresh index statistics 0.03 189386 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 13-02-2021 01:29:07 to 13-02-2021 01:29:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7212
TEST_TIME 2 6459
TEST_TIME 3 6261
TEST_TIME 4 7137
TEST_TIME 5 6099
TEST_TIME 6 5706
TEST_TIME 7 5660
TEST_TIME 8 5357
TEST_TIME 9 5454
TEST_TIME 10 5787
TEST_TIME 11 5794
TEST_TIME 12 6052
TEST_TIME 13 6480
TEST_TIME 14 6860
TEST_TIME 15 6898
TEST_TIME 16 7473
TEST_TIME 17 7465
TEST_TIME 18 7540
TEST_TIME 19 8144
TEST_TIME 20 8503
TEST_TIME 21 9006
TEST_TIME 22 8804
TEST_TIME 23 8997
TEST_TIME 24 9405
TEST_TIME 25 9487
TEST_TIME 26 10259
TEST_TIME 27 10550
TEST_TIME 28 11213
TEST_TIME 29 11286
TEST_TIME 30 11096
TEST_TIME 31 11081
TEST_TIME 32 10887
TEST_TIME 33 10826
TEST_TIME 34 10963
TEST_TIME 35 10918
TEST_TIME 36 10759
TEST_TIME 37 10508
TEST_TIME 38 10628
TEST_TIME 39 10586
TEST_TIME 40 10408
TEST_TIME 41 10357
TEST_TIME 42 10316
TEST_TIME 43 10175
TEST_TIME 44 10240
TEST_TIME 45 10244
TEST_TIME 46 10147
TEST_TIME 47 10174
TEST_TIME 48 10121
TEST_TIME 49 9957
TEST_TIME 50 10017
TEST_TIME 51 10027
TEST_TIME 52 10017
TEST_TIME 53 10076
TEST_TIME 54 10154
TEST_TIME 55 10178
TEST_TIME 56 10203
TEST_TIME 57 10104
TEST_TIME 58 10197
TEST_TIME 59 10265
TEST_TIME 60 10256
TEST_TIME 61 10345
TEST_TIME 62 10293
TEST_TIME 63 10207
TEST_TIME 64 10091
TEST_TIME 65 10132
TEST_TIME 66 10122
TEST_TIME 67 10103
TEST_TIME 68 10000
TEST_TIME 69 9959
TEST_TIME 70 9952
TEST_TIME 71 9863
TEST_TIME 72 9830
TEST_TIME 73 9809
TEST_TIME 74 9781
TEST_TIME 75 9736
TEST_TIME 76 9774
TEST_TIME 77 9734
TEST_TIME 78 9707
TEST_TIME 79 9714
TEST_TIME 80 9816
TEST_TIME 81 9852
TEST_TIME 82 9902
TEST_TIME 83 9859
TEST_TIME 84 9825
TEST_TIME 85 9857
TEST_TIME 86 9906
TEST_TIME 87 9960
TEST_TIME 88 9992
TEST_TIME 89 9896
TEST_TIME 90 9846
TEST_TIME 91 9818
TEST_TIME 92 9821
TEST_TIME 93 9776
TEST_TIME 94 9709
TEST_TIME 95 9691
TEST_TIME 96 9688
TEST_TIME 97 9640
TEST_TIME 98 9639
TEST_TIME 99 9685
TEST_TIME 100 9726
TEST_TIME 101 9745
TEST_TIME 102 9706
TEST_TIME 103 9732
TEST_TIME 104 9731
TEST_TIME 105 9740
TEST_TIME 106 9837
TEST_TIME 107 9847
TEST_TIME 108 9826
TEST_TIME 109 9846
TEST_TIME 110 9802
TEST_TIME 111 9734
TEST_TIME 112 9740
TEST_TIME 113 9734
TEST_TIME 114 9679
TEST_TIME 115 9666
TEST_TIME 116 9629
TEST_TIME 117 9593
TEST_TIME 118 9548
TEST_TIME 119 9563
TEST_TIME 120 9513

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-02-2021 01:29:11 to 13-02-2021 01:29:14.

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 1570138 1570138 0 0.00 0 15681 6 0 0
doc_list_biud 1570138 1570138 0 0.00 0 47459 28 0 0
sp_add_invoice_to_stock 5113 4980 133 2.60 40 186911 17327 0 133
sp_cancel_adding_invoice 5986 5986 0 0.00 4 69623 738 0 0
sp_cancel_client_order 1730 1730 0 0.00 4 10200 319 0 0
sp_cancel_customer_reserve 588435 588435 0 0.00 1 47463 61 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 3 3523 80 0 0
sp_cancel_pay_to_supplier 415 415 0 0.00 3 4340 69 0 0
sp_cancel_supplier_invoice 6566 6559 7 0.10 2 15009 729 0 7
sp_cancel_supplier_order 411 411 0 0.00 7 1264548 110163 0 0
sp_cancel_write_off 11791 11791 0 0.00 1 6834 105 0 0
sp_client_order 20860 20860 0 0.00 3 24713 339 0 0
sp_customer_reserve 463616 463616 0 0.00 0 85005 170 0 0
sp_fill_shopping_cart 31822 31822 0 0.00 1 14152 34 0 0
sp_fill_shopping_cart_clo_res 463609 463609 0 0.00 0 16859 14 0 0
sp_get_clo_for_invoice 4973 4973 0 0.00 0 19914 283 0 0
sp_kill_cost_storno 18867 18867 0 0.00 0 8965 55 0 0
sp_kill_qstorno_ret_qs2qd 1195631 1195631 0 0.00 0 47451 33 0 0
sp_kill_qty_storno 629912 629912 0 0.00 0 47458 70 0 0
sp_lock_selected_doc 20672 20672 0 0.00 0 6611 6 0 0
sp_make_cost_storno 27918 27918 0 0.00 0 14504 54 0 0
sp_multiply_rows_for_pdistr 27918 27918 0 0.00 0 9431 32 0 0
sp_multiply_rows_for_qdistr 20860 20860 0 0.00 0 14009 153 0 0
sp_pay_from_customer 6974 6974 0 0.00 4 19231 114 0 0
sp_pay_to_supplier 5944 5944 0 0.00 5 14530 126 0 0
sp_payment_common 12918 12918 0 0.00 1 19228 30 0 0
sp_qd_handle_on_cancel_clo 1730 1730 0 0.00 0 10175 295 0 0
sp_qd_handle_on_invoice_upd_sts 10958 10958 0 0.00 0 23510 318 0 0
sp_qd_handle_on_reserve_upd_sts 10028 10028 0 0.00 0 13962 66 0 0
sp_reserve_write_off 10028 10028 0 0.00 6 13979 192 0 0
sp_supplier_invoice 5445 5445 0 0.00 6 91769 3146 0 0
sp_supplier_order 5519 5519 0 0.00 5 31236 1130 0 0
srv_aggregate_perf_data 100 99 1 1.00 3109 183715 17006 0 1
srv_fill_mon_cache_memory 167 167 0 0.00 823 159555 31826 0 0
srv_find_qd_qs_mism 1093024 1093024 0 0.00 0 15680 5 0 0
srv_make_invnt_saldo 586 586 0 0.00 35 22260 1055 0 0
srv_make_money_saldo 812 812 0 0.00 1 2183 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 136379 216080 189387 0 0
t$perf-abend:sp_add_invoice_to_stock 133 133 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 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 4981 4981 0 0.00 0 10251 173 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 0 7757 169 0 0
t$perf-norm:sp_cancel_client_order 1730 1730 0 0.00 0 6655 17 0 0
t$perf-norm:sp_cancel_customer_reserve 640 640 0 0.00 0 1748 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 994 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 415 415 0 0.00 0 1285 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 2255 19 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 22081 1893 0 0
t$perf-norm:sp_cancel_write_off 1004 1004 0 0.00 0 2340 10 0 0
t$perf-norm:sp_client_order 20860 20860 0 0.00 0 20659 22 0 0
t$perf-norm:sp_customer_reserve 903 903 0 0.00 0 580 3 0 0
t$perf-norm:sp_pay_from_customer 6974 6974 0 0.00 0 6564 9 0 0
t$perf-norm:sp_pay_to_supplier 5944 5944 0 0.00 0 7219 11 0 0
t$perf-norm:sp_reserve_write_off 10028 10028 0 0.00 0 4002 10 0 0
t$perf-norm:sp_supplier_invoice 5445 5445 0 0.00 0 6210 18 0 0
t$perf-norm:sp_supplier_order 5519 5519 0 0.00 0 16682 18 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 7891 81 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 7019 45 0 0
t$perf-norm:srv_make_invnt_saldo 586 586 0 0.00 0 9329 41 0 0
t$perf-norm:srv_make_money_saldo 812 812 0 0.00 0 1016 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 13 6 0 0
v_add_invoice_to_stock 10206 9940 266 2.60 0 6680 24 0 266
v_all_customers 37834 37834 0 0.00 0 33 1 0 0
v_all_suppliers 30774 30774 0 0.00 0 19 1 0 0
v_all_wares 41720 41720 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 2816 13 0 0
v_cancel_client_order 3460 3460 0 0.00 0 995 3 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 2507 8 0 0
v_cancel_customer_reserve 1280 1280 0 0.00 0 562 3 0 0
v_cancel_payment_to_supplier 830 830 0 0.00 0 1905 6 0 0
v_cancel_supplier_invoice 812 798 14 1.72 0 1692 20 0 14
v_cancel_supplier_order 822 822 0 0.00 0 1294 7 0 0
v_cancel_write_off 2008 2008 0 0.00 0 1649 11 0 0
v_max_id_clo_ord 5518 5518 0 0.00 0 4046 2 0 0
v_max_id_clo_res 903 903 0 0.00 0 1485 15 0 0
v_max_id_ord_sup 5444 5444 0 0.00 0 4867 5 0 0
v_max_non_paid_invoice 1519 1519 0 0.00 0 74 2 0 0
v_max_non_paid_realizn 3646 3646 0 0.00 0 1567 4 0 0
v_min_id_clo_ord 5518 5518 0 0.00 0 1233 4 0 0
v_min_id_clo_res 903 903 0 0.00 0 9068 23 0 0
v_min_id_ord_sup 5444 5444 0 0.00 0 2800 5 0 0
v_min_non_paid_invoice 5944 5944 0 0.00 0 7972 19 0 0
v_min_non_paid_realizn 6974 6974 0 0.00 0 19224 19 0 0
v_our_firm 10542 10542 0 0.00 0 146 1 0 0
v_reserve_write_off 20056 20056 0 0.00 0 5501 7 0 0
x_lock_depdocs_on_canc_invoice 12146 12146 0 0.00 0 13117 123 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 12865 413 0 0
x_make_qstorno_1000_1200 5519 5519 0 0.00 2 31207 1053 0 0
x_make_qstorno_1200_2000 5445 5445 0 0.00 3 80241 3030 0 0
x_make_qstorno_2100_3300 463615 463615 0 0.00 0 85004 154 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 13-02-2021 01:29:15 to 13-02-2021 01:29:20.

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:22 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:29 18188 8192000000 10267227296 10583875584 1147429008 12.285 88 63 123 1 1171972416 3177152 21366256
22:57:57 32598 8192000000 10351076544 10672152576 1402351072 14.616 100 88 175 2 1436056528 5130720 28574736
22:58:40 21260 8192000000 10390714880 10716381184 1436811568 14.922 100 91 182 0 1473094368 6578416 29704384
22:59:11 15413 8192000000 10403192160 10733047808 1464295472 15.164 100 90 180 1 1501049824 7137376 29616976
22:59:40 19274 8192000000 10448801296 10778431488 1500028352 15.476 100 93 186 1 1538167104 8231984 29906768
23:00:10 5339 8192000000 10453205584 10785693696 1510876912 15.571 100 89 178 0 1548197648 8978368 28342368
23:00:34 25744 8192000000 10476089360 10814464000 1525069680 15.694 100 87 174 1 1562021248 9502832 27448736
23:01:12 16467 8192000000 10486352608 10829983744 1547936672 15.892 100 87 173 0 1585218496 10306192 26975632
23:01:45 8301 8192000000 10510591792 10854813696 1563877872 16.030 100 86 172 1 1601204352 10750944 26575536
23:02:02 12062 8192000000 10524441184 10873991168 1581168192 16.178 100 87 174 0 1618810800 11166288 26476320
23:02:24 10882 8192000000 10547125344 10899161088 1593392496 16.283 100 75 149 1 1625839856 9999520 22447840
23:02:45 11040 8192000000 10564875856 10922561536 1625265536 16.555 100 78 156 2 1659492208 10830832 23395840
23:03:04 16327 8192000000 10600557696 10957549568 1648810592 16.754 100 82 165 3 1685209616 11385920 25013104
23:03:27 13133 8192000000 10606979872 10970394624 1661796112 16.864 100 87 174 0 1699858304 11902512 26159680
23:03:54 11735 8192000000 10621406704 10993115136 1685311824 17.062 100 76 152 0 1719058624 11909296 21837504
23:04:13 7142 8192000000 10640206544 11010306048 1697894240 17.167 100 71 142 0 1730076464 11661488 20520736
23:04:28 9295 8192000000 10654558400 11029626880 1714661792 17.308 100 75 149 1 1748080832 12227440 21191600
23:04:44 7435 8192000000 10672374400 11047612416 1733802304 17.467 100 81 161 1 1768695088 11948368 22944416
23:05:00 8517 8192000000 10686263696 11064745984 1745320352 17.563 100 76 151 0 1780991600 13644576 22026672
23:05:17 5432 8192000000 10702923440 11077390336 1758046752 17.668 100 81 162 0 1794097648 13135376 22915520
23:05:31 5582 8192000000 10707792448 11090505728 1768016768 17.751 100 76 152 2 1802444576 13916832 20510976
23:05:45 5064 8192000000 10716545680 11096862720 1782269712 17.868 100 86 172 1 1820442016 14701760 23470544
23:05:57 4392 8192000000 10719500672 11103928320 1790020032 17.932 100 77 154 2 1824373568 13391808 20961728
23:06:08 3297 8192000000 10732947120 11118669824 1796297488 17.984 100 80 158 1 1832878032 13680304 22900240
23:06:25 4896 8192000000 10746345136 11134156800 1802049152 18.031 100 73 146 0 1835163344 13041952 20072240
23:06:36 3492 8192000000 10755949760 11142098944 1819076080 18.170 100 80 160 2 1855093728 13482224 22535424
23:06:46 3068 8192000000 10758141696 11142799360 1820721840 18.184 100 92 183 1 1860191440 13545856 25923744
23:06:56 1985 8192000000 10764212448 11151814656 1827676112 18.240 100 86 172 0 1865054848 13270288 24108448
23:07:05 2861 8192000000 10767706560 11157221376 1830436304 18.263 100 73 146 2 1863145600 12334016 20375280
23:07:15 2889 8192000000 10778052832 11165986816 1839593168 18.337 100 94 186 1 1878275504 12315216 26367120
23:07:25 2670 8192000000 10780241840 11168460800 1839574384 18.337 100 92 182 2 1878156320 12600320 25981616
23:07:34 2287 8192000000 10774356192 11167621120 1839880720 18.340 100 84 168 1 1875549936 11960416 23708800
23:07:43 2416 8192000000 10781153040 11172065280 1841856960 18.356 100 75 149 1 1873880384 11763296 20260128
23:07:52 1875 8192000000 10791796288 11177697280 1847454336 18.401 100 90 180 1 1885882864 13487008 24941520
23:08:00 8073 8192000000 10790277440 11178250240 1849737392 18.420 100 73 146 2 1882678688 13216960 19724336
23:08:14 1275 8192000000 10793655472 11184586752 1853633520 18.452 100 87 175 1 1891565632 12785024 25147088
23:08:22 2073 8192000000 10799255184 11189166080 1856037456 18.471 100 92 183 0 1894861248 13041056 25782736
23:08:31 18951 8192000000 10797321680 11193790464 1858654784 18.492 100 72 145 0 1889018288 10394416 19969088
23:08:56 5363 8192000000 10778377520 11187916800 1858999424 18.495 100 60 117 1 1887972576 11547280 17425872
23:09:09 2484 8192000000 10805775216 11207348224 1872356560 18.603 100 69 138 2 1904549472 11924400 20268512
23:09:19 2744 8192000000 10816277680 11210977280 1875150544 18.626 100 73 145 0 1908002000 12328432 20523024
23:09:29 2118 8192000000 10812411776 11207217152 1872518192 18.605 100 70 138 3 1901037168 9278112 19240864
23:09:37 3285 8192000000 10796312688 11208007680 1870686256 18.590 100 49 96 0 1893984096 8933072 14364768
23:09:48 3968 8192000000 10784259744 11201626112 1872396480 18.604 100 38 76 0 1891612864 8591008 10625376
23:10:00 5224 8192000000 10788891840 11205754880 1871827936 18.599 100 36 73 1 1890613472 8813456 9972080
23:10:11 4177 8192000000 10790613744 11207426048 1873480864 18.612 100 39 79 1 1893717120 9504688 10731568
23:10:22 7784 8192000000 10783485920 11208331264 1873429168 18.612 100 24 48 2 1887574448 7705360 6439920
23:10:41 6978 8192000000 10799131728 11213492224 1877266896 18.643 100 25 51 1 1890903904 6204544 7432464
23:10:57 9081 8192000000 10794314416 11219271680 1881908144 18.681 100 33 66 3 1899452992 7831664 9713184
23:11:12 12303 8192000000 10791115024 11222155264 1887628864 18.727 100 38 74 2 1905049200 6317904 11102432
23:11:30 62895 8192000000 10800556448 11231485952 1892166560 18.763 100 32 63 3 1907058464 5522944 9368960
23:12:43 5529 8192000000 10818282784 11243552768 1898452000 18.814 100 51 102 2 1920772272 7809632 14510640
23:12:57 11565 8192000000 10814854432 11242414080 1894607408 18.783 100 28 56 1 1907873760 5661088 7605264
23:13:17 5326 8192000000 10833943024 11253555200 1897800448 18.809 100 43 86 1 1922316000 13084688 11430864
23:13:29 4845 8192000000 10809854960 11239079936 1895557200 18.791 100 30 60 0 1912133680 8294336 8282144
23:13:40 6996 8192000000 10797995088 11236192256 1893888896 18.777 100 22 44 1 1910554400 10167568 6497936
23:13:53 5470 8192000000 10814025056 11240611840 1894674544 18.783 100 26 52 2 1907755584 5842640 7238400
23:14:08 9079 8192000000 10808674896 11243991040 1899188784 18.820 100 26 52 0 1914724624 7745744 7790096
23:14:23 7959 8192000000 10805149248 11243085824 1895529024 18.790 100 9 18 0 1903126128 5125344 2471760
23:14:37 5355 8192000000 10807179920 11243167744 1902830624 18.849 100 30 62 3 1916710912 5504464 8375824
23:14:50 8605 8192000000 10813228704 11246968832 1902177392 18.844 100 19 38 0 1914522816 5419952 6925472
23:15:06 7588 8192000000 10825128288 11256836096 1905607488 18.871 100 20 40 3 1916399984 4918048 5874448
23:15:21 8014 8192000000 10811741408 11251716096 1906374096 18.878 100 16 32 2 1916240624 5595952 4270576
23:15:39 10954 8192000000 10828476640 11261190144 1914031920 18.939 100 25 49 2 1926936560 5781936 7122704
23:15:58 12695 8192000000 10820640992 11257344000 1910056624 18.907 100 22 44 2 1923023440 6954032 6012784
23:16:23 77054 8192000000 10797917984 11239972864 1857519936 18.483 97 28 55 3 1871069168 4557632 8991600
23:17:47 9488 8192000000 10812382688 11232485376 1864944592 18.543 98 24 48 1 1877717968 5385296 7388080
23:18:03 5841 8192000000 10788777200 11213451264 1818843952 18.168 96 34 66 3 1834713536 6376992 9492592
23:18:15 3531 8192000000 10775535824 11195097088 1853251840 18.449 100 41 82 2 1871761824 6478800 12031184
23:18:25 6531 8192000000 10749171760 11172777984 1810264272 18.098 97 27 53 3 1823369520 5330992 7774256
23:18:40 11750 8192000000 10782747200 11200389120 1812061296 18.113 97 30 60 2 1827317568 5627872 9628400
23:19:00 10176 8192000000 10727537344 11146121216 1735313248 17.480 94 22 44 2 1746901456 4707264 6880944
23:19:19 7557 8192000000 10703022736 11122757632 1717467872 17.331 95 18 37 2 1727782384 5041808 5272704
23:19:33 10906 8192000000 10705138592 11118084096 1717380352 17.330 95 20 40 1 1729166464 5839472 5946640
23:19:50 9964 8192000000 10717100048 11141292032 1787710560 17.913 99 12 24 0 1796121152 4760992 3649600
23:20:07 9149 8192000000 10693807616 11103481856 1713377232 17.297 95 28 56 1 1726444832 5069904 7997696
23:20:24 13500 8192000000 10671132848 11075723264 1619056480 16.502 91 19 38 0 1630035568 4892384 6086704
23:20:46 10968 8192000000 10687902112 11103006720 1727843216 17.418 97 21 42 2 1739440400 5671168 5926016
23:21:04 67337 8192000000 10666094176 11083857920 1693631680 17.132 95 31 62 1 1708218176 5240000 9346496
23:22:18 8116 8192000000 10704956272 11123793920 1755149616 17.644 98 23 46 1 1767181488 5869952 6161920
23:22:34 8388 8192000000 10736726768 11146989568 1794232784 17.967 99 31 58 2 1808542512 5536240 8773488
23:22:49 4011 8192000000 10741040368 11163938816 1822034272 18.194 100 27 54 1 1840092288 11101088 6956928
23:23:01 5090 8192000000 10743111520 11150417920 1792502080 17.952 99 32 64 1 1809726656 8352528 8872048
23:23:13 4646 8192000000 10741001520 11153338368 1813907248 18.128 100 40 82 3 1832337712 7562992 10867472
23:23:25 6959 8192000000 10741600912 11159687168 1823968864 18.210 100 21 42 1 1835897024 5182816 6745344
23:23:40 9637 8192000000 10742871792 11165757440 1821379616 18.189 99 32 64 3 1836525424 6066624 9079184
23:23:58 6872 8192000000 10740357632 11170922496 1833423792 18.287 100 16 32 0 1844165440 5749984 4991664
23:24:13 6160 8192000000 10751256768 11180072960 1841481600 18.353 100 21 42 1 1853837552 6422864 5933088
23:24:27 13286 8192000000 10777210960 11189657600 1847088176 18.398 100 19 36 2 1857995856 5142976 5764704
23:24:48 8412 8192000000 10769343072 11189895168 1852552176 18.443 100 36 72 1 1869119216 5135328 11431712
23:25:03 9359 8192000000 10781032976 11197976576 1856339984 18.474 100 19 38 1 1867118976 5188288 5590704
23:25:19 16772 8192000000 10768700592 11196731392 1855923760 18.470 100 15 30 3 1865741872 5600256 4217856
23:25:42 22489 8192000000 10776475200 11201142784 1858551168 18.492 100 18 36 0 1873928912 9926528 5451216
23:26:12 82017 8192000000 10805778752 11227672576 1872650512 18.606 100 29 58 0 1886240400 5325664 8264224
23:27:43 14469 8192000000 10832915696 11247988736 1901904144 18.842 100 62 124 2 1927358144 7476752 17977248
23:28:08 10471 8192000000 10843042544 11256147968 1905925136 18.874 100 56 111 1 1930970496 8921568 16123792
23:28:27 7362 8192000000 10843760208 11259863040 1909494656 18.903 100 54 108 1 1933811536 9038592 15278288
23:28:42 4054 8192000000 10849258496 11264012288 1915051488 18.947 100 59 118 0 1942521280 10650848 16818944
23:28:54 34290 8192000000 10848274400 11271020544 1919298912 18.981 100 52 104 0 1944116400 10417888 14399600
23:29:39 5148 8192000000 10869786048 11284099072 1929616080 19.064 100 63 126 1 1958581024 10559024 18405920
23:29:54 35329 8192000000 10870536064 11295035392 1934624320 19.104 100 48 93 2 1960847888 12462544 13761024
23:30:38 44734 8192000000 10880662704 11310301184 1944437024 19.182 100 33 66 0 1968404368 14316896 9650448
23:31:33 31655 8192000000 10883771808 11326046208 1954334848 19.261 100 34 67 0 1977695312 13809776 9550688
23:32:22 11561 8192000000 10903091968 11337764864 1970463456 19.389 100 44 86 0 1995910544 12947632 12499456
23:32:47 25625 8192000000 10914060848 11353788416 1977833120 19.448 100 44 86 1 2006522096 15608288 13080688
23:33:20 30118 8192000000 10914670864 11360288768 1985256400 19.506 100 46 92 2 2018222592 19272976 13693216
23:34:14 8664 8192000000 10927585088 11365171200 1987848944 19.527 100 39 78 0 2020259216 19220992 13189280
23:34:36 15749 8192000000 10921672240 11364204544 1985432048 19.508 100 42 84 2 2019185232 20681552 13071632
23:34:59 10164 8192000000 10929986112 11368443904 1988034192 19.528 100 41 79 0 2020109488 19349728 12725568
23:35:24 5410 8192000000 10948447952 11377872896 1997354576 19.602 100 55 111 1 2034441184 20584144 16502464
23:35:47 7645 8192000000 10950444896 11384348672 1999794352 19.621 100 49 98 2 2039110464 24302256 15013856
23:36:04 6272 8192000000 10956993296 11391447040 2003299696 19.649 100 51 101 2 2044049040 25347120 15402224
23:36:20 11909 8192000000 10966535168 11396100096 2008946000 19.693 100 66 132 0 2056786592 27451216 20389376
23:36:42 9938 8192000000 10967830848 11397107712 2010730544 19.707 100 60 118 0 2055047360 25972464 18344352
23:37:01 11031 8192000000 10964852192 11401744384 2012775792 19.723 100 56 112 0 2057321936 26885280 17660864
23:37:22 23872 8192000000 10970953888 11399495680 1996561168 19.596 99 55 110 1 2039383424 25239568 17582688
23:38:08 10075 8192000000 10959700128 11398725632 1995567184 19.588 99 49 98 1 2036254528 25183168 15504176
23:38:25 3306 8192000000 10973137264 11403726848 2013480928 19.729 100 62 123 0 2058564080 26214560 18868592
23:38:36 9279 8192000000 10965766928 11403112448 2013463760 19.729 100 52 103 0 2058140832 27319712 17357360
23:38:52 6951 8192000000 10975783856 11413184512 2017971920 19.764 100 54 108 0 2064963552 29536160 17455472
23:39:06 3455 8192000000 10971108400 11407609856 2003240640 19.648 99 65 128 2 2051562832 28403680 19918512
23:39:20 10902 8192000000 10972774208 11403165696 1993962064 19.575 99 57 114 0 2039244640 27545632 17736944
23:39:37 3483 8192000000 10981928496 11413086208 2016037072 19.749 100 71 142 1 2072088320 34441328 21609920
23:39:49 2911 8192000000 10995437856 11418202112 2019589792 19.777 100 75 150 4 2073418784 30856000 22972992
23:40:01 3354 8192000000 10980351984 11406819328 1998388928 19.610 99 78 156 1 2053754960 31732528 23633504
23:40:13 12770 8192000000 11000976560 11418136576 2005064592 19.663 99 86 173 0 2065718448 34143968 26509888
23:40:36 1862 8192000000 11003935680 11427217408 2022168944 19.797 100 75 150 1 2078631264 33523328 22938992
23:40:46 7760 8192000000 10978765520 11407568896 1997297392 19.601 99 59 116 2 2045301088 29899984 18103712
23:41:07 6130 8192000000 10981167760 11411066880 2015662112 19.746 100 73 146 1 2069142624 30098320 23382192
23:41:20 3571 8192000000 10994571904 11415052288 2015932208 19.748 100 88 173 2 2074474400 30961616 27580576
23:41:30 2358 8192000000 10991969968 11412963328 2015531424 19.745 100 94 188 2 2079676944 35717648 28427872
23:41:40 1434 8192000000 10983499008 11406356480 2010068800 19.702 100 84 165 1 2066116528 31655904 24391824
23:41:50 5665 8192000000 10985619872 11412611072 2014021760 19.733 100 77 153 0 2068487360 31463552 23002048
23:42:03 4361 8192000000 10976084272 11396567040 2001114336 19.632 100 77 152 0 2055686704 31963472 22608896
23:42:16 1720 8192000000 10978553728 11394666496 1989229136 19.538 99 88 174 2 2050513904 34858800 26425968
23:42:24 6313 8192000000 10990351440 11413241856 2010197792 19.703 100 83 162 0 2070603088 35644608 24760688
23:42:41 4141 8192000000 10964660640 11376001024 1962194752 19.323 98 74 148 1 2020261808 35522048 22545008
23:42:52 5819 8192000000 10979049792 11395272704 1994204704 19.577 100 86 170 1 2055794464 35584576 26005184
23:43:05 1080 8192000000 10984461936 11401625600 2000430304 19.626 100 87 173 1 2061272608 34298208 26544096
23:43:13 2179 8192000000 10989016880 11407724544 2010076768 19.702 100 84 166 1 2070445424 36117376 24251280
23:43:22 2460 8192000000 10998570784 11416338432 2014708912 19.739 100 98 196 2 2079935184 36055136 29171136
23:43:31 1889 8192000000 10979750176 11408515072 2008455840 19.689 100 86 171 1 2070129904 35668320 26005744
23:43:41 3873 8192000000 10956516992 11393019904 1986088480 19.513 99 61 122 2 2041620624 36376192 19155952
23:43:55 10178 8192000000 10946793712 11379150848 1956007920 19.274 98 57 115 1 2009706624 35453120 18245584
23:44:12 1743 8192000000 10984361648 11405991936 1999137936 19.616 100 89 178 1 2064807424 37917456 27752032
23:44:21 4616 8192000000 10978017232 11407511552 1999026960 19.615 100 69 138 1 2056911552 36660112 21224480
23:44:37 3547 8192000000 10980340448 11409231872 2003993856 19.654 100 83 166 1 2068558704 37661248 26903600
23:44:50 1869 8192000000 11001421472 11426488320 2014824432 19.739 100 86 172 0 2084762960 42162400 27776128
23:45:03 3239 8192000000 10992545888 11430846464 2014672192 19.738 100 65 130 6 2078647584 43163520 20811872
23:45:16 4181 8192000000 10993987984 11424346112 2008154304 19.687 100 59 116 4 2072569584 45051680 19363600
23:45:29 1708 8192000000 10987279120 11417321472 1996516224 19.595 99 76 148 3 2063424208 43969392 22938592
23:45:38 7995 8192000000 11010306224 11436449792 2018760640 19.770 100 82 163 1 2092598608 48445104 25392864
23:45:54 2187 8192000000 11018343216 11443912704 2025375200 19.822 100 83 166 1 2102542448 50004384 27162864
23:46:03 2663 8192000000 11011692560 11441082368 2023009552 19.804 100 79 157 1 2097159424 48385664 25764208
23:46:13 6320 8192000000 10993167152 11427115008 2001142160 19.632 99 61 122 0 2065621488 44616752 19862576
23:46:34 2509 8192000000 11014324368 11440062464 2024861392 19.818 100 83 165 0 2096936256 45427440 26647424
23:46:46 2940 8192000000 11012712752 11441360896 2024459584 19.815 100 88 177 3 2096837328 43888928 28488816
23:46:56 3938 8192000000 10998863680 11420938240 2010825088 19.708 100 88 176 2 2085072384 45129280 29118016
23:47:09 2163 8192000000 10996155184 11417411584 2006176848 19.671 100 86 172 1 2080233664 46210464 27846352
23:47:19 3392 8192000000 10986869824 11410538496 1979252064 19.459 99 82 164 1 2055230224 49995264 25982896
23:47:31 3338 8192000000 10980328496 11410497536 1994312928 19.578 100 67 134 0 2064838288 49721344 20804016
23:47:42 819 8192000000 10988849168 11409235968 1992418816 19.563 100 81 163 0 2069212144 50845184 25948144
23:47:53 3460 8192000000 10979864368 11403116544 1987897024 19.527 100 75 151 1 2062599648 50720224 23982400
23:48:07 4050 8192000000 10968841616 11395104768 1967527952 19.366 99 68 136 1 2039591728 50159760 21904016
23:48:20 5250 8192000000 10974210480 11399008256 1975677504 19.430 100 61 122 0 2045877568 51037424 19162640
23:48:34 8519 8192000000 10949614960 11388989440 1971760256 19.399 100 50 99 1 2037504416 49582656 16161504
23:48:54 20231 8192000000 10926714512 11373682688 1953079584 19.251 99 31 62 1 2006520720 42980880 10460256
23:49:23 11491 8192000000 10922823104 11363520512 1927258832 19.045 98 37 74 1 1986638976 46838544 12541600
23:49:57 13263 8192000000 10926322816 11364487168 1931203152 19.076 99 39 78 1 1994775808 49909552 13663104
23:50:22 13545 8192000000 10935462128 11384090624 1962688848 19.327 100 34 68 1 2020664208 45984432 11990928
23:50:47 17572 8192000000 10934383744 11379646464 1948137632 19.212 99 31 61 0 2006748752 47963312 10647808
23:51:17 17462 8192000000 10911021184 11357708288 1931982992 19.083 99 30 60 1 1989802800 47854384 9965424
23:51:42 8639 8192000000 10898517824 11344412672 1929809968 19.065 100 25 50 1 1990949360 51218912 9920480
23:52:03 13961 8192000000 10885868560 11334381568 1921647856 19.000 100 32 64 2 1977733968 45340640 10745472
23:52:26 18373 8192000000 10889384240 11335892992 1888657760 18.735 98 32 64 1 1943332336 44329600 10344976
23:52:56 13528 8192000000 10879859200 11343855616 1912752832 18.929 100 23 46 1 1968507264 47507168 8247264
23:53:35 21512 8192000000 10868638368 11335299072 1899523424 18.822 100 13 26 1 1957774128 52860704 5390000
23:54:21 68953 8192000000 10854753280 11327045632 1887638464 18.727 99 12 24 1 1929700544 37940960 4121120
23:56:12 69075 8192000000 10821000144 11294765056 1839277936 18.335 97 9 18 0 1857546192 16191760 2076496
23:57:27 53233 8192000000 10852613440 11289550848 1878408992 18.652 98 23 47 2 1894741216 9395616 6936608
23:58:27 35418 8192000000 10843329008 11302658048 1903447840 18.854 99 17 34 2 1916718384 8880960 4389584
23:59:09 30852 8192000000 10864920688 11298942976 1897827904 18.809 98 28 56 0 1915074464 9389216 7857344
23:59:47 70256 8192000000 10880781168 11318390784 1897151152 18.803 98 16 32 1 1912221504 10916944 4153408
00:01:07 30062 8192000000 10864577232 11316903936 1927709072 19.049 99 23 46 3 1945596704 11345264 6542368
00:01:44 47040 8192000000 10868246592 11333550080 1904006496 18.859 98 9 18 1 1919802672 13825392 1970784
00:03:09 21581 8192000000 10908041584 11350478848 1963813568 19.336 100 56 112 3 1992328960 12619440 15895952
00:03:48 159554 8192000000 10885687088 11361701888 1935764720 19.113 99 29 58 2 1959715552 14936944 9013888
00:06:35 91803 8192000000 10895760000 11332157440 1904565216 18.863 97 25 50 3 1921437536 10216480 6655840
00:08:13 12384 8192000000 10910561328 11367411712 1978376304 19.452 100 56 112 1 2004773952 10336256 16061392
00:08:33 35187 8192000000 10903646864 11370545152 1978700592 19.454 100 29 57 2 1997477920 10310128 8467200
00:09:14 39396 8192000000 10921146352 11380674560 1980885568 19.472 100 23 46 0 2001267008 13150048 7231392
00:10:17 43614 8192000000 10892100992 11353088000 1943430272 19.174 98 40 80 0 1970418624 14739280 12249072
00:11:14 26860 8192000000 10890408288 11355410432 1938755824 19.137 99 13 26 0 1956091328 13178016 4157488
00:11:55 27677 8192000000 10870923968 11343065088 1915839104 18.953 98 13 26 0 1935236768 15070272 4327392
00:12:33 26198 8192000000 10863266304 11329671168 1926247776 19.037 99 8 16 0 1937936272 9650592 2037904
00:13:10 41343 8192000000 10877302096 11348205568 1954906736 19.266 100 6 12 0 1966505312 9878816 1719760
00:14:01 15221 8192000000 10870401088 11340140544 1947872384 19.210 100 7 14 1 1961382848 11225216 2285248
00:14:25 17827 8192000000 10875837856 11350380544 1949502944 19.223 100 12 24 0 1966973376 13783616 3686816
00:14:49 29685 8192000000 10884238464 11357372416 1964014656 19.338 100 30 59 1 1981412256 8698192 8699408
00:15:27 123627 8192000000 10892884240 11379945472 1977581072 19.446 100 9 18 0 1989734240 9840096 2313072
00:17:38 73936 8192000000 10901249760 11393511424 1959486880 19.302 99 7 14 1 1971845472 10601744 1756848
00:19:08 68608 8192000000 10920973840 11405934592 1990737696 19.550 100 18 36 1 2011673904 14888976 6047232
00:20:24 58146 8192000000 10910022704 11387486208 1947923200 19.210 98 12 24 0 1970305520 18888272 3494048
00:21:33 54363 8192000000 10914086800 11390550016 1982361600 19.483 100 14 28 0 1995613888 9370512 3881776
00:22:34 26570 8192000000 10913510128 11380568064 1946675776 19.200 98 24 47 0 1962679552 9053424 6950352
00:23:38 32173 8192000000 10910704064 11374997504 1963671648 19.335 99 16 28 2 1975371456 7697664 4002144
00:24:19 69395 8192000000 10913743568 11384426496 1948032000 19.211 98 25 48 1 1968545600 13008368 7505232
00:25:35 67081 8192000000 10901073760 11390009344 1919597856 18.984 97 9 18 1 1938887024 16776368 2512800
00:26:56 90752 8192000000 10868373408 11350245376 1861782144 18.518 94 10 20 0 1879749952 15529936 2437872
00:28:33 50988 8192000000 10907125072 11350814720 1942157712 19.164 99 39 74 5 1959617120 7457584 10001824
00:29:44 79013 8192000000 10904412960 11366903808 1903679840 18.856 97 28 54 1 1919968128 9020384 7267904
00:31:39 48282 8192000000 10903341120 11352674304 1908082720 18.891 97 28 56 2 1928967552 12366464 8518368
00:32:36 51564 8192000000 10891502080 11358932992 1942247616 19.165 99 41 82 0 1972876336 19021840 11606880
00:33:35 54086 8192000000 10874108144 11346497536 1898673072 18.816 97 20 40 0 1919376144 14088912 6614160
00:34:58 87805 8192000000 10834936672 11319754752 1846762624 18.396 96 8 16 0 1865153056 16378384 2012048
00:36:32 40757 8192000000 10836468064 11304923136 1864558928 18.540 97 18 36 1 1881970736 11742256 5669552
00:37:20 40301 8192000000 10835215808 11315499008 1896936976 18.802 99 10 18 1 1910298272 10450800 2910496
00:38:28 91876 8192000000 10839198992 11319492608 1895814096 18.793 99 14 28 0 1920024544 20432608 3777840
00:40:06 31952 8192000000 10821530272 11289907200 1823456992 18.206 95 13 26 0 1845381984 17569952 4355040
00:40:47 62656 8192000000 10818493024 11304792064 1865887232 18.551 98 8 15 1 1888116576 20108864 2120480
00:42:14 62699 8192000000 10831945216 11326132224 1893660992 18.775 99 13 26 0 1917152640 19613936 3877712
00:43:31 43391 8192000000 10861924544 11327111168 1903738624 18.856 99 20 40 1 1921372576 11919184 5714768
00:44:22 63795 8192000000 10848545216 11318620160 1843774832 18.372 95 15 30 0 1859675408 10500800 5399776
00:45:32 60867 8192000000 10847233504 11313963008 1861559760 18.516 97 20 40 1 1882022048 14669600 5792688
00:46:43 63357 8192000000 10854672672 11324846080 1898906672 18.817 99 14 28 0 1922417696 19310496 4200528
00:47:58 50467 8192000000 10851768096 11330232320 1874801376 18.623 97 21 42 3 1900256640 19706320 5748944
00:48:55 87560 8192000000 10866730448 11330973696 1891420512 18.757 98 23 46 1 1910576576 13274064 5882000
00:50:28 17517 8192000000 10889670688 11332476928 1917515536 18.967 99 52 103 1 1942182304 9231824 15434944
00:50:56 28635 8192000000 10882158496 11331764224 1928754768 19.057 100 42 84 1 1951718928 11608048 11356112
00:51:36 8391 8192000000 10884088448 11334610944 1934257936 19.101 100 43 86 3 1957405952 10497600 12650416
00:51:55 9922 8192000000 10890682512 11331289088 1920729120 18.993 99 52 104 0 1947770416 12868912 14172384
00:52:12 20682 8192000000 10875963504 11335557120 1923265584 19.013 99 46 92 1 1950667808 14097056 13305168
00:52:43 20757 8192000000 10866938176 11324932096 1907826176 18.889 98 49 97 2 1935199920 12981456 14392288
00:53:11 28079 8192000000 10879333216 11343609856 1906340000 18.877 98 28 56 0 1933370864 19267376 7763488
00:53:51 62208 8192000000 10879767504 11366080512 1941309584 19.157 100 14 28 0 1967416208 22149232 3957392
00:56:35 105023 8192000000 10867886960 11342745600 1926707520 19.041 98 18 36 0 1938126288 6255872 5162896
00:58:26 23251 8192000000 10872016000 11341107200 1942865648 19.170 99 18 36 0 1959565776 11376992 5323136
00:59:34 45090 8192000000 10890549072 11371978752 1952644080 19.248 99 16 32 1 1965497968 8198304 4655584
01:00:26 56670 8192000000 10879062432 11368038400 1950032128 19.227 99 6 12 1 1962216096 10516576 1667392
01:01:35 23257 8192000000 10871452528 11356790784 1953911936 19.258 100 7 14 1 1967312560 10935776 2464848
01:02:17 77129 8192000000 10878803824 11375198208 1948875600 19.218 99 5 10 0 1958571696 8571968 1124128
01:03:41 60235 8192000000 10891091936 11372478464 1954615264 19.263 99 17 34 0 1970315184 10998496 4701424
01:04:51 23929 8192000000 10930364736 11393249280 1986168976 19.514 100 39 78 2 2009566304 12476448 10920880
01:05:24 30285 8192000000 10911684544 11388805120 1966480496 19.358 99 29 58 2 1990348912 14972336 8896080
01:06:01 50067 8192000000 10902891712 11388473344 1939250544 19.141 98 19 38 1 1960341008 14956624 6133840
01:07:04 49498 8192000000 10899592736 11360841728 1930909888 19.074 98 12 24 0 1946303312 12059456 3333968
01:07:59 83509 8192000000 10876083376 11361984512 1891352096 18.757 96 22 42 1 1905487568 8320848 5814624
01:09:30 46799 8192000000 10895275072 11370156032 1967578000 19.366 100 29 58 1 1987655488 11689408 8388080
01:10:23 39391 8192000000 10919596176 11389505536 1982707728 19.486 100 32 64 1 2004036432 12549872 8778832
01:11:09 91173 8192000000 10913118768 11389673472 1960584672 19.311 99 13 26 1 1981739120 17042672 4111776
01:12:57 146410 8192000000 10893619760 11366993920 1878091712 18.650 95 12 24 2 1894453808 13462832 2899264
01:15:30 6688 8192000000 10901897200 11362025472 1950142848 19.228 99 50 101 0 1974652384 9538256 14971280
01:15:42 58799 8192000000 10902201680 11380625408 1947840528 19.209 99 17 34 0 1963293328 10842640 4610160
01:16:47 138540 8192000000 10906334656 11383988224 1964919488 19.345 100 16 32 1 1982220448 12706112 4594848
01:19:27 52186 8192000000 10877963392 11376066560 1945222736 19.188 99 11 23 1 1963575088 15188320 3164032
01:20:42 67517 8192000000 10895705808 11388719104 1969255568 19.380 100 5 10 0 1982406000 11830416 1320016
01:21:56 75202 8192000000 10881625840 11369304064 1900056832 18.827 96 8 16 0 1913263472 10666448 2540192
01:23:20 56422 8192000000 10864996384 11345473536 1904597344 18.863 97 11 23 0 1915289216 7785984 2905888
01:24:47 74812 8192000000 10859781856 11341869056 1914226096 18.941 98 16 32 0 1928767072 9494320 5046656
01:26:08 70342 8192000000 10851864944 11340128256 1930852880 19.074 99 16 32 0 1961653152 26097024 4703248

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 13-02-2021 01:29:21 to 13-02-2021 01:29:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 133 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-02-2021 01:29:54 to 13-02-2021 01:29:56.

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          236186
MON$OLDEST_ACTIVE               237059
MON$OLDEST_SNAPSHOT             237059
MON$NEXT_TRANSACTION            237059
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                       2043680
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:309: 
:310: mscs-test-161.budzdorov.ru    Sat Feb 13 01:27:32 2021
:311:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:312: 
--- end of diff output ---

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

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