explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cmp : Optimization for: plan #ILV6

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.078 0.102 ↓ 15.0 15 1

Seq Scan on pspelement (cost=1.07..3.46 rows=1 width=137) (actual time=0.084..0.102 rows=15 loops=1)

  • Filter: (rights && $0)
  • Rows Removed by Filter: 16
2.          

Initplan (for Seq Scan)

3. 0.024 0.024 ↑ 1.0 1 1

Seq Scan on ehuelusers (cost=0.00..1.07 rows=1 width=32) (actual time=0.022..0.024 rows=1 loops=1)

  • Filter: (username = CURRENT_USER)
  • Rows Removed by Filter: 4
Planning time : 29.112 ms
Execution time : 0.287 ms