explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UdUp

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.023 ↓ 0.0 0 1

Sort (cost=50.52..50.53 rows=1 width=426) (actual time=0.023..0.023 rows=0 loops=1)

  • Sort Key: casejudgem1_.creation_date DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.000 0.016 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1.82..50.51 rows=1 width=426) (actual time=0.016..0.016 rows=0 loops=1)

3. 0.000 0.016 ↓ 0.0 0 1

Nested Loop (cost=1.41..34.06 rows=1 width=426) (actual time=0.016..0.016 rows=0 loops=1)

4. 0.000 0.016 ↓ 0.0 0 1

Nested Loop (cost=1.13..33.74 rows=1 width=434) (actual time=0.016..0.016 rows=0 loops=1)

5. 0.002 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.84..25.43 rows=1 width=426) (actual time=0.016..0.016 rows=0 loops=1)

6. 0.007 0.007 ↑ 2.0 1 1

Index Scan using case_judgements_x_case_idx on case_judgements_x_t casejudgem1_ (cost=0.42..8.52 rows=2 width=16) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (case_id = 1530447)
7. 0.007 0.007 ↓ 0.0 0 1

Index Scan using pk_judgement_t on judgement_t judgement0_ (cost=0.42..8.45 rows=1 width=418) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (id = casejudgem1_.judgement_id)
  • Filter: (((judgement_status)::text = 'PROPOSITION'::text) AND (given_on = '2018-06-19 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1
8. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_judgement_result_t on judgement_result_t judgementr2_ (cost=0.28..8.30 rows=1 width=16) (never executed)

  • Index Cond: (id = judgement0_.judgement_result_id)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_judgement_subject_t on judgement_subject_t judgements3_ (cost=0.28..0.31 rows=1 width=8) (never executed)

  • Index Cond: (id = judgementr2_.judgement_subject_id)
  • Filter: ((type_subject)::text = 'CCADVICE'::text)
10. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix_meetop_given_judgement on meeting_topic_t meetingtop4_ (cost=0.42..8.44 rows=1 width=8) (never executed)

  • Index Cond: (given_judgement_id = judgement0_.id)
  • Heap Fetches: 0
Planning time : 0.823 ms