explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wu2L

Settings
# exclusive inclusive rows x rows loops node
1. 335.331 953.731 ↑ 17.8 51 1

Hash Join (cost=33,013.78..132,293.51 rows=907 width=4) (actual time=809.199..953.731 rows=51 loops=1)

  • Hash Cond: (pm.sejour_id = s.id)
  • Join Filter: ((pm.qui = 3761) OR (s.medecin_id = 1328))
  • Rows Removed by Join Filter: 5685
2. 306.442 306.442 ↓ 1.0 1,358,834 1

Seq Scan on prescription_medic pm (cost=0.00..69,253.52 rows=1,356,552 width=12) (actual time=0.002..306.442 rows=1,358,834 loops=1)

3. 84.249 311.958 ↑ 1.0 438,956 1

Hash (cost=25,753.01..25,753.01 rows=442,541 width=8) (actual time=311.958..311.958 rows=438,956 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 3184kB
4. 227.709 227.709 ↑ 1.0 438,956 1

Seq Scan on sejour s (cost=0.00..25,753.01 rows=442,541 width=8) (actual time=0.004..227.709 rows=438,956 loops=1)

  • Filter: ((etat)::text = ANY ('{PRESENT,RESERVE}'::text[]))
  • Rows Removed by Filter: 374478
Planning time : 0.464 ms
Execution time : 953.771 ms