explain.depesz.com

PostgreSQL's explain analyze made readable

Result: InUU

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 4,031.238 ↓ 0.0 0 1

Limit (cost=29,122.02..29,122.03 rows=1 width=108) (actual time=4,031.238..4,031.238 rows=0 loops=1)

  • Buffers: shared hit=88723 read=73
2. 0.012 4,031.236 ↓ 0.0 0 1

Sort (cost=29,122.02..29,122.03 rows=1 width=108) (actual time=4,031.236..4,031.236 rows=0 loops=1)

  • Sort Key: order0_.dateordered DESC, order0_.documentno DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=88723 read=73
3. 0.000 4,031.224 ↓ 0.0 0 1

Nested Loop (cost=9,598.26..29,122.01 rows=1 width=108) (actual time=4,031.224..4,031.224 rows=0 loops=1)

  • Buffers: shared hit=88723 read=73
4. 0.002 4,031.224 ↓ 0.0 0 1

Nested Loop Semi Join (cost=9,597.70..29,113.43 rows=1 width=125) (actual time=4,031.224..4,031.224 rows=0 loops=1)

  • Buffers: shared hit=88723 read=73
5. 0.037 4,031.222 ↓ 0.0 0 1

Bitmap Heap Scan on c_order order0_ (cost=9,597.14..29,060.63 rows=81 width=125) (actual time=4,031.222..4,031.222 rows=0 loops=1)

  • Recheck Cond: (upper((documentno)::text) ~~ '%24.101/002692%'::text)
  • Rows Removed by Index Recheck: 1
  • Filter: ((em_obpos_applications_id IS NOT NULL) AND (cancelledorder_id IS NULL) AND ((c_doctype_id)::text = ANY ('{2B0E8C61AD624AD291CE1D04384128DD,C3847F7938834C47A14C00FC98A9819C}'::text[])) AND (em_obpos_isdeleted = 'N'::bpchar))
  • Heap Blocks: exact=1
  • Buffers: shared hit=88723 read=73
6. 4,031.185 4,031.185 ↑ 4,949.0 1 1

Bitmap Index Scan on em_obpos_order_docno_trgm (cost=0.00..9,597.12 rows=4,949 width=0) (actual time=4,031.185..4,031.185 rows=1 loops=1)

  • Index Cond: (upper((documentno)::text) ~~ '%24.101/002692%'::text)
  • Buffers: shared hit=88723 read=72
7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using em_obpos_deliveredqty on c_orderline orderlinel2_ (cost=0.57..24.84 rows=295 width=33) (never executed)

  • Index Cond: ((c_order_id = (order0_.c_order_id)::text) AND (qtydelivered > '0'::numeric))
  • Heap Fetches: 0
8. 0.000 0.000 ↓ 0.0 0

Index Scan using c_bpartner_key on c_bpartner businesspa1_ (cost=0.56..8.58 rows=1 width=49) (never executed)

  • Index Cond: ((c_bpartner_id)::text = (order0_.c_bpartner_id)::text)
Planning time : 2.670 ms
Execution time : 4,031.687 ms