explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OC2b

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

Limit (cost=0.90..91.98 rows=1,500 width=12) (actual time=0.173..0.175 rows=1 loops=1)

2.          

Initplan (for Limit)

3. 0.002 0.073 ↑ 1.0 1 1

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

4.          

Initplan (for Result)

5. 0.001 0.071 ↑ 1.0 1 1

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

6. 0.070 0.070 ↑ 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.070..0.070 rows=1 loops=1)

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

Index Scan using offer_p01_last_update_partition_id_idx on offer_p01 o (cost=0.43..127,916.89 rows=2,106,654 width=12) (actual time=0.172..0.173 rows=1 loops=1)

  • Index Cond: ((last_update < $1) AND (partition_id = 1))
Planning time : 0.470 ms
Execution time : 0.212 ms