explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DVjq

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 5,232.605 ↑ 1.0 20 1

Limit (cost=880,421.44..880,421.49 rows=20 width=737) (actual time=5,232.599..5,232.605 rows=20 loops=1)

2. 1,453.947 5,232.602 ↑ 75,957.6 20 1

Sort (cost=880,421.44..884,219.32 rows=1,519,152 width=737) (actual time=5,232.597..5,232.602 rows=20 loops=1)

  • Sort Key: last_activity_at DESC, id DESC
  • Sort Method: top-N heapsort Memory: 35kB
3. 3,778.655 3,778.655 ↓ 1.0 1,526,941 1

Index Scan using projects_last_activity_at_id_idx on projects (cost=0.43..839,997.35 rows=1,519,152 width=737) (actual time=0.016..3,778.655 rows=1,526,941 loops=1)

  • Filter: (NOT pending_delete)
  • Rows Removed by Filter: 50
Planning time : 0.476 ms
Execution time : 5,232.673 ms