explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yGvA : Optimization for: plan #KTq6

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Group (cost=3,129,966.58..3,129,983.51 rows=3,348 width=10) (actual rows= loops=)

  • Group Key: h."HCP_ID
2. 0.000 0.000 ↓ 0.0

Sort (cost=3,129,966.58..3,129,975.05 rows=3,387 width=10) (actual rows= loops=)

  • Sort Key: h."HCP_ID
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2,630,395.05..3,129,768.00 rows=3,387 width=10) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on "COUNTRY" c (cost=0.00..5.53 rows=1 width=4) (actual rows= loops=)

  • Filter: (("COUNTRY_ID" = 3) AND (("COUNTRY_CD")::text = 'FRA'::text))
5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "EVENT" h (cost=2,630,395.05..3,129,728.61 rows=3,387 width=14) (actual rows= loops=)

  • Recheck Cond: (("COUNTRY_ID" = 3) AND ("SOURCE_SYSTEM_ID" = 109))
  • Filter: ((("HCP_ID")::text <> '-1'::text) AND ("CALENDAR_ID" >= 20,191,016) AND ("CALENDAR_ID" <= 20,201,015) AND (("BUSINESS_UNIT")::text = 'VAC'::text) AND (("EVENT_STATUS")::text = 'Submitted'::text))
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "IND_EVENT_CD_CTRY_ID_SRC_SYS_ID" (cost=0.00..2,630,394.21 rows=151,073 width=0) (actual rows= loops=)

  • Index Cond: (("COUNTRY_ID" = 3) AND ("SOURCE_SYSTEM_ID" = 109))