explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fTli

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 364.354 ↑ 1.0 1 1

Limit (cost=0.44..5.85 rows=1 width=8) (actual time=364.352..364.354 rows=1 loops=1)

  • Buffers: shared hit=435946
2. 364.351 364.351 ↑ 28,687.0 1 1

Index Scan using merge_request_metrics_merged_at on public.merge_request_metrics (cost=0.44..155,318.95 rows=28,687 width=8) (actual time=364.350..364.351 rows=1 loops=1)

  • Index Cond: (merge_request_metrics.merged_at > '2019-09-01 00:00:00'::timestamp without time zone)
  • Filter: (merge_request_metrics.commits_count IS NOT NULL)
  • Rows Removed by Filter: 441710
  • Buffers: shared hit=435946