explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i6tP

Settings
# exclusive inclusive rows x rows loops node
1. 0.584 2.472 ↑ 1.1 131 1

Bitmap Heap Scan on public.job (cost=484.10..925.60 rows=144 width=363) (actual time=1.912..2.472 rows=131 loops=1)

  • Output: uuid, state, last_update, queue_time, start_time, end_time, job_type, phase_history, service_node_uuid, throughput, progress_percentage, progress_status, machine_uuid, tenant_uui
  • Recheck Cond: (((job.job_type = 'MACHINE_SOURCE_SYNC'::jobtype) AND (job.start_time <= (now() - '1 day'::interval))) OR (job.start_time <= (now() - '60 days'::interval)))
  • Filter: (((job.job_type = 'MACHINE_SOURCE_SYNC'::jobtype) AND (job.start_time <= (now() - '1 day'::interval))) OR ((job.job_type <> 'MACHINE_SOURCE_SYNC'::jobtype) AND (job.start_time <=
  • (now() - '60 days'::interval))))
  • Heap Blocks: exact=113
  • Buffers: shared hit=204
  • Planning time: 0.849 ms
  • Execution time: 2.576 ms
2. 0.002 1.888 ↓ 0.0 0 1

BitmapOr (cost=484.10..484.10 rows=144 width=0) (actual time=1.888..1.888 rows=0 loops=1)

  • Buffers: shared hit=91
3. 0.038 1.880 ↓ 0.0 0 1

BitmapAnd (cost=479.76..479.76 rows=144 width=0) (actual time=1.880..1.880 rows=0 loops=1)

  • Buffers: shared hit=89
4. 0.104 0.104 ↓ 1.2 472 1

Bitmap Index Scan on ix_job_job_type (cost=0.00..15.26 rows=396 width=0) (actual time=0.104..0.104 rows=472 loops=1)

  • Index Cond: (job.job_type = 'MACHINE_SOURCE_SYNC'::jobtype)
  • Buffers: shared hit=4
5. 1.738 1.738 ↑ 1.0 14,363 1

Bitmap Index Scan on ix_job_start_time (cost=0.00..464.18 rows=14,385 width=0) (actual time=1.738..1.738 rows=14,363 loops=1)

  • Index Cond: (job.start_time <= (now() - '1 day'::interval))
  • Buffers: shared hit=85
6. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on ix_job_start_time (cost=0.00..4.30 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (job.start_time <= (now() - '60 days'::interval))
  • Buffers: shared hit=2