explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GfJN

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

Limit (cost=591,012.71..591,012.73 rows=10 width=100) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=591,012.71..591,012.92 rows=83 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=591,010.08..591,010.91 rows=83 width=100) (actual rows= loops=)

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

Hash Join (cost=3,562.37..539,504.58 rows=824,088 width=8) (actual rows= loops=)

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

Hash Join (cost=7.07..524,266.33 rows=917,887 width=12) (actual rows= loops=)

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

Seq Scan on file_tracing ft (cost=0.00..487,328.65 rows=7,400,465 width=12) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

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

8. 0.000 0.000 ↓ 0.0

Seq Scan on data_source ds (cost=0.00..6.87 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[]))
9. 0.000 0.000 ↓ 0.0

Hash (cost=3,533.77..3,533.77 rows=1,722 width=4) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on data_source_location dsl (cost=0.00..3,533.77 rows=1,722 width=4) (actual rows= loops=)

  • Filter: ((server_name = 'MESOS'::text) AND (deletion = 0))