explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hcgm

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 54.973 ↓ 0.0 0 1

Limit (cost=1,000.90..118,823.07 rows=1 width=12) (actual time=54.973..54.973 rows=0 loops=1)

2.          

Initplan (for Limit)

3. 0.001 0.025 ↑ 1.0 1 1

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

4.          

Initplan (for Result)

5. 0.001 0.024 ↑ 1.0 1 1

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

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

  • Index Cond: (last_update IS NOT NULL)
  • Heap Fetches: 0
7. 68.963 68.973 ↓ 0.0 0 1

Gather (cost=1,000.43..118,822.60 rows=1 width=12) (actual time=54.972..68.973 rows=0 loops=1)

  • Workers Planned: 2
  • Params Evaluated: $1
  • Workers Launched: 2
8. 0.010 0.010 ↓ 0.0 0 3 / 3

Parallel Index Scan using offer_p01_last_update_partition_id_idx on offer_p01 o (cost=0.43..117,822.50 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=3)

  • Index Cond: ((last_update < $1) AND (partition_id = 1))
  • Filter: (state <> 'FINISHED'::offer_state)
  • Rows Removed by Filter: 0
Planning time : 0.363 ms
Execution time : 69.014 ms