explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B8tc

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 0.076 ↓ 0.0 0 1

Hash Right Join (cost=64.34..69.10 rows=1 width=80) (actual time=0.076..0.076 rows=0 loops=1)

  • Hash Cond: (instance.survey_template_id = template.id)
2. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=49.08..51.08 rows=200 width=48) (never executed)

  • Group Key: instance.survey_template_id
3. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=37.36..44.10 rows=398 width=56) (never executed)

  • Hash Cond: (response.survey_instance_id = instance.id)
4. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=18.39..20.39 rows=200 width=32) (never executed)

  • Group Key: response.survey_instance_id
5. 0.000 0.000 ↓ 0.0 0

Seq Scan on response (cost=0.00..14.80 rows=478 width=40) (never executed)

  • Filter: (response_date IS NOT NULL)
6. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.00..14.00 rows=398 width=40) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Seq Scan on instance (cost=0.00..14.00 rows=398 width=40) (never executed)

  • Filter: (sent_date IS NOT NULL)
8. 0.015 0.043 ↓ 0.0 0 1

Hash (cost=15.25..15.25 rows=1 width=48) (actual time=0.043..0.043 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
9. 0.028 0.028 ↓ 0.0 0 1

Seq Scan on template (cost=0.00..15.25 rows=1 width=48) (actual time=0.028..0.028 rows=0 loops=1)

  • Filter: ((survey_type = 'custom'::text) AND (community_id = 'c11e8e17-5e73-4388-a13a-d604100326f0'::uuid))
  • Rows Removed by Filter: 5