explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n6aE

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 0.069 ↓ 3.0 3 1

Hash Anti Join (cost=12.03..22.34 rows=1 width=154) (actual time=0.054..0.069 rows=3 loops=1)

  • Hash Cond: ((t1.order_no)::text = (t2.order_no)::text)
2. 0.029 0.029 ↓ 1.5 6 1

Seq Scan on t_order t1 (cost=0.00..10.30 rows=4 width=154) (actual time=0.023..0.029 rows=6 loops=1)

  • Filter: ((basket_no)::text = ANY ('{mczu6ze74fvbmzdlu3a1dwowud0x0m5k,zolso9c8ucyp3axnbn9qqn1iuxmdl49x,birnqken1jx02l1wpyu6tuznbgrmnor8,tnjqsosodvnuyl3tuzbb1youhoh5e32m}'::text[]))
3. 0.006 0.017 ↑ 30.0 3 1

Hash (cost=10.90..10.90 rows=90 width=72) (actual time=0.017..0.017 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.011 0.011 ↑ 30.0 3 1

Seq Scan on t_order_booking t2 (cost=0.00..10.90 rows=90 width=72) (actual time=0.008..0.011 rows=3 loops=1)