explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d4s

Settings
# exclusive inclusive rows x rows loops node
1. 42.939 153.271 ↓ 2.0 8,680 1

Sort (cost=1,647.21..1,658.05 rows=4,337 width=490) (actual time=152.546..153.271 rows=8,680 loops=1)

  • Sort Key: pojazd.nr_rejestracyjny
  • Sort Method: quicksort Memory: 2509kB
2. 12.229 110.332 ↓ 2.0 8,680 1

Nested Loop (cost=15.58..1,385.20 rows=4,337 width=490) (actual time=43.669..110.332 rows=8,680 loops=1)

3. 6.600 46.023 ↓ 43.4 8,680 1

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual time=43.629..46.023 rows=8,680 loops=1)

  • Group Key: get_user_vehicles_temp.get_user_vehicles_temp
4. 39.423 39.423 ↓ 8.7 8,680 1

Function Scan on get_user_vehicles_temp (cost=0.25..10.25 rows=1,000 width=4) (actual time=38.342..39.423 rows=8,680 loops=1)

5. 26.040 52.080 ↑ 1.0 1 8,680

Bitmap Heap Scan on pojazd (cost=2.83..6.84 rows=1 width=490) (actual time=0.006..0.006 rows=1 loops=8,680)

  • Recheck Cond: (pojazd_id = get_user_vehicles_temp.get_user_vehicles_temp)
  • Heap Blocks: exact=8680
6. 26.040 26.040 ↑ 1.0 1 8,680

Bitmap Index Scan on pojazd_pkey (cost=0.00..2.83 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=8,680)

  • Index Cond: (pojazd_id = get_user_vehicles_temp.get_user_vehicles_temp)
Planning time : 0.556 ms
Execution time : 154.247 ms