explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TYlx

Settings
# exclusive inclusive rows x rows loops node
1. 24.130 543.022 ↓ 0.0 0 1

Hash Semi Join (cost=67,008.93..69,612.39 rows=34,906 width=8) (actual time=543.022..543.022 rows=0 loops=1)

  • Hash Cond: (ce.task_id = tt.id)
2. 60.682 60.682 ↓ 1.1 40,168 1

Index Scan using cal_event_i04 on cal_event_t ce (cost=0.00..1,851.93 rows=37,803 width=16) (actual time=0.011..60.682 rows=40,168 loops=1)

  • Index Cond: (start_date > '2018-12-03'::date)
3. 107.724 458.210 ↓ 1.2 591,848 1

Hash (cost=60,869.83..60,869.83 rows=491,128 width=4) (actual time=458.210..458.210 rows=591,848 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 20808kB
4. 222.399 350.486 ↓ 1.2 591,848 1

Hash Join (cost=1.17..60,869.83 rows=491,128 width=4) (actual time=0.017..350.486 rows=591,848 loops=1)

  • Hash Cond: (tt.status_id = st.id)
5. 128.081 128.081 ↑ 1.0 1,438,312 1

Seq Scan on om_task_t tt (cost=0.00..52,887.83 rows=1,473,383 width=8) (actual time=0.002..128.081 rows=1,438,312 loops=1)

6. 0.001 0.006 ↑ 1.0 2 1

Hash (cost=1.15..1.15 rows=2 width=8) (actual time=0.006..0.006 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
7. 0.005 0.005 ↑ 1.0 2 1

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

  • Filter: ((code)::text = ANY ('{ORPHAN,CANCEL}'::text[]))
  • Rows Removed by Filter: 10