explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nm1D

Settings
# exclusive inclusive rows x rows loops node
1. 229.151 1,851.427 ↑ 495.8 84 1

GroupAggregate (cost=351,397.01..372,562.78 rows=41,647 width=44) (actual time=1,386.512..1,851.427 rows=84 loops=1)

  • Group Key: ((((trs."timestamp" + 1451667600))::abstime)::date)
2. 973.585 1,622.276 ↓ 1.0 1,648,379 1

Sort (cost=351,397.01..355,484.40 rows=1,634,956 width=20) (actual time=1,312.937..1,622.276 rows=1,648,379 loops=1)

  • Sort Key: ((((trs."timestamp" + 1451667600))::abstime)::date)
  • Sort Method: external merge Disk: 54744kB
3. 648.691 648.691 ↓ 1.0 1,648,379 1

Seq Scan on trs (cost=0.00..115,602.84 rows=1,634,956 width=20) (actual time=0.071..648.691 rows=1,648,379 loops=1)

  • Filter: (("timestamp" >= 84000000) AND ("timestamp" <= 96000000))
  • Rows Removed by Filter: 25