explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uNJb

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 686.221 ↑ 1.0 51 1

Limit (cost=49,956.30..49,956.43 rows=51 width=280) (actual time=686.213..686.221 rows=51 loops=1)

2.          

Initplan (forLimit)

3. 0.007 0.032 ↑ 1,638.0 1 1

Bitmap Heap Scan on product_synchronization_tracking product_synchronization_tracking_1 (cost=61.12..4,671.14 rows=1,638 width=24) (actual time=0.031..0.032 rows=1 loops=1)

  • Recheck Cond: (((id)::character varying)::text = '021f095b-0108-4064-82fa-fcd4b2833e78'::text)
  • Heap Blocks: exact=1
4. 0.025 0.025 ↑ 1,638.0 1 1

Bitmap Index Scan on test (cost=0.00..60.71 rows=1,638 width=0) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: (((id)::character varying)::text = '021f095b-0108-4064-82fa-fcd4b2833e78'::text)
5. 62.892 686.219 ↑ 2,141.7 51 1

Sort (cost=45,285.16..45,558.23 rows=109,227 width=280) (actual time=686.212..686.219 rows=51 loops=1)

  • Sort Key: product_synchronization_tracking.last_updated_date, product_synchronization_tracking.id
  • Sort Method: top-N heapsort Memory: 51kB
6. 57.401 623.327 ↓ 3.0 327,530 1

Group (cost=41,094.98..41,641.12 rows=109,227 width=280) (actual time=461.579..623.327 rows=327,530 loops=1)

  • Group Key: product_synchronization_tracking.id
7. 439.100 565.926 ↓ 3.0 327,530 1

Sort (cost=41,094.98..41,368.05 rows=109,227 width=280) (actual time=461.576..565.926 rows=327,530 loops=1)

  • Sort Key: product_synchronization_tracking.id
  • Sort Method: external merge Disk: 93728kB
8. 74.367 126.826 ↓ 3.0 327,530 1

Bitmap Heap Scan on product_synchronization_tracking (cost=3,018.93..17,765.34 rows=109,227 width=280) (actual time=54.184..126.826 rows=327,530 loops=1)

  • Recheck Cond: (ROW(last_updated_date, id) > ROW($0, $1))
  • Heap Blocks: exact=13108
9. 52.459 52.459 ↓ 3.0 327,530 1

Bitmap Index Scan on test3 (cost=0.00..2,991.62 rows=109,227 width=0) (actual time=52.459..52.459 rows=327,530 loops=1)

  • Index Cond: (ROW(last_updated_date, id) > ROW($0, $1))