explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U39T

Settings
# exclusive inclusive rows x rows loops node
1. 9.868 4,500.262 ↑ 403.5 34,053 1

Unique (cost=3,184,855,759.23..3,189,573,930.92 rows=13,741,451 width=70) (actual time=4,486.093..4,500.262 rows=34,053 loops=1)

2. 18.140 4,490.394 ↑ 11,084.3 34,053 1

Sort (cost=3,184,855,759.23..3,185,799,393.57 rows=377,453,735 width=70) (actual time=4,486.092..4,490.394 rows=34,053 loops=1)

  • Sort Key: a1.customer_network_id, a1.id, a1.customer_id, a1.customer_network_path
  • Sort Method: external merge Disk: 2,736kB
3. 2,120.079 4,472.254 ↑ 11,084.3 34,053 1

Gather (cost=1,000.00..3,069,158,215.93 rows=377,453,735 width=70) (actual time=0.299..4,472.254 rows=34,053 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 1,100.104 2,352.175 ↑ 13,855.4 11,351 3 / 3

Nested Loop (cost=0.00..3,031,411,842.43 rows=157,272,390 width=70) (actual time=862.372..2,352.175 rows=11,351 loops=3)

  • Join Filter: ((a1.customer_network_path <@ path.customer_network_path) OR (a1.customer_network_path @> path.customer_network_path))
  • Rows Removed by Join Filter: 4,571,249
5. 862.413 862.413 ↓ 0.0 0 3 / 3

Parallel Seq Scan on customer_network_ltree path (cost=0.00..257,493.06 rows=5,725 width=46) (actual time=862.369..862.413 rows=0 loops=3)

  • Filter: (customer_network_path ~ '*.1'::lquery)
  • Rows Removed by Filter: 4,582,600
6. 389.658 389.658 ↓ 1.0 13,747,800 1 / 3

Seq Scan on customer_network_ltree a1 (cost=0.00..323,337.51 rows=13,741,451 width=70) (actual time=0.002..1,168.974 rows=13,747,800 loops=1)