explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZwYE

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

Sort (cost=13,568,234.16..13,568,443.12 rows=83,586 width=46) (actual rows= loops=)

  • Sort Key: swp_mstar_fund_mpi.fund_ticker, mstar_total_index_return.asof_date
2. 0.000 0.000 ↓ 0.0

WindowAgg (cost=13,556,947.41..13,558,828.09 rows=83,586 width=46) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=13,556,947.41..13,557,156.37 rows=83,586 width=22) (actual rows= loops=)

  • Sort Key: mstar_total_index_return.asof_date
4. 0.000 0.000 ↓ 0.0

Gather (cost=20,650.10..13,550,113.85 rows=83,586 width=22) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=19,650.10..13,540,755.25 rows=34,828 width=22) (actual rows= loops=)

  • Hash Cond: ((mstar_total_index_return.mstar_id)::text = (swp_mstar_fund_mpi.mstar
  • -> Parallel Seq Scan on mstar_total_index_return (cost=0.00..13511962.50 rows=3
  • Filter: ((total_index_return IS NOT NULL) AND (to_char(asof_date, 'DY'::tex
6. 0.000 0.000 ↓ 0.0

Hash (cost=19,587.30..19,587.30 rows=5,024 width=17) (actual rows= loops=)

  • -> Seq Scan on swp_mstar_fund_mpi (cost=0.00..19587.30 rows=5,024 width=17
  • Filter: (upper((fund_ticker)::text) = ANY ('{PTTRX,PIMIX}'::text[]))