explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZTyc : Optimization for: plan #kRQR

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.088 0.138 ↑ 1.0 17 1

Sort (cost=76.28..76.32 rows=17 width=1,482) (actual time=0.136..0.138 rows=17 loops=1)

  • Sort Key: tree_id, lft
  • Sort Method: quicksort Memory: 78kB
2. 0.026 0.050 ↑ 1.0 17 1

Bitmap Heap Scan on category_category (cost=12.39..75.93 rows=17 width=1,482) (actual time=0.033..0.050 rows=17 loops=1)

  • Recheck Cond: (parent_id IS NULL)
3. 0.024 0.024 ↑ 1.0 17 1

Bitmap Index Scan on category_category_parent_id (cost=0.00..12.38 rows=17 width=0) (actual time=0.024..0.024 rows=17 loops=1)

  • Index Cond: (parent_id IS NULL)