explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6P5q : With explain analyze, 400

Settings
# exclusive inclusive rows x rows loops node
1. 0.523 14.806 ↓ 1.4 338 1

Nested Loop Left Join (cost=505.75..6,747.24 rows=250 width=1,571) (actual time=9.916..14.806 rows=338 loops=1)

  • Buffers: shared hit=4534
2. 0.439 13.945 ↓ 1.4 338 1

Nested Loop Left Join (cost=505.47..6,668.46 rows=250 width=1,434) (actual time=9.906..13.945 rows=338 loops=1)

  • Buffers: shared hit=3520
3. 0.274 13.168 ↓ 1.4 338 1

Nested Loop Left Join (cost=505.18..6,589.68 rows=250 width=1,369) (actual time=9.897..13.168 rows=338 loops=1)

  • Buffers: shared hit=2770
4. 0.293 11.894 ↑ 1.0 250 1

Nested Loop Left Join (cost=504.74..3,503.78 rows=250 width=1,257) (actual time=9.882..11.894 rows=250 loops=1)

  • Buffers: shared hit=1679
5. 0.143 11.601 ↑ 1.0 250 1

Nested Loop Left Join (cost=504.46..3,424.80 rows=250 width=1,166) (actual time=9.879..11.601 rows=250 loops=1)

  • Buffers: shared hit=1664
6. 0.260 10.708 ↑ 1.0 250 1

Hash Left Join (cost=504.04..1,533.55 rows=250 width=1,044) (actual time=9.862..10.708 rows=250 loops=1)

  • Hash Cond: (form_responses.form_id = forms_1.id)
  • Buffers: shared hit=664
7. 0.086 0.623 ↑ 1.0 250 1

Limit (cost=0.56..1,022.88 rows=250 width=363) (actual time=0.018..0.623 rows=250 loops=1)

  • Buffers: shared hit=277
8. 0.537 0.537 ↑ 265.3 250 1

Index Scan using form_responses_covering_created_time_first_index on form_responses (cost=0.56..271,266.72 rows=66,336 width=363) (actual time=0.017..0.537 rows=250 loops=1)

  • Index Cond: ((project_id = 20006) AND (created_time >= '2018-09-29 21:55:32+00'::timestamp with time zone) AND (created_time <= '2018-10-29 21:55:32+00'::timestamp with time zone))
  • Filter: ((deleted IS NOT TRUE) AND (is_unanswered IS NOT TRUE))
  • Rows Removed by Filter: 8
  • Buffers: shared hit=277
9. 5.941 9.825 ↓ 1.0 5,196 1

Hash (cost=438.77..438.77 rows=5,177 width=681) (actual time=9.825..9.825 rows=5,196 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2672kB
  • Buffers: shared hit=387
10. 3.884 3.884 ↓ 1.0 5,196 1

Seq Scan on forms forms_1 (cost=0.00..438.77 rows=5,177 width=681) (actual time=0.004..3.884 rows=5,196 loops=1)

  • Buffers: shared hit=387
11. 0.750 0.750 ↑ 1.0 1 250

Index Scan using mailings_pkey on mailings mailings_1 (cost=0.42..7.55 rows=1 width=122) (actual time=0.002..0.003 rows=1 loops=250)

  • Index Cond: (id = form_responses.mailing_id)
  • Buffers: shared hit=1000
12. 0.000 0.000 ↓ 0.0 0 250

Index Scan using mailing_groups_pkey on mailing_groups mailing_groups_1 (cost=0.28..0.31 rows=1 width=91) (actual time=0.000..0.000 rows=0 loops=250)

  • Index Cond: (id = mailings_1.mailing_group_id)
  • Buffers: shared hit=15
13. 1.000 1.000 ↑ 1.0 1 250

Index Scan using question_responses_form_response_id_index on question_responses question_responses_1 (cost=0.43..12.33 rows=1 width=112) (actual time=0.003..0.004 rows=1 loops=250)

  • Index Cond: (form_response_id = form_responses.id)
  • Filter: ((deleted IS NOT TRUE) AND (form_id = form_responses.form_id))
  • Buffers: shared hit=1091
14. 0.338 0.338 ↑ 1.0 1 338

Index Scan using answers_pkey on answers answers_1 (cost=0.29..0.31 rows=1 width=65) (actual time=0.001..0.001 rows=1 loops=338)

  • Index Cond: (id = question_responses_1.answer_id)
  • Buffers: shared hit=750
15. 0.338 0.338 ↑ 1.0 1 338

Index Scan using questions_pkey on questions questions_1 (cost=0.29..0.31 rows=1 width=137) (actual time=0.001..0.001 rows=1 loops=338)

  • Index Cond: (id = question_responses_1.question_id)
  • Buffers: shared hit=1014