explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LpPm : update license_management

Settings
# exclusive inclusive rows x rows loops node
1. 392,382.998 2,938,054.907 ↓ 0.0 0 1

ModifyTable on public.ci_job_artifacts (cost=0.57..8,491,007.47 rows=149,593 width=137) (actual time=2,938,054.907..2,938,054.907 rows=0 loops=1)

  • Buffers: shared hit=3,275,778 read=3,160,736 dirtied=524,020 written=44,241
  • I/O Timings: read=2,853,792.774 write=7,931.452
2. 2,545,671.909 2,545,671.909 ↑ 1.1 139,463 1

Index Scan using index_ci_job_artifacts_on_job_id_and_file_type on public.ci_job_artifacts (cost=0.57..8,491,007.47 rows=149,593 width=137) (actual time=62,467.261..2,545,671.909 rows=139,463 loops=1)

  • Index Cond: (ci_job_artifacts.file_type = 10)
  • Buffers: shared hit=2,654 read=2,872,350 dirtied=8 written=35,685
  • I/O Timings: read=2,494,125.990 write=6,293.961