Re:Ask HN: What do I need to learn how to write a scalable app?
by protonimitate on Thursday June 04, 2020 @10:57AM
(#23417438)
> 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).
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.