PG_STAT_STATEMENTS
PG_STAT_STATEMENTS is a SQL statement in the PostgreSQL Specific category. PostgreSQL extension: tracks query execution statistics (planning time, execution time, rows, blocks hit/read). The syntax is SELECT * FROM pg_stat_statements ORDER BY total_exec_time DESC;. It returns query statistics. A typical example: CREATE EXTENSION IF NOT EXISTS pg_stat_statements; -- Top by total time: SELECT queryid, query, calls, total_exec_time / 1000 AS total_sec, mean_exec_time AS avg_ms, rows / calls AS avg_rows FROM pg_stat_statements WHERE query NOT LIKE '%pg_%' -- Exclude system queries ORDER BY total_exec_time DESC LIMIT 20; -- Reset statistics: SELECT pg_stat_statements_reset(); A close relative is SERIAL, which postgreSQL auto-increment type. Creates an INTEGER column with a sequence. Equivalent to AUTO_INCREMENT in MySQL. A close relative is RETURNING, which postgreSQL extension that returns values from INSERT/UPDATE/DELETE statements (like OUTPUT in SQL Server). A close relative is ARRAY, which postgreSQL supports array columns and array operations. Can be multi-dimensional.