explain.depesz.com

PostgreSQL's explain analyze made readable

Result: huP7

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 27,798.137 ↑ 1.0 1 1

Limit (cost=1,000.00..368,552.43 rows=1 width=310) (actual time=0.739..27,798.137 rows=1 loops=1)

  • Buffers: shared hit=1203 read=327589
2. 9,293.838 27,798.136 ↑ 1.0 1 1

Gather (cost=1,000.00..368,552.43 rows=1 width=310) (actual time=0.738..27,798.136 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1203 read=327589
3. 18,504.298 18,504.298 ↓ 0.0 0 3

Parallel Seq Scan on patient_cases_information (cost=0.00..367,552.33 rows=1 width=310) (actual time=18,504.298..18,504.298 rows=0 loops=3)

  • Filter: (srv_id = 155690353)
  • Rows Removed by Filter: 2480654
  • Buffers: shared hit=1203 read=327589
Planning time : 0.093 ms