explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PvCj

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,795.186 53,682.842 ↑ 177.5 2,716 1

Gather (cost=1,000.00..3,053,162.67 rows=482,041 width=63) (actual time=24.638..53,682.842 rows=2,716 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 46,311.981 51,887.656 ↑ 208.8 1,358 2 / 2

Nested Loop Left Join (cost=0.00..3,003,958.57 rows=283,554 width=63) (actual time=14.542..51,887.656 rows=1,358 loops=2)

  • Join Filter: (((custom_categories.ancestry)::text ~~* ('%'::text || (custom_categories_1.id)::text)) OR ((custom_categories.ancestry)::text = (custom_categories_1.id)::text))
  • Rows Removed by Join Filter: 49339564
3. 11.263 11.263 ↑ 1.1 408 2 / 2

Parallel Seq Scan on custom_categories (cost=0.00..2,802.31 rows=465 width=57) (actual time=0.044..11.263 rows=408 loops=2)

  • Filter: ((hidden IS FALSE) AND (site_id = 15))
  • Rows Removed by Filter: 60134
4. 5,564.412 5,564.412 ↑ 1.0 121,082 815 / 2

Seq Scan on custom_categories custom_categories_1 (cost=0.00..3,122.82 rows=121,082 width=29) (actual time=0.005..13.655 rows=121,082 loops=815)

Planning time : 0.255 ms
Execution time : 53,683.734 ms