explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W7ku

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Subquery Scan on x2 (cost=1,580,826.59..1,580,826.61 rows=1 width=45) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=1,580,826.59..1,580,826.60 rows=1 width=46) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=1,580,826.59..1,580,826.59 rows=1 width=46) (actual rows= loops=)

  • Sort Key: x7.name, x7.uuid, x7.code, x7.number_code, ((x8.parse_error_type IS NOT NULL))
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20,698.85..1,580,826.58 rows=1 width=46) (actual rows= loops=)

  • Join Filter: (x8.manufacture_id = x7.number_code)
5. 0.000 0.000 ↓ 0.0

Gather (cost=20,698.85..1,580,796.73 rows=1 width=8) (actual rows= loops=)

  • Workers Planned: 2
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=19,698.85..1,579,796.63 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((x8.meter_serial = x12.meter_serial) AND (x11.uuid = x12.gateway_id) AND (x8.drt_count = x12.drt_count))
  • Filter: (x12.uuid IS NULL)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=19,403.32..1,552,221.81 rows=3,464,035 width=32) (actual rows= loops=)

  • Hash Cond: (x10.gateway_id = x11.uuid)
8. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=19,398.50..1,542,648.13 rows=3,464,035 width=32) (actual rows= loops=)

  • Hash Cond: (x8.file_id = x10.uuid)
9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on frames x8 (cost=0.00..1,466,068.38 rows=3,464,035 width=32) (actual rows= loops=)

  • Filter: ((parse_error_type IS NULL) AND ((parse_error_type IS NULL) OR (parse_error_type <> 2)))
10. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=17,340.22..17,340.22 rows=106,422 width=32) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on files x10 (cost=0.00..17,340.22 rows=106,422 width=32) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=3.81..3.81 rows=81 width=16) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on gateways x11 (cost=0.00..3.81 rows=81 width=16) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash (cost=159.01..159.01 rows=7,801 width=40) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on meter_templates x12 (cost=0.00..159.01 rows=7,801 width=40) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on manufacturers x7 (cost=0.00..18.82 rows=882 width=45) (actual rows= loops=)