explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w79s : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.149 0.438 ↑ 2.2 168 1

Sort (cost=188.73..189.67 rows=374 width=24) (actual time=0.403..0.438 rows=168 loops=1)

  • Sort Key: poi_id, mobject_id
  • Sort Method: quicksort Memory: 38kB
2. 0.289 0.289 ↑ 2.2 168 1

Index Scan using mps_direction_idx on mobject_poi_status (cost=0.41..172.75 rows=374 width=24) (actual time=0.035..0.289 rows=168 loops=1)

  • Index Cond: (direction = 1)
  • Filter: (mps_status = 'A'::bpchar)