explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g6k0

Settings
# exclusive inclusive rows x rows loops node
1. 931.581 1,275.580 ↓ 1.1 348,101 1

Bitmap Heap Scan on tmp_sdl_bundled_workorders (cost=9,571.74..651,478.23 rows=324,555 width=969) (actual time=426.823..1,275.580 rows=348,101 loops=1)

  • Recheck Cond: (wo_entered_date >= '2019-07-01 00:00:00'::timestamp without time zone)
  • Heap Blocks: exact=239327
  • Buffers: shared hit=244152
2. 343.999 343.999 ↓ 4.1 1,330,090 1

Bitmap Index Scan on indx_bundled_orderdate (cost=0.00..9,490.60 rows=324,555 width=0) (actual time=343.999..343.999 rows=1,330,090 loops=1)

  • Index Cond: (wo_entered_date >= '2019-07-01 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=4825
Planning time : 0.190 ms