explain.depesz.com

PostgreSQL's explain analyze made readable

Result: waPa

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.040 ↑ 1.0 2 1

Merge Left Join (cost=2.59..2.63 rows=2 width=36) (actual time=0.038..0.040 rows=2 loops=1)

  • Merge Cond: (ic.item_category_id = icifl.item_category_id)
2.          

CTE item_category_info_for_location

3. 0.003 0.014 ↑ 1.0 2 1

Sort (cost=1.51..1.51 rows=2 width=21) (actual time=0.013..0.014 rows=2 loops=1)

  • Sort Key: ici.item_category_id
  • Sort Method: quicksort Memory: 25kB
4. 0.011 0.011 ↑ 1.0 2 1

Seq Scan on item_category_info ici (cost=0.00..1.50 rows=2 width=21) (actual time=0.009..0.011 rows=2 loops=1)

  • Filter: (location_id = 1)
  • Rows Removed by Filter: 38
5. 0.006 0.015 ↑ 1.0 2 1

Sort (cost=1.03..1.03 rows=2 width=23) (actual time=0.015..0.015 rows=2 loops=1)

  • Sort Key: ic.item_category_id
  • Sort Method: quicksort Memory: 25kB
6. 0.009 0.009 ↑ 1.0 2 1

Seq Scan on item_category ic (cost=0.00..1.02 rows=2 width=23) (actual time=0.009..0.009 rows=2 loops=1)

7. 0.003 0.019 ↑ 1.0 2 1

Sort (cost=0.05..0.06 rows=2 width=17) (actual time=0.019..0.019 rows=2 loops=1)

  • Sort Key: icifl.item_category_id
  • Sort Method: quicksort Memory: 25kB
8. 0.016 0.016 ↑ 1.0 2 1

CTE Scan on item_category_info_for_location icifl (cost=0.00..0.04 rows=2 width=17) (actual time=0.015..0.016 rows=2 loops=1)