explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6kZk

Settings
# exclusive inclusive rows x rows loops node
1. 0.170 0.810 ↑ 1.0 8 1

Seq Scan on access (cost=0.00..107.56 rows=8 width=320) (actual time=0.204..0.810 rows=8 loops=1)

2.          

SubPlan (forSeq Scan)

3. 0.040 0.040 ↓ 0.0 0 8

Seq Scan on endpoint (cost=0.00..1.14 rows=1 width=32) (actual time=0.004..0.005 rows=0 loops=8)

  • Filter: ((access.source)::text = ANY ((group_ids)::text[]))
  • Rows Removed by Filter: 6
4. 0.040 0.152 ↑ 1.0 1 8

Aggregate (cost=2.19..2.20 rows=1 width=32) (actual time=0.019..0.019 rows=1 loops=8)

5. 0.080 0.112 ↑ 2.0 1 8

Seq Scan on tag (cost=1.14..2.18 rows=2 width=32) (actual time=0.008..0.014 rows=1 loops=8)

  • Filter: (((asset_id)::text = (access.source)::text) OR (hashed SubPlan 2))
  • Rows Removed by Filter: 2
6.          

SubPlan (forSeq Scan)

7. 0.032 0.032 ↓ 0.0 0 8

Seq Scan on endpoint endpoint_1 (cost=0.00..1.14 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=8)

  • Filter: ((access.source)::text = ANY ((group_ids)::text[]))
  • Rows Removed by Filter: 6
8. 0.054 0.088 ↓ 0.0 0 8

Seq Scan on application (cost=2.27..3.32 rows=1 width=32) (actual time=0.009..0.011 rows=0 loops=8)

  • Filter: (((access.source)::text = ANY ((asset_ids)::text[])) OR ($4 AND (asset_ids @> $5)))
  • Rows Removed by Filter: 2
9.          

Initplan (forSeq Scan)

10. 0.024 0.024 ↓ 0.0 0 8

Seq Scan on endpoint endpoint_2 (cost=0.00..1.14 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=8)

  • Filter: ((access.source)::text = ANY ((group_ids)::text[]))
  • Rows Removed by Filter: 4
11. 0.010 0.010 ↓ 2.0 2 2

Seq Scan on endpoint endpoint_3 (cost=0.00..1.14 rows=1 width=32) (actual time=0.003..0.005 rows=2 loops=2)

  • Filter: ((access.source)::text = ANY ((group_ids)::text[]))
  • Rows Removed by Filter: 4
12. 0.032 0.032 ↑ 1.0 1 8

Seq Scan on endpoint endpoint_4 (cost=0.00..1.14 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=8)

  • Filter: ((access.destination)::text = ANY ((group_ids)::text[]))
  • Rows Removed by Filter: 5
13. 0.048 0.136 ↑ 1.0 1 8

Aggregate (cost=2.19..2.20 rows=1 width=32) (actual time=0.017..0.017 rows=1 loops=8)

14. 0.056 0.088 ↑ 2.0 1 8

Seq Scan on tag tag_1 (cost=1.14..2.18 rows=2 width=32) (actual time=0.010..0.011 rows=1 loops=8)

  • Filter: (((asset_id)::text = (access.destination)::text) OR (hashed SubPlan 8))
  • Rows Removed by Filter: 2
15.          

SubPlan (forSeq Scan)

16. 0.032 0.032 ↑ 1.0 1 8

Seq Scan on endpoint endpoint_5 (cost=0.00..1.14 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=8)

  • Filter: ((access.destination)::text = ANY ((group_ids)::text[]))
  • Rows Removed by Filter: 5
17. 0.153 0.192 ↑ 1.0 1 8

Seq Scan on application application_1 (cost=2.27..3.32 rows=1 width=32) (actual time=0.021..0.024 rows=1 loops=8)

  • Filter: (((access.destination)::text = ANY ((asset_ids)::text[])) OR ($10 AND (asset_ids @> $11)))
  • Rows Removed by Filter: 1
18.          

Initplan (forSeq Scan)

19. 0.024 0.024 ↓ 0.0 0 8

Seq Scan on endpoint endpoint_6 (cost=0.00..1.14 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=8)

  • Filter: ((access.destination)::text = ANY ((group_ids)::text[]))
  • Rows Removed by Filter: 4
20. 0.015 0.015 ↓ 2.0 2 3

Seq Scan on endpoint endpoint_7 (cost=0.00..1.14 rows=1 width=32) (actual time=0.003..0.005 rows=2 loops=3)

  • Filter: ((access.destination)::text = ANY ((group_ids)::text[]))
  • Rows Removed by Filter: 4