explain.depesz.com

PostgreSQL's explain analyze made readable

Result: anVR

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1.805 ↑ 1.0 1 1

Limit (cost=0.57..39,428.64 rows=1 width=7) (actual time=1.804..1.805 rows=1 loops=1)

2. 1.799 1.799 ↑ 42.0 1 1

Index Scan using idx_lgr_rev_svcid_dvcid on uat_log_revalidation internal (cost=0.57..1,655,979.22 rows=42 width=7) (actual time=1.799..1.799 rows=1 loops=1)

  • Index Cond: ((lgr_dvcid = '254851'::numeric) AND (lgr_rev_svcid = '52'::numeric))
  • Filter: (('2020-02-25'::date = lgr_date) AND ((lgr_action)::text = 'Starting Revalidation'::text))
  • Rows Removed by Filter: 1021