explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d9R

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

Nested Loop (cost=10.03..130,743.31 rows=309 width=100) (actual time=160.068..160.068 rows=0 loops=1)

2. 0.000 160.068 ↓ 0.0 0 1

Nested Loop (cost=1.42..128,075.87 rows=309 width=68) (actual time=160.068..160.068 rows=0 loops=1)

3. 17.863 63.805 ↓ 3.1 33,291 1

Nested Loop (cost=1.00..123,206.69 rows=10,742 width=57) (actual time=0.034..63.805 rows=33,291 loops=1)

4. 3.046 3.046 ↓ 2.8 6,128 1

Index Scan using fin_bill_cases_bill_id_ix on fin_bill_cases c (cost=0.43..2,287.99 rows=2,167 width=41) (actual time=0.021..3.046 rows=6,128 loops=1)

  • Index Cond: (bill_id = 33875)
5. 42.896 42.896 ↑ 9.8 5 6,128

Index Scan using sr_srv_rendered_md_case_ix on sr_srv_rendered s (cost=0.57..55.31 rows=49 width=20) (actual time=0.004..0.007 rows=5 loops=6,128)

  • Index Cond: (md_case_id = c.case_id)
6. 99.873 99.873 ↓ 0.0 0 33,291

Index Scan using sr_service_pk on sr_service v (cost=0.42..0.44 rows=1 width=15) (actual time=0.003..0.003 rows=0 loops=33,291)

  • Index Cond: (id = s.service_id)
  • Filter: ((code)::text ~ '^Onko(Stad|Tumor|Nodus|Metast|Gist|Mark|Ds|Tip|Cons|MTSTZ|Sod|DtDiag|Pov|Rslt|Antr|Kfr|Pptr)'::text)
  • Rows Removed by Filter: 1
7. 0.000 0.000 ↓ 0.0 0

Limit (cost=8.60..8.61 rows=1 width=36) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Sort (cost=8.60..8.61 rows=1 width=36) (never executed)

  • Sort Key: ((s_1.region_data -> 'idcase'::text)) DESC
9. 0.000 0.000 ↓ 0.0 0

Index Scan using fin_bill_steps_bill_id_case_id_idx on fin_bill_steps s_1 (cost=0.56..8.59 rows=1 width=36) (never executed)

  • Index Cond: ((bill_id = c.bill_id) AND (case_id = c.case_id))