explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vdkq

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 0.081 ↓ 0.0 0 1

Hash Join (cost=30.45..171.63 rows=1 width=274) (actual time=0.081..0.081 rows=0 loops=1)

  • Hash Cond: ("surveyConstraints"."surveyId" = survey.id)
2. 0.005 0.005 ↑ 2,028.0 1 1

Seq Scan on "surveyConstraints" (cost=0.00..135.85 rows=2,028 width=83) (actual time=0.005..0.005 rows=1 loops=1)

  • Filter: (("deletedAt" IS NULL) AND ((platform)::text = 'web'::text))
  • Rows Removed by Filter: 4
3. 0.001 0.046 ↓ 0.0 0 1

Hash (cost=30.44..30.44 rows=1 width=191) (actual time=0.046..0.046 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
4. 0.045 0.045 ↓ 0.0 0 1

Index Scan using surveys_environment_id on surveys survey (cost=0.28..30.44 rows=1 width=191) (actual time=0.045..0.045 rows=0 loops=1)

  • Index Cond: (("environmentId")::text = '7FZivRhA6kU'::text)
  • Filter: (("deletedAt" IS NULL) AND ("archivedAt" IS NULL) AND ("completedAt" IS NULL) AND ("deletedAt" IS NULL) AND ((platform)::text = 'web'::text) AND (status = 1))
  • Rows Removed by Filter: 41
Planning time : 0.842 ms
Execution time : 0.143 ms