explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5dqM : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.45..3,008,325.02 rows=261,399 width=973) (actual rows= loops=)

  • Hash Cond: ((ma.vision_customer_id)::numeric = (substr((pf.vision_id)::text, 1, 9))::numeric)
2. 0.000 0.000 ↓ 0.0

Seq Scan on master_account ma (cost=0.00..2,548,260.64 rows=52,279,764 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=2.44..2.44 rows=1 width=965) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using pnm_feed_uk on pnm_feed pf (cost=0.42..2.44 rows=1 width=965) (actual rows= loops=)

  • Index Cond: ((vision_id)::text = '6546723520001'::text)