explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RxMt

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.113 ↑ 2.4 13 1

Unique (cost=4.20..4.43 rows=31 width=236) (actual time=0.109..0.113 rows=13 loops=1)

2. 0.109 0.109 ↑ 2.4 13 1

Sort (cost=4.20..4.28 rows=31 width=236) (actual time=0.108..0.109 rows=13 loops=1)

3. 0.063 0.063 ↑ 2.4 13 1

Hash Semi Join (cost=1.70..3.43 rows=31 width=236) (actual time=0.054..0.063 rows=13 loops=1)

4. 0.016 0.016 ↑ 1.0 31 1

Seq Scan on members (cost=0.00..1.31 rows=31 width=240) (actual time=0.014..0.016 rows=31 loops=1)

5. 0.020 0.020 ↑ 1.4 22 1

Hash (cost=1.31..1.31 rows=31 width=4) (actual time=0.020..0.020 rows=22 loops=1)

6. 0.012 0.012 ↑ 1.4 22 1

Seq Scan on members members_1 (cost=0.00..1.31 rows=31 width=4) (actual time=0.006..0.012 rows=22 loops=1)

Planning time : 0.239 ms
Execution time : 0.155 ms