explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h2EO

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.134 ↑ 1.0 20 1

Limit (cost=0.56..9.40 rows=20 width=737) (actual time=0.086..0.134 rows=20 loops=1)

2. 0.134 0.134 ↑ 75,957.6 20 1

Index Scan using test_desc on projects (cost=0.56..671,255.42 rows=1,519,152 width=737) (actual time=0.086..0.134 rows=20 loops=1)

  • Index Cond: (visibility_level = 20)
  • Filter: (NOT pending_delete)
Planning time : 0.561 ms
Execution time : 0.183 ms