explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pF9

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 749.853 ↓ 0.0 0 1

Nested Loop (cost=0.43..39,721.24 rows=1 width=299) (actual time=749.853..749.853 rows=0 loops=1)

2. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on surveys (cost=0.00..1.04 rows=1 width=4) (actual time=0.006..0.009 rows=1 loops=1)

  • Filter: (uuid = 'd5867329-ff5c-4d91-a8a0-5704f847433d'::uuid)
  • Rows Removed by Filter: 2
3. 749.841 749.841 ↓ 0.0 0 1

Index Scan using index_assessments_on_survey_id on assessments (cost=0.43..39,720.19 rows=1 width=299) (actual time=749.841..749.841 rows=0 loops=1)

  • Index Cond: (survey_id = surveys.id)
  • Filter: ((end_time IS NOT NULL) AND (in_dispute IS NOT TRUE) AND (invalidated IS NOT TRUE) AND (user_id = 176830))
  • Rows Removed by Filter: 1481700
Planning time : 0.207 ms
Execution time : 749.894 ms