explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ggxQ : Optimization for: plan #MGlU

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 76.394 ↑ 579.0 987 1

Bitmap Heap Scan on tdata d (cost=10,000,015,557.82..10,000,844,594.08 rows=571,516 width=158) (actual time=74.886..76.394 rows=987 loops=1)

  • Recheck Cond: (fk_uid = $0)
  • Heap Blocks: exact=786
2.          

Initplan (forBitmap Heap Scan)

3. 74.574 74.574 ↑ 1.0 1 1

Seq Scan on tepoch (cost=10,000,000,000.00..10,000,007,992.00 rows=1 width=8) (actual time=25.560..74.574 rows=1 loops=1)

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

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

  • Index Cond: (fk_uid = $0)