explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UHmG

Settings
# exclusive inclusive rows x rows loops node
1. 23.070 303.616 ↓ 3.9 1,286 1

Gather (cost=1,004.90..29,672.70 rows=333 width=1,547) (actual time=1.407..303.616 rows=1,286 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.672 280.546 ↓ 3.1 429 3 / 3

Hash Join (cost=4.90..28,639.40 rows=139 width=1,547) (actual time=0.499..280.546 rows=429 loops=3)

  • Hash Cond: ((v.plate_holder_id)::text = (tph.id)::text)
3. 3.110 279.789 ↓ 3.1 429 3 / 3

Nested Loop (cost=0.84..28,634.94 rows=139 width=1,406) (actual time=0.344..279.789 rows=429 loops=3)

4. 2.174 270.224 ↓ 2.2 430 3 / 3

Nested Loop (cost=0.42..28,197.53 rows=192 width=740) (actual time=0.313..270.224 rows=430 loops=3)

5. 258.583 258.583 ↓ 2.2 430 3 / 3

Parallel Seq Scan on tbl_registration r2 (cost=0.00..26,663.87 rows=192 width=666) (actual time=0.272..258.583 rows=430 loops=3)

  • Filter: (last_modified_timestamp > to_date('20200624'::text, 'yyyymmdd'::text))
  • Rows Removed by Filter: 157,376
6. 9.467 9.467 ↑ 1.0 1 1,291 / 3

Index Scan using tbl_vehicle_pkey on tbl_vehicle v (cost=0.42..7.99 rows=1 width=74) (actual time=0.022..0.022 rows=1 loops=1,291)

  • Index Cond: ((id)::text = (r2.vehicle_id)::text)
7. 6.455 6.455 ↑ 1.0 1 1,291 / 3

Index Scan using idx_registration_vehicle_id on tbl_registration r (cost=0.42..2.27 rows=1 width=666) (actual time=0.015..0.015 rows=1 loops=1,291)

  • Index Cond: ((vehicle_id)::text = (v.id)::text)
  • Filter: (inactivated_date_time IS NULL)
  • Rows Removed by Filter: 0
8. 0.039 0.085 ↑ 1.0 47 3 / 3

Hash (cost=3.47..3.47 rows=47 width=141) (actual time=0.084..0.085 rows=47 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
9. 0.046 0.046 ↑ 1.0 47 3 / 3

Seq Scan on tbl_plate_holder tph (cost=0.00..3.47 rows=47 width=141) (actual time=0.018..0.046 rows=47 loops=3)

  • Filter: antai_enabled
Planning time : 1.177 ms
Execution time : 304.024 ms