explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G6kv

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 11,552.974 ↓ 0.0 0 1

Limit (cost=728,323.15..728,323.16 rows=1 width=49) (actual time=11,552.974..11,552.974 rows=0 loops=1)

  • Buffers: shared hit=104588 read=8868
2. 0.001 11,552.972 ↓ 0.0 0 1

Unique (cost=728,323.15..728,323.16 rows=1 width=49) (actual time=11,552.972..11,552.972 rows=0 loops=1)

  • Buffers: shared hit=104588 read=8868
3. 0.017 11,552.971 ↓ 0.0 0 1

Sort (cost=728,323.15..728,323.16 rows=1 width=49) (actual time=11,552.971..11,552.971 rows=0 loops=1)

  • Sort Key: businesspa3_.name, businesspa3_.c_bpartner_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=104588 read=8868
4. 0.002 11,552.954 ↓ 0.0 0 1

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

  • Buffers: shared hit=104588 read=8868
5. 0.922 11,552.952 ↓ 0.0 0 1

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

  • Join Filter: ((product2_.m_product_category_id)::text = (obre_resou4_.m_product_category_id)::text)
  • Rows Removed by Join Filter: 2100
  • Buffers: shared hit=104588 read=8868
6. 0.016 11,551.208 ↓ 6.0 6 1

Nested Loop (cost=20,071.45..728,293.84 rows=1 width=115) (actual time=10,728.975..11,551.208 rows=6 loops=1)

  • Buffers: shared hit=104464 read=8866
7. 0.958 11,542.222 ↓ 6.0 6 1

Nested Loop (cost=20,070.90..728,290.44 rows=1 width=115) (actual time=10,726.793..11,542.222 rows=6 loops=1)

  • Buffers: shared hit=104451 read=8849
8. 92.706 10,514.469 ↓ 20.3 385 1

Hash Join (cost=20,070.33..724,826.46 rows=19 width=82) (actual time=9,956.301..10,514.469 rows=385 loops=1)

  • Hash Cond: ((order1_.c_bpartner_id)::text = (businesspa3_.c_bpartner_id)::text)
  • Buffers: shared hit=103505 read=7571
9. 495.301 548.573 ↑ 1.1 169,856 1

Bitmap Heap Scan on c_order order1_ (cost=13,349.18..717,612.23 rows=187,841 width=66) (actual time=82.122..548.573 rows=169,856 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=100265
  • Buffers: shared hit=102412
10. 53.272 53.272 ↑ 1.1 180,982 1

Bitmap Index Scan on em_obpos_doctype_idx (cost=0.00..13,302.22 rows=205,561 width=0) (actual time=53.272..53.272 rows=180,982 loops=1)

  • Index Cond: ((c_doctype_id)::text = ANY ('{4F94921D217F48A993FE766B8334B936,7CE7854395964A60A29EB3C5B7D46B40,116D158017A74901960473E3231FF91F,D457B6F9629240058922D59065FCC63A,D14BC7AD73FB4DD0B815E52DE3B31DFE,7C03FC3EE0FF40EEB1C07283E60E57F8,6BC35B437FF546299164FEEE30B3E950,5F3EA76D38834CD99E7DD5673CC06358}'::text[]))
  • Buffers: shared hit=2147
11. 12.989 9,873.190 ↓ 4.5 6,644 1

Hash (cost=6,702.81..6,702.81 rows=1,467 width=49) (actual time=9,873.189..9,873.190 rows=6,644 loops=1)

  • Buckets: 8192 (originally 2048) Batches: 1 (originally 1) Memory Usage: 612kB
  • Buffers: shared hit=1093 read=7571
12. 9,639.975 9,860.201 ↓ 4.5 6,644 1

Bitmap Heap Scan on c_bpartner businesspa3_ (cost=963.37..6,702.81 rows=1,467 width=49) (actual time=224.996..9,860.201 rows=6,644 loops=1)

  • Recheck Cond: (upper((name)::text) ~~ '%ANDER%'::text)
  • Rows Removed by Index Recheck: 824
  • Heap Blocks: exact=7606
  • Buffers: shared hit=1093 read=7571
13. 220.226 220.226 ↓ 5.3 7,767 1

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

  • Index Cond: (upper((name)::text) ~~ '%ANDER%'::text)
  • Buffers: shared hit=672 read=386
14. 1,026.795 1,026.795 ↓ 0.0 0 385

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

  • 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: 2
  • Buffers: shared hit=946 read=1278
15. 8.970 8.970 ↑ 1.0 1 6

Index Scan using m_product_key on m_product product2_ (cost=0.56..3.40 rows=1 width=66) (actual time=1.495..1.495 rows=1 loops=6)

  • Index Cond: ((m_product_id)::text = (orderline0_.m_product_id)::text)
  • Buffers: shared hit=13 read=17
16. 0.822 0.822 ↓ 1.0 350 6

Seq Scan on obre_resource obre_resou4_ (cost=0.00..24.44 rows=344 width=33) (actual time=0.008..0.137 rows=350 loops=6)

  • Buffers: shared hit=124 read=2
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 : 6.213 ms
Execution time : 11,557.317 ms