#	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

Aggregate  (cost=3755.82..3755.83 rows=1 width=32) (actual time=2.947..2.947 rows=1 loops=1)
  ->  GroupAggregate  (cost=3754.00..3755.41 rows=23 width=48) (actual time=2.742..2.917 rows=15 loops=1)
        Group Key: m.deviceid
        ->  Merge Semi Join  (cost=3754.00..3754.95 rows=23 width=393) (actual time=2.707..2.764 rows=180 loops=1)
              Merge Cond: ((m.deviceid)::text = (devices.deviceid)::text)
              ->  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
                    ->  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
                          ->  Append  (cost=0.00..972.47 rows=132 width=393) (actual time=0.018..0.134 rows=228 loops=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
              ->  Sort  (cost=2776.88..2776.92 rows=15 width=9) (actual time=2.322..2.324 rows=15 loops=1)
                    Sort Key: devices.deviceid
                    Sort Method: quicksort  Memory: 25kB
                    ->  Seq Scan on devices  (cost=0.00..2776.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: 9672.516 ms
Execution time: 6.239 ms

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.030 ms	1.0 %
Append	1	0.009 ms	0.3 %
Custom Scan (ConstraintAwareAppend)	1	0.010 ms	0.3 %
GroupAggregate	1	0.153 ms	5.2 %
Index Scan	1	0.125 ms	4.2 %
Merge Semi Join	1	0.079 ms	2.7 %
Seq Scan	1	2.294 ms	77.8 %
Sort	2	0.247 ms	8.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
_hyper_1_428_chunk	1	0.125 ms	4.2 %
Index Scan	1	0.125 ms	100.0 %
devices	1	2.294 ms	77.8 %
Seq Scan	1	2.294 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DP52

Color mode:

Visible columns:

Per node type stats

Per table stats