explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uuSm

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 0.118 ↑ 1.0 1 1

GroupAggregate (cost=0.15..19.03 rows=1 width=45) (actual time=0.118..0.118 rows=1 loops=1)

  • Group Key: p.id
2. 0.007 0.079 ↑ 1.6 34 1

Nested Loop Left Join (cost=0.15..18.61 rows=54 width=44) (actual time=0.060..0.079 rows=34 loops=1)

  • Join Filter: (p.id = pr2.poll_id)
3. 0.001 0.057 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.15..13.54 rows=1 width=40) (actual time=0.054..0.057 rows=1 loops=1)

  • Join Filter: (p.id = pr.poll_id)
4. 0.021 0.021 ↑ 1.0 1 1

Index Scan using poll_pkey on poll p (cost=0.15..8.17 rows=1 width=36) (actual time=0.019..0.021 rows=1 loops=1)

  • Index Cond: (id = 2)
5. 0.035 0.035 ↑ 1.0 1 1

Seq Scan on poll_response pr (cost=0.00..5.36 rows=1 width=8) (actual time=0.033..0.035 rows=1 loops=1)

  • Filter: ((poll_id = 2) AND (user_id = 2) AND (ip_address = '202.9.120.15'::text))
  • Rows Removed by Filter: 119
6. 0.015 0.015 ↑ 1.6 34 1

Seq Scan on poll_response pr2 (cost=0.00..4.40 rows=54 width=8) (actual time=0.004..0.015 rows=34 loops=1)

  • Filter: (poll_id = 2)
  • Rows Removed by Filter: 86
Planning time : 0.211 ms
Execution time : 2.995 ms