Profile Window with SQL Queries

Use to monitor and capture data during a SQL queries session.

The following table shows the available actions.

Element Description

Results

Pause live results iconPause live results

Click to pause the live results display.

Update live results iconUpdate live results

Click to update the live results display.

Show delta values iconShow delta values

Click to either show delta values or absolute values.
Collected Data

Take snapshot iconSnapshot

Click to take a snapshot of the session.

Reset collected results iconReset Collected Results

Click to reset the collected results.
Process

Thread dump iconThread Dump

Click to create a textual dump of all active threads and monitors of the profiled application.

Heap dump iconHeap Dump

Click to save an image of the current heap content of the profiled process in .hprof format.

Garbage collection iconGC

Click to request the JVM of the profiled process to invoke garbage collection.
Settings buttonSettings Click to display and select or hide the profiling options: All queries or Defined queries.
Profile
All Queries Displays and profiles all queries contained in your application.
Defined Queries Displays and profiles specified queries in your application.
SQL Query Displays a list of queries. You can sort the list by clicking a column heading.
Total Time Displays total of time spent on a SQL query. You can sort the list by clicking a column heading.
Invocations Displays the number of the selected query invocations. You can sort the list by clicking a column heading.
Statement Type Displays the type of an SQL query. The options are: Callable, Prepared, Regular. You can sort the list by clicking a column heading.
Command Type Displays the type of a SQL command (for example, Select or Delete). You can sort the list by clicking a column heading.
Table Displays the name of a database table that a SQL query accesses. You can sort the list by clicking a column heading.
Statements
Regular Select to display queries with regular Statements in the SQL Query table.
Prepared Select to display queries with PreparedStatements in the SQL Query table.
Callable Select to display queries with CallableStatements in the SQL Query table.
Commands Specify the value of a command for a query to be displayed in the SQL Query table.
Tables Specify the value of a table for a query to be displayed in the SQL Query table.
Apply Click to apply the selected Statements options and specified Commands and Tables options.
Filter Specify the value of a filter.
Filter resultsFilter results Click to apply the specified filter.
Filter type Opens a submenu that enables you to select a filter for the types of queries to display. You can select any of the following filters:
ContainsContains Displays queries that contain the specified filter value.
Does not containDoes Not Contain Displays queries that do not contain the specified filter value.
Regular expessionRegular Expression Displays queries that contain the specified regular expression.
Match caseMatch case Click to filter for the queries that match the case of the specified filter value.


Related Topics

Developing Applications with NetBeans IDE,

Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements; and to You under the Apache License, Version 2.0.