explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IndH

Settings
# exclusive inclusive rows x rows loops node
1. 0.094 0.968 ↓ 0.0 0 1

Insert on all_links_indexable (cost=13.03..13.15 rows=6 width=96) (actual time=0.964..0.968 rows=0 loops=1)

  • Conflict Resolution: NOTHING
  • Tuples Inserted: 0
  • Conflicting Tuples: 9
2. 0.103 0.874 ↓ 1.5 9 1

HashAggregate (cost=13.03..13.09 rows=6 width=96) (actual time=0.825..0.874 rows=9 loops=1)

  • Group Key: cass_all.url, ('decision'::text), ('decisions__cass_all'::text)
3.          

CTE all_decisions

4. 0.155 0.374 ↑ 1.0 9 1

Hash Join (cost=1.20..11.51 rows=9 width=61) (actual time=0.191..0.374 rows=9 loops=1)

  • Hash Cond: ((decisions_aggregated.reference_doc_id)::text = all_decisions_indexable.reference_doc_id)
5. 0.105 0.105 ↑ 1.1 18 1

Seq Scan on decisions_aggregated (cost=0.00..10.20 rows=20 width=68) (actual time=0.017..0.105 rows=18 loops=1)

6. 0.057 0.114 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=39) (actual time=0.110..0.114 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.057 0.057 ↑ 1.0 9 1

Seq Scan on all_decisions_indexable (cost=0.00..1.09 rows=9 width=39) (actual time=0.008..0.057 rows=9 loops=1)

8.          

CTE cass_all

9. 0.442 0.442 ↓ 2.0 2 1

CTE Scan on all_decisions (cost=0.00..0.20 rows=1 width=72) (actual time=0.202..0.442 rows=2 loops=1)

  • Filter: ((juridiction)::text = 'CASS'::text)
  • Rows Removed by Filter: 7
10.          

CTE ce_all

11. 0.019 0.019 ↑ 1.0 1 1

CTE Scan on all_decisions all_decisions_1 (cost=0.00..0.20 rows=1 width=72) (actual time=0.009..0.019 rows=1 loops=1)

  • Filter: ((juridiction)::text = 'CE'::text)
  • Rows Removed by Filter: 8
12.          

CTE constit_all

13. 0.015 0.015 ↑ 1.0 1 1

CTE Scan on all_decisions all_decisions_2 (cost=0.00..0.20 rows=1 width=72) (actual time=0.006..0.015 rows=1 loops=1)

  • Filter: ((juridiction)::text = 'CONSTIT'::text)
  • Rows Removed by Filter: 8
14.          

CTE all_2018

15. 0.018 0.018 ↓ 2.0 2 1

CTE Scan on all_decisions all_decisions_3 (cost=0.00..0.20 rows=1 width=72) (actual time=0.004..0.018 rows=2 loops=1)

  • Filter: (date = '2018'::double precision)
  • Rows Removed by Filter: 7
16.          

CTE ca_2019

17. 0.016 0.016 ↑ 1.0 1 1

CTE Scan on all_decisions all_decisions_4 (cost=0.00..0.23 rows=1 width=72) (actual time=0.006..0.016 rows=1 loops=1)

  • Filter: (((juridiction)::text = 'CA'::text) AND (date = '2019'::double precision))
  • Rows Removed by Filter: 8
18.          

CTE ta_2016_2017

19. 0.021 0.021 ↓ 2.0 2 1

CTE Scan on all_decisions all_decisions_5 (cost=0.00..0.23 rows=1 width=72) (actual time=0.007..0.021 rows=2 loops=1)

  • Filter: ((date = ANY ('{2016,2017}'::double precision[])) AND ((juridiction)::text = 'TA'::text))
  • Rows Removed by Filter: 7
20. 0.096 0.771 ↓ 1.5 9 1

Append (cost=0.00..0.21 rows=6 width=96) (actual time=0.222..0.771 rows=9 loops=1)

21. 0.471 0.471 ↓ 2.0 2 1

CTE Scan on cass_all (cost=0.00..0.02 rows=1 width=96) (actual time=0.212..0.471 rows=2 loops=1)

22. 0.035 0.035 ↑ 1.0 1 1

CTE Scan on constit_all (cost=0.00..0.02 rows=1 width=96) (actual time=0.016..0.035 rows=1 loops=1)

23. 0.038 0.038 ↑ 1.0 1 1

CTE Scan on ce_all (cost=0.00..0.02 rows=1 width=96) (actual time=0.019..0.038 rows=1 loops=1)

24. 0.036 0.036 ↑ 1.0 1 1

CTE Scan on ca_2019 (cost=0.00..0.02 rows=1 width=96) (actual time=0.016..0.036 rows=1 loops=1)

25. 0.046 0.046 ↓ 2.0 2 1

CTE Scan on all_2018 (cost=0.00..0.02 rows=1 width=96) (actual time=0.014..0.046 rows=2 loops=1)

26. 0.049 0.049 ↓ 2.0 2 1

CTE Scan on ta_2016_2017 (cost=0.00..0.02 rows=1 width=96) (actual time=0.016..0.049 rows=2 loops=1)

Planning time : 1.277 ms
Execution time : 1.355 ms