explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VWi1

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

Nested Loop (cost=6,007.08..13,478,533.56 rows=3,611,606 width=27) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on bucketsandcodes bac (cost=0.00..56.95 rows=13 width=6) (actual rows= loops=)

  • Filter: ((bucketname)::text = (bucketname)::text)
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on service_lines2018 sl (cost=6,007.08..1,033,974.78 rows=283,111 width=32) (actual rows= loops=)

  • Recheck Cond: (((dx_code_position)::text = '1'::text) AND ((procedure_cd)::text = (bac.hcpccode)::text))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on procedure_dx_code_postion (cost=0.00..5,936.30 rows=283,111 width=0) (actual rows= loops=)

  • Index Cond: (((dx_code_position)::text = '1'::text) AND ((procedure_cd)::text = (bac.hcpccode)::text))