explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GXHI

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.009 ↓ 0.0 0 1

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

2. 0.004 0.008 ↓ 0.0 0 1

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

  • Sort Key: start_at
  • Sort Method: quicksort Memory: 25kB
3. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

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