The output of explain is not "parse this SQL statement and show me what it means... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

saurik on July 24, 2017 | parent | context | favorite | on: Pev: Postgres ‘Explain’ Visualizer (2016)

The output of explain is not "parse this SQL statement and show me what it means" but "given this SQL statement, how will it be executed on this database (which is affected by the table's stored statistics and takes into account any indexes)". I am thereby not sure how these query parsing libraries are relevant.

j_s on July 24, 2017 [–]

Thanks for taking the time to comment (?).

Never-before-on-the-HN-front-page tools for working with PostgreSQL queries seemed relevant to me; this info may help a few others.

Consider applying for YC's Fall 2026 batch! Applications are open till July 27.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact