explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F1TI : Optimization for: plan #dgcs

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 50,764.227 50,764.227 ↓ 7,701.0 7,701 1

Index Scan using tagsr_type_dwdate_plcuid on tagsr (cost=0.69..0.91 rows=1 width=274) (actual time=39.967..50,764.227 rows=7,701 loops=1)

  • Index Cond: (((tagtype)::text = 'DELETE'::text) AND (dwdatetime >= '2020-01-14 07:01:26.578'::timestamp without time zone) AND (dwdatetime <= '2020-01-14 07:19:46.578'::timestamp without time zone) AND ((plcuid)::text = '4251ed62-7090-4f98-a9cd-5839512593e7'::text))
  • Buffers: shared hit=11436 read=101189 dirtied=437
Planning time : 0.225 ms
Execution time : 50,766.122 ms