explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J7LH

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

Limit (cost=50,214.16..50,214.29 rows=51 width=280) (actual time=644.936..644.942 rows=51 loops=1)

2.          

Initplan (forLimit)

3. 0.004 0.015 ↑ 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.014..0.015 rows=1 loops=1)

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

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

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

Sort (cost=45,543.03..45,816.09 rows=109,227 width=280) (actual time=644.935..644.939 rows=51 loops=1)

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

Group (cost=41,352.85..41,898.98 rows=109,227 width=280) (actual time=418.710..581.885 rows=327,530 loops=1)

  • Group Key: product_synchronization_tracking.id
7. 444.217 523.094 ↓ 3.0 327,530 1

Sort (cost=41,352.85..41,625.91 rows=109,227 width=280) (actual time=418.708..523.094 rows=327,530 loops=1)

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

Seq Scan on product_synchronization_tracking (cost=0.00..18,023.20 rows=109,227 width=280) (actual time=0.019..78.877 rows=327,530 loops=1)

  • Filter: (ROW(last_updated_date, id) > ROW($0, $1))
  • Rows Removed by Filter: 150