explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v37Q : T

Settings
# exclusive inclusive rows x rows loops node
1. 16.104 16.233 ↓ 1.2 7 1

Sort (cost=29.71..29.73 rows=6 width=64) (actual time=0.189..16.233 rows=7 loops=1)

  • Sort Key: books.title
2. 0.044 0.129 ↓ 1.2 7 1

Nested Loop (cost=0.00..29.63 rows=6 width=64) (actual time=0.068..0.129 rows=7 loops=1)

3. 0.033 0.033 ↑ 1.0 1 1

Index Scan using authors_pkey on authors (cost=0.00..5.82 rows=1 width=36) (actual time=0.029..0.033 rows=1 loops=1)

  • Index Cond: (id = 16)
4. 0.052 0.052 ↓ 1.2 7 1

Seq Scan on books (cost=0.00..23.75 rows=6 width=36) (actual time=0.026..0.052 rows=7 loops=1)

  • Filter: (author_id = 16)
Total runtime : 16.386 ms