explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bj0

Settings
# exclusive inclusive rows x rows loops node
1. 0.614 1,453.798 ↑ 1.0 1,000 1

Limit (cost=1,001.16..269,068.37 rows=1,000 width=8) (actual time=2.115..1,453.798 rows=1,000 loops=1)

2. 2.681 1,453.184 ↑ 117.2 1,000 1

GroupAggregate (cost=1,001.16..31,405,879.59 rows=117,153 width=8) (actual time=2.112..1,453.184 rows=1,000 loops=1)

  • Group Key: de.case_id
3. 1.567 1,450.503 ↑ 1,559.9 1,605 1

Gather Merge (cost=1,001.16..31,392,190.19 rows=2,503,574 width=8) (actual time=0.729..1,450.503 rows=1,605 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
4. 94.465 1,448.936 ↑ 649.9 1,605 1

Nested Loop (cost=1.13..31,102,215.61 rows=1,043,156 width=8) (actual time=0.124..1,448.936 rows=1,605 loops=1)

5. 683.586 683.586 ↑ 254.1 134,177 1

Parallel Index Scan using ix_docket_entry_case_id on docket_entry de (cost=0.57..10,863,802.51 rows=34,092,407 width=12) (actual time=0.077..683.586 rows=134,177 loops=1)

6. 670.885 670.885 ↓ 0.0 0 134,177

Index Only Scan using positve_docket_tags_pkey on positve_docket_tags pdt (cost=0.56..0.59 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=134,177)

  • Index Cond: ((docket_entry_id = de.id) AND (tag_id = 257))
  • Heap Fetches: 0
Planning time : 0.969 ms
Execution time : 1,454.387 ms