explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9SYJ

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

Hash Join (cost=8,659.97..30,581.71 rows=56,579 width=114) (actual rows= loops=)

  • Hash Cond: (prod.prod_id = prod_prc.prod_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on prod (cost=0.00..13,724.40 rows=353,940 width=18) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=7,123.74..7,123.74 rows=56,579 width=96) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=9.73..7,123.74 rows=56,579 width=96) (actual rows= loops=)

  • Hash Cond: (prod_prc.st_id = gnl_st.gnl_st_id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on prod_prc (cost=0.00..5,684.16 rows=230,416 width=103) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=8.86..8.86 rows=69 width=5) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on gnl_st (cost=0.00..8.86 rows=69 width=5) (actual rows= loops=)

  • Filter: ((shrt_code)::text = ANY ('{PNDG_ACTV,ACTV,PNDG_CNCL}'::text[]))