explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OyOX

Settings
# exclusive inclusive rows x rows loops node
1. 256.946 394.063 ↓ 1.0 24,158 1

Sort (cost=4,461.09..4,521.31 rows=24,086 width=125) (actual time=373.187..394.063 rows=24,158 loops=1)

  • Sort Key: lk.sort_order, lk.description
  • Sort Method: external merge Disk: 4,384kB
2. 75.477 137.117 ↓ 1.0 24,158 1

WindowAgg (cost=1,062.85..2,708.12 rows=24,086 width=125) (actual time=73.044..137.117 rows=24,158 loops=1)

3. 10.272 61.640 ↓ 1.0 24,158 1

Hash Left Join (cost=1,062.85..2,346.83 rows=24,086 width=83) (actual time=26.714..61.640 rows=24,158 loops=1)

  • Hash Cond: (lk.lookup_gender_id = l2.id)
4. 24.890 24.890 ↓ 1.0 24,158 1

Seq Scan on lookup_title lk (cost=0.00..1,220.75 rows=24,086 width=69) (actual time=0.078..24.890 rows=24,158 loops=1)

  • Filter: (active AND (tenant_id = 'd6cd45bb-7717-480d-b189-b789caad692b'::uuid))
  • Rows Removed by Filter: 14,462
5. 9.946 26.478 ↑ 1.0 27,371 1

Hash (cost=720.71..720.71 rows=27,371 width=30) (actual time=26.478..26.478 rows=27,371 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,933kB
6. 16.532 16.532 ↑ 1.0 27,371 1

Seq Scan on lookup_gender l2 (cost=0.00..720.71 rows=27,371 width=30) (actual time=0.041..16.532 rows=27,371 loops=1)

Planning time : 65.729 ms
Execution time : 408.270 ms