explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SXdJ

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

XN Hash Left Join DS_DIST_ALL_NONE (cost=9.12..9.16 rows=1 width=121) (actual rows= loops=)

  • Hash Cond: ("outer".week_end_date = "inner".week_end_date)
2. 0.000 0.000 ↓ 0.0

XN Seq Scan on "day" (cost=0.00..0.01 rows=1 width=119) (actual rows= loops=)

  • Filter: (day_date = '2019-05-09'::date)
3. 0.000 0.000 ↓ 0.0

XN Hash (cost=7.30..7.30 rows=730 width=6) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

XN Seq Scan on week (cost=0.00..7.30 rows=730 width=6) (actual rows= loops=)