explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KKMK : ffffffff

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.930 ↑ 50.0 2 1

Limit (cost=1,214.560..1,261.330 rows=100 width=320) (actual time=0.923..0.930 rows=2 loops=1)

2. 0.029 0.927 ↑ 325.0 2 1

GroupAggregate (cost=1,214.560..1,518.580 rows=650 width=320) (actual time=0.921..0.927 rows=2 loops=1)

  • Group Key: charlie172.quebec
3. 0.010 0.898 ↑ 4,579.5 2 1

Sort (cost=1,214.560..1,237.450 rows=9,159 width=247) (actual time=0.898..0.898 rows=2 loops=1)

  • Sort Key: charlie172.quebec
  • Sort Method: quicksort Memory: 29kB
4. 0.009 0.888 ↑ 4,579.5 2 1

Hash Left Join (cost=429.750..611.850 rows=9,159 width=247) (actual time=0.883..0.888 rows=2 loops=1)

  • Hash Cond: (CASE WHEN (CASE WHEN (charlie67.echo five_romeo NULL) THEN NULL::integer ELSE 1 END five_romeo NOT NULL) THEN charlie67.echo ELSE NULL::bigint END = charlie19.echo)
5. 0.009 0.670 ↑ 4,579.5 2 1

Hash Left Join (cost=382.230..539.770 rows=9,159 width=207) (actual time=0.666..0.670 rows=2 loops=1)

  • Hash Cond: (CASE WHEN (CASE WHEN (charlie158.november five_romeo NULL) THEN NULL::integer ELSE 1 END five_romeo NOT NULL) THEN charlie158.november ELSE NULL::bigint END = charlie67.quebec)
6. 0.030 0.386 ↑ 4,579.5 2 1

Hash Right Join (cost=274.710..407.700 rows=9,159 width=199) (actual time=0.383..0.386 rows=2 loops=1)

  • Hash Cond: (charlie158.victor = charlie172.quebec)
7. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on papa india (cost=0.000..25.700 rows=1,570 width=16) (actual time=0.003..0.003 rows=0 loops=1)

8. 0.004 0.353 ↑ 1,896.0 2 1

Hash (cost=227.310..227.310 rows=3,792 width=191) (actual time=0.353..0.353 rows=2 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 35kB
9. 0.015 0.349 ↑ 1,896.0 2 1

Hash Left Join (cost=145.700..227.310 rows=3,792 width=191) (actual time=0.347..0.349 rows=2 loops=1)

  • Hash Cond: (CASE WHEN (CASE WHEN (charlie171.kilo five_romeo NULL) THEN NULL::integer ELSE 1 END five_romeo NOT NULL) THEN charlie171.kilo ELSE NULL::bigint END = charlie120.quebec)
10. 0.026 0.107 ↑ 1,896.0 2 1

Hash Right Join (cost=97.480..168.950 rows=3,792 width=176) (actual time=0.105..0.107 rows=2 loops=1)

  • Hash Cond: (charlie171.victor = charlie172.quebec)
11. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on five_hotel four_sierra (cost=0.000..25.700 rows=1,570 width=16) (actual time=0.003..0.003 rows=0 loops=1)

12. 0.003 0.078 ↑ 785.0 2 1

Hash (cost=77.860..77.860 rows=1,570 width=168) (actual time=0.078..0.078 rows=2 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 19kB
13. 0.022 0.075 ↑ 785.0 2 1

Hash Left Join (cost=43.850..77.860 rows=1,570 width=168) (actual time=0.064..0.075 rows=2 loops=1)

  • Hash Cond: (CASE WHEN (CASE WHEN (charlie173.uniform five_romeo NULL) THEN NULL::integer ELSE 1 END five_romeo NOT NULL) THEN charlie173.uniform ELSE NULL::bigint END = charlie141.quebec)
14. 0.025 0.044 ↑ 785.0 2 1

Hash Right Join (cost=24.620..54.470 rows=1,570 width=104) (actual time=0.034..0.044 rows=2 loops=1)

  • Hash Cond: (charlie173.victor = charlie172.quebec)
15. 0.005 0.005 ↑ 1,570.0 1 1

Seq Scan on bravo sierra (cost=0.000..25.700 rows=1,570 width=16) (actual time=0.005..0.005 rows=1 loops=1)

16. 0.004 0.014 ↑ 325.0 2 1

Hash (cost=16.500..16.500 rows=650 width=96) (actual time=0.014..0.014 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
17. 0.010 0.010 ↑ 325.0 2 1

Seq Scan on tango_romeo romeo (cost=0.000..16.500 rows=650 width=96) (actual time=0.010..0.010 rows=2 loops=1)

18. 0.003 0.009 ↑ 410.0 1 1

Hash (cost=14.100..14.100 rows=410 width=72) (actual time=0.008..0.009 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.006 0.006 ↑ 410.0 1 1

Seq Scan on five_three xray (cost=0.000..14.100 rows=410 width=72) (actual time=0.006..0.006 rows=1 loops=1)

20. 0.110 0.227 ↑ 1.0 232 1

Hash (cost=45.320..45.320 rows=232 width=23) (actual time=0.227..0.227 rows=232 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
21. 0.117 0.117 ↑ 1.0 232 1

Seq Scan on four_six seven (cost=0.000..45.320 rows=232 width=23) (actual time=0.006..0.117 rows=232 loops=1)

22. 0.084 0.275 ↓ 1.2 238 1

Hash (cost=105.010..105.010 rows=201 width=16) (actual time=0.275..0.275 rows=238 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
23. 0.191 0.191 ↓ 1.2 238 1

Seq Scan on six tango_papa (cost=0.000..105.010 rows=201 width=16) (actual time=0.007..0.191 rows=238 loops=1)

24. 0.073 0.209 ↓ 1.2 232 1

Hash (cost=45.010..45.010 rows=201 width=40) (actual time=0.209..0.209 rows=232 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
25. 0.136 0.136 ↓ 1.2 232 1

Seq Scan on delta hotel (cost=0.000..45.010 rows=201 width=40) (actual time=0.005..0.136 rows=232 loops=1)

Planning time : 2.834 ms
Execution time : 1.167 ms