explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t73N

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 5,523.234 ↑ 1.0 20 1

Limit (cost=713,348.89..713,348.94 rows=20 width=744) (actual time=5,523.229..5,523.234 rows=20 loops=1)

2. 1,132.686 5,523.229 ↑ 76,267.8 20 1

Sort (cost=713,348.89..717,162.28 rows=1,525,356 width=744) (actual time=5,523.227..5,523.229 rows=20 loops=1)

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

Index Scan using index_projects_on_visibility_level_and_created_at_and_id2 on projects (cost=0.56..672,759.71 rows=1,525,356 width=744) (actual time=6.937..4,390.543 rows=1,526,941 loops=1)

  • Index Cond: (visibility_level = 20)
  • Filter: (NOT pending_delete)
  • Rows Removed by Filter: 50
Planning time : 0.469 ms
Execution time : 5,523.301 ms