explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1KYV

Settings
# exclusive inclusive rows x rows loops node
1. 205.939 220.076 ↓ 3.3 63,176 1

Bitmap Heap Scan on virtual_position (cost=938.98..69,682.30 rows=19,358 width=212) (actual time=25.134..220.076 rows=63,176 loops=1)

  • Recheck Cond: (((group_ref)::text = '6593'::text) AND ((catalogue_id)::text = '5d912c27-e7d8-4bd7-bab6-d0878e0ff691'::text))
  • Heap Blocks: exact=57343
2. 14.137 14.137 ↓ 3.3 63,176 1

Bitmap Index Scan on idx_virtual_position_group_ref_catalogue_id (cost=0.00..934.14 rows=19,358 width=0) (actual time=14.137..14.137 rows=63,176 loops=1)

  • Index Cond: (((group_ref)::text = '6593'::text) AND ((catalogue_id)::text = '5d912c27-e7d8-4bd7-bab6-d0878e0ff691'::text))