explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HMeS

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 4.607 ↑ 1.0 1 1

Aggregate (cost=356.64..356.65 rows=1 width=8) (actual time=4.605..4.607 rows=1 loops=1)

2. 0.007 4.600 ↑ 71.5 6 1

Limit (cost=350.20..351.27 rows=429 width=8) (actual time=4.591..4.600 rows=6 loops=1)

3. 0.030 4.593 ↑ 71.5 6 1

Sort (cost=350.20..351.27 rows=429 width=8) (actual time=4.589..4.593 rows=6 loops=1)

  • Sort Key: o.id DESC
  • Sort Method: quicksort Memory: 25kB
4. 0.025 4.563 ↑ 71.5 6 1

Hash Semi Join (cost=232.39..331.44 rows=429 width=8) (actual time=4.108..4.563 rows=6 loops=1)

  • Hash Cond: (o.id = op."orderRef")
5. 0.857 1.290 ↑ 71.5 6 1

Seq Scan on "OrderDO" o (cost=88.46..180.01 rows=429 width=8) (actual time=0.841..1.290 rows=6 loops=1)

  • Filter: (((((id)::character varying)::text ~~ '%456%'::text) OR (("shopOrderNo")::text ~~ '%456%'::text) OR (hashed SubPlan 1)) AND ("shopRef" = ANY ('{0,500,1,200,210,220,230,120,100,300,110,111}'::bigint[])))
  • Rows Removed by Filter: 1111
6.          

SubPlan (for Seq Scan)

7. 0.433 0.433 ↑ 1.2 4 1

Seq Scan on "OrderPropertyDO" (cost=0.00..88.44 rows=5 width=8) (actual time=0.033..0.433 rows=4 loops=1)

  • Filter: (((key)::text = ANY ('{myOrderNo,SAPOrder}'::text[])) AND ((value)::text ~~ '%456%'::text))
  • Rows Removed by Filter: 2369
8. 1.238 3.248 ↓ 1.3 1,806 1

Hash (cost=126.02..126.02 rows=1,433 width=8) (actual time=3.247..3.248 rows=1,806 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 87kB
9. 2.010 2.010 ↓ 1.3 1,806 1

Seq Scan on "OrderPosDO" op (cost=0.00..126.02 rows=1,433 width=8) (actual time=0.008..2.010 rows=1,806 loops=1)

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