explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WEMt

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

Sort (cost=349.91..350.41 rows=200 width=31) (actual rows= loops=)

  • Sort Key: (count(*)) DESC
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=305.67..342.27 rows=200 width=31) (actual rows= loops=)

  • Hash Cond: (author.id = book_author.author_id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on author (cost=0.00..31.89 rows=1,789 width=23) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=303.17..303.17 rows=200 width=12) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

HashAggregate (cost=299.17..301.17 rows=200 width=12) (actual rows= loops=)

  • Group Key: book_author.author_id
6. 0.000 0.000 ↓ 0.0

HashAggregate (cost=229.65..257.46 rows=2,781 width=8) (actual rows= loops=)

  • Group Key: book_author.author_id, book.id
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=157.31..215.74 rows=2,781 width=8) (actual rows= loops=)

  • Hash Cond: (book_edition.book_id = book.id)
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=74.50..125.62 rows=2,781 width=8) (actual rows= loops=)

  • Hash Cond: (book_author.book_edition_id = book_edition.id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on book_author (cost=0.00..43.81 rows=2,781 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=40.89..40.89 rows=2,689 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on book_edition (cost=0.00..40.89 rows=2,689 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=49.58..49.58 rows=2,658 width=4) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on book (cost=0.00..49.58 rows=2,658 width=4) (actual rows= loops=)