explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8n23

Settings
# exclusive inclusive rows x rows loops node
1. 273.779 273.835 ↑ 333.3 48 1

ProjectSet (cost=28.82..125.02 rows=16,000 width=92) (actual time=27.275..273.835 rows=48 loops=1)

2. 0.019 0.056 ↑ 1.3 12 1

Group (cost=28.82..28.94 rows=16 width=26) (actual time=0.032..0.056 rows=12 loops=1)

  • Group Key: subnet, contact_role_id
3. 0.015 0.037 ↑ 1.3 12 1

Sort (cost=28.82..28.86 rows=16 width=26) (actual time=0.030..0.037 rows=12 loops=1)

  • Sort Key: subnet
  • Sort Method: quicksort Memory: 25kB
4. 0.014 0.022 ↑ 1.3 12 1

Bitmap Heap Scan on claimedsubnets me (cost=4.41..28.50 rows=16 width=26) (actual time=0.015..0.022 rows=12 loops=1)

  • Recheck Cond: (contact_role_id = 'e2a72665-832a-45c5-a688-29927b7cf11b'::uuid)
  • Filter: (z_subnet_check_ts IS NULL)
  • Heap Blocks: exact=5
5. 0.008 0.008 ↑ 1.4 12 1

Bitmap Index Scan on claimedsubnets_contactrole_id_idx (cost=0.00..4.41 rows=17 width=0) (actual time=0.008..0.008 rows=12 loops=1)

  • Index Cond: (contact_role_id = 'e2a72665-832a-45c5-a688-29927b7cf11b'::uuid)
Planning time : 0.133 ms
Execution time : 273.882 ms