explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iZB7

Settings
# exclusive inclusive rows x rows loops node
1. 2,442.990 4,379.030 ↑ 1.1 682,069 1

Sort (cost=270,934.09..272,792.20 rows=743,246 width=12) (actual time=4,238.556..4,379.030 rows=682,069 loops=1)

  • Sort Key: product_template_attribute_line__attribute_id.sequence, product_template_attribute_line__attribute_id.id, product_template_attribute_line.id
  • Sort Method: quicksort Memory: 56,548kB
2. 384.332 1,936.040 ↑ 1.1 682,069 1

Hash Left Join (cost=100.62..198,454.67 rows=743,246 width=12) (actual time=127.954..1,936.040 rows=682,069 loops=1)

  • Hash Cond: (product_template_attribute_line.attribute_id = product_template_attribute_line__attribute_id.id)
3. 1,549.664 1,549.664 ↑ 1.1 682,069 1

Index Scan using product_template_attribute_line_product_tmpl_id_index on product_template_attribute_line (cost=0.42..196,400.55 rows=743,246 width=8) (actual time=125.858..1,549.664 rows=682,069 loops=1)

  • Index Cond: (product_tmpl_id = ANY ('{1727897,12789}'::integer[]))
4. 0.922 2.044 ↑ 1.0 2,853 1

Hash (cost=64.53..64.53 rows=2,853 width=8) (actual time=2.043..2.044 rows=2,853 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 133kB
5. 1.122 1.122 ↑ 1.0 2,853 1

Seq Scan on product_attribute product_template_attribute_line__attribute_id (cost=0.00..64.53 rows=2,853 width=8) (actual time=0.022..1.122 rows=2,853 loops=1)

Planning time : 815.154 ms
Execution time : 4,482.631 ms