explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DP52

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 2.947 ↑ 1.0 1 1

Aggregate (cost=3,755.82..3,755.83 rows=1 width=32) (actual time=2.947..2.947 rows=1 loops=1)

2. 0.153 2.917 ↑ 1.5 15 1

GroupAggregate (cost=3,754.00..3,755.41 rows=23 width=48) (actual time=2.742..2.917 rows=15 loops=1)

  • Group Key: m.deviceid
3. 0.079 2.764 ↓ 7.8 180 1

Merge Semi Join (cost=3,754.00..3,754.95 rows=23 width=393) (actual time=2.707..2.764 rows=180 loops=1)

  • Merge Cond: ((m.deviceid)::text = (devices.deviceid)::text)
4. 0.217 0.361 ↓ 1.6 217 1

Sort (cost=977.12..977.45 rows=132 width=393) (actual time=0.353..0.361 rows=217 loops=1)

  • Sort Key: m.deviceid
  • Sort Method: quicksort Memory: 42kB
5. 0.010 0.144 ↓ 1.7 228 1

Custom Scan (ConstraintAwareAppend) (cost=0.00..972.47 rows=132 width=393) (actual time=0.020..0.144 rows=228 loops=1)

  • Hypertable: measurements
  • Chunks left after exclusion: 1
6. 0.009 0.134 ↓ 1.7 228 1

Append (cost=0.00..972.47 rows=132 width=393) (actual time=0.018..0.134 rows=228 loops=1)

7. 0.125 0.125 ↓ 228.0 228 1

Index Scan using _hyper_1_428_chunk_measurements_time_idx on _hyper_1_428_chunk m_1 (cost=0.29..12.52 rows=1 width=344) (actual time=0.017..0.125 rows=228 loops=1)

  • Index Cond: ("time" > (now() - '01:00:00'::interval))
  • Filter: (metrics ? 'visitorActive'::text)
  • Rows Removed by Filter: 95
8. 0.030 2.324 ↑ 1.0 15 1

Sort (cost=2,776.88..2,776.92 rows=15 width=9) (actual time=2.322..2.324 rows=15 loops=1)

  • Sort Key: devices.deviceid
  • Sort Method: quicksort Memory: 25kB
9. 2.294 2.294 ↑ 1.0 15 1

Seq Scan on devices (cost=0.00..2,776.59 rows=15 width=9) (actual time=0.025..2.294 rows=15 loops=1)

  • Filter: ((description)::text = ANY ('{"McLaren Flat","Olivers Road/Osborn Road","Chapel Hill Road","Olivers Road/Chalk Hill Road",Clarendon,"Blewitt Springs","Corner of Main and Stump Hill Roads","McMurtrie Road","Main Road/McMurtrie Intersection",Willunga,"Kangarilla Road","Kays Road","Seaview Road","Whites Valley","Port Willunga"}'::text[]))
  • Rows Removed by Filter: 79
Planning time : 9,672.516 ms
Execution time : 6.239 ms