explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aRX4

Settings
# exclusive inclusive rows x rows loops node
1. 338.418 9,145.993 ↑ 1.0 10,000 1

Limit (cost=1,001.16..2,681,673.31 rows=10,000 width=8) (actual time=31.400..9,145.993 rows=10,000 loops=1)

2. 0.000 8,807.575 ↑ 11.7 10,000 1

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

  • Group Key: de.case_id
3. 0.000 9,122.361 ↑ 184.8 13,551 1

Gather Merge (cost=1,001.16..31,392,190.19 rows=2,503,574 width=8) (actual time=29.729..9,122.361 rows=13,551 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 392.077 20,592.105 ↑ 230.6 4,524 3

Nested Loop (cost=1.13..31,102,215.61 rows=1,043,156 width=8) (actual time=1.902..6,864.035 rows=4,524 loops=3)

5. 13,270.812 13,270.812 ↑ 118.1 288,717 3

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.204..4,423.604 rows=288,717 loops=3)

6. 6,929.216 6,929.216 ↓ 0.0 0 866,152

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.008..0.008 rows=0 loops=866,152)

  • Index Cond: ((docket_entry_id = de.id) AND (tag_id = 257))
  • Heap Fetches: 56
Planning time : 0.673 ms
Execution time : 9,148.837 ms