explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BP1i : lane

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 516.721 90,929.792 ↑ 1.0 201,527 1

Unique (cost=20,157,906.020..20,201,234.330 rows=201,527 width=2,437) (actual time=90,282.136..90,929.792 rows=201,527 loops=1)

2. 1,494.496 90,413.071 ↑ 1.0 201,527 1

Sort (cost=20,157,906.020..20,158,409.840 rows=201,527 width=2,437) (actual time=90,282.134..90,413.071 rows=201,527 loops=1)

  • Sort Key: yankee_xray.tango_xray,
  • Sort Method: external merge Disk: 95832kB
3. 22,166.258 88,918.575 ↑ 1.0 201,527 1

Seq Scan on echo_zulu yankee_xray (cost=0.000..19,715,838.880 rows=201,527 width=2,437) (actual time=0.525..88,918.575 rows=201,527 loops=1)

4.          

SubPlan (for Seq Scan)

5. 403.054 403.054 ↑ 1.0 1 201,527

Seq Scan on tango_delta kilo_foxtrot (cost=0.000..1.010 rows=1 width=58) (actual time=0.002..0.002 rows=1 loops=201,527)

  • Filter: (foxtrot = yankee_xray.foxtrot)
6. 403.054 403.054 ↑ 1.0 1 201,527

Seq Scan on alpha_delta papa_india (cost=0.000..1.050 rows=1 width=58) (actual time=0.002..0.002 rows=1 loops=201,527)

  • Filter: (kilo_zulu = yankee_xray.kilo_zulu)
  • Rows Removed by Filter: 3
7. 403.054 403.054 ↑ 1.0 1 201,527

Seq Scan on alpha_delta tango_mike (cost=0.000..1.050 rows=1 width=58) (actual time=0.001..0.002 rows=1 loops=201,527)

  • Filter: (kilo_zulu = yankee_xray.kilo_zulu)
  • Rows Removed by Filter: 3
8. 1,612.216 1,612.216 ↑ 1.0 1 201,527

Seq Scan on hotel alpha_seven (cost=0.000..1.630 rows=1 width=58) (actual time=0.005..0.008 rows=1 loops=201,527)

  • Filter: (delta_echo = yankee_xray.yankee_golf)
  • Rows Removed by Filter: 49
9. 3,425.959 3,425.959 ↓ 0.0 0 201,527

Seq Scan on three kilo_hotel (cost=0.000..3.340 rows=1 width=12) (actual time=0.017..0.017 rows=0 loops=201,527)

  • Filter: (india = yankee_xray.seven_echo)
  • Rows Removed by Filter: 107
10. 1,612.216 1,612.216 ↓ 0.0 0 201,527

Seq Scan on hotel uniform_charlie (cost=0.000..1.630 rows=1 width=58) (actual time=0.008..0.008 rows=0 loops=201,527)

  • Filter: (delta_echo = yankee_xray.four_xray)
  • Rows Removed by Filter: 50
11. 3,224.432 3,224.432 ↓ 0.0 0 201,527

Seq Scan on three papa_delta (cost=0.000..3.340 rows=1 width=12) (actual time=0.016..0.016 rows=0 loops=201,527)

  • Filter: (india = yankee_xray.four_victor)
  • Rows Removed by Filter: 107
12. 1,612.216 1,612.216 ↓ 0.0 0 201,527

Seq Scan on hotel kilo_delta (cost=0.000..1.630 rows=1 width=58) (actual time=0.007..0.008 rows=0 loops=201,527)

  • Filter: (delta_echo = yankee_xray.echo_uniform)
  • Rows Removed by Filter: 50
13. 3,425.959 3,425.959 ↓ 0.0 0 201,527

Seq Scan on three romeo_charlie (cost=0.000..3.340 rows=1 width=12) (actual time=0.014..0.017 rows=0 loops=201,527)

  • Filter: (india = yankee_xray.yankee_sierra)
  • Rows Removed by Filter: 107
14. 468.340 468.340 ↑ 1.0 1 93,668

