explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k3JX

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 20,759.807 20,759.807 ↓ 1.6 987 1

Seq Scan on tdata d (cost=10,000,000,000.00..10,004,358,066.10 rows=604 width=158) (actual time=11,327.777..20,759.807 rows=987 loops=1)

  • Filter: (epoch = '1999-07-23 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 114302143