explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LnFL : NNDI

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=227,240.55..227,240.84 rows=1 width=73) (actual rows= loops=)

  • Group Key: rlu1.lookupfull, (speciesdisplaynamefromcode(r.species)), loc.abbrev
2. 0.000 0.000 ↓ 0.0

Sort (cost=227,240.55..227,240.56 rows=1 width=53) (actual rows= loops=)

  • Sort Key: rlu1.lookupfull, (speciesdisplaynamefromcode(r.species)), loc.abbrev
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.30..227,240.54 rows=1 width=53) (actual rows= loops=)

  • Join Filter: ("substring"((r.location)::text, 1, 1) = (loc.locationcode)::text)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.30..227,022.94 rows=1 width=30) (actual rows= loops=)

  • Join Filter: (res1.resultvalue = (rlu1.id)::numeric)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.30..226,820.12 rows=1 width=21) (actual rows= loops=)

  • Join Filter: (r.id = res1.reportid)
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..219,364.37 rows=723 width=25) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using reports_idx_projectid on reports r (cost=0.43..8,877.84 rows=26,694 width=17) (actual rows= loops=)

  • Index Cond: (projectid = 30)
  • Filter: (NOT del)
8. 0.000 0.000 ↓ 0.0

Index Scan using results_idx_reportid on results res2 (cost=0.44..7.88 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reportid = r.id)
  • Filter: ((NOT del) AND (resulttypeid = 50))
9. 0.000 0.000 ↓ 0.0

Index Scan using results_idx_reportid on results res1 (cost=0.44..10.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reportid = res2.reportid)
  • Filter: ((NOT del) AND (resulttypeid = 9) AND (resultvalue = ANY ('{25,26,27,29,30,31,32,33,34,36,37,38,40,41,42,43,44,45,46,47,48,49,51,52,55,58,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,95,96,97,98,99,100,101,102,103,104,106,107,108,109,110,111,112,113,115,1358,1360,1361,1362,1363,1364,1365,1366,1368,1369,3057,3058,3059,3060,3061,3062,3066,5200,5201,5202,5205}'::numeric[])))
10. 0.000 0.000 ↓ 0.0

Seq Scan on resultlookup rlu1 (cost=0.00..123.13 rows=5,313 width=17) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on locations loc (cost=0.00..203.94 rows=894 width=9) (actual rows= loops=)