explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fzkPj

Settings
# exclusive inclusive rows x rows loops node
1. 1,326.888 5,314.501 ↑ 1.0 3,205,528 1

Hash Join (cost=59.26..100,132.04 rows=3,205,528 width=860) (actual time=0.894..5,314.501 rows=3,205,528 loops=1)

  • Hash Cond: (ports.p_nl_id = nodeslogical.nl_id)
2. 1,392.168 3,987.105 ↑ 1.0 3,205,528 1

Hash Join (cost=28.19..75,618.83 rows=3,205,528 width=838) (actual time=0.377..3,987.105 rows=3,205,528 loops=1)

  • Hash Cond: (induscommcontrollers.ic_p_id = ports.p_id)
3. 2,129.056 2,594.699 ↑ 1.0 3,205,528 1

Hash Join (cost=8.28..67,126.71 rows=3,205,528 width=838) (actual time=0.134..2,594.699 rows=3,205,528 loops=1)

  • Hash Cond: (induscommcontrollersdata.icd_p_id = induscommcontrollers.ic_p_id)
4. 465.527 465.527 ↑ 1.0 3,205,528 1

Seq Scan on induscommcontrollersdata (cost=0.00..58,078.28 rows=3,205,528 width=22) (actual time=0.006..465.527 rows=3,205,528 loops=1)

5. 0.058 0.116 ↑ 1.0 57 1

Hash (cost=7.57..7.57 rows=57 width=816) (actual time=0.116..0.116 rows=57 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
6. 0.058 0.058 ↑ 1.0 57 1

Seq Scan on induscommcontrollers (cost=0.00..7.57 rows=57 width=816) (actual time=0.006..0.058 rows=57 loops=1)

7. 0.118 0.238 ↑ 1.0 618 1

Hash (cost=12.18..12.18 rows=618 width=8) (actual time=0.238..0.238 rows=618 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
8. 0.120 0.120 ↑ 1.0 618 1

Seq Scan on ports (cost=0.00..12.18 rows=618 width=8) (actual time=0.006..0.120 rows=618 loops=1)

9. 0.226 0.508 ↑ 1.0 892 1

Hash (cost=19.92..19.92 rows=892 width=26) (actual time=0.508..0.508 rows=892 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 61kB
10. 0.282 0.282 ↑ 1.0 892 1

Seq Scan on nodeslogical (cost=0.00..19.92 rows=892 width=26) (actual time=0.013..0.282 rows=892 loops=1)

Planning time : 1.213 ms
Execution time : 5,528.552 ms