explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TTeG

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=13,637.49..13,637.52 rows=10 width=1,214) (actual rows= loops=)

2.          

CTE deliverables_build

3. 0.000 0.000 ↓ 0.0

Index Scan using deliverables_buildid_index on deliverables (cost=0.57..13,395.32 rows=5,820 width=243) (actual rows= loops=)

  • Index Cond: (buildid = 28,920,689)
4. 0.000 0.000 ↓ 0.0

Sort (cost=242.17..256.72 rows=5,820 width=1,214) (actual rows= loops=)

  • Sort Key: deliverables_build.deliverableid
5. 0.000 0.000 ↓ 0.0

CTE Scan on deliverables_build (cost=0.00..116.40 rows=5,820 width=1,214) (actual rows= loops=)