explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YlS6

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.060 ↑ 40.0 5 1

HashAggregate (cost=167.85..169.85 rows=200 width=36) (actual time=0.058..0.060 rows=5 loops=1)

  • Output: all_locations.id, all_locations.name
  • Group Key: all_locations.id, all_locations.name
  • Buffers: shared hit=2
2. 0.000 0.049 ↑ 150.6 5 1

Nested Loop (cost=0.00..164.09 rows=753 width=36) (actual time=0.041..0.049 rows=5 loops=1)

  • Output: all_locations.id, all_locations.name
  • Join Filter: ((all_locations.pre <= l.pre) AND (all_locations.post >= l.post))
  • Rows Removed by Join Filter: 9
  • Buffers: shared hit=2
3. 0.021 0.021 ↑ 80.7 14 1

Seq Scan on public.v1_location all_locations (cost=0.00..21.30 rows=1,130 width=44) (actual time=0.020..0.021 rows=14 loops=1)

  • Output: all_locations.id, all_locations.name, all_locations.pre, all_locations.post
  • Buffers: shared hit=1
4. 0.015 0.028 ↑ 6.0 1 14

Materialize (cost=0.00..24.16 rows=6 width=8) (actual time=0.001..0.002 rows=1 loops=14)

  • Output: l.pre, l.post
  • Buffers: shared hit=1
5. 0.013 0.013 ↑ 6.0 1 1

Seq Scan on public.v1_location l (cost=0.00..24.13 rows=6 width=8) (actual time=0.012..0.013 rows=1 loops=1)

  • Output: l.pre, l.post
  • Filter: (l.id = 6)
  • Rows Removed by Filter: 13
  • Buffers: shared hit=1
Planning time : 0.149 ms