explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oDqH

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 10,728.078 ↓ 2.0 4 1

Nested Loop (cost=8.46..25,231.91 rows=2 width=4) (actual time=584.073..10,728.078 rows=4 loops=1)

2.          

Initplan (for Nested Loop)

3. 0.008 0.008 ↑ 1.0 1 1

Index Scan using asset_geom_pkey on asset_geom (cost=0.15..8.17 rows=1 width=32) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: (id = 1)
4. 10,727.940 10,727.940 ↓ 2.5 20 1

Seq Scan on ob_station s (cost=0.00..25,157.16 rows=8 width=4) (actual time=584.059..10,727.940 rows=20 loops=1)

  • Filter: ((point)::geography && st_buffer((st_setsrid($0, 4326))::geography, '10000'::double precision, 'quad_segs=2'::text))
  • Rows Removed by Filter: 79044
5. 0.100 0.100 ↓ 0.0 0 20

Index Scan using ob_ob_station_id_idx on ob o (cost=0.29..8.31 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=20)

  • Index Cond: (ob_station_id = s.id)
  • Filter: (observed_at > (now() - '00:10:00'::interval))
Planning time : 0.424 ms
Execution time : 10,728.102 ms