explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RMpg

Settings
# exclusive inclusive rows x rows loops node
1. 144,109.232 144,109.232 ↑ 1.0 13,255,680 1

Seq Scan on frequencies ff (cost=0.00..6,701,161.81 rows=13,257,818 width=11) (actual time=54,168.805..144,109.232 rows=13,255,680 loops=1)

  • Filter: ((ts >= '1562770247001'::bigint) AND (ts <= '1562856647001'::bigint) AND (sensor_id = 15079166))
  • Rows Removed by Filter: 228698112
Planning time : 2.972 ms