explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HG4V

Settings
# exclusive inclusive rows x rows loops node
1. 0.076 4.858 ↑ 1.0 500 1

Limit (cost=33.74..1,995.32 rows=500 width=10) (actual time=2.309..4.858 rows=500 loops=1)

2. 1.996 4.782 ↑ 2.6 500 1

LockRows (cost=33.74..5,078.92 rows=1,286 width=10) (actual time=2.308..4.782 rows=500 loops=1)

3. 0.725 2.786 ↑ 2.6 500 1

Bitmap Heap Scan on marks (cost=33.74..5,066.06 rows=1,286 width=10) (actual time=2.282..2.786 rows=500 loops=1)

  • Recheck Cond: ((gtin_id = 43) AND (print_id IS NULL))
  • Heap Blocks: exact=223
4. 2.061 2.061 ↓ 15.6 20,000 1

Bitmap Index Scan on marks_gtin_id_print_id_id_index (cost=0.00..33.42 rows=1,286 width=0) (actual time=2.061..2.061 rows=20,000 loops=1)

  • Index Cond: ((gtin_id = 43) AND (print_id IS NULL))
Planning time : 0.191 ms
Execution time : 4.963 ms