explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GNqh

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 842.480 ↓ 0.0 0 1

Limit (cost=728,316.21..728,316.22 rows=1 width=49) (actual time=842.480..842.480 rows=0 loops=1)

  • Buffers: shared hit=105993
2. 0.002 842.464 ↓ 0.0 0 1

Unique (cost=728,316.21..728,316.22 rows=1 width=49) (actual time=842.464..842.464 rows=0 loops=1)

  • Buffers: shared hit=105993
3. 0.018 842.462 ↓ 0.0 0 1

Sort (cost=728,316.21..728,316.22 rows=1 width=49) (actual time=842.462..842.462 rows=0 loops=1)

  • Sort Key: businesspa3_.name, businesspa3_.c_bpartner_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=105993
4. 0.001 842.444 ↓ 0.0 0 1

Nested Loop Anti Join (cost=20,071.87..728,316.20 rows=1 width=49) (actual time=842.444..842.444 rows=0 loops=1)

  • Buffers: shared hit=105993
5. 0.002 842.443 ↓ 0.0 0 1

Nested Loop Semi Join (cost=20,071.45..728,315.64 rows=1 width=82) (actual time=842.443..842.443 rows=0 loops=1)

  • Join Filter: ((product2_.m_product_category_id)::text = (obre_resou4_.m_product_category_id)::text)
  • Buffers: shared hit=105993
6. 0.002 842.441 ↓ 0.0 0 1

Nested Loop (cost=20,071.45..728,286.90 rows=1 width=115) (actual time=842.441..842.441 rows=0 loops=1)

  • Buffers: shared hit=105993
7. 0.022 842.439 ↓ 0.0 0 1

Nested Loop (cost=20,070.90..728,283.50 rows=1 width=115) (actual time=842.439..842.439 rows=0 loops=1)

  • Buffers: shared hit=105993
8. 52.662 842.276 ↑ 6.3 3 1

Hash Join (cost=20,070.33..724,819.52 rows=19 width=82) (actual time=702.289..842.276 rows=3 loops=1)

  • Hash Cond: ((order1_.c_bpartner_id)::text = (businesspa3_.c_bpartner_id)::text)
  • Buffers: shared hit=105969
9. 255.396 292.565 ↑ 1.1 169,855 1

Bitmap Heap Scan on c_order order1_ (cost=13,349.18..717,605.30 rows=187,839 width=66) (actual time=59.377..292.565 rows=169,855 loops=1)

  • Recheck Cond: ((c_doctype_id)::text = ANY ('{4F94921D217F48A993FE766B8334B936,7CE7854395964A60A29EB3C5B7D46B40,116D158017A74901960473E3231FF91F,D457B6F9629240058922D59065FCC63A,D14BC7AD73FB4DD0B815E52DE3B31DFE,7C03FC3EE0FF40EEB1C07283E60E57F8,6BC35B437FF546299164FEEE30B3E950,5F3EA76D38834CD99E7DD5673CC06358}'::text[]))
  • Filter: ((docstatus)::text = 'CO'::text)
  • Rows Removed by Filter: 9816
  • Heap Blocks: exact=100264
  • Buffers: shared hit=102411
10. 37.169 37.169 ↑ 1.1 180,980 1

Bitmap Index Scan on em_obpos_doctype_idx (cost=0.00..13,302.22 rows=205,559 width=0) (actual time=37.169..37.169 rows=180,980 loops=1)

  • Index Cond: ((c_doctype_id)::text = ANY ('{4F94921D217F48A993FE766B8334B936,7CE7854395964A60A29EB3C5B7D46B40,116D158017A74901960473E3231FF91F,D457B6F9629240058922D59065FCC63A,D14BC7AD73FB4DD0B815E52DE3B31DFE,7C03FC3EE0FF40EEB1C07283E60E57F8,6BC35B437FF546299164FEEE30B3E950,5F3EA76D38834CD99E7DD5673CC06358}'::text[]))
  • Buffers: shared hit=2147
11. 0.006 497.049 ↑ 293.4 5 1

Hash (cost=6,702.81..6,702.81 rows=1,467 width=49) (actual time=497.049..497.049 rows=5 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=3558
12. 0.032 497.043 ↑ 293.4 5 1

Bitmap Heap Scan on c_bpartner businesspa3_ (cost=963.37..6,702.81 rows=1,467 width=49) (actual time=497.030..497.043 rows=5 loops=1)

  • Recheck Cond: (upper((name)::text) ~~ '%BERNARD THIRIET%'::text)
  • Heap Blocks: exact=6
  • Buffers: shared hit=3558
13. 497.011 497.011 ↑ 209.6 7 1

Bitmap Index Scan on c_bpartner_name_trgm (cost=0.00..963.00 rows=1,467 width=0) (actual time=497.011..497.011 rows=7 loops=1)

  • Index Cond: (upper((name)::text) ~~ '%BERNARD THIRIET%'::text)
  • Buffers: shared hit=3552
14. 0.141 0.141 ↓ 0.0 0 3

Index Scan using c_orderline_order on c_orderline orderline0_ (cost=0.57..182.30 rows=1 width=99) (actual time=0.047..0.047 rows=0 loops=3)

  • Index Cond: ((c_order_id)::text = (order1_.c_order_id)::text)
  • Filter: ((qtydelivered <> qtyordered) AND ((ad_org_id)::text = '9758FB33A4524765BA9F0C6C559A4A7D'::text))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=24
15. 0.000 0.000 ↓ 0.0 0

Index Scan using m_product_key on m_product product2_ (cost=0.56..3.41 rows=1 width=66) (never executed)

  • Index Cond: ((m_product_id)::text = (orderline0_.m_product_id)::text)
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on obre_resource obre_resou4_ (cost=0.00..24.44 rows=344 width=33) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Index Scan using obre_reservation_cordline_idx on obre_reservation obre_reser5_ (cost=0.42..0.49 rows=1 width=33) (never executed)

  • Index Cond: ((c_orderline_id)::text = (orderline0_.c_orderline_id)::text)
  • Filter: ((obre_reservation_id)::text <> '3F5C299C34564BA6A2C2F780511A523C'::text)
Planning time : 5.802 ms
Execution time : 842.764 ms