Index Scan using lima on whiskey_quebec two_six (cost=0.270..8.290 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=93,668)

  • Index Cond: (zulu_whiskey = yankee_xray.zulu_whiskey)
15. 374.672 655.676 ↑ 1.0 1 93,668

Seq Scan on xray_juliet (cost=8.290..9.330 rows=1 width=58) (actual time=0.007..0.007 rows=1 loops=93,668)

  • Filter: (oscar_bravo = $11)
  • Rows Removed by Filter: 2
16.          

Initplan (for Seq Scan)

17. 281.004 281.004 ↑ 1.0 1 93,668

Index Scan using lima on whiskey_quebec uniform_hotel (cost=0.270..8.290 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=93,668)

  • Index Cond: (zulu_whiskey = yankee_xray.zulu_whiskey)
18. 5,441.229 5,441.229 ↓ 0.0 0 201,527

Seq Scan on kilo_uniform romeo_three (cost=0.000..4.140 rows=1 width=4) (actual time=0.026..0.027 rows=0 loops=201,527)

  • Filter: (xray_oscar = (yankee_xray.papa_quebec)::integer)
  • Rows Removed by Filter: 65
19. 5,239.702 5,239.702 ↓ 0.0 0 201,527

Seq Scan on kilo_uniform victor (cost=0.000..4.140 rows=1 width=13) (actual time=0.025..0.026 rows=0 loops=201,527)

  • Filter: (xray_oscar = (yankee_xray.papa_quebec)::integer)
  • Rows Removed by Filter: 65
20. 5,239.702 5,239.702 ↓ 0.0 0 201,527

Seq Scan on kilo_uniform quebec_bravo (cost=0.000..4.140 rows=1 width=5) (actual time=0.024..0.026 rows=0 loops=201,527)

  • Filter: (xray_oscar = (yankee_xray.papa_quebec)::integer)
  • Rows Removed by Filter: 65
21. 5,239.702 5,239.702 ↓ 0.0 0 201,527

Seq Scan on kilo_uniform oscar_two (cost=0.000..4.140 rows=1 width=6) (actual time=0.024..0.026 rows=0 loops=201,527)

  • Filter: (xray_oscar = (yankee_xray.papa_quebec)::integer)
  • Rows Removed by Filter: 65
22. 5,239.702 5,239.702 ↓ 0.0 0 201,527

Seq Scan on kilo_uniform alpha_charlie (cost=0.000..4.140 rows=1 width=4) (actual time=0.024..0.026 rows=0 loops=201,527)

  • Filter: (xray_oscar = (yankee_xray.papa_quebec)::integer)
  • Rows Removed by Filter: 65
23. 5,239.702 5,239.702 ↓ 0.0 0 201,527

Seq Scan on kilo_uniform mike (cost=0.000..4.140 rows=1 width=3) (actual time=0.024..0.026 rows=0 loops=201,527)

  • Filter: (xray_oscar = (yankee_xray.papa_quebec)::integer)
  • Rows Removed by Filter: 65
24. 5,239.702 5,239.702 ↓ 0.0 0 201,527

Seq Scan on kilo_uniform oscar_papa (cost=0.000..4.140 rows=1 width=4) (actual time=0.024..0.026 rows=0 loops=201,527)

  • Filter: (xray_oscar = (yankee_xray.papa_quebec)::integer)
  • Rows Removed by Filter: 65
25. 403.054 403.054 ↓ 0.0 0 201,527

Seq Scan on seven_two juliet_juliet (cost=0.000..1.050 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=201,527)

  • Filter: (quebec_lima = yankee_xray.seven_two)
  • Rows Removed by Filter: 4
26. 403.054 403.054 ↓ 0.0 0 201,527

Seq Scan on seven_two charlie_oscar (cost=0.000..1.050 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=201,527)

  • Filter: (quebec_lima = yankee_xray.seven_two)
  • Rows Removed by Filter: 4
27. 92.817 1,546.950 ↑ 1.0 1 30,939

Unique (cost=9.760..9.760 rows=1 width=58) (actual time=0.050..0.050 rows=1 loops=30,939)

