explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 23gs

Settings
# exclusive inclusive rows x rows loops node
1. 1,303.758 4,537.209 ↑ 1.0 187,117 1

Sort (cost=108,781.33..109,249.77 rows=187,376 width=221) (actual time=4,451.760..4,537.209 rows=187,117 loops=1)

  • Sort Key: partner.name
  • Sort Method: external merge Disk: 17080kB
2.          

Initplan (for Sort)

3. 0.020 0.020 ↑ 1.0 1 1

Index Scan using ir_model_fields_name_unique on ir_model_fields (cost=0.28..4.30 rows=1 width=4) (actual time=0.020..0.020 rows=1 loops=1)

  • Index Cond: (((model)::text = 'res.partner'::text) AND ((name)::text = 'property_product_pricelist'::text))
4. 0.013 0.013 ↑ 1.0 1 1

Index Scan using ir_model_fields_name_unique on ir_model_fields ir_model_fields_1 (cost=0.28..4.30 rows=1 width=4) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (((model)::text = 'res.partner'::text) AND ((name)::text = 'property_account_position_id'::text))
5. 65.515 3,233.418 ↑ 1.0 187,117 1

Hash Semi Join (cost=70,312.18..78,180.24 rows=187,376 width=221) (actual time=2,844.217..3,233.418 rows=187,117 loops=1)

  • Hash Cond: (partner.id = res_partner.id)
6. 16.723 3,119.787 ↑ 1.0 187,117 1

Merge Left Join (cost=58,891.95..64,183.59 rows=187,376 width=221) (actual time=2,795.907..3,119.787 rows=187,117 loops=1)

  • Merge Cond: (('res.partner,'::text || (partner.id)::text) = (prop_pos.res_id)::text)
7. 170.002 3,103.036 ↑ 1.0 187,117 1

Merge Left Join (cost=48,368.98..51,249.02 rows=187,376 width=202) (actual time=2,795.872..3,103.036 rows=187,117 loops=1)

  • Merge Cond: ((('res.partner,'::text || (partner.id)::text)) = (prop_pricelist.res_id)::text)
8. 2,244.649 2,331.119 ↑ 1.0 187,117 1

Sort (cost=37,846.01..38,314.45 rows=187,376 width=183) (actual time=2,202.744..2,331.119 rows=187,117 loops=1)

  • Sort Key: (('res.partner,'::text || (partner.id)::text))
  • Sort Method: external merge Disk: 18952kB
9. 86.470 86.470 ↑ 1.0 187,117 1

Seq Scan on res_partner partner (cost=0.00..9,541.01 rows=187,376 width=183) (actual time=0.011..86.470 rows=187,117 loops=1)

  • Filter: (customer AND (company_id = 1))
  • Rows Removed by Filter: 545
10. 583.364 601.915 ↓ 3.7 74,381 1

Sort (cost=10,522.97..10,573.02 rows=20,018 width=37) (actual time=593.121..601.915 rows=74,381 loops=1)

  • Sort Key: prop_pricelist.res_id
  • Sort Method: quicksort Memory: 8884kB
11. 14.872 18.551 ↓ 3.7 74,381 1

Bitmap Heap Scan on ir_property prop_pricelist (cost=269.56..9,092.79 rows=20,018 width=37) (actual time=4.160..18.551 rows=74,381 loops=1)

  • Recheck Cond: (fields_id = $0)
  • Heap Blocks: exact=4879
12. 3.679 3.679 ↓ 3.7 74,880 1

Bitmap Index Scan on ir_property_fields_id_index (cost=0.00..264.56 rows=20,018 width=0) (actual time=3.679..3.679 rows=74,880 loops=1)

  • Index Cond: (fields_id = $0)
13. 0.005 0.028 ↓ 0.0 0 1

Sort (cost=10,522.97..10,573.02 rows=20,018 width=37) (actual time=0.028..0.028 rows=0 loops=1)

  • Sort Key: prop_pos.res_id
  • Sort Method: quicksort Memory: 25kB
14. 0.001 0.023 ↓ 0.0 0 1

Bitmap Heap Scan on ir_property prop_pos (cost=269.56..9,092.79 rows=20,018 width=37) (actual time=0.023..0.023 rows=0 loops=1)

  • Recheck Cond: (fields_id = $1)
15. 0.022 0.022 ↓ 0.0 0 1

Bitmap Index Scan on ir_property_fields_id_index (cost=0.00..264.56 rows=20,018 width=0) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (fields_id = $1)
16. 21.984 48.116 ↑ 1.0 187,662 1

Hash (cost=9,071.21..9,071.21 rows=187,921 width=4) (actual time=48.116..48.116 rows=187,662 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 8646kB
17. 26.132 26.132 ↑ 1.0 187,662 1

Seq Scan on res_partner (cost=0.00..9,071.21 rows=187,921 width=4) (actual time=0.004..26.132 rows=187,662 loops=1)