explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PlUw

Settings
# exclusive inclusive rows x rows loops node
1. 23,148.877 43,237.569 ↓ 4.9 236,671 1

Hash Left Join (cost=183.96..259,613.15 rows=48,044 width=637) (actual time=2.689..43,237.569 rows=236,671 loops=1)

  • Hash Cond: (d.publisher_organisation_id = oef.organisation_id)
2. 86.480 20,087.938 ↓ 23.8 101,243 1

Hash Join (cost=123.11..64,602.50 rows=4,254 width=425) (actual time=1.664..20,087.938 rows=101,243 loops=1)

  • Hash Cond: (d.impact_score = ei.impact_score)
3. 90.109 20,001.447 ↓ 23.8 101,244 1

Hash Join (cost=105.45..64,573.54 rows=4,254 width=337) (actual time=1.642..20,001.447 rows=101,244 loops=1)

  • Hash Cond: (d.responsible_org_orgref = resporg.swa_org_ref)
4. 114.024 19,910.519 ↓ 23.8 101,261 1

Hash Join (cost=53.00..64,509.89 rows=4,254 width=315) (actual time=0.817..19,910.519 rows=101,261 loops=1)

  • Hash Cond: (d.publisher_orgref = publisher.swa_org_ref)
5. 72.477 19,795.714 ↓ 23.9 101,534 1

Nested Loop (cost=0.55..64,446.23 rows=4,254 width=293) (actual time=0.030..19,795.714 rows=101,534 loops=1)

6. 0.045 0.045 ↓ 31.0 31 1

Seq Scan on entity_category ecat (cost=0.00..10.50 rows=1 width=118) (actual time=0.004..0.045 rows=31 loops=1)

  • Filter: ((entitygroupid)::text = 'RW'::text)
  • Rows Removed by Filter: 61
7. 19,723.192 19,723.192 ↑ 1.3 3,275 31

Index Scan using idx_entity_category on entity d (cost=0.55..64,393.19 rows=4,254 width=301) (actual time=1.001..636.232 rows=3,275 loops=31)

  • Index Cond: ((entity_category)::text = (ecat.nsa_code)::text)
  • Filter: (active AND (tm__entity_id_sw_xref IS NULL) AND (entity_type > 1))
  • Rows Removed by Filter: 21898
8. 0.388 0.781 ↑ 1.0 1,309 1

Hash (cost=36.09..36.09 rows=1,309 width=26) (actual time=0.781..0.781 rows=1,309 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 82kB
9. 0.393 0.393 ↑ 1.0 1,309 1

Seq Scan on orgref publisher (cost=0.00..36.09 rows=1,309 width=26) (actual time=0.002..0.393 rows=1,309 loops=1)

10. 0.389 0.819 ↑ 1.0 1,309 1

Hash (cost=36.09..36.09 rows=1,309 width=26) (actual time=0.819..0.819 rows=1,309 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 82kB
11. 0.430 0.430 ↑ 1.0 1,309 1

Seq Scan on orgref resporg (cost=0.00..36.09 rows=1,309 width=26) (actual time=0.003..0.430 rows=1,309 loops=1)

12. 0.004 0.011 ↑ 68.0 5 1

Hash (cost=13.40..13.40 rows=340 width=92) (actual time=0.011..0.011 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
13. 0.007 0.007 ↑ 68.0 5 1

Seq Scan on eton_impact ei (cost=0.00..13.40 rows=340 width=92) (actual time=0.005..0.007 rows=5 loops=1)

14. 0.157 0.754 ↑ 5.2 437 1

Hash (cost=32.60..32.60 rows=2,260 width=8) (actual time=0.754..0.754 rows=437 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 50kB
15. 0.597 0.597 ↑ 5.2 437 1

Seq Scan on organisation_extended_funcs oef (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.474..0.597 rows=437 loops=1)