explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tf7p : Optimization for: plan #ILp8

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 12,922.803 ↑ 1.0 1 1

Limit (cost=0.43..65.12 rows=1 width=1,984) (actual time=12,922.803..12,922.803 rows=1 loops=1)

2. 12,922.801 12,922.801 ↑ 12,320.0 1 1

Index Scan using feeds_post_orderab_7ba03a_idx on feeds_post (cost=0.43..796,970.52 rows=12,320 width=1,984) (actual time=12,922.801..12,922.801 rows=1 loops=1)

  • Filter: (draft_id = '7c3f32de-0948-4a54-b06e-e67975ce0b67'::uuid)
  • Rows Removed by Filter: 2463921
Planning time : 16.170 ms
Execution time : 12,922.866 ms