explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4VK8

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1,624.685 ↓ 0.0 0 1

Limit (cost=12,652.97..12,652.97 rows=1 width=76) (actual time=1,624.685..1,624.685 rows=0 loops=1)

2. 0.011 1,624.684 ↓ 0.0 0 1

Sort (cost=12,652.97..12,652.97 rows=1 width=76) (actual time=1,624.684..1,624.684 rows=0 loops=1)

  • Sort Key: dvir_driverdvir.id
  • Sort Method: quicksort Memory: 25kB
3. 0.001 1,624.673 ↓ 0.0 0 1

Nested Loop (cost=2.23..12,652.96 rows=1 width=76) (actual time=1,624.673..1,624.673 rows=0 loops=1)

4. 0.039 1,624.672 ↓ 0.0 0 1

Nested Loop (cost=1.15..12,650.85 rows=1 width=76) (actual time=1,624.672..1,624.672 rows=0 loops=1)

5. 0.474 1,622.203 ↓ 11.2 90 1

Nested Loop (cost=0.72..12,631.92 rows=8 width=4) (actual time=845.106..1,622.203 rows=90 loops=1)

6. 0.348 4.069 ↓ 2.1 495 1

Nested Loop (cost=0.29..137.00 rows=234 width=4) (actual time=0.272..4.069 rows=495 loops=1)

7. 0.083 0.083 ↑ 1.0 1 1

Seq Scan on dvir_inspectionpoint (cost=0.00..1.83 rows=1 width=4) (actual time=0.074..0.083 rows=1 loops=1)

  • Filter: ((name)::text = 'Vehicle ID'::text)
  • Rows Removed by Filter: 65
8. 3.638 3.638 ↓ 2.1 495 1

Index Scan using dvir_customerdvirinspectionpoint_4bea308e on dvir_customerdvirinspectionpoint (cost=0.29..132.84 rows=234 width=8) (actual time=0.193..3.638 rows=495 loops=1)

  • Index Cond: (inspection_point_id = dvir_inspectionpoint.id)
9. 1,617.660 1,617.660 ↓ 0.0 0 495

Index Scan using dvir_driverdvirvalue_4bea308e on dvir_driverdvirvalue (cost=0.43..53.39 rows=1 width=8) (actual time=3.244..3.268 rows=0 loops=495)

  • Index Cond: (inspection_point_id = dvir_customerdvirinspectionpoint.id)
  • Filter: ((value)::text = '411701'::text)
  • Rows Removed by Filter: 1025
10. 2.430 2.430 ↓ 0.0 0 90

Index Scan using dvir_driverdvir_pkey on dvir_driverdvir (cost=0.43..2.36 rows=1 width=76) (actual time=0.027..0.027 rows=0 loops=90)

  • Index Cond: (id = dvir_driverdvirvalue.driver_dvir_id)
  • Filter: ((timezone('US/Eastern'::text, dt))::date = '2019-07-10'::date)
  • Rows Removed by Filter: 1
11. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on logistics_driver (cost=1.08..2.10 rows=1 width=4) (never executed)

  • Recheck Cond: (id = dvir_driverdvir.driver_id)
  • Filter: (customer_id = 257)