explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j1VH

Settings
# exclusive inclusive rows x rows loops node
1. 0.083 68.182 ↑ 1.0 1 1

Aggregate (cost=4,238.94..4,238.95 rows=1 width=8) (actual time=68.182..68.182 rows=1 loops=1)

2. 2.280 68.099 ↓ 104.0 104 1

Nested Loop Left Join (cost=1.54..4,238.94 rows=1 width=37) (actual time=1.249..68.099 rows=104 loops=1)

  • Filter: (validhash3_.id IS NULL)
  • Rows Removed by Filter: 2,986
3. 2.500 31.829 ↓ 3.1 3,090 1

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

4. 0.309 1.356 ↓ 3.5 2,543 1

Nested Loop (cost=0.57..2,920.50 rows=728 width=37) (actual time=0.073..1.356 rows=2,543 loops=1)

5. 0.014 0.014 ↑ 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.014 rows=1 loops=1)

  • Index Cond: ((vat_number)::text = 'Vat Number for Test Account 799225'::text)
6. 1.033 1.033 ↑ 9.7 2,543 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.057..1.033 rows=2,543 loops=1)

  • Index Cond: ((plate_holder_id)::text = (plateholde2_.id)::text)
7. 27.973 27.973 ↑ 2.0 1 2,543

Index Scan using idx_registration_vehicle_id on tbl_registration registrati0_ (cost=0.42..0.80 rows=2 width=139) (actual time=0.011..0.011 rows=1 loops=2,543)

  • Index Cond: ((vehicle_id)::text = (vehicle1_.id)::text)
  • Filter: (inactivated_date_time IS NULL)
8. 33.990 33.990 ↑ 1.0 1 3,090

Index Scan using idx_valid_hash_file_id on tbl_processing_valid_hash validhash3_ (cost=0.55..0.72 rows=1 width=102) (actual time=0.011..0.011 rows=1 loops=3,090)

  • Index Cond: (((file_id)::text = '799225_31_2020-07-25-12-05-08'::text) AND ((registration_hash)::text = (registrati0_.registration_hash)::text))
Planning time : 1.353 ms
Execution time : 68.248 ms