explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9oT1

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

Limit (cost=8.31..8.32 rows=1 width=74) (actual time=0.044..0.044 rows=0 loops=1)

2. 0.004 0.042 ↓ 0.0 0 1

Sort (cost=8.31..8.32 rows=1 width=74) (actual time=0.042..0.042 rows=0 loops=1)

  • Sort Key: start_at
  • Sort Method: quicksort Memory: 25kB
3. 0.038 0.038 ↓ 0.0 0 1

Index Scan using lessons_executor_id_status_start_at_idx on lessons (cost=0.28..8.30 rows=1 width=74) (actual time=0.038..0.038 rows=0 loops=1)

  • Index Cond: (executor_id = 362)
  • Filter: ((start_at >= '2019-11-08 09:45:35'::timestamp without time zone) AND (status = ANY ('{wait_lesson,find_coach,start}'::lesson_status[])))