explain.depesz.com

A tool for finding a real cause for slow queries.

Result: CfN

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 27.613 ↑ 1.0 1 1

SetOp Intersect (cost=1,460.98..1,470.85 rows=1 width=268) (actual time=26.539..27.613 rows=1 loops=1)

2. 26.785 26.785 ↑ 1.0 188 1

Sort (cost=1,460.98..1,461.45 rows=188 width=268) (actual time=26.499..26.785 rows=188 loops=1)

3. 25.366 25.366 ↑ 1.0 188 1

Append (cost=0.00..1,453.88 rows=188 width=268) (actual time=0.146..25.366 rows=188 loops=1)

4. 13.409 13.409 ↑ 1.0 1 1

Subquery Scan on "*SELECT* 2" (cost=0.00..726.01 rows=1 width=268) (actual time=0.143..13.409 rows=1 loops=1)

5. 13.399 13.399 ↑ 1.0 1 1

Seq Scan on customers (cost=0.00..726.00 rows=1 width=268) (actual time=0.137..13.399 rows=1 loops=1)

6. 11.384 11.384 ↑ 1.0 187 1

Subquery Scan on "*SELECT* 1" (cost=0.00..727.87 rows=187 width=268) (actual time=0.070..11.384 rows=187 loops=1)

7. 10.544 10.544 ↑ 1.0 187 1

Seq Scan on customers (cost=0.00..726.00 rows=187 width=268) (actual time=0.062..10.544 rows=187 loops=1)