explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DvFe

Settings
# exclusive inclusive rows x rows loops node
1. 36.578 93.367 ↑ 5,242.1 23 1

Gather Merge (cost=93,367.23..107,434.48 rows=120,568 width=20) (actual time=72.217..93.367 rows=23 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.052 56.789 ↑ 7,535.5 8 3 / 3

Sort (cost=92,367.21..92,517.92 rows=60,284 width=20) (actual time=56.788..56.789 rows=8 loops=3)

  • Sort Key: "d"."srvkey
  • Sort Method: quicksort Memory: 26kB
3. 0.021 56.737 ↑ 7,535.5 8 3 / 3

Nested Loop (cost=0.85..87,580.81 rows=60,284 width=20) (actual time=20.747..56.737 rows=8 loops=3)

4. 44.668 44.668 ↑ 7,535.5 8 3 / 3

Parallel Index Only Scan using "caseytemp1" on "rsstuff_rsdvr" "r" (cost=0.42..24,615.07 rows=60,284 width=4) (actual time=8.797..44.668 rows=8 loops=3)

  • Index Cond: ("pod_id" = 37)
  • Heap Fetches: 42514
5. 12.048 12.048 ↑ 1.0 1 24 / 3

Index Scan using "datacenters_node_pkey" on "datacenters_node" "d" (cost=0.43..1.04 rows=1 width=20) (actual time=1.506..1.506 rows=1 loops=24)

  • Index Cond: ("id" = "r"."node_id")
  • Filter: ("srvkey" <> 'f6efdec6-7652-4d95-a2ef-2143464a78b4'::"uuid")
  • Rows Removed by Filter: 0