explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8QRh

Settings
# exclusive inclusive rows x rows loops node
1. 14.117 136,463.294 ↓ 102.7 22,176 1

GroupAggregate (cost=1,120,173.67..1,120,179.07 rows=216 width=44) (actual time=136,443.101..136,463.294 rows=22,176 loops=1)

  • Group Key: "TurnoversRest".date, "TurnoversRest"."dateSupply", "TurnoversRest".endpoint, "TurnoversRest"."nomenclatureCode
2. 65.363 136,449.177 ↓ 141.9 30,643 1

Sort (cost=1,120,173.67..1,120,174.21 rows=216 width=44) (actual time=136,443.088..136,449.177 rows=30,643 loops=1)

  • Sort Key: "TurnoversRest".date, "TurnoversRest"."dateSupply", "TurnoversRest".endpoint, "TurnoversRest"."nomenclatureCode
  • Sort Method: quicksort Memory: 5078kB
3. 1.729 136,383.814 ↓ 141.9 30,643 1

Gather (cost=1,005.27..1,120,165.29 rows=216 width=44) (actual time=13,897.016..136,383.814 rows=30,643 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 3,551.684 136,382.085 ↓ 113.5 6,129 5

Nested Loop (cost=5.27..1,119,143.69 rows=54 width=44) (actual time=13,889.660..136,382.085 rows=6,129 loops=5)

5. 1,340.767 132,830.374 ↑ 2.0 128,262 5

Hash Semi Join (cost=4.70..920,766.20 rows=252,366 width=59) (actual time=1,464.578..132,830.374 rows=128,262 loops=5)

  • Hash Cond: ("Turnovers".endpoint = "Endpoints".id)
6. 131,489.216 131,489.216 ↓ 1.1 7,270,396 5

Parallel Seq Scan on "Turnovers" (cost=0.00..901,007.73 rows=6,455,695 width=43) (actual time=0.551..131,489.216 rows=7,270,396 loops=5)

  • Filter: ("docType" = 3)
  • Rows Removed by Filter: 30169483
7. 0.017 0.391 ↑ 1.1 28 5

Hash (cost=4.31..4.31 rows=31 width=16) (actual time=0.391..0.391 rows=28 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
8. 0.374 0.374 ↑ 1.1 28 5

Index Scan using "Endpoints_client_idx" on "Endpoints" (cost=0.28..4.31 rows=31 width=16) (actual time=0.065..0.374 rows=28 loops=5)

  • Index Cond: (client = '38ecbc48-663c-4416-8002-710cdb64693f'::uuid)
9. 0.027 0.027 ↓ 0.0 0 641,312

Index Scan using "TurnoversRest_endpoint_nomenclatureCode_idx" on "TurnoversRest" (cost=0.57..0.78 rows=1 width=56) (actual time=0.027..0.027 rows=0 loops=641,312)

  • Index Cond: ((endpoint = "Turnovers".endpoint) AND (("nomenclatureCode")::text = ("Turnovers"."nomenclatureCode")::text))
  • Filter: ("Turnovers".import = import)
  • Rows Removed by Filter: 16