explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nXaS

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 22.070 ↓ 0.0 0 1

Delete on report_cache_index (cost=0.54..4,747.40 rows=1 width=6) (actual time=22.070..22.070 rows=0 loops=1)

2. 22.067 22.067 ↓ 0.0 0 1

Index Scan using uk_report_cache_index on report_cache_index (cost=0.54..4,747.40 rows=1 width=6) (actual time=22.067..22.067 rows=0 loops=1)

  • Index Cond: ((cube_name)::text = 'Altria'::text)
Planning time : 0.170 ms