explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HwCN

Settings
# exclusive inclusive rows x rows loops node
1. 20.899 13,138.538 ↑ 1.0 1 1

Aggregate (cost=278,450.37..278,450.38 rows=1 width=8) (actual time=13,138.537..13,138.538 rows=1 loops=1)

2. 43.109 13,117.639 ↑ 451.7 18,828 1

Nested Loop (cost=44,366.69..257,189.47 rows=8,504,361 width=8) (actual time=650.866..13,117.639 rows=18,828 loops=1)

3. 0.015 647.096 ↑ 1.0 1 1

HashAggregate (cost=44,366.12..44,366.13 rows=1 width=7) (actual time=647.094..647.096 rows=1 loops=1)

  • Group Key: internal.lgr_ticket
4. 0.005 647.081 ↑ 1.0 1 1

Limit (cost=0.57..44,366.10 rows=1 width=7) (actual time=647.079..647.081 rows=1 loops=1)

5. 647.076 647.076 ↑ 1.0 1 1

Index Scan using idx_lgr_rev_svcid_dvcid on uat_log_revalidation internal (cost=0.57..44,366.10 rows=1 width=7) (actual time=647.076..647.076 rows=1 loops=1)

  • Index Cond: ((lgr_dvcid = '583124'::numeric) AND (lgr_rev_svcid = '53'::numeric))
  • Filter: (('2019-04-24'::date = lgr_date) AND ((lgr_action)::text = 'Starting Revalidation'::text))
  • Rows Removed by Filter: 6166
6. 12,427.434 12,427.434 ↑ 3.1 18,828 1

Index Scan using idx_lgr_ticket on uat_log_revalidation external (cost=0.57..212,234.41 rows=58,894 width=15) (actual time=3.762..12,427.434 rows=18,828 loops=1)

  • Index Cond: (lgr_ticket = internal.lgr_ticket)