explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d1Lv

Settings
# exclusive inclusive rows x rows loops node
1. 37.692 172.638 ↑ 160.0 1 1

Gather Merge (cost=7,911.57..7,930.24 rows=160 width=12) (actual time=155.581..172.638 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.042 134.946 ↓ 0.0 0 3 / 3

Sort (cost=6,911.55..6,911.75 rows=80 width=12) (actual time=134.945..134.946 rows=0 loops=3)

  • Sort Key: su1.presence_asked_at
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
3. 0.009 134.904 ↓ 0.0 0 3 / 3

Hash Anti Join (cost=7.73..6,909.02 rows=80 width=12) (actual time=84.283..134.904 rows=0 loops=3)

  • Hash Cond: (su1.id = mte1.execution_scheduler_result)
4. 134.866 134.866 ↓ 0.0 0 3 / 3

Parallel Seq Scan on slack_user su1 (cost=0.00..6,900.28 rows=80 width=12) (actual time=84.246..134.866 rows=0 loops=3)

  • Filter: (snack_time_participant AND (NOT app_uninstalled) AND (presence_asked_at < (now() - '00:05:00'::interval)))
  • Rows Removed by Filter: 65,979
5. 0.000 0.029 ↓ 0.0 0 1 / 3

Hash (cost=7.72..7.72 rows=1 width=4) (actual time=0.085..0.086 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
6. 0.005 0.028 ↓ 0.0 0 1 / 3

Nested Loop (cost=3.69..7.72 rows=1 width=4) (actual time=0.085..0.085 rows=0 loops=1)

7. 0.014 0.014 ↓ 7.0 7 1 / 3

Index Scan using maintenance_task_execution_ended_at_maintenance_task_id_idx on maintenance_task_execution mte1 (cost=0.42..2.42 rows=1 width=8) (actual time=0.026..0.043 rows=7 loops=1)

  • Index Cond: (ended_at IS NULL)
8. 0.005 0.009 ↓ 0.0 0 7 / 3

Bitmap Heap Scan on maintenance_task mt1 (cost=3.27..4.29 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=7)

  • Recheck Cond: (id = mte1.maintenance_task_id)
  • Filter: (nid = 'update_user_presence'::text)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=7
9. 0.005 0.005 ↑ 1.0 1 7 / 3

Bitmap Index Scan on maintenance_task_pkey (cost=0.00..3.27 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=7)

  • Index Cond: (id = mte1.maintenance_task_id)
Planning time : 0.494 ms
Execution time : 172.809 ms