explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b2vQ

Settings
# exclusive inclusive rows x rows loops node
1. 16.065 16.065 ↓ 3.9 7,133 1

Index Scan using tmp_index_for_fixing_inconsistent_vulnerability_occurrences on public.vulnerability_occurrences (cost=0.42..2,062.37 rows=1,816 width=49) (actual time=0.311..16.065 rows=7,133 loops=1)

  • Index Cond: ((vulnerability_occurrences.id >= 231,411) AND (vulnerability_occurrences.id <= 2,312,411))
  • Buffers: shared hit=6,902 read=22
  • I/O Timings: read=1.202