explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SSVL

Settings
# exclusive inclusive rows x rows loops node
1. 43.833 274.116 ↑ 5,233.6 23 1

Gather Merge (cost=95,362.84..109,407.22 rows=120,372 width=20) (actual time=235.146..274.116 rows=23 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.059 230.283 ↑ 7,523.2 8 3 / 3

Sort (cost=94,362.81..94,513.28 rows=60,186 width=20) (actual time=230.282..230.283 rows=8 loops=3)

  • Sort Key: "d"."srvkey
  • Sort Method: quicksort Memory: 25kB
3. 0.020 230.224 ↑ 7,523.2 8 3 / 3

Nested Loop (cost=0.85..89,584.90 rows=60,186 width=20) (actual time=161.090..230.224 rows=8 loops=3)

4. 227.556 227.556 ↑ 7,523.2 8 3 / 3

Parallel Index Scan using "rsstuff_rsdvr_node_id_key" on "rsstuff_rsdvr" "r" (cost=0.42..26,713.90 rows=60,186 width=4) (actual time=161.044..227.556 rows=8 loops=3)

  • Filter: ("pod_id" = 37)
  • Rows Removed by Filter: 48
5. 2.648 2.648 ↑ 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=0.331..0.331 rows=1 loops=24)

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