explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JUsA

Settings
# exclusive inclusive rows x rows loops node
1. 1.439 2,604.792 ↑ 1.4 604 1

Unique (cost=211,718.37..211,779.13 rows=838 width=376) (actual time=2,603.247..2,604.792 rows=604 loops=1)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, mc.email, mc.status, m.description, m.licensetype, slp.startdate, lp.license_id, lp.partner_id, lp.enddate, lp.created, pfu.productfeature_id, pfu.unitcount, prodpack.pricingplanmodel, prodpack.key, prodpack.description, prodpack.producttype, prodpack.addon, prodpackparent.key, prodpackparent.description, pf.featurekey, pfu.starter, ((pricingplan.monthsvalid = 12)), (CASE WHEN (lp.partner_id = 1,652,472) THEN true ELSE false END), (CASE WHEN ((prodpack.key)::text = 'atlassian.cloud'::text) THEN (((SubPlan 1) > 0) AND ((SubPlan 2) = (SubPlan 3))) ELSE false END)
2. 13.387 2,603.353 ↓ 2.8 2,328 1

Sort (cost=211,718.37..211,720.47 rows=838 width=376) (actual time=2,603.246..2,603.353 rows=2,328 loops=1)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, mc.email, mc.status, m.description, m.licensetype, slp.startdate, lp.license_id, lp.partner_id, lp.enddate, lp.created, pfu.productfeature_id, pfu.unitcount, prodpack.pricingplanmodel, prodpack.key, prodpack.description, prodpack.producttype, prodpack.addon, prodpackparent.key, prodpackparent.description, pf.featurekey, pfu.starter, ((pricingplan.monthsvalid = 12)), (CASE WHEN (lp.partner_id = 1,652,472) THEN true ELSE false END), (CASE WHEN ((prodpack.key)::text = 'atlassian.cloud'::text) THEN (((SubPlan 1) > 0) AND ((SubPlan 2) = (SubPlan 3))) ELSE false END)
  • Sort Key: (CASE WHEN (lp.partner_id = 1,652,472) THEN true ELSE false END) DESC, lp.created DESC, a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, mc.email, mc.status, m.description, m.licensetype, slp.startdate, lp.license_id, lp.partner_id, lp.enddate, pfu.productfeature_id, pfu.unitcount, prodpack.pricingplanmodel, prodpack.key, prodpack.description, prodpack.producttype, prodpack.addon, prodpackparent.key, prodpackparent.description, pf.featurekey, pfu.starter, ((pricingplan.monthsvalid = 12)), (CASE WHEN ((prodpack.key)::text = 'atlassian.cloud'::text) THEN (((SubPlan 1) > 0) AND ((SubPlan 2) = (SubPlan 3))) ELSE false END)
  • Sort Method: quicksort Memory: 1,109kB
3. 0.000 2,589.966 ↓ 2.8 2,328 1

Gather (cost=5,958.68..211,677.68 rows=838 width=376) (actual time=37.399..2,589.966 rows=2,328 loops=1)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, mc.email, mc.status, m.description, m.licensetype, slp.startdate, lp.license_id, lp.partner_id, lp.enddate, lp.created, pfu.productfeature_id, pfu.unitcount, prodpack.pricingplanmodel, prodpack.key, prodpack.description, prodpack.producttype, prodpack.addon, prodpackparent.key, prodpackparent.description, pf.featurekey, pfu.starter, (pricingplan.monthsvalid = 12), CASE WHEN (lp.partner_id = 1,652,472) THEN true ELSE false END, CASE WHEN ((prodpack.key)::text = 'atlassian.cloud'::text) THEN (((SubPlan 1) > 0) AND ((SubPlan 2) = (SubPlan 3))) ELSE false END
  • Workers Planned: 1
  • Workers Launched: 1
4. 0.237 72.925 ↓ 2.4 1,164 2 / 2

Nested Loop Left Join (cost=4,958.68..74,608.91 rows=493 width=377) (actual time=35.775..72.925 rows=1,164 loops=2)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, lp.license_id, lp.partner_id, lp.enddate, lp.created, slp.startdate, m.description, m.licensetype, prodpack.pricingplanmodel, prodpack.key, prodpack.description, prodpack.producttype, prodpack.addon, prodpackparent.key, prodpackparent.description, pricingplan.monthsvalid, pfu.productfeature_id, pfu.unitcount, pfu.starter, pf.featurekey, mc.email, mc.status
  • Inner Unique: true
  • Worker 0: actual time=35.328..109.435 rows=2,324 loops=1
