explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M8LM

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.035 ↑ 1.0 1 1

Result (cost=0.46..0.47 rows=1 width=8) (actual time=0.035..0.035 rows=1 loops=1)

2.          

Initplan (for Result)

3. 0.001 0.032 ↑ 1.0 1 1

Limit (cost=0.43..0.46 rows=1 width=8) (actual time=0.032..0.032 rows=1 loops=1)

4. 0.031 0.031 ↑ 9,929,946.0 1 1

Index Only Scan using test on global_restriction g (cost=0.43..203,727.49 rows=9,929,946 width=8) (actual time=0.031..0.031 rows=1 loops=1)

  • Index Cond: (last_update IS NOT NULL)
  • Heap Fetches: 0
Planning time : 0.154 ms
Execution time : 0.068 ms