explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KT5A

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.051 ↓ 0.0 0 1

Nested Loop (cost=0.43..9.49 rows=1 width=299) (actual time=0.051..0.051 rows=0 loops=1)

  • Join Filter: (assessments.survey_id = surveys.id)
2. 0.050 0.050 ↓ 0.0 0 1

Index Scan using index_assessments_on_user_id on assessments (cost=0.43..8.45 rows=1 width=299) (actual time=0.050..0.050 rows=0 loops=1)

  • Index Cond: (user_id = 176830)
  • Filter: ((end_time IS NOT NULL) AND (in_dispute IS NOT TRUE) AND (invalidated IS NOT TRUE))
3. 0.000 0.000 ↓ 0.0 0

Seq Scan on surveys (cost=0.00..1.04 rows=1 width=4) (never executed)

  • Filter: (uuid = 'd5867329-ff5c-4d91-a8a0-5704f847433d'::uuid)
Planning time : 0.272 ms
Execution time : 0.081 ms