5. 0.148 70.360 ↓ 2.4 1,164 2 / 2

Nested Loop Left Join (cost=4,958.24..71,941.60 rows=493 width=354) (actual time=35.762..70.360 rows=1,164 loops=2)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, lp.license_id, lp.partner_id, lp.enddate, lp.created, slp.startdate, m.description, m.licensetype, prodpack.pricingplanmodel, prodpack.key, prodpack.description, prodpack.producttype, prodpack.addon, prodpackparent.key, prodpackparent.description, pricingplan.monthsvalid, pfu.productfeature_id, pfu.unitcount, pfu.starter, pf.featurekey, mcr.contact_id
  • Inner Unique: true
  • Worker 0: actual time=35.315..104.328 rows=2,324 loops=1
6. 0.434 65.556 ↓ 2.4 1,164 2 / 2

Hash Left Join (cost=4,957.68..70,701.83 rows=493 width=346) (actual time=35.748..65.556 rows=1,164 loops=2)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, lp.license_id, lp.partner_id, lp.enddate, lp.created, slp.startdate, m.description, m.licensetype, prodpack.pricingplanmodel, prodpack.key, prodpack.description, prodpack.producttype, prodpack.addon, prodpackparent.key, prodpackparent.description, pricingplan.monthsvalid, pfu.productfeature_id, pfu.unitcount, pfu.starter, pf.featurekey
  • Inner Unique: true
  • Hash Cond: (pfu.productfeature_id = pf.id)
  • Worker 0: actual time=35.300..94.747 rows=2,324 loops=1
7. 0.974 63.893 ↓ 2.4 1,164 2 / 2

Nested Loop Left Join (cost=4,794.42..70,537.27 rows=493 width=336) (actual time=34.472..63.893 rows=1,164 loops=2)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, lp.license_id, lp.partner_id, lp.enddate, lp.created, slp.startdate, m.description, m.licensetype, prodpack.pricingplanmodel, prodpack.key, prodpack.description, prodpack.producttype, prodpack.addon, prodpackparent.key, prodpackparent.description, pricingplan.monthsvalid, pfu.productfeature_id, pfu.unitcount, pfu.starter
  • Inner Unique: true
  • Worker 0: actual time=34.028..92.703 rows=2,324 loops=1
8. 0.620 60.591 ↓ 2.4 1,164 2 / 2

Hash Left Join (cost=4,793.85..67,743.06 rows=493 width=331) (actual time=34.456..60.591 rows=1,164 loops=2)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, lp.license_id, lp.partner_id, lp.enddate, lp.created, lp.productfeatureusage_id, slp.startdate, m.description, m.licensetype, prodpack.pricingplanmodel, prodpack.key, prodpack.description, prodpack.producttype, prodpack.addon, prodpackparent.key, prodpackparent.description, pricingplan.monthsvalid
  • Inner Unique: true
  • Hash Cond: (a.pricingplan_id = pricingplan.id)
  • Worker 0: actual time=34.013..86.130 rows=2,324 loops=1
9. 0.309 47.266 ↓ 2.4 1,164 2 / 2

Hash Left Join (cost=2,579.52..65,527.45 rows=493 width=327) (actual time=21.505..47.266 rows=1,164 loops=2)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, lp.license_id, lp.partner_id, lp.enddate, lp.created, lp.productfeatureusage_id, slp.startdate, m.description, m.licensetype, prodpack.pricingplanmodel, prodpack.key, prodpack.description, prodpack.producttype, prodpack.addon, prodpackparent.key, prodpackparent.description
  • Inner Unique: true
  • Hash Cond: (prodpack.parent_id = prodpackparent.id)
  • Worker 0: actual time=21.057..72.427 rows=2,324 loops=1
10. 0.426 44.490 ↓ 2.4 1,164 2 / 2

