explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yhEn

Settings
# exclusive inclusive rows x rows loops node
1. 6.213 128.827 ↑ 1.0 10 1

Limit (cost=530,422.18..530,467.29 rows=10 width=361) (actual time=111.272..128.827 rows=10 loops=1)

  • Buffers: shared hit=23 read=26387, temp read=17 written=1200
2. 0.000 122.614 ↑ 13,935.0 10 1

Nested Loop Left Join (cost=530,422.18..1,159,021.38 rows=139,350 width=361) (actual time=111.270..122.614 rows=10 loops=1)

  • Buffers: shared hit=10 read=10807, temp read=1 written=487
3. 0.000 117.477 ↑ 13,935.0 10 1

Gather Merge (cost=530,421.74..546,680.38 rows=139,350 width=281) (actual time=111.231..117.477 rows=10 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=13 read=26357, temp read=17 written=1200
4. 51.843 324.207 ↑ 483.9 144 3

Sort (cost=529,421.72..529,595.91 rows=69,675 width=281) (actual time=108.019..108.069 rows=144 loops=3)

  • Sort Key: rights_proposedrelationship.views DESC
  • Sort Method: external sort Disk: 3896kB
  • Buffers: shared hit=13 read=26357, temp read=17 written=1200
5. 258.331 272.364 ↑ 6.4 10,894 3

Parallel Bitmap Heap Scan on rights_proposedrelationship (cost=7,228.72..514,527.94 rows=69,675 width=281) (actual time=18.895..90.788 rows=10,894 loops=3)

  • Recheck Cond: ((admin_id = 7) AND ((status)::text = 'PROPOSED'::text) AND (score >= 0.85000))
  • Filter: ("primary" AND (NOT in_catalog))
  • Heap Blocks: exact=10576
  • Buffers: shared read=26356
6. 14.033 14.033 ↑ 5.1 32,681 1

Bitmap Index Scan on rights_proposedrelations_admin_id_primary_status__c3a99605_idx (cost=0.00..7,186.91 rows=167,220 width=0) (actual time=14.033..14.033 rows=32,681 loops=1)

  • Index Cond: ((admin_id = 7) AND ("primary" = true) AND ((status)::text = 'PROPOSED'::text) AND (in_catalog = false) AND (score >= 0.85000))
  • Buffers: shared read=201
7. 11.260 11.260 ↑ 1.0 1 10

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

  • Index Cond: (rights_proposedrelationship.instance_id = id)
  • Buffers: shared hit=10 read=30