explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7bsj : restore renamed labels

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

Update on labels (cost=13.94..17.50 rows=2 width=183) (actual rows= loops=)

2.          

CTE backups

3. 0.000 0.000 ↓ 0.0

Seq Scan on backup_labels (cost=0.00..13.88 rows=2 width=36) (actual rows= loops=)

  • Filter: (restore_action = 2)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.07..3.63 rows=2 width=183) (actual rows= loops=)

  • Hash Cond: (labels.id = backups.id)
5. 0.000 0.000 ↓ 0.0

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

6. 0.000 0.000 ↓ 0.0

Hash (cost=0.04..0.04 rows=2 width=96) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

CTE Scan on backups (cost=0.00..0.04 rows=2 width=96) (actual rows= loops=)