Hash Left Join (cost=2,120.96..65,067.59 rows=493 width=264) (actual time=19.001..44.490 rows=1,164 loops=2)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, lp.license_id, lp.partner_id, lp.enddate, lp.created, lp.productfeatureusage_id, slp.startdate, m.description, m.licensetype, prodpack.pricingplanmodel, prodpack.key, prodpack.description, prodpack.producttype, prodpack.addon, prodpack.parent_id
  • Inner Unique: true
  • Hash Cond: (m.productpackage_id = prodpack.id)
  • Worker 0: actual time=18.589..69.418 rows=2,324 loops=1
11. 0.665 40.537 ↓ 2.4 1,164 2 / 2

Hash Join (cost=1,662.40..64,607.74 rows=493 width=174) (actual time=15.439..40.537 rows=1,164 loops=2)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, lp.license_id, lp.partner_id, lp.enddate, lp.created, lp.productfeatureusage_id, slp.startdate, m.description, m.licensetype, m.productpackage_id
  • Inner Unique: true
  • Hash Cond: (a.merchandise_id = m.id)
  • Worker 0: actual time=15.080..65.130 rows=2,324 loops=1
12. 0.829 25.180 ↓ 2.4 1,164 2 / 2

Nested Loop (cost=68.54..63,012.58 rows=493 width=89) (actual time=0.476..25.180 rows=1,164 loops=2)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, lp.license_id, lp.partner_id, lp.enddate, lp.created, lp.productfeatureusage_id, slp.startdate
  • Inner Unique: true
  • Worker 0: actual time=0.058..49.321 rows=2,324 loops=1
13. 0.186 22.023 ↓ 2.4 1,164 2 / 2

Nested Loop (cost=67.97..60,109.28 rows=493 width=58) (actual time=0.469..22.023 rows=1,164 loops=2)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, a.latestperiod_id, slp.startdate
  • Join Filter: (p.account_id = slp.account_id)
  • Worker 0: actual time=0.049..43.029 rows=2,324 loops=1
14. 1.756 7.869 ↓ 2.4 1,164 2 / 2

Nested Loop (cost=67.40..21,067.43 rows=494 width=58) (actual time=0.457..7.869 rows=1,164 loops=2)

  • Output: a.id, a.pricingplan_id, a.name, a.priceoverridetype, a.merchandise_id, a.latestperiod_id, p.account_id
  • Inner Unique: true
  • Worker 0: actual time=0.036..14.824 rows=2,324 loops=1
15. 1.323 1.637 ↓ 1.6 2,238 2 / 2

Parallel Bitmap Heap Scan on public.period p (cost=66.96..9,359.59 rows=1,396 width=16) (actual time=0.446..1.637 rows=2,238 loops=2)

  • Output: p.id, p.created, p.startdate, p.enddate, p.months, p.productid, p.current, p.referencenumber, p.invoice_id, p.account_id, p.license_id, p.orderable_id, p.previousperiod_id, p.autoquoted, p.partner_id, p.renewreminded, p.pricingplan_id, p.productfeatureusage_id, p.dbmodified, p.renewalpricingplan_id, p.anchor, p.migrationevaluation_id
  • Recheck Cond: (p.partner_id = 1,652,472)
  • Heap Blocks: exact=4
  • Worker 0: actual time=0.025..2.400 rows=4,468 loops=1
16. 0.314 0.314 ↓ 1.9 4,625 1 / 2

Bitmap Index Scan on period_partner_id (cost=0.00..66.37 rows=2,373 width=0) (actual time=0.627..0.628 rows=4,625 loops=1)

  • Index Cond: (p.partner_id = 1,652,472)
17. 4.476 4.476 ↑ 1.0 1 4,476 / 2

Index Scan using account_pkey on public.account a (cost=0.44..8.39 rows=1 width=50) (actual time=0.002..0.002 rows=1 loops=4,476)

  • Output: a.id, a.name, a.autorenew, a.productid, a.domain, a.creditcarddata_id, a.merchandise_id, a.isjplicense, a.currentunits, a.latestperiod_id, a.status, a.unitusdoverridepriceextax, a.priceoverrideenddate, a.dbmodified, a.actualdomain, a.parent_id, a.renewalaction, a.externaluuid, a.pricingplan_id, a.createexternalaccount, a.warnbeforerenewal, a.priceoverridetype, a.archived, a.billing_group_id, a.transaction_account_billing_group_id, a.latestprovisioningoverrideperiod_id
  • Index Cond: (a.id = p.account_id)
  • Filter: ((a.parent_id IS NULL) AND ((a.status)::text = 'ACTIVE'::text))
  • Rows Removed by Filter: 0
  • Worker 0: actual time=0.002..0.002 rows=1 loops=4,468
