explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gTQG

Settings
# exclusive inclusive rows x rows loops node
1. 45.632 124.888 ↓ 1.0 8,680 1

Sort (cost=39,474.05..39,495.74 rows=8,674 width=490) (actual time=123.889..124.888 rows=8,680 loops=1)

  • Sort Key: pojazd.nr_rejestracyjny
  • Sort Method: quicksort Memory: 2509kB
2. 9.670 79.256 ↓ 1.0 8,680 1

Hash Semi Join (cost=2,527.18..36,978.17 rows=8,674 width=490) (actual time=31.965..79.256 rows=8,680 loops=1)

  • Hash Cond: (pojazd.pojazd_id = grupa_pojazdow_pojazd.pojazd_id)
3. 37.661 37.661 ↓ 1.0 8,701 1

Index Scan using pojazd_pkey on pojazd (cost=0.41..34,245.39 rows=8,674 width=490) (actual time=0.018..37.661 rows=8,701 loops=1)

4. 2.532 31.925 ↑ 1.0 8,680 1

Hash (cost=2,417.47..2,417.47 rows=8,744 width=8) (actual time=31.925..31.925 rows=8,680 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 340kB
5. 7.820 29.393 ↑ 1.0 8,680 1

HashAggregate (cost=2,242.59..2,330.03 rows=8,744 width=8) (actual time=27.374..29.393 rows=8,680 loops=1)

  • Group Key: grupa_pojazdow_pojazd.pojazd_id
6. 8.486 21.573 ↑ 1.2 16,350 1

Merge Join (cost=1,185.73..2,193.89 rows=19,480 width=8) (actual time=4.894..21.573 rows=16,350 loops=1)

  • Merge Cond: (grupa_pojazdow_pojazd.grupa_pojazdow_id = auser_grupa_pojazdow.grupa_pojazdow_id)
7. 6.796 6.796 ↑ 1.0 16,350 1

Index Scan using grupa_pojazdow_pojazd_grupa_pojazdow_id on grupa_pojazdow_pojazd (cost=0.29..675.37 rows=16,504 width=16) (actual time=0.027..6.796 rows=16,350 loops=1)

8. 2.144 6.291 ↓ 8.1 16,743 1

Sort (cost=1,185.44..1,190.59 rows=2,059 width=4) (actual time=4.863..6.291 rows=16,743 loops=1)

  • Sort Key: auser_grupa_pojazdow.grupa_pojazdow_id
  • Sort Method: quicksort Memory: 139kB
9. 3.771 4.147 ↑ 1.1 1,926 1

Bitmap Heap Scan on auser_grupa_pojazdow (cost=40.38..1,072.11 rows=2,059 width=4) (actual time=0.456..4.147 rows=1,926 loops=1)

  • Recheck Cond: (auser_id = 1)
  • Heap Blocks: exact=395
10. 0.376 0.376 ↑ 1.1 1,926 1

Bitmap Index Scan on auser_grupa_pojazdow_user_id_x (cost=0.00..39.86 rows=2,059 width=0) (actual time=0.376..0.376 rows=1,926 loops=1)

  • Index Cond: (auser_id = 1)