explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TMkP

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.337 ↑ 1.0 20 1

Limit (cost=0.56..9.38 rows=20 width=744) (actual time=0.269..0.337 rows=20 loops=1)

2. 0.331 0.331 ↑ 76,267.8 20 1

Index Scan using abrandl_test6 on projects (cost=0.56..672,759.71 rows=1,525,356 width=744) (actual time=0.267..0.331 rows=20 loops=1)

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