explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 25RN

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

Update on ad (cost=0.00..35.72 rows=1,890 width=231) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..35.72 rows=1,890 width=231) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on ""user"" (cost=0.00..4.54 rows=105 width=6) (actual rows= loops=)

  • Filter: (""availableBudget"" <= 0)
4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..7.60 rows=18 width=223) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on ad (cost=0.00..7.51 rows=18 width=223) (actual rows= loops=)

  • Filter: (userid = 142)