explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XAqL

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.121 ↓ 0.0 0 1

GroupAggregate (cost=87.67..87.69 rows=1 width=12) (actual time=0.121..0.121 rows=0 loops=1)

  • Group Key: tb.start_date
2. 0.012 0.119 ↓ 0.0 0 1

Sort (cost=87.67..87.68 rows=1 width=12) (actual time=0.119..0.119 rows=0 loops=1)

  • Sort Key: tb.start_date
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.107 ↓ 0.0 0 1

Nested Loop (cost=1.27..87.66 rows=1 width=12) (actual time=0.107..0.107 rows=0 loops=1)

4. 0.000 0.106 ↓ 0.0 0 1

Nested Loop (cost=1.12..79.46 rows=1 width=20) (actual time=0.106..0.106 rows=0 loops=1)

5. 0.000 0.106 ↓ 0.0 0 1

Nested Loop (cost=0.84..71.15 rows=1 width=28) (actual time=0.106..0.106 rows=0 loops=1)

6. 0.001 0.106 ↓ 0.0 0 1

Nested Loop (cost=0.57..70.84 rows=1 width=36) (actual time=0.106..0.106 rows=0 loops=1)

7. 0.105 0.105 ↓ 0.0 0 1

Index Scan using i_timeblock_location on timeblock tb (cost=0.29..62.53 rows=1 width=36) (actual time=0.105..0.105 rows=0 loops=1)

  • Index Cond: (location_id = 10)
  • Filter: ((date_published IS NOT NULL) AND (start_date >= '2013-01-07'::date) AND (start_date <= '2013-01-07'::date) AND (id <> 10) AND (last_published = 'N'::bpchar))
  • Rows Removed by Filter: 77
8. 0.000 0.000 ↓ 0.0 0

Index Scan using employee_pkey on employee emp (cost=0.28..8.30 rows=1 width=16) (never executed)

  • Index Cond: (id = tb.employee_id)
  • Filter: (deleted = 'N'::bpchar)
9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using i_au_id_del on app_user au (cost=0.28..0.31 rows=1 width=8) (never executed)

  • Index Cond: (id = emp.user_id)
  • Filter: (id <> 45)
  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

Index Scan using location_pkey on location loc (cost=0.28..8.29 rows=1 width=8) (never executed)

  • Index Cond: (id = 10)
  • Filter: (deleted = 'N'::bpchar)
11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using i_schedule_idtempn on schedule sch (cost=0.15..8.17 rows=1 width=8) (never executed)

  • Index Cond: (id = tb.schedule_id)