explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xGFy

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.108 4.324 ↑ 1.0 1 1

Aggregate (cost=40.64..40.98 rows=1 width=5) (actual time=4.323..4.324 rows=1 loops=1)

  • Buffers: shared hit=310 read=1
  • I/O Timings: read=3.725
2. 0.087 0.346 ↑ 1.0 1,000 1

Limit (cost=0.44..25.64 rows=1,000 width=4) (actual time=0.061..0.346 rows=1,000 loops=1)

  • Buffers: shared hit=310
3. 0.259 0.259 ↑ 21,895.1 1,000 1

Index Only Scan using lfs_objects_pkey on public.lfs_objects (cost=0.44..551,771.60 rows=21,895,120 width=4) (actual time=0.059..0.259 rows=1,000 loops=1)

  • Index Cond: (lfs_objects.id >= 10000)
  • Heap Fetches: 0
  • Buffers: shared hit=310
4.          

SubPlan (for Aggregate)

5. 3.870 3.870 ↑ 7,301,232.0 1 1

Seq Scan on public.lfs_objects lfs_objects_1 (cost=0.00..2,442,060.20 rows=7,301,232 width=0) (actual time=3.870..3.870 rows=1 loops=1)

  • Filter: (lfs_objects_1.id > max(lfs_objects.id))
  • Rows Removed by Filter: 1
  • Buffers: shared read=1
  • I/O Timings: read=3.725