explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qe4u : Remove full duplicates

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

CTE Scan on data (cost=7,240,722.58..7,469,611.48 rows=3,390,947 width=1,173) (actual rows= loops=)

  • Filter: (row_number > 1)
2.          

CTE data

3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=6,910,105.28..7,240,722.58 rows=10,172,840 width=96) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=6,910,105.28..6,935,537.38 rows=10,172,840 width=84) (actual rows= loops=)

  • Sort Key: labels.project_id, labels.title, labels.template, labels.description, labels.type, labels.color, labels.id
5. 0.000 0.000 ↓ 0.0

Merge Anti Join (cost=5.43..3,778,929.28 rows=10,172,840 width=84) (actual rows= loops=)

  • Merge Cond: (labels.id = board_labels.label_id)
6. 0.000 0.000 ↓ 0.0

Merge Anti Join (cost=5.15..3,752,954.42 rows=10,182,196 width=84) (actual rows= loops=)

  • Merge Cond: (labels.id = resource_label_events.label_id)
7. 0.000 0.000 ↓ 0.0

Merge Anti Join (cost=4.58..2,062,374.37 rows=10,364,552 width=84) (actual rows= loops=)

  • Merge Cond: (labels.id = label_links.label_id)
8. 0.000 0.000 ↓ 0.0

Merge Anti Join (cost=1.16..864,849.28 rows=10,640,435 width=84) (actual rows= loops=)

  • Merge Cond: (labels.id = label_priorities.label_id)
9. 0.000 0.000 ↓ 0.0

Merge Anti Join (cost=0.87..833,920.51 rows=10,732,133 width=84) (actual rows= loops=)

  • Merge Cond: (labels.id = lists.label_id)
10. 0.000 0.000 ↓ 0.0

Index Scan using labels_pkey on labels (cost=0.43..763,371.15 rows=11,277,626 width=84) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Only Scan using index_lists_on_label_id on lists (cost=0.43..92,912.73 rows=4,548,617 width=4) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Only Scan using index_label_priorities_on_label_id on label_priorities (cost=0.29..2,833.46 rows=105,754 width=4) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Only Scan using index_label_links_on_label_id on label_links (cost=0.56..765,327.52 rows=34,257,352 width=4) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Only Scan using index_resource_label_events_on_label_id_and_action on resource_label_events (cost=0.56..1,248,116.73 rows=44,380,942 width=4) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Index Only Scan using index_board_labels_on_label_id on board_labels (cost=0.29..375.01 rows=12,832 width=4) (actual rows= loops=)