explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5D97 : Optimization for: plan #JlGR

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 2.256 2.256 ↓ 1.6 987 1

Index Scan using idx_tdata_epoch_fk_point on tdata d (cost=0.57..1,257.60 rows=632 width=158) (actual time=0.044..2.256 rows=987 loops=1)

  • Index Cond: (epoch = '1999-07-23 00:00:00'::timestamp without time zone)
Planning time : 0.230 ms
Execution time : 2.443 ms