explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qIdy

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

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

2. 0.003 0.010 ↓ 0.0 0 1

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

  • Sort Key: start_at
  • Sort Method: quicksort Memory: 25kB
3. 0.007 0.007 ↓ 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.007..0.007 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[])))