explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xUg0u

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.016 ↑ 1.0 1 1

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

2. 0.001 0.014 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.54..3,538.34 rows=1 width=37) (actual time=0.014..0.014 rows=0 loops=1)

  • Join Filter: ((registrati0_.registration_hash)::text = (validhash3_.registration_hash)::text)
  • Filter: (validhash3_.id IS NULL)
3. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.99..3,514.98 rows=986 width=102) (actual time=0.013..0.013 rows=0 loops=1)

4. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.57..2,920.50 rows=728 width=37) (actual time=0.013..0.013 rows=0 loops=1)

5. 0.013 0.013 ↓ 0.0 0 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=0 loops=1)

  • Index Cond: ((vat_number)::text = 'bla'::text)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_vehicle_plateholder on tbl_vehicle vehicle1_ (cost=0.42..2,664.95 rows=24,739 width=44) (never executed)

  • Index Cond: ((plate_holder_id)::text = (plateholde2_.id)::text)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_registration_vehicle_id on tbl_registration registrati0_ (cost=0.42..0.80 rows=2 width=139) (never executed)

  • Index Cond: ((vehicle_id)::text = (vehicle1_.id)::text)
  • Filter: (inactivated_date_time IS NULL)
8. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.55..8.57 rows=1 width=102) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_valid_hash_file_id on tbl_processing_valid_hash validhash3_ (cost=0.55..8.56 rows=1 width=102) (never executed)

  • Index Cond: ((file_id)::text = 'bla'::text)
Planning time : 13.867 ms
Execution time : 0.126 ms