#	exclusive	inclusive	rows x	rows	loops	node
1.	0.043	707.726	↑ 1.0	500	1	→ Limit (cost=0.56..78.76 rows=500 width=8) (actual time=646.673..707.726 rows=500 loops=1)
2.	707.683	707.683	↑ 27,614.9	500	1	→ Index Scan using party_id on merchant_parties (cost=0.56..2,159,512.61 rows=13,807,431 width=8) (actual time=646.672..707.683 rows=500 loops=1) Filter: (updated_at IS NULL) Rows Removed by Filter: 1,054,900

Planning time	:	0.112 ms
Execution time	:	707.769 ms

Limit  (cost=0.56..78.76 rows=500 width=8) (actual time=646.673..707.726 rows=500 loops=1)
  ->  Index Scan using party_id on merchant_parties  (cost=0.56..2159512.61 rows=13807431 width=8) (actual time=646.672..707.683 rows=500 loops=1)
        Filter: (updated_at IS NULL)
        Rows Removed by Filter: 1054900
Planning time: 0.112 ms
Execution time: 707.769 ms

Per node type stats

node type	count	sum of times	% of query
Index Scan	1	707.683 ms	100.0 %
Limit	1	0.043 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
merchant_parties	1	707.683 ms	100.0 %
Index Scan	1	707.683 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6ES

Color mode:

Visible columns:

Per node type stats

Per table stats