explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fucl

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 1.442 ↑ 1.0 1 1

Limit (cost=0.57..39,062.66 rows=1 width=7) (actual time=1.440..1.442 rows=1 loops=1)

2. 1.435 1.435 ↑ 25.0 1 1

Index Scan using idx_lgr_rev_svcid_dvcid on uat_log_revalidation internal (cost=0.57..976,552.62 rows=25 width=7) (actual time=1.435..1.435 rows=1 loops=1)

  • Index Cond: ((lgr_dvcid = '254861'::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: 1183