explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sRat

Settings
# 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