explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CD8J

Settings
# exclusive inclusive rows x rows loops node
1. 0.043 9.281 ↑ 1.0 1 1

Aggregate (cost=232.97..232.98 rows=1 width=40) (actual time=9.281..9.281 rows=1 loops=1)

2. 0.012 9.238 ↑ 1.0 50 1

Limit (cost=0.43..232.22 rows=50 width=12) (actual time=0.034..9.238 rows=50 loops=1)

3. 9.226 9.226 ↑ 1,378.9 50 1

Index Scan Backward using customer_feedbacks_created_at_idx on customer_feedbacks (cost=0.43..319,605.62 rows=68,945 width=12) (actual time=0.033..9.226 rows=50 loops=1)

  • Filter: (customer_id = '4'::text)
  • Rows Removed by Filter: 5389
Planning time : 2.416 ms
Execution time : 9.392 ms