medium10 pts · first answer countsindexingquery-tuning
Reading loops in a plan
In EXPLAIN ANALYZE, the inner side of a Nested Loop shows the line below. Roughly how much total time did this node take?
Index Scan using customers_pkey on customers (actual time=0.020..0.025 rows=1 loops=40000)
Discussion 0
Join free to post in the discussion.
Related questions
- When a B-tree index helpsDatabase Administrator
- Finding slow MySQL queriesDatabase Administrator
- Index on a yes/no columnDatabase Administrator
- How InnoDB stores table rowsDatabase Administrator
- What an InnoDB secondary index points toDatabase Administrator
- LIKE with a leading %Database Administrator
- What a hash index supportsDatabase Administrator
- Cost of extra indexes on insertsDatabase Administrator