explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qk5s

Settings
# exclusive inclusive rows x rows loops node
1. 3.357 32,022.070 ↑ 1.0 1 1

GroupAggregate (cost=2,264.720..49,683.510 rows=1 width=32) (actual time=32,022.069..32,022.070 rows=1 loops=1)

  • Group Key: oscar."five
2.          

CTE oscar

3. 3.734 53.674 ↓ 2.9 344 1

GroupAggregate (cost=2,261.890..2,264.290 rows=120 width=32) (actual time=48.757..53.674 rows=344 loops=1)

  • Group Key: "juliet".charlie, "juliet"."five
4. 3.674 49.940 ↓ 23.4 2,808 1

Sort (cost=2,261.890..2,262.190 rows=120 width=32) (actual time=48.742..49.940 rows=2,808 loops=1)

  • Sort Key: "juliet".charlie
  • Sort Method: quicksort Memory: 405kB
5. 26.882 46.266 ↓ 23.4 2,808 1

Bitmap Heap Scan on yankee juliet (cost=1,791.260..2,257.750 rows=120 width=32) (actual time=19.776..46.266 rows=2,808 loops=1)

  • Recheck Cond: (("two" = 'echo'::uuid) AND ("four" = 'kilo'::text))
  • Heap Blocks: exact=2535
6. 0.407 19.384 ↓ 0.0 0 1

BitmapAnd (cost=1,791.260..1,791.260 rows=120 width=0) (actual time=19.384..19.384 rows=0 loops=1)

7. 2.876 2.876 ↓ 1.2 5,076 1

Bitmap Index Scan on sierra (cost=0.000..143.890 rows=4,195 width=0) (actual time=2.876..2.876 rows=5,076 loops=1)

  • Index Cond: ("two" = 'echo'::uuid)
8. 16.101 16.101 ↓ 1.4 83,742 1

Bitmap Index Scan on delta (cost=0.000..1,647.060 rows=61,150 width=0) (actual time=16.101..16.101 rows=83,742 loops=1)

  • Index Cond: ("four" = 'kilo'::text)
9. 6,580.101 32,018.713 ↓ 358.0 358 1

Nested Loop (cost=0.430..47,419.190 rows=1 width=24) (actual time=173.310..32,018.713 rows=358 loops=1)

  • Join Filter: (("yankee"."india" = oscar."india") AND ("yankee".charlie = oscar.charlie))
  • Rows Removed by Join Filter: 27970282
10. 55.884 55.884 ↓ 344.0 344 1

CTE Scan on oscar (cost=0.000..2.700 rows=1 width=56) (actual time=48.762..55.884 rows=344 loops=1)

  • Filter: ("two" = 'echo'::uuid)
11. 25,382.728 25,382.728 ↓ 1.3 81,310 344

Index Scan using delta on yankee (cost=0.430..46,499.240 rows=61,150 width=24) (actual time=0.033..73.787 rows=81,310 loops=344)

  • Index Cond: ("four" = 'kilo'::text)
Planning time : 1.314 ms
Execution time : 32,022.383 ms