explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qcNb

Settings
# exclusive inclusive rows x rows loops node
1. 59.339 493.810 ↓ 0.0 0 1

Hash Join (cost=64,844.05..68,795.81 rows=8,211 width=8) (actual time=493.810..493.810 rows=0 loops=1)

  • Hash Cond: (ce.task_id = tt.id)
2. 12.103 12.103 ↓ 1.1 32,841 1

Index Scan using cal_event_i04 on cal_event_t ce (cost=0.00..1,703.27 rows=31,138 width=16) (actual time=0.016..12.103 rows=32,841 loops=1)

  • Index Cond: (start_date > '2018-12-03'::date)
3. 77.205 422.368 ↓ 1.5 587,230 1

Hash (cost=58,338.96..58,338.96 rows=396,487 width=4) (actual time=422.368..422.368 rows=587,230 loops=1)

  • Buckets: 4096 Batches: 32 (originally 16) Memory Usage: 1025kB
4. 185.601 345.163 ↓ 1.5 587,230 1

Hash Join (cost=1.17..58,338.96 rows=396,487 width=4) (actual time=0.022..345.163 rows=587,230 loops=1)

  • Hash Cond: (tt.status_id = st.id)
5. 159.555 159.555 ↑ 1.0 1,387,705 1

Seq Scan on om_task_t tt (cost=0.00..50,821.05 rows=1,387,705 width=8) (actual time=0.009..159.555 rows=1,387,705 loops=1)

6. 0.000 0.007 ↑ 1.0 2 1

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

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

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

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