explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 948p

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.083 ↑ 1.3 3 1

Sort (cost=46.31..46.32 rows=4 width=39) (actual time=0.083..0.083 rows=3 loops=1)

  • Output: build_log.environment_id, build_log.datetime_start, build_log.datetime_end, build_log.state, build_log.project_name, build_log_commit.revision
  • Sort Key: build_log.datetime_start DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=17
2. 0.004 0.069 ↑ 1.3 3 1

Nested Loop (cost=0.84..46.27 rows=4 width=39) (actual time=0.052..0.069 rows=3 loops=1)

  • Output: build_log.environment_id, build_log.datetime_start, build_log.datetime_end, build_log.state, build_log.project_name, build_log_commit.revision
  • Buffers: shared hit=17
3. 0.044 0.044 ↑ 1.3 3 1

Index Scan using build_log_commit_revision_idx on public.build_log_commit (cost=0.42..12.48 rows=4 width=8) (actual time=0.038..0.044 rows=3 loops=1)

  • Output: build_log_commit.revision, build_log_commit.build_log_id
  • Index Cond: (build_log_commit.revision = 197794)
  • Buffers: shared hit=5
4. 0.021 0.021 ↑ 1.0 1 3

Index Scan using build_log_pkey on public.build_log (cost=0.42..8.44 rows=1 width=39) (actual time=0.007..0.007 rows=1 loops=3)

  • Output: build_log.environment_id, build_log.datetime_start, build_log.datetime_end, build_log.state, build_log.project_name, build_log.id
  • Index Cond: (build_log.id = build_log_commit.build_log_id)
  • Buffers: shared hit=12
Planning time : 0.463 ms
Execution time : 0.158 ms