pganalyze

Automated EXPLAIN Plan Visualization & Insights for Postgres

3 followers

pganalyze provides deep insights into Postgres. Other monitoring tools show you what happened. pganalyze tells you why. We've just introduced automated EXPLAIN plan collection, visualization and insights, so you know exactly why queries are slow.

This is the 2nd launch from pganalyze. View more

pganalyze Index Advisor for Postgres

A better way to index your Postgres database

The index advisor makes recommendations for creating the best indexes for your Postgres queries, based on the schema and table statistics information. Improve query performance and save developer time by quickly getting the right CREATE INDEX command.

pganalyze Index Advisor for Postgres gallery image

Free

Launch tags:

Developer Tools

Launch Team

Lukas Fittl

pganalyze

Maker

We're launching the new pganalyze Index Advisor today (https://pganalyze.com/blog/intro...) - this is both a free standalone tool, as well as an automatic experience for pganalyze customers. Based on the Postgres queries, as well as the schema and table sizes, we calculate which indexes work best for the query. We've built the index advisor using the Postgres planner itself, which knows best which indexes need to be created. In the browser we run using the planner code compiled to WebAssembly, with all data staying local within your browser. Feedback & thoughts welcome! :)

Report

4yr ago