explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E5qJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 13.654 ↓ 0.0 0 1

Bitmap Heap Scan on tagsr (cost=145,128.91..370,607.79 rows=181,967 width=280) (actual time=13.654..13.654 rows=0 loops=1)

  • Recheck Cond: (((assetuid)::text = 'ee463abb-dfa8-4096-885c-49efb59dffc5'::text) AND (plcdatetime < '2019-11-30 14:18:30.151'::timestamp without time zone))
  • Filter: ((edcuid)::text = '163748c2-cad3-4696-a013-5e3e76815b35'::text)
2. 13.650 13.650 ↓ 0.0 0 1

Bitmap Index Scan on tagsr_asset_plcdate2 (cost=0.00..145,083.42 rows=206,844 width=0) (actual time=13.650..13.650 rows=0 loops=1)

  • Index Cond: (((assetuid)::text = 'ee463abb-dfa8-4096-885c-49efb59dffc5'::text) AND (plcdatetime < '2019-11-30 14:18:30.151'::timestamp without time zone))
Planning time : 0.393 ms
Execution time : 13.676 ms