explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3osi

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

Delete on report_cache_index (cost=0.42..2.64 rows=1 width=6) (actual time=0.038..0.038 rows=0 loops=1)

2. 0.037 0.037 ↓ 0.0 0 1

Index Scan using idx_rpt_cache on report_cache_index (cost=0.42..2.64 rows=1 width=6) (actual time=0.037..0.037 rows=0 loops=1)

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