explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v5cK

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

Sort (cost=38.72..38.73 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.05..38.68 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.00..21.00 rows=4 width=110) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.90..21.00 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.84..2.84 rows=5 width=78) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on t13_opp_fact (cost=0.00..2.84 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))