explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GgF0

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

Sort (cost=38.76..38.77 rows=4 width=186) (actual rows= loops=)

  • Sort Key: t13_opp_fact.sid, t13_opp_fact.start_stamp
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=21.09..38.72 rows=4 width=186) (actual rows= loops=)

  • Hash Cond: (t16_0.sid = t13_opp_fact.c117_opportunity_stagename)
3. 0.000 0.000 ↓ 0.0

Seq Scan on t16_opportunitystagenamepicklistdim t16_0 (cost=0.00..14.30 rows=430 width=36) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=21.04..21.04 rows=4 width=110) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.94..21.04 rows=4 width=110) (actual rows= loops=)

  • Hash Cond: (t15_0.sid = t13_opp_fact.c116_opportunity_forecastcategory)
6. 0.000 0.000 ↓ 0.0

Seq Scan on t15_opportunityforecastcategorypicklistdim t15_0 (cost=0.00..14.30 rows=430 width=36) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=2.88..2.88 rows=5 width=78) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on t13_opp_fact (cost=0.00..2.88 rows=5 width=78) (actual rows= loops=)

  • Filter: ((NOT deleted) AND (c118_opportunity_close_date >= 20,171,001) AND (c118_opportunity_close_date <= 20,171,231) AND (c114_opportunity_ownerid = 2) AND (to_timestamp(((start_stamp / 1000))::double precision) <= '2017-09-01 00:00:00+00'::timestamp with time zone) AND (to_timestamp(((end_stamp / 1000))::double precision) > '2017-09-01 00:00:00+00'::timestamp with time zone))