18. 13.968 13.968 ↑ 5.0 1 2,328 / 2

Index Scan using period_account_id on public.period slp (cost=0.57..78.97 rows=5 width=16) (actual time=0.011..0.012 rows=1 loops=2,328)

  • Output: slp.id, slp.created, slp.startdate, slp.enddate, slp.months, slp.productid, slp.current, slp.referencenumber, slp.invoice_id, slp.account_id, slp.license_id, slp.orderable_id, slp.previousperiod_id, slp.autoquoted, slp.partner_id, slp.renewreminded, slp.pricingplan_id, slp.productfeatureusage_id, slp.dbmodified, slp.renewalpricingplan_id, slp.anchor, slp.migrationevaluation_id
  • Index Cond: (slp.account_id = a.id)
  • Filter: (slp.previousperiod_id IS NULL)
  • Rows Removed by Filter: 19
  • Worker 0: actual time=0.011..0.012 rows=1 loops=2,324
19. 2.328 2.328 ↑ 1.0 1 2,328 / 2

Index Scan using period_pkey on public.period lp (cost=0.57..5.89 rows=1 width=47) (actual time=0.002..0.002 rows=1 loops=2,328)

  • Output: lp.id, lp.created, lp.startdate, lp.enddate, lp.months, lp.productid, lp.current, lp.referencenumber, lp.invoice_id, lp.account_id, lp.license_id, lp.orderable_id, lp.previousperiod_id, lp.autoquoted, lp.partner_id, lp.renewreminded, lp.pricingplan_id, lp.productfeatureusage_id, lp.dbmodified, lp.renewalpricingplan_id, lp.anchor, lp.migrationevaluation_id
  • Index Cond: (lp.id = a.latestperiod_id)
  • Worker 0: actual time=0.002..0.002 rows=1 loops=2,324
20. 8.419 14.692 ↑ 1.0 37,191 2 / 2

Hash (cost=1,128.94..1,128.94 rows=37,194 width=93) (actual time=14.692..14.692 rows=37,191 loops=2)

  • Output: m.description, m.licensetype, m.id, m.productpackage_id
  • Buckets: 65,536 Batches: 1 Memory Usage: 5,151kB
  • Worker 0: actual time=14.725..14.725 rows=37,191 loops=1
21. 6.273 6.273 ↑ 1.0 37,191 2 / 2

Seq Scan on public.merchandise m (cost=0.00..1,128.94 rows=37,194 width=93) (actual time=0.007..6.273 rows=37,191 loops=2)

  • Output: m.description, m.licensetype, m.id, m.productpackage_id
  • Worker 0: actual time=0.008..6.208 rows=37,191 loops=1
22. 1.566 3.527 ↓ 1.0 5,937 2 / 2

Hash (cost=384.36..384.36 rows=5,936 width=106) (actual time=3.527..3.527 rows=5,937 loops=2)

  • Output: prodpack.pricingplanmodel, prodpack.key, prodpack.description, prodpack.producttype, prodpack.addon, prodpack.id, prodpack.parent_id
  • Buckets: 8,192 Batches: 1 Memory Usage: 894kB
  • Worker 0: actual time=3.472..3.472 rows=5,937 loops=1
23. 1.961 1.961 ↓ 1.0 5,937 2 / 2

Seq Scan on public.productpackage prodpack (cost=0.00..384.36 rows=5,936 width=106) (actual time=0.008..1.961 rows=5,937 loops=2)

  • Output: prodpack.pricingplanmodel, prodpack.key, prodpack.description, prodpack.producttype, prodpack.addon, prodpack.id, prodpack.parent_id
  • Worker 0: actual time=0.012..1.900 rows=5,937 loops=1
24. 1.278 2.467 ↓ 1.0 5,937 2 / 2

