explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 49Po

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1,483.180 ↑ 1.0 1 1

Aggregate (cost=147,913.430..147,913.440 rows=1 width=8) (actual time=1,483.180..1,483.180 rows=1 loops=1)

2. 0.000 1,483.174 ↓ 0.0 0 1

Limit (cost=4,508.230..147,913.410 rows=2 width=9) (actual time=1,483.174..1,483.174 rows=0 loops=1)

3. 5.831 1,484.858 ↓ 0.0 0 1

Gather (cost=4,508.230..147,913.410 rows=2 width=9) (actual time=1,483.172..1,484.858 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 18.280 1,479.027 ↓ 0.0 0 3

Hash Join (cost=3,508.230..146,913.210 rows=1 width=9) (actual time=1,479.026..1,479.027 rows=0 loops=3)

  • Hash Cond: (whiskey.bravo = mike_romeo.juliet)
5. 209.692 1,460.656 ↑ 1.3 48,628 3

Nested Loop (cost=3,436.880..146,682.230 rows=60,805 width=8) (actual time=41.759..1,460.656 rows=48,628 loops=3)

6. 601.980 1,250.961 ↑ 1.3 48,628 3

Parallel Hash Join (cost=3,436.450..107,500.530 rows=60,805 width=24) (actual time=41.732..1,250.961 rows=48,628 loops=3)

  • Hash Cond: (lima.quebec_seven = whiskey.victor)
7. 607.803 607.803 ↑ 1.2 1,488,100 3

Parallel Seq Scan on lima (cost=0.000..99,181.250 rows=1,860,125 width=16) (actual time=0.008..607.803 rows=1,488,100 loops=3)

8. 22.353 41.178 ↑ 1.8 48,628 3

Parallel Hash (cost=2,363.420..2,363.420 rows=85,842 width=24) (actual time=41.178..41.178 rows=48,628 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 10112kB
9. 18.825 18.825 ↑ 1.8 48,628 3

Parallel Seq Scan on whiskey (cost=0.000..2,363.420 rows=85,842 width=24) (actual time=0.005..18.825 rows=48,628 loops=3)

10. 0.003 0.003 ↑ 1.0 1 145,885

Index Scan using india_seven on golf (cost=0.430..0.640 rows=1 width=104) (actual time=0.003..0.003 rows=1 loops=145,885)

  • Index Cond: (india_juliet = lima.quebec_seven)
11. 0.009 0.091 ↓ 14.0 14 3

Hash (cost=71.340..71.340 rows=1 width=8) (actual time=0.091..0.091 rows=14 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.016 0.082 ↓ 14.0 14 3

Bitmap Heap Scan on quebec_foxtrot mike_romeo (cost=67.290..71.340 rows=1 width=8) (actual time=0.073..0.082 rows=14 loops=3)

  • Recheck Cond: ((papa = 1540) AND ((zulu = 154200) OR (zulu = 154201) OR (zulu = 154202) OR (zulu = 154203) OR (zulu = 154204) OR (zulu = 154205) OR (zulu = 154206) OR (zulu = 154207) OR (zulu = 154208) OR (zulu = 154209) OR (zulu = 154210) OR (zulu = 154211) OR (zulu = 154212) OR (zulu = 154213)))
  • Heap Blocks: exact=2
13. 0.004 0.066 ↓ 0.0 0 3

BitmapAnd (cost=67.290..67.290 rows=1 width=0) (actual time=0.065..0.066 rows=0 loops=3)

14. 0.026 0.026 ↓ 1.1 80 3

Bitmap Index Scan on tango (cost=0.000..4.980 rows=75 width=0) (actual time=0.026..0.026 rows=80 loops=3)

  • Index Cond: (papa = 1540)
15. 0.000 0.036 ↓ 0.0 0 3

BitmapOr (cost=62.060..62.060 rows=23 width=0) (actual time=0.036..0.036 rows=0 loops=3)

16. 0.006 0.006 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.006..0.006 rows=1 loops=3)

  • Index Cond: (zulu = 154200)
17. 0.008 0.008 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.008..0.008 rows=1 loops=3)

  • Index Cond: (zulu = 154201)
18. 0.002 0.002 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (zulu = 154202)
19. 0.002 0.002 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (zulu = 154203)
20. 0.002 0.002 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.001..0.002 rows=1 loops=3)

  • Index Cond: (zulu = 154204)
21. 0.002 0.002 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (zulu = 154205)
22. 0.002 0.002 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.001..0.002 rows=1 loops=3)

  • Index Cond: (zulu = 154206)
23. 0.002 0.002 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.001..0.002 rows=1 loops=3)

  • Index Cond: (zulu = 154207)
24. 0.002 0.002 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.001..0.002 rows=1 loops=3)

  • Index Cond: (zulu = 154208)
25. 0.002 0.002 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (zulu = 154209)
26. 0.002 0.002 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.001..0.002 rows=1 loops=3)

  • Index Cond: (zulu = 154210)
27. 0.002 0.002 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.001..0.002 rows=1 loops=3)

  • Index Cond: (zulu = 154211)
28. 0.002 0.002 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.001..0.002 rows=1 loops=3)

  • Index Cond: (zulu = 154212)
29. 0.002 0.002 ↑ 2.0 1 3

Bitmap Index Scan on mike_five (cost=0.000..4.430 rows=2 width=0) (actual time=0.001..0.002 rows=1 loops=3)

  • Index Cond: (zulu = 154213)
Planning time : 1.803 ms
Execution time : 1,484.996 ms