PostgreSQL
EXPLAIN, ANALYZE, BUFFERS: Three Different Questions
Which variant you ran decides whether the numbers in front of you are the planner's estimate or a measurement, and whether the pages came from cache.
· 4 min
tag
#performance
Articles tagged “performance” on SQLPress — 2 in total.
2 articles
SQL Fundamentals
N+1 Queries: What the ORM Is Actually Doing
One query for the list, then one more for every item in it. The cost is per statement, which is why the profiler shows a fast database and a slow request.
· 3 min