explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c3vM

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 4,764.321 ↑ 1.0 20 1

Limit (cost=713,348.89..713,348.94 rows=20 width=744) (actual time=4,764.314..4,764.321 rows=20 loops=1)

2. 1,293.240 4,764.315 ↑ 76,267.8 20 1

Sort (cost=713,348.89..717,162.28 rows=1,525,356 width=744) (actual time=4,764.312..4,764.315 rows=20 loops=1)

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

Index Scan using abrandl_test5 on projects (cost=0.56..672,759.71 rows=1,525,356 width=744) (actual time=0.020..3,471.075 rows=1,526,941 loops=1)

  • Index Cond: (visibility_level = 20)
  • Filter: (NOT pending_delete)
  • Rows Removed by Filter: 50
Planning time : 1.017 ms
Execution time : 4,764.426 ms