explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wF23 : Alarm

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 112.088 ↑ 1.0 100 1

Limit (cost=0.57..851.15 rows=100 width=21) (actual time=98.344..112.088 rows=100 loops=1)

2. 112.081 112.081 ↑ 15,721.0 100 1

Index Scan using aisdataentity_pkey on aisdataentity (cost=0.57..13,371,972.89 rows=1,572,099 width=21) (actual time=98.342..112.081 rows=100 loops=1)

  • Filter: ((alarmtype)::text = 'PARAMETER'::text)
  • Rows Removed by Filter: 6235