explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YHQS

Settings
# exclusive inclusive rows x rows loops node
1. 0.191 0.879 ↑ 65.0 8 1

Seq Scan on access (cost=0.00..63,304.40 rows=520 width=320) (actual time=0.219..0.879 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.005..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=25.44..25.45 rows=1 width=32) (actual time=0.019..0.019 rows=1 loops=8)

5. 0.072 0.112 ↑ 440.0 1 8

Seq Scan on tag (cost=1.14..24.34 rows=440 width=32) (actual time=0.010..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.040 0.040 ↓ 0.0 0 8

Seq Scan on endpoint endpoint_1 (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
8. 0.054 0.120 ↓ 0.0 0 8

Seq Scan on application (cost=2.27..34.27 rows=45 width=32) (actual time=0.011..0.015 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.048 0.048 ↓ 0.0 0 8

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

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

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

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

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

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

Aggregate (cost=25.44..25.45 rows=1 width=32) (actual time=0.025..0.025 rows=1 loops=8)

14. 0.104 0.144 ↑ 440.0 1 8

Seq Scan on tag tag_1 (cost=1.14..24.34 rows=440 width=32) (actual time=0.016..0.018 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.040 0.040 ↑ 1.0 1 8

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

  • Filter: ((access.destination)::text = ANY ((group_ids)::text[]))
  • Rows Removed by Filter: 5
17. 0.080 0.136 ↑ 45.0 1 8

Seq Scan on application application_1 (cost=2.27..34.27 rows=45 width=32) (actual time=0.014..0.017 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.032 0.032 ↓ 0.0 0 8

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

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

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

  • Filter: ((access.destination)::text = ANY ((group_ids)::text[]))
  • Rows Removed by Filter: 4
Planning time : 0.929 ms
Execution time : 1.054 ms