explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aHR0

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 52.927 ↑ 1.0 100 1

Limit (cost=125.77..128.28 rows=100 width=128) (actual time=52.816..52.927 rows=100 loops=1)

  • Output: get_group_container_subscription_details.resource_id, get_group_container_subscription_details.fname, get_group_container_subscription_details.device_profile_id, get_group_container_subscription_details.container_name
2. 0.057 52.896 ↑ 2.0 100 1

Unique (cost=125.77..130.78 rows=200 width=128) (actual time=52.814..52.896 rows=100 loops=1)

  • Output: get_group_container_subscription_details.resource_id, get_group_container_subscription_details.fname, get_group_container_subscription_details.device_profile_id, get_group_container_subscription_details.container_name
3. 0.365 52.839 ↑ 10.0 100 1

Sort (cost=125.77..128.28 rows=1,002 width=128) (actual time=52.812..52.839 rows=100 loops=1)

  • Output: get_group_container_subscription_details.resource_id, get_group_container_subscription_details.fname, get_group_container_subscription_details.device_profile_id, get_group_container_subscription_details.container_name
  • Sort Key: get_group_container_subscription_details.resource_id
  • Sort Method: quicksort Memory: 39kB
4. 0.267 52.474 ↑ 10.0 100 1

HashAggregate (cost=55.79..65.81 rows=1,002 width=128) (actual time=52.401..52.474 rows=100 loops=1)

  • Output: get_group_container_subscription_details.resource_id, get_group_container_subscription_details.fname, get_group_container_subscription_details.device_profile_id, get_group_container_subscription_details.container_name
  • Group Key: get_group_container_subscription_details.resource_id, get_group_container_subscription_details.fname, get_group_container_subscription_details.device_profile_id, get_group_container_subscription_details.container_name
5. 0.044 52.207 ↑ 10.0 100 1

Append (cost=0.25..45.77 rows=1,002 width=128) (actual time=15.070..52.207 rows=100 loops=1)

6. 15.096 15.096 ↑ 10.0 100 1

Function Scan on iot.get_group_container_subscription_details (cost=0.25..10.25 rows=1,000 width=128) (actual time=15.069..15.096 rows=100 loops=1)

  • Output: get_group_container_subscription_details.resource_id, get_group_container_subscription_details.fname, get_group_container_subscription_details.device_profile_id, get_group_container_subscription_details.container_name
  • Function Call: get_group_container_subscription_details('{1416,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,3505,3605,3606,3809,3810,3886,3887,3951,3954,3955,4018,4019,4028,4032,4033,4034,4036,4075,4092,4093,4104,4105,4106,4107,4108,4109,4145,4146}'::integer[], 'C264516AA-5e6f2974'::character varying, 100, NULL::numeric, NULL::character varying, NULL::text[], NULL::boolean, NULL::character varying)
7. 14.258 14.258 ↓ 0.0 0 1

Function Scan on iot.get_ae_container_subscription_details (cost=0.25..12.75 rows=1 width=128) (actual time=14.258..14.258 rows=0 loops=1)

  • Output: get_ae_container_subscription_details.resource_id, get_ae_container_subscription_details.fname, get_ae_container_subscription_details.device_profile_id, get_ae_container_subscription_details.container_name
  • Function Call: get_ae_container_subscription_details('{60}'::integer[], 'C264516AA-5e6f2974'::character varying, NULL::numeric, NULL::character varying, NULL::text[], NULL::boolean)
  • Filter: (get_ae_container_subscription_details.ansctr @> '{1416,CUSTOMER}'::text[])
8. 22.809 22.809 ↓ 0.0 0 1

Function Scan on iot.get_container_subscription_details (cost=0.25..12.75 rows=1 width=128) (actual time=22.809..22.809 rows=0 loops=1)

  • Output: get_container_subscription_details.resource_id, get_container_subscription_details.fname, get_container_subscription_details.device_profile_id, get_container_subscription_details.container_name
  • Function Call: get_container_subscription_details('{60}'::integer[], 'C264516AA-5e6f2974'::character varying, NULL::numeric, NULL::character varying, NULL::text[], NULL::boolean)
  • Filter: (get_container_subscription_details.ansctr @> '{1416,CUSTOMER}'::text[])
Planning time : 0.423 ms
Execution time : 55.481 ms