explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tOXT

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

Aggregate (cost=2,391,223.19..2,391,223.20 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.56..2,365,252.13 rows=104,698 width=16) (actual rows= loops=)

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

Hash Anti Join (cost=22,889.01..25,840.18 rows=52,349 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,093.96 rows=104,698 width=56) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=17,475.67..17,475.67 rows=433,067 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on client_projects cp (cost=0.00..17,475.67 rows=433,067 width=16) (actual rows= loops=)