explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v1NN : Sandbox with lateral

Settings
# exclusive inclusive rows x rows loops node
1. 0.669 24.173 ↓ 1.0 492 1

Nested Loop Left Join (cost=15,460.93..7,312,260.18 rows=473 width=196) (actual time=0.203..24.173 rows=492 loops=1)

2. 0.491 6.776 ↓ 1.0 492 1

Nested Loop Left Join (cost=15,316.42..7,243,890.95 rows=473 width=188) (actual time=0.171..6.776 rows=492 loops=1)

3. 0.231 1.365 ↓ 1.0 492 1

Hash Left Join (cost=1.83..78.06 rows=473 width=180) (actual time=0.098..1.365 rows=492 loops=1)

  • Hash Cond: (s.fk_place = p.id_place)
4. 1.084 1.084 ↓ 1.0 492 1

Seq Scan on surveys s (cost=0.00..74.20 rows=473 width=148) (actual time=0.038..1.084 rows=492 loops=1)

  • Filter: (deletedat IS NULL)
  • Rows Removed by Filter: 47
5. 0.026 0.050 ↑ 1.0 37 1

Hash (cost=1.37..1.37 rows=37 width=64) (actual time=0.050..0.050 rows=37 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
6. 0.024 0.024 ↑ 1.0 37 1

Seq Scan on places p (cost=0.00..1.37 rows=37 width=64) (actual time=0.013..0.024 rows=37 loops=1)

7. 0.984 4.920 ↑ 1.0 1 492

Aggregate (cost=15,314.58..15,314.59 rows=1 width=0) (actual time=0.010..0.010 rows=1 loops=492)

8. 3.936 3.936 ↑ 61,188.5 8 492

Index Only Scan using "IX_survey_responses_fk_survey" on survey_responses sr (cost=0.42..14,090.81 rows=489,508 width=0) (actual time=0.005..0.008 rows=8 loops=492)

  • Index Cond: (fk_survey = s.id_survey)
  • Heap Fetches: 0
9. 1.476 16.728 ↑ 1.0 1 492

Aggregate (cost=144.51..144.52 rows=1 width=0) (actual time=0.034..0.034 rows=1 loops=492)

10. 15.252 15.252 ↑ 5.6 14 492

Index Scan using "IX_survey_audiences_fk_survey" on survey_audiences sa (cost=0.28..144.32 rows=78 width=0) (actual time=0.005..0.031 rows=14 loops=492)

  • Index Cond: (fk_survey = s.id_survey)
  • Filter: (deletedat IS NULL)
  • Rows Removed by Filter: 0
Planning time : 0.588 ms
Execution time : 24.395 ms