explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3m1v

Settings
# exclusive inclusive rows x rows loops node
1. 16,084.953 50,485.191 ↑ 1.0 58,110,390 1

Nested Loop (cost=0.00..1,366,189.79 rows=58,110,390 width=174) (actual time=13.326..50,485.191 rows=58,110,390 loops=1)

2. 16,520.118 16,520.118 ↑ 1.0 298,002 1

Seq Scan on demo_groups d (cost=0.00..58,706.02 rows=298,002 width=1,218) (actual time=13.311..16,520.118 rows=298,002 loops=1)

3. 17,880.120 17,880.120 ↑ 1.0 195 298,002

Values Scan on "*VALUES*" (cost=0.00..2.44 rows=195 width=64) (actual time=0.000..0.060 rows=195 loops=298,002)