explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H833

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 1,685.504 ↑ 1.0 1 1

Finalize Aggregate (cost=33,211.57..33,211.58 rows=1 width=8) (actual time=1,685.504..1,685.504 rows=1 loops=1)

2. 233.709 1,685.556 ↓ 1.5 3 1

Gather (cost=33,211.35..33,211.56 rows=2 width=8) (actual time=1,685.493..1,685.556 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 4.789 1,451.847 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=32,211.35..32,211.36 rows=1 width=8) (actual time=1,451.847..1,451.847 rows=1 loops=3)

4. 587.406 1,447.058 ↓ 1.5 10,607 3 / 3

Hash Left Join (cost=21,682.35..32,193.35 rows=7,202 width=8) (actual time=503.693..1,447.058 rows=10,607 loops=3)

  • Hash Cond: (devicedata0_.production_device_id = production1_.id)
  • Filter: ((lower((devicemeta7_.device_name)::text) ~~ '%218%'::text) OR (lower((devicedata0_.eid)::text) ~~ '%218%'::text) OR (lower((production1_.common_name)::text) ~~ '%218%'::text) OR (lower((production1_.serial_number)::text) ~~ '%218%'::text))
  • Rows Removed by Filter: 38,946
5. 269.492 486.531 ↓ 1.0 49,553 3 / 3

Hash Left Join (cost=8,000.50..15,521.01 rows=47,804 width=72) (actual time=129.140..486.531 rows=49,553 loops=3)

  • Hash Cond: ((devicedata0_.eid)::text = (devicemeta7_.eid)::text)
6. 88.508 88.508 ↓ 1.0 49,553 3 / 3

Parallel Seq Scan on t_device devicedata0_ (cost=0.00..4,417.03 rows=47,804 width=86) (actual time=0.015..88.508 rows=49,553 loops=3)

  • Filter: ((next IS NULL) AND ((registration_time IS NOT NULL) OR (registration_time IS NULL)))
  • Rows Removed by Filter: 7,969
7. 81.130 128.531 ↑ 1.0 170,911 3 / 3

Hash (cost=4,194.11..4,194.11 rows=170,911 width=56) (actual time=128.530..128.531 rows=170,911 loops=3)

  • Buckets: 65,536 Batches: 8 Memory Usage: 2,362kB
8. 47.401 47.401 ↑ 1.0 170,911 3 / 3

Seq Scan on t_device_metadata devicemeta7_ (cost=0.00..4,194.11 rows=170,911 width=56) (actual time=0.027..47.401 rows=170,911 loops=3)

9. 183.231 373.121 ↑ 1.0 148,660 3 / 3

Hash (cost=10,080.60..10,080.60 rows=148,660 width=67) (actual time=373.121..373.121 rows=148,660 loops=3)

  • Buckets: 65,536 Batches: 8 Memory Usage: 1,872kB
10. 189.890 189.890 ↑ 1.0 148,660 3 / 3

Seq Scan on t_production_device production1_ (cost=0.00..10,080.60 rows=148,660 width=67) (actual time=0.070..189.890 rows=148,660 loops=3)

Planning time : 0.788 ms
Execution time : 1,685.667 ms