explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1INZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 5.057 ↑ 1.0 1 1

Aggregate (cost=9,642.63..9,642.64 rows=1 width=8) (actual time=5.056..5.057 rows=1 loops=1)

2. 0.001 5.052 ↓ 0.0 0 1

Limit (cost=9,633.99..9,635.43 rows=576 width=8) (actual time=5.052..5.052 rows=0 loops=1)

3. 0.008 5.051 ↓ 0.0 0 1

Sort (cost=9,633.99..9,635.43 rows=576 width=8) (actual time=5.050..5.051 rows=0 loops=1)

  • Sort Key: o.id DESC
  • Sort Method: quicksort Memory: 25kB
4. 0.002 5.043 ↓ 0.0 0 1

Hash Semi Join (cost=259.13..9,607.58 rows=576 width=8) (actual time=5.042..5.043 rows=0 loops=1)

  • Hash Cond: (o.id = op."orderRef")
5. 1.762 5.041 ↓ 0.0 0 1

Bitmap Heap Scan on "OrderDO" o (cost=72.02..9,410.39 rows=576 width=8) (actual time=5.040..5.041 rows=0 loops=1)

  • Recheck Cond: ("shopRef" = ANY ('{0,500,1,200,210,220,230,120,100,300,110,111}'::bigint[]))
  • Filter: ((((id)::character varying)::text ~~ '456%'::text) OR (("shopOrderNo")::text ~~ '456%'::text) OR (("shopCustomerOrderNo")::text ~~ '456%'::text) OR (SubPlan 1))
  • Rows Removed by Filter: 1538
  • Heap Blocks: exact=60
6. 0.203 0.203 ↓ 1.7 1,910 1

Bitmap Index Scan on "index_OrderDO_shopRef" (cost=0.00..71.88 rows=1,145 width=0) (actual time=0.202..0.203 rows=1,910 loops=1)

  • Index Cond: ("shopRef" = ANY ('{0,500,1,200,210,220,230,120,100,300,110,111}'::bigint[]))
7.          

SubPlan (for Bitmap Heap Scan)

8. 3.076 3.076 ↓ 0.0 0 1,538

Index Scan using "index_OrderPropertyDO_orderRef" on "OrderPropertyDO" (cost=0.28..15.84 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1,538)

  • Index Cond: ("orderRef" = o.id)
  • Filter: (((key)::text = ANY ('{myOrderNo,SAPOrder}'::text[])) AND ((value)::text ~~ '456%'::text))
  • Rows Removed by Filter: 2
9. 0.000 0.000 ↓ 0.0 0

Hash (cost=162.30..162.30 rows=1,985 width=8) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Seq Scan on "OrderPosDO" op (cost=0.00..162.30 rows=1,985 width=8) (never executed)

  • Filter: ("supplierRef" = ANY ('{1,3000,1211,1212,1000,2000,1200,1210,1100}'::bigint[]))
Planning time : 1.141 ms
Execution time : 5.132 ms