explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rJ3v

Settings
# exclusive inclusive rows x rows loops node
1. 24.524 58.121 ↑ 5.7 5,665 1

Sort (cost=33,940.16..34,020.23 rows=32,029 width=1,443) (actual time=55.836..58.121 rows=5,665 loops=1)

  • Sort Key: "DockGroup".created_at DESC
  • Sort Method: external merge Disk: 3360kB
2. 4.049 33.597 ↑ 5.7 5,665 1

Hash Left Join (cost=10,860.05..11,397.26 rows=32,029 width=1,443) (actual time=18.886..33.597 rows=5,665 loops=1)

  • Hash Cond: ("DockGroup".id = controller.dock_group_id)
3. 4.688 11.328 ↓ 1.2 5,665 1

Hash Right Join (cost=61.47..467.17 rows=4,558 width=1,107) (actual time=0.631..11.328 rows=5,665 loops=1)

  • Hash Cond: (docks.dock_group_id = "DockGroup".id)
4. 6.057 6.057 ↓ 1.0 12,001 1

Seq Scan on dock docks (cost=0.00..315.19 rows=11,983 width=101) (actual time=0.017..6.057 rows=12,001 loops=1)

  • Filter: ((deleted_at > '2019-03-13 10:18:56.389+00'::timestamp with time zone) OR (deleted_at IS NULL))
  • Rows Removed by Filter: 672
5. 0.161 0.583 ↓ 1.1 252 1

Hash (cost=58.47..58.47 rows=240 width=1,006) (actual time=0.583..0.583 rows=252 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 122kB
6. 0.422 0.422 ↓ 1.1 252 1

Seq Scan on dock_group "DockGroup" (cost=0.00..58.47 rows=240 width=1,006) (actual time=0.035..0.422 rows=252 loops=1)

  • Filter: (((deleted_at > '2019-03-13 10:18:56.389+00'::timestamp with time zone) OR (deleted_at IS NULL)) AND ((system_id)::text = 'oslobysykkel'::text))
  • Rows Removed by Filter: 380
7. 0.423 18.220 ↑ 17.4 255 1

Hash (cost=10,743.16..10,743.16 rows=4,434 width=282) (actual time=18.220..18.220 rows=255 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 95kB
8. 17.797 17.797 ↑ 1.0 4,434 1

Seq Scan on hardware_controller controller (cost=0.00..10,743.16 rows=4,434 width=282) (actual time=0.012..17.797 rows=4,434 loops=1)

  • Filter: ((deleted_at > '2019-03-13 10:18:56.389+00'::timestamp with time zone) OR (deleted_at IS NULL))
  • Rows Removed by Filter: 219