explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a3Umk

Settings
# exclusive inclusive rows x rows loops node
1. 1,704.790 1,943.397 ↓ 0.0 0 1

Bitmap Heap Scan on virtual_position (cost=32,588.82..1,039,486.29 rows=1,125,742 width=212) (actual time=1,943.397..1,943.397 rows=0 loops=1)

  • Recheck Cond: ((group_ref)::text = 'ATS_HD'::text)
  • Filter: ((catalogue_id)::text = '5d912c27-e7d8-4bd7-bab6-d0878e0ff691'::text)
  • Rows Removed by Filter: 779040
  • Heap Blocks: exact=388243
2. 238.607 238.607 ↓ 1.2 1,813,611 1

Bitmap Index Scan on idx_virtual_position_group_ref (cost=0.00..32,307.39 rows=1,466,510 width=0) (actual time=238.607..238.607 rows=1,813,611 loops=1)

  • Index Cond: ((group_ref)::text = 'ATS_HD'::text)
Planning time : 0.137 ms
Execution time : 1,945.070 ms