explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vwDo

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

Seq Scan on activ_submissions (cost=12.68..25.79 rows=1 width=2,693) (actual rows= loops=)

  • Filter: ((NOT is_deleted) AND ((instance_ref)::text = 'VgXeTHHnv'::text) AND (((submitted_by)::text = 'pmCRFw80s'::text) OR (hashed SubPlan 1)))
2.          

SubPlan (for Seq Scan)

3. 0.000 0.000 ↓ 0.0

Group (cost=0.14..12.68 rows=1 width=516) (actual rows= loops=)

  • Group Key: activ_submission_group_identities.submission_ref
4. 0.000 0.000 ↓ 0.0

Index Only Scan using activ_submission_group_identities_pkey on activ_submission_group_identities (cost=0.14..12.68 rows=1 width=516) (actual rows= loops=)

  • Index Cond: (identity_ref = 'pmCRFw80s'::text)