explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LHG6

Settings
# exclusive inclusive rows x rows loops node
1. 0.201 1,327.850 ↑ 1.0 300 1

Limit (cost=40,260.29..40,261.04 rows=300 width=642) (actual time=1,327.521..1,327.850 rows=300 loops=1)

2. 0.395 1,327.649 ↑ 1.5 300 1

Sort (cost=40,260.29..40,261.45 rows=464 width=642) (actual time=1,327.519..1,327.649 rows=300 loops=1)

  • Sort Key: "TestStatsApp_jenkinsbuild".build_number DESC
  • Sort Method: quicksort Memory: 150kB
3. 445.067 1,327.254 ↓ 1.0 477 1

HashAggregate (cost=40,235.10..40,239.74 rows=464 width=642) (actual time=1,326.961..1,327.254 rows=477 loops=1)

  • Group Key: "TestStatsApp_jenkinsbuild".id
4. 606.802 882.187 ↓ 1.0 686,781 1

Hash Right Join (cost=17.44..28,395.91 rows=676,525 width=622) (actual time=0.465..882.187 rows=686,781 loops=1)

  • Hash Cond: ("TestStatsApp_testcaseresult".build_id = "TestStatsApp_jenkinsbuild".id)
5. 274.931 274.931 ↓ 1.0 686,770 1

Seq Scan on "TestStatsApp_testcaseresult" (cost=0.00..19,076.25 rows=676,525 width=24) (actual time=0.005..274.931 rows=686,770 loops=1)

6. 0.239 0.454 ↓ 1.0 477 1

Hash (cost=11.64..11.64 rows=464 width=602) (actual time=0.454..0.454 rows=477 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 62kB
7. 0.215 0.215 ↓ 1.0 477 1

Seq Scan on "TestStatsApp_jenkinsbuild" (cost=0.00..11.64 rows=464 width=602) (actual time=0.006..0.215 rows=477 loops=1)

Planning time : 0.255 ms
Execution time : 1,328.012 ms