explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yy45

Settings
# exclusive inclusive rows x rows loops node
1. 433.222 672.288 ↑ 1.5 497,361 1

Bitmap Heap Scan on tagsr (cost=594,361.97..1,474,853.14 rows=745,236 width=280) (actual time=268.527..672.288 rows=497,361 loops=1)

  • Recheck Cond: (((assetuid)::text = 'ee463abb-dfa8-4096-885c-49efb59dffc5'::text) AND (plcdatetime < '2019-11-30 14:55:30.151'::timestamp without time zone))
  • Filter: ((edcuid)::text = '163748c2-cad3-4696-a013-5e3e76815b35'::text)
  • Heap Blocks: exact=81476
2. 239.066 239.066 ↑ 1.3 635,438 1

Bitmap Index Scan on tagsr_asset_plcdate2 (cost=0.00..594,175.66 rows=847,118 width=0) (actual time=239.066..239.066 rows=635,438 loops=1)

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