explain.depesz.com

A tool for finding a real cause for slow queries.

Result: gk0 : Anonymized with Pg::Explain 0.63

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.046 0.354 ↓ 3.8 42 1

Hash Left Join (cost=11.830..13.980 rows=11 width=268) (actual time=0.256..0.354 rows=42 loops=1)

  • Output: kilo_foxtrot.echo, kilo_foxtrot.tango_victor, kilo_foxtrot.four, kilo_foxtrot.juliet, kilo_foxtrot.tango_tango, kilo_foxtrot.five_alpha, kilo_foxtrot.five_quebec, kilo_tango.echo, kilo_tango.tango_victor, kilo_tango.juliet, kilo_tango.lima_november, $0
  • Hash Cond: (kilo_foxtrot.juliet = kilo_tango.juliet)
2.          

Initplan (forHash Left Join)

3. 0.009 0.110 ↑ 1.0 1 1

Aggregate (cost=9.920..9.930 rows=1 width=0) (actual time=0.109..0.110 rows=1 loops=1)

  • Output: five_two(*)
4. 0.101 0.101 ↑ 2.1 42 1

Foreign Scan on two (cost=0.000..9.700 rows=87 width=0) (actual time=0.008..0.101 rows=42 loops=1)

  • Output: golf.echo, golf.tango_victor, golf.four, golf.juliet, golf.tango_tango, golf.five_alpha, golf.five_quebec
  • Foreign File: whiskey
  • Foreign File Size: 2079
5. 0.090 0.090 ↓ 3.8 42 1

Foreign Scan on two kilo_foxtrot (cost=0.000..2.100 rows=11 width=168) (actual time=0.020..0.090 rows=42 loops=1)

  • Output: kilo_foxtrot.echo, kilo_foxtrot.tango_victor, kilo_foxtrot.four, kilo_foxtrot.juliet, kilo_foxtrot.tango_tango, kilo_foxtrot.five_alpha, kilo_foxtrot.five_quebec
  • Foreign File: whiskey
  • Foreign File Size: 2079
6. 0.032 0.108 ↓ 8.9 71 1

Hash (cost=1.800..1.800 rows=8 width=100) (actual time=0.108..0.108 rows=71 loops=1)

  • Output: kilo_tango.echo, kilo_tango.tango_victor, kilo_tango.juliet, kilo_tango.lima_november
  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
7. 0.076 0.076 ↓ 8.9 71 1

Foreign Scan on lima_xray kilo_tango (cost=0.000..1.800 rows=8 width=100) (actual time=0.009..0.076 rows=71 loops=1)

  • Output: kilo_tango.echo, kilo_tango.tango_victor, kilo_tango.juliet, kilo_tango.lima_november
  • Foreign File: india
  • Foreign File Size: 987