explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8GdT

Settings
# exclusive inclusive rows x rows loops node
1. 17.267 1,159.105 ↑ 1.9 441 1

GroupAggregate (cost=303,400.620..313,076.690 rows=850 width=136) (actual time=1,141.849..1,159.105 rows=441 loops=1)

  • Group Key: whiskey1.zulu
  • Functions: 69
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 5.829 ms, Inlining 0.000 ms, Optimization 2.832 ms, Emission 50.074 ms, Total 58.735 ms
2. 1.061 1,141.838 ↑ 151.1 1,421 1

Sort (cost=303,400.620..303,937.240 rows=214,646 width=1,265) (actual time=1,141.711..1,141.838 rows=1,421 loops=1)

  • Sort Key: whiskey1.zulu
  • Sort Method: quicksort Memory: 1473kB
3. 0.411 1,140.777 ↑ 151.1 1,421 1

Nested Loop Left Join (cost=1,321.260..46,686.000 rows=214,646 width=1,265) (actual time=71.016..1,140.777 rows=1,421 loops=1)

4. 0.859 1,133.373 ↓ 1.2 999 1

Nested Loop Left Join (cost=1,320.680..23,285.370 rows=851 width=1,205) (actual time=68.934..1,133.373 rows=999 loops=1)

5. 0.413 1,123.523 ↓ 1.2 999 1

Hash Left Join (cost=1,320.120..15,981.160 rows=851 width=244) (actual time=66.258..1,123.523 rows=999 loops=1)

  • Hash Cond: (whiskey1.seven_lima = bravo.seven_lima)
6. 0.892 1,114.788 ↓ 1.2 999 1

Nested Loop (cost=1.720..14,660.520 rows=851 width=224) (actual time=57.891..1,114.788 rows=999 loops=1)

7. 54.252 237.773 ↓ 1.2 999 1

Nested Loop (cost=1.150..7,352.560 rows=851 width=218) (actual time=57.107..237.773 rows=999 loops=1)

8. 3.701 3.701 ↓ 1.2 999 1

Index Scan using three_whiskey on kilo (cost=0.570..44.590 rows=851 width=24) (actual time=2.446..3.701 rows=999 loops=1)

  • Index Cond: ((quebec_seven > 8000000) AND (quebec_seven < 8001000))
9. 179.820 179.820 ↑ 1.0 1 999

Index Scan using seven_alpha on oscar_kilo golf (cost=0.570..8.590 rows=1 width=202) (actual time=0.180..0.180 rows=1 loops=999)

  • Index Cond: (zulu = whiskey1.zulu)
10. 876.123 876.123 ↑ 1.0 1 999

Index Scan using foxtrot on sierra six (cost=0.570..8.590 rows=1 width=22) (actual time=0.877..0.877 rows=1 loops=999)

  • Index Cond: (lima = whiskey1.lima)
11. 3.974 8.322 ↑ 1.0 25,576 1

Hash (cost=994.290..994.290 rows=25,929 width=36) (actual time=8.321..8.322 rows=25,576 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 2052kB
12. 4.348 4.348 ↑ 1.0 25,576 1

Seq Scan on uniform bravo (cost=0.000..994.290 rows=25,929 width=36) (actual time=0.007..4.348 rows=25,576 loops=1)

13. 8.991 8.991 ↓ 0.0 0 999

Index Scan using oscar_uniform on three_mike quebec_juliet (cost=0.560..8.570 rows=1 width=969) (actual time=0.009..0.009 rows=0 loops=999)

  • Index Cond: (zulu = whiskey1.zulu)
14. 6.993 6.993 ↑ 252.0 1 999

Index Scan using four on xray quebec_foxtrot (cost=0.570..24.980 rows=252 width=68) (actual time=0.007..0.007 rows=1 loops=999)

  • Index Cond: (zulu = whiskey1.zulu)
15.          

SubPlan (for GroupAggregate)

16. 0.000 0.000 ↑ 1.0 1 1,421

Result (cost=0.000..0.010 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=1,421)

17. 0.000 0.000 ↑ 1.0 1 1,421

Result (cost=0.000..0.010 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=1,421)

18. 0.000 0.000 ↑ 1.0 1 1,421

Result (cost=0.000..0.010 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=1,421)

Planning time : 1.269 ms
Execution time : 1,165.157 ms