explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X85p

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=58,194.88..58,194.90 rows=10 width=100) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=58,194.88..58,194.97 rows=39 width=100) (actual rows= loops=)

  • Sort Key: (sum(CASE WHEN (ft.status = 8) THEN 1 ELSE NULL::integer END)) DESC
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=58,193.64..58,194.03 rows=39 width=100) (actual rows= loops=)

  • Group Key: ft.data_source_id
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=45.06..51,171.20 rows=112,359 width=8) (actual rows= loops=)

  • Hash Cond: (ft.data_source_id = ds.id)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=43.14..49,018.66 rows=273,875 width=8) (actual rows= loops=)

  • Hash Cond: (ft.data_source_location_id = dsl.id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on file_tracing ft (cost=0.00..43,141.11 rows=825,511 width=12) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=41.38..41.38 rows=141 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on data_source_location dsl (cost=0.00..41.38 rows=141 width=4) (actual rows= loops=)

  • Filter: ((server_name = 'MESOS'::text) AND (deletion = 0))
9. 0.000 0.000 ↓ 0.0

Hash (cost=1.72..1.72 rows=16 width=4) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on data_source ds (cost=0.00..1.72 rows=16 width=4) (actual rows= loops=)

  • Filter: (id = ANY ('{21823,21822,21820,21819,21818,21817,21815,21814,21813,21812,21808,21807,21805,21804,21803,21794}'::integer[]))