SQL-Profiler

SQL-Profiler is a tool provided by EnterpriseDB that captures and analyzes SQL statements executed by the database server.

The key features of SQL-Profiler include real-time SQL statement capture, detailed query performance statistics, graphical representation of query plans, and the ability to identify and troubleshoot performance bottlenecks.

SQL-Profiler captures SQL statements by hooking into the PostgreSQL server process using the extension framework provided by PostgreSQL.

Yes, SQL-Profiler can capture queries from all users configured on the database server.

Yes, SQL-Profiler provides powerful filtering capabilities to focus on specific queries based on various criteria like username, database, query duration, query text, etc.

Yes, SQL-Profiler can display query execution plans in a graphical format, helping users to visualize and understand how queries are processed by the PostgreSQL optimizer.

Yes, SQL-Profiler allows exporting captured data in different formats like CSV, JSON, or plain text for further analysis or sharing with other team members.

While capturing queries incurs some overhead, SQL-Profiler is designed to have minimal impact on database performance. However, it is recommended to enable SQL-Profiler only when necessary.

SQL-Profiler is compatible with PostgreSQL versions 9.5 and later. It does not require any additional hardware but it is recommended to allocate sufficient disk space for storing captured data.

Yes, SQL-Profiler is available as part of the EnterpriseDB Postgres Platform and can be used without any additional cost for Postgres Plus Advanced Server customers.