explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RhFrC

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 829.059 23,324.968 ↑ 1.0 1 1

Aggregate (cost=250,759.55..250,759.56 rows=1 width=8) (actual time=23,324.967..23,324.968 rows=1 loops=1)

  • Buffers: shared hit=2,612,675 read=74,671 dirtied=2,877
  • I/O Timings: read=19,487.477
2. 22,495.909 22,495.909 ↑ 1.0 7,142,504 1

Index Only Scan using index_namespaces_on_parent_id_and_id on public.namespaces (cost=0.56..232,896.14 rows=7,145,363 width=0) (actual time=13.561..22,495.909 rows=7,142,504 loops=1)

  • Index Cond: (namespaces.parent_id IS NULL)
  • Heap Fetches: 426,599
  • Buffers: shared hit=2,612,675 read=74,671 dirtied=2,877
  • I/O Timings: read=19,487.477