explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iYt : ordering

Settings
# exclusive inclusive rows x rows loops node
1. 0.213 149,833.030 ↑ 1.0 10 1

Limit (cost=0.87..3,905.77 rows=10 width=361) (actual time=149,828.198..149,833.030 rows=10 loops=1)

  • Buffers: shared hit=353681 read=2145084
2. 0.080 149,832.817 ↑ 16,722.0 10 1

Nested Loop Left Join (cost=0.87..65,297,791.29 rows=167,220 width=361) (actual time=149,827.998..149,832.817 rows=10 loops=1)

  • Buffers: shared hit=353681 read=2145084
3. 149,827.757 149,827.757 ↑ 16,722.0 10 1

Index Scan Backward using rights_proposedrelationship_views_fc471a32 on rights_proposedrelationship (cost=0.44..64,148,934.29 rows=167,220 width=281) (actual time=149,826.958..149,827.757 rows=10 loops=1)

  • Filter: ("primary" AND (NOT in_catalog) AND (score >= 0.85000) AND (admin_id = 7) AND ((status)::text = 'PROPOSED'::text))
  • Rows Removed by Filter: 19239900
  • Buffers: shared hit=353672 read=2145053
4. 4.980 4.980 ↑ 1.0 1 10

Index Scan using rights_assetinstance_pkey on rights_assetinstance (cost=0.43..6.87 rows=1 width=96) (actual time=0.498..0.498 rows=1 loops=10)

  • Index Cond: (rights_proposedrelationship.instance_id = id)
  • Buffers: shared hit=9 read=31
Planning time : 0.802 ms