explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9w8L : Optimization for: Optimization for: plan #JlGR; plan #5D97

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.832 1.871 ↓ 1.5 987 1

Index Scan using idx_fk_uid on tdata d (cost=5.01..1,254.99 rows=639 width=158) (actual time=0.075..1.871 rows=987 loops=1)

  • Index Cond: (fk_uid = $0)
2.          

Initplan (forIndex Scan)

3. 0.039 0.039 ↑ 1.0 1 1

Index Only Scan using idx_tepoch_epoch_pk_uid on tepoch (cost=0.42..4.44 rows=1 width=8) (actual time=0.037..0.039 rows=1 loops=1)

  • Index Cond: (epoch = '1999-07-23 00:00:00'::timestamp without time zone)
  • Heap Fetches: 1
Planning time : 0.273 ms
Execution time : 2.061 ms