explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RPha

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,093.331 ↑ 1,500.0 1 1

Limit (cost=0.47..149.78 rows=1,500 width=12) (actual time=0.070..1,093.331 rows=1 loops=1)

2.          

Initplan (for Limit)

3. 0.001 0.027 ↑ 1.0 1 1

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

4.          

Initplan (for Result)

5. 0.001 0.026 ↑ 1.0 1 1

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

6. 0.025 0.025 ↑ 9,929,946.0 1 1

Index Only Scan Backward using global_restriction_uidx on global_restriction g (cost=0.43..213,375.59 rows=9,929,946 width=8) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: (last_update IS NOT NULL)
  • Heap Fetches: 0
7. 1,093.330 1,093.330 ↑ 2,106,702.0 1 1

Seq Scan on offer_p01 o (cost=0.00..209,712.58 rows=2,106,702 width=12) (actual time=0.069..1,093.330 rows=1 loops=1)

  • Filter: ((last_update < $1) AND (partition_id = 1))
  • Rows Removed by Filter: 6,320,067
Planning time : 0.400 ms
Execution time : 1,093.403 ms