# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.070 | 663,976.007 | ↑ 274.5 | 2 | 1 |
→
Hash Join (cost=9,551,800.78..9,626,572.56 rows=549 width=24) (actual time=663,975.876..663,976.007 rows=2 loops=1)
|
2. | 6.352 | 663,947.735 | ↑ 274.5 | 2 | 1 |
→
GroupAggregate (cost=9,551,528.98..9,626,287.72 rows=549 width=8) (actual time=663,947.611..663,947.735 rows=2 loops=1)
|
3. | 1.140 | 663,941.383 | ↑ 18,985.0 | 525 | 1 |
→
Sort (cost=9,551,528.98..9,576,446.73 rows=9,967,100 width=8) (actual time=663,941.303..663,941.383 rows=525 loops=1)
|
4. | 1,429.175 | 663,940.243 | ↑ 18,985.0 | 525 | 1 |
→
Nested Loop (cost=47,114.04..8,120,378.28 rows=9,967,100 width=8) (actual time=20,392.133..663,940.243 rows=525 loops=1) |
5. | 610,703.065 | 627,634.436 | ↑ 1.0 | 2,491,188 | 1 |
→
Bitmap Heap Scan on api_logs_201812 l (cost=47,114.03..2,414,213.52 rows=2,491,775 width=758) (actual time=16,955.046..627,634.436 rows=2,491,188 loops=1)
|
6. | 16,931.371 | 16,931.371 | ↑ 1.0 | 2,491,500 | 1 |
→
Bitmap Index Scan on api_logs_201812_api_method_index (cost=0.00..46,491.09 rows=2,504,296 width=0) (actual time=16,931.371..16,931.371 rows=2,491,500 loops=1)
|
7. | 34,876.632 | 34,876.632 | ↓ 0.0 | 0 | 2,491,188 |
→
Function Scan on jsonb_array_elements p (cost=0.01..2.26 rows=4 width=0) (actual time=0.014..0.014 rows=0 loops=2,491,188)
|
8. | 1.328 | 28.202 | ↑ 1.0 | 4,880 | 1 |
→
Hash (cost=210.80..210.80 rows=4,880 width=20) (actual time=28.202..28.202 rows=4,880 loops=1)
|
9. | 26.874 | 26.874 | ↑ 1.0 | 4,880 | 1 |
→
Seq Scan on users u (cost=0.00..210.80 rows=4,880 width=20) (actual time=14.506..26.874 rows=4,880 loops=1) |