explain.depesz.com

PostgreSQL's explain analyze made readable

Result: frfe : Optimization for: plan #MGlU

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.489 122.349 ↓ 3.9 987 1

Nested Loop (cost=7,566.24..854,994.26 rows=256 width=174) (actual time=40.019..122.349 rows=987 loops=1)

2. 120.143 120.143 ↑ 1.0 1 1

Index Scan using tepoch_pkey on tepoch e (cost=0.42..12,677.02 rows=1 width=16) (actual time=39.757..120.143 rows=1 loops=1)

  • Filter: (epoch = '1999-07-23 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 446319
3. 1.571 1.717 ↑ 579.0 987 1

Bitmap Heap Scan on tdata d (cost=7,565.82..836,602.08 rows=571,516 width=158) (actual time=0.247..1.717 rows=987 loops=1)

  • Recheck Cond: (fk_uid = e.pk_uid)
  • Heap Blocks: exact=786
4. 0.146 0.146 ↑ 579.0 987 1

Bitmap Index Scan on idx_fk_uid (cost=0.00..7,422.94 rows=571,516 width=0) (actual time=0.146..0.146 rows=987 loops=1)

  • Index Cond: (fk_uid = e.pk_uid)