explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gsg

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 161.506 291.131 ↑ 1.0 26,284 1

Nested Loop (cost=0.00..10,715.90 rows=26,284 width=4,449) (actual time=0.054..291.131 rows=26,284 loops=1)

2. 50.773 50.773 ↑ 1.0 26,284 1

Index Scan using books_index_title on books (cost=0.00..3,306.28 rows=26,284 width=3,357) (actual time=0.033..50.773 rows=26,284 loops=1)

3. 78.852 78.852 ↑ 1.0 1 26,284

Index Scan using categories_pkey on categories (cost=0.00..0.27 rows=1 width=1,092) (actual time=0.002..0.003 rows=1 loops=26,284)

  • Index Cond: (categories.id = books.category_id)