explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xs4n

Settings
# exclusive inclusive rows x rows loops node
1. 15,582.539 15,644.596 ↑ 1.0 24,747 1

Bitmap Heap Scan on sale s (cost=393.57..43,852.54 rows=25,438 width=976) (actual time=70.525..15,644.596 rows=24,747 loops=1)

  • Recheck Cond: (branch_id = '971aa24a-dc34-4477-b039-8dc8a20f07f4'::uuid)
  • Heap Blocks: exact=23,083
2. 62.057 62.057 ↑ 1.0 24,747 1

Bitmap Index Scan on sale_branch_id_idx (cost=0.00..387.21 rows=25,438 width=0) (actual time=62.056..62.057 rows=24,747 loops=1)

  • Index Cond: (branch_id = '971aa24a-dc34-4477-b039-8dc8a20f07f4'::uuid)
Planning time : 1.861 ms
Execution time : 15,692.985 ms