explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p22M

Settings
# exclusive inclusive rows x rows loops node
1. 1,134.922 1,361.084 ↑ 1.0 141,503 1

Sort (cost=122,654.89..123,013.43 rows=143,415 width=103) (actual time=1,342.758..1,361.084 rows=141,503 loops=1)

  • Sort Key: (COALESCE(website_published, false)) DESC, website_sequence DESC, name
  • Sort Method: quicksort Memory: 36,935kB
  • Functions: 6
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 4.378 ms, Inlining 0.000 ms, Optimization 1.597 ms, Emission 18.274 ms, Total 24.248 ms
2. 205.809 226.162 ↑ 1.0 141,503 1

Bitmap Heap Scan on product_template (cost=1,512.71..110,371.51 rows=143,415 width=103) (actual time=51.324..226.162 rows=141,503 loops=1)

  • Recheck Cond: (product_brand_id = ANY ('{49141,113535}'::integer[]))
  • Filter: active
  • Heap Blocks: exact=57,088
3. 20.353 20.353 ↑ 1.0 141,503 1

Bitmap Index Scan on product_template_product_brand_id_idx (cost=0.00..1,476.86 rows=143,415 width=0) (actual time=20.353..20.353 rows=141,503 loops=1)

  • Index Cond: (product_brand_id = ANY ('{49141,113535}'::integer[]))
Planning time : 0.361 ms
Execution time : 1,382.586 ms