#	exclusive	inclusive	rows x	rows	loops	node
1.	481.506	4,478.796	↑ 146.8	13,691	1	→ GroupAggregate (cost=704,730.07..769,247.62 rows=2,009,255 width=23) (actual time=3,422.235..4,478.796 rows=13,691 loops=1) Group Key: (date_trunc('day'::text, first_seen)), type
2.	3,118.173	3,997.290	↓ 1.0	3,940,892	1	→ Sort (cost=704,730.07..714,580.54 rows=3,940,186 width=15) (actual time=3,422.167..3,997.290 rows=3,940,892 loops=1) Sort Key: (date_trunc('day'::text, first_seen)) DESC, type Sort Method: external merge Disk: 108296kB
3.	879.117	879.117	↓ 1.0	3,940,892	1	→ Seq Scan on activations (cost=0.00..138,406.00 rows=3,940,186 width=15) (actual time=0.009..879.117 rows=3,940,892 loops=1) Filter: ((first_seen >= '0001-01-01 00:00:00'::timestamp without time zone) AND (first_seen <= '2018-12-05 20:27:02'::timestamp without time zone)) Rows Removed by Filter: 77

                                                                            QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
 GroupAggregate  (cost=704730.07..769247.62 rows=2009255 width=23) (actual time=3422.235..4478.796 rows=13691 loops=1)
   Group Key: (date_trunc('day'::text, first_seen)), type
   ->  Sort  (cost=704730.07..714580.54 rows=3940186 width=15) (actual time=3422.167..3997.290 rows=3940892 loops=1)
         Sort Key: (date_trunc('day'::text, first_seen)) DESC, type
         Sort Method: external merge  Disk: 108296kB
         ->  Seq Scan on activations  (cost=0.00..138406.00 rows=3940186 width=15) (actual time=0.009..879.117 rows=3940892 loops=1)
               Filter: ((first_seen >= '0001-01-01 00:00:00'::timestamp without time zone) AND (first_seen <= '2018-12-05 20:27:02'::timestamp without time zone))
               Rows Removed by Filter: 77
 Planning time: 0.179 ms
 Execution time: 4494.853 ms
(10 rows)

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	481.506 ms	10.8 %
Seq Scan	1	879.117 ms	19.6 %
Sort	1	3,118.173 ms	69.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
activations	1	879.117 ms	19.6 %
Seq Scan	1	879.117 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sRat

Color mode:

Visible columns:

Per node type stats

Per table stats