explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fubi

Settings
# exclusive inclusive rows x rows loops node
1. 5.676 141,114.962 ↓ 75.5 16,315 1

Unique (cost=1,120,173.67..1,120,180.15 rows=216 width=44) (actual time=141,092.001..141,114.962 rows=16,315 loops=1)

2. 12.668 141,109.286 ↓ 102.7 22,176 1

GroupAggregate (cost=1,120,173.67..1,120,179.07 rows=216 width=44) (actual time=141,091.998..141,109.286 rows=22,176 loops=1)

  • Group Key: "TurnoversRest".endpoint, "TurnoversRest"."nomenclatureCode", "TurnoversRest".date, "TurnoversRest"."dateSupply
3. 138.674 141,096.618 ↓ 141.9 30,643 1

Sort (cost=1,120,173.67..1,120,174.21 rows=216 width=44) (actual time=141,091.984..141,096.618 rows=30,643 loops=1)

  • Sort Key: "TurnoversRest".endpoint, "TurnoversRest"."nomenclatureCode", "TurnoversRest".date, "TurnoversRest"."dateSupply
  • Sort Method: quicksort Memory: 5078kB
4. 1.960 140,957.944 ↓ 141.9 30,643 1

Gather (cost=1,005.27..1,120,165.29 rows=216 width=44) (actual time=14,166.027..140,957.944 rows=30,643 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
5. 3,429.649 140,955.984 ↓ 113.5 6,129 5

Nested Loop (cost=5.27..1,119,143.69 rows=54 width=44) (actual time=14,158.605..140,955.984 rows=6,129 loops=5)

6. 1,360.752 137,526.309 ↑ 2.0 128,262 5

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

  • Hash Cond: ("Turnovers".endpoint = "Endpoints".id)
7. 136,165.140 136,165.140 ↓ 1.1 7,270,495 5

Parallel Seq Scan on "Turnovers" (cost=0.00..901,007.73 rows=6,455,695 width=43) (actual time=0.311..136,165.140 rows=7,270,495 loops=5)

  • Filter: ("docType" = 3)
  • Rows Removed by Filter: 30169553
8. 0.018 0.417 ↑ 1.1 28 5

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
9. 0.399 0.399 ↑ 1.1 28 5

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

  • Index Cond: (client = '38ecbc48-663c-4416-8002-710cdb64693f'::uuid)
10. 0.026 0.026 ↓ 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.026..0.026 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