explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 74yB

Settings
# exclusive inclusive rows x rows loops node
1. 0.778 22,306.605 ↑ 1.0 1 1

Aggregate (cost=3,538.34..3,538.35 rows=1 width=8) (actual time=22,306.605..22,306.605 rows=1 loops=1)

2. 15,730.000 22,305.827 ↓ 567.0 567 1

Nested Loop Left Join (cost=1.54..3,538.34 rows=1 width=37) (actual time=21.916..22,305.827 rows=567 loops=1)

  • Join Filter: ((registrati0_.registration_hash)::text = (validhash3_.registration_hash)::text)
  • Rows Removed by Join Filter: 159,512,600
  • Filter: (validhash3_.id IS NULL)
  • Rows Removed by Filter: 12,350
3. 24.982 233.580 ↓ 13.1 12,917 1

Nested Loop (cost=0.99..3,514.98 rows=986 width=102) (actual time=0.097..233.580 rows=12,917 loops=1)

4. 5.307 18.358 ↓ 13.1 9,512 1

Nested Loop (cost=0.57..2,920.50 rows=728 width=37) (actual time=0.074..18.358 rows=9,512 loops=1)

5. 0.013 0.013 ↑ 1.0 1 1

Index Scan using idx_plateholder_vatnumber on tbl_plate_holder plateholde2_ (cost=0.15..8.17 rows=1 width=32) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: ((vat_number)::text = 'Vat Number for Test Account 799220'::text)
6. 13.038 13.038 ↑ 2.6 9,512 1

Index Scan using idx_vehicle_plateholder on tbl_vehicle vehicle1_ (cost=0.42..2,664.95 rows=24,739 width=44) (actual time=0.059..13.038 rows=9,512 loops=1)

  • Index Cond: ((plate_holder_id)::text = (plateholde2_.id)::text)
7. 190.240 190.240 ↑ 2.0 1 9,512

Index Scan using idx_registration_vehicle_id on tbl_registration registrati0_ (cost=0.42..0.80 rows=2 width=139) (actual time=0.017..0.020 rows=1 loops=9,512)

  • Index Cond: ((vehicle_id)::text = (vehicle1_.id)::text)
  • Filter: (inactivated_date_time IS NULL)
8. 6,328.938 6,342.247 ↓ 12,350.0 12,350 12,917

Materialize (cost=0.55..8.57 rows=1 width=102) (actual time=0.000..0.491 rows=12,350 loops=12,917)

9. 13.309 13.309 ↓ 12,350.0 12,350 1

Index Scan using idx_valid_hash_file_id on tbl_processing_valid_hash validhash3_ (cost=0.55..8.56 rows=1 width=102) (actual time=0.020..13.309 rows=12,350 loops=1)

  • Index Cond: ((file_id)::text = '799220_42_2020-07-25-12-05-56'::text)
Planning time : 1.191 ms
Execution time : 22,307.054 ms