explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3XwA

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 3,258.759 ↑ 1.0 1 1

Limit (cost=0.56..17.12 rows=1 width=64) (actual time=3,258.758..3,258.759 rows=1 loops=1)

2. 3,258.757 3,258.757 ↑ 113,149.0 1 1

Index Scan using index_hit_entries_on_created_at on hit_entries (cost=0.56..1,873,018.09 rows=113,149 width=64) (actual time=3,258.757..3,258.757 rows=1 loops=1)

  • Filter: (bot_id = 20947)
  • Rows Removed by Filter: 6862991