explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TRac

Settings
# exclusive inclusive rows x rows loops node
1. 0.074 301.308 ↑ 1.0 500 1

Limit (cost=14,758.48..14,764.73 rows=500 width=10) (actual time=300.480..301.308 rows=500 loops=1)

2. 0.745 301.234 ↑ 7.5 500 1

LockRows (cost=14,758.48..14,805.51 rows=3,762 width=10) (actual time=300.478..301.234 rows=500 loops=1)

3. 1.739 300.489 ↑ 7.5 500 1

Sort (cost=14,758.48..14,767.89 rows=3,762 width=10) (actual time=300.429..300.489 rows=500 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 272kB
4. 296.530 298.750 ↑ 1.0 3,750 1

Bitmap Heap Scan on marks (cost=137.72..14,571.02 rows=3,762 width=10) (actual time=2.380..298.750 rows=3,750 loops=1)

  • Recheck Cond: (gtin_id = 22,035)
  • Heap Blocks: exact=604
5. 2.220 2.220 ↓ 3.9 14,836 1

Bitmap Index Scan on marks_gtin_id_printed_index (cost=0.00..136.78 rows=3,762 width=0) (actual time=2.220..2.220 rows=14,836 loops=1)

  • Index Cond: (gtin_id = 22,035)
Planning time : 0.180 ms
Execution time : 301.406 ms