explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JhJa : mrking

Settings
# exclusive inclusive rows x rows loops node
1. 4.515 7,498.718 ↓ 1.4 20,749 1

Unique (cost=606,555.59..606,628.62 rows=14,606 width=90) (actual time=7,492.008..7,498.718 rows=20,749 loops=1)

2. 15.853 7,494.203 ↓ 1.4 20,760 1

Sort (cost=606,555.59..606,592.10 rows=14,606 width=90) (actual time=7,491.999..7,494.203 rows=20,760 loops=1)

  • Sort Key: nodes.id
  • Sort Method: quicksort Memory: 3689kB
3. 21.547 7,478.350 ↓ 1.4 20,760 1

Nested Loop Left Join (cost=1,973.67..605,545.27 rows=14,606 width=90) (actual time=40.560..7,478.350 rows=20,760 loops=1)

4. 26.009 4,986.363 ↓ 1.4 20,760 1

Hash Left Join (cost=1,973.24..579,861.21 rows=14,606 width=76) (actual time=40.467..4,986.363 rows=20,760 loops=1)

  • Hash Cond: (nodes.id = node_claim_records.node_id)
5. 10.347 4,942.801 ↓ 1.4 20,760 1

Hash Join (cost=429.02..577,915.03 rows=14,606 width=68) (actual time=22.881..4,942.801 rows=20,760 loops=1)

  • Hash Cond: (nodes.product_id = products.id)
6. 28.055 4,931.293 ↓ 1.4 20,760 1

Nested Loop Left Join (cost=349.34..577,634.52 rows=14,606 width=69) (actual time=21.693..4,931.293 rows=20,760 loops=1)

  • Filter: ((store_order_serials.document_number IS NULL) OR (((store_order_serials.document_number)::text !~~ '4R%'::text) AND ((store_order_serials.document_number)::text !~~ 'RTN%'::text) AND ((store_order_serials.document_number)::text !~~ 'RTC%'::text)))
  • Rows Removed by Filter: 11
7. 1,586.980 4,633.501 ↓ 1.3 20,749 1

Hash Join (cost=348.91..549,741.17 rows=15,634 width=69) (actual time=21.649..4,633.501 rows=20,749 loops=1)

  • Hash Cond: (nodes.network_id = node_groups.id)
8. 3,037.048 3,037.048 ↓ 1.0 6,749,423 1

Seq Scan on nodes (cost=0.00..465,484.28 rows=6,700,132 width=69) (actual time=0.041..3,037.048 rows=6,749,423 loops=1)

  • Filter: (network_id <> 31)
  • Rows Removed by Filter: 3516839
9. 2.166 9.473 ↓ 1.1 8,935 1

Hash (cost=247.54..247.54 rows=8,109 width=8) (actual time=9.473..9.473 rows=8,935 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 350kB
10. 7.307 7.307 ↓ 1.1 8,935 1

Index Only Scan using node_groups_organization_id_id_index on node_groups (cost=0.43..247.54 rows=8,109 width=8) (actual time=0.078..7.307 rows=8,935 loops=1)

  • Index Cond: (organization_id = 600667600300540438::bigint)
  • Filter: (id <> 31)
  • Heap Fetches: 111
11. 269.737 269.737 ↑ 1.0 1 20,749

Index Scan using store_order_serials_serial_index on store_order_serials (cost=0.43..1.77 rows=1 width=25) (actual time=0.013..0.013 rows=1 loops=20,749)

  • Index Cond: ((serial)::text = (nodes.serial)::text)
12. 0.327 1.161 ↑ 1.0 1,497 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 62kB
13. 0.834 0.834 ↑ 1.0 1,497 1

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

14. 5.680 17.553 ↑ 1.0 21,087 1

Hash (cost=1,280.21..1,280.21 rows=21,120 width=16) (actual time=17.553..17.553 rows=21,087 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 989kB
15. 11.873 11.873 ↑ 1.0 21,087 1

Seq Scan on node_claim_records (cost=0.00..1,280.21 rows=21,120 width=16) (actual time=0.015..11.873 rows=21,087 loops=1)

  • Filter: (organization_id = 600667600300540438::bigint)
  • Rows Removed by Filter: 18610
16. 2,470.440 2,470.440 ↑ 1.0 1 20,760

Index Scan using node_stats_pkey on node_stats (cost=0.43..1.75 rows=1 width=22) (actual time=0.009..0.119 rows=1 loops=20,760)

  • Index Cond: (nodes.id = id)