explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LldOO

Settings
# exclusive inclusive rows x rows loops node
1. 31.996 104,497.949 ↑ 1.0 1 1

Sort (cost=2,065,282.95..2,065,282.95 rows=1 width=341) (actual time=104,497.944..104,497.949 rows=1 loops=1)

  • Sort Key: incidents.incidenttime DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=129700 read=818671
2. 0.030 104,465.953 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.00..2,065,282.94 rows=1 width=341) (actual time=74,886.572..104,465.953 rows=1 loops=1)

  • Join Filter: (incidenttypes.incidenttypeid = incidents.incidenttypeid)
  • Rows Removed by Join Filter: 6
  • Buffers: shared hit=129700 read=818671
3. 104,464.973 104,464.973 ↑ 1.0 1 1

Seq Scan on incidents (cost=0.00..2,065,281.78 rows=1 width=95) (actual time=74,885.606..104,464.973 rows=1 loops=1)

  • Filter: ((incidenttime >= '2019-01-07 08:15:01+03'::timestamp with time zone) AND (incidenttime <= '2019-01-07 08:16:01+03'::timestamp with time zone) AND (incidenttypeid <> ALL ('{2,6}'::integer[])) AND (sensorid = 0))
  • Rows Removed by Filter: 55842686
  • Buffers: shared hit=129700 read=818670
4. 0.950 0.950 ↑ 1.0 7 1

Seq Scan on incidenttypes (cost=0.00..1.07 rows=7 width=238) (actual time=0.945..0.950 rows=7 loops=1)

  • Buffers: shared read=1