explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SjjR

Settings
# exclusive inclusive rows x rows loops node
1. 373.754 388.044 ↑ 1.6 60,032 1

Bitmap Heap Scan on virtual_position (cost=5,240.94..312,278.92 rows=95,008 width=212) (actual time=25.242..388.044 rows=60,032 loops=1)

  • Recheck Cond: (((group_ref)::text = '6593'::text) AND ((catalogue_id)::text = '5d912c27-e7d8-4bd7-bab6-d0878e0ff691'::text))
  • Filter: ((status)::text = 'ACTIVE'::text)
  • Rows Removed by Filter: 3144
  • Heap Blocks: exact=57343
2. 14.290 14.290 ↑ 1.7 63,176 1

Bitmap Index Scan on idx_virtual_position_group_ref_catalogue_id (cost=0.00..5,217.19 rows=106,863 width=0) (actual time=14.290..14.290 rows=63,176 loops=1)

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