explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Eifz

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 146,237.536 ↓ 0.0 0 1

Limit (cost=1.30..198,618.03 rows=20 width=207) (actual time=146,237.536..146,237.536 rows=0 loops=1)

2. 0.014 146,237.534 ↓ 0.0 0 1

GroupAggregate (cost=1.30..14,389,783.70 rows=1,449 width=207) (actual time=146,237.534..146,237.534 rows=0 loops=1)

  • Group Key: grants.id
3. 0.004 146,237.520 ↓ 0.0 0 1

Nested Loop (cost=1.30..14,385,045.47 rows=1,449 width=141) (actual time=146,237.520..146,237.520 rows=0 loops=1)

  • Join Filter: (grants."benefitId" = benefits.id)
4. 0.001 146,237.516 ↓ 0.0 0 1

Nested Loop (cost=1.30..14,384,756.97 rows=2,535 width=66) (actual time=146,237.516..146,237.516 rows=0 loops=1)

5. 14,501.312 146,237.515 ↓ 0.0 0 1

Nested Loop (cost=0.87..14,383,401.71 rows=3,000 width=28) (actual time=146,237.515..146,237.515 rows=0 loops=1)

6. 101,660.513 101,660.513 ↓ 1.0 30,075,690 1

Index Scan Backward using "grantToVehicle_grantId" on "grantToVehicle" gtov (cost=0.44..757,120.79 rows=30,015,757 width=17) (actual time=0.053..101,660.513 rows=30,075,690 loops=1)

7. 30,075.690 30,075.690 ↓ 0.0 0 30,075,690

Index Scan using vehicles_pkey on vehicles (cost=0.43..0.45 rows=1 width=19) (actual time=0.001..0.001 rows=0 loops=30,075,690)

  • Index Cond: (id = gtov."vehicleId")
  • Filter: (vrp ~~ '%A123AA45%'::text)
  • Rows Removed by Filter: 1
8. 0.000 0.000 ↓ 0.0 0

Index Scan using grants_pkey on grants (cost=0.43..0.45 rows=1 width=42) (never executed)

  • Index Cond: (id = gtov."grantId")
  • Filter: (("end" <= '1599479501990'::bigint) OR ("deleteDate" IS NOT NULL))
9. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.22 rows=8 width=79) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Seq Scan on benefits (cost=0.00..1.18 rows=8 width=79) (never executed)

  • Filter: (target = 'benefits'::text)
Planning time : 0.953 ms
Execution time : 146,237.755 ms