explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jrq

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.113 ↑ 1.0 1 1

Limit (cost=42.35..42.35 rows=1 width=637) (actual time=0.111..0.113 rows=1 loops=1)

2. 0.027 0.110 ↑ 1.0 1 1

Sort (cost=42.35..42.35 rows=1 width=637) (actual time=0.110..0.110 rows=1 loops=1)

  • Sort Key: slr_schedule_job.info_date_begin DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.083 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.12..42.34 rows=1 width=637) (actual time=0.078..0.083 rows=1 loops=1)

4. 0.001 0.082 ↑ 1.0 1 1

Nested Loop (cost=1.83..41.97 rows=1 width=557) (actual time=0.077..0.082 rows=1 loops=1)

5. 0.001 0.075 ↑ 1.0 1 1

Nested Loop (cost=1.55..33.66 rows=1 width=477) (actual time=0.071..0.075 rows=1 loops=1)

6. 0.003 0.066 ↑ 1.0 1 1

Nested Loop (cost=1.26..25.34 rows=1 width=376) (actual time=0.062..0.066 rows=1 loops=1)

7. 0.003 0.054 ↑ 1.0 1 1

Nested Loop (cost=0.84..16.89 rows=1 width=220) (actual time=0.050..0.054 rows=1 loops=1)

8. 0.033 0.033 ↑ 1.0 1 1

Index Scan using slr_schedule_job_employee_id on slr_schedule_job (cost=0.42..8.45 rows=1 width=38) (actual time=0.032..0.033 rows=1 loops=1)

  • Index Cond: (employee_id = 57538)
  • Filter: ((info_date_begin <= '2019-02-28'::date) AND (info_date_end >= '2019-02-01'::date))
9. 0.018 0.018 ↑ 1.0 1 1

Index Scan using slr_employee_pkey on slr_employee (cost=0.42..8.44 rows=1 width=182) (actual time=0.015..0.018 rows=1 loops=1)

  • Index Cond: (id = 57538)
10. 0.009 0.009 ↑ 1.0 1 1

Index Scan using slr_local_position_pkey on slr_local_position (cost=0.42..8.44 rows=1 width=156) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = slr_employee.position_id)
11. 0.008 0.008 ↑ 1.0 1 1

Index Scan using slr_manning_table_pkey on slr_manning_table (cost=0.29..8.31 rows=1 width=101) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = slr_employee.manning_table_id)
12. 0.006 0.006 ↑ 1.0 1 1

Index Scan using slr_work_time_schedule_pkey on slr_work_time_schedule (cost=0.28..8.30 rows=1 width=80) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: (id = slr_schedule_job.schedule_id)
13. 0.002 0.002 ↓ 0.0 0 1

Index Scan using slr_work_time_schedule_pkey on slr_work_time_schedule t6 (cost=0.28..0.36 rows=1 width=80) (actual time=0.001..0.002 rows=0 loops=1)

  • Index Cond: (slr_work_time_schedule.norm_schedule_id = id)