explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IloS

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 / (decisionlabels.label_total)::numeric))
3. 0.000 0.000 ↓ 0.0

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

4. 0.000 0.000 ↓ 0.0

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

  • Workers Planned: 1
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

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

8. 0.000 0.000 ↓ 0.0

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

9. 0.000 0.000 ↓ 0.0

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

10. 0.000 0.000 ↓ 0.0

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

11. 0.000 0.000 ↓ 0.0

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

12. 0.000 0.000 ↓ 0.0

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

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

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

25. 0.000 0.000 ↓ 0.0

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

  • Group Key: "TransactionLabels_2"."TransactionId", "TransactionLabels_2"."ClassifierId", "TransactionLabels_2"."LabelSetId"
26. 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)