explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fTYW

Settings
# exclusive inclusive rows x rows loops node
1. 0.143 1,079.341 ↓ 1.4 135 1

Nested Loop Left Join (cost=11,147.14..14,062.49 rows=100 width=592) (actual time=1,032.518..1,079.341 rows=135 loops=1)

  • Buffers: shared hit=3805 read=2047
2. 0.201 1,078.793 ↓ 1.4 135 1

Nested Loop Left Join (cost=11,146.86..14,030.98 rows=100 width=530) (actual time=1,032.502..1,078.793 rows=135 loops=1)

  • Buffers: shared hit=3400 read=2047
3. 0.139 1,078.322 ↓ 1.4 135 1

Nested Loop Left Join (cost=11,146.57..13,999.46 rows=100 width=508) (actual time=1,032.484..1,078.322 rows=135 loops=1)

  • Buffers: shared hit=3100 read=2047
4. 0.168 1,064.583 ↑ 1.0 100 1

Nested Loop Left Join (cost=11,146.13..12,764.41 rows=100 width=444) (actual time=1,031.940..1,064.583 rows=100 loops=1)

  • Buffers: shared hit=2689 read=2023
5. 0.149 1,064.415 ↑ 1.0 100 1

Nested Loop Left Join (cost=11,145.85..12,732.83 rows=100 width=429) (actual time=1,031.936..1,064.415 rows=100 loops=1)

  • Buffers: shared hit=2683 read=2023
6. 0.204 1,063.866 ↑ 1.0 100 1

Nested Loop Left Join (cost=11,145.43..11,924.33 rows=100 width=388) (actual time=1,031.917..1,063.866 rows=100 loops=1)

  • Buffers: shared hit=2283 read=2023
7. 1.258 1,063.262 ↑ 1.0 100 1

Limit (cost=11,145.15..11,404.33 rows=100 width=311) (actual time=1,031.881..1,063.262 rows=100 loops=1)

  • Buffers: shared hit=1982 read=2023
8. 1,062.004 1,062.004 ↑ 328.0 4,400 1

Index Scan Backward using form_responses_covering_created_time_first_index on form_responses (cost=0.56..3,740,065.86 rows=1,443,057 width=311) (actual time=0.032..1,062.004 rows=4,400 loops=1)

  • Index Cond: (project_id = 20006)
  • Filter: ((deleted IS NOT TRUE) AND (is_unanswered IS NOT TRUE))
  • Rows Removed by Filter: 181
  • Buffers: shared hit=1982 read=2023
9. 0.400 0.400 ↑ 1.0 1 100

Index Scan using forms_pkey on forms forms_1 (cost=0.28..5.18 rows=1 width=77) (actual time=0.004..0.004 rows=1 loops=100)

  • Index Cond: (id = form_responses.form_id)
  • Buffers: shared hit=301
10. 0.400 0.400 ↑ 1.0 1 100

Index Scan using mailings_pkey on mailings mailings_1 (cost=0.42..8.08 rows=1 width=41) (actual time=0.004..0.004 rows=1 loops=100)

  • Index Cond: (id = form_responses.mailing_id)
  • Buffers: shared hit=400
11. 0.000 0.000 ↓ 0.0 0 100

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

  • Index Cond: (id = mailings_1.mailing_group_id)
  • Buffers: shared hit=6
12. 13.600 13.600 ↑ 1.0 1 100

Index Scan using question_responses_form_response_id_index on question_responses question_responses_1 (cost=0.43..12.34 rows=1 width=72) (actual time=0.083..0.136 rows=1 loops=100)

  • Index Cond: (form_response_id = form_responses.id)
  • Filter: ((deleted IS NOT TRUE) AND (form_id = form_responses.form_id))
  • Buffers: shared hit=411 read=24
13. 0.270 0.270 ↑ 1.0 1 135

Index Scan using answers_pkey on answers answers_1 (cost=0.29..0.31 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=135)

  • Index Cond: (id = question_responses_1.answer_id)
  • Buffers: shared hit=300
14. 0.405 0.405 ↑ 1.0 1 135

Index Scan using questions_pkey on questions questions_1 (cost=0.29..0.31 rows=1 width=62) (actual time=0.002..0.003 rows=1 loops=135)

  • Index Cond: (id = question_responses_1.question_id)
  • Buffers: shared hit=405
Planning time : 3.957 ms
Execution time : 1,079.539 ms