explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Baqi

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

Nested Loop (cost=0.00..54,630.66 rows=1 width=8) (actual time=261.143..261.143 rows=0 loops=1)

2. 0.005 261.143 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.00..54,295.58 rows=39 width=4) (actual time=261.143..261.143 rows=0 loops=1)

  • Join Filter: (tt.status_id = st.id)
  • Rows Removed by Join Filter: 4
3. 261.120 261.120 ↑ 68.5 2 1

Seq Scan on om_task_t tt (cost=0.00..54,290.31 rows=137 width=8) (actual time=261.120..261.120 rows=2 loops=1)

  • Filter: (last_modify_date > '2018-12-02 23:45:00'::timestamp without time zone)
  • Rows Removed by Filter: 1387703
4. 0.006 0.018 ↑ 1.0 2 2

Materialize (cost=0.00..1.16 rows=2 width=8) (actual time=0.008..0.009 rows=2 loops=2)

5. 0.012 0.012 ↑ 1.0 2 1

Seq Scan on fm_status_t st (cost=0.00..1.15 rows=2 width=8) (actual time=0.010..0.012 rows=2 loops=1)

  • Filter: ((code)::text = ANY ('{ORPHAN,CANCEL}'::text[]))
  • Rows Removed by Filter: 10
6. 0.000 0.000 ↓ 0.0 0

Index Scan using cal_event_i06 on cal_event_t ce (cost=0.00..8.58 rows=1 width=16) (never executed)

  • Index Cond: (task_id = tt.id)
  • Filter: (start_date > '2018-12-03'::date)