explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0FYd

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 19,492.808 ↑ 25.0 4 1

Limit (cost=1.41..11,535.23 rows=100 width=823) (actual time=19,480.985..19,492.808 rows=4 loops=1)

2. 0.011 19,492.807 ↑ 6,349.0 4 1

Nested Loop Left Join (cost=1.41..2,929,130.07 rows=25,396 width=823) (actual time=19,480.984..19,492.807 rows=4 loops=1)

3. 0.004 19,492.784 ↑ 6,349.0 4 1

Nested Loop (cost=1.13..2,921,149.82 rows=25,396 width=789) (actual time=19,480.977..19,492.784 rows=4 loops=1)

4. 0.008 19,492.764 ↑ 6,349.0 4 1

Nested Loop (cost=0.85..2,912,777.06 rows=25,396 width=733) (actual time=19,480.969..19,492.764 rows=4 loops=1)

5. 19,492.736 19,492.736 ↑ 6,349.0 4 1

Index Scan using builds_kickedoff_index on builds (cost=0.56..2,903,457.32 rows=25,396 width=707) (actual time=19,480.950..19,492.736 rows=4 loops=1)

  • Filter: (((status)::text = 'queued'::text) AND ((site)::text = 'sjc31'::text))
  • Rows Removed by Filter: 24,048,824
6. 0.020 0.020 ↑ 1.0 1 4

Index Scan using branches_pkey on branches (cost=0.29..0.36 rows=1 width=26) (actual time=0.004..0.005 rows=1 loops=4)

  • Index Cond: (branchid = builds.branchid)
7. 0.016 0.016 ↑ 1.0 1 4

Index Scan using products_pkey on products (cost=0.28..0.32 rows=1 width=56) (actual time=0.004..0.004 rows=1 loops=4)

  • Index Cond: (productid = builds.productid)
8. 0.012 0.012 ↓ 0.0 0 4

Index Scan using manifest_compilations_pk on manifest_compilations (cost=0.28..0.29 rows=1 width=18) (actual time=0.003..0.003 rows=0 loops=4)

  • Index Cond: (builds.compilation_id = id)
Planning time : 1.598 ms
Execution time : 19,492.884 ms