explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FiPB

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 26.919 490.694 ↑ 1.8 10,961 1

Nested Loop Left Join (cost=12,065.050..265,241.970 rows=19,828 width=1,194) (actual time=154.822..490.694 rows=10,961 loops=1)

2. 0.151 398.009 ↑ 1.8 10,961 1

Nested Loop Left Join (cost=12,064.500..221,471.470 rows=19,813 width=1,114) (actual time=154.788..398.009 rows=10,961 loops=1)

3. 3.155 332.092 ↑ 1.8 10,961 1

Nested Loop (cost=12,063.940..181,569.730 rows=19,798 width=1,105) (actual time=154.778..332.092 rows=10,961 loops=1)

4. 116.615 259.403 ↑ 2.1 11,589 1

Bitmap Heap Scan on november quebec_three (cost=12,063.390..132,267.050 rows=23,941 width=1,105) (actual time=154.760..259.403 rows=11,589 loops=1)

  • Recheck Cond: (romeo_seven = 'romeo_alpha'::text)
  • Filter: (foxtrot AND (two = 86) AND ('three'::text <> (quebec_kilo ->> 'papa'::text)))
  • Rows Removed by Filter: 83,117
  • Heap Blocks: exact=77,406
5. 10.429 142.788 ↓ 0.0 0 1

BitmapAnd (cost=12,063.390..12,063.390 rows=127,322 width=0) (actual time=142.788..142.788 rows=0 loops=1)

6. 82.048 82.048 ↑ 1.0 547,919 1

Bitmap Index Scan on delta (cost=0.000..5,778.780 rows=549,273 width=0) (actual time=82.048..82.048 rows=547,919 loops=1)

  • Index Cond: (foxtrot = true)
7. 50.311 50.311 ↑ 1.0 588,778 1

Bitmap Index Scan on charlie (cost=0.000..6,272.390 rows=596,168 width=0) (actual time=50.311..50.311 rows=588,778 loops=1)

  • Index Cond: (romeo_seven = 'romeo_alpha'::text)
8. 69.534 69.534 ↑ 1.0 1 11,589

Index Scan using xray on four juliet (cost=0.560..2.060 rows=1 width=33) (actual time=0.006..0.006 rows=1 loops=11,589)

  • Index Cond: (alpha = quebec_three.quebec_seven)
  • Filter: (tango = 1)
  • Rows Removed by Filter: 0
9. 65.766 65.766 ↑ 1.0 1 10,961

Index Scan using bravo on five echo (cost=0.560..2.020 rows=1 width=42) (actual time=0.006..0.006 rows=1 loops=10,961)

  • Index Cond: (alpha = quebec_three.quebec_seven)
10. 65.766 65.766 ↑ 1.0 1 10,961

Index Scan using oscar on seven quebec_sierra (cost=0.560..1.950 rows=1 width=49) (actual time=0.006..0.006 rows=1 loops=10,961)

  • Index Cond: (alpha = quebec_three.quebec_seven)