explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q2wT

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

Hash Left Join (cost=112,549.42..1,703,528.16 rows=1,792,428 width=282) (actual rows= loops=)

  • Hash Cond: (cd.curtyp = (qd.loaitien)::bpchar)
2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=112,547.63..952,947.14 rows=1,792,428 width=142) (actual rows= loops=)

  • Hash Cond: (ft.acc_id = cd.acctno)
  • -> Seq Scan on ft_accday ft (cost=0.00..727497.34 rows=3824357 width=26
  • Filter: ((acctyp_id)::text = 'CD'::text)
3. 0.000 0.000 ↓ 0.0

Hash (cost=56,884.28..56,884.28 rows=1,792,428 width=126) (actual rows= loops=)

  • -> Seq Scan on cdmast cd (cost=0.00..56884.28 rows=1792428 width=
4. 0.000 0.000 ↓ 0.0

Hash (cost=1.35..1.35 rows=35 width=10) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on ssfxrt qd (cost=0.00..1.35 rows=35 width=10) (actual rows= loops=)