explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hhvq

Settings
# exclusive inclusive rows x rows loops node
1. 0.158 0.510 ↑ 5.0 1,000 1

Sort (cost=419.70..432.20 rows=5,000 width=8) (actual time=0.473..0.510 rows=1,000 loops=1)

  • Sort Key: b.b
  • Sort Method: quicksort Memory: 71kB
2. 0.105 0.352 ↑ 5.0 1,000 1

Nested Loop (cost=0.01..112.50 rows=5,000 width=8) (actual time=0.152..0.352 rows=1,000 loops=1)

3. 0.122 0.122 ↑ 5.0 1 1

Function Scan on generate_series a (cost=0.00..12.50 rows=5 width=4) (actual time=0.082..0.122 rows=1 loops=1)

  • Filter: (a = 40)
  • Rows Removed by Filter: 999
4. 0.125 0.125 ↑ 1.0 1,000 1

Function Scan on generate_series b (cost=0.00..10.00 rows=1,000 width=4) (actual time=0.069..0.125 rows=1,000 loops=1)

Planning time : 0.090 ms
Execution time : 0.584 ms