explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sACH

Settings
# exclusive inclusive rows x rows loops node
1. 713.389 1,219.621 ↑ 1.0 141,503 1

Gather Merge (cost=197,710.52..214,882.38 rows=143,416 width=103) (actual time=634.120..1,219.621 rows=141,503 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Functions: 20
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 18.277 ms, Inlining 0.000 ms, Optimization 11.781 ms, Emission 102.333 ms, Total 132.391 ms
2. 208.583 506.232 ↑ 1.3 28,301 5 / 5

Sort (cost=196,710.46..196,800.10 rows=35,854 width=103) (actual time=499.786..506.232 rows=28,301 loops=5)

  • Sort Key: (COALESCE(website_published, false)) DESC, website_sequence DESC, name
  • Sort Method: quicksort Memory: 9,365kB
  • Worker 0: Sort Method: quicksort Memory: 5,942kB
  • Worker 1: Sort Method: quicksort Memory: 6,652kB
  • Worker 2: Sort Method: quicksort Memory: 6,562kB
  • Worker 3: Sort Method: quicksort Memory: 6,628kB
3. 297.649 297.649 ↑ 1.3 28,301 5 / 5

Parallel Seq Scan on product_template (cost=0.00..193,998.13 rows=35,854 width=103) (actual time=30.227..297.649 rows=28,301 loops=5)

  • Filter: (active AND (product_brand_id = ANY ('{49141,113535}'::integer[])))
  • Rows Removed by Filter: 135,228
Planning time : 0.419 ms
Execution time : 1,233.086 ms