explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JlGR

Settings

Optimization(s) for this plan:

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

Index Scan using idx_tdata_epoch_fk_point on tdata d (cost=0.57..741.22 rows=604 width=158) (actual time=0.042..1.872 rows=987 loops=1)

  • Index Cond: (epoch = '1999-07-23 00:00:00'::timestamp without time zone)