Hash (cost=384.36..384.36 rows=5,936 width=79) (actual time=2.467..2.467 rows=5,937 loops=2)

  • Output: prodpackparent.key, prodpackparent.description, prodpackparent.id
  • Buckets: 8,192 Batches: 1 Memory Usage: 734kB
  • Worker 0: actual time=2.430..2.430 rows=5,937 loops=1
25. 1.189 1.189 ↓ 1.0 5,937 2 / 2

Seq Scan on public.productpackage prodpackparent (cost=0.00..384.36 rows=5,936 width=79) (actual time=0.003..1.189 rows=5,937 loops=2)

  • Output: prodpackparent.key, prodpackparent.description, prodpackparent.id
  • Worker 0: actual time=0.003..1.136 rows=5,937 loops=1
26. 5.388 12.705 ↓ 1.0 39,569 2 / 2

Hash (cost=1,720.81..1,720.81 rows=39,481 width=12) (actual time=12.705..12.705 rows=39,569 loops=2)

  • Output: pricingplan.monthsvalid, pricingplan.id
  • Buckets: 65,536 Batches: 1 Memory Usage: 2,367kB
  • Worker 0: actual time=12.709..12.709 rows=39,569 loops=1
27. 7.317 7.317 ↓ 1.0 39,569 2 / 2

Seq Scan on public.pricingplan (cost=0.00..1,720.81 rows=39,481 width=12) (actual time=0.006..7.317 rows=39,569 loops=2)

  • Output: pricingplan.monthsvalid, pricingplan.id
  • Worker 0: actual time=0.009..7.201 rows=39,569 loops=1
28. 2.328 2.328 ↑ 1.0 1 2,328 / 2

Index Scan using productfeatureusage_pkey on public.productfeatureusage pfu (cost=0.57..5.67 rows=1 width=21) (actual time=0.002..0.002 rows=1 loops=2,328)

  • Output: pfu.id, pfu.productfeature_id, pfu.unitcount, pfu.created, pfu.updated, pfu.updatedby, pfu.starter, pfu.dbmodified
  • Index Cond: (pfu.id = lp.productfeatureusage_id)
  • Worker 0: actual time=0.002..0.002 rows=1 loops=2,324
29. 0.703 1.229 ↓ 1.0 4,989 2 / 2

Hash (cost=101.45..101.45 rows=4,945 width=18) (actual time=1.229..1.229 rows=4,989 loops=2)

  • Output: pf.featurekey, pf.id
  • Buckets: 8,192 Batches: 1 Memory Usage: 338kB
  • Worker 0: actual time=1.214..1.214 rows=4,989 loops=1
30. 0.526 0.526 ↓ 1.0 4,989 2 / 2

Seq Scan on public.productfeature pf (cost=0.00..101.45 rows=4,945 width=18) (actual time=0.008..0.526 rows=4,989 loops=2)

  • Output: pf.featurekey, pf.id
  • Worker 0: actual time=0.011..0.530 rows=4,989 loops=1
31. 4.656 4.656 ↑ 4.0 1 2,328 / 2

Index Scan using contactrelationship_account on public.contactrelationship mcr (cost=0.56..8.37 rows=4 width=16) (actual time=0.004..0.004 rows=1 loops=2,328)

  • Output: mcr.id, mcr.main, mcr.relationshiptype, mcr.contact_id, mcr.account_id, mcr.organisationoverride_id, mcr.dbmodified
  • Index Cond: (mcr.account_id = a.id)
  • Filter: (mcr.main AND ((mcr.relationshiptype)::text = 'TECHNICAL'::text))
  • Rows Removed by Filter: 2
  • Worker 0: actual time=0.004..0.004 rows=1 loops=2,324
32. 2.328 2.328 ↑ 1.0 1 2,328 / 2

Index Scan using contact_pkey on public.contact mc (cost=0.43..5.41 rows=1 width=39) (actual time=0.002..0.002 rows=1 loops=2,328)

  • Output: mc.id, mc.firstname, mc.lastname, mc.email, mc.phone, mc.netsuiteid, mc.organisation_id, mc.dbmodified, mc.smart_domain, mc.screenname, mc.department, mc."position", mc.homepageurl, mc.location, mc.aboutme, mc.avatartype, mc.avatarurl, mc.instantmessenger, mc.external_uuid, mc.status
  • Index Cond: (mc.id = mcr.contact_id)
  • Worker 0: actual time=0.002..0.002 rows=1 loops=2,324
