explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Owwm

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

Hash Left Join (cost=23,855.61..1,717,091.10 rows=63 width=4) (actual rows= loops=)

  • Hash Cond: (auction_auction.id = auction_successfulcompletedauction.auction_id)
  • Filter: ((((wall_post.type)::text = 'purchase'::text) AND (wall_post.creator_id = 84307) AND (wall_post.previous_post_id IS NULL)) OR (((auction_auction.status)::text = 'sold'::text) AND (auction_successfulcompletedauction.winner_id = 84307) AND ((wall_post.creator_id <> 84307) OR (wall_post.creator_id IS NULL))) OR (((wall_post.type)::text = 'purchase'::text) AND (wall_post.creator_id = 84307) AND ((t3.type)::text = 'sale'::text)))
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=23,659.06..1,716,507.21 rows=84,889 width=34) (actual rows= loops=)

  • Hash Cond: (wall_post.id = auction_auction.post_id)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=13,707.23..1,703,285.30 rows=84,889 width=22) (actual rows= loops=)

  • Hash Cond: (wall_post.previous_post_id = t3.id)
4. 0.000 0.000 ↓ 0.0

Index Scan using wall_post_is_deleted_66239426 on wall_post (cost=0.42..1,687,133.29 rows=84,889 width=17) (actual rows= loops=)

  • Index Cond: (is_deleted = false)
  • Filter: ((NOT is_deleted) AND (NOT (SubPlan 1)))
5.          

SubPlan (for Index Scan)

6. 0.000 0.000 ↓ 0.0

Index Scan using wall_post_previous_post_id_06bab8a8 on wall_post u0 (cost=0.42..9.76 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (previous_post_id = wall_post.id)
  • Filter: ((NOT is_deleted) AND (NOT is_draft))
7. 0.000 0.000 ↓ 0.0

Hash (cost=9,741.25..9,741.25 rows=228,125 width=9) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on wall_post t3 (cost=0.00..9,741.25 rows=228,125 width=9) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=6,000.81..6,000.81 rows=227,281 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on auction_auction (cost=0.00..6,000.81 rows=227,281 width=16) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=119.58..119.58 rows=6,158 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on auction_successfulcompletedauction (cost=0.00..119.58 rows=6,158 width=8) (actual rows= loops=)