explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FmvF

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 2,158.624 ↑ 1.0 75 1

Limit (cost=4,846,863.88..4,846,864.07 rows=75 width=49) (actual time=2,158.613..2,158.624 rows=75 loops=1)

  • Buffers: shared hit=494749, temp read=1738 written=1732
2. 0.158 2,158.618 ↑ 19.5 75 1

Sort (cost=4,846,863.88..4,846,867.54 rows=1,465 width=49) (actual time=2,158.612..2,158.618 rows=75 loops=1)

  • Sort Key: businesspa3_.name
  • Sort Method: top-N heapsort Memory: 32kB
  • Buffers: shared hit=494749, temp read=1738 written=1732
3. 0.208 2,158.460 ↑ 7.2 204 1

HashAggregate (cost=4,846,796.28..4,846,810.93 rows=1,465 width=49) (actual time=2,158.432..2,158.460 rows=204 loops=1)

  • Group Key: businesspa3_.name, businesspa3_.c_bpartner_id
  • Buffers: shared hit=494749, temp read=1738 written=1732
4. 0.114 2,158.252 ↑ 6.6 222 1

Nested Loop (cost=76,345.62..4,846,788.96 rows=1,465 width=49) (actual time=564.139..2,158.252 rows=222 loops=1)

  • Buffers: shared hit=494749, temp read=1738 written=1732
5. 0.125 2,155.696 ↑ 6.6 222 1

Nested Loop Anti Join (cost=76,345.06..4,836,399.98 rows=1,465 width=33) (actual time=564.125..2,155.696 rows=222 loops=1)

  • Buffers: shared hit=493637, temp read=1738 written=1732
6. 0.342 2,154.366 ↑ 6.1 241 1

Nested Loop (cost=76,344.64..4,826,479.91 rows=1,466 width=66) (actual time=564.111..2,154.366 rows=241 loops=1)

  • Buffers: shared hit=492893, temp read=1738 written=1732
7. 40.375 2,145.510 ↑ 119.4 946 1

Hash Join (cost=76,344.08..3,994,752.83 rows=112,973 width=66) (actual time=530.833..2,145.510 rows=946 loops=1)

  • Hash Cond: ((orderline0_.m_product_id)::text = (product2_.m_product_id)::text)
  • Buffers: shared hit=488149, temp read=1738 written=1732
8. 1,610.842 1,798.113 ↑ 18.8 81,707 1

Bitmap Heap Scan on c_orderline orderline0_ (cost=56,622.97..3,918,541.26 rows=1,539,661 width=99) (actual time=193.664..1,798.113 rows=81,707 loops=1)

  • Recheck Cond: ((ad_org_id)::text = '392FC5F103F442A597F2F4C07698A9A9'::text)
  • Rows Removed by Index Recheck: 3835710
  • Filter: (qtydelivered <> qtyordered)
  • Rows Removed by Filter: 1313143
  • Heap Blocks: exact=17242 lossy=388911
  • Buffers: shared hit=416181
9. 187.271 187.271 ↑ 1.1 1,401,574 1

Bitmap Index Scan on em_oborpre_ordline_org (cost=0.00..56,238.05 rows=1,547,398 width=0) (actual time=187.271..187.271 rows=1,401,574 loops=1)

  • Index Cond: ((ad_org_id)::text = '392FC5F103F442A597F2F4C07698A9A9'::text)
  • Buffers: shared hit=10028
10. 43.716 307.022 ↓ 1.0 188,956 1

Hash (cost=15,897.14..15,897.14 rows=188,238 width=33) (actual time=307.022..307.022 rows=188,956 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 4034kB
  • Buffers: shared hit=71968, temp written=915
11. 22.334 263.306 ↓ 1.0 188,956 1

Nested Loop (cost=105.45..15,897.14 rows=188,238 width=33) (actual time=0.346..263.306 rows=188,956 loops=1)

  • Buffers: shared hit=71968
12. 0.061 0.166 ↑ 1.0 2 1

HashAggregate (cost=24.29..24.31 rows=2 width=33) (actual time=0.163..0.166 rows=2 loops=1)

  • Group Key: (obre_resou4_.m_product_category_id)::text
  • Buffers: shared hit=20
13. 0.105 0.105 ↑ 1.0 343 1

Seq Scan on obre_resource obre_resou4_ (cost=0.00..23.43 rows=343 width=33) (actual time=0.005..0.105 rows=343 loops=1)

  • Buffers: shared hit=20
14. 215.422 240.806 ↓ 44.1 94,478 2

Bitmap Heap Scan on m_product product2_ (cost=81.16..7,914.98 rows=2,143 width=66) (actual time=15.897..120.403 rows=94,478 loops=2)

  • Recheck Cond: ((m_product_category_id)::text = (obre_resou4_.m_product_category_id)::text)
  • Rows Removed by Index Recheck: 193818
  • Heap Blocks: exact=36406 lossy=34184
  • Buffers: shared hit=71948
15. 25.384 25.384 ↓ 44.1 94,478 2

Bitmap Index Scan on m_product_productcategory (cost=0.00..80.63 rows=2,143 width=0) (actual time=12.692..12.692 rows=94,478 loops=2)

  • Index Cond: ((m_product_category_id)::text = (obre_resou4_.m_product_category_id)::text)
  • Buffers: shared hit=1358
16. 8.514 8.514 ↓ 0.0 0 946

Index Scan using c_order_key on c_order order1_ (cost=0.56..7.35 rows=1 width=66) (actual time=0.009..0.009 rows=0 loops=946)

  • Index Cond: ((c_order_id)::text = (orderline0_.c_order_id)::text)
  • Filter: (((docstatus)::text = 'CO'::text) AND ((c_doctype_id)::text = ANY ('{4F94921D217F48A993FE766B8334B936,7CE7854395964A60A29EB3C5B7D46B40,116D158017A74901960473E3231FF91F,D457B6F9629240058922D59065FCC63A,D14BC7AD73FB4DD0B815E52DE3B31DFE,7C03FC3EE0FF40EEB1C07283E60E57F8,6BC35B437FF546299164FEEE30B3E950,B475D71C30534BF2912C039F1770785E}'::text[])))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4744
17. 1.205 1.205 ↓ 0.0 0 241

Index Only Scan using obre_reservation_cordline_idx on obre_reservation obre_reser5_ (cost=0.42..6.77 rows=1 width=33) (actual time=0.005..0.005 rows=0 loops=241)

  • Index Cond: (c_orderline_id = (orderline0_.c_orderline_id)::text)
  • Heap Fetches: 19
  • Buffers: shared hit=744
18. 2.442 2.442 ↑ 1.0 1 222

Index Scan using c_bpartner_key on c_bpartner businesspa3_ (cost=0.56..7.08 rows=1 width=49) (actual time=0.011..0.011 rows=1 loops=222)

  • Index Cond: ((c_bpartner_id)::text = (order1_.c_bpartner_id)::text)
  • Buffers: shared hit=1112
Planning time : 2.080 ms
Execution time : 2,158.777 ms