explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wiWP

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

Hash Join (cost=2.78..20.96 rows=5 width=72) (actual rows= loops=)

  • Hash Cond: (t16_0.sid = t13_opp_fact.c117_opportunity_stagename)
2. 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=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=2.71..2.71 rows=5 width=40) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on t13_opp_fact (cost=0.00..2.71 rows=5 width=40) (actual rows= loops=)

  • Filter: ((c118_opportunity_close_date >= 20,170,901) AND (c118_opportunity_close_date < 20171231) 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))