explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TrMvO

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=79.03..2,462.86 rows=118 width=197) (never executed)

2.          

Initplan (for Hash Join)

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=22.29..22.3 rows=1 width=32) (never executed)

4. 0.000 0.000 ↓ 0.0

Limit (cost=0.28..22.25 rows=3 width=32) (never executed)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..117.43 rows=16 width=32) (never executed)

6. 0.000 0.000 ↓ 0.0

Seq Scan on authors a (cost=0..40.95 rows=195 width=552) (never executed)

7. 0.000 0.000 ↓ 0.0

Materialize (cost=0.28..29.64 rows=16 width=4) (never executed)

8. 0.000 0.000 ↓ 0.0

Index Only Scan using books2authors_pkey on books2authors b2a (cost=0.28..29.56 rows=16 width=4) (never executed)

  • Index Cond: (b2a.id_book = 27)
9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=43.58..747.99 rows=118 width=105) (never executed)

10. 0.000 0.000 ↓ 0.0

Sort (cost=43.3..43.66 rows=143 width=4) (never executed)

  • Sort Key: g2b2.id_book
11. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on genres2books g2b2 (cost=5.39..38.18 rows=143 width=4) (never executed)

12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on genres_index (cost=0..5.35 rows=143 width=0) (never executed)

  • Index Cond: (g2b2.id_genre = 196)
13. 0.000 0.000 ↓ 0.0

Index Scan using books_pkey on books b (cost=0.28..4.92 rows=1 width=105) (never executed)

  • Index Cond: (b.id_book = g2b2.id_book)
  • Filter: (NOT b.deleted)
14. 0.000 0.000 ↓ 0.0

Hash (cost=11.4..11.4 rows=140 width=36) (never executed)

15. 0.000 0.000 ↓ 0.0

Seq Scan on series s (cost=0..11.4 rows=140 width=36) (never executed)

16.          

SubPlan (for Hash Join)

17. 0.000 0.000 ↓ 0.0

Aggregate (cost=14.22..14.23 rows=1 width=32) (never executed)

18. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.31..14.21 rows=1 width=38) (never executed)

19. 0.000 0.000 ↓ 0.0

Seq Scan on genres g (cost=0..5.29 rows=229 width=42) (never executed)

20. 0.000 0.000 ↓ 0.0

Hash (cost=8.3..8.3 rows=1 width=4) (never executed)

21. 0.000 0.000 ↓ 0.0

Index Only Scan using genres2books_pkey on genres2books g2b (cost=0.28..8.3 rows=1 width=4) (never executed)

  • Index Cond: (g2b.id_book = b.id_book)
Planning time : 0.527 ms