explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HTC4

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

Insert on email (cost=0.01..0.02 rows=1 width=146) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Subquery Scan on a (cost=0.01..0.02 rows=1 width=146) (actual rows= loops=)

  • Filter: (a.ordem = 1)
3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0.01..0.02 rows=0 width=154) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=0.01..0.02 rows=0 width=146) (actual rows= loops=)

  • Sort Key: id, updated_at
5. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=0 width=146) (actual rows= loops=)

  • One-Time Filter: false