explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JVsP

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

Aggregate (cost=29,970.89..29,970.90 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17,901.85..29,970.89 rows=1 width=0) (actual rows= loops=)

  • Join Filter: (a.record_id = az.agency_id)
3. 0.000 0.000 ↓ 0.0

Merge Join (cost=17,901.43..28,275.59 rows=3,385 width=9) (actual rows= loops=)

  • Merge Cond: (a.arc_region_code = reg.code)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17,888.14..323,320.79 rows=804,153 width=19) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=35.97..89,354.41 rows=1 width=14) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=35.83..89,351.74 rows=1 width=10) (actual rows= loops=)

  • Join Filter: (a.regional_chapter_code = (ra.chapter_code)::bpchar)
7. 0.000 0.000 ↓ 0.0

Index Scan using idx_agency_dbs_arc_region_code on agency_dbs a (cost=0.41..81,606.61 rows=645 width=16) (actual rows= loops=)

  • Filter: (serverid = 'os186'::bpchar)
8. 0.000 0.000 ↓ 0.0

Materialize (cost=35.41..1,506.37 rows=645 width=1) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on agency_dbs ra (cost=35.41..1,503.14 rows=645 width=1) (actual rows= loops=)

  • Recheck Cond: (serverid = 'os186'::bpchar)
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_agency_dbs_serverid (cost=0.00..35.25 rows=645 width=0) (actual rows= loops=)

  • Index Cond: (serverid = 'os186'::bpchar)
11. 0.000 0.000 ↓ 0.0

Index Only Scan using arc_division_code_pk on arc_division div (cost=0.14..2.66 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((code = 'D21'::bpchar) AND (serverid = 'os186'::bpchar))
12. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fb_client c (cost=17,852.17..224,399.62 rows=956,676 width=5) (actual rows= loops=)

  • Recheck Cond: (serverid = 'os186'::bpchar)
13. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_public_fb_client_serverid (cost=0.00..17,613.00 rows=956,676 width=0) (actual rows= loops=)

  • Index Cond: (serverid = 'os186'::bpchar)
14. 0.000 0.000 ↓ 0.0

Sort (cost=13.29..13.33 rows=14 width=10) (actual rows= loops=)

  • Sort Key: reg.code
15. 0.000 0.000 ↓ 0.0

Seq Scan on arc_region reg (cost=0.00..13.02 rows=14 width=10) (actual rows= loops=)

  • Filter: (((arc_division_code)::bpchar = 'D21'::bpchar) AND (serverid = 'os186'::bpchar))
16. 0.000 0.000 ↓ 0.0

Index Scan using idx_agency_zip_zip on agency_zip az (cost=0.42..0.49 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (zip = (c.zip)::bpchar)
  • Filter: (serverid = 'os186'::bpchar)