explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f6Ws

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 3,162.830 ↑ 1.0 500 1

Limit (cost=5,130.14..5,136.39 rows=500 width=10) (actual time=2,918.970..3,162.830 rows=500 loops=1)

2. 243.812 3,162.795 ↑ 2.6 500 1

LockRows (cost=5,130.14..5,146.21 rows=1,286 width=10) (actual time=2,918.969..3,162.795 rows=500 loops=1)

3. 5.123 2,918.983 ↑ 2.6 500 1

Sort (cost=5,130.14..5,133.35 rows=1,286 width=10) (actual time=2,918.946..2,918.983 rows=500 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 1,706kB
4. 2,613.472 2,913.860 ↓ 15.6 20,000 1

Bitmap Heap Scan on marks (cost=33.74..5,066.06 rows=1,286 width=10) (actual time=300.508..2,913.860 rows=20,000 loops=1)

  • Recheck Cond: ((gtin_id = 43) AND (print_id IS NULL))
  • Heap Blocks: exact=1,115
5. 300.388 300.388 ↓ 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=300.388..300.388 rows=20,000 loops=1)

  • Index Cond: ((gtin_id = 43) AND (print_id IS NULL))
Planning time : 0.153 ms
Execution time : 3,162.997 ms