explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XbQL

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 3,675.825 ↑ 1.0 20 1

Limit (cost=711,679.51..711,679.56 rows=20 width=737) (actual time=3,675.819..3,675.825 rows=20 loops=1)

2. 970.284 3,675.822 ↑ 75,957.6 20 1

Sort (cost=711,679.51..715,477.39 rows=1,519,152 width=737) (actual time=3,675.817..3,675.822 rows=20 loops=1)

  • Sort Key: updated_at DESC, id DESC
  • Sort Method: top-N heapsort Memory: 33kB
3. 2,705.538 2,705.538 ↓ 1.0 1,526,941 1

Index Scan using index_projects_on_visibility_level_and_created_at_and_id2 on projects (cost=0.56..671,255.42 rows=1,519,152 width=737) (actual time=0.019..2,705.538 rows=1,526,941 loops=1)

  • Index Cond: (visibility_level = 20)
  • Filter: (NOT pending_delete)
  • Rows Removed by Filter: 50
Planning time : 0.438 ms
Execution time : 3,675.896 ms