explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QT9p

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

Sort (cost=52.85..52.91 rows=23 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=39.35..52.33 rows=23 width=186) (actual rows= loops=)

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

Hash Join (cost=19.68..32.25 rows=23 width=110) (actual rows= loops=)

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

Seq Scan on t13_opp_fact (cost=0.00..12.51 rows=24 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))
5. 0.000 0.000 ↓ 0.0

Hash (cost=14.30..14.30 rows=430 width=36) (actual rows= loops=)

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=14.30..14.30 rows=430 width=36) (actual rows= loops=)

8. 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=)