explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rlSo

Settings
# exclusive inclusive rows x rows loops node
1. 10,597.653 48,476.296 ↑ 1.0 1 1

Aggregate (cost=175,658,331,000,177,518,706,688.00..175,658,331,000,177,518,706,688.00 rows=1 width=8) (actual time=48,476.296..48,476.296 rows=1 loops=1)

2. 24,043.294 37,878.643 ↑ 117,033,789,351,264,256.0 100,000,000 1

Nested Loop (cost=0.00..146,399,883,662,361,471,483,904.00 rows=11,703,378,935,126,425,600,000,000 width=0) (actual time=0.026..37,878.643 rows=100,000,000 loops=1)

3. 2,455.588 3,835.349 ↑ 860,542,568,759,296.0 10,000,000 1

Nested Loop (cost=0.00..107,646,973,281,148,141,568.00 rows=8,605,425,687,592,960,000,000 width=0) (actual time=0.025..3,835.349 rows=10,000,000 loops=1)

4. 240.185 379.761 ↑ 6,327,518,887,936.0 1,000,000 1

Nested Loop (cost=0.00..79,152,186,236,138,480.00 rows=6,327,518,887,936,000,000 width=0) (actual time=0.022..379.761 rows=1,000,000 loops=1)

5. 24.602 39.576 ↑ 46,525,874,176.0 100,000 1

Nested Loop (cost=0.00..58,200,136,938,451.60 rows=4,652,587,417,600,000 width=0) (actual time=0.020..39.576 rows=100,000 loops=1)

6. 2.905 4.974 ↑ 342,102,016.0 10,000 1

Nested Loop (cost=0.00..42,794,218,424.60 rows=3,421,020,160,000 width=0) (actual time=0.019..4.974 rows=10,000 loops=1)

7. 0.466 1.069 ↑ 2,515,456.0 1,000 1

Nested Loop (cost=0.00..31,466,397.60 rows=2,515,456,000 width=0) (actual time=0.017..1.069 rows=1,000 loops=1)

8. 0.142 0.303 ↑ 18,496.0 100 1

Nested Loop (cost=0.00..23,170.60 rows=1,849,600 width=0) (actual time=0.015..0.303 rows=100 loops=1)

9. 0.031 0.031 ↑ 136.0 10 1

Seq Scan on test t1 (cost=0.00..23.60 rows=1,360 width=0) (actual time=0.009..0.031 rows=10 loops=1)

10. 0.108 0.130 ↑ 136.0 10 10

Materialize (cost=0.00..30.40 rows=1,360 width=0) (actual time=0.001..0.013 rows=10 loops=10)

11. 0.022 0.022 ↑ 136.0 10 1

Seq Scan on test t2 (cost=0.00..23.60 rows=1,360 width=0) (actual time=0.002..0.022 rows=10 loops=1)

12. 0.296 0.300 ↑ 136.0 10 100

Materialize (cost=0.00..30.40 rows=1,360 width=0) (actual time=0.000..0.003 rows=10 loops=100)

13. 0.004 0.004 ↑ 136.0 10 1

Seq Scan on test t3 (cost=0.00..23.60 rows=1,360 width=0) (actual time=0.001..0.004 rows=10 loops=1)

14. 0.997 1.000 ↑ 136.0 10 1,000

Materialize (cost=0.00..30.40 rows=1,360 width=0) (actual time=0.000..0.001 rows=10 loops=1,000)

15. 0.003 0.003 ↑ 136.0 10 1

Seq Scan on test t4 (cost=0.00..23.60 rows=1,360 width=0) (actual time=0.001..0.003 rows=10 loops=1)

16. 9.997 10.000 ↑ 136.0 10 10,000

Materialize (cost=0.00..30.40 rows=1,360 width=0) (actual time=0.000..0.001 rows=10 loops=10,000)

17. 0.003 0.003 ↑ 136.0 10 1

Seq Scan on test t5 (cost=0.00..23.60 rows=1,360 width=0) (actual time=0.001..0.003 rows=10 loops=1)

18. 99.998 100.000 ↑ 136.0 10 100,000

Materialize (cost=0.00..30.40 rows=1,360 width=0) (actual time=0.000..0.001 rows=10 loops=100,000)

19. 0.002 0.002 ↑ 136.0 10 1

Seq Scan on test t6 (cost=0.00..23.60 rows=1,360 width=0) (actual time=0.001..0.002 rows=10 loops=1)

20. 999.997 1,000.000 ↑ 136.0 10 1,000,000

Materialize (cost=0.00..30.40 rows=1,360 width=0) (actual time=0.000..0.001 rows=10 loops=1,000,000)

21. 0.003 0.003 ↑ 136.0 10 1

Seq Scan on test t7 (cost=0.00..23.60 rows=1,360 width=0) (actual time=0.001..0.003 rows=10 loops=1)

22. 9,999.997 10,000.000 ↑ 136.0 10 10,000,000

Materialize (cost=0.00..30.40 rows=1,360 width=0) (actual time=0.000..0.001 rows=10 loops=10,000,000)

23. 0.003 0.003 ↑ 136.0 10 1

Seq Scan on test t8 (cost=0.00..23.60 rows=1,360 width=0) (actual time=0.001..0.003 rows=10 loops=1)