explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H1rE

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

Limit (cost=575,427.30..575,427.35 rows=20 width=743) (actual time=5,218.246..5,218.253 rows=20 loops=1)

2. 1,029.525 5,218.248 ↑ 76,746.6 20 1

Sort (cost=575,427.30..579,264.63 rows=1,534,932 width=743) (actual time=5,218.246..5,218.248 rows=20 loops=1)

  • Sort Key: created_at, id DESC
  • Sort Method: top-N heapsort Memory: 31kB
3. 4,188.723 4,188.723 ↓ 1.0 1,537,348 1

Index Scan using index_projects_on_visibility_level_and_created_at_and_id on projects (cost=0.56..534,583.31 rows=1,534,932 width=743) (actual time=0.028..4,188.723 rows=1,537,348 loops=1)

  • Index Cond: (visibility_level = 20)
  • Filter: (NOT pending_delete)
  • Rows Removed by Filter: 51
Planning time : 0.375 ms
Execution time : 5,218.316 ms