explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b6P9

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

Delete on location_lock (cost=0.00..22.15 rows=1 width=6) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on location_lock (cost=0.00..22.15 rows=1 width=6) (actual rows= loops=)

  • Filter: ((last_updated < '2020-05-12 00:00:00+03'::timestamp with time zone) AND (array_length(locations, 1) IS NULL))