explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n6tr

Settings
# exclusive inclusive rows x rows loops node
1. 55.449 31,662.240 ↓ 2.1 46,611 1

Nested Loop (cost=655.96..258,893.78 rows=22,576 width=2,109) (actual time=468.347..31,662.240 rows=46,611 loops=1)

2. 58.348 517.254 ↓ 2.1 46,611 1

Bitmap Heap Scan on unit_media_items u0 (cost=655.40..77,710.38 rows=22,576 width=926) (actual time=464.745..517.254 rows=46,611 loops=1)

  • Recheck Cond: (domain_unit_id = '37fdf460-9670-4a1c-a17f-0561b6c62a73'::uuid)
  • Heap Blocks: exact=28837
3. 458.906 458.906 ↓ 2.1 46,611 1

Bitmap Index Scan on unit_media_items_domain_unit_id_index (cost=0.00..649.75 rows=22,576 width=0) (actual time=458.906..458.906 rows=46,611 loops=1)

  • Index Cond: (domain_unit_id = '37fdf460-9670-4a1c-a17f-0561b6c62a73'::uuid)
4. 31,089.537 31,089.537 ↑ 1.0 1 46,611

Index Scan using media_items_pkey on media_items m1 (cost=0.56..8.02 rows=1 width=1,183) (actual time=0.665..0.667 rows=1 loops=46,611)

  • Index Cond: (id = u0.media_item_id)