explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bOpC

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 9.879 ↑ 25.0 4 1

Limit (cost=33,795.99..33,796.24 rows=100 width=4,943) (actual time=9.878..9.879 rows=4 loops=1)

  • Execution time: 9.974 ms(
2.          

CTE inner_query

3. 0.011 9.861 ↑ 4,207.2 4 1

Hash Left Join (cost=1,236.92..32,816.22 rows=16,829 width=822) (actual time=9.820..9.861 rows=4 loops=1)

  • Hash Cond: (builds.compilation_id = manifest_compilations.id)
4. 0.013 9.572 ↑ 4,207.2 4 1

Hash Join (cost=1,208.98..32,512.71 rows=16,829 width=788) (actual time=9.535..9.572 rows=4 loops=1)

  • Hash Cond: (builds.productid = products.productid)
5. 0.039 7.427 ↑ 4,207.2 4 1

Hash Join (cost=924.91..31,997.24 rows=16,829 width=732) (actual time=7.390..7.427 rows=4 loops=1)

  • Hash Cond: (builds.branchid = branches.branchid)
6. 0.053 0.053 ↑ 4,207.2 4 1

Index Scan using builds_status_index on builds (cost=0.56..30,841.50 rows=16,829 width=706) (actual time=0.020..0.053 rows=4 loops=1)

  • Index Cond: ((status)::text = 'queued'::text)
  • Filter: ((site)::text = 'sjc31'::text)
7. 4.507 7.335 ↓ 1.0 30,245 1

Hash (cost=546.93..546.93 rows=30,193 width=26) (actual time=7.335..7.335 rows=30,245 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 2,216kB
8. 2.828 2.828 ↓ 1.0 30,245 1

Seq Scan on branches (cost=0.00..546.93 rows=30,193 width=26) (actual time=0.004..2.828 rows=30,245 loops=1)

9. 1.307 2.132 ↓ 1.0 8,189 1

Hash (cost=181.81..181.81 rows=8,181 width=56) (actual time=2.132..2.132 rows=8,189 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 842kB
10. 0.825 0.825 ↓ 1.0 8,189 1

Seq Scan on products (cost=0.00..181.81 rows=8,181 width=56) (actual time=0.005..0.825 rows=8,189 loops=1)

11. 0.141 0.278 ↑ 1.0 975 1

Hash (cost=15.75..15.75 rows=975 width=18) (actual time=0.278..0.278 rows=975 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 57kB
12. 0.137 0.137 ↑ 1.0 975 1

Seq Scan on manifest_compilations (cost=0.00..15.75 rows=975 width=18) (actual time=0.004..0.137 rows=975 loops=1)

13. 0.007 9.877 ↑ 4,207.2 4 1

Sort (cost=979.77..1,021.84 rows=16,829 width=4,943) (actual time=9.876..9.877 rows=4 loops=1)

  • Sort Key: inner_query.kickedoff
  • Sort Method: quicksort Memory: 26kB
14. 9.870 9.870 ↑ 4,207.2 4 1

CTE Scan on inner_query (cost=0.00..336.58 rows=16,829 width=4,943) (actual time=9.824..9.870 rows=4 loops=1)

Planning time : 0.843 ms