explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HEvF : Survey with Lateral

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 14.454 ↑ 1.1 90 1

Nested Loop Left Join (cost=805.64..78,861.40 rows=100 width=193) (actual time=0.089..14.454 rows=90 loops=1)

2. 0.012 1.225 ↑ 1.1 90 1

Nested Loop Left Join (cost=37.67..2,061.08 rows=100 width=185) (actual time=0.078..1.225 rows=90 loops=1)

3. 0.041 0.133 ↑ 1.1 90 1

Hash Left Join (cost=17.43..33.75 rows=100 width=177) (actual time=0.059..0.133 rows=90 loops=1)

  • Hash Cond: (s.fk_place = p.id_place)
4. 0.075 0.075 ↑ 1.1 90 1

Seq Scan on surveys s (cost=0.00..16.06 rows=100 width=145) (actual time=0.018..0.075 rows=90 loops=1)

  • Filter: (deletedat IS NULL)
  • Rows Removed by Filter: 6
5. 0.007 0.017 ↑ 110.0 3 1

Hash (cost=13.30..13.30 rows=330 width=64) (actual time=0.017..0.017 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.010 0.010 ↑ 110.0 3 1

Seq Scan on places p (cost=0.00..13.30 rows=330 width=64) (actual time=0.009..0.010 rows=3 loops=1)

7. 0.180 1.080 ↑ 1.0 1 90

Aggregate (cost=20.24..20.25 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=90)

8. 0.900 0.900 ↑ 2.3 25 90

Index Only Scan using "IX_survey_responses_fk_survey" on survey_responses sr (cost=0.28..20.10 rows=58 width=0) (actual time=0.004..0.010 rows=25 loops=90)

  • Index Cond: (fk_survey = s.id_survey)
  • Heap Fetches: 2262
9. 1.980 13.230 ↑ 1.0 1 90

Aggregate (cost=767.97..767.98 rows=1 width=8) (actual time=0.147..0.147 rows=1 loops=90)

10. 11.250 11.250 ↑ 3.0 378 90

Index Scan using "IX_survey_audiences_fk_survey" on survey_audiences sa (cost=0.29..765.18 rows=1,118 width=0) (actual time=0.003..0.125 rows=378 loops=90)

  • Index Cond: (fk_survey = s.id_survey)
  • Filter: (deletedat IS NULL)
  • Rows Removed by Filter: 0
Planning time : 2,501.960 ms
Execution time : 14.643 ms