33.          

SubPlan (for Gather)

34. 0.578 27.744 ↑ 1.0 1 578

Aggregate (cost=65.55..65.56 rows=1 width=8) (actual time=0.048..0.048 rows=1 loops=578)

  • Output: count(1)
35. 1.723 27.166 ↓ 1.7 5 578

Nested Loop Anti Join (cost=1.70..65.55 rows=3 width=0) (actual time=0.016..0.047 rows=5 loops=578)

36. 1.614 12.138 ↓ 1.7 5 578

Nested Loop (cost=1.13..37.11 rows=3 width=8) (actual time=0.008..0.021 rows=5 loops=578)

  • Output: child.id
  • Inner Unique: true
37. 5.202 5.202 ↓ 1.7 5 578

Index Scan using account_parent_id on public.account child (cost=0.56..19.35 rows=3 width=16) (actual time=0.004..0.009 rows=5 loops=578)

  • Output: child.id, child.name, child.autorenew, child.productid, child.domain, child.creditcarddata_id, child.merchandise_id, child.isjplicense, child.currentunits, child.latestperiod_id, child.status, child.unitusdoverridepriceextax, child.priceoverrideenddate, child.dbmodified, child.actualdomain, child.parent_id, child.renewalaction, child.externaluuid, child.pricingplan_id, child.createexternalaccount, child.warnbeforerenewal, child.priceoverridetype, child.archived, child.billing_group_id, child.transaction_account_billing_group_id, child.latestprovisioningoverrideperiod_id
  • Index Cond: (child.parent_id = a.id)
  • Filter: ((child.status)::text = 'ACTIVE'::text)
  • Rows Removed by Filter: 6
38. 5.322 5.322 ↑ 1.0 1 2,661

Index Only Scan using period_pkey on public.period childperiod (cost=0.57..5.92 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=2,661)

  • Output: childperiod.id
  • Index Cond: (childperiod.id = child.latestperiod_id)
  • Heap Fetches: 2,087
39. 13.305 13.305 ↓ 0.0 0 2,661

Index Only Scan using accountproperty_unique_keys on public.accountproperty childproperty (cost=0.56..7.25 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=2,661)

  • Output: childproperty.key, childproperty.account_id
  • Index Cond: ((childproperty.key = 'account.deactivated'::text) AND (childproperty.account_id = child.id))
  • Heap Fetches: 121
40. 0.578 20.808 ↑ 1.0 1 578

Aggregate (cost=65.55..65.56 rows=1 width=8) (actual time=0.036..0.036 rows=1 loops=578)

  • Output: count(1)
41. 1.494 20.230 ↓ 1.7 5 578

Nested Loop Anti Join (cost=1.70..65.55 rows=3 width=0) (actual time=0.010..0.035 rows=5 loops=578)

42. 1.963 8.092 ↓ 1.7 5 578

Nested Loop (cost=1.13..37.11 rows=3 width=8) (actual time=0.004..0.014 rows=5 loops=578)

  • Output: child_1.id
  • Inner Unique: true
43. 3.468 3.468 ↓ 1.7 5 578

Index Scan using account_parent_id on public.account child_1 (cost=0.56..19.35 rows=3 width=16) (actual time=0.002..0.006 rows=5 loops=578)

  • Output: child_1.id, child_1.name, child_1.autorenew, child_1.productid, child_1.domain, child_1.creditcarddata_id, child_1.merchandise_id, child_1.isjplicense, child_1.currentunits, child_1.latestperiod_id, child_1.status, child_1.unitusdoverridepriceextax, child_1.priceoverrideenddate, child_1.dbmodified, child_1.actualdomain, child_1.parent_id, child_1.renewalaction, child_1.externaluuid, child_1.pricingplan_id, child_1.createexternalaccount, child_1.warnbeforerenewal, child_1.priceoverridetype, child_1.archived, child_1.billing_group_id, child_1.transaction_account_billing_group_id, child_1.latestprovisioningoverrideperiod_id
  • Index Cond: (child_1.parent_id = a.id)
  • Filter: ((child_1.status)::text = 'ACTIVE'::text)
  • Rows Removed by Filter: 6
