explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Se06

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

Unique (cost=0..0 rows=0 width=0) (never executed)

2. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: transaction_labels."TransactionId", transaction_labels."CaseId", transaction_labels."LabelSetId", transaction_labels."LabellerId", "TransactionLabels"."ClassifierId", "TransactionLabels"."Label", "TransactionLabels"."Id", ((consensus_base.consensus_count / ((count("TransactionLabels_2"."Label")))::numeric))
3. 0.000 0.000 ↓ 0.0

Merge Join (cost=0..0 rows=0 width=0) (never executed)

4. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: transaction_labels."TransactionId"
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

8. 0.000 0.000 ↓ 0.0

Seq Scan on TransactionLabels transaction_labels (cost=0..0 rows=0 width=0) (never executed)

9. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

10. 0.000 0.000 ↓ 0.0

Subquery Scan on consensus_base (cost=0..0 rows=0 width=0) (never executed)

11. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0..0 rows=0 width=0) (never executed)

  • Group Key: selected_transaction_labels."TransactionId", "TransactionLabels_1"."Label"
12. 0.000 0.000 ↓ 0.0

Gather Merge (cost=0..0 rows=0 width=0) (never executed)

  • Workers Planned: 2
13. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0..0 rows=0 width=0) (never executed)

  • Group Key: selected_transaction_labels."TransactionId", "TransactionLabels_1"."Label"
14. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: selected_transaction_labels."TransactionId", "TransactionLabels_1"."Label"
15. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

16. 0.000 0.000 ↓ 0.0

Seq Scan on TransactionLabels TransactionLabels_1 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ("ClassifierId" = 'Decision'::text)
17. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

18. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0..0 rows=0 width=0) (never executed)

  • Group Key: selected_transaction_labels."TransactionId"
  • Filter: (count(DISTINCT selected_transaction_labels."LabelSetId") = 1)
19. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: selected_transaction_labels."TransactionId"
20. 0.000 0.000 ↓ 0.0

Seq Scan on TransactionLabels selected_transaction_labels (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ("ClassifierId" = 'Decision'::text)
21. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

22. 0.000 0.000 ↓ 0.0

Seq Scan on LabelSets labelsets (cost=0..0 rows=0 width=0) (never executed)

  • Filter: "Completed"
23. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

24. 0.000 0.000 ↓ 0.0

Seq Scan on TransactionLabels TransactionLabels (cost=0..0 rows=0 width=0) (never executed)

25. 0.000 0.000 ↓ 0.0

Materialize (cost=0..0 rows=0 width=0) (never executed)

26. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0..0 rows=0 width=0) (never executed)

  • Group Key: "TransactionLabels_2"."TransactionId", "TransactionLabels_2"."ClassifierId", "TransactionLabels_2"."LabelSetId"
27. 0.000 0.000 ↓ 0.0

Gather Merge (cost=0..0 rows=0 width=0) (never executed)

  • Workers Planned: 2
28. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0..0 rows=0 width=0) (never executed)

  • Group Key: "TransactionLabels_2"."TransactionId", "TransactionLabels_2"."ClassifierId", "TransactionLabels_2"."LabelSetId"
29. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: "TransactionLabels_2"."TransactionId", "TransactionLabels_2"."LabelSetId"
30. 0.000 0.000 ↓ 0.0

Seq Scan on TransactionLabels TransactionLabels_2 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ("ClassifierId" = 'Decision'::text)