explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g3Ln

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 6,469.846 ↑ 10.0 20 1

Limit (cost=0.43..112.25 rows=200 width=313) (actual time=0.816..6,469.846 rows=20 loops=1)

2. 6,469.830 6,469.830 ↑ 89,143.3 20 1

Index Scan Backward using eatery_comments_created_at_idx on eatery_comments (cost=0.43..996,742.23 rows=1,782,866 width=313) (actual time=0.814..6,469.830 rows=20 loops=1)

  • Filter: (order_id > 0)
  • Rows Removed by Filter: 5337407
Planning time : 0.247 ms
Execution time : 6,469.896 ms