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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-15 22:27:04
DTS_END                         2020-12-15 22:27:04.8230
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/37512
TRN_ID                          252235
ATT_ID                          731
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: 9373.22 21891 1124786
customer order: creation 180.71 333 21685
customer order: refuse 15.69 260 1883
order to supplier: creation 48.45 1131 5814
order to supplier: removal 3.68 72947 442
invoice (draft): creation 50.25 3165 6030
invoice (draft): removal 52.39 618 6287
invoice accept: apply 43.18 15520 5181
invoice accept: cancel 47.35 752 5682
customer reserve: creation 3945.82 156 473498
customer reserve: removal 4674.58 45 560949
realization accept: apply 87.28 153 10474
realization accept: cancel 86.75 98 10410
payment from customer: creation 63.02 87 7562
payment from customer: removal 5.94 53 713
payment to supplier: creation 51.49 107 6179
payment to supplier: removal 3.64 68 437
service: total inventory turnovers 5.54 842 665
service: total monetary turnovers 6.51 23 781
service: aggregate perf. data 0.92 16509 110
service: refresh index statistics 0.03 324946 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-12-2020 22:27:53 to 15-12-2020 22:27:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4551
TEST_TIME 2 4720
TEST_TIME 3 5189
TEST_TIME 4 5492
TEST_TIME 5 5364
TEST_TIME 6 5542
TEST_TIME 7 6628
TEST_TIME 8 7649
TEST_TIME 9 7558
TEST_TIME 10 7816
TEST_TIME 11 8040
TEST_TIME 12 8656
TEST_TIME 13 9872
TEST_TIME 14 10075
TEST_TIME 15 10732
TEST_TIME 16 10768
TEST_TIME 17 10638
TEST_TIME 18 11097
TEST_TIME 19 11384
TEST_TIME 20 11489
TEST_TIME 21 12074
TEST_TIME 22 11729
TEST_TIME 23 11454
TEST_TIME 24 11177
TEST_TIME 25 11045
TEST_TIME 26 11241
TEST_TIME 27 11135
TEST_TIME 28 10964
TEST_TIME 29 10980
TEST_TIME 30 10770
TEST_TIME 31 10640
TEST_TIME 32 10519
TEST_TIME 33 10298
TEST_TIME 34 10125
TEST_TIME 35 10158
TEST_TIME 36 9999
TEST_TIME 37 9900
TEST_TIME 38 10278
TEST_TIME 39 10139
TEST_TIME 40 10125
TEST_TIME 41 10057
TEST_TIME 42 10105
TEST_TIME 43 10180
TEST_TIME 44 10247
TEST_TIME 45 10171
TEST_TIME 46 10266
TEST_TIME 47 10244
TEST_TIME 48 10259
TEST_TIME 49 10249
TEST_TIME 50 10162
TEST_TIME 51 10035
TEST_TIME 52 9980
TEST_TIME 53 9930
TEST_TIME 54 9919
TEST_TIME 55 9853
TEST_TIME 56 9818
TEST_TIME 57 9780
TEST_TIME 58 9659
TEST_TIME 59 9591
TEST_TIME 60 9709
TEST_TIME 61 9682
TEST_TIME 62 9630
TEST_TIME 63 9706
TEST_TIME 64 9730
TEST_TIME 65 9883
TEST_TIME 66 9877
TEST_TIME 67 9862
TEST_TIME 68 9834
TEST_TIME 69 9852
TEST_TIME 70 9870
TEST_TIME 71 9849
TEST_TIME 72 9965
TEST_TIME 73 10017
TEST_TIME 74 10015
TEST_TIME 75 9906
TEST_TIME 76 9842
TEST_TIME 77 9782
TEST_TIME 78 9777
TEST_TIME 79 9736
TEST_TIME 80 9704
TEST_TIME 81 9646
TEST_TIME 82 9573
TEST_TIME 83 9604
TEST_TIME 84 9603
TEST_TIME 85 9588
TEST_TIME 86 9644
TEST_TIME 87 9640
TEST_TIME 88 9651
TEST_TIME 89 9656
TEST_TIME 90 9693
TEST_TIME 91 9739
TEST_TIME 92 9753
TEST_TIME 93 9757
TEST_TIME 94 9777
TEST_TIME 95 9739
TEST_TIME 96 9792
TEST_TIME 97 9865
TEST_TIME 98 9790
TEST_TIME 99 9750
TEST_TIME 100 9733
TEST_TIME 101 9691
TEST_TIME 102 9648
TEST_TIME 103 9583
TEST_TIME 104 9541
TEST_TIME 105 9621
TEST_TIME 106 9560
TEST_TIME 107 9541
TEST_TIME 108 9509
TEST_TIME 109 9452
TEST_TIME 110 9419
TEST_TIME 111 9424
TEST_TIME 112 9404
TEST_TIME 113 9420
TEST_TIME 114 9395
TEST_TIME 115 9430
TEST_TIME 116 9470
TEST_TIME 117 9442
TEST_TIME 118 9480
TEST_TIME 119 9458
TEST_TIME 120 9380

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-12-2020 22:27:57 to 15-12-2020 22:28:00.

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 1565417 1565417 0 0.00 0 24537 6 0 0
doc_list_biud 1565417 1565417 0 0.00 0 30207 21 0 0
sp_add_invoice_to_stock 5300 5181 119 2.24 45 183537 15520 0 119
sp_cancel_adding_invoice 5682 5682 0 0.00 4 52055 752 0 0
sp_cancel_client_order 1883 1883 0 0.00 4 15273 261 0 0
sp_cancel_customer_reserve 560949 560949 0 0.00 1 24491 45 0 0
sp_cancel_pay_from_customer 713 713 0 0.00 2 2649 53 0 0
sp_cancel_pay_to_supplier 437 437 0 0.00 3 3531 68 0 0
sp_cancel_supplier_invoice 6295 6287 8 0.12 1 24594 619 0 8
sp_cancel_supplier_order 442 442 0 0.00 8 713154 72947 0 0
sp_cancel_write_off 10410 10410 0 0.00 1 10012 98 0 0
sp_client_order 21685 21685 0 0.00 3 28110 334 0 0
sp_customer_reserve 473498 473498 0 0.00 0 41101 157 0 0
sp_fill_shopping_cart 33506 33506 0 0.00 1 16241 37 0 0
sp_fill_shopping_cart_clo_res 473490 473490 0 0.00 0 12184 12 0 0
sp_get_clo_for_invoice 5173 5173 0 0.00 0 14860 260 0 0
sp_kill_cost_storno 17242 17242 0 0.00 0 18385 48 0 0
sp_kill_qstorno_ret_qs2qd 1139037 1139037 0 0.00 0 24574 24 0 0
sp_kill_qty_storno 601300 601300 0 0.00 0 30202 54 0 0
sp_lock_selected_doc 21871 21871 0 0.00 0 7284 4 0 0
sp_make_cost_storno 29388 29388 0 0.00 0 22953 43 0 0
sp_multiply_rows_for_pdistr 29388 29388 0 0.00 0 6739 22 0 0
sp_multiply_rows_for_qdistr 21685 21685 0 0.00 0 14914 159 0 0
sp_pay_from_customer 7562 7562 0 0.00 4 22962 88 0 0
sp_pay_to_supplier 6179 6179 0 0.00 5 17134 108 0 0
sp_payment_common 13741 13741 0 0.00 1 11541 25 0 0
sp_qd_handle_on_cancel_clo 1883 1883 0 0.00 0 15265 245 0 0
sp_qd_handle_on_invoice_upd_sts 10855 10855 0 0.00 0 30195 303 0 0
sp_qd_handle_on_reserve_upd_sts 10474 10474 0 0.00 0 15697 57 0 0
sp_reserve_write_off 10474 10474 0 0.00 6 15872 153 0 0
sp_supplier_invoice 6030 6030 0 0.00 6 94251 3165 0 0
sp_supplier_order 5814 5814 0 0.00 6 39921 1132 0 0
srv_aggregate_perf_data 111 110 1 0.90 2755 177494 16510 0 1
srv_fill_mon_cache_memory 144 144 0 0.00 1062 139328 36999 0 0
srv_find_qd_qs_mism 1075925 1075925 0 0.00 0 24475 5 0 0
srv_make_invnt_saldo 665 665 0 0.00 34 33804 842 0 0
srv_make_money_saldo 781 781 0 0.00 0 3266 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 194198 590744 324947 0 0
t$perf-abend:sp_add_invoice_to_stock 119 119 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5181 5181 0 0.00 0 8495 130 0 0
t$perf-norm:sp_cancel_adding_invoice 457 457 0 0.00 0 5003 81 0 0
t$perf-norm:sp_cancel_client_order 1883 1883 0 0.00 0 3121 14 0 0
t$perf-norm:sp_cancel_customer_reserve 743 743 0 0.00 0 868 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 713 713 0 0.00 0 680 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 437 437 0 0.00 0 1880 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 444 444 0 0.00 0 3784 21 0 0
t$perf-norm:sp_cancel_supplier_order 442 442 0 0.00 0 30952 1294 0 0
t$perf-norm:sp_cancel_write_off 1105 1105 0 0.00 0 2178 8 0 0
t$perf-norm:sp_client_order 21685 21685 0 0.00 0 21276 15 0 0
t$perf-norm:sp_customer_reserve 1073 1073 0 0.00 0 21725 28 0 0
t$perf-norm:sp_pay_from_customer 7562 7562 0 0.00 0 18486 12 0 0
t$perf-norm:sp_pay_to_supplier 6179 6179 0 0.00 0 5419 8 0 0
t$perf-norm:sp_reserve_write_off 10474 10474 0 0.00 0 24476 12 0 0
t$perf-norm:sp_supplier_invoice 6030 6030 0 0.00 0 17960 17 0 0
t$perf-norm:sp_supplier_order 5814 5814 0 0.00 0 3125 10 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 331 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 144 144 0 0.00 0 196 3 0 0
t$perf-norm:srv_make_invnt_saldo 665 665 0 0.00 0 894 9 0 0
t$perf-norm:srv_make_money_saldo 781 781 0 0.00 0 2236 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 10584 10346 238 2.24 0 2550 14 0 238
v_all_customers 39544 39544 0 0.00 0 27 0 0 0
v_all_suppliers 32584 32584 0 0.00 0 15 1 0 0
v_all_wares 43370 43370 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 914 914 0 0.00 0 2581 9 0 0
v_cancel_client_order 3766 3766 0 0.00 0 3705 4 0 0
v_cancel_customer_prepayment 1426 1426 0 0.00 0 2618 6 0 0
v_cancel_customer_reserve 1486 1486 0 0.00 0 1704 5 0 0
v_cancel_payment_to_supplier 874 874 0 0.00 0 1690 8 0 0
v_cancel_supplier_invoice 904 888 16 1.76 0 2234 14 0 16
v_cancel_supplier_order 884 884 0 0.00 0 3271 10 0 0
v_cancel_write_off 2210 2210 0 0.00 0 3124 13 0 0
v_max_id_clo_ord 5814 5814 0 0.00 0 715 1 0 0
v_max_id_clo_res 1073 1073 0 0.00 0 3688 22 0 0
v_max_id_ord_sup 6004 6004 0 0.00 0 3717 5 0 0
v_max_non_paid_invoice 1705 1705 0 0.00 0 243 2 0 0
v_max_non_paid_realizn 3949 3949 0 0.00 0 887 3 0 0
v_min_id_clo_ord 5814 5814 0 0.00 0 3634 4 0 0
v_min_id_clo_res 1073 1073 0 0.00 0 9279 26 0 0
v_min_id_ord_sup 6004 6004 0 0.00 0 6041 12 0 0
v_min_non_paid_invoice 6179 6179 0 0.00 0 10087 20 0 0
v_min_non_paid_realizn 7562 7562 0 0.00 0 11534 16 0 0
v_our_firm 11052 11052 0 0.00 0 56 1 0 0
v_reserve_write_off 20948 20948 0 0.00 0 3343 6 0 0
x_lock_depdocs_on_canc_invoice 11525 11525 0 0.00 0 14610 106 0 0
x_lock_depdocs_on_canc_sup_ord 442 442 0 0.00 0 17762 293 0 0
x_make_qstorno_1000_1200 5814 5814 0 0.00 1 39915 1065 0 0
x_make_qstorno_1200_2000 6030 6030 0 0.00 2 94238 3025 0 0
x_make_qstorno_2100_3300 473498 473498 0 0.00 0 41100 142 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-12-2020 22:28:01 to 15-12-2020 22:28:05.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:08 9 8192000000 8801716384 8813314048 6918096 0.084 2 1 2 0 7037472 56816 62560
19:57:15 10492 8192000000 10195053472 10496098304 902286496 9.921 73 56 113 1 924526928 2681808 19558624
19:57:33 16584 8192000000 10303693424 10616365056 1357080272 14.211 100 85 170 0 1389660176 4238432 28341472
19:58:02 34354 8192000000 10364897040 10686722048 1412383344 14.705 100 90 180 0 1448461664 6290320 29788000
19:58:49 20372 8192000000 10398552720 10722951168 1449828736 15.036 100 91 182 0 1486710336 7481136 29400464
19:59:20 18993 8192000000 10420051376 10747179008 1472756976 15.238 100 93 186 0 1511410384 8431632 30221776
19:59:47 12894 8192000000 10433948576 10766774272 1485775360 15.352 100 90 180 0 1523377552 8797088 28805104
20:00:09 25529 8192000000 10459457376 10795667456 1507279936 15.540 100 84 168 2 1543038592 9214128 26544528
20:00:45 13924 8192000000 10467105552 10811838464 1530024960 15.737 100 81 162 0 1565223680 9879776 25318944
20:01:12 15481 8192000000 10498355776 10846253056 1547369184 15.887 100 77 154 2 1581195952 9906240 23920528
20:01:39 14931 8192000000 10523647792 10872782848 1578228592 16.153 100 82 164 3 1613079504 10085440 24765472
20:02:03 11522 8192000000 10542329424 10900402176 1608369408 16.411 100 81 162 2 1643240288 10699664 24171216
20:02:22 11579 8192000000 10573470128 10928984064 1628938096 16.586 100 75 147 2 1661927248 10324080 22665072
20:02:43 12226 8192000000 10600746208 10964852736 1655607712 16.812 100 76 152 1 1689896464 11645888 22642864
20:03:08 8771 8192000000 10618145840 10985598976 1676580720 16.989 100 79 158 0 1711952160 11874000 23497440
20:03:27 9024 8192000000 10637229104 11004784640 1691998720 17.118 100 81 161 0 1728799600 13571312 23229568
20:03:43 5069 8192000000 10646286784 11019083776 1705082736 17.228 100 83 166 2 1742746496 13381968 24281792
20:03:58 5820 8192000000 10666209472 11039010816 1723119024 17.378 100 73 145 0 1755827328 12311264 20397040
20:04:11 4605 8192000000 10677542288 11051319296 1734363536 17.472 100 82 159 0 1769896112 12983424 22549152
20:04:23 4470 8192000000 10687773248 11062411264 1748021728 17.585 100 82 164 1 1785305520 13387872 23895920
20:04:35 4828 8192000000 10689304608 11069677568 1758487824 17.672 100 75 148 1 1793213360 13212720 21512816
20:04:47 3518 8192000000 10706490624 11081740288 1765664864 17.731 100 78 159 0 1801365664 13340016 22360784
20:04:57 3646 8192000000 10717409840 11096629248 1779004784 17.841 100 89 178 3 1818836320 14103504 25728032
20:05:08 2931 8192000000 10712791088 11092619264 1783963728 17.882 100 80 160 2 1819359200 13082208 22313264
20:05:17 4069 8192000000 10731592592 11112574976 1795457952 17.977 100 80 158 2 1829655536 12273536 21924048
20:05:28 2597 8192000000 10739806624 11123400704 1803656752 18.044 100 87 170 1 1841492720 14203600 23632368
20:05:37 3200 8192000000 10749022864 11135172608 1810275520 18.098 100 80 160 1 1845092896 12699392 22117984
20:05:53 4157 8192000000 10741843120 11131662336 1814744272 18.135 100 70 138 1 1845811408 11955856 19111280
20:06:04 3253 8192000000 10766876256 11155857408 1830626656 18.264 100 74 148 2 1863481104 11726048 21128400
20:06:14 2919 8192000000 10784508112 11170418688 1839196112 18.334 100 84 168 1 1874863968 11375344 24292512
20:06:23 2318 8192000000 10782420816 11169579008 1844398736 18.377 100 82 164 0 1880146000 12106848 23640416
20:06:32 1752 8192000000 10793096816 11180367872 1850150352 18.423 100 92 185 1 1888775184 12911840 25712992
20:06:41 1334 8192000000 10791881936 11182321664 1848171312 18.407 100 80 160 2 1883713184 12169232 23372640
20:06:48 2804 8192000000 10802428384 11190747136 1857038192 18.479 100 85 171 0 1893803344 13196848 23568304
20:06:58 2033 8192000000 10805493120 11194134528 1863262880 18.530 100 94 189 2 1903884112 13624400 26996832
20:07:06 2280 8192000000 10809649424 11197779968 1865799920 18.550 100 95 189 2 1905805888 14780080 25225888
20:07:16 1769 8192000000 10807750928 11194634240 1862671872 18.525 100 88 174 0 1901768128 14708480 24387776
20:07:24 1596 8192000000 10809834992 11198570496 1864349808 18.539 100 84 167 1 1901910160 14134752 23425600
20:07:32 1174 8192000000 10806402480 11196706816 1869355920 18.579 100 89 177 0 1905447344 12168128 23923296
20:07:39 2403 8192000000 10813154480 11204026368 1870833392 18.591 100 90 182 0 1910064928 13396368 25835168
20:07:48 1393 8192000000 10823449680 11212750848 1874052576 18.617 100 92 186 1 1914245904 13701680 26491648
20:07:56 10107 8192000000 10823144336 11214753792 1880084656 18.666 100 85 170 1 1915720192 12385712 23249824
20:08:12 2796 8192000000 10808836752 11211890688 1880934640 18.673 100 80 162 0 1916221360 12368864 22917856
20:08:22 4748 8192000000 10827620480 11219484672 1881432144 18.677 100 78 154 1 1913627216 10709904 21485168
20:08:33 21211 8192000000 10791685856 11217989632 1877868768 18.648 100 36 72 0 1896748080 8918320 9960992
20:09:01 7493 8192000000 10790902640 11216588800 1878127792 18.650 100 30 60 2 1893629632 6541888 8959952
20:09:15 3365 8192000000 10794862800 11221860352 1882914288 18.689 100 24 48 0 1895887936 7069712 5903936
20:09:25 1650 8192000000 10813043376 11227656192 1888794864 18.736 100 46 91 3 1908260800 6979264 12486672
20:09:36 6669 8192000000 10803549680 11224227840 1887744496 18.728 100 25 51 2 1901398544 6635872 7018176
20:09:54 10195 8192000000 10786697984 11223678976 1885120016 18.706 100 22 44 0 1898163392 6906336 6137040
20:10:10 4759 8192000000 10802957008 11228033024 1891332656 18.757 100 43 86 1 1911199904 6732960 13134288
20:10:22 9354 8192000000 10793303504 11225124864 1887988016 18.730 100 26 52 0 1901443792 6074880 7380896
20:10:40 7356 8192000000 10800783680 11231215616 1891302288 18.756 100 21 42 2 1903303504 5867824 6133392
20:10:54 4691 8192000000 10806405296 11234643968 1896068800 18.795 100 24 48 0 1909850256 6827296 6954160
20:11:06 7406 8192000000 10797512320 11237502976 1898139600 18.811 100 18 36 2 1910430064 6260704 6029760
20:11:23 10850 8192000000 10811911648 11247304704 1903545920 18.855 100 28 55 2 1922630416 11227456 7857040
20:11:40 13778 8192000000 10803566864 11243077632 1901497072 18.838 100 18 34 1 1912690784 6318880 4874832
20:12:00 11656 8192000000 10810474480 11246657536 1904418784 18.862 100 24 48 0 1918167792 6471760 7277248
20:12:19 12017 8192000000 10820773136 11249332224 1905107344 18.867 100 22 44 1 1917240752 6354208 5779200
20:12:37 70853 8192000000 10833585152 11253202944 1911022816 18.915 100 40 80 0 1928566800 4545952 12998032
20:13:56 2407 8192000000 10840552480 11268071424 1916656704 18.960 100 59 116 0 1943993840 11056592 16280544
20:14:04 3980 8192000000 10833119344 11266899968 1911496576 18.919 100 32 64 2 1928784992 8284336 9004080
20:14:15 8762 8192000000 10825786288 11261284352 1910206928 18.908 100 26 52 2 1923915808 5875808 7833072
20:14:33 6348 8192000000 10837903584 11262812160 1910208416 18.908 100 35 71 1 1926701760 6200256 10293088
20:14:48 2376 8192000000 10833036512 11258667008 1905644672 18.872 100 46 93 2 1926581232 6961424 13975136
20:15:00 4726 8192000000 10827368464 11260342272 1907069456 18.883 100 30 61 0 1921216480 5638992 8508032
20:15:13 6110 8192000000 10805069888 11240288256 1881133248 18.674 99 24 49 0 1894416512 5969968 7313296
20:15:26 7171 8192000000 10806849776 11248635904 1885729824 18.711 99 24 48 1 1897607552 5603456 6274272
20:15:40 4995 8192000000 10812206144 11245174784 1896395760 18.797 100 23 47 3 1909409296 5860080 7153456
20:15:53 6992 8192000000 10824683456 11251499008 1884726288 18.703 99 25 50 1 1898232192 6173680 7332224
20:16:08 8379 8192000000 10788610352 11231494144 1860855152 18.510 98 23 44 1 1872912368 5310720 6746496
20:16:30 15834 8192000000 10780214000 11207573504 1811130736 18.105 96 19 38 0 1821929072 4942208 5856128
20:16:52 53320 8192000000 10790127328 11218849792 1842456832 18.361 98 35 68 1 1857836560 5118688 10261040
20:17:52 14376 8192000000 10715517936 11136237568 1663272176 16.876 89 23 46 0 1674030208 5113568 5644464
20:18:14 8872 8192000000 10756832848 11175055360 1797626896 17.994 98 27 54 1 1812029248 6907120 7495232
20:18:31 5375 8192000000 10744292048 11168071680 1827073360 18.235 100 27 54 2 1840816272 6540784 7202128
20:18:42 6675 8192000000 10704867152 11116122112 1730369776 17.439 96 33 66 2 1746306144 6273136 9663232
20:18:57 6353 8192000000 10731204688 11148013568 1810657168 18.101 100 36 72 2 1828194048 6364864 11172016
20:19:12 8172 8192000000 10711300784 11135246336 1783308400 17.877 98 20 40 0 1794811616 5733632 5769584
20:19:27 7314 8192000000 10719392352 11143495680 1794333456 17.967 99 29 56 3 1808431488 4751040 9346992
20:19:42 6657 8192000000 10699168560 11113742336 1728432304 17.422 96 24 48 2 1741503536 6188064 6883168
20:19:55 8258 8192000000 10698425408 11106582528 1722081120 17.370 96 26 52 1 1734563984 5100304 7382560
20:20:11 11343 8192000000 10674636096 11087319040 1722473344 17.373 96 22 44 0 1734334720 5356512 6504864
20:20:28 10696 8192000000 10706505120 11125522432 1773518496 17.796 99 20 40 1 1784924800 5022064 6384240
20:20:46 8484 8192000000 10721966464 11145805824 1810517360 18.100 100 26 51 2 1823336608 5658000 7161248
20:21:01 10388 8192000000 10727068288 11147567104 1781015872 17.858 98 21 41 1 1792655936 5570160 6069904
20:21:20 47896 8192000000 10740629984 11170062336 1830284848 18.262 100 19 38 1 1845247632 9489056 5473728
20:22:34 11249 8192000000 10754621536 11184181248 1848472096 18.410 100 26 52 3 1862447568 6801904 7173568
20:22:53 8425 8192000000 10769640336 11192795136 1847650368 18.403 100 25 50 4 1860334032 6100768 6582896
20:23:07 5563 8192000000 10773620576 11194417152 1855886624 18.470 100 33 66 3 1871828576 6304000 9637952
20:23:19 5350 8192000000 10764704640 11199008768 1855734976 18.469 100 24 46 2 1869204976 6870016 6599984
20:23:31 4782 8192000000 10769353056 11199094784 1861380768 18.514 100 33 66 0 1877953088 6421360 10150960
20:23:42 8471 8192000000 10773424240 11200421888 1851703936 18.436 100 19 37 2 1867121808 9956544 5461328
20:23:56 9002 8192000000 10767931904 11196485632 1856683040 18.476 100 24 47 3 1868969024 5409152 6876832
20:24:12 7229 8192000000 10776166416 11202060288 1861487088 18.515 100 33 66 2 1877353008 6582688 9283232
20:24:27 8422 8192000000 10764223712 11194920960 1840993936 18.349 99 23 45 2 1852335904 4788096 6553872
20:24:42 8462 8192000000 10772239664 11201859584 1861286208 18.514 100 32 63 3 1877678592 5187744 11204640
20:25:00 10976 8192000000 10773692864 11205066752 1859980592 18.503 100 15 30 1 1869285104 4994448 4310064
20:25:17 14421 8192000000 10774950144 11208380416 1864107376 18.537 100 19 38 0 1875087504 5595920 5384208
20:25:41 10513 8192000000 10773571200 11210043392 1864466416 18.539 100 12 24 0 1873381712 5479136 3436160
20:26:01 10304 8192000000 10783632016 11214172160 1875992992 18.633 100 40 78 2 1893656560 6834544 10829024
20:26:19 90356 8192000000 10807140768 11231297536 1877146592 18.642 100 36 73 0 1893193968 5090048 10957328
20:28:07 25751 8192000000 10836183520 11260788736 1908722480 18.896 100 39 78 2 1929924464 9977952 11224032
20:28:48 9122 8192000000 10852350352 11276214272 1923344592 19.014 100 50 98 5 1948021920 10973440 13703888
20:29:18 15232 8192000000 10862151632 11288412160 1931864784 19.082 100 40 80 1 1955301376 11823728 11612864
20:29:45 20952 8192000000 10855550256 11279609856 1927087264 19.044 100 47 94 0 1953072048 12318240 13666544
20:30:18 20470 8192000000 10862314464 11298488320 1935454432 19.110 100 33 66 3 1958283056 12698000 10130624
20:30:47 26326 8192000000 10881303616 11312267264 1947545392 19.207 100 38 75 3 1972330640 13683008 11102240
20:31:23 14895 8192000000 10870038736 11303071744 1926705184 19.041 99 36 72 3 1953404496 15338896 11360416
20:31:45 9546 8192000000 10870281264 11308056576 1930261296 19.069 99 40 80 3 1958992016 16334944 12395776
20:32:02 9719 8192000000 10879906032 11310170112 1945474528 19.190 100 34 68 2 1970415440 14574416 10366496
20:32:19 7627 8192000000 10887947824 11318530048 1949372032 19.221 100 36 72 1 1974028528 14169728 10486768
20:32:36 25502 8192000000 10906371216 11326382080 1948021344 19.211 99 57 114 1 1981058480 15850768 17186368
20:33:09 13466 8192000000 10902541984 11336945664 1962828672 19.329 100 45 90 2 1998238496 20889024 14520800
20:33:31 26968 8192000000 10904614576 11336916992 1944656224 19.184 99 38 76 0 1978698960 22070816 11971920
20:34:06 8622 8192000000 10911608224 11345018880 1963253488 19.332 100 39 78 0 1999267392 23690592 12323312
20:34:21 5116 8192000000 10915445712 11346862080 1969131408 19.379 100 49 98 2 2010472928 25826528 15514992
20:34:34 10320 8192000000 10938517888 11359547392 1978865440 19.456 100 70 138 1 2024760576 24710976 21184160
20:34:52 3287 8192000000 10939053344 11356852224 1979087776 19.457 100 74 148 0 2023882304 22862544 21931984
20:35:03 3725 8192000000 10951699248 11370770432 1984829328 19.503 100 80 158 1 2031154528 23399344 22925856
20:35:13 3609 8192000000 10945360272 11367944192 1993124992 19.568 100 78 156 0 2039254368 23461872 22667504
20:35:28 3773 8192000000 10936478080 11369238528 1988722720 19.534 100 51 101 3 2025720720 21780944 15217056
20:35:38 3585 8192000000 10940681472 11368443904 1993758464 19.573 100 78 154 3 2037251344 20571024 22921856
20:35:48 1744 8192000000 10957720112 11373301760 1996890944 19.598 100 83 162 3 2040303200 19587984 23824272
20:35:56 4335 8192000000 10959698160 11376328704 2001160400 19.632 100 72 144 0 2043876112 21959104 20756608
20:36:08 1806 8192000000 10963424240 11381424128 2000191600 19.624 100 86 173 0 2047430624 21986160 25252864
20:36:19 4656 8192000000 10970860336 11384029184 2004314624 19.657 100 78 155 0 2051861488 25074848 22472016
20:36:31 6927 8192000000 10959754432 11383500800 1997493408 19.603 100 81 162 0 2048449712 27319456 23636848
20:36:50 4633 8192000000 10955634528 11384475648 1994536160 19.580 100 64 126 1 2043415904 29843344 19036400
20:37:05 8447 8192000000 10945909456 11370299392 1970172192 19.387 99 63 126 2 2017708912 28222464 19314256
20:37:22 1899 8192000000 10960535616 11377922048 1990706448 19.549 100 82 162 2 2042479040 27918560 23854032
20:37:34 7325 8192000000 10932561696 11361599488 1953042816 19.251 98 65 128 1 2000232336 27934000 19255520
20:37:48 6935 8192000000 10944777184 11368013824 1980350928 19.467 100 70 140 1 2033611040 32103392 21156720
20:38:04 3734 8192000000 10966390112 11389353984 1990426544 19.547 100 70 138 0 2048984928 37458816 21099568
20:38:15 1947 8192000000 10951415296 11372392448 1983357392 19.491 100 78 157 0 2037549056 30641712 23549952
20:38:25 2401 8192000000 10947523840 11373518848 1983847040 19.495 100 66 132 0 2036944624 31643568 21454016
20:38:37 2779 8192000000 10964483808 11382194176 1974761456 19.423 99 81 162 1 2030701312 31198416 24741440
20:38:48 5309 8192000000 10958696240 11374596096 1985347760 19.507 100 80 160 2 2042762928 32869232 24545936
20:39:02 3715 8192000000 10969030624 11385004032 1990199168 19.545 100 86 173 0 2054066192 37437040 26429984
20:39:13 1459 8192000000 10977661840 11394306048 1997568832 19.604 100 85 169 1 2063250416 39639760 26041824
20:39:23 1733 8192000000 10967324928 11379773440 1984688096 19.502 100 88 176 1 2053035760 40520592 27827072
20:39:31 1272 8192000000 10947265808 11356971008 1948768848 19.217 99 93 185 0 2019211104 41647584 28794672
20:39:39 2690 8192000000 10916580144 11336298496 1935035904 19.107 99 65 130 0 1995717520 39644112 21037504
20:39:50 3872 8192000000 10925920064 11343532032 1949156912 19.220 100 74 146 0 2009858352 37829680 22871760
20:40:03 1813 8192000000 10922383392 11334598656 1931120208 19.076 99 80 160 3 1990989840 35542496 24327136
20:40:11 2004 8192000000 10924771296 11345924096 1950515760 19.231 100 72 139 4 2009446832 37602240 21328832
20:40:20 5814 8192000000 10898526880 11332251648 1914068448 18.939 98 50 100 2 1960512576 31565344 14878784
20:40:36 25056 8192000000 10876012848 11309236224 1871407056 18.596 97 36 72 0 1912863040 29713040 11742944
20:41:08 9901 8192000000 10874545792 11298840576 1906367344 18.877 99 47 94 4 1944796736 23523824 14905568
20:41:25 1673 8192000000 10910501744 11318185984 1939266800 19.141 100 87 174 2 1991450080 26096464 26086816
20:41:33 7315 8192000000 10890879232 11323662336 1938364864 19.134 100 53 106 1 1982336112 27948000 16023248
20:42:09 4309 8192000000 10902457728 11327074304 1937202832 19.124 100 52 104 1 1983578944 29519808 16856304
20:42:22 4667 8192000000 10906420704 11331031040 1926472640 19.039 99 50 100 0 1978786048 36519920 15793488
20:42:34 13366 8192000000 10876703152 11323346944 1906519984 18.879 98 28 56 2 1951175152 35814304 8840864
20:42:55 7858 8192000000 10893126928 11333210112 1907986720 18.890 98 37 73 2 1950222064 31164864 11070480
20:43:10 9581 8192000000 10858567664 11294838784 1890327632 18.748 98 34 68 3 1928879056 27740800 10810624
20:43:58 27443 8192000000 10849281888 11286167552 1836882432 18.315 96 20 40 0 1871762176 28275872 6603872
20:44:32 17398 8192000000 10861167232 11293523968 1876062080 18.633 98 28 56 2 1916885296 31492832 9330384
20:44:57 1061 8192000000 10879161248 11298115584 1907265296 18.885 100 61 124 1 1959736272 33005792 19465184
20:45:09 13583 8192000000 10863281888 11300241408 1905725808 18.872 100 25 49 1 1945220768 31295920 8199040
20:45:31 14623 8192000000 10863942688 11299135488 1873717120 18.614 98 19 37 2 1910881712 30577600 6586992
20:45:57 25854 8192000000 10864137456 11311554560 1898399104 18.813 99 19 38 0 1935082608 30198256 6485248
20:46:29 28222 8192000000 10866819792 11315167232 1899120240 18.819 99 13 26 1 1933821568 29911936 4789392
20:47:11 18337 8192000000 10870606464 11299311616 1897003872 18.802 99 27 54 1 1932568816 26318336 9246608
20:47:38 1769 8192000000 10886043600 11306991616 1918553072 18.975 100 61 120 2 1964531760 27480688 18498000
20:47:46 5428 8192000000 10883027136 11314532352 1926594816 19.040 100 64 128 0 1972162272 25681248 19886208
20:47:58 10034 8192000000 10890639264 11324350464 1927977104 19.051 100 43 86 1 1967417648 26249008 13191536
20:48:18 4372 8192000000 10863614400 11291422720 1895747968 18.792 98 39 78 2 1933224672 26305984 11170720
20:48:30 14354 8192000000 10865120272 11322470400 1926679840 19.040 100 22 44 0 1961385024 27567552 7137632
20:49:04 23117 8192000000 10870458672 11318677504 1931742992 19.081 100 19 38 0 1949575952 11616416 6216544
20:49:41 58153 8192000000 10887676128 11334770688 1938034064 19.131 99 41 80 2 1966556800 16610272 11912464
20:50:45 139328 8192000000 10885674848 11348983808 1950065888 19.227 100 31 62 5 1981145680 20988720 10091072
20:53:15 74874 8192000000 10873169600 11343650816 1948056864 19.211 100 10 20 1 1971471632 20637296 2777472
20:54:40 112990 8192000000 10853508400 11318657024 1905116800 18.867 98 25 51 1 1925282432 12157184 8008448
20:56:42 66428 8192000000 10876368784 11328901120 1916784144 18.961 98 18 35 0 1928792144 7432624 4575376
20:57:59 54115 8192000000 10881881712 11349450752 1965958656 19.353 100 8 16 1 1974189168 6334672 1895840
21:00:18 79324 8192000000 10896187936 11360428032 1961844544 19.321 99 13 26 0 1976030560 10611152 3574864
21:01:52 78928 8192000000 10858977904 11336892416 1909154064 18.900 97 11 21 0 1925473408 13519024 2800320
21:03:17 38139 8192000000 10880475040 11348574208 1953246768 19.252 99 13 26 0 1964700240 7829536 3623936
21:04:05 38346 8192000000 10918684848 11376689152 1980716032 19.470 100 16 32 0 1996912576 11138816 5057728
21:04:49 86051 8192000000 10915097600 11382689792 1963286448 19.332 99 16 32 0 1981107360 13454192 4366720
21:06:29 77527 8192000000 10914909632 11381698560 1948796256 19.217 98 17 34 1 1961692544 8653504 4242784
21:07:53 61431 8192000000 10941000016 11401433088 1993812496 19.574 100 33 66 2 2020428112 17496416 9119200
21:09:09 43422 8192000000 10947062288 11389374464 1979556624 19.461 99 33 66 1 2006127888 17177488 9393776
21:10:00 40070 8192000000 10949133664 11403702272 2007134944 19.679 100 44 88 1 2032982672 13492720 12355008
21:10:55 35279 8192000000 10931649440 11399352320 1979970816 19.464 99 35 70 1 2004770992 15293760 9506416
21:11:41 101394 8192000000 10917759984 11396141056 1955953840 19.274 98 20 40 0 1972526192 11573920 4998432
21:14:24 71600 8192000000 10923449232 11382763520 1947311856 19.205 98 20 40 2 1972842416 19301712 6228848
21:15:45 68547 8192000000 10921555904 11384766464 1956158512 19.275 98 16 32 0 1970656704 10384112 4114080
21:18:35 65903 8192000000 10892155424 11361492992 1879352480 18.660 94 26 52 2 1894836528 7804544 7679504
21:19:47 61159 8192000000 10901619616 11365203968 1934494624 19.103 98 34 69 0 1956954800 12915184 9544992
21:21:12 37401 8192000000 10861331296 11338690560 1913914512 18.938 97 19 38 0 1926648208 7331984 5401712
21:22:03 51429 8192000000 10875628368 11356467200 1948847328 19.217 99 11 22 1 1959940912 8204448 2889136
21:23:01 37145 8192000000 10897514208 11367165952 1949422352 19.222 99 21 43 0 1962802960 7826816 5553792
21:23:50 53426 8192000000 10876160944 11348807680 1920907984 18.994 97 8 16 0 1929953232 6849248 2196000
21:24:50 52596 8192000000 10891087728 11368960000 1976184544 19.434 100 12 24 1 1988104160 8020976 3898640
21:26:06 56239 8192000000 10860529328 11332964352 1872004016 18.600 95 17 34 3 1886625664 9163728 5457920
21:27:11 47011 8192000000 10858903648 11348254720 1947994464 19.211 100 10 20 1 1963382384 12536400 2851520
21:28:06 31022 8192000000 10847903712 11309322240 1901492256 18.838 97 23 46 2 1915341520 7399296 6449968
21:28:58 71339 8192000000 10890425680 11359576064 1923872576 19.018 98 17 34 1 1944962368 16083424 5006368
21:30:15 34981 8192000000 10872278096 11340673024 1876074704 18.633 95 18 35 0 1895105440 13845024 5185712
21:31:05 75051 8192000000 10852245056 11325542400 1832942608 18.283 94 20 38 0 1852355856 14514352 4898896
21:32:28 74441 8192000000 10847537488 11314987008 1833184912 18.285 95 20 40 2 1854681744 15973792 5523040
21:33:55 94456 8192000000 10845080464 11286679552 1762980928 17.709 92 18 36 0 1777377056 10021296 4374832
21:35:41 18372 8192000000 10854929056 11292729344 1891003984 18.754 99 50 98 2 1915856080 10842240 14009856
21:36:09 18109 8192000000 10878365648 11313188864 1922145968 19.004 100 57 113 0 1951531696 12812096 16573632
21:36:49 47618 8192000000 10843158880 11297185792 1861640080 18.517 97 33 66 0 1886750912 15982512 9128320
21:37:48 45132 8192000000 10837216704 11292672000 1866771552 18.558 98 30 60 2 1892702880 17696224 8235104
21:38:42 86939 8192000000 10853225776 11335561216 1889780352 18.744 99 12 24 0 1917589152 23899152 3909648
21:40:15 104420 8192000000 10850946512 11327090688 1891145136 18.755 98 6 12 0 1911376160 18627936 1603088
21:43:20 54859 8192000000 10874158272 11328712704 1947252080 19.205 100 28 56 1 1963460704 8476080 7732544
21:44:26 41164 8192000000 10876584272 11339776000 1933648752 19.096 99 17 34 0 1951132432 12836784 4646896
21:45:15 55152 8192000000 10875032752 11351728128 1950927472 19.234 100 8 16 0 1963675216 10383920 2363824
21:46:32 58075 8192000000 10883745584 11360645120 1956693664 19.280 100 11 22 0 1974368336 14721312 2953360
21:47:36 68130 8192000000 10872938960 11344904192 1924984448 19.027 98 12 24 1 1938085136 9799664 3301024
21:48:56 74115 8192000000 10888255408 11364732928 1965603776 19.351 100 19 38 0 1985197232 13311152 6282304
21:50:23 50478 8192000000 10895918864 11369537536 1966436256 19.357 100 9 18 1 1982082736 12833936 2812544
21:51:20 51697 8192000000 10901017168 11363766272 1953706544 19.256 99 18 36 0 1970631472 11499968 5424960
21:52:19 64539 8192000000 10907867968 11383595008 1956213168 19.276 99 12 24 3 1971469168 11808176 3447824
21:54:08 70445 8192000000 10898278576 11366596608 1915652432 18.952 97 18 36 2 1935682400 14642096 5387872
21:55:30 52625 8192000000 10884053456 11353604096 1923563200 19.015 98 17 33 0 1937706240 9149552 4993488
21:56:31 67662 8192000000 10883676224 11348987904 1920012720 18.987 98 21 43 1 1936990928 10952432 6025776
21:57:45 72035 8192000000 10892274400 11367026688 1946338240 19.197 99 15 30 0 1968610448 18228032 4044176
21:59:03 49045 8192000000 10899422464 11370180608 1952410496 19.246 99 15 30 0 1966999024 10626304 3962224
22:00:02 60794 8192000000 10896401616 11366252544 1938934928 19.138 98 13 26 0 1951488608 9197648 3356032
22:01:09 94709 8192000000 10934179648 11379773440 1937625568 19.128 97 23 46 1 1952134400 8753200 5755632
22:02:54 68724 8192000000 10914806176 11395833856 1954464880 19.262 98 29 59 1 1981367872 18167056 8735936
22:05:13 86053 8192000000 10923647040 11380404224 1986331616 19.515 100 28 56 1 2007541408 12053504 9156288
22:06:45 67336 8192000000 10895835456 11369537536 1919910320 18.986 97 17 34 0 1935943888 11655584 4377984
22:08:03 11811 8192000000 10886377952 11368284160 1953331312 19.253 99 16 32 0 1973146640 15362192 4453136
22:08:21 58741 8192000000 10884289360 11355901952 1934533264 19.103 98 13 26 1 1952317280 13965184 3818832
22:10:08 77477 8192000000 10879309056 11348209664 1927014496 19.043 98 14 28 1 1944401920 13435744 3951680
22:11:40 37447 8192000000 10878929648 11352723456 1936251504 19.117 99 10 20 0 1955461296 16017664 3192128
22:12:34 57955 8192000000 10873627584 11341090816 1921136992 18.996 98 17 34 0 1933918512 8162000 4619520
22:13:39 54423 8192000000 10861836240 11326799872 1897733440 18.808 97 21 42 0 1912227360 8130496 6363424
22:14:39 77738 8192000000 10884978096 11351830528 1946452896 19.198 99 22 44 0 1960539232 8233968 5852368
22:16:06 112845 8192000000 10857907584 11338895360 1901059008 18.835 97 7 14 2 1912485040 9367344 2058688
22:18:48 27694 8192000000 10871014064 11337637888 1918135984 18.972 98 19 38 2 1933962432 10754992 5071456
22:19:23 57760 8192000000 10869359664 11340156928 1920055776 18.987 98 26 53 0 1936185856 9287152 6842928
22:20:28 50811 8192000000 10878938416 11337129984 1929512768 19.063 99 32 64 0 1948278896 9845824 8920304
22:21:27 40282 8192000000 10866105088 11328335872 1870695632 18.590 96 30 60 2 1891482160 12680160 8106368
22:22:14 74276 8192000000 10827282112 11312132096 1829357056 18.254 95 14 28 0 1848042288 14930480 3754752
22:24:11 38230 8192000000 10852953552 11302690816 1898151824 18.811 99 23 45 3 1915546624 10585536 6809264
22:24:56 101272 8192000000 10842659376 11289190400 1824432752 18.214 95 20 39 1 1841462176 11780688 5248736
22:26:44 14314 8192000000 10847873232 11292532736 1892825136 18.769 99 43 84 1 1914691040 9874672 11991232

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 15-12-2020 22:28:07 to 15-12-2020 22:28:37.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-12-2020 22:28:38 to 15-12-2020 22:28:40.

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          250096
MON$OLDEST_ACTIVE               252849
MON$OLDEST_SNAPSHOT             252849
MON$NEXT_TRANSACTION            252849
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                       2007872
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.33400 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33400 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33400 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 ---
:100: 
:101: mscs-test-161.budzdorov.ru    Tue Dec 15 22:27:08 2020
:102:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:103: 
:104: 
:105: mscs-test-161.budzdorov.ru    Tue Dec 15 22:27:09 2020
:106:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:107: 
:108: 
:109: mscs-test-161.budzdorov.ru    Tue Dec 15 22:27:09 2020
:110:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:111: 
:112: 
:113: mscs-test-161.budzdorov.ru    Tue Dec 15 22:27:09 2020
:114:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:115: 
:116: 
:117: mscs-test-161.budzdorov.ru    Tue Dec 15 22:27:09 2020
:118:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:119: 
:120: 
:121: mscs-test-161.budzdorov.ru    Tue Dec 15 22:27:09 2020
:122:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:123: 
--- end of diff output ---

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

15.12.20 22:28:41. 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-12-15 22:28:43 No severe PSQL-related problems occured
15.12.20 22:28:45. End of report.