On: The many faces of DISTINCT in Postgres (2017)

[swader999]

I throw it lines of logs of sql from Paper trail and ask it to extract the SQL statements. Then I give it the analyse explain output. Sometimes ChatGPT will give me great advice on optimizing.

[cpursley → swader999]

Dang, that's a good idea (as long as not production data).

It seems like eventually database automation is going be self-optimizing (more than the query planner already is).