explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h5oK

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 17.191 ↑ 1.0 1 1

Aggregate (cost=256,939.21..256,939.22 rows=1 width=8) (actual time=17.190..17.191 rows=1 loops=1)

2. 0.039 17.165 ↑ 7,754.0 17 1

Nested Loop (cost=44,366.69..256,609.66 rows=131,818 width=8) (actual time=5.545..17.165 rows=17 loops=1)

3. 0.012 5.401 ↑ 1.0 1 1

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

  • Group Key: internal.lgr_ticket
4. 0.006 5.389 ↑ 1.0 1 1

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

5. 5.383 5.383 ↑ 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=5.383..5.383 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. 11.725 11.725 ↑ 53.7 17 1

Index Scan using idx_lgr_ticket on uat_log_revalidation external (cost=0.57..212,234.41 rows=913 width=15) (actual time=0.141..11.725 rows=17 loops=1)

  • Index Cond: (lgr_ticket = internal.lgr_ticket)
  • Filter: (lgr_action_ticket IS NOT NULL)
  • Rows Removed by Filter: 18811