explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QoxY

Settings
# exclusive inclusive rows x rows loops node
1. 0.045 712.720 ↑ 18,037.0 1 1

Sort (cost=53,825.56..53,870.65 rows=18,037 width=201) (actual time=712.719..712.72 rows=1 loops=1)

  • Sort Key: se.start_time DESC, se.step_execution_id DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=42,606, temp read=3,775 written=3,775
2. 138.721 712.675 ↑ 18,037.0 1 1

Hash Join (cost=28,292.62..52,550.47 rows=18,037 width=201) (actual time=522.562..712.675 rows=1 loops=1)

  • Buffers: shared hit=42,600, temp read=3,775 written=3,775
3. 85.986 85.986 ↓ 1.1 38,201 1

Index Scan using batch_step_exe_ix on batch_step_execution se (cost=0.42..15,834.57 rows=36,074 width=140) (actual time=0.073..85.986 rows=38,201 loops=1)

  • Index Cond: ((se.step_name)::text = 'sendNStep'::text)
  • Buffers: shared hit=25,294
4. 189.979 373.365 ↓ 1.0 548,654 1

Hash (cost=14,700.31..14,700.31 rows=539,431 width=77) (actual time=373.364..373.365 rows=548,654 loops=1)

  • Buffers: shared hit=9,306, temp written=3,351
5. 183.386 183.386 ↓ 1.0 548,654 1

Seq Scan on batch_job_execution je (cost=0..14,700.31 rows=539,431 width=77) (actual time=0.015..183.386 rows=548,654 loops=1)

  • Buffers: shared hit=9,306
6.          

SubPlan (for Hash Join)

7. 61.392 114.603 ↑ 41,494.7 13 38,201

Result (cost=0..14,700.31 rows=539,431 width=8) (actual time=0..0.003 rows=13 loops=38,201)

  • Buffers: shared hit=8,000
8. 53.211 53.211 ↑ 1.1 497,994 1

Seq Scan on batch_job_execution batch_job_execution (cost=0..14,700.31 rows=539,431 width=8) (actual time=0.009..53.211 rows=497,994 loops=1)

  • Buffers: shared hit=8,000
Planning time : 0.763 ms
Execution time : 712.956 ms