explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iGZt

Settings
# exclusive inclusive rows x rows loops node
1. 21.370 320.712 ↓ 7.6 1,286 1

Gather (cost=1,004.90..28,703.04 rows=169 width=1,547) (actual time=1.466..320.712 rows=1,286 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.667 299.342 ↓ 6.1 429 3 / 3

Hash Join (cost=4.90..27,686.14 rows=70 width=1,547) (actual time=0.277..299.342 rows=429 loops=3)

  • Hash Cond: ((v.plate_holder_id)::text = (tph.id)::text)
3. 0.649 298.604 ↓ 6.1 429 3 / 3

Nested Loop (cost=0.84..27,681.88 rows=70 width=1,406) (actual time=0.139..298.604 rows=429 loops=3)

4. 1.432 291.096 ↓ 4.4 429 3 / 3

Nested Loop (cost=0.42..27,460.90 rows=97 width=740) (actual time=0.105..291.096 rows=429 loops=3)

5. 274.232 274.232 ↓ 4.4 429 3 / 3

Parallel Seq Scan on tbl_registration r2 (cost=0.00..26,663.87 rows=97 width=666) (actual time=0.070..274.232 rows=429 loops=3)

  • Filter: ((inactivated_date_time IS NULL) AND (last_modified_timestamp > to_date('20200624'::text, 'yyyymmdd'::text)))
  • Rows Removed by Filter: 157,378
6. 15.432 15.432 ↑ 1.0 1 1,286 / 3

Index Scan using tbl_vehicle_pkey on tbl_vehicle v (cost=0.42..8.22 rows=1 width=74) (actual time=0.036..0.036 rows=1 loops=1,286)

  • Index Cond: ((id)::text = (r2.vehicle_id)::text)
7. 6.859 6.859 ↑ 1.0 1 1,286 / 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.016 rows=1 loops=1,286)

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

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

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

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

  • Filter: antai_enabled
Planning time : 1.116 ms
Execution time : 321.072 ms