explain.depesz.com

PostgreSQL's explain analyze made readable

Result: touE

Settings
# exclusive inclusive rows x rows loops node
1. 2.979 2,022.781 ↓ 593.2 4,746 1

GroupAggregate (cost=97,024.65..97,024.85 rows=8 width=44) (actual time=2,019.055..2,022.781 rows=4,746 loops=1)

  • Group Key: "TurnoversRest".date, "TurnoversRest"."dateSupply", "TurnoversRest".endpoint, "TurnoversRest"."nomenclatureCode
2. 12.731 2,019.802 ↓ 861.4 6,891 1

Sort (cost=97,024.65..97,024.67 rows=8 width=44) (actual time=2,019.043..2,019.802 rows=6,891 loops=1)

  • Sort Key: "TurnoversRest".date, "TurnoversRest"."dateSupply", "TurnoversRest"."nomenclatureCode
  • Sort Method: quicksort Memory: 1162kB
3. 487.697 2,007.071 ↓ 861.4 6,891 1

Merge Join (cost=90,872.57..97,024.53 rows=8 width=44) (actual time=1,219.302..2,007.071 rows=6,891 loops=1)

  • Merge Cond: (("TurnoversRest"."nomenclatureCode")::text = ("Turnovers"."nomenclatureCode")::text)
  • Join Filter: ("Turnovers".import = "TurnoversRest".import)
  • Rows Removed by Join Filter: 2238048
4. 47.088 47.088 ↓ 1.2 41,867 1

Index Scan using "TurnoversRest_endpoint_nomenclatureCode_idx" on "TurnoversRest" (cost=0.57..4,619.73 rows=36,389 width=56) (actual time=0.025..47.088 rows=41,867 loops=1)

  • Index Cond: (endpoint = '111ccc0a-d90a-4f8a-a02a-971946fe657f'::uuid)
5. 773.629 1,472.286 ↓ 17.9 2,250,821 1

Sort (cost=90,868.97..91,183.15 rows=125,671 width=43) (actual time=1,219.001..1,472.286 rows=2,250,821 loops=1)

  • Sort Key: "Turnovers"."nomenclatureCode
  • Sort Method: quicksort Memory: 22694kB
6. 698.657 698.657 ↓ 1.2 145,505 1

Index Scan using "Turnovers_endpoint_docDate_idx" on "Turnovers" (cost=0.57..80,225.08 rows=125,671 width=43) (actual time=0.887..698.657 rows=145,505 loops=1)

  • Index Cond: (endpoint = '111ccc0a-d90a-4f8a-a02a-971946fe657f'::uuid)
  • Filter: ("docType" = 3)
  • Rows Removed by Filter: 799156