explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m763

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.087 ↓ 0.0 0 1

Delete on ld_property_override (cost=9.52..11.16 rows=1 width=12) (actual time=0.087..0.087 rows=0 loops=1)

2. 0.013 0.086 ↓ 0.0 0 1

Hash Anti Join (cost=9.52..11.16 rows=1 width=12) (actual time=0.086..0.086 rows=0 loops=1)

  • Hash Cond: ((ld_property_override.key)::text = (ld_property_default.key)::text)
3. 0.010 0.010 ↓ 1.2 54 1

Seq Scan on ld_property_override (cost=0.00..1.46 rows=46 width=24) (actual time=0.006..0.010 rows=54 loops=1)

4. 0.030 0.063 ↓ 1.0 208 1

Hash (cost=7.01..7.01 rows=201 width=31) (actual time=0.063..0.063 rows=208 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
5. 0.033 0.033 ↓ 1.0 208 1

Seq Scan on ld_property_default (cost=0.00..7.01 rows=201 width=31) (actual time=0.004..0.033 rows=208 loops=1)

Planning time : 0.160 ms
Execution time : 0.106 ms