explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iHyd

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

Subquery Scan on wf3 (cost=0..0 rows=0 width=0) (never executed)

2. 0.000 0.000 ↓ 0.0

Aggregate (cost=0..0 rows=0 width=0) (never executed)

3. 0.000 0.000 ↓ 0.0

Gather Merge (cost=0..0 rows=0 width=0) (never executed)

4. 0.000 0.000 ↓ 0.0

Aggregate (cost=0..0 rows=0 width=0) (never executed)

5. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: w2.crm_client_id, w2.wksid, w2.is_new
6. 0.000 0.000 ↓ 0.0

Seq Scan on event_client_registration_wfw w2 (cost=0..0 rows=0 width=0) (never executed)

7.          

SubPlan (forSubquery Scan)

8. 0.000 0.000 ↓ 0.0

Limit (cost=0..0 rows=0 width=0) (never executed)

9. 0.000 0.000 ↓ 0.0

Index Scan using event_client_registration_wfw_wksid_eventoccurred_idx on event_client_registration_wfw w1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (((wksid)::text = wf3.wksid) AND (event_occurred < wf3.event_occurred_min))
10. 0.000 0.000 ↓ 0.0

Limit (cost=0..0 rows=0 width=0) (never executed)

11. 0.000 0.000 ↓ 0.0

Index Scan using event_client_registration_wfw_wksid_eventoccurred_idx on event_client_registration_wfw w1_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (((wksid)::text = wf3.wksid) AND (event_occurred < wf3.event_occurred_min))
12. 0.000 0.000 ↓ 0.0

Index Scan using event_client_registration_wfw_pkey on event_client_registration_wfw w5 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (event_id = $6)
13.          

Initplan (forIndex Scan)

14. 0.000 0.000 ↓ 0.0

Limit (cost=0..0 rows=0 width=0) (never executed)

15. 0.000 0.000 ↓ 0.0

Index Scan using event_client_registration_wfw_wksid_eventoccurred_idx on event_client_registration_wfw w1_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (((wksid)::text = wf3.wksid) AND (event_occurred < wf3.event_occurred_min))