explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EZIJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=235,502.02..53,446,559.94 rows=14,151,788 width=502) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Limit (cost=235,502.02..238,787.67 rows=1,000 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=235,502.02..5,040,481.23 rows=1,462,415 width=8) (actual rows= loops=)

  • Hash Cond: (clm.cc_list_id = clp.cc_list_id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on cc_listing_main clm (cost=0.00..3,655,878.72 rows=31,852,261 width=8) (actual rows= loops=)

  • Filter: (photo_dt IS NULL)
5. 0.000 0.000 ↓ 0.0

Hash (cost=121,596.01..121,596.01 rows=6,942,801 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on mv_priority_cc_list_id clp (cost=0.00..121,596.01 rows=6,942,801 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Append (cost=0.00..53,065.31 rows=14,245 width=498) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on cc_photo_p cpp (cost=0.00..0.00 rows=1 width=36) (actual rows= loops=)

  • Filter: (cc_list_id = clm.cc_list_id)
9. 0.000 0.000 ↓ 0.0

Index Scan using cc_photo_p1_cc_list_id_idx on cc_photo_p1 cpp_1 (cost=0.56..3,597.75 rows=935 width=498) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)
10. 0.000 0.000 ↓ 0.0

Index Scan using cc_photo_p10_cc_list_id_idx on cc_photo_p10 cpp_2 (cost=0.56..4,065.49 rows=1,103 width=498) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)
11. 0.000 0.000 ↓ 0.0

Index Scan using cc_photo_p11_cc_list_id_idx on cc_photo_p11 cpp_3 (cost=0.56..4,607.30 rows=1,286 width=498) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)
12. 0.000 0.000 ↓ 0.0

Index Scan using cc_photo_p2_cc_list_id_idx on cc_photo_p2 cpp_4 (cost=0.56..3,584.74 rows=925 width=498) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)
13. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on cc_photo_p3 cpp_5 (cost=19.64..3,594.57 rows=931 width=498) (actual rows= loops=)

  • Recheck Cond: (cc_list_id = clm.cc_list_id)
14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on cc_photo_p3_cc_list_id_idx (cost=0.00..19.41 rows=931 width=0) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)
15. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on cc_photo_p4 cpp_6 (cost=19.44..3,496.29 rows=905 width=498) (actual rows= loops=)

  • Recheck Cond: (cc_list_id = clm.cc_list_id)
16. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on cc_photo_p4_cc_list_id_idx (cost=0.00..19.22 rows=905 width=0) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)
17. 0.000 0.000 ↓ 0.0

Index Scan using cc_photo_p5_cc_list_id_idx on cc_photo_p5 cpp_7 (cost=0.56..3,922.75 rows=1,012 width=498) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)
18. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on cc_photo_p6 cpp_8 (cost=19.93..3,739.90 rows=969 width=498) (actual rows= loops=)

  • Recheck Cond: (cc_list_id = clm.cc_list_id)
19. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on cc_photo_p6_cc_list_id_idx (cost=0.00..19.69 rows=969 width=0) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)
20. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on cc_photo_p7 cpp_9 (cost=23.85..3,751.67 rows=971 width=498) (actual rows= loops=)

  • Recheck Cond: (cc_list_id = clm.cc_list_id)
21. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on cc_photo_p7_cc_list_id_idx (cost=0.00..23.60 rows=971 width=0) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)
22. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on cc_photo_p8 cpp_10 (cost=23.93..3,783.82 rows=979 width=498) (actual rows= loops=)

  • Recheck Cond: (cc_list_id = clm.cc_list_id)
23. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on cc_photo_p8_cc_list_id_idx (cost=0.00..23.68 rows=979 width=0) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)
24. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on cc_photo_p9 cpp_11 (cost=24.52..4,061.54 rows=1,052 width=498) (actual rows= loops=)

  • Recheck Cond: (cc_list_id = clm.cc_list_id)
25. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on cc_photo_p9_cc_list_id_idx (cost=0.00..24.26 rows=1,052 width=0) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)
26. 0.000 0.000 ↓ 0.0

Index Scan using cc_photo_p12_cc_list_id_idx on cc_photo_p12 cpp_12 (cost=0.56..4,795.49 rows=1,307 width=498) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)
27. 0.000 0.000 ↓ 0.0

Index Scan using cc_photo_p13_cc_list_id_idx on cc_photo_p13 cpp_13 (cost=0.56..4,326.98 rows=1,414 width=499) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)
28. 0.000 0.000 ↓ 0.0

Index Scan using cc_photo_p14_cc_list_id_idx on cc_photo_p14 cpp_14 (cost=0.56..1,737.01 rows=455 width=499) (actual rows= loops=)

  • Index Cond: (cc_list_id = clm.cc_list_id)