explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LstH

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

Aggregate (cost=3,618,407.48..3,618,407.49 rows=1 width=8) (actual rows= loops=)

2.          

CTE cp_audits

3. 0.000 0.000 ↓ 0.0

Index Only Scan using auditable_index on audits (cost=0.57..3,585,159.73 rows=104,521 width=16) (actual rows= loops=)

  • Index Cond: (auditable_type = 'ClientProject'::text)
4. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=25,943.91..33,117.10 rows=52,260 width=40) (actual rows= loops=)

  • Hash Cond: (a.auditable_id = cp.id)
5. 0.000 0.000 ↓ 0.0

CTE Scan on cp_audits a (cost=0.00..2,090.42 rows=104,521 width=56) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=18,167.85..18,167.85 rows=447,285 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on client_projects cp (cost=0.00..18,167.85 rows=447,285 width=16) (actual rows= loops=)