44. 2.661 2.661 ↑ 1.0 1 2,661

Index Only Scan using period_pkey on public.period childperiod_1 (cost=0.57..5.92 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=2,661)

  • Output: childperiod_1.id
  • Index Cond: (childperiod_1.id = child_1.latestperiod_id)
  • Heap Fetches: 2,087
45. 10.644 10.644 ↓ 0.0 0 2,661

Index Only Scan using accountproperty_unique_keys on public.accountproperty childproperty_1 (cost=0.56..7.25 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=2,661)

  • Output: childproperty_1.key, childproperty_1.account_id
  • Index Cond: ((childproperty_1.key = 'account.deactivated'::text) AND (childproperty_1.account_id = child_1.id))
  • Heap Fetches: 121
46. 0.578 2,498.116 ↑ 1.0 1 578

Aggregate (cost=31.12..31.13 rows=1 width=8) (actual time=4.322..4.322 rows=1 loops=578)

  • Output: count(1)
47. 0.000 2,497.538 ↓ 0.0 0 578

Nested Loop Anti Join (cost=1.70..31.12 rows=1 width=0) (actual time=4.308..4.321 rows=0 loops=578)

48. 0.000 2,497.538 ↓ 0.0 0 578

Nested Loop (cost=1.13..17.18 rows=1 width=8) (actual time=4.308..4.321 rows=0 loops=578)

  • Output: child_2.id
49. 448.528 448.528 ↓ 2,020.0 2,020 578

Index Scan using migrationevaluation_id_unique_idx on public.period childperiod_2 (cost=0.57..8.59 rows=1 width=8) (actual time=0.004..0.776 rows=2,020 loops=578)

  • Output: childperiod_2.id, childperiod_2.created, childperiod_2.startdate, childperiod_2.enddate, childperiod_2.months, childperiod_2.productid, childperiod_2.current, childperiod_2.referencenumber, childperiod_2.invoice_id, childperiod_2.account_id, childperiod_2.license_id, childperiod_2.orderable_id, childperiod_2.previousperiod_id, childperiod_2.autoquoted, childperiod_2.partner_id, childperiod_2.renewreminded, childperiod_2.pricingplan_id, childperiod_2.productfeatureusage_id, childperiod_2.dbmodified, childperiod_2.renewalpricingplan_id, childperiod_2.anchor, childperiod_2.migrationevaluation_id
  • Index Cond: (childperiod_2.migrationevaluation_id IS NOT NULL)
50. 2,335.120 2,335.120 ↓ 0.0 0 1,167,560

Index Scan using account_latestperiod on public.account child_2 (cost=0.56..8.59 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1,167,560)

  • Output: child_2.id, child_2.name, child_2.autorenew, child_2.productid, child_2.domain, child_2.creditcarddata_id, child_2.merchandise_id, child_2.isjplicense, child_2.currentunits, child_2.latestperiod_id, child_2.status, child_2.unitusdoverridepriceextax, child_2.priceoverrideenddate, child_2.dbmodified, child_2.actualdomain, child_2.parent_id, child_2.renewalaction, child_2.externaluuid, child_2.pricingplan_id, child_2.createexternalaccount, child_2.warnbeforerenewal, child_2.priceoverridetype, child_2.archived, child_2.billing_group_id, child_2.transaction_account_billing_group_id, child_2.latestprovisioningoverrideperiod_id
  • Index Cond: (child_2.latestperiod_id = childperiod_2.id)
  • Filter: ((child_2.parent_id = a.id) AND ((child_2.status)::text = 'ACTIVE'::text))
  • Rows Removed by Filter: 0
51. 0.042 0.042 ↓ 0.0 0 6

Index Only Scan using accountproperty_unique_keys on public.accountproperty childproperty_2 (cost=0.56..7.25 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=6)

  • Output: childproperty_2.key, childproperty_2.account_id
  • Index Cond: ((childproperty_2.key = 'account.deactivated'::text) AND (childproperty_2.account_id = child_2.id))
  • Heap Fetches: 0
Planning time : 4.320 ms
Execution time : 2,605.245 ms