explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l0A3 : Forms stats with empty stats.

Settings
# exclusive inclusive rows x rows loops node
1. 367.992 1,597.790 ↑ 2.2 5 1

GroupAggregate (cost=69,169.92..69,170.14 rows=11 width=28) (actual time=1,089.595..1,597.790 rows=5 loops=1)

  • Group Key: forms.id
  • Buffers: shared hit=186228 dirtied=2
2. 413.707 1,229.798 ↓ 70,753.4 778,287 1

Sort (cost=69,169.92..69,169.95 rows=11 width=28) (actual time=1,089.532..1,229.798 rows=778,287 loops=1)

  • Sort Key: forms.id
  • Sort Method: quicksort Memory: 84435kB
  • Buffers: shared hit=186228 dirtied=2
3. 417.546 816.091 ↓ 70,753.4 778,287 1

Hash Right Join (cost=56.68..69,169.73 rows=11 width=28) (actual time=0.091..816.091 rows=778,287 loops=1)

  • Hash Cond: (form_responses.form_id = forms.id)
  • Join Filter: (forms.project_id = 20206)
  • Buffers: shared hit=186228 dirtied=2
4. 398.490 398.490 ↑ 1.0 778,286 1

Index Only Scan using form_responses_form_id_mailing_id_covering_index on form_responses (cost=0.56..66,173.06 rows=779,077 width=16) (actual time=0.018..398.490 rows=778,286 loops=1)

  • Index Cond: (project_id = 20206)
  • Filter: ((deleted IS NOT TRUE) AND (is_unanswered IS NOT TRUE))
  • Rows Removed by Filter: 45726
  • Heap Fetches: 1144
  • Buffers: shared hit=186213 dirtied=2
5. 0.004 0.055 ↑ 2.2 5 1

Hash (cost=55.98..55.98 rows=11 width=20) (actual time=0.055..0.055 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=15
6. 0.032 0.051 ↑ 2.2 5 1

Bitmap Heap Scan on forms (cost=4.40..55.98 rows=11 width=20) (actual time=0.030..0.051 rows=5 loops=1)

  • Recheck Cond: (project_id = 20206)
  • Filter: (deleted IS NOT TRUE)
  • Rows Removed by Filter: 7
  • Heap Blocks: exact=12
  • Buffers: shared hit=15
7. 0.019 0.019 ↑ 1.2 12 1

Bitmap Index Scan on forms_project_id_index (cost=0.00..4.39 rows=15 width=0) (actual time=0.019..0.019 rows=12 loops=1)

  • Index Cond: (project_id = 20206)
  • Buffers: shared hit=3
Planning time : 0.403 ms