explain analyze to find indexes is a hassle

I'm sure I'm missing something, but is there not an easier way to get my queries EXPLAIN ANALYZE'd ? Logging the queries includes dollar signs to be interoplated, so they cannot be EXPLAINed directly.

What I'm really after is a helper to tell me what indexes I need.
Was this page helpful?