explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jEQU

Settings
# exclusive inclusive rows x rows loops node
1. 9.523 10,433.042 ↓ 1.1 64,599 1

Limit (cost=1,000.85..376,271.63 rows=60,807 width=3,857) (actual time=3.060..10,433.042 rows=64,599 loops=1)

2. 331.374 10,423.519 ↓ 1.1 64,599 1

Gather (cost=1,000.85..376,271.63 rows=60,807 width=3,857) (actual time=3.058..10,423.519 rows=64,599 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 160.078 10,092.145 ↑ 1.2 21,533 3 / 3

Nested Loop (cost=0.85..369,190.93 rows=25,336 width=3,857) (actual time=4.826..10,092.145 rows=21,533 loops=3)

4. 136.153 6,852.848 ↑ 1.2 21,533 3 / 3

Nested Loop (cost=0.43..353,514.55 rows=25,336 width=1,520) (actual time=3.273..6,852.848 rows=21,533 loops=3)

5. 3,615.655 3,615.655 ↑ 1.2 21,535 3 / 3

Parallel Seq Scan on bill_charge bc (cost=0.00..270,269.07 rows=25,336 width=811) (actual time=2.093..3,615.655 rows=21,535 loops=3)

  • Filter: ((charge_group)::text = 'OPE'::text)
  • Rows Removed by Filter: 1636847
6. 3,101.040 3,101.040 ↑ 1.0 1 64,605 / 3

Index Scan using bill_pkey on bill b (cost=0.43..3.29 rows=1 width=709) (actual time=0.144..0.144 rows=1 loops=64,605)

  • Index Cond: ((bill_no)::text = (bc.bill_no)::text)
7. 3,079.219 3,079.219 ↑ 1.0 1 64,599 / 3

Index Scan using patient_registration_pkey on patient_registration pr (cost=0.42..0.62 rows=1 width=2,337) (actual time=0.143..0.143 rows=1 loops=64,599)

  • Index Cond: ((patient_id)::text = (b.visit_id)::text)
Planning time : 3.739 ms
Execution time : 10,446.330 ms