explain.depesz.com

PostgreSQL's explain analyze made readable

Result: feiP

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

CTE Scan on data (cost=11.41..13.93 rows=37 width=237) (actual rows= loops=)

  • Filter: (row_number > 1)
2.          

CTE data

3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=6.93..11.41 rows=112 width=136) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=6.93..7.21 rows=112 width=92) (actual rows= loops=)

  • Sort Key: labels.project_id, labels.title, labels.id
5. 0.000 0.000 ↓ 0.0

Seq Scan on labels (cost=0.00..3.12 rows=112 width=92) (actual rows= loops=)