explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eQqA

Settings
# exclusive inclusive rows x rows loops node
1. 206.659 250.929 ↓ 5.2 890,723 1

Hash Join (cost=4,490.44..7,423.81 rows=172,780 width=91) (actual time=24.199..250.929 rows=890,723 loops=1)

  • Hash Cond: (post_to_tag_link_1.tag_id = tag.id)
2. 15.212 41.092 ↑ 1.0 32,633 1

Hash Join (cost=4,385.07..5,305.10 rows=32,633 width=4) (actual time=21.010..41.092 rows=32,633 loops=1)

  • Hash Cond: (post_to_tag_link_1.post_id = post.id)
3. 4.942 4.942 ↑ 1.0 32,633 1

Seq Scan on post_to_tag_link post_to_tag_link_1 (cost=0.00..471.33 rows=32,633 width=8) (actual time=0.016..4.942 rows=32,633 loops=1)

4. 7.953 20.938 ↑ 1.0 24,492 1

Hash (cost=4,078.92..4,078.92 rows=24,492 width=4) (actual time=20.938..20.938 rows=24,492 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1118kB
5. 12.985 12.985 ↑ 1.0 24,492 1

Seq Scan on post (cost=0.00..4,078.92 rows=24,492 width=4) (actual time=0.009..12.985 rows=24,492 loops=1)

6. 0.615 3.178 ↓ 1.1 1,318 1

Hash (cost=90.55..90.55 rows=1,186 width=99) (actual time=3.178..3.178 rows=1,318 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 196kB
7. 0.698 2.563 ↓ 1.1 1,318 1

Hash Join (cost=40.07..90.55 rows=1,186 width=99) (actual time=0.843..2.563 rows=1,318 loops=1)

  • Hash Cond: (card_to_tag_link_1.tag_id = tag.id)
8. 0.825 1.714 ↓ 1.1 1,318 1

Hash Join (cost=30.03..64.20 rows=1,186 width=95) (actual time=0.688..1.714 rows=1,318 loops=1)

  • Hash Cond: (card_to_tag_link_1.card_id = card.id)
9. 0.228 0.228 ↓ 1.1 1,318 1

Seq Scan on card_to_tag_link card_to_tag_link_1 (cost=0.00..17.86 rows=1,186 width=8) (actual time=0.016..0.228 rows=1,318 loops=1)

10. 0.357 0.661 ↑ 1.0 757 1

Hash (cost=20.57..20.57 rows=757 width=91) (actual time=0.661..0.661 rows=757 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 104kB
11. 0.304 0.304 ↑ 1.0 757 1

Seq Scan on card (cost=0.00..20.57 rows=757 width=91) (actual time=0.011..0.304 rows=757 loops=1)

12. 0.066 0.151 ↑ 1.0 224 1

Hash (cost=7.24..7.24 rows=224 width=4) (actual time=0.150..0.151 rows=224 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
13. 0.085 0.085 ↑ 1.0 224 1

Seq Scan on tag (cost=0.00..7.24 rows=224 width=4) (actual time=0.015..0.085 rows=224 loops=1)