explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wDXb

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

Sort (cost=20.78..20.79 rows=5 width=68) (actual rows= loops=)

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

Hash Join (cost=2.53..20.72 rows=5 width=68) (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=2.47..2.47 rows=5 width=28) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on t13_opp_fact (cost=0.00..2.47 rows=5 width=28) (actual rows= loops=)

  • Filter: ((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))