/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

newvick.com
| | sophiabits.com
3.8 parsecs away

Travel
| | [AI summary] A developer explains how to use the pg_stat_statements PostgreSQL extension to identify slow queries and optimize database performance by analyzing execution metrics like rows per call.
| | e7e6.github.io
3.1 parsecs away

Travel
| | With Michael of pgMustard fame current host of #PGSQLPhriday, I could not resist revisiting this rather abondoned place of the interweb. As a short prelude, PGSQL Phriday is a blog event to talk of all things PostgreSQL and this week topic is about pg_stat_statements. pg_stat_statement is a module available since 2009 in Postgres 8.4. It tracks execution statistics on all SQL statements that have been executed. Since version 13, it also tracks planning statistics.
| | akorotkov.github.io
3.8 parsecs away

Travel
| | [AI summary] A technical article demonstrates how to implement efficient faceted search for mailing list archives using a single PostgreSQL SQL query with window functions and CTEs.
| | sqlserver-help.com
30.3 parsecs away

Travel
| 1 post published by blakhani on March 18, 2014