explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5WbK

Settings
# exclusive inclusive rows x rows loops node
1. 7.795 12.807 ↑ 1.0 91,456 1

Bitmap Heap Scan on folder_hierarchies fh (cost=2,316.90..13,147.97 rows=92,965 width=64) (actual time=5.105..12.807 rows=91,456 loops=1)

  • Recheck Cond: (parent = '00000000-0000-0000-0000-000000000000'::uuid)
  • Heap Blocks: exact=1,046
  • Buffers: shared hit=1,479
2. 5.012 5.012 ↑ 1.0 91,904 1

Bitmap Index Scan on idx_folder_hierarchies_parent (cost=0.00..2,293.66 rows=92,965 width=0) (actual time=5.012..5.012 rows=91,904 loops=1)

  • Index Cond: (parent = '00000000-0000-0000-0000-000000000000'::uuid)
  • Buffers: shared hit=433
Planning time : 0.074 ms
Execution time : 14.966 ms