explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dgcs

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 27.344 42.242 ↓ 0.0 0 1

Bitmap Heap Scan on tagsr (cost=1.62..1.75 rows=1 width=274) (actual time=42.242..42.242 rows=0 loops=1)

  • Recheck Cond: ((((tagtype)::text = 'DELETE'::text) AND (dwdatetime >= (now() - '00:30:00'::interval)) AND (dwdatetime <= (now() - '00:15:00'::interval))) OR (((tagtype)::text = 'USER'::text) AND (dwdatetime >= (now() - '00:30:00'::interval)) AND (dwdatetime <= (now() - '00:15:00'::interval))))
  • Filter: (((plcuid)::text = '2bafcb6d-a51a-4612-bcf2-6c6ad2626eda'::text) AND (((tagtype)::text = 'DELETE'::text) OR (((tagtype)::text = 'USER'::text) AND (dwvalue <> 1073741824))) AND (dwdatetime >= (now() - '00:30:00'::interval)) AND (dwdatetime <= (now() - '00:15:00'::interval)))
  • Rows Removed by Filter: 5321
  • Heap Blocks: exact=2272
2. 0.002 14.898 ↓ 0.0 0 1

BitmapOr (cost=1.62..1.62 rows=1 width=0) (actual time=14.898..14.898 rows=0 loops=1)

3. 13.490 13.490 ↓ 10,162.0 10,162 1

Bitmap Index Scan on tagsr_type_dwdate_dwkey (cost=0.00..0.81 rows=1 width=0) (actual time=13.490..13.490 rows=10,162 loops=1)

  • Index Cond: (((tagtype)::text = 'DELETE'::text) AND (dwdatetime >= (now() - '00:30:00'::interval)) AND (dwdatetime <= (now() - '00:15:00'::interval)))
4. 1.406 1.406 ↓ 2,950.0 2,950 1

Bitmap Index Scan on tagsr_type_dwdate_dwkey (cost=0.00..0.81 rows=1 width=0) (actual time=1.406..1.406 rows=2,950 loops=1)

  • Index Cond: (((tagtype)::text = 'USER'::text) AND (dwdatetime >= (now() - '00:30:00'::interval)) AND (dwdatetime <= (now() - '00:15:00'::interval)))
Planning time : 0.428 ms
Execution time : 42.313 ms