28. 402.207 1,454.133 ↑ 1.0 1 30,939

Sort (cost=9.760..9.760 rows=1 width=58) (actual time=0.047..0.047 rows=1 loops=30,939)

  • Sort Key: ((quebec_sierra.romeo_echo)::character varying(20))
  • Sort Method: quicksort Memory: 25kB
29. 309.782 1,051.926 ↑ 1.0 1 30,939

Hash Join (cost=8.310..9.750 rows=1 width=58) (actual time=0.033..0.034 rows=1 loops=30,939)

  • Hash Cond: (quebec_sierra.sierra = oscar_mike3.sierra)
30. 123.364 123.364 ↑ 1.0 31 30,841

Seq Scan on uniform_seven quebec_sierra (cost=0.000..1.310 rows=31 width=122) (actual time=0.002..0.004 rows=31 loops=30,841)

31. 123.756 618.780 ↑ 1.0 1 30,939

Hash (cost=8.290..8.290 rows=1 width=4) (actual time=0.020..0.020 rows=1 loops=30,939)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
32. 495.024 495.024 ↑ 1.0 1 30,939

Index Scan using yankee_lima on bravo papa_sierra (cost=0.280..8.290 rows=1 width=4) (actual time=0.016..0.016 rows=1 loops=30,939)

  • Index Cond: ((two_charlie)::text = (yankee_xray.two_india)::text)
33. 92.817 2,011.035 ↑ 1.0 1 30,939

Unique (cost=12.780..12.790 rows=1 width=78) (actual time=0.064..0.065 rows=1 loops=30,939)

34. 371.268 1,918.218 ↑ 1.0 1 30,939

Sort (cost=12.780..12.790 rows=1 width=78) (actual time=0.062..0.062 rows=1 loops=30,939)

  • Sort Key: (((((golf1.two_echo)::text || 'charlie_charlie'::text) || (oscar_mike4.five)::text))::character varying(30))
  • Sort Method: quicksort Memory: 25kB
35. 589.115 1,546.950 ↑ 1.0 1 30,939

Hash Join (cost=8.310..12.770 rows=1 width=78) (actual time=0.041..0.050 rows=1 loops=30,939)

  • Hash Cond: (golf1.juliet_echo = oscar_mike4.juliet_echo)
36. 400.933 400.933 ↑ 1.0 105 30,841

Seq Scan on charlie_mike zulu_zulu (cost=0.000..4.050 rows=105 width=19) (actual time=0.002..0.013 rows=105 loops=30,841)

37. 92.817 556.902 ↑ 1.0 1 30,939

Hash (cost=8.300..8.300 rows=1 width=15) (actual time=0.018..0.018 rows=1 loops=30,939)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
38. 464.085 464.085 ↑ 1.0 1 30,939

Index Scan using yankee_lima on bravo four_three (cost=0.280..8.300 rows=1 width=15) (actual time=0.014..0.015 rows=1 loops=30,939)

  • Index Cond: ((yankee_xray.two_india)::text = (two_charlie)::text)
  • Filter: (juliet_seven = 0)
39. 1,612.216 1,612.216 ↓ 0.0 0 201,527

Seq Scan on hotel whiskey_foxtrot (cost=0.000..1.630 rows=1 width=58) (actual time=0.007..0.008 rows=0 loops=201,527)

  • Filter: (delta_echo = yankee_xray.papa_victor)
  • Rows Removed by Filter: 50
40. 3,425.959 3,425.959 ↓ 0.0 0 201,527

Seq Scan on three delta_romeo (cost=0.000..3.340 rows=1 width=12) (actual time=0.017..0.017 rows=0 loops=201,527)

  • Filter: (india = yankee_xray.delta_four)
  • Rows Removed by Filter: 107
41. 3,224.432 3,224.432 ↓ 0.0 0 201,527

Seq Scan on three four_delta (cost=0.000..3.340 rows=1 width=12) (actual time=0.016..0.016 rows=0 loops=201,527)

  • Filter: (india = yankee_xray.kilo_yankee)
  • Rows Removed by Filter: 107