explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zpi

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 4.384 ↑ 266.5 2 1

Limit (cost=175.46..178.17 rows=533 width=8) (actual time=3.509..4.384 rows=2 loops=1)

2. 0.560 4.382 ↑ 266.5 2 1

Merge Left Join (cost=175.46..178.17 rows=533 width=8) (actual time=3.507..4.382 rows=2 loops=1)

  • Merge Cond: (o.id = "OrderPropertyDO"."orderRef")
  • Filter: ((((o.id)::character varying)::text ~~ '%7421-2%'::text) OR (((o.id)::character varying)::text ~~ '10343%'::text) OR ((o."shopOrderNo")::text ~~ '%7421-2%'::text) OR ("OrderPropertyDO"."orderRef" IS NOT NULL))
  • Rows Removed by Filter: 638
3. 0.722 3.762 ↓ 1.2 640 1

Sort (cost=171.08..172.42 rows=536 width=43) (actual time=3.441..3.762 rows=640 loops=1)

  • Sort Key: o.id DESC
  • Sort Method: quicksort Memory: 75kB
4. 0.730 3.040 ↓ 1.2 640 1

Hash Semi Join (cost=95.45..146.79 rows=536 width=43) (actual time=1.828..3.040 rows=640 loops=1)

  • Hash Cond: (o.id = op."orderRef")
5. 0.502 0.502 ↓ 1.2 640 1

Seq Scan on "OrderDO" o (cost=0.00..41.95 rows=539 width=43) (actual time=0.007..0.502 rows=640 loops=1)

  • Filter: ("shopRef" = ANY ('{0,500,1,200,210,220,230,120,100,300,110,111}'::bigint[]))
6. 0.749 1.808 ↓ 1.1 1,214 1

Hash (cost=81.65..81.65 rows=1,104 width=8) (actual time=1.807..1.808 rows=1,214 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 64kB
7. 1.059 1.059 ↓ 1.1 1,214 1

Seq Scan on "OrderPosDO" op (cost=0.00..81.65 rows=1,104 width=8) (actual time=0.006..1.059 rows=1,214 loops=1)

  • Filter: ("supplierRef" = ANY ('{1,3000,1211,1212,1000,2000,1200,1210,1100}'::bigint[]))
8. 0.009 0.060 ↑ 1.0 1 1

Sort (cost=4.37..4.38 rows=1 width=8) (actual time=0.059..0.060 rows=1 loops=1)

  • Sort Key: "OrderPropertyDO"."orderRef" DESC
  • Sort Method: quicksort Memory: 25kB
9. 0.005 0.051 ↑ 1.0 1 1

Unique (cost=4.34..4.35 rows=1 width=8) (actual time=0.048..0.051 rows=1 loops=1)

10. 0.020 0.046 ↑ 1.0 1 1

Sort (cost=4.34..4.35 rows=1 width=8) (actual time=0.044..0.046 rows=1 loops=1)

  • Sort Key: "OrderPropertyDO"."orderRef
  • Sort Method: quicksort Memory: 25kB
11. 0.026 0.026 ↑ 1.0 1 1

Seq Scan on "OrderPropertyDO" (cost=0.00..4.33 rows=1 width=8) (actual time=0.024..0.026 rows=1 loops=1)

  • Filter: (((value)::text ~~ '%7421-2%'::text) AND ((key)::text = 'myOrderNo'::text))
  • Rows Removed by Filter: 95
Planning time : 0.514 ms
Execution time : 4.461 ms