Postgres - Cool and Useful Postgresql Tools
Cool and Useful PostgreSQL tools#
Visualisers#
- PEV2 - Postgresql EXPLAIN Visualizer - a vuejs html file - just put the result of
EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS, FORMAT JSON) <your query>in the input.
Log Analyser#
- pgbadger - a perl based command line aggregator of a static log file
Performance#
- Connection Pooler for PostgreSQL - useful for a large number of connections and load (not response time)
- pgbench - run a benchmark test on PostgreSQL
Development#
Python#
- aiosql - Using SQL as code (no ORM)