explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KdRj

Settings
# exclusive inclusive rows x rows loops node
1. 1.273 23.258 ↑ 10,855.4 269 1

Unique (cost=512,934.52..527,535.02 rows=2,920,100 width=32) (actual time=21.054..23.258 rows=269 loops=1)

2. 5.389 21.985 ↑ 201.5 14,491 1

Sort (cost=512,934.52..520,234.77 rows=2,920,100 width=32) (actual time=21.053..21.985 rows=14,491 loops=1)

  • Sort Key: (unnest(access.subnet_endpoints))
  • Sort Method: quicksort Memory: 1064kB
3. 1.563 16.596 ↑ 201.5 14,491 1

Append (cost=0.00..59,617.02 rows=2,920,100 width=32) (actual time=0.027..16.596 rows=14,491 loops=1)

4. 6.253 9.858 ↑ 116.3 14,491 1

ProjectSet (cost=0.00..9,207.68 rows=1,685,900 width=32) (actual time=0.027..9.858 rows=14,491 loops=1)

5. 3.605 3.605 ↓ 1.0 16,938 1

Seq Scan on access (cost=0.00..651.74 rows=16,859 width=29) (actual time=0.022..3.605 rows=16,938 loops=1)

  • Filter: (tenant_id = '7b26e0d9-d493-30c1-ac75-38d68d70538d'::uuid)
6. 3.087 5.175 ↓ 0.0 0 1

ProjectSet (cost=0.00..6,607.84 rows=1,234,200 width=32) (actual time=5.175..5.175 rows=0 loops=1)

7. 2.088 2.088 ↑ 1.0 12,307 1

Seq Scan on security_access (cost=0.00..344.27 rows=12,342 width=13) (actual time=0.022..2.088 rows=12,307 loops=1)

  • Filter: (tenant_id = '7b26e0d9-d493-30c1-ac75-38d68d70538d'::uuid)
Planning time : 0.637 ms
Execution time : 23.452 ms