explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8MC9

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=246,934.11..246,934.12 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=420.24..242,583.88 rows=1,740,095 width=8) (actual rows= loops=)

  • Hash Cond: (sv.road_station_id = rs.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on sensor_value sv (cost=0.00..190,144.68 rows=9,231,468 width=13) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=397.92..397.92 rows=1,786 width=5) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on road_station rs (cost=46.59..397.92 rows=1,786 width=5) (actual rows= loops=)

  • Recheck Cond: (type = '1'::numeric)
  • Filter: publishable
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on road_station_search_i (cost=0.00..46.14 rows=1,786 width=0) (actual rows= loops=)

  • Index Cond: ((publishable = true) AND (type = '1'::numeric))