explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yggz

Settings
# exclusive inclusive rows x rows loops node
1. 207.553 6,724.660 ↓ 2.8 20,749 1

Hash Join (cost=8,415.19..632,380.47 rows=7,364 width=464) (actual time=20.814..6,724.660 rows=20,749 loops=1)

  • Hash Cond: (nodes.product_id = products.id)
2. 7.497 6,516.377 ↓ 2.8 20,749 1

Nested Loop (cost=8,335.51..631,730.08 rows=7,364 width=465) (actual time=20.005..6,516.377 rows=20,749 loops=1)

3. 12.138 6,446.633 ↓ 2.8 20,749 1

Nested Loop (cost=8,335.08..622,909.81 rows=7,364 width=473) (actual time=19.986..6,446.633 rows=20,749 loops=1)

4. 1,805.404 4,567.085 ↑ 1.2 20,749 1

Hash Join (cost=8,334.65..576,668.99 rows=23,944 width=85) (actual time=19.968..4,567.085 rows=20,749 loops=1)

  • Hash Cond: (nodes.network_id = node_groups.id)
5. 2,741.819 2,741.819 ↓ 1.0 10,266,262 1

Seq Scan on nodes (cost=0.00..439,831.62 rows=10,261,062 width=69) (actual time=0.014..2,741.819 rows=10,266,262 loops=1)

6. 1.233 19.862 ↓ 1.1 8,935 1

Hash (cost=8,233.29..8,233.29 rows=8,109 width=16) (actual time=19.862..19.862 rows=8,935 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 419kB
7. 18.629 18.629 ↓ 1.1 8,935 1

Index Scan using node_groups_organization_id_id_index on node_groups (cost=0.43..8,233.29 rows=8,109 width=16) (actual time=0.060..18.629 rows=8,935 loops=1)

  • Index Cond: (organization_id = 600667600300540438::bigint)
8. 1,867.410 1,867.410 ↑ 1.0 1 20,749

Index Scan using node_stats_pkey on node_stats (cost=0.43..1.92 rows=1 width=396) (actual time=0.009..0.090 rows=1 loops=20,749)

  • Index Cond: (id = nodes.id)
9. 62.247 62.247 ↑ 1.0 1 20,749

Index Only Scan using node_groups_pkey on node_groups node_groups_nodes (cost=0.43..1.19 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=20,749)

  • Index Cond: (id = nodes.network_id)
  • Heap Fetches: 384
10. 0.196 0.730 ↑ 1.0 1,497 1

Hash (cost=60.97..60.97 rows=1,497 width=15) (actual time=0.730..0.730 rows=1,497 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 62kB
11. 0.534 0.534 ↑ 1.0 1,497 1

Seq Scan on products (cost=0.00..60.97 rows=1,497 width=15) (actual time=0.006..0.534 rows=1,497 loops=1)

Planning time : 3.037 ms
Execution time : 6,726.650 ms