explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kiRE

Settings
# exclusive inclusive rows x rows loops node
1. 0.199 0.839 ↑ 65.0 8 1

Seq Scan on access (cost=0.00..31,116.40 rows=520 width=320) (actual time=0.269..0.839 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.048 0.160 ↑ 1.0 1 8

Aggregate (cost=25.44..25.45 rows=1 width=32) (actual time=0.020..0.020 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.009..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.056 0.104 ↓ 0.0 0 8

Seq Scan on application (cost=2.27..3.32 rows=1 width=32) (actual time=0.010..0.013 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.032 0.032 ↓ 0.0 0 8

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

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

Seq Scan on endpoint endpoint_3 (cost=0.00..1.14 rows=1 width=32) (actual time=0.006..0.008 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.168 ↑ 1.0 1 8

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

14. 0.080 0.112 ↑ 440.0 1 8

Seq Scan on tag tag_1 (cost=1.14..24.34 rows=440 width=32) (actual time=0.012..0.014 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.078 0.128 ↑ 1.0 1 8

Seq Scan on application application_1 (cost=2.27..3.32 rows=1 width=32) (actual time=0.013..0.016 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.018 0.018 ↓ 2.0 2 3

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

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