explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5bWe

Settings
# exclusive inclusive rows x rows loops node
1. 8.002 16,975.532 ↑ 1.0 10,000 1

Limit (cost=0.85..21,695.55 rows=10,000 width=116) (actual time=0.538..16,975.532 rows=10,000 loops=1)

2. 15,847.774 16,967.530 ↑ 5.1 10,000 1

Nested Loop (cost=0.85..109,886.68 rows=50,651 width=116) (actual time=0.537..16,967.530 rows=10,000 loops=1)

3. 9.270 129.756 ↑ 5.1 10,000 1

Nested Loop (cost=0.43..57,847.88 rows=51,074 width=44) (actual time=0.022..129.756 rows=10,000 loops=1)

4. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on surveys (cost=0.00..10.50 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=1)

  • Filter: (uuid = 'd5867329-ff5c-4d91-a8a0-5704f847433d'::uuid)
  • Rows Removed by Filter: 1
5. 120.479 120.479 ↑ 68.1 10,000 1

Index Scan using index_assessments_on_survey_id on assessments (cost=0.43..51,027.46 rows=680,992 width=48) (actual time=0.013..120.479 rows=10,000 loops=1)

  • Index Cond: (survey_id = surveys.id)
  • Filter: (end_time IS NOT NULL)
  • Rows Removed by Filter: 1,380
6. 990.000 990.000 ↑ 1.0 1 10,000

Index Scan using assessment_json_scores_pkey on assessment_json_scores scores (cost=0.43..0.90 rows=1 width=22) (actual time=0.099..0.099 rows=1 loops=10,000)

  • Index Cond: (id = assessments.id)
Planning time : 0.402 ms
Execution time : 16,978.816 ms