explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3tai : no ordering

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.133 ↑ 1.0 10 1

Limit (cost=0.99..106.52 rows=10 width=361) (actual time=0.063..0.133 rows=10 loops=1)

  • Buffers: shared hit=54
2. 0.013 0.128 ↑ 16,722.0 10 1

Nested Loop Left Join (cost=0.99..1,764,557.60 rows=167,220 width=361) (actual time=0.062..0.128 rows=10 loops=1)

  • Buffers: shared hit=54
3. 0.065 0.065 ↑ 16,722.0 10 1

Index Scan using rights_proposedrelations_admin_id_primary_status__c3a99605_idx on rights_proposedrelationship (cost=0.56..615,700.60 rows=167,220 width=281) (actual time=0.051..0.065 rows=10 loops=1)

  • Index Cond: ((admin_id = 7) AND ("primary" = true) AND ((status)::text = 'PROPOSED'::text) AND (in_catalog = false) AND (score >= 0.85000))
  • Filter: ("primary" AND (NOT in_catalog))
  • Buffers: shared hit=14
4. 0.050 0.050 ↑ 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.005..0.005 rows=1 loops=10)

  • Index Cond: (rights_proposedrelationship.instance_id = id)
  • Buffers: shared hit=40