explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ELCU

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 32.311 ↑ 1.3 3 1

Sort (cost=6,602.23..6,602.24 rows=4 width=39) (actual time=32.310..32.311 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=2445
2. 0.009 32.295 ↑ 1.3 3 1

Nested Loop (cost=0.42..6,602.19 rows=4 width=39) (actual time=32.244..32.295 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=2445
3. 32.259 32.259 ↑ 1.3 3 1

Seq Scan on public.build_log_commit (cost=0.00..6,568.40 rows=4 width=8) (actual time=32.221..32.259 rows=3 loops=1)

  • Output: build_log_commit.revision, build_log_commit.build_log_id
  • Filter: (build_log_commit.revision = 197794)
  • Rows Removed by Filter: 326823
  • Buffers: shared hit=2433
4. 0.027 0.027 ↑ 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.008..0.009 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.348 ms
Execution time : 32.362 ms