explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KdWH

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 3.583 ↓ 3.0 3 1

Nested Loop (cost=1.27..498.95 rows=1 width=2,000) (actual time=3.237..3.583 rows=3 loops=1)

2. 0.011 3.537 ↓ 3.0 3 1

Nested Loop (cost=0.99..426.67 rows=1 width=1,643) (actual time=3.211..3.537 rows=3 loops=1)

3. 0.012 3.514 ↓ 3.0 3 1

Nested Loop (cost=0.84..418.46 rows=1 width=1,487) (actual time=3.197..3.514 rows=3 loops=1)

4. 0.012 3.481 ↓ 3.0 3 1

Nested Loop (cost=0.56..418.00 rows=1 width=692) (actual time=3.177..3.481 rows=3 loops=1)

5. 3.442 3.442 ↓ 3.0 3 1

Index Scan using i_timeblock_schedule on timeblock tb (cost=0.28..409.69 rows=1 width=200) (actual time=3.152..3.442 rows=3 loops=1)

  • Filter: ((date_published IS NOT NULL) AND (start_date >= '2019-08-29'::date) AND (start_date <= '2019-10-01'::date) AND (last_published = 'Y'::bpchar))
  • Rows Removed by Filter: 7331
6. 0.027 0.027 ↑ 1.0 1 3

Index Scan using employee_pkey on employee emp (cost=0.28..8.30 rows=1 width=492) (actual time=0.009..0.009 rows=1 loops=3)

  • Index Cond: (id = tb.employee_id)
  • Filter: (deleted = 'N'::bpchar)
7. 0.021 0.021 ↑ 1.0 1 3

Index Scan using i_au_id_del on app_user aur (cost=0.28..0.46 rows=1 width=795) (actual time=0.007..0.007 rows=1 loops=3)

  • Index Cond: (id = emp.user_id)
8. 0.012 0.012 ↑ 1.0 1 3

Index Scan using i_schedule_idtempn on schedule scd (cost=0.15..8.17 rows=1 width=156) (actual time=0.004..0.004 rows=1 loops=3)

  • Index Cond: (id = tb.schedule_id)
9. 0.027 0.027 ↑ 1.0 1 3

Index Scan using location_pkey on location loc (cost=0.28..54.28 rows=1 width=357) (actual time=0.009..0.009 rows=1 loops=3)

  • Index Cond: ((id = tb.location_id) AND (id = ANY ('{206,1056,892,183,184,186,835,883,836,884,188,872,1072,1073,1074,860,164,201,1005,204,159,190}'::bigint[])))
  • Filter: (deleted = 'N'::bpchar)
Planning time : 4.525 ms