explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lVBn

Settings
# exclusive inclusive rows x rows loops node
1. 0.062 266.591 ↑ 1.0 23 1

Sort (cost=730.28..730.34 rows=24 width=20) (actual time=266.589..266.591 rows=23 loops=1)

  • Sort Key: "d"."srvkey
  • Sort Method: quicksort Memory: 26kB
2. 0.132 266.529 ↑ 1.0 23 1

Nested Loop (cost=16.71..729.73 rows=24 width=20) (actual time=9.834..266.529 rows=23 loops=1)

3. 50.013 50.013 ↑ 1.0 24 1

Index Scan using "rsstuff_rsdvr_e9fabc39" on "rsstuff_rsdvr" "r" (cost=0.40..313.69 rows=24 width=4) (actual time=0.023..50.013 rows=24 loops=1)

  • Index Cond: ("pod_id" = 37)
4. 202.512 216.384 ↑ 1.0 1 24

Bitmap Heap Scan on "datacenters_node" "d" (cost=16.32..17.33 rows=1 width=20) (actual time=9.016..9.016 rows=1 loops=24)

  • Recheck Cond: ("id" = "r"."node_id")
  • Filter: ("srvkey" <> 'f6efdec6-7652-4d95-a2ef-2143464a78b4'::"uuid")
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=116,201
5. 13.872 13.872 ↓ 4,868.0 4,868 24

Bitmap Index Scan on "datacenters_node_pkey" (cost=0.00..16.32 rows=1 width=0) (actual time=0.578..0.578 rows=4,868 loops=24)

  • Index Cond: ("id" = "r"."node_id")