2 ms·
> Did you check "explain analyze"[1] to check your query plans to ensure that the indexes are being used or not? Word of caution `explain analyze` actually exe
by protonimitate 6y ago
> Did you check "explain analyze"[1] to check your query plans to ensure that the indexes are being used or not?
Word of caution `explain analyze` actually executes the query and then returns the execution plan. Just `explain` will give you the estimated plan without executing (although usually less accurate than the analyze counterpart).
Learned that one the hard way.