explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WnpS

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.033 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.00..13.25 rows=1 width=8) (actual time=0.033..0.033 rows=0 loops=1)

2. 0.000 0.033 ↓ 0.0 0 1

Nested Loop (cost=0.00..12.71 rows=1 width=12) (actual time=0.033..0.033 rows=0 loops=1)

3. 0.033 0.033 ↓ 0.0 0 1

Index Scan using cal_event_i04 on cal_event_t ce (cost=0.00..4.41 rows=1 width=16) (actual time=0.033..0.033 rows=0 loops=1)

  • Index Cond: (start_date > '2018-12-03'::date)
4. 0.000 0.000 ↓ 0.0 0

Index Scan using om_task_pk on om_task_t tt (cost=0.00..8.29 rows=1 width=8) (never executed)

  • Index Cond: (id = ce.task_id)
5. 0.000 0.000 ↓ 0.0 0

Index Scan using fm_status_pk on fm_status_t st (cost=0.00..0.27 rows=1 width=8) (never executed)

  • Index Cond: (id = tt.status_id)
  • Filter: ((code)::text = ANY ('{ORPHAN,CANCEL}'::text[]))